Basic Skill. More...

Inheritance diagram for ilBasicSkill:

Collaboration diagram for ilBasicSkill:

Public Member Functions
	__construct ($a_id=0)
	Constructor 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)
	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...

	lookupLevelsForTriggerRefId ($a_ref_id)
	Lookup levels for trigger. 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...

	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...

	lookupLevelAchievementDate ($a_user_id, $a_level_id, $a_self_eval=0)
	Lookup level achievement date. More...

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

	getLevelTitleForCertificate ($a_level_id)
	Get title for certificate. More...

	getTriggerTitleForCertificate ($a_level_id)
	Get trigger title for certificate. More...

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

Public Member Functions inherited from ilSkillTreeNode
	ilSkillTreeNode ($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...

	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...

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

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

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

static	lookupLevelTrigger ($a_id)
	Lookup level trigger. 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	writeLevelTrigger ($a_id, $a_trigger_ref_id)
	Write trigger. More...

static	updateAllUserSkillLevels ()
	Look for all skill level that have a trigger and update the user skill level information, if it has changed. More...

static	updateSkillLevelsByTriggerRef ($a_user_id, $a_ref_id)
	Look for all skill level that have a trigger and update the user skill level information, if it has changed. 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=0, $a_unique_identifier="")
	Write skill level status. More...

static	getCompletionDateForTriggerRefId ($a_user_id, $a_ref_id=null, $a_self_eval=0)
	Get trigger completion. More...

static	checkUserCertificateForTriggerRefId ($a_user_id, $a_ref_id, $a_self_eval=0)
	Get trigger completion. More...

static	getTriggerOfAllCertificates ($a_user_id, $a_self_eval=0)
	Get trigger completion. More...

static	getSkillLevelsForTrigger ($a_ref_id)
	Get assigned skill levels for trigger. 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 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	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...

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 Protected Member Functions inherited from ilSkillTreeNode
static	_lookup ($a_obj_id, $a_field)
	Lookup Title. 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 public.

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

References ilSkillTreeNode\setType().

         {
                 parent::ilSkillTreeNode($a_id);
                 $this->setType("skll");
         }

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 1106 of file class.ilBasicSkill.php.

Referenced by checkUserCertificateForTriggerRefId(), and getTriggerOfAllCertificates().

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

Here is the caller graph for this function:

◆ addLevel()

ilBasicSkill::addLevel	(	$a_title,
		$a_description
	)

Add new level.

Parameters

string	title
string	description

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

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

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

Here is the call graph for this function:

◆ checkUserCertificateForTriggerRefId()

static ilBasicSkill::checkUserCertificateForTriggerRefId	(	$a_user_id,
		$a_ref_id,
		$a_self_eval = `0`
	)

static

Get trigger completion.

Parameters

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

References $ilDB, $ref_id, and _lookupCertificate().

Referenced by ilObjSkillManagementGUI\testCert().

         {
                 global $ilDB;
 die("ilBasicSkill::checkUserCertificateForTriggerRefId is deprecated.");
                 if (!is_array($a_ref_id))
                 {
                         $a_ref_id = array($a_ref_id);
                 }
                 if (!is_array($a_user_id))
                 {
                         $a_user_id = array($a_user_id);
                 }
                 $set = $ilDB->query($q = "SELECT user_id, status_date, trigger_ref_id, level_id, skill_id FROM skl_user_has_level WHERE ".
                         $ilDB->in("user_id", $a_user_id, false, "integer")." AND ".
                         $ilDB->in("trigger_ref_id", $a_ref_id, false, "integer")
                 );
 
                 $completion = array();
 
                 $completion = array();
                 while ($rec = $ilDB->fetchAssoc($set))
                 {
                         if (!isset($completion[$rec["user_id"]][$rec["trigger_ref_id"]])
                                 && ilBasicSkill::_lookupCertificate($rec["skill_id"], $rec["level_id"]))
                         {
                                 $completion[$rec["user_id"]][$rec["trigger_ref_id"]] = true;
                         }
                 }
 
                 foreach ($a_ref_id as $ref_id)
                 {
                         foreach ($a_user_id as $user_id)
                         {
                                 if (!isset($completion[$user_id][$ref_id]))
                                 {
                                         $completion[$user_id][$ref_id] = false;
                                 }
                         }
                 }
                 return $completion;
 
         }

