Self evaluation application class. More...

Collaboration diagram for ilSkillSelfEvaluation:

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

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

	getId ()
	Get id. More...

	setUserId ($a_val)
	Set user id. More...

	getUserId ()
	Get user id. More...

	setTopSkillId ($a_val)
	Set top skill id. More...

	getTopSkillId ()
	Get top skill id. More...

	setCreated ($a_val)
	Set created at. More...

	getCreated ()
	Get created at. More...

	setLastUpdate ($a_val)
	Set last update. More...

	getLastUpdate ()
	Get last update. More...

	setLevels ($a_val, $a_keep_existing=false)
	Set level. More...

	getLevels ()
	Get level. More...

	read ()
	Read. More...

	create ()
	Create self evaluation. More...

	update ()
	Update self evaluation. More...

	delete ()
	Delete self evaluation. More...

Static Public Member Functions
static	getAllSelfEvaluationsOfUser ($a_user, $a_one_per_top_skill=false)
	Get all self evaluations. More...

static	getAverageLevel ($a_se_id, $a_user_id, $a_top_skill_id)
	Get average level of user self evaluation. More...

static	determineSteps ($a_sn_id)
	Determine steps. More...

Static Protected Member Functions
static	lookupProperty ($a_id, $a_prop)
	Lookup property. More...

Protected Attributes
	$db

Detailed Description

Self evaluation application class.

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

Constructor & Destructor Documentation

◆ __construct()

ilSkillSelfEvaluation::__construct ( $a_id = 0 )

Constructor.

Parameters

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

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

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

Here is the call graph for this function:

Member Function Documentation

◆ create()

ilSkillSelfEvaluation::create ( )

Create self evaluation.

Definition at line 197 of file class.ilSkillSelfEvaluation.php.

    {
        $ilDB = $this->db;
 
        $this->setId($ilDB->nextId("skl_self_eval"));
 
        $ilDB->manipulate("INSERT INTO skl_self_eval " .
            "(id, user_id, top_skill_id, created, last_update) VALUES (" .
            $ilDB->quote($this->getId(), "integer") . "," .
            $ilDB->quote($this->getUserId(), "integer") . "," .
            $ilDB->quote($this->getTopSkillId(), "integer") . "," .
            $ilDB->now() . "," .
            $ilDB->now() .
            ")");
 
        $levels = $this->getLevels();
        if (is_array($levels)) {
            foreach ($levels as $skill_id => $level_id) {
                $ilDB->manipulate("INSERT INTO skl_self_eval_level " .
                    "(self_eval_id, skill_id, level_id) VALUES (" .
                    $ilDB->quote($this->getId(), "integer") . "," .
                    $ilDB->quote($skill_id, "integer") . "," .
                    $ilDB->quote($level_id, "integer") .
                    ")");
            }
        }
    }

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

Here is the call graph for this function:

◆ delete()

ilSkillSelfEvaluation::delete ( )

Delete self evaluation.

Definition at line 261 of file class.ilSkillSelfEvaluation.php.

    {
        $ilDB = $this->db;
 
        $ilDB->manipulate(
            "DELETE FROM skl_self_eval WHERE "
            . " id = " . $ilDB->quote($this->getId(), "integer")
            );
 
        $ilDB->manipulate(
            "DELETE FROM skl_self_eval_level WHERE "
            . " self_eval_id = " . $ilDB->quote($this->getId(), "integer")
            );
    }

References $db, and $ilDB.

◆ determineSteps()

static ilSkillSelfEvaluation::determineSteps ( $a_sn_id )

static

Determine steps.

Parameters

return

Definition at line 385 of file class.ilSkillSelfEvaluation.php.

    {
        $steps = array();
        if ($a_sn_id > 0) {
            $stree = new ilSkillTree();
 
            if ($stree->isInTree($a_sn_id)) {
                $cnode = $stree->getNodeData($a_sn_id);
                $childs = $stree->getSubTree($cnode);
                foreach ($childs as $child) {
                    if ($child["type"] == "skll") {
                        $steps[] = $child["child"];
                    }
                }
            }
        }
        return $steps;
    }

References $steps.

Referenced by ilSkillSelfEvaluationGUI\saveSelfEvaluation(), ilSkillSelfEvaluationGUI\startSelfEvaluation(), and ilSkillSelfEvaluationGUI\updateSelfEvaluation().

Here is the caller graph for this function:

◆ getAllSelfEvaluationsOfUser()

static ilSkillSelfEvaluation::getAllSelfEvaluationsOfUser	(	$a_user,
		$a_one_per_top_skill = `false`
	)

static

Get all self evaluations.

