dolibarr 21.0.0-beta
position_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) 2021 Gauthier VERDOL <gauthier.verdol@atm-consulting.fr>
4 * Copyright (C) 2021 Greg Rastklan <greg.rastklan@atm-consulting.fr>
5 * Copyright (C) 2021 Jean-Pascal BOUDET <jean-pascal.boudet@atm-consulting.fr>
6 * Copyright (C) 2021 Grégory BLEMAND <gregory.blemand@atm-consulting.fr>
7 * Copyright (C) 2024 Frédéric France <frederic.france@free.fr>
8 *
9 * This program is free software; you can redistribute it and/or modify
10 * it under the terms of the GNU General Public License as published by
11 * the Free Software Foundation; either version 3 of the License, or
12 * (at your option) any later version.
13 *
14 * This program is distributed in the hope that it will be useful,
15 * but WITHOUT ANY WARRANTY; without even the implied warranty of
16 * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the
17 * GNU General Public License for more details.
18 *
19 * You should have received a copy of the GNU General Public License
20 * along with this program. If not, see <https://www.gnu.org/licenses/>.
21 */
22
30// Load Dolibarr environment
31require '../main.inc.php';
32
33require_once DOL_DOCUMENT_ROOT.'/core/class/html.formcompany.class.php';
34require_once DOL_DOCUMENT_ROOT.'/core/lib/date.lib.php';
35require_once DOL_DOCUMENT_ROOT.'/core/lib/company.lib.php';
36require_once DOL_DOCUMENT_ROOT.'/hrm/class/job.class.php';
37require_once DOL_DOCUMENT_ROOT.'/hrm/class/position.class.php';
38
47// Load translation files required by the page
48$langs->loadLangs(array('hrm', 'other'));
49
50// Get Parameters
51$action = GETPOST('action', 'aZ09') ? GETPOST('action', 'aZ09') : 'view'; // The action 'add', 'create', 'edit', 'update', 'view', ...
52$massaction = GETPOST('massaction', 'alpha'); // The bulk action (combo box choice into lists)
53$show_files = GETPOSTINT('show_files'); // Show files area generated by bulk actions ?
54$confirm = GETPOST('confirm', 'alpha'); // Result of a confirmation
55$cancel = GETPOST('cancel', 'alpha'); // We click on a Cancel button
56$toselect = GETPOST('toselect', 'array'); // Array of ids of elements selected into a list
57$contextpage = GETPOST('contextpage', 'aZ') ? GETPOST('contextpage', 'aZ') : 'positionlist'; // To manage different context of search
58$backtopage = GETPOST('backtopage', 'alpha'); // Go back to a dedicated page
59$optioncss = GETPOST('optioncss', 'aZ'); // Option for the css output (always '' except when 'print')
60$mode = GETPOST('mode', 'aZ');
61
62$id = GETPOSTINT('id');
63$ref = GETPOST('ref', 'alpha');
64
65// Load variable for pagination
66$limit = GETPOSTINT('limit') ? GETPOSTINT('limit') : $conf->liste_limit;
67$sortfield = GETPOST('sortfield', 'aZ09comma');
68$sortorder = GETPOST('sortorder', 'aZ09comma');
69$page = GETPOSTISSET('pageplusone') ? (GETPOSTINT('pageplusone') - 1) : GETPOSTINT("page");
70if (empty($page) || $page < 0 || GETPOST('button_search', 'alpha') || GETPOST('button_removefilter', 'alpha')) {
71 // If $page is not defined, or '' or -1 or if we click on clear filters
72 $page = 0;
73}
74$offset = $limit * $page;
75$pageprev = $page - 1;
76$pagenext = $page + 1;
77
78// Initialize a technical objects
79$object = new Position($db);
80$extrafields = new ExtraFields($db);
81$userstatic = new User($db);
82$diroutputmassaction = $conf->hrm->dir_output.'/temp/massgeneration/'.$user->id;
83$hookmanager->initHooks(array('positionlist')); // Note that conf->hooks_modules contains array
84
85// Fetch optionals attributes and labels
86$extrafields->fetch_name_optionals_label($object->table_element);
87//$extrafields->fetch_name_optionals_label($object->table_element_line);
88
89$search_array_options = $extrafields->getOptionalsFromPost($object->table_element, '', 'search_');
90
91// Default sort order (if not yet defined by previous GETPOST)
92if (!$sortfield) {
93 reset($object->fields); // Reset is required to avoid key() to return null.
94 $sortfield = "t.".key($object->fields); // Set here default search field. By default 1st field in definition.
95}
96if (!$sortorder) {
97 $sortorder = "ASC";
98}
99
100// Initialize array of search criteria
101$search_all = GETPOST('search_all', 'alphanohtml');
102$search = array();
103foreach ($object->fields as $key => $val) {
104 if (GETPOST('search_'.$key, 'alpha') !== '') {
105 $search[$key] = GETPOST('search_'.$key, 'alpha');
106 }
107 if (preg_match('/^(date|timestamp|datetime)/', $val['type'])) {
108 $search[$key.'_dtstart'] = dol_mktime(0, 0, 0, GETPOSTINT('search_'.$key.'_dtstartmonth'), GETPOSTINT('search_'.$key.'_dtstartday'), GETPOSTINT('search_'.$key.'_dtstartyear'));
109 $search[$key.'_dtend'] = dol_mktime(23, 59, 59, GETPOSTINT('search_'.$key.'_dtendmonth'), GETPOSTINT('search_'.$key.'_dtendday'), GETPOSTINT('search_'.$key.'_dtendyear'));
110 }
111}
112
113// List of fields to search into when doing a "search in all"
114$fieldstosearchall = array();
115foreach ($object->fields as $key => $val) {
116 if (!empty($val['searchall'])) {
117 $fieldstosearchall['t.'.$key] = $val['label'];
118 }
119}
120
121// Definition of array of fields for columns
122$arrayfields = array();
123foreach ($object->fields as $key => $val) {
124 // If $val['visible']==0, then we never show the field
125 if (!empty($val['visible'])) {
126 $visible = (int) dol_eval((string) $val['visible'], 1);
127 $arrayfields['t.'.$key] = array(
128 'label' => $val['label'],
129 'checked' => (($visible < 0) ? 0 : 1),
130 'enabled' => (abs($visible) != 3 && (bool) dol_eval($val['enabled'], 1)),
131 'position' => $val['position'],
132 'help' => isset($val['help']) ? $val['help'] : ''
133 );
134 }
135}
136// Extra fields
137include DOL_DOCUMENT_ROOT.'/core/tpl/extrafields_list_array_fields.tpl.php';
138
139$object->fields = dol_sort_array($object->fields, 'position');
140$arrayfields = dol_sort_array($arrayfields, 'position');
141
142// Permissions
143$permissiontoread = $user->hasRight('hrm', 'all', 'read');
144$permissiontoadd = $user->hasRight('hrm', 'all', 'write');
145$permissiontodelete = $user->hasRight('hrm', 'all', 'delete');
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, $object->id, $object->table_element, '', 'fk_soc', 'rowid', $isdraft);
155if (!isModEnabled('hrm')) {
156 accessforbidden('Module hrm not enabled');
157}
158if (!$permissiontoread) {
160}
161
162
163
164/*
165 * Actions
166 */
167
168if (GETPOST('cancel', 'alpha')) {
169 $action = 'list';
170 $massaction = '';
171}
172if (!GETPOST('confirmmassaction', 'alpha') && $massaction != 'presend' && $massaction != 'confirm_presend') {
173 $massaction = '';
174}
175
176$parameters = array();
177$reshook = $hookmanager->executeHooks('doActions', $parameters, $object, $action); // Note that $action and $object may have been modified by some hooks
178if ($reshook < 0) {
179 setEventMessages($hookmanager->error, $hookmanager->errors, 'errors');
180}
181
182if (empty($reshook)) {
183 // Selection of new fields
184 include DOL_DOCUMENT_ROOT.'/core/actions_changeselectedfields.inc.php';
185
186 // Purge search criteria
187 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
188 foreach ($object->fields as $key => $val) {
189 $search[$key] = '';
190 if (preg_match('/^(date|timestamp|datetime)/', $val['type'])) {
191 $search[$key.'_dtstart'] = '';
192 $search[$key.'_dtend'] = '';
193 }
194 }
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 = 'Position';
205 $objectlabel = 'Position';
206 $uploaddir = $conf->hrm->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$jobstatic = new Job($db);
218
219$now = dol_now();
220
221//$help_url="EN:Module_Position|FR:Module_Position_FR|ES:Módulo_Position";
222$help_url = '';
223$title = $langs->trans('EmployeePositions');
224$morejs = array();
225$morecss = array();
226
227
228// Build and execute select
229// --------------------------------------------------------------------
230$sql = 'SELECT ';
231$sql .= $object->getFieldList('t');
232$sql .= ',';
233$sql .= $userstatic->getFieldList('u', array('rowid'));
234$sql .= ', u.email, u.statut, u.photo, u.login'; // Add more field not yet into the user->fields
235$sql .= ', j.rowid as job_id, j.label as job_label';
236// Add fields from extrafields
237if (!empty($extrafields->attributes[$object->table_element]['label'])) {
238 foreach ($extrafields->attributes[$object->table_element]['label'] as $key => $val) {
239 $sql .= ($extrafields->attributes[$object->table_element]['type'][$key] != 'separate' ? ", ef.".$key." as options_".$key : '');
240 }
241}
242// Add fields from hooks
243$parameters = array();
244$reshook = $hookmanager->executeHooks('printFieldListSelect', $parameters, $object); // Note that $action and $object may have been modified by hook
245$sql .= $hookmanager->resPrint;
246$sql = preg_replace('/,\s*$/', '', $sql);
247$sql .= " FROM ".MAIN_DB_PREFIX.$object->table_element." as t LEFT JOIN ".MAIN_DB_PREFIX.$userstatic->table_element." as u on t.fk_user = u.rowid, ".MAIN_DB_PREFIX."hrm_job as j";
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); // 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).")";
257} else {
258 $sql .= " WHERE 1 = 1";
259}
260$sql .= " AND t.fk_job = j.rowid";
261foreach ($search as $key => $val) {
262 if (array_key_exists($key, $object->fields)) {
263 if ($key == 'status' && $search[$key] == -1) {
264 continue;
265 }
266 $mode_search = (($object->isInt($object->fields[$key]) || $object->isFloat($object->fields[$key])) ? 1 : 0);
267 if ((strpos($object->fields[$key]['type'], 'integer:') === 0) || (strpos($object->fields[$key]['type'], 'sellist:') === 0) || !empty($object->fields[$key]['arrayofkeyval'])) {
268 if ($search[$key] == '-1' || ($search[$key] === '0' && (empty($object->fields[$key]['arrayofkeyval']) || !array_key_exists('0', $object->fields[$key]['arrayofkeyval'])))) {
269 $search[$key] = '';
270 }
271 $mode_search = 2;
272 }
273 if ($search[$key] != '') {
274 $sql .= natural_search("t.".$db->escape($key), $search[$key], (($key == 'status') ? 2 : $mode_search));
275 }
276 } else {
277 if (preg_match('/(_dtstart|_dtend)$/', $key) && $search[$key] != '') {
278 $columnName=preg_replace('/(_dtstart|_dtend)$/', '', $key);
279 if (preg_match('/^(date|timestamp|datetime)/', $object->fields[$columnName]['type'])) {
280 if (preg_match('/_dtstart$/', $key)) {
281 $sql .= " AND t.".$db->escape($columnName)." >= '".$db->idate($search[$key])."'";
282 }
283 if (preg_match('/_dtend$/', $key)) {
284 $sql .= " AND t.".$db->escape($columnName)." <= '".$db->idate($search[$key])."'";
285 }
286 }
287 }
288 }
289}
290$vacant = GETPOST('search_fk_uservacant', 'alphanohtml') === 'on';
291if ($vacant) {
292 $sql .= ' AND t.fk_user = 0';
293}
294if ($search_all) {
295 $sql .= natural_search(array_keys($fieldstosearchall), $search_all);
296}
297//$sql.= dolSqlDateFilter("t.field", $search_xxxday, $search_xxxmonth, $search_xxxyear);
298// Add where from extra fields
299include DOL_DOCUMENT_ROOT.'/core/tpl/extrafields_list_search_sql.tpl.php';
300// Add where from hooks
301$parameters = array();
302$reshook = $hookmanager->executeHooks('printFieldListWhere', $parameters, $object); // Note that $action and $object may have been modified by hook
303$sql .= $hookmanager->resPrint;
304
305/* If a group by is required
306$sql .= " GROUP BY ";
307foreach($object->fields as $key => $val) {
308 $sql .= "t.".$db->escape($key).", ";
309}
310// Add fields from extrafields
311if (!empty($extrafields->attributes[$object->table_element]['label'])) {
312 foreach ($extrafields->attributes[$object->table_element]['label'] as $key => $val) {
313 $sql .= ($extrafields->attributes[$object->table_element]['type'][$key] != 'separate' ? "ef.".$key.', ' : '');
314 }
315}
316// Add where from hooks
317$parameters = array();
318$reshook = $hookmanager->executeHooks('printFieldListGroupBy', $parameters, $object); // Note that $action and $object may have been modified by hook
319$sql .= $hookmanager->resPrint;
320$sql = preg_replace('/,\s*$/', '', $sql);
321*/
322
323// Count total nb of records
324$nbtotalofrecords = '';
325if (!getDolGlobalInt('MAIN_DISABLE_FULL_SCANLIST')) {
326 $resql = $db->query($sql);
327 $nbtotalofrecords = $db->num_rows($resql);
328 if (($page * $limit) > $nbtotalofrecords) { // if total of record found is smaller than page * limit, goto and load page 0
329 $page = 0;
330 $offset = 0;
331 }
332 $db->free($resql);
333}
334
335// Complete request and execute it with limit
336$sql .= $db->order($sortfield, $sortorder);
337if ($limit) {
338 $sql .= $db->plimit($limit + 1, $offset);
339}
340
341$resql = $db->query($sql);
342if (!$resql) {
343 dol_print_error($db);
344 exit;
345}
346
347$num = $db->num_rows($resql);
348
349
350// Direct jump if only one record found
351if ($num == 1 && getDolGlobalString('MAIN_SEARCH_DIRECT_OPEN_IF_ONLY_ONE') && $search_all && !$page) {
352 $obj = $db->fetch_object($resql);
353 $id = $obj->rowid;
354 header("Location: ".dol_buildpath('/hrm/position.php', 1).'?id='.$id);
355 exit;
356}
357
358
359// Output page
360// --------------------------------------------------------------------
361
362llxHeader('', $title, $help_url, '', 0, 0, $morejs, $morecss, '', 'bodyforlist');
363
364// Example : Adding jquery code
365// print '<script type="text/javascript" language="javascript">
366// jQuery(document).ready(function() {
367// function init_myfunc()
368// {
369// jQuery("#myid").removeAttr(\'disabled\');
370// jQuery("#myid").attr(\'disabled\',\'disabled\');
371// }
372// init_myfunc();
373// jQuery("#mybutton").click(function() {
374// init_myfunc();
375// });
376// });
377// </script>';
378
379$arrayofselected = is_array($toselect) ? $toselect : array();
380
381$param = '';
382if (!empty($mode)) {
383 $param .= '&mode='.urlencode($mode);
384}
385if (!empty($contextpage) && $contextpage != $_SERVER["PHP_SELF"]) {
386 $param .= '&contextpage='.urlencode($contextpage);
387}
388if ($limit > 0 && $limit != $conf->liste_limit) {
389 $param .= '&limit='.((int) $limit);
390}
391
392foreach ($search as $key => $val) {
393 if (is_array($search[$key])) {
394 foreach ($search[$key] as $skey) {
395 if ($skey != '') {
396 $param .= '&search_'.$key.'[]='.urlencode($skey);
397 }
398 }
399 } elseif (preg_match('/(_dtstart|_dtend)$/', $key) && !empty($val)) {
400 $param .= '&search_'.$key.'month='.(GETPOSTINT('search_'.$key.'month'));
401 $param .= '&search_'.$key.'day='.(GETPOSTINT('search_'.$key.'day'));
402 $param .= '&search_'.$key.'year='.(GETPOSTINT('search_'.$key.'year'));
403 } elseif ($search[$key] != '') {
404 $param .= '&search_'.$key.'='.urlencode($search[$key]);
405 }
406}
407if ($optioncss != '') {
408 $param .= '&optioncss='.urlencode($optioncss);
409}
410// Add $param from extra fields
411include DOL_DOCUMENT_ROOT.'/core/tpl/extrafields_list_search_param.tpl.php';
412// Add $param from hooks
413$parameters = array('param' => &$param);
414$reshook = $hookmanager->executeHooks('printFieldListSearchParam', $parameters, $object); // Note that $action and $object may have been modified by hook
415$param .= $hookmanager->resPrint;
416
417// List of mass actions available
418$arrayofmassactions = array(
419 //'validate'=>img_picto('', 'check', 'class="pictofixedwidth"').$langs->trans("Validate"),
420 //'generate_doc'=>img_picto('', 'pdf', 'class="pictofixedwidth"').$langs->trans("ReGeneratePDF"),
421 //'builddoc'=>img_picto('', 'pdf', 'class="pictofixedwidth"').$langs->trans("PDFMerge"),
422 //'presend'=>img_picto('', 'email', 'class="pictofixedwidth"').$langs->trans("SendByMail"),
423);
424if (!empty($permissiontodelete)) {
425 $arrayofmassactions['predelete'] = img_picto('', 'delete', 'class="pictofixedwidth"').$langs->trans("Delete");
426}
427if (GETPOSTINT('nomassaction') || in_array($massaction, array('presend', 'predelete'))) {
428 $arrayofmassactions = array();
429}
430$massactionbutton = $form->selectMassAction('', $arrayofmassactions);
431
432print '<form method="POST" id="searchFormList" action="'.$_SERVER["PHP_SELF"].'">'."\n";
433if ($optioncss != '') {
434 print '<input type="hidden" name="optioncss" value="'.$optioncss.'">';
435}
436print '<input type="hidden" name="token" value="'.newToken().'">';
437print '<input type="hidden" name="formfilteraction" id="formfilteraction" value="list">';
438print '<input type="hidden" name="action" value="list">';
439print '<input type="hidden" name="sortfield" value="'.$sortfield.'">';
440print '<input type="hidden" name="sortorder" value="'.$sortorder.'">';
441print '<input type="hidden" name="page" value="'.$page.'">';
442print '<input type="hidden" name="contextpage" value="'.$contextpage.'">';
443print '<input type="hidden" name="mode" value="'.$mode.'">';
444
445$newcardbutton = '';
446$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'));
447$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'));
448$newcardbutton .= dolGetButtonTitleSeparator();
449$newcardbutton .= dolGetButtonTitle($langs->trans('New'), '', 'fa fa-plus-circle', dol_buildpath('/hrm/position.php', 1).'?action=create', '', $permissiontoadd);
450
451print_barre_liste($title, $page, $_SERVER["PHP_SELF"], $param, $sortfield, $sortorder, $massactionbutton, $num, $nbtotalofrecords, 'object_'.$object->picto, 0, $newcardbutton, '', $limit, 0, 0, 1);
452
453// Add code for pre mass action (confirmation or email presend form)
454$topicmail = "SendPositionRef";
455$modelmail = "position";
456$objecttmp = new Position($db);
457$trackid = 'xxxx'.$object->id;
458include DOL_DOCUMENT_ROOT.'/core/tpl/massactions_pre.tpl.php';
459
460if ($search_all) {
461 $setupstring = '';
462 foreach ($fieldstosearchall as $key => $val) {
463 $fieldstosearchall[$key] = $langs->trans($val);
464 $setupstring .= $key."=".$val.";";
465 }
466 print '<!-- Search done like if JOBPOSITION_QUICKSEARCH_ON_FIELDS = '.$setupstring.' -->'."\n";
467 print '<div class="divsearchfieldfilter">'.$langs->trans("FilterOnInto", $search_all).implode(', ', $fieldstosearchall).'</div>';
468}
469
470$moreforfilter = '';
471/*$moreforfilter.='<div class="divsearchfield">';
472$moreforfilter.= $langs->trans('MyFilter') . ': <input type="text" name="search_myfield" value="'.dol_escape_htmltag($search_myfield).'">';
473$moreforfilter.= '</div>';*/
474
475$parameters = array();
476$reshook = $hookmanager->executeHooks('printFieldPreListTitle', $parameters, $object); // Note that $action and $object may have been modified by hook
477if (empty($reshook)) {
478 $moreforfilter .= $hookmanager->resPrint;
479} else {
480 $moreforfilter = $hookmanager->resPrint;
481}
482
483if (!empty($moreforfilter)) {
484 print '<div class="liste_titre liste_titre_bydiv centpercent">';
485 print $moreforfilter;
486 print '</div>';
487}
488
489$varpage = empty($contextpage) ? $_SERVER["PHP_SELF"] : $contextpage;
490$selectedfields = $form->multiSelectArrayWithCheckbox('selectedfields', $arrayfields, $varpage, getDolGlobalString('MAIN_CHECKBOX_LEFT_COLUMN')); // This also change content of $arrayfields
491$selectedfields .= (count($arrayofmassactions) ? $form->showCheckAddButtons('checkforselect', 1) : '');
492
493print '<div class="div-table-responsive">'; // You can use div-table-responsive-no-min if you don't need reserved height for your table
494print '<table class="tagtable nobottomiftotal liste'.($moreforfilter ? " listwithfilterbefore" : "").'">'."\n";
495
496
497// Fields title search
498// --------------------------------------------------------------------
499print '<tr class="liste_titre">';
500// Action column
501if (getDolGlobalString('MAIN_CHECKBOX_LEFT_COLUMN')) {
502 print '<td class="liste_titre maxwidthsearch">';
503 $searchpicto = $form->showFilterButtons('left');
504 print $searchpicto;
505 print '</td>';
506}
507foreach ($object->fields as $key => $val) {
508 $searchkey = empty($search[$key]) ? '' : $search[$key];
509 $cssforfield = (empty($val['csslist']) ? (empty($val['css']) ? '' : $val['css']) : $val['csslist']);
510 if ($key == 'status') {
511 $cssforfield .= ($cssforfield ? ' ' : '').'center';
512 } elseif (in_array($val['type'], array('date', 'datetime', 'timestamp'))) {
513 $cssforfield .= ($cssforfield ? ' ' : '').'center';
514 } elseif (in_array($val['type'], array('timestamp'))) {
515 $cssforfield .= ($cssforfield ? ' ' : '').'nowrap';
516 } 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'])) {
517 $cssforfield .= ($cssforfield ? ' ' : '').'right';
518 }
519 if (!empty($arrayfields['t.'.$key]['checked'])) {
520 print '<td class="liste_titre'.($cssforfield ? ' '.$cssforfield : '').'">';
521 if (!empty($val['arrayofkeyval']) && is_array($val['arrayofkeyval'])) {
522 print $form->selectarray('search_'.$key, $val['arrayofkeyval'], (isset($search[$key]) ? $search[$key] : ''), $val['notnull'], 0, 0, '', 1, 0, 0, '', 'maxwidth100', 1);
523 } elseif ((strpos($val['type'], 'integer:') === 0) || (strpos($val['type'], 'sellist:') === 0)) {
524 print $object->showInputField($val, $key, (isset($search[$key]) ? $search[$key] : ''), '', '', 'search_', $cssforfield.' maxwidth250', 1);
525 } elseif (preg_match('/^(date|timestamp|datetime)/', $val['type'])) {
526 print '<div class="nowrap">';
527 print $form->selectDate($search[$key.'_dtstart'] ? $search[$key.'_dtstart'] : '', "search_".$key."_dtstart", 0, 0, 1, '', 1, 0, 0, '', '', '', '', 1, '', $langs->trans('From'));
528 print '</div>';
529 print '<div class="nowrap">';
530 print $form->selectDate($search[$key.'_dtend'] ? $search[$key.'_dtend'] : '', "search_".$key."_dtend", 0, 0, 1, '', 1, 0, 0, '', '', '', '', 1, '', $langs->trans('to'));
531 print '</div>';
532 } elseif ($key == 'lang') {
533 require_once DOL_DOCUMENT_ROOT.'/core/class/html.formadmin.class.php';
534 $formadmin = new FormAdmin($db);
535 print $formadmin->select_language($search[$key], 'search_lang', 0, null, 1, 0, 0, 'minwidth100imp maxwidth125', 2);
536 } else {
537 print '<input type="text" class="flat maxwidth'.($val['type'] == 'integer' ? '50' : '75').'" name="search_'.$key.'" value="'.dol_escape_htmltag(isset($search[$key]) ? $search[$key] : '').'">';
538 }
539 print '</td>';
540 }
541}
542// Extra fields
543include DOL_DOCUMENT_ROOT.'/core/tpl/extrafields_list_search_input.tpl.php';
544
545// Fields from hook
546$parameters = array('arrayfields'=>$arrayfields);
547$reshook = $hookmanager->executeHooks('printFieldListOption', $parameters, $object); // Note that $action and $object may have been modified by hook
548print $hookmanager->resPrint;
549// Action column
550if (!getDolGlobalString('MAIN_CHECKBOX_LEFT_COLUMN')) {
551 print '<td class="liste_titre maxwidthsearch">';
552 $searchpicto = $form->showFilterButtons();
553 print $searchpicto;
554 print '</td>';
555}
556print '</tr>'."\n";
557
558$totalarray = array();
559$totalarray['nbfield'] = 0;
560
561// Fields title label
562// --------------------------------------------------------------------
563print '<tr class="liste_titre">';
564if (getDolGlobalString('MAIN_CHECKBOX_LEFT_COLUMN')) {
565 print getTitleFieldOfList(($mode != 'kanban' ? $selectedfields : ''), 0, $_SERVER["PHP_SELF"], '', '', '', '', $sortfield, $sortorder, 'center maxwidthsearch ')."\n";
566}
567foreach ($object->fields as $key => $val) {
568 $cssforfield = (empty($val['csslist']) ? (empty($val['css']) ? '' : $val['css']) : $val['csslist']);
569 if ($key == 'status') {
570 $cssforfield .= ($cssforfield ? ' ' : '').'center';
571 } elseif (in_array($val['type'], array('date', 'datetime', 'timestamp'))) {
572 $cssforfield .= ($cssforfield ? ' ' : '').'center';
573 } elseif (in_array($val['type'], array('timestamp'))) {
574 $cssforfield .= ($cssforfield ? ' ' : '').'nowrap';
575 } 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'])) {
576 $cssforfield .= ($cssforfield ? ' ' : '').'right';
577 }
578 $cssforfield = preg_replace('/small\s*/', '', $cssforfield); // the 'small' css must not be used for the title label
579 if (!empty($arrayfields['t.'.$key]['checked'])) {
580 print getTitleFieldOfList($arrayfields['t.'.$key]['label'], 0, $_SERVER['PHP_SELF'], 't.'.$key, '', $param, ($cssforfield ? 'class="'.$cssforfield.'"' : ''), $sortfield, $sortorder, ($cssforfield ? $cssforfield.' ' : ''))."\n";
581 $totalarray['nbfield']++;
582 }
583}
584// Extra fields
585include DOL_DOCUMENT_ROOT.'/core/tpl/extrafields_list_search_title.tpl.php';
586// Hook fields
587$parameters = array('arrayfields'=>$arrayfields, 'param'=>$param, 'sortfield'=>$sortfield, 'sortorder'=>$sortorder, 'totalarray'=>&$totalarray);
588$reshook = $hookmanager->executeHooks('printFieldListTitle', $parameters, $object); // Note that $action and $object may have been modified by hook
589print $hookmanager->resPrint;
590// Action column
591if (!getDolGlobalString('MAIN_CHECKBOX_LEFT_COLUMN')) {
592 print getTitleFieldOfList(($mode != 'kanban' ? $selectedfields : ''), 0, $_SERVER["PHP_SELF"], '', '', '', '', $sortfield, $sortorder, 'center maxwidthsearch ')."\n";
593}
594$totalarray['nbfield']++;
595print '</tr>'."\n";
596
597
598// Detect if we need a fetch on each output line
599$needToFetchEachLine = 0;
600if (isset($extrafields->attributes[$object->table_element]['computed']) && is_array($extrafields->attributes[$object->table_element]['computed']) && count($extrafields->attributes[$object->table_element]['computed']) > 0) {
601 foreach ($extrafields->attributes[$object->table_element]['computed'] as $key => $val) {
602 if (!is_null($val) && preg_match('/\$object/', $val)) {
603 $needToFetchEachLine++; // There is at least one compute field that use $object
604 }
605 }
606}
607
608
609// Loop on record
610// --------------------------------------------------------------------
611$i = 0;
612$savnbfield = $totalarray['nbfield'];
613$totalarray = array();
614$totalarray['nbfield'] = 0;
615$imaxinloop = ($limit ? min($num, $limit) : $num);
616while ($i < $imaxinloop) {
617 $obj = $db->fetch_object($resql);
618 if (empty($obj)) {
619 break; // Should not happen
620 }
621
622 // Store properties in $object
623 $object->setVarsFromFetchObj($obj);
624
625
626 if ($mode == 'kanban') {
627 if ($i == 0) {
628 print '<tr class="trkanban"><td colspan="'.$savnbfield.'">';
629 print '<div class="box-flex-container kanban">';
630 }
631 // get info needed
632 $object->date_start = $obj->date_start;
633 $object->date_end = $obj->date_end;
634 $object->fk_job = $obj->job_id;
635
636 $jobstatic->id = $obj->job_id;
637 $jobstatic->label = $obj->job_label;
638 $jobstatic->status = $obj->job_status;
639
640 $userstatic->id = $obj->fk_user;
641 $userstatic->ref = $obj->fk_user;
642 $userstatic->firstname = $obj->firstname;
643 $userstatic->lastname = $obj->lastname;
644 $userstatic->email = $obj->email;
645 $userstatic->statut = $obj->statut;
646 $userstatic->status = $obj->statut;
647 $userstatic->login = $obj->login;
648 $userstatic->photo = $obj->photo;
649
650 // Output kanban
651 $selected = -1;
652 if ($massactionbutton || $massaction) { // If we are in select mode (massactionbutton defined) or if we have already selected and sent an action ($massaction) defined
653 $selected = 0;
654 if (in_array($object->id, $arrayofselected)) {
655 $selected = 1;
656 }
657 }
658 print $object->getKanbanView('', array('user' => $userstatic->getNomUrl(-1), 'job'=> $jobstatic->getNomUrl(1), 'selected' => $selected));
659 if ($i == ($imaxinloop - 1)) {
660 print '</div>';
661 print '</td></tr>';
662 }
663 } else {
664 // Show here line of result
665 $j = 0;
666 print '<tr data-rowid="'.$object->id.'" class="oddeven">';
667 // Action column
668 if (getDolGlobalString('MAIN_CHECKBOX_LEFT_COLUMN')) {
669 print '<td class="nowrap center">';
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 print '<input id="cb'.$object->id.'" class="flat checkforselect" type="checkbox" name="toselect[]" value="'.$object->id.'"'.($selected ? ' checked="checked"' : '').'>';
676 }
677 print '</td>';
678 }
679 foreach ($object->fields as $key => $val) {
680 $cssforfield = (empty($val['csslist']) ? (empty($val['css']) ? '' : $val['css']) : $val['csslist']);
681 if (in_array($val['type'], array('date', 'datetime', 'timestamp'))) {
682 $cssforfield .= ($cssforfield ? ' ' : '').'center';
683 } elseif ($key == 'status') {
684 $cssforfield .= ($cssforfield ? ' ' : '').'center';
685 }
686
687 if (in_array($val['type'], array('timestamp'))) {
688 $cssforfield .= ($cssforfield ? ' ' : '').'nowrap';
689 } elseif ($key == 'ref') {
690 $cssforfield .= ($cssforfield ? ' ' : '').'nowrap';
691 }
692
693 if (in_array($val['type'], array('double(24,8)', 'double(6,3)', 'integer', 'real', 'price')) && !in_array($key, array('rowid', 'status')) && empty($val['arrayofkeyval'])) {
694 $cssforfield .= ($cssforfield ? ' ' : '').'right';
695 }
696 //if (in_array($key, array('fk_soc', 'fk_user', 'fk_warehouse'))) $cssforfield = 'tdoverflowmax100';
697
698 if (!empty($arrayfields['t.'.$key]['checked'])) {
699 print '<td'.($cssforfield ? ' class="'.$cssforfield.(preg_match('/tdoverflow/', $cssforfield) ? ' classfortooltip' : '').'"' : '');
700 if (preg_match('/tdoverflow/', $cssforfield) && !is_numeric($object->$key)) {
701 print ' title="'.dol_escape_htmltag($object->$key).'"';
702 }
703 print '>';
704 if ($key == 'status') {
705 print $object->getLibStatut(5);
706 } elseif ($key == 'rowid') {
707 print $object->showOutputField($val, $key, $object->id, '');
708 } else {
709 print $object->showOutputField($val, $key, $object->$key, '');
710 }
711 print '</td>';
712 if (!$i) {
713 $totalarray['nbfield']++;
714 }
715 if (!empty($val['isameasure']) && $val['isameasure'] == 1) {
716 if (!$i) {
717 $totalarray['pos'][$totalarray['nbfield']] = 't.'.$key;
718 }
719 if (!isset($totalarray['val'])) {
720 $totalarray['val'] = array();
721 }
722 if (!isset($totalarray['val']['t.'.$key])) {
723 $totalarray['val']['t.'.$key] = 0;
724 }
725 $totalarray['val']['t.'.$key] += $object->$key;
726 }
727 }
728 }
729 // Extra fields
730 include DOL_DOCUMENT_ROOT.'/core/tpl/extrafields_list_print_fields.tpl.php';
731 // Fields from hook
732 $parameters = array('arrayfields'=>$arrayfields, 'object'=>$object, 'obj'=>$obj, 'i'=>$i, 'totalarray'=>&$totalarray);
733 $reshook = $hookmanager->executeHooks('printFieldListValue', $parameters, $object); // Note that $action and $object may have been modified by hook
734 print $hookmanager->resPrint;
735 // Action column
736 if (!getDolGlobalString('MAIN_CHECKBOX_LEFT_COLUMN')) {
737 print '<td class="nowrap center">';
738 if ($massactionbutton || $massaction) { // If we are in select mode (massactionbutton defined) or if we have already selected and sent an action ($massaction) defined
739 $selected = 0;
740 if (in_array($object->id, $arrayofselected)) {
741 $selected = 1;
742 }
743 print '<input id="cb'.$object->id.'" class="flat checkforselect" type="checkbox" name="toselect[]" value="'.$object->id.'"'.($selected ? ' checked="checked"' : '').'>';
744 }
745 print '</td>';
746 }
747 if (!$i) {
748 $totalarray['nbfield']++;
749 }
750
751 print '</tr>'."\n";
752 }
753
754 $i++;
755}
756
757// Show total line
758include DOL_DOCUMENT_ROOT.'/core/tpl/list_print_total.tpl.php';
759
760// If no record found
761if ($num == 0) {
762 $colspan = 1;
763 foreach ($arrayfields as $key => $val) {
764 if (!empty($val['checked'])) {
765 $colspan++;
766 }
767 }
768 print '<tr><td colspan="'.$colspan.'"><span class="opacitymedium">'.$langs->trans("NoRecordFound").'</span></td></tr>';
769}
770
771
772$db->free($resql);
773
774$parameters = array('arrayfields'=>$arrayfields, 'sql'=>$sql);
775$reshook = $hookmanager->executeHooks('printFieldListFooter', $parameters, $object, $action); // Note that $action and $object may have been modified by hook
776print $hookmanager->resPrint;
777
778print '</table>'."\n";
779print '</div>'."\n";
780
781print '</form>'."\n";
782
783if (in_array('builddoc', array_keys($arrayofmassactions)) && ($nbtotalofrecords === '' || $nbtotalofrecords)) {
784 $hidegeneratedfilelistifempty = 1;
785 if ($massaction == 'builddoc' || $action == 'remove_file' || $show_files) {
786 $hidegeneratedfilelistifempty = 0;
787 }
788
789 require_once DOL_DOCUMENT_ROOT.'/core/class/html.formfile.class.php';
790 $formfile = new FormFile($db);
791
792 // Show list of available documents
793 $urlsource = $_SERVER['PHP_SELF'].'?sortfield='.$sortfield.'&sortorder='.$sortorder;
794 $urlsource .= str_replace('&amp;', '&', $param);
795
796 $filedir = $diroutputmassaction;
797 $genallowed = $permissiontoread;
798 $delallowed = $permissiontoadd;
799
800 print $formfile->showdocuments('massfilesarea_hrm', '', $filedir, $urlsource, 0, $delallowed, '', 1, 1, 0, 48, 1, $param, $title, '', '', '', null, $hidegeneratedfilelistifempty);
801}
802
803// End of page
804llxFooter();
805$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 for Job.
Definition job.class.php:38
Class for Position.
Class to manage Dolibarr users.
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...
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.
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...
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.