modSupplierInvoice.class.php

Go to the documentation of this file.

<?php
/* Copyright (C) 2003       Rodolphe Quiedeville    <rodolphe@quiedeville.org>
 * Copyright (C) 2004-2015  Laurent Destailleur     <eldy@users.sourceforge.net>
 * Copyright (C) 2005-2012  Regis Houssin           <regis.houssin@inodbox.com>
 * Copyright (C) 2012       Juanjo Menent           <jmenent@2byte.es>
 * Copyright (C) 2013-2015  Philippe Grand          <philippe.grand@atoo-net.com>
 * Copyright (C) 2020       Ahmad Jamaly Rabib      <rabib@metroworks.co.jp>
 * Copyright (C) 2024-2026  MDW                     <mdeweerd@users.noreply.github.com>
 * Copyright (C) 2024-2026  Frédéric France         <frederic.france@free.fr>
 * Copyright (C) 2026       Alexandre Spangaro      <alexandre@inovea-conseil.com>
 *
 * This program is free software; you can redistribute it and/or modify
 * it under the terms of the GNU General Public License as published by
 * the Free Software Foundation; either version 3 of the License, or
 * (at your option) any later version.
 *
 * This program is distributed in the hope that it will be useful,
 * but WITHOUT ANY WARRANTY; without even the implied warranty of
 * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
 * GNU General Public License for more details.
 *
 * You should have received a copy of the GNU General Public License
 * along with this program. If not, see <https://www.gnu.org/licenses/>.
 */
 
