ILIAS  release_6 Revision v6.24-5-g0c8bfefb3b8
class.ilSurveySkill.php
Go to the documentation of this file.
1<?php
2
3/* Copyright (c) 1998-2012 ILIAS open source, Extended GPL, see docs/LICENSE */
4
13{
17 protected $db;
18
19 protected $q_skill = array(); // key: question id, value:
20 // array("base_skill_id" =>..., "tref_id" =>... )
24 protected $log;
25
32 public function __construct(ilObjSurvey $a_survey)
33 {
34 global $DIC;
35
36 $this->db = $DIC->database();
37 $this->survey = $a_survey;
38 $this->read();
39 $this->log = ilLoggerFactory::getLogger("svy");
40 }
41
48 public function read()
49 {
51
52 $set = $ilDB->query(
53 "SELECT * FROM svy_quest_skill " .
54 " WHERE survey_id = " . $ilDB->quote($this->survey->getId(), "integer")
55 );
56
57 while ($rec = $ilDB->fetchAssoc($set)) {
58 if (SurveyQuestion::_questionExists($rec["q_id"])) {
59 $this->q_skill[$rec["q_id"]] = array("q_id" => $rec["q_id"],
60 "base_skill_id" => $rec["base_skill_id"],
61 "tref_id" => $rec["tref_id"]);
62 }
63 }
64 }
65
72 public function getSkillForQuestion($a_question_id)
73 {
74 if (isset($this->q_skill[$a_question_id])) {
75 return $this->q_skill[$a_question_id];
76 }
77 return false;
78 }
79
86 public function getQuestionsForSkill($a_base_skill_id, $a_tref_id)
87 {
88 $q_ids = array();
89 foreach ($this->q_skill as $q_id => $s) {
90 if ($s["base_skill_id"] == $a_base_skill_id &&
91 $s["tref_id"] == $a_tref_id) {
92 $q_ids[] = $q_id;
93 }
94 }
95 return $q_ids;
96 }
97
98
106 public function addQuestionSkillAssignment($a_question_id, $a_base_skill_id, $a_tref_id)
107 {
109
110 $ilDB->replace(
111 "svy_quest_skill",
112 array("q_id" => array("integer", $a_question_id)),
113 array(
114 "survey_id" => array("integer", $this->survey->getId()),
115 "base_skill_id" => array("integer", $a_base_skill_id),
116 "tref_id" => array("integer", $a_tref_id)
117 )
118 );
119 $this->q_skill[$a_question_id] = array("q_id" => $a_question_id,
120 "base_skill_id" => $a_base_skill_id,
121 "tref_id" => $a_tref_id);
122
123 // add usage
124 ilSkillUsage::setUsage($this->survey->getId(), $a_base_skill_id, $a_tref_id);
125 }
126
132 public function removeQuestionSkillAssignment($a_question_id)
133 {
135
136 // read skills that are assigned to the quesiton
137 $set = $ilDB->query(
138 "SELECT * FROM svy_quest_skill " .
139 " WHERE q_id = " . $ilDB->quote($a_question_id, "integer")
140 );
141 $skills = array();
142 while ($rec = $ilDB->fetchAssoc($set)) {
143 $skills[] = array("skill_id" => $rec["base_skill_id"],
144 "tref_id" => $rec["tref_id"]);
145 }
146
147 // remove assignment of question
148 $ilDB->manipulate(
149 "DELETE FROM svy_quest_skill WHERE " .
150 " q_id = " . $ilDB->quote($a_question_id, "integer")
151 );
152 unset($this->q_skill[$a_question_id]);
153
154 $this->removeUsagesOfSkills($skills);
155 }
156
162 public static function handleQuestionDeletion($a_question_id, $a_obj_id)
163 {
164 global $DIC;
165
166 $ilDB = $DIC->database();
167 if (ilObject::_lookupType($a_obj_id) == "svy") {
168 // mantis 11691
169 $svy = new ilObjSurvey($a_obj_id, false);
170 $svy_skill = new ilSurveySkill($svy);
171 $svy_skill->removeQuestionSkillAssignment($a_question_id);
172 }
173 }
174
181 public function removeUsagesOfSkills($a_skills)
182 {
183 $used_skills = array();
184 foreach ($a_skills as $skill) {
185 if ($this->isSkillAssignedToQuestion($skill["skill_id"], $skill["tref_id"])) {
186 $used_skills[] = $skill["skill_id"] . ":" . $skill["tref_id"];
187 }
188 }
189 reset($a_skills);
190
191 // now remove all usages that have been confirmed
192 foreach ($a_skills as $skill) {
193 if (!in_array($skill["skill_id"] . ":" . $skill["tref_id"], $used_skills)) {
194 ilSkillUsage::setUsage($this->survey->getId(), $skill["skill_id"], $skill["tref_id"], false);
195 }
196 }
197 }
198
205 public function isSkillAssignedToQuestion($a_skill_id, $a_tref_id)
206 {
208
209 $set = $ilDB->query(
210 "SELECT * FROM svy_quest_skill " .
211 " WHERE base_skill_id = " . $ilDB->quote($a_skill_id, "integer") .
212 " AND tref_id = " . $ilDB->quote($a_tref_id, "integer") .
213 " AND survey_id = " . $ilDB->quote($this->survey->getId(), "integer")
214 );
215 if ($rec = $ilDB->fetchAssoc($set)) {
216 return true;
217 }
218 return false;
219 }
220
221
229 {
230 $skills = array();
231 foreach ($this->q_skill as $sk) {
232 $skills[$sk["base_skill_id"] . ":" . $sk["tref_id"]] =
233 ilBasicSkill::_lookupTitle($sk["base_skill_id"]);
234 }
235 return $skills;
236 }
237
244 public function determineSkillLevelsForAppraisee($a_appraisee_id, $a_self_eval = false)
245 {
246 $skills = array();
247
248 // get all skills
249 $opts = $this->getAllAssignedSkillsAsOptions();
250 foreach ($opts as $k => $title) {
251 $k = explode(":", $k);
252
253 $bs = new ilBasicSkill((int) $k[0]);
254 $ld = $bs->getLevelData();
255
256 $skills[] = array(
257 "base_skill_id" => (int) $k[0],
258 "tref_id" => (int) $k[1],
259 "skill_title" => $title,
260 "level_data" => $ld
261 );
262 }
263
264 if (!$a_self_eval) {
265 $finished_ids = $this->survey->getFinishedIdsForAppraiseeId($a_appraisee_id, true);
266 } else {
267 $finished_id = $this->survey->getFinishedIdForAppraiseeIdAndRaterId($a_appraisee_id, $a_appraisee_id);
268 if ($finished_id > 0) {
269 $finished_ids = array($finished_id);
270 }
271 }
272
273 if (!is_array($finished_ids)) {
274 $finished_ids = array(-1);
275 }
276
277 $results = $this->survey->getUserSpecificResults($finished_ids);
278 $this->log->debug("Finished IDS: " . print_r($finished_ids, true));
279 foreach ($skills as $k => $s) {
280 $q_ids = $this->getQuestionsForSkill($s["base_skill_id"], $s["tref_id"]);
281 $this->log->debug("Skill: " . $s["base_skill_id"] . ":" . $s["tref_id"] . ", Questions: " . implode(",", $q_ids));
282 $mean_sum = 0;
283 foreach ($q_ids as $q_id) {
284 $qmean = 0;
285 if (is_array($results[$q_id])) {
286 $cnt = 0;
287 $sum = 0;
288 foreach ($results[$q_id] as $uid => $answer) { // answer of user $uid for question $q_id
289 // $answer has the scale values as keys and the answer texts as values.
290 // In case of single choice this is an array with one key => value pair.
291 // For multiple choice questions (currently not supported for being used for competences)
292 // multiple elements may be in the array (in the future).
293 $scale_values = array_keys($answer); // scale values of the answer
294 $this->log->debug("User answer (scale values): " . print_r($scale_values, true));
295 $sum += array_sum($scale_values);
296 $cnt += sizeof($scale_values); // nr of answers (always one in the case of single choice)
297 }
298 if ($cnt > 0) {
299 $qmean = $sum / $cnt;
300 }
301 $this->log->debug("MEAN: " . $qmean);
302 }
303 $mean_sum += $qmean;
304 $this->log->debug("MEAN SUM: " . $mean_sum);
305 }
306 $skills[$k]["mean_sum"] = $mean_sum;
307
308 $skthr = new ilSurveySkillThresholds($this->survey);
309 $thresholds = $skthr->getThresholds();
310 foreach ($skills[$k]["level_data"] as $l) {
311 $t = $thresholds[$l["id"]][$s["tref_id"]];
312 if ($t > 0 && $mean_sum >= $t) {
313 $skills[$k]["new_level"] = $l["title"];
314 $skills[$k]["new_level_id"] = $l["id"];
315 }
316 }
317 }
318 return $skills;
319 }
320
321
328 public function determineMaxScale($a_base_skill, $a_tref_id = 0)
329 {
330 $ssk = new ilSurveySkill($this->survey);
331 $question_ids = $ssk->getQuestionsForSkill($a_base_skill, $a_tref_id);
332 $scale_sum = 0;
333 foreach ($question_ids as $q_id) {
335 if (!is_object($q)) {
336 continue;
337 }
338 $cats = $q->getCategories();
339 $max_scale = 0;
340 for ($i = 0; $i <= $cats->getCategoryCount(); $i++) {
341 $c = $cats->getCategory($i);
342 $n = $c->neutral;
343 $s = $c->scale;
344 if (!$c->neutral) {
345 if ($c->scale > $max_scale) {
346 $max_scale = $c->scale;
347 }
348 }
349 }
350 $scale_sum += $max_scale;
351 }
352
353 return $scale_sum;
354 }
355
361 public function writeAndAddAppraiseeSkills(int $user_id)
362 {
363 // write raters evaluation
364 $new_levels = $this->determineSkillLevelsForAppraisee($user_id);
365 foreach ($new_levels as $nl) {
366 if ($nl["new_level_id"] > 0) {
368 $nl["new_level_id"],
369 $user_id,
370 $this->survey->getRefId(),
371 $nl["tref_id"],
373 true
374 );
375
376 if ($nl["tref_id"] > 0) {
377 ilPersonalSkill::addPersonalSkill($user_id, $nl["tref_id"]);
378 } else {
379 ilPersonalSkill::addPersonalSkill($user_id, $nl["base_skill_id"]);
380 }
381 }
382 }
383
384 // write self evaluation
385 $this->writeAndAddSelfEvalSkills($user_id);
386 }
387
393 public function writeAndAddSelfEvalSkills(int $user_id)
394 {
395 if ($user_id > 0 && in_array($this->survey->getMode(), [ilObjSurvey::MODE_SELF_EVAL, ilObjSurvey::MODE_360])) {
396 $new_levels = $this->determineSkillLevelsForAppraisee($user_id, true);
397 foreach ($new_levels as $nl) {
398 if ($nl["new_level_id"] > 0) {
400 $nl["new_level_id"],
401 $user_id,
402 $this->survey->getRefId(),
403 $nl["tref_id"],
405 true,
406 1
407 );
408
409 if ($nl["tref_id"] > 0) {
410 ilPersonalSkill::addPersonalSkill($user_id, $nl["tref_id"]);
411 } else {
412 ilPersonalSkill::addPersonalSkill($user_id, $nl["base_skill_id"]);
413 }
414 }
415 }
416 }
417 }
418}
$n
Definition: RandomTest.php:85
An exception for terminatinating execution or to throw for unit testing.
static _questionExists($question_id)
Returns true if the question already exists in the database.
static _instanciateQuestion($question_id)
Creates an instance of a question with a given question id.
static writeUserSkillLevelStatus( $a_level_id, $a_user_id, $a_trigger_ref_id, $a_tref_id=0, $a_status=ilBasicSkill::ACHIEVED, $a_force=false, $a_self_eval=false, $a_unique_identifier="")
Write skill level status.
static getLogger($a_component_id)
Get component logger.
Class ilObjSurvey.
static _lookupType($a_id, $a_reference=false)
lookup object type
static addPersonalSkill($a_user_id, $a_skill_node_id)
Add personal skill.
static _lookupTitle($a_obj_id, $a_tref_id=0)
Lookup Title.
static setUsage($a_obj_id, $a_skill_id, $a_tref_id, $a_use=true)
Set usage.
Skill tresholds for 360 surveys.
Skill/Competence handling in surveys.
isSkillAssignedToQuestion($a_skill_id, $a_tref_id)
Is skill assigned to any question?
removeUsagesOfSkills($a_skills)
Remove usages of skills.
writeAndAddAppraiseeSkills(int $user_id)
Write appraisee skills and add them to user's competence records.
__construct(ilObjSurvey $a_survey)
Constructor.
determineSkillLevelsForAppraisee($a_appraisee_id, $a_self_eval=false)
Determine skill levels for appraisee.
static handleQuestionDeletion($a_question_id, $a_obj_id)
Remove question skill assignment.
getAllAssignedSkillsAsOptions()
Get skill for question.
writeAndAddSelfEvalSkills(int $user_id)
Write skills on self evaluation and add them to user's competence records.
getQuestionsForSkill($a_base_skill_id, $a_tref_id)
Get questions for skill.
removeQuestionSkillAssignment($a_question_id)
Remove question skill assignment.
determineMaxScale($a_base_skill, $a_tref_id=0)
Determine max scales and questions.
addQuestionSkillAssignment($a_question_id, $a_base_skill_id, $a_tref_id)
Add survey question to skill assignment.
getSkillForQuestion($a_question_id)
Get skill for question.
$i
Definition: metadata.php:24
$results
global $ilDB
$DIC
Definition: xapitoken.php:46