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	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	getUsageInfo ($a_cskill_ids, &$a_usages)
	Get title of an assigned item. More...

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

Protected Attributes
	$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 26 of file class.ilSkillProfile.php.

        {
                if ($a_id > 0)
                {
                        $this->setId($a_id);
                        $this->read();
                }
        }

References read(), and setId().

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

return

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

        {
//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
                        );
        }

Referenced by read().

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

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

References $ilDB, and getId().

Here is the call graph for this function:

◆ countUsers()

static ilSkillProfile::countUsers ( $a_profile_id )

static

Get assigned users.

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

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

References $ilDB.

Referenced by ilSkillProfileTableGUI\fillRow().

Here is the caller graph for this function:

◆ create()

ilSkillProfile::create ( )

Create skill profile.

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

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

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

Here is the call graph for this function:

◆ delete()

ilSkillProfile::delete ( )

Delete skill profile.

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

        {
                global $ilDB;
                
                // profile levels
                $ilDB->manipulate("DELETE FROM skl_profile_level WHERE ".
                        " profile_id = ".$ilDB->quote($this->getId(), "integer")
                        );
                
                // profile
                $ilDB->manipulate("DELETE FROM skl_profile WHERE ".
                        " id = ".$ilDB->quote($this->getId(), "integer")
                        );
                
        }

References $ilDB.

◆ getAssignedUsers()

ilSkillProfile::getAssignedUsers ( )

Get assigned users.

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

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

References $ilDB, and ilObjUser\_lookupName().

Here is the call graph for this function:

◆ getDescription()

ilSkillProfile::getDescription ( )

Get description.

Returns: string description

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

        {
                return $this->description;
        }

References $description.

◆ getId()

ilSkillProfile::getId ( )

Get id.

Returns: int id

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

        {
                return $this->id;
        }

References $id.

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

Here is the caller graph for this function:

◆ getProfiles()

static ilSkillProfile::getProfiles ( )

static

Get profiles.

Parameters

return

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

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

References $ilDB.

Referenced by ilSkillProfileTableGUI\getProfiles().

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

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

References $ilDB.

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

Here is the caller graph for this function:

◆ getSkillLevels()

ilSkillProfile::getSkillLevels ( )

Get skill levels.

Parameters

return

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

        {
                return $this->skill_level;
        }

References $skill_level.

◆ getTitle()

ilSkillProfile::getTitle ( )

Get title.

Returns: string title

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

        {
                return $this->title;
        }

References $title.

◆ getUsageInfo()

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

static

Get usage info.

Parameters

return

Implements ilSkillUsageInfo.

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

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

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

Here is the call graph for this function:

◆ lookup()

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

staticprotected

Lookup.

Parameters

return

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

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

References $ilDB.

Referenced by lookupTitle().

Here is the caller graph for this function:

◆ lookupTitle()

static ilSkillProfile::lookupTitle ( $a_id )

static

Lookup title.

Parameters

return

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

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

References lookup().

Referenced by ilSkillProfileGUI\confirmDeleteProfiles().

Here is the call graph for this function:

Here is the caller graph for this function:

◆ read()

ilSkillProfile::read ( )

Read skill profile from db.

Parameters

return

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

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

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

Referenced by __construct().

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

return

Definition at line 117 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]);
                        }
                }
        }

◆ removeUserFromProfile()

ilSkillProfile::removeUserFromProfile ( $a_user_id )

Remove user from profile.

Parameters

int $a_user_id user id

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

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

References $ilDB.

◆ setDescription()

ilSkillProfile::setDescription ( $a_val )

Set description.

Parameters

string $a_val description

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

        {
                $this->description = $a_val;
        }

Referenced by read().

Here is the caller graph for this function:

◆ setId()

ilSkillProfile::setId ( $a_val )

Set id.

Parameters

int $a_val id

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

        {
                $this->id = $a_val;
        }

Referenced by __construct(), and create().

Here is the caller graph for this function:

◆ setTitle()

ilSkillProfile::setTitle ( $a_val )

Set title.

Parameters

string $a_val title

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

        {
                $this->title = $a_val;
        }

Referenced by read().

Here is the caller graph for this function:

◆ update()

ilSkillProfile::update ( )

Update skill profile.

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

        {
                global $ilDB;
                
                // 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").
                                ")");*/
                }
        }

References $ilDB, and getId().

Here is the call graph for this function:

Field Documentation

◆ $description

ilSkillProfile::$description

protected

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

Referenced by getDescription().

◆ $id

ilSkillProfile::$id

protected

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

Referenced by getId().

◆ $skill_level

ilSkillProfile::$skill_level = array()

protected

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

Referenced by getSkillLevels().

◆ $title

ilSkillProfile::$title

protected

Definition at line 17 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()

◆ removeUserFromProfile()

◆ setDescription()

◆ setId()

◆ setTitle()

◆ update()

Field Documentation

◆ $description

◆ $id

◆ $skill_level

◆ $title