hierarchy.php

Go to the documentation of this file.

<?php
/* Copyright (C) 2005      Matthieu Valleton    <mv@seeschloss.org>
 * Copyright (C) 2005      Eric Seigne          <eric.seigne@ryxeo.com>
 * Copyright (C) 2006-2015 Laurent Destailleur  <eldy@users.sourceforge.net>
 * Copyright (C) 2007      Patrick Raguin       <patrick.raguin@gmail.com>
 * Copyright (C) 2005-2012 Regis Houssin        <regis.houssin@inodbox.com>
 * Copyright (C) 2019-2024  Frédéric France      <frederic.france@free.fr>
 * Copyright (C) 2024   MDW             <mdeweerd@users.noreply.github.com>
 *
 * This program is free software; you can redistribute it and/or modify
 * it under the terms of the GNU General Public License as published by
 * the Free Software Foundation; either version 3 of the License, or
 * (at your option) any later version.
 *
 * This program is distributed in the hope that it will be useful,
 * but WITHOUT ANY WARRANTY; without even the implied warranty of
 * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
 * GNU General Public License for more details.
 *
 * You should have received a copy of the GNU General Public License
 * along with this program. If not, see <https://www.gnu.org/licenses/>.
 */
 
// Load Dolibarr environment
require '../main.inc.php';
require_once DOL_DOCUMENT_ROOT.'/core/lib/treeview.lib.php';
 
// Load translation files required by page
$langs->loadLangs(array('users', 'companies', 'hrm', 'salaries'));
 
// Security check (for external users)
$socid = 0;
if ($user->socid > 0) {
  $socid = $user->socid;
}
 
$optioncss = GETPOST('optioncss', 'alpha');
$contextpage = GETPOST('contextpage', 'aZ') ? GETPOST('contextpage', 'aZ') : 'userlist'; // To manage different context of search
$mode = GETPOST("mode", 'alpha');
if (empty($mode)) {
  $mode = 'hierarchy';
}
 
$sortfield = GETPOST('sortfield', 'aZ09comma');
$sortorder = GETPOST('sortorder', 'aZ09comma');
$page = GETPOSTISSET('pageplusone') ? (GETPOSTINT('pageplusone') - 1) : GETPOSTINT("page");
 
 
$search_status = GETPOST('search_status', 'intcomma');
if ($search_status == '') {
  $search_status = '1';
}
 
if (GETPOST('button_removefilter_x', 'alpha') || GETPOST('button_removefilter', 'alpha')) { // Both test are required to be compatible with all browsers
  $search_status = "";
}
 
$search_employee = -1;
if ($contextpage == 'employeelist') {
  $search_employee = 1;
}
 
$userstatic = new User($db);
 
// Define value to know what current user can do on users
$permissiontoadd = (!empty($user->admin) || $user->hasRight("user", "user", "write"));
 
// Permission to list
if (isModEnabled('salaries') && $contextpage == 'employeelist' && $search_employee == 1) {
  if (!$user->hasRight("salaries", "read")) {
    accessforbidden();
  }
} else {
  if (!$user->hasRight("user", "user", "read") && empty($user->admin)) {
    accessforbidden();
  }
}
 
$childids = $user->getAllChildIds(1);
 
 
 
/*
 * View
 */
 
$form = new Form($db);
 
$help_url = 'EN:Module_Users|FR:Module_Utilisateurs|ES:M&oacute;dulo_Usuarios|DE:Modul_Benutzer';
if ($contextpage == 'employeelist' && $search_employee == 1) {
  $title = $langs->trans("Employees");
} else {
  $title = $langs->trans("Users");
}
$arrayofjs = array(
  '/includes/jquery/plugins/jquerytreeview/jquery.treeview.js',
  '/includes/jquery/plugins/jquerytreeview/lib/jquery.cookie.js',
);
$arrayofcss = array('/includes/jquery/plugins/jquerytreeview/jquery.treeview.css');
 
llxHeader('', $title, $help_url, '', 0, 0, $arrayofjs, $arrayofcss, '', 'bodyforlist mod-user page-hierarchy');
 
$filters = [];
if (($search_status != '' && $search_status >= 0)) {
  $filters[] = "statut = ".((int) $search_status);
}
if (($search_employee != '' && $search_employee >= 0)) {
  $filters[] = "employee = ".((int) $search_employee);
}
$sqlfilter = '';
if (!empty($filters)) {
  $sqlfilter = implode(' AND ', $filters);
}
// Load hierarchy of users
$user_arbo_all = $userstatic->get_full_tree(0, '');
if ($sqlfilter) {
  $user_arbo = $userstatic->get_full_tree(0, $sqlfilter);
} else {
  $user_arbo = $user_arbo_all;
}
 
// Count total nb of records
$nbtotalofrecords = count($user_arbo);
 
 
if (!is_array($user_arbo) && $user_arbo < 0) {
  setEventMessages($userstatic->error, $userstatic->errors, 'warnings');
} else {
  // Define fulltree array
  $fulltree = $user_arbo;
  //var_dump($fulltree);
  // Define data (format for treeview)
  $data = array();
  $data[0] = array('rowid' => 0, 'fk_menu' => -1, 'title' => 'racine', 'mainmenu' => '', 'leftmenu' => '', 'fk_mainmenu' => '', 'fk_leftmenu' => '');
 
  foreach ($fulltree as $key => $val) {
    $userstatic->id = $val['id'];
    $userstatic->ref = (string) $val['id'];
    $userstatic->login = $val['login'];
    $userstatic->firstname = $val['firstname'];
    $userstatic->lastname = $val['lastname'];
    $userstatic->status = $val['statut'];
    $userstatic->email = $val['email'];
    $userstatic->gender = $val['gender'];
    $userstatic->socid = $val['fk_soc'];
    $userstatic->admin = $val['admin'];
    $userstatic->entity = $val['entity'];
    $userstatic->photo = $val['photo'];
 
    $entity = $val['entity'];
    $entitystring = '';
 
    // TODO Set of entitystring should be done with a hook
    if (isModEnabled('multicompany') && is_object($mc)) {
      if (empty($entity)) {
        $entitystring = $langs->trans("AllEntities");
      } else {
        $mc->getInfo($entity);
        $entitystring = $mc->label;
      }
    }
 
    $li = $userstatic->getNomUrl(-1, '', 0, 1);
    if (isModEnabled('multicompany') && $userstatic->admin && !$userstatic->entity) {
      $li .= img_picto($langs->trans("SuperAdministratorDesc"), 'redstar', 'class="valignmiddle paddingright paddingleft"');
    } elseif ($userstatic->admin) {
      $li .= img_picto($langs->trans("AdministratorDesc"), 'star', 'class="valignmiddle paddingright paddingleft"');
    }
    $li .= ' <span class="opacitymedium">('.$val['login'].($entitystring ? ' - '.$entitystring : '').')</span>';
 
    $entry = '<table class="nobordernopadding centpercent"><tr class="trtree"><td class="'.($val['statut'] ? 'usertdenabled' : 'usertddisabled').'">'.$li.'</td><td align="right" class="'.($val['statut'] ? 'usertdenabled' : 'usertddisabled').'">'.$userstatic->getLibStatut(2).'</td></tr></table>';
 
    $data[$val['rowid']] = array(
      'rowid' => $val['rowid'],
      'fk_menu' => $val['fk_user'], // TODO Replace fk_menu with fk_parent
      'statut' => $val['statut'],
      'entry' => $entry
    );
  }
 
  // Loop on $data to link user linked to a parent that was excluded by the filter
  foreach ($data as $key => $tmpdata) {
    $idparent = $tmpdata['fk_menu'];
    // Loop to check if parent exists
    if ($idparent > 0) {
      $parentfound = array_key_exists($idparent, $data) ? 1 : 0;
 
      $i = 0;
      while (!$parentfound && $i < 50) {
        // Parent was not found but we need it to show the child, so we reintroduce the parent
        if (!empty($user_arbo_all[$idparent])) {
          $val = $user_arbo_all[$idparent];
          $userstatic->id = $val['id'];
          $userstatic->ref = (string) $val['id'];
          $userstatic->login = $val['login'];
          $userstatic->firstname = $val['firstname'];
          $userstatic->lastname = $val['lastname'];
          $userstatic->status = $val['statut'];
          $userstatic->email = $val['email'];
          $userstatic->gender = $val['gender'];
          $userstatic->socid = $val['fk_soc'];
          $userstatic->admin = $val['admin'];
          $userstatic->entity = $val['entity'];
          $userstatic->photo = $val['photo'];
 
          $entity = $val['entity'];
          $entitystring = '';
 
          // TODO Set of entitystring should be done with a hook
          if (isModEnabled('multicompany') && is_object($mc)) {
            if (empty($entity)) {
              $entitystring = $langs->trans("AllEntities");
            } else {
              $mc->getInfo($entity);
              $entitystring = $mc->label;
            }
          }
 
          $li = '<span class="opacitymedium">';
          $li .= $userstatic->getNomUrl(-1, '', 0, 1);
          if (isModEnabled('multicompany') && $userstatic->admin && !$userstatic->entity) {
            $li .= img_picto($langs->trans("SuperAdministrator"), 'redstar');
          } elseif ($userstatic->admin) {
            $li .= img_picto($langs->trans("Administrator"), 'star');
          }
          $li .= ' <span class="opacitymedium">('.$val['login'].($entitystring ? ' - '.$entitystring : '').')</span>';
          $li .= ' - <span class="opacitymedium">'.$langs->trans("ExcludedByFilter").'</span>';
          $li .= '</span>';
 
          $entry = '<table class="nobordernopadding centpercent"><tr class="trtree"><td class="'.($val['statut'] ? 'usertdenabled' : 'usertddisabled').'">'.$li.'</td><td align="right" class="'.($val['statut'] ? 'usertdenabled' : 'usertddisabled').'">'.$userstatic->getLibStatut(2).'</td></tr></table>';
 
          $data[$idparent] = array(
            'rowid' => $idparent,
            'fk_menu' => $user_arbo_all[$idparent]['fk_user'],
            'statut' => $user_arbo_all[$idparent]['statut'],
            'entry' => $entry
          );
          $idparent = $user_arbo_all[$idparent]['fk_user'];
          if ($idparent > 0) {
            $parentfound = array_key_exists($idparent, $data) ? 1 : 0;
          } else {
            $parentfound = 1;
          }
          //var_dump($data[$idparent]);
        } else {
          // We should not be here. If a record has a parent id, parent id should be into $user_arbo_all
          $data[$key]['fk_menu'] = -2;
          if (empty($data[-2])) {
            $li = '<span class="opacitymedium">'.$langs->trans("WarningParentIDDoesNotExistAnymore").'</span>';
            $entry = '<table class="nobordernopadding centpercent"><tr class="trtree"><td class="usertddisabled">'.$li.'</td><td align="right" class="usertddisabled"></td></tr></table>';
            $data[-2] = array(
              'rowid' => -2,
              'fk_menu' => null,
              'statut' => 1,
              'entry' => $entry
            );
          }
          $parentfound = 1;
        }
 
        $i++;
      }
    }
  }
  //var_dump($data);exit;
 
  $param = "&search_status=".urlencode($search_status);
  $param = "&contextpage=".urlencode($contextpage);
 
  $newcardbutton = '';
  $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'));
  $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'));
  $newcardbutton .= dolGetButtonTitle($langs->trans('ViewKanban'), '', 'fa fa-th-list imgforviewmode', DOL_URL_ROOT.'/user/list.php?mode=kanban'.preg_replace('/(&|\?)*mode=[^&]+/', '', $param), '', ($mode == 'kanban' ? 2 : 1), array('morecss' => 'reposition'));
  $newcardbutton .= dolGetButtonTitleSeparator();
  $newcardbutton .= dolGetButtonTitle($langs->trans('NewUser'), '', 'fa fa-plus-circle', DOL_URL_ROOT.'/user/card.php?action=create'.($mode == 'employee' ? '&employee=1' : '').'&leftmenu=', '', (int) $permissiontoadd);
 
  $massactionbutton = '';
  $num = 0;
  $limit = 0;
 
  print_barre_liste($title, $page, $_SERVER["PHP_SELF"], $param, $sortfield, $sortorder, $massactionbutton, $num, $nbtotalofrecords, 'user', 0, $newcardbutton, '', $limit, 0, 0, 1);
 
  print '<form method="POST" id="searchFormList" action="'.$_SERVER["PHP_SELF"].'">'."\n";
  if ($optioncss != '') {
    print '<input type="hidden" name="optioncss" value="'.$optioncss.'">';
  }
  print '<input type="hidden" name="token" value="'.newToken().'">';
  print '<input type="hidden" name="formfilteraction" id="formfilteraction" value="list">';
  print '<input type="hidden" name="sortfield" value="'.$sortfield.'">';
  print '<input type="hidden" name="sortorder" value="'.$sortorder.'">';
  print '<input type="hidden" name="page" value="'.$page.'">';
  print '<input type="hidden" name="contextpage" value="'.$contextpage.'">';
  print '<input type="hidden" name="mode" value="'.$mode.'">';
 
  print '<div class="div-table-responsive">'; // You can use div-table-responsive-no-min if you don't need reserved height for your table
  print '<table class="liste nohover centpercent">';
 
  print '<tr class="liste_titre_filter">';
  // Action column
  if (getDolGlobalString('MAIN_CHECKBOX_LEFT_COLUMN')) {
    print '<td class="liste_titre maxwidthsearch">';
    $searchpicto = $form->showFilterAndCheckAddButtons(0);
    print $searchpicto;
    print '</td>';
  }
  print '<td class="liste_titre">&nbsp;</td>';
  print '<td class="liste_titre">&nbsp;</td>';
  // Status
  print '<td class="liste_titre right parentonrightofpage">';
  print $form->selectarray('search_status', array('-1' => '', '0' => $langs->trans('Disabled'), '1' => $langs->trans('Enabled')), $search_status, 0, 0, 0, '', 0, 0, 0, '', 'minwidth75imp onrightofpage width100');
  print '</td>';
  // Action column
  if (!getDolGlobalString('MAIN_CHECKBOX_LEFT_COLUMN')) {
    print '<td class="liste_titre maxwidthsearch">';
    $searchpicto = $form->showFilterAndCheckAddButtons(0);
    print $searchpicto;
    print '</td>';
  }
  print '</tr>';
 
  print '<tr class="liste_titre">';
  // Action column
  if (getDolGlobalString('MAIN_CHECKBOX_LEFT_COLUMN')) {
    print_liste_field_titre('', $_SERVER["PHP_SELF"], "", '', '', '', '', '', 'maxwidthsearch ');
  }
  print_liste_field_titre("HierarchicView");
  print_liste_field_titre('<div id="iddivjstreecontrol"><a href="#">'.img_picto('', 'folder', 'class="paddingright"').'<span class="hideonsmartphone">'.$langs->trans("UndoExpandAll").'</span></a> | <a href="#">'.img_picto('', 'folder-open', 'class="paddingright"').'<span class="hideonsmartphone">'.$langs->trans("ExpandAll").'</span></a></div>', $_SERVER['PHP_SELF'], "", '', "", 'align="center"');
  print_liste_field_titre("Status", $_SERVER['PHP_SELF'], "", '', "", '', '', '', 'right onrightofpage');
  // Action column
  if (!getDolGlobalString('MAIN_CHECKBOX_LEFT_COLUMN')) {
    print_liste_field_titre('', $_SERVER["PHP_SELF"], "", '', '', '', '', '', 'maxwidthsearch ');
  }
  print '</tr>';
 
 
  $nbofentries = (count($data) - 1);
 
  if ($nbofentries > 0) {
    print '<tr>';
    // Action column
    if (getDolGlobalString('MAIN_CHECKBOX_LEFT_COLUMN')) {
      print '<td></td>';
    }
    print '<td colspan="3">';
    tree_recur($data, $data[0], 0);
    print '</td>';
    // Action column
    if (!getDolGlobalString('MAIN_CHECKBOX_LEFT_COLUMN')) {
      print '<td></td>';
    }
    print '</tr>';
  } else {
    print '<tr class="oddeven">';
    print '<td colspan="3">';
    print '<table class="nobordernopadding"><tr class="nobordernopadding"><td>'.img_picto_common('', 'treemenu/branchbottom.gif').'</td>';
    print '<td valign="middle">';
    print $langs->trans("NoCategoryYet");
    print '</td>';
    print '<td>&nbsp;</td>';
    print '</table>';
    print '</td>';
    print '<td></td>';
    print '</tr>';
  }
 
  print "</table>";
  print '</div>';
 
  print "</form>\n";
}
 
//
/*print '<script type="text/javascript">
jQuery(document).ready(function() {
  function init_myfunc()
  {
    jQuery(".usertddisabled").hide();
  }
  init_myfunc();
});
</script>';
*/
 
// End of page
llxFooter();
$db->close();