class.ilBasicSkill.php

Go to the documentation of this file.

<?php
 
/* Copyright (c) 1998-2013 ILIAS open source, Extended GPL, see docs/LICENSE */
 
include_once("./Services/Skill/classes/class.ilSkillTreeNode.php");
include_once("./Services/Skill/interfaces/interface.ilSkillUsageInfo.php");
 
class ilBasicSkill extends ilSkillTreeNode implements ilSkillUsageInfo
{
        const ACHIEVED = 1;
        const NOT_ACHIEVED = 0;
 
        const EVAL_BY_OTHERS_= 0;
        const EVAL_BY_SELF = 1;
        const EVAL_BY_ALL = 2;
 
        var $id;
 
        function __construct($a_id = 0)
        {
                parent::ilSkillTreeNode($a_id);
                $this->setType("skll");
        }
 
        function read()
        {
                parent::read();
        }
 
        function create()
        {
                parent::create();
        }
 
        function delete()
        {
                global $ilDB;
 
                $ilDB->manipulate("DELETE FROM skl_level WHERE "
                        ." skill_id = ".$ilDB->quote($this->getId(), "integer")
                        );
 
                $ilDB->manipulate("DELETE FROM skl_user_has_level WHERE "
                        ." skill_id = ".$ilDB->quote($this->getId(), "integer")
                        );
 
                parent::delete();
        }
 
        function copy()
        {
                $skill = new ilBasicSkill();
                $skill->setTitle($this->getTitle());
                $skill->setType($this->getType());
                $skill->setSelfEvaluation($this->getSelfEvaluation());
                $skill->setOrderNr($this->getOrderNr());
                $skill->create();
 
                $levels = $this->getLevelData();
                if (sizeof($levels))
                {
                        foreach($levels as $item)
                        {
                                $skill->addLevel($item["title"], $item["description"]);
                        }
                }
                $skill->update();
                
                return $skill;
        }
 
        //
        //
        // Skill level related methods
        //
        //
 
        function addLevel($a_title, $a_description)
        {
                global $ilDB;
 
                $nr = $this->getMaxLevelNr();
                $nid = $ilDB->nextId("skl_level");
                $ilDB->insert("skl_level", array(
                        "id" => array("integer", $nid),
                        "skill_id" => array("integer", $this->getId()),
                        "nr" => array("integer", $nr+1),
                        "title" => array("text", $a_title),
                        "description" => array("clob", $a_description)
                        ));
 
        }
 
        function getMaxLevelNr()
        {
                global $ilDB;
 
                $set = $ilDB->query("SELECT MAX(nr) mnr FROM skl_level WHERE ".
                        " skill_id = ".$ilDB->quote($this->getId(), "integer")
                        );
                $rec = $ilDB->fetchAssoc($set);
                return (int) $rec["mnr"];
        }
 
        function getLevelData($a_id = 0)
        {
                global $ilDB;
 
                if ($a_id > 0)
                {
                        $and = " AND id = ".$ilDB->quote($a_id, "integer");
                }
 
                $set = $ilDB->query("SELECT * FROM skl_level WHERE ".
                        " skill_id = ".$ilDB->quote($this->getId(), "integer").
                        $and.
                        " ORDER BY nr"
                        );
                $levels = array();
                while ($rec = $ilDB->fetchAssoc($set))
                {
                        if ($a_id > 0)
                        {
                                return $rec;
                        }
                        $levels[] = $rec;
                }
                return $levels;
        }
 
        protected static function lookupLevelProperty($a_id, $a_prop)
        {
                global $ilDB;
 
                $set = $ilDB->query("SELECT $a_prop FROM skl_level WHERE ".
                        " id = ".$ilDB->quote($a_id, "integer")
                );
                $rec = $ilDB->fetchAssoc($set);
                return $rec[$a_prop];
        }
 
        static function lookupLevelTitle($a_id)
        {
                return ilBasicSkill::lookupLevelProperty($a_id, "title");
        }
 
