class.ilSkillProfile.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 ilSkillProfile implements ilSkillUsageInfo
{
        protected $id;
        protected $title;
        protected $description;
        protected $skill_level = array();
        
        function __construct($a_id = 0)
        {
                if ($a_id > 0)
                {
                        $this->setId($a_id);
                        $this->read();
                }
        }
        
        function setId($a_val)
        {
                $this->id = $a_val;
        }
        
        function getId()
        {
                return $this->id;
        }
        
        function setTitle($a_val)
        {
                $this->title = $a_val;
        }
        
        function getTitle()
        {
                return $this->title;
        }
        
        function setDescription($a_val)
        {
                $this->description = $a_val;
        }
        
        function getDescription()
        {
                return $this->description;
        }
        
        function addSkillLevel($a_base_skill_id, $a_tref_id, $a_level_id)
        {
//echo "-".$a_base_skill_id."-";
                $this->skill_level[] = array(
                        "base_skill_id" => $a_base_skill_id,
                        "tref_id" => $a_tref_id,
                        "level_id" => $a_level_id
                        );
        }
        
        function removeSkillLevel($a_base_skill_id, $a_tref_id, $a_level_id)
        {
                foreach ($this->skill_level as $k => $sl)
                {
                        if ((int) $sl["base_skill_id"] == (int) $a_base_skill_id &&
                                (int) $sl["tref_id"] == (int) $a_tref_id &&
                                (int) $sl["level_id"] == (int) $a_level_id)
                        {
                                unset($this->skill_level[$k]);
                        }
                }
        }
 
        function getSkillLevels()
        {
                return $this->skill_level;
        }
        
        function read()
        {
                global $ilDB;
                
                $set = $ilDB->query("SELECT * FROM skl_profile ".
                        " WHERE id = ".$ilDB->quote($this->getId(), "integer")
                        );
                $rec  = $ilDB->fetchAssoc($set);
                $this->setTitle($rec["title"]);
                $this->setDescription($rec["description"]);
                
                $set = $ilDB->query("SELECT * FROM skl_profile_level ".
                        " WHERE profile_id = ".$ilDB->quote($this->getId(), "integer")
                        );
                while ($rec = $ilDB->fetchAssoc($set))
                {
                        $this->addSkillLevel((int) $rec["base_skill_id"], (int) $rec["tref_id"],
                                (int) $rec["level_id"]);
                }
        }
        
        function create()
        {
                global $ilDB;
                
                // profile
                $this->setId($ilDB->nextId("skl_profile"));
                $ilDB->manipulate("INSERT INTO skl_profile ".
                        "(id, title, description) VALUES (".
                        $ilDB->quote($this->getId(), "integer").",".
                        $ilDB->quote($this->getTitle(), "text").",".
                        $ilDB->quote($this->getDescription(), "text").
                        ")");
                
                // profile levels
                foreach ($this->skill_level as $level)
                {
                        $ilDB->replace("skl_profile_level", 
                                array("profile_id" => array("integer", $this->getId()),
                                        "tref_id" => array("integer", (int) $level["tref_id"]),
                                        "base_skill_id" => array("integer", (int) $level["base_skill_id"])
                                        ),
                                array("level_id" => array("integer", (int) $level["level_id"]))
                                );
                }
        }
        
        function update()
        {
                global $ilDB;
                
                // profile
                $ilDB->manipulate("UPDATE skl_profile SET ".
                        " title = ".$ilDB->quote($this->getTitle(), "text").",".
                        " description = ".$ilDB->quote($this->getDescription(), "text").
                        " WHERE id = ".$ilDB->quote($this->getId(), "integer")
                        );
                
                // profile levels
                $ilDB->manipulate("DELETE FROM skl_profile_level WHERE ".
                        " profile_id = ".$ilDB->quote($this->getId(), "integer")
                        );
                foreach ($this->skill_level as $level)
                {
                        $ilDB->replace("skl_profile_level", 
                                array("profile_id" => array("integer", $this->getId()),
                                        "tref_id" => array("integer", (int) $level["tref_id"]),
                                        "base_skill_id" => array("integer", (int) $level["base_skill_id"])
                                        ),
                                array("level_id" => array("integer", (int) $level["level_id"]))
                                );
                        
                        /*$ilDB->manipulate("INSERT INTO skl_profile_level ".
                                "(profile_id, base_skill_id, tref_id, level_id) VALUES (".
                                $ilDB->quote($this->getId(), "integer").",".
                                $ilDB->quote((int) $level["base_skill_id"], "integer").",".
                                $ilDB->quote((int) $level["tref_id"], "integer").",".
                                $ilDB->quote((int) $level["level_id"], "integer").
                                ")");*/
                }
        }
        
