Personal skill. More...

Inheritance diagram for ilPersonalSkill:

Collaboration diagram for ilPersonalSkill:

Static Public Member Functions
static	getSelectedUserSkills ($a_user_id)
	Get personal selected user skills. More...

static	addPersonalSkill ($a_user_id, $a_skill_node_id)
	Add personal skill. More...

static	removeSkill ($a_user_id, $a_skill_node_id)
	Remove personal skill. More...

static	assignMaterial ($a_user_id, $a_top_skill, $a_tref_id, $a_basic_skill, $a_level, $a_wsp_id)
	Assign material to skill level. More...

static	getAssignedMaterial ($a_user_id, $a_tref_id, $a_level)
	Get assigned material (for a skill level and user) More...

static	countAssignedMaterial ($a_user_id, $a_tref_id, $a_level)
	Get assigned material (for a skill level and user) More...

static	removeMaterial ($a_user_id, $a_tref_id, $a_level_id, $a_wsp_id)
	Remove material. More...

static	saveSelfEvaluation ($a_user_id, $a_top_skill, $a_tref_id, $a_basic_skill, $a_level)
	Save self evaluation. More...

static	getSelfEvaluation ($a_user_id, $a_top_skill, $a_tref_id, $a_basic_skill)
	Get self evaluation. More...

static	getSelfEvaluationDate ($a_user_id, $a_top_skill, $a_tref_id, $a_basic_skill)
	Get self evaluation. More...

static	getUsageInfo ($a_cskill_ids, &$a_usages)
	Get usage info. More...

Detailed Description

Personal skill.

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

Version: $Id$

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

Member Function Documentation

◆ addPersonalSkill()

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

static

Add personal skill.

Parameters

int	$a_user_id
int	$a_skill_node_id

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

References $ilDB.

Referenced by ilPersonalSkillsGUI\addSkill(), and ilObjPortfolioBase\clonePagesAndSettings().

         {
                 global $ilDB;
                 
                 $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").
                                 ")");
                 }
         }

Here is the caller graph for this function:

◆ assignMaterial()

static ilPersonalSkill::assignMaterial	(	$a_user_id,
		$a_top_skill,
		$a_tref_id,
		$a_basic_skill,
		$a_level,
		$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 102 of file class.ilPersonalSkill.php.

References $ilDB.

Referenced by ilPersonalSkillsGUI\selectMaterial().

         {
                 global $ilDB;
                 
                 $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").
                                 ")");
                 }
         }

Here is the caller graph for this function:

◆ countAssignedMaterial()

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

static

Get assigned material (for a skill level and user)

Parameters

int	$a_user_id	user id
int	$a_tref_id	template reference id
int	$a_level	level id

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

References $ilDB.

Referenced by ilPersonalSkillsGUI\renderMaterialsRow().

         {
                 global $ilDB;
                 
                 $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"];
         }

Here is the caller graph for this function:

◆ getAssignedMaterial()

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

static

Get assigned material (for a skill level and user)

Parameters

int	$a_user_id	user id
int	$a_tref_id	template reference id
int	$a_level	level id

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

References $ilDB, and array.

Referenced by ilCOPageHTMLExport\collectPageElements(), ilSkillAssignMaterialsTableGUI\fillRow(), and ilPersonalSkillsGUI\renderMaterialsRow().

         {
                 global $ilDB;
                 
                 $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;
         }

Here is the caller graph for this function:

◆ getSelectedUserSkills()

static ilPersonalSkill::getSelectedUserSkills ( $a_user_id )

static

Get personal selected user skills.

Parameters

int $a_user_id user id

Returns: array

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

References $ilDB, ilSkillTreeNode\_lookupTitle(), and array.

Referenced by ilPersonalSkillTableGUI\__construct(), ilObjPortfolioBase\clonePagesAndSettings(), ilObjPortfolioGUI\initCreatePortfolioFromTemplateForm(), ilPCSkillsGUI\initForm(), and ilPersonalSkillsGUI\listSkills().

         {
                 global $ilDB;
                 
                 include_once "Services/Skill/classes/class.ilSkillTreeNode.php";
                 
                 include_once("./Services/Skill/classes/class.ilSkillTree.php");
                 $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;
         }

Here is the call graph for this function:

Here is the caller graph for this function:

◆ getSelfEvaluation()

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

static

Get self evaluation.

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 level id

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

Referenced by ilSelfEvaluationSimpleTableGUI\__construct(), and ilPersonalSkillsGUI\renderSelfEvaluationRow().

         {
                 include_once("./Services/Skill/classes/class.ilBasicSkill.php");
                 $bs = new ilBasicSkill($a_basic_skill);
                 return $bs->getLastLevelPerObject($a_tref_id, 0, $a_user_id, 1);
         }

Here is the caller graph for this function:

◆ getSelfEvaluationDate()

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

static

Get self evaluation.

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 level id

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

Referenced by ilPersonalSkillsGUI\renderSelfEvaluationRow(), and ilPersonalSkillsGUI\renderSkillHTML().

         {
                 include_once("./Services/Skill/classes/class.ilBasicSkill.php");
                 $bs = new ilBasicSkill($a_basic_skill);
                 return $bs->getLastUpdatePerObject($a_tref_id, 0, $a_user_id, 1);
         }

Here is the caller graph for this function:

◆ getUsageInfo()

static ilPersonalSkill::getUsageInfo	(		$a_cskill_ids,
		&	$a_usages
	)

static

Get usage info.

Parameters

array	$a_cskill_ids	skill ids
array	$a_usages	usages array

Implements ilSkillUsageInfo.

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

References $ilDB, ilSkillTemplateReference\_lookupTemplateId(), array, ilSkillUsage\getUsageInfoGeneric(), ilSkillUsage\PERSONAL_SKILL, ilSkillUsage\SELF_EVAL, and ilSkillUsage\USER_MATERIAL.

         {
                 global $ilDB;
 
                 // material
                 include_once("./Services/Skill/classes/class.ilSkillUsage.php");
                 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)
                         {
                                 include_once("./Services/Skill/classes/class.ilSkillTemplateReference.php");
                                 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"]);
                         }
                 }
         }

Here is the call graph for this function:

◆ removeMaterial()

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

static

Remove material.

Parameters

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

References $ilDB, and $t.

Referenced by ilPersonalSkillsGUI\removeMaterial().

         {
                 global $ilDB;
                 
                 $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);
         }

Here is the caller graph for this function:

◆ removeSkill()

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

static

Remove personal skill.

Parameters

int	$a_user_id	user id
int	$a_skill_node_id	the "selectable" top skill

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

References $ilDB.

Referenced by ilPersonalSkillsGUI\removeSkills().

         {
                 global $ilDB;
                 
                 $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")
                         );
                 
         }

Here is the caller graph for this function:

◆ saveSelfEvaluation()

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

static

Save self evaluation.

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 204 of file class.ilPersonalSkill.php.

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

Referenced by ilPersonalSkillsGUI\saveSelfEvaluation().

         {
                 include_once("./Services/Skill/classes/class.ilBasicSkill.php");
                 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);
                 }
 
         }