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
273$sql = "SELECT";
274$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,";
275if (!getDolGlobalString('FICHINTER_DISABLE_DETAILS') && $atleastonefieldinlines) {
276 $sql .= " fd.rowid as lineid, fd.description as descriptiondetail, fd.date as dp, fd.duree,";
277}
278$sql .= " s.nom as name, s.rowid as socid, s.client, s.fournisseur, s.email, s.status as thirdpartystatus";
279if (isModEnabled('project')) {
280 $sql .= ", pr.rowid as projet_id, pr.ref as projet_ref, pr.title as projet_title";
281}
282if (isModEnabled('contract')) {
283 $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";
284}
285// Add fields from extrafields
286if (!empty($extrafields->attributes[$object->table_element]['label'])) {
287 foreach ($extrafields->attributes[$object->table_element]['label'] as $key => $val) {
288 $sql .= ($extrafields->attributes[$object->table_element]['type'][$key] != 'separate' ? ", ef.".$key." as options_".$key : '');
289 }
290}
291// Add fields from hooks
292$parameters = array();
293$reshook = $hookmanager->executeHooks('printFieldListSelect', $parameters, $object, $action); // Note that $action and $object may have been modified by hook
294$sql .= $hookmanager->resPrint;
295
296$sqlfields = $sql; // $sql fields to remove for count total
297
298$sql .= " FROM ".MAIN_DB_PREFIX."fichinter as f";
299if (isModEnabled('project')) {
300 $sql .= " LEFT JOIN ".MAIN_DB_PREFIX."projet as pr on f.fk_projet = pr.rowid";
301}
302if (isModEnabled('contract')) {
303 $sql .= " LEFT JOIN ".MAIN_DB_PREFIX."contrat as c on f.fk_contrat = c.rowid";
304}
305if (isset($extrafields->attributes[$object->table_element]['label']) && is_array($extrafields->attributes[$object->table_element]['label']) && count($extrafields->attributes[$object->table_element]['label'])) {
306 $sql .= " LEFT JOIN ".MAIN_DB_PREFIX.$object->table_element."_extrafields as ef on (f.rowid = ef.fk_object)";
307}
308if (!getDolGlobalString('FICHINTER_DISABLE_DETAILS') && $atleastonefieldinlines) {
309 $sql .= " LEFT JOIN ".MAIN_DB_PREFIX."fichinterdet as fd ON fd.fk_fichinter = f.rowid";
310}
311
312// Add table from hooks
313$parameters = array();
314$reshook = $hookmanager->executeHooks('printFieldListFrom', $parameters, $object, $action); // Note that $action and $object may have been modified by hook
315$sql .= $hookmanager->resPrint;
316
317if (empty($user->socid) && !$user->hasRight('societe', 'client', 'voir')) {
318 $sql .= ", ".MAIN_DB_PREFIX."societe_commerciaux as sc";
319}
320$sql .= ", ".MAIN_DB_PREFIX."societe as s";
321$sql .= " WHERE f.entity IN (".getEntity('intervention').")";
322$sql .= " AND f.fk_soc = s.rowid";
323if ($search_ref) {
324 $sql .= natural_search('f.ref', $search_ref);
325}
326if ($search_ref_client) {
327 $sql .= natural_search('f.ref_client', $search_ref_client);
328}
329if ($search_company) {
330 $sql .= natural_search('s.nom', $search_company);
331}
332if ($search_projet_ref) {
333 $sql .= natural_search('pr.ref', $search_projet_ref);
334}
335if ($search_contrat_ref) {
336 $sql .= natural_search('c.ref', $search_contrat_ref);
337}
338if ($search_desc) {
339 if (!getDolGlobalString('FICHINTER_DISABLE_DETAILS') && $atleastonefieldinlines) {
340 $sql .= natural_search(array('f.description', 'fd.description'), $search_desc);
341 } else {
342 $sql .= natural_search(array('f.description'), $search_desc);
343 }
344}
345if ($search_status != '' && $search_status >= 0) {
346 $sql .= ' AND f.fk_statut = '.((int) ($search_status));
347}
348if ($search_signed_status != '' && $search_signed_status >= 0) {
349 $sql .= ' AND f.signed_status = '.((int) $search_signed_status);
350}
351if (!getDolGlobalString('FICHINTER_DISABLE_DETAILS') && $atleastonefieldinlines) {
352 if ($search_date_start) {
353 $sql .= " AND fd.date >= '".$db->idate($search_date_start)."'";
354 }
355 if ($search_date_end) {
356 $sql .= " AND fd.date <= '".$db->idate($search_date_end)."'";
357 }
358}
359if ($socid > 0) {
360 $sql .= " AND s.rowid = ".((int) $socid);
361}
362// Restriction on sale representative
363if (empty($user->socid) && !$permissiontoreadallthirdparty) {
364 $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).")";
365 if (getDolGlobalInt('MAIN_SEE_SUBORDINATES') && $userschilds) {
366 $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))."))";
367 }
368 $sql .= ")";
369}
370
371if ($search_all) {
372 $sql .= natural_search(array_keys($fieldstosearchall), $search_all);
373}
374// Search on sale representative
375/*
376if ($search_sale && $search_sale != '-1') {
377 if ($search_sale == -2) {
378 $sql .= " AND NOT EXISTS (SELECT sc.fk_soc FROM ".MAIN_DB_PREFIX."societe_commerciaux as sc WHERE sc.fk_soc = f.fk_soc)";
379 } elseif ($search_sale > 0) {
380 $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).")";
381 }
382}*/
383// Add where from extra fields
384include DOL_DOCUMENT_ROOT.'/core/tpl/extrafields_list_search_sql.tpl.php';
385// Add where from hooks
386$parameters = array();
387$reshook = $hookmanager->executeHooks('printFieldListWhere', $parameters, $object, $action); // Note that $action and $object may have been modified by hook
388$sql .= $hookmanager->resPrint;
389// Add GroupBy from hooks
390$parameters = array('search_all' => $search_all, 'fieldstosearchall' => $fieldstosearchall);
391$reshook = $hookmanager->executeHooks('printFieldListGroupBy', $parameters, $object); // Note that $action and $object may have been modified by hook
392$sql .= $hookmanager->resPrint;
393
394// Count total nb of records
395$nbtotalofrecords = '';
396if (!getDolGlobalInt('MAIN_DISABLE_FULL_SCANLIST')) {
397 /* The fast and low memory method to get and count full list converts the sql into a sql count */
398 $sqlforcount = preg_replace('/^'.preg_quote($sqlfields, '/').'/', 'SELECT COUNT(*) as nbtotalofrecords', $sql);
399 $sqlforcount = preg_replace('/GROUP BY .*$/', '', $sqlforcount);
400 $resql = $db->query($sqlforcount);
401 if ($resql) {
402 $objforcount = $db->fetch_object($resql);
403 $nbtotalofrecords = $objforcount->nbtotalofrecords;
404 } else {
405 dol_print_error($db);
406 }
407
408 if (($page * $limit) > $nbtotalofrecords) { // if total resultset is smaller than the paging size (filtering), goto and load page 0
409 $page = 0;
410 $offset = 0;
411 }
412 $db->free($resql);
413}
414
415// Complete request and execute it with limit
416$sql .= $db->order($sortfield, $sortorder);
417if ($limit) {
418 $sql .= $db->plimit($limit + 1, $offset);
419}
420
421$resql = $db->query($sql);
422if (!$resql) {
423 dol_print_error($db);
424 exit;
425}
426
427$num = $db->num_rows($resql);
428
429
430// Direct jump if only one record found
431if ($num == 1 && getDolGlobalString('MAIN_SEARCH_DIRECT_OPEN_IF_ONLY_ONE') && $search_all && !$page) {
432 $obj = $db->fetch_object($resql);
433 $id = $obj->rowid;
434 header("Location: ".dol_buildpath('/fichinter/card.php', 1).'?id='.$id);
435 exit;
436}
437
438
439// Output page
440// --------------------------------------------------------------------
441
442llxHeader('', $title, $help_url, '', 0, 0, $morejs, $morecss, '', 'bodyforlist mod-fichinter page-list'); // Can use also classforhorizontalscrolloftabs instead of bodyforlist for no horizontal scroll
443
444
445$arrayofselected = is_array($toselect) ? $toselect : array();
446
447if ($socid > 0) {
448 $soc = new Societe($db);
449 $soc->fetch($socid);
450 if (empty($search_company)) {
451 $search_company = $soc->name;
452 }
453}
454
455$param = '';
456if (!empty($mode)) {
457 $param .= '&mode='.urlencode($mode);
458}
459if (!empty($contextpage) && $contextpage != $_SERVER["PHP_SELF"]) {
460 $param .= '&contextpage='.urlencode($contextpage);
461}
462if ($limit > 0 && $limit != $conf->liste_limit) {
463 $param .= '&limit='.((int) $limit);
464}
465if ($search_all) {
466 $param .= "&search_all=".urlencode($search_all);
467}
468if ($socid) {
469 $param .= "&socid=".urlencode((string) ($socid));
470}
471if ($search_ref) {
472 $param .= "&search_ref=".urlencode($search_ref);
473}
474if ($search_ref_client) {
475 $param .= "&search_ref_client=".urlencode($search_ref_client);
476}
477if ($search_company) {
478 $param .= "&search_company=".urlencode($search_company);
479}
480if ($search_desc) {
481 $param .= "&search_desc=".urlencode($search_desc);
482}
483if ($search_projet_ref) {
484 $param .= "&search_projet_ref=".urlencode($search_projet_ref);
485}
486if ($search_contrat_ref) {
487 $param .= "&search_contrat_ref=".urlencode($search_contrat_ref);
488}
489if ($search_status != '' && $search_status > -1) {
490 $param .= "&search_status=".urlencode($search_status);
491}
492if ($search_signed_status != '' && $search_signed_status >= 0) {
493 $param .= '&search_signed_status='.urlencode($search_signed_status);
494}
495if ($search_date_startday > 0) {
496 $param .= '&search_date_startday='.urlencode((string) ($search_date_startday));
497}
498if ($search_date_startmonth > 0) {
499 $param .= '&search_date_startmonth='.urlencode((string) ($search_date_startmonth));
500}
501if ($search_date_startyear > 0) {
502 $param .= '&search_date_startyear='.urlencode((string) ($search_date_startyear));
503}
504if ($search_date_endday > 0) {
505 $param .= '&search_date_endday='.urlencode((string) ($search_date_endday));
506}
507if ($search_date_endmonth > 0) {
508 $param .= '&search_date_endmonth='.urlencode((string) ($search_date_endmonth));
509}
510if ($search_date_endyear > 0) {
511 $param .= '&search_date_endyear='.urlencode((string) ($search_date_endyear));
512}
513if ($show_files) {
514 $param .= '&show_files='.urlencode((string) ($show_files));
515}
516if ($optioncss != '') {
517 $param .= '&optioncss='.urlencode($optioncss);
518}
519// Add $param from extra fields
520include DOL_DOCUMENT_ROOT.'/core/tpl/extrafields_list_search_param.tpl.php';
521// Add $param from hooks
522$parameters = array('param' => &$param);
523$reshook = $hookmanager->executeHooks('printFieldListSearchParam', $parameters, $object, $action); // Note that $action and $object may have been modified by hook
524$param .= $hookmanager->resPrint;
525
526// List of mass actions available
527$arrayofmassactions = array(
528 'generate_doc' => img_picto('', 'pdf', 'class="pictofixedwidth"').$langs->trans("ReGeneratePDF"),
529 'builddoc' => img_picto('', 'pdf', 'class="pictofixedwidth"').$langs->trans("PDFMerge"),
530 //'presend'=>$langs->trans("SendByMail"),
531);
532if (!empty($permissiontodelete)) {
533 $arrayofmassactions['predelete'] = img_picto('', 'delete', 'class="pictofixedwidth"').$langs->trans("Delete");
534}
535if (GETPOSTINT('nomassaction') || in_array($massaction, array('presend', 'predelete'))) {
536 $arrayofmassactions = array();
537}
538$massactionbutton = $form->selectMassAction('', $arrayofmassactions);
539
540
541print '<form method="POST" id="searchFormList" action="'.$_SERVER["PHP_SELF"].'">'."\n";
542if ($optioncss != '') {
543 print '<input type="hidden" name="optioncss" value="'.$optioncss.'">';
544}
545print '<input type="hidden" name="token" value="'.newToken().'">';
546print '<input type="hidden" name="formfilteraction" id="formfilteraction" value="list">';
547print '<input type="hidden" name="action" value="list">';
548print '<input type="hidden" name="sortfield" value="'.$sortfield.'">';
549print '<input type="hidden" name="sortorder" value="'.$sortorder.'">';
550print '<input type="hidden" name="page" value="'.$page.'">';
551print '<input type="hidden" name="contextpage" value="'.$contextpage.'">';
552print '<input type="hidden" name="page_y" value="">';
553print '<input type="hidden" name="mode" value="'.$mode.'">';
554
555$newcardbutton = '';
556$url = DOL_URL_ROOT.'/fichinter/card.php?action=create';
557if (!empty($socid)) {
558 $url .= '&socid='.$socid;
559}
560$newcardbutton = '';
561$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'));
562$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'));
563$newcardbutton .= dolGetButtonTitleSeparator();
564$newcardbutton .= dolGetButtonTitle($langs->trans('NewIntervention'), '', 'fa fa-plus-circle', $url, '', $user->hasRight('ficheinter', 'creer'));
565
566print_barre_liste($title, $page, $_SERVER['PHP_SELF'], $param, $sortfield, $sortorder, $massactionbutton, $num, $nbtotalofrecords, 'object_'.$object->picto, 0, $newcardbutton, '', $limit, 0, 0, 1);
567
568$topicmail = "Information";
569$modelmail = "intervention";
570$objecttmp = new Fichinter($db);
571$trackid = 'int'.$object->id;
572include DOL_DOCUMENT_ROOT.'/core/tpl/massactions_pre.tpl.php';
573
574if ($search_all) {
575 $setupstring = '';
576 foreach ($fieldstosearchall as $key => $val) {
577 $fieldstosearchall[$key] = $langs->trans($val);
578 $setupstring .= $key."=".$val.";";
579 }
580 print '<!-- Search done like if MYOBJECT_QUICKSEARCH_ON_FIELDS = '.$setupstring.' -->'."\n";
581 print '<div class="divsearchfieldfilter">'.$langs->trans("FilterOnInto", $search_all).implode(', ', $fieldstosearchall).'</div>'."\n";
582}
583
584$moreforfilter = '';
585
586$parameters = array();
587$reshook = $hookmanager->executeHooks('printFieldPreListTitle', $parameters, $object, $action); // Note that $action and $object may have been modified by hook
588if (empty($reshook)) {
589 $moreforfilter .= $hookmanager->resPrint;
590} else {
591 $moreforfilter = $hookmanager->resPrint;
592}
593
594if (!empty($moreforfilter)) {
595 print '<div class="liste_titre liste_titre_bydiv centpercent">';
596 print $moreforfilter;
597 print '</div>';
598}
599
600$varpage = empty($contextpage) ? $_SERVER["PHP_SELF"] : $contextpage;
601$htmlofselectarray = $form->multiSelectArrayWithCheckbox('selectedfields', $arrayfields, $varpage, getDolGlobalString('MAIN_CHECKBOX_LEFT_COLUMN')); // This also change content of $arrayfields with user setup
602$selectedfields = ($mode != 'kanban' ? $htmlofselectarray : '');
603$selectedfields .= (count($arrayofmassactions) ? $form->showCheckAddButtons('checkforselect', 1) : '');
604
605print '<div class="div-table-responsive">';
606print '<table class="tagtable nobottomiftotal liste'.($moreforfilter ? " listwithfilterbefore" : "").'">'."\n";
607
608// Fields title search
609// --------------------------------------------------------------------
610print '<tr class="liste_titre_filter">';
611// Action column
612if (getDolGlobalString('MAIN_CHECKBOX_LEFT_COLUMN')) {
613 print '<td class="liste_titre center maxwidthsearch">';
614 $searchpicto = $form->showFilterButtons('left');
615 print $searchpicto;
616 print '</td>';
617}
618if (!empty($arrayfields['f.ref']['checked'])) {
619 print '<td class="liste_titre">';
620 print '<input type="text" class="flat" name="search_ref" value="'.$search_ref.'" size="8">';
621 print '</td>';
622}
623if (!empty($arrayfields['f.ref_client']['checked'])) {
624 print '<td class="liste_titre">';
625 print '<input type="text" class="flat" name="search_ref_client" value="'.$search_ref_client.'" size="8">';
626 print '</td>';
627}
628if (!empty($arrayfields['s.nom']['checked'])) {
629 print '<td class="liste_titre">';
630 print '<input type="text" class="flat" name="search_company" value="'.$search_company.'" size="10">';
631 print '</td>';
632}
633if (!empty($arrayfields['pr.ref']['checked'])) {
634 print '<td class="liste_titre">';
635 print '<input type="text" class="flat" name="search_projet_ref" value="'.$search_projet_ref.'" size="8">';
636 print '</td>';
637}
638if (!empty($arrayfields['c.ref']['checked'])) {
639 print '<td class="liste_titre">';
640 print '<input type="text" class="flat" name="search_contrat_ref" value="'.$search_contrat_ref.'" size="8">';
641 print '</td>';
642}
643if (!empty($arrayfields['f.description']['checked'])) {
644 print '<td class="liste_titre">';
645 print '<input type="text" class="flat" name="search_desc" value="'.$search_desc.'" size="12">';
646 print '</td>';
647}
648// Extra fields
649include DOL_DOCUMENT_ROOT.'/core/tpl/extrafields_list_search_input.tpl.php';
650
651// Fields from hook
652$parameters = array('arrayfields' => $arrayfields);
653$reshook = $hookmanager->executeHooks('printFieldListOption', $parameters, $object, $action); // Note that $action and $object may have been modified by hook
654print $hookmanager->resPrint;
655if (!empty($arrayfields['f.datec']['checked'])) {
656 // Date creation
657 print '<td class="liste_titre">';
658 print '</td>';
659}
660if (!empty($arrayfields['f.tms']['checked'])) {
661 // Date modification
662 print '<td class="liste_titre">';
663 print '</td>';
664}
665if (!empty($arrayfields['f.note_public']['checked'])) {
666 // Note public
667 print '<td class="liste_titre">';
668 print '</td>';
669}
670if (!empty($arrayfields['f.note_private']['checked'])) {
671 // Note private
672 print '<td class="liste_titre">';
673 print '</td>';
674}
675// Status
676if (!empty($arrayfields['f.fk_statut']['checked'])) {
677 print '<td class="liste_titre right parentonrightofpage">';
678 $liststatus = [
679 $object::STATUS_DRAFT => $langs->transnoentitiesnoconv('Draft'),
680 $object::STATUS_VALIDATED => $langs->transnoentitiesnoconv('Validated'),
681 $object::STATUS_BILLED => $langs->transnoentitiesnoconv('StatusInterInvoiced'),
682 $object::STATUS_CLOSED => $langs->transnoentitiesnoconv('Done'),
683 ];
684 if (!getDolGlobalString('FICHINTER_CLASSIFY_BILLED')) {
685 unset($liststatus[2]); // Option deprecated. In a future, billed must be managed with a dedicated field to 0 or 1
686 }
687 // @phan-suppress-next-line PhanPluginSuspiciousParamOrder
688 print $form->selectarray('search_status', $liststatus, $search_status, 1, 0, 0, '', 1, 0, 0, '', 'search_status width100 onrightofpage');
689 print '</td>';
690}
691// Signed status
692if (!empty($arrayfields['f.signed_status']['checked'])) {
693 print '<td class="liste_titre center">';
694 $list_signed_status = $object->getSignedStatusLocalisedArray();
695 print $form->selectarray('search_signed_status', $list_signed_status, $search_signed_status, 1, 0, 0, '', 1, 0, 0, '', 'search_status');
696 print '</td>';
697}
698// Fields of detail line
699if (!empty($arrayfields['fd.description']['checked'])) {
700 print '<td class="liste_titre">&nbsp;</td>';
701}
702if (!empty($arrayfields['fd.date']['checked'])) {
703 print '<td class="liste_titre center">';
704 print '<div class="nowrapfordate">';
705 print $form->selectDate($search_date_start ?: -1, 'search_date_start', 0, 0, 1, '', 1, 0, 0, '', '', '', '', 1, '', $langs->trans('From'));
706 print '</div>';
707 print '<div class="nowrapfordate">';
708 print $form->selectDate($search_date_end ?: -1, 'search_date_end', 0, 0, 1, '', 1, 0, 0, '', '', '', '', 1, '', $langs->trans('to'));
709 print '</div>';
710 print '</td>';
711}
712if (!empty($arrayfields['fd.duree']['checked'])) {
713 print '<td class="liste_titre">&nbsp;</td>';
714}
715// Action column
716if (!getDolGlobalString('MAIN_CHECKBOX_LEFT_COLUMN')) {
717 print '<td class="liste_titre center maxwidthsearch">';
718 $searchpicto = $form->showFilterButtons();
719 print $searchpicto;
720 print '</td>';
721}
722print '</tr>'."\n";
723
724$totalarray = array();
725$totalarray['nbfield'] = 0;
726
727// Fields title label
728// --------------------------------------------------------------------
729print '<tr class="liste_titre">';
730// Action column
731if (getDolGlobalString('MAIN_CHECKBOX_LEFT_COLUMN')) {
732 print_liste_field_titre($selectedfields, $_SERVER["PHP_SELF"], "", '', '', '', $sortfield, $sortorder, 'center maxwidthsearch ');
733 $totalarray['nbfield']++;
734}
735if (!empty($arrayfields['f.ref']['checked'])) {
736 // @phan-suppress-next-line PhanTypeInvalidDimOffset
737 print_liste_field_titre($arrayfields['f.ref']['label'], $_SERVER["PHP_SELF"], "f.ref", "", $param, '', $sortfield, $sortorder);
738 $totalarray['nbfield']++;
739}
740if (!empty($arrayfields['f.ref_client']['checked'])) {
741 print_liste_field_titre($arrayfields['f.ref_client']['label'], $_SERVER["PHP_SELF"], "f.ref_client", "", $param, '', $sortfield, $sortorder);
742 $totalarray['nbfield']++;
743}
744if (!empty($arrayfields['s.nom']['checked'])) {
745 print_liste_field_titre($arrayfields['s.nom']['label'], $_SERVER["PHP_SELF"], "s.nom", "", $param, '', $sortfield, $sortorder);
746 $totalarray['nbfield']++;
747}
748if (!empty($arrayfields['pr.ref']['checked'])) {
749 print_liste_field_titre($arrayfields['pr.ref']['label'], $_SERVER["PHP_SELF"], "pr.ref", "", $param, '', $sortfield, $sortorder);
750 $totalarray['nbfield']++;
751}
752if (!empty($arrayfields['c.ref']['checked'])) {
753 print_liste_field_titre($arrayfields['c.ref']['label'], $_SERVER["PHP_SELF"], "c.ref", "", $param, '', $sortfield, $sortorder);
754 $totalarray['nbfield']++;
755}
756if (!empty($arrayfields['f.description']['checked'])) {
757 print_liste_field_titre($arrayfields['f.description']['label'], $_SERVER["PHP_SELF"], "f.description", "", $param, '', $sortfield, $sortorder);
758 $totalarray['nbfield']++;
759}
760// Extra fields
761include DOL_DOCUMENT_ROOT.'/core/tpl/extrafields_list_search_title.tpl.php';
762// Hook fields
763$parameters = array('arrayfields' => $arrayfields, 'param' => $param, 'sortfield' => $sortfield, 'sortorder' => $sortorder, 'totalarray' => &$totalarray);
764$reshook = $hookmanager->executeHooks('printFieldListTitle', $parameters, $object, $action); // Note that $action and $object may have been modified by hook
765print $hookmanager->resPrint;
766if (!empty($arrayfields['f.datec']['checked'])) {
767 print_liste_field_titre($arrayfields['f.datec']['label'], $_SERVER["PHP_SELF"], "f.datec", "", $param, '', $sortfield, $sortorder, 'center nowrap ');
768 $totalarray['nbfield']++;
769}
770if (!empty($arrayfields['f.tms']['checked'])) {
771 print_liste_field_titre($arrayfields['f.tms']['label'], $_SERVER["PHP_SELF"], "f.tms", "", $param, '', $sortfield, $sortorder, 'center nowrap ');
772 $totalarray['nbfield']++;
773}
774if (!empty($arrayfields['f.note_public']['checked'])) {
775 print_liste_field_titre($arrayfields['f.note_public']['label'], $_SERVER["PHP_SELF"], "f.note_public", "", $param, '', $sortfield, $sortorder, 'center nowrap ');
776 $totalarray['nbfield']++;
777}
778if (!empty($arrayfields['f.note_private']['checked'])) {
779 print_liste_field_titre($arrayfields['f.note_private']['label'], $_SERVER["PHP_SELF"], "f.note_private", "", $param, '', $sortfield, $sortorder, 'center nowrap ');
780 $totalarray['nbfield']++;
781}
782if (!empty($arrayfields['f.fk_statut']['checked'])) {
783 print_liste_field_titre($arrayfields['f.fk_statut']['label'], $_SERVER["PHP_SELF"], "f.fk_statut", "", $param, '', $sortfield, $sortorder, 'center ');
784 $totalarray['nbfield']++;
785}
786if (!empty($arrayfields['f.signed_status']['checked'])) {
787 print_liste_field_titre($arrayfields['f.signed_status']['label'], $_SERVER["PHP_SELF"], "f.signed_status", "", $param, '', $sortfield, $sortorder, 'center ');
788 $totalarray['nbfield']++;
789}
790if (!empty($arrayfields['fd.description']['checked'])) {
791 print_liste_field_titre($arrayfields['fd.description']['label'], $_SERVER["PHP_SELF"], '');
792 $totalarray['nbfield']++;
793}
794if (!empty($arrayfields['fd.date']['checked'])) {
795 print_liste_field_titre($arrayfields['fd.date']['label'], $_SERVER["PHP_SELF"], "fd.date", "", $param, '', $sortfield, $sortorder, 'center ');
796 $totalarray['nbfield']++;
797}
798if (!empty($arrayfields['fd.duree']['checked'])) {
799 print_liste_field_titre($arrayfields['fd.duree']['label'], $_SERVER["PHP_SELF"], "fd.duree", "", $param, '', $sortfield, $sortorder, 'right ');
800 $totalarray['nbfield']++;
801}
802
803// Action column
804if (!getDolGlobalString('MAIN_CHECKBOX_LEFT_COLUMN')) {
805 print_liste_field_titre($selectedfields, $_SERVER["PHP_SELF"], "", '', '', '', $sortfield, $sortorder, 'center maxwidthsearch ');
806 $totalarray['nbfield']++;
807}
808print "</tr>\n";
809
810
811// Loop on record
812// --------------------------------------------------------------------
813$i = 0;
814$savnbfield = $totalarray['nbfield'];
815$totalarray = array();
816$totalarray['nbfield'] = 0;
817$totalarray['val'] = array();
818$totalarray['val']['fd.duree'] = 0;
819$total = 0;
820$imaxinloop = ($limit ? min($num, $limit) : $num);
821while ($i < $imaxinloop) {
822 $obj = $db->fetch_object($resql);
823 if (empty($obj)) {
824 break; // Should not happen
825 }
826
827 // Store properties in $object
828 //$object->setVarsFromFetchObj($obj);
829
830 $objectstatic->id = $obj->rowid;
831 $objectstatic->ref = $obj->ref;
832 $objectstatic->ref_client = $obj->ref_client;
833 $objectstatic->statut = $obj->status; // deprecated
834 $objectstatic->status = $obj->status;
835 $objectstatic->signed_status = $obj->signed_status;
836
837 $companystatic->name = $obj->name;
838 $companystatic->id = $obj->socid;
839 $companystatic->client = $obj->client;
840 $companystatic->fournisseur = $obj->fournisseur;
841 $companystatic->email = $obj->email;
842 $companystatic->status = $obj->thirdpartystatus;
843
844 //mode kanban
845 if ($mode == 'kanban') {
846 if ($i == 0) {
847 print '<tr class="trkanban"><td colspan="'.$savnbfield.'">';
848 print '<div class="box-flex-container kanban">';
849 }
850
851 // Output Kanban
852 if ($massactionbutton || $massaction) { // If we are in select mode (massactionbutton defined) or if we have already selected and sent an action ($massaction) defined
853 $selected = 0;
854 if (in_array($object->id, $arrayofselected)) {
855 $selected = 1;
856 }
857 }
858
859 $objectstatic->duration = $obj->duree;
860 $arraydata = array();
861 $arraydata['thirdparty'] = $companystatic;
862 print $objectstatic->getKanbanView('', $arraydata);
863 if ($i == ($imaxinloop - 1)) {
864 print '</div>';
865 print '</td></tr>';
866 }
867 } else {
868 // Show here line of result
869 $j = 0;
870 print '<tr data-rowid="'.$object->id.'" class="oddeven">';
871 // Action column
872 if (getDolGlobalString('MAIN_CHECKBOX_LEFT_COLUMN')) {
873 print '<td class="nowrap center">';
874 if ($massactionbutton || $massaction) { // If we are in select mode (massactionbutton defined) or if we have already selected and sent an action ($massaction) defined
875 $selected = 0;
876 if (in_array($obj->rowid, $arrayofselected)) {
877 $selected = 1;
878 }
879 print '<input id="cb'.$obj->rowid.'" class="flat checkforselect" type="checkbox" name="toselect[]" value="'.$obj->rowid.'"'.($selected ? ' checked="checked"' : '').'>';
880 }
881 print '</td>';
882 if (!$i) {
883 $totalarray['nbfield']++;
884 }
885 }
886
887 // Picto + Ref
888 if (!empty($arrayfields['f.ref']['checked'])) {
889 print "<td>";
890
891 print '<table class="nobordernopadding"><tr class="nocellnopadd">';
892 print '<td class="nobordernopadding nowraponall">';
893 print $objectstatic->getNomUrl(1);
894 print '</td>';
895 // Warning
896 $warnornote = '';
897 //if ($obj->fk_statut == 1 && $db->jdate($obj->dfv) < ($now - $conf->fichinter->warning_delay)) $warnornote.=img_warning($langs->trans("Late"));
898 if (!empty($obj->note_private)) {
899 $warnornote .= ($warnornote ? ' ' : '');
900 $warnornote .= '<span class="note">';
901 $warnornote .= '<a href="note.php?id='.$obj->rowid.'">'.img_picto($langs->trans("ViewPrivateNote"), 'object_generic').'</a>';
902 $warnornote .= '</span>';
903 }
904 if ($warnornote) {
905 print '<td style="min-width: 20px" class="nobordernopadding nowrap">';
906 print $warnornote;
907 print '</td>';
908 }
909
910 // Other picto tool
911 print '<td width="16" class="right nobordernopadding hideonsmartphone">';
912 $filename = dol_sanitizeFileName($obj->ref);
913 $filedir = $conf->ficheinter->dir_output.'/'.dol_sanitizeFileName($obj->ref);
914 $urlsource = $_SERVER['PHP_SELF'].'?id='.$obj->rowid;
915 print $formfile->getDocumentsLink($objectstatic->element, $filename, $filedir);
916 print '</td></tr></table>';
917
918 print "</td>\n";
919 if (!$i) {
920 $totalarray['nbfield']++;
921 }
922 }
923
924 // Customer ref
925 if (!empty($arrayfields['f.ref_client']['checked'])) {
926 print '<td class="nowrap tdoverflowmax200">';
927 print dol_escape_htmltag($obj->ref_client);
928 print '</td>';
929 if (!$i) {
930 $totalarray['nbfield']++;
931 }
932 }
933 // Third party
934 if (!empty($arrayfields['s.nom']['checked'])) {
935 print '<td class="tdoverflowmax125">';
936 print $companystatic->getNomUrl(1, '', 44);
937 print '</td>';
938 if (!$i) {
939 $totalarray['nbfield']++;
940 }
941 }
942 // Project ref
943 if (!empty($arrayfields['pr.ref']['checked']) && $projetstatic !== null) {
944 print '<td class="tdoverflowmax150">';
945 $projetstatic->id = $obj->projet_id;
946 $projetstatic->ref = $obj->projet_ref;
947 $projetstatic->title = $obj->projet_title;
948 if ($projetstatic->id > 0) {
949 print $projetstatic->getNomUrl(1, '');
950 }
951 print '</td>';
952 if (!$i) {
953 $totalarray['nbfield']++;
954 }
955 }
956 // Contract
957 if (!empty($arrayfields['c.ref']['checked']) && $contratstatic !== null) {
958 print '<td class="tdoverflowmax150">';
959 $contratstatic->id = $obj->contrat_id;
960 $contratstatic->ref = $obj->contrat_ref;
961 $contratstatic->ref_customer = $obj->contrat_ref_customer;
962 $contratstatic->ref_supplier = $obj->contrat_ref_supplier;
963 if ($contratstatic->id > 0) {
964 print $contratstatic->getNomUrl(1, 0);
965 print '</td>';
966 }
967 if (!$i) {
968 $totalarray['nbfield']++;
969 }
970 }
971 if (!empty($arrayfields['f.description']['checked'])) {
972 print '<td>'.dol_trunc(dolGetFirstLineOfText(dol_string_nohtmltag($obj->description, 1)), 48).'</td>';
973 if (!$i) {
974 $totalarray['nbfield']++;
975 }
976 }
977
978 // Extra fields
979 include DOL_DOCUMENT_ROOT.'/core/tpl/extrafields_list_print_fields.tpl.php';
980 // Fields from hook
981 $parameters = array('arrayfields' => $arrayfields, 'obj' => $obj, 'i' => $i, 'totalarray' => &$totalarray);
982 $reshook = $hookmanager->executeHooks('printFieldListValue', $parameters); // Note that $action and $object may have been modified by hook
983 print $hookmanager->resPrint;
984 // Date creation
985 if (!empty($arrayfields['f.datec']['checked'])) {
986 print '<td class="center nowraponall">';
987 print dol_print_date($db->jdate($obj->date_creation), 'dayhour', 'tzuser');
988 print '</td>';
989 if (!$i) {
990 $totalarray['nbfield']++;
991 }
992 }
993 // Date modification
994 if (!empty($arrayfields['f.tms']['checked'])) {
995 print '<td class="center nowraponall">';
996 print dol_print_date($db->jdate($obj->date_modification), 'dayhour', 'tzuser');
997 print '</td>';
998 if (!$i) {
999 $totalarray['nbfield']++;
1000 }
1001 }
1002 // Note public
1003 if (!empty($arrayfields['f.note_public']['checked'])) {
1004 print '<td class="sensiblehtmlcontent center">';
1005 print '<div class="small lineheightsmall twolinesmax-normallineheight">'.dolPrintHTML(dolGetFirstLineOfText($obj->note_public, 5)).'</div>';
1006 print '</td>';
1007 if (!$i) {
1008 $totalarray['nbfield']++;
1009 }
1010 }
1011 // Note private
1012 if (!empty($arrayfields['f.note_private']['checked'])) {
1013 print '<td class="sensiblehtmlcontent center">';
1014 print '<div class="small lineheightsmall twolinesmax-normallineheight">'.dolPrintHTML(dolGetFirstLineOfText($obj->note_private, 5)).'</div>';
1015 print '</td>';
1016 if (!$i) {
1017 $totalarray['nbfield']++;
1018 }
1019 }
1020 // Status
1021 if (!empty($arrayfields['f.fk_statut']['checked'])) {
1022 print '<td class="center">'.$objectstatic->getLibStatut(5).'</td>';
1023 if (!$i) {
1024 $totalarray['nbfield']++;
1025 }
1026 }
1027 // Signed Status
1028 if (!empty($arrayfields['f.signed_status']['checked'])) {
1029 print '<td class="center">'.$objectstatic->getLibSignedStatus(5).'</td>';
1030 if (!$i) {
1031 $totalarray['nbfield']++;
1032 }
1033 }
1034 // Fields of detail of line
1035 if (!empty($arrayfields['fd.description']['checked'])) {
1036 $text = dolGetFirstLineOfText(dol_string_nohtmltag($obj->descriptiondetail, 1));
1037 print '<td>';
1038 print '<div class="classfortooltip tdoverflowmax250 small" title="'.dol_escape_htmltag($obj->descriptiondetail, 1, 1).'">';
1039 print dol_escape_htmltag($text);
1040 print '</div>';
1041 print '</td>';
1042 if (!$i) {
1043 $totalarray['nbfield']++;
1044 }
1045 }
1046 // Date line
1047 if (!empty($arrayfields['fd.date']['checked'])) {
1048 print '<td class="center nowraponall" title="'.dol_print_date($db->jdate($obj->dp), 'dayhour').'">'.dol_print_date($db->jdate($obj->dp), 'dayhour')."</td>\n";
1049 if (!$i) {
1050 $totalarray['nbfield']++;
1051 }
1052 }
1053 // Duration line
1054 if (!empty($arrayfields['fd.duree']['checked'])) {
1055 print '<td class="right">'.convertSecondToTime($obj->duree, 'allhourmin').'</td>';
1056 if (!$i) {
1057 $totalarray['nbfield']++;
1058 }
1059 if (!$i) {
1060 $totalarray['type'][$totalarray['nbfield']] = 'duration';
1061 }
1062 if (!$i) {
1063 $totalarray['pos'][$totalarray['nbfield']] = 'fd.duree';
1064 }
1065 $totalarray['val']['fd.duree'] += $obj->duree;
1066 }
1067 // Action column
1068 if (!getDolGlobalString('MAIN_CHECKBOX_LEFT_COLUMN')) {
1069 print '<td class="nowrap center">';
1070 if ($massactionbutton || $massaction) { // If we are in select mode (massactionbutton defined) or if we have already selected and sent an action ($massaction) defined
1071 $selected = 0;
1072 if (in_array($obj->rowid, $arrayofselected)) {
1073 $selected = 1;
1074 }
1075 print '<input id="cb'.$obj->rowid.'" class="flat checkforselect" type="checkbox" name="toselect[]" value="'.$obj->rowid.'"'.($selected ? ' checked="checked"' : '').'>';
1076 }
1077 print '</td>';
1078 if (!$i) {
1079 $totalarray['nbfield']++;
1080 }
1081 }
1082
1083 print '</tr>'."\n";
1084
1085 $total += (isset($obj->duree) ? $obj->duree : 0);
1086 }
1087 $i++;
1088}
1089
1090
1091// Show total line
1092include DOL_DOCUMENT_ROOT.'/core/tpl/list_print_total.tpl.php';
1093
1094// If no record found
1095if ($num == 0) {
1096 $colspan = 1;
1097 foreach ($arrayfields as $key => $val) {
1098 if (!empty($val['checked'])) {
1099 $colspan++;
1100 }
1101 }
1102 print '<tr><td colspan="'.$colspan.'"><span class="opacitymedium">'.$langs->trans("NoRecordFound").'</span></td></tr>';
1103}
1104
1105$db->free($resql);
1106
1107$parameters = array('arrayfields' => $arrayfields, 'sql' => $sql);
1108$reshook = $hookmanager->executeHooks('printFieldListFooter', $parameters, $object, $action); // Note that $action and $object may have been modified by hook
1109print $hookmanager->resPrint;
1110
1111print '</table>'."\n";
1112print '</div>'."\n";
1113
1114print '</form>'."\n";
1115
1116if (in_array('builddoc', array_keys($arrayofmassactions)) && ($nbtotalofrecords === '' || $nbtotalofrecords)) {
1117 $hidegeneratedfilelistifempty = 1;
1118 if ($massaction == 'builddoc' || $action == 'remove_file' || $show_files) {
1119 $hidegeneratedfilelistifempty = 0;
1120 }
1121
1122 require_once DOL_DOCUMENT_ROOT.'/core/class/html.formfile.class.php';
1123 $formfile = new FormFile($db);
1124
1125 // Show list of available documents
1126 $urlsource = $_SERVER['PHP_SELF'].'?sortfield='.$sortfield.'&sortorder='.$sortorder;
1127 $urlsource .= str_replace('&amp;', '&', $param);
1128
1129 $filedir = $diroutputmassaction;
1130 $genallowed = $permissiontoread;
1131 $delallowed = $permissiontoadd;
1132
1133 print $formfile->showdocuments('massfilesarea_interventions', '', $filedir, $urlsource, 0, $delallowed, '', 1, 1, 0, 48, 1, $param, $title, '', '', '', null, $hidegeneratedfilelistifempty);
1134}
1135
1136// End of page
1137llxFooter();
1138$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.