perms.php

Go to the documentation of this file.

<?php
/* Copyright (C) 2002-2005  Rodolphe Quiedeville    <rodolphe@quiedeville.org>
 * Copyright (C) 2002-2003  Jean-Louis Bergamo      <jlb@j1b.org>
 * Copyright (C) 2004-2020  Laurent Destailleur     <eldy@users.sourceforge.net>
 * Copyright (C) 2004       Eric Seigne             <eric.seigne@ryxeo.com>
 * Copyright (C) 2005-2017  Regis Houssin           <regis.houssin@inodbox.com>
 * Copyright (C) 2012       Juanjo Menent           <jmenent@2byte.es>
 * Copyright (C) 2020       Tobias Sekan            <tobias.sekan@startmail.com>
 * Copyright (C) 2024       MDW                     <mdeweerd@users.noreply.github.com>
 * Copyright (C) 2024-2026  Frédéric France         <frederic.france@free.fr>
 * Copyright (C) 2025-2026  Charlene Benke          <charlene@patas-monkey.com>
 * Copyright (C) 2026       Alexandre Spangaro      <alexandre@inovea-conseil.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/>.
 */
 
if (!defined('CSRFCHECK_WITH_TOKEN')) {
  define('CSRFCHECK_WITH_TOKEN', '1'); // Force use of CSRF protection with tokens even for GET
}
 
// Load Dolibarr environment
require '../main.inc.php';
require_once DOL_DOCUMENT_ROOT.'/core/lib/usergroups.lib.php';
require_once DOL_DOCUMENT_ROOT.'/core/lib/functions2.lib.php';
require_once DOL_DOCUMENT_ROOT.'/core/lib/admin.lib.php';
 
// Load translation files required by page
$langs->loadLangs(array('users', 'admin'));
 
$id = GETPOSTINT('id');
$action = GETPOST('action', 'aZ09');
$confirm = GETPOST('confirm', 'alpha');
$module = GETPOST('module', 'alpha');
$rights = GETPOSTINT('rights');
$updatedmodulename = GETPOST('updatedmodulename', 'alpha');
$contextpage = GETPOST('contextpage', 'aZ') ? GETPOST('contextpage', 'aZ') : 'userperms'; // To manage different context of search
 
if (!isset($id) || empty($id)) {
  accessforbidden();
}
 
// Define if user can read permissions
$canreaduser = ($user->admin || $user->hasRight("user", "user", "read"));
// Define if user can modify other users and permissions
$caneditperms = ($user->admin || $user->hasRight("user", "user", "write"));
// Advanced permissions
if (getDolGlobalString('MAIN_USE_ADVANCED_PERMS')) {
  $canreaduser = ($user->admin || ($user->hasRight("user", "user", "read") && $user->hasRight("user", "user_advance", "readperms")));
  $caneditselfperms = ($user->id == $id && $user->hasRight("user", "self_advance", "writeperms"));
  $caneditperms = (($caneditperms || $caneditselfperms) ? 1 : 0);
}
 
// Security check
$socid = 0;
if (!empty($user->socid) && $user->socid > 0) {
  $socid = $user->socid;
}
$feature2 = (($socid && $user->hasRight("user", "self", "write")) ? '' : 'user');
// A user can always read its own card if not advanced perms enabled, or if he has advanced perms, except for admin
if ($user->id == $id && (getDolGlobalString('MAIN_USE_ADVANCED_PERMS') && !$user->hasRight("user", "self_advance", "readperms") && empty($user->admin))) {
  accessforbidden();
}
 
// Initialize a technical object to manage hooks of page. Note that conf->hooks_modules contains an array of hook context
$hookmanager->initHooks(array('usercard', 'userperms', 'globalcard'));
 
$result = restrictedArea($user, 'user', $id, 'user&user', $feature2);
if ($user->id != $id && !$canreaduser) {
  accessforbidden();
}
 
$object = new User($db);
$object->fetch($id, '', '', 1);
$object->loadRights();
 
$entity = $conf->entity;
 
 
/*
 * Actions
 */
 
$parameters = array('socid' => $socid);
$reshook = $hookmanager->executeHooks('doActions', $parameters, $object, $action); // Note that $action and $object may have been modified by some hooks
if ($reshook < 0) {
  setEventMessages($hookmanager->error, $hookmanager->errors, 'errors');
}
 
if (empty($reshook)) {
  if ($action == 'addrights' && $caneditperms && $confirm == 'yes') {
    $edituser = new User($db);
    $edituser->fetch($object->id);
    $result = $edituser->addrights($rights, $module, '', $entity);
    if ($result < 0) {
      setEventMessages($edituser->error, $edituser->errors, 'errors');
    }
 
    // If we are changing our own permissions, we reload permissions and menu
    if ($object->id == $user->id) {
      $user->clearrights();
      $user->loadRights();
      // @phan-suppress-next-line PhanRedefinedClassReference
      $menumanager->loadMenu();
    }
 
    $object->clearrights();
    $object->loadRights();
 
    // We redirect to avoid to get an URL with token inside
    $qs = $_SERVER["QUERY_STRING"];
    $qs = preg_replace('/&action=addrights/', '', $qs);
    $qs = preg_replace('/&token=[0-9a-f]+/i', '', $qs);
    $qs = preg_replace('/&confirm=yes/', '', $qs);
    header("Location: ".$_SERVER["PHP_SELF"].($qs ? "?".$qs : ""));
    exit;
  }
 
  if ($action == 'delrights' && $caneditperms && $confirm == 'yes') {
    $edituser = new User($db);
    $edituser->fetch($object->id);
    $result = $edituser->delrights($rights, $module, '', $entity);
    if ($result < 0) {
      setEventMessages($edituser->error, $edituser->errors, 'errors');
    }
 
    // If we are changing our own permissions, we reload permissions and menu
    if ($object->id == $user->id) {
      $user->clearrights();
      $user->loadRights();
      // @phan-suppress-next-line PhanRedefinedClassReference
      $menumanager->loadMenu();
    }
 
    $object->clearrights();
    $object->loadRights();
 
    // We redirect to avoid to get an URL with token inside
    $qs = $_SERVER["QUERY_STRING"];
    $qs = preg_replace('/&action=delrights/', '', $qs);
    $qs = preg_replace('/&token=[0-9a-f]+/i', '', $qs);
    $qs = preg_replace('/&confirm=yes/', '', $qs);
    header("Location: ".$_SERVER["PHP_SELF"].($qs ? "?".$qs : ""));
    exit;
  }
}
 
$db->begin();
 
// Search all modules with permission and reload permissions def.
$modules = array();
$modulesdir = dolGetModulesDirs();
 
// Modules to ignore depending on supplier module mode
$excludedModules = getDolGlobalInt('MAIN_USE_NEW_SUPPLIERMOD') ? array('modFournisseur') : array('modSupplierOrder', 'modSupplierInvoice');
 
// Preload MAIN_MODULE_* enablement for the target entity in one query, so we can skip calling
// insert_permissions() (which starts by re-checking this same enablement with its own query) on
// every disabled module found on disk. If we are looking at our own entity, $conf->global already
// has this cached from bootstrap and no query is needed at all.
if ($entity == $conf->entity) {
  $enabledmoduleconst = (array) $conf->global;
} else {
  $enabledmoduleconst = array();
  $sql = "SELECT ".$db->decrypt('name')." as name, ".$db->decrypt('value')." as value";
  $sql .= " FROM ".MAIN_DB_PREFIX."const";
  $sql .= " WHERE entity IN (0, ".((int) $entity).")";
  $sql .= " ORDER BY entity"; // entity 0 first, then entity-specific overrides it
  $resql = $db->query($sql);
  if ($resql) {
    while ($obj = $db->fetch_object($resql)) {
      $enabledmoduleconst[$obj->name] = $obj->value;
    }
    $db->free($resql);
  }
}
 
// Preload the ids of rights already present in llx_rights_def for this entity in one query, so insert_permissions()
// below can check existence in-memory instead of issuing one "SELECT count(*)" query per permission of every module.
$existingrightsdefids = array();
$sql = "SELECT id FROM ".MAIN_DB_PREFIX."rights_def WHERE entity = ".((int) $entity);
$resql = $db->query($sql);
if ($resql) {
  while ($obj = $db->fetch_object($resql)) {
    $existingrightsdefids[$obj->id] = 1;
  }
  $db->free($resql);
}
 
foreach ($modulesdir as $dir) {
  $handle = @opendir(dol_osencode($dir));
  if (is_resource($handle)) {
    while (($file = readdir($handle)) !== false) {
      if (is_readable($dir.$file) && substr($file, 0, 3) == 'mod' && substr($file, dol_strlen($file) - 10) == '.class.php') {
        $modName = substr($file, 0, dol_strlen($file) - 10);
 
        if ($modName) {
          // Exclude old/new supplier descriptors depending on MAIN_USE_NEW_SUPPLIERMOD
          if (in_array($modName, $excludedModules, true)) {
            continue;
          }
 
          include_once $dir.$file;
          $objMod = new $modName($db);
          '@phan-var-force DolibarrModules $objMod';
          // Load all lang files of module
          if (isset($objMod->langfiles) && is_array($objMod->langfiles)) {
            foreach ($objMod->langfiles as $domain) {
              $langs->load($domain);
            }
          }
          // Load all permissions
          if ($objMod->rights_class) {
            // Skip the DB round trip insert_permissions() would do just to find out the
            // module is disabled for this entity - we already know from the preload above.
            if (empty($objMod->const_name) || !empty($enabledmoduleconst[$objMod->const_name])) {
              $objMod->insert_permissions(0, $entity, 0, $existingrightsdefids);
            }
            $modules[$objMod->rights_class] = $objMod;
            //print "modules[".$objMod->rights_class."]=$objMod;";
          }
        }
      }
    }
  }
}
 
$db->commit();
 
'@phan-var-force DolibarrModules[] $modules';
 
 
// Fix bad value for module_position in table
// ------------------------------------------
$sql = "SELECT r.id, r.libelle as label, r.module, r.perms, r.subperms, r.module_position, r.family, r.family_position, r.bydefault";
$sql .= " FROM ".MAIN_DB_PREFIX."rights_def as r";
$sql .= " WHERE r.libelle NOT LIKE 'tou%'"; // We ignore permission "tous les tiers". Why ?
$sql .= " AND r.entity = ".((int) $entity);
$sql .= " ORDER BY r.family, r.family_position, r.module_position, r.right_position, r.module, r.id";
 
