Inheritance diagram for ilOrgUnitUserAssignmentDBRepository:

Collaboration diagram for ilOrgUnitUserAssignmentDBRepository:

Public Member Functions
	__construct (ilDBInterface $db, ?ilAppEventHandler $handler=null)

	get (int $user_id, int $position_id, int $orgu_id)
	Get existing user assignment or create a new one. More...

	find (int $user_id, int $position_id, int $orgu_id)
	Find assignment for user, position and org-unit Does not create new assigment, returns null if no assignment exists. More...

	store (ilOrgUnitUserAssignment $assignment)
	Store assignment to db. More...

	delete (ilOrgUnitUserAssignment $assignment)
	Delete a single assignment Returns false if no assignment was found. More...

	deleteByUser (int $user_id)
	Delete all assignments for a user_id Returns false if no assignments were found. More...

	getByUsers (array $user_ids)
	Get assignments for one or more users. More...

	getByPosition (int $position_id)
	Get all assignments for a position. More...

	getByOrgUnit (int $orgu_id)
	Get all assignments for an org-unit. More...

	getByUserAndPosition (int $user_id, int $position_id)
	Get assignments for a user in a dedicated position. More...

	getUsersByOrgUnits (array $orgu_ids)
	Get all users for a given set of org-units. More...

	getUsersByPosition (int $position_id)
	Get all users with a certain position. More...

	getUsersByOrgUnitsAndPosition (array $orgu_ids, int $position_id)
	Get all users in a specific position for a given set of org-units. More...

	getUsersByUserAndPosition (int $user_id, int $position_id, bool $recursive=false)
	Get all users from org-units where the user has a certain position i.e. More...

	getFilteredUsersByUserAndPosition (int $user_id, int $position_id, int $position_filter_id, bool $recursive=false)
	Get all users with position $position_filter_id from those org-units, where the user has position $position_id i.e. More...

	getOrgUnitsByUser (int $user_id)
	Get all org-units a user is assigned to. More...

	getOrgUnitsByUserAndPosition (int $user_id, int $position_id, bool $recursive=false)
	Get all org-units where a user has a dedicated position. More...

	getPositionsByUser (int $user_id)
	Get all positions a user is assigned to. More...

	getSuperiorsByUsers (array $user_ids)
	Get all superiors of one or more users $user_id => [ $superior_ids ]. More...

	getTotalRowCount (?array $filter_data, ?array $additional_parameters)

	getRows (Table\DataRowBuilder $row_builder, array $visible_column_ids, Range $range, Order $order, ?array $filter_data, ?array $additional_parameters)

Data Fields
const	TABLE_NAME = 'il_orgu_ua'

Protected Member Functions
	getPositionRepo ()

	insert (ilOrgUnitUserAssignment $assignment)

	update (ilOrgUnitUserAssignment $assignment)

	raiseEvent (string $event, ilOrgUnitUserAssignment $assignment)

	getUserDataByOrgUnitsAndPosition (array $orgu_ids, int $position_id, bool $count_only=false, ?Range $range=null, ?Order $order=null)

Protected Attributes
ilDBInterface	$db

ilAppEventHandler	$ilAppEventHandler

ilOrgUnitPositionDBRepository	$positionRepo

Detailed Description

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

Constructor & Destructor Documentation

◆ __construct()

ilOrgUnitUserAssignmentDBRepository::__construct	(	ilDBInterface	$db,
		?ilAppEventHandler	$handler = `null`
	)

Definition at line 32 of file class.ilOrgUnitUserAssignmentDBRepository.php.

References $db, $DIC, and $handler.

     {
         $this->db = $db;
 
         if ($handler) {
             $this->ilAppEventHandler = $handler;
         } else {
             global $DIC;
             $this->ilAppEventHandler = $DIC->event();
         }
     }

Member Function Documentation

◆ delete()

ilOrgUnitUserAssignmentDBRepository::delete ( ilOrgUnitUserAssignment $assignment )

Delete a single assignment Returns false if no assignment was found.

Implements OrgUnitUserAssignmentRepository.

Definition at line 146 of file class.ilOrgUnitUserAssignmentDBRepository.php.

References raiseEvent().

                                                                : bool
     {
         if ($assignment->getId() === 0) {
             return false;
         }
 
         $query = 'DELETE FROM ' . self::TABLE_NAME . PHP_EOL
             . ' WHERE id = ' . $this->db->quote($assignment->getId(), 'integer');
         $rows = $this->db->manipulate($query);
 
         if ($rows > 0) {
             $this->raiseEvent('deassignUserFromPosition', $assignment);
             return true;
         }
 
         return false;
     }

