ILIAS  trunk Revision v11.0_alpha-3011-gc6b235a2e85
ilScormAiccDataSet Class Reference
+ Inheritance diagram for ilScormAiccDataSet:
+ Collaboration diagram for ilScormAiccDataSet:

Public Member Functions

 __construct ()
 
 writeData (string $a_entity, string $a_version, int $a_id, array $data)
 
 getExtendedXmlRepresentation (string $exportArchiveDir, string $a_entity, string $a_schema_version, array $a_ids, string $a_field="", bool $a_omit_header=false, bool $a_omit_types=false)
 own getXmlRepresentation function to embed zipfile in xml More...
 
 readData (string $a_entity, string $a_version, array $a_ids, string $a_field="")
 
 getElementNameByDbColumn (string $db_col_name)
 retrieve element name by database column name More...
 
 getSupportedVersions ()
 
- Public Member Functions inherited from ilDataSet
 __construct ()
 
 init (string $a_entity, string $a_schema_version)
 Init. More...
 
 getSupportedVersions ()
 
 readData (string $a_entity, string $a_version, array $a_ids)
 Read data from DB. More...
 
 initByExporter (ilXmlExporter $xml_exporter)
 
 setImportDirectory (string $a_val)
 
 getImportDirectory ()
 
 setDSPrefix (string $a_val)
 
 getDSPrefix ()
 
 getDSPrefixString ()
 
 getDirectDataFromQuery (string $a_query, bool $a_convert_to_leading_upper=true, bool $a_set=true)
 Get data from query.This is a standard procedure, all db field names are directly mapped to abstract fields. More...
 
 convertToLeadingUpper (string $a_str)
 Make xyz_abc a XyzAbc string. More...
 
 getXmlRepresentation (string $a_entity, string $a_schema_version, ?array $a_ids, string $a_field="", bool $a_omit_header=false, bool $a_omit_types=false)
 Get xml representation <dataset install_id="123" install_url="..."> <types entity="table_name" version="4.0.1"> <ftype name="field_1" type="text" > <ftype name="field_2" type="date" > <ftype name="field_3" type="integer" > </types> <types ...> ... </types> <set entity="table_name"> <rec> <field_1>content</field_1> <field_2>my_date</field_2> <field_3>my_number</field_3> </rec> ... </set> </dataset> More...
 
 addRecordsXml (ilXmlWriter $a_writer, array $a_prefixes, string $a_entity, string $a_schema_version, array $a_ids, ?string $a_field="")
 
 afterXmlRecordWriting (string $a_entity, string $a_version, array $a_set)
 
 getNamespaces (array &$namespaces, string $a_entity, string $a_schema_version)
 
 getXmlRecord (string $a_entity, string $a_version, array $a_set)
 Get xml record for version. More...
 
 getXmlTypes (string $a_entity, string $a_version)
 Get xml types. More...
 
 getXMLEntityName (string $a_entity, string $a_version)
 Get entity name for xml (may be overwritten) More...
 
 getXMLEntityTag (string $a_entity, string $a_schema_version)
 Get entity tag. More...
 
 setImport (ilSurveyImporter $a_val)
 
 getImport ()
 
 setCurrentInstallationId (string $a_val)
 
 getCurrentInstallationId ()
 
 importRecord (string $a_entity, array $a_types, array $a_rec, ilImportMapping $a_mapping, string $a_schema_version)
 Needs to be overwritten for import use case. More...
 
 getCollection (array $record, string $entity, string $schema_version, string $field, string $value)
 
 getContainerExportConfig (array $record, string $entity, string $schema_version, string $field, string $value)
 

Data Fields

array $properties
 
- Data Fields inherited from ilDataSet
const DATASET_NS = 'http://www.ilias.de/Services/DataSet/ds/4_3'
 
const DATASET_NS_PREFIX = 'ds'
 
const EXPORT_NO_INST_ID = 1
 
const EXPORT_ID_ILIAS_LOCAL = 2
 
const EXPORT_ID_ILIAS_LOCAL_INVALID = 3
 
const EXPORT_ID_ILIAS_REMOTE = 4
 
const EXPORT_ID_ILIAS_REMOTE_INVALID = 5
 
const EXPORT_ID = 6
 
const EXPORT_ID_INVALID = 7
 
