class.ilOrgUnitPosition.php

Go to the documentation of this file.

<?php
 
class ilOrgUnitPosition extends \ActiveRecord
{
    const CORE_POSITION_EMPLOYEE = 1;
    const CORE_POSITION_SUPERIOR = 2;
 
 
    public static function returnDbTableName()
    {
        return "il_orgu_positions";
    }
 
 
    public static function get()
    {
        return parent::get();
    }
 
 
    public static function getCorePosition($core_identifier)
    {
        return ilOrgUnitPosition::where([ 'core_identifier' => $core_identifier ])->first();
    }
 
 
    public static function getCorePositionId($core_identifier)
    {
        return self::getCorePosition($core_identifier)->getId();
    }
 
    public function delete()
    {
        if ($this->isCorePosition()) {
            throw new ilException('Cannot delete Core-Position');
        }
        parent::delete();
    }
 
 
    public static function getActive()
    {
        arObjectCache::flush(self::class);
        $q = "SELECT DISTINCT il_orgu_positions.id, il_orgu_positions.*
                                FROM il_orgu_positions 
                                 LEFT JOIN il_orgu_ua ON il_orgu_positions.id = il_orgu_ua.position_id  
                                WHERE il_orgu_ua.user_id IS NOT NULL 
                                        OR il_orgu_positions.core_position = 1";
        $database = $GLOBALS['DIC']->database();
        $st = $database->query($q);
 
        $positions = array();
 
        while ($data = $database->fetchAssoc($st)) {
            $position = new self();
            $position->buildFromArray($data);
            $positions[] = $position;
        }
 
        return $positions;
    }
 
 
    public static function getActiveForPosition($orgu_ref_id)
    {
        arObjectCache::flush(self::class);
        $q = "SELECT DISTINCT il_orgu_positions.id, il_orgu_positions.*
                                FROM il_orgu_positions 
                                LEFT JOIN il_orgu_ua ON il_orgu_positions.id = il_orgu_ua.position_id AND il_orgu_ua.orgu_id = %s 
                                WHERE il_orgu_ua.user_id IS NOT NULL 
                                        OR core_position = 1";
        $database = $GLOBALS['DIC']->database();
        $st = $database->queryF($q, array( 'integer' ), array( $orgu_ref_id ));
 
        $positions = array();
 
        while ($data = $database->fetchAssoc($st)) {
            $position = new self();
            $position->buildFromArray($data);
            $positions[] = $position;
        }
 
        return $positions;
    }
 
 
    protected $id = 0;
    protected $title = "";
    protected $description = "";
    protected $core_position = false;
    protected $core_identifier = 0;
    protected $authorities = array();
 
 
    public function afterObjectLoad()
    {
        $this->authorities = ilOrgUnitAuthority::where(array( ilOrgUnitAuthority::POSITION_ID => $this->getId() ))
                                               ->get();
    }
 
 
    public function update()
    {
        parent::update();
        $this->storeAuthorities();
    }
 
 
    public function create()
    {
        parent::create();
        $this->storeAuthorities();
    }
 
 
    public function getAuthoritiesAsArray()
    {
        $return = array();
        foreach ($this->authorities as $authority) {
            $return[] = $authority->__toArray();
        }
 
        return $return;
    }
 
 
    public function __toString()
    {
        return $this->getTitle();
    }
 
 
    public function getDependentAuthorities()
    {
        $dependent = ilOrgUnitAuthority::where(array( ilOrgUnitAuthority::FIELD_OVER => $this->getId() ))
                                       ->get();
 
        $arr = $dependent + $this->authorities;
 
        return (array) $arr;
    }
 
 
    public function deleteWithAllDependencies()
    {
        foreach ($this->getDependentAuthorities() as $authority) {
            $authority->delete();
        }
 
        $ilOrgUnitUserAssignmentQueries = ilOrgUnitUserAssignmentQueries::getInstance();
        foreach ($ilOrgUnitUserAssignmentQueries->getUserAssignmentsOfPosition($this->getId()) as $assignment) {
            $assignment->delete();
        }
        parent::delete();
    }
 
 
    public function getId()
    {
        return $this->id;
    }
 
 
    public function setId($id)
    {
        $this->id = $id;
    }
 
 
    public function getTitle()
    {
        return $this->title;
    }
 
 
    public function setTitle($title)
    {
        $this->title = $title;
    }
 
 
    public function getDescription()
    {
        return $this->description;
    }
 
 
    public function setDescription($description)
    {
        $this->description = $description;
    }
 
 
    public function isCorePosition()
    {
        return $this->core_position;
    }
 
 
    public function setCorePosition($core_position)
    {
        $this->core_position = $core_position;
    }
 
 
    public function getAuthorities()
    {
        return $this->authorities;
    }
 
 
    public function setAuthorities($authorities)
    {
        $this->authorities = $authorities;
    }
 
 
    public function getCoreIdentifier()
    {
        return $this->core_identifier;
    }
 
 
    public function setCoreIdentifier($core_identifier)
    {
        $this->core_identifier = $core_identifier;
    }
 
 
    private function storeAuthorities()
    {
        $ids = [];
        foreach ($this->getAuthorities() as $authority) {
            $authority->setPositionId($this->getId());
            if ($authority->getId()) {
                $authority->update();
            } else {
                $authority->create();
            }
            $ids[] = $authority->getId();
        }
        if (count($ids) > 0) {
            foreach (ilOrgUnitAuthority::where(array(
                'id'          => $ids,
                'position_id' => $this->getId(),
            ), array( 'id' => 'NOT IN', 'position_id' => '=' ))->get() as $authority) {
                $authority->delete();
            }
        }
 
        if (count($ids) === 0) {
            foreach (ilOrgUnitAuthority::where(array(
                'position_id' => $this->getId(),
            ))->get() as $authority) {
                $authority->delete();
            }
        }
    }
}