Basic Skill. More...

Inheritance diagram for ilBasicSkill:

Collaboration diagram for ilBasicSkill:

Public Member Functions
	__construct ($a_id=0)
	Constructor @access public. More...

	read ()
	Read data from database. More...

	create ()
	Create skill. More...

	delete ()
	Delete skill. More...

	copy ()
	Copy basic skill. More...

	addLevel ($a_title, $a_description, $a_import_id="")
	Add new level. More...

	getMaxLevelNr ()
	Get maximum level nr. More...

	getLevelData ($a_id=0)
	Get level data. More...

	updateLevelOrder ($order)
	Update level order. More...

	deleteLevel ($a_id)
	Delete level. More...

	fixLevelNumbering ()
	Fix level numbering. More...

	getSkillForLevelId ($a_level_id)
	Get skill for level id. More...

	getMaxLevelPerType ($a_tref_id, $a_type, $a_user_id=0, $a_self_eval=0)
	Get max levels per type. More...

	getAllLevelEntriesOfUser ($a_tref_id, $a_user_id=0, $a_self_eval=0)
	Get all level entries. More...

	getAllHistoricLevelEntriesOfUser ($a_tref_id, $a_user_id=0, $a_eval_by=0)
	Get all historic level entries. More...

	getMaxLevelPerObject ($a_tref_id, $a_object_id, $a_user_id=0, $a_self_eval=0)
	Get max levels per object. More...

	getMaxLevel ($a_tref_id, $a_user_id=0, $a_self_eval=0)
	Get max levels per object. More...

	getLastLevelPerObject ($a_tref_id, $a_object_id, $a_user_id=0, $a_self_eval=0)
	Get last level set per object. More...

	getLastUpdatePerObject ($a_tref_id, $a_object_id, $a_user_id=0, $a_self_eval=0)
	Get last update per object. More...

	getTitleForCertificate ()
	Get title for certificate. More...

	getShortTitleForCertificate ()
	Get short title for certificate. More...

Public Member Functions inherited from ilSkillTreeNode
	__construct ($a_id=0)

	setTitle ($a_title)
	Set title. More...

	getTitle ()
	Get title. More...

	setType ($a_type)
	Set type. More...

	getType ()
	Get type. More...

	setId ($a_id)
	Set Node ID. More...

	getId ()
	Get Node ID. More...

	setSelfEvaluation ($a_val)
	Set self evaluation. More...

	getSelfEvaluation ()
	Get self evaluation. More...

	setOrderNr ($a_val)
	Set order nr. More...

	getOrderNr ()
	Get order nr. More...

	setImportId ($a_val)
	Set import id. More...

	getImportId ()
	Get import id. More...

	getCreationDate ()
	Get creation date. More...

	read ()
	Read Data of Node. More...

	setDataRecord ($a_record)
	this method should only be called by class ilSCORM2004NodeFactory More...

	setStatus ($a_val)
	Set status. More...

	getStatus ()
	Get status. More...

	create ()
	Create Node. More...

	update ()
	Update Node. More...

	delete ()
	Delete Node. More...

Static Public Member Functions
static	lookupLevelTitle ($a_id)
	Lookup level title. More...

static	lookupLevelDescription ($a_id)
	Lookup level description. More...

static	lookupLevelSkillId ($a_id)
	Lookup level skill id. More...

static	writeLevelTitle ($a_id, $a_title)
	Write level title. More...

static	writeLevelDescription ($a_id, $a_description)
	Write level description. More...

static	resetUserSkillLevelStatus ($a_user_id, $a_skill_id, $a_tref_id=0, $a_trigger_ref_id=0, $a_self_eval=false)
	Reset skill level status. More...

static	getNewAchievementsPerUser ($a_timestamp, $a_timestamp_to=null, $a_user_id=0, $a_self_eval=0)
	Get new achievements. More...

static	writeUserSkillLevelStatus ( $a_level_id, $a_user_id, $a_trigger_ref_id, $a_tref_id=0, $a_status=ilBasicSkill::ACHIEVED, $a_force=false, $a_self_eval=false, $a_unique_identifier="")
	Write skill level status. More...

static	removeAllUserSkillLevelStatusOfObject ($a_user_id, $a_trigger_obj_id, $a_self_eval=false, $a_unique_identifier="")
	Remove a user skill completely. More...

static	removeAllUserData ($a_user_id)
	Remove all data of a user. More...

static	hasSelfEvaluated ($a_user_id, $a_skill_id, $a_tref_id)
	Has use self evaluated a skill? More...

static	_lookupCertificate ($a_skill_id, $a_skill_level_id)
	Checks whether a skill level has a certificate or not. More...

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

static	getCommonSkillIdForImportId ($a_source_inst_id, $a_skill_import_id, $a_tref_import_id=0)
	Get common skill ids for import IDs (newest first) More...

static	getLevelIdForImportId ($a_source_inst_id, $a_level_import_id)
	Get level ids for import IDs (newest first) More...

static	getLevelIdForImportIdMatchSkill ($a_source_inst_id, $a_level_import_id, $a_skill_import_id, $a_tref_import_id=0)
	Get level ids for import Ids matching common skills. More...

Static Public Member Functions inherited from ilSkillTreeNode
static	getAllStatus ()
	Get all status. More...

static	getStatusInfo ($a_status)
	Get status info. More...

static	_lookupTitle ($a_obj_id, $a_tref_id=0)
	Lookup Title. More...

static	_lookupSelfEvaluation ($a_obj_id)
	Lookup self evaluation. More...

static	_lookupStatus ($a_obj_id)
	Lookup Status. More...

static	_lookupType ($a_obj_id)
	Lookup Type. More...

static	_writeTitle ($a_obj_id, $a_title)
	Write Title. More...

static	_writeOrderNr ($a_obj_id, $a_nr)
	Write Order Nr. More...

static	putInTree ($a_obj, $a_parent_id="", $a_target_node_id="")
	Put this object into the skill tree. More...

static	getTree ($a_slm_obj_id)
	Get scorm module editing tree. More...

static	uniqueTypesCheck ($a_items)
	Check for unique types. More...

static	clipboardCut ($a_tree_id, $a_ids)
	Cut and copy a set of skills/skill categories into the clipboard. More...

static	clipboardCopy ($a_tree_id, $a_ids)
	Copy a set of skills/skill categories into the clipboard. More...

static	insertItemsFromClip ($a_type, $a_obj_id)
	Insert basic skills from clipboard. More...

static	clearClipboard ()
	Remove all skill items from clipboard. More...

static	pasteTree ( $a_item_id, $a_parent_id, $a_target, $a_insert_time, &$a_copied_nodes, $a_as_copy=false, $a_add_suffix=false)
	Paste item (tree) from clipboard to skill tree. More...

static	isInTree ($a_id)
	Is id in tree? More...

static	getAllSelfEvaluationNodes ()
	Get all self evaluation nodes. More...

static	getTopTemplates ()
	Get top skill templates and template categories. More...

static	getSelectableSkills ()
	Get selectable skills. More...

static	saveChildsOrder ($a_par_id, $a_childs_order, $a_templates=false)
	Save childs order. More...

static	getIconPath ($a_obj_id, $a_type, $a_size="", $a_status=0)
	Get icon path. More...

static	findSkills ($a_term)
	Find skills. More...

static	getAllCSkillIdsForNodeIds (array $a_node_ids)
	Get all possible common skill IDs for node IDs. More...

static	getUsageInfo ($a_cskill_ids, &$a_usages)
	Get title of an assigned item. More...

Data Fields
const	ACHIEVED = 1

const	NOT_ACHIEVED = 0

const	EVAL_BY_OTHERS_ = 0

const	EVAL_BY_SELF = 1

const	EVAL_BY_ALL = 2

	$id

Data Fields inherited from ilSkillTreeNode
const	STATUS_PUBLISH = 0

const	STATUS_DRAFT = 1

const	STATUS_OUTDATED = 2

	$type

	$id

	$title

Static Protected Member Functions
static	lookupLevelProperty ($a_id, $a_prop)
	Lookup level property. More...

static	writeLevelProperty ($a_id, $a_prop, $a_value, $a_type)
	Write level property. More...

static	hasRecentSelfEvaluation ($a_user_id, $a_skill_id, $a_tref_id=0, $a_trigger_ref_id=0)
	Has recent self evaluation. More...

Static Protected Member Functions inherited from ilSkillTreeNode
static	_lookup ($a_obj_id, $a_field)
	Lookup Title. More...

Protected Attributes
	$db

	$user

Protected Attributes inherited from ilSkillTreeNode
	$db

Additional Inherited Members
Protected Member Functions inherited from ilSkillTreeNode
	setCreationDate ($a_val)
	Set creation date. More...

Detailed Description

Basic Skill.

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

Version: $Id$

Definition at line 16 of file class.ilBasicSkill.php.

Constructor & Destructor Documentation

◆ __construct()

ilBasicSkill::__construct ( $a_id = 0 )

Constructor @access public.

Reimplemented from ilSkillTreeNode.

Reimplemented in ilBasicSkillTemplate.

Definition at line 41 of file class.ilBasicSkill.php.

    {
        global $DIC;
 
        $this->db = $DIC->database();
        $this->user = $DIC->user();
        parent::__construct($a_id);
        $this->setType("skll");
    }

References $DIC, ilSkillTreeNode\setType(), and user().

Here is the call graph for this function:

Member Function Documentation

◆ _lookupCertificate()

static ilBasicSkill::_lookupCertificate	(	$a_skill_id,
		$a_skill_level_id
	)

static

Checks whether a skill level has a certificate or not.

Parameters

int	skill id
int	skill level id

Returns: true/false

Definition at line 1016 of file class.ilBasicSkill.php.

    {
        $certificatefile = CLIENT_WEB_DIR . "/certificates/skill/" .
            ((int) $a_skill_id) . "/" . ((int) $a_skill_level_id) . "/certificate.xml";
        if (@file_exists($certificatefile)) {
            return true;
        } else {
            return false;
        }
    }

◆ addLevel()

ilBasicSkill::addLevel	(	$a_title,
		$a_description,
		$a_import_id = `""`
	)

Add new level.

Parameters

string	title
string	description

Definition at line 123 of file class.ilBasicSkill.php.

    {
        $ilDB = $this->db;
 
        $nr = $this->getMaxLevelNr();
        $nid = $ilDB->nextId("skl_level");
        $ilDB->insert("skl_level", array(
                "id" => array("integer", $nid),
                "skill_id" => array("integer", $this->getId()),
                "nr" => array("integer", $nr + 1),
                "title" => array("text", $a_title),
                "description" => array("clob", $a_description),
                "import_id" => array("text", $a_import_id),
                "creation_date" => array("timestamp", ilUtil::now())
            ));
    }

References $db, $ilDB, ilSkillTreeNode\getId(), getMaxLevelNr(), and ilUtil\now().

Here is the call graph for this function:

◆ copy()

ilBasicSkill::copy ( )

Copy basic skill.

Reimplemented in ilBasicSkillTemplate.

Definition at line 91 of file class.ilBasicSkill.php.

    {
        $skill = new ilBasicSkill();
        $skill->setTitle($this->getTitle());
        $skill->setType($this->getType());
        $skill->setSelfEvaluation($this->getSelfEvaluation());
        $skill->setOrderNr($this->getOrderNr());
        $skill->create();
 
        $levels = $this->getLevelData();
        if (sizeof($levels)) {
            foreach ($levels as $item) {
                $skill->addLevel($item["title"], $item["description"]);
            }
        }
        $skill->update();
        
        return $skill;
    }

References getLevelData(), ilSkillTreeNode\getOrderNr(), ilSkillTreeNode\getSelfEvaluation(), ilSkillTreeNode\getTitle(), and ilSkillTreeNode\getType().

Here is the call graph for this function:

◆ create()

ilBasicSkill::create ( )

Create skill.

Reimplemented from ilSkillTreeNode.

Definition at line 63 of file class.ilBasicSkill.php.

    {
        parent::create();
    }

◆ delete()

ilBasicSkill::delete ( )

Delete skill.

Reimplemented from ilSkillTreeNode.

Definition at line 71 of file class.ilBasicSkill.php.

    {
        $ilDB = $this->db;
 
        $ilDB->manipulate(
            "DELETE FROM skl_level WHERE "
            . " skill_id = " . $ilDB->quote($this->getId(), "integer")
        );
 
        $ilDB->manipulate(
            "DELETE FROM skl_user_has_level WHERE "
            . " skill_id = " . $ilDB->quote($this->getId(), "integer")
        );
 
        parent::delete();
    }

References $db, and $ilDB.

◆ deleteLevel()

ilBasicSkill::deleteLevel ( $a_id )

Delete level.

Parameters

return

Definition at line 309 of file class.ilBasicSkill.php.

    {
        $ilDB = $this->db;
 
        $ilDB->manipulate(
            "DELETE FROM skl_level WHERE "
            . " id = " . $ilDB->quote($a_id, "integer")
        );
    }

References $db, and $ilDB.

◆ fixLevelNumbering()

ilBasicSkill::fixLevelNumbering ( )

Fix level numbering.

Parameters

return

Definition at line 325 of file class.ilBasicSkill.php.

    {
        $ilDB = $this->db;
 
        $set = $ilDB->query(
            "SELECT id, nr FROM skl_level WHERE " .
            " skill_id = " . $ilDB->quote($this->getId(), "integer") .
            " ORDER BY nr ASC"
        );
        $cnt = 1;
        while ($rec = $ilDB->fetchAssoc($set)) {
            $ilDB->manipulate(
                "UPDATE skl_level SET " .
                " nr = " . $ilDB->quote($cnt, "integer") .
                " WHERE id = " . $ilDB->quote($rec["id"], "integer")
            );
            $cnt++;
        }
    }

References $db, and $ilDB.

◆ getAllHistoricLevelEntriesOfUser()

ilBasicSkill::getAllHistoricLevelEntriesOfUser	(	$a_tref_id,
		$a_user_id = `0`,
		$a_eval_by = `0`
	)

Get all historic level entries.

Parameters

return

Definition at line 789 of file class.ilBasicSkill.php.

    {
        $ilDB = $this->db;
        $ilUser = $this->user;
 
        if ($a_user_id == 0) {
            $a_user_id = $ilUser->getId();
        }
 
        $by = ($a_eval_by != self::EVAL_BY_ALL)
            ? " AND self_eval = " . $ilDB->quote($a_self_eval, "integer")
            : "";
 
        $set = $ilDB->query(
            $q = "SELECT * FROM skl_user_skill_level " .
                " WHERE skill_id = " . $ilDB->quote($this->getId(), "integer") .
                " AND tref_id = " . $ilDB->quote((int) $a_tref_id, "integer") .
                " AND user_id = " . $ilDB->quote($a_user_id, "integer") .
                $by .
                " ORDER BY status_date DESC"
        );
        $levels = array();
        while ($rec = $ilDB->fetchAssoc($set)) {
            $levels[] = $rec;
        }
        return $levels;
    }