Here is the call graph for this function:

Here is the caller graph for this function:

◆ copy()

ilBasicSkill::copy ( )

Copy basic skill.

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

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

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

Here is the call graph for this function:

◆ create()

ilBasicSkill::create ( )

Create skill.

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

         {
                 parent::create();
         }

◆ delete()

ilBasicSkill::delete ( )

Delete skill.

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

References $ilDB.

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

◆ deleteLevel()

ilBasicSkill::deleteLevel ( $a_id )

Delete level.

Parameters

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

References $ilDB.

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

◆ fixLevelNumbering()

ilBasicSkill::fixLevelNumbering ( )

Fix level numbering.

Parameters

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

References $ilDB.

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

◆ getAllHistoricLevelEntriesOfUser()

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

Get all historic level entries.

Parameters

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

References $ilDB, and $ilUser.

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

◆ getAllLevelEntriesOfUser()

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

Get all level entries.

Parameters

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

References $ilDB, and $ilUser.

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

◆ getCompletionDateForTriggerRefId()

static ilBasicSkill::getCompletionDateForTriggerRefId	(	$a_user_id,
		$a_ref_id = `null`,
		$a_self_eval = `0`
	)

static

Get trigger completion.

Parameters

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

References $ilDB, $ref_id, and ilParticipants\_getMembershipByType().

Referenced by ilObjSkillManagementGUI\test().

         {
                 global $ilDB;
 die("ilBasicSkill::getCompletionDateForTriggerRefId is deprecated.");
                 if ($a_ref_id == "")
                 {
                         $a_ref_id = null;
                 }
                 else if (!is_array($a_ref_id))
                 {
                         $a_ref_id = array($a_ref_id);
                 }
                 if (!is_array($a_user_id))
                 {
                         $a_user_id = array($a_user_id);
                 }
 
                 if ($a_ref_id != null)
                 {
                         if (!is_array($a_ref_id))
                         {
                                 $a_ref_id = array($a_ref_id);
                         }
 
                         $set = $ilDB->query($q = "SELECT user_id, status_date, trigger_ref_id FROM skl_user_has_level WHERE ".
                                 $ilDB->in("user_id", $a_user_id, false, "integer")." AND ".
                                 $ilDB->in("trigger_ref_id", $a_ref_id, false, "integer")
                         );
 
                         $completion = array();
                         while ($rec = $ilDB->fetchAssoc($set))
                         {
                                 if (!isset($completion[$rec["user_id"]][$rec["trigger_ref_id"]]))
                                 {
                                         $completion[$rec["user_id"]][$rec["trigger_ref_id"]] = $rec["status_date"];
                                 }
                                 else if ($rec["status_date"] < $completion[$rec["user_id"]][$rec["trigger_ref_id"]])
                                 {
                                         $completion[$rec["user_id"]][$rec["trigger_ref_id"]] = $rec["status_date"];
                                 }
                         }
 
                         foreach ($a_ref_id as $ref_id)
                         {
                                 foreach ($a_user_id as $user_id)
                                 {
                                         if (!isset($completion[$user_id][$ref_id]))
                                         {
                                                 $completion[$user_id][$ref_id] = false;
                                         }
                                 }
                         }
                 }
                 else
                 {
                         $completion = array();
                         foreach ($a_user_id as $user_id)
                         {
                                 include_once 'Services/Membership/classes/class.ilParticipants.php';
                                 $a_ref_id = ilParticipants::_getMembershipByType($user_id, 'crs', true);
 
                                 $set = $ilDB->query($q = "SELECT user_id, status_date, trigger_ref_id FROM skl_user_has_level WHERE ".
                                         "user_id = ".$ilDB->quote($user_id, "integer")." AND ".
                                         $ilDB->in("trigger_ref_id", $a_ref_id, false, "integer")
                                 );
 
                                 while ($rec = $ilDB->fetchAssoc($set))
                                 {
                                         if (!isset($completion[$user_id][$rec["trigger_ref_id"]]))
                                         {
                                                 $completion[$user_id][$rec["trigger_ref_id"]] = $rec["status_date"];
                                         }
                                         else if ($rec["status_date"] < $completion[$user_id][$rec["trigger_ref_id"]])
                                         {
                                                 $completion[$user_id][$rec["trigger_ref_id"]] = $rec["status_date"];
                                         }
                                 }
                                 foreach ($a_ref_id as $ref_id)
                                 {
                                         if (!isset($completion[$user_id][$ref_id]))
                                         {
                                                 $completion[$user_id][$ref_id] = false;
                                         }
                                 }
                         }
                         
                 }
                 return $completion;
         }

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

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