$result = $db->query($sql);
if ($result) {
  $num = $db->num_rows($result);
  $i = 0;
 
  while ($i < $num) {
    $obj = $db->fetch_object($result);
 
    // If line is for a module that does not exist anymore (absent of includes/module), we ignore it
    if (!isset($obj->module) || empty($modules[$obj->module])) {
      $i++;
      continue;
    }
 
    // Special cases
    if (isModEnabled("reception")) {
      // The 2 permissions in vendor modules are replaced by the 2 permissions into reception module
      if ($obj->module == 'fournisseur' && $obj->perms == 'commande' && $obj->subperms == 'receptionner') {
        $i++;
        continue;
      }
      if ($obj->module == 'fournisseur' && $obj->perms == 'commande_advance' && $obj->subperms == 'check') {
        $i++;
        continue;
      }
    }
 
    $objMod = $modules[$obj->module];
    // $objMod is necessarily an object here
 
    // Save field module_position in database if value is undefined or wrong (old data/version)
    if (empty($obj->module_position) || ($objMod->isCoreOrExternalModule() == 'external' && $obj->module_position < 100000)) {
      if (is_object($modules[$obj->module]) && ($modules[$obj->module]->module_position > 0)) {
        // TODO Define familyposition
        //$familyposition = $modules[$obj->module]->family_position;
        $familyposition = 0;
 
        $newmoduleposition = $modules[$obj->module]->module_position;
 
        // Correct $newmoduleposition position for external modules
        $objMod = $modules[$obj->module];
        if (is_object($objMod) && $objMod->isCoreOrExternalModule() == 'external' && $newmoduleposition < 100000) {
          $newmoduleposition += 100000;
        }
 
        $sqlupdate = 'UPDATE '.MAIN_DB_PREFIX."rights_def SET module_position = ".((int) $newmoduleposition).",";
        $sqlupdate .= " family_position = ".((int) $familyposition);
        $sqlupdate .= " WHERE module_position = ".((int) $obj->module_position)." AND module = '".$db->escape($obj->module)."'";
 
        $db->query($sqlupdate);
      }
    }
 
    // Save field family in database if value is undefined (old data/version)
    if (empty($obj->family) && !empty($objMod->family)) {
      $newfamily = $objMod->family;
      $sqlupdate = 'UPDATE '.MAIN_DB_PREFIX."rights_def SET family = '".$db->escape($newfamily)."'";
      $sqlupdate .= " WHERE id = ".((int) $obj->id);
 
      $db->query($sqlupdate);
    }
  }
} else {
  dol_print_error($db);
}
 
 
/*
 *  View
 */
 
$form = new Form($db);
 
$person_name = !empty($object->firstname) ? $object->lastname.", ".$object->firstname : $object->lastname;
$title = $person_name." - ".$langs->trans('Permissions');
$help_url = '';
llxHeader('', $title, $help_url, '', 0, 0, '', '', '', 'mod-user page-card_perms');
 
$head = user_prepare_head($object);
 
$title = $langs->trans("User");
print dol_get_fiche_head($head, 'rights', $title, -1, 'user');
 
// Read permissions of edited user
$permsuser = array();
 
$sql = "SELECT ur.fk_id";
$sql .= " FROM ".MAIN_DB_PREFIX."user_rights as ur";
$sql .= " WHERE ur.entity = ".((int) $entity);
$sql .= " AND ur.fk_user = ".((int) $object->id);
 
dol_syslog("get user perms", LOG_DEBUG);
$result = $db->query($sql);
if ($result) {
  $num = $db->num_rows($result);
  $i = 0;
  while ($i < $num) {
    $obj = $db->fetch_object($result);
    array_push($permsuser, $obj->fk_id);
    $i++;
  }
  $db->free($result);
} else {
  dol_print_error($db);
}
 
// Read the permissions of a user inherited by its groups
$permsgroupbyentity = array();
 
$sql = "SELECT DISTINCT gr.fk_id, gu.entity"; // fk_id are permission id and entity is entity of the group
$sql .= " FROM ".MAIN_DB_PREFIX."usergroup_rights as gr,";
$sql .= " ".MAIN_DB_PREFIX."usergroup_user as gu";  // all groups of a user
$sql .= " WHERE gr.entity = ".((int) $entity); // it's very important, don't change please !
// The entity on the table gu=usergroup_user should be useless and should never be used because it is already into gr and r.
// but when using MULTICOMPANY_TRANSVERSE_MODE, we may have inserted record that make rubbish result here due to the duplicate record of
// other entities, so we are forced to add a filter on gu here
if (getDolGlobalString("MULTICOMPANY_TRANSVERSE_MODE_FIX_WHEN_GU_CONTAINS_0")) {
  $sql .= " AND gu.entity IN (0,". ((int) $entity).")";
} else {
  $sql .= " AND gu.entity = ".((int) $entity);
}
$sql .= " AND gr.fk_usergroup = gu.fk_usergroup";
$sql .= " AND gu.fk_user = ".((int) $object->id);
 
dol_syslog("get user perms", LOG_DEBUG);
$result = $db->query($sql);
if ($result) {
  $num = $db->num_rows($result);
  $i = 0;
  while ($i < $num) {
    $obj = $db->fetch_object($result);
    if (!isset($permsgroupbyentity[$obj->entity])) {
      $permsgroupbyentity[$obj->entity] = array();
    }
    array_push($permsgroupbyentity[$obj->entity], $obj->fk_id);
    $i++;
  }
  $db->free($result);
} else {
  dol_print_error($db);
}
 
 
 
/*
 * Part to add/remove permissions
 */
 
$linkback = '';
 
if ($user->hasRight("user", "user", "read") || $user->admin) {
  $linkback = '<a href="'.DOL_URL_ROOT.'/user/list.php?restore_lastsearch_values=1">'.$langs->trans("BackToList").'</a>';
}
 
$morehtmlref = '<a href="'.DOL_URL_ROOT.'/user/vcard.php?id='.$object->id.'&output=file&file='.urlencode(dol_sanitizeFileName($object->getFullName($langs).'.vcf')).'" class="refid valignmiddle" rel="noopener">';
$morehtmlref .= img_picto($langs->trans("Download").' '.$langs->trans("VCard"), 'vcard', 'class="valignmiddle marginleftonly paddingrightonly"');
$morehtmlref .= '</a>';
 
$urltovirtualcard = '/user/virtualcard.php?id='.((int) $object->id);
$morehtmlref .= dolButtonToOpenUrlInDialogPopup('publicvirtualcard', $langs->transnoentitiesnoconv("PublicVirtualCardUrl").' - '.$object->getFullName($langs), img_picto($langs->trans("PublicVirtualCardUrl"), 'card', 'class="refid valignmiddle marginleftonly paddingrightonly"'), $urltovirtualcard, '', 'refid valignmiddle nohover');
 
