ilPersonalSkill Class Reference

This file is part of ILIAS, a powerful learning management system published by ILIAS open source e-Learning e.V. More...

Inheritance diagram for ilPersonalSkill:

Collaboration diagram for ilPersonalSkill:

Static Public Member Functions
static	getSelectedUserSkills (int $a_user_id)
static	addPersonalSkill (int $a_user_id, int $a_skill_node_id)
static	removeSkill (int $a_user_id, int $a_skill_node_id)
static	removeSkills (int $a_user_id)
static	assignMaterial (int $a_user_id, int $a_top_skill, int $a_tref_id, int $a_basic_skill, int $a_level, int $a_wsp_id)
	Assign material to skill level. More...
static	getAssignedMaterial (int $a_user_id, int $a_tref_id, int $a_level)
	Get assigned material (for a skill level and user) More...
static	countAssignedMaterial (int $a_user_id, int $a_tref_id, int $a_level)
	Count assigned material (for a skill level and user) More...
static	removeMaterial (int $a_user_id, int $a_tref_id, int $a_level_id, int $a_wsp_id)
static	removeMaterials (int $a_user_id)
static	saveSelfEvaluation (int $a_user_id, int $a_top_skill, int $a_tref_id, int $a_basic_skill, int $a_level)
static	getSelfEvaluation (int $a_user_id, int $a_top_skill, int $a_tref_id, int $a_basic_skill)
static	getSelfEvaluationDate (int $a_user_id, int $a_top_skill, int $a_tref_id, int $a_basic_skill)
static	getUsageInfo (array $a_cskill_ids)
static	getUsageInfo (array $a_cskill_ids)
	Get title of an assigned item. More...

Detailed Description

This file is part of ILIAS, a powerful learning management system published by ILIAS open source e-Learning e.V.

ILIAS is licensed with the GPL-3.0, see https://www.gnu.org/licenses/gpl-3.0.en.html You should have received a copy of said license along with the source code, too.

If this is not the case or you just want to try ILIAS, you'll find us at: https://www.ilias.de https://github.com/ILIAS-eLearning Personal skill

Author

Alex Killing alex..nosp@m.kill.nosp@m.ing@g.nosp@m.mx.d.nosp@m.e

Definition at line 25 of file class.ilPersonalSkill.php.

Member Function Documentation

addPersonalSkill()

static ilPersonalSkill::addPersonalSkill ( int  $a_user_id, int  $a_skill_node_id  )

static

Definition at line 54 of file class.ilPersonalSkill.php.

                                                                                 : void
    {
        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") .
                ")");
        }
    }

References $DIC, and $ilDB.

Referenced by ilPersonalSkillsGUI\addSkill(), ilSkillAppEventListener\handleEvent(), ilTestSkillEvaluation\handleSkillTriggering(), ilContainerMemberSkills\publish(), ilSurveySkill\writeAndAddAppraiseeSkills(), ilSurveySkill\writeAndAddIndFeedbackSkills(), and ilSurveySkill\writeAndAddSelfEvalSkills().

Here is the caller graph for this function:

assignMaterial()

static ilPersonalSkill::assignMaterial ( int  $a_user_id, int  $a_top_skill, int  $a_tref_id, int  $a_basic_skill, int  $a_level, int  $a_wsp_id  )

static

Assign material to skill level.

Parameters

int	$a_user_id	user id
int	$a_top_skill	the "selectable" top skill
int	$a_tref_id	template reference id
int	$a_basic_skill	the basic skill the level belongs to
int	$a_level	level id
int	$a_wsp_id	workspace object

Definition at line 114 of file class.ilPersonalSkill.php.

     : void {
        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($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($a_tref_id, "integer") . "," .
                $ilDB->quote($a_basic_skill, "integer") . "," .
                $ilDB->quote($a_level, "integer") . "," .
                $ilDB->quote($a_wsp_id, "integer") .
                ")");
        }
    }

References $ilDB.

Referenced by ilPersonalSkillsGUI\selectMaterial().

Here is the caller graph for this function:

countAssignedMaterial()

static ilPersonalSkill::countAssignedMaterial ( int  $a_user_id, int  $a_tref_id, int  $a_level  )

static

Count assigned material (for a skill level and user)

