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
	$dic
	$orgu_users
	$with_superiors = false
	$with_positions = false

Static Protected Attributes
static	$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 13 of file class.ilOrgUnitUserRepository.php.

Constructor & Destructor Documentation

__construct()

OrgUnit\User\ilOrgUnitUserRepository::__construct

(

)

ilOrgUnitUserRepository constructor.

Definition at line 42 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 136 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 97 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 76 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 156 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 116 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 211 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 63 of file class.ilOrgUnitUserRepository.php.

                                    : ilOrgUnitUserRepository
    {
        $this->with_positions = true;

        return $this;
    }

withSuperiors()

OrgUnit\User\ilOrgUnitUserRepository::withSuperiors

(

)

Returns

ilOrgUnitUserRepository

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

                                    : ilOrgUnitUserRepository
    {
        $this->with_superiors = true;

        return $this;
    }

Field Documentation

$dic

OrgUnit\User\ilOrgUnitUserRepository::$dic

protected

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

$instance

OrgUnit\User\ilOrgUnitUserRepository::$instance

staticprotected

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

$orgu_users

OrgUnit\User\ilOrgUnitUserRepository::$orgu_users

protected

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

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

$with_positions

OrgUnit\User\ilOrgUnitUserRepository::$with_positions = false

protected

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

$with_superiors

OrgUnit\User\ilOrgUnitUserRepository::$with_superiors = false

protected

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

---

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

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