Skill profile. More...

Inheritance diagram for ilSkillProfile:

Collaboration diagram for ilSkillProfile:

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

	setId ($a_val)
	Set id. More...

	getId ()
	Get id. More...

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

	getTitle ()
	Get title. More...

	setDescription ($a_val)
	Set description. More...

	getDescription ()
	Get description. More...

	addSkillLevel ($a_base_skill_id, $a_tref_id, $a_level_id)
	Add skill level. More...

	removeSkillLevel ($a_base_skill_id, $a_tref_id, $a_level_id)
	Remove skill level. More...

	getSkillLevels ()
	Get skill levels. More...

	read ()
	Read skill profile from db. More...

	create ()
	Create skill profile. More...

	update ()
	Update skill profile. More...

	delete ()
	Delete skill profile. More...

	getAssignedUsers ()
	Get assigned users. More...

	addUserToProfile ($a_user_id)
	Add user to profile. More...

	removeUserFromProfile ($a_user_id)
	Remove user from profile. More...

Static Public Member Functions
static	getProfiles ()
	Get profiles. More...

static	lookupTitle ($a_id)
	Lookup title. More...

static	removeUserFromAllProfiles ($a_user_id)
	Remove user from all profiles. More...

static	getProfilesOfUser ($a_user_id)
	Get profiles of a user. More...

static	countUsers ($a_profile_id)
	Get assigned users. More...

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

Static Protected Member Functions
static	lookup ($a_id, $a_field)
	Lookup. More...

Protected Attributes
	$db

	$id

	$title

	$description

	$skill_level = array()

Detailed Description

Skill profile.

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

Version: $Id$ /

Definition at line 14 of file class.ilSkillProfile.php.

Constructor & Destructor Documentation

◆ __construct()

ilSkillProfile::__construct ( $a_id = 0 )

Constructor.

Parameters

int $a_id profile id

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

References $DIC, read(), and setId().

     {
         global $DIC;
 
         $this->db = $DIC->database();
         if ($a_id > 0) {
             $this->setId($a_id);
             $this->read();
         }
     }

Here is the call graph for this function:

Member Function Documentation

◆ addSkillLevel()

ilSkillProfile::addSkillLevel	(	$a_base_skill_id,
		$a_tref_id,
		$a_level_id
	)

Add skill level.

Parameters

Definition at line 108 of file class.ilSkillProfile.php.

Referenced by read().

     {
         //echo "-".$a_base_skill_id."-";
         $this->skill_level[] = array(
             "base_skill_id" => $a_base_skill_id,
             "tref_id" => $a_tref_id,
             "level_id" => $a_level_id
             );
     }

Here is the caller graph for this function:

◆ addUserToProfile()

ilSkillProfile::addUserToProfile ( $a_user_id )

Add user to profile.

Parameters

int $a_user_id user id

Definition at line 368 of file class.ilSkillProfile.php.

References $db, $ilDB, and getId().

     {
         $ilDB = $this->db;
         
         $ilDB->replace(
             "skl_profile_user",
             array("profile_id" => array("integer", $this->getId()),
                 "user_id" => array("integer", (int) $a_user_id),
                 ),
             array()
         );
     }

Here is the call graph for this function:

◆ countUsers()

static ilSkillProfile::countUsers ( $a_profile_id )

static

Get assigned users.

Definition at line 441 of file class.ilSkillProfile.php.

References $DIC, and $ilDB.

Referenced by ilSkillProfileTableGUI\fillRow().

     {
         global $DIC;
 
         $ilDB = $DIC->database();
         
         $set = $ilDB->query(
             "SELECT count(*) ucnt FROM skl_profile_user " .
             " WHERE profile_id = " . $ilDB->quote($a_profile_id, "integer")
         );
         $rec = $ilDB->fetchAssoc($set);
         return (int) $rec["ucnt"];
     }

Here is the caller graph for this function:

◆ create()

ilSkillProfile::create ( )

Create skill profile.

Definition at line 180 of file class.ilSkillProfile.php.

References $db, $ilDB, getId(), and setId().

     {
         $ilDB = $this->db;
         
         // profile
         $this->setId($ilDB->nextId("skl_profile"));
         $ilDB->manipulate("INSERT INTO skl_profile " .
             "(id, title, description) VALUES (" .
             $ilDB->quote($this->getId(), "integer") . "," .
             $ilDB->quote($this->getTitle(), "text") . "," .
             $ilDB->quote($this->getDescription(), "text") .
             ")");
         
         // profile levels
         foreach ($this->skill_level as $level) {
             $ilDB->replace(
                 "skl_profile_level",
                 array("profile_id" => array("integer", $this->getId()),
                     "tref_id" => array("integer", (int) $level["tref_id"]),
                     "base_skill_id" => array("integer", (int) $level["base_skill_id"])
                     ),
                 array("level_id" => array("integer", (int) $level["level_id"]))
             );
         }
     }

Here is the call graph for this function:

◆ delete()

ilSkillProfile::delete ( )

Delete skill profile.

Definition at line 249 of file class.ilSkillProfile.php.

References $db, and $ilDB.

     {
         $ilDB = $this->db;
 
         // TODO: Split the deletions when refactoring to repository pattern
         
         // profile levels
         $ilDB->manipulate(
             "DELETE FROM skl_profile_level WHERE " .
             " profile_id = " . $ilDB->quote($this->getId(), "integer")
         );
 
         // profile users
         $ilDB->manipulate(
             "DELETE FROM skl_profile_user WHERE " .
             " profile_id = " . $ilDB->quote($this->getId(), "integer")
         );
 
         // profile roles
         $ilDB->manipulate(
             "DELETE FROM skl_profile_role WHERE " .
             " profile_id = " . $ilDB->quote($this->getId(), "integer")
         );
         
         // profile
         $ilDB->manipulate(
             "DELETE FROM skl_profile WHERE " .
             " id = " . $ilDB->quote($this->getId(), "integer")
         );
     }

◆ getAssignedUsers()

ilSkillProfile::getAssignedUsers ( )

Get assigned users.

Definition at line 342 of file class.ilSkillProfile.php.

References $db, $ilDB, $name, $users, and ilObjUser\_lookupName().

     {
         $ilDB = $this->db;
         
         $set = $ilDB->query(
             "SELECT * FROM skl_profile_user " .
             " WHERE profile_id = " . $ilDB->quote($this->getId(), "integer")
         );
         $users = array();
         while ($rec = $ilDB->fetchAssoc($set)) {
             $name = ilObjUser::_lookupName($rec["user_id"]);
             $users[$rec["user_id"]] = array(
                 "lastname" => $name["lastname"],
                 "firstname" => $name["firstname"],
                 "login" => $name["login"],
                 "id" => $name["user_id"]
                 );
         }
         return $users;
     }

Here is the call graph for this function:

◆ getDescription()

ilSkillProfile::getDescription ( )

Get description.

Returns: string description

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

References $description.

     {
         return $this->description;
     }

◆ getId()

ilSkillProfile::getId ( )

Get id.

Returns: int id

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

References $id.

Referenced by addUserToProfile(), create(), and update().

     {
         return $this->id;
     }

Here is the caller graph for this function:

◆ getProfiles()

static ilSkillProfile::getProfiles ( )

static

Get profiles.

Parameters

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

References $DIC, and $ilDB.

Referenced by ilSkillProfileTableGUI\getProfiles().

     {
         global $DIC;
 
         $ilDB = $DIC->database();
         
         $set = $ilDB->query(
             "SELECT * FROM skl_profile " .
             " ORDER BY title "
         );
         $profiles = array();
         while ($rec = $ilDB->fetchAssoc($set)) {
             $profiles[$rec["id"]] = $rec;
         }
         
         return $profiles;
     }

Here is the caller graph for this function:

◆ getProfilesOfUser()

static ilSkillProfile::getProfilesOfUser ( $a_user_id )

static

Get profiles of a user.

Parameters

int $a_user_id user id

Definition at line 419 of file class.ilSkillProfile.php.

References $DIC, and $ilDB.

Referenced by ilPersonalSkillsGUI\__construct(), ilSurveyEvaluationGUI\competenceEval(), and ilTestSkillEvaluation\getAssignedSkillMatchingSkillProfiles().

     {
         global $DIC;
 
         $ilDB = $DIC->database();
         
         $profiles = array();
         $set = $ilDB->query(
             "SELECT p.id, p.title FROM skl_profile_user u JOIN skl_profile p " .
             " ON (u.profile_id = p.id) " .
             " WHERE user_id = " . $ilDB->quote($a_user_id, "integer") .
             " ORDER BY p.title ASC"
         );
         while ($rec = $ilDB->fetchAssoc($set)) {
             $profiles[] = $rec;
         }
         return $profiles;
     }

Here is the caller graph for this function:

◆ getSkillLevels()

ilSkillProfile::getSkillLevels ( )

Get skill levels.

Parameters

Definition at line 141 of file class.ilSkillProfile.php.

References $skill_level.

     {
         return $this->skill_level;
     }

◆ getTitle()

ilSkillProfile::getTitle ( )

Get title.

Returns: string title

Definition at line 77 of file class.ilSkillProfile.php.

References $title.

     {
         return $this->title;
     }

◆ getUsageInfo()

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

static

Get usage info.

Parameters

Implements ilSkillUsageInfo.

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

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

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

Here is the call graph for this function:

◆ lookup()

static ilSkillProfile::lookup	(	$a_id,
		$a_field
	)

staticprotected

Lookup.

Parameters

Definition at line 310 of file class.ilSkillProfile.php.

References $DIC, and $ilDB.

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

◆ lookupTitle()

static ilSkillProfile::lookupTitle ( $a_id )

static

Lookup title.

Parameters

Definition at line 330 of file class.ilSkillProfile.php.

Referenced by ilSkillProfileGUI\confirmDeleteProfiles().

     {
         return self::lookup($a_id, "title");
     }

Here is the caller graph for this function:

◆ read()

ilSkillProfile::read ( )

Read skill profile from db.

Parameters

Definition at line 152 of file class.ilSkillProfile.php.

References $db, $ilDB, addSkillLevel(), setDescription(), and setTitle().

Referenced by __construct().

     {
         $ilDB = $this->db;
         
         $set = $ilDB->query(
             "SELECT * FROM skl_profile " .
             " WHERE id = " . $ilDB->quote($this->getId(), "integer")
         );
         $rec = $ilDB->fetchAssoc($set);
         $this->setTitle($rec["title"]);
         $this->setDescription($rec["description"]);
         
         $set = $ilDB->query(
             "SELECT * FROM skl_profile_level " .
             " WHERE profile_id = " . $ilDB->quote($this->getId(), "integer")
         );
         while ($rec = $ilDB->fetchAssoc($set)) {
             $this->addSkillLevel(
                 (int) $rec["base_skill_id"],
                 (int) $rec["tref_id"],
                 (int) $rec["level_id"]
             );
         }
     }

Here is the call graph for this function:

Here is the caller graph for this function:

◆ removeSkillLevel()

ilSkillProfile::removeSkillLevel	(	$a_base_skill_id,
		$a_tref_id,
		$a_level_id
	)

Remove skill level.

Parameters

Definition at line 124 of file class.ilSkillProfile.php.

     {
         foreach ($this->skill_level as $k => $sl) {
             if ((int) $sl["base_skill_id"] == (int) $a_base_skill_id &&
                 (int) $sl["tref_id"] == (int) $a_tref_id &&
                 (int) $sl["level_id"] == (int) $a_level_id) {
                 unset($this->skill_level[$k]);
             }
         }
     }

◆ removeUserFromAllProfiles()

static ilSkillProfile::removeUserFromAllProfiles ( $a_user_id )

static

Remove user from all profiles.

Parameters

int $a_user_id

Definition at line 402 of file class.ilSkillProfile.php.

References $DIC, and $ilDB.

Referenced by ilSkillObjDeletionHandler\processDeletion().

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

Here is the caller graph for this function:

◆ removeUserFromProfile()

ilSkillProfile::removeUserFromProfile ( $a_user_id )

Remove user from profile.

Parameters

int $a_user_id user id

Definition at line 386 of file class.ilSkillProfile.php.

References $db, and $ilDB.

     {
         $ilDB = $this->db;
         
         $ilDB->manipulate(
             "DELETE FROM skl_profile_user WHERE " .
             " profile_id = " . $ilDB->quote($this->getId(), "integer") .
             " AND user_id = " . $ilDB->quote($a_user_id, "integer")
         );
     }

◆ setDescription()

ilSkillProfile::setDescription ( $a_val )

Set description.

Parameters

string $a_val description

Definition at line 87 of file class.ilSkillProfile.php.

Referenced by read().

     {
         $this->description = $a_val;
     }

Here is the caller graph for this function:

◆ setId()

ilSkillProfile::setId ( $a_val )

Set id.

Parameters

int $a_val id

Definition at line 47 of file class.ilSkillProfile.php.

Referenced by __construct(), and create().

     {
         $this->id = $a_val;
     }

Here is the caller graph for this function:

◆ setTitle()

ilSkillProfile::setTitle ( $a_val )

Set title.

Parameters

string $a_val title

Definition at line 67 of file class.ilSkillProfile.php.

Referenced by read().

     {
         $this->title = $a_val;
     }

Here is the caller graph for this function:

◆ update()

ilSkillProfile::update ( )

Update skill profile.

Definition at line 209 of file class.ilSkillProfile.php.

References $db, $ilDB, and getId().

     {
         $ilDB = $this->db;
         
         // profile
         $ilDB->manipulate(
             "UPDATE skl_profile SET " .
             " title = " . $ilDB->quote($this->getTitle(), "text") . "," .
             " description = " . $ilDB->quote($this->getDescription(), "text") .
             " WHERE id = " . $ilDB->quote($this->getId(), "integer")
         );
         
         // profile levels
         $ilDB->manipulate(
             "DELETE FROM skl_profile_level WHERE " .
             " profile_id = " . $ilDB->quote($this->getId(), "integer")
         );
         foreach ($this->skill_level as $level) {
             $ilDB->replace(
                 "skl_profile_level",
                 array("profile_id" => array("integer", $this->getId()),
                     "tref_id" => array("integer", (int) $level["tref_id"]),
                     "base_skill_id" => array("integer", (int) $level["base_skill_id"])
                     ),
                 array("level_id" => array("integer", (int) $level["level_id"]))
             );
             
             /*$ilDB->manipulate("INSERT INTO skl_profile_level ".
                 "(profile_id, base_skill_id, tref_id, level_id) VALUES (".
                 $ilDB->quote($this->getId(), "integer").",".
                 $ilDB->quote((int) $level["base_skill_id"], "integer").",".
                 $ilDB->quote((int) $level["tref_id"], "integer").",".
                 $ilDB->quote((int) $level["level_id"], "integer").
                 ")");*/
         }
     }

Here is the call graph for this function:

Field Documentation

◆ $db

ilSkillProfile::$db

protected

Definition at line 19 of file class.ilSkillProfile.php.

Referenced by addUserToProfile(), create(), delete(), getAssignedUsers(), read(), removeUserFromProfile(), and update().

◆ $description

ilSkillProfile::$description

protected

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

Referenced by getDescription().

◆ $id

ilSkillProfile::$id

protected

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

Referenced by getId().

◆ $skill_level

ilSkillProfile::$skill_level = array()

protected

Definition at line 24 of file class.ilSkillProfile.php.

Referenced by getSkillLevels().

◆ $title

ilSkillProfile::$title

protected

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

Referenced by getTitle().

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

Services/Skill/classes/class.ilSkillProfile.php

Public Member Functions

Static Public Member Functions

Static Protected Member Functions

Protected Attributes

Detailed Description

Constructor & Destructor Documentation

◆ __construct()

Member Function Documentation

◆ addSkillLevel()

◆ addUserToProfile()

◆ countUsers()

◆ create()

◆ delete()

◆ getAssignedUsers()

◆ getDescription()

◆ getId()

◆ getProfiles()

◆ getProfilesOfUser()

◆ getSkillLevels()

◆ getTitle()

◆ getUsageInfo()

◆ lookup()

◆ lookupTitle()

◆ read()

◆ removeSkillLevel()

◆ removeUserFromAllProfiles()

◆ removeUserFromProfile()

◆ setDescription()

◆ setId()

◆ setTitle()

◆ update()

Field Documentation

◆ $db

◆ $description

◆ $id

◆ $skill_level

◆ $title