include_once DOL_DOCUMENT_ROOT . '/core/modules/DolibarrModules.class.php';
 
 
class modSupplierInvoice extends DolibarrModules
{
  public function __construct($db)
  {
    global $conf, $langs, $user, $mysoc;
 
    $this->db = $db;
    $this->numero = 41;
 
    // Family can be 'crm','financial','hr','projects','product','ecm','technic','other'
    // It is used to group modules in module setup page
    $this->family = "srm";
    $this->module_position = '13';
    // Module label (no space allowed), used if translation string 'ModuleXXXName' not found (where XXX is value of numeric property 'numero' of module)
    $this->name = preg_replace('/^mod/i', '', get_class($this));
    $this->description = "Manage supplier invoice";
 
    // Possible values for version are: 'development', 'experimental', 'dolibarr' or version
    $this->version = 'dolibarr';
    $this->hidden = !getDolGlobalString('MAIN_USE_NEW_SUPPLIERMOD');
 
    $this->const_name = 'MAIN_MODULE_' . strtoupper($this->name);
    $this->picto = 'supplier_invoice';
 
    // Data directories to create when module is enabled
    $this->dirs = array(
      "/fournisseur/temp",
      "/fournisseur/facture",
      "/fournisseur/facture/temp"
    );
 
    // Dependencies
    $this->depends = array("modSociete");
    $this->requiredby = array("modSupplierProposal");
    $this->langfiles = array('bills', 'companies', 'suppliers', 'orders', 'sendings');
 
    // Config pages
    $this->config_page_url = array("supplier_invoice.php@supplier_invoice");
 
    // Constants
    $this->const = [
      // For supplier invoice, we must not have default pdf template on. In most cases, we need to join PDF from supplier, not have a document generated.
      // [
      //  "INVOICE_SUPPLIER_ADDON_PDF",
      //  "chaine",
      //  "canelle",
      //  'Name of the generator for PDF supplier invoices',
      //  0,
      // ],
      [
        "INVOICE_SUPPLIER_ADDON_NUMBER",
        "chaine",
        "mod_facture_fournisseur_cactus",
        "Name of the supplier invoice numbering manager",
        0,
      ],
      // Add ability ODT for Supplier Invoices
      [
        "SUPPLIER_INVOICE_ADDON_PDF_ODT_PATH",
        "chaine",
        "DOL_DATA_ROOT" . ($conf->entity > 1 ? '/' . $conf->entity : '') . "/doctemplates/supplier_invoices",
        "",
        0,
      ],
    ];
 
    // Boxes
    $this->boxes = [
      ['file' => 'box_graph_invoices_supplier_permonth.php', 'enabledbydefaulton' => 'Home'],
      ['file' => 'box_fournisseurs.php', 'enabledbydefaulton' => 'Home'],
      ['file' => 'box_factures_fourn_imp.php', 'enabledbydefaulton' => 'Home'],
      ['file' => 'box_factures_fourn.php', 'enabledbydefaulton' => 'Home'],
    ];
 
    $arraydate = dol_getdate(dol_now());
    $datestart = dol_mktime(23, 0, 0, $arraydate['mon'], $arraydate['mday'], $arraydate['year']);
    $this->cronjobs = array(
      0 => array(
        'label' => 'RecurringSupplierInvoicesJob',
        'jobtype' => 'method',
        'class' => 'fourn/class/fournisseur.facture-rec.class.php',
        'objectname' => 'FactureFournisseurRec',
        'method' => 'createRecurringInvoices',
        'parameters' => '',
        'comment' => 'Generate recurring supplier invoices',
        'frequency' => 1,
        'unitfrequency' => 3600 * 24,
        'priority' => 51,
        'status' => 1,
        'test' => 'isModEnabled("supplier_invoice")',
        'datestart' => $datestart
      ),
      1 => array(
        'label' => 'SendEmailsRemindersOnSupplierInvoiceDueDate',
        'jobtype' => 'method',
        'class' => 'fourn/class/fournisseur.facture.class.php',
        'objectname' => 'FactureFournisseur',
        'method' => 'sendEmailsRemindersOnSupplierInvoiceDueDate',
        'parameters' => '10,all,EmailTemplateCode,duedate',
        'comment' => 'Send an email when we reach the supplier invoice due date (or supplier invoice date) - n days. First param is n, the number of days before due date (or supplier invoice date) to send the remind (or after if value is negative), second parameter is "all" or a payment mode code, third parameter is the code of the email template to use (an email template with the EmailTemplateCode must exists. The version of the email template in the language of the thirdparty will be used in priority. Language of the thirdparty will be also used to update the PDF of the sent supplier invoice). The fourth parameter is the string "duedate" (default) or "invoicedate" to define which date of the supplier invoice to use.',
        'frequency' => 1,
        'unitfrequency' => 3600 * 24,
        'priority' => 50,
        'status' => 0,
        'test' => 'isModEnabled("supplier_invoice")',
        'datestart' => $datestart
      )
    );
 
 
    // Permissions
    $this->rights = array();
    $this->rights_class = 'supplier_invoice';
    $r = 0;
 
    $r++;
    $this->rights[$r][0] = 1171;
    $this->rights[$r][1] = 'Consulter les factures fournisseur';
    $this->rights[$r][2] = 'r';
    $this->rights[$r][3] = 0;
    $this->rights[$r][4] = 'lire';
 
    $r++;
    $this->rights[$r][0] = 1172;
    $this->rights[$r][1] = 'Creer une facture fournisseur';
    $this->rights[$r][2] = 'w';
    $this->rights[$r][3] = 0;
    $this->rights[$r][4] = 'creer';
 
    $r++;
    $this->rights[$r][0] = 1173;
    $this->rights[$r][1] = 'Valider une facture fournisseur';
    $this->rights[$r][2] = 'w';
    $this->rights[$r][3] = 0;
    $this->rights[$r][4] = 'supplier_invoice_advance';
    $this->rights[$r][5] = 'validate';
 
    $r++;
    $this->rights[$r][0] = 1174;
    $this->rights[$r][1] = 'Supprimer une facture fournisseur';
    $this->rights[$r][2] = 'd';
    $this->rights[$r][3] = 0;
    $this->rights[$r][4] = 'supprimer';
 
    $r++;
    $this->rights[$r][0] = 1175;
    $this->rights[$r][1] = 'Envoyer les factures par mail';
    $this->rights[$r][2] = 'a';
    $this->rights[$r][3] = 0;
    $this->rights[$r][4] = 'supplier_invoice_advance';
    $this->rights[$r][5] = 'send';
 
    $r++;
    $this->rights[$r][0] = 1176;
    $this->rights[$r][1] = 'Exporter les factures fournisseurs, attributes et reglements';
    $this->rights[$r][2] = 'r';
    $this->rights[$r][3] = 0;
    $this->rights[$r][4] = 'export';
 
 
    // Menus
    //-------
    $this->menu = 1; // This module add menu entries. They are coded into menu manager.
 
 
    // Exports
    //--------
    $uselocaltax1 = (is_object($mysoc) && $mysoc->localtax1_assuj) ? $mysoc->localtax1_assuj : 0;
    $uselocaltax2 = (is_object($mysoc) && $mysoc->localtax2_assuj) ? $mysoc->localtax2_assuj : 0;
 
    $r = 0;
 
    $langs->loadLangs(array("suppliers", "compta", "multicurrency", "bills"));
 
    $alias_product_perentity = !getDolGlobalString('MAIN_PRODUCT_PERENTITY_SHARED') ? "p" : "ppe";
 
    $r++;
    $this->export_code[$r] = $this->rights_class . '_' . $r;
    $this->export_label[$r] = 'Vendor invoices and lines of invoices';
    $this->export_icon[$r] = 'invoice';
    $this->export_permission[$r] = array(array("fournisseur", "facture", "export"));
    $this->export_fields_array[$r] = array(
      's.rowid' => "IdCompany",
      's.nom' => 'CompanyName',
      'ps.nom' => 'ParentCompany',
      's.address' => 'Address',
      's.zip' => 'Zip',
      's.town' => 'Town',
      'c.code' => 'CountryCode',
      's.phone' => 'Phone',
      's.siren' => 'ProfId1',
      's.siret' => 'ProfId2',
      's.ape' => 'ProfId3',
      's.idprof4' => 'ProfId4',
      's.idprof5' => 'ProfId5',
      's.idprof6' => 'ProfId6',
      's.code_compta' => 'CustomerAccountancyCode',
      's.code_compta_fournisseur' => 'SupplierAccountancyCode',
      's.tva_intra' => 'VATIntra',
      'f.rowid' => "InvoiceId",
      'f.ref' => "InvoiceRef",
      'f.ref_supplier' => "RefSupplier",
      'f.datec' => "InvoiceDateCreation",
      'f.datef' => "DateInvoice",
      'f.date_lim_reglement' => 'DateMaxPayment',
      'f.fk_cond_reglement' => 'IdPaymentTerm',
      'f.fk_mode_reglement' => 'IdPaymentMode',
      'f.total_ht' => "TotalHT",
      'f.total_ttc' => "TotalTTC",
      'f.total_tva' => "TotalVAT",
      'f.localtax1' => "TotalLT1",
      'f.localtax2' => "TotalLT2",
      'f.paye' => "InvoicePaid",
      'f.fk_statut' => 'InvoiceStatus',
      'f.note_public' => "InvoiceNote",
      'fd.rowid' => 'LineId',
      'fd.description' => "LineDescription",
      'fd.qty' => "LineQty",
      'fd.remise_percent' => "Discount",
      'fd.tva_tx' => "LineVATRate",
      'fd.total_ht' => "LineTotalHT",
      'fd.total_ttc' => "LineTotalTTC",
      'fd.tva' => "LineTotalVAT",
      'fd.localtax1_tx' => "LineLT1Rate",
      'fd.localtax1_type' => "LineLT1Type",
      'fd.total_localtax1' => "LineTotalLT1",
      'fd.localtax2_tx' => "LineLT2Rate",
      'fd.localtax2_type' => "LineLT2Type",
      'fd.total_localtax2' => "LineTotalLT2",
      'fd.date_start' => "DateStart",
      'fd.date_end' => "DateEnd",
      'fd.special_code' => 'SpecialCode',
      'fd.product_type' => 'TypeOfLineServiceOrProduct',
      'fd.fk_product' => 'ProductId',
      'p.ref' => 'ProductRef',
      'p.label' => 'ProductLabel',
      $alias_product_perentity . '.accountancy_code_buy' => 'ProductAccountancyBuyCode',
      'project.rowid' => 'ProjectId',
      'project.ref' => 'ProjectRef',
      'project.title' => 'ProjectLabel'
    );
    if (!$uselocaltax1) {
      unset($this->export_fields_array[$r]['fd.localtax1_tx']);
      unset($this->export_fields_array[$r]['fd.localtax1_type']);
      unset($this->export_fields_array[$r]['fd.total_localtax1']);
    }
    if (!$uselocaltax2) {
      unset($this->export_fields_array[$r]['fd.localtax2_tx']);
      unset($this->export_fields_array[$r]['fd.localtax2_type']);
      unset($this->export_fields_array[$r]['fd.total_localtax2']);
    }
 
    if (isModEnabled("multicurrency")) {
      $this->export_fields_array[$r]['f.multicurrency_code'] = 'Currency';
      $this->export_fields_array[$r]['f.multicurrency_tx'] = 'CurrencyRate';
      $this->export_fields_array[$r]['f.multicurrency_total_ht'] = 'MulticurrencyAmountHT';
      $this->export_fields_array[$r]['f.multicurrency_total_tva'] = 'MulticurrencyAmountVAT';
      $this->export_fields_array[$r]['f.multicurrency_total_ttc'] = 'MulticurrencyAmountTTC';
    }
    if (!$uselocaltax1) {
      unset($this->export_fields_array[$r]['f.localtax1']);
    }
    if (!$uselocaltax2) {
      unset($this->export_fields_array[$r]['f.localtax2']);
    }
 
    //$this->export_TypeFields_array[$r]=array(
    //    's.rowid'=>"Numeric",'s.nom'=>'Text','s.address'=>'Text','s.zip'=>'Text','s.town'=>'Text','c.code'=>'Text','s.phone'=>'Text','s.siren'=>'Text','s.siret'=>'Text',
    //    's.ape'=>'Text','s.idprof4'=>'Text','s.tva_intra'=>'Text','f.ref'=>"Text",'f.datec'=>"Date",'f.datef'=>"Date",'f.total_ht'=>"Numeric",'f.total_ttc'=>"Numeric",'f.total_tva'=>"Numeric",
    //    'f.paye'=>"Boolean",'f.fk_statut'=>'Status','f.note_public'=>"Text",'fd.description'=>"Text",'fd.tva_tx'=>"Text",'fd.qty'=>"Numeric",'fd.total_ht'=>"Numeric",'fd.total_ttc'=>"Numeric",
    //     'fd.tva'=>"Numeric",'fd.product_type'=>'Numeric','fd.fk_product'=>'List:product:label','p.ref'=>'Text','p.label'=>'Text'
    //);
    $this->export_TypeFields_array[$r] = array(
      's.rowid' => 'Numeric',
      's.nom' => 'Text',
      'ps.nom' => 'Text',
      's.address' => 'Text',
      's.zip' => 'Text',
      's.town' => 'Text',
      'c.code' => 'Text',
      's.phone' => 'Text',
      's.siren' => 'Text',
      's.siret' => 'Text',
      's.ape' => 'Text',
      's.idprof4' => 'Text',
      's.idprof5' => 'Text',
      's.idprof6' => 'Text',
      's.code_compta' => 'Text',
      's.code_compta_fournisseur' => 'Text',
      's.tva_intra' => 'Text',
      'f.rowid' => 'Numeric',
      'f.ref' => "Text",
      'f.ref_supplier' => "Text",
      'f.datec' => "Date",
      'f.datef' => "Date",
      'f.date_lim_reglement' => 'Date',
      'f.fk_cond_reglement' => 'Numeric',
      'f.fk_mode_reglement' => 'Numeric',
      'f.total_ht' => "Numeric",
      'f.total_ttc' => "Numeric",
      'f.total_tva' => "Numeric",
      'f.localtax1' => "Numeric",
      'f.localtax2' => "Numeric",
      'f.paye' => "Boolean",
      'f.fk_statut' => 'Status',
      'f.note_public' => "Text",
      'fd.rowid' => 'Numeric',
      'fd.description' => "Text",
      'fd.tva_tx' => "Text",
      'fd.qty' => "Numeric",
      'fd.remise_percent' => "Numeric",
      'fd.total_ht' => "Numeric",
      'fd.total_ttc' => "Numeric",
      'fd.tva' => "Numeric",
      'fd.total_localtax1' => "Numeric",
      'fd.total_localtax2' => "Numeric",
      'fd.localtax1_tx' => 'Numeric',
      'fd.localtax2_tx' => 'Numeric',
      'fd.localtax1_type' => 'Numeric',
      'fd.localtax2_type' => 'Numeric',
      'fd.date_start' => "Date",
      'fd.date_end' => "Date",
      'fd.special_code' => "Numeric",
      'fd.product_type' => 'Numeric',
      'fd.fk_product' => 'List:product:label',
      $alias_product_perentity . '.accountancy_code_buy' => 'Text',
      'p.ref' => 'Text',
      'p.label' => 'Text',
      'project.ref' => 'Text',
      'project.title' => 'Text',
      'f.multicurrency_code' => 'Text',
      'f.multicurrency_tx' => 'Number',
      'f.multicurrency_total_ht' => 'Number',
      'f.multicurrency_total_tva' => 'Number',
      'f.multicurrency_total_ttc' => 'Number'
    );
    $this->export_entities_array[$r] = array(
      's.rowid' => "company",
      's.nom' => 'company',
      'ps.nom' => 'company',
      's.address' => 'company',
      's.zip' => 'company',
      's.town' => 'company',
      'c.code' => 'company',
      's.phone' => 'company',
      's.siren' => 'company',
      's.siret' => 'company',
      's.ape' => 'company',
      's.idprof4' => 'company',
      's.idprof5' => 'company',
      's.idprof6' => 'company',
      's.code_compta' => 'company',
      's.code_compta_fournisseur' => 'company',
      's.tva_intra' => 'company',
      'f.rowid' => "invoice",
      'f.ref' => "invoice",
      'f.ref_supplier' => "invoice",
      'f.datec' => "invoice",
      'f.datef' => "invoice",
      'f.date_lim_reglement' => 'invoice',
      'f.fk_cond_reglement' => 'invoice',
      'f.fk_mode_reglement' => 'invoice',
      'f.total_ht' => "invoice",
      'f.total_ttc' => "invoice",
      'f.total_tva' => "invoice",
      'f.paye' => "invoice",
      'f.fk_statut' => 'invoice',
      'f.note_public' => "invoice",
      'fd.rowid' => 'invoice_line',
      'fd.description' => "invoice_line",
      'fd.qty' => "invoice_line",
      'fd.total_ht' => "invoice_line",
      'fd.tva' => "invoice_line",
      'fd.total_ttc' => "invoice_line",
      'fd.total_localtax1' => "invoice_line",
      'fd.total_localtax2' => "invoice_line",
      'fd.tva_tx' => "invoice_line",
      'fd.localtax1_tx' => "invoice_line",
      'fd.localtax2_tx' => "invoice_line",
      'fd.localtax1_type' => "invoice_line",
      'fd.localtax2_type' => "invoice_line",
      'fd.remise_percent' => "invoice_line",
      'fd.date_start' => "invoice_line",
      'fd.date_end' => "invoice_line",
      'fd.special_code' => "invoice_line",
      'fd.product_type' => 'invoice_line',
      'fd.fk_product' => 'product',
      'p.ref' => 'product',
      'p.label' => 'product',
      $alias_product_perentity . '.accountancy_code_buy' => 'product',
      'project.rowid' => 'project',
      'project.ref' => 'project',
      'project.title' => 'project'
    );
    $this->export_dependencies_array[$r] = array('invoice_line' => 'fd.rowid', 'product' => 'fd.rowid'); // To add unique key if we ask a field of a child to avoid the DISTINCT to discard them
    // Add extra fields object
    $keyforselect = 'facture_fourn';
    $keyforelement = 'invoice';
    $keyforaliasextra = 'extra';
    include DOL_DOCUMENT_ROOT . '/core/extrafieldsinexport.inc.php';
    $keyforselect = 'facture_fourn_det';
    $keyforelement = 'invoice_line';
    $keyforaliasextra = 'extraline';
    include DOL_DOCUMENT_ROOT . '/core/extrafieldsinexport.inc.php';
    // End add extra fields line
    $this->export_sql_start[$r] = 'SELECT DISTINCT ';
    $this->export_sql_end[$r] = ' FROM ' . MAIN_DB_PREFIX . 'societe as s';
    $this->export_sql_end[$r] .= ' LEFT JOIN ' . MAIN_DB_PREFIX . 'societe as ps ON ps.rowid = s.parent';
    if (is_object($user) && !$user->hasRight('societe', 'client', 'voir')) {
      $this->export_sql_end[$r] .= ' LEFT JOIN ' . MAIN_DB_PREFIX . 'societe_commerciaux as sc ON sc.fk_soc = s.rowid';
    }
    $this->export_sql_end[$r] .= ' LEFT JOIN ' . MAIN_DB_PREFIX . 'c_country as c ON s.fk_pays = c.rowid,';
    $this->export_sql_end[$r] .= ' ' . MAIN_DB_PREFIX . 'facture_fourn as f';
    $this->export_sql_end[$r] .= ' LEFT JOIN ' . MAIN_DB_PREFIX . 'projet as project on (f.fk_projet = project.rowid)';
    $this->export_sql_end[$r] .= ' LEFT JOIN ' . MAIN_DB_PREFIX . 'facture_fourn_extrafields as extra ON f.rowid = extra.fk_object';
    $this->export_sql_end[$r] .= ' LEFT JOIN ' . MAIN_DB_PREFIX . 'c_paiement as cp ON f.fk_mode_reglement = cp.id';
    $this->export_sql_end[$r] .= ' LEFT JOIN ' . MAIN_DB_PREFIX . 'c_payment_term as cpt ON f.fk_cond_reglement = cpt.rowid,';
    $this->export_sql_end[$r] .= ' ' . MAIN_DB_PREFIX . 'facture_fourn_det as fd';
    $this->export_sql_end[$r] .= ' LEFT JOIN ' . MAIN_DB_PREFIX . 'facture_fourn_det_extrafields as extraline ON fd.rowid = extraline.fk_object';
    $this->export_sql_end[$r] .= ' LEFT JOIN ' . MAIN_DB_PREFIX . 'product as p on (fd.fk_product = p.rowid)';
    $this->export_sql_end[$r] .= ' WHERE f.fk_soc = s.rowid AND f.rowid = fd.fk_facture_fourn';
    $this->export_sql_end[$r] .= ' AND f.entity IN (' . getEntity('supplier_invoice') . ')';
    if (is_object($user) && !$user->hasRight('societe', 'client', 'voir')) {
      $this->export_sql_end[$r] .= ' AND sc.fk_user = ' . ((int) $user->id);
    }
 
    // Invoices and payments
    $r++;
    $this->export_code[$r] = $this->rights_class . '_' . $r;
    $this->export_label[$r] = 'Factures fournisseurs et reglements';
    $this->export_icon[$r] = 'invoice';
    $this->export_permission[$r] = array(array("fournisseur", "facture", "export"));
    $this->export_fields_array[$r] = array(
      's.rowid' => "IdCompany",
      's.nom' => 'CompanyName',
      's.address' => 'Address',
      's.zip' => 'Zip',
      's.town' => 'Town',
      'c.code' => 'CountryCode',
      's.phone' => 'Phone',
      's.siren' => 'ProfId1',
      's.siret' => 'ProfId2',
      's.ape' => 'ProfId3',
      's.idprof4' => 'ProfId4',
      's.idprof5' => 'ProfId5',
      's.idprof6' => 'ProfId6',
      's.code_compta' => 'CustomerAccountancyCode',
      's.code_compta_fournisseur' => 'SupplierAccountancyCode',
      's.tva_intra' => 'VATIntra',
      'f.rowid' => "InvoiceId",
      'f.ref' => "InvoiceRef",
      'f.ref_supplier' => "RefSupplier",
      'f.datec' => "InvoiceDateCreation",
      'f.datef' => "DateInvoice",
      'f.date_lim_reglement' => "DateMaxPayment",
      'f.fk_cond_reglement' => 'IdPaymentTerm',
      'f.fk_mode_reglement' => 'IdPaymentMode',
      'f.total_ht' => "TotalHT",
      'f.total_ttc' => "TotalTTC",
      'f.total_tva' => "TotalVAT",
      'f.localtax1' => "TotalLT1",
      'f.localtax2' => "TotalLT2",
      'f.paye' => "InvoicePaid",
      'f.fk_statut' => 'InvoiceStatus',
      'f.note_public' => "InvoiceNote",
      'p.rowid' => 'PaymentId',
      'pf.amount' => 'AmountPayment',
      'p.datep' => 'DatePayment',
      'p.num_paiement' => 'PaymentNumber',
      'p.fk_bank' => 'IdTransaction',
      'project.rowid' => 'ProjectId',
      'project.ref' => 'ProjectRef',
      'project.title' => 'ProjectLabel'
    );
    if (!$uselocaltax1) {
      unset($this->export_fields_array[$r]['f.localtax1']);
    }
    if (!$uselocaltax2) {
      unset($this->export_fields_array[$r]['f.localtax2']);
    }
    if (isModEnabled("multicurrency")) {
      $this->export_fields_array[$r]['f.multicurrency_code'] = 'Currency';
      $this->export_fields_array[$r]['f.multicurrency_tx'] = 'CurrencyRate';
      $this->export_fields_array[$r]['f.multicurrency_total_ht'] = 'MulticurrencyAmountHT';
      $this->export_fields_array[$r]['f.multicurrency_total_tva'] = 'MulticurrencyAmountVAT';
      $this->export_fields_array[$r]['f.multicurrency_total_ttc'] = 'MulticurrencyAmountTTC';
    }
    //$this->export_TypeFields_array[$r]=array(
    //  's.rowid'=>"Numeric",'s.nom'=>'Text','s.address'=>'Text','s.zip'=>'Text','s.town'=>'Text','c.code'=>'Text','s.phone'=>'Text',
    //  's.siren'=>'Text','s.siret'=>'Text','s.ape'=>'Text','s.idprof4'=>'Text','s.tva_intra'=>'Text','f.ref'=>"Text",'f.datec'=>"Date",'f.datef'=>"Date",
    //  'f.total_ht'=>"Numeric",'f.total_ttc'=>"Numeric",'f.total_tva'=>"Numeric",'f.paye'=>"Boolean",'f.fk_statut'=>'Status','f.note_public'=>"Text",
    //  'pf.amount'=>'Numeric','p.datep'=>'Date','p.num_paiement'=>'Numeric'
    //);
    $this->export_TypeFields_array[$r] = array(
      's.rowid' => 'Numeric',
      's.nom' => 'Text',
      's.address' => 'Text',
      's.zip' => 'Text',
      's.town' => 'Text',
      'c.code' => 'Text',
      's.phone' => 'Text',
      's.siren' => 'Text',
      's.siret' => 'Text',
      's.ape' => 'Text',
      's.idprof4' => 'Text',
      's.idprof5' => 'Text',
      's.idprof6' => 'Text',
      's.code_compta' => 'Text',
      's.code_compta_fournisseur' => 'Text',
      's.tva_intra' => 'Text',
      'f.rowid' => 'Numeric',
      'f.ref' => "Text",
      'f.ref_supplier' => "Text",
      'f.datec' => "Date",
      'f.datef' => "Date",
      'f.date_lim_reglement' => 'Date',
      'f.fk_cond_reglement' => 'Numeric',
      'f.fk_mode_reglement' => 'Numeric',
      'f.total_ht' => "Numeric",
      'f.total_ttc' => "Numeric",
      'f.total_tva' => "Numeric",
      'f.localtax1' => "Numeric",
      'f.localtax2' => "Numeric",
      'f.paye' => "Boolean",
      'f.fk_statut' => 'Status',
      'f.note_public' => "Text",
      'pf.amount' => 'Numeric',
      'p.rowid' => 'Numeric',
      'p.datep' => 'Date',
      'p.num_paiement' => 'Numeric',
      'p.fk_bank' => 'Numeric',
      'project.rowid' => 'Numeric',
      'project.ref' => 'Text',
      'project.title' => 'Text',
      'f.multicurrency_code' => 'Text',
      'f.multicurrency_tx' => 'Number',
      'f.multicurrency_total_ht' => 'Number',
      'f.multicurrency_total_tva' => 'Number',
      'f.multicurrency_total_ttc' => 'Number'
    );
    $this->export_entities_array[$r] = array(
      's.rowid' => "company",
      's.nom' => 'company',
      's.address' => 'company',
      's.zip' => 'company',
      's.town' => 'company',
      'c.code' => 'company',
      's.phone' => 'company',
      's.siren' => 'company',
      's.siret' => 'company',
      's.ape' => 'company',
      's.idprof4' => 'company',
      's.idprof5' => 'company',
      's.idprof6' => 'company',
      's.code_compta' => 'company',
      's.code_compta_fournisseur' => 'company',
      's.tva_intra' => 'company',
      'f.rowid' => "invoice",
      'f.ref' => "invoice",
      'f.ref_supplier' => "invoice",
      'f.datec' => "invoice",
      'f.datef' => "invoice",
      'f.date_lim_reglement' => 'invoice',
      'f.fk_cond_reglement' => 'invoice',
      'f.fk_mode_reglement' => 'invoice',
      'f.total_ht' => "invoice",
      'f.total_ttc' => "invoice",
      'f.total_tva' => "invoice",
      'f.paye' => "invoice",
      'f.fk_statut' => 'invoice',
      'f.note_public' => "invoice",
      'p.rowid' => 'payment',
      'pf.amount' => 'payment',
      'p.datep' => 'payment',
      'p.num_paiement' => 'payment',
      'p.fk_bank' => 'account',
      'project.rowid' => 'project',
      'project.ref' => 'project',
      'project.title' => 'project'
    );
    $this->export_dependencies_array[$r] = array('payment' => 'p.rowid'); // To add unique key if we ask a field of a child to avoid the DISTINCT to discard them
    // Add extra fields object
    $keyforselect = 'facture_fourn';
    $keyforelement = 'invoice';
    $keyforaliasextra = 'extra';
    include DOL_DOCUMENT_ROOT . '/core/extrafieldsinexport.inc.php';
    // End add extra fields object
    $this->export_sql_start[$r] = 'SELECT DISTINCT ';
    $this->export_sql_end[$r] = ' FROM ' . MAIN_DB_PREFIX . 'societe as s';
    if (is_object($user) && !$user->hasRight('societe', 'client', 'voir')) {
      $this->export_sql_end[$r] .= ' LEFT JOIN ' . MAIN_DB_PREFIX . 'societe_commerciaux as sc ON sc.fk_soc = s.rowid';
    }
    $this->export_sql_end[$r] .= ' LEFT JOIN ' . MAIN_DB_PREFIX . 'c_country as c ON s.fk_pays = c.rowid,';
    $this->export_sql_end[$r] .= ' ' . MAIN_DB_PREFIX . 'facture_fourn as f';
    $this->export_sql_end[$r] .= ' LEFT JOIN ' . MAIN_DB_PREFIX . 'projet as project on (f.fk_projet = project.rowid)';
    $this->export_sql_end[$r] .= ' LEFT JOIN ' . MAIN_DB_PREFIX . 'facture_fourn_extrafields as extra ON f.rowid = extra.fk_object';
    $this->export_sql_end[$r] .= ' LEFT JOIN ' . MAIN_DB_PREFIX . 'paiementfourn_facturefourn as pf ON pf.fk_facturefourn = f.rowid';
    $this->export_sql_end[$r] .= ' LEFT JOIN ' . MAIN_DB_PREFIX . 'paiementfourn as p ON pf.fk_paiementfourn = p.rowid';
    $this->export_sql_end[$r] .= ' LEFT JOIN ' . MAIN_DB_PREFIX . 'c_paiement as cp ON f.fk_mode_reglement = cp.id';
    $this->export_sql_end[$r] .= ' LEFT JOIN ' . MAIN_DB_PREFIX . 'c_payment_term as cpt ON f.fk_cond_reglement = cpt.rowid';
    $this->export_sql_end[$r] .= ' WHERE f.fk_soc = s.rowid';
    $this->export_sql_end[$r] .= ' AND f.entity IN (' . getEntity('supplier_invoice') . ')';
    if (is_object($user) && !$user->hasRight('societe', 'client', 'voir')) {
      $this->export_sql_end[$r] .= ' AND sc.fk_user = ' . ((int) $user->id);
    }
 
    // Import Supplier Invoice
    //--------
    $r = 0;
 
    $r++;
    $this->import_code[$r] = $this->rights_class . '_' . $r;
    $this->import_label[$r] = "SupplierInvoices"; // Translation key
    $this->import_icon[$r] = 'supplier_invoice';
    $this->import_entities_array[$r] = array(); // We define here only fields that use another icon that the one defined into import_icon
    $this->import_tables_array[$r] = array('f' => MAIN_DB_PREFIX . 'facture_fourn', 'extra' => MAIN_DB_PREFIX . 'facture_fourn_extrafields');
    $this->import_tables_creator_array[$r] = array('f' => 'fk_user_author'); // Fields to store import user id
    $this->import_fields_array[$r] = array(
      'f.ref' => 'InvoiceRef*',
      'f.ref_supplier' => 'RefSupplier',
      'f.type' => 'Type*',
      'f.fk_soc' => 'Supplier/Vendor*',
      'f.datec' => 'InvoiceDateCreation',
      'f.datef' => 'DateInvoice',
      'f.date_lim_reglement' => 'DateMaxPayment',
      'f.total_ht' => 'TotalHT',
      'f.total_ttc' => 'TotalTTC',
      'f.total_tva' => 'TotalVAT',
      'f.paye' => 'InvoicePaid',
      'f.fk_statut' => 'InvoiceStatus',
      'f.fk_user_modif' => 'Modifier Id',
      'f.fk_user_valid' => 'Validator Id',
      'f.fk_facture_source' => 'Invoice Source Id',
      'f.fk_projet' => 'Project Id',
      'f.fk_account' => 'Bank Account*',
      'f.note_public' => 'InvoiceNote',
      'f.note_private' => 'NotePrivate',
      'f.fk_cond_reglement' => 'PaymentTerm',
      'f.fk_mode_reglement' => 'PaymentMode',
      'f.model_pdf' => 'Model',
      'f.date_valid' => 'DateValidation'
    );
    if (isModEnabled("multicurrency")) {
      $this->import_fields_array[$r]['f.multicurrency_code'] = 'Currency';
      $this->import_fields_array[$r]['f.multicurrency_tx'] = 'CurrencyRate';
      $this->import_fields_array[$r]['f.multicurrency_total_ht'] = 'MulticurrencyAmountHT';
      $this->import_fields_array[$r]['f.multicurrency_total_tva'] = 'MulticurrencyAmountVAT';
      $this->import_fields_array[$r]['f.multicurrency_total_ttc'] = 'MulticurrencyAmountTTC';
    }
    // Add extra fields
    $import_extrafield_sample = array();
    $sql = "SELECT name, label, fieldrequired FROM " . MAIN_DB_PREFIX . "extrafields WHERE type <> 'separate' AND elementtype = 'facture_fourn' AND entity IN (0, " . $conf->entity . ")";
    $resql = $this->db->query($sql);
    if ($resql) {
      while ($obj = $this->db->fetch_object($resql)) {
        $fieldname = 'extra.' . $obj->name;
        $fieldlabel = ucfirst($obj->label);
        $this->import_fields_array[$r][$fieldname] = $fieldlabel . ($obj->fieldrequired ? '*' : '');
        $import_extrafield_sample[$fieldname] = $fieldlabel;
      }
    }
    // End add extra fields
    $this->import_fieldshidden_array[$r] = array('extra.fk_object' => 'lastrowid-' . MAIN_DB_PREFIX . 'facture_fourn');
    if (empty($conf->multicurrency->enabled)) {
      $this->import_fieldshidden_array[$r]['f.multicurrency_code'] = 'const-' . $conf->currency;
    }
    $this->import_regex_array[$r] = array('f.multicurrency_code' => 'code@' . MAIN_DB_PREFIX . 'multicurrency');
    $import_sample = array(
      'f.ref' => '(PROV001)',
      'f.ref_supplier' => 'Supplier1',
      'f.type' => '0',
      'f.fk_soc' => 'Vendor1',
      'f.datec' => '2021-01-01',
      'f.datef' => '',
      'f.date_lim_reglement' => '2021-01-30',
      'f.total_ht' => '1000',
      'f.total_ttc' => '1000',
      'f.total_tva' => '0',
      'f.paye' => '0',
      'f.fk_statut' => '0',
      'f.fk_user_modif' => '',
      'f.fk_user_valid' => '',
      'f.fk_facture_source' => '',
      'f.fk_projet' => '',
      'f.fk_account' => 'BANK1',
      'f.note_public' => 'Note: ',
      'f.note_private' => '',
      'f.fk_cond_reglement' => '1',
      'f.fk_mode_reglement' => '2',
      'f.model_pdf' => 'crab',
      'f.date_valid' => '',
      'f.multicurrency_code' => 'USD',
      'f.multicurrency_tx' => '1',
      'f.multicurrency_total_ht' => '1000',
      'f.multicurrency_total_tva' => '0',
      'f.multicurrency_total_ttc' => '1000'
    );
    $this->import_examplevalues_array[$r] = array_merge($import_sample, $import_extrafield_sample);
    $this->import_updatekeys_array[$r] = array('f.ref' => 'Ref');
    $this->import_convertvalue_array[$r] = array(
      'f.ref' => array(
        'rule' => 'getrefifauto',
        'class' => (!getDolGlobalString('INVOICE_SUPPLIER_ADDON_NUMBER') ? 'mod_facture_fournisseur_cactus' : $conf->global->INVOICE_SUPPLIER_ADDON_NUMBER),
        'path' => "/core/modules/supplier_invoice/" . (!getDolGlobalString('INVOICE_SUPPLIER_ADDON_NUMBER') ? 'mod_facture_fournisseur_cactus' : $conf->global->INVOICE_SUPPLIER_ADDON_NUMBER) . '.php',
        'classobject' => 'FactureFournisseur',
        'pathobject' => '/fourn/class/fournisseur.facture.class.php',
      ),
      'f.fk_soc' => array('rule' => 'fetchidfromref', 'file' => '/societe/class/societe.class.php', 'class' => 'Societe', 'method' => 'fetch', 'element' => 'ThirdParty'),
      'f.fk_account' => array('rule' => 'fetchidfromref', 'file' => '/compta/bank/class/account.class.php', 'class' => 'Account', 'method' => 'fetch', 'element' => 'bank_account'),
    );
 
    // Import Supplier Invoice Lines
    $r++;
    $this->import_code[$r] = $this->rights_class . '_' . $r;
    $this->import_label[$r] = "SupplierInvoiceLines"; // Translation key
    $this->import_icon[$r] = 'supplier_invoice';
    $this->import_entities_array[$r] = array(); // We define here only fields that use another icon that the one defined into import_icon
    $this->import_tables_array[$r] = array('fd' => MAIN_DB_PREFIX . 'facture_fourn_det', 'extra' => MAIN_DB_PREFIX . 'facture_fourn_det_extrafields');
    $this->import_fields_array[$r] = array(
      'fd.fk_facture_fourn' => 'InvoiceRef*',
      'fd.fk_parent_line' => 'ParentLine',
      'fd.fk_product' => 'IdProduct',
      'fd.description' => 'LineDescription',
      'fd.pu_ht' => 'PriceUHT',
      'fd.pu_ttc' => 'PriceUTTC',
      'fd.qty' => 'LineQty',
      'fd.remise_percent' => 'Reduc.',
      'fd.vat_src_code' => 'Vat Source Code',
      'fd.product_type' => 'TypeOfLineServiceOrProduct',
      'fd.tva_tx' => 'LineVATRate',
      'fd.total_ht' => 'LineTotalHT',
      'fd.tva' => 'LineTotalVAT',
      'fd.total_ttc' => 'LineTotalTTC',
      'fd.date_start' => 'Start Date',
      'fd.date_end' => 'End Date',
      'fd.fk_unit' => 'Unit'
    );
    if (isModEnabled("multicurrency")) {
      $this->import_fields_array[$r]['fd.multicurrency_code'] = 'Currency';
      $this->import_fields_array[$r]['fd.multicurrency_subprice'] = 'CurrencyRate';
      $this->import_fields_array[$r]['fd.multicurrency_total_ht'] = 'MulticurrencyAmountHT';
      $this->import_fields_array[$r]['fd.multicurrency_total_tva'] = 'MulticurrencyAmountVAT';
      $this->import_fields_array[$r]['fd.multicurrency_total_ttc'] = 'MulticurrencyAmountTTC';
    }
    // Add extra fields
    $import_extrafield_sample = array();
    $sql = "SELECT name, label, fieldrequired FROM " . MAIN_DB_PREFIX . "extrafields WHERE type <> 'separate' AND elementtype = 'facture_fourn_det' AND entity IN (0, " . $conf->entity . ")";
    $resql = $this->db->query($sql);
    if ($resql) {
      while ($obj = $this->db->fetch_object($resql)) {
        $fieldname = 'extra.' . $obj->name;
        $fieldlabel = ucfirst($obj->label);
        $this->import_fields_array[$r][$fieldname] = $fieldlabel . ($obj->fieldrequired ? '*' : '');
        $import_extrafield_sample[$fieldname] = $fieldlabel;
      }
    }
    // End add extra fields
    $this->import_fieldshidden_array[$r] = array('extra.fk_object' => 'lastrowid-' . MAIN_DB_PREFIX . 'facture_fourn_det');
    $this->import_regex_array[$r] = array('fd.product_type' => '[0|1]$', 'fd.fk_product' => 'rowid@' . MAIN_DB_PREFIX . 'product', 'fd.multicurrency_code' => 'code@' . MAIN_DB_PREFIX . 'multicurrency');
    $import_sample = array(
      'fd.fk_facture_fourn' => '(PROV001)',
      'fd.fk_parent_line' => '',
      'fd.fk_product' => '',
      'fd.description' => 'Test Product',
      'fd.pu_ht' => '50000',
      'fd.pu_ttc' => '50000',
      'fd.qty' => '1',
      'fd.remise_percent' => '0',
      'fd.vat_src_code' => '',
      'fd.product_type' => '0',
      'fd.tva_tx' => '0',
      'fd.total_ht' => '50000',
      'fd.tva' => '0',
      'fd.total_ttc' => '50000',
      'fd.date_start' => '',
      'fd.date_end' => '',
      'fd.fk_unit' => '',
      'fd.multicurrency_code' => 'USD',
      'fd.multicurrency_tx' => '0',
      'fd.multicurrency_total_ht' => '50000',
      'fd.multicurrency_total_tva' => '0',
      'fd.multicurrency_total_ttc' => '50000'
    );
    $this->import_examplevalues_array[$r] = array_merge($import_sample, $import_extrafield_sample);
    $this->import_updatekeys_array[$r] = array('fd.rowid' => 'Row Id', 'fd.fk_facture_fourn' => 'Invoice Id', 'fd.fk_product' => 'Product Id');
    $this->import_convertvalue_array[$r] = array(
      'fd.fk_facture_fourn' => array('rule' => 'fetchidfromref', 'file' => '/fourn/class/fournisseur.facture.class.php', 'class' => 'FactureFournisseur', 'method' => 'fetch'),
    );
  }
 
 
  public function init($options = '')
  {
    global $conf, $langs;
 
    $this->remove($options);
 
    $src = DOL_DOCUMENT_ROOT . '/install/doctemplates/supplier_invoices/template_supplier_invoices.odt';
    $dirodt = DOL_DATA_ROOT . ($conf->entity > 1 ? '/' . $conf->entity : '') . '/doctemplates/supplier_invoices';
    $dest = $dirodt . '/template_supplier_invoices.odt';
 
    if (file_exists($src) && !file_exists($dest)) {
      require_once DOL_DOCUMENT_ROOT . '/core/lib/files.lib.php';
      dol_mkdir($dirodt);
      $result = dol_copy($src, $dest, '0', 0);
      if ($result < 0) {
        $langs->load("errors");
        $this->error = $langs->trans('ErrorFailToCopyFile', $src, $dest);
        return 0;
      }
    }
 
    $sql = array();
    /*
      $sql_invoice = array(
        "DELETE FROM ".MAIN_DB_PREFIX."document_model WHERE nom = '".$this->db->escape($this->const[2][2])."' AND type = 'invoice_supplier' AND entity = ".((int) $conf->entity),
        "INSERT INTO ".MAIN_DB_PREFIX."document_model (nom, type, entity) VALUES('".$this->db->escape($this->const[2][2])."', 'invoice_supplier', ".((int) $conf->entity).")",
      );
 
      $sql = $sql_invoice;
      */
 
    return $this->_init($sql, $options);
  }
}