Definition at line 279 of file class.ilSkillSelfEvaluation.php.

    {
        global $DIC;
 
        $ilDB = $DIC->database();
 
        $set = $ilDB->query(
            "SELECT * FROM skl_self_eval WHERE user_id = " .
            $ilDB->quote($a_user, "integer") . " " .
            "ORDER BY last_update DESC"
            );
 
        $self_evaluation = array();
 
        $top_skills = array();
        while ($rec = $ilDB->fetchAssoc($set)) {
            if (!$a_one_per_top_skill || !in_array($rec["top_skill_id"], $top_skills)) {
                $self_evaluation[] = $rec;
                $top_skills[] = $rec["top_skill_id"];
            }
        }
 
        return $self_evaluation;
    }

References $DIC, and $ilDB.

Referenced by ilSelfEvaluationTableGUI\__construct(), and ilSkillSelfEvaluationGUI\getPresentationView().

Here is the caller graph for this function:

◆ getAverageLevel()

static ilSkillSelfEvaluation::getAverageLevel	(	$a_se_id,
		$a_user_id,
		$a_top_skill_id
	)

static

Get average level of user self evaluation.

Note: this method does not make much sense in general, since it assumes that all basic skills have the same level

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

    {
        global $DIC;
 
        $lng = $DIC->language();
 
        $lng->loadLanguageModule("skmg");
 
        $stree = new ilSkillTree();
        $cnt = 0;
        $sum = 0;
        if ($stree->isInTree($a_top_skill_id)) {
            $se = new ilSkillSelfEvaluation($a_se_id);
            $levels = $se->getLevels();
 
            $cnode = $stree->getNodeData($a_top_skill_id);
            $childs = $stree->getSubTree($cnode);
 
            foreach ($childs as $child) {
                if ($child["type"] == "skll") {
                    $sk = new ilBasicSkill($child["child"]);
                    $ls = $sk->getLevelData();
                    $ord = array();
                    foreach ($ls as $k => $l) {
                        $ord[$l["id"]] = $k + 1;
                    }
                    reset($ls);
                    foreach ($ls as $ld) {
                        if ($ld["id"] == $levels[$child["child"]]) {
                            $sum += $ord[$ld["id"]];
                        }
                    }
                    $cnt += 1;
                }
            }
        }
        if ($cnt > 0) {
            $avg = round($sum / $cnt);
            if ($avg > 0) {
                return (array("skill_title" => $cnode["title"],
                    "ord" => $avg, "avg_title" => $ls[$avg - 1]["title"]));
            } else {
                return (array("skill_title" => $cnode["title"],
                    "ord" => $avg, "avg_title" => $lng->txt("skmg_no_skills")));
            }
        }
        return null;
    }

References $DIC, and $lng.

◆ getCreated()

ilSkillSelfEvaluation::getCreated ( )

Get created at.

Returns: timestamp created at

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

    {
        return $this->created;
    }

◆ getId()

ilSkillSelfEvaluation::getId ( )

Get id.

Returns: integer id

Definition at line 48 of file class.ilSkillSelfEvaluation.php.

    {
        return $this->id;
    }

◆ getLastUpdate()

ilSkillSelfEvaluation::getLastUpdate ( )

Get last update.

Returns: timestamp last update

Definition at line 128 of file class.ilSkillSelfEvaluation.php.

    {
        return $this->last_update;
    }

◆ getLevels()

ilSkillSelfEvaluation::getLevels ( )

Get level.

Returns: array level

Definition at line 156 of file class.ilSkillSelfEvaluation.php.

    {
        return $this->levels;
    }

Referenced by create(), and update().

Here is the caller graph for this function:

◆ getTopSkillId()

ilSkillSelfEvaluation::getTopSkillId ( )

Get top skill id.

Returns: integer top skill id

Definition at line 88 of file class.ilSkillSelfEvaluation.php.

    {
        return $this->top_skill_id;
    }

◆ getUserId()

ilSkillSelfEvaluation::getUserId ( )

Get user id.

Returns: integer user id

Definition at line 68 of file class.ilSkillSelfEvaluation.php.

    {
        return $this->user_id;
    }

◆ lookupProperty()

static ilSkillSelfEvaluation::lookupProperty	(	$a_id,
		$a_prop
	)

staticprotected

Lookup property.

Parameters

id level id

Returns: mixed property value

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

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

References $DIC, and $ilDB.

◆ read()

ilSkillSelfEvaluation::read ( )

Read.

Parameters

return

Definition at line 167 of file class.ilSkillSelfEvaluation.php.

    {
        $ilDB = $this->db;
 
        $set = $ilDB->query(
            "SELECT * FROM skl_self_eval WHERE " .
            " id = " . $ilDB->quote($this->getId(), "integer")
            );
        if ($rec = $ilDB->fetchAssoc($set)) {
            $this->setUserId($rec["user_id"]);
            $this->setTopSkillId($rec["top_skill_id"]);
            $this->setCreated($rec["created"]);
            $this->setLastUpdate($rec["last_update"]);
        }
 
        // levels
        $set = $ilDB->query(
            "SELECT * FROM skl_self_eval_level WHERE " .
            " self_eval_id = " . $ilDB->quote($this->getId(), "integer")
            );
        $levels = array();
        while ($rec = $ilDB->fetchAssoc($set)) {
            $levels[$rec["skill_id"]] = $rec["level_id"];
        }
        $this->setLevels($levels);
    }

References $db, $ilDB, setCreated(), setLastUpdate(), setLevels(), setTopSkillId(), and setUserId().

Referenced by __construct().

Here is the call graph for this function:

Here is the caller graph for this function:

◆ setCreated()

ilSkillSelfEvaluation::setCreated ( $a_val )

Set created at.

Parameters

timestamp created at

Definition at line 98 of file class.ilSkillSelfEvaluation.php.

    {
        $this->created = $a_val;
    }

Referenced by read().

Here is the caller graph for this function:

◆ setId()

ilSkillSelfEvaluation::setId ( $a_val )

Set id.

Parameters

integer id

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

    {
        $this->id = $a_val;
    }

Referenced by __construct(), and create().

Here is the caller graph for this function:

◆ setLastUpdate()

ilSkillSelfEvaluation::setLastUpdate ( $a_val )

Set last update.

Parameters

timestamp last update

Definition at line 118 of file class.ilSkillSelfEvaluation.php.

    {
        $this->last_update = $a_val;
    }

Referenced by read().

Here is the caller graph for this function:

◆ setLevels()

ilSkillSelfEvaluation::setLevels	(	$a_val,
		$a_keep_existing = `false`
	)

Set level.

Parameters

array level; index: skill id, value: level id (or 0 for no skills)

Definition at line 138 of file class.ilSkillSelfEvaluation.php.

    {
        if (!$a_keep_existing) {
            $this->levels = $a_val;
        } else {
            if (is_array($a_val)) {
                foreach ($a_val as $k => $v) {
                    $this->levels[$k] = $v;
                }
            }
        }
    }

Referenced by read().

Here is the caller graph for this function:

◆ setTopSkillId()

ilSkillSelfEvaluation::setTopSkillId ( $a_val )

Set top skill id.

Parameters

integer top skill id

Definition at line 78 of file class.ilSkillSelfEvaluation.php.

    {
        $this->top_skill_id = $a_val;
    }

Referenced by read().

Here is the caller graph for this function:

◆ setUserId()

ilSkillSelfEvaluation::setUserId ( $a_val )

Set user id.

Parameters

integer user id

Definition at line 58 of file class.ilSkillSelfEvaluation.php.

    {
        $this->user_id = $a_val;
    }

Referenced by read().

Here is the caller graph for this function:

◆ update()

ilSkillSelfEvaluation::update ( )

Update self evaluation.

Definition at line 228 of file class.ilSkillSelfEvaluation.php.

    {
        $ilDB = $this->db;
 
        $ilDB->manipulate(
            "UPDATE skl_self_eval SET " .
            " user_id = " . $ilDB->quote($this->getUserId(), "integer") .
            ", top_skill_id = " . $ilDB->quote($this->getTopSkillId(), "integer") .
            ", last_update = " . $ilDB->now() .
            " WHERE id = " . $ilDB->quote($this->getId(), "integer")
            );
 
        $ilDB->manipulate(
            "DELETE FROM skl_self_eval_level WHERE "
            . " self_eval_id = " . $ilDB->quote($this->getId(), "integer")
            );
 
        $levels = $this->getLevels();
        if (is_array($levels)) {
            foreach ($levels as $skill_id => $level_id) {
                $ilDB->manipulate("INSERT INTO skl_self_eval_level " .
                    "(self_eval_id, skill_id, level_id) VALUES (" .
                    $ilDB->quote($this->getId(), "integer") . "," .
                    $ilDB->quote($skill_id, "integer") . "," .
                    $ilDB->quote($level_id, "integer") .
                    ")");
            }
        }
    }

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

Here is the call graph for this function:

Field Documentation

◆ $db

ilSkillSelfEvaluation::$db

protected

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

Referenced by create(), delete(), read(), and update().

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

Services/Skill/classes/class.ilSkillSelfEvaluation.php

Public Member Functions

Static Public Member Functions

Static Protected Member Functions

Protected Attributes

Detailed Description

Constructor & Destructor Documentation

◆ __construct()

Member Function Documentation

◆ create()

◆ delete()

◆ determineSteps()

◆ getAllSelfEvaluationsOfUser()

◆ getAverageLevel()

◆ getCreated()

◆ getId()

◆ getLastUpdate()

◆ getLevels()

◆ getTopSkillId()

◆ getUserId()

◆ lookupProperty()

◆ read()

◆ setCreated()

◆ setId()

◆ setLastUpdate()

◆ setLevels()

◆ setTopSkillId()

◆ setUserId()

◆ update()

Field Documentation

◆ $db