dol_banner_tab($object, 'id', $linkback, $user->hasRight("user", "user", "read") || $user->admin, 'rowid', 'ref', $morehtmlref);
 
 
print '<div class="fichecenter">';
 
print '<div class="underbanner clearboth"></div>';
print '<table class="border centpercent tableforfield">';
 
// Login
print '<tr><td id="anchorforperms" class="titlefield">'.$langs->trans("Login").'</td>';
if (!empty($object->ldap_sid) && $object->status == 0) {
  print '<td class="error">';
  print $langs->trans("LoginAccountDisableInDolibarr");
  print '</td>';
} else {
  print '<td>';
  $addadmin = '';
  if (isModEnabled('multicompany') && !empty($object->admin) && empty($object->entity)) {
    $addadmin .= img_picto($langs->trans("SuperAdministratorDesc"), "superadmin", 'class="paddingleft valignmiddle"');
  } elseif (!empty($object->admin)) {
    $addadmin .= img_picto($langs->trans("AdministratorDesc"), "admin", 'class="paddingleft valignmiddle"');
  }
  print showValueWithClipboardCPButton($object->login).$addadmin;
  print '</td>';
}
print '</tr>'."\n";
 
// Type
print '<tr><td>';
$text = $langs->trans("Type");
print $form->textwithpicto($text, $langs->trans("InternalExternalDesc"));
print '</td><td>';
$type = $langs->trans("Internal");
if ($object->socid > 0) {
  $type = $langs->trans("External");
}
print '<span class="badgeneutral">';
print $type;
if ($object->ldap_sid) {
  print ' ('.$langs->trans("DomainUser").')';
}
print '</span>';
print '</td></tr>'."\n";
 
print '</table>';
print '</div>';
 
 
print '<br>';
 
 
if ($user->admin) {
  $s = $langs->trans("WarningOnlyPermissionOfActivatedModules")." ".$langs->trans("YouCanEnableModulesFrom");
  if (getDolGlobalString('MAIN_USE_ADVANCED_PERMS')) {
    $s .= '<br>';
    $s .= img_picto($langs->trans('InfoAdmin'), 'info-circle').' ';
    $s .= $langs->trans("YouAreUsingTheAdvancedPermissionsMode");
  } else {
    $s .= '<br>';
    $s .= img_picto($langs->trans('InfoAdmin'), 'info-circle').' ';
    $s .= $langs->trans("YouAreUsingTheSimplePermissionsMode");
  }
  print info_admin($s);
}
// If edited user is an extern user, we show warning for external users
if (!empty($object->socid)) {
  print info_admin(showModulesExludedForExternal($modules))."\n";
}
print '<br>';
 
$parameters = array('permsgroupbyentity' => $permsgroupbyentity);
$reshook = $hookmanager->executeHooks('insertExtraHeader', $parameters, $object, $action); // Note that $action and $object may have been modified by some hooks
if ($reshook < 0) {
  setEventMessages($hookmanager->error, $hookmanager->errors, 'errors');
}
 
print "\n";
print '<div class="div-table-responsive-no-min">';
print '<table class="noborder centpercent">';
 
print '<tr class="liste_titre">';
print '<td>'.$langs->trans("Module").'</td>';
if ($caneditperms) {
  print '<td class="center nowrap">';
  print '<a class="reposition commonlink addexpandedmodulesinparamlist" title="'.dol_escape_htmltag($langs->trans("All")).'" alt="'.dol_escape_htmltag($langs->trans("All")).'" href="'.dolBuildUrl($_SERVER["PHP_SELF"], ['id' => $object->id, 'action' => 'addrights', 'entity' => $entity, 'module' => 'allmodules', 'confirm' => 'yes'], true).'">'.$langs->trans("All")."</a>";
  print ' / ';
  print '<a class="reposition commonlink addexpandedmodulesinparamlist" title="'.dol_escape_htmltag($langs->trans("None")).'" alt="'.dol_escape_htmltag($langs->trans("None")).'" href="'.dolBuildUrl($_SERVER["PHP_SELF"], ['id' => $object->id, 'action' => 'delrights', 'entity' => $entity, 'module' => 'allmodules', 'confirm' => 'yes'], true).'">'.$langs->trans("None")."</a>";
  print '</td>';
} else {
  print '<td></td>';
}
print '<td></td>';
print '<td class="right nowrap" colspan="2">';
print '<a class="showallperms" title="'.dol_escape_htmltag($langs->trans("ShowAllPerms")).'" alt="'.dol_escape_htmltag($langs->trans("ShowAllPerms")).'" href="#">'.img_picto('', 'folder-open', 'class="paddingright"').'<span class="hideonsmartphone">'.$langs->trans("ExpandAll").'</span></a>';
print ' | ';
print '<a class="hideallperms" title="'.dol_escape_htmltag($langs->trans("HideAllPerms")).'" alt="'.dol_escape_htmltag($langs->trans("HideAllPerms")).'" href="#">'.img_picto('', 'folder', 'class="paddingright"').'<span class="hideonsmartphone">'.$langs->trans("UndoExpandAll").'</span></a>';
print '</td>';
print '</tr>'."\n";
 
// Get list of all permissions
$sql = "SELECT r.id, r.libelle as label, r.module, r.module_origin, r.perms, r.subperms, r.module_position, r.bydefault, r.family, r.family_position";
$sql .= " FROM ".MAIN_DB_PREFIX."rights_def as r";
$sql .= " WHERE r.libelle NOT LIKE 'tou%'";  // We ignore permission "tous les tiers". Why ?
$sql .= " AND r.entity = ".((int) $entity);
if (!getDolGlobalString('MAIN_USE_ADVANCED_PERMS')) {
  $sql .= " AND r.perms NOT LIKE '%_advance'"; // Hide advanced perms if option is not enabled
}
$sql .= " ORDER BY r.family_position, r.module_position, r.right_position, r.module, r.id";
 