References $ilDB, $ilUser, and ilSkillTreeNode\getId().

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

Here is the call graph for this function:

◆ getLastUpdatePerObject()

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

Get last update per object.

Parameters

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

References $ilDB, $ilUser, and ilSkillTreeNode\getId().

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

Here is the call graph for this function:

◆ getLevelData()

ilBasicSkill::getLevelData ( $a_id = 0 )

Get level data.

Returns: array level data

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

References $ilDB.

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

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

Here is the caller graph for this function:

◆ getLevelTitleForCertificate()

ilBasicSkill::getLevelTitleForCertificate ( $a_level_id )

Get title for certificate.

Parameters

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

References lookupLevelTitle().

         {
 die("ilBasicSkill::getLevelTitleForCertificate is deprecated.");
                 return ilBasicSkill::lookupLevelTitle($a_level_id);
         }

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 130 of file class.ilBasicSkill.php.

References $ilDB.

Referenced by addLevel().

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

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

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

References $ilDB, $ilUser, $l, ilSkillTreeNode\getId(), and getLevelData().

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

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

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

References $ilDB, $ilUser, $l, ilSkillTreeNode\getId(), and getLevelData().

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

Here is the call graph for this function:

◆ getShortTitleForCertificate()

ilBasicSkill::getShortTitleForCertificate ( )

Get short title for certificate.

Parameters

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

         {
                 return "Skill";
         }

◆ getSkillForLevelId()

ilBasicSkill::getSkillForLevelId ( $a_level_id )

Get skill for level id.

Parameters

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

References $ilDB, and ilSkillTreeNode\isInTree().

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

Here is the call graph for this function:

◆ getSkillLevelsForTrigger()

static ilBasicSkill::getSkillLevelsForTrigger ( $a_ref_id )

static

Get assigned skill levels for trigger.

Parameters

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

References $ilDB.

Referenced by ilObjSkillManagementGUI\testLevels().

         {
                 global $ilDB;
 die("ilBasicSkill::getSkillLevelsForTrigger is deprecated.");
                 $set = $ilDB->query($q = "SELECT id FROM skl_level".
                         " WHERE trigger_ref_id = ".$ilDB->quote($a_ref_id, "integer"));
 
                 $skill_levels = array();
                 while ($rec = $ilDB->fetchAssoc($set))
                 {
                         $skill_levels[] = $rec["id"];
                 }
 
                 return $skill_levels;
 
         }

Here is the caller graph for this function:

◆ getTitleForCertificate()

ilBasicSkill::getTitleForCertificate ( )

Get title for certificate.

Parameters

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

References ilSkillTreeNode\getTitle().

         {
                 return $this->getTitle();
         }

Here is the call graph for this function:

◆ getTriggerOfAllCertificates()

static ilBasicSkill::getTriggerOfAllCertificates	(	$a_user_id,
		$a_self_eval = `0`
	)

static

Get trigger completion.

Parameters

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

References $ilDB, and _lookupCertificate().

Referenced by ilObjSkillManagementGUI\testAllCert().

         {
                 global $ilDB, $tree;
 die("ilBasicSkill::getTriggerOfAllCertificates is deprecated.");
                 if (!is_array($a_user_id))
                 {
                         $a_user_id = array($a_user_id);
                 }
 
                 $set = $ilDB->query($q = "SELECT user_id, status_date, trigger_ref_id, level_id, skill_id FROM skl_user_has_level WHERE ".
                         $ilDB->in("user_id", $a_user_id, false, "integer")
                 );
 
                 $completion = array();
 
                 while ($rec = $ilDB->fetchAssoc($set))
                 {
                         if ((!is_array($completion[$rec["user_id"]]) || !in_array($rec["trigger_ref_id"], $completion[$rec["user_id"]]))
                                 && ilBasicSkill::_lookupCertificate($rec["skill_id"], $rec["level_id"]))
                         {
                                 if ($tree->isInTree($rec["trigger_ref_id"]))
                                 {
                                         $completion[$rec["user_id"]][] = $rec["trigger_ref_id"];
                                 }
                         }
                 }
 
                 foreach ($a_user_id as $user_id)
                 {
                         if (!is_array($completion[$user_id]))
                         {
                                 $completion[$user_id] = array();
                         }
                 }
                 return $completion;
         }

Here is the call graph for this function:

Here is the caller graph for this function:

◆ getTriggerTitleForCertificate()

ilBasicSkill::getTriggerTitleForCertificate ( $a_level_id )

Get trigger title for certificate.

Parameters

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

References ilObject\_lookupTitle(), and lookupLevelTrigger().

         {
 die("ilBasicSkill::getTriggerTitleForCertificate is deprecated.");
                 $tr = ilBasicSkill::lookupLevelTrigger($a_level_id);
                 return ilObject::_lookupTitle($tr["obj_id"]);
         }

Here is the call graph for this function:

◆ getUsageInfo()

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

static

Get usage info.

Parameters

Implements ilSkillUsageInfo.

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

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

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

Here is the call graph for this function:

◆ lookupLevelAchievementDate()

ilBasicSkill::lookupLevelAchievementDate	(	$a_user_id,
		$a_level_id,
		$a_self_eval = `0`
	)

Lookup level achievement date.

Parameters

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

References $ilDB.

Referenced by ilSkillCertificateAdapter\getCertificateVariablesForPresentation().

         {
                 global $ilDB;
 die("ilBasicSkill::lookupLevelAchievementDate is deprecated.");
                 $set = $ilDB->query("SELECT user_id, status_date, trigger_ref_id, level_id, skill_id FROM skl_user_has_level WHERE ".
                         " user_id = ".$ilDB->quote($a_user_id, "integer").
                         " AND user_id = ".$ilDB->quote($a_user_id, "integer")
                 );
                 if ($rec = $ilDB->fetchAssoc($set))
                 {
                         return $rec["status_date"];
                 }
 
                 return false;
         }

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 206 of file class.ilBasicSkill.php.

References lookupLevelProperty().

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

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 178 of file class.ilBasicSkill.php.

References $ilDB.

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

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

Here is the caller graph for this function:

◆ lookupLevelsForTriggerRefId()

ilBasicSkill::lookupLevelsForTriggerRefId ( $a_ref_id )

Lookup levels for trigger.

Parameters

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

References $ilDB.

         {
                 global $ilDB;
 die("ilBasicSkill::lookupLevelsForTriggerRefId is deprecated.");
                 $set = $ilDB->query("SELECT id FROM skl_level WHERE ".
                         " trigger_ref_id = ".$ilDB->quote($a_ref_id, "integer")
                         );
                 $levels = array();
                 while ($rec = $ilDB->fetchAssoc($set))
                 {
                         $levels[] = $rec["id"];
                 }
                 return $levels;
         }

