content/classes/SCORM/class.ilSCORMTree.php

Go to the documentation of this file.

<?php
/*
        +-----------------------------------------------------------------------------+
        | ILIAS open source                                                           |
        +-----------------------------------------------------------------------------+
        | Copyright (c) 1998-2001 ILIAS open source, University of Cologne            |
        |                                                                             |
        | This program is free software; you can redistribute it and/or               |
        | modify it under the terms of the GNU General Public License                 |
        | as published by the Free Software Foundation; either version 2              |
        | of the License, or (at your option) any later version.                      |
        |                                                                             |
        | This program is distributed in the hope that it will be useful,             |
        | but WITHOUT ANY WARRANTY; without even the implied warranty of              |
        | MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the               |
        | GNU General Public License for more details.                                |
        |                                                                             |
        | You should have received a copy of the GNU General Public License           |
        | along with this program; if not, write to the Free Software                 |
        | Foundation, Inc., 59 Temple Place - Suite 330, Boston, MA  02111-1307, USA. |
        +-----------------------------------------------------------------------------+
*/

require_once ("classes/class.ilTree.php");

class ilSCORMTree extends ilTree
{

        function ilSCORMTree($a_id = 0)
        {
                parent::ilTree($a_id);
                $this->setTableNames('scorm_tree','scorm_object');
                $this->setTreeTablePK('slm_id');
        }
        
        function getChilds($a_node_id, $a_order = "", $a_direction = "ASC")
        {
                if (!isset($a_node_id))
                {
                        $message = get_class($this)."::getChilds(): No node_id given!";
                        $this->ilErr->raiseError($message,$this->ilErr->WARNING);
                }

                // 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";
                }

        //666
                $q = "SELECT * FROM ".$this->table_tree." ".
                         $this->buildJoin().
                         "WHERE parent = '".$a_node_id."' ".
                         "AND ".$this->table_tree.".".$this->tree_pk." = '".$this->tree_id."' ".                         
                         $order_clause;
        
                $r = $this->ilDB->query($q);

                $count = $r->numRows();
                

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

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

                        return $childs;
                }
                else
                {
                        return $childs;
                }
        }
}
?>