class.ilObjSystemFolder.php

Go to the documentation of this file.

<?php

class ilObjSystemFolder extends ilObject
{
    protected ilObjUser $user;

    public function __construct($a_id, $a_call_by_reference = true)
    {
        global $DIC;

        $this->db = $DIC->database();
        $this->user = $DIC->user();
        $this->type = "adm";
        parent::__construct($a_id, $a_call_by_reference);
    }


    public function delete(): bool
    {
        // DISABLED
        return false;

        // always call parent delete function first!!
        if (!parent::delete()) {
            return false;
        }

        // put here systemfolder specific stuff

        // always call parent delete function at the end!!
        return true;
    }

    public function getHeaderTitleTranslations()
    {
        $ilDB = $this->db;

        $q = "SELECT * FROM object_translation WHERE obj_id = " .
            $ilDB->quote($this->getId(), 'integer') . " ORDER BY lang_default DESC";
        $r = $ilDB->query($q);

        $num = 0;

        while ($row = $ilDB->fetchObject($r)) {
            $data["Fobject"][$num] = array("title" => $row->title,
                                           "desc" => ilStr::shortenTextExtended(
                                               (string) $row->description,
                                               ilObject::DESC_LENGTH,
                                               true
                                           ),
                                           "lang" => $row->lang_code
                                          );
            $num++;
        }

        // first entry is always the default language
        $data["default_language"] = 0;

        return $data ? $data : array();
    }

    // remove all Translations of current category
    public function removeHeaderTitleTranslations()
    {
        $ilDB = $this->db;

        $query = "DELETE FROM object_translation WHERE obj_id= " .
            $ilDB->quote($this->getId(), 'integer');
        $res = $ilDB->manipulate($query);
    }

    // add a new translation to current category
    public function addHeaderTitleTranslation($a_title, $a_desc, $a_lang, $a_lang_default)
    {
        $ilDB = $this->db;

        $query = "INSERT INTO object_translation " .
             "(obj_id,title,description,lang_code,lang_default) " .
             "VALUES " .
             "(" . $ilDB->quote($this->getId(), 'integer') . "," .
             $ilDB->quote($a_title, 'text') . "," .
             $ilDB->quote($a_desc, 'text') . "," .
             $ilDB->quote($a_lang, 'text') . "," .
             $ilDB->quote($a_lang_default, 'integer') . ")";
        $res = $ilDB->manipulate($query);

        return true;
    }

    public static function _getId()
    {
        global $DIC;

        $ilDB = $DIC->database();

        $q = "SELECT obj_id FROM object_data WHERE type = " . $ilDB->quote('adm', 'text');
        $r = $ilDB->query($q);
        $row = $ilDB->fetchObject($r);

        return $row->obj_id;
    }

    public static function _getHeaderTitle(): string
    {
        global $DIC;

        $ilDB = $DIC->database();
        $ilUser = $DIC->user();

        $id = ilObjSystemFolder::_getId();

        $title = '';

        $q = "SELECT title FROM object_translation " .
            "WHERE obj_id = " . $ilDB->quote($id, 'integer') . " " .
            "AND lang_default = 1";
        $r = $ilDB->query($q);
        $row = $ilDB->fetchObject($r);
        if ($row !== null) {
            $title = (string) $row->title;
        }

        $q = "SELECT title FROM object_translation " .
            "WHERE obj_id = " . $ilDB->quote($id, 'integer') . " " .
            "AND lang_code = " .
            $ilDB->quote($ilUser->getCurrentLanguage(), 'text') . " " .
            "AND NOT lang_default = 1";
        $r = $ilDB->query($q);
        $row = $ilDB->fetchObject($r);

        if ($row !== null) {
            $title = (string) $row->title;
        }

        return $title;
    }

    public function _getHeaderTitleDescription()
    {
        $ilDB = $this->db;
        $ilUser = $this->user;

        $id = ilObjSystemFolder::_getId();

        $q = "SELECT title,description FROM object_translation " .
            "WHERE obj_id = " . $ilDB->quote($id, 'integer') . " " .
            "AND lang_default = 1";
        $r = $ilDB->query($q);
        $row = $ilDB->fetchObject($r);
        $description = $row->description;

        $q = "SELECT title,description FROM object_translation " .
            "WHERE obj_id = " . $ilDB->quote($id, 'integer') . " " .
            "AND lang_code = " .
            $ilDB->quote($ilUser->getPref("language"), 'text') . " " .
            "AND NOT lang_default = 1";
        $r = $ilDB->query($q);
        $row = $ilDB->fetchObject($r);

        if ($row) {
            $description = ilStr::shortenTextExtended($row->description, ilObject::DESC_LENGTH, true);
        }

        return $description;
    }
} // END class.ilObjSystemFolder