ILIAS  release_5-1 Revision 5.0.0-5477-g43f3e3fab5f
Public Member Functions | Static Public Member Functions | Data Fields | Private Member Functions
ilObjSCORMLearningModule Class Reference
Modules/ScormAicc

Class ilObjSCORMLearningModule. More...

+ Inheritance diagram for ilObjSCORMLearningModule:
+ Collaboration diagram for ilObjSCORMLearningModule:

Public Member Functions

 ilObjSCORMLearningModule ($a_id=0, $a_call_by_reference=true)
 Constructor @access public. More...
 
 validate ($directory)
 Validate all XML-Files in a SCOM-Directory. More...
 
 getValidationSummary ()
 
 getTrackingItems ()
 
 _getTrackingItems ($a_obj_id)
 get all tracking items of scorm object @access static More...
 
 readObject ()
 read manifest file @access public More...
 
 setLearningProgressSettingsAtUpload ()
 set settings for learning progress determination per default at upload More...
 
 getTrackedItems ()
 get all tracked items of current user More...
 
 getTrackedUsers ($a_search)
 
 getAttemptsForUsers ()
 Get attempts for all users @global ilDB $ilDB. More...
 
 getAttemptsForUser ($a_user_id)
 get number of atttempts for a certain user and package More...
 
 getModuleVersionForUsers ()
 Get module version for users. More...
 
 getModuleVersionForUser ($a_user_id)
 get module version that tracking data for a user was recorded on More...
 
 getTrackingDataPerUser ($a_sco_id, $a_user_id)
 Get tracking data per user @global ilDB $ilDB. More...
 
 getTrackingDataAgg ($a_user_id)
 
 getTrackingDataAggSco ($a_sco_id)
 
 exportSelected ($a_all, $a_users=array())
 Export selected user tracking data @global ilDB $ilDB @global ilObjUser $ilUser. More...
 
 importTrackingData ($a_file)
 
 importSuccess ($a_file)
 
 importSuccessForSahsUser ($user_id, $last_access, $status, $attempts=null, $percentage_completed=null, $sco_total_time_sec=null)
 
 decreaseAttemptsForUser ($a_user_id)
 Decrease attempts for user @global ilDB $ilDB. More...
 
 get_user_id ($a_login)
 
 getUserIdEmail ($a_mail)
 assumes that only one account exists for a mailadress More...
 
 sendExportFile ($a_header, $a_content)
 send export file to browser More...
 
 getAllScoIds ()
 
 getStatusForUser ($a_user, $a_allScoIds, $a_numerical=false)
 
 getCourseCompletionForUser ($a_user)
 
 _getScoresForUser ($a_item_id, $a_user_id)
 
 getLastVisited ($user_id)
 
 deleteTrackingDataOfUsers ($a_users)
 
- Public Member Functions inherited from ilObjSAHSLearningModule
 ilObjSAHSLearningModule ($a_id=0, $a_call_by_reference=true)
 Constructor @access public. More...
 
 create ($upload=false)
 create file based lm More...
 
 read ()
 read object More...
 
 _lookupOnline ($a_id)
 check wether scorm module is online More...
 
 getAffectiveLocalization ($a_id)
 Get affective localization. More...
 
 _lookupSubType ($a_obj_id)
 lookup subtype id (scorm, aicc, hacp) More...
 
 setEditable ($a_editable)
 Set Editable. More...
 
 getEditable ()
 Get Editable. More...
 
 setTries ($a_tries)
 Set default tries for questions. More...
 
 getTries ()
 Get Tries. More...
 
 setLocalization ($a_val)
 Set localization. More...
 
 getLocalization ()
 Get localization. More...
 
 getDiskUsage ()
 Gets the disk usage of the object in bytes. More...
 
 createDataDirectory ()
 creates data directory for package files ("./data/lm_data/lm_<id>") More...
 
 getDataDirectory ($mode="filesystem")
 get data directory of lm More...
 
 getAPIAdapterName ()
 get api adapter name More...
 
 setAPIAdapterName ($a_api)
 set api adapter name More...
 
 getAPIFunctionsPrefix ()
 get api functions prefix More...
 
 setAPIFunctionsPrefix ($a_prefix)
 set api functions prefix More...
 
 getCreditMode ()
 get credit mode More...
 
 setCreditMode ($a_credit_mode)
 set credit mode More...
 
 setDefaultLessonMode ($a_lesson_mode)
 set default lesson mode More...
 
 getDefaultLessonMode ()
 get default lesson mode More...
 
 getStyleSheetId ()
 get ID of assigned style sheet object More...
 
 setStyleSheetId ($a_style_id)
 set ID of assigned style sheet object More...
 
 setAutoReview ($a_auto_review)
 set auto review as true/false for SCORM 1.2, HACP, SAHS, AICC More...
 
 getAutoReview ()
 get auto review as true/false for SCORM 1.2, HACP, SAHS, AICC More...
 
 setAutoReviewChar ($a_auto_review)
 set auto review as Char for SCORM 2004 More...
 
 getAutoReviewChar ()
 get auto review as Char for SCORM 2004 More...
 
 getMaxAttempt ()
 get max attempt More...
 
 setMaxAttempt ($a_max_attempt)
 set max attempt More...
 
 getModuleVersion ()
 get module version More...
 
 getAssignedGlossary ()
 get assigned glossary More...
 
 setAssignedGlossary ($a_assigned_glossary)
 set assigned glossary More...
 
 setModuleVersion ($a_module_version)
 set max attempt More...
 
 getSession ()
 get session setting More...
 
 setSession ($a_session)
 set session setting More...
 
 getNoMenu ()
 disable menu More...
 
 setNoMenu ($a_no_menu)
 disable menu More...
 
 getHideNavig ()
 hide navigation tree More...
 
 setHideNavig ($a_hide_navig)
 disable menu More...
 
 getCacheDeactivated ()
 BrowserCacheDisabled for SCORM 2004 / ENABLE_JS_DEBUG. More...
 
 getSessionDeactivated ()
 sessionDisabled for SCORM 2004 More...
 
 getDebugActivated ()
 debugActivated More...
 
 getIe_compatibility ()
 set compatibility mode for Internet Exlorer manually More...
 
 setIe_compatibility ($a_ie_compatibility)
 
 getIe_force_render ()
 force Internet Explorer to render again after some Milliseconds - useful for learning Modules with a lot of iframesor frames and IE >=10 More...
 
 setIe_force_render ($a_ie_force_render)
 
 getFourth_Edition ()
 SCORM 2004 4th edition features. More...
 
 setFourth_edition ($a_fourth_edition)
 
 getSequencing ()
 sequencing More...
 
 setSequencing ($a_sequencing)
 
 getInteractions ()
 interactions More...
 
 setInteractions ($a_interactions)
 
 getObjectives ()
 objectives More...
 
 setObjectives ($a_objectives)
 
 getComments ()
 comments More...
 
 setComments ($a_comments)
 
 getTime_from_lms ()
 time_from_lms More...
 
 setTime_from_lms ($a_time_from_lms)
 
 getCheck_values ()
 check_values More...
 
 setCheck_values ($a_check_values)
 
 getOfflineMode ()
 offlineMode More...
 
 setOfflineMode ($a_offline_mode)
 
 getDebug ()
 debug More...
 
 setDebug ($a_debug)
 debug More...
 
 getDebugPw ()
 debug pw More...
 
 setDebugPw ($a_debug_pw)
 debug pw More...
 
 setAutoContinue ($a_auto_continue)
 get auto continue More...
 
 getAutoContinue ()
 set auto continue More...
 
 getAuto_last_visited ()
 auto_last_visited More...
 
 setAuto_last_visited ($a_auto_last_visited)
 
 setSequencingExpertMode ($a_val)
 Set sequencing expert mode. More...
 
 getSequencingExpertMode ()
 Get sequencing expert mode. More...
 
 setAutoSuspend ($a_auto_suspend)
 get auto continue More...
 
 getAutoSuspend ()
 set auto continue More...
 
 getOpenMode ()
 open_mode 0: in Tab/new Window like in previous versions 1: in iFrame with width=100% and heigth=100% 2: in iFrame with specified width and height 3: 4: 5: in new Window without specified width and height 6: in new Window with specified width and height More...
 
 setOpenMode ($a_open_mode)
 
 getWidth ()
 width More...
 
 setWidth ($a_width)
 
 getHeight ()
 height More...
 
 setHeight ($a_height)
 
 getMasteryScore ()
 get mastery_score More...
 
 setMasteryScore ($a_mastery_score)
 set mastery_score More...
 
 checkMasteryScoreValues ()
 check mastery_score / min_normalized_measure of SCOs (SCORM 1.2) / objectives (SCORM 2004) More...
 
 getMasteryScoreValues ()
 get mastery_score_values More...
 
 update ()
 update values for mastery_score / min_normalized_measure in database - not requested More...
 
 setOnline ($a_online)
 get online More...
 
 getOnline ()
 set online More...
 
 setSubType ($a_sub_type)
 get sub type More...
 
 getSubType ()
 set sub type More...
 
 delete ()
 delete SCORM learning module and all related data More...
 
 notify ($a_event, $a_ref_id, $a_parent_non_rbac_id, $a_node_id, $a_params=0)
 notifys an object about an event occured Based on the event happend, each object may decide how it reacts. More...
 
 getPointsInPercent ()
 Returns the points in percent for the learning module This is called by the certificate generator if [SCORM_POINTS] is inserted. More...
 
 getMaxPoints ()
 Returns score.max for the learning module, refered to the last sco where score.max is set. More...
 
 populateByDirectoy ($a_dir, $a_filename="")
 Populate by directory. More...
 
 cloneObject ($a_target_id, $a_copy_id=0)
 Clone scorm object. More...
 
 zipLmForOfflineMode ()
 