        static function lookupLevelDescription($a_id)
        {
                return ilBasicSkill::lookupLevelProperty($a_id, "description");
        }
 
        static function lookupLevelTrigger($a_id)
        {
die("ilBasicSkill::lookupLevelTrigger is deprecated.");
                $ref_id = ilBasicSkill::lookupLevelProperty($a_id, "trigger_ref_id");
                $obj_id = ilBasicSkill::lookupLevelProperty($a_id, "trigger_obj_id");
                return array("ref_id" => $ref_id, "obj_id" => $obj_id);
        }
 
        static function lookupLevelSkillId($a_id)
        {
                return ilBasicSkill::lookupLevelProperty($a_id, "skill_id");
        }
 
        static protected function writeLevelProperty($a_id, $a_prop, $a_value, $a_type)
        {
                global $ilDB;
 
                $ilDB->update("skl_level", array(
                        $a_prop => array($a_type, $a_value),
                        ), array(
                        "id" => array("integer", $a_id),
                ));
        }
 
        static function writeLevelTitle($a_id, $a_title)
        {
                ilBasicSkill::writeLevelProperty($a_id, "title", $a_title, "text");
        }
 
        static function writeLevelDescription($a_id, $a_description)
        {
                ilBasicSkill::writeLevelProperty($a_id, "description", $a_description, "clob");
        }
 
        static function writeLevelTrigger($a_id, $a_trigger_ref_id)
        {
die("ilBasicSkill::writeLevelTrigger is deprecated.");
                $a_trigger_obj_id = 0;
                if ($a_trigger_ref_id > 0)
                {
                        $a_trigger_obj_id = ilObject::_lookupObjId($a_trigger_ref_id);
                }
                ilBasicSkill::writeLevelProperty($a_id, "trigger_ref_id", $a_trigger_ref_id, "integer");
                ilBasicSkill::writeLevelProperty($a_id, "trigger_obj_id", $a_trigger_obj_id, "integer");
        }
 
        function updateLevelOrder($order)
        {
                global $ilDB;
 
                asort($order);
 
                $cnt = 1;
                foreach ($order as $id => $o)
                {
                        $ilDB->manipulate("UPDATE skl_level SET ".
                                " nr = ".$ilDB->quote($cnt, "integer").
                                " WHERE id = ".$ilDB->quote($id, "integer")
                                );
                        $cnt++;
                }
        }
 
        function deleteLevel($a_id)
        {
                global $ilDB;
 
                $ilDB->manipulate("DELETE FROM skl_level WHERE "
                        ." id = ".$ilDB->quote($a_id, "integer")
                        );
 
        }
 
        function fixLevelNumbering()
        {
                global $ilDB;
 
                $set = $ilDB->query("SELECT id, nr FROM skl_level WHERE ".
                        " skill_id = ".$ilDB->quote($this->getId(), "integer").
                        " ORDER BY nr ASC"
                );
                $cnt = 1;
                while ($rec = $ilDB->fetchAssoc($set))
                {
                        $ilDB->manipulate("UPDATE skl_level SET ".
                                " nr = ".$ilDB->quote($cnt, "integer").
                                " WHERE id = ".$ilDB->quote($rec["id"], "integer")
                                );
                        $cnt++;
                }
        }
 
        function lookupLevelsForTriggerRefId($a_ref_id)
        {
                global $ilDB;
die("ilBasicSkill::lookupLevelsForTriggerRefId is deprecated.");
                $set = $ilDB->query("SELECT id FROM skl_level WHERE ".
                        " trigger_ref_id = ".$ilDB->quote($a_ref_id, "integer")
                        );
                $levels = array();
                while ($rec = $ilDB->fetchAssoc($set))
                {
                        $levels[] = $rec["id"];
                }
                return $levels;
        }
 