◆ lookupLevelSkillId()

static ilBasicSkill::lookupLevelSkillId ( $a_id )

static

Lookup level skill id.

Parameters

int level id

Returns: string skill id

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

References lookupLevelProperty().

Referenced by writeUserSkillLevelStatus().

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

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 195 of file class.ilBasicSkill.php.

References lookupLevelProperty().

Referenced by ilSkillProfileGUI\confirmLevelAssignmentRemoval(), ilBasicSkillGUI\confirmLevelDeletion(), ilSkillProfileLevelsTableGUI\fillRow(), getLevelTitleForCertificate(), ilPersonalSkillsGUI\renderSuggestedResources(), ilBasicSkillTemplateGUI\setLevelHead(), and ilBasicSkillGUI\setLevelHead().

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

Here is the call graph for this function:

Here is the caller graph for this function:

◆ lookupLevelTrigger()

static ilBasicSkill::lookupLevelTrigger ( $a_id )

static

Lookup level trigger.

Parameters

int level id

Returns: array trigger ref id and obj id

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

References $ref_id, and lookupLevelProperty().

Referenced by ilBasicSkillGUI\editLevelTrigger(), and getTriggerTitleForCertificate().

         {
 die("ilBasicSkill::lookupLevelTrigger is deprecated.");
                 $ref_id = ilBasicSkill::lookupLevelProperty($a_id, "trigger_ref_id");
                 $obj_id = ilBasicSkill::lookupLevelProperty($a_id, "trigger_obj_id");
                 return array("ref_id" => $ref_id, "obj_id" => $obj_id);
         }

Here is the call graph for this function:

Here is the caller graph for this function:

◆ read()

ilBasicSkill::read ( )

Read data from database.

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

         {
                 parent::read();
         }

◆ updateAllUserSkillLevels()

static ilBasicSkill::updateAllUserSkillLevels ( )

static

Look for all skill level that have a trigger and update the user skill level information, if it has changed.

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

References $ilDB, ilObject\_hasUntrashedReference(), ilLPStatusWrapper\_lookupCompletedForObject(), ACHIEVED, and writeUserSkillLevelStatus().

         {
                 global $ilDB;
 die("ilBasicSkill::updateAllUserSkillLevels is deprecated.");
                 $set = $ilDB->query("SELECT id, trigger_obj_id FROM skl_level WHERE ".
                         " trigger_obj_id > ".$ilDB->quote(0, "integer")
                 );
                 while ($rec = $ilDB->fetchAssoc($set))          // all trigger objects
                 {
                         $skill_level_id = $rec["id"];
                         $tr_obj_id = $rec["trigger_obj_id"];
 
                         if (ilObject::_hasUntrashedReference($tr_obj_id))
                         {
                                 include_once("./Services/Tracking/classes/class.ilLPStatusWrapper.php");
                                 $completed = ilLPStatusWrapper::_lookupCompletedForObject($tr_obj_id);
                                 foreach ($completed as $user_id)
                                 {
                                         ilBasicSkill::writeUserSkillLevelStatus($skill_level_id,
                                                 $user_id, ilBasicSkill::ACHIEVED);
                                 }
                         }
                 }
         }

Here is the call graph for this function:

◆ updateLevelOrder()

ilBasicSkill::updateLevelOrder ( $order )

Update level order.

Parameters

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

References $ilDB.

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

◆ updateSkillLevelsByTriggerRef()

static ilBasicSkill::updateSkillLevelsByTriggerRef	(	$a_user_id,
		$a_ref_id
	)

static

Look for all skill level that have a trigger and update the user skill level information, if it has changed.

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

References $ilDB, ilObject\_hasUntrashedReference(), ilLPStatusWrapper\_lookupCompletedForObject(), ACHIEVED, and writeUserSkillLevelStatus().

         {
                 global $ilDB;
 die("ilBasicSkill::updateSkillLevelsByTriggerRef is deprecated.");
                 $set = $ilDB->query("SELECT id, trigger_obj_id FROM skl_level WHERE ".
                         " trigger_ref_id = ".$ilDB->quote($a_ref_id, "integer")
                 );
                 while ($rec = $ilDB->fetchAssoc($set))          // all trigger objects
                 {
                         $skill_level_id = $rec["id"];
                         $tr_obj_id = $rec["trigger_obj_id"];
 
                         if (ilObject::_hasUntrashedReference($tr_obj_id))
                         {
                                 include_once("./Services/Tracking/classes/class.ilLPStatusWrapper.php");
                                 $completed = ilLPStatusWrapper::_lookupCompletedForObject($tr_obj_id);
                                 foreach ($completed as $user_id)
                                 {
                                         if ($a_user_id == $user_id)
                                         {
                                                 ilBasicSkill::writeUserSkillLevelStatus($skill_level_id,
                                                         $user_id, ilBasicSkill::ACHIEVED);
                                         }
                                 }
                         }
                 }
         }

Here is the call graph for this function:

◆ writeLevelDescription()

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

static

Write level description.

Parameters

int	level id
text	level description

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

References writeLevelProperty().

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

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

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

References $ilDB.

Referenced by writeLevelDescription(), writeLevelTitle(), and writeLevelTrigger().

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

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 259 of file class.ilBasicSkill.php.

References writeLevelProperty().

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

Here is the call graph for this function:

◆ writeLevelTrigger()

static ilBasicSkill::writeLevelTrigger	(	$a_id,
		$a_trigger_ref_id
	)

static

Write trigger.

Parameters

int	level id
text	level description

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

References ilObject\_lookupObjId(), and writeLevelProperty().

Referenced by ilBasicSkillGUI\removeLevelTrigger(), and ilBasicSkillGUI\saveLevelTrigger().

         {
 die("ilBasicSkill::writeLevelTrigger is deprecated.");
                 $a_trigger_obj_id = 0;
                 if ($a_trigger_ref_id > 0)
                 {
                         $a_trigger_obj_id = ilObject::_lookupObjId($a_trigger_ref_id);
                 }
                 ilBasicSkill::writeLevelProperty($a_id, "trigger_ref_id", $a_trigger_ref_id, "integer");
                 ilBasicSkill::writeLevelProperty($a_id, "trigger_obj_id", $a_trigger_obj_id, "integer");
         }

Here is the call graph for this function:

Here is the caller 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 = `0`,
		$a_unique_identifier = `""`
	)

static

Write skill level status.

Parameters

int	skill level id
int	user id
int	status
string	any unique identifier set from the outside, if records for skill_id-tref_id-user_id-trigger_ref_id-self_eval-unique_identifier already exist the are removed from the history and the new entry is added The unique identifier is "unique per trigger object" not globally.

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

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

Referenced by ilTestSkillEvaluation\invokeSkillLevelTrigger(), ilPersonalSkill\saveSelfEvaluation(), updateAllUserSkillLevels(), updateSkillLevelsByTriggerRef(), ilSurveySkill\writeAppraiseeSkills(), and ilSurveySkillDeterminationGUI\writeSkills().

         {
                 global $ilDB;
 
                 $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;
 
                         // check whether current skill user level is identical
                         // to the one that should be set (-> no change required)
 /*                      $ilDB->setLimit(1);
                         $set = $ilDB->query("SELECT status, valid FROM skl_user_skill_level WHERE ".
                                 "level_id = ".$ilDB->quote($a_level_id, "integer")." AND ".
                                 "user_id = ".$ilDB->quote($a_user_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").
                                 " ORDER BY status_date DESC"
                         );
                         $rec = $ilDB->fetchAssoc($set);
                         if (!$rec["valid"] || $rec["status"] != $a_status)
                         {
                                 $save = true;
                         }*/
 
                 if ($a_self_eval)
                 {
                         $ilDB->setLimit(1);
                         $set = $ilDB->query("SELECT * FROM skl_user_skill_level WHERE ".
                                 "skill_id = ".$ilDB->quote($skill_id, "integer")." AND ".
                                 "user_id = ".$ilDB->quote($a_user_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").
                                 " ORDER BY status_date DESC"
                         );
                         $rec = $ilDB->fetchAssoc($set);
                         $status_day = substr($rec["status_date"], 0, 10);
                         $today = substr(ilUtil::now(), 0, 10);
                         if ($rec["valid"] && $rec["status"] == $a_status && $status_day == $today)
                         {
                                 $update = true;
                         }
                 }
 
                 if ($update)
                 {
                         $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($rec["status_date"], "timestamp").
                                 " AND skill_id = ".$ilDB->quote($rec["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").
                         ")");
                 }
         }

Here is the call graph for this function:

Here is the caller graph for this function:

Field Documentation

◆ $id

ilBasicSkill::$id

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

◆ ACHIEVED

const ilBasicSkill::ACHIEVED = 1

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

Referenced by ilTestSkillEvaluation\invokeSkillLevelTrigger(), ilPersonalSkill\saveSelfEvaluation(), updateAllUserSkillLevels(), updateSkillLevelsByTriggerRef(), ilSurveySkill\writeAppraiseeSkills(), ilSurveySkillDeterminationGUI\writeSkills(), and writeUserSkillLevelStatus().

◆ EVAL_BY_ALL

const ilBasicSkill::EVAL_BY_ALL = 2

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

Referenced by ilPersonalSkillsGUI\getSkillHTML().

◆ EVAL_BY_OTHERS_

const ilBasicSkill::EVAL_BY_OTHERS_ = 0

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

◆ EVAL_BY_SELF

const ilBasicSkill::EVAL_BY_SELF = 1

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

◆ NOT_ACHIEVED

const ilBasicSkill::NOT_ACHIEVED = 0

Definition at line 19 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

Detailed Description

Constructor & Destructor Documentation

◆ __construct()

Member Function Documentation

◆ _lookupCertificate()

◆ addLevel()

◆ checkUserCertificateForTriggerRefId()

◆ copy()

◆ create()

◆ delete()

◆ deleteLevel()

◆ fixLevelNumbering()

◆ getAllHistoricLevelEntriesOfUser()

◆ getAllLevelEntriesOfUser()

◆ getCompletionDateForTriggerRefId()

◆ getLastLevelPerObject()

◆ getLastUpdatePerObject()

◆ getLevelData()

◆ getLevelTitleForCertificate()

◆ getMaxLevelNr()

◆ getMaxLevelPerObject()

◆ getMaxLevelPerType()

◆ getShortTitleForCertificate()

◆ getSkillForLevelId()

◆ getSkillLevelsForTrigger()

◆ getTitleForCertificate()

◆ getTriggerOfAllCertificates()

◆ getTriggerTitleForCertificate()

◆ getUsageInfo()

◆ lookupLevelAchievementDate()

◆ lookupLevelDescription()

◆ lookupLevelProperty()

◆ lookupLevelsForTriggerRefId()

◆ lookupLevelSkillId()

◆ lookupLevelTitle()

◆ lookupLevelTrigger()

◆ read()

◆ updateAllUserSkillLevels()

◆ updateLevelOrder()

◆ updateSkillLevelsByTriggerRef()

◆ writeLevelDescription()

◆ writeLevelProperty()

◆ writeLevelTitle()

◆ writeLevelTrigger()

◆ writeUserSkillLevelStatus()

Field Documentation

◆ $id

◆ ACHIEVED

◆ EVAL_BY_ALL

◆ EVAL_BY_OTHERS_

◆ EVAL_BY_SELF

◆ NOT_ACHIEVED