dolibarr  16.0.5
modCommande.class.php
Go to the documentation of this file.
1 <?php
2 /* Copyright (C) 2003-2005 Rodolphe Quiedeville <rodolphe@quiedeville.org>
3  * Copyright (C) 2004-2013 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) 2004 Eric Seigne <eric.seigne@ryxeo.com>
7  * Copyright (C) 2005-2012 Regis Houssin <regis.houssin@inodbox.com>
8  * Copyright (C) 2012 Juanjo Menent <jmenent@2byte.es>
9  * Copyright (C) 2020 Ahmad Jamaly Rabub <rabib@metroworks.co.jp>
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 
33 include_once DOL_DOCUMENT_ROOT.'/core/modules/DolibarrModules.class.php';
34 
35 
40 {
41 
47  public function __construct($db)
48  {
49  global $conf, $user;
50 
51  $this->db = $db;
52  $this->numero = 25;
53 
54  $this->family = "crm";
55  $this->module_position = '11';
56  // Module label (no space allowed), used if translation string 'ModuleXXXName' not found (where XXX is value of numeric property 'numero' of module)
57  $this->name = preg_replace('/^mod/i', '', get_class($this));
58  $this->description = "Gestion des commandes clients";
59  // Possible values for version are: 'development', 'experimental', 'dolibarr' or version
60  $this->version = 'dolibarr';
61 
62  $this->const_name = 'MAIN_MODULE_'.strtoupper($this->name);
63  $this->picto = 'order';
64 
65  // Data directories to create when module is enabled
66  $this->dirs = array("/commande/temp");
67 
68  // Config pages
69  $this->config_page_url = array("commande.php");
70 
71  // Dependancies
72  $this->depends = array("modSociete");
73  $this->requiredby = array("modExpedition");
74  $this->conflictwith = array();
75  $this->langfiles = array('orders', 'bills', 'companies', 'products', 'deliveries', 'sendings');
76 
77  // Constants
78  $this->const = array();
79  $r = 0;
80 
81  $this->const[$r][0] = "COMMANDE_ADDON_PDF";
82  $this->const[$r][1] = "chaine";
83  $this->const[$r][2] = "einstein";
84  $this->const[$r][3] = 'Name of PDF model of order';
85  $this->const[$r][4] = 0;
86 
87  $r++;
88  $this->const[$r][0] = "COMMANDE_ADDON";
89  $this->const[$r][1] = "chaine";
90  $this->const[$r][2] = "mod_commande_marbre";
91  $this->const[$r][3] = 'Name of numbering numerotation rules of order';
92  $this->const[$r][4] = 0;
93 
94  $r++;
95  $this->const[$r][0] = "COMMANDE_ADDON_PDF_ODT_PATH";
96  $this->const[$r][1] = "chaine";
97  $this->const[$r][2] = "DOL_DATA_ROOT/doctemplates/orders";
98  $this->const[$r][3] = "";
99  $this->const[$r][4] = 0;
100 
101  /*$r++;
102  $this->const[$r][0] = "COMMANDE_DRAFT_WATERMARK";
103  $this->const[$r][1] = "chaine";
104  $this->const[$r][2] = "__(Draft)__";
105  $this->const[$r][3] = 'Watermark to show on draft orders';
106  $this->const[$r][4] = 0;*/
107 
108  // Boxes
109  $this->boxes = array(
110  0=>array('file'=>'box_commandes.php', 'enabledbydefaulton'=>'Home'),
111  2=>array('file'=>'box_graph_orders_permonth.php', 'enabledbydefaulton'=>'Home')
112  );
113 
114  // Permissions
115  $this->rights = array();
116  $this->rights_class = 'commande';
117 
118  $r = 0;
119 
120  $r++;
121  $this->rights[$r][0] = 81;
122  $this->rights[$r][1] = 'Read sales orders';
123  $this->rights[$r][2] = 'r';
124  $this->rights[$r][3] = 0;
125  $this->rights[$r][4] = 'lire';
126 
127  $r++;
128  $this->rights[$r][0] = 82;
129  $this->rights[$r][1] = 'Creeat/modify sales orders';
130  $this->rights[$r][2] = 'w';
131  $this->rights[$r][3] = 0;
132  $this->rights[$r][4] = 'creer';
133 
134  $r++;
135  $this->rights[$r][0] = 84;
136  $this->rights[$r][1] = 'Validate sales orders';
137  $this->rights[$r][2] = 'd';
138  $this->rights[$r][3] = 0;
139  $this->rights[$r][4] = 'order_advance';
140  $this->rights[$r][5] = 'validate';
141 
142  $r++;
143  $this->rights[$r][0] = 86;
144  $this->rights[$r][1] = 'Send sale orders by email';
145  $this->rights[$r][2] = 'd';
146  $this->rights[$r][3] = 0;
147  $this->rights[$r][4] = 'order_advance';
148  $this->rights[$r][5] = 'send';
149 
150  $r++;
151  $this->rights[$r][0] = 87;
152  $this->rights[$r][1] = 'Close sale orders';
153  $this->rights[$r][2] = 'd';
154  $this->rights[$r][3] = 0;
155  $this->rights[$r][4] = 'order_advance';
156  $this->rights[$r][5] = 'close';
157 
158  $r++;
159  $this->rights[$r][0] = 88;
160  $this->rights[$r][1] = 'Cancel sale orders';
161  $this->rights[$r][2] = 'd';
162  $this->rights[$r][3] = 0;
163  $this->rights[$r][4] = 'order_advance';
164  $this->rights[$r][5] = 'annuler';
165 
166  $r++;
167  $this->rights[$r][0] = 89;
168  $this->rights[$r][1] = 'Delete sales orders';
169  $this->rights[$r][2] = 'd';
170  $this->rights[$r][3] = 0;
171  $this->rights[$r][4] = 'supprimer';
172 
173  $r++;
174  $this->rights[$r][0] = 1421;
175  $this->rights[$r][1] = 'Export sales orders and attributes';
176  $this->rights[$r][2] = 'r';
177  $this->rights[$r][3] = 0;
178  $this->rights[$r][4] = 'commande';
179  $this->rights[$r][5] = 'export';
180 
181 
182  // Menus
183  //-------
184  $this->menu = 1; // This module add menu entries. They are coded into menu manager.
185 
186 
187  // Exports
188  //--------
189  $r = 0;
190 
191  $r++;
192  $this->export_code[$r] = $this->rights_class.'_'.$r;
193  $this->export_label[$r] = 'CustomersOrdersAndOrdersLines'; // Translation key (used only if key ExportDataset_xxx_z not found)
194  $this->export_permission[$r] = array(array("commande", "commande", "export"));
195  $this->export_fields_array[$r] = array(
196  's.rowid'=>"IdCompany", 's.nom'=>'CompanyName', 'ps.nom'=>'ParentCompany', 's.address'=>'Address', 's.zip'=>'Zip', 's.town'=>'Town', 'd.nom'=>'State', 'co.label'=>'Country',
197  'co.code'=>"CountryCode", 's.phone'=>'Phone', 's.siren'=>'ProfId1', 's.siret'=>'ProfId2', 's.ape'=>'ProfId3', 's.idprof4'=>'ProfId4', 'c.rowid'=>"Id",
198  'c.ref'=>"Ref", 'c.ref_client'=>"RefCustomer", 'c.fk_soc'=>"IdCompany", 'c.date_creation'=>"DateCreation", 'c.date_commande'=>"OrderDate",
199  'c.date_livraison'=>"DateDeliveryPlanned", 'c.amount_ht'=>"Amount", 'c.total_ht'=>"TotalHT",
200  'c.total_ttc'=>"TotalTTC", 'c.facture'=>"Billed", 'c.fk_statut'=>'Status', 'c.note_public'=>"Note", 'c.date_livraison'=>'DeliveryDate',
201  'c.fk_user_author'=>'CreatedById', 'uc.login'=>'CreatedByLogin', 'c.fk_user_valid'=>'ValidatedById', 'uv.login'=>'ValidatedByLogin',
202  'pj.ref'=>'ProjectRef', 'cd.rowid'=>'LineId', 'cd.description'=>"LineDescription", 'cd.product_type'=>'TypeOfLineServiceOrProduct',
203  'cd.tva_tx'=>"LineVATRate", 'cd.qty'=>"LineQty", 'cd.total_ht'=>"LineTotalHT", 'cd.total_tva'=>"LineTotalVAT", 'cd.total_ttc'=>"LineTotalTTC",
204  'p.rowid'=>'ProductId', 'p.ref'=>'ProductRef', 'p.label'=>'ProductLabel'
205  );
206  if (!empty($conf->multicurrency->enabled)) {
207  $this->export_fields_array[$r]['c.multicurrency_code'] = 'Currency';
208  $this->export_fields_array[$r]['c.multicurrency_tx'] = 'CurrencyRate';
209  $this->export_fields_array[$r]['c.multicurrency_total_ht'] = 'MulticurrencyAmountHT';
210  $this->export_fields_array[$r]['c.multicurrency_total_tva'] = 'MulticurrencyAmountVAT';
211  $this->export_fields_array[$r]['c.multicurrency_total_ttc'] = 'MulticurrencyAmountTTC';
212  }
213  // Add multicompany field
214  if (!empty($conf->global->MULTICOMPANY_ENTITY_IN_EXPORT_IF_SHARED)) {
215  $nbofallowedentities = count(explode(',', getEntity('commande')));
216  if (!empty($conf->multicompany->enabled) && $nbofallowedentities > 1) {
217  $this->export_fields_array[$r]['c.entity'] = 'Entity';
218  }
219  }
220  //$this->export_TypeFields_array[$r]=array(
221  // 's.rowid'=>"Numeric",'s.nom'=>'Text','s.address'=>'Text','s.zip'=>'Text','s.town'=>'Text','co.label'=>'List:c_country:label:label',
222  // 'co.code'=>'Text','s.phone'=>'Text','s.siren'=>'Text','s.siret'=>'Text','s.ape'=>'Text','s.idprof4'=>'Text','c.ref'=>"Text",'c.ref_client'=>"Text",
223  // 'c.date_creation'=>"Date",'c.date_commande'=>"Date",'c.amount_ht'=>"Numeric",'c.total_ht'=>"Numeric",
224  // 'c.total_ttc'=>"Numeric",'c.facture'=>"Boolean",'c.fk_statut'=>'Status','c.note_public'=>"Text",'c.date_livraison'=>'Date','cd.description'=>"Text",
225  // 'cd.product_type'=>'Boolean','cd.tva_tx'=>"Numeric",'cd.qty'=>"Numeric",'cd.total_ht'=>"Numeric",'cd.total_tva'=>"Numeric",'cd.total_ttc'=>"Numeric",
226  // 'p.rowid'=>'List:product:ref','p.ref'=>'Text','p.label'=>'Text'
227  //);
228  $this->export_TypeFields_array[$r] = array(
229  's.nom'=>'Text', 'ps.nom'=>'Text', 's.address'=>'Text', 's.zip'=>'Text', 's.town'=>'Text', 'co.label'=>'List:c_country:label:label', 'co.code'=>'Text', 's.phone'=>'Text',
230  's.siren'=>'Text', 's.siret'=>'Text', 's.ape'=>'Text', 's.idprof4'=>'Text', 'c.ref'=>"Text", 'c.ref_client'=>"Text", 'c.date_creation'=>"Date",
231  'c.date_commande'=>"Date", 'c.date_livraison'=>"Date", 'c.amount_ht'=>"Numeric", 'c.total_ht'=>"Numeric",
232  'c.total_ttc'=>"Numeric", 'c.facture'=>"Boolean", 'c.fk_statut'=>'Status', 'c.note_public'=>"Text", 'c.date_livraison'=>'Date', 'pj.ref'=>'Text',
233  'cd.description'=>"Text", 'cd.product_type'=>'Boolean', 'cd.tva_tx'=>"Numeric", 'cd.qty'=>"Numeric", 'cd.total_ht'=>"Numeric", 'cd.total_tva'=>"Numeric",
234  'cd.total_ttc'=>"Numeric", 'p.rowid'=>'List:product:ref::product', 'p.ref'=>'Text', 'p.label'=>'Text', 'd.nom'=>'Text',
235  'c.entity'=>'List:entity:label:rowid',
236  );
237  $this->export_entities_array[$r] = array(
238  's.rowid'=>"company", 's.nom'=>'company', 'ps.nom'=>'company', 's.address'=>'company', 's.zip'=>'company', 's.town'=>'company', 'd.nom'=>'company', 'co.label'=>'company',
239  'co.code'=>'company', 's.phone'=>'company', 's.siren'=>'company', 's.ape'=>'company', 's.idprof4'=>'company', 's.siret'=>'company', 'c.rowid'=>"order",
240  'c.ref'=>"order", 'c.ref_client'=>"order", 'c.fk_soc'=>"order", 'c.date_creation'=>"order", 'c.date_commande'=>"order", 'c.amount_ht'=>"order",
241  'c.total_ht'=>"order", 'c.total_ttc'=>"order", 'c.facture'=>"order", 'c.fk_statut'=>"order", 'c.note'=>"order",
242  'c.date_livraison'=>"order", 'pj.ref'=>'project', 'cd.rowid'=>'order_line', 'cd.description'=>"order_line",
243  'cd.product_type'=>'order_line', 'cd.tva_tx'=>"order_line", 'cd.qty'=>"order_line", 'cd.total_ht'=>"order_line", 'cd.total_tva'=>"order_line",
244  'cd.total_ttc'=>"order_line", 'p.rowid'=>'product', 'p.ref'=>'product', 'p.label'=>'product'
245  );
246  $this->export_dependencies_array[$r] = array('order_line'=>'cd.rowid', 'product'=>'cd.rowid'); // To add unique key if we ask a field of a child to avoid the DISTINCT to discard them
247  $keyforselect = 'commande';
248  $keyforelement = 'order';
249  $keyforaliasextra = 'extra';
250  include DOL_DOCUMENT_ROOT.'/core/extrafieldsinexport.inc.php';
251  $keyforselect = 'commandedet';
252  $keyforelement = 'order_line';
253  $keyforaliasextra = 'extra2';
254  include DOL_DOCUMENT_ROOT.'/core/extrafieldsinexport.inc.php';
255  $keyforselect = 'product';
256  $keyforelement = 'product';
257  $keyforaliasextra = 'extra3';
258  include DOL_DOCUMENT_ROOT.'/core/extrafieldsinexport.inc.php';
259  $keyforselect = 'societe';
260  $keyforelement = 'company';
261  $keyforaliasextra = 'extra4';
262  include DOL_DOCUMENT_ROOT.'/core/extrafieldsinexport.inc.php';
263  $this->export_sql_start[$r] = 'SELECT DISTINCT ';
264  $this->export_sql_end[$r] = ' FROM '.MAIN_DB_PREFIX.'societe as s';
265  $this->export_sql_end[$r] .= ' LEFT JOIN '.MAIN_DB_PREFIX.'societe_extrafields as extra4 ON s.rowid = extra4.fk_object';
266  $this->export_sql_end[$r] .= ' LEFT JOIN '.MAIN_DB_PREFIX.'societe as ps ON ps.rowid = s.parent';
267  if (empty($user->rights->societe->client->voir)) {
268  $this->export_sql_end[$r] .= ' LEFT JOIN '.MAIN_DB_PREFIX.'societe_commerciaux as sc ON sc.fk_soc = s.rowid';
269  }
270  $this->export_sql_end[$r] .= ' LEFT JOIN '.MAIN_DB_PREFIX.'c_departements as d ON s.fk_departement = d.rowid';
271  $this->export_sql_end[$r] .= ' LEFT JOIN '.MAIN_DB_PREFIX.'c_country as co ON s.fk_pays = co.rowid,';
272  $this->export_sql_end[$r] .= ' '.MAIN_DB_PREFIX.'commande as c';
273  $this->export_sql_end[$r] .= ' LEFT JOIN '.MAIN_DB_PREFIX.'projet as pj ON c.fk_projet = pj.rowid';
274  $this->export_sql_end[$r] .= ' LEFT JOIN '.MAIN_DB_PREFIX.'user as uc ON c.fk_user_author = uc.rowid';
275  $this->export_sql_end[$r] .= ' LEFT JOIN '.MAIN_DB_PREFIX.'user as uv ON c.fk_user_valid = uv.rowid';
276  $this->export_sql_end[$r] .= ' LEFT JOIN '.MAIN_DB_PREFIX.'commande_extrafields as extra ON c.rowid = extra.fk_object';
277  $this->export_sql_end[$r] .= ' , '.MAIN_DB_PREFIX.'commandedet as cd';
278  $this->export_sql_end[$r] .= ' LEFT JOIN '.MAIN_DB_PREFIX.'commandedet_extrafields as extra2 on cd.rowid = extra2.fk_object';
279  $this->export_sql_end[$r] .= ' LEFT JOIN '.MAIN_DB_PREFIX.'product as p on cd.fk_product = p.rowid';
280  $this->export_sql_end[$r] .= ' LEFT JOIN '.MAIN_DB_PREFIX.'product_extrafields as extra3 on p.rowid = extra3.fk_object';
281  $this->export_sql_end[$r] .= ' WHERE c.fk_soc = s.rowid AND c.rowid = cd.fk_commande';
282  $this->export_sql_end[$r] .= ' AND c.entity IN ('.getEntity('commande').')';
283  if (empty($user->rights->societe->client->voir)) {
284  $this->export_sql_end[$r] .= ' AND sc.fk_user = '.(empty($user) ? 0 : $user->id);
285  }
286 
287  // Imports
288  //--------
289  $r = 0;
290  //Import Order Header
291 
292  $r++;
293  $this->import_code[$r] = 'commande_'.$r;
294  $this->import_label[$r] = 'CustomersOrders';
295  $this->import_icon[$r] = $this->picto;
296  $this->import_entities_array[$r] = array();
297  $this->import_tables_array[$r] = array('c' => MAIN_DB_PREFIX.'commande', 'extra' => MAIN_DB_PREFIX.'commande_extrafields');
298  $this->import_tables_creator_array[$r] = array('c' => 'fk_user_author'); // Fields to store import user id
299  $import_sample = array();
300  $this->import_fields_array[$r] = array(
301  'c.ref' => 'Ref*',
302  'c.ref_client' => 'RefCustomer',
303  'c.fk_soc' => 'ThirdPartyName*',
304  'c.fk_projet' => 'ProjectId',
305  'c.date_creation' => 'DateCreation',
306  'c.date_valid' => 'DateValidation',
307  'c.date_commande' => 'OrderDate*',
308  'c.fk_user_modif' => 'ModifiedById',
309  'c.fk_user_valid' => 'ValidatedById',
310  'c.total_tva' => 'TotalTVA',
311  'c.total_ht' => 'TotalHT',
312  'c.total_ttc' => 'TotalTTC',
313  'c.note_private' => 'NotePrivate',
314  'c.note_public' => 'Note',
315  'c.facture' => 'Invoice(1/0)',
316  'c.date_livraison' => 'DeliveryDate',
317  'c.fk_cond_reglement' => 'Payment Condition',
318  'c.fk_mode_reglement' => 'Payment Mode',
319  'c.model_pdf' => 'Model',
320  'c.fk_statut' => 'Status*'
321  );
322 
323  if (!empty($conf->multicurrency->enabled)) {
324  $this->import_fields_array[$r]['c.multicurrency_code'] = 'Currency';
325  $this->import_fields_array[$r]['c.multicurrency_tx'] = 'CurrencyRate';
326  $this->import_fields_array[$r]['c.multicurrency_total_ht'] = 'MulticurrencyAmountHT';
327  $this->import_fields_array[$r]['c.multicurrency_total_tva'] = 'MulticurrencyAmountVAT';
328  $this->import_fields_array[$r]['c.multicurrency_total_ttc'] = 'MulticurrencyAmountTTC';
329  }
330  $import_extrafield_sample = array();
331  $keyforselect = 'commande';
332  $keyforelement = 'order';
333  $keyforaliasextra = 'extra';
334  include DOL_DOCUMENT_ROOT.'/core/extrafieldsinimport.inc.php';
335 
336  $this->import_fieldshidden_array[$r] = array('extra.fk_object' => 'lastrowid-'.MAIN_DB_PREFIX.'commande');
337  $this->import_regex_array[$r] = array(
338  'c.multicurrency_code' => 'code@'.MAIN_DB_PREFIX.'multicurrency'
339  );
340  $this->import_examplevalues_array[$r] = array_merge($import_sample, $import_extrafield_sample);
341  $this->import_updatekeys_array[$r] = array('c.ref' => 'Ref');
342  $this->import_convertvalue_array[$r] = array(
343  'c.ref' => array(
344  'rule'=>'getrefifauto',
345  'class'=>(empty($conf->global->COMMANDE_ADDON) ? 'mod_commande_marbre' : $conf->global->COMMANDE_ADDON),
346  'path'=>"/core/modules/commande/".(empty($conf->global->COMMANDE_ADDON) ? 'mod_commande_marbre' : $conf->global->COMMANDE_ADDON).'.php',
347  'classobject'=>'Commande',
348  'pathobject'=>'/commande/class/commande.class.php',
349  ),
350  'c.fk_soc' => array(
351  'rule' => 'fetchidfromref',
352  'file' => '/societe/class/societe.class.php',
353  'class' => 'Societe',
354  'method' => 'fetch',
355  'element' => 'ThirdParty'
356  ),
357  'c.fk_user_valid' => array(
358  'rule' => 'fetchidfromref',
359  'file' => '/user/class/user.class.php',
360  'class' => 'User',
361  'method' => 'fetch',
362  'element' => 'user'
363  ),
364  'c.fk_mode_reglement' => array(
365  'rule' => 'fetchidfromcodeorlabel',
366  'file' => '/compta/paiement/class/cpaiement.class.php',
367  'class' => 'Cpaiement',
368  'method' => 'fetch',
369  'element' => 'cpayment'
370  ),
371  );
372 
373  //Import Order Lines
374  $r++;
375  $this->import_code[$r] = 'commande_lines_'.$r;
376  $this->import_label[$r] = 'SaleOrderLines';
377  $this->import_icon[$r] = $this->picto;
378  $this->import_entities_array[$r] = array();
379  $this->import_tables_array[$r] = array('cd' => MAIN_DB_PREFIX.'commandedet', 'extra' => MAIN_DB_PREFIX.'commandedet_extrafields');
380  $this->import_fields_array[$r] = array(
381  'cd.fk_commande' => 'CustomerOrder*',
382  'cd.fk_parent_line' => 'ParentLine',
383  'cd.fk_product' => 'IdProduct',
384  'cd.description' => 'LineDescription',
385  'cd.tva_tx' => 'LineVATRate',
386  'cd.qty' => 'LineQty',
387  'cd.remise_percent' => 'Reduc. Percent',
388  'cd.price' => 'Price',
389  'cd.subprice' => 'Sub Price',
390  'cd.total_ht' => 'LineTotalHT',
391  'cd.total_tva' => 'LineTotalVAT',
392  'cd.total_ttc' => 'LineTotalTTC',
393  'cd.product_type' => 'TypeOfLineServiceOrProduct',
394  'cd.date_start' => 'Start Date',
395  'cd.date_end' => 'End Date',
396  'cd.buy_price_ht' => 'LineBuyPriceHT',
397  'cd.rang' => 'LinePosition'
398  );
399 
400  if (!empty($conf->multicurrency->enabled)) {
401  $this->import_fields_array[$r]['cd.multicurrency_code'] = 'Currency';
402  $this->import_fields_array[$r]['cd.multicurrency_subprice'] = 'CurrencyRate';
403  $this->import_fields_array[$r]['cd.multicurrency_total_ht'] = 'MulticurrencyAmountHT';
404  $this->import_fields_array[$r]['cd.multicurrency_total_tva'] = 'MulticurrencyAmountVAT';
405  $this->import_fields_array[$r]['cd.multicurrency_total_ttc'] = 'MulticurrencyAmountTTC';
406  }
407 
408  $import_extrafield_sample = array();
409  $keyforselect = 'commandedet';
410  $keyforelement = 'orderline';
411  $keyforaliasextra = 'extra';
412  include DOL_DOCUMENT_ROOT.'/core/extrafieldsinimport.inc.php';
413 
414  $this->import_fieldshidden_array[$r] = ['extra.fk_object' => 'lastrowid-'.MAIN_DB_PREFIX.'commandedet'];
415  $this->import_regex_array[$r] = [
416  'cd.product_type' => '[0|1]$',
417  'cd.fk_product' => 'rowid@'.MAIN_DB_PREFIX.'product',
418  'cd.multicurrency_code' => 'code@'.MAIN_DB_PREFIX.'multicurrency'
419  ];
420  $this->import_updatekeys_array[$r] = ['cd.fk_commande' => 'Sales Order Id', 'cd.fk_product' => 'Product Id'];
421  $this->import_convertvalue_array[$r] = [
422  'cd.fk_commande' => [
423  'rule' => 'fetchidfromref',
424  'file' => '/commande/class/commande.class.php',
425  'class' => 'Commande',
426  'method' => 'fetch',
427  'element' => 'commande'
428  ],
429  ];
430  }
431 
432 
441  public function init($options = '')
442  {
443  global $conf, $langs;
444 
445  // Permissions
446  $this->remove($options);
447 
448  //ODT template
449  $src = DOL_DOCUMENT_ROOT.'/install/doctemplates/orders/template_order.odt';
450  $dirodt = DOL_DATA_ROOT.'/doctemplates/orders';
451  $dest = $dirodt.'/template_order.odt';
452 
453  if (file_exists($src) && !file_exists($dest)) {
454  require_once DOL_DOCUMENT_ROOT.'/core/lib/files.lib.php';
455  dol_mkdir($dirodt);
456  $result = dol_copy($src, $dest, 0, 0);
457  if ($result < 0) {
458  $langs->load("errors");
459  $this->error = $langs->trans('ErrorFailToCopyFile', $src, $dest);
460  return 0;
461  }
462  }
463 
464  $sql = array(
465  "DELETE FROM ".MAIN_DB_PREFIX."document_model WHERE nom = '".$this->db->escape($this->const[0][2])."' AND type = 'order' AND entity = ".((int) $conf->entity),
466  "INSERT INTO ".MAIN_DB_PREFIX."document_model (nom, type, entity) VALUES('".$this->db->escape($this->const[0][2])."', 'order', ".((int) $conf->entity).")"
467  );
468 
469  return $this->_init($sql, $options);
470  }
471 }
db
$conf db
API class for accounts.
Definition: inc.php:41
description
print *****$script_file(".$version.") pid cd cd cd description as description
Definition: email_expire_services_to_customers.php:83
modCommande\__construct
__construct($db)
Constructor.
Definition: modCommande.class.php:47
name
$conf db name
Definition: repair.php:122
dol_copy
dol_copy($srcfile, $destfile, $newmask=0, $overwriteifexists=1)
Copy a file to another file.
Definition: files.lib.php:703
getEntity
getEntity($element, $shared=1, $currentobject=null)
Get list of entity id to use.
Definition: functions.lib.php:148
DolibarrModules\_init
_init($array_sql, $options='')
Enables a module.
Definition: DolibarrModules.class.php:383
modCommande\init
init($options='')
Function called when module is enabled.
Definition: modCommande.class.php:441
modCommande
Class to describe module customer orders.
Definition: modCommande.class.php:39
dol_mkdir
dol_mkdir($dir, $dataroot='', $newmask='')
Creation of a directory (this can create recursive subdir)
Definition: functions.lib.php:6603
DolibarrModules
Class DolibarrModules.
Definition: DolibarrModules.class.php:37