ilSurveySkill Class Reference

Skill/Competence handling in surveys. More...

Collaboration diagram for ilSurveySkill:

Public Member Functions
	__construct (ilObjSurvey $a_survey)
	Constructor. More...
	read ()
	Read. More...
	getSkillForQuestion ($a_question_id)
	Get skill for question. More...
	getQuestionsForSkill ($a_base_skill_id, $a_tref_id)
	Get questions for skill. More...
	addQuestionSkillAssignment ($a_question_id, $a_base_skill_id, $a_tref_id)
	Add survey question to skill assignment. More...
	removeQuestionSkillAssignment ($a_question_id)
	Remove question skill assignment. More...
	removeUsagesOfSkills ($a_skills)
	Remove usages of skills. More...
	isSkillAssignedToQuestion ($a_skill_id, $a_tref_id)
	Is skill assigned to any question? More...
	getAllAssignedSkillsAsOptions ()
	Get skill for question. More...
	determineSkillLevelsForAppraisee ($a_appraisee_id, $a_self_eval=false)
	Determine skill levels for appraisee. More...
	determineMaxScale ($a_base_skill, $a_tref_id=0)
	Determine max scales and questions. More...
	writeAppraiseeSkills ($a_app_id)
	Write appraisee skills. More...

Static Public Member Functions
static	handleQuestionDeletion ($a_question_id, $a_obj_id)
	Remove question skill assignment. More...

Protected Attributes
	$db
	$q_skill = array()
	$log

Detailed Description

Skill/Competence handling in surveys.

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

Constructor & Destructor Documentation

__construct()

ilSurveySkill::__construct

(

ilObjSurvey

$a_survey

)

Constructor.

Parameters

Definition at line 32 of file class.ilSurveySkill.php.

References $DIC, ilLoggerFactory\getLogger(), and read().

    {
        global $DIC;

        $this->db = $DIC->database();
        $this->survey = $a_survey;
        $this->read();
        $this->log = ilLoggerFactory::getLogger("svy");
    }

Here is the call graph for this function:

Member Function Documentation

addQuestionSkillAssignment()

ilSurveySkill::addQuestionSkillAssignment	(		$a_question_id,
			$a_base_skill_id,
			$a_tref_id
	)

Add survey question to skill assignment.

Parameters

int	$a_question_id	question id
int	$a_base_skill_id	base skill id
int	$a_tref_id	skill template reference id (0, if no template involved)

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

References $db, $ilDB, array, and ilSkillUsage\setUsage().

    {
        $ilDB = $this->db;
        
        $ilDB->replace(
            "svy_quest_skill",
            array("q_id" => array("integer", $a_question_id)),
            array(
                "survey_id" => array("integer", $this->survey->getId()),
                "base_skill_id" => array("integer", $a_base_skill_id),
                "tref_id" => array("integer", $a_tref_id)
                )
        );
        $this->q_skill[$a_question_id] = array("q_id" => $a_question_id,
            "base_skill_id" => $a_base_skill_id,
            "tref_id" => $a_tref_id);
        
        // add usage
        include_once("./Services/Skill/classes/class.ilSkillUsage.php");
        ilSkillUsage::setUsage($this->survey->getId(), $a_base_skill_id, $a_tref_id);
    }

Here is the call graph for this function:

determineMaxScale()

ilSurveySkill::determineMaxScale	(		$a_base_skill,
			$a_tref_id = 0
	)

Determine max scales and questions.

Parameters

Definition at line 337 of file class.ilSurveySkill.php.

References $i, $n, $s, and SurveyQuestion\_instanciateQuestion().

    {
        include_once("./Modules/SurveyQuestionPool/classes/class.SurveyQuestion.php");
        include_once("./Modules/Survey/classes/class.ilSurveySkill.php");
        $ssk = new ilSurveySkill($this->survey);
        $question_ids = $ssk->getQuestionsForSkill($a_base_skill, $a_tref_id);
        $scale_sum = 0;
        foreach ($question_ids as $q_id) {
            $q = SurveyQuestion::_instanciateQuestion($q_id);
            if (!is_object($q)) {
                continue;
            }
            $cats = $q->getCategories();
            $max_scale = 0;
            for ($i = 0; $i<= $cats->getCategoryCount(); $i++) {
                $c = $cats->getCategory($i);
                $n = $c->neutral;
                $s = $c->scale;
                if (!$c->neutral) {
                    if ($c->scale > $max_scale) {
                        $max_scale = $c->scale;
                    }
                }
            }
            $scale_sum+= $max_scale;
        }
        
        return $scale_sum;
    }

Here is the call graph for this function:

determineSkillLevelsForAppraisee()

ilSurveySkill::determineSkillLevelsForAppraisee	(		$a_appraisee_id,
			$a_self_eval = false
	)

Determine skill levels for appraisee.

Parameters

$a_appraisee_id

int user id of appraisee

Returns

array array with lots of information

Definition at line 252 of file class.ilSurveySkill.php.

References $l, $results, $s, $t, $title, array, getAllAssignedSkillsAsOptions(), and getQuestionsForSkill().

Referenced by writeAppraiseeSkills().

    {
        $skills = array();

        // get all skills
        $opts = $this->getAllAssignedSkillsAsOptions();
        foreach ($opts as $k => $title) {
            $k = explode(":", $k);
            
            $bs = new ilBasicSkill((int) $k[0]);
            $ld = $bs->getLevelData();
            
            $skills[] = array(
                "base_skill_id" => (int) $k[0],
                "tref_id" => (int) $k[1],
                "skill_title" => $title,
                "level_data" => $ld
                );
        }

        if (!$a_self_eval) {
            $finished_ids = $this->survey->getFinishedIdsForAppraiseeId($a_appraisee_id, true);
        } else {
            $finished_id = $this->survey->getFinishedIdForAppraiseeIdAndRaterId($a_appraisee_id, $a_appraisee_id);
            if ($finished_id > 0) {
                $finished_ids = array($finished_id);
            }
        }
        
        if (!sizeof($finished_ids)) {
            $finished_ids = array(-1);
        }

        $results = $this->survey->getUserSpecificResults($finished_ids);
        $this->log->debug("Finished IDS: " . print_r($finished_ids, true));
        foreach ($skills as $k => $s) {
            $q_ids = $this->getQuestionsForSkill($s["base_skill_id"], $s["tref_id"]);
            $this->log->debug("Skill: " . $s["base_skill_id"] . ":" . $s["tref_id"] . ", Questions: " . implode(",", $q_ids));
            $mean_sum = 0;
            foreach ($q_ids as $q_id) {
                $qmean = 0;
                if (is_array($results[$q_id])) {
                    $cnt = 0;
                    $sum = 0;
                    foreach ($results[$q_id] as $uid => $answer) {      // answer of user $uid for question $q_id
                        // $answer has the scale values as keys and the answer texts as values.
                        // In case of single choice this is an array with one key => value pair.
                        // For multiple choice questions (currently not supported for being used for competences)
                        // multiple elements may be in the array (in the future).
                        $scale_values = array_keys($answer); // scale values of the answer
                        $this->log->debug("User answer (scale values): " . print_r($scale_values, true));
                        $sum += array_sum($scale_values);
                        $cnt += sizeof($scale_values); // nr of answers (always one in the case of single choice)
                    }
                    if ($cnt > 0) {
                        $qmean = $sum/$cnt;
                    }
                    $this->log->debug("MEAN: " . $qmean);
                }
                $mean_sum += $qmean;
                $this->log->debug("MEAN SUM: " . $mean_sum);
            }
            $skills[$k]["mean_sum"] = $mean_sum;
            
            include_once("./Modules/Survey/classes/class.ilSurveySkillThresholds.php");
            $skthr = new ilSurveySkillThresholds($this->survey);
            $thresholds = $skthr->getThresholds();
            foreach ($skills[$k]["level_data"] as $l) {
                $t = $thresholds[$l["id"]][$s["tref_id"]];
                if ($t > 0 && $mean_sum >= $t) {
                    $skills[$k]["new_level"] = $l["title"];
                    $skills[$k]["new_level_id"] = $l["id"];
                }
            }
        }
        return $skills;
    }

Here is the call graph for this function:

Here is the caller graph for this function:

getAllAssignedSkillsAsOptions()

ilSurveySkill::getAllAssignedSkillsAsOptions

(

)

Get skill for question.

Parameters

int

$a_question_id

question id

Returns

array skill array

Definition at line 235 of file class.ilSurveySkill.php.

References ilSkillTreeNode\_lookupTitle(), and array.

Referenced by determineSkillLevelsForAppraisee().

    {
        $skills = array();
        include_once("./Services/Skill/classes/class.ilBasicSkill.php");
        foreach ($this->q_skill as $sk) {
            $skills[$sk["base_skill_id"] . ":" . $sk["tref_id"]] =
                ilBasicSkill::_lookupTitle($sk["base_skill_id"]);
        }
        return $skills;
    }

Here is the call graph for this function:

Here is the caller graph for this function:

getQuestionsForSkill()

ilSurveySkill::getQuestionsForSkill	(		$a_base_skill_id,
			$a_tref_id
	)

Get questions for skill.

Parameters

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

References $s, and array.

Referenced by determineSkillLevelsForAppraisee().

    {
        $q_ids = array();
        foreach ($this->q_skill as $q_id => $s) {
            if ($s["base_skill_id"] == $a_base_skill_id &&
                $s["tref_id"] == $a_tref_id) {
                $q_ids[] = $q_id;
            }
        }
        return $q_ids;
    }

Here is the caller graph for this function:

getSkillForQuestion()

ilSurveySkill::getSkillForQuestion

(

$a_question_id

)

Get skill for question.

Parameters

int

$a_question_id

question id

Returns

array skill array

Definition at line 74 of file class.ilSurveySkill.php.

    {
        if (isset($this->q_skill[$a_question_id])) {
            return $this->q_skill[$a_question_id];
        }
        return false;
    }

handleQuestionDeletion()

static ilSurveySkill::handleQuestionDeletion (   $a_question_id,   $a_obj_id  )

static

Remove question skill assignment.

Parameters

int

$a_question_id

question id

Definition at line 165 of file class.ilSurveySkill.php.

References $DIC, $ilDB, and ilObject\_lookupType().

Referenced by SurveyQuestion\delete().

    {
        global $DIC;

        $ilDB = $DIC->database();
        if (ilObject::_lookupType($a_obj_id) == "svy") {
            // mantis 11691
            include_once './Modules/Survey/classes/class.ilObjSurvey.php';
            $svy = new ilObjSurvey($a_obj_id, false);
            $svy_skill = new ilSurveySkill($svy);
            $svy_skill->removeQuestionSkillAssignment($a_question_id);
        }
    }

Here is the call graph for this function:

Here is the caller graph for this function:

isSkillAssignedToQuestion()

ilSurveySkill::isSkillAssignedToQuestion	(		$a_skill_id,
			$a_tref_id
	)

Is skill assigned to any question?

Parameters

Definition at line 212 of file class.ilSurveySkill.php.

References $db, and $ilDB.

Referenced by removeUsagesOfSkills().

    {
        $ilDB = $this->db;
        
        $set = $ilDB->query(
            "SELECT * FROM svy_quest_skill " .
            " WHERE base_skill_id = " . $ilDB->quote($a_skill_id, "integer") .
            " AND tref_id = " . $ilDB->quote($a_tref_id, "integer") .
            " AND survey_id = " . $ilDB->quote($this->survey->getId(), "integer")
        );
        if ($rec = $ilDB->fetchAssoc($set)) {
            return true;
        }
        return false;
    }

Here is the caller graph for this function:

read()

ilSurveySkill::read

(

)

Read.

Parameters

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

References $db, $ilDB, SurveyQuestion\_questionExists(), and array.

Referenced by __construct().

    {
        $ilDB = $this->db;
        
        $set = $ilDB->query(
            "SELECT * FROM svy_quest_skill " .
            " WHERE survey_id = " . $ilDB->quote($this->survey->getId(), "integer")
        );
        
        include_once("./Modules/SurveyQuestionPool/classes/class.SurveyQuestion.php");
        
        while ($rec = $ilDB->fetchAssoc($set)) {
            if (SurveyQuestion::_questionExists($rec["q_id"])) {
                $this->q_skill[$rec["q_id"]] = array("q_id" => $rec["q_id"],
                    "base_skill_id" => $rec["base_skill_id"],
                    "tref_id" => $rec["tref_id"]);
            }
        }
    }

Here is the call graph for this function:

Here is the caller graph for this function:

removeQuestionSkillAssignment()

ilSurveySkill::removeQuestionSkillAssignment

(

$a_question_id

)

Remove question skill assignment.

Parameters

int

$a_question_id

question id

Definition at line 135 of file class.ilSurveySkill.php.

References $db, $ilDB, array, and removeUsagesOfSkills().

    {
        $ilDB = $this->db;
        
        // read skills that are assigned to the quesiton
        $set = $ilDB->query(
            "SELECT * FROM svy_quest_skill " .
            " WHERE q_id = " . $ilDB->quote($a_question_id, "integer")
        );
        $skills = array();
        while ($rec = $ilDB->fetchAssoc($set)) {
            $skills[] = array("skill_id" => $rec["base_skill_id"],
                "tref_id" => $rec["tref_id"]);
        }
        
        // remove assignment of question
        $ilDB->manipulate(
            "DELETE FROM svy_quest_skill WHERE " .
            " q_id = " . $ilDB->quote($a_question_id, "integer")
        );
        unset($this->q_skill[$a_question_id]);
        
        $this->removeUsagesOfSkills($skills);
    }

Here is the call graph for this function:

removeUsagesOfSkills()

ilSurveySkill::removeUsagesOfSkills

(

$a_skills

)

Remove usages of skills.

This function checks, if the skills are really not in use anymore

Parameters

array

array of arrays with keys "skill_id" and "tref_id"

Definition at line 185 of file class.ilSurveySkill.php.

References array, isSkillAssignedToQuestion(), and ilSkillUsage\setUsage().

Referenced by removeQuestionSkillAssignment().

    {
        $used_skills = array();
        foreach ($a_skills as $skill) {
            if ($this->isSkillAssignedToQuestion($skill["skill_id"], $skill["tref_id"])) {
                $used_skills[] = $skill["skill_id"] . ":" . $skill["tref_id"];
            }
        }
        reset($a_skills);
        
        // now remove all usages that have been confirmed
        include_once("./Services/Skill/classes/class.ilSkillUsage.php");
        //var_dump($a_skills);
        //var_dump($used_skills); exit;
        foreach ($a_skills as $skill) {
            if (!in_array($skill["skill_id"] . ":" . $skill["tref_id"], $used_skills)) {
                ilSkillUsage::setUsage($this->survey->getId(), $skill["skill_id"], $skill["tref_id"], false);
            }
        }
    }

Here is the call graph for this function:

Here is the caller graph for this function:

writeAppraiseeSkills()

ilSurveySkill::writeAppraiseeSkills

(

$a_app_id

)

Write appraisee skills.

Parameters

Definition at line 373 of file class.ilSurveySkill.php.

References ilBasicSkill\ACHIEVED, determineSkillLevelsForAppraisee(), and ilBasicSkill\writeUserSkillLevelStatus().

    {
        // write raters evaluation
        $new_levels = $this->determineSkillLevelsForAppraisee($a_app_id);
        foreach ($new_levels as $nl) {
            if ($nl["new_level_id"] > 0) {
                ilBasicSkill::writeUserSkillLevelStatus(
                    $nl["new_level_id"],
                    $a_app_id,
                    $this->survey->getRefId(),
                    $nl["tref_id"],
                    ilBasicSkill::ACHIEVED,
                    true
                );
            }
        }

        // write self evaluation
        $new_levels = $this->determineSkillLevelsForAppraisee($a_app_id, true);
        foreach ($new_levels as $nl) {
            if ($nl["new_level_id"] > 0) {
                ilBasicSkill::writeUserSkillLevelStatus(
                    $nl["new_level_id"],
                    $a_app_id,
                    $this->survey->getRefId(),
                    $nl["tref_id"],
                    ilBasicSkill::ACHIEVED,
                    true,
                    1
                );
            }
        }
    }

Here is the call graph for this function:

Field Documentation

$db

ilSurveySkill::$db

protected

Definition at line 17 of file class.ilSurveySkill.php.

Referenced by addQuestionSkillAssignment(), isSkillAssignedToQuestion(), read(), and removeQuestionSkillAssignment().

$log

ilSurveySkill::$log

protected

Definition at line 24 of file class.ilSurveySkill.php.

$q_skill

ilSurveySkill::$q_skill = array()

protected

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

---

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

• Modules/Survey/classes/class.ilSurveySkill.php