ILIAS  release_7 Revision v7.30-3-g800a261c036
•All Data Structures Namespaces Files Functions Variables Modules Pages
Public Member Functions | Protected Attributes
ilBasicSkillUserLevelDBRepository Class Reference
+ Inheritance diagram for ilBasicSkillUserLevelDBRepository:
+ Collaboration diagram for ilBasicSkillUserLevelDBRepository:

Public Member Functions

 __construct (ilDBInterface $db=null)
 
 deleteUserLevelsOfSkill (int $skill_id)
 
 resetUserSkillLevelStatus (bool $update, int $trigger_obj_id, $status_date, int $a_user_id, int $a_skill_id, int $a_tref_id=0, int $a_trigger_ref_id=0, bool $a_self_eval=false)
 
 hasRecentSelfEvaluation (int $trigger_obj_id, int $a_user_id, int $a_skill_id, int $a_tref_id=0, int $a_trigger_ref_id=0)
 
 getNewAchievementsPerUser (string $a_timestamp, string $a_timestamp_to=null, int $a_user_id=0, int $a_self_eval=0)
 
 writeUserSkillLevelStatus (int $skill_id, int $trigger_ref_id, int $trigger_obj_id, ?string $trigger_title, ?string $trigger_type, bool $update, $status_date, int $a_level_id, int $a_user_id, int $a_tref_id=0, bool $a_self_eval=false, string $a_unique_identifier="", float $a_next_level_fulfilment=0.0)
 
 removeAllUserSkillLevelStatusOfObject (int $a_user_id, int $a_trigger_obj_id, bool $a_self_eval=false, string $a_unique_identifier="")
 
 removeAllUserData (int $a_user_id)
 
 getMaxLevelPerType (int $skill_id, array $levels, int $a_tref_id, string $a_type, int $a_user_id=0, int $a_self_eval=0)
 
 getAllLevelEntriesOfUser (int $skill_id, int $a_tref_id, int $a_user_id=0, int $a_self_eval=0)
 
 getAllHistoricLevelEntriesOfUser (int $skill_id, int $a_tref_id, int $a_user_id=0, int $a_eval_by=0)
 
 getMaxLevelPerObject (int $skill_id, array $levels, int $a_tref_id, int $a_object_id, int $a_user_id=0, int $a_self_eval=0)
 
 getMaxLevel (int $skill_id, array $levels, int $a_tref_id, int $a_user_id=0, int $a_self_eval=0)
 
 hasSelfEvaluated (int $a_user_id, int $a_skill_id, int $a_tref_id)
 
 getLastLevelPerObject (int $skill_id, int $a_tref_id, int $a_object_id, int $a_user_id=0, int $a_self_eval=0)
 
 getLastUpdatePerObject (int $skill_id, int $a_tref_id, int $a_object_id, int $a_user_id=0, int $a_self_eval=0)
 

Protected Attributes

 $db
 

Detailed Description

Definition at line 3 of file class.ilBasicSkillUserLevelDBRepository.php.

Constructor & Destructor Documentation

◆ __construct()

ilBasicSkillUserLevelDBRepository::__construct ( ilDBInterface  $db = null)

Definition at line 10 of file class.ilBasicSkillUserLevelDBRepository.php.

References $db, and $DIC.

11  {
12  global $DIC;
13 
14  $this->db = ($db)
15  ? $db
16  : $DIC->database();
17  }
$DIC
global $DIC
Definition: goto.php:24

Member Function Documentation

◆ deleteUserLevelsOfSkill()

ilBasicSkillUserLevelDBRepository::deleteUserLevelsOfSkill ( int  $skill_id)

Implements ilBasicSkillUserLevelRepository.

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

References $db, and $ilDB.

23  {
24  $ilDB = $this->db;
25 
26  $ilDB->manipulate("DELETE FROM skl_user_has_level WHERE "
27  . " skill_id = " . $ilDB->quote($skill_id, "integer")
28  );
29  }
$ilDB
global $ilDB
Definition: storeScorm2004.php:16