Here is the call graph for this function:

◆ deleteByUser()

ilOrgUnitUserAssignmentDBRepository::deleteByUser ( int $user_id )

Delete all assignments for a user_id Returns false if no assignments were found.

Implements OrgUnitUserAssignmentRepository.

Definition at line 164 of file class.ilOrgUnitUserAssignmentDBRepository.php.

Referenced by ilOrgUnitUserAssignmentQueries\deleteAllAssignmentsOfUser().

                                               : bool
     {
         if ($user_id <= 0) {
             return false;
         }
 
         $query = 'DELETE FROM ' . self::TABLE_NAME . PHP_EOL
             . ' WHERE user_id = ' . $this->db->quote($user_id, 'integer');
         $rows = $this->db->manipulate($query);
 
         if ($rows > 0) {
             return true;
         }
 
         return false;
     }

Here is the caller graph for this function:

◆ find()

ilOrgUnitUserAssignmentDBRepository::find	(	int	$user_id,
		int	$position_id,
		int	$orgu_id
	)

Find assignment for user, position and org-unit Does not create new assigment, returns null if no assignment exists.

Implements OrgUnitUserAssignmentRepository.

Definition at line 79 of file class.ilOrgUnitUserAssignmentDBRepository.php.

References $res, and null.

Referenced by ilOrgUnitUserAssignmentQueries\getAssignmentOrFail().

                                                                       : ?ilOrgUnitUserAssignment
     {
         $query = 'SELECT id, user_id, position_id, orgu_id FROM' . PHP_EOL
             . self::TABLE_NAME
             . ' WHERE ' . self::TABLE_NAME . '.user_id = ' . $this->db->quote($user_id, 'integer') . PHP_EOL
             . ' AND ' . self::TABLE_NAME . '.position_id = ' . $this->db->quote($position_id, 'integer') . PHP_EOL
             . ' AND ' . self::TABLE_NAME . '.orgu_id = ' . $this->db->quote($orgu_id, 'integer');
 
         $res = $this->db->query($query);
         if ($res->numRows() === 0) {
             return null;
         }
 
         $rec = $this->db->fetchAssoc($res);
         return (new ilOrgUnitUserAssignment((int) $rec['id']))
             ->withUserId((int) $rec['user_id'])
             ->withPositionId((int) $rec['position_id'])
             ->withOrguId((int) $rec['orgu_id']);
     }

Here is the caller graph for this function:

◆ get()

ilOrgUnitUserAssignmentDBRepository::get	(	int	$user_id,
		int	$position_id,
		int	$orgu_id
	)

Get existing user assignment or create a new one.

Implements OrgUnitUserAssignmentRepository.

Definition at line 54 of file class.ilOrgUnitUserAssignmentDBRepository.php.

References $res, and store().

                                                                      : ilOrgUnitUserAssignment
     {
         $query = 'SELECT id, user_id, position_id, orgu_id FROM' . PHP_EOL
             . self::TABLE_NAME
             . ' WHERE ' . self::TABLE_NAME . '.user_id = ' . $this->db->quote($user_id, 'integer') . PHP_EOL
             . ' AND ' . self::TABLE_NAME . '.position_id = ' . $this->db->quote($position_id, 'integer') . PHP_EOL
             . ' AND ' . self::TABLE_NAME . '.orgu_id = ' . $this->db->quote($orgu_id, 'integer');
 
         $res = $this->db->query($query);
         if ($res->numRows() > 0) {
             $rec = $this->db->fetchAssoc($res);
             return (new ilOrgUnitUserAssignment((int) $rec['id']))
                 ->withUserId((int) $rec['user_id'])
                 ->withPositionId((int) $rec['position_id'])
                 ->withOrguId((int) $rec['orgu_id']);
         }
 
         $assignment = (new ilOrgUnitUserAssignment())
             ->withUserId($user_id)
             ->withPositionId($position_id)
             ->withOrguId($orgu_id);
         $assignment = $this->store($assignment);
         return $assignment;
     }

Here is the call graph for this function:

◆ getByOrgUnit()

ilOrgUnitUserAssignmentDBRepository::getByOrgUnit ( int $orgu_id )

Get all assignments for an org-unit.

Returns: ilOrgUnitUserAssignment[]

