ILIAS  release_4-4 Revision
Public Member Functions | Static Public Member Functions
ilPersonalSkill Class Reference

Personal skill. More...

+ Inheritance diagram for ilPersonalSkill:
+ Collaboration diagram for ilPersonalSkill:

Public Member Functions

 addPersonalSkill ($a_user_id, $a_skill_node_id)
 Add personal skill. More...
 
 removeSkill ($a_user_id, $a_skill_node_id)
 Remove personal skill. More...
 

Static Public Member Functions

static getSelectedUserSkills ($a_user_id)
 Get personal selected user skills. More...
 
static assignMaterial ($a_user_id, $a_top_skill, $a_tref_id, $a_basic_skill, $a_level, $a_wsp_id)
 Assign material to skill level. More...
 
static getAssignedMaterial ($a_user_id, $a_tref_id, $a_level)
 Get assigned material (for a skill level and user) More...
 
static countAssignedMaterial ($a_user_id, $a_tref_id, $a_level)
 Get assigned material (for a skill level and user) More...
 
static removeMaterial ($a_user_id, $a_tref_id, $a_level_id, $a_wsp_id)
 Remove material. More...
 
static saveSelfEvaluation ($a_user_id, $a_top_skill, $a_tref_id, $a_basic_skill, $a_level)
 Save self evaluation. More...
 
static getSelfEvaluation ($a_user_id, $a_top_skill, $a_tref_id, $a_basic_skill)
 Get self evaluation. More...
 
static getSelfEvaluationDate ($a_user_id, $a_top_skill, $a_tref_id, $a_basic_skill)
 Get self evaluation. More...
 
static getUsageInfo ($a_cskill_ids, &$a_usages)
 Get usage info. More...
 

Detailed Description

Personal skill.

Author
Alex Killing alex..nosp@m.kill.nosp@m.ing@g.nosp@m.mx.d.nosp@m.e
Version
$Id$

Definition at line 14 of file class.ilPersonalSkill.php.

Member Function Documentation

◆ addPersonalSkill()

ilPersonalSkill::addPersonalSkill (   $a_user_id,
  $a_skill_node_id 
)

Add personal skill.

Parameters
int$a_user_id
int$a_skill_node_id

Definition at line 52 of file class.ilPersonalSkill.php.

Referenced by ilPersonalSkillsGUI\addSkill(), and ilObjPortfolioBase\clonePagesAndSettings().

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  }
+ Here is the caller graph for this function:

◆ assignMaterial()

static ilPersonalSkill::assignMaterial (   $a_user_id,
  $a_top_skill,
  $a_tref_id,
  $a_basic_skill,
  $a_level,
  $a_wsp_id 
)
static

Assign material to skill level.

Parameters
int$a_user_iduser id
int$a_top_skillthe "selectable" top skill
int$a_tref_idtemplate reference id
int$a_basic_skillthe basic skill the level belongs to
int$a_levellevel id
int$a_wsp_idworkspace object

Definition at line 102 of file class.ilPersonalSkill.php.

Referenced by ilPersonalSkillsGUI\selectMaterial().

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  }
+ Here is the caller graph for this function:

◆ countAssignedMaterial()

static ilPersonalSkill::countAssignedMaterial (   $a_user_id,
  $a_tref_id,
  $a_level 
)
static

Get assigned material (for a skill level and user)

Parameters
int$a_user_iduser id
int$a_tref_idtemplate reference id
int$a_levellevel id

Definition at line 159 of file class.ilPersonalSkill.php.

Referenced by ilPersonalSkillsGUI\renderMaterialsRow().

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  }
+ Here is the caller graph for this function:

◆ getAssignedMaterial()

static ilPersonalSkill::getAssignedMaterial (   $a_user_id,
  $a_tref_id,
  $a_level 
)
static

Get assigned material (for a skill level and user)

Parameters
int$a_user_iduser id
int$a_tref_idtemplate reference id
int$a_levellevel id

Definition at line 135 of file class.ilPersonalSkill.php.

Referenced by ilCOPageHTMLExport\collectPageElements(), ilSkillAssignMaterialsTableGUI\fillRow(), and ilPersonalSkillsGUI\renderMaterialsRow().

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  }
+ Here is the caller graph for this function:

◆ getSelectedUserSkills()

static ilPersonalSkill::getSelectedUserSkills (   $a_user_id)
static

Get personal selected user skills.

Parameters
int$a_user_iduser id
Returns
array

Definition at line 22 of file class.ilPersonalSkill.php.

References ilSkillTreeNode\_lookupTitle().

Referenced by ilPersonalSkillTableGUI\__construct(), ilObjPortfolioBase\clonePagesAndSettings(), ilObjPortfolioGUI\initCreatePortfolioFromTemplateForm(), ilPCSkillsGUI\initForm(), and ilPersonalSkillsGUI\listSkills().

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  }
ilSkillTree
Skill tree.
Definition: class.ilSkillTree.php:14
ilSkillTreeNode\_lookupTitle
static _lookupTitle($a_obj_id, $a_tref_id=0)
Lookup Title.
Definition: class.ilSkillTreeNode.php:227
+ Here is the call graph for this function:
+ Here is the caller graph for this function:

◆ getSelfEvaluation()

static ilPersonalSkill::getSelfEvaluation (   $a_user_id,
  $a_top_skill,
  $a_tref_id,
  $a_basic_skill 
)
static

Get self evaluation.

Parameters
int$a_user_iduser id
int$a_top_skillthe "selectable" top skill
int$a_tref_idtemplate reference id
int$a_basic_skillthe basic skill the level belongs to
Returns
int level id

Definition at line 246 of file class.ilPersonalSkill.php.

Referenced by ilSelfEvaluationSimpleTableGUI\__construct(), and ilPersonalSkillsGUI\renderSelfEvaluationRow().

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  }
+ Here is the caller graph for this function:

◆ getSelfEvaluationDate()

static ilPersonalSkill::getSelfEvaluationDate (   $a_user_id,
  $a_top_skill,
  $a_tref_id,
  $a_basic_skill 
)
static

Get self evaluation.

Parameters
int$a_user_iduser id
int$a_top_skillthe "selectable" top skill
int$a_tref_idtemplate reference id
int$a_basic_skillthe basic skill the level belongs to
Returns
int level id

Definition at line 270 of file class.ilPersonalSkill.php.

Referenced by ilPersonalSkillsGUI\getSkillHTML(), and ilPersonalSkillsGUI\renderSelfEvaluationRow().

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  }
+ Here is the caller graph for this function:

◆ getUsageInfo()

static ilPersonalSkill::getUsageInfo (   $a_cskill_ids,
&  $a_usages 
)
static

Get usage info.

Parameters
array$a_cskill_idsskill ids
array$a_usagesusages array

Implements ilSkillUsageInfo.

Definition at line 291 of file class.ilPersonalSkill.php.

References ilSkillTemplateReference\_lookupTemplateId(), ilSkillUsage\getUsageInfoGeneric(), ilSkillUsage\PERSONAL_SKILL, ilSkillUsage\SELF_EVAL, and ilSkillUsage\USER_MATERIAL.

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  }
ilSkillTemplateReference\_lookupTemplateId
static _lookupTemplateId($a_obj_id)
Lookup template ID.
Definition: class.ilSkillTemplateReference.php:133
ilSkillUsage\getUsageInfoGeneric
static getUsageInfoGeneric($a_cskill_ids, &$a_usages, $a_usage_type, $a_table, $a_key_field, $a_skill_field="skill_id", $a_tref_field="tref_id")
Get standard usage query.
Definition: class.ilSkillUsage.php:120
+ Here is the call graph for this function:

◆ removeMaterial()

static ilPersonalSkill::removeMaterial (   $a_user_id,
  $a_tref_id,
  $a_level_id,
  $a_wsp_id 
)
static

Remove material.

Parameters

Definition at line 178 of file class.ilPersonalSkill.php.

References $t.

Referenced by ilPersonalSkillsGUI\removeMaterial().

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  }
$t
$t
Definition: class.ilBMFType_duration.php:154
+ Here is the caller graph for this function:

◆ removeSkill()

ilPersonalSkill::removeSkill (   $a_user_id,
  $a_skill_node_id 
)

Remove personal skill.

Parameters
int$a_user_iduser id
int$a_skill_node_idthe "selectable" top skill

Definition at line 76 of file class.ilPersonalSkill.php.

Referenced by ilPersonalSkillsGUI\removeSkills().

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  }
+ Here is the caller graph for this function:

◆ saveSelfEvaluation()

static ilPersonalSkill::saveSelfEvaluation (   $a_user_id,
  $a_top_skill,
  $a_tref_id,
  $a_basic_skill,
  $a_level 
)
static

Save self evaluation.

Parameters
int$a_user_iduser id
int$a_top_skillthe "selectable" top skill
int$a_tref_idtemplate reference id
int$a_basic_skillthe basic skill the level belongs to
int$a_levellevel id

Definition at line 204 of file class.ilPersonalSkill.php.

References ilUtil\now().

Referenced by ilPersonalSkillsGUI\saveSelfEvaluation().

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  }
ilUtil\now
static now()
Return current timestamp in Y-m-d H:i:s format.
Definition: class.ilUtil.php:4210
+ Here is the call graph for this function:
+ Here is the caller graph for this function:
The documentation for this class was generated from the following file: