dolibarr 22.0.5
list.php
Go to the documentation of this file.
1<?php
2/* Copyright (C) 2002-2003 Rodolphe Quiedeville <rodolphe@quiedeville.org>
3 * Copyright (C) 2004-2014 Laurent Destailleur <eldy@users.sourceforge.net>
4 * Copyright (C) 2005-2012 Regis Houssin <regis.houssin@inodbox.com>
5 * Copyright (C) 2011-2012 Juanjo Menent <jmenent@2byte.es>
6 * Copyright (C) 2013 Cédric Salvador <csalvador@gpcsolutions.fr>
7 * Copyright (C) 2015 Jean-François Ferry <jfefe@aternatik.fr>
8 * Copyright (C) 2018 Ferran Marcet <fmarcet@2byte.es>
9 * Copyright (C) 2021-2024 Frédéric France <frederic.france@free.fr>
10 * Copyright (C) 2022 Charlène Benke <charlene@patas-monkey.com>
11 * Copyright (C) 2024 William Mead <william.mead@manchenumerique.fr>
12 * Copyright (C) 2024-2026 MDW <mdeweerd@users.noreply.github.com>
13 * Copyright (C) 2024 Benjamin Falière <benjamin.faliere@altairis.fr>
14 *
15 * This program is free software; you can redistribute it and/or modify
16 * it under the terms of the GNU General Public License as published by
17 * the Free Software Foundation; either version 3 of the License, or
18 * (at your option) any later version.
19 *
20 * This program is distributed in the hope that it will be useful,
21 * but WITHOUT ANY WARRANTY; without even the implied warranty of
22 * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the
23 * GNU General Public License for more details.
24 *
25 * You should have received a copy of the GNU General Public License
26 * along with this program. If not, see <https://www.gnu.org/licenses/>.
27 */
28
35// Load Dolibarr environment
36require '../main.inc.php';
37require_once DOL_DOCUMENT_ROOT.'/core/class/html.formfile.class.php';
38require_once DOL_DOCUMENT_ROOT.'/contact/class/contact.class.php';
39require_once DOL_DOCUMENT_ROOT.'/fichinter/class/fichinter.class.php';
40require_once DOL_DOCUMENT_ROOT.'/core/lib/date.lib.php';
41if (isModEnabled('project')) {
42 require_once DOL_DOCUMENT_ROOT.'/projet/class/project.class.php';
43}
44if (isModEnabled('contract')) {
45 require_once DOL_DOCUMENT_ROOT.'/contrat/class/contrat.class.php';
46}
47
56// Load translation files required by the page
57$langs->loadLangs(array('companies', 'bills', 'interventions'));
58if (isModEnabled('project')) {
59 $langs->load("projects");
60}
61if (isModEnabled('contract')) {
62 $langs->load("contracts");
63}
64
65$action = GETPOST('action', 'aZ09');
66$massaction = GETPOST('massaction', 'alpha');
67$show_files = GETPOSTINT('show_files');
68$confirm = GETPOST('confirm', 'alpha');
69$toselect = GETPOST('toselect', 'array');
70$contextpage = GETPOST('contextpage', 'aZ') ? GETPOST('contextpage', 'aZ') : 'interventionlist';
71$mode = GETPOST('mode', 'alpha');
72
73if (getDolGlobalInt('MAIN_SEE_SUBORDINATES')) {
74 $userschilds = $user->getAllChildIds();
75} else {
76 $userschilds = array();
77}
78
79$search_ref = GETPOST('search_ref') ? GETPOST('search_ref', 'alpha') : GETPOST('search_inter', 'alpha');
80$search_ref_client = GETPOST('search_ref_client', 'alpha');
81$search_company = GETPOST('search_company', 'alpha');
82$search_desc = GETPOST('search_desc', 'alpha');
83$search_projet_ref = GETPOST('search_projet_ref', 'alpha');
84$search_contrat_ref = GETPOST('search_contrat_ref', 'alpha');
85$search_status = GETPOST('search_status', 'alpha');
86$search_signed_status = GETPOST('search_signed_status', 'alpha');
87$search_all = trim(GETPOST('search_all', 'alphanohtml'));
88$search_date_startday = GETPOSTINT('search_date_startday');
89$search_date_startmonth = GETPOSTINT('search_date_startmonth');
90$search_date_startyear = GETPOSTINT('search_date_startyear');
91$search_date_endday = GETPOSTINT('search_date_endday');
92$search_date_endmonth = GETPOSTINT('search_date_endmonth');
93$search_date_endyear = GETPOSTINT('search_date_endyear');
94$search_date_start = dol_mktime(0, 0, 0, $search_date_startmonth, $search_date_startday, $search_date_startyear); // Use tzserver
95$search_date_end = dol_mktime(23, 59, 59, $search_date_endmonth, $search_date_endday, $search_date_endyear);
96$optioncss = GETPOST('optioncss', 'alpha');
97$socid = GETPOSTINT('socid');
98
99$diroutputmassaction = $conf->ficheinter->dir_output.'/temp/massgeneration/'.$user->id;
100
101// Load variable for pagination
102$limit = GETPOSTINT('limit') ? GETPOSTINT('limit') : $conf->liste_limit;
103$sortfield = GETPOST('sortfield', 'aZ09comma');
104$sortorder = GETPOST('sortorder', 'aZ09comma');
105$page = GETPOSTISSET('pageplusone') ? (GETPOSTINT('pageplusone') - 1) : GETPOSTINT("page");
106if (empty($page) || $page < 0 || GETPOST('button_search', 'alpha') || GETPOST('button_removefilter', 'alpha')) {
107 // If $page is not defined, or '' or -1 or if we click on clear filters
108 $page = 0;
109}
110$offset = $limit * $page;
111$pageprev = $page - 1;
112$pagenext = $page + 1;
113if (!$sortorder) {
114 $sortorder = "DESC";
115}
116if (!$sortfield) {
117 $sortfield = "f.ref";
118}
119
120// Initialize a technical object to manage hooks of page. Note that conf->hooks_modules contains an array of hook context
121$object = new Fichinter($db);
122$hookmanager->initHooks(array($contextpage)); // Note that conf->hooks_modules contains array of activated contexes
123
124$extrafields = new ExtraFields($db);
125
126// Fetch optionals attributes and labels
127$extrafields->fetch_name_optionals_label($object->table_element);
128
129$search_array_options = $extrafields->getOptionalsFromPost($object->table_element, '', 'search_');
130
131// List of fields to search into when doing a "search in all"
132$fieldstosearchall = array(
133 'f.ref' => 'Ref',
134 's.nom' => "ThirdParty",
135 'f.description' => 'Description',
136 'f.note_public' => 'NotePublic',
137 'fd.description' => 'DescriptionOfLine',
138);
139if (empty($user->socid)) {
140 $fieldstosearchall["f.note_private"] = "NotePrivate";
141}
142if (getDolGlobalString('FICHINTER_DISABLE_DETAILS')) {
143 unset($fieldstosearchall['fd.description']);
144}
145
146// Definition of fields for list
147$arrayfields = array(
148 'f.ref' => array('label' => 'Ref', 'checked' => '1'),
149 'f.ref_client' => array('label' => 'RefCustomer', 'checked' => '1'),
150 's.nom' => array('label' => 'ThirdParty', 'checked' => '1'),
151 'pr.ref' => array('label' => 'Project', 'checked' => '1', 'enabled' => (!isModEnabled('project') ? '0' : '1')),
152 'c.ref' => array('label' => 'Contract', 'checked' => '1', 'enabled' => (empty($conf->contrat->enabled) ? '0' : '1')),
153 'f.description' => array('label' => 'Description', 'checked' => '1'),
154 'f.datec' => array('label' => 'DateCreation', 'checked' => '0', 'position' => 500),
155 'f.tms' => array('label' => 'DateModificationShort', 'checked' => '0', 'position' => 500),
156 'f.note_public' => array('label' => 'NotePublic', 'checked' => '0', 'position' => 510, 'enabled' => (string) (!getDolGlobalInt('MAIN_LIST_HIDE_PUBLIC_NOTES'))),
157 'f.note_private' => array('label' => 'NotePrivate', 'checked' => '0', 'position' => 511, 'enabled' => (string) (!getDolGlobalInt('MAIN_LIST_HIDE_PRIVATE_NOTES'))),
158 'f.fk_statut' => array('label' => 'Status', 'checked' => '1', 'position' => 1000),
159 'f.signed_status' => array('label' => 'SignedStatus', 'checked' => '0', 'position' => 1001),
160 'fd.description' => array('label' => "DescriptionOfLine", 'checked' => '1', 'enabled' => getDolGlobalString('FICHINTER_DISABLE_DETAILS') != '1' ? '1' : '0'),
161 'fd.date' => array('label' => 'DateOfLine', 'checked' => '1', 'enabled' => getDolGlobalString('FICHINTER_DISABLE_DETAILS') != '1' ? '1' : '0'),
162 'fd.duree' => array('label' => 'DurationOfLine', 'type' => 'duration', 'checked' => '1', 'enabled' => !getDolGlobalString('FICHINTER_DISABLE_DETAILS') ? '1' : '0'), //type duration is here because in database, column 'duree' is double
163);
164// Extra fields
165include DOL_DOCUMENT_ROOT.'/core/tpl/extrafields_list_array_fields.tpl.php';
166
167$object->fields = dol_sort_array($object->fields, 'position');
168$arrayfields = dol_sort_array($arrayfields, 'position');
169
170// Security check
171$id = GETPOSTINT('id');
172if ($user->socid) {
173 $socid = $user->socid;
174}
175$result = restrictedArea($user, 'ficheinter', $id, 'fichinter');
176
177$permissiontoreadallthirdparty = $user->hasRight('societe', 'client', 'voir');
178$permissiontoread = $user->hasRight('ficheinter', 'lire');
179$permissiontoadd = $user->hasRight('ficheinter', 'creer');
180$permissiontodelete = $user->hasRight('ficheinter', 'supprimer');
181
182
183/*
184 * Actions
185 */
186
187if (GETPOST('cancel', 'alpha')) {
188 $action = 'list';
189 $massaction = '';
190}
191if (!GETPOST('confirmmassaction', 'alpha') && $massaction != 'presend' && $massaction != 'confirm_presend') {
192 $massaction = '';
193}
194
195$parameters = array('socid' => $socid, 'arrayfields' => &$arrayfields);
196$reshook = $hookmanager->executeHooks('doActions', $parameters, $object, $action); // Note that $action and $object may have been modified by some hooks
197if ($reshook < 0) {
198 setEventMessages($hookmanager->error, $hookmanager->errors, 'errors');
199}
200
201if (empty($reshook)) {
202 // Selection of new fields
203 include DOL_DOCUMENT_ROOT.'/core/actions_changeselectedfields.inc.php';
204
205 // Purge search criteria
206 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
207 $search_ref = "";
208 $search_ref_client = "";
209 $search_company = "";
210 $search_projet_ref = "";
211 $search_contrat_ref = "";
212 $search_desc = "";
213 $search_status = "";
214 $search_signed_status = '';
215 $search_date_startday = '';
216 $search_date_startmonth = '';
217 $search_date_startyear = '';
218 $search_date_endday = '';
219 $search_date_endmonth = '';
220 $search_date_endyear = '';
221 $search_date_start = '';
222 $search_date_end = '';
223 $toselect = array();
224 $search_array_options = array();
225 }
226
227 // Mass actions
228 $objectclass = 'Fichinter';
229 $objectlabel = 'Interventions';
230 $uploaddir = $conf->ficheinter->dir_output;
231 include DOL_DOCUMENT_ROOT.'/core/actions_massactions.inc.php';
232}
233
234
235
236/*
237 * View
238 */
239
240
241$form = new Form($db);
242$formfile = new FormFile($db);
243$objectstatic = new Fichinter($db);
244$companystatic = new Societe($db);
245$projetstatic = null;
246$contratstatic = null;
247if (isModEnabled('project')) {
248 $projetstatic = new Project($db);
249}
250if (isModEnabled('contract')) {
251 $contratstatic = new Contrat($db);
252}
253
254$now = dol_now();
255
256$title = $langs->trans("Interventions");
257$help_url = '';
258$morejs = array();
259$morecss = array();
260
261
262$varpage = empty($contextpage) ? $_SERVER["PHP_SELF"] : $contextpage;
263$selectedfields = $form->multiSelectArrayWithCheckbox('selectedfields', $arrayfields, $varpage); // This also change content of $arrayfields
264
265$atleastonefieldinlines = 0;
266foreach ($arrayfields as $tmpkey => $tmpval) {
267 if (preg_match('/^fd\./', $tmpkey) && !empty($arrayfields[$tmpkey]['checked'])) {
268 $atleastonefieldinlines++;
269 break;
270 }
271}
272// The table of lines is joined only if a field of lines is shown, so do not search into it otherwise
273if (!$atleastonefieldinlines) {
274 unset($fieldstosearchall['fd.description']);
275}
276
277$sql = "SELECT";
278$sql .= " f.ref, f.ref_client, f.rowid, f.fk_statut as status, f.signed_status as signed_status, f.description, f.datec as date_creation, f.tms as date_modification, f.note_public, f.note_private,";
279if (!getDolGlobalString('FICHINTER_DISABLE_DETAILS') && $atleastonefieldinlines) {
280 $sql .= " fd.rowid as lineid, fd.description as descriptiondetail, fd.date as dp, fd.duree,";
281}
282$sql .= " s.nom as name, s.rowid as socid, s.client, s.fournisseur, s.email, s.status as thirdpartystatus";
283if (isModEnabled('project')) {
284 $sql .= ", pr.rowid as projet_id, pr.ref as projet_ref, pr.title as projet_title";
285}
286if (isModEnabled('contract')) {
287 $sql .= ", c.rowid as contrat_id, c.ref as contrat_ref, c.ref_customer as contrat_ref_customer, c.ref_supplier as contrat_ref_supplier";
288}
289// Add fields from extrafields
290if (!empty($extrafields->attributes[$object->table_element]['label'])) {
291 foreach ($extrafields->attributes[$object->table_element]['label'] as $key => $val) {
292 $sql .= ($extrafields->attributes[$object->table_element]['type'][$key] != 'separate' ? ", ef.".$key." as options_".$key : '');
293 }
294}
295// Add fields from hooks
296$parameters = array();
297$reshook = $hookmanager->executeHooks('printFieldListSelect', $parameters, $object, $action); // Note that $action and $object may have been modified by hook
298$sql .= $hookmanager->resPrint;
299
300$sqlfields = $sql; // $sql fields to remove for count total
301
302$sql .= " FROM ".MAIN_DB_PREFIX."fichinter as f";
303if (isModEnabled('project')) {
304 $sql .= " LEFT JOIN ".MAIN_DB_PREFIX."projet as pr on f.fk_projet = pr.rowid";
305}
306if (isModEnabled('contract')) {
307 $sql .= " LEFT JOIN ".MAIN_DB_PREFIX."contrat as c on f.fk_contrat = c.rowid";
308}
309if (isset($extrafields->attributes[$object->table_element]['label']) && is_array($extrafields->attributes[$object->table_element]['label']) && count($extrafields->attributes[$object->table_element]['label'])) {
310 $sql .= " LEFT JOIN ".MAIN_DB_PREFIX.$object->table_element."_extrafields as ef on (f.rowid = ef.fk_object)";
311}
312if (!getDolGlobalString('FICHINTER_DISABLE_DETAILS') && $atleastonefieldinlines) {
313 $sql .= " LEFT JOIN ".MAIN_DB_PREFIX."fichinterdet as fd ON fd.fk_fichinter = f.rowid";
314}
315
316// Add table from hooks
317$parameters = array();
318$reshook = $hookmanager->executeHooks('printFieldListFrom', $parameters, $object, $action); // Note that $action and $object may have been modified by hook
319$sql .= $hookmanager->resPrint;
320
321if (empty($user->socid) && !$user->hasRight('societe', 'client', 'voir')) {
322 $sql .= ", ".MAIN_DB_PREFIX."societe_commerciaux as sc";
323}
324$sql .= ", ".MAIN_DB_PREFIX."societe as s";
325$sql .= " WHERE f.entity IN (".getEntity('intervention').")";
326$sql .= " AND f.fk_soc = s.rowid";
327if ($search_ref) {
328 $sql .= natural_search('f.ref', $search_ref);
329}
330if ($search_ref_client) {
331 $sql .= natural_search('f.ref_client', $search_ref_client);
332}
333if ($search_company) {
334 $sql .= natural_search('s.nom', $search_company);
335}
336if ($search_projet_ref) {
337 $sql .= natural_search('pr.ref', $search_projet_ref);
338}
339if ($search_contrat_ref) {
340 $sql .= natural_search('c.ref', $search_contrat_ref);
341}
342if ($search_desc) {
343 if (!getDolGlobalString('FICHINTER_DISABLE_DETAILS') && $atleastonefieldinlines) {
344 $sql .= natural_search(array('f.description', 'fd.description'), $search_desc);
345 } else {
346 $sql .= natural_search(array('f.description'), $search_desc);
347 }
348}
349if ($search_status != '' && $search_status >= 0) {
350 $sql .= ' AND f.fk_statut = '.((int) ($search_status));
351}
352if ($search_signed_status != '' && $search_signed_status >= 0) {
353 $sql .= ' AND f.signed_status = '.((int) $search_signed_status);
354}
355if (!getDolGlobalString('FICHINTER_DISABLE_DETAILS') && $atleastonefieldinlines) {
356 if ($search_date_start) {
357 $sql .= " AND fd.date >= '".$db->idate($search_date_start)."'";
358 }
359 if ($search_date_end) {
360 $sql .= " AND fd.date <= '".$db->idate($search_date_end)."'";
361 }
362}
363if ($socid > 0) {
364 $sql .= " AND s.rowid = ".((int) $socid);
365}
366// Restriction on sale representative
367if (empty($user->socid) && !$permissiontoreadallthirdparty) {
368 $sql .= " AND (EXISTS (SELECT sc.fk_soc FROM ".MAIN_DB_PREFIX."societe_commerciaux as sc WHERE sc.fk_soc = c.fk_soc AND sc.fk_user = ".((int) $user->id).")";
369 if (getDolGlobalInt('MAIN_SEE_SUBORDINATES') && $userschilds) {
370 $sql .= " OR EXISTS (SELECT sc.fk_soc FROM ".MAIN_DB_PREFIX."societe_commerciaux as sc WHERE sc.fk_soc = c.fk_soc AND sc.fk_user IN (".$db->sanitize(implode(',', $userschilds))."))";
371 }
372 $sql .= ")";
373}
374
375if ($search_all) {
376 $sql .= natural_search(array_keys($fieldstosearchall), $search_all);
377}
378// Search on sale representative
379/*
380if ($search_sale && $search_sale != '-1') {
381 if ($search_sale == -2) {
382 $sql .= " AND NOT EXISTS (SELECT sc.fk_soc FROM ".MAIN_DB_PREFIX."societe_commerciaux as sc WHERE sc.fk_soc = f.fk_soc)";
383 } elseif ($search_sale > 0) {
384 $sql .= " AND EXISTS (SELECT sc.fk_soc FROM ".MAIN_DB_PREFIX."societe_commerciaux as sc WHERE sc.fk_soc = f.fk_soc AND sc.fk_user = ".((int) $search_sale).")";
385 }
386}*/
387// Add where from extra fields
388include DOL_DOCUMENT_ROOT.'/core/tpl/extrafields_list_search_sql.tpl.php';
389// Add where from hooks
390$parameters = array();
391$reshook = $hookmanager->executeHooks('printFieldListWhere', $parameters, $object, $action); // Note that $action and $object may have been modified by hook
392$sql .= $hookmanager->resPrint;
393// Add GroupBy from hooks
394$parameters = array('search_all' => $search_all, 'fieldstosearchall' => $fieldstosearchall);
395$reshook = $hookmanager->executeHooks('printFieldListGroupBy', $parameters, $object); // Note that $action and $object may have been modified by hook
396$sql .= $hookmanager->resPrint;
397
398// Count total nb of records
399$nbtotalofrecords = '';
400if (!getDolGlobalInt('MAIN_DISABLE_FULL_SCANLIST')) {
401 /* The fast and low memory method to get and count full list converts the sql into a sql count */
402 $sqlforcount = preg_replace('/^'.preg_quote($sqlfields, '/').'/', 'SELECT COUNT(*) as nbtotalofrecords', $sql);
403 $sqlforcount = preg_replace('/GROUP BY .*$/', '', $sqlforcount);
404 $resql = $db->query($sqlforcount);
405 if ($resql) {
406 $objforcount = $db->fetch_object($resql);
407 $nbtotalofrecords = $objforcount->nbtotalofrecords;
408 } else {
409 dol_print_error($db);
410 }
411
412 if (($page * $limit) > $nbtotalofrecords) { // if total resultset is smaller than the paging size (filtering), goto and load page 0
413 $page = 0;
414 $offset = 0;
415 }
416 $db->free($resql);
417}
418
419// Complete request and execute it with limit
420$sql .= $db->order($sortfield, $sortorder);
421if ($limit) {
422 $sql .= $db->plimit($limit + 1, $offset);
423}
424
425$resql = $db->query($sql);
426if (!$resql) {
427 dol_print_error($db);
428 exit;
429}
430
431$num = $db->num_rows($resql);
432
433
434// Direct jump if only one record found
435if ($num == 1 && getDolGlobalString('MAIN_SEARCH_DIRECT_OPEN_IF_ONLY_ONE') && $search_all && !$page) {
436 $obj = $db->fetch_object($resql);
437 $id = $obj->rowid;
438 header("Location: ".dol_buildpath('/fichinter/card.php', 1).'?id='.$id);
439 exit;
440}
441
442
443// Output page
444// --------------------------------------------------------------------
445
446llxHeader('', $title, $help_url, '', 0, 0, $morejs, $morecss, '', 'bodyforlist mod-fichinter page-list'); // Can use also classforhorizontalscrolloftabs instead of bodyforlist for no horizontal scroll
447
448
449$arrayofselected = is_array($toselect) ? $toselect : array();
450
451if ($socid > 0) {
452 $soc = new Societe($db);
453 $soc->fetch($socid);
454 if (empty($search_company)) {
455 $search_company = $soc->name;
456 }
457}
458
459$param = '';
460if (!empty($mode)) {
461 $param .= '&mode='.urlencode($mode);
462}
463if (!empty($contextpage) && $contextpage != $_SERVER["PHP_SELF"]) {
464 $param .= '&contextpage='.urlencode($contextpage);
465}
466if ($limit > 0 && $limit != $conf->liste_limit) {
467 $param .= '&limit='.((int) $limit);
468}
469if ($search_all) {
470 $param .= "&search_all=".urlencode($search_all);
471}
472if ($socid) {
473 $param .= "&socid=".urlencode((string) ($socid));
474}
475if ($search_ref) {
476 $param .= "&search_ref=".urlencode($search_ref);
477}
478if ($search_ref_client) {
479 $param .= "&search_ref_client=".urlencode($search_ref_client);
480}
481if ($search_company) {
482 $param .= "&search_company=".urlencode($search_company);
483}
484if ($search_desc) {
485 $param .= "&search_desc=".urlencode($search_desc);
486}
487if ($search_projet_ref) {
488 $param .= "&search_projet_ref=".urlencode($search_projet_ref);
489}
490if ($search_contrat_ref) {
491 $param .= "&search_contrat_ref=".urlencode($search_contrat_ref);
492}
493if ($search_status != '' && $search_status > -1) {
494 $param .= "&search_status=".urlencode($search_status);
495}
496if ($search_signed_status != '' && $search_signed_status >= 0) {
497 $param .= '&search_signed_status='.urlencode($search_signed_status);
498}
499if ($search_date_startday > 0) {
500 $param .= '&search_date_startday='.urlencode((string) ($search_date_startday));
501}
502if ($search_date_startmonth > 0) {
503 $param .= '&search_date_startmonth='.urlencode((string) ($search_date_startmonth));
504}
505if ($search_date_startyear > 0) {
506 $param .= '&search_date_startyear='.urlencode((string) ($search_date_startyear));
507}
508if ($search_date_endday > 0) {
509 $param .= '&search_date_endday='.urlencode((string) ($search_date_endday));
510}
511if ($search_date_endmonth > 0) {
512 $param .= '&search_date_endmonth='.urlencode((string) ($search_date_endmonth));
513}
514if ($search_date_endyear > 0) {
515 $param .= '&search_date_endyear='.urlencode((string) ($search_date_endyear));
516}
517if ($show_files) {
518 $param .= '&show_files='.urlencode((string) ($show_files));
519}
520if ($optioncss != '') {
521 $param .= '&optioncss='.urlencode($optioncss);
522}
523// Add $param from extra fields
524include DOL_DOCUMENT_ROOT.'/core/tpl/extrafields_list_search_param.tpl.php';
525// Add $param from hooks
526$parameters = array('param' => &$param);
527$reshook = $hookmanager->executeHooks('printFieldListSearchParam', $parameters, $object, $action); // Note that $action and $object may have been modified by hook
528$param .= $hookmanager->resPrint;
529
530// List of mass actions available
531$arrayofmassactions = array(
532 'generate_doc' => img_picto('', 'pdf', 'class="pictofixedwidth"').$langs->trans("ReGeneratePDF"),
533 'builddoc' => img_picto('', 'pdf', 'class="pictofixedwidth"').$langs->trans("PDFMerge"),
534 //'presend'=>$langs->trans("SendByMail"),
535);
536if (!empty($permissiontodelete)) {
537 $arrayofmassactions['predelete'] = img_picto('', 'delete', 'class="pictofixedwidth"').$langs->trans("Delete");
538}
539if (GETPOSTINT('nomassaction') || in_array($massaction, array('presend', 'predelete'))) {
540 $arrayofmassactions = array();
541}
542$massactionbutton = $form->selectMassAction('', $arrayofmassactions);
543
544
545print '<form method="POST" id="searchFormList" action="'.$_SERVER["PHP_SELF"].'">'."\n";
546if ($optioncss != '') {
547 print '<input type="hidden" name="optioncss" value="'.$optioncss.'">';
548}
549print '<input type="hidden" name="token" value="'.newToken().'">';
550print '<input type="hidden" name="formfilteraction" id="formfilteraction" value="list">';
551print '<input type="hidden" name="action" value="list">';
552print '<input type="hidden" name="sortfield" value="'.$sortfield.'">';
553print '<input type="hidden" name="sortorder" value="'.$sortorder.'">';
554print '<input type="hidden" name="page" value="'.$page.'">';
555print '<input type="hidden" name="contextpage" value="'.$contextpage.'">';
556print '<input type="hidden" name="page_y" value="">';
557print '<input type="hidden" name="mode" value="'.$mode.'">';
558
559$newcardbutton = '';
560$url = DOL_URL_ROOT.'/fichinter/card.php?action=create';
561if (!empty($socid)) {
562 $url .= '&socid='.$socid;
563}
564$newcardbutton = '';
565$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'));
566$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'));
567$newcardbutton .= dolGetButtonTitleSeparator();
568$newcardbutton .= dolGetButtonTitle($langs->trans('NewIntervention'), '', 'fa fa-plus-circle', $url, '', $user->hasRight('ficheinter', 'creer'));
569
570print_barre_liste($title, $page, $_SERVER['PHP_SELF'], $param, $sortfield, $sortorder, $massactionbutton, $num, $nbtotalofrecords, 'object_'.$object->picto, 0, $newcardbutton, '', $limit, 0, 0, 1);
571
572$topicmail = "Information";
573$modelmail = "intervention";
574$objecttmp = new Fichinter($db);
575$trackid = 'int'.$object->id;
576include DOL_DOCUMENT_ROOT.'/core/tpl/massactions_pre.tpl.php';
577
578if ($search_all) {
579 $setupstring = '';
580 foreach ($fieldstosearchall as $key => $val) {
581 $fieldstosearchall[$key] = $langs->trans($val);
582 $setupstring .= $key."=".$val.";";
583 }
584 print '<!-- Search done like if MYOBJECT_QUICKSEARCH_ON_FIELDS = '.$setupstring.' -->'."\n";
585 print '<div class="divsearchfieldfilter">'.$langs->trans("FilterOnInto", $search_all).implode(', ', $fieldstosearchall).'</div>'."\n";
586}
587
588$moreforfilter = '';
589
590$parameters = array();
591$reshook = $hookmanager->executeHooks('printFieldPreListTitle', $parameters, $object, $action); // Note that $action and $object may have been modified by hook
592if (empty($reshook)) {
593 $moreforfilter .= $hookmanager->resPrint;
594} else {
595 $moreforfilter = $hookmanager->resPrint;
596}
597
598if (!empty($moreforfilter)) {
599 print '<div class="liste_titre liste_titre_bydiv centpercent">';
600 print $moreforfilter;
601 print '</div>';
602}
603
604$varpage = empty($contextpage) ? $_SERVER["PHP_SELF"] : $contextpage;
605$htmlofselectarray = $form->multiSelectArrayWithCheckbox('selectedfields', $arrayfields, $varpage, getDolGlobalString('MAIN_CHECKBOX_LEFT_COLUMN')); // This also change content of $arrayfields with user setup
606$selectedfields = ($mode != 'kanban' ? $htmlofselectarray : '');
607$selectedfields .= (count($arrayofmassactions) ? $form->showCheckAddButtons('checkforselect', 1) : '');
608
609print '<div class="div-table-responsive">';
610print '<table class="tagtable nobottomiftotal liste'.($moreforfilter ? " listwithfilterbefore" : "").'">'."\n";
611
612// Fields title search
613// --------------------------------------------------------------------
614print '<tr class="liste_titre_filter">';
615// Action column
616if (getDolGlobalString('MAIN_CHECKBOX_LEFT_COLUMN')) {
617 print '<td class="liste_titre center maxwidthsearch">';
618 $searchpicto = $form->showFilterButtons('left');
619 print $searchpicto;
620 print '</td>';
621}
622if (!empty($arrayfields['f.ref']['checked'])) {
623 print '<td class="liste_titre">';
624 print '<input type="text" class="flat" name="search_ref" value="'.$search_ref.'" size="8">';
625 print '</td>';
626}
627if (!empty($arrayfields['f.ref_client']['checked'])) {
628 print '<td class="liste_titre">';
629 print '<input type="text" class="flat" name="search_ref_client" value="'.$search_ref_client.'" size="8">';
630 print '</td>';
631}
632if (!empty($arrayfields['s.nom']['checked'])) {
633 print '<td class="liste_titre">';
634 print '<input type="text" class="flat" name="search_company" value="'.$search_company.'" size="10">';
635 print '</td>';
636}
637if (!empty($arrayfields['pr.ref']['checked'])) {
638 print '<td class="liste_titre">';
639 print '<input type="text" class="flat" name="search_projet_ref" value="'.$search_projet_ref.'" size="8">';
640 print '</td>';
641}
642if (!empty($arrayfields['c.ref']['checked'])) {
643 print '<td class="liste_titre">';
644 print '<input type="text" class="flat" name="search_contrat_ref" value="'.$search_contrat_ref.'" size="8">';
645 print '</td>';
646}
647if (!empty($arrayfields['f.description']['checked'])) {
648 print '<td class="liste_titre">';
649 print '<input type="text" class="flat" name="search_desc" value="'.$search_desc.'" size="12">';
650 print '</td>';
651}
652// Extra fields
653include DOL_DOCUMENT_ROOT.'/core/tpl/extrafields_list_search_input.tpl.php';
654
655// Fields from hook
656$parameters = array('arrayfields' => $arrayfields);
657$reshook = $hookmanager->executeHooks('printFieldListOption', $parameters, $object, $action); // Note that $action and $object may have been modified by hook
658print $hookmanager->resPrint;
659if (!empty($arrayfields['f.datec']['checked'])) {
660 // Date creation
661 print '<td class="liste_titre">';
662 print '</td>';
663}
664if (!empty($arrayfields['f.tms']['checked'])) {
665 // Date modification
666 print '<td class="liste_titre">';
667 print '</td>';
668}
669if (!empty($arrayfields['f.note_public']['checked'])) {
670 // Note public
671 print '<td class="liste_titre">';
672 print '</td>';
673}
674if (!empty($arrayfields['f.note_private']['checked'])) {
675 // Note private
676 print '<td class="liste_titre">';
677 print '</td>';
678}
679// Status
680if (!empty($arrayfields['f.fk_statut']['checked'])) {
681 print '<td class="liste_titre right parentonrightofpage">';
682 $liststatus = [
683 $object::STATUS_DRAFT => $langs->transnoentitiesnoconv('Draft'),
684 $object::STATUS_VALIDATED => $langs->transnoentitiesnoconv('Validated'),
685 $object::STATUS_BILLED => $langs->transnoentitiesnoconv('StatusInterInvoiced'),
686 $object::STATUS_CLOSED => $langs->transnoentitiesnoconv('Done'),
687 ];
688 if (!getDolGlobalString('FICHINTER_CLASSIFY_BILLED')) {
689 unset($liststatus[2]); // Option deprecated. In a future, billed must be managed with a dedicated field to 0 or 1
690 }
691 // @phan-suppress-next-line PhanPluginSuspiciousParamOrder
692 print $form->selectarray('search_status', $liststatus, $search_status, 1, 0, 0, '', 1, 0, 0, '', 'search_status width100 onrightofpage');
693 print '</td>';
694}
695// Signed status
696if (!empty($arrayfields['f.signed_status']['checked'])) {
697 print '<td class="liste_titre center">';
698 $list_signed_status = $object->getSignedStatusLocalisedArray();
699 print $form->selectarray('search_signed_status', $list_signed_status, $search_signed_status, 1, 0, 0, '', 1, 0, 0, '', 'search_status');
700 print '</td>';
701}
702// Fields of detail line
703if (!empty($arrayfields['fd.description']['checked'])) {
704 print '<td class="liste_titre">&nbsp;</td>';
705}
706if (!empty($arrayfields['fd.date']['checked'])) {
707 print '<td class="liste_titre center">';
708 print '<div class="nowrapfordate">';
709 print $form->selectDate($search_date_start ?: -1, 'search_date_start', 0, 0, 1, '', 1, 0, 0, '', '', '', '', 1, '', $langs->trans('From'));
710 print '</div>';
711 print '<div class="nowrapfordate">';
712 print $form->selectDate($search_date_end ?: -1, 'search_date_end', 0, 0, 1, '', 1, 0, 0, '', '', '', '', 1, '', $langs->trans('to'));
713 print '</div>';
714 print '</td>';
715}
716if (!empty($arrayfields['fd.duree']['checked'])) {
717 print '<td class="liste_titre">&nbsp;</td>';
718}
719// Action column
720if (!getDolGlobalString('MAIN_CHECKBOX_LEFT_COLUMN')) {
721 print '<td class="liste_titre center maxwidthsearch">';
722 $searchpicto = $form->showFilterButtons();
723 print $searchpicto;
724 print '</td>';
725}
726print '</tr>'."\n";
727
728$totalarray = array();
729$totalarray['nbfield'] = 0;
730
731// Fields title label
732// --------------------------------------------------------------------
733print '<tr class="liste_titre">';
734// Action column
735if (getDolGlobalString('MAIN_CHECKBOX_LEFT_COLUMN')) {
736 print_liste_field_titre($selectedfields, $_SERVER["PHP_SELF"], "", '', '', '', $sortfield, $sortorder, 'center maxwidthsearch ');
737 $totalarray['nbfield']++;
738}
739if (!empty($arrayfields['f.ref']['checked'])) {
740 // @phan-suppress-next-line PhanTypeInvalidDimOffset
741 print_liste_field_titre($arrayfields['f.ref']['label'], $_SERVER["PHP_SELF"], "f.ref", "", $param, '', $sortfield, $sortorder);
742 $totalarray['nbfield']++;
743}
744if (!empty($arrayfields['f.ref_client']['checked'])) {
745 print_liste_field_titre($arrayfields['f.ref_client']['label'], $_SERVER["PHP_SELF"], "f.ref_client", "", $param, '', $sortfield, $sortorder);
746 $totalarray['nbfield']++;
747}
748if (!empty($arrayfields['s.nom']['checked'])) {
749 print_liste_field_titre($arrayfields['s.nom']['label'], $_SERVER["PHP_SELF"], "s.nom", "", $param, '', $sortfield, $sortorder);
750 $totalarray['nbfield']++;
751}
752if (!empty($arrayfields['pr.ref']['checked'])) {
753 print_liste_field_titre($arrayfields['pr.ref']['label'], $_SERVER["PHP_SELF"], "pr.ref", "", $param, '', $sortfield, $sortorder);
754 $totalarray['nbfield']++;
755}
756if (!empty($arrayfields['c.ref']['checked'])) {
757 print_liste_field_titre($arrayfields['c.ref']['label'], $_SERVER["PHP_SELF"], "c.ref", "", $param, '', $sortfield, $sortorder);
758 $totalarray['nbfield']++;
759}
760if (!empty($arrayfields['f.description']['checked'])) {
761 print_liste_field_titre($arrayfields['f.description']['label'], $_SERVER["PHP_SELF"], "f.description", "", $param, '', $sortfield, $sortorder);
762 $totalarray['nbfield']++;
763}
764// Extra fields
765include DOL_DOCUMENT_ROOT.'/core/tpl/extrafields_list_search_title.tpl.php';
766// Hook fields
767$parameters = array('arrayfields' => $arrayfields, 'param' => $param, 'sortfield' => $sortfield, 'sortorder' => $sortorder, 'totalarray' => &$totalarray);
768$reshook = $hookmanager->executeHooks('printFieldListTitle', $parameters, $object, $action); // Note that $action and $object may have been modified by hook
769print $hookmanager->resPrint;
770if (!empty($arrayfields['f.datec']['checked'])) {
771 print_liste_field_titre($arrayfields['f.datec']['label'], $_SERVER["PHP_SELF"], "f.datec", "", $param, '', $sortfield, $sortorder, 'center nowrap ');
772 $totalarray['nbfield']++;
773}
774if (!empty($arrayfields['f.tms']['checked'])) {
775 print_liste_field_titre($arrayfields['f.tms']['label'], $_SERVER["PHP_SELF"], "f.tms", "", $param, '', $sortfield, $sortorder, 'center nowrap ');
776 $totalarray['nbfield']++;
777}
778if (!empty($arrayfields['f.note_public']['checked'])) {
779 print_liste_field_titre($arrayfields['f.note_public']['label'], $_SERVER["PHP_SELF"], "f.note_public", "", $param, '', $sortfield, $sortorder, 'center nowrap ');
780 $totalarray['nbfield']++;
781}
782if (!empty($arrayfields['f.note_private']['checked'])) {
783 print_liste_field_titre($arrayfields['f.note_private']['label'], $_SERVER["PHP_SELF"], "f.note_private", "", $param, '', $sortfield, $sortorder, 'center nowrap ');
784 $totalarray['nbfield']++;
785}
786if (!empty($arrayfields['f.fk_statut']['checked'])) {
787 print_liste_field_titre($arrayfields['f.fk_statut']['label'], $_SERVER["PHP_SELF"], "f.fk_statut", "", $param, '', $sortfield, $sortorder, 'center ');
788 $totalarray['nbfield']++;
789}
790if (!empty($arrayfields['f.signed_status']['checked'])) {
791 print_liste_field_titre($arrayfields['f.signed_status']['label'], $_SERVER["PHP_SELF"], "f.signed_status", "", $param, '', $sortfield, $sortorder, 'center ');
792 $totalarray['nbfield']++;
793}
794if (!empty($arrayfields['fd.description']['checked'])) {
795 print_liste_field_titre($arrayfields['fd.description']['label'], $_SERVER["PHP_SELF"], '');
796 $totalarray['nbfield']++;
797}
798if (!empty($arrayfields['fd.date']['checked'])) {
799 print_liste_field_titre($arrayfields['fd.date']['label'], $_SERVER["PHP_SELF"], "fd.date", "", $param, '', $sortfield, $sortorder, 'center ');
800 $totalarray['nbfield']++;
801}
802if (!empty($arrayfields['fd.duree']['checked'])) {
803 print_liste_field_titre($arrayfields['fd.duree']['label'], $_SERVER["PHP_SELF"], "fd.duree", "", $param, '', $sortfield, $sortorder, 'right ');
804 $totalarray['nbfield']++;
805}
806
807// Action column
808if (!getDolGlobalString('MAIN_CHECKBOX_LEFT_COLUMN')) {
809 print_liste_field_titre($selectedfields, $_SERVER["PHP_SELF"], "", '', '', '', $sortfield, $sortorder, 'center maxwidthsearch ');
810 $totalarray['nbfield']++;
811}
812print "</tr>\n";
813
814
815// Loop on record
816// --------------------------------------------------------------------
817$i = 0;
818$savnbfield = $totalarray['nbfield'];
819$totalarray = array();
820$totalarray['nbfield'] = 0;
821$totalarray['val'] = array();
822$totalarray['val']['fd.duree'] = 0;
823$total = 0;
824$imaxinloop = ($limit ? min($num, $limit) : $num);
825while ($i < $imaxinloop) {
826 $obj = $db->fetch_object($resql);
827 if (empty($obj)) {
828 break; // Should not happen
829 }
830
831 // Store properties in $object
832 //$object->setVarsFromFetchObj($obj);
833
834 $objectstatic->id = $obj->rowid;
835 $objectstatic->ref = $obj->ref;
836 $objectstatic->ref_client = $obj->ref_client;
837 $objectstatic->statut = $obj->status; // deprecated
838 $objectstatic->status = $obj->status;
839 $objectstatic->signed_status = $obj->signed_status;
840
841 $companystatic->name = $obj->name;
842 $companystatic->id = $obj->socid;
843 $companystatic->client = $obj->client;
844 $companystatic->fournisseur = $obj->fournisseur;
845 $companystatic->email = $obj->email;
846 $companystatic->status = $obj->thirdpartystatus;
847
848 //mode kanban
849 if ($mode == 'kanban') {
850 if ($i == 0) {
851 print '<tr class="trkanban"><td colspan="'.$savnbfield.'">';
852 print '<div class="box-flex-container kanban">';
853 }
854
855 // Output Kanban
856 if ($massactionbutton || $massaction) { // If we are in select mode (massactionbutton defined) or if we have already selected and sent an action ($massaction) defined
857 $selected = 0;
858 if (in_array($object->id, $arrayofselected)) {
859 $selected = 1;
860 }
861 }
862
863 $objectstatic->duration = $obj->duree;
864 $arraydata = array();
865 $arraydata['thirdparty'] = $companystatic;
866 print $objectstatic->getKanbanView('', $arraydata);
867 if ($i == ($imaxinloop - 1)) {
868 print '</div>';
869 print '</td></tr>';
870 }
871 } else {
872 // Show here line of result
873 $j = 0;
874 print '<tr data-rowid="'.$object->id.'" class="oddeven">';
875 // Action column
876 if (getDolGlobalString('MAIN_CHECKBOX_LEFT_COLUMN')) {
877 print '<td class="nowrap center">';
878 if ($massactionbutton || $massaction) { // If we are in select mode (massactionbutton defined) or if we have already selected and sent an action ($massaction) defined
879 $selected = 0;
880 if (in_array($obj->rowid, $arrayofselected)) {
881 $selected = 1;
882 }
883 print '<input id="cb'.$obj->rowid.'" class="flat checkforselect" type="checkbox" name="toselect[]" value="'.$obj->rowid.'"'.($selected ? ' checked="checked"' : '').'>';
884 }
885 print '</td>';
886 if (!$i) {
887 $totalarray['nbfield']++;
888 }
889 }
890
891 // Picto + Ref
892 if (!empty($arrayfields['f.ref']['checked'])) {
893 print "<td>";
894
895 print '<table class="nobordernopadding"><tr class="nocellnopadd">';
896 print '<td class="nobordernopadding nowraponall">';
897 print $objectstatic->getNomUrl(1);
898 print '</td>';
899 // Warning
900 $warnornote = '';
901 //if ($obj->fk_statut == 1 && $db->jdate($obj->dfv) < ($now - $conf->fichinter->warning_delay)) $warnornote.=img_warning($langs->trans("Late"));
902 if (!empty($obj->note_private)) {
903 $warnornote .= ($warnornote ? ' ' : '');
904 $warnornote .= '<span class="note">';
905 $warnornote .= '<a href="note.php?id='.$obj->rowid.'">'.img_picto($langs->trans("ViewPrivateNote"), 'object_generic').'</a>';
906 $warnornote .= '</span>';
907 }
908 if ($warnornote) {
909 print '<td style="min-width: 20px" class="nobordernopadding nowrap">';
910 print $warnornote;
911 print '</td>';
912 }
913
914 // Other picto tool
915 print '<td width="16" class="right nobordernopadding hideonsmartphone">';
916 $filename = dol_sanitizeFileName($obj->ref);
917 $filedir = $conf->ficheinter->dir_output.'/'.dol_sanitizeFileName($obj->ref);
918 $urlsource = $_SERVER['PHP_SELF'].'?id='.$obj->rowid;
919 print $formfile->getDocumentsLink($objectstatic->element, $filename, $filedir);
920 print '</td></tr></table>';
921
922 print "</td>\n";
923 if (!$i) {
924 $totalarray['nbfield']++;
925 }
926 }
927
928 // Customer ref
929 if (!empty($arrayfields['f.ref_client']['checked'])) {
930 print '<td class="nowrap tdoverflowmax200">';
931 print dol_escape_htmltag($obj->ref_client);
932 print '</td>';
933 if (!$i) {
934 $totalarray['nbfield']++;
935 }
936 }
937 // Third party
938 if (!empty($arrayfields['s.nom']['checked'])) {
939 print '<td class="tdoverflowmax125">';
940 print $companystatic->getNomUrl(1, '', 44);
941 print '</td>';
942 if (!$i) {
943 $totalarray['nbfield']++;
944 }
945 }
946 // Project ref
947 if (!empty($arrayfields['pr.ref']['checked']) && $projetstatic !== null) {
948 print '<td class="tdoverflowmax150">';
949 $projetstatic->id = $obj->projet_id;
950 $projetstatic->ref = $obj->projet_ref;
951 $projetstatic->title = $obj->projet_title;
952 if ($projetstatic->id > 0) {
953 print $projetstatic->getNomUrl(1, '');
954 }
955 print '</td>';
956 if (!$i) {
957 $totalarray['nbfield']++;
958 }
959 }
960 // Contract
961 if (!empty($arrayfields['c.ref']['checked']) && $contratstatic !== null) {
962 print '<td class="tdoverflowmax150">';
963 $contratstatic->id = $obj->contrat_id;
964 $contratstatic->ref = $obj->contrat_ref;
965 $contratstatic->ref_customer = $obj->contrat_ref_customer;
966 $contratstatic->ref_supplier = $obj->contrat_ref_supplier;
967 if ($contratstatic->id > 0) {
968 print $contratstatic->getNomUrl(1, 0);
969 print '</td>';
970 }
971 if (!$i) {
972 $totalarray['nbfield']++;
973 }
974 }
975 if (!empty($arrayfields['f.description']['checked'])) {
976 print '<td>'.dol_trunc(dolGetFirstLineOfText(dol_string_nohtmltag($obj->description, 1)), 48).'</td>';
977 if (!$i) {
978 $totalarray['nbfield']++;
979 }
980 }
981
982 // Extra fields
983 include DOL_DOCUMENT_ROOT.'/core/tpl/extrafields_list_print_fields.tpl.php';
984 // Fields from hook
985 $parameters = array('arrayfields' => $arrayfields, 'obj' => $obj, 'i' => $i, 'totalarray' => &$totalarray);
986 $reshook = $hookmanager->executeHooks('printFieldListValue', $parameters); // Note that $action and $object may have been modified by hook
987 print $hookmanager->resPrint;
988 // Date creation
989 if (!empty($arrayfields['f.datec']['checked'])) {
990 print '<td class="center nowraponall">';
991 print dol_print_date($db->jdate($obj->date_creation), 'dayhour', 'tzuser');
992 print '</td>';
993 if (!$i) {
994 $totalarray['nbfield']++;
995 }
996 }
997 // Date modification
998 if (!empty($arrayfields['f.tms']['checked'])) {
999 print '<td class="center nowraponall">';
1000 print dol_print_date($db->jdate($obj->date_modification), 'dayhour', 'tzuser');
1001 print '</td>';
1002 if (!$i) {
1003 $totalarray['nbfield']++;
1004 }
1005 }
1006 // Note public
1007 if (!empty($arrayfields['f.note_public']['checked'])) {
1008 print '<td class="sensiblehtmlcontent center">';
1009 print '<div class="small lineheightsmall twolinesmax-normallineheight">'.dolPrintHTML(dolGetFirstLineOfText($obj->note_public, 5)).'</div>';
1010 print '</td>';
1011 if (!$i) {
1012 $totalarray['nbfield']++;
1013 }
1014 }
1015 // Note private
1016 if (!empty($arrayfields['f.note_private']['checked'])) {
1017 print '<td class="sensiblehtmlcontent center">';
1018 print '<div class="small lineheightsmall twolinesmax-normallineheight">'.dolPrintHTML(dolGetFirstLineOfText($obj->note_private, 5)).'</div>';
1019 print '</td>';
1020 if (!$i) {
1021 $totalarray['nbfield']++;
1022 }
1023 }
1024 // Status
1025 if (!empty($arrayfields['f.fk_statut']['checked'])) {
1026 print '<td class="center">'.$objectstatic->getLibStatut(5).'</td>';
1027 if (!$i) {
1028 $totalarray['nbfield']++;
1029 }
1030 }
1031 // Signed Status
1032 if (!empty($arrayfields['f.signed_status']['checked'])) {
1033 print '<td class="center">'.$objectstatic->getLibSignedStatus(5).'</td>';
1034 if (!$i) {
1035 $totalarray['nbfield']++;
1036 }
1037 }
1038 // Fields of detail of line
1039 if (!empty($arrayfields['fd.description']['checked'])) {
1040 $text = dolGetFirstLineOfText(dol_string_nohtmltag($obj->descriptiondetail, 1));
1041 print '<td>';
1042 print '<div class="classfortooltip tdoverflowmax250 small" title="'.dol_escape_htmltag($obj->descriptiondetail, 1, 1).'">';
1043 print dol_escape_htmltag($text);
1044 print '</div>';
1045 print '</td>';
1046 if (!$i) {
1047 $totalarray['nbfield']++;
1048 }
1049 }
1050 // Date line
1051 if (!empty($arrayfields['fd.date']['checked'])) {
1052 print '<td class="center nowraponall" title="'.dol_print_date($db->jdate($obj->dp), 'dayhour').'">'.dol_print_date($db->jdate($obj->dp), 'dayhour')."</td>\n";
1053 if (!$i) {
1054 $totalarray['nbfield']++;
1055 }
1056 }
1057 // Duration line
1058 if (!empty($arrayfields['fd.duree']['checked'])) {
1059 print '<td class="right">'.convertSecondToTime($obj->duree, 'allhourmin').'</td>';
1060 if (!$i) {
1061 $totalarray['nbfield']++;
1062 }
1063 if (!$i) {
1064 $totalarray['type'][$totalarray['nbfield']] = 'duration';
1065 }
1066 if (!$i) {
1067 $totalarray['pos'][$totalarray['nbfield']] = 'fd.duree';
1068 }
1069 $totalarray['val']['fd.duree'] += $obj->duree;
1070 }
1071 // Action column
1072 if (!getDolGlobalString('MAIN_CHECKBOX_LEFT_COLUMN')) {
1073 print '<td class="nowrap center">';
1074 if ($massactionbutton || $massaction) { // If we are in select mode (massactionbutton defined) or if we have already selected and sent an action ($massaction) defined
1075 $selected = 0;
1076 if (in_array($obj->rowid, $arrayofselected)) {
1077 $selected = 1;
1078 }
1079 print '<input id="cb'.$obj->rowid.'" class="flat checkforselect" type="checkbox" name="toselect[]" value="'.$obj->rowid.'"'.($selected ? ' checked="checked"' : '').'>';
1080 }
1081 print '</td>';
1082 if (!$i) {
1083 $totalarray['nbfield']++;
1084 }
1085 }
1086
1087 print '</tr>'."\n";
1088
1089 $total += (isset($obj->duree) ? $obj->duree : 0);
1090 }
1091 $i++;
1092}
1093
1094
1095// Show total line
1096include DOL_DOCUMENT_ROOT.'/core/tpl/list_print_total.tpl.php';
1097
1098// If no record found
1099if ($num == 0) {
1100 $colspan = 1;
1101 foreach ($arrayfields as $key => $val) {
1102 if (!empty($val['checked'])) {
1103 $colspan++;
1104 }
1105 }
1106 print '<tr><td colspan="'.$colspan.'"><span class="opacitymedium">'.$langs->trans("NoRecordFound").'</span></td></tr>';
1107}
1108
1109$db->free($resql);
1110
1111$parameters = array('arrayfields' => $arrayfields, 'sql' => $sql);
1112$reshook = $hookmanager->executeHooks('printFieldListFooter', $parameters, $object, $action); // Note that $action and $object may have been modified by hook
1113print $hookmanager->resPrint;
1114
1115print '</table>'."\n";
1116print '</div>'."\n";
1117
1118print '</form>'."\n";
1119
1120if (in_array('builddoc', array_keys($arrayofmassactions)) && ($nbtotalofrecords === '' || $nbtotalofrecords)) {
1121 $hidegeneratedfilelistifempty = 1;
1122 if ($massaction == 'builddoc' || $action == 'remove_file' || $show_files) {
1123 $hidegeneratedfilelistifempty = 0;
1124 }
1125
1126 require_once DOL_DOCUMENT_ROOT.'/core/class/html.formfile.class.php';
1127 $formfile = new FormFile($db);
1128
1129 // Show list of available documents
1130 $urlsource = $_SERVER['PHP_SELF'].'?sortfield='.$sortfield.'&sortorder='.$sortorder;
1131 $urlsource .= str_replace('&amp;', '&', $param);
1132
1133 $filedir = $diroutputmassaction;
1134 $genallowed = $permissiontoread;
1135 $delallowed = $permissiontoadd;
1136
1137 print $formfile->showdocuments('massfilesarea_interventions', '', $filedir, $urlsource, 0, $delallowed, '', 1, 1, 0, 48, 1, $param, $title, '', '', '', null, $hidegeneratedfilelistifempty);
1138}
1139
1140// End of page
1141llxFooter();
1142$db->close();
$id
Support class for third parties, contacts, members, users or resources.
Definition account.php:48
if( $user->socid > 0) if(! $user->hasRight('accounting', 'chartofaccount')) $object
Definition card.php:67
$totalarray
Definition export.php:1206
llxFooter($comment='', $zone='private', $disabledoutputofmessages=0)
Empty footer.
Definition wrapper.php:91
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:73
Class to manage standard extra fields.
Class to offer components to list and upload files.
Class to manage generation of HTML components Only common components must be here.
Class to manage projects.
Class to manage third parties objects (customers, suppliers, prospects...)
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_liste_field_titre($name, $file="", $field="", $begin="", $param="", $moreattrib="", $sortfield="", $sortorder="", $prefix="", $tooltip="", $forcenowrapcolumntitle=0)
Show 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, $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, $allowothertags=array())
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.
dolGetFirstLineOfText($text, $nboflines=1, $charset='UTF-8')
Return first line of text.
dol_string_nohtmltag($stringtoclean, $removelinefeed=1, $pagecodeto='UTF-8', $strip_tags=0, $removedoublespaces=1)
Clean a string from all HTML tags and entities.
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.
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_print_date($time, $format='', $tzoutput='auto', $outputlangs=null, $encodetooutput=false)
Output date in a string format according to outputlangs (or langs if not defined).
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...
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...
dol_sanitizeFileName($str, $newstr='_', $unaccent=1, $includequotes=0)
Clean a string to use it as a file name.
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
restrictedArea(User $user, $features, $object=0, $tableandshare='', $feature2='', $dbt_keyfield='fk_soc', $dbt_select='rowid', $isdraft=0, $mode=0)
Check permissions of a user to show a page and an object.