Collaboration diagram for ilSCORMOfflineMode:

Public Member Functions
	__construct ()
	Constructor. More...

	il2sop ()

	getClientIdSop ()

	il2sopUserData ()

	il2sopSahsUser ()

	sop2il ()

	scormPlayerUnloadForSop2il ($data)

	setOfflineMode ($a_mode)

	getOfflineMode ()

Static Public Member Functions
static	checkIfAnyoneIsInOfflineMode ($obj_id)

static	usersInOfflineMode ($obj_id)

static	stopOfflineModeForUser ($obj_id, $user_id)

Data Fields
	$type

	$obj_id

	$offlineMode

Private Member Functions
	read ()

Detailed Description

Class ilSCORMOfflineMode.

Class for scorm offline player connection

Author: Uwe Kohnle kohnl.nosp@m.e@in.nosp@m.terne.nosp@m.tleh.nosp@m.rer-g.nosp@m.mbh..nosp@m.de

Version

Id: class.ilSCORMOfflineMode.php

Definition at line 16 of file class.ilSCORMOfflineMode.php.

Constructor & Destructor Documentation

◆ __construct()

ilSCORMOfflineMode::__construct ( )

Constructor.

Parameters

int $a_id Object ID public

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

References $_GET, ilObject\_lookupObjectId(), ilObjSAHSLearningModule\_lookupSubType(), and read().

         {
                 global $ilias;
                 $this->ilias = $ilias;
                 $this->id = $_GET['ref_id'];
                 $this->obj_id = ilObject::_lookupObjectId($_GET['ref_id']);
                 include_once "./Modules/ScormAicc/classes/class.ilObjSAHSLearningModule.php";
                 $this->type = ilObjSAHSLearningModule::_lookupSubType($this->obj_id);
                 $this->read();
         }

Here is the call graph for this function:

Member Function Documentation

◆ checkIfAnyoneIsInOfflineMode()

static ilSCORMOfflineMode::checkIfAnyoneIsInOfflineMode ( $obj_id )

static

Definition at line 295 of file class.ilSCORMOfflineMode.php.

References $ilDB, $res, and array.

Referenced by ilObjSCORM2004LearningModuleGUI\initPropertiesForm(), and ilObjSCORMLearningModuleGUI\properties().

                                                                      {
                 global $ilDB;
                 $res = $ilDB->queryF("SELECT count(*) cnt FROM sahs_user WHERE obj_id=%s AND offline_mode = 'offline'",
                         array('integer'),
                         array($obj_id)
                 );
                 $val_rec = $ilDB->fetchAssoc($res);
                 if ($val_rec["cnt"] == 0) return false;
                 return true;
         }

Here is the caller graph for this function:

◆ getClientIdSop()

ilSCORMOfflineMode::getClientIdSop ( )

Definition at line 110 of file class.ilSCORMOfflineMode.php.

                                   {
                 $iliasDomain = substr(ILIAS_HTTP_PATH,7);
                 if (substr($iliasDomain,0,1) == "\/") $iliasDomain = substr($iliasDomain,1);
                 if (substr($iliasDomain,0,4) == "www.") $iliasDomain = substr($iliasDomain,4);
                 return $iliasDomain.';'.CLIENT_ID;
         }

◆ getOfflineMode()

ilSCORMOfflineMode::getOfflineMode ( )

Definition at line 275 of file class.ilSCORMOfflineMode.php.

References $offlineMode.

                                   {
                 return $this->offlineMode;
         }

◆ il2sop()

ilSCORMOfflineMode::il2sop ( )

Definition at line 39 of file class.ilSCORMOfflineMode.php.