References $db, $ilDB, $ilUser, $user, and EVAL_BY_ALL.

◆ getAllLevelEntriesOfUser()

ilBasicSkill::getAllLevelEntriesOfUser	(	$a_tref_id,
		$a_user_id = `0`,
		$a_self_eval = `0`
	)

Get all level entries.

Parameters

return

Definition at line 758 of file class.ilBasicSkill.php.

    {
        $ilDB = $this->db;
        $ilUser = $this->user;
        
        if ($a_user_id == 0) {
            $a_user_id = $ilUser->getId();
        }
        
        $set = $ilDB->query(
            $q = "SELECT * FROM skl_user_has_level " .
            " WHERE skill_id = " . $ilDB->quote($this->getId(), "integer") .
            " AND tref_id = " . $ilDB->quote((int) $a_tref_id, "integer") .
            " AND user_id = " . $ilDB->quote($a_user_id, "integer") .
            " AND self_eval = " . $ilDB->quote($a_self_eval, "integer") .
            " ORDER BY status_date DESC"
        );
 
        $levels = array();
        while ($rec = $ilDB->fetchAssoc($set)) {
            $levels[] = $rec;
        }
        return $levels;
    }

References $db, $ilDB, $ilUser, and $user.

◆ getCommonSkillIdForImportId()

static ilBasicSkill::getCommonSkillIdForImportId	(	$a_source_inst_id,
		$a_skill_import_id,
		$a_tref_import_id = `0`
	)

static

Get common skill ids for import IDs (newest first)

Parameters

int	$a_source_inst_id	source installation id, must be <>0
int	$a_skill_import_id	source skill id (type basic skill ("skll") or basic skill template ("sktp"))
int	$a_tref_import_id	source template reference id (if > 0 skill_import_id will be of type "sktp")

Returns: array array of common skill ids, keys are "skill_id", "tref_id", "creation_date"

Definition at line 1057 of file class.ilBasicSkill.php.

    {
        global $DIC;
 
        $ilDB = $DIC->database();
 
        include_once("./Services/Skill/classes/class.ilSkillTree.php");
        include_once("./Services/Skill/classes/class.ilSkillTemplateReference.php");
        $tree = new ilSkillTree();
 
        if ($a_source_inst_id == 0) {
            return array();
        }
 
        $template_ids = array();
        if ($a_tref_import_id > 0) {
            $skill_node_type = "sktp";
 
            // get all matching tref nodes
            $set = $ilDB->query("SELECT * FROM skl_tree_node n JOIN skl_tree t ON (n.obj_id = t.child) " .
                    " WHERE n.import_id = " . $ilDB->quote("il_" . ((int) $a_source_inst_id) . "_sktr_" . $a_tref_import_id, "text") .
                    " ORDER BY n.creation_date DESC ");
            while ($rec = $ilDB->fetchAssoc($set)) {
                if (($t = ilSkillTemplateReference::_lookupTemplateId($rec["obj_id"])) > 0) {
                    $template_ids[$t] = $rec["obj_id"];
                }
            }
        } else {
            $skill_node_type = "skll";
        }
        $set = $ilDB->query("SELECT * FROM skl_tree_node n JOIN skl_tree t ON (n.obj_id = t.child) " .
            " WHERE n.import_id = " . $ilDB->quote("il_" . ((int) $a_source_inst_id) . "_" . $skill_node_type . "_" . $a_skill_import_id, "text") .
            " ORDER BY n.creation_date DESC ");
        $results = array();
        while ($rec = $ilDB->fetchAssoc($set)) {
            $matching_trefs = array();
            if ($a_tref_import_id > 0) {
                $skill_template_id = $tree->getTopParentNodeId($rec["obj_id"]);
 
                // check of skill is in template
                foreach ($template_ids as $templ => $tref) {
                    if ($skill_template_id == $templ) {
                        $matching_trefs[] = $tref;
                    }
                }
            } else {
                $matching_trefs = array(0);
            }
 
            foreach ($matching_trefs as $t) {
                $results[] = array("skill_id" => $rec["obj_id"], "tref_id" => $t, "creation_date" => $rec["creation_date"]);
            }
        }
        return $results;
    }

References $DIC, $ilDB, $results, $t, $tree, and ilSkillTemplateReference\_lookupTemplateId().

Referenced by getLevelIdForImportIdMatchSkill(), ilAssQuestionSkillAssignmentImporter\getSkillIdMapping(), ilSurveyDataSet\importRecord(), and ilSkillDataSet\importRecord().

Here is the call graph for this function:

Here is the caller graph for this function:

◆ getLastLevelPerObject()

ilBasicSkill::getLastLevelPerObject	(	$a_tref_id,
		$a_object_id,
		$a_user_id = `0`,
		$a_self_eval = `0`
	)

Get last level set per object.

Parameters

return

Definition at line 926 of file class.ilBasicSkill.php.

    {
        $ilDB = $this->db;
        $ilUser = $this->user;
 
        if ($a_user_id == 0) {
            $a_user_id = $ilUser->getId();
        }
 
        $ilDB->setLimit(1);
        $set = $ilDB->query(
            $q = "SELECT level_id FROM skl_user_has_level " .
                " WHERE trigger_obj_id = " . $ilDB->quote($a_object_id, "integer") .
                " AND skill_id = " . $ilDB->quote($this->getId(), "integer") .
                " AND tref_id = " . $ilDB->quote((int) $a_tref_id, "integer") .
                " AND user_id = " . $ilDB->quote($a_user_id, "integer") .
                " AND self_eval = " . $ilDB->quote($a_self_eval, "integer") .
                " ORDER BY status_date DESC"
        );
 
        $rec = $ilDB->fetchAssoc($set);
 
        return $rec["level_id"];
    }

References $db, $ilDB, $ilUser, and $user.

◆ getLastUpdatePerObject()

ilBasicSkill::getLastUpdatePerObject	(	$a_tref_id,
		$a_object_id,
		$a_user_id = `0`,
		$a_self_eval = `0`
	)

Get last update per object.

Parameters

return

Definition at line 957 of file class.ilBasicSkill.php.

    {
        $ilDB = $this->db;
        $ilUser = $this->user;
 
        if ($a_user_id == 0) {
            $a_user_id = $ilUser->getId();
        }
 
        $ilDB->setLimit(1);
        $set = $ilDB->query(
            $q = "SELECT status_date FROM skl_user_has_level " .
                " WHERE trigger_obj_id = " . $ilDB->quote($a_object_id, "integer") .
                " AND skill_id = " . $ilDB->quote($this->getId(), "integer") .
                " AND tref_id = " . $ilDB->quote((int) $a_tref_id, "integer") .
                " AND user_id = " . $ilDB->quote($a_user_id, "integer") .
                " AND self_eval = " . $ilDB->quote($a_self_eval, "integer") .
                " ORDER BY status_date DESC"
        );
 
        $rec = $ilDB->fetchAssoc($set);
 
        return $rec["status_date"];
    }

References $db, $ilDB, $ilUser, and $user.

◆ getLevelData()

ilBasicSkill::getLevelData ( $a_id = 0 )

Get level data.

