class ilRbacReview Contains Review functions of core Rbac. More...

Collaboration diagram for ilRbacReview:

Public Member Functions
	__construct ()
	Constructor @access public. More...

	roleExists (string $a_title, int $a_id=0)
	Checks if a role already exists. More...

	getParentRoleIds (int $a_endnode_id, bool $a_templates=false)
	Get an array of parent role ids of all parent roles, if last parameter is set true you get also all parent templates. More...

	getRoleListByObject (int $a_ref_id, bool $a_templates=false)
	Returns a list of roles in an container. More...

	getAssignableRoles (bool $a_templates=false, bool $a_internal_roles=false, string $title_filter='')
	Returns a list of all assignable roles. More...

	getAssignableRolesInSubtree (int $ref_id)
	Returns a list of assignable roles in a subtree of the repository. More...

	getAssignableChildRoles (int $a_ref_id)
	Get all assignable roles directly under a specific node. More...

	getNumberOfAssignedUsers (array $a_roles)
	Get the number of assigned users to roles (not properly deleted user accounts are not counted) More...

	assignedUsers (int $a_rol_id)
	get all assigned users to a given role @access public More...

	isAssigned (int $a_usr_id, int $a_role_id)
	check if a specific user is assigned to specific role More...

	isAssignedToAtLeastOneGivenRole (int $a_usr_id, array $a_role_ids)
	check if a specific user is assigned to at least one of the given role ids. More...

	assignedRoles (int $a_usr_id)
	get all assigned roles to a given user More...

	assignedGlobalRoles (int $a_usr_id)
	Get assigned global roles for an user. More...

	isAssignable (int $a_rol_id, int $a_ref_id)
	Check if its possible to assign users. More...

	hasMultipleAssignments (int $a_role_id)

	getFoldersAssignedToRole (int $a_rol_id, bool $a_assignable=false)
	Returns an array of objects assigned to a role. More...

	getRolesOfObject (int $a_ref_id, bool $a_assignable_only=false)
	Get roles of object. More...

	getRolesOfRoleFolder (int $a_ref_id, bool $a_nonassignable=true)
	get all roles of a role folder including linked local roles that are created due to stopped inheritance returns an array with role ids @access public More...

	getGlobalRoles ()
	get only 'global' roles More...

	getLocalRoles (int $a_ref_id)
	Get local roles of object. More...

	getLocalPolicies (int $a_ref_id)
	Get all roles with local policies. More...

	getGlobalRolesArray ()
	get only 'global' roles More...

	getGlobalAssignableRoles ()
	get only 'global' roles (with flag 'assign_users') More...

	isRoleAssignedToObject (int $a_role_id, int $a_parent_id)
	Check if role is assigned to an object. More...

	getOperations ()
	get all possible operations More...

	getOperation (int $ops_id)
	get one operation by operation id More...

	getAllOperationsOfRole (int $a_rol_id, int $a_parent=0)
	get all possible operations of a specific role The ref_id of the role folder (parent object) is necessary to distinguish local roles More...

	getActiveOperationsOfRole (int $a_ref_id, int $a_role_id)
	Get active operations for a role. More...

	getOperationsOfRole (int $a_rol_id, string $a_type, int $a_parent=0)
	get all possible operations of a specific role The ref_id of the role folder (parent object) is necessary to distinguish local roles More...

	getRoleOperationsOnObject (int $a_role_id, int $a_ref_id)

	getOperationsOnType (int $a_typ_id)
	all possible operations of a type More...

	getOperationsOnTypeString (string $a_type)
	all possible operations of a type More...

	getOperationsByTypeAndClass (string $a_type, string $a_class)
	Get operations by type and class. More...

	getObjectsWithStopedInheritance (int $a_rol_id, array $a_filter=[])
	get all objects in which the inheritance of role with role_id was stopped the function returns all reference ids of objects containing a role folder. More...

	isDeleted (int $a_node_id)
	Checks if a rolefolder is set as deleted (negative tree_id) More...

	isGlobalRole (int $a_role_id)
	Check if role is a global role. More...

	getRolesByFilter (int $a_filter=0, int $a_user_id=0, string $title_filter='')

	getTypeId (string $a_type)

	isProtected (int $a_ref_id, int $a_role_id)
	ref_id not used yet. More...

	isBlockedAtPosition (int $a_role_id, int $a_ref_id)

	isBlockedInUpperContext (int $a_role_id, int $a_ref_id)
	Check if role is blocked in upper context. More...

	getObjectOfRole (int $a_role_id)
	Get object id of objects a role is assigned to. More...

	getObjectReferenceOfRole (int $a_role_id)

	isRoleDeleted (int $a_role_id)
	return if role is only attached to deleted role folders More...

	getRolesForIDs (array $role_ids, bool $use_templates)

	getOperationAssignment ()
	get operation assignments More...

	isDeleteable (int $a_role_id, int $a_rolf_id)
	Check if role is deleteable at a specific position. More...

	isSystemGeneratedRole (int $a_role_id)
	Check if the role is system generate role or role template. More...

	getRoleFolderOfRole (int $a_role_id)

	getUserPermissionsOnObject (int $a_user_id, int $a_ref_id)
	Get all user permissions on an object. More...

	setAssignedCacheEntry (int $a_role_id, int $a_user_id, bool $a_value)
	set entry of assigned_chache More...

	getAssignedCacheEntry (int $a_role_id, int $a_user_id)

	clearCaches ()
	Clear assigned users caches. More...

Static Public Member Functions
static	_getOperationIdsByName (array $operations)
	get ops_id's by name. More...

static	_getOperationIdByName (string $a_operation)
	get operation id by name of operation More...

static	lookupCreateOperationIds (array $a_type_arr)
	Lookup operation ids. More...

static	_getOperationList (string $a_type='')
	get operation list by object type More...

static	_groupOperationsByClass (array $a_ops_arr)

static	_getCustomRBACOperationId (string $operation, \ilDBInterface $ilDB=null)

static	_isRBACOperation (int $type_id, int $ops_id, \ilDBInterface $ilDB=null)

Data Fields
const	FILTER_ALL = 1

const	FILTER_ALL_GLOBAL = 2

const	FILTER_ALL_LOCAL = 3

const	FILTER_INTERNAL = 4

const	FILTER_NOT_INTERNAL = 5

const	FILTER_TEMPLATES = 6

Protected Member Functions
	__getParentRoles (array $a_path, bool $a_templates)
	Note: This function performs faster than the new getParentRoles function, because it uses database indexes whereas getParentRoles needs a full table space scan. More...

	__setTemplateFilter (bool $a_templates)
	get roles and templates or only roles; returns string for where clause More...

	__setRoleType (array $a_role_list)
	computes role type in role list array: global: roles in ROLE_FOLDER_ID local: assignable roles in other role folders linked: roles with stoppped inheritance template: role templates More...

	__setProtectedStatus (array $a_parent_roles, array $a_role_hierarchy, int $a_ref_id)

Protected Attributes
ilLogger	$log

ilDBInterface	$db

Static Protected Attributes
static array	$assigned_users_cache = []

static array	$is_assigned_cache = []

Private Member Functions
	getAssignableRolesGenerator (bool $a_templates=false, bool $a_internal_roles=false, string $title_filter='')

	setRoleTypeAndProtection (array $role_list_entry)

	buildRoleType (array $role_list_entry)

	buildProtectionByStringValue (string $value)

Static Private Attributes
static array	$_opsCache = null

Detailed Description

class ilRbacReview Contains Review functions of core Rbac.

This class offers the possibility to view the contents of the user <-> role (UR) relation and the permission <-> role (PR) relation. For example, from the UA relation the administrator should have the facility to view all user assigned to a given role.

Author: Stefan Meyer meyer.nosp@m.@lei.nosp@m.fos.c.nosp@m.om; Sascha Hofmann sasch.nosp@m.ahof.nosp@m.mann@.nosp@m.gmx..nosp@m.de

Version: $Id$

@phpstan-type RoleListEntry array{obj_id: int, rol_id: int, parent: int, user_id: int, owner: int, title: ?string, desc: string, description: string, create_date: ?string, last_update: ?string, import_id: ?string, tile_image_rid: ?string, role_type: string, offline: ?int, type: string, assign: string, protected: bool, blocked: int, rol_id: int}

Definition at line 33 of file class.ilRbacReview.php.

Constructor & Destructor Documentation

◆ __construct()

ilRbacReview::__construct ( )

Constructor @access public.

Definition at line 55 of file class.ilRbacReview.php.

    {
        global $DIC;
 
        $this->log = ilLoggerFactory::getLogger('ac');
        $this->db = $DIC->database();
    }

References $DIC, and ilLoggerFactory\getLogger().

Here is the call graph for this function:

Member Function Documentation

◆ __getParentRoles()

ilRbacReview::__getParentRoles	(	array	$a_path,
		bool	$a_templates
	)

protected

Note: This function performs faster than the new getParentRoles function, because it uses database indexes whereas getParentRoles needs a full table space scan.

Get parent roles in a path. If last parameter is set 'true' it delivers also all templates in the path

Parameters

array	array with path_ids
bool	true for role templates (default: false)

Returns: array array with all parent roles (obj_ids)

