ilObjSCORMLearningModule Class Reference
This file is part of ILIAS, a powerful learning management system published by ILIAS open source e-Learning e.V. More...
Inheritance diagram for ilObjSCORMLearningModule:
Collaboration diagram for ilObjSCORMLearningModule:
Public Member Functions | |
| __construct (int $a_id=0, bool $a_call_by_reference=true) | |
| Constructor. More... | |
| getTrackingItems () | |
| readObject () | |
| read manifest file More... | |
| setLearningProgressSettingsAtUpload () | |
| set settings for learning progress determination per default at upload More... | |
| getTrackedItems () | |
| get all tracked items of current user More... | |
| getTrackedUsers (string $a_search) | |
| getAttemptsForUsers () | |
| Get attempts for all users. More... | |
| getAttemptsForUser (int $a_user_id) | |
| get number of attempts for a certain user and package More... | |
| getModuleVersionForUsers () | |
| Get module version for users. More... | |
| getModuleVersionForUser (int $a_user_id) | |
| get module version that tracking data for a user was recorded on More... | |
| getTrackingDataPerUser (int $a_sco_id, int $a_user_id) | |
| Get tracking data per user. More... | |
| getTrackingDataAgg (int $a_user_id) | |
| getTrackingDataAggSco (int $a_sco_id) | |
| exportSelected (bool $a_all, array $a_users=array()) | |
| Export selected user tracking data @global ilObjUser $ilUser. More... | |
| importTrackingData (string $a_file) | |
| importSuccess (string $a_file) | |
| importSuccessForSahsUser (int $user_id, string $last_access, int $status, ?int $attempts=null, ?int $percentage_completed=null, ?int $sco_total_time_sec=null) | |
| get_user_id (string $a_login) | |
| getUserIdEmail (string $a_mail) | |
| assumes that only one account exists for a mailadress More... | |
| sendExportFile (string $a_header, string $a_content) | |
| send export file to browser More... | |
| getAllScoIds () | |
| getStatusForUser (int $a_user, array $a_allScoIds, bool $a_numerical=false) | |
| getCourseCompletionForUser (int $a_user) | |
| getLastVisited (int $user_id) | |
| deleteTrackingDataOfUsers (array $a_users) | |
| Public Member Functions inherited from ilObjSAHSLearningModule | |
| __construct (int $a_id=0, bool $a_call_by_reference=true) | |
| Constructor. More... | |
| create (bool $upload=false) | |
| create file based lm More... | |
| read () | |
| read object More... | |
| getEditable () | |
| setTries (int $a_tries) | |
| Set default tries for questions. More... | |
| getTries () | |
| setLocalization (string $a_val) | |
| getLocalization () | |
| 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 (?string $mode="filesystem") | |
| get data directory of lm More... | |
| getAPIAdapterName () | |
| get api adapter name More... | |
| setAPIAdapterName (string $a_api) | |
| set api adapter name More... | |
| getAPIFunctionsPrefix () | |
| get api functions prefix More... | |
| setAPIFunctionsPrefix (string $a_prefix) | |
| set api functions prefix More... | |
| getCreditMode () | |
| get credit mode More... | |
| setCreditMode (string $a_credit_mode) | |
| set credit mode More... | |
| setDefaultLessonMode (string $a_lesson_mode) | |
| set default lesson mode More... | |
| getDefaultLessonMode () | |
| get default lesson mode More... | |
| getStyleSheetId () | |
| get ID of assigned style sheet object More... | |
| setStyleSheetId (int $a_style_id) | |
| set ID of assigned style sheet object More... | |
| setAutoReview (bool $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 (?string $a_auto_review) | |
| set auto review as Char for SCORM 2004 More... | |
| getAutoReviewChar () | |
| get auto review as Char for SCORM 2004 More... | |
| getMaxAttempt () | |
| setMaxAttempt (int $a_max_attempt) | |
| getModuleVersion () | |
| getAssignedGlossary () | |
| setAssignedGlossary (int $a_assigned_glossary) | |
| setModuleVersion (int $a_module_version) | |
| getSession () | |
| setSession (bool $a_session) | |
| getNoMenu () | |
| disable menu More... | |
| setNoMenu (bool $a_no_menu) | |
| disable menu More... | |
| getHideNavig () | |
| hide navigation tree More... | |
| setHideNavig (bool $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 iframes or frames and IE >=10 More... | |
| setIe_force_render (bool $a_ie_force_render) | |
| getFourth_Edition () | |
| SCORM 2004 4th edition features. More... | |
| setFourth_edition (bool $a_fourth_edition) | |
| getSequencing () | |
| setSequencing (bool $a_sequencing) | |
| getInteractions () | |
| setInteractions (bool $a_interactions) | |
| getObjectives () | |
| setObjectives (bool $a_objectives) | |
| getComments () | |
| setComments (bool $a_comments) | |
| getTime_from_lms () | |
| setTime_from_lms (bool $a_time_from_lms) | |
| getCheck_values () | |
| setCheck_values (bool $a_check_values) | |
| getDebug () | |
| setDebug (bool $a_debug) | |
| setAutoContinue (bool $a_auto_continue) | |
| getAutoContinue () | |
| getAuto_last_visited () | |
| setAuto_last_visited (bool $a_auto_last_visited) | |
| setAutoSuspend (bool $a_auto_suspend) | |
| getAutoSuspend () | |
| 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 (int $a_open_mode) | |
| getWidth () | |
| setWidth (int $a_width) | |
| getHeight () | |
| setHeight (int $a_height) | |
| getMasteryScore () | |
| setMasteryScore (?int $a_mastery_score) | |
| checkMasteryScoreValues () | |
| check mastery_score / min_normalized_measure of SCOs (SCORM 1.2) / objectives (SCORM 2004) More... | |
| getMasteryScoreValues () | |
| getIdSetting () | |
| setIdSetting (int $a_id_setting) | |
| getNameSetting () | |
| setNameSetting (int $a_name_setting) | |
| update () | |
| setSubType (string $a_sub_type) | |
| getSubType () | |
| 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 (string $a_dir, string $a_filename="") | |
| Populate by directory. More... | |
| 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 (int $id=0, bool $reference=true) | |
| withReferences () | |
| determines whether objects are referenced or not (got ref ids or not) More... | |
| processAutoRating () | |
| read () | |
| getId () | |
| setId (int $id) | |
| setRefId (int $ref_id) | |
| getRefId () | |
| getType () | |
| setType (string $type) | |
| getPresentationTitle () | |
| get presentation title Normally same as title Overwritten for sessions More... | |
| getTitle () | |
| getUntranslatedTitle () | |
| Get untranslated object title WebDAV needs to access the untranslated title of an object. More... | |
| setTitle (string $title) | |
| getDescription () | |
| setDescription (string $desc) | |
| getLongDescription () | |
| get object long description (stored in object_description) More... | |
| getImportId () | |
| setImportId (string $import_id) | |
| setOfflineStatus (bool $status) | |
| getOfflineStatus () | |
| supportsOfflineHandling () | |
| getOwner () | |
| getOwnerName () | |
| get full name of object owner More... | |
| setOwner (int $usr_id) | |
| getCreateDate () | |
| Get create date in YYYY-MM-DD HH-MM-SS format. More... | |
| getLastUpdateDate () | |
| Get last update date in YYYY-MM-DD HH-MM-SS format. More... | |
| create () | |
| note: title, description and type should be set when this function is called More... | |
| update () | |
| MDUpdateListener (string $element) | |
| Metadata update listener. More... | |
| createMetaData () | |
| updateMetaData () | |
| deleteMetaData () | |
| updateOwner () | |
| update owner of object in db More... | |
| putInTree (int $parent_ref_id) | |
| maybe this method should be in tree object!? More... | |
| setPermissions (int $parent_ref_id) | |
| setParentRolePermissions (int $parent_ref_id) | |
| Initialize the permissions of parent roles (local roles of categories, global roles...) This method is overwritten in e.g. More... | |
| createReference () | |
| creates reference for object More... | |
| countReferences () | |
| 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. More... | |
| applyDidacticTemplate (int $tpl_id) | |
| getXMLZip () | |
| getHTMLDirectory () | |
| appendCopyInfo (int $target_id, int $copy_id) | |
| Prepend Copy info if object with same name exists in that container. More... | |
| cloneDependencies (int $target_id, int $copy_id) | |
| Clone object dependencies. More... | |
| cloneMetaData (ilObject $target_obj) | |
| Copy meta data. More... | |
| selfOrParentWithRatingEnabled () | |
| getPossibleSubObjects (bool $filter=true) | |
| get all possible sub objects of this type the object can decide which types of sub objects are possible jut in time overwrite if the decision distinguish from standard model More... | |
Static Public Member Functions | |
| static | _getTrackingItems (int $a_obj_id) |
| get all tracking items of scorm object More... | |
| static | _getAllScoIds (int $a_id) |
| Get an array of id's for all Sco's in the module. More... | |
| static | _getStatusForUser (int $a_id, int $a_user, array $a_allScoIds, bool $a_numerical=false) |
| Get the status of a SCORM module for a given user. More... | |
| static | _getCourseCompletionForUser (int $a_id, int $a_user) |
| Get the completion of a SCORM module for a given user. More... | |
| static | _removeTrackingDataForUser (int $user_id) |
| to be called from IlObjUser More... | |
| static | _getScoresForUser (int $a_item_id, int $a_user_id) |
| Static Public Member Functions inherited from ilObjSAHSLearningModule | |
| static | getAffectiveLocalization (int $a_id) |
| Get affective localization. More... | |
| static | _lookupSubType (int $a_obj_id) |
| lookup subtype id (scorm, ) More... | |
| static | _getTries (int $a_id) |
| obsolet? More... | |
| static | getScormModulesForGlossary (int $a_glo_id) |
| Get SCORM modules that assign a certain glossary. More... | |
| static | lookupAssignedGlossary (int $a_slm_id) |
| Get SCORM modules that assign a certain glossary. More... | |
| Static Public Member Functions inherited from ilObject | |
| static | _lookupObjIdByImportId (string $import_id) |
| Get (latest) object id for an import id. More... | |
| static | _lookupImportId (int $obj_id) |
| static | _lookupOwnerName (int $owner_id) |
| Lookup owner name for owner id. More... | |
| static | _getIdForImportId (string $import_id) |
| static | _getAllReferences (int $id) |
| get all reference ids for object ID More... | |
| static | _lookupTitle (int $obj_id) |
| static | lookupOfflineStatus (int $obj_id) |
| Lookup offline status using objectDataCache. More... | |
| static | _lookupOwner (int $obj_id) |
| Lookup owner user ID for object ID. More... | |
| static | _getIdsForTitle (string $title, string $type='', bool $partial_match=false) |
| static | _lookupDescription (int $obj_id) |
| static | _lookupLastUpdate (int $obj_id, bool $formatted=false) |
| static | _getLastUpdateOfObjects (array $obj_ids) |
| static | _lookupObjId (int $ref_id) |
| static | _setDeletedDate (int $ref_id, int $deleted_by) |
| static | setDeletedDates (array $ref_ids, int $user_id) |
| static | _resetDeletedDate (int $ref_id) |
| static | _lookupDeletedDate (int $ref_id) |
| static | _writeTitle (int $obj_id, string $title) |
| write title to db (static) More... | |
| static | _writeDescription (int $obj_id, string $desc) |
| write description to db (static) More... | |
| static | _writeImportId (int $obj_id, string $import_id) |
| write import id to db (static) More... | |
| static | _lookupType (int $id, bool $reference=false) |
| static | _isInTrash (int $ref_id) |
| static | _hasUntrashedReference (int $obj_id) |
| checks whether an object has at least one reference that is not in trash More... | |
| static | _lookupObjectId (int $ref_id) |
| static | _getObjectsDataForType (string $type, bool $omit_trash=false) |
| get all objects of a certain type More... | |
| static | _exists (int $id, bool $reference=false, ?string $type=null) |
| checks if an object exists in object_data More... | |
| static | _getObjectsByType (string $obj_type="", int $owner=null) |
| static | _prepareCloneSelection (array $ref_ids, string $new_type, bool $show_path=true) |
| Prepare copy wizard object selection. More... | |
| static | _getIcon (int $obj_id=0, string $size="big", string $type="", bool $offline=false) |
| Get icon for repository item. More... | |
| static | collectDeletionDependencies (array &$deps, int $ref_id, int $obj_id, string $type, int $depth=0) |
| Collect deletion dependencies. More... | |
| static | getDeletionDependencies (int $obj_id) |
| Get deletion dependencies. More... | |
| static | getLongDescriptions (array $obj_ids) |
| static | getAllOwnedRepositoryObjects (int $user_id) |
| static | fixMissingTitles ($type, array &$obj_title_map) |
| Try to fix missing object titles. More... | |
| static | _lookupCreationDate (int $obj_id) |
| static | _getObjectTypeIdByTitle (string $type, \ilDBInterface $ilDB=null) |
Private Member Functions | |
| parseUserId (string $il_id) | |
| Parse il_usr_123_6 id. More... | |
| importRaw (string $a_file) | |
| Import raw data. More... | |
| lookupSCOId (string $a_referrer) | |
| resolves manifest SCOID to internal ILIAS SCO ID More... | |
Detailed Description
This file is part of ILIAS, a powerful learning management system published by ILIAS open source e-Learning e.V.
ILIAS is licensed with the GPL-3.0, see https://www.gnu.org/licenses/gpl-3.0.en.html You should have received a copy of said license along with the source code, too.
If this is not the case or you just want to try ILIAS, you'll find us at: https://www.ilias.de https://github.com/ILIAS-eLearning Class ilObjSCORMLearningModule
Definition at line 29 of file class.ilObjSCORMLearningModule.php.
Constructor & Destructor Documentation
◆ __construct()
| ilObjSCORMLearningModule::__construct | ( | int | $a_id = 0, |
| bool | $a_call_by_reference = true |
||
| ) |
Constructor.
- 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 36 of file class.ilObjSCORMLearningModule.php.
37 {
38 $this->type = "sahs";
39 parent::__construct($a_id, $a_call_by_reference);
40 }
References ILIAS\GlobalScreen\Provider\__construct().
Here is the call graph for this function:
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 1043 of file class.ilObjSCORMLearningModule.php.
1043 : array
1044 {
1045 global $DIC;
1047
1048 $scos = array();
1049
1050 $val_set = $ilDB->queryF(
1051 '
1052 SELECT scorm_object.obj_id,
1053 scorm_object.title,
1054 scorm_object.c_type,
1055 scorm_object.slm_id,
1056 scorm_object.obj_id scoid
1057 FROM scorm_object,sc_item,sc_resource
1058 WHERE(scorm_object.slm_id = %s
1059 AND scorm_object.obj_id = sc_item.obj_id
1060 AND sc_item.identifierref = sc_resource.import_id
1061 AND sc_resource.scormtype = %s)
1062 GROUP BY scorm_object.obj_id,
1063 scorm_object.title,
1064 scorm_object.c_type,
1065 scorm_object.slm_id,
1066 scorm_object.obj_id ',
1067 array('integer', 'text'),
1068 array($a_id,'sco')
1069 );
1070
1072 $scos[] = $val_rec['scoid'];
1073 }
1074 return $scos;
1075 }
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
- string Completion status
Reimplemented in ilObjSCORM2004LearningModule.
Definition at line 1127 of file class.ilObjSCORMLearningModule.php.
1127 : bool
1128 {
1129 return ilObjSCORMLearningModule::_getStatusForUser($a_id, $a_user, ilObjSCORMLearningModule::_getAllScoIds($a_id), true);
1130 }
static _getStatusForUser(int $a_id, int $a_user, array $a_allScoIds, bool $a_numerical=false)
Get the status of a SCORM module for a given user.
Definition: class.ilObjSCORMLearningModule.php:1085
static _getAllScoIds(int $a_id)
Get an array of id's for all Sco's in the module.
Definition: class.ilObjSCORMLearningModule.php:1043
References _getAllScoIds(), and _getStatusForUser().
Here is the call graph for this function:
◆ _getScoresForUser()
|
static |
Definition at line 1227 of file class.ilObjSCORMLearningModule.php.
1227 : array
1228 {
1229 global $DIC;
1231
1232 $retAr = array("raw" => null, "max" => null, "scaled" => null);
1233 $val_set = $ilDB->queryF(
1234 "
1235 SELECT lvalue, rvalue FROM scorm_tracking
1236 WHERE sco_id = %s
1237 AND user_id = %s
1238 AND (lvalue = 'cmi.core.score.raw' OR lvalue = 'cmi.core.score.max')",
1239 array('integer', 'integer'),
1240 array($a_item_id, $a_user_id)
1241 );
1243 if ($val_rec['lvalue'] === "cmi.core.score.raw") {
1244 $retAr["raw"] = $val_rec["rvalue"];
1245 }
1246 if ($val_rec['lvalue'] === "cmi.core.score.max") {
1247 $retAr["max"] = $val_rec["rvalue"];
1248 }
1249 }
1250 if ($retAr["raw"] != null && $retAr["max"] != null) {
1251 $retAr["scaled"] = ($retAr["raw"] / $retAr["max"]);
1252 }
1253
1254 return $retAr;
1255 }
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
- bool Status result
Definition at line 1085 of file class.ilObjSCORMLearningModule.php.
1085 : bool
1086 {
1087 global $DIC;
1090
1091 $scos = $a_allScoIds;
1092 //check if all SCO's are completed
1093 $scos_c = implode(',', $scos);
1094
1095 $val_set = $ilDB->queryF(
1096 '
1097 SELECT * FROM scorm_tracking
1098 WHERE (user_id = %s
1099 AND obj_id = %s
1103 array('integer','integer','text','text'),
1104 array($a_user,$a_id,'cmi.core.lesson_status', 'cmi.core.lesson_status')
1105 );
1108 unset($scos[$key]);
1109 }
1110 $completion = false;
1111 //check for completion
1112 if (count($scos) == 0) {
1114 }
1115 if (count($scos) > 0) {
1117 }
1118 return $completion;
1119 }
txt(string $a_topic, string $a_default_lang_fallback_mod="")
gets the text for a given topic if the topic is not in the list, the topic itself with "-" will be re...
Definition: class.ilLanguage.php:172
References $DIC, $ilDB, ILIAS\LTI\ToolProvider\$key, and $lng.
Referenced by _getCourseCompletionForUser().
Here is the caller graph for this function:
◆ _getTrackingItems()
|
static |
get all tracking items of scorm object
Reimplemented in ilObjSCORM2004LearningModule.
Definition at line 50 of file class.ilObjSCORMLearningModule.php.
50 : array
51 {
54
55 $items = array();
57
58 foreach ($childs as $child) {
59 if ($child["c_type"] === "sit") {
61 if ($sc_item->getIdentifierRef() != "") {
62 $items[] = $sc_item;
63 }
64 }
65 }
66
67 return $items;
68 }
This file is part of ILIAS, a powerful learning management system published by ILIAS open source e-Le...
Definition: class.ilSCORMItem.php:30
This file is part of ILIAS, a powerful learning management system published by ILIAS open source e-Le...
Definition: class.ilSCORMTree.php:29
getNodeData(int $a_node_id, ?int $a_tree_pk=null)
get all information of a node.
Definition: class.ilTree.php:1094
getSubTree(array $a_node, bool $a_with_data=true, array $a_type=[])
get all nodes in the subtree under specified node
Definition: class.ilTree.php:744
References ilObject\$tree, ilTree\getNodeData(), ilTree\getSubTree(), and ilTree\readRootId().
Referenced by ilLPCollectionOfSCOs\getPossibleItems(), and getTrackingItems().
Here is the call graph for this function:
Here is the caller graph for this function:
◆ _removeTrackingDataForUser()
|
static |
to be called from IlObjUser
Definition at line 1210 of file class.ilObjSCORMLearningModule.php.
1210 : void
1211 {
1212 global $DIC;
1214 //gobjective
1215 $ilDB->manipulateF(
1216 'DELETE FROM scorm_tracking WHERE user_id = %s',
1217 array('integer'),
1218 array($user_id)
1219 );
1220 $ilDB->manipulateF(
1221 'DELETE FROM sahs_user WHERE user_id = %s',
1222 array('integer'),
1223 array($user_id)
1224 );
1225 }
Referenced by ilObjUser\delete().
Here is the caller graph for this function:
◆ deleteTrackingDataOfUsers()
| ilObjSCORMLearningModule::deleteTrackingDataOfUsers | ( | array | $a_users | ) |
Reimplemented in ilObjSCORM2004LearningModule.
Definition at line 1274 of file class.ilObjSCORMLearningModule.php.
1274 : void
1275 {
1276 global $DIC;
1278
1280
1281 foreach ($a_users as $usr) {
1283 $ilDB->manipulateF(
1284 '
1285 DELETE FROM scorm_tracking
1286 WHERE user_id = %s
1287 AND obj_id = %s',
1288 array('integer', 'integer'),
1289 array($user, $this->getID())
1290 );
1291
1292 $ilDB->manipulateF(
1293 '
1294 DELETE FROM sahs_user
1295 WHERE user_id = %s
1296 AND obj_id = %s',
1297 array('integer', 'integer'),
1298 array($user, $this->getID())
1299 );
1300
1302 }
1303 }
static _deleteReadEventsForUsers(int $a_obj_id, array $a_user_ids)
Definition: class.ilChangeEvent.php:873
static _updateStatus(int $a_obj_id, int $a_usr_id, ?object $a_obj=null, bool $a_percentage=false, bool $a_force_raise=false)
Definition: class.ilLPStatusWrapper.php:282
References $DIC, $ilDB, ilChangeEvent\_deleteReadEventsForUsers(), ilLPStatusWrapper\_updateStatus(), ILIAS\Survey\Mode\getId(), and ILIAS\Repository\int().
Referenced by importSuccess().
Here is the call graph for this function:
Here is the caller graph for this function:
◆ exportSelected()
| ilObjSCORMLearningModule::exportSelected | ( | bool | $a_all, |
| array | $a_users = array() |
||
| ) |
Export selected user tracking data @global ilObjUser $ilUser.
Definition at line 517 of file class.ilObjSCORMLearningModule.php.
517 : void
518 {
519 global $DIC;
522 $privacy = ilPrivacySettings::getInstance();
523 $allowExportPrivacy = $privacy->enabledExportSCORM();
524
525 $csv = "";
527 if (count($a_users) > 0) {
529 }
531 $query,
532 array('integer'),
533 array($this->getId())
534 );
539 . ";\"" . implode("\";\"", ilSCORMTrackingItems::userDataArrayForExport((int) $data["user_id"], $allowExportPrivacy)) . "\""
541 . ";\"" . ilLearningProgressBaseGUI::__readStatus((int) $data["obj_id"], (int) $data["user_id"]) . "\"" //not $data["status"] because modifications to learning progress could have made before export
545// . ";\"" . $certificateDate ."\""
546 . "\n";
547 }
548 $udh = ilSCORMTrackingItems::userDataHeaderForExport();
549 $header = "LearningModuleId;LearningModuleTitle;LearningModuleVersion;" . str_replace(',', ';', $udh["cols"]) . ";"
550 . "LastAccess;Status;Attempts;percentageCompletedSCOs;SumTotal_timeSeconds\n";
551
552 $this->sendExportFile($header, $csv);
553 }
static __readStatus(int $a_obj_id, int $user_id)
@noinspection PhpInconsistentReturnPointsInspection
Definition: class.ilLearningProgressBaseGUI.php:543
sendExportFile(string $a_header, string $a_content)
send export file to browser
Definition: class.ilObjSCORMLearningModule.php:1029
static userDataHeaderForExport()
Definition: class.ilSCORMTrackingItems.php:56
static userDataArrayForExport(int $user, bool $b_allowExportPrivacy=false)
Definition: class.ilSCORMTrackingItems.php:263
References $data, $DIC, $ilDB, $ilUser, $query, $res, ilLearningProgressBaseGUI\__readStatus(), ilObject\getId(), ilPrivacySettings\getInstance(), ilObject\getTitle(), sendExportFile(), ilSCORMTrackingItems\userDataArrayForExport(), and ilSCORMTrackingItems\userDataHeaderForExport().
Here is the call graph for this function:
◆ get_user_id()
| ilObjSCORMLearningModule::get_user_id | ( | string | $a_login | ) |
Definition at line 957 of file class.ilObjSCORMLearningModule.php.
957 : ?int
958 {
959 global $DIC;
962
963 $val_set = $ilDB->queryF(
964 'SELECT * FROM usr_data WHERE(login=%s)',
965 array('text'),
966 array($a_login)
967 );
968 $val_rec = $ilDB->fetchAssoc($val_set);
969
970 if (count($val_rec) > 0) {
971 return (int) $val_rec['usr_id'];
972 }
973
974 return null;
975 }
References $DIC, $ilDB, and $ilUser.
Referenced by ilObjSCORM2004LearningModule\importSuccess(), and importSuccess().
Here is the caller graph for this function:
◆ getAllScoIds()
| ilObjSCORMLearningModule::getAllScoIds | ( | ) |
- Returns
- array
Definition at line 1135 of file class.ilObjSCORMLearningModule.php.
1135 : array
1136 {
1137 global $DIC;
1139
1140 $scos = array();
1141 //get all SCO's of this object
1142 $val_set = $ilDB->queryF(
1143 '
1144 SELECT scorm_object.obj_id,
1145 scorm_object.title,
1146 scorm_object.c_type,
1147 scorm_object.slm_id,
1148 scorm_object.obj_id scoid
1149 FROM scorm_object, sc_item,sc_resource
1150 WHERE(scorm_object.slm_id = %s
1151 AND scorm_object.obj_id = sc_item.obj_id
1152 AND sc_item.identifierref = sc_resource.import_id
1153 AND sc_resource.scormtype = %s )
1154 GROUP BY scorm_object.obj_id,
1155 scorm_object.title,
1156 scorm_object.c_type,
1157 scorm_object.slm_id,
1158 scorm_object.obj_id',
1159 array('integer','text'),
1161 );
1162
1164 $scos[] = $val_rec['scoid'];
1165 }
1166 return $scos;
1167 }
References $DIC, $ilDB, and ILIAS\Survey\Mode\getId().
Here is the call graph for this function:
◆ getAttemptsForUser()
| ilObjSCORMLearningModule::getAttemptsForUser | ( | int | $a_user_id | ) |
get number of attempts for a certain user and package
Reimplemented in ilObjSCORM2004LearningModule.
Definition at line 308 of file class.ilObjSCORMLearningModule.php.
308 : int
309 {
310 global $DIC;
312 $val_set = $ilDB->queryF(
313 'SELECT package_attempts FROM sahs_user WHERE obj_id = %s AND user_id = %s',
314 array('integer','integer'),
315 array($this->getId(),$a_user_id)
316 );
317
318 $val_rec = $ilDB->fetchAssoc($val_set);
319
320 if ($val_rec["package_attempts"] == null) {
321 $val_rec["package_attempts"] = 0;
322 }
323 return (int) $val_rec["package_attempts"];
324 }
References $DIC, $ilDB, and ilObject\getId().
Here is the call graph for this function:
◆ getAttemptsForUsers()
| ilObjSCORMLearningModule::getAttemptsForUsers | ( | ) |
Get attempts for all users.
- Returns
- int[]
Definition at line 289 of file class.ilObjSCORMLearningModule.php.
289 : array
290 {
291 global $DIC;
293 $query = 'SELECT user_id, package_attempts FROM sahs_user WHERE obj_id = ' . $ilDB->quote($this->getId(), 'integer') . ' ';
295
296 $attempts = array();
299 }
300 return $attempts;
301 }
References $DIC, $ilDB, $query, $res, ilDBConstants\FETCHMODE_ASSOC, ilObject\getId(), and ILIAS\Repository\int().
Here is the call graph for this function:
◆ getCourseCompletionForUser()
| ilObjSCORMLearningModule::getCourseCompletionForUser | ( | int | $a_user | ) |
Definition at line 1202 of file class.ilObjSCORMLearningModule.php.
1202 : bool
1203 {
1205 }
getAllScoIds()
Definition: class.ilObjSCORMLearningModule.php:1135
getStatusForUser(int $a_user, array $a_allScoIds, bool $a_numerical=false)
Definition: class.ilObjSCORMLearningModule.php:1169
◆ getLastVisited()
| ilObjSCORMLearningModule::getLastVisited | ( | int | $user_id | ) |
Definition at line 1257 of file class.ilObjSCORMLearningModule.php.
1257 : string
1258 {
1259 global $DIC;
1261 $val_set = $ilDB->queryF(
1262 'SELECT last_visited FROM sahs_user WHERE obj_id = %s AND user_id = %s',
1263 array('integer','integer'),
1264 array($this->getID(),$user_id)
1265 );
1267 if ($val_rec["last_visited"] != null) {
1268 return "" . $val_rec["last_visited"];
1269 }
1270 }
1271 return '0';
1272 }
Referenced by ilObjSCORMInitData\getIliasScormVars().
Here is the caller graph for this function:
◆ getModuleVersionForUser()
| ilObjSCORMLearningModule::getModuleVersionForUser | ( | int | $a_user_id | ) |
get module version that tracking data for a user was recorded on
Reimplemented in ilObjSCORM2004LearningModule.
Definition at line 346 of file class.ilObjSCORMLearningModule.php.
346 : string
347 {
348 global $DIC;
350 $val_set = $ilDB->queryF(
351 'SELECT module_version FROM sahs_user WHERE obj_id = %s AND user_id = %s',
352 array('integer','integer'),
353 array($this->getId(),$a_user_id,0)
354 );
355
356 $val_rec = $ilDB->fetchAssoc($val_set);
357
358 if ($val_rec["module_version"] == null) {
359 $val_rec["module_version"] = "";
360 }
361 return $val_rec["module_version"];
362 }
References $DIC, $ilDB, and ilObject\getId().
Here is the call graph for this function:
◆ getModuleVersionForUsers()
| ilObjSCORMLearningModule::getModuleVersionForUsers | ( | ) |
Get module version for users.
Definition at line 329 of file class.ilObjSCORMLearningModule.php.
329 : array
330 {
331 global $DIC;
333 $query = 'SELECT user_id, module_version FROM sahs_user WHERE obj_id = ' . $ilDB->quote($this->getId(), 'integer') . ' ';
335
336 $versions = array();
339 }
340 return $versions;
341 }
References $DIC, $ilDB, $query, $res, ilDBConstants\FETCHMODE_ASSOC, ilObject\getId(), and ILIAS\Repository\int().
Here is the call graph for this function:
◆ getStatusForUser()
| ilObjSCORMLearningModule::getStatusForUser | ( | int | $a_user, |
| array | $a_allScoIds, | ||
| bool | $a_numerical = false |
||
| ) |
Definition at line 1169 of file class.ilObjSCORMLearningModule.php.
1169 : bool
1170 {
1171 global $DIC;
1173 $scos = $a_allScoIds;
1174 //loook up status
1175 //check if all SCO's are completed
1176 $scos_c = implode(',', $scos);
1177
1178 $val_set = $ilDB->queryF(
1179 '
1180 SELECT sco_id FROM scorm_tracking
1181 WHERE (user_id = %s
1182 AND obj_id = %s
1184 AND ((lvalue = %s AND ' . $ilDB->like('rvalue', 'clob', 'completed') . ') OR (lvalue = %s AND ' . $ilDB->like('rvalue', 'clob', 'passed') . ') ) )',
1185 array('integer','integer','text','text',),
1186 array($a_user,$this->getID(),'cmi.core.lesson_status','cmi.core.lesson_status')
1187 );
1190 unset($scos[$key]);
1191 }
1192 //check for completion
1193 if (count($scos) == 0) {
1195 }
1196 if (count($scos) > 0) {
1198 }
1199 return $completion;
1200 }
References $DIC, $ilDB, ILIAS\LTI\ToolProvider\$key, and ILIAS\Repository\lng().
Here is the call graph for this function:
◆ getTrackedItems()
| ilObjSCORMLearningModule::getTrackedItems | ( | ) |
get all tracked items of current user
Reimplemented in ilObjSCORM2004LearningModule.
Definition at line 207 of file class.ilObjSCORMLearningModule.php.
207 : array
208 {
209 global $DIC;
212
213 $sco_set = $ilDB->queryF(
214 '
215 SELECT DISTINCT sco_id FROM scorm_tracking WHERE obj_id = %s',
216 array('integer'),
217 array($this->getId())
218 );
219
220 $items = array();
223 if ($sc_item->getIdentifierRef() != "") {
224 $items[] = $sc_item;
225 }
226 }
227
228 return $items;
229 }
References $DIC, $ilDB, $ilUser, and ilObject\getId().
Here is the call graph for this function:
◆ getTrackedUsers()
| ilObjSCORMLearningModule::getTrackedUsers | ( | string | $a_search | ) |
Definition at line 259 of file class.ilObjSCORMLearningModule.php.
259 : array
260 {
261 global $DIC;
264 //TODO: UK last_access is not correct if no Commit or last_visited_sco
265 // $query = 'SELECT user_id,MAX(c_timestamp) last_access, lastname, firstname FROM scorm_tracking st ' .
267 'JOIN usr_data ud ON st.user_id = ud.usr_id ' .
269 if ($a_search) {
270 // $query .= ' AND (' . $ilDB->like('lastname', 'text', '%' . $a_search . '%') . ' OR ' . $ilDB->like('firstname', 'text', '%' . $a_search . '%') .')';
272 }
275
276 $items = array();
278 $items[] = $sco_rec;
279 }
280 return $items;
281 }
References $DIC, $ilDB, $ilUser, $query, and ilObject\getId().
Here is the call graph for this function:
◆ getTrackingDataAgg()
| ilObjSCORMLearningModule::getTrackingDataAgg | ( | int | $a_user_id | ) |
Definition at line 391 of file class.ilObjSCORMLearningModule.php.
391 : array
392 {
393 global $DIC;
395
396 // get all users with any tracking data
397 $sco_set = $ilDB->queryF(
398 '
399 SELECT DISTINCT sco_id FROM scorm_tracking
400 WHERE obj_id = %s
401 AND user_id = %s
402 AND sco_id <> %s',
403 array('integer','integer','integer'),
404 array($this->getId(),$a_user_id,0)
405 );
406
407 $data = array();
409 $data_set = $ilDB->queryF(
410 '
411 SELECT * FROM scorm_tracking
412 WHERE obj_id = %s
413 AND sco_id = %s
414 AND user_id = %s
415 AND lvalue <> %s
416 AND (lvalue = %s
417 OR lvalue = %s
418 OR lvalue = %s)',
419 array('integer','integer','integer','text','text','text','text'),
420 array($this->getId(),
421 $sco_rec["sco_id"],
422 $a_user_id,
423 "package_attempts",
424 "cmi.core.lesson_status",
425 "cmi.core.total_time",
426 "cmi.core.score.raw")
427 );
428
429 $score = $time = $status = "";
430
432 switch ($data_rec["lvalue"]) {
433 case "cmi.core.lesson_status":
434 $status = $data_rec["rvalue"];
435 break;
436
437 case "cmi.core.total_time":
438 $time = $data_rec["rvalue"];
439 break;
440
441 case "cmi.core.score.raw":
442 $score = $data_rec["rvalue"];
443 break;
444 }
445 }
448 "score" => $score, "time" => $time, "status" => $status);
449 }
451 }
References $data, $DIC, $ilDB, and ilObject\getId().
Here is the call graph for this function:
◆ getTrackingDataAggSco()
| ilObjSCORMLearningModule::getTrackingDataAggSco | ( | int | $a_sco_id | ) |
Definition at line 453 of file class.ilObjSCORMLearningModule.php.
453 : array
454 {
455 global $DIC;
457
458 // get all users with any tracking data
459 $user_set = $ilDB->queryF(
460 '
461 SELECT DISTINCT user_id FROM scorm_tracking
462 WHERE obj_id = %s
463 AND sco_id = %s',
464 array('integer','integer'),
465 array($this->getId(),$a_sco_id)
466 );
467
468 $data = array();
470 $data_set = $ilDB->queryF(
471 '
472 SELECT * FROM scorm_tracking
473 WHERE obj_id = %s
474 AND sco_id = %s
475 AND user_id = %s
476 AND (lvalue = %s
477 OR lvalue = %s
478 OR lvalue = %s)',
479 array('integer','integer','integer','text','text','text'),
480 array($this->getId(),
481 $a_sco_id,
482 $user_rec["user_id"],
483 "cmi.core.lesson_status",
484 "cmi.core.total_time",
485 "cmi.core.score.raw")
486 );
487
488 $score = $time = $status = "";
489
491 switch ($data_rec["lvalue"]) {
492 case "cmi.core.lesson_status":
493 $status = $data_rec["rvalue"];
494 break;
495
496 case "cmi.core.total_time":
497 $time = $data_rec["rvalue"];
498 break;
499
500 case "cmi.core.score.raw":
501 $score = $data_rec["rvalue"];
502 break;
503 }
504 }
505
507 "score" => $score, "time" => $time, "status" => $status);
508 }
509
511 }
References $data, $DIC, $ilDB, and ilObject\getId().
Here is the call graph for this function:
◆ getTrackingDataPerUser()
| ilObjSCORMLearningModule::getTrackingDataPerUser | ( | int | $a_sco_id, |
| int | $a_user_id | ||
| ) |
Get tracking data per user.
Definition at line 367 of file class.ilObjSCORMLearningModule.php.
367 : array
368 {
369 global $DIC;
371
372 $data_set = $ilDB->queryF(
373 '
374 SELECT * FROM scorm_tracking
375 WHERE user_id = %s
376 AND sco_id = %s
377 AND obj_id = %s
378 ORDER BY lvalue',
379 array('integer','integer','integer'),
380 array($a_user_id,$a_sco_id,$this->getId())
381 );
382
383 $data = array();
385 $data[] = $data_rec;
386 }
387
389 }
References $data, $DIC, $ilDB, and ilObject\getId().
Here is the call graph for this function:
◆ getTrackingItems()
| ilObjSCORMLearningModule::getTrackingItems | ( | ) |
Definition at line 42 of file class.ilObjSCORMLearningModule.php.
42 : array
43 {
45 }
static _getTrackingItems(int $a_obj_id)
get all tracking items of scorm object
Definition: class.ilObjSCORMLearningModule.php:50
References _getTrackingItems(), and ilObject\getId().
Here is the call graph for this function:
◆ getUserIdEmail()
| ilObjSCORMLearningModule::getUserIdEmail | ( | string | $a_mail | ) |
assumes that only one account exists for a mailadress
Definition at line 1008 of file class.ilObjSCORMLearningModule.php.
◆ importRaw()
|
private |
Import raw data.
Definition at line 798 of file class.ilObjSCORMLearningModule.php.
798 : bool
799 {
800 global $DIC;
805
806 $fhandle = fopen($a_file, "r");
807
808 $fields = fgetcsv($fhandle, 2 ** 16, ';');
809 $users = array();
810 $a_last_access = array();
811 $a_time = array();
812 $a_package_attempts = array();
813 $a_module_version = array();
814 while (($csv_rows = fgetcsv($fhandle, 2 ** 16, ";")) !== false) {
815 $data = array_combine($fields, $csv_rows);
821 }
822 }
825 }
826 if (!$user_id) {
827 continue;
828 }
829
832 }
835 }
836 if (!$il_sco_id) {
837 continue;
838 }
839
840 $c_timestamp = "";
843 }
846 }
847 if ($c_timestamp == "") {
848 $date = new DateTime();
849 $c_timestamp = $date->getTimestamp();
850 } else {
851 if ($a_last_access[$user_id]) {
852 if ($a_last_access[$user_id] < $c_timestamp) {
853 $a_last_access[$user_id] = $c_timestamp;
854 }
855 } else {
856 $a_last_access[$user_id] = $c_timestamp;
857 }
858 }
859
861 continue;
862 }
865 }
866
870 (int) substr($tarr[0], strlen($tarr[0]) - 3) * 60 * 60;
871 if ($a_time[$user_id]) {
872 $a_time[$user_id] += $sec;
873 } else {
874 $a_time[$user_id] = $sec;
875 }
876 }
877 //do the actual import
878 if ($il_sco_id > 0) {
879 $statement = $ilDB->queryF(
880 '
881 SELECT * FROM scorm_tracking
882 WHERE user_id = %s
883 AND sco_id = %s
884 AND lvalue = %s
885 AND obj_id = %s',
886 array('integer', 'integer', 'text', 'integer'),
888 );
890 $ilDB->update(
891 'scorm_tracking',
892 array(
894 'c_timestamp' => array('timestamp', $c_timestamp)
895 ),
896 array(
897 'user_id' => array('integer', $user_id),
898 'sco_id' => array('integer', $il_sco_id),
901 )
902 );
903 } else {
906 'user_id' => array('integer', $user_id),
907 'sco_id' => array('integer', $il_sco_id),
911 ));
912 }
913 }
914 // $package_attempts = 1;
915 if ($il_sco_id == 0) {
918 }
919 // if ($data['Key'] == "module_version") $a_module_version[$user_id] = $data['Value'];
920 }
921 if (!in_array($user_id, $users)) {
922 $users[] = $user_id;
923 }
924 }
925 fclose($fhandle);
927 foreach ($users as $user_id) {
928 $attempts = 1;
929 if ($a_package_attempts[$user_id]) {
930 $attempts = $a_package_attempts[$user_id];
931 }
932 // $module_version = 1;
933 // if ($a_module_version[$user_id]) $module_version = $a_module_version[$user_id];
934 $sco_total_time_sec = null;
935 if ($a_time[$user_id]) {
936 $sco_total_time_sec = $a_time[$user_id];
937 }
938 $last_access = null;
939 if ($a_last_access[$user_id]) {
940 $last_access = $a_last_access[$user_id];
941 }
942 // $status = ilLPStatusWrapper::_determineStatus($this->getId(),$user_id);
944 // $percentage_completed = ilLPStatusSCORM::determinePercentage($this->getId(),$user_id);
946
947 $this->importSuccessForSahsUser($user_id, $last_access, $status, $attempts, $percentage_completed, $sco_total_time_sec);
948 }
949
950 return true;
951 }
static _refreshStatus(int $a_obj_id, ?array $a_users=null)
Definition: class.ilLPStatusWrapper.php:307
static _lookupPercentage(int $a_obj_id, int $a_user_id)
Lookup percentage.
Definition: class.ilLPStatus.php:695
static _lookupStatus(int $a_obj_id, int $a_user_id, bool $a_create=true)
Lookup status.
Definition: class.ilLPStatus.php:660
importSuccessForSahsUser(int $user_id, string $last_access, int $status, ?int $attempts=null, ?int $percentage_completed=null, ?int $sco_total_time_sec=null)
Definition: class.ilObjSCORMLearningModule.php:724
lookupSCOId(string $a_referrer)
resolves manifest SCOID to internal ILIAS SCO ID
Definition: class.ilObjSCORMLearningModule.php:980
get_user_id(string $a_login)
Definition: class.ilObjSCORMLearningModule.php:957
References $data, $DIC, $ilDB, $ilUser, $lng, ilLPStatus\_lookupPercentage(), ilLPStatus\_lookupStatus(), ilLPStatusWrapper\_refreshStatus(), ILIAS\Survey\Mode\getId(), and ILIAS\Repository\int().
Referenced by importTrackingData().
Here is the call graph for this function:
Here is the caller graph for this function:
◆ importSuccess()
| ilObjSCORMLearningModule::importSuccess | ( | string | $a_file | ) |
Reimplemented in ilObjSCORM2004LearningModule.
Definition at line 588 of file class.ilObjSCORMLearningModule.php.
588 : bool
589 {
590 global $DIC;
593 $scos = array();
595 $collection = $olp->getCollectionInstance();
596 if ($collection) {
597 $scos = $collection->getItems();
598 }
599
600 $fhandle = fopen($a_file, "r");
601
602 $obj_id = $this->getID();
603 $fields = fgetcsv($fhandle, 2 ** 16, ';');
604 $users = array();
605 $usersToDelete = array();
606 while (($csv_rows = fgetcsv($fhandle, 2 ** 16, ";")) !== false) {
607 $user_id = 0;
608 $data = array_combine($fields, $csv_rows);
609 //no check the format - sufficient to import users
612 }
615 }
616 //add mail in future
619 }
620
621 if ($user_id > 0) {
622 $last_access = ilUtil::now();
625 $last_access = implode('-', array($date_ex[2], $date_ex[1], $date_ex[0]));
626 }
629 }
630
631 $status = ilLPStatus::LP_STATUS_COMPLETED_NUM;
632
636 } elseif ($data["Status"] == "0" || $data["Status"] == "1" || $data["Status"] == "2" || $data["Status"] == "3") {
639 $status = ilLPStatus::LP_STATUS_NOT_ATTEMPTED_NUM;
641 $status = ilLPStatus::LP_STATUS_IN_PROGRESS_NUM;
643 $status = ilLPStatus::LP_STATUS_FAILED_NUM;
644 }
645 }
646
647 $attempts = null;
650 }
651
652 $percentage_completed = 0;
654 $percentage_completed = 100;
655 }
658 }
659
660 $sco_total_time_sec = null;
663 }
664
666 $usersToDelete[] = $user_id;
667 } else {
668 $this->importSuccessForSahsUser($user_id, $last_access, $status, $attempts, $percentage_completed, $sco_total_time_sec);
669 $users[] = $user_id;
670 }
671
673 foreach ($scos as $sco_id) {
674 $statement = $ilDB->queryF(
675 '
676 SELECT * FROM scorm_tracking
677 WHERE user_id = %s
678 AND sco_id = %s
679 AND lvalue = %s
680 AND obj_id = %s',
681 array('integer','integer','text','integer'),
682 array($user_id, $sco_id, 'cmi.core.lesson_status',$obj_id)
683 );
685 $ilDB->update(
686 'scorm_tracking',
687 array(
688 'rvalue' => array('clob', 'completed'),
689 'c_timestamp' => array('timestamp', $last_access)
690 ),
691 array(
692 'user_id' => array('integer', $user_id),
693 'sco_id' => array('integer', $sco_id),
694 'lvalue' => array('text', 'cmi.core.lesson_status'),
695 'obj_id' => array('integer', $obj_id)
696 )
697 );
698 } else {
700 'obj_id' => array('integer', $obj_id),
701 'user_id' => array('integer', $user_id),
702 'sco_id' => array('integer', $sco_id),
703 'lvalue' => array('text', 'cmi.core.lesson_status'),
704 'rvalue' => array('clob', 'completed'),
705 'c_timestamp' => array('timestamp', $last_access)
706 ));
707 }
708 }
709 }
710 } else {
711 //echo "Warning! User $csv_rows[0] does not exist in ILIAS. Data for this user was skipped.\n";
712 }
713 }
714
715 if (count($usersToDelete) > 0) {
716 // include_once("./Services/Tracking/classes/class.ilLPMarks.php");
717 // ilLPMarks::_deleteForUsers($this->getId(), $usersToDelete);
718 $this->deleteTrackingDataOfUsers($usersToDelete);
719 }
721 return true;
722 }
const LP_STATUS_IN_PROGRESS_NUM
Definition: class.ilLPStatus.php:43
const LP_STATUS_NOT_ATTEMPTED_NUM
Definition: class.ilLPStatus.php:42
deleteTrackingDataOfUsers(array $a_users)
Definition: class.ilObjSCORMLearningModule.php:1274
References $data, $DIC, $ilDB, $ilUser, ilLPStatusWrapper\_refreshStatus(), deleteTrackingDataOfUsers(), get_user_id(), ilObject\getId(), ilObjectLP\getInstance(), importSuccessForSahsUser(), ILIAS\Repository\int(), 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 | ( | int | $user_id, |
| string | $last_access, | ||
| int | $status, | ||
| ?int | $attempts = null, |
||
| ?int | $percentage_completed = null, |
||
| ?int | $sco_total_time_sec = null |
||
| ) |
Definition at line 724 of file class.ilObjSCORMLearningModule.php.
731 : void {
732 global $DIC;
734 $statement = $ilDB->queryF(
735 'SELECT * FROM sahs_user WHERE obj_id = %s AND user_id = %s',
736 array('integer','integer'),
737 array($this->getID(),$user_id)
738 );
740 $ilDB->update(
741 'sahs_user',
742 array(
743 'last_access' => array('timestamp', $last_access),
744 'status' => array('integer', $status),
745 'package_attempts' => array('integer', $attempts),
746 'percentage_completed' => array('integer', $percentage_completed),
747 'sco_total_time_sec' => array('integer', $sco_total_time_sec)
748 ),
749 array(
750 'obj_id' => array('integer', $this->getID()),
751 'user_id' => array('integer', $user_id)
752 )
753 );
754 } else {
756 'obj_id' => array('integer', $this->getID()),
757 'user_id' => array('integer', $user_id),
758 'last_access' => array('timestamp', $last_access),
759 'status' => array('integer', $status),
760 'package_attempts' => array('integer', $attempts),
761 'percentage_completed' => array('integer', $percentage_completed),
762 'sco_total_time_sec' => array('integer', $sco_total_time_sec)
763 ));
764 }
765 // since 8 necessary because attempts can be null
767 ilChangeEvent::_recordReadEvent("sahs", $DIC->http()->wrapper()->query()->retrieve('ref_id', $DIC->refinery()->kindlyTo()->int()), $this->getID(), $user_id, false);
768 }
769
770 ilChangeEvent::_recordReadEvent("sahs", $DIC->http()->wrapper()->query()->retrieve('ref_id', $DIC->refinery()->kindlyTo()->int()), $this->getID(), $user_id, false, $attempts, $sco_total_time_sec);
771 }
static _recordReadEvent(string $a_type, int $a_ref_id, int $obj_id, int $usr_id, bool $isCatchupWriteEvents=true, $a_ext_rc=null, $a_ext_time=null)
Definition: class.ilChangeEvent.php:103
static _lookupReadEvents($obj_id, $usr_id=null)
Reads all read events which occured on the object.
Definition: class.ilChangeEvent.php:678
References $ilDB.
Referenced by ilObjSCORM2004LearningModule\importSuccess(), and importSuccess().
Here is the caller graph for this function:
◆ importTrackingData()
| ilObjSCORMLearningModule::importTrackingData | ( | string | $a_file | ) |
Definition at line 555 of file class.ilObjSCORMLearningModule.php.
555 : bool
556 {
557 global $DIC;
560
561 $success = false;
562 //echo file_get_contents($a_file);
563 $method = null;
564
565 //lets import
566 $fhandle = fopen($a_file, "r");
567
568 //the top line is the field names
569 $fields = fgetcsv($fhandle, 2 ** 16, ';');
570 //lets check the import method
571 fclose($fhandle);
572
573 switch ($fields[0]) {
574 case "Scoid":
575 case "SCO-Identifier":
576 $success = $this->importRaw($a_file);
577 break;
578 case "Department":
579 case "LearningModuleId":
580 $success = $this->importSuccess($a_file);
581 break;
582 default:
583 return false;
584 }
585 return $success;
586 }
importSuccess(string $a_file)
Definition: class.ilObjSCORMLearningModule.php:588
References $DIC, $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 980 of file class.ilObjSCORMLearningModule.php.
980 : int
981 {
982 global $DIC;
985
986 //non specific SCO entries
987 if ($a_referrer == "0") {
988 return 0;
989 }
990
991 $val_set = $ilDB->queryF(
992 '
993 SELECT obj_id FROM sc_item,scorm_tree
994 WHERE (obj_id = child
995 AND identifierref = %s
996 AND slm_id = %s)',
997 array('text','integer'),
998 array($a_referrer,$this->getID())
999 );
1000 $val_rec = $ilDB->fetchAssoc($val_set);
1001
1002 return (int) $val_rec["obj_id"];
1003 }
◆ parseUserId()
|
private |
Parse il_usr_123_6 id.
Definition at line 776 of file class.ilObjSCORMLearningModule.php.
776 : int
777 {
778 global $DIC;
780
782
784 return 0;
785 }
787 return 0;
788 }
790 return 0;
791 }
793 }
if($clientAssertionType !='urn:ietf:params:oauth:client-assertion-type:jwt-bearer'|| $grantType !='client_credentials') $parts
Definition: ltitoken.php:64
References $DIC, $ilSetting, and $parts.
◆ readObject()
| ilObjSCORMLearningModule::readObject | ( | ) |
read manifest file
- Exceptions
-
ilSaxParserException
Reimplemented in ilObjSCORM2004LearningModule.
Definition at line 74 of file class.ilObjSCORMLearningModule.php.
74 : string
75 {
76 global $DIC;
78
79 $needs_convert = false;
80
81 // convert imsmanifest.xml file in iso to utf8 if needed
82
84
85 // check if manifestfile exists and space left on device...
86 $check_for_manifest_file = is_file($manifest_file);
87
88 // if no manifestfile
89 if (!$check_for_manifest_file) {
91 return "";
92 }
93
94 if ($check_for_manifest_file) {
95 $manifest_file_array = file($manifest_file);
96 foreach ($manifest_file_array as $mfa) {
97 // if (seems_not_utf8($mfa))
98 if (@iconv('UTF-8', 'UTF-8', $mfa) != $mfa) {
99 $needs_convert = true;
100 break;
101 }
102 }
103
104 // to copy the file we need some extraspace, counted in bytes *2 ... we need 2 copies....
105 $estimated_manifest_filesize = filesize($manifest_file) * 2;
106
107 // i deactivated this, because it seems to fail on some windows systems (see bug #1795)
108 //$check_disc_free = disk_free_space($this->getDataDirectory()) - $estimated_manifest_filesize;
109 $check_disc_free = 2;
110 }
111
112 // if $manifest_file needs to be converted to UTF8
113 if ($needs_convert) {
114 // if file exists and enough space left on device
115 if ($check_for_manifest_file && ($check_disc_free > 1)) {
116
117 // create backup from original
118 if (!copy($manifest_file, $manifest_file . ".old")) {
119 echo "Failed to copy $manifest_file...<br>\n";
120 }
121
122 // read backupfile, convert each line to utf8, write line to new file
123 // php < 4.3 style
124 $f_write_handler = fopen($manifest_file . ".new", "w");
125 $f_read_handler = fopen($manifest_file . ".old", "r");
126 while (!feof($f_read_handler)) {
127 $zeile = fgets($f_read_handler);
128 //echo mb_detect_encoding($zeile);
129 fwrite($f_write_handler, utf8_encode($zeile));
130 }
131 fclose($f_read_handler);
132 fclose($f_write_handler);
133
134 // copy new utf8-file to imsmanifest.xml
135 if (!copy($manifest_file . ".new", $manifest_file)) {
136 echo "Failed to copy $manifest_file...<br>\n";
137 }
138
139 if (!@is_file($manifest_file)) {
141 }
142 } else {
143 // gives out the specific error
144
145 if (!($check_disc_free > 1)) {
147 }
148 return "";
149 }
150 } else {
151 // check whether file starts with BOM (that confuses some sax parsers, see bug #1795)
152 $hmani = fopen($manifest_file, "r");
153 $start = fread($hmani, 3);
154 if (strtolower(bin2hex($start)) === "efbbbf") {
155 $f_write_handler = fopen($manifest_file . ".new", "w");
156 while (!feof($hmani)) {
157 $n = fread($hmani, 900);
158 fwrite($f_write_handler, $n);
159 }
160 fclose($f_write_handler);
161 fclose($hmani);
162
163 // copy new utf8-file to imsmanifest.xml
164 if (!copy($manifest_file . ".new", $manifest_file)) {
165 echo "Failed to copy $manifest_file...<br>\n";
166 }
167 } else {
168 fclose($hmani);
169 }
170 }
171
172 // todo determine imsmanifest.xml path here...
174 $slmParser->startParsing();
175 return (string) $slmParser->getPackageTitle();
176 }
getDataDirectory(?string $mode="filesystem")
get data directory of lm
Definition: class.ilObjSAHSLearningModule.php:296
This file is part of ILIAS, a powerful learning management system published by ILIAS open source e-Le...
Definition: class.ilSCORMPackageParser.php:29
References $DIC, $ilErr, ilObjSAHSLearningModule\getDataDirectory(), and ILIAS\Repository\lng().
Here is the call graph for this function:
◆ sendExportFile()
| ilObjSCORMLearningModule::sendExportFile | ( | string | $a_header, |
| string | $a_content | ||
| ) |
send export file to browser
Definition at line 1029 of file class.ilObjSCORMLearningModule.php.
1029 : void
1030 {
1031 $timestamp = time();
1032 $refid = $this->getRefId();
1035 exit;
1036 }
static deliverData(string $a_data, string $a_filename, string $mime="application/octet-stream")
Definition: class.ilUtil.php:362
References $filename, $timestamp, ilUtil\deliverData(), and exit.
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 181 of file class.ilObjSCORMLearningModule.php.
181 : void
182 {
183 global $DIC;
185 //condition 1
188 return;
189 }
191 return;
192 }
195 $lm_set->insert();
197 $scos = array();
198 foreach ($collection->getPossibleItems() as $sco_id => $item) {
199 $scos[] = $sco_id;
200 }
201 $collection->activateEntries($scos);
202 }
Definition: class.ilLPObjSettings.php:27
static _enabledLearningProgress()
Definition: class.ilObjUserTracking.php:58
This file is part of ILIAS, a powerful learning management system published by ILIAS open source e-Le...
Definition: class.ilSetting.php:27
References $DIC, $ilSetting, $lm_set, ilObjUserTracking\_enabledLearningProgress(), ilObject\getId(), and ilLPObjSettings\LP_MODE_SCORM.
Here is the call graph for this function:
The documentation for this class was generated from the following file:
- Modules/ScormAicc/classes/class.ilObjSCORMLearningModule.php
