class.ilLMTree.php

Go to the documentation of this file.

<?php
 
/* Copyright (c) 1998-2014 ILIAS open source, Extended GPL, see docs/LICENSE */
 
class ilLMTree extends ilTree
{
    protected $db;
 
    public static $instances = array();
 
    public function __construct($a_tree_id)
    {
        global $DIC;
 
        $this->db = $DIC->database();
        parent::__construct($a_tree_id);
        $this->setTableNames('lm_tree', 'lm_data');
        $this->setTreeTablePK("lm_id");
        $this->useCache(true);
    }
 
    public static function getInstance($a_tree_id)
    {
        if (isset(self::$instances[$a_tree_id])) {
            return self::$instances[$a_tree_id];
        }
        $tree = new ilLMTree($a_tree_id);
        self::$instances[$a_tree_id] = $tree;
 
        return $tree;
    }
 
 
    public function isCacheUsed()
    {
        return $this->use_cache;
    }
 
    
    public function getLastActivePage()
    {
        $ilDB = $this->db;
        
        $ilDB->setLimit(1);
        
        $sql = "SELECT lm_data.obj_id" .
            " FROM lm_data" .
            " JOIN lm_tree ON (lm_tree.child = lm_data.obj_id)" .
            " JOIN page_object ON (page_object.page_id = lm_data.obj_id AND page_object.parent_type = " . $ilDB->quote("lm", "text") . ")" .
            " WHERE lm_tree.lm_id = " . $ilDB->quote($this->tree_id, "integer") .
            " AND lm_data.type = " . $ilDB->quote("pg", "text") .
            " AND page_object.active = " . $ilDB->quote(1, "integer") .
            " ORDER BY lm_tree.rgt DESC";
        $set = $ilDB->query($sql);
        $row = $ilDB->fetchAssoc($set);
        return (int) $row["obj_id"];
    }
}