29 require
'../main.inc.php';
30 require_once DOL_DOCUMENT_ROOT.
'/core/class/html.formother.class.php';
32 require_once DOL_DOCUMENT_ROOT.
'/categories/class/categorie.class.php';
36 $langs->loadLangs(array(
'users',
'companies',
'hrm',
'salaries'));
38 $action =
GETPOST(
'action',
'aZ09') ?
GETPOST(
'action',
'aZ09') :
'view';
39 $massaction =
GETPOST(
'massaction',
'alpha');
40 $show_files =
GETPOST(
'show_files',
'int');
41 $confirm =
GETPOST(
'confirm',
'alpha');
42 $cancel =
GETPOST(
'cancel',
'alpha');
43 $toselect =
GETPOST(
'toselect',
'array');
44 $contextpage =
GETPOST(
'contextpage',
'aZ') ?
GETPOST(
'contextpage',
'aZ') :
'userlist';
45 $backtopage =
GETPOST(
'backtopage',
'alpha');
46 $optioncss =
GETPOST(
'optioncss',
'aZ');
51 if ($user->socid > 0) {
52 $socid = $user->socid;
56 $limit =
GETPOST(
'limit',
'int') ?
GETPOST(
'limit',
'int') : $conf->liste_limit;
57 $sortfield =
GETPOST(
'sortfield',
'aZ09comma');
58 $sortorder =
GETPOST(
'sortorder',
'aZ09comma');
60 if (empty($page) || $page < 0 ||
GETPOST(
'button_search',
'alpha') ||
GETPOST(
'button_removefilter',
'alpha')) {
64 $offset = $limit * $page;
65 $pageprev = $page - 1;
66 $pagenext = $page + 1;
69 $object =
new User($db);
71 $diroutputmassaction = $conf->user->dir_output.
'/temp/massgeneration/'.$user->id;
72 $hookmanager->initHooks(array(
'userlist'));
75 $extrafields->fetch_name_optionals_label($object->table_element);
77 $search_array_options = $extrafields->getOptionalsFromPost($object->table_element,
'',
'search_');
80 $sortfield =
"u.login";
87 $search_all =
GETPOST(
'search_all',
'alphanohtml');
89 foreach ($object->fields as $key => $val) {
90 if (
GETPOST(
'search_'.$key,
'alpha') !==
'') {
91 $search[$key] =
GETPOST(
'search_'.$key,
'alpha');
93 if (preg_match(
'/^(date|timestamp|datetime)/', $val[
'type'])) {
94 $search[$key.
'_dtstart'] =
dol_mktime(0, 0, 0,
GETPOST(
'search_'.$key.
'_dtstartmonth',
'int'),
GETPOST(
'search_'.$key.
'_dtstartday',
'int'),
GETPOST(
'search_'.$key.
'_dtstartyear',
'int'));
95 $search[$key.
'_dtend'] =
dol_mktime(23, 59, 59,
GETPOST(
'search_'.$key.
'_dtendmonth',
'int'),
GETPOST(
'search_'.$key.
'_dtendday',
'int'),
GETPOST(
'search_'.$key.
'_dtendyear',
'int'));
99 $userstatic =
new User($db);
100 $companystatic =
new Societe($db);
104 $fieldstosearchall = array(
106 'u.lastname'=>
"Lastname",
107 'u.firstname'=>
"Firstname",
108 'u.accountancy_code'=>
"AccountancyCode",
109 'u.office_phone'=>
"PhonePro",
110 'u.user_mobile'=>
"PhoneMobile",
112 'u.note_public'=>
"NotePublic",
113 'u.note_private'=>
"NotePrivate"
116 $fieldstosearchall[
'u.api_key'] =
"ApiKey";
119 $permissiontoreadhr = $user->hasRight(
'hrm',
'read_personal_information',
'read') || $user->hasRight(
'hrm',
'write_personal_information',
'write');
120 $permissiontowritehr = $user->hasRight(
'hrm',
'write_personal_information',
'write');
123 $arrayfields = array(
124 'u.login'=>array(
'label'=>
"Login",
'checked'=>1,
'position'=>10),
125 'u.lastname'=>array(
'label'=>
"Lastname",
'checked'=>1,
'position'=>15),
126 'u.firstname'=>array(
'label'=>
"Firstname",
'checked'=>1,
'position'=>20),
127 'u.entity'=>array(
'label'=>
"Entity",
'checked'=>1,
'position'=>50,
'enabled'=>(
isModEnabled(
'multicompany') && empty($conf->global->MULTICOMPANY_TRANSVERSE_MODE))),
128 'u.gender'=>array(
'label'=>
"Gender",
'checked'=>0,
'position'=>22),
129 'u.employee'=>array(
'label'=>
"Employee",
'checked'=>($contextpage ==
'employeelist' ? 1 : 0),
'position'=>25),
130 'u.fk_user'=>array(
'label'=>
"HierarchicalResponsible",
'checked'=>1,
'position'=>27,
'csslist'=>
'maxwidth150'),
131 'u.accountancy_code'=>array(
'label'=>
"AccountancyCode",
'checked'=>0,
'position'=>30),
132 'u.office_phone'=>array(
'label'=>
"PhonePro",
'checked'=>1,
'position'=>31),
133 'u.user_mobile'=>array(
'label'=>
"PhoneMobile",
'checked'=>1,
'position'=>32),
134 'u.email'=>array(
'label'=>
"EMail",
'checked'=>1,
'position'=>35),
135 'u.api_key'=>array(
'label'=>
"ApiKey",
'checked'=>0,
'position'=>40,
"enabled"=>(
isModEnabled(
'api') && $user->admin)),
136 'u.fk_soc'=>array(
'label'=>
"Company",
'checked'=>($contextpage ==
'employeelist' ? 0 : 1),
'position'=>45),
137 'u.ref_employee'=>array(
'label'=>
"RefEmployee",
'checked'=>-1,
'position'=>60,
'enabled'=>(
isModEnabled(
'hrm') && $permissiontoreadhr)),
138 'u.national_registration_number'=>array(
'label'=>
"NationalRegistrationNumber",
'checked'=>-1,
'position'=>61,
'enabled'=>(
isModEnabled(
'hrm') && $permissiontoreadhr)),
139 'u.job'=>array(
'label'=>
"PostOrFunction",
'checked'=>-1,
'position'=>50),
140 'u.salary'=>array(
'label'=>
"Salary",
'checked'=>-1,
'position'=>80,
'enabled'=>(
isModEnabled(
'salaries') && $user->hasRight(
"salaries",
"readall")),
'isameasure'=>1),
141 'u.datelastlogin'=>array(
'label'=>
"LastConnexion",
'checked'=>1,
'position'=>100),
142 'u.datepreviouslogin'=>array(
'label'=>
"PreviousConnexion",
'checked'=>0,
'position'=>110),
143 'u.datec'=>array(
'label'=>
"DateCreation",
'checked'=>0,
'position'=>500),
144 'u.tms'=>array(
'label'=>
"DateModificationShort",
'checked'=>0,
'position'=>500),
145 'u.statut'=>array(
'label'=>
"Status",
'checked'=>1,
'position'=>1000),
148 include DOL_DOCUMENT_ROOT .
'/core/tpl/extrafields_list_array_fields.tpl.php';
154 $search_all = trim((
GETPOST(
'search_all',
'alphanohtml') !=
'') ?
GETPOST(
'search_all',
'alphanohtml') :
GETPOST(
'sall',
'alphanohtml'));
155 $search_user =
GETPOST(
'search_user',
'alpha');
156 $search_login =
GETPOST(
'search_login',
'alpha');
157 $search_lastname =
GETPOST(
'search_lastname',
'alpha');
158 $search_firstname =
GETPOST(
'search_firstname',
'alpha');
159 $search_gender =
GETPOST(
'search_gender',
'alpha');
160 $search_employee =
GETPOST(
'search_employee',
'alpha');
161 $search_accountancy_code =
GETPOST(
'search_accountancy_code',
'alpha');
162 $search_phonepro =
GETPOST(
'search_phonepro',
'alpha');
163 $search_phonemobile =
GETPOST(
'search_phonemobile',
'alpha');
164 $search_email =
GETPOST(
'search_email',
'alpha');
165 $search_api_key =
GETPOST(
'search_api_key',
'alphanohtml');
166 $search_statut =
GETPOST(
'search_statut',
'intcomma');
167 $search_thirdparty =
GETPOST(
'search_thirdparty',
'alpha');
168 $search_job =
GETPOST(
'search_job',
'alpha');
169 $search_warehouse =
GETPOST(
'search_warehouse',
'alpha');
170 $search_supervisor =
GETPOST(
'search_supervisor',
'intcomma');
171 $search_categ =
GETPOST(
"search_categ",
'int');
172 $searchCategoryUserOperator = 0;
174 $searchCategoryUserOperator =
GETPOSTINT(
'search_category_user_operator');
175 } elseif (!empty($conf->global->MAIN_SEARCH_CAT_OR_BY_DEFAULT)) {
176 $searchCategoryUserOperator = $conf->global->MAIN_SEARCH_CAT_OR_BY_DEFAULT;
178 $searchCategoryUserList =
GETPOST(
'search_category_user_list',
'array');
179 $catid =
GETPOST(
'catid',
'int');
180 if (!empty($catid) && empty($searchCategoryUserList)) {
181 $searchCategoryUserList = array($catid);
183 $catid =
GETPOST(
'catid',
'int');
184 if (!empty($catid) && empty($search_categ)) {
185 $search_categ = $catid;
189 if ($search_statut ==
'') {
190 $search_statut =
'1';
192 if ($contextpage ==
'employeelist' && !
GETPOSTISSET(
'search_employee')) {
193 $search_employee = 1;
197 $permissiontoadd = (!empty($user->admin) || $user->hasRight(
"user",
"user",
"write"));
198 $canreaduser = (!empty($user->admin) || $user->hasRight(
"user",
"user",
"read"));
199 $canedituser = (!empty($user->admin) || $user->hasRight(
"user",
"user",
"write"));
200 $candisableuser = (!empty($user->admin) || $user->hasRight(
"user",
"user",
"delete"));
201 $canreadgroup = $canreaduser;
202 $caneditgroup = $canedituser;
203 if (!empty($conf->global->MAIN_USE_ADVANCED_PERMS)) {
204 $canreadgroup = (!empty($user->admin) || $user->hasRight(
"user",
"group_advance",
"read"));
205 $caneditgroup = (!empty($user->admin) || $user->hasRight(
"user",
"group_advance",
"write"));
211 if (
isModEnabled(
'salaries') && $contextpage ==
'employeelist' && $search_employee == 1) {
212 if (!$user->hasRight(
"salaries",
"read")) {
216 if (!$user->hasRight(
"user",
"user",
"read") && empty($user->admin)) {
221 $childids = $user->getAllChildIds(1);
228 if (
GETPOST(
'cancel',
'alpha')) {
232 if (!
GETPOST(
'confirmmassaction',
'alpha') && $massaction !=
'presend' && $massaction !=
'confirm_presend') {
236 $parameters = array();
237 $reshook = $hookmanager->executeHooks(
'doActions', $parameters, $object, $action);
242 if (empty($reshook)) {
244 include DOL_DOCUMENT_ROOT.
'/core/actions_changeselectedfields.inc.php';
247 if (
GETPOST(
'button_removefilter_x',
'alpha') ||
GETPOST(
'button_removefilter.x',
'alpha') ||
GETPOST(
'button_removefilter',
'alpha')) {
250 $search_lastname =
"";
251 $search_firstname =
"";
253 $search_employee =
"";
254 $search_accountancy_code =
"";
255 $search_phonepro =
"";
256 $search_phonemobile =
"";
259 $search_thirdparty =
"";
261 $search_warehouse =
"";
262 $search_supervisor =
"";
263 $search_api_key =
"";
264 $search_datelastlogin =
"";
265 $search_datepreviouslogin =
"";
266 $search_date_creation =
"";
267 $search_date_update =
"";
270 $search_array_options = array();
272 if (
GETPOST(
'button_removefilter_x',
'alpha') ||
GETPOST(
'button_removefilter.x',
'alpha') ||
GETPOST(
'button_removefilter',
'alpha')
273 ||
GETPOST(
'button_search_x',
'alpha') ||
GETPOST(
'button_search.x',
'alpha') ||
GETPOST(
'button_search',
'alpha')) {
278 $objectclass =
'User';
279 $objectlabel =
'User';
280 $uploaddir = $conf->user->dir_output;
281 include DOL_DOCUMENT_ROOT.
'/core/actions_massactions.inc.php';
284 if (!$error && ($massaction ==
'disable' || $massaction ==
'reactivate') && $permissiontoadd) {
285 $objecttmp =
new User($db);
291 foreach ($toselect as $toselectid) {
292 if ($toselectid == $user->id) {
293 setEventMessages($langs->trans($massaction == 0 ?
'CantDisableYourself' :
'CanEnableYourself'),
null,
'errors');
298 $result = $objecttmp->fetch($toselectid);
300 if ($objecttmp->admin) {
301 setEventMessages($langs->trans($massaction == 0 ?
'CantDisableAnAdminUserWithMassActions' :
'CantEnableAnAdminUserWithMassActions', $objecttmp->login),
null,
'errors');
306 $result = $objecttmp->setstatus($massaction ==
'disable' ? 0 : 1);
309 } elseif ($result < 0) {
323 if (!$error && !empty($conf->file->main_limit_users)) {
324 $nb = $object->getNbOfUsers(
"active");
325 if ($nb >= $conf->file->main_limit_users) {
327 setEventMessages($langs->trans(
"YourQuotaOfUsersIsReached"),
null,
'errors');
351 $user2 =
new User($db);
355 $help_url =
'EN:Module_Users|FR:Module_Utilisateurs|ES:Módulo_Usuarios|DE:Modul_Benutzer';
356 if ($contextpage ==
'employeelist' && $search_employee == 1) {
357 $title = $langs->trans(
"Employees");
359 $title = $langs->trans(
"Users");
367 $sql =
"SELECT DISTINCT u.rowid, u.lastname, u.firstname, u.admin, u.fk_soc, u.login, u.office_phone, u.user_mobile, u.email, u.api_key, u.accountancy_code, u.gender, u.employee, u.photo,";
368 $sql .=
" u.fk_user,";
369 $sql .=
" u.ref_employee, u.national_registration_number, u.job, u.salary, u.datelastlogin, u.datepreviouslogin,";
370 $sql .=
" u.ldap_sid, u.statut as status, u.entity,";
371 $sql .=
" u.tms as date_update, u.datec as date_creation,";
372 $sql .=
" u2.rowid as id2, u2.login as login2, u2.firstname as firstname2, u2.lastname as lastname2, u2.admin as admin2, u2.fk_soc as fk_soc2, u2.office_phone as ofice_phone2, u2.user_mobile as user_mobile2, u2.email as email2, u2.gender as gender2, u2.photo as photo2, u2.entity as entity2, u2.statut as status2,";
373 $sql .=
" s.nom as name, s.canvas";
375 if (!empty($extrafields->attributes[$object->table_element][
'label'])) {
376 foreach ($extrafields->attributes[$object->table_element][
'label'] as $key => $val) {
377 $sql .= ($extrafields->attributes[$object->table_element][
'type'][$key] !=
'separate' ?
", ef.".$key.
" as options_".$key :
'');
381 $parameters = array();
382 $reshook = $hookmanager->executeHooks(
'printFieldListSelect', $parameters, $object);
383 $sql .= $hookmanager->resPrint;
384 $sql = preg_replace(
'/,\s*$/',
'',
$sql);
388 $sql .=
" FROM ".MAIN_DB_PREFIX.$object->table_element.
" as u";
389 if (isset($extrafields->attributes[$object->table_element][
'label']) && is_array($extrafields->attributes[$object->table_element][
'label']) && count($extrafields->attributes[$object->table_element][
'label'])) {
390 $sql .=
" LEFT JOIN ".MAIN_DB_PREFIX.$object->table_element.
"_extrafields as ef on (u.rowid = ef.fk_object)";
392 $sql .=
" LEFT JOIN ".MAIN_DB_PREFIX.
"societe as s ON u.fk_soc = s.rowid";
393 $sql .=
" LEFT JOIN ".MAIN_DB_PREFIX.
"user as u2 ON u.fk_user = u2.rowid";
395 $parameters = array();
396 $reshook = $hookmanager->executeHooks(
'printFieldListFrom', $parameters, $object);
397 $sql .= $hookmanager->resPrint;
399 $sql .= $hookmanager->resPrint;
401 $sql .=
" WHERE u.entity IN (".getEntity($object->element).
")";
403 $sql .=
" AND u.fk_soc = ".((int) $socid);
406 if ($search_supervisor > 0) {
407 $sql .=
" AND u.fk_user IN (".$db->sanitize($search_supervisor).
")";
409 if ($search_thirdparty !=
'') {
412 if ($search_warehouse > 0) {
415 if ($search_login !=
'') {
418 if ($search_lastname !=
'') {
421 if ($search_firstname !=
'') {
424 if ($search_gender !=
'' && $search_gender !=
'-1') {
425 $sql .=
" AND u.gender = '".$db->escape($search_gender).
"'";
427 if (is_numeric($search_employee) && $search_employee >= 0) {
428 $sql .=
' AND u.employee = '.(int) $search_employee;
430 if ($search_accountancy_code !=
'') {
433 if ($search_phonepro !=
'') {
436 if ($search_phonemobile !=
'') {
439 if ($search_email !=
'') {
442 if ($search_api_key !=
'') {
445 if ($search_job !=
'') {
448 if ($search_statut !=
'' && $search_statut >= 0) {
449 $sql .=
" AND u.statut IN (".$db->sanitize($search_statut).
")";
455 $searchCategoryUserList = array($search_categ);
456 if (!empty($searchCategoryUserList)) {
457 $searchCategoryUserSqlList = array();
458 $listofcategoryid =
'';
459 foreach ($searchCategoryUserList as $searchCategoryUser) {
460 if (intval($searchCategoryUser) == -2) {
461 $searchCategoryUserSqlList[] =
"NOT EXISTS (SELECT ck.fk_user FROM ".MAIN_DB_PREFIX.
"categorie_user as ck WHERE u.rowid = ck.fk_user)";
462 } elseif (intval($searchCategoryUser) > 0) {
463 if ($searchCategoryUserOperator == 0) {
464 $searchCategoryUserSqlList[] =
" EXISTS (SELECT ck.fk_user FROM ".MAIN_DB_PREFIX.
"categorie_user as ck WHERE u.rowid = ck.fk_user AND ck.fk_categorie = ".((int) $searchCategoryUser).
")";
466 $listofcategoryid .= ($listofcategoryid ?
', ' :
'') .((
int) $searchCategoryUser);
470 if ($listofcategoryid) {
471 $searchCategoryUserSqlList[] =
" EXISTS (SELECT ck.fk_user FROM ".MAIN_DB_PREFIX.
"categorie_user as ck WHERE u.rowid = ck.fk_user AND ck.fk_categorie IN (".$db->sanitize($listofcategoryid).
"))";
473 if ($searchCategoryUserOperator == 1) {
474 if (!empty($searchCategoryUserSqlList)) {
475 $sql .=
" AND (".implode(
' OR ', $searchCategoryUserSqlList).
")";
478 if (!empty($searchCategoryUserSqlList)) {
479 $sql .=
" AND (".implode(
' AND ', $searchCategoryUserSqlList).
")";
483 if ($search_warehouse > 0) {
484 $sql .=
" AND u.fk_warehouse = ".((int) $search_warehouse);
486 if (
isModEnabled(
'salaries') && $contextpage ==
'employeelist' && !$user->hasRight(
"salaries",
"readall")) {
487 $sql .=
" AND u.rowid IN (".$db->sanitize(join(
',', $childids)).
")";
490 include DOL_DOCUMENT_ROOT.
'/core/tpl/extrafields_list_search_sql.tpl.php';
492 $parameters = array();
493 $reshook = $hookmanager->executeHooks(
'printFieldListWhere', $parameters, $object);
494 $sql .= $hookmanager->resPrint;
497 $nbtotalofrecords =
'';
500 $sqlforcount = preg_replace(
'/^'.preg_quote($sqlfields,
'/').
'/',
'SELECT COUNT(*) as nbtotalofrecords',
$sql);
501 $sqlforcount = preg_replace(
'/GROUP BY .*$/',
'', $sqlforcount);
502 $resql = $db->query($sqlforcount);
504 $objforcount = $db->fetch_object($resql);
505 $nbtotalofrecords = $objforcount->nbtotalofrecords;
510 if (($page * $limit) > $nbtotalofrecords) {
518 $sql .= $db->order($sortfield, $sortorder);
520 $sql .= $db->plimit($limit + 1, $offset);
523 $resql = $db->query(
$sql);
529 $num = $db->num_rows($resql);
532 if ($num == 1 && !empty($conf->global->MAIN_SEARCH_DIRECT_OPEN_IF_ONLY_ONE) && $search_all && !$page) {
533 $obj = $db->fetch_object($resql);
535 header(
"Location: ".DOL_URL_ROOT.
'/user/card.php?id='.$id);
544 $arrayofselected = is_array($toselect) ? $toselect : array();
548 $param .=
'&mode='.urlencode($mode);
550 if (!empty($contextpage) && $contextpage != $_SERVER[
"PHP_SELF"]) {
551 $param .=
'&contextpage='.urlencode($contextpage);
553 if ($limit > 0 && $limit != $conf->liste_limit) {
554 $param .=
'&limit='.((int) $limit);
556 if ($search_all !=
'') {
557 $param .=
'&search_all='.urlencode($search_all);
559 if ($search_user !=
'') {
560 $param .=
"&search_user=".urlencode($search_user);
562 if ($search_login !=
'') {
563 $param .=
"&search_login=".urlencode($search_login);
565 if ($search_lastname !=
'') {
566 $param .=
"&search_lastname=".urlencode($search_lastname);
568 if ($search_firstname !=
'') {
569 $param .=
"&search_firstname=".urlencode($search_firstname);
571 if ($search_gender !=
'' && $search_gender !=
'-1') {
572 $param .=
"&search_gender=".urlencode($search_gender);
574 if ($search_employee !=
'' && $search_employee !=
'-1') {
575 $param .=
"&search_employee=".urlencode($search_employee);
577 if ($search_accountancy_code !=
'') {
578 $param .=
"&search_accountancy_code=".urlencode($search_accountancy_code);
580 if ($search_phonepro !=
'') {
581 $param .=
"&search_phonepro=".urlencode($search_phonepro);
583 if ($search_phonemobile !=
'') {
584 $param .=
"&search_phonemobile=".urlencode($search_phonemobile);
586 if ($search_email !=
'') {
587 $param .=
"&search_email=".urlencode($search_email);
589 if ($search_api_key !=
'') {
590 $param .=
"&search_api_key=".urlencode($search_api_key);
592 if ($search_supervisor > 0) {
593 $param .=
"&search_supervisor=".urlencode($search_supervisor);
595 if ($search_statut !=
'') {
596 $param .=
"&search_statut=".urlencode($search_statut);
598 if ($optioncss !=
'') {
599 $param .=
'&optioncss='.urlencode($optioncss);
601 if ($search_categ > 0) {
602 $param .=
'&search_categ='.urlencode($search_categ);
604 if ($search_warehouse > 0) {
605 $param .=
'&search_warehouse='.urlencode($search_warehouse);
608 include DOL_DOCUMENT_ROOT.
'/core/tpl/extrafields_list_search_param.tpl.php';
611 $arrayofmassactions = array();
612 if ($permissiontoadd) {
613 $arrayofmassactions[
'disable'] =
img_picto(
'',
'close_title',
'class="pictofixedwidth"').$langs->trans(
"DisableUser");
615 if ($permissiontoadd) {
616 $arrayofmassactions[
'reactivate'] =
img_picto(
'',
'check',
'class="pictofixedwidth"').$langs->trans(
"Reactivate");
619 $arrayofmassactions[
'preaffecttag'] =
img_picto(
'',
'category',
'class="pictofixedwidth"').$langs->trans(
"AffectTag");
621 if ($permissiontoadd) {
622 $arrayofmassactions[
'presetsupervisor'] =
img_picto(
'',
'user',
'class="pictofixedwidth"').$langs->trans(
"SetSupervisor");
626 if (
GETPOST(
'nomassaction',
'int') || in_array($massaction, array(
'presend',
'predelete',
'preaffecttag',
'presetsupervisor'))) {
627 $arrayofmassactions = array();
629 $massactionbutton =
$form->selectMassAction(
'', $arrayofmassactions);
631 print
'<form method="POST" id="searchFormList" action="'.$_SERVER[
"PHP_SELF"].
'">'.
"\n";
632 if ($optioncss !=
'') {
633 print
'<input type="hidden" name="optioncss" value="'.$optioncss.
'">';
635 print
'<input type="hidden" name="token" value="'.newToken().
'">';
636 print
'<input type="hidden" name="formfilteraction" id="formfilteraction" value="list">';
637 print
'<input type="hidden" name="sortfield" value="'.$sortfield.
'">';
638 print
'<input type="hidden" name="sortorder" value="'.$sortorder.
'">';
639 print
'<input type="hidden" name="page" value="'.$page.
'">';
640 print
'<input type="hidden" name="contextpage" value="'.$contextpage.
'">';
641 print
'<input type="hidden" name="page_y" value="">';
642 print
'<input type="hidden" name="mode" value="'.$mode.
'">';
644 $url = DOL_URL_ROOT.
'/user/card.php?action=create'.($contextpage ==
'employeelist' ?
'&search_employee=1' :
'').
'&leftmenu=';
645 if (!empty($socid)) {
646 $url .=
'&socid='.urlencode($socid);
650 $newcardbutton .=
dolGetButtonTitle($langs->trans(
'ViewList'),
'',
'fa fa-bars paddingleft imgforviewmode', DOL_URL_ROOT.
'/user/list.php?mode=common'.preg_replace(
'/(&|\?)*mode=[^&]+/',
'', $param),
'', ((empty($mode) || $mode ==
'common') ? 2 : 1), array(
'morecss'=>
'reposition'));
651 $newcardbutton .=
dolGetButtonTitle($langs->trans(
'HierarchicView'),
'',
'fa fa-stream paddingleft imgforviewmode', DOL_URL_ROOT.
'/user/hierarchy.php?mode=hierarchy'.preg_replace(
'/(&|\?)*mode=[^&]+/',
'', $param),
'', (($mode ==
'hierarchy') ? 2 : 1), array(
'morecss'=>
'reposition'));
652 $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'));
654 $newcardbutton .=
dolGetButtonTitle($langs->trans(
'NewUser'),
'',
'fa fa-plus-circle', $url,
'', $permissiontoadd);
661 print_barre_liste($title, $page, $_SERVER[
"PHP_SELF"], $param, $sortfield, $sortorder, $massactionbutton, $num, $nbtotalofrecords,
'user', 0, $morehtmlright.
' '.$newcardbutton,
'', $limit, 0, 0, 1);
666 $topicmail =
"SendUserRef";
668 $objecttmp =
new User($db);
669 $trackid =
'use'.$object->id;
670 include DOL_DOCUMENT_ROOT.
'/core/tpl/massactions_pre.tpl.php';
672 if (!empty($catid)) {
673 print
"<div id='ways'>";
675 $ways = $c->print_all_ways(
' > ',
'user/list.php');
676 print
" > ".$ways[0].
"<br>\n";
681 foreach ($fieldstosearchall as $key => $val) {
682 $fieldstosearchall[$key] = $langs->trans($val);
684 print
'<!-- Search done like if USER_QUICKSEARCH_ON_FIELDS = '.$setupstring.
' -->'.
"\n";
685 print
'<div class="divsearchfieldfilter">'.$langs->trans(
"FilterOnInto", $search_all).join(
', ', $fieldstosearchall).
'</div>';
694 if (
isModEnabled(
'categorie') && $user->hasRight(
"categorie",
"read")) {
695 $moreforfilter .=
'<div class="divsearchfield">';
696 $tmptitle = $langs->trans(
'Category');
697 $moreforfilter .=
img_picto($langs->trans(
"Category"),
'category',
'class="pictofixedwidth"').$formother->select_categories(Categorie::TYPE_USER, $search_categ,
'search_categ', 1, $tmptitle);
698 $moreforfilter .=
'</div>';
701 if (
isModEnabled(
'stock') && !empty($conf->global->MAIN_DEFAULT_WAREHOUSE_USER)) {
702 require_once DOL_DOCUMENT_ROOT.
'/product/class/html.formproduct.class.php';
704 $moreforfilter .=
'<div class="divsearchfield">';
705 $tmptitle = $langs->trans(
'Warehouse');
706 $moreforfilter .=
img_picto($tmptitle,
'stock',
'class="pictofixedwidth"').$formproduct->selectWarehouses($search_warehouse,
'search_warehouse',
'', $tmptitle, 0, 0, $tmptitle);
707 $moreforfilter .=
'</div>';
710 $parameters = array();
711 $reshook = $hookmanager->executeHooks(
'printFieldPreListTitle', $parameters, $object);
712 if (empty($reshook)) {
713 $moreforfilter .= $hookmanager->resPrint;
715 $moreforfilter = $hookmanager->resPrint;
718 if (!empty($moreforfilter)) {
719 print
'<div class="liste_titre liste_titre_bydiv centpercent">';
720 print $moreforfilter;
724 $varpage = empty($contextpage) ? $_SERVER[
"PHP_SELF"] : $contextpage;
725 $selectedfields =
$form->multiSelectArrayWithCheckbox(
'selectedfields', $arrayfields, $varpage,
getDolGlobalString(
'MAIN_CHECKBOX_LEFT_COLUMN',
''));
726 $selectedfields .= (count($arrayofmassactions) ?
$form->showCheckAddButtons(
'checkforselect', 1) :
'');
728 print
'<div class="div-table-responsive">';
729 print
'<table class="tagtable nobottomiftotal liste'.($moreforfilter ?
" listwithfilterbefore" :
"").
'">'.
"\n";
733 print
'<tr class="liste_titre_filter">';
736 print
'<td class="liste_titre center maxwidthsearch">';
737 $searchpicto =
$form->showFilterButtons(
'left');
741 if (!empty($arrayfields[
'u.login'][
'checked'])) {
742 print
'<td class="liste_titre"><input type="text" name="search_login" class="maxwidth50" value="'.$search_login.
'"></td>';
744 if (!empty($arrayfields[
'u.lastname'][
'checked'])) {
745 print
'<td class="liste_titre"><input type="text" name="search_lastname" class="maxwidth50" value="'.$search_lastname.
'"></td>';
747 if (!empty($arrayfields[
'u.firstname'][
'checked'])) {
748 print
'<td class="liste_titre"><input type="text" name="search_firstname" class="maxwidth50" value="'.$search_firstname.
'"></td>';
750 if (!empty($arrayfields[
'u.gender'][
'checked'])) {
751 print
'<td class="liste_titre center">';
752 $arraygender = array(
'man'=>$langs->trans(
"Genderman"),
'woman'=>$langs->trans(
"Genderwoman"),
'other'=>$langs->trans(
"Genderother"));
753 print
$form->selectarray(
'search_gender', $arraygender, $search_gender, 1);
756 if (!empty($arrayfields[
'u.employee'][
'checked'])) {
757 print
'<td class="liste_titre">';
758 print
$form->selectyesno(
'search_employee', $search_employee, 1,
false, 1);
762 if (!empty($arrayfields[
'u.fk_user'][
'checked'])) {
763 print
'<td class="liste_titre">';
764 print
$form->select_dolusers($search_supervisor,
'search_supervisor', 1, array(), 0,
'', 0, 0, 0, 0,
'', 0,
'',
'maxwidth125');
767 if (!empty($arrayfields[
'u.accountancy_code'][
'checked'])) {
768 print
'<td class="liste_titre"><input type="text" name="search_accountancy_code" class="maxwidth50" value="'.$search_accountancy_code.
'"></td>';
770 if (!empty($arrayfields[
'u.office_phone'][
'checked'])) {
771 print
'<td class="liste_titre"><input type="text" name="search_phonepro" class="maxwidth50" value="'.$search_phonepro.
'"></td>';
773 if (!empty($arrayfields[
'u.user_mobile'][
'checked'])) {
774 print
'<td class="liste_titre"><input type="text" name="search_phonemobile" class="maxwidth50" value="'.$search_phonemobile.
'"></td>';
776 if (!empty($arrayfields[
'u.email'][
'checked'])) {
777 print
'<td class="liste_titre"><input type="text" name="search_email" class="maxwidth75" value="'.$search_email.
'"></td>';
779 if (!empty($arrayfields[
'u.api_key'][
'checked'])) {
780 print
'<td class="liste_titre"><input type="text" name="search_api_key" class="maxwidth50" value="'.$search_api_key.
'"></td>';
782 if (!empty($arrayfields[
'u.fk_soc'][
'checked'])) {
783 print
'<td class="liste_titre"><input type="text" name="search_thirdparty" class="maxwidth75" value="'.$search_thirdparty.
'"></td>';
785 if (!empty($arrayfields[
'u.entity'][
'checked'])) {
786 print
'<td class="liste_titre"></td>';
788 if (!empty($arrayfields[
'u.ref_employee'][
'checked'])) {
789 print
'<td class="liste_titre"></td>';
791 if (!empty($arrayfields[
'u.national_registration_number'][
'checked'])) {
792 print
'<td class="liste_titre"></td>';
794 if (!empty($arrayfields[
'u.job'][
'checked'])) {
795 print
'<td class="liste_titre"><input type="text" name="search_job" class="maxwidth75" value="'.$search_job.
'"></td>';
797 if (!empty($arrayfields[
'u.salary'][
'checked'])) {
798 print
'<td class="liste_titre"></td>';
800 if (!empty($arrayfields[
'u.datelastlogin'][
'checked'])) {
801 print
'<td class="liste_titre"></td>';
803 if (!empty($arrayfields[
'u.datepreviouslogin'][
'checked'])) {
804 print
'<td class="liste_titre"></td>';
807 include DOL_DOCUMENT_ROOT.
'/core/tpl/extrafields_list_search_input.tpl.php';
809 $parameters = array(
'arrayfields'=>$arrayfields);
810 $reshook = $hookmanager->executeHooks(
'printFieldListOption', $parameters, $object);
811 print $hookmanager->resPrint;
812 if (!empty($arrayfields[
'u.datec'][
'checked'])) {
814 print
'<td class="liste_titre">';
817 if (!empty($arrayfields[
'u.tms'][
'checked'])) {
819 print
'<td class="liste_titre">';
822 if (!empty($arrayfields[
'u.statut'][
'checked'])) {
824 print
'<td class="liste_titre center parentonrightofpage">';
825 print
$form->selectarray(
'search_statut', array(
'-1'=>
'',
'0'=>$langs->trans(
'Disabled'),
'1'=>$langs->trans(
'Enabled')), $search_statut, 0, 0, 0,
'', 0, 0, 0,
'',
'search_status width100 onrightofpage');
830 print
'<td class="liste_titre maxwidthsearch">';
831 $searchpicto =
$form->showFilterButtons();
837 $totalarray = array();
838 $totalarray[
'nbfield'] = 0;
842 print
'<tr class="liste_titre">';
844 print
getTitleFieldOfList(($mode !=
'kanban' ? $selectedfields :
''), 0, $_SERVER[
"PHP_SELF"],
'',
'',
'',
'', $sortfield, $sortorder,
'center maxwidthsearch ').
"\n";
845 $totalarray[
'nbfield']++;
847 if (!empty($arrayfields[
'u.login'][
'checked'])) {
848 print_liste_field_titre($arrayfields[
'u.login'][
'label'], $_SERVER[
'PHP_SELF'],
"u.login", $param,
"",
"", $sortfield, $sortorder);
849 $totalarray[
'nbfield']++;
851 if (!empty($arrayfields[
'u.lastname'][
'checked'])) {
852 print_liste_field_titre(
"Lastname", $_SERVER[
'PHP_SELF'],
"u.lastname", $param,
"",
"", $sortfield, $sortorder);
853 $totalarray[
'nbfield']++;
855 if (!empty($arrayfields[
'u.firstname'][
'checked'])) {
856 print_liste_field_titre(
"FirstName", $_SERVER[
'PHP_SELF'],
"u.firstname", $param,
"",
"", $sortfield, $sortorder);
857 $totalarray[
'nbfield']++;
859 if (!empty($arrayfields[
'u.gender'][
'checked'])) {
860 print_liste_field_titre(
"Gender", $_SERVER[
'PHP_SELF'],
"u.gender", $param,
"",
"", $sortfield, $sortorder,
'center ');
861 $totalarray[
'nbfield']++;
863 if (!empty($arrayfields[
'u.employee'][
'checked'])) {
864 print_liste_field_titre(
"Employee", $_SERVER[
'PHP_SELF'],
"u.employee", $param,
"",
"", $sortfield, $sortorder,
'center ');
865 $totalarray[
'nbfield']++;
867 if (!empty($arrayfields[
'u.fk_user'][
'checked'])) {
868 print_liste_field_titre(
"HierarchicalResponsible", $_SERVER[
'PHP_SELF'],
"u.fk_user", $param,
"",
"", $sortfield, $sortorder);
869 $totalarray[
'nbfield']++;
871 if (!empty($arrayfields[
'u.accountancy_code'][
'checked'])) {
872 print_liste_field_titre(
"AccountancyCode", $_SERVER[
'PHP_SELF'],
"u.accountancy_code", $param,
"",
"", $sortfield, $sortorder);
873 $totalarray[
'nbfield']++;
875 if (!empty($arrayfields[
'u.office_phone'][
'checked'])) {
876 print_liste_field_titre(
"PhonePro", $_SERVER[
'PHP_SELF'],
"u.office_phone", $param,
"",
"", $sortfield, $sortorder);
877 $totalarray[
'nbfield']++;
879 if (!empty($arrayfields[
'u.user_mobile'][
'checked'])) {
880 print_liste_field_titre(
"PhoneMobile", $_SERVER[
'PHP_SELF'],
"u.user_mobile", $param,
"",
"", $sortfield, $sortorder);
881 $totalarray[
'nbfield']++;
883 if (!empty($arrayfields[
'u.email'][
'checked'])) {
885 $totalarray[
'nbfield']++;
887 if (!empty($arrayfields[
'u.api_key'][
'checked'])) {
889 $totalarray[
'nbfield']++;
891 if (!empty($arrayfields[
'u.fk_soc'][
'checked'])) {
893 $totalarray[
'nbfield']++;
895 if (!empty($arrayfields[
'u.entity'][
'checked'])) {
896 print_liste_field_titre($arrayfields[
'u.entity'][
'label'], $_SERVER[
'PHP_SELF'],
"u.entity", $param,
"",
"", $sortfield, $sortorder);
897 $totalarray[
'nbfield']++;
899 if (!empty($arrayfields[
'u.job'][
'checked'])) {
900 print_liste_field_titre($arrayfields[
'u.job'][
'label'], $_SERVER[
'PHP_SELF'],
"u.job", $param,
"",
"", $sortfield, $sortorder);
901 $totalarray[
'nbfield']++;
903 if (!empty($arrayfields[
'u.ref_employee'][
'checked'])) {
904 print_liste_field_titre(
"RefEmployee", $_SERVER[
'PHP_SELF'],
"u.ref_employee", $param,
"",
"", $sortfield, $sortorder);
905 $totalarray[
'nbfield']++;
907 if (!empty($arrayfields[
'u.national_registration_number'][
'checked'])) {
908 print_liste_field_titre(
"NationalRegistrationNumber", $_SERVER[
'PHP_SELF'],
"u.national_registration_number", $param,
"",
"", $sortfield, $sortorder);
909 $totalarray[
'nbfield']++;
911 if (!empty($arrayfields[
'u.salary'][
'checked'])) {
912 print_liste_field_titre(
"Salary", $_SERVER[
'PHP_SELF'],
"u.salary", $param,
"",
"", $sortfield, $sortorder,
'right ');
913 $totalarray[
'nbfield']++;
915 if (!empty($arrayfields[
'u.datelastlogin'][
'checked'])) {
916 print_liste_field_titre(
"LastConnexion", $_SERVER[
'PHP_SELF'],
"u.datelastlogin", $param,
"",
'', $sortfield, $sortorder,
'center ');
917 $totalarray[
'nbfield']++;
919 if (!empty($arrayfields[
'u.datepreviouslogin'][
'checked'])) {
920 print_liste_field_titre(
"PreviousConnexion", $_SERVER[
'PHP_SELF'],
"u.datepreviouslogin", $param,
"",
'', $sortfield, $sortorder,
'center ');
921 $totalarray[
'nbfield']++;
924 include DOL_DOCUMENT_ROOT.
'/core/tpl/extrafields_list_search_title.tpl.php';
926 $parameters = array(
'arrayfields'=>$arrayfields,
'param'=>$param,
'sortfield'=>$sortfield,
'sortorder'=>$sortorder,
'totalarray'=>&$totalarray);
927 $reshook = $hookmanager->executeHooks(
'printFieldListTitle', $parameters, $object);
928 print $hookmanager->resPrint;
929 if (!empty($arrayfields[
'u.datec'][
'checked'])) {
930 print_liste_field_titre(
"DateCreationShort", $_SERVER[
"PHP_SELF"],
"u.datec",
"", $param,
'', $sortfield, $sortorder,
'center nowrap ');
931 $totalarray[
'nbfield']++;
933 if (!empty($arrayfields[
'u.tms'][
'checked'])) {
934 print_liste_field_titre(
"DateModificationShort", $_SERVER[
"PHP_SELF"],
"u.tms",
"", $param,
'', $sortfield, $sortorder,
'center nowrap ');
935 $totalarray[
'nbfield']++;
937 if (!empty($arrayfields[
'u.statut'][
'checked'])) {
938 print_liste_field_titre(
"Status", $_SERVER[
"PHP_SELF"],
"u.statut",
"", $param,
'', $sortfield, $sortorder,
'center ');
939 $totalarray[
'nbfield']++;
943 print
getTitleFieldOfList(($mode !=
'kanban' ? $selectedfields :
''), 0, $_SERVER[
"PHP_SELF"],
'',
'',
'',
'', $sortfield, $sortorder,
'center maxwidthsearch ').
"\n";
944 $totalarray[
'nbfield']++;
950 $needToFetchEachLine = 0;
951 if (isset($extrafields->attributes[$object->table_element][
'computed']) && is_array($extrafields->attributes[$object->table_element][
'computed']) && count($extrafields->attributes[$object->table_element][
'computed']) > 0) {
952 foreach ($extrafields->attributes[$object->table_element][
'computed'] as $key => $val) {
953 if (!is_null($val) && preg_match(
'/\$object/', $val)) {
954 $needToFetchEachLine++;
963 $savnbfield = $totalarray[
'nbfield'];
964 $totalarray = array(
'val'=>array(
'u.salary'=>0));
965 $totalarray[
'nbfield'] = 0;
966 $imaxinloop = ($limit ? min($num, $limit) : $num);
967 while ($i < $imaxinloop) {
968 $obj = $db->fetch_object($resql);
973 if (empty($obj->country_code)) {
974 $obj->country_code =
'';
978 $object->setVarsFromFetchObj($obj);
980 $object->id = $obj->rowid;
981 $object->admin = $obj->admin;
982 $object->ref = $obj->rowid;
983 $object->login = $obj->login;
984 $object->statut = $obj->status;
985 $object->status = $obj->status;
986 $object->office_phone = $obj->office_phone;
987 $object->user_mobile = $obj->user_mobile;
988 $object->job = $obj->job;
989 $object->email = $obj->email;
990 $object->gender = $obj->gender;
991 $object->socid = $obj->fk_soc;
992 $object->firstname = $obj->firstname;
993 $object->lastname = $obj->lastname;
994 $object->employee = $obj->employee;
995 $object->photo = $obj->photo;
997 $li = $object->getNomUrl(-1,
'', 0, 0, 24, 1,
'login',
'', 1);
1000 if ((
isModEnabled(
'salaries') && $user->hasRight(
"salaries",
"read") && in_array($obj->rowid, $childids))
1001 || (
isModEnabled(
'salaries') && $user->hasRight(
"salaries",
"readall"))
1002 || (
isModEnabled(
'hrm') && $user->hasRight(
"hrm",
"employee",
"read"))) {
1003 $canreadhrmdata = 1;
1005 $canreadsecretapi = 0;
1006 if ($user->id == $obj->rowid || !empty($user->admin)) {
1007 $canreadsecretapi = 1;
1010 if ($mode ==
'kanban') {
1012 print
'<tr class="trkanban"><td colspan="'.$savnbfield.
'">';
1013 print
'<div class="box-flex-container kanban">';
1017 print $object->getKanbanView(
'', array(
'selected' => in_array($object->id, $arrayofselected)));
1018 if ($i == ($imaxinloop - 1)) {
1025 print
'<tr data-rowid="'.$object->id.
'" class="oddeven">';
1028 print
'<td class="nowrap center">';
1029 if ($massactionbutton || $massaction) {
1031 if (in_array($object->id, $arrayofselected)) {
1034 print
'<input id="cb'.$object->id.
'" class="flat checkforselect" type="checkbox" name="toselect[]" value="'.$object->id.
'"'.($selected ?
' checked="checked"' :
'').
'>';
1038 $totalarray[
'nbfield']++;
1042 if (!empty($arrayfields[
'u.login'][
'checked'])) {
1043 print
'<td class="nowraponall tdoverflowmax150">';
1045 if (
isModEnabled(
'multicompany') && $obj->admin && !$obj->entity) {
1046 print
img_picto($langs->trans(
"SuperAdministrator"),
'redstar',
'class="valignmiddle paddingright paddingleft"');
1047 } elseif ($obj->admin) {
1048 print
img_picto($langs->trans(
"Administrator"),
'star',
'class="valignmiddle paddingright paddingleft"');
1052 $totalarray[
'nbfield']++;
1055 if (!empty($arrayfields[
'u.lastname'][
'checked'])) {
1056 print
'<td class="tdoverflowmax150" title="'.dol_escape_htmltag($obj->lastname).
'">'.
dol_escape_htmltag($obj->lastname).
'</td>';
1058 $totalarray[
'nbfield']++;
1061 if (!empty($arrayfields[
'u.firstname'][
'checked'])) {
1062 print
'<td class="tdoverflowmax150" title="'.dol_escape_htmltag($obj->lastname).
'">'.
dol_escape_htmltag($obj->firstname).
'</td>';
1064 $totalarray[
'nbfield']++;
1067 if (!empty($arrayfields[
'u.gender'][
'checked'])) {
1068 print
'<td class="center">';
1072 switch ($obj->gender) {
1074 $addgendertxt .=
'<i class="fas fa-mars" title="'.dol_escape_htmltag($langs->trans(
"Gender".$obj->gender)).
'"></i>';
1077 $addgendertxt .=
'<i class="fas fa-venus" title="'.dol_escape_htmltag($langs->trans(
"Gender".$obj->gender)).
'"></i>';
1080 $addgendertxt .=
'<i class="fas fa-transgender" title="'.dol_escape_htmltag($langs->trans(
"Gender".$obj->gender)).
'"></i>';
1083 print $addgendertxt;
1088 $totalarray[
'nbfield']++;
1092 if (!empty($arrayfields[
'u.employee'][
'checked'])) {
1093 print
'<td class="center">'.yn($obj->employee).
'</td>';
1095 $totalarray[
'nbfield']++;
1100 if (!empty($arrayfields[
'u.fk_user'][
'checked'])) {
1101 print
'<td class="tdoverflowmax125">';
1103 $user2->id = $obj->id2;
1104 $user2->login = $obj->login2;
1105 $user2->lastname = $obj->lastname2;
1106 $user2->firstname = $obj->firstname2;
1107 $user2->gender = $obj->gender2;
1108 $user2->photo = $obj->photo2;
1109 $user2->admin = $obj->admin2;
1110 $user2->office_phone = $obj->office_phone;
1111 $user2->user_mobile = $obj->user_mobile;
1112 $user2->email = $obj->email2;
1113 $user2->socid = $obj->fk_soc2;
1114 $user2->statut = $obj->status2;
1115 $user2->status = $obj->status2;
1116 if (
isModEnabled(
'multicompany') && $obj->admin2 && !$obj->entity2) {
1117 print
img_picto($langs->trans(
"SuperAdministrator"),
'redstar',
'class="valignmiddle paddingright"');
1118 } elseif ($obj->admin2) {
1119 print
img_picto($langs->trans(
"Administrator"),
'star',
'class="valignmiddle paddingright"');
1121 print $user2->getNomUrl(-1,
'', 0, 0, 24, 0,
'',
'', 1);
1125 $totalarray[
'nbfield']++;
1129 if (!empty($arrayfields[
'u.accountancy_code'][
'checked'])) {
1130 print
'<td>'.$obj->accountancy_code.
'</td>';
1132 $totalarray[
'nbfield']++;
1137 if (!empty($arrayfields[
'u.office_phone'][
'checked'])) {
1138 print
'<td class="tdoverflowmax125">'.dol_print_phone($obj->office_phone, $obj->country_code, 0, $obj->rowid,
'AC_TEL',
' ',
'phone').
"</td>\n";
1140 $totalarray[
'nbfield']++;
1143 if (!empty($arrayfields[
'u.user_mobile'][
'checked'])) {
1144 print
'<td class="tdoverflowmax125">'.dol_print_phone($obj->user_mobile, $obj->country_code, 0, $obj->rowid,
'AC_TEL',
' ',
'mobile').
"</td>\n";
1146 $totalarray[
'nbfield']++;
1149 if (!empty($arrayfields[
'u.email'][
'checked'])) {
1150 print
'<td class="tdoverflowmax150">'.dol_print_email($obj->email, $obj->rowid, $obj->fk_soc,
'AC_EMAIL', 0, 0, 1).
"</td>\n";
1152 $totalarray[
'nbfield']++;
1155 if (!empty($arrayfields[
'u.api_key'][
'checked'])) {
1157 print
'<td class="tdoverflowmax125" title="'.dol_escape_htmltag($api_key).
'">';
1159 if ($canreadsecretapi) {
1160 print
'<span class="opacitymedium">';
1164 print
'<span class="opacitymedium">'.$langs->trans(
"Hidden").
'</span>';
1169 $totalarray[
'nbfield']++;
1172 if (!empty($arrayfields[
'u.fk_soc'][
'checked'])) {
1173 print
'<td class="tdoverflowmax150">';
1174 if ($obj->fk_soc > 0) {
1175 $companystatic->id = $obj->fk_soc;
1176 $companystatic->name = $obj->name;
1177 $companystatic->canvas = $obj->canvas;
1178 print $companystatic->getNomUrl(1);
1179 } elseif ($obj->ldap_sid) {
1180 print
'<span class="opacitymedium">'.$langs->trans(
"DomainUser").
'</span>';
1182 print
'<span class="opacitymedium">'.$langs->trans(
"InternalUser").
'</span>';
1186 $totalarray[
'nbfield']++;
1190 if (
isModEnabled(
'multicompany') && is_object($mc) && empty($conf->global->MULTICOMPANY_TRANSVERSE_MODE)) {
1191 if (!empty($arrayfields[
'u.entity'][
'checked'])) {
1192 if (!$obj->entity) {
1193 $labeltouse = $langs->trans(
"AllEntities");
1195 $mc->getInfo($obj->entity);
1196 $labeltouse = $mc->label;
1198 print
'<td class="tdoverflowmax100" title="'.dol_escape_htmltag($labeltouse).
'">';
1202 $totalarray[
'nbfield']++;
1208 if (!empty($arrayfields[
'u.ref_employee'][
'checked'])) {
1209 print
'<td class="tdoverflowmax100" title="'.dol_escape_htmltag($obj->ref_employee).
'">';
1213 $totalarray[
'nbfield']++;
1217 if (!empty($arrayfields[
'u.national_registration_number'][
'checked'])) {
1218 print
'<td class="tdoverflowmax100" title="'.dol_escape_htmltag($obj->national_registration_number).
'">';
1222 $totalarray[
'nbfield']++;
1226 if (!empty($arrayfields[
'u.job'][
'checked'])) {
1227 print
'<td class="tdoverflowmax100" title="'.dol_escape_htmltag($obj->job).
'">';
1231 $totalarray[
'nbfield']++;
1236 if (!empty($arrayfields[
'u.salary'][
'checked'])) {
1237 print
'<td class="nowraponall right amount">';
1239 if ($canreadhrmdata) {
1240 print
price($obj->salary);
1242 print
'<span class="opacitymedium">'.$langs->trans(
"Hidden").
'</span>';
1247 $totalarray[
'nbfield']++;
1250 $totalarray[
'pos'][$totalarray[
'nbfield']] =
'u.salary';
1252 if (!isset($totalarray[
'val'])) {
1253 $totalarray[
'val'] = array();
1255 if (!isset($totalarray[
'val'][
'u.salary'])) {
1256 $totalarray[
'val'][
'u.salary'] = 0;
1258 $totalarray[
'val'][
'u.salary'] += $obj->salary;
1262 if (!empty($arrayfields[
'u.datelastlogin'][
'checked'])) {
1263 print
'<td class="nowrap center">'.dol_print_date($db->jdate($obj->datelastlogin),
"dayhour").
'</td>';
1265 $totalarray[
'nbfield']++;
1269 if (!empty($arrayfields[
'u.datepreviouslogin'][
'checked'])) {
1270 print
'<td class="nowrap center">'.dol_print_date($db->jdate($obj->datepreviouslogin),
"dayhour").
'</td>';
1272 $totalarray[
'nbfield']++;
1277 include DOL_DOCUMENT_ROOT.
'/core/tpl/extrafields_list_print_fields.tpl.php';
1279 $parameters = array(
'arrayfields'=>$arrayfields,
'object'=>$object,
'obj'=>$obj,
'i'=>$i,
'totalarray'=>&$totalarray);
1280 $reshook = $hookmanager->executeHooks(
'printFieldListValue', $parameters, $object);
1281 print $hookmanager->resPrint;
1283 if (!empty($arrayfields[
'u.datec'][
'checked'])) {
1284 print
'<td class="center nowraponall">';
1285 print
dol_print_date($db->jdate($obj->date_creation),
'dayhour',
'tzuser');
1288 $totalarray[
'nbfield']++;
1292 if (!empty($arrayfields[
'u.tms'][
'checked'])) {
1293 print
'<td class="center nowraponall">';
1294 print
dol_print_date($db->jdate($obj->date_update),
'dayhour',
'tzuser');
1297 $totalarray[
'nbfield']++;
1301 if (!empty($arrayfields[
'u.statut'][
'checked'])) {
1302 print
'<td class="center">'.$object->getLibStatut(5).
'</td>';
1304 $totalarray[
'nbfield']++;
1309 print
'<td class="nowrap center">';
1310 if ($massactionbutton || $massaction) {
1312 if (in_array($object->id, $arrayofselected)) {
1315 print
'<input id="cb'.$object->id.
'" class="flat checkforselect" type="checkbox" name="toselect[]" value="'.$object->id.
'"'.($selected ?
' checked="checked"' :
'').
'>';
1319 $totalarray[
'nbfield']++;
1330 include DOL_DOCUMENT_ROOT.
'/core/tpl/list_print_total.tpl.php';
1335 foreach ($arrayfields as $key => $val) {
1336 if (!empty($val[
'checked'])) {
1340 print
'<tr><td colspan="'.$colspan.
'"><span class="opacitymedium">'.$langs->trans(
"NoRecordFound").
'</span></td></tr>';
1346 $parameters = array(
'arrayfields'=>$arrayfields,
'sql'=>
$sql);
1347 $reshook = $hookmanager->executeHooks(
'printFieldListFooter', $parameters, $object, $action);
1348 print $hookmanager->resPrint;
1350 print
'</table>'.
"\n";
1351 print
'</div>'.
"\n";
1353 print
'</form>'.
"\n";
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.
if(!defined('NOREQUIRESOC')) if(!defined('NOREQUIRETRAN')) if(!defined('NOTOKENRENEWAL')) if(!defined('NOREQUIREMENU')) if(!defined('NOREQUIREHTML')) if(!defined('NOREQUIREAJAX')) llxHeader()
Empty header.
Class to manage categories.
Class to manage third parties objects (customers, suppliers, prospects...)
Class to manage Dolibarr users.
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.
if($cancel &&! $id) if($action=='add' &&! $cancel) if($action=='delete') if($id) $form
Actions.
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...
showValueWithClipboardCPButton($valuetocopy, $showonlyonhover=1, $texttoshow='')
Create a button to copy $valuetocopy in the clipboard (for copy and paste feature).
GETPOSTINT($paramname, $method=0)
Return value of a param into GET or POST supervariable.
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...
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.
dolGetButtonTitleSeparator($moreClass="")
Add space between dolGetButtonTitle.
GETPOST($paramname, $check='alphanohtml', $method=0, $filter=null, $options=null, $noreplace=0)
Return value of a param into GET or POST supervariable.
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.
dol_trunc($string, $size=40, $trunc='right', $stringencoding='UTF-8', $nodot=0, $display=0)
Truncate a string to a particular length adding '…' if string larger than length.
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...
dolDecrypt($chain, $key='')
Decode a string with a symetric encryption.
accessforbidden($message='', $printheader=1, $printfooter=1, $showonlymessage=0, $params=null)
Show a message to say access is forbidden and stop program.