Returns: array level data

Definition at line 162 of file class.ilBasicSkill.php.

    {
        $ilDB = $this->db;
 
        if ($a_id > 0) {
            $and = " AND id = " . $ilDB->quote($a_id, "integer");
        }
 
        $set = $ilDB->query(
            "SELECT * FROM skl_level WHERE " .
            " skill_id = " . $ilDB->quote($this->getId(), "integer") .
            $and .
            " ORDER BY nr"
        );
        $levels = array();
        while ($rec = $ilDB->fetchAssoc($set)) {
            if ($a_id > 0) {
                return $rec;
            }
            $levels[] = $rec;
        }
        return $levels;
    }

References $db, and $ilDB.

Referenced by copy(), ilBasicSkillTemplate\copy(), getMaxLevel(), getMaxLevelPerObject(), and getMaxLevelPerType().

Here is the caller graph for this function:

◆ getLevelIdForImportId()

static ilBasicSkill::getLevelIdForImportId	(	$a_source_inst_id,
		$a_level_import_id
	)

static

Get level ids for import IDs (newest first)

Parameters

int	$a_source_inst_id	source installation id, must be <>0
int	$a_skill_import_id	source skill id (type basic skill ("skll") or basic skill template ("sktp"))

Returns: array array of common skill ids, keys are "level_id", "creation_date"

Definition at line 1120 of file class.ilBasicSkill.php.

    {
        global $DIC;
 
        $ilDB = $DIC->database();
 
        $set = $ilDB->query("SELECT * FROM skl_level l JOIN skl_tree t ON (l.skill_id = t.child) " .
                " WHERE l.import_id = " . $ilDB->quote("il_" . ((int) $a_source_inst_id) . "_sklv_" . $a_level_import_id, "text") .
                " ORDER BY l.creation_date DESC ");
        $results = array();
        while ($rec = $ilDB->fetchAssoc($set)) {
            $results[] = array("level_id" => $rec["id"], "creation_date" => $rec["creation_date"]);
        }
        return $results;
    }

References $DIC, $ilDB, and $results.

Referenced by getLevelIdForImportIdMatchSkill(), ilTestSkillLevelThresholdImporter\getLevelIdMapping(), and ilSkillDataSet\importRecord().

Here is the caller graph for this function:

◆ getLevelIdForImportIdMatchSkill()

static ilBasicSkill::getLevelIdForImportIdMatchSkill	(	$a_source_inst_id,
		$a_level_import_id,
		$a_skill_import_id,
		$a_tref_import_id = `0`
	)

static

Get level ids for import Ids matching common skills.

Parameters

return

Definition at line 1142 of file class.ilBasicSkill.php.

    {
        $level_id_data = self::getLevelIdForImportId($a_source_inst_id, $a_level_import_id);
        $skill_data = self::getCommonSkillIdForImportId($a_source_inst_id, $a_skill_import_id, $a_tref_import_id);
        $matches = array();
        foreach ($level_id_data as $l) {
            reset($skill_data);
            foreach ($skill_data as $s) {
                if (ilBasicSkill::lookupLevelSkillId($l["level_id"]) == $s["skill_id"]) {
                    $matches[] = array(
                            "level_id" => $l["level_id"],
                            "creation_date" => $l["creation_date"],
                            "skill_id" => $s["skill_id"],
                            "tref_id" => $s["tref_id"]
                    );
                }
            }
        }
        return $matches;
    }

References $l, $s, getCommonSkillIdForImportId(), getLevelIdForImportId(), and lookupLevelSkillId().

Referenced by ilSurveyDataSet\importRecord().

Here is the call graph for this function:

Here is the caller graph for this function:

◆ getMaxLevel()

ilBasicSkill::getMaxLevel	(	$a_tref_id,
		$a_user_id = `0`,
		$a_self_eval = `0`
	)

Get max levels per object.

Parameters

return

Definition at line 861 of file class.ilBasicSkill.php.

    {
        $ilDB = $this->db;
        $ilUser = $this->user;
 
        if ($a_user_id == 0) {
            $a_user_id = $ilUser->getId();
        }
 
        $set = $ilDB->query(
            $q = "SELECT level_id FROM skl_user_has_level " .
            " WHERE skill_id = " . $ilDB->quote($this->getId(), "integer") .
            " AND tref_id = " . $ilDB->quote((int) $a_tref_id, "integer") .
            " AND user_id = " . $ilDB->quote($a_user_id, "integer") .
            " AND self_eval = " . $ilDB->quote($a_self_eval, "integer")
        );
 
        $has_level = array();
        while ($rec = $ilDB->fetchAssoc($set)) {
            $has_level[$rec["level_id"]] = true;
        }
        $max_level = 0;
        foreach ($this->getLevelData() as $l) {
            if (isset($has_level[$l["id"]])) {
                $max_level = $l["id"];
            }
        }
        return $max_level;
    }

References $db, $ilDB, $ilUser, $l, $user, and getLevelData().

Here is the call graph for this function:

◆ getMaxLevelNr()

ilBasicSkill::getMaxLevelNr ( )

Get maximum level nr.

Returns: int maximum level nr of skill

Definition at line 145 of file class.ilBasicSkill.php.

    {
        $ilDB = $this->db;
 
        $set = $ilDB->query(
            "SELECT MAX(nr) mnr FROM skl_level WHERE " .
            " skill_id = " . $ilDB->quote($this->getId(), "integer")
        );
        $rec = $ilDB->fetchAssoc($set);
        return (int) $rec["mnr"];
    }

References $db, and $ilDB.

Referenced by addLevel().

Here is the caller graph for this function:

◆ getMaxLevelPerObject()

ilBasicSkill::getMaxLevelPerObject	(	$a_tref_id,
		$a_object_id,
		$a_user_id = `0`,
		$a_self_eval = `0`
	)

Get max levels per object.

Parameters

return

Definition at line 824 of file class.ilBasicSkill.php.

    {
        $ilDB = $this->db;
        $ilUser = $this->user;
 
        if ($a_user_id == 0) {
            $a_user_id = $ilUser->getId();
        }
 
        $set = $ilDB->query(
            $q = "SELECT level_id FROM skl_user_has_level " .
                " WHERE trigger_obj_id = " . $ilDB->quote($a_object_id, "integer") .
                " AND skill_id = " . $ilDB->quote($this->getId(), "integer") .
                " AND tref_id = " . $ilDB->quote((int) $a_tref_id, "integer") .
                " AND user_id = " . $ilDB->quote($a_user_id, "integer") .
                " AND self_eval = " . $ilDB->quote($a_self_eval, "integer")
        );
 
        $has_level = array();
        while ($rec = $ilDB->fetchAssoc($set)) {
            $has_level[$rec["level_id"]] = true;
        }
        $max_level = 0;
        foreach ($this->getLevelData() as $l) {
            if (isset($has_level[$l["id"]])) {
                $max_level = $l["id"];
            }
        }
        return $max_level;
    }

References $db, $ilDB, $ilUser, $l, $user, and getLevelData().

Here is the call graph for this function:

◆ getMaxLevelPerType()

ilBasicSkill::getMaxLevelPerType	(	$a_tref_id,
		$a_type,
		$a_user_id = `0`,
		$a_self_eval = `0`
	)

Get max levels per type.

Parameters

return