        function getSkillForLevelId($a_level_id)
        {
                global $ilDB;
 
                $set = $ilDB->query("SELECT * FROM skl_level WHERE ".
                        " id = ".$ilDB->quote($a_level_id, "integer")
                        );
                $skill = null;
                if ($rec = $ilDB->fetchAssoc($set))
                {
                        if (ilSkillTreeNode::isInTree($rec["skill_id"]))
                        {
                                $skill = new ilBasicSkill($rec["skill_id"]);
                        }
                }
                return $skill;
        }
 
        //
        //
        // User skill (level) related methods
        //
        //
 
 
        public static function updateAllUserSkillLevels()
        {
                global $ilDB;
die("ilBasicSkill::updateAllUserSkillLevels is deprecated.");
                $set = $ilDB->query("SELECT id, trigger_obj_id FROM skl_level WHERE ".
                        " trigger_obj_id > ".$ilDB->quote(0, "integer")
                );
                while ($rec = $ilDB->fetchAssoc($set))          // all trigger objects
                {
                        $skill_level_id = $rec["id"];
                        $tr_obj_id = $rec["trigger_obj_id"];
 
                        if (ilObject::_hasUntrashedReference($tr_obj_id))
                        {
                                include_once("./Services/Tracking/classes/class.ilLPStatusWrapper.php");
                                $completed = ilLPStatusWrapper::_lookupCompletedForObject($tr_obj_id);
                                foreach ($completed as $user_id)
                                {
                                        ilBasicSkill::writeUserSkillLevelStatus($skill_level_id,
                                                $user_id, ilBasicSkill::ACHIEVED);
                                }
                        }
                }
        }
 
        public static function updateSkillLevelsByTriggerRef($a_user_id, $a_ref_id)
        {
                global $ilDB;
die("ilBasicSkill::updateSkillLevelsByTriggerRef is deprecated.");
                $set = $ilDB->query("SELECT id, trigger_obj_id FROM skl_level WHERE ".
                        " trigger_ref_id = ".$ilDB->quote($a_ref_id, "integer")
                );
                while ($rec = $ilDB->fetchAssoc($set))          // all trigger objects
                {
                        $skill_level_id = $rec["id"];
                        $tr_obj_id = $rec["trigger_obj_id"];
 
                        if (ilObject::_hasUntrashedReference($tr_obj_id))
                        {
                                include_once("./Services/Tracking/classes/class.ilLPStatusWrapper.php");
                                $completed = ilLPStatusWrapper::_lookupCompletedForObject($tr_obj_id);
                                foreach ($completed as $user_id)
                                {
                                        if ($a_user_id == $user_id)
                                        {
                                                ilBasicSkill::writeUserSkillLevelStatus($skill_level_id,
                                                        $user_id, ilBasicSkill::ACHIEVED);
                                        }
                                }
                        }
                }
        }
 
