class.ilSCORM2004Utilities.php

Go to the documentation of this file.

<?php

/* Copyright (c) 1998-2011 ILIAS open source, Extended GPL, see docs/LICENSE */


class ilSCORM2004Utilities 
{
        
        
        private $id = null;
        
        /*
        * Constructor
        * @access       public
        */
        function __construct($a_id)
        {
                $this->id = $a_id;
        }
        
        public function parentHasSeqTemplate($a_slm_id)
        {
                require_once("./Modules/Scorm2004/classes/seq_editor/class.ilSCORM2004SeqTemplate.php");
                
                global $ilDB,$ilLog;
                $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;
        }
        
        private function getParentsForNode($a_parents,$a_id){
                $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;
                }
        }
        
        
        public function getLeftRightInfo() 
        {
                global $ilDB,$ilLog;
                $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"]);
        }
        
        
        protected function getSeqNodeId() 
        {
                global $ilDB,$ilLog;
                $all_props = $this->getAllSequencingProperties();
                $ilLog->write("SCORM: getSeqNodeId: ".$all_props["seqnodeid"]);
                return $all_props["seqnodeid"];
        }
        
        private function getSequencingId() 
        {
                global $ilDB,$ilLog;
                $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'];
        }
        
        private function getItemId() 
        {
                global $ilDB,$ilLog;
                $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'];
        }
        
        public function getImportIdent() 
        {
                global $ilDB,$ilLog;
                $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'];
        }
        
        
        
        private function getId()
        {
                return $this->id;
        }
        
        public function getAllowedActions()
        {
                global $ilDB,$ilLog;
                $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']);
        }
        
        public function getControlModeProperties()
        {
                global $ilDB;
                $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;
        }
        
        public function getAllSequencingProperties()
        {
                global $ilDB,$ilLog;
                $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;
        }
        

        
}
?>