ILIAS  Release_5_0_x_branch Revision 61816
 All Data Structures Namespaces Files Functions Variables Groups Pages
class.ilPersonalSkill.php
Go to the documentation of this file.
1 <?php
2 
3 /* Copyright (c) 1998-2011 ILIAS open source, Extended GPL, see docs/LICENSE */
4 
5 include_once("./Services/Skill/interfaces/interface.ilSkillUsageInfo.php");
6 
14 class ilPersonalSkill implements ilSkillUsageInfo
15 {
22  static function getSelectedUserSkills($a_user_id)
23  {
24  global $ilDB;
25 
26  include_once "Services/Skill/classes/class.ilSkillTreeNode.php";
27 
28  include_once("./Services/Skill/classes/class.ilSkillTree.php");
29  $stree = new ilSkillTree();
30 
31  $set = $ilDB->query("SELECT * FROM skl_personal_skill ".
32  " WHERE user_id = ".$ilDB->quote($a_user_id, "integer")
33  );
34  $pskills = array();
35  while ($rec = $ilDB->fetchAssoc($set))
36  {
37  if ($stree->isInTree($rec["skill_node_id"]))
38  {
39  $pskills[$rec["skill_node_id"]] = array("skill_node_id" => $rec["skill_node_id"],
40  "title" => ilSkillTreeNode::_lookupTitle($rec["skill_node_id"]));
41  }
42  }
43  return $pskills;
44  }
45 
52  function addPersonalSkill($a_user_id, $a_skill_node_id)
53  {
54  global $ilDB;
55 
56  $set = $ilDB->query("SELECT * FROM skl_personal_skill ".
57  " WHERE user_id = ".$ilDB->quote($a_user_id, "integer").
58  " AND skill_node_id = ".$ilDB->quote($a_skill_node_id, "integer")
59  );
60  if (!$ilDB->fetchAssoc($set))
61  {
62  $ilDB->manipulate("INSERT INTO skl_personal_skill ".
63  "(user_id, skill_node_id) VALUES (".
64  $ilDB->quote($a_user_id, "integer").",".
65  $ilDB->quote($a_skill_node_id, "integer").
66  ")");
67  }
68  }
69 
76  function removeSkill($a_user_id, $a_skill_node_id)
77  {
78  global $ilDB;
79 
80  $ilDB->manipulate("DELETE FROM skl_personal_skill WHERE ".
81  " user_id = ".$ilDB->quote($a_user_id, "integer").
82  " AND skill_node_id = ".$ilDB->quote($a_skill_node_id, "integer")
83  );
84 
85  }
86 
87 
88  //
89  // Assigned materials
90  //
91 
102  static function assignMaterial($a_user_id, $a_top_skill, $a_tref_id, $a_basic_skill, $a_level, $a_wsp_id)
103  {
104  global $ilDB;
105 
106  $set = $ilDB->query("SELECT * FROM skl_assigned_material ".
107  " WHERE user_id = ".$ilDB->quote($a_user_id, "integer").
108  " AND top_skill_id = ".$ilDB->quote($a_top_skill, "integer").
109  " AND tref_id = ".$ilDB->quote((int) $a_tref_id, "integer").
110  " AND skill_id = ".$ilDB->quote($a_basic_skill, "integer").
111  " AND level_id = ".$ilDB->quote($a_level, "integer").
112  " AND wsp_id = ".$ilDB->quote($a_wsp_id, "integer")
113  );
114  if (!$ilDB->fetchAssoc($set))
115  {
116  $ilDB->manipulate("INSERT INTO skl_assigned_material ".
117  "(user_id, top_skill_id, tref_id, skill_id, level_id, wsp_id) VALUES (".
118  $ilDB->quote($a_user_id, "integer").",".
119  $ilDB->quote($a_top_skill, "integer").",".
120  $ilDB->quote((int) $a_tref_id, "integer").",".
121  $ilDB->quote($a_basic_skill, "integer").",".
122  $ilDB->quote($a_level, "integer").",".
123  $ilDB->quote($a_wsp_id, "integer").
124  ")");
125  }
126  }
127 
135  static function getAssignedMaterial($a_user_id, $a_tref_id, $a_level)
136  {
137  global $ilDB;
138 
139  $set = $ilDB->query("SELECT * FROM skl_assigned_material ".
140  " WHERE level_id = ".$ilDB->quote($a_level, "integer").
141  " AND tref_id = ".$ilDB->quote((int) $a_tref_id, "integer").
142  " AND user_id = ".$ilDB->quote($a_user_id, "integer")
143  );
144  $mat = array();
145  while ($rec = $ilDB->fetchAssoc($set))
146  {
147  $mat[] = $rec;
148  }
149  return $mat;
150  }
151 
159  static function countAssignedMaterial($a_user_id, $a_tref_id, $a_level)
160  {
161  global $ilDB;
162 
163  $set = $ilDB->query("SELECT count(*) as cnt FROM skl_assigned_material ".
164  " WHERE level_id = ".$ilDB->quote($a_level, "integer").
165  " AND tref_id = ".$ilDB->quote((int) $a_tref_id, "integer").
166  " AND user_id = ".$ilDB->quote($a_user_id, "integer")
167  );
168  $rec = $ilDB->fetchAssoc($set);
169  return $rec["cnt"];
170  }
171 
178  static function removeMaterial($a_user_id, $a_tref_id, $a_level_id, $a_wsp_id)
179  {
180  global $ilDB;
181 
182  $t = "DELETE FROM skl_assigned_material WHERE ".
183  " user_id = ".$ilDB->quote($a_user_id, "integer").
184  " AND tref_id = ".$ilDB->quote((int) $a_tref_id, "integer").
185  " AND level_id = ".$ilDB->quote($a_level_id, "integer").
186  " AND wsp_id = ".$ilDB->quote($a_wsp_id, "integer");
187 
188  $ilDB->manipulate($t);
189  }
190 
191  //
192  // Self evaluation
193  //
194 
204  static function saveSelfEvaluation($a_user_id, $a_top_skill, $a_tref_id, $a_basic_skill, $a_level)
205  {
206  global $ilDB;
207 
208  include_once("./Services/Skill/classes/class.ilBasicSkill.php");
209  ilBasicSkill::writeUserSkillLevelStatus($a_level, $a_user_id,
210  0, $a_tref_id, ilBasicSkill::ACHIEVED, false,
211  1);
212 
213  return;
214 
215  $set = $ilDB->query("SELECT * FROM skl_self_eval_level ".
216  " WHERE user_id = ".$ilDB->quote($a_user_id, "integer").
217  " AND top_skill_id = ".$ilDB->quote($a_top_skill, "integer").
218  " AND tref_id = ".$ilDB->quote((int) $a_tref_id, "integer").
219  " AND skill_id = ".$ilDB->quote($a_basic_skill, "integer"));
220  if (!$ilDB->fetchAssoc($set))
221  {
222  $ilDB->manipulate("INSERT INTO skl_self_eval_level ".
223  "(user_id, top_skill_id, tref_id, skill_id, level_id, last_update) VALUES (".
224  $ilDB->quote($a_user_id, "integer").",".
225  $ilDB->quote($a_top_skill, "integer").",".
226  $ilDB->quote((int) $a_tref_id, "integer").",".
227  $ilDB->quote($a_basic_skill, "integer").",".
228  $ilDB->quote($a_level, "integer").",".
229  $ilDB->quote(ilUtil::now(), "timestamp").
230  ")");
231  }
232  else
233  {
234  $ilDB->manipulate("UPDATE skl_self_eval_level SET ".
235  " level_id = ".$ilDB->quote($a_level, "integer").", ".
236  " last_update = ".$ilDB->quote(ilUtil::now(), "timestamp").
237  " WHERE user_id = ".$ilDB->quote($a_user_id, "integer").
238  " AND top_skill_id = ".$ilDB->quote($a_top_skill, "integer").
239  " AND tref_id = ".$ilDB->quote((int) $a_tref_id, "integer").
240  " AND skill_id = ".$ilDB->quote($a_basic_skill, "integer"));
241  }
242  }
243 
253  static function getSelfEvaluation($a_user_id, $a_top_skill, $a_tref_id, $a_basic_skill)
254  {
255  global $ilDB;
256 
257  include_once("./Services/Skill/classes/class.ilBasicSkill.php");
258  $bs = new ilBasicSkill($a_basic_skill);
259  return $bs->getLastLevelPerObject($a_tref_id, 0, $a_user_id, 1);
260 
261  $set = $ilDB->query("SELECT level_id FROM skl_self_eval_level ".
262  " WHERE user_id = ".$ilDB->quote($a_user_id, "integer").
263  " AND top_skill_id = ".$ilDB->quote($a_top_skill, "integer").
264  " AND tref_id = ".$ilDB->quote((int) $a_tref_id, "integer").
265  " AND skill_id = ".$ilDB->quote($a_basic_skill, "integer")
266  );
267  $rec = $ilDB->fetchAssoc($set);
268 
269  return (int) $rec["level_id"];
270  }
271 
281  static function getSelfEvaluationDate($a_user_id, $a_top_skill, $a_tref_id, $a_basic_skill)
282  {
283  global $ilDB;
284 
285  include_once("./Services/Skill/classes/class.ilBasicSkill.php");
286  $bs = new ilBasicSkill($a_basic_skill);
287  return $bs->getLastUpdatePerObject($a_tref_id, 0, $a_user_id, 1);
288 
289  $set = $ilDB->query("SELECT last_update FROM skl_self_eval_level ".
290  " WHERE user_id = ".$ilDB->quote($a_user_id, "integer").
291  " AND top_skill_id = ".$ilDB->quote($a_top_skill, "integer").
292  " AND tref_id = ".$ilDB->quote((int) $a_tref_id, "integer").
293  " AND skill_id = ".$ilDB->quote($a_basic_skill, "integer")
294  );
295  $rec = $ilDB->fetchAssoc($set);
296 
297  return $rec["last_update"];
298  }
299 
306  static public function getUsageInfo($a_cskill_ids, &$a_usages)
307  {
308  global $ilDB;
309 
310  // material
311  include_once("./Services/Skill/classes/class.ilSkillUsage.php");
312  ilSkillUsage::getUsageInfoGeneric($a_cskill_ids, $a_usages, ilSkillUsage::USER_MATERIAL,
313  "skl_assigned_material", "user_id");
314 
315  // self evaluations
316  ilSkillUsage::getUsageInfoGeneric($a_cskill_ids, $a_usages, ilSkillUsage::SELF_EVAL,
317  "skl_self_eval_level", "user_id");
318 
319  // users that use the skills as personal skills
320  $pskill_ids = array();
321  $tref_ids = array();
322  foreach ($a_cskill_ids as $cs)
323  {
324  if ($cs["tref_id"] > 0)
325  {
326  include_once("./Services/Skill/classes/class.ilSkillTemplateReference.php");
327  if (ilSkillTemplateReference::_lookupTemplateId($cs["tref_id"]) == $cs["skill_id"])
328  {
329  $pskill_ids[$cs["tref_id"]] = $cs["tref_id"];
330  $tref_ids[(int) $cs["tref_id"]] = $cs["skill_id"];
331  }
332  }
333  else
334  {
335  $pskill_ids[$cs["skill_id"]] = $cs["skill_id"];
336  }
337  }
338  $set = $ilDB->query("SELECT skill_node_id, user_id FROM skl_personal_skill ".
339  " WHERE ".$ilDB->in("skill_node_id", $pskill_ids, false, "integer").
340  " GROUP BY skill_node_id, user_id"
341  );
342  while ($rec = $ilDB->fetchAssoc($set))
343  {
344  if (isset($tref_ids[(int) $rec["skill_node_id"]]))
345  {
346  $a_usages[$tref_ids[$rec["skill_node_id"]].":".$rec["skill_node_id"]][ilSkillUsage::PERSONAL_SKILL][] =
347  array("key" => $rec["user_id"]);
348  }
349  else
350  {
351  $a_usages[$rec["skill_node_id"].":0"][ilSkillUsage::PERSONAL_SKILL][] =
352  array("key" => $rec["user_id"]);
353  }
354  }
355  }
356 
357 }
358 
359 ?>