class.ilContainerSkills.php

Go to the documentation of this file.

<?php
 
/* Copyright (c) 1998-2017 ILIAS open source, Extended GPL, see docs/LICENSE */
 
class ilContainerSkills
{
 
    protected $db;
 
    protected $skills = array();
 
    protected $id;
 
    public function __construct($a_obj_id)
    {
        global $DIC;
 
        $this->db = $DIC->database();
 
        $this->setId($a_obj_id);
        if ($a_obj_id > 0) {
            $this->read();
        }
    }
 
    public function setId($a_val)
    {
        $this->id = $a_val;
    }
 
    public function getId()
    {
        return $this->id;
    }
 
    public function resetSkills()
    {
        $this->skills = array();
    }
 
    public function addSkill($a_skill_id, $a_tref_id)
    {
        $this->skills[$a_skill_id . "-" . $a_tref_id] = array(
            "skill_id" => $a_skill_id,
            "tref_id" => $a_tref_id
        );
    }
 
    public function removeSkill($a_skill_id, $a_tref_id)
    {
        unset($this->skills[$a_skill_id . "-" . $a_tref_id]);
    }
 
 
    public function getSkills()
    {
        return $this->skills;
    }
 
    public function getOrderedSkills()
    {
        $vtree = new ilVirtualSkillTree();
        return $vtree->getOrderedNodeset($this->getSkills(), "skill_id", "tref_id");
    }
 
 
    public function read()
    {
        $db = $this->db;
 
        $this->skills = array();
        $set = $db->query("SELECT * FROM cont_skills " .
            " WHERE id  = " . $db->quote($this->getId(), "integer"));
        while ($rec = $db->fetchAssoc($set)) {
            $this->skills[$rec["skill_id"] . "-" . $rec["tref_id"]] = $rec;
        }
    }
 
    public function delete()
    {
        $db = $this->db;
 
        $db->manipulate("DELETE FROM cont_skills WHERE " .
            " id = " . $db->quote($this->getId(), "integer"));
    }
 
    public function save()
    {
        $db = $this->db;
 
        $this->delete();
        foreach ($this->skills as $s) {
            $db->manipulate("INSERT INTO cont_skills " .
                "(id, skill_id, tref_id) VALUES (" .
                $db->quote($this->getId(), "integer") . "," .
                $db->quote($s["skill_id"], "integer") . "," .
                $db->quote($s["tref_id"], "integer") . ")");
        }
    }
}