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

	setRefId ($a_val)

	getRefId ()

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

	removeSkillLevel ($a_base_skill_id, $a_tref_id, $a_level_id, $a_order_nr)
	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...

	updateSkillOrder (array $order)
	Update skill order. More...

	fixSkillOrderNumbering ()
	Fix skill order numbering. More...

	getMaxLevelOrderNr ()
	Get maximum order number of levels. More...

	updateRefIdAfterImport (int $a_new_ref_id)
	Update the old ref id with the new ref id after import. More...

	getAssignments ()
	Get all assignments (users and roles) More...

	getAssignedUsers ()
	Get assigned users. More...

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

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

	getAssignedRoles ()
	Get assigned roles. More...

	addRoleToProfile (int $a_role_id)
	Add role to profile. More...

	removeRoleFromProfile (int $a_role_id)
	Remove role from profile. More...

Static Public Member Functions
static	deleteProfilesFromObject (int $a_ref_id)

static	getProfiles ()
	Get profiles. More...

static	getGlobalProfiles ()
	Get global profiles. More...

static	getLocalProfiles (int $a_ref_id)
	Get local profiles of object. More...

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

static	lookupRefId ($a_id)

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	removeRoleFromAllProfiles (int $a_role_id)
	Remove role from all profiles. More...

static	getAllProfilesOfRole (int $a_role_id)
	Get global and local profiles of a role. More...

static	getGlobalProfilesOfRole (int $a_role_id)
	Get global profiles of a role. More...

static	getLocalProfilesOfRole (int $a_role_id, int $a_ref_id)
	Get local profiles of a role. More...

static	countRoles (int $a_profile_id)
	Count assigned roles of a profile. 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

	$lng

	$review

	$id

	$title

	$description

	$ref_id = 0

	$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

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

Constructor & Destructor Documentation

◆ __construct()

ilSkillProfile::__construct ( $a_id = 0 )

Constructor.

Parameters

int $a_id profile id

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

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

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

Here is the call graph for this function:

Member Function Documentation

◆ addRoleToProfile()

ilSkillProfile::addRoleToProfile ( int $a_role_id )

Add role to profile.

Parameters

int $a_role_id role id

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

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

     {
         $ilDB = $this->db;
 
         $ilDB->replace(
             "skl_profile_role",
             array("profile_id" => array("integer", $this->getId()),
                 "role_id" => array("integer", (int) $a_role_id),
             ),
             array()
         );
     }

Here is the call graph for this function:

◆ addSkillLevel()

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

Add skill level.

Parameters

Definition at line 133 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,
             "order_nr" => $a_order_nr
             );
     }

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 574 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:

◆ countRoles()

static ilSkillProfile::countRoles ( int $a_profile_id )

static

Count assigned roles of a profile.

Parameters

int $a_profile_id

Returns: int

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

References $DIC, and $ilDB.

Referenced by ilSkillProfileTableGUI\fillRow().

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

Here is the caller graph for this function:

◆ countUsers()

static ilSkillProfile::countUsers ( $a_profile_id )

static

Get assigned users.

Definition at line 671 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 213 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, ref_id) VALUES (" .
             $ilDB->quote($this->getId(), "integer") . "," .
             $ilDB->quote($this->getTitle(), "text") . "," .
             $ilDB->quote($this->getDescription(), "text") . "," .
             $ilDB->quote($this->getRefId(), "integer") .
             ")");
         
         // 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("order_nr" => array("integer", (int) $level["order_nr"]),
                     "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 288 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")
             );
     }

◆ deleteProfilesFromObject()

static ilSkillProfile::deleteProfilesFromObject ( int $a_ref_id )

static

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

References $DIC, and $ilDB.

Referenced by ilSkillObjDeletionHandler\processDeletion().

     {
         global $DIC;
 
         $ilDB = $DIC->database();
 
         $ilDB->manipulate(
             "DELETE FROM skl_profile WHERE " .
             " ref_id = " . $ilDB->quote($a_ref_id, "integer")
         );
     }

Here is the caller graph for this function:

◆ fixSkillOrderNumbering()

ilSkillProfile::fixSkillOrderNumbering ( )

Fix skill order numbering.

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

References $db, and $ilDB.

     {
         $ilDB = $this->db;
 
         $set = $ilDB->query(
             "SELECT profile_id, base_skill_id, tref_id, order_nr FROM skl_profile_level WHERE " .
             " profile_id = " . $ilDB->quote($this->getId(), "integer") .
             " ORDER BY order_nr ASC"
         );
         $cnt = 1;
         while ($rec = $ilDB->fetchAssoc($set)) {
             $ilDB->manipulate(
                 "UPDATE skl_profile_level SET " .
                 " order_nr = " . $ilDB->quote(($cnt * 10), "integer") .
                 " WHERE profile_id = " . $ilDB->quote($rec["profile_id"], "integer") .
                 " AND base_skill_id = " . $ilDB->quote($rec["base_skill_id"], "integer") .
                 " AND tref_id = " . $ilDB->quote($rec["tref_id"], "integer")
             );
             $cnt++;
         }
     }

◆ getAllProfilesOfRole()

static ilSkillProfile::getAllProfilesOfRole ( int $a_role_id )

static

Get global and local profiles of a role.

Parameters

int $a_role_id role id

Returns: array

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

References $DIC, and $ilDB.

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

◆ getAssignedRoles()

ilSkillProfile::getAssignedRoles ( )

Get assigned roles.

Returns: array

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

References $db, $ilDB, $lng, $name, $review, $type, ilObjRole\_getTranslation(), ilObject\_lookupObjectId(), ilObject\_lookupTitle(), and ilObject\_lookupType().

Referenced by getAssignments().

     {
         $ilDB = $this->db;
         $lng = $this->lng;
         $review = $this->review;
 
         $set = $ilDB->query(
             "SELECT * FROM skl_profile_role " .
             " WHERE profile_id = " . $ilDB->quote($this->getId(), "integer")
         );
         $roles = array();
         while ($rec = $ilDB->fetchAssoc($set)) {
             $name = ilObjRole::_getTranslation(ilObjRole::_lookupTitle($rec["role_id"]));
             $type = $lng->txt("role");
             // get object of role
             $obj_id = ilObject::_lookupObjectId($review->getObjectReferenceOfRole($rec["role_id"]));
             // get title of object if course or group
             $obj_title = "";
             $obj_type = "";
             if (ilObject::_lookupType($obj_id) == "crs" || ilObject::_lookupType($obj_id) == "grp") {
                 $obj_title = ilObject::_lookupTitle($obj_id);
                 $obj_type = ilObject::_lookupType($obj_id);
             }
 
             $roles[$rec["role_id"]] = array(
                 "type" => $type,
                 "name" => $name,
                 "id" => $rec["role_id"],
                 "object_title" => $obj_title,
                 "object_type" => $obj_type,
                 "object_id" => $obj_id
             );
         }
 
         return $roles;
     }

Here is the call graph for this function:

Here is the caller graph for this function:

◆ getAssignedUsers()

ilSkillProfile::getAssignedUsers ( )

Get assigned users.

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

References $db, $ilDB, $lng, $name, $type, and ilUserUtil\getNamePresentation().

Referenced by getAssignments().

     {
         $ilDB = $this->db;
         $lng = $this->lng;
         
         $set = $ilDB->query(
             "SELECT * FROM skl_profile_user " .
             " WHERE profile_id = " . $ilDB->quote($this->getId(), "integer")
             );
         $users = array();
         while ($rec = $ilDB->fetchAssoc($set)) {
             $name = ilUserUtil::getNamePresentation($rec["user_id"]);
             $type = $lng->txt("user");
             $users[$rec["user_id"]] = array(
                 "type" => $type,
                 "name" => $name,
                 "id" => $rec["user_id"]
                 );
         }
         return $users;
     }

Here is the call graph for this function:

Here is the caller graph for this function:

◆ getAssignments()

ilSkillProfile::getAssignments ( )

Get all assignments (users and roles)

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

References getAssignedRoles(), and getAssignedUsers().

     {
         $assignments = array();
 
         $users = $this->getAssignedUsers();
         $roles = $this->getAssignedRoles();
         $assignments = $users + $roles;
         ksort($assignments);
 
         return $assignments;
     }

Here is the call graph for this function:

◆ getDescription()

ilSkillProfile::getDescription ( )

Get description.

Returns: string description

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

References $description.

     {
         return $this->description;
     }

◆ getGlobalProfiles()

static ilSkillProfile::getGlobalProfiles ( )

static

Get global profiles.

Returns: array

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

References $DIC, and $ilDB.

Referenced by ilContSkillAdminGUI\listProfiles().

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

Here is the caller graph for this function:

◆ getGlobalProfilesOfRole()

static ilSkillProfile::getGlobalProfilesOfRole ( int $a_role_id )

static

Get global profiles of a role.

Parameters

int $a_role_id role id

Returns: array

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

References $DIC, and $ilDB.

     {
         global $DIC;
 
         $ilDB = $DIC->database();
 
         $profiles = array();
         $set = $ilDB->query(
             "SELECT p.id, p.title FROM skl_profile_role r JOIN skl_profile p " .
             " ON (r.profile_id = p.id) " .
             " WHERE r.role_id = " . $ilDB->quote($a_role_id, "integer") .
             " AND p.ref_id = 0" .
             " ORDER BY p.title ASC"
         );
         while ($rec = $ilDB->fetchAssoc($set)) {
             $profiles[] = $rec;
         }
         return $profiles;
     }

◆ getId()

ilSkillProfile::getId ( )

Get id.

Returns: int id

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

References $id.

Referenced by addRoleToProfile(), addUserToProfile(), create(), update(), updateRefIdAfterImport(), and updateSkillOrder().

     {
         return $this->id;
     }

Here is the caller graph for this function:

◆ getLocalProfiles()

static ilSkillProfile::getLocalProfiles ( int $a_ref_id )

static

Get local profiles of object.

Parameters

int $a_ref_id

Returns: array

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

References $DIC, and $ilDB.

Referenced by ilSkillDataSet\readData().

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

Here is the caller graph for this function:

◆ getLocalProfilesOfRole()

static ilSkillProfile::getLocalProfilesOfRole	(	int	$a_role_id,
		int	$a_ref_id
	)

static

Get local profiles of a role.

Parameters

int	$a_role_id	role id
int	$a_ref_id	ref id

Returns: array

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

References $DIC, and $ilDB.

     {
         global $DIC;
 
         $ilDB = $DIC->database();
 
         $profiles = array();
         $set = $ilDB->query(
             "SELECT p.id, p.title FROM skl_profile_role r JOIN skl_profile p " .
             " ON (r.profile_id = p.id) " .
             " WHERE r.role_id = " . $ilDB->quote($a_role_id, "integer") .
             " AND p.ref_id = " . $ilDB->quote($a_ref_id, "integer") .
             " ORDER BY p.title ASC"
         );
         while ($rec = $ilDB->fetchAssoc($set)) {
             $profiles[] = $rec;
         }
         return $profiles;
     }

◆ getMaxLevelOrderNr()

ilSkillProfile::getMaxLevelOrderNr ( )

Get maximum order number of levels.

Returns: int

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

References $db, and $ilDB.

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

◆ getProfiles()

static ilSkillProfile::getProfiles ( )

static

Get profiles.

Parameters

Definition at line 404 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 625 of file class.ilSkillProfile.php.