- Public Member Functions inherited from ilObject
 ilObject ($a_id=0, $a_reference=true)
 Constructor @access public. More...
 
 withReferences ()
 determines wehter objects are referenced or not (got ref ids or not) More...
 
 read ($a_force_db=false)
 read object data from db into object More...
 
 getId ()
 get object id @access public More...
 
 setId ($a_id)
 set object id @access public More...
 
 setRefId ($a_id)
 set reference id @access public More...
 
 getRefId ()
 get reference id @access public More...
 
 getType ()
 get object type @access public More...
 
 setType ($a_type)
 set object type @access public More...
 
 getPresentationTitle ()
 get presentation title Normally same as title Overwritten for sessions More...
 
 getTitle ()
 get object title @access public More...
 
 getUntranslatedTitle ()
 get untranslated object title @access public More...
 
 setTitle ($a_title)
 set object title More...
 
 getDescription ()
 get object description More...
 
 setDescription ($a_desc)
 set object description More...
 
 getLongDescription ()
 get object long description (stored in object_description) More...
 
 getImportId ()
 get import id More...
 
 setImportId ($a_import_id)
 set import id More...
 
 getOwner ()
 get object owner More...
 
 getOwnerName ()
 
 _lookupOwnerName ($a_owner_id)
 lookup owner name for owner id More...
 
 setOwner ($a_owner)
 set object owner More...
 
 getCreateDate ()
 get create date @access public More...
 
 getLastUpdateDate ()
 get last update date @access public More...
 
 getDiskUsage ()
 
 setObjDataRecord ($a_record)
 set object_data record (note: this method should only be called from the ilObjectFactory class) More...
 
 create ()
 create More...
 
 update ()
 update object in db More...
 
 MDUpdateListener ($a_element)
 Meta data update listener. More...
 
 createMetaData ()
 create meta data entry More...
 
 updateMetaData ()
 update meta data entry More...
 
 deleteMetaData ()
 delete meta data entry More...
 
 updateOwner ()
 update owner of object in db More...
 
 _getIdForImportId ($a_import_id)
 get current object id for import id (static) More...
 
 _lookupOwner ($a_id)
 lookup object owner More...
 
 _lookupLastUpdate ($a_id, $a_as_string=false)
 lookup last update More...
 
 _getLastUpdateOfObjects ($a_objs)
 Get last update for a set of media objects. More...
 
 _setDeletedDate ($a_ref_id)
 only called in ilTree::saveSubTree More...
 
 _resetDeletedDate ($a_ref_id)
 only called in ilObjectGUI::insertSavedNodes More...
 
 _lookupDeletedDate ($a_ref_id)
 only called in ilObjectGUI::insertSavedNodes More...
 
 _writeTitle ($a_obj_id, $a_title)
 write title to db (static) More...
 
 _writeDescription ($a_obj_id, $a_desc)
 write description to db (static) More...
 
 _writeImportId ($a_obj_id, $a_import_id)
 write import id to db (static) More...
 
 _isInTrash ($a_ref_id)
 checks wether object is in trash More...
 
 _hasUntrashedReference ($a_obj_id)
 checks wether an object has at least one reference that is not in trash More...
 
 _getObjectsDataForType ($a_type, $a_omit_trash=false)
 get all objects of a certain type More...
 
 putInTree ($a_parent_ref)
 maybe this method should be in tree object!? More...
 
 setPermissions ($a_parent_ref)
 set permissions of object More...
 
 setParentRolePermissions ($a_parent_ref)
 Initialize the permissions of parent roles (local roles of categories, global roles...) This method is overwritten in e.g courses, groups for building permission intersections with non_member templates. More...
 
 createReference ()
 creates reference for object More...
 
 countReferences ()
 count references of object More...
 
 delete ()
 delete object or referenced object (in the case of a referenced object, object data is only deleted if last reference is deleted) This function removes an object entirely from system!! More...
 
 initDefaultRoles ()
 init default roles settings Purpose of this function is to create a local role folder and local roles, that are needed depending on the object type If you want to setup default local roles you MUST overwrite this method in derived object classes (see ilObjForum for an example) @access public More...
 
 applyDidacticTemplate ($a_tpl_id)
 Apply template. More...
 
 notify ($a_event, $a_ref_id, $a_parent_non_rbac_id, $a_node_id, $a_params=0)
 notifys an object about an event occured Based on the event passed, each object may decide how it reacts. More...
 
 setRegisterMode ($a_bool)
 
 isUserRegistered ($a_user_id=0)
 
 requireRegistration ()
 
 getXMLZip ()
 
 getHTMLDirectory ()
 
 cloneObject ($a_target_id, $a_copy_id=0, $a_omit_tree=false)
 Clone object permissions, put in tree ... More...
 
 appendCopyInfo ($a_target_id, $a_copy_id)
 Prepend Copy info if object with same name exists in that container. More...
 
 cloneDependencies ($a_target_id, $a_copy_id)
 Clone object dependencies. More...
 
 cloneMetaData ($target_obj)
 Copy meta data. More...
 
 _lookupCreationDate ($a_id)
 Lookup creation date. More...
 
 getPossibleSubObjects ($a_filter=true)
 get all possible subobjects of this type the object can decide which types of subobjects are possible jut in time overwrite if the decision distinguish from standard model More...
 

Static Public Member Functions

static _lookupLastAccess ($a_obj_id, $a_usr_id)
 Return the last access timestamp for a given user. More...
 
static _getAllScoIds ($a_id)
 Get an array of id's for all Sco's in the module. More...
 
static _getStatusForUser ($a_id, $a_user, $a_allScoIds, $a_numerical=false)
 Get the status of a SCORM module for a given user. More...
 
static _getCourseCompletionForUser ($a_id, $a_user)
 Get the completion of a SCORM module for a given user. More...
 
static _removeTrackingDataForUser ($user_id)
 
- Static Public Member Functions inherited from ilObjSAHSLearningModule
static _getTries ($a_id)
 
static getScormModulesForGlossary ($a_glo_id)
 Get SCORM modules that assign a certain glossary. More...
 
static lookupAssignedGlossary ($a_slm_id)
 Get SCORM modules that assign a certain glossary. More...
 
- Static Public Member Functions inherited from ilObject
static _lookupObjIdByImportId ($a_import_id)
 
static _lookupImportId ($a_obj_id)
 
static _getAllReferences ($a_id)
 get all reference ids of object More...
 
static _lookupTitle ($a_id)
 lookup object title More...
 
static _getIdsForTitle ($title, $type='', $partialmatch=false)
 
static _lookupDescription ($a_id)
 lookup object description More...
 
static _lookupObjId ($a_id)
 
static setDeletedDates ($a_ref_ids)
 Set deleted date @global type $ilDB. More...
 
static _lookupType ($a_id, $a_reference=false)
 lookup object type More...
 
static _lookupObjectId ($a_ref_id)
 lookup object id More...
 
static _exists ($a_id, $a_reference=false, $a_type=null)
 checks if an object exists in object_data@access public More...
 
static _getObjectsByType ($a_obj_type="", $a_owner="")
 Get objects by type. More...
 
static _prepareCloneSelection ($a_ref_ids, $new_type, $show_path=true)
 Prepare copy wizard object selection. More...
 
static _getIcon ($a_obj_id="", $a_size="big", $a_type="", $a_offline=false)
 Get icon for repository item. More...
 
static collectDeletionDependencies (&$deps, $a_ref_id, $a_obj_id, $a_type, $a_depth=0)
 Collect deletion dependencies. More...
 
static getDeletionDependencies ($a_obj_id)
 Get deletion dependencies. More...
 
static getLongDescriptions (array $a_obj_ids)
 Get long description data. More...
 
static getAllOwnedRepositoryObjects ($a_user_id)
 Get all ids of objects user owns. More...
 
static fixMissingTitles ($a_type, array &$a_obj_title_map)
 Try to fix missing object titles. More...
 
static hasAutoRating ($a_type, $a_ref_id)
 Check if auto rating is active for parent group/course. More...
 

Data Fields

 $validator
 
- Data Fields inherited from ilObjSAHSLearningModule
 $validator
 
- Data Fields inherited from ilObject
const TITLE_LENGTH = 255
 max length of object title More...
 
const DESC_LENGTH = 128
 
 $ilias
 
 $lng
 
 $id
 
 $ref_id
 
 $type
 
 $title
 
 $untranslatedTitle
 
 $desc
 
 $long_desc
 
 $owner
 
 $create_date
 
 $last_update
 
 $import_id
 
 $register = false
 
 $referenced
 
 $objectList
 
 $max_title
 
 $max_desc
 
 $add_dots
 
 $obj_data_record
 object_data record More...
 

Private Member Functions

 parseUserId ($il_id)
 Parse il_usr_123_6 id. More...
 
 importRaw ($a_file)
 Import raw data @global ilDB $ilDB @global ilObjUser $ilUser. More...
 
 lookupSCOId ($a_referrer)
 resolves manifest SCOID to internal ILIAS SCO ID More...
 

Detailed Description

Class ilObjSCORMLearningModule.

Author
Alex Killing alex..nosp@m.kill.nosp@m.ing@g.nosp@m.mx.d.nosp@m.e $Id$

Definition at line 17 of file class.ilObjSCORMLearningModule.php.

Member Function Documentation

◆ _getAllScoIds()

static ilObjSCORMLearningModule::_getAllScoIds (   $a_id)
static

Get an array of id's for all Sco's in the module.

Parameters
int$a_idObject id
Returns
array Sco id's

Definition at line 1098 of file class.ilObjSCORMLearningModule.php.

1099 {
1100 global $ilDB;
1101
1102 $scos = array();
1103
1104 $val_set = $ilDB->queryF('
1105 SELECT scorm_object.obj_id,
1106 scorm_object.title,
1107 scorm_object.c_type,
1108 scorm_object.slm_id,
1109 scorm_object.obj_id scoid
1110 FROM scorm_object,sc_item,sc_resource
1111 WHERE(scorm_object.slm_id = %s
1112 AND scorm_object.obj_id = sc_item.obj_id
1113 AND sc_item.identifierref = sc_resource.import_id
1114 AND sc_resource.scormtype = %s)
1115 GROUP BY scorm_object.obj_id,
1116 scorm_object.title,
1117 scorm_object.c_type,
1118 scorm_object.slm_id,
1119 scorm_object.obj_id ',
1120 array('integer', 'text'),
1121 array($a_id,'sco'));
1122
1123 while ($val_rec = $ilDB->fetchAssoc($val_set))
1124 {
1125 array_push($scos,$val_rec['scoid']);
1126 }
1127 return $scos;
1128 }
$ilDB
global $ilDB
Definition: storeScorm2004.php:19

References $ilDB.

Referenced by _getCourseCompletionForUser().

+ Here is the caller graph for this function:

◆ _getCourseCompletionForUser()

static ilObjSCORMLearningModule::_getCourseCompletionForUser (   $a_id,
  $a_user 
)
static

Get the completion of a SCORM module for a given user.

Parameters
int$a_idObject id
int$a_userUser id
Returns
boolean Completion status

Reimplemented in ilObjSCORM2004LearningModule.

