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)

	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...

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.

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

References $db, $DIC, and $handler.

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.

                                                               : 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;
    }

References raiseEvent().

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.

                                              : 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;
    }

References $user_id.

Referenced by ilOrgUnitUserAssignmentQueries\deleteAllAssignmentsOfUser().

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.

                                                                      : ?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']);
    }

References $res, and $user_id.

Referenced by ilOrgUnitUserAssignmentQueries\getAssignmentOrFail().

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.

                                                                     : 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;
    }

References $res, $user_id, and store().

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.

                                              : 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;
    }

References $res.

◆ 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.

                                                   : 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;
    }

References $res.

Referenced by ilOrgUnitUserAssignmentQueries\getUserAssignmentsOfPosition().

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.

                                                                        : 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;
    }

References $res, and $user_id.

Referenced by ilOrgUnitUserAssignmentQueries\getAssignmentsOfUserIdAndPosition().

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.

                                               : 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;
    }

References $res.

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

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.

                                                                                                                                       : 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;
    }

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

Referenced by ilOrgUnitUserAssignmentQueries\getUserIdsOfUsersOrgUnitsInPosition().

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.

                                                   : 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;
    }

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

Referenced by ilOrgUnitUserAssignmentQueries\getOrgUnitIdsofUser().

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.

                                                                                                         : 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 = array_merge($recursive_orgu_ids, $tree->getAllChildren($orgu_id));
        }
        return $recursive_orgu_ids;
    }

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

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

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.

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

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

Referenced by getPositionsByUser().

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 355 of file class.ilOrgUnitUserAssignmentDBRepository.php.

                                                    : 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;
    }

References $res, $user_id, and getPositionRepo().

Referenced by ilOrgUnitUserAssignmentQueries\getPositionsOfUserId().

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 449 of file class.ilOrgUnitUserAssignmentDBRepository.php.

     : \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
                );
 
        }
    }

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

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 369 of file class.ilOrgUnitUserAssignmentDBRepository.php.

                                                        : 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;
    }

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

◆ getTotalRowCount()

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

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

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

◆ getUserDataByOrgUnitsAndPosition()

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

protected

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

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

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

Here is the call 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.

                                                       : 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;
    }

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

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

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.

                                                                                    : 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;
    }

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

Referenced by ilOrgUnitUserAssignmentQueries\getUserIdsOfOrgUnitsInPosition().

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.

                                                        : 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;
    }

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

Referenced by ilOrgUnitUserAssignmentQueries\getUserIdsOfPosition().

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.

                                                                                                      : 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;
    }

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

Referenced by ilOrgUnitUserAssignmentQueries\getUserIdsOfOrgUnitsOfUsersPosition().

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.

                                                                  : 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;
    }

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

Referenced by store().

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 395 of file class.ilOrgUnitUserAssignmentDBRepository.php.

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

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

Referenced by delete(), and store().

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.

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

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

Referenced by get().

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.

                                                                  : 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);
    }

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

Referenced by store().

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