dolibarr  21.0.0-alpha
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  * Copyright (C) 2024 MDW <mdeweerd@users.noreply.github.com>
11  *
12  * This program is free software; you can redistribute it and/or modify
13  * it under the terms of the GNU General Public License as published by
14  * the Free Software Foundation; either version 3 of the License, or
15  * (at your option) any later version.
16  *
17  * This program is distributed in the hope that it will be useful,
18  * but WITHOUT ANY WARRANTY; without even the implied warranty of
19  * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the
20  * GNU General Public License for more details.
21  *
22  * You should have received a copy of the GNU General Public License
23  * along with this program. If not, see <https://www.gnu.org/licenses/>.
24  */
25 
34 include_once DOL_DOCUMENT_ROOT.'/core/modules/DolibarrModules.class.php';
35 
36 
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("order.php");
70 
71  // Dependencies
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] = "eratosthene";
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] = 85;
144  $this->rights[$r][1] = 'Generate the documents sales orders';
145  $this->rights[$r][2] = 'd';
146  $this->rights[$r][3] = 0;
147  $this->rights[$r][4] = 'order_advance';
148  $this->rights[$r][5] = 'generetedoc';
149 
150  $r++;
151  $this->rights[$r][0] = 86;
152  $this->rights[$r][1] = 'Send sales orders by email';
153  $this->rights[$r][2] = 'd';
154  $this->rights[$r][3] = 0;
155  $this->rights[$r][4] = 'order_advance';
156  $this->rights[$r][5] = 'send';
157 
158  $r++;
159  $this->rights[$r][0] = 87;
160  $this->rights[$r][1] = 'Close 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] = 'close';
165 
166  $r++;
167  $this->rights[$r][0] = 88;
168  $this->rights[$r][1] = 'Cancel sale orders';
169  $this->rights[$r][2] = 'd';
170  $this->rights[$r][3] = 0;
171  $this->rights[$r][4] = 'order_advance';
172  $this->rights[$r][5] = 'annuler';
173 
174  $r++;
175  $this->rights[$r][0] = 89;
176  $this->rights[$r][1] = 'Delete sales orders';
177  $this->rights[$r][2] = 'd';
178  $this->rights[$r][3] = 0;
179  $this->rights[$r][4] = 'supprimer';
180 
181  $r++;
182  $this->rights[$r][0] = 1421;
183  $this->rights[$r][1] = 'Export sales orders and attributes';
184  $this->rights[$r][2] = 'r';
185  $this->rights[$r][3] = 0;
186  $this->rights[$r][4] = 'commande';
187  $this->rights[$r][5] = 'export';
188 
189 
190  // Menus
191  //-------
192  $this->menu = 1; // This module add menu entries. They are coded into menu manager.
193 
194 
195  // Exports
196  //--------
197  $r = 0;
198 
199  $r++;
200  $this->export_code[$r] = $this->rights_class.'_'.$r;
201  $this->export_label[$r] = 'CustomersOrdersAndOrdersLines'; // Translation key (used only if key ExportDataset_xxx_z not found)
202  $this->export_permission[$r] = array(array("commande", "commande", "export"));
203  $this->export_fields_array[$r] = array(
204  's.rowid' => "IdCompany", 's.nom' => 'CompanyName', 'ps.nom' => 'ParentCompany', 's.code_client' => 'CustomerCode', 's.address' => 'Address', 's.zip' => 'Zip', 's.town' => 'Town', 'd.nom' => 'State', 'co.label' => 'Country',
205  'co.code' => "CountryCode", 's.phone' => 'Phone', 's.siren' => 'ProfId1', 's.siret' => 'ProfId2', 's.ape' => 'ProfId3', 's.idprof4' => 'ProfId4', 'c.rowid' => "Id",
206  'c.ref' => "Ref", 'c.ref_client' => "RefCustomer", 'c.fk_soc' => "IdCompany", 'c.date_creation' => "DateCreation", 'c.date_commande' => "OrderDate",
207  'c.date_livraison' => "DateDeliveryPlanned", 'c.amount_ht' => "Amount", 'c.total_ht' => "TotalHT",
208  'c.total_ttc' => "TotalTTC", 'c.facture' => "Billed", 'c.fk_statut' => 'Status', 'c.note_public' => "Note", 'sm.code' => 'SendingMethod',
209  'c.fk_user_author' => 'CreatedById', 'uc.login' => 'CreatedByLogin', 'c.fk_user_valid' => 'ValidatedById', 'uv.login' => 'ValidatedByLogin',
210  'pj.ref' => 'ProjectRef', 'cd.rowid' => 'LineId', 'cd.description' => "LineDescription", 'cd.product_type' => 'TypeOfLineServiceOrProduct',
211  'cd.tva_tx' => "LineVATRate", 'cd.qty' => "LineQty", 'cd.total_ht' => "LineTotalHT", 'cd.total_tva' => "LineTotalVAT", 'cd.total_ttc' => "LineTotalTTC",
212  'p.rowid' => 'ProductId', 'p.ref' => 'ProductRef', 'p.label' => 'ProductLabel',
213  'cir.label'=>'Source',
214  );
215  if (isModEnabled("multicurrency")) {
216  $this->export_fields_array[$r]['c.multicurrency_code'] = 'Currency';
217  $this->export_fields_array[$r]['c.multicurrency_tx'] = 'CurrencyRate';
218  $this->export_fields_array[$r]['c.multicurrency_total_ht'] = 'MulticurrencyAmountHT';
219  $this->export_fields_array[$r]['c.multicurrency_total_tva'] = 'MulticurrencyAmountVAT';
220  $this->export_fields_array[$r]['c.multicurrency_total_ttc'] = 'MulticurrencyAmountTTC';
221  }
222  // Add multicompany field
223  if (getDolGlobalString('MULTICOMPANY_ENTITY_IN_EXPORT_IF_SHARED')) {
224  $nbofallowedentities = count(explode(',', getEntity('commande')));
225  if (isModEnabled('multicompany') && $nbofallowedentities > 1) {
226  $this->export_fields_array[$r]['c.entity'] = 'Entity';
227  }
228  }
229  //$this->export_TypeFields_array[$r]=array(
230  // 's.rowid'=>"Numeric",'s.nom'=>'Text','s.address'=>'Text','s.zip'=>'Text','s.town'=>'Text','co.label'=>'List:c_country:label:label',
231  // '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",
232  // 'c.date_creation'=>"Date",'c.date_commande'=>"Date",'c.amount_ht'=>"Numeric",'c.total_ht'=>"Numeric",
233  // 'c.total_ttc'=>"Numeric",'c.facture'=>"Boolean",'c.fk_statut'=>'Status','c.note_public'=>"Text",'c.date_livraison'=>'Date','cd.description'=>"Text",
234  // 'cd.product_type'=>'Boolean','cd.tva_tx'=>"Numeric",'cd.qty'=>"Numeric",'cd.total_ht'=>"Numeric",'cd.total_tva'=>"Numeric",'cd.total_ttc'=>"Numeric",
235  // 'p.rowid'=>'List:product:ref','p.ref'=>'Text','p.label'=>'Text'
236  //);
237  $this->export_TypeFields_array[$r] = array(
238  's.nom' => 'Text', 'ps.nom' => 'Text', 's.code_client' => 'Text', 's.address' => 'Text', 's.zip' => 'Text', 's.town' => 'Text', 'co.label' => 'List:c_country:label:label', 'co.code' => 'Text', 's.phone' => 'Text',
239  's.siren' => 'Text', 's.siret' => 'Text', 's.ape' => 'Text', 's.idprof4' => 'Text', 'c.ref' => "Text", 'c.ref_client' => "Text", 'c.date_creation' => "Date",
240  'c.date_commande' => "Date", 'c.date_livraison' => "Date", 'sm.code' => "Text", 'c.amount_ht' => "Numeric", 'c.total_ht' => "Numeric",
241  'c.total_ttc' => "Numeric", 'c.facture' => "Boolean", 'c.fk_statut' => 'Status', 'c.note_public' => "Text", 'pj.ref' => 'Text',
242  'cd.description' => "Text", 'cd.product_type' => 'Boolean', 'cd.tva_tx' => "Numeric", 'cd.qty' => "Numeric", 'cd.total_ht' => "Numeric", 'cd.total_tva' => "Numeric",
243  'cd.total_ttc' => "Numeric", 'p.rowid' => 'List:product:ref::product', 'p.ref' => 'Text', 'p.label' => 'Text', 'd.nom' => 'Text',
244  'c.entity' => 'List:entity:label:rowid',
245  'cir.label'=>'Text',
246  );
247  $this->export_entities_array[$r] = array(
248  's.rowid' => "company", 's.nom' => 'company', 'ps.nom' => 'company', 's.code_client' => 'company', 's.address' => 'company', 's.zip' => 'company', 's.town' => 'company', 'd.nom' => 'company', 'co.label' => 'company',
249  'co.code' => 'company', 's.phone' => 'company', 's.siren' => 'company', 's.ape' => 'company', 's.idprof4' => 'company', 's.siret' => 'company', 'c.rowid' => "order",
250  'c.ref' => "order", 'c.ref_client' => "order", 'c.fk_soc' => "order", 'c.date_creation' => "order", 'c.date_commande' => "order", 'c.amount_ht' => "order",
251  'c.total_ht' => "order", 'c.total_ttc' => "order", 'c.facture' => "order", 'c.fk_statut' => "order", 'c.note' => "order",
252  'c.date_livraison' => "order", 'sm.code' => "order", 'pj.ref' => 'project', 'cd.rowid' => 'order_line', 'cd.description' => "order_line",
253  'cd.product_type' => 'order_line', 'cd.tva_tx' => "order_line", 'cd.qty' => "order_line", 'cd.total_ht' => "order_line", 'cd.total_tva' => "order_line",
254  'cd.total_ttc' => "order_line", 'p.rowid' => 'product', 'p.ref' => 'product', 'p.label' => 'product'
255  );
256  $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
257  $keyforselect = 'commande';
258  $keyforelement = 'order';
259  $keyforaliasextra = 'extra';
260  include DOL_DOCUMENT_ROOT.'/core/extrafieldsinexport.inc.php';
261  $keyforselect = 'commandedet';
262  $keyforelement = 'order_line';
263  $keyforaliasextra = 'extra2';
264  include DOL_DOCUMENT_ROOT.'/core/extrafieldsinexport.inc.php';
265  $keyforselect = 'product';
266  $keyforelement = 'product';
267  $keyforaliasextra = 'extra3';
268  include DOL_DOCUMENT_ROOT.'/core/extrafieldsinexport.inc.php';
269  $keyforselect = 'societe';
270  $keyforelement = 'company';
271  $keyforaliasextra = 'extra4';
272  include DOL_DOCUMENT_ROOT.'/core/extrafieldsinexport.inc.php';
273  $this->export_sql_start[$r] = 'SELECT DISTINCT ';
274  $this->export_sql_end[$r] = ' FROM '.MAIN_DB_PREFIX.'societe as s';
275  $this->export_sql_end[$r] .= ' LEFT JOIN '.MAIN_DB_PREFIX.'societe_extrafields as extra4 ON s.rowid = extra4.fk_object';
276  $this->export_sql_end[$r] .= ' LEFT JOIN '.MAIN_DB_PREFIX.'societe as ps ON ps.rowid = s.parent';
277  if (!empty($user) && !$user->hasRight('societe', 'client', 'voir')) {
278  $this->export_sql_end[$r] .= ' LEFT JOIN '.MAIN_DB_PREFIX.'societe_commerciaux as sc ON sc.fk_soc = s.rowid';
279  }
280  $this->export_sql_end[$r] .= ' LEFT JOIN '.MAIN_DB_PREFIX.'c_departements as d ON s.fk_departement = d.rowid';
281  $this->export_sql_end[$r] .= ' LEFT JOIN '.MAIN_DB_PREFIX.'c_country as co ON s.fk_pays = co.rowid,';
282  $this->export_sql_end[$r] .= ' '.MAIN_DB_PREFIX.'commande as c';
283  $this->export_sql_end[$r] .= ' LEFT JOIN '.MAIN_DB_PREFIX.'c_shipment_mode as sm ON c.fk_shipping_method = sm.rowid';
284  $this->export_sql_end[$r] .= ' LEFT JOIN '.MAIN_DB_PREFIX.'c_input_reason as cir ON cir.rowid = c.fk_input_reason';
285  $this->export_sql_end[$r] .= ' LEFT JOIN '.MAIN_DB_PREFIX.'projet as pj ON c.fk_projet = pj.rowid';
286  $this->export_sql_end[$r] .= ' LEFT JOIN '.MAIN_DB_PREFIX.'user as uc ON c.fk_user_author = uc.rowid';
287  $this->export_sql_end[$r] .= ' LEFT JOIN '.MAIN_DB_PREFIX.'user as uv ON c.fk_user_valid = uv.rowid';
288  $this->export_sql_end[$r] .= ' LEFT JOIN '.MAIN_DB_PREFIX.'commande_extrafields as extra ON c.rowid = extra.fk_object';
289  $this->export_sql_end[$r] .= ' , '.MAIN_DB_PREFIX.'commandedet as cd';
290  $this->export_sql_end[$r] .= ' LEFT JOIN '.MAIN_DB_PREFIX.'commandedet_extrafields as extra2 on cd.rowid = extra2.fk_object';
291  $this->export_sql_end[$r] .= ' LEFT JOIN '.MAIN_DB_PREFIX.'product as p on cd.fk_product = p.rowid';
292  $this->export_sql_end[$r] .= ' LEFT JOIN '.MAIN_DB_PREFIX.'product_extrafields as extra3 on p.rowid = extra3.fk_object';
293  $this->export_sql_end[$r] .= ' WHERE c.fk_soc = s.rowid AND c.rowid = cd.fk_commande';
294  $this->export_sql_end[$r] .= ' AND c.entity IN ('.getEntity('commande').')';
295  if (!empty($user) && !$user->hasRight('societe', 'client', 'voir')) {
296  $this->export_sql_end[$r] .= ' AND sc.fk_user = '.(empty($user) ? 0 : $user->id);
297  }
298 
299  // Imports
300  //--------
301  $r = 0;
302  //Import Order Header
303 
304  $r++;
305  $this->import_code[$r] = 'commande_'.$r;
306  $this->import_label[$r] = 'CustomersOrders';
307  $this->import_icon[$r] = $this->picto;
308  $this->import_entities_array[$r] = array();
309  $this->import_tables_array[$r] = array('c' => MAIN_DB_PREFIX.'commande', 'extra' => MAIN_DB_PREFIX.'commande_extrafields');
310  $this->import_tables_creator_array[$r] = array('c' => 'fk_user_author'); // Fields to store import user id
311  $import_sample = array('c.facture' => '0 or 1');
312  $this->import_fields_array[$r] = array(
313  'c.ref' => 'Ref*',
314  'c.ref_client' => 'RefCustomer',
315  'c.fk_soc' => 'ThirdPartyName*',
316  'c.fk_projet' => 'ProjectId',
317  'c.date_creation' => 'DateCreation',
318  'c.date_valid' => 'DateValidation',
319  'c.date_commande' => 'OrderDate*',
320  'c.fk_user_modif' => 'ModifiedById',
321  'c.fk_user_valid' => 'ValidatedById',
322  'c.total_tva' => 'TotalTVA',
323  'c.total_ht' => 'TotalHT',
324  'c.total_ttc' => 'TotalTTC',
325  'c.note_private' => 'NotePrivate',
326  'c.note_public' => 'Note',
327  'c.facture' => 'Billed',
328  'c.date_livraison' => 'DeliveryDate',
329  'c.fk_cond_reglement' => 'Payment Condition',
330  'c.fk_mode_reglement' => 'Payment Mode',
331  'c.model_pdf' => 'Model',
332  'c.fk_statut' => 'Status*'
333  );
334 
335  if (isModEnabled("multicurrency")) {
336  $this->import_fields_array[$r]['c.multicurrency_code'] = 'Currency';
337  $this->import_fields_array[$r]['c.multicurrency_tx'] = 'CurrencyRate';
338  $this->import_fields_array[$r]['c.multicurrency_total_ht'] = 'MulticurrencyAmountHT';
339  $this->import_fields_array[$r]['c.multicurrency_total_tva'] = 'MulticurrencyAmountVAT';
340  $this->import_fields_array[$r]['c.multicurrency_total_ttc'] = 'MulticurrencyAmountTTC';
341  }
342  $import_extrafield_sample = array();
343  $keyforselect = 'commande';
344  $keyforelement = 'order';
345  $keyforaliasextra = 'extra';
346  include DOL_DOCUMENT_ROOT.'/core/extrafieldsinimport.inc.php';
347 
348  $this->import_fieldshidden_array[$r] = array('extra.fk_object' => 'lastrowid-'.MAIN_DB_PREFIX.'commande');
349  $this->import_regex_array[$r] = array(
350  'c.multicurrency_code' => 'code@'.MAIN_DB_PREFIX.'multicurrency'
351  );
352  $this->import_examplevalues_array[$r] = array_merge($import_sample, $import_extrafield_sample);
353  $this->import_updatekeys_array[$r] = array('c.ref' => 'Ref');
354  $this->import_convertvalue_array[$r] = array(
355  'c.ref' => array(
356  'rule' => 'getrefifauto',
357  'class' => (!getDolGlobalString('COMMANDE_ADDON') ? 'mod_commande_marbre' : $conf->global->COMMANDE_ADDON),
358  'path' => "/core/modules/commande/".(!getDolGlobalString('COMMANDE_ADDON') ? 'mod_commande_marbre' : $conf->global->COMMANDE_ADDON).'.php',
359  'classobject' => 'Commande',
360  'pathobject' => '/commande/class/commande.class.php',
361  ),
362  'c.fk_soc' => array(
363  'rule' => 'fetchidfromref',
364  'file' => '/societe/class/societe.class.php',
365  'class' => 'Societe',
366  'method' => 'fetch',
367  'element' => 'ThirdParty'
368  ),
369  'c.fk_user_valid' => array(
370  'rule' => 'fetchidfromref',
371  'file' => '/user/class/user.class.php',
372  'class' => 'User',
373  'method' => 'fetch',
374  'element' => 'user'
375  ),
376  'c.fk_mode_reglement' => array(
377  'rule' => 'fetchidfromcodeorlabel',
378  'file' => '/compta/paiement/class/cpaiement.class.php',
379  'class' => 'Cpaiement',
380  'method' => 'fetch',
381  'element' => 'cpayment'
382  ),
383  );
384 
385  //Import Order Lines
386  $r++;
387  $this->import_code[$r] = 'commande_lines_'.$r;
388  $this->import_label[$r] = 'SaleOrderLines';
389  $this->import_icon[$r] = $this->picto;
390  $this->import_entities_array[$r] = array();
391  $this->import_tables_array[$r] = array('cd' => MAIN_DB_PREFIX.'commandedet', 'extra' => MAIN_DB_PREFIX.'commandedet_extrafields');
392  $this->import_fields_array[$r] = array(
393  'cd.fk_commande' => 'CustomerOrder*',
394  'cd.fk_parent_line' => 'ParentLine',
395  'cd.fk_product' => 'IdProduct',
396  'cd.description' => 'LineDescription',
397  'cd.tva_tx' => 'LineVATRate',
398  'cd.qty' => 'LineQty',
399  'cd.remise_percent' => 'Reduc. Percent',
400  'cd.price' => 'Price',
401  'cd.subprice' => 'Sub Price',
402  'cd.total_ht' => 'LineTotalHT',
403  'cd.total_tva' => 'LineTotalVAT',
404  'cd.total_ttc' => 'LineTotalTTC',
405  'cd.product_type' => 'TypeOfLineServiceOrProduct',
406  'cd.date_start' => 'Start Date',
407  'cd.date_end' => 'End Date',
408  'cd.buy_price_ht' => 'LineBuyPriceHT',
409  'cd.rang' => 'LinePosition'
410  );
411 
412  if (isModEnabled("multicurrency")) {
413  $this->import_fields_array[$r]['cd.multicurrency_code'] = 'Currency';
414  $this->import_fields_array[$r]['cd.multicurrency_subprice'] = 'CurrencyRate';
415  $this->import_fields_array[$r]['cd.multicurrency_total_ht'] = 'MulticurrencyAmountHT';
416  $this->import_fields_array[$r]['cd.multicurrency_total_tva'] = 'MulticurrencyAmountVAT';
417  $this->import_fields_array[$r]['cd.multicurrency_total_ttc'] = 'MulticurrencyAmountTTC';
418  }
419 
420  $import_extrafield_sample = array();
421  $keyforselect = 'commandedet';
422  $keyforelement = 'orderline';
423  $keyforaliasextra = 'extra';
424  include DOL_DOCUMENT_ROOT.'/core/extrafieldsinimport.inc.php';
425 
426  $this->import_fieldshidden_array[$r] = ['extra.fk_object' => 'lastrowid-'.MAIN_DB_PREFIX.'commandedet'];
427  $this->import_regex_array[$r] = [
428  'cd.product_type' => '[0|1]$',
429  'cd.fk_product' => 'rowid@'.MAIN_DB_PREFIX.'product',
430  'cd.multicurrency_code' => 'code@'.MAIN_DB_PREFIX.'multicurrency'
431  ];
432  $this->import_updatekeys_array[$r] = ['cd.fk_commande' => 'Sales Order Id', 'cd.fk_product' => 'Product Id'];
433  $this->import_convertvalue_array[$r] = [
434  'cd.fk_commande' => [
435  'rule' => 'fetchidfromref',
436  'file' => '/commande/class/commande.class.php',
437  'class' => 'Commande',
438  'method' => 'fetch',
439  'element' => 'commande'
440  ],
441  ];
442  }
443 
444 
453  public function init($options = '')
454  {
455  global $conf, $langs;
456 
457  // Permissions
458  $this->remove($options);
459 
460  //ODT template
461  $src = DOL_DOCUMENT_ROOT.'/install/doctemplates/orders/template_order.odt';
462  $dirodt = DOL_DATA_ROOT.'/doctemplates/orders';
463  $dest = $dirodt.'/template_order.odt';
464 
465  if (file_exists($src) && !file_exists($dest)) {
466  require_once DOL_DOCUMENT_ROOT.'/core/lib/files.lib.php';
467  dol_mkdir($dirodt);
468  $result = dol_copy($src, $dest, 0, 0);
469  if ($result < 0) {
470  $langs->load("errors");
471  $this->error = $langs->trans('ErrorFailToCopyFile', $src, $dest);
472  return 0;
473  }
474  }
475 
476  $sql = array(
477  "DELETE FROM ".MAIN_DB_PREFIX."document_model WHERE nom = '".$this->db->escape($this->const[0][2])."' AND type = 'order' AND entity = ".((int) $conf->entity),
478  "INSERT INTO ".MAIN_DB_PREFIX."document_model (nom, type, entity) VALUES('".$this->db->escape($this->const[0][2])."', 'order', ".((int) $conf->entity).")"
479  );
480 
481  return $this->_init($sql, $options);
482  }
483 }
Class DolibarrModules.
_init($array_sql, $options='')
Enables a module.
Class to describe module Sales Orders.
__construct($db)
Constructor.
init($options='')
Function called when module is enabled.
if(isModEnabled('invoice') && $user->hasRight('facture', 'lire')) if((isModEnabled('fournisseur') &&!getDolGlobalString('MAIN_USE_NEW_SUPPLIERMOD') && $user->hasRight("fournisseur", "facture", "lire"))||(isModEnabled('supplier_invoice') && $user->hasRight("supplier_invoice", "lire"))) if(isModEnabled('don') && $user->hasRight('don', 'lire')) if(isModEnabled('tax') && $user->hasRight('tax', 'charges', 'lire')) if(isModEnabled('invoice') &&isModEnabled('order') && $user->hasRight("commande", "lire") &&!getDolGlobalString('WORKFLOW_DISABLE_CREATE_INVOICE_FROM_ORDER')) $sql
Social contributions to pay.
Definition: index.php:751
print *****$script_file(".$version.") pid 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.
Definition: files.lib.php:767
getDolGlobalString($key, $default='')
Return dolibarr global constant string value.
isModEnabled($module)
Is Dolibarr module enabled.
getEntity($element, $shared=1, $currentobject=null)
Get list of entity id to use.
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