Definition at line 721 of file class.ilBasicSkill.php.

    {
        $ilDB = $this->db;
        $ilUser = $this->user;
        
        if ($a_user_id == 0) {
            $a_user_id = $ilUser->getId();
        }
        
        $set = $ilDB->query(
            $q = "SELECT level_id FROM skl_user_has_level " .
            " WHERE trigger_obj_type = " . $ilDB->quote($a_type, "text") .
            " AND skill_id = " . $ilDB->quote($this->getId(), "integer") .
            " AND tref_id = " . $ilDB->quote((int) $a_tref_id, "integer") .
            " AND user_id = " . $ilDB->quote($a_user_id, "integer") .
            " AND self_eval = " . $ilDB->quote($a_self_eval, "integer")
        );
 
        $has_level = array();
        while ($rec = $ilDB->fetchAssoc($set)) {
            $has_level[$rec["level_id"]] = true;
        }
        $max_level = 0;
        foreach ($this->getLevelData() as $l) {
            if (isset($has_level[$l["id"]])) {
                $max_level = $l["id"];
            }
        }
        return $max_level;
    }

References $a_type, $db, $ilDB, $ilUser, $l, $user, and getLevelData().

Here is the call graph for this function:

◆ getNewAchievementsPerUser()

static ilBasicSkill::getNewAchievementsPerUser	(	$a_timestamp,
		$a_timestamp_to = `null`,
		$a_user_id = `0`,
		$a_self_eval = `0`
	)

static

Get new achievements.

Parameters

string $a_timestamp

Returns: array

Definition at line 499 of file class.ilBasicSkill.php.

    {
        global $DIC;
 
        $db = $DIC->database();
 
        $to = (!is_null($a_timestamp_to))
            ? " AND status_date <= " . $db->quote($a_timestamp_to, "timestamp")
            : "";
 
        $user = ($a_user_id > 0)
            ? " AND user_id = " . $db->quote($a_user_id, "integer")
            : "";
 
        $set = $db->query("SELECT * FROM skl_user_skill_level " .
            " WHERE status_date >= " . $db->quote($a_timestamp, "timestamp") .
            " AND valid = " . $db->quote(1, "integer") .
            " AND status = " . $db->quote(ilBasicSkill::ACHIEVED, "integer") .
            " AND self_eval = " . $db->quote($a_self_eval, "integer") .
            $to .
            $user .
            " ORDER BY user_id, status_date ASC ");
        $achievments = array();
        while ($rec = $db->fetchAssoc($set)) {
            $achievments[$rec["user_id"]][] = $rec;
        }
 
        return $achievments;
    }

References $db, $DIC, $user, and ACHIEVED.

Referenced by ilSkillLearningHistoryProvider\getEntries(), and ilSkillNotifications\run().

Here is the caller graph for this function:

◆ getShortTitleForCertificate()

ilBasicSkill::getShortTitleForCertificate ( )

Get short title for certificate.

Parameters

return

Definition at line 1005 of file class.ilBasicSkill.php.

    {
        return "Skill";
    }

◆ getSkillForLevelId()

ilBasicSkill::getSkillForLevelId ( $a_level_id )

Get skill for level id.

Parameters

return

Definition at line 351 of file class.ilBasicSkill.php.

    {
        $ilDB = $this->db;
 
        $set = $ilDB->query(
            "SELECT * FROM skl_level WHERE " .
            " id = " . $ilDB->quote($a_level_id, "integer")
        );
        $skill = null;
        if ($rec = $ilDB->fetchAssoc($set)) {
            if (ilSkillTreeNode::isInTree($rec["skill_id"])) {
                $skill = new ilBasicSkill($rec["skill_id"]);
            }
        }
        return $skill;
    }

References $db, $ilDB, and ilSkillTreeNode\isInTree().

Here is the call graph for this function:

◆ getTitleForCertificate()

ilBasicSkill::getTitleForCertificate ( )

Get title for certificate.

Parameters

return

Definition at line 994 of file class.ilBasicSkill.php.

    {
        return $this->getTitle();
    }

References ilSkillTreeNode\getTitle().

Here is the call graph for this function:

◆ getUsageInfo()

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

static

Get usage info.

Parameters

return

Implements ilSkillUsageInfo.

Definition at line 1033 of file class.ilBasicSkill.php.

    {
        global $DIC;
 
        $ilDB = $DIC->database();
        
        include_once("./Services/Skill/classes/class.ilSkillUsage.php");
        ilSkillUsage::getUsageInfoGeneric(
            $a_cskill_ids,
            $a_usages,
            ilSkillUsage::USER_ASSIGNED,
            "skl_user_skill_level",
            "user_id"
        );
    }

References $DIC, $ilDB, ilSkillUsage\getUsageInfoGeneric(), and ilSkillUsage\USER_ASSIGNED.

Here is the call graph for this function:

◆ hasRecentSelfEvaluation()

static ilBasicSkill::hasRecentSelfEvaluation	(	$a_user_id,
		$a_skill_id,
		$a_tref_id = `0`,
		$a_trigger_ref_id = `0`
	)

staticprotected

Has recent self evaluation.

Check if self evaluation for user/object has been done on the same day already

Parameters

return

Definition at line 461 of file class.ilBasicSkill.php.

    {
        global $DIC;
 
        $db = $DIC->database();
 
        $trigger_obj_id = ($a_trigger_ref_id > 0)
            ? ilObject::_lookupObjId($a_trigger_ref_id)
            : 0;
 
        $recent = "";
 
        $db->setLimit(1);
        $set = $db->query(
            "SELECT * FROM skl_user_skill_level WHERE " .
            "skill_id = " . $db->quote($a_skill_id, "integer") . " AND " .
            "user_id = " . $db->quote($a_user_id, "integer") . " AND " .
            "tref_id = " . $db->quote((int) $a_tref_id, "integer") . " AND " .
            "trigger_obj_id = " . $db->quote($trigger_obj_id, "integer") . " AND " .
            "self_eval = " . $db->quote(1, "integer") .
            " ORDER BY status_date DESC"
        );
        $rec = $db->fetchAssoc($set);
        $status_day = substr($rec["status_date"], 0, 10);
        $today = substr(ilUtil::now(), 0, 10);
        if ($rec["valid"] && $rec["status"] == ilBasicSkill::ACHIEVED && $status_day == $today) {
            $recent = $rec["status_date"];
        }
 
        return $recent;
    }

References $db, $DIC, ilObject\_lookupObjId(), ACHIEVED, and ilUtil\now().

Referenced by resetUserSkillLevelStatus(), and writeUserSkillLevelStatus().

Here is the call graph for this function:

Here is the caller graph for this function:

◆ hasSelfEvaluated()

static ilBasicSkill::hasSelfEvaluated	(	$a_user_id,
		$a_skill_id,
		$a_tref_id
	)

static

Has use self evaluated a skill?

Parameters

int	$a_user_id
int	$a_skill_id
int	$a_tref_id

Returns: bool

Definition at line 900 of file class.ilBasicSkill.php.

    {
        global $DIC;
 
        $db = $DIC->database();
 
        $set = $db->query(
            $q = "SELECT level_id FROM skl_user_has_level " .
            " WHERE skill_id = " . $db->quote((int) $a_skill_id, "integer") .
            " AND tref_id = " . $db->quote((int) $a_tref_id, "integer") .
            " AND user_id = " . $db->quote($a_user_id, "integer") .
            " AND self_eval = " . $db->quote(1, "integer")
        );
        
        if ($rec = $db->fetchAssoc($set)) {
            return true;
        }
        return false;
    }

References $db, and $DIC.

Referenced by ilPersonalSkillsGUI\renderSkillHTML().

Here is the caller graph for this function:

◆ lookupLevelDescription()

static ilBasicSkill::lookupLevelDescription ( $a_id )

static

Lookup level description.

Parameters

int level id

Returns: string level description

Definition at line 223 of file class.ilBasicSkill.php.

    {
        return ilBasicSkill::lookupLevelProperty($a_id, "description");
    }

References lookupLevelProperty().

Here is the call graph for this function:

◆ lookupLevelProperty()

static ilBasicSkill::lookupLevelProperty	(	$a_id,
		$a_prop
	)

staticprotected

Lookup level property.

Parameters

id level id

Returns: mixed property value

Definition at line 192 of file class.ilBasicSkill.php.

    {
        global $DIC;
 
        $ilDB = $DIC->database();
 
        $set = $ilDB->query(
            "SELECT $a_prop FROM skl_level WHERE " .
            " id = " . $ilDB->quote($a_id, "integer")
        );
        $rec = $ilDB->fetchAssoc($set);
        return $rec[$a_prop];
    }

References $DIC, and $ilDB.

Referenced by lookupLevelDescription(), lookupLevelSkillId(), and lookupLevelTitle().

Here is the caller graph for this function:

◆ lookupLevelSkillId()

static ilBasicSkill::lookupLevelSkillId ( $a_id )

static

Lookup level skill id.

Parameters

int level id

Returns: string skill id

Definition at line 234 of file class.ilBasicSkill.php.

    {
        return ilBasicSkill::lookupLevelProperty($a_id, "skill_id");
    }

References lookupLevelProperty().

Referenced by getLevelIdForImportIdMatchSkill(), ilSkillDataSet\importRecord(), and writeUserSkillLevelStatus().

Here is the call graph for this function:

Here is the caller graph for this function:

◆ lookupLevelTitle()

static ilBasicSkill::lookupLevelTitle ( $a_id )

static

Lookup level title.

Parameters

int level id

Returns: string level title

Definition at line 212 of file class.ilBasicSkill.php.

    {
        return ilBasicSkill::lookupLevelProperty($a_id, "title");
    }

References lookupLevelProperty().

Referenced by ilSkillProfileGUI\confirmLevelAssignmentRemoval(), ilBasicSkillGUI\confirmLevelDeletion(), ilContSkillMemberTableGUI\fillRow(), ilSkillProfileLevelsTableGUI\fillRow(), ilSkillLearningHistoryProvider\getEntries(), ilPersonalSkillsGUI\getSuggestedResources(), ilSkillNotifications\sendMail(), ilBasicSkillGUI\setLevelHead(), and ilBasicSkillTemplateGUI\setLevelHead().

Here is the call graph for this function:

Here is the caller graph for this function:

◆ read()

ilBasicSkill::read ( )

Read data from database.

Reimplemented from ilSkillTreeNode.

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

    {
        parent::read();
    }

◆ removeAllUserData()

static ilBasicSkill::removeAllUserData ( $a_user_id )

static

Remove all data of a user.

Parameters

int $a_user_id

Definition at line 698 of file class.ilBasicSkill.php.

    {
        global $DIC;
 
        $db = $DIC->database();
 
        $db->manipulate(
            "DELETE FROM skl_user_skill_level WHERE "
            . " user_id = " . $db->quote($a_user_id, "integer")
        );
        $db->manipulate(
            "DELETE FROM skl_user_has_level WHERE "
            . " user_id = " . $db->quote($a_user_id, "integer")
        );
    }

References $db, and $DIC.

Referenced by ilSkillObjDeletionHandler\processDeletion().

Here is the caller graph for this function:

◆ removeAllUserSkillLevelStatusOfObject()

static ilBasicSkill::removeAllUserSkillLevelStatusOfObject	(	$a_user_id,
		$a_trigger_obj_id,
		$a_self_eval = `false`,
		$a_unique_identifier = `""`
	)

static

Remove a user skill completely.

Parameters

int	$a_user_id	user id
int	$a_trigger_obj_id	triggering repository object obj id
bool	$a_self_eval	currently needs to be set to true
string	$a_unique_identifier	unique identifier string

Returns: bool true, if entries have been deleted, otherwise false

Definition at line 658 of file class.ilBasicSkill.php.

    {
        global $DIC;
 
        $db = $DIC->database();
 
        if ($a_trigger_obj_id == 0) {
            return false;
        }
 
        $changed = false;
 
        $aff_rows = $db->manipulate(
            "DELETE FROM skl_user_skill_level WHERE "
            . " user_id = " . $db->quote($a_user_id, "integer")
            . " AND trigger_obj_id = " . $db->quote($a_trigger_obj_id, "integer")
            . " AND self_eval = " . $db->quote($a_self_eval, "integer")
            . " AND unique_identifier = " . $db->quote($a_unique_identifier, "text")
        );
        if ($aff_rows > 0) {
            $changed = true;
        }
 
        $aff_rows = $db->manipulate(
            "DELETE FROM skl_user_has_level WHERE "
            . " user_id = " . $db->quote($a_user_id, "integer")
            . " AND trigger_obj_id = " . $db->quote($a_trigger_obj_id, "integer")
            . " AND self_eval = " . $db->quote($a_self_eval, "integer")
        );
        if ($aff_rows > 0) {
            $changed = true;
        }
        return $changed;
    }

References $changed, $db, and $DIC.

Referenced by ilContainerMemberSkills\publish(), and ilContainerMemberSkills\removeAllSkillLevels().

Here is the caller graph for this function:

◆ resetUserSkillLevelStatus()

static ilBasicSkill::resetUserSkillLevelStatus	(	$a_user_id,
		$a_skill_id,
		$a_tref_id = `0`,
		$a_trigger_ref_id = `0`,
		$a_self_eval = `false`
	)

static

Reset skill level status.

This is currently only used for self evaluations with a "no competence" level. It has to be discussed, how this should be provided for non-self-evaluations.

Parameters

int	$a_user_id	user id
int	$a_skill_id	skill id
int	$a_tref_id	skill tref id
int	$a_trigger_ref_id	triggering repository object ref id
bool	$a_self_eval	currently needs to be set to true

Exceptions

ilSkillException

Definition at line 387 of file class.ilBasicSkill.php.

    {
        global $DIC;
 
        $db = $DIC->database();
 
        if (!$a_self_eval) {
            include_once("./Services/Skill/exceptions/class.ilSkillException.php");
            throw new ilSkillException("resetUserSkillLevelStatus currently only provided for self evaluations.");
        }
 
        $trigger_obj_id = ($a_trigger_ref_id > 0)
            ? ilObject::_lookupObjId($a_trigger_ref_id)
            : 0;
 
        $update = false;
        $status_date = self::hasRecentSelfEvaluation($a_user_id, $a_skill_id, $a_tref_id, $a_trigger_ref_id);
        if ($status_date != "") {
            $update = true;
        }
 
        if ($update) {
            // this will only be set in self eval case, means this will always have a $rec
            $now = ilUtil::now();
            $db->manipulate(
                "UPDATE skl_user_skill_level SET " .
                " level_id = " . $db->quote(0, "integer") . "," .
                " status_date = " . $db->quote($now, "timestamp") .
                " WHERE user_id = " . $db->quote($a_user_id, "integer") .
                " AND status_date = " . $db->quote($status_date, "timestamp") .
                " AND skill_id = " . $db->quote($a_skill_id, "integer") .
                " AND status = " . $db->quote(self::ACHIEVED, "integer") .
                " AND trigger_obj_id = " . $db->quote($trigger_obj_id, "integer") .
                " AND tref_id = " . $db->quote((int) $a_tref_id, "integer") .
                " AND self_eval = " . $db->quote($a_self_eval, "integer")
            );
        } else {
            $now = ilUtil::now();
            $db->manipulate("INSERT INTO skl_user_skill_level " .
                "(level_id, user_id, tref_id, status_date, skill_id, status, valid, trigger_ref_id," .
                "trigger_obj_id, trigger_obj_type, trigger_title, self_eval, unique_identifier) VALUES (" .
                $db->quote(0, "integer") . "," .
                $db->quote($a_user_id, "integer") . "," .
                $db->quote((int) $a_tref_id, "integer") . "," .
                $db->quote($now, "timestamp") . "," .
                $db->quote($a_skill_id, "integer") . "," .
                $db->quote(self::ACHIEVED, "integer") . "," .
                $db->quote(1, "integer") . "," .
                $db->quote($a_trigger_ref_id, "integer") . "," .
                $db->quote($trigger_obj_id, "integer") . "," .
                $db->quote("", "text") . "," .
                $db->quote("", "text") . "," .
                $db->quote($a_self_eval, "integer") . "," .
                $db->quote("", "text") .
                ")");
        }
 
        $db->manipulate(
            "DELETE FROM skl_user_has_level WHERE "
            . " user_id = " . $db->quote($a_user_id, "integer")
            . " AND skill_id = " . $db->quote($a_skill_id, "integer")
            . " AND tref_id = " . $db->quote((int) $a_tref_id, "integer")
            . " AND trigger_obj_id = " . $db->quote($trigger_obj_id, "integer")
            . " AND self_eval = " . $db->quote($a_self_eval, "integer")
        );
    }

References $db, $DIC, ilObject\_lookupObjId(), hasRecentSelfEvaluation(), and ilUtil\now().

Referenced by ilPersonalSkill\saveSelfEvaluation().

Here is the call graph for this function:

Here is the caller graph for this function:

◆ updateLevelOrder()

ilBasicSkill::updateLevelOrder ( $order )

Update level order.

Parameters

return

Definition at line 286 of file class.ilBasicSkill.php.

    {
        $ilDB = $this->db;
 
        asort($order);
 
        $cnt = 1;
        foreach ($order as $id => $o) {
            $ilDB->manipulate(
                "UPDATE skl_level SET " .
                " nr = " . $ilDB->quote($cnt, "integer") .
                " WHERE id = " . $ilDB->quote($id, "integer")
            );
            $cnt++;
        }
    }

References $db, $id, and $ilDB.

◆ writeLevelDescription()

static ilBasicSkill::writeLevelDescription	(	$a_id,
		$a_description
	)

static

Write level description.

Parameters

int	level id
text	level description

Definition at line 275 of file class.ilBasicSkill.php.

    {
        ilBasicSkill::writeLevelProperty($a_id, "description", $a_description, "clob");
    }

References writeLevelProperty().

Here is the call graph for this function:

◆ writeLevelProperty()

static ilBasicSkill::writeLevelProperty	(	$a_id,
		$a_prop,
		$a_value,
		$a_type
	)

staticprotected

Write level property.

Parameters

return

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

    {
        global $DIC;
 
        $ilDB = $DIC->database();
 
        $ilDB->update("skl_level", array(
            $a_prop => array($a_type, $a_value),
            ), array(
            "id" => array("integer", $a_id),
        ));
    }

References $a_type, $DIC, and $ilDB.

Referenced by writeLevelDescription(), and writeLevelTitle().

Here is the caller graph for this function:

◆ writeLevelTitle()

static ilBasicSkill::writeLevelTitle	(	$a_id,
		$a_title
	)

static

Write level title.

Parameters

int	level id
text	level title

Definition at line 264 of file class.ilBasicSkill.php.

    {
        ilBasicSkill::writeLevelProperty($a_id, "title", $a_title, "text");
    }

References writeLevelProperty().

Here is the call graph for this function:

◆ writeUserSkillLevelStatus()

static ilBasicSkill::writeUserSkillLevelStatus	(	$a_level_id,
		$a_user_id,
		$a_trigger_ref_id,
		$a_tref_id = `0`,
		$a_status = `ilBasicSkill::ACHIEVED`,
		$a_force = `false`,
		$a_self_eval = `false`,
		$a_unique_identifier = `""`
	)

static

Write skill level status.

Parameters

int	$a_level_id	skill level id
int	$a_user_id	user id
int	$a_trigger_ref_id	trigger repository object ref id
int	$a_tref_id	skill tref id
int	$a_status	DEPRECATED, always use ilBasicSkill::ACHIEVED
bool	$a_force	DEPRECATED
bool	$a_self_eval	self evaluation
string	$a_unique_identifier	a unique identifier (should be used with trigger_ref_id > 0)

