ILIAS  release_10 Revision v10.1-43-ga1241a92c2f
Public Member Functions | Protected Member Functions | Protected Attributes | Static Protected Attributes | Private Member Functions
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 29 of file class.ilOrgUnitUserRepository.php.

Constructor & Destructor Documentation

◆ __construct()

OrgUnit\User\ilOrgUnitUserRepository::__construct ( )

ilOrgUnitUserRepository constructor.

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

References $DIC.

50  {
51  global $DIC;
52  $this->dic = $DIC;
53  }
$DIC
global $DIC
Definition: shib_login.php:25

Member Function Documentation

◆ getAssignmentRepo()

OrgUnit\User\ilOrgUnitUserRepository::getAssignmentRepo ( )
protected

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

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

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

65  : \ilOrgUnitUserAssignmentDBRepository
66  {
67  if (!isset($this->assignmentRepo)) {
68  $dic = \ilOrgUnitLocalDIC::dic();
69  $this->assignmentRepo = $dic["repo.UserAssignments"];
70  }
71 
72  return $this->assignmentRepo;
73  }
OrgUnit\User\ilOrgUnitUserRepository\$assignmentRepo
ilOrgUnitUserAssignmentDBRepository $assignmentRepo
Definition: class.ilOrgUnitUserRepository.php:44
+ 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 159 of file class.ilOrgUnitUserRepository.php.

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

159  : array
160  {
161  global $DIC;
162 
163  $st = $DIC->database()->query($this->getSuperiorsSql($user_ids));
164 
165  $arr_email_sup = [];
166  while ($data = $DIC->database()->fetchAssoc($st)) {
167  $arr_email_sup[] = $data['sup_email'];
168  }
169 
170  return $arr_email_sup;
171  }
$DIC
global $DIC
Definition: shib_login.php:25
+ 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 118 of file class.ilOrgUnitUserRepository.php.

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

118  : ?ilOrgUnitUser
119  {
120  $this->orgu_users = $this->loadUsersByUserIds([$user_id]);
121 
122  if (count($this->orgu_users) == 0) {
123  return null;
124  }
125 
126  if ($this->with_superiors === true) {
127  $this->loadSuperiors([$user_id]);
128  }
129 
130  return $this->orgu_users[0];
131  }
+ 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 99 of file class.ilOrgUnitUserRepository.php.

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

99  : array
100  {
101  $this->orgu_users = $this->loadUsersByUserIds($arr_user_id);
102 
103  if ($this->with_superiors === true) {
104  $this->loadSuperiors($arr_user_id);
105  }
106 
107  if ($this->with_positions === true) {
108  $this->loadPositions($arr_user_id);
109  }
110 
111  return $this->orgu_users;
112  }
+ Here is the call graph for this function:

◆ getPositionRepo()

OrgUnit\User\ilOrgUnitUserRepository::getPositionRepo ( )
private

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

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

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

55  : \ilOrgUnitPositionDBRepository
56  {
57  if (!isset($this->positionRepo)) {
58  $dic = \ilOrgUnitLocalDIC::dic();
59  $this->positionRepo = $dic["repo.Positions"];
60  }
61 
62  return $this->positionRepo;
63  }
+ 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 177 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().

177  : string
178  {
179  global $DIC;
180 
181  $sql = "SELECT
182  orgu_ua.orgu_id AS orgu_id,
183  orgu_ua.user_id AS empl_usr_id,
184  orgu_ua2.user_id as sup_usr_id,
185  superior.email as sup_email,
186  superior.second_email as sup_second_email,
187  superior.login as sup_login
188  FROM
189  il_orgu_ua as orgu_ua,
190  il_orgu_ua as orgu_ua2
191  inner join usr_data as superior on superior.usr_id = orgu_ua2.user_id
192  WHERE
193  orgu_ua.orgu_id = orgu_ua2.orgu_id
194  and orgu_ua.user_id <> orgu_ua2.user_id
195  and orgu_ua.position_id = " . \ilOrgUnitPosition::CORE_POSITION_EMPLOYEE . "
196  and orgu_ua2.position_id = " . \ilOrgUnitPosition::CORE_POSITION_SUPERIOR . "
197  AND " . $DIC->database()->in('orgu_ua.user_id', $user_ids, false, 'integer');
198 
199  return $sql;
200  }
$DIC
global $DIC
Definition: shib_login.php:25
+ Here is the caller graph for this function:

◆ loadPositions()

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

Definition at line 202 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().

202  : void
203  {
204  $assignments = $this->getAssignmentRepo()
205  ->getByUsers($user_ids);
206  foreach ($assignments as $assignment) {
207  $org_unit_user = ilOrgUnitUser::getInstanceById($assignment->getUserId());
208  $org_unit_user->addPositions($this->getPositionRepo()->getSingle($assignment->getPositionId(), 'id'));
209  }
210  }
OrgUnit\User\ilOrgUnitUser\getInstanceById
static getInstanceById(int $user_id)
Definition: class.ilOrgUnitUser.php:54
+ 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 136 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().

136  : void
137  {
138  global $DIC;
139 
140  $st = $DIC->database()->query($this->getSuperiorsSql($user_ids));
141 
142  $empl_id_sup_ids = [];
143  while ($data = $DIC->database()->fetchAssoc($st)) {
144  $org_unit_user = ilOrgUnitUser::getInstanceById($data['empl_usr_id']);
145  $superior = ilOrgUnitUser::getInstance(
146  $data['sup_usr_id'],
147  (string) $data['sup_login'],
148  (string) $data['sup_email'],
149  (string) $data['sup_second_email']
150  );
151  $org_unit_user->addSuperior($superior);
152  }
153  }
OrgUnit\User\ilOrgUnitUser\getInstanceById
static getInstanceById(int $user_id)
Definition: class.ilOrgUnitUser.php:54
OrgUnit\User\ilOrgUnitUser\getInstance
static getInstance(int $user_id, string $login, string $email, string $second_email)
Definition: class.ilOrgUnitUser.php:69
$DIC
global $DIC
Definition: shib_login.php:25
+ 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 216 of file class.ilOrgUnitUserRepository.php.

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

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

216  : array
217  {
218  $users = array();
219 
220  $q = "SELECT * FROM usr_data WHERE " . $this->dic->database()->in('usr_id', $user_ids, false, 'int');
221 
222  $set = $this->dic->database()->query($q);
223 
224  while ($row = $this->dic->database()->fetchAssoc($set)) {
225  $users[] = ilOrgUnitUser::getInstance(
226  $row['usr_id'],
227  (string) $row['login'],
228  (string) $row['email'],
229  (string) $row['second_email']
230  );
231  }
232 
233  return $users;
234  }
OrgUnit\User\ilOrgUnitUser\getInstance
static getInstance(int $user_id, string $login, string $email, string $second_email)
Definition: class.ilOrgUnitUser.php:69
$q
$q
Definition: shib_logout.php:18
+ 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 88 of file class.ilOrgUnitUserRepository.php.

88  : ilOrgUnitUserRepository
89  {
90  $this->with_positions = true;
91 
92  return $this;
93  }

◆ withSuperiors()

OrgUnit\User\ilOrgUnitUserRepository::withSuperiors ( )
Returns
ilOrgUnitUserRepository

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

78  : ilOrgUnitUserRepository
79  {
80  $this->with_superiors = true;
81 
82  return $this;
83  }

Field Documentation

◆ $assignmentRepo

ilOrgUnitUserAssignmentDBRepository OrgUnit\User\ilOrgUnitUserRepository::$assignmentRepo
protected

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

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

◆ $dic

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

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

◆ $instance

array OrgUnit\User\ilOrgUnitUserRepository::$instance
staticprotected

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

◆ $orgu_users

array OrgUnit\User\ilOrgUnitUserRepository::$orgu_users
protected

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

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

◆ $positionRepo

ilOrgUnitPositionDBRepository OrgUnit\User\ilOrgUnitUserRepository::$positionRepo
protected

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

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

◆ $with_positions

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

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

◆ $with_superiors

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

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

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