Definition at line 180 of file class.ilPersonalSkill.php.

                                                                                              : int
    {
        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($a_tref_id, "integer") .
            " AND user_id = " . $ilDB->quote($a_user_id, "integer")
        );
        $rec = $ilDB->fetchAssoc($set);
        return (int) $rec["cnt"];
    }

References $DIC, and $ilDB.

Referenced by ilPersonalSkillsGUI\getMaterials().

Here is the caller graph for this function:

getAssignedMaterial()

static ilPersonalSkill::getAssignedMaterial ( int  $a_user_id, int  $a_tref_id, int  $a_level  )

static

Get assigned material (for a skill level and user)

Returns

array{user_id: int, top_skill_id: int, skill_id: int, level_id: int, wsp_id: int, tref_id: int}[]

Definition at line 152 of file class.ilPersonalSkill.php.

                                                                                            : array
    {
        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($a_tref_id, "integer") .
            " AND user_id = " . $ilDB->quote($a_user_id, "integer")
        );
        $mat = [];
        while ($rec = $ilDB->fetchAssoc($set)) {
            $rec['user_id'] = (int) $rec['user_id'];
            $rec['top_skill_id'] = (int) $rec['top_skill_id'];
            $rec['skill_id'] = (int) $rec['skill_id'];
            $rec['level_id'] = (int) $rec['level_id'];
            $rec['wsp_id'] = (int) $rec['wsp_id'];
            $rec['tref_id'] = (int) $rec['tref_id'];
            $mat[] = $rec;
        }
        return $mat;
    }

References $DIC, $ilDB, and ILIAS\Repository\int().

Referenced by ilSkillAssignMaterialsTableGUI\fillRow(), and ilPersonalSkillsGUI\getMaterials().

Here is the call graph for this function:

Here is the caller graph for this function:

getSelectedUserSkills()

static ilPersonalSkill::getSelectedUserSkills ( int  $a_user_id )

static

Returns

array<int, array{skill_node_id: int, title: string}>

Definition at line 30 of file class.ilPersonalSkill.php.

                                                                : array
    {
        global $DIC;
 
        $ilDB = $DIC->database();
 
        $repo = $DIC->skills()->internal()->repo()->getTreeRepo();
 
        $set = $ilDB->query(
            "SELECT * FROM skl_personal_skill " .
            " WHERE user_id = " . $ilDB->quote($a_user_id, "integer")
        );
        $pskills = [];
        while ($rec = $ilDB->fetchAssoc($set)) {
            if ($repo->isInAnyTree($rec["skill_node_id"])) {
                $pskills[(int) $rec["skill_node_id"]] = array(
                    "skill_node_id" => (int) $rec["skill_node_id"],
                    "title" => ilSkillTreeNode::_lookupTitle($rec["skill_node_id"])
                );
            }
        }
        return $pskills;
    }

References $DIC, $ilDB, ilSkillTreeNode\_lookupTitle(), and ILIAS\Repository\int().

Referenced by ilPersonalSkillTableGUI\__construct(), ilObjPortfolioGUI\createPortfolioFromAssignment(), ilPersonalSkillsGUI\listSkills(), and ilMStShowUserCompetencesGUI\showSkills().

Here is the call graph for this function:

Here is the caller graph for this function:

getSelfEvaluation()

static ilPersonalSkill::getSelfEvaluation ( int  $a_user_id, int  $a_top_skill, int  $a_tref_id, int  $a_basic_skill  )

static

Parameters

int	$a_user_id	user id
int	$a_top_skill	the "selectable" top skill
int	$a_tref_id	template reference id
int	$a_basic_skill	the basic skill the level belongs to

Returns

int|null level id

Definition at line 262 of file class.ilPersonalSkill.php.

     : ?int {
        $bs = new ilBasicSkill($a_basic_skill);
        return $bs->getLastLevelPerObject($a_tref_id, 0, $a_user_id, 1);
    }

Referenced by ilSelfEvaluationSimpleTableGUI\__construct().

Here is the caller graph for this function:

getSelfEvaluationDate()

static ilPersonalSkill::getSelfEvaluationDate ( int  $a_user_id, int  $a_top_skill, int  $a_tref_id, int  $a_basic_skill  )

static

Parameters

int	$a_user_id	user id
int	$a_top_skill	the "selectable" top skill
int	$a_tref_id	template reference id
int	$a_basic_skill	the basic skill the level belongs to

