class.ilECSCmsTree.php

Go to the documentation of this file.

<?php

declare(strict_types=1);

class ilECSCmsTree extends ilTree
{
    public function __construct(int $a_tree_id)
    {
        parent::__construct($a_tree_id, self::lookupRootId($a_tree_id));

        $this->setObjectTablePK('obj_id');
        $this->setTableNames('ecs_cms_tree', 'ecs_cms_data');
        $this->useCache(false);
    }

    public function insertRootNode(int $tree, int $a_child): bool
    {
        $query = 'INSERT INTO ecs_cms_tree ' .
            '(tree,child,parent,lft,rgt,depth) ' .
            'VALUES ( ' .
            $this->db->quote($tree, 'integer') . ', ' .
            $this->db->quote($a_child, 'integer') . ', ' .
            $this->db->quote(0, 'integer') . ', ' .
            $this->db->quote(1, 'integer') . ', ' .
            $this->db->quote(100, 'integer') . ', ' .
            $this->db->quote(1, 'integer') . ' )';

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

        return true;
    }

    public static function deleteByTreeId(int $a_tree_id): bool
    {
        global $DIC;

        $ilDB = $DIC['ilDB'];

        $DIC->logger()->wsrv()->debug('Deleting cms tree: ' . $a_tree_id);
        $query = 'DELETE FROM ecs_cms_tree ' .
                'WHERE tree = ' . $ilDB->quote($a_tree_id, 'integer');
        $ilDB->manipulate($query);
        return true;
    }

    public function treeExists(int $a_tree_id): bool
    {
        $query = 'SELECT COUNT(*) num FROM ecs_cms_tree WHERE tree = ' . $this->db->quote($a_tree_id, 'integer');
        $res = $this->db->query($query);
        if ($row = $res->fetchRow(ilDBConstants::FETCHMODE_OBJECT)) {
            return $row->num > 0;
        }
        return false;
    }


    public static function lookupRootId($a_tree_id): int
    {
        global $DIC;

        $ilDB = $DIC['ilDB'];

        $query = 'SELECT child FROM ecs_cms_tree WHERE tree = ' . $ilDB->quote($a_tree_id, 'integer');
        $res = $ilDB->query($query);
        if ($row = $res->fetchRow(ilDBConstants::FETCHMODE_OBJECT)) {
            return (int) $row->child;
        }
        return 0;
    }
}