Definition at line 95 of file class.ilRbacReview.php.

                                                                         : array
    {
        $parent_roles = [];
        $role_hierarchy = [];
        foreach ($a_path as $ref_id) {
            $roles = $this->getRoleListByObject($ref_id, $a_templates);
            foreach ($roles as $role) {
                $id = (int) $role["obj_id"];
                $role["parent"] = (int) $ref_id;
                $parent_roles[$id] = $role;
 
                if (!array_key_exists($role['obj_id'], $role_hierarchy)) {
                    $role_hierarchy[$id] = $ref_id;
                }
            }
        }
        return $this->__setProtectedStatus($parent_roles, $role_hierarchy, (int) reset($a_path));
    }

References $id, $ref_id, __setProtectedStatus(), getRoleListByObject(), and ILIAS\Repository\int().

Referenced by getParentRoleIds().

Here is the call graph for this function:

Here is the caller graph for this function:

◆ __setProtectedStatus()

ilRbacReview::__setProtectedStatus	(	array	$a_parent_roles,
		array	$a_role_hierarchy,
		int	$a_ref_id
	)

protected

Definition at line 1088 of file class.ilRbacReview.php.

                                                                                                          : array
    {
        global $DIC;
 
        $rbacsystem = $DIC->rbac()->system();
        $ilUser = $DIC->user();
        if (in_array(SYSTEM_ROLE_ID, $this->assignedRoles($ilUser->getId()))) {
            $leveladmin = true;
        } else {
            $leveladmin = false;
        }
        foreach ($a_role_hierarchy as $role_id => $rolf_id) {
            if ($leveladmin == true) {
                $a_parent_roles[$role_id]['protected'] = false;
                continue;
            }
 
            if ($a_parent_roles[$role_id]['protected'] == true) {
                $arr_lvl_roles_user = array_intersect(
                    $this->assignedRoles($ilUser->getId()),
                    array_keys($a_role_hierarchy, $rolf_id)
                );
 
                foreach ($arr_lvl_roles_user as $lvl_role_id) {
                    // check if role grants 'edit_permission' to parent
                    $rolf = $a_parent_roles[$role_id]['parent'];
                    if ($rbacsystem->checkPermission($rolf, $lvl_role_id, 'edit_permission')) {
                        $a_parent_roles[$role_id]['protected'] = false;
                    }
                }
            }
        }
        return $a_parent_roles;
    }

References $DIC, $ilUser, and SYSTEM_ROLE_ID.

Referenced by __getParentRoles().

Here is the caller graph for this function:

◆ __setRoleType()

ilRbacReview::__setRoleType ( array $a_role_list )

protected

computes role type in role list array: global: roles in ROLE_FOLDER_ID local: assignable roles in other role folders linked: roles with stoppped inheritance template: role templates

Definition at line 284 of file class.ilRbacReview.php.

                                                        : array
    {
        foreach ($a_role_list as $key => $val) {
            $a_role_list[$key] = $this->setRoleTypeAndProtection($val);
        }
        return $a_role_list;
    }

References ILIAS\LTI\ToolProvider\$key.

Referenced by getRoleListByObject().

Here is the caller graph for this function:

◆ __setTemplateFilter()

ilRbacReview::__setTemplateFilter ( bool $a_templates )

protected

get roles and templates or only roles; returns string for where clause

Definition at line 267 of file class.ilRbacReview.php.

                                                             : string
    {
        if ($a_templates) {
            $where = "WHERE " . $this->db->in('object_data.type', array('role', 'rolt'), false, 'text') . " ";
        } else {
            $where = "WHERE " . $this->db->in('object_data.type', array('role'), false, 'text') . " ";
        }
        return $where;
    }

Referenced by getRoleListByObject().

Here is the caller graph for this function:

◆ _getCustomRBACOperationId()

static ilRbacReview::_getCustomRBACOperationId	(	string	$operation,
		\ilDBInterface	$ilDB = `null`
	)

static

Definition at line 1395 of file class.ilRbacReview.php.

                                                                                                    : ?int
    {
        if (!$ilDB) {
            global $DIC;
            $ilDB = $DIC->database();
        }
 
        $sql =
            "SELECT ops_id" . PHP_EOL
            . "FROM rbac_operations" . PHP_EOL
            . "WHERE operation = " . $ilDB->quote($operation, "text") . PHP_EOL
        ;
 
        $res = $ilDB->query($sql);
        if ($ilDB->numRows($res) == 0) {
            return null;
        }
 
        $row = $ilDB->fetchAssoc($res);
        return (int) $row["ops_id"] ?? null;
    }

References $DIC, $ilDB, and $res.

Referenced by ilAccessCustomRBACOperationAddedObjective\achieve(), ilAccessInitialPermissionGuidelineAppliedObjective\achieve(), ilAccessRbacStandardOperationsAddedObjective\achieve(), ilAccessRolePermissionSetObjective\achieve(), ilDBUpdateNewObjectType\addCustomRBACOperation(), ilDBUpdateNewObjectType\addRBACOperations(), ilAccessCustomRBACOperationAddedObjective\isApplicable(), ilAccessInitialPermissionGuidelineAppliedObjective\isApplicable(), ilAccessRbacStandardOperationsAddedObjective\isApplicable(), and ilDBUpdateNewObjectType\setRolePermission().

Here is the caller graph for this function:

◆ _getOperationIdByName()

static ilRbacReview::_getOperationIdByName ( string $a_operation )

static

get operation id by name of operation

Definition at line 968 of file class.ilRbacReview.php.

                                                                     : int
    {
        global $DIC;
 
        $ilDB = $DIC->database();
 
        // Cache operation ids
        if (!is_array(self::$_opsCache)) {
            self::$_opsCache = [];
 
            $q = "SELECT ops_id, operation FROM rbac_operations";
            $r = $ilDB->query($q);
            while ($row = $r->fetchRow(ilDBConstants::FETCHMODE_OBJECT)) {
                self::$_opsCache[$row->operation] = (int) $row->ops_id;
            }
        }
 
        // Get operation ID by name from cache
        if (array_key_exists($a_operation, self::$_opsCache)) {
            return self::$_opsCache[$a_operation];
        }
        return 0;
    }

References $DIC, $ilDB, ilDBConstants\FETCHMODE_OBJECT, and ILIAS\Repository\int().

Referenced by ilRepositoryObjectPlugin\beforeActivation(), ilRbacSystem\checkAccessOfUser(), and ilObjBlog\getRolesWithContributeOrRedact().

Here is the call graph for this function:

Here is the caller graph for this function:

◆ _getOperationIdsByName()

static ilRbacReview::_getOperationIdsByName ( array $operations )

static

get ops_id's by name.

Example usage: $rbacadmin->grantPermission($roles,ilRbacReview::_getOperationIdsByName(array('visible','read'),$ref_id));

Definition at line 945 of file class.ilRbacReview.php.

                                                                    : array
    {
        global $DIC;
 
        $ilDB = $DIC->database();
        if ($operations === []) {
            return [];
        }
 
        $query = 'SELECT ops_id FROM rbac_operations ' .
            'WHERE ' . $ilDB->in('operation', $operations, false, 'text');
 
        $res = $ilDB->query($query);
        $ops_ids = [];
        while ($row = $ilDB->fetchObject($res)) {
            $ops_ids[] = (int) $row->ops_id;
        }
        return $ops_ids;
    }

References $DIC, $ilDB, $query, $res, and ILIAS\Repository\int().

Referenced by ilLTIProviderObjectSettingGUI\checkLocalRole(), and ilECSObjectSettings\handlePermissionUpdate().

Here is the call graph for this function:

Here is the caller graph for this function:

◆ _getOperationList()

static ilRbacReview::_getOperationList ( string $a_type = '' )

static

get operation list by object type

Definition at line 1126 of file class.ilRbacReview.php.

                                                                 : array
    {
        global $DIC;
 
        $ilDB = $DIC->database();
        $arr = [];
        if ($a_type) {
            $query = sprintf(
                'SELECT * FROM rbac_operations ' .
                'JOIN rbac_ta ON rbac_operations.ops_id = rbac_ta.ops_id ' .
                'JOIN object_data ON rbac_ta.typ_id = object_data.obj_id ' .
                'WHERE object_data.title = %s ' .
                'AND object_data.type = %s ' .
                'ORDER BY op_order ASC',
                $ilDB->quote($a_type, 'text'),
                $ilDB->quote('typ', 'text')
            );
        } else {
            $query = 'SELECT * FROM rbac_operations ORDER BY op_order ASC';
        }
        $res = $ilDB->query($query);
        while ($row = $ilDB->fetchAssoc($res)) {
            $arr[] = array(
                "ops_id" => (int) $row['ops_id'],
                "operation" => $row['operation'],
                "desc" => $row['description'],
                "class" => $row['class'],
                "order" => (int) $row['op_order']
            );
        }
        return $arr;
    }

References $DIC, $ilDB, $query, and $res.

Referenced by ilSettingsPermissionGUI\__construct(), ilObjTypeDefinitionGUI\editObject(), ilObjectPermissionStatusGUI\getAccessPermissionTableData(), ilObjectPermissionStatusGUI\getAssignedValidRoles(), and ilObjTypeDefinitionGUI\viewObject().

Here is the caller graph for this function:

◆ _groupOperationsByClass()

static ilRbacReview::_groupOperationsByClass ( array $a_ops_arr )

static

Definition at line 1159 of file class.ilRbacReview.php.

                                                                    : array
    {
        $arr = [];
        foreach ($a_ops_arr as $ops) {
            $arr[$ops['class']][] = array('ops_id' => (int) $ops['ops_id'],
                                          'name' => $ops['operation']
            );
        }
        return $arr;
    }

◆ _isRBACOperation()

static ilRbacReview::_isRBACOperation	(	int	$type_id,
		int	$ops_id,
		\ilDBInterface	$ilDB = `null`
	)

static

Definition at line 1417 of file class.ilRbacReview.php.

                                                                                                   : bool
    {
        if (!$ilDB) {
            global $DIC;
            $ilDB = $DIC->database();
        }
 
        $sql =
            "SELECT typ_id" . PHP_EOL
            . "FROM rbac_ta" . PHP_EOL
            . "WHERE typ_id = " . $ilDB->quote($type_id, "integer") . PHP_EOL
            . "AND ops_id = " . $ilDB->quote($ops_id, "integer") . PHP_EOL
        ;
 
        return (bool) $ilDB->numRows($ilDB->query($sql));
    }

References $DIC, and $ilDB.

Referenced by ilAccessRbacStandardOperationsAddedObjective\achieve(), ilTreeAdminNodeAddedObjective\achieve(), and ilAccessRbacStandardOperationsAddedObjective\isApplicable().

Here is the caller graph for this function:

◆ assignedGlobalRoles()

ilRbacReview::assignedGlobalRoles ( int $a_usr_id )

Get assigned global roles for an user.

Definition at line 427 of file class.ilRbacReview.php.

                                                      : array
    {
        $query = "SELECT ua.rol_id FROM rbac_ua ua " .
            "JOIN rbac_fa fa ON ua.rol_id = fa.rol_id " .
            "WHERE usr_id = " . $this->db->quote($a_usr_id, 'integer') . ' ' .
            "AND parent = " . $this->db->quote(ROLE_FOLDER_ID, ilDBConstants::T_INTEGER) . " " .
            "AND assign = 'y' ";
 
        $res = $this->db->query($query);
        $role_arr = [];
        while ($row = $this->db->fetchObject($res)) {
            $role_arr[] = $row->rol_id;
        }
        return $role_arr !== [] ? $role_arr : [];
    }

References $query, $res, ROLE_FOLDER_ID, and ilDBConstants\T_INTEGER.

◆ assignedRoles()

ilRbacReview::assignedRoles ( int $a_usr_id )

get all assigned roles to a given user

Parameters

int usr_id

Returns: int[] all roles (id) the user is assigned to

Definition at line 412 of file class.ilRbacReview.php.

                                                : array
    {
        $query = "SELECT rol_id FROM rbac_ua WHERE usr_id = " . $this->db->quote($a_usr_id, 'integer');
 
        $res = $this->db->query($query);
        $role_arr = [];
        while ($row = $this->db->fetchObject($res)) {
            $role_arr[] = (int) $row->rol_id;
        }
        return $role_arr;
    }

References $query, $res, and ILIAS\Repository\int().

Referenced by ilObjCategoryGUI\assignRolesObject(), ilObjCategoryGUI\assignSaveObject(), ilObjCategoryGUI\checkGlobalRoles(), ilObjCategoryGUI\getAssignableRoles(), ilCalendarShared\getSharedCalendarsForUser(), ilCalendarShared\isSharedWithUser(), and ilObjCategoryGUI\listUsersObject().

Here is the call graph for this function:

Here is the caller graph for this function:

◆ assignedUsers()

ilRbacReview::assignedUsers ( int $a_rol_id )

get all assigned users to a given role @access public

Parameters

int role_id

Returns: array all users (id) assigned to role

Definition at line 349 of file class.ilRbacReview.php.

                                                : array
    {
        if (isset(self::$assigned_users_cache[$a_rol_id])) {
            return self::$assigned_users_cache[$a_rol_id];
        }
 
        $result_arr = [];
        $query = "SELECT usr_id FROM rbac_ua WHERE rol_id= " . $this->db->quote($a_rol_id, 'integer');
        $res = $this->db->query($query);
        while ($row = $this->db->fetchAssoc($res)) {
            $result_arr[] = (int) $row["usr_id"];
        }
        self::$assigned_users_cache[$a_rol_id] = $result_arr;
        return $result_arr;
    }

References $query, $res, and ILIAS\Repository\int().

Referenced by ilContributorTableGUI\getItems().

Here is the call graph for this function:

Here is the caller graph for this function:

◆ buildProtectionByStringValue()

ilRbacReview::buildProtectionByStringValue ( string $value )

private

Definition at line 316 of file class.ilRbacReview.php.

                                                                : bool
    {
        if ($value === 'y') {
            return true;
        }
        return false;
    }

◆ buildRoleType()

ilRbacReview::buildRoleType ( array $role_list_entry )

private

Definition at line 299 of file class.ilRbacReview.php.

                                                          : string
    {
        if ($role_list_entry['type'] === 'rolt') {
            return 'template';
        }
 
        if ($role_list_entry['assign'] !== 'y') {
            return 'linked';
        }
 
        if ($role_list_entry['parent'] === ROLE_FOLDER_ID) {
            return 'global';
        }
 
        return 'local';
    }

References ROLE_FOLDER_ID.

◆ clearCaches()

ilRbacReview::clearCaches ( )

Clear assigned users caches.

Definition at line 1389 of file class.ilRbacReview.php.

                                 : void
    {
        self::$is_assigned_cache = [];
        self::$assigned_users_cache = [];
    }

◆ getActiveOperationsOfRole()

ilRbacReview::getActiveOperationsOfRole	(	int	$a_ref_id,
		int	$a_role_id
	)

Get active operations for a role.

Definition at line 687 of file class.ilRbacReview.php.

                                                                            : array
    {
        $query = 'SELECT * FROM rbac_pa ' .
            'WHERE ref_id = ' . $this->db->quote($a_ref_id, 'integer') . ' ' .
            'AND rol_id = ' . $this->db->quote($a_role_id, 'integer') . ' ';
 
        $res = $this->db->query($query);
        while ($row = $res->fetchRow(ilDBConstants::FETCHMODE_ASSOC)) {
            return unserialize($row['ops_id']);
        }
        return [];
    }

References $query, $res, and ilDBConstants\FETCHMODE_ASSOC.

◆ getAllOperationsOfRole()

ilRbacReview::getAllOperationsOfRole	(	int	$a_rol_id,
		int	$a_parent = `0`
	)

get all possible operations of a specific role The ref_id of the role folder (parent object) is necessary to distinguish local roles

Definition at line 667 of file class.ilRbacReview.php.

                                                                            : array
    {
        if (!$a_parent) {
            $a_parent = ROLE_FOLDER_ID;
        }
        $query = "SELECT ops_id,type FROM rbac_templates " .
            "WHERE rol_id = " . $this->db->quote($a_rol_id, 'integer') . " " .
            "AND parent = " . $this->db->quote($a_parent, 'integer');
        $res = $this->db->query($query);
 
        $ops_arr = [];
        while ($row = $this->db->fetchObject($res)) {
            $ops_arr[$row->type][] = (int) $row->ops_id;
        }
        return $ops_arr;
    }

References $query, $res, ILIAS\Repository\int(), and ROLE_FOLDER_ID.

Here is the call graph for this function:

◆ getAssignableChildRoles()

ilRbacReview::getAssignableChildRoles ( int $a_ref_id )

Get all assignable roles directly under a specific node.

Definition at line 244 of file class.ilRbacReview.php.

                                                          : array
    {
        $query = "SELECT fa.*, rd.* " .
            "FROM object_data rd " .
            "JOIN rbac_fa fa ON rd.obj_id = fa.rol_id " .
            "WHERE fa.assign = 'y' " .
            "AND fa.parent = " . $this->db->quote($a_ref_id, 'integer') . " ";
 
        $res = $this->db->query($query);
        $roles_data = [];
        while ($row = $this->db->fetchAssoc($res)) {
            $row['rol_id'] = (int) $row['rol_id'];
            $row['obj_id'] = (int) $row['obj_id'];
 
            $roles_data[] = $row;
        }
 
        return $roles_data;
    }

References $query, $res, and ILIAS\Repository\int().

Referenced by ilObjCategoryGUI\getAssignableRoles().

Here is the call graph for this function:

Here is the caller graph for this function:

◆ getAssignableRoles()

ilRbacReview::getAssignableRoles	(	bool	$a_templates = `false`,
		bool	$a_internal_roles = `false`,
		string	$title_filter = `''`
	)

Returns a list of all assignable roles.

Returns: list<RoleListEntry>

Definition at line 167 of file class.ilRbacReview.php.

     : array {
        return iterator_to_array(
            $this->getAssignableRolesGenerator(
                $a_templates,
                $a_internal_roles,
                $title_filter
            )
        );
    }

◆ getAssignableRolesGenerator()

ilRbacReview::getAssignableRolesGenerator	(	bool	$a_templates = `false`,
		bool	$a_internal_roles = `false`,
		string	$title_filter = `''`
	)

private

Returns: Generator<RoleListEntry>

Definition at line 184 of file class.ilRbacReview.php.

     : Generator {
        $where = $this->__setTemplateFilter($a_templates);
        $query = "SELECT * FROM object_data " .
            "JOIN rbac_fa ON obj_id = rol_id " .
            $where .
            "AND rbac_fa.assign = 'y' ";
 
        if (strlen($title_filter)) {
            $query .= (' AND ' . $this->db->like(
                'title',
                'text',
                $title_filter . '%'
            ));
        }
        $res = $this->db->query($query);
 
        while ($row = $this->db->fetchAssoc($res)) {
            $row["description"] = (string) $row["description"];
            $row["desc"] = $row["description"];
            $row["user_id"] = (int) $row["owner"];
            $row['obj_id'] = (int) $row['obj_id'];
            $row['parent'] = (int) $row['parent'];
            yield $this->setRoleTypeAndProtection($row);
        }
    }

References $query.

◆ getAssignableRolesInSubtree()

ilRbacReview::getAssignableRolesInSubtree ( int $ref_id )

Returns a list of assignable roles in a subtree of the repository.

Todo:: move tree to construct. Currently this is not possible due to init sequence

Definition at line 218 of file class.ilRbacReview.php.

                                                            : array
    {
        global $DIC;
 
        $tree = $DIC->repositoryTree();
        $query = 'SELECT rol_id FROM rbac_fa fa ' .
            'JOIN tree t1 ON t1.child = fa.parent ' .
            'JOIN object_data obd ON fa.rol_id = obd.obj_id ' .
            'WHERE assign = ' . $this->db->quote('y', 'text') . ' ' .
            'AND obd.type = ' . $this->db->quote('role', 'text') . ' ' .
            'AND t1.child IN (' .
            $tree->getSubTreeQuery($ref_id, array('child')) . ' ' .
            ') ';
 
        $res = $this->db->query($query);
 
        $role_list = [];
        while ($row = $res->fetchRow(ilDBConstants::FETCHMODE_OBJECT)) {
            $role_list[] = (int) $row->rol_id;
        }
        return $role_list;
    }

References $DIC, $query, $ref_id, $res, ilDBConstants\FETCHMODE_OBJECT, and ILIAS\Repository\int().

Here is the call graph for this function:

◆ getAssignedCacheEntry()

ilRbacReview::getAssignedCacheEntry	(	int	$a_role_id,
		int	$a_user_id
	)

Definition at line 1381 of file class.ilRbacReview.php.

                                                                         : bool
    {
        return self::$is_assigned_cache[$a_role_id][$a_user_id];
    }

◆ getFoldersAssignedToRole()

ilRbacReview::getFoldersAssignedToRole	(	int	$a_rol_id,
		bool	$a_assignable = `false`
	)

Returns an array of objects assigned to a role.

A role with stopped inheritance may be assigned to more than one objects. To get only the original location of a role, set the second parameter to true @access public

Parameters

int	role id
bool	get only rolefolders where role is assignable (true)

Returns: int[] reference IDs of role folders

Definition at line 480 of file class.ilRbacReview.php.

                                                                                       : array
    {
        $where = '';
        if ($a_assignable) {
            $where = " AND assign ='y'";
        }
 
        $query = "SELECT DISTINCT parent FROM rbac_fa " .
            "WHERE rol_id = " . $this->db->quote($a_rol_id, 'integer') . " " . $where . " ";
 
        $res = $this->db->query($query);
        $folders = [];
        while ($row = $this->db->fetchObject($res)) {
            $folders[] = (int) $row->parent;
        }
        return $folders;
    }

References $query, $res, and ILIAS\Repository\int().

Here is the call graph for this function:

◆ getGlobalAssignableRoles()

ilRbacReview::getGlobalAssignableRoles ( )

get only 'global' roles (with flag 'assign_users')

Definition at line 604 of file class.ilRbacReview.php.

                                              : array
    {
        $ga = [];
        foreach ($this->getGlobalRoles() as $role_id) {
            if (ilObjRole::_getAssignUsersStatus($role_id)) {
                $ga[] = array('obj_id' => $role_id,
                              'role_type' => 'global'
                );
            }
        }
        return $ga;
    }

References ilObjRole\_getAssignUsersStatus().

Referenced by ilObjCategoryGUI\checkGlobalRoles(), ilObjCategoryGUI\getAssignableRoles(), and ilObjCategoryGUI\listUsersObject().

Here is the call graph for this function:

Here is the caller graph for this function:

◆ getGlobalRoles()

ilRbacReview::getGlobalRoles ( )

get only 'global' roles

Returns: int[] Array with rol_ids

Todo:: refactor rolf => DONE

Definition at line 555 of file class.ilRbacReview.php.

                                    : array
    {
        return $this->getRolesOfRoleFolder(ROLE_FOLDER_ID, false);
    }

References ROLE_FOLDER_ID.

Referenced by ilObjCategoryGUI\checkGlobalRoles().

Here is the caller graph for this function:

◆ getGlobalRolesArray()

ilRbacReview::getGlobalRolesArray ( )

get only 'global' roles

Definition at line 590 of file class.ilRbacReview.php.

                                         : array
    {
        $ga = [];
        foreach ($this->getRolesOfRoleFolder(ROLE_FOLDER_ID, false) as $role_id) {
            $ga[] = array('obj_id' => $role_id,
                          'role_type' => 'global'
            );
        }
        return $ga;
    }

References ROLE_FOLDER_ID.

Referenced by ilObjCategoryGUI\checkGlobalRoles(), and ilObjCategoryGUI\getAssignableRoles().

Here is the caller graph for this function:

◆ getLocalPolicies()

ilRbacReview::getLocalPolicies ( int $a_ref_id )

Get all roles with local policies.

Returns: int[]

Definition at line 578 of file class.ilRbacReview.php.

                                                   : array
    {
        $lroles = [];
        foreach ($this->getRolesOfRoleFolder($a_ref_id) as $role_id) {
            $lroles[] = $role_id;
        }
        return $lroles;
    }

◆ getLocalRoles()

ilRbacReview::getLocalRoles ( int $a_ref_id )

Get local roles of object.

Definition at line 563 of file class.ilRbacReview.php.

                                                : array
    {
        $lroles = [];
        foreach ($this->getRolesOfRoleFolder($a_ref_id) as $role_id) {
            if ($this->isAssignable($role_id, $a_ref_id)) {
                $lroles[] = $role_id;
            }
        }
        return $lroles;
    }

Referenced by ilOrgUnitStaffGUI\getOtherRolesTableHTML().

Here is the caller graph for this function:

◆ getNumberOfAssignedUsers()

ilRbacReview::getNumberOfAssignedUsers ( array $a_roles )

Get the number of assigned users to roles (not properly deleted user accounts are not counted)

Parameters

int[] $a_roles

Definition at line 328 of file class.ilRbacReview.php.

                                                            : int
    {
        $query = 'select count(distinct(ua.usr_id)) as num from rbac_ua ua ' .
            'join object_data on ua.usr_id = obj_id ' .
            'join usr_data ud on ua.usr_id = ud.usr_id ' .
            'where ' . $this->db->in('rol_id', $a_roles, false, 'integer');
 
        $res = $this->db->query($query);
        if ($res->numRows() > 0) {
            $row = $res->fetchRow(\ilDBConstants::FETCHMODE_OBJECT);
            return isset($row->num) && is_numeric($row->num) ? (int) $row->num : 0;
        }
        return 0;
    }

References $query, $res, ilDBConstants\FETCHMODE_OBJECT, and ILIAS\Repository\int().

Here is the call graph for this function:

◆ getObjectOfRole()

ilRbacReview::getObjectOfRole ( int $a_role_id )

Get object id of objects a role is assigned to.

Todo:: refactor rolf (due to performance reasons the new version does not check for deleted roles only in object reference)

Definition at line 1174 of file class.ilRbacReview.php.

                                                   : int
    {
        // internal cache
        static $obj_cache = [];
 
        if (isset($obj_cache[$a_role_id]) && $obj_cache[$a_role_id]) {
            return $obj_cache[$a_role_id];
        }
 
        $query = 'SELECT obr.obj_id FROM rbac_fa rfa ' .
            'JOIN object_reference obr ON rfa.parent = obr.ref_id ' .
            'WHERE assign = ' . $this->db->quote('y', 'text') . ' ' .
            'AND rol_id = ' . $this->db->quote($a_role_id, 'integer') . ' ' .
            'AND deleted IS NULL';
 
        $res = $this->db->query($query);
        $obj_cache[$a_role_id] = 0;
        while ($row = $this->db->fetchObject($res)) {
            $obj_cache[$a_role_id] = (int) $row->obj_id;
        }
        return $obj_cache[$a_role_id];
    }

References $query, $res, and ILIAS\Repository\int().

Here is the call graph for this function:

◆ getObjectReferenceOfRole()

ilRbacReview::getObjectReferenceOfRole ( int $a_role_id )

Definition at line 1197 of file class.ilRbacReview.php.

                                                            : int
    {
        $query = 'SELECT parent p_ref FROM rbac_fa ' .
            'WHERE rol_id = ' . $this->db->quote($a_role_id, 'integer') . ' ' .
            'AND assign = ' . $this->db->quote('y', 'text');
 
        $res = $this->db->query($query);
        while ($row = $res->fetchRow(ilDBConstants::FETCHMODE_OBJECT)) {
            return (int) $row->p_ref;
        }
        return 0;
    }

References $query, $res, and ilDBConstants\FETCHMODE_OBJECT.

Referenced by ILIAS\Skill\Profile\SkillProfileRoleDBRepository\getAssignedRoles().

Here is the caller graph for this function:

◆ getObjectsWithStopedInheritance()

ilRbacReview::getObjectsWithStopedInheritance	(	int	$a_rol_id,
		array	$a_filter = `[]`
	)

get all objects in which the inheritance of role with role_id was stopped the function returns all reference ids of objects containing a role folder.

Definition at line 798 of file class.ilRbacReview.php.

                                                                                        : array
    {
        $query = 'SELECT parent p FROM rbac_fa ' .
            'WHERE assign = ' . $this->db->quote('n', 'text') . ' ' .
            'AND rol_id = ' . $this->db->quote($a_rol_id, 'integer') . ' ';
 
        if ($a_filter !== []) {
            $query .= ('AND ' . $this->db->in('parent', (array) $a_filter, false, 'integer'));
        }
 
        $res = $this->db->query($query);
        $parent = [];
        while ($row = $res->fetchRow(ilDBConstants::FETCHMODE_OBJECT)) {
            $parent[] = (int) $row->p;
        }
        return $parent;
    }

References $query, $res, ilDBConstants\FETCHMODE_OBJECT, and ILIAS\Repository\int().

Here is the call graph for this function:

◆ getOperation()

ilRbacReview::getOperation ( int $ops_id )

get one operation by operation id

Definition at line 649 of file class.ilRbacReview.php.

                                             : array
    {
        $query = 'SELECT * FROM rbac_operations WHERE ops_id = ' . $this->db->quote($ops_id, 'integer');
        $res = $this->db->query($query);
        $ops = [];
        while ($row = $this->db->fetchObject($res)) {
            $ops = array('ops_id' => (int) $row->ops_id,
                         'operation' => $row->operation,
                         'description' => $row->description
            );
        }
        return $ops;
    }

References $query, and $res.

◆ getOperationAssignment()

ilRbacReview::getOperationAssignment ( )

get operation assignments

Returns: array array(array('typ_id' => $typ_id,'title' => $title,'ops_id => '$ops_is,'operation' => $operation),...

Definition at line 1252 of file class.ilRbacReview.php.

                                            : array
    {
        global $DIC;
 
        $this->db = $DIC['ilDB'];
 
        $query = 'SELECT ta.typ_id, obj.title, ops.ops_id, ops.operation FROM rbac_ta ta ' .
            'JOIN object_data obj ON obj.obj_id = ta.typ_id ' .
            'JOIN rbac_operations ops ON ops.ops_id = ta.ops_id ';
        $res = $this->db->query($query);
 
        $counter = 0;
        $info = [];
        while ($row = $this->db->fetchObject($res)) {
            $info[$counter]['typ_id'] = (int) $row->typ_id;
            $info[$counter]['type'] = $row->title;
            $info[$counter]['ops_id'] = (int) $row->ops_id;
            $info[$counter]['operation'] = $row->operation;
            $counter++;
        }
        return $info;
    }

References $DIC, $query, $res, and ILIAS\Repository\int().

Here is the call graph for this function:

◆ getOperations()

ilRbacReview::getOperations ( )

get all possible operations

Definition at line 632 of file class.ilRbacReview.php.

                                   : array
    {
        $query = 'SELECT * FROM rbac_operations ORDER BY ops_id ';
        $res = $this->db->query($query);
        $ops = [];
        while ($row = $this->db->fetchObject($res)) {
            $ops[] = array('ops_id' => (int) $row->ops_id,
                           'operation' => $row->operation,
                           'description' => $row->description
            );
        }
        return $ops;
    }

References $query, and $res.

◆ getOperationsByTypeAndClass()

ilRbacReview::getOperationsByTypeAndClass	(	string	$a_type,
		string	$a_class
	)

Get operations by type and class.

Definition at line 770 of file class.ilRbacReview.php.

                                                                                : array
    {
        if ($a_class != 'create') {
            $condition = "AND class != " . $this->db->quote('create', 'text');
        } else {
            $condition = "AND class = " . $this->db->quote('create', 'text');
        }
 
        $query = "SELECT ro.ops_id FROM rbac_operations ro " .
            "JOIN rbac_ta rt ON  ro.ops_id = rt.ops_id " .
            "JOIN object_data od ON rt.typ_id = od.obj_id " .
            "WHERE type = " . $this->db->quote('typ', 'text') . " " .
            "AND title = " . $this->db->quote($a_type, 'text') . " " .
            $condition . " " .
            "ORDER BY op_order ";
 
        $res = $this->db->query($query);
        $ops = [];
        while ($row = $res->fetchRow(ilDBConstants::FETCHMODE_OBJECT)) {
            $ops[] = (int) $row->ops_id;
        }
        return $ops;
    }

References $query, $res, ilDBConstants\FETCHMODE_OBJECT, and ILIAS\Repository\int().

Referenced by ilPermissionGUI\savePermissions().

Here is the call graph for this function:

Here is the caller graph for this function:

◆ getOperationsOfRole()

ilRbacReview::getOperationsOfRole	(	int	$a_rol_id,
		string	$a_type,
		int	$a_parent = `0`
	)

get all possible operations of a specific role The ref_id of the role folder (parent object) is necessary to distinguish local roles

Definition at line 704 of file class.ilRbacReview.php.

                                                                                         : array
    {
        $ops_arr = [];
        // if no rolefolder id is given, assume global role folder as target
        if ($a_parent == 0) {
            $a_parent = ROLE_FOLDER_ID;
        }
 
        $query = "SELECT ops_id FROM rbac_templates " .
            "WHERE type =" . $this->db->quote($a_type, 'text') . " " .
            "AND rol_id = " . $this->db->quote($a_rol_id, 'integer') . " " .
            "AND parent = " . $this->db->quote($a_parent, 'integer');
        $res = $this->db->query($query);
        while ($row = $this->db->fetchObject($res)) {
            $ops_arr[] = $row->ops_id;
        }
        return $ops_arr;
    }

References $query, $res, and ROLE_FOLDER_ID.

◆ getOperationsOnType()

ilRbacReview::getOperationsOnType ( int $a_typ_id )

all possible operations of a type

Definition at line 740 of file class.ilRbacReview.php.

                                                      : array
    {
        $query = 'SELECT * FROM rbac_ta ta JOIN rbac_operations o ON ta.ops_id = o.ops_id ' .
            'WHERE typ_id = ' . $this->db->quote($a_typ_id, 'integer') . ' ' .
            'ORDER BY op_order';
 
        $res = $this->db->query($query);
        $ops_id = [];
        while ($row = $this->db->fetchObject($res)) {
            $ops_id[] = (int) $row->ops_id;
        }
        return $ops_id;
    }

References $query, $res, and ILIAS\Repository\int().

Here is the call graph for this function:

◆ getOperationsOnTypeString()

ilRbacReview::getOperationsOnTypeString ( string $a_type )

all possible operations of a type

Definition at line 757 of file class.ilRbacReview.php.

                                                             : array
    {
        $query = "SELECT * FROM object_data WHERE type = 'typ' AND title = " . $this->db->quote($a_type, 'text') . " ";
        $res = $this->db->query($query);
        while ($row = $res->fetchRow(ilDBConstants::FETCHMODE_OBJECT)) {
            return $this->getOperationsOnType((int) $row->obj_id);
        }
        return [];
    }

References $query, $res, and ilDBConstants\FETCHMODE_OBJECT.

◆ getParentRoleIds()

ilRbacReview::getParentRoleIds	(	int	$a_endnode_id,
		bool	$a_templates = `false`
	)

Get an array of parent role ids of all parent roles, if last parameter is set true you get also all parent templates.

Parameters

int	ref_id of an object which is end node
bool	true for role templates (default: false)

Returns: array array(role_ids => role_data)

Todo:: move tree to construct. Currently this is not possible due to init sequence

Definition at line 122 of file class.ilRbacReview.php.

                                                                                  : array
    {
        global $DIC;
 
        $tree = $DIC->repositoryTree();
 
        $pathIds = $tree->getPathId($a_endnode_id);
 
        // add system folder since it may not in the path
        $pathIds[0] = ROLE_FOLDER_ID;
        return $this->__getParentRoles($pathIds, $a_templates);
    }

References $DIC, __getParentRoles(), and ROLE_FOLDER_ID.

Referenced by ilContainerGUI\performPasteIntoMultipleObjectsObject(), and ilPermissionGUI\savePermissions().

Here is the call graph for this function:

Here is the caller graph for this function:

◆ getRoleFolderOfRole()

ilRbacReview::getRoleFolderOfRole ( int $a_role_id )

Definition at line 1328 of file class.ilRbacReview.php.

                                                       : int
    {
        if (ilObject::_lookupType($a_role_id) == 'role') {
            $and = ('AND assign = ' . $this->db->quote('y', 'text'));
        } else {
            $and = '';
        }
 
        $query = 'SELECT * FROM rbac_fa ' .
            'WHERE rol_id = ' . $this->db->quote($a_role_id, 'integer') . ' ' .
            $and;
        $res = $this->db->query($query);
        while ($row = $res->fetchRow(ilDBConstants::FETCHMODE_OBJECT)) {
            return (int) $row->parent;
        }
        return 0;
    }

References $query, $res, ilObject\_lookupType(), and ilDBConstants\FETCHMODE_OBJECT.

Here is the call graph for this function:

◆ getRoleListByObject()

ilRbacReview::getRoleListByObject	(	int	$a_ref_id,
		bool	$a_templates = `false`
	)

Returns a list of roles in an container.

Returns: list<RoleListEntry>

Definition at line 139 of file class.ilRbacReview.php.

                                                                                 : array
    {
        $role_list = [];
        $where = $this->__setTemplateFilter($a_templates);
 
        $query = "SELECT * FROM object_data " .
            "JOIN rbac_fa ON obj_id = rol_id " .
            $where .
            "AND object_data.obj_id = rbac_fa.rol_id " .
            "AND rbac_fa.parent = " . $this->db->quote($a_ref_id, 'integer') . " ";
 
        $res = $this->db->query($query);
        while ($row = $this->db->fetchAssoc($res)) {
            $row["desc"] = $row["description"];
            $row["user_id"] = (int) $row["owner"];
            $row['obj_id'] = (int) $row['obj_id'];
            $row['rol_id'] = (int) $row['rol_id'];
            $row['parent'] = (int) $row['parent'];
            $role_list[] = $row;
        }
 
        return $this->__setRoleType($role_list);
    }

References $query, $res, __setRoleType(), __setTemplateFilter(), and ILIAS\Repository\int().

Referenced by __getParentRoles().

Here is the call graph for this function:

Here is the caller graph for this function:

◆ getRoleOperationsOnObject()

ilRbacReview::getRoleOperationsOnObject	(	int	$a_role_id,
		int	$a_ref_id
	)

Definition at line 723 of file class.ilRbacReview.php.

                                                                            : array
    {
        $query = "SELECT * FROM rbac_pa " .
            "WHERE rol_id = " . $this->db->quote($a_role_id, 'integer') . " " .
            "AND ref_id = " . $this->db->quote($a_ref_id, 'integer') . " ";
 
        $res = $this->db->query($query);
        $ops = [];
        while ($row = $this->db->fetchObject($res)) {
            $ops = (array) unserialize($row->ops_id);
        }
        return $ops;
    }

References $query, and $res.

Referenced by ilPermissionGUI\savePermissions().

Here is the caller graph for this function:

◆ getRolesByFilter()

ilRbacReview::getRolesByFilter	(	int	$a_filter = `0`,
		int	$a_user_id = `0`,
		string	$title_filter = `''`
	)

Returns: Generator<RoleListEntry>

Definition at line 849 of file class.ilRbacReview.php.

                                                                                                      : Generator
    {
        $assign = "y";
        switch ($a_filter) {
            // all (assignable) roles
            case self::FILTER_ALL:
                yield from $this->getAssignableRolesGenerator(true, true, $title_filter);
 
                // all (assignable) global roles
                // no break
            case self::FILTER_ALL_GLOBAL:
                $where = 'WHERE ' . $this->db->in('rbac_fa.rol_id', $this->getGlobalRoles(), false, 'integer') . ' ';
                break;
 
                // all (assignable) local roles
            case self::FILTER_ALL_LOCAL:
            case self::FILTER_INTERNAL:
            case self::FILTER_NOT_INTERNAL:
                $where = 'WHERE ' . $this->db->in('rbac_fa.rol_id', $this->getGlobalRoles(), true, 'integer');
                break;
 
            case self::FILTER_TEMPLATES:
                $where = "WHERE object_data.type = 'rolt'";
                $assign = "n";
                break;
 
                // only assigned roles, handled by ilObjUserGUI::roleassignmentObject()
            case 0:
            default:
                if (!$a_user_id) {
                    return [];
                }
 
                $where = 'WHERE ' . $this->db->in(
                    'rbac_fa.rol_id',
                    $this->assignedRoles($a_user_id),
                    false,
                    'integer'
                ) . ' ';
                break;
        }
 
        $query = "SELECT * FROM object_data " .
            "JOIN rbac_fa ON obj_id = rol_id " .
            $where .
            "AND rbac_fa.assign = " . $this->db->quote($assign, 'text') . " ";
 
        if (strlen($title_filter)) {
            $query .= (' AND ' . $this->db->like(
                'title',
                'text',
                '%' . $title_filter . '%'
            ));
        }
 
        $res = $this->db->query($query);
        while ($row = $this->db->fetchAssoc($res)) {
            $row['title'] = $row['title'] ?? '';
            $prefix = substr($row['title'], 0, 3) == "il_";
 
            // all (assignable) internal local roles only
            if ($a_filter == 4 && !$prefix) {
                continue;
            }
 
            // all (assignable) non internal local roles only
            if ($a_filter == 5 && $prefix) {
                continue;
            }
 
            $row['description'] = $row['description'] ?? '';
            $row["desc"] = $row["description"];
            $row["user_id"] = (int) $row["owner"];
            $row['obj_id'] = (int) $row['obj_id'];
            $row['rol_id'] = (int) $row['rol_id'];
            $row['parent'] = (int) $row['parent'];
 
            yield $this->setRoleTypeAndProtection($row);
        }
    }

References $query, $res, and ILIAS\Repository\int().

Here is the call graph for this function:

◆ getRolesForIDs()

ilRbacReview::getRolesForIDs	(	array	$role_ids,
		bool	$use_templates
	)

Definition at line 1229 of file class.ilRbacReview.php.

                                                                        : array
    {
        $where = $this->__setTemplateFilter($use_templates);
        $query = "SELECT * FROM object_data " .
            "JOIN rbac_fa ON object_data.obj_id = rbac_fa.rol_id " .
            $where .
            "AND rbac_fa.assign = 'y' " .
            'AND ' . $this->db->in('object_data.obj_id', $role_ids, false, 'integer');
 
        $res = $this->db->query($query);
        $role_list = [];
        while ($row = $this->db->fetchAssoc($res)) {
            $row["desc"] = $row["description"];
            $row["user_id"] = (int) $row["owner"];
            $role_list[] = $row;
        }
        return $this->__setRoleType($role_list);
    }

References $query, $res, and ILIAS\Repository\int().

Here is the call graph for this function:

◆ getRolesOfObject()

ilRbacReview::getRolesOfObject	(	int	$a_ref_id,
		bool	$a_assignable_only = `false`
	)

Get roles of object.

Definition at line 501 of file class.ilRbacReview.php.

                                                                                    : array
    {
        $and = '';
        if ($a_assignable_only === true) {
            $and = 'AND assign = ' . $this->db->quote('y', 'text');
        }
        $query = "SELECT rol_id FROM rbac_fa " .
            "WHERE parent = " . $this->db->quote($a_ref_id, 'integer') . " " .
            $and;
 
        $res = $this->db->query($query);
 
        $role_ids = [];
        while ($row = $this->db->fetchObject($res)) {
            $role_ids[] = (int) $row->rol_id;
        }
        return $role_ids;
    }

References $query, $res, and ILIAS\Repository\int().

Here is the call graph for this function:

◆ getRolesOfRoleFolder()

ilRbacReview::getRolesOfRoleFolder	(	int	$a_ref_id,
		bool	$a_nonassignable = `true`
	)

get all roles of a role folder including linked local roles that are created due to stopped inheritance returns an array with role ids @access public

Parameters

int	ref_id of object
bool	if false only get true local roles

Returns: int[] Array with rol_ids

Deprecated:: since version 4.5.0

Todo:: refactor rolf => RENAME

Definition at line 530 of file class.ilRbacReview.php.

                                                                                     : array
    {
        $and = '';
        if ($a_nonassignable === false) {
            $and = " AND assign='y'";
        }
 
        $query = "SELECT rol_id FROM rbac_fa " .
            "WHERE parent = " . $this->db->quote($a_ref_id, 'integer') . " " .
            $and;
 
        $res = $this->db->query($query);
        $rol_id = [];
        while ($row = $this->db->fetchObject($res)) {
            $rol_id[] = (int) $row->rol_id;
        }
 
        return $rol_id;
    }

References $query, $res, and ILIAS\Repository\int().

Referenced by ilObjSessionGUI\getDefaultMemberRole(), and ilObjSessionGUI\getLocalRoles().

Here is the call graph for this function:

Here is the caller graph for this function:

◆ getTypeId()

ilRbacReview::getTypeId ( string $a_type )

Definition at line 930 of file class.ilRbacReview.php.

                                             : int
    {
        $q = "SELECT obj_id FROM object_data " .
            "WHERE title=" . $this->db->quote($a_type, 'text') . " AND type='typ'";
        $r = $this->db->query($q);
        while ($row = $r->fetchRow(ilDBConstants::FETCHMODE_OBJECT)) {
            return (int) $row->obj_id;
        }
        return 0;
    }

References ilDBConstants\FETCHMODE_OBJECT.

◆ getUserPermissionsOnObject()

ilRbacReview::getUserPermissionsOnObject	(	int	$a_user_id,
		int	$a_ref_id
	)

Get all user permissions on an object.

Definition at line 1349 of file class.ilRbacReview.php.

                                                                             : array
    {
        $query = "SELECT ops_id FROM rbac_pa JOIN rbac_ua " .
            "ON (rbac_pa.rol_id = rbac_ua.rol_id) " .
            "WHERE rbac_ua.usr_id = " . $this->db->quote($a_user_id, 'integer') . " " .
            "AND rbac_pa.ref_id = " . $this->db->quote($a_ref_id, 'integer') . " ";
 
        $res = $this->db->query($query);
        $all_ops = [];
        while ($row = $this->db->fetchObject($res)) {
            $ops = unserialize($row->ops_id);
            $all_ops = array_merge($all_ops, $ops);
        }
        $all_ops = array_unique($all_ops);
 
        $set = $this->db->query("SELECT operation FROM rbac_operations " .
            " WHERE " . $this->db->in("ops_id", $all_ops, false, "integer"));
        $perms = [];
        while ($rec = $this->db->fetchAssoc($set)) {
            $perms[] = $rec["operation"];
        }
        return $perms;
    }

References $query, and $res.

◆ hasMultipleAssignments()

ilRbacReview::hasMultipleAssignments ( int $a_role_id )

Definition at line 463 of file class.ilRbacReview.php.

                                                          : bool
    {
        $query = "SELECT * FROM rbac_fa WHERE rol_id = " . $this->db->quote($a_role_id, 'integer') . ' ' .
            "AND assign = " . $this->db->quote('y', 'text');
        $res = $this->db->query($query);
        return $res->numRows() > 1;
    }

References $query, and $res.

◆ isAssignable()

ilRbacReview::isAssignable	(	int	$a_rol_id,
		int	$a_ref_id
	)

Check if its possible to assign users.

Definition at line 446 of file class.ilRbacReview.php.

                                                              : bool
    {
        // exclude system role from rbac
        if ($a_rol_id == SYSTEM_ROLE_ID) {
            return true;
        }
 
        $query = "SELECT * FROM rbac_fa " .
            "WHERE rol_id = " . $this->db->quote($a_rol_id, 'integer') . " " .
            "AND parent = " . $this->db->quote($a_ref_id, 'integer') . " ";
        $res = $this->db->query($query);
        while ($row = $this->db->fetchObject($res)) {
            return $row->assign == 'y';
        }
        return false;
    }

References $query, $res, and SYSTEM_ROLE_ID.

Referenced by ilRecommendedContentRoleConfigGUI\listItems(), and ilPermissionGUI\savePermissions().

Here is the caller graph for this function:

◆ isAssigned()

ilRbacReview::isAssigned	(	int	$a_usr_id,
		int	$a_role_id
	)

check if a specific user is assigned to specific role

Definition at line 368 of file class.ilRbacReview.php.

                                                             : bool
    {
        if (isset(self::$is_assigned_cache[$a_role_id][$a_usr_id])) {
            return self::$is_assigned_cache[$a_role_id][$a_usr_id];
        }
        // Quickly determine if user is assigned to a role
        $this->db->setLimit(1, 0);
        $query = "SELECT usr_id FROM rbac_ua WHERE " .
            "rol_id= " . $this->db->quote($a_role_id, 'integer') . " " .
            "AND usr_id= " . $this->db->quote($a_usr_id, ilDBConstants::T_INTEGER);
        $res = $this->db->query($query);
        $is_assigned = $res->numRows() == 1;
        self::$is_assigned_cache[$a_role_id][$a_usr_id] = $is_assigned;
        return $is_assigned;
    }

References $query, $res, and ilDBConstants\T_INTEGER.

Referenced by ILIAS\Awareness\User\Collector\collectUsers().

Here is the caller graph for this function:

◆ isAssignedToAtLeastOneGivenRole()

ilRbacReview::isAssignedToAtLeastOneGivenRole	(	int	$a_usr_id,
		array	$a_role_ids
	)

check if a specific user is assigned to at least one of the given role ids.

This function is used to quickly check whether a user is member of a course or a group.

Parameters

int	usr_id
int[]	role_ids

Definition at line 392 of file class.ilRbacReview.php.

                                                                                     : bool
    {
        global $DIC;
 
        $this->db = $DIC['ilDB'];
 
        $this->db->setLimit(1, 0);
        $query = "SELECT usr_id FROM rbac_ua WHERE " .
            $this->db->in('rol_id', $a_role_ids, false, 'integer') .
            " AND usr_id= " . $this->db->quote($a_usr_id, ilDBConstants::T_INTEGER);
        $res = $this->db->query($query);
 
        return $this->db->numRows($res) == 1;
    }

References $DIC, $query, $res, and ilDBConstants\T_INTEGER.

◆ isBlockedAtPosition()

ilRbacReview::isBlockedAtPosition	(	int	$a_role_id,
		int	$a_ref_id
	)

Definition at line 1043 of file class.ilRbacReview.php.

                                                                      : bool
    {
        $query = 'SELECT blocked from rbac_fa ' .
            'WHERE rol_id = ' . $this->db->quote($a_role_id, 'integer') . ' ' .
            'AND parent = ' . $this->db->quote($a_ref_id, 'integer');
        $res = $this->db->query($query);
        while ($row = $res->fetchRow(ilDBConstants::FETCHMODE_OBJECT)) {
            return (bool) $row->blocked;
        }
        return false;
    }

References $query, $res, and ilDBConstants\FETCHMODE_OBJECT.

Referenced by ilPermissionGUI\getModifiedBlockedSettings(), and ilPermissionGUI\savePermissions().

Here is the caller graph for this function:

◆ isBlockedInUpperContext()

ilRbacReview::isBlockedInUpperContext	(	int	$a_role_id,
		int	$a_ref_id
	)

Check if role is blocked in upper context.

Todo:: move tree to construct. Currently this is not possible due to init sequence

Definition at line 1059 of file class.ilRbacReview.php.

                                                                          : bool
    {
        global $DIC;
 
        $tree = $DIC['tree'];
 
        if ($this->isBlockedAtPosition($a_role_id, $a_ref_id)) {
            return false;
        }
        $query = 'SELECT parent from rbac_fa ' .
            'WHERE rol_id = ' . $this->db->quote($a_role_id, 'integer') . ' ' .
            'AND blocked = ' . $this->db->quote(1, 'integer');
        $res = $this->db->query($query);
 
        $parent_ids = [];
        while ($row = $res->fetchRow(ilDBConstants::FETCHMODE_OBJECT)) {
            $parent_ids[] = (int) $row->parent;
        }
 
        foreach ($parent_ids as $parent_id) {
            if ($tree->isGrandChild($parent_id, $a_ref_id)) {
                return true;
            }
        }
        return false;
    }

References $DIC, $query, $res, ilDBConstants\FETCHMODE_OBJECT, and ILIAS\Repository\int().

Here is the call graph for this function:

◆ isDeleteable()

ilRbacReview::isDeleteable	(	int	$a_role_id,
		int	$a_rolf_id
	)

Check if role is deleteable at a specific position.

Definition at line 1278 of file class.ilRbacReview.php.

                                                                : bool
    {
        if (!$this->isAssignable($a_role_id, $a_rolf_id)) {
            return false;
        }
        if ($a_role_id == SYSTEM_ROLE_ID or $a_role_id == ANONYMOUS_ROLE_ID) {
            return false;
        }
        if (substr(ilObject::_lookupTitle($a_role_id), 0, 3) == 'il_') {
            return false;
        }
        return true;
    }

References ilObject\_lookupTitle(), ANONYMOUS_ROLE_ID, and SYSTEM_ROLE_ID.

Here is the call graph for this function:

◆ isDeleted()

ilRbacReview::isDeleted ( int $a_node_id )

Checks if a rolefolder is set as deleted (negative tree_id)

Todo:: delete this method

Definition at line 820 of file class.ilRbacReview.php.

                                             : bool
    {
        $q = "SELECT tree FROM tree WHERE child =" . $this->db->quote($a_node_id, ilDBConstants::T_INTEGER) . " ";
        $r = $this->db->query($q);
        $row = $r->fetchRow(ilDBConstants::FETCHMODE_OBJECT);
 
        if (!$row) {
            $message = sprintf(
                '%s::isDeleted(): Role folder with ref_id %s not found!',
                get_class($this),
                $a_node_id
            );
            $this->log->warning($message);
            return true;
        }
        return $row->tree < 0;
    }

References $message, ilDBConstants\FETCHMODE_OBJECT, and ilDBConstants\T_INTEGER.

◆ isGlobalRole()

ilRbacReview::isGlobalRole ( int $a_role_id )

Check if role is a global role.

Definition at line 841 of file class.ilRbacReview.php.

                                                : bool
    {
        return in_array($a_role_id, $this->getGlobalRoles());
    }

◆ isProtected()

ilRbacReview::isProtected	(	int	$a_ref_id,
		int	$a_role_id
	)

ref_id not used yet.

Protected permission acts 'global' for each role,

Definition at line 1030 of file class.ilRbacReview.php.

                                                              : bool
    {
        $query = 'SELECT protected FROM rbac_fa ' .
            'WHERE rol_id = ' . $this->db->quote($a_role_id, ilDBConstants::T_INTEGER);
        $res = $this->db->query($query);
        while ($row = $res->fetchRow(ilDBConstants::FETCHMODE_OBJECT)) {
            if ($row->protected === 'y') {
                return true;
            }
        }
        return false;
    }

References $query, $res, ilDBConstants\FETCHMODE_OBJECT, and ilDBConstants\T_INTEGER.

Referenced by ilPermissionGUI\savePermissions().

Here is the caller graph for this function:

◆ isRoleAssignedToObject()

ilRbacReview::isRoleAssignedToObject	(	int	$a_role_id,
		int	$a_parent_id
	)

Check if role is assigned to an object.

Definition at line 620 of file class.ilRbacReview.php.

                                                                            : bool
    {
        $query = 'SELECT * FROM rbac_fa ' .
            'WHERE rol_id = ' . $this->db->quote($a_role_id, 'integer') . ' ' .
            'AND parent = ' . $this->db->quote($a_parent_id, 'integer');
        $res = $this->db->query($query);
        return (bool) $res->numRows();
    }

References $query, and $res.

◆ isRoleDeleted()

ilRbacReview::isRoleDeleted ( int $a_role_id )

return if role is only attached to deleted role folders

Definition at line 1213 of file class.ilRbacReview.php.

                                                 : bool
    {
        $rolf_list = $this->getFoldersAssignedToRole($a_role_id, false);
        $deleted = true;
        if ($rolf_list !== []) {
            foreach ($rolf_list as $rolf) {
                // only list roles that are not set to status "deleted"
                if (!$this->isDeleted($rolf)) {
                    $deleted = false;
                    break;
                }
            }
        }
        return $deleted;
    }

◆ isSystemGeneratedRole()

ilRbacReview::isSystemGeneratedRole ( int $a_role_id )

Check if the role is system generate role or role template.

Definition at line 1295 of file class.ilRbacReview.php.

                                                         : bool
    {
        $title = ilObject::_lookupTitle($a_role_id);
        return substr($title, 0, 3) == 'il_';
    }

References ilObject\_lookupTitle().

Here is the call graph for this function:

◆ lookupCreateOperationIds()

static ilRbacReview::lookupCreateOperationIds ( array $a_type_arr )

static

Lookup operation ids.

Parameters

array $a_type_arr e.g array('cat','crs','grp'). The operation name (e.g. 'create_cat') is generated automatically

Returns: int[] Array with operation ids

Definition at line 997 of file class.ilRbacReview.php.

                                                                      : array
    {
        global $DIC;
 
        $ilDB = $DIC->database();
 
        $operations = [];
        foreach ($a_type_arr as $type) {
            $operations[] = ('create_' . $type);
        }
 
        if ($operations === []) {
            return [];
        }
 
        $query = 'SELECT ops_id, operation FROM rbac_operations ' .
            'WHERE ' . $ilDB->in('operation', $operations, false, 'text');
 
        $res = $ilDB->query($query);
 
        $ops_ids = [];
        while ($row = $ilDB->fetchObject($res)) {
            $type_arr = explode('_', $row->operation);
            $type = $type_arr[1];
 
            $ops_ids[$type] = (int) $row->ops_id;
        }
        return $ops_ids;
    }

References $DIC, $ilDB, $query, $res, $type, and ILIAS\Repository\int().

Referenced by ilObjectXMLWriter\appendOperations(), ilObjectRolePermissionTableGUI\parse(), ilObjectRoleTemplatePermissionTableGUI\parse(), and ilPermissionGUI\savePermissions().

Here is the call graph for this function:

Here is the caller graph for this function:

◆ roleExists()

ilRbacReview::roleExists	(	string	$a_title,
		int	$a_id = `0`
	)

Checks if a role already exists.

Role title should be unique @access public

Parameters

string	role title
?int	obj_id of role to exclude in the check. Commonly this is the current role you want to edit

Returns: bool

Definition at line 70 of file class.ilRbacReview.php.

                                                              : ?int
    {
        $clause = ($a_id) ? " AND obj_id != " . $this->db->quote($a_id, ilDBConstants::T_TEXT) . " " : "";
 
        $q = "SELECT DISTINCT(obj_id) obj_id FROM object_data " .
            "WHERE title =" . $this->db->quote($a_title, ilDBConstants::T_TEXT) . " " .
            "AND type IN('role','rolt')" .
            $clause . " ";
        $r = $this->db->query($q);
        while ($row = $r->fetchRow(ilDBConstants::FETCHMODE_OBJECT)) {
            return (int) $row->obj_id;
        }
        return null;
    }

References ilDBConstants\FETCHMODE_OBJECT, and ilDBConstants\T_TEXT.

◆ setAssignedCacheEntry()

ilRbacReview::setAssignedCacheEntry	(	int	$a_role_id,
		int	$a_user_id,
		bool	$a_value
	)

set entry of assigned_chache

Definition at line 1376 of file class.ilRbacReview.php.

                                                                                        : void
    {
        self::$is_assigned_cache[$a_role_id][$a_user_id] = $a_value;
    }

◆ setRoleTypeAndProtection()

ilRbacReview::setRoleTypeAndProtection ( array $role_list_entry )

private

Definition at line 292 of file class.ilRbacReview.php.

                                                                     : array
    {
        $role_list_entry['role_type'] = $this->buildRoleType($role_list_entry);
        $role_list_entry['protected'] = $this->buildProtectionByStringValue($role_list_entry['protected']);
        return $role_list_entry;
    }

Field Documentation

◆ $_opsCache

array ilRbacReview::$_opsCache = null

staticprivate

Definition at line 43 of file class.ilRbacReview.php.

◆ $assigned_users_cache

array ilRbacReview::$assigned_users_cache = []

staticprotected

Definition at line 45 of file class.ilRbacReview.php.

◆ $db

ilDBInterface ilRbacReview::$db

protected

Definition at line 49 of file class.ilRbacReview.php.

◆ $is_assigned_cache

array ilRbacReview::$is_assigned_cache = []

staticprotected

Definition at line 46 of file class.ilRbacReview.php.

◆ $log

ilLogger ilRbacReview::$log

protected

Definition at line 48 of file class.ilRbacReview.php.

◆ FILTER_ALL

const ilRbacReview::FILTER_ALL = 1

Definition at line 35 of file class.ilRbacReview.php.

Referenced by ilRoleTableGUI\initFilter(), and ilRoleTableGUI\parse().

◆ FILTER_ALL_GLOBAL

const ilRbacReview::FILTER_ALL_GLOBAL = 2

Definition at line 36 of file class.ilRbacReview.php.

Referenced by ilRoleTableGUI\initFilter().

◆ FILTER_ALL_LOCAL

const ilRbacReview::FILTER_ALL_LOCAL = 3

Definition at line 37 of file class.ilRbacReview.php.

Referenced by ilRoleTableGUI\initFilter().

◆ FILTER_INTERNAL

const ilRbacReview::FILTER_INTERNAL = 4

Definition at line 38 of file class.ilRbacReview.php.

Referenced by ilRoleTableGUI\initFilter().

◆ FILTER_NOT_INTERNAL

const ilRbacReview::FILTER_NOT_INTERNAL = 5

Definition at line 39 of file class.ilRbacReview.php.

Referenced by ilRoleTableGUI\initFilter().

◆ FILTER_TEMPLATES

const ilRbacReview::FILTER_TEMPLATES = 6

Definition at line 40 of file class.ilRbacReview.php.

Referenced by ilRoleTableGUI\initFilter().

The documentation for this class was generated from the following file:

Services/AccessControl/classes/class.ilRbacReview.php

Public Member Functions

Static Public Member Functions

Data Fields

Protected Member Functions

Protected Attributes

Static Protected Attributes

Private Member Functions

Static Private Attributes

Detailed Description

Constructor & Destructor Documentation

◆ __construct()

Member Function Documentation

◆ __getParentRoles()

◆ __setProtectedStatus()

◆ __setRoleType()

◆ __setTemplateFilter()

◆ _getCustomRBACOperationId()

◆ _getOperationIdByName()

◆ _getOperationIdsByName()

◆ _getOperationList()

◆ _groupOperationsByClass()

◆ _isRBACOperation()

◆ assignedGlobalRoles()

◆ assignedRoles()

◆ assignedUsers()

◆ buildProtectionByStringValue()

◆ buildRoleType()

◆ clearCaches()

◆ getActiveOperationsOfRole()

◆ getAllOperationsOfRole()

◆ getAssignableChildRoles()

◆ getAssignableRoles()

◆ getAssignableRolesGenerator()

◆ getAssignableRolesInSubtree()

◆ getAssignedCacheEntry()

◆ getFoldersAssignedToRole()

◆ getGlobalAssignableRoles()

◆ getGlobalRoles()

◆ getGlobalRolesArray()

◆ getLocalPolicies()

◆ getLocalRoles()

◆ getNumberOfAssignedUsers()

◆ getObjectOfRole()

◆ getObjectReferenceOfRole()

◆ getObjectsWithStopedInheritance()

◆ getOperation()

◆ getOperationAssignment()

◆ getOperations()

◆ getOperationsByTypeAndClass()

◆ getOperationsOfRole()

◆ getOperationsOnType()

◆ getOperationsOnTypeString()

◆ getParentRoleIds()

◆ getRoleFolderOfRole()

◆ getRoleListByObject()

◆ getRoleOperationsOnObject()

◆ getRolesByFilter()

◆ getRolesForIDs()

◆ getRolesOfObject()

◆ getRolesOfRoleFolder()

◆ getTypeId()

◆ getUserPermissionsOnObject()

◆ hasMultipleAssignments()

◆ isAssignable()

◆ isAssigned()

◆ isAssignedToAtLeastOneGivenRole()

◆ isBlockedAtPosition()

◆ isBlockedInUpperContext()

◆ isDeleteable()

◆ isDeleted()

◆ isGlobalRole()

◆ isProtected()

◆ isRoleAssignedToObject()

◆ isRoleDeleted()

◆ isSystemGeneratedRole()

◆ lookupCreateOperationIds()

◆ roleExists()

◆ setAssignedCacheEntry()

◆ setRoleTypeAndProtection()

Field Documentation