44require
'../main.inc.php';
54require_once DOL_DOCUMENT_ROOT.
'/core/lib/date.lib.php';
55require_once DOL_DOCUMENT_ROOT.
'/core/lib/company.lib.php';
56require_once DOL_DOCUMENT_ROOT.
'/core/class/discount.class.php';
57require_once DOL_DOCUMENT_ROOT.
'/core/class/html.formfile.class.php';
58require_once DOL_DOCUMENT_ROOT.
'/core/class/html.formother.class.php';
59require_once DOL_DOCUMENT_ROOT.
'/core/class/html.formcompany.class.php';
61 require_once DOL_DOCUMENT_ROOT.
'/core/class/html.formmargin.class.php';
63require_once DOL_DOCUMENT_ROOT.
'/commande/class/commande.class.php';
64require_once DOL_DOCUMENT_ROOT.
'/compta/facture/class/facture.class.php';
65require_once DOL_DOCUMENT_ROOT.
'/product/class/product.class.php';
66require_once DOL_DOCUMENT_ROOT.
'/product/class/html.formproduct.class.php';
67require_once DOL_DOCUMENT_ROOT.
'/projet/class/project.class.php';
70 require_once DOL_DOCUMENT_ROOT.
'/categories/class/categorie.class.php';
71 require_once DOL_DOCUMENT_ROOT.
'/core/class/html.formcategory.class.php';
75$langs->loadLangs(array(
'orders',
'sendings',
'companies',
'compta',
'bills',
'stocks',
'products'));
78$action =
GETPOST(
'action',
'aZ09');
79$massaction =
GETPOST(
'massaction',
'alpha');
81$confirm =
GETPOST(
'confirm',
'alpha');
82$toselect =
GETPOST(
'toselect',
'array:int');
83$contextpage =
GETPOST(
'contextpage',
'aZ') ?
GETPOST(
'contextpage',
'aZ') :
'orderlist';
84$optioncss =
GETPOST(
'optioncss',
'alpha');
88 $userschilds = $user->getAllChildIds();
90 $userschilds = array();
94$search_datecloture_start =
GETPOSTINT(
'search_datecloture_start');
95if (empty($search_datecloture_start)) {
98$search_datecloture_end =
GETPOSTINT(
'search_datecloture_end');
99if (empty($search_datecloture_end)) {
109$search_all = trim(
GETPOST(
'search_all',
'alphanohtml'));
110$searchCategoryOrderOperator = 0;
112 $searchCategoryOrderOperator =
GETPOSTINT(
'search_category_order_operator');
116$searchCategoryOrderList =
GETPOST(
'search_category_order_list',
'array');
117$search_product_category =
GETPOST(
'search_product_category',
'intcomma');
118$search_id =
GETPOST(
'search_id',
'int');
119$search_ref =
GETPOST(
'search_ref',
'alpha') !=
'' ?
GETPOST(
'search_ref',
'alpha') :
GETPOST(
'sref',
'alpha');
120$search_ref_ext =
GETPOST(
'search_ref_ext',
'alpha');
121$search_ref_customer =
GETPOST(
'search_ref_customer',
'alpha');
122$search_company =
GETPOST(
'search_company',
'alpha');
123$search_company_alias =
GETPOST(
'search_company_alias',
'alpha');
124$search_parent_name = trim(
GETPOST(
'search_parent_name',
'alphanohtml'));
125$search_town =
GETPOST(
'search_town',
'alpha');
126$search_zip =
GETPOST(
'search_zip',
'alpha');
127$search_state =
GETPOST(
'search_state',
'alpha');
128$search_country =
GETPOST(
'search_country',
'aZ09');
129$search_type_thirdparty =
GETPOST(
'search_type_thirdparty',
'intcomma');
130$search_user =
GETPOST(
'search_user',
'intcomma');
131$search_sale =
GETPOST(
'search_sale',
'intcomma');
132$search_total_ht =
GETPOST(
'search_total_ht',
'alpha');
133$search_total_vat =
GETPOST(
'search_total_vat',
'alpha');
134$search_total_ttc =
GETPOST(
'search_total_ttc',
'alpha');
135$search_warehouse =
GETPOST(
'search_warehouse',
'intcomma');
136$search_note_public =
GETPOST(
'search_note_public',
'alphanohtml');
137$search_note_private =
GETPOST(
'search_note_private',
'alphanohtml');
139$search_module_source =
GETPOST(
'search_module_source',
'alphanohtml');
140$search_pos_source =
GETPOST(
'search_pos_source',
'alphanohtml');
142$search_multicurrency_code =
GETPOST(
'search_multicurrency_code',
'alpha');
143$search_multicurrency_tx =
GETPOST(
'search_multicurrency_tx',
'alpha');
144$search_multicurrency_montant_ht =
GETPOST(
'search_multicurrency_montant_ht',
'alpha');
145$search_multicurrency_montant_vat =
GETPOST(
'search_multicurrency_montant_vat',
'alpha');
146$search_multicurrency_montant_ttc =
GETPOST(
'search_multicurrency_montant_ttc',
'alpha');
148$search_login =
GETPOST(
'search_login',
'alpha');
149$search_categ_cus =
GETPOST(
"search_categ_cus",
'intcomma');
150$search_billed =
GETPOST(
'search_billed',
'intcomma');
151$search_status =
GETPOST(
'search_status',
'intcomma');
152$search_project_ref =
GETPOST(
'search_project_ref',
'alpha');
153$search_project =
GETPOST(
'search_project',
'alpha');
154$search_shippable =
GETPOST(
'search_shippable',
'aZ09');
156$search_fk_cond_reglement =
GETPOST(
'search_fk_cond_reglement',
'intcomma');
157$search_fk_shipping_method =
GETPOST(
'search_fk_shipping_method',
'intcomma');
158$search_fk_mode_reglement =
GETPOST(
'search_fk_mode_reglement',
'intcomma');
159$search_fk_input_reason =
GETPOST(
'search_fk_input_reason',
'intcomma');
161$search_option =
GETPOST(
'search_option',
'alpha');
162if ($search_option ==
'late') {
163 $search_status =
'-2';
165$search_import_key = trim(
GETPOST(
"search_import_key",
"alpha"));
167$diroutputmassaction =
$conf->order->multidir_output[
$conf->entity].
'/temp/massgeneration/'.$user->id;
171$sortfield =
GETPOST(
'sortfield',
'aZ09comma');
172$sortorder =
GETPOST(
'sortorder',
'aZ09comma');
174if (empty($page) || $page < 0 ||
GETPOST(
'button_search',
'alpha') ||
GETPOST(
'button_removefilter',
'alpha')) {
178$offset = $limit * $page;
179$pageprev = $page - 1;
180$pagenext = $page + 1;
182 $sortfield =
'c.ref';
188$show_shippable_command =
GETPOST(
'show_shippable_command',
'aZ09');
192$hookmanager->initHooks(array(
'orderlist'));
195$extrafields->fetch_name_optionals_label(
$object->table_element);
196$search_array_options = $extrafields->getOptionalsFromPost(
$object->table_element,
'',
'search_');
199$fieldstosearchall = array(
201 'c.ref_client' =>
'RefCustomerOrder',
202 'pd.description' =>
'ProductDescription',
203 's.nom' =>
"ThirdParty",
204 's.name_alias' =>
"AliasNameShort",
207 'c.note_public' =>
'NotePublic',
209if (empty($user->socid)) {
210 $fieldstosearchall[
"c.note_private"] =
"NotePrivate";
216$checkedtypetiers =
'0';
218 'c.rowid' => array(
'label' =>
"ID",
'checked' =>
'1',
'enabled' => (
string)
getDolGlobalInt(
'MAIN_SHOW_TECHNICAL_ID'),
'position' => 1),
219 'c.ref' => array(
'label' =>
"Ref",
'checked' =>
'1',
'position' => 5,
'searchall' => 1),
220 'c.ref_ext' => array(
'label' =>
"RefExt",
'checked' =>
'1',
'position' => 5,
'visible' => 0,
'searchall' => 1),
221 'c.ref_client' => array(
'label' =>
"RefCustomerOrder",
'checked' =>
'-1',
'position' => 10,
'searchall' => 1),
222 'p.ref' => array(
'label' =>
"ProjectRef",
'langfile' =>
'projects',
'checked' =>
'-1',
'enabled' => (!
isModEnabled(
'project') ?
'0' :
'1'),
'position' => 20),
223 'p.title' => array(
'label' =>
"ProjectLabel",
'langfile' =>
'projects',
'checked' =>
'0',
'enabled' => (!
isModEnabled(
'project') ?
'0' :
'1'),
'position' => 25),
224 's.nom' => array(
'label' =>
"ThirdParty",
'checked' =>
'1',
'position' => 30,
'searchall' => 1),
225 's.name_alias' => array(
'label' =>
"AliasNameShort",
'checked' =>
'-1',
'position' => 31,
'searchall' => 1),
226 's2.nom' => array(
'label' =>
'ParentCompany',
'position' => 32,
'checked' =>
'0'),
227 's.town' => array(
'label' =>
"Town",
'checked' =>
'-1',
'position' => 35,
'searchall' => 1),
228 's.zip' => array(
'label' =>
"Zip",
'checked' =>
'-1',
'position' => 40,
'searchall' => 1),
229 'state.nom' => array(
'label' =>
"StateShort",
'checked' =>
'0',
'position' => 45),
230 'country.code_iso' => array(
'label' =>
"Country",
'checked' =>
'0',
'position' => 50),
231 'typent.code' => array(
'label' =>
"ThirdPartyType",
'checked' => (string) $checkedtypetiers,
'position' => 55),
232 'c.date_commande' => array(
'label' =>
"OrderDateShort",
'checked' =>
'1',
'position' => 60,
'csslist' =>
'nowraponall'),
233 'c.delivery_date' => array(
'label' =>
"DateDeliveryPlanned",
'checked' =>
'1',
'enabled' => (string) (int) !
getDolGlobalString(
'ORDER_DISABLE_DELIVERY_DATE'),
'position' => 65,
'csslist' =>
'nowraponall'),
234 'c.fk_shipping_method' => array(
'label' =>
"SendingMethod",
'checked' =>
'-1',
'position' => 66 ,
'enabled' => (string) (int)
isModEnabled(
"shipping")),
235 'c.fk_cond_reglement' => array(
'label' =>
"PaymentConditionsShort",
'checked' =>
'-1',
'position' => 67),
236 'c.fk_mode_reglement' => array(
'label' =>
"PaymentMode",
'checked' =>
'-1',
'position' => 68),
237 'c.fk_input_reason' => array(
'label' =>
"Origin",
'checked' =>
'-1',
'position' => 69),
238 'c.module_source' => array(
'label' =>
"POSModule",
'langfile' =>
'cashdesk',
'checked' => ($contextpage ==
'poslist' ?
'1' :
'0'),
'enabled' => $showpos,
'position' => 90),
239 'c.pos_source' => array(
'label' =>
"POSTerminal",
'langfile' =>
'cashdesk',
'checked' => ($contextpage ==
'poslist' ?
'1' :
'0'),
'enabled' => $showpos,
'position' => 91),
240 'c.total_ht' => array(
'label' =>
"AmountHT",
'checked' =>
'1',
'position' => 75),
241 'c.total_vat' => array(
'label' =>
"AmountVAT",
'checked' =>
'0',
'position' => 80),
242 'c.total_ttc' => array(
'label' =>
"AmountTTC",
'checked' =>
'0',
'position' => 85),
243 'c.multicurrency_code' => array(
'label' =>
'Currency',
'checked' =>
'0',
'enabled' => (!
isModEnabled(
"multicurrency") ?
'0' :
'1'),
'position' => 92),
244 'c.multicurrency_tx' => array(
'label' =>
'CurrencyRate',
'checked' =>
'0',
'enabled' => (!
isModEnabled(
"multicurrency") ?
'0' :
'1'),
'position' => 95),
245 'c.multicurrency_total_ht' => array(
'label' =>
'MulticurrencyAmountHT',
'checked' =>
'0',
'enabled' => (!
isModEnabled(
"multicurrency") ?
'0' :
'1'),
'position' => 100),
246 'c.multicurrency_total_vat' => array(
'label' =>
'MulticurrencyAmountVAT',
'checked' =>
'0',
'enabled' => (!
isModEnabled(
"multicurrency") ?
'0' :
'1'),
'position' => 105),
247 'c.multicurrency_total_ttc' => array(
'label' =>
'MulticurrencyAmountTTC',
'checked' =>
'0',
'enabled' => (!
isModEnabled(
"multicurrency") ?
'0' :
'1'),
'position' => 110),
248 'u.login' => array(
'label' =>
"Author",
'checked' =>
'-1',
'position' => 115),
249 'sale_representative' => array(
'label' =>
"SaleRepresentativesOfThirdParty",
'checked' =>
'0',
'position' => 116),
250 'total_pa' => array(
'label' => (
getDolGlobalString(
'MARGIN_TYPE') ==
'1' ?
'BuyingPrice' :
'CostPrice'),
'checked' =>
'0',
'position' => 300,
'enabled' => (string) (int) (!
isModEnabled(
'margin') || !$user->hasRight(
"margins",
"liretous") ? 0 : 1)),
251 'total_margin' => array(
'label' =>
'Margin',
'checked' =>
'0',
'position' => 301,
'enabled' => (string) (int) (!
isModEnabled(
'margin') || !$user->hasRight(
"margins",
"liretous") ? 0 : 1)),
252 'total_margin_rate' => array(
'label' =>
'MarginRate',
'checked' =>
'0',
'position' => 302,
'enabled' => (string) (int) (!
isModEnabled(
'margin') || !$user->hasRight(
"margins",
"liretous") || !
getDolGlobalString(
'DISPLAY_MARGIN_RATES') ? 0 : 1)),
253 'total_mark_rate' => array(
'label' =>
'MarkRate',
'checked' =>
'0',
'position' => 303,
'enabled' => (string) (int) (!
isModEnabled(
'margin') || !$user->hasRight(
"margins",
"liretous") || !
getDolGlobalString(
'DISPLAY_MARK_RATES') ? 0 : 1)),
254 'c.datec' => array(
'label' =>
"DateCreation",
'checked' =>
'0',
'position' => 120),
255 'c.tms' => array(
'label' =>
"DateModificationShort",
'checked' =>
'0',
'position' => 125),
256 'c.date_cloture' => array(
'label' =>
"DateClosing",
'checked' =>
'0',
'position' => 130),
257 'c.note_public' => array(
'label' =>
'NotePublic',
'checked' =>
'0',
'enabled' => (string) (int) (!
getDolGlobalInt(
'MAIN_LIST_HIDE_PUBLIC_NOTES')),
'position' => 135,
'searchall' => 1),
258 'c.note_private' => array(
'label' =>
'NotePrivate',
'checked' =>
'0',
'enabled' => (string) (int) (!
getDolGlobalInt(
'MAIN_LIST_HIDE_PRIVATE_NOTES')),
'position' => 140),
259 'shippable' => array(
'label' =>
"Shippable",
'checked' =>
'1',
'enabled' => (string) (int) (
isModEnabled(
"shipping")),
'position' => 990),
260 'c.facture' => array(
'label' =>
"Billed",
'checked' =>
'1',
'enabled' => (string) (int) (!
getDolGlobalString(
'WORKFLOW_BILL_ON_SHIPMENT')),
'position' => 995),
261 'c.import_key' => array(
'type' =>
'varchar(14)',
'label' =>
'ImportId',
'enabled' =>
'1',
'visible' => -2,
'position' => 999),
262 'c.fk_statut' => array(
'label' =>
"Status",
'checked' =>
'1',
'position' => 1000)
265 unset($arrayfields[
'c.note_private']);
267$parameters = array(
'fieldstosearchall' => $fieldstosearchall);
268$reshook = $hookmanager->executeHooks(
'completeFieldsToSearchAll', $parameters, $object, $action);
270 $fieldstosearchall = empty($hookmanager->resArray[
'fieldstosearchall']) ? array() : $hookmanager->resArray[
'fieldstosearchall'];
271} elseif ($reshook == 0) {
272 $fieldstosearchall = array_merge($fieldstosearchall, empty($hookmanager->resArray[
'fieldstosearchall']) ? array() : $hookmanager->resArray[
'fieldstosearchall']);
276include DOL_DOCUMENT_ROOT.
'/core/tpl/extrafields_list_array_fields.tpl.php';
278$parameters = array(
'arrayfields' => &$arrayfields);
279$reshook = $hookmanager->executeHooks(
'completeArrayFields', $parameters, $object, $action);
282$parameters = array(
'arrayfields' => &$arrayfields);
283$reshook = $hookmanager->executeHooks(
'completeArrayFields', $parameters, $object, $action);
294 $socid = $user->socid;
297$permissiontoreadallthirdparty = $user->hasRight(
'societe',
'client',
'voir');
298$permissiontoread =
false;
299$permissiontovalidate =
false;
300$permissiontoclose =
false;
301$permissiontocancel =
false;
302$permissiontosendbymail =
false;
308$permissiontoread = $user->hasRight(
"commande",
"lire");
309$permissiontoadd = $user->hasRight(
"commande",
"creer");
310$permissiontodelete = $user->hasRight(
"commande",
"supprimer");
312 $permissiontovalidate = $user->hasRight(
"commande",
"order_advance",
"validate");
313 $permissiontoclose = $user->hasRight(
"commande",
"order_advance",
"close");
314 $permissiontocancel = $user->hasRight(
"commande",
"order_advance",
"annuler");
315 $permissiontosendbymail = $user->hasRight(
"commande",
"order_advance",
"send");
317 $permissiontovalidate = $user->hasRight(
"commande",
"creer");
318 $permissiontoclose = $user->hasRight(
"commande",
"creer");
319 $permissiontocancel = $user->hasRight(
"commande",
"creer");
320 $permissiontosendbymail = $user->hasRight(
"commande",
"creer");
330if (
GETPOST(
'cancel',
'alpha')) {
334if (!
GETPOST(
'confirmmassaction',
'alpha') && $massaction !=
'presend' && $massaction !=
'confirm_presend' && $massaction !=
'confirm_createbills') {
338$parameters = array(
'socid' => $socid,
'arrayfields' => &$arrayfields);
339$reshook = $hookmanager->executeHooks(
'doActions', $parameters, $object, $action);
341 setEventMessages($hookmanager->error, $hookmanager->errors,
'errors');
344if (empty($reshook)) {
346 include DOL_DOCUMENT_ROOT.
'/core/actions_changeselectedfields.inc.php';
349 if (
GETPOST(
'button_removefilter_x',
'alpha') ||
GETPOST(
'button_removefilter.x',
'alpha') ||
GETPOST(
'button_removefilter',
'alpha')) {
352 $search_product_category =
'';
353 $searchCategoryOrderList = array();
356 $search_ref_ext =
'';
357 $search_ref_customer =
'';
358 $search_company =
'';
359 $search_company_alias =
'';
360 $search_parent_name =
'';
361 $search_module_source =
'';
362 $search_pos_source =
'';
367 $search_country =
'';
368 $search_type_thirdparty =
'';
369 $search_total_ht =
'';
370 $search_total_vat =
'';
371 $search_total_ttc =
'';
372 $search_warehouse =
'';
373 $search_note_public =
'';
374 $search_note_private =
'';
375 $search_multicurrency_code =
'';
376 $search_multicurrency_tx =
'';
377 $search_multicurrency_montant_ht =
'';
378 $search_multicurrency_montant_vat =
'';
379 $search_multicurrency_montant_ttc =
'';
381 $search_dateorder_start =
'';
382 $search_dateorder_end =
'';
383 $search_datedelivery_start =
'';
384 $search_datedelivery_end =
'';
385 $search_project_ref =
'';
386 $search_project =
'';
389 $search_datecloture_start =
'';
390 $search_datecloture_end =
'';
391 $search_fk_cond_reglement =
'';
392 $search_fk_shipping_method =
'';
393 $search_fk_mode_reglement =
'';
394 $search_fk_input_reason =
'';
396 $search_import_key =
'';
397 $search_categ_cus = 0;
401 $search_array_options = array();
403 if (
GETPOST(
'button_removefilter_x',
'alpha') ||
GETPOST(
'button_removefilter.x',
'alpha') ||
GETPOST(
'button_removefilter',
'alpha')
404 ||
GETPOST(
'button_search_x',
'alpha') ||
GETPOST(
'button_search.x',
'alpha') ||
GETPOST(
'button_search',
'alpha')) {
409 $objectclass =
'Commande';
410 $objectlabel =
'Orders';
411 $uploaddir =
$conf->order->multidir_output[
$conf->entity];
412 $triggersendname =
'ORDER_SENTBYMAIL';
415 include DOL_DOCUMENT_ROOT.
'/core/actions_massactions.inc.php';
417 if (!$error && $massaction ==
'confirm_createbills' && $user->hasRight(
'facture',
'creer')) {
419 $createbills_onebythird =
GETPOSTINT(
'createbills_onebythird');
420 $validate_invoices =
GETPOSTINT(
'validate_invoices');
425 $TFactThird = array();
426 $TFactThirdNbLines = array();
428 $nb_bills_created = 0;
434 $nbOrders = is_array($orders) ? count($orders) : 1;
438 foreach ($orders as $id_order) {
440 if ($cmd->fetch($id_order) <= 0) {
448 setEventMessages($langs->trans(
'WarningOrderNotEligibleForInvoicing', $cmd->ref),
null,
'warnings');
452 $cmd->fetch_thirdparty();
455 $notesUpdated =
false;
456 if (!empty($createbills_onebythird) && !empty($TFactThird[$cmd->socid])) {
459 $objecttmp = $TFactThird[$cmd->socid];
460 if ($reuseNotesOnCreateFrom) {
461 if (!empty($cmd->note_public)) {
462 $objecttmp->note_public =
dol_concatdesc($objecttmp->note_public, $cmd->note_public);
463 $notesUpdated =
true;
465 if (!empty($cmd->note_private)) {
466 $objecttmp->note_private =
dol_concatdesc($objecttmp->note_private, $cmd->note_private);
467 $notesUpdated =
true;
472 $objecttmp->socid = $cmd->socid;
473 $objecttmp->thirdparty = $cmd->thirdparty;
475 $objecttmp->type = $objecttmp::TYPE_STANDARD;
476 $objecttmp->cond_reglement_id = !empty($cmd->cond_reglement_id) ? $cmd->cond_reglement_id : $cmd->thirdparty->cond_reglement_id;
477 $objecttmp->mode_reglement_id = !empty($cmd->mode_reglement_id) ? $cmd->mode_reglement_id : $cmd->thirdparty->mode_reglement_id;
478 $objecttmp->demand_reason_id = !empty($cmd->demand_reason_id) ? $cmd->demand_reason_id : $cmd->thirdparty->demand_reason_id;
480 $objecttmp->fk_project = $cmd->fk_project;
482 $objecttmp->multicurrency_code = $cmd->multicurrency_code;
484 if (empty($createbills_onebythird)) {
485 $objecttmp->ref_client = $cmd->ref_client;
488 $objecttmp->note_public = $objecttmp->getDefaultCreateValueFor(
'note_public', ($reuseNotesOnCreateFrom ? $cmd->note_public : null));
489 $objecttmp->note_private = $objecttmp->getDefaultCreateValueFor(
'note_private', ($reuseNotesOnCreateFrom ? $cmd->note_private : null));
491 if (!$reuseNotesOnCreateFrom && empty($objecttmp->note_public) &&
getDolGlobalInt(
"MAXREFONDOC", 10)>0) {
492 $objecttmp->note_public = $langs->transnoentities(
"Orders");
496 if (empty($datefacture)) {
500 $objecttmp->date = $datefacture;
501 $objecttmp->origin =
'commande';
502 $objecttmp->origin_id = (int) $id_order;
504 $objecttmp->array_options = $cmd->array_options;
506 $res = $objecttmp->create($user);
509 $objecttmp->user_creation_id = $user->id;
512 $lastref = $objecttmp->ref;
513 $lastid = $objecttmp->id;
515 $TFactThird[$cmd->socid] = $objecttmp;
516 $TFactThirdNbLines[$cmd->socid] = 0;
518 $langs->load(
"errors");
519 $errors[] = $cmd->ref.
' : '.$langs->trans($objecttmp->errors[0]);
524 if ($objecttmp->id > 0) {
525 $res = $objecttmp->add_object_linked($objecttmp->origin, $id_order);
528 $errors[] = $cmd->ref.
' : '.$langs->trans($objecttmp->errors[0]);
534 $cmd->fetchObjectLinked();
536 if (!$error && $cmd->id && !empty($cmd->linkedObjectsIds[
'shipping']) && is_array($cmd->linkedObjectsIds[
'shipping'])) {
537 $cmd->linked_objects = $cmd->linkedObjectsIds;
538 foreach ($cmd->linked_objects as $origin_type => $tmp_origin_id) {
540 if ($origin_type ==
'shipping') {
541 if (is_array($tmp_origin_id)) {
542 foreach ($tmp_origin_id as $origin_id) {
543 $res = $objecttmp->add_object_linked($origin_type, $origin_id);
545 $errors[] = $cmd->ref.
' : '.$langs->trans($objecttmp->errors[0]);
550 $origin_id = $tmp_origin_id;
551 $res = $objecttmp->add_object_linked($origin_type, $origin_id);
553 $errors[] = $cmd->ref.
' : '.$langs->trans($objecttmp->errors[0]);
563 $lines = $cmd->lines;
564 if (empty($lines) && method_exists($cmd,
'fetch_lines')) {
566 $lines = $cmd->lines;
570 $num = count($lines);
571 $array_options = array();
573 for ($i = 0; $i < $num; $i++) {
574 $desc = ($lines[$i]->desc ? $lines[$i]->desc :
'');
576 if (!empty($createbills_onebythird)) {
580 if ($lines[$i]->subprice < 0 && !
getDolGlobalString(
'INVOICE_KEEP_DISCOUNT_LINES_AS_IN_ORIGIN')) {
583 $discount->fk_soc = $objecttmp->socid;
584 $discount->socid = $objecttmp->socid;
585 $discount->amount_ht = abs($lines[$i]->total_ht);
586 $discount->amount_tva = abs($lines[$i]->total_tva);
587 $discount->amount_ttc = abs($lines[$i]->total_ttc);
588 $discount->tva_tx = $lines[$i]->tva_tx;
589 $discount->fk_user = $user->id;
590 $discount->description = $desc;
591 $discountid = $discount->create($user);
592 if ($discountid > 0) {
593 $result = $objecttmp->insert_discount($discountid);
596 setEventMessages($discount->error, $discount->errors,
'errors');
602 $product_type = ($lines[$i]->product_type ? $lines[$i]->product_type : 0);
605 if ($lines[$i]->date_debut_prevue) {
608 if ($lines[$i]->date_debut_reel) {
611 if ($lines[$i]->date_start) {
616 if ($lines[$i]->date_fin_prevue) {
617 $date_end = $lines[$i]->date_fin_prevue;
619 if ($lines[$i]->date_fin_reel) {
620 $date_end = $lines[$i]->date_fin_reel;
622 if ($lines[$i]->date_end) {
623 $date_end = $lines[$i]->date_end;
626 if (($lines[$i]->product_type != 9 && empty($lines[$i]->fk_parent_line)) || $lines[$i]->product_type == 9) {
631 if (method_exists($lines[$i],
'fetch_optionals')) {
632 $lines[$i]->fetch_optionals();
633 $array_options = $lines[$i]->array_options;
636 $objecttmp->context[
'createfromclone'] =
'createfromclone';
638 $rang = ($nbOrders > 1) ? -1 : $lines[$i]->rang;
640 if (!empty($createbills_onebythird)) {
641 $TFactThirdNbLines[$cmd->socid]++;
642 $rang = $TFactThirdNbLines[$cmd->socid];
645 $result = $objecttmp->addline(
647 $lines[$i]->subprice,
650 $lines[$i]->localtax1_tx,
651 $lines[$i]->localtax2_tx,
652 $lines[$i]->fk_product,
653 $lines[$i]->remise_percent,
657 $lines[$i]->info_bits,
658 $lines[$i]->fk_remise_except,
663 $lines[$i]->special_code,
667 $lines[$i]->fk_fournprice,
676 if (!empty($lines[$i]->extraparams)) {
678 $factureLine->id = $result;
679 $factureLine->extraparams = $lines[$i]->extraparams;
680 $factureLine->setExtraParameters();
687 $errors[] = $objecttmp->error;
691 if ($result > 0 && $lines[$i]->product_type == 9) {
692 $fk_parent_line = $result;
699 if (!$reuseNotesOnCreateFrom && $currentIndex <=
getDolGlobalInt(
"MAXREFONDOC", 10)) {
700 $objecttmp->note_public =
dol_concatdesc($objecttmp->note_public, $langs->transnoentities($cmd->ref).(empty($cmd->ref_client) ?
'' :
' ('.$cmd->ref_client.
')'));
701 if ($objecttmp->update($user) < 0) {
703 $errors[] = $objecttmp->error;
705 } elseif ($notesUpdated && $objecttmp->update($user) < 0) {
707 $errors[] = $objecttmp->error;
712 if (!empty($createbills_onebythird) && empty($TFactThird[$cmd->socid])) {
713 $TFactThird[$cmd->socid] = $objecttmp;
715 $TFact[$objecttmp->id] = $objecttmp;
720 $TAllFact = empty($createbills_onebythird) ? $TFact : $TFactThird;
723 if (!$error && $validate_invoices) {
724 $massaction = $action =
'builddoc';
726 foreach ($TAllFact as &$objecttmp) {
727 $result = $objecttmp->validate($user);
730 setEventMessages($objecttmp->error, $objecttmp->errors,
'errors');
734 $id = $objecttmp->id;
735 $lastref = $objecttmp->ref;
739 $upload_dir =
$conf->facture->dir_output;
740 $permissiontoadd = $user->hasRight(
'facture',
'creer');
745 include DOL_DOCUMENT_ROOT.
'/core/actions_builddoc.inc.php';
749 $massaction = $action =
'confirm_createbills';
755 if ($nb_bills_created == 1) {
756 if (
getDolGlobalInt(
'MAIN_MASSACTION_CREATEBILLS_REDIRECT_IF_ONE') == 1) {
758 header(
'Location: '.DOL_URL_ROOT.
'/compta/facture/card.php?id='.urlencode((
string) $lastid));
761 $texttoshow = $langs->trans(
'BillXCreated',
'{s1}');
762 $texttoshow = str_replace(
'{s1}',
'<a href="'.DOL_URL_ROOT.
'/compta/facture/card.php?id='.urlencode((
string) ($lastid)).
'">'.$lastref.
'</a>', $texttoshow);
763 setEventMessages($texttoshow,
null,
'mesgs');
765 if (
getDolGlobalInt(
'MAIN_MASSACTION_CREATEBILLS_REDIRECT_IF_MANY') == 1) {
767 header(
"Location: ".DOL_URL_ROOT.
'/compta/facture/list.php?mainmenu=billing&leftmenu=customers_bills');
770 setEventMessages($langs->trans(
'BillCreated', $nb_bills_created),
null,
'mesgs');
776 $param .=
'&mode='.urlencode($mode);
778 if (!empty($contextpage) && $contextpage != $_SERVER[
"PHP_SELF"]) {
779 $param .=
'&contextpage='.urlencode($contextpage);
781 if ($limit > 0 && $limit !=
$conf->liste_limit) {
782 $param .=
'&limit='.((int) $limit);
784 if ($optioncss !=
'') {
785 $param .=
'&optioncss='.urlencode($optioncss);
788 $param .=
'&search_all='.urlencode($search_all);
791 $param .=
'&show_files='.urlencode((
string) ($show_files));
794 $param .=
'&socid='.urlencode((
string) ($socid));
796 if ($search_status !=
'') {
797 $param .=
'&search_status='.urlencode($search_status);
799 if ($search_option) {
800 $param .=
"&search_option=".urlencode($search_option);
803 $param .=
'&search_id='.urlencode((
string) $search_id);
806 $param .=
'&search_ref='.urlencode($search_ref);
808 if ($search_ref_ext) {
809 $param .=
'&search_ref_ext='.urlencode($search_ref_ext);
811 if ($search_company) {
812 $param .=
'&search_company='.urlencode($search_company);
814 if ($search_ref_customer) {
815 $param .=
'&search_ref_customer='.urlencode($search_ref_customer);
817 if ($search_user > 0) {
818 $param .=
'&search_user='.urlencode((
string) ($search_user));
820 if ($search_sale > 0) {
821 $param .=
'&search_sale='.urlencode((
string) ($search_sale));
823 if ($search_total_ht !=
'') {
824 $param .=
'&search_total_ht='.urlencode($search_total_ht);
826 if ($search_total_vat !=
'') {
827 $param .=
'&search_total_vat='.urlencode($search_total_vat);
829 if ($search_total_ttc !=
'') {
830 $param .=
'&search_total_ttc='.urlencode($search_total_ttc);
832 if ($search_project_ref >= 0) {
833 $param .=
"&search_project_ref=".urlencode($search_project_ref);
835 if ($search_project !=
'') {
836 $param .=
"&search_project=".urlencode($search_project);
838 if ($search_billed !=
'') {
839 $param .=
'&search_billed='.urlencode($search_billed);
842 header(
"Location: ".$_SERVER[
'PHP_SELF'].
'?'.$param);
848 $_GET[
"origin"] =
GETPOST(
"origin",
'alpha');
850 if (!empty($errors)) {
851 setEventMessages(
null, $errors,
'errors');
853 setEventMessages(
"Error",
null,
'errors');
860if ($action ==
'validate' && $permissiontoadd && $objectclass !==
null) {
861 if (
GETPOST(
'confirm') ==
'yes') {
863 $objecttmp =
new $objectclass($db);
866 foreach ($toselect as $checked) {
867 if ($objecttmp->fetch($checked)) {
868 if ($objecttmp->status == $objecttmp::STATUS_DRAFT) {
869 if (!empty($objecttmp->warehouse_id)) {
870 $idwarehouse = $objecttmp->warehouse_id;
874 if ($objecttmp->valid($user, $idwarehouse) > 0) {
875 setEventMessages($langs->trans(
'hasBeenValidated', $objecttmp->ref),
null,
'mesgs');
877 setEventMessages($objecttmp->error, $objecttmp->errors,
'errors');
881 $langs->load(
"errors");
882 setEventMessages($langs->trans(
'ErrorIsNotADraft', $objecttmp->ref),
null,
'errors');
886 dol_print_error($db);
897if ($action ==
'shipped' && $permissiontoadd && $objectclass !==
null) {
898 if (
GETPOST(
'confirm') ==
'yes') {
900 $objecttmp =
new $objectclass($db);
903 foreach ($toselect as $checked) {
904 if ($objecttmp->fetch($checked)) {
905 if ($objecttmp->status == $objecttmp::STATUS_VALIDATED || $objecttmp->status == $objecttmp::STATUS_SHIPMENTONPROCESS || $objecttmp->status == $objecttmp::STATUS_CLOSED) {
906 $result = $objecttmp->cloture($user);
908 setEventMessages($langs->trans(
'StatusOrderDelivered', $objecttmp->ref),
null,
'mesgs');
909 } elseif ($result < 0) {
910 setEventMessages($langs->trans(
'ErrorOrderStatusCantBeSetToDelivered'),
null,
'errors');
914 $langs->load(
"errors");
915 setEventMessages($langs->trans(
'ErrorObjectHasWrongStatus', $objecttmp->ref),
null,
'errors');
919 dol_print_error($db);
932if (!$error && $massaction ===
'setbilled' && $permissiontoclose && $objectclass !==
null) {
935 $objecttmp =
new $objectclass($db);
937 foreach ($toselect as $toselectid) {
938 $result = $objecttmp->fetch($toselectid);
940 $result = $objecttmp->classifyBilled($user, 0);
942 setEventMessages($objecttmp->error, $objecttmp->errors,
'errors');
949 setEventMessages($objecttmp->error, $objecttmp->errors,
'errors');
956 setEventMessages($langs->trans(
"RecordsModified", $nbok),
null,
'mesgs');
968$form =
new Form($db);
976$companystatic =
new Societe($db);
977$company_url_list = array();
979$projectstatic =
new Project($db);
983$varpage = empty($contextpage) ? $_SERVER[
"PHP_SELF"] : $contextpage;
984$selectedfields = $form->multiSelectArrayWithCheckbox(
'selectedfields', $arrayfields, $varpage);
986$title = $langs->trans(
"Orders");
987$help_url =
"EN:Module_Customers_Orders|FR:Module_Commandes_Clients|ES:Módulo_Pedidos_de_clientes";
992$sql .=
' s.rowid as socid, s.nom as name, s.name_alias as alias, s.email, s.phone, s.fax, s.address, s.town, s.zip, s.fk_pays, s.client, s.fournisseur, s.code_client,';
993$sql .=
" s.parent as fk_parent,";
994$sql .=
" s2.nom as name2,";
995$sql .=
" typent.code as typent_code,";
996$sql .=
" state.code_departement as state_code, state.nom as state_name,";
997$sql .=
" country.code as country_code,";
998$sql .=
' c.rowid, c.ref, c.ref_ext, c.total_ht, c.total_tva, c.total_ttc, c.ref_client, c.fk_user_author,';
999$sql .=
' c.fk_multicurrency, c.multicurrency_code, c.multicurrency_tx, c.multicurrency_total_ht, c.multicurrency_total_tva as multicurrency_total_vat, c.multicurrency_total_ttc,';
1000$sql .=
' c.date_valid, c.date_commande, c.note_public, c.note_private, c.date_livraison as delivery_date, c.fk_statut, c.facture as billed,';
1001$sql .=
' c.date_creation as date_creation, c.tms as date_modification, c.date_cloture as date_cloture,';
1002$sql .=
' c.fk_cond_reglement,c.deposit_percent,c.fk_mode_reglement,c.fk_shipping_method,';
1003$sql .=
' c.fk_input_reason, c.import_key,';
1004$sql .=
" c.module_source, c.pos_source,";
1005$sql .=
' p.rowid as project_id, p.ref as project_ref, p.title as project_label,';
1006$sql .=
' u.login, u.lastname, u.firstname, u.email as user_email, u.statut as user_statut, u.entity, u.photo, u.office_phone, u.office_fax, u.user_mobile, u.job, u.gender';
1009if (!empty($extrafields->attributes[
$object->table_element][
'label'])) {
1010 foreach ($extrafields->attributes[
$object->table_element][
'label'] as $key => $val) {
1011 $sql .= ($extrafields->attributes[
$object->table_element][
'type'][$key] !=
'separate' ?
", ef.".$key.
" as options_".$key :
'');
1016$parameters = array();
1017$reshook = $hookmanager->executeHooks(
'printFieldListSelect', $parameters, $object, $action);
1018$sql .= $hookmanager->resPrint;
1019$sql = preg_replace(
'/,\s*$/',
'', $sql);
1023$sql .=
' FROM '.MAIN_DB_PREFIX.
'societe as s';
1024$sql .=
" LEFT JOIN ".MAIN_DB_PREFIX.
"societe as s2 ON s2.rowid = s.parent";
1025$sql .=
" LEFT JOIN ".MAIN_DB_PREFIX.
"c_country as country on (country.rowid = s.fk_pays)";
1026$sql .=
" LEFT JOIN ".MAIN_DB_PREFIX.
"c_typent as typent on (typent.id = s.fk_typent)";
1027$sql .=
" LEFT JOIN ".MAIN_DB_PREFIX.
"c_departements as state on (state.rowid = s.fk_departement)";
1028$sql .=
', '.MAIN_DB_PREFIX.
'commande as c';
1029if (!empty($extrafields->attributes[
$object->table_element][
'label']) && is_array($extrafields->attributes[
$object->table_element][
'label']) && count($extrafields->attributes[
$object->table_element][
'label'])) {
1030 $sql .=
" LEFT JOIN ".MAIN_DB_PREFIX.
"commande_extrafields as ef on (c.rowid = ef.fk_object)";
1032$sql .=
" LEFT JOIN ".MAIN_DB_PREFIX.
"projet as p ON p.rowid = c.fk_projet";
1033$sql .=
' LEFT JOIN '.MAIN_DB_PREFIX.
'user as u ON c.fk_user_author = u.rowid';
1035$parameters = array();
1036$reshook = $hookmanager->executeHooks(
'printFieldListFrom', $parameters, $object, $action);
1037$sql .= $hookmanager->resPrint;
1039$sql .=
' WHERE c.fk_soc = s.rowid';
1040$sql .=
' AND c.entity IN ('.getEntity(
'commande').
')';
1042 $sql .=
' AND s.rowid = '.((int) $socid);
1045if (empty($user->socid) && !$permissiontoreadallthirdparty) {
1046 $sql .=
" AND (".getSalesRepresentativeSqlFilter(
'c.fk_soc', (
int) $user->id);
1048 $sql .=
" OR ".getSalesRepresentativeSqlFilter(
'c.fk_soc', $db->sanitize(implode(
',', $userschilds)));
1053if ($search_id > 0) {
1059if ($search_ref_ext) {
1062if ($search_ref_customer) {
1065if ($search_billed !=
'' && $search_billed >= 0) {
1066 $sql .=
' AND c.facture = '.((int) $search_billed);
1068if ($search_status !=
'') {
1069 if ($search_status <= 3 && $search_status >= -1) {
1070 if ($search_status == 1 && !
isModEnabled(
'shipping')) {
1071 $sql .=
' AND c.fk_statut IN (1,2)';
1073 $sql .=
' AND c.fk_statut = '.((int) $search_status);
1076 if ($search_status == -2) {
1078 $sql .=
" AND (c.fk_statut IN (1,2))";
1080 if ($search_status == -3) {
1083 $sql .=
' AND (c.fk_statut IN (1,2,3))';
1086if ($search_option ==
'late') {
1089 $sql .=
" AND ((c.date_livraison IS NOT NULL AND c.date_livraison < '".$db->idate(
dol_now() -
$conf->order->client->warning_delay).
"') OR (c.date_livraison IS NULL AND c.date_commande < '".$db->idate(
dol_now() -
$conf->order->client->warning_delay).
"'))";
1091 $sql .=
" AND c.date_commande < '".$db->idate(
dol_now() -
$conf->order->client->warning_delay).
"'";
1094if ($search_datecloture_start) {
1095 $sql .=
" AND c.date_cloture >= '".$db->idate($search_datecloture_start).
"'";
1097if ($search_datecloture_end) {
1098 $sql .=
" AND c.date_cloture <= '".$db->idate($search_datecloture_end).
"'";
1100if ($search_dateorder_start) {
1101 $sql .=
" AND c.date_commande >= '".$db->idate($search_dateorder_start).
"'";
1103if ($search_dateorder_end) {
1104 $sql .=
" AND c.date_commande <= '".$db->idate($search_dateorder_end).
"'";
1106if ($search_datedelivery_start) {
1107 $sql .=
" AND c.date_livraison >= '".$db->idate($search_datedelivery_start).
"'";
1109if ($search_datedelivery_end) {
1110 $sql .=
" AND c.date_livraison <= '".$db->idate($search_datedelivery_end).
"'";
1121if ($search_country) {
1122 $sql .=
" AND s.fk_pays IN (".$db->sanitize($search_country).
')';
1124if ($search_type_thirdparty && $search_type_thirdparty !=
'-1') {
1125 $sql .=
" AND s.fk_typent IN (".$db->sanitize($search_type_thirdparty).
')';
1127if (empty($arrayfields[
's.name_alias'][
'checked']) && $search_company) {
1128 $sql .=
natural_search(array(
"s.nom",
"s.name_alias"), $search_company);
1130 if ($search_company) {
1133 if ($search_company_alias) {
1137if ($search_parent_name) {
1140if ($search_total_ht !=
'') {
1143if ($search_total_vat !=
'') {
1146if ($search_total_ttc !=
'') {
1149if ($search_warehouse !=
'' && $search_warehouse > 0) {
1152if ($search_note_public !=
'') {
1155if ($search_note_private !=
'') {
1158if ($search_multicurrency_code !=
'') {
1159 $sql .=
" AND c.multicurrency_code = '".$db->escape($search_multicurrency_code).
"'";
1161if ($search_multicurrency_tx !=
'') {
1162 $sql .=
natural_search(
'c.multicurrency_tx', $search_multicurrency_tx, 1);
1164if ($search_multicurrency_montant_ht !=
'') {
1165 $sql .=
natural_search(
'c.multicurrency_total_ht', $search_multicurrency_montant_ht, 1);
1167if ($search_multicurrency_montant_vat !=
'') {
1168 $sql .=
natural_search(
'c.multicurrency_total_tva', $search_multicurrency_montant_vat, 1);
1170if ($search_multicurrency_montant_ttc !=
'') {
1171 $sql .=
natural_search(
'c.multicurrency_total_ttc', $search_multicurrency_montant_ttc, 1);
1174 $sql .=
natural_search(array(
"u.login",
"u.firstname",
"u.lastname"), $search_login);
1176if ($search_project_ref !=
'') {
1179if ($search_project !=
'') {
1182if ($search_fk_cond_reglement > 0) {
1183 $sql .=
" AND c.fk_cond_reglement = ".((int) $search_fk_cond_reglement);
1185if ($search_fk_shipping_method > 0) {
1186 $sql .=
" AND c.fk_shipping_method = ".((int) $search_fk_shipping_method);
1188if ($search_fk_mode_reglement > 0) {
1189 $sql .=
" AND c.fk_mode_reglement = ".((int) $search_fk_mode_reglement);
1191if ($search_fk_input_reason > 0) {
1192 $sql .=
" AND c.fk_input_reason = ".((int) $search_fk_input_reason);
1194if ($search_module_source) {
1195 $sql .=
natural_search(
"c.module_source", $search_module_source);
1197if ($search_pos_source) {
1200if ($search_import_key) {
1204if ($search_user > 0) {
1205 $sql .=
" AND EXISTS (";
1206 $sql .=
" SELECT ec.fk_c_type_contact, ec.element_id, ec.fk_socpeople";
1207 $sql .=
" FROM ".MAIN_DB_PREFIX.
"element_contact as ec";
1208 $sql .=
" INNER JOIN ".MAIN_DB_PREFIX.
"c_type_contact as tc";
1209 $sql .=
" ON ec.fk_c_type_contact = tc.rowid AND tc.element = 'commande' AND tc.source = 'internal'";
1210 $sql .=
" WHERE ec.element_id = c.rowid AND ec.fk_socpeople = ".((int) $search_user).
")";
1213if ($search_sale && $search_sale !=
'-1') {
1214 if ($search_sale == -2) {
1215 $sql .=
" AND ".getSalesRepresentativeSqlFilter(
'c.fk_soc', 0, 1);
1216 } elseif ($search_sale > 0) {
1217 $sql .=
" AND ".getSalesRepresentativeSqlFilter(
'c.fk_soc', (
int) $search_sale);
1222if (!empty($searchCategoryOrderList)) {
1223 $searchCategoryOrderSqlList = array();
1224 $listofcategoryid =
'';
1225 foreach ($searchCategoryOrderList as $searchCategoryOrder) {
1226 if (intval($searchCategoryOrder) == -2) {
1227 $searchCategoryOrderSqlList[] =
"NOT EXISTS (SELECT ck.fk_order FROM ".MAIN_DB_PREFIX.
"categorie_order as ck WHERE c.rowid = ck.fk_order)";
1228 } elseif (intval($searchCategoryOrder) > 0) {
1229 if ($searchCategoryOrderOperator == 0) {
1230 $searchCategoryOrderSqlList[] =
" EXISTS (SELECT ck.fk_order FROM ".MAIN_DB_PREFIX.
"categorie_order as ck WHERE c.rowid = ck.fk_order AND ck.fk_categorie = ".((int) $searchCategoryOrder).
")";
1232 $listofcategoryid .= ($listofcategoryid ?
', ' :
'') .((
int) $searchCategoryOrder);
1236 if ($listofcategoryid) {
1237 $searchCategoryOrderSqlList[] =
" EXISTS (SELECT ck.fk_order FROM ".MAIN_DB_PREFIX.
"categorie_order as ck WHERE c.rowid = ck.fk_order AND ck.fk_categorie IN (".$db->sanitize($listofcategoryid).
"))";
1239 if ($searchCategoryOrderOperator == 1) {
1240 if (!empty($searchCategoryOrderSqlList)) {
1241 $sql .=
" AND (".implode(
' OR ', $searchCategoryOrderSqlList).
")";
1244 if (!empty($searchCategoryOrderSqlList)) {
1245 $sql .=
" AND (".implode(
' AND ', $searchCategoryOrderSqlList).
")";
1251$searchCategoryCustomerOperator =
GETPOSTINT(
'search_category_customer_operator');
1252$searchCategoryCustomerList = array($search_categ_cus);
1253if (!empty($searchCategoryCustomerList)) {
1254 $searchCategoryCustomerSqlList = array();
1255 $listofcategoryid =
'';
1256 foreach ($searchCategoryCustomerList as $searchCategoryCustomer) {
1257 if (intval($searchCategoryCustomer) == -2) {
1258 $searchCategoryCustomerSqlList[] =
"NOT EXISTS (SELECT cs.fk_soc FROM ".MAIN_DB_PREFIX.
"categorie_societe as cs WHERE s.rowid = cs.fk_soc)";
1259 } elseif (intval($searchCategoryCustomer) > 0) {
1260 if ($searchCategoryCustomerOperator == 0) {
1261 $searchCategoryCustomerSqlList[] =
" EXISTS (SELECT cs.fk_soc FROM ".MAIN_DB_PREFIX.
"categorie_societe as cs WHERE s.rowid = cs.fk_soc AND cs.fk_categorie = ".((int) $searchCategoryCustomer).
")";
1263 $listofcategoryid .= ($listofcategoryid ?
', ' :
'') .((
int) $searchCategoryCustomer);
1267 if ($listofcategoryid) {
1268 $searchCategoryCustomerSqlList[] =
" EXISTS (SELECT cs.fk_soc FROM ".MAIN_DB_PREFIX.
"categorie_societe as cs WHERE s.rowid = cs.fk_soc AND cs.fk_categorie IN (".$db->sanitize($listofcategoryid).
"))";
1270 if ($searchCategoryCustomerOperator == 1) {
1271 if (!empty($searchCategoryCustomerSqlList)) {
1272 $sql .=
" AND (".implode(
' OR ', $searchCategoryCustomerSqlList).
")";
1275 if (!empty($searchCategoryCustomerSqlList)) {
1276 $sql .=
" AND (".implode(
' AND ', $searchCategoryCustomerSqlList).
")";
1281$searchCategoryProductOperator =
GETPOSTINT(
'search_category_product_operator');
1282$searchCategoryProductList = array($search_product_category);
1283if (!empty($searchCategoryProductList)) {
1284 $searchCategoryProductSqlList = array();
1285 $listofcategoryid =
'';
1286 foreach ($searchCategoryProductList as $searchCategoryProduct) {
1287 if (intval($searchCategoryProduct) == -2) {
1288 $searchCategoryProductSqlList[] =
"NOT EXISTS (SELECT ck.fk_product FROM ".MAIN_DB_PREFIX.
"categorie_product as ck, ".MAIN_DB_PREFIX.
"commandedet as cd WHERE cd.fk_commande = c.rowid AND cd.fk_product = ck.fk_product)";
1289 } elseif (intval($searchCategoryProduct) > 0) {
1290 if ($searchCategoryProductOperator == 0) {
1291 $searchCategoryProductSqlList[] =
" EXISTS (SELECT ck.fk_product FROM ".MAIN_DB_PREFIX.
"categorie_product as ck, ".MAIN_DB_PREFIX.
"commandedet as cd WHERE cd.fk_commande = c.rowid AND cd.fk_product = ck.fk_product AND ck.fk_categorie = ".((int) $searchCategoryProduct).
")";
1293 $listofcategoryid .= ($listofcategoryid ?
', ' :
'') .((
int) $searchCategoryProduct);
1297 if ($listofcategoryid) {
1298 $searchCategoryProductSqlList[] =
" EXISTS (SELECT ck.fk_product FROM ".MAIN_DB_PREFIX.
"categorie_product as ck, ".MAIN_DB_PREFIX.
"commandedet as cd WHERE cd.fk_commande = c.rowid AND cd.fk_product = ck.fk_product AND ck.fk_categorie IN (".$db->sanitize($listofcategoryid).
"))";
1300 if ($searchCategoryProductOperator == 1) {
1301 if (!empty($searchCategoryProductSqlList)) {
1302 $sql .=
" AND (".implode(
' OR ', $searchCategoryProductSqlList).
")";
1305 if (!empty($searchCategoryProductSqlList)) {
1306 $sql .=
" AND (".implode(
' AND ', $searchCategoryProductSqlList).
")";
1311include DOL_DOCUMENT_ROOT.
'/core/tpl/extrafields_list_search_sql.tpl.php';
1313$parameters = array();
1314$reshook = $hookmanager->executeHooks(
'printFieldListWhere', $parameters, $object, $action);
1315$sql .= $hookmanager->resPrint;
1320 $fieldstosearchallwithoutpd = array();
1321 $fieldstosearchallwithpd = array();
1322 foreach ($fieldstosearchall as $key => $val) {
1323 if (!preg_match(
'/^pd\./', $key)) {
1324 $fieldstosearchallwithoutpd[$key] = $val;
1326 $fieldstosearchallwithpd[$key] = $val;
1330 if (count($fieldstosearchallwithpd) > 0) {
1331 $sqltoadd .=
" OR EXISTS (SELECT pd.rowid FROM ".MAIN_DB_PREFIX.
"commandedet as pd WHERE pd.fk_commande = c.rowid";
1332 $sqltoadd .=
natural_search(array_keys($fieldstosearchallwithpd),
'__KEYTOSEARCH__');
1336 $sql .=
natural_search(array_keys($fieldstosearchallwithoutpd), $search_all, 0, 0, $sqltoadd);
1340$parameters = array();
1341$reshook = $hookmanager->executeHooks(
'printFieldListHaving', $parameters, $object, $action);
1342if (empty($reshook)) {
1343 $sql .= empty($hookmanager->resPrint) ?
"" :
" HAVING 1=1 ".$hookmanager->resPrint;
1345 $sql = $hookmanager->resPrint;
1350$nbtotalofrecords =
'';
1353 $sqlforcount = preg_replace(
'/^'.preg_quote($sqlfields,
'/').
'/',
'SELECT COUNT(*) as nbtotalofrecords', $sql);
1354 $sqlforcount = preg_replace(
'/GROUP BY .*$/',
'', $sqlforcount);
1355 $resql = $db->query($sqlforcount);
1357 $objforcount = $db->fetch_object($resql);
1358 $nbtotalofrecords = $objforcount->nbtotalofrecords;
1360 dol_print_error($db);
1363 if (($page * $limit) > (
int) $nbtotalofrecords) {
1371$sql .= $db->order($sortfield, $sortorder);
1373 $sql .= $db->plimit($limit + 1, $offset);
1377$resql = $db->query($sql);
1379 dol_print_error($db);
1385 $soc->fetch($socid);
1386 $title = $langs->trans(
'CustomersOrders').
' - '.$soc->name;
1387 if (empty($search_company)) {
1388 $search_company = $soc->name;
1391 $title = $langs->trans(
'CustomersOrders');
1393if (strval($search_status) ==
'0') {
1394 $title .=
' - '.$langs->trans(
'StatusOrderDraftShort');
1396if ($search_status == 1) {
1397 $title .=
' - '.$langs->trans(
'StatusOrderValidatedShort');
1399if ($search_status == 2) {
1400 $title .=
' - '.$langs->trans(
'StatusOrderSentShort');
1402if ($search_status == 3) {
1403 $title .=
' - '.$langs->trans(
'StatusOrderToBillShort');
1405if ($search_status == -1) {
1406 $title .=
' - '.$langs->trans(
'StatusOrderCanceledShort');
1408if ($search_status == -2) {
1409 $title .=
' - '.$langs->trans(
'StatusOrderToProcessShort');
1411if ($search_status == -3) {
1412 $title .=
' - '.$langs->trans(
'StatusOrderValidated').
', '.(!
isModEnabled(
'shipping') ?
'' : $langs->trans(
"StatusOrderSent").
', ').$langs->trans(
'StatusOrderToBill');
1414if ($search_status == -4) {
1415 $title .=
' - '.$langs->trans(
"StatusOrderValidatedShort").
'+'.$langs->trans(
"StatusOrderSentShort");
1418$num = $db->num_rows($resql);
1420$arrayofselected = is_array($toselect) ? $toselect : array();
1422if ($num == 1 &&
getDolGlobalString(
'MAIN_SEARCH_DIRECT_OPEN_IF_ONLY_ONE') && $search_all) {
1423 $obj = $db->fetch_object($resql);
1425 header(
"Location: ".DOL_URL_ROOT.
'/commande/card.php?id='.
$id);
1432llxHeader(
'', $title, $help_url,
'', 0, 0,
'',
'',
'',
'bodyforlist mod-order page-list');
1434$arrayofselected = is_array($toselect) ? $toselect : array();
1438 $param .=
'&mode='.urlencode($mode);
1440if (!empty($contextpage) && $contextpage != $_SERVER[
"PHP_SELF"]) {
1441 $param .=
'&contextpage='.urlencode($contextpage);
1443if ($limit > 0 && $limit !=
$conf->liste_limit) {
1444 $param .=
'&limit='.((int) $limit);
1446if ($optioncss !=
'') {
1447 $param .=
'&optioncss='.urlencode($optioncss);
1450 $param .=
'&show_files='.urlencode((
string) ($show_files));
1453 $param .=
'&search_all='.urlencode($search_all);
1456 $param .=
'&socid='.((int) $socid);
1458if ($search_status !=
'') {
1459 $param .=
'&search_status='.urlencode($search_status);
1461if ($search_option) {
1462 $param .=
"&search_option=".urlencode($search_option);
1464if ($search_datecloture_start) {
1465 $param .=
'&search_datecloture_startday='.dol_print_date($search_datecloture_start,
'%d').
'&search_datecloture_startmonth='.
dol_print_date($search_datecloture_start,
'%m').
'&search_datecloture_startyear='.
dol_print_date($search_datecloture_start,
'%Y');
1467if ($search_datecloture_end) {
1468 $param .=
'&search_datecloture_endday='.dol_print_date($search_datecloture_end,
'%d').
'&search_datecloture_endmonth='.
dol_print_date($search_datecloture_end,
'%m').
'&search_datecloture_endyear='.
dol_print_date($search_datecloture_end,
'%Y');
1470if ($search_dateorder_start) {
1471 $param .=
'&search_dateorder_start_day='.dol_print_date($search_dateorder_start,
'%d').
'&search_dateorder_start_month='.
dol_print_date($search_dateorder_start,
'%m').
'&search_dateorder_start_year='.
dol_print_date($search_dateorder_start,
'%Y');
1473if ($search_dateorder_end) {
1474 $param .=
'&search_dateorder_end_day='.dol_print_date($search_dateorder_end,
'%d').
'&search_dateorder_end_month='.
dol_print_date($search_dateorder_end,
'%m').
'&search_dateorder_end_year='.
dol_print_date($search_dateorder_end,
'%Y');
1476if ($search_datedelivery_start) {
1477 $param .=
'&search_datedelivery_start_day='.dol_print_date($search_datedelivery_start,
'%d').
'&search_datedelivery_start_month='.
dol_print_date($search_datedelivery_start,
'%m').
'&search_datedelivery_start_year='.
dol_print_date($search_datedelivery_start,
'%Y');
1479if ($search_datedelivery_end) {
1480 $param .=
'&search_datedelivery_end_day='.dol_print_date($search_datedelivery_end,
'%d').
'&search_datedelivery_end_month='.
dol_print_date($search_datedelivery_end,
'%m').
'&search_datedelivery_end_year='.
dol_print_date($search_datedelivery_end,
'%Y');
1483 $param .=
'&search_id='.urlencode((
string) $search_id);
1486 $param .=
'&search_ref='.urlencode($search_ref);
1488if ($search_ref_ext) {
1489 $param .=
'&search_ref_ext='.urlencode($search_ref_ext);
1491if ($search_company) {
1492 $param .=
'&search_company='.urlencode($search_company);
1494if ($search_company_alias) {
1495 $param .=
'&search_company_alias='.urlencode($search_company_alias);
1497if ($search_parent_name !=
'') {
1498 $param .=
'&search_parent_name='.urlencode($search_parent_name);
1500if ($search_ref_customer) {
1501 $param .=
'&search_ref_customer='.urlencode($search_ref_customer);
1503if ($search_user > 0) {
1504 $param .=
'&search_user='.urlencode((
string) ($search_user));
1506if ($search_sale > 0) {
1507 $param .=
'&search_sale='.urlencode((
string) ($search_sale));
1509if ($search_total_ht !=
'') {
1510 $param .=
'&search_total_ht='.urlencode($search_total_ht);
1512if ($search_total_vat !=
'') {
1513 $param .=
'&search_total_vat='.urlencode($search_total_vat);
1515if ($search_total_ttc !=
'') {
1516 $param .=
'&search_total_ttc='.urlencode($search_total_ttc);
1518if ($search_warehouse !=
'') {
1519 $param .=
'&search_warehouse='.urlencode((
string) ($search_warehouse));
1522 $param .=
'&search_login='.urlencode($search_login);
1524if ($search_multicurrency_code !=
'') {
1525 $param .=
'&search_multicurrency_code='.urlencode($search_multicurrency_code);
1527if ($search_multicurrency_tx !=
'') {
1528 $param .=
'&search_multicurrency_tx='.urlencode($search_multicurrency_tx);
1530if ($search_multicurrency_montant_ht !=
'') {
1531 $param .=
'&search_multicurrency_montant_ht='.urlencode($search_multicurrency_montant_ht);
1533if ($search_multicurrency_montant_vat !=
'') {
1534 $param .=
'&search_multicurrency_montant_vat='.urlencode($search_multicurrency_montant_vat);
1536if ($search_multicurrency_montant_ttc !=
'') {
1537 $param .=
'&search_multicurrency_montant_ttc='.urlencode($search_multicurrency_montant_ttc);
1539if ($search_project_ref >= 0) {
1540 $param .=
"&search_project_ref=".urlencode($search_project_ref);
1542if ($search_project !=
'') {
1543 $param .=
"&search_project=".urlencode($search_project);
1545if ($search_town !=
'') {
1546 $param .=
'&search_town='.urlencode($search_town);
1548if ($search_zip !=
'') {
1549 $param .=
'&search_zip='.urlencode($search_zip);
1551if ($search_state !=
'') {
1552 $param .=
'&search_state='.urlencode($search_state);
1554if ($search_country !=
'') {
1555 $param .=
'&search_country='.urlencode((
string) ($search_country));
1557if ($search_type_thirdparty && $search_type_thirdparty !=
'-1') {
1558 $param .=
'&search_type_thirdparty='.urlencode((
string) ($search_type_thirdparty));
1560if ($searchCategoryOrderOperator == 1) {
1561 $param .=
"&search_category_order_operator=".urlencode((
string) ($searchCategoryOrderOperator));
1563foreach ($searchCategoryOrderList as $searchCategoryOrder) {
1564 $param .=
"&search_category_order_list[]=".urlencode($searchCategoryOrder);
1566if ($search_product_category !=
'') {
1567 $param .=
'&search_product_category='.urlencode((
string) ($search_product_category));
1569if (($search_categ_cus > 0) || ($search_categ_cus == -2)) {
1570 $param .=
'&search_categ_cus='.urlencode((
string) ($search_categ_cus));
1572if ($search_billed !=
'') {
1573 $param .=
'&search_billed='.urlencode($search_billed);
1575if ($search_fk_cond_reglement > 0) {
1576 $param .=
'&search_fk_cond_reglement='.urlencode((
string) ($search_fk_cond_reglement));
1578if ($search_fk_shipping_method > 0) {
1579 $param .=
'&search_fk_shipping_method='.urlencode((
string) ($search_fk_shipping_method));
1581if ($search_fk_mode_reglement > 0) {
1582 $param .=
'&search_fk_mode_reglement='.urlencode((
string) ($search_fk_mode_reglement));
1584if ($search_fk_input_reason > 0) {
1585 $param .=
'&search_fk_input_reason='.urlencode((
string) ($search_fk_input_reason));
1587if ($search_module_source) {
1588 $param .=
'&search_module_source='.urlencode($search_module_source);
1590if ($search_pos_source) {
1591 $param .=
'&search_pos_source='.urlencode($search_pos_source);
1593if ($search_import_key !=
'') {
1594 $param .=
'&search_import_key='.urlencode($search_import_key);
1598include DOL_DOCUMENT_ROOT.
'/core/tpl/extrafields_list_search_param.tpl.php';
1601$parameters = array();
1602$reshook = $hookmanager->executeHooks(
'printFieldListSearchParam', $parameters, $object, $action);
1603$param .= $hookmanager->resPrint;
1606$arrayofmassactions = array(
1607 'generate_doc' => img_picto(
'',
'pdf',
'class="pictofixedwidth"').$langs->trans(
"ReGeneratePDF"),
1608 'builddoc' => img_picto(
'',
'pdf',
'class="pictofixedwidth"').$langs->trans(
"PDFMerge"),
1610if (
isModEnabled(
'category') && $user->hasRight(
"commande",
"lire")) {
1611 $arrayofmassactions[
'preaffecttag'] = img_picto(
'',
'category',
'class="pictofixedwidth"').$langs->trans(
"AffectTag");
1613if ($permissiontovalidate) {
1614 $arrayofmassactions[
'prevalidate'] = img_picto(
'',
'check',
'class="pictofixedwidth"').$langs->trans(
"Validate");
1616if ($permissiontoclose) {
1617 $arrayofmassactions[
'preshipped'] = img_picto(
'',
'dolly',
'class="pictofixedwidth"').$langs->trans(
"ClassifyShipped");
1619if (
isModEnabled(
'invoice') && $user->hasRight(
"facture",
"creer")) {
1620 $arrayofmassactions[
'createbills'] = img_picto(
'',
'bill',
'class="pictofixedwidth"').$langs->trans(
"CreateInvoiceForThisCustomer");
1622if ($permissiontoclose) {
1623 $arrayofmassactions[
'setbilled'] = img_picto(
'',
'bill',
'class="pictofixedwidth"').$langs->trans(
"ClassifyBilled");
1625if ($permissiontocancel) {
1626 $arrayofmassactions[
'cancelorders'] = img_picto(
'',
'close_title',
'class="pictofixedwidth"').$langs->trans(
"CancelOrder");
1628if (!empty($permissiontodelete)) {
1629 $arrayofmassactions[
'predelete'] = img_picto(
'',
'delete',
'class="pictofixedwidth"').$langs->trans(
"Delete");
1631if ($permissiontosendbymail) {
1632 $arrayofmassactions[
'presend'] = img_picto(
'',
'email',
'class="pictofixedwidth"').$langs->trans(
"SendByMail");
1634if (in_array($massaction, array(
'presend',
'predelete',
'createbills'))) {
1635 $arrayofmassactions = array();
1637$massactionbutton = $form->selectMassAction(
'', $arrayofmassactions);
1639$url = DOL_URL_ROOT.
'/commande/card.php?action=create';
1640if (!empty($socid)) {
1641 $url .=
'&socid='.$socid;
1644$newcardbutton .=
dolGetButtonTitle($langs->trans(
'ViewList'),
'',
'fa fa-bars imgforviewmode', $_SERVER[
"PHP_SELF"].
'?mode=common'.preg_replace(
'/(&|\?)*mode=[^&]+/',
'', $param),
'', ((empty($mode) || $mode ==
'common') ? 2 : 1), array(
'morecss' =>
'reposition'));
1645$newcardbutton .=
dolGetButtonTitle($langs->trans(
'ViewKanban'),
'',
'fa fa-th-list imgforviewmode', $_SERVER[
"PHP_SELF"].
'?mode=kanban'.preg_replace(
'/(&|\?)*mode=[^&]+/',
'', $param),
'', ($mode ==
'kanban' ? 2 : 1), array(
'morecss' =>
'reposition'));
1646$newcardbutton .=
dolGetButtonTitle($langs->trans(
'Statistics'),
'',
'fa fa-chart-bar imgforviewmode', DOL_URL_ROOT.
'/commande/stats/index.php?'.preg_replace(
'/(&|\?)*(mode|groupby)=[^&]+/',
'', $param),
'', ($mode ==
'statistics' ? 2 : 1), array(
'morecss' =>
'reposition'));
1648$newcardbutton .=
dolGetButtonTitle($langs->trans(
'NewOrder'),
'',
'fa fa-plus-circle', $url,
'', (
int) (($contextpage ==
'orderlist' || $contextpage ==
'billableorders') && $permissiontoadd));
1651print
'<form method="POST" id="searchFormList" name="searchFormList" action="'.$_SERVER[
"PHP_SELF"].
'">'.
"\n";
1652if ($optioncss !=
'') {
1653 print
'<input type="hidden" name="optioncss" value="'.$optioncss.
'">';
1655print
'<input type="hidden" name="token" value="'.newToken().
'">';
1656print
'<input type="hidden" name="formfilteraction" id="formfilteraction" value="list">';
1657print
'<input type="hidden" name="action" value="list">';
1658print
'<input type="hidden" name="sortfield" value="'.$sortfield.
'">';
1659print
'<input type="hidden" name="sortorder" value="'.$sortorder.
'">';
1660print
'<input type="hidden" name="contextpage" value="'.$contextpage.
'">';
1661print
'<input type="hidden" name="search_status" value="'.$search_status.
'">';
1662print
'<input type="hidden" name="socid" value="'.$socid.
'">';
1663print
'<input type="hidden" name="page_y" value="">';
1664print
'<input type="hidden" name="mode" value="'.$mode.
'">';
1667print_barre_liste($title, $page, $_SERVER[
"PHP_SELF"], $param, $sortfield, $sortorder, $massactionbutton, $num, $nbtotalofrecords,
'order', 0, $newcardbutton,
'', $limit, 0, 0, 1);
1669$topicmail =
"SendOrderRef";
1670$modelmail =
"order_send";
1672$trackid =
'ord'.$object->id;
1673include DOL_DOCUMENT_ROOT.
'/core/tpl/massactions_pre.tpl.php';
1675if ($massaction ==
'prevalidate') {
1676 print $form->formconfirm($_SERVER[
"PHP_SELF"], $langs->trans(
"ConfirmMassValidation"), $langs->trans(
"ConfirmMassValidationQuestion"),
"validate",
null,
'', 0, 200, 500, 1);
1678if ($massaction ==
'preshipped') {
1679 print $form->formconfirm($_SERVER[
"PHP_SELF"], $langs->trans(
"CloseOrder"), $langs->trans(
"ConfirmCloseOrder"),
"shipped",
null,
'', 0, 200, 500, 1);
1682if ($massaction ==
'createbills') {
1683 print
'<input type="hidden" name="massaction" value="confirm_createbills">';
1685 print
'<table class="noborder centpercent">';
1688 print $langs->trans(
'DateInvoice');
1691 print $form->selectDate(
'',
'', 0, 0, 0,
'', 1, 1);
1696 print $langs->trans(
'CreateOneBillByThird');
1699 print $form->selectyesno(
'createbills_onebythird',
getDolGlobalString(
'MAIN_ORDERLIST_CREATEBILLS_ONEBYTHIRD',
'no'), 1);
1704 print $langs->trans(
'ValidateInvoices');
1708 print $form->selectyesno(
'validate_invoices', 0, 1, 1);
1709 $langs->load(
"errors");
1710 print
' ('.$langs->trans(
"WarningAutoValNotPossibleWhenStockIsDecreasedOnInvoiceVal").
')';
1712 print $form->selectyesno(
'validate_invoices', 0, 1);
1714 if (!empty(
$conf->workflow->enabled) &&
getDolGlobalString(
'WORKFLOW_INVOICE_AMOUNT_CLASSIFY_BILLED_ORDER')) {
1715 print
' <span class="opacitymedium">'.$langs->trans(
"IfValidateInvoiceIsNoOrderStayUnbilled").
'</span>';
1717 print
' <span class="opacitymedium">'.$langs->trans(
"OptionToSetOrderBilledNotEnabled").
'</span>';
1723 print
'<div class="center">';
1724 print
'<input type="submit" class="button" id="createbills" name="createbills" value="'.$langs->trans(
'CreateInvoiceForThisCustomer').
'"> ';
1725 print
'<input type="submit" class="button button-cancel" id="cancel" name="cancel" value="'.$langs->trans(
"Cancel").
'">';
1732 foreach ($fieldstosearchall as $key => $val) {
1733 $fieldstosearchall[$key] = $langs->trans($val);
1734 $setupstring .= $key.
"=".$val.
";";
1736 print
'<!-- Search done like if MYOBJECT_QUICKSEARCH_ON_FIELDS = '.$setupstring.
' -->'.
"\n";
1737 print
'<div class="divsearchfieldfilter">'.$langs->trans(
"FilterOnInto", $search_all).implode(
', ', $fieldstosearchall).
'</div>';
1742if (
isModEnabled(
'category') && $user->hasRight(
'categorie',
'read')) {
1744 $moreforfilter .= $formcategory->getFilterBox(Categorie::TYPE_ORDER, $searchCategoryOrderList,
'minwidth300', $searchCategoryOrderOperator ? $searchCategoryOrderOperator : 0);
1748if ($user->hasRight(
"user",
"user",
"lire")) {
1749 $langs->load(
"commercial");
1750 $moreforfilter .=
'<div class="divsearchfield">';
1751 $tmptitle = $langs->trans(
'ThirdPartiesOfSaleRepresentative');
1752 $moreforfilter .= img_picto($tmptitle,
'user',
'class="pictofixedwidth"').$formother->select_salesrepresentatives($search_sale,
'search_sale', $user, 0, $tmptitle,
'maxwidth250 widthcentpercentminusx');
1753 $moreforfilter .=
'</div>';
1756if ($user->hasRight(
"user",
"user",
"lire")) {
1757 $moreforfilter .=
'<div class="divsearchfield">';
1758 $tmptitle = $langs->trans(
'LinkedToSpecificUsers');
1759 $moreforfilter .= img_picto($tmptitle,
'user',
'class="pictofixedwidth"').$form->select_dolusers($search_user,
'search_user', $tmptitle,
null, 0,
'',
'',
'0', 0, 0,
'', 0,
'',
'maxwidth250 widthcentpercentminusx');
1760 $moreforfilter .=
'</div>';
1764if (
isModEnabled(
'category') && $user->hasRight(
"categorie",
"lire") && ($user->hasRight(
"produit",
"lire") || $user->hasRight(
"service",
"lire"))) {
1765 include_once DOL_DOCUMENT_ROOT.
'/categories/class/categorie.class.php';
1766 $moreforfilter .=
'<div class="divsearchfield">';
1767 $tmptitle = $langs->trans(
'IncludingProductWithTag');
1768 $cate_arbo = $form->select_all_categories(Categorie::TYPE_PRODUCT,
'',
'parent', 0, array(), 1);
1769 $moreforfilter .= img_picto($tmptitle,
'category',
'class="pictofixedwidth"').$form->selectarray(
'search_product_category', $cate_arbo, $search_product_category, $tmptitle, 0, 0,
'', 0, 0, 0,
'',
'maxwidth300 widthcentpercentminusx', 1);
1770 $moreforfilter .=
'</div>';
1773if (
isModEnabled(
'category') && $user->hasRight(
"categorie",
"lire")) {
1774 require_once DOL_DOCUMENT_ROOT.
'/categories/class/categorie.class.php';
1775 $moreforfilter .=
'<div class="divsearchfield">';
1776 $tmptitle = $langs->trans(
'CustomersProspectsCategoriesShort');
1777 $moreforfilter .= img_picto($tmptitle,
'category',
'class="pictofixedwidth"').$formother->select_categories(
'customer', $search_categ_cus,
'search_categ_cus', 1, $tmptitle,
'maxwidth300 widthcentpercentminusx');
1778 $moreforfilter .=
'</div>';
1782 $moreforfilter .=
'<div class="divsearchfield">';
1783 $tmptitle = $langs->trans(
'Warehouse');
1784 $moreforfilter .= img_picto($tmptitle,
'stock',
'class="pictofixedwidth"').$formproduct->selectWarehouses($search_warehouse,
'search_warehouse',
'', 1, 0, 0, $tmptitle, 0, 0, array(),
'maxwidth250 widthcentpercentminusx');
1785 $moreforfilter .=
'</div>';
1788$parameters = array();
1789$reshook = $hookmanager->executeHooks(
'printFieldPreListTitle', $parameters, $object, $action);
1790if (empty($reshook)) {
1791 $moreforfilter .= $hookmanager->resPrint;
1793 $moreforfilter = $hookmanager->resPrint;
1796if (!empty($moreforfilter)) {
1797 print
'<div class="liste_titre liste_titre_bydiv centpercent">';
1798 print $moreforfilter;
1802$varpage = empty($contextpage) ? $_SERVER[
"PHP_SELF"] : $contextpage;
1803$htmlofselectarray = $form->multiSelectArrayWithCheckbox(
'selectedfields', $arrayfields, $varpage,
$conf->main_checkbox_left_column);
1804$selectedfields = ($mode !=
'kanban' ? $htmlofselectarray :
'');
1805$selectedfields .= (count($arrayofmassactions) ? $form->showCheckAddButtons(
'checkforselect', 1) :
'');
1808 $selectedfields .=
'<script>';
1809 $selectedfields .=
' $(document).ready(function() {';
1810 $selectedfields .=
' console.log("Autoclick on checkforselects");';
1811 $selectedfields .=
' $("#checkforselects").click();';
1812 $selectedfields .=
' $("#massaction").val("createbills").change();';
1813 $selectedfields .=
' });';
1814 $selectedfields .=
'</script>';
1817print
'<div class="div-table-responsive">';
1818print
'<table class="tagtable nobottomiftotal liste'.($moreforfilter ?
" listwithfilterbefore" :
"").
'">'.
"\n";
1822print
'<tr class="liste_titre_filter">';
1824if (
$conf->main_checkbox_left_column) {
1825 print
'<td class="liste_titre center maxwidthsearch actioncolumn">';
1826 $searchpicto = $form->showFilterButtons(
'left');
1832if (!empty($arrayfields[
'c.rowid'][
'checked'])) {
1833 print
'<td class="liste_titre">';
1834 print
'<input class="flat" size="6" type="text" name="search_id" value="'.dol_escape_htmltag($search_id).
'">';
1839if (!empty($arrayfields[
'c.ref'][
'checked'])) {
1840 print
'<td class="liste_titre">';
1841 print
'<input class="flat maxwidth50imp" type="text" name="search_ref" value="'.dol_escape_htmltag($search_ref).
'">';
1845if (!empty($arrayfields[
'c.ref_ext'][
'checked'])) {
1846 print
'<td class="liste_titre">';
1847 print
'<input class="flat maxwidth50imp" type="text" name="search_ref_ext" value="'.dol_escape_htmltag($search_ref_ext).
'">';
1851if (!empty($arrayfields[
'c.ref_client'][
'checked'])) {
1852 print
'<td class="liste_titre" align="left">';
1853 print
'<input class="flat" type="text" size="6" name="search_ref_customer" value="'.dol_escape_htmltag($search_ref_customer).
'">';
1857if (!empty($arrayfields[
'p.ref'][
'checked'])) {
1858 print
'<td class="liste_titre"><input type="text" class="flat" size="6" name="search_project_ref" value="'.dol_escape_htmltag($search_project_ref).
'"></td>';
1861if (!empty($arrayfields[
'p.title'][
'checked'])) {
1862 print
'<td class="liste_titre"><input type="text" class="flat" size="6" name="search_project" value="'.dol_escape_htmltag($search_project).
'"></td>';
1865if (!empty($arrayfields[
's.nom'][
'checked'])) {
1866 print
'<td class="liste_titre">';
1867 print
'<input class="flat maxwidth75imp" type="text" name="search_company" value="'.dol_escape_htmltag((
string) $search_company).
'"'.(!empty($user->socid) ?
" disabled" :
"").
'>';
1871if (!empty($arrayfields[
's.name_alias'][
'checked'])) {
1872 print
'<td class="liste_titre">';
1873 print
'<input class="flat maxwidth75imp" type="text" name="search_company_alias" value="'.dol_escape_htmltag($search_company_alias).
'">';
1877if (!empty($arrayfields[
's2.nom'][
'checked'])) {
1878 print
'<td class="liste_titre">';
1879 print
'<input class="flat maxwidth100" type="text" name="search_parent_name" value="'.dol_escape_htmltag($search_parent_name).
'">';
1883if (!empty($arrayfields[
's.town'][
'checked'])) {
1884 print
'<td class="liste_titre"><input class="flat maxwidth75imp" type="text" name="search_town" value="'.dol_escape_htmltag($search_town).
'"></td>';
1887if (!empty($arrayfields[
's.zip'][
'checked'])) {
1888 print
'<td class="liste_titre"><input class="flat maxwidth50imp" type="text" name="search_zip" value="'.dol_escape_htmltag($search_zip).
'"></td>';
1891if (!empty($arrayfields[
'state.nom'][
'checked'])) {
1892 print
'<td class="liste_titre">';
1893 print
'<input class="flat maxwidth50imp" type="text" name="search_state" value="'.dol_escape_htmltag($search_state).
'">';
1897if (!empty($arrayfields[
'country.code_iso'][
'checked'])) {
1898 print
'<td class="liste_titre" align="center">';
1899 print $form->select_country($search_country,
'search_country',
'', 0,
'minwidth100imp maxwidth100');
1903if (!empty($arrayfields[
'typent.code'][
'checked'])) {
1904 print
'<td class="liste_titre maxwidthonsmartphone center">';
1905 print $form->selectarray(
"search_type_thirdparty", $formcompany->typent_array(0), $search_type_thirdparty, 1, 0, 0,
'', 0, 0, 0,
getDolGlobalString(
'SOCIETE_SORT_ON_TYPEENT',
'ASC'),
'', 1);
1909if (!empty($arrayfields[
'c.date_commande'][
'checked'])) {
1910 print
'<td class="liste_titre center">';
1911 print
'<div class="nowrapfordate">';
1912 print $form->selectDate($search_dateorder_start ? $search_dateorder_start : -1,
'search_dateorder_start_', 0, 0, 1,
'', 1, 0, 0,
'',
'',
'',
'', 1,
'', $langs->trans(
'From'));
1914 print
'<div class="nowrapfordate">';
1915 print $form->selectDate($search_dateorder_end ? $search_dateorder_end : -1,
'search_dateorder_end_', 0, 0, 1,
'', 1, 0, 0,
'',
'',
'',
'', 1,
'', $langs->trans(
'to'));
1919if (!empty($arrayfields[
'c.delivery_date'][
'checked'])) {
1920 print
'<td class="liste_titre center">';
1921 print
'<div class="nowrapfordate">';
1922 print $form->selectDate($search_datedelivery_start ? $search_datedelivery_start : -1,
'search_datedelivery_start_', 0, 0, 1,
'', 1, 0, 0,
'',
'',
'',
'', 1,
'', $langs->trans(
'From'));
1924 print
'<div class="nowrapfordate">';
1925 print $form->selectDate($search_datedelivery_end ? $search_datedelivery_end : -1,
'search_datedelivery_end_', 0, 0, 1,
'', 1, 0, 0,
'',
'',
'',
'', 1,
'', $langs->trans(
'to'));
1930if (!empty($arrayfields[
'c.fk_shipping_method'][
'checked'])) {
1931 print
'<td class="liste_titre">';
1932 $form->selectShippingMethod($search_fk_shipping_method,
'search_fk_shipping_method',
'', 1,
'', 1);
1936if (!empty($arrayfields[
'c.fk_cond_reglement'][
'checked'])) {
1937 print
'<td class="liste_titre">';
1938 print $form->getSelectConditionsPaiements((
int) $search_fk_cond_reglement,
'search_fk_cond_reglement', 1, 1, 1);
1942if (!empty($arrayfields[
'c.fk_mode_reglement'][
'checked'])) {
1943 print
'<td class="liste_titre">';
1944 print $form->select_types_paiements($search_fk_mode_reglement,
'search_fk_mode_reglement',
'', 0, 1, 1, 0, -1,
'', 1);
1948if (!empty($arrayfields[
'c.fk_input_reason'][
'checked'])) {
1949 print
'<td class="liste_titre">';
1950 $form->selectInputReason($search_fk_input_reason,
'search_fk_input_reason',
'', 1,
'', 1);
1954if (!empty($arrayfields[
'c.module_source'][
'checked'])) {
1955 print
'<td class="liste_titre">';
1956 print
'<input class="flat maxwidth75" type="text" name="search_module_source" value="'.dol_escape_htmltag($search_module_source).
'">';
1960if (!empty($arrayfields[
'c.pos_source'][
'checked'])) {
1961 print
'<td class="liste_titre">';
1962 print
'<input class="flat maxwidth50" type="text" name="search_pos_source" value="'.dol_escape_htmltag($search_pos_source).
'">';
1966if (!empty($arrayfields[
'c.total_ht'][
'checked'])) {
1967 print
'<td class="liste_titre right">';
1968 print
'<input class="flat" type="text" size="4" name="search_total_ht" value="'.dol_escape_htmltag($search_total_ht).
'">';
1972if (!empty($arrayfields[
'c.total_vat'][
'checked'])) {
1973 print
'<td class="liste_titre right">';
1974 print
'<input class="flat" type="text" size="4" name="search_total_vat" value="'.dol_escape_htmltag($search_total_vat).
'">';
1978if (!empty($arrayfields[
'c.total_ttc'][
'checked'])) {
1979 print
'<td class="liste_titre right">';
1980 print
'<input class="flat" type="text" size="5" name="search_total_ttc" value="'.$search_total_ttc.
'">';
1984if (!empty($arrayfields[
'c.multicurrency_code'][
'checked'])) {
1985 print
'<td class="liste_titre">';
1986 print $form->selectMultiCurrency($search_multicurrency_code,
'search_multicurrency_code', 1);
1990if (!empty($arrayfields[
'c.multicurrency_tx'][
'checked'])) {
1991 print
'<td class="liste_titre">';
1992 print
'<input class="flat" type="text" size="4" name="search_multicurrency_tx" value="'.dol_escape_htmltag($search_multicurrency_tx).
'">';
1996if (!empty($arrayfields[
'c.multicurrency_total_ht'][
'checked'])) {
1997 print
'<td class="liste_titre right">';
1998 print
'<input class="flat" type="text" size="4" name="search_multicurrency_montant_ht" value="'.dol_escape_htmltag($search_multicurrency_montant_ht).
'">';
2002if (!empty($arrayfields[
'c.multicurrency_total_vat'][
'checked'])) {
2003 print
'<td class="liste_titre right">';
2004 print
'<input class="flat" type="text" size="4" name="search_multicurrency_montant_vat" value="'.dol_escape_htmltag($search_multicurrency_montant_vat).
'">';
2008if (!empty($arrayfields[
'c.multicurrency_total_ttc'][
'checked'])) {
2009 print
'<td class="liste_titre right">';
2010 print
'<input class="flat width75" type="text" name="search_multicurrency_montant_ttc" value="'.dol_escape_htmltag($search_multicurrency_montant_ttc).
'">';
2014if (!empty($arrayfields[
'u.login'][
'checked'])) {
2015 print
'<td class="liste_titre">';
2016 print
'<input class="flat width75" type="text" name="search_login" value="'.dol_escape_htmltag($search_login).
'">';
2020if (!empty($arrayfields[
'sale_representative'][
'checked'])) {
2021 print
'<td class="liste_titre"></td>';
2023if (!empty($arrayfields[
'total_pa'][
'checked'])) {
2024 print
'<td class="liste_titre right">';
2027if (!empty($arrayfields[
'total_margin'][
'checked'])) {
2028 print
'<td class="liste_titre right">';
2031if (!empty($arrayfields[
'total_margin_rate'][
'checked'])) {
2032 print
'<td class="liste_titre right">';
2035if (!empty($arrayfields[
'total_mark_rate'][
'checked'])) {
2036 print
'<td class="liste_titre right">';
2041if (!empty($arrayfields[
'c.datec'][
'checked'])) {
2042 print
'<td class="liste_titre">';
2046if (!empty($arrayfields[
'c.tms'][
'checked'])) {
2047 print
'<td class="liste_titre">';
2051if (!empty($arrayfields[
'c.date_cloture'][
'checked'])) {
2052 print
'<td class="liste_titre center">';
2053 print
'<div class="nowrapfordate">';
2054 print $form->selectDate($search_datecloture_start ? $search_datecloture_start : -1,
'search_datecloture_start', 0, 0, 1,
'', 1, 0, 0,
'',
'',
'',
'', 1,
'', $langs->trans(
'From'));
2056 print
'<div class="nowrapfordate">';
2057 print $form->selectDate($search_datecloture_end ? $search_datecloture_end : -1,
'search_datecloture_end', 0, 0, 1,
'', 1, 0, 0,
'',
'',
'',
'', 1,
'', $langs->trans(
'to'));
2062if (!empty($arrayfields[
'c.note_public'][
'checked'])) {
2063 print
'<td class="liste_titre">';
2064 print
'<input class="flat width75" type="text" name="search_note_public" value="'.dolPrintHTMLForAttribute($search_note_public).
'">';
2068if (!empty($arrayfields[
'c.note_private'][
'checked'])) {
2069 print
'<td class="liste_titre">';
2070 print
'<input class="flat width75" type="text" name="search_note_private" value="'.dolPrintHTMLForAttribute($search_note_private).
'">';
2074if (!empty($arrayfields[
'shippable'][
'checked'])) {
2075 print
'<td class="liste_titre maxwidthonsmartphone" align="center">';
2078 print
'<input type="checkbox" name="show_shippable_command" value="1"'.($show_shippable_command ?
' checked' :
'').
'>';
2079 print $langs->trans(
'ShowShippableStatus');
2081 $show_shippable_command = 1;
2087include DOL_DOCUMENT_ROOT.
'/core/tpl/extrafields_list_search_input.tpl.php';
2090$parameters = array(
'arrayfields' => $arrayfields);
2091$reshook = $hookmanager->executeHooks(
'printFieldListOption', $parameters, $object, $action);
2092print $hookmanager->resPrint;
2095if (!empty($arrayfields[
'c.facture'][
'checked'])) {
2096 print
'<td class="liste_titre maxwidthonsmartphone center">';
2097 print $form->selectyesno(
'search_billed', $search_billed, 1, 0, 1, 1);
2102if (!empty($arrayfields[
'c.import_key'][
'checked'])) {
2103 print
'<td class="liste_titre maxwidthonsmartphone center">';
2104 print
'<input class="flat searchstring maxwidth50" type="text" name="search_import_key" value="'.dol_escape_htmltag($search_import_key).
'">';
2109if (!empty($arrayfields[
'c.fk_statut'][
'checked'])) {
2110 print
'<td class="liste_titre center parentonrightofpage">';
2111 $liststatus = array(
2115 -2 => $langs->trans(
"StatusOrderValidatedShort").
'+'.$langs->trans(
"StatusOrderSentShort"),
2116 -3 => $langs->trans(
"StatusOrderValidatedShort").
'+'.$langs->trans(
"StatusOrderSentShort").
'+'.$langs->trans(
"StatusOrderDelivered"),
2121 print $form->selectarray(
'search_status', $liststatus, $search_status, -5, 0, 0,
'', 0, 0, 0,
'',
'search_status width100 onrightofpage', 1);
2125if (!
$conf->main_checkbox_left_column) {
2126 print
'<td class="liste_titre center maxwidthsearch">';
2127 $searchpicto = $form->showFilterButtons();
2146print
'<tr class="liste_titre">';
2149if (
$conf->main_checkbox_left_column) {
2150 print_liste_field_titre($selectedfields, $_SERVER[
"PHP_SELF"],
"",
'', $param,
'', $sortfield, $sortorder,
'maxwidthsearch center ');
2151 $totalarray[
'nbfield']++;
2153if (!empty($arrayfields[
'c.rowid'][
'checked'])) {
2154 print_liste_field_titre($arrayfields[
'c.rowid'][
'label'], $_SERVER[
"PHP_SELF"],
'c.rowid',
'', $param,
'', $sortfield, $sortorder,
'center ');
2155 $totalarray[
'nbfield']++;
2157if (!empty($arrayfields[
'c.ref'][
'checked'])) {
2158 print_liste_field_titre($arrayfields[
'c.ref'][
'label'], $_SERVER[
"PHP_SELF"],
'c.ref',
'', $param,
'', $sortfield, $sortorder);
2159 $totalarray[
'nbfield']++;
2161if (!empty($arrayfields[
'c.ref_ext'][
'checked'])) {
2162 print_liste_field_titre($arrayfields[
'c.ref_ext'][
'label'], $_SERVER[
"PHP_SELF"],
'c.ref_ext',
'', $param,
'', $sortfield, $sortorder);
2163 $totalarray[
'nbfield']++;
2165if (!empty($arrayfields[
'c.ref_client'][
'checked'])) {
2166 print_liste_field_titre($arrayfields[
'c.ref_client'][
'label'], $_SERVER[
"PHP_SELF"],
'c.ref_client',
'', $param,
'', $sortfield, $sortorder);
2167 $totalarray[
'nbfield']++;
2169if (!empty($arrayfields[
'p.ref'][
'checked'])) {
2170 print_liste_field_titre($arrayfields[
'p.ref'][
'label'], $_SERVER[
"PHP_SELF"],
"p.ref",
"", $param,
'', $sortfield, $sortorder);
2171 $totalarray[
'nbfield']++;
2173if (!empty($arrayfields[
'p.title'][
'checked'])) {
2174 print_liste_field_titre($arrayfields[
'p.title'][
'label'], $_SERVER[
"PHP_SELF"],
"p.title",
"", $param,
'', $sortfield, $sortorder);
2175 $totalarray[
'nbfield']++;
2177if (!empty($arrayfields[
's.nom'][
'checked'])) {
2178 print_liste_field_titre($arrayfields[
's.nom'][
'label'], $_SERVER[
"PHP_SELF"],
's.nom',
'', $param,
'', $sortfield, $sortorder);
2179 $totalarray[
'nbfield']++;
2181if (!empty($arrayfields[
's.name_alias'][
'checked'])) {
2183 print_liste_field_titre($arrayfields[
's.name_alias'][
'label'], $_SERVER[
"PHP_SELF"],
's.name_alias',
'', $param,
'', $sortfield, $sortorder);
2184 $totalarray[
'nbfield']++;
2186if (!empty($arrayfields[
's2.nom'][
'checked'])) {
2187 print_liste_field_titre($arrayfields[
's2.nom'][
'label'], $_SERVER[
'PHP_SELF'],
's2.nom',
'', $param,
'', $sortfield, $sortorder);
2188 $totalarray[
'nbfield']++;
2190if (!empty($arrayfields[
's.town'][
'checked'])) {
2191 print_liste_field_titre($arrayfields[
's.town'][
'label'], $_SERVER[
"PHP_SELF"],
's.town',
'', $param,
'', $sortfield, $sortorder);
2192 $totalarray[
'nbfield']++;
2194if (!empty($arrayfields[
's.zip'][
'checked'])) {
2195 print_liste_field_titre($arrayfields[
's.zip'][
'label'], $_SERVER[
"PHP_SELF"],
's.zip',
'', $param,
'', $sortfield, $sortorder);
2196 $totalarray[
'nbfield']++;
2198if (!empty($arrayfields[
'state.nom'][
'checked'])) {
2199 print_liste_field_titre($arrayfields[
'state.nom'][
'label'], $_SERVER[
"PHP_SELF"],
"state.nom",
"", $param,
'', $sortfield, $sortorder);
2200 $totalarray[
'nbfield']++;
2202if (!empty($arrayfields[
'country.code_iso'][
'checked'])) {
2203 print_liste_field_titre($arrayfields[
'country.code_iso'][
'label'], $_SERVER[
"PHP_SELF"],
"country.code_iso",
"", $param,
'', $sortfield, $sortorder,
'center ');
2204 $totalarray[
'nbfield']++;
2206if (!empty($arrayfields[
'typent.code'][
'checked'])) {
2207 print_liste_field_titre($arrayfields[
'typent.code'][
'label'], $_SERVER[
"PHP_SELF"],
"typent.code",
"", $param,
'', $sortfield, $sortorder,
'center ');
2208 $totalarray[
'nbfield']++;
2210if (!empty($arrayfields[
'c.date_commande'][
'checked'])) {
2211 print_liste_field_titre($arrayfields[
'c.date_commande'][
'label'], $_SERVER[
"PHP_SELF"],
'c.date_commande',
'', $param,
'', $sortfield, $sortorder,
'center ');
2212 $totalarray[
'nbfield']++;
2214if (!empty($arrayfields[
'c.delivery_date'][
'checked'])) {
2215 print_liste_field_titre($arrayfields[
'c.delivery_date'][
'label'], $_SERVER[
"PHP_SELF"],
'c.date_livraison',
'', $param,
'', $sortfield, $sortorder,
'center ');
2216 $totalarray[
'nbfield']++;
2218if (!empty($arrayfields[
'c.fk_shipping_method'][
'checked'])) {
2219 print_liste_field_titre($arrayfields[
'c.fk_shipping_method'][
'label'], $_SERVER[
"PHP_SELF"],
"c.fk_shipping_method",
"", $param,
'', $sortfield, $sortorder);
2220 $totalarray[
'nbfield']++;
2222if (!empty($arrayfields[
'c.fk_cond_reglement'][
'checked'])) {
2223 print_liste_field_titre($arrayfields[
'c.fk_cond_reglement'][
'label'], $_SERVER[
"PHP_SELF"],
"c.fk_cond_reglement",
"", $param,
'', $sortfield, $sortorder);
2224 $totalarray[
'nbfield']++;
2226if (!empty($arrayfields[
'c.fk_mode_reglement'][
'checked'])) {
2227 print_liste_field_titre($arrayfields[
'c.fk_mode_reglement'][
'label'], $_SERVER[
"PHP_SELF"],
"c.fk_mode_reglement",
"", $param,
'', $sortfield, $sortorder);
2228 $totalarray[
'nbfield']++;
2230if (!empty($arrayfields[
'c.fk_input_reason'][
'checked'])) {
2231 print_liste_field_titre($arrayfields[
'c.fk_input_reason'][
'label'], $_SERVER[
"PHP_SELF"],
"c.fk_input_reason",
"", $param,
'', $sortfield, $sortorder);
2232 $totalarray[
'nbfield']++;
2234if (!empty($arrayfields[
'c.module_source'][
'checked'])) {
2235 print_liste_field_titre($arrayfields[
'c.module_source'][
'label'], $_SERVER[
"PHP_SELF"],
"f.module_source",
"", $param,
"", $sortfield, $sortorder);
2236 $totalarray[
'nbfield']++;
2238if (!empty($arrayfields[
'c.pos_source'][
'checked'])) {
2239 print_liste_field_titre($arrayfields[
'c.pos_source'][
'label'], $_SERVER[
"PHP_SELF"],
"f.pos_source",
"", $param,
"", $sortfield, $sortorder);
2240 $totalarray[
'nbfield']++;
2242if (!empty($arrayfields[
'c.total_ht'][
'checked'])) {
2243 print_liste_field_titre($arrayfields[
'c.total_ht'][
'label'], $_SERVER[
"PHP_SELF"],
'c.total_ht',
'', $param,
'', $sortfield, $sortorder,
'right ');
2244 $totalarray[
'nbfield']++;
2246if (!empty($arrayfields[
'c.total_vat'][
'checked'])) {
2247 print_liste_field_titre($arrayfields[
'c.total_vat'][
'label'], $_SERVER[
"PHP_SELF"],
'c.total_tva',
'', $param,
'', $sortfield, $sortorder,
'right ');
2248 $totalarray[
'nbfield']++;
2250if (!empty($arrayfields[
'c.total_ttc'][
'checked'])) {
2251 print_liste_field_titre($arrayfields[
'c.total_ttc'][
'label'], $_SERVER[
"PHP_SELF"],
'c.total_ttc',
'', $param,
'', $sortfield, $sortorder,
'right ');
2252 $totalarray[
'nbfield']++;
2254if (!empty($arrayfields[
'c.multicurrency_code'][
'checked'])) {
2255 print_liste_field_titre($arrayfields[
'c.multicurrency_code'][
'label'], $_SERVER[
'PHP_SELF'],
'c.multicurrency_code',
'', $param,
'', $sortfield, $sortorder);
2256 $totalarray[
'nbfield']++;
2258if (!empty($arrayfields[
'c.multicurrency_tx'][
'checked'])) {
2259 print_liste_field_titre($arrayfields[
'c.multicurrency_tx'][
'label'], $_SERVER[
'PHP_SELF'],
'c.multicurrency_tx',
'', $param,
'', $sortfield, $sortorder);
2260 $totalarray[
'nbfield']++;
2262if (!empty($arrayfields[
'c.multicurrency_total_ht'][
'checked'])) {
2263 print_liste_field_titre($arrayfields[
'c.multicurrency_total_ht'][
'label'], $_SERVER[
'PHP_SELF'],
'c.multicurrency_total_ht',
'', $param,
'class="right"', $sortfield, $sortorder);
2264 $totalarray[
'nbfield']++;
2266if (!empty($arrayfields[
'c.multicurrency_total_vat'][
'checked'])) {
2267 print_liste_field_titre($arrayfields[
'c.multicurrency_total_vat'][
'label'], $_SERVER[
'PHP_SELF'],
'c.multicurrency_total_tva',
'', $param,
'class="right"', $sortfield, $sortorder);
2268 $totalarray[
'nbfield']++;
2270if (!empty($arrayfields[
'c.multicurrency_total_ttc'][
'checked'])) {
2271 print_liste_field_titre($arrayfields[
'c.multicurrency_total_ttc'][
'label'], $_SERVER[
'PHP_SELF'],
'c.multicurrency_total_ttc',
'', $param,
'class="right"', $sortfield, $sortorder);
2272 $totalarray[
'nbfield']++;
2274if (!empty($arrayfields[
'u.login'][
'checked'])) {
2275 print_liste_field_titre($arrayfields[
'u.login'][
'label'], $_SERVER[
"PHP_SELF"],
'u.login',
'', $param,
'', $sortfield, $sortorder);
2276 $totalarray[
'nbfield']++;
2278if (!empty($arrayfields[
'sale_representative'][
'checked'])) {
2279 print_liste_field_titre($arrayfields[
'sale_representative'][
'label'], $_SERVER[
"PHP_SELF"],
"",
"",
"$param",
'', $sortfield, $sortorder);
2280 $totalarray[
'nbfield']++;
2282if (!empty($arrayfields[
'total_pa'][
'checked'])) {
2283 print_liste_field_titre($arrayfields[
'total_pa'][
'label'], $_SERVER[
'PHP_SELF'],
'',
'', $param,
'class="right"', $sortfield, $sortorder);
2284 $totalarray[
'nbfield']++;
2286if (!empty($arrayfields[
'total_margin'][
'checked'])) {
2287 print_liste_field_titre($arrayfields[
'total_margin'][
'label'], $_SERVER[
'PHP_SELF'],
'',
'', $param,
'class="right"', $sortfield, $sortorder);
2288 $totalarray[
'nbfield']++;
2290if (!empty($arrayfields[
'total_margin_rate'][
'checked'])) {
2291 print_liste_field_titre($arrayfields[
'total_margin_rate'][
'label'], $_SERVER[
'PHP_SELF'],
'',
'', $param,
'class="right"', $sortfield, $sortorder);
2292 $totalarray[
'nbfield']++;
2294if (!empty($arrayfields[
'total_mark_rate'][
'checked'])) {
2295 print_liste_field_titre($arrayfields[
'total_mark_rate'][
'label'], $_SERVER[
'PHP_SELF'],
'',
'', $param,
'class="right"', $sortfield, $sortorder);
2296 $totalarray[
'nbfield']++;
2299if (!empty($arrayfields[
'c.datec'][
'checked'])) {
2300 print_liste_field_titre($arrayfields[
'c.datec'][
'label'], $_SERVER[
"PHP_SELF"],
"c.date_creation",
"", $param,
'', $sortfield, $sortorder,
'center nowrap ');
2301 $totalarray[
'nbfield']++;
2303if (!empty($arrayfields[
'c.tms'][
'checked'])) {
2304 print_liste_field_titre($arrayfields[
'c.tms'][
'label'], $_SERVER[
"PHP_SELF"],
"c.tms",
"", $param,
'', $sortfield, $sortorder,
'center nowrap ');
2305 $totalarray[
'nbfield']++;
2307if (!empty($arrayfields[
'c.date_cloture'][
'checked'])) {
2308 print_liste_field_titre($arrayfields[
'c.date_cloture'][
'label'], $_SERVER[
"PHP_SELF"],
"c.date_cloture",
"", $param,
'', $sortfield, $sortorder,
'center nowrap ');
2309 $totalarray[
'nbfield']++;
2311if (!empty($arrayfields[
'c.note_public'][
'checked'])) {
2312 print_liste_field_titre($arrayfields[
'c.note_public'][
'label'], $_SERVER[
"PHP_SELF"],
"c.note_public",
"", $param,
'', $sortfield, $sortorder,
'');
2313 $totalarray[
'nbfield']++;
2315if (!empty($arrayfields[
'c.note_private'][
'checked'])) {
2316 print_liste_field_titre($arrayfields[
'c.note_private'][
'label'], $_SERVER[
"PHP_SELF"],
"c.note_private",
"", $param,
'', $sortfield, $sortorder,
'');
2317 $totalarray[
'nbfield']++;
2319if (!empty($arrayfields[
'shippable'][
'checked'])) {
2320 print_liste_field_titre($arrayfields[
'shippable'][
'label'], $_SERVER[
"PHP_SELF"],
'',
'', $param,
'', $sortfield, $sortorder,
'center ');
2321 $totalarray[
'nbfield']++;
2324include DOL_DOCUMENT_ROOT.
'/core/tpl/extrafields_list_search_title.tpl.php';
2327$parameters = array(
'arrayfields' => $arrayfields,
'param' => $param,
'sortfield' => $sortfield,
'sortorder' => $sortorder,
'totalarray' => &$totalarray);
2328$reshook = $hookmanager->executeHooks(
'printFieldListTitle', $parameters, $object, $action);
2329print $hookmanager->resPrint;
2332if (!empty($arrayfields[
'c.facture'][
'checked'])) {
2333 print_liste_field_titre($arrayfields[
'c.facture'][
'label'], $_SERVER[
"PHP_SELF"],
'c.facture',
'', $param,
'', $sortfield, $sortorder,
'center ');
2334 $totalarray[
'nbfield']++;
2337if (!empty($arrayfields[
'c.import_key'][
'checked'])) {
2338 print_liste_field_titre($arrayfields[
'c.import_key'][
'label'], $_SERVER[
"PHP_SELF"],
"c.import_key",
"", $param,
'', $sortfield, $sortorder,
'center ');
2339 $totalarray[
'nbfield']++;
2342if (!empty($arrayfields[
'c.fk_statut'][
'checked'])) {
2343 print_liste_field_titre($arrayfields[
'c.fk_statut'][
'label'], $_SERVER[
"PHP_SELF"],
"c.fk_statut",
"", $param,
'', $sortfield, $sortorder,
'center ');
2344 $totalarray[
'nbfield']++;
2347if (!
$conf->main_checkbox_left_column) {
2348 print_liste_field_titre($selectedfields, $_SERVER[
"PHP_SELF"],
"",
'', $param,
'', $sortfield, $sortorder,
'maxwidthsearch center ');
2349 $totalarray[
'nbfield']++;
2355$productstat_cache = array();
2356$productstat_cachevirtual = array();
2357$getNomUrl_cache = array();
2359$generic_commande =
new Commande($db);
2360$generic_product =
new Product($db);
2361$userstatic =
new User($db);
2363$with_margin_info =
false;
2365 !empty($arrayfields[
'total_pa'][
'checked'])
2366 || !empty($arrayfields[
'total_margin'][
'checked'])
2367 || !empty($arrayfields[
'total_margin_rate'][
'checked'])
2368 || !empty($arrayfields[
'total_mark_rate'][
'checked'])
2371 $with_margin_info =
true;
2380$savnbfield = $totalarray[
'nbfield'];
2381$totalarray = array();
2382$totalarray[
'nbfield'] = 0;
2383$imaxinloop = ($limit ? min($num, $limit) : $num);
2384while ($i < $imaxinloop) {
2385 $obj = $db->fetch_object($resql);
2390 $typenArray = $formcompany->typent_array(1);
2398 $companystatic->id = $obj->socid;
2399 $companystatic->name = $obj->name;
2400 $companystatic->name_alias = $obj->alias;
2401 $companystatic->client = $obj->client;
2402 $companystatic->fournisseur = $obj->fournisseur;
2403 $companystatic->code_client = $obj->code_client;
2404 $companystatic->email = $obj->email;
2405 $companystatic->phone = $obj->phone;
2406 $companystatic->address = $obj->address;
2407 $companystatic->zip = $obj->zip;
2408 $companystatic->town = $obj->town;
2409 $companystatic->country_code = $obj->country_code;
2410 if (!isset($getNomUrl_cache[$obj->socid])) {
2411 $getNomUrl_cache[$obj->socid] = $companystatic->getNomUrl(1,
'customer', 100, 0, 1, empty($arrayfields[
's.name_alias'][
'checked']) ? 0 : 1);
2414 $generic_commande->id = $obj->rowid;
2415 $generic_commande->ref = $obj->ref;
2416 $generic_commande->status = $obj->fk_statut;
2417 $generic_commande->statut = $obj->fk_statut;
2418 $generic_commande->status = $obj->fk_statut;
2419 $generic_commande->billed = $obj->billed;
2420 $generic_commande->date = $db->jdate($obj->date_commande);
2421 $generic_commande->delivery_date = $db->jdate($obj->delivery_date);
2422 $generic_commande->ref_client = $obj->ref_client;
2423 $generic_commande->total_ht = $obj->total_ht;
2424 $generic_commande->total_tva = $obj->total_tva;
2425 $generic_commande->total_ttc = $obj->total_ttc;
2426 $generic_commande->note_public = $obj->note_public;
2427 $generic_commande->note_private = $obj->note_private;
2429 $generic_commande->thirdparty = $companystatic;
2432 $projectstatic->id = $obj->project_id;
2433 $projectstatic->ref = $obj->project_ref;
2434 $projectstatic->title = $obj->project_label;
2436 $marginInfo = array();
2437 if ($with_margin_info) {
2438 $generic_commande->fetch_lines();
2439 $marginInfo = $formmargin->getMarginInfosArray($generic_commande);
2440 $total_ht += $obj->total_ht;
2441 $total_margin += $marginInfo[
'total_margin'];
2444 if ($mode ==
'kanban') {
2446 print
'<tr class="trkanban"><td colspan="'.$savnbfield.
'">';
2447 print
'<div class="box-flex-container kanban">';
2452 if ($massactionbutton || $massaction) {
2454 if (in_array(
$object->id, $arrayofselected)) {
2458 print $generic_commande->getKanbanView(
'', array(
'selected' => $selected));
2459 if ($i == ($imaxinloop - 1)) {
2466 print
'<tr data-rowid="'.$object->id.
'" class="oddeven row-with-select status'.$generic_commande->status.((getDolGlobalInt(
'MAIN_FINISHED_LINES_OPACITY') == 1 && $obj->status > 1) ?
' opacitymedium' :
'').
'">';
2469 if (
$conf->main_checkbox_left_column) {
2470 print
'<td class="nowrap center">';
2471 if ($massactionbutton || $massaction) {
2473 if (in_array($obj->rowid, $arrayofselected)) {
2476 print
'<input id="cb'.$obj->rowid.
'" class="flat checkforselect" type="checkbox" name="toselect[]" value="'.$obj->rowid.
'"'.($selected ?
' checked="checked"' :
'').
'>';
2480 $totalarray[
'nbfield']++;
2485 if (!empty($arrayfields[
'c.rowid'][
'checked'])) {
2486 print
'<td class="center" data-key="id">'.$obj->rowid.
'</td>';
2488 $totalarray[
'nbfield']++;
2493 if (!empty($arrayfields[
'c.ref'][
'checked'])) {
2494 print
'<td class="nowraponall">';
2495 $getNomUrlOption = $search_status != 2 ? 0 : $obj->fk_statut;
2501 $getNomUrlOption =
'';
2503 print $generic_commande->getNomUrl(1, $getNomUrlOption, 0, 0, 0, 1, 1);
2507 $urlsource = $_SERVER[
'PHP_SELF'].
'?id='.$obj->rowid;
2508 print $formfile->getDocumentsLink($generic_commande->element, $filename, $filedir);
2512 $totalarray[
'nbfield']++;
2517 if (!empty($arrayfields[
'c.ref_ext'][
'checked'])) {
2518 print
'<td class="nowrap tdoverflowmax75" title="'.dol_escape_htmltag($obj->ref_ext).
'">';
2522 $totalarray[
'nbfield']++;
2527 if (!empty($arrayfields[
'c.ref_client'][
'checked'])) {
2528 print
'<td class="nowrap tdoverflowmax150" title="'.dol_escape_htmltag($obj->ref_client).
'">';
2532 $totalarray[
'nbfield']++;
2537 if (!empty($arrayfields[
'p.ref'][
'checked'])) {
2538 print
'<td class="nocellnopadd nowraponall">';
2539 if ($obj->project_id > 0) {
2540 print $projectstatic->getNomUrl(1);
2544 $totalarray[
'nbfield']++;
2549 if (!empty($arrayfields[
'p.title'][
'checked'])) {
2550 print
'<td class="nowraponall">';
2551 if ($obj->project_id > 0) {
2552 print $projectstatic->title;
2556 $totalarray[
'nbfield']++;
2561 if (!empty($arrayfields[
's.nom'][
'checked'])) {
2562 print
'<td class="tdoverflowmax150">';
2564 print $companystatic->getNomUrl(1,
'customer', 100, 0, 1, empty($arrayfields[
's.name_alias'][
'checked']) ? 0 : 1);
2566 print $getNomUrl_cache[$obj->socid];
2571 if ($user->hasRight(
'facture',
'creer')) {
2572 if (($obj->fk_statut > 0 && $obj->fk_statut < 3) || ($obj->fk_statut == 3 && $obj->billed == 0)) {
2573 print
' <a href="'.DOL_URL_ROOT.
'/commande/list.php?socid='.$companystatic->id.
'&search_billed=0&autoselectall=1">';
2574 print img_picto($langs->trans(
"CreateInvoiceForThisCustomer").
' : '.$companystatic->name,
'object_bill',
'hideonsmartphone').
'</a>';
2580 $totalarray[
'nbfield']++;
2585 if (!empty($arrayfields[
's.name_alias'][
'checked'])) {
2586 print
'<td class="nocellnopadd tdoverflowmax100" title="'.dolPrintHTMLForAttribute($obj->alias).
'">';
2587 print
'<span class="spantitle">';
2588 print dolPrintLabel($obj->alias);
2592 $totalarray[
'nbfield']++;
2597 if (!empty($arrayfields[
's2.nom'][
'checked'])) {
2598 print
'<td class="tdoverflowmax200">';
2599 if ($obj->fk_parent > 0) {
2600 if (!isset($company_url_list[$obj->fk_parent])) {
2601 $companyparent =
new Societe($db);
2602 $res = $companyparent->fetch($obj->fk_parent);
2604 $company_url_list[$obj->fk_parent] = $companyparent->getNomUrl(1);
2607 if (isset($company_url_list[$obj->fk_parent])) {
2608 print $company_url_list[$obj->fk_parent];
2613 $totalarray[
'nbfield']++;
2618 if (!empty($arrayfields[
's.town'][
'checked'])) {
2619 print
'<td class="tdoverflowmax100" title="'.dolPrintHTMLForTextArea($obj->town).
'">';
2620 print dolPrintLabel($obj->town);
2623 $totalarray[
'nbfield']++;
2628 if (!empty($arrayfields[
's.zip'][
'checked'])) {
2629 print
'<td class="tdoverflowmax100" title="'.dolPrintHTMLForTextArea($obj->zip).
'">';
2630 print dolPrintLabel($obj->zip);
2633 $totalarray[
'nbfield']++;
2638 if (!empty($arrayfields[
'state.nom'][
'checked'])) {
2639 print
'<td class="tdoverflowmax100" title="'.dolPrintHTMLForTextArea($obj->state_name).
'">'.dolPrintLabel($obj->state_name).
"</td>\n";
2641 $totalarray[
'nbfield']++;
2646 if (!empty($arrayfields[
'country.code_iso'][
'checked'])) {
2647 $tmparray =
getCountry($obj->fk_pays,
'all');
2648 print
'<td class="center tdoverflowmax100" title="'.dolPrintHTMLForAttribute($tmparray[
'label']).
'">';
2649 print dolPrintHTML($tmparray[
'label']);
2652 $totalarray[
'nbfield']++;
2657 if (!empty($arrayfields[
'typent.code'][
'checked'])) {
2658 if (!is_array($typenArray) || count($typenArray) == 0) {
2659 $typenArray = $formcompany->typent_array(1);
2661 if (!empty($obj->typent_code)) {
2662 print
'<td class="center tdoverflowmax100" title="'.dolPrintHTMLForAttribute($typenArray[$obj->typent_code]).
'">';
2663 print $typenArray[$obj->typent_code];
2665 print
'<td class="center tdoverflowmax100">';
2670 $totalarray[
'nbfield']++;
2675 if (!empty($arrayfields[
'c.date_commande'][
'checked'])) {
2676 print
'<td class="center nowraponall">';
2679 if ($generic_commande->hasDelay()) {
2680 print img_picto($langs->trans(
"Late").
' : '.$generic_commande->showDelay(),
"warning");
2684 $totalarray[
'nbfield']++;
2689 if (!empty($arrayfields[
'c.delivery_date'][
'checked'])) {
2690 print
'<td class="center nowraponall">';
2691 print
dol_print_date($db->jdate($obj->delivery_date),
'dayhour');
2694 $totalarray[
'nbfield']++;
2699 if (!empty($arrayfields[
'c.fk_shipping_method'][
'checked'])) {
2701 $form->formSelectShippingMethod(
'', $obj->fk_shipping_method,
'none', 1);
2704 $totalarray[
'nbfield']++;
2709 if (!empty($arrayfields[
'c.fk_cond_reglement'][
'checked'])) {
2711 $form->form_conditions_reglement($_SERVER[
'PHP_SELF'], $obj->fk_cond_reglement,
'none', 0,
'', 1, $obj->deposit_percent);
2714 $totalarray[
'nbfield']++;
2719 if (!empty($arrayfields[
'c.fk_mode_reglement'][
'checked'])) {
2721 $form->form_modes_reglement($_SERVER[
'PHP_SELF'], $obj->fk_mode_reglement,
'none',
'', -1);
2724 $totalarray[
'nbfield']++;
2729 if (!empty($arrayfields[
'c.fk_input_reason'][
'checked'])) {
2731 $form->formInputReason($_SERVER[
'PHP_SELF'], $obj->fk_input_reason,
'none', 0);
2734 $totalarray[
'nbfield']++;
2739 if (!empty($arrayfields[
'c.module_source'][
'checked'])) {
2744 $totalarray[
'nbfield']++;
2748 if (!empty($arrayfields[
'c.pos_source'][
'checked'])) {
2753 $totalarray[
'nbfield']++;
2758 if (!empty($arrayfields[
'c.total_ht'][
'checked'])) {
2759 print
'<td class="nowraponall right"><span class="amount">'.price($obj->total_ht).
"</span></td>\n";
2761 $totalarray[
'nbfield']++;
2764 $totalarray[
'pos'][$totalarray[
'nbfield']] =
'c.total_ht';
2766 if (isset($totalarray[
'val'][
'c.total_ht'])) {
2767 $totalarray[
'val'][
'c.total_ht'] += $obj->total_ht;
2769 $totalarray[
'val'][
'c.total_ht'] = $obj->total_ht;
2774 if (!empty($arrayfields[
'c.total_vat'][
'checked'])) {
2775 print
'<td class="nowrap right"><span class="amount">'.price($obj->total_tva).
"</span></td>\n";
2777 $totalarray[
'nbfield']++;
2780 $totalarray[
'pos'][$totalarray[
'nbfield']] =
'c.total_tva';
2782 if (isset($totalarray[
'val'][
'c.total_tva'])) {
2783 $totalarray[
'val'][
'c.total_tva'] += $obj->total_tva;
2785 $totalarray[
'val'][
'c.total_tva'] = $obj->total_tva;
2790 if (!empty($arrayfields[
'c.total_ttc'][
'checked'])) {
2791 print
'<td class="nowrap right"><span class="amount">'.price($obj->total_ttc).
"</span></td>\n";
2793 $totalarray[
'nbfield']++;
2796 $totalarray[
'pos'][$totalarray[
'nbfield']] =
'c.total_ttc';
2798 if (isset($totalarray[
'val'][
'c.total_ttc'])) {
2799 $totalarray[
'val'][
'c.total_ttc'] += $obj->total_ttc;
2801 $totalarray[
'val'][
'c.total_ttc'] = $obj->total_ttc;
2806 if (!empty($arrayfields[
'c.multicurrency_code'][
'checked'])) {
2807 print
'<td class="nowrap">'.$obj->multicurrency_code.
' - '.$langs->trans(
'Currency'.$obj->multicurrency_code).
"</td>\n";
2809 $totalarray[
'nbfield']++;
2814 if (!empty($arrayfields[
'c.multicurrency_tx'][
'checked'])) {
2815 print
'<td class="nowrap">';
2816 $form->form_multicurrency_rate($_SERVER[
'PHP_SELF'].
'?id='.$obj->rowid, $obj->multicurrency_tx,
'none', $obj->multicurrency_code);
2819 $totalarray[
'nbfield']++;
2824 if (!empty($arrayfields[
'c.multicurrency_total_ht'][
'checked'])) {
2825 print
'<td class="right nowrap"><span class="amount">'.price($obj->multicurrency_total_ht).
"</span></td>\n";
2827 $totalarray[
'nbfield']++;
2831 if (!empty($arrayfields[
'c.multicurrency_total_vat'][
'checked'])) {
2832 print
'<td class="right nowrap"><span class="amount">'.price($obj->multicurrency_total_vat).
"</span></td>\n";
2834 $totalarray[
'nbfield']++;
2838 if (!empty($arrayfields[
'c.multicurrency_total_ttc'][
'checked'])) {
2839 print
'<td class="right nowrap"><span class="amount">'.price($obj->multicurrency_total_ttc).
"</span></td>\n";
2841 $totalarray[
'nbfield']++;
2845 $userstatic->id = $obj->fk_user_author;
2846 $userstatic->login = $obj->login;
2847 $userstatic->lastname = $obj->lastname;
2848 $userstatic->firstname = $obj->firstname;
2849 $userstatic->email = $obj->user_email;
2850 $userstatic->status = $obj->user_statut;
2851 $userstatic->entity = $obj->entity;
2852 $userstatic->photo = $obj->photo;
2853 $userstatic->office_phone = $obj->office_phone;
2854 $userstatic->office_fax = $obj->office_fax;
2855 $userstatic->user_mobile = $obj->user_mobile;
2856 $userstatic->job = $obj->job;
2857 $userstatic->gender = $obj->gender;
2860 if (!empty($arrayfields[
'u.login'][
'checked'])) {
2861 print
'<td class="tdoverflowmax125">';
2862 if ($userstatic->id) {
2863 print $userstatic->getNomUrl(-1);
2869 $totalarray[
'nbfield']++;
2874 if (!empty($arrayfields[
'sale_representative'][
'checked'])) {
2876 if ($obj->socid > 0) {
2877 $listsalesrepresentatives = $companystatic->getSalesRepresentatives($user);
2878 if ($listsalesrepresentatives < 0) {
2879 dol_print_error($db);
2881 $nbofsalesrepresentative = count($listsalesrepresentatives);
2882 if ($nbofsalesrepresentative > 6) {
2884 print $nbofsalesrepresentative;
2885 } elseif ($nbofsalesrepresentative > 0) {
2887 foreach ($listsalesrepresentatives as $val) {
2888 $userstatic->id = $val[
'id'];
2889 $userstatic->lastname = $val[
'lastname'];
2890 $userstatic->firstname = $val[
'firstname'];
2891 $userstatic->email = $val[
'email'];
2892 $userstatic->status = $val[
'statut'];
2893 $userstatic->entity = $val[
'entity'];
2894 $userstatic->photo = $val[
'photo'];
2895 $userstatic->login = $val[
'login'];
2896 $userstatic->office_phone = $val[
'office_phone'];
2897 $userstatic->office_fax = $val[
'office_fax'];
2898 $userstatic->user_mobile = $val[
'user_mobile'];
2899 $userstatic->job = $val[
'job'];
2900 $userstatic->gender = $val[
'gender'];
2902 print ($nbofsalesrepresentative < 2) ? $userstatic->getNomUrl(-1,
'', 0, 0, 12) : $userstatic->getNomUrl(-2);
2904 if ($j < $nbofsalesrepresentative) {
2916 $totalarray[
'nbfield']++;
2921 if (!empty($arrayfields[
'total_pa'][
'checked'])) {
2922 print
'<td class="right nowrap">'.price($marginInfo[
'pa_total']).
'</td>';
2924 $totalarray[
'nbfield']++;
2929 if (!empty($arrayfields[
'total_margin'][
'checked'])) {
2930 print
'<td class="right nowrap">'.price($marginInfo[
'total_margin']).
'</td>';
2932 $totalarray[
'nbfield']++;
2935 $totalarray[
'pos'][$totalarray[
'nbfield']] =
'total_margin';
2938 if (!isset($totalarray[
'val'][
'total_margin'])) {
2939 $totalarray[
'val'][
'total_margin'] = 0;
2942 $totalarray[
'val'][
'total_margin'] += $marginInfo[
'total_margin'];
2946 if (!empty($arrayfields[
'total_margin_rate'][
'checked'])) {
2947 print
'<td class="right nowrap">'.(($marginInfo[
'total_margin_rate'] ==
'') ?
'' :
price($marginInfo[
'total_margin_rate'], 0,
'', 0, 0, 2).
'%').
'</td>';
2949 $totalarray[
'nbfield']++;
2954 if (!empty($arrayfields[
'total_mark_rate'][
'checked'])) {
2955 print
'<td class="right nowrap">'.(($marginInfo[
'total_mark_rate'] ==
'') ?
'' :
price($marginInfo[
'total_mark_rate'], 0,
'', 0, 0, 2).
'%').
'</td>';
2957 $totalarray[
'nbfield']++;
2960 $totalarray[
'pos'][$totalarray[
'nbfield']] =
'total_mark_rate';
2962 if ($i >= $imaxinloop - 1) {
2963 if (!empty($total_ht)) {
2964 $totalarray[
'val'][
'total_mark_rate'] =
price2num($total_margin * 100 / $total_ht,
'MT');
2966 $totalarray[
'val'][
'total_mark_rate'] =
'';
2972 if (!empty($arrayfields[
'c.datec'][
'checked'])) {
2973 print
'<td class="center nowraponall">';
2974 print
dol_print_date($db->jdate($obj->date_creation),
'dayhour',
'tzuserrel');
2977 $totalarray[
'nbfield']++;
2982 if (!empty($arrayfields[
'c.tms'][
'checked'])) {
2983 print
'<td class="center nowraponall">';
2984 print
dol_print_date($db->jdate($obj->date_modification),
'dayhour',
'tzuserrel');
2987 $totalarray[
'nbfield']++;
2992 if (!empty($arrayfields[
'c.date_cloture'][
'checked'])) {
2993 print
'<td class="center nowraponall">';
2994 print
dol_print_date($db->jdate($obj->date_cloture),
'dayhour',
'tzuserrel');
2997 $totalarray[
'nbfield']++;
3002 if (!empty($arrayfields[
'c.note_public'][
'checked'])) {
3003 print
'<td class="sensiblehtmlcontent maxwidth250imp classfortooltip" title="'.dolPrintHTMLForAttribute(
dolGetFirstLineOfText($obj->note_public, 20)).
'">';
3004 print
'<div class="small lineheightsmall twolinesmax-normallineheight">'.dolPrintHTML(
dolGetFirstLineOfText($obj->note_public, 5)).
'</div>';
3007 $totalarray[
'nbfield']++;
3012 if (!empty($arrayfields[
'c.note_private'][
'checked'])) {
3013 print
'<td class="sensiblehtmlcontent maxwidth250imp classfortooltip" title="'.dolPrintHTMLForAttribute(
dolGetFirstLineOfText($obj->note_private, 20)).
'">';
3014 print
'<div class="small lineheightsmall twolinesmax-normallineheight">'.dolPrintHTML(
dolGetFirstLineOfText($obj->note_private, 5)).
'</div>';
3017 $totalarray[
'nbfield']++;
3022 if (!empty($arrayfields[
'shippable'][
'checked'])) {
3023 print
'<td class="center">';
3024 if (!empty($show_shippable_command) &&
isModEnabled(
'stock')) {
3026 $commande->id = (int) $obj->rowid;
3027 $commande->status = (int) $obj->fk_statut;
3028 $commande->statut = (int) $obj->fk_statut;
3030 $shippableInfos = $commande->getShippableInfos();
3032 if ($shippableInfos[
'has_product']) {
3033 print
'<a href="'.DOL_URL_ROOT.
'/expedition/shipment.php?id='.(int) $obj->rowid.
'">';
3034 print $form->textwithtooltip(
'', $shippableInfos[
'textinfo'], 2, 1, $shippableInfos[
'texticon'],
'', 2);
3037 if (!empty($shippableInfos[
'warning'])) {
3039 print $form->textwithtooltip(
'', $langs->trans(
"NotEnoughForAllOrders"), 2, 1, img_picto(
'',
'error',
'', 0, 0, 0,
'',
'2'),
'', 2);
3045 $totalarray[
'nbfield']++;
3050 include DOL_DOCUMENT_ROOT.
'/core/tpl/extrafields_list_print_fields.tpl.php';
3052 $parameters = array(
'arrayfields' => $arrayfields,
'obj' => $obj,
'i' => $i,
'totalarray' => &$totalarray);
3053 $reshook = $hookmanager->executeHooks(
'printFieldListValue', $parameters, $object, $action);
3054 print $hookmanager->resPrint;
3057 if (!empty($arrayfields[
'c.facture'][
'checked'])) {
3058 print
'<td class="center">';
3060 print yn($obj->billed, $langs->trans(
"Billed"));
3064 $totalarray[
'nbfield']++;
3069 if (!empty($arrayfields[
'c.import_key'][
'checked'])) {
3070 print
'<td class="nowrap center">'.dol_escape_htmltag($obj->import_key).
'</td>';
3072 $totalarray[
'nbfield']++;
3077 if (!empty($arrayfields[
'c.fk_statut'][
'checked'])) {
3078 print
'<td class="nowrap center">'.$generic_commande->LibStatut($obj->fk_statut, $obj->billed, 5, 1).
'</td>';
3080 $totalarray[
'nbfield']++;
3085 if (!
$conf->main_checkbox_left_column) {
3086 print
'<td class="nowrap center">';
3087 if ($massactionbutton || $massaction) {
3089 if (in_array($obj->rowid, $arrayofselected)) {
3092 print
'<input id="cb'.$obj->rowid.
'" class="flat checkforselect" type="checkbox" name="toselect[]" value="'.$obj->rowid.
'"'.($selected ?
' checked="checked"' :
'').
'>';
3096 $totalarray[
'nbfield']++;
3102 $total += $obj->total_ht;
3103 $subtotal += $obj->total_ht;
3109include DOL_DOCUMENT_ROOT.
'/core/tpl/list_print_total.tpl.php';
3114 foreach ($arrayfields as $key => $val) {
3115 if (!empty($val[
'checked'])) {
3119 print
'<tr><td colspan="'.$colspan.
'"><span class="opacitymedium">'.$langs->trans(
"NoRecordFound").
'</span></td></tr>';
3124$parameters = array(
'arrayfields' => $arrayfields,
'sql' => $sql);
3125$reshook = $hookmanager->executeHooks(
'printFieldListFooter', $parameters, $object, $action);
3126print $hookmanager->resPrint;
3128print
'</table>'.
"\n";
3131print
'</form>'.
"\n";
3133if (in_array(
'builddoc', array_keys($arrayofmassactions)) && ($nbtotalofrecords ===
'' || $nbtotalofrecords)) {
3134 $hidegeneratedfilelistifempty = 1;
3135 if ($massaction ==
'builddoc' || $action ==
'remove_file' || $show_files) {
3136 $hidegeneratedfilelistifempty = 0;
3140 $urlsource = $_SERVER[
'PHP_SELF'].
'?sortfield='.$sortfield.
'&sortorder='.$sortorder;
3141 $urlsource .= str_replace(
'&',
'&', $param);
3143 $filedir = $diroutputmassaction;
3144 $genallowed = $permissiontoread;
3145 $delallowed = $permissiontoadd;
3147 print $formfile->showdocuments(
'massfilesarea_orders',
'', $filedir, $urlsource, 0, $delallowed,
'', 1, 1, 0, 48, 1, $param, $title,
'',
'',
'',
null, $hidegeneratedfilelistifempty);
$id
Support class for third parties, contacts, members, users or resources.
if(! $sortfield) if(! $sortorder) $object
llxFooter($comment='', $zone='private', $disabledoutputofmessages=0)
Empty footer.
if(!defined('NOREQUIRESOC')) if(!defined( 'NOREQUIRETRAN')) if(!defined('NOTOKENRENEWAL')) if(!defined( 'NOREQUIREMENU')) if(!defined('NOREQUIREHTML')) if(!defined( 'NOREQUIREAJAX')) llxHeader($head='', $title='', $help_url='', $target='', $disablejs=0, $disablehead=0, $arrayofjs='', $arrayofcss='', $morequerystring='', $morecssonbody='', $replacemainareaby='', $disablenofollow=0, $disablenoindex=0)
Empty header.
if(!isModEnabled('ai')||!getDolGlobalString('AI_ASSISTANT_ENABLED')) global $conf
The main.inc.php has been included so the following variable are now defined:
Class to manage customers orders.
const STATUS_SHIPMENTONPROCESS
Shipment on process.
const STATUS_CLOSED
Closed (Sent, billed or not)
const STATUS_CANCELED
Canceled status.
const STATUS_DRAFT
Draft status.
const STATUS_VALIDATED
Validated status.
Class to manage absolute discounts.
Class to manage invoices.
Class to manage invoice lines.
Class to manage products or services.
Class to manage projects.
Class to manage third parties objects (customers, suppliers, prospects...)
Class to manage Dolibarr users.
getCountry($searchkey, $withcode='', $dbtouse=null, $outputlangs=null, $entconv=1, $searchlabel='')
Return country label, code or id from an id, code or label.
$date_start
Variables from include:
dol_now($mode='gmt')
Return date for now.
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...
price2num($amount, $rounding='', $option=0, $currencycode='')
Function that return a number with universal decimal format (decimal separator is '.
dolGetFirstLineOfText($text, $nboflines=1, $charset='UTF-8')
Return first line of text.
dol_sanitizeFileName($str, $newstr='_', $unaccent=1, $includequotes=0, $allowdash=0)
Clean a string to use it as a file name.
price($amount, $form=0, $outlangs='', $trunc=1, $rounding=-1, $forcerounding=-1, $currency_code='')
Function to format a value into an amount for visual output Function used into PDF and HTML pages.
natural_search($fields, $value, $mode=0, $nofirstand=0, $sqltoadd='')
Generate natural SQL search string for a criteria (this criteria can be tested on one or several fiel...
getDolGlobalInt($key, $default=0)
Return a Dolibarr global constant int value.
dol_sort_array(&$array, $index, $order='asc', $natsort=0, $case_sensitive=0, $keepindex=0)
Advanced sort array by the value of a given key, which produces ascending (default) or descending out...
GETPOST($paramname, $check='alphanohtml', $method=0, $filter=null, $options=null, $noreplace=0, $nodefault=0)
Return value of a param into GET or POST supervariable.
dol_concatdesc($text1, $text2, $forxml=false, $invert=false)
Concat 2 descriptions with a new line between them (second operand after first one with appropriate n...
GETPOSTINT($paramname, $method=0, $nodefault=0)
Return the value of a $_GET or $_POST supervariable, converted into integer.
dol_print_date($time, $format='', $tzoutput='auto', $outputlangs=null, $encodetooutput=false, $decorate=0)
Output date in a string format according to outputlangs (or langs if not defined).
GETPOSTISSET($paramname)
Return true if we are in a context of submitting the parameter $paramname from a POST of a form.
getDolGlobalString($key, $default='')
Return a Dolibarr global constant string value.
isModEnabled($module)
Is Dolibarr module enabled.
print_liste_field_titre($name, $file="", $field="", $begin="", $param="", $moreattrib="", $sortfield="", $sortorder="", $prefix="", $tooltip="", $forcenowrapcolumntitle=0)
Show title line of an array.
dolGetButtonTitle($label, $helpText='', $iconClass='fa fa-file', $url='', $id='', $status=1, $params=array())
Function dolGetButtonTitle : this kind of buttons are used in title in list.
dolGetButtonTitleSeparator($moreClass="")
Add space between dolGetButtonTitle.
dol_escape_htmltag($stringtoescape, $keepb=0, $keepn=0, $noescapetags='', $escapeonlyhtmltags=0, $cleanalsojavascript=0)
restrictedArea(User $user, $features, $object=0, $tableandshare='', $feature2='', $dbt_keyfield='fk_soc', $dbt_select='rowid', $isdraft=0, $nodie=0, $mode='')
Check permissions of a user to show a page and an object.