dolibarr 20.0.0
modFacture.class.php
Go to the documentation of this file.
1<?php
2/* Copyright (C) 2003-2004 Rodolphe Quiedeville <rodolphe@quiedeville.org>
3 * Copyright (C) 2004-2018 Laurent Destailleur <eldy@users.sourceforge.net>
4 * Copyright (C) 2004 Sebastien Di Cintio <sdicintio@ressource-toi.org>
5 * Copyright (C) 2004 Benoit Mortier <benoit.mortier@opensides.be>
6 * Copyright (C) 2005-2012 Regis Houssin <regis.houssin@inodbox.com>
7 * Copyright (C) 2021 Alexandre Spangaro <aspangaro@open-dsi.fr>
8 * Copyright (C) 2022 Frédéric France <frederic.france@netlogic.fr>
9 * Copyright (C) 2024 William Mead <william.mead@manchenumerique.fr>
10 *
11 * This program is free software; you can redistribute it and/or modify
12 * it under the terms of the GNU General Public License as published by
13 * the Free Software Foundation; either version 3 of the License, or
14 * (at your option) any later version.
15 *
16 * This program is distributed in the hope that it will be useful,
17 * but WITHOUT ANY WARRANTY; without even the implied warranty of
18 * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the
19 * GNU General Public License for more details.
20 *
21 * You should have received a copy of the GNU General Public License
22 * along with this program. If not, see <https://www.gnu.org/licenses/>.
23 */
24
32include_once DOL_DOCUMENT_ROOT.'/core/modules/DolibarrModules.class.php';
33
34
39{
45 public function __construct($db)
46 {
47 global $conf, $langs, $user, $mysoc;
48
49 $this->db = $db;
50 $this->numero = 30;
51
52 $this->family = "financial";
53 $this->module_position = '11';
54 // Module label (no space allowed), used if translation string 'ModuleXXXName' not found (where XXX is value of numeric property 'numero' of module)
55 $this->name = preg_replace('/^mod/i', '', get_class($this));
56 $this->description = "Gestion des factures";
57
58 // Possible values for version are: 'development', 'experimental', 'dolibarr' or version
59 $this->version = 'dolibarr';
60
61 $this->const_name = 'MAIN_MODULE_'.strtoupper($this->name);
62 $this->picto = 'bill';
63
64 // Data directories to create when module is enabled
65 $this->dirs = array("/facture/temp");
66
67 // Dependencies
68 $this->depends = array('always'=>"modSociete");
69 $this->requiredby = array("modComptabilite", "modAccounting");
70 $this->conflictwith = array();
71 $this->langfiles = array("bills", "companies", "compta", "products");
72 $this->warnings_activation = array(); // Warning to show when we activate module. array('always'='text') or array('FR'='text')
73 $this->warnings_activation_ext = array(); // Warning to show when we activate an external module. array('always'='text') or array('FR'='text')
74
75 // Config pages
76 $this->config_page_url = array("invoice.php");
77
78 // Constants
79 $this->const = array();
80 $r = 0;
81
82 $this->const[$r][0] = "FACTURE_ADDON";
83 $this->const[$r][1] = "chaine";
84 $this->const[$r][2] = "mod_facture_terre";
85 $this->const[$r][3] = 'Name of numbering numerotation rules of invoice';
86 $this->const[$r][4] = 0;
87 $r++;
88
89 $this->const[$r][0] = "FACTURE_ADDON_PDF";
90 $this->const[$r][1] = "chaine";
91 $this->const[$r][2] = "sponge";
92 $this->const[$r][3] = 'Name of PDF model of invoice';
93 $this->const[$r][4] = 0;
94 $r++;
95
96 $this->const[$r][0] = "FACTURE_ADDON_PDF_ODT_PATH";
97 $this->const[$r][1] = "chaine";
98 $this->const[$r][2] = "DOL_DATA_ROOT/doctemplates/invoices";
99 $this->const[$r][3] = "";
100 $this->const[$r][4] = 0;
101 $r++;
102
103 // Boxes
104 //$this->boxes = array(0=>array(1=>'box_factures_imp.php'),1=>array(1=>'box_factures.php'));
105 $this->boxes = array(
106 0=>array('file'=>'box_factures_imp.php', 'enabledbydefaulton'=>'Home'),
107 1=>array('file'=>'box_factures.php', 'enabledbydefaulton'=>'Home'),
108 2=>array('file'=>'box_graph_invoices_permonth.php', 'enabledbydefaulton'=>'Home'),
109 3=>array('file'=>'box_customers_outstanding_bill_reached.php', 'enabledbydefaulton'=>'Home')
110 );
111
112 // Cronjobs
113 $arraydate = dol_getdate(dol_now());
114 $datestart = dol_mktime(23, 0, 0, $arraydate['mon'], $arraydate['mday'], $arraydate['year']);
115 $this->cronjobs = array(
116 0 => array(
117 'label'=>'RecurringInvoicesJob',
118 'jobtype'=>'method',
119 'class'=>'compta/facture/class/facture-rec.class.php',
120 'objectname'=>'FactureRec',
121 'method'=>'createRecurringInvoices',
122 'parameters'=>'',
123 'comment'=>'Generate recurring invoices',
124 'frequency'=>1,
125 'unitfrequency'=>3600 * 24,
126 'priority'=>51,
127 'status'=>1,
128 'test'=>'$conf->facture->enabled',
129 'datestart'=>$datestart
130 ),
131 1 => array(
132 'label'=>'SendEmailsRemindersOnInvoiceDueDate',
133 'jobtype'=>'method',
134 'class'=>'compta/facture/class/facture.class.php',
135 'objectname'=>'Facture',
136 'method'=>'sendEmailsRemindersOnInvoiceDueDate',
137 'parameters'=>"10,all,EmailTemplateCode,duedate",
138 'comment'=>'Send an email when we reach the invoice due date (or invoice date) - n days. First param is n, the number of days before due date (or 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 invoice). The fourth parameter is the string "duedate" (default) or "invoicedate" to define which date of the invoice to use.',
139 'frequency'=>1,
140 'unitfrequency'=>3600 * 24,
141 'priority'=>50,
142 'status'=>0,
143 'test'=>'$conf->facture->enabled',
144 'datestart'=>$datestart
145 ),
146 );
147
148 // Permissions
149 $this->rights = array();
150 $this->rights_class = 'facture';
151 $r = 0;
152
153 $r++;
154 $this->rights[$r][0] = 11;
155 $this->rights[$r][1] = 'Read invoices';
156 $this->rights[$r][2] = 'a';
157 $this->rights[$r][3] = 0;
158 $this->rights[$r][4] = 'lire';
159
160 $r++;
161 $this->rights[$r][0] = 12;
162 $this->rights[$r][1] = 'Create and update invoices';
163 $this->rights[$r][2] = 'a';
164 $this->rights[$r][3] = 0;
165 $this->rights[$r][4] = 'creer';
166
167 // There is a particular permission for unvalidate because this may be not forbidden by some laws
168 $r++;
169 $this->rights[$r][0] = 13;
170 $this->rights[$r][1] = 'Devalidate invoices';
171 $this->rights[$r][2] = 'a';
172 $this->rights[$r][3] = 0;
173 $this->rights[$r][4] = 'invoice_advance';
174 $this->rights[$r][5] = 'unvalidate';
175
176 $r++;
177 $this->rights[$r][0] = 14;
178 $this->rights[$r][1] = 'Validate invoices';
179 $this->rights[$r][2] = 'a';
180 $this->rights[$r][3] = 0;
181 $this->rights[$r][4] = 'invoice_advance';
182 $this->rights[$r][5] = 'validate';
183
184 $r++;
185 $this->rights[$r][0] = 15;
186 $this->rights[$r][1] = 'Send invoices by email';
187 $this->rights[$r][2] = 'a';
188 $this->rights[$r][3] = 0;
189 $this->rights[$r][4] = 'invoice_advance';
190 $this->rights[$r][5] = 'send';
191
192 $r++;
193 $this->rights[$r][0] = 16;
194 $this->rights[$r][1] = 'Issue payments on invoices';
195 $this->rights[$r][2] = 'a';
196 $this->rights[$r][3] = 0;
197 $this->rights[$r][4] = 'paiement';
198
199 $r++;
200 $this->rights[$r][0] = 19;
201 $this->rights[$r][1] = 'Delete invoices';
202 $this->rights[$r][2] = 'a';
203 $this->rights[$r][3] = 0;
204 $this->rights[$r][4] = 'supprimer';
205
206 $r++;
207 $this->rights[$r][0] = 1321;
208 $this->rights[$r][1] = 'Export customer invoices, attributes and payments';
209 $this->rights[$r][2] = 'r';
210 $this->rights[$r][3] = 0;
211 $this->rights[$r][4] = 'facture';
212 $this->rights[$r][5] = 'export';
213
214 $r++;
215 $this->rights[$r][0] = 1322;
216 $this->rights[$r][1] = 'Re-open a fully paid invoice';
217 $this->rights[$r][2] = 'r';
218 $this->rights[$r][3] = 0;
219 $this->rights[$r][4] = 'invoice_advance';
220 $this->rights[$r][5] = 'reopen';
221
222
223 // Menus
224 //-------
225 $this->menu = 1; // This module add menu entries. They are coded into menu manager.
226
227
228 // Imports
229 //--------
230 $r = 1;
231
232 $r++;
233 $this->import_code[$r] = $this->rights_class.'_'.$r;
234 $this->import_label[$r] = "Invoices"; // Translation key
235 $this->import_icon[$r] = $this->picto;
236 $this->import_entities_array[$r] = array(); // We define here only fields that use another icon that the one defined into import_icon
237 $this->import_tables_array[$r] = array('f' => MAIN_DB_PREFIX.'facture', 'extra' => MAIN_DB_PREFIX.'facture_extrafields');
238 $this->import_tables_creator_array[$r] = array('f' => 'fk_user_author'); // Fields to store import user id
239 $this->import_fields_array[$r] = array(
240 'f.ref' => 'InvoiceRef*',
241 'f.ref_ext' => 'ExternalRef',
242 'f.ref_client' => 'RefCustomer',
243 'f.type' => 'Type*',
244 'f.fk_soc' => 'Customer*',
245 'f.datec' => 'InvoiceDateCreation',
246 'f.datef' => 'DateInvoice',
247 'f.date_valid' => 'Validation Date',
248 'f.paye' => 'InvoicePaid',
249 'f.total_tva' => 'TotalVAT',
250 'f.total_ht' => 'TotalHT',
251 'f.total_ttc' => 'TotalTTC',
252 'f.fk_statut' => 'InvoiceStatus',
253 'f.fk_user_modif' => 'Modifier Id',
254 'f.fk_user_valid' => 'Validator Id',
255 'f.fk_user_closing' => 'Closer Id',
256 'f.fk_facture_source' => 'Invoice Source Id',
257 'f.fk_projet' => 'Project Id',
258 'f.fk_account' => 'Bank Account',
259 'f.fk_currency' => 'Currency*',
260 'f.fk_cond_reglement' => 'PaymentTerm',
261 'f.fk_mode_reglement' => 'PaymentMode',
262 'f.date_lim_reglement' => 'DateMaxPayment',
263 'f.note_public' => 'InvoiceNote',
264 'f.note_private' => 'NotePrivate',
265 'f.model_pdf' => 'Model'
266 );
267 if (isModEnabled("multicurrency")) {
268 $this->import_fields_array[$r]['f.multicurrency_code'] = 'Currency';
269 $this->import_fields_array[$r]['f.multicurrency_tx'] = 'CurrencyRate';
270 $this->import_fields_array[$r]['f.multicurrency_total_ht'] = 'MulticurrencyAmountHT';
271 $this->import_fields_array[$r]['f.multicurrency_total_tva'] = 'MulticurrencyAmountVAT';
272 $this->import_fields_array[$r]['f.multicurrency_total_ttc'] = 'MulticurrencyAmountTTC';
273 }
274 // Add extra fields
275 $import_extrafield_sample = array();
276 $sql = "SELECT name, label, fieldrequired FROM ".MAIN_DB_PREFIX."extrafields WHERE elementtype = 'facture' AND entity IN (0, ".$conf->entity.")";
277 $resql = $this->db->query($sql);
278 if ($resql) {
279 while ($obj = $this->db->fetch_object($resql)) {
280 $fieldname = 'extra.'.$obj->name;
281 $fieldlabel = ucfirst($obj->label);
282 $this->import_fields_array[$r][$fieldname] = $fieldlabel.($obj->fieldrequired ? '*' : '');
283 $import_extrafield_sample[$fieldname] = $fieldlabel;
284 }
285 }
286 // End add extra fields
287 $this->import_fieldshidden_array[$r] = array('extra.fk_object' => 'lastrowid-'.MAIN_DB_PREFIX.'facture');
288 $this->import_regex_array[$r] = array('f.multicurrency_code' => 'code@'.MAIN_DB_PREFIX.'multicurrency');
289 $import_sample = array(
290 'f.ref' => '(PROV0001)',
291 'f.ref_ext' => '',
292 'f.ref_client' => '',
293 'f.type' => '0',
294 'f.fk_soc' => '80LIMIT',
295 'f.datec' => '2021-11-24',
296 'f.datef' => '2021-11-24',
297 'f.date_valid' => '2021-11-24',
298 'f.paye' => '1',
299 'f.total_tva' => '21',
300 'f.total_ht' => '100',
301 'f.total_ttc' => '121',
302 'f.fk_statut' => '1',
303 'f.fk_user_modif' => '',
304 'f.fk_user_valid' => '',
305 'f.fk_user_closing' => '',
306 'f.fk_facture_source' => '',
307 'f.fk_projet' => '',
308 'f.fk_account' => '',
309 'f.fk_currency' => 'EUR',
310 'f.fk_cond_reglement' => '30D',
311 'f.fk_mode_reglement' => 'VIR',
312 'f.date_lim_reglement' => '2021-12-24',
313 'f.note_public' => '',
314 'f.note_private' => '',
315 'f.model_pdf' => 'sponge',
316 'f.multicurrency_code' => 'EUR',
317 'f.multicurrency_tx' => '1',
318 'f.multicurrency_total_ht' => '100',
319 'f.multicurrency_total_tva' => '21',
320 'f.multicurrency_total_ttc' => '121'
321 );
322 $this->import_examplevalues_array[$r] = array_merge($import_sample, $import_extrafield_sample);
323 $this->import_updatekeys_array[$r] = array('f.ref' => 'Ref');
324 $this->import_convertvalue_array[$r] = array(
325 'f.fk_soc' => array(
326 'rule' => 'fetchidfromref',
327 'file' => '/societe/class/societe.class.php',
328 'class' => 'Societe',
329 'method' => 'fetch',
330 'element' => 'ThirdParty'
331 ),
332 'f.fk_projet' => array(
333 'rule' => 'fetchidfromref',
334 'file' => '/projet/class/project.class.php',
335 'class' => 'Project',
336 'method' => 'fetch',
337 'element' => 'facture'
338 ),
339 'f.fk_cond_reglement' => array(
340 'rule' => 'fetchidfromcodeorlabel',
341 'file' => '/compta/facture/class/paymentterm.class.php',
342 'class' => 'PaymentTerm',
343 'method' => 'fetch',
344 'element' => 'c_payment_term'
345 )
346 );
347
348 // Import Invoice Lines
349 $r++;
350 $this->import_code[$r] = $this->rights_class.'_'.$r;
351 $this->import_label[$r] = "InvoiceLine"; // Translation key
352 $this->import_icon[$r] = $this->picto;
353 $this->import_entities_array[$r] = array(); // We define here only fields that use another icon that the one defined into import_icon
354 $this->import_tables_array[$r] = array('fd' => MAIN_DB_PREFIX.'facturedet', 'extra' => MAIN_DB_PREFIX.'facturedet_extrafields');
355 $this->import_fields_array[$r] = array(
356 'fd.fk_facture' => 'InvoiceRef*',
357 'fd.fk_parent_line' => 'FacParentLine',
358 'fd.fk_product' => 'IdProduct',
359 'fd.label' => 'Label',
360 'fd.description' => 'LineDescription*',
361 'fd.vat_src_code' => 'Vat Source Code',
362 'fd.tva_tx' => 'LineVATRate*',
363 // localtax1_tx
364 // localtax1_type
365 // localtax2_tx
366 // localtax2_type
367 'fd.qty' => 'LineQty',
368 'fd.remise_percent' => 'Reduc. (%)',
369 // remise
370 // fk_remise_except
371 'fd.subprice' => 'UnitPriceHT',
372 // price
373 'fd.total_ht' => 'LineTotalHT',
374 'fd.total_tva' => 'LineTotalVAT',
375 // total_localtax1
376 // total_localtax2
377 'fd.total_ttc' => 'LineTotalTTC',
378 'fd.product_type' => 'TypeOfLineServiceOrProduct',
379 'fd.date_start' => 'Start Date',
380 'fd.date_end' => 'End Date',
381 // info_bits
382 // buy_price_ht
383 // fk_product_fournisseur_price
384 // specia_code
385 // rang
386 // fk_contract_line
387 'fd.fk_unit' => 'Unit',
388 // fk_code_ventilation
389 // situation_percent
390 // fk_prev_id
391 // fk_user_author
392 // fk_user_modif
393 // ref_ext
394 );
395 if (isModEnabled("multicurrency")) {
396 $this->import_fields_array[$r]['fd.multicurrency_code'] = 'Currency';
397 $this->import_fields_array[$r]['fd.multicurrency_subprice'] = 'CurrencyRate';
398 $this->import_fields_array[$r]['fd.multicurrency_total_ht'] = 'MulticurrencyAmountHT';
399 $this->import_fields_array[$r]['fd.multicurrency_total_tva'] = 'MulticurrencyAmountVAT';
400 $this->import_fields_array[$r]['fd.multicurrency_total_ttc'] = 'MulticurrencyAmountTTC';
401 }
402 // Add extra fields
403 $import_extrafield_sample = array();
404 $sql = "SELECT name, label, fieldrequired FROM ".MAIN_DB_PREFIX."extrafields WHERE elementtype = 'facture_det' AND entity IN (0, ".$conf->entity.")";
405 $resql = $this->db->query($sql);
406 if ($resql) {
407 while ($obj = $this->db->fetch_object($resql)) {
408 $fieldname = 'extra.'.$obj->name;
409 $fieldlabel = ucfirst($obj->label);
410 $this->import_fields_array[$r][$fieldname] = $fieldlabel.($obj->fieldrequired ? '*' : '');
411 $import_extrafield_sample[$fieldname] = $fieldlabel;
412 }
413 }
414 // End add extra fields
415 $this->import_fieldshidden_array[$r] = array('extra.fk_object' => 'lastrowid-'.MAIN_DB_PREFIX.'facturedet');
416 $this->import_regex_array[$r] = array(
417 'fd.fk_product' => 'rowid@'.MAIN_DB_PREFIX.'product',
418 'fd.multicurrency_code' => 'code@'.MAIN_DB_PREFIX.'multicurrency'
419 );
420 $import_sample = array(
421 'fd.fk_facture' => '(PROV00001)',
422 'fd.fk_parent_line' => '',
423 'fd.fk_product' => '',
424 'fd.label' => '',
425 'fd.description' => 'Test product',
426 'fd.vat_src_code' => '',
427 'fd.tva_tx' => '21',
428 // localtax1_tx
429 // localtax1_type
430 // localtax2_tx
431 // localtax2_type
432 'fd.qty' => '1',
433 'fd.remise_percent' => '0',
434 // remise
435 // fk_remise_except
436 'fd.subprice' => '100',
437 // price
438 'fd.total_ht' => '100',
439 'fd.total_tva' => '21',
440 // total_localtax1
441 // total_localtax2
442 'fd.total_ttc' => '121',
443 'fd.product_type' => '0',
444 'fd.date_start' => '',
445 'fd.date_end' => '',
446 // info_bits
447 // buy_price_ht
448 // fk_product_fournisseur_price
449 // specia_code
450 // rang
451 // fk_contract_line
452 'fd.fk_unit' => '',
453 // fk_code_ventilation
454 // situation_percent
455 // fk_prev_id
456 // fk_user_author
457 // fk_user_modif
458 // ref_ext
459 'fd.multicurrency_code' => 'EUR',
460 'fd.multicurrency_tx' => '21',
461 'fd.multicurrency_total_ht' => '100',
462 'fd.multicurrency_total_tva' => '21',
463 'fd.multicurrency_total_ttc' => '121'
464 );
465 $this->import_examplevalues_array[$r] = array_merge($import_sample, $import_extrafield_sample);
466 $this->import_updatekeys_array[$r] = array(
467 'fd.rowid' => 'Row Id',
468 'fd.fk_facture' => 'Invoice Id'
469 );
470 $this->import_convertvalue_array[$r] = array(
471 'fd.fk_facture' => array(
472 'rule' => 'fetchidfromref',
473 'file' => '/compta/facture/class/facture.class.php',
474 'class' => 'Facture',
475 'method' => 'fetch',
476 'element' => 'facture'
477 ),
478 'fd.fk_projet' => array(
479 'rule' => 'fetchidfromref',
480 'file' => '/projet/class/project.class.php',
481 'class' => 'Project',
482 'method' => 'fetch',
483 'element' => 'facture'
484 ),
485 );
486
487
488 // Exports
489 //--------
490 $uselocaltax1 = (is_object($mysoc) && $mysoc->localtax1_assuj) ? $mysoc->localtax1_assuj : 0;
491 $uselocaltax2 = (is_object($mysoc) && $mysoc->localtax2_assuj) ? $mysoc->localtax2_assuj : 0;
492
493 $r = 0;
494
495 $langs->loadLangs(array("suppliers", "multicurrency", "bills"));
496
497 $uselocaltax1 = $mysoc->localtax1_assuj ?? 0;
498 $uselocaltax2 = $mysoc->localtax2_assuj ?? 0;
499
500 $alias_product_perentity = !getDolGlobalString('MAIN_PRODUCT_PERENTITY_SHARED') ? "p" : "ppe";
501
502 // Invoices and lines
503 $this->export_code[$r] = $this->rights_class.'_'.$r;
504 $this->export_label[$r] = 'CustomersInvoicesAndInvoiceLines'; // Translation key (used only if key ExportDataset_xxx_z not found)
505 $this->export_icon[$r] = 'invoice';
506 $this->export_permission[$r] = array(array("facture", "facture", "export", "other"));
507
508 $this->export_fields_array[$r] = array(
509 's.rowid'=>"IdCompany", 's.nom'=>'CompanyName', 'ps.nom' => 'ParentCompany', 's.code_client'=>'CustomerCode', 's.address'=>'Address', 's.zip'=>'Zip', 's.town'=>'Town', 'c.code'=>'CountryCode', 'cd.nom'=>'State',
510 's.phone'=>'Phone',
511 's.siren'=>'ProfId1', 's.siret'=>'ProfId2', 's.ape'=>'ProfId3', 's.idprof4'=>'ProfId4',
512 's.code_compta'=>'CustomerAccountancyCode',
513 's.code_compta_fournisseur'=>'SupplierAccountancyCode',
514 's.tva_intra'=>'VATIntra',
515 't.libelle'=>"ThirdPartyType", // 'ce.code'=>"Staff", "cfj.libelle"=>"JuridicalStatus",
516 'f.rowid'=>"InvoiceId", 'f.ref'=>"InvoiceRef", 'f.ref_client'=>'RefCustomer', 'f.fk_facture_source'=>'SourceInvoiceId',
517 'f.type'=>"Type", 'f.datec'=>"InvoiceDateCreation", 'f.datef'=>"DateInvoice", 'f.date_lim_reglement'=>"DateDue",
518 'f.fk_cond_reglement'=>'IdPaymentTerm', 'f.fk_mode_reglement'=>'IdPaymentMode',
519 'f.total_ht'=>"TotalHT", 'f.total_ttc'=>"TotalTTC", 'f.total_tva'=>"TotalVAT",
520 'f.localtax1'=>"TotalLT1", 'f.localtax2'=>"TotalLT2",
521 'f.paye'=>"InvoicePaidCompletely", 'f.fk_statut'=>'InvoiceStatus', 'f.close_code'=>'EarlyClosingReason', 'f.close_note'=>'EarlyClosingComment',
522 'none.rest'=>'Rest',
523 'f.note_private'=>"NotePrivate", 'f.note_public'=>"NotePublic"
524 );
525 if (!$uselocaltax1) {
526 unset($this->export_fields_array[$r]['f.localtax1']);
527 }
528 if (!$uselocaltax2) {
529 unset($this->export_fields_array[$r]['f.localtax2']);
530 }
531
532 // Add multicurrency fields
533 if (isModEnabled("multicurrency")) {
534 $this->export_fields_array[$r]['f.multicurrency_code'] = 'Currency';
535 $this->export_fields_array[$r]['f.multicurrency_tx'] = 'CurrencyRate';
536 $this->export_fields_array[$r]['f.multicurrency_total_ht'] = 'MulticurrencyAmountHT';
537 $this->export_fields_array[$r]['f.multicurrency_total_tva'] = 'MulticurrencyAmountVAT';
538 $this->export_fields_array[$r]['f.multicurrency_total_ttc'] = 'MulticurrencyAmountTTC';
539 }
540 // Add POS fields
541 if (!empty($conf->cashdesk->enabled) || !empty($conf->takepos->enabled) || getDolGlobalString('INVOICE_SHOW_POS')) {
542 $this->export_fields_array[$r]['f.module_source'] = 'Module';
543 $this->export_fields_array[$r]['f.pos_source'] = 'POSTerminal';
544 }
545 $this->export_fields_array[$r] = $this->export_fields_array[$r] + array(
546 'f.fk_user_author'=>'CreatedById', 'uc.login'=>'CreatedByLogin',
547 'f.fk_user_valid'=>'ValidatedById', 'uv.login'=>'ValidatedByLogin',
548 'pj.ref'=>'ProjectRef', 'pj.title'=>'ProjectLabel'
549 );
550 // Add multicompany field
551 if (getDolGlobalString('MULTICOMPANY_ENTITY_IN_EXPORT_IF_SHARED')) {
552 $nbofallowedentities = count(explode(',', getEntity('invoice')));
553 if (isModEnabled('multicompany') && $nbofallowedentities > 1) {
554 $this->export_fields_array[$r]['f.entity'] = 'Entity';
555 }
556 }
557 $this->export_fields_array[$r] = $this->export_fields_array[$r] + array(
558 'fd.rowid'=>'LineId', 'fd.description'=>"LineDescription",
559 'fd.subprice'=>"LineUnitPrice", 'fd.qty'=>"LineQty",
560 'fd.tva_tx'=>"LineVATRate",
561 'fd.total_ht'=>"LineTotalHT", 'fd.total_tva'=>"LineTotalVAT", 'fd.total_ttc'=>"LineTotalTTC",
562 'fd.localtax1_tx'=>"LineLT1Rate", 'fd.localtax1_type'=>"LineLT1Type", 'fd.total_localtax1'=>"LineTotalLT1",
563 'fd.localtax2_tx'=>"LineLT2Rate", 'fd.localtax2_type'=>"LineLT2Type", 'fd.total_localtax2'=>"LineTotalLT2",
564 'fd.buy_price_ht'=>'BuyingPrice', 'fd.date_start'=>"DateStart", 'fd.date_end'=>"DateEnd", 'fd.special_code'=>'SpecialCode',
565 'fd.product_type'=>"TypeOfLineServiceOrProduct", 'fd.fk_product'=>'ProductId', 'p.ref'=>'ProductRef', 'p.label'=>'ProductLabel',
566 $alias_product_perentity . '.accountancy_code_sell'=>'ProductAccountancySellCode',
567 'aa.account_number' => 'AccountingAffectation'
568 );
569 if (!$uselocaltax1) {
570 unset($this->export_fields_array[$r]['fd.localtax1_tx']);
571 unset($this->export_fields_array[$r]['fd.localtax1_type']);
572 unset($this->export_fields_array[$r]['fd.total_localtax1']);
573 }
574 if (!$uselocaltax2) {
575 unset($this->export_fields_array[$r]['fd.localtax2_tx']);
576 unset($this->export_fields_array[$r]['fd.localtax2_type']);
577 unset($this->export_fields_array[$r]['fd.total_localtax2']);
578 }
579
580 $this->export_TypeFields_array[$r] = array(
581 's.rowid'=>'Numeric', 's.nom'=>'Text', 'ps.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',
582 's.siret'=>'Text', 's.ape'=>'Text', 's.idprof4'=>'Text', 's.code_compta'=>'Text', 's.code_compta_fournisseur'=>'Text', 's.tva_intra'=>'Text',
583 't.libelle'=>"Text", // 'ce.code'=>"List:c_effectif:libelle:code", "cfj.libelle"=>"Text",
584 'f.rowid'=>'Numeric', 'f.ref'=>"Text", 'f.ref_client'=>'Text', 'f.fk_facture_source'=>'Numeric', 'f.type'=>"Numeric", 'f.datec'=>"Date", 'f.datef'=>"Date", 'f.date_lim_reglement'=>"Date",
585 'f.fk_cond_reglement'=>'Numeric', 'f.fk_mode_reglement'=>'Numeric',
586 'f.total_ht'=>"Numeric", 'f.total_ttc'=>"Numeric", 'f.total_tva'=>"Numeric", 'f.localtax1'=>'Numeric', 'f.localtax2'=>'Numeric', 'f.paye'=>"Boolean", 'f.fk_statut'=>'Numeric', 'f.close_code'=>'Text', 'f.close_note'=>'Text',
587 'none.rest'=>"NumericCompute",
588 'f.note_private'=>"Text", 'f.note_public'=>"Text",
589 'f.module_source' => 'Text',
590 'f.pos_source' => 'Text',
591 'f.entity'=>'List:entity:label:rowid',
592 'f.fk_user_author'=>'Numeric', 'uc.login'=>'Text', 'f.fk_user_valid'=>'Numeric', 'uv.login'=>'Text',
593 'pj.ref'=>'Text', 'pj.title'=>'Text', 'fd.rowid'=>'Numeric', 'fd.description'=>"Text", 'fd.subprice'=>"Numeric", 'fd.tva_tx'=>"Numeric",
594 'fd.qty'=>"Numeric", 'fd.buy_price_ht'=>"Numeric", 'fd.date_start'=>"Date", 'fd.date_end'=>"Date",
595 'fd.total_ht'=>"Numeric", 'fd.total_tva'=>"Numeric", 'fd.total_ttc'=>"Numeric", 'fd.total_localtax1'=>"Numeric", 'fd.total_localtax2'=>"Numeric",
596 'fd.localtax1_tx'=>'Numeric', 'fd.localtax2_tx'=>'Numeric', 'fd.localtax1_type'=>'Numeric', 'fd.localtax2_type'=>'Numeric',
597 'fd.special_code'=>'Numeric', 'fd.product_type'=>"Numeric", 'fd.fk_product'=>'List:product:label', 'p.ref'=>'Text', 'p.label'=>'Text',
598 $alias_product_perentity . '.accountancy_code_sell'=>'Text',
599 'aa.account_number' => 'Text',
600 'f.multicurrency_code' => 'Text',
601 'f.multicurrency_tx' => 'Number', 'f.multicurrency_total_ht' => 'Number', 'f.multicurrency_total_tva' => 'Number', 'f.multicurrency_total_ttc' => 'Number'
602 );
603 $this->export_entities_array[$r] = array(
604 's.rowid'=>"company", 's.nom'=>'company', 'ps.nom'=>'company', 's.code_client'=>'company', 's.address'=>'company', 's.zip'=>'company', 's.town'=>'company', 'c.code'=>'company', 'cd.nom'=>'company', 's.phone'=>'company',
605 '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',
606 't.libelle'=>'company', // 'ce.code'=>'company', 'cfj.libelle'=>'company'
607 'pj.ref'=>'project', 'pj.title'=>'project', 'fd.rowid'=>'invoice_line', 'fd.description'=>"invoice_line",
608 'fd.subprice'=>"invoice_line", 'fd.buy_price_ht'=>'invoice_line',
609 'fd.total_ht'=>"invoice_line", 'fd.total_tva'=>"invoice_line", 'fd.total_ttc'=>"invoice_line", 'fd.total_localtax1'=>"invoice_line", 'fd.total_localtax2'=>"invoice_line",
610 '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",
611 'fd.qty'=>"invoice_line", 'fd.date_start'=>"invoice_line", 'fd.date_end'=>"invoice_line", 'fd.special_code'=>'invoice_line',
612 'fd.product_type'=>'invoice_line', 'fd.fk_product'=>'product', 'p.ref'=>'product', 'p.label'=>'product', $alias_product_perentity . '.accountancy_code_sell'=>'product',
613 'f.fk_user_author'=>'user', 'uc.login'=>'user', 'f.fk_user_valid'=>'user', 'uv.login'=>'user',
614 'aa.account_number' => "invoice_line",
615 );
616 $this->export_help_array[$r] = array('fd.buy_price_ht'=>'CostPriceUsage');
617 $this->export_special_array[$r] = array('none.rest'=>'getRemainToPay');
618 $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
619 $keyforselect = 'facture';
620 $keyforelement = 'invoice';
621 $keyforaliasextra = 'extra';
622 include DOL_DOCUMENT_ROOT.'/core/extrafieldsinexport.inc.php';
623 $keyforselect = 'facturedet';
624 $keyforelement = 'invoice_line';
625 $keyforaliasextra = 'extra2';
626 include DOL_DOCUMENT_ROOT.'/core/extrafieldsinexport.inc.php';
627 $keyforselect = 'product';
628 $keyforelement = 'product';
629 $keyforaliasextra = 'extra3';
630 include DOL_DOCUMENT_ROOT.'/core/extrafieldsinexport.inc.php';
631 $keyforselect = 'societe';
632 $keyforelement = 'company';
633 $keyforaliasextra = 'extra4';
634 include DOL_DOCUMENT_ROOT.'/core/extrafieldsinexport.inc.php';
635 $this->export_sql_start[$r] = 'SELECT DISTINCT ';
636 $this->export_sql_end[$r] = ' FROM '.MAIN_DB_PREFIX.'societe as s';
637 $this->export_sql_end[$r] .= ' LEFT JOIN '.MAIN_DB_PREFIX.'societe_extrafields as extra4 ON s.rowid = extra4.fk_object';
638 $this->export_sql_end[$r] .= ' LEFT JOIN '.MAIN_DB_PREFIX.'societe as ps ON ps.rowid = s.parent';
639 $this->export_sql_end[$r] .= ' LEFT JOIN '.MAIN_DB_PREFIX.'c_typent as t ON s.fk_typent = t.id';
640 if (!empty($user) && !$user->hasRight('societe', 'client', 'voir')) {
641 $this->export_sql_end[$r] .= ' LEFT JOIN '.MAIN_DB_PREFIX.'societe_commerciaux as sc ON sc.fk_soc = s.rowid';
642 }
643 $this->export_sql_end[$r] .= ' LEFT JOIN '.MAIN_DB_PREFIX.'c_country as c on s.fk_pays = c.rowid';
644 $this->export_sql_end[$r] .= ' LEFT JOIN '.MAIN_DB_PREFIX.'c_departements as cd on s.fk_departement = cd.rowid,';
645 $this->export_sql_end[$r] .= ' '.MAIN_DB_PREFIX.'facture as f';
646 $this->export_sql_end[$r] .= ' LEFT JOIN '.MAIN_DB_PREFIX.'projet as pj ON f.fk_projet = pj.rowid';
647 $this->export_sql_end[$r] .= ' LEFT JOIN '.MAIN_DB_PREFIX.'user as uc ON f.fk_user_author = uc.rowid';
648 $this->export_sql_end[$r] .= ' LEFT JOIN '.MAIN_DB_PREFIX.'user as uv ON f.fk_user_valid = uv.rowid';
649 $this->export_sql_end[$r] .= ' LEFT JOIN '.MAIN_DB_PREFIX.'facture_extrafields as extra ON f.rowid = extra.fk_object';
650 $this->export_sql_end[$r] .= ' , '.MAIN_DB_PREFIX.'facturedet as fd';
651 $this->export_sql_end[$r] .= ' LEFT JOIN '.MAIN_DB_PREFIX.'facturedet_extrafields as extra2 on fd.rowid = extra2.fk_object';
652 $this->export_sql_end[$r] .= ' LEFT JOIN '.MAIN_DB_PREFIX.'product as p on (fd.fk_product = p.rowid)';
653 if (getDolGlobalString('MAIN_PRODUCT_PERENTITY_SHARED')) {
654 $this->export_sql_end[$r] .= " LEFT JOIN " . MAIN_DB_PREFIX . "product_perentity as ppe ON ppe.fk_product = p.rowid AND ppe.entity = " . ((int) $conf->entity);
655 }
656 $this->export_sql_end[$r] .= ' LEFT JOIN '.MAIN_DB_PREFIX.'product_extrafields as extra3 on p.rowid = extra3.fk_object';
657 $this->export_sql_end[$r] .= ' LEFT JOIN '.MAIN_DB_PREFIX.'accounting_account as aa on fd.fk_code_ventilation = aa.rowid';
658 $this->export_sql_end[$r] .= ' WHERE f.fk_soc = s.rowid AND f.rowid = fd.fk_facture';
659 $this->export_sql_end[$r] .= ' AND f.entity IN ('.getEntity('invoice').')';
660 if (!empty($user) && !$user->hasRight('societe', 'client', 'voir')) {
661 $this->export_sql_end[$r] .= ' AND sc.fk_user = '.(empty($user) ? 0 : $user->id);
662 }
663 $r++;
664
665 // Invoices and payments
666 $this->export_code[$r] = $this->rights_class.'_'.$r;
667 $this->export_label[$r] = 'CustomersInvoicesAndPayments'; // Translation key (used only if key ExportDataset_xxx_z not found)
668 $this->export_icon[$r] = 'invoice';
669 $this->export_permission[$r] = array(array("facture", "facture", "export"));
670 $this->export_fields_array[$r] = array(
671 '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',
672 's.phone'=>'Phone',
673 's.siren'=>'ProfId1', 's.siret'=>'ProfId2', 's.ape'=>'ProfId3', 's.idprof4'=>'ProfId4', 's.code_compta'=>'CustomerAccountancyCode',
674 's.code_compta_fournisseur'=>'SupplierAccountancyCode', 's.tva_intra'=>'VATIntra',
675 'f.rowid'=>"InvoiceId", 'f.ref'=>"InvoiceRef", 'f.ref_client'=>'RefCustomer', 'f.fk_facture_source'=>'SourceInvoiceId',
676 'f.type'=>"Type", 'f.datec'=>"InvoiceDateCreation", 'f.datef'=>"DateInvoice", 'f.date_lim_reglement'=>"DateDue",
677 'f.fk_cond_reglement'=>'IdPaymentTerm', 'f.fk_mode_reglement'=>'IdPaymentMode',
678 'f.total_ht'=>"TotalHT", 'f.total_ttc'=>"TotalTTC", 'f.total_tva'=>"TotalVAT", 'f.localtax1'=>'LT1', 'f.localtax2'=>'LT2', 'f.paye'=>"InvoicePaidCompletely", 'f.fk_statut'=>'InvoiceStatus', 'f.close_code'=>'EarlyClosingReason', 'f.close_note'=>'EarlyClosingComment',
679 'none.rest'=>'Rest',
680 'f.note_private'=>"NotePrivate", 'f.note_public'=>"NotePublic", 'f.fk_user_author'=>'CreatedById', 'uc.login'=>'CreatedByLogin',
681 'f.fk_user_valid'=>'ValidatedById', 'uv.login'=>'ValidatedByLogin', 'pj.ref'=>'ProjectRef', 'pj.title'=>'ProjectLabel', 'p.rowid'=>'PaymentId', 'p.ref'=>'PaymentRef',
682 'p.amount'=>'AmountPayment', 'pf.amount'=>'AmountPaymentDistributedOnInvoice', 'p.datep'=>'DatePayment', 'p.num_paiement'=>'PaymentNumber',
683 'pt.code'=>'CodePaymentMode', 'pt.libelle'=>'LabelPaymentMode', 'p.note'=>'PaymentNote', 'p.fk_bank'=>'IdTransaction', 'ba.ref'=>'AccountRef'
684 );
685 if (!$uselocaltax1) {
686 unset($this->export_fields_array[$r]['f.localtax1']);
687 }
688 if (!$uselocaltax2) {
689 unset($this->export_fields_array[$r]['f.localtax2']);
690 }
691
692 $this->export_help_array[$r] = array('f.paye'=>'InvoicePaidCompletelyHelp');
693 if (isModEnabled("multicurrency")) {
694 $this->export_fields_array[$r]['f.multicurrency_code'] = 'Currency';
695 $this->export_fields_array[$r]['f.multicurrency_tx'] = 'CurrencyRate';
696 $this->export_fields_array[$r]['f.multicurrency_total_ht'] = 'MulticurrencyAmountHT';
697 $this->export_fields_array[$r]['f.multicurrency_total_tva'] = 'MulticurrencyAmountVAT';
698 $this->export_fields_array[$r]['f.multicurrency_total_ttc'] = 'MulticurrencyAmountTTC';
699 $this->export_examplevalues_array[$r]['f.multicurrency_code'] = 'EUR';
700 }
701 if (!empty($conf->cashdesk->enabled) || !empty($conf->takepos->enabled) || getDolGlobalString('INVOICE_SHOW_POS')) {
702 $this->export_fields_array[$r]['f.module_source'] = 'POSModule';
703 $this->export_fields_array[$r]['f.pos_source'] = 'POSTerminal';
704 }
705 $this->export_TypeFields_array[$r] = array(
706 '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',
707 's.siret'=>'Text', 's.ape'=>'Text', 's.idprof4'=>'Text', 's.code_compta'=>'Text', 's.code_compta_fournisseur'=>'Text', 's.tva_intra'=>'Text',
708 'f.rowid'=>"Numeric", 'f.ref'=>"Text", 'f.ref_client'=>'Text', 'f.fk_facture_source'=>'Numeric', 'f.type'=>"Numeric", 'f.datec'=>"Date", 'f.datef'=>"Date", 'f.date_lim_reglement'=>"Date",
709 'f.fk_cond_reglement'=>'Numeric', 'f.fk_mode_reglement'=>'Numeric',
710 '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.close_code'=>'Text', 'f.close_note'=>'Text',
711 'none.rest'=>'NumericCompute',
712 'f.note_private'=>"Text", 'f.note_public'=>"Text", 'f.fk_user_author'=>'Numeric', 'uc.login'=>'Text', 'f.fk_user_valid'=>'Numeric', 'uv.login'=>'Text',
713 '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',
714 'p.fk_bank'=>'Numeric', 'p.note'=>'Text', 'pt.code'=>'Text', 'pt.libelle'=>'text', 'ba.ref'=>'Text'
715 );
716 if (!empty($conf->cashdesk->enabled) || !empty($conf->takepos->enabled) || getDolGlobalString('INVOICE_SHOW_POS')) {
717 $this->export_fields_array[$r]['f.module_source'] = 'POSModule';
718 $this->export_fields_array[$r]['f.pos_source'] = 'POSTerminal';
719 }
720 $this->export_entities_array[$r] = array(
721 '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',
722 's.siren'=>'company', 's.siret'=>'company', 's.ape'=>'company', 's.idprof4'=>'company', 's.code_compta'=>'company', 's.code_compta_fournisseur'=>'company',
723 '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',
724 'p.num_paiement'=>'payment', 'pt.code'=>'payment', 'pt.libelle'=>'payment', 'p.note'=>'payment', 'f.fk_user_author'=>'user', 'uc.login'=>'user',
725 'f.fk_user_valid'=>'user', 'uv.login'=>'user', 'p.fk_bank'=>'account', 'ba.ref'=>'account'
726 );
727 $this->export_special_array[$r] = array('none.rest'=>'getRemainToPay');
728 $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
729 $keyforselect = 'facture';
730 $keyforelement = 'invoice';
731 $keyforaliasextra = 'extra';
732 include DOL_DOCUMENT_ROOT.'/core/extrafieldsinexport.inc.php';
733 $this->export_sql_start[$r] = 'SELECT DISTINCT ';
734 $this->export_sql_end[$r] = ' FROM '.MAIN_DB_PREFIX.'societe as s';
735 if (!empty($user) && !$user->hasRight('societe', 'client', 'voir')) {
736 $this->export_sql_end[$r] .= ' LEFT JOIN '.MAIN_DB_PREFIX.'societe_commerciaux as sc ON sc.fk_soc = s.rowid';
737 }
738 $this->export_sql_end[$r] .= ' LEFT JOIN '.MAIN_DB_PREFIX.'c_country as c on s.fk_pays = c.rowid';
739 $this->export_sql_end[$r] .= ' LEFT JOIN '.MAIN_DB_PREFIX.'c_departements as cd on s.fk_departement = cd.rowid,';
740 $this->export_sql_end[$r] .= ' '.MAIN_DB_PREFIX.'facture as f';
741 $this->export_sql_end[$r] .= ' LEFT JOIN '.MAIN_DB_PREFIX.'projet as pj ON f.fk_projet = pj.rowid';
742 $this->export_sql_end[$r] .= ' LEFT JOIN '.MAIN_DB_PREFIX.'user as uc ON f.fk_user_author = uc.rowid';
743 $this->export_sql_end[$r] .= ' LEFT JOIN '.MAIN_DB_PREFIX.'user as uv ON f.fk_user_valid = uv.rowid';
744 $this->export_sql_end[$r] .= ' LEFT JOIN '.MAIN_DB_PREFIX.'facture_extrafields as extra ON f.rowid = extra.fk_object';
745 $this->export_sql_end[$r] .= ' LEFT JOIN '.MAIN_DB_PREFIX.'paiement_facture as pf ON pf.fk_facture = f.rowid';
746 $this->export_sql_end[$r] .= ' LEFT JOIN '.MAIN_DB_PREFIX.'paiement as p ON pf.fk_paiement = p.rowid';
747 $this->export_sql_end[$r] .= ' LEFT JOIN '.MAIN_DB_PREFIX.'c_paiement as pt ON pt.id = p.fk_paiement';
748 $this->export_sql_end[$r] .= ' LEFT JOIN '.MAIN_DB_PREFIX.'bank as b ON b.rowid = p.fk_bank';
749 $this->export_sql_end[$r] .= ' LEFT JOIN '.MAIN_DB_PREFIX.'bank_account as ba ON ba.rowid = b.fk_account';
750 $this->export_sql_end[$r] .= ' WHERE f.fk_soc = s.rowid';
751 $this->export_sql_end[$r] .= ' AND f.entity IN ('.getEntity('invoice').')';
752 if (!empty($user) && !$user->hasRight('societe', 'client', 'voir')) {
753 $this->export_sql_end[$r] .= ' AND sc.fk_user = '.(empty($user) ? 0 : $user->id);
754 }
755 $r++;
756 }
757
758
767 public function init($options = '')
768 {
769 global $conf, $langs;
770
771 // Remove permissions and default values
772 $this->remove($options);
773
774 //ODT template
775 $src = DOL_DOCUMENT_ROOT.'/install/doctemplates/invoices/template_invoice.odt';
776 $dirodt = DOL_DATA_ROOT.'/doctemplates/invoices';
777 $dest = $dirodt.'/template_invoice.odt';
778
779 if (file_exists($src) && !file_exists($dest)) {
780 require_once DOL_DOCUMENT_ROOT.'/core/lib/files.lib.php';
781 dol_mkdir($dirodt);
782 $result = dol_copy($src, $dest, 0, 0);
783 if ($result < 0) {
784 $langs->load("errors");
785 $this->error = $langs->trans('ErrorFailToCopyFile', $src, $dest);
786 return 0;
787 }
788 }
789
790 $sql = array(
791 "DELETE FROM ".MAIN_DB_PREFIX."document_model WHERE nom = '".$this->db->escape($this->const[1][2])."' AND type = 'invoice' AND entity = ".((int) $conf->entity),
792 "INSERT INTO ".MAIN_DB_PREFIX."document_model (nom, type, entity) VALUES('".$this->db->escape($this->const[1][2])."','invoice',".((int) $conf->entity).")"
793 );
794
795 return $this->_init($sql, $options);
796 }
797}
Class DolibarrModules.
_init($array_sql, $options='')
Enables a module.
Class to describe module customer invoices.
init($options='')
Function called when module is enabled.
__construct($db)
Constructor.
print $script_file $mode $langs defaultlang(is_numeric($duration_value) ? " delay=". $duration_value :"").(is_numeric($duration_value2) ? " after cd cd cd description as description
Only used if Module[ID]Desc translation string is not found.
dol_copy($srcfile, $destfile, $newmask='0', $overwriteifexists=1, $testvirus=0, $indexdatabase=0)
Copy a file to another file.
dol_mktime($hour, $minute, $second, $month, $day, $year, $gm='auto', $check=1)
Return a timestamp date built from detailed information (by default a local PHP server timestamp) Rep...
dol_now($mode='auto')
Return date for now.
getDolGlobalString($key, $default='')
Return dolibarr global constant string value.
getEntity($element, $shared=1, $currentobject=null)
Get list of entity id to use.
dol_getdate($timestamp, $fast=false, $forcetimezone='')
Return an array with locale date info.
dol_mkdir($dir, $dataroot='', $newmask='')
Creation of a directory (this can create recursive subdir)
$conf db name
Only used if Module[ID]Name translation string is not found.
Definition repair.php:142