ilPersonalSkill Class Reference

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...
static	getUsageInfo ($a_cskill_ids, &$a_usages)
	Get title of an assigned item. 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.

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

References $ilDB.

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

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.

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

References $ilDB.

Referenced by ilPersonalSkillsGUI\selectMaterial().

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.

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

References $ilDB.

Referenced by ilPersonalSkillsGUI\renderMaterialsRow().

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.

        {
                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;
        }

References $ilDB.

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

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.

        {
                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;
        }

References $ilDB, and ilSkillTreeNode\_lookupTitle().

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

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.

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

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

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.

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

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

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.

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

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

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

return

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

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

References $ilDB, and $t.

Referenced by ilPersonalSkillsGUI\removeMaterial().

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.

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

References $ilDB.

Referenced by ilPersonalSkillsGUI\removeSkills().

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.

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

References ilBasicSkill\ACHIEVED, ilBasicSkill\resetUserSkillLevelStatus(), 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/classes/class.ilPersonalSkill.php