33 include_once DOL_DOCUMENT_ROOT.
'/core/modules/DolibarrModules.class.php';
54 $this->family =
"crm";
55 $this->module_position =
'11';
57 $this->
name = preg_replace(
'/^mod/i',
'', get_class($this));
58 $this->
description =
"Gestion des commandes clients";
60 $this->version =
'dolibarr';
62 $this->const_name =
'MAIN_MODULE_'.strtoupper($this->
name);
63 $this->picto =
'order';
66 $this->dirs = array(
"/commande/temp");
69 $this->config_page_url = array(
"commande.php");
72 $this->depends = array(
"modSociete");
73 $this->requiredby = array(
"modExpedition");
74 $this->conflictwith = array();
75 $this->langfiles = array(
'orders',
'bills',
'companies',
'products',
'deliveries',
'sendings');
78 $this->
const = array();
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;
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;
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;
109 $this->boxes = array(
110 0=>array(
'file'=>
'box_commandes.php',
'enabledbydefaulton'=>
'Home'),
111 2=>array(
'file'=>
'box_graph_orders_permonth.php',
'enabledbydefaulton'=>
'Home')
115 $this->rights = array();
116 $this->rights_class =
'commande';
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';
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';
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';
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';
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';
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';
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';
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';
192 $this->export_code[$r] = $this->rights_class.
'_'.$r;
193 $this->export_label[$r] =
'CustomersOrdersAndOrdersLines';
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'
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';
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';
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',
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'
246 $this->export_dependencies_array[$r] = array(
'order_line'=>
'cd.rowid',
'product'=>
'cd.rowid');
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';
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);
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');
299 $import_sample = array();
300 $this->import_fields_array[$r] = array(
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*'
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';
330 $import_extrafield_sample = array();
331 $keyforselect =
'commande';
332 $keyforelement =
'order';
333 $keyforaliasextra =
'extra';
334 include DOL_DOCUMENT_ROOT.
'/core/extrafieldsinimport.inc.php';
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'
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(
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',
351 'rule' =>
'fetchidfromref',
352 'file' =>
'/societe/class/societe.class.php',
353 'class' =>
'Societe',
355 'element' =>
'ThirdParty'
357 'c.fk_user_valid' => array(
358 'rule' =>
'fetchidfromref',
359 'file' =>
'/user/class/user.class.php',
364 'c.fk_mode_reglement' => array(
365 'rule' =>
'fetchidfromcodeorlabel',
366 'file' =>
'/compta/paiement/class/cpaiement.class.php',
367 'class' =>
'Cpaiement',
369 'element' =>
'cpayment'
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'
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';
408 $import_extrafield_sample = array();
409 $keyforselect =
'commandedet';
410 $keyforelement =
'orderline';
411 $keyforaliasextra =
'extra';
412 include DOL_DOCUMENT_ROOT.
'/core/extrafieldsinimport.inc.php';
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'
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',
427 'element' =>
'commande'
441 public function init($options =
'')
443 global $conf, $langs;
446 $this->
remove($options);
449 $src = DOL_DOCUMENT_ROOT.
'/install/doctemplates/orders/template_order.odt';
450 $dirodt = DOL_DATA_ROOT.
'/doctemplates/orders';
451 $dest = $dirodt.
'/template_order.odt';
453 if (file_exists($src) && !file_exists($dest)) {
454 require_once DOL_DOCUMENT_ROOT.
'/core/lib/files.lib.php';
456 $result =
dol_copy($src, $dest, 0, 0);
458 $langs->load(
"errors");
459 $this->error = $langs->trans(
'ErrorFailToCopyFile', $src, $dest);
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).
")"
469 return $this->
_init($sql, $options);