ILIAS  trunk Revision v12.0_alpha-1227-g7ff6d300864
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 294 of file class.ilScormAiccDataSet.php.

294 : string
295 {
296 $manWriter = new ilXmlWriter();
297 $manWriter->xmlHeader();
298 foreach ($this->_archive['files'] as $key => $value) {
299 $manWriter->xmlElement($key, null, $value, true, true);
300 }
301
302 return $manWriter->xmlDumpMem(true);
303 }
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 310 of file class.ilScormAiccDataSet.php.

310 : string
311 {
312 $writer = new ilXmlWriter();
313
314 if (!$a_omit_header) {
315 $writer->xmlHeader();
316 }
317
318 $writer->appendXML("\n");
319 $writer->xmlStartTag('DataSet', array(
320 "InstallationId" => IL_INST_ID,
321 "InstallationUrl" => ILIAS_HTTP_PATH,
322 "TopEntity" => $a_entity
323 ));
324
325 $writer->appendXML("\n");
326
327 foreach ($this->data as $key => $value) {
328 $writer->xmlElement($this->getElementNameByDbColumn($key), null, $value, true, true);
329 $writer->appendXML("\n");
330 }
331
332 $writer->xmlEndTag("DataSet");
333
334 return $writer->xmlDumpMem(false);
335 }
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 264 of file class.ilScormAiccDataSet.php.

264 : string
265 {
266 if ($db_col_name === "title") {
267 return "Title";
268 }
269 if ($db_col_name === "description") {
270 return "Description";
271 }
272 return $this->element_db_mapping[$db_col_name];
273 }

◆ 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 'scormFile' => "content.zip"
190 ];
191
192 // build content zip file
193 if (isset($this->_archive['files']['scormFile'])) {
194 $lmDir = './' . ILIAS_WEB_DIR . "/" . CLIENT_ID . "/lm_data/lm_" . $id;
195 // Important: content zip should not contain a 'lm_x' directory
196 $DIC->legacyArchives()->zip(
197 $lmDir,
198 $exportArchiveDir . "/" . $this->_archive['files']['scormFile'],
199 false
200 );
201 }
202
203 // build property xml file
204 file_put_contents(
205 $exportArchiveDir . "/" . $this->_archive['files']['properties'],
206 $this->buildProperties($a_entity, $a_omit_header)
207 );
208
209 return $exportArchiveDir . '.zip';
210 }
$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 286 of file class.ilScormAiccDataSet.php.

286 : array
287 {
288 return ["5.1.0"];
289 }

◆ 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 218 of file class.ilScormAiccDataSet.php.

218 : array
219 {
220 if ($a_entity === "sahs") {
221 switch ($a_version) {
222 case "5.1.0":
223 $types = [];
224 foreach ($this->properties as $key => $value) {
225 $types[$key] = $value["db_type"];
226 }
227 return $types;
228 }
229 }
230 return [];
231 }

◆ getXmlNamespace()

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

Get xml namespace.

Reimplemented from ilDataSet.

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

278 : string
279 {
280 return "http://www.ilias.de/xml/Modules/ScormAicc/" . $a_entity;
281 }

◆ readData()

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

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

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

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: