class.ilOrgUnitUserAssignmentQueries.php

Go to the documentation of this file.

<?php
 
class ilOrgUnitUserAssignmentQueries
{
 
    protected static $instance;
 
 
    public static function getInstance()
    {
        if (!isset(self::$instance)) {
            self::$instance = new self();
        }
 
        return self::$instance;
    }
 
 
    public function getPositionsOfUserId($user_id)
    {
        $positions = [];
        foreach ($this->getAssignmentsOfUserId($user_id) as $assignment) {
            $positions[] = ilOrgUnitPosition::find($assignment->getPositionId());
        }
 
        return $positions;
    }
 
 
    public function getAssignmentOrFail($user_id, $position_id, $orgu_id)
    {
        $ua = ilOrgUnitUserAssignment::where([
            'user_id' => $user_id,
            'position_id' => $position_id,
            'orgu_id' => $orgu_id,
        ])->first();
        if (!$ua) {
            throw new  ilException('UserAssignement not found');
        }
 
        return $ua;
    }
 
 
    public function filterUserIdsDueToAuthorities($user_id, array $user_ids)
    {
    }
 
 
    public function getAssignmentsOfUserId($user_id)
    {
        return ilOrgUnitUserAssignment::where([ 'user_id' => $user_id ])->get();
    }
 
 
    public function getUserIdsOfOrgUnit($orgunit_ref_id)
    {
        return ilOrgUnitUserAssignment::where([ 'orgu_id' => $orgunit_ref_id ])
                                      ->getArray(null, 'user_id');
    }
 
 
    public function getUserIdsOfOrgUnits(array $orgunit_ref_id)
    {
        return ilOrgUnitUserAssignment::where([ 'orgu_id' => $orgunit_ref_id ])
                                      ->getArray(null, 'user_id');
    }
 
 
    public function getUserIdsOfOrgUnitsOfUsersPosition($position_id, $user_id, $recursive = false)
    {
        return ilOrgUnitUserAssignment::where([ 'orgu_id' => $this->getOrgUnitIdsOfUsersPosition($position_id, $user_id, $recursive) ])
                                      ->getArray(null, 'user_id');
    }
 
 
    public function getUserIdsOfOrgUnitsInPosition(array $orgu_ids, $position_id)
    {
        return ilOrgUnitUserAssignment::where([
            'orgu_id' => $orgu_ids,
            'position_id' => $position_id,
        ])->getArray(null, 'user_id');
    }
 
 
    public function getUserIdsOfUsersOrgUnitsInPosition($user_id, $users_position_id, $position_id, $recursive = false)
    {
        return ilOrgUnitUserAssignment::where([
            'orgu_id' => $this->getOrgUnitIdsOfUsersPosition($users_position_id, $user_id, $recursive),
            'position_id' => $position_id,
        ])->getArray(null, 'user_id');
    }
 
 
    public function getOrgUnitIdsOfUsersPosition($position_id, $user_id, $recursive = false)
    {
        $orgu_ids = ilOrgUnitUserAssignment::where([
            'position_id' => $position_id,
            'user_id' => $user_id,
        ])->getArray(null, 'orgu_id');
 
        if (!$recursive) {
            return $orgu_ids;
        }
 
        $recursive_orgu_ids = [];
        $tree = ilObjOrgUnitTree::_getInstance();
        foreach ($orgu_ids as $orgu_id) {
            $recursive_orgu_ids = $recursive_orgu_ids + $tree->getAllChildren($orgu_id);
        }
 
        return $recursive_orgu_ids;
    }
 
 
    public function getUserIdsOfPosition($position_id)
    {
        return ilOrgUnitUserAssignment::where([
            'position_id' => $position_id,
        ])->getArray(null, 'user_id');
    }
 
 
    public function getUserAssignmentsOfPosition($position_id)
    {
        return ilOrgUnitUserAssignment::where([
            'position_id' => $position_id,
        ])->get();
    }
 
    public function deleteAllAssignmentsOfUser($user_id)
    {
        global $DIC;
        $q = "DELETE FROM il_orgu_ua WHERE user_id = " . $DIC->database()->quote($user_id, "integer");
        $DIC->database()->manipulate($q);
    }
}