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

Version: $Id$

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

Constructor & Destructor Documentation

◆ __construct()

ilSkillSelfEvaluation::__construct ( $a_id = 0 )

Constructor.

Parameters

Definition at line 24 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 199 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 263 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 389 of file class.ilSkillSelfEvaluation.php.

    {
        $steps = array();
        if ($a_sn_id > 0) {
            include_once("./Services/Skill/classes/class.ilSkillTree.php");
            include_once("./Services/Skill/classes/class.ilSkillSelfEvalSkillTableGUI.php");
            $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 281 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 332 of file class.ilSkillSelfEvaluation.php.

    {
        global $DIC;
 
        $lng = $DIC->language();
 
        $lng->loadLanguageModule("skmg");
 
        include_once("./Services/Skill/classes/class.ilSkillTree.php");
        include_once("./Services/Skill/classes/class.ilBasicSkill.php");
        $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, $l, and $lng.

◆ getCreated()

ilSkillSelfEvaluation::getCreated ( )

Get created at.

Returns: timestamp created at

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

    {
        return $this->created;
    }

◆ getId()

ilSkillSelfEvaluation::getId ( )

Get id.

Returns: integer id

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

    {
        return $this->id;
    }

References $id.

◆ getLastUpdate()

ilSkillSelfEvaluation::getLastUpdate ( )

Get last update.

Returns: timestamp last update

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

    {
        return $this->last_update;
    }

◆ getLevels()

ilSkillSelfEvaluation::getLevels ( )

Get level.

Returns: array level

Definition at line 158 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 90 of file class.ilSkillSelfEvaluation.php.

    {
        return $this->top_skill_id;
    }

◆ getUserId()

ilSkillSelfEvaluation::getUserId ( )

Get user id.

Returns: integer user id

Definition at line 70 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 312 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 169 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 100 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 40 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 120 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 140 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 80 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 60 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 230 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 17 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