References $_GET, $ilUser, $obj_id, $result, ilObject\_lookupDescription(), ilObject\_lookupTitle(), array, ilObjSCORMInitData\get_max_attempts(), ilObjSCORMInitData\getIliasScormData(), ilObjSCORMInitData\getIliasScormResources(), ilObjSCORMInitData\getIliasScormTree(), ilObjSCORMInitData\getIliasScormVars(), ilObjectLP\getInstance(), header, il2sopSahsUser(), il2sopUserData(), and setOfflineMode().

                           {
                 global $ilUser, $ilias;
                 $this->setOfflineMode("il2sop");
                 header('Content-Type: text/javascript; charset=UTF-8');
 
                 include_once "./Modules/ScormAicc/classes/class.ilObjSAHSLearningModule.php";
                 $ob = new ilObjSAHSLearningModule($this->id);
                 $module_version = $ob->getModuleVersion();
                 $sahs_user = $this->il2sopSahsUser();
                 $support_mail = "";//TODO
                 $scorm_version = "1.2";
                 if ($this->type == "scorm2004") $scorm_version = "2004";
                 $tree="";
                 
                 $learning_progress_enabled = 1;
                 include_once './Services/Object/classes/class.ilObjectLP.php';
                 $olp = ilObjectLP::getInstance($this->obj_id);
                 if ($olp->getCurrentMode() == 0) $learning_progress_enabled = 0;
                 
                 $certificate_enabled = 0;
 
                 $adlact_data = null;
                 $ilias_version = $ilias->getSetting("ilias_version");
 
                 if ($this->type == 'scorm2004') {
                         include_once "./Modules/Scorm2004/classes/ilSCORM13Player.php";
                         $ob2004 = new ilSCORM13Player();
                         $init_data = $ob2004->getConfigForPlayer();
                         $resources = json_decode($ob2004->getCPDataInit());
                         $cmi = $ob2004->getCMIData($ilUser->getID(), $this->obj_id);
                         $max_attempt = $ob2004->get_max_attempts();
                         $adlact_data = json_decode($ob2004->getADLActDataInit());
                         //$globalobj_data = $ob2004->readGObjectiveInit();      
                 } else {
                         include_once "./Modules/ScormAicc/classes/SCORM/class.ilObjSCORMInitData.php";
                         $slm_obj = new ilObjSCORMLearningModule($_GET["ref_id"]);
                         $init_data = ilObjSCORMInitData::getIliasScormVars($slm_obj);
                         $resources = json_decode(ilObjSCORMInitData::getIliasScormResources($this->obj_id));
                         $tree = json_decode(ilObjSCORMInitData::getIliasScormTree($this->obj_id));
                         $cmi = json_decode(ilObjSCORMInitData::getIliasScormData($this->obj_id));
                         $max_attempt = ilObjSCORMInitData::get_max_attempts($this->obj_id);
                 }
                 if ($max_attempt == null) $max_attempt = 0;
                 $result = array(
                         'client_data' => array(
                                 $support_mail
                         ),
                         'user_data' => $this->il2sopUserData(),
                         'lm' => array(
                                 ilObject::_lookupTitle($this->obj_id),
                                 ilObject::_lookupDescription($this->obj_id),
                                 $scorm_version,
                                 1,//active
                                 $init_data,
                                 $resources,
                                 $tree,
                                 $module_version,
                                 "", //offline_zip_created!!!!!!!!
                                 $learning_progress_enabled,
                                 $certificate_enabled,
                                 $max_attempt,
                                 $adlact_data,
                                 $ilias_version
                         ),
                         'sahs_user' => $sahs_user,
                         'cmi' => $cmi
                 );
                 
                 print(json_encode($result));
         }

Here is the call graph for this function:

◆ il2sopSahsUser()

ilSCORMOfflineMode::il2sopSahsUser ( )

Definition at line 129 of file class.ilSCORMOfflineMode.php.

References $ilDB, $ilUser, $res, $row, ilChangeEvent\_lookupReadEvents(), and array.

Referenced by il2sop().

                                   {
                 global $ilDB,$ilUser;
                 $package_attempts       = 0;
                 $module_version         = 1;//if module_version in sop is different...
                 $last_visited           = "";
                 $first_access           = null;
                 $last_access            = null;
                 $last_status_change     = null;
                 $total_time_sec         = null;
                 $sco_total_time_sec     = 0;
                 $status                         = 0;
                 $percentage_completed = 0;
                 $user_data                      = "";
 
                 global $ilDB,$ilUser;
                 $res = $ilDB->queryF('SELECT * FROM sahs_user WHERE obj_id=%s AND user_id=%s',
                         array('integer','integer'),
                         array($this->obj_id,$ilUser->getID())
                 );
                 while($row = $ilDB->fetchAssoc($res))
                 {
                         $package_attempts = $row['package_attempts'];
                         $module_version = $row['module_version'];
                         $last_visited = $row['last_visited'];
                         if ($row['first_access'] != null) {
                                 $first_access = strtotime($row['first_access'])*1000;//check Oracle!
                         }
                         if ($row['last_access'] != null) {
                                 $last_access = strtotime($row['last_access'])*1000;//check Oracle!
                         }
                         $total_time_sec = $row['total_time_sec'];
                         $sco_total_time_sec = $row['sco_total_time_sec'];
                         $status = $row['status'];
                         $percentage_completed = $row['percentage_completed'];
                 }
                 if ($first_access == null) {
                         include_once './Services/Tracking/classes/class.ilChangeEvent.php';
                         $all = ilChangeEvent::_lookupReadEvents($this->obj_id,$ilUser->getID());
                         foreach($all as $event)
                         {
                                 $first_access = strtotime($event['first_access'])*1000;//
                         }
                 }
                 return array($package_attempts, $module_version, $last_visited, $first_access, $last_access, $last_status_change, $total_time_sec, $sco_total_time_sec, $status, $percentage_completed, $user_data);
         }

Here is the call graph for this function:

Here is the caller graph for this function:

◆ il2sopUserData()

ilSCORMOfflineMode::il2sopUserData ( )

Definition at line 117 of file class.ilSCORMOfflineMode.php.

References $ilUser, and array.

Referenced by il2sop().

                                   {
                 global $ilUser;
                 return array(
                         $ilUser->getLogin(),
                         "",
                         $ilUser->getFirstname(),
                         $ilUser->getLastname(),
                         $ilUser->getUTitle(),
                         $ilUser->getGender(),
                         $ilUser->getID()
                         );
         }

Here is the caller graph for this function:

◆ read()

ilSCORMOfflineMode::read ( )

private

Definition at line 279 of file class.ilSCORMOfflineMode.php.

References $ilDB, $ilUser, $res, $row, and array.

Referenced by __construct().

                                 {
                 global $ilDB,$ilUser;
                 $res = $ilDB->queryF('SELECT offline_mode FROM sahs_user WHERE obj_id=%s AND user_id=%s',
                         array('integer','integer'),
                         array($this->obj_id,$ilUser->getId())
                 );
                 while($row = $ilDB->fetchAssoc($res))
                 {
                         if ($row['offline_mode'] != null) {
                                 $this->offlineMode = $row['offline_mode'];
                         } else {
                                 $this->offlineMode = "online";
                         }
                 }
         }

Here is the caller graph for this function:

◆ scormPlayerUnloadForSop2il()

ilSCORMOfflineMode::scormPlayerUnloadForSop2il ( $data )

Definition at line 242 of file class.ilSCORMOfflineMode.php.

References $data, $GLOBALS, $ilDB, $ilUser, $res, ilChangeEvent\_updateAccessForScormOfflinePlayer(), array, and date.

                                                    {
                 global $ilDB,$ilUser;
                 $first_access=null;
                 if($data->first_access != null) $first_access=date('Y-m-d H:i:s',round($data->first_access/1000));
                 $last_access=null;
                 $i_last_access=null;
                 if($data->last_access != null) {
                         $i_last_access = round($data->last_access/1000);
                         $last_access=date('Y-m-d H:i:s',$i_last_access);
                         include_once("./Services/Tracking/classes/class.ilChangeEvent.php");
                         ilChangeEvent::_updateAccessForScormOfflinePlayer($this->obj_id,$ilUser->getId(), $i_last_access, $first_access);
                 }
                 $last_status_change=null;
                 if($data->last_status_change != null) $last_status_change=date('Y-m-d H:i:s',round($data->last_status_change/1000));
                 $GLOBALS['ilLog']->write('first_access='.$first_access);
                 $res = $ilDB->queryF('UPDATE sahs_user SET first_access=%s, last_access=%s, last_status_change=%s, last_visited=%s, module_version=%s WHERE obj_id=%s AND user_id=%s',
                         array('timestamp','timestamp','timestamp','text','integer','integer','integer'),
                         array($first_access,$last_access,$last_status_change,$data->last_visited,$data->module_version, $this->obj_id,$ilUser->getId())
                 );
 
                 //populate last_status_change
                 return true;
         }

Here is the call graph for this function:

◆ setOfflineMode()

ilSCORMOfflineMode::setOfflineMode ( $a_mode )

Definition at line 267 of file class.ilSCORMOfflineMode.php.

References $ilDB, $ilUser, $res, and array.

Referenced by il2sop().

                                          {
                 global $ilDB,$ilUser;
                 $res = $ilDB->queryF('UPDATE sahs_user SET offline_mode=%s WHERE obj_id=%s AND user_id=%s',
                         array('text','integer','integer'),
                         array($a_mode, $this->obj_id,$ilUser->getId())
                 );
                 $this->offlineMode=$a_mode;
         }

Here is the caller graph for this function:

◆ sop2il()

ilSCORMOfflineMode::sop2il ( )

Definition at line 175 of file class.ilSCORMOfflineMode.php.

References $data, $GLOBALS, $ilDB, $ilUser, $in, $lm_set, $result, $ret, array, exit, header, ilSCORM2004StoreData\setCMIData(), ilObjSCORMTracking\storeJsApiCmi(), ilObjSCORMTracking\syncGlobalStatus(), ilSCORM2004StoreData\syncGlobalStatus(), and ilUtil\yn2tf().

                           {
 //              sleep(5);
                 global $ilDB,$ilUser;
                 $in = file_get_contents("php://input");
                 $GLOBALS['ilLog']->write($in);
                 $ret = array('msg'=>array(),'err'=>array());
                 
                 if (!$in || $in == "") {
                         $ret['err'][] = "no post data recieved";
                         print(json_encode($ret));
                         exit;
                 }
                 $userId=$ilUser->getID();
                 $result=true;
 
                 if ($this->type == 'scorm2004') {
                         $lm_set = $ilDB->queryF('SELECT default_lesson_mode, interactions, objectives, comments, time_from_lms FROM sahs_lm WHERE id = %s', array('integer'),array($this->obj_id));
                         while($lm_rec = $ilDB->fetchAssoc($lm_set))
                         {
                                 $defaultLessonMode=($lm_rec["default_lesson_mode"]);
                                 $interactions=(ilUtil::yn2tf($lm_rec["interactions"]));
                                 $objectives=(ilUtil::yn2tf($lm_rec["objectives"]));
                                 $comments=(ilUtil::yn2tf($lm_rec["comments"]));
                                 $time_from_lms=(ilUtil::yn2tf($lm_rec["time_from_lms"]));
                         }
                         include_once './Modules/Scorm2004/classes/class.ilSCORM2004StoreData.php';
                         $data = json_decode($in);
                         $GLOBALS['ilLog']->write('cmi_count='.count($data->cmi));
                         for ($i=0; $i<count($data->cmi); $i++) {
                                 if($result==true) {
                                         //$a_r=array();
                                         $cdata=$data->cmi[$i];
                                         $a_r = ilSCORM2004StoreData::setCMIData(
                                                 $userId, 
                                                 $this->obj_id, 
                                                 $data->cmi[$i],//json_decode($data->cmi[$i]), 
                                                 $comments,
                                                 $interactions,
                                                 $objectives
                                                 );
                                         if (!is_array($a_r)) $result=false; 
                                 }
                         }
                         if ($result==true) {
                                 $result=ilSCORM2004StoreData::syncGlobalStatus($userId, $this->obj_id, $data, $data->now_global_status, $time_from_lms);
                         }
                 } else {
                         include_once "./Modules/ScormAicc/classes/SCORM/class.ilObjSCORMTracking.php";
                         $data = json_decode($in);
                         $result=ilObjSCORMTracking::storeJsApiCmi($userId,$this->obj_id,$data);
                         if ($result==true) {
                                 $result=ilObjSCORMTracking::syncGlobalStatus($userId, $this->obj_id, $data, $data->now_global_status);
                         }
                 }
                 if ($result==true) {
                         $result=self::scormPlayerUnloadForSOP2il($data);
                 }
 
                 if ($result==false) {
                         $ret['err'][] = "invalid post data recieved";
                 } else {
                         $ret['msg'][]  = "post data recieved";
                 }
                 header('Content-Type: text/plain; charset=UTF-8');
                 print json_encode($ret);
         }

Here is the call graph for this function:

◆ stopOfflineModeForUser()

static ilSCORMOfflineMode::stopOfflineModeForUser	(	$obj_id,
		$user_id
	)

static

Definition at line 321 of file class.ilSCORMOfflineMode.php.

References $ilDB, $res, and array.

Referenced by ilObjSCORMLearningModuleGUI\confirmedStopUserOfflineMode().

                                                                         {
                 global $ilDB;
                 $res = $ilDB->queryF("UPDATE sahs_user SET offline_mode='online' WHERE obj_id=%s AND user_id=%s",
                         array('integer','integer'),
                         array($obj_id,$user_id)
                 );
         }

Here is the caller graph for this function:

◆ usersInOfflineMode()

static ilSCORMOfflineMode::usersInOfflineMode ( $obj_id )

static

Definition at line 306 of file class.ilSCORMOfflineMode.php.

References $ilDB, $res, $row, and array.

Referenced by ilSCORMOfflineModeUsersTableGUI\parse().

                                                            {
                 global $ilDB;
                 $users = array();
                 $res = $ilDB->queryF("SELECT user_id, lastname, firstname FROM sahs_user, usr_data "
                                                         ."WHERE sahs_user.obj_id=%s AND sahs_user.offline_mode = 'offline' AND sahs_user.user_id=usr_data.usr_id",
                         array('integer'),
                         array($obj_id)
                 );
                 while($row = $ilDB->fetchAssoc($res))
                 {
                         $users[] = $row;
                 }
                 return $users;
         }