        static function writeUserSkillLevelStatus($a_level_id, $a_user_id,
                $a_trigger_ref_id, $a_tref_id = 0, $a_status = ilBasicSkill::ACHIEVED, $a_force = false,
                $a_self_eval = 0)
        {
                global $ilDB;
 
                $skill_id = ilBasicSkill::lookupLevelSkillId($a_level_id);
                $trigger_ref_id = $a_trigger_ref_id;
                $trigger_obj_id = ilObject::_lookupObjId($trigger_ref_id);
                $trigger_title = ilObject::_lookupTitle($trigger_obj_id);
                $trigger_type = ilObject::_lookupType($trigger_obj_id);
 
                $update = false;
 
                        // check whether current skill user level is identical
                        // to the one that should be set (-> no change required)
/*                      $ilDB->setLimit(1);
                        $set = $ilDB->query("SELECT status, valid FROM skl_user_skill_level WHERE ".
                                "level_id = ".$ilDB->quote($a_level_id, "integer")." AND ".
                                "user_id = ".$ilDB->quote($a_user_id, "integer")." AND ".
                                "tref_id = ".$ilDB->quote((int) $a_tref_id, "integer")." AND ".
                                "trigger_obj_id = ".$ilDB->quote($trigger_obj_id, "integer")." AND ".
                                "self_eval = ".$ilDB->quote($a_self_eval, "integer").
                                " ORDER BY status_date DESC"
                        );
                        $rec = $ilDB->fetchAssoc($set);
                        if (!$rec["valid"] || $rec["status"] != $a_status)
                        {
                                $save = true;
                        }*/
 
                if ($a_self_eval)
                {
                        $ilDB->setLimit(1);
                        $set = $ilDB->query("SELECT * FROM skl_user_skill_level WHERE ".
                                "skill_id = ".$ilDB->quote($skill_id, "integer")." AND ".
                                "user_id = ".$ilDB->quote($a_user_id, "integer")." AND ".
                                "tref_id = ".$ilDB->quote((int) $a_tref_id, "integer")." AND ".
                                "trigger_obj_id = ".$ilDB->quote($trigger_obj_id, "integer")." AND ".
                                "self_eval = ".$ilDB->quote($a_self_eval, "integer").
                                " ORDER BY status_date DESC"
                        );
                        $rec = $ilDB->fetchAssoc($set);
                        $status_day = substr($rec["status_date"], 0, 10);
                        $today = substr(ilUtil::now(), 0, 10);
                        if ($rec["valid"] && $rec["status"] == $a_status && $status_day == $today)
                        {
                                $update = true;
                        }
                }
 
                if ($update)
                {
                        $now = ilUtil::now();
                        $ilDB->manipulate("UPDATE skl_user_skill_level SET ".
                                " level_id = ".$ilDB->quote($a_level_id, "integer").",".
                                " status_date = ".$ilDB->quote($now, "timestamp").
                                " WHERE user_id = ".$ilDB->quote($a_user_id, "integer").
                                " AND status_date = ".$ilDB->quote($rec["status_date"], "timestamp").
                                " AND skill_id = ".$ilDB->quote($rec["skill_id"], "integer").
                                " AND status = ".$ilDB->quote($a_status, "integer").
                                " AND trigger_obj_id = ".$ilDB->quote($trigger_obj_id, "integer").
                                " AND tref_id = ".$ilDB->quote((int) $a_tref_id, "integer").
                                " AND self_eval = ".$ilDB->quote($a_self_eval, "integer")
                                );
                }
                else
                {
                        $now = ilUtil::now();
                        $ilDB->manipulate("INSERT INTO skl_user_skill_level ".
                                "(level_id, user_id, tref_id, status_date, skill_id, status, valid, trigger_ref_id,".
                                "trigger_obj_id, trigger_obj_type, trigger_title, self_eval) VALUES (".
                                $ilDB->quote($a_level_id, "integer").",".
                                $ilDB->quote($a_user_id, "integer").",".
                                $ilDB->quote((int) $a_tref_id, "integer").",".
                                $ilDB->quote($now, "timestamp").",".
                                $ilDB->quote($skill_id, "integer").",".
                                $ilDB->quote($a_status, "integer").",".
                                $ilDB->quote(1, "integer").",".
                                $ilDB->quote($trigger_ref_id, "integer").",".
                                $ilDB->quote($trigger_obj_id, "integer").",".
                                $ilDB->quote($trigger_type, "text").",".
                                $ilDB->quote($trigger_title, "text").",".
                                $ilDB->quote($a_self_eval, "integer").
                                ")");
                }
 
                // fix (removed level_id and added skill id, since table should hold only
                // one entry per skill)
                $ilDB->manipulate("DELETE FROM skl_user_has_level WHERE "
                        ." user_id = ".$ilDB->quote($a_user_id, "integer")
                        ." AND skill_id = ".$ilDB->quote($skill_id, "integer")
                        ." AND tref_id = ".$ilDB->quote((int) $a_tref_id, "integer")
                        ." AND trigger_obj_id = ".$ilDB->quote($trigger_obj_id, "integer")
                        ." AND self_eval = ".$ilDB->quote($a_self_eval, "integer")
                );
 
                if ($a_status == ilBasicSkill::ACHIEVED)
                {
                        $ilDB->manipulate("INSERT INTO skl_user_has_level ".
                        "(level_id, user_id, tref_id, status_date, skill_id, trigger_ref_id, trigger_obj_id, trigger_obj_type, trigger_title, self_eval) VALUES (".
                        $ilDB->quote($a_level_id, "integer").",".
                        $ilDB->quote($a_user_id, "integer").",".
                        $ilDB->quote($a_tref_id, "integer").",".
                        $ilDB->quote($now, "timestamp").",".
                        $ilDB->quote($skill_id, "integer").",".
                        $ilDB->quote($trigger_ref_id, "integer").",".
                        $ilDB->quote($trigger_obj_id, "integer").",".
                        $ilDB->quote($trigger_type, "text").",".
                        $ilDB->quote($trigger_title, "text").",".
                        $ilDB->quote($a_self_eval, "integer").
                        ")");
                }
        }
 
