Class ilSCORM2004Utilities. More...

Collaboration diagram for ilSCORM2004Utilities:

Public Member Functions
	__construct ($a_id)

	getLeftRightInfo ()

	getImportIdent ()

	getAllowedActions ()

	getControlModeProperties ()

	getAllSequencingProperties ()

Protected Member Functions
	getSeqNodeId ()

Protected Attributes
	$db

	$log

Private Member Functions
	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 150 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: 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 177 of file class.ilSCORM2004Utilities.php.

References $db, $ilDB, $ilLog, $log, $query, 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 162 of file class.ilSCORM2004Utilities.php.

References $db, $ilDB, $query, 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 145 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 131 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 119 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 83 of file class.ilSCORM2004Utilities.php.

References $db, $ilDB, $ilLog, $log, $query, 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:

◆ getSeqNodeId()

ilSCORM2004Utilities::getSeqNodeId ( )

protected

Definition at line 98 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 107 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'];
     }