Implements OrgUnitUserAssignmentRepository.

Definition at line 213 of file class.ilOrgUnitUserAssignmentDBRepository.php.

References $res.

                                               : array
     {
         $query = 'SELECT id, user_id, position_id, orgu_id FROM' . PHP_EOL
             . self::TABLE_NAME
             . ' WHERE ' . self::TABLE_NAME . '.orgu_id = ' . $this->db->quote($orgu_id, 'integer');
         $res = $this->db->query($query);
         $ret = [];
         while ($rec = $this->db->fetchAssoc($res)) {
             $ret[] = (new ilOrgUnitUserAssignment((int) $rec['id']))
                 ->withUserId((int) $rec['user_id'])
                 ->withPositionId((int) $rec['position_id'])
                 ->withOrguId((int) $rec['orgu_id']);
         }
         return $ret;
     }

◆ getByPosition()

ilOrgUnitUserAssignmentDBRepository::getByPosition ( int $position_id )

Get all assignments for a position.

Returns: ilOrgUnitUserAssignment[]

Implements OrgUnitUserAssignmentRepository.

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

References $res.

Referenced by ilOrgUnitUserAssignmentQueries\getUserAssignmentsOfPosition().

                                                    : array
     {
         $query = 'SELECT id, user_id, position_id, orgu_id FROM' . PHP_EOL
             . self::TABLE_NAME
             . ' WHERE ' . self::TABLE_NAME . '.position_id = ' . $this->db->quote($position_id, 'integer');
         $res = $this->db->query($query);
         $ret = [];
         while ($rec = $this->db->fetchAssoc($res)) {
             $ret[] = (new ilOrgUnitUserAssignment((int) $rec['id']))
                 ->withUserId((int) $rec['user_id'])
                 ->withPositionId((int) $rec['position_id'])
                 ->withOrguId((int) $rec['orgu_id']);
         }
         return $ret;
     }

Here is the caller graph for this function:

◆ getByUserAndPosition()

ilOrgUnitUserAssignmentDBRepository::getByUserAndPosition	(	int	$user_id,
		int	$position_id
	)

Get assignments for a user in a dedicated position.

Returns: ilOrgUnitUserAssignment[]

Implements OrgUnitUserAssignmentRepository.

Definition at line 230 of file class.ilOrgUnitUserAssignmentDBRepository.php.

References $res.

Referenced by ilOrgUnitUserAssignmentQueries\getAssignmentsOfUserIdAndPosition().

                                                                         : array
     {
         $query = 'SELECT id, user_id, position_id, orgu_id FROM' . PHP_EOL
             . self::TABLE_NAME
             . ' WHERE ' . self::TABLE_NAME . '.user_id = ' . $this->db->quote($user_id, 'integer') . PHP_EOL
             . ' AND ' . self::TABLE_NAME . '.position_id = ' . $this->db->quote($position_id, 'integer');
         $res = $this->db->query($query);
         $ret = [];
         while ($rec = $this->db->fetchAssoc($res)) {
             $ret[] = (new ilOrgUnitUserAssignment((int) $rec['id']))
                 ->withUserId((int) $rec['user_id'])
                 ->withPositionId((int) $rec['position_id'])
                 ->withOrguId((int) $rec['orgu_id']);
         }
         return $ret;
     }

Here is the caller graph for this function:

◆ getByUsers()

ilOrgUnitUserAssignmentDBRepository::getByUsers ( array $user_ids )

Get assignments for one or more users.

Parameters

int[] $user_ids

Returns: ilOrgUnitUserAssignment[]

Implements OrgUnitUserAssignmentRepository.

Definition at line 181 of file class.ilOrgUnitUserAssignmentDBRepository.php.

References $res.

Referenced by ilOrgUnitUserAssignmentQueries\getAssignmentsOfUserId(), and ilOrgUnitUserAssignmentQueries\getAssignmentsOfUserIds().

                                                : array
     {
         $query = 'SELECT id, user_id, position_id, orgu_id FROM' . PHP_EOL
             . self::TABLE_NAME
             . ' WHERE ' . $this->db->in('user_id', $user_ids, false, 'integer');
         $res = $this->db->query($query);
         $ret = [];
         while ($rec = $this->db->fetchAssoc($res)) {
             $ret[] = (new ilOrgUnitUserAssignment((int) $rec['id']))
                 ->withUserId((int) $rec['user_id'])
                 ->withPositionId((int) $rec['position_id'])
                 ->withOrguId((int) $rec['orgu_id']);
         }
         return $ret;
     }

Here is the caller graph for this function:

◆ getFilteredUsersByUserAndPosition()

ilOrgUnitUserAssignmentDBRepository::getFilteredUsersByUserAndPosition	(	int	$user_id,
		int	$position_id,
		int	$position_filter_id,
		bool	$recursive = `false`
	)

Get all users with position $position_filter_id from those org-units, where the user has position $position_id i.e.

all employees of all org-units where the user is a superior

Returns: int[]

Implements OrgUnitUserAssignmentRepository.

Definition at line 302 of file class.ilOrgUnitUserAssignmentDBRepository.php.

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

Referenced by ilOrgUnitUserAssignmentQueries\getUserIdsOfUsersOrgUnitsInPosition().

                                                                                                                                        : array
     {
         $orgu_ids = $this->getOrgUnitsByUserAndPosition($user_id, $position_id, $recursive);
 
         $query = 'SELECT user_id FROM' . PHP_EOL
             . self::TABLE_NAME
             . ' WHERE ' . $this->db->in(self::TABLE_NAME . '.orgu_id', $orgu_ids, false, 'integer') . PHP_EOL
             . ' AND ' . self::TABLE_NAME . '.position_id = ' . $this->db->quote($position_filter_id, 'integer');
         $res = $this->db->query($query);
         $users = [];
         while ($rec = $this->db->fetchAssoc($res)) {
             $users[] = (int) $rec['user_id'];
         }
         return $users;
     }

Here is the call graph for this function:

Here is the caller graph for this function:

◆ getOrgUnitsByUser()

ilOrgUnitUserAssignmentDBRepository::getOrgUnitsByUser ( int $user_id )

Get all org-units a user is assigned to.

Returns: int[]

Implements OrgUnitUserAssignmentRepository.

Definition at line 318 of file class.ilOrgUnitUserAssignmentDBRepository.php.

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

Referenced by ilOrgUnitUserAssignmentQueries\getOrgUnitIdsofUser().

                                                    : array
     {
         $query = 'SELECT orgu_id FROM' . PHP_EOL
             . self::TABLE_NAME
             . ' WHERE ' . self::TABLE_NAME . '.user_id = ' . $this->db->quote($user_id, 'integer');
         $res = $this->db->query($query);
         $orgu_ids = [];
         while ($rec = $this->db->fetchAssoc($res)) {
             $orgu_ids[] = (int) $rec['orgu_id'];
         }
         return $orgu_ids;
     }

Here is the call graph for this function:

Here is the caller graph for this function:

◆ getOrgUnitsByUserAndPosition()

ilOrgUnitUserAssignmentDBRepository::getOrgUnitsByUserAndPosition	(	int	$user_id,
		int	$position_id,
		bool	$recursive = `false`
	)

Get all org-units where a user has a dedicated position.

Returns: int[]

Implements OrgUnitUserAssignmentRepository.

Definition at line 331 of file class.ilOrgUnitUserAssignmentDBRepository.php.

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