        function getMaxLevelPerType($a_tref_id, $a_type, $a_user_id = 0, $a_self_eval = 0)
        {
                global $ilDB, $ilUser;
                
                if ($a_user_id == 0)
                {
                        $a_user_id = $ilUser->getId();
                }
                
                $set = $ilDB->query($q = "SELECT level_id FROM skl_user_has_level ".
                        " WHERE trigger_obj_type = ".$ilDB->quote($a_type, "text").
                        " AND skill_id = ".$ilDB->quote($this->getId(), "integer").
                        " AND tref_id = ".$ilDB->quote((int) $a_tref_id, "integer").
                        " AND user_id = ".$ilDB->quote($a_user_id, "integer").
                        " AND self_eval = ".$ilDB->quote($a_self_eval, "integer")
                        );
 
                $has_level = array();
                while ($rec = $ilDB->fetchAssoc($set))
                {
                        $has_level[$rec["level_id"]] = true;
                }
                $max_level = 0;
                foreach ($this->getLevelData() as $l)
                {
                        if (isset($has_level[$l["id"]]))
                        {
                                $max_level = $l["id"];
                        }
                }
                return $max_level;
        }
 
        function getAllLevelEntriesOfUser($a_tref_id, $a_user_id = 0, $a_self_eval = 0)
        {
                global $ilDB, $ilUser;
                
                if ($a_user_id == 0)
                {
                        $a_user_id = $ilUser->getId();
                }
                
                $set = $ilDB->query($q = "SELECT * FROM skl_user_has_level ".
                        " WHERE skill_id = ".$ilDB->quote($this->getId(), "integer").
                        " AND tref_id = ".$ilDB->quote((int) $a_tref_id, "integer").
                        " AND user_id = ".$ilDB->quote($a_user_id, "integer").
                        " AND self_eval = ".$ilDB->quote($a_self_eval, "integer").
                        " ORDER BY status_date DESC"
                        );
 
                $levels = array();
                while ($rec = $ilDB->fetchAssoc($set))
                {
                        $levels[] = $rec;
                }
                return $levels;
        }
 
