dolibarr 20.0.0
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 $parameters = array();
511 $reshook = $hookmanager->executeHooks('printFieldPreListTitle', $parameters, $object, $action); // Note that $action and $object may have been modified by hook
512 print $hookmanager->resPrint;
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">';
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 $cssforfield = (empty($val['csslist']) ? (empty($val['css']) ? '' : $val['css']) : $val['csslist']);
537 if ($key == 'status') {
538 $cssforfield .= ($cssforfield ? ' ' : '').'center';
539 } elseif (in_array($val['type'], array('date', 'datetime', 'timestamp'))) {
540 $cssforfield .= ($cssforfield ? ' ' : '').'center';
541 } elseif (in_array($val['type'], array('timestamp'))) {
542 $cssforfield .= ($cssforfield ? ' ' : '').'nowrap';
543 } 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'])) {
544 $cssforfield .= ($cssforfield ? ' ' : '').'right';
545 }
546 if (!empty($arrayfields['t.'.$key]['checked'])) {
547 print '<td class="liste_titre'.($cssforfield ? ' '.$cssforfield : '').($key == 'status' ? ' parentonrightofpage' : '').'">';
548 if (!empty($val['arrayofkeyval']) && is_array($val['arrayofkeyval'])) {
549 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);
550 } elseif ((strpos($val['type'], 'integer:') === 0) || (strpos($val['type'], 'sellist:') === 0)) {
551 print $object->showInputField($val, $key, (isset($search[$key]) ? $search[$key] : ''), '', '', 'search_', $cssforfield.' maxwidth250', 1);
552 } elseif (preg_match('/^(date|timestamp|datetime)/', $val['type'])) {
553 print '<div class="nowrap">';
554 print $form->selectDate($search[$key.'_dtstart'] ? $search[$key.'_dtstart'] : '', "search_".$key."_dtstart", 0, 0, 1, '', 1, 0, 0, '', '', '', '', 1, '', $langs->trans('From'));
555 print '</div>';
556 print '<div class="nowrap">';
557 print $form->selectDate($search[$key.'_dtend'] ? $search[$key.'_dtend'] : '', "search_".$key."_dtend", 0, 0, 1, '', 1, 0, 0, '', '', '', '', 1, '', $langs->trans('to'));
558 print '</div>';
559 } elseif ($key == 'lang') {
560 require_once DOL_DOCUMENT_ROOT.'/core/class/html.formadmin.class.php';
561 $formadmin = new FormAdmin($db);
562 print $formadmin->select_language((isset($search[$key]) ? $search[$key] : ''), 'search_lang', 0, null, 1, 0, 0, 'minwidth100imp maxwidth125', 2);
563 } else {
564 print '<input type="text" class="flat maxwidth75" name="search_'.$key.'" value="'.dol_escape_htmltag(isset($search[$key]) ? $search[$key] : '').'">';
565 }
566 print '</td>';
567 }
568}
569// Extra fields
570include DOL_DOCUMENT_ROOT.'/core/tpl/extrafields_list_search_input.tpl.php';
571
572// Fields from hook
573$parameters = array('arrayfields'=>$arrayfields);
574$reshook = $hookmanager->executeHooks('printFieldListOption', $parameters, $object, $action); // Note that $action and $object may have been modified by hook
575print $hookmanager->resPrint;
576/*if (!empty($arrayfields['anotherfield']['checked'])) {
577 print '<td class="liste_titre"></td>';
578}*/
579// Action column
580if (!getDolGlobalString('MAIN_CHECKBOX_LEFT_COLUMN')) {
581 print '<td class="liste_titre center maxwidthsearch">';
582 print '<td class="liste_titre 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')) && !in_array($key, array('id', 'rowid', 'ref', 'status')) && $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 if (empty($obj->ref)) {
660 $obj->ref = $obj->rowid;
661 }
662
663 // Store properties in $object
664 $object->setVarsFromFetchObj($obj);
665
666 if ($mode == 'kanban') {
667 if ($i == 0) {
668 print '<tr class="trkanban"><td colspan="'.$savnbfield.'">';
669 print '<div class="box-flex-container kanban">';
670 }
671 // Output Kanban
672 $selected = -1;
673 if ($massactionbutton || $massaction) { // If we are in select mode (massactionbutton defined) or if we have already selected and sent an action ($massaction) defined
674 $selected = 0;
675 if (in_array($object->id, $arrayofselected)) {
676 $selected = 1;
677 }
678 }
679 print $object->getKanbanView('', array('selected' => $selected));
680 if ($i == ($imaxinloop - 1)) {
681 print '</div>';
682 print '</td></tr>';
683 }
684 } else {
685 // Show line of result
686 $j = 0;
687 print '<tr data-rowid="'.$object->id.'" class="oddeven">';
688
689 // Action column
690 if (getDolGlobalString('MAIN_CHECKBOX_LEFT_COLUMN')) {
691 print '<td class="nowrap center">';
692 if ($massactionbutton || $massaction) { // If we are in select mode (massactionbutton defined) or if we have already selected and sent an action ($massaction) defined
693 $selected = 0;
694 if (in_array($object->id, $arrayofselected)) {
695 $selected = 1;
696 }
697 print '<input id="cb'.$object->id.'" class="flat checkforselect" type="checkbox" name="toselect[]" value="'.$object->id.'"'.($selected ? ' checked="checked"' : '').'>';
698 }
699 print '</td>';
700 if (!$i) {
701 $totalarray['nbfield']++;
702 }
703 }
704 foreach ($object->fields as $key => $val) {
705 $cssforfield = (empty($val['csslist']) ? (empty($val['css']) ? '' : $val['css']) : $val['csslist']);
706 if (in_array($val['type'], array('date', 'datetime', 'timestamp'))) {
707 $cssforfield .= ($cssforfield ? ' ' : '').'center';
708 } elseif ($key == 'status') {
709 $cssforfield .= ($cssforfield ? ' ' : '').'center';
710 }
711
712 if (in_array($val['type'], array('timestamp'))) {
713 $cssforfield .= ($cssforfield ? ' ' : '').'nowraponall';
714 } elseif ($key == 'ref') {
715 $cssforfield .= ($cssforfield ? ' ' : '').'nowraponall';
716 }
717
718 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'])) {
719 $cssforfield .= ($cssforfield ? ' ' : '').'right';
720 }
721 //if (in_array($key, array('fk_soc', 'fk_user', 'fk_warehouse'))) $cssforfield = 'tdoverflowmax100';
722
723 if (!empty($arrayfields['t.'.$key]['checked'])) {
724 print '<td'.($cssforfield ? ' class="'.$cssforfield.((preg_match('/tdoverflow/', $cssforfield) && !in_array($val['type'], array('ip', 'url')) && !is_numeric($object->$key)) ? ' classfortooltip' : '').'"' : '');
725 if (preg_match('/tdoverflow/', $cssforfield) && !in_array($val['type'], array('ip', 'url')) && !is_numeric($object->$key)) {
726 print ' title="'.dol_escape_htmltag($object->$key).'"';
727 }
728 print '>';
729 if ($key == 'status') {
730 print $object->getLibStatut(5);
731 } elseif ($key == 'rowid') {
732 print $object->showOutputField($val, $key, $object->id, '');
733 } else {
734 print $object->showOutputField($val, $key, $object->$key, '');
735 }
736 print '</td>';
737 if (!$i) {
738 $totalarray['nbfield']++;
739 }
740 if (!empty($val['isameasure']) && $val['isameasure'] == 1) {
741 if (!$i) {
742 $totalarray['pos'][$totalarray['nbfield']] = 't.'.$key;
743 }
744 if (!isset($totalarray['val'])) {
745 $totalarray['val'] = array();
746 }
747 if (!isset($totalarray['val']['t.'.$key])) {
748 $totalarray['val']['t.'.$key] = 0;
749 }
750 $totalarray['val']['t.'.$key] += $object->$key;
751 }
752 }
753 }
754 // Extra fields
755 include DOL_DOCUMENT_ROOT.'/core/tpl/extrafields_list_print_fields.tpl.php';
756 // Fields from hook
757 $parameters = array('arrayfields'=>$arrayfields, 'object'=>$object, 'obj'=>$obj, 'i'=>$i, 'totalarray'=>&$totalarray);
758 $reshook = $hookmanager->executeHooks('printFieldListValue', $parameters, $object, $action); // Note that $action and $object may have been modified by hook
759 print $hookmanager->resPrint;
760 /*if (!empty($arrayfields['anotherfield']['checked'])) {
761 print '<td class="right">'.$obj->anotherfield.'</td>';
762 }*/
763 // Action column
764 if (!getDolGlobalString('MAIN_CHECKBOX_LEFT_COLUMN')) {
765 print '<td class="nowrap center">';
766 if ($massactionbutton || $massaction) { // If we are in select mode (massactionbutton defined) or if we have already selected and sent an action ($massaction) defined
767 $selected = 0;
768 if (in_array($object->id, $arrayofselected)) {
769 $selected = 1;
770 }
771 print '<input id="cb'.$object->id.'" class="flat checkforselect" type="checkbox" name="toselect[]" value="'.$object->id.'"'.($selected ? ' checked="checked"' : '').'>';
772 }
773 print '</td>';
774 if (!$i) {
775 $totalarray['nbfield']++;
776 }
777 }
778
779 print '</tr>'."\n";
780 }
781
782 $i++;
783}
784
785// Show total line
786include DOL_DOCUMENT_ROOT.'/core/tpl/list_print_total.tpl.php';
787
788// If no record found
789if ($num == 0) {
790 $colspan = 1;
791 foreach ($arrayfields as $key => $val) {
792 if (!empty($val['checked'])) {
793 $colspan++;
794 }
795 }
796 print '<tr><td colspan="'.$colspan.'"><span class="opacitymedium">'.$langs->trans("NoRecordFound").'</span></td></tr>';
797}
798
799
800$db->free($resql);
801
802$parameters = array('arrayfields'=>$arrayfields, 'sql'=>$sql);
803$reshook = $hookmanager->executeHooks('printFieldListFooter', $parameters, $object, $action); // Note that $action and $object may have been modified by hook
804print $hookmanager->resPrint;
805
806print '</table>'."\n";
807print '</div>'."\n";
808
809print '</form>'."\n";
810
811if (in_array('builddoc', array_keys($arrayofmassactions)) && ($nbtotalofrecords === '' || $nbtotalofrecords)) {
812 $hidegeneratedfilelistifempty = 1;
813 if ($massaction == 'builddoc' || $action == 'remove_file' || $show_files) {
814 $hidegeneratedfilelistifempty = 0;
815 }
816
817 require_once DOL_DOCUMENT_ROOT.'/core/class/html.formfile.class.php';
818 $formfile = new FormFile($db);
819
820 // Show list of available documents
821 $urlsource = $_SERVER['PHP_SELF'].'?sortfield='.$sortfield.'&sortorder='.$sortorder;
822 $urlsource .= str_replace('&amp;', '&', $param);
823
824 $filedir = $diroutputmassaction;
825 $genallowed = $permissiontoread;
826 $delallowed = $permissiontoadd;
827
828 print $formfile->showdocuments('massfilesarea_'.$object->module, '', $filedir, $urlsource, 0, $delallowed, '', 1, 1, 0, 48, 1, $param, $title, '', '', '', null, $hidegeneratedfilelistifempty);
829}
830
831// End of page
832llxFooter();
833$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.