Definition at line 542 of file class.ilBasicSkill.php.

      {
        global $DIC;
 
        $ilDB = $DIC->database();
 
        $skill_id = ilBasicSkill::lookupLevelSkillId($a_level_id);
        $trigger_ref_id = $a_trigger_ref_id;
        $trigger_obj_id = ilObject::_lookupObjId($trigger_ref_id);
        $trigger_title = ilObject::_lookupTitle($trigger_obj_id);
        $trigger_type = ilObject::_lookupType($trigger_obj_id);
 
        $update = false;
 
        // self evaluations will update, if the last self evaluation is on the same day
        if ($a_self_eval && self::hasRecentSelfEvaluation($a_user_id, $skill_id, $a_tref_id, $trigger_ref_id)) {
            $status_date = self::hasRecentSelfEvaluation($a_user_id, $skill_id, $a_tref_id, $trigger_ref_id);
            if ($status_date != "") {
                $update = true;
            }
        }
 
        if ($update) {
            // this will only be set in self eval case, means this will always have a $rec
            $now = ilUtil::now();
            $ilDB->manipulate(
                "UPDATE skl_user_skill_level SET " .
                " level_id = " . $ilDB->quote($a_level_id, "integer") . "," .
                " status_date = " . $ilDB->quote($now, "timestamp") .
                " WHERE user_id = " . $ilDB->quote($a_user_id, "integer") .
                " AND status_date = " . $ilDB->quote($status_date, "timestamp") .
                " AND skill_id = " . $ilDB->quote($skill_id, "integer") .
                " AND status = " . $ilDB->quote($a_status, "integer") .
                " AND trigger_obj_id = " . $ilDB->quote($trigger_obj_id, "integer") .
                " AND tref_id = " . $ilDB->quote((int) $a_tref_id, "integer") .
                " AND self_eval = " . $ilDB->quote($a_self_eval, "integer")
            );
        } else {
            if ($a_unique_identifier != "") {
                $ilDB->manipulate(
                    "DELETE FROM skl_user_skill_level WHERE " .
                    " user_id = " . $ilDB->quote($a_user_id, "integer") .
                    " AND tref_id = " . $ilDB->quote($a_tref_id, "integer") .
                    " AND skill_id = " . $ilDB->quote($skill_id, "integer") .
                    " AND trigger_ref_id = " . $ilDB->quote($trigger_ref_id, "integer") .
                    " AND trigger_obj_id = " . $ilDB->quote($trigger_obj_id, "integer") .
                    " AND self_eval = " . $ilDB->quote($a_self_eval, "integer") .
                    " AND unique_identifier = " . $ilDB->quote($a_unique_identifier, "text")
                );
            }
 
            $now = ilUtil::now();
            $ilDB->manipulate("INSERT INTO skl_user_skill_level " .
                "(level_id, user_id, tref_id, status_date, skill_id, status, valid, trigger_ref_id," .
                "trigger_obj_id, trigger_obj_type, trigger_title, self_eval, unique_identifier) VALUES (" .
                $ilDB->quote($a_level_id, "integer") . "," .
                $ilDB->quote($a_user_id, "integer") . "," .
                $ilDB->quote((int) $a_tref_id, "integer") . "," .
                $ilDB->quote($now, "timestamp") . "," .
                $ilDB->quote($skill_id, "integer") . "," .
                $ilDB->quote($a_status, "integer") . "," .
                $ilDB->quote(1, "integer") . "," .
                $ilDB->quote($trigger_ref_id, "integer") . "," .
                $ilDB->quote($trigger_obj_id, "integer") . "," .
                $ilDB->quote($trigger_type, "text") . "," .
                $ilDB->quote($trigger_title, "text") . "," .
                $ilDB->quote($a_self_eval, "integer") . "," .
                $ilDB->quote($a_unique_identifier, "text") .
                ")");
        }
 
        // fix (removed level_id and added skill id, since table should hold only
        // one entry per skill)
        $ilDB->manipulate(
            "DELETE FROM skl_user_has_level WHERE "
            . " user_id = " . $ilDB->quote($a_user_id, "integer")
            . " AND skill_id = " . $ilDB->quote($skill_id, "integer")
            . " AND tref_id = " . $ilDB->quote((int) $a_tref_id, "integer")
            . " AND trigger_obj_id = " . $ilDB->quote($trigger_obj_id, "integer")
            . " AND self_eval = " . $ilDB->quote($a_self_eval, "integer")
        );
 
        if ($a_status == ilBasicSkill::ACHIEVED) {
            $ilDB->manipulate("INSERT INTO skl_user_has_level " .
            "(level_id, user_id, tref_id, status_date, skill_id, trigger_ref_id, trigger_obj_id, trigger_obj_type, trigger_title, self_eval) VALUES (" .
            $ilDB->quote($a_level_id, "integer") . "," .
            $ilDB->quote($a_user_id, "integer") . "," .
            $ilDB->quote($a_tref_id, "integer") . "," .
            $ilDB->quote($now, "timestamp") . "," .
            $ilDB->quote($skill_id, "integer") . "," .
            $ilDB->quote($trigger_ref_id, "integer") . "," .
            $ilDB->quote($trigger_obj_id, "integer") . "," .
            $ilDB->quote($trigger_type, "text") . "," .
            $ilDB->quote($trigger_title, "text") . "," .
            $ilDB->quote($a_self_eval, "integer") .
            ")");
        }
    }

References $DIC, $ilDB, ilObject\_lookupObjId(), ilObject\_lookupTitle(), ilObject\_lookupType(), ACHIEVED, hasRecentSelfEvaluation(), lookupLevelSkillId(), and ilUtil\now().

Referenced by ilSkillAppEventListener\handleEvent(), ilTestSkillEvaluation\invokeSkillLevelTrigger(), ilContainerMemberSkills\publish(), ilPersonalSkill\saveSelfEvaluation(), ilSurveySkill\writeAppraiseeSkills(), ilSurveySkill\writeSelfEvalSkills(), and ilSurveySkillDeterminationGUI\writeSkills().

Here is the call graph for this function:

Here is the caller graph for this function:

Field Documentation

◆ $db

ilBasicSkill::$db

protected

◆ $id

ilBasicSkill::$id

Definition at line 35 of file class.ilBasicSkill.php.

Referenced by updateLevelOrder().

◆ $user

ilBasicSkill::$user

protected

Definition at line 26 of file class.ilBasicSkill.php.

Referenced by getAllHistoricLevelEntriesOfUser(), getAllLevelEntriesOfUser(), getLastLevelPerObject(), getLastUpdatePerObject(), getMaxLevel(), getMaxLevelPerObject(), getMaxLevelPerType(), and getNewAchievementsPerUser().

◆ ACHIEVED

const ilBasicSkill::ACHIEVED = 1

Definition at line 28 of file class.ilBasicSkill.php.

Referenced by getNewAchievementsPerUser(), hasRecentSelfEvaluation(), ilTestSkillEvaluation\invokeSkillLevelTrigger(), ilContainerMemberSkills\publish(), ilPersonalSkill\saveSelfEvaluation(), ilSurveySkill\writeAppraiseeSkills(), ilSurveySkill\writeSelfEvalSkills(), ilSurveySkillDeterminationGUI\writeSkills(), and writeUserSkillLevelStatus().

◆ EVAL_BY_ALL

const ilBasicSkill::EVAL_BY_ALL = 2

Definition at line 33 of file class.ilBasicSkill.php.

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

◆ EVAL_BY_OTHERS_

const ilBasicSkill::EVAL_BY_OTHERS_ = 0

Definition at line 31 of file class.ilBasicSkill.php.

◆ EVAL_BY_SELF

const ilBasicSkill::EVAL_BY_SELF = 1

Definition at line 32 of file class.ilBasicSkill.php.

◆ NOT_ACHIEVED

const ilBasicSkill::NOT_ACHIEVED = 0

Definition at line 29 of file class.ilBasicSkill.php.

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

Services/Skill/classes/class.ilBasicSkill.php

Public Member Functions

Static Public Member Functions

Data Fields

Static Protected Member Functions

Protected Attributes

Additional Inherited Members

Detailed Description

Constructor & Destructor Documentation

◆ __construct()

Member Function Documentation

◆ _lookupCertificate()

◆ addLevel()

◆ copy()

◆ create()

◆ delete()

◆ deleteLevel()

◆ fixLevelNumbering()

◆ getAllHistoricLevelEntriesOfUser()

◆ getAllLevelEntriesOfUser()

◆ getCommonSkillIdForImportId()

◆ getLastLevelPerObject()

◆ getLastUpdatePerObject()

◆ getLevelData()

◆ getLevelIdForImportId()

◆ getLevelIdForImportIdMatchSkill()

◆ getMaxLevel()

◆ getMaxLevelNr()

◆ getMaxLevelPerObject()

◆ getMaxLevelPerType()

◆ getNewAchievementsPerUser()

◆ getShortTitleForCertificate()

◆ getSkillForLevelId()

◆ getTitleForCertificate()

◆ getUsageInfo()

◆ hasRecentSelfEvaluation()

◆ hasSelfEvaluated()

◆ lookupLevelDescription()

◆ lookupLevelProperty()

◆ lookupLevelSkillId()

◆ lookupLevelTitle()

◆ read()

◆ removeAllUserData()

◆ removeAllUserSkillLevelStatusOfObject()

◆ resetUserSkillLevelStatus()

◆ updateLevelOrder()

◆ writeLevelDescription()

◆ writeLevelProperty()

◆ writeLevelTitle()

◆ writeUserSkillLevelStatus()

Field Documentation

◆ $db

◆ $id

◆ $user

◆ ACHIEVED

◆ EVAL_BY_ALL

◆ EVAL_BY_OTHERS_

◆ EVAL_BY_SELF

◆ NOT_ACHIEVED