class.ilSCORMTree.php

Go to the documentation of this file.

<?php

declare(strict_types=1);
class ilSCORMTree extends ilTree
{
    public function __construct(int $a_id = 0)
    {
        parent::__construct($a_id);
        $this->setTableNames('scorm_tree', 'scorm_object');
        $this->setTreeTablePK('slm_id');
    }

    public function getChilds(int $a_node_id, string $a_order = "", string $a_direction = "ASC"): array
    {
        global $DIC;
        $ilDB = $DIC->database();

        if (!isset($a_node_id)) {
            $message = "No node_id given!";
            $this->logger->error($message);
            throw new InvalidArgumentException($message);
        }

        // init childs
        $childs = array();

        // number of childs
        $count = 0;

        // init order_clause
        $order_clause = "";

        // set order_clause if sort order parameter is given
        if (!empty($a_order)) {
            $order_clause = "ORDER BY " . $a_order . " " . $a_direction;
        } else {
            $order_clause = "ORDER BY " . $this->table_tree . ".lft";
        }

        $r = $ilDB->queryF(
            "
                        SELECT * FROM " . $this->table_tree . " " .
            $this->buildJoin() .
            "WHERE parent = %s " .
            "AND " . $this->table_tree . "." . $this->tree_pk . " = %s " .
            $order_clause,
            array('integer','integer'),
            array($a_node_id,$this->tree_id)
        );

        $count = $ilDB->numRows($r);

        if ($count > 0) {
            while ($row = $ilDB->fetchAssoc($r)) {
                $childs[] = $this->fetchNodeData($row);
            }

            // mark the last child node (important for display)
            $childs[$count - 1]["last"] = true;

            return $childs;
        }

        return $childs;
    }
}