        function getAllHistoricLevelEntriesOfUser($a_tref_id, $a_user_id = 0, $a_eval_by = 0)
        {
                global $ilDB, $ilUser;
 
                if ($a_user_id == 0)
                {
                        $a_user_id = $ilUser->getId();
                }
 
                $by = ($a_eval_by != self::EVAL_BY_ALL)
                        ? " AND self_eval = ".$ilDB->quote($a_self_eval, "integer")
                        : "";
 
                $set = $ilDB->query($q = "SELECT * FROM skl_user_skill_level ".
                                " WHERE skill_id = ".$ilDB->quote($this->getId(), "integer").
                                " AND tref_id = ".$ilDB->quote((int) $a_tref_id, "integer").
                                " AND user_id = ".$ilDB->quote($a_user_id, "integer").
                                $by.
                                " ORDER BY status_date DESC"
                );
                $levels = array();
                while ($rec = $ilDB->fetchAssoc($set))
                {
                        $levels[] = $rec;
                }
                return $levels;
        }
 
 
        function getMaxLevelPerObject($a_tref_id, $a_object_id, $a_user_id = 0, $a_self_eval = 0)
        {
                global $ilDB, $ilUser;
 
                if ($a_user_id == 0)
                {
                        $a_user_id = $ilUser->getId();
                }
 
                $set = $ilDB->query($q = "SELECT level_id FROM skl_user_has_level ".
                                " WHERE trigger_obj_id = ".$ilDB->quote($a_object_id, "integer").
                                " AND skill_id = ".$ilDB->quote($this->getId(), "integer").
                                " AND tref_id = ".$ilDB->quote((int) $a_tref_id, "integer").
                                " AND user_id = ".$ilDB->quote($a_user_id, "integer").
                                " AND self_eval = ".$ilDB->quote($a_self_eval, "integer")
                );
 
                $has_level = array();
                while ($rec = $ilDB->fetchAssoc($set))
                {
                        $has_level[$rec["level_id"]] = true;
                }
                $max_level = 0;
                foreach ($this->getLevelData() as $l)
                {
                        if (isset($has_level[$l["id"]]))
                        {
                                $max_level = $l["id"];
                        }
                }
                return $max_level;
        }
 
        function getLastLevelPerObject($a_tref_id, $a_object_id, $a_user_id = 0, $a_self_eval = 0)
        {
                global $ilDB, $ilUser;
 
                if ($a_user_id == 0)
                {
                        $a_user_id = $ilUser->getId();
                }
 
                $ilDB->setLimit(1);
                $set = $ilDB->query($q = "SELECT level_id FROM skl_user_has_level ".
                                " WHERE trigger_obj_id = ".$ilDB->quote($a_object_id, "integer").
                                " AND skill_id = ".$ilDB->quote($this->getId(), "integer").
                                " AND tref_id = ".$ilDB->quote((int) $a_tref_id, "integer").
                                " AND user_id = ".$ilDB->quote($a_user_id, "integer").
                                " AND self_eval = ".$ilDB->quote($a_self_eval, "integer").
                                " ORDER BY status_date DESC"
                );
 
                $rec = $ilDB->fetchAssoc($set);
 
                return $rec["level_id"];
        }
 
        function getLastUpdatePerObject($a_tref_id, $a_object_id, $a_user_id = 0, $a_self_eval = 0)
        {
                global $ilDB, $ilUser;
 
                if ($a_user_id == 0)
                {
                        $a_user_id = $ilUser->getId();
                }
 
                $ilDB->setLimit(1);
                $set = $ilDB->query($q = "SELECT status_date FROM skl_user_has_level ".
                                " WHERE trigger_obj_id = ".$ilDB->quote($a_object_id, "integer").
                                " AND skill_id = ".$ilDB->quote($this->getId(), "integer").
                                " AND tref_id = ".$ilDB->quote((int) $a_tref_id, "integer").
                                " AND user_id = ".$ilDB->quote($a_user_id, "integer").
                                " AND self_eval = ".$ilDB->quote($a_self_eval, "integer").
                                " ORDER BY status_date DESC"
                );
 
                $rec = $ilDB->fetchAssoc($set);
 
                return $rec["status_date"];
        }
 
