class.ilSkillResources.php

Go to the documentation of this file.

<?php
 
/* Copyright (c) 1998-2012 ILIAS open source, Extended GPL, see docs/LICENSE */
 
include_once("./Services/Skill/interfaces/interface.ilSkillUsageInfo.php");
 
class ilSkillResources implements ilSkillUsageInfo
{
    protected $db;
 
    protected $tree;
 
    protected $base_skill_id;   // base skill id
    protected $tref_id;                 // template reference id (if no template involved: 0)
    
    // The resources array has the following keys (int)
    // first dimension is "level_id" (int): the skill level id
    // second dimension is "rep_ref_id" (int): the ref id of the repository resource
    //
    // The values of the array are associatives arrays with the following key value pairs:
    // level_id (int): the skill level id
    // rep_ref_id (int): the ref id of the repository resource
    // trigger: 1, if the resource triggers the skill level (0 otherwise)
    // imparting: 1, if the resource imparts knowledge of the skill level (0 otherwise)
    protected $resources = array();
    
    public function __construct($a_skill_id = 0, $a_tref_id = 0)
    {
        global $DIC;
 
        $this->db = $DIC->database();
        $this->tree = $DIC->repositoryTree();
        $this->setBaseSkillId($a_skill_id);
        $this->setTemplateRefId($a_tref_id);
        
        if ($a_skill_id > 0) {
            $this->readResources();
        }
    }
    
    public function setBaseSkillId($a_val)
    {
        $this->base_skill_id = (int) $a_val;
    }
    
    public function getBaseSkillId()
    {
        return $this->base_skill_id;
    }
    
    public function setTemplateRefId($a_val)
    {
        $this->tref_id = (int) $a_val;
    }
    
    public function getTemplateRefId()
    {
        return $this->tref_id;
    }
    
    public function readResources()
    {
        $ilDB = $this->db;
        $tree = $this->tree;
        
        $set = $ilDB->query(
            "SELECT * FROM skl_skill_resource " .
            " WHERE base_skill_id = " . $ilDB->quote($this->getBaseSkillId(), "integer") .
            " AND tref_id = " . $ilDB->quote($this->getTemplateRefId(), "integer")
        );
        while ($rec = $ilDB->fetchAssoc($set)) {
            if ($tree->isInTree($rec["rep_ref_id"])) {
                $this->resources[$rec["level_id"]][$rec["rep_ref_id"]] = array(
                    "level_id" => $rec["level_id"],
                    "rep_ref_id" => $rec["rep_ref_id"],
                    "trigger" => $rec["ltrigger"],
                    "imparting" => $rec["imparting"]
                    );
            }
        }
    }
    
    public function save()
    {
        $ilDB = $this->db;
        
        $ilDB->manipulate(
            "DELETE FROM skl_skill_resource WHERE " .
            " base_skill_id = " . $ilDB->quote((int) $this->getBaseSkillId(), "integer") .
            " AND tref_id = " . $ilDB->quote((int) $this->getTemplateRefId(), "integer")
        );
        foreach ($this->getResources() as $level_id => $l) {
            foreach ($l as $ref_id => $r) {
                if ($r["imparting"] || $r["trigger"]) {
                    $ilDB->manipulate("INSERT INTO skl_skill_resource " .
                        "(base_skill_id, tref_id, level_id, rep_ref_id, imparting, ltrigger) VALUES (" .
                        $ilDB->quote((int) $this->getBaseSkillId(), "integer") . "," .
                        $ilDB->quote((int) $this->getTemplateRefId(), "integer") . "," .
                        $ilDB->quote((int) $level_id, "integer") . "," .
                        $ilDB->quote((int) $ref_id, "integer") . "," .
                        $ilDB->quote((int) $r["imparting"], "integer") . "," .
                        $ilDB->quote((int) $r["trigger"], "integer") .
                        ")");
                }
            }
        }
    }
    
    public function getResources()
    {
        return $this->resources;
    }
    
    public function getResourcesOfLevel($a_level_id)
    {
        $ret = (is_array($this->resources[$a_level_id]))
            ? $this->resources[$a_level_id]
            : array();
            
        return $ret;
    }
    
    public function setResourceAsTrigger($a_level_id, $a_rep_ref_id, $a_trigger = true)
    {
        if (!is_array($this->resources[$a_level_id])) {
            $this->resources[$a_level_id] = array();
        }
        if (!is_array($this->resources[$a_level_id][$a_rep_ref_id])) {
            $this->resources[$a_level_id][$a_rep_ref_id] = array();
        }
        
        $this->resources[$a_level_id][$a_rep_ref_id]["trigger"] = $a_trigger;
    }
 
    public function setResourceAsImparting($a_level_id, $a_rep_ref_id, $a_imparting = true)
    {
        if (!is_array($this->resources[$a_level_id])) {
            $this->resources[$a_level_id] = array();
        }
        if (!is_array($this->resources[$a_level_id][$a_rep_ref_id])) {
            $this->resources[$a_level_id][$a_rep_ref_id] = array();
        }
        
        $this->resources[$a_level_id][$a_rep_ref_id]["imparting"] = $a_imparting;
    }
 
    public static function getUsageInfo($a_cskill_ids, &$a_usages)
    {
        global $DIC;
 
        $ilDB = $DIC->database();
        
        include_once("./Services/Skill/classes/class.ilSkillUsage.php");
        ilSkillUsage::getUsageInfoGeneric(
            $a_cskill_ids,
            $a_usages,
            ilSkillUsage::RESOURCE,
            "skl_skill_resource",
            "rep_ref_id",
            "base_skill_id"
        );
    }
 
    public static function getTriggerLevelsForRefId($a_ref_id)
    {
        global $DIC;
 
        $db = $DIC->database();
 
        $set = $db->query("SELECT * FROM skl_skill_resource " .
            " WHERE rep_ref_id = " . $db->quote($a_ref_id, "integer") .
            " AND ltrigger = " . $db->quote(1, "integer"));
 
        $skill_levels = array();
        while ($rec = $db->fetchAssoc($set)) {
            $skill_levels[] = array(
                "base_skill_id" => $rec["base_skill_id"],
                "tref_id" => $rec["tref_id"],
                "level_id" => $rec["level_id"]
            );
        }
        return $skill_levels;
    }
}