class.ilECSCmsTree.php

Go to the documentation of this file.

<?php
/* Copyright (c) 1998-2009 ILIAS open source, Extended GPL, see docs/LICENSE */

include_once './Services/Tree/classes/class.ilTree.php';

class ilECSCmsTree extends ilTree
{
        public function __construct($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($tree, $a_child)
        {
                global $ilDB;

                $query = 'INSERT INTO ecs_cms_tree '.
                        '(tree,child,parent,lft,rgt,depth) '.
                        'VALUES ( '.
                        $ilDB->quote($tree,'integer').', '.
                        $ilDB->quote($a_child,'integer').', '.
                        $ilDB->quote(0,'integer').', '.
                        $ilDB->quote(1,'integer').', '.
                        $ilDB->quote(100,'integer').', '.
                        $ilDB->quote(1,'integer').' )';

                $ilDB->manipulate($query);
                
                
                return true;
        }
        
        public static function deleteByTreeId($a_tree_id)
        {
                global $ilDB;
                
                $query = 'DELETE FROM ecs_cms_tree '.
                                'WHERE tree = '.$ilDB->quote($a_tree_id,'integer');
                $ilDB->manipulate($query);
                return true;
        }

        public function treeExists($a_tree_id)
        {
                global $ilDB;

                $query = 'SELECT COUNT(*) num FROM ecs_cms_tree WHERE tree = '.$ilDB->quote($a_tree_id,'integer');
                $res = $ilDB->query($query);
                while($row = $res->fetchRow(DB_FETCHMODE_OBJECT))
                {
                        return $row->num > 0 ? true : false;
                }
                return false;
        }


        public static function lookupRootId($a_tree_id)
        {
                global $ilDB;

                $query = 'SELECT child FROM ecs_cms_tree WHERE tree = '.$ilDB->quote($a_tree_id,'integer');
                $res = $ilDB->query($query);
                while($row = $res->fetchRow(DB_FETCHMODE_OBJECT))
                {
                        return $row->child;
                }
                return 0;
        }
}
?>