ilWebDAVMountInstructionsRepositoryImpl Class Reference

Inheritance diagram for ilWebDAVMountInstructionsRepositoryImpl:

Collaboration diagram for ilWebDAVMountInstructionsRepositoryImpl:

Public Member Functions
	__construct (ilDBInterface $a_db)
	ilWebDAVMountInstructionsRepository constructor. More...
	createMountInstructionsDocumentEntry (ilWebDAVMountInstructionsDocument $document)
	@inheritDoc More...
	getNextMountInstructionsDocumentId ()
	@inheritDoc More...
	getHighestSortingNumber ()
	@inheritDoc More...
	getMountInstructionsDocumentById (int $id)
	@inheritDoc More...
	getMountInstructionsByLanguage (string $language)
	@inheritDoc More...
	getAllMountInstructions ()
	@inheritDoc More...
	doMountInstructionsExistByLanguage (string $language)
	@inheritDoc More...
	updateMountInstructions (ilWebDAVMountInstructionsDocument $document)
	@inheritDoc More...
	updateSortingValueById (int $id, int $a_new_sorting_value)
	@inheritDoc More...
	deleteMountInstructionsById (int $id)
	@inheritDoc More...
	createMountInstructionsDocumentEntry (ilWebDAVMountInstructionsDocument $document)
	Create new database entry for given mount instructions document. More...
	getNextMountInstructionsDocumentId ()
	Return next free ID for mount instructions document. More...
	getHighestSortingNumber ()
	Get currently highest sorting number for mount instructions document. More...
	getMountInstructionsDocumentById (int $id)
	Gets mount instructions document by id. More...
	getMountInstructionsByLanguage (string $language)
	Gets mount instructions document by language -> language is two letters like "en" for English etc. More...
	getAllMountInstructions ()
	Returns an array with all existing mount instructions documents. More...
	doMountInstructionsExistByLanguage (string $language)
	Check if mount instructions for language exists. More...
	updateMountInstructions (ilWebDAVMountInstructionsDocument $document)
	Update existing mount instructions document. More...
	updateSortingValueById (int $id, int $a_new_sorting_value)
	Update sorting value of a mount instructions document. More...
	deleteMountInstructionsById (int $id)
	Delete mount instructions document by id. More...

Data Fields
const	TABLE_MOUNT_INSTRUCTIONS = 'webdav_instructions'

Protected Member Functions
	buildDocumentFromDatabaseRecord (array $result)
	Fills document with results array from database. More...

Protected Attributes
	$db

Detailed Description

Definition at line 4 of file class.ilWebDAVMountInstructionsRepositoryImpl.php.

Constructor & Destructor Documentation

__construct()

ilWebDAVMountInstructionsRepositoryImpl::__construct

(

ilDBInterface

$a_db

)

ilWebDAVMountInstructionsRepository constructor.

Parameters

ilDBInterface

$a_db

Definition at line 16 of file class.ilWebDAVMountInstructionsRepositoryImpl.php.

    {
        $this->db = $a_db;
    }

Member Function Documentation

buildDocumentFromDatabaseRecord()

ilWebDAVMountInstructionsRepositoryImpl::buildDocumentFromDatabaseRecord ( array  $result )

protected

Fills document with results array from database.

Parameters

array

$result

Returns

ilWebDAVMountInstructionsDocument

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

    {
        return new ilWebDAVMountInstructionsDocument(
            $result['id'],
            $result['title'],
            $result['uploaded_instructions'],
            $result['processed_instructions'],
            $result['lng'],
            $result['creation_ts'],
            $result['modification_ts'],
            $result['owner_usr_id'],
            $result['last_modification_usr_id'],
            $result['sorting']
        );
    }

References $result.

Referenced by getAllMountInstructions(), getMountInstructionsByLanguage(), and getMountInstructionsDocumentById().

Here is the caller graph for this function:

createMountInstructionsDocumentEntry()

ilWebDAVMountInstructionsRepositoryImpl::createMountInstructionsDocumentEntry

(

ilWebDAVMountInstructionsDocument

$document

)

@inheritDoc

Implements ilWebDAVMountInstructionsRepository.

Definition at line 24 of file class.ilWebDAVMountInstructionsRepositoryImpl.php.

    {
        $this->db->insert(
            // table
            self::TABLE_MOUNT_INSTRUCTIONS,
 
            // values
            array(
            'id' => array('int', $document->getId()),
            'title' => array('text', $document->getTitle()),
            'uploaded_instructions' => array('clob', $document->getUploadedInstructions()),
            'processed_instructions' => array('clob', $document->getProcessedInstructions()),
            'lng' => array('text', $document->getLanguage()),
            'creation_ts' => array('timestamp', $document->getCreationTs()),
            'modification_ts' => array('timestamp', $document->getModificationTs()),
            'owner_usr_id' => array('int', $document->getOwnerUsrId()),
            'last_modification_usr_id' => array('int', $document->getLastModificationUsrId()),
            'sorting' => array('int', $document->getSorting())
        )
        );
    }

References ilWebDAVMountInstructionsDocument\getCreationTs(), ilWebDAVMountInstructionsDocument\getId(), ilWebDAVMountInstructionsDocument\getLanguage(), ilWebDAVMountInstructionsDocument\getLastModificationUsrId(), ilWebDAVMountInstructionsDocument\getModificationTs(), ilWebDAVMountInstructionsDocument\getOwnerUsrId(), ilWebDAVMountInstructionsDocument\getProcessedInstructions(), ilWebDAVMountInstructionsDocument\getSorting(), ilWebDAVMountInstructionsDocument\getTitle(), and ilWebDAVMountInstructionsDocument\getUploadedInstructions().

Here is the call graph for this function:

deleteMountInstructionsById()

ilWebDAVMountInstructionsRepositoryImpl::deleteMountInstructionsById

(

int

$id

)

@inheritDoc

Implements ilWebDAVMountInstructionsRepository.

Definition at line 187 of file class.ilWebDAVMountInstructionsRepositoryImpl.php.

    {
        $query = "DELETE FROM " . $this->db->quoteIdentifier(self::TABLE_MOUNT_INSTRUCTIONS)
            . ' WHERE id=' . $this->db->quote($id, 'integer');
 
        $this->db->manipulate($query);
    }

References $query.

doMountInstructionsExistByLanguage()

ilWebDAVMountInstructionsRepositoryImpl::doMountInstructionsExistByLanguage

(

string

$language

)

@inheritDoc

Implements ilWebDAVMountInstructionsRepository.

Definition at line 125 of file class.ilWebDAVMountInstructionsRepositoryImpl.php.

                                                                         : int
    {
        $query = "SELECT * FROM " . $this->db->quoteIdentifier(self::TABLE_MOUNT_INSTRUCTIONS)
            . " WHERE lng=" . $this->db->quote($language, 'text');
 
        $result = $this->db->query($query);
        $record = $this->db->fetchAssoc($result);
 
        return ($record == null ? 0 : $record['id']);
    }

References $query, and $result.

getAllMountInstructions()

ilWebDAVMountInstructionsRepositoryImpl::getAllMountInstructions

(

)

@inheritDoc

Implements ilWebDAVMountInstructionsRepository.

Definition at line 109 of file class.ilWebDAVMountInstructionsRepositoryImpl.php.

                                              : array
    {
        $query = "SELECT * FROM " . $this->db->quoteIdentifier(self::TABLE_MOUNT_INSTRUCTIONS) . " ORDER BY sorting";
        $result = $this->db->query($query);
 
        $document_list = array();
        while ($record = $this->db->fetchAssoc($result)) {
            $document_list[] = $this->buildDocumentFromDatabaseRecord($record);
        }
 
        return $document_list;
    }

References $query, $result, and buildDocumentFromDatabaseRecord().

Here is the call graph for this function:

getHighestSortingNumber()

ilWebDAVMountInstructionsRepositoryImpl::getHighestSortingNumber

(

)

@inheritDoc

Implements ilWebDAVMountInstructionsRepository.

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

                                              : int
    {
        $query = "SELECT max(sorting) as max_sort FROM " . $this->db->quoteIdentifier(self::TABLE_MOUNT_INSTRUCTIONS);
        $result = $this->db->query($query);
 
        $row = $this->db->fetchAssoc($result);
        return isset($row) && !is_null($row['max_sort']) ? $row['max_sort'] : 0;
    }

References $query, and $result.

getMountInstructionsByLanguage()

ilWebDAVMountInstructionsRepositoryImpl::getMountInstructionsByLanguage

(

string

$language

)

@inheritDoc

Implements ilWebDAVMountInstructionsRepository.

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

                                                                     : ilWebDAVMountInstructionsDocument
    {
        $query = "SELECT * FROM " . $this->db->quoteIdentifier(self::TABLE_MOUNT_INSTRUCTIONS)
            . " WHERE lng=" . $this->db->quote($language, 'text');
 
        $result = $this->db->query($query);
        $record = $this->db->fetchAssoc($result);
 
        if (!$record) {
            throw new InvalidArgumentException("Document for the language $language not found");
        }
 
        return $this->buildDocumentFromDatabaseRecord($record);
    }

References $query, $result, and buildDocumentFromDatabaseRecord().

Here is the call graph for this function:

getMountInstructionsDocumentById()

ilWebDAVMountInstructionsRepositoryImpl::getMountInstructionsDocumentById

(

int

$id

)

@inheritDoc

Implements ilWebDAVMountInstructionsRepository.

Definition at line 73 of file class.ilWebDAVMountInstructionsRepositoryImpl.php.

                                                              : ilWebDAVMountInstructionsDocument
    {
        $query = "SELECT * FROM " . $this->db->quoteIdentifier(self::TABLE_MOUNT_INSTRUCTIONS)
            . " WHERE id=" . $this->db->quote($id, 'int');
 
        $result = $this->db->query($query);
        $record = $this->db->fetchAssoc($result);
 
        if (!$record) {
            throw new InvalidArgumentException("Document with the id $id not found");
        }
 
        return $this->buildDocumentFromDatabaseRecord($record);
    }

References $query, $result, and buildDocumentFromDatabaseRecord().

Here is the call graph for this function:

getNextMountInstructionsDocumentId()

ilWebDAVMountInstructionsRepositoryImpl::getNextMountInstructionsDocumentId

(

)

@inheritDoc

Implements ilWebDAVMountInstructionsRepository.

Definition at line 49 of file class.ilWebDAVMountInstructionsRepositoryImpl.php.

                                                         : int
    {
        if (!$this->db->sequenceExists(self::TABLE_MOUNT_INSTRUCTIONS)) {
            $this->db->createSequence(self::TABLE_MOUNT_INSTRUCTIONS);
        }
 
        return $this->db->nextId(self::TABLE_MOUNT_INSTRUCTIONS);
    }

updateMountInstructions()

ilWebDAVMountInstructionsRepositoryImpl::updateMountInstructions

(

ilWebDAVMountInstructionsDocument

$document

)

@inheritDoc

Implements ilWebDAVMountInstructionsRepository.

Definition at line 139 of file class.ilWebDAVMountInstructionsRepositoryImpl.php.

    {
        $this->db->update(
            // table name
            self::TABLE_MOUNT_INSTRUCTIONS,
 
            // values to update
            array(
                'title' => array('text', $document->getTitle()),
                'lng' => array('text', $document->getLanguage()),
                'creation_ts' => array('timestamp', $document->getCreationTs()),
                'modification_ts' => array('timestamp', $document->getModificationTs()),
                'owner_usr_id' => array('int', $document->getOwnerUsrId()),
                'last_modification_usr_id' => array('int', $document->getLastModificationUsrId()),
                'sorting' => array('int', $document->getSorting())
            ),
 
            // which rows to update
            array(
                'id' => array('int', $document->getId()),
            )
        );
    }

References ilWebDAVMountInstructionsDocument\getCreationTs(), ilWebDAVMountInstructionsDocument\getId(), ilWebDAVMountInstructionsDocument\getLanguage(), ilWebDAVMountInstructionsDocument\getLastModificationUsrId(), ilWebDAVMountInstructionsDocument\getModificationTs(), ilWebDAVMountInstructionsDocument\getOwnerUsrId(), ilWebDAVMountInstructionsDocument\getSorting(), and ilWebDAVMountInstructionsDocument\getTitle().

Here is the call graph for this function:

updateSortingValueById()

ilWebDAVMountInstructionsRepositoryImpl::updateSortingValueById	(	int	$id,
		int	$a_new_sorting_value
	)

@inheritDoc

Implements ilWebDAVMountInstructionsRepository.

Definition at line 166 of file class.ilWebDAVMountInstructionsRepositoryImpl.php.

    {
        $this->db->update(
        // table name
            self::TABLE_MOUNT_INSTRUCTIONS,
 
            // values to update
            array(
                'sorting' => array('int', $a_new_sorting_value)
            ),
 
            // which rows to update
            array(
                'id' => array('int', $id),
            )
        );
    }

Field Documentation

$db

ilWebDAVMountInstructionsRepositoryImpl::$db

protected

Definition at line 9 of file class.ilWebDAVMountInstructionsRepositoryImpl.php.

TABLE_MOUNT_INSTRUCTIONS

const ilWebDAVMountInstructionsRepositoryImpl::TABLE_MOUNT_INSTRUCTIONS = 'webdav_instructions'

Definition at line 6 of file class.ilWebDAVMountInstructionsRepositoryImpl.php.

---

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

• Services/WebDAV/classes/mount_instructions/class.ilWebDAVMountInstructionsRepositoryImpl.php