ilSurveySkill Class Reference

Skill/Competence handling in surveys. More...

Collaboration diagram for ilSurveySkill:

Public Member Functions
	__construct (ilObjSurvey $a_survey)
	read ()
	getSkillForQuestion (int $a_question_id)
	Get skill for question. More...
	getQuestionsForSkill (int $a_base_skill_id, int $a_tref_id)
	Get questions for skill. More...
	addQuestionSkillAssignment (int $a_question_id, int $a_base_skill_id, int $a_tref_id)
	Add survey question to skill assignment. More...
	removeQuestionSkillAssignment (int $a_question_id)
	removeUsagesOfSkills (array $a_skills)
	Remove usages of skills This function checks, if the skills are really not in use anymore. More...
	isSkillAssignedToQuestion (int $a_skill_id, int $a_tref_id)
	getAllAssignedSkillsAsOptions ()
	determineSkillLevelsForAppraisee (int $a_appraisee_id, bool $a_self_eval=false, int $finished_id=0)
	Determine skill levels for appraisee. More...
	determineMaxScale (int $a_base_skill, int $a_tref_id=0)
	writeAndAddAppraiseeSkills (int $user_id)
	Write appraisee skills and add them to user's competence records. More...
	writeAndAddIndFeedbackSkills (int $finished_id, int $appr_id, string $rater_id)
	writeAndAddSelfEvalSkills (int $user_id)
	Write skills on self evaluation and add them to user's competence records. More...

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

Protected Attributes
ilObjSurvey	$survey
ilDBInterface	$db
array	$q_skill = array()
ilLogger	$log
ILIAS Skill Service SkillProfileService	$skill_profile_service
ILIAS Skill Service SkillPersonalService	$skill_personal_service
ILIAS Skill Service SkillUsageService	$skill_usage_service

Detailed Description

Skill/Competence handling in surveys.

Author

Alexander Killing killi.nosp@m.ng@l.nosp@m.eifos.nosp@m..de

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

Constructor & Destructor Documentation

__construct()

ilSurveySkill::__construct

(

ilObjSurvey

$a_survey

)

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

    {
        global $DIC;
 
        $this->db = $DIC->database();
        $this->survey = $a_survey;
        $this->read();
        $this->log = ilLoggerFactory::getLogger("svy");
        $this->skill_profile_service = $DIC->skills()->profile();
        $this->skill_personal_service = $DIC->skills()->personal();
        $this->skill_usage_service = $DIC->skills()->usage();
    }

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

Here is the call graph for this function:

Member Function Documentation

addQuestionSkillAssignment()

ilSurveySkill::addQuestionSkillAssignment	(	int	$a_question_id,
		int	$a_base_skill_id,
		int	$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.

     : void {
        $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
        $this->skill_usage_service->addUsage($this->survey->getId(), $a_base_skill_id, $a_tref_id);
    }

determineMaxScale()

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

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

     : int {
        $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 = (bool) $c->neutral;
                $s = (int) $c->scale;
                if (!$n) {
                    if ($s > $max_scale) {
                        $max_scale = $s;
                    }
                }
            }
            $scale_sum += $max_scale;
        }
 
        return $scale_sum;
    }

References Vendor\Package\$c, and SurveyQuestion\_instanciateQuestion().

Here is the call graph for this function:

determineSkillLevelsForAppraisee()

ilSurveySkill::determineSkillLevelsForAppraisee	(	int	$a_appraisee_id,
		bool	$a_self_eval = false,
		int	$finished_id = 0
	)

Determine skill levels for appraisee.

Returns

array array with lots of information

Todo:

introduce dto

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

     : array {
        $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
            );
        }
 
        $finished_ids = [];
        if (!$a_self_eval) {
            if ($finished_id > 0) {
                $finished_ids = array($finished_id);
            } else {
                $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 (!is_array($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 += count($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;
 
            $skthr = new ilSurveySkillThresholds($this->survey);
            $thresholds = $skthr->getThresholds();
            $previous = 0;
            $previous_t = 0;
            foreach ($skills[$k]["level_data"] as $l) {
                $t = $thresholds[$l["id"]][$s["tref_id"]] ?? 0;
                if ($t > 0 && $mean_sum >= $t) {
                    $skills[$k]["new_level"] = $l["title"];
                    $skills[$k]["new_level_id"] = $l["id"];
                    $skills[$k]["next_level_perc"] = 0;
                } elseif ($t > 0 && $mean_sum < $t) {
                    // first unfulfilled level
                    if ($previous == ($skills[$k]["new_level_id"] ?? null) && !isset($skills[$k]["next_level_perc"])) {
                        $skills[$k]["next_level_perc"] = 1 / ($t - $previous_t) * ($mean_sum - $previous_t);
                    }
                }
                if ($t > 0) {
                    $previous = $l["id"];
                    $previous_t = $t;
                }
            }
        }
        return $skills;
    }

getAllAssignedSkillsAsOptions()

ilSurveySkill::getAllAssignedSkillsAsOptions

(

)

Returns

array skill array

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

                                                   : array
    {
        $skills = array();
        foreach ($this->q_skill as $sk) {
            $skills[$sk["base_skill_id"] . ":" . $sk["tref_id"]] = ilBasicSkill::_lookupTitle($sk["base_skill_id"]);
        }
        return $skills;
    }

References ilSkillTreeNode\_lookupTitle().

Here is the call graph for this function:

getQuestionsForSkill()

ilSurveySkill::getQuestionsForSkill	(	int	$a_base_skill_id,
		int	$a_tref_id
	)

Get questions for skill.

Returns

int[]

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

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

getSkillForQuestion()

ilSurveySkill::getSkillForQuestion

(

int

$a_question_id

)

Get skill for question.

Parameters

int

$a_question_id

question id

Returns

?array{q_id: int, base_skill_id: int, tref_id: int} skill array

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

     : ?array {
        return $this->q_skill[$a_question_id] ?? null;
    }

handleQuestionDeletion()

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

static

Remove question skill assignment.

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

     : void {
        $svy_log = ilLoggerFactory::getLogger("svy");
 
        $svy_log->debug("delete skill assignment, obj id " . $a_obj_id .
            ", obj type: " . ilObject::_lookupType($a_obj_id));
 
        if (ilObject::_lookupType($a_obj_id) === "svy" &&
            ilObject::_exists($a_obj_id)) {
            $svy_log->debug("call removeQuestionSkillAssignment.");
            // mantis 11691
            $svy = new ilObjSurvey($a_obj_id, false);
            $svy_skill = new ilSurveySkill($svy);
            $svy_skill->removeQuestionSkillAssignment($a_question_id);
        }
    }

Referenced by SurveyQuestion\delete().

Here is the caller graph for this function:

isSkillAssignedToQuestion()

ilSurveySkill::isSkillAssignedToQuestion	(	int	$a_skill_id,
		int	$a_tref_id
	)

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

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

read()

ilSurveySkill::read

(

)

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

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

References $db, $ilDB, SurveyQuestion\_questionExists(), and ILIAS\Repository\int().

Referenced by __construct().

Here is the call graph for this function:

Here is the caller graph for this function:

removeQuestionSkillAssignment()

ilSurveySkill::removeQuestionSkillAssignment

(

int

$a_question_id

)

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

     : void {
        $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" => (int) $rec["base_skill_id"],
                "tref_id" => (int) $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);
    }

removeUsagesOfSkills()

ilSurveySkill::removeUsagesOfSkills

(

array

$a_skills

)

Remove usages of skills This function checks, if the skills are really not in use anymore.

Parameters

array

$a_skills

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

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

     : void {
        $used_skills = array();
        foreach ($a_skills as $skill) {
            $skill_id = (int) $skill["skill_id"];
            $tref_id = (int) $skill["tref_id"];
            if ($this->isSkillAssignedToQuestion($skill_id, $tref_id)) {
                $used_skills[] = $skill_id . ":" . $tref_id;
            }
        }
        reset($a_skills);
 
        // now remove all usages that have been confirmed
        foreach ($a_skills as $skill) {
            $skill_id = (int) $skill["skill_id"];
            $tref_id = (int) $skill["tref_id"];
            if (!in_array($skill_id . ":" . $tref_id, $used_skills, true)) {
                $this->skill_usage_service->removeUsage($this->survey->getId(), $skill_id, $tref_id);
            }
        }
    }

References ILIAS\Repository\int().

Here is the call graph for this function:

writeAndAddAppraiseeSkills()

ilSurveySkill::writeAndAddAppraiseeSkills

(

int

$user_id

)

Write appraisee skills and add them to user's competence records.

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

     : void {
        // write raters evaluation
        $new_levels = $this->determineSkillLevelsForAppraisee($user_id);
        foreach ($new_levels as $nl) {
            if (($nl["new_level_id"] ?? 0) > 0) {
                ilBasicSkill::writeUserSkillLevelStatus(
                    (int) $nl["new_level_id"],
                    $user_id,
                    $this->survey->getRefId(),
                    (int) $nl["tref_id"],
                    ilBasicSkill::ACHIEVED,
                    true,
                    false,
                    "",
                    (float) $nl["next_level_perc"]
                );
 
                if (($nl["tref_id"] ?? 0) > 0) {
                    $this->skill_personal_service->addPersonalSkill($user_id, (int) $nl["tref_id"]);
                } else {
                    $this->skill_personal_service->addPersonalSkill($user_id, (int) $nl["base_skill_id"]);
                }
            }
        }
 
        //write profile completion entries if fulfilment status has changed
        $this->skill_profile_service->writeCompletionEntryForAllProfiles($user_id);
 
        // write self evaluation
        $this->writeAndAddSelfEvalSkills($user_id);
    }

References $user_id, ilBasicSkill\ACHIEVED, and ilBasicSkill\writeUserSkillLevelStatus().

Here is the call graph for this function:

writeAndAddIndFeedbackSkills()

ilSurveySkill::writeAndAddIndFeedbackSkills	(	int	$finished_id,
		int	$appr_id,
		string	$rater_id
	)

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

     : void {
        $new_levels = $this->determineSkillLevelsForAppraisee($appr_id, false, $finished_id);
        foreach ($new_levels as $nl) {
            if (($nl["new_level_id"] ?? 0) > 0) {
                ilBasicSkill::writeUserSkillLevelStatus(
                    (int) $nl["new_level_id"],
                    $appr_id,
                    $this->survey->getRefId(),
                    (int) $nl["tref_id"],
                    ilBasicSkill::ACHIEVED,
                    true,
                    false,
                    "",
                    (float) $nl["next_level_perc"],
                    $rater_id
                );
 
                if (($nl["tref_id"] ?? 0) > 0) {
                    $this->skill_personal_service->addPersonalSkill($appr_id, (int) $nl["tref_id"]);
                } else {
                    $this->skill_personal_service->addPersonalSkill($appr_id, (int) $nl["base_skill_id"]);
                }
            }
        }
    }

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

Here is the call graph for this function:

writeAndAddSelfEvalSkills()

ilSurveySkill::writeAndAddSelfEvalSkills

(

int

$user_id

)

Write skills on self evaluation and add them to user's competence records.

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

     : void {
        if ($user_id > 0 && in_array($this->survey->getMode(), [ilObjSurvey::MODE_SELF_EVAL, ilObjSurvey::MODE_360], true)) {
            $new_levels = $this->determineSkillLevelsForAppraisee($user_id, true);
            foreach ($new_levels as $nl) {
                if (($nl["new_level_id"] ?? 0) > 0) {
                    ilBasicSkill::writeUserSkillLevelStatus(
                        (int) $nl["new_level_id"],
                        $user_id,
                        $this->survey->getRefId(),
                        (int) $nl["tref_id"],
                        ilBasicSkill::ACHIEVED,
                        true,
                        true,
                        "",
                        (float) $nl["next_level_perc"]
                    );
 
                    if (($nl["tref_id"] ?? 0) > 0) {
                        $this->skill_personal_service->addPersonalSkill($user_id, (int) $nl["tref_id"]);
                    } else {
                        $this->skill_personal_service->addPersonalSkill($user_id, (int) $nl["base_skill_id"]);
                    }
                }
            }
        }
    }

References $user_id, ilBasicSkill\ACHIEVED, and ilBasicSkill\writeUserSkillLevelStatus().

Here is the call graph for this function:

Field Documentation

$db

ilDBInterface ilSurveySkill::$db

protected

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

Referenced by read().

$log

ilLogger ilSurveySkill::$log

protected

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

$q_skill

array ilSurveySkill::$q_skill = array()

protected

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

$skill_personal_service

ILIAS Skill Service SkillPersonalService ilSurveySkill::$skill_personal_service

protected

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

$skill_profile_service

ILIAS Skill Service SkillProfileService ilSurveySkill::$skill_profile_service

protected

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

$skill_usage_service

ILIAS Skill Service SkillUsageService ilSurveySkill::$skill_usage_service

protected

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

$survey

ilObjSurvey ilSurveySkill::$survey

protected

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

---

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

• components/ILIAS/Survey/Skills/class.ilSurveySkill.php