dolibarr 25.0.0-alpha
stocktransfer_list.php
Go to the documentation of this file.
1<?php
2/* Copyright (C) 2007-2017 Laurent Destailleur <eldy@users.sourceforge.net>
3 * Copyright (C) 2021 Gauthier VERDOL <gauthier.verdol@atm-consulting.fr>
4 * Copyright (C) 2024 Frédéric France <frederic.france@free.fr>
5 * Copyright (C) 2025-2026 MDW <mdeweerd@users.noreply.github.com>
6 *
7 * This program is free software; you can redistribute it and/or modify
8 * it under the terms of the GNU General Public License as published by
9 * the Free Software Foundation; either version 3 of the License, or
10 * (at your option) any later version.
11 *
12 * This program is distributed in the hope that it will be useful,
13 * but WITHOUT ANY WARRANTY; without even the implied warranty of
14 * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the
15 * GNU General Public License for more details.
16 *
17 * You should have received a copy of the GNU General Public License
18 * along with this program. If not, see <https://www.gnu.org/licenses/>.
19 */
20
27// Load Dolibarr environment
28require '../../../main.inc.php';
36require_once DOL_DOCUMENT_ROOT.'/core/class/html.formcompany.class.php';
37require_once DOL_DOCUMENT_ROOT.'/core/lib/date.lib.php';
38require_once DOL_DOCUMENT_ROOT.'/core/lib/company.lib.php';
39require_once DOL_DOCUMENT_ROOT.'/product/stock/stocktransfer/class/stocktransfer.class.php';
40
41// Load translation files required by the page
42$langs->loadLangs(array("stocks", "other"));
43
44// Get parameters
45$action = GETPOST('action', 'aZ09') ? GETPOST('action', 'aZ09') : 'view'; // The action 'add', 'create', 'edit', 'update', 'view', ...
46$massaction = GETPOST('massaction', 'alpha'); // The bulk action (combo box choice into lists)
47$show_files = GETPOSTINT('show_files'); // Show files area generated by bulk actions ?
48$confirm = GETPOST('confirm', 'alpha'); // Result of a confirmation
49$cancel = GETPOST('cancel', 'alpha'); // We click on a Cancel button
50$toselect = GETPOST('toselect', 'array:int'); // Array of ids of elements selected into a list
51$contextpage = GETPOST('contextpage', 'aZ') ? GETPOST('contextpage', 'aZ') : 'stocktransferlist'; // To manage different context of search
52$backtopage = GETPOST('backtopage', 'alpha'); // Go back to a dedicated page
53$optioncss = GETPOST('optioncss', 'aZ'); // Option for the css output (always '' except when 'print')
54$mode = GETPOST('mode', 'aZ'); // The output mode ('list', 'kanban', 'hierarchy', 'calendar', ...)
55
56$id = GETPOSTINT('id');
57
58// Load variable for pagination
59$limit = GETPOSTINT('limit') ? GETPOSTINT('limit') : $conf->liste_limit;
60$sortfield = GETPOST('sortfield', 'aZ09comma');
61$sortorder = GETPOST('sortorder', 'aZ09comma');
62$page = GETPOSTISSET('pageplusone') ? (GETPOSTINT('pageplusone') - 1) : GETPOSTINT("page");
63if (empty($page) || $page < 0 || GETPOST('button_search', 'alpha') || GETPOST('button_removefilter', 'alpha')) {
64 // If $page is not defined, or '' or -1 or if we click on clear filters
65 $page = 0;
66}
67$offset = $limit * $page;
68$pageprev = $page - 1;
69$pagenext = $page + 1;
70
71// Initialize a technical objects
72$object = new StockTransfer($db);
73$extrafields = new ExtraFields($db);
74$diroutputmassaction = getMultidirOutput($object, '', 0, 'temp') . 'massgeneration/'.$user->id;
75$hookmanager->initHooks(array('stocktransferlist')); // Note that conf->hooks_modules contains array
76
77// Fetch optionals attributes and labels
78$extrafields->fetch_name_optionals_label($object->table_element);
79//$extrafields->fetch_name_optionals_label($object->table_element_line);
80
81$search_array_options = $extrafields->getOptionalsFromPost($object->table_element, '', 'search_');
82
83// Default sort order (if not yet defined by previous GETPOST)
84if (!$sortfield) {
85 reset($object->fields); // Reset is required to avoid key() to return null.
86 $sortfield = "t.".key($object->fields); // Set here default search field. By default 1st field in definition.
87}
88if (!$sortorder) {
89 $sortorder = "ASC";
90}
91
92// Initialize array of search criteria
93$search_all = trim(GETPOST('search_all', 'alphanohtml'));
94$search = array();
95foreach ($object->fields as $key => $val) {
96 if (GETPOST('search_'.$key, 'alpha') !== '') {
97 $search[$key] = GETPOST('search_'.$key, 'alpha');
98 }
99 if (preg_match('/^(date|timestamp|datetime)/', $val['type'])) {
100 $search[$key.'_dtstart'] = dol_mktime(0, 0, 0, GETPOSTINT('search_'.$key.'_dtstartmonth'), GETPOSTINT('search_'.$key.'_dtstartday'), GETPOSTINT('search_'.$key.'_dtstartyear'));
101 $search[$key.'_dtend'] = dol_mktime(23, 59, 59, GETPOSTINT('search_'.$key.'_dtendmonth'), GETPOSTINT('search_'.$key.'_dtendday'), GETPOSTINT('search_'.$key.'_dtendyear'));
102 }
103}
104
105// List of fields to search into when doing a "search in all"
106$fieldstosearchall = array();
107foreach ($object->fields as $key => $val) {
108 if (!empty($val['searchall'])) {
109 $fieldstosearchall['t.'.$key] = $val['label'];
110 }
111}
112
113// Definition of array of fields for columns
114$arrayfields = array();
115foreach ($object->fields as $key => $val) {
116 // If $val['visible']==0, then we never show the field
117 if (!empty($val['visible'])) {
118 $visible = (int) dol_eval((string) $val['visible'], 1);
119 $arrayfields['t.'.$key] = array(
120 'label' => $val['label'],
121 'checked' => (($visible < 0) ? 0 : 1),
122 'enabled' => (abs($visible) != 3 && (bool) dol_eval((string) $val['enabled'], 1)),
123 'position' => $val['position'],
124 'help' => isset($val['help']) ? $val['help'] : ''
125 );
126 }
127}
128// Extra fields
129include DOL_DOCUMENT_ROOT.'/core/tpl/extrafields_list_array_fields.tpl.php';
130// Add hook to complete $arrayfield
131$parameters = array('arrayfields' => &$arrayfields);
132$reshook = $hookmanager->executeHooks('completeArrayFields', $parameters, $object, $action); // Note that $action and $object may have been modified by hook
133
134$object->fields = dol_sort_array($object->fields, 'position');
135$arrayfields = dol_sort_array($arrayfields, 'position');
136
137$permissiontoread = $user->hasRight('stocktransfer', 'stocktransfer', 'read');
138$permissiontoadd = $user->hasRight('stocktransfer', 'stocktransfer', 'write');
139$permissiontodelete = $user->hasRight('stocktransfer', 'stocktransfer', 'delete');
140
141// Security check
142if (empty($conf->stocktransfer->enabled)) {
143 accessforbidden('Module not enabled');
144}
145
146// Security check (enable the most restrictive one)
147if ($user->socid > 0) {
149}
150//restrictedArea($user, 'stocktransfer', $id, '');
151if (!$permissiontoread) {
153}
154
155
156
157/*
158 * Actions
159 */
160
161if (GETPOST('cancel', 'alpha')) {
162 $action = 'list';
163 $massaction = '';
164}
165if (!GETPOST('confirmmassaction', 'alpha') && $massaction != 'presend' && $massaction != 'confirm_presend') {
166 $massaction = '';
167}
168
169$parameters = array();
170$reshook = $hookmanager->executeHooks('doActions', $parameters, $object, $action); // Note that $action and $object may have been modified by some hooks
171if ($reshook < 0) {
172 setEventMessages($hookmanager->error, $hookmanager->errors, 'errors');
173}
174
175if (empty($reshook)) {
176 // Selection of new fields
177 include DOL_DOCUMENT_ROOT.'/core/actions_changeselectedfields.inc.php';
178
179 // Purge search criteria
180 if (GETPOST('button_removefilter_x', 'alpha') || GETPOST('button_removefilter.x', 'alpha') || GETPOST('button_removefilter', 'alpha')) { // All tests are required to be compatible with all browsers
181 foreach ($object->fields as $key => $val) {
182 $search[$key] = '';
183 if (preg_match('/^(date|timestamp|datetime)/', $val['type'])) {
184 $search[$key.'_dtstart'] = '';
185 $search[$key.'_dtend'] = '';
186 }
187 }
188 $toselect = array();
189 $search_array_options = array();
190 }
191 if (GETPOST('button_removefilter_x', 'alpha') || GETPOST('button_removefilter.x', 'alpha') || GETPOST('button_removefilter', 'alpha')
192 || GETPOST('button_search_x', 'alpha') || GETPOST('button_search.x', 'alpha') || GETPOST('button_search', 'alpha')) {
193 $massaction = ''; // Protection to avoid mass action if we force a new search during a mass action confirmation
194 }
195
196 // Mass actions
197 $objectclass = 'StockTransfer';
198 $objectlabel = 'StockTransfer';
199 $uploaddir = $conf->stocktransfer->dir_output;
200 include DOL_DOCUMENT_ROOT.'/core/actions_massactions.inc.php';
201}
202
203
204
205/*
206 * View
207 */
208
209$form = new Form($db);
210
211$now = dol_now();
212
213$title = $langs->trans('StockTransferList');
214//$help_url="EN:Module_StockTransfer|FR:Module_StockTransfer_FR|ES:Módulo_StockTransfer";
215$help_url = '';
216$morejs = array();
217$morecss = array();
218
219$varpage = empty($contextpage) ? $_SERVER["PHP_SELF"] : $contextpage;
220$htmlofselectarray = $form->multiSelectArrayWithCheckbox('selectedfields', $arrayfields, $varpage, $conf->main_checkbox_left_column); // This also change content of $arrayfields with user setup
221
222
223// Build and execute select
224// --------------------------------------------------------------------
225$sql = 'SELECT ';
226$sql .= $object->getFieldList('t');
227// Add fields from extrafields
228if (!empty($extrafields->attributes[$object->table_element]['label'])) {
229 foreach ($extrafields->attributes[$object->table_element]['label'] as $key => $val) {
230 $sql .= ($extrafields->attributes[$object->table_element]['type'][$key] != 'separate' ? ", ef.".$key." as options_".$key : '');
231 }
232}
233// Add fields from hooks
234$parameters = array();
235$reshook = $hookmanager->executeHooks('printFieldListSelect', $parameters, $object, $action); // Note that $action and $object may have been modified by hook
236$sql .= $hookmanager->resPrint;
237$sql = preg_replace('/,\s*$/', '', $sql);
238
239$sqlfields = $sql; // $sql fields to remove for count total
240
241$sql .= " FROM ".MAIN_DB_PREFIX.$object->table_element." as t";
242if (isset($extrafields->attributes[$object->table_element]['label']) && is_array($extrafields->attributes[$object->table_element]['label']) && count($extrafields->attributes[$object->table_element]['label'])) {
243 $sql .= " LEFT JOIN ".MAIN_DB_PREFIX.$object->table_element."_extrafields as ef on (t.rowid = ef.fk_object)";
244}
245// Add table from hooks
246$parameters = array();
247$reshook = $hookmanager->executeHooks('printFieldListFrom', $parameters, $object, $action); // Note that $action and $object may have been modified by hook
248$sql .= $hookmanager->resPrint;
249if ($object->ismultientitymanaged == 1) {
250 $sql .= " WHERE t.entity IN (".getEntity($object->element, (GETPOSTINT('search_current_entity') ? 0 : 1)).")";
251} else {
252 $sql .= " WHERE 1 = 1";
253}
254foreach ($search as $key => $val) {
255 if (array_key_exists($key, $object->fields)) {
256 if ($key == 'status' && $search[$key] == -1) {
257 continue;
258 }
259 $mode_search = (($object->isInt($object->fields[$key]) || $object->isFloat($object->fields[$key])) ? 1 : 0);
260 if ((strpos($object->fields[$key]['type'], 'integer:') === 0) || (strpos($object->fields[$key]['type'], 'sellist:') === 0) || !empty($object->fields[$key]['arrayofkeyval'])) {
261 if ($search[$key] == '-1' || ($search[$key] === '0' && (empty($object->fields[$key]['arrayofkeyval']) || !array_key_exists('0', $object->fields[$key]['arrayofkeyval'])))) {
262 $search[$key] = '';
263 }
264 $mode_search = 2;
265 }
266 if ($search[$key] != '') {
267 if ($key == 'ref' && empty($arrayfields['t.label']['checked'])) {
268 // Label is shown into the ref column, so search on both
269 $sql .= natural_search(array('t.ref', 't.label'), $search[$key]);
270 } else {
271 $sql .= natural_search("t.".$db->escape($key), $search[$key], (($key == 'status') ? 2 : $mode_search));
272 }
273 }
274 } else {
275 if (preg_match('/(_dtstart|_dtend)$/', $key) && $search[$key] != '') {
276 $columnName = preg_replace('/(_dtstart|_dtend)$/', '', $key);
277 if (preg_match('/^(date|timestamp|datetime)/', $object->fields[$columnName]['type'])) {
278 if (preg_match('/_dtstart$/', $key)) {
279 $sql .= " AND t.".$db->sanitize($columnName)." >= '".$db->idate($search[$key])."'";
280 }
281 if (preg_match('/_dtend$/', $key)) {
282 $sql .= " AND t.".$db->sanitize($columnName)." <= '".$db->idate($search[$key])."'";
283 }
284 }
285 }
286 }
287}
288if ($search_all) {
289 $sql .= natural_search(array_keys($fieldstosearchall), $search_all);
290}
291//$sql.= dolSqlDateFilter("t.field", $search_xxxday, $search_xxxmonth, $search_xxxyear);
292// Add where from extra fields
293include DOL_DOCUMENT_ROOT.'/core/tpl/extrafields_list_search_sql.tpl.php';
294// Add where from hooks
295$parameters = array();
296$reshook = $hookmanager->executeHooks('printFieldListWhere', $parameters, $object, $action); // Note that $action and $object may have been modified by hook
297$sql .= $hookmanager->resPrint;
298
299/* If a group by is required
300$sql.= " GROUP BY ";
301foreach($object->fields as $key => $val) {
302 $sql .= "t.".$db->escape($key).", ";
303}
304// Add fields from extrafields
305if (!empty($extrafields->attributes[$object->table_element]['label'])) {
306 foreach ($extrafields->attributes[$object->table_element]['label'] as $key => $val) {
307 $sql .= ($extrafields->attributes[$object->table_element]['type'][$key] != 'separate' ? "ef.".$key.', ' : '');
308 }
309}
310// Add groupby from hooks
311$parameters=array();
312$reshook = $hookmanager->executeHooks('printFieldListGroupBy', $parameters, $object, $action); // Note that $action and $object may have been modified by hook
313$sql.=$hookmanager->resPrint;
314$sql=preg_replace('/,\s*$/','', $sql);
315*/
316
317// Count total nb of records
318$nbtotalofrecords = '';
319if (!getDolGlobalInt('MAIN_DISABLE_FULL_SCANLIST')) {
320 /* The fast and low memory method to get and count full list converts the sql into a sql count */
321 $sqlforcount = preg_replace('/^'.preg_quote($sqlfields, '/').'/', 'SELECT COUNT(*) as nbtotalofrecords', $sql);
322 $sqlforcount = preg_replace('/GROUP BY .*$/', '', $sqlforcount);
323 $resql = $db->query($sqlforcount);
324 if ($resql) {
325 $objforcount = $db->fetch_object($resql);
326 $nbtotalofrecords = $objforcount->nbtotalofrecords;
327 } else {
328 dol_print_error($db);
329 }
330
331 if (($page * $limit) > (int) $nbtotalofrecords) { // if total resultset is smaller than the paging size (filtering), goto and load page 0
332 $page = 0;
333 $offset = 0;
334 }
335 $db->free($resql);
336}
337
338// Complete request and execute it with limit
339$sql .= $db->order($sortfield, $sortorder);
340if ($limit) {
341 $sql .= $db->plimit($limit + 1, $offset);
342}
343
344$resql = $db->query($sql);
345if (!$resql) {
346 dol_print_error($db);
347 exit;
348}
349
350$num = $db->num_rows($resql);
351
352// Direct jump if only one record found
353if ($num == 1 && getDolGlobalInt('MAIN_SEARCH_DIRECT_OPEN_IF_ONLY_ONE') && $search_all && !$page) {
354 $obj = $db->fetch_object($resql);
355 $id = $obj->rowid;
356 header("Location: ".dol_buildpath('/product/stock/stocktransfer/stocktransfer_card.php', 1).'?id='.$id);
357 exit;
358}
359
360
361// Output page
362// --------------------------------------------------------------------
363
364llxHeader('', $title, $help_url, '', 0, 0, $morejs, $morecss, '', 'bodyforlist mod-product page-stock-stocktransfer_stocktransfer_list'); // Can use also classforhorizontalscrolloftabs instead of bodyforlist for no horizontal scroll
365
366// Example : Adding jquery code
367// print '<script type="text/javascript">
368// jQuery(document).ready(function() {
369// function init_myfunc()
370// {
371// jQuery("#myid").removeAttr(\'disabled\');
372// jQuery("#myid").attr(\'disabled\',\'disabled\');
373// }
374// init_myfunc();
375// jQuery("#mybutton").click(function() {
376// init_myfunc();
377// });
378// });
379// </script>';
380
381$arrayofselected = is_array($toselect) ? $toselect : array();
382
383$param = '';
384if (!empty($mode)) {
385 $param .= '&mode='.urlencode($mode);
386}
387if (!empty($contextpage) && $contextpage != $_SERVER["PHP_SELF"]) {
388 $param .= '&contextpage='.urlencode($contextpage);
389}
390if ($limit > 0 && $limit != $conf->liste_limit) {
391 $param .= '&limit='.((int) $limit);
392}
393if ($optioncss != '') {
394 $param .= '&optioncss='.urlencode($optioncss);
395}
396foreach ($search as $key => $val) {
397 if (is_array($search[$key])) {
398 foreach ($search[$key] as $skey) {
399 if ($skey != '') {
400 $param .= '&search_'.$key.'[]='.urlencode($skey);
401 }
402 }
403 } elseif (preg_match('/(_dtstart|_dtend)$/', $key) && !empty($val)) {
404 $param .= '&search_'.$key.'month='.(GETPOSTINT('search_'.$key.'month'));
405 $param .= '&search_'.$key.'day='.(GETPOSTINT('search_'.$key.'day'));
406 $param .= '&search_'.$key.'year='.(GETPOSTINT('search_'.$key.'year'));
407 } elseif ($search[$key] != '') {
408 $param .= '&search_'.$key.'='.urlencode($search[$key]);
409 }
410}
411// Add $param from extra fields
412include DOL_DOCUMENT_ROOT.'/core/tpl/extrafields_list_search_param.tpl.php';
413// Add $param from hooks
414$parameters = array('param' => &$param);
415$reshook = $hookmanager->executeHooks('printFieldListSearchParam', $parameters, $object, $action); // Note that $action and $object may have been modified by hook
416$param .= $hookmanager->resPrint;
417
418// List of mass actions available
419$arrayofmassactions = array(
420 //'validate'=>$langs->trans("Validate"),
421 //'generate_doc'=>$langs->trans("ReGeneratePDF"),
422 //'builddoc'=>$langs->trans("PDFMerge"),
423 //'presend'=>$langs->trans("SendByMail"),
424);
425if (!empty($permissiontodelete)) {
426 $arrayofmassactions['predelete'] = img_picto('', 'delete', 'class="pictofixedwidth"').$langs->trans("Delete");
427}
428if (GETPOSTINT('nomassaction') || in_array($massaction, array('presend', 'predelete'))) {
429 $arrayofmassactions = array();
430}
431$massactionbutton = $form->selectMassAction('', $arrayofmassactions);
432
433print '<form method="POST" id="searchFormList" spellcheck="false" action="'.$_SERVER["PHP_SELF"].'">'."\n";
434if ($optioncss != '') {
435 print '<input type="hidden" name="optioncss" value="'.$optioncss.'">';
436}
437print '<input type="hidden" name="token" value="'.newToken().'">';
438print '<input type="hidden" name="formfilteraction" id="formfilteraction" value="list">';
439print '<input type="hidden" name="action" value="list">';
440print '<input type="hidden" name="sortfield" value="'.$sortfield.'">';
441print '<input type="hidden" name="sortorder" value="'.$sortorder.'">';
442print '<input type="hidden" name="page" value="'.$page.'">';
443print '<input type="hidden" name="contextpage" value="'.$contextpage.'">';
444print '<input type="hidden" name="page_y" value="">';
445print '<input type="hidden" name="mode" value="'.$mode.'">';
446
447$newcardbutton = '';
448$newcardbutton .= dolGetButtonTitle($langs->trans('New'), '', 'fa fa-plus-circle', dol_buildpath('/product/stock/stocktransfer/stocktransfer_card.php', 1).'?action=create&backtopage='.urlencode($_SERVER['PHP_SELF']), '', $permissiontoadd);
449
450print_barre_liste($title, $page, $_SERVER["PHP_SELF"], $param, $sortfield, $sortorder, $massactionbutton, $num, $nbtotalofrecords, 'object_'.$object->picto, 0, $newcardbutton, '', $limit, 0, 0, 1);
451
452// Add code for pre mass action (confirmation or email presend form)
453$topicmail = "SendStockTransferRef";
454$modelmail = "stocktransfer";
455$objecttmp = new StockTransfer($db);
456$trackid = 'xxxx'.$object->id;
457include DOL_DOCUMENT_ROOT.'/core/tpl/massactions_pre.tpl.php';
458
459if ($search_all) {
460 $setupstring = '';
461 foreach ($fieldstosearchall as $key => $val) {
462 $fieldstosearchall[$key] = $langs->trans($val);
463 $setupstring .= $key."=".$val.";";
464 }
465 print '<!-- Search done like if STOCKTRANSFER_QUICKSEARCH_ON_FIELDS = '.$setupstring.' -->'."\n";
466 print '<div class="divsearchfieldfilter">'.$langs->trans("FilterOnInto", $search_all).implode(', ', $fieldstosearchall).'</div>';
467}
468
469$moreforfilter = '';
470/*$moreforfilter.='<div class="divsearchfield">';
471$moreforfilter.= $langs->trans('MyFilter') . ': <input type="text" name="search_myfield" value="'.dol_escape_htmltag($search_myfield).'">';
472$moreforfilter.= '</div>';*/
473
474$parameters = array();
475$reshook = $hookmanager->executeHooks('printFieldPreListTitle', $parameters, $object, $action); // Note that $action and $object may have been modified by hook
476if (empty($reshook)) {
477 $moreforfilter .= $hookmanager->resPrint;
478} else {
479 $moreforfilter = $hookmanager->resPrint;
480}
481
482if (!empty($moreforfilter)) {
483 print '<div class="liste_titre liste_titre_bydiv centpercent">';
484 print $moreforfilter;
485 print '</div>';
486}
487
488$selectedfields = ($mode != 'kanban' ? $htmlofselectarray : '');
489$selectedfields .= (count($arrayofmassactions) ? $form->showCheckAddButtons('checkforselect', 1) : '');
490
491print '<div class="div-table-responsive">'; // You can use div-table-responsive-no-min if you don't need reserved height for your table
492print '<table class="tagtable nobottomiftotal liste'.($moreforfilter ? " listwithfilterbefore" : "").'">'."\n";
493
494
495// Fields title search
496// --------------------------------------------------------------------
497print '<tr class="liste_titre_filter">';
498// Action column
499if ($conf->main_checkbox_left_column) {
500 print '<td class="liste_titre center maxwidthsearch">';
501 $searchpicto = $form->showFilterButtons('left');
502 print $searchpicto;
503 print '</td>';
504}
505foreach ($object->fields as $key => $val) {
506 $searchkey = empty($search[$key]) ? '' : $search[$key];
507 $cssforfield = (empty($val['csslist']) ? (empty($val['css']) ? '' : $val['css']) : $val['csslist']);
508 if ($key == 'status') {
509 $cssforfield .= ($cssforfield ? ' ' : '').'center';
510 } elseif (in_array($val['type'], array('date', 'datetime', 'timestamp'))) {
511 $cssforfield .= ($cssforfield ? ' ' : '').'center';
512 } elseif (in_array($val['type'], array('timestamp'))) {
513 $cssforfield .= ($cssforfield ? ' ' : '').'nowrap';
514 } elseif (in_array($val['type'], array('double(24,8)', 'double(6,3)', 'integer', 'real', 'price')) && !in_array($key, array('id', 'rowid', 'ref', 'status')) && $val['label'] != 'TechnicalID' && empty($val['arrayofkeyval'])) {
515 $cssforfield .= ($cssforfield ? ' ' : '').'right';
516 }
517 if (!empty($arrayfields['t.'.$key]['checked'])) {
518 print '<td class="liste_titre'.($cssforfield ? ' '.$cssforfield : '').($key == 'status' ? ' parentonrightofpage' : '').'">';
519 if (!empty($val['arrayofkeyval']) && is_array($val['arrayofkeyval'])) {
520 print $form->selectarray('search_'.$key, $val['arrayofkeyval'], (isset($search[$key]) ? $search[$key] : ''), 1, 0, 0, '', 1, 0, 0, '', 'maxwidth100'.($key == 'status' ? ' search_status width100 onrightofpage' : ''), 1);
521 } elseif ((strpos($val['type'], 'integer:') === 0) || (strpos($val['type'], 'sellist:') === 0)) {
522 print $object->showInputField($val, $key, (isset($search[$key]) ? $search[$key] : ''), '', '', 'search_', $cssforfield.' maxwidth250', 1);
523 } elseif (preg_match('/^(date|timestamp|datetime)/', $val['type'])) {
524 print '<div class="nowrap">';
525 print $form->selectDate($search[$key.'_dtstart'] ? $search[$key.'_dtstart'] : '', "search_".$key."_dtstart", 0, 0, 1, '', 1, 0, 0, '', '', '', '', 1, '', $langs->trans('From'));
526 print '</div>';
527 print '<div class="nowrap">';
528 print $form->selectDate($search[$key.'_dtend'] ? $search[$key.'_dtend'] : '', "search_".$key."_dtend", 0, 0, 1, '', 1, 0, 0, '', '', '', '', 1, '', $langs->trans('to'));
529 print '</div>';
530 } elseif ($key == 'lang') {
531 require_once DOL_DOCUMENT_ROOT.'/core/class/html.formadmin.class.php';
532 $formadmin = new FormAdmin($db);
533 print $formadmin->select_language($search[$key], 'search_lang', 0, array(), 1, 0, 0, 'minwidth100imp maxwidth125', 2);
534 } else {
535 print '<input type="text" class="flat maxwidth'.($val['type'] == 'integer' ? '50' : '75').'" name="search_'.$key.'" value="'.dol_escape_htmltag(isset($search[$key]) ? $search[$key] : '').'">';
536 }
537 print '</td>';
538 }
539}
540// Extra fields
541include DOL_DOCUMENT_ROOT.'/core/tpl/extrafields_list_search_input.tpl.php';
542
543// Fields from hook
544$parameters = array('arrayfields' => $arrayfields);
545$reshook = $hookmanager->executeHooks('printFieldListOption', $parameters, $object, $action); // Note that $action and $object may have been modified by hook
546print $hookmanager->resPrint;
547// Action column
548if (!$conf->main_checkbox_left_column) {
549 print '<td class="liste_titre center maxwidthsearch">';
550 $searchpicto = $form->showFilterButtons();
551 print $searchpicto;
552 print '</td>';
553}
554print '</tr>'."\n";
555
556$totalarray = array();
557$totalarray['nbfield'] = 0;
558
559// Fields title label
560// --------------------------------------------------------------------
561print '<tr class="liste_titre">';
562// Action column
563if ($conf->main_checkbox_left_column) {
564 print getTitleFieldOfList($selectedfields, 0, $_SERVER["PHP_SELF"], '', '', '', '', $sortfield, $sortorder, 'center maxwidthsearch ')."\n";
565 $totalarray['nbfield']++;
566}
567foreach ($object->fields as $key => $val) {
568 $cssforfield = (empty($val['csslist']) ? (empty($val['css']) ? '' : $val['css']) : $val['csslist']);
569 if ($key == 'status') {
570 $cssforfield .= ($cssforfield ? ' ' : '').'center';
571 } elseif (in_array($val['type'], array('date', 'datetime', 'timestamp'))) {
572 $cssforfield .= ($cssforfield ? ' ' : '').'center';
573 } elseif (in_array($val['type'], array('timestamp'))) {
574 $cssforfield .= ($cssforfield ? ' ' : '').'nowrap';
575 } elseif (in_array($val['type'], array('double(24,8)', 'double(6,3)', 'integer', 'real', 'price')) && !in_array($key, array('id', 'rowid', 'ref', 'status')) && $val['label'] != 'TechnicalID' && empty($val['arrayofkeyval'])) {
576 $cssforfield .= ($cssforfield ? ' ' : '').'right';
577 }
578 $cssforfield = preg_replace('/small\s*/', '', $cssforfield); // the 'small' css must not be used for the title label
579 if (!empty($arrayfields['t.'.$key]['checked'])) {
580 print getTitleFieldOfList($arrayfields['t.'.$key]['label'], 0, $_SERVER['PHP_SELF'], 't.'.$key, '', $param, ($cssforfield ? 'class="'.$cssforfield.'"' : ''), $sortfield, $sortorder, ($cssforfield ? $cssforfield.' ' : ''), 0, (empty($val['helplist']) ? '' : $val['helplist']))."\n";
581 $totalarray['nbfield']++;
582 }
583}
584// Extra fields
585include DOL_DOCUMENT_ROOT.'/core/tpl/extrafields_list_search_title.tpl.php';
586// Hook fields
587$parameters = array('arrayfields' => $arrayfields, 'param' => $param, 'sortfield' => $sortfield, 'sortorder' => $sortorder, 'totalarray' => &$totalarray);
588$reshook = $hookmanager->executeHooks('printFieldListTitle', $parameters, $object, $action); // Note that $action and $object may have been modified by hook
589print $hookmanager->resPrint;
590// Action column
591if (!$conf->main_checkbox_left_column) {
592 print getTitleFieldOfList($selectedfields, 0, $_SERVER["PHP_SELF"], '', '', '', '', $sortfield, $sortorder, 'center maxwidthsearch ')."\n";
593 $totalarray['nbfield']++;
594}
595print '</tr>'."\n";
596
597
598// Detect if we need a fetch on each output line
599$needToFetchEachLine = 0;
600if (isset($extrafields->attributes[$object->table_element]['computed']) && is_array($extrafields->attributes[$object->table_element]['computed']) && count($extrafields->attributes[$object->table_element]['computed']) > 0) {
601 foreach ($extrafields->attributes[$object->table_element]['computed'] as $key => $val) {
602 if (!is_null($val) && preg_match('/\$object/', $val)) {
603 $needToFetchEachLine++; // There is at least one compute field that use $object
604 }
605 }
606}
607
608
609// Loop on record
610// --------------------------------------------------------------------
611$i = 0;
612$savnbfield = $totalarray['nbfield'];
613$totalarray = array();
614$totalarray['nbfield'] = 0;
615$imaxinloop = ($limit ? min($num, $limit) : $num);
616while ($i < $imaxinloop) {
617 $obj = $db->fetch_object($resql);
618 if (empty($obj)) {
619 break; // Should not happen
620 }
621
622 // Store properties in $object
623 $object->setVarsFromFetchObj($obj);
624
625 if ($mode == 'kanban') {
626 if ($i == 0) {
627 print '<tr class="trkanban"><td colspan="'.$savnbfield.'">';
628 print '<div class="box-flex-container kanban">';
629 }
630 // Output Kanban
631 $selected = -1;
632 if ($massactionbutton || $massaction) { // If we are in select mode (massactionbutton defined) or if we have already selected and sent an action ($massaction) defined
633 $selected = 0;
634 if (in_array($object->id, $arrayofselected)) {
635 $selected = 1;
636 }
637 }
638 //print $object->getKanbanView('', array('thirdparty'=>$object->thirdparty, 'selected' => $selected));
639 print $object->getKanbanView('', array('selected' => $selected));
640 if ($i == ($imaxinloop - 1)) {
641 print '</div>';
642 print '</td></tr>';
643 }
644 } else {
645 // Show line of result
646 $j = 0;
647 print '<tr data-rowid="'.$object->id.'" class="oddeven">';
648
649 // Action column
650 if ($conf->main_checkbox_left_column) {
651 print '<td class="nowrap center">';
652 if ($massactionbutton || $massaction) { // If we are in select mode (massactionbutton defined) or if we have already selected and sent an action ($massaction) defined
653 $selected = 0;
654 if (in_array($object->id, $arrayofselected)) {
655 $selected = 1;
656 }
657 print '<input id="cb'.$object->id.'" class="flat checkforselect" type="checkbox" name="toselect[]" value="'.$object->id.'"'.($selected ? ' checked="checked"' : '').'>';
658 }
659 print '</td>';
660 if (!$i) {
661 $totalarray['nbfield']++;
662 }
663 }
664 foreach ($object->fields as $key => $val) {
665 $cssforfield = (empty($val['csslist']) ? (empty($val['css']) ? '' : $val['css']) : $val['csslist']);
666 if (in_array($val['type'], array('date', 'datetime', 'timestamp'))) {
667 $cssforfield .= ($cssforfield ? ' ' : '').'center';
668 } elseif ($key == 'status') {
669 $cssforfield .= ($cssforfield ? ' ' : '').'center';
670 }
671
672 if (in_array($val['type'], array('timestamp'))) {
673 $cssforfield .= ($cssforfield ? ' ' : '').'nowraponall';
674 } elseif ($key == 'ref') {
675 $cssforfield .= ($cssforfield ? ' ' : '').(empty($arrayfields['t.label']['checked']) ? 'tdlineheightsmall' : 'nowraponall');
676 }
677
678 if (in_array($val['type'], array('double(24,8)', 'double(6,3)', 'integer', 'real', 'price')) && !in_array($key, array('id', 'rowid', 'ref', 'status')) && empty($val['arrayofkeyval'])) {
679 $cssforfield .= ($cssforfield ? ' ' : '').'right';
680 }
681
682 if (!empty($arrayfields['t.'.$key]['checked'])) {
683 print '<td'.($cssforfield ? ' class="'.$cssforfield.(preg_match('/tdoverflow/', $cssforfield) ? ' classfortooltip' : '').'"' : '');
684 if (preg_match('/tdoverflow/', $cssforfield) && !in_array($val['type'], array('ip', 'url')) && !is_numeric($object->$key)) {
685 print ' title="'.dol_escape_htmltag((string) $object->$key).'"';
686 }
687 print '>';
688 if ($key == 'status') {
689 print $object->getLibStatut(5);
690 } elseif ($key == 'rowid') {
691 print $object->showOutputField($val, $key, (string) $object->id, '');
692 } elseif ($key == 'ref' && empty($arrayfields['t.label']['checked'])) {
693 // Show label under the ref when label column is not enabled
694 print '<div class="tdoverflowmax150 inline-block lineheightsmall">';
695 print $object->showOutputField($val, $key, $object->$key, '');
696 if (!empty($object->label)) {
697 print '<br><span class="spantitle">'.dolPrintHTML($object->label).'</span>';
698 }
699 print '</div>';
700 } elseif ($key == 'label') {
701 print '<span class="spantitle">'.$object->showOutputField($val, $key, $object->$key, '').'</span>';
702 } else {
703 print $object->showOutputField($val, $key, $object->$key, '');
704 }
705 print '</td>';
706 if (!$i) {
707 $totalarray['nbfield']++;
708 }
709 if (!empty($val['isameasure']) && $val['isameasure'] == 1) {
710 if (!$i) {
711 $totalarray['pos'][$totalarray['nbfield']] = 't.'.$key;
712 }
713 if (!isset($totalarray['val'])) {
714 $totalarray['val'] = array();
715 }
716 if (!isset($totalarray['val']['t.'.$key])) {
717 $totalarray['val']['t.'.$key] = 0;
718 }
719 $totalarray['val']['t.'.$key] += $object->$key;
720 }
721 }
722 }
723 // Extra fields
724 include DOL_DOCUMENT_ROOT.'/core/tpl/extrafields_list_print_fields.tpl.php';
725 // Fields from hook
726 $parameters = array('arrayfields' => $arrayfields, 'object' => $object, 'obj' => $obj, 'i' => $i, 'totalarray' => &$totalarray);
727 $reshook = $hookmanager->executeHooks('printFieldListValue', $parameters, $object, $action); // Note that $action and $object may have been modified by hook
728 print $hookmanager->resPrint;
729 // Action column
730 if (!$conf->main_checkbox_left_column) {
731 print '<td class="nowrap center">';
732 if ($massactionbutton || $massaction) { // If we are in select mode (massactionbutton defined) or if we have already selected and sent an action ($massaction) defined
733 $selected = 0;
734 if (in_array($object->id, $arrayofselected)) {
735 $selected = 1;
736 }
737 print '<input id="cb'.$object->id.'" class="flat checkforselect" type="checkbox" name="toselect[]" value="'.$object->id.'"'.($selected ? ' checked="checked"' : '').'>';
738 }
739 print '</td>';
740 if (!$i) {
741 $totalarray['nbfield']++;
742 }
743 }
744
745 print '</tr>'."\n";
746 }
747
748 $i++;
749}
750
751// Show total line
752include DOL_DOCUMENT_ROOT.'/core/tpl/list_print_total.tpl.php';
753
754// If no record found
755if ($num == 0) {
756 $colspan = 1;
757 foreach ($arrayfields as $key => $val) {
758 if (!empty($val['checked'])) {
759 $colspan++;
760 }
761 }
762 print '<tr><td colspan="'.$colspan.'"><span class="opacitymedium">'.$langs->trans("NoRecordFound").'</span></td></tr>';
763}
764
765
766$db->free($resql);
767
768$parameters = array('arrayfields' => $arrayfields, 'sql' => $sql);
769$reshook = $hookmanager->executeHooks('printFieldListFooter', $parameters, $object, $action); // Note that $action and $object may have been modified by hook
770print $hookmanager->resPrint;
771
772print '</table>'."\n";
773print '</div>'."\n";
774
775print '</form>'."\n";
776
777if (in_array('builddoc', array_keys($arrayofmassactions)) && ($nbtotalofrecords === '' || $nbtotalofrecords)) {
778 $hidegeneratedfilelistifempty = 1;
779 if ($massaction == 'builddoc' || $action == 'remove_file' || $show_files) {
780 $hidegeneratedfilelistifempty = 0;
781 }
782
783 require_once DOL_DOCUMENT_ROOT.'/core/class/html.formfile.class.php';
784 $formfile = new FormFile($db);
785
786 // Show list of available documents
787 $urlsource = $_SERVER['PHP_SELF'].'?sortfield='.$sortfield.'&sortorder='.$sortorder;
788 $urlsource .= str_replace('&amp;', '&', $param);
789
790 $filedir = $diroutputmassaction;
791 $genallowed = $permissiontoread;
792 $delallowed = $permissiontoadd;
793
794 print $formfile->showdocuments('massfilesarea_'.$object->module, '', $filedir, $urlsource, 0, $delallowed, '', 1, 1, 0, 48, 1, $param, $title, '', '', '', null, $hidegeneratedfilelistifempty);
795}
796
797// End of page
798llxFooter();
799$db->close();
$id
Support class for third parties, contacts, members, users or resources.
Definition account.php:47
if(! $sortfield) if(! $sortorder) $object
Definition account.php:100
llxFooter($comment='', $zone='private', $disabledoutputofmessages=0)
Empty footer.
Definition wrapper.php:91
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.
Definition wrapper.php:73
if(!isModEnabled('ai')||!getDolGlobalString('AI_ASSISTANT_ENABLED')) global $conf
The main.inc.php has been included so the following variable are now defined:
Class to manage standard extra fields.
Class to generate html code for admin pages.
Class to offer components to list and upload files.
Class to manage generation of HTML components Only common components must be here.
Class for StockTransfer.
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...
dol_eval($s, $returnvalue=1, $hideerrors=1, $onlysimplestring='1')
Replace eval function to add more security.
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...
getMultidirOutput($object, $module='', $forobject=0, $mode='output')
Return the full path of the directory where a module (or an object of a module) stores its files.
GETPOST($paramname, $check='alphanohtml', $method=0, $filter=null, $options=null, $noreplace=0, $nodefault=0)
Return value of a param into GET or POST supervariable.
GETPOSTINT($paramname, $method=0, $nodefault=0)
Return the value of a $_GET or $_POST supervariable, converted into integer.
dol_buildpath($path, $type=0, $returnemptyifnotfound=0)
Return path of url or filesystem.
GETPOSTISSET($paramname)
Return true if we are in a context of submitting the parameter $paramname from a POST of a form.
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.
getTitleFieldOfList($name, $thead=0, $file="", $field="", $begin="", $moreparam="", $moreattrib="", $sortfield="", $sortorder="", $prefix="", $disablesortlink=0, $tooltip='', $forcenowrapcolumntitle=0)
Get title line of an array.
dol_escape_htmltag($stringtoescape, $keepb=0, $keepn=0, $noescapetags='', $escapeonlyhtmltags=0, $cleanalsojavascript=0)
Definition html.lib.php:183
accessforbidden($message='', $printheader=1, $printfooter=1, $showonlymessage=0, $params=null)
Show a message to say access is forbidden and stop program.