dolibarr 24.0.3
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-2026 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// Definition of array of fields with hardcoded columns
196/*
197$arrayfields = array_merge($arrayfields, array(
198 't.anotherfield' => array('type'=>'integer', 'label'=>'AnotherField', 'checked'=>'1', 'enabled'=>'1', 'position'=>'90', 'csslist'=>'right'),
199));
200*/
201
202// Extra fields
203include DOL_DOCUMENT_ROOT.'/core/tpl/extrafields_list_array_fields.tpl.php';
204// Add hook to complete $arrayfield
205$parameters = array('arrayfields' => &$arrayfields);
206$reshook = $hookmanager->executeHooks('completeArrayFields', $parameters, $object, $action); // Note that $action and $object may have been modified by hook
207
208// Complete arrayfields with special fields
209/*$arrayfields = array_merge($arrayfields, array(
210 'anotherfield' => array('type'=>'integer', 'label'=>'AnotherField', 'checked'=>'1', 'enabled'=>'1', 'position'=>'90', 'csslist'=>'right'),
211));*/
212
213// Change position of fields in arrayfield and object
214include DOL_DOCUMENT_ROOT.'/core/tpl/arrayfield_object_position_fields.tpl.php';
215
216$object->fields = dol_sort_array($object->fields, 'position');
217$arrayfields = dol_sort_array($arrayfields, 'position');
218
219// There is several ways to check permission.
220// Set $enablepermissioncheck to 1 to enable a minimum low level of checks
221$enablepermissioncheck = getDolGlobalInt('MYMODULE_ENABLE_PERMISSION_CHECK');
222if ($enablepermissioncheck) {
223 $permissiontoread = $user->hasRight('mymodule', 'myobject', 'read');
224 $permissiontoadd = $user->hasRight('mymodule', 'myobject', 'write');
225 $permissiontodelete = $user->hasRight('mymodule', 'myobject', 'delete');
226} else {
227 $permissiontoread = 1;
228 $permissiontoadd = 1;
229 $permissiontodelete = 1;
230}
231
232// Security check (enable the most restrictive one)
233if ($user->socid > 0) {
235}
236//if ($user->socid > 0) accessforbidden();
237//$socid = 0; if ($user->socid > 0) $socid = $user->socid;
238//$isdraft = (($object->status == $object::STATUS_DRAFT) ? 1 : 0);
239//restrictedArea($user, $object->module, 0, $object->table_element, $object->element, 'fk_soc', 'rowid', $isdraft);
240if (!isModEnabled("mymodule")) {
241 accessforbidden('Module mymodule not enabled');
242}
243if (!$permissiontoread) {
245}
246
247
248/*
249 * Actions
250 */
251
252if (GETPOST('cancel', 'alpha')) {
253 $action = 'list';
254 $massaction = '';
255}
256if (!GETPOST('confirmmassaction', 'alpha') && $massaction != 'presend' && $massaction != 'confirm_presend') {
257 $massaction = '';
258}
259
260$parameters = array('arrayfields' => &$arrayfields);
261$reshook = $hookmanager->executeHooks('doActions', $parameters, $object, $action); // Note that $action and $object may have been modified by some hooks
262if ($reshook < 0) {
263 setEventMessages($hookmanager->error, $hookmanager->errors, 'errors');
264}
265
266if (empty($reshook)) {
267 // Selection of new fields
268 include DOL_DOCUMENT_ROOT.'/core/actions_changeselectedfields.inc.php';
269
270 // Purge search criteria
271 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
272 foreach ($object->fields as $key => $val) {
273 $search[$key] = '';
274 if (preg_match('/^(date|timestamp|datetime)/', $val['type'])) {
275 $search[$key.'_dtstart'] = '';
276 $search[$key.'_dtend'] = '';
277 }
278 }
279 $search_all = '';
280 $toselect = array();
281 $search_array_options = array();
282 }
283 if (GETPOST('button_removefilter_x', 'alpha') || GETPOST('button_removefilter.x', 'alpha') || GETPOST('button_removefilter', 'alpha')
284 || GETPOST('button_search_x', 'alpha') || GETPOST('button_search.x', 'alpha') || GETPOST('button_search', 'alpha')) {
285 $massaction = ''; // Protection to avoid mass action if we force a new search during a mass action confirmation
286 }
287
288 // Mass actions
289 $objectclass = 'MyObject';
290 $objectlabel = 'MyObject';
291 $uploaddir = $conf->mymodule->dir_output;
292
293 global $error;
294 include DOL_DOCUMENT_ROOT.'/core/actions_massactions.inc.php';
295
296 // You can add more action here
297 // if ($action == 'xxx' && $permissiontoxxx) ...
298}
299
300
301
302/*
303 * View
304 */
305
306$form = new Form($db);
307
308$now = dol_now();
309
310$title = $langs->trans("MyObjects");
311//$help_url = "EN:Module_MyObject|FR:Module_MyObject_FR|ES:Módulo_MyObject";
312$help_url = '';
313$morejs = array();
314$morecss = array();
315
316
317// Build and execute select
318// --------------------------------------------------------------------
319$sql = "SELECT";
320$sql .= " ".$object->getFieldList('t');
321// Add fields from extrafields
322if (!empty($extrafields->attributes[$object->table_element]['label'])) {
323 foreach ($extrafields->attributes[$object->table_element]['label'] as $key => $val) {
324 $sql .= ($extrafields->attributes[$object->table_element]['type'][$key] != 'separate' ? ", ef.".$key." as options_".$key : "");
325 }
326}
327// Add fields from hooks
328$parameters = array();
329$reshook = $hookmanager->executeHooks('printFieldListSelect', $parameters, $object, $action); // Note that $action and $object may have been modified by hook
330$sql .= $hookmanager->resPrint;
331$sql = preg_replace('/,\s*$/', '', $sql);
332
333$sqlfields = $sql; // $sql fields to remove for count total
334
335$sql .= " FROM ".$db->prefix().$object->table_element." as t";
336//$sql .= " LEFT JOIN ".$db->prefix()."anothertable as rc ON rc.parent = t.rowid";
337if (isset($extrafields->attributes[$object->table_element]['label']) && is_array($extrafields->attributes[$object->table_element]['label']) && count($extrafields->attributes[$object->table_element]['label'])) {
338 $sql .= " LEFT JOIN ".$db->prefix().$object->table_element."_extrafields as ef on (t.rowid = ef.fk_object)";
339}
340// Add table from hooks
341$parameters = array();
342$reshook = $hookmanager->executeHooks('printFieldListFrom', $parameters, $object, $action); // Note that $action and $object may have been modified by hook
343$sql .= $hookmanager->resPrint;
344
345if (!empty($object->ismultientitymanaged) && (int) $object->ismultientitymanaged == 1) {
346 $sql .= " WHERE t.entity IN (".getEntity($object->element, (GETPOSTINT('search_current_entity') ? 0 : 1)).")";
347} elseif (preg_match('/^\w+@\w+$/', (string) $object->ismultientitymanaged)) {
348 $tmparray = explode('@', (string) $object->ismultientitymanaged);
349 $sql .= " LEFT JOIN ".$object->db->prefix().$db->sanitize($tmparray[1])." as pt ON t.".$db->sanitize($tmparray[0])." = pt.rowid";
350 $sql .= " WHERE pt.entity IN (".getEntity($object->element, (GETPOSTINT('search_current_entity') ? 0 : 1)).")";
351} else {
352 $sql .= " WHERE 1 = 1";
353}
354foreach ($search as $key => $val) {
355 if (array_key_exists($key, $object->fields)) {
356 if ($key == 'status' && $search[$key] == -1) {
357 continue;
358 }
359 $field_spec = $object->fields[$key];
360 // Ignore false positive @phan-suppress-next-line PhanTypeMismatchArgumentNullable
361 $mode_search = (($object->isInt($field_spec) || $object->isFloat($field_spec)) ? 1 : 0);
362 if ((strpos($field_spec['type'], 'integer:') === 0) || (strpos($field_spec['type'], 'sellist:') === 0) || !empty($field_spec['arrayofkeyval'])) {
363 if ($search[$key] == '-1' || ($search[$key] === '0' && (empty($field_spec['arrayofkeyval']) || !array_key_exists('0', $field_spec['arrayofkeyval'])))) {
364 $search[$key] = '';
365 }
366 $mode_search = 2;
367 }
368 if ($field_spec['type'] === 'boolean') {
369 $mode_search = 1;
370 if ($search[$key] == '-1') {
371 $search[$key] = '';
372 }
373 }
374 if (empty($field_spec['searchmulti'])) {
375 if (!is_array($search[$key]) && $search[$key] != '') {
376 $sql .= natural_search("t.".$db->escape($key), $search[$key], (($key == 'status') ? 2 : $mode_search));
377 }
378 } else {
379 if (is_array($search[$key]) && !empty($search[$key])) {
380 $sql .= natural_search("t.".$db->escape($key), implode(',', $search[$key]), (($key == 'status') ? 2 : $mode_search));
381 }
382 }
383 } else {
384 if (preg_match('/(_dtstart|_dtend)$/', $key) && $search[$key] != '') {
385 $columnName = preg_replace('/(_dtstart|_dtend)$/', '', $key);
386 if (preg_match('/^(date|timestamp|datetime)/', $object->fields[$columnName]['type'])) {
387 if (preg_match('/_dtstart$/', $key)) {
388 $sql .= " AND t.".$db->sanitize($columnName)." >= '".$db->idate($search[$key])."'";
389 }
390 if (preg_match('/_dtend$/', $key)) {
391 $sql .= " AND t.".$db->sanitize($columnName)." <= '".$db->idate($search[$key])."'";
392 }
393 }
394 }
395 }
396}
397if ($search_all) {
398 $sql .= natural_search(array_keys($fieldstosearchall), $search_all);
399}
400/*
401// If the internal user must only see his customers, force searching by him
402$search_sale = 0;
403if (!$user->hasRight('societe', 'client', 'voir')) {
404 $search_sale = $user->id;
405}
406// Search on sale representative
407if ($search_sale && $search_sale != '-1') {
408 if ($search_sale == -2) {
409 $sql .= " AND NOT EXISTS (SELECT sc.fk_soc FROM ".$db->prefix()."societe_commerciaux as sc WHERE sc.fk_soc = t.fk_soc)";
410 } elseif ($search_sale > 0) {
411 $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).")";
412 }
413}
414// Search on socid
415if ($socid) {
416 $sql .= " AND t.fk_soc = ".((int) $socid);
417}
418*/
419//$sql.= dolSqlDateFilter("t.field", $search_xxxday, $search_xxxmonth, $search_xxxyear);
420// Add where from extra fields
421include DOL_DOCUMENT_ROOT.'/core/tpl/extrafields_list_search_sql.tpl.php';
422// Add where from hooks
423$parameters = array();
424$reshook = $hookmanager->executeHooks('printFieldListWhere', $parameters, $object, $action); // Note that $action and $object may have been modified by hook
425$sql .= $hookmanager->resPrint;
426
427/* If a group by is required
428$sql .= " GROUP BY ";
429foreach($object->fields as $key => $val) {
430 $sql .= "t.".$db->sanitize($key).", ";
431}
432// Add fields from extrafields
433if (!empty($extrafields->attributes[$object->table_element]['label'])) {
434 foreach ($extrafields->attributes[$object->table_element]['label'] as $key => $val) {
435 $sql .= ($extrafields->attributes[$object->table_element]['type'][$key] != 'separate' ? "ef.".$key.', ' : '');
436 }
437}
438// Add groupby from hooks
439$parameters = array();
440$reshook = $hookmanager->executeHooks('printFieldListGroupBy', $parameters, $object, $action); // Note that $action and $object may have been modified by hook
441if (empty($reshook)) {
442 $sql .= $hookmanager->resPrint;
443} else {
444 $sql = $hookmanager->resPrint;
445}
446
447$sql = preg_replace('/,\s*$/', '', $sql);
448*/
449
450// Add HAVING from hooks
451/*
452$parameters = array();
453$reshook = $hookmanager->executeHooks('printFieldListHaving', $parameters, $object, $action); // Note that $action and $object may have been modified by hook
454if (empty($reshook)) {
455 $sql .= empty($hookmanager->resPrint) ? "" : " HAVING 1=1 ".$hookmanager->resPrint;
456} else {
457 $sql = $hookmanager->resPrint;
458}
459*/
460
461// Count total nb of records
462$nbtotalofrecords = '';
463if (!getDolGlobalInt('MAIN_DISABLE_FULL_SCANLIST')) {
464 /* The fast and low memory method to get and count full list converts the sql into a sql count */
465 $sqlforcount = preg_replace('/^'.preg_quote($sqlfields, '/').'/', 'SELECT COUNT(*) as nbtotalofrecords', $sql);
466 $sqlforcount = preg_replace('/GROUP BY .*$/', '', $sqlforcount);
467
468 $resql = $db->query($sqlforcount);
469 if ($resql) {
470 $objforcount = $db->fetch_object($resql);
471 $nbtotalofrecords = $objforcount->nbtotalofrecords;
472 } else {
474 }
475
476 if (($page * $limit) > (int) $nbtotalofrecords) { // if total resultset is smaller than the paging size (filtering), goto and load page 0
477 $page = 0;
478 $offset = 0;
479 }
480 $db->free($resql);
481}
482
483// Complete request and execute it with limit
484$sql .= $db->order($sortfield, $sortorder);
485if ($limit) {
486 $sql .= $db->plimit($limit + 1, $offset);
487}
488
489$resql = $db->query($sql);
490if (!$resql) {
492 exit;
493}
494
495$num = $db->num_rows($resql);
496
497
498// Direct jump if only one record found
499if ($num == 1 && getDolGlobalInt('MAIN_SEARCH_DIRECT_OPEN_IF_ONLY_ONE') && $search_all && !$page) {
500 $obj = $db->fetch_object($resql);
501 $id = $obj->rowid;
502 header("Location: ".dol_buildpath('/mymodule/myobject_card.php', 1).'?id='.((int) $id));
503 exit;
504}
505
506
507// Output page
508// --------------------------------------------------------------------
509
510llxHeader('', $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
511
512// Example : Adding jquery code
513// print '<script type="text/javascript">
514// jQuery(document).ready(function() {
515// function init_myfunc()
516// {
517// jQuery("#myid").removeAttr(\'disabled\');
518// jQuery("#myid").attr(\'disabled\',\'disabled\');
519// }
520// init_myfunc();
521// jQuery("#mybutton").click(function() {
522// init_myfunc();
523// });
524// });
525// </script>';
526
527$arrayofselected = is_array($toselect) ? $toselect : array();
528
529$param = '';
530if (!empty($mode)) {
531 $param .= '&mode='.urlencode($mode);
532}
533if (!empty($contextpage) && $contextpage != getDolDefaultContextPage(__FILE__)) {
534 $param .= '&contextpage='.urlencode($contextpage);
535}
536if ($limit > 0 && $limit != $conf->liste_limit) {
537 $param .= '&limit='.((int) $limit);
538}
539if ($optioncss != '') {
540 $param .= '&optioncss='.urlencode($optioncss);
541}
542if ($groupby != '') {
543 $param .= '&groupby='.urlencode($groupby);
544}
545foreach ($search as $key => $val) {
546 if (is_array($search[$key])) {
547 foreach ($search[$key] as $skey) {
548 if ($skey != '') {
549 $param .= '&search_'.$key.'[]='.urlencode($skey);
550 }
551 }
552 } elseif (preg_match('/(_dtstart|_dtend)$/', $key) && !empty($val)) {
553 $param .= '&search_'.$key.'month='.GETPOSTINT('search_'.$key.'month');
554 $param .= '&search_'.$key.'day='.GETPOSTINT('search_'.$key.'day');
555 $param .= '&search_'.$key.'year='.GETPOSTINT('search_'.$key.'year');
556 } elseif ($search[$key] != '') {
557 $param .= '&search_'.$key.'='.urlencode((string) $search[$key]);
558 }
559}
560// Add $param from extra fields
561include DOL_DOCUMENT_ROOT.'/core/tpl/extrafields_list_search_param.tpl.php';
562// Add $param from hooks
563$parameters = array('param' => &$param);
564$reshook = $hookmanager->executeHooks('printFieldListSearchParam', $parameters, $object, $action); // Note that $action and $object may have been modified by hook
565$param .= $hookmanager->resPrint;
566
567// List of mass actions available
568$arrayofmassactions = array(
569 //'validate'=>img_picto('', 'check', 'class="pictofixedwidth"').$langs->trans("Validate"),
570 //'generate_doc'=>img_picto('', 'pdf', 'class="pictofixedwidth"').$langs->trans("ReGeneratePDF"),
571 //'builddoc'=>img_picto('', 'pdf', 'class="pictofixedwidth"').$langs->trans("PDFMerge"),
572 //'presend'=>img_picto('', 'email', 'class="pictofixedwidth"').$langs->trans("SendByMail"),
573);
574if (!empty($permissiontodelete)) {
575 $arrayofmassactions['predelete'] = img_picto('', 'delete', 'class="pictofixedwidth"').$langs->trans("Delete");
576}
577if (GETPOSTINT('nomassaction') || in_array($massaction, array('presend', 'predelete'))) {
578 $arrayofmassactions = array();
579}
580$massactionbutton = $form->selectMassAction('', $arrayofmassactions);
581
582print '<form method="POST" id="searchFormList" action="'.$_SERVER["PHP_SELF"].'">'."\n";
583if ($optioncss != '') {
584 print '<input type="hidden" name="optioncss" value="'.$optioncss.'">';
585}
586print '<input type="hidden" name="token" value="'.newToken().'">';
587print '<input type="hidden" name="formfilteraction" id="formfilteraction" value="list">';
588print '<input type="hidden" name="action" value="list">';
589print '<input type="hidden" name="sortfield" value="'.$sortfield.'">';
590print '<input type="hidden" name="sortorder" value="'.$sortorder.'">';
591print '<input type="hidden" name="page" value="'.$page.'">';
592print '<input type="hidden" name="contextpage" value="'.$contextpage.'">';
593print '<input type="hidden" name="page_y" value="">';
594print '<input type="hidden" name="mode" value="'.$mode.'">';
595
596
597$newcardbutton = '';
598$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'));
599$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'));
600//$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'));
601//$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'));
602$newcardbutton .= dolGetButtonTitle($langs->trans('Statistics'), '', 'fa fa-chart-bar imgforviewmode', dol_buildpath('/mymodule/stats/myobject_index.php', 1).'?mode=statistics&objecttype=myobject@mymodule'.preg_replace('/(&|\?)*(mode|groupby)=[^&]+/', '', $param), '', ($mode == 'statistics' ? 2 : 1), array('morecss' => 'reposition'));
603$newcardbutton .= dolGetButtonTitleSeparator();
604$newcardbutton .= dolGetButtonTitle($langs->trans('New'), '', 'fa fa-plus-circle', dol_buildpath('/mymodule/myobject_card.php', 1).'?action=create&backtopage='.urlencode($_SERVER['PHP_SELF']), '', $permissiontoadd);
605
606print_barre_liste($title, $page, $_SERVER["PHP_SELF"], $param, $sortfield, $sortorder, $massactionbutton, $num, $nbtotalofrecords, $object->picto, 0, $newcardbutton, '', $limit, 0, 0, 1);
607
608// Add code for pre mass action (confirmation or email presend form)
609$topicmail = "SendMyObjectRef";
610$modelmail = "myobject";
611$objecttmp = new MyObject($db);
612$trackid = 'myobject'.$object->id;
613include DOL_DOCUMENT_ROOT.'/core/tpl/massactions_pre.tpl.php';
614
615if ($search_all) {
616 $setupstring = '';
617 // @phan-suppress-next-line PhanEmptyForeach
618 foreach ($fieldstosearchall as $key => $val) {
619 $fieldstosearchall[$key] = $langs->trans($val);
620 $setupstring .= $key."=".$val.";";
621 }
622 print '<!-- Search done like if MYOBJECT_QUICKSEARCH_ON_FIELDS = '.$setupstring.' -->'."\n";
623 print '<div class="divsearchfieldfilter">'.$langs->trans("FilterOnInto", $search_all).implode(', ', $fieldstosearchall).'</div>'."\n";
624}
625
626$moreforfilter = '';
627/*$moreforfilter.='<div class="divsearchfield">';
628$moreforfilter.= $langs->trans('MyFilter') . ': <input type="text" name="search_myfield" value="'.dol_escape_htmltag($search_myfield).'">';
629$moreforfilter.= '</div>';*/
630
631$parameters = array();
632$reshook = $hookmanager->executeHooks('printFieldPreListTitle', $parameters, $object, $action); // Note that $action and $object may have been modified by hook
633if (empty($reshook)) {
634 $moreforfilter .= $hookmanager->resPrint;
635} else {
636 $moreforfilter = $hookmanager->resPrint;
637}
638$parameters = array(
639 'arrayfields' => &$arrayfields,
640);
641
642if (!empty($moreforfilter)) {
643 print '<div class="liste_titre liste_titre_bydiv centpercent">';
644 print $moreforfilter;
645 print '</div>';
646}
647
648$varpage = empty($contextpage) ? $_SERVER["PHP_SELF"] : $contextpage;
649$htmlofselectarray = $form->multiSelectArrayWithCheckbox('selectedfields', $arrayfields, $varpage, $conf->main_checkbox_left_column, 1); // This also change content of $arrayfields with user setup
650$selectedfields = (($mode != 'kanban' && $mode != 'kanbangroupby') ? $htmlofselectarray : '');
651$selectedfields .= (count($arrayofmassactions) ? $form->showCheckAddButtons('checkforselect', 1) : '');
652
653print '<div class="div-table-responsive">'; // You can use div-table-responsive-no-min if you don't need reserved height for your table
654print '<table class="tagtable nobottomiftotal noborder liste'.($moreforfilter ? " listwithfilterbefore" : "").'">'."\n";
655
656// Fields title search
657// --------------------------------------------------------------------
658print '<tr class="liste_titre_filter">';
659// Action column
660if ($conf->main_checkbox_left_column) {
661 print '<td class="liste_titre center maxwidthsearch">';
662 $searchpicto = $form->showFilterButtons('left');
663 print $searchpicto;
664 print '</td>';
665}
666foreach ($object->fields as $key => $val) {
667 //$searchkey = empty($search[$key]) ? '' : $search[$key];
668 $cssforfield = (empty($val['csslist']) ? (empty($val['css']) ? '' : $val['css']) : $val['csslist']);
669 if ($key == 'status') {
670 $cssforfield .= ($cssforfield ? ' ' : '').'center';
671 } elseif (in_array($val['type'], array('date', 'datetime', 'timestamp'))) {
672 $cssforfield .= ($cssforfield ? ' ' : '').'center';
673 } elseif (in_array($val['type'], array('timestamp'))) {
674 $cssforfield .= ($cssforfield ? ' ' : '').'nowrap';
675 } 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'])) {
676 $cssforfield .= ($cssforfield ? ' ' : '').'right';
677 }
678 if (!empty($arrayfields['t.'.$key]['checked'])) {
679 print '<td class="liste_titre'.($cssforfield ? ' '.$cssforfield : '').($key == 'status' ? ' parentonrightofpage' : '').'">';
680 if (!empty($val['arrayofkeyval']) && is_array($val['arrayofkeyval'])) {
681 if (empty($val['searchmulti'])) {
682 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);
683 } else {
684 print $form->multiselectarray('search_'.$key, $val['arrayofkeyval'], (isset($search[$key]) ? $search[$key] : ''), 0, 0, 'maxwidth100'.($key == 'status' ? ' search_status width100 onrightofpage' : ''), 1);
685 }
686 } elseif ((strpos($val['type'], 'integer:') === 0) || (strpos($val['type'], 'sellist:') === 0)) {
687 print $object->showInputField($val, $key, (isset($search[$key]) ? $search[$key] : ''), '', '', 'search_', $cssforfield.' maxwidth250', 1);
688 } elseif (preg_match('/^(date|timestamp|datetime)/', $val['type'])) {
689 print '<div class="nowrap">';
690 print $form->selectDate($search[$key.'_dtstart'] ? $search[$key.'_dtstart'] : '', "search_".$key."_dtstart", 0, 0, 1, '', 1, 0, 0, '', '', '', '', 1, '', $langs->trans('From'));
691 print '</div>';
692 print '<div class="nowrap">';
693 print $form->selectDate($search[$key.'_dtend'] ? $search[$key.'_dtend'] : '', "search_".$key."_dtend", 0, 0, 1, '', 1, 0, 0, '', '', '', '', 1, '', $langs->trans('to'));
694 print '</div>';
695 } elseif ($key == 'lang') {
696 require_once DOL_DOCUMENT_ROOT.'/core/class/html.formadmin.class.php';
697 $formadmin = new FormAdmin($db);
698 print $formadmin->select_language((isset($search[$key]) ? $search[$key] : ''), 'search_lang', 0, array(), 1, 0, 0, 'minwidth100imp maxwidth125', 2);
699 } elseif ($val['type'] === 'boolean') {
700 print $form->selectyesno('search_' . $key, $search[$key] ?? '', 1, false, 1);
701 } else {
702 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] : '').'">';
703 }
704 print '</td>';
705 }
706}
707// Extra fields
708include DOL_DOCUMENT_ROOT.'/core/tpl/extrafields_list_search_input.tpl.php';
709
710// Fields from hook
711$parameters = array('arrayfields' => $arrayfields);
712$reshook = $hookmanager->executeHooks('printFieldListOption', $parameters, $object, $action); // Note that $action and $object may have been modified by hook
713print $hookmanager->resPrint;
714/*if (!empty($arrayfields['anotherfield']['checked'])) {
715 print '<td class="liste_titre"></td>';
716}*/
717// Action column
718if (!$conf->main_checkbox_left_column) {
719 print '<td class="liste_titre center maxwidthsearch">';
720 $searchpicto = $form->showFilterButtons();
721 print $searchpicto;
722 print '</td>';
723}
724print '</tr>'."\n";
725
726$totalarray = array();
727$totalarray['nbfield'] = 0;
728
729// Fields title label
730// --------------------------------------------------------------------
731print '<tr class="liste_titre">';
732// Action column
733if ($conf->main_checkbox_left_column) {
734 print getTitleFieldOfList($selectedfields, 0, $_SERVER["PHP_SELF"], '', '', '', '', $sortfield, $sortorder, 'center maxwidthsearch ')."\n";
735 $totalarray['nbfield']++;
736}
737foreach ($object->fields as $key => $val) {
738 $cssforfield = (empty($val['csslist']) ? (empty($val['css']) ? '' : $val['css']) : $val['csslist']);
739 if ($key == 'status') {
740 $cssforfield .= ($cssforfield ? ' ' : '').'center';
741 } elseif (in_array($val['type'], array('date', 'datetime', 'timestamp'))) {
742 $cssforfield .= ($cssforfield ? ' ' : '').'center';
743 } elseif (in_array($val['type'], array('timestamp'))) {
744 $cssforfield .= ($cssforfield ? ' ' : '').'nowrap';
745 } 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'])) {
746 $cssforfield .= ($cssforfield ? ' ' : '').'right';
747 }
748 $cssforfield = preg_replace('/small\s*/', '', $cssforfield); // the 'small' css must not be used for the title label
749 if (!empty($arrayfields['t.'.$key]['checked'])) {
750 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";
751 $totalarray['nbfield']++;
752 }
753}
754// Extra fields
755include DOL_DOCUMENT_ROOT.'/core/tpl/extrafields_list_search_title.tpl.php';
756// Hook fields
757$parameters = array('arrayfields' => $arrayfields, 'param' => $param, 'sortfield' => $sortfield, 'sortorder' => $sortorder, 'totalarray' => &$totalarray);
758$reshook = $hookmanager->executeHooks('printFieldListTitle', $parameters, $object, $action); // Note that $action and $object may have been modified by hook
759print $hookmanager->resPrint;
760/*if (!empty($arrayfields['anotherfield']['checked'])) {
761 print '<th class="liste_titre">'.$langs->trans("AnotherField").'</th>';
762 $totalarray['nbfield']++;
763}*/
764// Action column
765if (!$conf->main_checkbox_left_column) {
766 print getTitleFieldOfList(($mode != 'kanban' ? $selectedfields : ''), 0, $_SERVER["PHP_SELF"], '', '', '', '', $sortfield, $sortorder, 'center maxwidthsearch ')."\n";
767 $totalarray['nbfield']++;
768}
769print '</tr>'."\n";
770
771// Detect if we need a fetch on each output line
772$needToFetchEachLine = 0;
773if (isset($extrafields->attributes[$object->table_element]['computed']) && is_array($extrafields->attributes[$object->table_element]['computed']) && count($extrafields->attributes[$object->table_element]['computed']) > 0) {
774 foreach ($extrafields->attributes[$object->table_element]['computed'] as $key => $val) {
775 if (!is_null($val) && preg_match('/\$object/', $val)) {
776 $needToFetchEachLine++; // There is at least one compute field that use $object
777 }
778 }
779}
780
781
782// Loop on record
783// --------------------------------------------------------------------
784$i = 0;
785$savnbfield = $totalarray['nbfield'];
786$totalarray = array();
787$totalarray['nbfield'] = 0;
788$imaxinloop = ($limit ? min($num, $limit) : $num);
789while ($i < $imaxinloop) {
790 $obj = $db->fetch_object($resql);
791 if (empty($obj)) {
792 break; // Should not happen
793 }
794
795 // Store properties in $object
796 $object->setVarsFromFetchObj($obj);
797
798 /*
799 $object->thirdparty = null;
800 if ($obj->fk_soc > 0) {
801 if (!empty($conf->cache['thirdparty'][$obj->fk_soc])) {
802 $companyobj = $conf->cache['thirdparty'][$obj->fk_soc];
803 } else {
804 $companyobj = new Societe($db);
805 $companyobj->fetch($obj->fk_soc);
806 $conf->cache['thirdparty'][$obj->fk_soc] = $companyobj;
807 }
808
809 $object->thirdparty = $companyobj;
810 }*/
811
812 if ($mode == 'kanban' || $mode == 'kanbangroupby') {
813 if ($i == 0) {
814 print '<tr class="trkanban"><td colspan="'.$savnbfield.'">';
815 print '<div class="box-flex-container kanban">';
816 }
817 // Output Kanban
818 $selected = -1;
819 if ($massactionbutton || $massaction) { // If we are in select mode (massactionbutton defined) or if we have already selected and sent an action ($massaction) defined
820 $selected = 0;
821 if (in_array($object->id, $arrayofselected)) {
822 $selected = 1;
823 }
824 }
825 //print $object->getKanbanView('', array('thirdparty'=>$object->thirdparty, 'selected' => $selected));
826 print $object->getKanbanView('', array('selected' => $selected));
827 if ($i == ($imaxinloop - 1)) {
828 print '</div>';
829 print '</td></tr>';
830 }
831 } else {
832 // Show line of result
833 $j = 0;
834 print '<tr data-rowid="'.$object->id.'" class="oddeven row-with-select">';
835
836 // Action column
837 if ($conf->main_checkbox_left_column) {
838 print '<td class="nowrap center">';
839 if ($massactionbutton || $massaction) { // If we are in select mode (massactionbutton defined) or if we have already selected and sent an action ($massaction) defined
840 $selected = 0;
841 if (in_array($object->id, $arrayofselected)) {
842 $selected = 1;
843 }
844 print '<input id="cb'.$object->id.'" class="flat checkforselect" type="checkbox" name="toselect[]" value="'.$object->id.'"'.($selected ? ' checked="checked"' : '').'>';
845 }
846 print '</td>';
847 if (!$i) {
848 $totalarray['nbfield']++;
849 }
850 }
851 // Fields
852 foreach ($object->fields as $key => $val) {
853 $cssforfield = (empty($val['csslist']) ? (empty($val['css']) ? '' : $val['css']) : $val['csslist']);
854 if (in_array($val['type'], array('date', 'datetime', 'timestamp'))) {
855 $cssforfield .= ($cssforfield ? ' ' : '').'center';
856 } elseif ($key == 'status') {
857 $cssforfield .= ($cssforfield ? ' ' : '').'center';
858 }
859
860 if (in_array($val['type'], array('timestamp'))) {
861 $cssforfield .= ($cssforfield ? ' ' : '').'nowraponall';
862 } elseif ($key == 'ref') {
863 $cssforfield .= ($cssforfield ? ' ' : '').'nowraponall';
864 }
865
866 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'])) {
867 $cssforfield .= ($cssforfield ? ' ' : '').'right';
868 }
869 //if (in_array($key, array('fk_soc', 'fk_user', 'fk_warehouse'))) $cssforfield = 'tdoverflowmax100';
870
871 if (!empty($arrayfields['t.'.$key]['checked'])) {
872 print '<td'.($cssforfield ? ' class="'.$cssforfield.((preg_match('/tdoverflow/', $cssforfield) && !in_array($val['type'], array('ip', 'url')) && !is_numeric($object->$key)) ? ' classfortooltip' : '').'"' : '');
873 if (preg_match('/tdoverflow/', $cssforfield) && !in_array($val['type'], array('ip', 'url')) && !is_numeric($object->$key) && !in_array($key, array('ref'))) {
874 print ' title="'.dol_escape_htmltag((string) $object->$key).'"';
875 }
876 print '>';
877 if ($key == 'status') {
878 print $object->getLibStatut(5);
879 } elseif ($key == 'rowid') {
880 print $object->showOutputField($val, $key, (string) $object->id, '');
881 } else {
882 if ($val['type'] == 'html') {
883 print '<div class="small lineheightsmall twolinesmax-normallineheight">';
884 }
885 print $object->showOutputField($val, $key, (string) $object->$key, '');
886 if ($val['type'] == 'html') {
887 print '</div>';
888 }
889 }
890 print '</td>';
891 if (!$i) {
892 $totalarray['nbfield']++;
893 }
894 if (!empty($val['isameasure']) && $val['isameasure'] == 1) {
895 if (!$i) {
896 $totalarray['pos'][$totalarray['nbfield']] = 't.'.$key;
897 }
898 if (!isset($totalarray['val'])) {
899 $totalarray['val'] = array();
900 }
901 if (!isset($totalarray['val']['t.'.$key])) {
902 $totalarray['val']['t.'.$key] = 0;
903 }
904 $totalarray['val']['t.'.$key] += $object->$key;
905 }
906 }
907 }
908 // Extra fields
909 include DOL_DOCUMENT_ROOT.'/core/tpl/extrafields_list_print_fields.tpl.php';
910 // Fields from hook
911 $parameters = array('arrayfields' => $arrayfields, 'object' => $object, 'obj' => $obj, 'i' => $i, 'totalarray' => &$totalarray);
912 $reshook = $hookmanager->executeHooks('printFieldListValue', $parameters, $object, $action); // Note that $action and $object may have been modified by hook
913 print $hookmanager->resPrint;
914
915 /*if (!empty($arrayfields['anotherfield']['checked'])) {
916 print '<td class="right">'.$obj->anotherfield.'</td>';
917 }*/
918
919 // Action column
920 if (empty($conf->main_checkbox_left_column)) {
921 print '<td class="nowrap center">';
922 if ($massactionbutton || $massaction) { // If we are in select mode (massactionbutton defined) or if we have already selected and sent an action ($massaction) defined
923 $selected = 0;
924 if (in_array($object->id, $arrayofselected)) {
925 $selected = 1;
926 }
927 print '<input id="cb'.$object->id.'" class="flat checkforselect" type="checkbox" name="toselect[]" value="'.$object->id.'"'.($selected ? ' checked="checked"' : '').'>';
928 }
929 print '</td>';
930 if (!$i) {
931 $totalarray['nbfield']++;
932 }
933 }
934
935 print '</tr>'."\n";
936 }
937
938 $i++;
939}
940
941// Show total line
942include DOL_DOCUMENT_ROOT.'/core/tpl/list_print_total.tpl.php';
943
944// If no record found
945if ($num == 0) {
946 $colspan = 1;
947 foreach ($arrayfields as $key => $val) {
948 if (!empty($val['checked'])) {
949 $colspan++;
950 }
951 }
952 print '<tr><td colspan="'.$colspan.'"><span class="opacitymedium">'.$langs->trans("NoRecordFound").'</span></td></tr>';
953}
954
955
956$db->free($resql);
957
958$parameters = array('arrayfields' => $arrayfields, 'sql' => $sql);
959$reshook = $hookmanager->executeHooks('printFieldListFooter', $parameters, $object, $action); // Note that $action and $object may have been modified by hook
960print $hookmanager->resPrint;
961
962print '</table>'."\n";
963print '</div>'."\n";
964
965print '</form>'."\n";
966
967if (in_array('builddoc', array_keys($arrayofmassactions)) && ($nbtotalofrecords === '' || $nbtotalofrecords)) {
968 $hidegeneratedfilelistifempty = 1;
969 if ($massaction == 'builddoc' || $action == 'remove_file' || $show_files) {
970 $hidegeneratedfilelistifempty = 0;
971 }
972
973 require_once DOL_DOCUMENT_ROOT.'/core/class/html.formfile.class.php';
974 $formfile = new FormFile($db);
975
976 // Show list of available documents
977 $urlsource = $_SERVER['PHP_SELF'].'?sortfield='.$sortfield.'&sortorder='.$sortorder;
978 $urlsource .= str_replace('&amp;', '&', $param);
979
980 $filedir = $diroutputmassaction;
981 $genallowed = $permissiontoread;
982 $delallowed = $permissiontoadd;
983
984 print $formfile->showdocuments('massfilesarea_'.$object->module, '', $filedir, $urlsource, $genallowed, $delallowed, '', 1, 1, 0, 48, 1, $param, $title, '', '', '', null, $hidegeneratedfilelistifempty);
985}
986
987// End of page
988llxFooter();
989$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 list.php:501
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.
if(!isModEnabled('ai')||!getDolGlobalString('AI_ASSISTANT_ENABLED')) global $conf
The main.inc.php has been included so the following variable are now defined:
if(!isModEnabled('ai')||!getDolGlobalString('AI_ASSISTANT_ENABLED')) global $db
API class for accounts.
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)
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...
GETPOST($paramname, $check='alphanohtml', $method=0, $filter=null, $options=null, $noreplace=0, $nodefault=0)
Return value of a param into GET or POST supervariable.
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.
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.
dol_print_error($db=null, $error='', $errors=null)
Displays error message system with all the information to facilitate the diagnosis and the escalation...
GETPOSTISSET($paramname)
Return true if we are in a context of submitting the parameter $paramname from a POST of a form.
isModEnabled($module)
Is Dolibarr module enabled.
dol_escape_htmltag($stringtoescape, $keepb=0, $keepn=0, $noescapetags='', $escapeonlyhtmltags=0, $cleanalsojavascript=0)
Returns text escaped for inclusion in HTML alt or title or value tags, or into values of HTML input f...
print $langs trans("Show") . '< td style="' . $timeColor . '" align="center"> s</td > badge status0 badge status4 badge status3 Error badge status8< td align="center">< span class="badge ' . $badge . '"></span ></td >< td align="center">< a href="#" class="button button-small" onclick="openLogModal(this)" data-req="' . dol_escape_htmltag($reqSafe) . '" data-res="' . dol_escape_htmltag($resSafe) . '" data-err="' . dol_escape_htmltag($errSafe) . '">< span class="fa fa-search-plus"></span ></a ></td ></tr >< tr >< td colspan="' . $colspan . '" class="opacitymedium"></td ></tr ></table ></div ></form > logModal none logModal none s a JSON string
buildzip.php
accessforbidden($message='', $printheader=1, $printfooter=1, $showonlymessage=0, $params=null)
Show a message to say access is forbidden and stop program.