$familyinfo = array(
  'hr' => array('position' => '001', 'label' => $langs->trans("ModuleFamilyHr")),
  'crm' => array('position' => '006', 'label' => $langs->trans("ModuleFamilyCrm")),
  'srm' => array('position' => '007', 'label' => $langs->trans("ModuleFamilySrm")),
  'financial' => array('position' => '009', 'label' => $langs->trans("ModuleFamilyFinancial")),
  'products' => array('position' => '012', 'label' => $langs->trans("ModuleFamilyProducts")),
  'projects' => array('position' => '015', 'label' => $langs->trans("ModuleFamilyProjects")),
  'ecm' => array('position' => '018', 'label' => $langs->trans("ModuleFamilyECM")),
  'technic' => array('position' => '021', 'label' => $langs->trans("ModuleFamilyTechnic")),
  'portal' => array('position' => '040', 'label' => $langs->trans("ModuleFamilyPortal")),
  'interface' => array('position' => '050', 'label' => $langs->trans("ModuleFamilyInterface")),
  'base' => array('position' => '060', 'label' => $langs->trans("ModuleFamilyBase")),
  'other' => array('position' => '100', 'label' => $langs->trans("ModuleFamilyOther")),
  'external' => array('position' => '500', 'label' => 'External'),
);
 
$arrayofpermission = array();
$cookietohidegroup = (empty($_COOKIE["DOLUSER_PERMS_HIDE_GRP"]) ? '' : preg_replace('/^,/', '', $_COOKIE["DOLUSER_PERMS_HIDE_GRP"]));
$cookietohidegrouparray = explode(',', $cookietohidegroup);
 
$result = $db->query($sql);
if ($result) {
  $num = $db->num_rows($result);
  $i = 0;
 
 
  while ($i < $num) {
    $obj = $db->fetch_object($result);
 
    if (empty($obj->family)) {
      $obj->family = 'other';
    }
    if (!empty($obj->family) && !isset($familyinfo[$obj->family])) {
      $obj->family = 'external';
    }
 
    // If the family does not exist in $familyinfo, use 'other'
    if (!empty($obj->family) && !isset($familyinfo[$obj->family])) {
      $obj->family = 'other';
    }
    if (empty($obj->family_position)) {
      $obj->family_position = $familyinfo[$obj->family]['position'];
      if ($obj->module_position < 100000) {
        $obj->module_position = intval($obj->module_position) + 100000;
      } else {
        $obj->module_position = intval($obj->module_position);
      }
    }
 
    $obj->position = $obj->family_position.'_'.$obj->module_position.'_'.$obj->id;
 
    $arrayofpermission[$i] = $obj;
    $i++;
  }
} else {
  dol_print_error($db);
}
 
 
$arrayofpermission = dol_sort_array($arrayofpermission, 'position');
 
$j = 0;
$oldmod = '';
 