Referenced by getFilteredUsersByUserAndPosition(), ilOrgUnitUserAssignmentQueries\getOrgUnitIdsOfUsersPosition(), and getUsersByUserAndPosition().

                                                                                                          : array
     {
         $query = 'SELECT orgu_id FROM' . PHP_EOL
             . self::TABLE_NAME
             . ' WHERE ' . self::TABLE_NAME . '.user_id = ' . $this->db->quote($user_id, 'integer') . PHP_EOL
             . ' AND ' . self::TABLE_NAME . '.position_id = ' . $this->db->quote($position_id, 'integer');
         $res = $this->db->query($query);
         $orgu_ids = [];
         while ($rec = $this->db->fetchAssoc($res)) {
             $orgu_ids[] = (int) $rec['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:

◆ getPositionRepo()

ilOrgUnitUserAssignmentDBRepository::getPositionRepo ( )

protected

Definition at line 44 of file class.ilOrgUnitUserAssignmentDBRepository.php.

References $dic, $positionRepo, and ilOrgUnitLocalDIC\dic().

Referenced by getPositionsByUser().

                                         : \ilOrgUnitPositionDBRepository
     {
         if (!isset($this->positionRepo)) {
             $dic = \ilOrgUnitLocalDIC::dic();
             $this->positionRepo = $dic["repo.Positions"];
         }
 
         return $this->positionRepo;
     }

Here is the call graph for this function:

Here is the caller graph for this function:

◆ getPositionsByUser()

ilOrgUnitUserAssignmentDBRepository::getPositionsByUser ( int $user_id )

Get all positions a user is assigned to.

Returns: ilOrgUnitPosition[]

Implements OrgUnitUserAssignmentRepository.

Definition at line 356 of file class.ilOrgUnitUserAssignmentDBRepository.php.

References $res, and getPositionRepo().

Referenced by ilOrgUnitUserAssignmentQueries\getPositionsOfUserId().

                                                     : array
     {
         $query = 'SELECT DISTINCT position_id FROM' . PHP_EOL
             . self::TABLE_NAME
             . ' WHERE ' . self::TABLE_NAME . '.user_id = ' . $this->db->quote($user_id, 'integer');
         $res = $this->db->query($query);
 
         $positions = [];
         while ($rec = $this->db->fetchAssoc($res)) {
             $positions[] = $this->getPositionRepo()->getSingle((int) $rec['position_id'], 'id');
         }
         return $positions;
     }

Here is the call graph for this function:

Here is the caller graph for this function:

◆ getRows()

ilOrgUnitUserAssignmentDBRepository::getRows	(	Table\DataRowBuilder	$row_builder,
		array	$visible_column_ids,
		Range	$range,
		Order	$order,
		?array	$filter_data,
		?array	$additional_parameters
	)

Definition at line 450 of file class.ilOrgUnitUserAssignmentDBRepository.php.

References ilObjUserTracking\_enabledLearningProgress(), ilObjUserTracking\_enabledUserRelatedData(), and getUserDataByOrgUnitsAndPosition().

      : \Generator {
         $orgu_ids = $additional_parameters['orgu_ids'];
         $position_id = $additional_parameters['position_id'];
         $lp_visible = $additional_parameters['lp_visible_ref_ids'];
         $write_access = $additional_parameters['write_access'];
 
         foreach ($this->getUserDataByOrgUnitsAndPosition($orgu_ids, $position_id, false, $range, $order) as $record) {
             $row_id = implode('_', [(string) $position_id, (string) $record['usr_id']]);
             yield $row_builder->buildDataRow($row_id, $record)
                 ->withDisabledAction(
                     'show_learning_progress',
                     !(
                         in_array($record['orgu_id'], $lp_visible)
                         && ilObjUserTracking::_enabledLearningProgress()
                         && ilObjUserTracking::_enabledUserRelatedData()
                     )
                 )
                 ->withDisabledAction(
                     'remove',
                     !$write_access
                 );
 
         }
     }

Here is the call graph for this function:

◆ getSuperiorsByUsers()

ilOrgUnitUserAssignmentDBRepository::getSuperiorsByUsers ( array $user_ids )

Get all superiors of one or more users $user_id => [ $superior_ids ].

Parameters

int[] $user_ids

Returns: int[]

Implements OrgUnitUserAssignmentRepository.

Definition at line 370 of file class.ilOrgUnitUserAssignmentDBRepository.php.

References $res, ilOrgUnitPosition\CORE_POSITION_EMPLOYEE, and ilOrgUnitPosition\CORE_POSITION_SUPERIOR.

                                                         : array
     {
         $query = 'SELECT ' . PHP_EOL
             . ' ua.orgu_id AS orgu_id,' . PHP_EOL
             . ' ua.user_id AS empl,' . PHP_EOL
             . ' ua2.user_id as sup' . PHP_EOL
             . ' FROM' . PHP_EOL
             . self::TABLE_NAME . ' as ua,' . PHP_EOL
             . self::TABLE_NAME . ' as ua2' . PHP_EOL
             . ' WHERE ua.orgu_id = ua2.orgu_id' . PHP_EOL
             . ' AND ua.user_id <> ua2.user_id' . PHP_EOL
             . ' AND ua.position_id = ' . $this->db->quote(ilOrgUnitPosition::CORE_POSITION_EMPLOYEE, 'integer') . PHP_EOL
             . ' AND ua2.position_id = ' . $this->db->quote(ilOrgUnitPosition::CORE_POSITION_SUPERIOR, 'integer') . PHP_EOL
             . ' AND ' . $this->db->in('ua.user_id', $user_ids, false, 'integer');
         $res = $this->db->query($query);
         if ($res->numRows() === 0) {
             return [];
         }
 
         $ret = [];
         while ($rec = $this->db->fetchAssoc($res)) {
             $ret[$rec['empl']][] = $rec['sup'];
         }
         return $ret;
     }

◆ getTotalRowCount()

ilOrgUnitUserAssignmentDBRepository::getTotalRowCount	(	?array	$filter_data,
		?array	$additional_parameters
	)

Definition at line 441 of file class.ilOrgUnitUserAssignmentDBRepository.php.

References getUserDataByOrgUnitsAndPosition().

      : ?int {
         $orgu_ids = $additional_parameters['orgu_ids'];
         $position_id = $additional_parameters['position_id'];
         return $this->getUserDataByOrgUnitsAndPosition($orgu_ids, $position_id, true);
     }

Here is the call graph for this function:

◆ getUserDataByOrgUnitsAndPosition()

ilOrgUnitUserAssignmentDBRepository::getUserDataByOrgUnitsAndPosition	(	array	$orgu_ids,
		int	$position_id,
		bool	$count_only = `false`,
		?Range	$range = `null`,
		?Order	$order = `null`
	)

protected

Definition at line 405 of file class.ilOrgUnitUserAssignmentDBRepository.php.

References ILIAS\UI\Implementation\Component\Table\$range, $res, and ILIAS\Data\Range\unpack().

Referenced by getRows(), and getTotalRowCount().

       {
         $sql_order_part = $order ? $order->join('ORDER BY', fn(...$o) => implode(' ', $o)) : '';
         $sql_range_part = $range ? sprintf('LIMIT %2$s OFFSET %1$s', ...$range->unpack()) : '';
 
         $query = 'SELECT usr_id, login, firstname, lastname, active, orgu_id' . PHP_EOL
             . ', GROUP_CONCAT (od.title SEPARATOR ", ") as orgu_title ' . PHP_EOL
             . 'FROM ' . self::TABLE_NAME . PHP_EOL
             . 'JOIN usr_data ud on ud.usr_id = user_id' . PHP_EOL
             . 'JOIN object_reference oref on oref.ref_id = orgu_id' . PHP_EOL
             . 'JOIN object_data od on od.obj_id = oref.obj_id' . PHP_EOL
             . 'WHERE ' . $this->db->in(self::TABLE_NAME . '.orgu_id', $orgu_ids, false, 'integer') . PHP_EOL
             . 'AND ' . self::TABLE_NAME . '.position_id = ' . $this->db->quote($position_id, 'integer') . PHP_EOL
             . 'group by login' . PHP_EOL
             . $sql_order_part . PHP_EOL
             . $sql_range_part . PHP_EOL
         ;
         $res = $this->db->query($query);
 
         if ($count_only) {
             return $this->db->numRows($res);
         }
 
         $users = [];
         while ($rec = $this->db->fetchAssoc($res)) {
             $rec['active'] = (bool) $rec['active'];
             $users[] = $rec;
         }
         return $users;
     }

Here is the call graph for this function:

Here is the caller graph for this function:

◆ getUsersByOrgUnits()

ilOrgUnitUserAssignmentDBRepository::getUsersByOrgUnits ( array $orgu_ids )

Get all users for a given set of org-units.

Parameters

int[] $orgu_ids

Returns: int[]

Implements OrgUnitUserAssignmentRepository.

Definition at line 247 of file class.ilOrgUnitUserAssignmentDBRepository.php.

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

Referenced by ilOrgUnitUserAssignmentQueries\getUserIdsOfOrgUnit(), and ilOrgUnitUserAssignmentQueries\getUserIdsOfOrgUnits().

                                                        : array
     {
         $query = 'SELECT user_id FROM' . PHP_EOL
             . self::TABLE_NAME
             . ' WHERE ' . $this->db->in(self::TABLE_NAME . '.orgu_id', $orgu_ids, false, 'integer');
         $res = $this->db->query($query);
         $users = [];
         while ($rec = $this->db->fetchAssoc($res)) {
             $users[] = (int) $rec['user_id'];
         }
         return $users;
     }

Here is the call graph for this function:

Here is the caller graph for this function:

◆ getUsersByOrgUnitsAndPosition()

ilOrgUnitUserAssignmentDBRepository::getUsersByOrgUnitsAndPosition	(	array	$orgu_ids,
		int	$position_id
	)

Get all users in a specific position for a given set of org-units.

Parameters

int[] $orgu_ids

Returns: int[]

Implements OrgUnitUserAssignmentRepository.

Definition at line 273 of file class.ilOrgUnitUserAssignmentDBRepository.php.

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

Referenced by ilOrgUnitUserAssignmentQueries\getUserIdsOfOrgUnitsInPosition().

                                                                                     : array
     {
         $query = 'SELECT user_id FROM' . PHP_EOL
             . self::TABLE_NAME
             . ' WHERE ' . $this->db->in(self::TABLE_NAME . '.orgu_id', $orgu_ids, false, 'integer') . PHP_EOL
             . ' AND ' . self::TABLE_NAME . '.position_id = ' . $this->db->quote($position_id, 'integer');
         $res = $this->db->query($query);
         $users = [];
         while ($rec = $this->db->fetchAssoc($res)) {
             $users[] = (int) $rec['user_id'];
         }
         return $users;
     }

Here is the call graph for this function:

Here is the caller graph for this function:

◆ getUsersByPosition()

ilOrgUnitUserAssignmentDBRepository::getUsersByPosition ( int $position_id )

Get all users with a certain position.

Returns: int[]

Implements OrgUnitUserAssignmentRepository.

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

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

Referenced by ilOrgUnitUserAssignmentQueries\getUserIdsOfPosition().

                                                         : array
     {
         $query = 'SELECT user_id FROM' . PHP_EOL
             . self::TABLE_NAME
             . ' WHERE ' . self::TABLE_NAME . '.position_id = ' . $this->db->quote($position_id, 'integer');
         $res = $this->db->query($query);
         $users = [];
         while ($rec = $this->db->fetchAssoc($res)) {
             $users[] = (int) $rec['user_id'];
         }
         return $users;
     }

Here is the call graph for this function:

Here is the caller graph for this function:

◆ getUsersByUserAndPosition()

ilOrgUnitUserAssignmentDBRepository::getUsersByUserAndPosition	(	int	$user_id,
		int	$position_id,
		bool	$recursive = `false`
	)

Get all users from org-units where the user has a certain position i.e.

all users from all org-units where the user is an employee

Returns: int[]

Implements OrgUnitUserAssignmentRepository.

Definition at line 287 of file class.ilOrgUnitUserAssignmentDBRepository.php.

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

Referenced by ilOrgUnitUserAssignmentQueries\getUserIdsOfOrgUnitsOfUsersPosition().

                                                                                                       : array
     {
         $orgu_ids = $this->getOrgUnitsByUserAndPosition($user_id, $position_id, $recursive);
 
         $query = 'SELECT user_id FROM' . PHP_EOL
             . self::TABLE_NAME
             . ' WHERE ' . $this->db->in(self::TABLE_NAME . '.orgu_id', $orgu_ids, false, 'integer');
         $res = $this->db->query($query);
         $users = [];
         while ($rec = $this->db->fetchAssoc($res)) {
             $users[] = (int) $rec['user_id'];
         }
         return $users;
     }

Here is the call graph for this function:

Here is the caller graph for this function:

◆ insert()

ilOrgUnitUserAssignmentDBRepository::insert ( ilOrgUnitUserAssignment $assignment )

protected

Definition at line 112 of file class.ilOrgUnitUserAssignmentDBRepository.php.

References $id, ilOrgUnitUserAssignment\getOrguId(), ilOrgUnitUserAssignment\getPositionId(), and ilOrgUnitUserAssignment\getUserId().

Referenced by store().

                                                                   : ilOrgUnitUserAssignment
     {
         $id = $this->db->nextId(self::TABLE_NAME);
 
         $values = [
             'id' => [ 'integer', $id ],
             'user_id' => [ 'integer', $assignment->getUserId() ],
             'position_id' => [ 'integer', $assignment->getPositionId() ],
             'orgu_id' => [ 'integer', $assignment->getOrguId() ]
         ];
 
         $this->db->insert(self::TABLE_NAME, $values);
 
         $ret = (new ilOrgUnitUserAssignment($id))
             ->withUserId($assignment->getUserId())
             ->withPositionId($assignment->getPositionId())
             ->withOrguId($assignment->getOrguId());
 
         return $ret;
     }

Here is the call graph for this function:

Here is the caller graph for this function:

◆ raiseEvent()

ilOrgUnitUserAssignmentDBRepository::raiseEvent	(	string	$event,
		ilOrgUnitUserAssignment	$assignment
	)

protected

Definition at line 396 of file class.ilOrgUnitUserAssignmentDBRepository.php.

References ilOrgUnitUserAssignment\getOrguId(), ilOrgUnitUserAssignment\getPositionId(), ilOrgUnitUserAssignment\getUserId(), and ilAppEventHandler\raise().

Referenced by delete(), and store().

                                                                                      : void
     {
         $this->ilAppEventHandler->raise('components/ILIAS/OrgUnit', $event, array(
             'obj_id' => $assignment->getOrguId(),
             'usr_id' => $assignment->getUserId(),
             'position_id' => $assignment->getPositionId()
         ));
     }

Here is the call graph for this function:

Here is the caller graph for this function:

◆ store()

ilOrgUnitUserAssignmentDBRepository::store ( ilOrgUnitUserAssignment $assignment )

Store assignment to db.

Implements OrgUnitUserAssignmentRepository.

Definition at line 99 of file class.ilOrgUnitUserAssignmentDBRepository.php.

References ilOrgUnitUserAssignment\getId(), insert(), raiseEvent(), and update().

Referenced by get().

                                                               : ilOrgUnitUserAssignment
     {
         if ($assignment->getId() === 0) {
             $assignment = $this->insert($assignment);
         } else {
             $this->update($assignment);
         }
 
         $this->raiseEvent('assignUserToPosition', $assignment);
 
         return $assignment;
     }

Here is the call graph for this function:

Here is the caller graph for this function:

◆ update()

ilOrgUnitUserAssignmentDBRepository::update ( ilOrgUnitUserAssignment $assignment )

protected

Definition at line 133 of file class.ilOrgUnitUserAssignmentDBRepository.php.

References ilOrgUnitUserAssignment\getId(), ilOrgUnitUserAssignment\getOrguId(), ilOrgUnitUserAssignment\getPositionId(), and ilOrgUnitUserAssignment\getUserId().

Referenced by store().

                                                                   : void
     {
         $where = [ 'id' => [ 'integer', $assignment->getId() ] ];
 
         $values = [
             'user_id' => [ 'integer', $assignment->getUserId() ],
             'position_id' => [ 'integer', $assignment->getPositionId(),
             'orgu_id' => [ 'integer', $assignment->getOrguId() ]]
         ];
 
         $this->db->update(self::TABLE_NAME, $values, $where);
     }

Here is the call graph for this function:

Here is the caller graph for this function:

Field Documentation

◆ $db

ilDBInterface ilOrgUnitUserAssignmentDBRepository::$db

protected

Definition at line 28 of file class.ilOrgUnitUserAssignmentDBRepository.php.

Referenced by __construct().

◆ $ilAppEventHandler

ilAppEventHandler ilOrgUnitUserAssignmentDBRepository::$ilAppEventHandler

protected

Definition at line 29 of file class.ilOrgUnitUserAssignmentDBRepository.php.

◆ $positionRepo

ilOrgUnitPositionDBRepository ilOrgUnitUserAssignmentDBRepository::$positionRepo

protected

Definition at line 30 of file class.ilOrgUnitUserAssignmentDBRepository.php.

Referenced by getPositionRepo().

◆ TABLE_NAME

const ilOrgUnitUserAssignmentDBRepository::TABLE_NAME = 'il_orgu_ua'

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

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

components/ILIAS/OrgUnit/classes/Positions/UserAssignment/class.ilOrgUnitUserAssignmentDBRepository.php

Public Member Functions

Data Fields

Protected Member Functions

Protected Attributes

Detailed Description

Constructor & Destructor Documentation

◆ __construct()

Member Function Documentation

◆ delete()

◆ deleteByUser()

◆ find()

◆ get()

◆ getByOrgUnit()

◆ getByPosition()

◆ getByUserAndPosition()

◆ getByUsers()

◆ getFilteredUsersByUserAndPosition()

◆ getOrgUnitsByUser()

◆ getOrgUnitsByUserAndPosition()

◆ getPositionRepo()

◆ getPositionsByUser()

◆ getRows()

◆ getSuperiorsByUsers()

◆ getTotalRowCount()

◆ getUserDataByOrgUnitsAndPosition()

◆ getUsersByOrgUnits()

◆ getUsersByOrgUnitsAndPosition()

◆ getUsersByPosition()

◆ getUsersByUserAndPosition()

◆ insert()

◆ raiseEvent()

◆ store()

◆ update()

Field Documentation

◆ $db

◆ $ilAppEventHandler

◆ $positionRepo

◆ TABLE_NAME