alxarafe / alixar

public/htdocs/user/hierarchy.php

<?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       Rafael San José             <rsanjose@alxarafe.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/>.
 */

use Dolibarr\Code\Core\Classes\Form;
use Dolibarr\Code\User\Classes\User;
use Dolibarr\Lib\ViewMain;

/**
 *      \file       htdocs/user/hierarchy.php
 *      \ingroup    user
 *      \brief      Page of hierarchy view of user module
 */

// Load Dolibarr environment
require constant('DOL_DOCUMENT_ROOT') . '/main.inc.php';
require_once constant('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
$canadduser = (!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');

ViewMain::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) {

The expression $fulltree of type integer is not traversable.

        $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', constant('BASE_URL') . '/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', constant('BASE_URL') . '/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', constant('BASE_URL') . '/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', constant('BASE_URL') . '/user/card.php?action=create' . ($mode == 'employee' ? '&employee=1' : '') . '&leftmenu=', '', $canadduser);

    $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
ViewMain::llxFooter();
$db->close();