OrgUnit\User\ilOrgUnitUserRepository Class Reference

Class ilOrgUnitUserRepository. More...

Collaboration diagram for OrgUnit\User\ilOrgUnitUserRepository:

Public Member Functions
	__construct ()
	ilOrgUnitUserRepository constructor. More...
	withSuperiors ()
	withPositions ()
	getOrgUnitUsers (array $arr_user_id)
	getOrgUnitUser (int $user_id)
	loadSuperiors (array $user_ids)
	getEmailAdressesOfSuperiors (array $user_ids)
	loadPositions (array $user_ids)

Protected Member Functions
	getAssignmentRepo ()
	getSuperiorsSql (array $user_ids)

Protected Attributes
ILIAS DI Container	$dic
ilOrgUnitPositionDBRepository	$positionRepo
array	$orgu_users
bool	$with_superiors = false
bool	$with_positions = false
ilOrgUnitUserAssignmentDBRepository	$assignmentRepo

Static Protected Attributes
static array	$instance

Private Member Functions
	getPositionRepo ()
	loadUsersByUserIds (array $user_ids)

Detailed Description

Class ilOrgUnitUserRepository.

Author

: Martin Studer ms@st.nosp@m.uder.nosp@m.-raim.nosp@m.ann..nosp@m.ch

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

Constructor & Destructor Documentation

__construct()

OrgUnit\User\ilOrgUnitUserRepository::__construct

(

)

ilOrgUnitUserRepository constructor.

Definition at line 48 of file class.ilOrgUnitUserRepository.php.

References $DIC.

    {
        global $DIC;
        $this->dic = $DIC;
    }

Member Function Documentation

getAssignmentRepo()

OrgUnit\User\ilOrgUnitUserRepository::getAssignmentRepo ( )

protected

Definition at line 64 of file class.ilOrgUnitUserRepository.php.

References OrgUnit\User\ilOrgUnitUserRepository\$assignmentRepo, and ilOrgUnitLocalDIC\dic().

Referenced by OrgUnit\User\ilOrgUnitUserRepository\loadPositions().

                                          : \ilOrgUnitUserAssignmentDBRepository
    {
        if (!isset($this->assignmentRepo)) {
            $dic = \ilOrgUnitLocalDIC::dic();
            $this->assignmentRepo = $dic["repo.UserAssignments"];
        }

        return $this->assignmentRepo;
    }

Here is the call graph for this function:

Here is the caller graph for this function:

getEmailAdressesOfSuperiors()

OrgUnit\User\ilOrgUnitUserRepository::getEmailAdressesOfSuperiors

(

array

$user_ids

)

Parameters

array

$user_ids

Returns

array

Definition at line 158 of file class.ilOrgUnitUserRepository.php.

References $data, $DIC, and OrgUnit\User\ilOrgUnitUserRepository\getSuperiorsSql().

                                                                : array
    {
        global $DIC;

        $st = $DIC->database()->query($this->getSuperiorsSql($user_ids));

        $arr_email_sup = [];
        while ($data = $DIC->database()->fetchAssoc($st)) {
            $arr_email_sup[] = $data['sup_email'];
        }

        return $arr_email_sup;
    }

Here is the call graph for this function:

getOrgUnitUser()

OrgUnit\User\ilOrgUnitUserRepository::getOrgUnitUser

(

int

$user_id

)

Parameters

int

$user_id

Returns

ilOrgUnitUser|null

Definition at line 117 of file class.ilOrgUnitUserRepository.php.

References OrgUnit\User\ilOrgUnitUserRepository\loadSuperiors(), OrgUnit\User\ilOrgUnitUserRepository\loadUsersByUserIds(), and null.

                                                : ?ilOrgUnitUser
    {
        $this->orgu_users = $this->loadUsersByUserIds([$user_id]);

        if (count($this->orgu_users) == 0) {
            return null;
        }

        if ($this->with_superiors === true) {
            $this->loadSuperiors([$user_id]);
        }

        return $this->orgu_users[0];
    }

Here is the call graph for this function:

getOrgUnitUsers()

