51 $this->family =
"crm";
52 $this->module_position =
'40';
54 $this->
name = preg_replace(
'/^mod/i',
'', get_class($this));
58 $this->version =
'dolibarr';
60 $this->const_name =
'MAIN_MODULE_'.strtoupper($this->
name);
61 $this->picto =
"dolly";
64 $this->dirs = array(
"/expedition/temp",
65 "/expedition/sending",
66 "/expedition/sending/temp",
67 "/expedition/receipt",
68 "/expedition/receipt/temp",
69 "/doctemplates/shipments",
70 "/doctemplates/deliveries"
74 $this->config_page_url = array(
"expedition.php");
77 $this->depends = array(
"modCommande");
78 $this->requiredby = array();
79 $this->conflictwith = array();
80 $this->langfiles = array(
'deliveries',
'sendings');
83 $this->
const = array();
86 $this->
const[$r][0] =
"EXPEDITION_ADDON_PDF";
87 $this->
const[$r][1] =
"chaine";
88 $this->
const[$r][2] =
"espadon";
89 $this->
const[$r][3] =
'Nom du gestionnaire de generation des bons expeditions en PDF';
90 $this->
const[$r][4] = 0;
93 $this->
const[$r][0] =
"EXPEDITION_ADDON_NUMBER";
94 $this->
const[$r][1] =
"chaine";
95 $this->
const[$r][2] =
"mod_expedition_safor";
96 $this->
const[$r][3] =
'Name for numbering manager for shipments';
97 $this->
const[$r][4] = 0;
100 $this->
const[$r][0] =
"EXPEDITION_ADDON_PDF_ODT_PATH";
101 $this->
const[$r][1] =
"chaine";
102 $this->
const[$r][2] =
"DOL_DATA_ROOT/doctemplates/shipments";
103 $this->
const[$r][3] =
"";
104 $this->
const[$r][4] = 0;
107 $this->
const[$r][0] =
"DELIVERY_ADDON_PDF";
108 $this->
const[$r][1] =
"chaine";
109 $this->
const[$r][2] =
"storm";
110 $this->
const[$r][3] =
'Nom du gestionnaire de generation des bons de reception en PDF';
111 $this->
const[$r][4] = 0;
114 $this->
const[$r][0] =
"DELIVERY_ADDON_NUMBER";
115 $this->
const[$r][1] =
"chaine";
116 $this->
const[$r][2] =
"mod_delivery_jade";
117 $this->
const[$r][3] =
'Nom du gestionnaire de numerotation des bons de reception';
118 $this->
const[$r][4] = 0;
121 $this->
const[$r][0] =
"DELIVERY_ADDON_PDF_ODT_PATH";
122 $this->
const[$r][1] =
"chaine";
123 $this->
const[$r][2] =
"DOL_DATA_ROOT/doctemplates/deliveries";
124 $this->
const[$r][3] =
"";
125 $this->
const[$r][4] = 0;
128 $this->
const[$r][0] =
"MAIN_SUBMODULE_EXPEDITION";
129 $this->
const[$r][1] =
"chaine";
130 $this->
const[$r][2] =
"1";
131 $this->
const[$r][3] =
"Enable delivery receipts";
132 $this->
const[$r][4] = 0;
136 $this->boxes = array(
137 0=>array(
'file'=>
'box_shipments.php',
'enabledbydefaulton'=>
'Home'),
141 $this->rights = array();
142 $this->rights_class =
'expedition';
146 $this->rights[$r][0] = 101;
147 $this->rights[$r][1] =
'Read shipments';
148 $this->rights[$r][2] =
'r';
149 $this->rights[$r][3] = 0;
150 $this->rights[$r][4] =
'lire';
153 $this->rights[$r][0] = 102;
154 $this->rights[$r][1] =
'Create/modify shipments';
155 $this->rights[$r][2] =
'w';
156 $this->rights[$r][3] = 0;
157 $this->rights[$r][4] =
'creer';
160 $this->rights[$r][0] = 104;
161 $this->rights[$r][1] =
'Validate shipments';
162 $this->rights[$r][2] =
'd';
163 $this->rights[$r][3] = 0;
164 $this->rights[$r][4] =
'shipping_advance';
165 $this->rights[$r][5] =
'validate';
168 $this->rights[$r][0] = 105;
169 $this->rights[$r][1] =
'Send shipments by email to customers';
170 $this->rights[$r][2] =
'd';
171 $this->rights[$r][3] = 0;
172 $this->rights[$r][4] =
'shipping_advance';
173 $this->rights[$r][5] =
'send';
176 $this->rights[$r][0] = 106;
177 $this->rights[$r][1] =
'Export shipments';
178 $this->rights[$r][2] =
'r';
179 $this->rights[$r][3] = 0;
180 $this->rights[$r][4] =
'shipment';
181 $this->rights[$r][5] =
'export';
184 $this->rights[$r][0] = 109;
185 $this->rights[$r][1] =
'Delete shipments';
186 $this->rights[$r][2] =
'd';
187 $this->rights[$r][3] = 0;
188 $this->rights[$r][4] =
'supprimer';
191 $this->rights[$r][0] = 1101;
192 $this->rights[$r][1] =
'Read delivery receipts';
193 $this->rights[$r][2] =
'r';
194 $this->rights[$r][3] = 0;
195 $this->rights[$r][4] =
'delivery';
196 $this->rights[$r][5] =
'lire';
199 $this->rights[$r][0] = 1102;
200 $this->rights[$r][1] =
'Create/modify delivery receipts';
201 $this->rights[$r][2] =
'w';
202 $this->rights[$r][3] = 0;
203 $this->rights[$r][4] =
'delivery';
204 $this->rights[$r][5] =
'creer';
207 $this->rights[$r][0] = 1104;
208 $this->rights[$r][1] =
'Validate delivery receipts';
209 $this->rights[$r][2] =
'd';
210 $this->rights[$r][3] = 0;
211 $this->rights[$r][4] =
'delivery_advance';
212 $this->rights[$r][5] =
'validate';
215 $this->rights[$r][0] = 1109;
216 $this->rights[$r][1] =
'Delete delivery receipts';
217 $this->rights[$r][2] =
'd';
218 $this->rights[$r][3] = 0;
219 $this->rights[$r][4] =
'delivery';
220 $this->rights[$r][5] =
'supprimer';
232 include_once DOL_DOCUMENT_ROOT.
'/commande/class/commande.class.php';
233 $shipment =
new Commande($this->db);
234 $contact_arrays = $shipment->liste_type_contact(
'external',
'', 0, 0,
'');
235 if (is_array($contact_arrays) && count($contact_arrays) > 0) {
236 $idcontacts = implode(
',', array_keys($shipment->liste_type_contact(
'external',
'', 0, 0,
'')));
243 $this->export_code[$r] = $this->rights_class.
'_'.$r;
244 $this->export_label[$r] =
'Shipments';
245 $this->export_permission[$r] = array(array(
"expedition",
"shipment",
"export"));
246 $this->export_fields_array[$r] = array(
247 's.rowid'=>
"IdCompany",
's.nom'=>
'ThirdParty',
's.address'=>
'Address',
's.zip'=>
'Zip',
's.town'=>
'Town',
'd.nom'=>
'State',
'co.label'=>
'Country',
248 'co.code'=>
'CountryCode',
's.phone'=>
'Phone',
's.siren'=>
'ProfId1',
's.siret'=>
'ProfId2',
's.ape'=>
'ProfId3',
's.idprof4'=>
'ProfId4',
's.idprof5'=>
'ProfId5',
249 's.idprof6'=>
'ProfId6',
'c.rowid'=>
"Id",
'c.ref'=>
"Ref",
'c.ref_customer'=>
"RefCustomer",
'c.fk_soc'=>
"IdCompany",
'c.date_creation'=>
"DateCreation",
'c.date_valid'=>
"DateValidation",
250 'c.date_delivery'=>
"DateDeliveryPlanned",
'c.tracking_number'=>
"TrackingNumber",
'c.height'=>
"Height",
'c.width'=>
"Width",
'c.size'=>
"Depth",
251 'c.size_units'=>
'SizeUnits',
'c.weight'=>
"Weight",
'c.weight_units'=>
"WeightUnits",
'c.fk_statut'=>
'Status',
'c.note_public'=>
"NotePublic",
252 'ed.rowid'=>
'LineId',
'cd.description'=>
'Description',
'ed.qty'=>
"Qty",
'p.rowid'=>
'ProductId',
'p.ref'=>
'ProductRef',
'p.label'=>
'ProductLabel',
253 'p.weight'=>
'ProductWeight',
'p.weight_units'=>
'WeightUnits',
'p.volume'=>
'ProductVolume',
'p.volume_units'=>
'VolumeUnits'
256 $this->export_fields_array[$r] += array(
'sp.rowid'=>
'IdContact',
'sp.lastname'=>
'Lastname',
'sp.firstname'=>
'Firstname',
'sp.note_public'=>
'NotePublic');
264 $this->export_TypeFields_array[$r] = array(
265 's.nom'=>
'Text',
's.address'=>
'Text',
's.zip'=>
'Text',
's.town'=>
'Text',
'co.label'=>
'List:c_country:label:label',
'co.code'=>
'Text',
's.phone'=>
'Text',
266 's.siren'=>
'Text',
's.siret'=>
'Text',
's.ape'=>
'Text',
's.idprof4'=>
'Text',
'c.ref'=>
"Text",
'c.ref_customer'=>
"Text",
'c.date_creation'=>
"Date",
'c.date_valid'=>
"Date",
267 'c.date_delivery'=>
"Date",
'c.tracking_number'=>
"Numeric",
'c.height'=>
"Numeric",
'c.width'=>
"Numeric",
'c.weight'=>
"Numeric",
'c.fk_statut'=>
'Status',
268 'c.note_public'=>
"Text",
'ed.qty'=>
"Numeric",
'd.nom'=>
'Text'
270 $this->export_entities_array[$r] = array(
271 's.rowid'=>
"company",
's.nom'=>
'company',
's.address'=>
'company',
's.zip'=>
'company',
's.town'=>
'company',
'd.nom'=>
'company',
'co.label'=>
'company',
272 'co.code'=>
'company',
's.fk_pays'=>
'company',
's.phone'=>
'company',
's.siren'=>
'company',
's.ape'=>
'company',
's.siret'=>
'company',
's.idprof4'=>
'company',
273 's.idprof5'=>
'company',
's.idprof6'=>
'company',
'c.rowid'=>
"shipment",
'c.ref'=>
"shipment",
'c.ref_customer'=>
"shipment",
'c.fk_soc'=>
"shipment",
274 'c.date_creation'=>
"shipment",
'c.date_valid'=>
"shipment",
'c.date_delivery'=>
"shipment",
'c.tracking_number'=>
'shipment',
'c.height'=>
"shipment",
'c.width'=>
"shipment",
275 'c.size'=>
'shipment',
'c.size_units'=>
'shipment',
'c.weight'=>
"shipment",
'c.weight_units'=>
'shipment',
'c.fk_statut'=>
"shipment",
'c.note_public'=>
"shipment",
276 'ed.rowid'=>
'shipment_line',
'cd.description'=>
'shipment_line',
'ed.qty'=>
"shipment_line",
'p.rowid'=>
'product',
'p.ref'=>
'product',
'p.label'=>
'product',
277 'p.weight'=>
'product',
'p.weight_units'=>
'product',
'p.volume'=>
'product',
'p.volume_units'=>
'product'
280 $this->export_entities_array[$r] += array(
'sp.rowid'=>
'contact',
'sp.lastname'=>
'contact',
'sp.firstname'=>
'contact',
'sp.note_public'=>
'contact');
282 $this->export_dependencies_array[$r] = array(
'shipment_line'=>
'ed.rowid',
'product'=>
'ed.rowid');
284 $keyforselect =
'socpeople';
285 $keyforelement =
'contact';
286 $keyforaliasextra =
'extra3';
287 include DOL_DOCUMENT_ROOT.
'/core/extrafieldsinexport.inc.php';
289 $keyforselect =
'expedition';
290 $keyforelement =
'shipment';
291 $keyforaliasextra =
'extra';
292 include DOL_DOCUMENT_ROOT.
'/core/extrafieldsinexport.inc.php';
293 $keyforselect =
'expeditiondet';
294 $keyforelement =
'shipment_line';
295 $keyforaliasextra =
'extra2';
296 include DOL_DOCUMENT_ROOT.
'/core/extrafieldsinexport.inc.php';
297 $keyforselect =
'product';
298 $keyforelement =
'product';
299 $keyforaliasextra =
'extraprod';
300 include DOL_DOCUMENT_ROOT.
'/core/extrafieldsinexport.inc.php';
302 $this->export_sql_start[$r] =
'SELECT DISTINCT ';
303 $this->export_sql_end[$r] =
' FROM '.MAIN_DB_PREFIX.
'expedition as c';
304 $this->export_sql_end[$r] .=
' LEFT JOIN '.MAIN_DB_PREFIX.
'expedition_extrafields as extra ON c.rowid = extra.fk_object,';
305 $this->export_sql_end[$r] .=
' '.MAIN_DB_PREFIX.
'societe as s';
306 if (!empty($user) && !$user->hasRight(
'societe',
'client',
'voir')) {
307 $this->export_sql_end[$r] .=
' LEFT JOIN '.MAIN_DB_PREFIX.
'societe_commerciaux as sc ON sc.fk_soc = s.rowid';
309 $this->export_sql_end[$r] .=
' LEFT JOIN '.MAIN_DB_PREFIX.
'c_departements as d ON s.fk_departement = d.rowid';
310 $this->export_sql_end[$r] .=
' LEFT JOIN '.MAIN_DB_PREFIX.
'c_country as co ON s.fk_pays = co.rowid,';
311 $this->export_sql_end[$r] .=
' '.MAIN_DB_PREFIX.
'expeditiondet as ed';
312 $this->export_sql_end[$r] .=
' LEFT JOIN '.MAIN_DB_PREFIX.
'expeditiondet_extrafields as extra2 ON ed.rowid = extra2.fk_object';
313 $this->export_sql_end[$r] .=
' , '.MAIN_DB_PREFIX.
'commandedet as cd';
314 $this->export_sql_end[$r] .=
' LEFT JOIN '.MAIN_DB_PREFIX.
'product as p on cd.fk_product = p.rowid';
315 $this->export_sql_end[$r] .=
' LEFT JOIN '.MAIN_DB_PREFIX.
'product_extrafields as extraprod ON p.rowid = extraprod.fk_object';
317 $this->export_sql_end[$r] .=
' LEFT JOIN '.MAIN_DB_PREFIX.
'element_contact as ee ON ee.element_id = cd.fk_commande AND ee.fk_c_type_contact IN ('.$this->db->sanitize($idcontacts).
')';
318 $this->export_sql_end[$r] .=
' LEFT JOIN '.MAIN_DB_PREFIX.
'socpeople as sp ON sp.rowid = ee.fk_socpeople';
319 $this->export_sql_end[$r] .=
' LEFT JOIN '.MAIN_DB_PREFIX.
'socpeople_extrafields as extra3 ON sp.rowid = extra3.fk_object';
321 $this->export_sql_end[$r] .=
' WHERE c.fk_soc = s.rowid AND c.rowid = ed.fk_expedition AND ed.fk_elementdet = cd.rowid';
322 $this->export_sql_end[$r] .=
' AND c.entity IN ('.getEntity(
'expedition').
')';
323 if (!empty($user) && !$user->hasRight(
'societe',
'client',
'voir')) {
324 $this->export_sql_end[$r] .=
' AND sc.fk_user = '.(empty($user) ? 0 : $user->id);