References $DIC, and $ilDB.

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

     {
         global $DIC;
 
         $ilDB = $DIC->database();
         $rbacreview = $DIC->rbac()->review();
 
         $all_profiles = array();
 
         // competence profiles coming from user assignments
         $user_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)) {
             $user_profiles[] = $rec;
         }
 
         // competence profiles coming from role assignments
         $role_profiles = array();
         $user_roles = $rbacreview->assignedRoles($a_user_id);
         foreach ($user_roles as $role) {
             $profiles = self::getGlobalProfilesOfRole($role);
             foreach ($profiles as $profile) {
                 $role_profiles[] = $profile;
             }
         }
 
         // merge competence profiles and remove multiple occurrences
         $all_profiles = array_merge($user_profiles, $role_profiles);
         $temp_profiles = array();
         foreach ($all_profiles as &$v) {
             if (!isset($temp_profiles[$v["id"]])) {
                 $temp_profiles[$v["id"]] = &$v;
             }
         }
         $all_profiles = array_values($temp_profiles);
         return $all_profiles;
     }

Here is the caller graph for this function:

◆ getRefId()

ilSkillProfile::getRefId ( )

Returns: int ref id

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

References $ref_id.

     {
         return $this->ref_id;
     }

◆ getSkillLevels()

ilSkillProfile::getSkillLevels ( )

Get skill levels.

Parameters

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

References $skill_level.

     {
         usort($this->skill_level, function($level_a, $level_b) {
             return $level_a['order_nr'] <=> $level_b['order_nr'];
         });
 
         return $this->skill_level;
     }

◆ getTitle()

ilSkillProfile::getTitle ( )

Get title.

Returns: string title

Definition at line 86 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 881 of file class.ilSkillProfile.php.

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

     {
         global $DIC;
 
         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 477 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];
     }

◆ lookupRefId()

static ilSkillProfile::lookupRefId ( $a_id )

static

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

Referenced by ilContSkillAdminGUI\confirmDeleteSelectedLocalProfiles(), ilContSkillAdminGUI\confirmRemoveSelectedGlobalProfiles(), ilContSkillAdminGUI\deleteSelectedLocalProfiles(), ilSkillProfileTableGUI\fillRow(), and ilContProfileTableGUI\fillRow().

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

Here is the caller graph for this function:

◆ lookupTitle()

static ilSkillProfile::lookupTitle ( $a_id )

static

Lookup title.

Parameters

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

Referenced by ilSkillProfileGUI\confirmDeleteProfiles(), ilContSkillAdminGUI\confirmDeleteSelectedLocalProfiles(), ilContSkillAdminGUI\confirmDeleteSingleLocalProfile(), ilContSkillAdminGUI\confirmRemoveSelectedGlobalProfiles(), ilContSkillAdminGUI\confirmRemoveSingleGlobalProfile(), and ilContProfileTableGUI\getProfiles().

     {
         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 183 of file class.ilSkillProfile.php.

References $db, $ilDB, addSkillLevel(), setDescription(), setRefId(), 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"]);
         $this->setRefId($rec["ref_id"]);
         
         $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"],
                 (int) $rec["order_nr"]
             );
         }
     }

Here is the call graph for this function:

Here is the caller graph for this function:

◆ removeRoleFromAllProfiles()

static ilSkillProfile::removeRoleFromAllProfiles ( int $a_role_id )

static

Remove role from all profiles.

Parameters

int $a_role_id

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

References $DIC, and $ilDB.

Referenced by ilSkillObjDeletionHandler\processDeletion().

     {
         global $DIC;
         $ilDB = $DIC->database();
 
         $ilDB->manipulate(
             "DELETE FROM skl_profile_role WHERE " .
             " role_id = " . $ilDB->quote($a_role_id, "integer")
         );
     }

Here is the caller graph for this function:

◆ removeRoleFromProfile()

ilSkillProfile::removeRoleFromProfile ( int $a_role_id )

Remove role from profile.

Parameters

int $a_role_id role id

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

References $db, and $ilDB.

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

◆ removeSkillLevel()

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

Remove skill level.

Parameters

