class.ilObjAICCLearningModule.php

Go to the documentation of this file.

<?php
/*
        +-----------------------------------------------------------------------------+
        | ILIAS open source                                                           |
        +-----------------------------------------------------------------------------+
        | Copyright (c) 1998-2001 ILIAS open source, University of Cologne            |
        |                                                                             |
        | This program is free software; you can redistribute it and/or               |
        | modify it under the terms of the GNU General Public License                 |
        | as published by the Free Software Foundation; either version 2              |
        | of the License, or (at your option) any later version.                      |
        |                                                                             |
        | This program is distributed in the hope that it will be useful,             |
        | but WITHOUT ANY WARRANTY; without even the implied warranty of              |
        | MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the               |
        | GNU General Public License for more details.                                |
        |                                                                             |
        | You should have received a copy of the GNU General Public License           |
        | along with this program; if not, write to the Free Software                 |
        | Foundation, Inc., 59 Temple Place - Suite 330, Boston, MA  02111-1307, USA. |
        +-----------------------------------------------------------------------------+
*/

require_once "classes/class.ilObject.php";
//require_once "Services/MetaData/classes/class.ilMDLanguageItem.php";
require_once "./Modules/ScormAicc/classes/class.ilObjSCORMLearningModule.php";

class ilObjAICCLearningModule extends ilObjSCORMLearningModule
{
        //var $meta_data;

        function ilObjAICCLearningModule($a_id = 0, $a_call_by_reference = true)
        {
                $this->type = "sahs";
                parent::ilObject($a_id,$a_call_by_reference);
        }

        function readObject()
        {
                require_once("./Modules/ScormAicc/classes/class.ilObjAICCCourseInterchangeFiles.php");
                $cifModule = new ilObjAICCCourseInterchangeFiles();
                $cifModule->findFiles($this->getDataDirectory());

                $cifModule->readFiles();
                if (!empty($cifModule->errorText))
                {
                        $this->ilias->raiseError("<b>Error reading LM-File(s):</b><br>".implode("<br>", $cifModule->errorText), $this->ilias->error_obj->WARNING);
                }

                if ($_POST["validate"] == "y")
                {

                        $cifModule->validate();
                        if (!empty($cifModule->errorText))
                        {
                                $this->ilias->raiseError("<b>Validation Error(s):</b><br>".implode("<br>", $cifModule->errorText), $this->ilias->error_obj->WARNING);
                        }
                }

                $cifModule->writeToDatabase($this->getId());
        }


        function delete()
        {
                global $ilDB, $ilLog;

                // always call parent delete function first!!
                if (!parent::delete())
                {
                        return false;
                }

                // delete meta data of scorm content object
/*
                $nested = new ilNestedSetXML();
                $nested->init($this->getId(), $this->getType());
                $nested->deleteAllDBData();
*/
                $this->deleteMetaData();

                // delete data directory
                ilUtil::delDir($this->getDataDirectory());

                // delete scorm learning module record
                $ilDB->manipulateF('DELETE FROM sahs_lm WHERE id = %s',
                array('integer'), array($this->getId()));

                // delete aicc data
                $res = $ilDB->queryF('
                        SELECT * FROM aicc_object, aicc_units
                        WHERE aicc_object.obj_id = aicc_units.obj_id
                        AND aicc_object.slm_id = %s',
                        array('integer'), array($this->getId()));
                
                        while($row = $ilDB->fetchAssoc($res))
                        {
                                $obj_id = $row['obj_id'];
                                $ilDB->manipulateF('
                                        DELETE FROM aicc_units WHERE obj_id = %s', 
                                        array('integer'), array($obj_id));                              
                        }
                
                $res = $ilDB->queryF('
                        SELECT * FROM aicc_object, aicc_course
                        WHERE aicc_object.obj_id = aicc_course.obj_id
                        AND aicc_object.slm_id = %s',
                        array('integer'), array($this->getId()));
                
                        while($row = $ilDB->fetchAssoc($res))
                        {
                                $obj_id = $row['obj_id'];
                                $ilDB->manipulateF('
                                DELETE FROM aicc_course WHERE obj_id = %s',
                                array('integer'), array($obj_id));              
                        }

                $ilDB->manipulateF('DELETE FROM scorm_tree WHERE slm_id = %s',
                array('integer'), array($this->getId()));

                $ilDB->manipulateF('DELETE FROM aicc_object WHERE slm_id = %s',
                array('integer'), array($this->getId()));

                $q_log = "DELETE FROM scorm_tracking WHERE obj_id = ".$ilDB->quote($this->getId());
                $ilLog->write("SAHS Delete (AICC LM): ".$q_log);
                $ilDB->manipulateF('DELETE FROM scorm_tracking WHERE obj_id = %s',
                array('integer'), array($this->getId()));

                // always call parent delete function at the end!!
                return true;
        }


        function getTrackingItems()
        {
                return ilObjAICCLearningModule::_getTrackingItems($this->getId());
        }


        function _getTrackingItems($a_obj_id)
        {
                global $ilDB;

                include_once("./Modules/ScormAicc/classes/AICC/class.ilAICCUnit.php");

                $statement = $ilDB->queryF('
                        SELECT obj_id,title FROM aicc_object 
                        WHERE slm_id = %s
                        AND c_type = %s ',
                        array('integer', 'text'),
                        array($a_obj_id,'sau')
                );
                
                while($row = $ilDB->fetchObject($statement))
                {
                        $items[$row->obj_id]['obj_id'] = $row->obj_id;
                        $items[$row->obj_id]['title'] = $row->title;

                }               
                
                return $items ? $items : array();

                /*
                include_once("./Modules/ScormAicc/classes/SCORM/class.ilSCORMTree.php");
                $tree = new ilSCORMTree($a_obj_id);
                $root_id = $tree->readRootId();

                $items = array();
                $childs = $tree->getSubTree($tree->getNodeData($root_id));
                foreach($childs as $child)
                {
                        if($child["c_type"] == "sau")
                        {
                                include_once("./Modules/ScormAicc/classes/AICC/class.ilAICCUnit.php");
                                $ac_item =& new ilAICCUnit($child["obj_id"]);
                                $items[count($items)] =& $ac_item;
                        }
                }

                return $items;
                */
        }

        function getTrackedItems()
        {
                global $ilUser, $ilDB, $ilUser;
        
                $sco_set = $ilDB->queryF('
                        SELECT DISTINCT sco_id FROM scorm_tracking WHERE obj_id = %s',
                        array('integer'), array($this->getId()));       
                        
                $items = array();       
                while($sco_rec = $ilDB->fetchAssoc($sco_set))
                {
                        include_once("./Modules/ScormAicc/classes/AICC/class.ilAICCUnit.php");  
                        $ac_item =& new ilAICCUnit($sco_rec["sco_id"]);
                        $items[count($items)] =& $ac_item;

                }               
                
                return $items;
        }

        function getTrackingData($a_sco_id)
        {
                global $ilDB;

                $data_set = $ilDB->queryF('
                SELECT * FROM scorm_tracking 
                WHERE obj_id = %s 
                AND sco_id = %s
                ORDER BY user_id, lvalue',
                array('integer', 'interger'),
                array($this->getId(), $a_sco_id));
                
                $data = array();
                while($data_rec = $ilDB->fetchAssoc($data_set))
                {
                        $data[] = $data_rec;
                }       
                return $data;
        }

} // END class.ilObjAICCLearningModule

?>