ILIAS  trunk Revision v11.0_alpha-2638-g80c1d007f79
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 $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 ...> ... 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 ( )

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  foreach ($this->properties as $key => $value) {
75  $this->element_db_mapping [$value["db_col"]] = $key;
76  }
77  }

Member Function Documentation

◆ buildManifest()

ilScormAiccDataSet::buildManifest ( )
private
Returns
string

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

References null.

Referenced by getExtendedXmlRepresentation().

336  : string
337  {
338  $manWriter = new ilXmlWriter();
339  $manWriter->xmlHeader();
340  foreach ($this->_archive['files'] as $key => $value) {
341  $manWriter->xmlElement($key, null, $value, true, true);
342  }
343 
344  return $manWriter->xmlDumpMem(true);
345  }
while($session_entry=$r->fetchRow(ilDBConstants::FETCHMODE_ASSOC)) return null
+ Here is the caller graph for this function:

◆ buildProperties()

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

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

References getElementNameByDbColumn(), IL_INST_ID, and null.

Referenced by getExtendedXmlRepresentation().

352  : string
353  {
354  $writer = new ilXmlWriter();
355 
356  if (!$a_omit_header) {
357  $writer->xmlHeader();
358  }
359 
360  $writer->appendXML("\n");
361  $writer->xmlStartTag('DataSet', array(
362  "InstallationId" => IL_INST_ID,
363  "InstallationUrl" => ILIAS_HTTP_PATH,
364  "TopEntity" => $a_entity
365  ));
366 
367  $writer->appendXML("\n");
368 
369  foreach ($this->data as $key => $value) {
370  $writer->xmlElement($this->getElementNameByDbColumn($key), null, $value, true, true);
371  $writer->appendXML("\n");
372  }
373 
374  $writer->xmlEndTag("DataSet");
375 
376  return $writer->xmlDumpMem(false);
377  }
const IL_INST_ID
Definition: constants.php:40
while($session_entry=$r->fetchRow(ilDBConstants::FETCHMODE_ASSOC)) return null
getElementNameByDbColumn(string $db_col_name)
retrieve element name by database column name
+ Here is the call graph for this function:
+ Here is the caller graph for this function:

◆ getDependencies()

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

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

84  : array {
85  return [];
86  }

◆ getElementNameByDbColumn()

ilScormAiccDataSet::getElementNameByDbColumn ( string  $db_col_name)

retrieve element name by database column name

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

Referenced by buildProperties().

306  : string
307  {
308  if ($db_col_name === "title") {
309  return "Title";
310  }
311  if ($db_col_name === "description") {
312  return "Description";
313  }
314  return $this->element_db_mapping[$db_col_name];
315  }
+ Here is the caller graph for this function:

◆ getExtendedXmlRepresentation()

ilScormAiccDataSet::getExtendedXmlRepresentation ( 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 164 of file class.ilScormAiccDataSet.php.

References $GLOBALS, $id, ilExport\_getExportDirectory(), buildManifest(), buildProperties(), exit, getTypes(), ilFileUtils\getWebspaceDir(), IL_INST_ID, ILIAS\Repository\int(), readData(), and ilFileUtils\zip().

171  : string {
172  $GLOBALS['DIC']["ilLog"]->write(json_encode($this->getTypes("sahs", "5.1.0"), JSON_PRETTY_PRINT));
173 
174  $this->dircnt = 1;
175 
176  $this->readData($a_entity, $a_schema_version, $a_ids, $a_field = "");
177  $id = (int) $this->data["id"];
178  $exportDir = ilExport::_getExportDirectory((int) $id, "xml", "sahs");
179 
180  // prepare archive skeleton
181  $objTypeAndId = "sahs_" . $id;
182  $this->_archive['directories'] = [
183  "exportDir" => ilExport::_getExportDirectory($id)
184  ,"tempDir" => ilExport::_getExportDirectory($id) . "/temp"
185  ,"archiveDir" => time() . "__" . IL_INST_ID . "__" . $objTypeAndId
186  ,"moduleDir" => $objTypeAndId
187  ];
188 
189  $this->_archive['files'] = [
190  "properties" => "properties.xml",
191  "manifest" => 'manifest.xml',
192  'scormFile' => "content.zip"
193  ];
194 
195  // Prepare temp storage on the local filesystem
196  if (!file_exists($this->_archive['directories']['exportDir'])) {
197  mkdir($this->_archive['directories']['exportDir'], 0755, true);
198  //$DIC->filesystem()->storage()->createDir($this->_archive['directories']['tempDir']);
199  }
200  if (!file_exists($this->_archive['directories']['tempDir'])) {
201  mkdir($this->_archive['directories']['tempDir'], 0755, true);
202  }
203 
204  // build manifest xml file
205  file_put_contents(
206  $this->_archive['directories']['tempDir'] . "/" . $this->_archive['files']['manifest'],
207  $this->buildManifest()
208  );
209 
210  // build content zip file
211  if (isset($this->_archive['files']['scormFile'])) {
212  $lmDir = ilFileUtils::getWebspaceDir("filesystem") . "/lm_data/lm_" . $id;
213  ilFileUtils::zip($lmDir, $this->_archive['directories']['tempDir'] . "/" . $this->_archive['files']['scormFile'], true);
214  }
215 
216  // build property xml file
217  file_put_contents(
218  $this->_archive['directories']['tempDir'] . "/" . $this->_archive['files']['properties'],
219  $this->buildProperties($a_entity, $a_omit_header)
220  );
221 
222  // zip tempDir and append to export folder
223  $fileName = $this->_archive['directories']['exportDir'] . "/" . $this->_archive['directories']['archiveDir'] . ".zip";
224  $zArchive = new ZipArchive();
225  if ($zArchive->open($fileName, ZipArchive::CREATE) !== true) {
226  exit("cannot open <$fileName>\n");
227  }
228  $zArchive->addFile(
229  $this->_archive['directories']['tempDir'] . "/" . $this->_archive['files']['properties'],
230  $this->_archive['directories']['archiveDir'] . '/properties.xml'
231  );
232  $zArchive->addFile(
233  $this->_archive['directories']['tempDir'] . "/" . $this->_archive['files']['manifest'],
234  $this->_archive['directories']['archiveDir'] . '/' . "manifest.xml"
235  );
236  if (isset($this->_archive['files']['scormFile'])) {
237  $zArchive->addFile(
238  $this->_archive['directories']['tempDir'] . "/" . $this->_archive['files']['scormFile'],
239  $this->_archive['directories']['archiveDir'] . '/content.zip'
240  );
241  }
242  $zArchive->close();
243 
244  // unlink tempDir and its content
245  unlink($this->_archive['directories']['tempDir'] . "/manifest.xml");
246  unlink($this->_archive['directories']['tempDir'] . "/properties.xml");
247  if (isset($this->_archive['files']['scormFile']) && file_exists($this->_archive['directories']['tempDir'] . "/content.zip")) {
248  unlink($this->_archive['directories']['tempDir'] . "/content.zip");
249  }
250 
251  return $fileName;
252  }
static getWebspaceDir(string $mode="filesystem")
get webspace directory
const IL_INST_ID
Definition: constants.php:40
getTypes(string $a_entity, string $a_version)
Get field types for entity.
static _getExportDirectory(int $a_obj_id, string $a_type="xml", string $a_obj_type="", string $a_entity="")
Get export directory for an repository object
$GLOBALS["DIC"]
Definition: wac.php:53
exit
buildProperties($a_entity, bool $a_omit_header=false)
$id
plugin.php for ilComponentBuildPluginInfoObjectiveTest::testAddPlugins
Definition: plugin.php:23
static zip(string $a_dir, string $a_file, bool $compress_content=false)
readData(string $a_entity, string $a_version, array $a_ids, string $a_field="")
+ Here is the call graph for this function:

◆ getSupportedVersions()

ilScormAiccDataSet::getSupportedVersions ( )
Returns
string[]

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

328  : array
329  {
330  return ["5.1.0"];
331  }

◆ 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

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

Referenced by getExtendedXmlRepresentation().

260  : array
261  {
262  if ($a_entity === "sahs") {
263  switch ($a_version) {
264  case "5.1.0":
265  $types = [];
266  foreach ($this->properties as $key => $value) {
267  $types[$key] = $value["db_type"];
268  }
269  return $types;
270  }
271  }
272  return [];
273  }
+ Here is the caller graph for this function:

◆ getXmlNamespace()

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

Get xml namespace.

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

320  : string
321  {
322  return "http://www.ilias.de/xml/Modules/ScormAicc/" . $a_entity;
323  }

◆ readData()

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

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

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

Referenced by getExtendedXmlRepresentation().

275  : void
276  {
277  global $DIC;
278  $ilDB = $DIC->database();
279 
280  $obj_id = (int) $a_ids[0];
281  $columns = [];
282  foreach ($this->properties as $property) {
283  $columns[] = $property["db_col"];
284  }
285 
286  $query = "SELECT " . implode(",", $columns) . " FROM " . $this->db_table;
287  $query .= " WHERE id=" . $ilDB->quote($obj_id, "integer");
288  $result = $ilDB->query($query);
289  $this->data = [];
290  if ($dataset = $ilDB->fetchAssoc($result)) {
291  $this->data = $dataset;
292  }
293 
294  $query = "SELECT title,description FROM object_data";
295  $query .= " WHERE obj_id=" . $ilDB->quote($obj_id, "integer");
296  $result = $ilDB->query($query);
297  while ($dataset = $ilDB->fetchAssoc($result)) {
298  $this->data ["title"] = $dataset["title"];
299  $this->data ["description"] = $dataset["description"];
300  }
301  }
global $DIC
Definition: shib_login.php:26
+ Here is the call graph for this function:
+ Here is the caller graph for this function:

◆ writeData()

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

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

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

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

Referenced by readData().

◆ $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: