ILIAS  release_8 Revision v8.19-1-g4e8f2f9140c
•All Data Structures Namespaces Files Functions Variables Modules Pages
Static Public Member Functions | Static Protected Member Functions
ilSCORM2004StoreData Class Reference

Class ilSCORM2004StoreData. More...

+ Collaboration diagram for ilSCORM2004StoreData:

Static Public Member Functions

static scormPlayerUnload (int $packageId, int $refId, bool $time_from_lms, ?int $userId=null)
 
static checkIfAllowed (int $packageId, int $userId, int $hash)
 
static persistCMIData (int $packageId, int $refId, string $defaultLessonMode, bool $comments, bool $interactions, bool $objectives, bool $time_from_lms, ?string $data=null, ?int $userId=null)
 
static setCMIData (int $userId, int $packageId, object $data, bool $getComments, bool $getInteractions, bool $getObjectives)
 
static writeGObjective (int $user, int $package, ?array $g_data)
 
static syncGlobalStatus (int $userId, int $packageId, int $refId, object $data, int $new_global_status, bool $time_from_lms)
 

Static Protected Member Functions

static setGlobalObjectives (int $userId, int $packageId, object $data)
 

Detailed Description

Class ilSCORM2004StoreData.

Author
Alex Killing alex..nosp@m.kill.nosp@m.ing@g.nosp@m.mx.d.nosp@m.e
Uwe Kohnle kohnl.nosp@m.e@in.nosp@m.terne.nosp@m.tleh.nosp@m.rer-g.nosp@m.mbh..nosp@m.de

Definition at line 26 of file class.ilSCORM2004StoreData.php.

Member Function Documentation

◆ checkIfAllowed()

static ilSCORM2004StoreData::checkIfAllowed ( int  $packageId,
int  $userId,
int  $hash 
)
static

Definition at line 91 of file class.ilSCORM2004StoreData.php.

References $DIC, $GLOBALS, $ilDB, and $res.

91  : void
92  {
93  global $DIC;
94 
95  $ilDB = $DIC->database();
96  $res = $ilDB->queryF(
97  'select hash from sahs_user where obj_id=%s AND user_id=%s AND hash_end>%s',
98  array('integer', 'integer', 'timestamp'),
99  array($packageId, $userId, date('Y-m-d H:i:s'))
100  );
101  $rowtmp = $ilDB->fetchAssoc($res);
102  if ($rowtmp && (int) $rowtmp['hash'] == $hash) {
103  return;
104  }
105 
106  die("not allowed");
107  }
$res
$res
Definition: ltiservices.php:69
$packageId
$packageId
Definition: storeScorm.php:25
$DIC
global $DIC
Definition: feed.php:28

◆ persistCMIData()

static ilSCORM2004StoreData::persistCMIData ( int  $packageId,
int  $refId,
string  $defaultLessonMode,
bool  $comments,
bool  $interactions,
bool  $objectives,
bool  $time_from_lms,
?string  $data = null,
?int  $userId = null 
)
static

Definition at line 125 of file class.ilSCORM2004StoreData.php.

References $_SERVER, $data, $DIC, ilLoggerFactory\getLogger(), ilObjSCORM2004LearningModule\getQuantityOfSCOs(), ilLTIAppEventListener\handleOutcomeWithoutLP(), ILIAS\Repository\int(), setCMIData(), setGlobalObjectives(), and syncGlobalStatus().

Referenced by ilSCORM13PlayerGUI\executeCommand().

135  : void {
136  global $DIC;
137 
138  $ilLog = ilLoggerFactory::getLogger('sc13');
139 
140  if ($defaultLessonMode === "browse") {
141  return;
142  }
143 
144  $jsMode = strpos($_SERVER['HTTP_ACCEPT'], 'text/javascript') !== false;//ToDo: Avoid $_SERVER
145 
146  $data = json_decode(is_string($data) ? $data : file_get_contents('php://input'));
147  $ilLog->debug("dataTo_setCMIData: " . file_get_contents('php://input'));
148  if (!$data) {
149  return;
150  }
151  if ($userId == null) {
152  $userId = (int) $data->p;
153  self::checkIfAllowed($packageId, $userId, $data->hash);
154  // header('Access-Control-Allow-Origin: http://localhost:50012');//just for tests - not for release UK
155  }
156  $return = ilSCORM2004StoreData::setCMIData(
157  $userId,
158  $packageId,
159  $data,
160  $comments,
161  $interactions,
162  $objectives
163  );
164 
165  //$new_global_status=ilSCORM2004StoreData::setGlobalObjectivesAndGetGlobalStatus($userId, $packageId, $data);
166  ilSCORM2004StoreData::setGlobalObjectives($userId, $packageId, $data);
167  $new_global_status = $data->now_global_status;
168  $return["new_global_status"] = $new_global_status;
169 
170  // mantis #30293
171  $score_scaled = $data->node[0][35];
172  if ($score_scaled != null) {
173  if (ilObjSCORM2004LearningModule::getQuantityOfSCOs($packageId) == 1) {
174  ilLTIAppEventListener::handleOutcomeWithoutLP($packageId, $userId, $score_scaled * 100);
175  }
176  }
177 
178  ilSCORM2004StoreData::syncGlobalStatus($userId, $packageId, $refId, $data, $new_global_status, $time_from_lms);
179 
180  $ilLog->debug("SCORM: return of persistCMIData: " . json_encode($return));
181  if ($jsMode) {
182  header('Content-Type: text/javascript; charset=UTF-8');
183  print(json_encode($return));
184  } else {
185  header('Content-Type: text/html; charset=UTF-8');
186  print(var_export($return, true));
187  }
188  }
$time_from_lms
$time_from_lms
Definition: storeScorm2004.php:41
ilLoggerFactory\getLogger
static getLogger(string $a_component_id)
Get component logger.
Definition: class.ilLoggerFactory.php:89
$defaultLessonMode
if($DIC->http() ->wrapper() ->query() ->has('do')) $defaultLessonMode
Definition: storeScorm2004.php:37
$packageId
$packageId
Definition: storeScorm.php:25
$refId
$refId
Definition: xapitoken.php:58
ilSCORM2004StoreData\setCMIData
static setCMIData(int $userId, int $packageId, object $data, bool $getComments, bool $getInteractions, bool $getObjectives)
Definition: class.ilSCORM2004StoreData.php:193
$interactions
$interactions
Definition: storeScorm2004.php:39
ilSCORM2004StoreData\syncGlobalStatus
static syncGlobalStatus(int $userId, int $packageId, int $refId, object $data, int $new_global_status, bool $time_from_lms)
Definition: class.ilSCORM2004StoreData.php:658
$DIC
global $DIC
Definition: feed.php:28
$objectives
$objectives
Definition: storeScorm2004.php:40
ilSCORM2004StoreData\setGlobalObjectives
static setGlobalObjectives(int $userId, int $packageId, object $data)
Definition: class.ilSCORM2004StoreData.php:421
$_SERVER
$_SERVER['HTTP_HOST']
Definition: raiseError.php:10
$comments
$comments
Definition: storeScorm2004.php:38
ilLTIAppEventListener\handleOutcomeWithoutLP
static handleOutcomeWithoutLP(int $a_obj_id, int $a_usr_id, ?float $a_percentage)
Definition: class.ilLTIAppEventListener.php:201
+ Here is the call graph for this function:
+ Here is the caller graph for this function:

◆ scormPlayerUnload()

static ilSCORM2004StoreData::scormPlayerUnload ( int  $packageId,
int  $refId,
bool  $time_from_lms,
?int  $userId = null 
)
static

Definition at line 28 of file class.ilSCORM2004StoreData.php.

References $data, $DIC, $ilDB, ilSCORM2004Tracking\_syncReadEvent(), and ILIAS\Repository\int().

Referenced by ilSCORM13PlayerGUI\executeCommand().

