ILIAS  release_5-3 Revision v5.3.23-19-g915713cf615
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 include_once("./Modules/SurveyQuestionPool/classes/class.SurveyQuestion.php");
58
59 while ($rec = $ilDB->fetchAssoc($set)) {
60 if (SurveyQuestion::_questionExists($rec["q_id"])) {
61 $this->q_skill[$rec["q_id"]] = array("q_id" => $rec["q_id"],
62 "base_skill_id" => $rec["base_skill_id"],
63 "tref_id" => $rec["tref_id"]);
64 }
65 }
66 }
67
74 public function getSkillForQuestion($a_question_id)
75 {
76 if (isset($this->q_skill[$a_question_id])) {
77 return $this->q_skill[$a_question_id];
78 }
79 return false;
80 }
81
88 public function getQuestionsForSkill($a_base_skill_id, $a_tref_id)
89 {
90 $q_ids = array();
91 foreach ($this->q_skill as $q_id => $s) {
92 if ($s["base_skill_id"] == $a_base_skill_id &&
93 $s["tref_id"] == $a_tref_id) {
94 $q_ids[] = $q_id;
95 }
96 }
97 return $q_ids;
98 }
99
100
108 public function addQuestionSkillAssignment($a_question_id, $a_base_skill_id, $a_tref_id)
109 {
111
112 $ilDB->replace(
113 "svy_quest_skill",
114 array("q_id" => array("integer", $a_question_id)),
115 array(
116 "survey_id" => array("integer", $this->survey->getId()),
117 "base_skill_id" => array("integer", $a_base_skill_id),
118 "tref_id" => array("integer", $a_tref_id)
119 )
120 );
121 $this->q_skill[$a_question_id] = array("q_id" => $a_question_id,
122 "base_skill_id" => $a_base_skill_id,
123 "tref_id" => $a_tref_id);
124
125 // add usage
126 include_once("./Services/Skill/classes/class.ilSkillUsage.php");
127 ilSkillUsage::setUsage($this->survey->getId(), $a_base_skill_id, $a_tref_id);
128 }
129
135 public function removeQuestionSkillAssignment($a_question_id)
136 {
138
139 // read skills that are assigned to the quesiton
140 $set = $ilDB->query(
141 "SELECT * FROM svy_quest_skill " .
142 " WHERE q_id = " . $ilDB->quote($a_question_id, "integer")
143 );
144 $skills = array();
145 while ($rec = $ilDB->fetchAssoc($set)) {
146 $skills[] = array("skill_id" => $rec["base_skill_id"],
147 "tref_id" => $rec["tref_id"]);
148 }
149
150 // remove assignment of question
151 $ilDB->manipulate(
152 "DELETE FROM svy_quest_skill WHERE " .
153 " q_id = " . $ilDB->quote($a_question_id, "integer")
154 );
155 unset($this->q_skill[$a_question_id]);
156
157 $this->removeUsagesOfSkills($skills);
158 }
159
165 public static function handleQuestionDeletion($a_question_id, $a_obj_id)
166 {
167 global $DIC;
168
169 $ilDB = $DIC->database();
170 if (ilObject::_lookupType($a_obj_id) == "svy") {
171 // mantis 11691
172 include_once './Modules/Survey/classes/class.ilObjSurvey.php';
173 $svy = new ilObjSurvey($a_obj_id, false);
174 $svy_skill = new ilSurveySkill($svy);
175 $svy_skill->removeQuestionSkillAssignment($a_question_id);
176 }
177 }
178
185 public function removeUsagesOfSkills($a_skills)
186 {
187 $used_skills = array();
188 foreach ($a_skills as $skill) {
189 if ($this->isSkillAssignedToQuestion($skill["skill_id"], $skill["tref_id"])) {
190 $used_skills[] = $skill["skill_id"] . ":" . $skill["tref_id"];
191 }
192 }
193 reset($a_skills);
194
195 // now remove all usages that have been confirmed
196 include_once("./Services/Skill/classes/class.ilSkillUsage.php");
197 //var_dump($a_skills);
198 //var_dump($used_skills); exit;
199 foreach ($a_skills as $skill) {
200 if (!in_array($skill["skill_id"] . ":" . $skill["tref_id"], $used_skills)) {
201 ilSkillUsage::setUsage($this->survey->getId(), $skill["skill_id"], $skill["tref_id"], false);
202 }
203 }
204 }
205
212 public function isSkillAssignedToQuestion($a_skill_id, $a_tref_id)
213 {
215
216 $set = $ilDB->query(
217 "SELECT * FROM svy_quest_skill " .
218 " WHERE base_skill_id = " . $ilDB->quote($a_skill_id, "integer") .
219 " AND tref_id = " . $ilDB->quote($a_tref_id, "integer") .
220 " AND survey_id = " . $ilDB->quote($this->survey->getId(), "integer")
221 );
222 if ($rec = $ilDB->fetchAssoc($set)) {
223 return true;
224 }
225 return false;
226 }
227
228
236 {
237 $skills = array();
238 include_once("./Services/Skill/classes/class.ilBasicSkill.php");
239 foreach ($this->q_skill as $sk) {
240 $skills[$sk["base_skill_id"] . ":" . $sk["tref_id"]] =
241 ilBasicSkill::_lookupTitle($sk["base_skill_id"]);
242 }
243 return $skills;
244 }
245
252 public function determineSkillLevelsForAppraisee($a_appraisee_id, $a_self_eval = false)
253 {
254 $skills = array();
255
256 // get all skills
257 $opts = $this->getAllAssignedSkillsAsOptions();
258 foreach ($opts as $k => $title) {
259 $k = explode(":", $k);
260
261 $bs = new ilBasicSkill((int) $k[0]);
262 $ld = $bs->getLevelData();
263
264 $skills[] = array(
265 "base_skill_id" => (int) $k[0],
266 "tref_id" => (int) $k[1],
267 "skill_title" => $title,
268 "level_data" => $ld
269 );
270 }
271
272 if (!$a_self_eval) {
273 $finished_ids = $this->survey->getFinishedIdsForAppraiseeId($a_appraisee_id, true);
274 } else {
275 $finished_id = $this->survey->getFinishedIdForAppraiseeIdAndRaterId($a_appraisee_id, $a_appraisee_id);
276 if ($finished_id > 0) {
277 $finished_ids = array($finished_id);
278 }
279 }
280
281 if (!sizeof($finished_ids)) {
282 $finished_ids = array(-1);
283 }
284
285 $results = $this->survey->getUserSpecificResults($finished_ids);
286 $this->log->debug("Finished IDS: " . print_r($finished_ids, true));
287 foreach ($skills as $k => $s) {
288 $q_ids = $this->getQuestionsForSkill($s["base_skill_id"], $s["tref_id"]);
289 $this->log->debug("Skill: " . $s["base_skill_id"] . ":" . $s["tref_id"] . ", Questions: " . implode(",", $q_ids));
290 $mean_sum = 0;
291 foreach ($q_ids as $q_id) {
292 $qmean = 0;
293 if (is_array($results[$q_id])) {
294 $cnt = 0;
295 $sum = 0;
296 foreach ($results[$q_id] as $uid => $answer) { // answer of user $uid for question $q_id
297 // $answer has the scale values as keys and the answer texts as values.
298 // In case of single choice this is an array with one key => value pair.
299 // For multiple choice questions (currently not supported for being used for competences)
300 // multiple elements may be in the array (in the future).
301 $scale_values = array_keys($answer); // scale values of the answer
302 $this->log->debug("User answer (scale values): " . print_r($scale_values, true));
303 $sum += array_sum($scale_values);
304 $cnt += sizeof($scale_values); // nr of answers (always one in the case of single choice)
305 }
306 if ($cnt > 0) {
307 $qmean = $sum/$cnt;
308 }
309 $this->log->debug("MEAN: " . $qmean);
310 }
311 $mean_sum += $qmean;
312 $this->log->debug("MEAN SUM: " . $mean_sum);
313 }
314 $skills[$k]["mean_sum"] = $mean_sum;
315
316 include_once("./Modules/Survey/classes/class.ilSurveySkillThresholds.php");
317 $skthr = new ilSurveySkillThresholds($this->survey);
318 $thresholds = $skthr->getThresholds();
319 foreach ($skills[$k]["level_data"] as $l) {
320 $t = $thresholds[$l["id"]][$s["tref_id"]];
321 if ($t > 0 && $mean_sum >= $t) {
322 $skills[$k]["new_level"] = $l["title"];
323 $skills[$k]["new_level_id"] = $l["id"];
324 }
325 }
326 }
327 return $skills;
328 }
329
330
337 public function determineMaxScale($a_base_skill, $a_tref_id = 0)
338 {
339 include_once("./Modules/SurveyQuestionPool/classes/class.SurveyQuestion.php");
340 include_once("./Modules/Survey/classes/class.ilSurveySkill.php");
341 $ssk = new ilSurveySkill($this->survey);
342 $question_ids = $ssk->getQuestionsForSkill($a_base_skill, $a_tref_id);
343 $scale_sum = 0;
344 foreach ($question_ids as $q_id) {
346 if (!is_object($q)) {
347 continue;
348 }
349 $cats = $q->getCategories();
350 $max_scale = 0;
351 for ($i = 0; $i<= $cats->getCategoryCount(); $i++) {
352 $c = $cats->getCategory($i);
353 $n = $c->neutral;
354 $s = $c->scale;
355 if (!$c->neutral) {
356 if ($c->scale > $max_scale) {
357 $max_scale = $c->scale;
358 }
359 }
360 }
361 $scale_sum+= $max_scale;
362 }
363
364 return $scale_sum;
365 }
366
373 public function writeAppraiseeSkills($a_app_id)
374 {
375 // write raters evaluation
376 $new_levels = $this->determineSkillLevelsForAppraisee($a_app_id);
377 foreach ($new_levels as $nl) {
378 if ($nl["new_level_id"] > 0) {
380 $nl["new_level_id"],
381 $a_app_id,
382 $this->survey->getRefId(),
383 $nl["tref_id"],
385 true
386 );
387 }
388 }
389
390 // write self evaluation
391 $new_levels = $this->determineSkillLevelsForAppraisee($a_app_id, true);
392 foreach ($new_levels as $nl) {
393 if ($nl["new_level_id"] > 0) {
395 $nl["new_level_id"],
396 $a_app_id,
397 $this->survey->getRefId(),
398 $nl["tref_id"],
400 true,
401 1
402 );
403 }
404 }
405 }
406}
$n
Definition: RandomTest.php:85
global $l
Definition: afr.php:30
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.
static _lookupType($a_id, $a_reference=false)
lookup object type
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.
__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.
writeAppraiseeSkills($a_app_id)
Write appraisee skills.
getAllAssignedSkillsAsOptions()
Get skill for question.
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: disco.tpl.php:19
$s
Definition: pwgen.php:45
global $DIC
Definition: saml.php:7
global $ilDB
$results
Definition: svg-scanner.php:47