Inheritance diagram for ilOrgUnitPositionDBRepository:

Collaboration diagram for ilOrgUnitPositionDBRepository:

Public Member Functions
	__construct (ilDBInterface $db, ilOrgUnitAuthorityDBRepository $authorityRepo, ilOrgUnitUserAssignmentDBRepository $assignmentRepo)

	get (int\|string $value, string $field)
	Get one or more positions filtered by field/value. More...

	getSingle (int\|string $value, string $field)
	Get a single position from a filtered query (see get()) More...

	getAllPositions ()
	Returns all position objects. More...

	getArray (?string $key=null, ?string $field=null)
	Returns position data as an array, e.g. More...

	getPositionsForOrgUnit (int $orgu_id)
	Returns all core positions plus all positions with user assignments for a certain org unit (kept for compatibility, filtering by ua will be moved to orgu later) More...

	create ()

	store (ilOrgUnitPosition $position)
	Saves position and its authorities. More...

	delete (int $position_id)
	Deletes position and authorities/user assignments attached to it. More...

	getAuthority (?int $id)
	Gets or creates an authority object, as the authority repo is encapsulated into this repo. More...

Data Fields
const	TABLE_NAME = 'il_orgu_positions'

Protected Attributes
ilDBInterface	$db

ilOrgUnitAuthorityDBRepository	$authorityRepo

ilOrgUnitUserAssignmentDBRepository	$assignmentRepo

Private Member Functions
	insert (ilOrgUnitPosition $position)

	update (ilOrgUnitPosition $position)

Private Attributes
const	TABLE_NAME_UA = 'il_orgu_ua'

Detailed Description

Definition at line 21 of file class.ilOrgUnitPositionDBRepository.php.

Constructor & Destructor Documentation

◆ __construct()

ilOrgUnitPositionDBRepository::__construct	(	ilDBInterface	$db,
		ilOrgUnitAuthorityDBRepository	$authorityRepo,
		ilOrgUnitUserAssignmentDBRepository	$assignmentRepo
	)

Definition at line 29 of file class.ilOrgUnitPositionDBRepository.php.

References $assignmentRepo, $authorityRepo, and $db.

     {
         $this->db = $db;
         $this->authorityRepo = $authorityRepo;
         $this->assignmentRepo = $assignmentRepo;
     }

Member Function Documentation

◆ create()

ilOrgUnitPositionDBRepository::create ( )

Implements OrgUnitPositionRepository.

Definition at line 196 of file class.ilOrgUnitPositionDBRepository.php.

                             : ilOrgUnitPosition
     {
         return new ilOrgUnitPosition();
     }

◆ delete()

ilOrgUnitPositionDBRepository::delete ( int $position_id )

Deletes position and authorities/user assignments attached to it.

Implements OrgUnitPositionRepository.

Definition at line 276 of file class.ilOrgUnitPositionDBRepository.php.

                                             : void
     {
         $query = 'DELETE FROM ' . self::TABLE_NAME . PHP_EOL
             . ' WHERE id = ' . $this->db->quote($position_id, 'integer');
 
         $this->db->manipulate($query);
 
         $authorities = $this->authorityRepo->get($position_id, 'position_id');
         foreach ($authorities as $authority) {
             $this->authorityRepo->delete($authority->getId());
         }
 
         $assignments = $this->assignmentRepo->getByPosition($position_id);
         foreach ($assignments as $assignment) {
             $this->assignmentRepo->delete($assignment);
         }
     }

◆ get()

ilOrgUnitPositionDBRepository::get	(	int\|string	$value,
		string	$field
	)

Get one or more positions filtered by field/value.

Returns: ilOrgUnitPosition[]

Exceptions

Exception

Implements OrgUnitPositionRepository.

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

References $res, and ilOrgUnitAuthority\POSITION_ID.

                                                          : array
     {
         $fields = [
             'id' => 'integer',
             'core_identifier' => 'integer',
             'title' => 'string'
         ];
         if (!in_array($field, array_keys($fields))) {
             throw new Exception("Invalid field: " . $field);
         }
 
         $query = 'SELECT id, title, description, core_position, core_identifier FROM' . PHP_EOL
             . self::TABLE_NAME
             . ' WHERE ' . self::TABLE_NAME . '.' . $field . ' = ' . $this->db->quote($value, $fields[$field]);
         $res = $this->db->query($query);
         $ret = [];
         while ($rec = $this->db->fetchAssoc($res)) {
             $ret[] = (new ilOrgUnitPosition((int) $rec['id']))
                 ->withTitle((string) $rec['title'])
                 ->withDescription((string) $rec['description'])
                 ->withCorePosition((bool) $rec['core_position'])
                 ->withCoreIdentifier((int) $rec['core_identifier'])
                 ->withAuthorities($this->authorityRepo->get((int) $rec['id'], ilOrgUnitAuthority::POSITION_ID));
         }
 
         return $ret;
     }

◆ getAllPositions()

ilOrgUnitPositionDBRepository::getAllPositions ( )

Returns all position objects.

Returns: ilOrgUnitPosition[]

Implements OrgUnitPositionRepository.

Definition at line 88 of file class.ilOrgUnitPositionDBRepository.php.

References $res, and ilOrgUnitAuthority\POSITION_ID.

                                      : array
     {
         $query = 'SELECT id, title, description, core_position, core_identifier FROM' . PHP_EOL
             . self::TABLE_NAME . PHP_EOL
             . 'WHERE 1';
         $res = $this->db->query($query);
         $ret = [];
         while ($rec = $this->db->fetchAssoc($res)) {
             $ret[] = (new ilOrgUnitPosition((int) $rec['id']))
                 ->withTitle((string) $rec['title'])
                 ->withDescription((string) $rec['description'])
                 ->withCorePosition((bool) $rec['core_position'])
                 ->withCoreIdentifier((int) $rec['core_identifier'])
                 ->withAuthorities($this->authorityRepo->get((int) $rec['id'], ilOrgUnitAuthority::POSITION_ID));
         }
 
         return $ret;
     }

◆ getArray()

ilOrgUnitPositionDBRepository::getArray	(	?string	$key = `null`,
		?string	$field = `null`
	)

Returns position data as an array, e.g.

for using ids in forms

Exceptions

Exception

Implements OrgUnitPositionRepository.

Definition at line 112 of file class.ilOrgUnitPositionDBRepository.php.

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

                                                                         : array
     {
         if (!in_array($key, ['id', null])) {
             throw new Exception("Invalid key: " . $field);
         }
 
         $fields = [
             'id' => 'int',
             'title' => 'string',
             'description' => 'string',
             'core_identifier' => 'int',
             'core_position' => 'int'
         ];
         if (!in_array($field, array_keys($fields)) && $field !== null) {
             throw new Exception("Invalid field: " . $field);
         }
 
         if ($field !== null && $this->db->tableColumnExists(self::TABLE_NAME, $field)) {
             $query = 'SELECT id, ' . $field . ' FROM' . PHP_EOL
                 . self::TABLE_NAME
                 . '     WHERE 1';
 
             $res = $this->db->query($query);
             $ret = [];
             while ($rec = $this->db->fetchAssoc($res)) {
                 $value = $rec[$field];
                 if ($fields[$field] == 'int') {
                     $value = (int) $value;
                 } elseif ($fields[$field] == 'string') {
                     $value = (string) $value;
                 }
                 if ($key !== null) {
                     $ret[$rec[$key]] = $value;
                 } else {
                     $ret[] = $value;
                 }
             }
         } else {
             $query = 'SELECT id, title, description, core_identifier, core_position FROM' . PHP_EOL
                 . self::TABLE_NAME
                 . '     WHERE 1';
             $res = $this->db->query($query);
             $ret = [];
             while ($rec = $this->db->fetchAssoc($res)) {
                 if ($key !== null) {
                     $ret[$key] = $rec;
                 } else {
                     $ret[] = $rec;
                 }
             }
         }
 
         return $ret;
     }

Here is the call graph for this function:

◆ getAuthority()

ilOrgUnitPositionDBRepository::getAuthority ( ?int $id )

Gets or creates an authority object, as the authority repo is encapsulated into this repo.