        static function getCompletionDateForTriggerRefId($a_user_id, $a_ref_id = null, $a_self_eval = 0)
        {
                global $ilDB;
die("ilBasicSkill::getCompletionDateForTriggerRefId is deprecated.");
                if ($a_ref_id == "")
                {
                        $a_ref_id = null;
                }
                else if (!is_array($a_ref_id))
                {
                        $a_ref_id = array($a_ref_id);
                }
                if (!is_array($a_user_id))
                {
                        $a_user_id = array($a_user_id);
                }
 
                if ($a_ref_id != null)
                {
                        if (!is_array($a_ref_id))
                        {
                                $a_ref_id = array($a_ref_id);
                        }
 
                        $set = $ilDB->query($q = "SELECT user_id, status_date, trigger_ref_id FROM skl_user_has_level WHERE ".
                                $ilDB->in("user_id", $a_user_id, false, "integer")." AND ".
                                $ilDB->in("trigger_ref_id", $a_ref_id, false, "integer")
                        );
 
                        $completion = array();
                        while ($rec = $ilDB->fetchAssoc($set))
                        {
                                if (!isset($completion[$rec["user_id"]][$rec["trigger_ref_id"]]))
                                {
                                        $completion[$rec["user_id"]][$rec["trigger_ref_id"]] = $rec["status_date"];
                                }
                                else if ($rec["status_date"] < $completion[$rec["user_id"]][$rec["trigger_ref_id"]])
                                {
                                        $completion[$rec["user_id"]][$rec["trigger_ref_id"]] = $rec["status_date"];
                                }
                        }
 
                        foreach ($a_ref_id as $ref_id)
                        {
                                foreach ($a_user_id as $user_id)
                                {
                                        if (!isset($completion[$user_id][$ref_id]))
                                        {
                                                $completion[$user_id][$ref_id] = false;
                                        }
                                }
                        }
                }
                else
                {
                        $completion = array();
                        foreach ($a_user_id as $user_id)
                        {
                                include_once 'Services/Membership/classes/class.ilParticipants.php';
                                $a_ref_id = ilParticipants::_getMembershipByType($user_id, 'crs', true);
 
                                $set = $ilDB->query($q = "SELECT user_id, status_date, trigger_ref_id FROM skl_user_has_level WHERE ".
                                        "user_id = ".$ilDB->quote($user_id, "integer")." AND ".
                                        $ilDB->in("trigger_ref_id", $a_ref_id, false, "integer")
                                );
 
                                while ($rec = $ilDB->fetchAssoc($set))
                                {
                                        if (!isset($completion[$user_id][$rec["trigger_ref_id"]]))
                                        {
                                                $completion[$user_id][$rec["trigger_ref_id"]] = $rec["status_date"];
                                        }
                                        else if ($rec["status_date"] < $completion[$user_id][$rec["trigger_ref_id"]])
                                        {
                                                $completion[$user_id][$rec["trigger_ref_id"]] = $rec["status_date"];
                                        }
                                }
                                foreach ($a_ref_id as $ref_id)
                                {
                                        if (!isset($completion[$user_id][$ref_id]))
                                        {
                                                $completion[$user_id][$ref_id] = false;
                                        }
                                }
                        }
                        
                }
                return $completion;
        }
 
        static function checkUserCertificateForTriggerRefId($a_user_id, $a_ref_id, $a_self_eval = 0)
        {
                global $ilDB;
die("ilBasicSkill::checkUserCertificateForTriggerRefId is deprecated.");
                if (!is_array($a_ref_id))
                {
                        $a_ref_id = array($a_ref_id);
                }
                if (!is_array($a_user_id))
                {
                        $a_user_id = array($a_user_id);
                }
                $set = $ilDB->query($q = "SELECT user_id, status_date, trigger_ref_id, level_id, skill_id FROM skl_user_has_level WHERE ".
                        $ilDB->in("user_id", $a_user_id, false, "integer")." AND ".
                        $ilDB->in("trigger_ref_id", $a_ref_id, false, "integer")
                );
 
                $completion = array();
 
                $completion = array();
                while ($rec = $ilDB->fetchAssoc($set))
                {
                        if (!isset($completion[$rec["user_id"]][$rec["trigger_ref_id"]])
                                && ilBasicSkill::_lookupCertificate($rec["skill_id"], $rec["level_id"]))
                        {
                                $completion[$rec["user_id"]][$rec["trigger_ref_id"]] = true;
                        }
                }
 
                foreach ($a_ref_id as $ref_id)
                {
                        foreach ($a_user_id as $user_id)
                        {
                                if (!isset($completion[$user_id][$ref_id]))
                                {
                                        $completion[$user_id][$ref_id] = false;
                                }
                        }
                }
                return $completion;
 
        }
 