◆ getAllHistoricLevelEntriesOfUser()

ilBasicSkillUserLevelDBRepository::getAllHistoricLevelEntriesOfUser ( int  $skill_id,
int  $a_tref_id,
int  $a_user_id = 0,
int  $a_eval_by = 0 
)

Implements ilBasicSkillUserLevelRepository.

Definition at line 374 of file class.ilBasicSkillUserLevelDBRepository.php.

References $db, $ilDB, and ilBasicSkill\EVAL_BY_ALL.

379  : array {
380  $ilDB = $this->db;
381 
382  $by = ($a_eval_by != ilBasicSkill::EVAL_BY_ALL)
383  ? " AND self_eval = " . $ilDB->quote($a_self_eval, "integer")
384  : "";
385 
386  $set = $ilDB->query($q = "SELECT * FROM skl_user_skill_level " .
387  " WHERE skill_id = " . $ilDB->quote($skill_id, "integer") .
388  " AND tref_id = " . $ilDB->quote((int) $a_tref_id, "integer") .
389  " AND user_id = " . $ilDB->quote($a_user_id, "integer") .
390  $by .
391  " ORDER BY status_date DESC"
392  );
393  $levels = array();
394  while ($rec = $ilDB->fetchAssoc($set)) {
395  $levels[] = $rec;
396  }
397  return $levels;
398  }
$ilDB
global $ilDB
Definition: storeScorm2004.php:16

◆ getAllLevelEntriesOfUser()

ilBasicSkillUserLevelDBRepository::getAllLevelEntriesOfUser ( int  $skill_id,
int  $a_tref_id,
int  $a_user_id = 0,
int  $a_self_eval = 0 
)

Implements ilBasicSkillUserLevelRepository.

Definition at line 348 of file class.ilBasicSkillUserLevelDBRepository.php.

References $db, and $ilDB.

353  : array {
354  $ilDB = $this->db;
355 
356  $set = $ilDB->query($q = "SELECT * FROM skl_user_has_level " .
357  " WHERE skill_id = " . $ilDB->quote($skill_id, "integer") .
358  " AND tref_id = " . $ilDB->quote((int) $a_tref_id, "integer") .
359  " AND user_id = " . $ilDB->quote($a_user_id, "integer") .
360  " AND self_eval = " . $ilDB->quote($a_self_eval, "integer") .
361  " ORDER BY status_date DESC"
362  );
363 
364  $levels = array();
365  while ($rec = $ilDB->fetchAssoc($set)) {
366  $levels[] = $rec;
367  }
368  return $levels;
369  }
$ilDB
global $ilDB
Definition: storeScorm2004.php:16

◆ getLastLevelPerObject()

ilBasicSkillUserLevelDBRepository::getLastLevelPerObject ( int  $skill_id,
int  $a_tref_id,
int  $a_object_id,
int  $a_user_id = 0,
int  $a_self_eval = 0 
)

Implements ilBasicSkillUserLevelRepository.

Definition at line 489 of file class.ilBasicSkillUserLevelDBRepository.php.

References $db, and $ilDB.

495  : ?int {
496  $ilDB = $this->db;
497 
498  $ilDB->setLimit(1);
499  $set = $ilDB->query($q = "SELECT level_id FROM skl_user_has_level " .
500  " WHERE trigger_obj_id = " . $ilDB->quote($a_object_id, "integer") .
501  " AND skill_id = " . $ilDB->quote($skill_id, "integer") .
502  " AND tref_id = " . $ilDB->quote((int) $a_tref_id, "integer") .
503  " AND user_id = " . $ilDB->quote($a_user_id, "integer") .
504  " AND self_eval = " . $ilDB->quote($a_self_eval, "integer") .
505  " ORDER BY status_date DESC"
506  );
507 
508  $rec = $ilDB->fetchAssoc($set);
509 
510  return $rec["level_id"];
511  }
$ilDB
global $ilDB
Definition: storeScorm2004.php:16

◆ getLastUpdatePerObject()

ilBasicSkillUserLevelDBRepository::getLastUpdatePerObject ( int  $skill_id,
int  $a_tref_id,
int  $a_object_id,
int  $a_user_id = 0,
int  $a_self_eval = 0 
)

Implements ilBasicSkillUserLevelRepository.

Definition at line 516 of file class.ilBasicSkillUserLevelDBRepository.php.

References $db, and $ilDB.

522  : ?string {
523  $ilDB = $this->db;
524 
525  $ilDB->setLimit(1);
526  $set = $ilDB->query($q = "SELECT status_date FROM skl_user_has_level " .
527  " WHERE trigger_obj_id = " . $ilDB->quote($a_object_id, "integer") .
528  " AND skill_id = " . $ilDB->quote($skill_id, "integer") .
529  " AND tref_id = " . $ilDB->quote((int) $a_tref_id, "integer") .
530  " AND user_id = " . $ilDB->quote($a_user_id, "integer") .
531  " AND self_eval = " . $ilDB->quote($a_self_eval, "integer") .
532  " ORDER BY status_date DESC"
533  );
534 
535  $rec = $ilDB->fetchAssoc($set);
536 
537  return $rec["status_date"];
538  }
$ilDB
global $ilDB
Definition: storeScorm2004.php:16

◆ getMaxLevel()

ilBasicSkillUserLevelDBRepository::getMaxLevel ( int  $skill_id,
array  $levels,
int  $a_tref_id,
int  $a_user_id = 0,
int  $a_self_eval = 0 
)

Implements ilBasicSkillUserLevelRepository.

Definition at line 437 of file class.ilBasicSkillUserLevelDBRepository.php.

References $db, and $ilDB.

443  : int {
444  $ilDB = $this->db;
445 
446  $set = $ilDB->query($q = "SELECT level_id FROM skl_user_has_level " .
447  " WHERE skill_id = " . $ilDB->quote($skill_id, "integer") .
448  " AND tref_id = " . $ilDB->quote((int) $a_tref_id, "integer") .
449  " AND user_id = " . $ilDB->quote($a_user_id, "integer") .
450  " AND self_eval = " . $ilDB->quote($a_self_eval, "integer")
451  );
452 
453  $has_level = array();
454  while ($rec = $ilDB->fetchAssoc($set)) {
455  $has_level[$rec["level_id"]] = true;
456  }
457  $max_level = 0;
458  foreach ($levels as $l) {
459  if (isset($has_level[$l["id"]])) {
460  $max_level = $l["id"];
461  }
462  }
463  return $max_level;
464  }
$ilDB
global $ilDB
Definition: storeScorm2004.php:16

◆ getMaxLevelPerObject()

ilBasicSkillUserLevelDBRepository::getMaxLevelPerObject ( int  $skill_id,
array  $levels,
int  $a_tref_id,
int  $a_object_id,
int  $a_user_id = 0,
int  $a_self_eval = 0 
)

Implements ilBasicSkillUserLevelRepository.

Definition at line 403 of file class.ilBasicSkillUserLevelDBRepository.php.

References $db, and $ilDB.

410  : int {
411  $ilDB = $this->db;
412 
413  $set = $ilDB->query($q = "SELECT level_id FROM skl_user_has_level " .
414  " WHERE trigger_obj_id = " . $ilDB->quote($a_object_id, "integer") .
415  " AND skill_id = " . $ilDB->quote($skill_id, "integer") .
416  " AND tref_id = " . $ilDB->quote((int) $a_tref_id, "integer") .
417  " AND user_id = " . $ilDB->quote($a_user_id, "integer") .
418  " AND self_eval = " . $ilDB->quote($a_self_eval, "integer")
419  );
420 
421  $has_level = array();
422  while ($rec = $ilDB->fetchAssoc($set)) {
423  $has_level[$rec["level_id"]] = true;
424  }
425  $max_level = 0;
426  foreach ($levels as $l) {
427  if (isset($has_level[$l["id"]])) {
428  $max_level = $l["id"];
429  }
430  }
431  return $max_level;
432  }
$ilDB
global $ilDB
Definition: storeScorm2004.php:16

◆ getMaxLevelPerType()

ilBasicSkillUserLevelDBRepository::getMaxLevelPerType ( int  $skill_id,
array  $levels,
int  $a_tref_id,
string  $a_type,
int  $a_user_id = 0,
int  $a_self_eval = 0 
)

Implements ilBasicSkillUserLevelRepository.

Definition at line 314 of file class.ilBasicSkillUserLevelDBRepository.php.

References $db, and $ilDB.

321  : int {
322  $ilDB = $this->db;
323 
324  $set = $ilDB->query($q = "SELECT level_id FROM skl_user_has_level " .
325  " WHERE trigger_obj_type = " . $ilDB->quote($a_type, "text") .
326  " AND skill_id = " . $ilDB->quote($skill_id, "integer") .
327  " AND tref_id = " . $ilDB->quote((int) $a_tref_id, "integer") .
328  " AND user_id = " . $ilDB->quote($a_user_id, "integer") .
329  " AND self_eval = " . $ilDB->quote($a_self_eval, "integer")
330  );
331 
332  $has_level = array();
333  while ($rec = $ilDB->fetchAssoc($set)) {
334  $has_level[$rec["level_id"]] = true;
335  }
336  $max_level = 0;
337  foreach ($levels as $l) {
338  if (isset($has_level[$l["id"]])) {
339  $max_level = $l["id"];
340  }
341  }
342  return $max_level;
343  }
$ilDB
global $ilDB
Definition: storeScorm2004.php:16

◆ getNewAchievementsPerUser()

ilBasicSkillUserLevelDBRepository::getNewAchievementsPerUser ( string  $a_timestamp,
string  $a_timestamp_to = null,
int  $a_user_id = 0,
int  $a_self_eval = 0 
)

Implements ilBasicSkillUserLevelRepository.

Definition at line 130 of file class.ilBasicSkillUserLevelDBRepository.php.

References $db, $ilDB, and ilBasicSkill\ACHIEVED.

135  : array {
136  $ilDB = $this->db;
137 
138  $to = (!is_null($a_timestamp_to))
139  ? " AND status_date <= " . $ilDB->quote($a_timestamp_to, "timestamp")
140  : "";
141 
142  $user = ($a_user_id > 0)
143  ? " AND user_id = " . $ilDB->quote($a_user_id, "integer")
144  : "";
145 
146  $set = $ilDB->query("SELECT * FROM skl_user_skill_level " .
147  " WHERE status_date >= " . $ilDB->quote($a_timestamp, "timestamp") .
148  " AND valid = " . $ilDB->quote(1, "integer") .
149  " AND status = " . $ilDB->quote(ilBasicSkill::ACHIEVED, "integer") .
150  " AND self_eval = " . $ilDB->quote($a_self_eval, "integer") .
151  $to .
152  $user .
153  " ORDER BY user_id, status_date ASC ");
154  $achievments = array();
155  while ($rec = $ilDB->fetchAssoc($set)) {
156  $achievments[$rec["user_id"]][] = $rec;
157  }
158 
159  return $achievments;
160  }
$ilDB
global $ilDB
Definition: storeScorm2004.php:16

◆ hasRecentSelfEvaluation()

ilBasicSkillUserLevelDBRepository::hasRecentSelfEvaluation ( int  $trigger_obj_id,
int  $a_user_id,
int  $a_skill_id,
int  $a_tref_id = 0,
int  $a_trigger_ref_id = 0 
)

Implements ilBasicSkillUserLevelRepository.

Definition at line 96 of file class.ilBasicSkillUserLevelDBRepository.php.

References $db, $ilDB, ilBasicSkill\ACHIEVED, and ilUtil\now().

102  {
103  $ilDB = $this->db;
104 
105  $recent = "";
106 
107  $ilDB->setLimit(1);
108  $set = $ilDB->query("SELECT * FROM skl_user_skill_level WHERE " .
109  "skill_id = " . $ilDB->quote($a_skill_id, "integer") . " AND " .
110  "user_id = " . $ilDB->quote($a_user_id, "integer") . " AND " .
111  "tref_id = " . $ilDB->quote((int) $a_tref_id, "integer") . " AND " .
112  "trigger_obj_id = " . $ilDB->quote($trigger_obj_id, "integer") . " AND " .
113  "self_eval = " . $ilDB->quote(1, "integer") .
114  " ORDER BY status_date DESC"
115  );
116  if ($rec = $ilDB->fetchAssoc($set)) {
117  $status_day = substr($rec["status_date"], 0, 10);
118  $today = substr(ilUtil::now(), 0, 10);
119  if ($rec["valid"] && $rec["status"] == ilBasicSkill::ACHIEVED && $status_day == $today) {
120  $recent = $rec["status_date"];
121  }
122  }
123 
124  return $recent;
125  }
ilUtil\now
static now()
Return current timestamp in Y-m-d H:i:s format.
Definition: class.ilUtil.php:3916
$ilDB
global $ilDB
Definition: storeScorm2004.php:16
+ Here is the call graph for this function:

◆ hasSelfEvaluated()

ilBasicSkillUserLevelDBRepository::hasSelfEvaluated ( int  $a_user_id,
int  $a_skill_id,
int  $a_tref_id 
)

Implements ilBasicSkillUserLevelRepository.

Definition at line 469 of file class.ilBasicSkillUserLevelDBRepository.php.

References $db, and $ilDB.

469  : bool
470  {
471  $ilDB = $this->db;
472 
473  $set = $ilDB->query($q = "SELECT level_id FROM skl_user_has_level " .
474  " WHERE skill_id = " . $ilDB->quote((int) $a_skill_id, "integer") .
475  " AND tref_id = " . $ilDB->quote((int) $a_tref_id, "integer") .
476  " AND user_id = " . $ilDB->quote($a_user_id, "integer") .
477  " AND self_eval = " . $ilDB->quote(1, "integer")
478  );
479 
480  if ($rec = $ilDB->fetchAssoc($set)) {
481  return true;
482  }
483  return false;
484  }
$ilDB
global $ilDB
Definition: storeScorm2004.php:16

◆ removeAllUserData()

ilBasicSkillUserLevelDBRepository::removeAllUserData ( int  $a_user_id)

Implements ilBasicSkillUserLevelRepository.

Definition at line 299 of file class.ilBasicSkillUserLevelDBRepository.php.

References $db, and $ilDB.

300  {
301  $ilDB = $this->db;
302 
303  $ilDB->manipulate("DELETE FROM skl_user_skill_level WHERE "
304  . " user_id = " . $ilDB->quote($a_user_id, "integer")
305  );
306  $ilDB->manipulate("DELETE FROM skl_user_has_level WHERE "
307  . " user_id = " . $ilDB->quote($a_user_id, "integer")
308  );
309  }
$ilDB
global $ilDB
Definition: storeScorm2004.php:16

◆ removeAllUserSkillLevelStatusOfObject()

ilBasicSkillUserLevelDBRepository::removeAllUserSkillLevelStatusOfObject ( int  $a_user_id,
int  $a_trigger_obj_id,
bool  $a_self_eval = false,
string  $a_unique_identifier = "" 
)

Implements ilBasicSkillUserLevelRepository.

Definition at line 265 of file class.ilBasicSkillUserLevelDBRepository.php.

References $changed, $db, and $ilDB.

270  : bool {
271  $ilDB = $this->db;
272 
273  $changed = false;
274 
275  $aff_rows = $ilDB->manipulate("DELETE FROM skl_user_skill_level WHERE "
276  . " user_id = " . $ilDB->quote($a_user_id, "integer")
277  . " AND trigger_obj_id = " . $ilDB->quote($a_trigger_obj_id, "integer")
278  . " AND self_eval = " . $ilDB->quote($a_self_eval, "integer")
279  . " AND unique_identifier = " . $ilDB->quote($a_unique_identifier, "text")
280  );
281  if ($aff_rows > 0) {
282  $changed = true;
283  }
284 
285  $aff_rows = $ilDB->manipulate("DELETE FROM skl_user_has_level WHERE "
286  . " user_id = " . $ilDB->quote($a_user_id, "integer")
287  . " AND trigger_obj_id = " . $ilDB->quote($a_trigger_obj_id, "integer")
288  . " AND self_eval = " . $ilDB->quote($a_self_eval, "integer")
289  );
290  if ($aff_rows > 0) {
291  $changed = true;
292  }
293  return $changed;
294  }
$ilDB
global $ilDB
Definition: storeScorm2004.php:16

◆ resetUserSkillLevelStatus()

ilBasicSkillUserLevelDBRepository::resetUserSkillLevelStatus ( bool  $update,
int  $trigger_obj_id,
  $status_date,
int  $a_user_id,
int  $a_skill_id,
int  $a_tref_id = 0,
int  $a_trigger_ref_id = 0,
bool  $a_self_eval = false 
)

Implements ilBasicSkillUserLevelRepository.

Definition at line 34 of file class.ilBasicSkillUserLevelDBRepository.php.

References $db, $ilDB, ilBasicSkill\ACHIEVED, and ilUtil\now().

43  {
44  $ilDB = $this->db;
45 
46  if ($update) {
47  // this will only be set in self eval case, means this will always have a $rec
48  $now = ilUtil::now();
49  $ilDB->manipulate("UPDATE skl_user_skill_level SET " .
50  " level_id = " . $ilDB->quote(0, "integer") . "," .
51  " next_level_fulfilment = " . $ilDB->quote(0.0, "float") . "," .
52  " status_date = " . $ilDB->quote($now, "timestamp") .
53  " WHERE user_id = " . $ilDB->quote($a_user_id, "integer") .
54  " AND status_date = " . $ilDB->quote($status_date, "timestamp") .
55  " AND skill_id = " . $ilDB->quote($a_skill_id, "integer") .
56  " AND status = " . $ilDB->quote(ilBasicSkill::ACHIEVED, "integer") .
57  " AND trigger_obj_id = " . $ilDB->quote($trigger_obj_id, "integer") .
58  " AND tref_id = " . $ilDB->quote((int) $a_tref_id, "integer") .
59  " AND self_eval = " . $ilDB->quote($a_self_eval, "integer")
60  );
61  } else {
62  $now = ilUtil::now();
63  $ilDB->manipulate("INSERT INTO skl_user_skill_level " .
64  "(level_id, user_id, tref_id, status_date, skill_id, status, valid, trigger_ref_id," .
65  "trigger_obj_id, trigger_obj_type, trigger_title, self_eval, unique_identifier," .
66  "next_level_fulfilment) VALUES (" .
67  $ilDB->quote(0, "integer") . "," .
68  $ilDB->quote($a_user_id, "integer") . "," .
69  $ilDB->quote((int) $a_tref_id, "integer") . "," .
70  $ilDB->quote($now, "timestamp") . "," .
71  $ilDB->quote($a_skill_id, "integer") . "," .
72  $ilDB->quote(ilBasicSkill::ACHIEVED, "integer") . "," .
73  $ilDB->quote(1, "integer") . "," .
74  $ilDB->quote($a_trigger_ref_id, "integer") . "," .
75  $ilDB->quote($trigger_obj_id, "integer") . "," .
76  $ilDB->quote("", "text") . "," .
77  $ilDB->quote("", "text") . "," .
78  $ilDB->quote($a_self_eval, "integer") . "," .
79  $ilDB->quote("", "text") . "," .
80  $ilDB->quote(0.0, "float") .
81  ")");
82  }
83 
84  $ilDB->manipulate("DELETE FROM skl_user_has_level WHERE "
85  . " user_id = " . $ilDB->quote($a_user_id, "integer")
86  . " AND skill_id = " . $ilDB->quote($a_skill_id, "integer")
87  . " AND tref_id = " . $ilDB->quote((int) $a_tref_id, "integer")
88  . " AND trigger_obj_id = " . $ilDB->quote($trigger_obj_id, "integer")
89  . " AND self_eval = " . $ilDB->quote($a_self_eval, "integer")
90  );
91  }
ilUtil\now
static now()
Return current timestamp in Y-m-d H:i:s format.
Definition: class.ilUtil.php:3916
$ilDB
global $ilDB
Definition: storeScorm2004.php:16
+ Here is the call graph for this function:

◆ writeUserSkillLevelStatus()

ilBasicSkillUserLevelDBRepository::writeUserSkillLevelStatus ( int  $skill_id,
int  $trigger_ref_id,
int  $trigger_obj_id,
?string  $trigger_title,
?string  $trigger_type,
bool  $update,
  $status_date,
int  $a_level_id,
int  $a_user_id,
int  $a_tref_id = 0,
bool  $a_self_eval = false,
string  $a_unique_identifier = "",
float  $a_next_level_fulfilment = 0.0 
)

Implements ilBasicSkillUserLevelRepository.

Definition at line 165 of file class.ilBasicSkillUserLevelDBRepository.php.

References $db, $ilDB, ilBasicSkill\ACHIEVED, and ilUtil\now().

179  {
180  $ilDB = $this->db;
181  $a_status = ilBasicSkill::ACHIEVED;
182 
183  if ($update) {
184  // this will only be set in self eval case, means this will always have a $rec
185  $now = ilUtil::now();
186  $ilDB->manipulate("UPDATE skl_user_skill_level SET " .
187  " level_id = " . $ilDB->quote($a_level_id, "integer") . "," .
188  " status_date = " . $ilDB->quote($now, "timestamp") . "," .
189  " next_level_fulfilment = " . $ilDB->quote((float) $a_next_level_fulfilment, "float") .
190  " WHERE user_id = " . $ilDB->quote($a_user_id, "integer") .
191  " AND status_date = " . $ilDB->quote($status_date, "timestamp") .
192  " AND skill_id = " . $ilDB->quote($skill_id, "integer") .
193  " AND status = " . $ilDB->quote($a_status, "integer") .
194  " AND trigger_obj_id = " . $ilDB->quote($trigger_obj_id, "integer") .
195  " AND tref_id = " . $ilDB->quote((int) $a_tref_id, "integer") .
196  " AND self_eval = " . $ilDB->quote($a_self_eval, "integer")
197  );
198  } else {
199  if ($a_unique_identifier != "") {
200  $ilDB->manipulate("DELETE FROM skl_user_skill_level WHERE " .
201  " user_id = " . $ilDB->quote($a_user_id, "integer") .
202  " AND tref_id = " . $ilDB->quote($a_tref_id, "integer") .
203  " AND skill_id = " . $ilDB->quote($skill_id, "integer") .
204  " AND trigger_ref_id = " . $ilDB->quote($trigger_ref_id, "integer") .
205  " AND trigger_obj_id = " . $ilDB->quote($trigger_obj_id, "integer") .
206  " AND self_eval = " . $ilDB->quote($a_self_eval, "integer") .
207  " AND unique_identifier = " . $ilDB->quote($a_unique_identifier, "text")
208  );
209  }
210 
211  $now = ilUtil::now();
212  $ilDB->manipulate("INSERT INTO skl_user_skill_level " .
213  "(level_id, user_id, tref_id, status_date, skill_id, status, valid, trigger_ref_id," .
214  "trigger_obj_id, trigger_obj_type, trigger_title, self_eval, unique_identifier," .
215  "next_level_fulfilment) VALUES (" .
216  $ilDB->quote($a_level_id, "integer") . "," .
217  $ilDB->quote($a_user_id, "integer") . "," .
218  $ilDB->quote((int) $a_tref_id, "integer") . "," .
219  $ilDB->quote($now, "timestamp") . "," .
220  $ilDB->quote($skill_id, "integer") . "," .
221  $ilDB->quote($a_status, "integer") . "," .
222  $ilDB->quote(1, "integer") . "," .
223  $ilDB->quote($trigger_ref_id, "integer") . "," .
224  $ilDB->quote($trigger_obj_id, "integer") . "," .
225  $ilDB->quote($trigger_type, "text") . "," .
226  $ilDB->quote($trigger_title, "text") . "," .
227  $ilDB->quote($a_self_eval, "integer") . "," .
228  $ilDB->quote($a_unique_identifier, "text") . "," .
229  $ilDB->quote((float) $a_next_level_fulfilment, "float") .
230  ")");
231  }
232 
233  // fix (removed level_id and added skill id, since table should hold only
234  // one entry per skill)
235  $ilDB->manipulate("DELETE FROM skl_user_has_level WHERE "
236  . " user_id = " . $ilDB->quote($a_user_id, "integer")
237  . " AND skill_id = " . $ilDB->quote($skill_id, "integer")
238  . " AND tref_id = " . $ilDB->quote((int) $a_tref_id, "integer")
239  . " AND trigger_obj_id = " . $ilDB->quote($trigger_obj_id, "integer")
240  . " AND self_eval = " . $ilDB->quote($a_self_eval, "integer")
241  );
242 
243  if ($a_status == ilBasicSkill::ACHIEVED) {
244  $ilDB->manipulate("INSERT INTO skl_user_has_level " .
245  "(level_id, user_id, tref_id, status_date, skill_id, trigger_ref_id, trigger_obj_id, trigger_obj_type," .
246  "trigger_title, self_eval, next_level_fulfilment) VALUES (" .
247  $ilDB->quote($a_level_id, "integer") . "," .
248  $ilDB->quote($a_user_id, "integer") . "," .
249  $ilDB->quote($a_tref_id, "integer") . "," .
250  $ilDB->quote($now, "timestamp") . "," .
251  $ilDB->quote($skill_id, "integer") . "," .
252  $ilDB->quote($trigger_ref_id, "integer") . "," .
253  $ilDB->quote($trigger_obj_id, "integer") . "," .
254  $ilDB->quote($trigger_type, "text") . "," .
255  $ilDB->quote($trigger_title, "text") . "," .
256  $ilDB->quote($a_self_eval, "integer") . "," .
257  $ilDB->quote((float) $a_next_level_fulfilment, "float") .
258  ")");
259  }
260  }
ilUtil\now
static now()
Return current timestamp in Y-m-d H:i:s format.
Definition: class.ilUtil.php:3916
$ilDB
global $ilDB
Definition: storeScorm2004.php:16
+ Here is the call graph for this function:

Field Documentation

◆ $db

ilBasicSkillUserLevelDBRepository::$db
protected

Definition at line 8 of file class.ilBasicSkillUserLevelDBRepository.php.

Referenced by __construct(), deleteUserLevelsOfSkill(), getAllHistoricLevelEntriesOfUser(), getAllLevelEntriesOfUser(), getLastLevelPerObject(), getLastUpdatePerObject(), getMaxLevel(), getMaxLevelPerObject(), getMaxLevelPerType(), getNewAchievementsPerUser(), hasRecentSelfEvaluation(), hasSelfEvaluated(), removeAllUserData(), removeAllUserSkillLevelStatusOfObject(), resetUserSkillLevelStatus(), and writeUserSkillLevelStatus().

The documentation for this class was generated from the following file: