class.ilSCORMObject.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. |
    +-----------------------------------------------------------------------------+
*/


class ilSCORMObject
{
    public $id;
    public $title;
    public $type;
    public $slm_id;


    public function __construct($a_id = 0)
    {
        global $DIC;
        $ilias = $DIC['ilias'];

        $this->ilias = $ilias;
        $this->id = $a_id;
        if ($a_id > 0) {
            $this->read();
        }
    }

    public function getId()
    {
        return $this->id;
    }

    public function setId($a_id)
    {
        $this->id = $a_id;
    }

    public function getType()
    {
        return $this->type;
    }

    public function setType($a_type)
    {
        $this->type = $a_type;
    }

    public function getTitle()
    {
        return $this->title;
    }

    public function setTitle($a_title)
    {
        $this->title = $a_title;
    }

    public function getSLMId()
    {
        return $this->slm_id;
    }

    public function setSLMId($a_slm_id)
    {
        $this->slm_id = $a_slm_id;
    }

    public function read()
    {
        global $DIC;
        $ilDB = $DIC['ilDB'];
        
        $obj_set = $ilDB->queryF(
            'SELECT * FROM scorm_object WHERE obj_id = %s',
            array('integer'),
            array($this->getId())
        );
        $obj_rec = $ilDB->fetchAssoc($obj_set);
        $this->setTitle($obj_rec["title"]);
        $this->setType($obj_rec["c_type"]);
        $this->setSLMId($obj_rec["slm_id"]);
    }
    
    public static function _lookupPresentableItems($a_slm_id)
    {
        global $DIC;
        $ilDB = $DIC['ilDB'];
        
        $set = $ilDB->queryF(
            "
                        SELECT sit.obj_id id 
                        FROM scorm_object sob, sc_item sit
                        WHERE sob.slm_id = %s
                        AND sob.obj_id = sit.obj_id
                        AND sit.identifierref IS NOT NULL",
            array('integer'),
            array($a_slm_id)
        );
        $items = array();
        while ($rec = $ilDB->fetchAssoc($set)) {
            $items[] = $rec["id"];
        }
        
        return $items;
    }

    public function create()
    {
        global $DIC;
        $ilDB = $DIC['ilDB'];
      
        $nextId = $ilDB->nextId('scorm_object');
        $this->setId($nextId);
         
        $ilDB->manipulateF(
            '
        INSERT INTO scorm_object (obj_id,title, c_type, slm_id) 
        VALUES (%s,%s,%s,%s) ',
            array('integer','text','text','integer'),
            array($nextId, $this->getTitle(),$this->getType(), $this->getSLMId())
        );
    }

    public function update()
    {
        global $DIC;
        $ilDB = $DIC['ilDB'];
        
        $ilDB->manipulateF(
            '
        UPDATE scorm_object 
        SET title = %s,
                c_type = %s,
                slm_id = %s
        WHERE obj_id = %s',
            array('text','text','integer','integer'),
            array($this->getTitle(),$this->getType(), $this->getSLMId(),$this->getId())
        );
    }

    public function delete()
    {
        global $DIC;
        $ilDB = $DIC['ilDB'];
        $ilDB->manipulateF(
            'DELETE FROM scorm_object WHERE obj_id = %s',
            array('integer'),
            array($this->getId())
        );
    }

    public static function &_getInstance($a_id, $a_slm_id)
    {
        global $DIC;
        $ilDB = $DIC['ilDB'];

        $sc_set = $ilDB->queryF(
            '
                        SELECT c_type FROM scorm_object 
                        WHERE obj_id = %s
                        AND slm_id = %s',
            array('integer','integer'),
            array($a_id, $a_slm_id)
        );
        $sc_rec = $ilDB->fetchAssoc($sc_set);
            
        switch ($sc_rec["c_type"]) {
            case "sit":                                 // item
                include_once("./Modules/ScormAicc/classes/SCORM/class.ilSCORMItem.php");
                $item = new ilSCORMItem($a_id);
                return $item;
                break;

            case "sos":                                 // organizations
                include_once("./Modules/ScormAicc/classes/SCORM/class.ilSCORMOrganizations.php");
                $sos = new ilSCORMOrganizations($a_id);
                return $sos;
                break;

            case "sor":                                 // organization
                include_once("./Modules/ScormAicc/classes/SCORM/class.ilSCORMOrganization.php");
                $sor = new ilSCORMOrganization($a_id);
                return $sor;
                break;

            case "sma":                                 // manifest
                include_once("./Modules/ScormAicc/classes/SCORM/class.ilSCORMManifest.php");
                $sma = new ilSCORMManifest($a_id);
                return $sma;
                break;

            case "srs":                                 // resources
                include_once("./Modules/ScormAicc/classes/SCORM/class.ilSCORMResources.php");
                $srs = new ilSCORMResources($a_id);
                return $srs;
                break;

            case "sre":                                 // resource
                include_once("./Modules/ScormAicc/classes/SCORM/class.ilSCORMResource.php");
                $sre = new ilSCORMResource($a_id);
                return $sre;
                break;
        }
    }
}