28  : void
29  {
30  global $DIC;
31 
32  $ilDB = $DIC->database();
33 
34  // $data = json_decode(is_string($data) ? $data : file_get_contents('php://input'));
35  $data = json_decode(file_get_contents('php://input'));
36  if (!$data) {
37  return;
38  }
39  if ($userId == null) {
40  $userId = (int) $data->p;
41  self::checkIfAllowed($packageId, $userId, $data->hash);
42  }
43  $last_visited = null;
44  if ($data->last != "") {
45  $last_visited = $data->last;
46  }
47  $endDate = date(
48  'Y-m-d H:i:s',
49  mktime(
50  (int) date('H'),
51  (int) date('i') + 5,
52  (int) date('s'),
53  (int) date('m'),
54  (int) date('d'),
55  (int) date('Y')
56  )
57  );
58  $total_time_sec = null;
59  if ($data->total_time_sec != "") {
60  $total_time_sec = $data->total_time_sec;
61  $ilDB->manipulateF(
62  'UPDATE sahs_user
63  SET total_time_sec = %s, last_visited = %s, hash_end =%s, last_access = %s
64  WHERE obj_id = %s AND user_id = %s',
65  array('integer', 'text', 'timestamp', 'timestamp', 'integer', 'integer'),
66  array($total_time_sec, $last_visited, $endDate, date('Y-m-d H:i:s'), $packageId, $userId)
67  );
68  if ($time_from_lms == true) {
69  self::ensureObjectDataCacheExistence();
70  global $DIC;
71 
72  $ilObjDataCache = $DIC["ilObjDataCache"];
73  // sync access number and time in read event table
74  ilSCORM2004Tracking::_syncReadEvent($packageId, $userId, "sahs", $refId, $time_from_lms);
75  //end sync access number and time in read event table
76  }
77  } else {
78  $ilDB->manipulateF(
79  'UPDATE sahs_user
80  SET last_visited = %s, hash_end =%s, last_access = %s
81  WHERE obj_id = %s AND user_id = %s',
82  array('text', 'timestamp', 'timestamp', 'integer', 'integer'),
83  array($last_visited, $endDate, date('Y-m-d H:i:s'), $packageId, $userId)
84  );
85  }
86 
87  header('Content-Type: text/plain; charset=UTF-8');
88  print("");
89  }
$time_from_lms
$time_from_lms
Definition: storeScorm2004.php:41
$packageId
$packageId
Definition: storeScorm.php:25
$refId
$refId
Definition: xapitoken.php:58
$DIC
global $DIC
Definition: feed.php:28
ilSCORM2004Tracking\_syncReadEvent
static _syncReadEvent(int $a_obj_id, int $a_user_id, string $a_type, int $a_ref_id, ?bool $time_from_lms=null)
Synch read event table.
Definition: class.ilSCORM2004Tracking.php:323
+ Here is the call graph for this function:
+ Here is the caller graph for this function:

◆ setCMIData()

static ilSCORM2004StoreData::setCMIData ( int  $userId,
int  $packageId,
object  $data,
bool  $getComments,
bool  $getInteractions,
bool  $getObjectives 
)
static
Returns
mixed[]

Definition at line 193 of file class.ilSCORM2004StoreData.php.

References $DIC, $i, $ilDB, $res, and ilLoggerFactory\getLogger().

Referenced by persistCMIData().

