43require
'../main.inc.php';
44require_once DOL_DOCUMENT_ROOT.
'/core/lib/date.lib.php';
45require_once DOL_DOCUMENT_ROOT.
'/core/lib/company.lib.php';
46require_once DOL_DOCUMENT_ROOT.
'/core/class/discount.class.php';
47require_once DOL_DOCUMENT_ROOT.
'/core/class/html.formfile.class.php';
48require_once DOL_DOCUMENT_ROOT.
'/core/class/html.formother.class.php';
49require_once DOL_DOCUMENT_ROOT.
'/core/class/html.formcompany.class.php';
50if (isModEnabled(
'margin')) {
51 require_once DOL_DOCUMENT_ROOT.
'/core/class/html.formmargin.class.php';
53require_once DOL_DOCUMENT_ROOT.
'/commande/class/commande.class.php';
54require_once DOL_DOCUMENT_ROOT.
'/compta/facture/class/facture.class.php';
55require_once DOL_DOCUMENT_ROOT.
'/product/class/product.class.php';
56require_once DOL_DOCUMENT_ROOT.
'/projet/class/project.class.php';
58if (isModEnabled(
'category')) {
59 require_once DOL_DOCUMENT_ROOT.
'/categories/class/categorie.class.php';
60 require_once DOL_DOCUMENT_ROOT.
'/core/class/html.formcategory.class.php';
72$langs->loadLangs(array(
'orders',
'sendings',
'deliveries',
'companies',
'compta',
'bills',
'stocks',
'products'));
75$action =
GETPOST(
'action',
'aZ09');
76$massaction =
GETPOST(
'massaction',
'alpha');
78$confirm =
GETPOST(
'confirm',
'alpha');
79$toselect =
GETPOST(
'toselect',
'array');
80$contextpage =
GETPOST(
'contextpage',
'aZ') ?
GETPOST(
'contextpage',
'aZ') :
'orderlist';
81$optioncss =
GETPOST(
'optioncss',
'alpha');
85 $userschilds = $user->getAllChildIds();
87 $userschilds = array();
91$search_datecloture_start =
GETPOSTINT(
'search_datecloture_start');
92if (empty($search_datecloture_start)) {
95$search_datecloture_end =
GETPOSTINT(
'search_datecloture_end');
96if (empty($search_datecloture_end)) {
106$search_all = trim(
GETPOST(
'search_all',
'alphanohtml'));
107$searchCategoryOrderOperator = 0;
108if (GETPOSTISSET(
'formfilteraction')) {
109 $searchCategoryOrderOperator =
GETPOSTINT(
'search_category_order_operator');
113$searchCategoryOrderList =
GETPOST(
'search_category_order_list',
'array');
114$search_product_category =
GETPOST(
'search_product_category',
'intcomma');
115$search_id =
GETPOST(
'search_id',
'int');
116$search_ref =
GETPOST(
'search_ref',
'alpha') !=
'' ?
GETPOST(
'search_ref',
'alpha') :
GETPOST(
'sref',
'alpha');
117$search_ref_ext =
GETPOST(
'search_ref_ext',
'alpha');
118$search_ref_customer =
GETPOST(
'search_ref_customer',
'alpha');
119$search_company =
GETPOST(
'search_company',
'alpha');
120$search_company_alias =
GETPOST(
'search_company_alias',
'alpha');
121$search_parent_name = trim(
GETPOST(
'search_parent_name',
'alphanohtml'));
122$search_town =
GETPOST(
'search_town',
'alpha');
123$search_zip =
GETPOST(
'search_zip',
'alpha');
124$search_state =
GETPOST(
'search_state',
'alpha');
125$search_country =
GETPOST(
'search_country',
'aZ09');
126$search_type_thirdparty =
GETPOST(
'search_type_thirdparty',
'intcomma');
127$search_user =
GETPOST(
'search_user',
'intcomma');
128$search_sale =
GETPOST(
'search_sale',
'intcomma');
129$search_total_ht =
GETPOST(
'search_total_ht',
'alpha');
130$search_total_vat =
GETPOST(
'search_total_vat',
'alpha');
131$search_total_ttc =
GETPOST(
'search_total_ttc',
'alpha');
132$search_warehouse =
GETPOST(
'search_warehouse',
'intcomma');
133$search_note_public =
GETPOST(
'search_note_public',
'alphanohtml');
134$search_note_private =
GETPOST(
'search_note_private',
'alphanohtml');
136$search_module_source =
GETPOST(
'search_module_source',
'alphanohtml');
137$search_pos_source =
GETPOST(
'search_pos_source',
'alphanohtml');
139$search_multicurrency_code =
GETPOST(
'search_multicurrency_code',
'alpha');
140$search_multicurrency_tx =
GETPOST(
'search_multicurrency_tx',
'alpha');
141$search_multicurrency_montant_ht =
GETPOST(
'search_multicurrency_montant_ht',
'alpha');
142$search_multicurrency_montant_vat =
GETPOST(
'search_multicurrency_montant_vat',
'alpha');
143$search_multicurrency_montant_ttc =
GETPOST(
'search_multicurrency_montant_ttc',
'alpha');
145$search_login =
GETPOST(
'search_login',
'alpha');
146$search_categ_cus =
GETPOST(
"search_categ_cus",
'intcomma');
147$search_billed =
GETPOST(
'search_billed',
'intcomma');
148$search_status =
GETPOST(
'search_status',
'intcomma');
149$search_project_ref =
GETPOST(
'search_project_ref',
'alpha');
150$search_project =
GETPOST(
'search_project',
'alpha');
151$search_shippable =
GETPOST(
'search_shippable',
'aZ09');
153$search_fk_cond_reglement =
GETPOST(
'search_fk_cond_reglement',
'intcomma');
154$search_fk_shipping_method =
GETPOST(
'search_fk_shipping_method',
'intcomma');
155$search_fk_mode_reglement =
GETPOST(
'search_fk_mode_reglement',
'intcomma');
156$search_fk_input_reason =
GETPOST(
'search_fk_input_reason',
'intcomma');
158$search_option =
GETPOST(
'search_option',
'alpha');
159if ($search_option ==
'late') {
160 $search_status =
'-2';
162$search_orderday =
'';
163$search_ordermonth =
'';
164$search_orderyear =
'';
165$search_deliveryday =
'';
166$search_deliverymonth =
'';
167$search_deliveryyear =
'';
169$search_import_key = trim(
GETPOST(
"search_import_key",
"alpha"));
171$diroutputmassaction =
$conf->order->multidir_output[
$conf->entity].
'/temp/massgeneration/'.$user->id;
175$sortfield =
GETPOST(
'sortfield',
'aZ09comma');
176$sortorder =
GETPOST(
'sortorder',
'aZ09comma');
178if (empty($page) || $page < 0 ||
GETPOST(
'button_search',
'alpha') ||
GETPOST(
'button_removefilter',
'alpha')) {
182$offset = $limit * $page;
183$pageprev = $page - 1;
184$pagenext = $page + 1;
186 $sortfield =
'c.ref';
192$show_shippable_command =
GETPOST(
'show_shippable_command',
'aZ09');
196$hookmanager->initHooks(array(
'orderlist'));
200$extrafields->fetch_name_optionals_label(
$object->table_element);
201$search_array_options = $extrafields->getOptionalsFromPost(
$object->table_element,
'',
'search_');
204$fieldstosearchall = array(
206 'c.ref_client' =>
'RefCustomerOrder',
207 'pd.description' =>
'Description',
208 's.nom' =>
"ThirdParty",
209 's.name_alias' =>
"AliasNameShort",
212 'c.note_public' =>
'NotePublic',
214if (empty($user->socid)) {
215 $fieldstosearchall[
"c.note_private"] =
"NotePrivate";
219$showpos = (isModEnabled(
'cashdesk') || isModEnabled(
'takepos') ||
getDolGlobalInt(
'ORDER_SHOW_POS')) ?
'1' :
'0';
221$checkedtypetiers =
'0';
223 'c.rowid' => array(
'label' =>
"ID",
'checked' =>
'1',
'enabled' => (
string)
getDolGlobalInt(
'MAIN_SHOW_TECHNICAL_ID'),
'position' => 1),
224 'c.ref' => array(
'label' =>
"Ref",
'checked' =>
'1',
'position' => 5,
'searchall' => 1),
225 'c.ref_ext' => array(
'label' =>
"RefExt",
'checked' =>
'1',
'position' => 5,
'visible' => 0,
'searchall' => 1),
226 'c.ref_client' => array(
'label' =>
"RefCustomerOrder",
'checked' =>
'-1',
'position' => 10,
'searchall' => 1),
227 'p.ref' => array(
'label' =>
"ProjectRef",
'langfile' =>
'projects',
'checked' =>
'-1',
'enabled' => (!isModEnabled(
'project') ?
'0' :
'1'),
'position' => 20),
228 'p.title' => array(
'label' =>
"ProjectLabel",
'langfile' =>
'projects',
'checked' =>
'0',
'enabled' => (!isModEnabled(
'project') ?
'0' :
'1'),
'position' => 25),
229 's.nom' => array(
'label' =>
"ThirdParty",
'checked' =>
'1',
'position' => 30,
'searchall' => 1),
230 's.name_alias' => array(
'label' =>
"AliasNameShort",
'checked' =>
'-1',
'position' => 31,
'searchall' => 1),
231 's2.nom' => array(
'label' =>
'ParentCompany',
'position' => 32,
'checked' =>
'0'),
232 's.town' => array(
'label' =>
"Town",
'checked' =>
'-1',
'position' => 35,
'searchall' => 1),
233 's.zip' => array(
'label' =>
"Zip",
'checked' =>
'-1',
'position' => 40,
'searchall' => 1),
234 'state.nom' => array(
'label' =>
"StateShort",
'checked' =>
'0',
'position' => 45),
235 'country.code_iso' => array(
'label' =>
"Country",
'checked' =>
'0',
'position' => 50),
236 'typent.code' => array(
'label' =>
"ThirdPartyType",
'checked' => (string) $checkedtypetiers,
'position' => 55),
237 'c.date_commande' => array(
'label' =>
"OrderDateShort",
'checked' =>
'1',
'position' => 60,
'csslist' =>
'nowraponall'),
238 'c.delivery_date' => array(
'label' =>
"DateDeliveryPlanned",
'checked' =>
'1',
'enabled' => (string) (int) !
getDolGlobalString(
'ORDER_DISABLE_DELIVERY_DATE'),
'position' => 65,
'csslist' =>
'nowraponall'),
239 'c.fk_shipping_method' => array(
'label' =>
"SendingMethod",
'checked' =>
'-1',
'position' => 66 ,
'enabled' => (string) (int) isModEnabled(
"shipping")),
240 'c.fk_cond_reglement' => array(
'label' =>
"PaymentConditionsShort",
'checked' =>
'-1',
'position' => 67),
241 'c.fk_mode_reglement' => array(
'label' =>
"PaymentMode",
'checked' =>
'-1',
'position' => 68),
242 'c.fk_input_reason' => array(
'label' =>
"Origin",
'checked' =>
'-1',
'position' => 69),
243 'c.module_source' => array(
'label' =>
"POSModule",
'langfile' =>
'cashdesk',
'checked' => ($contextpage ==
'poslist' ?
'1' :
'0'),
'enabled' => $showpos,
'position' => 90),
244 'c.pos_source' => array(
'label' =>
"POSTerminal",
'langfile' =>
'cashdesk',
'checked' => ($contextpage ==
'poslist' ?
'1' :
'0'),
'enabled' => $showpos,
'position' => 91),
245 'c.total_ht' => array(
'label' =>
"AmountHT",
'checked' =>
'1',
'position' => 75),
246 'c.total_vat' => array(
'label' =>
"AmountVAT",
'checked' =>
'0',
'position' => 80),
247 'c.total_ttc' => array(
'label' =>
"AmountTTC",
'checked' =>
'0',
'position' => 85),
248 'c.multicurrency_code' => array(
'label' =>
'Currency',
'checked' =>
'0',
'enabled' => (!isModEnabled(
"multicurrency") ?
'0' :
'1'),
'position' => 92),
249 'c.multicurrency_tx' => array(
'label' =>
'CurrencyRate',
'checked' =>
'0',
'enabled' => (!isModEnabled(
"multicurrency") ?
'0' :
'1'),
'position' => 95),
250 'c.multicurrency_total_ht' => array(
'label' =>
'MulticurrencyAmountHT',
'checked' =>
'0',
'enabled' => (!isModEnabled(
"multicurrency") ?
'0' :
'1'),
'position' => 100),
251 'c.multicurrency_total_vat' => array(
'label' =>
'MulticurrencyAmountVAT',
'checked' =>
'0',
'enabled' => (!isModEnabled(
"multicurrency") ?
'0' :
'1'),
'position' => 105),
252 'c.multicurrency_total_ttc' => array(
'label' =>
'MulticurrencyAmountTTC',
'checked' =>
'0',
'enabled' => (!isModEnabled(
"multicurrency") ?
'0' :
'1'),
'position' => 110),
253 'u.login' => array(
'label' =>
"Author",
'checked' =>
'-1',
'position' => 115),
254 'sale_representative' => array(
'label' =>
"SaleRepresentativesOfThirdParty",
'checked' =>
'0',
'position' => 116),
255 '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)),
256 'total_margin' => array(
'label' =>
'Margin',
'checked' =>
'0',
'position' => 301,
'enabled' => (string) (int) (!isModEnabled(
'margin') || !$user->hasRight(
"margins",
"liretous") ? 0 : 1)),
257 '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)),
258 '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)),
259 'c.datec' => array(
'label' =>
"DateCreation",
'checked' =>
'0',
'position' => 120),
260 'c.tms' => array(
'label' =>
"DateModificationShort",
'checked' =>
'0',
'position' => 125),
261 'c.date_cloture' => array(
'label' =>
"DateClosing",
'checked' =>
'0',
'position' => 130),
262 'c.note_public' => array(
'label' =>
'NotePublic',
'checked' =>
'0',
'enabled' => (string) (int) (!
getDolGlobalInt(
'MAIN_LIST_HIDE_PUBLIC_NOTES')),
'position' => 135,
'searchall' => 1),
263 'c.note_private' => array(
'label' =>
'NotePrivate',
'checked' =>
'0',
'enabled' => (string) (int) (!
getDolGlobalInt(
'MAIN_LIST_HIDE_PRIVATE_NOTES')),
'position' => 140),
264 'shippable' => array(
'label' =>
"Shippable",
'checked' =>
'1',
'enabled' => (string) (int) (isModEnabled(
"shipping")),
'position' => 990),
265 'c.facture' => array(
'label' =>
"Billed",
'checked' =>
'1',
'enabled' => (string) (int) (!
getDolGlobalString(
'WORKFLOW_BILL_ON_SHIPMENT')),
'position' => 995),
266 'c.import_key' => array(
'type' =>
'varchar(14)',
'label' =>
'ImportId',
'enabled' =>
'1',
'visible' => -2,
'position' => 999),
267 'c.fk_statut' => array(
'label' =>
"Status",
'checked' =>
'1',
'position' => 1000)
270 unset($arrayfields[
'c.note_private']);
272$parameters = array(
'fieldstosearchall' => $fieldstosearchall);
273$reshook = $hookmanager->executeHooks(
'completeFieldsToSearchAll', $parameters, $object, $action);
275 $fieldstosearchall = empty($hookmanager->resArray[
'fieldstosearchall']) ? array() : $hookmanager->resArray[
'fieldstosearchall'];
276} elseif ($reshook == 0) {
277 $fieldstosearchall = array_merge($fieldstosearchall, empty($hookmanager->resArray[
'fieldstosearchall']) ? array() : $hookmanager->resArray[
'fieldstosearchall']);
281include DOL_DOCUMENT_ROOT.
'/core/tpl/extrafields_list_array_fields.tpl.php';
291 $socid = $user->socid;
294$permissiontoreadallthirdparty = $user->hasRight(
'societe',
'client',
'voir');
295$permissiontoread =
false;
296$permissiontovalidate =
false;
297$permissiontoclose =
false;
298$permissiontocancel =
false;
299$permissiontosendbymail =
false;
312if (
GETPOST(
'cancel',
'alpha')) {
316if (!
GETPOST(
'confirmmassaction',
'alpha') && $massaction !=
'presend' && $massaction !=
'confirm_presend' && $massaction !=
'confirm_createbills') {
320$parameters = array(
'socid' => $socid,
'arrayfields' => &$arrayfields);
321$reshook = $hookmanager->executeHooks(
'doActions', $parameters, $object, $action);
326if (empty($reshook)) {
328 include DOL_DOCUMENT_ROOT.
'/core/actions_changeselectedfields.inc.php';
331 if (
GETPOST(
'button_removefilter_x',
'alpha') ||
GETPOST(
'button_removefilter.x',
'alpha') ||
GETPOST(
'button_removefilter',
'alpha')) {
334 $search_product_category =
'';
335 $searchCategoryOrderList = array();
338 $search_ref_ext =
'';
339 $search_ref_customer =
'';
340 $search_company =
'';
341 $search_company_alias =
'';
342 $search_parent_name =
'';
343 $search_module_source =
'';
344 $search_pos_source =
'';
349 $search_country =
'';
350 $search_type_thirdparty =
'';
351 $search_total_ht =
'';
352 $search_total_vat =
'';
353 $search_total_ttc =
'';
354 $search_warehouse =
'';
355 $search_note_public =
'';
356 $search_note_private =
'';
357 $search_multicurrency_code =
'';
358 $search_multicurrency_tx =
'';
359 $search_multicurrency_montant_ht =
'';
360 $search_multicurrency_montant_vat =
'';
361 $search_multicurrency_montant_ttc =
'';
363 $search_dateorder_start =
'';
364 $search_dateorder_end =
'';
365 $search_datedelivery_start =
'';
366 $search_datedelivery_end =
'';
367 $search_project_ref =
'';
368 $search_project =
'';
371 $search_datecloture_start =
'';
372 $search_datecloture_end =
'';
373 $search_fk_cond_reglement =
'';
374 $search_fk_shipping_method =
'';
375 $search_fk_mode_reglement =
'';
376 $search_fk_input_reason =
'';
378 $search_import_key =
'';
379 $search_categ_cus = 0;
383 $search_array_options = array();
385 if (
GETPOST(
'button_removefilter_x',
'alpha') ||
GETPOST(
'button_removefilter.x',
'alpha') ||
GETPOST(
'button_removefilter',
'alpha')
386 ||
GETPOST(
'button_search_x',
'alpha') ||
GETPOST(
'button_search.x',
'alpha') ||
GETPOST(
'button_search',
'alpha')) {
391 $objectclass =
'Commande';
392 $objectlabel =
'Orders';
393 $permissiontoread = $user->hasRight(
"commande",
"lire");
394 $permissiontoadd = $user->hasRight(
"commande",
"creer");
395 $permissiontodelete = $user->hasRight(
"commande",
"supprimer");
397 $permissiontovalidate = $user->hasRight(
"commande",
"order_advance",
"validate");
398 $permissiontoclose = $user->hasRight(
"commande",
"order_advance",
"close");
399 $permissiontocancel = $user->hasRight(
"commande",
"order_advance",
"annuler");
400 $permissiontosendbymail = $user->hasRight(
"commande",
"order_advance",
"send");
402 $permissiontovalidate = $user->hasRight(
"commande",
"creer");
403 $permissiontoclose = $user->hasRight(
"commande",
"creer");
404 $permissiontocancel = $user->hasRight(
"commande",
"creer");
405 $permissiontosendbymail = $user->hasRight(
"commande",
"creer");
407 $uploaddir =
$conf->order->multidir_output[
$conf->entity];
408 $triggersendname =
'ORDER_SENTBYMAIL';
411 include DOL_DOCUMENT_ROOT.
'/core/actions_massactions.inc.php';
413 if ($massaction ==
'confirm_createbills') {
414 $orders =
GETPOST(
'toselect',
'array');
415 $createbills_onebythird =
GETPOSTINT(
'createbills_onebythird');
416 $validate_invoices =
GETPOSTINT(
'validate_invoices');
421 $TFactThird = array();
422 $TFactThirdNbLines = array();
424 $nb_bills_created = 0;
430 $nbOrders = is_array($orders) ? count($orders) : 1;
433 foreach ($orders as $id_order) {
435 if ($cmd->fetch($id_order) <= 0) {
438 $cmd->fetch_thirdparty();
441 if (!empty($createbills_onebythird) && !empty($TFactThird[$cmd->socid])) {
444 $objecttmp = $TFactThird[$cmd->socid];
447 $objecttmp->socid = $cmd->socid;
448 $objecttmp->thirdparty = $cmd->thirdparty;
450 $objecttmp->type = $objecttmp::TYPE_STANDARD;
451 $objecttmp->cond_reglement_id = !empty($cmd->cond_reglement_id) ? $cmd->cond_reglement_id : $cmd->thirdparty->cond_reglement_id;
452 $objecttmp->mode_reglement_id = !empty($cmd->mode_reglement_id) ? $cmd->mode_reglement_id : $cmd->thirdparty->mode_reglement_id;
453 $objecttmp->demand_reason_id = !empty($cmd->demand_reason_id) ? $cmd->demand_reason_id : $cmd->thirdparty->demand_reason_id;
455 $objecttmp->fk_project = $cmd->fk_project;
456 $objecttmp->multicurrency_code = $cmd->multicurrency_code;
457 if (empty($createbills_onebythird)) {
458 $objecttmp->ref_client = $cmd->ref_client;
461 if (empty($objecttmp->note_public) &&
getDolGlobalInt(
"MAXREFONDOC", 10)>0) {
462 $objecttmp->note_public = $langs->transnoentities(
"Orders");
466 if (empty($datefacture)) {
470 $objecttmp->date = $datefacture;
471 $objecttmp->origin =
'commande';
472 $objecttmp->origin_id = $id_order;
474 $objecttmp->array_options = $cmd->array_options;
476 $res = $objecttmp->create($user);
479 $objecttmp->user_creation_id = $user->id;
482 $lastref = $objecttmp->ref;
483 $lastid = $objecttmp->id;
485 $TFactThird[$cmd->socid] = $objecttmp;
486 $TFactThirdNbLines[$cmd->socid] = 0;
488 $langs->load(
"errors");
489 $errors[] = $cmd->ref.
' : '.$langs->trans($objecttmp->errors[0]);
494 if ($objecttmp->id > 0) {
495 $res = $objecttmp->add_object_linked($objecttmp->origin, $id_order);
498 $errors[] = $cmd->ref.
' : '.$langs->trans($objecttmp->errors[0]);
503 $lines = $cmd->lines;
504 if (empty($lines) && method_exists($cmd,
'fetch_lines')) {
506 $lines = $cmd->lines;
510 $num = count($lines);
511 $array_options = array();
513 for ($i = 0; $i < $num; $i++) {
514 $desc = ($lines[$i]->desc ? $lines[$i]->desc :
'');
516 if (!empty($createbills_onebythird)) {
520 if ($lines[$i]->subprice < 0 && !
getDolGlobalString(
'INVOICE_KEEP_DISCOUNT_LINES_AS_IN_ORIGIN')) {
523 $discount->fk_soc = $objecttmp->socid;
524 $discount->socid = $objecttmp->socid;
525 $discount->amount_ht = abs($lines[$i]->total_ht);
526 $discount->amount_tva = abs($lines[$i]->total_tva);
527 $discount->amount_ttc = abs($lines[$i]->total_ttc);
528 $discount->tva_tx = $lines[$i]->tva_tx;
529 $discount->fk_user = $user->id;
530 $discount->description = $desc;
531 $discountid = $discount->create($user);
532 if ($discountid > 0) {
533 $result = $objecttmp->insert_discount($discountid);
542 $product_type = ($lines[$i]->product_type ? $lines[$i]->product_type : 0);
545 if ($lines[$i]->date_debut_prevue) {
546 $date_start = $lines[$i]->date_debut_prevue;
548 if ($lines[$i]->date_debut_reel) {
549 $date_start = $lines[$i]->date_debut_reel;
551 if ($lines[$i]->date_start) {
552 $date_start = $lines[$i]->date_start;
556 if ($lines[$i]->date_fin_prevue) {
557 $date_end = $lines[$i]->date_fin_prevue;
559 if ($lines[$i]->date_fin_reel) {
560 $date_end = $lines[$i]->date_fin_reel;
562 if ($lines[$i]->date_end) {
563 $date_end = $lines[$i]->date_end;
566 if (($lines[$i]->product_type != 9 && empty($lines[$i]->fk_parent_line)) || $lines[$i]->product_type == 9) {
571 if (method_exists($lines[$i],
'fetch_optionals')) {
572 $lines[$i]->fetch_optionals();
573 $array_options = $lines[$i]->array_options;
576 $objecttmp->context[
'createfromclone'] =
'createfromclone';
578 $rang = ($nbOrders > 1) ? -1 : $lines[$i]->rang;
580 if (!empty($createbills_onebythird)) {
581 $TFactThirdNbLines[$cmd->socid]++;
582 $rang = $TFactThirdNbLines[$cmd->socid];
585 $result = $objecttmp->addline(
587 $lines[$i]->subprice,
590 $lines[$i]->localtax1_tx,
591 $lines[$i]->localtax2_tx,
592 $lines[$i]->fk_product,
593 $lines[$i]->remise_percent,
597 $lines[$i]->info_bits,
598 $lines[$i]->fk_remise_except,
603 $lines[$i]->special_code,
607 $lines[$i]->fk_fournprice,
616 if (!empty($lines[$i]->extraparams)) {
618 $factureLine->id = $result;
619 $factureLine->extraparams = $lines[$i]->extraparams;
620 $factureLine->setExtraParameters();
627 $errors[] = $objecttmp->error;
631 if ($result > 0 && $lines[$i]->product_type == 9) {
632 $fk_parent_line = $result;
640 $objecttmp->note_public =
dol_concatdesc($objecttmp->note_public, $langs->transnoentities($cmd->ref).(empty($cmd->ref_client) ?
'' :
' ('.$cmd->ref_client.
')'));
641 $objecttmp->update($user);
646 if (!empty($createbills_onebythird) && empty($TFactThird[$cmd->socid])) {
647 $TFactThird[$cmd->socid] = $objecttmp;
649 $TFact[$objecttmp->id] = $objecttmp;
654 $TAllFact = empty($createbills_onebythird) ? $TFact : $TFactThird;
657 if (!$error && $validate_invoices) {
658 $massaction = $action =
'builddoc';
660 foreach ($TAllFact as &$objecttmp) {
661 $result = $objecttmp->validate($user);
668 $id = $objecttmp->id;
672 $upload_dir =
$conf->facture->dir_output;
673 $permissiontoadd = $user->hasRight(
'facture',
'creer');
678 include DOL_DOCUMENT_ROOT.
'/core/actions_builddoc.inc.php';
682 $massaction = $action =
'confirm_createbills';
688 if ($nb_bills_created == 1) {
689 if (
getDolGlobalInt(
'MAIN_MASSACTION_CREATEBILLS_REDIRECT_IF_ONE') == 1) {
691 header(
'Location: '.DOL_URL_ROOT.
'/compta/facture/card.php?id='.urlencode((
string) $lastid));
694 $texttoshow = $langs->trans(
'BillXCreated',
'{s1}');
695 $texttoshow = str_replace(
'{s1}',
'<a href="'.DOL_URL_ROOT.
'/compta/facture/card.php?id='.urlencode((
string) ($lastid)).
'">'.$lastref.
'</a>', $texttoshow);
698 if (
getDolGlobalInt(
'MAIN_MASSACTION_CREATEBILLS_REDIRECT_IF_MANY') == 1) {
700 header(
"Location: ".DOL_URL_ROOT.
'/compta/facture/list.php?mainmenu=billing&leftmenu=customers_bills');
703 setEventMessages($langs->trans(
'BillCreated', $nb_bills_created),
null,
'mesgs');
709 $param .=
'&mode='.urlencode($mode);
711 if (!empty($contextpage) && $contextpage != $_SERVER[
"PHP_SELF"]) {
712 $param .=
'&contextpage='.urlencode($contextpage);
714 if ($limit > 0 && $limit !=
$conf->liste_limit) {
715 $param .=
'&limit='.((int) $limit);
717 if ($optioncss !=
'') {
718 $param .=
'&optioncss='.urlencode($optioncss);
721 $param .=
'&search_all='.urlencode($search_all);
724 $param .=
'&show_files='.urlencode((
string) ($show_files));
727 $param .=
'&socid='.urlencode((
string) ($socid));
729 if ($search_status !=
'') {
730 $param .=
'&search_status='.urlencode($search_status);
732 if ($search_option) {
733 $param .=
"&search_option=".urlencode($search_option);
735 if ($search_orderday) {
736 $param .=
'&search_orderday='.urlencode($search_orderday);
738 if ($search_ordermonth) {
739 $param .=
'&search_ordermonth='.urlencode($search_ordermonth);
741 if ($search_orderyear) {
742 $param .=
'&search_orderyear='.urlencode($search_orderyear);
744 if ($search_deliveryday) {
745 $param .=
'&search_deliveryday='.urlencode($search_deliveryday);
747 if ($search_deliverymonth) {
748 $param .=
'&search_deliverymonth='.urlencode($search_deliverymonth);
750 if ($search_deliveryyear) {
751 $param .=
'&search_deliveryyear='.urlencode($search_deliveryyear);
754 $param .=
'&search_id='.urlencode((
string) $search_id);
757 $param .=
'&search_ref='.urlencode($search_ref);
759 if ($search_ref_ext) {
760 $param .=
'&search_ref_ext='.urlencode($search_ref_ext);
762 if ($search_company) {
763 $param .=
'&search_company='.urlencode($search_company);
765 if ($search_ref_customer) {
766 $param .=
'&search_ref_customer='.urlencode($search_ref_customer);
768 if ($search_user > 0) {
769 $param .=
'&search_user='.urlencode((
string) ($search_user));
771 if ($search_sale > 0) {
772 $param .=
'&search_sale='.urlencode((
string) ($search_sale));
774 if ($search_total_ht !=
'') {
775 $param .=
'&search_total_ht='.urlencode($search_total_ht);
777 if ($search_total_vat !=
'') {
778 $param .=
'&search_total_vat='.urlencode($search_total_vat);
780 if ($search_total_ttc !=
'') {
781 $param .=
'&search_total_ttc='.urlencode($search_total_ttc);
783 if ($search_project_ref >= 0) {
784 $param .=
"&search_project_ref=".urlencode($search_project_ref);
786 if ($search_project !=
'') {
787 $param .=
"&search_project=".urlencode($search_project);
789 if ($search_billed !=
'') {
790 $param .=
'&search_billed='.urlencode($search_billed);
793 header(
"Location: ".$_SERVER[
'PHP_SELF'].
'?'.$param);
799 $_GET[
"origin"] = $_POST[
"origin"];
800 $_GET[
"originid"] = $_POST[
"originid"];
801 if (!empty($errors)) {
811if ($action ==
'validate' && $permissiontoadd && $objectclass !==
null) {
812 if (
GETPOST(
'confirm') ==
'yes') {
814 $objecttmp =
new $objectclass($db);
817 foreach ($toselect as $checked) {
818 if ($objecttmp->fetch($checked)) {
819 if ($objecttmp->status == $objecttmp::STATUS_DRAFT) {
820 if (!empty($objecttmp->fk_warehouse)) {
821 $idwarehouse = $objecttmp->fk_warehouse;
825 if ($objecttmp->valid($user, $idwarehouse) > 0) {
826 setEventMessages($langs->trans(
'hasBeenValidated', $objecttmp->ref),
null,
'mesgs');
832 $langs->load(
"errors");
833 setEventMessages($langs->trans(
'ErrorIsNotADraft', $objecttmp->ref),
null,
'errors');
848if ($action ==
'shipped' && $permissiontoadd && $objectclass !==
null) {
849 if (
GETPOST(
'confirm') ==
'yes') {
851 $objecttmp =
new $objectclass($db);
854 foreach ($toselect as $checked) {
855 if ($objecttmp->fetch($checked)) {
856 if ($objecttmp->status == $objecttmp::STATUS_VALIDATED || $objecttmp->status == $objecttmp::STATUS_SHIPMENTONPROCESS || $objecttmp->status == $objecttmp::STATUS_CLOSED) {
857 $result = $objecttmp->cloture($user);
859 setEventMessages($langs->trans(
'StatusOrderDelivered', $objecttmp->ref),
null,
'mesgs');
860 } elseif ($result < 0) {
861 setEventMessages($langs->trans(
'ErrorOrderStatusCantBeSetToDelivered'),
null,
'errors');
865 $langs->load(
"errors");
866 setEventMessages($langs->trans(
'ErrorObjectHasWrongStatus', $objecttmp->ref),
null,
'errors');
883if (!$error && $massaction ===
'setbilled' && $permissiontoclose && $objectclass !==
null) {
886 $objecttmp =
new $objectclass($db);
888 foreach ($toselect as $toselectid) {
889 $result = $objecttmp->fetch($toselectid);
891 $result = $objecttmp->classifyBilled($user, 0);
919$form =
new Form($db);
923if (isModEnabled(
'margin')) {
926$companystatic =
new Societe($db);
927$company_url_list = array();
929$projectstatic =
new Project($db);
933$varpage = empty($contextpage) ? $_SERVER[
"PHP_SELF"] : $contextpage;
934$selectedfields = $form->multiSelectArrayWithCheckbox(
'selectedfields', $arrayfields, $varpage);
936$title = $langs->trans(
"Orders");
937$help_url =
"EN:Module_Customers_Orders|FR:Module_Commandes_Clients|ES:Módulo_Pedidos_de_clientes";
943 $sql =
'SELECT DISTINCT';
945$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,';
946$sql .=
" s.parent as fk_parent,";
947$sql .=
" s2.nom as name2,";
948$sql .=
" typent.code as typent_code,";
949$sql .=
" state.code_departement as state_code, state.nom as state_name,";
950$sql .=
" country.code as country_code,";
951$sql .=
' c.rowid, c.ref, c.ref_ext, c.total_ht, c.total_tva, c.total_ttc, c.ref_client, c.fk_user_author,';
952$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,';
953$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,';
954$sql .=
' c.date_creation as date_creation, c.tms as date_modification, c.date_cloture as date_cloture,';
955$sql .=
' c.fk_cond_reglement,c.deposit_percent,c.fk_mode_reglement,c.fk_shipping_method,';
956$sql .=
' c.fk_input_reason, c.import_key,';
957$sql .=
" c.module_source, c.pos_source,";
958$sql .=
' p.rowid as project_id, p.ref as project_ref, p.title as project_label,';
959$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';
962if (!empty($extrafields->attributes[
$object->table_element][
'label'])) {
963 foreach ($extrafields->attributes[
$object->table_element][
'label'] as $key => $val) {
964 $sql .= ($extrafields->attributes[
$object->table_element][
'type'][$key] !=
'separate' ?
", ef.".$key.
" as options_".$key :
'');
969$parameters = array();
970$reshook = $hookmanager->executeHooks(
'printFieldListSelect', $parameters, $object, $action);
971$sql .= $hookmanager->resPrint;
972$sql = preg_replace(
'/,\s*$/',
'', $sql);
976$sql .=
' FROM '.MAIN_DB_PREFIX.
'societe as s';
977$sql .=
" LEFT JOIN ".MAIN_DB_PREFIX.
"societe as s2 ON s2.rowid = s.parent";
978$sql .=
" LEFT JOIN ".MAIN_DB_PREFIX.
"c_country as country on (country.rowid = s.fk_pays)";
979$sql .=
" LEFT JOIN ".MAIN_DB_PREFIX.
"c_typent as typent on (typent.id = s.fk_typent)";
980$sql .=
" LEFT JOIN ".MAIN_DB_PREFIX.
"c_departements as state on (state.rowid = s.fk_departement)";
981$sql .=
', '.MAIN_DB_PREFIX.
'commande as c';
982if (!empty($extrafields->attributes[
$object->table_element][
'label']) && is_array($extrafields->attributes[
$object->table_element][
'label']) && count($extrafields->attributes[
$object->table_element][
'label'])) {
983 $sql .=
" LEFT JOIN ".MAIN_DB_PREFIX.
"commande_extrafields as ef on (c.rowid = ef.fk_object)";
986 $sql .=
' LEFT JOIN '.MAIN_DB_PREFIX.
'commandedet as pd ON c.rowid = pd.fk_commande';
988$sql .=
" LEFT JOIN ".MAIN_DB_PREFIX.
"projet as p ON p.rowid = c.fk_projet";
989$sql .=
' LEFT JOIN '.MAIN_DB_PREFIX.
'user as u ON c.fk_user_author = u.rowid';
991$parameters = array();
992$reshook = $hookmanager->executeHooks(
'printFieldListFrom', $parameters, $object, $action);
993$sql .= $hookmanager->resPrint;
995$sql .=
' WHERE c.fk_soc = s.rowid';
996$sql .=
' AND c.entity IN ('.getEntity(
'commande').
')';
998 $sql .=
' AND s.rowid = '.((int) $socid);
1001if (empty($user->socid) && !$permissiontoreadallthirdparty) {
1002 $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).
")";
1004 $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)).
"))";
1009if ($search_id > 0) {
1015if ($search_ref_ext) {
1018if ($search_ref_customer) {
1021if ($search_billed !=
'' && $search_billed >= 0) {
1022 $sql .=
' AND c.facture = '.((int) $search_billed);
1024if ($search_status !=
'') {
1025 if ($search_status <= 3 && $search_status >= -1) {
1026 if ($search_status == 1 && !isModEnabled(
'shipping')) {
1027 $sql .=
' AND c.fk_statut IN (1,2)';
1029 $sql .=
' AND c.fk_statut = '.((int) $search_status);
1032 if ($search_status == -2) {
1034 $sql .=
" AND (c.fk_statut IN (1,2))";
1036 if ($search_status == -3) {
1039 $sql .=
' AND (c.fk_statut IN (1,2,3))';
1042if ($search_option ==
'late') {
1045 $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).
"'))";
1047 $sql .=
" AND c.date_commande < '".$db->idate(
dol_now() -
$conf->order->client->warning_delay).
"'";
1050if ($search_datecloture_start) {
1051 $sql .=
" AND c.date_cloture >= '".$db->idate($search_datecloture_start).
"'";
1053if ($search_datecloture_end) {
1054 $sql .=
" AND c.date_cloture <= '".$db->idate($search_datecloture_end).
"'";
1056if ($search_dateorder_start) {
1057 $sql .=
" AND c.date_commande >= '".$db->idate($search_dateorder_start).
"'";
1059if ($search_dateorder_end) {
1060 $sql .=
" AND c.date_commande <= '".$db->idate($search_dateorder_end).
"'";
1062if ($search_datedelivery_start) {
1063 $sql .=
" AND c.date_livraison >= '".$db->idate($search_datedelivery_start).
"'";
1065if ($search_datedelivery_end) {
1066 $sql .=
" AND c.date_livraison <= '".$db->idate($search_datedelivery_end).
"'";
1077if ($search_country) {
1078 $sql .=
" AND s.fk_pays IN (".$db->sanitize($search_country).
')';
1080if ($search_type_thirdparty && $search_type_thirdparty !=
'-1') {
1081 $sql .=
" AND s.fk_typent IN (".$db->sanitize($search_type_thirdparty).
')';
1083if (empty($arrayfields[
's.name_alias'][
'checked']) && $search_company) {
1084 $sql .=
natural_search(array(
"s.nom",
"s.name_alias"), $search_company);
1086 if ($search_company) {
1089 if ($search_company_alias) {
1093if ($search_parent_name) {
1096if ($search_total_ht !=
'') {
1099if ($search_total_vat !=
'') {
1102if ($search_total_ttc !=
'') {
1105if ($search_warehouse !=
'' && $search_warehouse > 0) {
1108if ($search_note_public !=
'') {
1111if ($search_note_private !=
'') {
1114if ($search_multicurrency_code !=
'') {
1115 $sql .=
" AND c.multicurrency_code = '".$db->escape($search_multicurrency_code).
"'";
1117if ($search_multicurrency_tx !=
'') {
1118 $sql .=
natural_search(
'c.multicurrency_tx', $search_multicurrency_tx, 1);
1120if ($search_multicurrency_montant_ht !=
'') {
1121 $sql .=
natural_search(
'c.multicurrency_total_ht', $search_multicurrency_montant_ht, 1);
1123if ($search_multicurrency_montant_vat !=
'') {
1124 $sql .=
natural_search(
'c.multicurrency_total_tva', $search_multicurrency_montant_vat, 1);
1126if ($search_multicurrency_montant_ttc !=
'') {
1127 $sql .=
natural_search(
'c.multicurrency_total_ttc', $search_multicurrency_montant_ttc, 1);
1130 $sql .=
natural_search(array(
"u.login",
"u.firstname",
"u.lastname"), $search_login);
1132if ($search_project_ref !=
'') {
1135if ($search_project !=
'') {
1138if ($search_fk_cond_reglement > 0) {
1139 $sql .=
" AND c.fk_cond_reglement = ".((int) $search_fk_cond_reglement);
1141if ($search_fk_shipping_method > 0) {
1142 $sql .=
" AND c.fk_shipping_method = ".((int) $search_fk_shipping_method);
1144if ($search_fk_mode_reglement > 0) {
1145 $sql .=
" AND c.fk_mode_reglement = ".((int) $search_fk_mode_reglement);
1147if ($search_fk_input_reason > 0) {
1148 $sql .=
" AND c.fk_input_reason = ".((int) $search_fk_input_reason);
1150if ($search_module_source) {
1151 $sql .=
natural_search(
"c.module_source", $search_module_source);
1153if ($search_pos_source) {
1156if ($search_import_key) {
1160if ($search_user > 0) {
1161 $sql .=
" AND EXISTS (";
1162 $sql .=
" SELECT ec.fk_c_type_contact, ec.element_id, ec.fk_socpeople";
1163 $sql .=
" FROM ".MAIN_DB_PREFIX.
"element_contact as ec";
1164 $sql .=
" INNER JOIN ".MAIN_DB_PREFIX.
"c_type_contact as tc";
1165 $sql .=
" ON ec.fk_c_type_contact = tc.rowid AND tc.element = 'commande' AND tc.source = 'internal'";
1166 $sql .=
" WHERE ec.element_id = c.rowid AND ec.fk_socpeople = ".((int) $search_user).
")";
1169if ($search_sale && $search_sale !=
'-1') {
1170 if ($search_sale == -2) {
1171 $sql .=
" AND NOT EXISTS (SELECT sc.fk_soc FROM ".MAIN_DB_PREFIX.
"societe_commerciaux as sc WHERE sc.fk_soc = c.fk_soc)";
1172 } elseif ($search_sale > 0) {
1173 $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).
")";
1178if (!empty($searchCategoryOrderList)) {
1179 $searchCategoryOrderSqlList = array();
1180 $listofcategoryid =
'';
1181 foreach ($searchCategoryOrderList as $searchCategoryOrder) {
1182 if (intval($searchCategoryOrder) == -2) {
1183 $searchCategoryOrderSqlList[] =
"NOT EXISTS (SELECT ck.fk_order FROM ".MAIN_DB_PREFIX.
"categorie_order as ck WHERE c.rowid = ck.fk_order)";
1184 } elseif (intval($searchCategoryOrder) > 0) {
1185 if ($searchCategoryOrderOperator == 0) {
1186 $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).
")";
1188 $listofcategoryid .= ($listofcategoryid ?
', ' :
'') .((
int) $searchCategoryOrder);
1192 if ($listofcategoryid) {
1193 $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).
"))";
1195 if ($searchCategoryOrderOperator == 1) {
1196 if (!empty($searchCategoryOrderSqlList)) {
1197 $sql .=
" AND (".implode(
' OR ', $searchCategoryOrderSqlList).
")";
1200 if (!empty($searchCategoryOrderSqlList)) {
1201 $sql .=
" AND (".implode(
' AND ', $searchCategoryOrderSqlList).
")";
1207$searchCategoryCustomerOperator =
GETPOSTINT(
'search_category_customer_operator');
1208$searchCategoryCustomerList = array($search_categ_cus);
1209if (!empty($searchCategoryCustomerList)) {
1210 $searchCategoryCustomerSqlList = array();
1211 $listofcategoryid =
'';
1212 foreach ($searchCategoryCustomerList as $searchCategoryCustomer) {
1213 if (intval($searchCategoryCustomer) == -2) {
1214 $searchCategoryCustomerSqlList[] =
"NOT EXISTS (SELECT cs.fk_soc FROM ".MAIN_DB_PREFIX.
"categorie_societe as cs WHERE s.rowid = cs.fk_soc)";
1215 } elseif (intval($searchCategoryCustomer) > 0) {
1216 if ($searchCategoryCustomerOperator == 0) {
1217 $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).
")";
1219 $listofcategoryid .= ($listofcategoryid ?
', ' :
'') .((
int) $searchCategoryCustomer);
1223 if ($listofcategoryid) {
1224 $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).
"))";
1226 if ($searchCategoryCustomerOperator == 1) {
1227 if (!empty($searchCategoryCustomerSqlList)) {
1228 $sql .=
" AND (".implode(
' OR ', $searchCategoryCustomerSqlList).
")";
1231 if (!empty($searchCategoryCustomerSqlList)) {
1232 $sql .=
" AND (".implode(
' AND ', $searchCategoryCustomerSqlList).
")";
1237$searchCategoryProductOperator =
GETPOSTINT(
'search_category_product_operator');
1238$searchCategoryProductList = array($search_product_category);
1239if (!empty($searchCategoryProductList)) {
1240 $searchCategoryProductSqlList = array();
1241 $listofcategoryid =
'';
1242 foreach ($searchCategoryProductList as $searchCategoryProduct) {
1243 if (intval($searchCategoryProduct) == -2) {
1244 $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)";
1245 } elseif (intval($searchCategoryProduct) > 0) {
1246 if ($searchCategoryProductOperator == 0) {
1247 $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).
")";
1249 $listofcategoryid .= ($listofcategoryid ?
', ' :
'') .((
int) $searchCategoryProduct);
1253 if ($listofcategoryid) {
1254 $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).
"))";
1256 if ($searchCategoryProductOperator == 1) {
1257 if (!empty($searchCategoryProductSqlList)) {
1258 $sql .=
" AND (".implode(
' OR ', $searchCategoryProductSqlList).
")";
1261 if (!empty($searchCategoryProductSqlList)) {
1262 $sql .=
" AND (".implode(
' AND ', $searchCategoryProductSqlList).
")";
1267include DOL_DOCUMENT_ROOT.
'/core/tpl/extrafields_list_search_sql.tpl.php';
1269$parameters = array();
1270$reshook = $hookmanager->executeHooks(
'printFieldListWhere', $parameters, $object, $action);
1271$sql .= $hookmanager->resPrint;
1274 $sql .=
natural_search(array_keys($fieldstosearchall), $search_all);
1278$parameters = array();
1279$reshook = $hookmanager->executeHooks(
'printFieldListHaving', $parameters, $object, $action);
1280$sql .= empty($hookmanager->resPrint) ?
"" :
" HAVING 1=1 ".$hookmanager->resPrint;
1284$nbtotalofrecords =
'';
1287 $sqlforcount = preg_replace(
'/^'.preg_quote($sqlfields,
'/').
'/',
'SELECT COUNT(*) as nbtotalofrecords', $sql);
1288 $sqlforcount = preg_replace(
'/GROUP BY .*$/',
'', $sqlforcount);
1289 $resql = $db->query($sqlforcount);
1291 $objforcount = $db->fetch_object($resql);
1292 $nbtotalofrecords = $objforcount->nbtotalofrecords;
1297 if (($page * $limit) > $nbtotalofrecords) {
1305$sql .= $db->order($sortfield, $sortorder);
1307 $sql .= $db->plimit($limit + 1, $offset);
1311$resql = $db->query($sql);
1319 $soc->fetch($socid);
1320 $title = $langs->trans(
'CustomersOrders').
' - '.$soc->name;
1321 if (empty($search_company)) {
1322 $search_company = $soc->name;
1325 $title = $langs->trans(
'CustomersOrders');
1327if (strval($search_status) ==
'0') {
1328 $title .=
' - '.$langs->trans(
'StatusOrderDraftShort');
1330if ($search_status == 1) {
1331 $title .=
' - '.$langs->trans(
'StatusOrderValidatedShort');
1333if ($search_status == 2) {
1334 $title .=
' - '.$langs->trans(
'StatusOrderSentShort');
1336if ($search_status == 3) {
1337 $title .=
' - '.$langs->trans(
'StatusOrderToBillShort');
1339if ($search_status == -1) {
1340 $title .=
' - '.$langs->trans(
'StatusOrderCanceledShort');
1342if ($search_status == -2) {
1343 $title .=
' - '.$langs->trans(
'StatusOrderToProcessShort');
1345if ($search_status == -3) {
1346 $title .=
' - '.$langs->trans(
'StatusOrderValidated').
', '.(!isModEnabled(
'shipping') ?
'' : $langs->trans(
"StatusOrderSent").
', ').$langs->trans(
'StatusOrderToBill');
1348if ($search_status == -4) {
1349 $title .=
' - '.$langs->trans(
"StatusOrderValidatedShort").
'+'.$langs->trans(
"StatusOrderSentShort");
1352$num = $db->num_rows($resql);
1354$arrayofselected = is_array($toselect) ? $toselect : array();
1356if ($num == 1 &&
getDolGlobalString(
'MAIN_SEARCH_DIRECT_OPEN_IF_ONLY_ONE') && $search_all) {
1357 $obj = $db->fetch_object($resql);
1359 header(
"Location: ".DOL_URL_ROOT.
'/commande/card.php?id='.
$id);
1366llxHeader(
'', $title, $help_url,
'', 0, 0,
'',
'',
'',
'bodyforlist mod-order page-list');
1368$arrayofselected = is_array($toselect) ? $toselect : array();
1372 $param .=
'&mode='.urlencode($mode);
1374if (!empty($contextpage) && $contextpage != $_SERVER[
"PHP_SELF"]) {
1375 $param .=
'&contextpage='.urlencode($contextpage);
1377if ($limit > 0 && $limit !=
$conf->liste_limit) {
1378 $param .=
'&limit='.((int) $limit);
1380if ($optioncss !=
'') {
1381 $param .=
'&optioncss='.urlencode($optioncss);
1384 $param .=
'&show_files='.urlencode((
string) ($show_files));
1387 $param .=
'&search_all='.urlencode($search_all);
1390 $param .=
'&socid='.((int) $socid);
1392if ($search_status !=
'') {
1393 $param .=
'&search_status='.urlencode($search_status);
1395if ($search_option) {
1396 $param .=
"&search_option=".urlencode($search_option);
1398if ($search_datecloture_start) {
1399 $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');
1401if ($search_datecloture_end) {
1402 $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');
1404if ($search_dateorder_start) {
1405 $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');
1407if ($search_dateorder_end) {
1408 $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');
1410if ($search_datedelivery_start) {
1411 $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');
1413if ($search_datedelivery_end) {
1414 $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');
1417 $param .=
'&search_id='.urlencode((
string) $search_id);
1420 $param .=
'&search_ref='.urlencode($search_ref);
1422if ($search_ref_ext) {
1423 $param .=
'&search_ref_ext='.urlencode($search_ref_ext);
1425if ($search_company) {
1426 $param .=
'&search_company='.urlencode($search_company);
1428if ($search_company_alias) {
1429 $param .=
'&search_company_alias='.urlencode($search_company_alias);
1431if ($search_parent_name !=
'') {
1432 $param .=
'&search_parent_name='.urlencode($search_parent_name);
1434if ($search_ref_customer) {
1435 $param .=
'&search_ref_customer='.urlencode($search_ref_customer);
1437if ($search_user > 0) {
1438 $param .=
'&search_user='.urlencode((
string) ($search_user));
1440if ($search_sale > 0) {
1441 $param .=
'&search_sale='.urlencode((
string) ($search_sale));
1443if ($search_total_ht !=
'') {
1444 $param .=
'&search_total_ht='.urlencode($search_total_ht);
1446if ($search_total_vat !=
'') {
1447 $param .=
'&search_total_vat='.urlencode($search_total_vat);
1449if ($search_total_ttc !=
'') {
1450 $param .=
'&search_total_ttc='.urlencode($search_total_ttc);
1452if ($search_warehouse !=
'') {
1453 $param .=
'&search_warehouse='.urlencode((
string) ($search_warehouse));
1456 $param .=
'&search_login='.urlencode($search_login);
1458if ($search_multicurrency_code !=
'') {
1459 $param .=
'&search_multicurrency_code='.urlencode($search_multicurrency_code);
1461if ($search_multicurrency_tx !=
'') {
1462 $param .=
'&search_multicurrency_tx='.urlencode($search_multicurrency_tx);
1464if ($search_multicurrency_montant_ht !=
'') {
1465 $param .=
'&search_multicurrency_montant_ht='.urlencode($search_multicurrency_montant_ht);
1467if ($search_multicurrency_montant_vat !=
'') {
1468 $param .=
'&search_multicurrency_montant_vat='.urlencode($search_multicurrency_montant_vat);
1470if ($search_multicurrency_montant_ttc !=
'') {
1471 $param .=
'&search_multicurrency_montant_ttc='.urlencode($search_multicurrency_montant_ttc);
1473if ($search_project_ref >= 0) {
1474 $param .=
"&search_project_ref=".urlencode($search_project_ref);
1476if ($search_project !=
'') {
1477 $param .=
"&search_project=".urlencode($search_project);
1479if ($search_town !=
'') {
1480 $param .=
'&search_town='.urlencode($search_town);
1482if ($search_zip !=
'') {
1483 $param .=
'&search_zip='.urlencode($search_zip);
1485if ($search_state !=
'') {
1486 $param .=
'&search_state='.urlencode($search_state);
1488if ($search_country !=
'') {
1489 $param .=
'&search_country='.urlencode((
string) ($search_country));
1491if ($search_type_thirdparty && $search_type_thirdparty !=
'-1') {
1492 $param .=
'&search_type_thirdparty='.urlencode((
string) ($search_type_thirdparty));
1494if ($searchCategoryOrderOperator == 1) {
1495 $param .=
"&search_category_order_operator=".urlencode((
string) ($searchCategoryOrderOperator));
1497foreach ($searchCategoryOrderList as $searchCategoryOrder) {
1498 $param .=
"&search_category_order_list[]=".urlencode($searchCategoryOrder);
1500if ($search_product_category !=
'') {
1501 $param .=
'&search_product_category='.urlencode((
string) ($search_product_category));
1503if (($search_categ_cus > 0) || ($search_categ_cus == -2)) {
1504 $param .=
'&search_categ_cus='.urlencode((
string) ($search_categ_cus));
1506if ($search_billed !=
'') {
1507 $param .=
'&search_billed='.urlencode($search_billed);
1509if ($search_fk_cond_reglement > 0) {
1510 $param .=
'&search_fk_cond_reglement='.urlencode((
string) ($search_fk_cond_reglement));
1512if ($search_fk_shipping_method > 0) {
1513 $param .=
'&search_fk_shipping_method='.urlencode((
string) ($search_fk_shipping_method));
1515if ($search_fk_mode_reglement > 0) {
1516 $param .=
'&search_fk_mode_reglement='.urlencode((
string) ($search_fk_mode_reglement));
1518if ($search_fk_input_reason > 0) {
1519 $param .=
'&search_fk_input_reason='.urlencode((
string) ($search_fk_input_reason));
1521if ($search_module_source) {
1522 $param .=
'&search_module_source='.urlencode($search_module_source);
1524if ($search_pos_source) {
1525 $param .=
'&search_pos_source='.urlencode($search_pos_source);
1527if ($search_import_key !=
'') {
1528 $param .=
'&search_import_key='.urlencode($search_import_key);
1532include DOL_DOCUMENT_ROOT.
'/core/tpl/extrafields_list_search_param.tpl.php';
1535$parameters = array();
1536$reshook = $hookmanager->executeHooks(
'printFieldListSearchParam', $parameters, $object, $action);
1537$param .= $hookmanager->resPrint;
1540$arrayofmassactions = array(
1541 'generate_doc' =>
img_picto(
'',
'pdf',
'class="pictofixedwidth"').$langs->trans(
"ReGeneratePDF"),
1542 'builddoc' =>
img_picto(
'',
'pdf',
'class="pictofixedwidth"').$langs->trans(
"PDFMerge"),
1544if ($permissiontovalidate) {
1545 $arrayofmassactions[
'prevalidate'] =
img_picto(
'',
'check',
'class="pictofixedwidth"').$langs->trans(
"Validate");
1547if ($permissiontoclose) {
1548 $arrayofmassactions[
'preshipped'] =
img_picto(
'',
'dolly',
'class="pictofixedwidth"').$langs->trans(
"ClassifyShipped");
1550if (isModEnabled(
'invoice') && $user->hasRight(
"facture",
"creer")) {
1551 $arrayofmassactions[
'createbills'] =
img_picto(
'',
'bill',
'class="pictofixedwidth"').$langs->trans(
"CreateInvoiceForThisCustomer");
1553if ($permissiontoclose) {
1554 $arrayofmassactions[
'setbilled'] =
img_picto(
'',
'bill',
'class="pictofixedwidth"').$langs->trans(
"ClassifyBilled");
1556if ($permissiontocancel) {
1557 $arrayofmassactions[
'cancelorders'] =
img_picto(
'',
'close_title',
'class="pictofixedwidth"').$langs->trans(
"CancelOrder");
1559if (!empty($permissiontodelete)) {
1560 $arrayofmassactions[
'predelete'] =
img_picto(
'',
'delete',
'class="pictofixedwidth"').$langs->trans(
"Delete");
1562if ($permissiontosendbymail) {
1563 $arrayofmassactions[
'presend'] =
img_picto(
'',
'email',
'class="pictofixedwidth"').$langs->trans(
"SendByMail");
1565if (in_array($massaction, array(
'presend',
'predelete',
'createbills'))) {
1566 $arrayofmassactions = array();
1568$massactionbutton = $form->selectMassAction(
'', $arrayofmassactions);
1570$url = DOL_URL_ROOT.
'/commande/card.php?action=create';
1571if (!empty($socid)) {
1572 $url .=
'&socid='.$socid;
1575$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'));
1576$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'));
1578$newcardbutton .=
dolGetButtonTitle($langs->trans(
'NewOrder'),
'',
'fa fa-plus-circle', $url,
'', (
int) (($contextpage ==
'orderlist' || $contextpage ==
'billableorders') && $permissiontoadd));
1581print
'<form method="POST" id="searchFormList" name="searchFormList" action="'.$_SERVER[
"PHP_SELF"].
'">'.
"\n";
1582if ($optioncss !=
'') {
1583 print
'<input type="hidden" name="optioncss" value="'.$optioncss.
'">';
1585print
'<input type="hidden" name="token" value="'.newToken().
'">';
1586print
'<input type="hidden" name="formfilteraction" id="formfilteraction" value="list">';
1587print
'<input type="hidden" name="action" value="list">';
1588print
'<input type="hidden" name="sortfield" value="'.$sortfield.
'">';
1589print
'<input type="hidden" name="sortorder" value="'.$sortorder.
'">';
1590print
'<input type="hidden" name="contextpage" value="'.$contextpage.
'">';
1591print
'<input type="hidden" name="search_status" value="'.$search_status.
'">';
1592print
'<input type="hidden" name="socid" value="'.$socid.
'">';
1593print
'<input type="hidden" name="page_y" value="">';
1594print
'<input type="hidden" name="mode" value="'.$mode.
'">';
1597print_barre_liste($title, $page, $_SERVER[
"PHP_SELF"], $param, $sortfield, $sortorder, $massactionbutton, $num, $nbtotalofrecords,
'order', 0, $newcardbutton,
'', $limit, 0, 0, 1);
1599$topicmail =
"SendOrderRef";
1600$modelmail =
"order_send";
1602$trackid =
'ord'.$object->id;
1603include DOL_DOCUMENT_ROOT.
'/core/tpl/massactions_pre.tpl.php';
1605if ($massaction ==
'prevalidate') {
1606 print $form->formconfirm($_SERVER[
"PHP_SELF"], $langs->trans(
"ConfirmMassValidation"), $langs->trans(
"ConfirmMassValidationQuestion"),
"validate",
null,
'', 0, 200, 500, 1);
1608if ($massaction ==
'preshipped') {
1609 print $form->formconfirm($_SERVER[
"PHP_SELF"], $langs->trans(
"CloseOrder"), $langs->trans(
"ConfirmCloseOrder"),
"shipped",
null,
'', 0, 200, 500, 1);
1612if ($massaction ==
'createbills') {
1613 print
'<input type="hidden" name="massaction" value="confirm_createbills">';
1615 print
'<table class="noborder centpercent">';
1618 print $langs->trans(
'DateInvoice');
1621 print $form->selectDate(
'',
'', 0, 0, 0,
'', 1, 1);
1626 print $langs->trans(
'CreateOneBillByThird');
1629 print $form->selectyesno(
'createbills_onebythird',
getDolGlobalString(
'MAIN_ORDERLIST_CREATEBILLS_ONEBYTHIRD',
'no'), 1);
1634 print $langs->trans(
'ValidateInvoices');
1638 print $form->selectyesno(
'validate_invoices', 0, 1, 1);
1639 $langs->load(
"errors");
1640 print
' ('.$langs->trans(
"WarningAutoValNotPossibleWhenStockIsDecreasedOnInvoiceVal").
')';
1642 print $form->selectyesno(
'validate_invoices', 0, 1);
1644 if (!empty(
$conf->workflow->enabled) &&
getDolGlobalString(
'WORKFLOW_INVOICE_AMOUNT_CLASSIFY_BILLED_ORDER')) {
1645 print
' <span class="opacitymedium">'.$langs->trans(
"IfValidateInvoiceIsNoOrderStayUnbilled").
'</span>';
1647 print
' <span class="opacitymedium">'.$langs->trans(
"OptionToSetOrderBilledNotEnabled").
'</span>';
1653 print
'<div class="center">';
1654 print
'<input type="submit" class="button" id="createbills" name="createbills" value="'.$langs->trans(
'CreateInvoiceForThisCustomer').
'"> ';
1655 print
'<input type="submit" class="button button-cancel" id="cancel" name="cancel" value="'.$langs->trans(
"Cancel").
'">';
1662 foreach ($fieldstosearchall as $key => $val) {
1663 $fieldstosearchall[$key] = $langs->trans($val);
1664 $setupstring .= $key.
"=".$val.
";";
1666 print
'<!-- Search done like if MYOBJECT_QUICKSEARCH_ON_FIELDS = '.$setupstring.
' -->'.
"\n";
1667 print
'<div class="divsearchfieldfilter">'.$langs->trans(
"FilterOnInto", $search_all).implode(
', ', $fieldstosearchall).
'</div>';
1672if (isModEnabled(
'category') && $user->hasRight(
'categorie',
'read')) {
1674 $moreforfilter .= $formcategory->getFilterBox(Categorie::TYPE_ORDER, $searchCategoryOrderList,
'minwidth300', $searchCategoryOrderOperator ? $searchCategoryOrderOperator : 0);
1678if ($user->hasRight(
"user",
"user",
"lire")) {
1679 $langs->load(
"commercial");
1680 $moreforfilter .=
'<div class="divsearchfield">';
1681 $tmptitle = $langs->trans(
'ThirdPartiesOfSaleRepresentative');
1682 $moreforfilter .=
img_picto($tmptitle,
'user',
'class="pictofixedwidth"').$formother->select_salesrepresentatives($search_sale,
'search_sale', $user, 0, $tmptitle,
'maxwidth250 widthcentpercentminusx');
1683 $moreforfilter .=
'</div>';
1686if ($user->hasRight(
"user",
"user",
"lire")) {
1687 $moreforfilter .=
'<div class="divsearchfield">';
1688 $tmptitle = $langs->trans(
'LinkedToSpecificUsers');
1689 $moreforfilter .=
img_picto($tmptitle,
'user',
'class="pictofixedwidth"').$form->select_dolusers($search_user,
'search_user', $tmptitle,
null, 0,
'',
'',
'0', 0, 0,
'', 0,
'',
'maxwidth250 widthcentpercentminusx');
1690 $moreforfilter .=
'</div>';
1694if (isModEnabled(
'category') && $user->hasRight(
"categorie",
"lire") && ($user->hasRight(
"produit",
"lire") || $user->hasRight(
"service",
"lire"))) {
1695 include_once DOL_DOCUMENT_ROOT.
'/categories/class/categorie.class.php';
1696 $moreforfilter .=
'<div class="divsearchfield">';
1697 $tmptitle = $langs->trans(
'IncludingProductWithTag');
1698 $cate_arbo = $form->select_all_categories(Categorie::TYPE_PRODUCT,
'',
'parent', 0, array(), 1);
1699 $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);
1700 $moreforfilter .=
'</div>';
1703if (isModEnabled(
'category') && $user->hasRight(
"categorie",
"lire")) {
1704 require_once DOL_DOCUMENT_ROOT.
'/categories/class/categorie.class.php';
1705 $moreforfilter .=
'<div class="divsearchfield">';
1706 $tmptitle = $langs->trans(
'CustomersProspectsCategoriesShort');
1707 $moreforfilter .=
img_picto($tmptitle,
'category',
'class="pictofixedwidth"').$formother->select_categories(
'customer', $search_categ_cus,
'search_categ_cus', 1, $tmptitle,
'maxwidth300 widthcentpercentminusx');
1708 $moreforfilter .=
'</div>';
1711if (isModEnabled(
'stock') &&
getDolGlobalString(
'WAREHOUSE_ASK_WAREHOUSE_DURING_ORDER')) {
1712 require_once DOL_DOCUMENT_ROOT.
'/product/class/html.formproduct.class.php';
1714 $moreforfilter .=
'<div class="divsearchfield">';
1715 $tmptitle = $langs->trans(
'Warehouse');
1716 $moreforfilter .=
img_picto($tmptitle,
'stock',
'class="pictofixedwidth"').$formproduct->selectWarehouses($search_warehouse,
'search_warehouse',
'', 1, 0, 0, $tmptitle, 0, 0, array(),
'maxwidth250 widthcentpercentminusx');
1717 $moreforfilter .=
'</div>';
1720$parameters = array();
1721$reshook = $hookmanager->executeHooks(
'printFieldPreListTitle', $parameters, $object, $action);
1722if (empty($reshook)) {
1723 $moreforfilter .= $hookmanager->resPrint;
1725 $moreforfilter = $hookmanager->resPrint;
1728if (!empty($moreforfilter)) {
1729 print
'<div class="liste_titre liste_titre_bydiv centpercent">';
1730 print $moreforfilter;
1734$varpage = empty($contextpage) ? $_SERVER[
"PHP_SELF"] : $contextpage;
1735$htmlofselectarray = $form->multiSelectArrayWithCheckbox(
'selectedfields', $arrayfields, $varpage,
getDolGlobalString(
'MAIN_CHECKBOX_LEFT_COLUMN'));
1736$selectedfields = ($mode !=
'kanban' ? $htmlofselectarray :
'');
1737$selectedfields .= (count($arrayofmassactions) ? $form->showCheckAddButtons(
'checkforselect', 1) :
'');
1740 $selectedfields .=
'<script>';
1741 $selectedfields .=
' $(document).ready(function() {';
1742 $selectedfields .=
' console.log("Autoclick on checkforselects");';
1743 $selectedfields .=
' $("#checkforselects").click();';
1744 $selectedfields .=
' $("#massaction").val("createbills").change();';
1745 $selectedfields .=
' });';
1746 $selectedfields .=
'</script>';
1749print
'<div class="div-table-responsive">';
1750print
'<table class="tagtable nobottomiftotal liste'.($moreforfilter ?
" listwithfilterbefore" :
"").
'">'.
"\n";
1754print
'<tr class="liste_titre_filter">';
1757 print
'<td class="liste_titre center maxwidthsearch actioncolumn">';
1758 $searchpicto = $form->showFilterButtons(
'left');
1764if (!empty($arrayfields[
'c.rowid'][
'checked'])) {
1765 print
'<td class="liste_titre">';
1766 print
'<input class="flat" size="6" type="text" name="search_id" value="'.dol_escape_htmltag($search_id).
'">';
1771if (!empty($arrayfields[
'c.ref'][
'checked'])) {
1772 print
'<td class="liste_titre">';
1773 print
'<input class="flat maxwidth50imp" type="text" name="search_ref" value="'.dol_escape_htmltag($search_ref).
'">';
1777if (!empty($arrayfields[
'c.ref_ext'][
'checked'])) {
1778 print
'<td class="liste_titre">';
1779 print
'<input class="flat maxwidth50imp" type="text" name="search_ref_ext" value="'.dol_escape_htmltag($search_ref_ext).
'">';
1783if (!empty($arrayfields[
'c.ref_client'][
'checked'])) {
1784 print
'<td class="liste_titre" align="left">';
1785 print
'<input class="flat" type="text" size="6" name="search_ref_customer" value="'.dol_escape_htmltag($search_ref_customer).
'">';
1789if (!empty($arrayfields[
'p.ref'][
'checked'])) {
1790 print
'<td class="liste_titre"><input type="text" class="flat" size="6" name="search_project_ref" value="'.dol_escape_htmltag($search_project_ref).
'"></td>';
1793if (!empty($arrayfields[
'p.title'][
'checked'])) {
1794 print
'<td class="liste_titre"><input type="text" class="flat" size="6" name="search_project" value="'.dol_escape_htmltag($search_project).
'"></td>';
1797if (!empty($arrayfields[
's.nom'][
'checked'])) {
1798 print
'<td class="liste_titre">';
1799 print
'<input class="flat maxwidth75imp" type="text" name="search_company" value="'.dol_escape_htmltag((
string) $search_company).
'"'.(!empty($user->socid) ?
" disabled" :
"").
'>';
1803if (!empty($arrayfields[
's.name_alias'][
'checked'])) {
1804 print
'<td class="liste_titre">';
1805 print
'<input class="flat maxwidth75imp" type="text" name="search_company_alias" value="'.dol_escape_htmltag($search_company_alias).
'">';
1809if (!empty($arrayfields[
's2.nom'][
'checked'])) {
1810 print
'<td class="liste_titre">';
1811 print
'<input class="flat maxwidth100" type="text" name="search_parent_name" value="'.dol_escape_htmltag($search_parent_name).
'">';
1815if (!empty($arrayfields[
's.town'][
'checked'])) {
1816 print
'<td class="liste_titre"><input class="flat maxwidth75imp" type="text" name="search_town" value="'.dol_escape_htmltag($search_town).
'"></td>';
1819if (!empty($arrayfields[
's.zip'][
'checked'])) {
1820 print
'<td class="liste_titre"><input class="flat maxwidth50imp" type="text" name="search_zip" value="'.dol_escape_htmltag($search_zip).
'"></td>';
1823if (!empty($arrayfields[
'state.nom'][
'checked'])) {
1824 print
'<td class="liste_titre">';
1825 print
'<input class="flat maxwidth50imp" type="text" name="search_state" value="'.dol_escape_htmltag($search_state).
'">';
1829if (!empty($arrayfields[
'country.code_iso'][
'checked'])) {
1830 print
'<td class="liste_titre" align="center">';
1831 print $form->select_country($search_country,
'search_country',
'', 0,
'minwidth100imp maxwidth100');
1835if (!empty($arrayfields[
'typent.code'][
'checked'])) {
1836 print
'<td class="liste_titre maxwidthonsmartphone center">';
1837 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);
1841if (!empty($arrayfields[
'c.date_commande'][
'checked'])) {
1842 print
'<td class="liste_titre center">';
1843 print
'<div class="nowrapfordate">';
1844 print $form->selectDate($search_dateorder_start ? $search_dateorder_start : -1,
'search_dateorder_start_', 0, 0, 1,
'', 1, 0, 0,
'',
'',
'',
'', 1,
'', $langs->trans(
'From'));
1846 print
'<div class="nowrapfordate">';
1847 print $form->selectDate($search_dateorder_end ? $search_dateorder_end : -1,
'search_dateorder_end_', 0, 0, 1,
'', 1, 0, 0,
'',
'',
'',
'', 1,
'', $langs->trans(
'to'));
1851if (!empty($arrayfields[
'c.delivery_date'][
'checked'])) {
1852 print
'<td class="liste_titre center">';
1853 print
'<div class="nowrapfordate">';
1854 print $form->selectDate($search_datedelivery_start ? $search_datedelivery_start : -1,
'search_datedelivery_start_', 0, 0, 1,
'', 1, 0, 0,
'',
'',
'',
'', 1,
'', $langs->trans(
'From'));
1856 print
'<div class="nowrapfordate">';
1857 print $form->selectDate($search_datedelivery_end ? $search_datedelivery_end : -1,
'search_datedelivery_end_', 0, 0, 1,
'', 1, 0, 0,
'',
'',
'',
'', 1,
'', $langs->trans(
'to'));
1862if (!empty($arrayfields[
'c.fk_shipping_method'][
'checked'])) {
1863 print
'<td class="liste_titre">';
1864 $form->selectShippingMethod($search_fk_shipping_method,
'search_fk_shipping_method',
'', 1,
'', 1);
1868if (!empty($arrayfields[
'c.fk_cond_reglement'][
'checked'])) {
1869 print
'<td class="liste_titre">';
1870 print $form->getSelectConditionsPaiements((
int) $search_fk_cond_reglement,
'search_fk_cond_reglement', 1, 1, 1);
1874if (!empty($arrayfields[
'c.fk_mode_reglement'][
'checked'])) {
1875 print
'<td class="liste_titre">';
1876 print $form->select_types_paiements($search_fk_mode_reglement,
'search_fk_mode_reglement',
'', 0, 1, 1, 0, -1,
'', 1);
1880if (!empty($arrayfields[
'c.fk_input_reason'][
'checked'])) {
1881 print
'<td class="liste_titre">';
1882 $form->selectInputReason($search_fk_input_reason,
'search_fk_input_reason',
'', 1,
'', 1);
1886if (!empty($arrayfields[
'c.module_source'][
'checked'])) {
1887 print
'<td class="liste_titre">';
1888 print
'<input class="flat maxwidth75" type="text" name="search_module_source" value="'.dol_escape_htmltag($search_module_source).
'">';
1892if (!empty($arrayfields[
'c.pos_source'][
'checked'])) {
1893 print
'<td class="liste_titre">';
1894 print
'<input class="flat maxwidth50" type="text" name="search_pos_source" value="'.dol_escape_htmltag($search_pos_source).
'">';
1898if (!empty($arrayfields[
'c.total_ht'][
'checked'])) {
1899 print
'<td class="liste_titre right">';
1900 print
'<input class="flat" type="text" size="4" name="search_total_ht" value="'.dol_escape_htmltag($search_total_ht).
'">';
1904if (!empty($arrayfields[
'c.total_vat'][
'checked'])) {
1905 print
'<td class="liste_titre right">';
1906 print
'<input class="flat" type="text" size="4" name="search_total_vat" value="'.dol_escape_htmltag($search_total_vat).
'">';
1910if (!empty($arrayfields[
'c.total_ttc'][
'checked'])) {
1911 print
'<td class="liste_titre right">';
1912 print
'<input class="flat" type="text" size="5" name="search_total_ttc" value="'.$search_total_ttc.
'">';
1916if (!empty($arrayfields[
'c.multicurrency_code'][
'checked'])) {
1917 print
'<td class="liste_titre">';
1918 print $form->selectMultiCurrency($search_multicurrency_code,
'search_multicurrency_code', 1);
1922if (!empty($arrayfields[
'c.multicurrency_tx'][
'checked'])) {
1923 print
'<td class="liste_titre">';
1924 print
'<input class="flat" type="text" size="4" name="search_multicurrency_tx" value="'.dol_escape_htmltag($search_multicurrency_tx).
'">';
1928if (!empty($arrayfields[
'c.multicurrency_total_ht'][
'checked'])) {
1929 print
'<td class="liste_titre right">';
1930 print
'<input class="flat" type="text" size="4" name="search_multicurrency_montant_ht" value="'.dol_escape_htmltag($search_multicurrency_montant_ht).
'">';
1934if (!empty($arrayfields[
'c.multicurrency_total_vat'][
'checked'])) {
1935 print
'<td class="liste_titre right">';
1936 print
'<input class="flat" type="text" size="4" name="search_multicurrency_montant_vat" value="'.dol_escape_htmltag($search_multicurrency_montant_vat).
'">';
1940if (!empty($arrayfields[
'c.multicurrency_total_ttc'][
'checked'])) {
1941 print
'<td class="liste_titre right">';
1942 print
'<input class="flat width75" type="text" name="search_multicurrency_montant_ttc" value="'.dol_escape_htmltag($search_multicurrency_montant_ttc).
'">';
1946if (!empty($arrayfields[
'u.login'][
'checked'])) {
1947 print
'<td class="liste_titre">';
1948 print
'<input class="flat width75" type="text" name="search_login" value="'.dol_escape_htmltag($search_login).
'">';
1952if (!empty($arrayfields[
'sale_representative'][
'checked'])) {
1953 print
'<td class="liste_titre"></td>';
1955if (!empty($arrayfields[
'total_pa'][
'checked'])) {
1956 print
'<td class="liste_titre right">';
1959if (!empty($arrayfields[
'total_margin'][
'checked'])) {
1960 print
'<td class="liste_titre right">';
1963if (!empty($arrayfields[
'total_margin_rate'][
'checked'])) {
1964 print
'<td class="liste_titre right">';
1967if (!empty($arrayfields[
'total_mark_rate'][
'checked'])) {
1968 print
'<td class="liste_titre right">';
1973if (!empty($arrayfields[
'c.datec'][
'checked'])) {
1974 print
'<td class="liste_titre">';
1978if (!empty($arrayfields[
'c.tms'][
'checked'])) {
1979 print
'<td class="liste_titre">';
1983if (!empty($arrayfields[
'c.date_cloture'][
'checked'])) {
1984 print
'<td class="liste_titre center">';
1985 print
'<div class="nowrapfordate">';
1986 print $form->selectDate($search_datecloture_start ? $search_datecloture_start : -1,
'search_datecloture_start', 0, 0, 1,
'', 1, 0, 0,
'',
'',
'',
'', 1,
'', $langs->trans(
'From'));
1988 print
'<div class="nowrapfordate">';
1989 print $form->selectDate($search_datecloture_end ? $search_datecloture_end : -1,
'search_datecloture_end', 0, 0, 1,
'', 1, 0, 0,
'',
'',
'',
'', 1,
'', $langs->trans(
'to'));
1994if (!empty($arrayfields[
'c.note_public'][
'checked'])) {
1995 print
'<td class="liste_titre">';
1996 print
'<input class="flat width75" type="text" name="search_note_public" value="'.dolPrintHTMLForAttribute($search_note_public).
'">';
2000if (!empty($arrayfields[
'c.note_private'][
'checked'])) {
2001 print
'<td class="liste_titre">';
2002 print
'<input class="flat width75" type="text" name="search_note_private" value="'.dolPrintHTMLForAttribute($search_note_private).
'">';
2006if (!empty($arrayfields[
'shippable'][
'checked'])) {
2007 print
'<td class="liste_titre maxwidthonsmartphone" align="center">';
2010 print
'<input type="checkbox" name="show_shippable_command" value="1"'.($show_shippable_command ?
' checked' :
'').
'>';
2011 print $langs->trans(
'ShowShippableStatus');
2013 $show_shippable_command = 1;
2019include DOL_DOCUMENT_ROOT.
'/core/tpl/extrafields_list_search_input.tpl.php';
2022$parameters = array(
'arrayfields' => $arrayfields);
2023$reshook = $hookmanager->executeHooks(
'printFieldListOption', $parameters, $object, $action);
2024print $hookmanager->resPrint;
2027if (!empty($arrayfields[
'c.facture'][
'checked'])) {
2028 print
'<td class="liste_titre maxwidthonsmartphone center">';
2029 print $form->selectyesno(
'search_billed', $search_billed, 1, 0, 1, 1);
2034if (!empty($arrayfields[
'c.import_key'][
'checked'])) {
2035 print
'<td class="liste_titre maxwidthonsmartphone center">';
2036 print
'<input class="flat searchstring maxwidth50" type="text" name="search_import_key" value="'.dol_escape_htmltag($search_import_key).
'">';
2041if (!empty($arrayfields[
'c.fk_statut'][
'checked'])) {
2042 print
'<td class="liste_titre center parentonrightofpage">';
2043 $liststatus = array(
2047 -2 => $langs->trans(
"StatusOrderValidatedShort").
'+'.$langs->trans(
"StatusOrderSentShort"),
2048 -3 => $langs->trans(
"StatusOrderValidatedShort").
'+'.$langs->trans(
"StatusOrderSentShort").
'+'.$langs->trans(
"StatusOrderDelivered"),
2053 print $form->selectarray(
'search_status', $liststatus, $search_status, -5, 0, 0,
'', 0, 0, 0,
'',
'search_status width100 onrightofpage', 1);
2058 print
'<td class="liste_titre center maxwidthsearch">';
2059 $searchpicto = $form->showFilterButtons();
2078print
'<tr class="liste_titre">';
2082 print_liste_field_titre($selectedfields, $_SERVER[
"PHP_SELF"],
"",
'', $param,
'', $sortfield, $sortorder,
'maxwidthsearch center ');
2085if (!empty($arrayfields[
'c.rowid'][
'checked'])) {
2086 print_liste_field_titre($arrayfields[
'c.rowid'][
'label'], $_SERVER[
"PHP_SELF"],
'c.rowid',
'', $param,
'', $sortfield, $sortorder,
'center ');
2089if (!empty($arrayfields[
'c.ref'][
'checked'])) {
2090 print_liste_field_titre($arrayfields[
'c.ref'][
'label'], $_SERVER[
"PHP_SELF"],
'c.ref',
'', $param,
'', $sortfield, $sortorder);
2093if (!empty($arrayfields[
'c.ref_ext'][
'checked'])) {
2094 print_liste_field_titre($arrayfields[
'c.ref_ext'][
'label'], $_SERVER[
"PHP_SELF"],
'c.ref_ext',
'', $param,
'', $sortfield, $sortorder);
2097if (!empty($arrayfields[
'c.ref_client'][
'checked'])) {
2098 print_liste_field_titre($arrayfields[
'c.ref_client'][
'label'], $_SERVER[
"PHP_SELF"],
'c.ref_client',
'', $param,
'', $sortfield, $sortorder);
2101if (!empty($arrayfields[
'p.ref'][
'checked'])) {
2102 print_liste_field_titre($arrayfields[
'p.ref'][
'label'], $_SERVER[
"PHP_SELF"],
"p.ref",
"", $param,
'', $sortfield, $sortorder);
2105if (!empty($arrayfields[
'p.title'][
'checked'])) {
2106 print_liste_field_titre($arrayfields[
'p.title'][
'label'], $_SERVER[
"PHP_SELF"],
"p.title",
"", $param,
'', $sortfield, $sortorder);
2109if (!empty($arrayfields[
's.nom'][
'checked'])) {
2110 print_liste_field_titre($arrayfields[
's.nom'][
'label'], $_SERVER[
"PHP_SELF"],
's.nom',
'', $param,
'', $sortfield, $sortorder);
2113if (!empty($arrayfields[
's.name_alias'][
'checked'])) {
2115 print_liste_field_titre($arrayfields[
's.name_alias'][
'label'], $_SERVER[
"PHP_SELF"],
's.name_alias',
'', $param,
'', $sortfield, $sortorder);
2118if (!empty($arrayfields[
's2.nom'][
'checked'])) {
2119 print_liste_field_titre($arrayfields[
's2.nom'][
'label'], $_SERVER[
'PHP_SELF'],
's2.nom',
'', $param,
'', $sortfield, $sortorder);
2122if (!empty($arrayfields[
's.town'][
'checked'])) {
2123 print_liste_field_titre($arrayfields[
's.town'][
'label'], $_SERVER[
"PHP_SELF"],
's.town',
'', $param,
'', $sortfield, $sortorder);
2126if (!empty($arrayfields[
's.zip'][
'checked'])) {
2127 print_liste_field_titre($arrayfields[
's.zip'][
'label'], $_SERVER[
"PHP_SELF"],
's.zip',
'', $param,
'', $sortfield, $sortorder);
2130if (!empty($arrayfields[
'state.nom'][
'checked'])) {
2131 print_liste_field_titre($arrayfields[
'state.nom'][
'label'], $_SERVER[
"PHP_SELF"],
"state.nom",
"", $param,
'', $sortfield, $sortorder);
2134if (!empty($arrayfields[
'country.code_iso'][
'checked'])) {
2135 print_liste_field_titre($arrayfields[
'country.code_iso'][
'label'], $_SERVER[
"PHP_SELF"],
"country.code_iso",
"", $param,
'', $sortfield, $sortorder,
'center ');
2138if (!empty($arrayfields[
'typent.code'][
'checked'])) {
2139 print_liste_field_titre($arrayfields[
'typent.code'][
'label'], $_SERVER[
"PHP_SELF"],
"typent.code",
"", $param,
'', $sortfield, $sortorder,
'center ');
2142if (!empty($arrayfields[
'c.date_commande'][
'checked'])) {
2143 print_liste_field_titre($arrayfields[
'c.date_commande'][
'label'], $_SERVER[
"PHP_SELF"],
'c.date_commande',
'', $param,
'', $sortfield, $sortorder,
'center ');
2146if (!empty($arrayfields[
'c.delivery_date'][
'checked'])) {
2147 print_liste_field_titre($arrayfields[
'c.delivery_date'][
'label'], $_SERVER[
"PHP_SELF"],
'c.date_livraison',
'', $param,
'', $sortfield, $sortorder,
'center ');
2150if (!empty($arrayfields[
'c.fk_shipping_method'][
'checked'])) {
2151 print_liste_field_titre($arrayfields[
'c.fk_shipping_method'][
'label'], $_SERVER[
"PHP_SELF"],
"c.fk_shipping_method",
"", $param,
'', $sortfield, $sortorder);
2154if (!empty($arrayfields[
'c.fk_cond_reglement'][
'checked'])) {
2155 print_liste_field_titre($arrayfields[
'c.fk_cond_reglement'][
'label'], $_SERVER[
"PHP_SELF"],
"c.fk_cond_reglement",
"", $param,
'', $sortfield, $sortorder);
2158if (!empty($arrayfields[
'c.fk_mode_reglement'][
'checked'])) {
2159 print_liste_field_titre($arrayfields[
'c.fk_mode_reglement'][
'label'], $_SERVER[
"PHP_SELF"],
"c.fk_mode_reglement",
"", $param,
'', $sortfield, $sortorder);
2162if (!empty($arrayfields[
'c.fk_input_reason'][
'checked'])) {
2163 print_liste_field_titre($arrayfields[
'c.fk_input_reason'][
'label'], $_SERVER[
"PHP_SELF"],
"c.fk_input_reason",
"", $param,
'', $sortfield, $sortorder);
2166if (!empty($arrayfields[
'c.module_source'][
'checked'])) {
2167 print_liste_field_titre($arrayfields[
'c.module_source'][
'label'], $_SERVER[
"PHP_SELF"],
"f.module_source",
"", $param,
"", $sortfield, $sortorder);
2170if (!empty($arrayfields[
'c.pos_source'][
'checked'])) {
2171 print_liste_field_titre($arrayfields[
'c.pos_source'][
'label'], $_SERVER[
"PHP_SELF"],
"f.pos_source",
"", $param,
"", $sortfield, $sortorder);
2174if (!empty($arrayfields[
'c.total_ht'][
'checked'])) {
2175 print_liste_field_titre($arrayfields[
'c.total_ht'][
'label'], $_SERVER[
"PHP_SELF"],
'c.total_ht',
'', $param,
'', $sortfield, $sortorder,
'right ');
2178if (!empty($arrayfields[
'c.total_vat'][
'checked'])) {
2179 print_liste_field_titre($arrayfields[
'c.total_vat'][
'label'], $_SERVER[
"PHP_SELF"],
'c.total_tva',
'', $param,
'', $sortfield, $sortorder,
'right ');
2182if (!empty($arrayfields[
'c.total_ttc'][
'checked'])) {
2183 print_liste_field_titre($arrayfields[
'c.total_ttc'][
'label'], $_SERVER[
"PHP_SELF"],
'c.total_ttc',
'', $param,
'', $sortfield, $sortorder,
'right ');
2186if (!empty($arrayfields[
'c.multicurrency_code'][
'checked'])) {
2187 print_liste_field_titre($arrayfields[
'c.multicurrency_code'][
'label'], $_SERVER[
'PHP_SELF'],
'c.multicurrency_code',
'', $param,
'', $sortfield, $sortorder);
2190if (!empty($arrayfields[
'c.multicurrency_tx'][
'checked'])) {
2191 print_liste_field_titre($arrayfields[
'c.multicurrency_tx'][
'label'], $_SERVER[
'PHP_SELF'],
'c.multicurrency_tx',
'', $param,
'', $sortfield, $sortorder);
2194if (!empty($arrayfields[
'c.multicurrency_total_ht'][
'checked'])) {
2195 print_liste_field_titre($arrayfields[
'c.multicurrency_total_ht'][
'label'], $_SERVER[
'PHP_SELF'],
'c.multicurrency_total_ht',
'', $param,
'class="right"', $sortfield, $sortorder);
2198if (!empty($arrayfields[
'c.multicurrency_total_vat'][
'checked'])) {
2199 print_liste_field_titre($arrayfields[
'c.multicurrency_total_vat'][
'label'], $_SERVER[
'PHP_SELF'],
'c.multicurrency_total_tva',
'', $param,
'class="right"', $sortfield, $sortorder);
2202if (!empty($arrayfields[
'c.multicurrency_total_ttc'][
'checked'])) {
2203 print_liste_field_titre($arrayfields[
'c.multicurrency_total_ttc'][
'label'], $_SERVER[
'PHP_SELF'],
'c.multicurrency_total_ttc',
'', $param,
'class="right"', $sortfield, $sortorder);
2206if (!empty($arrayfields[
'u.login'][
'checked'])) {
2207 print_liste_field_titre($arrayfields[
'u.login'][
'label'], $_SERVER[
"PHP_SELF"],
'u.login',
'', $param,
'', $sortfield, $sortorder);
2210if (!empty($arrayfields[
'sale_representative'][
'checked'])) {
2211 print_liste_field_titre($arrayfields[
'sale_representative'][
'label'], $_SERVER[
"PHP_SELF"],
"",
"",
"$param",
'', $sortfield, $sortorder);
2214if (!empty($arrayfields[
'total_pa'][
'checked'])) {
2215 print_liste_field_titre($arrayfields[
'total_pa'][
'label'], $_SERVER[
'PHP_SELF'],
'',
'', $param,
'class="right"', $sortfield, $sortorder);
2218if (!empty($arrayfields[
'total_margin'][
'checked'])) {
2219 print_liste_field_titre($arrayfields[
'total_margin'][
'label'], $_SERVER[
'PHP_SELF'],
'',
'', $param,
'class="right"', $sortfield, $sortorder);
2222if (!empty($arrayfields[
'total_margin_rate'][
'checked'])) {
2223 print_liste_field_titre($arrayfields[
'total_margin_rate'][
'label'], $_SERVER[
'PHP_SELF'],
'',
'', $param,
'class="right"', $sortfield, $sortorder);
2226if (!empty($arrayfields[
'total_mark_rate'][
'checked'])) {
2227 print_liste_field_titre($arrayfields[
'total_mark_rate'][
'label'], $_SERVER[
'PHP_SELF'],
'',
'', $param,
'class="right"', $sortfield, $sortorder);
2231if (!empty($arrayfields[
'c.datec'][
'checked'])) {
2232 print_liste_field_titre($arrayfields[
'c.datec'][
'label'], $_SERVER[
"PHP_SELF"],
"c.date_creation",
"", $param,
'', $sortfield, $sortorder,
'center nowrap ');
2235if (!empty($arrayfields[
'c.tms'][
'checked'])) {
2236 print_liste_field_titre($arrayfields[
'c.tms'][
'label'], $_SERVER[
"PHP_SELF"],
"c.tms",
"", $param,
'', $sortfield, $sortorder,
'center nowrap ');
2239if (!empty($arrayfields[
'c.date_cloture'][
'checked'])) {
2240 print_liste_field_titre($arrayfields[
'c.date_cloture'][
'label'], $_SERVER[
"PHP_SELF"],
"c.date_cloture",
"", $param,
'', $sortfield, $sortorder,
'center nowrap ');
2243if (!empty($arrayfields[
'c.note_public'][
'checked'])) {
2244 print_liste_field_titre($arrayfields[
'c.note_public'][
'label'], $_SERVER[
"PHP_SELF"],
"c.note_public",
"", $param,
'', $sortfield, $sortorder,
'');
2247if (!empty($arrayfields[
'c.note_private'][
'checked'])) {
2248 print_liste_field_titre($arrayfields[
'c.note_private'][
'label'], $_SERVER[
"PHP_SELF"],
"c.note_private",
"", $param,
'', $sortfield, $sortorder,
'');
2251if (!empty($arrayfields[
'shippable'][
'checked'])) {
2252 print_liste_field_titre($arrayfields[
'shippable'][
'label'], $_SERVER[
"PHP_SELF"],
'',
'', $param,
'', $sortfield, $sortorder,
'center ');
2256include DOL_DOCUMENT_ROOT.
'/core/tpl/extrafields_list_search_title.tpl.php';
2259$parameters = array(
'arrayfields' => $arrayfields,
'param' => $param,
'sortfield' => $sortfield,
'sortorder' => $sortorder,
'totalarray' => &$totalarray);
2260$reshook = $hookmanager->executeHooks(
'printFieldListTitle', $parameters, $object, $action);
2261print $hookmanager->resPrint;
2264if (!empty($arrayfields[
'c.facture'][
'checked'])) {
2265 print_liste_field_titre($arrayfields[
'c.facture'][
'label'], $_SERVER[
"PHP_SELF"],
'c.facture',
'', $param,
'', $sortfield, $sortorder,
'center ');
2269if (!empty($arrayfields[
'c.import_key'][
'checked'])) {
2270 print_liste_field_titre($arrayfields[
'c.import_key'][
'label'], $_SERVER[
"PHP_SELF"],
"c.import_key",
"", $param,
'', $sortfield, $sortorder,
'center ');
2274if (!empty($arrayfields[
'c.fk_statut'][
'checked'])) {
2275 print_liste_field_titre($arrayfields[
'c.fk_statut'][
'label'], $_SERVER[
"PHP_SELF"],
"c.fk_statut",
"", $param,
'', $sortfield, $sortorder,
'center ');
2280 print_liste_field_titre($selectedfields, $_SERVER[
"PHP_SELF"],
"",
'', $param,
'', $sortfield, $sortorder,
'maxwidthsearch center ');
2287$productstat_cache = array();
2288$productstat_cachevirtual = array();
2289$getNomUrl_cache = array();
2291$generic_commande =
new Commande($db);
2292$generic_product =
new Product($db);
2293$userstatic =
new User($db);
2295$with_margin_info =
false;
2296if (isModEnabled(
'margin') && (
2297 !empty($arrayfields[
'total_pa'][
'checked'])
2298 || !empty($arrayfields[
'total_margin'][
'checked'])
2299 || !empty($arrayfields[
'total_margin_rate'][
'checked'])
2300 || !empty($arrayfields[
'total_mark_rate'][
'checked'])
2303 $with_margin_info =
true;
2315$imaxinloop = ($limit ? min($num, $limit) : $num);
2316while ($i < $imaxinloop) {
2317 $obj = $db->fetch_object($resql);
2322 $typenArray = $formcompany->typent_array(1);
2330 $companystatic->id = $obj->socid;
2331 $companystatic->name = $obj->name;
2332 $companystatic->name_alias = $obj->alias;
2333 $companystatic->client = $obj->client;
2334 $companystatic->fournisseur = $obj->fournisseur;
2335 $companystatic->code_client = $obj->code_client;
2336 $companystatic->email = $obj->email;
2337 $companystatic->phone = $obj->phone;
2338 $companystatic->address = $obj->address;
2339 $companystatic->zip = $obj->zip;
2340 $companystatic->town = $obj->town;
2341 $companystatic->country_code = $obj->country_code;
2342 if (!isset($getNomUrl_cache[$obj->socid])) {
2343 $getNomUrl_cache[$obj->socid] = $companystatic->getNomUrl(1,
'customer', 100, 0, 1, empty($arrayfields[
's.name_alias'][
'checked']) ? 0 : 1);
2346 $generic_commande->id = $obj->rowid;
2347 $generic_commande->ref = $obj->ref;
2348 $generic_commande->status = $obj->fk_statut;
2349 $generic_commande->statut = $obj->fk_statut;
2350 $generic_commande->status = $obj->fk_statut;
2351 $generic_commande->billed = $obj->billed;
2352 $generic_commande->date = $db->jdate($obj->date_commande);
2353 $generic_commande->delivery_date = $db->jdate($obj->delivery_date);
2354 $generic_commande->ref_client = $obj->ref_client;
2355 $generic_commande->total_ht = $obj->total_ht;
2356 $generic_commande->total_tva = $obj->total_tva;
2357 $generic_commande->total_ttc = $obj->total_ttc;
2358 $generic_commande->note_public = $obj->note_public;
2359 $generic_commande->note_private = $obj->note_private;
2361 $generic_commande->thirdparty = $companystatic;
2364 $projectstatic->id = $obj->project_id;
2365 $projectstatic->ref = $obj->project_ref;
2366 $projectstatic->title = $obj->project_label;
2368 $marginInfo = array();
2369 if ($with_margin_info) {
2370 $generic_commande->fetch_lines();
2371 $marginInfo = $formmargin->getMarginInfosArray($generic_commande);
2372 $total_ht += $obj->total_ht;
2373 $total_margin += $marginInfo[
'total_margin'];
2376 if ($mode ==
'kanban') {
2378 print
'<tr class="trkanban"><td colspan="'.$savnbfield.
'">';
2379 print
'<div class="box-flex-container kanban">';
2384 if ($massactionbutton || $massaction) {
2386 if (in_array(
$object->id, $arrayofselected)) {
2390 print $generic_commande->getKanbanView(
'', array(
'selected' => $selected));
2391 if ($i == ($imaxinloop - 1)) {
2398 print
'<tr data-rowid="'.$object->id.
'" class="oddeven status'.$generic_commande->status.((getDolGlobalInt(
'MAIN_FINISHED_LINES_OPACITY') == 1 && $obj->status > 1) ?
' opacitymedium' :
'').
'">';
2402 print
'<td class="nowrap center">';
2403 if ($massactionbutton || $massaction) {
2405 if (in_array($obj->rowid, $arrayofselected)) {
2408 print
'<input id="cb'.$obj->rowid.
'" class="flat checkforselect" type="checkbox" name="toselect[]" value="'.$obj->rowid.
'"'.($selected ?
' checked="checked"' :
'').
'>';
2417 if (!empty($arrayfields[
'c.rowid'][
'checked'])) {
2418 print
'<td class="center" data-key="id">'.$obj->rowid.
'</td>';
2425 if (!empty($arrayfields[
'c.ref'][
'checked'])) {
2426 print
'<td class="nowraponall">';
2427 $getNomUrlOption = $search_status != 2 ? 0 : $obj->fk_statut;
2433 $getNomUrlOption =
'';
2435 print $generic_commande->getNomUrl(1, $getNomUrlOption, 0, 0, 0, 1, 1);
2439 $urlsource = $_SERVER[
'PHP_SELF'].
'?id='.$obj->rowid;
2440 print $formfile->getDocumentsLink($generic_commande->element, $filename, $filedir);
2449 if (!empty($arrayfields[
'c.ref_ext'][
'checked'])) {
2450 print
'<td class="nowrap tdoverflowmax75" title="'.dol_escape_htmltag($obj->ref_ext).
'">';
2459 if (!empty($arrayfields[
'c.ref_client'][
'checked'])) {
2460 print
'<td class="nowrap tdoverflowmax150" title="'.dol_escape_htmltag($obj->ref_client).
'">';
2469 if (!empty($arrayfields[
'p.ref'][
'checked'])) {
2470 print
'<td class="nocellnopadd nowraponall">';
2471 if ($obj->project_id > 0) {
2472 print $projectstatic->getNomUrl(1);
2481 if (!empty($arrayfields[
'p.title'][
'checked'])) {
2482 print
'<td class="nowraponall">';
2483 if ($obj->project_id > 0) {
2484 print $projectstatic->title;
2493 if (!empty($arrayfields[
's.nom'][
'checked'])) {
2494 print
'<td class="tdoverflowmax150">';
2496 print $companystatic->getNomUrl(1,
'customer', 100, 0, 1, empty($arrayfields[
's.name_alias'][
'checked']) ? 0 : 1);
2498 print $getNomUrl_cache[$obj->socid];
2503 if ($user->hasRight(
'facture',
'creer')) {
2504 if (($obj->fk_statut > 0 && $obj->fk_statut < 3) || ($obj->fk_statut == 3 && $obj->billed == 0)) {
2505 print
' <a href="'.DOL_URL_ROOT.
'/commande/list.php?socid='.$companystatic->id.
'&search_billed=0&autoselectall=1">';
2506 print
img_picto($langs->trans(
"CreateInvoiceForThisCustomer").
' : '.$companystatic->name,
'object_bill',
'hideonsmartphone').
'</a>';
2517 if (!empty($arrayfields[
's.name_alias'][
'checked'])) {
2518 print
'<td class="nocellnopadd tdoverflowmax100" title="'.dolPrintHTMLForTextArea($obj->alias).
'">';
2527 if (!empty($arrayfields[
's2.nom'][
'checked'])) {
2528 print
'<td class="tdoverflowmax200">';
2529 if ($obj->fk_parent > 0) {
2530 if (!isset($company_url_list[$obj->fk_parent])) {
2531 $companyparent =
new Societe($db);
2532 $res = $companyparent->fetch($obj->fk_parent);
2534 $company_url_list[$obj->fk_parent] = $companyparent->getNomUrl(1);
2537 if (isset($company_url_list[$obj->fk_parent])) {
2538 print $company_url_list[$obj->fk_parent];
2548 if (!empty($arrayfields[
's.town'][
'checked'])) {
2549 print
'<td class="tdoverflowmax100" title="'.dolPrintHTMLForTextArea($obj->town).
'">';
2558 if (!empty($arrayfields[
's.zip'][
'checked'])) {
2559 print
'<td class="tdoverflowmax100" title="'.dolPrintHTMLForTextArea($obj->zip).
'">';
2568 if (!empty($arrayfields[
'state.nom'][
'checked'])) {
2569 print
'<td class="tdoverflowmax100" title="'.dolPrintHTMLForTextArea($obj->state_name).
'">'.
dolPrintLabel($obj->state_name).
"</td>\n";
2576 if (!empty($arrayfields[
'country.code_iso'][
'checked'])) {
2577 print
'<td class="center tdoverflowmax100">';
2578 $tmparray =
getCountry($obj->fk_pays,
'all');
2579 print $tmparray[
'label'];
2587 if (!empty($arrayfields[
'typent.code'][
'checked'])) {
2588 if (!is_array($typenArray) || count($typenArray) == 0) {
2589 $typenArray = $formcompany->typent_array(1);
2591 if (!empty($obj->typent_code)) {
2592 print
'<td class="center tdoverflowmax100" title="'.dolPrintHTMLForAttribute($typenArray[$obj->typent_code]).
'">';
2593 print $typenArray[$obj->typent_code];
2595 print
'<td class="center tdoverflowmax100">';
2605 if (!empty($arrayfields[
'c.date_commande'][
'checked'])) {
2606 print
'<td class="center nowraponall">';
2609 if ($generic_commande->hasDelay()) {
2610 print
img_picto($langs->trans(
"Late").
' : '.$generic_commande->showDelay(),
"warning");
2619 if (!empty($arrayfields[
'c.delivery_date'][
'checked'])) {
2620 print
'<td class="center nowraponall">';
2621 print
dol_print_date($db->jdate($obj->delivery_date),
'dayhour');
2629 if (!empty($arrayfields[
'c.fk_shipping_method'][
'checked'])) {
2631 $form->formSelectShippingMethod(
'', $obj->fk_shipping_method,
'none', 1);
2639 if (!empty($arrayfields[
'c.fk_cond_reglement'][
'checked'])) {
2641 $form->form_conditions_reglement($_SERVER[
'PHP_SELF'], $obj->fk_cond_reglement,
'none', 0,
'', 1, $obj->deposit_percent);
2649 if (!empty($arrayfields[
'c.fk_mode_reglement'][
'checked'])) {
2651 $form->form_modes_reglement($_SERVER[
'PHP_SELF'], $obj->fk_mode_reglement,
'none',
'', -1);
2659 if (!empty($arrayfields[
'c.fk_input_reason'][
'checked'])) {
2661 $form->formInputReason($_SERVER[
'PHP_SELF'], $obj->fk_input_reason,
'none', 0);
2669 if (!empty($arrayfields[
'c.module_source'][
'checked'])) {
2678 if (!empty($arrayfields[
'c.pos_source'][
'checked'])) {
2688 if (!empty($arrayfields[
'c.total_ht'][
'checked'])) {
2689 print
'<td class="nowraponall right"><span class="amount">'.price($obj->total_ht).
"</span></td>\n";
2696 if (isset($totalarray[
'val'][
'c.total_ht'])) {
2697 $totalarray[
'val'][
'c.total_ht'] += $obj->total_ht;
2699 $totalarray[
'val'][
'c.total_ht'] = $obj->total_ht;
2704 if (!empty($arrayfields[
'c.total_vat'][
'checked'])) {
2705 print
'<td class="nowrap right"><span class="amount">'.price($obj->total_tva).
"</span></td>\n";
2712 if (isset($totalarray[
'val'][
'c.total_tva'])) {
2713 $totalarray[
'val'][
'c.total_tva'] += $obj->total_tva;
2715 $totalarray[
'val'][
'c.total_tva'] = $obj->total_tva;
2720 if (!empty($arrayfields[
'c.total_ttc'][
'checked'])) {
2721 print
'<td class="nowrap right"><span class="amount">'.price($obj->total_ttc).
"</span></td>\n";
2728 if (isset($totalarray[
'val'][
'c.total_ttc'])) {
2729 $totalarray[
'val'][
'c.total_ttc'] += $obj->total_ttc;
2731 $totalarray[
'val'][
'c.total_ttc'] = $obj->total_ttc;
2736 if (!empty($arrayfields[
'c.multicurrency_code'][
'checked'])) {
2737 print
'<td class="nowrap">'.$obj->multicurrency_code.
' - '.$langs->trans(
'Currency'.$obj->multicurrency_code).
"</td>\n";
2744 if (!empty($arrayfields[
'c.multicurrency_tx'][
'checked'])) {
2745 print
'<td class="nowrap">';
2746 $form->form_multicurrency_rate($_SERVER[
'PHP_SELF'].
'?id='.$obj->rowid, $obj->multicurrency_tx,
'none', $obj->multicurrency_code);
2754 if (!empty($arrayfields[
'c.multicurrency_total_ht'][
'checked'])) {
2755 print
'<td class="right nowrap"><span class="amount">'.price($obj->multicurrency_total_ht).
"</span></td>\n";
2761 if (!empty($arrayfields[
'c.multicurrency_total_vat'][
'checked'])) {
2762 print
'<td class="right nowrap"><span class="amount">'.price($obj->multicurrency_total_vat).
"</span></td>\n";
2768 if (!empty($arrayfields[
'c.multicurrency_total_ttc'][
'checked'])) {
2769 print
'<td class="right nowrap"><span class="amount">'.price($obj->multicurrency_total_ttc).
"</span></td>\n";
2775 $userstatic->id = $obj->fk_user_author;
2776 $userstatic->login = $obj->login;
2777 $userstatic->lastname = $obj->lastname;
2778 $userstatic->firstname = $obj->firstname;
2779 $userstatic->email = $obj->user_email;
2780 $userstatic->status = $obj->user_statut;
2781 $userstatic->entity = $obj->entity;
2782 $userstatic->photo = $obj->photo;
2783 $userstatic->office_phone = $obj->office_phone;
2784 $userstatic->office_fax = $obj->office_fax;
2785 $userstatic->user_mobile = $obj->user_mobile;
2786 $userstatic->job = $obj->job;
2787 $userstatic->gender = $obj->gender;
2790 if (!empty($arrayfields[
'u.login'][
'checked'])) {
2791 print
'<td class="tdoverflowmax125">';
2792 if ($userstatic->id) {
2793 print $userstatic->getNomUrl(-1);
2804 if (!empty($arrayfields[
'sale_representative'][
'checked'])) {
2806 if ($obj->socid > 0) {
2807 $listsalesrepresentatives = $companystatic->getSalesRepresentatives($user);
2808 if ($listsalesrepresentatives < 0) {
2811 $nbofsalesrepresentative = count($listsalesrepresentatives);
2812 if ($nbofsalesrepresentative > 6) {
2814 print $nbofsalesrepresentative;
2815 } elseif ($nbofsalesrepresentative > 0) {
2817 foreach ($listsalesrepresentatives as $val) {
2818 $userstatic->id = $val[
'id'];
2819 $userstatic->lastname = $val[
'lastname'];
2820 $userstatic->firstname = $val[
'firstname'];
2821 $userstatic->email = $val[
'email'];
2822 $userstatic->status = $val[
'statut'];
2823 $userstatic->entity = $val[
'entity'];
2824 $userstatic->photo = $val[
'photo'];
2825 $userstatic->login = $val[
'login'];
2826 $userstatic->office_phone = $val[
'office_phone'];
2827 $userstatic->office_fax = $val[
'office_fax'];
2828 $userstatic->user_mobile = $val[
'user_mobile'];
2829 $userstatic->job = $val[
'job'];
2830 $userstatic->gender = $val[
'gender'];
2832 print ($nbofsalesrepresentative < 2) ? $userstatic->getNomUrl(-1,
'', 0, 0, 12) : $userstatic->getNomUrl(-2);
2834 if ($j < $nbofsalesrepresentative) {
2851 if (!empty($arrayfields[
'total_pa'][
'checked'])) {
2852 print
'<td class="right nowrap">'.price($marginInfo[
'pa_total']).
'</td>';
2859 if (!empty($arrayfields[
'total_margin'][
'checked'])) {
2860 print
'<td class="right nowrap">'.price($marginInfo[
'total_margin']).
'</td>';
2868 if (!isset($totalarray[
'val'][
'total_margin'])) {
2872 $totalarray[
'val'][
'total_margin'] += $marginInfo[
'total_margin'];
2876 if (!empty($arrayfields[
'total_margin_rate'][
'checked'])) {
2877 print
'<td class="right nowrap">'.(($marginInfo[
'total_margin_rate'] ==
'') ?
'' :
price($marginInfo[
'total_margin_rate'], 0,
'', 0, 0, 2).
'%').
'</td>';
2884 if (!empty($arrayfields[
'total_mark_rate'][
'checked'])) {
2885 print
'<td class="right nowrap">'.(($marginInfo[
'total_mark_rate'] ==
'') ?
'' :
price($marginInfo[
'total_mark_rate'], 0,
'', 0, 0, 2).
'%').
'</td>';
2892 if ($i >= $imaxinloop - 1) {
2893 if (!empty($total_ht)) {
2902 if (!empty($arrayfields[
'c.datec'][
'checked'])) {
2903 print
'<td class="center nowraponall">';
2904 print
dol_print_date($db->jdate($obj->date_creation),
'dayhour',
'tzuserrel');
2912 if (!empty($arrayfields[
'c.tms'][
'checked'])) {
2913 print
'<td class="center nowraponall">';
2914 print
dol_print_date($db->jdate($obj->date_modification),
'dayhour',
'tzuserrel');
2922 if (!empty($arrayfields[
'c.date_cloture'][
'checked'])) {
2923 print
'<td class="center nowraponall">';
2924 print
dol_print_date($db->jdate($obj->date_cloture),
'dayhour',
'tzuserrel');
2932 if (!empty($arrayfields[
'c.note_public'][
'checked'])) {
2933 print
'<td class="sensiblehtmlcontent maxwidth250imp classfortooltip" title="'.dolPrintHTMLForAttribute(
dolGetFirstLineOfText($obj->note_public, 20)).
'">';
2934 print
'<div class="small lineheightsmall twolinesmax-normallineheight">'.dolPrintHTML(
dolGetFirstLineOfText($obj->note_public, 5)).
'</div>';
2942 if (!empty($arrayfields[
'c.note_private'][
'checked'])) {
2943 print
'<td class="sensiblehtmlcontent maxwidth250imp classfortooltip" title="'.dolPrintHTMLForAttribute(
dolGetFirstLineOfText($obj->note_private, 20)).
'">';
2944 print
'<div class="small lineheightsmall twolinesmax-normallineheight">'.dolPrintHTML(
dolGetFirstLineOfText($obj->note_private, 5)).
'</div>';
2952 if (!empty($arrayfields[
'shippable'][
'checked'])) {
2953 print
'<td class="center">';
2954 if (!empty($show_shippable_command) && isModEnabled(
'stock')) {
2956 if (($obj->fk_statut > $generic_commande::STATUS_DRAFT) && ($obj->fk_statut < $generic_commande::STATUS_CLOSED)) {
2957 $generic_commande->getLinesArray();
2958 $generic_commande->loadExpeditions();
2960 $numlines = count($generic_commande->lines);
2961 for ($lig = 0; $lig < $numlines; $lig++) {
2962 $orderLine = $generic_commande->lines[$lig];
2963 '@phan-var-force OrderLine $orderLine';
2964 if (isset($generic_commande->expeditions[$orderLine->id])) {
2965 $reliquat = $orderLine->qty - $generic_commande->expeditions[$orderLine->id];
2967 $reliquat = $orderLine->qty;
2969 if ($orderLine->product_type == 0 && $orderLine->fk_product > 0) {
2971 $generic_product->id = $orderLine->fk_product;
2974 if (empty($productstat_cache[$orderLine->fk_product])) {
2975 $generic_product->load_stock(
'nobatch,warehouseopen');
2976 $productstat_cache[$orderLine->fk_product][
'stock_reel'] = $generic_product->stock_reel;
2977 $productstat_cachevirtual[$orderLine->fk_product][
'stock_reel'] = $generic_product->stock_theorique;
2979 $generic_product->stock_reel = $productstat_cache[$orderLine->fk_product][
'stock_reel'];
2981 $generic_product->stock_theorique = $productstat_cachevirtual[$orderLine->fk_product][
'stock_reel'];
2984 if ($reliquat > $generic_product->stock_reel) {
2988 $text_info .= $reliquat.
' x '.$orderLine->product_ref.
' '.
dol_trunc($orderLine->product_label, 20);
2989 $text_info .=
' - '.$langs->trans(
"Stock").
': <span class="'.($generic_product->stock_reel > 0 ?
'ok' :
'error').
'">'.$generic_product->stock_reel.
'</span>';
2990 $text_info .=
' - '.$langs->trans(
"VirtualStock").
': <span class="'.($generic_product->stock_theorique > 0 ?
'ok' :
'error').
'">'.$generic_product->stock_theorique.
'</span>';
2991 $text_info .= ($reliquat != $orderLine->qty ?
' <span class="opacitymedium">('.$langs->trans(
"QtyInOtherShipments").
' '.($orderLine->qty - $reliquat).
')</span>' :
'');
2992 $text_info .=
'<br>';
2999 $stock_order_supplier = 0;
3001 if (isModEnabled(
'order')) {
3002 if (empty($productstat_cache[$orderLine->fk_product][
'stats_order_customer'])) {
3003 $generic_product->load_stats_commande(0,
'1,2');
3004 $productstat_cache[$orderLine->fk_product][
'stats_order_customer'] = $generic_product->stats_commande[
'qty'];
3007 $generic_product->stats_commande[
'qty'] = $productstat_cache[$orderLine->fk_product][
'stats_order_customer'];
3009 $stock_order = $generic_product->stats_commande[
'qty'];
3011 if (isModEnabled(
"supplier_order")) {
3012 if (empty($productstat_cache[$orderLine->fk_product][
'stats_order_supplier'])) {
3013 $generic_product->load_stats_commande_fournisseur(0,
'3');
3014 $productstat_cache[$orderLine->fk_product][
'stats_order_supplier'] = $generic_product->stats_commande_fournisseur[
'qty'];
3017 $generic_product->stats_commande_fournisseur[
'qty'] = $productstat_cache[$orderLine->fk_product][
'stats_order_supplier'];
3019 $stock_order_supplier = $generic_product->stats_commande_fournisseur[
'qty'];
3022 $text_info .= $reliquat.
' x '.$orderLine->ref.
' '.
dol_trunc($orderLine->product_label, 20);
3023 $text_stock_reel = $generic_product->stock_reel.
'/'.$stock_order;
3024 if ($stock_order > $generic_product->stock_reel && !($generic_product->stock_reel < $orderLine->qty)) {
3026 $text_warning .=
'<span class="warning">'.$langs->trans(
'Available').
' : '.$text_stock_reel.
'</span>';
3028 if ($reliquat > $generic_product->stock_reel) {
3029 $text_info .=
'<span class="warning">'.$langs->trans(
'Available').
' : '.$text_stock_reel.
'</span>';
3031 $text_info .=
'<span class="ok">'.$langs->trans(
'Available').
' : '.$text_stock_reel.
'</span>';
3033 if (isModEnabled(
"supplier_order")) {
3034 $text_info .=
' '.$langs->trans(
'SupplierOrder').
' : '.$stock_order_supplier;
3036 $text_info .= ($reliquat != $orderLine->qty ?
' <span class="opacitymedium">('.$langs->trans(
"QtyInOtherShipments").
' '.($orderLine->qty - $reliquat).
')</span>' :
'');
3037 $text_info .=
'<br>';
3041 if ($notshippable == 0) {
3042 $text_icon =
img_picto(
'',
'dolly',
'', 0, 0, 0,
'',
'green paddingleft');
3043 $text_info = $text_icon.
' '.$langs->trans(
'Shippable').
'<br>'.$text_info;
3045 $text_icon =
img_picto(
'',
'dolly',
'', 0, 0, 0,
'',
'error paddingleft');
3046 $text_info = $text_icon.
' '.$langs->trans(
'NonShippable').
'<br>'.$text_info;
3051 print
'<a href="'.DOL_URL_ROOT.
'/expedition/shipment.php?id='.((int) $obj->rowid).
'">';
3052 print $form->textwithtooltip(
'', $text_info, 2, 1, $text_icon,
'', 2);
3056 print $form->textwithtooltip(
'', $langs->trans(
'NotEnoughForAllOrders').
'<br>'.$text_warning, 2, 1,
img_picto(
'',
'error'),
'', 2);
3066 include DOL_DOCUMENT_ROOT.
'/core/tpl/extrafields_list_print_fields.tpl.php';
3068 $parameters = array(
'arrayfields' => $arrayfields,
'obj' => $obj,
'i' => $i,
'totalarray' => &$totalarray);
3069 $reshook = $hookmanager->executeHooks(
'printFieldListValue', $parameters, $object, $action);
3070 print $hookmanager->resPrint;
3073 if (!empty($arrayfields[
'c.facture'][
'checked'])) {
3074 print
'<td class="center">';
3076 print
yn($obj->billed, $langs->trans(
"Billed"));
3085 if (!empty($arrayfields[
'c.import_key'][
'checked'])) {
3086 print
'<td class="nowrap center">'.dol_escape_htmltag($obj->import_key).
'</td>';
3093 if (!empty($arrayfields[
'c.fk_statut'][
'checked'])) {
3094 print
'<td class="nowrap center">'.$generic_commande->LibStatut($obj->fk_statut, $obj->billed, 5, 1).
'</td>';
3102 print
'<td class="nowrap center">';
3103 if ($massactionbutton || $massaction) {
3105 if (in_array($obj->rowid, $arrayofselected)) {
3108 print
'<input id="cb'.$obj->rowid.
'" class="flat checkforselect" type="checkbox" name="toselect[]" value="'.$obj->rowid.
'"'.($selected ?
' checked="checked"' :
'').
'>';
3118 $total += $obj->total_ht;
3119 $subtotal += $obj->total_ht;
3125include DOL_DOCUMENT_ROOT.
'/core/tpl/list_print_total.tpl.php';
3130 foreach ($arrayfields as $key => $val) {
3131 if (!empty($val[
'checked'])) {
3135 print
'<tr><td colspan="'.$colspan.
'"><span class="opacitymedium">'.$langs->trans(
"NoRecordFound").
'</span></td></tr>';
3140$parameters = array(
'arrayfields' => $arrayfields,
'sql' => $sql);
3141$reshook = $hookmanager->executeHooks(
'printFieldListFooter', $parameters, $object, $action);
3142print $hookmanager->resPrint;
3144print
'</table>'.
"\n";
3147print
'</form>'.
"\n";
3149if (in_array(
'builddoc', array_keys($arrayofmassactions)) && ($nbtotalofrecords ===
'' || $nbtotalofrecords)) {
3150 $hidegeneratedfilelistifempty = 1;
3151 if ($massaction ==
'builddoc' || $action ==
'remove_file' || $show_files) {
3152 $hidegeneratedfilelistifempty = 0;
3156 $urlsource = $_SERVER[
'PHP_SELF'].
'?sortfield='.$sortfield.
'&sortorder='.$sortorder;
3157 $urlsource .= str_replace(
'&',
'&', $param);
3159 $filedir = $diroutputmassaction;
3160 $genallowed = $permissiontoread;
3161 $delallowed = $permissiontoadd;
3163 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( $user->socid > 0) if(! $user->hasRight('accounting', 'chartofaccount')) $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_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.
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.
natural_search($fields, $value, $mode=0, $nofirstand=0)
Generate natural SQL search string for a criteria (this criteria can be tested on one or several fiel...
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.
dol_now($mode='auto')
Return date for now.
getDolGlobalInt($key, $default=0)
Return a Dolibarr global constant int value.
dol_print_date($time, $format='', $tzoutput='auto', $outputlangs=null, $encodetooutput=false)
Output date in a string format according to outputlangs (or langs if not defined).
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_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.
dol_sanitizeFileName($str, $newstr='_', $unaccent=1, $includequotes=0)
Clean a string to use it as a file name.
getDolGlobalString($key, $default='')
Return a Dolibarr global constant string value.
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...
global $conf
The following vars must be defined: $type2label $form $conf, $lang, The following vars may also be de...
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.