SCORM Resource. More...

Inheritance diagram for ilSCORMResource:

Collaboration diagram for ilSCORMResource:

Public Member Functions
	__construct ($a_id=0)
	Constructor. More...

	getImportId ()

	setImportId ($a_import_id)

	getResourceType ()

	setResourceType ($a_type)

	getScormType ()

	setScormType ($a_scormtype)

	getHRef ()

	setHRef ($a_href)

	getXmlBase ()

	setXmlBase ($a_xml_base)

	addFile (&$a_file_obj)

&	getFiles ()

	addDependency (&$a_dependency)

&	getDependencies ()

	read ()

	readByIdRef ($a_id_ref, $a_slm_id)

	create ()
	Create database record for SCORM object. More...

	update ()
	Updates database record for SCORM object. More...

	delete ()

Public Member Functions inherited from ilSCORMObject
	__construct ($a_id=0)
	Constructor. More...

	getId ()

	setId ($a_id)

	getType ()

	setType ($a_type)

	getTitle ()

	setTitle ($a_title)

	getSLMId ()

	setSLMId ($a_slm_id)

	read ()

	create ()
	Create database record for SCORM object. More...

	update ()
	Updates database record for SCORM object. More...

	delete ()

Static Public Member Functions
static	_lookupIdByIdRef ($a_id_ref, $a_slm_id)

static	_lookupScormType ($a_obj_id)

Static Public Member Functions inherited from ilSCORMObject
static	_lookupPresentableItems ($a_slm_id)
	Count number of presentable SCOs/Assets of SCORM learning module. More...

static &	_getInstance ($a_id, $a_slm_id)
	get instance of specialized GUI class More...

Data Fields
	$import_id

	$resourcetype

	$scormtype

	$href

	$xml_base

	$files

	$dependencies

Data Fields inherited from ilSCORMObject
	$id

	$title

	$type

	$slm_id

Detailed Description

SCORM Resource.

Author: Alex Killing alex..nosp@m.kill.nosp@m.ing@g.nosp@m.mx.d.nosp@m.e

Version: $Id$

Definition at line 36 of file class.ilSCORMResource.php.

Constructor & Destructor Documentation

◆ __construct()

ilSCORMResource::__construct ( $a_id = 0 )

Constructor.

Parameters

int $a_id Object ID @access public

Reimplemented from ilSCORMObject.

Definition at line 53 of file class.ilSCORMResource.php.

    {
        $this->files = array();
        $this->dependencies = array();
        $this->setType("sre");
        parent::__construct($a_id);
    }

References ILIAS\GlobalScreen\Provider\__construct(), and ilSCORMObject\setType().

Here is the call graph for this function:

Member Function Documentation

◆ _lookupIdByIdRef()

static ilSCORMResource::_lookupIdByIdRef	(	$a_id_ref,
		$a_slm_id
	)

static

Definition at line 201 of file class.ilSCORMResource.php.

    {
        global $DIC;
        $ilBench = $DIC['ilBench'];
        $ilDB = $DIC['ilDB'];
        
        $id_set = $ilDB->queryF(
            'SELECT ob.obj_id id FROM sc_resource res, scorm_object ob
                        WHERE ob.obj_id = res.obj_id 
                        AND res.import_id = %s 
                        AND ob.slm_id = %s',
            array('text', 'integer'),
            array($a_id_ref ,$a_slm_id)
        );
        
        if ($id_rec = $ilDB->fetchAssoc($id_set)) {
            return $id_rec["id"];
        }
        return 0;
    }

References $DIC, $ilBench, and $ilDB.

Referenced by ilSCORMPresentationGUI\api(), and ilSCORMExplorer\insertObject().

Here is the caller graph for this function:

◆ _lookupScormType()

static ilSCORMResource::_lookupScormType ( $a_obj_id )

static

Definition at line 222 of file class.ilSCORMResource.php.

    {
        global $DIC;
        $ilDB = $DIC['ilDB'];
        
        $st_set = $ilDB->queryF(
            'SELECT scormtype FROM sc_resource WHERE obj_id = %s',
            array('integer'),
            array($a_obj_id)
        );
        if ($st_rec = $ilDB->fetchAssoc($st_set)) {
            return $st_rec["scormtype"];
        }
        return "";
    }

References $DIC, and $ilDB.

Referenced by ilSCORMPresentationGUI\api(), and ilSCORMExplorer\insertObject().

Here is the caller graph for this function:

◆ addDependency()

ilSCORMResource::addDependency ( & $a_dependency )

