Class ilSCORM2004Utilities. More...

Collaboration diagram for ilSCORM2004Utilities:

Public Member Functions
	__construct ($a_id)

	parentHasSeqTemplate ($a_slm_id)

	getLeftRightInfo ()

	getImportIdent ()

	getAllowedActions ()

	getControlModeProperties ()

	getAllSequencingProperties ()

Protected Member Functions
	getSeqNodeId ()

Protected Attributes
	$db

	$log

Private Member Functions
	getParentsForNode ($a_parents, $a_id)

	getSequencingId ()

	getItemId ()

	getId ()

Private Attributes
	$id = null

Detailed Description

Class ilSCORM2004Utilities.

Sequencing Utilities class for SCORM 2004 Editing

Author: Hendrik Holtmann holtm.nosp@m.ann@.nosp@m.me.co.nosp@m.m

Version: $Id$

Definition at line 17 of file class.ilSCORM2004Utilities.php.

Constructor & Destructor Documentation

◆ __construct()

ilSCORM2004Utilities::__construct ( $a_id )

Definition at line 37 of file class.ilSCORM2004Utilities.php.

References $DIC.

     {
         global $DIC;
 
         $this->db = $DIC->database();
         $this->log = $DIC["ilLog"];
         $this->id = $a_id;
     }

Member Function Documentation

◆ getAllowedActions()

ilSCORM2004Utilities::getAllowedActions ( )

Definition at line 149 of file class.ilSCORM2004Utilities.php.

References $db, $ilDB, $ilLog, $log, $query, array, ilDBConstants\FETCHMODE_ASSOC, and getId().

     {
         $ilDB = $this->db;
         $ilLog = $this->log;
         $ilLog->write("SCORM: getAllowedActions for" . $this->tree_node_id);
         $query = "SELECT * FROM sahs_sc13_seq_item WHERE sahs_sc13_tree_node_id = " .
             $ilDB->quote($this->getId(), "integer");
         $obj_set = $ilDB->query($query);
         $obj_rec = $obj_set->fetchRow(ilDBConstants::FETCHMODE_ASSOC);
         return array("copy"=>!$obj_rec['nocopy'],"move"=>!$obj_rec['nomove'],"delete"=>!$obj_rec['nodelete']);
     }

Here is the call graph for this function:

◆ getAllSequencingProperties()

ilSCORM2004Utilities::getAllSequencingProperties ( )

Definition at line 176 of file class.ilSCORM2004Utilities.php.

References $db, $ilDB, $ilLog, $log, $query, array, ilDBConstants\FETCHMODE_ASSOC, getImportIdent(), and getSequencingId().

Referenced by getSeqNodeId().

     {
         $ilDB = $this->db;
         $ilLog = $this->log;
         $query = "SELECT * FROM sahs_sc13_seq_seq WHERE (id = " .
             $ilDB->quote($this->getSequencingId(), "text") .
             " AND importid=" . $ilDB->quote($this->getImportIdent(), "text") . ")";
         $obj_set = $ilDB->query($query);
         $ilLog->write("SCORM: getAllSequencingProperties for" . $this->getSequencingId());
         $obj_rec = $obj_set->fetchRow(ilDBConstants::FETCHMODE_ASSOC);
         $sprop = array(
             'importId' => $obj_rec['importid'],
             'activityAbsoluteDurationLimit' => $obj_rec['activityabsolutedurationlimit'],
             'activityExperiencedDurationLimit' => $obj_rec['activityexperienceddurlimit'],
             'attemptAbsoluteDurationLimit' => $obj_rec['attemptabsolutedurationlimit'],
             'attemptExperiencedDurationLimit' => $obj_rec['attemptexperienceddurlimit'],
             'attemptLimit' => $obj_rec['attemptlimit'],
             'beginTimeLimit' => $obj_rec['begintimelimit'],
             'completionSetByContent' => $obj_rec['completionsetbycontent'],
             'constrainChoice' => $obj_rec['constrainchoice'],
             'seqNodeId' => $obj_rec['seqnodeid'],
             'endTimeLimit' => $obj_rec['endtimelimit'],
             'id' => $obj_rec['id'],
             'measureSatisfactionIfActive' => $obj_rec['measuresatisfactionifactive'],
             'objectiveMeasureWeight' => $obj_rec['objectivemeasureweight'],
             'objectiveSetByContent' => $obj_rec['objectivesetbycontent'],
             'preventActivation' => $obj_rec['preventactivation'],
             'randomizationTiming' => $obj_rec['randomizationtiming'],
             'reorderChildren' => $obj_rec['reorderchildren'],
             'requiredForCompleted' => $obj_rec['requiredforcompleted'],
             'requiredForIncomplete' => $obj_rec['requiredforincomplete'],
             'requiredForNotSatisfied' => $obj_rec['requiredfornotsatisfied'],
             'requiredForSatisfied' => $obj_rec['requiredforsatisfied'],
             'rollupObjectiveSatisfied' => $obj_rec['rollupobjectivesatisfied'],
             'rollupProgressCompletion' => $obj_rec['rollupprogresscompletion'],
             'selectCount' => $obj_rec['selectcount'],
             'selectionTiming' => $obj_rec['selectiontiming'],
             'sequencingId' => $obj_rec['sequencingid'],
             'tracked' => $obj_rec['tracked'],
             'useCurrentAttemptObjectiveInfo' => $obj_rec['usecurrentattemptobjectiveinfo'],
             'useCurrentAttemptProgressInfo' => $obj_rec['usecurrentattemptprogressinfo'],
             'flow' => $obj_rec['flow'],
             'forwardOnly' => $obj_rec['forwardonly'],
             'choice' => $obj_rec['choice'],
             'choiceExit' => $obj_rec['choiceexit'] );
         return $sprop;
     }