int $dircnt = 0
 

Protected Member Functions

 getDependencies (string $a_entity, string $a_version, ?array $a_rec=null, ?array $a_ids=null)
 
 getTypes (string $a_entity, string $a_version)
 Get field types for entity. More...
 
 getXmlNamespace (string $a_entity, string $a_schema_version)
 Get xml namespace. More...
 
- Protected Member Functions inherited from ilDataSet
 getTypes (string $a_entity, string $a_version)
 Get (abstract) types for (abstract) field names. More...
 
 getXmlNamespace (string $a_entity, string $a_schema_version)
 
 getExportDirInContainer (string $exp_dir)
 
 getIRSSContainerExportConfig (StorableResource $source_container, string $source_path, string $target_path="")
 
 getDependencies (string $a_entity, string $a_version, ?array $a_rec=null, ?array $a_ids=null)
 
 createObjectExportId (string $a_type, string $a_id)
 Build ilias export id. More...
 
 parseObjectExportId (string $a_id, ?string $a_fallback_id=null)
 Parse export id. More...
 
 stripTags (array $rec, array $omit_keys=[])
 

Private Member Functions

 buildManifest ()
 
 buildProperties ($a_entity, bool $a_omit_header=false)
 

Private Attributes

string $db_table
 
array $_archive
 
array $element_db_mapping
 

Additional Inherited Members

- Protected Attributes inherited from ilDataSet
ILIAS ResourceStorage Services $irss
 
string $current_installation_id = ""
 
array $data = []
 
ilDBInterface $db
 
ilLogger $ds_log
 
string $import_directory = ""
 
string $entity = ""
 
string $schema_version = ""
 
string $component_export_dir = ""
 
string $ds_prefix = "ds"
 
string $version = ""
 
ilSurveyImporter $import
 
ilExport $export
 

Detailed Description

Definition at line 21 of file class.ilScormAiccDataSet.php.

Constructor & Destructor Documentation

◆ __construct()

ilScormAiccDataSet::__construct ( )

Reimplemented from ilDataSet.

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

29 {
30 $this->db_table = "sahs_lm";
31 $this->_archive = [];
32 $this->properties = [
33 "Id" => ["db_col" => "id", "db_type" => "integer"],
34 "APIAdapterName" => ["db_col" => "api_adapter", "db_type" => "text"],
35 "APIFunctionsPrefix" => ["db_col" => "api_func_prefix", "db_type" => "text"],
36 "AssignedGlossary" => ["db_col" => "glossary", "db_type" => "integer"],
37 "AutoContinue" => ["db_col" => "auto_continue", "db_type" => "text"],
38 "AutoReviewChar" => ["db_col" => "auto_review", "db_type" => "text"],
39 "AutoSuspend" => ["db_col" => "auto_suspend", "db_type" => "text"],
40 "Auto_last_visited" => ["db_col" => "auto_last_visited", "db_type" => "text"],
41 "Check_values" => ["db_col" => "check_values", "db_type" => "text"],
42 "Comments" => ["db_col" => "comments", "db_type" => "text"],
43 "CreditMode" => ["db_col" => "credit", "db_type" => "text"],
44 "Debug" => ["db_col" => "debug", "db_type" => "text"],
45 "DebugPw" => ["db_col" => "debugpw", "db_type" => "text"],
46 "DefaultLessonMode" => ["db_col" => "default_lesson_mode", "db_type" => "text"],
47 "Editable" => ["db_col" => "editable", "db_type" => "integer"],
48 "Fourth_edition" => ["db_col" => "fourth_edition", "db_type" => "text"],
49 "Height" => ["db_col" => "height", "db_type" => "integer"],
50 "HideNavig" => ["db_col" => "hide_navig", "db_type" => "text"],
51 "Ie_force_render" => ["db_col" => "ie_force_render", "db_type" => "text"],
52 "Interactions" => ["db_col" => "interactions", "db_type" => "text"],
53 "Localization" => ["db_col" => "localization", "db_type" => "text"],
54 "MasteryScore" => ["db_col" => "mastery_score", "db_type" => "integer"],
55 "MaxAttempt" => ["db_col" => "max_attempt", "db_type" => "integer"],
56 "ModuleVersion" => ["db_col" => "module_version", "db_type" => "integer"],
57 "NoMenu" => ["db_col" => "no_menu", "db_type" => "text"],
58 "Objectives" => ["db_col" => "objectives", "db_type" => "text"],
59 "OfflineMode" => ["db_col" => "offline_mode", "db_type" => "text"],
60 "OpenMode" => ["db_col" => "open_mode", "db_type" => "integer"],
61 "Sequencing" => ["db_col" => "sequencing", "db_type" => "text"],
62 "SequencingExpertMode" => ["db_col" => "seq_exp_mode", "db_type" => "integer"],
63 "Session" => ["db_col" => "unlimited_session", "db_type" => "text"],
64 "StyleSheetId" => ["db_col" => "stylesheet", "db_type" => "integer"],
65 "SubType" => ["db_col" => "c_type", "db_type" => "text"],
66 "Time_from_lms" => ["db_col" => "time_from_lms", "db_type" => "text"],
67 "Tries" => ["db_col" => "question_tries", "db_type" => "integer"],
68 "Width" => ["db_col" => "width", "db_type" => "integer"],
69 "IdSetting" => ["db_col" => "id_setting", "db_type" => "integer"],
70 "NameSetting" => ["db_col" => "name_setting", "db_type" => "integer"]
71 ];
72
73 $this->element_db_mapping = [];
74
76
77 foreach ($this->properties as $key => $value) {
78 $this->element_db_mapping [$value["db_col"]] = $key;
79 }
80 }
__construct(Container $dic, ilPlugin $plugin)
@inheritDoc

