class.ilSkillTemplateReference.php

Go to the documentation of this file.

<?php

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

class ilSkillTemplateReference extends ilSkillTreeNode
{
    protected $db;

    public $id;

    public function __construct($a_id = 0)
    {
        global $DIC;

        $this->db = $DIC->database();
        parent::__construct($a_id);
        $this->setType("sktr");
    }

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

    public function create()
    {
        $ilDB = $this->db;
        
        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") .
            ")");
    }
    
    public function update()
    {
        $ilDB = $this->db;
        
        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")
            );
    }
    

    public function delete()
    {
        $ilDB = $this->db;

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

        parent::delete();
    }

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

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

        $ilDB = $DIC->database();

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

    public static function _lookupTrefIdsForTopTemplateId($a_template_id)
    {
        global $DIC;

        $ilDB = $DIC->database();

        $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;
    }


    public static function _lookupTrefIdsForTemplateId($a_tid)
    {
        $tree = new ilSkillTree();
        $top_template_id = $tree->getTopParentNodeId($a_tid);
        return self::_lookupTrefIdsForTopTemplateId($top_template_id);
    }
}