        function delete()
        {
                global $ilDB;
                
                // profile levels
                $ilDB->manipulate("DELETE FROM skl_profile_level WHERE ".
                        " profile_id = ".$ilDB->quote($this->getId(), "integer")
                        );
                
                // profile
                $ilDB->manipulate("DELETE FROM skl_profile WHERE ".
                        " id = ".$ilDB->quote($this->getId(), "integer")
                        );
                
        }
        
        static function getProfiles()
        {
                global $ilDB;
                
                $set = $ilDB->query("SELECT * FROM skl_profile ".
                        " ORDER BY title "
                        );
                $profiles = array();
                while ($rec = $ilDB->fetchAssoc($set))
                {
                        $profiles[$rec["id"]] = $rec;
                }
                
                return $profiles;
        }
        
        static protected function lookup($a_id, $a_field)
        {
                global $ilDB;
                
                $set = $ilDB->query("SELECT ".$a_field." FROM skl_profile ".
                        " WHERE id = ".$ilDB->quote($a_id, "integer")
                        );
                $rec  = $ilDB->fetchAssoc($set);
                return $rec[$a_field];
        }
        
        static function lookupTitle($a_id)
        {
                return self::lookup($a_id, "title");
        }
        
        
        function getAssignedUsers()
        {
                global $ilDB;
                
                $set = $ilDB->query("SELECT * FROM skl_profile_user ".
                        " WHERE profile_id = ".$ilDB->quote($this->getId(), "integer")
                        );
                $users = array();
                while ($rec = $ilDB->fetchAssoc($set))
                {
                        $name = ilObjUser::_lookupName($rec["user_id"]);
                        $users[$rec["user_id"]] = array(
                                "lastname" => $name["lastname"],
                                "firstname" => $name["firstname"],
                                "login" => $name["login"],
                                "id" => $name["user_id"]
                                );
                }
                return $users;
        }
        
        function addUserToProfile($a_user_id)
        {
                global $ilDB;
                
                $ilDB->replace("skl_profile_user", 
                        array("profile_id" => array("integer", $this->getId()),
                                "user_id" => array("integer", (int) $a_user_id),
                                ),
                        array()
                        );
        }
        
        function removeUserFromProfile($a_user_id)
        {
                global $ilDB;
                
                $ilDB->manipulate("DELETE FROM skl_profile_user WHERE ".
                        " profile_id = ".$ilDB->quote($this->getId(), "integer").
                        " AND user_id = ".$ilDB->quote($a_user_id, "integer")
                        );
        }
        
        static function getProfilesOfUser($a_user_id)
        {
                global $ilDB;
                
                $profiles = array();
                $set = $ilDB->query("SELECT p.id, p.title FROM skl_profile_user u JOIN skl_profile p ".
                        " ON (u.profile_id = p.id) ".
                        " WHERE user_id = ".$ilDB->quote($a_user_id, "integer").
                        " ORDER BY p.title ASC"
                        );
                while ($rec  = $ilDB->fetchAssoc($set))
                {
                        $profiles[] = $rec;
                }
                return $profiles;
        }
 
        static function countUsers($a_profile_id)
        {
                global $ilDB;
                
                $set = $ilDB->query("SELECT count(*) ucnt FROM skl_profile_user ".
                        " WHERE profile_id = ".$ilDB->quote($a_profile_id, "integer")
                        );
                $rec = $ilDB->fetchAssoc($set);
                return (int) $rec["ucnt"];
        }
        
        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::PROFILE,
                                "skl_profile_level", "profile_id", "base_skill_id");
        }
 
 
}
 
?>