Here is the call graph for this function:

Here is the caller graph for this function:

◆ getControlModeProperties()

ilSCORM2004Utilities::getControlModeProperties ( )

Definition at line 161 of file class.ilSCORM2004Utilities.php.

References $db, $ilDB, $query, array, ilDBConstants\FETCHMODE_ASSOC, and getSequencingId().

     {
         $ilDB = $this->db;
         $query = "SELECT * FROM sahs_sc13_seq_seq WHERE id = " .
             $ilDB->quote($this->getSequencingId(), "text");
         $obj_set = $ilDB->query($query);
         $obj_rec = $obj_set->fetchRow(ilDBConstants::FETCHMODE_ASSOC);
         $c_properties = array(
             'flow' => $obj_rec['flow'],
             'forwardOnly' => $obj_rec['forwardonly'],
             'choice' => $obj_rec['choice'],
             'choiceExit' => $obj_rec['choiceexit'] );
         return $c_properties;
     }

Here is the call graph for this function:

◆ getId()

ilSCORM2004Utilities::getId ( )

private

Definition at line 144 of file class.ilSCORM2004Utilities.php.

References $id.

Referenced by getAllowedActions(), getImportIdent(), getItemId(), and getSequencingId().

     {
         return $this->id;
     }

Here is the caller graph for this function:

◆ getImportIdent()

ilSCORM2004Utilities::getImportIdent ( )

Definition at line 130 of file class.ilSCORM2004Utilities.php.

References $db, $ilDB, $ilLog, $log, $query, ilDBConstants\FETCHMODE_ASSOC, and getId().

Referenced by getAllSequencingProperties(), and getLeftRightInfo().

     {
         $ilDB = $this->db;
         $ilLog = $this->log;
         $ilLog->write("SCORM: getImportIdent for" . $this->getId);
         $query = "SELECT * FROM sahs_sc13_seq_item WHERE sahs_sc13_tree_node_id = " .
             $ilDB->quote($this->getId(), "integer");
         $obj_set = $ilDB->query($query);
         $obj_rec = $obj_set->fetchRow(ilDBConstants::FETCHMODE_ASSOC);
         return $obj_rec['importid'];
     }

Here is the call graph for this function:

Here is the caller graph for this function:

◆ getItemId()

ilSCORM2004Utilities::getItemId ( )

private

Definition at line 118 of file class.ilSCORM2004Utilities.php.

References $db, $ilDB, $ilLog, $log, $query, ilDBConstants\FETCHMODE_ASSOC, and getId().

     {
         $ilDB = $this->db;
         $ilLog = $this->log;
         $ilLog->write("SCORM: getSequencingId for" . $this->getId);
         $query = "SELECT * FROM sahs_sc13_seq_item WHERE sahs_sc13_tree_node_id = " .
             $ilDB->quote($this->getId(), "integer");
         $obj_set = $ilDB->query($query);
         $obj_rec = $obj_set->fetchRow(ilDBConstants::FETCHMODE_ASSOC);
         return $obj_rec['seqnodeid'];
     }