        function lookupLevelAchievementDate($a_user_id, $a_level_id, $a_self_eval = 0)
        {
                global $ilDB;
die("ilBasicSkill::lookupLevelAchievementDate is deprecated.");
                $set = $ilDB->query("SELECT user_id, status_date, trigger_ref_id, level_id, skill_id FROM skl_user_has_level WHERE ".
                        " user_id = ".$ilDB->quote($a_user_id, "integer").
                        " AND user_id = ".$ilDB->quote($a_user_id, "integer")
                );
                if ($rec = $ilDB->fetchAssoc($set))
                {
                        return $rec["status_date"];
                }
 
                return false;
        }
 
        static function getTriggerOfAllCertificates($a_user_id, $a_self_eval = 0)
        {
                global $ilDB, $tree;
die("ilBasicSkill::getTriggerOfAllCertificates is deprecated.");
                if (!is_array($a_user_id))
                {
                        $a_user_id = array($a_user_id);
                }
 
                $set = $ilDB->query($q = "SELECT user_id, status_date, trigger_ref_id, level_id, skill_id FROM skl_user_has_level WHERE ".
                        $ilDB->in("user_id", $a_user_id, false, "integer")
                );
 
                $completion = array();
 
                while ($rec = $ilDB->fetchAssoc($set))
                {
                        if ((!is_array($completion[$rec["user_id"]]) || !in_array($rec["trigger_ref_id"], $completion[$rec["user_id"]]))
                                && ilBasicSkill::_lookupCertificate($rec["skill_id"], $rec["level_id"]))
                        {
                                if ($tree->isInTree($rec["trigger_ref_id"]))
                                {
                                        $completion[$rec["user_id"]][] = $rec["trigger_ref_id"];
                                }
                        }
                }
 
                foreach ($a_user_id as $user_id)
                {
                        if (!is_array($completion[$user_id]))
                        {
                                $completion[$user_id] = array();
                        }
                }
                return $completion;
        }
 
        static function getSkillLevelsForTrigger($a_ref_id)
        {
                global $ilDB;
die("ilBasicSkill::getSkillLevelsForTrigger is deprecated.");
                $set = $ilDB->query($q = "SELECT id FROM skl_level".
                        " WHERE trigger_ref_id = ".$ilDB->quote($a_ref_id, "integer"));
 
                $skill_levels = array();
                while ($rec = $ilDB->fetchAssoc($set))
                {
                        $skill_levels[] = $rec["id"];
                }
 
                return $skill_levels;
 
        }
 
        //
        //
        // Certificate related methods
        //
        //
 
        function getTitleForCertificate()
        {
                return $this->getTitle();
        }
 
        function getLevelTitleForCertificate($a_level_id)
        {
die("ilBasicSkill::getLevelTitleForCertificate is deprecated.");
                return ilBasicSkill::lookupLevelTitle($a_level_id);
        }
 
        function getTriggerTitleForCertificate($a_level_id)
        {
die("ilBasicSkill::getTriggerTitleForCertificate is deprecated.");
                $tr = ilBasicSkill::lookupLevelTrigger($a_level_id);
                return ilObject::_lookupTitle($tr["obj_id"]);
        }
 
        function getShortTitleForCertificate()
        {
                return "Skill";
        }
 
        public static function _lookupCertificate($a_skill_id, $a_skill_level_id)
        {
                $certificatefile = CLIENT_WEB_DIR."/certificates/skill/".
                        ((int)$a_skill_id)."/".((int) $a_skill_level_id)."/certificate.xml";
                if (@file_exists($certificatefile))
                {
                        return true;
                }
                else
                {
                        return false;
                }
        }
 
        static public function getUsageInfo($a_cskill_ids, &$a_usages)
        {
                global $ilDB;
                
                include_once("./Services/Skill/classes/class.ilSkillUsage.php");
                ilSkillUsage::getUsageInfoGeneric($a_cskill_ids, $a_usages, ilSkillUsage::USER_ASSIGNED,
                                "skl_user_skill_level", "user_id");
        }
 
 
}
?>