Implements OrgUnitPositionRepository.

Definition at line 297 of file class.ilOrgUnitPositionDBRepository.php.

                                           : ilOrgUnitAuthority
     {
         if ($id === null) {
             return $this->authorityRepo->create();
         } else {
             $authority = $this->authorityRepo->get($id, 'id');
             return array_shift($authority);
         }
     }

◆ getPositionsForOrgUnit()

ilOrgUnitPositionDBRepository::getPositionsForOrgUnit ( int $orgu_id )

Returns all core positions plus all positions with user assignments for a certain org unit (kept for compatibility, filtering by ua will be moved to orgu later)

Returns: ilOrgUnitPosition[]

Implements OrgUnitPositionRepository.

Definition at line 173 of file class.ilOrgUnitPositionDBRepository.php.

References $res, and ilOrgUnitAuthority\POSITION_ID.

                                                         : array
     {
         $query = 'SELECT DISTINCT ' . self::TABLE_NAME . '.id, ' . self::TABLE_NAME . '.*' . PHP_EOL
             . 'FROM ' . self::TABLE_NAME . PHP_EOL
             . 'LEFT JOIN ' . self::TABLE_NAME_UA . PHP_EOL
             . 'ON ' . self::TABLE_NAME . '.id = ' . self::TABLE_NAME_UA . '.position_id' . PHP_EOL
             . 'AND ' . self::TABLE_NAME_UA . '.orgu_id = ' . $this->db->quote($orgu_id, 'integer') . PHP_EOL
             . 'WHERE ' . self::TABLE_NAME_UA . '.user_id IS NOT NULL' . PHP_EOL
             . 'OR ' . self::TABLE_NAME . '.core_position = 1';
         $res = $this->db->query($query);
         $ret = [];
         while ($rec = $this->db->fetchAssoc($res)) {
             $ret[] = (new ilOrgUnitPosition((int) $rec['id']))
                 ->withTitle((string) $rec['title'])
                 ->withDescription((string) $rec['description'])
                 ->withCorePosition((bool) $rec['core_position'])
                 ->withCoreIdentifier((int) $rec['core_identifier'])
                 ->withAuthorities($this->authorityRepo->get((int) $rec['id'], ilOrgUnitAuthority::POSITION_ID));
         }
 
         return $ret;
     }

◆ getSingle()

ilOrgUnitPositionDBRepository::getSingle	(	int\|string	$value,
		string	$field
	)

Get a single position from a filtered query (see get())

Implements OrgUnitPositionRepository.

Definition at line 73 of file class.ilOrgUnitPositionDBRepository.php.

                                                                : ?ilOrgUnitPosition
     {
         $pos = $this->get($value, $field);
         if (count($pos) === 0) {
             return null;
         }
 
         return (array_shift($pos));
     }

◆ insert()

ilOrgUnitPositionDBRepository::insert ( ilOrgUnitPosition $position )

private

Definition at line 235 of file class.ilOrgUnitPositionDBRepository.php.

References $id, ilOrgUnitPosition\getAuthorities(), ilOrgUnitPosition\getCoreIdentifier(), ilOrgUnitPosition\getDescription(), ilOrgUnitPosition\getTitle(), and ilOrgUnitPosition\isCorePosition().

Referenced by store().

                                                         : ilOrgUnitPosition
     {
         $id = $this->db->nextId(self::TABLE_NAME);
 
         $values = [
             'id' => [ 'integer', $id],
             'title' => [ 'text', $position->getTitle() ],
             'description' => [ 'text', $position->getDescription() ],
             'core_position' => [ 'integer', ($position->isCorePosition()) ? 1 : 0 ],
             'core_identifier' => [ 'integer', $position->getCoreIdentifier() ]
         ];
 
         $this->db->insert(self::TABLE_NAME, $values);
 
         $ret = (new ilOrgUnitPosition($id))
             ->withTitle($position->getTitle())
             ->withDescription($position->getDescription())
             ->withCorePosition($position->isCorePosition())
             ->withCoreIdentifier($position->getCoreIdentifier())
             ->withAuthorities($position->getAuthorities());
 
         return $ret;
     }

