class.ilPersonalSkill.php

Go to the documentation of this file.

<?php

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

class ilPersonalSkill implements ilSkillUsageInfo
{
    public static function getSelectedUserSkills($a_user_id)
    {
        global $DIC;

        $ilDB = $DIC->database();
        
        $stree = new ilSkillTree();

        $set = $ilDB->query(
            "SELECT * FROM skl_personal_skill " .
            " WHERE user_id = " . $ilDB->quote($a_user_id, "integer")
            );
        $pskills = array();
        while ($rec = $ilDB->fetchAssoc($set)) {
            if ($stree->isInTree($rec["skill_node_id"])) {
                $pskills[$rec["skill_node_id"]] = array("skill_node_id" => $rec["skill_node_id"],
                    "title" => ilSkillTreeNode::_lookupTitle($rec["skill_node_id"]));
            }
        }
        return $pskills;
    }
    
    public static function addPersonalSkill($a_user_id, $a_skill_node_id)
    {
        global $DIC;

        $ilDB = $DIC->database();
        
        $set = $ilDB->query(
            "SELECT * FROM skl_personal_skill " .
            " WHERE user_id = " . $ilDB->quote($a_user_id, "integer") .
            " AND skill_node_id = " . $ilDB->quote($a_skill_node_id, "integer")
            );
        if (!$ilDB->fetchAssoc($set)) {
            $ilDB->manipulate("INSERT INTO skl_personal_skill " .
                "(user_id, skill_node_id) VALUES (" .
                $ilDB->quote($a_user_id, "integer") . "," .
                $ilDB->quote($a_skill_node_id, "integer") .
                ")");
        }
    }
    
    public static function removeSkill($a_user_id, $a_skill_node_id)
    {
        global $DIC;

        $ilDB = $DIC->database();
        
        $ilDB->manipulate(
            "DELETE FROM skl_personal_skill WHERE " .
            " user_id = " . $ilDB->quote($a_user_id, "integer") .
            " AND skill_node_id = " . $ilDB->quote($a_skill_node_id, "integer")
            );
    }

    public static function removeSkills($a_user_id)
    {
        global $DIC;

        $ilDB = $DIC->database();

        $ilDB->manipulate(
            "DELETE FROM skl_personal_skill WHERE " .
            " user_id = " . $ilDB->quote($a_user_id, "integer")
            );
    }

    
    //
    // Assigned materials
    //
    
    public static function assignMaterial($a_user_id, $a_top_skill, $a_tref_id, $a_basic_skill, $a_level, $a_wsp_id)
    {
        global $DIC;

        $ilDB = $DIC->database();
        
        $set = $ilDB->query(
            "SELECT * FROM skl_assigned_material " .
            " WHERE user_id = " . $ilDB->quote($a_user_id, "integer") .
            " AND top_skill_id = " . $ilDB->quote($a_top_skill, "integer") .
            " AND tref_id = " . $ilDB->quote((int) $a_tref_id, "integer") .
            " AND skill_id = " . $ilDB->quote($a_basic_skill, "integer") .
            " AND level_id = " . $ilDB->quote($a_level, "integer") .
            " AND wsp_id = " . $ilDB->quote($a_wsp_id, "integer")
            );
        if (!$ilDB->fetchAssoc($set)) {
            $ilDB->manipulate("INSERT INTO skl_assigned_material " .
                "(user_id, top_skill_id, tref_id, skill_id, level_id, wsp_id) VALUES (" .
                $ilDB->quote($a_user_id, "integer") . "," .
                $ilDB->quote($a_top_skill, "integer") . "," .
                $ilDB->quote((int) $a_tref_id, "integer") . "," .
                $ilDB->quote($a_basic_skill, "integer") . "," .
                $ilDB->quote($a_level, "integer") . "," .
                $ilDB->quote($a_wsp_id, "integer") .
                ")");
        }
    }
    
    public static function getAssignedMaterial($a_user_id, $a_tref_id, $a_level)
    {
        global $DIC;

        $ilDB = $DIC->database();
        
        $set = $ilDB->query(
            "SELECT * FROM skl_assigned_material " .
            " WHERE level_id = " . $ilDB->quote($a_level, "integer") .
            " AND tref_id = " . $ilDB->quote((int) $a_tref_id, "integer") .
            " AND user_id = " . $ilDB->quote($a_user_id, "integer")
            );
        $mat = array();
        while ($rec = $ilDB->fetchAssoc($set)) {
            $mat[] = $rec;
        }
        return $mat;
    }
    
    public static function countAssignedMaterial($a_user_id, $a_tref_id, $a_level)
    {
        global $DIC;

        $ilDB = $DIC->database();
        
        $set = $ilDB->query(
            "SELECT count(*) as cnt FROM skl_assigned_material " .
            " WHERE level_id = " . $ilDB->quote($a_level, "integer") .
            " AND tref_id = " . $ilDB->quote((int) $a_tref_id, "integer") .
            " AND user_id = " . $ilDB->quote($a_user_id, "integer")
            );
        $rec = $ilDB->fetchAssoc($set);
        return $rec["cnt"];
    }
    
    public static function removeMaterial($a_user_id, $a_tref_id, $a_level_id, $a_wsp_id)
    {
        global $DIC;

        $ilDB = $DIC->database();
        
        $t = "DELETE FROM skl_assigned_material WHERE " .
            " user_id = " . $ilDB->quote($a_user_id, "integer") .
            " AND tref_id = " . $ilDB->quote((int) $a_tref_id, "integer") .
            " AND level_id = " . $ilDB->quote($a_level_id, "integer") .
            " AND wsp_id = " . $ilDB->quote($a_wsp_id, "integer");

        $ilDB->manipulate($t);
    }

    public static function removeMaterials($a_user_id)
    {
        global $DIC;

        $ilDB = $DIC->database();

        $t = "DELETE FROM skl_assigned_material WHERE " .
            " user_id = " . $ilDB->quote($a_user_id, "integer");
        $ilDB->manipulate($t);
    }

    //
    // Self evaluation
    //
    
    public static function saveSelfEvaluation($a_user_id, $a_top_skill, $a_tref_id, $a_basic_skill, $a_level)
    {
        if ($a_level > 0) {
            ilBasicSkill::writeUserSkillLevelStatus(
                $a_level,
                $a_user_id,
                0,
                $a_tref_id,
                ilBasicSkill::ACHIEVED,
                false,
                1
            );
        } else {
            ilBasicSkill::resetUserSkillLevelStatus($a_user_id, $a_basic_skill, $a_tref_id, 0, true);
        }
    }

    public static function getSelfEvaluation($a_user_id, $a_top_skill, $a_tref_id, $a_basic_skill)
    {
        $bs = new ilBasicSkill($a_basic_skill);
        return $bs->getLastLevelPerObject($a_tref_id, 0, $a_user_id, 1);
    }

    public static function getSelfEvaluationDate($a_user_id, $a_top_skill, $a_tref_id, $a_basic_skill)
    {
        $bs = new ilBasicSkill($a_basic_skill);
        return $bs->getLastUpdatePerObject($a_tref_id, 0, $a_user_id, 1);
    }

    public static function getUsageInfo($a_cskill_ids, &$a_usages)
    {
        global $DIC;

        $ilDB = $DIC->database();

        // material
        ilSkillUsage::getUsageInfoGeneric(
            $a_cskill_ids,
            $a_usages,
            ilSkillUsage::USER_MATERIAL,
            "skl_assigned_material",
            "user_id"
        );

        // self evaluations
        ilSkillUsage::getUsageInfoGeneric(
            $a_cskill_ids,
            $a_usages,
            ilSkillUsage::SELF_EVAL,
            "skl_self_eval_level",
            "user_id"
        );

        // users that use the skills as personal skills
        $pskill_ids = array();
        $tref_ids = array();
        foreach ($a_cskill_ids as $cs) {
            if ($cs["tref_id"] > 0) {
                if (ilSkillTemplateReference::_lookupTemplateId($cs["tref_id"]) == $cs["skill_id"]) {
                    $pskill_ids[$cs["tref_id"]] = $cs["tref_id"];
                    $tref_ids[(int) $cs["tref_id"]] = $cs["skill_id"];
                }
            } else {
                $pskill_ids[$cs["skill_id"]] = $cs["skill_id"];
            }
        }
        $set = $ilDB->query(
            "SELECT skill_node_id, user_id FROM skl_personal_skill " .
            " WHERE " . $ilDB->in("skill_node_id", $pskill_ids, false, "integer") .
            " GROUP BY skill_node_id, user_id"
            );
        while ($rec = $ilDB->fetchAssoc($set)) {
            if (isset($tref_ids[(int) $rec["skill_node_id"]])) {
                $a_usages[$tref_ids[$rec["skill_node_id"]] . ":" . $rec["skill_node_id"]][ilSkillUsage::PERSONAL_SKILL][] =
                    array("key" => $rec["user_id"]);
            } else {
                $a_usages[$rec["skill_node_id"] . ":0"][ilSkillUsage::PERSONAL_SKILL][] =
                    array("key" => $rec["user_id"]);
            }
        }
    }
}