44require
'../main.inc.php';
45require_once DOL_DOCUMENT_ROOT.
'/core/lib/date.lib.php';
46require_once DOL_DOCUMENT_ROOT.
'/core/lib/company.lib.php';
47require_once DOL_DOCUMENT_ROOT.
'/core/class/discount.class.php';
48require_once DOL_DOCUMENT_ROOT.
'/core/class/html.formfile.class.php';
49require_once DOL_DOCUMENT_ROOT.
'/core/class/html.formother.class.php';
50require_once DOL_DOCUMENT_ROOT.
'/core/class/html.formcompany.class.php';
52 require_once DOL_DOCUMENT_ROOT.
'/core/class/html.formmargin.class.php';
54require_once DOL_DOCUMENT_ROOT.
'/commande/class/commande.class.php';
55require_once DOL_DOCUMENT_ROOT.
'/compta/facture/class/facture.class.php';
56require_once DOL_DOCUMENT_ROOT.
'/product/class/product.class.php';
57require_once DOL_DOCUMENT_ROOT.
'/projet/class/project.class.php';
60 require_once DOL_DOCUMENT_ROOT.
'/categories/class/categorie.class.php';
61 require_once DOL_DOCUMENT_ROOT.
'/core/class/html.formcategory.class.php';
73$langs->loadLangs(array(
'orders',
'sendings',
'companies',
'compta',
'bills',
'stocks',
'products'));
76$action =
GETPOST(
'action',
'aZ09');
77$massaction =
GETPOST(
'massaction',
'alpha');
79$confirm =
GETPOST(
'confirm',
'alpha');
80$toselect =
GETPOST(
'toselect',
'array:int');
81$contextpage =
GETPOST(
'contextpage',
'aZ') ?
GETPOST(
'contextpage',
'aZ') :
'orderlist';
82$optioncss =
GETPOST(
'optioncss',
'alpha');
86 $userschilds = $user->getAllChildIds();
88 $userschilds = array();
92$search_datecloture_start =
GETPOSTINT(
'search_datecloture_start');
93if (empty($search_datecloture_start)) {
96$search_datecloture_end =
GETPOSTINT(
'search_datecloture_end');
97if (empty($search_datecloture_end)) {
107$search_all = trim(
GETPOST(
'search_all',
'alphanohtml'));
108$searchCategoryOrderOperator = 0;
109if (GETPOSTISSET(
'formfilteraction')) {
110 $searchCategoryOrderOperator =
GETPOSTINT(
'search_category_order_operator');
114$searchCategoryOrderList =
GETPOST(
'search_category_order_list',
'array');
115$search_product_category =
GETPOST(
'search_product_category',
'intcomma');
116$search_id =
GETPOST(
'search_id',
'int');
117$search_ref =
GETPOST(
'search_ref',
'alpha') !=
'' ?
GETPOST(
'search_ref',
'alpha') :
GETPOST(
'sref',
'alpha');
118$search_ref_ext =
GETPOST(
'search_ref_ext',
'alpha');
119$search_ref_customer =
GETPOST(
'search_ref_customer',
'alpha');
120$search_company =
GETPOST(
'search_company',
'alpha');
121$search_company_alias =
GETPOST(
'search_company_alias',
'alpha');
122$search_parent_name = trim(
GETPOST(
'search_parent_name',
'alphanohtml'));
123$search_town =
GETPOST(
'search_town',
'alpha');
124$search_zip =
GETPOST(
'search_zip',
'alpha');
125$search_state =
GETPOST(
'search_state',
'alpha');
126$search_country =
GETPOST(
'search_country',
'aZ09');
127$search_type_thirdparty =
GETPOST(
'search_type_thirdparty',
'intcomma');
128$search_user =
GETPOST(
'search_user',
'intcomma');
129$search_sale =
GETPOST(
'search_sale',
'intcomma');
130$search_total_ht =
GETPOST(
'search_total_ht',
'alpha');
131$search_total_vat =
GETPOST(
'search_total_vat',
'alpha');
132$search_total_ttc =
GETPOST(
'search_total_ttc',
'alpha');
133$search_warehouse =
GETPOST(
'search_warehouse',
'intcomma');
134$search_note_public =
GETPOST(
'search_note_public',
'alphanohtml');
135$search_note_private =
GETPOST(
'search_note_private',
'alphanohtml');
137$search_module_source =
GETPOST(
'search_module_source',
'alphanohtml');
138$search_pos_source =
GETPOST(
'search_pos_source',
'alphanohtml');
140$search_multicurrency_code =
GETPOST(
'search_multicurrency_code',
'alpha');
141$search_multicurrency_tx =
GETPOST(
'search_multicurrency_tx',
'alpha');
142$search_multicurrency_montant_ht =
GETPOST(
'search_multicurrency_montant_ht',
'alpha');
143$search_multicurrency_montant_vat =
GETPOST(
'search_multicurrency_montant_vat',
'alpha');
144$search_multicurrency_montant_ttc =
GETPOST(
'search_multicurrency_montant_ttc',
'alpha');
146$search_login =
GETPOST(
'search_login',
'alpha');
147$search_categ_cus =
GETPOST(
"search_categ_cus",
'intcomma');
148$search_billed =
GETPOST(
'search_billed',
'intcomma');
149$search_status =
GETPOST(
'search_status',
'intcomma');
150$search_project_ref =
GETPOST(
'search_project_ref',
'alpha');
151$search_project =
GETPOST(
'search_project',
'alpha');
152$search_shippable =
GETPOST(
'search_shippable',
'aZ09');
154$search_fk_cond_reglement =
GETPOST(
'search_fk_cond_reglement',
'intcomma');
155$search_fk_shipping_method =
GETPOST(
'search_fk_shipping_method',
'intcomma');
156$search_fk_mode_reglement =
GETPOST(
'search_fk_mode_reglement',
'intcomma');
157$search_fk_input_reason =
GETPOST(
'search_fk_input_reason',
'intcomma');
159$search_option =
GETPOST(
'search_option',
'alpha');
160if ($search_option ==
'late') {
161 $search_status =
'-2';
163$search_orderday =
'';
164$search_ordermonth =
'';
165$search_orderyear =
'';
166$search_deliveryday =
'';
167$search_deliverymonth =
'';
168$search_deliveryyear =
'';
170$search_import_key = trim(
GETPOST(
"search_import_key",
"alpha"));
172$diroutputmassaction = $conf->order->multidir_output[$conf->entity].
'/temp/massgeneration/'.$user->id;
176$sortfield =
GETPOST(
'sortfield',
'aZ09comma');
177$sortorder =
GETPOST(
'sortorder',
'aZ09comma');
179if (empty($page) || $page < 0 ||
GETPOST(
'button_search',
'alpha') ||
GETPOST(
'button_removefilter',
'alpha')) {
183$offset = $limit * $page;
184$pageprev = $page - 1;
185$pagenext = $page + 1;
187 $sortfield =
'c.ref';
193$show_shippable_command =
GETPOST(
'show_shippable_command',
'aZ09');
197$hookmanager->initHooks(array(
'orderlist'));
201$extrafields->fetch_name_optionals_label(
$object->table_element);
202$search_array_options = $extrafields->getOptionalsFromPost(
$object->table_element,
'',
'search_');
205$fieldstosearchall = array(
207 'c.ref_client' =>
'RefCustomerOrder',
208 'pd.description' =>
'ProductDescription',
209 's.nom' =>
"ThirdParty",
210 's.name_alias' =>
"AliasNameShort",
213 'c.note_public' =>
'NotePublic',
215if (empty($user->socid)) {
216 $fieldstosearchall[
"c.note_private"] =
"NotePrivate";
222$checkedtypetiers =
'0';
224 'c.rowid' => array(
'label' =>
"ID",
'checked' =>
'1',
'enabled' => (
string)
getDolGlobalInt(
'MAIN_SHOW_TECHNICAL_ID'),
'position' => 1),
225 'c.ref' => array(
'label' =>
"Ref",
'checked' =>
'1',
'position' => 5,
'searchall' => 1),
226 'c.ref_ext' => array(
'label' =>
"RefExt",
'checked' =>
'1',
'position' => 5,
'visible' => 0,
'searchall' => 1),
227 'c.ref_client' => array(
'label' =>
"RefCustomerOrder",
'checked' =>
'-1',
'position' => 10,
'searchall' => 1),
228 'p.ref' => array(
'label' =>
"ProjectRef",
'langfile' =>
'projects',
'checked' =>
'-1',
'enabled' => (!
isModEnabled(
'project') ?
'0' :
'1'),
'position' => 20),
229 'p.title' => array(
'label' =>
"ProjectLabel",
'langfile' =>
'projects',
'checked' =>
'0',
'enabled' => (!
isModEnabled(
'project') ?
'0' :
'1'),
'position' => 25),
230 's.nom' => array(
'label' =>
"ThirdParty",
'checked' =>
'1',
'position' => 30,
'searchall' => 1),
231 's.name_alias' => array(
'label' =>
"AliasNameShort",
'checked' =>
'-1',
'position' => 31,
'searchall' => 1),
232 's2.nom' => array(
'label' =>
'ParentCompany',
'position' => 32,
'checked' =>
'0'),
233 's.town' => array(
'label' =>
"Town",
'checked' =>
'-1',
'position' => 35,
'searchall' => 1),
234 's.zip' => array(
'label' =>
"Zip",
'checked' =>
'-1',
'position' => 40,
'searchall' => 1),
235 'state.nom' => array(
'label' =>
"StateShort",
'checked' =>
'0',
'position' => 45),
236 'country.code_iso' => array(
'label' =>
"Country",
'checked' =>
'0',
'position' => 50),
237 'typent.code' => array(
'label' =>
"ThirdPartyType",
'checked' => (string) $checkedtypetiers,
'position' => 55),
238 'c.date_commande' => array(
'label' =>
"OrderDateShort",
'checked' =>
'1',
'position' => 60,
'csslist' =>
'nowraponall'),
239 'c.delivery_date' => array(
'label' =>
"DateDeliveryPlanned",
'checked' =>
'1',
'enabled' => (string) (int) !
getDolGlobalString(
'ORDER_DISABLE_DELIVERY_DATE'),
'position' => 65,
'csslist' =>
'nowraponall'),
240 'c.fk_shipping_method' => array(
'label' =>
"SendingMethod",
'checked' =>
'-1',
'position' => 66 ,
'enabled' => (string) (int)
isModEnabled(
"shipping")),
241 'c.fk_cond_reglement' => array(
'label' =>
"PaymentConditionsShort",
'checked' =>
'-1',
'position' => 67),
242 'c.fk_mode_reglement' => array(
'label' =>
"PaymentMode",
'checked' =>
'-1',
'position' => 68),
243 'c.fk_input_reason' => array(
'label' =>
"Origin",
'checked' =>
'-1',
'position' => 69),
244 'c.module_source' => array(
'label' =>
"POSModule",
'langfile' =>
'cashdesk',
'checked' => ($contextpage ==
'poslist' ?
'1' :
'0'),
'enabled' => $showpos,
'position' => 90),
245 'c.pos_source' => array(
'label' =>
"POSTerminal",
'langfile' =>
'cashdesk',
'checked' => ($contextpage ==
'poslist' ?
'1' :
'0'),
'enabled' => $showpos,
'position' => 91),
246 'c.total_ht' => array(
'label' =>
"AmountHT",
'checked' =>
'1',
'position' => 75),
247 'c.total_vat' => array(
'label' =>
"AmountVAT",
'checked' =>
'0',
'position' => 80),
248 'c.total_ttc' => array(
'label' =>
"AmountTTC",
'checked' =>
'0',
'position' => 85),
249 'c.multicurrency_code' => array(
'label' =>
'Currency',
'checked' =>
'0',
'enabled' => (!
isModEnabled(
"multicurrency") ?
'0' :
'1'),
'position' => 92),
250 'c.multicurrency_tx' => array(
'label' =>
'CurrencyRate',
'checked' =>
'0',
'enabled' => (!
isModEnabled(
"multicurrency") ?
'0' :
'1'),
'position' => 95),
251 'c.multicurrency_total_ht' => array(
'label' =>
'MulticurrencyAmountHT',
'checked' =>
'0',
'enabled' => (!
isModEnabled(
"multicurrency") ?
'0' :
'1'),
'position' => 100),
252 'c.multicurrency_total_vat' => array(
'label' =>
'MulticurrencyAmountVAT',
'checked' =>
'0',
'enabled' => (!
isModEnabled(
"multicurrency") ?
'0' :
'1'),
'position' => 105),
253 'c.multicurrency_total_ttc' => array(
'label' =>
'MulticurrencyAmountTTC',
'checked' =>
'0',
'enabled' => (!
isModEnabled(
"multicurrency") ?
'0' :
'1'),
'position' => 110),
254 'u.login' => array(
'label' =>
"Author",
'checked' =>
'-1',
'position' => 115),
255 'sale_representative' => array(
'label' =>
"SaleRepresentativesOfThirdParty",
'checked' =>
'0',
'position' => 116),
256 '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)),
257 'total_margin' => array(
'label' =>
'Margin',
'checked' =>
'0',
'position' => 301,
'enabled' => (string) (int) (!
isModEnabled(
'margin') || !$user->hasRight(
"margins",
"liretous") ? 0 : 1)),
258 '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)),
259 '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)),
260 'c.datec' => array(
'label' =>
"DateCreation",
'checked' =>
'0',
'position' => 120),
261 'c.tms' => array(
'label' =>
"DateModificationShort",
'checked' =>
'0',
'position' => 125),
262 'c.date_cloture' => array(
'label' =>
"DateClosing",
'checked' =>
'0',
'position' => 130),
263 'c.note_public' => array(
'label' =>
'NotePublic',
'checked' =>
'0',
'enabled' => (string) (int) (!
getDolGlobalInt(
'MAIN_LIST_HIDE_PUBLIC_NOTES')),
'position' => 135,
'searchall' => 1),
264 'c.note_private' => array(
'label' =>
'NotePrivate',
'checked' =>
'0',
'enabled' => (string) (int) (!
getDolGlobalInt(
'MAIN_LIST_HIDE_PRIVATE_NOTES')),
'position' => 140),
265 'shippable' => array(
'label' =>
"Shippable",
'checked' =>
'1',
'enabled' => (string) (int) (
isModEnabled(
"shipping")),
'position' => 990),
266 'c.facture' => array(
'label' =>
"Billed",
'checked' =>
'1',
'enabled' => (string) (int) (!
getDolGlobalString(
'WORKFLOW_BILL_ON_SHIPMENT')),
'position' => 995),
267 'c.import_key' => array(
'type' =>
'varchar(14)',
'label' =>
'ImportId',
'enabled' =>
'1',
'visible' => -2,
'position' => 999),
268 'c.fk_statut' => array(
'label' =>
"Status",
'checked' =>
'1',
'position' => 1000)
271 unset($arrayfields[
'c.note_private']);
273$parameters = array(
'fieldstosearchall' => $fieldstosearchall);
274$reshook = $hookmanager->executeHooks(
'completeFieldsToSearchAll', $parameters, $object, $action);
276 $fieldstosearchall = empty($hookmanager->resArray[
'fieldstosearchall']) ? array() : $hookmanager->resArray[
'fieldstosearchall'];
277} elseif ($reshook == 0) {
278 $fieldstosearchall = array_merge($fieldstosearchall, empty($hookmanager->resArray[
'fieldstosearchall']) ? array() : $hookmanager->resArray[
'fieldstosearchall']);
282include DOL_DOCUMENT_ROOT.
'/core/tpl/extrafields_list_array_fields.tpl.php';
292 $socid = $user->socid;
295$permissiontoreadallthirdparty = $user->hasRight(
'societe',
'client',
'voir');
296$permissiontoread =
false;
297$permissiontovalidate =
false;
298$permissiontoclose =
false;
299$permissiontocancel =
false;
300$permissiontosendbymail =
false;
313if (
GETPOST(
'cancel',
'alpha')) {
317if (!
GETPOST(
'confirmmassaction',
'alpha') && $massaction !=
'presend' && $massaction !=
'confirm_presend' && $massaction !=
'confirm_createbills') {
321$parameters = array(
'socid' => $socid,
'arrayfields' => &$arrayfields);
322$reshook = $hookmanager->executeHooks(
'doActions', $parameters, $object, $action);
327if (empty($reshook)) {
329 include DOL_DOCUMENT_ROOT.
'/core/actions_changeselectedfields.inc.php';
332 if (
GETPOST(
'button_removefilter_x',
'alpha') ||
GETPOST(
'button_removefilter.x',
'alpha') ||
GETPOST(
'button_removefilter',
'alpha')) {
335 $search_product_category =
'';
336 $searchCategoryOrderList = array();
339 $search_ref_ext =
'';
340 $search_ref_customer =
'';
341 $search_company =
'';
342 $search_company_alias =
'';
343 $search_parent_name =
'';
344 $search_module_source =
'';
345 $search_pos_source =
'';
350 $search_country =
'';
351 $search_type_thirdparty =
'';
352 $search_total_ht =
'';
353 $search_total_vat =
'';
354 $search_total_ttc =
'';
355 $search_warehouse =
'';
356 $search_note_public =
'';
357 $search_note_private =
'';
358 $search_multicurrency_code =
'';
359 $search_multicurrency_tx =
'';
360 $search_multicurrency_montant_ht =
'';
361 $search_multicurrency_montant_vat =
'';
362 $search_multicurrency_montant_ttc =
'';
364 $search_dateorder_start =
'';
365 $search_dateorder_end =
'';
366 $search_datedelivery_start =
'';
367 $search_datedelivery_end =
'';
368 $search_project_ref =
'';
369 $search_project =
'';
372 $search_datecloture_start =
'';
373 $search_datecloture_end =
'';
374 $search_fk_cond_reglement =
'';
375 $search_fk_shipping_method =
'';
376 $search_fk_mode_reglement =
'';
377 $search_fk_input_reason =
'';
379 $search_import_key =
'';
380 $search_categ_cus = 0;
384 $search_array_options = array();
386 if (
GETPOST(
'button_removefilter_x',
'alpha') ||
GETPOST(
'button_removefilter.x',
'alpha') ||
GETPOST(
'button_removefilter',
'alpha')
387 ||
GETPOST(
'button_search_x',
'alpha') ||
GETPOST(
'button_search.x',
'alpha') ||
GETPOST(
'button_search',
'alpha')) {
392 $objectclass =
'Commande';
393 $objectlabel =
'Orders';
394 $permissiontoread = $user->hasRight(
"commande",
"lire");
395 $permissiontoadd = $user->hasRight(
"commande",
"creer");
396 $permissiontodelete = $user->hasRight(
"commande",
"supprimer");
398 $permissiontovalidate = $user->hasRight(
"commande",
"order_advance",
"validate");
399 $permissiontoclose = $user->hasRight(
"commande",
"order_advance",
"close");
400 $permissiontocancel = $user->hasRight(
"commande",
"order_advance",
"annuler");
401 $permissiontosendbymail = $user->hasRight(
"commande",
"order_advance",
"send");
403 $permissiontovalidate = $user->hasRight(
"commande",
"creer");
404 $permissiontoclose = $user->hasRight(
"commande",
"creer");
405 $permissiontocancel = $user->hasRight(
"commande",
"creer");
406 $permissiontosendbymail = $user->hasRight(
"commande",
"creer");
408 $uploaddir = $conf->order->multidir_output[$conf->entity];
409 $triggersendname =
'ORDER_SENTBYMAIL';
412 include DOL_DOCUMENT_ROOT.
'/core/actions_massactions.inc.php';
414 if ($massaction ==
'confirm_createbills') {
415 $orders =
GETPOST(
'toselect',
'array:int');
416 $createbills_onebythird =
GETPOSTINT(
'createbills_onebythird');
417 $validate_invoices =
GETPOSTINT(
'validate_invoices');
422 $TFactThird = array();
423 $TFactThirdNbLines = array();
425 $nb_bills_created = 0;
431 $nbOrders = is_array($orders) ? count($orders) : 1;
434 foreach ($orders as $id_order) {
436 if ($cmd->fetch($id_order) <= 0) {
444 setEventMessages($langs->trans(
'WarningOrderNotEligibleForInvoicing', $cmd->ref),
null,
'warnings');
448 $cmd->fetch_thirdparty();
451 if (!empty($createbills_onebythird) && !empty($TFactThird[$cmd->socid])) {
454 $objecttmp = $TFactThird[$cmd->socid];
457 $objecttmp->socid = $cmd->socid;
458 $objecttmp->thirdparty = $cmd->thirdparty;
460 $objecttmp->type = $objecttmp::TYPE_STANDARD;
461 $objecttmp->cond_reglement_id = !empty($cmd->cond_reglement_id) ? $cmd->cond_reglement_id : $cmd->thirdparty->cond_reglement_id;
462 $objecttmp->mode_reglement_id = !empty($cmd->mode_reglement_id) ? $cmd->mode_reglement_id : $cmd->thirdparty->mode_reglement_id;
463 $objecttmp->demand_reason_id = !empty($cmd->demand_reason_id) ? $cmd->demand_reason_id : $cmd->thirdparty->demand_reason_id;
465 $objecttmp->fk_project = $cmd->fk_project;
466 $objecttmp->multicurrency_code = $cmd->multicurrency_code;
467 if (empty($createbills_onebythird)) {
468 $objecttmp->ref_client = $cmd->ref_client;
471 if (empty($objecttmp->note_public) &&
getDolGlobalInt(
"MAXREFONDOC", 10)>0) {
472 $objecttmp->note_public = $langs->transnoentities(
"Orders");
476 if (empty($datefacture)) {
480 $objecttmp->date = $datefacture;
481 $objecttmp->origin =
'commande';
482 $objecttmp->origin_id = (int) $id_order;
484 $objecttmp->array_options = $cmd->array_options;
486 $res = $objecttmp->create($user);
489 $objecttmp->user_creation_id = $user->id;
492 $lastref = $objecttmp->ref;
493 $lastid = $objecttmp->id;
495 $TFactThird[$cmd->socid] = $objecttmp;
496 $TFactThirdNbLines[$cmd->socid] = 0;
498 $langs->load(
"errors");
499 $errors[] = $cmd->ref.
' : '.$langs->trans($objecttmp->errors[0]);
504 if ($objecttmp->id > 0) {
505 $res = $objecttmp->add_object_linked($objecttmp->origin, $id_order);
508 $errors[] = $cmd->ref.
' : '.$langs->trans($objecttmp->errors[0]);
514 $cmd->fetchObjectLinked();
516 if (!$error && $cmd->id && !empty($cmd->linkedObjectsIds[
'shipping']) && is_array($cmd->linkedObjectsIds[
'shipping'])) {
517 $cmd->linked_objects = $cmd->linkedObjectsIds;
518 foreach ($cmd->linked_objects as $origin_type => $tmp_origin_id) {
520 if ($origin_type ==
'shipping') {
521 if (is_array($tmp_origin_id)) {
522 foreach ($tmp_origin_id as $origin_id) {
523 $res = $objecttmp->add_object_linked($origin_type, $origin_id);
525 $errors[] = $cmd->ref.
' : '.$langs->trans($objecttmp->errors[0]);
530 $origin_id = $tmp_origin_id;
531 $res = $objecttmp->add_object_linked($origin_type, $origin_id);
533 $errors[] = $cmd->ref.
' : '.$langs->trans($objecttmp->errors[0]);
543 $lines = $cmd->lines;
544 if (empty($lines) && method_exists($cmd,
'fetch_lines')) {
546 $lines = $cmd->lines;
550 $num = count($lines);
551 $array_options = array();
553 for ($i = 0; $i < $num; $i++) {
554 $desc = ($lines[$i]->desc ? $lines[$i]->desc :
'');
556 if (!empty($createbills_onebythird)) {
560 if ($lines[$i]->subprice < 0 && !
getDolGlobalString(
'INVOICE_KEEP_DISCOUNT_LINES_AS_IN_ORIGIN')) {
563 $discount->fk_soc = $objecttmp->socid;
564 $discount->socid = $objecttmp->socid;
565 $discount->amount_ht = abs($lines[$i]->total_ht);
566 $discount->amount_tva = abs($lines[$i]->total_tva);
567 $discount->amount_ttc = abs($lines[$i]->total_ttc);
568 $discount->tva_tx = $lines[$i]->tva_tx;
569 $discount->fk_user = $user->id;
570 $discount->description = $desc;
571 $discountid = $discount->create($user);
572 if ($discountid > 0) {
573 $result = $objecttmp->insert_discount($discountid);
582 $product_type = ($lines[$i]->product_type ? $lines[$i]->product_type : 0);
585 if ($lines[$i]->date_debut_prevue) {
586 $date_start = $lines[$i]->date_debut_prevue;
588 if ($lines[$i]->date_debut_reel) {
589 $date_start = $lines[$i]->date_debut_reel;
591 if ($lines[$i]->date_start) {
592 $date_start = $lines[$i]->date_start;
596 if ($lines[$i]->date_fin_prevue) {
597 $date_end = $lines[$i]->date_fin_prevue;
599 if ($lines[$i]->date_fin_reel) {
600 $date_end = $lines[$i]->date_fin_reel;
602 if ($lines[$i]->date_end) {
603 $date_end = $lines[$i]->date_end;
606 if (($lines[$i]->product_type != 9 && empty($lines[$i]->fk_parent_line)) || $lines[$i]->product_type == 9) {
611 if (method_exists($lines[$i],
'fetch_optionals')) {
612 $lines[$i]->fetch_optionals();
613 $array_options = $lines[$i]->array_options;
616 $objecttmp->context[
'createfromclone'] =
'createfromclone';
618 $rang = ($nbOrders > 1) ? -1 : $lines[$i]->rang;
620 if (!empty($createbills_onebythird)) {
621 $TFactThirdNbLines[$cmd->socid]++;
622 $rang = $TFactThirdNbLines[$cmd->socid];
625 $result = $objecttmp->addline(
627 $lines[$i]->subprice,
630 $lines[$i]->localtax1_tx,
631 $lines[$i]->localtax2_tx,
632 $lines[$i]->fk_product,
633 $lines[$i]->remise_percent,
637 $lines[$i]->info_bits,
638 $lines[$i]->fk_remise_except,
643 $lines[$i]->special_code,
647 $lines[$i]->fk_fournprice,
656 if (!empty($lines[$i]->extraparams)) {
658 $factureLine->id = $result;
659 $factureLine->extraparams = $lines[$i]->extraparams;
660 $factureLine->setExtraParameters();
667 $errors[] = $objecttmp->error;
671 if ($result > 0 && $lines[$i]->product_type == 9) {
672 $fk_parent_line = $result;
680 $objecttmp->note_public =
dol_concatdesc($objecttmp->note_public, $langs->transnoentities($cmd->ref).(empty($cmd->ref_client) ?
'' :
' ('.$cmd->ref_client.
')'));
681 $objecttmp->update($user);
686 if (!empty($createbills_onebythird) && empty($TFactThird[$cmd->socid])) {
687 $TFactThird[$cmd->socid] = $objecttmp;
689 $TFact[$objecttmp->id] = $objecttmp;
694 $TAllFact = empty($createbills_onebythird) ? $TFact : $TFactThird;
697 if (!$error && $validate_invoices) {
698 $massaction = $action =
'builddoc';
700 foreach ($TAllFact as &$objecttmp) {
701 $result = $objecttmp->validate($user);
708 $id = $objecttmp->id;
709 $lastref = $objecttmp->ref;
713 $upload_dir = $conf->facture->dir_output;
714 $permissiontoadd = $user->hasRight(
'facture',
'creer');
719 include DOL_DOCUMENT_ROOT.
'/core/actions_builddoc.inc.php';
723 $massaction = $action =
'confirm_createbills';
729 if ($nb_bills_created == 1) {
730 if (
getDolGlobalInt(
'MAIN_MASSACTION_CREATEBILLS_REDIRECT_IF_ONE') == 1) {
732 header(
'Location: '.DOL_URL_ROOT.
'/compta/facture/card.php?id='.urlencode((
string) $lastid));
735 $texttoshow = $langs->trans(
'BillXCreated',
'{s1}');
736 $texttoshow = str_replace(
'{s1}',
'<a href="'.DOL_URL_ROOT.
'/compta/facture/card.php?id='.urlencode((
string) ($lastid)).
'">'.$lastref.
'</a>', $texttoshow);
739 if (
getDolGlobalInt(
'MAIN_MASSACTION_CREATEBILLS_REDIRECT_IF_MANY') == 1) {
741 header(
"Location: ".DOL_URL_ROOT.
'/compta/facture/list.php?mainmenu=billing&leftmenu=customers_bills');
744 setEventMessages($langs->trans(
'BillCreated', $nb_bills_created),
null,
'mesgs');
750 $param .=
'&mode='.urlencode($mode);
752 if (!empty($contextpage) && $contextpage != $_SERVER[
"PHP_SELF"]) {
753 $param .=
'&contextpage='.urlencode($contextpage);
755 if ($limit > 0 && $limit != $conf->liste_limit) {
756 $param .=
'&limit='.((int) $limit);
758 if ($optioncss !=
'') {
759 $param .=
'&optioncss='.urlencode($optioncss);
762 $param .=
'&search_all='.urlencode($search_all);
765 $param .=
'&show_files='.urlencode((
string) ($show_files));
768 $param .=
'&socid='.urlencode((
string) ($socid));
770 if ($search_status !=
'') {
771 $param .=
'&search_status='.urlencode($search_status);
773 if ($search_option) {
774 $param .=
"&search_option=".urlencode($search_option);
776 if ($search_orderday) {
777 $param .=
'&search_orderday='.urlencode($search_orderday);
779 if ($search_ordermonth) {
780 $param .=
'&search_ordermonth='.urlencode($search_ordermonth);
782 if ($search_orderyear) {
783 $param .=
'&search_orderyear='.urlencode($search_orderyear);
785 if ($search_deliveryday) {
786 $param .=
'&search_deliveryday='.urlencode($search_deliveryday);
788 if ($search_deliverymonth) {
789 $param .=
'&search_deliverymonth='.urlencode($search_deliverymonth);
791 if ($search_deliveryyear) {
792 $param .=
'&search_deliveryyear='.urlencode($search_deliveryyear);
795 $param .=
'&search_id='.urlencode((
string) $search_id);
798 $param .=
'&search_ref='.urlencode($search_ref);
800 if ($search_ref_ext) {
801 $param .=
'&search_ref_ext='.urlencode($search_ref_ext);
803 if ($search_company) {
804 $param .=
'&search_company='.urlencode($search_company);
806 if ($search_ref_customer) {
807 $param .=
'&search_ref_customer='.urlencode($search_ref_customer);
809 if ($search_user > 0) {
810 $param .=
'&search_user='.urlencode((
string) ($search_user));
812 if ($search_sale > 0) {
813 $param .=
'&search_sale='.urlencode((
string) ($search_sale));
815 if ($search_total_ht !=
'') {
816 $param .=
'&search_total_ht='.urlencode($search_total_ht);
818 if ($search_total_vat !=
'') {
819 $param .=
'&search_total_vat='.urlencode($search_total_vat);
821 if ($search_total_ttc !=
'') {
822 $param .=
'&search_total_ttc='.urlencode($search_total_ttc);
824 if ($search_project_ref >= 0) {
825 $param .=
"&search_project_ref=".urlencode($search_project_ref);
827 if ($search_project !=
'') {
828 $param .=
"&search_project=".urlencode($search_project);
830 if ($search_billed !=
'') {
831 $param .=
'&search_billed='.urlencode($search_billed);
834 header(
"Location: ".$_SERVER[
'PHP_SELF'].
'?'.$param);
840 $_GET[
"origin"] = $_POST[
"origin"];
841 $_GET[
"originid"] = $_POST[
"originid"];
842 if (!empty($errors)) {
852if ($action ==
'validate' && $permissiontoadd && $objectclass !==
null) {
853 if (
GETPOST(
'confirm') ==
'yes') {
855 $objecttmp =
new $objectclass($db);
858 foreach ($toselect as $checked) {
859 if ($objecttmp->fetch($checked)) {
860 if ($objecttmp->status == $objecttmp::STATUS_DRAFT) {
861 if (!empty($objecttmp->fk_warehouse)) {
862 $idwarehouse = $objecttmp->fk_warehouse;
866 if ($objecttmp->valid($user, $idwarehouse) > 0) {
867 setEventMessages($langs->trans(
'hasBeenValidated', $objecttmp->ref),
null,
'mesgs');
873 $langs->load(
"errors");
874 setEventMessages($langs->trans(
'ErrorIsNotADraft', $objecttmp->ref),
null,
'errors');
889if ($action ==
'shipped' && $permissiontoadd && $objectclass !==
null) {
890 if (
GETPOST(
'confirm') ==
'yes') {
892 $objecttmp =
new $objectclass($db);
895 foreach ($toselect as $checked) {
896 if ($objecttmp->fetch($checked)) {
897 if ($objecttmp->status == $objecttmp::STATUS_VALIDATED || $objecttmp->status == $objecttmp::STATUS_SHIPMENTONPROCESS || $objecttmp->status == $objecttmp::STATUS_CLOSED) {
898 $result = $objecttmp->cloture($user);
900 setEventMessages($langs->trans(
'StatusOrderDelivered', $objecttmp->ref),
null,
'mesgs');
901 } elseif ($result < 0) {
902 setEventMessages($langs->trans(
'ErrorOrderStatusCantBeSetToDelivered'),
null,
'errors');
906 $langs->load(
"errors");
907 setEventMessages($langs->trans(
'ErrorObjectHasWrongStatus', $objecttmp->ref),
null,
'errors');
924if (!$error && $massaction ===
'setbilled' && $permissiontoclose && $objectclass !==
null) {
927 $objecttmp =
new $objectclass($db);
929 foreach ($toselect as $toselectid) {
930 $result = $objecttmp->fetch($toselectid);
932 $result = $objecttmp->classifyBilled($user, 0);
960$form =
new Form($db);
967$companystatic =
new Societe($db);
968$company_url_list = array();
970$projectstatic =
new Project($db);
974$varpage = empty($contextpage) ? $_SERVER[
"PHP_SELF"] : $contextpage;
975$selectedfields = $form->multiSelectArrayWithCheckbox(
'selectedfields', $arrayfields, $varpage);
977$title = $langs->trans(
"Orders");
978$help_url =
"EN:Module_Customers_Orders|FR:Module_Commandes_Clients|ES:Módulo_Pedidos_de_clientes";
983$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,';
984$sql .=
" s.parent as fk_parent,";
985$sql .=
" s2.nom as name2,";
986$sql .=
" typent.code as typent_code,";
987$sql .=
" state.code_departement as state_code, state.nom as state_name,";
988$sql .=
" country.code as country_code,";
989$sql .=
' c.rowid, c.ref, c.ref_ext, c.total_ht, c.total_tva, c.total_ttc, c.ref_client, c.fk_user_author,';
990$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,';
991$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,';
992$sql .=
' c.date_creation as date_creation, c.tms as date_modification, c.date_cloture as date_cloture,';
993$sql .=
' c.fk_cond_reglement,c.deposit_percent,c.fk_mode_reglement,c.fk_shipping_method,';
994$sql .=
' c.fk_input_reason, c.import_key,';
995$sql .=
" c.module_source, c.pos_source,";
996$sql .=
' p.rowid as project_id, p.ref as project_ref, p.title as project_label,';
997$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';
1000if (!empty($extrafields->attributes[
$object->table_element][
'label'])) {
1001 foreach ($extrafields->attributes[
$object->table_element][
'label'] as $key => $val) {
1002 $sql .= ($extrafields->attributes[
$object->table_element][
'type'][$key] !=
'separate' ?
", ef.".$key.
" as options_".$key :
'');
1007$parameters = array();
1008$reshook = $hookmanager->executeHooks(
'printFieldListSelect', $parameters, $object, $action);
1009$sql .= $hookmanager->resPrint;
1010$sql = preg_replace(
'/,\s*$/',
'', $sql);
1014$sql .=
' FROM '.MAIN_DB_PREFIX.
'societe as s';
1015$sql .=
" LEFT JOIN ".MAIN_DB_PREFIX.
"societe as s2 ON s2.rowid = s.parent";
1016$sql .=
" LEFT JOIN ".MAIN_DB_PREFIX.
"c_country as country on (country.rowid = s.fk_pays)";
1017$sql .=
" LEFT JOIN ".MAIN_DB_PREFIX.
"c_typent as typent on (typent.id = s.fk_typent)";
1018$sql .=
" LEFT JOIN ".MAIN_DB_PREFIX.
"c_departements as state on (state.rowid = s.fk_departement)";
1019$sql .=
', '.MAIN_DB_PREFIX.
'commande as c';
1020if (!empty($extrafields->attributes[
$object->table_element][
'label']) && is_array($extrafields->attributes[
$object->table_element][
'label']) && count($extrafields->attributes[
$object->table_element][
'label'])) {
1021 $sql .=
" LEFT JOIN ".MAIN_DB_PREFIX.
"commande_extrafields as ef on (c.rowid = ef.fk_object)";
1023$sql .=
" LEFT JOIN ".MAIN_DB_PREFIX.
"projet as p ON p.rowid = c.fk_projet";
1024$sql .=
' LEFT JOIN '.MAIN_DB_PREFIX.
'user as u ON c.fk_user_author = u.rowid';
1026$parameters = array();
1027$reshook = $hookmanager->executeHooks(
'printFieldListFrom', $parameters, $object, $action);
1028$sql .= $hookmanager->resPrint;
1030$sql .=
' WHERE c.fk_soc = s.rowid';
1031$sql .=
' AND c.entity IN ('.getEntity(
'commande').
')';
1033 $sql .=
' AND s.rowid = '.((int) $socid);
1036if (empty($user->socid) && !$permissiontoreadallthirdparty) {
1037 $sql .=
" AND (EXISTS (SELECT sc.fk_soc FROM ".MAIN_DB_PREFIX.
"societe_commerciaux as sc WHERE sc.fk_soc = c.fk_soc AND sc.fk_user = ".((int) $user->id).
")";
1039 $sql .=
" OR EXISTS (SELECT sc.fk_soc FROM ".MAIN_DB_PREFIX.
"societe_commerciaux as sc WHERE sc.fk_soc = c.fk_soc AND sc.fk_user IN (".$db->sanitize(implode(
',', $userschilds)).
"))";
1044if ($search_id > 0) {
1050if ($search_ref_ext) {
1053if ($search_ref_customer) {
1056if ($search_billed !=
'' && $search_billed >= 0) {
1057 $sql .=
' AND c.facture = '.((int) $search_billed);
1059if ($search_status !=
'') {
1060 if ($search_status <= 3 && $search_status >= -1) {
1061 if ($search_status == 1 && !
isModEnabled(
'shipping')) {
1062 $sql .=
' AND c.fk_statut IN (1,2)';
1064 $sql .=
' AND c.fk_statut = '.((int) $search_status);
1067 if ($search_status == -2) {
1069 $sql .=
" AND (c.fk_statut IN (1,2))";
1071 if ($search_status == -3) {
1074 $sql .=
' AND (c.fk_statut IN (1,2,3))';
1077if ($search_option ==
'late') {
1080 $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).
"'))";
1082 $sql .=
" AND c.date_commande < '".$db->idate(
dol_now() - $conf->order->client->warning_delay).
"'";
1085if ($search_datecloture_start) {
1086 $sql .=
" AND c.date_cloture >= '".$db->idate($search_datecloture_start).
"'";
1088if ($search_datecloture_end) {
1089 $sql .=
" AND c.date_cloture <= '".$db->idate($search_datecloture_end).
"'";
1091if ($search_dateorder_start) {
1092 $sql .=
" AND c.date_commande >= '".$db->idate($search_dateorder_start).
"'";
1094if ($search_dateorder_end) {
1095 $sql .=
" AND c.date_commande <= '".$db->idate($search_dateorder_end).
"'";
1097if ($search_datedelivery_start) {
1098 $sql .=
" AND c.date_livraison >= '".$db->idate($search_datedelivery_start).
"'";
1100if ($search_datedelivery_end) {
1101 $sql .=
" AND c.date_livraison <= '".$db->idate($search_datedelivery_end).
"'";
1112if ($search_country) {
1113 $sql .=
" AND s.fk_pays IN (".$db->sanitize($search_country).
')';
1115if ($search_type_thirdparty && $search_type_thirdparty !=
'-1') {
1116 $sql .=
" AND s.fk_typent IN (".$db->sanitize($search_type_thirdparty).
')';
1118if (empty($arrayfields[
's.name_alias'][
'checked']) && $search_company) {
1119 $sql .=
natural_search(array(
"s.nom",
"s.name_alias"), $search_company);
1121 if ($search_company) {
1124 if ($search_company_alias) {
1128if ($search_parent_name) {
1131if ($search_total_ht !=
'') {
1134if ($search_total_vat !=
'') {
1137if ($search_total_ttc !=
'') {
1140if ($search_warehouse !=
'' && $search_warehouse > 0) {
1143if ($search_note_public !=
'') {
1146if ($search_note_private !=
'') {
1149if ($search_multicurrency_code !=
'') {
1150 $sql .=
" AND c.multicurrency_code = '".$db->escape($search_multicurrency_code).
"'";
1152if ($search_multicurrency_tx !=
'') {
1153 $sql .=
natural_search(
'c.multicurrency_tx', $search_multicurrency_tx, 1);
1155if ($search_multicurrency_montant_ht !=
'') {
1156 $sql .=
natural_search(
'c.multicurrency_total_ht', $search_multicurrency_montant_ht, 1);
1158if ($search_multicurrency_montant_vat !=
'') {
1159 $sql .=
natural_search(
'c.multicurrency_total_tva', $search_multicurrency_montant_vat, 1);
1161if ($search_multicurrency_montant_ttc !=
'') {
1162 $sql .=
natural_search(
'c.multicurrency_total_ttc', $search_multicurrency_montant_ttc, 1);
1165 $sql .=
natural_search(array(
"u.login",
"u.firstname",
"u.lastname"), $search_login);
1167if ($search_project_ref !=
'') {
1170if ($search_project !=
'') {
1173if ($search_fk_cond_reglement > 0) {
1174 $sql .=
" AND c.fk_cond_reglement = ".((int) $search_fk_cond_reglement);
1176if ($search_fk_shipping_method > 0) {
1177 $sql .=
" AND c.fk_shipping_method = ".((int) $search_fk_shipping_method);
1179if ($search_fk_mode_reglement > 0) {
1180 $sql .=
" AND c.fk_mode_reglement = ".((int) $search_fk_mode_reglement);
1182if ($search_fk_input_reason > 0) {
1183 $sql .=
" AND c.fk_input_reason = ".((int) $search_fk_input_reason);
1185if ($search_module_source) {
1186 $sql .=
natural_search(
"c.module_source", $search_module_source);
1188if ($search_pos_source) {
1191if ($search_import_key) {
1195if ($search_user > 0) {
1196 $sql .=
" AND EXISTS (";
1197 $sql .=
" SELECT ec.fk_c_type_contact, ec.element_id, ec.fk_socpeople";
1198 $sql .=
" FROM ".MAIN_DB_PREFIX.
"element_contact as ec";
1199 $sql .=
" INNER JOIN ".MAIN_DB_PREFIX.
"c_type_contact as tc";
1200 $sql .=
" ON ec.fk_c_type_contact = tc.rowid AND tc.element = 'commande' AND tc.source = 'internal'";
1201 $sql .=
" WHERE ec.element_id = c.rowid AND ec.fk_socpeople = ".((int) $search_user).
")";
1204if ($search_sale && $search_sale !=
'-1') {
1205 if ($search_sale == -2) {
1206 $sql .=
" AND NOT EXISTS (SELECT sc.fk_soc FROM ".MAIN_DB_PREFIX.
"societe_commerciaux as sc WHERE sc.fk_soc = c.fk_soc)";
1207 } elseif ($search_sale > 0) {
1208 $sql .=
" AND EXISTS (SELECT sc.fk_soc FROM ".MAIN_DB_PREFIX.
"societe_commerciaux as sc WHERE sc.fk_soc = c.fk_soc AND sc.fk_user = ".((int) $search_sale).
")";
1213if (!empty($searchCategoryOrderList)) {
1214 $searchCategoryOrderSqlList = array();
1215 $listofcategoryid =
'';
1216 foreach ($searchCategoryOrderList as $searchCategoryOrder) {
1217 if (intval($searchCategoryOrder) == -2) {
1218 $searchCategoryOrderSqlList[] =
"NOT EXISTS (SELECT ck.fk_order FROM ".MAIN_DB_PREFIX.
"categorie_order as ck WHERE c.rowid = ck.fk_order)";
1219 } elseif (intval($searchCategoryOrder) > 0) {
1220 if ($searchCategoryOrderOperator == 0) {
1221 $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).
")";
1223 $listofcategoryid .= ($listofcategoryid ?
', ' :
'') .((
int) $searchCategoryOrder);
1227 if ($listofcategoryid) {
1228 $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).
"))";
1230 if ($searchCategoryOrderOperator == 1) {
1231 if (!empty($searchCategoryOrderSqlList)) {
1232 $sql .=
" AND (".implode(
' OR ', $searchCategoryOrderSqlList).
")";
1235 if (!empty($searchCategoryOrderSqlList)) {
1236 $sql .=
" AND (".implode(
' AND ', $searchCategoryOrderSqlList).
")";
1242$searchCategoryCustomerOperator =
GETPOSTINT(
'search_category_customer_operator');
1243$searchCategoryCustomerList = array($search_categ_cus);
1244if (!empty($searchCategoryCustomerList)) {
1245 $searchCategoryCustomerSqlList = array();
1246 $listofcategoryid =
'';
1247 foreach ($searchCategoryCustomerList as $searchCategoryCustomer) {
1248 if (intval($searchCategoryCustomer) == -2) {
1249 $searchCategoryCustomerSqlList[] =
"NOT EXISTS (SELECT cs.fk_soc FROM ".MAIN_DB_PREFIX.
"categorie_societe as cs WHERE s.rowid = cs.fk_soc)";
1250 } elseif (intval($searchCategoryCustomer) > 0) {
1251 if ($searchCategoryCustomerOperator == 0) {
1252 $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).
")";
1254 $listofcategoryid .= ($listofcategoryid ?
', ' :
'') .((
int) $searchCategoryCustomer);
1258 if ($listofcategoryid) {
1259 $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).
"))";
1261 if ($searchCategoryCustomerOperator == 1) {
1262 if (!empty($searchCategoryCustomerSqlList)) {
1263 $sql .=
" AND (".implode(
' OR ', $searchCategoryCustomerSqlList).
")";
1266 if (!empty($searchCategoryCustomerSqlList)) {
1267 $sql .=
" AND (".implode(
' AND ', $searchCategoryCustomerSqlList).
")";
1272$searchCategoryProductOperator =
GETPOSTINT(
'search_category_product_operator');
1273$searchCategoryProductList = array($search_product_category);
1274if (!empty($searchCategoryProductList)) {
1275 $searchCategoryProductSqlList = array();
1276 $listofcategoryid =
'';
1277 foreach ($searchCategoryProductList as $searchCategoryProduct) {
1278 if (intval($searchCategoryProduct) == -2) {
1279 $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)";
1280 } elseif (intval($searchCategoryProduct) > 0) {
1281 if ($searchCategoryProductOperator == 0) {
1282 $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).
")";
1284 $listofcategoryid .= ($listofcategoryid ?
', ' :
'') .((
int) $searchCategoryProduct);
1288 if ($listofcategoryid) {
1289 $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).
"))";
1291 if ($searchCategoryProductOperator == 1) {
1292 if (!empty($searchCategoryProductSqlList)) {
1293 $sql .=
" AND (".implode(
' OR ', $searchCategoryProductSqlList).
")";
1296 if (!empty($searchCategoryProductSqlList)) {
1297 $sql .=
" AND (".implode(
' AND ', $searchCategoryProductSqlList).
")";
1302include DOL_DOCUMENT_ROOT.
'/core/tpl/extrafields_list_search_sql.tpl.php';
1304$parameters = array();
1305$reshook = $hookmanager->executeHooks(
'printFieldListWhere', $parameters, $object, $action);
1306$sql .= $hookmanager->resPrint;
1311 $fieldstosearchallwithoutpd = array();
1312 $fieldstosearchallwithpd = array();
1313 foreach ($fieldstosearchall as $key => $val) {
1314 if (!preg_match(
'/^pd\./', $key)) {
1315 $fieldstosearchallwithoutpd[$key] = $val;
1317 $fieldstosearchallwithpd[$key] = $val;
1321 if (count($fieldstosearchallwithpd) > 0) {
1322 $sqltoadd .=
" OR EXISTS (SELECT pd.rowid FROM ".MAIN_DB_PREFIX.
"commandedet as pd WHERE pd.fk_commande = c.rowid";
1323 $sqltoadd .=
natural_search(array_keys($fieldstosearchallwithpd),
'__KEYTOSEARCH__');
1327 $sql .=
natural_search(array_keys($fieldstosearchallwithoutpd), $search_all, 0, 0, $sqltoadd);
1331$parameters = array();
1332$reshook = $hookmanager->executeHooks(
'printFieldListHaving', $parameters, $object, $action);
1333if (empty($reshook)) {
1334 $sql .= empty($hookmanager->resPrint) ?
"" :
" HAVING 1=1 ".$hookmanager->resPrint;
1336 $sql = $hookmanager->resPrint;
1341$nbtotalofrecords =
'';
1344 $sqlforcount = preg_replace(
'/^'.preg_quote($sqlfields,
'/').
'/',
'SELECT COUNT(*) as nbtotalofrecords', $sql);
1345 $sqlforcount = preg_replace(
'/GROUP BY .*$/',
'', $sqlforcount);
1346 $resql = $db->query($sqlforcount);
1348 $objforcount = $db->fetch_object($resql);
1349 $nbtotalofrecords = $objforcount->nbtotalofrecords;
1354 if (($page * $limit) > (
int) $nbtotalofrecords) {
1362$sql .= $db->order($sortfield, $sortorder);
1364 $sql .= $db->plimit($limit + 1, $offset);
1368$resql = $db->query($sql);
1376 $soc->fetch($socid);
1377 $title = $langs->trans(
'CustomersOrders').
' - '.$soc->name;
1378 if (empty($search_company)) {
1379 $search_company = $soc->name;
1382 $title = $langs->trans(
'CustomersOrders');
1384if (strval($search_status) ==
'0') {
1385 $title .=
' - '.$langs->trans(
'StatusOrderDraftShort');
1387if ($search_status == 1) {
1388 $title .=
' - '.$langs->trans(
'StatusOrderValidatedShort');
1390if ($search_status == 2) {
1391 $title .=
' - '.$langs->trans(
'StatusOrderSentShort');
1393if ($search_status == 3) {
1394 $title .=
' - '.$langs->trans(
'StatusOrderToBillShort');
1396if ($search_status == -1) {
1397 $title .=
' - '.$langs->trans(
'StatusOrderCanceledShort');
1399if ($search_status == -2) {
1400 $title .=
' - '.$langs->trans(
'StatusOrderToProcessShort');
1402if ($search_status == -3) {
1403 $title .=
' - '.$langs->trans(
'StatusOrderValidated').
', '.(!
isModEnabled(
'shipping') ?
'' : $langs->trans(
"StatusOrderSent").
', ').$langs->trans(
'StatusOrderToBill');
1405if ($search_status == -4) {
1406 $title .=
' - '.$langs->trans(
"StatusOrderValidatedShort").
'+'.$langs->trans(
"StatusOrderSentShort");
1409$num = $db->num_rows($resql);
1411$arrayofselected = is_array($toselect) ? $toselect : array();
1413if ($num == 1 &&
getDolGlobalString(
'MAIN_SEARCH_DIRECT_OPEN_IF_ONLY_ONE') && $search_all) {
1414 $obj = $db->fetch_object($resql);
1416 header(
"Location: ".DOL_URL_ROOT.
'/commande/card.php?id='.
$id);
1423llxHeader(
'', $title, $help_url,
'', 0, 0,
'',
'',
'',
'bodyforlist mod-order page-list');
1425$arrayofselected = is_array($toselect) ? $toselect : array();
1429 $param .=
'&mode='.urlencode($mode);
1431if (!empty($contextpage) && $contextpage != $_SERVER[
"PHP_SELF"]) {
1432 $param .=
'&contextpage='.urlencode($contextpage);
1434if ($limit > 0 && $limit != $conf->liste_limit) {
1435 $param .=
'&limit='.((int) $limit);
1437if ($optioncss !=
'') {
1438 $param .=
'&optioncss='.urlencode($optioncss);
1441 $param .=
'&show_files='.urlencode((
string) ($show_files));
1444 $param .=
'&search_all='.urlencode($search_all);
1447 $param .=
'&socid='.((int) $socid);
1449if ($search_status !=
'') {
1450 $param .=
'&search_status='.urlencode($search_status);
1452if ($search_option) {
1453 $param .=
"&search_option=".urlencode($search_option);
1455if ($search_datecloture_start) {
1456 $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');
1458if ($search_datecloture_end) {
1459 $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');
1461if ($search_dateorder_start) {
1462 $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');
1464if ($search_dateorder_end) {
1465 $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');
1467if ($search_datedelivery_start) {
1468 $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');
1470if ($search_datedelivery_end) {
1471 $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');
1474 $param .=
'&search_id='.urlencode((
string) $search_id);
1477 $param .=
'&search_ref='.urlencode($search_ref);
1479if ($search_ref_ext) {
1480 $param .=
'&search_ref_ext='.urlencode($search_ref_ext);
1482if ($search_company) {
1483 $param .=
'&search_company='.urlencode($search_company);
1485if ($search_company_alias) {
1486 $param .=
'&search_company_alias='.urlencode($search_company_alias);
1488if ($search_parent_name !=
'') {
1489 $param .=
'&search_parent_name='.urlencode($search_parent_name);
1491if ($search_ref_customer) {
1492 $param .=
'&search_ref_customer='.urlencode($search_ref_customer);
1494if ($search_user > 0) {
1495 $param .=
'&search_user='.urlencode((
string) ($search_user));
1497if ($search_sale > 0) {
1498 $param .=
'&search_sale='.urlencode((
string) ($search_sale));
1500if ($search_total_ht !=
'') {
1501 $param .=
'&search_total_ht='.urlencode($search_total_ht);
1503if ($search_total_vat !=
'') {
1504 $param .=
'&search_total_vat='.urlencode($search_total_vat);
1506if ($search_total_ttc !=
'') {
1507 $param .=
'&search_total_ttc='.urlencode($search_total_ttc);
1509if ($search_warehouse !=
'') {
1510 $param .=
'&search_warehouse='.urlencode((
string) ($search_warehouse));
1513 $param .=
'&search_login='.urlencode($search_login);
1515if ($search_multicurrency_code !=
'') {
1516 $param .=
'&search_multicurrency_code='.urlencode($search_multicurrency_code);
1518if ($search_multicurrency_tx !=
'') {
1519 $param .=
'&search_multicurrency_tx='.urlencode($search_multicurrency_tx);
1521if ($search_multicurrency_montant_ht !=
'') {
1522 $param .=
'&search_multicurrency_montant_ht='.urlencode($search_multicurrency_montant_ht);
1524if ($search_multicurrency_montant_vat !=
'') {
1525 $param .=
'&search_multicurrency_montant_vat='.urlencode($search_multicurrency_montant_vat);
1527if ($search_multicurrency_montant_ttc !=
'') {
1528 $param .=
'&search_multicurrency_montant_ttc='.urlencode($search_multicurrency_montant_ttc);
1530if ($search_project_ref >= 0) {
1531 $param .=
"&search_project_ref=".urlencode($search_project_ref);
1533if ($search_project !=
'') {
1534 $param .=
"&search_project=".urlencode($search_project);
1536if ($search_town !=
'') {
1537 $param .=
'&search_town='.urlencode($search_town);
1539if ($search_zip !=
'') {
1540 $param .=
'&search_zip='.urlencode($search_zip);
1542if ($search_state !=
'') {
1543 $param .=
'&search_state='.urlencode($search_state);
1545if ($search_country !=
'') {
1546 $param .=
'&search_country='.urlencode((
string) ($search_country));
1548if ($search_type_thirdparty && $search_type_thirdparty !=
'-1') {
1549 $param .=
'&search_type_thirdparty='.urlencode((
string) ($search_type_thirdparty));
1551if ($searchCategoryOrderOperator == 1) {
1552 $param .=
"&search_category_order_operator=".urlencode((
string) ($searchCategoryOrderOperator));
1554foreach ($searchCategoryOrderList as $searchCategoryOrder) {
1555 $param .=
"&search_category_order_list[]=".urlencode($searchCategoryOrder);
1557if ($search_product_category !=
'') {
1558 $param .=
'&search_product_category='.urlencode((
string) ($search_product_category));
1560if (($search_categ_cus > 0) || ($search_categ_cus == -2)) {
1561 $param .=
'&search_categ_cus='.urlencode((
string) ($search_categ_cus));
1563if ($search_billed !=
'') {
1564 $param .=
'&search_billed='.urlencode($search_billed);
1566if ($search_fk_cond_reglement > 0) {
1567 $param .=
'&search_fk_cond_reglement='.urlencode((
string) ($search_fk_cond_reglement));
1569if ($search_fk_shipping_method > 0) {
1570 $param .=
'&search_fk_shipping_method='.urlencode((
string) ($search_fk_shipping_method));
1572if ($search_fk_mode_reglement > 0) {
1573 $param .=
'&search_fk_mode_reglement='.urlencode((
string) ($search_fk_mode_reglement));
1575if ($search_fk_input_reason > 0) {
1576 $param .=
'&search_fk_input_reason='.urlencode((
string) ($search_fk_input_reason));
1578if ($search_module_source) {
1579 $param .=
'&search_module_source='.urlencode($search_module_source);
1581if ($search_pos_source) {
1582 $param .=
'&search_pos_source='.urlencode($search_pos_source);
1584if ($search_import_key !=
'') {
1585 $param .=
'&search_import_key='.urlencode($search_import_key);
1589include DOL_DOCUMENT_ROOT.
'/core/tpl/extrafields_list_search_param.tpl.php';
1592$parameters = array();
1593$reshook = $hookmanager->executeHooks(
'printFieldListSearchParam', $parameters, $object, $action);
1594$param .= $hookmanager->resPrint;
1597$arrayofmassactions = array(
1598 'generate_doc' =>
img_picto(
'',
'pdf',
'class="pictofixedwidth"').$langs->trans(
"ReGeneratePDF"),
1599 'builddoc' =>
img_picto(
'',
'pdf',
'class="pictofixedwidth"').$langs->trans(
"PDFMerge"),
1601if (
isModEnabled(
'category') && $user->hasRight(
"commande",
"lire")) {
1602 $arrayofmassactions[
'preaffecttag'] =
img_picto(
'',
'category',
'class="pictofixedwidth"').$langs->trans(
"AffectTag");
1604if ($permissiontovalidate) {
1605 $arrayofmassactions[
'prevalidate'] =
img_picto(
'',
'check',
'class="pictofixedwidth"').$langs->trans(
"Validate");
1607if ($permissiontoclose) {
1608 $arrayofmassactions[
'preshipped'] =
img_picto(
'',
'dolly',
'class="pictofixedwidth"').$langs->trans(
"ClassifyShipped");
1610if (
isModEnabled(
'invoice') && $user->hasRight(
"facture",
"creer")) {
1611 $arrayofmassactions[
'createbills'] =
img_picto(
'',
'bill',
'class="pictofixedwidth"').$langs->trans(
"CreateInvoiceForThisCustomer");
1613if ($permissiontoclose) {
1614 $arrayofmassactions[
'setbilled'] =
img_picto(
'',
'bill',
'class="pictofixedwidth"').$langs->trans(
"ClassifyBilled");
1616if ($permissiontocancel) {
1617 $arrayofmassactions[
'cancelorders'] =
img_picto(
'',
'close_title',
'class="pictofixedwidth"').$langs->trans(
"CancelOrder");
1619if (!empty($permissiontodelete)) {
1620 $arrayofmassactions[
'predelete'] =
img_picto(
'',
'delete',
'class="pictofixedwidth"').$langs->trans(
"Delete");
1622if ($permissiontosendbymail) {
1623 $arrayofmassactions[
'presend'] =
img_picto(
'',
'email',
'class="pictofixedwidth"').$langs->trans(
"SendByMail");
1625if (in_array($massaction, array(
'presend',
'predelete',
'createbills'))) {
1626 $arrayofmassactions = array();
1628$massactionbutton = $form->selectMassAction(
'', $arrayofmassactions);
1630$url = DOL_URL_ROOT.
'/commande/card.php?action=create';
1631if (!empty($socid)) {
1632 $url .=
'&socid='.$socid;
1635$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'));
1636$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'));
1638$newcardbutton .=
dolGetButtonTitle($langs->trans(
'NewOrder'),
'',
'fa fa-plus-circle', $url,
'', (
int) (($contextpage ==
'orderlist' || $contextpage ==
'billableorders') && $permissiontoadd));
1641print
'<form method="POST" id="searchFormList" name="searchFormList" action="'.$_SERVER[
"PHP_SELF"].
'">'.
"\n";
1642if ($optioncss !=
'') {
1643 print
'<input type="hidden" name="optioncss" value="'.$optioncss.
'">';
1645print
'<input type="hidden" name="token" value="'.newToken().
'">';
1646print
'<input type="hidden" name="formfilteraction" id="formfilteraction" value="list">';
1647print
'<input type="hidden" name="action" value="list">';
1648print
'<input type="hidden" name="sortfield" value="'.$sortfield.
'">';
1649print
'<input type="hidden" name="sortorder" value="'.$sortorder.
'">';
1650print
'<input type="hidden" name="contextpage" value="'.$contextpage.
'">';
1651print
'<input type="hidden" name="search_status" value="'.$search_status.
'">';
1652print
'<input type="hidden" name="socid" value="'.$socid.
'">';
1653print
'<input type="hidden" name="page_y" value="">';
1654print
'<input type="hidden" name="mode" value="'.$mode.
'">';
1657print_barre_liste($title, $page, $_SERVER[
"PHP_SELF"], $param, $sortfield, $sortorder, $massactionbutton, $num, $nbtotalofrecords,
'order', 0, $newcardbutton,
'', $limit, 0, 0, 1);
1659$topicmail =
"SendOrderRef";
1660$modelmail =
"order_send";
1662$trackid =
'ord'.$object->id;
1663include DOL_DOCUMENT_ROOT.
'/core/tpl/massactions_pre.tpl.php';
1665if ($massaction ==
'prevalidate') {
1666 print $form->formconfirm($_SERVER[
"PHP_SELF"], $langs->trans(
"ConfirmMassValidation"), $langs->trans(
"ConfirmMassValidationQuestion"),
"validate",
null,
'', 0, 200, 500, 1);
1668if ($massaction ==
'preshipped') {
1669 print $form->formconfirm($_SERVER[
"PHP_SELF"], $langs->trans(
"CloseOrder"), $langs->trans(
"ConfirmCloseOrder"),
"shipped",
null,
'', 0, 200, 500, 1);
1672if ($massaction ==
'createbills') {
1673 print
'<input type="hidden" name="massaction" value="confirm_createbills">';
1675 print
'<table class="noborder centpercent">';
1678 print $langs->trans(
'DateInvoice');
1681 print $form->selectDate(
'',
'', 0, 0, 0,
'', 1, 1);
1686 print $langs->trans(
'CreateOneBillByThird');
1689 print $form->selectyesno(
'createbills_onebythird',
getDolGlobalString(
'MAIN_ORDERLIST_CREATEBILLS_ONEBYTHIRD',
'no'), 1);
1694 print $langs->trans(
'ValidateInvoices');
1698 print $form->selectyesno(
'validate_invoices', 0, 1, 1);
1699 $langs->load(
"errors");
1700 print
' ('.$langs->trans(
"WarningAutoValNotPossibleWhenStockIsDecreasedOnInvoiceVal").
')';
1702 print $form->selectyesno(
'validate_invoices', 0, 1);
1704 if (!empty($conf->workflow->enabled) &&
getDolGlobalString(
'WORKFLOW_INVOICE_AMOUNT_CLASSIFY_BILLED_ORDER')) {
1705 print
' <span class="opacitymedium">'.$langs->trans(
"IfValidateInvoiceIsNoOrderStayUnbilled").
'</span>';
1707 print
' <span class="opacitymedium">'.$langs->trans(
"OptionToSetOrderBilledNotEnabled").
'</span>';
1713 print
'<div class="center">';
1714 print
'<input type="submit" class="button" id="createbills" name="createbills" value="'.$langs->trans(
'CreateInvoiceForThisCustomer').
'"> ';
1715 print
'<input type="submit" class="button button-cancel" id="cancel" name="cancel" value="'.$langs->trans(
"Cancel").
'">';
1722 foreach ($fieldstosearchall as $key => $val) {
1723 $fieldstosearchall[$key] = $langs->trans($val);
1724 $setupstring .= $key.
"=".$val.
";";
1726 print
'<!-- Search done like if MYOBJECT_QUICKSEARCH_ON_FIELDS = '.$setupstring.
' -->'.
"\n";
1727 print
'<div class="divsearchfieldfilter">'.$langs->trans(
"FilterOnInto", $search_all).implode(
', ', $fieldstosearchall).
'</div>';
1732if (
isModEnabled(
'category') && $user->hasRight(
'categorie',
'read')) {
1734 $moreforfilter .= $formcategory->getFilterBox(Categorie::TYPE_ORDER, $searchCategoryOrderList,
'minwidth300', $searchCategoryOrderOperator ? $searchCategoryOrderOperator : 0);
1738if ($user->hasRight(
"user",
"user",
"lire")) {
1739 $langs->load(
"commercial");
1740 $moreforfilter .=
'<div class="divsearchfield">';
1741 $tmptitle = $langs->trans(
'ThirdPartiesOfSaleRepresentative');
1742 $moreforfilter .=
img_picto($tmptitle,
'user',
'class="pictofixedwidth"').$formother->select_salesrepresentatives($search_sale,
'search_sale', $user, 0, $tmptitle,
'maxwidth250 widthcentpercentminusx');
1743 $moreforfilter .=
'</div>';
1746if ($user->hasRight(
"user",
"user",
"lire")) {
1747 $moreforfilter .=
'<div class="divsearchfield">';
1748 $tmptitle = $langs->trans(
'LinkedToSpecificUsers');
1749 $moreforfilter .=
img_picto($tmptitle,
'user',
'class="pictofixedwidth"').$form->select_dolusers($search_user,
'search_user', $tmptitle,
null, 0,
'',
'',
'0', 0, 0,
'', 0,
'',
'maxwidth250 widthcentpercentminusx');
1750 $moreforfilter .=
'</div>';
1754if (
isModEnabled(
'category') && $user->hasRight(
"categorie",
"lire") && ($user->hasRight(
"produit",
"lire") || $user->hasRight(
"service",
"lire"))) {
1755 include_once DOL_DOCUMENT_ROOT.
'/categories/class/categorie.class.php';
1756 $moreforfilter .=
'<div class="divsearchfield">';
1757 $tmptitle = $langs->trans(
'IncludingProductWithTag');
1758 $cate_arbo = $form->select_all_categories(Categorie::TYPE_PRODUCT,
'',
'parent', 0, array(), 1);
1759 $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);
1760 $moreforfilter .=
'</div>';
1763if (
isModEnabled(
'category') && $user->hasRight(
"categorie",
"lire")) {
1764 require_once DOL_DOCUMENT_ROOT.
'/categories/class/categorie.class.php';
1765 $moreforfilter .=
'<div class="divsearchfield">';
1766 $tmptitle = $langs->trans(
'CustomersProspectsCategoriesShort');
1767 $moreforfilter .=
img_picto($tmptitle,
'category',
'class="pictofixedwidth"').$formother->select_categories(
'customer', $search_categ_cus,
'search_categ_cus', 1, $tmptitle,
'maxwidth300 widthcentpercentminusx');
1768 $moreforfilter .=
'</div>';
1772 require_once DOL_DOCUMENT_ROOT.
'/product/class/html.formproduct.class.php';
1774 $moreforfilter .=
'<div class="divsearchfield">';
1775 $tmptitle = $langs->trans(
'Warehouse');
1776 $moreforfilter .=
img_picto($tmptitle,
'stock',
'class="pictofixedwidth"').$formproduct->selectWarehouses($search_warehouse,
'search_warehouse',
'', 1, 0, 0, $tmptitle, 0, 0, array(),
'maxwidth250 widthcentpercentminusx');
1777 $moreforfilter .=
'</div>';
1780$parameters = array();
1781$reshook = $hookmanager->executeHooks(
'printFieldPreListTitle', $parameters, $object, $action);
1782if (empty($reshook)) {
1783 $moreforfilter .= $hookmanager->resPrint;
1785 $moreforfilter = $hookmanager->resPrint;
1788if (!empty($moreforfilter)) {
1789 print
'<div class="liste_titre liste_titre_bydiv centpercent">';
1790 print $moreforfilter;
1794$varpage = empty($contextpage) ? $_SERVER[
"PHP_SELF"] : $contextpage;
1795$htmlofselectarray = $form->multiSelectArrayWithCheckbox(
'selectedfields', $arrayfields, $varpage,
getDolGlobalString(
'MAIN_CHECKBOX_LEFT_COLUMN'));
1796$selectedfields = ($mode !=
'kanban' ? $htmlofselectarray :
'');
1797$selectedfields .= (count($arrayofmassactions) ? $form->showCheckAddButtons(
'checkforselect', 1) :
'');
1800 $selectedfields .=
'<script>';
1801 $selectedfields .=
' $(document).ready(function() {';
1802 $selectedfields .=
' console.log("Autoclick on checkforselects");';
1803 $selectedfields .=
' $("#checkforselects").click();';
1804 $selectedfields .=
' $("#massaction").val("createbills").change();';
1805 $selectedfields .=
' });';
1806 $selectedfields .=
'</script>';
1809print
'<div class="div-table-responsive">';
1810print
'<table class="tagtable nobottomiftotal liste'.($moreforfilter ?
" listwithfilterbefore" :
"").
'">'.
"\n";
1814print
'<tr class="liste_titre_filter">';
1817 print
'<td class="liste_titre center maxwidthsearch actioncolumn">';
1818 $searchpicto = $form->showFilterButtons(
'left');
1824if (!empty($arrayfields[
'c.rowid'][
'checked'])) {
1825 print
'<td class="liste_titre">';
1826 print
'<input class="flat" size="6" type="text" name="search_id" value="'.dol_escape_htmltag($search_id).
'">';
1831if (!empty($arrayfields[
'c.ref'][
'checked'])) {
1832 print
'<td class="liste_titre">';
1833 print
'<input class="flat maxwidth50imp" type="text" name="search_ref" value="'.dol_escape_htmltag($search_ref).
'">';
1837if (!empty($arrayfields[
'c.ref_ext'][
'checked'])) {
1838 print
'<td class="liste_titre">';
1839 print
'<input class="flat maxwidth50imp" type="text" name="search_ref_ext" value="'.dol_escape_htmltag($search_ref_ext).
'">';
1843if (!empty($arrayfields[
'c.ref_client'][
'checked'])) {
1844 print
'<td class="liste_titre" align="left">';
1845 print
'<input class="flat" type="text" size="6" name="search_ref_customer" value="'.dol_escape_htmltag($search_ref_customer).
'">';
1849if (!empty($arrayfields[
'p.ref'][
'checked'])) {
1850 print
'<td class="liste_titre"><input type="text" class="flat" size="6" name="search_project_ref" value="'.dol_escape_htmltag($search_project_ref).
'"></td>';
1853if (!empty($arrayfields[
'p.title'][
'checked'])) {
1854 print
'<td class="liste_titre"><input type="text" class="flat" size="6" name="search_project" value="'.dol_escape_htmltag($search_project).
'"></td>';
1857if (!empty($arrayfields[
's.nom'][
'checked'])) {
1858 print
'<td class="liste_titre">';
1859 print
'<input class="flat maxwidth75imp" type="text" name="search_company" value="'.dol_escape_htmltag((
string) $search_company).
'"'.(!empty($user->socid) ?
" disabled" :
"").
'>';
1863if (!empty($arrayfields[
's.name_alias'][
'checked'])) {
1864 print
'<td class="liste_titre">';
1865 print
'<input class="flat maxwidth75imp" type="text" name="search_company_alias" value="'.dol_escape_htmltag($search_company_alias).
'">';
1869if (!empty($arrayfields[
's2.nom'][
'checked'])) {
1870 print
'<td class="liste_titre">';
1871 print
'<input class="flat maxwidth100" type="text" name="search_parent_name" value="'.dol_escape_htmltag($search_parent_name).
'">';
1875if (!empty($arrayfields[
's.town'][
'checked'])) {
1876 print
'<td class="liste_titre"><input class="flat maxwidth75imp" type="text" name="search_town" value="'.dol_escape_htmltag($search_town).
'"></td>';
1879if (!empty($arrayfields[
's.zip'][
'checked'])) {
1880 print
'<td class="liste_titre"><input class="flat maxwidth50imp" type="text" name="search_zip" value="'.dol_escape_htmltag($search_zip).
'"></td>';
1883if (!empty($arrayfields[
'state.nom'][
'checked'])) {
1884 print
'<td class="liste_titre">';
1885 print
'<input class="flat maxwidth50imp" type="text" name="search_state" value="'.dol_escape_htmltag($search_state).
'">';
1889if (!empty($arrayfields[
'country.code_iso'][
'checked'])) {
1890 print
'<td class="liste_titre" align="center">';
1891 print $form->select_country($search_country,
'search_country',
'', 0,
'minwidth100imp maxwidth100');
1895if (!empty($arrayfields[
'typent.code'][
'checked'])) {
1896 print
'<td class="liste_titre maxwidthonsmartphone center">';
1897 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' : $conf->global->SOCIETE_SORT_ON_TYPEENT),
'', 1);
1901if (!empty($arrayfields[
'c.date_commande'][
'checked'])) {
1902 print
'<td class="liste_titre center">';
1903 print
'<div class="nowrapfordate">';
1904 print $form->selectDate($search_dateorder_start ? $search_dateorder_start : -1,
'search_dateorder_start_', 0, 0, 1,
'', 1, 0, 0,
'',
'',
'',
'', 1,
'', $langs->trans(
'From'));
1906 print
'<div class="nowrapfordate">';
1907 print $form->selectDate($search_dateorder_end ? $search_dateorder_end : -1,
'search_dateorder_end_', 0, 0, 1,
'', 1, 0, 0,
'',
'',
'',
'', 1,
'', $langs->trans(
'to'));
1911if (!empty($arrayfields[
'c.delivery_date'][
'checked'])) {
1912 print
'<td class="liste_titre center">';
1913 print
'<div class="nowrapfordate">';
1914 print $form->selectDate($search_datedelivery_start ? $search_datedelivery_start : -1,
'search_datedelivery_start_', 0, 0, 1,
'', 1, 0, 0,
'',
'',
'',
'', 1,
'', $langs->trans(
'From'));
1916 print
'<div class="nowrapfordate">';
1917 print $form->selectDate($search_datedelivery_end ? $search_datedelivery_end : -1,
'search_datedelivery_end_', 0, 0, 1,
'', 1, 0, 0,
'',
'',
'',
'', 1,
'', $langs->trans(
'to'));
1922if (!empty($arrayfields[
'c.fk_shipping_method'][
'checked'])) {
1923 print
'<td class="liste_titre">';
1924 $form->selectShippingMethod($search_fk_shipping_method,
'search_fk_shipping_method',
'', 1,
'', 1);
1928if (!empty($arrayfields[
'c.fk_cond_reglement'][
'checked'])) {
1929 print
'<td class="liste_titre">';
1930 print $form->getSelectConditionsPaiements((
int) $search_fk_cond_reglement,
'search_fk_cond_reglement', 1, 1, 1);
1934if (!empty($arrayfields[
'c.fk_mode_reglement'][
'checked'])) {
1935 print
'<td class="liste_titre">';
1936 print $form->select_types_paiements($search_fk_mode_reglement,
'search_fk_mode_reglement',
'', 0, 1, 1, 0, -1,
'', 1);
1940if (!empty($arrayfields[
'c.fk_input_reason'][
'checked'])) {
1941 print
'<td class="liste_titre">';
1942 $form->selectInputReason($search_fk_input_reason,
'search_fk_input_reason',
'', 1,
'', 1);
1946if (!empty($arrayfields[
'c.module_source'][
'checked'])) {
1947 print
'<td class="liste_titre">';
1948 print
'<input class="flat maxwidth75" type="text" name="search_module_source" value="'.dol_escape_htmltag($search_module_source).
'">';
1952if (!empty($arrayfields[
'c.pos_source'][
'checked'])) {
1953 print
'<td class="liste_titre">';
1954 print
'<input class="flat maxwidth50" type="text" name="search_pos_source" value="'.dol_escape_htmltag($search_pos_source).
'">';
1958if (!empty($arrayfields[
'c.total_ht'][
'checked'])) {
1959 print
'<td class="liste_titre right">';
1960 print
'<input class="flat" type="text" size="4" name="search_total_ht" value="'.dol_escape_htmltag($search_total_ht).
'">';
1964if (!empty($arrayfields[
'c.total_vat'][
'checked'])) {
1965 print
'<td class="liste_titre right">';
1966 print
'<input class="flat" type="text" size="4" name="search_total_vat" value="'.dol_escape_htmltag($search_total_vat).
'">';
1970if (!empty($arrayfields[
'c.total_ttc'][
'checked'])) {
1971 print
'<td class="liste_titre right">';
1972 print
'<input class="flat" type="text" size="5" name="search_total_ttc" value="'.$search_total_ttc.
'">';
1976if (!empty($arrayfields[
'c.multicurrency_code'][
'checked'])) {
1977 print
'<td class="liste_titre">';
1978 print $form->selectMultiCurrency($search_multicurrency_code,
'search_multicurrency_code', 1);
1982if (!empty($arrayfields[
'c.multicurrency_tx'][
'checked'])) {
1983 print
'<td class="liste_titre">';
1984 print
'<input class="flat" type="text" size="4" name="search_multicurrency_tx" value="'.dol_escape_htmltag($search_multicurrency_tx).
'">';
1988if (!empty($arrayfields[
'c.multicurrency_total_ht'][
'checked'])) {
1989 print
'<td class="liste_titre right">';
1990 print
'<input class="flat" type="text" size="4" name="search_multicurrency_montant_ht" value="'.dol_escape_htmltag($search_multicurrency_montant_ht).
'">';
1994if (!empty($arrayfields[
'c.multicurrency_total_vat'][
'checked'])) {
1995 print
'<td class="liste_titre right">';
1996 print
'<input class="flat" type="text" size="4" name="search_multicurrency_montant_vat" value="'.dol_escape_htmltag($search_multicurrency_montant_vat).
'">';
2000if (!empty($arrayfields[
'c.multicurrency_total_ttc'][
'checked'])) {
2001 print
'<td class="liste_titre right">';
2002 print
'<input class="flat width75" type="text" name="search_multicurrency_montant_ttc" value="'.dol_escape_htmltag($search_multicurrency_montant_ttc).
'">';
2006if (!empty($arrayfields[
'u.login'][
'checked'])) {
2007 print
'<td class="liste_titre">';
2008 print
'<input class="flat width75" type="text" name="search_login" value="'.dol_escape_htmltag($search_login).
'">';
2012if (!empty($arrayfields[
'sale_representative'][
'checked'])) {
2013 print
'<td class="liste_titre"></td>';
2015if (!empty($arrayfields[
'total_pa'][
'checked'])) {
2016 print
'<td class="liste_titre right">';
2019if (!empty($arrayfields[
'total_margin'][
'checked'])) {
2020 print
'<td class="liste_titre right">';
2023if (!empty($arrayfields[
'total_margin_rate'][
'checked'])) {
2024 print
'<td class="liste_titre right">';
2027if (!empty($arrayfields[
'total_mark_rate'][
'checked'])) {
2028 print
'<td class="liste_titre right">';
2033if (!empty($arrayfields[
'c.datec'][
'checked'])) {
2034 print
'<td class="liste_titre">';
2038if (!empty($arrayfields[
'c.tms'][
'checked'])) {
2039 print
'<td class="liste_titre">';
2043if (!empty($arrayfields[
'c.date_cloture'][
'checked'])) {
2044 print
'<td class="liste_titre center">';
2045 print
'<div class="nowrapfordate">';
2046 print $form->selectDate($search_datecloture_start ? $search_datecloture_start : -1,
'search_datecloture_start', 0, 0, 1,
'', 1, 0, 0,
'',
'',
'',
'', 1,
'', $langs->trans(
'From'));
2048 print
'<div class="nowrapfordate">';
2049 print $form->selectDate($search_datecloture_end ? $search_datecloture_end : -1,
'search_datecloture_end', 0, 0, 1,
'', 1, 0, 0,
'',
'',
'',
'', 1,
'', $langs->trans(
'to'));
2054if (!empty($arrayfields[
'c.note_public'][
'checked'])) {
2055 print
'<td class="liste_titre">';
2056 print
'<input class="flat width75" type="text" name="search_note_public" value="'.dolPrintHTMLForAttribute($search_note_public).
'">';
2060if (!empty($arrayfields[
'c.note_private'][
'checked'])) {
2061 print
'<td class="liste_titre">';
2062 print
'<input class="flat width75" type="text" name="search_note_private" value="'.dolPrintHTMLForAttribute($search_note_private).
'">';
2066if (!empty($arrayfields[
'shippable'][
'checked'])) {
2067 print
'<td class="liste_titre maxwidthonsmartphone" align="center">';
2070 print
'<input type="checkbox" name="show_shippable_command" value="1"'.($show_shippable_command ?
' checked' :
'').
'>';
2071 print $langs->trans(
'ShowShippableStatus');
2073 $show_shippable_command = 1;
2079include DOL_DOCUMENT_ROOT.
'/core/tpl/extrafields_list_search_input.tpl.php';
2082$parameters = array(
'arrayfields' => $arrayfields);
2083$reshook = $hookmanager->executeHooks(
'printFieldListOption', $parameters, $object, $action);
2084print $hookmanager->resPrint;
2087if (!empty($arrayfields[
'c.facture'][
'checked'])) {
2088 print
'<td class="liste_titre maxwidthonsmartphone center">';
2089 print $form->selectyesno(
'search_billed', $search_billed, 1, 0, 1, 1);
2094if (!empty($arrayfields[
'c.import_key'][
'checked'])) {
2095 print
'<td class="liste_titre maxwidthonsmartphone center">';
2096 print
'<input class="flat searchstring maxwidth50" type="text" name="search_import_key" value="'.dol_escape_htmltag($search_import_key).
'">';
2101if (!empty($arrayfields[
'c.fk_statut'][
'checked'])) {
2102 print
'<td class="liste_titre center parentonrightofpage">';
2103 $liststatus = array(
2107 -2 => $langs->trans(
"StatusOrderValidatedShort").
'+'.$langs->trans(
"StatusOrderSentShort"),
2108 -3 => $langs->trans(
"StatusOrderValidatedShort").
'+'.$langs->trans(
"StatusOrderSentShort").
'+'.$langs->trans(
"StatusOrderDelivered"),
2113 print $form->selectarray(
'search_status', $liststatus, $search_status, -5, 0, 0,
'', 0, 0, 0,
'',
'search_status width100 onrightofpage', 1);
2118 print
'<td class="liste_titre center maxwidthsearch">';
2119 $searchpicto = $form->showFilterButtons();
2138print
'<tr class="liste_titre">';
2142 print_liste_field_titre($selectedfields, $_SERVER[
"PHP_SELF"],
"",
'', $param,
'', $sortfield, $sortorder,
'maxwidthsearch center ');
2145if (!empty($arrayfields[
'c.rowid'][
'checked'])) {
2146 print_liste_field_titre($arrayfields[
'c.rowid'][
'label'], $_SERVER[
"PHP_SELF"],
'c.rowid',
'', $param,
'', $sortfield, $sortorder,
'center ');
2149if (!empty($arrayfields[
'c.ref'][
'checked'])) {
2150 print_liste_field_titre($arrayfields[
'c.ref'][
'label'], $_SERVER[
"PHP_SELF"],
'c.ref',
'', $param,
'', $sortfield, $sortorder);
2153if (!empty($arrayfields[
'c.ref_ext'][
'checked'])) {
2154 print_liste_field_titre($arrayfields[
'c.ref_ext'][
'label'], $_SERVER[
"PHP_SELF"],
'c.ref_ext',
'', $param,
'', $sortfield, $sortorder);
2157if (!empty($arrayfields[
'c.ref_client'][
'checked'])) {
2158 print_liste_field_titre($arrayfields[
'c.ref_client'][
'label'], $_SERVER[
"PHP_SELF"],
'c.ref_client',
'', $param,
'', $sortfield, $sortorder);
2161if (!empty($arrayfields[
'p.ref'][
'checked'])) {
2162 print_liste_field_titre($arrayfields[
'p.ref'][
'label'], $_SERVER[
"PHP_SELF"],
"p.ref",
"", $param,
'', $sortfield, $sortorder);
2165if (!empty($arrayfields[
'p.title'][
'checked'])) {
2166 print_liste_field_titre($arrayfields[
'p.title'][
'label'], $_SERVER[
"PHP_SELF"],
"p.title",
"", $param,
'', $sortfield, $sortorder);
2169if (!empty($arrayfields[
's.nom'][
'checked'])) {
2170 print_liste_field_titre($arrayfields[
's.nom'][
'label'], $_SERVER[
"PHP_SELF"],
's.nom',
'', $param,
'', $sortfield, $sortorder);
2173if (!empty($arrayfields[
's.name_alias'][
'checked'])) {
2175 print_liste_field_titre($arrayfields[
's.name_alias'][
'label'], $_SERVER[
"PHP_SELF"],
's.name_alias',
'', $param,
'', $sortfield, $sortorder);
2178if (!empty($arrayfields[
's2.nom'][
'checked'])) {
2179 print_liste_field_titre($arrayfields[
's2.nom'][
'label'], $_SERVER[
'PHP_SELF'],
's2.nom',
'', $param,
'', $sortfield, $sortorder);
2182if (!empty($arrayfields[
's.town'][
'checked'])) {
2183 print_liste_field_titre($arrayfields[
's.town'][
'label'], $_SERVER[
"PHP_SELF"],
's.town',
'', $param,
'', $sortfield, $sortorder);
2186if (!empty($arrayfields[
's.zip'][
'checked'])) {
2187 print_liste_field_titre($arrayfields[
's.zip'][
'label'], $_SERVER[
"PHP_SELF"],
's.zip',
'', $param,
'', $sortfield, $sortorder);
2190if (!empty($arrayfields[
'state.nom'][
'checked'])) {
2191 print_liste_field_titre($arrayfields[
'state.nom'][
'label'], $_SERVER[
"PHP_SELF"],
"state.nom",
"", $param,
'', $sortfield, $sortorder);
2194if (!empty($arrayfields[
'country.code_iso'][
'checked'])) {
2195 print_liste_field_titre($arrayfields[
'country.code_iso'][
'label'], $_SERVER[
"PHP_SELF"],
"country.code_iso",
"", $param,
'', $sortfield, $sortorder,
'center ');
2198if (!empty($arrayfields[
'typent.code'][
'checked'])) {
2199 print_liste_field_titre($arrayfields[
'typent.code'][
'label'], $_SERVER[
"PHP_SELF"],
"typent.code",
"", $param,
'', $sortfield, $sortorder,
'center ');
2202if (!empty($arrayfields[
'c.date_commande'][
'checked'])) {
2203 print_liste_field_titre($arrayfields[
'c.date_commande'][
'label'], $_SERVER[
"PHP_SELF"],
'c.date_commande',
'', $param,
'', $sortfield, $sortorder,
'center ');
2206if (!empty($arrayfields[
'c.delivery_date'][
'checked'])) {
2207 print_liste_field_titre($arrayfields[
'c.delivery_date'][
'label'], $_SERVER[
"PHP_SELF"],
'c.date_livraison',
'', $param,
'', $sortfield, $sortorder,
'center ');
2210if (!empty($arrayfields[
'c.fk_shipping_method'][
'checked'])) {
2211 print_liste_field_titre($arrayfields[
'c.fk_shipping_method'][
'label'], $_SERVER[
"PHP_SELF"],
"c.fk_shipping_method",
"", $param,
'', $sortfield, $sortorder);
2214if (!empty($arrayfields[
'c.fk_cond_reglement'][
'checked'])) {
2215 print_liste_field_titre($arrayfields[
'c.fk_cond_reglement'][
'label'], $_SERVER[
"PHP_SELF"],
"c.fk_cond_reglement",
"", $param,
'', $sortfield, $sortorder);
2218if (!empty($arrayfields[
'c.fk_mode_reglement'][
'checked'])) {
2219 print_liste_field_titre($arrayfields[
'c.fk_mode_reglement'][
'label'], $_SERVER[
"PHP_SELF"],
"c.fk_mode_reglement",
"", $param,
'', $sortfield, $sortorder);
2222if (!empty($arrayfields[
'c.fk_input_reason'][
'checked'])) {
2223 print_liste_field_titre($arrayfields[
'c.fk_input_reason'][
'label'], $_SERVER[
"PHP_SELF"],
"c.fk_input_reason",
"", $param,
'', $sortfield, $sortorder);
2226if (!empty($arrayfields[
'c.module_source'][
'checked'])) {
2227 print_liste_field_titre($arrayfields[
'c.module_source'][
'label'], $_SERVER[
"PHP_SELF"],
"f.module_source",
"", $param,
"", $sortfield, $sortorder);
2230if (!empty($arrayfields[
'c.pos_source'][
'checked'])) {
2231 print_liste_field_titre($arrayfields[
'c.pos_source'][
'label'], $_SERVER[
"PHP_SELF"],
"f.pos_source",
"", $param,
"", $sortfield, $sortorder);
2234if (!empty($arrayfields[
'c.total_ht'][
'checked'])) {
2235 print_liste_field_titre($arrayfields[
'c.total_ht'][
'label'], $_SERVER[
"PHP_SELF"],
'c.total_ht',
'', $param,
'', $sortfield, $sortorder,
'right ');
2238if (!empty($arrayfields[
'c.total_vat'][
'checked'])) {
2239 print_liste_field_titre($arrayfields[
'c.total_vat'][
'label'], $_SERVER[
"PHP_SELF"],
'c.total_tva',
'', $param,
'', $sortfield, $sortorder,
'right ');
2242if (!empty($arrayfields[
'c.total_ttc'][
'checked'])) {
2243 print_liste_field_titre($arrayfields[
'c.total_ttc'][
'label'], $_SERVER[
"PHP_SELF"],
'c.total_ttc',
'', $param,
'', $sortfield, $sortorder,
'right ');
2246if (!empty($arrayfields[
'c.multicurrency_code'][
'checked'])) {
2247 print_liste_field_titre($arrayfields[
'c.multicurrency_code'][
'label'], $_SERVER[
'PHP_SELF'],
'c.multicurrency_code',
'', $param,
'', $sortfield, $sortorder);
2250if (!empty($arrayfields[
'c.multicurrency_tx'][
'checked'])) {
2251 print_liste_field_titre($arrayfields[
'c.multicurrency_tx'][
'label'], $_SERVER[
'PHP_SELF'],
'c.multicurrency_tx',
'', $param,
'', $sortfield, $sortorder);
2254if (!empty($arrayfields[
'c.multicurrency_total_ht'][
'checked'])) {
2255 print_liste_field_titre($arrayfields[
'c.multicurrency_total_ht'][
'label'], $_SERVER[
'PHP_SELF'],
'c.multicurrency_total_ht',
'', $param,
'class="right"', $sortfield, $sortorder);
2258if (!empty($arrayfields[
'c.multicurrency_total_vat'][
'checked'])) {
2259 print_liste_field_titre($arrayfields[
'c.multicurrency_total_vat'][
'label'], $_SERVER[
'PHP_SELF'],
'c.multicurrency_total_tva',
'', $param,
'class="right"', $sortfield, $sortorder);
2262if (!empty($arrayfields[
'c.multicurrency_total_ttc'][
'checked'])) {
2263 print_liste_field_titre($arrayfields[
'c.multicurrency_total_ttc'][
'label'], $_SERVER[
'PHP_SELF'],
'c.multicurrency_total_ttc',
'', $param,
'class="right"', $sortfield, $sortorder);
2266if (!empty($arrayfields[
'u.login'][
'checked'])) {
2267 print_liste_field_titre($arrayfields[
'u.login'][
'label'], $_SERVER[
"PHP_SELF"],
'u.login',
'', $param,
'', $sortfield, $sortorder);
2270if (!empty($arrayfields[
'sale_representative'][
'checked'])) {
2271 print_liste_field_titre($arrayfields[
'sale_representative'][
'label'], $_SERVER[
"PHP_SELF"],
"",
"",
"$param",
'', $sortfield, $sortorder);
2274if (!empty($arrayfields[
'total_pa'][
'checked'])) {
2275 print_liste_field_titre($arrayfields[
'total_pa'][
'label'], $_SERVER[
'PHP_SELF'],
'',
'', $param,
'class="right"', $sortfield, $sortorder);
2278if (!empty($arrayfields[
'total_margin'][
'checked'])) {
2279 print_liste_field_titre($arrayfields[
'total_margin'][
'label'], $_SERVER[
'PHP_SELF'],
'',
'', $param,
'class="right"', $sortfield, $sortorder);
2282if (!empty($arrayfields[
'total_margin_rate'][
'checked'])) {
2283 print_liste_field_titre($arrayfields[
'total_margin_rate'][
'label'], $_SERVER[
'PHP_SELF'],
'',
'', $param,
'class="right"', $sortfield, $sortorder);
2286if (!empty($arrayfields[
'total_mark_rate'][
'checked'])) {
2287 print_liste_field_titre($arrayfields[
'total_mark_rate'][
'label'], $_SERVER[
'PHP_SELF'],
'',
'', $param,
'class="right"', $sortfield, $sortorder);
2291if (!empty($arrayfields[
'c.datec'][
'checked'])) {
2292 print_liste_field_titre($arrayfields[
'c.datec'][
'label'], $_SERVER[
"PHP_SELF"],
"c.date_creation",
"", $param,
'', $sortfield, $sortorder,
'center nowrap ');
2295if (!empty($arrayfields[
'c.tms'][
'checked'])) {
2296 print_liste_field_titre($arrayfields[
'c.tms'][
'label'], $_SERVER[
"PHP_SELF"],
"c.tms",
"", $param,
'', $sortfield, $sortorder,
'center nowrap ');
2299if (!empty($arrayfields[
'c.date_cloture'][
'checked'])) {
2300 print_liste_field_titre($arrayfields[
'c.date_cloture'][
'label'], $_SERVER[
"PHP_SELF"],
"c.date_cloture",
"", $param,
'', $sortfield, $sortorder,
'center nowrap ');
2303if (!empty($arrayfields[
'c.note_public'][
'checked'])) {
2304 print_liste_field_titre($arrayfields[
'c.note_public'][
'label'], $_SERVER[
"PHP_SELF"],
"c.note_public",
"", $param,
'', $sortfield, $sortorder,
'');
2307if (!empty($arrayfields[
'c.note_private'][
'checked'])) {
2308 print_liste_field_titre($arrayfields[
'c.note_private'][
'label'], $_SERVER[
"PHP_SELF"],
"c.note_private",
"", $param,
'', $sortfield, $sortorder,
'');
2311if (!empty($arrayfields[
'shippable'][
'checked'])) {
2312 print_liste_field_titre($arrayfields[
'shippable'][
'label'], $_SERVER[
"PHP_SELF"],
'',
'', $param,
'', $sortfield, $sortorder,
'center ');
2316include DOL_DOCUMENT_ROOT.
'/core/tpl/extrafields_list_search_title.tpl.php';
2319$parameters = array(
'arrayfields' => $arrayfields,
'param' => $param,
'sortfield' => $sortfield,
'sortorder' => $sortorder,
'totalarray' => &$totalarray);
2320$reshook = $hookmanager->executeHooks(
'printFieldListTitle', $parameters, $object, $action);
2321print $hookmanager->resPrint;
2324if (!empty($arrayfields[
'c.facture'][
'checked'])) {
2325 print_liste_field_titre($arrayfields[
'c.facture'][
'label'], $_SERVER[
"PHP_SELF"],
'c.facture',
'', $param,
'', $sortfield, $sortorder,
'center ');
2329if (!empty($arrayfields[
'c.import_key'][
'checked'])) {
2330 print_liste_field_titre($arrayfields[
'c.import_key'][
'label'], $_SERVER[
"PHP_SELF"],
"c.import_key",
"", $param,
'', $sortfield, $sortorder,
'center ');
2334if (!empty($arrayfields[
'c.fk_statut'][
'checked'])) {
2335 print_liste_field_titre($arrayfields[
'c.fk_statut'][
'label'], $_SERVER[
"PHP_SELF"],
"c.fk_statut",
"", $param,
'', $sortfield, $sortorder,
'center ');
2340 print_liste_field_titre($selectedfields, $_SERVER[
"PHP_SELF"],
"",
'', $param,
'', $sortfield, $sortorder,
'maxwidthsearch center ');
2347$productstat_cache = array();
2348$productstat_cachevirtual = array();
2349$getNomUrl_cache = array();
2351$generic_commande =
new Commande($db);
2352$generic_product =
new Product($db);
2353$userstatic =
new User($db);
2355$with_margin_info =
false;
2357 !empty($arrayfields[
'total_pa'][
'checked'])
2358 || !empty($arrayfields[
'total_margin'][
'checked'])
2359 || !empty($arrayfields[
'total_margin_rate'][
'checked'])
2360 || !empty($arrayfields[
'total_mark_rate'][
'checked'])
2363 $with_margin_info =
true;
2375$imaxinloop = ($limit ? min($num, $limit) : $num);
2376while ($i < $imaxinloop) {
2377 $obj = $db->fetch_object($resql);
2382 $typenArray = $formcompany->typent_array(1);
2390 $companystatic->id = $obj->socid;
2391 $companystatic->name = $obj->name;
2392 $companystatic->name_alias = $obj->alias;
2393 $companystatic->client = $obj->client;
2394 $companystatic->fournisseur = $obj->fournisseur;
2395 $companystatic->code_client = $obj->code_client;
2396 $companystatic->email = $obj->email;
2397 $companystatic->phone = $obj->phone;
2398 $companystatic->address = $obj->address;
2399 $companystatic->zip = $obj->zip;
2400 $companystatic->town = $obj->town;
2401 $companystatic->country_code = $obj->country_code;
2402 if (!isset($getNomUrl_cache[$obj->socid])) {
2403 $getNomUrl_cache[$obj->socid] = $companystatic->getNomUrl(1,
'customer', 100, 0, 1, empty($arrayfields[
's.name_alias'][
'checked']) ? 0 : 1);
2406 $generic_commande->id = $obj->rowid;
2407 $generic_commande->ref = $obj->ref;
2408 $generic_commande->status = $obj->fk_statut;
2409 $generic_commande->statut = $obj->fk_statut;
2410 $generic_commande->status = $obj->fk_statut;
2411 $generic_commande->billed = $obj->billed;
2412 $generic_commande->date = $db->jdate($obj->date_commande);
2413 $generic_commande->delivery_date = $db->jdate($obj->delivery_date);
2414 $generic_commande->ref_client = $obj->ref_client;
2415 $generic_commande->total_ht = $obj->total_ht;
2416 $generic_commande->total_tva = $obj->total_tva;
2417 $generic_commande->total_ttc = $obj->total_ttc;
2418 $generic_commande->note_public = $obj->note_public;
2419 $generic_commande->note_private = $obj->note_private;
2421 $generic_commande->thirdparty = $companystatic;
2424 $projectstatic->id = $obj->project_id;
2425 $projectstatic->ref = $obj->project_ref;
2426 $projectstatic->title = $obj->project_label;
2428 $marginInfo = array();
2429 if ($with_margin_info) {
2430 $generic_commande->fetch_lines();
2431 $marginInfo = $formmargin->getMarginInfosArray($generic_commande);
2432 $total_ht += $obj->total_ht;
2433 $total_margin += $marginInfo[
'total_margin'];
2436 if ($mode ==
'kanban') {
2438 print
'<tr class="trkanban"><td colspan="'.$savnbfield.
'">';
2439 print
'<div class="box-flex-container kanban">';
2444 if ($massactionbutton || $massaction) {
2446 if (in_array(
$object->id, $arrayofselected)) {
2450 print $generic_commande->getKanbanView(
'', array(
'selected' => $selected));
2451 if ($i == ($imaxinloop - 1)) {
2458 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' :
'').
'">';
2462 print
'<td class="nowrap center">';
2463 if ($massactionbutton || $massaction) {
2465 if (in_array($obj->rowid, $arrayofselected)) {
2468 print
'<input id="cb'.$obj->rowid.
'" class="flat checkforselect" type="checkbox" name="toselect[]" value="'.$obj->rowid.
'"'.($selected ?
' checked="checked"' :
'').
'>';
2477 if (!empty($arrayfields[
'c.rowid'][
'checked'])) {
2478 print
'<td class="center" data-key="id">'.$obj->rowid.
'</td>';
2485 if (!empty($arrayfields[
'c.ref'][
'checked'])) {
2486 print
'<td class="nowraponall">';
2487 $getNomUrlOption = $search_status != 2 ? 0 : $obj->fk_statut;
2493 $getNomUrlOption =
'';
2495 print $generic_commande->getNomUrl(1, $getNomUrlOption, 0, 0, 0, 1, 1);
2499 $urlsource = $_SERVER[
'PHP_SELF'].
'?id='.$obj->rowid;
2500 print $formfile->getDocumentsLink($generic_commande->element, $filename, $filedir);
2509 if (!empty($arrayfields[
'c.ref_ext'][
'checked'])) {
2510 print
'<td class="nowrap tdoverflowmax75" title="'.dol_escape_htmltag($obj->ref_ext).
'">';
2519 if (!empty($arrayfields[
'c.ref_client'][
'checked'])) {
2520 print
'<td class="nowrap tdoverflowmax150" title="'.dol_escape_htmltag($obj->ref_client).
'">';
2529 if (!empty($arrayfields[
'p.ref'][
'checked'])) {
2530 print
'<td class="nocellnopadd nowraponall">';
2531 if ($obj->project_id > 0) {
2532 print $projectstatic->getNomUrl(1);
2541 if (!empty($arrayfields[
'p.title'][
'checked'])) {
2542 print
'<td class="nowraponall">';
2543 if ($obj->project_id > 0) {
2544 print $projectstatic->title;
2553 if (!empty($arrayfields[
's.nom'][
'checked'])) {
2554 print
'<td class="tdoverflowmax150">';
2556 print $companystatic->getNomUrl(1,
'customer', 100, 0, 1, empty($arrayfields[
's.name_alias'][
'checked']) ? 0 : 1);
2558 print $getNomUrl_cache[$obj->socid];
2563 if ($user->hasRight(
'facture',
'creer')) {
2564 if (($obj->fk_statut > 0 && $obj->fk_statut < 3) || ($obj->fk_statut == 3 && $obj->billed == 0)) {
2565 print
' <a href="'.DOL_URL_ROOT.
'/commande/list.php?socid='.$companystatic->id.
'&search_billed=0&autoselectall=1">';
2566 print
img_picto($langs->trans(
"CreateInvoiceForThisCustomer").
' : '.$companystatic->name,
'object_bill',
'hideonsmartphone').
'</a>';
2577 if (!empty($arrayfields[
's.name_alias'][
'checked'])) {
2578 print
'<td class="nocellnopadd tdoverflowmax100" title="'.dolPrintHTMLForTextArea($obj->alias).
'">';
2587 if (!empty($arrayfields[
's2.nom'][
'checked'])) {
2588 print
'<td class="tdoverflowmax200">';
2589 if ($obj->fk_parent > 0) {
2590 if (!isset($company_url_list[$obj->fk_parent])) {
2591 $companyparent =
new Societe($db);
2592 $res = $companyparent->fetch($obj->fk_parent);
2594 $company_url_list[$obj->fk_parent] = $companyparent->getNomUrl(1);
2597 if (isset($company_url_list[$obj->fk_parent])) {
2598 print $company_url_list[$obj->fk_parent];
2608 if (!empty($arrayfields[
's.town'][
'checked'])) {
2609 print
'<td class="tdoverflowmax100" title="'.dolPrintHTMLForTextArea($obj->town).
'">';
2618 if (!empty($arrayfields[
's.zip'][
'checked'])) {
2619 print
'<td class="tdoverflowmax100" title="'.dolPrintHTMLForTextArea($obj->zip).
'">';
2628 if (!empty($arrayfields[
'state.nom'][
'checked'])) {
2629 print
'<td class="tdoverflowmax100" title="'.dolPrintHTMLForTextArea($obj->state_name).
'">'.
dolPrintLabel($obj->state_name).
"</td>\n";
2636 if (!empty($arrayfields[
'country.code_iso'][
'checked'])) {
2637 $tmparray =
getCountry($obj->fk_pays,
'all');
2638 print
'<td class="center tdoverflowmax100" title="'.dolPrintHTMLForAttribute($tmparray[
'label']).
'">';
2647 if (!empty($arrayfields[
'typent.code'][
'checked'])) {
2648 if (!is_array($typenArray) || count($typenArray) == 0) {
2649 $typenArray = $formcompany->typent_array(1);
2651 if (!empty($obj->typent_code)) {
2652 print
'<td class="center tdoverflowmax100" title="'.dolPrintHTMLForAttribute($typenArray[$obj->typent_code]).
'">';
2653 print $typenArray[$obj->typent_code];
2655 print
'<td class="center tdoverflowmax100">';
2665 if (!empty($arrayfields[
'c.date_commande'][
'checked'])) {
2666 print
'<td class="center nowraponall">';
2669 if ($generic_commande->hasDelay()) {
2670 print
img_picto($langs->trans(
"Late").
' : '.$generic_commande->showDelay(),
"warning");
2679 if (!empty($arrayfields[
'c.delivery_date'][
'checked'])) {
2680 print
'<td class="center nowraponall">';
2681 print
dol_print_date($db->jdate($obj->delivery_date),
'dayhour');
2689 if (!empty($arrayfields[
'c.fk_shipping_method'][
'checked'])) {
2691 $form->formSelectShippingMethod(
'', $obj->fk_shipping_method,
'none', 1);
2699 if (!empty($arrayfields[
'c.fk_cond_reglement'][
'checked'])) {
2701 $form->form_conditions_reglement($_SERVER[
'PHP_SELF'], $obj->fk_cond_reglement,
'none', 0,
'', 1, $obj->deposit_percent);
2709 if (!empty($arrayfields[
'c.fk_mode_reglement'][
'checked'])) {
2711 $form->form_modes_reglement($_SERVER[
'PHP_SELF'], $obj->fk_mode_reglement,
'none',
'', -1);
2719 if (!empty($arrayfields[
'c.fk_input_reason'][
'checked'])) {
2721 $form->formInputReason($_SERVER[
'PHP_SELF'], $obj->fk_input_reason,
'none', 0);
2729 if (!empty($arrayfields[
'c.module_source'][
'checked'])) {
2738 if (!empty($arrayfields[
'c.pos_source'][
'checked'])) {
2748 if (!empty($arrayfields[
'c.total_ht'][
'checked'])) {
2749 print
'<td class="nowraponall right"><span class="amount">'.price($obj->total_ht).
"</span></td>\n";
2756 if (isset($totalarray[
'val'][
'c.total_ht'])) {
2757 $totalarray[
'val'][
'c.total_ht'] += $obj->total_ht;
2759 $totalarray[
'val'][
'c.total_ht'] = $obj->total_ht;
2764 if (!empty($arrayfields[
'c.total_vat'][
'checked'])) {
2765 print
'<td class="nowrap right"><span class="amount">'.price($obj->total_tva).
"</span></td>\n";
2772 if (isset($totalarray[
'val'][
'c.total_tva'])) {
2773 $totalarray[
'val'][
'c.total_tva'] += $obj->total_tva;
2775 $totalarray[
'val'][
'c.total_tva'] = $obj->total_tva;
2780 if (!empty($arrayfields[
'c.total_ttc'][
'checked'])) {
2781 print
'<td class="nowrap right"><span class="amount">'.price($obj->total_ttc).
"</span></td>\n";
2788 if (isset($totalarray[
'val'][
'c.total_ttc'])) {
2789 $totalarray[
'val'][
'c.total_ttc'] += $obj->total_ttc;
2791 $totalarray[
'val'][
'c.total_ttc'] = $obj->total_ttc;
2796 if (!empty($arrayfields[
'c.multicurrency_code'][
'checked'])) {
2797 print
'<td class="nowrap">'.$obj->multicurrency_code.
' - '.$langs->trans(
'Currency'.$obj->multicurrency_code).
"</td>\n";
2804 if (!empty($arrayfields[
'c.multicurrency_tx'][
'checked'])) {
2805 print
'<td class="nowrap">';
2806 $form->form_multicurrency_rate($_SERVER[
'PHP_SELF'].
'?id='.$obj->rowid, $obj->multicurrency_tx,
'none', $obj->multicurrency_code);
2814 if (!empty($arrayfields[
'c.multicurrency_total_ht'][
'checked'])) {
2815 print
'<td class="right nowrap"><span class="amount">'.price($obj->multicurrency_total_ht).
"</span></td>\n";
2821 if (!empty($arrayfields[
'c.multicurrency_total_vat'][
'checked'])) {
2822 print
'<td class="right nowrap"><span class="amount">'.price($obj->multicurrency_total_vat).
"</span></td>\n";
2828 if (!empty($arrayfields[
'c.multicurrency_total_ttc'][
'checked'])) {
2829 print
'<td class="right nowrap"><span class="amount">'.price($obj->multicurrency_total_ttc).
"</span></td>\n";
2835 $userstatic->id = $obj->fk_user_author;
2836 $userstatic->login = $obj->login;
2837 $userstatic->lastname = $obj->lastname;
2838 $userstatic->firstname = $obj->firstname;
2839 $userstatic->email = $obj->user_email;
2840 $userstatic->status = $obj->user_statut;
2841 $userstatic->entity = $obj->entity;
2842 $userstatic->photo = $obj->photo;
2843 $userstatic->office_phone = $obj->office_phone;
2844 $userstatic->office_fax = $obj->office_fax;
2845 $userstatic->user_mobile = $obj->user_mobile;
2846 $userstatic->job = $obj->job;
2847 $userstatic->gender = $obj->gender;
2850 if (!empty($arrayfields[
'u.login'][
'checked'])) {
2851 print
'<td class="tdoverflowmax125">';
2852 if ($userstatic->id) {
2853 print $userstatic->getNomUrl(-1);
2864 if (!empty($arrayfields[
'sale_representative'][
'checked'])) {
2866 if ($obj->socid > 0) {
2867 $listsalesrepresentatives = $companystatic->getSalesRepresentatives($user);
2868 if ($listsalesrepresentatives < 0) {
2871 $nbofsalesrepresentative = count($listsalesrepresentatives);
2872 if ($nbofsalesrepresentative > 6) {
2874 print $nbofsalesrepresentative;
2875 } elseif ($nbofsalesrepresentative > 0) {
2877 foreach ($listsalesrepresentatives as $val) {
2878 $userstatic->id = $val[
'id'];
2879 $userstatic->lastname = $val[
'lastname'];
2880 $userstatic->firstname = $val[
'firstname'];
2881 $userstatic->email = $val[
'email'];
2882 $userstatic->status = $val[
'statut'];
2883 $userstatic->entity = $val[
'entity'];
2884 $userstatic->photo = $val[
'photo'];
2885 $userstatic->login = $val[
'login'];
2886 $userstatic->office_phone = $val[
'office_phone'];
2887 $userstatic->office_fax = $val[
'office_fax'];
2888 $userstatic->user_mobile = $val[
'user_mobile'];
2889 $userstatic->job = $val[
'job'];
2890 $userstatic->gender = $val[
'gender'];
2892 print ($nbofsalesrepresentative < 2) ? $userstatic->getNomUrl(-1,
'', 0, 0, 12) : $userstatic->getNomUrl(-2);
2894 if ($j < $nbofsalesrepresentative) {
2911 if (!empty($arrayfields[
'total_pa'][
'checked'])) {
2912 print
'<td class="right nowrap">'.price($marginInfo[
'pa_total']).
'</td>';
2919 if (!empty($arrayfields[
'total_margin'][
'checked'])) {
2920 print
'<td class="right nowrap">'.price($marginInfo[
'total_margin']).
'</td>';
2928 if (!isset($totalarray[
'val'][
'total_margin'])) {
2932 $totalarray[
'val'][
'total_margin'] += $marginInfo[
'total_margin'];
2936 if (!empty($arrayfields[
'total_margin_rate'][
'checked'])) {
2937 print
'<td class="right nowrap">'.(($marginInfo[
'total_margin_rate'] ==
'') ?
'' :
price($marginInfo[
'total_margin_rate'], 0,
'', 0, 0, 2).
'%').
'</td>';
2944 if (!empty($arrayfields[
'total_mark_rate'][
'checked'])) {
2945 print
'<td class="right nowrap">'.(($marginInfo[
'total_mark_rate'] ==
'') ?
'' :
price($marginInfo[
'total_mark_rate'], 0,
'', 0, 0, 2).
'%').
'</td>';
2952 if ($i >= $imaxinloop - 1) {
2953 if (!empty($total_ht)) {
2962 if (!empty($arrayfields[
'c.datec'][
'checked'])) {
2963 print
'<td class="center nowraponall">';
2964 print
dol_print_date($db->jdate($obj->date_creation),
'dayhour',
'tzuserrel');
2972 if (!empty($arrayfields[
'c.tms'][
'checked'])) {
2973 print
'<td class="center nowraponall">';
2974 print
dol_print_date($db->jdate($obj->date_modification),
'dayhour',
'tzuserrel');
2982 if (!empty($arrayfields[
'c.date_cloture'][
'checked'])) {
2983 print
'<td class="center nowraponall">';
2984 print
dol_print_date($db->jdate($obj->date_cloture),
'dayhour',
'tzuserrel');
2992 if (!empty($arrayfields[
'c.note_public'][
'checked'])) {
2993 print
'<td class="sensiblehtmlcontent maxwidth250imp classfortooltip" title="'.dolPrintHTMLForAttribute(
dolGetFirstLineOfText($obj->note_public, 20)).
'">';
2994 print
'<div class="small lineheightsmall twolinesmax-normallineheight">'.dolPrintHTML(
dolGetFirstLineOfText($obj->note_public, 5)).
'</div>';
3002 if (!empty($arrayfields[
'c.note_private'][
'checked'])) {
3003 print
'<td class="sensiblehtmlcontent maxwidth250imp classfortooltip" title="'.dolPrintHTMLForAttribute(
dolGetFirstLineOfText($obj->note_private, 20)).
'">';
3004 print
'<div class="small lineheightsmall twolinesmax-normallineheight">'.dolPrintHTML(
dolGetFirstLineOfText($obj->note_private, 5)).
'</div>';
3012 if (!empty($arrayfields[
'shippable'][
'checked'])) {
3013 print
'<td class="center">';
3014 if (!empty($show_shippable_command) &&
isModEnabled(
'stock')) {
3016 if (($obj->fk_statut > $generic_commande::STATUS_DRAFT) && ($obj->fk_statut < $generic_commande::STATUS_CLOSED)) {
3017 $generic_commande->getLinesArray();
3018 $generic_commande->loadExpeditions();
3022 $numlines = count($generic_commande->lines);
3023 for ($lig = 0; $lig < $numlines; $lig++) {
3024 $orderLine = $generic_commande->lines[$lig];
3025 '@phan-var-force OrderLine $orderLine';
3026 if (isset($generic_commande->expeditions[$orderLine->id])) {
3027 $reliquat = $orderLine->qty - $generic_commande->expeditions[$orderLine->id];
3029 $reliquat = $orderLine->qty;
3031 if ($orderLine->product_type == 0 && $orderLine->fk_product > 0) {
3033 $generic_product->id = $orderLine->fk_product;
3036 if (empty($productstat_cache[$orderLine->fk_product])) {
3037 $generic_product->load_stock(
'nobatch,warehouseopen');
3038 $productstat_cache[$orderLine->fk_product][
'stock_reel'] = $generic_product->stock_reel;
3039 $productstat_cachevirtual[$orderLine->fk_product][
'stock_reel'] = $generic_product->stock_theorique;
3041 $generic_product->stock_reel = $productstat_cache[$orderLine->fk_product][
'stock_reel'];
3043 $generic_product->stock_theorique = $productstat_cachevirtual[$orderLine->fk_product][
'stock_reel'];
3046 if (!array_key_exists($orderLine->fk_product, $stock)) {
3047 $stock[$orderLine->fk_product] = $generic_product->stock_reel;
3050 if ($reliquat > $stock[$orderLine->fk_product]) {
3054 $stock[$orderLine->fk_product] = $stock[$orderLine->fk_product] - $reliquat;
3056 $text_info .= $reliquat.
' x '.$orderLine->product_ref.
' '.
dol_trunc($orderLine->product_label, 20);
3057 $text_info .=
' - '.$langs->trans(
"Stock").
': <span class="'.($generic_product->stock_reel > 0 ?
'ok' :
'error').
'">'.$generic_product->stock_reel.
'</span>';
3058 $text_info .=
' - '.$langs->trans(
"VirtualStock").
': <span class="'.($generic_product->stock_theorique > 0 ?
'ok' :
'error').
'">'.$generic_product->stock_theorique.
'</span>';
3059 $text_info .= ($reliquat != $orderLine->qty ?
' <span class="opacitymedium">('.$langs->trans(
"QtyInOtherShipments").
' '.($orderLine->qty - $reliquat).
')</span>' :
'');
3060 $text_info .=
'<br>';
3067 $stock_order_supplier = 0;
3070 if (empty($productstat_cache[$orderLine->fk_product][
'stats_order_customer'])) {
3071 $generic_product->load_stats_commande(0,
'1,2');
3072 $productstat_cache[$orderLine->fk_product][
'stats_order_customer'] = $generic_product->stats_commande[
'qty'];
3075 $generic_product->stats_commande[
'qty'] = $productstat_cache[$orderLine->fk_product][
'stats_order_customer'];
3077 $stock_order = $generic_product->stats_commande[
'qty'];
3080 if (empty($productstat_cache[$orderLine->fk_product][
'stats_order_supplier'])) {
3081 $generic_product->load_stats_commande_fournisseur(0,
'3');
3082 $productstat_cache[$orderLine->fk_product][
'stats_order_supplier'] = $generic_product->stats_commande_fournisseur[
'qty'];
3085 $generic_product->stats_commande_fournisseur[
'qty'] = $productstat_cache[$orderLine->fk_product][
'stats_order_supplier'];
3087 $stock_order_supplier = $generic_product->stats_commande_fournisseur[
'qty'];
3090 $text_info .= $reliquat.
' x '.$orderLine->ref.
' '.
dol_trunc($orderLine->product_label, 20);
3091 $text_stock_reel = $generic_product->stock_reel.
'/'.$stock_order;
3092 if ($stock_order > $generic_product->stock_reel && !($generic_product->stock_reel < $orderLine->qty)) {
3094 $text_warning .=
'<span class="warning">'.$langs->trans(
'Available').
' : '.$text_stock_reel.
'</span>';
3096 if ($reliquat > $generic_product->stock_reel) {
3097 $text_info .=
'<span class="warning">'.$langs->trans(
'Available').
' : '.$text_stock_reel.
'</span>';
3099 $text_info .=
'<span class="ok">'.$langs->trans(
'Available').
' : '.$text_stock_reel.
'</span>';
3102 $text_info .=
' '.$langs->trans(
'SupplierOrder').
' : '.$stock_order_supplier;
3104 $text_info .= ($reliquat != $orderLine->qty ?
' <span class="opacitymedium">('.$langs->trans(
"QtyInOtherShipments").
' '.($orderLine->qty - $reliquat).
')</span>' :
'');
3105 $text_info .=
'<br>';
3109 if ($notshippable == 0) {
3110 $text_icon =
img_picto(
'',
'dolly',
'', 0, 0, 0,
'',
'green paddingleft');
3111 $text_info = $text_icon.
' '.$langs->trans(
'Shippable').
'<br>'.$text_info;
3113 $text_icon =
img_picto(
'',
'dolly',
'', 0, 0, 0,
'',
'error paddingleft');
3114 $text_info = $text_icon.
' '.$langs->trans(
'NonShippable').
'<br>'.$text_info;
3119 print
'<a href="'.DOL_URL_ROOT.
'/expedition/shipment.php?id='.((int) $obj->rowid).
'">';
3120 print $form->textwithtooltip(
'', $text_info, 2, 1, $text_icon,
'', 2);
3124 print $form->textwithtooltip(
'', $langs->trans(
'NotEnoughForAllOrders').
'<br>'.$text_warning, 2, 1,
img_picto(
'',
'error'),
'', 2);
3134 include DOL_DOCUMENT_ROOT.
'/core/tpl/extrafields_list_print_fields.tpl.php';
3136 $parameters = array(
'arrayfields' => $arrayfields,
'obj' => $obj,
'i' => $i,
'totalarray' => &$totalarray);
3137 $reshook = $hookmanager->executeHooks(
'printFieldListValue', $parameters, $object, $action);
3138 print $hookmanager->resPrint;
3141 if (!empty($arrayfields[
'c.facture'][
'checked'])) {
3142 print
'<td class="center">';
3144 print
yn($obj->billed, $langs->trans(
"Billed"));
3153 if (!empty($arrayfields[
'c.import_key'][
'checked'])) {
3154 print
'<td class="nowrap center">'.dol_escape_htmltag($obj->import_key).
'</td>';
3161 if (!empty($arrayfields[
'c.fk_statut'][
'checked'])) {
3162 print
'<td class="nowrap center">'.$generic_commande->LibStatut($obj->fk_statut, $obj->billed, 5, 1).
'</td>';
3170 print
'<td class="nowrap center">';
3171 if ($massactionbutton || $massaction) {
3173 if (in_array($obj->rowid, $arrayofselected)) {
3176 print
'<input id="cb'.$obj->rowid.
'" class="flat checkforselect" type="checkbox" name="toselect[]" value="'.$obj->rowid.
'"'.($selected ?
' checked="checked"' :
'').
'>';
3186 $total += $obj->total_ht;
3187 $subtotal += $obj->total_ht;
3193include DOL_DOCUMENT_ROOT.
'/core/tpl/list_print_total.tpl.php';
3198 foreach ($arrayfields as $key => $val) {
3199 if (!empty($val[
'checked'])) {
3203 print
'<tr><td colspan="'.$colspan.
'"><span class="opacitymedium">'.$langs->trans(
"NoRecordFound").
'</span></td></tr>';
3208$parameters = array(
'arrayfields' => $arrayfields,
'sql' => $sql);
3209$reshook = $hookmanager->executeHooks(
'printFieldListFooter', $parameters, $object, $action);
3210print $hookmanager->resPrint;
3212print
'</table>'.
"\n";
3215print
'</form>'.
"\n";
3217if (in_array(
'builddoc', array_keys($arrayofmassactions)) && ($nbtotalofrecords ===
'' || $nbtotalofrecords)) {
3218 $hidegeneratedfilelistifempty = 1;
3219 if ($massaction ==
'builddoc' || $action ==
'remove_file' || $show_files) {
3220 $hidegeneratedfilelistifempty = 0;
3224 $urlsource = $_SERVER[
'PHP_SELF'].
'?sortfield='.$sortfield.
'&sortorder='.$sortorder;
3225 $urlsource .= str_replace(
'&',
'&', $param);
3227 $filedir = $diroutputmassaction;
3228 $genallowed = $permissiontoread;
3229 $delallowed = $permissiontoadd;
3231 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.
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.
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...
setEventMessages($mesg, $mesgs, $style='mesgs', $messagekey='', $noduplicate=0, $attop=0)
Set event messages in dol_events session object.
print_liste_field_titre($name, $file="", $field="", $begin="", $param="", $moreattrib="", $sortfield="", $sortorder="", $prefix="", $tooltip="", $forcenowrapcolumntitle=0)
Show title line of an array.
print_barre_liste($title, $page, $file, $options='', $sortfield='', $sortorder='', $morehtmlcenter='', $num=-1, $totalnboflines='', $picto='generic', $pictoisfullpath=0, $morehtmlright='', $morecss='', $limit=-1, $selectlimitsuffix=0, $hidenavigation=0, $pagenavastextinput=0, $morehtmlrightbeforearrow='')
Print a title with navigation controls for pagination.
img_picto($titlealt, $picto, $moreatt='', $pictoisfullpath=0, $srconly=0, $notitle=0, $alt='', $morecss='', $marginleftonlyshort=2, $allowothertags=array())
Show picto whatever it's its name (generic function)
GETPOSTINT($paramname, $method=0)
Return the value of a $_GET or $_POST supervariable, converted into integer.
dolGetFirstLineOfText($text, $nboflines=1, $charset='UTF-8')
Return first line of text.
dolPrintHTML($s, $allowiframe=0)
Return a string (that can be on several lines) ready to be output on a HTML page.
price2num($amount, $rounding='', $option=0)
Function that return a number with universal decimal format (decimal separator is '.
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.
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...
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...
dolPrintLabel($s, $escapeonlyhtmltags=0)
Return a string label (so on 1 line only and that should not contains any HTML) ready to be output on...
yn($yesno, $format=1, $color=0)
Return yes or no in current language.
dolGetButtonTitleSeparator($moreClass="")
Add space between dolGetButtonTitle.
GETPOST($paramname, $check='alphanohtml', $method=0, $filter=null, $options=null, $noreplace=0)
Return value of a param into GET or POST supervariable.
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).
dol_print_error($db=null, $error='', $errors=null)
Displays error message system with all the information to facilitate the diagnosis and the escalation...
dol_trunc($string, $size=40, $trunc='right', $stringencoding='UTF-8', $nodot=0, $display=0)
Truncate a string to a particular length adding '…' if string larger than length.
getDolGlobalString($key, $default='')
Return a Dolibarr global constant string value.
isModEnabled($module)
Is Dolibarr module enabled.
dol_escape_htmltag($stringtoescape, $keepb=0, $keepn=0, $noescapetags='', $escapeonlyhtmltags=0, $cleanalsojavascript=0)
Returns text escaped for inclusion in HTML alt or title or value tags, or into values of HTML input f...
restrictedArea(User $user, $features, $object=0, $tableandshare='', $feature2='', $dbt_keyfield='fk_soc', $dbt_select='rowid', $isdraft=0, $mode=0)
Check permissions of a user to show a page and an object.