dolibarr 21.0.0-beta
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) 2018-2024 Alexandre Spangaro <alexandre@inovea-conseil.com>
4 * Copyright (C) 2024 Frédéric France <frederic.france@free.fr>
5 * Copyright (C) 2024 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';
29require_once DOL_DOCUMENT_ROOT.'/core/class/html.formcompany.class.php';
30require_once DOL_DOCUMENT_ROOT.'/core/lib/date.lib.php';
31require_once DOL_DOCUMENT_ROOT.'/core/lib/company.lib.php';
32require_once DOL_DOCUMENT_ROOT.'/asset/class/assetmodel.class.php';
33
43// Load translation files required by the page
44$langs->loadLangs(array("assets", "other"));
45
46$action = GETPOST('action', 'aZ09') ? GETPOST('action', 'aZ09') : 'view'; // The action 'add', 'create', 'edit', 'update', 'view', ...
47$massaction = GETPOST('massaction', 'alpha'); // The bulk action (combo box choice into lists)
48$show_files = GETPOSTINT('show_files'); // Show files area generated by bulk actions ?
49$confirm = GETPOST('confirm', 'alpha'); // Result of a confirmation
50$cancel = GETPOST('cancel', 'alpha'); // We click on a Cancel button
51$toselect = GETPOST('toselect', 'array'); // Array of ids of elements selected into a list
52$contextpage = GETPOST('contextpage', 'aZ') ? GETPOST('contextpage', 'aZ') : 'assetmodellist'; // To manage different context of search
53$backtopage = GETPOST('backtopage', 'alpha'); // Go back to a dedicated page
54$optioncss = GETPOST('optioncss', 'aZ'); // Option for the css output (always '' except when 'print')
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') || (empty($toselect) && $massaction === '0')) {
64 $page = 0;
65} // If $page is not defined, or '' or -1 or if we click on clear filters or if we select empty mass action
66$offset = $limit * $page;
67$pageprev = $page - 1;
68$pagenext = $page + 1;
69
70// Initialize a technical objects
71$object = new AssetModel($db);
72$extrafields = new ExtraFields($db);
73$diroutputmassaction = $conf->asset->dir_output.'/temp/massgeneration/'.$user->id;
74$hookmanager->initHooks(array('assetmodellist')); // Note that conf->hooks_modules contains array
75
76// Fetch optionals attributes and labels
77$extrafields->fetch_name_optionals_label($object->table_element);
78//$extrafields->fetch_name_optionals_label($object->table_element_line);
79
80$search_array_options = $extrafields->getOptionalsFromPost($object->table_element, '', 'search_');
81
82// Default sort order (if not yet defined by previous GETPOST)
83if (!$sortfield) {
84 reset($object->fields); // Reset is required to avoid key() to return null.
85 $sortfield = "t.".key($object->fields); // Set here default search field. By default 1st field in definition.
86}
87if (!$sortorder) {
88 $sortorder = "ASC";
89}
90
91// Initialize array of search criteria
92$search_all = GETPOST('search_all', 'alphanohtml');
93$search = array();
94foreach ($object->fields as $key => $val) {
95 if ($key == 'fk_pays' && !GETPOSTISSET('search_'.$key)) {
96 $search[$key] = $mysoc->country_id;
97 } elseif (GETPOST('search_'.$key, 'alpha') !== '') {
98 $search[$key] = GETPOST('search_'.$key, 'alpha');
99 }
100 if (preg_match('/^(date|timestamp|datetime)/', $val['type'])) {
101 $search[$key.'_dtstart'] = dol_mktime(0, 0, 0, GETPOSTINT('search_'.$key.'_dtstartmonth'), GETPOSTINT('search_'.$key.'_dtstartday'), GETPOSTINT('search_'.$key.'_dtstartyear'));
102 $search[$key.'_dtend'] = dol_mktime(23, 59, 59, GETPOSTINT('search_'.$key.'_dtendmonth'), GETPOSTINT('search_'.$key.'_dtendday'), GETPOSTINT('search_'.$key.'_dtendyear'));
103 }
104}
105
106// List of fields to search into when doing a "search in all"
107$fieldstosearchall = array();
108foreach ($object->fields as $key => $val) {
109 if (!empty($val['searchall'])) {
110 $fieldstosearchall['t.'.$key] = $val['label'];
111 }
112}
113
114// Definition of array of fields for columns
115$arrayfields = array();
116foreach ($object->fields as $key => $val) {
117 // If $val['visible']==0, then we never show the field
118 if (!empty($val['visible'])) {
119 $visible = (int) dol_eval((string) $val['visible'], 1);
120 $arrayfields['t.'.$key] = array(
121 'label' => $val['label'],
122 'checked' => (($visible < 0) ? 0 : 1),
123 'enabled' => (abs($visible) != 3 && (bool) dol_eval($val['enabled'], 1)),
124 'position' => $val['position'],
125 'help' => isset($val['help']) ? $val['help'] : ''
126 );
127 }
128}
129// Extra fields
130include DOL_DOCUMENT_ROOT.'/core/tpl/extrafields_list_array_fields.tpl.php';
131
132$object->fields = dol_sort_array($object->fields, 'position');
133$arrayfields = dol_sort_array($arrayfields, 'position');
134
135$permissiontoread = ((!getDolGlobalString('MAIN_USE_ADVANCED_PERMS') && $user->hasRight('asset', 'read')) || (getDolGlobalString('MAIN_USE_ADVANCED_PERMS') && $user->hasRight('asset', 'model_advance', 'read')));
136$permissiontoadd = ((!getDolGlobalString('MAIN_USE_ADVANCED_PERMS') && $user->hasRight('asset', 'write')) || (getDolGlobalString('MAIN_USE_ADVANCED_PERMS') && $user->hasRight('asset', 'model_advance', 'write')));
137$permissiontodelete = ((!getDolGlobalString('MAIN_USE_ADVANCED_PERMS') && $user->hasRight('asset', 'delete')) || (getDolGlobalString('MAIN_USE_ADVANCED_PERMS') && $user->hasRight('asset', 'model_advance', 'delete')));
138
139// Security check
140if (!isModEnabled('asset')) {
141 accessforbidden('Module not enabled');
142}
143
144// Security check (enable the most restrictive one)
145if ($user->socid > 0) {
147}
148$socid = 0;
149if ($user->socid > 0) {
150 $socid = $user->socid;
151}
152$isdraft = (($object->status == $object::STATUS_DRAFT) ? 1 : 0);
153restrictedArea($user, 'asset', $object->id, $object->table_element, '', 'fk_soc', 'rowid', $isdraft);
154if (!isModEnabled('asset')) {
156}
157if (!$permissiontoread) {
159}
160
161/*
162 * Actions
163 */
164
165if (GETPOST('cancel', 'alpha')) {
166 $action = 'list';
167 $massaction = '';
168}
169if (!GETPOST('confirmmassaction', 'alpha') && $massaction != 'presend' && $massaction != 'confirm_presend') {
170 $massaction = '';
171}
172
173$parameters = array();
174$reshook = $hookmanager->executeHooks('doActions', $parameters, $object, $action); // Note that $action and $object may have been modified by some hooks
175if ($reshook < 0) {
176 setEventMessages($hookmanager->error, $hookmanager->errors, 'errors');
177}
178
179if (empty($reshook)) {
180 // Selection of new fields
181 include DOL_DOCUMENT_ROOT.'/core/actions_changeselectedfields.inc.php';
182
183 // Purge search criteria
184 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
185 foreach ($object->fields as $key => $val) {
186 $search[$key] = '';
187 if ($key == 'fk_pays') {
188 $search[$key] = $mysoc->country_id;
189 }
190 if (preg_match('/^(date|timestamp|datetime)/', $val['type'])) {
191 $search[$key.'_dtstart'] = '';
192 $search[$key.'_dtend'] = '';
193 }
194 }
195 $toselect = array();
196 $search_array_options = array();
197 }
198 if (GETPOST('button_removefilter_x', 'alpha') || GETPOST('button_removefilter.x', 'alpha') || GETPOST('button_removefilter', 'alpha')
199 || GETPOST('button_search_x', 'alpha') || GETPOST('button_search.x', 'alpha') || GETPOST('button_search', 'alpha')) {
200 $massaction = ''; // Protection to avoid mass action if we force a new search during a mass action confirmation
201 }
202
203 // Mass actions
204 $objectclass = 'AssetModel';
205 $objectlabel = 'AssetModel';
206 $uploaddir = $conf->asset->dir_output;
207 include DOL_DOCUMENT_ROOT.'/core/actions_massactions.inc.php';
208}
209
210
211
212/*
213 * View
214 */
215
216$form = new Form($db);
217
218$now = dol_now();
219
220$help_url = '';
221$title = $langs->trans('ListOf', $langs->transnoentitiesnoconv("AssetModels"));
222$morejs = array();
223$morecss = array();
224
225
226// Build and execute select
227// --------------------------------------------------------------------
228$sql = 'SELECT ';
229$sql .= $object->getFieldList('t');
230// Add fields from extrafields
231if (!empty($extrafields->attributes[$object->table_element]['label'])) {
232 foreach ($extrafields->attributes[$object->table_element]['label'] as $key => $val) {
233 $sql .= ($extrafields->attributes[$object->table_element]['type'][$key] != 'separate' ? ", ef.".$key." as options_".$key : '');
234 }
235}
236// Add fields from hooks
237$parameters = array();
238$reshook = $hookmanager->executeHooks('printFieldListSelect', $parameters, $object); // Note that $action and $object may have been modified by hook
239$sql .= $hookmanager->resPrint;
240$sql = preg_replace('/,\s*$/', '', $sql);
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); // 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).")";
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 $sql .= natural_search($key, $search[$key], (($key == 'status') ? 2 : $mode_search));
268 }
269 } else {
270 if (preg_match('/(_dtstart|_dtend)$/', $key) && $search[$key] != '') {
271 $columnName = preg_replace('/(_dtstart|_dtend)$/', '', $key);
272 if (preg_match('/^(date|timestamp|datetime)/', $object->fields[$columnName]['type'])) {
273 if (preg_match('/_dtstart$/', $key)) {
274 $sql .= " AND t.".$columnName." >= '".$db->idate($search[$key])."'";
275 }
276 if (preg_match('/_dtend$/', $key)) {
277 $sql .= " AND t." . $columnName . " <= '" . $db->idate($search[$key]) . "'";
278 }
279 }
280 }
281 }
282}
283if ($search_all) {
284 $sql .= natural_search(array_keys($fieldstosearchall), $search_all);
285}
286//$sql.= dolSqlDateFilter("t.field", $search_xxxday, $search_xxxmonth, $search_xxxyear);
287// Add where from extra fields
288include DOL_DOCUMENT_ROOT.'/core/tpl/extrafields_list_search_sql.tpl.php';
289// Add where from hooks
290$parameters = array();
291$reshook = $hookmanager->executeHooks('printFieldListWhere', $parameters, $object); // Note that $action and $object may have been modified by hook
292$sql .= $hookmanager->resPrint;
293
294/* If a group by is required
295$sql .= " GROUP BY ";
296foreach($object->fields as $key => $val) {
297 $sql .= "t.".$key.", ";
298}
299// Add fields from extrafields
300if (!empty($extrafields->attributes[$object->table_element]['label'])) {
301 foreach ($extrafields->attributes[$object->table_element]['label'] as $key => $val) {
302 $sql .= ($extrafields->attributes[$object->table_element]['type'][$key] != 'separate' ? "ef.".$key.', ' : '');
303 }
304}
305// Add where from hooks
306$parameters = array();
307$reshook = $hookmanager->executeHooks('printFieldListGroupBy', $parameters, $object); // Note that $action and $object may have been modified by hook
308$sql .= $hookmanager->resPrint;
309$sql = preg_replace('/,\s*$/', '', $sql);
310*/
311
312// Add HAVING from hooks
313/*
314$parameters = array();
315$reshook = $hookmanager->executeHooks('printFieldListHaving', $parameters, $object); // Note that $action and $object may have been modified by hook
316$sql .= !empty($hookmanager->resPrint) ? (" HAVING 1=1 " . $hookmanager->resPrint) : "";
317*/
318
319// Count total nb of records
320$nbtotalofrecords = '';
321if (!getDolGlobalInt('MAIN_DISABLE_FULL_SCANLIST')) {
322 /* This old and fast method to get and count full list returns all record so use a high amount of memory.
323 $result = $db->query($sql);
324 $nbtotalofrecords = $db->num_rows($result);
325 */
326 /* The fast and low memory method to get and count full list converts the sql into a sql count */
327 $sqlforcount = preg_replace('/^SELECT[a-z0-9\._\s\‍(\‍),]+FROM/Ui', 'SELECT COUNT(*) as nbtotalofrecords FROM', $sql);
328
329 $resql = $db->query($sqlforcount);
330 if ($resql) {
331 $objforcount = $db->fetch_object($resql);
332 $nbtotalofrecords = $objforcount->nbtotalofrecords;
333 } else {
334 dol_print_error($db);
335 }
336
337 if (($page * $limit) > $nbtotalofrecords) { // if total of record found is smaller than page * limit, goto and load page 0
338 $page = 0;
339 $offset = 0;
340 }
341 $db->free($resql);
342}
343
344// Complete request and execute it with limit
345$sql .= $db->order($sortfield, $sortorder);
346if ($limit) {
347 $sql .= $db->plimit($limit + 1, $offset);
348}
349
350$resql = $db->query($sql);
351if (!$resql) {
352 dol_print_error($db);
353 exit;
354}
355
356$num = $db->num_rows($resql);
357
358
359// Direct jump if only one record found
360if ($num == 1 && getDolGlobalString('MAIN_SEARCH_DIRECT_OPEN_IF_ONLY_ONE') && $search_all && !$page) {
361 $obj = $db->fetch_object($resql);
362 $id = $obj->rowid;
363 header("Location: ".DOL_URL_ROOT.'/asset/model/card.php?id='.$id);
364 exit;
365}
366
367
368// Output page
369// --------------------------------------------------------------------
370
371llxHeader('', $title, $help_url, '', 0, 0, $morejs, $morecss, '', 'bodyforlist mod-asset page-model-list');
372
373$arrayofselected = is_array($toselect) ? $toselect : array();
374
375$param = '';
376if (!empty($contextpage) && $contextpage != $_SERVER["PHP_SELF"]) {
377 $param .= '&contextpage='.urlencode($contextpage);
378}
379if ($limit > 0 && $limit != $conf->liste_limit) {
380 $param .= '&limit='.((int) $limit);
381}
382foreach ($search as $key => $val) {
383 if (is_array($search[$key]) && count($search[$key])) {
384 foreach ($search[$key] as $skey) {
385 if ($skey != '') {
386 $param .= '&search_'.$key.'[]='.urlencode($skey);
387 }
388 }
389 } elseif ($search[$key] != '') {
390 $param .= '&search_'.$key.'='.urlencode($search[$key]);
391 }
392}
393if ($optioncss != '') {
394 $param .= '&optioncss='.urlencode($optioncss);
395}
396// Add $param from extra fields
397include DOL_DOCUMENT_ROOT.'/core/tpl/extrafields_list_search_param.tpl.php';
398// Add $param from hooks
399$parameters = array('param' => &$param);
400$reshook = $hookmanager->executeHooks('printFieldListSearchParam', $parameters, $object); // Note that $action and $object may have been modified by hook
401$param .= $hookmanager->resPrint;
402
403// List of mass actions available
404$arrayofmassactions = array(
405 //'validate'=>img_picto('', 'check', 'class="pictofixedwidth"').$langs->trans("Validate"),
406 //'generate_doc'=>img_picto('', 'pdf', 'class="pictofixedwidth"').$langs->trans("ReGeneratePDF"),
407 //'builddoc'=>img_picto('', 'pdf', 'class="pictofixedwidth"').$langs->trans("PDFMerge"),
408 //'presend'=>img_picto('', 'email', 'class="pictofixedwidth"').$langs->trans("SendByMail"),
409);
410if ($permissiontodelete) {
411 $arrayofmassactions['predelete'] = img_picto('', 'delete', 'class="pictofixedwidth"').$langs->trans("Delete");
412}
413if (GETPOSTINT('nomassaction') || in_array($massaction, array('presend', 'predelete'))) {
414 $arrayofmassactions = array();
415}
416$massactionbutton = $form->selectMassAction('', $arrayofmassactions);
417
418print '<form method="POST" id="searchFormList" action="'.$_SERVER["PHP_SELF"].'">'."\n";
419if ($optioncss != '') {
420 print '<input type="hidden" name="optioncss" value="'.$optioncss.'">';
421}
422print '<input type="hidden" name="token" value="'.newToken().'">';
423print '<input type="hidden" name="formfilteraction" id="formfilteraction" value="list">';
424print '<input type="hidden" name="action" value="list">';
425print '<input type="hidden" name="sortfield" value="'.$sortfield.'">';
426print '<input type="hidden" name="sortorder" value="'.$sortorder.'">';
427print '<input type="hidden" name="page" value="'.$page.'">';
428print '<input type="hidden" name="contextpage" value="'.$contextpage.'">';
429
430$newcardbutton = '';
431$newcardbutton .= dolGetButtonTitle($langs->trans('New'), '', 'fa fa-plus-circle', DOL_URL_ROOT.'/asset/model/card.php?action=create&backtopage='.urlencode($_SERVER['PHP_SELF']), '', (int) $permissiontoadd);
432
433print_barre_liste($title, $page, $_SERVER["PHP_SELF"], $param, $sortfield, $sortorder, $massactionbutton, $num, $nbtotalofrecords, 'object_'.$object->picto, 0, $newcardbutton, '', $limit, 0, 0, 1);
434
435// Add code for pre mass action (confirmation or email presend form)
436$topicmail = "SendAssetModelRef";
437$modelmail = "assetmodel";
438$objecttmp = new AssetModel($db);
439$trackid = 'assetmodel'.$object->id;
440include DOL_DOCUMENT_ROOT.'/core/tpl/massactions_pre.tpl.php';
441
442if ($search_all) {
443 foreach ($fieldstosearchall as $key => $val) {
444 $fieldstosearchall[$key] = $langs->trans($val);
445 }
446 print '<div class="divsearchfieldfilter">'.$langs->trans("FilterOnInto", $search_all).implode(', ', $fieldstosearchall).'</div>';
447}
448
449$moreforfilter = '';
450/*$moreforfilter.='<div class="divsearchfield">';
451$moreforfilter.= $langs->trans('MyFilter') . ': <input type="text" name="search_myfield" value="'.dol_escape_htmltag($search_myfield).'">';
452$moreforfilter.= '</div>';*/
453
454$parameters = array();
455$reshook = $hookmanager->executeHooks('printFieldPreListTitle', $parameters, $object, $action); // Note that $action and $object may have been modified by hook
456if (empty($reshook)) {
457 $moreforfilter .= $hookmanager->resPrint;
458} else {
459 $moreforfilter = $hookmanager->resPrint;
460}
461
462if (!empty($moreforfilter)) {
463 print '<div class="liste_titre liste_titre_bydiv centpercent">';
464 print $moreforfilter;
465 print '</div>';
466}
467
468$varpage = empty($contextpage) ? $_SERVER["PHP_SELF"] : $contextpage;
469$selectedfields = $form->multiSelectArrayWithCheckbox('selectedfields', $arrayfields, $varpage); // This also change content of $arrayfields
470$selectedfields .= (count($arrayofmassactions) ? $form->showCheckAddButtons('checkforselect', 1) : '');
471
472print '<div class="div-table-responsive">'; // You can use div-table-responsive-no-min if you don't need reserved height for your table
473print '<table class="tagtable nobottomiftotal noborder liste'.($moreforfilter ? " listwithfilterbefore" : "").'">'."\n";
474
475
476// Fields title search
477// --------------------------------------------------------------------
478print '<tr class="liste_titre">';
479foreach ($object->fields as $key => $val) {
480 $cssforfield = (empty($val['csslist']) ? (empty($val['css']) ? '' : $val['css']) : $val['csslist']);
481 if ($key == 'status') {
482 $cssforfield .= ($cssforfield ? ' ' : '').'center';
483 } elseif (in_array($val['type'], array('date', 'datetime', 'timestamp'))) {
484 $cssforfield .= ($cssforfield ? ' ' : '').'center';
485 } elseif (in_array($val['type'], array('timestamp'))) {
486 $cssforfield .= ($cssforfield ? ' ' : '').'nowrap';
487 } elseif (in_array($val['type'], array('double(24,8)', 'double(6,3)', 'integer', 'real', 'price')) && $val['label'] != 'TechnicalID' && empty($val['arrayofkeyval'])) {
488 $cssforfield .= ($cssforfield ? ' ' : '').'right';
489 }
490 if (!empty($arrayfields['t.'.$key]['checked'])) {
491 print '<td class="liste_titre'.($cssforfield ? ' '.$cssforfield : '').'">';
492 if (!empty($val['arrayofkeyval']) && is_array($val['arrayofkeyval'])) {
493 print $form->selectarray('search_'.$key, $val['arrayofkeyval'], (isset($search[$key]) ? $search[$key] : ''), $val['notnull'], 0, 0, '', 1, 0, 0, '', 'maxwidth100', 1);
494 } elseif ((strpos($val['type'], 'integer:') === 0) || (strpos($val['type'], 'sellist:') === 0)) {
495 print $object->showInputField($val, $key, (isset($search[$key]) ? $search[$key] : ''), '', '', 'search_', 'maxwidth125', 1);
496 } elseif (preg_match('/^(date|timestamp|datetime)/', $val['type'])) {
497 print '<div class="nowrap">';
498 $form->selectDate($search[$key.'_dtstart'] ? $search[$key.'_dtstart'] : '', "search_".$key."_dtstart", 0, 0, 1, '', 1, 0, 0, '', '', '', '', 1, '', $langs->trans('From'));
499 print '</div>';
500 print '<div class="nowrap">';
501 print $form->selectDate($search[$key.'_dtend'] ? $search[$key.'_dtend'] : '', "search_".$key."_dtend", 0, 0, 1, '', 1, 0, 0, '', '', '', '', 1, '', $langs->trans('to'));
502 print '</div>';
503 } elseif ($key == 'lang') {
504 require_once DOL_DOCUMENT_ROOT.'/core/class/html.formadmin.class.php';
505 $formadmin = new FormAdmin($db);
506 print $formadmin->select_language($search[$key], 'search_lang', 0, array(), 1, 0, 0, 'minwidth100imp maxwidth125', 2);
507 } else {
508 print '<input type="text" class="flat maxwidth'.($val['type'] == 'integer' ? '50' : '75').'" name="search_'.$key.'" value="'.dol_escape_htmltag(isset($search[$key]) ? $search[$key] : '').'">';
509 }
510 print '</td>';
511 }
512}
513// Extra fields
514include DOL_DOCUMENT_ROOT.'/core/tpl/extrafields_list_search_input.tpl.php';
515
516// Fields from hook
517$parameters = array('arrayfields' => $arrayfields);
518$reshook = $hookmanager->executeHooks('printFieldListOption', $parameters, $object); // Note that $action and $object may have been modified by hook
519print $hookmanager->resPrint;
520// Action column
521print '<td class="liste_titre maxwidthsearch">';
522$searchpicto = $form->showFilterButtons();
523print $searchpicto;
524print '</td>';
525print '</tr>'."\n";
526
527
528// Fields title label
529// --------------------------------------------------------------------
530print '<tr class="liste_titre">';
531foreach ($object->fields as $key => $val) {
532 $cssforfield = (empty($val['csslist']) ? (empty($val['css']) ? '' : $val['css']) : $val['csslist']);
533 if ($key == 'status') {
534 $cssforfield .= ($cssforfield ? ' ' : '').'center';
535 } elseif (in_array($val['type'], array('date', 'datetime', 'timestamp'))) {
536 $cssforfield .= ($cssforfield ? ' ' : '').'center';
537 } elseif (in_array($val['type'], array('timestamp'))) {
538 $cssforfield .= ($cssforfield ? ' ' : '').'nowrap';
539 } elseif (in_array($val['type'], array('double(24,8)', 'double(6,3)', 'integer', 'real', 'price')) && $val['label'] != 'TechnicalID' && empty($val['arrayofkeyval'])) {
540 $cssforfield .= ($cssforfield ? ' ' : '').'right';
541 }
542 if (!empty($arrayfields['t.'.$key]['checked'])) {
543 print getTitleFieldOfList($arrayfields['t.'.$key]['label'], 0, $_SERVER['PHP_SELF'], 't.'.$key, '', $param, ($cssforfield ? 'class="'.$cssforfield.'"' : ''), $sortfield, $sortorder, ($cssforfield ? $cssforfield.' ' : ''))."\n";
544 }
545}
546// Extra fields
547include DOL_DOCUMENT_ROOT.'/core/tpl/extrafields_list_search_title.tpl.php';
548// Hook fields
549$parameters = array('arrayfields' => $arrayfields, 'param' => $param, 'sortfield' => $sortfield, 'sortorder' => $sortorder);
550$reshook = $hookmanager->executeHooks('printFieldListTitle', $parameters, $object); // Note that $action and $object may have been modified by hook
551print $hookmanager->resPrint;
552// Action column
553print getTitleFieldOfList($selectedfields, 0, $_SERVER["PHP_SELF"], '', '', '', '', $sortfield, $sortorder, 'center maxwidthsearch ')."\n";
554print '</tr>'."\n";
555
556
557// Detect if we need a fetch on each output line
558$needToFetchEachLine = 0;
559if (isset($extrafields->attributes[$object->table_element]['computed']) && is_array($extrafields->attributes[$object->table_element]['computed']) && count($extrafields->attributes[$object->table_element]['computed']) > 0) {
560 foreach ($extrafields->attributes[$object->table_element]['computed'] as $key => $val) {
561 if (!is_null($val) && preg_match('/\$object/', $val)) {
562 $needToFetchEachLine++; // There is at least one compute field that use $object
563 }
564 }
565}
566
567
568// Loop on record
569// --------------------------------------------------------------------
570$i = 0;
571$totalarray = array();
572$totalarray['nbfield'] = 0;
573while ($i < ($limit ? min($num, $limit) : $num)) {
574 $obj = $db->fetch_object($resql);
575 if (empty($obj)) {
576 break; // Should not happen
577 }
578
579 // Store properties in $object
580 $object->setVarsFromFetchObj($obj);
581
582 // Show here line of result
583 print '<tr class="oddeven">';
584 foreach ($object->fields as $key => $val) {
585 $cssforfield = (empty($val['csslist']) ? (empty($val['css']) ? '' : $val['css']) : $val['csslist']);
586 if (in_array($val['type'], array('date', 'datetime', 'timestamp'))) {
587 $cssforfield .= ($cssforfield ? ' ' : '').'center';
588 } elseif ($key == 'status') {
589 $cssforfield .= ($cssforfield ? ' ' : '').'center';
590 }
591
592 if (in_array($val['type'], array('timestamp'))) {
593 $cssforfield .= ($cssforfield ? ' ' : '').'nowrap';
594 } elseif ($key == 'ref') {
595 $cssforfield .= ($cssforfield ? ' ' : '').'nowrap';
596 }
597
598 if (in_array($val['type'], array('double(24,8)', 'double(6,3)', 'integer', 'real', 'price')) && !in_array($key, array('rowid', 'status')) && empty($val['arrayofkeyval'])) {
599 $cssforfield .= ($cssforfield ? ' ' : '').'right';
600 }
601 //if (in_array($key, array('fk_soc', 'fk_user', 'fk_warehouse'))) $cssforfield = 'tdoverflowmax100';
602
603 if (!empty($arrayfields['t.'.$key]['checked'])) {
604 print '<td'.($cssforfield ? ' class="'.$cssforfield.'"' : '').'>';
605 if ($key == 'status') {
606 print $object->getLibStatut(5);
607 } elseif ($key == 'rowid') {
608 print $object->showOutputField($val, $key, $object->id, '');
609 } else {
610 print $object->showOutputField($val, $key, $object->$key, '');
611 }
612 print '</td>';
613 if (!$i) {
614 $totalarray['nbfield']++;
615 }
616 if (!empty($val['isameasure']) && $val['isameasure'] == 1) {
617 if (!$i) {
618 $totalarray['pos'][$totalarray['nbfield']] = 't.'.$key;
619 }
620 if (!isset($totalarray['val'])) {
621 $totalarray['val'] = array();
622 }
623 if (!isset($totalarray['val']['t.'.$key])) {
624 $totalarray['val']['t.'.$key] = 0;
625 }
626 $totalarray['val']['t.'.$key] += $object->$key;
627 }
628 }
629 }
630 // Extra fields
631 include DOL_DOCUMENT_ROOT.'/core/tpl/extrafields_list_print_fields.tpl.php';
632 // Fields from hook
633 $parameters = array('arrayfields' => $arrayfields, 'object' => $object, 'obj' => $obj, 'i' => $i, 'totalarray' => &$totalarray);
634 $reshook = $hookmanager->executeHooks('printFieldListValue', $parameters, $object); // Note that $action and $object may have been modified by hook
635 print $hookmanager->resPrint;
636 // Action column
637 print '<td class="nowrap center">';
638 if ($massactionbutton || $massaction) { // If we are in select mode (massactionbutton defined) or if we have already selected and sent an action ($massaction) defined
639 $selected = 0;
640 if (in_array($object->id, $arrayofselected)) {
641 $selected = 1;
642 }
643 print '<input id="cb'.$object->id.'" class="flat checkforselect" type="checkbox" name="toselect[]" value="'.$object->id.'"'.($selected ? ' checked="checked"' : '').'>';
644 }
645 print '</td>';
646 if (!$i) {
647 $totalarray['nbfield']++;
648 }
649
650 print '</tr>'."\n";
651
652 $i++;
653}
654
655// Show total line
656include DOL_DOCUMENT_ROOT.'/core/tpl/list_print_total.tpl.php';
657
658// If no record found
659if ($num == 0) {
660 $colspan = 1;
661 foreach ($arrayfields as $key => $val) {
662 if (!empty($val['checked'])) {
663 $colspan++;
664 }
665 }
666 print '<tr><td colspan="'.$colspan.'" class="opacitymedium">'.$langs->trans("NoRecordFound").'</td></tr>';
667}
668
669
670$db->free($resql);
671
672$parameters = array('arrayfields' => $arrayfields, 'sql' => $sql);
673$reshook = $hookmanager->executeHooks('printFieldListFooter', $parameters, $object); // Note that $action and $object may have been modified by hook
674print $hookmanager->resPrint;
675
676print '</table>'."\n";
677print '</div>'."\n";
678
679print '</form>'."\n";
680
681if (in_array('builddoc', array_keys($arrayofmassactions)) && ($nbtotalofrecords === '' || $nbtotalofrecords)) {
682 $hidegeneratedfilelistifempty = 1;
683 if ($massaction == 'builddoc' || $action == 'remove_file' || $show_files) {
684 $hidegeneratedfilelistifempty = 0;
685 }
686
687 require_once DOL_DOCUMENT_ROOT.'/core/class/html.formfile.class.php';
688 $formfile = new FormFile($db);
689
690 // Show list of available documents
691 $urlsource = $_SERVER['PHP_SELF'].'?sortfield='.$sortfield.'&sortorder='.$sortorder;
692 $urlsource .= str_replace('&amp;', '&', $param);
693
694 $filedir = $diroutputmassaction;
695 $genallowed = $permissiontoread;
696 $delallowed = $permissiontoadd;
697
698 print $formfile->showdocuments('massfilesarea_asset', '', $filedir, $urlsource, 0, $delallowed, '', 1, 1, 0, 48, 1, $param, $title, '', '', '', null, $hidegeneratedfilelistifempty);
699}
700
701// End of page
702llxFooter();
703$db->close();
$id
Definition account.php:48
if( $user->socid > 0) if(! $user->hasRight('accounting', 'chartofaccount')) $object
Definition card.php:66
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:71
Class for AssetModel.
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.
llxFooter()
Footer empty.
Definition document.php:107
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_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)
Show picto whatever it's its name (generic function)
GETPOSTINT($paramname, $method=0)
Return the value of a $_GET or $_POST supervariable, converted into integer.
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_eval($s, $returnvalue=1, $hideerrors=1, $onlysimplestring='1')
Replace eval function to add more security.
natural_search($fields, $value, $mode=0, $nofirstand=0)
Generate natural SQL search string for a criteria (this criteria can be tested on one or several fiel...
dol_now($mode='auto')
Return date for now.
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...
getTitleFieldOfList($name, $thead=0, $file="", $field="", $begin="", $moreparam="", $moreattrib="", $sortfield="", $sortorder="", $prefix="", $disablesortlink=0, $tooltip='', $forcenowrapcolumntitle=0)
Get title line of an array.
GETPOST($paramname, $check='alphanohtml', $method=0, $filter=null, $options=null, $noreplace=0)
Return value of a param into GET or POST supervariable.
dol_print_error($db=null, $error='', $errors=null)
Displays error message system with all the information to facilitate the diagnosis and the escalation...
getDolGlobalString($key, $default='')
Return a Dolibarr global constant string value.
dol_escape_htmltag($stringtoescape, $keepb=0, $keepn=0, $noescapetags='', $escapeonlyhtmltags=0, $cleanalsojavascript=0)
Returns text escaped for inclusion in HTML alt or title or value tags, or into values of HTML input f...
global $conf
The following vars must be defined: $type2label $form $conf, $lang, The following vars may also be de...
Definition member.php:79
restrictedArea(User $user, $features, $object=0, $tableandshare='', $feature2='', $dbt_keyfield='fk_soc', $dbt_select='rowid', $isdraft=0, $mode=0)
Check permissions of a user to show a page and an object.
accessforbidden($message='', $printheader=1, $printfooter=1, $showonlymessage=0, $params=null)
Show a message to say access is forbidden and stop program.