dolibarr 23.0.4
myobject_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) 2024 Frédéric France <frederic.france@free.fr>
4 * Copyright (C) ---Replace with your own copyright and developer email---
5 *
6 * This program is free software; you can redistribute it and/or modify
7 * it under the terms of the GNU General Public License as published by
8 * the Free Software Foundation; either version 3 of the License, or
9 * (at your option) any later version.
10 *
11 * This program is distributed in the hope that it will be useful,
12 * but WITHOUT ANY WARRANTY; without even the implied warranty of
13 * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the
14 * GNU General Public License for more details.
15 *
16 * You should have received a copy of the GNU General Public License
17 * along with this program. If not, see <https://www.gnu.org/licenses/>.
18 */
19
26// General defined Options
27//if (! defined('CSRFCHECK_WITH_TOKEN')) define('CSRFCHECK_WITH_TOKEN', '1'); // Force use of CSRF protection with tokens even for GET
28//if (! defined('MAIN_AUTHENTICATION_MODE')) define('MAIN_AUTHENTICATION_MODE', 'aloginmodule'); // Force authentication handler
29//if (! defined('MAIN_LANG_DEFAULT')) define('MAIN_LANG_DEFAULT', 'auto'); // Force LANG (language) to a particular value
30//if (! defined('MAIN_SECURITY_FORCECSP')) define('MAIN_SECURITY_FORCECSP', 'none'); // Disable all Content Security Policies
31//if (! defined('NOBROWSERNOTIF')) define('NOBROWSERNOTIF', '1'); // Disable browser notification
32//if (! defined('NOIPCHECK')) define('NOIPCHECK', '1'); // Do not check IP defined into conf $dolibarr_main_restrict_ip
33//if (! defined('NOLOGIN')) define('NOLOGIN', '1'); // Do not use login - if this page is public (can be called outside logged session). This includes the NOIPCHECK too.
34//if (! defined('NOREQUIREAJAX')) define('NOREQUIREAJAX', '1'); // Do not load ajax.lib.php library
35//if (! defined('NOREQUIREDB')) define('NOREQUIREDB', '1'); // Do not create database handler $db
36//if (! defined('NOREQUIREHTML')) define('NOREQUIREHTML', '1'); // Do not load html.form.class.php
37//if (! defined('NOREQUIREMENU')) define('NOREQUIREMENU', '1'); // Do not load and show top and left menu
38//if (! defined('NOREQUIRESOC')) define('NOREQUIRESOC', '1'); // Do not load object $mysoc
39//if (! defined('NOREQUIRETRAN')) define('NOREQUIRETRAN', '1'); // Do not load object $langs
40//if (! defined('NOREQUIREUSER')) define('NOREQUIREUSER', '1'); // Do not load object $user
41//if (! defined('NOSCANGETFORINJECTION')) define('NOSCANGETFORINJECTION', '1'); // Do not check injection attack on GET parameters
42//if (! defined('NOSCANPOSTFORINJECTION')) define('NOSCANPOSTFORINJECTION', '1'); // Do not check injection attack on POST parameters
43//if (! defined('NOSESSION')) define('NOSESSION', '1'); // On CLI mode, no need to use web sessions
44//if (! defined('NOSTYLECHECK')) define('NOSTYLECHECK', '1'); // Do not check style html tag into posted data
45//if (! defined('NOTOKENRENEWAL')) define('NOTOKENRENEWAL', '1'); // Do not roll the Anti CSRF token (used if MAIN_SECURITY_CSRF_WITH_TOKEN is on)
46
47
48// Load Dolibarr environment
49$res = 0;
50// Try main.inc.php into web root known defined into CONTEXT_DOCUMENT_ROOT (not always defined)
51if (!$res && !empty($_SERVER["CONTEXT_DOCUMENT_ROOT"])) {
52 $res = @include str_replace("..", "", $_SERVER["CONTEXT_DOCUMENT_ROOT"])."/main.inc.php";
53}
54// Try main.inc.php into web root detected using web root calculated from SCRIPT_FILENAME
55$tmp = empty($_SERVER['SCRIPT_FILENAME']) ? '' : $_SERVER['SCRIPT_FILENAME'];
56$tmp2 = realpath(__FILE__);
57$i = strlen($tmp) - 1;
58$j = strlen($tmp2) - 1;
59while ($i > 0 && $j > 0 && isset($tmp[$i]) && isset($tmp2[$j]) && $tmp[$i] == $tmp2[$j]) {
60 $i--;
61 $j--;
62}
63if (!$res && $i > 0 && file_exists(substr($tmp, 0, ($i + 1))."/main.inc.php")) {
64 $res = @include substr($tmp, 0, ($i + 1))."/main.inc.php";
65}
66if (!$res && $i > 0 && file_exists(dirname(substr($tmp, 0, ($i + 1)))."/main.inc.php")) {
67 $res = @include dirname(substr($tmp, 0, ($i + 1)))."/main.inc.php";
68}
69// Try main.inc.php using relative path
70if (!$res && file_exists("../main.inc.php")) {
71 $res = @include "../main.inc.php";
72}
73if (!$res && file_exists("../../main.inc.php")) {
74 $res = @include "../../main.inc.php";
75}
76if (!$res && file_exists("../../../main.inc.php")) {
77 $res = @include "../../../main.inc.php";
78}
79if (!$res) {
80 die("Include of main fails");
81}
90include_once DOL_DOCUMENT_ROOT.'/core/class/html.formcompany.class.php';
91include_once DOL_DOCUMENT_ROOT.'/core/lib/date.lib.php';
92include_once DOL_DOCUMENT_ROOT.'/core/lib/company.lib.php';
93// load module libraries
94include_once __DIR__.'/class/myobject.class.php';
95// for other modules
96//dol_include_once('/othermodule/class/otherobject.class.php');
97
98// Load translation files required by the page
99$langs->loadLangs(array("mymodule@mymodule", "other"));
100
101// Get parameters
102$action = GETPOST('action', 'aZ09') ? GETPOST('action', 'aZ09') : 'view'; // The action 'create'/'add', 'edit'/'update', 'view', ...
103$massaction = GETPOST('massaction', 'alpha'); // The bulk action (combo box choice into lists)
104$show_files = GETPOSTINT('show_files'); // Show files area generated by bulk actions ?
105$confirm = GETPOST('confirm', 'alpha'); // Result of a confirmation
106$cancel = GETPOST('cancel', 'alpha'); // We click on a Cancel button
107$toselect = GETPOST('toselect', 'array:int'); // Array of ids of elements selected into a list
108$contextpage = GETPOST('contextpage', 'aZ') ? GETPOST('contextpage', 'aZ') : getDolDefaultContextPage(__FILE__); // To manage different context of search
109$backtopage = GETPOST('backtopage', 'alpha'); // Go back to a dedicated page
110$optioncss = GETPOST('optioncss', 'aZ'); // Option for the css output (always '' except when 'print')
111$mode = GETPOST('mode', 'aZ'); // The display mode ('list', 'kanban', 'hierarchy', 'calendar', 'gantt', ...)
112$groupby = GETPOST('groupby', 'aZ09'); // Example: $groupby = 'p.fk_opp_status' or $groupby = 'p.fk_statut'
113
114$id = GETPOSTINT('id');
115$ref = GETPOST('ref', 'alpha');
116
117// Load variable for pagination
118$limit = GETPOSTINT('limit') ? GETPOSTINT('limit') : $conf->liste_limit;
119$sortfield = GETPOST('sortfield', 'aZ09comma');
120$sortorder = GETPOST('sortorder', 'aZ09comma');
121$page = GETPOSTISSET('pageplusone') ? (GETPOSTINT('pageplusone') - 1) : GETPOSTINT('page');
122if (empty($page) || $page < 0 || GETPOST('button_search', 'alpha') || GETPOST('button_removefilter', 'alpha')) {
123 // If $page is not defined, or '' or -1 or if we click on clear filters
124 $page = 0;
125}
126$offset = $limit * $page;
127$pageprev = $page - 1;
128$pagenext = $page + 1;
129
130// Initialize technical objects
131$object = new MyObject($db);
132$extrafields = new ExtraFields($db);
133$diroutputmassaction = $conf->mymodule->dir_output.'/temp/massgeneration/'.$user->id;
134$hookmanager->initHooks(array($contextpage)); // Note that conf->hooks_modules contains array of activated contexes
135
136// Fetch optionals attributes and labels
137$extrafields->fetch_name_optionals_label($object->table_element);
138//$extrafields->fetch_name_optionals_label($object->table_element_line);
139
140$search_array_options = $extrafields->getOptionalsFromPost($object->table_element, '', 'search_');
141
142// Default sort order (if not yet defined by previous GETPOST)
143if (!$sortfield) {
144 reset($object->fields); // Reset is required to avoid key() to return null.
145 $sortfield = "t.".key($object->fields); // Set here default search field. By default 1st field in definition.
146}
147if (!$sortorder) {
148 $sortorder = "ASC";
149}
150
151// Initialize array of search criteria
152$search_all = trim(GETPOST('search_all', 'alphanohtml'));
153$search = array();
154foreach ($object->fields as $key => $val) {
155 if (GETPOST('search_'.$key, 'alpha') !== '') {
156 $search[$key] = GETPOST('search_'.$key, 'alpha');
157 }
158 if (preg_match('/^(date|timestamp|datetime)/', $val['type'])) {
159 $search[$key.'_dtstart'] = dol_mktime(0, 0, 0, GETPOSTINT('search_'.$key.'_dtstartmonth'), GETPOSTINT('search_'.$key.'_dtstartday'), GETPOSTINT('search_'.$key.'_dtstartyear'));
160 $search[$key.'_dtend'] = dol_mktime(23, 59, 59, GETPOSTINT('search_'.$key.'_dtendmonth'), GETPOSTINT('search_'.$key.'_dtendday'), GETPOSTINT('search_'.$key.'_dtendyear'));
161 }
162}
163
164// List of fields to search into when doing a "search in all"
165$fieldstosearchall = array();
166// foreach ($object->fields as $key => $val) {
167// if (!empty($val['searchall'])) {
168// $fieldstosearchall['t.'.$key] = $val['label'];
169// }
170// }
171// $parameters = array('fieldstosearchall'=>$fieldstosearchall);
172// $reshook = $hookmanager->executeHooks('completeFieldsToSearchAll', $parameters, $object, $action); // Note that $action and $object may have been modified by some hooks
173// if ($reshook > 0) {
174// $fieldstosearchall = empty($hookmanager->resArray['fieldstosearchall']) ? array() : $hookmanager->resArray['fieldstosearchall'];
175// } elseif ($reshook == 0) {
176// $fieldstosearchall = array_merge($fieldstosearchall, empty($hookmanager->resArray['fieldstosearchall']) ? array() : $hookmanager->resArray['fieldstosearchall']);
177// }
178
179// Definition of array of fields for columns from ->fields
180$tableprefix = 't';
181$arrayfields = array();
182foreach ($object->fields as $key => $val) {
183 // If $val['visible']==0, then we never show the field
184 if (!empty($val['visible'])) {
185 $visible = (int) dol_eval((string) $val['visible'], 1);
186 $arrayfields[$tableprefix.'.'.$key] = array(
187 'label' => $val['label'],
188 'checked' => (($visible < 0) ? '0' : '1'),
189 'enabled' => (string) (int) (abs($visible) != 3 && (bool) dol_eval((string) $val['enabled'], 1)),
190 'position' => $val['position'],
191 'help' => isset($val['help']) ? $val['help'] : ''
192 );
193 }
194}
195
196// Extra fields
197include DOL_DOCUMENT_ROOT.'/core/tpl/extrafields_list_array_fields.tpl.php';
198// Add hook to complete $arrayfield
199$parameters = array('arrayfields' => &$arrayfields);
200$reshook = $hookmanager->executeHooks('completeArrayFields', $parameters, $object, $action); // Note that $action and $object may have been modified by hook
201
202// Complete arrayfields with special fields
203/*$arrayfields = array_merge($arrayfields, array(
204 'anotherfield' => array('type'=>'integer', 'label'=>'AnotherField', 'checked'=>'1', 'enabled'=>'1', 'position'=>'90', 'csslist'=>'right'),
205));*/
206
207$object->fields = dol_sort_array($object->fields, 'position');
208$arrayfields = dol_sort_array($arrayfields, 'position');
209
210// There is several ways to check permission.
211// Set $enablepermissioncheck to 1 to enable a minimum low level of checks
212$enablepermissioncheck = getDolGlobalInt('MYMODULE_ENABLE_PERMISSION_CHECK');
213if ($enablepermissioncheck) {
214 $permissiontoread = $user->hasRight('mymodule', 'myobject', 'read');
215 $permissiontoadd = $user->hasRight('mymodule', 'myobject', 'write');
216 $permissiontodelete = $user->hasRight('mymodule', 'myobject', 'delete');
217} else {
218 $permissiontoread = 1;
219 $permissiontoadd = 1;
220 $permissiontodelete = 1;
221}
222
223// Security check (enable the most restrictive one)
224if ($user->socid > 0) {
226}
227//if ($user->socid > 0) accessforbidden();
228//$socid = 0; if ($user->socid > 0) $socid = $user->socid;
229//$isdraft = (($object->status == $object::STATUS_DRAFT) ? 1 : 0);
230//restrictedArea($user, $object->module, 0, $object->table_element, $object->element, 'fk_soc', 'rowid', $isdraft);
231if (!isModEnabled("mymodule")) {
232 accessforbidden('Module mymodule not enabled');
233}
234if (!$permissiontoread) {
236}
237
238
239/*
240 * Actions
241 */
242
243if (GETPOST('cancel', 'alpha')) {
244 $action = 'list';
245 $massaction = '';
246}
247if (!GETPOST('confirmmassaction', 'alpha') && $massaction != 'presend' && $massaction != 'confirm_presend') {
248 $massaction = '';
249}
250
251$parameters = array('arrayfields' => &$arrayfields);
252$reshook = $hookmanager->executeHooks('doActions', $parameters, $object, $action); // Note that $action and $object may have been modified by some hooks
253if ($reshook < 0) {
254 setEventMessages($hookmanager->error, $hookmanager->errors, 'errors');
255}
256
257if (empty($reshook)) {
258 // Selection of new fields
259 include DOL_DOCUMENT_ROOT.'/core/actions_changeselectedfields.inc.php';
260
261 // Purge search criteria
262 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
263 foreach ($object->fields as $key => $val) {
264 $search[$key] = '';
265 if (preg_match('/^(date|timestamp|datetime)/', $val['type'])) {
266 $search[$key.'_dtstart'] = '';
267 $search[$key.'_dtend'] = '';
268 }
269 }
270 $search_all = '';
271 $toselect = array();
272 $search_array_options = array();
273 }
274 if (GETPOST('button_removefilter_x', 'alpha') || GETPOST('button_removefilter.x', 'alpha') || GETPOST('button_removefilter', 'alpha')
275 || GETPOST('button_search_x', 'alpha') || GETPOST('button_search.x', 'alpha') || GETPOST('button_search', 'alpha')) {
276 $massaction = ''; // Protection to avoid mass action if we force a new search during a mass action confirmation
277 }
278
279 // Mass actions
280 $objectclass = 'MyObject';
281 $objectlabel = 'MyObject';
282 $uploaddir = $conf->mymodule->dir_output;
283
284 global $error;
285 include DOL_DOCUMENT_ROOT.'/core/actions_massactions.inc.php';
286
287 // You can add more action here
288 // if ($action == 'xxx' && $permissiontoxxx) ...
289}
290
291
292
293/*
294 * View
295 */
296
297$form = new Form($db);
298
299$now = dol_now();
300
301$title = $langs->trans("MyObjects");
302//$help_url = "EN:Module_MyObject|FR:Module_MyObject_FR|ES:Módulo_MyObject";
303$help_url = '';
304$morejs = array();
305$morecss = array();
306
307
308// Build and execute select
309// --------------------------------------------------------------------
310$sql = "SELECT";
311$sql .= " ".$object->getFieldList('t');
312// Add fields from extrafields
313if (!empty($extrafields->attributes[$object->table_element]['label'])) {
314 foreach ($extrafields->attributes[$object->table_element]['label'] as $key => $val) {
315 $sql .= ($extrafields->attributes[$object->table_element]['type'][$key] != 'separate' ? ", ef.".$key." as options_".$key : "");
316 }
317}
318// Add fields from hooks
319$parameters = array();
320$reshook = $hookmanager->executeHooks('printFieldListSelect', $parameters, $object, $action); // Note that $action and $object may have been modified by hook
321$sql .= $hookmanager->resPrint;
322$sql = preg_replace('/,\s*$/', '', $sql);
323
324$sqlfields = $sql; // $sql fields to remove for count total
325
326$sql .= " FROM ".$db->prefix().$object->table_element." as t";
327//$sql .= " LEFT JOIN ".$db->prefix()."anothertable as rc ON rc.parent = t.rowid";
328if (isset($extrafields->attributes[$object->table_element]['label']) && is_array($extrafields->attributes[$object->table_element]['label']) && count($extrafields->attributes[$object->table_element]['label'])) {
329 $sql .= " LEFT JOIN ".$db->prefix().$object->table_element."_extrafields as ef on (t.rowid = ef.fk_object)";
330}
331// Add table from hooks
332$parameters = array();
333$reshook = $hookmanager->executeHooks('printFieldListFrom', $parameters, $object, $action); // Note that $action and $object may have been modified by hook
334$sql .= $hookmanager->resPrint;
335
336if (!empty($object->ismultientitymanaged) && (int) $object->ismultientitymanaged == 1) {
337 $sql .= " WHERE t.entity IN (".getEntity($object->element, (GETPOSTINT('search_current_entity') ? 0 : 1)).")";
338} elseif (preg_match('/^\w+@\w+$/', (string) $object->ismultientitymanaged)) {
339 $tmparray = explode('@', (string) $object->ismultientitymanaged);
340 $sql .= " LEFT JOIN ".$object->db->prefix().$tmparray[1]." as pt ON t.".$db->sanitize($tmparray[0])." = pt.rowid";
341 $sql .= " WHERE pt.entity IN (".getEntity($object->element, (GETPOSTINT('search_current_entity') ? 0 : 1)).")";
342} else {
343 $sql .= " WHERE 1 = 1";
344}
345foreach ($search as $key => $val) {
346 if (array_key_exists($key, $object->fields)) {
347 if ($key == 'status' && $search[$key] == -1) {
348 continue;
349 }
350 $field_spec = $object->fields[$key];
351 if ($field_spec === null) {
352 continue;
353 }
354 $mode_search = (($object->isInt($field_spec) || $object->isFloat($field_spec)) ? 1 : 0);
355 if ((strpos($field_spec['type'], 'integer:') === 0) || (strpos($field_spec['type'], 'sellist:') === 0) || !empty($field_spec['arrayofkeyval'])) {
356 if ($search[$key] == '-1' || ($search[$key] === '0' && (empty($field_spec['arrayofkeyval']) || !array_key_exists('0', $field_spec['arrayofkeyval'])))) {
357 $search[$key] = '';
358 }
359 $mode_search = 2;
360 }
361 if ($field_spec['type'] === 'boolean') {
362 $mode_search = 1;
363 if ($search[$key] == '-1') {
364 $search[$key] = '';
365 }
366 }
367 if (empty($field_spec['searchmulti'])) {
368 if (!is_array($search[$key]) && $search[$key] != '') {
369 $sql .= natural_search("t.".$db->escape($key), $search[$key], (($key == 'status') ? 2 : $mode_search));
370 }
371 } else {
372 if (is_array($search[$key]) && !empty($search[$key])) {
373 $sql .= natural_search("t.".$db->escape($key), implode(',', $search[$key]), (($key == 'status') ? 2 : $mode_search));
374 }
375 }
376 } else {
377 if (preg_match('/(_dtstart|_dtend)$/', $key) && $search[$key] != '') {
378 $columnName = preg_replace('/(_dtstart|_dtend)$/', '', $key);
379 if (preg_match('/^(date|timestamp|datetime)/', $object->fields[$columnName]['type'])) {
380 if (preg_match('/_dtstart$/', $key)) {
381 $sql .= " AND t.".$db->sanitize($columnName)." >= '".$db->idate($search[$key])."'";
382 }
383 if (preg_match('/_dtend$/', $key)) {
384 $sql .= " AND t.".$db->sanitize($columnName)." <= '".$db->idate($search[$key])."'";
385 }
386 }
387 }
388 }
389}
390if ($search_all) {
391 $sql .= natural_search(array_keys($fieldstosearchall), $search_all);
392}
393/*
394// If the internal user must only see his customers, force searching by him
395$search_sale = 0;
396if (!$user->hasRight('societe', 'client', 'voir')) {
397 $search_sale = $user->id;
398}
399// Search on sale representative
400if ($search_sale && $search_sale != '-1') {
401 if ($search_sale == -2) {
402 $sql .= " AND NOT EXISTS (SELECT sc.fk_soc FROM ".$db->prefix()."societe_commerciaux as sc WHERE sc.fk_soc = t.fk_soc)";
403 } elseif ($search_sale > 0) {
404 $sql .= " AND EXISTS (SELECT sc.fk_soc FROM ".$db->prefix()."societe_commerciaux as sc WHERE sc.fk_soc = t.fk_soc AND sc.fk_user = ".((int) $search_sale).")";
405 }
406}
407// Search on socid
408if ($socid) {
409 $sql .= " AND t.fk_soc = ".((int) $socid);
410}
411*/
412//$sql.= dolSqlDateFilter("t.field", $search_xxxday, $search_xxxmonth, $search_xxxyear);
413// Add where from extra fields
414include DOL_DOCUMENT_ROOT.'/core/tpl/extrafields_list_search_sql.tpl.php';
415// Add where from hooks
416$parameters = array();
417$reshook = $hookmanager->executeHooks('printFieldListWhere', $parameters, $object, $action); // Note that $action and $object may have been modified by hook
418$sql .= $hookmanager->resPrint;
419
420/* If a group by is required
421$sql .= " GROUP BY ";
422foreach($object->fields as $key => $val) {
423 $sql .= "t.".$db->sanitize($key).", ";
424}
425// Add fields from extrafields
426if (!empty($extrafields->attributes[$object->table_element]['label'])) {
427 foreach ($extrafields->attributes[$object->table_element]['label'] as $key => $val) {
428 $sql .= ($extrafields->attributes[$object->table_element]['type'][$key] != 'separate' ? "ef.".$key.', ' : '');
429 }
430}
431// Add groupby from hooks
432$parameters = array();
433$reshook = $hookmanager->executeHooks('printFieldListGroupBy', $parameters, $object, $action); // Note that $action and $object may have been modified by hook
434if (empty($reshook)) {
435 $sql .= $hookmanager->resPrint;
436} else {
437 $sql = $hookmanager->resPrint;
438}
439
440$sql = preg_replace('/,\s*$/', '', $sql);
441*/
442
443// Add HAVING from hooks
444/*
445$parameters = array();
446$reshook = $hookmanager->executeHooks('printFieldListHaving', $parameters, $object, $action); // Note that $action and $object may have been modified by hook
447if (empty($reshook)) {
448 $sql .= empty($hookmanager->resPrint) ? "" : " HAVING 1=1 ".$hookmanager->resPrint;
449} else {
450 $sql = $hookmanager->resPrint;
451}
452*/
453
454// Count total nb of records
455$nbtotalofrecords = '';
456if (!getDolGlobalInt('MAIN_DISABLE_FULL_SCANLIST')) {
457 /* The fast and low memory method to get and count full list converts the sql into a sql count */
458 $sqlforcount = preg_replace('/^'.preg_quote($sqlfields, '/').'/', 'SELECT COUNT(*) as nbtotalofrecords', $sql);
459 $sqlforcount = preg_replace('/GROUP BY .*$/', '', $sqlforcount);
460
461 $resql = $db->query($sqlforcount);
462 if ($resql) {
463 $objforcount = $db->fetch_object($resql);
464 $nbtotalofrecords = $objforcount->nbtotalofrecords;
465 } else {
466 dol_print_error($db);
467 }
468
469 if (($page * $limit) > (int) $nbtotalofrecords) { // if total resultset is smaller than the paging size (filtering), goto and load page 0
470 $page = 0;
471 $offset = 0;
472 }
473 $db->free($resql);
474}
475
476// Complete request and execute it with limit
477$sql .= $db->order($sortfield, $sortorder);
478if ($limit) {
479 $sql .= $db->plimit($limit + 1, $offset);
480}
481
482$resql = $db->query($sql);
483if (!$resql) {
484 dol_print_error($db);
485 exit;
486}
487
488$num = $db->num_rows($resql);
489
490
491// Direct jump if only one record found
492if ($num == 1 && getDolGlobalInt('MAIN_SEARCH_DIRECT_OPEN_IF_ONLY_ONE') && $search_all && !$page) {
493 $obj = $db->fetch_object($resql);
494 $id = $obj->rowid;
495 header("Location: ".dol_buildpath('/mymodule/myobject_card.php', 1).'?id='.((int) $id));
496 exit;
497}
498
499
500// Output page
501// --------------------------------------------------------------------
502
503llxHeader('', $title, $help_url, '', 0, 0, $morejs, $morecss, '', 'mod-mymodule page-list bodyforlist'); // Can use also classforhorizontalscrolloftabs instead of bodyforlist for a horizontal scroll in the table instead of page
504
505// Example : Adding jquery code
506// print '<script type="text/javascript">
507// jQuery(document).ready(function() {
508// function init_myfunc()
509// {
510// jQuery("#myid").removeAttr(\'disabled\');
511// jQuery("#myid").attr(\'disabled\',\'disabled\');
512// }
513// init_myfunc();
514// jQuery("#mybutton").click(function() {
515// init_myfunc();
516// });
517// });
518// </script>';
519
520$arrayofselected = is_array($toselect) ? $toselect : array();
521
522$param = '';
523if (!empty($mode)) {
524 $param .= '&mode='.urlencode($mode);
525}
526if (!empty($contextpage) && $contextpage != getDolDefaultContextPage(__FILE__)) {
527 $param .= '&contextpage='.urlencode($contextpage);
528}
529if ($limit > 0 && $limit != $conf->liste_limit) {
530 $param .= '&limit='.((int) $limit);
531}
532if ($optioncss != '') {
533 $param .= '&optioncss='.urlencode($optioncss);
534}
535if ($groupby != '') {
536 $param .= '&groupby='.urlencode($groupby);
537}
538foreach ($search as $key => $val) {
539 if (is_array($search[$key])) {
540 foreach ($search[$key] as $skey) {
541 if ($skey != '') {
542 $param .= '&search_'.$key.'[]='.urlencode($skey);
543 }
544 }
545 } elseif (preg_match('/(_dtstart|_dtend)$/', $key) && !empty($val)) {
546 $param .= '&search_'.$key.'month='.GETPOSTINT('search_'.$key.'month');
547 $param .= '&search_'.$key.'day='.GETPOSTINT('search_'.$key.'day');
548 $param .= '&search_'.$key.'year='.GETPOSTINT('search_'.$key.'year');
549 } elseif ($search[$key] != '') {
550 $param .= '&search_'.$key.'='.urlencode($search[$key]);
551 }
552}
553// Add $param from extra fields
554include DOL_DOCUMENT_ROOT.'/core/tpl/extrafields_list_search_param.tpl.php';
555// Add $param from hooks
556$parameters = array('param' => &$param);
557$reshook = $hookmanager->executeHooks('printFieldListSearchParam', $parameters, $object, $action); // Note that $action and $object may have been modified by hook
558$param .= $hookmanager->resPrint;
559
560// List of mass actions available
561$arrayofmassactions = array(
562 //'validate'=>img_picto('', 'check', 'class="pictofixedwidth"').$langs->trans("Validate"),
563 //'generate_doc'=>img_picto('', 'pdf', 'class="pictofixedwidth"').$langs->trans("ReGeneratePDF"),
564 //'builddoc'=>img_picto('', 'pdf', 'class="pictofixedwidth"').$langs->trans("PDFMerge"),
565 //'presend'=>img_picto('', 'email', 'class="pictofixedwidth"').$langs->trans("SendByMail"),
566);
567if (!empty($permissiontodelete)) {
568 $arrayofmassactions['predelete'] = img_picto('', 'delete', 'class="pictofixedwidth"').$langs->trans("Delete");
569}
570if (GETPOSTINT('nomassaction') || in_array($massaction, array('presend', 'predelete'))) {
571 $arrayofmassactions = array();
572}
573$massactionbutton = $form->selectMassAction('', $arrayofmassactions);
574
575print '<form method="POST" id="searchFormList" action="'.$_SERVER["PHP_SELF"].'">'."\n";
576if ($optioncss != '') {
577 print '<input type="hidden" name="optioncss" value="'.$optioncss.'">';
578}
579print '<input type="hidden" name="token" value="'.newToken().'">';
580print '<input type="hidden" name="formfilteraction" id="formfilteraction" value="list">';
581print '<input type="hidden" name="action" value="list">';
582print '<input type="hidden" name="sortfield" value="'.$sortfield.'">';
583print '<input type="hidden" name="sortorder" value="'.$sortorder.'">';
584print '<input type="hidden" name="page" value="'.$page.'">';
585print '<input type="hidden" name="contextpage" value="'.$contextpage.'">';
586print '<input type="hidden" name="page_y" value="">';
587print '<input type="hidden" name="mode" value="'.$mode.'">';
588
589
590$newcardbutton = '';
591$newcardbutton .= dolGetButtonTitle($langs->trans('ViewList'), '', 'fa fa-bars imgforviewmode', $_SERVER["PHP_SELF"].'?mode=common'.preg_replace('/(&|\?)*(mode|groupby)=[^&]+/', '', $param), '', ((empty($mode) || $mode == 'common') ? 2 : 1), array('morecss' => 'reposition'));
592$newcardbutton .= dolGetButtonTitle($langs->trans('ViewKanban'), '', 'fa fa-th-list imgforviewmode', $_SERVER["PHP_SELF"].'?mode=kanban'.preg_replace('/(&|\?)*(mode|groupby)=[^&]+/', '', $param), '', ($mode == 'kanban' ? 2 : 1), array('morecss' => 'reposition'));
593//$newcardbutton .= dolGetButtonTitle($langs->trans('ViewKanbanGroupBy'), '', 'fa fa-grip-vertical imgforviewmode', $_SERVER["PHP_SELF"].'?mode=kanbangroupby&groupby=p.fk_opp_status'.preg_replace('/(&|\?)*(mode|groupby)=[^&]+/', '', $param), '', ($mode == 'kanbangroupby' ? 2 : 1), array('morecss' => 'reposition'));
594//$newcardbutton .= dolGetButtonTitle($langs->trans('HierarchicView'), '', 'fa fa-stream paddingleft imgforviewmode', $_SERVER["PHP_SELF"].'?mode=hierarchy'.preg_replace('/(&|\?)*(mode|groupby)=[^&]+/', '', $param), '', (($mode == 'hierarchy') ? 2 : 1), array('morecss' => 'reposition'));
595$newcardbutton .= dolGetButtonTitleSeparator();
596$newcardbutton .= dolGetButtonTitle($langs->trans('New'), '', 'fa fa-plus-circle', dol_buildpath('/mymodule/myobject_card.php', 1).'?action=create&backtopage='.urlencode($_SERVER['PHP_SELF']), '', $permissiontoadd);
597
598print_barre_liste($title, $page, $_SERVER["PHP_SELF"], $param, $sortfield, $sortorder, $massactionbutton, $num, $nbtotalofrecords, $object->picto, 0, $newcardbutton, '', $limit, 0, 0, 1);
599
600// Add code for pre mass action (confirmation or email presend form)
601$topicmail = "SendMyObjectRef";
602$modelmail = "myobject";
603$objecttmp = new MyObject($db);
604$trackid = 'xxxx'.$object->id;
605include DOL_DOCUMENT_ROOT.'/core/tpl/massactions_pre.tpl.php';
606
607if ($search_all) {
608 $setupstring = '';
609 // @phan-suppress-next-line PhanEmptyForeach
610 foreach ($fieldstosearchall as $key => $val) {
611 $fieldstosearchall[$key] = $langs->trans($val);
612 $setupstring .= $key."=".$val.";";
613 }
614 print '<!-- Search done like if MYOBJECT_QUICKSEARCH_ON_FIELDS = '.$setupstring.' -->'."\n";
615 print '<div class="divsearchfieldfilter">'.$langs->trans("FilterOnInto", $search_all).implode(', ', $fieldstosearchall).'</div>'."\n";
616}
617
618$moreforfilter = '';
619/*$moreforfilter.='<div class="divsearchfield">';
620$moreforfilter.= $langs->trans('MyFilter') . ': <input type="text" name="search_myfield" value="'.dol_escape_htmltag($search_myfield).'">';
621$moreforfilter.= '</div>';*/
622
623$parameters = array();
624$reshook = $hookmanager->executeHooks('printFieldPreListTitle', $parameters, $object, $action); // Note that $action and $object may have been modified by hook
625if (empty($reshook)) {
626 $moreforfilter .= $hookmanager->resPrint;
627} else {
628 $moreforfilter = $hookmanager->resPrint;
629}
630$parameters = array(
631 'arrayfields' => &$arrayfields,
632);
633
634if (!empty($moreforfilter)) {
635 print '<div class="liste_titre liste_titre_bydiv centpercent">';
636 print $moreforfilter;
637 print '</div>';
638}
639
640$varpage = empty($contextpage) ? $_SERVER["PHP_SELF"] : $contextpage;
641$htmlofselectarray = $form->multiSelectArrayWithCheckbox('selectedfields', $arrayfields, $varpage, $conf->main_checkbox_left_column); // This also change content of $arrayfields with user setup
642$selectedfields = (($mode != 'kanban' && $mode != 'kanbangroupby') ? $htmlofselectarray : '');
643$selectedfields .= (count($arrayofmassactions) ? $form->showCheckAddButtons('checkforselect', 1) : '');
644
645print '<div class="div-table-responsive">'; // You can use div-table-responsive-no-min if you don't need reserved height for your table
646print '<table class="tagtable nobottomiftotal noborder liste'.($moreforfilter ? " listwithfilterbefore" : "").'">'."\n";
647
648// Fields title search
649// --------------------------------------------------------------------
650print '<tr class="liste_titre_filter">';
651// Action column
652if ($conf->main_checkbox_left_column) {
653 print '<td class="liste_titre center maxwidthsearch">';
654 $searchpicto = $form->showFilterButtons('left');
655 print $searchpicto;
656 print '</td>';
657}
658foreach ($object->fields as $key => $val) {
659 //$searchkey = empty($search[$key]) ? '' : $search[$key];
660 $cssforfield = (empty($val['csslist']) ? (empty($val['css']) ? '' : $val['css']) : $val['csslist']);
661 if ($key == 'status') {
662 $cssforfield .= ($cssforfield ? ' ' : '').'center';
663 } elseif (in_array($val['type'], array('date', 'datetime', 'timestamp'))) {
664 $cssforfield .= ($cssforfield ? ' ' : '').'center';
665 } elseif (in_array($val['type'], array('timestamp'))) {
666 $cssforfield .= ($cssforfield ? ' ' : '').'nowrap';
667 } 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'])) {
668 $cssforfield .= ($cssforfield ? ' ' : '').'right';
669 }
670 if (!empty($arrayfields['t.'.$key]['checked'])) {
671 print '<td class="liste_titre'.($cssforfield ? ' '.$cssforfield : '').($key == 'status' ? ' parentonrightofpage' : '').'">';
672 if (!empty($val['arrayofkeyval']) && is_array($val['arrayofkeyval'])) {
673 if (empty($val['searchmulti'])) {
674 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);
675 } else {
676 print $form->multiselectarray('search_'.$key, $val['arrayofkeyval'], (isset($search[$key]) ? $search[$key] : ''), 0, 0, 'maxwidth100'.($key == 'status' ? ' search_status width100 onrightofpage' : ''), 1);
677 }
678 } elseif ((strpos($val['type'], 'integer:') === 0) || (strpos($val['type'], 'sellist:') === 0)) {
679 print $object->showInputField($val, $key, (isset($search[$key]) ? $search[$key] : ''), '', '', 'search_', $cssforfield.' maxwidth250', 1);
680 } elseif (preg_match('/^(date|timestamp|datetime)/', $val['type'])) {
681 print '<div class="nowrap">';
682 print $form->selectDate($search[$key.'_dtstart'] ? $search[$key.'_dtstart'] : '', "search_".$key."_dtstart", 0, 0, 1, '', 1, 0, 0, '', '', '', '', 1, '', $langs->trans('From'));
683 print '</div>';
684 print '<div class="nowrap">';
685 print $form->selectDate($search[$key.'_dtend'] ? $search[$key.'_dtend'] : '', "search_".$key."_dtend", 0, 0, 1, '', 1, 0, 0, '', '', '', '', 1, '', $langs->trans('to'));
686 print '</div>';
687 } elseif ($key == 'lang') {
688 require_once DOL_DOCUMENT_ROOT.'/core/class/html.formadmin.class.php';
689 $formadmin = new FormAdmin($db);
690 print $formadmin->select_language((isset($search[$key]) ? $search[$key] : ''), 'search_lang', 0, array(), 1, 0, 0, 'minwidth100imp maxwidth125', 2);
691 } elseif ($val['type'] === 'boolean') {
692 print $form->selectyesno('search_' . $key, $search[$key] ?? '', 1, false, 1);
693 } else {
694 print '<input type="text" class="flat maxwidth'.(in_array($val['type'], array('integer', 'price')) ? '50' : '75').'" name="search_'.$key.'" value="'.dol_escape_htmltag(isset($search[$key]) ? $search[$key] : '').'">';
695 }
696 print '</td>';
697 }
698}
699// Extra fields
700include DOL_DOCUMENT_ROOT.'/core/tpl/extrafields_list_search_input.tpl.php';
701
702// Fields from hook
703$parameters = array('arrayfields' => $arrayfields);
704$reshook = $hookmanager->executeHooks('printFieldListOption', $parameters, $object, $action); // Note that $action and $object may have been modified by hook
705print $hookmanager->resPrint;
706/*if (!empty($arrayfields['anotherfield']['checked'])) {
707 print '<td class="liste_titre"></td>';
708}*/
709// Action column
710if (!$conf->main_checkbox_left_column) {
711 print '<td class="liste_titre center maxwidthsearch">';
712 $searchpicto = $form->showFilterButtons();
713 print $searchpicto;
714 print '</td>';
715}
716print '</tr>'."\n";
717
718$totalarray = array();
719$totalarray['nbfield'] = 0;
720
721// Fields title label
722// --------------------------------------------------------------------
723print '<tr class="liste_titre">';
724// Action column
725if ($conf->main_checkbox_left_column) {
726 print getTitleFieldOfList($selectedfields, 0, $_SERVER["PHP_SELF"], '', '', '', '', $sortfield, $sortorder, 'center maxwidthsearch ')."\n";
727 $totalarray['nbfield']++;
728}
729foreach ($object->fields as $key => $val) {
730 $cssforfield = (empty($val['csslist']) ? (empty($val['css']) ? '' : $val['css']) : $val['csslist']);
731 if ($key == 'status') {
732 $cssforfield .= ($cssforfield ? ' ' : '').'center';
733 } elseif (in_array($val['type'], array('date', 'datetime', 'timestamp'))) {
734 $cssforfield .= ($cssforfield ? ' ' : '').'center';
735 } elseif (in_array($val['type'], array('timestamp'))) {
736 $cssforfield .= ($cssforfield ? ' ' : '').'nowrap';
737 } 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'])) {
738 $cssforfield .= ($cssforfield ? ' ' : '').'right';
739 }
740 $cssforfield = preg_replace('/small\s*/', '', $cssforfield); // the 'small' css must not be used for the title label
741 if (!empty($arrayfields['t.'.$key]['checked'])) {
742 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";
743 $totalarray['nbfield']++;
744 }
745}
746// Extra fields
747include DOL_DOCUMENT_ROOT.'/core/tpl/extrafields_list_search_title.tpl.php';
748// Hook fields
749$parameters = array('arrayfields' => $arrayfields, 'param' => $param, 'sortfield' => $sortfield, 'sortorder' => $sortorder, 'totalarray' => &$totalarray);
750$reshook = $hookmanager->executeHooks('printFieldListTitle', $parameters, $object, $action); // Note that $action and $object may have been modified by hook
751print $hookmanager->resPrint;
752/*if (!empty($arrayfields['anotherfield']['checked'])) {
753 print '<th class="liste_titre">'.$langs->trans("AnotherField").'</th>';
754 $totalarray['nbfield']++;
755}*/
756// Action column
757if (!$conf->main_checkbox_left_column) {
758 print getTitleFieldOfList(($mode != 'kanban' ? $selectedfields : ''), 0, $_SERVER["PHP_SELF"], '', '', '', '', $sortfield, $sortorder, 'center maxwidthsearch ')."\n";
759 $totalarray['nbfield']++;
760}
761print '</tr>'."\n";
762
763// Detect if we need a fetch on each output line
764$needToFetchEachLine = 0;
765if (isset($extrafields->attributes[$object->table_element]['computed']) && is_array($extrafields->attributes[$object->table_element]['computed']) && count($extrafields->attributes[$object->table_element]['computed']) > 0) {
766 foreach ($extrafields->attributes[$object->table_element]['computed'] as $key => $val) {
767 if (!is_null($val) && preg_match('/\$object/', $val)) {
768 $needToFetchEachLine++; // There is at least one compute field that use $object
769 }
770 }
771}
772
773
774// Loop on record
775// --------------------------------------------------------------------
776$i = 0;
777$savnbfield = $totalarray['nbfield'];
778$totalarray = array();
779$totalarray['nbfield'] = 0;
780$imaxinloop = ($limit ? min($num, $limit) : $num);
781while ($i < $imaxinloop) {
782 $obj = $db->fetch_object($resql);
783 if (empty($obj)) {
784 break; // Should not happen
785 }
786
787 // Store properties in $object
788 $object->setVarsFromFetchObj($obj);
789
790 /*
791 $object->thirdparty = null;
792 if ($obj->fk_soc > 0) {
793 if (!empty($conf->cache['thirdparty'][$obj->fk_soc])) {
794 $companyobj = $conf->cache['thirdparty'][$obj->fk_soc];
795 } else {
796 $companyobj = new Societe($db);
797 $companyobj->fetch($obj->fk_soc);
798 $conf->cache['thirdparty'][$obj->fk_soc] = $companyobj;
799 }
800
801 $object->thirdparty = $companyobj;
802 }*/
803
804 if ($mode == 'kanban' || $mode == 'kanbangroupby') {
805 if ($i == 0) {
806 print '<tr class="trkanban"><td colspan="'.$savnbfield.'">';
807 print '<div class="box-flex-container kanban">';
808 }
809 // Output Kanban
810 $selected = -1;
811 if ($massactionbutton || $massaction) { // If we are in select mode (massactionbutton defined) or if we have already selected and sent an action ($massaction) defined
812 $selected = 0;
813 if (in_array($object->id, $arrayofselected)) {
814 $selected = 1;
815 }
816 }
817 //print $object->getKanbanView('', array('thirdparty'=>$object->thirdparty, 'selected' => $selected));
818 print $object->getKanbanView('', array('selected' => $selected));
819 if ($i == ($imaxinloop - 1)) {
820 print '</div>';
821 print '</td></tr>';
822 }
823 } else {
824 // Show line of result
825 $j = 0;
826 print '<tr data-rowid="'.$object->id.'" class="oddeven row-with-select">';
827
828 // Action column
829 if ($conf->main_checkbox_left_column) {
830 print '<td class="nowrap center">';
831 if ($massactionbutton || $massaction) { // If we are in select mode (massactionbutton defined) or if we have already selected and sent an action ($massaction) defined
832 $selected = 0;
833 if (in_array($object->id, $arrayofselected)) {
834 $selected = 1;
835 }
836 print '<input id="cb'.$object->id.'" class="flat checkforselect" type="checkbox" name="toselect[]" value="'.$object->id.'"'.($selected ? ' checked="checked"' : '').'>';
837 }
838 print '</td>';
839 if (!$i) {
840 $totalarray['nbfield']++;
841 }
842 }
843 // Fields
844 foreach ($object->fields as $key => $val) {
845 $cssforfield = (empty($val['csslist']) ? (empty($val['css']) ? '' : $val['css']) : $val['csslist']);
846 if (in_array($val['type'], array('date', 'datetime', 'timestamp'))) {
847 $cssforfield .= ($cssforfield ? ' ' : '').'center';
848 } elseif ($key == 'status') {
849 $cssforfield .= ($cssforfield ? ' ' : '').'center';
850 }
851
852 if (in_array($val['type'], array('timestamp'))) {
853 $cssforfield .= ($cssforfield ? ' ' : '').'nowraponall';
854 } elseif ($key == 'ref') {
855 $cssforfield .= ($cssforfield ? ' ' : '').'nowraponall';
856 }
857
858 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'])) {
859 $cssforfield .= ($cssforfield ? ' ' : '').'right';
860 }
861 //if (in_array($key, array('fk_soc', 'fk_user', 'fk_warehouse'))) $cssforfield = 'tdoverflowmax100';
862
863 if (!empty($arrayfields['t.'.$key]['checked'])) {
864 print '<td'.($cssforfield ? ' class="'.$cssforfield.((preg_match('/tdoverflow/', $cssforfield) && !in_array($val['type'], array('ip', 'url')) && !is_numeric($object->$key)) ? ' classfortooltip' : '').'"' : '');
865 if (preg_match('/tdoverflow/', $cssforfield) && !in_array($val['type'], array('ip', 'url')) && !is_numeric($object->$key) && !in_array($key, array('ref'))) {
866 print ' title="'.dol_escape_htmltag((string) $object->$key).'"';
867 }
868 print '>';
869 if ($key == 'status') {
870 print $object->getLibStatut(5);
871 } elseif ($key == 'rowid') {
872 print $object->showOutputField($val, $key, (string) $object->id, '');
873 } else {
874 if ($val['type'] == 'html') {
875 print '<div class="small lineheightsmall twolinesmax-normallineheight">';
876 }
877 print $object->showOutputField($val, $key, (string) $object->$key, '');
878 if ($val['type'] == 'html') {
879 print '</div>';
880 }
881 }
882 print '</td>';
883 if (!$i) {
884 $totalarray['nbfield']++;
885 }
886 if (!empty($val['isameasure']) && $val['isameasure'] == 1) {
887 if (!$i) {
888 $totalarray['pos'][$totalarray['nbfield']] = 't.'.$key;
889 }
890 if (!isset($totalarray['val'])) {
891 $totalarray['val'] = array();
892 }
893 if (!isset($totalarray['val']['t.'.$key])) {
894 $totalarray['val']['t.'.$key] = 0;
895 }
896 $totalarray['val']['t.'.$key] += $object->$key;
897 }
898 }
899 }
900 // Extra fields
901 include DOL_DOCUMENT_ROOT.'/core/tpl/extrafields_list_print_fields.tpl.php';
902 // Fields from hook
903 $parameters = array('arrayfields' => $arrayfields, 'object' => $object, 'obj' => $obj, 'i' => $i, 'totalarray' => &$totalarray);
904 $reshook = $hookmanager->executeHooks('printFieldListValue', $parameters, $object, $action); // Note that $action and $object may have been modified by hook
905 print $hookmanager->resPrint;
906
907 /*if (!empty($arrayfields['anotherfield']['checked'])) {
908 print '<td class="right">'.$obj->anotherfield.'</td>';
909 }*/
910
911 // Action column
912 if (empty($conf->main_checkbox_left_column)) {
913 print '<td class="nowrap center">';
914 if ($massactionbutton || $massaction) { // If we are in select mode (massactionbutton defined) or if we have already selected and sent an action ($massaction) defined
915 $selected = 0;
916 if (in_array($object->id, $arrayofselected)) {
917 $selected = 1;
918 }
919 print '<input id="cb'.$object->id.'" class="flat checkforselect" type="checkbox" name="toselect[]" value="'.$object->id.'"'.($selected ? ' checked="checked"' : '').'>';
920 }
921 print '</td>';
922 if (!$i) {
923 $totalarray['nbfield']++;
924 }
925 }
926
927 print '</tr>'."\n";
928 }
929
930 $i++;
931}
932
933// Show total line
934include DOL_DOCUMENT_ROOT.'/core/tpl/list_print_total.tpl.php';
935
936// If no record found
937if ($num == 0) {
938 $colspan = 1;
939 foreach ($arrayfields as $key => $val) {
940 if (!empty($val['checked'])) {
941 $colspan++;
942 }
943 }
944 print '<tr><td colspan="'.$colspan.'"><span class="opacitymedium">'.$langs->trans("NoRecordFound").'</span></td></tr>';
945}
946
947
948$db->free($resql);
949
950$parameters = array('arrayfields' => $arrayfields, 'sql' => $sql);
951$reshook = $hookmanager->executeHooks('printFieldListFooter', $parameters, $object, $action); // Note that $action and $object may have been modified by hook
952print $hookmanager->resPrint;
953
954print '</table>'."\n";
955print '</div>'."\n";
956
957print '</form>'."\n";
958
959if (in_array('builddoc', array_keys($arrayofmassactions)) && ($nbtotalofrecords === '' || $nbtotalofrecords)) {
960 $hidegeneratedfilelistifempty = 1;
961 if ($massaction == 'builddoc' || $action == 'remove_file' || $show_files) {
962 $hidegeneratedfilelistifempty = 0;
963 }
964
965 require_once DOL_DOCUMENT_ROOT.'/core/class/html.formfile.class.php';
966 $formfile = new FormFile($db);
967
968 // Show list of available documents
969 $urlsource = $_SERVER['PHP_SELF'].'?sortfield='.$sortfield.'&sortorder='.$sortorder;
970 $urlsource .= str_replace('&amp;', '&', $param);
971
972 $filedir = $diroutputmassaction;
973 $genallowed = $permissiontoread;
974 $delallowed = $permissiontoadd;
975
976 print $formfile->showdocuments('massfilesarea_'.$object->module, '', $filedir, $urlsource, 0, $delallowed, '', 1, 1, 0, 48, 1, $param, $title, '', '', '', null, $hidegeneratedfilelistifempty);
977}
978
979// End of page
980llxFooter();
981$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
$totalarray
Definition export.php:1216
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
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 MyObject.
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_barre_liste($title, $page, $file, $options='', $sortfield='', $sortorder='', $morehtmlcenter='', $num=-1, $totalnboflines='', $picto='generic', $pictoisfullpath=0, $morehtmlright='', $morecss='', $limit=-1, $selectlimitsuffix=0, $hidenavigation=0, $pagenavastextinput=0, $morehtmlrightbeforearrow='')
Print a title with navigation controls for pagination.
img_picto($titlealt, $picto, $moreatt='', $pictoisfullpath=0, $srconly=0, $notitle=0, $alt='', $morecss='', $marginleftonlyshort=2, $allowothertags=array())
Show picto whatever it's its name (generic function)
GETPOSTINT($paramname, $method=0)
Return the value of a $_GET or $_POST supervariable, converted into integer.
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, $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...
getTitleFieldOfList($name, $thead=0, $file="", $field="", $begin="", $moreparam="", $moreattrib="", $sortfield="", $sortorder="", $prefix="", $disablesortlink=0, $tooltip='', $forcenowrapcolumntitle=0)
Get title line of an array.
dolGetButtonTitleSeparator($moreClass="")
Add space between dolGetButtonTitle.
getDolDefaultContextPage($s)
Return the default context page string.
GETPOST($paramname, $check='alphanohtml', $method=0, $filter=null, $options=null, $noreplace=0)
Return value of a param into GET or POST supervariable.
dol_buildpath($path, $type=0, $returnemptyifnotfound=0)
Return path of url or filesystem.
dol_print_error($db=null, $error='', $errors=null)
Displays error message system with all the information to facilitate the diagnosis and the escalation...
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...
accessforbidden($message='', $printheader=1, $printfooter=1, $showonlymessage=0, $params=null)
Show a message to say access is forbidden and stop program.