dolibarr  18.0.6
list.php
Go to the documentation of this file.
1 <?php
2 /* Copyright (C) 2001-2005 Rodolphe Quiedeville <rodolphe@quiedeville.org>
3  * Copyright (C) 2004-2019 Laurent Destailleur <eldy@users.sourceforge.net>
4  * Copyright (C) 2005 Marc Bariley / Ocebo <marc@ocebo.com>
5  * Copyright (C) 2005-2010 Regis Houssin <regis.houssin@inodbox.com>
6  * Copyright (C) 2013 C├ędric Salvador <csalvador@gpcsolutions.fr>
7  * Copyright (C) 2015 Claudio Aschieri <c.aschieri@19.coop>
8  * Copyright (C) 2018 Ferran Marcet <fmarcet@2byte.es>
9  * Copyright (C) 2019 Juanjo Menent <jmenent@2byte.es>
10  * Copyright (C) 2020 Tobias Sean <tobias.sekan@startmail.com>
11  *
12  * This program is free software; you can redistribute it and/or modify
13  * it under the terms of the GNU General Public License as published by
14  * the Free Software Foundation; either version 3 of the License, or
15  * (at your option) any later version.
16  *
17  * This program is distributed in the hope that it will be useful,
18  * but WITHOUT ANY WARRANTY; without even the implied warranty of
19  * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the
20  * GNU General Public License for more details.
21  *
22  * You should have received a copy of the GNU General Public License
23  * along with this program. If not, see <https://www.gnu.org/licenses/>.
24  */
25 
32 // Load Dolibarr environment
33 require '../main.inc.php';
34 require_once DOL_DOCUMENT_ROOT.'/projet/class/project.class.php';
35 require_once DOL_DOCUMENT_ROOT.'/core/lib/date.lib.php';
36 require_once DOL_DOCUMENT_ROOT.'/core/class/html.formother.class.php';
37 require_once DOL_DOCUMENT_ROOT.'/core/class/html.formprojet.class.php';
38 require_once DOL_DOCUMENT_ROOT.'/core/class/html.formcompany.class.php';
39 require_once DOL_DOCUMENT_ROOT.'/projet/class/task.class.php';
40 
41 if (isModEnabled('categorie')) {
42  require_once DOL_DOCUMENT_ROOT.'/core/class/html.formcategory.class.php';
43  require_once DOL_DOCUMENT_ROOT.'/categories/class/categorie.class.php';
44 }
45 
46 // Load translation files required by the page
47 $langs->loadLangs(array('projects', 'companies', 'commercial'));
48 if (isModEnabled('eventorganization') && $conf->eventorganization->enabled) {
49  $langs->loadLangs(array('eventorganization'));
50 }
51 
52 $action = GETPOST('action', 'aZ09');
53 $massaction = GETPOST('massaction', 'alpha');
54 $show_files = GETPOST('show_files', 'int');
55 $confirm = GETPOST('confirm', 'alpha');
56 $toselect = GETPOST('toselect', 'array');
57 $optioncss = GETPOST('optioncss', 'alpha');
58 $contextpage = GETPOST('contextpage', 'aZ') ?GETPOST('contextpage', 'aZ') : 'projectlist';
59 $mode = GETPOST('mode', 'alpha');
60 
61 
62 $title = $langs->trans("Projects");
63 
64 // Security check
65 $socid = GETPOST('socid', 'int');
66 //if ($user->socid > 0) $socid = $user->socid; // For external user, no check is done on company because readability is managed by public status of project and assignement.
67 if ($socid > 0) {
68  $soc = new Societe($db);
69  $soc->fetch($socid);
70  $title .= ' (<a href="list.php">'.$soc->name.'</a>)';
71 }
72 if (!$user->rights->projet->lire) {
74 }
75 
76 $diroutputmassaction = $conf->project->dir_output.'/temp/massgeneration/'.$user->id;
77 
78 $limit = GETPOST('limit', 'int') ?GETPOST('limit', 'int') : $conf->liste_limit;
79 $sortfield = GETPOST('sortfield', 'aZ09comma');
80 $sortorder = GETPOST('sortorder', 'aZ09comma');
81 $page = GETPOSTISSET('pageplusone') ? (GETPOST('pageplusone') - 1) : GETPOST("page", 'int');
82 if (empty($page) || $page < 0 || GETPOST('button_search', 'alpha') || GETPOST('button_removefilter', 'alpha')) {
83  // If $page is not defined, or '' or -1 or if we click on clear filters
84  $page = 0;
85 }
86 if (!$sortfield) {
87  $sortfield = "p.ref";
88 }
89 if (!$sortorder) {
90  $sortorder = "ASC";
91 }
92 $offset = $limit * $page;
93 $pageprev = $page - 1;
94 $pagenext = $page + 1;
95 
96 $search_all = GETPOST('search_all', 'alphanohtml') ? GETPOST('search_all', 'alphanohtml') : GETPOST('sall', 'alphanohtml');
97 $search_ref = GETPOST("search_ref", 'alpha');
98 $search_label = GETPOST("search_label", 'alpha');
99 $search_societe = GETPOST("search_societe", 'alpha');
100 $search_societe_alias = GETPOST("search_societe_alias", 'alpha');
101 $search_status = GETPOST("search_status", 'int');
102 $search_opp_status = GETPOST("search_opp_status", 'alpha');
103 $search_opp_percent = GETPOST("search_opp_percent", 'alpha');
104 $search_opp_amount = GETPOST("search_opp_amount", 'alpha');
105 $search_budget_amount = GETPOST("search_budget_amount", 'alpha');
106 $search_public = GETPOST("search_public", 'int');
107 $search_project_user = GETPOST('search_project_user', 'int');
108 $search_project_contact = GETPOST('search_project_contact', 'int');
109 $search_sale = GETPOST('search_sale', 'int');
110 $search_usage_opportunity = GETPOST('search_usage_opportunity', 'int');
111 $search_usage_task = GETPOST('search_usage_task', 'int');
112 $search_usage_bill_time = GETPOST('search_usage_bill_time', 'int');
113 $search_usage_event_organization = GETPOST('search_usage_event_organization', 'int');
114 $search_accept_conference_suggestions = GETPOST('search_accept_conference_suggestions', 'int');
115 $search_accept_booth_suggestions = GETPOST('search_accept_booth_suggestions', 'int');
116 $search_price_registration = GETPOST("search_price_registration", 'alpha');
117 $search_price_booth = GETPOST("search_price_booth", 'alpha');
118 $search_login = GETPOST('search_login', 'alpha');
119 $search_import_key = GETPOST('search_import_key', 'alpha');
120 $searchCategoryCustomerOperator = 0;
121 if (GETPOSTISSET('formfilteraction')) {
122  $searchCategoryCustomerOperator = GETPOST('search_category_customer_operator', 'int');
123 } elseif (!empty($conf->global->MAIN_SEARCH_CAT_OR_BY_DEFAULT)) {
124  $searchCategoryCustomerOperator = $conf->global->MAIN_SEARCH_CAT_OR_BY_DEFAULT;
125 }
126 $searchCategoryCustomerList = GETPOST('search_category_customer_list', 'array');
127 if (getDolGlobalInt('PROJECT_ENABLE_SUB_PROJECT')) {
128  $search_omitChildren = GETPOST('search_omitChildren', 'alpha') == 'on' ? 1 : 0;
129 }
130 
131 
132 $mine = ((GETPOST('mode') == 'mine') ? 1 : 0);
133 if ($mine) {
134  $search_project_user = $user->id; $mine = 0;
135 }
136 
137 $search_sday = GETPOST('search_sday', 'int');
138 $search_smonth = GETPOST('search_smonth', 'int');
139 $search_syear = GETPOST('search_syear', 'int');
140 $search_eday = GETPOST('search_eday', 'int');
141 $search_emonth = GETPOST('search_emonth', 'int');
142 $search_eyear = GETPOST('search_eyear', 'int');
143 
144 $search_date_start_startmonth = GETPOST('search_date_start_startmonth', 'int');
145 $search_date_start_startyear = GETPOST('search_date_start_startyear', 'int');
146 $search_date_start_startday = GETPOST('search_date_start_startday', 'int');
147 $search_date_start_start = dol_mktime(0, 0, 0, $search_date_start_startmonth, $search_date_start_startday, $search_date_start_startyear); // Use tzserver
148 $search_date_start_endmonth = GETPOST('search_date_start_endmonth', 'int');
149 $search_date_start_endyear = GETPOST('search_date_start_endyear', 'int');
150 $search_date_start_endday = GETPOST('search_date_start_endday', 'int');
151 $search_date_start_end = dol_mktime(23, 59, 59, $search_date_start_endmonth, $search_date_start_endday, $search_date_start_endyear); // Use tzserver
152 
153 $search_date_end_startmonth = GETPOST('search_date_end_startmonth', 'int');
154 $search_date_end_startyear = GETPOST('search_date_end_startyear', 'int');
155 $search_date_end_startday = GETPOST('search_date_end_startday', 'int');
156 $search_date_end_start = dol_mktime(0, 0, 0, $search_date_end_startmonth, $search_date_end_startday, $search_date_end_startyear); // Use tzserver
157 $search_date_end_endmonth = GETPOST('search_date_end_endmonth', 'int');
158 $search_date_end_endyear = GETPOST('search_date_end_endyear', 'int');
159 $search_date_end_endday = GETPOST('search_date_end_endday', 'int');
160 $search_date_end_end = dol_mktime(23, 59, 59, $search_date_end_endmonth, $search_date_end_endday, $search_date_end_endyear); // Use tzserver
161 
162 if (isModEnabled('categorie')) {
163  $search_category_array = GETPOST("search_category_".Categorie::TYPE_PROJECT."_list", "array");
164 }
165 
166 if ($search_status == '') {
167  $search_status = -1; // -1 or 1
168 }
169 
170 
171 // Initialize technical object to manage hooks of page. Note that conf->hooks_modules contains array of hook context
172 $object = new Project($db);
173 $hookmanager->initHooks(array('projectlist'));
174 $extrafields = new ExtraFields($db);
175 
176 // fetch optionals attributes and labels
177 $extrafields->fetch_name_optionals_label($object->table_element);
178 
179 $search_array_options = $extrafields->getOptionalsFromPost($object->table_element, '', 'search_');
180 
181 // List of fields to search into when doing a "search in all"
182 $fieldstosearchall = array();
183 foreach ($object->fields as $key => $val) {
184  if (empty($val['searchall'])) {
185  continue;
186  }
187 
188  // Don't allow search in private notes for external users when doing "search in all"
189  if (!empty($user->socid) && $key == "note_private") {
190  continue;
191  }
192 
193  $fieldstosearchall['p.'.$key] = $val['label'];
194 }
195 
196 // Add name object fields to "search in all"
197 $fieldstosearchall['s.nom'] = "ThirdPartyName";
198 $fieldstosearchall['s.name_alias'] = "AliasNameShort";
199 $fieldstosearchall['s.code_client'] = "CustomerCode";
200 
201 // Definition of array of fields for columns
202 $arrayfields = array();
203 foreach ($object->fields as $key => $val) {
204  // If $val['visible']==0, then we never show the field
205  if (!empty($val['visible'])) {
206  $visible = dol_eval($val['visible'], 1, 1, '1');
207  $arrayfields['p.'.$key] = array(
208  'label'=>$val['label'],
209  'checked'=>(($visible < 0) ? 0 : 1),
210  'enabled'=>($visible != 3 && dol_eval($val['enabled'], 1, 1, '1')),
211  'position'=>$val['position'],
212  'help'=> isset($val['help']) ? $val['help'] : ''
213  );
214  }
215 }
216 // Extra fields
217 include DOL_DOCUMENT_ROOT.'/core/tpl/extrafields_list_array_fields.tpl.php';
218 
219 // Add non object fields to fields for list
220 $arrayfields['s.nom'] = array('label'=>$langs->trans("ThirdParty"), 'checked'=>1, 'position'=>21, 'enabled'=>(!isModEnabled('societe') ? 0 : 1));
221 $arrayfields['s.name_alias'] = array('label'=>"AliasNameShort", 'checked'=>0, 'position'=>22);
222 $arrayfields['commercial'] = array('label'=>$langs->trans("SaleRepresentativesOfThirdParty"), 'checked'=>0, 'position'=>23);
223 $arrayfields['c.assigned'] = array('label'=>$langs->trans("AssignedTo"), 'checked'=>1, 'position'=>120);
224 $arrayfields['opp_weighted_amount'] = array('label'=>$langs->trans('OpportunityWeightedAmountShort'), 'checked'=>0, 'enabled'=>(empty($conf->global->PROJECT_USE_OPPORTUNITIES) ? 0 : 1), 'position'=>106);
225 $arrayfields['u.login'] = array('label'=>"Author", 'checked'=>-1, 'position'=>165);
226 // Force some fields according to search_usage filter...
227 if (GETPOST('search_usage_opportunity')) {
228  //$arrayfields['p.usage_opportunity']['visible'] = 1; // Not require, filter on search_opp_status is enough
229  //$arrayfields['p.usage_opportunity']['checked'] = 1; // Not require, filter on search_opp_status is enough
230 }
231 if (GETPOST('search_usage_event_organization')) {
232  $arrayfields['p.fk_opp_status']['enabled'] = 0;
233  $arrayfields['p.opp_amount']['enabled'] = 0;
234  $arrayfields['p.opp_percent']['enabled'] = 0;
235  $arrayfields['opp_weighted_amount']['enabled'] = 0;
236  $arrayfields['p.usage_organize_event']['visible'] = 1;
237  $arrayfields['p.usage_organize_event']['checked'] = 1;
238 }
239 
240 $object->fields = dol_sort_array($object->fields, 'position');
241 $arrayfields = dol_sort_array($arrayfields, 'position');
242 
243 
244 /*
245  * Actions
246  */
247 
248 if (GETPOST('cancel', 'alpha')) {
249  $action = 'list';
250  $massaction = '';
251 }
252 if (!GETPOST('confirmmassaction', 'alpha') && $massaction != 'presend' && $massaction != 'confirm_presend') {
253  $massaction = '';
254 }
255 
256 $parameters = array('socid'=>$socid);
257 $reshook = $hookmanager->executeHooks('doActions', $parameters, $object, $action); // Note that $action and $object may have been modified by some hooks
258 if ($reshook < 0) {
259  setEventMessages($hookmanager->error, $hookmanager->errors, 'errors');
260 }
261 
262 if (empty($reshook)) {
263  // Selection of new fields
264  include DOL_DOCUMENT_ROOT.'/core/actions_changeselectedfields.inc.php';
265 
266  // Purge search criteria
267  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
268  $search_all = '';
269  $search_ref = "";
270  $search_label = "";
271  $search_societe = "";
272  $search_societe_alias = '';
273  $search_status = -1;
274  $search_opp_status = -1;
275  $search_opp_amount = '';
276  $search_opp_percent = '';
277  $search_budget_amount = '';
278  $search_public = "";
279  $search_sale = "";
280  $search_project_user = '';
281  $search_project_contact = '';
282  $search_sday = "";
283  $search_smonth = "";
284  $search_syear = "";
285  $search_eday = "";
286  $search_emonth = "";
287  $search_eyear = "";
288  $search_date_start_startmonth = "";
289  $search_date_start_startyear = "";
290  $search_date_start_startday = "";
291  $search_date_start_start = "";
292  $search_date_start_endmonth = "";
293  $search_date_start_endyear = "";
294  $search_date_start_endday = "";
295  $search_date_start_end = "";
296  $search_date_end_startmonth = "";
297  $search_date_end_startyear = "";
298  $search_date_end_startday = "";
299  $search_date_end_start = "";
300  $search_date_end_endmonth = "";
301  $search_date_end_endyear = "";
302  $search_date_end_endday = "";
303  $search_date_end_end = "";
304  $search_usage_opportunity = '';
305  $search_usage_task = '';
306  $search_usage_bill_time = '';
307  $search_usage_event_organization = '';
308  $search_accept_conference_suggestions = '';
309  $search_accept_booth_suggestions = '';
310  $search_price_registration = '';
311  $search_price_booth = '';
312  $search_login = '';
313  $search_import_key = '';
314  $toselect = array();
315  $search_array_options = array();
316  $search_category_array = array();
317  }
318 
319 
320  // Mass actions
321  $objectclass = 'Project';
322  $objectlabel = 'Project';
323  $permissiontoread = $user->hasRight('projet', 'lire');
324  $permissiontodelete = $user->hasRight('projet', 'supprimer');
325  $permissiontoadd = $user->hasRight('projet', 'creer');
326  $uploaddir = $conf->project->dir_output;
327  include DOL_DOCUMENT_ROOT.'/core/actions_massactions.inc.php';
328 
329  // Close records
330  if (!$error && $massaction == 'close' && $user->hasRight('projet', 'creer')) {
331  $db->begin();
332 
333  $objecttmp = new $objectclass($db);
334  $nbok = 0;
335  foreach ($toselect as $toselectid) {
336  $result = $objecttmp->fetch($toselectid);
337  if ($result > 0) {
338  $userWrite = $object->restrictedProjectArea($user, 'write');
339  if ($userWrite > 0 && $objecttmp->statut == 1) {
340  $result = $objecttmp->setClose($user);
341  if ($result <= 0) {
342  setEventMessages($objecttmp->error, $objecttmp->errors, 'errors');
343  $error++;
344  break;
345  } else {
346  $nbok++;
347  }
348  } elseif ($userWrite <= 0) {
349  setEventMessages($langs->trans("DontHavePermissionForCloseProject", $objecttmp->ref), null, 'warnings');
350  } else {
351  setEventMessages($langs->trans("DontHaveTheValidateStatus", $objecttmp->ref), null, 'warnings');
352  }
353  } else {
354  setEventMessages($objecttmp->error, $objecttmp->errors, 'errors');
355  $error++;
356  break;
357  }
358  }
359 
360  if (!$error) {
361  if ($nbok > 1) {
362  setEventMessages($langs->trans("RecordsClosed", $nbok), null, 'mesgs');
363  } else {
364  setEventMessages($langs->trans("RecordsClosed", $nbok), null, 'mesgs');
365  }
366  $db->commit();
367  } else {
368  $db->rollback();
369  }
370  }
371 }
372 
373 
374 /*
375  * View
376  */
377 
378 unset($_SESSION['pageforbacktolist']['project']);
379 
380 $form = new Form($db);
381 $formcompany = new FormCompany($db);
382 
383 $now = dol_now();
384 
385 $companystatic = new Societe($db);
386 $taskstatic = new Task($db);
387 $formother = new FormOther($db);
388 $formproject = new FormProjets($db);
389 $userstatic = new User($db);
390 
391 $help_url = "EN:Module_Projects|FR:Module_Projets|ES:M&oacute;dulo_Proyectos";
392 $title = $langs->trans("LeadsOrProjects");
393 if (empty($conf->global->PROJECT_USE_OPPORTUNITIES)) {
394  $title = $langs->trans("Projects");
395 }
396 if (isset($conf->global->PROJECT_USE_OPPORTUNITIES) && $conf->global->PROJECT_USE_OPPORTUNITIES == 2) { // 2 = leads only
397  $title = $langs->trans("Leads");
398 }
399 $morejs = array();
400 $morecss = array();
401 
402 
403 // Get list of project id allowed to user (in a string list separated by comma)
404 $projectsListId = '';
405 if (empty($user->rights->projet->all->lire)) {
406  $projectsListId = $object->getProjectsAuthorizedForUser($user, 0, 1, $socid);
407 }
408 
409 // Get id of types of contacts for projects (This list never contains a lot of elements)
410 $listofprojectcontacttype = array();
411 $listofprojectcontacttypeexternal = array();
412 $sql = "SELECT ctc.rowid, ctc.code, ctc.source FROM ".MAIN_DB_PREFIX."c_type_contact as ctc";
413 $sql .= " WHERE ctc.element = '".$db->escape($object->element)."'";
414 $resql = $db->query($sql);
415 if ($resql) {
416  while ($obj = $db->fetch_object($resql)) {
417  if ($obj->source == 'internal') $listofprojectcontacttype[$obj->rowid] = $obj->code;
418  else $listofprojectcontacttypeexternal[$obj->rowid] = $obj->code;
419  }
420 } else {
421  dol_print_error($db);
422 }
423 if (count($listofprojectcontacttype) == 0) {
424  $listofprojectcontacttype[0] = '0'; // To avoid sql syntax error if not found
425 }
426 if (count($listofprojectcontacttypeexternal) == 0) {
427  $listofprojectcontacttypeexternal[0] = '0'; // To avoid sql syntax error if not found
428 }
429 
430 $varpage = empty($contextpage) ? $_SERVER["PHP_SELF"] : $contextpage;
431 $selectedfields = $form->multiSelectArrayWithCheckbox('selectedfields', $arrayfields, $varpage); // This also change content of $arrayfields
432 
433 $distinct = 'DISTINCT'; // We add distinct until filter on contact of project or task is implemented with AND EXISTS
434 $sql = "SELECT ".$distinct." p.rowid as id, p.ref, p.title, p.fk_statut as status, p.fk_opp_status, p.public, p.fk_user_creat,";
435 $sql .= " p.datec as date_creation, p.dateo as date_start, p.datee as date_end, p.opp_amount, p.opp_percent, (p.opp_amount*p.opp_percent/100) as opp_weighted_amount, p.tms as date_update, p.budget_amount,";
436 $sql .= " p.usage_opportunity, p.usage_task, p.usage_bill_time, p.usage_organize_event,";
437 $sql .= " p.email_msgid, p.import_key,";
438 $sql .= " p.accept_conference_suggestions, p.accept_booth_suggestions, p.price_registration, p.price_booth,";
439 $sql .= " s.rowid as socid, s.nom as name, s.name_alias as alias, s.email, s.email, s.phone, s.fax, s.address, s.town, s.zip, s.fk_pays, s.client, s.code_client,";
440 $sql .= " country.code as country_code,";
441 $sql .= " cls.code as opp_status_code,";
442 $sql .= ' u.login, u.lastname, u.firstname, u.email as user_email, u.statut as user_statut, u.entity, u.photo, u.office_phone, u.office_fax, u.user_mobile, u.job, u.gender';
443 // Add fields from extrafields
444 if (!empty($extrafields->attributes[$object->table_element]['label'])) {
445  foreach ($extrafields->attributes[$object->table_element]['label'] as $key => $val) {
446  $sql .= ($extrafields->attributes[$object->table_element]['type'][$key] != 'separate' ? ", ef.".$key." as options_".$key : '');
447  }
448 }
449 // Add fields from hooks
450 $parameters = array();
451 $reshook = $hookmanager->executeHooks('printFieldListSelect', $parameters, $object); // Note that $action and $object may have been modified by hook
452 $sql .= $hookmanager->resPrint;
453 $sql = preg_replace('/,\s*$/', '', $sql);
454 
455 $sqlfields = $sql; // $sql fields to remove for count total
456 
457 $sql .= " FROM ".MAIN_DB_PREFIX.$object->table_element." as p";
458 if (!empty($extrafields->attributes[$object->table_element]['label']) &&is_array($extrafields->attributes[$object->table_element]['label']) && count($extrafields->attributes[$object->table_element]['label'])) {
459  $sql .= " LEFT JOIN ".MAIN_DB_PREFIX.$object->table_element."_extrafields as ef on (p.rowid = ef.fk_object)";
460 }
461 $sql .= " LEFT JOIN ".MAIN_DB_PREFIX."societe as s on p.fk_soc = s.rowid";
462 $sql .= " LEFT JOIN ".MAIN_DB_PREFIX."c_country as country on (country.rowid = s.fk_pays)";
463 $sql .= " LEFT JOIN ".MAIN_DB_PREFIX."c_lead_status as cls on p.fk_opp_status = cls.rowid";
464 $sql .= ' LEFT JOIN '.MAIN_DB_PREFIX.'user AS u ON p.fk_user_creat = u.rowid';
465 // We'll need this table joined to the select in order to filter by sale
466 // No check is done on company permission because readability is managed by public status of project and assignement.
467 //if ($search_sale > 0 || (! $user->rights->societe->client->voir && ! $socid)) $sql .= " LEFT JOIN ".MAIN_DB_PREFIX."societe_commerciaux as sc ON sc.fk_soc = s.rowid";
468 if ($search_sale > 0) {
469  $sql .= " LEFT JOIN ".MAIN_DB_PREFIX."societe_commerciaux as sc ON sc.fk_soc = s.rowid";
470 }
471 if ($search_project_user > 0) {
472  $sql .= ", ".MAIN_DB_PREFIX."element_contact as ecp";
473 }
474 if ($search_project_contact > 0) {
475  $sql .= ", ".MAIN_DB_PREFIX."element_contact as ecp_contact";
476 }
477 
478 $reshook = $hookmanager->executeHooks('printFieldListFrom', $parameters, $object); // Note that $action and $object may have been modified by hook
479 $sql .= $hookmanager->resPrint;
480 
481 $sql .= " WHERE p.entity IN (".getEntity('project', (GETPOST('search_current_entity', 'int') ? 0 : 1)).')';
482 if (empty($user->rights->projet->all->lire)) {
483  $sql .= " AND p.rowid IN (".$db->sanitize($projectsListId).")"; // public and assigned to, or restricted to company for external users
484 }
485 // No need to check if company is external user, as filtering of projects must be done by getProjectsAuthorizedForUser
486 if ($socid > 0) {
487  $sql .= " AND (p.fk_soc = ".((int) $socid).")"; // This filter if when we use a hard coded filter on company on url (not related to filter for external users)
488 }
489 if ($search_ref) {
490  $sql .= natural_search('p.ref', $search_ref);
491 }
492 if ($search_label) {
493  $sql .= natural_search('p.title', $search_label);
494 }
495 if (empty($arrayfields['s.name_alias']['checked']) && $search_societe) {
496  $sql .= natural_search(array("s.nom", "s.name_alias"), $search_societe);
497 } else {
498  if ($search_societe) {
499  $sql .= natural_search('s.nom', $search_societe);
500  }
501  if ($search_societe_alias) {
502  $sql .= natural_search('s.name_alias', $search_societe_alias);
503  }
504 }
505 if ($search_opp_amount) {
506  $sql .= natural_search('p.opp_amount', $search_opp_amount, 1);
507 }
508 if ($search_opp_percent) {
509  $sql .= natural_search('p.opp_percent', $search_opp_percent, 1);
510 }
511 $sql .= dolSqlDateFilter('p.dateo', $search_sday, $search_smonth, $search_syear);
512 $sql .= dolSqlDateFilter('p.datee', $search_eday, $search_emonth, $search_eyear);
513 
514 if ($search_date_start_start) {
515  $sql .= " AND p.dateo >= '".$db->idate($search_date_start_start)."'";
516 }
517 if ($search_date_start_end) {
518  $sql .= " AND p.dateo <= '".$db->idate($search_date_start_end)."'";
519 }
520 
521 if ($search_date_end_start) {
522  $sql .= " AND p.datee >= '".$db->idate($search_date_end_start)."'";
523 }
524 if ($search_date_end_end) {
525  $sql .= " AND p.datee <= '".$db->idate($search_date_end_end)."'";
526 }
527 
528 if ($search_all) {
529  $sql .= natural_search(array_keys($fieldstosearchall), $search_all);
530 }
531 if ($search_status >= 0) {
532  if ($search_status == 99) {
533  $sql .= " AND p.fk_statut <> 2";
534  } else {
535  $sql .= " AND p.fk_statut = ".((int) $search_status);
536  }
537 }
538 if ($search_opp_status) {
539  if (is_numeric($search_opp_status) && $search_opp_status > 0) {
540  $sql .= " AND p.fk_opp_status = ".((int) $search_opp_status);
541  }
542  if ($search_opp_status == 'all') {
543  $sql .= " AND (p.fk_opp_status IS NOT NULL AND p.fk_opp_status <> -1)";
544  }
545  if ($search_opp_status == 'openedopp') {
546  $sql .= " AND p.fk_opp_status IS NOT NULL AND p.fk_opp_status <> -1 AND p.fk_opp_status NOT IN (SELECT rowid FROM ".MAIN_DB_PREFIX."c_lead_status WHERE code IN ('WON','LOST'))";
547  }
548  if ($search_opp_status == 'notopenedopp') {
549  $sql .= " AND (p.fk_opp_status IS NULL OR p.fk_opp_status = -1 OR p.fk_opp_status IN (SELECT rowid FROM ".MAIN_DB_PREFIX."c_lead_status WHERE code = 'WON'))";
550  }
551  if ($search_opp_status == 'none') {
552  $sql .= " AND (p.fk_opp_status IS NULL OR p.fk_opp_status = -1)";
553  }
554 }
555 if ($search_public != '') {
556  $sql .= " AND p.public = ".((int) $search_public);
557 }
558 // For external user, no check is done on company permission because readability is managed by public status of project and assignement.
559 //if ($socid > 0) $sql.= " AND s.rowid = ".((int) $socid);
560 if ($search_sale > 0) {
561  $sql .= " AND sc.fk_user = ".((int) $search_sale);
562 }
563 // No check is done on company permission because readability is managed by public status of project and assignement.
564 //if (! $user->rights->societe->client->voir && ! $socid) $sql.= " AND ((s.rowid = sc.fk_soc AND sc.fk_user = ".((int) $user->id).") OR (s.rowid IS NULL))";
565 if ($search_project_user > 0) {
566  // TODO Replace this with a EXISTS and remove the link to table + DISTINCT
567  $sql .= " AND ecp.fk_c_type_contact IN (".$db->sanitize(join(',', array_keys($listofprojectcontacttype))).") AND ecp.element_id = p.rowid AND ecp.fk_socpeople = ".((int) $search_project_user);
568 }
569 if ($search_project_contact > 0) {
570  // TODO Replace this with a EXISTS and remove the link to table + DISTINCT
571  $sql .= " AND ecp_contact.fk_c_type_contact IN (".$db->sanitize(join(',', array_keys($listofprojectcontacttypeexternal))).") AND ecp_contact.element_id = p.rowid AND ecp_contact.fk_socpeople = ".((int) $search_project_contact);
572 }
573 if ($search_opp_amount != '') {
574  $sql .= natural_search('p.opp_amount', $search_opp_amount, 1);
575 }
576 if ($search_budget_amount != '') {
577  $sql .= natural_search('p.budget_amount', $search_budget_amount, 1);
578 }
579 if ($search_usage_opportunity != '' && $search_usage_opportunity >= 0) {
580  $sql .= natural_search('p.usage_opportunity', $search_usage_opportunity, 2);
581 }
582 if ($search_usage_task != '' && $search_usage_task >= 0) {
583  $sql .= natural_search('p.usage_task', $search_usage_task, 2);
584 }
585 if ($search_usage_bill_time != '' && $search_usage_bill_time >= 0) {
586  $sql .= natural_search('p.usage_bill_time', $search_usage_bill_time, 2);
587 }
588 if ($search_usage_event_organization != '' && $search_usage_event_organization >= 0) {
589  $sql .= natural_search('p.usage_organize_event', $search_usage_event_organization, 2);
590 }
591 if ($search_accept_conference_suggestions != '' && $search_accept_conference_suggestions >= 0) {
592  $sql .= natural_search('p.accept_conference_suggestions', $search_accept_conference_suggestions, 2);
593 }
594 if ($search_accept_booth_suggestions != '' && $search_accept_booth_suggestions >= 0) {
595  $sql .= natural_search('p.accept_booth_suggestions', $search_accept_booth_suggestions, 2);
596 }
597 if ($search_price_registration != '') {
598  $sql .= natural_search('p.price_registration', $search_price_registration, 1);
599 }
600 if ($search_price_booth != '') {
601  $sql .= natural_search('p.price_booth', $search_price_booth, 1);
602 }
603 if ($search_login) {
604  $sql .= natural_search(array('u.login', 'u.firstname', 'u.lastname'), $search_login);
605 }
606 if ($search_import_key) {
607  $sql .= natural_search(array('p.import_key'), $search_import_key);
608 }
609 if (getDolGlobalInt('PROJECT_ENABLE_SUB_PROJECT')) {
610  if ($search_omitChildren == 1) {
611  $sql .= " AND p.fk_project IS NULL";
612  }
613 }
614 
615 // Search for tag/category ($searchCategoryProjectList is an array of ID)
616 $searchCategoryProjectList = $search_category_array;
617 $searchCategoryProjectOperator = 0;
618 if (!empty($searchCategoryProjectList)) {
619  $searchCategoryProjectSqlList = array();
620  $listofcategoryid = '';
621  foreach ($searchCategoryProjectList as $searchCategoryProject) {
622  if (intval($searchCategoryProject) == -2) {
623  $searchCategoryProjectSqlList[] = "NOT EXISTS (SELECT ck.fk_project FROM ".MAIN_DB_PREFIX."categorie_project as ck WHERE p.rowid = ck.fk_project)";
624  } elseif (intval($searchCategoryProject) > 0) {
625  if ($searchCategoryProjectOperator == 0) {
626  $searchCategoryProjectSqlList[] = " EXISTS (SELECT ck.fk_project FROM ".MAIN_DB_PREFIX."categorie_project as ck WHERE p.rowid = ck.fk_project AND ck.fk_categorie = ".((int) $searchCategoryProject).")";
627  } else {
628  $listofcategoryid .= ($listofcategoryid ? ', ' : '') .((int) $searchCategoryProject);
629  }
630  }
631  }
632  if ($listofcategoryid) {
633  $searchCategoryProjectSqlList[] = " EXISTS (SELECT ck.fk_project FROM ".MAIN_DB_PREFIX."categorie_project as ck WHERE p.rowid = ck.fk_project AND ck.fk_categorie IN (".$db->sanitize($listofcategoryid)."))";
634  }
635  if ($searchCategoryProjectOperator == 1) {
636  if (!empty($searchCategoryProjectSqlList)) {
637  $sql .= " AND (".implode(' OR ', $searchCategoryProjectSqlList).")";
638  }
639  } else {
640  if (!empty($searchCategoryProjectSqlList)) {
641  $sql .= " AND (".implode(' AND ', $searchCategoryProjectSqlList).")";
642  }
643  }
644 }
645 $searchCategoryCustomerSqlList = array();
646 if ($searchCategoryCustomerOperator == 1) {
647  $existsCategoryCustomerList = array();
648  foreach ($searchCategoryCustomerList as $searchCategoryCustomer) {
649  if (intval($searchCategoryCustomer) == -2) {
650  $sqlCategoryCustomerNotExists = " NOT EXISTS (";
651  $sqlCategoryCustomerNotExists .= " SELECT cat_cus.fk_soc";
652  $sqlCategoryCustomerNotExists .= " FROM ".$db->prefix()."categorie_societe AS cat_cus";
653  $sqlCategoryCustomerNotExists .= " WHERE cat_cus.fk_soc = p.fk_soc";
654  $sqlCategoryCustomerNotExists .= " )";
655  $searchCategoryCustomerSqlList[] = $sqlCategoryCustomerNotExists;
656  } elseif (intval($searchCategoryCustomer) > 0) {
657  $existsCategoryCustomerList[] = $db->escape($searchCategoryCustomer);
658  }
659  }
660  if (!empty($existsCategoryCustomerList)) {
661  $sqlCategoryCustomerExists = " EXISTS (";
662  $sqlCategoryCustomerExists .= " SELECT cat_cus.fk_soc";
663  $sqlCategoryCustomerExists .= " FROM ".$db->prefix()."categorie_societe AS cat_cus";
664  $sqlCategoryCustomerExists .= " WHERE cat_cus.fk_soc = p.fk_soc";
665  $sqlCategoryCustomerExists .= " AND cat_cus.fk_categorie IN (".$db->sanitize(implode(',', $existsCategoryCustomerList)).")";
666  $sqlCategoryCustomerExists .= " )";
667  $searchCategoryCustomerSqlList[] = $sqlCategoryCustomerExists;
668  }
669  if (!empty($searchCategoryCustomerSqlList)) {
670  $sql .= " AND (".implode(' OR ', $searchCategoryCustomerSqlList).")";
671  }
672 } else {
673  foreach ($searchCategoryCustomerList as $searchCategoryCustomer) {
674  if (intval($searchCategoryCustomer) == -2) {
675  $sqlCategoryCustomerNotExists = " NOT EXISTS (";
676  $sqlCategoryCustomerNotExists .= " SELECT cat_cus.fk_soc";
677  $sqlCategoryCustomerNotExists .= " FROM ".$db->prefix()."categorie_societe AS cat_cus";
678  $sqlCategoryCustomerNotExists .= " WHERE cat_cus.fk_soc = p.fk_soc";
679  $sqlCategoryCustomerNotExists .= " )";
680  $searchCategoryCustomerSqlList[] = $sqlCategoryCustomerNotExists;
681  } elseif (intval($searchCategoryCustomer) > 0) {
682  $searchCategoryCustomerSqlList[] = "p.fk_soc IN (SELECT fk_soc FROM ".$db->prefix()."categorie_societe WHERE fk_categorie = ".((int) $searchCategoryCustomer).")";
683  }
684  }
685  if (!empty($searchCategoryCustomerSqlList)) {
686  $sql .= " AND (".implode(' AND ', $searchCategoryCustomerSqlList).")";
687  }
688 }
689 // Add where from extra fields
690 include DOL_DOCUMENT_ROOT.'/core/tpl/extrafields_list_search_sql.tpl.php';
691 // Add where from hooks
692 $parameters = array();
693 $reshook = $hookmanager->executeHooks('printFieldListWhere', $parameters, $object); // Note that $action and $object may have been modified by hook
694 $sql .= $hookmanager->resPrint;
695 //print $sql;
696 
697 // Count total nb of records
698 $nbtotalofrecords = '';
699 if (!getDolGlobalInt('MAIN_DISABLE_FULL_SCANLIST')) {
700  /* The fast and low memory method to get and count full list converts the sql into a sql count */
701  $sqlforcount = preg_replace('/^'.preg_quote($sqlfields, '/').'/', 'SELECT COUNT(*) as nbtotalofrecords', $sql);
702  $sqlforcount = preg_replace('/GROUP BY .*$/', '', $sqlforcount);
703  $resql = $db->query($sqlforcount);
704  if ($resql) {
705  $objforcount = $db->fetch_object($resql);
706  $nbtotalofrecords = $objforcount->nbtotalofrecords;
707  } else {
708  dol_print_error($db);
709  }
710 
711  if (($page * $limit) > $nbtotalofrecords) { // if total resultset is smaller then paging size (filtering), goto and load page 0
712  $page = 0;
713  $offset = 0;
714  }
715  $db->free($resql);
716 }
717 
718 // Complete request and execute it with limit
719 $sql .= $db->order($sortfield, $sortorder);
720 if ($limit) {
721  $sql .= $db->plimit($limit + 1, $offset);
722 }
723 
724 $resql = $db->query($sql);
725 if (!$resql) {
726  dol_print_error($db);
727  exit;
728 }
729 
730 $num = $db->num_rows($resql);
731 
732 // Direct jump if only one record found
733 if ($num == 1 && !empty($conf->global->MAIN_SEARCH_DIRECT_OPEN_IF_ONLY_ONE) && $search_all && !$page) {
734  $obj = $db->fetch_object($resql);
735  header("Location: ".DOL_URL_ROOT.'/projet/card.php?id='.$obj->id);
736  exit;
737 }
738 
739 
740 // Output page
741 // --------------------------------------------------------------------
742 
743 llxHeader('', $title, $help_url);
744 
745 $arrayofselected = is_array($toselect) ? $toselect : array();
746 
747 $param = '';
748 if (!empty($mode)) {
749  $param .= '&mode='.urlencode($mode);
750 }
751 if (!empty($contextpage) && $contextpage != $_SERVER["PHP_SELF"]) {
752  $param .= '&contextpage='.urlencode($contextpage);
753 }
754 if ($limit > 0 && $limit != $conf->liste_limit) {
755  $param .= '&limit='.((int) $limit);
756 }
757 if ($search_all != '') {
758  $param .= '&search_all='.urlencode($search_all);
759 }
760 if ($search_sday) {
761  $param .= '&search_sday='.urlencode($search_sday);
762 }
763 if ($search_smonth) {
764  $param .= '&search_smonth='.urlencode($search_smonth);
765 }
766 if ($search_syear) {
767  $param .= '&search_syear='.urlencode($search_syear);
768 }
769 if ($search_eday) {
770  $param .= '&search_eday='.urlencode($search_eday);
771 }
772 if ($search_emonth) {
773  $param .= '&search_emonth='.urlencode($search_emonth);
774 }
775 if ($search_eyear) {
776  $param .= '&search_eyear='.urlencode($search_eyear);
777 }
778 if ($search_date_start_startmonth) {
779  $param .= '&search_date_start_startmonth='.urlencode($search_date_start_startmonth);
780 }
781 if ($search_date_start_startyear) {
782  $param .= '&search_date_start_startyear='.urlencode($search_date_start_startyear);
783 }
784 if ($search_date_start_startday) {
785  $param .= '&search_date_start_startday='.urlencode($search_date_start_startday);
786 }
787 if ($search_date_start_start) {
788  $param .= '&search_date_start_start='.urlencode($search_date_start_start);
789 }
790 if ($search_date_start_endmonth) {
791  $param .= '&search_date_start_endmonth='.urlencode($search_date_start_endmonth);
792 }
793 if ($search_date_start_endyear) {
794  $param .= '&search_date_start_endyear='.urlencode($search_date_start_endyear);
795 }
796 if ($search_date_start_endday) {
797  $param .= '&search_date_start_endday='.urlencode($search_date_start_endday);
798 }
799 if ($search_date_start_end) {
800  $param .= '&search_date_start_end='.urlencode($search_date_start_end);
801 }
802 if ($search_date_end_startmonth) {
803  $param .= '&search_date_end_startmonth='.urlencode($search_date_end_startmonth);
804 }
805 if ($search_date_end_startyear) {
806  $param .= '&search_date_end_startyear='.urlencode($search_date_end_startyear);
807 }
808 if ($search_date_end_startday) {
809  $param .= '&search_date_end_startday='.urlencode($search_date_end_startday);
810 }
811 if ($search_date_end_start) {
812  $param .= '&search_date_end_start='.urlencode($search_date_end_start);
813 }
814 if ($search_date_end_endmonth) {
815  $param .= '&search_date_end_endmonth='.urlencode($search_date_end_endmonth);
816 }
817 if ($search_date_end_endyear) {
818  $param .= '&search_date_end_endyear='.urlencode($search_date_end_endyear);
819 }
820 if ($search_date_end_endday) {
821  $param .= '&search_date_end_endday='.urlencode($search_date_end_endday);
822 }
823 if ($search_date_end_end) {
824  $param .= '&search_date_end_end=' . urlencode($search_date_end_end);
825 }
826 if ($socid) {
827  $param .= '&socid='.urlencode($socid);
828 }
829 if (!empty($search_category_array)) {
830  foreach ($search_category_array as $tmpval) {
831  $param .= '&search_categegory_project_list[]='.urlencode($tmpval);
832  }
833 }
834 if ($search_ref != '') {
835  $param .= '&search_ref='.urlencode($search_ref);
836 }
837 if ($search_label != '') {
838  $param .= '&search_label='.urlencode($search_label);
839 }
840 if ($search_societe != '') {
841  $param .= '&search_societe='.urlencode($search_societe);
842 }
843 if ($search_societe_alias != '') {
844  $param .= '&search_societe_alias='.urlencode($search_societe_alias);
845 }
846 if ($search_status >= 0) {
847  $param .= '&search_status='.urlencode($search_status);
848 }
849 if ((is_numeric($search_opp_status) && $search_opp_status >= 0) || in_array($search_opp_status, array('all', 'openedopp', 'notopenedopp', 'none'))) {
850  $param .= '&search_opp_status='.urlencode($search_opp_status);
851 }
852 if ($search_opp_percent != '') {
853  $param .= '&search_opp_percent='.urlencode($search_opp_percent);
854 }
855 if ($search_public != '') {
856  $param .= '&search_public='.urlencode($search_public);
857 }
858 if ($search_project_user > 0) {
859  $param .= '&search_project_user='.urlencode($search_project_user);
860 }
861 if ($search_project_contact > 0) {
862  $param .= '&search_project_contact='.urlencode($search_project_contact);
863 }
864 if ($search_sale > 0) {
865  $param .= '&search_sale='.urlencode($search_sale);
866 }
867 if ($search_opp_amount != '') {
868  $param .= '&search_opp_amount='.urlencode($search_opp_amount);
869 }
870 if ($search_budget_amount != '') {
871  $param .= '&search_budget_amount='.urlencode($search_budget_amount);
872 }
873 if ($search_usage_task != '') {
874  $param .= '&search_usage_task='.urlencode($search_usage_task);
875 }
876 if ($search_usage_bill_time != '') {
877  $param .= '&search_usage_opportunity='.urlencode($search_usage_bill_time);
878 }
879 if ($search_usage_event_organization != '') {
880  $param .= '&search_usage_event_organization='.urlencode($search_usage_event_organization);
881 }
882 if ($search_accept_conference_suggestions != '') {
883  $param .= '&search_accept_conference_suggestions='.urlencode($search_accept_conference_suggestions);
884 }
885 if ($search_accept_booth_suggestions != '') {
886  $param .= '&search_accept_booth_suggestions='.urlencode($search_accept_booth_suggestions);
887 }
888 if ($search_price_registration != '') {
889  $param .= '&search_price_registration='.urlencode($search_price_registration);
890 }
891 if ($search_price_booth != '') {
892  $param .= '&search_price_booth='.urlencode($search_price_booth);
893 }
894 if ($search_login) {
895  $param .= '&search_login='.urlencode($search_login);
896 }
897 if ($search_import_key) {
898  $param .= '&search_import_key='.urlencode($search_import_key);
899 }
900 if ($optioncss != '') {
901  $param .= '&optioncss='.urlencode($optioncss);
902 }
903 foreach ($searchCategoryCustomerList as $searchCategoryCustomer) {
904  $param .= "&search_category_customer_list[]=".urlencode($searchCategoryCustomer);
905 }
906 // Add $param from extra fields
907 include DOL_DOCUMENT_ROOT.'/core/tpl/extrafields_list_search_param.tpl.php';
908 
909 // List of mass actions available
910 $arrayofmassactions = array(
911  'validate'=>img_picto('', 'check', 'class="pictofixedwidth"').$langs->trans("Validate"),
912  'generate_doc'=>img_picto('', 'pdf', 'class="pictofixedwidth"').$langs->trans("ReGeneratePDF"),
913  //'builddoc'=>img_picto('', 'pdf', 'class="pictofixedwidth"').$langs->trans("PDFMerge"),
914  //'presend'=>img_picto('', 'email', 'class="pictofixedwidth"').$langs->trans("SendByMail"),
915 );
916 //if($user->rights->societe->creer) $arrayofmassactions['createbills']=$langs->trans("CreateInvoiceForThisCustomer");
917 if ($user->hasRight('projet', 'creer')) {
918  $arrayofmassactions['close'] = img_picto('', 'close_title', 'class="pictofixedwidth"').$langs->trans("Close");
919  $arrayofmassactions['preaffectuser'] = img_picto('', 'user', 'class="pictofixedwidth"').$langs->trans("AffectUser");
920 }
921 if ($user->hasRight('projet', 'supprimer')) {
922  $arrayofmassactions['predelete'] = img_picto('', 'delete', 'class="pictofixedwidth"').$langs->trans("Delete");
923 }
924 if (isModEnabled('category') && $user->hasRight('projet', 'creer')) {
925  $arrayofmassactions['preaffecttag'] = img_picto('', 'category', 'class="pictofixedwidth"').$langs->trans("AffectTag");
926 }
927 if (in_array($massaction, array('presend', 'predelete', 'preaffecttag', 'preaffectuser'))) {
928  $arrayofmassactions = array();
929 }
930 
931 $massactionbutton = $form->selectMassAction('', $arrayofmassactions);
932 
933 $url = DOL_URL_ROOT.'/projet/card.php?action=create';
934 if (!empty($socid)) {
935  $url .= '&socid='.$socid;
936 }
937 if ($search_usage_event_organization == 1) {
938  $url .= '&usage_organize_event=1';
939  if (((int) $search_usage_opportunity) < 1) {
940  $url .= '&usage_opportunity=0';
941  }
942 }
943 
944 $newcardbutton = '';
945 $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'));
946 $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'));
947 $newcardbutton .= dolGetButtonTitle($langs->trans('NewProject'), '', 'fa fa-plus-circle', $url, '', $user->hasRight('projet', 'creer'));
948 
949 print '<form method="POST" id="searchFormList" action="'.$_SERVER["PHP_SELF"].'">';
950 if ($optioncss != '') {
951  print '<input type="hidden" name="optioncss" value="'.$optioncss.'">';
952 }
953 print '<input type="hidden" name="token" value="'.newToken().'">';
954 print '<input type="hidden" name="formfilteraction" id="formfilteraction" value="list">';
955 print '<input type="hidden" name="action" value="list">';
956 print '<input type="hidden" name="sortfield" value="'.$sortfield.'">';
957 print '<input type="hidden" name="sortorder" value="'.$sortorder.'">';
958 print '<input type="hidden" name="contextpage" value="'.$contextpage.'">';
959 print '<input type="hidden" name="mode" value="'.$mode.'">';
960 
961 
962 // Show description of content
963 $texthelp = '';
964 if ($search_project_user == $user->id) {
965  $texthelp .= $langs->trans("MyProjectsDesc");
966 } else {
967  if ($user->hasRight('projet', 'all', 'lire') && !$socid) {
968  $texthelp .= $langs->trans("ProjectsDesc");
969  } else {
970  $texthelp .= $langs->trans("ProjectsPublicDesc");
971  }
972 }
973 
974 print_barre_liste($form->textwithpicto($title, $texthelp), $page, $_SERVER["PHP_SELF"], $param, $sortfield, $sortorder, $massactionbutton, $num, $nbtotalofrecords, 'project', 0, $newcardbutton, '', $limit, 0, 0, 1);
975 
976 
977 $topicmail = "Information";
978 $modelmail = "project";
979 $objecttmp = new Project($db);
980 $trackid = 'proj'.$object->id;
981 include DOL_DOCUMENT_ROOT.'/core/tpl/massactions_pre.tpl.php';
982 
983 if ($search_all) {
984  foreach ($fieldstosearchall as $key => $val) {
985  $fieldstosearchall[$key] = $langs->trans($val);
986  }
987  print '<div class="divsearchfieldfilter">'.$langs->trans("FilterOnInto", $search_all).join(', ', $fieldstosearchall).'</div>';
988 }
989 
990 $moreforfilter = '';
991 
992 // If the user can view user other than himself
993 $moreforfilter .= '<div class="divsearchfield">';
994 $tmptitle = $langs->trans('ProjectsWithThisUserAsContact');
995 //$includeonly = 'hierarchyme';
996 $includeonly = '';
997 if (empty($user->rights->user->user->lire)) {
998  $includeonly = array($user->id);
999 }
1000 $moreforfilter .= img_picto($tmptitle, 'user', 'class="pictofixedwidth"').$form->select_dolusers($search_project_user ? $search_project_user : '', 'search_project_user', $tmptitle, '', 0, $includeonly, '', 0, 0, 0, '', 0, '', 'maxwidth300 widthcentpercentminusx');
1001 $moreforfilter .= '</div>';
1002 
1003 $moreforfilter .= '<div class="divsearchfield">';
1004 $tmptitle = $langs->trans('ProjectsWithThisContact');
1005 $moreforfilter .= img_picto($tmptitle, 'contact', 'class="pictofixedwidth"').$form->selectcontacts(0, $search_project_contact ? $search_project_contact : '', 'search_project_contact', $tmptitle, '', '', 0, 'maxwidth300 widthcentpercentminusx');
1006 $moreforfilter .= '</div>';
1007 
1008 // If the user can view thirdparties other than his'
1009 if ($user->rights->user->user->lire) {
1010  $langs->load("commercial");
1011  $moreforfilter .= '<div class="divsearchfield">';
1012  $tmptitle = $langs->trans('ThirdPartiesOfSaleRepresentative');
1013  $moreforfilter .= img_picto($tmptitle, 'user', 'class="pictofixedwidth"').$formother->select_salesrepresentatives($search_sale, 'search_sale', $user, 0, $tmptitle, 'maxwidth300 widthcentpercentminusx');
1014  $moreforfilter .= '</div>';
1015 }
1016 
1017 // Filter on categories
1018 if (isModEnabled('categorie') && $user->hasRight('categorie', 'lire')) {
1019  $formcategory = new FormCategory($db);
1020  $moreforfilter .= $formcategory->getFilterBox(Categorie::TYPE_PROJECT, $search_category_array, 'minwidth300imp minwidth300 widthcentpercentminusx');
1021 }
1022 // Filter on customer categories
1023 if (!empty($conf->global->MAIN_SEARCH_CATEGORY_CUSTOMER_ON_PROJECT_LIST) && isModEnabled("categorie") && $user->hasRight('categorie', 'lire')) {
1024  $moreforfilter .= '<div class="divsearchfield">';
1025  $tmptitle = $langs->transnoentities('CustomersProspectsCategoriesShort');
1026  $moreforfilter .= img_picto($tmptitle, 'category', 'class="pictofixedwidth"');
1027  $categoriesArr = $form->select_all_categories(Categorie::TYPE_CUSTOMER, '', '', 64, 0, 1);
1028  $categoriesArr[-2] = '- '.$langs->trans('NotCategorized').' -';
1029  $moreforfilter .= Form::multiselectarray('search_category_customer_list', $categoriesArr, $searchCategoryCustomerList, 0, 0, 'minwidth300im minwidth300 widthcentpercentminusx', 0, 0, '', 'category', $tmptitle);
1030  $moreforfilter .= ' <input type="checkbox" class="valignmiddle" id="search_category_customer_operator" name="search_category_customer_operator" value="1"'.($searchCategoryCustomerOperator == 1 ? ' checked="checked"' : '').'/>';
1031  $moreforfilter .= $form->textwithpicto('', $langs->trans('UseOrOperatorForCategories') . ' : ' . $tmptitle, 1, 'help', '', 0, 2, 'tooltip_cat_cus'); // Tooltip on click
1032  $moreforfilter .= '</div>';
1033 }
1034 
1035 if (getDolGlobalInt('PROJECT_ENABLE_SUB_PROJECT')) {
1036  //Checkbox for omitting child projects filter
1037  $moreforfilter .= '<p style="display: inline-block; margin-left: 5px;">'.$langs->trans("Omit sub-projects").' </p><input type="checkbox" style="margin-left: 10px" class="valignmiddle" id="search_omitChildren" name="search_omitChildren"'.($search_omitChildren ? ' checked="checked"' : '').'"> ';
1038 }
1039 
1040 if (!empty($moreforfilter)) {
1041  print '<div class="liste_titre liste_titre_bydiv centpercent">';
1042  print $moreforfilter;
1043  $parameters = array();
1044  $reshook = $hookmanager->executeHooks('printFieldPreListTitle', $parameters); // Note that $action and $object may have been modified by hook
1045  print $hookmanager->resPrint;
1046  print '</div>';
1047 }
1048 
1049 $varpage = empty($contextpage) ? $_SERVER["PHP_SELF"] : $contextpage;
1050 $selectedfields = ($mode != 'kanban' ? $form->multiSelectArrayWithCheckbox('selectedfields', $arrayfields, $varpage, getDolGlobalString('MAIN_CHECKBOX_LEFT_COLUMN', '')) : ''); // This also change content of $arrayfields
1051 $selectedfields .= (count($arrayofmassactions) ? $form->showCheckAddButtons('checkforselect', 1) : '');
1052 
1053 
1054 print '<div class="div-table-responsive">';
1055 print '<table class="tagtable nobottomiftotal liste'.($moreforfilter ? " listwithfilterbefore" : "").'">'."\n";
1056 
1057 // Fields title search
1058 // --------------------------------------------------------------------
1059 print '<tr class="liste_titre_filter">';
1060 // Action column
1061 if (!empty($conf->global->MAIN_CHECKBOX_LEFT_COLUMN)) {
1062  print '<td class="liste_titre maxwidthsearch">';
1063  $searchpicto = $form->showFilterButtons('left');
1064  print $searchpicto;
1065  print '</td>';
1066 }
1067 // Project ref
1068 if (!empty($arrayfields['p.ref']['checked'])) {
1069  print '<td class="liste_titre">';
1070  print '<input type="text" class="flat" name="search_ref" value="'.dol_escape_htmltag($search_ref).'" size="6">';
1071  print '</td>';
1072 }
1073 // Project label
1074 if (!empty($arrayfields['p.title']['checked'])) {
1075  print '<td class="liste_titre">';
1076  print '<input type="text" class="flat" name="search_label" size="8" value="'.dol_escape_htmltag($search_label).'">';
1077  print '</td>';
1078 }
1079 // Third party
1080 if (!empty($arrayfields['s.nom']['checked'])) {
1081  print '<td class="liste_titre">';
1082  if ($socid > 0) {
1083  $tmpthirdparty = new Societe($db);
1084  $tmpthirdparty->fetch($socid);
1085  $search_societe = $tmpthirdparty->name;
1086  }
1087  print '<input type="text" class="flat" name="search_societe" size="8" value="'.dol_escape_htmltag($search_societe).'">';
1088  print '</td>';
1089 }
1090 
1091 // Alias
1092 if (!empty($arrayfields['s.name_alias']['checked'])) {
1093  print '<td class="liste_titre">';
1094  if ($socid > 0) {
1095  $tmpthirdparty = new Societe($db);
1096  $tmpthirdparty->fetch($socid);
1097  $search_societe_alias = $tmpthirdparty->name_alias;
1098  }
1099  print '<input type="text" class="flat" name="search_societe_alias" size="8" value="'.dol_escape_htmltag($search_societe_alias).'">';
1100  print '</td>';
1101 }
1102 // Sale representative
1103 if (!empty($arrayfields['commercial']['checked'])) {
1104  print '<td class="liste_titre">&nbsp;</td>';
1105 }
1106 // Start date
1107 if (!empty($arrayfields['p.dateo']['checked'])) {
1108  print '<td class="liste_titre center nowraponall">';
1109  /*if (!empty($conf->global->MAIN_LIST_FILTER_ON_DAY)) {
1110  print '<input class="flat valignmiddle" type="text" size="1" maxlength="2" name="search_sday" value="'.dol_escape_htmltag($search_sday).'">';
1111  }
1112  print '<input class="flat valignmiddle" type="text" size="1" maxlength="2" name="search_smonth" value="'.dol_escape_htmltag($search_smonth).'">';
1113  print $formother->selectyear($search_syear ? $search_syear : -1, 'search_syear', 1, 20, 5, 0, 0, '', 'widthauto valignmiddle');*/
1114  print '<div class="nowrap">';
1115  print $form->selectDate($search_date_start_start ? $search_date_start_start : -1, 'search_date_start_start', 0, 0, 1, '', 1, 0, 0, '', '', '', '', 1, '', $langs->trans('From'));
1116  print '</div>';
1117  print '<div class="nowrap">';
1118  print $form->selectDate($search_date_start_end ? $search_date_start_end : -1, 'search_date_start_end', 0, 0, 1, '', 1, 0, 0, '', '', '', '', 1, '', $langs->trans('to'));
1119  print '</div>';
1120  print '</td>';
1121 }
1122 // End date
1123 if (!empty($arrayfields['p.datee']['checked'])) {
1124  print '<td class="liste_titre center nowraponall">';
1125  /*if (!empty($conf->global->MAIN_LIST_FILTER_ON_DAY)) {
1126  print '<input class="flat valignmiddle" type="text" size="1" maxlength="2" name="search_eday" value="'.dol_escape_htmltag($search_eday).'">';
1127  }
1128  print '<input class="flat valignmiddle" type="text" size="1" maxlength="2" name="search_emonth" value="'.dol_escape_htmltag($search_emonth).'">';
1129  print $formother->selectyear($search_eyear ? $search_eyear : -1, 'search_eyear', 1, 20, 5, 0, 0, '', 'widthauto valignmiddle');*/
1130  print '<div class="nowrap">';
1131  print $form->selectDate($search_date_end_start ? $search_date_end_start : -1, 'search_date_end_start', 0, 0, 1, '', 1, 0, 0, '', '', '', '', 1, '', $langs->trans('From'));
1132  print '</div>';
1133  print '<div class="nowrap">';
1134  print $form->selectDate($search_date_end_end ? $search_date_end_end : -1, 'search_date_end_end', 0, 0, 1, '', 1, 0, 0, '', '', '', '', 1, '', $langs->trans('to'));
1135  print '</div>';
1136  print '</td>';
1137 }
1138 // Visibility
1139 if (!empty($arrayfields['p.public']['checked'])) {
1140  print '<td class="liste_titre center">';
1141  $array = array(''=>'', 0 => $langs->trans("PrivateProject"), 1 => $langs->trans("SharedProject"));
1142  print $form->selectarray('search_public', $array, $search_public, 0, 0, 0, '', 0, 0, 0, '', 'maxwidth75');
1143  print '</td>';
1144 }
1145 if (!empty($arrayfields['c.assigned']['checked'])) {
1146  print '<td class="liste_titre center">';
1147  print '</td>';
1148 }
1149 // Opp status
1150 if (!empty($arrayfields['p.fk_opp_status']['checked'])) {
1151  print '<td class="liste_titre nowrap center">';
1152  print $formproject->selectOpportunityStatus('search_opp_status', $search_opp_status, 1, 1, 1, 0, 'maxwidth125 nowrapoption', 1, 1);
1153  print '</td>';
1154 }
1155 if (!empty($arrayfields['p.opp_amount']['checked'])) {
1156  print '<td class="liste_titre nowrap right">';
1157  print '<input type="text" class="flat" name="search_opp_amount" size="3" value="'.$search_opp_amount.'">';
1158  print '</td>';
1159 }
1160 if (!empty($arrayfields['p.opp_percent']['checked'])) {
1161  print '<td class="liste_titre nowrap right">';
1162  print '<input type="text" class="flat" name="search_opp_percent" size="2" value="'.$search_opp_percent.'">';
1163  print '</td>';
1164 }
1165 if (!empty($arrayfields['opp_weighted_amount']['checked'])) {
1166  print '<td class="liste_titre nowrap right">';
1167  print '</td>';
1168 }
1169 if (!empty($arrayfields['p.budget_amount']['checked'])) {
1170  print '<td class="liste_titre nowrap right">';
1171  print '<input type="text" class="flat" name="search_budget_amount" size="4" value="'.$search_budget_amount.'">';
1172  print '</td>';
1173 }
1174 if (!empty($arrayfields['p.usage_opportunity']['checked'])) {
1175  print '<td class="liste_titre nowrap">';
1176  print $form->selectyesno('search_usage_opportunity', $search_usage_opportunity, 1, false, 1, 1);
1177  print '';
1178  print '</td>';
1179 }
1180 if (!empty($arrayfields['p.usage_task']['checked'])) {
1181  print '<td class="liste_titre nowrap">';
1182  print $form->selectyesno('search_usage_task', $search_usage_task, 1, false, 1, 1);
1183  print '</td>';
1184 }
1185 if (!empty($arrayfields['p.usage_bill_time']['checked'])) {
1186  print '<td class="liste_titre nowrap">';
1187  print $form->selectyesno('search_usage_bill_time', $search_usage_bill_time, 1, false, 1, 1);
1188  print '</td>';
1189 }
1190 if (!empty($arrayfields['p.usage_organize_event']['checked'])) {
1191  print '<td class="liste_titre nowrap">';
1192  print $form->selectyesno('search_usage_event_organization', $search_usage_event_organization, 1, false, 1, 1);
1193  print '</td>';
1194 }
1195 if (!empty($arrayfields['p.accept_conference_suggestions']['checked'])) {
1196  print '<td class="liste_titre nowrap">';
1197  print $form->selectyesno('search_accept_conference_suggestions', $search_accept_conference_suggestions, 1, false, 1, 1);
1198  print '</td>';
1199 }
1200 if (!empty($arrayfields['p.accept_booth_suggestions']['checked'])) {
1201  print '<td class="liste_titre nowrap">';
1202  print $form->selectyesno('search_accept_booth_suggestions', $search_accept_booth_suggestions, 1, false, 1, 1);
1203  print '</td>';
1204 }
1205 if (!empty($arrayfields['p.price_registration']['checked'])) {
1206  print '<td class="liste_titre nowrap right">';
1207  print '<input type="text" class="flat" name="search_price_registration" size="4" value="'.dol_escape_htmltag($search_price_registration).'">';
1208  print '</td>';
1209 }
1210 if (!empty($arrayfields['p.price_booth']['checked'])) {
1211  print '<td class="liste_titre nowrap right">';
1212  print '<input type="text" class="flat" name="search_price_booth" size="4" value="'.dol_escape_htmltag($search_price_booth).'">';
1213  print '</td>';
1214 }
1215 if (!empty($arrayfields['u.login']['checked'])) {
1216  // Author
1217  print '<td class="liste_titre" align="center">';
1218  print '<input class="flat" size="4" type="text" name="search_login" value="'.dol_escape_htmltag($search_login).'">';
1219  print '</td>';
1220 }
1221 // Extra fields
1222 include DOL_DOCUMENT_ROOT.'/core/tpl/extrafields_list_search_input.tpl.php';
1223 
1224 // Fields from hook
1225 $parameters = array('arrayfields'=>$arrayfields);
1226 $reshook = $hookmanager->executeHooks('printFieldListOption', $parameters); // Note that $action and $object may have been modified by hook
1227 print $hookmanager->resPrint;
1228 if (!empty($arrayfields['p.datec']['checked'])) {
1229  // Date creation
1230  print '<td class="liste_titre">';
1231  print '</td>';
1232 }
1233 if (!empty($arrayfields['p.tms']['checked'])) {
1234  // Date modification
1235  print '<td class="liste_titre">';
1236  print '</td>';
1237 }
1238 if (!empty($arrayfields['p.email_msgid']['checked'])) {
1239  // Email msg id
1240  print '<td class="liste_titre">';
1241  print '</td>';
1242 }
1243 if (!empty($arrayfields['p.import_key']['checked'])) {
1244  // Import key
1245  print '<td class="liste_titre">';
1246  print '<input class="flat width75" type="text" name="search_import_key" value="'.dol_escape_htmltag($search_import_key).'">';
1247  print '</td>';
1248 }
1249 if (!empty($arrayfields['p.fk_statut']['checked'])) {
1250  print '<td class="liste_titre center parentonrightofpage">';
1251  $arrayofstatus = array();
1252  foreach ($object->statuts_short as $key => $val) {
1253  $arrayofstatus[$key] = $langs->trans($val);
1254  }
1255  $arrayofstatus['99'] = $langs->trans("NotClosed").' ('.$langs->trans('Draft').' + '.$langs->trans('Opened').')';
1256  print $form->selectarray('search_status', $arrayofstatus, $search_status, 1, 0, 0, '', 0, 0, 0, '', 'search_status width100 onrightofpage', 1);
1257  print '</td>';
1258 }
1259 // Action column
1260 if (empty($conf->global->MAIN_CHECKBOX_LEFT_COLUMN)) {
1261  print '<td class="liste_titre maxwidthsearch">';
1262  $searchpicto = $form->showFilterButtons();
1263  print $searchpicto;
1264  print '</td>';
1265 }
1266 print '</tr>'."\n";
1267 
1268 $totalarray = array();
1269 $totalarray['nbfield'] = 0;
1270 
1271 // Fields title label
1272 // --------------------------------------------------------------------
1273 print '<tr class="liste_titre">';
1274 if (getDolGlobalString('MAIN_CHECKBOX_LEFT_COLUMN')) {
1275  print getTitleFieldOfList($selectedfields, 0, $_SERVER["PHP_SELF"], '', '', '', '', $sortfield, $sortorder, 'center maxwidthsearch ')."\n";
1276  $totalarray['nbfield']++;
1277 }
1278 if (!empty($arrayfields['p.ref']['checked'])) {
1279  print_liste_field_titre($arrayfields['p.ref']['label'], $_SERVER["PHP_SELF"], "p.ref", "", $param, "", $sortfield, $sortorder);
1280  $totalarray['nbfield']++;
1281 }
1282 if (!empty($arrayfields['p.title']['checked'])) {
1283  print_liste_field_titre($arrayfields['p.title']['label'], $_SERVER["PHP_SELF"], "p.title", "", $param, "", $sortfield, $sortorder);
1284  $totalarray['nbfield']++;
1285 }
1286 if (!empty($arrayfields['s.nom']['checked'])) {
1287  print_liste_field_titre($arrayfields['s.nom']['label'], $_SERVER["PHP_SELF"], "s.nom", "", $param, "", $sortfield, $sortorder);
1288  $totalarray['nbfield']++;
1289 }
1290 if (!empty($arrayfields['s.name_alias']['checked'])) {
1291  print_liste_field_titre($arrayfields['s.name_alias']['label'], $_SERVER["PHP_SELF"], "s.name_alias", "", $param, "", $sortfield, $sortorder);
1292  $totalarray['nbfield']++;
1293 }
1294 if (!empty($arrayfields['commercial']['checked'])) {
1295  print_liste_field_titre($arrayfields['commercial']['label'], $_SERVER["PHP_SELF"], "", "", $param, "", $sortfield, $sortorder, 'tdoverflowmax100imp ');
1296  $totalarray['nbfield']++;
1297 }
1298 if (!empty($arrayfields['p.dateo']['checked'])) {
1299  print_liste_field_titre($arrayfields['p.dateo']['label'], $_SERVER["PHP_SELF"], "p.dateo", "", $param, '', $sortfield, $sortorder, 'center ');
1300  $totalarray['nbfield']++;
1301 }
1302 if (!empty($arrayfields['p.datee']['checked'])) {
1303  print_liste_field_titre($arrayfields['p.datee']['label'], $_SERVER["PHP_SELF"], "p.datee", "", $param, '', $sortfield, $sortorder, 'center ');
1304  $totalarray['nbfield']++;
1305 }
1306 if (!empty($arrayfields['p.public']['checked'])) {
1307  print_liste_field_titre($arrayfields['p.public']['label'], $_SERVER["PHP_SELF"], "p.public", "", $param, "", $sortfield, $sortorder, 'center ');
1308  $totalarray['nbfield']++;
1309 }
1310 if (!empty($arrayfields['c.assigned']['checked'])) {
1311  print_liste_field_titre($arrayfields['c.assigned']['label'], $_SERVER["PHP_SELF"], "", '', $param, '', $sortfield, $sortorder, 'center ', '');
1312  $totalarray['nbfield']++;
1313 }
1314 if (!empty($arrayfields['p.fk_opp_status']['checked'])) {
1315  print_liste_field_titre($arrayfields['p.fk_opp_status']['label'], $_SERVER["PHP_SELF"], 'p.fk_opp_status', "", $param, '', $sortfield, $sortorder, 'center ');
1316  $totalarray['nbfield']++;
1317 }
1318 if (!empty($arrayfields['p.opp_amount']['checked'])) {
1319  print_liste_field_titre($arrayfields['p.opp_amount']['label'], $_SERVER["PHP_SELF"], 'p.opp_amount', "", $param, '', $sortfield, $sortorder, 'right ');
1320  $totalarray['nbfield']++;
1321 }
1322 if (!empty($arrayfields['p.opp_percent']['checked'])) {
1323  print_liste_field_titre($arrayfields['p.opp_percent']['label'], $_SERVER['PHP_SELF'], 'p.opp_percent', "", $param, '', $sortfield, $sortorder, 'right ');
1324  $totalarray['nbfield']++;
1325 }
1326 if (!empty($arrayfields['opp_weighted_amount']['checked'])) {
1327  print_liste_field_titre($arrayfields['opp_weighted_amount']['label'], $_SERVER['PHP_SELF'], 'opp_weighted_amount', '', $param, '', $sortfield, $sortorder, 'right ');
1328  $totalarray['nbfield']++;
1329 }
1330 if (!empty($arrayfields['p.budget_amount']['checked'])) {
1331  print_liste_field_titre($arrayfields['p.budget_amount']['label'], $_SERVER["PHP_SELF"], 'p.budget_amount', "", $param, '', $sortfield, $sortorder, 'right ');
1332  $totalarray['nbfield']++;
1333 }
1334 if (!empty($arrayfields['p.usage_opportunity']['checked'])) {
1335  print_liste_field_titre($arrayfields['p.usage_opportunity']['label'], $_SERVER["PHP_SELF"], 'p.usage_opportunity', "", $param, '', $sortfield, $sortorder, '');
1336  $totalarray['nbfield']++;
1337 }
1338 if (!empty($arrayfields['p.usage_task']['checked'])) {
1339  print_liste_field_titre($arrayfields['p.usage_task']['label'], $_SERVER["PHP_SELF"], 'p.usage_task', "", $param, '', $sortfield, $sortorder, '');
1340  $totalarray['nbfield']++;
1341 }
1342 if (!empty($arrayfields['p.usage_bill_time']['checked'])) {
1343  print_liste_field_titre($arrayfields['p.usage_bill_time']['label'], $_SERVER["PHP_SELF"], 'p.usage_bill_time', "", $param, '', $sortfield, $sortorder, '');
1344  $totalarray['nbfield']++;
1345 }
1346 if (!empty($arrayfields['p.usage_organize_event']['checked'])) {
1347  print_liste_field_titre($arrayfields['p.usage_organize_event']['label'], $_SERVER["PHP_SELF"], 'p.usage_organize_event', "", $param, '', $sortfield, $sortorder, '');
1348  $totalarray['nbfield']++;
1349 }
1350 if (!empty($arrayfields['p.accept_conference_suggestions']['checked'])) {
1351  print_liste_field_titre($arrayfields['p.accept_conference_suggestions']['label'], $_SERVER["PHP_SELF"], 'p.accept_conference_suggestions', "", $param, '', $sortfield, $sortorder, '');
1352  $totalarray['nbfield']++;
1353 }
1354 if (!empty($arrayfields['p.accept_booth_suggestions']['checked'])) {
1355  print_liste_field_titre($arrayfields['p.accept_booth_suggestions']['label'], $_SERVER["PHP_SELF"], 'p.accept_booth_suggestions', "", $param, '', $sortfield, $sortorder, '');
1356  $totalarray['nbfield']++;
1357 }
1358 if (!empty($arrayfields['p.price_registration']['checked'])) {
1359  print_liste_field_titre($arrayfields['p.price_registration']['label'], $_SERVER["PHP_SELF"], 'p.price_registration', "", $param, '', $sortfield, $sortorder, 'right ');
1360  $totalarray['nbfield']++;
1361 }
1362 if (!empty($arrayfields['p.price_booth']['checked'])) {
1363  print_liste_field_titre($arrayfields['p.price_booth']['label'], $_SERVER["PHP_SELF"], 'p.price_booth', "", $param, '', $sortfield, $sortorder, 'right ');
1364  $totalarray['nbfield']++;
1365 }
1366 if (!empty($arrayfields['u.login']['checked'])) {
1367  print_liste_field_titre($arrayfields['u.login']['label'], $_SERVER["PHP_SELF"], 'u.login', '', $param, 'align="center"', $sortfield, $sortorder);
1368  $totalarray['nbfield']++;
1369 }
1370 // Extra fields
1371 include DOL_DOCUMENT_ROOT.'/core/tpl/extrafields_list_search_title.tpl.php';
1372 // Hook fields
1373 $parameters = array('arrayfields'=>$arrayfields, 'param'=>$param, 'sortfield'=>$sortfield, 'sortorder'=>$sortorder, 'totalarray'=>&$totalarray);
1374 $reshook = $hookmanager->executeHooks('printFieldListTitle', $parameters, $object, $action); // Note that $action and $object may have been modified by hook
1375 print $hookmanager->resPrint;
1376 if (!empty($arrayfields['p.datec']['checked'])) {
1377  print_liste_field_titre($arrayfields['p.datec']['label'], $_SERVER["PHP_SELF"], "p.datec", "", $param, '', $sortfield, $sortorder, 'center nowrap ');
1378  $totalarray['nbfield']++;
1379 }
1380 if (!empty($arrayfields['p.tms']['checked'])) {
1381  print_liste_field_titre($arrayfields['p.tms']['label'], $_SERVER["PHP_SELF"], "p.tms", "", $param, '', $sortfield, $sortorder, 'center nowrap ');
1382  $totalarray['nbfield']++;
1383 }
1384 if (!empty($arrayfields['p.email_msgid']['checked'])) {
1385  print_liste_field_titre($arrayfields['p.email_msgid']['label'], $_SERVER["PHP_SELF"], "p.email_msgid", "", $param, '', $sortfield, $sortorder, 'center ');
1386  $totalarray['nbfield']++;
1387 }
1388 if (!empty($arrayfields['p.import_key']['checked'])) {
1389  print_liste_field_titre($arrayfields['p.import_key']['label'], $_SERVER["PHP_SELF"], "p.import_key", "", $param, '', $sortfield, $sortorder, '');
1390  $totalarray['nbfield']++;
1391 }
1392 if (!empty($arrayfields['p.fk_statut']['checked'])) {
1393  print_liste_field_titre($arrayfields['p.fk_statut']['label'], $_SERVER["PHP_SELF"], "p.fk_statut", "", $param, '', $sortfield, $sortorder, 'center ');
1394  $totalarray['nbfield']++;
1395 }
1396 // Action column
1397 if (!getDolGlobalString('MAIN_CHECKBOX_LEFT_COLUMN')) {
1398  print getTitleFieldOfList($selectedfields, 0, $_SERVER["PHP_SELF"], '', '', '', '', $sortfield, $sortorder, 'center maxwidthsearch ')."\n";
1399  $totalarray['nbfield']++;
1400 }
1401 print '</tr>'."\n";
1402 
1403 
1404 $i = 0;
1405 $savnbfield = $totalarray['nbfield'];
1406 $totalarray = array(
1407  'nbfield' => 0,
1408  'val' => array()
1409 );
1410 $imaxinloop = ($limit ? min($num, $limit) : $num);
1411 while ($i < $imaxinloop) {
1412  $obj = $db->fetch_object($resql);
1413  if (empty($obj)) {
1414  break; // Should not happen
1415  }
1416 
1417  $object->id = $obj->id;
1418  $object->ref = $obj->ref;
1419  $object->title = $obj->title;
1420  $object->fk_opp_status = $obj->fk_opp_status;
1421  $object->user_author_id = $obj->fk_user_creat;
1422  $object->date_creation = $db->jdate($obj->date_creation);
1423  $object->date_start = $db->jdate($obj->date_start);
1424  $object->date_end = $db->jdate($obj->date_end);
1425  $object->statut = $obj->status; // deprecated
1426  $object->status = $obj->status;
1427  $object->public = $obj->public;
1428  $object->opp_percent = $obj->opp_percent;
1429  $object->opp_status = $obj->fk_opp_status;
1430  $object->opp_status_code = $obj->opp_status_code;
1431  $object->opp_amount = !empty($obj->opp_amount) ? $obj->opp_amount : "";
1432  $object->opp_weighted_amount = $obj->opp_weighted_amount;
1433  $object->budget_amount = $obj->budget_amount;
1434  $object->usage_opportunity = $obj->usage_opportunity;
1435  $object->usage_task = $obj->usage_task;
1436  $object->usage_bill_time = $obj->usage_bill_time;
1437  $object->usage_organize_event = $obj->usage_organize_event;
1438  $object->email_msgid = $obj->email_msgid;
1439  $object->import_key = $obj->import_key;
1440 
1441 
1442  //$userAccess = $object->restrictedProjectArea($user); // disabled, permission on project must be done by the select
1443 
1444  // Thirdparty
1445  $companystatic->id = $obj->socid;
1446  $companystatic->name = $obj->name;
1447  $companystatic->name_alias = $obj->alias;
1448  $companystatic->client = $obj->client;
1449  $companystatic->code_client = $obj->code_client;
1450  $companystatic->email = $obj->email;
1451  $companystatic->phone = $obj->phone;
1452  $companystatic->address = $obj->address;
1453  $companystatic->zip = $obj->zip;
1454  $companystatic->town = $obj->town;
1455  $companystatic->country_code = $obj->country_code;
1456 
1457  $stringassignedusers = '';
1458 
1459  if (!empty($arrayfields['c.assigned']['checked'])) {
1460  $ifisrt = 1;
1461  foreach (array('internal', 'external') as $source) {
1462  $tab = $object->liste_contact(-1, $source, 0, '', 1);
1463  $numcontact = count($tab);
1464  if (!empty($numcontact)) {
1465  foreach ($tab as $contactproject) {
1466  //var_dump($contacttask);
1467  if ($source == 'internal') {
1468  $c = new User($db);
1469  } else {
1470  $c = new Contact($db);
1471  }
1472  $c->fetch($contactproject['id']);
1473  if (!empty($c->photo)) {
1474  if (get_class($c) == 'User') {
1475  $stringassignedusers .= $c->getNomUrl(-2, '', 0, 0, 24, 1, '', 'valignmiddle'.($ifisrt ? '' : ' notfirst'));
1476  } else {
1477  $stringassignedusers .= $c->getNomUrl(-2, '', 0, '', -1, 0, 'valignmiddle'.($ifisrt ? '' : ' notfirst'));
1478  }
1479  } else {
1480  if (get_class($c) == 'User') {
1481  $stringassignedusers .= $c->getNomUrl(2, '', 0, 0, 24, 1, '', 'valignmiddle'.($ifisrt ? '' : ' notfirst'));
1482  } else {
1483  $stringassignedusers .= $c->getNomUrl(2, '', 0, '', -1, 0, 'valignmiddle'.($ifisrt ? '' : ' notfirst'));
1484  }
1485  }
1486  $ifisrt = 0;
1487  }
1488  }
1489  }
1490  }
1491 
1492  if ($mode == 'kanban') {
1493  if ($i == 0) {
1494  print '<tr class="trkanban"><td colspan="'.$savnbfield.'">';
1495  print '<div class="box-flex-container kanban">';
1496  }
1497 
1498  $selected = in_array($object->id, $arrayofselected);
1499  $arrayofdata = array('assignedusers' => $stringassignedusers, 'selected' => $selected);
1500 
1501  print $object->getKanbanView('', $arrayofdata);
1502 
1503  if ($i == ($imaxinloop - 1)) {
1504  print '</div>';
1505  print '</td></tr>';
1506  }
1507  } else {
1508  // Author
1509  $userstatic->id = $obj->fk_user_creat;
1510  $userstatic->login = $obj->login;
1511  $userstatic->lastname = $obj->lastname;
1512  $userstatic->firstname = $obj->firstname;
1513  $userstatic->email = $obj->user_email;
1514  $userstatic->statut = $obj->user_statut;
1515  $userstatic->entity = $obj->entity;
1516  $userstatic->photo = $obj->photo;
1517  $userstatic->office_phone = $obj->office_phone;
1518  $userstatic->office_fax = $obj->office_fax;
1519  $userstatic->user_mobile = $obj->user_mobile;
1520  $userstatic->job = $obj->job;
1521  $userstatic->gender = $obj->gender;
1522 
1523  // Show here line of result
1524  $j = 0;
1525  print '<tr data-rowid="'.$object->id.'" class="oddeven">';
1526  // Action column
1527  if (getDolGlobalString('MAIN_CHECKBOX_LEFT_COLUMN')) {
1528  print '<td class="nowrap center">';
1529  if ($massactionbutton || $massaction) { // If we are in select mode (massactionbutton defined) or if we have already selected and sent an action ($massaction) defined
1530  $selected = 0;
1531  if (in_array($object->id, $arrayofselected)) {
1532  $selected = 1;
1533  }
1534  print '<input id="cb'.$object->id.'" class="flat checkforselect" type="checkbox" name="toselect[]" value="'.$object->id.'"'.($selected ? ' checked="checked"' : '').'>';
1535  }
1536  print '</td>';
1537  if (!$i) {
1538  $totalarray['nbfield']++;
1539  }
1540  }
1541  // Project url
1542  if (!empty($arrayfields['p.ref']['checked'])) {
1543  print '<td class="nowraponall tdoverflowmax200">';
1544  print $object->getNomUrl(1, (!empty(GETPOST('search_usage_event_organization', 'int'))?'eventorganization':''));
1545  if ($object->hasDelay()) {
1546  print img_warning($langs->trans('Late'));
1547  }
1548  print '</td>';
1549  if (!$i) {
1550  $totalarray['nbfield']++;
1551  }
1552  }
1553  // Title
1554  if (!empty($arrayfields['p.title']['checked'])) {
1555  print '<td class="tdoverflowmax200" title="'.dol_escape_htmltag($obj->title).'">';
1556  print dol_escape_htmltag($obj->title);
1557  print '</td>';
1558  if (!$i) {
1559  $totalarray['nbfield']++;
1560  }
1561  }
1562  // Company
1563  if (!empty($arrayfields['s.nom']['checked'])) {
1564  print '<td class="tdoverflowmax125">';
1565  if ($obj->socid) {
1566  print $companystatic->getNomUrl(1, '', 0, 0, -1, empty($arrayfields['s.name_alias']['checked']) ? 0 : 1);
1567  } else {
1568  print '&nbsp;';
1569  }
1570  print '</td>';
1571  if (!$i) {
1572  $totalarray['nbfield']++;
1573  }
1574  }
1575  // Alias
1576  if (!empty($arrayfields['s.name_alias']['checked'])) {
1577  print '<td class="tdoverflowmax100">';
1578  if ($obj->socid) {
1579  print $companystatic->name_alias;
1580  } else {
1581  print '&nbsp;';
1582  }
1583  print '</td>';
1584  if (!$i) {
1585  $totalarray['nbfield']++;
1586  }
1587  }
1588  // Sales Representatives
1589  if (!empty($arrayfields['commercial']['checked'])) {
1590  print '<td class="tdoverflowmax150">';
1591  if ($obj->socid) {
1592  $companystatic->id = $obj->socid;
1593  $companystatic->name = $obj->name;
1594  $listsalesrepresentatives = $companystatic->getSalesRepresentatives($user);
1595  $nbofsalesrepresentative = count($listsalesrepresentatives);
1596  if ($nbofsalesrepresentative > 6) {
1597  // We print only number
1598  print $nbofsalesrepresentative;
1599  } elseif ($nbofsalesrepresentative > 0) {
1600  $userstatic = new User($db);
1601  $j = 0;
1602  foreach ($listsalesrepresentatives as $val) {
1603  $userstatic->id = $val['id'];
1604  $userstatic->lastname = $val['lastname'];
1605  $userstatic->firstname = $val['firstname'];
1606  $userstatic->email = $val['email'];
1607  $userstatic->statut = $val['statut'];
1608  $userstatic->entity = $val['entity'];
1609  $userstatic->photo = $val['photo'];
1610  $userstatic->login = $val['login'];
1611  $userstatic->office_phone = $val['office_phone'];
1612  $userstatic->office_fax = $val['office_fax'];
1613  $userstatic->user_mobile = $val['user_mobile'];
1614  $userstatic->job = $val['job'];
1615  $userstatic->gender = $val['gender'];
1616  print ($nbofsalesrepresentative < 2) ? $userstatic->getNomUrl(-1, '', 0, 0, 12) : $userstatic->getNomUrl(-2);
1617  $j++;
1618  if ($j < $nbofsalesrepresentative) {
1619  print ' ';
1620  }
1621  }
1622  }
1623  //else print $langs->trans("NoSalesRepresentativeAffected");
1624  } else {
1625  print '&nbsp;';
1626  }
1627  print '</td>';
1628  if (!$i) {
1629  $totalarray['nbfield']++;
1630  }
1631  }
1632 
1633  // Date start project
1634  if (!empty($arrayfields['p.dateo']['checked'])) {
1635  print '<td class="center">';
1636  print dol_print_date($db->jdate($obj->date_start), 'day');
1637  print '</td>';
1638  if (!$i) {
1639  $totalarray['nbfield']++;
1640  }
1641  }
1642  // Date end project
1643  if (!empty($arrayfields['p.datee']['checked'])) {
1644  print '<td class="center">';
1645  print dol_print_date($db->jdate($obj->date_end), 'day');
1646  print '</td>';
1647  if (!$i) {
1648  $totalarray['nbfield']++;
1649  }
1650  }
1651 
1652  // Visibility
1653  if (!empty($arrayfields['p.public']['checked'])) {
1654  print '<td class="center">';
1655  if ($obj->public) {
1656  print img_picto($langs->trans('SharedProject'), 'world', 'class="paddingrightonly"');
1657  //print $langs->trans('SharedProject');
1658  } else {
1659  print img_picto($langs->trans('PrivateProject'), 'private', 'class="paddingrightonly"');
1660  //print $langs->trans('PrivateProject');
1661  }
1662  print '</td>';
1663  if (!$i) {
1664  $totalarray['nbfield']++;
1665  }
1666  }
1667  // Assigned contacts of project
1668  if (!empty($arrayfields['c.assigned']['checked'])) {
1669  print '<td class="center nowraponall tdoverflowmax200">';
1670  print $stringassignedusers;
1671  print '</td>';
1672  if (!$i) {
1673  $totalarray['nbfield']++;
1674  }
1675  }
1676  // Opp Status
1677  if (!empty($arrayfields['p.fk_opp_status']['checked'])) {
1678  print '<td class="center">';
1679  if ($obj->opp_status_code) {
1680  print $langs->trans("OppStatus".$obj->opp_status_code);
1681  }
1682  print '</td>';
1683  if (!$i) {
1684  $totalarray['nbfield']++;
1685  }
1686  }
1687  // Opp Amount
1688  if (!empty($arrayfields['p.opp_amount']['checked'])) {
1689  print '<td class="right">';
1690  //if ($obj->opp_status_code)
1691  if (strcmp($obj->opp_amount, '')) {
1692  print '<span class="amount">'.price($obj->opp_amount, 1, $langs, 1, -1, -1, '').'</span>';
1693  if (!isset($totalarray['val']['p.opp_amount'])) {
1694  $totalarray['val']['p.opp_amount'] = $obj->opp_amount;
1695  } else {
1696  $totalarray['val']['p.opp_amount'] += $obj->opp_amount;
1697  }
1698  }
1699  print '</td>';
1700  if (!$i) {
1701  $totalarray['nbfield']++;
1702  }
1703  if (!$i) {
1704  $totalarray['pos'][$totalarray['nbfield']] = 'p.opp_amount';
1705  }
1706  }
1707  // Opp percent
1708  if (!empty($arrayfields['p.opp_percent']['checked'])) {
1709  print '<td class="right">';
1710  if ($obj->opp_percent) {
1711  print price($obj->opp_percent, 1, $langs, 1, 0).'%';
1712  }
1713  print '</td>';
1714  if (!$i) {
1715  $totalarray['nbfield']++;
1716  }
1717  }
1718  // Opp weighted amount
1719  if (!empty($arrayfields['opp_weighted_amount']['checked'])) {
1720  if (!isset($totalarray['val']['opp_weighted_amount'])) {
1721  $totalarray['val']['opp_weighted_amount'] = 0;
1722  }
1723  print '<td align="right">';
1724  if ($obj->opp_weighted_amount) {
1725  print '<span class="amount">'.price($obj->opp_weighted_amount, 1, $langs, 1, -1, -1, '').'</span>';
1726  $totalarray['val']['opp_weighted_amount'] += $obj->opp_weighted_amount;
1727  }
1728  print '</td>';
1729  if (!$i) {
1730  $totalarray['nbfield']++;
1731  }
1732  if (!$i) {
1733  $totalarray['pos'][$totalarray['nbfield']] = 'opp_weighted_amount';
1734  }
1735  }
1736  // Budget
1737  if (!empty($arrayfields['p.budget_amount']['checked'])) {
1738  print '<td class="right">';
1739  if ($obj->budget_amount != '') {
1740  print '<span class="amount">'.price($obj->budget_amount, 1, $langs, 1, -1, -1).'</span>';
1741  if (!isset($totalarray['val']['p.budget_amount'])) {
1742  $totalarray['val']['p.budget_amount'] = $obj->budget_amount;
1743  } else {
1744  $totalarray['val']['p.budget_amount'] += $obj->budget_amount;
1745  }
1746  }
1747  print '</td>';
1748  if (!$i) {
1749  $totalarray['nbfield']++;
1750  }
1751  if (!$i) {
1752  $totalarray['pos'][$totalarray['nbfield']] = 'p.budget_amount';
1753  }
1754  }
1755  // Usage opportunity
1756  if (!empty($arrayfields['p.usage_opportunity']['checked'])) {
1757  print '<td class="">';
1758  if ($obj->usage_opportunity) {
1759  print yn($obj->usage_opportunity);
1760  }
1761  print '</td>';
1762  if (!$i) {
1763  $totalarray['nbfield']++;
1764  }
1765  }
1766  // Usage task
1767  if (!empty($arrayfields['p.usage_task']['checked'])) {
1768  print '<td class="">';
1769  if ($obj->usage_task) {
1770  print yn($obj->usage_task);
1771  }
1772  print '</td>';
1773  if (!$i) {
1774  $totalarray['nbfield']++;
1775  }
1776  }
1777  // Bill time
1778  if (!empty($arrayfields['p.usage_bill_time']['checked'])) {
1779  print '<td class="">';
1780  if ($obj->usage_bill_time) {
1781  print yn($obj->usage_bill_time);
1782  }
1783  print '</td>';
1784  if (!$i) {
1785  $totalarray['nbfield']++;
1786  }
1787  }
1788  // Event Organization
1789  if (!empty($arrayfields['p.usage_organize_event']['checked'])) {
1790  print '<td class="">';
1791  if ($obj->usage_organize_event) {
1792  print yn($obj->usage_organize_event);
1793  }
1794  print '</td>';
1795  if (!$i) {
1796  $totalarray['nbfield']++;
1797  }
1798  }
1799  // Allow unknown people to suggest conferences
1800  if (!empty($arrayfields['p.accept_conference_suggestions']['checked'])) {
1801  print '<td class="">';
1802  if ($obj->accept_conference_suggestions) {
1803  print yn($obj->accept_conference_suggestions);
1804  }
1805  print '</td>';
1806  if (!$i) {
1807  $totalarray['nbfield']++;
1808  }
1809  }
1810  // Allow unknown people to suggest booth
1811  if (!empty($arrayfields['p.accept_booth_suggestions']['checked'])) {
1812  print '<td class="">';
1813  if ($obj->accept_booth_suggestions) {
1814  print yn($obj->accept_booth_suggestions);
1815  }
1816  print '</td>';
1817  if (!$i) {
1818  $totalarray['nbfield']++;
1819  }
1820  }
1821  // Price of registration
1822  if (!empty($arrayfields['p.price_registration']['checked'])) {
1823  print '<td class="right">';
1824  if ($obj->price_registration != '') {
1825  print '<span class="amount">'.price($obj->price_registration, 1, $langs, 1, -1, -1).'</span>';
1826  $totalarray['val']['p.price_registration'] += $obj->price_registration;
1827  }
1828  print '</td>';
1829  if (!$i) {
1830  $totalarray['nbfield']++;
1831  }
1832  if (!$i) {
1833  $totalarray['pos'][$totalarray['nbfield']] = 'p.price_registration';
1834  }
1835  }
1836  // Price of booth
1837  if (!empty($arrayfields['p.price_booth']['checked'])) {
1838  print '<td class="right">';
1839  if ($obj->price_booth != '') {
1840  print '<span class="amount">'.price($obj->price_booth, 1, $langs, 1, -1, -1).'</span>';
1841  $totalarray['val']['p.price_booth'] += $obj->price_booth;
1842  }
1843  print '</td>';
1844  if (!$i) {
1845  $totalarray['nbfield']++;
1846  }
1847  if (!$i) {
1848  $totalarray['pos'][$totalarray['nbfield']] = 'p.price_booth';
1849  }
1850  }
1851  // Author
1852  if (!empty($arrayfields['u.login']['checked'])) {
1853  print '<td class="center tdoverflowmax150">';
1854  if ($userstatic->id) {
1855  print $userstatic->getNomUrl(-1);
1856  } else {
1857  print '&nbsp;';
1858  }
1859  print "</td>\n";
1860  if (!$i) {
1861  $totalarray['nbfield']++;
1862  }
1863  }
1864  // Extra fields
1865  include DOL_DOCUMENT_ROOT.'/core/tpl/extrafields_list_print_fields.tpl.php';
1866  // Fields from hook
1867  $parameters = array('arrayfields'=>$arrayfields, 'object'=>$object, 'obj'=>$obj, 'i'=>$i, 'totalarray'=>&$totalarray);
1868  $reshook = $hookmanager->executeHooks('printFieldListValue', $parameters, $object, $action); // Note that $action and $object may have been modified by hook
1869  print $hookmanager->resPrint;
1870  // Date creation
1871  if (!empty($arrayfields['p.datec']['checked'])) {
1872  print '<td class="center nowraponall">';
1873  print dol_print_date($db->jdate($obj->date_creation), 'dayhour', 'tzuser');
1874  print '</td>';
1875  if (!$i) {
1876  $totalarray['nbfield']++;
1877  }
1878  }
1879  // Date modification
1880  if (!empty($arrayfields['p.tms']['checked'])) {
1881  print '<td class="center nowraponall">';
1882  print dol_print_date($db->jdate($obj->date_update), 'dayhour', 'tzuser');
1883  print '</td>';
1884  if (!$i) {
1885  $totalarray['nbfield']++;
1886  }
1887  }
1888  // Email MsgID
1889  if (!empty($arrayfields['p.email_msgid']['checked'])) {
1890  print '<td class="tdoverflowmax125" title="'.dol_escape_htmltag($obj->email_msgid).'">';
1891  print dol_escape_htmltag($obj->email_msgid);
1892  print '</td>';
1893  if (!$i) {
1894  $totalarray['nbfield']++;
1895  }
1896  }
1897  // Import key
1898  if (!empty($arrayfields['p.import_key']['checked'])) {
1899  print '<td class="right">'.dol_escape_htmltag($obj->import_key).'</td>';
1900  if (!$i) {
1901  $totalarray['nbfield']++;
1902  }
1903  }
1904  // Status
1905  if (!empty($arrayfields['p.fk_statut']['checked'])) {
1906  print '<td class="center">'.$object->getLibStatut(5).'</td>';
1907  if (!$i) {
1908  $totalarray['nbfield']++;
1909  }
1910  }
1911  // Action column
1912  if (!getDolGlobalString('MAIN_CHECKBOX_LEFT_COLUMN')) {
1913  print '<td class="nowrap center">';
1914  if ($massactionbutton || $massaction) { // If we are in select mode (massactionbutton defined) or if we have already selected and sent an action ($massaction) defined
1915  $selected = 0;
1916  if (in_array($object->id, $arrayofselected)) {
1917  $selected = 1;
1918  }
1919  print '<input id="cb'.$object->id.'" class="flat checkforselect" type="checkbox" name="toselect[]" value="'.$object->id.'"'.($selected ? ' checked="checked"' : '').'>';
1920  }
1921  print '</td>';
1922  if (!$i) {
1923  $totalarray['nbfield']++;
1924  }
1925  }
1926 
1927  print '</tr>'."\n";
1928  }
1929  //}
1930 
1931  $i++;
1932 }
1933 
1934 // Show total line
1935 include DOL_DOCUMENT_ROOT.'/core/tpl/list_print_total.tpl.php';
1936 
1937 // If no record found
1938 if ($num == 0) {
1939  $colspan = 1;
1940  foreach ($arrayfields as $key => $val) {
1941  if (!empty($val['checked'])) {
1942  $colspan++;
1943  }
1944  }
1945  print '<tr><td colspan="'.$colspan.'"><span class="opacitymedium">'.$langs->trans("NoRecordFound").'</span></td></tr>';
1946 }
1947 
1948 $db->free($resql);
1949 
1950 $parameters = array('arrayfields'=>$arrayfields, 'sql' => $sql);
1951 $reshook = $hookmanager->executeHooks('printFieldListFooter', $parameters, $object, $action); // Note that $action and $object may have been modified by hook
1952 print $hookmanager->resPrint;
1953 
1954 print '</table>'."\n";
1955 print '</div>'."\n";
1956 
1957 print '</form>'."\n";
1958 
1959 // End of page
1960 llxFooter();
1961 $db->close();
if(GETPOST('button_removefilter_x', 'alpha')||GETPOST('button_removefilter.x', 'alpha')||GETPOST('button_removefilter', 'alpha')) if(GETPOST('button_search_x', 'alpha')||GETPOST('button_search.x', 'alpha')||GETPOST('button_search', 'alpha')) if($action=="save" &&empty($cancel)) $help_url
View.
Definition: agenda.php:118
if(!defined('NOREQUIRESOC')) if(!defined('NOREQUIRETRAN')) if(!defined('NOTOKENRENEWAL')) if(!defined('NOREQUIREMENU')) if(!defined('NOREQUIREHTML')) if(!defined('NOREQUIREAJAX')) llxHeader()
Empty header.
Definition: wrapper.php:56
llxFooter()
Empty footer.
Definition: wrapper.php:70
Class to manage contact/addresses.
Class to manage standard extra fields.
Class to manage forms for categories.
Class to build HTML component for third parties management Only common components are here.
Class to manage generation of HTML components Only common components must be here.
static multiselectarray($htmlname, $array, $selected=array(), $key_in_label=0, $value_as_key=0, $morecss='', $translate=0, $width=0, $moreattrib='', $elemtype='', $placeholder='', $addjscombo=-1)
Show a multiselect form from an array.
Classe permettant la generation de composants html autre Only common components are here.
Class to manage building of HTML components.
Class to manage projects.
Class to manage third parties objects (customers, suppliers, prospects...)
Class to manage tasks.
Definition: task.class.php:40
Class to manage Dolibarr users.
Definition: user.class.php:48
if(isModEnabled('facture') && $user->hasRight('facture', 'lire')) if((isModEnabled('fournisseur') &&empty($conf->global->MAIN_USE_NEW_SUPPLIERMOD) && $user->hasRight("fournisseur", "facture", "lire"))||(isModEnabled('supplier_invoice') && $user->hasRight("supplier_invoice", "lire"))) if(isModEnabled('don') && $user->hasRight('don', 'lire')) if(isModEnabled('tax') &&!empty($user->rights->tax->charges->lire)) if(isModEnabled('facture') &&isModEnabled('commande') && $user->hasRight("commande", "lire") &&empty($conf->global->WORKFLOW_DISABLE_CREATE_INVOICE_FROM_ORDER)) $sql
Social contributions to pay.
Definition: index.php:746
if($cancel &&! $id) if($action=='add' &&! $cancel) if($action=='delete') if($id) $form
Actions.
Definition: card.php:143
dolSqlDateFilter($datefield, $day_date, $month_date, $year_date, $excludefirstand=0, $gm=false)
Generate a SQL string to make a filter into a range (for second of date until last second of date).
Definition: date.lib.php:360
dol_mktime($hour, $minute, $second, $month, $day, $year, $gm='auto', $check=1)
Return a timestamp date built from detailed informations (by default a local PHP server timestamp) Re...
img_warning($titlealt='default', $moreatt='', $morecss='pictowarning')
Show warning logo.
yn($yesno, $case=1, $color=0)
Return yes or no in current language.
dol_print_error($db='', $error='', $errors=null)
Displays error message system with all the information to facilitate the diagnosis and the escalation...
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...
price($amount, $form=0, $outlangs='', $trunc=1, $rounding=-1, $forcerounding=-1, $currency_code='')
Function to format a value into an amount for visual output Function used into PDF and HTML pages.
dol_print_date($time, $format='', $tzoutput='auto', $outputlangs='', $encodetooutput=false)
Output date in a string format according to outputlangs (or langs if not defined).
dol_now($mode='auto')
Return date for now.
getDolGlobalInt($key, $default=0)
Return dolibarr global constant int value.
img_picto($titlealt, $picto, $moreatt='', $pictoisfullpath=false, $srconly=0, $notitle=0, $alt='', $morecss='', $marginleftonlyshort=2)
Show picto whatever it's its name (generic function)
dol_sort_array(&$array, $index, $order='asc', $natsort=0, $case_sensitive=0, $keepindex=0)
Advanced sort array by second index function, which produces ascending (default) or descending output...
dol_eval($s, $returnvalue=0, $hideerrors=1, $onlysimplestring='1')
Replace eval function to add more security.
print_liste_field_titre($name, $file="", $field="", $begin="", $moreparam="", $moreattrib="", $sortfield="", $sortorder="", $prefix="", $tooltip="", $forcenowrapcolumntitle=0)
Show title line of an array.
getTitleFieldOfList($name, $thead=0, $file="", $field="", $begin="", $moreparam="", $moreattrib="", $sortfield="", $sortorder="", $prefix="", $disablesortlink=0, $tooltip='', $forcenowrapcolumntitle=0)
Get title line of an array.
GETPOST($paramname, $check='alphanohtml', $method=0, $filter=null, $options=null, $noreplace=0)
Return value of a param into GET or POST supervariable.
setEventMessages($mesg, $mesgs, $style='mesgs', $messagekey='', $noduplicate=0)
Set event messages in dol_events session object.
print_barre_liste($titre, $page, $file, $options='', $sortfield='', $sortorder='', $morehtmlcenter='', $num=-1, $totalnboflines='', $picto='generic', $pictoisfullpath=0, $morehtmlright='', $morecss='', $limit=-1, $hideselectlimit=0, $hidenavigation=0, $pagenavastextinput=0, $morehtmlrightbeforearrow='')
Print a title with navigation controls for pagination.
GETPOSTISSET($paramname)
Return true if we are in a context of submitting the parameter $paramname from a POST of a form.
getDolGlobalString($key, $default='')
Return dolibarr global constant string value.
isModEnabled($module)
Is Dolibarr module enabled.
dol_escape_htmltag($stringtoescape, $keepb=0, $keepn=0, $noescapetags='', $escapeonlyhtmltags=0, $cleanalsojavascript=0)
Returns text escaped for inclusion in HTML alt or title or value tags, or into values of HTML input f...
accessforbidden($message='', $printheader=1, $printfooter=1, $showonlymessage=0, $params=null)
Show a message to say access is forbidden and stop program.