References ILIAS\GlobalScreen\Provider\__construct().

+ Here is the call graph for this function:

Member Function Documentation

◆ buildManifest()

ilScormAiccDataSet::buildManifest ( )
private
Returns
string

Definition at line 301 of file class.ilScormAiccDataSet.php.

301 : string
302 {
303 $manWriter = new ilXmlWriter();
304 $manWriter->xmlHeader();
305 foreach ($this->_archive['files'] as $key => $value) {
306 $manWriter->xmlElement($key, null, $value, true, true);
307 }
308
309 return $manWriter->xmlDumpMem(true);
310 }
This file is part of ILIAS, a powerful learning management system published by ILIAS open source e-Le...

◆ buildProperties()

ilScormAiccDataSet::buildProperties (   $a_entity,
bool  $a_omit_header = false 
)
private
Parameters
$a_entity
bool$a_omit_header
Returns
string

Definition at line 317 of file class.ilScormAiccDataSet.php.

317 : string
318 {
319 $writer = new ilXmlWriter();
320
321 if (!$a_omit_header) {
322 $writer->xmlHeader();
323 }
324
325 $writer->appendXML("\n");
326 $writer->xmlStartTag('DataSet', array(
327 "InstallationId" => IL_INST_ID,
328 "InstallationUrl" => ILIAS_HTTP_PATH,
329 "TopEntity" => $a_entity
330 ));
331
332 $writer->appendXML("\n");
333
334 foreach ($this->data as $key => $value) {
335 $writer->xmlElement($this->getElementNameByDbColumn($key), null, $value, true, true);
336 $writer->appendXML("\n");
337 }
338
339 $writer->xmlEndTag("DataSet");
340
341 return $writer->xmlDumpMem(false);
342 }
getElementNameByDbColumn(string $db_col_name)
retrieve element name by database column name
const IL_INST_ID
Definition: constants.php:40

References IL_INST_ID.

◆ getDependencies()

ilScormAiccDataSet::getDependencies ( string  $a_entity,
string  $a_version,
?array  $a_rec = null,
?array  $a_ids = null 
)
protected

Reimplemented from ilDataSet.

Definition at line 82 of file class.ilScormAiccDataSet.php.

87 : array {
88 return [];
89 }

◆ getElementNameByDbColumn()

ilScormAiccDataSet::getElementNameByDbColumn ( string  $db_col_name)

retrieve element name by database column name

Definition at line 271 of file class.ilScormAiccDataSet.php.

271 : string
272 {
273 if ($db_col_name === "title") {
274 return "Title";
275 }
276 if ($db_col_name === "description") {
277 return "Description";
278 }
279 return $this->element_db_mapping[$db_col_name];
280 }

◆ getExtendedXmlRepresentation()

ilScormAiccDataSet::getExtendedXmlRepresentation ( string  $exportArchiveDir,
string  $a_entity,
string  $a_schema_version,
array  $a_ids,
string  $a_field = "",
bool  $a_omit_header = false,
bool  $a_omit_types = false 
)

own getXmlRepresentation function to embed zipfile in xml

Definition at line 167 of file class.ilScormAiccDataSet.php.

175 : string {
176
177 global $DIC;
178 $ilLog = ilLoggerFactory::getLogger('sahs');
179
180 $ilLog->write(json_encode($this->getTypes("sahs", "5.1.0"), JSON_PRETTY_PRINT));
181
182 $this->dircnt = 1;
183
184 $this->readData($a_entity, $a_schema_version, $a_ids, $a_field = "");
185 $id = (int) $this->data["id"];
186
187 $this->_archive['files'] = [
188 "properties" => "properties.xml",
189 "manifest" => 'manifest.xml',
190 'scormFile' => "content.zip"
191 ];
192
193 // build manifest xml file
194 file_put_contents(
195 $exportArchiveDir . "/" . $this->_archive['files']['manifest'],
196 $this->buildManifest()
197 );
198
199 // build content zip file
200 if (isset($this->_archive['files']['scormFile'])) {
201 $lmDir = './' . ILIAS_WEB_DIR . "/" . CLIENT_ID . "/lm_data/lm_" . $id;
202 // Important: content zip should not contain a 'lm_x' directory
203 $DIC->legacyArchives()->zip(
204 $lmDir,
205 $exportArchiveDir . "/" . $this->_archive['files']['scormFile'],
206 false
207 );
208 }
209
210 // build property xml file
211 file_put_contents(
212 $exportArchiveDir . "/" . $this->_archive['files']['properties'],
213 $this->buildProperties($a_entity, $a_omit_header)
214 );
215
216 return $exportArchiveDir . '.zip';
217 }
$id
plugin.php for ilComponentBuildPluginInfoObjectiveTest::testAddPlugins
Definition: plugin.php:23
static getLogger(string $a_component_id)
Get component logger.
buildProperties($a_entity, bool $a_omit_header=false)
getTypes(string $a_entity, string $a_version)
Get field types for entity.
readData(string $a_entity, string $a_version, array $a_ids, string $a_field="")
const CLIENT_ID
Definition: constants.php:41
const ILIAS_WEB_DIR
Definition: constants.php:45
global $DIC
Definition: shib_login.php:26

◆ getSupportedVersions()

ilScormAiccDataSet::getSupportedVersions ( )
Returns
string[]

Reimplemented from ilDataSet.

Definition at line 293 of file class.ilScormAiccDataSet.php.

293 : array
294 {
295 return ["5.1.0"];
296 }

◆ getTypes()

ilScormAiccDataSet::getTypes ( string  $a_entity,
string  $a_version 
)
protected

Get field types for entity.

Parameters
string$a_entityentity
string$a_versionversion number
Returns
array types array

Reimplemented from ilDataSet.

Definition at line 225 of file class.ilScormAiccDataSet.php.

225 : array
226 {
227 if ($a_entity === "sahs") {
228 switch ($a_version) {
229 case "5.1.0":
230 $types = [];
231 foreach ($this->properties as $key => $value) {
232 $types[$key] = $value["db_type"];
233 }
234 return $types;
235 }
236 }
237 return [];
238 }

◆ getXmlNamespace()

ilScormAiccDataSet::getXmlNamespace ( string  $a_entity,
string  $a_schema_version 
)
protected

Get xml namespace.

Reimplemented from ilDataSet.

Definition at line 285 of file class.ilScormAiccDataSet.php.

285 : string
286 {
287 return "http://www.ilias.de/xml/Modules/ScormAicc/" . $a_entity;
288 }

◆ readData()

ilScormAiccDataSet::readData ( string  $a_entity,
string  $a_version,
array  $a_ids,
string  $a_field = "" 
)

Definition at line 240 of file class.ilScormAiccDataSet.php.

240 : void
241 {
242 global $DIC;
243 $ilDB = $DIC->database();
244
245 $obj_id = (int) $a_ids[0];
246 $columns = [];
247 foreach ($this->properties as $property) {
248 $columns[] = $property["db_col"];
249 }
250
251 $query = "SELECT " . implode(",", $columns) . " FROM " . $this->db_table;
252 $query .= " WHERE id=" . $ilDB->quote($obj_id, "integer");
253 $result = $ilDB->query($query);
254 $this->data = [];
255 if ($dataset = $ilDB->fetchAssoc($result)) {
256 $this->data = $dataset;
257 }
258
259 $query = "SELECT title,description FROM object_data";
260 $query .= " WHERE obj_id=" . $ilDB->quote($obj_id, "integer");
261 $result = $ilDB->query($query);
262 while ($dataset = $ilDB->fetchAssoc($result)) {
263 $this->data ["title"] = $dataset["title"];
264 $this->data ["description"] = $dataset["description"];
265 }
266 }

References $DIC, $ilDB, and ILIAS\Repository\int().

+ Here is the call graph for this function:

◆ writeData()

ilScormAiccDataSet::writeData ( string  $a_entity,
string  $a_version,
int  $a_id,
array  $data 
)

Definition at line 91 of file class.ilScormAiccDataSet.php.

91 : void
92 {
93 global $DIC;
94 $ilDB = $DIC->database();
95 $ilLog = ilLoggerFactory::getLogger('sahs');
96 if (count($data) > 0) {
97 $columns = [];
98 foreach ($this->properties as $key => $value) {
99 if ($key === "Id" || $key === "title" || $key === "description") {
100 continue;
101 }
102 //fix localization and mastery_score
103 if ($key === "MasteryScore" && isset($data[$key][0]) && $data[$key][0] == 0) {
104 continue;
105 }
106 if ($key === "Localization" && isset($data[$key][0]) && $data[$key][0] == "") {
107 continue;
108 }
109 //end fix
110 if ( isset( $data[ $key ] ) ) {
111 $data_value = '';
112 if ( is_array( $data[ $key ] ) ) {
113 $data_value = $data[ $key ][ 0 ] ?? '';
114 }
115 else {
116 $data_value = $data[ $key ];
117 }
118 $columns [ $value[ "db_col" ] ] = [
119 $value[ "db_type" ],
120 $data_value
121 ];
122 }
123 }
124 if (is_array($columns)) {
125 if (count($columns) > 0) {
126 $conditions ["id"] = ["integer", $a_id];
127 $ilDB->update($this->db_table, $columns, $conditions);
128 }
129 }
130
131 //setting title and description in table object_data
132 $od_table = "object_data";
133 $od_properties = [
134 "Title" => ["db_col" => "title", "db_type" => "text"],
135 "Description" => ["db_col" => "description", "db_type" => "text"]
136 ];
137 foreach ($od_properties as $key => $value) {
138 if ( isset( $data[ $key ] ) ) {
139 $data_value = '';
140 if ( is_array( $data[ $key ] ) ) {
141 $data_value = $data[ $key ][ 0 ] ?? '';
142 }
143 else {
144 $data_value = $data[ $key ];
145 }
146 $od_columns [ $value[ "db_col" ] ] = [
147 $value[ "db_type" ],
148 $data_value
149 ];
150 }
151
152 if (isset($od_columns) && is_array($od_columns)) {
153 if (count($od_columns) > 0) {
154 $od_conditions ["obj_id"] = ["integer", $a_id];
155 $ilDB->update("object_data", $od_columns, $od_conditions);
156 }
157 }
158 }
159 } else {
160 $ilLog->write("no module properties for imported object");
161 }
162 }

References $data, $DIC, $ilDB, and ilLoggerFactory\getLogger().

+ Here is the call graph for this function:

Field Documentation

◆ $_archive

array ilScormAiccDataSet::$_archive
private

Definition at line 25 of file class.ilScormAiccDataSet.php.

◆ $db_table

string ilScormAiccDataSet::$db_table
private

Definition at line 23 of file class.ilScormAiccDataSet.php.

◆ $element_db_mapping

array ilScormAiccDataSet::$element_db_mapping
private

Definition at line 26 of file class.ilScormAiccDataSet.php.

◆ $properties

array ilScormAiccDataSet::$properties

Definition at line 24 of file class.ilScormAiccDataSet.php.


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