class.ilLMTree.php

Go to the documentation of this file.

<?php

class ilLMTree extends ilTree
{
    public static array $instances = [];
    protected ?array $complete_tree = null;

    public function __construct(
        int $a_tree_id,
        bool $read_root_id = true
    ) {
        parent::__construct($a_tree_id);
        $this->setTableNames('lm_tree', 'lm_data');
        $this->setTreeTablePK("lm_id");
        $this->useCache(true);
        if ($read_root_id) {
            $this->readRootId();
        }
    }

    public static function getInstance(
        int $a_tree_id
    ): self {
        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(): bool
    {
        return $this->use_cache;
    }

    public function getLastActivePage(): int
    {
        $ilDB = $this->db;

        $ilDB->setLimit(1, 0);

        $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"] ?? 0);
    }

    public function getCompleteTree(): array
    {
        if (is_null($this->complete_tree)) {
            $this->complete_tree = $this->getSubTree($this->getNodeData($this->readRootId()));
        }
        return $this->complete_tree;
    }
}