200  : array {
201  global $DIC;
202 
203  $ilDB = $DIC->database();
204  $ilLog = ilLoggerFactory::getLogger('sc13');
205 
206  $result = array();
207 
208  if (!$data) {
209  return $result;
210  }
211 
212  $i_check = $data->i_check;
213  $i_set = $data->i_set;
214  $b_node_update = false;
215  $cmi_node_id = null;
216  $a_map_cmi_interaction_id = array();
217 
218  $tables = array('node', 'comment', 'interaction', 'objective', 'correct_response');
219 
220  foreach ($tables as $table) {
221  if (!is_array($data->$table)) {
222  continue;
223  }
224 
225  $ilLog->debug("SCORM: setCMIData, table -" . $table . "-");
226 
227  // now iterate through data rows from input
228  foreach ($data->$table as &$row) {
229  $ilLog->debug("Checking table: " . $table);
230 
231  switch ($table) {
232  case 'node': //is always first and has only 1 row
233 
234  $res = $ilDB->queryF(
235  'SELECT cmi_node_id FROM cmi_node WHERE cp_node_id = %s and user_id = %s',
236  array('integer', 'integer'),
237  array($row[19], $userId)
238  );
239  $rowtmp = $ilDB->fetchAssoc($res);
240 
241  if ($rowtmp != null) {
242  $cmi_node_id = $rowtmp['cmi_node_id'];
243  $b_node_update = true;
244  } else {
245  $cmi_node_id = $ilDB->nextId('cmi_node');
246  $b_node_update = false;
247  }
248  $ilLog->debug("setCMIdata with cmi_node_id = " . $cmi_node_id);
249  $a_data = array(
250  'accesscount' => array('integer', $row[0]),
251  'accessduration' => array('text', $row[1]),
252  'accessed' => array('text', $row[2]),
253  'activityabsduration' => array('text', $row[3]),
254  'activityattemptcount' => array('integer', $row[4]),
255  'activityexpduration' => array('text', $row[5]),
256  'activityprogstatus' => array('integer', $row[6]),
257  'attemptabsduration' => array('text', $row[7]),
258  'attemptcomplamount' => array('float', $row[8]),
259  'attemptcomplstatus' => array('integer', $row[9]),
260  'attemptexpduration' => array('text', $row[10]),
261  'attemptprogstatus' => array('integer', $row[11]),
262  'audio_captioning' => array('integer', $row[12]),
263  'audio_level' => array('float', $row[13]),
264  'availablechildren' => array('text', $row[14]),
265  'cmi_node_id' => array('integer', $cmi_node_id),
266  'completion' => array('float', $row[16]),
267  'completion_status' => array('text', $row[17]),
268  'completion_threshold' => array('text', $row[18]),
269  'cp_node_id' => array('integer', $row[19]),
270  'created' => array('text', $row[20]),
271  'credit' => array('text', $row[21]),
272  'delivery_speed' => array('float', $row[22]),
273  'c_entry' => array('text', $row[23]),
274  'c_exit' => array('text', $row[24]),
275  'c_language' => array('text', $row[25]),
276  'launch_data' => array('clob', $row[26]),
277  'learner_name' => array('text', $row[27]),
278  'location' => array('text', $row[28]),
279  'c_max' => array('float', $row[29]),
280  'c_min' => array('float', $row[30]),
281  'c_mode' => array('text', $row[31]),
282  'modified' => array('text', $row[32]),
283  'progress_measure' => array('float', $row[33]),
284  'c_raw' => array('float', $row[34]),
285  'scaled' => array('float', $row[35]),
286  'scaled_passing_score' => array('float', $row[36]),
287  'session_time' => array('text', $row[37]),
288  'success_status' => array('text', $row[38]),
289  'suspend_data' => array('clob', $row[39]),
290  'total_time' => array('text', $row[40]),
291  'user_id' => array('integer', $userId),
292  'c_timestamp' => array('timestamp', date('Y-m-d H:i:s')),
293  'additional_tables' => array('integer', $i_check)
294  );
295 
296  if ($b_node_update == false) {
297  $ilDB->insert('cmi_node', $a_data);
298  $ilLog->debug("inserted");
299  } else {
300  $ilDB->update('cmi_node', $a_data, array('cmi_node_id' => array('integer', $cmi_node_id)));
301  $ilLog->debug("updated");
302  }
303 
304  if ($b_node_update == true) {
305  //remove
306  if ($i_set > 7) {
307  $i_set -= 8;
308  if ($getComments) {
309  $q = 'DELETE FROM cmi_comment WHERE cmi_node_id = %s';
310  $ilDB->manipulateF($q, array('integer'), array($cmi_node_id));
311  }
312  }
313  if ($i_set > 3) {
314  $i_set -= 4;
315  if ($getInteractions) {
316  $q = 'DELETE FROM cmi_correct_response
317  WHERE cmi_interaction_id IN (
318  SELECT cmi_interaction.cmi_interaction_id FROM cmi_interaction WHERE cmi_interaction.cmi_node_id = %s)';
319  $ilDB->manipulateF($q, array('integer'), array($cmi_node_id));
320  }
321  }
322  if ($i_set > 1) {
323  $i_set -= 2;
324  if ($getInteractions) {
325  $q = 'DELETE FROM cmi_interaction WHERE cmi_node_id = %s';
326  $ilDB->manipulateF($q, array('integer'), array($cmi_node_id));
327  }
328  }
329  if ($i_set > 0) {
330  $i_set = 0;
331  if ($getObjectives) {
332  $q = 'DELETE FROM cmi_objective WHERE cmi_node_id = %s';
333  $ilDB->manipulateF($q, array('integer'), array($cmi_node_id));
334  }
335  }
336  //end remove
337  }
338  //to send to client
339  $result[(string) $row[19]] = $cmi_node_id;
340  break;
341 
342  case 'comment':
343  $row[0] = $ilDB->nextId('cmi_comment');
344 
345  $ilDB->insert('cmi_comment', array(
346  'cmi_comment_id' => array('integer', $row[0]),
347  'cmi_node_id' => array('integer', $cmi_node_id),
348  'c_comment' => array('clob', $row[2]),
349  'c_timestamp' => array('text', $row[3]),
350  'location' => array('text', $row[4]),
351  'sourceislms' => array('integer', $row[5])
352  ));
353  break;
354 
355  case 'interaction':
356  $cmi_interaction_id = $ilDB->nextId('cmi_interaction');
357  $a_map_cmi_interaction_id[] = array($row[0], $cmi_interaction_id);
358  $ilDB->insert('cmi_interaction', array(
359  'cmi_interaction_id' => array('integer', $cmi_interaction_id),
360  'cmi_node_id' => array('integer', $cmi_node_id),
361  'description' => array('clob', $row[2]),
362  'id' => array('text', $row[3]),
363  'latency' => array('text', $row[4]),
364  'learner_response' => array('clob', $row[5]),
365  'result' => array('text', $row[6]),
366  'c_timestamp' => array('text', $row[7]),
367  'c_type' => array('text', $row[8]),
368  'weighting' => array('float', $row[9])
369  ));
370  break;
371 
372  case 'objective':
373  $row[2] = $ilDB->nextId('cmi_objective');
374  $cmi_interaction_id = null;
375  if ($row[0] != null) {
376  foreach ($a_map_cmi_interaction_id as $i => $value) {
377  if ($row[0] == $value[0]) {
378  $cmi_interaction_id = $value[1];
379  }
380  }
381  }
382  $ilDB->insert('cmi_objective', array(
383  'cmi_interaction_id' => array('integer', $cmi_interaction_id),
384  'cmi_node_id' => array('integer', $cmi_node_id),
385  'cmi_objective_id' => array('integer', $row[2]),
386  'completion_status' => array('text', $row[3]),
387  'description' => array('clob', $row[4]),
388  'id' => array('text', $row[5]),
389  'c_max' => array('float', $row[6]),
390  'c_min' => array('float', $row[7]),
391  'c_raw' => array('float', $row[8]),
392  'scaled' => array('float', $row[9]),
393  'progress_measure' => array('float', $row[10]),
394  'success_status' => array('text', $row[11]),
395  'scope' => array('text', $row[12])
396  ));
397  break;
398 
399  case 'correct_response':
400  $cmi_interaction_id = null;
401  if ($row[1] !== null) {
402  foreach ($a_map_cmi_interaction_id as $i => $value) {
403  if ($row[1] == $value[0]) {
404  $cmi_interaction_id = $value[1];
405  }
406  }
407  $row[0] = $ilDB->nextId('cmi_correct_response');
408  $ilDB->insert('cmi_correct_response', array(
409  'cmi_correct_resp_id' => array('integer', $row[0]),
410  'cmi_interaction_id' => array('integer', $cmi_interaction_id),
411  'pattern' => array('text', $row[2])
412  ));
413  }
414  break;
415  }
416  }
417  }
418  return $result;
419  }
$res
$res
Definition: ltiservices.php:69
ilLoggerFactory\getLogger
static getLogger(string $a_component_id)
Get component logger.
Definition: class.ilLoggerFactory.php:89
$DIC
global $DIC
Definition: feed.php:28
$i
$i
Definition: metadata.php:41
+ Here is the call graph for this function:
+ Here is the caller graph for this function:

