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)

Protected Member Functions
	getSuperiorsSql (array $user_ids)

Protected Attributes
ILIAS DI Container	$dic
array	$orgu_users
bool	$with_superiors = false
bool	$with_positions = false

Static Protected Attributes
static array	$instance

Private Member Functions
	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 45 of file class.ilOrgUnitUserRepository.php.

References $DIC.

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

Member Function Documentation

getEmailAdressesOfSuperiors()

OrgUnit\User\ilOrgUnitUserRepository::getEmailAdressesOfSuperiors

(

array

$user_ids

)

Parameters

array

$user_ids

Returns

array

Definition at line 135 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 94 of file class.ilOrgUnitUserRepository.php.

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

                                                : ?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 75 of file class.ilOrgUnitUserRepository.php.

References OrgUnit\User\ilOrgUnitUserRepository\$orgu_users, 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:

getSuperiorsSql()

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

protected

Parameters

array

$user_ids

Returns

string

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

References $DIC, ilOrgUnitPosition\CORE_POSITION_EMPLOYEE, ilOrgUnitPosition\CORE_POSITION_SUPERIOR, OrgUnit\User\ilOrgUnitUser\getInstanceById(), and ActiveRecord\where().

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 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 112 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 204 of file class.ilOrgUnitUserRepository.php.

References 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 64 of file class.ilOrgUnitUserRepository.php.

                                   : ilOrgUnitUserRepository
    {
        $this->with_positions = true;

        return $this;
    }

withSuperiors()

OrgUnit\User\ilOrgUnitUserRepository::withSuperiors

(

)

Returns

ilOrgUnitUserRepository

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

                                   : ilOrgUnitUserRepository
    {
        $this->with_superiors = true;

        return $this;
    }

Field Documentation

$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 34 of file class.ilOrgUnitUserRepository.php.

$orgu_users

array OrgUnit\User\ilOrgUnitUserRepository::$orgu_users

protected

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

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

$with_positions

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

protected

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

$with_superiors

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

protected

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

---

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

• Modules/OrgUnit/classes/User/class.ilOrgUnitUserRepository.php