dolibarr 21.0.0-beta
list.php
Go to the documentation of this file.
1<?php
2/* Copyright (C) 2016 Marcos García <marcosgdf@gmail.com>
3 * Copyright (C) 2022 Open-Dsi <support@open-dsi.fr>
4 * Copyright (C) 2024 MDW <mdeweerd@users.noreply.github.com>
5 * Copyright (C) 2024 Benjamin Falière <benjamin.faliere@altairis.fr>
6 * Copyright (C) 2024 Frédéric France <frederic.france@free.fr>
7 *
8 * This program is free software; you can redistribute it and/or modify
9 * it under the terms of the GNU General Public License as published by
10 * the Free Software Foundation; either version 3 of the License, or
11 * (at your option) any later version.
12 *
13 * This program is distributed in the hope that it will be useful,
14 * but WITHOUT ANY WARRANTY; without even the implied warranty of
15 * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the
16 * GNU General Public License for more details.
17 *
18 * You should have received a copy of the GNU General Public License
19 * along with this program. If not, see <https://www.gnu.org/licenses/>.
20 */
21
28// Load Dolibarr environment
29require '../main.inc.php';
30require_once DOL_DOCUMENT_ROOT.'/product/class/product.class.php';
31require_once DOL_DOCUMENT_ROOT.'/variants/class/ProductAttribute.class.php';
32
41// Load translation files required by the page
42$langs->loadLangs(array("products", "other"));
43
44$action = GETPOST('action', 'aZ09') ? GETPOST('action', 'aZ09') : 'view'; // The action 'create'/'add', 'edit'/'update', 'view', ...
45$massaction = GETPOST('massaction', 'alpha'); // The bulk action (combo box choice into lists)
46$show_files = GETPOSTINT('show_files'); // Show files area generated by bulk actions
47$confirm = GETPOST('confirm', 'alpha'); // Result of a confirmation
48$cancel = GETPOST('cancel', 'alpha'); // We click on a Cancel button
49$toselect = GETPOST('toselect', 'array:int'); // Array of ids of elements selected into a list
50$contextpage = GETPOST('contextpage', 'aZ') ? GETPOST('contextpage', 'aZ') : str_replace('_', '', basename(dirname(__FILE__)).basename(__FILE__, '.php')); // To manage different context of search
51$backtopage = GETPOST('backtopage', 'alpha'); // Go back to a dedicated page
52$optioncss = GETPOST('optioncss', 'aZ'); // Option for the css output (always '' except when 'print')
53$mode = GETPOST('mode', 'aZ'); // The display mode ('list', 'kanban', 'hierarchy', 'calendar', 'gantt', ...)
54
55$id = GETPOSTINT('id');
56
57// Load variable for pagination
58$limit = GETPOSTINT('limit') ? GETPOSTINT('limit') : $conf->liste_limit;
59$sortfield = GETPOST('sortfield', 'aZ09comma');
60$sortorder = GETPOST('sortorder', 'aZ09comma');
61$page = GETPOSTISSET('pageplusone') ? (GETPOSTINT('pageplusone') - 1) : GETPOSTINT('page');
62if (empty($page) || $page < 0 || GETPOST('button_search', 'alpha') || GETPOST('button_removefilter', 'alpha')) {
63 // If $page is not defined, or '' or -1 or if we click on clear filters
64 $page = 0;
65}
66$offset = $limit * $page;
67$pageprev = $page - 1;
68$pagenext = $page + 1;
69
70// Initialize a technical objects
71$object = new ProductAttribute($db);
72$extrafields = new ExtraFields($db);
73$diroutputmassaction = $conf->variants->dir_output.'/temp/massgeneration/'.$user->id;
74$hookmanager->initHooks(array('productattributelist')); // Note that conf->hooks_modules contains array
75
76// Fetch optionals attributes and labels
77$extrafields->fetch_name_optionals_label($object->table_element);
78
79$search_array_options = $extrafields->getOptionalsFromPost($object->table_element, '', 'search_');
80
81// Default sort order (if not yet defined by previous GETPOST)
82if (!$sortfield) {
83 $sortfield = "t.position"; // Set here default search field. By default 1st field in definition.
84}
85if (!$sortorder) {
86 $sortorder = "ASC";
87}
88
89// Initialize array of search criteria
90$search_all = trim(GETPOST('search_all', 'alphanohtml'));
91$search = array();
92foreach ($object->fields as $key => $val) {
93 if (GETPOST('search_'.$key, 'alpha') !== '') {
94 $search[$key] = GETPOST('search_'.$key, 'alpha');
95 }
96 if (preg_match('/^(date|timestamp|datetime)/', $val['type'])) {
97 $search[$key.'_dtstart'] = dol_mktime(0, 0, 0, GETPOSTINT('search_'.$key.'_dtstartmonth'), GETPOSTINT('search_'.$key.'_dtstartday'), GETPOSTINT('search_'.$key.'_dtstartyear'));
98 $search[$key.'_dtend'] = dol_mktime(23, 59, 59, GETPOSTINT('search_'.$key.'_dtendmonth'), GETPOSTINT('search_'.$key.'_dtendday'), GETPOSTINT('search_'.$key.'_dtendyear'));
99 }
100}
101$search['nb_of_values'] = GETPOST('search_nb_of_values', 'alpha');
102$search['nb_products'] = GETPOST('search_nb_products', 'alpha');
103
104$fieldstosearchall = array();
105// List of fields to search into when doing a "search in all"
106foreach ($object->fields as $key => $val) {
107 if (!empty($val['searchall'])) {
108 $fieldstosearchall['t.'.$key] = $val['label'];
109 }
110}
111$parameters = array('fieldstosearchall' => $fieldstosearchall);
112$reshook = $hookmanager->executeHooks('completeFieldsToSearchAll', $parameters, $object, $action); // Note that $action and $object may have been modified by some hooks
113if ($reshook > 0) {
114 $fieldstosearchall = empty($hookmanager->resArray['fieldstosearchall']) ? array() : $hookmanager->resArray['fieldstosearchall'];
115} elseif ($reshook == 0) {
116 $fieldstosearchall = array_merge($fieldstosearchall, empty($hookmanager->resArray['fieldstosearchall']) ? array() : $hookmanager->resArray['fieldstosearchall']);
117}
118
119// Definition of array of fields for columns
120$arrayfields = array();
121foreach ($object->fields as $key => $val) {
122 // If $val['visible']==0, then we never show the field
123 if (!empty($val['visible'])) {
124 $visible = (int) dol_eval((string) $val['visible'], 1);
125 $arrayfields['t.'.$key] = array(
126 'label' => $val['label'],
127 'checked' => (($visible < 0) ? 0 : 1),
128 'enabled' => (abs($visible) != 3 && (bool) dol_eval($val['enabled'], 1)),
129 'position' => $val['position'],
130 'help' => isset($val['help']) ? $val['help'] : ''
131 );
132 }
133}
134$arrayfields['nb_of_values'] = array(
135 'label' => $langs->trans('NbOfDifferentValues'),
136 'checked' => 1,
137 'enabled' => 1,
138 'position' => 40,
139 'help' => ''
140);
141$arrayfields['nb_products'] = array(
142 'label' => $langs->trans('NbProducts'),
143 'checked' => 1,
144 'enabled' => 1,
145 'position' => 50,
146 'help' => ''
147);
148// Extra fields
149include DOL_DOCUMENT_ROOT.'/core/tpl/extrafields_list_array_fields.tpl.php';
150
151$object->fields = dol_sort_array($object->fields, 'position');
152$arrayfields = dol_sort_array($arrayfields, 'position');
153'@phan-var-force array<string,array{label:string,checked?:int<0,1>,position?:int,help?:string}> $arrayfields'; // dol_sort_array looses type for Phan
154
155$permissiontoread = $user->hasRight('variants', 'read');
156$permissiontoadd = $user->hasRight('variants', 'write');
157$permissiontodelete = $user->hasRight('variants', 'delete');
158
159// Security check
160if (!isModEnabled('variants')) {
161 accessforbidden('Module not enabled');
162}
163$socid = 0;
164if ($user->socid > 0) { // Protection if external user
165 //$socid = $user->socid;
167}
168if (!$permissiontoread) {
170}
171
172
173/*
174 * Actions
175 */
176
177if (GETPOST('cancel', 'alpha')) {
178 $action = 'list';
179 $massaction = '';
180}
181if (!GETPOST('confirmmassaction', 'alpha') && $massaction != 'presend' && $massaction != 'confirm_presend') {
182 $massaction = '';
183}
184
185$parameters = array('arrayfields' => &$arrayfields);
186$reshook = $hookmanager->executeHooks('doActions', $parameters, $object, $action); // Note that $action and $object may have been modified by some hooks
187if ($reshook < 0) {
188 setEventMessages($hookmanager->error, $hookmanager->errors, 'errors');
189}
190
191if (empty($reshook)) {
192 // Selection of new fields
193 include DOL_DOCUMENT_ROOT.'/core/actions_changeselectedfields.inc.php';
194
195 // Purge search criteria
196 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
197 foreach ($object->fields as $key => $val) {
198 $search[$key] = '';
199 if (preg_match('/^(date|timestamp|datetime)/', $val['type'])) {
200 $search[$key.'_dtstart'] = '';
201 $search[$key.'_dtend'] = '';
202 }
203 }
204 $search['nb_of_values'] = '';
205 $search['nb_products'] = '';
206 $toselect = array();
207 $search_array_options = array();
208 }
209 if (GETPOST('button_removefilter_x', 'alpha') || GETPOST('button_removefilter.x', 'alpha') || GETPOST('button_removefilter', 'alpha')
210 || GETPOST('button_search_x', 'alpha') || GETPOST('button_search.x', 'alpha') || GETPOST('button_search', 'alpha')) {
211 $massaction = ''; // Protection to avoid mass action if we force a new search during a mass action confirmation
212 }
213
214 if ($action == 'up' && $permissiontoadd) {
215 $object->attributeMoveUp($rowid);
216
217 header('Location: '.$_SERVER['PHP_SELF']);
218 exit();
219 } elseif ($action == 'down' && $permissiontoadd) {
220 $object->attributeMoveDown($rowid);
221
222 header('Location: '.$_SERVER['PHP_SELF']);
223 exit();
224 }
225
226 // Mass actions
227 $objectclass = 'ProductAttribute';
228 $objectlabel = 'ProductAttribute';
229 $uploaddir = $conf->variants->dir_output;
230 include DOL_DOCUMENT_ROOT.'/core/actions_massactions.inc.php';
231}
232
233
234
235/*
236 * View
237 */
238
239$form = new Form($db);
240
241$now = dol_now();
242
243$title = $langs->trans("ProductAttributes");
244$help_url = '';
245$morejs = array();
246$morecss = array();
247
248
249// Build and execute select
250// --------------------------------------------------------------------
251$sql = "SELECT COUNT(DISTINCT pav.rowid) AS nb_of_values, COUNT(DISTINCT pac2v.fk_prod_combination) AS nb_products, ";
252$sql .= $object->getFieldList("t");
253// Add fields from extrafields
254if (!empty($extrafields->attributes[$object->table_element]['label'])) {
255 foreach ($extrafields->attributes[$object->table_element]['label'] as $key => $val) {
256 $sql .= ($extrafields->attributes[$object->table_element]['type'][$key] != 'separate' ? ", ef.".$key." as options_".$key : "");
257 }
258}
259// Add fields from hooks
260$parameters = array();
261$reshook = $hookmanager->executeHooks('printFieldListSelect', $parameters, $object, $action); // Note that $action and $object may have been modified by hook
262$sql .= $hookmanager->resPrint;
263$sql = preg_replace('/,\s*$/', '', $sql);
264
265$sqlfields = $sql; // $sql fields to remove for count total
266
267$sql .= " FROM ".MAIN_DB_PREFIX.$object->table_element." as t";
268if (isset($extrafields->attributes[$object->table_element]['label']) && is_array($extrafields->attributes[$object->table_element]['label']) && count($extrafields->attributes[$object->table_element]['label'])) {
269 $sql .= " LEFT JOIN ".MAIN_DB_PREFIX.$object->table_element."_extrafields as ef on (t.rowid = ef.fk_object)";
270}
271$sql .= " LEFT JOIN ".MAIN_DB_PREFIX."product_attribute_combination2val AS pac2v ON pac2v.fk_prod_attr = t.rowid";
272$sql .= " LEFT JOIN ".MAIN_DB_PREFIX."product_attribute_value AS pav ON pav.fk_product_attribute = t.rowid";
273// Add table from hooks
274$parameters = array();
275$reshook = $hookmanager->executeHooks('printFieldListFrom', $parameters, $object, $action); // Note that $action and $object may have been modified by hook
276$sql .= $hookmanager->resPrint;
277if ($object->ismultientitymanaged == 1) {
278 $sql .= " WHERE t.entity IN (".getEntity($object->element, (GETPOSTINT('search_current_entity') ? 0 : 1)).")";
279} else {
280 $sql .= " WHERE 1 = 1";
281}
282foreach ($search as $key => $val) {
283 if (array_key_exists($key, $object->fields)) {
284 if ($key == 'status' && $search[$key] == -1) {
285 continue;
286 }
287 $mode_search = (($object->isInt($object->fields[$key]) || $object->isFloat($object->fields[$key])) ? 1 : 0);
288 if ((strpos($object->fields[$key]['type'], 'integer:') === 0) || (strpos($object->fields[$key]['type'], 'sellist:') === 0) || !empty($object->fields[$key]['arrayofkeyval'])) {
289 if ($search[$key] == '-1' || ($search[$key] === '0' && (empty($object->fields[$key]['arrayofkeyval']) || !array_key_exists('0', $object->fields[$key]['arrayofkeyval'])))) {
290 $search[$key] = '';
291 }
292 $mode_search = 2;
293 }
294 if ($search[$key] != '') {
295 $sql .= natural_search("t.".$db->sanitize($key), $search[$key], (($key == 'status') ? 2 : $mode_search));
296 }
297 } else {
298 if (preg_match('/(_dtstart|_dtend)$/', $key) && $search[$key] != '') {
299 $columnName = preg_replace('/(_dtstart|_dtend)$/', '', $key);
300 if (preg_match('/^(date|timestamp|datetime)/', $object->fields[$columnName]['type'])) {
301 if (preg_match('/_dtstart$/', $key)) {
302 $sql .= " AND t.".$db->sanitize($columnName)." >= '".$db->idate($search[$key])."'";
303 }
304 if (preg_match('/_dtend$/', $key)) {
305 $sql .= " AND t.".$db->sanitize($columnName)." <= '".$db->idate($search[$key])."'";
306 }
307 }
308 }
309 }
310}
311if ($search_all) {
312 $sql .= natural_search(array_keys($fieldstosearchall), $search_all);
313}
314//$sql.= dolSqlDateFilter("t.field", $search_xxxday, $search_xxxmonth, $search_xxxyear);
315// Add where from extra fields
316include DOL_DOCUMENT_ROOT.'/core/tpl/extrafields_list_search_sql.tpl.php';
317// Add where from hooks
318$parameters = array();
319$reshook = $hookmanager->executeHooks('printFieldListWhere', $parameters, $object, $action); // Note that $action and $object may have been modified by hook
320$sql .= $hookmanager->resPrint;
321
322$hasgroupby = true;
323$sql .= " GROUP BY ";
324foreach ($object->fields as $key => $val) {
325 $sql .= "t.".$db->sanitize($key).", ";
326}
327// Add fields from extrafields
328if (!empty($extrafields->attributes[$object->table_element]['label'])) {
329 foreach ($extrafields->attributes[$object->table_element]['label'] as $key => $val) {
330 $sql .= ($extrafields->attributes[$object->table_element]['type'][$key] != 'separate' ? "ef.".$key.', ' : '');
331 }
332}
333// Add where from hooks
334$parameters = array();
335$reshook = $hookmanager->executeHooks('printFieldListGroupBy', $parameters, $object, $action); // Note that $action and $object may have been modified by hook
336$sql .= $hookmanager->resPrint;
337$sql = preg_replace("/,\s*$/", "", $sql);
338
339$sql .= " HAVING 1=1";
340if ($search['nb_of_values'] != '') {
341 $sql .= natural_search("nb_of_values", $search['nb_of_values'], 1);
342}
343if ($search['nb_products'] != '') {
344 $sql .= natural_search("nb_products", $search['nb_products'], 1);
345}
346// Add HAVING from hooks
347$parameters = array();
348$reshook = $hookmanager->executeHooks('printFieldListHaving', $parameters, $object, $action); // Note that $action and $object may have been modified by hook
349$sql .= empty($hookmanager->resPrint) ? "" : " ".$hookmanager->resPrint;
350
351// Count total nb of records
352$nbtotalofrecords = '';
353if (!getDolGlobalInt('MAIN_DISABLE_FULL_SCANLIST')) {
354 /* This old and fast method to get and count full list returns all record so use a high amount of memory.
355 $resql = $db->query($sql);
356 $nbtotalofrecords = $db->num_rows($resql);
357 */
358 /* The slow method does not consume memory on mysql (not tested on pgsql) */
359 /*$resql = $db->query($sql, 0, 'auto', 1);
360 while ($db->fetch_object($resql)) {
361 $nbtotalofrecords++;
362 }*/
363 /* The fast and low memory method to get and count full list converts the sql into a sql count */
364 $sqlforcount = preg_replace('/^'.preg_quote($sqlfields, '/').'/', 'SELECT COUNT(*) as nbtotalofrecords', $sql);
365 $sqlforcount = preg_replace('/GROUP BY .*$/', '', $sqlforcount);
366
367 $resql = $db->query($sqlforcount);
368 if ($resql) {
369 if ($hasgroupby) {
370 $nbtotalofrecords = $db->num_rows($resql);
371 } else {
372 $objforcount = $db->fetch_object($resql);
373 $nbtotalofrecords = $objforcount->nbtotalofrecords;
374 }
375 if (($page * $limit) > $nbtotalofrecords) { // if total resultset is smaller than the paging size (filtering), goto and load page 0
376 $page = 0;
377 $offset = 0;
378 }
379 $db->free($resql);
380 }
381}
382
383// Complete request and execute it with limit
384$sql .= $db->order($sortfield, $sortorder);
385if ($limit) {
386 $sql .= $db->plimit($limit + 1, $offset);
387}
388
389$resql = $db->query($sql);
390if (!$resql) {
391 dol_print_error($db);
392 exit;
393}
394
395$num = $db->num_rows($resql);
396
397
398// Direct jump if only one record found
399if ($num == 1 && getDolGlobalInt('MAIN_SEARCH_DIRECT_OPEN_IF_ONLY_ONE') && $search_all && !$page) {
400 $obj = $db->fetch_object($resql);
401 $id = $obj->rowid;
402 header("Location: " . dol_buildpath('/variants/card.php', 2) . '?id='.((int) $id));
403 exit;
404}
405
406
407// Output page
408// --------------------------------------------------------------------
409
410llxHeader('', $title, $help_url, '', 0, 0, $morejs, $morecss, '', 'bodyforlist');
411
412$arrayofselected = is_array($toselect) ? $toselect : array();
413
414$param = '';
415if (!empty($mode)) {
416 $param .= '&mode='.urlencode($mode);
417}
418if (!empty($contextpage) && $contextpage != $_SERVER["PHP_SELF"]) {
419 $param .= '&contextpage='.urlencode($contextpage);
420}
421if ($limit > 0 && $limit != $conf->liste_limit) {
422 $param .= '&limit='.((int) $limit);
423}
424if ($optioncss != '') {
425 $param .= '&optioncss='.urlencode($optioncss);
426}
427/*
428if ($groupby != '') {
429 $param .= '&groupby='.urlencode($groupby);
430}
431*/
432foreach ($search as $key => $val) {
433 if (is_array($search[$key])) {
434 foreach ($search[$key] as $skey) {
435 if ($skey != '') {
436 $param .= '&search_'.$key.'[]='.urlencode($skey);
437 }
438 }
439 } elseif (preg_match('/(_dtstart|_dtend)$/', $key) && !empty($val)) {
440 $param .= '&search_'.$key.'month='.(GETPOSTINT('search_'.$key.'month'));
441 $param .= '&search_'.$key.'day='.(GETPOSTINT('search_'.$key.'day'));
442 $param .= '&search_'.$key.'year='.(GETPOSTINT('search_'.$key.'year'));
443 } elseif ($search[$key] != '') {
444 $param .= '&search_'.$key.'='.urlencode($search[$key]);
445 }
446}
447// Add $param from extra fields
448include DOL_DOCUMENT_ROOT.'/core/tpl/extrafields_list_search_param.tpl.php';
449// Add $param from hooks
450$parameters = array('param' => &$param);
451$reshook = $hookmanager->executeHooks('printFieldListSearchParam', $parameters, $object, $action); // Note that $action and $object may have been modified by hook
452$param .= $hookmanager->resPrint;
453
454// List of mass actions available
455$arrayofmassactions = array(
456 //'validate'=>img_picto('', 'check', 'class="pictofixedwidth"').$langs->trans("Validate"),
457 //'generate_doc'=>img_picto('', 'pdf', 'class="pictofixedwidth"').$langs->trans("ReGeneratePDF"),
458 //'builddoc'=>img_picto('', 'pdf', 'class="pictofixedwidth"').$langs->trans("PDFMerge"),
459 //'presend'=>img_picto('', 'email', 'class="pictofixedwidth"').$langs->trans("SendByMail"),
460);
461if (!empty($permissiontodelete)) {
462 $arrayofmassactions['predelete'] = img_picto('', 'delete', 'class="pictofixedwidth"').$langs->trans("Delete");
463}
464if (GETPOSTINT('nomassaction') || in_array($massaction, array('presend', 'predelete'))) {
465 $arrayofmassactions = array();
466}
467$massactionbutton = $form->selectMassAction('', $arrayofmassactions);
468
469print '<form method="POST" id="searchFormList" action="'.$_SERVER["PHP_SELF"].'">'."\n";
470if ($optioncss != '') {
471 print '<input type="hidden" name="optioncss" value="'.$optioncss.'">';
472}
473print '<input type="hidden" name="token" value="'.newToken().'">';
474print '<input type="hidden" name="formfilteraction" id="formfilteraction" value="list">';
475print '<input type="hidden" name="action" value="list">';
476print '<input type="hidden" name="sortfield" value="'.$sortfield.'">';
477print '<input type="hidden" name="sortorder" value="'.$sortorder.'">';
478print '<input type="hidden" name="page" value="'.$page.'">';
479print '<input type="hidden" name="contextpage" value="'.$contextpage.'">';
480print '<input type="hidden" name="page_y" value="">';
481print '<input type="hidden" name="mode" value="'.$mode.'">';
482
483$newcardbutton = '';
484$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'));
485$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'));
486$newcardbutton .= dolGetButtonTitleSeparator();
487$newcardbutton .= dolGetButtonTitle($langs->trans('New'), '', 'fa fa-plus-circle', DOL_URL_ROOT.'/variants/card.php?action=create&backtopage='.urlencode($_SERVER['PHP_SELF']), '', $permissiontoadd);
488
489print_barre_liste($title, $page, $_SERVER["PHP_SELF"], $param, $sortfield, $sortorder, $massactionbutton, $num, $nbtotalofrecords, 'object_'.$object->picto, 0, $newcardbutton, '', $limit, 0, 0, 1);
490
491// Add code for pre mass action (confirmation or email presend form)
492$topicmail = "SendProductAttributeRef";
493$modelmail = "productattribute";
494$objecttmp = new ProductAttribute($db);
495$trackid = 'pa'.$object->id;
496include DOL_DOCUMENT_ROOT.'/core/tpl/massactions_pre.tpl.php';
497
498if ($search_all) {
499 $setupstring = '';
500 foreach ($fieldstosearchall as $key => $val) {
501 $fieldstosearchall[$key] = $langs->trans($val);
502 $setupstring .= $key."=".$val.";";
503 }
504 print '<!-- Search done like if MYOBJECT_QUICKSEARCH_ON_FIELDS = '.$setupstring.' -->'."\n";
505 print '<div class="divsearchfieldfilter">'.$langs->trans("FilterOnInto", $search_all).implode(', ', $fieldstosearchall).'</div>'."\n";
506}
507
508$moreforfilter = '';
509/*$moreforfilter.='<div class="divsearchfield">';
510$moreforfilter.= $langs->trans('MyFilter') . ': <input type="text" name="search_myfield" value="'.dol_escape_htmltag($search_myfield).'">';
511$moreforfilter.= '</div>';*/
512
513$parameters = array();
514$reshook = $hookmanager->executeHooks('printFieldPreListTitle', $parameters, $object, $action); // Note that $action and $object may have been modified by hook
515if (empty($reshook)) {
516 $moreforfilter .= $hookmanager->resPrint;
517} else {
518 $moreforfilter = $hookmanager->resPrint;
519}
520
521if (!empty($moreforfilter)) {
522 print '<div class="liste_titre liste_titre_bydiv centpercent">';
523 print $moreforfilter;
524 print '</div>';
525}
526
527$varpage = empty($contextpage) ? $_SERVER["PHP_SELF"] : $contextpage;
528$htmlofselectarray = $form->multiSelectArrayWithCheckbox('selectedfields', $arrayfields, $varpage, getDolGlobalString('MAIN_CHECKBOX_LEFT_COLUMN')); // This also change content of $arrayfields with user setup
529$selectedfields = ($mode != 'kanban' ? $htmlofselectarray : '');
530$selectedfields .= (count($arrayofmassactions) ? $form->showCheckAddButtons('checkforselect', 1) : '');
531
532print '<div class="div-table-responsive">'; // You can use div-table-responsive-no-min if you don't need reserved height for your table
533print '<table id="tableattributes" class="tagtable nobottomiftotal liste'.($moreforfilter ? " listwithfilterbefore" : "").'">'."\n";
534
535
536// Fields title search
537// --------------------------------------------------------------------
538print '<tr class="liste_titre_filter nodrag nodrop">';
539// Action column
540if (getDolGlobalString('MAIN_CHECKBOX_LEFT_COLUMN')) {
541 print '<td class="liste_titre center maxwidthsearch">';
542 $searchpicto = $form->showFilterButtons('left');
543 print $searchpicto;
544 print '</td>';
545}
546foreach ($object->fields as $key => $val) {
547 //$searchkey = empty($search[$key]) ? '' : $search[$key];
548 $cssforfield = (empty($val['csslist']) ? (empty($val['css']) ? '' : $val['css']) : $val['csslist']);
549 if ($key == 'status') {
550 $cssforfield .= ($cssforfield ? ' ' : '').'center';
551 } elseif (in_array($val['type'], array('date', 'datetime', 'timestamp'))) {
552 $cssforfield .= ($cssforfield ? ' ' : '').'center';
553 } elseif (in_array($val['type'], array('timestamp'))) {
554 $cssforfield .= ($cssforfield ? ' ' : '').'nowrap';
555 } 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'])) {
556 $cssforfield .= ($cssforfield ? ' ' : '').'right';
557 }
558 if (!empty($arrayfields['t.'.$key]['checked'])) {
559 print '<td class="liste_titre'.($cssforfield ? ' '.$cssforfield : '').($key == 'status' ? ' parentonrightofpage' : '').'">';
560 if (!empty($val['arrayofkeyval']) && is_array($val['arrayofkeyval'])) {
561 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);
562 } elseif ((strpos($val['type'], 'integer:') === 0) || (strpos($val['type'], 'sellist:') === 0)) {
563 print $object->showInputField($val, $key, (isset($search[$key]) ? $search[$key] : ''), '', '', 'search_', $cssforfield.' maxwidth250', 1);
564 } elseif (preg_match('/^(date|timestamp|datetime)/', $val['type'])) {
565 print '<div class="nowrap">';
566 print $form->selectDate($search[$key.'_dtstart'] ? $search[$key.'_dtstart'] : '', "search_".$key."_dtstart", 0, 0, 1, '', 1, 0, 0, '', '', '', '', 1, '', $langs->trans('From'));
567 print '</div>';
568 print '<div class="nowrap">';
569 print $form->selectDate($search[$key.'_dtend'] ? $search[$key.'_dtend'] : '', "search_".$key."_dtend", 0, 0, 1, '', 1, 0, 0, '', '', '', '', 1, '', $langs->trans('to'));
570 print '</div>';
571 } elseif ($key == 'lang') {
572 require_once DOL_DOCUMENT_ROOT.'/core/class/html.formadmin.class.php';
573 $formadmin = new FormAdmin($db);
574 print $formadmin->select_language((isset($search[$key]) ? $search[$key] : ''), 'search_lang', 0, array(), 1, 0, 0, 'minwidth100imp maxwidth125', 2);
575 } else {
576 print '<input type="text" class="flat maxwidth'.($val['type'] == 'integer' ? '50' : '75').'" name="search_'.$key.'" value="'.dol_escape_htmltag(isset($search[$key]) ? $search[$key] : '').'">';
577 }
578 print '</td>';
579 }
580}
581// Extra fields
582include DOL_DOCUMENT_ROOT.'/core/tpl/extrafields_list_search_input.tpl.php';
583// Fields from hook
584$parameters = array('arrayfields' => $arrayfields);
585$reshook = $hookmanager->executeHooks('printFieldListOption', $parameters, $object, $action); // Note that $action and $object may have been modified by hook
586print $hookmanager->resPrint;
587
588$key = 'nb_of_values';
589if (!empty($arrayfields[$key]['checked'])) {
590 print '<td class="liste_titre center">';
591 print '<input type="text" class="flat maxwidth'.($val['type'] == 'integer' ? '50' : '75').'" name="search_'.$key.'" value="'.dol_escape_htmltag(isset($search[$key]) ? $search[$key] : '').'">';
592 print '</td>';
593}
594$key = 'nb_products';
595if (!empty($arrayfields[$key]['checked'])) {
596 print '<td class="liste_titre center">';
597 print '<input type="text" class="flat maxwidth'.($val['type'] == 'integer' ? '50' : '75').'" name="search_'.$key.'" value="'.dol_escape_htmltag(isset($search[$key]) ? $search[$key] : '').'">';
598 print '</td>';
599}
600// Action column
601if (!getDolGlobalString('MAIN_CHECKBOX_LEFT_COLUMN')) {
602 print '<td class="liste_titre center maxwidthsearch">';
603 $searchpicto = $form->showFilterButtons();
604 print $searchpicto;
605 print '</td>';
606}
607// Move
608print '<td class="liste_titre linecolmove width25"></td>';
609print '</tr>'."\n";
610
611$totalarray = array();
612$totalarray['nbfield'] = 0;
613
614// Fields title label
615// --------------------------------------------------------------------
616print '<tr class="liste_titre nodrag nodrop">';
617// Action column
618if (getDolGlobalString('MAIN_CHECKBOX_LEFT_COLUMN')) {
619 print getTitleFieldOfList($selectedfields, 0, $_SERVER["PHP_SELF"], '', '', '', '', $sortfield, $sortorder, 'center maxwidthsearch ')."\n";
620 $totalarray['nbfield']++;
621}
622foreach ($object->fields as $key => $val) {
623 $cssforfield = (empty($val['csslist']) ? (empty($val['css']) ? '' : $val['css']) : $val['csslist']);
624 if ($key == 'status') {
625 $cssforfield .= ($cssforfield ? ' ' : '').'center';
626 } elseif (in_array($val['type'], array('date', 'datetime', 'timestamp'))) {
627 $cssforfield .= ($cssforfield ? ' ' : '').'center';
628 } elseif (in_array($val['type'], array('timestamp'))) {
629 $cssforfield .= ($cssforfield ? ' ' : '').'nowrap';
630 } 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'])) {
631 $cssforfield .= ($cssforfield ? ' ' : '').'right';
632 }
633 $cssforfield = preg_replace('/small\s*/', '', $cssforfield); // the 'small' css must not be used for the title label
634 if (!empty($arrayfields['t.'.$key]['checked'])) {
635 print getTitleFieldOfList($arrayfields['t.'.$key]['label'], 0, $_SERVER['PHP_SELF'], 't.'.$key, '', $param, '', $sortfield, $sortorder, ($cssforfield ? $cssforfield.' ' : ''), 0, (empty($val['helplist']) ? '' : $val['helplist']))."\n";
636 $totalarray['nbfield']++;
637 }
638}
639// Extra fields
640include DOL_DOCUMENT_ROOT.'/core/tpl/extrafields_list_search_title.tpl.php';
641// Hook fields
642$parameters = array('arrayfields' => $arrayfields, 'param' => $param, 'sortfield' => $sortfield, 'sortorder' => $sortorder, 'totalarray' => &$totalarray);
643$reshook = $hookmanager->executeHooks('printFieldListTitle', $parameters, $object, $action); // Note that $action and $object may have been modified by hook
644print $hookmanager->resPrint;
645
646$key = 'nb_of_values';
647if (!empty($arrayfields[$key]['checked'])) {
648 // @phan-suppress-next-line PhanTypeInvalidDimOffset
649 print getTitleFieldOfList($arrayfields[$key]['label'], 0, $_SERVER['PHP_SELF'], $key, '', $param, 'class="center"', $sortfield, $sortorder, 'center ')."\n";
650 $totalarray['nbfield']++;
651}
652$key = 'nb_products';
653if (!empty($arrayfields[$key]['checked'])) {
654 print getTitleFieldOfList($arrayfields[$key]['label'], 0, $_SERVER['PHP_SELF'], $key, '', $param, 'class="center"', $sortfield, $sortorder, 'center ')."\n";
655 $totalarray['nbfield']++;
656}
657// Action column
658if (!getDolGlobalString('MAIN_CHECKBOX_LEFT_COLUMN')) {
659 print getTitleFieldOfList($selectedfields, 0, $_SERVER["PHP_SELF"], '', '', '', '', $sortfield, $sortorder, 'center maxwidthsearch ')."\n";
660 $totalarray['nbfield']++;
661}
662// Move
663print getTitleFieldOfList('', 0, '', '', '', '', '', '', '', 'linecolmove ')."\n";
664$totalarray['nbfield']++;
665print '</tr>'."\n";
666
667
668// Detect if we need a fetch on each output line
669$needToFetchEachLine = 0;
670//if (isset($extrafields->attributes[$object->table_element]['computed']) && is_array($extrafields->attributes[$object->table_element]['computed']) && count($extrafields->attributes[$object->table_element]['computed']) > 0) {
671// foreach ($extrafields->attributes[$object->table_element]['computed'] as $key => $val) {
672// if (!is_null($val) && preg_match('/\$object/', $val)) {
673// $needToFetchEachLine++; // There is at least one compute field that use $object
674// }
675// }
676//}
677
678
679// Loop on record
680// --------------------------------------------------------------------
681$i = 0;
682$savnbfield = $totalarray['nbfield'];
683$totalarray = array();
684$totalarray['nbfield'] = 0;
685$imaxinloop = ($limit ? min($num, $limit) : $num);
686while ($i < $imaxinloop) {
687 $obj = $db->fetch_object($resql);
688 if (empty($obj)) {
689 break; // Should not happen
690 }
691
692 // Store properties in $object
693 $object->setVarsFromFetchObj($obj);
694 $object->fetch_optionals();
695
696 if ($mode == 'kanban') {
697 if ($i == 0) {
698 print '<tr class="trkanban"><td colspan="'.$savnbfield.'">';
699 print '<div class="box-flex-container kanban">';
700 }
701 // Output Kanban
702 $selected = -1;
703 if ($massactionbutton || $massaction) { // If we are in select mode (massactionbutton defined) or if we have already selected and sent an action ($massaction) defined
704 $selected = 0;
705 if (in_array($object->id, $arrayofselected)) {
706 $selected = 1;
707 }
708 }
709 print $object->getKanbanView('', array('selected' => $selected));
710 if ($i == ($imaxinloop - 1)) {
711 print '</div>';
712 print '</td></tr>';
713 }
714 } else {
715 // Show line of result
716 $j = 0;
717 print '<tr data-rowid="'.$object->id.'" class="oddeven">';
718 // Action column
719 if (getDolGlobalString('MAIN_CHECKBOX_LEFT_COLUMN')) {
720 print '<td class="nowrap center">';
721 if ($massactionbutton || $massaction) { // If we are in select mode (massactionbutton defined) or if we have already selected and sent an action ($massaction) defined
722 $selected = 0;
723 if (in_array($object->id, $arrayofselected)) {
724 $selected = 1;
725 }
726 print '<input id="cb'.$object->id.'" class="flat checkforselect" type="checkbox" name="toselect[]" value="'.$object->id.'"'.($selected ? ' checked="checked"' : '').'>';
727 }
728 print '</td>';
729 if (!$i) {
730 $totalarray['nbfield']++;
731 }
732 }
733 // Fields
734 foreach ($object->fields as $key => $val) {
735 $cssforfield = (empty($val['csslist']) ? (empty($val['css']) ? '' : $val['css']) : $val['csslist']);
736 if (in_array($val['type'], array('date', 'datetime', 'timestamp'))) {
737 $cssforfield .= ($cssforfield ? ' ' : '') . 'center';
738 } elseif ($key == 'status') {
739 $cssforfield .= ($cssforfield ? ' ' : '') . 'center';
740 }
741
742 if (in_array($val['type'], array('timestamp'))) {
743 $cssforfield .= ($cssforfield ? ' ' : '') . 'nowraponall';
744 } elseif ($key == 'ref') {
745 $cssforfield .= ($cssforfield ? ' ' : '') . 'nowraponall';
746 }
747
748 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'])) {
749 $cssforfield .= ($cssforfield ? ' ' : '') . 'right';
750 }
751 //if (in_array($key, array('fk_soc', 'fk_user', 'fk_warehouse'))) $cssforfield = 'tdoverflowmax100';
752
753 if (!empty($arrayfields['t.' . $key]['checked'])) {
754 print '<td'.($cssforfield ? ' class="'.$cssforfield.((preg_match('/tdoverflow/', $cssforfield) && !in_array($val['type'], array('ip', 'url')) && !is_numeric($object->$key)) ? ' classfortooltip' : '').'"' : '');
755 if (preg_match('/tdoverflow/', $cssforfield) && !in_array($val['type'], array('ip', 'url')) && !is_numeric($object->$key)) {
756 print ' title="'.dol_escape_htmltag($object->$key).'"';
757 }
758 print '>';
759 if ($key == 'status') {
760 print $object->getLibStatut(5);
761 } elseif ($key == 'rowid') {
762 print $object->showOutputField($val, $key, $object->id, '');
763 } else {
764 print $object->showOutputField($val, $key, $object->$key, '');
765 }
766 print '</td>';
767 if (!$i) {
768 $totalarray['nbfield']++;
769 }
770 if (!empty($val['isameasure']) && $val['isameasure'] == 1) {
771 if (!$i) {
772 $totalarray['pos'][$totalarray['nbfield']] = 't.' . $key;
773 }
774 if (!isset($totalarray['val'])) {
775 $totalarray['val'] = array();
776 }
777 if (!isset($totalarray['val']['t.' . $key])) {
778 $totalarray['val']['t.' . $key] = 0;
779 }
780 $totalarray['val']['t.' . $key] += $object->$key;
781 }
782 }
783 }
784 // Extra fields
785 include DOL_DOCUMENT_ROOT.'/core/tpl/extrafields_list_print_fields.tpl.php';
786 // Fields from hook
787 $parameters = array('arrayfields' => $arrayfields, 'object' => $object, 'obj' => $obj, 'i' => $i, 'totalarray' => &$totalarray);
788 $reshook = $hookmanager->executeHooks('printFieldListValue', $parameters, $object, $action); // Note that $action and $object may have been modified by hook
789 print $hookmanager->resPrint;
790 // Other
791 $key = 'nb_of_values';
792 if (!empty($arrayfields[$key]['checked'])) {
793 print '<td class="center">';
794 print $obj->$key;
795 print '</td>';
796 if (!$i) {
797 $totalarray['nbfield']++;
798 }
799 }
800 $key = 'nb_products';
801 if (!empty($arrayfields[$key]['checked'])) {
802 print '<td class="center">';
803 print $obj->$key;
804 print '</td>';
805 if (!$i) {
806 $totalarray['nbfield']++;
807 }
808 }
809 // Action column
810 if (!getDolGlobalString('MAIN_CHECKBOX_LEFT_COLUMN')) {
811 print '<td class="nowrap center">';
812 if ($massactionbutton || $massaction) { // If we are in select mode (massactionbutton defined) or if we have already selected and sent an action ($massaction) defined
813 $selected = 0;
814 if (in_array($object->id, $arrayofselected)) {
815 $selected = 1;
816 }
817 print '<input id="cb'.$object->id.'" class="flat checkforselect" type="checkbox" name="toselect[]" value="'.$object->id.'"'.($selected ? ' checked="checked"' : '').'>';
818 }
819 print '</td>';
820 if (!$i) {
821 $totalarray['nbfield']++;
822 }
823 }
824 // Move
825 print '<td class="center linecolmove tdlineupdown">';
826 if ($i > 0) {
827 print '<a class="lineupdown" href="' . $_SERVER['PHP_SELF'] . '?action=up&amp;rowid=' . $obj->rowid . '">' . img_up('default', 0, 'imgupforline') . '</a>';
828 }
829 if ($i < $num - 1) {
830 print '<a class="lineupdown" href="' . $_SERVER['PHP_SELF'] . '?action=down&amp;rowid=' . $obj->rowid . '">' . img_down('default', 0, 'imgdownforline') . '</a>';
831 }
832 print '</td>';
833 if (!$i) {
834 $totalarray['nbfield']++;
835 }
836
837 print '</tr>' . "\n";
838 }
839
840 $i++;
841}
842
843// Show total line
844include DOL_DOCUMENT_ROOT.'/core/tpl/list_print_total.tpl.php';
845
846// If no record found
847if ($num == 0) {
848 $colspan = 1;
849 foreach ($arrayfields as $key => $val) {
850 if (!empty($val['checked'])) {
851 $colspan++;
852 }
853 }
854 $colspan++; // For the move column
855 print '<tr><td colspan="'.$colspan.'"><span class="opacitymedium">'.$langs->trans("NoRecordFound").'</span></td></tr>';
856}
857
858$db->free($resql);
859
860$parameters = array('arrayfields' => $arrayfields, 'sql' => $sql);
861$reshook = $hookmanager->executeHooks('printFieldListFooter', $parameters, $object, $action); // Note that $action and $object may have been modified by hook
862print $hookmanager->resPrint;
863
864print '</table>'."\n";
865print '</div>'."\n";
866
867print '</form>'."\n";
868
869$forcereloadpage = getDolGlobalString('MAIN_FORCE_RELOAD_PAGE') ? 1 : 0;
870$tagidfortablednd = (empty($tagidfortablednd) ? 'tableattributes' : $tagidfortablednd);
871?>
872 <script>
873 $(document).ready(function(){
874 $(".imgupforline, .imgdownforline").hide();
875 $(".lineupdown").removeAttr('href');
876 $(".tdlineupdown")
877 .css("background-image", 'url(<?php echo DOL_URL_ROOT.'/theme/'.$conf->theme.'/img/grip.png'; ?>)')
878 .css("background-repeat", "no-repeat")
879 .css("background-position", "center center")
880 .hover(
881 function () {
882 $(this).addClass('showDragHandle');
883 }, function () {
884 $(this).removeClass('showDragHandle');
885 }
886 );
887
888 $("#<?php echo $tagidfortablednd; ?>").tableDnD({
889 onDrop: function(table, row) {
890 console.log('drop');
891 $('#<?php echo $tagidfortablednd; ?> tr[data-element=extrafield]').attr('id', ''); // Set extrafields id to empty value in order to ignore them in tableDnDSerialize function
892 $('#<?php echo $tagidfortablednd; ?> tr[data-ignoreidfordnd=1]').attr('id', ''); // Set id to empty value in order to ignore them in tableDnDSerialize function
893 var reloadpage = "<?php echo $forcereloadpage; ?>";
894 var roworder = cleanSerialize(decodeURI($("#<?php echo $tagidfortablednd; ?>").tableDnDSerialize()));
895 $.post("<?php echo DOL_URL_ROOT; ?>/variants/ajax/orderAttribute.php",
896 {
897 roworder: roworder,
898 token: "<?php echo currentToken(); ?>"
899 },
900 function() {
901 if (reloadpage == 1) {
902 location.href = '<?php echo dol_escape_htmltag($_SERVER['PHP_SELF']).'?'.dol_escape_htmltag($_SERVER['QUERY_STRING']); ?>';
903 }
904 });
905 },
906 onDragClass: "dragClass",
907 dragHandle: "td.tdlineupdown"
908 });
909 });
910 </script>
911<?php
912
913if (in_array('builddoc', array_keys($arrayofmassactions)) && ($nbtotalofrecords === '' || $nbtotalofrecords)) {
914 $hidegeneratedfilelistifempty = 1;
915 if ($massaction == 'builddoc' || $action == 'remove_file' || $show_files) {
916 $hidegeneratedfilelistifempty = 0;
917 }
918
919 require_once DOL_DOCUMENT_ROOT.'/core/class/html.formfile.class.php';
920 $formfile = new FormFile($db);
921
922 // Show list of available documents
923 $urlsource = $_SERVER['PHP_SELF'].'?sortfield='.$sortfield.'&sortorder='.$sortorder;
924 $urlsource .= str_replace('&amp;', '&', $param);
925
926 $filedir = $diroutputmassaction;
927 $genallowed = $permissiontoread;
928 $delallowed = $permissiontoadd;
929
930 print $formfile->showdocuments('massfilesarea_productattribute', '', $filedir, $urlsource, 0, $delallowed, '', 1, 1, 0, 48, 1, $param, $title, '', '', '', null, $hidegeneratedfilelistifempty);
931}
932
933// End of page
934llxFooter();
935$db->close();
$id
Definition account.php:48
if( $user->socid > 0) if(! $user->hasRight('accounting', 'chartofaccount')) $object
Definition card.php:66
if(!defined('NOREQUIRESOC')) if(!defined( 'NOREQUIRETRAN')) if(!defined('NOTOKENRENEWAL')) if(!defined( 'NOREQUIREMENU')) if(!defined('NOREQUIREHTML')) if(!defined( 'NOREQUIREAJAX')) llxHeader($head='', $title='', $help_url='', $target='', $disablejs=0, $disablehead=0, $arrayofjs='', $arrayofcss='', $morequerystring='', $morecssonbody='', $replacemainareaby='', $disablenofollow=0, $disablenoindex=0)
Empty header.
Definition wrapper.php:71
Class 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 ProductAttribute Used to represent a Product attribute Examples:
llxFooter()
Footer empty.
Definition document.php:107
dol_mktime($hour, $minute, $second, $month, $day, $year, $gm='auto', $check=1)
Return a timestamp date built from detailed information (by default a local PHP server timestamp) Rep...
setEventMessages($mesg, $mesgs, $style='mesgs', $messagekey='', $noduplicate=0, $attop=0)
Set event messages in dol_events session object.
print_barre_liste($title, $page, $file, $options='', $sortfield='', $sortorder='', $morehtmlcenter='', $num=-1, $totalnboflines='', $picto='generic', $pictoisfullpath=0, $morehtmlright='', $morecss='', $limit=-1, $selectlimitsuffix=0, $hidenavigation=0, $pagenavastextinput=0, $morehtmlrightbeforearrow='')
Print a title with navigation controls for pagination.
img_picto($titlealt, $picto, $moreatt='', $pictoisfullpath=0, $srconly=0, $notitle=0, $alt='', $morecss='', $marginleftonlyshort=2)
Show picto whatever it's its name (generic function)
GETPOSTINT($paramname, $method=0)
Return the value of a $_GET or $_POST supervariable, converted into integer.
dolGetButtonTitle($label, $helpText='', $iconClass='fa fa-file', $url='', $id='', $status=1, $params=array())
Function dolGetButtonTitle : this kind of buttons are used in title in list.
dol_eval($s, $returnvalue=1, $hideerrors=1, $onlysimplestring='1')
Replace eval function to add more security.
natural_search($fields, $value, $mode=0, $nofirstand=0)
Generate natural SQL search string for a criteria (this criteria can be tested on one or several fiel...
img_down($titlealt='default', $selected=0, $moreclass='')
Show down arrow logo.
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.
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...
getDolGlobalString($key, $default='')
Return a Dolibarr global constant string value.
img_up($titlealt='default', $selected=0, $moreclass='')
Show top arrow logo.
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...
treeview li table
No Email.
global $conf
The following vars must be defined: $type2label $form $conf, $lang, The following vars may also be de...
Definition member.php:79
accessforbidden($message='', $printheader=1, $printfooter=1, $showonlymessage=0, $params=null)
Show a message to say access is forbidden and stop program.