44require
'../main.inc.php';
54require_once DOL_DOCUMENT_ROOT.
'/core/lib/date.lib.php';
55require_once DOL_DOCUMENT_ROOT.
'/core/lib/company.lib.php';
56require_once DOL_DOCUMENT_ROOT.
'/core/class/discount.class.php';
57require_once DOL_DOCUMENT_ROOT.
'/core/class/html.formfile.class.php';
58require_once DOL_DOCUMENT_ROOT.
'/core/class/html.formother.class.php';
59require_once DOL_DOCUMENT_ROOT.
'/core/class/html.formcompany.class.php';
61 require_once DOL_DOCUMENT_ROOT.
'/core/class/html.formmargin.class.php';
63require_once DOL_DOCUMENT_ROOT.
'/commande/class/commande.class.php';
64require_once DOL_DOCUMENT_ROOT.
'/compta/facture/class/facture.class.php';
65require_once DOL_DOCUMENT_ROOT.
'/product/class/product.class.php';
66require_once DOL_DOCUMENT_ROOT.
'/product/class/html.formproduct.class.php';
67require_once DOL_DOCUMENT_ROOT.
'/projet/class/project.class.php';
70 require_once DOL_DOCUMENT_ROOT.
'/categories/class/categorie.class.php';
71 require_once DOL_DOCUMENT_ROOT.
'/core/class/html.formcategory.class.php';
75$langs->loadLangs(array(
'orders',
'sendings',
'companies',
'compta',
'bills',
'stocks',
'products'));
78$action =
GETPOST(
'action',
'aZ09');
79$massaction =
GETPOST(
'massaction',
'alpha');
81$confirm =
GETPOST(
'confirm',
'alpha');
82$toselect =
GETPOST(
'toselect',
'array:int');
83$contextpage =
GETPOST(
'contextpage',
'aZ') ?
GETPOST(
'contextpage',
'aZ') :
'orderlist';
84$optioncss =
GETPOST(
'optioncss',
'alpha');
88 $userschilds = $user->getAllChildIds();
90 $userschilds = array();
94$search_datecloture_start =
GETPOSTINT(
'search_datecloture_start');
95if (empty($search_datecloture_start)) {
98$search_datecloture_end =
GETPOSTINT(
'search_datecloture_end');
99if (empty($search_datecloture_end)) {
109$search_all = trim(
GETPOST(
'search_all',
'alphanohtml'));
110$searchCategoryOrderOperator = 0;
112 $searchCategoryOrderOperator =
GETPOSTINT(
'search_category_order_operator');
116$searchCategoryOrderList =
GETPOST(
'search_category_order_list',
'array');
117$search_product_category =
GETPOST(
'search_product_category',
'intcomma');
118$search_id =
GETPOST(
'search_id',
'int');
119$search_ref =
GETPOST(
'search_ref',
'alpha') !=
'' ?
GETPOST(
'search_ref',
'alpha') :
GETPOST(
'sref',
'alpha');
120$search_ref_ext =
GETPOST(
'search_ref_ext',
'alpha');
121$search_ref_customer =
GETPOST(
'search_ref_customer',
'alpha');
122$search_company =
GETPOST(
'search_company',
'alpha');
123$search_company_alias =
GETPOST(
'search_company_alias',
'alpha');
124$search_parent_name = trim(
GETPOST(
'search_parent_name',
'alphanohtml'));
125$search_town =
GETPOST(
'search_town',
'alpha');
126$search_zip =
GETPOST(
'search_zip',
'alpha');
127$search_state =
GETPOST(
'search_state',
'alpha');
128$search_country =
GETPOST(
'search_country',
'aZ09');
129$search_type_thirdparty =
GETPOST(
'search_type_thirdparty',
'intcomma');
130$search_user =
GETPOST(
'search_user',
'intcomma');
131$search_sale =
GETPOST(
'search_sale',
'intcomma');
132$search_total_ht =
GETPOST(
'search_total_ht',
'alpha');
133$search_total_vat =
GETPOST(
'search_total_vat',
'alpha');
134$search_total_ttc =
GETPOST(
'search_total_ttc',
'alpha');
135$search_warehouse =
GETPOST(
'search_warehouse',
'intcomma');
136$search_note_public =
GETPOST(
'search_note_public',
'alphanohtml');
137$search_note_private =
GETPOST(
'search_note_private',
'alphanohtml');
139$search_module_source =
GETPOST(
'search_module_source',
'alphanohtml');
140$search_pos_source =
GETPOST(
'search_pos_source',
'alphanohtml');
142$search_multicurrency_code =
GETPOST(
'search_multicurrency_code',
'alpha');
143$search_multicurrency_tx =
GETPOST(
'search_multicurrency_tx',
'alpha');
144$search_multicurrency_montant_ht =
GETPOST(
'search_multicurrency_montant_ht',
'alpha');
145$search_multicurrency_montant_vat =
GETPOST(
'search_multicurrency_montant_vat',
'alpha');
146$search_multicurrency_montant_ttc =
GETPOST(
'search_multicurrency_montant_ttc',
'alpha');
148$search_login =
GETPOST(
'search_login',
'alpha');
149$search_categ_cus =
GETPOST(
"search_categ_cus",
'intcomma');
150$search_billed =
GETPOST(
'search_billed',
'intcomma');
151$search_status =
GETPOST(
'search_status',
'intcomma');
152$search_project_ref =
GETPOST(
'search_project_ref',
'alpha');
153$search_project =
GETPOST(
'search_project',
'alpha');
154$search_shippable =
GETPOST(
'search_shippable',
'aZ09');
156$search_fk_cond_reglement =
GETPOST(
'search_fk_cond_reglement',
'intcomma');
157$search_fk_shipping_method =
GETPOST(
'search_fk_shipping_method',
'intcomma');
158$search_fk_mode_reglement =
GETPOST(
'search_fk_mode_reglement',
'intcomma');
159$search_fk_input_reason =
GETPOST(
'search_fk_input_reason',
'intcomma');
161$search_option =
GETPOST(
'search_option',
'alpha');
162if ($search_option ==
'late') {
163 $search_status =
'-2';
165$search_orderday =
'';
166$search_ordermonth =
'';
167$search_orderyear =
'';
168$search_deliveryday =
'';
169$search_deliverymonth =
'';
170$search_deliveryyear =
'';
172$search_import_key = trim(
GETPOST(
"search_import_key",
"alpha"));
174$diroutputmassaction =
$conf->order->multidir_output[
$conf->entity].
'/temp/massgeneration/'.$user->id;
178$sortfield =
GETPOST(
'sortfield',
'aZ09comma');
179$sortorder =
GETPOST(
'sortorder',
'aZ09comma');
181if (empty($page) || $page < 0 ||
GETPOST(
'button_search',
'alpha') ||
GETPOST(
'button_removefilter',
'alpha')) {
185$offset = $limit * $page;
186$pageprev = $page - 1;
187$pagenext = $page + 1;
189 $sortfield =
'c.ref';
195$show_shippable_command =
GETPOST(
'show_shippable_command',
'aZ09');
199$hookmanager->initHooks(array(
'orderlist'));
202$extrafields->fetch_name_optionals_label(
$object->table_element);
203$search_array_options = $extrafields->getOptionalsFromPost(
$object->table_element,
'',
'search_');
206$fieldstosearchall = array(
208 'c.ref_client' =>
'RefCustomerOrder',
209 'pd.description' =>
'ProductDescription',
210 's.nom' =>
"ThirdParty",
211 's.name_alias' =>
"AliasNameShort",
214 'c.note_public' =>
'NotePublic',
216if (empty($user->socid)) {
217 $fieldstosearchall[
"c.note_private"] =
"NotePrivate";
223$checkedtypetiers =
'0';
225 'c.rowid' => array(
'label' =>
"ID",
'checked' =>
'1',
'enabled' => (
string)
getDolGlobalInt(
'MAIN_SHOW_TECHNICAL_ID'),
'position' => 1),
226 'c.ref' => array(
'label' =>
"Ref",
'checked' =>
'1',
'position' => 5,
'searchall' => 1),
227 'c.ref_ext' => array(
'label' =>
"RefExt",
'checked' =>
'1',
'position' => 5,
'visible' => 0,
'searchall' => 1),
228 'c.ref_client' => array(
'label' =>
"RefCustomerOrder",
'checked' =>
'-1',
'position' => 10,
'searchall' => 1),
229 'p.ref' => array(
'label' =>
"ProjectRef",
'langfile' =>
'projects',
'checked' =>
'-1',
'enabled' => (!
isModEnabled(
'project') ?
'0' :
'1'),
'position' => 20),
230 'p.title' => array(
'label' =>
"ProjectLabel",
'langfile' =>
'projects',
'checked' =>
'0',
'enabled' => (!
isModEnabled(
'project') ?
'0' :
'1'),
'position' => 25),
231 's.nom' => array(
'label' =>
"ThirdParty",
'checked' =>
'1',
'position' => 30,
'searchall' => 1),
232 's.name_alias' => array(
'label' =>
"AliasNameShort",
'checked' =>
'-1',
'position' => 31,
'searchall' => 1),
233 's2.nom' => array(
'label' =>
'ParentCompany',
'position' => 32,
'checked' =>
'0'),
234 's.town' => array(
'label' =>
"Town",
'checked' =>
'-1',
'position' => 35,
'searchall' => 1),
235 's.zip' => array(
'label' =>
"Zip",
'checked' =>
'-1',
'position' => 40,
'searchall' => 1),
236 'state.nom' => array(
'label' =>
"StateShort",
'checked' =>
'0',
'position' => 45),
237 'country.code_iso' => array(
'label' =>
"Country",
'checked' =>
'0',
'position' => 50),
238 'typent.code' => array(
'label' =>
"ThirdPartyType",
'checked' => (
string) $checkedtypetiers,
'position' => 55),
239 'c.date_commande' => array(
'label' =>
"OrderDateShort",
'checked' =>
'1',
'position' => 60,
'csslist' =>
'nowraponall'),
240 'c.delivery_date' => array(
'label' =>
"DateDeliveryPlanned",
'checked' =>
'1',
'enabled' => (
string) (int) !
getDolGlobalString(
'ORDER_DISABLE_DELIVERY_DATE'),
'position' => 65,
'csslist' =>
'nowraponall'),
241 'c.fk_shipping_method' => array(
'label' =>
"SendingMethod",
'checked' =>
'-1',
'position' => 66 ,
'enabled' => (
string) (int)
isModEnabled(
"shipping")),
242 'c.fk_cond_reglement' => array(
'label' =>
"PaymentConditionsShort",
'checked' =>
'-1',
'position' => 67),
243 'c.fk_mode_reglement' => array(
'label' =>
"PaymentMode",
'checked' =>
'-1',
'position' => 68),
244 'c.fk_input_reason' => array(
'label' =>
"Origin",
'checked' =>
'-1',
'position' => 69),
245 'c.module_source' => array(
'label' =>
"POSModule",
'langfile' =>
'cashdesk',
'checked' => ($contextpage ==
'poslist' ?
'1' :
'0'),
'enabled' => $showpos,
'position' => 90),
246 'c.pos_source' => array(
'label' =>
"POSTerminal",
'langfile' =>
'cashdesk',
'checked' => ($contextpage ==
'poslist' ?
'1' :
'0'),
'enabled' => $showpos,
'position' => 91),
247 'c.total_ht' => array(
'label' =>
"AmountHT",
'checked' =>
'1',
'position' => 75),
248 'c.total_vat' => array(
'label' =>
"AmountVAT",
'checked' =>
'0',
'position' => 80),
249 'c.total_ttc' => array(
'label' =>
"AmountTTC",
'checked' =>
'0',
'position' => 85),
250 'c.multicurrency_code' => array(
'label' =>
'Currency',
'checked' =>
'0',
'enabled' => (!
isModEnabled(
"multicurrency") ?
'0' :
'1'),
'position' => 92),
251 'c.multicurrency_tx' => array(
'label' =>
'CurrencyRate',
'checked' =>
'0',
'enabled' => (!
isModEnabled(
"multicurrency") ?
'0' :
'1'),
'position' => 95),
252 'c.multicurrency_total_ht' => array(
'label' =>
'MulticurrencyAmountHT',
'checked' =>
'0',
'enabled' => (!
isModEnabled(
"multicurrency") ?
'0' :
'1'),
'position' => 100),
253 'c.multicurrency_total_vat' => array(
'label' =>
'MulticurrencyAmountVAT',
'checked' =>
'0',
'enabled' => (!
isModEnabled(
"multicurrency") ?
'0' :
'1'),
'position' => 105),
254 'c.multicurrency_total_ttc' => array(
'label' =>
'MulticurrencyAmountTTC',
'checked' =>
'0',
'enabled' => (!
isModEnabled(
"multicurrency") ?
'0' :
'1'),
'position' => 110),
255 'u.login' => array(
'label' =>
"Author",
'checked' =>
'-1',
'position' => 115),
256 'sale_representative' => array(
'label' =>
"SaleRepresentativesOfThirdParty",
'checked' =>
'0',
'position' => 116),
257 '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)),
258 'total_margin' => array(
'label' =>
'Margin',
'checked' =>
'0',
'position' => 301,
'enabled' => (
string) (int) (!
isModEnabled(
'margin') || !$user->hasRight(
"margins",
"liretous") ? 0 : 1)),
259 '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)),
260 '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)),
261 'c.datec' => array(
'label' =>
"DateCreation",
'checked' =>
'0',
'position' => 120),
262 'c.tms' => array(
'label' =>
"DateModificationShort",
'checked' =>
'0',
'position' => 125),
263 'c.date_cloture' => array(
'label' =>
"DateClosing",
'checked' =>
'0',
'position' => 130),
264 'c.note_public' => array(
'label' =>
'NotePublic',
'checked' =>
'0',
'enabled' => (
string) (int) (!
getDolGlobalInt(
'MAIN_LIST_HIDE_PUBLIC_NOTES')),
'position' => 135,
'searchall' => 1),
265 'c.note_private' => array(
'label' =>
'NotePrivate',
'checked' =>
'0',
'enabled' => (
string) (int) (!
getDolGlobalInt(
'MAIN_LIST_HIDE_PRIVATE_NOTES')),
'position' => 140),
266 'shippable' => array(
'label' =>
"Shippable",
'checked' =>
'1',
'enabled' => (
string) (int) (
isModEnabled(
"shipping")),
'position' => 990),
267 'c.facture' => array(
'label' =>
"Billed",
'checked' =>
'1',
'enabled' => (
string) (int) (!
getDolGlobalString(
'WORKFLOW_BILL_ON_SHIPMENT')),
'position' => 995),
268 'c.import_key' => array(
'type' =>
'varchar(14)',
'label' =>
'ImportId',
'enabled' =>
'1',
'visible' => -2,
'position' => 999),
269 'c.fk_statut' => array(
'label' =>
"Status",
'checked' =>
'1',
'position' => 1000)
272 unset($arrayfields[
'c.note_private']);
274$parameters = array(
'fieldstosearchall' => $fieldstosearchall);
275$reshook = $hookmanager->executeHooks(
'completeFieldsToSearchAll', $parameters, $object, $action);
277 $fieldstosearchall = empty($hookmanager->resArray[
'fieldstosearchall']) ? array() : $hookmanager->resArray[
'fieldstosearchall'];
278} elseif ($reshook == 0) {
279 $fieldstosearchall = array_merge($fieldstosearchall, empty($hookmanager->resArray[
'fieldstosearchall']) ? array() : $hookmanager->resArray[
'fieldstosearchall']);
283include DOL_DOCUMENT_ROOT.
'/core/tpl/extrafields_list_array_fields.tpl.php';
286$parameters = array(
'arrayfields' => &$arrayfields);
287$reshook = $hookmanager->executeHooks(
'completeArrayFields', $parameters, $object, $action);
297 $socid = $user->socid;
300$permissiontoreadallthirdparty = $user->hasRight(
'societe',
'client',
'voir');
301$permissiontoread =
false;
302$permissiontovalidate =
false;
303$permissiontoclose =
false;
304$permissiontocancel =
false;
305$permissiontosendbymail =
false;
311$permissiontoread = $user->hasRight(
"commande",
"lire");
312$permissiontoadd = $user->hasRight(
"commande",
"creer");
313$permissiontodelete = $user->hasRight(
"commande",
"supprimer");
315 $permissiontovalidate = $user->hasRight(
"commande",
"order_advance",
"validate");
316 $permissiontoclose = $user->hasRight(
"commande",
"order_advance",
"close");
317 $permissiontocancel = $user->hasRight(
"commande",
"order_advance",
"annuler");
318 $permissiontosendbymail = $user->hasRight(
"commande",
"order_advance",
"send");
320 $permissiontovalidate = $user->hasRight(
"commande",
"creer");
321 $permissiontoclose = $user->hasRight(
"commande",
"creer");
322 $permissiontocancel = $user->hasRight(
"commande",
"creer");
323 $permissiontosendbymail = $user->hasRight(
"commande",
"creer");
333if (
GETPOST(
'cancel',
'alpha')) {
337if (!
GETPOST(
'confirmmassaction',
'alpha') && $massaction !=
'presend' && $massaction !=
'confirm_presend' && $massaction !=
'confirm_createbills') {
341$parameters = array(
'socid' => $socid,
'arrayfields' => &$arrayfields);
342$reshook = $hookmanager->executeHooks(
'doActions', $parameters, $object, $action);
347if (empty($reshook)) {
349 include DOL_DOCUMENT_ROOT.
'/core/actions_changeselectedfields.inc.php';
352 if (
GETPOST(
'button_removefilter_x',
'alpha') ||
GETPOST(
'button_removefilter.x',
'alpha') ||
GETPOST(
'button_removefilter',
'alpha')) {
355 $search_product_category =
'';
356 $searchCategoryOrderList = array();
359 $search_ref_ext =
'';
360 $search_ref_customer =
'';
361 $search_company =
'';
362 $search_company_alias =
'';
363 $search_parent_name =
'';
364 $search_module_source =
'';
365 $search_pos_source =
'';
370 $search_country =
'';
371 $search_type_thirdparty =
'';
372 $search_total_ht =
'';
373 $search_total_vat =
'';
374 $search_total_ttc =
'';
375 $search_warehouse =
'';
376 $search_note_public =
'';
377 $search_note_private =
'';
378 $search_multicurrency_code =
'';
379 $search_multicurrency_tx =
'';
380 $search_multicurrency_montant_ht =
'';
381 $search_multicurrency_montant_vat =
'';
382 $search_multicurrency_montant_ttc =
'';
384 $search_dateorder_start =
'';
385 $search_dateorder_end =
'';
386 $search_datedelivery_start =
'';
387 $search_datedelivery_end =
'';
388 $search_project_ref =
'';
389 $search_project =
'';
392 $search_datecloture_start =
'';
393 $search_datecloture_end =
'';
394 $search_fk_cond_reglement =
'';
395 $search_fk_shipping_method =
'';
396 $search_fk_mode_reglement =
'';
397 $search_fk_input_reason =
'';
399 $search_import_key =
'';
400 $search_categ_cus = 0;
404 $search_array_options = array();
406 if (
GETPOST(
'button_removefilter_x',
'alpha') ||
GETPOST(
'button_removefilter.x',
'alpha') ||
GETPOST(
'button_removefilter',
'alpha')
407 ||
GETPOST(
'button_search_x',
'alpha') ||
GETPOST(
'button_search.x',
'alpha') ||
GETPOST(
'button_search',
'alpha')) {
412 $objectclass =
'Commande';
413 $objectlabel =
'Orders';
414 $uploaddir =
$conf->order->multidir_output[
$conf->entity];
415 $triggersendname =
'ORDER_SENTBYMAIL';
418 include DOL_DOCUMENT_ROOT.
'/core/actions_massactions.inc.php';
420 if (!$error && $massaction ==
'confirm_createbills' && $user->hasRight(
'facture',
'creer')) {
422 $createbills_onebythird =
GETPOSTINT(
'createbills_onebythird');
423 $validate_invoices =
GETPOSTINT(
'validate_invoices');
428 $TFactThird = array();
429 $TFactThirdNbLines = array();
431 $nb_bills_created = 0;
437 $nbOrders = is_array($orders) ? count($orders) : 1;
440 foreach ($orders as $id_order) {
442 if ($cmd->fetch($id_order) <= 0) {
450 setEventMessages($langs->trans(
'WarningOrderNotEligibleForInvoicing', $cmd->ref),
null,
'warnings');
454 $cmd->fetch_thirdparty();
457 if (!empty($createbills_onebythird) && !empty($TFactThird[$cmd->socid])) {
460 $objecttmp = $TFactThird[$cmd->socid];
463 $objecttmp->socid = $cmd->socid;
464 $objecttmp->thirdparty = $cmd->thirdparty;
466 $objecttmp->type = $objecttmp::TYPE_STANDARD;
467 $objecttmp->cond_reglement_id = !empty($cmd->cond_reglement_id) ? $cmd->cond_reglement_id : $cmd->thirdparty->cond_reglement_id;
468 $objecttmp->mode_reglement_id = !empty($cmd->mode_reglement_id) ? $cmd->mode_reglement_id : $cmd->thirdparty->mode_reglement_id;
469 $objecttmp->demand_reason_id = !empty($cmd->demand_reason_id) ? $cmd->demand_reason_id : $cmd->thirdparty->demand_reason_id;
471 $objecttmp->fk_project = $cmd->fk_project;
473 $objecttmp->multicurrency_code = $cmd->multicurrency_code;
475 if (empty($createbills_onebythird)) {
476 $objecttmp->ref_client = $cmd->ref_client;
479 if (empty($objecttmp->note_public) &&
getDolGlobalInt(
"MAXREFONDOC", 10)>0) {
480 $objecttmp->note_public = $langs->transnoentities(
"Orders");
484 if (empty($datefacture)) {
488 $objecttmp->date = $datefacture;
489 $objecttmp->origin =
'commande';
490 $objecttmp->origin_id = (int) $id_order;
492 $objecttmp->array_options = $cmd->array_options;
494 $res = $objecttmp->create($user);
497 $objecttmp->user_creation_id = $user->id;
500 $lastref = $objecttmp->ref;
501 $lastid = $objecttmp->id;
503 $TFactThird[$cmd->socid] = $objecttmp;
504 $TFactThirdNbLines[$cmd->socid] = 0;
506 $langs->load(
"errors");
507 $errors[] = $cmd->ref.
' : '.$langs->trans($objecttmp->errors[0]);
512 if ($objecttmp->id > 0) {
513 $res = $objecttmp->add_object_linked($objecttmp->origin, $id_order);
516 $errors[] = $cmd->ref.
' : '.$langs->trans($objecttmp->errors[0]);
522 $cmd->fetchObjectLinked();
524 if (!$error && $cmd->id && !empty($cmd->linkedObjectsIds[
'shipping']) && is_array($cmd->linkedObjectsIds[
'shipping'])) {
525 $cmd->linked_objects = $cmd->linkedObjectsIds;
526 foreach ($cmd->linked_objects as $origin_type => $tmp_origin_id) {
528 if ($origin_type ==
'shipping') {
529 if (is_array($tmp_origin_id)) {
530 foreach ($tmp_origin_id as $origin_id) {
531 $res = $objecttmp->add_object_linked($origin_type, $origin_id);
533 $errors[] = $cmd->ref.
' : '.$langs->trans($objecttmp->errors[0]);
538 $origin_id = $tmp_origin_id;
539 $res = $objecttmp->add_object_linked($origin_type, $origin_id);
541 $errors[] = $cmd->ref.
' : '.$langs->trans($objecttmp->errors[0]);
551 $lines = $cmd->lines;
552 if (empty($lines) && method_exists($cmd,
'fetch_lines')) {
554 $lines = $cmd->lines;
558 $num = count($lines);
559 $array_options = array();
561 for ($i = 0; $i < $num; $i++) {
562 $desc = ($lines[$i]->desc ? $lines[$i]->desc :
'');
564 if (!empty($createbills_onebythird)) {
568 if ($lines[$i]->subprice < 0 && !
getDolGlobalString(
'INVOICE_KEEP_DISCOUNT_LINES_AS_IN_ORIGIN')) {
571 $discount->fk_soc = $objecttmp->socid;
572 $discount->socid = $objecttmp->socid;
573 $discount->amount_ht = abs($lines[$i]->total_ht);
574 $discount->amount_tva = abs($lines[$i]->total_tva);
575 $discount->amount_ttc = abs($lines[$i]->total_ttc);
576 $discount->tva_tx = $lines[$i]->tva_tx;
577 $discount->fk_user = $user->id;
578 $discount->description = $desc;
579 $discountid = $discount->create($user);
580 if ($discountid > 0) {
581 $result = $objecttmp->insert_discount($discountid);
590 $product_type = ($lines[$i]->product_type ? $lines[$i]->product_type : 0);
593 if ($lines[$i]->date_debut_prevue) {
596 if ($lines[$i]->date_debut_reel) {
599 if ($lines[$i]->date_start) {
604 if ($lines[$i]->date_fin_prevue) {
605 $date_end = $lines[$i]->date_fin_prevue;
607 if ($lines[$i]->date_fin_reel) {
608 $date_end = $lines[$i]->date_fin_reel;
610 if ($lines[$i]->date_end) {
611 $date_end = $lines[$i]->date_end;
614 if (($lines[$i]->product_type != 9 && empty($lines[$i]->fk_parent_line)) || $lines[$i]->product_type == 9) {
619 if (method_exists($lines[$i],
'fetch_optionals')) {
620 $lines[$i]->fetch_optionals();
621 $array_options = $lines[$i]->array_options;
624 $objecttmp->context[
'createfromclone'] =
'createfromclone';
626 $rang = ($nbOrders > 1) ? -1 : $lines[$i]->rang;
628 if (!empty($createbills_onebythird)) {
629 $TFactThirdNbLines[$cmd->socid]++;
630 $rang = $TFactThirdNbLines[$cmd->socid];
633 $result = $objecttmp->addline(
635 $lines[$i]->subprice,
638 $lines[$i]->localtax1_tx,
639 $lines[$i]->localtax2_tx,
640 $lines[$i]->fk_product,
641 $lines[$i]->remise_percent,
645 $lines[$i]->info_bits,
646 $lines[$i]->fk_remise_except,
651 $lines[$i]->special_code,
655 $lines[$i]->fk_fournprice,
664 if (!empty($lines[$i]->extraparams)) {
666 $factureLine->id = $result;
667 $factureLine->extraparams = $lines[$i]->extraparams;
668 $factureLine->setExtraParameters();
675 $errors[] = $objecttmp->error;
679 if ($result > 0 && $lines[$i]->product_type == 9) {
680 $fk_parent_line = $result;
688 $objecttmp->note_public =
dol_concatdesc($objecttmp->note_public, $langs->transnoentities($cmd->ref).(empty($cmd->ref_client) ?
'' :
' ('.$cmd->ref_client.
')'));
689 $objecttmp->update($user);
694 if (!empty($createbills_onebythird) && empty($TFactThird[$cmd->socid])) {
695 $TFactThird[$cmd->socid] = $objecttmp;
697 $TFact[$objecttmp->id] = $objecttmp;
702 $TAllFact = empty($createbills_onebythird) ? $TFact : $TFactThird;
705 if (!$error && $validate_invoices) {
706 $massaction = $action =
'builddoc';
708 foreach ($TAllFact as &$objecttmp) {
709 $result = $objecttmp->validate($user);
716 $id = $objecttmp->id;
717 $lastref = $objecttmp->ref;
721 $upload_dir =
$conf->facture->dir_output;
722 $permissiontoadd = $user->hasRight(
'facture',
'creer');
727 include DOL_DOCUMENT_ROOT.
'/core/actions_builddoc.inc.php';
731 $massaction = $action =
'confirm_createbills';
737 if ($nb_bills_created == 1) {
738 if (
getDolGlobalInt(
'MAIN_MASSACTION_CREATEBILLS_REDIRECT_IF_ONE') == 1) {
740 header(
'Location: '.DOL_URL_ROOT.
'/compta/facture/card.php?id='.urlencode((
string) $lastid));
743 $texttoshow = $langs->trans(
'BillXCreated',
'{s1}');
744 $texttoshow = str_replace(
'{s1}',
'<a href="'.DOL_URL_ROOT.
'/compta/facture/card.php?id='.urlencode((
string) ($lastid)).
'">'.$lastref.
'</a>', $texttoshow);
747 if (
getDolGlobalInt(
'MAIN_MASSACTION_CREATEBILLS_REDIRECT_IF_MANY') == 1) {
749 header(
"Location: ".DOL_URL_ROOT.
'/compta/facture/list.php?mainmenu=billing&leftmenu=customers_bills');
752 setEventMessages($langs->trans(
'BillCreated', $nb_bills_created),
null,
'mesgs');
758 $param .=
'&mode='.urlencode($mode);
760 if (!empty($contextpage) && $contextpage != $_SERVER[
"PHP_SELF"]) {
761 $param .=
'&contextpage='.urlencode($contextpage);
763 if ($limit > 0 && $limit !=
$conf->liste_limit) {
764 $param .=
'&limit='.((int) $limit);
766 if ($optioncss !=
'') {
767 $param .=
'&optioncss='.urlencode($optioncss);
770 $param .=
'&search_all='.urlencode($search_all);
773 $param .=
'&show_files='.urlencode((
string) ($show_files));
776 $param .=
'&socid='.urlencode((
string) ($socid));
778 if ($search_status !=
'') {
779 $param .=
'&search_status='.urlencode($search_status);
781 if ($search_option) {
782 $param .=
"&search_option=".urlencode($search_option);
784 if ($search_orderday) {
785 $param .=
'&search_orderday='.urlencode($search_orderday);
787 if ($search_ordermonth) {
788 $param .=
'&search_ordermonth='.urlencode($search_ordermonth);
790 if ($search_orderyear) {
791 $param .=
'&search_orderyear='.urlencode($search_orderyear);
793 if ($search_deliveryday) {
794 $param .=
'&search_deliveryday='.urlencode($search_deliveryday);
796 if ($search_deliverymonth) {
797 $param .=
'&search_deliverymonth='.urlencode($search_deliverymonth);
799 if ($search_deliveryyear) {
800 $param .=
'&search_deliveryyear='.urlencode($search_deliveryyear);
803 $param .=
'&search_id='.urlencode((
string) $search_id);
806 $param .=
'&search_ref='.urlencode($search_ref);
808 if ($search_ref_ext) {
809 $param .=
'&search_ref_ext='.urlencode($search_ref_ext);
811 if ($search_company) {
812 $param .=
'&search_company='.urlencode($search_company);
814 if ($search_ref_customer) {
815 $param .=
'&search_ref_customer='.urlencode($search_ref_customer);
817 if ($search_user > 0) {
818 $param .=
'&search_user='.urlencode((
string) ($search_user));
820 if ($search_sale > 0) {
821 $param .=
'&search_sale='.urlencode((
string) ($search_sale));
823 if ($search_total_ht !=
'') {
824 $param .=
'&search_total_ht='.urlencode($search_total_ht);
826 if ($search_total_vat !=
'') {
827 $param .=
'&search_total_vat='.urlencode($search_total_vat);
829 if ($search_total_ttc !=
'') {
830 $param .=
'&search_total_ttc='.urlencode($search_total_ttc);
832 if ($search_project_ref >= 0) {
833 $param .=
"&search_project_ref=".urlencode($search_project_ref);
835 if ($search_project !=
'') {
836 $param .=
"&search_project=".urlencode($search_project);
838 if ($search_billed !=
'') {
839 $param .=
'&search_billed='.urlencode($search_billed);
842 header(
"Location: ".$_SERVER[
'PHP_SELF'].
'?'.$param);
848 $_GET[
"origin"] =
GETPOST(
"origin",
'alpha');
850 if (!empty($errors)) {
860if ($action ==
'validate' && $permissiontoadd && $objectclass !==
null) {
861 if (
GETPOST(
'confirm') ==
'yes') {
863 $objecttmp =
new $objectclass(
$db);
866 foreach ($toselect as $checked) {
867 if ($objecttmp->fetch($checked)) {
868 if ($objecttmp->status == $objecttmp::STATUS_DRAFT) {
869 if (!empty($objecttmp->fk_warehouse)) {
870 $idwarehouse = $objecttmp->fk_warehouse;
874 if ($objecttmp->valid($user, $idwarehouse) > 0) {
875 setEventMessages($langs->trans(
'hasBeenValidated', $objecttmp->ref),
null,
'mesgs');
881 $langs->load(
"errors");
882 setEventMessages($langs->trans(
'ErrorIsNotADraft', $objecttmp->ref),
null,
'errors');
897if ($action ==
'shipped' && $permissiontoadd && $objectclass !==
null) {
898 if (
GETPOST(
'confirm') ==
'yes') {
900 $objecttmp =
new $objectclass(
$db);
903 foreach ($toselect as $checked) {
904 if ($objecttmp->fetch($checked)) {
905 if ($objecttmp->status == $objecttmp::STATUS_VALIDATED || $objecttmp->status == $objecttmp::STATUS_SHIPMENTONPROCESS || $objecttmp->status == $objecttmp::STATUS_CLOSED) {
906 $result = $objecttmp->cloture($user);
908 setEventMessages($langs->trans(
'StatusOrderDelivered', $objecttmp->ref),
null,
'mesgs');
909 } elseif ($result < 0) {
910 setEventMessages($langs->trans(
'ErrorOrderStatusCantBeSetToDelivered'),
null,
'errors');
914 $langs->load(
"errors");
915 setEventMessages($langs->trans(
'ErrorObjectHasWrongStatus', $objecttmp->ref),
null,
'errors');
932if (!$error && $massaction ===
'setbilled' && $permissiontoclose && $objectclass !==
null) {
935 $objecttmp =
new $objectclass(
$db);
937 foreach ($toselect as $toselectid) {
938 $result = $objecttmp->fetch($toselectid);
940 $result = $objecttmp->classifyBilled($user, 0);
977$company_url_list = array();
983$varpage = empty($contextpage) ? $_SERVER[
"PHP_SELF"] : $contextpage;
984$selectedfields = $form->multiSelectArrayWithCheckbox(
'selectedfields', $arrayfields, $varpage);
986$title = $langs->trans(
"Orders");
987$help_url =
"EN:Module_Customers_Orders|FR:Module_Commandes_Clients|ES:Módulo_Pedidos_de_clientes";
992$sql .=
' s.rowid as socid, s.nom as name, s.name_alias as alias, s.email, s.phone, s.fax, s.address, s.town, s.zip, s.fk_pays, s.client, s.fournisseur, s.code_client,';
993$sql .=
" s.parent as fk_parent,";
994$sql .=
" s2.nom as name2,";
995$sql .=
" typent.code as typent_code,";
996$sql .=
" state.code_departement as state_code, state.nom as state_name,";
997$sql .=
" country.code as country_code,";
998$sql .=
' c.rowid, c.ref, c.ref_ext, c.total_ht, c.total_tva, c.total_ttc, c.ref_client, c.fk_user_author,';
999$sql .=
' c.fk_multicurrency, c.multicurrency_code, c.multicurrency_tx, c.multicurrency_total_ht, c.multicurrency_total_tva as multicurrency_total_vat, c.multicurrency_total_ttc,';
1000$sql .=
' c.date_valid, c.date_commande, c.note_public, c.note_private, c.date_livraison as delivery_date, c.fk_statut, c.facture as billed,';
1001$sql .=
' c.date_creation as date_creation, c.tms as date_modification, c.date_cloture as date_cloture,';
1002$sql .=
' c.fk_cond_reglement,c.deposit_percent,c.fk_mode_reglement,c.fk_shipping_method,';
1003$sql .=
' c.fk_input_reason, c.import_key,';
1004$sql .=
" c.module_source, c.pos_source,";
1005$sql .=
' p.rowid as project_id, p.ref as project_ref, p.title as project_label,';
1006$sql .=
' u.login, u.lastname, u.firstname, u.email as user_email, u.statut as user_statut, u.entity, u.photo, u.office_phone, u.office_fax, u.user_mobile, u.job, u.gender';
1009if (!empty($extrafields->attributes[
$object->table_element][
'label'])) {
1010 foreach ($extrafields->attributes[
$object->table_element][
'label'] as $key => $val) {
1011 $sql .= ($extrafields->attributes[
$object->table_element][
'type'][$key] !=
'separate' ?
", ef.".$key.
" as options_".$key :
'');
1016$parameters = array();
1017$reshook = $hookmanager->executeHooks(
'printFieldListSelect', $parameters, $object, $action);
1018$sql .= $hookmanager->resPrint;
1019$sql = preg_replace(
'/,\s*$/',
'', $sql);
1023$sql .=
' FROM '.MAIN_DB_PREFIX.
'societe as s';
1024$sql .=
" LEFT JOIN ".MAIN_DB_PREFIX.
"societe as s2 ON s2.rowid = s.parent";
1025$sql .=
" LEFT JOIN ".MAIN_DB_PREFIX.
"c_country as country on (country.rowid = s.fk_pays)";
1026$sql .=
" LEFT JOIN ".MAIN_DB_PREFIX.
"c_typent as typent on (typent.id = s.fk_typent)";
1027$sql .=
" LEFT JOIN ".MAIN_DB_PREFIX.
"c_departements as state on (state.rowid = s.fk_departement)";
1028$sql .=
', '.MAIN_DB_PREFIX.
'commande as c';
1029if (!empty($extrafields->attributes[
$object->table_element][
'label']) && is_array($extrafields->attributes[
$object->table_element][
'label']) && count($extrafields->attributes[
$object->table_element][
'label'])) {
1030 $sql .=
" LEFT JOIN ".MAIN_DB_PREFIX.
"commande_extrafields as ef on (c.rowid = ef.fk_object)";
1032$sql .=
" LEFT JOIN ".MAIN_DB_PREFIX.
"projet as p ON p.rowid = c.fk_projet";
1033$sql .=
' LEFT JOIN '.MAIN_DB_PREFIX.
'user as u ON c.fk_user_author = u.rowid';
1035$parameters = array();
1036$reshook = $hookmanager->executeHooks(
'printFieldListFrom', $parameters, $object, $action);
1037$sql .= $hookmanager->resPrint;
1039$sql .=
' WHERE c.fk_soc = s.rowid';
1040$sql .=
' AND c.entity IN ('.getEntity(
'commande').
')';
1042 $sql .=
' AND s.rowid = '.((int) $socid);
1045if (empty($user->socid) && !$permissiontoreadallthirdparty) {
1046 $sql .=
" AND (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).
")";
1048 $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)).
"))";
1053if ($search_id > 0) {
1059if ($search_ref_ext) {
1062if ($search_ref_customer) {
1065if ($search_billed !=
'' && $search_billed >= 0) {
1066 $sql .=
' AND c.facture = '.((int) $search_billed);
1068if ($search_status !=
'') {
1069 if ($search_status <= 3 && $search_status >= -1) {
1070 if ($search_status == 1 && !
isModEnabled(
'shipping')) {
1071 $sql .=
' AND c.fk_statut IN (1,2)';
1073 $sql .=
' AND c.fk_statut = '.((int) $search_status);
1076 if ($search_status == -2) {
1078 $sql .=
" AND (c.fk_statut IN (1,2))";
1080 if ($search_status == -3) {
1083 $sql .=
' AND (c.fk_statut IN (1,2,3))';
1086if ($search_option ==
'late') {
1089 $sql .=
" AND ((c.date_livraison IS NOT NULL AND c.date_livraison < '".$db->idate(
dol_now() -
$conf->order->client->warning_delay).
"') OR (c.date_livraison IS NULL AND c.date_commande < '".
$db->idate(
dol_now() -
$conf->order->client->warning_delay).
"'))";
1091 $sql .=
" AND c.date_commande < '".$db->idate(
dol_now() -
$conf->order->client->warning_delay).
"'";
1094if ($search_datecloture_start) {
1095 $sql .=
" AND c.date_cloture >= '".$db->idate($search_datecloture_start).
"'";
1097if ($search_datecloture_end) {
1098 $sql .=
" AND c.date_cloture <= '".$db->idate($search_datecloture_end).
"'";
1100if ($search_dateorder_start) {
1101 $sql .=
" AND c.date_commande >= '".$db->idate($search_dateorder_start).
"'";
1103if ($search_dateorder_end) {
1104 $sql .=
" AND c.date_commande <= '".$db->idate($search_dateorder_end).
"'";
1106if ($search_datedelivery_start) {
1107 $sql .=
" AND c.date_livraison >= '".$db->idate($search_datedelivery_start).
"'";
1109if ($search_datedelivery_end) {
1110 $sql .=
" AND c.date_livraison <= '".$db->idate($search_datedelivery_end).
"'";
1121if ($search_country) {
1122 $sql .=
" AND s.fk_pays IN (".$db->sanitize($search_country).
')';
1124if ($search_type_thirdparty && $search_type_thirdparty !=
'-1') {
1125 $sql .=
" AND s.fk_typent IN (".$db->sanitize($search_type_thirdparty).
')';
1127if (empty($arrayfields[
's.name_alias'][
'checked']) && $search_company) {
1128 $sql .=
natural_search(array(
"s.nom",
"s.name_alias"), $search_company);
1130 if ($search_company) {
1133 if ($search_company_alias) {
1137if ($search_parent_name) {
1140if ($search_total_ht !=
'') {
1143if ($search_total_vat !=
'') {
1146if ($search_total_ttc !=
'') {
1149if ($search_warehouse !=
'' && $search_warehouse > 0) {
1152if ($search_note_public !=
'') {
1155if ($search_note_private !=
'') {
1158if ($search_multicurrency_code !=
'') {
1159 $sql .=
" AND c.multicurrency_code = '".$db->escape($search_multicurrency_code).
"'";
1161if ($search_multicurrency_tx !=
'') {
1162 $sql .=
natural_search(
'c.multicurrency_tx', $search_multicurrency_tx, 1);
1164if ($search_multicurrency_montant_ht !=
'') {
1165 $sql .=
natural_search(
'c.multicurrency_total_ht', $search_multicurrency_montant_ht, 1);
1167if ($search_multicurrency_montant_vat !=
'') {
1168 $sql .=
natural_search(
'c.multicurrency_total_tva', $search_multicurrency_montant_vat, 1);
1170if ($search_multicurrency_montant_ttc !=
'') {
1171 $sql .=
natural_search(
'c.multicurrency_total_ttc', $search_multicurrency_montant_ttc, 1);
1174 $sql .=
natural_search(array(
"u.login",
"u.firstname",
"u.lastname"), $search_login);
1176if ($search_project_ref !=
'') {
1179if ($search_project !=
'') {
1182if ($search_fk_cond_reglement > 0) {
1183 $sql .=
" AND c.fk_cond_reglement = ".((int) $search_fk_cond_reglement);
1185if ($search_fk_shipping_method > 0) {
1186 $sql .=
" AND c.fk_shipping_method = ".((int) $search_fk_shipping_method);
1188if ($search_fk_mode_reglement > 0) {
1189 $sql .=
" AND c.fk_mode_reglement = ".((int) $search_fk_mode_reglement);
1191if ($search_fk_input_reason > 0) {
1192 $sql .=
" AND c.fk_input_reason = ".((int) $search_fk_input_reason);
1194if ($search_module_source) {
1195 $sql .=
natural_search(
"c.module_source", $search_module_source);
1197if ($search_pos_source) {
1200if ($search_import_key) {
1204if ($search_user > 0) {
1205 $sql .=
" AND EXISTS (";
1206 $sql .=
" SELECT ec.fk_c_type_contact, ec.element_id, ec.fk_socpeople";
1207 $sql .=
" FROM ".MAIN_DB_PREFIX.
"element_contact as ec";
1208 $sql .=
" INNER JOIN ".MAIN_DB_PREFIX.
"c_type_contact as tc";
1209 $sql .=
" ON ec.fk_c_type_contact = tc.rowid AND tc.element = 'commande' AND tc.source = 'internal'";
1210 $sql .=
" WHERE ec.element_id = c.rowid AND ec.fk_socpeople = ".((int) $search_user).
")";
1213if ($search_sale && $search_sale !=
'-1') {
1214 if ($search_sale == -2) {
1215 $sql .=
" AND NOT EXISTS (SELECT sc.fk_soc FROM ".MAIN_DB_PREFIX.
"societe_commerciaux as sc WHERE sc.fk_soc = c.fk_soc)";
1216 } elseif ($search_sale > 0) {
1217 $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).
")";
1222if (!empty($searchCategoryOrderList)) {
1223 $searchCategoryOrderSqlList = array();
1224 $listofcategoryid =
'';
1225 foreach ($searchCategoryOrderList as $searchCategoryOrder) {
1226 if (intval($searchCategoryOrder) == -2) {
1227 $searchCategoryOrderSqlList[] =
"NOT EXISTS (SELECT ck.fk_order FROM ".MAIN_DB_PREFIX.
"categorie_order as ck WHERE c.rowid = ck.fk_order)";
1228 } elseif (intval($searchCategoryOrder) > 0) {
1229 if ($searchCategoryOrderOperator == 0) {
1230 $searchCategoryOrderSqlList[] =
" EXISTS (SELECT ck.fk_order FROM ".MAIN_DB_PREFIX.
"categorie_order as ck WHERE c.rowid = ck.fk_order AND ck.fk_categorie = ".((int) $searchCategoryOrder).
")";
1232 $listofcategoryid .= ($listofcategoryid ?
', ' :
'') .((
int) $searchCategoryOrder);
1236 if ($listofcategoryid) {
1237 $searchCategoryOrderSqlList[] =
" EXISTS (SELECT ck.fk_order FROM ".MAIN_DB_PREFIX.
"categorie_order as ck WHERE c.rowid = ck.fk_order AND ck.fk_categorie IN (".
$db->sanitize($listofcategoryid).
"))";
1239 if ($searchCategoryOrderOperator == 1) {
1240 if (!empty($searchCategoryOrderSqlList)) {
1241 $sql .=
" AND (".implode(
' OR ', $searchCategoryOrderSqlList).
")";
1244 if (!empty($searchCategoryOrderSqlList)) {
1245 $sql .=
" AND (".implode(
' AND ', $searchCategoryOrderSqlList).
")";
1251$searchCategoryCustomerOperator =
GETPOSTINT(
'search_category_customer_operator');
1252$searchCategoryCustomerList = array($search_categ_cus);
1253if (!empty($searchCategoryCustomerList)) {
1254 $searchCategoryCustomerSqlList = array();
1255 $listofcategoryid =
'';
1256 foreach ($searchCategoryCustomerList as $searchCategoryCustomer) {
1257 if (intval($searchCategoryCustomer) == -2) {
1258 $searchCategoryCustomerSqlList[] =
"NOT EXISTS (SELECT cs.fk_soc FROM ".MAIN_DB_PREFIX.
"categorie_societe as cs WHERE s.rowid = cs.fk_soc)";
1259 } elseif (intval($searchCategoryCustomer) > 0) {
1260 if ($searchCategoryCustomerOperator == 0) {
1261 $searchCategoryCustomerSqlList[] =
" EXISTS (SELECT cs.fk_soc FROM ".MAIN_DB_PREFIX.
"categorie_societe as cs WHERE s.rowid = cs.fk_soc AND cs.fk_categorie = ".((int) $searchCategoryCustomer).
")";
1263 $listofcategoryid .= ($listofcategoryid ?
', ' :
'') .((
int) $searchCategoryCustomer);
1267 if ($listofcategoryid) {
1268 $searchCategoryCustomerSqlList[] =
" EXISTS (SELECT cs.fk_soc FROM ".MAIN_DB_PREFIX.
"categorie_societe as cs WHERE s.rowid = cs.fk_soc AND cs.fk_categorie IN (".
$db->sanitize($listofcategoryid).
"))";
1270 if ($searchCategoryCustomerOperator == 1) {
1271 if (!empty($searchCategoryCustomerSqlList)) {
1272 $sql .=
" AND (".implode(
' OR ', $searchCategoryCustomerSqlList).
")";
1275 if (!empty($searchCategoryCustomerSqlList)) {
1276 $sql .=
" AND (".implode(
' AND ', $searchCategoryCustomerSqlList).
")";
1281$searchCategoryProductOperator =
GETPOSTINT(
'search_category_product_operator');
1282$searchCategoryProductList = array($search_product_category);
1283if (!empty($searchCategoryProductList)) {
1284 $searchCategoryProductSqlList = array();
1285 $listofcategoryid =
'';
1286 foreach ($searchCategoryProductList as $searchCategoryProduct) {
1287 if (intval($searchCategoryProduct) == -2) {
1288 $searchCategoryProductSqlList[] =
"NOT EXISTS (SELECT ck.fk_product FROM ".MAIN_DB_PREFIX.
"categorie_product as ck, ".MAIN_DB_PREFIX.
"commandedet as cd WHERE cd.fk_commande = c.rowid AND cd.fk_product = ck.fk_product)";
1289 } elseif (intval($searchCategoryProduct) > 0) {
1290 if ($searchCategoryProductOperator == 0) {
1291 $searchCategoryProductSqlList[] =
" EXISTS (SELECT ck.fk_product FROM ".MAIN_DB_PREFIX.
"categorie_product as ck, ".MAIN_DB_PREFIX.
"commandedet as cd WHERE cd.fk_commande = c.rowid AND cd.fk_product = ck.fk_product AND ck.fk_categorie = ".((int) $searchCategoryProduct).
")";
1293 $listofcategoryid .= ($listofcategoryid ?
', ' :
'') .((
int) $searchCategoryProduct);
1297 if ($listofcategoryid) {
1298 $searchCategoryProductSqlList[] =
" EXISTS (SELECT ck.fk_product FROM ".MAIN_DB_PREFIX.
"categorie_product as ck, ".MAIN_DB_PREFIX.
"commandedet as cd WHERE cd.fk_commande = c.rowid AND cd.fk_product = ck.fk_product AND ck.fk_categorie IN (".
$db->sanitize($listofcategoryid).
"))";
1300 if ($searchCategoryProductOperator == 1) {
1301 if (!empty($searchCategoryProductSqlList)) {
1302 $sql .=
" AND (".implode(
' OR ', $searchCategoryProductSqlList).
")";
1305 if (!empty($searchCategoryProductSqlList)) {
1306 $sql .=
" AND (".implode(
' AND ', $searchCategoryProductSqlList).
")";
1311include DOL_DOCUMENT_ROOT.
'/core/tpl/extrafields_list_search_sql.tpl.php';
1313$parameters = array();
1314$reshook = $hookmanager->executeHooks(
'printFieldListWhere', $parameters, $object, $action);
1315$sql .= $hookmanager->resPrint;
1320 $fieldstosearchallwithoutpd = array();
1321 $fieldstosearchallwithpd = array();
1322 foreach ($fieldstosearchall as $key => $val) {
1323 if (!preg_match(
'/^pd\./', $key)) {
1324 $fieldstosearchallwithoutpd[$key] = $val;
1326 $fieldstosearchallwithpd[$key] = $val;
1330 if (count($fieldstosearchallwithpd) > 0) {
1331 $sqltoadd .=
" OR EXISTS (SELECT pd.rowid FROM ".MAIN_DB_PREFIX.
"commandedet as pd WHERE pd.fk_commande = c.rowid";
1332 $sqltoadd .=
natural_search(array_keys($fieldstosearchallwithpd),
'__KEYTOSEARCH__');
1336 $sql .=
natural_search(array_keys($fieldstosearchallwithoutpd), $search_all, 0, 0, $sqltoadd);
1340$parameters = array();
1341$reshook = $hookmanager->executeHooks(
'printFieldListHaving', $parameters, $object, $action);
1342if (empty($reshook)) {
1343 $sql .= empty($hookmanager->resPrint) ?
"" :
" HAVING 1=1 ".$hookmanager->resPrint;
1345 $sql = $hookmanager->resPrint;
1350$nbtotalofrecords =
'';
1353 $sqlforcount = preg_replace(
'/^'.preg_quote($sqlfields,
'/').
'/',
'SELECT COUNT(*) as nbtotalofrecords', $sql);
1354 $sqlforcount = preg_replace(
'/GROUP BY .*$/',
'', $sqlforcount);
1355 $resql =
$db->query($sqlforcount);
1357 $objforcount =
$db->fetch_object($resql);
1358 $nbtotalofrecords = $objforcount->nbtotalofrecords;
1363 if (($page * $limit) > (
int) $nbtotalofrecords) {
1371$sql .=
$db->order($sortfield, $sortorder);
1373 $sql .=
$db->plimit($limit + 1, $offset);
1377$resql =
$db->query($sql);
1385 $soc->fetch($socid);
1386 $title = $langs->trans(
'CustomersOrders').
' - '.$soc->name;
1387 if (empty($search_company)) {
1388 $search_company = $soc->name;
1391 $title = $langs->trans(
'CustomersOrders');
1393if (strval($search_status) ==
'0') {
1394 $title .=
' - '.$langs->trans(
'StatusOrderDraftShort');
1396if ($search_status == 1) {
1397 $title .=
' - '.$langs->trans(
'StatusOrderValidatedShort');
1399if ($search_status == 2) {
1400 $title .=
' - '.$langs->trans(
'StatusOrderSentShort');
1402if ($search_status == 3) {
1403 $title .=
' - '.$langs->trans(
'StatusOrderToBillShort');
1405if ($search_status == -1) {
1406 $title .=
' - '.$langs->trans(
'StatusOrderCanceledShort');
1408if ($search_status == -2) {
1409 $title .=
' - '.$langs->trans(
'StatusOrderToProcessShort');
1411if ($search_status == -3) {
1412 $title .=
' - '.$langs->trans(
'StatusOrderValidated').
', '.(!
isModEnabled(
'shipping') ?
'' : $langs->trans(
"StatusOrderSent").
', ').$langs->trans(
'StatusOrderToBill');
1414if ($search_status == -4) {
1415 $title .=
' - '.$langs->trans(
"StatusOrderValidatedShort").
'+'.$langs->trans(
"StatusOrderSentShort");
1418$num =
$db->num_rows($resql);
1420$arrayofselected = is_array($toselect) ? $toselect : array();
1422if ($num == 1 &&
getDolGlobalString(
'MAIN_SEARCH_DIRECT_OPEN_IF_ONLY_ONE') && $search_all) {
1423 $obj =
$db->fetch_object($resql);
1425 header(
"Location: ".DOL_URL_ROOT.
'/commande/card.php?id='.
$id);
1432llxHeader(
'', $title, $help_url,
'', 0, 0,
'',
'',
'',
'bodyforlist mod-order page-list');
1434$arrayofselected = is_array($toselect) ? $toselect : array();
1438 $param .=
'&mode='.urlencode($mode);
1440if (!empty($contextpage) && $contextpage != $_SERVER[
"PHP_SELF"]) {
1441 $param .=
'&contextpage='.urlencode($contextpage);
1443if ($limit > 0 && $limit !=
$conf->liste_limit) {
1444 $param .=
'&limit='.((int) $limit);
1446if ($optioncss !=
'') {
1447 $param .=
'&optioncss='.urlencode($optioncss);
1450 $param .=
'&show_files='.urlencode((
string) ($show_files));
1453 $param .=
'&search_all='.urlencode($search_all);
1456 $param .=
'&socid='.((int) $socid);
1458if ($search_status !=
'') {
1459 $param .=
'&search_status='.urlencode($search_status);
1461if ($search_option) {
1462 $param .=
"&search_option=".urlencode($search_option);
1464if ($search_datecloture_start) {
1465 $param .=
'&search_datecloture_startday='.dol_print_date($search_datecloture_start,
'%d').
'&search_datecloture_startmonth='.
dol_print_date($search_datecloture_start,
'%m').
'&search_datecloture_startyear='.
dol_print_date($search_datecloture_start,
'%Y');
1467if ($search_datecloture_end) {
1468 $param .=
'&search_datecloture_endday='.dol_print_date($search_datecloture_end,
'%d').
'&search_datecloture_endmonth='.
dol_print_date($search_datecloture_end,
'%m').
'&search_datecloture_endyear='.
dol_print_date($search_datecloture_end,
'%Y');
1470if ($search_dateorder_start) {
1471 $param .=
'&search_dateorder_start_day='.dol_print_date($search_dateorder_start,
'%d').
'&search_dateorder_start_month='.
dol_print_date($search_dateorder_start,
'%m').
'&search_dateorder_start_year='.
dol_print_date($search_dateorder_start,
'%Y');
1473if ($search_dateorder_end) {
1474 $param .=
'&search_dateorder_end_day='.dol_print_date($search_dateorder_end,
'%d').
'&search_dateorder_end_month='.
dol_print_date($search_dateorder_end,
'%m').
'&search_dateorder_end_year='.
dol_print_date($search_dateorder_end,
'%Y');
1476if ($search_datedelivery_start) {
1477 $param .=
'&search_datedelivery_start_day='.dol_print_date($search_datedelivery_start,
'%d').
'&search_datedelivery_start_month='.
dol_print_date($search_datedelivery_start,
'%m').
'&search_datedelivery_start_year='.
dol_print_date($search_datedelivery_start,
'%Y');
1479if ($search_datedelivery_end) {
1480 $param .=
'&search_datedelivery_end_day='.dol_print_date($search_datedelivery_end,
'%d').
'&search_datedelivery_end_month='.
dol_print_date($search_datedelivery_end,
'%m').
'&search_datedelivery_end_year='.
dol_print_date($search_datedelivery_end,
'%Y');
1483 $param .=
'&search_id='.urlencode((
string) $search_id);
1486 $param .=
'&search_ref='.urlencode($search_ref);
1488if ($search_ref_ext) {
1489 $param .=
'&search_ref_ext='.urlencode($search_ref_ext);
1491if ($search_company) {
1492 $param .=
'&search_company='.urlencode($search_company);
1494if ($search_company_alias) {
1495 $param .=
'&search_company_alias='.urlencode($search_company_alias);
1497if ($search_parent_name !=
'') {
1498 $param .=
'&search_parent_name='.urlencode($search_parent_name);
1500if ($search_ref_customer) {
1501 $param .=
'&search_ref_customer='.urlencode($search_ref_customer);
1503if ($search_user > 0) {
1504 $param .=
'&search_user='.urlencode((
string) ($search_user));
1506if ($search_sale > 0) {
1507 $param .=
'&search_sale='.urlencode((
string) ($search_sale));
1509if ($search_total_ht !=
'') {
1510 $param .=
'&search_total_ht='.urlencode($search_total_ht);
1512if ($search_total_vat !=
'') {
1513 $param .=
'&search_total_vat='.urlencode($search_total_vat);
1515if ($search_total_ttc !=
'') {
1516 $param .=
'&search_total_ttc='.urlencode($search_total_ttc);
1518if ($search_warehouse !=
'') {
1519 $param .=
'&search_warehouse='.urlencode((
string) ($search_warehouse));
1522 $param .=
'&search_login='.urlencode($search_login);
1524if ($search_multicurrency_code !=
'') {
1525 $param .=
'&search_multicurrency_code='.urlencode($search_multicurrency_code);
1527if ($search_multicurrency_tx !=
'') {
1528 $param .=
'&search_multicurrency_tx='.urlencode($search_multicurrency_tx);
1530if ($search_multicurrency_montant_ht !=
'') {
1531 $param .=
'&search_multicurrency_montant_ht='.urlencode($search_multicurrency_montant_ht);
1533if ($search_multicurrency_montant_vat !=
'') {
1534 $param .=
'&search_multicurrency_montant_vat='.urlencode($search_multicurrency_montant_vat);
1536if ($search_multicurrency_montant_ttc !=
'') {
1537 $param .=
'&search_multicurrency_montant_ttc='.urlencode($search_multicurrency_montant_ttc);
1539if ($search_project_ref >= 0) {
1540 $param .=
"&search_project_ref=".urlencode($search_project_ref);
1542if ($search_project !=
'') {
1543 $param .=
"&search_project=".urlencode($search_project);
1545if ($search_town !=
'') {
1546 $param .=
'&search_town='.urlencode($search_town);
1548if ($search_zip !=
'') {
1549 $param .=
'&search_zip='.urlencode($search_zip);
1551if ($search_state !=
'') {
1552 $param .=
'&search_state='.urlencode($search_state);
1554if ($search_country !=
'') {
1555 $param .=
'&search_country='.urlencode((
string) ($search_country));
1557if ($search_type_thirdparty && $search_type_thirdparty !=
'-1') {
1558 $param .=
'&search_type_thirdparty='.urlencode((
string) ($search_type_thirdparty));
1560if ($searchCategoryOrderOperator == 1) {
1561 $param .=
"&search_category_order_operator=".urlencode((
string) ($searchCategoryOrderOperator));
1563foreach ($searchCategoryOrderList as $searchCategoryOrder) {
1564 $param .=
"&search_category_order_list[]=".urlencode($searchCategoryOrder);
1566if ($search_product_category !=
'') {
1567 $param .=
'&search_product_category='.urlencode((
string) ($search_product_category));
1569if (($search_categ_cus > 0) || ($search_categ_cus == -2)) {
1570 $param .=
'&search_categ_cus='.urlencode((
string) ($search_categ_cus));
1572if ($search_billed !=
'') {
1573 $param .=
'&search_billed='.urlencode($search_billed);
1575if ($search_fk_cond_reglement > 0) {
1576 $param .=
'&search_fk_cond_reglement='.urlencode((
string) ($search_fk_cond_reglement));
1578if ($search_fk_shipping_method > 0) {
1579 $param .=
'&search_fk_shipping_method='.urlencode((
string) ($search_fk_shipping_method));
1581if ($search_fk_mode_reglement > 0) {
1582 $param .=
'&search_fk_mode_reglement='.urlencode((
string) ($search_fk_mode_reglement));
1584if ($search_fk_input_reason > 0) {
1585 $param .=
'&search_fk_input_reason='.urlencode((
string) ($search_fk_input_reason));
1587if ($search_module_source) {
1588 $param .=
'&search_module_source='.urlencode($search_module_source);
1590if ($search_pos_source) {
1591 $param .=
'&search_pos_source='.urlencode($search_pos_source);
1593if ($search_import_key !=
'') {
1594 $param .=
'&search_import_key='.urlencode($search_import_key);
1598include DOL_DOCUMENT_ROOT.
'/core/tpl/extrafields_list_search_param.tpl.php';
1601$parameters = array();
1602$reshook = $hookmanager->executeHooks(
'printFieldListSearchParam', $parameters, $object, $action);
1603$param .= $hookmanager->resPrint;
1606$arrayofmassactions = array(
1607 'generate_doc' =>
img_picto(
'',
'pdf',
'class="pictofixedwidth"').$langs->trans(
"ReGeneratePDF"),
1608 'builddoc' =>
img_picto(
'',
'pdf',
'class="pictofixedwidth"').$langs->trans(
"PDFMerge"),
1610if (
isModEnabled(
'category') && $user->hasRight(
"commande",
"lire")) {
1611 $arrayofmassactions[
'preaffecttag'] =
img_picto(
'',
'category',
'class="pictofixedwidth"').$langs->trans(
"AffectTag");
1613if ($permissiontovalidate) {
1614 $arrayofmassactions[
'prevalidate'] =
img_picto(
'',
'check',
'class="pictofixedwidth"').$langs->trans(
"Validate");
1616if ($permissiontoclose) {
1617 $arrayofmassactions[
'preshipped'] =
img_picto(
'',
'dolly',
'class="pictofixedwidth"').$langs->trans(
"ClassifyShipped");
1619if (
isModEnabled(
'invoice') && $user->hasRight(
"facture",
"creer")) {
1620 $arrayofmassactions[
'createbills'] =
img_picto(
'',
'bill',
'class="pictofixedwidth"').$langs->trans(
"CreateInvoiceForThisCustomer");
1622if ($permissiontoclose) {
1623 $arrayofmassactions[
'setbilled'] =
img_picto(
'',
'bill',
'class="pictofixedwidth"').$langs->trans(
"ClassifyBilled");
1625if ($permissiontocancel) {
1626 $arrayofmassactions[
'cancelorders'] =
img_picto(
'',
'close_title',
'class="pictofixedwidth"').$langs->trans(
"CancelOrder");
1628if (!empty($permissiontodelete)) {
1629 $arrayofmassactions[
'predelete'] =
img_picto(
'',
'delete',
'class="pictofixedwidth"').$langs->trans(
"Delete");
1631if ($permissiontosendbymail) {
1632 $arrayofmassactions[
'presend'] =
img_picto(
'',
'email',
'class="pictofixedwidth"').$langs->trans(
"SendByMail");
1634if (in_array($massaction, array(
'presend',
'predelete',
'createbills'))) {
1635 $arrayofmassactions = array();
1637$massactionbutton = $form->selectMassAction(
'', $arrayofmassactions);
1639$url = DOL_URL_ROOT.
'/commande/card.php?action=create';
1640if (!empty($socid)) {
1641 $url .=
'&socid='.$socid;
1644$newcardbutton .=
dolGetButtonTitle($langs->trans(
'ViewList'),
'',
'fa fa-bars imgforviewmode', $_SERVER[
"PHP_SELF"].
'?mode=common'.preg_replace(
'/(&|\?)*mode=[^&]+/',
'', $param),
'', ((empty($mode) || $mode ==
'common') ? 2 : 1), array(
'morecss' =>
'reposition'));
1645$newcardbutton .=
dolGetButtonTitle($langs->trans(
'ViewKanban'),
'',
'fa fa-th-list imgforviewmode', $_SERVER[
"PHP_SELF"].
'?mode=kanban'.preg_replace(
'/(&|\?)*mode=[^&]+/',
'', $param),
'', ($mode ==
'kanban' ? 2 : 1), array(
'morecss' =>
'reposition'));
1646$newcardbutton .=
dolGetButtonTitle($langs->trans(
'Statistics'),
'',
'fa fa-chart-bar imgforviewmode', DOL_URL_ROOT.
'/commande/stats/index.php?'.preg_replace(
'/(&|\?)*(mode|groupby)=[^&]+/',
'', $param),
'', ($mode ==
'statistics' ? 2 : 1), array(
'morecss' =>
'reposition'));
1648$newcardbutton .=
dolGetButtonTitle($langs->trans(
'NewOrder'),
'',
'fa fa-plus-circle', $url,
'', (
int) (($contextpage ==
'orderlist' || $contextpage ==
'billableorders') && $permissiontoadd));
1651print
'<form method="POST" id="searchFormList" name="searchFormList" action="'.$_SERVER[
"PHP_SELF"].
'">'.
"\n";
1652if ($optioncss !=
'') {
1653 print
'<input type="hidden" name="optioncss" value="'.$optioncss.
'">';
1655print
'<input type="hidden" name="token" value="'.newToken().
'">';
1656print
'<input type="hidden" name="formfilteraction" id="formfilteraction" value="list">';
1657print
'<input type="hidden" name="action" value="list">';
1658print
'<input type="hidden" name="sortfield" value="'.$sortfield.
'">';
1659print
'<input type="hidden" name="sortorder" value="'.$sortorder.
'">';
1660print
'<input type="hidden" name="contextpage" value="'.$contextpage.
'">';
1661print
'<input type="hidden" name="search_status" value="'.$search_status.
'">';
1662print
'<input type="hidden" name="socid" value="'.$socid.
'">';
1663print
'<input type="hidden" name="page_y" value="">';
1664print
'<input type="hidden" name="mode" value="'.$mode.
'">';
1667print_barre_liste($title, $page, $_SERVER[
"PHP_SELF"], $param, $sortfield, $sortorder, $massactionbutton, $num, $nbtotalofrecords,
'order', 0, $newcardbutton,
'', $limit, 0, 0, 1);
1669$topicmail =
"SendOrderRef";
1670$modelmail =
"order_send";
1672$trackid =
'ord'.$object->id;
1673include DOL_DOCUMENT_ROOT.
'/core/tpl/massactions_pre.tpl.php';
1675if ($massaction ==
'prevalidate') {
1676 print $form->formconfirm($_SERVER[
"PHP_SELF"], $langs->trans(
"ConfirmMassValidation"), $langs->trans(
"ConfirmMassValidationQuestion"),
"validate",
null,
'', 0, 200, 500, 1);
1678if ($massaction ==
'preshipped') {
1679 print $form->formconfirm($_SERVER[
"PHP_SELF"], $langs->trans(
"CloseOrder"), $langs->trans(
"ConfirmCloseOrder"),
"shipped",
null,
'', 0, 200, 500, 1);
1682if ($massaction ==
'createbills') {
1683 print
'<input type="hidden" name="massaction" value="confirm_createbills">';
1685 print
'<table class="noborder centpercent">';
1688 print $langs->trans(
'DateInvoice');
1691 print $form->selectDate(
'',
'', 0, 0, 0,
'', 1, 1);
1696 print $langs->trans(
'CreateOneBillByThird');
1699 print $form->selectyesno(
'createbills_onebythird',
getDolGlobalString(
'MAIN_ORDERLIST_CREATEBILLS_ONEBYTHIRD',
'no'), 1);
1704 print $langs->trans(
'ValidateInvoices');
1708 print $form->selectyesno(
'validate_invoices', 0, 1, 1);
1709 $langs->load(
"errors");
1710 print
' ('.$langs->trans(
"WarningAutoValNotPossibleWhenStockIsDecreasedOnInvoiceVal").
')';
1712 print $form->selectyesno(
'validate_invoices', 0, 1);
1714 if (!empty(
$conf->workflow->enabled) &&
getDolGlobalString(
'WORKFLOW_INVOICE_AMOUNT_CLASSIFY_BILLED_ORDER')) {
1715 print
' <span class="opacitymedium">'.$langs->trans(
"IfValidateInvoiceIsNoOrderStayUnbilled").
'</span>';
1717 print
' <span class="opacitymedium">'.$langs->trans(
"OptionToSetOrderBilledNotEnabled").
'</span>';
1723 print
'<div class="center">';
1724 print
'<input type="submit" class="button" id="createbills" name="createbills" value="'.$langs->trans(
'CreateInvoiceForThisCustomer').
'"> ';
1725 print
'<input type="submit" class="button button-cancel" id="cancel" name="cancel" value="'.$langs->trans(
"Cancel").
'">';
1732 foreach ($fieldstosearchall as $key => $val) {
1733 $fieldstosearchall[$key] = $langs->trans($val);
1734 $setupstring .= $key.
"=".$val.
";";
1736 print
'<!-- Search done like if MYOBJECT_QUICKSEARCH_ON_FIELDS = '.$setupstring.
' -->'.
"\n";
1737 print
'<div class="divsearchfieldfilter">'.$langs->trans(
"FilterOnInto", $search_all).implode(
', ', $fieldstosearchall).
'</div>';
1742if (
isModEnabled(
'category') && $user->hasRight(
'categorie',
'read')) {
1744 $moreforfilter .= $formcategory->getFilterBox(Categorie::TYPE_ORDER, $searchCategoryOrderList,
'minwidth300', $searchCategoryOrderOperator ? $searchCategoryOrderOperator : 0);
1748if ($user->hasRight(
"user",
"user",
"lire")) {
1749 $langs->load(
"commercial");
1750 $moreforfilter .=
'<div class="divsearchfield">';
1751 $tmptitle = $langs->trans(
'ThirdPartiesOfSaleRepresentative');
1752 $moreforfilter .=
img_picto($tmptitle,
'user',
'class="pictofixedwidth"').$formother->select_salesrepresentatives($search_sale,
'search_sale', $user, 0, $tmptitle,
'maxwidth250 widthcentpercentminusx');
1753 $moreforfilter .=
'</div>';
1756if ($user->hasRight(
"user",
"user",
"lire")) {
1757 $moreforfilter .=
'<div class="divsearchfield">';
1758 $tmptitle = $langs->trans(
'LinkedToSpecificUsers');
1759 $moreforfilter .=
img_picto($tmptitle,
'user',
'class="pictofixedwidth"').$form->select_dolusers($search_user,
'search_user', $tmptitle,
null, 0,
'',
'',
'0', 0, 0,
'', 0,
'',
'maxwidth250 widthcentpercentminusx');
1760 $moreforfilter .=
'</div>';
1764if (
isModEnabled(
'category') && $user->hasRight(
"categorie",
"lire") && ($user->hasRight(
"produit",
"lire") || $user->hasRight(
"service",
"lire"))) {
1765 include_once DOL_DOCUMENT_ROOT.
'/categories/class/categorie.class.php';
1766 $moreforfilter .=
'<div class="divsearchfield">';
1767 $tmptitle = $langs->trans(
'IncludingProductWithTag');
1768 $cate_arbo = $form->select_all_categories(Categorie::TYPE_PRODUCT,
'',
'parent', 0, array(), 1);
1769 $moreforfilter .=
img_picto($tmptitle,
'category',
'class="pictofixedwidth"').$form->selectarray(
'search_product_category', $cate_arbo, $search_product_category, $tmptitle, 0, 0,
'', 0, 0, 0,
'',
'maxwidth300 widthcentpercentminusx', 1);
1770 $moreforfilter .=
'</div>';
1773if (
isModEnabled(
'category') && $user->hasRight(
"categorie",
"lire")) {
1774 require_once DOL_DOCUMENT_ROOT.
'/categories/class/categorie.class.php';
1775 $moreforfilter .=
'<div class="divsearchfield">';
1776 $tmptitle = $langs->trans(
'CustomersProspectsCategoriesShort');
1777 $moreforfilter .=
img_picto($tmptitle,
'category',
'class="pictofixedwidth"').$formother->select_categories(
'customer', $search_categ_cus,
'search_categ_cus', 1, $tmptitle,
'maxwidth300 widthcentpercentminusx');
1778 $moreforfilter .=
'</div>';
1782 $moreforfilter .=
'<div class="divsearchfield">';
1783 $tmptitle = $langs->trans(
'Warehouse');
1784 $moreforfilter .=
img_picto($tmptitle,
'stock',
'class="pictofixedwidth"').$formproduct->selectWarehouses($search_warehouse,
'search_warehouse',
'', 1, 0, 0, $tmptitle, 0, 0, array(),
'maxwidth250 widthcentpercentminusx');
1785 $moreforfilter .=
'</div>';
1788$parameters = array();
1789$reshook = $hookmanager->executeHooks(
'printFieldPreListTitle', $parameters, $object, $action);
1790if (empty($reshook)) {
1791 $moreforfilter .= $hookmanager->resPrint;
1793 $moreforfilter = $hookmanager->resPrint;
1796if (!empty($moreforfilter)) {
1797 print
'<div class="liste_titre liste_titre_bydiv centpercent">';
1798 print $moreforfilter;
1802$varpage = empty($contextpage) ? $_SERVER[
"PHP_SELF"] : $contextpage;
1803$htmlofselectarray = $form->multiSelectArrayWithCheckbox(
'selectedfields', $arrayfields, $varpage,
$conf->main_checkbox_left_column);
1804$selectedfields = ($mode !=
'kanban' ? $htmlofselectarray :
'');
1805$selectedfields .= (count($arrayofmassactions) ? $form->showCheckAddButtons(
'checkforselect', 1) :
'');
1808 $selectedfields .=
'<script>';
1809 $selectedfields .=
' $(document).ready(function() {';
1810 $selectedfields .=
' console.log("Autoclick on checkforselects");';
1811 $selectedfields .=
' $("#checkforselects").click();';
1812 $selectedfields .=
' $("#massaction").val("createbills").change();';
1813 $selectedfields .=
' });';
1814 $selectedfields .=
'</script>';
1817print
'<div class="div-table-responsive">';
1818print
'<table class="tagtable nobottomiftotal liste'.($moreforfilter ?
" listwithfilterbefore" :
"").
'">'.
"\n";
1822print
'<tr class="liste_titre_filter">';
1824if (
$conf->main_checkbox_left_column) {
1825 print
'<td class="liste_titre center maxwidthsearch actioncolumn">';
1826 $searchpicto = $form->showFilterButtons(
'left');
1832if (!empty($arrayfields[
'c.rowid'][
'checked'])) {
1833 print
'<td class="liste_titre">';
1834 print
'<input class="flat" size="6" type="text" name="search_id" value="'.dol_escape_htmltag($search_id).
'">';
1839if (!empty($arrayfields[
'c.ref'][
'checked'])) {
1840 print
'<td class="liste_titre">';
1841 print
'<input class="flat maxwidth50imp" type="text" name="search_ref" value="'.dol_escape_htmltag($search_ref).
'">';
1845if (!empty($arrayfields[
'c.ref_ext'][
'checked'])) {
1846 print
'<td class="liste_titre">';
1847 print
'<input class="flat maxwidth50imp" type="text" name="search_ref_ext" value="'.dol_escape_htmltag($search_ref_ext).
'">';
1851if (!empty($arrayfields[
'c.ref_client'][
'checked'])) {
1852 print
'<td class="liste_titre" align="left">';
1853 print
'<input class="flat" type="text" size="6" name="search_ref_customer" value="'.dol_escape_htmltag($search_ref_customer).
'">';
1857if (!empty($arrayfields[
'p.ref'][
'checked'])) {
1858 print
'<td class="liste_titre"><input type="text" class="flat" size="6" name="search_project_ref" value="'.dol_escape_htmltag($search_project_ref).
'"></td>';
1861if (!empty($arrayfields[
'p.title'][
'checked'])) {
1862 print
'<td class="liste_titre"><input type="text" class="flat" size="6" name="search_project" value="'.dol_escape_htmltag($search_project).
'"></td>';
1865if (!empty($arrayfields[
's.nom'][
'checked'])) {
1866 print
'<td class="liste_titre">';
1867 print
'<input class="flat maxwidth75imp" type="text" name="search_company" value="'.dol_escape_htmltag((
string) $search_company).
'"'.(!empty($user->socid) ?
" disabled" :
"").
'>';
1871if (!empty($arrayfields[
's.name_alias'][
'checked'])) {
1872 print
'<td class="liste_titre">';
1873 print
'<input class="flat maxwidth75imp" type="text" name="search_company_alias" value="'.dol_escape_htmltag($search_company_alias).
'">';
1877if (!empty($arrayfields[
's2.nom'][
'checked'])) {
1878 print
'<td class="liste_titre">';
1879 print
'<input class="flat maxwidth100" type="text" name="search_parent_name" value="'.dol_escape_htmltag($search_parent_name).
'">';
1883if (!empty($arrayfields[
's.town'][
'checked'])) {
1884 print
'<td class="liste_titre"><input class="flat maxwidth75imp" type="text" name="search_town" value="'.dol_escape_htmltag($search_town).
'"></td>';
1887if (!empty($arrayfields[
's.zip'][
'checked'])) {
1888 print
'<td class="liste_titre"><input class="flat maxwidth50imp" type="text" name="search_zip" value="'.dol_escape_htmltag($search_zip).
'"></td>';
1891if (!empty($arrayfields[
'state.nom'][
'checked'])) {
1892 print
'<td class="liste_titre">';
1893 print
'<input class="flat maxwidth50imp" type="text" name="search_state" value="'.dol_escape_htmltag($search_state).
'">';
1897if (!empty($arrayfields[
'country.code_iso'][
'checked'])) {
1898 print
'<td class="liste_titre" align="center">';
1899 print $form->select_country($search_country,
'search_country',
'', 0,
'minwidth100imp maxwidth100');
1903if (!empty($arrayfields[
'typent.code'][
'checked'])) {
1904 print
'<td class="liste_titre maxwidthonsmartphone center">';
1905 print $form->selectarray(
"search_type_thirdparty", $formcompany->typent_array(0), $search_type_thirdparty, 1, 0, 0,
'', 0, 0, 0,
getDolGlobalString(
'SOCIETE_SORT_ON_TYPEENT',
'ASC'),
'', 1);
1909if (!empty($arrayfields[
'c.date_commande'][
'checked'])) {
1910 print
'<td class="liste_titre center">';
1911 print
'<div class="nowrapfordate">';
1912 print $form->selectDate($search_dateorder_start ? $search_dateorder_start : -1,
'search_dateorder_start_', 0, 0, 1,
'', 1, 0, 0,
'',
'',
'',
'', 1,
'', $langs->trans(
'From'));
1914 print
'<div class="nowrapfordate">';
1915 print $form->selectDate($search_dateorder_end ? $search_dateorder_end : -1,
'search_dateorder_end_', 0, 0, 1,
'', 1, 0, 0,
'',
'',
'',
'', 1,
'', $langs->trans(
'to'));
1919if (!empty($arrayfields[
'c.delivery_date'][
'checked'])) {
1920 print
'<td class="liste_titre center">';
1921 print
'<div class="nowrapfordate">';
1922 print $form->selectDate($search_datedelivery_start ? $search_datedelivery_start : -1,
'search_datedelivery_start_', 0, 0, 1,
'', 1, 0, 0,
'',
'',
'',
'', 1,
'', $langs->trans(
'From'));
1924 print
'<div class="nowrapfordate">';
1925 print $form->selectDate($search_datedelivery_end ? $search_datedelivery_end : -1,
'search_datedelivery_end_', 0, 0, 1,
'', 1, 0, 0,
'',
'',
'',
'', 1,
'', $langs->trans(
'to'));
1930if (!empty($arrayfields[
'c.fk_shipping_method'][
'checked'])) {
1931 print
'<td class="liste_titre">';
1932 $form->selectShippingMethod($search_fk_shipping_method,
'search_fk_shipping_method',
'', 1,
'', 1);
1936if (!empty($arrayfields[
'c.fk_cond_reglement'][
'checked'])) {
1937 print
'<td class="liste_titre">';
1938 print $form->getSelectConditionsPaiements((
int) $search_fk_cond_reglement,
'search_fk_cond_reglement', 1, 1, 1);
1942if (!empty($arrayfields[
'c.fk_mode_reglement'][
'checked'])) {
1943 print
'<td class="liste_titre">';
1944 print $form->select_types_paiements($search_fk_mode_reglement,
'search_fk_mode_reglement',
'', 0, 1, 1, 0, -1,
'', 1);
1948if (!empty($arrayfields[
'c.fk_input_reason'][
'checked'])) {
1949 print
'<td class="liste_titre">';
1950 $form->selectInputReason($search_fk_input_reason,
'search_fk_input_reason',
'', 1,
'', 1);
1954if (!empty($arrayfields[
'c.module_source'][
'checked'])) {
1955 print
'<td class="liste_titre">';
1956 print
'<input class="flat maxwidth75" type="text" name="search_module_source" value="'.dol_escape_htmltag($search_module_source).
'">';
1960if (!empty($arrayfields[
'c.pos_source'][
'checked'])) {
1961 print
'<td class="liste_titre">';
1962 print
'<input class="flat maxwidth50" type="text" name="search_pos_source" value="'.dol_escape_htmltag($search_pos_source).
'">';
1966if (!empty($arrayfields[
'c.total_ht'][
'checked'])) {
1967 print
'<td class="liste_titre right">';
1968 print
'<input class="flat" type="text" size="4" name="search_total_ht" value="'.dol_escape_htmltag($search_total_ht).
'">';
1972if (!empty($arrayfields[
'c.total_vat'][
'checked'])) {
1973 print
'<td class="liste_titre right">';
1974 print
'<input class="flat" type="text" size="4" name="search_total_vat" value="'.dol_escape_htmltag($search_total_vat).
'">';
1978if (!empty($arrayfields[
'c.total_ttc'][
'checked'])) {
1979 print
'<td class="liste_titre right">';
1980 print
'<input class="flat" type="text" size="5" name="search_total_ttc" value="'.$search_total_ttc.
'">';
1984if (!empty($arrayfields[
'c.multicurrency_code'][
'checked'])) {
1985 print
'<td class="liste_titre">';
1986 print $form->selectMultiCurrency($search_multicurrency_code,
'search_multicurrency_code', 1);
1990if (!empty($arrayfields[
'c.multicurrency_tx'][
'checked'])) {
1991 print
'<td class="liste_titre">';
1992 print
'<input class="flat" type="text" size="4" name="search_multicurrency_tx" value="'.dol_escape_htmltag($search_multicurrency_tx).
'">';
1996if (!empty($arrayfields[
'c.multicurrency_total_ht'][
'checked'])) {
1997 print
'<td class="liste_titre right">';
1998 print
'<input class="flat" type="text" size="4" name="search_multicurrency_montant_ht" value="'.dol_escape_htmltag($search_multicurrency_montant_ht).
'">';
2002if (!empty($arrayfields[
'c.multicurrency_total_vat'][
'checked'])) {
2003 print
'<td class="liste_titre right">';
2004 print
'<input class="flat" type="text" size="4" name="search_multicurrency_montant_vat" value="'.dol_escape_htmltag($search_multicurrency_montant_vat).
'">';
2008if (!empty($arrayfields[
'c.multicurrency_total_ttc'][
'checked'])) {
2009 print
'<td class="liste_titre right">';
2010 print
'<input class="flat width75" type="text" name="search_multicurrency_montant_ttc" value="'.dol_escape_htmltag($search_multicurrency_montant_ttc).
'">';
2014if (!empty($arrayfields[
'u.login'][
'checked'])) {
2015 print
'<td class="liste_titre">';
2016 print
'<input class="flat width75" type="text" name="search_login" value="'.dol_escape_htmltag($search_login).
'">';
2020if (!empty($arrayfields[
'sale_representative'][
'checked'])) {
2021 print
'<td class="liste_titre"></td>';
2023if (!empty($arrayfields[
'total_pa'][
'checked'])) {
2024 print
'<td class="liste_titre right">';
2027if (!empty($arrayfields[
'total_margin'][
'checked'])) {
2028 print
'<td class="liste_titre right">';
2031if (!empty($arrayfields[
'total_margin_rate'][
'checked'])) {
2032 print
'<td class="liste_titre right">';
2035if (!empty($arrayfields[
'total_mark_rate'][
'checked'])) {
2036 print
'<td class="liste_titre right">';
2041if (!empty($arrayfields[
'c.datec'][
'checked'])) {
2042 print
'<td class="liste_titre">';
2046if (!empty($arrayfields[
'c.tms'][
'checked'])) {
2047 print
'<td class="liste_titre">';
2051if (!empty($arrayfields[
'c.date_cloture'][
'checked'])) {
2052 print
'<td class="liste_titre center">';
2053 print
'<div class="nowrapfordate">';
2054 print $form->selectDate($search_datecloture_start ? $search_datecloture_start : -1,
'search_datecloture_start', 0, 0, 1,
'', 1, 0, 0,
'',
'',
'',
'', 1,
'', $langs->trans(
'From'));
2056 print
'<div class="nowrapfordate">';
2057 print $form->selectDate($search_datecloture_end ? $search_datecloture_end : -1,
'search_datecloture_end', 0, 0, 1,
'', 1, 0, 0,
'',
'',
'',
'', 1,
'', $langs->trans(
'to'));
2062if (!empty($arrayfields[
'c.note_public'][
'checked'])) {
2063 print
'<td class="liste_titre">';
2064 print
'<input class="flat width75" type="text" name="search_note_public" value="'.dolPrintHTMLForAttribute($search_note_public).
'">';
2068if (!empty($arrayfields[
'c.note_private'][
'checked'])) {
2069 print
'<td class="liste_titre">';
2070 print
'<input class="flat width75" type="text" name="search_note_private" value="'.dolPrintHTMLForAttribute($search_note_private).
'">';
2074if (!empty($arrayfields[
'shippable'][
'checked'])) {
2075 print
'<td class="liste_titre maxwidthonsmartphone" align="center">';
2078 print
'<input type="checkbox" name="show_shippable_command" value="1"'.($show_shippable_command ?
' checked' :
'').
'>';
2079 print $langs->trans(
'ShowShippableStatus');
2081 $show_shippable_command = 1;
2087include DOL_DOCUMENT_ROOT.
'/core/tpl/extrafields_list_search_input.tpl.php';
2090$parameters = array(
'arrayfields' => $arrayfields);
2091$reshook = $hookmanager->executeHooks(
'printFieldListOption', $parameters, $object, $action);
2092print $hookmanager->resPrint;
2095if (!empty($arrayfields[
'c.facture'][
'checked'])) {
2096 print
'<td class="liste_titre maxwidthonsmartphone center">';
2097 print $form->selectyesno(
'search_billed', $search_billed, 1, 0, 1, 1);
2102if (!empty($arrayfields[
'c.import_key'][
'checked'])) {
2103 print
'<td class="liste_titre maxwidthonsmartphone center">';
2104 print
'<input class="flat searchstring maxwidth50" type="text" name="search_import_key" value="'.dol_escape_htmltag($search_import_key).
'">';
2109if (!empty($arrayfields[
'c.fk_statut'][
'checked'])) {
2110 print
'<td class="liste_titre center parentonrightofpage">';
2111 $liststatus = array(
2115 -2 => $langs->trans(
"StatusOrderValidatedShort").
'+'.$langs->trans(
"StatusOrderSentShort"),
2116 -3 => $langs->trans(
"StatusOrderValidatedShort").
'+'.$langs->trans(
"StatusOrderSentShort").
'+'.$langs->trans(
"StatusOrderDelivered"),
2121 print $form->selectarray(
'search_status', $liststatus, $search_status, -5, 0, 0,
'', 0, 0, 0,
'',
'search_status width100 onrightofpage', 1);
2125if (!
$conf->main_checkbox_left_column) {
2126 print
'<td class="liste_titre center maxwidthsearch">';
2127 $searchpicto = $form->showFilterButtons();
2146print
'<tr class="liste_titre">';
2149if (
$conf->main_checkbox_left_column) {
2150 print_liste_field_titre($selectedfields, $_SERVER[
"PHP_SELF"],
"",
'', $param,
'', $sortfield, $sortorder,
'maxwidthsearch center ');
2153if (!empty($arrayfields[
'c.rowid'][
'checked'])) {
2154 print_liste_field_titre($arrayfields[
'c.rowid'][
'label'], $_SERVER[
"PHP_SELF"],
'c.rowid',
'', $param,
'', $sortfield, $sortorder,
'center ');
2157if (!empty($arrayfields[
'c.ref'][
'checked'])) {
2158 print_liste_field_titre($arrayfields[
'c.ref'][
'label'], $_SERVER[
"PHP_SELF"],
'c.ref',
'', $param,
'', $sortfield, $sortorder);
2161if (!empty($arrayfields[
'c.ref_ext'][
'checked'])) {
2162 print_liste_field_titre($arrayfields[
'c.ref_ext'][
'label'], $_SERVER[
"PHP_SELF"],
'c.ref_ext',
'', $param,
'', $sortfield, $sortorder);
2165if (!empty($arrayfields[
'c.ref_client'][
'checked'])) {
2166 print_liste_field_titre($arrayfields[
'c.ref_client'][
'label'], $_SERVER[
"PHP_SELF"],
'c.ref_client',
'', $param,
'', $sortfield, $sortorder);
2169if (!empty($arrayfields[
'p.ref'][
'checked'])) {
2170 print_liste_field_titre($arrayfields[
'p.ref'][
'label'], $_SERVER[
"PHP_SELF"],
"p.ref",
"", $param,
'', $sortfield, $sortorder);
2173if (!empty($arrayfields[
'p.title'][
'checked'])) {
2174 print_liste_field_titre($arrayfields[
'p.title'][
'label'], $_SERVER[
"PHP_SELF"],
"p.title",
"", $param,
'', $sortfield, $sortorder);
2177if (!empty($arrayfields[
's.nom'][
'checked'])) {
2178 print_liste_field_titre($arrayfields[
's.nom'][
'label'], $_SERVER[
"PHP_SELF"],
's.nom',
'', $param,
'', $sortfield, $sortorder);
2181if (!empty($arrayfields[
's.name_alias'][
'checked'])) {
2183 print_liste_field_titre($arrayfields[
's.name_alias'][
'label'], $_SERVER[
"PHP_SELF"],
's.name_alias',
'', $param,
'', $sortfield, $sortorder);
2186if (!empty($arrayfields[
's2.nom'][
'checked'])) {
2187 print_liste_field_titre($arrayfields[
's2.nom'][
'label'], $_SERVER[
'PHP_SELF'],
's2.nom',
'', $param,
'', $sortfield, $sortorder);
2190if (!empty($arrayfields[
's.town'][
'checked'])) {
2191 print_liste_field_titre($arrayfields[
's.town'][
'label'], $_SERVER[
"PHP_SELF"],
's.town',
'', $param,
'', $sortfield, $sortorder);
2194if (!empty($arrayfields[
's.zip'][
'checked'])) {
2195 print_liste_field_titre($arrayfields[
's.zip'][
'label'], $_SERVER[
"PHP_SELF"],
's.zip',
'', $param,
'', $sortfield, $sortorder);
2198if (!empty($arrayfields[
'state.nom'][
'checked'])) {
2199 print_liste_field_titre($arrayfields[
'state.nom'][
'label'], $_SERVER[
"PHP_SELF"],
"state.nom",
"", $param,
'', $sortfield, $sortorder);
2202if (!empty($arrayfields[
'country.code_iso'][
'checked'])) {
2203 print_liste_field_titre($arrayfields[
'country.code_iso'][
'label'], $_SERVER[
"PHP_SELF"],
"country.code_iso",
"", $param,
'', $sortfield, $sortorder,
'center ');
2206if (!empty($arrayfields[
'typent.code'][
'checked'])) {
2207 print_liste_field_titre($arrayfields[
'typent.code'][
'label'], $_SERVER[
"PHP_SELF"],
"typent.code",
"", $param,
'', $sortfield, $sortorder,
'center ');
2210if (!empty($arrayfields[
'c.date_commande'][
'checked'])) {
2211 print_liste_field_titre($arrayfields[
'c.date_commande'][
'label'], $_SERVER[
"PHP_SELF"],
'c.date_commande',
'', $param,
'', $sortfield, $sortorder,
'center ');
2214if (!empty($arrayfields[
'c.delivery_date'][
'checked'])) {
2215 print_liste_field_titre($arrayfields[
'c.delivery_date'][
'label'], $_SERVER[
"PHP_SELF"],
'c.date_livraison',
'', $param,
'', $sortfield, $sortorder,
'center ');
2218if (!empty($arrayfields[
'c.fk_shipping_method'][
'checked'])) {
2219 print_liste_field_titre($arrayfields[
'c.fk_shipping_method'][
'label'], $_SERVER[
"PHP_SELF"],
"c.fk_shipping_method",
"", $param,
'', $sortfield, $sortorder);
2222if (!empty($arrayfields[
'c.fk_cond_reglement'][
'checked'])) {
2223 print_liste_field_titre($arrayfields[
'c.fk_cond_reglement'][
'label'], $_SERVER[
"PHP_SELF"],
"c.fk_cond_reglement",
"", $param,
'', $sortfield, $sortorder);
2226if (!empty($arrayfields[
'c.fk_mode_reglement'][
'checked'])) {
2227 print_liste_field_titre($arrayfields[
'c.fk_mode_reglement'][
'label'], $_SERVER[
"PHP_SELF"],
"c.fk_mode_reglement",
"", $param,
'', $sortfield, $sortorder);
2230if (!empty($arrayfields[
'c.fk_input_reason'][
'checked'])) {
2231 print_liste_field_titre($arrayfields[
'c.fk_input_reason'][
'label'], $_SERVER[
"PHP_SELF"],
"c.fk_input_reason",
"", $param,
'', $sortfield, $sortorder);
2234if (!empty($arrayfields[
'c.module_source'][
'checked'])) {
2235 print_liste_field_titre($arrayfields[
'c.module_source'][
'label'], $_SERVER[
"PHP_SELF"],
"c.module_source",
"", $param,
"", $sortfield, $sortorder);
2238if (!empty($arrayfields[
'c.pos_source'][
'checked'])) {
2239 print_liste_field_titre($arrayfields[
'c.pos_source'][
'label'], $_SERVER[
"PHP_SELF"],
"c.pos_source",
"", $param,
"", $sortfield, $sortorder);
2242if (!empty($arrayfields[
'c.total_ht'][
'checked'])) {
2243 print_liste_field_titre($arrayfields[
'c.total_ht'][
'label'], $_SERVER[
"PHP_SELF"],
'c.total_ht',
'', $param,
'', $sortfield, $sortorder,
'right ');
2246if (!empty($arrayfields[
'c.total_vat'][
'checked'])) {
2247 print_liste_field_titre($arrayfields[
'c.total_vat'][
'label'], $_SERVER[
"PHP_SELF"],
'c.total_tva',
'', $param,
'', $sortfield, $sortorder,
'right ');
2250if (!empty($arrayfields[
'c.total_ttc'][
'checked'])) {
2251 print_liste_field_titre($arrayfields[
'c.total_ttc'][
'label'], $_SERVER[
"PHP_SELF"],
'c.total_ttc',
'', $param,
'', $sortfield, $sortorder,
'right ');
2254if (!empty($arrayfields[
'c.multicurrency_code'][
'checked'])) {
2255 print_liste_field_titre($arrayfields[
'c.multicurrency_code'][
'label'], $_SERVER[
'PHP_SELF'],
'c.multicurrency_code',
'', $param,
'', $sortfield, $sortorder);
2258if (!empty($arrayfields[
'c.multicurrency_tx'][
'checked'])) {
2259 print_liste_field_titre($arrayfields[
'c.multicurrency_tx'][
'label'], $_SERVER[
'PHP_SELF'],
'c.multicurrency_tx',
'', $param,
'', $sortfield, $sortorder);
2262if (!empty($arrayfields[
'c.multicurrency_total_ht'][
'checked'])) {
2263 print_liste_field_titre($arrayfields[
'c.multicurrency_total_ht'][
'label'], $_SERVER[
'PHP_SELF'],
'c.multicurrency_total_ht',
'', $param,
'class="right"', $sortfield, $sortorder);
2266if (!empty($arrayfields[
'c.multicurrency_total_vat'][
'checked'])) {
2267 print_liste_field_titre($arrayfields[
'c.multicurrency_total_vat'][
'label'], $_SERVER[
'PHP_SELF'],
'c.multicurrency_total_tva',
'', $param,
'class="right"', $sortfield, $sortorder);
2270if (!empty($arrayfields[
'c.multicurrency_total_ttc'][
'checked'])) {
2271 print_liste_field_titre($arrayfields[
'c.multicurrency_total_ttc'][
'label'], $_SERVER[
'PHP_SELF'],
'c.multicurrency_total_ttc',
'', $param,
'class="right"', $sortfield, $sortorder);
2274if (!empty($arrayfields[
'u.login'][
'checked'])) {
2275 print_liste_field_titre($arrayfields[
'u.login'][
'label'], $_SERVER[
"PHP_SELF"],
'u.login',
'', $param,
'', $sortfield, $sortorder);
2278if (!empty($arrayfields[
'sale_representative'][
'checked'])) {
2279 print_liste_field_titre($arrayfields[
'sale_representative'][
'label'], $_SERVER[
"PHP_SELF"],
"",
"",
"$param",
'', $sortfield, $sortorder);
2282if (!empty($arrayfields[
'total_pa'][
'checked'])) {
2283 print_liste_field_titre($arrayfields[
'total_pa'][
'label'], $_SERVER[
'PHP_SELF'],
'',
'', $param,
'class="right"', $sortfield, $sortorder);
2286if (!empty($arrayfields[
'total_margin'][
'checked'])) {
2287 print_liste_field_titre($arrayfields[
'total_margin'][
'label'], $_SERVER[
'PHP_SELF'],
'',
'', $param,
'class="right"', $sortfield, $sortorder);
2290if (!empty($arrayfields[
'total_margin_rate'][
'checked'])) {
2291 print_liste_field_titre($arrayfields[
'total_margin_rate'][
'label'], $_SERVER[
'PHP_SELF'],
'',
'', $param,
'class="right"', $sortfield, $sortorder);
2294if (!empty($arrayfields[
'total_mark_rate'][
'checked'])) {
2295 print_liste_field_titre($arrayfields[
'total_mark_rate'][
'label'], $_SERVER[
'PHP_SELF'],
'',
'', $param,
'class="right"', $sortfield, $sortorder);
2299if (!empty($arrayfields[
'c.datec'][
'checked'])) {
2300 print_liste_field_titre($arrayfields[
'c.datec'][
'label'], $_SERVER[
"PHP_SELF"],
"c.date_creation",
"", $param,
'', $sortfield, $sortorder,
'center nowrap ');
2303if (!empty($arrayfields[
'c.tms'][
'checked'])) {
2304 print_liste_field_titre($arrayfields[
'c.tms'][
'label'], $_SERVER[
"PHP_SELF"],
"c.tms",
"", $param,
'', $sortfield, $sortorder,
'center nowrap ');
2307if (!empty($arrayfields[
'c.date_cloture'][
'checked'])) {
2308 print_liste_field_titre($arrayfields[
'c.date_cloture'][
'label'], $_SERVER[
"PHP_SELF"],
"c.date_cloture",
"", $param,
'', $sortfield, $sortorder,
'center nowrap ');
2311if (!empty($arrayfields[
'c.note_public'][
'checked'])) {
2312 print_liste_field_titre($arrayfields[
'c.note_public'][
'label'], $_SERVER[
"PHP_SELF"],
"c.note_public",
"", $param,
'', $sortfield, $sortorder,
'');
2315if (!empty($arrayfields[
'c.note_private'][
'checked'])) {
2316 print_liste_field_titre($arrayfields[
'c.note_private'][
'label'], $_SERVER[
"PHP_SELF"],
"c.note_private",
"", $param,
'', $sortfield, $sortorder,
'');
2319if (!empty($arrayfields[
'shippable'][
'checked'])) {
2320 print_liste_field_titre($arrayfields[
'shippable'][
'label'], $_SERVER[
"PHP_SELF"],
'',
'', $param,
'', $sortfield, $sortorder,
'center ');
2324include DOL_DOCUMENT_ROOT.
'/core/tpl/extrafields_list_search_title.tpl.php';
2327$parameters = array(
'arrayfields' => $arrayfields,
'param' => $param,
'sortfield' => $sortfield,
'sortorder' => $sortorder,
'totalarray' => &
$totalarray);
2328$reshook = $hookmanager->executeHooks(
'printFieldListTitle', $parameters, $object, $action);
2329print $hookmanager->resPrint;
2332if (!empty($arrayfields[
'c.facture'][
'checked'])) {
2333 print_liste_field_titre($arrayfields[
'c.facture'][
'label'], $_SERVER[
"PHP_SELF"],
'c.facture',
'', $param,
'', $sortfield, $sortorder,
'center ');
2337if (!empty($arrayfields[
'c.import_key'][
'checked'])) {
2338 print_liste_field_titre($arrayfields[
'c.import_key'][
'label'], $_SERVER[
"PHP_SELF"],
"c.import_key",
"", $param,
'', $sortfield, $sortorder,
'center ');
2342if (!empty($arrayfields[
'c.fk_statut'][
'checked'])) {
2343 print_liste_field_titre($arrayfields[
'c.fk_statut'][
'label'], $_SERVER[
"PHP_SELF"],
"c.fk_statut",
"", $param,
'', $sortfield, $sortorder,
'center ');
2347if (!
$conf->main_checkbox_left_column) {
2348 print_liste_field_titre($selectedfields, $_SERVER[
"PHP_SELF"],
"",
'', $param,
'', $sortfield, $sortorder,
'maxwidthsearch center ');
2355$productstat_cache = array();
2356$productstat_cachevirtual = array();
2357$getNomUrl_cache = array();
2363$with_margin_info =
false;
2365 !empty($arrayfields[
'total_pa'][
'checked'])
2366 || !empty($arrayfields[
'total_margin'][
'checked'])
2367 || !empty($arrayfields[
'total_margin_rate'][
'checked'])
2368 || !empty($arrayfields[
'total_mark_rate'][
'checked'])
2371 $with_margin_info =
true;
2383$imaxinloop = ($limit ? min($num, $limit) : $num);
2384while ($i < $imaxinloop) {
2385 $obj =
$db->fetch_object($resql);
2390 $typenArray = $formcompany->typent_array(1);
2398 $companystatic->id = $obj->socid;
2399 $companystatic->name = $obj->name;
2400 $companystatic->name_alias = $obj->alias;
2401 $companystatic->client = $obj->client;
2402 $companystatic->fournisseur = $obj->fournisseur;
2403 $companystatic->code_client = $obj->code_client;
2404 $companystatic->email = $obj->email;
2405 $companystatic->phone = $obj->phone;
2406 $companystatic->address = $obj->address;
2407 $companystatic->zip = $obj->zip;
2408 $companystatic->town = $obj->town;
2409 $companystatic->country_code = $obj->country_code;
2410 if (!isset($getNomUrl_cache[$obj->socid])) {
2411 $getNomUrl_cache[$obj->socid] = $companystatic->getNomUrl(1,
'customer', 100, 0, 1, empty($arrayfields[
's.name_alias'][
'checked']) ? 0 : 1);
2414 $generic_commande->id = $obj->rowid;
2415 $generic_commande->ref = $obj->ref;
2416 $generic_commande->status = $obj->fk_statut;
2417 $generic_commande->statut = $obj->fk_statut;
2418 $generic_commande->status = $obj->fk_statut;
2419 $generic_commande->billed = $obj->billed;
2420 $generic_commande->date =
$db->jdate($obj->date_commande);
2421 $generic_commande->delivery_date =
$db->jdate($obj->delivery_date);
2422 $generic_commande->ref_client = $obj->ref_client;
2423 $generic_commande->total_ht = $obj->total_ht;
2424 $generic_commande->total_tva = $obj->total_tva;
2425 $generic_commande->total_ttc = $obj->total_ttc;
2426 $generic_commande->note_public = $obj->note_public;
2427 $generic_commande->note_private = $obj->note_private;
2429 $generic_commande->thirdparty = $companystatic;
2432 $projectstatic->id = $obj->project_id;
2433 $projectstatic->ref = $obj->project_ref;
2434 $projectstatic->title = $obj->project_label;
2436 $marginInfo = array();
2437 if ($with_margin_info) {
2438 $generic_commande->fetch_lines();
2439 $marginInfo = $formmargin->getMarginInfosArray($generic_commande);
2440 $total_ht += $obj->total_ht;
2441 $total_margin += $marginInfo[
'total_margin'];
2444 if ($mode ==
'kanban') {
2446 print
'<tr class="trkanban"><td colspan="'.$savnbfield.
'">';
2447 print
'<div class="box-flex-container kanban">';
2452 if ($massactionbutton || $massaction) {
2454 if (in_array(
$object->id, $arrayofselected)) {
2458 print $generic_commande->getKanbanView(
'', array(
'selected' => $selected));
2459 if ($i == ($imaxinloop - 1)) {
2466 print
'<tr data-rowid="'.$object->id.
'" class="oddeven row-with-select status'.$generic_commande->status.((getDolGlobalInt(
'MAIN_FINISHED_LINES_OPACITY') == 1 && $obj->status > 1) ?
' opacitymedium' :
'').
'">';
2469 if (
$conf->main_checkbox_left_column) {
2470 print
'<td class="nowrap center">';
2471 if ($massactionbutton || $massaction) {
2473 if (in_array($obj->rowid, $arrayofselected)) {
2476 print
'<input id="cb'.$obj->rowid.
'" class="flat checkforselect" type="checkbox" name="toselect[]" value="'.$obj->rowid.
'"'.($selected ?
' checked="checked"' :
'').
'>';
2485 if (!empty($arrayfields[
'c.rowid'][
'checked'])) {
2486 print
'<td class="center" data-key="id">'.$obj->rowid.
'</td>';
2493 if (!empty($arrayfields[
'c.ref'][
'checked'])) {
2494 print
'<td class="nowraponall">';
2495 $getNomUrlOption = $search_status != 2 ? 0 : $obj->fk_statut;
2501 $getNomUrlOption =
'';
2503 print $generic_commande->getNomUrl(1, $getNomUrlOption, 0, 0, 0, 1, 1);
2507 $urlsource = $_SERVER[
'PHP_SELF'].
'?id='.$obj->rowid;
2508 print $formfile->getDocumentsLink($generic_commande->element, $filename, $filedir);
2517 if (!empty($arrayfields[
'c.ref_ext'][
'checked'])) {
2518 print
'<td class="nowrap tdoverflowmax75" title="'.dol_escape_htmltag($obj->ref_ext).
'">';
2527 if (!empty($arrayfields[
'c.ref_client'][
'checked'])) {
2528 print
'<td class="nowrap tdoverflowmax150" title="'.dol_escape_htmltag($obj->ref_client).
'">';
2537 if (!empty($arrayfields[
'p.ref'][
'checked'])) {
2538 print
'<td class="nocellnopadd nowraponall">';
2539 if ($obj->project_id > 0) {
2540 print $projectstatic->getNomUrl(1);
2549 if (!empty($arrayfields[
'p.title'][
'checked'])) {
2550 print
'<td class="nowraponall">';
2551 if ($obj->project_id > 0) {
2552 print $projectstatic->title;
2561 if (!empty($arrayfields[
's.nom'][
'checked'])) {
2562 print
'<td class="tdoverflowmax150">';
2564 print $companystatic->getNomUrl(1,
'customer', 100, 0, 1, empty($arrayfields[
's.name_alias'][
'checked']) ? 0 : 1);
2566 print $getNomUrl_cache[$obj->socid];
2571 if ($user->hasRight(
'facture',
'creer')) {
2572 if (($obj->fk_statut > 0 && $obj->fk_statut < 3) || ($obj->fk_statut == 3 && $obj->billed == 0)) {
2573 print
' <a href="'.DOL_URL_ROOT.
'/commande/list.php?socid='.$companystatic->id.
'&search_billed=0&autoselectall=1">';
2574 print
img_picto($langs->trans(
"CreateInvoiceForThisCustomer").
' : '.$companystatic->name,
'object_bill',
'hideonsmartphone').
'</a>';
2585 if (!empty($arrayfields[
's.name_alias'][
'checked'])) {
2586 print
'<td class="nocellnopadd tdoverflowmax100" title="'.dolPrintHTMLForTextArea($obj->alias).
'">';
2595 if (!empty($arrayfields[
's2.nom'][
'checked'])) {
2596 print
'<td class="tdoverflowmax200">';
2597 if ($obj->fk_parent > 0) {
2598 if (!isset($company_url_list[$obj->fk_parent])) {
2600 $res = $companyparent->fetch($obj->fk_parent);
2602 $company_url_list[$obj->fk_parent] = $companyparent->getNomUrl(1);
2605 if (isset($company_url_list[$obj->fk_parent])) {
2606 print $company_url_list[$obj->fk_parent];
2616 if (!empty($arrayfields[
's.town'][
'checked'])) {
2617 print
'<td class="tdoverflowmax100" title="'.dolPrintHTMLForTextArea($obj->town).
'">';
2626 if (!empty($arrayfields[
's.zip'][
'checked'])) {
2627 print
'<td class="tdoverflowmax100" title="'.dolPrintHTMLForTextArea($obj->zip).
'">';
2636 if (!empty($arrayfields[
'state.nom'][
'checked'])) {
2637 print
'<td class="tdoverflowmax100" title="'.dolPrintHTMLForTextArea($obj->state_name).
'">'.
dolPrintLabel($obj->state_name).
"</td>\n";
2644 if (!empty($arrayfields[
'country.code_iso'][
'checked'])) {
2645 $tmparray =
getCountry($obj->fk_pays,
'all');
2646 print
'<td class="center tdoverflowmax100" title="'.dolPrintHTMLForAttribute($tmparray[
'label']).
'">';
2655 if (!empty($arrayfields[
'typent.code'][
'checked'])) {
2656 if (!is_array($typenArray) || count($typenArray) == 0) {
2657 $typenArray = $formcompany->typent_array(1);
2659 if (!empty($obj->typent_code)) {
2660 print
'<td class="center tdoverflowmax100" title="'.dolPrintHTMLForAttribute($typenArray[$obj->typent_code]).
'">';
2661 print $typenArray[$obj->typent_code];
2663 print
'<td class="center tdoverflowmax100">';
2673 if (!empty($arrayfields[
'c.date_commande'][
'checked'])) {
2674 print
'<td class="center nowraponall">';
2677 if ($generic_commande->hasDelay()) {
2678 print
img_picto($langs->trans(
"Late").
' : '.$generic_commande->showDelay(),
"warning");
2687 if (!empty($arrayfields[
'c.delivery_date'][
'checked'])) {
2688 print
'<td class="center nowraponall">';
2697 if (!empty($arrayfields[
'c.fk_shipping_method'][
'checked'])) {
2699 $form->formSelectShippingMethod(
'', $obj->fk_shipping_method,
'none', 1);
2707 if (!empty($arrayfields[
'c.fk_cond_reglement'][
'checked'])) {
2709 $form->form_conditions_reglement($_SERVER[
'PHP_SELF'], $obj->fk_cond_reglement,
'none', 0,
'', 1, $obj->deposit_percent);
2717 if (!empty($arrayfields[
'c.fk_mode_reglement'][
'checked'])) {
2719 $form->form_modes_reglement($_SERVER[
'PHP_SELF'], $obj->fk_mode_reglement,
'none',
'', -1);
2727 if (!empty($arrayfields[
'c.fk_input_reason'][
'checked'])) {
2729 $form->formInputReason($_SERVER[
'PHP_SELF'], $obj->fk_input_reason,
'none', 0);
2737 if (!empty($arrayfields[
'c.module_source'][
'checked'])) {
2746 if (!empty($arrayfields[
'c.pos_source'][
'checked'])) {
2756 if (!empty($arrayfields[
'c.total_ht'][
'checked'])) {
2757 print
'<td class="nowraponall right"><span class="amount">'.price($obj->total_ht).
"</span></td>\n";
2765 $totalarray[
'val'][
'c.total_ht'] += $obj->total_ht;
2767 $totalarray[
'val'][
'c.total_ht'] = $obj->total_ht;
2772 if (!empty($arrayfields[
'c.total_vat'][
'checked'])) {
2773 print
'<td class="nowrap right"><span class="amount">'.price($obj->total_tva).
"</span></td>\n";
2781 $totalarray[
'val'][
'c.total_tva'] += $obj->total_tva;
2783 $totalarray[
'val'][
'c.total_tva'] = $obj->total_tva;
2788 if (!empty($arrayfields[
'c.total_ttc'][
'checked'])) {
2789 print
'<td class="nowrap right"><span class="amount">'.price($obj->total_ttc).
"</span></td>\n";
2797 $totalarray[
'val'][
'c.total_ttc'] += $obj->total_ttc;
2799 $totalarray[
'val'][
'c.total_ttc'] = $obj->total_ttc;
2804 if (!empty($arrayfields[
'c.multicurrency_code'][
'checked'])) {
2805 print
'<td class="nowrap">'.$obj->multicurrency_code.
' - '.$langs->trans(
'Currency'.$obj->multicurrency_code).
"</td>\n";
2812 if (!empty($arrayfields[
'c.multicurrency_tx'][
'checked'])) {
2813 print
'<td class="nowrap">';
2814 $form->form_multicurrency_rate($_SERVER[
'PHP_SELF'].
'?id='.$obj->rowid, $obj->multicurrency_tx,
'none', $obj->multicurrency_code);
2822 if (!empty($arrayfields[
'c.multicurrency_total_ht'][
'checked'])) {
2823 print
'<td class="right nowrap"><span class="amount">'.price($obj->multicurrency_total_ht).
"</span></td>\n";
2829 if (!empty($arrayfields[
'c.multicurrency_total_vat'][
'checked'])) {
2830 print
'<td class="right nowrap"><span class="amount">'.price($obj->multicurrency_total_vat).
"</span></td>\n";
2836 if (!empty($arrayfields[
'c.multicurrency_total_ttc'][
'checked'])) {
2837 print
'<td class="right nowrap"><span class="amount">'.price($obj->multicurrency_total_ttc).
"</span></td>\n";
2843 $userstatic->id = $obj->fk_user_author;
2844 $userstatic->login = $obj->login;
2845 $userstatic->lastname = $obj->lastname;
2846 $userstatic->firstname = $obj->firstname;
2847 $userstatic->email = $obj->user_email;
2848 $userstatic->status = $obj->user_statut;
2849 $userstatic->entity = $obj->entity;
2850 $userstatic->photo = $obj->photo;
2851 $userstatic->office_phone = $obj->office_phone;
2852 $userstatic->office_fax = $obj->office_fax;
2853 $userstatic->user_mobile = $obj->user_mobile;
2854 $userstatic->job = $obj->job;
2855 $userstatic->gender = $obj->gender;
2858 if (!empty($arrayfields[
'u.login'][
'checked'])) {
2859 print
'<td class="tdoverflowmax125">';
2860 if ($userstatic->id) {
2861 print $userstatic->getNomUrl(-1);
2872 if (!empty($arrayfields[
'sale_representative'][
'checked'])) {
2874 if ($obj->socid > 0) {
2875 $listsalesrepresentatives = $companystatic->getSalesRepresentatives($user);
2876 if ($listsalesrepresentatives < 0) {
2879 $nbofsalesrepresentative = count($listsalesrepresentatives);
2880 if ($nbofsalesrepresentative > 6) {
2882 print $nbofsalesrepresentative;
2883 } elseif ($nbofsalesrepresentative > 0) {
2885 foreach ($listsalesrepresentatives as $val) {
2886 $userstatic->id = $val[
'id'];
2887 $userstatic->lastname = $val[
'lastname'];
2888 $userstatic->firstname = $val[
'firstname'];
2889 $userstatic->email = $val[
'email'];
2890 $userstatic->status = $val[
'statut'];
2891 $userstatic->entity = $val[
'entity'];
2892 $userstatic->photo = $val[
'photo'];
2893 $userstatic->login = $val[
'login'];
2894 $userstatic->office_phone = $val[
'office_phone'];
2895 $userstatic->office_fax = $val[
'office_fax'];
2896 $userstatic->user_mobile = $val[
'user_mobile'];
2897 $userstatic->job = $val[
'job'];
2898 $userstatic->gender = $val[
'gender'];
2900 print ($nbofsalesrepresentative < 2) ? $userstatic->getNomUrl(-1,
'', 0, 0, 12) : $userstatic->getNomUrl(-2);
2902 if ($j < $nbofsalesrepresentative) {
2919 if (!empty($arrayfields[
'total_pa'][
'checked'])) {
2920 print
'<td class="right nowrap">'.price($marginInfo[
'pa_total']).
'</td>';
2927 if (!empty($arrayfields[
'total_margin'][
'checked'])) {
2928 print
'<td class="right nowrap">'.price($marginInfo[
'total_margin']).
'</td>';
2940 $totalarray[
'val'][
'total_margin'] += $marginInfo[
'total_margin'];
2944 if (!empty($arrayfields[
'total_margin_rate'][
'checked'])) {
2945 print
'<td class="right nowrap">'.(($marginInfo[
'total_margin_rate'] ==
'') ?
'' :
price($marginInfo[
'total_margin_rate'], 0,
'', 0, 0, 2).
'%').
'</td>';
2952 if (!empty($arrayfields[
'total_mark_rate'][
'checked'])) {
2953 print
'<td class="right nowrap">'.(($marginInfo[
'total_mark_rate'] ==
'') ?
'' :
price($marginInfo[
'total_mark_rate'], 0,
'', 0, 0, 2).
'%').
'</td>';
2960 if ($i >= $imaxinloop - 1) {
2961 if (!empty($total_ht)) {
2970 if (!empty($arrayfields[
'c.datec'][
'checked'])) {
2971 print
'<td class="center nowraponall">';
2980 if (!empty($arrayfields[
'c.tms'][
'checked'])) {
2981 print
'<td class="center nowraponall">';
2982 print
dol_print_date(
$db->jdate($obj->date_modification),
'dayhour',
'tzuserrel');
2990 if (!empty($arrayfields[
'c.date_cloture'][
'checked'])) {
2991 print
'<td class="center nowraponall">';
3000 if (!empty($arrayfields[
'c.note_public'][
'checked'])) {
3001 print
'<td class="sensiblehtmlcontent maxwidth250imp classfortooltip" title="'.dolPrintHTMLForAttribute(
dolGetFirstLineOfText($obj->note_public, 20)).
'">';
3002 print
'<div class="small lineheightsmall twolinesmax-normallineheight">'.dolPrintHTML(
dolGetFirstLineOfText($obj->note_public, 5)).
'</div>';
3010 if (!empty($arrayfields[
'c.note_private'][
'checked'])) {
3011 print
'<td class="sensiblehtmlcontent maxwidth250imp classfortooltip" title="'.dolPrintHTMLForAttribute(
dolGetFirstLineOfText($obj->note_private, 20)).
'">';
3012 print
'<div class="small lineheightsmall twolinesmax-normallineheight">'.dolPrintHTML(
dolGetFirstLineOfText($obj->note_private, 5)).
'</div>';
3020 if (!empty($arrayfields[
'shippable'][
'checked'])) {
3021 print
'<td class="center">';
3022 if (!empty($show_shippable_command) &&
isModEnabled(
'stock')) {
3024 $commande->id = (int) $obj->rowid;
3025 $commande->status = (int) $obj->fk_statut;
3026 $commande->statut = (int) $obj->fk_statut;
3028 $shippableInfos = $commande->getShippableInfos();
3030 if ($shippableInfos[
'has_product']) {
3031 print
'<a href="'.DOL_URL_ROOT.
'/expedition/shipment.php?id='.(int) $obj->rowid.
'">';
3032 print $form->textwithtooltip(
'', $shippableInfos[
'textinfo'], 2, 1, $shippableInfos[
'texticon'],
'', 2);
3035 if (!empty($shippableInfos[
'warning'])) {
3037 print $form->textwithtooltip(
'', $langs->trans(
"NotEnoughForAllOrders"), 2, 1,
img_picto(
'',
'error',
'', 0, 0, 0,
'',
'2'),
'', 2);
3048 include DOL_DOCUMENT_ROOT.
'/core/tpl/extrafields_list_print_fields.tpl.php';
3050 $parameters = array(
'arrayfields' => $arrayfields,
'obj' => $obj,
'i' => $i,
'totalarray' => &
$totalarray);
3051 $reshook = $hookmanager->executeHooks(
'printFieldListValue', $parameters, $object, $action);
3052 print $hookmanager->resPrint;
3055 if (!empty($arrayfields[
'c.facture'][
'checked'])) {
3056 print
'<td class="center">';
3058 print
yn($obj->billed, $langs->trans(
"Billed"));
3067 if (!empty($arrayfields[
'c.import_key'][
'checked'])) {
3068 print
'<td class="nowrap center">'.dol_escape_htmltag($obj->import_key).
'</td>';
3075 if (!empty($arrayfields[
'c.fk_statut'][
'checked'])) {
3076 print
'<td class="nowrap center">'.$generic_commande->LibStatut($obj->fk_statut, $obj->billed, 5, 1).
'</td>';
3083 if (!
$conf->main_checkbox_left_column) {
3084 print
'<td class="nowrap center">';
3085 if ($massactionbutton || $massaction) {
3087 if (in_array($obj->rowid, $arrayofselected)) {
3090 print
'<input id="cb'.$obj->rowid.
'" class="flat checkforselect" type="checkbox" name="toselect[]" value="'.$obj->rowid.
'"'.($selected ?
' checked="checked"' :
'').
'>';
3100 $total += $obj->total_ht;
3101 $subtotal += $obj->total_ht;
3107include DOL_DOCUMENT_ROOT.
'/core/tpl/list_print_total.tpl.php';
3112 foreach ($arrayfields as $key => $val) {
3113 if (!empty($val[
'checked'])) {
3117 print
'<tr><td colspan="'.$colspan.
'"><span class="opacitymedium">'.$langs->trans(
"NoRecordFound").
'</span></td></tr>';
3122$parameters = array(
'arrayfields' => $arrayfields,
'sql' => $sql);
3123$reshook = $hookmanager->executeHooks(
'printFieldListFooter', $parameters, $object, $action);
3124print $hookmanager->resPrint;
3126print
'</table>'.
"\n";
3129print
'</form>'.
"\n";
3131if (in_array(
'builddoc', array_keys($arrayofmassactions)) && ($nbtotalofrecords ===
'' || $nbtotalofrecords)) {
3132 $hidegeneratedfilelistifempty = 1;
3133 if ($massaction ==
'builddoc' || $action ==
'remove_file' || $show_files) {
3134 $hidegeneratedfilelistifempty = 0;
3138 $urlsource = $_SERVER[
'PHP_SELF'].
'?sortfield='.$sortfield.
'&sortorder='.$sortorder;
3139 $urlsource .= str_replace(
'&',
'&', $param);
3141 $filedir = $diroutputmassaction;
3142 $genallowed = $permissiontoread;
3143 $delallowed = $permissiontoadd;
3145 print $formfile->showdocuments(
'massfilesarea_orders',
'', $filedir, $urlsource, 0, $delallowed,
'', 1, 1, 0, 48, 1, $param, $title,
'',
'',
'',
null, $hidegeneratedfilelistifempty);
$id
Support class for third parties, contacts, members, users or resources.
if(! $sortfield) if(! $sortorder) $object
llxFooter($comment='', $zone='private', $disabledoutputofmessages=0)
Empty footer.
if(!defined('NOREQUIRESOC')) if(!defined( 'NOREQUIRETRAN')) if(!defined('NOTOKENRENEWAL')) if(!defined( 'NOREQUIREMENU')) if(!defined('NOREQUIREHTML')) if(!defined( 'NOREQUIREAJAX')) llxHeader($head='', $title='', $help_url='', $target='', $disablejs=0, $disablehead=0, $arrayofjs='', $arrayofcss='', $morequerystring='', $morecssonbody='', $replacemainareaby='', $disablenofollow=0, $disablenoindex=0)
Empty header.
Class to manage customers orders.
const STATUS_SHIPMENTONPROCESS
Shipment on process.
const STATUS_CLOSED
Closed (Sent, billed or not)
const STATUS_CANCELED
Canceled status.
const STATUS_DRAFT
Draft status.
const STATUS_VALIDATED
Validated status.
Class to manage absolute discounts.
Class to manage invoices.
Class to manage invoice lines.
Class to manage products or services.
Class to manage projects.
Class to manage third parties objects (customers, suppliers, prospects...)
Class to manage Dolibarr users.
getCountry($searchkey, $withcode='', $dbtouse=null, $outputlangs=null, $entconv=1, $searchlabel='')
Return country label, code or id from an id, code or label.
$date_start
Variables from include:
dol_now($mode='gmt')
Return date for now.
dol_mktime($hour, $minute, $second, $month, $day, $year, $gm='auto', $check=1)
Return a timestamp date built from detailed information (by default a local PHP server timestamp) Rep...
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)
dolPrintHTML($s, $allowiframe=0, $moreallowedtags=array())
Return a string (that can be on several lines) ready to be output on a HTML page.
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.
dol_sanitizeFileName($str, $newstr='_', $unaccent=1, $includequotes=0, $allowdash=0)
Clean a string to use it as a file name.
price($amount, $form=0, $outlangs='', $trunc=1, $rounding=-1, $forcerounding=-1, $currency_code='')
Function to format a value into an amount for visual output Function used into PDF and HTML pages.
natural_search($fields, $value, $mode=0, $nofirstand=0, $sqltoadd='')
Generate natural SQL search string for a criteria (this criteria can be tested on one or several fiel...
getDolGlobalInt($key, $default=0)
Return a Dolibarr global constant int value.
dol_sort_array(&$array, $index, $order='asc', $natsort=0, $case_sensitive=0, $keepindex=0)
Advanced sort array by the value of a given key, which produces ascending (default) or descending out...
GETPOST($paramname, $check='alphanohtml', $method=0, $filter=null, $options=null, $noreplace=0, $nodefault=0)
Return value of a param into GET or POST supervariable.
dol_concatdesc($text1, $text2, $forxml=false, $invert=false)
Concat 2 descriptions with a new line between them (second operand after first one with appropriate n...
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.
GETPOSTINT($paramname, $method=0, $nodefault=0)
Return the value of a $_GET or $_POST supervariable, converted into integer.
dol_print_date($time, $format='', $tzoutput='auto', $outputlangs=null, $encodetooutput=false, $decorate=0)
Output date in a string format according to outputlangs (or langs if not defined).
dol_print_error($db=null, $error='', $errors=null)
Displays error message system with all the information to facilitate the diagnosis and the escalation...
GETPOSTISSET($paramname)
Return true if we are in a context of submitting the parameter $paramname from a POST of a form.
getDolGlobalString($key, $default='')
Return a Dolibarr global constant string value.
isModEnabled($module)
Is Dolibarr module enabled.
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...
print $langs trans("Show") . '< td style="' . $timeColor . '" align="center"> s</td > badge status0 badge status4 badge status3 Error badge status8< td align="center">< span class="badge ' . $badge . '"></span ></td >< td align="center">< a href="#" class="button button-small" onclick="openLogModal(this)" data-req="' . dol_escape_htmltag($reqSafe) . '" data-res="' . dol_escape_htmltag($resSafe) . '" data-err="' . dol_escape_htmltag($errSafe) . '">< span class="fa fa-search-plus"></span ></a ></td ></tr >< tr >< td colspan="' . $colspan . '" class="opacitymedium"></td ></tr ></table ></div ></form > logModal none logModal none s a JSON string
buildzip.php
restrictedArea(User $user, $features, $object=0, $tableandshare='', $feature2='', $dbt_keyfield='fk_soc', $dbt_select='rowid', $isdraft=0, $nodie=0, $mode='')
Check permissions of a user to show a page and an object.