ilOrgUnitAuthorityDBRepository Class Reference

Inheritance diagram for ilOrgUnitAuthorityDBRepository:

Collaboration diagram for ilOrgUnitAuthorityDBRepository:

Public Member Functions
	__construct (ilDBInterface $db)
	get (int $id, string $field)
	create ()
	store (ilOrgUnitAuthority $authority)
	delete (int $id)
	deleteByPositionId (int $position_id)
	Deletes all authorities for a position. More...
	deleteLeftoverAuthorities (array $ids, int $position_id)
	Deletes orphaned authorities on position save. More...

Data Fields
const	TABLE_NAME = 'il_orgu_authority'

Protected Attributes
ilDBInterface	$db

Private Member Functions
	insert (ilOrgUnitAuthority $authority)
	update (ilOrgUnitAuthority $authority)

Detailed Description

Definition at line 20 of file class.ilOrgUnitAuthorityDBRepository.php.

Constructor & Destructor Documentation

__construct()

ilOrgUnitAuthorityDBRepository::__construct

(

ilDBInterface

$db

)

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

References $db.

    {
        $this->db = $db;
    }

Member Function Documentation

create()

ilOrgUnitAuthorityDBRepository::create

(

)

Implements OrgUnitAuthorityRepository.

Definition at line 50 of file class.ilOrgUnitAuthorityDBRepository.php.

                            : ilOrgUnitAuthority
    {
        return new ilOrgUnitAuthority();
    }

delete()

ilOrgUnitAuthorityDBRepository::delete

(

int

$id

)

Implements OrgUnitAuthorityRepository.

Definition at line 100 of file class.ilOrgUnitAuthorityDBRepository.php.

                                   : void
    {
        $query = 'DELETE FROM ' . self::TABLE_NAME . PHP_EOL
            . ' WHERE id = ' . $this->db->quote($id, 'integer');

        $this->db->manipulate($query);
    }

deleteByPositionId()

ilOrgUnitAuthorityDBRepository::deleteByPositionId

(

int

$position_id

)

Deletes all authorities for a position.

Implements OrgUnitAuthorityRepository.

Definition at line 111 of file class.ilOrgUnitAuthorityDBRepository.php.

                                                        : void
    {
        $query = 'DELETE FROM ' . self::TABLE_NAME . PHP_EOL
            . ' WHERE position_id = ' . $this->db->quote($position_id, 'integer');

        $this->db->manipulate($query);
    }

deleteLeftoverAuthorities()

ilOrgUnitAuthorityDBRepository::deleteLeftoverAuthorities	(	array	$ids,
		int	$position_id
	)

Deletes orphaned authorities on position save.

Implements OrgUnitAuthorityRepository.

Definition at line 122 of file class.ilOrgUnitAuthorityDBRepository.php.

                                                                           : void
    {
        $query = 'DELETE FROM ' . self::TABLE_NAME . PHP_EOL
            . ' WHERE position_id = ' . $this->db->quote($position_id, 'integer') . PHP_EOL
            . ' AND ' . $this->db->in('id', $ids, true, 'integer');

        $this->db->manipulate($query);
    }

get()

ilOrgUnitAuthorityDBRepository::get	(	int	$id,
		string	$field
	)

Returns

ilOrgUnitAuthority[]

Implements OrgUnitAuthorityRepository.

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

References $res, ilOrgUnitAuthority\FIELD_OVER, and ilOrgUnitAuthority\POSITION_ID.

                                               : array
    {
        if (!in_array($field, [ilOrgUnitAuthority::FIELD_OVER, ilOrgUnitAuthority::POSITION_ID, 'id'])) {
            throw new Exception("Invalid field: " . $field);
        }
        $query = 'SELECT id, ' . self::TABLE_NAME . '.over, scope, position_id FROM' . PHP_EOL
            . self::TABLE_NAME
            . ' WHERE ' . self::TABLE_NAME . '.' . $field . ' = ' . $this->db->quote($id, 'integer');
        $res = $this->db->query($query);
        $ret = [];
        while ($rec = $this->db->fetchAssoc($res)) {
            $ret[] = (new ilOrgUnitAuthority((int) $rec['id']))
                ->withOver((int) $rec['over'])
                ->withScope((int) $rec['scope'])
                ->withPositionId((int) $rec['position_id']);
        }

        return $ret;
    }

insert()

ilOrgUnitAuthorityDBRepository::insert ( ilOrgUnitAuthority  $authority )

private

Definition at line 66 of file class.ilOrgUnitAuthorityDBRepository.php.

References $id, ilOrgUnitAuthority\getOver(), ilOrgUnitAuthority\getPositionId(), and ilOrgUnitAuthority\getScope().

Referenced by store().

                                                          : ilOrgUnitAuthority
    {
        $id = $this->db->nextId(self::TABLE_NAME);

        $values = [
            'id' => [ 'integer', $id],
            'over' => [ 'integer', $authority->getOver() ],
            'scope' => [ 'integer', $authority->getScope() ],
            'position_id' => [ 'integer', $authority->getPositionId() ]
        ];

        $this->db->insert(self::TABLE_NAME, $values);

        $ret = (new ilOrgUnitAuthority($id))
            ->withOver($authority->getOver())
            ->withScope($authority->getScope())
            ->withPositionId($authority->getPositionId());

        return $ret;
    }

Here is the call graph for this function:

Here is the caller graph for this function:

store()

ilOrgUnitAuthorityDBRepository::store

(

ilOrgUnitAuthority

$authority

)

Implements OrgUnitAuthorityRepository.

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

References ilOrgUnitAuthority\getId(), insert(), and update().

                                                        : ilOrgUnitAuthority
    {
        if ($authority->getId() === 0) {
            $authority = $this->insert($authority);
        } else {
            $this->update($authority);
        }

        return $authority;
    }

Here is the call graph for this function:

update()

ilOrgUnitAuthorityDBRepository::update ( ilOrgUnitAuthority  $authority )

private

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

References ilOrgUnitAuthority\getId(), ilOrgUnitAuthority\getOver(), ilOrgUnitAuthority\getPositionId(), and ilOrgUnitAuthority\getScope().

Referenced by store().

                                                          : void
    {
        $where = [ 'id' => [ 'integer', $authority->getId() ] ];

        $values = [
            'over' => [ 'integer', $authority->getOver() ],
            'scope' => [ 'integer', $authority->getScope() ],
            'position_id' => [ 'integer', $authority->getPositionId() ]
        ];

        $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

$db

ilDBInterface ilOrgUnitAuthorityDBRepository::$db

protected

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

Referenced by __construct().

TABLE_NAME

const ilOrgUnitAuthorityDBRepository::TABLE_NAME = 'il_orgu_authority'

Definition at line 22 of file class.ilOrgUnitAuthorityDBRepository.php.

---

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

• Modules/OrgUnit/classes/Positions/Authorities/class.ilOrgUnitAuthorityDBRepository.php