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