Definition at line 1176 of file class.ilObjSCORMLearningModule.php.

1177 {
1178 return ilObjSCORMLearningModule::_getStatusForUser($a_id, $a_user, ilObjSCORMLearningModule::_getAllScoIds($a_id), true);
1179 }
ilObjSCORMLearningModule\_getStatusForUser
static _getStatusForUser($a_id, $a_user, $a_allScoIds, $a_numerical=false)
Get the status of a SCORM module for a given user.
Definition: class.ilObjSCORMLearningModule.php:1138
ilObjSCORMLearningModule\_getAllScoIds
static _getAllScoIds($a_id)
Get an array of id's for all Sco's in the module.
Definition: class.ilObjSCORMLearningModule.php:1098

References _getAllScoIds(), and _getStatusForUser().

Referenced by ilObjSAHSLearningModuleAccess\_lookupUserCertificate(), and ilSCORMVerificationTableGUI\getItems().

+ Here is the call graph for this function:
+ Here is the caller graph for this function:

◆ _getScoresForUser()

ilObjSCORMLearningModule::_getScoresForUser (   $a_item_id,
  $a_user_id 
)

Definition at line 1262 of file class.ilObjSCORMLearningModule.php.

1263 {
1264 global $ilDB;
1265
1266 $retAr = array("raw" => null, "max" => null, "scaled" => null);
1267 $val_set = $ilDB->queryF("
1268 SELECT lvalue, rvalue FROM scorm_tracking
1269 WHERE sco_id = %s
1270 AND user_id = %s
1271 AND (lvalue = 'cmi.core.score.raw' OR lvalue = 'cmi.core.score.max')",
1272 array('integer', 'integer'),
1273 array($a_item_id, $a_user_id)
1274 );
1275 while ($val_rec = $ilDB->fetchAssoc($val_set))
1276 {
1277 if ($val_rec['lvalue'] == "cmi.core.score.raw") $retAr["raw"] = $val_rec["rvalue"];
1278 if ($val_rec['lvalue'] == "cmi.core.score.max") $retAr["max"] = $val_rec["rvalue"];
1279 }
1280 if ($retAr["raw"] != null && $retAr["max"] != null) $retAr["scaled"] = ($retAr["raw"] / $retAr["max"]);
1281
1282 return $retAr;
1283 }

References $ilDB.

Referenced by ilLPCollectionOfSCOs\getScoresForUserAndCP_Node_Id().

+ Here is the caller graph for this function:

◆ _getStatusForUser()

static ilObjSCORMLearningModule::_getStatusForUser (   $a_id,
  $a_user,
  $a_allScoIds,
  $a_numerical = false 
)
static

Get the status of a SCORM module for a given user.

Parameters
int$a_idObject id
int$a_userUser id
array$a_allScoIdsArray of Sco id's in this module
boolean$a_numericalText (false) or boolean result (true)
Returns
mixed Status result

Definition at line 1138 of file class.ilObjSCORMLearningModule.php.

1139 {
1140 global $ilDB, $lng;
1141
1142 $scos = $a_allScoIds;
1143 //check if all SCO's are completed
1144 $scos_c = implode(',',$scos);
1145
1146 $val_set = $ilDB->queryF('
1147 SELECT * FROM scorm_tracking
1148 WHERE (user_id = %s
1149 AND obj_id = %s
1150 AND '.$ilDB->in('sco_id', $scos, false, 'integer').'
1151 AND ((lvalue = %s AND '.$ilDB->like('rvalue', 'clob', 'completed').')
1152 OR (lvalue = %s AND '.$ilDB->like('rvalue', 'clob', 'passed').')))',
1153 array('integer','integer','text','text'),
1154 array($a_user,$a_id,'cmi.core.lesson_status', 'cmi.core.lesson_status'));
1155 while ($val_rec = $ilDB->fetchAssoc($val_set))
1156 {
1157 $key = array_search($val_rec['sco_id'], $scos);
1158 unset ($scos[$key]);
1159 }
1160 //check for completion
1161 if (count($scos) == 0) {
1162 $completion = ($a_numerical===true) ? true: $lng->txt("cont_complete");
1163 }
1164 if (count($scos) > 0) {
1165 $completion = ($a_numerical===true) ? false: $lng->txt("cont_incomplete");
1166 }
1167 return $completion;
1168 }

References $ilDB, and ilObject\$lng.

Referenced by _getCourseCompletionForUser().

+ Here is the caller graph for this function:

◆ _getTrackingItems()

ilObjSCORMLearningModule::_getTrackingItems (   $a_obj_id)

get all tracking items of scorm object @access static

Reimplemented in ilObjSCORM2004LearningModule, and ilObjAICCLearningModule.

Definition at line 66 of file class.ilObjSCORMLearningModule.php.

67 {
68 include_once("./Modules/ScormAicc/classes/SCORM/class.ilSCORMTree.php");
69 $tree = new ilSCORMTree($a_obj_id);
70 $root_id = $tree->readRootId();
71
72 $items = array();
73 $childs = $tree->getSubTree($tree->getNodeData($root_id));
74
75 foreach($childs as $child)
76 {
77 if($child["c_type"] == "sit")
78 {
79 include_once("./Modules/ScormAicc/classes/SCORM/class.ilSCORMItem.php");
80 $sc_item =& new ilSCORMItem($child["obj_id"]);
81 if ($sc_item->getIdentifierRef() != "")
82 {
83 $items[count($items)] =& $sc_item;
84 }
85 }
86 }
87
88 return $items;
89 }
ilSCORMTree
SCORM Object Tree.
Definition: class.ilSCORMTree.php:35

Referenced by ilLPCollectionOfSCOs\getPossibleItems(), and getTrackingItems().

+ Here is the caller graph for this function:

◆ _lookupLastAccess()

static ilObjSCORMLearningModule::_lookupLastAccess (   $a_obj_id,
  $a_usr_id 
)
static

Return the last access timestamp for a given user.

Parameters
int$a_obj_idobject id
int$user_iduser id
Returns
timestamp

Reimplemented in ilObjSCORM2004LearningModule.

Definition at line 290 of file class.ilObjSCORMLearningModule.php.

291 {
292 global $ilDB;
293
294 $result = $ilDB->queryF('
295 SELECT last_access FROM sahs_user
296 WHERE obj_id = %s
297 AND user_id = %s',
298 array('integer','integer'), array($a_obj_id,$a_usr_id));
299
300 if ($ilDB->numRows($result))
301 {
302 $row = $ilDB->fetchAssoc($result);
303 return $row["last_access"];
304 }
305 return "";
306 }
$result
$result
Definition: CleanUpTest.php:407

References $ilDB, $result, and $row.

Referenced by ilObjSCORMVerification\createFromSCORMLM(), and ilSCORMPresentationGUI\downloadCertificate().

+ Here is the caller graph for this function:

◆ _removeTrackingDataForUser()

static ilObjSCORMLearningModule::_removeTrackingDataForUser (   $user_id)
static

Definition at line 1247 of file class.ilObjSCORMLearningModule.php.

1247 {
1248 global $ilDB;
1249 //gobjective
1250 $ilDB->manipulateF(
1251 'DELETE FROM scorm_tracking WHERE user_id = %s',
1252 array('integer'),
1253 array($user_id)
1254 );
1255 $ilDB->manipulateF(
1256 'DELETE FROM sahs_user WHERE user_id = %s',
1257 array('integer'),
1258 array($user_id)
1259 );
1260 }

References $ilDB.

Referenced by ilObjUser\delete().

+ Here is the caller graph for this function:

◆ decreaseAttemptsForUser()

ilObjSCORMLearningModule::decreaseAttemptsForUser (   $a_user_id)

Decrease attempts for user @global ilDB $ilDB.

Parameters
array$a_user_id

Definition at line 991 of file class.ilObjSCORMLearningModule.php.

991 {
992 global $ilDB;
993
994 foreach ($a_user_id as $user)
995 {
996 //first check if there is a package_attempts entry
997 $val_set = $ilDB->queryF('SELECT package_attempts FROM sahs_user WHERE user_id = %s AND obj_id = %s',
998 array('integer','integer'),
999 array($user,$this->getID()));
1000
1001 $val_rec = $ilDB->fetchAssoc($val_set);
1002
1003 if ($val_rec["package_attempts"] != null && $val_rec["package_attempts"] != 0)
1004 {
1005 $new_rec = 0;
1006 //decrease attempt by 1
1007 if ((int)$val_rec["package_attempts"] > 0) $new_rec = (int)$val_rec["package_attempts"]-1;
1008 $ilDB->manipulateF('UPDATE sahs_user SET package_attempts = %s WHERE user_id = %s AND obj_id = %s',
1009 array('integer','integer','integer'),
1010 array($new_rec,$user,$this->getID()));
1011
1012 //following 2 lines were before 4.4 only for SCORM 1.2
1013 include_once("./Services/Tracking/classes/class.ilLPStatusWrapper.php");
1014 ilLPStatusWrapper::_updateStatus($this->getId(), $user);
1015 }
1016 }
1017 }
ilLPStatusWrapper\_updateStatus
static _updateStatus($a_obj_id, $a_usr_id, $a_obj=null, $a_percentage=false, $a_force_raise=false)
Update status.
Definition: class.ilLPStatusWrapper.php:276
ilObject\getId
getId()
get object id @access public
Definition: class.ilObject.php:297

References $ilDB, ilLPStatusWrapper\_updateStatus(), and ilObject\getId().

+ Here is the call graph for this function:

◆ deleteTrackingDataOfUsers()

ilObjSCORMLearningModule::deleteTrackingDataOfUsers (   $a_users)

Reimplemented in ilObjSCORM2004LearningModule.

Definition at line 1300 of file class.ilObjSCORMLearningModule.php.

1301 {
1302 global $ilDB;
1303 include_once("./Services/Tracking/classes/class.ilChangeEvent.php");
1304 include_once("./Services/Tracking/classes/class.ilLPStatusWrapper.php");
1305
1306 ilChangeEvent::_deleteReadEventsForUsers($this->getId(), $a_users);
1307
1308 foreach($a_users as $user)
1309 {
1310 $ilDB->manipulateF('
1311 DELETE FROM scorm_tracking
1312 WHERE user_id = %s
1313 AND obj_id = %s',
1314 array('integer', 'integer'),
1315 array($user, $this->getID()));
1316
1317 $ilDB->manipulateF('
1318 DELETE FROM sahs_user
1319 WHERE user_id = %s
1320 AND obj_id = %s',
1321 array('integer', 'integer'),
1322 array($user, $this->getID()));
1323
1324 ilLPStatusWrapper::_updateStatus($this->getId(), $user);
1325 }
1326 }
ilChangeEvent\_deleteReadEventsForUsers
static _deleteReadEventsForUsers($a_obj_id, array $a_user_ids)
Definition: class.ilChangeEvent.php:979

References $ilDB, ilChangeEvent\_deleteReadEventsForUsers(), ilLPStatusWrapper\_updateStatus(), and ilObject\getId().

Referenced by importSuccess().

+ Here is the call graph for this function:
+ Here is the caller graph for this function:

◆ exportSelected()

ilObjSCORMLearningModule::exportSelected (   $a_all,
  $a_users = array() 
)

Export selected user tracking data @global ilDB $ilDB @global ilObjUser $ilUser.

Parameters
bool$a_all
array$a_users

Definition at line 567 of file class.ilObjSCORMLearningModule.php.

568 {
569 global $ilDB, $ilUser;
570 include_once('./Modules/ScormAicc/classes/class.ilSCORMTrackingItems.php');
571 include_once("./Services/Tracking/classes/class.ilLearningProgressBaseGUI.php");
572 include_once('./Services/PrivacySecurity/classes/class.ilPrivacySettings.php');
573 $privacy = ilPrivacySettings::_getInstance();
574 $allowExportPrivacy = $privacy->enabledExportSCORM();
575
576 $csv = "";
577 $query = 'SELECT * FROM sahs_user WHERE obj_id = %s';
578 if (count($a_users) >0) $query .= ' AND '.$ilDB->in('user_id', $a_users, false, 'integer');
579 $res = $ilDB->queryF(
580 $query,
581 array('integer'),
582 array($this->getId())
583 );
584 while ($data = $ilDB->fetchAssoc($res)) {
585 $csv = $csv. $data["obj_id"]
586 . ";\"" . $this->getTitle() ."\""
587 . ";" . $data["module_version"]
588 . ";\"" . implode("\";\"",ilSCORMTrackingItems::userDataArrayForExport($data["user_id"], $allowExportPrivacy)) ."\""
589 . ";\"" . $data["last_access"] ."\""
590 . ";\"" . ilLearningProgressBaseGUI::__readStatus($data["obj_id"],$data["user_id"]) ."\"" //not $data["status"] because modifications to learning progress could have made before export
591 . ";" . $data["package_attempts"]
592 . ";" . $data["percentage_completed"]
593 . ";" . $data["sco_total_time_sec"]
594// . ";\"" . $certificateDate ."\""
595 . "\n";
596 }
597 $udh=ilSCORMTrackingItems::userDataHeaderForExport();
598 $header = "LearningModuleId;LearningModuleTitle;LearningModuleVersion;".str_replace(',',';',$udh["cols"]).";"
599 . "LastAccess;Status;Attempts;percentageCompletedSCOs;SumTotal_timeSeconds\n";
600
601 $this->sendExportFile($header, $csv);
602 }
ilObjSCORMLearningModule\sendExportFile
sendExportFile($a_header, $a_content)
send export file to browser
Definition: class.ilObjSCORMLearningModule.php:1077
ilObject\getTitle
getTitle()
get object title @access public
Definition: class.ilObject.php:373
ilPrivacySettings\_getInstance
static _getInstance()
Get instance of ilPrivacySettings.
Definition: class.ilPrivacySettings.php:77
ilSCORMTrackingItems\userDataArrayForExport
userDataArrayForExport($user, $b_allowExportPrivacy=false)
Definition: class.ilSCORMTrackingItems.php:49
$header
$header
Definition: example_011.php:123
$data
$data
Definition: example_011.php:126
$ilUser
global $ilUser
Definition: imgupload.php:15

References $data, $header, $ilDB, $ilUser, $query, $res, ilLearningProgressBaseGUI\__readStatus(), ilPrivacySettings\_getInstance(), ilObject\getId(), ilObject\getTitle(), sendExportFile(), ilSCORMTrackingItems\userDataArrayForExport(), and ilSCORMTrackingItems\userDataHeaderForExport().

+ Here is the call graph for this function:

◆ get_user_id()

ilObjSCORMLearningModule::get_user_id (   $a_login)

Definition at line 1021 of file class.ilObjSCORMLearningModule.php.

1021 {
1022 global $ilDB, $ilUser;
1023
1024 $val_set = $ilDB->queryF('SELECT * FROM usr_data WHERE(login=%s)',
1025 array('text'),array($a_login));
1026 $val_rec = $ilDB->fetchAssoc($val_set);
1027
1028 if (count($val_rec)>0) {
1029 return $val_rec['usr_id'];
1030 } else {
1031 return null;
1032 }
1033 }

References $ilDB, and $ilUser.

Referenced by importRaw(), ilObjSCORM2004LearningModule\importSuccess(), and importSuccess().

+ Here is the caller graph for this function:

◆ getAllScoIds()

ilObjSCORMLearningModule::getAllScoIds ( )

Definition at line 1181 of file class.ilObjSCORMLearningModule.php.

1181 {
1182 global $ilDB;
1183
1184 $scos = array();
1185 //get all SCO's of this object
1186 $val_set = $ilDB->queryF('
1187 SELECT scorm_object.obj_id,
1188 scorm_object.title,
1189 scorm_object.c_type,
1190 scorm_object.slm_id,
1191 scorm_object.obj_id scoid
1192 FROM scorm_object, sc_item,sc_resource
1193 WHERE(scorm_object.slm_id = %s
1194 AND scorm_object.obj_id = sc_item.obj_id
1195 AND sc_item.identifierref = sc_resource.import_id
1196 AND sc_resource.scormtype = %s )
1197 GROUP BY scorm_object.obj_id,
1198 scorm_object.title,
1199 scorm_object.c_type,
1200 scorm_object.slm_id,
1201 scorm_object.obj_id',
1202 array('integer','text'),
1203 array($this->getId(),'sco'));
1204
1205 while ($val_rec = $ilDB->fetchAssoc($val_set))
1206 {
1207 array_push($scos,$val_rec['scoid']);
1208 }
1209 return $scos;
1210 }

References $ilDB, and ilObject\getId().

Referenced by getCourseCompletionForUser().

+ Here is the call graph for this function:
+ Here is the caller graph for this function:

◆ getAttemptsForUser()

ilObjSCORMLearningModule::getAttemptsForUser (   $a_user_id)

get number of atttempts for a certain user and package

Reimplemented in ilObjSCORM2004LearningModule.

Definition at line 355 of file class.ilObjSCORMLearningModule.php.

355 {
356 global $ilDB;
357 $val_set = $ilDB->queryF('SELECT package_attempts FROM sahs_user WHERE obj_id = %s AND user_id = %s',
358 array('integer','integer'),
359 array($this->getId(),$a_user_id,0));
360
361 $val_rec = $ilDB->fetchAssoc($val_set);
362
363 if ($val_rec["package_attempts"] == null) {
364 $val_rec["package_attempts"]="";
365 }
366 return $val_rec["package_attempts"];
367 }

References $ilDB, and ilObject\getId().

+ Here is the call graph for this function:

◆ getAttemptsForUsers()

ilObjSCORMLearningModule::getAttemptsForUsers ( )

Get attempts for all users @global ilDB $ilDB.

Returns
array

Definition at line 337 of file class.ilObjSCORMLearningModule.php.

338 {
339 global $ilDB;
340 $query = 'SELECT user_id, package_attempts FROM sahs_user WHERE obj_id = ' . $ilDB->quote($this->getId(), 'integer') . ' ';
341 $res = $ilDB->query($query);
342
343 $attempts = array();
344 while($row = $res->fetchRow(DB_FETCHMODE_ASSOC))
345 {
346 $attempts[$row['user_id']] = (int) $row['package_attempts'];
347 }
348 return $attempts;
349 }
DB_FETCHMODE_ASSOC
const DB_FETCHMODE_ASSOC
Definition: class.ilDB.php:10

References $ilDB, $query, $res, $row, DB_FETCHMODE_ASSOC, and ilObject\getId().

+ Here is the call graph for this function:

◆ getCourseCompletionForUser()

ilObjSCORMLearningModule::getCourseCompletionForUser (   $a_user)

Reimplemented in ilObjSCORM2004LearningModule.

Definition at line 1242 of file class.ilObjSCORMLearningModule.php.

1242 {
1243 return $this->getStatusForUser($a_user,$this->getAllScoIds,true);
1244 }
ilObjSCORMLearningModule\getStatusForUser
getStatusForUser($a_user, $a_allScoIds, $a_numerical=false)
Definition: class.ilObjSCORMLearningModule.php:1212

References getAllScoIds(), and getStatusForUser().

+ Here is the call graph for this function:

◆ getLastVisited()

ilObjSCORMLearningModule::getLastVisited (   $user_id)

Definition at line 1286 of file class.ilObjSCORMLearningModule.php.

1287 {
1288 global $ilDB;
1289 $val_set = $ilDB->queryF('SELECT last_visited FROM sahs_user WHERE obj_id = %s AND user_id = %s',
1290 array('integer','integer'),
1291 array($this->getID(),$user_id)
1292 );
1293 while ($val_rec = $ilDB->fetchAssoc($val_set))
1294 {
1295 if ($val_rec["last_visited"] != null) return "".$val_rec["last_visited"];
1296 }
1297 return '0';
1298 }

References $ilDB.

◆ getModuleVersionForUser()

ilObjSCORMLearningModule::getModuleVersionForUser (   $a_user_id)

get module version that tracking data for a user was recorded on

Reimplemented in ilObjSCORM2004LearningModule.

Definition at line 392 of file class.ilObjSCORMLearningModule.php.

392 {
393 global $ilDB;
394 $val_set = $ilDB->queryF('SELECT module_version FROM sahs_user WHERE obj_id = %s AND user_id = %s',
395 array('integer','integer'),
396 array($this->getId(),$a_user_id,0));
397
398 $val_rec = $ilDB->fetchAssoc($val_set);
399
400 if ($val_rec["module_version"] == null) {
401 $val_rec["module_version"]="";
402 }
403 return $val_rec["module_version"];
404 }

References $ilDB, and ilObject\getId().

+ Here is the call graph for this function:

◆ getModuleVersionForUsers()

ilObjSCORMLearningModule::getModuleVersionForUsers ( )

Get module version for users.

@global ilDB $ilDB

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

375 {
376 global $ilDB;
377 $query = 'SELECT user_id, module_version FROM sahs_user WHERE obj_id = ' . $ilDB->quote($this->getId(), 'integer') . ' ';
378 $res = $ilDB->query($query);
379
380 $versions = array();
381 while($row = $res->fetchRow(DB_FETCHMODE_ASSOC))
382 {
383 $versions[$row['user_id']] = (int) $row['module_version'];
384 }
385 return $versions;
386 }

References $ilDB, $query, $res, $row, DB_FETCHMODE_ASSOC, and ilObject\getId().

+ Here is the call graph for this function:

◆ getStatusForUser()

ilObjSCORMLearningModule::getStatusForUser (   $a_user,
  $a_allScoIds,
  $a_numerical = false 
)

Definition at line 1212 of file class.ilObjSCORMLearningModule.php.

1212 {
1213 global $ilDB;
1214 $scos = $a_allScoIds;
1215 //loook up status
1216 //check if all SCO's are completed
1217 $scos_c = implode(',',$scos);
1218
1219 $val_set = $ilDB->queryF('
1220 SELECT sco_id FROM scorm_tracking
1221 WHERE (user_id = %s
1222 AND obj_id = %s
1223 AND '.$ilDB->in('sco_id', $scos, false, 'integer').'
1224 AND ((lvalue = %s AND '.$ilDB->like('rvalue', 'clob', 'completed').') OR (lvalue = %s AND '.$ilDB->like('rvalue', 'clob', 'passed').') ) )',
1225 array('integer','integer','text','text',),
1226 array($a_user,$this->getID(),'cmi.core.lesson_status','cmi.core.lesson_status'));
1227 while ($val_rec = $ilDB->fetchAssoc($val_set))
1228 {
1229 $key = array_search($val_rec['sco_id'], $scos);
1230 unset ($scos[$key]);
1231 }
1232 //check for completion
1233 if (count($scos) == 0) {
1234 $completion = ($a_numerical===true) ? true: $this->lng->txt("cont_complete");
1235 }
1236 if (count($scos) > 0) {
1237 $completion = ($a_numerical===true) ? false: $this->lng->txt("cont_incomplete");
1238 }
1239 return $completion;
1240 }

References $ilDB.

Referenced by getCourseCompletionForUser().

+ Here is the caller graph for this function:

◆ getTrackedItems()

ilObjSCORMLearningModule::getTrackedItems ( )

get all tracked items of current user

Reimplemented in ilObjSCORM2004LearningModule, and ilObjAICCLearningModule.

Definition at line 261 of file class.ilObjSCORMLearningModule.php.

262 {
263 global $ilDB, $ilUser;
264
265 $sco_set = $ilDB->queryF('
266 SELECT DISTINCT sco_id FROM scorm_tracking WHERE obj_id = %s',
267 array('integer'),array($this->getId()));
268
269 $items = array();
270 while($sco_rec = $ilDB->fetchAssoc($sco_set))
271 {
272 include_once("./Modules/ScormAicc/classes/SCORM/class.ilSCORMItem.php");
273 $sc_item =& new ilSCORMItem($sco_rec["sco_id"]);
274 if ($sc_item->getIdentifierRef() != "")
275 {
276 $items[count($items)] =& $sc_item;
277 }
278 }
279
280 return $items;
281 }

References $ilDB, $ilUser, and ilObject\getId().

+ Here is the call graph for this function:

◆ getTrackedUsers()

ilObjSCORMLearningModule::getTrackedUsers (   $a_search)

Definition at line 308 of file class.ilObjSCORMLearningModule.php.

309 {
310 global $ilDB, $ilUser;
311//TODO: UK last_access is not correct if no Commit or last_visited_sco
312// $query = 'SELECT user_id,MAX(c_timestamp) last_access, lastname, firstname FROM scorm_tracking st ' .
313 $query = 'SELECT user_id, last_access, lastname, firstname FROM sahs_user st ' .
314 'JOIN usr_data ud ON st.user_id = ud.usr_id ' .
315 'WHERE obj_id = ' . $ilDB->quote($this->getId(), 'integer');
316 if($a_search) {
317// $query .= ' AND (' . $ilDB->like('lastname', 'text', '%' . $a_search . '%') . ' OR ' . $ilDB->like('firstname', 'text', '%' . $a_search . '%') .')';
318 $query .= ' AND ' . $ilDB->like('lastname', 'text', '%' . $a_search . '%');
319 }
320 $query .= ' GROUP BY user_id, lastname, firstname, last_access';
321 $sco_set = $ilDB->query($query);
322
323 $items = array();
324 while($sco_rec = $ilDB->fetchAssoc($sco_set))
325 {
326 $items[] = $sco_rec;
327 }
328 return $items;
329 }

References $ilDB, $ilUser, $query, and ilObject\getId().

+ Here is the call graph for this function:

◆ getTrackingDataAgg()

ilObjSCORMLearningModule::getTrackingDataAgg (   $a_user_id)

Definition at line 434 of file class.ilObjSCORMLearningModule.php.

435 {
436 global $ilDB;
437
438 // get all users with any tracking data
439 $sco_set = $ilDB->queryF('
440 SELECT DISTINCT sco_id FROM scorm_tracking
441 WHERE obj_id = %s
442 AND user_id = %s
443 AND sco_id <> %s',
444 array('integer','integer','integer'),
445 array($this->getId(),$a_user_id,0));
446
447 $data = array();
448 while($sco_rec = $ilDB->fetchAssoc($sco_set))
449 {
450 $data_set = $ilDB->queryF('
451 SELECT * FROM scorm_tracking
452 WHERE obj_id = %s
453 AND sco_id = %s
454 AND user_id = %s
455 AND lvalue <> %s
456 AND (lvalue = %s
457 OR lvalue = %s
458 OR lvalue = %s)',
459 array('integer','integer','integer','text','text','text','text'),
460 array($this->getId(),
461 $sco_rec["sco_id"],
462 $a_user_id,
463 "package_attempts",
464 "cmi.core.lesson_status",
465 "cmi.core.total_time",
466 "cmi.core.score.raw")
467 );
468
469 $score = $time = $status = "";
470
471 while($data_rec = $ilDB->fetchAssoc($data_set))
472 {
473 switch($data_rec["lvalue"])
474 {
475 case "cmi.core.lesson_status":
476 $status = $data_rec["rvalue"];
477 break;
478
479 case "cmi.core.total_time":
480 $time = $data_rec["rvalue"];
481 break;
482
483 case "cmi.core.score.raw":
484 $score = $data_rec["rvalue"];
485 break;
486 }
487 }
488 //create sco_object
489 include_once './Modules/ScormAicc/classes/SCORM/class.ilSCORMItem.php';
490 $sc_item =& new ilSCORMItem($sco_rec["sco_id"]);
491 $data[] = array("sco_id"=>$sco_rec["sco_id"], "title" => $sc_item->getTitle(),
492 "score" => $score, "time" => $time, "status" => $status);
493
494 }
495 return (array) $data;
496 }

References $data, $ilDB, and ilObject\getId().

+ Here is the call graph for this function:

◆ getTrackingDataAggSco()

ilObjSCORMLearningModule::getTrackingDataAggSco (   $a_sco_id)

Definition at line 498 of file class.ilObjSCORMLearningModule.php.

499 {
500 global $ilDB;
501
502 // get all users with any tracking data
503 $user_set = $ilDB->queryF('
504 SELECT DISTINCT user_id FROM scorm_tracking
505 WHERE obj_id = %s
506 AND sco_id = %s',
507 array('integer','integer'),
508 array($this->getId(),$a_sco_id));
509
510 $data = array();
511 while($user_rec = $ilDB->fetchAssoc($user_set))
512 {
513
514 $data_set = $ilDB->queryF('
515 SELECT * FROM scorm_tracking
516 WHERE obj_id = %s
517 AND sco_id = %s
518 AND user_id = %s
519 AND (lvalue = %s
520 OR lvalue = %s
521 OR lvalue = %s)',
522 array('integer','integer','integer','text','text','text'),
523 array($this->getId(),
524 $a_sco_id,
525 $user_rec["user_id"],
526 "cmi.core.lesson_status",
527 "cmi.core.total_time",
528 "cmi.core.score.raw")
529 );
530
531 $score = $time = $status = "";
532
533 while($data_rec = $ilDB->fetchAssoc($data_set))
534 {
535 switch($data_rec["lvalue"])
536 {
537 case "cmi.core.lesson_status":
538 $status = $data_rec["rvalue"];
539 break;
540
541 case "cmi.core.total_time":
542 $time = $data_rec["rvalue"];
543 break;
544
545 case "cmi.core.score.raw":
546 $score = $data_rec["rvalue"];
547 break;
548 }
549 }
550
551 $data[] = array("user_id" => $user_rec["user_id"],
552 "score" => $score, "time" => $time, "status" => $status);
553 }
554
555 return $data;
556 }

References $data, $ilDB, and ilObject\getId().

+ Here is the call graph for this function:

◆ getTrackingDataPerUser()

ilObjSCORMLearningModule::getTrackingDataPerUser (   $a_sco_id,
  $a_user_id 
)

Get tracking data per user @global ilDB $ilDB.

Parameters
int$a_sco_id
int$a_user_id
Returns
array

Definition at line 413 of file class.ilObjSCORMLearningModule.php.

414 {
415 global $ilDB;
416
417 $data_set = $ilDB->queryF('
418 SELECT * FROM scorm_tracking
419 WHERE user_id = %s
420 AND sco_id = %s
421 AND obj_id = %s
422 ORDER BY lvalue',
423 array('integer','integer','integer'),
424 array($a_user_id,$a_sco_id,$this->getId()));
425
426 $data = array();
427 while($data_rec = $ilDB->fetchAssoc($data_set)) {
428 $data[] = $data_rec;
429 }
430
431 return $data;
432 }

References $data, $ilDB, and ilObject\getId().

+ Here is the call graph for this function:

◆ getTrackingItems()

ilObjSCORMLearningModule::getTrackingItems ( )

Reimplemented in ilObjAICCLearningModule.

Definition at line 56 of file class.ilObjSCORMLearningModule.php.

57 {
58 return ilObjSCORMLearningModule::_getTrackingItems($this->getId());
59 }
ilObjSCORMLearningModule\_getTrackingItems
_getTrackingItems($a_obj_id)
get all tracking items of scorm object @access static
Definition: class.ilObjSCORMLearningModule.php:66

References _getTrackingItems(), and ilObject\getId().

+ Here is the call graph for this function:

◆ getUserIdEmail()

ilObjSCORMLearningModule::getUserIdEmail (   $a_mail)

assumes that only one account exists for a mailadress

Definition at line 1061 of file class.ilObjSCORMLearningModule.php.

1062 {
1063 global $ilDB, $ilUser;
1064
1065 $val_set = $ilDB->queryF('SELECT usr_id FROM usr_data WHERE(email=%s)',
1066 array('text'),array($a_mail));
1067 $val_rec = $ilDB->fetchAssoc($val_set);
1068
1069
1070 return $val_rec["usr_id"];
1071 }

References $ilDB, and $ilUser.

◆ getValidationSummary()

ilObjSCORMLearningModule::getValidationSummary ( )

Definition at line 47 of file class.ilObjSCORMLearningModule.php.

48 {
49 if(is_object($this->validator))
50 {
51 return $this->validator->getSummary();
52 }
53 return "";
54 }

Referenced by ilObjSCORM2004LearningModule\readObject(), and readObject().

+ Here is the caller graph for this function:

◆ ilObjSCORMLearningModule()

ilObjSCORMLearningModule::ilObjSCORMLearningModule (   $a_id = 0,
  $a_call_by_reference = true 
)

Constructor @access public.

Parameters
integerreference_id or object_id
booleantreat the id as reference_id (true) or object_id (false)

Definition at line 27 of file class.ilObjSCORMLearningModule.php.

28 {
29 $this->type = "sahs";
30 parent::ilObject($a_id,$a_call_by_reference);
31 }

◆ importRaw()

ilObjSCORMLearningModule::importRaw (   $a_file)
private

Import raw data @global ilDB $ilDB @global ilObjUser $ilUser.

Parameters
string$a_file
Returns
void

Definition at line 827 of file class.ilObjSCORMLearningModule.php.

828 {
829 global $ilDB, $ilUser,$lng;
830 $lng->loadLanguageModule("scormtrac");
831
832 $fhandle = fopen($a_file, "r");
833
834 $fields = fgetcsv($fhandle, pow(2, 16), ';');
835 $users = array();
836 $a_last_access = array();
837 $a_time = array();
838 $a_package_attempts = array();
839 $a_module_version = array();
840 while(($csv_rows = fgetcsv($fhandle, pow(2, 16), ";")) !== FALSE)
841 {
842 $data = array_combine($fields, $csv_rows);
843 if ($data['Userid']) {
844 $user_id = $this->parseUserId($data['Userid']);
845 }
846 else if ($data[$lng->txt("user")])
847 {
848 if (is_int($data[$lng->txt("user")])) $user_id = $data[$lng->txt("user")];
849 }
850 if ($data[$lng->txt("login")])
851 {
852 $user_id = $this->get_user_id($data[$lng->txt("login")]);
853 }
854 if(!$user_id)
855 {
856 continue;
857 }
858
859 if ($data['Scoid'])
860 {
861 $il_sco_id = $this->lookupSCOId($data['Scoid']);
862 }
863 if ($data[$lng->txt("identifierref")])
864 {
865 $il_sco_id = $this->lookupSCOId($data[$lng->txt("identifierref")]);
866 }
867 if(!$il_sco_id)
868 {
869 continue;
870 }
871
872 $c_timestamp="";
873 if ($data['Timestamp'])
874 {
875 $c_timestamp = $data['Timestamp'];
876 }
877 if ($data[$lng->txt("c_timestamp")])
878 {
879 $c_timestamp = $data[$lng->txt("c_timestamp")];
880 }
881 if ($c_timestamp == "")
882 {
883 $date = new DateTime();
884 $c_timestamp = $date->getTimestamp();
885 } else {
886 if($a_last_access[$user_id]) {
887 if ($a_last_access[$user_id] < $c_timestamp) $a_last_access[$user_id] = $c_timestamp;
888 } else {
889 $a_last_access[$user_id] = $c_timestamp;
890 }
891 }
892
893 if(!$data['Key'])
894 {
895 continue;
896 }
897 if(!$data['Value'])
898 {
899 $data['Value'] = "";
900 }
901
902 if($data['Key'] == "cmi.core.total_time" && $data['Value'] != "") {
903 $tarr = explode(":", $data['Value']);
904 $sec = (int) $tarr[2] + (int) $tarr[1] * 60 +
905 (int) substr($tarr[0], strlen($tarr[0]) - 3) * 60 * 60;
906 if ($a_time[$user_id]) $a_time[$user_id] += $sec;
907 else $a_time[$user_id] = $sec;
908 }
909 //do the actual import
910 if($il_sco_id > 0)
911 {
912 $statement = $ilDB->queryF('
913 SELECT * FROM scorm_tracking
914 WHERE user_id = %s
915 AND sco_id = %s
916 AND lvalue = %s
917 AND obj_id = %s',
918 array('integer', 'integer', 'text', 'integer'),
919 array($user_id, $il_sco_id, $data['Key'], $this->getID())
920 );
921 if($ilDB->numRows($statement) > 0)
922 {
923 $ilDB->update('scorm_tracking',
924 array(
925 'rvalue' => array('clob', $data['Value']),
926 'c_timestamp' => array('timestamp', $c_timestamp)
927 ),
928 array(
929 'user_id' => array('integer', $user_id),
930 'sco_id' => array('integer', $il_sco_id),
931 'lvalue' => array('text', $data['Key']),
932 'obj_id' => array('integer', $this->getId())
933 )
934 );
935 }
936 else
937 {
938 $ilDB->insert('scorm_tracking', array(
939 'obj_id' => array('integer', $this->getId()),
940 'user_id' => array('integer', $user_id),
941 'sco_id' => array('integer', $il_sco_id),
942 'lvalue' => array('text', $data['Key']),
943 'rvalue' => array('clob', $data['Value']),
944 'c_timestamp' => array('timestamp', $data['Timestamp'])
945 ));
946 }
947 }
948 // $package_attempts = 1;
949 if($il_sco_id == 0)
950 {
951 if ($data['Key'] == "package_attempts") $a_package_attempts[$user_id] = $data['Value'];
952 // if ($data['Key'] == "module_version") $a_module_version[$user_id] = $data['Value'];
953 }
954 if (!in_array($user_id,$users)) $users[] = $user_id;
955 }
956 fclose($fhandle);
957
958 //UK determineStatus, percentage_completed and syncGlobalStatus
959 include_once './Services/Tracking/classes/class.ilLPStatusWrapper.php';
960 ilLPStatusWrapper::_refreshStatus($this->getId(),$users);
961
962 // include_once './Services/Tracking/classes/status/class.ilLPStatusSCORM.php';
963 include_once './Services/Tracking/classes/class.ilLPStatus.php';
964 foreach ($users as $user_id){
965 $attempts = 1;
966 if ($a_package_attempts[$user_id]) $attempts = $a_package_attempts[$user_id];
967 // $module_version = 1;
968 // if ($a_module_version[$user_id]) $module_version = $a_module_version[$user_id];
969 $sco_total_time_sec = null;
970 if ($a_time[$user_id]) $sco_total_time_sec = $a_time[$user_id];
971 $last_access = null;
972 if ($a_last_access[$user_id]) $last_access = $a_last_access[$user_id];
973 // $status = ilLPStatusWrapper::_determineStatus($this->getId(),$user_id);
974 $status = ilLPStatus::_lookupStatus($this->getId(),$user_id);
975 // $percentage_completed = ilLPStatusSCORM::determinePercentage($this->getId(),$user_id);
976 $percentage_completed = ilLPStatus::_lookupPercentage($this->getId(),$user_id);
977
978 $this->importSuccessForSahsUser($user_id, $last_access, $status, $attempts, $percentage_completed, $sco_total_time_sec);
979
980 }
981
982 return 0;
983 }
ilLPStatusWrapper\_refreshStatus
_refreshStatus($a_obj_id, $a_users=null)
Set dirty.
Definition: class.ilLPStatusWrapper.php:302
ilLPStatus\_lookupStatus
static _lookupStatus($a_obj_id, $a_user_id, $a_create=true)
Lookup status.
Definition: class.ilLPStatus.php:548
ilLPStatus\_lookupPercentage
static _lookupPercentage($a_obj_id, $a_user_id)
Lookup percentage.
Definition: class.ilLPStatus.php:583
ilObjSCORMLearningModule\lookupSCOId
lookupSCOId($a_referrer)
resolves manifest SCOID to internal ILIAS SCO ID
Definition: class.ilObjSCORMLearningModule.php:1039
ilObjSCORMLearningModule\parseUserId
parseUserId($il_id)
Parse il_usr_123_6 id.
Definition: class.ilObjSCORMLearningModule.php:799
ilObjSCORMLearningModule\importSuccessForSahsUser
importSuccessForSahsUser($user_id, $last_access, $status, $attempts=null, $percentage_completed=null, $sco_total_time_sec=null)
Definition: class.ilObjSCORMLearningModule.php:758

References $data, $ilDB, $ilUser, ilObject\$lng, ilLPStatus\_lookupPercentage(), ilLPStatus\_lookupStatus(), ilLPStatusWrapper\_refreshStatus(), get_user_id(), ilObject\getId(), importSuccessForSahsUser(), lookupSCOId(), and parseUserId().

Referenced by importTrackingData().

+ Here is the call graph for this function:
+ Here is the caller graph for this function:

◆ importSuccess()

ilObjSCORMLearningModule::importSuccess (   $a_file)

Reimplemented in ilObjSCORM2004LearningModule.

Definition at line 638 of file class.ilObjSCORMLearningModule.php.

638 {
639
640 global $ilDB, $ilUser;
641 include_once("./Services/Tracking/classes/class.ilLPStatus.php");
642 $scos = array();
643 //get all SCO's of this object ONLY RELEVANT!
644 include_once './Services/Object/classes/class.ilObjectLP.php';
645 $olp = ilObjectLP::getInstance($this->getId());
646 $collection = $olp->getCollectionInstance();
647 if($collection)
648 {
649 $scos = $collection->getItems();
650 }
651
652 $fhandle = fopen($a_file, "r");
653
654 $obj_id = $this->getID();
655 $fields = fgetcsv($fhandle, pow(2, 16), ';');
656 $users = array();
657 $usersToDelete = array();
658 while(($csv_rows = fgetcsv($fhandle, pow(2, 16), ";")) !== FALSE)
659 {
660 $data = array_combine($fields, $csv_rows);
661 //no check the format - sufficient to import users
662 if ($data["Login"]) $user_id = $this->get_user_id($data["Login"]);
663 if ($data["login"]) $user_id = $this->get_user_id($data["login"]);
664 //add mail in future
665 if ($data["user"] && is_int($data["user"])) $user_id = $data["user"];
666 if ($user_id>0) {
667
668 $last_access = ilUtil::now();
669 if ($data['Date']) {
670 $date_ex = explode('.', $data['Date']);
671 $last_access = implode('-', array($date_ex[2], $date_ex[1], $date_ex[0]));
672 }
673 if ($data['LastAccess']) {
674 $last_access = $data['LastAccess'];
675 }
676
677 $status = ilLPStatus::LP_STATUS_COMPLETED_NUM;
678
679 if ($data["Status"]) {
680 if (is_int($data["Status"])) $status = $data["Status"];
681 else if ($data["Status"] == "0" || $data["Status"] == "1" || $data["Status"] == "2" || $data["Status"] == "3") $status = (int) $data["Status"];
682 else if ($data["Status"] == ilLPStatus::LP_STATUS_NOT_ATTEMPTED) $status = ilLPStatus::LP_STATUS_NOT_ATTEMPTED_NUM;
683 else if ($data["Status"] == ilLPStatus::LP_STATUS_IN_PROGRESS) $status = ilLPStatus::LP_STATUS_IN_PROGRESS_NUM;
684 else if ($data["Status"] == ilLPStatus::LP_STATUS_FAILED) $status = ilLPStatus::LP_STATUS_FAILED_NUM;
685 }
686
687 $attempts = null;
688 if($data["Attempts"]) $attempts = $data["Attempts"];
689
690 $percentage_completed = 0;
691 if ($status == ilLPStatus::LP_STATUS_COMPLETED_NUM) $percentage_completed = 100;
692 if ($data['percentageCompletedSCOs']) $percentage_completed = $data['percentageCompletedSCOs'];
693
694 $sco_total_time_sec = null;
695 if ($data['SumTotal_timeSeconds']) $sco_total_time_sec = $data['SumTotal_timeSeconds'];
696
697 if ($status == ilLPStatus::LP_STATUS_NOT_ATTEMPTED) {
698 $usersToDelete[] = $user_id;
699 } else {
700 $this->importSuccessForSahsUser($user_id, $last_access, $status, $attempts, $percentage_completed, $sco_total_time_sec);
701 $users[] = $user_id;
702 }
703
704 if ($status == ilLPStatus::LP_STATUS_COMPLETED_NUM) {
705 foreach ($scos as $sco_id)
706 {
707 $statement = $ilDB->queryF('
708 SELECT * FROM scorm_tracking
709 WHERE user_id = %s
710 AND sco_id = %s
711 AND lvalue = %s
712 AND obj_id = %s',
713 array('integer','integer','text','integer'),
714 array($user_id, $sco_id, 'cmi.core.lesson_status',$obj_id)
715 );
716 if($ilDB->numRows($statement) > 0)
717 {
718 $ilDB->update('scorm_tracking',
719 array(
720 'rvalue' => array('clob', 'completed'),
721 'c_timestamp' => array('timestamp', $last_access)
722 ),
723 array(
724 'user_id' => array('integer', $user_id),
725 'sco_id' => array('integer', $sco_id),
726 'lvalue' => array('text', 'cmi.core.lesson_status'),
727 'obj_id' => array('integer', $obj_id)
728 )
729 );
730 }
731 else
732 {
733 $ilDB->insert('scorm_tracking', array(
734 'obj_id' => array('integer', $obj_id),
735 'user_id' => array('integer', $user_id),
736 'sco_id' => array('integer', $sco_id),
737 'lvalue' => array('text', 'cmi.core.lesson_status'),
738 'rvalue' => array('clob', 'completed'),
739 'c_timestamp' => array('timestamp', $last_access)
740 ));
741 }
742 }
743 }
744 } else {
745 //echo "Warning! User $csv_rows[0] does not exist in ILIAS. Data for this user was skipped.\n";
746 }
747 }
748 if (count($usersToDelete)>0) {
749 // include_once("./Services/Tracking/classes/class.ilLPMarks.php");
750 // ilLPMarks::_deleteForUsers($this->getId(), $usersToDelete);
751 $this->deleteTrackingDataOfUsers($usersToDelete);
752 }
753 include_once("./Services/Tracking/classes/class.ilLPStatusWrapper.php");
754 ilLPStatusWrapper::_refreshStatus($this->getId(),$users);
755 return 0;
756 }
ilLPStatus\LP_STATUS_COMPLETED_NUM
const LP_STATUS_COMPLETED_NUM
Definition: class.ilLPStatus.php:30
ilLPStatus\LP_STATUS_FAILED
const LP_STATUS_FAILED
Definition: class.ilLPStatus.php:26
ilLPStatus\LP_STATUS_IN_PROGRESS_NUM
const LP_STATUS_IN_PROGRESS_NUM
Definition: class.ilLPStatus.php:29
ilLPStatus\LP_STATUS_NOT_ATTEMPTED_NUM
const LP_STATUS_NOT_ATTEMPTED_NUM
Definition: class.ilLPStatus.php:28
ilLPStatus\LP_STATUS_FAILED_NUM
const LP_STATUS_FAILED_NUM
Definition: class.ilLPStatus.php:31
ilLPStatus\LP_STATUS_NOT_ATTEMPTED
const LP_STATUS_NOT_ATTEMPTED
Definition: class.ilLPStatus.php:23
ilLPStatus\LP_STATUS_IN_PROGRESS
const LP_STATUS_IN_PROGRESS
Definition: class.ilLPStatus.php:24
ilObjectLP\getInstance
static getInstance($a_obj_id)
Definition: class.ilObjectLP.php:25
ilUtil\now
static now()
Return current timestamp in Y-m-d H:i:s format.
Definition: class.ilUtil.php:4239

References $data, $ilDB, $ilUser, ilLPStatusWrapper\_refreshStatus(), deleteTrackingDataOfUsers(), get_user_id(), ilObject\getId(), ilObjectLP\getInstance(), importSuccessForSahsUser(), ilLPStatus\LP_STATUS_COMPLETED_NUM, ilLPStatus\LP_STATUS_FAILED, ilLPStatus\LP_STATUS_FAILED_NUM, ilLPStatus\LP_STATUS_IN_PROGRESS, ilLPStatus\LP_STATUS_IN_PROGRESS_NUM, ilLPStatus\LP_STATUS_NOT_ATTEMPTED, ilLPStatus\LP_STATUS_NOT_ATTEMPTED_NUM, and ilUtil\now().

Referenced by importTrackingData().

+ Here is the call graph for this function:
+ Here is the caller graph for this function:

◆ importSuccessForSahsUser()

ilObjSCORMLearningModule::importSuccessForSahsUser (   $user_id,
  $last_access,
  $status,
  $attempts = null,
  $percentage_completed = null,
  $sco_total_time_sec = null 
)

Definition at line 758 of file class.ilObjSCORMLearningModule.php.

758 {
759 global $ilDB;
760 $statement = $ilDB->queryF('SELECT * FROM sahs_user WHERE obj_id = %s AND user_id = %s',
761 array('integer','integer'),
762 array($this->getID(),$user_id)
763 );
764 if($ilDB->numRows($statement) > 0)
765 {
766 $ilDB->update('sahs_user',
767 array(
768 'last_access' => array('timestamp', $last_access),
769 'status' => array('integer', $status),
770 'package_attempts' => array('integer', $attempts),
771 'percentage_completed' => array('integer', $percentage_completed),
772 'sco_total_time_sec' => array('integer', $sco_total_time_sec)
773 ),
774 array(
775 'obj_id' => array('integer', $this->getID()),
776 'user_id' => array('integer', $user_id)
777 )
778 );
779 }
780 else
781 {
782 $ilDB->insert('sahs_user', array(
783 'obj_id' => array('integer', $this->getID()),
784 'user_id' => array('integer', $user_id),
785 'last_access' => array('timestamp', $last_access),
786 'status' => array('integer', $status),
787 'package_attempts' => array('integer', $attempts),
788 'percentage_completed' => array('integer', $percentage_completed),
789 'sco_total_time_sec' => array('integer', $sco_total_time_sec)
790 ));
791 }
792 }

References $ilDB.

Referenced by importRaw(), ilObjSCORM2004LearningModule\importSuccess(), and importSuccess().

+ Here is the caller graph for this function:

◆ importTrackingData()

ilObjSCORMLearningModule::importTrackingData (   $a_file)

Definition at line 605 of file class.ilObjSCORMLearningModule.php.

606 {
607 global $ilDB, $ilUser;
608
609 $error = 0;
610 //echo file_get_contents($a_file);
611 $method = null;
612
613 //lets import
614 $fhandle = fopen($a_file, "r");
615
616 //the top line is the field names
617 $fields = fgetcsv($fhandle, pow(2, 16), ';');
618 //lets check the import method
619 fclose($fhandle);
620
621 switch($fields[0])
622 {
623 case "Scoid":
624 case "SCO-Identifier":
625 $error = $this->importRaw($a_file);
626 break;
627 case "Department":
628 case "LearningModuleId":
629 $error = $this->importSuccess($a_file);
630 break;
631 default:
632 return -1;
633 break;
634 }
635 return $error;
636 }
ilObjSCORMLearningModule\importRaw
importRaw($a_file)
Import raw data @global ilDB $ilDB @global ilObjUser $ilUser.
Definition: class.ilObjSCORMLearningModule.php:827

References $ilDB, $ilUser, importRaw(), and importSuccess().

+ Here is the call graph for this function:

◆ lookupSCOId()

ilObjSCORMLearningModule::lookupSCOId (   $a_referrer)
private

resolves manifest SCOID to internal ILIAS SCO ID

Definition at line 1039 of file class.ilObjSCORMLearningModule.php.

1039 {
1040 global $ilDB, $ilUser;
1041
1042 //non specific SCO entries
1043 if ($a_referrer=="0") {
1044 return 0;
1045 }
1046
1047 $val_set = $ilDB->queryF('
1048 SELECT obj_id FROM sc_item,scorm_tree
1049 WHERE (obj_id = child
1050 AND identifierref = %s
1051 AND slm_id = %s)',
1052 array('text','integer'), array($a_referrer,$this->getID()));
1053 $val_rec = $ilDB->fetchAssoc($val_set);
1054
1055 return $val_rec["obj_id"];
1056 }

References $ilDB, and $ilUser.

Referenced by importRaw().

+ Here is the caller graph for this function:

◆ parseUserId()

ilObjSCORMLearningModule::parseUserId (   $il_id)
private

Parse il_usr_123_6 id.

Parameters
<type>$il_id
Returns
<type>

Definition at line 799 of file class.ilObjSCORMLearningModule.php.

800 {
801 global $ilSetting;
802
803 $parts = explode('_', $il_id);
804
805 if(!count((array) $parts))
806 {
807 return 0;
808 }
809 if(!isset($parts[2]) or !isset($parts[3]))
810 {
811 return 0;
812 }
813 if($parts[2] != $ilSetting->get('inst_id',$parts[2]))
814 {
815 return 0;
816 }
817 return $parts[3];
818 }
$ilSetting
global $ilSetting
Definition: privfeed.php:40

References $ilSetting.

Referenced by importRaw().

+ Here is the caller graph for this function:

◆ readObject()

ilObjSCORMLearningModule::readObject ( )

read manifest file @access public

Reimplemented in ilObjSCORM2004LearningModule, and ilObjAICCLearningModule.

Definition at line 95 of file class.ilObjSCORMLearningModule.php.

96 {
97 global $ilErr;
98
99 $needs_convert = false;
100
101 // convert imsmanifest.xml file in iso to utf8 if needed
102
103 $manifest_file = $this->getDataDirectory()."/imsmanifest.xml";
104
105 // check if manifestfile exists and space left on device...
106 $check_for_manifest_file = is_file($manifest_file);
107
108 // if no manifestfile
109 if (!$check_for_manifest_file)
110 {
111 $this->ilias->raiseError($this->lng->txt("Manifestfile $manifest_file not found!"), $this->ilias->error_obj->MESSAGE);
112 return;
113 }
114
115 if ($check_for_manifest_file)
116 {
117 $manifest_file_array = file($manifest_file);
118 foreach($manifest_file_array as $mfa)
119 {
120 // if (seems_not_utf8($mfa))
121 if (@iconv('UTF-8', 'UTF-8', $mfa) != $mfa)
122 {
123 $needs_convert = true;
124 break;
125 }
126 }
127
128 // to copy the file we need some extraspace, counted in bytes *2 ... we need 2 copies....
129 $estimated_manifest_filesize = filesize($manifest_file) * 2;
130
131 // i deactivated this, because it seems to fail on some windows systems (see bug #1795)
132 //$check_disc_free = disk_free_space($this->getDataDirectory()) - $estimated_manifest_filesize;
133 $check_disc_free = 2;
134 }
135
136 // if $manifest_file needs to be converted to UTF8
137 if ($needs_convert)
138 {
139 // if file exists and enough space left on device
140 if ($check_for_manifest_file && ($check_disc_free > 1))
141 {
142
143 // create backup from original
144 if (!copy($manifest_file, $manifest_file.".old"))
145 {
146 echo "Failed to copy $manifest_file...<br>\n";
147 }
148
149 // read backupfile, convert each line to utf8, write line to new file
150 // php < 4.3 style
151 $f_write_handler = fopen($manifest_file.".new", "w");
152 $f_read_handler = fopen($manifest_file.".old", "r");
153 while (!feof($f_read_handler))
154 {
155 $zeile = fgets($f_read_handler);
156 //echo mb_detect_encoding($zeile);
157 fputs($f_write_handler, utf8_encode($zeile));
158 }
159 fclose($f_read_handler);
160 fclose($f_write_handler);
161
162 // copy new utf8-file to imsmanifest.xml
163 if (!copy($manifest_file.".new", $manifest_file))
164 {
165 echo "Failed to copy $manifest_file...<br>\n";
166 }
167
168 if (!@is_file($manifest_file))
169 {
170 $this->ilias->raiseError($this->lng->txt("cont_no_manifest"),
171 $this->ilias->error_obj->WARNING);
172 }
173 }
174 else
175 {
176 // gives out the specific error
177
178 if (!($check_disc_free > 1))
179 $this->ilias->raiseError($this->lng->txt("Not enough space left on device!"),$this->ilias->error_obj->MESSAGE);
180 return;
181 }
182
183 }
184 else
185 {
186 // check whether file starts with BOM (that confuses some sax parsers, see bug #1795)
187 $hmani = fopen($manifest_file, "r");
188 $start = fread($hmani, 3);
189 if (strtolower(bin2hex($start)) == "efbbbf")
190 {
191 $f_write_handler = fopen($manifest_file.".new", "w");
192 while (!feof($hmani))
193 {
194 $n = fread($hmani, 900);
195 fputs($f_write_handler, $n);
196 }
197 fclose($f_write_handler);
198 fclose($hmani);
199
200 // copy new utf8-file to imsmanifest.xml
201 if (!copy($manifest_file.".new", $manifest_file))
202 {
203 echo "Failed to copy $manifest_file...<br>\n";
204 }
205 }
206 else
207 {
208 fclose($hmani);
209 }
210 }
211
212 //validate the XML-Files in the SCORM-Package
213 if ($_POST["validate"] == "y")
214 {
215 if (!$this->validate($this->getDataDirectory()))
216 {
217 $ilErr->raiseError("<b>Validation Error(s):</b><br>".$this->getValidationSummary(),$ilErr->MESSAGE);
218 }
219 }
220
221 // start SCORM package parser
222 include_once ("./Modules/ScormAicc/classes/SCORM/class.ilSCORMPackageParser.php");
223 // todo determine imsmanifest.xml path here...
224 $slmParser = new ilSCORMPackageParser($this, $manifest_file);
225 $slmParser->startParsing();
226 return $slmParser->getPackageTitle();
227 }
$n
$n
Definition: RandomTest.php:80
ilObjSAHSLearningModule\getDataDirectory
getDataDirectory($mode="filesystem")
get data directory of lm
Definition: class.ilObjSAHSLearningModule.php:267
ilObjSCORMLearningModule\validate
validate($directory)
Validate all XML-Files in a SCOM-Directory.
Definition: class.ilObjSCORMLearningModule.php:40
$_POST
$_POST['username']
Definition: cron.php:12
$ilErr
$ilErr
Definition: inc.setup_header.php:67
ilias
redirection script todo: (a better solution should control the processing via a xml file)

References $_POST, $ilErr, $n, ilObjSAHSLearningModule\getDataDirectory(), getValidationSummary(), and validate().

+ Here is the call graph for this function:

◆ sendExportFile()

ilObjSCORMLearningModule::sendExportFile (   $a_header,
  $a_content 
)

send export file to browser

Definition at line 1077 of file class.ilObjSCORMLearningModule.php.

1078 {
1079 $timestamp = time();
1080 $refid = $this->getRefId();
1081 $filename = "scorm_tracking_".$refid."_".$timestamp.".csv";
1082 //Header
1083 header("Expires: 0");
1084 header("Cache-control: private");
1085 header("Cache-Control: must-revalidate, post-check=0, pre-check=0");
1086 header("Content-Description: File Transfer");
1087 header("Content-Type: application/octet-stream");
1088 header("Content-disposition: attachment; filename=$filename");
1089 echo $a_header.$a_content;
1090 exit;
1091 }
$filename
$filename
Definition: buildRTE.php:89
$timestamp
foreach($mandatory_scripts as $file) $timestamp
Definition: buildRTE.php:81
ilObject\getRefId
getRefId()
get reference id @access public
Definition: class.ilObject.php:328
exit
exit
Definition: login.php:54

References $filename, $timestamp, exit, and ilObject\getRefId().

Referenced by exportSelected().

+ Here is the call graph for this function:
+ Here is the caller graph for this function:

◆ setLearningProgressSettingsAtUpload()

ilObjSCORMLearningModule::setLearningProgressSettingsAtUpload ( )

set settings for learning progress determination per default at upload

Definition at line 232 of file class.ilObjSCORMLearningModule.php.

233 {
234 global $ilSetting;
235 //condition 1
236 $lm_set = new ilSetting("lm");
237 if ($lm_set->get('scorm_lp_auto_activate') != 1) return;
238 //condition 2
239 include_once("./Services/Tracking/classes/class.ilObjUserTracking.php");
240 if (ilObjUserTracking::_enabledLearningProgress() == false) return;
241
242 //set Learning Progress to Automatic by Collection of SCORM Items
243 include_once("./Services/Tracking/classes/class.ilLPObjSettings.php");
244 $lm_set = new ilLPObjSettings($this->getId());
245 $lm_set->setMode(ilLPObjSettings::LP_MODE_SCORM);
246 $lm_set->insert();
247
248 //select all SCOs as relevant for Learning Progress
249 include_once("Services/Tracking/classes/collection/class.ilLPCollectionOfSCOs.php");
250 $collection = new ilLPCollectionOfSCOs($this->getId(), ilLPObjSettings::LP_MODE_SCORM);
251 $scos = array();
252 foreach($collection->getPossibleItems() as $sco_id => $item)
253 {
254 $scos[] = $sco_id;
255 }
256 $collection->activateEntries($scos);
257 }
ilObjUserTracking\_enabledLearningProgress
static _enabledLearningProgress()
check wether learing progress is enabled or not
Definition: class.ilObjUserTracking.php:69
ilSetting
ILIAS Setting Class.
Definition: class.ilSetting.php:33
$lm_set
$lm_set
Definition: storeScorm2004.php:21

References $ilSetting, $lm_set, ilObjUserTracking\_enabledLearningProgress(), ilObject\getId(), and ilLPObjSettings\LP_MODE_SCORM.

+ Here is the call graph for this function:

◆ validate()

ilObjSCORMLearningModule::validate (   $directory)

Validate all XML-Files in a SCOM-Directory.

@access public

Returns
boolean true if all XML-Files are wellfomred and valid

Reimplemented in ilObjSCORM2004LearningModule.

Definition at line 40 of file class.ilObjSCORMLearningModule.php.

41 {
42 $this->validator = new ilObjSCORMValidator($directory);
43 $returnValue = $this->validator->validate();
44 return $returnValue;
45 }
ilObjSCORMValidator
Validation of SCORM-XML Files.
Definition: class.ilObjSCORMValidator.php:14

Referenced by readObject().

+ Here is the caller graph for this function:

Field Documentation

◆ $validator

ilObjSCORMLearningModule::$validator

Definition at line 19 of file class.ilObjSCORMLearningModule.php.

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