Returns

string|null status date

Definition at line 279 of file class.ilPersonalSkill.php.

     : ?string {
        $bs = new ilBasicSkill($a_basic_skill);
        return $bs->getLastUpdatePerObject($a_tref_id, 0, $a_user_id, 1);
    }

getUsageInfo()

static ilPersonalSkill::getUsageInfo ( array  $a_cskill_ids )

static

Parameters

array{skill_id

int, tref_id: int}[] $a_cskill_ids

Returns

array<string, array<string, array{key: string}[]>>

Implements ilSkillUsageInfo.

Definition at line 294 of file class.ilPersonalSkill.php.

                                                            : array
    {
        global $DIC;
 
        $ilDB = $DIC->database();
 
        // material
        $a_usages = ilSkillUsage::getUsageInfoGeneric(
            $a_cskill_ids,
            ilSkillUsage::USER_MATERIAL,
            "skl_assigned_material",
            "user_id"
        );
 
        // users that use the skills as personal skills
        $pskill_ids = [];
        $tref_ids = [];
        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"]);
            }
        }
 
        return $a_usages;
    }

References $DIC, $ilDB, ilSkillTemplateReference\_lookupTemplateId(), ilSkillUsage\getUsageInfoGeneric(), ILIAS\Repository\int(), ilSkillUsage\PERSONAL_SKILL, and ilSkillUsage\USER_MATERIAL.

Here is the call graph for this function:

removeMaterial()

static ilPersonalSkill::removeMaterial ( int  $a_user_id, int  $a_tref_id, int  $a_level_id, int  $a_wsp_id  )

static

Definition at line 196 of file class.ilPersonalSkill.php.

                                                                                                         : void
    {
        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($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);
    }

References $DIC, and $ilDB.

Referenced by ilPersonalSkillsGUI\removeMaterial().

Here is the caller graph for this function:

removeMaterials()

static ilPersonalSkill::removeMaterials ( int  $a_user_id )

static

Definition at line 211 of file class.ilPersonalSkill.php.

                                                          : void
    {
        global $DIC;
 
        $ilDB = $DIC->database();
 
        $t = "DELETE FROM skl_assigned_material WHERE " .
            " user_id = " . $ilDB->quote($a_user_id, "integer");
        $ilDB->manipulate($t);
    }

References $DIC, and $ilDB.

Referenced by ilSkillObjDeletionHandler\processDeletion().

Here is the caller graph for this function:

removeSkill()

static ilPersonalSkill::removeSkill ( int  $a_user_id, int  $a_skill_node_id  )

static

Definition at line 74 of file class.ilPersonalSkill.php.

                                                                            : void
    {
        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")
        );
    }

References $DIC, and $ilDB.

Referenced by ilPersonalSkillsGUI\removeSkills().

Here is the caller graph for this function:

removeSkills()

static ilPersonalSkill::removeSkills ( int  $a_user_id )

static

Definition at line 87 of file class.ilPersonalSkill.php.

                                                       : void
    {
        global $DIC;
 
        $ilDB = $DIC->database();
 
        $ilDB->manipulate(
            "DELETE FROM skl_personal_skill WHERE " .
            " user_id = " . $ilDB->quote($a_user_id, "integer")
        );
    }

References $DIC, and $ilDB.

Referenced by ilSkillObjDeletionHandler\processDeletion().

Here is the caller graph for this function:

saveSelfEvaluation()

static ilPersonalSkill::saveSelfEvaluation ( int  $a_user_id, int  $a_top_skill, int  $a_tref_id, int  $a_basic_skill, int  $a_level  )

static

Parameters

int	$a_user_id	user id
int	$a_top_skill	the "selectable" top skill
int	$a_tref_id	template reference id
int	$a_basic_skill	the basic skill the level belongs to
int	$a_level	level id

Definition at line 233 of file class.ilPersonalSkill.php.

     : void {
        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);
        }
    }

References ilBasicSkill\ACHIEVED, and ilBasicSkill\writeUserSkillLevelStatus().

Referenced by ilPersonalSkillsGUI\saveSelfEvaluation().

Here is the call graph for this function:

Here is the caller graph for this function:

---

The documentation for this class was generated from the following file:

• Services/Skill/Personal/class.ilPersonalSkill.php