Collaboration diagram for ilSCORMOfflineMode:

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

	il2sop ()

	getClientIdSop ()

	il2sopUserData ()

	il2sopSahsUser ()

	sop2il ()

	scormPlayerUnloadForSop2il ($data)

	setOfflineMode ($a_mode)

	getOfflineMode ()

	checkIfAnyoneIsInOfflineMode ($obj_id)

	usersInOfflineMode ($obj_id)

	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 @access public

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

        {
                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();
        }

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

Here is the call graph for this function:

Member Function Documentation

◆ checkIfAnyoneIsInOfflineMode()

ilSCORMOfflineMode::checkIfAnyoneIsInOfflineMode ( $obj_id )

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

                                                              {
                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;
        }

References $ilDB, $obj_id, and $res.

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

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 274 of file class.ilSCORMOfflineMode.php.

                                  {
                return $this->offlineMode;
        }

References $offlineMode.

◆ il2sop()

ilSCORMOfflineMode::il2sop ( )

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

                          {
                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));
        }

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

Here is the call graph for this function:

◆ il2sopSahsUser()

ilSCORMOfflineMode::il2sopSahsUser ( )

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

                                  {
                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);
        }

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

Referenced by il2sop().

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.

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

References $ilUser.

Referenced by il2sop().

Here is the caller graph for this function:

◆ read()

ilSCORMOfflineMode::read ( )

private

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

                                {
                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";
                        }
                }
        }

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

Referenced by __construct().

Here is the caller graph for this function:

◆ scormPlayerUnloadForSop2il()

ilSCORMOfflineMode::scormPlayerUnloadForSop2il ( $data )

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

                                                   {
                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;
        }

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

Here is the call graph for this function:

◆ setOfflineMode()

ilSCORMOfflineMode::setOfflineMode ( $a_mode )

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

                                         {
                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;
        }

References $ilDB, $ilUser, and $res.

Referenced by il2sop().

Here is the caller graph for this function:

◆ sop2il()

ilSCORMOfflineMode::sop2il ( )

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

                          {
//              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 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"]));
                        }
                        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);
                        }
                } 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);
        }

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

Here is the call graph for this function:

◆ stopOfflineModeForUser()

ilSCORMOfflineMode::stopOfflineModeForUser	(	$obj_id,
		$user_id
	)

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

                                                                 {
                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)
                );
        }

References $ilDB, $obj_id, and $res.

Referenced by ilObjSCORMLearningModuleGUI\confirmedStopUserOfflineMode().

Here is the caller graph for this function:

◆ usersInOfflineMode()

ilSCORMOfflineMode::usersInOfflineMode ( $obj_id )

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

                                                    {
                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;
        }