Definition at line 122 of file class.ilSCORMResource.php.

    {
        $this->dependencies[] = &$a_dependency;
    }

Referenced by read().

Here is the caller graph for this function:

◆ addFile()

ilSCORMResource::addFile ( & $a_file_obj )

Definition at line 112 of file class.ilSCORMResource.php.

    {
        $this->files[] = &$a_file_obj;
    }

Referenced by read().

Here is the caller graph for this function:

◆ create()

ilSCORMResource::create ( )

Create database record for SCORM object.

Reimplemented from ilSCORMObject.

Definition at line 238 of file class.ilSCORMResource.php.

    {
        global $DIC;
        $ilDB = $DIC['ilDB'];
        
        parent::create();
 
        $ilDB->manipulateF(
            '
                        INSERT INTO sc_resource 
                        (obj_id, import_id, resourcetype, scormtype, href, xml_base) 
                        VALUES(%s, %s, %s, %s, %s, %s)',
            array('integer','text','text','text','text','text'),
            array(      $this->getId(),
                    $this->getImportId(),
                    $this->getResourceType(),
                    $this->getScormType(),
                    $this->getHref(),
                    $this->getXmlBase()
            )
        );
 
        // save files
        for ($i = 0; $i < count($this->files); $i++) {
            $nextId = $ilDB->nextId('sc_resource_file');
 
            $ilDB->manipulateF(
                '
                                INSERT INTO sc_resource_file (id,res_id, href, nr) 
                                VALUES(%s, %s, %s, %s)',
                array('integer', 'integer', 'text', 'integer'),
                array($nextId, $this->getId(), $this->files[$i]->getHref(), ($i + 1))
            );
        }
 
        // save dependencies
        for ($i = 0; $i < count($this->dependencies); $i++) {
            $nextId = $ilDB->nextId('sc_resource_dependen');
 
            $ilDB->manipulateF(
                '
                                INSERT INTO sc_resource_dependen (id, res_id, identifierref, nr)
                                VALUES(%s, %s, %s, %s)',
                array('integer', 'integer', 'text', 'integer'),
                array($nextId, $this->getId(), $this->files[$i]->getHref(), ($i + 1))
            );
        }
    }

References $DIC, $i, $ilDB, ilSCORMObject\getId(), getImportId(), getResourceType(), getScormType(), and getXmlBase().

Here is the call graph for this function:

◆ delete()

ilSCORMResource::delete ( )

Reimplemented from ilSCORMObject.

Definition at line 350 of file class.ilSCORMResource.php.

    {
        global $DIC;
        $ilDB = $DIC['ilDB'];
 
        parent::delete();
 
        $ilDB->manipulateF(
            'DELETE FROM sc_resource WHERE obj_id = %s',
            array('integer'),
            array($this->getId())
        );
 
        $ilDB->manipulateF(
            'DELETE FROM sc_resource_file WHERE res_id = %s',
            array('integer'),
            array($this->getId())
        );
 
        $ilDB->manipulateF(
            'DELETE FROM sc_resource_dependen WHERE res_id = %s',
            array('integer'),
            array($this->getId())
        );
    }

References $DIC, $ilDB, and ilSCORMObject\getId().

Here is the call graph for this function:

◆ getDependencies()

& ilSCORMResource::getDependencies ( )

Definition at line 127 of file class.ilSCORMResource.php.

    {
        return $this->dependencies;
    }

References $dependencies.

◆ getFiles()

& ilSCORMResource::getFiles ( )

Definition at line 117 of file class.ilSCORMResource.php.

    {
        return $this->files;
    }

References $files.

◆ getHRef()

ilSCORMResource::getHRef ( )

Definition at line 91 of file class.ilSCORMResource.php.

    {
        return $this->href;
    }

References $href.

Referenced by update().

Here is the caller graph for this function:

◆ getImportId()

ilSCORMResource::getImportId ( )

Definition at line 61 of file class.ilSCORMResource.php.

    {
        return $this->import_id;
    }

References $import_id.

Referenced by create(), and update().

Here is the caller graph for this function:

◆ getResourceType()

ilSCORMResource::getResourceType ( )

Definition at line 71 of file class.ilSCORMResource.php.

    {
        return $this->resourcetype;
    }

References $resourcetype.

Referenced by create(), and update().

Here is the caller graph for this function:

◆ getScormType()

ilSCORMResource::getScormType ( )

Definition at line 81 of file class.ilSCORMResource.php.

    {
        return $this->scormtype;
    }

References $scormtype.

Referenced by create(), and update().

Here is the caller graph for this function:

◆ getXmlBase()

ilSCORMResource::getXmlBase ( )

Definition at line 102 of file class.ilSCORMResource.php.

    {
        return $this->xml_base;
    }

References $xml_base.

Referenced by create(), and update().

Here is the caller graph for this function:

◆ read()

ilSCORMResource::read ( )

Reimplemented from ilSCORMObject.

Definition at line 132 of file class.ilSCORMResource.php.

    {
        global $DIC;
        $ilDB = $DIC['ilDB'];
        
        parent::read();
    
        $obj_set = $ilDB->queryF(
            'SELECT * FROM sc_resource WHERE obj_id = %s',
            array('integer'),
            array($this->getId())
        );
        $obj_rec = $ilDB->fetchAssoc($obj_set);
        $this->setImportId($obj_rec["import_id"]);
        $this->setResourceType($obj_rec["resourcetype"]);
        $this->setScormType($obj_rec["scormtype"]);
        $this->setHRef($obj_rec["href"]);
        $this->setXmlBase($obj_rec["xml_base"]);
 
        // read files
        $file_set = $ilDB->queryF(
            'SELECT href FROM sc_resource_file WHERE res_id = %s ORDER BY nr',
            array('integer'),
            array($this->getId())
        );
        while ($file_rec = $ilDB->fetchAssoc($file_set)) {
            $res_file = new ilSCORMResourceFile();
            $res_file->setHref($file_rec["href"]);
            $this->addFile($res_file);
        }
        // read dependencies
 
        $dep_set = $ilDB->queryF(
            'SELECT identifierref FROM sc_resource_dependen WHERE res_id = %s ORDER BY nr',
            array('integer'),
            array($this->getId())
        );
        while ($dep_rec = $ilDB->fetchAssoc($dep_set)) {
            $res_dep = new ilSCORMResourceDependency();
            $res_dep->setIdentifierRef($dep_rec["identifierref"]);
            $this->addDependency($res_dep);
        }
    }

References $DIC, $ilDB, addDependency(), addFile(), ilSCORMObject\getId(), setHRef(), setImportId(), setResourceType(), setScormType(), and setXmlBase().

Referenced by readByIdRef().

Here is the call graph for this function:

Here is the caller graph for this function:

◆ readByIdRef()

ilSCORMResource::readByIdRef	(	$a_id_ref,
		$a_slm_id
	)

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

    {
        global $DIC;
        $ilBench = $DIC['ilBench'];
        $ilDB = $DIC['ilDB'];
        
        $ilBench->start("SCORMResource", "readByIdRef_Query");
        
        $id_set = $ilDB->queryF(
            'SELECT ob.obj_id id FROM sc_resource res, scorm_object ob
                        WHERE ob.obj_id = res.obj_id 
                        AND res.import_id = %s 
                        AND ob.slm_id = %s',
            array('text', 'integer'),
            array($a_id_ref, $a_slm_id)
        );
        
        $ilBench->stop("SCORMResource", "readByIdRef_Query");
        
        if ($id_rec = $ilDB->fetchAssoc($id_set)) {
            $this->setId($id_rec["id"]);
            $this->read();
        }
    }

References $DIC, $ilBench, $ilDB, read(), and ilSCORMObject\setId().

Here is the call graph for this function:

◆ setHRef()

ilSCORMResource::setHRef ( $a_href )

Definition at line 96 of file class.ilSCORMResource.php.

    {
        $this->href = $a_href;
        $this->setTitle($a_href);
    }

References ilSCORMObject\setTitle().

Referenced by read().

Here is the call graph for this function:

Here is the caller graph for this function:

◆ setImportId()

ilSCORMResource::setImportId ( $a_import_id )

Definition at line 66 of file class.ilSCORMResource.php.

    {
        $this->import_id = $a_import_id;
    }

Referenced by read().

Here is the caller graph for this function:

◆ setResourceType()

ilSCORMResource::setResourceType ( $a_type )

Definition at line 76 of file class.ilSCORMResource.php.

    {
        $this->resourcetype = $a_type;
    }

Referenced by read().

Here is the caller graph for this function:

◆ setScormType()

ilSCORMResource::setScormType ( $a_scormtype )

Definition at line 86 of file class.ilSCORMResource.php.

    {
        $this->scormtype = $a_scormtype;
    }

Referenced by read().

Here is the caller graph for this function:

◆ setXmlBase()

ilSCORMResource::setXmlBase ( $a_xml_base )

Definition at line 107 of file class.ilSCORMResource.php.

    {
        $this->xml_base = $a_xml_base;
    }

Referenced by read().

Here is the caller graph for this function:

◆ update()

ilSCORMResource::update ( )

Updates database record for SCORM object.

Reimplemented from ilSCORMObject.

Definition at line 287 of file class.ilSCORMResource.php.

    {
        global $DIC;
        $ilDB = $DIC['ilDB'];
        
        parent::update();
 
        $ilDB->manipulateF(
            '
                        UPDATE sc_resource 
                        SET import_id = %s,
                                resourcetype = %s,
                                scormtype = %s,
                                href = %s,
                                xml_base = %s
                        WHERE obj_id = %s',
            array('text', 'text', 'text', 'text', 'text', 'integer'),
            array(      $this->getImportId(),
                    $this->getResourceType(),
                    $this->getScormType(),
                    $this->getHRef(),
                    $this->getXmlBase(),
                    $this->getId())
        );
 
        // save files
        $ilDB->manipulateF(
            'DELETE FROM sc_resource_file WHERE res_id = %s',
            array('integer'),
            array($this->getId())
        );
        
        for ($i = 0; $i < count($this->files); $i++) {
            $nextId = $ilDB->nextId('sc_resource_file');
            
            $ilDB->manipulateF(
                'INSERT INTO sc_resource_file (id, res_id, href, nr) 
                                VALUES (%s, %s, %s, %s)',
                array('integer', 'integer', 'text', 'integer'),
                array($nextId, $this->getId(), $this->files[$i]->getHref(), ($i + 1))
            );
        }
 
        // save dependencies
        $ilDB->manipulateF(
            'DELETE FROM sc_resource_dependen WHERE res_id = %s',
            array('integer'),
            array($this->getId())
        );
        
        for ($i = 0; $i < count($this->dependencies); $i++) {
            $nextId = $ilDB->nextId('sc_resource_dependen');
 
            $ilDB->manipulateF(
                '
                                INSERT INTO sc_resource_dependen (id, res_id, identifierref, nr) VALUES
                                (%s, %s, %s, %s) ',
                array('integer', 'integer', 'text', 'integer'),
                array($nextId, $this->getId(), $this->dependencies[$i]->getIdentifierRef(), ($i + 1))
            );
        }
    }

References $DIC, $i, $ilDB, getHRef(), ilSCORMObject\getId(), getImportId(), getResourceType(), getScormType(), and getXmlBase().

Here is the call graph for this function:

Field Documentation

◆ $dependencies

ilSCORMResource::$dependencies

Definition at line 44 of file class.ilSCORMResource.php.

Referenced by getDependencies().

◆ $files

ilSCORMResource::$files

Definition at line 43 of file class.ilSCORMResource.php.

Referenced by getFiles().

◆ $href

ilSCORMResource::$href

Definition at line 41 of file class.ilSCORMResource.php.

Referenced by getHRef().

◆ $import_id

ilSCORMResource::$import_id

Definition at line 38 of file class.ilSCORMResource.php.

Referenced by getImportId().

◆ $resourcetype

ilSCORMResource::$resourcetype

Definition at line 39 of file class.ilSCORMResource.php.

Referenced by getResourceType().

◆ $scormtype

ilSCORMResource::$scormtype

Definition at line 40 of file class.ilSCORMResource.php.

Referenced by getScormType().

◆ $xml_base

ilSCORMResource::$xml_base

Definition at line 42 of file class.ilSCORMResource.php.

Referenced by getXmlBase().

The documentation for this class was generated from the following file:

Modules/ScormAicc/classes/SCORM/class.ilSCORMResource.php

Public Member Functions

Static Public Member Functions

Data Fields

Detailed Description

Constructor & Destructor Documentation

◆ __construct()

Member Function Documentation

◆ _lookupIdByIdRef()

◆ _lookupScormType()

◆ addDependency()

◆ addFile()

◆ create()

◆ delete()

◆ getDependencies()

◆ getFiles()

◆ getHRef()

◆ getImportId()

◆ getResourceType()

◆ getScormType()

◆ getXmlBase()

◆ read()

◆ readByIdRef()

◆ setHRef()

◆ setImportId()

◆ setResourceType()

◆ setScormType()

◆ setXmlBase()

◆ update()

Field Documentation

◆ $dependencies

◆ $files

◆ $href

◆ $import_id

◆ $resourcetype

◆ $scormtype

◆ $xml_base