ilSkillSelfEvaluation Class Reference

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.

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

create()

ilSkillSelfEvaluation::create

(

)

Create self evaluation.

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

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

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

Here is the call graph for this function:

delete()

ilSkillSelfEvaluation::delete

(

)

Delete self evaluation.

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

References $db, and $ilDB.

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

determineSteps()

static ilSkillSelfEvaluation::determineSteps (   $a_sn_id )

static

Determine steps.

Parameters

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

References $steps.

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

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

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.

References $DIC, and $ilDB.

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

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

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.

References $DIC, and $lng.

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

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.

Referenced by update().

    {
        return $this->id;
    }

Here is the caller graph for this function:

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.

Referenced by create(), and update().

    {
        return $this->levels;
    }

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.

References $DIC, and $ilDB.

    {
        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];
    }

read()

ilSkillSelfEvaluation::read

(

)

Read.

Parameters

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

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

Referenced by __construct().

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

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.

Referenced by read().

    {
        $this->created = $a_val;
    }

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.

Referenced by __construct(), and create().

    {
        $this->id = $a_val;
    }

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.

Referenced by read().

    {
        $this->last_update = $a_val;
    }

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.

Referenced by read().

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

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.

Referenced by read().

    {
        $this->top_skill_id = $a_val;
    }

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.

Referenced by read().

    {
        $this->user_id = $a_val;
    }

Here is the caller graph for this function:

update()

ilSkillSelfEvaluation::update

(

)

Update self evaluation.

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

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

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

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