OrgUnit\Positions\UserAssignment\ilOrgUnitUserAssignmentRepository Class Reference

Collaboration diagram for OrgUnit\Positions\UserAssignment\ilOrgUnitUserAssignmentRepository:

Public Member Functions
	getEmplSuperiorList ($arr_empl_user_ids)
	getAssignmentOrFail ($user_id, $position_id, $orgu_id)
	filterUserIdsDueToAuthorities ($user_id, array $user_ids)
	getAssignmentsOfUserId ($user_id)
	getUserIdsOfOrgUnit ($orgunit_ref_id)
	getUserIdsOfOrgUnits (array $orgunit_ref_id)
	getUserIdsOfOrgUnitsOfUsersPosition ($position_id, $user_id, $recursive=false)
	getUserIdsOfOrgUnitsInPosition (array $orgu_ids, $position_id)
	getUserIdsOfUsersOrgUnitsInPosition ($user_id, $users_position_id, $position_id, $recursive=false)
	getOrgUnitIdsOfUsersPosition ($position_id, $user_id, $recursive=false)
	getUserIdsOfPosition ($position_id)
	getUserAssignmentsOfPosition ($position_id)
	deleteAllAssignmentsOfUser ($user_id)

Static Public Member Functions
static	getInstance ()

Static Protected Attributes
static	$instance

Detailed Description

Definition at line 10 of file class.ilOrgUnitUserAssignmentRepository.php.

Member Function Documentation

deleteAllAssignmentsOfUser()

OrgUnit\Positions\UserAssignment\ilOrgUnitUserAssignmentRepository::deleteAllAssignmentsOfUser

(

$user_id

)

Parameters

int

$user_id

Returns

void

Definition at line 312 of file class.ilOrgUnitUserAssignmentRepository.php.

References $DIC.

    {
        global $DIC;
        $q = "DELETE FROM il_orgu_ua WHERE user_id = " . $DIC->database()->quote($user_id, "integer");
        $DIC->database()->manipulate($q);
    }

filterUserIdsDueToAuthorities()

OrgUnit\Positions\UserAssignment\ilOrgUnitUserAssignmentRepository::filterUserIdsDueToAuthorities	(		$user_id,
		array	$user_ids
	)

Definition at line 165 of file class.ilOrgUnitUserAssignmentRepository.php.

    {
    }

getAssignmentOrFail()

OrgUnit\Positions\UserAssignment\ilOrgUnitUserAssignmentRepository::getAssignmentOrFail	(		$user_id,
			$position_id,
			$orgu_id
	)

Parameters

int	$user_id
int	$position_id
int	$orgu_id	Org-Units Ref-ID

Returns

Exceptions

Definition at line 150 of file class.ilOrgUnitUserAssignmentRepository.php.

References ActiveRecord\where().

    {
        $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;
    }

Here is the call graph for this function:

getAssignmentsOfUserId()

OrgUnit\Positions\UserAssignment\ilOrgUnitUserAssignmentRepository::getAssignmentsOfUserId

(

$user_id

)

Parameters

$user_id

Returns

ilOrgUnitUserAssignment[]

Definition at line 175 of file class.ilOrgUnitUserAssignmentRepository.php.

References ActiveRecord\where().

Referenced by OrgUnit\Positions\UserAssignment\ilOrgUnitUserAssignmentRepository\getEmplSuperiorList().

    {
        return ilOrgUnitUserAssignment::where(['user_id' => $user_id])->get();
    }

Here is the call graph for this function:

Here is the caller graph for this function:

getEmplSuperiorList()

OrgUnit\Positions\UserAssignment\ilOrgUnitUserAssignmentRepository::getEmplSuperiorList

(

$arr_empl_user_ids

)

Parameters

$arr_empl_user_ids

Returns

array [user_id as an employee][][ user_id as a superior]

Definition at line 93 of file class.ilOrgUnitUserAssignmentRepository.php.

