ILIAS  Release_4_4_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  $set = $ilDB->query("SELECT * FROM skl_self_eval_level ".
209  " WHERE user_id = ".$ilDB->quote($a_user_id, "integer").
210  " AND top_skill_id = ".$ilDB->quote($a_top_skill, "integer").
211  " AND tref_id = ".$ilDB->quote((int) $a_tref_id, "integer").
212  " AND skill_id = ".$ilDB->quote($a_basic_skill, "integer"));
213  if (!$ilDB->fetchAssoc($set))
214  {
215  $ilDB->manipulate("INSERT INTO skl_self_eval_level ".
216  "(user_id, top_skill_id, tref_id, skill_id, level_id, last_update) VALUES (".
217  $ilDB->quote($a_user_id, "integer").",".
218  $ilDB->quote($a_top_skill, "integer").",".
219  $ilDB->quote((int) $a_tref_id, "integer").",".
220  $ilDB->quote($a_basic_skill, "integer").",".
221  $ilDB->quote($a_level, "integer").",".
222  $ilDB->quote(ilUtil::now(), "timestamp").
223  ")");
224  }
225  else
226  {
227  $ilDB->manipulate("UPDATE skl_self_eval_level SET ".
228  " level_id = ".$ilDB->quote($a_level, "integer").", ".
229  " last_update = ".$ilDB->quote(ilUtil::now(), "timestamp").
230  " WHERE user_id = ".$ilDB->quote($a_user_id, "integer").
231  " AND top_skill_id = ".$ilDB->quote($a_top_skill, "integer").
232  " AND tref_id = ".$ilDB->quote((int) $a_tref_id, "integer").
233  " AND skill_id = ".$ilDB->quote($a_basic_skill, "integer"));
234  }
235  }
236 
246  static function getSelfEvaluation($a_user_id, $a_top_skill, $a_tref_id, $a_basic_skill)
247  {
248  global $ilDB;
249 
250  $set = $ilDB->query("SELECT level_id FROM skl_self_eval_level ".
251  " WHERE user_id = ".$ilDB->quote($a_user_id, "integer").
252  " AND top_skill_id = ".$ilDB->quote($a_top_skill, "integer").
253  " AND tref_id = ".$ilDB->quote((int) $a_tref_id, "integer").
254  " AND skill_id = ".$ilDB->quote($a_basic_skill, "integer")
255  );
256  $rec = $ilDB->fetchAssoc($set);
257 
258  return (int) $rec["level_id"];
259  }
260 
270  static function getSelfEvaluationDate($a_user_id, $a_top_skill, $a_tref_id, $a_basic_skill)
271  {
272  global $ilDB;
273 
274  $set = $ilDB->query("SELECT last_update FROM skl_self_eval_level ".
275  " WHERE user_id = ".$ilDB->quote($a_user_id, "integer").
276  " AND top_skill_id = ".$ilDB->quote($a_top_skill, "integer").
277  " AND tref_id = ".$ilDB->quote((int) $a_tref_id, "integer").
278  " AND skill_id = ".$ilDB->quote($a_basic_skill, "integer")
279  );
280  $rec = $ilDB->fetchAssoc($set);
281 
282  return $rec["last_update"];
283  }
284 
291  static public function getUsageInfo($a_cskill_ids, &$a_usages)
292  {
293  global $ilDB;
294 
295  // material
296  include_once("./Services/Skill/classes/class.ilSkillUsage.php");
297  ilSkillUsage::getUsageInfoGeneric($a_cskill_ids, $a_usages, ilSkillUsage::USER_MATERIAL,
298  "skl_assigned_material", "user_id");
299 
300  // self evaluations
301  ilSkillUsage::getUsageInfoGeneric($a_cskill_ids, $a_usages, ilSkillUsage::SELF_EVAL,
302  "skl_self_eval_level", "user_id");
303 
304  // users that use the skills as personal skills
305  $pskill_ids = array();
306  $tref_ids = array();
307  foreach ($a_cskill_ids as $cs)
308  {
309  if ($cs["tref_id"] > 0)
310  {
311  include_once("./Services/Skill/classes/class.ilSkillTemplateReference.php");
312  if (ilSkillTemplateReference::_lookupTemplateId($cs["tref_id"]) == $cs["skill_id"])
313  {
314  $pskill_ids[$cs["tref_id"]] = $cs["tref_id"];
315  $tref_ids[(int) $cs["tref_id"]] = $cs["skill_id"];
316  }
317  }
318  else
319  {
320  $pskill_ids[$cs["skill_id"]] = $cs["skill_id"];
321  }
322  }
323  $set = $ilDB->query("SELECT skill_node_id, user_id FROM skl_personal_skill ".
324  " WHERE ".$ilDB->in("skill_node_id", $pskill_ids, false, "integer").
325  " GROUP BY skill_node_id, user_id"
326  );
327  while ($rec = $ilDB->fetchAssoc($set))
328  {
329  if (isset($tref_ids[(int) $rec["skill_node_id"]]))
330  {
331  $a_usages[$tref_ids[$rec["skill_node_id"]].":".$rec["skill_node_id"]][ilSkillUsage::PERSONAL_SKILL][] =
332  array("key" => $rec["user_id"]);
333  }
334  else
335  {
336  $a_usages[$rec["skill_node_id"].":0"][ilSkillUsage::PERSONAL_SKILL][] =
337  array("key" => $rec["user_id"]);
338  }
339  }
340  }
341 
342 }
343 
344 ?>