Role.class.php

Go to the documentation of this file.

<?php
include_once("core/system/JBaseObject.class.php");
include_once("core/db/dbjames.class.php");
include_once("core/system/JSystemError.class.php");
include_once("core/system/JUgrSystem.class.php");

class Role extends JBaseObject
{
        var $data;      
        var $perms;     


        function Role ($idR)
        {
                $dbObj = new DBJames();

                $query = "SELECT * FROM Roles ";
                $query .= "WHERE idR = " . $idR;
    
                $dbObj->Query($query);
                        
                if ($dbObj->numRows == 1)
                {
                        $this->data = $dbObj->row;
                        $this->perms =& $this->_GetAllPermissions();
                }
                else
                {
                        $this->data = null;
                        $this->RaiseConstructorError(new JSystemError(ERROR_ROLE_NOT_FOUND));
                }
        }
        
        
        function &_GetAllPermissions()
        {
                $dbObj = new DBJames();
                
                $query =  " SELECT Permissions.* ";
                $query .= " FROM Permissions, RelRolesPermissions";
                $query .= " WHERE RelRolesPermissions.idR = ".$this->GetId();
                $query .= " AND Permissions.idP = RelRolesPermissions.idP";
                $query .= " ORDER BY Permissions.idM";
                
                $dbObj->Query($query);
        
                $result = array();
                
                while (! $dbObj->EOF)
                {
                        $result[$dbObj->row["idM"]][$dbObj->row["name"]] = true;
                        $dbObj->Next();
                }
                
                return $result;
        }
        
        
        function _NumUsers($idR)
        {
                $dbObj = new DBJames();
                
                $query  = " SELECT DISTINCT RelUsersGroups.idU ";
                $query .= " FROM RelUsersGroups ";
                $query .= " WHERE idR = ". $idR;
                
                $dbObj->Query($query);
                
                return $dbObj->numRows;
        }

        function GetId()
        {
                return $this->data["idR"];
        }
        
        function GetName()
        {
                return $this->data["name"];
        }
        
        function SetName($name)
        {
                $this->data["name"] = $name;
        }
        
        function Commit()
        {
                $dbObj = new DBJames();
                
                $query  = " UPDATE Roles SET ";
                $query .= " name = '".$this->GetName()."'";
                $query .= " WHERE idR = ".$this->GetId();
                
                $dbObj->Execute($query);
        }       

        function GetPermissions($idM)
        {
                if($this->data == null)
                {
                        return JSystem::RaiseError(
                                                new JSystemError(ERROR_NOT_INITIALIZED));
                }
                
                return $this->perms[$idM];
        }
        
        
        function HasPermission($name, $idM)
        {
                if($this->data == null)
                {
                        return JSystem::RaiseError(
                                                new JSystemError(ERROR_NOT_INITIALIZED));
                }
                
                return $this->perms[$idM][$name];
        }               


        function AddPermission($name, $idM)
        {
                $modulesobj =& Modules::GetInstance();
                
                $mod =&  $modulesobj->GetModule($idM);
                if (JSystem::IsError($mod))
                        return $mod;
                else
                {
                        $this->perms =& $this->_GetAllPermissions();
                        if (! $this->perms[$idM][$name])
                        {                       
                                // First, we need the id of the permission
                                $module =& $modulesobj->GetModule($idM);                        
                                $idP = $module->GetPermissionId($name);
                                
                                // Then, we store it in RelRolesPermissions
                                $dbObj = new DBJames(); 
                                $query  = "INSERT INTO RelRolesPermissions ";
                                $query .= " (idP, idR) VALUES ";
                                $query .= " (".$idP.", ".$this->GetId().") ";                           
                                $dbObj->Execute($query);
                                $this->perms[$idM][$name] = true;
                        }
                }
        }
        
        
        function RemovePermission($name, $idM)
        {
                $modulesobj =& Modules::GetInstance();
                
                $module =& $modulesobj->GetModule($idM);
                
                if (JSystem::IsError($module))
                        return $module;
                else
                {
                        $this->perms =& $this->_GetAllPermissions();
                        if ($this->perms[$idM][$name])
                        {                       
                                // We get the id of the permission
                                $idP = $module->GetPermissionId($name);
                                
                                // Finally, we remove it from this role         
                                $dbObj = new DBJames();         
                                $query  = " DELETE FROM RelRolesPermissions ";
                                $query .= " WHERE idP = ".$idP;
                                $query .= " AND idR = ".$this->GetId();         
                                $dbObj->Execute($query);
                                $this->perms[$idM][$name] = false;
                        }
                }
        }
        
        
        function &Create($name)
        {
                $dbObj = new DBJames();
                
                $query  = " INSERT INTO Roles ";
                $query .= " (name) VALUES ";
                $query .= " ('".$name."') ";
                
                $dbObj->Execute($query);
                
                $dbObj->SetInsertId();
                
                $role =& new Role($dbObj->newID);
                if (JSystem::IsError($role))
                        return JSystem::GetLastError();
                else
                        return $role;
        }
        
        
        function Remove($idR)
        {
                $ugrsystem =& JugrSystem::GetInstance();
                
                if (JSystem::IsError($ugrsystem->GetRole($idR)))
                {
                        return JSystem::RaiseError(
                                                new JSystemError(ERROR_ROLE_NOT_FOUND));
                }
                else if (Role::_NumUsers($idR) > 0)
                {
                        return JSystem::RaiseError(
                                                new JSystemError(ERROR_STILL_USERS_WITH_ROLE));
                }
                else
                {
                        $dbObj = new DBJames();
                        
                        // First we remove all permissions from this role.
                        $query  = " DELETE FROM RelRolesPermissions ";
                        $query .= " WHERE idR=".$idR;
                        $dbObj->Execute($query);
                        
                        // Then, we remove the role.
                        $query  = " DELETE FROM Roles ";
                        $query .= " WHERE idR = ". $idR;
                        $dbObj->Execute($query);
                }
        }
        
        function GetAllRolesId()
        {
                $dbObj = new DBJames();         
                $query  = " SELECT * FROM Roles ";
                $dbObj->Query($query);
                
                return $dbObj;
        }                               
}
?>

---