ilOrgUnitUserAssignmentQueries Class Reference

This file is part of ILIAS, a powerful learning management system published by ILIAS open source e-Learning e.V. More...

Collaboration diagram for ilOrgUnitUserAssignmentQueries:

Public Member Functions
	getPositionsOfUserId (int $user_id)
	getAssignmentOrFail (int $user_id, int $position_id, int $orgu_id)
	getAssignmentsOfUserId (int $user_id)
	getAssignmentsOfUserIdAndPosition (int $user_id, int $position_id)
	getUserIdsOfOrgUnit (int $orgunit_ref_id)
	getUserIdsOfOrgUnits (array $orgunit_ref_id)
	getUserIdsOfOrgUnitsOfUsersPosition (int $position_id, int $user_id, bool $recursive=false)
	getUserIdsOfOrgUnitsInPosition (array $orgu_ids, int $position_id)
	getUserIdsOfUsersOrgUnitsInPosition (int $user_id, int $users_position_id, int $position_id, bool $recursive=false)
	getOrgUnitIdsOfUsersPosition (int $position_id, int $user_id, bool $recursive=false)
	getUserIdsOfPosition (int $position_id)
	getUserAssignmentsOfPosition (int $position_id)
	deleteAllAssignmentsOfUser (int $user_id)

Static Public Member Functions
static	getInstance ()

Static Protected Attributes
static ilOrgUnitUserAssignmentQueries	$instance

Detailed Description

This file is part of ILIAS, a powerful learning management system published by ILIAS open source e-Learning e.V.

ILIAS is licensed with the GPL-3.0, see https://www.gnu.org/licenses/gpl-3.0.en.html You should have received a copy of said license along with the source code, too.

If this is not the case or you just want to try ILIAS, you'll find us at: https://www.ilias.de https://github.com/ILIAS-eLearning Class ilOrgUnitUserAssignmentQueries

Author

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

Definition at line 23 of file class.ilOrgUnitUserAssignmentQueries.php.

Member Function Documentation

deleteAllAssignmentsOfUser()

ilOrgUnitUserAssignmentQueries::deleteAllAssignmentsOfUser

(

int

$user_id

)

Parameters

int

$user_id

Returns

void

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

References $DIC.

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

getAssignmentOrFail()

ilOrgUnitUserAssignmentQueries::getAssignmentOrFail	(	int	$user_id,
		int	$position_id,
		int	$orgu_id
	)

Exceptions

ilException

Definition at line 52 of file class.ilOrgUnitUserAssignmentQueries.php.

References ActiveRecord\where().

                                                                                     : ilOrgUnitUserAssignment
    {
        $ua = ilOrgUnitUserAssignment::where([
            'user_id' => $user_id,
            'position_id' => $position_id,
            'orgu_id' => $orgu_id,
        ])->first();
        if (!$ua) {
            throw new  ilException('UserAssignement not found');
        }

        assert($ua instanceof ilOrgUnitUserAssignment);
        return $ua;
    }

Here is the call graph for this function:

getAssignmentsOfUserId()

ilOrgUnitUserAssignmentQueries::getAssignmentsOfUserId

(

int

$user_id

)

Returns

ilOrgUnitUserAssignment[]

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

References ActiveRecord\where().

Referenced by getPositionsOfUserId().

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

Here is the call graph for this function:

Here is the caller graph for this function:

getAssignmentsOfUserIdAndPosition()

ilOrgUnitUserAssignmentQueries::getAssignmentsOfUserIdAndPosition	(	int	$user_id,
		int	$position_id
	)

Returns

ilOrgUnitUserAssignment[]

Definition at line 78 of file class.ilOrgUnitUserAssignmentQueries.php.

References ActiveRecord\where().

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

Here is the call graph for this function:

getInstance()

static ilOrgUnitUserAssignmentQueries::getInstance ( )

static

Definition at line 27 of file class.ilOrgUnitUserAssignmentQueries.php.

Referenced by ilOrgUnitPositionAccess\__construct(), ilObjEmployeeTalkAccess\__construct(), ilOrgUnitPositionGUI\assign(), ilOrgUnitPositionGUI\confirmDeletion(), ilOrgUnitUserAssignmentGUI\delete(), ilObjUser\delete(), ilOrgUnitUserAssignmentGUI\deleteRecursive(), ilOrgUnitPosition\deleteWithAllDependencies(), ilObjOrgUnitTree\getEmployees(), ilObjOrgUnitTree\getEmployeesUnderUser(), ILIAS\MyStaff\ilMyStaffAccess\getIdsForUserAndOperation(), ilObjOrgUnitTree\getOrgUnitOfUser(), ILIAS\MyStaff\ilMyStaffAccess\getUsersForUserPerPosition(), ilRepositorySearchGUI\listUsers(), ILIAS\OrgUnit\Webservices\SOAP\UserIdsOfPositionAndOrgUnit\run(), and ILIAS\OrgUnit\Webservices\SOAP\UserIdsOfPosition\run().

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

        return self::$instance;
    }

Here is the caller graph for this function:

getOrgUnitIdsOfUsersPosition()

ilOrgUnitUserAssignmentQueries::getOrgUnitIdsOfUsersPosition	(	int	$position_id,
		int	$user_id,
		bool	$recursive = false
	)

Returns

int[]

Definition at line 153 of file class.ilOrgUnitUserAssignmentQueries.php.

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

Referenced by getUserIdsOfOrgUnitsOfUsersPosition(), and getUserIdsOfUsersOrgUnitsInPosition().

                                                                                                         : array
    {
        $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:

getPositionsOfUserId()

ilOrgUnitUserAssignmentQueries::getPositionsOfUserId

(

int

$user_id

)

Returns

ilOrgUnitPosition[]

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

References getAssignmentsOfUserId().

                                                      : array
    {
        $positions = [];
        foreach ($this->getAssignmentsOfUserId($user_id) as $assignment) {
            $positions[] = ilOrgUnitPosition::find($assignment->getPositionId());
        }

        return $positions;
    }

Here is the call graph for this function:

getUserAssignmentsOfPosition()

ilOrgUnitUserAssignmentQueries::getUserAssignmentsOfPosition

(

int

$position_id

)

Returns

ilOrgUnitUserAssignment[]

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

References ActiveRecord\where().

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

Here is the call graph for this function:

getUserIdsOfOrgUnit()

ilOrgUnitUserAssignmentQueries::getUserIdsOfOrgUnit

(

int

$orgunit_ref_id

)

Parameters

$orgunit_ref_id

Returns

ilOrgUnitUserAssignment[]

Definition at line 92 of file class.ilOrgUnitUserAssignmentQueries.php.

References ActiveRecord\where().

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

Here is the call graph for this function:

getUserIdsOfOrgUnits()

ilOrgUnitUserAssignmentQueries::getUserIdsOfOrgUnits

(

array

$orgunit_ref_id

)

Parameters

int[]

$orgunit_ref_id

Returns

ilOrgUnitUserAssignment[]

Definition at line 102 of file class.ilOrgUnitUserAssignmentQueries.php.

References ActiveRecord\where().

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

Here is the call graph for this function:

getUserIdsOfOrgUnitsInPosition()

ilOrgUnitUserAssignmentQueries::getUserIdsOfOrgUnitsInPosition	(	array	$orgu_ids,
		int	$position_id
	)

Parameters

int[]

$orgu_ids

Returns

int[]

Definition at line 126 of file class.ilOrgUnitUserAssignmentQueries.php.

References ActiveRecord\where().

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

Here is the call graph for this function:

getUserIdsOfOrgUnitsOfUsersPosition()

ilOrgUnitUserAssignmentQueries::getUserIdsOfOrgUnitsOfUsersPosition	(	int	$position_id,
		int	$user_id,
		bool	$recursive = false
	)

Returns

ilOrgUnitUserAssignment[]

Definition at line 111 of file class.ilOrgUnitUserAssignmentQueries.php.

References getOrgUnitIdsOfUsersPosition(), and ActiveRecord\where().

                                                                                                                : array
    {
        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()

ilOrgUnitUserAssignmentQueries::getUserIdsOfPosition

(

int

$position_id

)

Returns

int[]

Definition at line 176 of file class.ilOrgUnitUserAssignmentQueries.php.

References ActiveRecord\where().

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

Here is the call graph for this function:

getUserIdsOfUsersOrgUnitsInPosition()

ilOrgUnitUserAssignmentQueries::getUserIdsOfUsersOrgUnitsInPosition	(	int	$user_id,
		int	$users_position_id,
		int	$position_id,
		bool	$recursive = false
	)

Parameters

int[]

$users_position_id

Returns

int[]

Definition at line 138 of file class.ilOrgUnitUserAssignmentQueries.php.

References getOrgUnitIdsOfUsersPosition(), and ActiveRecord\where().

     : array {
        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

ilOrgUnitUserAssignmentQueries ilOrgUnitUserAssignmentQueries::$instance

staticprotected

Definition at line 25 of file class.ilOrgUnitUserAssignmentQueries.php.

---

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

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