RyXéo » GLPI

<?php

/*

 * @version $Id: entity.function.php 7763 2009-01-06 18:44:50Z moyo $

 -------------------------------------------------------------------------

 GLPI - Gestionnaire Libre de Parc Informatique

 Copyright (C) 2003-2009 by the INDEPNET Development Team.

 http://indepnet.net/   http://glpi-project.org

 -------------------------------------------------------------------------

 LICENSE

 This file is part of GLPI.

 GLPI 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 2 of the License, or

 (at your option) any later version.

 GLPI 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 GLPI; if not, write to the Free Software

 Foundation, Inc., 59 Temple Place, Suite 330, Boston, MA  02111-1307  USA

 --------------------------------------------------------------------------

 */

// ----------------------------------------------------------------------

// Original Author of file: Julien Dombre

// Purpose of file:

// ----------------------------------------------------------------------

if (!defined('GLPI_ROOT')){

        die("Sorry. You can't access directly to this file");

        }

/**

 * Show users of an entity

 *

 * @param $target string : where to go on action

 * @param $ID integer : enterprise ID

 */

function showEntityUser($target,$ID){

        global $DB,$CFG_GLPI, $LANG;

        if (!haveRight("entity","r")||!haveRight("user","r"))        return false;

        $canedit=haveRight("entity","w");

        $canshowuser=haveRight("user","r");

        $nb_per_line=3;

        if ($canedit) $headerspan=$nb_per_line*2;

        else $headerspan=$nb_per_line;

        echo "<form name='entityuser_form' id='entityuser_form' method='post' action=\"$target\">";

        $entity=new Entity();

        if ($entity->getFromDB($ID)||$ID==0){

                if ($canedit){

                        echo "<div class='center'>";

                        echo "<table  class='tab_cadre_fixe'>";

                        echo "<tr class='tab_bg_1'><th colspan='5'>".$LANG["setup"][603]."</tr><tr><td class='tab_bg_2' align='center'>";

                        echo "<input type='hidden' name='FK_entities' value='$ID'>";

                        dropdownAllUsers("FK_users",0,1);

                        echo "</td><td align='center' class='tab_bg_2'>";

                        echo $LANG["profiles"][22].":";

                        dropdownUnderProfiles("FK_profiles");

                        echo "</td><td align='center' class='tab_bg_2'>";

                        echo $LANG["profiles"][28].":";

                        dropdownYesNo("recursive",0);

                        echo "</td><td align='center' class='tab_bg_2'>";

                        echo "<input type='submit' name='adduser' value=\"".$LANG["buttons"][8]."\" class='submit'>";

                        echo "</td></tr>";

                        echo "</table></div><br>";

                }

                echo "<div class='center'><table class='tab_cadrehov'><tr><th colspan='$headerspan'>".$LANG["Menu"][14]." (D=".$LANG["profiles"][29].", R=".$LANG["profiles"][28].")</th></tr>";

                $query="SELECT DISTINCT glpi_profiles.ID, glpi_profiles.name 

                                FROM glpi_users_profiles 

                                LEFT JOIN glpi_profiles ON (glpi_users_profiles.FK_profiles = glpi_profiles.ID)

                                LEFT JOIN glpi_users ON (glpi_users.ID = glpi_users_profiles.FK_users)

                                WHERE glpi_users_profiles.FK_entities='$ID' AND glpi_users.deleted=0;";

                $result=$DB->query($query);

                if ($DB->numrows($result)>0){

                        while ($data=$DB->fetch_array($result)){

                                echo "<tr><th colspan='$headerspan'>".$data["name"]."</th></tr>";

                                $query="SELECT glpi_users.*,glpi_users_profiles.ID as linkID,glpi_users_profiles.recursive,glpi_users_profiles.dynamic

                                        FROM glpi_users_profiles 

                                        LEFT JOIN glpi_users ON (glpi_users.ID = glpi_users_profiles.FK_users) 

                                        WHERE glpi_users_profiles.FK_entities='$ID' AND glpi_users.deleted=0 AND glpi_users_profiles.FK_profiles='".$data['ID']."'   

                                        ORDER BY glpi_users_profiles.FK_profiles, glpi_users.name, glpi_users.realname, glpi_users.firstname";

                                $result2=$DB->query($query);

                                if ($DB->numrows($result2)>0){

                                        $i=0;

                                        while ($data2=$DB->fetch_array($result2)){

                                                if ($i%$nb_per_line==0) {

                                                        if ($i!=0) echo "</tr>";

                                                        echo "<tr class='tab_bg_1'>";

                                                }

                                                if ($canedit){

                                                        echo "<td width='10'>";

                                                        $sel="";

                                                        if (isset($_GET["select"])&&$_GET["select"]=="all") $sel="checked";

                                                        echo "<input type='checkbox' name='item[".$data2["linkID"]."]' value='1' $sel>";

                                                        echo "</td>";

                                                }

                                                echo "<td>";

                                                echo formatUserName($data2["ID"],$data2["name"],$data2["realname"],$data2["firstname"],$canshowuser);

                                                if ($data2["dynamic"]||$data2["recursive"]){

                                                        echo "<strong>&nbsp;(";

                                                        if ($data2["dynamic"]) echo "D";

                                                        if ($data2["dynamic"]&&$data2["recursive"]) echo ", ";

                                                        if ($data2["recursive"]) echo "R";

                                                        echo ")</strong>";

                                                }

                                                echo "</td>";

                                                $i++;

                                        }

                                        while ($i%$nb_per_line!=0){

                                                echo "<td>&nbsp;</td>";

                                                if ($canedit) echo "<td>&nbsp;</td>";

                                                $i++;

                                        }

                                        echo "</tr>";

                                } else {

                                        echo "<tr colspan='$headerspan'>".$LANG["common"][54]."</tr>";

                                }

                        }

                }

                echo "</table></div>";

                if ($canedit){

                        echo "<div class='center'>";

                        echo "<table width='80%'>";

                        echo "<tr><td><img src=\"".$CFG_GLPI["root_doc"]."/pics/arrow-left.png\" alt=''></td><td class='center'><a onclick= \"if ( markAllRows('entityuser_form') ) return false;\" href='".$_SERVER['PHP_SELF']."?ID=$ID&amp;select=all'>".$LANG["buttons"][18]."</a></td>";

                        echo "<td>/</td><td class='center'><a onclick= \"if ( unMarkAllRows('entityuser_form') ) return false;\" href='".$_SERVER['PHP_SELF']."?ID=$ID&amp;select=none'>".$LANG["buttons"][19]."</a>";

                        echo "</td><td align='left' width='80%'>";

                        echo "<input type='submit' name='deleteuser' value=\"".$LANG["buttons"][6]."\" class='submit'>";

                        echo "</td>";

                        echo "</table>";

                        echo "</div>";

                }

                echo "</form>";

        }

}

/**

 * Add a right to a user 

 *

 * @param $input array : parameters : need FK_entities / FK_users / FK_profiles optional : recurisve=0 / dynamic=0

 * @return new glpi_users_profiles ID

 */

function addUserProfileEntity($input){

        global $DB;

        if (!isset($input['FK_entities'])||$input['FK_entities']<0

                ||!isset($input['FK_users'])||$input['FK_users']==0

                ||!isset($input['FK_profiles'])||$input['FK_profiles']==0) {

                return false;

        }

        if (!isset($input['recursive'])){

                $input['recursive']=0;

        }

        if (!isset($input['dynamic'])){

                $input['dynamic']=0;

        }

        $user=new User();

        $user->cleanCache($input['FK_users']);

        $query="INSERT INTO `glpi_users_profiles` ( `FK_users` , `FK_profiles` , `FK_entities` , `recursive` , `dynamic` )

                VALUES ('".$input['FK_users']."', '".$input['FK_profiles']."', '".$input['FK_entities']."', '".$input['recursive']."', '".$input['dynamic']."');";

        return $DB->query($query);

}

/**

 * Delete a right to a user 

 *

 * @param $ID integer : glpi_users_profiles ID

 */

function deleteUserProfileEntity($ID){

        global $DB;

        $query="SELECT FK_users FROM glpi_users_profiles WHERE ID= '$ID';";

        $result = $DB->query($query);

        $data=$DB->fetch_assoc($result);

        $user=new User();

        $user->cleanCache($data['FK_users']);

        $query="DELETE FROM glpi_users_profiles WHERE ID= '$ID';";

        $result = $DB->query($query);

}

/**

 * Move a right to another entity

 *

 * @param $ID integer : glpi_users_profiles ID

 * @param $FK_entities integer : new entity ID

 */

function moveUserProfileEntity($ID,$FK_entities){

        global $DB;

        $query="UPDATE glpi_users_profiles SET FK_entities='$FK_entities' WHERE ID= '$ID';";

        return $DB->query($query);

}

?>