class.ilOrgUnitPathStorage.php

Go to the documentation of this file.

<?php
require_once('./Services/ActiveRecord/class.ActiveRecord.php');

class ilOrgUnitPathStorage extends ActiveRecord {

        const GLUE = ' > ';
        const GLUE_SIMPLE = ' - ';
        const ORG_SEPARATOR = ' | ';
        const TABLE_NAME = 'orgu_path_storage';
        protected $ref_id = 0;
        protected $obj_id = 0;
        protected $path = '';
        protected static $orgu_names = array();


        public static function getAllOrguRefIds() {
                $names = self::getAllOrguNames();

                return array_keys($names);
        }


        public function store() {
                if (self::where(array( 'ref_id' => $this->getRefId() ))->hasSets()) {
                        $this->update();
                } else {
                        $this->create();
                }
        }


        public static function getTextRepresentationOfUsersOrgUnits($user_id, $separator = self::ORG_SEPARATOR, $using_tmp_table = true) {
                if ($using_tmp_table) {
                        global $DIC;
                        $ilDB = $DIC['ilDB'];
                        ilObjOrgUnitTree::_getInstance()->buildTempTableWithUsrAssignements();

                        $res = $ilDB->queryF("SELECT " . $ilDB->groupConcat("path", $separator) . " AS orgus FROM orgu_usr_assignements WHERE user_id = %s GROUP BY user_id;", array( 'integer' ), array( $user_id ));
                        $dat = $ilDB->fetchObject($res);

                        return $dat->orgus ? $dat->orgus : '-';
                } else {
                        $array_of_org_ids = ilObjOrgUnitTree::_getInstance()->getOrgUnitOfUser($user_id);

                        if (!$array_of_org_ids) {
                                return '-';
                        }
                        require_once('./Modules/OrgUnit/classes/PathStorage/class.ilOrgUnitPathStorage.php');
                        $paths = ilOrgUnitPathStorage::where(array( 'ref_id' => $array_of_org_ids ))->getArray(null, 'path');

                        return implode($separator, $paths);
                }
        }


        public static function getTextRepresentationOfOrgUnits($sort_by_title = true) {
                if ($sort_by_title) {
                        return ilOrgUnitPathStorage::orderBy('path')->getArray('ref_id', 'path');
                } else {
                        return ilOrgUnitPathStorage::getArray('ref_id', 'path');
                }
        }


        public static function writePathByRefId($ref_id) {
                require_once('./Modules/OrgUnit/classes/PathStorage/class.ilOrgUnitPathStorage.php');
                $original_ref_id = $ref_id;
                $names = self::getAllOrguNames();
                $root_ref_id = ilObjOrgUnit::getRootOrgRefId();
                $tree = ilObjOrgUnitTree::_getInstance();
                $path = array( $names[$ref_id] );
                if ($ref_id == $root_ref_id || !$ref_id) {
                        return false;
                }
                while ($ref_id != $root_ref_id && $ref_id) {
                        $ref_id = $tree->getParent($ref_id);
                        if ($ref_id != $root_ref_id && $names[$ref_id]) {
                                $path[] = $names[$ref_id];
                        }
                }

                $expression = reset($path) . self::GLUE_SIMPLE . end($path);
                $ilOrgUnitPathStorage = self::findOrGetInstance($original_ref_id);
                $ilOrgUnitPathStorage->setRefId($original_ref_id);
                $ilOrgUnitPathStorage->setObjId(ilObject2::_lookupObjectId($original_ref_id));
                $ilOrgUnitPathStorage->setPath($expression);
                $ilOrgUnitPathStorage->store();

                return true;
        }


        public static function clearDeleted() {
                global $DIC;
                $ilDB = $DIC['ilDB'];
                $ref_ids = self::getAllOrguRefIds();
                $q = "DELETE FROM " . self::TABLE_NAME . " WHERE  " . $ilDB->in('ref_id', $ref_ids, true, 'integer');
                $ilDB->manipulate($q);
        }


        protected static function writeFullPathByRefId($ref_id) {
                require_once('./Modules/OrgUnit/classes/PathStorage/class.ilOrgUnitPathStorage.php');
                $original_ref_id = $ref_id;
                $names = self::getAllOrguNames();
                $root_ref_id = ilObjOrgUnit::getRootOrgRefId();
                $tree = ilObjOrgUnitTree::_getInstance();
                $path = array( $names[$ref_id] );
                if ($ref_id == $root_ref_id || !$ref_id) {
                        return false;
                }
                while ($ref_id != $root_ref_id && $ref_id) {
                        $ref_id = $tree->getParent($ref_id);
                        if ($ref_id != $root_ref_id && $names[$ref_id]) {
                                $path[] = $names[$ref_id];
                        }
                }

                $path = array_reverse($path);

                $expression = implode(self::GLUE, $path);
                $ilOrgUnitPathStorage = self::findOrGetInstance($original_ref_id);
                $ilOrgUnitPathStorage->setRefId($original_ref_id);
                $ilOrgUnitPathStorage->setObjId(ilObject2::_lookupObjectId($original_ref_id));
                $ilOrgUnitPathStorage->setPath($expression);
                $ilOrgUnitPathStorage->store();

                return true;
        }


        public static function getAllOrguNames($lng_key = null) {
                if (count(self::$orgu_names) == 0) {
                        global $DIC;
                        $ilDB = $DIC['ilDB'];
                        $res = $ilDB->queryF('SELECT * FROM object_reference
                        JOIN object_data ON object_reference.obj_id = object_data.obj_id AND deleted IS NULL
                        WHERE object_data.type = %s', array( 'text' ), array( 'orgu' ));
                        while ($data = $ilDB->fetchObject($res)) {
                                self::$orgu_names[$data->ref_id] = $data->title;
                        }
                }

                return self::$orgu_names;
        }


        public function getConnectorContainerName() {
                return self::TABLE_NAME;
        }


        public function getRefId() {
                return $this->ref_id;
        }


        public function setRefId($ref_id) {
                $this->ref_id = $ref_id;
        }


        public function getPath() {
                return $this->path;
        }


        public function setPath($path) {
                $this->path = $path;
        }


        public function getObjId() {
                return $this->obj_id;
        }


        public function setObjId($obj_id) {
                $this->obj_id = $obj_id;
        }
}