OrgUnit\User\ilOrgUnitUserRepository::getOrgUnitUsers

(

array

$arr_user_id

)

Parameters

array

$arr_user_id

Returns

array

Definition at line 98 of file class.ilOrgUnitUserRepository.php.

References OrgUnit\User\ilOrgUnitUserRepository\$orgu_users, OrgUnit\User\ilOrgUnitUserRepository\loadPositions(), OrgUnit\User\ilOrgUnitUserRepository\loadSuperiors(), and OrgUnit\User\ilOrgUnitUserRepository\loadUsersByUserIds().

                                                       : array
    {
        $this->orgu_users = $this->loadUsersByUserIds($arr_user_id);

        if ($this->with_superiors === true) {
            $this->loadSuperiors($arr_user_id);
        }

        if ($this->with_positions === true) {
            $this->loadPositions($arr_user_id);
        }

        return $this->orgu_users;
    }

Here is the call graph for this function:

getPositionRepo()

OrgUnit\User\ilOrgUnitUserRepository::getPositionRepo ( )

private

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

References OrgUnit\User\ilOrgUnitUserRepository\$positionRepo, and ilOrgUnitLocalDIC\dic().

Referenced by OrgUnit\User\ilOrgUnitUserRepository\loadPositions().

                                      : \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:

getSuperiorsSql()

OrgUnit\User\ilOrgUnitUserRepository::getSuperiorsSql ( array  $user_ids )

protected

Parameters

array

$user_ids

Returns

string

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

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

Referenced by OrgUnit\User\ilOrgUnitUserRepository\getEmailAdressesOfSuperiors(), and OrgUnit\User\ilOrgUnitUserRepository\loadSuperiors().

                                                       : string
    {
        global $DIC;

        $sql = "SELECT 
                                orgu_ua.orgu_id AS orgu_id,
                                orgu_ua.user_id AS empl_usr_id,
                                orgu_ua2.user_id as sup_usr_id,
                                superior.email as sup_email,
                                superior.second_email as sup_second_email,
                                superior.login as sup_login
                                FROM
                                il_orgu_ua as orgu_ua,
                                il_orgu_ua as orgu_ua2
                                inner join usr_data as superior on superior.usr_id = orgu_ua2.user_id
                                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', $user_ids, false, 'integer');

        return $sql;
    }

Here is the caller graph for this function:

loadPositions()

OrgUnit\User\ilOrgUnitUserRepository::loadPositions

(

array

$user_ids

)

Definition at line 201 of file class.ilOrgUnitUserRepository.php.

References OrgUnit\User\ilOrgUnitUserRepository\getAssignmentRepo(), OrgUnit\User\ilOrgUnitUser\getInstanceById(), and OrgUnit\User\ilOrgUnitUserRepository\getPositionRepo().

Referenced by OrgUnit\User\ilOrgUnitUserRepository\getOrgUnitUsers().

                                                  : void
    {
        $assignments = $this->getAssignmentRepo()
            ->getByUsers($user_ids);
        foreach ($assignments as $assignment) {
            $org_unit_user = ilOrgUnitUser::getInstanceById($assignment->getUserId());
            $org_unit_user->addPositions($this->getPositionRepo()->getSingle($assignment->getPositionId(), 'id'));
        }
    }

Here is the call graph for this function:

Here is the caller graph for this function:

loadSuperiors()

OrgUnit\User\ilOrgUnitUserRepository::loadSuperiors

(

array

$user_ids

)

Parameters

array

$user_ids

Definition at line 135 of file class.ilOrgUnitUserRepository.php.

References $data, $DIC, OrgUnit\User\ilOrgUnitUser\getInstance(), OrgUnit\User\ilOrgUnitUser\getInstanceById(), and OrgUnit\User\ilOrgUnitUserRepository\getSuperiorsSql().

Referenced by OrgUnit\User\ilOrgUnitUserRepository\getOrgUnitUser(), and OrgUnit\User\ilOrgUnitUserRepository\getOrgUnitUsers().

                                                  : void
    {
        global $DIC;

        $st = $DIC->database()->query($this->getSuperiorsSql($user_ids));

        $empl_id_sup_ids = [];
        while ($data = $DIC->database()->fetchAssoc($st)) {
            $org_unit_user = ilOrgUnitUser::getInstanceById($data['empl_usr_id']);
            $superior = ilOrgUnitUser::getInstance(
                $data['sup_usr_id'],
                (string) $data['sup_login'],
                (string) $data['sup_email'],
                (string) $data['sup_second_email']
            );
            $org_unit_user->addSuperior($superior);
        }
    }

Here is the call graph for this function:

Here is the caller graph for this function:

loadUsersByUserIds()

OrgUnit\User\ilOrgUnitUserRepository::loadUsersByUserIds ( array  $user_ids )

private

Parameters

$user_ids

Returns

array

Definition at line 215 of file class.ilOrgUnitUserRepository.php.

References $q, and OrgUnit\User\ilOrgUnitUser\getInstance().

Referenced by OrgUnit\User\ilOrgUnitUserRepository\getOrgUnitUser(), and OrgUnit\User\ilOrgUnitUserRepository\getOrgUnitUsers().

                                                        : array
    {
        $users = array();

        $q = "SELECT * FROM usr_data WHERE " . $this->dic->database()->in('usr_id', $user_ids, false, 'int');

        $set = $this->dic->database()->query($q);

        while ($row = $this->dic->database()->fetchAssoc($set)) {
            $users[] = ilOrgUnitUser::getInstance(
                $row['usr_id'],
                (string) $row['login'],
                (string) $row['email'],
                (string) $row['second_email']
            );
        }

        return $users;
    }

Here is the call graph for this function:

Here is the caller graph for this function:

withPositions()

OrgUnit\User\ilOrgUnitUserRepository::withPositions

(

)

Returns

ilOrgUnitUserRepository

Definition at line 87 of file class.ilOrgUnitUserRepository.php.

                                   : ilOrgUnitUserRepository
    {
        $this->with_positions = true;

        return $this;
    }

withSuperiors()

OrgUnit\User\ilOrgUnitUserRepository::withSuperiors

(

)

Returns

ilOrgUnitUserRepository

Definition at line 77 of file class.ilOrgUnitUserRepository.php.

                                   : ilOrgUnitUserRepository
    {
        $this->with_superiors = true;

        return $this;
    }

Field Documentation

$assignmentRepo

ilOrgUnitUserAssignmentDBRepository OrgUnit\User\ilOrgUnitUserRepository::$assignmentRepo

protected

Definition at line 43 of file class.ilOrgUnitUserRepository.php.

Referenced by OrgUnit\User\ilOrgUnitUserRepository\getAssignmentRepo().

$dic

ILIAS DI Container OrgUnit\User\ilOrgUnitUserRepository::$dic

protected

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

$instance

array OrgUnit\User\ilOrgUnitUserRepository::$instance

staticprotected

Definition at line 36 of file class.ilOrgUnitUserRepository.php.

$orgu_users

array OrgUnit\User\ilOrgUnitUserRepository::$orgu_users

protected

Definition at line 40 of file class.ilOrgUnitUserRepository.php.

Referenced by OrgUnit\User\ilOrgUnitUserRepository\getOrgUnitUsers().

$positionRepo

ilOrgUnitPositionDBRepository OrgUnit\User\ilOrgUnitUserRepository::$positionRepo

protected

Definition at line 31 of file class.ilOrgUnitUserRepository.php.

Referenced by OrgUnit\User\ilOrgUnitUserRepository\getPositionRepo().

$with_positions

bool OrgUnit\User\ilOrgUnitUserRepository::$with_positions = false

protected

Definition at line 42 of file class.ilOrgUnitUserRepository.php.

$with_superiors

bool OrgUnit\User\ilOrgUnitUserRepository::$with_superiors = false

protected

Definition at line 41 of file class.ilOrgUnitUserRepository.php.

---

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

• components/ILIAS/OrgUnit/classes/User/class.ilOrgUnitUserRepository.php