ILIAS  release_5-1 Revision 5.0.0-5477-g43f3e3fab5f
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{
14 protected $q_skill = array(); // key: question id, value:
15 // array("base_skill_id" =>..., "tref_id" =>... )
16
23 function __construct(ilObjSurvey $a_survey)
24 {
25 $this->survey = $a_survey;
26 $this->read();
27 }
28
35 function read()
36 {
37 global $ilDB;
38
39 $set = $ilDB->query("SELECT * FROM svy_quest_skill ".
40 " WHERE survey_id = ".$ilDB->quote($this->survey->getId(), "integer")
41 );
42
43 include_once("./Modules/SurveyQuestionPool/classes/class.SurveyQuestion.php");
44
45 while ($rec = $ilDB->fetchAssoc($set))
46 {
47 if (SurveyQuestion::_questionExists($rec["q_id"]))
48 {
49 $this->q_skill[$rec["q_id"]] = array("q_id" => $rec["q_id"],
50 "base_skill_id" => $rec["base_skill_id"],
51 "tref_id" => $rec["tref_id"]);
52 }
53 }
54 }
55
62 function getSkillForQuestion($a_question_id)
63 {
64 if (isset($this->q_skill[$a_question_id]))
65 {
66 return $this->q_skill[$a_question_id];
67 }
68 return false;
69 }
70
77 function getQuestionsForSkill($a_base_skill_id, $a_tref_id)
78 {
79 $q_ids = array();
80 foreach ($this->q_skill as $q_id => $s)
81 {
82 if ($s["base_skill_id"] == $a_base_skill_id &&
83 $s["tref_id"] == $a_tref_id)
84 {
85 $q_ids[] = $q_id;
86 }
87 }
88 return $q_ids;
89 }
90
91
99 function addQuestionSkillAssignment($a_question_id, $a_base_skill_id, $a_tref_id)
100 {
101 global $ilDB;
102
103 $ilDB->replace("svy_quest_skill",
104 array("q_id" => array("integer", $a_question_id)),
105 array(
106 "survey_id" => array("integer", $this->survey->getId()),
107 "base_skill_id" => array("integer", $a_base_skill_id),
108 "tref_id" => array("integer", $a_tref_id)
109 )
110 );
111 $this->q_skill[$a_question_id] = array("q_id" => $a_question_id,
112 "base_skill_id" => $a_base_skill_id,
113 "tref_id" => $a_tref_id);
114
115 // add usage
116 include_once("./Services/Skill/classes/class.ilSkillUsage.php");
117 ilSkillUsage::setUsage($this->survey->getId(), $a_base_skill_id, $a_tref_id);
118
119 }
120
126 function removeQuestionSkillAssignment($a_question_id)
127 {
128 global $ilDB;
129
130 // read skills that are assigned to the quesiton
131 $set = $ilDB->query("SELECT * FROM svy_quest_skill ".
132 " WHERE q_id = ".$ilDB->quote($a_question_id, "integer")
133 );
134 $skills = array();
135 while ($rec = $ilDB->fetchAssoc($set))
136 {
137 $skills[] = array("skill_id" => $rec["base_skill_id"],
138 "tref_id" => $rec["tref_id"]);
139 }
140
141 // remove assignment of question
142 $ilDB->manipulate("DELETE FROM svy_quest_skill WHERE ".
143 " q_id = ".$ilDB->quote($a_question_id, "integer")
144 );
145 unset($this->q_skill[$a_question_id]);
146
147 $this->removeUsagesOfSkills($skills);
148 }
149
155 static function handleQuestionDeletion($a_question_id, $a_obj_id)
156 {
157 global $ilDB;
158 if (ilObject::_lookupType($a_obj_id) == "svy")
159 {
160 // mantis 11691
161 include_once './Modules/Survey/classes/class.ilObjSurvey.php';
162 $svy = new ilObjSurvey($a_obj_id, false);
163 $svy_skill = new ilSurveySkill($svy);
164 $svy_skill->removeQuestionSkillAssignment($a_question_id);
165 }
166 }
167
174 function removeUsagesOfSkills($a_skills)
175 {
176 $used_skills = array();
177 foreach ($a_skills as $skill)
178 {
179 if ($this->isSkillAssignedToQuestion($skill["skill_id"], $skill["tref_id"]))
180 {
181 $used_skills[] = $skill["skill_id"].":".$skill["tref_id"];
182 }
183 }
184 reset($a_skills);
185
186 // now remove all usages that have been confirmed
187 include_once("./Services/Skill/classes/class.ilSkillUsage.php");
188//var_dump($a_skills);
189//var_dump($used_skills); exit;
190 foreach ($a_skills as $skill)
191 {
192 if (!in_array($skill["skill_id"].":".$skill["tref_id"], $used_skills))
193 {
194 ilSkillUsage::setUsage($this->survey->getId(), $skill["skill_id"], $skill["tref_id"], false);
195 }
196 }
197 }
198
205 function isSkillAssignedToQuestion($a_skill_id, $a_tref_id)
206 {
207 global $ilDB;
208
209 $set = $ilDB->query("SELECT * FROM svy_quest_skill ".
210 " WHERE base_skill_id = ".$ilDB->quote($a_skill_id, "integer").
211 " AND tref_id = ".$ilDB->quote($a_tref_id, "integer").
212 " AND survey_id = ".$ilDB->quote($this->survey->getId(), "integer")
213 );
214 if ($rec = $ilDB->fetchAssoc($set))
215 {
216 return true;
217 }
218 return false;
219 }
220
221
229 {
230 $skills = array();
231 include_once("./Services/Skill/classes/class.ilBasicSkill.php");
232 foreach ($this->q_skill as $sk)
233 {
234 $skills[$sk["base_skill_id"].":".$sk["tref_id"]] =
235 ilBasicSkill::_lookupTitle($sk["base_skill_id"]);
236 }
237 return $skills;
238 }
239
246 function determineSkillLevelsForAppraisee($a_appraisee_id, $a_self_eval = false)
247 {
248 $skills = array();
249
250 // get all skills
251 $opts = $this->getAllAssignedSkillsAsOptions();
252 foreach ($opts as $k => $title)
253 {
254 $k = explode(":", $k);
255
256 $bs = new ilBasicSkill((int) $k[0]);
257 $ld = $bs->getLevelData();
258
259 $skills[] = array(
260 "base_skill_id" => (int) $k[0],
261 "tref_id" => (int) $k[1],
262 "skill_title" => $title,
263 "level_data" => $ld
264 );
265 }
266
267 if (!$a_self_eval)
268 {
269 $finished_ids = $this->survey->getFinishedIdsForAppraiseeId($a_appraisee_id, true);
270 }
271 else
272 {
273 $finished_id = $this->survey->getFinishedIdForAppraiseeIdAndRaterId($a_appraisee_id, $a_appraisee_id);
274 if ($finished_id > 0)
275 {
276 $finished_ids = array($finished_id);
277 }
278 }
279
280 if(!sizeof($finished_ids))
281 {
282 $finished_ids = array(-1);
283 }
284
285 $results = $this->survey->getUserSpecificResults($finished_ids);
286 foreach ($skills as $k => $s)
287 {
288 $q_ids = $this->getQuestionsForSkill($s["base_skill_id"], $s["tref_id"]);
289 $mean_sum = 0;
290 foreach ($q_ids as $q_id)
291 {
292 $qmean = 0;
293 if (is_array($results[$q_id]))
294 {
295 $cnt = 0;
296 $sum = 0;
297 foreach ($results[$q_id] as $r)
298 {
299 // this is a workaround, since we only get arrays from
300 // getUserSpecificResults()
301 $r = explode(" - ", $r);
302 $sum+= (int) $r[0];
303 $cnt++;
304 }
305 if ($cnt > 0)
306 {
307 $qmean = $sum/$cnt;
308 }
309 }
310 $mean_sum+= $qmean;
311 }
312 $skills[$k]["mean_sum"] = $mean_sum;
313
314 include_once("./Modules/Survey/classes/class.ilSurveySkillThresholds.php");
315 $skthr = new ilSurveySkillThresholds($this->survey);
316 $thresholds = $skthr->getThresholds();
317 foreach ($skills[$k]["level_data"] as $l)
318 {
319 $t = $thresholds[$l["id"]][$s["tref_id"]];
320 if ($t > 0 && $mean_sum >= $t)
321 {
322 $skills[$k]["new_level"] = $l["title"];
323 $skills[$k]["new_level_id"] = $l["id"];
324 }
325 }
326 }
327
328 return $skills;
329 }
330
331
338 function determineMaxScale($a_base_skill, $a_tref_id = 0)
339 {
340 include_once("./Modules/SurveyQuestionPool/classes/class.SurveyQuestion.php");
341 include_once("./Modules/Survey/classes/class.ilSurveySkill.php");
342 $ssk = new ilSurveySkill($this->survey);
343 $question_ids = $ssk->getQuestionsForSkill($a_base_skill, $a_tref_id);
344 $scale_sum = 0;
345 foreach ($question_ids as $q_id)
346 {
348 if(!is_object($q))
349 {
350 continue;
351 }
352 $cats = $q->getCategories();
353 $max_scale = 0;
354 for($i = 0; $i<= $cats->getCategoryCount(); $i++)
355 {
356 $c = $cats->getCategory($i);
357 $n = $c->neutral;
358 $s = $c->scale;
359 if (!$c->neutral)
360 {
361 if ($c->scale > $max_scale)
362 {
363 $max_scale = $c->scale;
364 }
365 }
366 }
367 $scale_sum+= $max_scale;
368 }
369
370 return $scale_sum;
371 }
372
379 function writeAppraiseeSkills($a_app_id)
380 {
381 // write raters evaluation
382 $new_levels = $this->determineSkillLevelsForAppraisee($a_app_id);
383 foreach ($new_levels as $nl)
384 {
385 if ($nl["new_level_id"] > 0)
386 {
387 ilBasicSkill::writeUserSkillLevelStatus($nl["new_level_id"],
388 $a_app_id, $this->survey->getRefId(), $nl["tref_id"], ilBasicSkill::ACHIEVED, true);
389 }
390 }
391
392 // write self evaluation
393 $new_levels = $this->determineSkillLevelsForAppraisee($a_app_id, true);
394 foreach ($new_levels as $nl)
395 {
396 if ($nl["new_level_id"] > 0)
397 {
398 ilBasicSkill::writeUserSkillLevelStatus($nl["new_level_id"],
399 $a_app_id, $this->survey->getRefId(), $nl["tref_id"], ilBasicSkill::ACHIEVED, true, 1);
400 }
401 }
402 }
403
404}
405
406?>
$n
Definition: RandomTest.php:80
global $l
Definition: afr.php:30
& _instanciateQuestion($question_id)
Creates an instance of a question with a given question id.
_questionExists($question_id)
Returns true if the question already exists in the database.
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=0, $a_unique_identifier="")
Write skill level status.
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.
$r
Definition: example_031.php:79
$results
global $ilDB