ilOrgUnitPermissionQueries Class Reference

Class ilOrgUnitPermissionQueries. More...

Collaboration diagram for ilOrgUnitPermissionQueries:

Static Public Member Functions
static	getTemplateSetForContextName ($context_name, $position_id, $editable=false)
static	hasLocalSet ($ref_id, $position_id)
static	getAllTemplateSetsForAllActivedContexts ($position_id, $editable=false)
static	getRelevantPermissionSetsForUserIdAndRefIdAndOperation ($user_id, $ref_id, $operation_string)

Static Protected Member Functions
static	getContextByRefId ($ref_id)
static	checkRefIdAndPositionId ($ref_id, $position_id)

Static Private Member Functions
static	getAllowedOperationsOnRefIdAndPosition ($ref_id, $position_id)

Detailed Description

Class ilOrgUnitPermissionQueries.

Author

Fabian Schmid fs@st.nosp@m.uder.nosp@m.-raim.nosp@m.ann..nosp@m.ch

Definition at line 8 of file class.ilOrgUnitPermissionQueries.php.

Member Function Documentation

checkRefIdAndPositionId()

static ilOrgUnitPermissionQueries::checkRefIdAndPositionId (   $ref_id,   $position_id  )

staticprotected

Parameters

$ref_id
$position_id

Exceptions

ilException

Definition at line 277 of file class.ilOrgUnitPermissionQueries.php.

    {
        if (!$ref_id) {
            throw new ilException('$ref_id cannot be null');
        }
        if (!$position_id) {
            throw new ilException('$position_id cannot be null');
        }
    }

getAllowedOperationsOnRefIdAndPosition()

static ilOrgUnitPermissionQueries::getAllowedOperationsOnRefIdAndPosition (   $ref_id,   $position_id  )

staticprivate

Definition at line 231 of file class.ilOrgUnitPermissionQueries.php.

    {
        global $DIC;
        $db = $DIC->database();
 
        $q = 'SELECT @CONTEXT_TYPE:= object_data.type
                 FROM object_reference
                 JOIN object_data ON object_data.obj_id = object_reference.obj_id
                 WHERE object_reference.ref_id = %s;';
        $db->queryF($q, [ 'integer' ], [ $ref_id ]);
 
        $q = 'SELECT @OP_ID:= CONCAT("%\"", il_orgu_operations.operation_id, "%\"")
                                        FROM il_orgu_operations 
                                        JOIN il_orgu_op_contexts ON il_orgu_op_contexts.context = @CONTEXT_TYPE -- AND il_orgu_op_contexts.id = il_orgu_operations.context_id
                                WHERE il_orgu_operations.operation_string = %s';
        $db->queryF($q, [ 'text' ], [ $pos_perm ]);
        $q = 'SELECT * FROM il_orgu_permissions WHERE operations LIKE @OP_ID AND position_id = %s;';
        $r = $db->queryF($q, [ 'integer' ], [ $position_id ]);
 
        ($r->numRows() > 0);
    }

References $DIC, and $r.

getAllTemplateSetsForAllActivedContexts()

static ilOrgUnitPermissionQueries::getAllTemplateSetsForAllActivedContexts (   $position_id,   $editable = false  )

static

Parameters

	$position_id
bool	$editable

Returns

\ilOrgUnitPermission[]

Definition at line 201 of file class.ilOrgUnitPermissionQueries.php.

    {
        $activated_components = [];
        foreach (ilOrgUnitGlobalSettings::getInstance()->getPositionSettings() as $ilOrgUnitObjectPositionSetting) {
            if ($ilOrgUnitObjectPositionSetting->isActive()) {
                $activated_components[] = $ilOrgUnitObjectPositionSetting->getType();
            }
        }
        $sets = [];
        foreach ($activated_components as $context) {
            $sets[] = ilOrgUnitPermissionQueries::getTemplateSetForContextName($context, $position_id, $editable);
        }
 
        return $sets;
    }