◆ setGlobalObjectives()

static ilSCORM2004StoreData::setGlobalObjectives ( int  $userId,
int  $packageId,
object  $data 
)
staticprotected

Definition at line 421 of file class.ilSCORM2004StoreData.php.

References ilLoggerFactory\getLogger(), and writeGObjective().

Referenced by persistCMIData().

421  : void
422  {
423  $ilLog = ilLoggerFactory::getLogger('sc13');
424  $changed_seq_utilities = $data->changed_seq_utilities;
425  $ilLog->debug("SCORM2004 adl_seq_utilities changed: " . $changed_seq_utilities);
426  if ($changed_seq_utilities == 1) {
427  $returnAr = ilSCORM2004StoreData::writeGObjective($userId, $packageId, (array) $data->adl_seq_utilities);
428  }
429  }
ilLoggerFactory\getLogger
static getLogger(string $a_component_id)
Get component logger.
Definition: class.ilLoggerFactory.php:89
$packageId
$packageId
Definition: storeScorm.php:25
ilSCORM2004StoreData\writeGObjective
static writeGObjective(int $user, int $package, ?array $g_data)
Definition: class.ilSCORM2004StoreData.php:437
+ Here is the call graph for this function:
+ Here is the caller graph for this function:

◆ syncGlobalStatus()