foreach ($arrayofpermission as $i => $obj) {
  // If line is for a module that does not exist anymore (absent of includes/module), we ignore it
  if (empty($modules[$obj->module])) {
    $i++;
    continue;
  }
 
  // Special cases
  if (isModEnabled("reception")) {
    // The 2 permission in fournisseur modules has been replaced by permissions into reception module
    if ($obj->module == 'fournisseur' && $obj->perms == 'commande' && $obj->subperms == 'receptionner') {
      $i++;
      continue;
    }
    if ($obj->module == 'fournisseur' && $obj->perms == 'commande_advance' && $obj->subperms == 'check') {
      $i++;
      continue;
    }
  }
 
  $objMod = $modules[$obj->module];
 
  if (GETPOSTISSET('forbreakperms_'.$obj->module)) {
    $ishidden = GETPOSTINT('forbreakperms_'.$obj->module);
  } elseif (in_array($j, $cookietohidegrouparray)) {  // If j is among list of hidden group
    $ishidden = 1;
  } else {
    $ishidden = 0;
  }
  $isexpanded = ! $ishidden;
 
  $permsgroupbyentitypluszero = array();
  if (!empty($permsgroupbyentity[0])) {
    $permsgroupbyentitypluszero = array_merge($permsgroupbyentitypluszero, $permsgroupbyentity[0]);
  }
  if (!empty($permsgroupbyentity[$entity])) {
    $permsgroupbyentitypluszero = array_merge($permsgroupbyentitypluszero, $permsgroupbyentity[$entity]);
  }
 
  // Break found, it's a new module to catch
  if (isset($obj->module) && ($oldmod != $obj->module)) {
    $oldmod = $obj->module;
 
    $j++;
    if (GETPOSTISSET('forbreakperms_'.$obj->module)) {
      $ishidden = GETPOSTINT('forbreakperms_'.$obj->module);
    } elseif (in_array($j, $cookietohidegrouparray)) {  // If j is among list of hidden group
      $ishidden = 1;
    } else {
      $ishidden = 0;
    }
    $isexpanded = ! $ishidden;
 
    // Break detected, we get objMod
    $objMod = $modules[$obj->module];
    $picto = ($objMod->picto ? $objMod->picto : 'generic');
 
    // Show break line
    print '<tr class="oddeven trforbreakperms trforbreaknobg" data-hide-perms="'.$obj->module.'" data-j="'.$j.'">';
    // Picto and label of module
    print '<td class="maxwidthonsmartphone tdoverflowmax200 tdforbreakperms" data-hide-perms="'.dol_escape_htmltag($obj->module).'" title="'.dol_escape_htmltag($objMod->getName()).'">';
    print '<input type="hidden" name="forbreakperms_'.$obj->module.'" id="idforbreakperms_'.$obj->module.'" css="cssforfieldishiden" data-j="'.$j.'" value="'.($isexpanded ? '0' : "1").'">';
    print img_object('', $picto, 'class="pictoobjectwidth paddingright"').' '.$objMod->getName();
    print '<a name="'.$objMod->getName().'"></a>';
    print '</td>';
 
    // Permission and tick (2 columns)
    if (($caneditperms && empty($objMod->rights_admin_allowed)) || empty($object->admin)) {
      if ($caneditperms) {
        print '<td class="tdforbreakperms tdforbreakpermsifnotempty center width50 nowraponall" data-hide-perms="'.dol_escape_htmltag($obj->module).'">';
        print '<span class="permtohide_'.dol_escape_htmltag($obj->module).'" '.(!$isexpanded ? ' style="display:none"' : '').'>';
        print '<a class="reposition alink addexpandedmodulesinparamlist" title="'.dol_escape_htmltag($langs->trans("All")).'" alt="'.dol_escape_htmltag($langs->trans("All")).'" href="'.dolBuildUrl($_SERVER["PHP_SELF"], ['id' => $object->id, 'action' => 'addrights', 'entity' => $entity, 'module' => $obj->module, 'confirm' => 'yes', 'updatedmodulename' => $obj->module], true).'">'.$langs->trans("All")."</a>";
        print ' / ';
        print '<a class="reposition alink addexpandedmodulesinparamlist" title="'.dol_escape_htmltag($langs->trans("None")).'" alt="'.dol_escape_htmltag($langs->trans("None")).'" href="'.dolBuildUrl($_SERVER["PHP_SELF"], ['id' => $object->id, 'action' => 'delrights', 'entity' => $entity, 'module' => $obj->module, 'confirm' => 'yes', 'updatedmodulename' => $obj->module], true).'">'.$langs->trans("None")."</a>";
        print '</span>';
        print '</td>';
        print '<td class="tdforbreakperms" data-hide-perms="'.dol_escape_htmltag($obj->module).'">';
        print '</td>';
      } else {
        print '<td class="tdforbreakperms" data-hide-perms="'.dol_escape_htmltag($obj->module).'"></td>';
        print '<td class="tdforbreakperms" data-hide-perms="'.dol_escape_htmltag($obj->module).'"></td>';
      }
    } else {
      if ($caneditperms) {
        print '<td class="tdforbreakperms center wraponsmartphone" data-hide-perms="'.dol_escape_htmltag($obj->module).'">';
        /*print '<a class="reposition alink" title="'.dol_escape_htmltag($langs->trans("All")).'" alt="'.dol_escape_htmltag($langs->trans("All")).'" href="'.$_SERVER["PHP_SELF"].'?id='.$object->id.'&action=addrights&token='.newToken().'&entity='.$entity.'&module='.$obj->module.'&confirm=yes&updatedmodulename='.$obj->module.'">'.$langs->trans("All")."</a>";
        print ' / ';
        print '<a class="reposition alink" title="'.dol_escape_htmltag($langs->trans("None")).'" alt="'.dol_escape_htmltag($langs->trans("None")).'" href="'.$_SERVER["PHP_SELF"].'?id='.$object->id.'&action=delrights&token='.newToken().'&entity='.$entity.'&module='.$obj->module.'&confirm=yes&updatedmodulename='.$obj->module.'">'.$langs->trans("None")."</a>";
        */
        print '</td>';
        print '<td class="tdforbreakperms" data-hide-perms="'.dol_escape_htmltag($obj->module).'">';
        print '</td>';
      } else {
        print '<td class="right tdforbreakperms" data-hide-perms="'.dol_escape_htmltag($obj->module).'"></td>';
        print '<td class="tdforbreakperms" data-hide-perms="'.dol_escape_htmltag($obj->module).'"></td>';
      }
    }
 
    // Description of permission (2 columns)
    print '<td class="tdforbreakperms" data-hide-perms="'.dol_escape_htmltag($obj->module).'"></td>';
    print '<td class="maxwidthonsmartphone right tdforbreakperms" data-hide-perms="'.dol_escape_htmltag($obj->module).'">';
 
    print '<div class="switchfolderperms inline-block marginrightonly folderperms_'.dol_escape_htmltag($obj->module).'"'.($isexpanded ? ' style="display:none;"' : '').'>';
    print img_picto('', 'folder', 'class="marginright"');
    print '</div>';
    print '<div class="switchfolderperms inline-block marginrightonly folderopenperms_'.dol_escape_htmltag($obj->module).'"'.(!$isexpanded ? ' style="display:none;"' : '').'>';
    print img_picto('', 'folder-open', 'class="marginright"');
    print '</div>';
 
    print '</td>'; //Add picto + / - when open en closed
    print '</tr>'."\n";
  }
 
  $permlabel = (getDolGlobalString('MAIN_USE_ADVANCED_PERMS') && ($langs->trans("PermissionAdvanced".$obj->id) != "PermissionAdvanced".$obj->id) ? $langs->trans("PermissionAdvanced".$obj->id) : (($langs->trans("Permission".$obj->id) != "Permission".$obj->id) ? $langs->trans("Permission".$obj->id) : $langs->trans($obj->label)));
 
  // This right is declared by another module (module_origin) but filed into this module's
  // section for display (KEY_MODULE): show a small badge so it is not mistaken for a native
  // right of this module.
  if (!empty($obj->module_origin) && $obj->module_origin != $obj->module && !empty($modules[$obj->module_origin])) {
    $permoriginmod = $modules[$obj->module_origin];
    $permoriginpicto = ($permoriginmod->picto ? $permoriginmod->picto : 'generic');
    $permlabel = img_picto($langs->trans("RightProvidedByModule", $permoriginmod->getName()), $permoriginpicto, 'class="paddingrightonly"').$permlabel;
  }
 
  print '<!-- '.$obj->module.'->'.$obj->perms.($obj->subperms ? '->'.$obj->subperms : '').' -->'."\n";
  print '<tr class="oddeven trtohide_'.$obj->module.'"'.(!$isexpanded ? ' style="display:none"' : '').'>';
 
  // Picto and label of module
  print '<td class="maxwidthonsmartphone">';
  print '</td>';
 
  // Permission and tick (2 columns)
  if (!empty($object->admin) && !empty($objMod->rights_admin_allowed)) {    // Permission granted because admin
    print '<!-- perm is a perm allowed to any admin -->';
    if ($caneditperms) {
      print '<td class="center nowrap">';
      print img_picto($langs->trans("AdministratorDesc"), 'admin', 'class="paddingleft valignmiddle"');
      print '</td>';
    } else {
      print '<td class="center nowrap">';
      print img_picto($langs->trans("Active"), 'switch_on', '', 0, 0, 0, '', 'opacitymedium');
      print '</td>';
    }
    print '<td>';
    print '</td>';
  } elseif (in_array($obj->id, $permsuser)) {         // Permission granted by user
    print '<!-- user has perm -->';
    if ($caneditperms) {
      print '<td class="center nowrap">';
      print '<a class="reposition addexpandedmodulesinparamlist" id="'.$obj->id.'" href="'.dolBuildUrl($_SERVER["PHP_SELF"], ['id' => $object->id, 'action' => 'delrights', 'entity' => $entity, 'rights' => $obj->id, 'confirm' => 'yes', 'updatedmodulename' => $obj->module], true).'">';
      //print img_edit_remove($langs->trans("Remove"));
      print img_picto($langs->trans("Remove"), 'switch_on');
      print '</a>';
      print '</td>';
    } else {
      print '<td class="center nowrap">';
      print img_picto($langs->trans("Active"), 'switch_on', '', 0, 0, 0, '', 'opacitymedium');
      print '</td>';
    }
    print '<td>';
    print '</td>';
  } elseif (isset($permsgroupbyentitypluszero) && is_array($permsgroupbyentitypluszero)) {
    print '<!-- permsgroupbyentitypluszero -->';
    if (in_array($obj->id, $permsgroupbyentitypluszero)) {  // Permission granted by group
      print '<td class="center nowrap">';
      print img_picto($langs->trans("Active"), 'switch_on', '', 0, 0, 0, '', 'opacitymedium');
      //print img_picto($langs->trans("Active"), 'tick');
      print '</td>';
      print '<td class="center nowrap">';
      print $form->textwithtooltip($langs->trans("Inherited"), $langs->trans("PermissionInheritedFromAGroup"));
      print '</td>';
    } else {
      // Do not own permission
      if ($caneditperms) {
        print '<td class="center nowrap">';
        print '<a class="reposition addexpandedmodulesinparamlist" id="'.$obj->id.'" href="'.dolBuildUrl($_SERVER["PHP_SELF"], ['id' => $object->id, 'action' => 'addrights', 'entity' => $entity, 'rights' => $obj->id, 'confirm' => 'yes', 'updatedmodulename' => $obj->module], true).'">';
        //print img_edit_add($langs->trans("Add"));
        print img_picto($langs->trans("Add"), 'switch_off');
        print '</a>';
        print '</td>';
      } else {
        print '<td class="center nowrap">';
        print img_picto($langs->trans("Disabled"), 'switch_off', '', 0, 0, 0, '', 'opacitymedium');
        print '</td>';
      }
      print '<td>';
      print '</td>';
    }
  } else {
    // Do not own permission
    print '<!-- do not own permission -->';
    if ($caneditperms) {
      print '<td class="center nowrap">';
      print '<a class="reposition addexpandedmodulesinparamlist" id="'.$obj->id.'" href="'.dolBuildUrl($_SERVER["PHP_SELF"], ['id' => $object->id, 'action' => 'addrights', 'entity' => $entity, 'rights' => $obj->id, 'confirm' => 'yes', 'updatedmodulename' => $obj->module], true).'">';
      //print img_edit_add($langs->trans("Add"));
      print img_picto($langs->trans("Add"), 'switch_off');
      print '</a>';
      print '</td>';
    } else {
      print '<td class="center nowrap">';
      print img_picto($langs->trans("Disabled"), 'switch_off', '', 0, 0, 0, '', 'opacitymedium');
      print '</td>';
    }
    print '<td>';
    print '</td>';
  }
 
  // Description of permission (1 or 2 columns)
  if (!$user->admin) {
    print '<td colspan="2">';
  } else {
    print '<td>';
  }
 
  print $permlabel;
  $idtouse = $obj->id;
  if (in_array($idtouse, array(121, 122, 125, 126))) {  // Force message for the 3 permission on third parties
    $idtouse = 122;
  }
  if ($langs->trans("Permission".$idtouse.'b') != "Permission".$idtouse.'b') {
    print '<br><span class="opacitymedium">'.$langs->trans("Permission".$idtouse.'b').'</span>';
  }
  if ($langs->trans("Permission".$obj->id.'c') != "Permission".$obj->id.'c') {
    print '<br><span class="opacitymedium">'.$langs->trans("Permission".$obj->id.'c').'</span>';
  }
  if (getDolGlobalString('MAIN_USE_ADVANCED_PERMS')) {
    if (preg_match('/_advance$/', $obj->perms)) {
      print ' <span class="opacitymedium">('.$langs->trans("AdvancedModeOnly").')</span>';
    }
  }
    // Special warning case for the permission "Allow to modify other users password"
  if ($obj->module == 'user' && $obj->perms == 'user' && $obj->subperms == 'password') {
    if ((!empty($object->admin) && !empty($objMod->rights_admin_allowed)) ||
      in_array($obj->id, $permsuser) /* if edited user owns this permissions */ ||
      (isset($permsgroupbyentitypluszero) && is_array($permsgroupbyentitypluszero) && in_array($obj->id, $permsgroupbyentitypluszero))) {
      print ' '.img_warning($langs->trans("AllowPasswordResetBySendingANewPassByEmail"));
    }
  }
    // Special warning case for the permission "Create/modify other users, groups and permissions"
  if ($obj->module == 'user' && $obj->perms == 'user' && ($obj->subperms == 'creer' || $obj->subperms == 'create')) {
    if ((!empty($object->admin) && !empty($objMod->rights_admin_allowed)) ||
      in_array($obj->id, $permsuser) /* if edited user owns this permissions */ ||
      (isset($permsgroupbyentitypluszero) && is_array($permsgroupbyentitypluszero) && in_array($obj->id, $permsgroupbyentitypluszero))) {
      print ' '.img_warning($langs->trans("AllowAnyPrivileges"));
    }
  }
    // Special case for reading bank account when you have permission to manage Chart of account
  if ($obj->module == 'banque' && $obj->perms == 'lire') {
    if (isModEnabled("accounting") && $object->hasRight('accounting', 'chartofaccount')) {
      print ' '.img_warning($langs->trans("WarningReadBankAlsoAllowedIfUserHasPermission"));
    }
  }
 
  print '</td>';
 
  // Permission id
  if ($user->admin) {
    print '<td class="right">';
    $htmltext = $langs->trans("ID").': '.$obj->id;
    // hasRight() is actually checked against module_origin when set (right filed into
    // another module's section via KEY_MODULE but still checked under the module that
    // declared it), not the display module column, see User::loadRights().
    $htmltextmodule = (!empty($obj->module_origin) ? $obj->module_origin : $obj->module);
    $htmltext .= '<br>'.$langs->trans("Permission").': user->hasRight(\''.dol_escape_htmltag($htmltextmodule).'\', \''.dol_escape_htmltag($obj->perms).'\''.($obj->subperms ? ', \''.dol_escape_htmltag($obj->subperms).'\'' : '').')';
    print $form->textwithpicto('', $htmltext, 1, 'help', 'inline-block marginrightonly');
    //print '<span class="opacitymedium">'.$obj->id.'</span>';
    print '</td>';
  }
 
  print '</tr>'."\n";
 
  $i++;
}
print '</table>';
print '</div>';
 
