ILIAS  Release_4_0_x_branch Revision 61816
 All Data Structures Namespaces Files Functions Variables Groups Pages
Public Member Functions | Data Fields | Private Member Functions | Private Attributes | Static Private Attributes
ilSCORM13Package Class Reference
+ Collaboration diagram for ilSCORM13Package:

Public Member Functions

 __construct ($packageId=null)
 load ($packageId)
 rollback ()
 exportZIP ()
 exportXML ()
 Export as internal XML.
 il_import ($packageFolder, $packageId, $ilias, $validate, $reimport=false)
 Imports an extracted SCORM 2004 module from ilias-data dir into database.
 il_importSco ($packageId, $sco_id, $packageFolder)
 Imports an extracted SCORM 2004 module from ilias-data dir into database.
 il_importLM ($slm, $packageFolder)
 dbImportLM ($node, $parent_id)
 jsonNode ($node, &$sink)
 Helper for UploadAndImport Recursively copies values from XML into PHP array for export as json Elements are translated into sub array, attributes into literals.
 dbImportSco ($slm, $sco)
 dbImport ($node, &$lft=1, $depth=1, $parent=0)
 dbAddNew ()
 add new sahs and package record
 removeCMIData ()
 removeCPData ()
 dbRemoveAll ()
 transform ($inputdoc, $xslfile, $outputpath=null)
 validate ($doc, $schema)

Data Fields

const DB_ENCODE_XSL = './Modules/Scorm2004/templates/xsl/op/op-scorm13.xsl'
const CONVERT_XSL = './Modules/Scorm2004/templates/xsl/op/scorm12To2004.xsl'
const DB_DECODE_XSL = './Modules/Scorm2004/templates/xsl/op/op-scorm13-revert.xsl'
const VALIDATE_XSD = './Modules/Scorm2004/templates/xsd/op/op-scorm13.xsd'
const WRAPPER_HTML = './Modules/Scorm2004/scripts/converter/GenericRunTimeWrapper1.0_aadlc/GenericRunTimeWrapper.htm'
const WRAPPER_JS = './Modules/Scorm2004/scripts/converter/GenericRunTimeWrapper1.0_aadlc/SCOPlayerWrapper.js'
 $imsmanifest
 $manifest
 $diagnostic
 $status
 $packageId
 $packageName
 $packageHash
 $userId

Private Member Functions

 setProgress ($progress, $msg= '')

Private Attributes

 $packageFile
 $packageFolder
 $packagesFolder
 $packageData
 $slm
 $slm_tree
 $idmap = array()
 $progress = 0.0

Static Private Attributes

static $elements

Detailed Description

Author
Alex Killing alex..nosp@m.kill.nosp@m.ing@g.nosp@m.mx.d.nosp@m.e, Hendrik Holtmann holtm.nosp@m.ann@.nosp@m.mac.c.nosp@m.om, Alfred Kohnert alfre.nosp@m.d.ko.nosp@m.hnert.nosp@m.@big.nosp@m.foot..nosp@m.com
Version
$Id$

Definition at line 37 of file ilSCORM13Package.php.

Constructor & Destructor Documentation

ilSCORM13Package::__construct (   $packageId = null)

Definition at line 93 of file ilSCORM13Package.php.

References $GLOBALS, $packageId, and load().

{
$this->packagesFolder = IL_OP_PACKAGES_FOLDER;
$this->load($packageId);
$this->userId = $GLOBALS['USER']['usr_id'];
}

+ Here is the call graph for this function:

Member Function Documentation

ilSCORM13Package::dbAddNew ( )

add new sahs and package record

Definition at line 744 of file ilSCORM13Package.php.

References $ilDB, and $x.

{
global $ilDB;
//$this->packageId = 100;
//return true;
//ilSCORM13DB::getRecord('sahs_lm', array());
// $this->packageId = ilSCORM13DB::getRecord('sahs_lm', array());
/* ilSCORM13DB::setRecord('cp_package', array(
'obj_id' => $this->packageId,
'xmldata' => $x->asXML(),
'jsdata' => json_encode($j),
), 'obj_id');
*/
$ilDB->insert('cp_package', array(
'obj_id' => array('integer', $this->packageId),
'xmldata' => array('clob', $x->asXML()),
'jsdata' => array('clob', json_encode($j))
));
return true;
}
ilSCORM13Package::dbImport (   $node,
&  $lft = 1,
  $depth = 1,
  $parent = 0 
)

Definition at line 547 of file ilSCORM13Package.php.

References $ilDB, $key, $query, and $res.

Referenced by il_import().

{
global $ilDB;
switch ($node->nodeType)
{
case XML_DOCUMENT_NODE:
// insert into cp_package
/*ilSCORM13DB::setRecord('cp_package', array(
'obj_id' => $this->packageId,
'identifier' => $this->packageName,
'persistPreviousAttempts' => 0,
'settings' => '',
));*/
$res = $ilDB->queryF(
'SELECT * FROM cp_package WHERE obj_id = %s AND c_identifier = %s',
array('integer', 'text'),
array($this->packageId, $this->packageName)
);
if($num_rows = $ilDB->numRows($res))
{
$query = 'UPDATE cp_package '
. 'SET persistprevattempts = %s, c_settings = %s '
. 'WHERE obj_id = %s AND c_identifier= %s';
$ilDB->manipulateF(
$query,
array('integer', 'text', 'integer', 'text'),
array(0, NULL, $this->packageId, $this->packageName)
);
}
else
{
$query = 'INSERT INTO cp_package (obj_id, c_identifier, persistprevattempts, c_settings) '
. 'VALUES (%s, %s, %s, %s)';
$ilDB->manipulateF(
$query,
array('integer','text','integer', 'text'),
array($this->packageId, $this->packageName, 0, NULL)
);
}
// run sub nodes
$this->dbImport($node->documentElement); // RECURSION
break;
case XML_ELEMENT_NODE:
if ($node->nodeName==='manifest')
{
if ($node->getAttribute('uri')=="")
{
// default URI is md5 hash of zip file, i.e. packageHash
$node->setAttribute('uri', 'md5:' . $this->packageHash);
}
}
$cp_node_id = $ilDB->nextId('cp_node');
$query = 'INSERT INTO cp_node (cp_node_id, slm_id, nodename) '
. 'VALUES (%s, %s, %s)';
$ilDB->manipulateF(
$query,
array('integer', 'integer', 'text'),
array($cp_node_id, $this->packageId, $node->nodeName)
);
$query = 'INSERT INTO cp_tree (child, depth, lft, obj_id, parent, rgt) '
. 'VALUES (%s, %s, %s, %s, %s, %s)';
$ilDB->manipulateF(
$query,
array('integer', 'integer', 'integer', 'integer', 'integer', 'integer'),
array($cp_node_id, $depth, $lft++, $this->packageId, $parent, 0)
);
// insert into cp_*
//$a = array('cp_node_id' => $cp_node_id);
$names = array('cp_node_id');
$values = array($cp_node_id);
$types = array('integer');
foreach ($node->attributes as $attr)
{
switch(strtolower($attr->name))
{
case 'completionsetbycontent': $names[] = 'completionbycontent';break;
case 'objectivesetbycontent': $names[] = 'objectivebycontent';break;
case 'type': $names[] = 'c_type';break;
case 'mode': $names[] = 'c_mode';break;
case 'language': $names[] = 'c_language';break;
case 'condition': $names[] = 'c_condition';break;
case 'operator': $names[] = 'c_operator';break;
case 'condition': $names[] = 'c_condition';break;
case 'readnormalizedmeasure': $names[] = 'readnormalmeasure';break;
case 'writenormalizedmeasure': $names[] = 'writenormalmeasure';break;
case 'minnormalizedmeasure': $names[] = 'minnormalmeasure';break;
case 'primary': $names[] = 'c_primary';break;
case 'minnormalizedmeasure': $names[] = 'minnormalmeasure';break;
case 'persistpreviousattempts': $names[] = 'persistprevattempts';break;
case 'identifier': $names[] = 'c_identifier';break;
case 'settings': $names[] = 'c_settings';break;
case 'activityabsolutedurationlimit': $names[] = 'activityabsdurlimit';break;
case 'activityexperienceddurationlimit': $names[] = 'activityexpdurlimit';break;
case 'attemptabsolutedurationlimit': $names[] = 'attemptabsdurlimit';break;
case 'measuresatisfactionifactive': $names[] = 'measuresatisfactive';break;
case 'objectivemeasureweight': $names[] = 'objectivemeasweight';break;
case 'requiredforcompleted': $names[] = 'requiredcompleted';break;
case 'requiredforincomplete': $names[] = 'requiredincomplete';break;
case 'requiredfornotsatisfied': $names[] = 'requirednotsatisfied';break;
case 'rollupobjectivesatisfied': $names[] = 'rollupobjectivesatis';break;
case 'rollupprogresscompletion': $names[] = 'rollupprogcompletion';break;
case 'usecurrentattemptobjectiveinfo': $names[] = 'usecurattemptobjinfo';break;
case 'usecurrentattemptprogressinfo': $names[] = 'usecurattemptproginfo';break;
default: $names[] = strtolower($attr->name);break;
}
if(in_array($names[count($names) - 1],
array('flow', 'completionbycontent',
'objectivebycontent', 'rollupobjectivesatis',
'tracked', 'choice',
'choiceexit', 'satisfiedbymeasure',
'c_primary', 'constrainchoice',
'forwardonly', 'global_to_system',
'writenormalmeasure', 'writesatisfiedstatus',
'readnormalmeasure', 'readsatisfiedstatus',
'preventactivation', 'measuresatisfactive',
'reorderchildren', 'usecurattemptproginfo',
'usecurattemptobjinfo', 'rollupprogcompletion')))
{
if($attr->value == 'true')
$values[] = 1;
else if ($attr->value == 'false')
$values[] = 0;
else
$values[] = (int)$attr->value;
}
else
{
$values[] = $attr->value;
}
if( in_array($names[count($names) - 1],
array('objectivesglobtosys', 'attemptlimit',
'flow', 'completionbycontent',
'objectivebycontent', 'rollupobjectivesatis',
'tracked', 'choice',
'choiceexit', 'satisfiedbymeasure',
'c_primary', 'constrainchoice',
'forwardonly', 'global_to_system',
'writenormalmeasure', 'writesatisfiedstatus',
'readnormalmeasure', 'readsatisfiedstatus',
'preventactivation', 'measuresatisfactive',
'reorderchildren', 'usecurattemptproginfo',
'usecurattemptobjinfo', 'rollupprogcompletion')))
$types[] = 'integer';
else if ( in_array($names[count($names) - 1],
array('jsdata', 'xmldata', 'activitytree', 'data')))
$types[] = 'clob';
else if ( in_array($names[count($names) - 1],
array('objectivemeasweight')))
$types[] = 'float';
else
$types[] = 'text';
}
// we have to change the insert method because of clob fields ($ilDB->manipulate does not work here)
$insert_data = array();
foreach($names as $key => $db_field)
{
$insert_data[$db_field] = array($types[$key], trim($values[$key]));
}
$ilDB->insert('cp_'.strtolower($node->nodeName), $insert_data);
$node->setAttribute('foreignId', $cp_node_id);
$this->idmap[$node->getAttribute('id')] = $cp_node_id;
// run sub nodes
foreach($node->childNodes as $child)
{
$this->dbImport($child, $lft, $depth + 1, $cp_node_id); // RECURSION
}
// update cp_tree (rgt value for pre order walk in sql tree)
$query = 'UPDATE cp_tree SET rgt = %s WHERE child = %s';
$ilDB->manipulateF(
$query,
array('integer', 'integer'),
array($lft++, $cp_node_id)
);
break;
}
}

+ Here is the caller graph for this function:

ilSCORM13Package::dbImportLM (   $node,
  $parent_id 
)

Definition at line 325 of file ilSCORM13Package.php.

References $l, ilSCORM2004Item\insert(), ilSCORM2004Node\putInTree(), ilTree\setTreeTablePK(), and ilSaxParser\startParsing().

Referenced by il_importLM().

{
switch($node->getName())
{
case "manifest":
$this->slm_tree =& new ilTree($this->slm->getId());
$this->slm_tree->setTreeTablePK("slm_id");
$this->slm_tree->setTableNames('sahs_sc13_tree', 'sahs_sc13_tree_node');
$this->slm_tree->addTree($this->slm->getId(), 1);
//add seqinfo for rootNode
include_once ("./Modules/Scorm2004/classes/seq_editor/class.ilSCORM2004Sequencing.php");
$seq_info = new ilSCORM2004Sequencing($this->slm->getId(),true);
$seq_info->insert();
$doc = simplexml_load_file($this->packageFolder . '/' . 'index.xml');
$l = $doc->xpath ( "/ContentObject/MetaData" );
if($l[0])
{
include_once 'Services/MetaData/classes/class.ilMDXMLCopier.php';
$mdxml =& new ilMDXMLCopier($l[0]->asXML(),$this->slm->getId(),$this->slm->getId(),$this->slm->getType());
$mdxml->startParsing();
$mdxml->getMDObject()->update();
}
break;
case "organization":
$this->slm->title=$node->title;
break;
case "item":
$a = $node->attributes();
if(preg_match("/il_\d+_chap_\d+/",$a['identifier']))
{
$chap=& new ilSCORM2004Chapter($this->slm);
$chap->setTitle($node->title);
$chap->setSLMId($this->slm->getId());
$chap->create();
ilSCORM2004Node::putInTree($chap, "", "");
$parent_id=$chap->getId();
}
if(preg_match("/il_\d+_sco_(\d+)/",$a['identifier'], $match))
{
$sco = new ilSCORM2004Sco($this->slm);
$sco->setTitle($node->title);
$sco->setSLMId($this->slm->getId());
$sco->create();
ilSCORM2004Node::putInTree($sco, $parent_id, "");
$newPack = new ilSCORM13Package();
$newPack->il_importSco($this->slm->getId(),$sco->getId(),$this->packageFolder."/".$match[1]);
$parent_id = $sco->getId();
}
break;
}
//if($node->nodeType==XML_ELEMENT_NODE)
{
foreach($node->children() as $child)
{
$this->dbImportLM($child,$parent_id);
}
}
}

+ Here is the call graph for this function:

+ Here is the caller graph for this function:

ilSCORM13Package::dbImportSco (   $slm,
  $sco 
)

Definition at line 418 of file ilSCORM13Package.php.

References $d, $f, $l, $q, $result, $slm, $t, ilObjMediaObject\_getDirectory(), ilUtil\getDir(), IL_MO_PARSE_QTI, IL_MO_VERIFY_QTI, ilSCORM2004Node\putInTree(), ilUtil\renameExecutables(), and ilSaxParser\startParsing().

Referenced by il_importSco().

{
$qtis = array();
$d = ilUtil::getDir ( $this->packageFolder );
foreach ( $d as $f ) {
//continue;
if ($f [type] == 'file' && substr ( $f [entry], 0, 4 ) == 'qti_') {
include_once "./Services/QTI/classes/class.ilQTIParser.php";
include_once "./Modules/Test/classes/class.ilObjTest.php";
$qtiParser = new ilQTIParser ( $this->packageFolder . "/" . $f [entry], IL_MO_VERIFY_QTI, 0, "" );
$result = $qtiParser->startParsing ();
$founditems = & $qtiParser->getFoundItems ();
// die(print_r($founditems));
foreach ( $founditems as $qp ) {
$newObj = new ilObjTest ( 0, true );
// This creates a lot of invalid repository objects for each question
// question are not repository objects (see e.g. table object_data), alex 29 Sep 2009
// $newObj->setType ( $qp ['type'] );
// $newObj->setTitle ( $qp ['title'] );
// $newObj->create ( true );
// $newObj->createReference ();
// $newObj->putInTree ($_GET ["ref_id"]);
// $newObj->setPermissions ( $sco->getId ());
// $newObj->notify ("new", $_GET["ref_id"], $sco->getId (), $_GET["ref_id"], $newObj->getRefId () );
// $newObj->mark_schema->flush ();
$qtiParser = new ilQTIParser ( $this->packageFolder . "/" . $f [entry], IL_MO_PARSE_QTI, 0, "" );
$qtiParser->setTestObject ( $newObj );
$result = $qtiParser->startParsing ();
// $newObj->saveToDb ();
$qtis = array_merge($qtis, $qtiParser->getImportMapping());
//var_dump($qtis);
}
}
}
//exit;
include_once 'class.ilSCORM2004Page.php';
$doc = new SimpleXMLElement($this->imsmanifest->saveXml());
$l = $doc->xpath ( "/ContentObject/MetaData" );
if($l[0])
{
include_once 'Services/MetaData/classes/class.ilMDXMLCopier.php';
$mdxml =& new ilMDXMLCopier($l[0]->asXML(),$slm->getId(),$sco->getId(),$sco->getType());
$mdxml->startParsing();
$mdxml->getMDObject()->update();
}
$l = $doc->xpath("/ContentObject/PageObject");
foreach ( $l as $page_xml )
{
$tnode = $page_xml->xpath ( 'MetaData/General/Title' );
$page = new ilSCORM2004PageNode ( $slm );
$page->setTitle ( $tnode [0] );
$page->setSLMId ( $slm->getId () );
$page->create ();
ilSCORM2004Node::putInTree ( $page, $sco->getId (), $target );
$pmd = $doc->xpath ("MetaData");
if($pmd[0])
{
include_once 'Services/MetaData/classes/class.ilMDXMLCopier.php';
$mdxml =& new ilMDXMLCopier($pmd[0]->asXML(),$slm->getId(),$page->getId(),$page->getType());
$mdxml->startParsing();
$mdxml->getMDObject()->update();
}
$tnode = $page_xml->xpath ( "//MediaObject/MediaAlias" );
foreach ( $tnode as $ttnode )
{
include_once './Services/MediaObjects/classes/class.ilObjMediaObject.php';
$OriginId = $ttnode[OriginId];
$medianodes = $doc->xpath("//MediaObject[MetaData/General/Identifier/@Entry='".$OriginId ."']");
$medianode = $medianodes[0];
if($medianode)
{
$media_object = new ilObjMediaObject ( );
$media_object->setTitle ($medianode->MetaData->General->Title);
$media_object->setDescription ($medianode->MetaData->General->Description);
$media_object->create ();
$media_object->createMetaData();
// determine and create mob directory, move uploaded file to directory
$media_object->createDirectory ();
$mob_dir = ilObjMediaObject::_getDirectory ( $media_object->getId () );
foreach ( $medianode->MediaItem as $xMediaItem )
{
$media_item = & new ilMediaItem ( );
$media_object->addMediaItem ( $media_item );
$media_item->setPurpose($xMediaItem[Purpose]);
$media_item->setFormat($xMediaItem->Format );
$media_item->setLocation($xMediaItem->Location);
$media_item->setLocationType($xMediaItem->Location[Type]);
$media_item->setWidth ( $xMediaItem->Layout[Width]);
$media_item->setHeight ( $xMediaItem->Layout[Height]);
$media_item->setHAlign($xMediaItem->Layout[HorizontalAlign]);
if($media_item->getLocationType()=="LocalFile")
{
$tmp_name = $this->packageFolder."/objects/".$OriginId."/".$xMediaItem->Location;
copy($tmp_name, $mob_dir."/".$xMediaItem->Location);
}
}
// alex: fixed media import: these lines have been
// behind the next curly bracket which makes it fail
// when no medianode is given. (id=0 -> fatal error)
ilUtil::renameExecutables ( $mob_dir );
$media_object->update ();
$ttnode [OriginId] = "il__mob_" . $media_object->getId ();
}
}
$pagex = new ilSCORM2004Page($page->getId());
$tnode = $page_xml->xpath('PageContent');
$t = "<PageObject>";
foreach($tnode as $ttnode)
$t .= $ttnode->asXML();
$t .="</PageObject>";
// alex: this is necessary due to the changes above
//foreach ($qtis as $old=>$q)
// $t = str_replace($old,'il__qst_'.$q['test'], $t);
foreach ($qtis as $old=>$q)
$t = str_replace($old,'il__qst_'.$q['pool'], $t);
$pagex->setXMLContent($t);
$pagex->updateFromXML();
}
}

+ Here is the call graph for this function:

+ Here is the caller graph for this function:

ilSCORM13Package::dbRemoveAll ( )

Definition at line 883 of file ilSCORM13Package.php.

References removeCMIData(), and removeCPData().

Referenced by il_import(), and rollback().

{
//dont change order of calls
$this->removeCMIData();
$this->removeCPData();
}

+ Here is the call graph for this function:

+ Here is the caller graph for this function:

ilSCORM13Package::exportXML ( )

Export as internal XML.

Definition at line 143 of file ilSCORM13Package.php.

References $ilDB, $res, and $row.

{
global $ilDB;
header('content-type: text/xml');
header('content-disposition: attachment; filename="manifest.xml"');
//$row = ilSCORM13DB::getRecord("cp_package", "obj_id",$this->packageId);
$res = $ilDB->queryF(
'SELECT xmldata FROM cp_package WHERE obj_id = %s',
array('integer'),
array($this->packageId)
);
$row = $ilDB->fetchAssoc($res);
print($row['xmldata']);
}
ilSCORM13Package::exportZIP ( )

Definition at line 133 of file ilSCORM13Package.php.

{
header('content-type: application/zip');
header('content-disposition: attachment; filename="' . basename($this->packageFile) . '"');
readfile($this->packageFile);
}
ilSCORM13Package::il_import (   $packageFolder,
  $packageId,
  $ilias,
  $validate,
  $reimport = false 
)

Imports an extracted SCORM 2004 module from ilias-data dir into database.

public

Returns
string title of package

Definition at line 168 of file ilSCORM13Package.php.

References $ilDB, $ilErr, $ilLog, $packageFolder, $packageId, $x, dbImport(), dbRemoveAll(), jsonNode(), transform(), and validate().

{
global $ilDB, $ilLog, $ilErr;
if ($reimport === true) {
$this->packageId = $packageId;
$this->dbRemoveAll();
}
$this->packageFolder=$packageFolder;
$this->packageId=$packageId;
$this->imsmanifestFile = $this->packageFolder . '/' . 'imsmanifest.xml';
//step 1 - parse Manifest-File and validate
$this->imsmanifest = new DOMDocument;
$this->imsmanifest->async = false;
if (!@$this->imsmanifest->load($this->imsmanifestFile))
{
$this->diagnostic[] = 'XML not wellformed';
return false;
}
//step 2 tranform
$this->manifest = $this->transform($this->imsmanifest, self::DB_ENCODE_XSL);
if (!$this->manifest)
{
$this->diagnostic[] = 'Cannot transform into normalized manifest';
return false;
}
//step 3 validation -just for normalized XML
if ($validate=="y") {
if (!$this->validate($this->manifest, self::VALIDATE_XSD))
{
$ilErr->raiseError("<b>The uploaded SCORM 1.2 / SCORM 2004 is not valid. You can try to import the package without the validation option checked on your own risk. </b><br><br>Validation Error(s):</b><br> Normalized XML is not conform to ". self::VALIDATE_XSD,
$ilErr->MESSAGE);
}
}
$this->dbImport($this->manifest);
//step 5
$x = simplexml_load_string($this->manifest->saveXML());
$x['persistPreviousAttempts'] = $this->packageData['persistprevattempts'];
$x['online'] = $this->packageData['c_online'];
$x['defaultLessonMode'] = $this->packageData['default_lesson_mode'];
$x['credit'] = $this->packageData['credit'];
$x['autoReview'] = $this->packageData['auto_review'];
$j = array();
// first read resources into flat array to resolve item/identifierref later
$r = array();
foreach ($x->resource as $xe)
{
$r[strval($xe['id'])] = $xe;
unset($xe);
}
// iterate through items and set href and scoType as activity attributes
foreach ($x->xpath('//*[local-name()="item"]') as $xe)
{
// get reference to resource and set href accordingly
if ($b = $r[strval($xe['resourceId'])])
{
$xe['href'] = strval($b['base']) . strval($b['href']);
unset($xe['resourceId']);
if (strval($b['scormType'])=='sco') $xe['sco'] = true;
}
}
// iterate recursivly through activities and build up simple php object
// with items and associated sequencings
// top node is the default organization which is handled as an item
self::jsonNode($x->organization, $j['item']);
foreach($x->sequencing as $s)
{
self::jsonNode($s, $j['sequencing'][]);
}
// combined manifest+resources xml:base is set as organization base
$j['item']['base'] = strval($x['base']);
// package folder is base to whole playing process
$j['base'] = $packageFolder . '/';
$j['foreignId'] = floatval($x['foreignId']); // manifest cp_node_id for associating global (package wide) objectives
$j['id'] = strval($x['id']); // manifest id for associating global (package wide) objectives
//last step - build ADL Activity tree
$act = new SeqTreeBuilder();
$adl_tree = $act->buildNodeSeqTree($this->imsmanifestFile);
$ilDB->update('cp_package',
array(
'xmldata' => array('clob', $x->asXML()),
'jsdata' => array('clob', json_encode($j)),
'activitytree' => array('clob', json_encode($adl_tree['tree'])),
'global_to_system' => array('integer', (int)$adl_tree['global'])
),
array(
'obj_id' => array('integer', (int)$this->packageId)
)
);
return $j['item']['title'];
}

+ Here is the call graph for this function:

ilSCORM13Package::il_importLM (   $slm,
  $packageFolder 
)

Definition at line 301 of file ilSCORM13Package.php.

References $ilDB, $ilLog, $packageFolder, $slm, and dbImportLM().

{
global $ilDB, $ilLog;
$this->packageFolder=$packageFolder;
$this->packageId=$slm->getId();
$this->imsmanifestFile = $this->packageFolder . '/' . 'imsmanifest.xml';
$this->imsmanifest = new DOMDocument;
$this->imsmanifest->async = false;
$this->slm = $slm;
if (!@$this->imsmanifest->load($this->imsmanifestFile))
{
$this->diagnostic[] = 'XML not wellformed';
return false;
}
$this->dbImportLM(simplexml_import_dom($this->imsmanifest->documentElement),$this->slm);
// if(is_dir($packageFolder."/glossary"))
// {
// $this->importGlossary($slm,$packageFolder."/glossary");
// }
//die($slm->title);
return $slm->title;
}

+ Here is the call graph for this function:

ilSCORM13Package::il_importSco (   $packageId,
  $sco_id,
  $packageFolder 
)

Imports an extracted SCORM 2004 module from ilias-data dir into database.

public

Returns
string title of package

Definition at line 277 of file ilSCORM13Package.php.

References $ilDB, $ilLog, $packageFolder, $packageId, $slm, and dbImportSco().

{
global $ilDB, $ilLog;
$this->packageFolder=$packageFolder;
$this->packageId=$packageId;
$this->imsmanifestFile = $this->packageFolder . '/' . 'index.xml';
$this->imsmanifest = new DOMDocument;
$this->imsmanifest->async = false;
if (!@$this->imsmanifest->load($this->imsmanifestFile))
{
$this->diagnostic[] = 'XML not wellformed';
return false;
}
$slm = new ilObjSCORM2004LearningModule($packageId,false);
$sco = new ilSCORM2004Sco($slm,$sco_id);
$this->dbImportSco($slm,$sco);
return "";
}

+ Here is the call graph for this function:

ilSCORM13Package::jsonNode (   $node,
&  $sink 
)

Helper for UploadAndImport Recursively copies values from XML into PHP array for export as json Elements are translated into sub array, attributes into literals.

Parameters
xmlelement to process
referenceto array object where to copy values
Returns
void

Definition at line 401 of file ilSCORM13Package.php.

References $name.

Referenced by il_import().

{
foreach ($node->attributes() as $k => $v)
{
// cast to boolean and number if possible
$v = strval($v);
if ($v==="true") $v = true;
else if ($v==="false") $v = false;
else if (is_numeric($v)) $v = (float) $v;
$sink[$k] = $v;
}
foreach ($node->children() as $name => $child)
{
self::jsonNode($child, $sink[$name][]); // RECURSION
}
}

+ Here is the caller graph for this function:

ilSCORM13Package::load (   $packageId)

Definition at line 100 of file ilSCORM13Package.php.

References $ilDB, and $packageId.

Referenced by __construct().

{
global $ilDB;
if (!is_numeric($packageId))
{
return false;
}
$lm_set = $ilDB->queryF('SELECT * FROM sahs_lm WHERE id = %s', array('integer'), array($packageId));
$lm_data = $ilDB->fetchAssoc($lm_set);
$pg_set = $ilDB->queryF('SELECT * FROM cp_package WHERE obj_id = %s', array('integer'), array($packageId));
$pg_data = $ilDB->fetchAssoc($lm_set);
$this->packageData = array_merge($lm_data, $pg_data);
$this->packageId = $packageId;
$this->packageFolder = $this->packagesFolder . '/' . $packageId;
$this->packageFile = $this->packageFolder . '.zip';
$this->imsmanifestFile = $this->packageFolder . '/' . 'imsmanifest.xml';
return true;
}

+ Here is the caller graph for this function:

ilSCORM13Package::removeCMIData ( )

Definition at line 769 of file ilSCORM13Package.php.

References $data, $ilDB, $query, and $res.

Referenced by dbRemoveAll().

{
global $ilDB;
//cmi nodes
$cmi_nodes = array();
$res = $ilDB->queryF('
SELECT cmi_node.cmi_node_id
FROM cmi_node, cp_node
WHERE cp_node.slm_id = %s AND cmi_node.cp_node_id = cp_node.cp_node_id',
array('integer'),
array($this->packageId)
);
while($data = $ilDB->fetchAssoc($res))
{
$cmi_node_values[] = $data['cmi_node_id'];
}
//cmi interaction nodes
$cmi_inodes = array();
$res = $ilDB->queryF('
SELECT cmi_interaction.cmi_interaction_id
FROM cmi_interaction, cmi_node, cp_node
WHERE (cp_node.slm_id = %s
AND cmi_node.cp_node_id = cp_node.cp_node_id
AND cmi_node.cmi_node_id = cmi_interaction.cmi_node_id)',
array('integer'),
array($this->packageId)
);
while($data = $ilDB->fetchAssoc($res))
{
$cmi_inode_values[] = $data['cmi_interaction_id'];
}
//response
$query = 'DELETE FROM cmi_correct_response WHERE '
. $ilDB->in('cmi_correct_response.cmi_interaction_id', $cmi_inode_values, false, 'integer');
$ilDB->manipulate($query);
//objective interaction
$query = 'DELETE FROM cmi_objective WHERE '
. $ilDB->in('cmi_objective.cmi_interaction_id', $cmi_inode_values, false, 'integer');
$ilDB->manipulate($query);
//objective
$query = 'DELETE FROM cmi_objective WHERE '
. $ilDB->in('cmi_objective.cmi_node_id', $cmi_node_values, false, 'integer');
$ilDB->manipulate($query);
//interaction
$query = 'DELETE FROM cmi_interaction WHERE '
. $ilDB->in('cmi_interaction.cmi_node_id', $cmi_node_values, false, 'integer');
$ilDB->manipulate($query);
//comment
$query = 'DELETE FROM cmi_comment WHERE '
. $ilDB->in('cmi_comment.cmi_node_id', $cmi_node_values, false, 'integer');
$ilDB->manipulate($query);
//node
$query = 'DELETE FROM cmi_node WHERE '
. $ilDB->in('cmi_node.cmi_node_id', $cmi_node_values, false, 'integer');
$ilDB->manipulate($query);
}

+ Here is the caller graph for this function:

ilSCORM13Package::removeCPData ( )

Definition at line 836 of file ilSCORM13Package.php.

References $data, $ilDB, $ilLog, $in, $res, and $t.

Referenced by dbRemoveAll().

{
global $ilDB, $ilLog;
//get relevant nodes
$cp_nodes = array();
$res = $ilDB->queryF(
'SELECT cp_node.cp_node_id FROM cp_node WHERE cp_node.slm_id = %s',
array('integer'),
array($this->packageId)
);
while($data = $ilDB->fetchAssoc($res))
{
$cp_nodes[] = $data['cp_node_id'];
}
//remove package data
foreach(self::$elements['cp'] as $t)
{
$t = 'cp_' . $t;
$in = $ilDB->in(strtolower($t).'.cp_node_id', $cp_nodes, false, 'integer');
$ilDB->manipulate('DELETE FROM '.strtolower($t).' WHERE '.$in);
}
// remove CP structure entries in tree and node
$ilDB->manipulateF(
'DELETE FROM cp_tree WHERE cp_tree.obj_id = %s',
array('integer'),
array($this->packageId)
);
$ilDB->manipulateF(
'DELETE FROM cp_node WHERE cp_node.slm_id = %s',
array('integer'),
array($this->packageId)
);
// remove general package entry
$ilDB->manipulateF(
'DELETE FROM cp_package WHERE cp_package.obj_id = %s',
array('integer'),
array($this->packageId)
);
}

+ Here is the caller graph for this function:

ilSCORM13Package::rollback ( )

Definition at line 122 of file ilSCORM13Package.php.

References dbRemoveAll(), and setProgress().

{
$this->setProgress(0, 'Rolling back...');
$this->dbRemoveAll();
if (is_dir($this->packageFolder))
dir_delete($this->packageFolder);
if (is_file($this->packageFile))
@unlink($this->packageFile);
$this->setProgress(0, 'Roll back finished: Ok. ');
}

+ Here is the call graph for this function:

ilSCORM13Package::setProgress (   $progress,
  $msg = '' 
)
private

Definition at line 387 of file ilSCORM13Package.php.

References $progress.

Referenced by rollback().

{
$this->progress = $progress;
$this->diagnostic[] = $msg;
}

+ Here is the caller graph for this function:

ilSCORM13Package::transform (   $inputdoc,
  $xslfile,
  $outputpath = null 
)

Definition at line 890 of file ilSCORM13Package.php.

Referenced by il_import().

{
$xsl = new DOMDocument;
$xsl->async = false;
if (!@$xsl->load($xslfile))
{
die('ERROR: load StyleSheet ' . $xslfile);
}
$prc = new XSLTProcessor;
$r = @$prc->importStyleSheet($xsl);
if (false===@$prc->importStyleSheet($xsl))
{
die('ERROR: importStyleSheet ' . $xslfile);
}
if ($outputpath)
{
file_put_contents($outputpath, $prc->transformToXML($inputdoc));
}
else
{
return $prc->transformToDoc($inputdoc);
}
}

+ Here is the caller graph for this function:

ilSCORM13Package::validate (   $doc,
  $schema 
)

Definition at line 914 of file ilSCORM13Package.php.

References $error.

Referenced by il_import().

{
libxml_use_internal_errors(true);
$return = @$doc->schemaValidate($schema);
if (!$return)
{
$levels = array(
LIBXML_ERR_ERROR => 'Error',
LIBXML_ERR_FATAL => 'Fatal Error'
);
foreach (libxml_get_errors() as $error)
{
$level = $levels[$error->level];
if (isset($level))
{
$message = trim($error->message);
$this->diagnostic[] = "XSLT $level (Line $error->line) $message";
}
}
libxml_clear_errors();
}
libxml_use_internal_errors(false);
return $return;
}

+ Here is the caller graph for this function:

Field Documentation

ilSCORM13Package::$diagnostic

Definition at line 58 of file ilSCORM13Package.php.

ilSCORM13Package::$elements
staticprivate
Initial value:
array(
'cp' => array(
'manifest',
'organization',
'item',
'hideLMSUI',
'resource',
'file',
'dependency',
'sequencing',
'rule',
'auxilaryResource',
'condition',
'mapinfo',
'objective',
),
'cmi' => array(
'comment',
'correct_response',
'interaction',
'node',
'objective',
),
)

Definition at line 68 of file ilSCORM13Package.php.

ilSCORM13Package::$idmap = array()
private

Definition at line 65 of file ilSCORM13Package.php.

ilSCORM13Package::$imsmanifest

Definition at line 56 of file ilSCORM13Package.php.

ilSCORM13Package::$manifest

Definition at line 57 of file ilSCORM13Package.php.

ilSCORM13Package::$packageData
private

Definition at line 52 of file ilSCORM13Package.php.

ilSCORM13Package::$packageFile
private

Definition at line 49 of file ilSCORM13Package.php.

ilSCORM13Package::$packageFolder
private

Definition at line 50 of file ilSCORM13Package.php.

Referenced by il_import(), il_importLM(), and il_importSco().

ilSCORM13Package::$packageHash

Definition at line 62 of file ilSCORM13Package.php.

ilSCORM13Package::$packageId

Definition at line 60 of file ilSCORM13Package.php.

Referenced by __construct(), il_import(), il_importSco(), and load().

ilSCORM13Package::$packageName

Definition at line 61 of file ilSCORM13Package.php.

ilSCORM13Package::$packagesFolder
private

Definition at line 51 of file ilSCORM13Package.php.

ilSCORM13Package::$progress = 0.0
private

Definition at line 66 of file ilSCORM13Package.php.

Referenced by setProgress().

ilSCORM13Package::$slm
private

Definition at line 53 of file ilSCORM13Package.php.

Referenced by dbImportSco(), il_importLM(), and il_importSco().

ilSCORM13Package::$slm_tree
private

Definition at line 54 of file ilSCORM13Package.php.

ilSCORM13Package::$status

Definition at line 59 of file ilSCORM13Package.php.

ilSCORM13Package::$userId

Definition at line 63 of file ilSCORM13Package.php.

const ilSCORM13Package::CONVERT_XSL = './Modules/Scorm2004/templates/xsl/op/scorm12To2004.xsl'

Definition at line 41 of file ilSCORM13Package.php.

const ilSCORM13Package::DB_DECODE_XSL = './Modules/Scorm2004/templates/xsl/op/op-scorm13-revert.xsl'

Definition at line 42 of file ilSCORM13Package.php.

const ilSCORM13Package::DB_ENCODE_XSL = './Modules/Scorm2004/templates/xsl/op/op-scorm13.xsl'

Definition at line 40 of file ilSCORM13Package.php.

const ilSCORM13Package::VALIDATE_XSD = './Modules/Scorm2004/templates/xsd/op/op-scorm13.xsd'

Definition at line 43 of file ilSCORM13Package.php.

const ilSCORM13Package::WRAPPER_HTML = './Modules/Scorm2004/scripts/converter/GenericRunTimeWrapper1.0_aadlc/GenericRunTimeWrapper.htm'

Definition at line 45 of file ilSCORM13Package.php.

const ilSCORM13Package::WRAPPER_JS = './Modules/Scorm2004/scripts/converter/GenericRunTimeWrapper1.0_aadlc/SCOPlayerWrapper.js'

Definition at line 46 of file ilSCORM13Package.php.

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