Definition at line 150 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 &&
                 (int) $sl["order_nr"] == (int) $a_order_nr) {
                 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 608 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 592 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 96 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 56 of file class.ilSkillProfile.php.

Referenced by __construct(), and create().

     {
         $this->id = $a_val;
     }

Here is the caller graph for this function:

◆ setRefId()

ilSkillProfile::setRefId ( $a_val )

Parameters

int $a_val ref id

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

Referenced by read().

     {
         $this->ref_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 76 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 245 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") .
             " AND ref_id = " . $ilDB->quote($this->getRefId(), "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("order_nr" => array("integer", (int) $level["order_nr"]),
                       "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:

◆ updateRefIdAfterImport()

ilSkillProfile::updateRefIdAfterImport ( int $a_new_ref_id )

Update the old ref id with the new ref id after import.

Parameters

int $a_new_ref_id

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

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

     {
         $ilDB = $this->db;
 
         $ilDB->update(
             "skl_profile",
             array(
                 "ref_id" => array("integer", $a_new_ref_id)),
             array(
                 "id" => array("integer", $this->getId()))
         );
     }

Here is the call graph for this function:

◆ updateSkillOrder()

ilSkillProfile::updateSkillOrder ( array $order )

Update skill order.

Parameters

array $order

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

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

     {
         $ilDB = $this->db;
 
         asort($order);
 
         $cnt = 1;
         foreach ($order as $id => $o) {
             $id_arr = explode("_", $id);
             $ilDB->manipulate(
                 "UPDATE skl_profile_level SET " .
                 " order_nr = " . $ilDB->quote(($cnt * 10), "integer") .
                 " WHERE base_skill_id = " . $ilDB->quote($id_arr[0], "integer") .
                 " AND tref_id = " . $ilDB->quote($id_arr[1], "integer") .
                 " AND profile_id = " . $ilDB->quote($this->getId(), "integer")
             );
             $cnt++;
         }
     }

Here is the call graph for this function:

Field Documentation

◆ $db

ilSkillProfile::$db

protected

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

Referenced by addRoleToProfile(), addUserToProfile(), create(), delete(), fixSkillOrderNumbering(), getAssignedRoles(), getAssignedUsers(), getMaxLevelOrderNr(), read(), removeRoleFromProfile(), removeUserFromProfile(), update(), updateRefIdAfterImport(), and updateSkillOrder().

◆ $description

ilSkillProfile::$description

protected

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

Referenced by getDescription().

◆ $id

ilSkillProfile::$id

protected

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

Referenced by getId(), and updateSkillOrder().

◆ $lng

ilSkillProfile::$lng

protected

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

Referenced by getAssignedRoles(), and getAssignedUsers().

◆ $ref_id

ilSkillProfile::$ref_id = 0

protected

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

Referenced by getRefId().

◆ $review

ilSkillProfile::$review

protected

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

Referenced by getAssignedRoles().

◆ $skill_level

ilSkillProfile::$skill_level = array()

protected

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

Referenced by getSkillLevels().

◆ $title

ilSkillProfile::$title

protected

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

◆ addRoleToProfile()

◆ addSkillLevel()

◆ addUserToProfile()

◆ countRoles()

◆ countUsers()

◆ create()

◆ delete()

◆ deleteProfilesFromObject()

◆ fixSkillOrderNumbering()

◆ getAllProfilesOfRole()

◆ getAssignedRoles()

◆ getAssignedUsers()

◆ getAssignments()

◆ getDescription()

◆ getGlobalProfiles()

◆ getGlobalProfilesOfRole()

◆ getId()

◆ getLocalProfiles()

◆ getLocalProfilesOfRole()

◆ getMaxLevelOrderNr()

◆ getProfiles()

◆ getProfilesOfUser()

◆ getRefId()

◆ getSkillLevels()

◆ getTitle()

◆ getUsageInfo()

◆ lookup()

◆ lookupRefId()

◆ lookupTitle()

◆ read()

◆ removeRoleFromAllProfiles()

◆ removeRoleFromProfile()

◆ removeSkillLevel()

◆ removeUserFromAllProfiles()

◆ removeUserFromProfile()

◆ setDescription()

◆ setId()

◆ setRefId()

◆ setTitle()

◆ update()

◆ updateRefIdAfterImport()

◆ updateSkillOrder()

Field Documentation

◆ $db

◆ $description

◆ $id

◆ $lng

◆ $ref_id

◆ $review

◆ $skill_level

◆ $title