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, 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... | |
| 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, $a_omit_tree=false) | |
| Clone scorm object. More... | |
| zipLmForOfflineMode () | |
| 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 () | |
| 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... | |
| 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... | |
| 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... | |
| 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, aicc, hacp) 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 |
| $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 | |
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.
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, ilObjAICCLearningModule, and ilObjHACPLearningModule.
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 1102 of file class.ilObjSCORMLearningModule.php.
1103 {
1104 global $ilDB;
1105
1106 $scos = array();
1107
1109 SELECT scorm_object.obj_id,
1110 scorm_object.title,
1111 scorm_object.c_type,
1112 scorm_object.slm_id,
1113 scorm_object.obj_id scoid
1114 FROM scorm_object,sc_item,sc_resource
1115 WHERE(scorm_object.slm_id = %s
1116 AND scorm_object.obj_id = sc_item.obj_id
1117 AND sc_item.identifierref = sc_resource.import_id
1118 AND sc_resource.scormtype = %s)
1119 GROUP BY scorm_object.obj_id,
1120 scorm_object.title,
1121 scorm_object.c_type,
1122 scorm_object.slm_id,
1123 scorm_object.obj_id ',
1124 array('integer', 'text'),
1125 array($a_id,'sco'));
1126
1128 {
1129 array_push($scos,$val_rec['scoid']);
1130 }
1131 return $scos;
1132 }
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 1180 of file class.ilObjSCORMLearningModule.php.
1181 {
1182 return ilObjSCORMLearningModule::_getStatusForUser($a_id, $a_user, ilObjSCORMLearningModule::_getAllScoIds($a_id), true);
1183 }
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:1142
static _getAllScoIds($a_id)
Get an array of id's for all Sco's in the module.
Definition: class.ilObjSCORMLearningModule.php:1102
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 1266 of file class.ilObjSCORMLearningModule.php.
1267 {
1268 global $ilDB;
1269
1270 $retAr = array("raw" => null, "max" => null, "scaled" => null);
1272 SELECT lvalue, rvalue FROM scorm_tracking
1273 WHERE sco_id = %s
1274 AND user_id = %s
1275 AND (lvalue = 'cmi.core.score.raw' OR lvalue = 'cmi.core.score.max')",
1276 array('integer', 'integer'),
1277 array($a_item_id, $a_user_id)
1278 );
1280 {
1281 if ($val_rec['lvalue'] == "cmi.core.score.raw") $retAr["raw"] = $val_rec["rvalue"];
1282 if ($val_rec['lvalue'] == "cmi.core.score.max") $retAr["max"] = $val_rec["rvalue"];
1283 }
1284 if ($retAr["raw"] != null && $retAr["max"] != null) $retAr["scaled"] = ($retAr["raw"] / $retAr["max"]);
1285
1286 return $retAr;
1287 }
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 1142 of file class.ilObjSCORMLearningModule.php.
1143 {
1145
1146 $scos = $a_allScoIds;
1147 //check if all SCO's are completed
1148 $scos_c = implode(',',$scos);
1149
1151 SELECT * FROM scorm_tracking
1152 WHERE (user_id = %s
1153 AND obj_id = %s
1157 array('integer','integer','text','text'),
1158 array($a_user,$a_id,'cmi.core.lesson_status', 'cmi.core.lesson_status'));
1160 {
1161 $key = array_search($val_rec['sco_id'], $scos);
1162 unset ($scos[$key]);
1163 }
1164 //check for completion
1165 if (count($scos) == 0) {
1167 }
1168 if (count($scos) > 0) {
1170 }
1171 return $completion;
1172 }
References $ilDB, 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, and ilObjAICCLearningModule.
Definition at line 66 of file class.ilObjSCORMLearningModule.php.
67 {
68 include_once("./Modules/ScormAicc/classes/SCORM/class.ilSCORMTree.php");
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");
81 if ($sc_item->getIdentifierRef() != "")
82 {
83 $items[count($items)] = $sc_item;
84 }
85 }
86 }
87
88 return $items;
89 }
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 290 of file class.ilObjSCORMLearningModule.php.
291 {
292 global $ilDB;
293
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
301 {
304 }
305 return "";
306 }
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 1251 of file class.ilObjSCORMLearningModule.php.
1251 {
1252 global $ilDB;
1253 //gobjective
1254 $ilDB->manipulateF(
1255 'DELETE FROM scorm_tracking WHERE user_id = %s',
1256 array('integer'),
1257 array($user_id)
1258 );
1259 $ilDB->manipulateF(
1260 'DELETE FROM sahs_user WHERE user_id = %s',
1261 array('integer'),
1262 array($user_id)
1263 );
1264 }
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 995 of file class.ilObjSCORMLearningModule.php.
995 {
996 global $ilDB;
997
998 foreach ($a_user_id as $user)
999 {
1000 //first check if there is a package_attempts entry
1001 $val_set = $ilDB->queryF('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 $val_rec = $ilDB->fetchAssoc($val_set);
1006
1007 if ($val_rec["package_attempts"] != null && $val_rec["package_attempts"] != 0)
1008 {
1009 $new_rec = 0;
1010 //decrease attempt by 1
1011 if ((int)$val_rec["package_attempts"] > 0) $new_rec = (int)$val_rec["package_attempts"]-1;
1012 $ilDB->manipulateF('UPDATE sahs_user SET package_attempts = %s WHERE user_id = %s AND obj_id = %s',
1013 array('integer','integer','integer'),
1014 array($new_rec,$user,$this->getID()));
1015
1016 //following 2 lines were before 4.4 only for SCORM 1.2
1017 include_once("./Services/Tracking/classes/class.ilLPStatusWrapper.php");
1019 }
1020 }
1021 }
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
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 1304 of file class.ilObjSCORMLearningModule.php.
1305 {
1306 global $ilDB;
1307 include_once("./Services/Tracking/classes/class.ilChangeEvent.php");
1308 include_once("./Services/Tracking/classes/class.ilLPStatusWrapper.php");
1309
1311
1312 foreach($a_users as $user)
1313 {
1315 DELETE FROM scorm_tracking
1316 WHERE user_id = %s
1317 AND obj_id = %s',
1318 array('integer', 'integer'),
1319 array($user, $this->getID()));
1320
1322 DELETE FROM sahs_user
1323 WHERE user_id = %s
1324 AND obj_id = %s',
1325 array('integer', 'integer'),
1326 array($user, $this->getID()));
1327
1329 }
1330 }
static _deleteReadEventsForUsers($a_obj_id, array $a_user_ids)
Definition: class.ilChangeEvent.php:922
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 {
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 = "";
580 $query,
581 array('integer'),
582 array($this->getId())
583 );
588 . ";\"" . implode("\";\"",ilSCORMTrackingItems::userDataArrayForExport($data["user_id"], $allowExportPrivacy)) ."\""
590 . ";\"" . ilLearningProgressBaseGUI::__readStatus($data["obj_id"],$data["user_id"]) ."\"" //not $data["status"] because modifications to learning progress could have made before export
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
602 }
static __readStatus($a_obj_id, $user_id)
Definition: class.ilLearningProgressBaseGUI.php:550
sendExportFile($a_header, $a_content)
send export file to browser
Definition: class.ilObjSCORMLearningModule.php:1081
static userDataHeaderForExport()
Definition: class.ilSCORMTrackingItems.php:606
static userDataArrayForExport($user, $b_allowExportPrivacy=false)
Definition: class.ilSCORMTrackingItems.php:49
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 1025 of file class.ilObjSCORMLearningModule.php.
1025 {
1027
1029 array('text'),array($a_login));
1030 $val_rec = $ilDB->fetchAssoc($val_set);
1031
1032 if (count($val_rec)>0) {
1033 return $val_rec['usr_id'];
1034 } else {
1035 return null;
1036 }
1037 }
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 1185 of file class.ilObjSCORMLearningModule.php.
1185 {
1186 global $ilDB;
1187
1188 $scos = array();
1189 //get all SCO's of this object
1191 SELECT scorm_object.obj_id,
1192 scorm_object.title,
1193 scorm_object.c_type,
1194 scorm_object.slm_id,
1195 scorm_object.obj_id scoid
1196 FROM scorm_object, sc_item,sc_resource
1197 WHERE(scorm_object.slm_id = %s
1198 AND scorm_object.obj_id = sc_item.obj_id
1199 AND sc_item.identifierref = sc_resource.import_id
1200 AND sc_resource.scormtype = %s )
1201 GROUP BY scorm_object.obj_id,
1202 scorm_object.title,
1203 scorm_object.c_type,
1204 scorm_object.slm_id,
1205 scorm_object.obj_id',
1206 array('integer','text'),
1208
1210 {
1211 array_push($scos,$val_rec['scoid']);
1212 }
1213 return $scos;
1214 }
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') . ' ';
342
343 $attempts = array();
345 {
347 }
348 return $attempts;
349 }
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 1246 of file class.ilObjSCORMLearningModule.php.
1246 {
1248 }
getAllScoIds()
Definition: class.ilObjSCORMLearningModule.php:1185
getStatusForUser($a_user, $a_allScoIds, $a_numerical=false)
Definition: class.ilObjSCORMLearningModule.php:1216
References getAllScoIds(), and getStatusForUser().
Here is the call graph for this function:
◆ getLastVisited()
| ilObjSCORMLearningModule::getLastVisited | ( | $user_id | ) |
Definition at line 1290 of file class.ilObjSCORMLearningModule.php.
1291 {
1292 global $ilDB;
1293 $val_set = $ilDB->queryF('SELECT last_visited FROM sahs_user WHERE obj_id = %s AND user_id = %s',
1294 array('integer','integer'),
1295 array($this->getID(),$user_id)
1296 );
1298 {
1299 if ($val_rec["last_visited"] != null) return "".$val_rec["last_visited"];
1300 }
1301 return '0';
1302 }
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') . ' ';
379
380 $versions = array();
382 {
384 }
385 return $versions;
386 }
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 1216 of file class.ilObjSCORMLearningModule.php.
1216 {
1217 global $ilDB;
1218 $scos = $a_allScoIds;
1219 //loook up status
1220 //check if all SCO's are completed
1221 $scos_c = implode(',',$scos);
1222
1224 SELECT sco_id FROM scorm_tracking
1225 WHERE (user_id = %s
1226 AND obj_id = %s
1228 AND ((lvalue = %s AND '.$ilDB->like('rvalue', 'clob', 'completed').') OR (lvalue = %s AND '.$ilDB->like('rvalue', 'clob', 'passed').') ) )',
1229 array('integer','integer','text','text',),
1230 array($a_user,$this->getID(),'cmi.core.lesson_status','cmi.core.lesson_status'));
1232 {
1233 $key = array_search($val_rec['sco_id'], $scos);
1234 unset ($scos[$key]);
1235 }
1236 //check for completion
1237 if (count($scos) == 0) {
1238 $completion = ($a_numerical===true) ? true: $this->lng->txt("cont_complete");
1239 }
1240 if (count($scos) > 0) {
1241 $completion = ($a_numerical===true) ? false: $this->lng->txt("cont_incomplete");
1242 }
1243 return $completion;
1244 }
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 {
264
266 SELECT DISTINCT sco_id FROM scorm_tracking WHERE obj_id = %s',
268
269 $items = array();
271 {
272 include_once("./Modules/ScormAicc/classes/SCORM/class.ilSCORMItem.php");
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 {
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 ' .
314 'JOIN usr_data ud ON st.user_id = ud.usr_id ' .
316 if($a_search) {
317// $query .= ' AND (' . $ilDB->like('lastname', 'text', '%' . $a_search . '%') . ' OR ' . $ilDB->like('firstname', 'text', '%' . $a_search . '%') .')';
319 }
322
323 $items = array();
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
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();
449 {
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
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';
492 "score" => $score, "time" => $time, "status" => $status);
493
494 }
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
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();
512 {
513
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
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
552 "score" => $score, "time" => $time, "status" => $status);
553 }
554
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
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();
428 $data[] = $data_rec;
429 }
430
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 {
59 }
static _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 1065 of file class.ilObjSCORMLearningModule.php.
1066 {
1068
1070 array('text'),array($a_mail));
1071 $val_rec = $ilDB->fetchAssoc($val_set);
1072
1073
1074 return $val_rec["usr_id"];
1075 }
◆ 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:
◆ importRaw()
|
private |
Import raw data @global ilDB $ilDB @global ilObjUser $ilUser.
- Parameters
-
string $a_file
- Returns
- void
Definition at line 831 of file class.ilObjSCORMLearningModule.php.
832 {
835
836 $fhandle = fopen($a_file, "r");
837
838 $fields = fgetcsv($fhandle, pow(2, 16), ';');
839 $users = array();
840 $a_last_access = array();
841 $a_time = array();
842 $a_package_attempts = array();
843 $a_module_version = array();
844 while(($csv_rows = fgetcsv($fhandle, pow(2, 16), ";")) !== FALSE)
845 {
846 $data = array_combine($fields, $csv_rows);
849 }
851 {
853 }
855 {
857 }
858 if(!$user_id)
859 {
860 continue;
861 }
862
864 {
866 }
868 {
870 }
871 if(!$il_sco_id)
872 {
873 continue;
874 }
875
876 $c_timestamp="";
878 {
880 }
882 {
884 }
885 if ($c_timestamp == "")
886 {
887 $date = new DateTime();
888 $c_timestamp = $date->getTimestamp();
889 } else {
890 if($a_last_access[$user_id]) {
891 if ($a_last_access[$user_id] < $c_timestamp) $a_last_access[$user_id] = $c_timestamp;
892 } else {
893 $a_last_access[$user_id] = $c_timestamp;
894 }
895 }
896
898 {
899 continue;
900 }
902 {
904 }
905
908 $sec = (int) $tarr[2] + (int) $tarr[1] * 60 +
909 (int) substr($tarr[0], strlen($tarr[0]) - 3) * 60 * 60;
910 if ($a_time[$user_id]) $a_time[$user_id] += $sec;
911 else $a_time[$user_id] = $sec;
912 }
913 //do the actual import
914 if($il_sco_id > 0)
915 {
917 SELECT * FROM scorm_tracking
918 WHERE user_id = %s
919 AND sco_id = %s
920 AND lvalue = %s
921 AND obj_id = %s',
922 array('integer', 'integer', 'text', 'integer'),
924 );
926 {
928 array(
930 'c_timestamp' => array('timestamp', $c_timestamp)
931 ),
932 array(
933 'user_id' => array('integer', $user_id),
934 'sco_id' => array('integer', $il_sco_id),
937 )
938 );
939 }
940 else
941 {
942 $ilDB->insert('scorm_tracking', array(
944 'user_id' => array('integer', $user_id),
945 'sco_id' => array('integer', $il_sco_id),
949 ));
950 }
951 }
952 // $package_attempts = 1;
953 if($il_sco_id == 0)
954 {
956 // if ($data['Key'] == "module_version") $a_module_version[$user_id] = $data['Value'];
957 }
958 if (!in_array($user_id,$users)) $users[] = $user_id;
959 }
960 fclose($fhandle);
961
962 //UK determineStatus, percentage_completed and syncGlobalStatus
963 include_once './Services/Tracking/classes/class.ilLPStatusWrapper.php';
965
966 // include_once './Services/Tracking/classes/status/class.ilLPStatusSCORM.php';
967 include_once './Services/Tracking/classes/class.ilLPStatus.php';
968 foreach ($users as $user_id){
969 $attempts = 1;
970 if ($a_package_attempts[$user_id]) $attempts = $a_package_attempts[$user_id];
971 // $module_version = 1;
972 // if ($a_module_version[$user_id]) $module_version = $a_module_version[$user_id];
973 $sco_total_time_sec = null;
974 if ($a_time[$user_id]) $sco_total_time_sec = $a_time[$user_id];
975 $last_access = null;
976 if ($a_last_access[$user_id]) $last_access = $a_last_access[$user_id];
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
986 return 0;
987 }
static _refreshStatus($a_obj_id, $a_users=null)
Set dirty.
Definition: class.ilLPStatusWrapper.php:302
static _lookupStatus($a_obj_id, $a_user_id, $a_create=true)
Lookup status.
Definition: class.ilLPStatus.php:568
static _lookupPercentage($a_obj_id, $a_user_id)
Lookup percentage.
Definition: class.ilLPStatus.php:603
get_user_id($a_login)
Definition: class.ilObjSCORMLearningModule.php:1025
lookupSCOId($a_referrer)
resolves manifest SCOID to internal ILIAS SCO ID
Definition: class.ilObjSCORMLearningModule.php:1043
importSuccessForSahsUser($user_id, $last_access, $status, $attempts=null, $percentage_completed=null, $sco_total_time_sec=null)
Definition: class.ilObjSCORMLearningModule.php:759
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
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';
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
664 //add mail in future
666
667 if ($user_id>0) {
668
669 $last_access = ilUtil::now();
672 $last_access = implode('-', array($date_ex[2], $date_ex[1], $date_ex[0]));
673 }
676 }
677
678 $status = ilLPStatus::LP_STATUS_COMPLETED_NUM;
679
682 else if ($data["Status"] == "0" || $data["Status"] == "1" || $data["Status"] == "2" || $data["Status"] == "3") $status = (int) $data["Status"];
683 else if ($data["Status"] == ilLPStatus::LP_STATUS_NOT_ATTEMPTED) $status = ilLPStatus::LP_STATUS_NOT_ATTEMPTED_NUM;
684 else if ($data["Status"] == ilLPStatus::LP_STATUS_IN_PROGRESS) $status = ilLPStatus::LP_STATUS_IN_PROGRESS_NUM;
685 else if ($data["Status"] == ilLPStatus::LP_STATUS_FAILED) $status = ilLPStatus::LP_STATUS_FAILED_NUM;
686 }
687
688 $attempts = null;
690
691 $percentage_completed = 0;
694
695 $sco_total_time_sec = null;
697
699 $usersToDelete[] = $user_id;
700 } else {
701 $this->importSuccessForSahsUser($user_id, $last_access, $status, $attempts, $percentage_completed, $sco_total_time_sec);
702 $users[] = $user_id;
703 }
704
706 foreach ($scos as $sco_id)
707 {
709 SELECT * FROM scorm_tracking
710 WHERE user_id = %s
711 AND sco_id = %s
712 AND lvalue = %s
713 AND obj_id = %s',
714 array('integer','integer','text','integer'),
715 array($user_id, $sco_id, 'cmi.core.lesson_status',$obj_id)
716 );
718 {
720 array(
721 'rvalue' => array('clob', 'completed'),
722 'c_timestamp' => array('timestamp', $last_access)
723 ),
724 array(
725 'user_id' => array('integer', $user_id),
726 'sco_id' => array('integer', $sco_id),
727 'lvalue' => array('text', 'cmi.core.lesson_status'),
728 'obj_id' => array('integer', $obj_id)
729 )
730 );
731 }
732 else
733 {
735 'obj_id' => array('integer', $obj_id),
736 'user_id' => array('integer', $user_id),
737 'sco_id' => array('integer', $sco_id),
738 'lvalue' => array('text', 'cmi.core.lesson_status'),
739 'rvalue' => array('clob', 'completed'),
740 'c_timestamp' => array('timestamp', $last_access)
741 ));
742 }
743 }
744 }
745 } else {
746 //echo "Warning! User $csv_rows[0] does not exist in ILIAS. Data for this user was skipped.\n";
747 }
748 }
749 if (count($usersToDelete)>0) {
750 // include_once("./Services/Tracking/classes/class.ilLPMarks.php");
751 // ilLPMarks::_deleteForUsers($this->getId(), $usersToDelete);
752 $this->deleteTrackingDataOfUsers($usersToDelete);
753 }
754 include_once("./Services/Tracking/classes/class.ilLPStatusWrapper.php");
756 return 0;
757 }
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:1304
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 759 of file class.ilObjSCORMLearningModule.php.
759 {
760 global $ilDB;
762 array('integer','integer'),
763 array($this->getID(),$user_id)
764 );
766 {
768 array(
769 'last_access' => array('timestamp', $last_access),
770 'status' => array('integer', $status),
771 'package_attempts' => array('integer', $attempts),
772 'percentage_completed' => array('integer', $percentage_completed),
773 'sco_total_time_sec' => array('integer', $sco_total_time_sec)
774 ),
775 array(
776 'obj_id' => array('integer', $this->getID()),
777 'user_id' => array('integer', $user_id)
778 )
779 );
780 }
781 else
782 {
784 'obj_id' => array('integer', $this->getID()),
785 'user_id' => array('integer', $user_id),
786 'last_access' => array('timestamp', $last_access),
787 'status' => array('integer', $status),
788 'package_attempts' => array('integer', $attempts),
789 'percentage_completed' => array('integer', $percentage_completed),
790 'sco_total_time_sec' => array('integer', $sco_total_time_sec)
791 ));
792 }
793
794 include_once("./Services/Tracking/classes/class.ilChangeEvent.php");
795 ilChangeEvent::_recordReadEvent("sahs", (int)$_GET["ref_id"], $this->getID(), $user_id, false, $attempts, $sco_total_time_sec);
796 }
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:112
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 605 of file class.ilObjSCORMLearningModule.php.
606 {
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":
626 break;
627 case "Department":
628 case "LearningModuleId":
630 break;
631 default:
632 return -1;
633 break;
634 }
636 }
importRaw($a_file)
Import raw data @global ilDB $ilDB @global ilObjUser $ilUser.
Definition: class.ilObjSCORMLearningModule.php:831
importSuccess($a_file)
Definition: class.ilObjSCORMLearningModule.php:638
References $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 1043 of file class.ilObjSCORMLearningModule.php.
1043 {
1045
1046 //non specific SCO entries
1047 if ($a_referrer=="0") {
1048 return 0;
1049 }
1050
1052 SELECT obj_id FROM sc_item,scorm_tree
1053 WHERE (obj_id = child
1054 AND identifierref = %s
1055 AND slm_id = %s)',
1056 array('text','integer'), array($a_referrer,$this->getID()));
1057 $val_rec = $ilDB->fetchAssoc($val_set);
1058
1059 return $val_rec["obj_id"];
1060 }
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 803 of file class.ilObjSCORMLearningModule.php.
804 {
805 global $ilSetting;
806
807 $parts = explode('_', $il_id);
808
809 if(!count((array) $parts))
810 {
811 return 0;
812 }
813 if(!isset($parts[2]) or !isset($parts[3]))
814 {
815 return 0;
816 }
818 {
819 return 0;
820 }
821 return $parts[3];
822 }
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
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 {
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);
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
214 {
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...
225 $slmParser->startParsing();
226 return $slmParser->getPackageTitle();
227 }
getDataDirectory($mode="filesystem")
get data directory of lm
Definition: class.ilObjSAHSLearningModule.php:267
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, $start, 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 1081 of file class.ilObjSCORMLearningModule.php.
1082 {
1083 $timestamp = time();
1084 $refid = $this->getRefId();
1086 //Header
1087 header("Expires: 0");
1088 header("Cache-control: private");
1089 header("Cache-Control: must-revalidate, post-check=0, pre-check=0");
1090 header("Content-Description: File Transfer");
1091 header("Content-Type: application/octet-stream");
1092 header("Content-disposition: attachment; filename=$filename");
1093 echo $a_header.$a_content;
1094 exit;
1095 }
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
238 //condition 2
239 include_once("./Services/Tracking/classes/class.ilObjUserTracking.php");
241
242 //set Learning Progress to Automatic by Collection of SCORM Items
243 include_once("./Services/Tracking/classes/class.ilLPObjSettings.php");
246 $lm_set->insert();
247
248 //select all SCOs as relevant for Learning Progress
249 include_once("Services/Tracking/classes/collection/class.ilLPCollectionOfSCOs.php");
251 $scos = array();
252 foreach($collection->getPossibleItems() as $sco_id => $item)
253 {
254 $scos[] = $sco_id;
255 }
256 $collection->activateEntries($scos);
257 }
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