References $context, $sets, ilOrgUnitGlobalSettings\getInstance(), and getTemplateSetForContextName().

Referenced by ilOrgUnitDefaultPermissionGUI\index(), and ilOrgUnitDefaultPermissionGUI\update().

Here is the call graph for this function:

Here is the caller graph for this function:

getContextByRefId()

static ilOrgUnitPermissionQueries::getContextByRefId (   $ref_id )

staticprotected

Parameters

$ref_id

Returns

\ilOrgUnitOperationContext

Exceptions

ilException

Definition at line 260 of file class.ilOrgUnitPermissionQueries.php.

    {
        $context = ilOrgUnitOperationContextQueries::findByRefId($ref_id);
        if (!$context) {
            throw new ilException('Context not found');
        }
 
        return $context;
    }

References $context, and ilOrgUnitOperationContextQueries\findByRefId().

Here is the call graph for this function:

getRelevantPermissionSetsForUserIdAndRefIdAndOperation()

static ilOrgUnitPermissionQueries::getRelevantPermissionSetsForUserIdAndRefIdAndOperation (   $user_id,   $ref_id,   $operation_string  )

static

Parameters

$user_id
$ref_id
$operation_string

Definition at line 223 of file class.ilOrgUnitPermissionQueries.php.

    {
        $q = 'SELECT @OP_ID:= CONCAT("%\"",operation_id, "\"%") FROM il_orgu_op_contexts
JOIN il_orgu_operations ON il_orgu_operations.context_id = il_orgu_op_contexts.id
WHERE il_orgu_op_contexts.context IN(\'crs\', \'object\') AND operation_string = \'viewmembers\';';
    }

getTemplateSetForContextName()

static ilOrgUnitPermissionQueries::getTemplateSetForContextName (   $context_name,   $position_id,   $editable = false  )

static

Parameters

	$context_name
	$position_id
bool	$editable

Returns

\ilOrgUnitPermission

Exceptions

ilException

Definition at line 21 of file class.ilOrgUnitPermissionQueries.php.

    {
        // TODO write performant query
        $context = ilOrgUnitOperationContextQueries::findByName($context_name);
        if (!$context) {
            throw new ilException('No context found');
        }
        if (!$position_id) {
            throw new ilException('$position_id cannot be null');
        }
 
        $template_set = ilOrgUnitPermission::where([
            'parent_id' => ilOrgUnitPermission::PARENT_TEMPLATE,
            'context_id' => $context->getId(),
            'position_id' => $position_id,
        ])->first();
 
        if (!$template_set) {
            $template_set = new ilOrgUnitPermission();
            $template_set->setParentId(ilOrgUnitPermission::PARENT_TEMPLATE);
            $template_set->setContextId($context->getId());
            $template_set->setPositionId($position_id);
            $template_set->setNewlyCreated(true);
            $template_set->create();
            $template_set->afterObjectLoad();
        }
 
        $template_set->setProtected(!$editable);
 
        return $template_set;
    }

References $context, ilOrgUnitOperationContextQueries\findByName(), ilOrgUnitPermission\PARENT_TEMPLATE, and ActiveRecord\where().

Referenced by getAllTemplateSetsForAllActivedContexts().

Here is the call graph for this function:

Here is the caller graph for this function:

hasLocalSet()

static ilOrgUnitPermissionQueries::hasLocalSet (   $ref_id,   $position_id  )

static

Parameters

$ref_id
$position_id

Returns

bool

Definition at line 60 of file class.ilOrgUnitPermissionQueries.php.

    {
        return (ilOrgUnitPermission::where([
            'parent_id' => $ref_id,
            'position_id' => $position_id,
        ])->hasSets());
    }

References ActiveRecord\where().

Here is the call graph for this function:

---

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

• Modules/OrgUnit/classes/Positions/Permissions/class.ilOrgUnitPermissionQueries.php