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	removeSkills ($a_user_id)
	Remove personal skills of user. 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	removeMaterials ($a_user_id)
	Remove materials of user. 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 53 of file class.ilPersonalSkill.php.

References $DIC, and $ilDB.

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

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

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

References $DIC, and $ilDB.

Referenced by ilPersonalSkillsGUI\selectMaterial().

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

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

References $DIC, and $ilDB.

Referenced by ilPersonalSkillsGUI\getMaterials().

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

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

References $DIC, and $ilDB.

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

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

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 $DIC, $ilDB, and ilSkillTreeNode\_lookupTitle().

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

    {
        global $DIC;

        $ilDB = $DIC->database();
        
        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 278 of file class.ilPersonalSkill.php.

Referenced by ilSelfEvaluationSimpleTableGUI\__construct().

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

Referenced by 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 307 of file class.ilPersonalSkill.php.

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

    {
        global $DIC;

        $ilDB = $DIC->database();

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

References $DIC, $ilDB, and $t.

Referenced by ilPersonalSkillsGUI\removeMaterial().

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

Here is the caller graph for this function:

removeMaterials()

static ilPersonalSkill::removeMaterials (   $a_user_id )

static

Remove materials of user.

Parameters

int

$a_user_id

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

References $DIC, $ilDB, and $t.

Referenced by ilSkillObjDeletionHandler\processDeletion().

    {
        global $DIC;

        $ilDB = $DIC->database();

        $t = "DELETE FROM skl_assigned_material WHERE " .
            " user_id = " . $ilDB->quote($a_user_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 79 of file class.ilPersonalSkill.php.

References $DIC, and $ilDB.

Referenced by ilPersonalSkillsGUI\removeSkills().

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

Here is the caller graph for this function:

removeSkills()

static ilPersonalSkill::removeSkills (   $a_user_id )

static

Remove personal skills of user.

Parameters

int

$a_user_id

user id

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

References $DIC, and $ilDB.

Referenced by ilSkillObjDeletionHandler\processDeletion().

    {
        global $DIC;

        $ilDB = $DIC->database();

        $ilDB->manipulate(
            "DELETE FROM skl_personal_skill WHERE " .
            " user_id = " . $ilDB->quote($a_user_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 251 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);
        }
    }

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