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)
	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 1088 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 898 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 668 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 637 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 802 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 742 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 772 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 1052 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 703 of file class.ilBasicSkill.php.

References $ilDB, $ilUser, 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 598 of file class.ilBasicSkill.php.

References $ilDB, $ilUser, 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 1077 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 1012 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 1041 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 969 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 1064 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 1108 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 947 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`
	)

static

Write skill level status.

Parameters

int	skill level id
int	user id
int	status

Definition at line 477 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
                 {
                         $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) 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").
                                 ")");
                 }
 
                 // 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