print '<script>';
print '$(".tdforbreakperms:not(.alink)").on("click", function(){
  console.log("Click on tdforbreakperms");
  moduletohide = $(this).data("hide-perms");
  j = $(this).data("j");
  if ($("#idforbreakperms_"+moduletohide).val() == 1) {
    console.log("idforbreakperms_"+moduletohide+" has value hidden=1, so we show all lines");
    $(".trtohide_"+moduletohide).show();
    $(".permtoshow_"+moduletohide).hide();
    $(".permtohide_"+moduletohide).show();
    $(".folderperms_"+moduletohide).hide();
    $(".folderopenperms_"+moduletohide).show();
    $("#idforbreakperms_"+moduletohide).val("0");
  } else if (! $(this).hasClass("tdforbreakpermsifnotempty")) {
    console.log("idforbreakperms_"+moduletohide+" has value hidden=0, so we hide all lines");
    $(".trtohide_"+moduletohide).hide();
    $(".folderopenperms_"+moduletohide).hide();
    $(".folderperms_"+moduletohide).show();
    $(".permtoshow_"+moduletohide).show();
    $(".permtohide_"+moduletohide).hide();
    $("#idforbreakperms_"+moduletohide).val("1");
  }
 
  // Now rebuild the value for cookie
  var hideuserperm="";
  $(".trforbreakperms").each(function(index) {
    //console.log( index + ": " + $( this ).data("j") + " " + $( this ).data("hide-perms") + " " + $("input[data-j="+(index+1)+"]").val());
    if ($("input[data-j="+(index+1)+"]").val() == 1) {
      hideuserperm=hideuserperm+","+(index+1);
    }
  });
  // set cookie by js
  date = new Date(); date.setTime(date.getTime()+(30*86400000));
  if (hideuserperm) {
    console.log("set cookie DOLUSER_PERMS_HIDE_GRP="+hideuserperm);
    document.cookie = "DOLUSER_PERMS_HIDE_GRP=" + hideuserperm + "; expires=" + date.toGMTString() + "; path=/ ";
  } else {
    console.log("delete cookie DOLUSER_PERMS_HIDE_GRP");
    document.cookie = "DOLUSER_PERMS_HIDE_GRP=; expires=Thu, 01-Jan-70 00:00:01 GMT; path=/ ";
  }
});';
print "\n";
 
