ilWebDAVMountInstructionsRepositoryImpl Class Reference

Inheritance diagram for ilWebDAVMountInstructionsRepositoryImpl:

Collaboration diagram for ilWebDAVMountInstructionsRepositoryImpl:

Public Member Functions
	__construct (ilDBInterface $a_db)
	ilWebDAVMountInstructionsRepository constructor. More...
	createMountInstructionsDocumentEntry (ilWebDAVMountInstructionsDocument $document)
	getNextMountInstructionsDocumentId ()
	getHighestSortingNumber ()
	getMountInstructionsDocumentById (int $id)
	getMountInstructionsByLanguage (string $language)
	getAllMountInstructions ()
	doMountInstructionsExistByLanguage (string $language)
	updateMountInstructions (ilWebDAVMountInstructionsDocument $document)
	updateSortingValueById (int $id, int $a_new_sorting_value)
	deleteMountInstructionsById (int $id)

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.

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

    {
        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']
        );
    }

Here is the caller graph for this function:

createMountInstructionsDocumentEntry()

ilWebDAVMountInstructionsRepositoryImpl::createMountInstructionsDocumentEntry

(

ilWebDAVMountInstructionsDocument

$document

)

Implements ilWebDAVMountInstructionsRepository.

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

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

    {
        $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())
        )
        );
    }

Here is the call graph for this function:

deleteMountInstructionsById()

ilWebDAVMountInstructionsRepositoryImpl::deleteMountInstructionsById

(

int

$id

)

Implements ilWebDAVMountInstructionsRepository.

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

References $query.

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

        $this->db->manipulate($query);
    }

doMountInstructionsExistByLanguage()

ilWebDAVMountInstructionsRepositoryImpl::doMountInstructionsExistByLanguage

(

string

$language

)

Implements ilWebDAVMountInstructionsRepository.

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

References $query, and $result.

                                                                         : 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']);
    }

getAllMountInstructions()

ilWebDAVMountInstructionsRepositoryImpl::getAllMountInstructions

(

)

Implements ilWebDAVMountInstructionsRepository.

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

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

                                              : 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;
    }

Here is the call graph for this function:

getHighestSortingNumber()

ilWebDAVMountInstructionsRepositoryImpl::getHighestSortingNumber

(

)

Implements ilWebDAVMountInstructionsRepository.

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

References $query, and $result.

                                              : 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;
    }

getMountInstructionsByLanguage()

ilWebDAVMountInstructionsRepositoryImpl::getMountInstructionsByLanguage

(

string

$language

)

Implements ilWebDAVMountInstructionsRepository.

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

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

                                                                     : 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);
    }

Here is the call graph for this function:

getMountInstructionsDocumentById()

ilWebDAVMountInstructionsRepositoryImpl::getMountInstructionsDocumentById

(

int

$id

)

Implements ilWebDAVMountInstructionsRepository.

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

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

                                                              : 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);
    }

Here is the call graph for this function:

getNextMountInstructionsDocumentId()

ilWebDAVMountInstructionsRepositoryImpl::getNextMountInstructionsDocumentId

(

)

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

)

Implements ilWebDAVMountInstructionsRepository.

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

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

    {
        $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()),
            )
        );
    }

Here is the call graph for this function:

updateSortingValueById()

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

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