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