References $data, $DIC, ilOrgUnitPosition\CORE_POSITION_EMPLOYEE, ilOrgUnitPosition\CORE_POSITION_SUPERIOR, and OrgUnit\Positions\UserAssignment\ilOrgUnitUserAssignmentRepository\getAssignmentsOfUserId().

                                                            : array
    {
        global $DIC;

        $sql = "SELECT 
                                orgu_ua.orgu_id AS orgu_id,
                                orgu_ua.user_id AS empl,
                                orgu_ua2.user_id as sup
                                FROM
                                il_orgu_ua as orgu_ua,
                                il_orgu_ua as orgu_ua2
                                WHERE
                                orgu_ua.orgu_id = orgu_ua2.orgu_id 
                                and orgu_ua.user_id <> orgu_ua2.user_id 
                                and orgu_ua.position_id = " . ilOrgUnitPosition::CORE_POSITION_EMPLOYEE . "
                                and orgu_ua2.position_id = " . ilOrgUnitPosition::CORE_POSITION_SUPERIOR . " 
                                AND " . $DIC->database()->in('orgu_ua.user_id', $arr_empl_user_ids, false, 'integer');

        $st = $DIC->database()->query($sql);

        $empl_id__sup_ids = [];
        while ($data = $DIC->database()->fetchAssoc($st)) {
            $empl_id__sup_ids[$data['empl']][] = $data['sup'];
        }
        $this->arr_empl_user_ids = $empl_id__sup_ids;

        return $empl_id__sup_ids;
    }

Here is the call graph for this function:

getInstance()

static OrgUnit\Positions\UserAssignment\ilOrgUnitUserAssignmentRepository::getInstance ( )

static

Returns

ilOrgUnitUserAssignmentRepository

Definition at line 22 of file class.ilOrgUnitUserAssignmentRepository.php.

References ActiveRecord\where().

    {
        if (!isset(self::$instance)) {
            self::$instance = new self();
        }

        return self::$instance;
    }

Here is the call graph for this function:

getOrgUnitIdsOfUsersPosition()

OrgUnit\Positions\UserAssignment\ilOrgUnitUserAssignmentRepository::getOrgUnitIdsOfUsersPosition	(		$position_id,
			$user_id,
			$recursive = false
	)

Parameters

	$position_id
	$user_id
bool	$recursive

Returns

int[]

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

References ilObjOrgUnitTree\_getInstance(), and ActiveRecord\where().

Referenced by OrgUnit\Positions\UserAssignment\ilOrgUnitUserAssignmentRepository\getUserIdsOfOrgUnitsOfUsersPosition(), and OrgUnit\Positions\UserAssignment\ilOrgUnitUserAssignmentRepository\getUserIdsOfUsersOrgUnitsInPosition().

    {
        $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;
    }

Here is the call graph for this function:

Here is the caller graph for this function:

getUserAssignmentsOfPosition()

OrgUnit\Positions\UserAssignment\ilOrgUnitUserAssignmentRepository::getUserAssignmentsOfPosition

(

$position_id

)

Parameters

$position_id

Returns

ilOrgUnitUserAssignment[]

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

References ActiveRecord\where().

    {
        return ilOrgUnitUserAssignment::where([
            'position_id' => $position_id,
        ])->get();
    }

Here is the call graph for this function:

getUserIdsOfOrgUnit()

OrgUnit\Positions\UserAssignment\ilOrgUnitUserAssignmentRepository::getUserIdsOfOrgUnit

(

$orgunit_ref_id

)

Parameters

$orgunit_ref_id

Returns

ilOrgUnitUserAssignment[]

Definition at line 186 of file class.ilOrgUnitUserAssignmentRepository.php.

References ActiveRecord\where().

    {
        return ilOrgUnitUserAssignment::where(['orgu_id' => $orgunit_ref_id])->getArray(null, 'user_id');
    }

Here is the call graph for this function:

getUserIdsOfOrgUnits()

OrgUnit\Positions\UserAssignment\ilOrgUnitUserAssignmentRepository::getUserIdsOfOrgUnits

(

array

$orgunit_ref_id

)

Parameters

$orgunit_ref_id

Returns

ilOrgUnitUserAssignment[]

Definition at line 197 of file class.ilOrgUnitUserAssignmentRepository.php.

References ActiveRecord\where().

    {
        return ilOrgUnitUserAssignment::where(['orgu_id' => $orgunit_ref_id])->getArray(null, 'user_id');
    }

Here is the call graph for this function:

getUserIdsOfOrgUnitsInPosition()

OrgUnit\Positions\UserAssignment\ilOrgUnitUserAssignmentRepository::getUserIdsOfOrgUnitsInPosition	(	array	$orgu_ids,
			$position_id
	)

Parameters

array	$orgu_ids
	$position_id

Returns

int[]

Definition at line 225 of file class.ilOrgUnitUserAssignmentRepository.php.

References ActiveRecord\where().

    {
        return ilOrgUnitUserAssignment::where([
            'orgu_id' => $orgu_ids,
            'position_id' => $position_id,
        ])->getArray(null, 'user_id');
    }

Here is the call graph for this function:

getUserIdsOfOrgUnitsOfUsersPosition()

OrgUnit\Positions\UserAssignment\ilOrgUnitUserAssignmentRepository::getUserIdsOfOrgUnitsOfUsersPosition	(		$position_id,
			$user_id,
			$recursive = false
	)

Parameters

	$position_id
	$user_id
bool	$recursive

Returns

[]

Definition at line 212 of file class.ilOrgUnitUserAssignmentRepository.php.

References OrgUnit\Positions\UserAssignment\ilOrgUnitUserAssignmentRepository\getOrgUnitIdsOfUsersPosition(), and ActiveRecord\where().

    {
        return ilOrgUnitUserAssignment::where(['orgu_id' => $this->getOrgUnitIdsOfUsersPosition($position_id, $user_id, $recursive)])
            ->getArray(null, 'user_id');
    }

Here is the call graph for this function:

getUserIdsOfPosition()

OrgUnit\Positions\UserAssignment\ilOrgUnitUserAssignmentRepository::getUserIdsOfPosition

(

$position_id

)

Parameters

$position_id

Returns

int[]

Definition at line 286 of file class.ilOrgUnitUserAssignmentRepository.php.

References ActiveRecord\where().

    {
        return ilOrgUnitUserAssignment::where([
            'position_id' => $position_id,
        ])->getArray(null, 'user_id');
    }

Here is the call graph for this function:

getUserIdsOfUsersOrgUnitsInPosition()

OrgUnit\Positions\UserAssignment\ilOrgUnitUserAssignmentRepository::getUserIdsOfUsersOrgUnitsInPosition	(		$user_id,
			$users_position_id,
			$position_id,
			$recursive = false
	)

Parameters

	$user_id
	$users_position_id
	$position_id
bool	$recursive

Returns

int[]

Definition at line 243 of file class.ilOrgUnitUserAssignmentRepository.php.

References OrgUnit\Positions\UserAssignment\ilOrgUnitUserAssignmentRepository\getOrgUnitIdsOfUsersPosition(), and ActiveRecord\where().

    {
        return ilOrgUnitUserAssignment::where([
            'orgu_id' => $this->getOrgUnitIdsOfUsersPosition($users_position_id, $user_id, $recursive),
            'position_id' => $position_id,
        ])->getArray(null, 'user_id');
    }

Here is the call graph for this function:

Field Documentation

$instance

OrgUnit\Positions\UserAssignment\ilOrgUnitUserAssignmentRepository::$instance

staticprotected

Definition at line 16 of file class.ilOrgUnitUserAssignmentRepository.php.

---

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

• Modules/OrgUnit/classes/Positions/UserAssignment/class.ilOrgUnitUserAssignmentRepository.php