ilObjSCORMLearningModule Class Reference
Class ilObjSCORMLearningModule. More...
Inheritance diagram for ilObjSCORMLearningModule:
Collaboration diagram for ilObjSCORMLearningModule:
Public Member Functions | |
| __construct ($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 () | |
| 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) | |
| getLastVisited ($user_id) | |
| deleteTrackingDataOfUsers ($a_users) | |
| Public Member Functions inherited from ilObjSAHSLearningModule | |
| __construct ($a_id=0, $a_call_by_reference=true) | |
| Constructor @access public. More... | |
| create ($upload=false) | |
| create file based lm More... | |
| read () | |
| read object 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 More... | |
| getAutoReview () | |
| get auto review as true/false for SCORM 1.2 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_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... | |
| getIdSetting () | |
| update values for mastery_score / min_normalized_measure in database - not requested More... | |
| setIdSetting ($a_id_setting) | |
| set id_setting More... | |
| getNameSetting () | |
| get name_setting More... | |
| setNameSetting ($a_name_setting) | |
| set name_setting More... | |
| update () | |
| update object data 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... | |
| 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... | |
| zipLmForOfflineMode () | |
| getApiStudentId () | |
| Get cmi.core.student_id / cmi.learner_id for API. More... | |
| getApiStudentName () | |
| Get cmi.core.student_name / cmi.learner_name for API note: 'lastname, firstname' is required for SCORM 1.2; 9 = no name to hide student_name for external content. More... | |
| getViewButton () | |
| get button for view More... | |
| Public Member Functions inherited from ilObject | |
| __construct ($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 () | |
| 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 () | |
| setOwner ($a_owner) | |
| set object owner More... | |
| getCreateDate () | |
| get create date @access public More... | |
| getLastUpdateDate () | |
| get last update date @access public More... | |
| getDiskUsage () | |
| Gets the disk usage of the object in bytes. 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... | |
| 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... | |
| 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... | |
| setRegisterMode ($a_bool) | |
| isUserRegistered ($a_user_id=0) | |
| requireRegistration () | |
| getXMLZip () | |
| getHTMLDirectory () | |
| 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... | |
| 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 | _getTrackingItems ($a_obj_id) |
| get all tracking items of scorm object @access static More... | |
| 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 | _getScoresForUser ($a_item_id, $a_user_id) |
| Static Public Member Functions inherited from ilObjSAHSLearningModule | |
| static | _lookupOnline ($a_id) |
| check wether scorm module is online More... | |
| static | getAffectiveLocalization ($a_id) |
| Get affective localization. More... | |
| static | _lookupSubType ($a_obj_id) |
| lookup subtype id (scorm, ) More... | |
| 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 | _lookupOwnerName ($a_owner_id) |
| lookup owner name for owner id More... | |
| static | _getIdForImportId ($a_import_id) |
| get current object id for import id (static) More... | |
| static | _getAllReferences ($a_id) |
| get all reference ids of object More... | |
| static | _lookupTitle ($a_id) |
| lookup object title More... | |
| static | _lookupOwner ($a_id) |
| lookup object owner More... | |
| static | _getIdsForTitle ($title, $type='', $partialmatch=false) |
| static | _lookupDescription ($a_id) |
| lookup object description More... | |
| static | _lookupLastUpdate ($a_id, $a_as_string=false) |
| lookup last update More... | |
| static | _getLastUpdateOfObjects ($a_objs) |
| Get last update for a set of media objects. More... | |
| static | _lookupObjId ($a_id) |
| static | _setDeletedDate ($a_ref_id) |
| only called in ilTree::saveSubTree More... | |
| static | setDeletedDates ($a_ref_ids) |
| Set deleted date @global type $ilDB. More... | |
| static | _resetDeletedDate ($a_ref_id) |
| only called in ilObjectGUI::insertSavedNodes More... | |
| static | _lookupDeletedDate ($a_ref_id) |
| only called in ilObjectGUI::insertSavedNodes More... | |
| static | _writeTitle ($a_obj_id, $a_title) |
| write title to db (static) More... | |
| static | _writeDescription ($a_obj_id, $a_desc) |
| write description to db (static) More... | |
| static | _writeImportId ($a_obj_id, $a_import_id) |
| write import id to db (static) More... | |
| static | _lookupType ($a_id, $a_reference=false) |
| lookup object type More... | |
| static | _isInTrash ($a_ref_id) |
| checks wether object is in trash More... | |
| static | _hasUntrashedReference ($a_obj_id) |
| checks wether an object has at least one reference that is not in trash More... | |
| static | _lookupObjectId ($a_ref_id) |
| lookup object id More... | |
| static | _getObjectsDataForType ($a_type, $a_omit_trash=false) |
| get all objects of a certain type 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 | _lookupCreationDate ($a_id) |
| Lookup creation date. 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 |
| $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 | |
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... | |
Additional Inherited Members | |
| Protected Attributes inherited from ilObject | |
| $objDefinition | |
| $db | |
| $log | |
| $error | |
| $tree | |
| $app_event_handler | |
| $rbacadmin | |
| $rbacreview | |
Detailed Description
Class ilObjSCORMLearningModule.
Definition at line 17 of file class.ilObjSCORMLearningModule.php.
Constructor & Destructor Documentation
◆ __construct()
| ilObjSCORMLearningModule::__construct | ( | $a_id = 0, |
|
$a_call_by_reference = true |
|||
| ) |
Constructor @access public.
- Parameters
-
integer reference_id or object_id boolean treat the id as reference_id (true) or object_id (false)
Reimplemented from ilObjSAHSLearningModule.
Reimplemented in ilObjSCORM2004LearningModule.
Definition at line 27 of file class.ilObjSCORMLearningModule.php.
28 {
29 $this->type = "sahs";
30 parent::__construct($a_id, $a_call_by_reference);
31 }
Member Function Documentation
◆ _getAllScoIds()
|
static |
Get an array of id's for all Sco's in the module.
- Parameters
-
int $a_id Object id
- Returns
- array Sco id's
Definition at line 1110 of file class.ilObjSCORMLearningModule.php.
1111 {
1112 global $ilDB;
1113
1114 $scos = array();
1115
1116 $val_set = $ilDB->queryF(
1117 '
1118 SELECT scorm_object.obj_id,
1119 scorm_object.title,
1120 scorm_object.c_type,
1121 scorm_object.slm_id,
1122 scorm_object.obj_id scoid
1123 FROM scorm_object,sc_item,sc_resource
1124 WHERE(scorm_object.slm_id = %s
1125 AND scorm_object.obj_id = sc_item.obj_id
1126 AND sc_item.identifierref = sc_resource.import_id
1127 AND sc_resource.scormtype = %s)
1128 GROUP BY scorm_object.obj_id,
1129 scorm_object.title,
1130 scorm_object.c_type,
1131 scorm_object.slm_id,
1132 scorm_object.obj_id ',
1133 array('integer', 'text'),
1134 array($a_id,'sco')
1135 );
1136
1138 array_push($scos, $val_rec['scoid']);
1139 }
1140 return $scos;
1141 }
References $ilDB.
Referenced by _getCourseCompletionForUser().
Here is the caller graph for this function:
◆ _getCourseCompletionForUser()
|
static |
Get the completion of a SCORM module for a given user.
- Parameters
-
int $a_id Object id int $a_user User id
- Returns
- boolean Completion status
Reimplemented in ilObjSCORM2004LearningModule.
Definition at line 1190 of file class.ilObjSCORMLearningModule.php.
1191 {
1192 return ilObjSCORMLearningModule::_getStatusForUser($a_id, $a_user, ilObjSCORMLearningModule::_getAllScoIds($a_id), true);
1193 }
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:1151
static _getAllScoIds($a_id)
Get an array of id's for all Sco's in the module.
Definition: class.ilObjSCORMLearningModule.php:1110
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()
|
static |
Definition at line 1282 of file class.ilObjSCORMLearningModule.php.
1283 {
1284 global $ilDB;
1285
1286 $retAr = array("raw" => null, "max" => null, "scaled" => null);
1287 $val_set = $ilDB->queryF(
1288 "
1289 SELECT lvalue, rvalue FROM scorm_tracking
1290 WHERE sco_id = %s
1291 AND user_id = %s
1292 AND (lvalue = 'cmi.core.score.raw' OR lvalue = 'cmi.core.score.max')",
1293 array('integer', 'integer'),
1294 array($a_item_id, $a_user_id)
1295 );
1297 if ($val_rec['lvalue'] == "cmi.core.score.raw") {
1298 $retAr["raw"] = $val_rec["rvalue"];
1299 }
1300 if ($val_rec['lvalue'] == "cmi.core.score.max") {
1301 $retAr["max"] = $val_rec["rvalue"];
1302 }
1303 }
1304 if ($retAr["raw"] != null && $retAr["max"] != null) {
1305 $retAr["scaled"] = ($retAr["raw"] / $retAr["max"]);
1306 }
1307
1308 return $retAr;
1309 }
References $ilDB.
Referenced by ilLPCollectionOfSCOs\getScoresForUserAndCP_Node_Id().
Here is the caller graph for this function:
◆ _getStatusForUser()
|
static |
Get the status of a SCORM module for a given user.
- Parameters
-
int $a_id Object id int $a_user User id array $a_allScoIds Array of Sco id's in this module boolean $a_numerical Text (false) or boolean result (true)
- Returns
- mixed Status result
Definition at line 1151 of file class.ilObjSCORMLearningModule.php.
1152 {
1154
1155 $scos = $a_allScoIds;
1156 //check if all SCO's are completed
1157 $scos_c = implode(',', $scos);
1158
1159 $val_set = $ilDB->queryF(
1160 '
1161 SELECT * FROM scorm_tracking
1162 WHERE (user_id = %s
1163 AND obj_id = %s
1167 array('integer','integer','text','text'),
1168 array($a_user,$a_id,'cmi.core.lesson_status', 'cmi.core.lesson_status')
1169 );
1172 unset($scos[$key]);
1173 }
1174 //check for completion
1175 if (count($scos) == 0) {
1177 }
1178 if (count($scos) > 0) {
1180 }
1181 return $completion;
1182 }
References $ilDB, $key, and ilObject\$lng.
Referenced by _getCourseCompletionForUser().
Here is the caller graph for this function:
◆ _getTrackingItems()
|
static |
get all tracking items of scorm object @access static
Reimplemented in ilObjSCORM2004LearningModule.
Definition at line 65 of file class.ilObjSCORMLearningModule.php.
66 {
67 include_once("./Modules/ScormAicc/classes/SCORM/class.ilSCORMTree.php");
69 $root_id = $tree->readRootId();
70
71 $items = array();
73
74 foreach ($childs as $child) {
75 if ($child["c_type"] == "sit") {
76 include_once("./Modules/ScormAicc/classes/SCORM/class.ilSCORMItem.php");
78 if ($sc_item->getIdentifierRef() != "") {
79 $items[count($items)] = $sc_item;
80 }
81 }
82 }
83
84 return $items;
85 }
References ilObject\$tree.
Referenced by ilLPCollectionOfSCOs\getPossibleItems(), and getTrackingItems().
Here is the caller graph for this function:
◆ _lookupLastAccess()
|
static |
Return the last access timestamp for a given user.
- Parameters
-
int $a_obj_id object id int $user_id user id
- Returns
- timestamp
Reimplemented in ilObjSCORM2004LearningModule.
Definition at line 271 of file class.ilObjSCORMLearningModule.php.
272 {
273 global $ilDB;
274
276 '
277 SELECT last_access FROM sahs_user
278 WHERE obj_id = %s
279 AND user_id = %s',
280 array('integer','integer'),
281 array($a_obj_id,$a_usr_id)
282 );
283
287 }
288 return "";
289 }
References $ilDB, $result, and $row.
Referenced by ilObjSCORMVerification\createFromSCORMLM(), and ilSCORMPresentationGUI\downloadCertificate().
Here is the caller graph for this function:
◆ _removeTrackingDataForUser()
|
static |
Definition at line 1266 of file class.ilObjSCORMLearningModule.php.
1267 {
1268 global $ilDB;
1269 //gobjective
1270 $ilDB->manipulateF(
1271 'DELETE FROM scorm_tracking WHERE user_id = %s',
1272 array('integer'),
1273 array($user_id)
1274 );
1275 $ilDB->manipulateF(
1276 'DELETE FROM sahs_user WHERE user_id = %s',
1277 array('integer'),
1278 array($user_id)
1279 );
1280 }
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 994 of file class.ilObjSCORMLearningModule.php.
995 {
996 global $ilDB;
997
998 foreach ($a_user_id as $user) {
999 //first check if there is a package_attempts entry
1000 $val_set = $ilDB->queryF(
1001 'SELECT package_attempts FROM sahs_user WHERE user_id = %s AND obj_id = %s',
1002 array('integer','integer'),
1003 array($user,$this->getID())
1004 );
1005
1006 $val_rec = $ilDB->fetchAssoc($val_set);
1007
1008 if ($val_rec["package_attempts"] != null && $val_rec["package_attempts"] != 0) {
1009 $new_rec = 0;
1010 //decrease attempt by 1
1011 if ((int) $val_rec["package_attempts"] > 0) {
1012 $new_rec = (int) $val_rec["package_attempts"]-1;
1013 }
1014 $ilDB->manipulateF(
1015 'UPDATE sahs_user SET package_attempts = %s WHERE user_id = %s AND obj_id = %s',
1016 array('integer','integer','integer'),
1017 array($new_rec,$user,$this->getID())
1018 );
1019
1020 //following 2 lines were before 4.4 only for SCORM 1.2
1021 include_once("./Services/Tracking/classes/class.ilLPStatusWrapper.php");
1023 }
1024 }
1025 }
static _updateStatus($a_obj_id, $a_usr_id, $a_obj=null, $a_percentage=false, $a_force_raise=false)
Update status.
Definition: class.ilLPStatusWrapper.php:265
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 1328 of file class.ilObjSCORMLearningModule.php.
1329 {
1330 global $ilDB;
1331 include_once("./Services/Tracking/classes/class.ilChangeEvent.php");
1332 include_once("./Services/Tracking/classes/class.ilLPStatusWrapper.php");
1333
1335
1336 foreach ($a_users as $user) {
1337 $ilDB->manipulateF(
1338 '
1339 DELETE FROM scorm_tracking
1340 WHERE user_id = %s
1341 AND obj_id = %s',
1342 array('integer', 'integer'),
1343 array($user, $this->getID())
1344 );
1345
1346 $ilDB->manipulateF(
1347 '
1348 DELETE FROM sahs_user
1349 WHERE user_id = %s
1350 AND obj_id = %s',
1351 array('integer', 'integer'),
1352 array($user, $this->getID())
1353 );
1354
1356 }
1357 }
static _deleteReadEventsForUsers($a_obj_id, array $a_user_ids)
Definition: class.ilChangeEvent.php:897
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 553 of file class.ilObjSCORMLearningModule.php.
554 {
556 include_once('./Modules/ScormAicc/classes/class.ilSCORMTrackingItems.php');
557 include_once("./Services/Tracking/classes/class.ilLearningProgressBaseGUI.php");
558 include_once('./Services/PrivacySecurity/classes/class.ilPrivacySettings.php');
559 $privacy = ilPrivacySettings::_getInstance();
560 $allowExportPrivacy = $privacy->enabledExportSCORM();
561
562 $csv = "";
564 if (count($a_users) >0) {
566 }
568 $query,
569 array('integer'),
570 array($this->getId())
571 );
576 . ";\"" . implode("\";\"", ilSCORMTrackingItems::userDataArrayForExport($data["user_id"], $allowExportPrivacy)) . "\""
578 . ";\"" . ilLearningProgressBaseGUI::__readStatus($data["obj_id"], $data["user_id"]) . "\"" //not $data["status"] because modifications to learning progress could have made before export
582// . ";\"" . $certificateDate ."\""
583 . "\n";
584 }
585 $udh=ilSCORMTrackingItems::userDataHeaderForExport();
586 $header = "LearningModuleId;LearningModuleTitle;LearningModuleVersion;" . str_replace(',', ';', $udh["cols"]) . ";"
587 . "LastAccess;Status;Attempts;percentageCompletedSCOs;SumTotal_timeSeconds\n";
588
590 }
static __readStatus($a_obj_id, $user_id)
Definition: class.ilLearningProgressBaseGUI.php:565
sendExportFile($a_header, $a_content)
send export file to browser
Definition: class.ilObjSCORMLearningModule.php:1096
static userDataHeaderForExport()
Definition: class.ilSCORMTrackingItems.php:674
static userDataArrayForExport($user, $b_allowExportPrivacy=false)
Definition: class.ilSCORMTrackingItems.php:52
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 1029 of file class.ilObjSCORMLearningModule.php.
1030 {
1032
1033 $val_set = $ilDB->queryF(
1034 'SELECT * FROM usr_data WHERE(login=%s)',
1035 array('text'),
1036 array($a_login)
1037 );
1038 $val_rec = $ilDB->fetchAssoc($val_set);
1039
1040 if (count($val_rec)>0) {
1041 return $val_rec['usr_id'];
1042 } else {
1043 return null;
1044 }
1045 }
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 1195 of file class.ilObjSCORMLearningModule.php.
1196 {
1197 global $ilDB;
1198
1199 $scos = array();
1200 //get all SCO's of this object
1201 $val_set = $ilDB->queryF(
1202 '
1203 SELECT scorm_object.obj_id,
1204 scorm_object.title,
1205 scorm_object.c_type,
1206 scorm_object.slm_id,
1207 scorm_object.obj_id scoid
1208 FROM scorm_object, sc_item,sc_resource
1209 WHERE(scorm_object.slm_id = %s
1210 AND scorm_object.obj_id = sc_item.obj_id
1211 AND sc_item.identifierref = sc_resource.import_id
1212 AND sc_resource.scormtype = %s )
1213 GROUP BY scorm_object.obj_id,
1214 scorm_object.title,
1215 scorm_object.c_type,
1216 scorm_object.slm_id,
1217 scorm_object.obj_id',
1218 array('integer','text'),
1220 );
1221
1223 array_push($scos, $val_rec['scoid']);
1224 }
1225 return $scos;
1226 }
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 336 of file class.ilObjSCORMLearningModule.php.
337 {
338 global $ilDB;
339 $val_set = $ilDB->queryF(
340 'SELECT package_attempts FROM sahs_user WHERE obj_id = %s AND user_id = %s',
341 array('integer','integer'),
342 array($this->getId(),$a_user_id,0)
343 );
344
345 $val_rec = $ilDB->fetchAssoc($val_set);
346
347 if ($val_rec["package_attempts"] == null) {
348 $val_rec["package_attempts"]="";
349 }
350 return $val_rec["package_attempts"];
351 }
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 319 of file class.ilObjSCORMLearningModule.php.
320 {
321 global $ilDB;
322 $query = 'SELECT user_id, package_attempts FROM sahs_user WHERE obj_id = ' . $ilDB->quote($this->getId(), 'integer') . ' ';
324
325 $attempts = array();
328 }
329 return $attempts;
330 }
References $ilDB, $query, $res, $row, ilDBConstants\FETCHMODE_ASSOC, and ilObject\getId().
Here is the call graph for this function:
◆ getCourseCompletionForUser()
| ilObjSCORMLearningModule::getCourseCompletionForUser | ( | $a_user | ) |
Reimplemented in ilObjSCORM2004LearningModule.
Definition at line 1260 of file class.ilObjSCORMLearningModule.php.
1261 {
1263 }
getAllScoIds()
Definition: class.ilObjSCORMLearningModule.php:1195
getStatusForUser($a_user, $a_allScoIds, $a_numerical=false)
Definition: class.ilObjSCORMLearningModule.php:1228
References getAllScoIds(), and getStatusForUser().
Here is the call graph for this function:
◆ getLastVisited()
| ilObjSCORMLearningModule::getLastVisited | ( | $user_id | ) |
Definition at line 1312 of file class.ilObjSCORMLearningModule.php.
1313 {
1314 global $ilDB;
1315 $val_set = $ilDB->queryF(
1316 'SELECT last_visited FROM sahs_user WHERE obj_id = %s AND user_id = %s',
1317 array('integer','integer'),
1318 array($this->getID(),$user_id)
1319 );
1321 if ($val_rec["last_visited"] != null) {
1322 return "" . $val_rec["last_visited"];
1323 }
1324 }
1325 return '0';
1326 }
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 375 of file class.ilObjSCORMLearningModule.php.
376 {
377 global $ilDB;
378 $val_set = $ilDB->queryF(
379 'SELECT module_version FROM sahs_user WHERE obj_id = %s AND user_id = %s',
380 array('integer','integer'),
381 array($this->getId(),$a_user_id,0)
382 );
383
384 $val_rec = $ilDB->fetchAssoc($val_set);
385
386 if ($val_rec["module_version"] == null) {
387 $val_rec["module_version"]="";
388 }
389 return $val_rec["module_version"];
390 }
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 358 of file class.ilObjSCORMLearningModule.php.
359 {
360 global $ilDB;
361 $query = 'SELECT user_id, module_version FROM sahs_user WHERE obj_id = ' . $ilDB->quote($this->getId(), 'integer') . ' ';
363
364 $versions = array();
367 }
368 return $versions;
369 }
References $ilDB, $query, $res, $row, ilDBConstants\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 1228 of file class.ilObjSCORMLearningModule.php.
1229 {
1230 global $ilDB;
1231 $scos = $a_allScoIds;
1232 //loook up status
1233 //check if all SCO's are completed
1234 $scos_c = implode(',', $scos);
1235
1236 $val_set = $ilDB->queryF(
1237 '
1238 SELECT sco_id FROM scorm_tracking
1239 WHERE (user_id = %s
1240 AND obj_id = %s
1242 AND ((lvalue = %s AND ' . $ilDB->like('rvalue', 'clob', 'completed') . ') OR (lvalue = %s AND ' . $ilDB->like('rvalue', 'clob', 'passed') . ') ) )',
1243 array('integer','integer','text','text',),
1244 array($a_user,$this->getID(),'cmi.core.lesson_status','cmi.core.lesson_status')
1245 );
1248 unset($scos[$key]);
1249 }
1250 //check for completion
1251 if (count($scos) == 0) {
1252 $completion = ($a_numerical===true) ? true: $this->lng->txt("cont_complete");
1253 }
1254 if (count($scos) > 0) {
1255 $completion = ($a_numerical===true) ? false: $this->lng->txt("cont_incomplete");
1256 }
1257 return $completion;
1258 }
Referenced by getCourseCompletionForUser().
Here is the caller graph for this function:
◆ getTrackedItems()
| ilObjSCORMLearningModule::getTrackedItems | ( | ) |
get all tracked items of current user
Reimplemented in ilObjSCORM2004LearningModule.
Definition at line 241 of file class.ilObjSCORMLearningModule.php.
242 {
244
245 $sco_set = $ilDB->queryF(
246 '
247 SELECT DISTINCT sco_id FROM scorm_tracking WHERE obj_id = %s',
248 array('integer'),
249 array($this->getId())
250 );
251
252 $items = array();
254 include_once("./Modules/ScormAicc/classes/SCORM/class.ilSCORMItem.php");
256 if ($sc_item->getIdentifierRef() != "") {
257 $items[count($items)] = $sc_item;
258 }
259 }
260
261 return $items;
262 }
References $ilDB, $ilUser, and ilObject\getId().
Here is the call graph for this function:
◆ getTrackedUsers()
| ilObjSCORMLearningModule::getTrackedUsers | ( | $a_search | ) |
Definition at line 291 of file class.ilObjSCORMLearningModule.php.
292 {
294 //TODO: UK last_access is not correct if no Commit or last_visited_sco
295 // $query = 'SELECT user_id,MAX(c_timestamp) last_access, lastname, firstname FROM scorm_tracking st ' .
297 'JOIN usr_data ud ON st.user_id = ud.usr_id ' .
299 if ($a_search) {
300 // $query .= ' AND (' . $ilDB->like('lastname', 'text', '%' . $a_search . '%') . ' OR ' . $ilDB->like('firstname', 'text', '%' . $a_search . '%') .')';
302 }
305
306 $items = array();
308 $items[] = $sco_rec;
309 }
310 return $items;
311 }
References $ilDB, $ilUser, $query, and ilObject\getId().
Here is the call graph for this function:
◆ getTrackingDataAgg()
| ilObjSCORMLearningModule::getTrackingDataAgg | ( | $a_user_id | ) |
Definition at line 422 of file class.ilObjSCORMLearningModule.php.
423 {
424 global $ilDB;
425
426 // get all users with any tracking data
427 $sco_set = $ilDB->queryF(
428 '
429 SELECT DISTINCT sco_id FROM scorm_tracking
430 WHERE obj_id = %s
431 AND user_id = %s
432 AND sco_id <> %s',
433 array('integer','integer','integer'),
434 array($this->getId(),$a_user_id,0)
435 );
436
437 $data = array();
439 $data_set = $ilDB->queryF(
440 '
441 SELECT * FROM scorm_tracking
442 WHERE obj_id = %s
443 AND sco_id = %s
444 AND user_id = %s
445 AND lvalue <> %s
446 AND (lvalue = %s
447 OR lvalue = %s
448 OR lvalue = %s)',
449 array('integer','integer','integer','text','text','text','text'),
450 array($this->getId(),
451 $sco_rec["sco_id"],
452 $a_user_id,
453 "package_attempts",
454 "cmi.core.lesson_status",
455 "cmi.core.total_time",
456 "cmi.core.score.raw")
457 );
458
460
462 switch ($data_rec["lvalue"]) {
463 case "cmi.core.lesson_status":
464 $status = $data_rec["rvalue"];
465 break;
466
467 case "cmi.core.total_time":
469 break;
470
471 case "cmi.core.score.raw":
472 $score = $data_rec["rvalue"];
473 break;
474 }
475 }
476 //create sco_object
477 include_once './Modules/ScormAicc/classes/SCORM/class.ilSCORMItem.php';
481 }
483 }
References $data, $ilDB, $time, and ilObject\getId().
Here is the call graph for this function:
◆ getTrackingDataAggSco()
| ilObjSCORMLearningModule::getTrackingDataAggSco | ( | $a_sco_id | ) |
Definition at line 485 of file class.ilObjSCORMLearningModule.php.
486 {
487 global $ilDB;
488
489 // get all users with any tracking data
490 $user_set = $ilDB->queryF(
491 '
492 SELECT DISTINCT user_id FROM scorm_tracking
493 WHERE obj_id = %s
494 AND sco_id = %s',
495 array('integer','integer'),
496 array($this->getId(),$a_sco_id)
497 );
498
499 $data = array();
501 $data_set = $ilDB->queryF(
502 '
503 SELECT * FROM scorm_tracking
504 WHERE obj_id = %s
505 AND sco_id = %s
506 AND user_id = %s
507 AND (lvalue = %s
508 OR lvalue = %s
509 OR lvalue = %s)',
510 array('integer','integer','integer','text','text','text'),
511 array($this->getId(),
512 $a_sco_id,
513 $user_rec["user_id"],
514 "cmi.core.lesson_status",
515 "cmi.core.total_time",
516 "cmi.core.score.raw")
517 );
518
520
522 switch ($data_rec["lvalue"]) {
523 case "cmi.core.lesson_status":
524 $status = $data_rec["rvalue"];
525 break;
526
527 case "cmi.core.total_time":
529 break;
530
531 case "cmi.core.score.raw":
532 $score = $data_rec["rvalue"];
533 break;
534 }
535 }
536
539 }
540
542 }
References $data, $ilDB, $time, 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 399 of file class.ilObjSCORMLearningModule.php.
400 {
401 global $ilDB;
402
403 $data_set = $ilDB->queryF(
404 '
405 SELECT * FROM scorm_tracking
406 WHERE user_id = %s
407 AND sco_id = %s
408 AND obj_id = %s
409 ORDER BY lvalue',
410 array('integer','integer','integer'),
411 array($a_user_id,$a_sco_id,$this->getId())
412 );
413
414 $data = array();
416 $data[] = $data_rec;
417 }
418
420 }
References $data, $ilDB, and ilObject\getId().
Here is the call graph for this function:
◆ getTrackingItems()
| ilObjSCORMLearningModule::getTrackingItems | ( | ) |
Definition at line 55 of file class.ilObjSCORMLearningModule.php.
56 {
58 }
static _getTrackingItems($a_obj_id)
get all tracking items of scorm object @access static
Definition: class.ilObjSCORMLearningModule.php:65
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 1077 of file class.ilObjSCORMLearningModule.php.
◆ getValidationSummary()
| ilObjSCORMLearningModule::getValidationSummary | ( | ) |
Definition at line 47 of file class.ilObjSCORMLearningModule.php.
48 {
49 if (is_object($this->validator)) {
50 return $this->validator->getSummary();
51 }
52 return "";
53 }
Referenced by ilObjSCORM2004LearningModule\readObject(), and readObject().
Here is the caller graph for this function:
◆ importRaw()
|
private |
Import raw data @global ilDB $ilDB @global ilObjUser $ilUser.
- Parameters
-
string $a_file
- Returns
- void
Definition at line 830 of file class.ilObjSCORMLearningModule.php.
831 {
834
835 $fhandle = fopen($a_file, "r");
836
837 $fields = fgetcsv($fhandle, pow(2, 16), ';');
838 $users = array();
839 $a_last_access = array();
840 $a_time = array();
841 $a_package_attempts = array();
842 $a_module_version = array();
843 while (($csv_rows = fgetcsv($fhandle, pow(2, 16), ";")) !== false) {
844 $data = array_combine($fields, $csv_rows);
850 }
851 }
854 }
855 if (!$user_id) {
856 continue;
857 }
858
861 }
864 }
865 if (!$il_sco_id) {
866 continue;
867 }
868
869 $c_timestamp="";
872 }
875 }
876 if ($c_timestamp == "") {
877 $date = new DateTime();
878 $c_timestamp = $date->getTimestamp();
879 } else {
880 if ($a_last_access[$user_id]) {
881 if ($a_last_access[$user_id] < $c_timestamp) {
882 $a_last_access[$user_id] = $c_timestamp;
883 }
884 } else {
885 $a_last_access[$user_id] = $c_timestamp;
886 }
887 }
888
890 continue;
891 }
894 }
895
898 $sec = (int) $tarr[2] + (int) $tarr[1] * 60 +
899 (int) substr($tarr[0], strlen($tarr[0]) - 3) * 60 * 60;
900 if ($a_time[$user_id]) {
901 $a_time[$user_id] += $sec;
902 } else {
903 $a_time[$user_id] = $sec;
904 }
905 }
906 //do the actual import
907 if ($il_sco_id > 0) {
908 $statement = $ilDB->queryF(
909 '
910 SELECT * FROM scorm_tracking
911 WHERE user_id = %s
912 AND sco_id = %s
913 AND lvalue = %s
914 AND obj_id = %s',
915 array('integer', 'integer', 'text', 'integer'),
917 );
919 $ilDB->update(
920 'scorm_tracking',
921 array(
923 'c_timestamp' => array('timestamp', $c_timestamp)
924 ),
925 array(
926 'user_id' => array('integer', $user_id),
927 'sco_id' => array('integer', $il_sco_id),
930 )
931 );
932 } else {
933 $ilDB->insert('scorm_tracking', array(
935 'user_id' => array('integer', $user_id),
936 'sco_id' => array('integer', $il_sco_id),
940 ));
941 }
942 }
943 // $package_attempts = 1;
944 if ($il_sco_id == 0) {
947 }
948 // if ($data['Key'] == "module_version") $a_module_version[$user_id] = $data['Value'];
949 }
951 $users[] = $user_id;
952 }
953 }
954 fclose($fhandle);
955
956 //UK determineStatus, percentage_completed and syncGlobalStatus
957 include_once './Services/Tracking/classes/class.ilLPStatusWrapper.php';
959
960 // include_once './Services/Tracking/classes/status/class.ilLPStatusSCORM.php';
961 include_once './Services/Tracking/classes/class.ilLPStatus.php';
963 $attempts = 1;
964 if ($a_package_attempts[$user_id]) {
965 $attempts = $a_package_attempts[$user_id];
966 }
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]) {
971 $sco_total_time_sec = $a_time[$user_id];
972 }
973 $last_access = null;
974 if ($a_last_access[$user_id]) {
975 $last_access = $a_last_access[$user_id];
976 }
977 // $status = ilLPStatusWrapper::_determineStatus($this->getId(),$user_id);
979 // $percentage_completed = ilLPStatusSCORM::determinePercentage($this->getId(),$user_id);
981
982 $this->importSuccessForSahsUser($user_id, $last_access, $status, $attempts, $percentage_completed, $sco_total_time_sec);
983 }
984
985 return 0;
986 }
static _refreshStatus($a_obj_id, $a_users=null)
Set dirty.
Definition: class.ilLPStatusWrapper.php:290
static _lookupStatus($a_obj_id, $a_user_id, $a_create=true)
Lookup status.
Definition: class.ilLPStatus.php:548
static _lookupPercentage($a_obj_id, $a_user_id)
Lookup percentage.
Definition: class.ilLPStatus.php:581
get_user_id($a_login)
Definition: class.ilObjSCORMLearningModule.php:1029
lookupSCOId($a_referrer)
resolves manifest SCOID to internal ILIAS SCO ID
Definition: class.ilObjSCORMLearningModule.php:1051
importSuccessForSahsUser($user_id, $last_access, $status, $attempts=null, $percentage_completed=null, $sco_total_time_sec=null)
Definition: class.ilObjSCORMLearningModule.php:761
References $data, $ilDB, $ilUser, ilObject\$lng, $users, 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 625 of file class.ilObjSCORMLearningModule.php.
626 {
628 include_once("./Services/Tracking/classes/class.ilLPStatus.php");
629 $scos = array();
630 //get all SCO's of this object ONLY RELEVANT!
631 include_once './Services/Object/classes/class.ilObjectLP.php';
633 $collection = $olp->getCollectionInstance();
634 if ($collection) {
635 $scos = $collection->getItems();
636 }
637
638 $fhandle = fopen($a_file, "r");
639
640 $obj_id = $this->getID();
641 $fields = fgetcsv($fhandle, pow(2, 16), ';');
642 $users = array();
643 $usersToDelete = array();
644 while (($csv_rows = fgetcsv($fhandle, pow(2, 16), ";")) !== false) {
645 $data = array_combine($fields, $csv_rows);
646 //no check the format - sufficient to import users
649 }
652 }
653 //add mail in future
656 }
657
658 if ($user_id>0) {
659 $last_access = ilUtil::now();
662 $last_access = implode('-', array($date_ex[2], $date_ex[1], $date_ex[0]));
663 }
666 }
667
668 $status = ilLPStatus::LP_STATUS_COMPLETED_NUM;
669
673 } elseif ($data["Status"] == "0" || $data["Status"] == "1" || $data["Status"] == "2" || $data["Status"] == "3") {
676 $status = ilLPStatus::LP_STATUS_NOT_ATTEMPTED_NUM;
678 $status = ilLPStatus::LP_STATUS_IN_PROGRESS_NUM;
680 $status = ilLPStatus::LP_STATUS_FAILED_NUM;
681 }
682 }
683
684 $attempts = null;
687 }
688
689 $percentage_completed = 0;
691 $percentage_completed = 100;
692 }
695 }
696
697 $sco_total_time_sec = null;
700 }
701
703 $usersToDelete[] = $user_id;
704 } else {
705 $this->importSuccessForSahsUser($user_id, $last_access, $status, $attempts, $percentage_completed, $sco_total_time_sec);
706 $users[] = $user_id;
707 }
708
710 foreach ($scos as $sco_id) {
711 $statement = $ilDB->queryF(
712 '
713 SELECT * FROM scorm_tracking
714 WHERE user_id = %s
715 AND sco_id = %s
716 AND lvalue = %s
717 AND obj_id = %s',
718 array('integer','integer','text','integer'),
719 array($user_id, $sco_id, 'cmi.core.lesson_status',$obj_id)
720 );
722 $ilDB->update(
723 'scorm_tracking',
724 array(
725 'rvalue' => array('clob', 'completed'),
726 'c_timestamp' => array('timestamp', $last_access)
727 ),
728 array(
729 'user_id' => array('integer', $user_id),
730 'sco_id' => array('integer', $sco_id),
731 'lvalue' => array('text', 'cmi.core.lesson_status'),
732 'obj_id' => array('integer', $obj_id)
733 )
734 );
735 } else {
737 'obj_id' => array('integer', $obj_id),
738 'user_id' => array('integer', $user_id),
739 'sco_id' => array('integer', $sco_id),
740 'lvalue' => array('text', 'cmi.core.lesson_status'),
741 'rvalue' => array('clob', 'completed'),
742 'c_timestamp' => array('timestamp', $last_access)
743 ));
744 }
745 }
746 }
747 } else {
748 //echo "Warning! User $csv_rows[0] does not exist in ILIAS. Data for this user was skipped.\n";
749 }
750 }
751 if (count($usersToDelete)>0) {
752 // include_once("./Services/Tracking/classes/class.ilLPMarks.php");
753 // ilLPMarks::_deleteForUsers($this->getId(), $usersToDelete);
754 $this->deleteTrackingDataOfUsers($usersToDelete);
755 }
756 include_once("./Services/Tracking/classes/class.ilLPStatusWrapper.php");
758 return 0;
759 }
const LP_STATUS_IN_PROGRESS_NUM
Definition: class.ilLPStatus.php:29
const LP_STATUS_NOT_ATTEMPTED_NUM
Definition: class.ilLPStatus.php:28
deleteTrackingDataOfUsers($a_users)
Definition: class.ilObjSCORMLearningModule.php:1328
References $data, $ilDB, $ilUser, $users, 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 761 of file class.ilObjSCORMLearningModule.php.
762 {
763 global $ilDB;
764 $statement = $ilDB->queryF(
765 'SELECT * FROM sahs_user WHERE obj_id = %s AND user_id = %s',
766 array('integer','integer'),
767 array($this->getID(),$user_id)
768 );
770 $ilDB->update(
771 'sahs_user',
772 array(
773 'last_access' => array('timestamp', $last_access),
774 'status' => array('integer', $status),
775 'package_attempts' => array('integer', $attempts),
776 'percentage_completed' => array('integer', $percentage_completed),
777 'sco_total_time_sec' => array('integer', $sco_total_time_sec)
778 ),
779 array(
780 'obj_id' => array('integer', $this->getID()),
781 'user_id' => array('integer', $user_id)
782 )
783 );
784 } else {
786 'obj_id' => array('integer', $this->getID()),
787 'user_id' => array('integer', $user_id),
788 'last_access' => array('timestamp', $last_access),
789 'status' => array('integer', $status),
790 'package_attempts' => array('integer', $attempts),
791 'percentage_completed' => array('integer', $percentage_completed),
792 'sco_total_time_sec' => array('integer', $sco_total_time_sec)
793 ));
794 }
795
796 include_once("./Services/Tracking/classes/class.ilChangeEvent.php");
797 ilChangeEvent::_recordReadEvent("sahs", (int) $_GET["ref_id"], $this->getID(), $user_id, false, $attempts, $sco_total_time_sec);
798 }
static _recordReadEvent( $a_type, $a_ref_id, $obj_id, $usr_id, $isCatchupWriteEvents=true, $a_ext_rc=false, $a_ext_time=false)
Records a read event and catches up with write events.
Definition: class.ilChangeEvent.php:111
References $_GET, $ilDB, and ilChangeEvent\_recordReadEvent().
Referenced by importRaw(), ilObjSCORM2004LearningModule\importSuccess(), and importSuccess().
Here is the call graph for this function:
Here is the caller graph for this function:
◆ importTrackingData()
| ilObjSCORMLearningModule::importTrackingData | ( | $a_file | ) |
Definition at line 593 of file class.ilObjSCORMLearningModule.php.
594 {
596
597 $error = 0;
598 //echo file_get_contents($a_file);
599 $method = null;
600
601 //lets import
602 $fhandle = fopen($a_file, "r");
603
604 //the top line is the field names
605 $fields = fgetcsv($fhandle, pow(2, 16), ';');
606 //lets check the import method
607 fclose($fhandle);
608
609 switch ($fields[0]) {
610 case "Scoid":
611 case "SCO-Identifier":
613 break;
614 case "Department":
615 case "LearningModuleId":
617 break;
618 default:
619 return -1;
620 break;
621 }
623 }
importRaw($a_file)
Import raw data @global ilDB $ilDB @global ilObjUser $ilUser.
Definition: class.ilObjSCORMLearningModule.php:830
importSuccess($a_file)
Definition: class.ilObjSCORMLearningModule.php:625
References ilObject\$error, $ilDB, $ilUser, importRaw(), and importSuccess().
Here is the call graph for this function:
◆ lookupSCOId()
|
private |
resolves manifest SCOID to internal ILIAS SCO ID
Definition at line 1051 of file class.ilObjSCORMLearningModule.php.
1052 {
1054
1055 //non specific SCO entries
1056 if ($a_referrer=="0") {
1057 return 0;
1058 }
1059
1060 $val_set = $ilDB->queryF(
1061 '
1062 SELECT obj_id FROM sc_item,scorm_tree
1063 WHERE (obj_id = child
1064 AND identifierref = %s
1065 AND slm_id = %s)',
1066 array('text','integer'),
1067 array($a_referrer,$this->getID())
1068 );
1069 $val_rec = $ilDB->fetchAssoc($val_set);
1070
1071 return $val_rec["obj_id"];
1072 }
References $ilDB, and $ilUser.
Referenced by importRaw().
Here is the caller graph for this function:
◆ parseUserId()
|
private |
Parse il_usr_123_6 id.
- Parameters
-
<type> $il_id
- Returns
- <type>
Definition at line 805 of file class.ilObjSCORMLearningModule.php.
806 {
807 global $ilSetting;
808
809 $parts = explode('_', $il_id);
810
811 if (!count((array) $parts)) {
812 return 0;
813 }
814 if (!isset($parts[2]) or !isset($parts[3])) {
815 return 0;
816 }
818 return 0;
819 }
820 return $parts[3];
821 }
References $ilSetting.
Referenced by importRaw().
Here is the caller graph for this function:
◆ readObject()
| ilObjSCORMLearningModule::readObject | ( | ) |
read manifest file @access public
Reimplemented in ilObjSCORM2004LearningModule.
Definition at line 91 of file class.ilObjSCORMLearningModule.php.
92 {
93 global $ilErr;
94
95 $needs_convert = false;
96
97 // convert imsmanifest.xml file in iso to utf8 if needed
98
100
101 // check if manifestfile exists and space left on device...
102 $check_for_manifest_file = is_file($manifest_file);
103
104 // if no manifestfile
105 if (!$check_for_manifest_file) {
106 $this->ilias->raiseError($this->lng->txt("Manifestfile $manifest_file not found!"), $this->ilias->error_obj->MESSAGE);
107 return;
108 }
109
110 if ($check_for_manifest_file) {
111 $manifest_file_array = file($manifest_file);
112 foreach ($manifest_file_array as $mfa) {
113 // if (seems_not_utf8($mfa))
114 if (@iconv('UTF-8', 'UTF-8', $mfa) != $mfa) {
115 $needs_convert = true;
116 break;
117 }
118 }
119
120 // to copy the file we need some extraspace, counted in bytes *2 ... we need 2 copies....
121 $estimated_manifest_filesize = filesize($manifest_file) * 2;
122
123 // i deactivated this, because it seems to fail on some windows systems (see bug #1795)
124 //$check_disc_free = disk_free_space($this->getDataDirectory()) - $estimated_manifest_filesize;
125 $check_disc_free = 2;
126 }
127
128 // if $manifest_file needs to be converted to UTF8
129 if ($needs_convert) {
130 // if file exists and enough space left on device
131 if ($check_for_manifest_file && ($check_disc_free > 1)) {
132
133 // create backup from original
134 if (!copy($manifest_file, $manifest_file . ".old")) {
135 echo "Failed to copy $manifest_file...<br>\n";
136 }
137
138 // read backupfile, convert each line to utf8, write line to new file
139 // php < 4.3 style
140 $f_write_handler = fopen($manifest_file . ".new", "w");
141 $f_read_handler = fopen($manifest_file . ".old", "r");
142 while (!feof($f_read_handler)) {
143 $zeile = fgets($f_read_handler);
144 //echo mb_detect_encoding($zeile);
145 fputs($f_write_handler, utf8_encode($zeile));
146 }
147 fclose($f_read_handler);
148 fclose($f_write_handler);
149
150 // copy new utf8-file to imsmanifest.xml
151 if (!copy($manifest_file . ".new", $manifest_file)) {
152 echo "Failed to copy $manifest_file...<br>\n";
153 }
154
155 if (!@is_file($manifest_file)) {
156 $this->ilias->raiseError(
157 $this->lng->txt("cont_no_manifest"),
158 $this->ilias->error_obj->WARNING
159 );
160 }
161 } else {
162 // gives out the specific error
163
164 if (!($check_disc_free > 1)) {
165 $this->ilias->raiseError($this->lng->txt("Not enough space left on device!"), $this->ilias->error_obj->MESSAGE);
166 }
167 return;
168 }
169 } else {
170 // check whether file starts with BOM (that confuses some sax parsers, see bug #1795)
171 $hmani = fopen($manifest_file, "r");
172 $start = fread($hmani, 3);
173 if (strtolower(bin2hex($start)) == "efbbbf") {
174 $f_write_handler = fopen($manifest_file . ".new", "w");
175 while (!feof($hmani)) {
176 $n = fread($hmani, 900);
177 fputs($f_write_handler, $n);
178 }
179 fclose($f_write_handler);
180 fclose($hmani);
181
182 // copy new utf8-file to imsmanifest.xml
183 if (!copy($manifest_file . ".new", $manifest_file)) {
184 echo "Failed to copy $manifest_file...<br>\n";
185 }
186 } else {
187 fclose($hmani);
188 }
189 }
190
191 //validate the XML-Files in the SCORM-Package
194 $ilErr->raiseError("<b>Validation Error(s):</b><br>" . $this->getValidationSummary(), $ilErr->MESSAGE);
195 }
196 }
197
198 // start SCORM package parser
199 include_once("./Modules/ScormAicc/classes/SCORM/class.ilSCORMPackageParser.php");
200 // todo determine imsmanifest.xml path here...
202 $slmParser->startParsing();
203 return $slmParser->getPackageTitle();
204 }
getDataDirectory($mode="filesystem")
get data directory of lm
Definition: class.ilObjSAHSLearningModule.php:283
getValidationSummary()
Definition: class.ilObjSCORMLearningModule.php:47
validate($directory)
Validate all XML-Files in a SCOM-Directory.
Definition: class.ilObjSCORMLearningModule.php:40
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 1096 of file class.ilObjSCORMLearningModule.php.
1097 {
1098 $timestamp = time();
1099 $refid = $this->getRefId();
1102 exit;
1103 }
static deliverData($a_data, $a_filename, $mime="application/octet-stream", $charset="")
deliver data for download via browser.
Definition: class.ilUtil.php:1966
References $a_content, $filename, $timestamp, ilUtil\deliverData(), 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 209 of file class.ilObjSCORMLearningModule.php.
210 {
211 global $ilSetting;
212 //condition 1
215 return;
216 }
217 //condition 2
218 include_once("./Services/Tracking/classes/class.ilObjUserTracking.php");
220 return;
221 }
222
223 //set Learning Progress to Automatic by Collection of SCORM Items
224 include_once("./Services/Tracking/classes/class.ilLPObjSettings.php");
227 $lm_set->insert();
228
229 //select all SCOs as relevant for Learning Progress
230 include_once("Services/Tracking/classes/collection/class.ilLPCollectionOfSCOs.php");
232 $scos = array();
233 foreach ($collection->getPossibleItems() as $sco_id => $item) {
234 $scos[] = $sco_id;
235 }
236 $collection->activateEntries($scos);
237 }
Definition: class.ilLPObjSettings.php:15
static _enabledLearningProgress()
check wether learing progress is enabled or not
Definition: class.ilObjUserTracking.php:69
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 {
43 $returnValue = $this->validator->validate();
44 return $returnValue;
45 }
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:
- Modules/ScormAicc/classes/class.ilObjSCORMLearningModule.php