static ilSCORM2004StoreData::syncGlobalStatus ( int  $userId,
int  $packageId,
int  $refId,
object  $data,
int  $new_global_status,
bool  $time_from_lms 
)
static

Definition at line 658 of file class.ilSCORM2004StoreData.php.

References $DIC, $ilDB, ilSCORM2004Tracking\_syncReadEvent(), ILIAS\Repository\int(), and ilLPStatus\writeStatus().

Referenced by persistCMIData().

658  : void
659  {
660  global $DIC;
661  $ilDB = $DIC->database();
662  $ilLog = $DIC["ilLog"];
663  $saved_global_status = $data->saved_global_status;
664  $ilLog->write("saved_global_status=" . $saved_global_status);
665 
666  //update percentage_completed, sco_total_time_sec,status in sahs_user
667  $totalTime = (int) $data->totalTimeCentisec;
668  $totalTime = round($totalTime / 100);
669  $ilDB->queryF(
670  'UPDATE sahs_user SET sco_total_time_sec=%s, status=%s, percentage_completed=%s WHERE obj_id = %s AND user_id = %s',
671  array('integer', 'integer', 'integer', 'integer', 'integer'),
672  array($totalTime, $new_global_status, $data->percentageCompleted, $packageId, $userId)
673  );
674 
675  self::ensureObjectDataCacheExistence();
676 
677  $ilObjDataCache = $DIC["ilObjDataCache"];
678 
679  // update learning progress
680  if ($new_global_status != null) {//could only happen when synchronising from SCORM Offline Player
681  ilLPStatus::writeStatus($packageId, $userId, $new_global_status, (int) $data->percentageCompleted);
682 
683  // here put code for soap to MaxCMS e.g. when if($saved_global_status != $new_global_status)
684  }
685  // sync access number and time in read event table
686  if ($time_from_lms == false) {
687  ilSCORM2004Tracking::_syncReadEvent($packageId, $userId, "sahs", $refId, $time_from_lms);
688  }
689  //end sync access number and time in read event table
690  }
$time_from_lms
$time_from_lms
Definition: storeScorm2004.php:41
$packageId
$packageId
Definition: storeScorm.php:25
$refId
$refId
Definition: xapitoken.php:58
$DIC
global $DIC
Definition: feed.php:28
ilSCORM2004Tracking\_syncReadEvent
static _syncReadEvent(int $a_obj_id, int $a_user_id, string $a_type, int $a_ref_id, ?bool $time_from_lms=null)
Synch read event table.
Definition: class.ilSCORM2004Tracking.php:323
ilLPStatus\writeStatus
static writeStatus(int $a_obj_id, int $a_user_id, int $a_status, int $a_percentage=0, bool $a_force_per=false, ?int &$a_old_status=self::LP_STATUS_NOT_ATTEMPTED_NUM)
Write status for user and object.
Definition: class.ilLPStatus.php:426
+ Here is the call graph for this function:
+ Here is the caller graph for this function:

◆ writeGObjective()

static ilSCORM2004StoreData::writeGObjective ( int  $user,
int  $package,
?array  $g_data 
)
static
Returns
mixed[]|null[]

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