// Button expand / collapse all
print '$(".showallperms").on("click", function(){
  console.log("Click on showallperms");
 
  console.log("delete cookie DOLUSER_PERMS_HIDE_GRP from showallperms click");
  document.cookie = "DOLUSER_PERMS_HIDE_GRP=; expires=Thu, 01-Jan-70 00:00:01 GMT; path=/ ";
  $(".tdforbreakperms").each( function(){
    moduletohide = $(this).data("hide-perms");
    //console.log(moduletohide);
    if ($("#idforbreakperms_"+moduletohide).val() != 0) {
      $(this).trigger("click"); // emulate the click, so the cooki will be resaved
    }
  })
});
 
$(".hideallperms").on("click", function(){
  console.log("Click on hideallperms");
 
  $(".tdforbreakperms").each( function(){
    moduletohide = $(this).data("hide-perms");
    //console.log(moduletohide);
    if ($("#idforbreakperms_"+moduletohide).val() != 1) {
      $(this).trigger("click"); // emulate the click, so the cooki will be resaved
    }
  })
});';
print "\n";
print '</script>';
 
print '<style>';
print '.switchfolderperms{
  cursor: pointer;
}';
print '</style>';
 
$parameters = array();
$reshook = $hookmanager->executeHooks('insertExtraFooter', $parameters, $object, $action); // Note that $action and $object may have been modified by some hooks
if ($reshook < 0) {
  setEventMessages($hookmanager->error, $hookmanager->errors, 'errors');
}
 
 
print dol_get_fiche_end();
 
// End of page
llxFooter();
$db->close();