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