Here is the call graph for this function:

Here is the caller graph for this function:

◆ store()

ilOrgUnitPositionDBRepository::store ( ilOrgUnitPosition $position )

Saves position and its authorities.

Implements OrgUnitPositionRepository.

Definition at line 204 of file class.ilOrgUnitPositionDBRepository.php.

References ilOrgUnitPosition\getAuthorities(), ilOrgUnitPosition\getId(), insert(), update(), and ilOrgUnitPosition\withAuthorities().

                                                       : ilOrgUnitPosition
     {
         if ($position->getId() === 0) {
             $position = $this->insert($position);
         } else {
             $this->update($position);
         }
 
         $authorities = $position->getAuthorities();
         $ids = [];
         $new_authorities = [];
         foreach ($authorities as $authority) {
             $auth = $this->authorityRepo->store($authority->withPositionId($position->getId()));
             $ids[] = $auth->getId();
             $new_authorities[] = $auth;
         }
         $position = $position->withAuthorities($new_authorities);
 
         if (count($ids) > 0) {
             $this->authorityRepo->deleteLeftoverAuthorities($ids, $position->getId());
         }
         if (count($ids) === 0) {
             $authorities = $this->authorityRepo->get($position->getId(), 'position_id');
             foreach ($authorities as $authority) {
                 $this->authorityRepo->delete($authority->getId());
             }
         }
 
         return $position;
     }

Here is the call graph for this function:

◆ update()

ilOrgUnitPositionDBRepository::update ( ilOrgUnitPosition $position )

private

Definition at line 259 of file class.ilOrgUnitPositionDBRepository.php.

References ilOrgUnitPosition\getCoreIdentifier(), ilOrgUnitPosition\getDescription(), ilOrgUnitPosition\getId(), ilOrgUnitPosition\getTitle(), and ilOrgUnitPosition\isCorePosition().

Referenced by store().

                                                         : void
     {
         $where = [ 'id' => [ 'integer', $position->getId() ] ];
 
         $values = [
             'title' => [ 'text', $position->getTitle() ],
             'description' => [ 'text', $position->getDescription() ],
             'core_position' => [ 'integer', (($position->isCorePosition()) ? 1 : 0) ],
             'core_identifier' => [ 'integer', $position->getCoreIdentifier() ]
         ];
 
         $this->db->update(self::TABLE_NAME, $values, $where);
     }

Here is the call graph for this function:

Here is the caller graph for this function:

Field Documentation

◆ $assignmentRepo

ilOrgUnitUserAssignmentDBRepository ilOrgUnitPositionDBRepository::$assignmentRepo

protected

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

Referenced by __construct().

◆ $authorityRepo

ilOrgUnitAuthorityDBRepository ilOrgUnitPositionDBRepository::$authorityRepo

protected

Definition at line 26 of file class.ilOrgUnitPositionDBRepository.php.

Referenced by __construct().

◆ $db

ilDBInterface ilOrgUnitPositionDBRepository::$db

protected

Definition at line 25 of file class.ilOrgUnitPositionDBRepository.php.

Referenced by __construct().

◆ TABLE_NAME

const ilOrgUnitPositionDBRepository::TABLE_NAME = 'il_orgu_positions'

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

◆ TABLE_NAME_UA

const ilOrgUnitPositionDBRepository::TABLE_NAME_UA = 'il_orgu_ua'

private

Definition at line 24 of file class.ilOrgUnitPositionDBRepository.php.

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

Modules/OrgUnit/classes/Positions/class.ilOrgUnitPositionDBRepository.php

Public Member Functions

Data Fields

Protected Attributes

Private Member Functions

Private Attributes

Detailed Description

Constructor & Destructor Documentation

◆ __construct()

Member Function Documentation

◆ create()

◆ delete()

◆ get()

◆ getAllPositions()

◆ getArray()

◆ getAuthority()

◆ getPositionsForOrgUnit()

◆ getSingle()

◆ insert()

◆ store()

◆ update()

Field Documentation

◆ $assignmentRepo

◆ $authorityRepo

◆ $db

◆ TABLE_NAME

◆ TABLE_NAME_UA