class.ilSkillTemplateReference.php

Go to the documentation of this file.

<?php

/* Copyright (c) 1998-2010 ILIAS open source, Extended GPL, see docs/LICENSE */

include_once("./Services/Skill/classes/class.ilSkillTreeNode.php");

class ilSkillTemplateReference extends ilSkillTreeNode
{
        var $id;

        function __construct($a_id = 0)
        {
                parent::ilSkillTreeNode($a_id);
                $this->setType("sktr");
        }

        function setSkillTemplateId($a_val)
        {
                $this->skill_template_id = $a_val;
        }
        
        function getSkillTemplateId()
        {
                return $this->skill_template_id;
        }
        
        function read()
        {
                global $ilDB;
                
                parent::read();
                
                $set = $ilDB->query("SELECT * FROM skl_templ_ref ".
                        " WHERE skl_node_id = ".$ilDB->quote($this->getId(), "integer")
                        );
                $rec  = $ilDB->fetchAssoc($set);
                $this->setSkillTemplateId((int) $rec["templ_id"]);
        }

        function create()
        {
                global $ilDB;
                
                parent::create();
                
                $ilDB->manipulate("INSERT INTO skl_templ_ref ".
                        "(skl_node_id, templ_id) VALUES (".
                        $ilDB->quote($this->getId(), "integer").",".
                        $ilDB->quote($this->getSkillTemplateId(), "integer").
                        ")");
        }
        
        function update()
        {
                global $ilDB;
                
                parent::update();
                
                $ilDB->manipulate("UPDATE skl_templ_ref SET ".
                        " templ_id = ".$ilDB->quote($this->getSkillTemplateId(), "integer").
                        " WHERE skl_node_id = ".$ilDB->quote($this->getId(), "integer")
                        );
        }
        

        function delete()
        {
                global $ilDB;

                $ilDB->manipulate("DELETE FROM skl_templ_ref WHERE "
                        ." skl_node_id = ".$ilDB->quote($this->getId(), "integer")
                        );

                parent::delete();
        }

        function copy()
        {
                $sktr = new ilSkillTemplateReference();
                $sktr->setTitle($this->getTitle());
                $sktr->setType($this->getType());
                $sktr->setSkillTemplateId($this->getSkillTemplateId());
                $sktr->setSelfEvaluation($this->getSelfEvaluation());
                $sktr->setOrderNr($this->getOrderNr());
                $sktr->create();

                return $sktr;
        }
        
        static function _lookupTemplateId($a_obj_id)
        {
                global $ilDB;

                $query = "SELECT templ_id FROM skl_templ_ref WHERE skl_node_id = ".
                        $ilDB->quote($a_obj_id, "integer");
                $obj_set = $ilDB->query($query);
                $obj_rec = $ilDB->fetchAssoc($obj_set);

                return $obj_rec["templ_id"];
        }

        function _lookupTrefIdsForTopTemplateId($a_template_id)
        {
                global $ilDB;

                $set = $ilDB->query("SELECT * FROM skl_templ_ref ".
                        " WHERE templ_id = ".$ilDB->quote($a_template_id, "integer")
                        );
                $trefs = array();
                while ($rec = $ilDB->fetchAssoc($set))
                {
                        $trefs[] = $rec["skl_node_id"];
                }
                return $trefs;
        }


        static function _lookupTrefIdsForTemplateId($a_tid)
        {
                include_once("./Services/Skill/classes/class.ilSkillTree.php");
                $tree = new ilSkillTree();
                $top_template_id = $tree->getTopParentNodeId($a_tid);
                return self::_lookupTrefIdsForTopTemplateId($top_template_id);
        }

}
?>