Here is the call graph for this function:

◆ getLeftRightInfo()

ilSCORM2004Utilities::getLeftRightInfo ( )

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

References $db, $ilDB, $ilLog, $log, $query, array, getImportIdent(), and getSeqNodeId().

     {
         $ilDB = $this->db;
         $ilLog = $this->log;
         $ilLog->write("SCORM: getLeftRightInfo");
         $query = "SELECT * FROM sahs_sc13_seq_tree WHERE (child = " .
             $ilDB->quote($this->getSeqNodeId(), "integer") .
             " AND importid=" . $ilDB->quote($this->getImportIdent(), "text") . ")";
         $obj_set = $ilDB->query($query);
         $ilLog->write("SCORM: getLeftRightInfo executed" . $query);
         $obj_rec = $ilDB->fetchAssoc($obj_set);
         return array("left"=> $obj_rec["lft"], "right" => $obj_rec["rgt"]);
     }

Here is the call graph for this function:

◆ getParentsForNode()

ilSCORM2004Utilities::getParentsForNode	(	$a_parents,
		$a_id
	)

private

Definition at line 70 of file class.ilSCORM2004Utilities.php.

References $id.

Referenced by parentHasSeqTemplate().

     {
         $parent_id = $tree->getParentId($id);
         if ($parent_id != 0) {
             array_push($a_parents, $parent_id);
             $this->getParentsForNode($a_parents, $parent_id);
         } else {
             return $a_parents;
         }
     }

Here is the caller graph for this function:

◆ getSeqNodeId()

ilSCORM2004Utilities::getSeqNodeId ( )

protected

Definition at line 97 of file class.ilSCORM2004Utilities.php.

References $db, $ilDB, $ilLog, $log, and getAllSequencingProperties().

Referenced by getLeftRightInfo().

     {
         $ilDB = $this->db;
         $ilLog = $this->log;
         $all_props = $this->getAllSequencingProperties();
         $ilLog->write("SCORM: getSeqNodeId: " . $all_props["seqnodeid"]);
         return $all_props["seqnodeid"];
     }

Here is the call graph for this function:

Here is the caller graph for this function:

◆ getSequencingId()

ilSCORM2004Utilities::getSequencingId ( )

private

Definition at line 106 of file class.ilSCORM2004Utilities.php.

References $db, $ilDB, $ilLog, $log, $query, ilDBConstants\FETCHMODE_ASSOC, and getId().

Referenced by getAllSequencingProperties(), and getControlModeProperties().

     {
         $ilDB = $this->db;
         $ilLog = $this->log;
         $ilLog->write("SCORM: getSequencingId for" . $this->getId());
         $query = "SELECT * FROM sahs_sc13_seq_item WHERE sahs_sc13_tree_node_id = " .
             $ilDB->quote($this->getId(), "integer");
         $obj_set = $ilDB->query($query);
         $obj_rec = $obj_set->fetchRow(ilDBConstants::FETCHMODE_ASSOC);
         return $obj_rec['sequencingid'];
     }

Here is the call graph for this function:

Here is the caller graph for this function:

◆ parentHasSeqTemplate()

ilSCORM2004Utilities::parentHasSeqTemplate ( $a_slm_id )

Definition at line 46 of file class.ilSCORM2004Utilities.php.

References $db, $i, $ilDB, $ilLog, $log, $template, array, getParentsForNode(), and ilSCORM2004SeqTemplate\templateForChapter().

     {
         require_once("./Modules/Scorm2004/classes/seq_editor/class.ilSCORM2004SeqTemplate.php");
         
         $ilDB = $this->db;
         $ilLog = $this->log;
         $has_template = false;
             
         $mtree = new ilTree($a_slm_id);
         $mtree->setTableNames('sahs_sc13_tree', 'sahs_sc13_tree_node');
         $mtree->setTreeTablePK("slm_id");
         //get all parents for current node
         $parents = $this -> getParentsForNode($a_parents=array(), $this->id);
         for ($i=0;$i<count($parents);$i++) {
             $template = ilSCORM2004SeqTemplate::templateForChapter($parents[$i]);
             if ($template) {
                 $has_template = true;
                 break;
             }
         }
         
         return $has_template;
     }