16 $this->insert = array();
17 if (is_array(
$_GET[
"iL"])) {
19 $this->insert[] = array(
"left" => $value,
"right" =>
$_GET[
"iR"][
$key]);
22 if (is_array(
$_POST[
"iL"])) {
24 $this->insert[] = array(
"left" => $value,
"right" =>
$_POST[
"iR"][
$key]);
29 if (is_array(
$_GET[
"uL"])) {
31 $this->
update[] = array(
"left" => $value,
"right" =>
$_GET[
"uR"][
$key]);
34 if (is_array(
$_POST[
"uL"])) {
41 public function store($obj_id=0, $sahs_id=0, $extractData=1)
45 $ref_id =
$_GET[
"ref_id"];
51 $f = fopen(
"./Modules/ScormAicc/log/scorm.log",
"a");
52 fwrite($f,
"\nCALLING SCORM store()\n");
53 fwrite($f,
'POST: ' . print_r(
$_POST,
true));
56 if (empty($sahs_id)) {
60 if ($extractData==1) {
71 fwrite($f,
"Error: No obj_id given.\n");
73 foreach ($this->insert as
$insert) {
76 SELECT * FROM scorm_tracking
81 array(
'integer',
'integer',
'text',
'integer'),
82 array($user_id,$sahs_id,
$insert[
"left"],$obj_id)
84 if ($rec =
$ilDB->fetchAssoc($set)) {
85 fwrite($f,
"Error Insert, left value already exists. L:" .
$insert[
"left"] .
",R:" .
86 $insert[
"right"] .
",sahs_id:" . $sahs_id .
",user_id:" . $user_id .
"\n");
88 $ilDB->insert(
'scorm_tracking', array(
89 'obj_id' => array(
'integer', $obj_id),
90 'user_id' => array(
'integer', $user_id),
91 'sco_id' => array(
'integer', $sahs_id),
92 'lvalue' => array(
'text',
$insert[
"left"]),
93 'rvalue' => array(
'clob',
$insert[
"right"]),
97 fwrite($f,
"Insert - L:" .
$insert[
"left"] .
",R:" .
98 $insert[
"right"] .
",sahs_id:" . $sahs_id .
",user_id:" . $user_id .
"\n");
101 foreach ($this->
update as $update) {
102 $set =
$ilDB->queryF(
104 SELECT * FROM scorm_tracking
109 array(
'integer',
'integer',
'text',
'integer'),
110 array($user_id,$sahs_id,$update[
"left"],$obj_id)
113 if ($rec =
$ilDB->fetchAssoc($set)) {
117 'rvalue' => array(
'clob', $update[
"right"]),
121 'user_id' => array(
'integer', $user_id),
122 'sco_id' => array(
'integer', $sahs_id),
123 'lvalue' => array(
'text', $update[
"left"]),
124 'obj_id' => array(
'integer', $obj_id)
128 fwrite($f,
"ERROR Update, left value does not exist. L:" . $update[
"left"] .
",R:" .
129 $update[
"right"] .
",sahs_id:" . $sahs_id .
",user_id:" . $user_id .
"\n");
136 include_once(
"./Services/Tracking/classes/class.ilLPStatusWrapper.php");
152 $obj_id = (int)
$_GET[
"package_id"];
153 $in = file_get_contents(
"php://input");
156 $user_id = (int)
$data->p;
158 header(
'Content-Type: text/plain; charset=UTF-8');
162 print(
"storeJsApiCmi failed");
166 print(
"syncGlobalStatus failed");
178 $b_updateStatus=
false;
181 if (
$ilLog->current_log_level == 30) {
186 $ilLog->write(
"ScormAicc: CALLING SCORM storeJsApi() " .
$_POST);
197 $aa_data[] = array(
"sco_id" => (
int)
$data->cmi[
$i][0],
"left" =>
$data->cmi[
$i][1],
"right" =>
$data->cmi[
$i][2]);
202 $ilLog->write(
"ScormAicc: storeJsApi: Error: No valid obj_id given.");
204 foreach ($aa_data as $a_data) {
205 $set =
$ilDB->queryF(
207 SELECT rvalue FROM scorm_tracking
212 array(
'integer',
'integer',
'text',
'integer'),
213 array($user_id,$a_data[
"sco_id"],$a_data[
"left"],$obj_id)
215 if ($rec =
$ilDB->fetchAssoc($set)) {
216 if ($a_data[
"left"] ==
'cmi.core.lesson_status' && $a_data[
"right"] != $rec[
"rvalue"]) {
217 $b_updateStatus =
true;
222 'rvalue' => array(
'clob', $a_data[
"right"]),
226 'user_id' => array(
'integer', $user_id),
227 'sco_id' => array(
'integer', $a_data[
"sco_id"]),
228 'lvalue' => array(
'text', $a_data[
"left"]),
229 'obj_id' => array(
'integer', $obj_id)
233 $ilLog->write(
"ScormAicc: storeJsApi Updated - L:" . $a_data[
"left"] .
",R:" .
234 $a_data[
"right"] .
" for obj_id:" . $obj_id .
",sco_id:" . $a_data[
"sco_id"] .
",user_id:" . $user_id);
237 if ($a_data[
"left"] ==
'cmi.core.lesson_status') {
238 $b_updateStatus =
true;
240 $ilDB->insert(
'scorm_tracking', array(
241 'obj_id' => array(
'integer', $obj_id),
242 'user_id' => array(
'integer', $user_id),
243 'sco_id' => array(
'integer', $a_data[
"sco_id"]),
244 'lvalue' => array(
'text', $a_data[
"left"]),
245 'rvalue' => array(
'clob', $a_data[
"right"]),
249 $ilLog->write(
"ScormAicc: storeJsApi Inserted - L:" . $a_data[
"left"] .
",R:" .
250 $a_data[
"right"] .
" for obj_id:" . $obj_id .
",sco_id:" . $a_data[
"sco_id"] .
",user_id:" . $user_id);
269 $saved_global_status=
$data->saved_global_status;
270 $ilLog->write(
"saved_global_status=" . $saved_global_status);
273 if (!
$data->packageAttempts) {
274 $val_set =
$ilDB->queryF(
275 'SELECT package_attempts FROM sahs_user WHERE obj_id = %s AND user_id = %s',
276 array(
'integer',
'integer'),
279 $val_rec =
$ilDB->fetchAssoc($val_set);
280 $attempts = $val_rec[
"package_attempts"];
282 $attempts=
$data->packageAttempts;
284 if ($attempts ==
null) {
289 $totalTime=(int)
$data->totalTimeCentisec;
290 $totalTime=round($totalTime/100);
292 'UPDATE sahs_user SET last_visited=%s, last_access = %s, sco_total_time_sec=%s, status=%s, percentage_completed=%s, package_attempts=%s WHERE obj_id = %s AND user_id = %s',
293 array(
'text',
'timestamp',
'integer',
'integer',
'integer',
'integer',
'integer',
'integer'),
294 array(
$data->last_visited,
date(
'Y-m-d H:i:s'), $totalTime, $new_global_status,
$data->percentageCompleted, $attempts,
$packageId, $userId)
298 global $ilObjDataCache;
299 include_once(
"./Services/Tracking/classes/class.ilChangeEvent.php");
305 if ($new_global_status !=
null) {
306 include_once(
"./Services/Tracking/classes/class.ilObjUserTracking.php");
307 include_once(
"./Services/Tracking/classes/class.ilLPStatus.php");
325 $val_set =
$ilDB->queryF(
326 'SELECT package_attempts, total_time_sec, sco_total_time_sec, time_from_lms FROM sahs_user, sahs_lm '
327 .
'WHERE sahs_user.obj_id = %s AND sahs_user.user_id = %s AND sahs_user.obj_id = sahs_lm.id',
328 array(
'integer',
'integer'),
329 array($a_obj_id,$a_user_id)
332 $val_rec =
$ilDB->fetchAssoc($val_set);
334 if ($val_rec[
"package_attempts"] ==
null) {
335 $val_rec[
"package_attempts"]=
"";
337 $attempts = $val_rec[
"package_attempts"];
343 $time = (int) $val_rec[
"sco_total_time_sec"];
348 $sco_set =
$ilDB->queryF(
350 SELECT sco_id, rvalue FROM scorm_tracking
355 array(
'integer',
'integer',
'text',
'integer'),
356 array($a_obj_id,$a_user_id,
'cmi.core.total_time',0)
359 while ($sco_rec =
$ilDB->fetchAssoc($sco_set)) {
360 $tarr = explode(
":", $sco_rec[
"rvalue"]);
361 $sec = (int) $tarr[2] + (
int) $tarr[1] * 60 +
362 (int) substr($tarr[0], strlen($tarr[0]) - 3) * 60 * 60;
367 include_once(
"./Services/Tracking/classes/class.ilChangeEvent.php");
375 $ilDB->insert(
'scorm_tracking', array(
376 'obj_id' => array(
'integer', $a_obj_id),
377 'user_id' => array(
'integer',
$ilUser->getId()),
378 'sco_id' => array(
'integer', $a_sahs_id),
379 'lvalue' => array(
'text', $a_lval),
380 'rvalue' => array(
'clob', $a_rval),
384 if ($a_lval ==
"cmi.core.lesson_status") {
385 include_once(
"./Services/Tracking/classes/class.ilLPStatusWrapper.php");
397 public static function _getInProgress($scorm_item_id, $a_obj_id, $a_blocked_user_ids =
null)
401 if (is_array($scorm_item_id)) {
402 $in =
$ilDB->in(
'sco_id', $scorm_item_id,
false,
'integer');
405 'SELECT user_id,sco_id FROM scorm_tracking
408 GROUP BY user_id, sco_id',
414 'SELECT user_id,sco_id FROM scorm_tracking
417 array(
'integer',
'integer'),
418 array($scorm_item_id,$a_obj_id)
422 $in_progress = array();
426 if (!($a_blocked_user_ids &&
427 is_array($a_blocked_user_ids[
$row->sco_id]) &&
428 in_array(
$row->user_id, $a_blocked_user_ids[
$row->sco_id]))) {
429 $in_progress[
$row->sco_id][] =
$row->user_id;
445 if (is_array($scorm_item_id)) {
446 $in =
$ilDB->in(
'sco_id', $scorm_item_id,
false,
'integer');
449 'SELECT DISTINCT(user_id) FROM scorm_tracking
453 AND (' .
$ilDB->like(
'rvalue',
'clob',
'completed') .
' OR ' .
$ilDB->like(
'rvalue',
'clob',
'passed') .
')',
454 array(
'integer',
'text'),
455 array($a_obj_id,
'cmi.core.lesson_status')
459 'SELECT DISTINCT(user_id) FROM scorm_tracking
463 AND (' .
$ilDB->like(
'rvalue',
'clob',
'completed') .
' OR ' .
$ilDB->like(
'rvalue',
'clob',
'passed') .
')',
464 array(
'integer',
'integer',
'text'),
465 array($scorm_item_id,$a_obj_id,
'cmi.core.lesson_status')
470 $user_ids[] =
$row->user_id;
472 return $user_ids ? $user_ids : array();
480 $status =
"not_attempted";
482 if (is_array($a_scos)) {
483 $in =
$ilDB->in(
'sco_id', $a_scos,
false,
'integer');
486 'SELECT sco_id, rvalue FROM scorm_tracking
491 array(
'integer',
'text',
'integer'),
492 array($a_obj_id,
'cmi.core.lesson_status', $a_user_id)
499 if ($rec[
"rvalue"] ==
"failed") {
502 if ($rec[
"rvalue"] !=
"completed" && $rec[
"rvalue"] !=
"passed") {
508 $status =
"in_progress";
510 if ($completed && $cnt == count($a_scos)) {
511 $status =
"completed";
525 if (is_array($a_scos)) {
526 $in =
$ilDB->in(
'sco_id', $a_scos,
false,
'integer');
529 'SELECT sco_id, rvalue FROM scorm_tracking
534 array(
'integer',
'text',
'integer'),
535 array($a_obj_id,
'cmi.core.lesson_status', $a_user_id)
540 if ($rec[
"rvalue"] ==
"completed" || $rec[
"rvalue"] ==
"passed") {
558 $query =
'SELECT user_id, MAX(c_timestamp) tst ' .
559 'FROM scorm_tracking ' .
560 'WHERE obj_id = ' .
$ilDB->quote($a_obj_id,
'integer') .
' ' .
582 'SELECT DISTINCT user_id FROM scorm_tracking
585 array(
'integer',
'text'),
586 array($a_obj_id,
'cmi.core.lesson_status')
606 if (is_array($scorm_item_id)) {
607 $in =
$ilDB->in(
'sco_id', $scorm_item_id,
false,
'integer');
611 SELECT DISTINCT(user_id) FROM scorm_tracking
615 AND ' .
$ilDB->like(
'rvalue',
'clob',
'failed') .
' ',
616 array(
'integer',
'text'),
617 array($a_obj_id,
'cmi.core.lesson_status')
622 SELECT DISTINCT(user_id) FROM scorm_tracking
626 AND ' .
$ilDB->like(
'rvalue',
'clob',
'failed') .
' ',
627 array(
'integer',
'integer',
'text'),
628 array($scorm_item_id,$a_obj_id,
'cmi.core.lesson_status')
633 $user_ids[] =
$row->user_id;
635 return $user_ids ? $user_ids : array();
648 $in =
$ilDB->in(
'sco_id', $a_scorm_item_ids,
false,
'integer');
654 SELECT user_id, COUNT(user_id) completed FROM scorm_tracking
658 AND (' .
$ilDB->like(
'rvalue',
'clob',
'completed') .
' OR ' .
$ilDB->like(
'rvalue',
'clob',
'passed') .
')
660 array(
'integer',
'text'),
661 array($a_obj_id,
'cmi.core.lesson_status')
679 $in =
$ilDB->in(
'sco_id', $sco_item_ids,
false,
'integer');
683 SELECT * FROM scorm_tracking
687 array(
'integer',
'text'),
688 array($a_obj_id,
'cmi.core.lesson_status')
691 $info[
'completed'] = array();
692 $info[
'failed'] = array();
696 switch (
$row->rvalue) {
700 $user_ids[
$row->sco_id][] =
$row->user_id;
705 $user_ids[
$row->sco_id][] =
$row->user_id;
719 $user_id = (int)
$_GET[
"p"];
720 $ref_id = (int)
$_GET[
"ref_id"];
722 $obj_id = (int)
$_GET[
"package_id"];
724 $GLOBALS[
'ilLog']->write(__METHOD__ .
' no valid obj_id');
726 $last_visited=
$_POST[
'last_visited'];
730 SET last_visited = %s, hash_end =%s, last_access = %s
731 WHERE obj_id = %s AND user_id = %s',
732 array(
'text',
'timestamp',
'timestamp',
'integer',
'integer'),
733 array($last_visited, $endDate,
date(
'Y-m-d H:i:s'), $obj_id, $user_id)
739 header(
'Content-Type: text/plain; charset=UTF-8');
747 'select hash from sahs_user where obj_id=%s AND user_id=%s AND hash_end>%s',
748 array(
'integer',
'integer',
'timestamp'),
752 if ($rowtmp[
'hash']==$hash) {
date( 'd-M-Y', $objPHPExcel->getProperties() ->getCreated())
if(php_sapi_name() !='cli') $in
An exception for terminatinating execution or to throw for unit testing.
static _recordReadEvent( $a_type, $a_ref_id, $obj_id, $usr_id, $isCatchupWriteEvents=true, $a_ext_rc=false, $a_ext_time=false)
Records a read event and catches up with write events.
static _updateStatus($a_obj_id, $a_usr_id, $a_obj=null, $a_percentage=false, $a_force_raise=false)
Update status.
static writeStatus($a_obj_id, $a_user_id, $a_status, $a_percentage=false, $a_force_per=false)
Write status for user and object.
Class ilObjSCORMTracking.
static _getTrackedUsers($a_obj_id)
Get all tracked users.
static _getProgressInfo($sco_item_ids, $a_obj_id)
Get info about.
static storeJsApi($obj_id=0)
static syncGlobalStatus($userId, $packageId, $data, $new_global_status)
static _getCompleted($scorm_item_id, $a_obj_id)
like necessary because of Oracle
static _countCompleted($a_scos, $a_obj_id, $a_user_id)
static _getInProgress($scorm_item_id, $a_obj_id, $a_blocked_user_ids=null)
static _getCollectionStatus($a_scos, $a_obj_id, $a_user_id)
static _syncReadEvent($a_obj_id, $a_user_id, $a_type, $a_ref_id)
Synch read event table.
static _getFailed($scorm_item_id, $a_obj_id)
like necessary because of Oracle
static lookupLastAccessTimes($a_obj_id)
Lookup last acccess time for all users of a scorm module @global ilDB $ilDB.
static storeJsApiCmi($user_id, $obj_id, $data)
static _getCountCompletedPerUser($a_scorm_item_ids, $a_obj_id)
Get users who have status completed or passed.
static _insertTrackData($a_sahs_id, $a_lval, $a_rval, $a_obj_id)
static checkIfAllowed($packageId, $userId, $hash)
store($obj_id=0, $sahs_id=0, $extractData=1)
static scorm12PlayerUnload()
static _lookupObjId($a_id)
static now()
Return current timestamp in Y-m-d H:i:s format.
$GLOBALS['loaded']
Global hash that tracks already loaded includes.
update($pash, $contents, Config $config)
foreach($_POST as $key=> $value) $res