References $DIC, $ilDB, ILIAS\LTI\ToolProvider\$key, $res, $scope, and ilLoggerFactory\getLogger().

Referenced by setGlobalObjectives().

437  : array
438  {
439  global $DIC;
440  $ilDB = $DIC->database();
441  $ilLog = ilLoggerFactory::getLogger('sc13');
442  $ilLog->debug("SCORM2004 writeGObjective");
443 
444  $returnAr = array(null, null, null);
445 
446  //iterate over assoziative array
447  if ($g_data == null) {
448  return $returnAr;
449  }
450 
451  $rows_to_insert = array();
452 
453  foreach ($g_data as $key => $value) {
454  $ilLog->debug("SCORM2004 writeGObjective -key: " . $key);
455  //objective
456  //learner = ilias learner id
457  //scope = null / course
458  foreach ($value as $skey => $svalue) {
459  $ilLog->debug("SCORM2004 writeGObjective -skey: " . $skey);
460  //we always have objective and learner id
461 // var_dump($svalue->$user->{"null"});
462 // die();
463 // if ($g_data->$key->$skey->$user->$package) { //check
464 // $o_value = $g_data->$key->$skey->$user->$package;
465 // $scope = $package;
466 // } else { //UK: is this okay? can $scope=0 and $user->{"null"}; when is $scope used?
467 // //scope 0
468 // $o_value = $g_data->$key->$skey->$user->{"null"};
469 // //has to be converted to NULL in JS Later
470 // $scope = 0;
471 // }
472  if (isset($svalue->$user->$package)) {
473  $o_value = $svalue->$user->$package;
474  $scope = $package;
475  } else { //UK: is this okay? can $scope=0 and $user->{"null"}; when is $scope used?
476  //scope 0
477  $o_value = null;
478  //has to be converted to NULL in JS Later
479  $scope = 0;
480  }
481 
482  //insert into database
483  $objective_id = $skey;
484  $toset = $o_value;
485  $dbuser = $user;
486  if ($key === "status") {
487  //special handling for status
488 // $completed = $g_data->$key->$skey->$user->{"completed"};
489 // $measure = $g_data->$key->$skey->$user->{"measure"};
490 // $satisfied = $g_data->$key->$skey->$user->{"satisfied"};
491  $completed = $svalue->$user->{"completed"};
492  $measure = $svalue->$user->{"measure"};
493  $satisfied = $svalue->$user->{"satisfied"};
494 
495  $returnAr = array($completed, $satisfied, $measure);
496 
497  $obj = '-course_overall_status-';
498  $pkg_id = $package;
499 
500  $res = $ilDB->queryF(
501  '
502  SELECT user_id FROM cmi_gobjective
503  WHERE objective_id =%s
504  AND user_id = %s
505  AND scope_id = %s',
506  array('text', 'integer', 'integer'),
507  array($obj, $dbuser, $pkg_id)
508  );
509  $ilLog->debug("SCORM2004 Count is: " . $ilDB->numRows($res));
510  if (!$ilDB->numRows($res)) {
511  $ilDB->manipulateF(
512  '
513  INSERT INTO cmi_gobjective
514  (user_id, status, scope_id, measure, satisfied, objective_id)
515  VALUES (%s, %s, %s, %s, %s, %s)',
516  array('integer', 'text', 'integer', 'text', 'text', 'text'),
517  array($dbuser, $completed, $pkg_id, $measure, $satisfied, $obj)
518  );
519  $ilLog->debug("SCORM2004 cmi_gobjective Insert status=" . $completed . " scope_id=" . $pkg_id . " measure=" . $measure . " satisfied=" . $satisfied . " objective_id=" . $obj);
520  } else {
521  $ilDB->manipulateF(
522  '
523  UPDATE cmi_gobjective
524  SET status = %s,
525  measure = %s,
526  satisfied = %s
527  WHERE objective_id = %s
528  AND user_id = %s
529  AND scope_id = %s',
530  array('text', 'text', 'text', 'text', 'integer', 'integer'),
531  array($completed, $measure, $satisfied, $obj, $dbuser, $pkg_id)
532  );
533 // $ilLog->debug("SCORM2004 cmi_gobjective Update status=" . $completed . " scope_id=" . $pkg_id . " measure=" . $measure . " satisfied=" . $satisfied . " objective_id=" . $obj);
534  }
535  } else { //add it to the rows_to_insert
536  //create the row if this is the first time it has been found
537  if ($rows_to_insert[$objective_id] == null) {
538  $rows_to_insert[$objective_id] = array();
539  }
540  $rows_to_insert[$objective_id][$key] = $toset;
541  }
542  }
543  }
544 
545  //Get the scope for all the global objectives!!!
546  $res = $ilDB->queryF(
547  "SELECT global_to_system FROM cp_package WHERE obj_id = %s",
548  array('text'),
549  array($package)
550  );
551 
552  $scope_id = ($ilDB->fetchObject($res)->global_to_system) ? 0 : $package;
553 
554  //build up the set to look for in the query
555  $existing_key_template = "";
556  foreach (array_keys($rows_to_insert) as $obj_id) {
557  $existing_key_template .= "'{$obj_id}',";
558  }
559  //remove trailing ','
560  $existing_key_template = substr($existing_key_template, 0, -1);
561  $existing_keys = array();
562 
563  if ($existing_key_template != "") {
564  //Get the ones that need to be updated in a single query
565  $res = $ilDB->queryF(
566  "SELECT objective_id
567  FROM cmi_gobjective
568  WHERE user_id = %s
569  AND scope_id = %s
570  AND objective_id IN ($existing_key_template)",
571  array('integer', 'integer'),
572  array($dbuser, $scope_id)
573  );
574 
575  while ($row = $ilDB->fetchAssoc($res)) {
576  $existing_keys[] = $row['objective_id'];
577  }
578  }
579 
580  foreach ($rows_to_insert as $obj_id => $vals) {
581  if (in_array($obj_id, $existing_keys)) {
582  $ilDB->manipulateF(
583  "UPDATE cmi_gobjective
584  SET satisfied=%s,
585  measure=%s,
586  score_raw=%s,
587  score_min=%s,
588  score_max=%s,
589  completion_status=%s,
590  progress_measure=%s
591  WHERE objective_id = %s
592  AND user_id = %s
593  AND scope_id = %s",
594  array('text',
595  'text',
596  'text',
597  'text',
598  'text',
599  'text',
600  'text',
601  'text',
602  'integer',
603  'integer'
604  ),
605  array($vals['satisfied'],
606  $vals["measure"],
607  $vals["score_raw"],
608  $vals["score_min"],
609  $vals["score_max"],
610  $vals["completion_status"],
611  $vals["progress_measure"],
612  $obj_id,
613  $dbuser,
614  $scope_id
615  )
616  );
617  } else {
618  $ilDB->manipulateF(
619  "INSERT INTO cmi_gobjective
620  (user_id, satisfied, measure, scope_id, status, objective_id,
621  score_raw, score_min, score_max, progress_measure, completion_status)
622  VALUES(%s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s)",
623  array('integer',
624  'text',
625  'text',
626  'integer',
627  'text',
628  'text',
629  'text',
630  'text',
631  'text',
632  'text',
633  'text'
634  ),
635  array($dbuser,
636  $vals['satisfied'],
637  $vals['measure'],
638  $scope_id,
639  null,
640  $obj_id,
641  $vals['score_raw'],
642  $vals['score_min'],
643  $vals['score_max'],
644  $vals['progress_measure'],
645  $vals['completion_status']
646  )
647  );
648  }
649  }
650 
651  // update learning progress here not necessary because integrated in setCMIdata
652  // check _updateStatus for cmi_gobjective
653  // ilLPStatusWrapper::_updateStatus($package, $user);
654 
655  return $returnAr;
656  }
$res
$res
Definition: ltiservices.php:69
$scope
$scope
Definition: ltiregstart.php:53
ilLoggerFactory\getLogger
static getLogger(string $a_component_id)
Get component logger.
Definition: class.ilLoggerFactory.php:89
$DIC
global $DIC
Definition: feed.php:28
ILIAS\LTI\ToolProvider\$key
string $key
Consumer key/client ID value.
Definition: System.php:193
+ 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: