ilWebLinkDatabaseRepository Class Reference

This file is part of ILIAS, a powerful learning management system published by ILIAS open source e-Learning e.V. More...

Inheritance diagram for ilWebLinkDatabaseRepository:

Collaboration diagram for ilWebLinkDatabaseRepository:

Public Member Functions
	__construct (int $webr_id, bool $update_history=true)
	createItem (ilWebLinkDraftItem $item)
	Creates a new item, complete with parameters. More...
	createList (ilWebLinkDraftList $list)
	createAllItemsInDraftContainer (ilWebLinkDraftItemsContainer $container)
	getAllItemsAsContainer (bool $only_active=false)
	getItemByLinkId (int $link_id)
	doesOnlyOneItemExist (bool $only_active=false)
	getParameterinItemByParamId (ilWebLinkItem $item, int $param_id)
	getList ()
	doesListExist ()
	updateItem (ilWebLinkItem $item, ilWebLinkDraftItem $drafted_item)
	Updates an item. More...
	updateList (ilWebLinkList $list, ilWebLinkDraftList $drafted_list)
	deleteAllItems ()
	deleteItemByLinkID (int $link_id)
	deleteParameterByLinkIdAndParamId (int $link_id, int $param_id)
	deleteList ()
	getWebrId ()
	isUpdateHistory ()
	setUpdateHistory (bool $update_history)

Data Fields
const	ITEMS_TABLE = 'webr_items'
const	LISTS_TABLE = 'webr_lists'
const	PARAMS_TABLE = 'webr_params'

Protected Member Functions
	getParametersByLinkId (int $link_id)
	validateParameter (ilWebLinkBaseParameter $parameter)
	validateInternalItemTarget (ilWebLinkDraftItem $item)
	getCurrentTime ()
	getNewDateTimeImmutable ()

Protected Attributes
int	$webr_id
ilDBInterface	$db
ilObjUser	$user
bool	$update_history

Detailed Description

This file is part of ILIAS, a powerful learning management system published by ILIAS open source e-Learning e.V.

ILIAS is licensed with the GPL-3.0, see https://www.gnu.org/licenses/gpl-3.0.en.html You should have received a copy of said license along with the source code, too.

If this is not the case or you just want to try ILIAS, you'll find us at: https://www.ilias.de https://github.com/ILIAS-eLearning

Author

Tim Schmitz schmi.nosp@m.tz@l.nosp@m.eifos.nosp@m..de

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

Constructor & Destructor Documentation

__construct()

ilWebLinkDatabaseRepository::__construct	(	int	$webr_id,
		bool	$update_history = true
	)

Definition at line 35 of file class.ilWebLinkDatabaseRepository.php.

References $DIC, $update_history, $webr_id, and ILIAS\Repository\user().

    {
        global $DIC;

        $this->db = $DIC->database();
        $this->user = $DIC->user();
        $this->webr_id = $webr_id;
        $this->update_history = $update_history;
    }

Here is the call graph for this function:

Member Function Documentation

createAllItemsInDraftContainer()

ilWebLinkDatabaseRepository::createAllItemsInDraftContainer

(

ilWebLinkDraftItemsContainer

$container

)

Implements ilWebLinkRepository.

Definition at line 167 of file class.ilWebLinkDatabaseRepository.php.

References createItem(), ilWebLinkDraftItemsContainer\getItems(), and getWebrId().

Referenced by ilObjLinkResource\cloneObject().

                                                                                           : ilWebLinkItemsContainer
    {
        $new_items = [];

        foreach ($container->getItems() as $item) {
            $new_items[] = $this->createItem($item);
        }

        return new ilWebLinkItemsContainer(
            $this->getWebrId(),
            $new_items
        );
    }

Here is the call graph for this function:

Here is the caller graph for this function:

createItem()

ilWebLinkDatabaseRepository::createItem

(

ilWebLinkDraftItem

$item

)

Creates a new item, complete with parameters.

New parameters cannot be created on their own, but only by adding them as drafts to a drafted item, and then updating or creating with it.

Implements ilWebLinkRepository.

Definition at line 45 of file class.ilWebLinkDatabaseRepository.php.

References Vendor\Package\$e, ilHistory\_createEntry(), ilWebLinkBaseItem\getDescription(), getNewDateTimeImmutable(), ilWebLinkBaseItem\getParameters(), ilWebLinkBaseItem\getTarget(), ilWebLinkBaseItem\getTitle(), getWebrId(), ILIAS\Repository\int(), ilWebLinkBaseItem\isActive(), ilWebLinkDraftItem\isInternal(), isUpdateHistory(), ILIAS\Repository\user(), validateInternalItemTarget(), and validateParameter().

Referenced by ilObjLinkResourceGUI\afterSave(), and createAllItemsInDraftContainer().

                                                        : ilWebLinkItem
    {
        $next_link_id = $this->db->nextId(self::ITEMS_TABLE);

        $this->validateInternalItemTarget($item);

        //create the parameters
        $new_parameters = [];
        foreach ($item->getParameters() as $parameter) {
            $next_param_id = $this->db->nextId(self::PARAMS_TABLE);

            try {
                $this->validateParameter($parameter);
            } catch (Exception $e) {
                continue;
            }


            $new_parameter = new ilWebLinkParameter(
                $this->user,
                $this->getWebrId(),
                $next_link_id,
                $next_param_id,
                $parameter->getValue(),
                $parameter->getName()
            );

            $this->db->insert(
                self::PARAMS_TABLE,
                [
                    'webr_id' => ['integer', $new_parameter->getWebrId()],
                    'link_id' => ['integer', $new_parameter->getLinkId()],
                    'param_id' => ['integer', $new_parameter->getParamId()],
                    'name' => ['text', $new_parameter->getName()],
                    'value' => ['integer', $new_parameter->getValue()]
                ]
            );

            $new_parameters[] = $new_parameter;
        }

        //create the item with the new parameters
        if ($item->isInternal()) {
            $class = ilWebLinkItemInternal::class;
        } else {
            $class = ilWebLinkItemExternal::class;
        }

        $new_item = new $class(
            $this->getWebrId(),
            $next_link_id,
            $item->getTitle(),
            $item->getDescription(),
            $item->getTarget(),
            $item->isActive(),
            $this->getNewDateTimeImmutable(),
            $this->getNewDateTimeImmutable(),
            $new_parameters
        );

        $this->db->insert(
            self::ITEMS_TABLE,
            [
                'internal' => ['integer', (int) $new_item->isInternal()],
                'webr_id' => ['integer', $new_item->getWebrId()],
                'link_id' => ['integer', $new_item->getLinkId()],
                'title' => ['text', $new_item->getTitle()],
                'description' => ['text', $new_item->getDescription() ?? ''],
                'target' => ['text', $new_item->getTarget()],
                'active' => ['integer', (int) $new_item->isActive()],
                'create_date' => ['integer', $new_item->getCreateDate()
                                                      ->getTimestamp()],
                'last_update' => ['integer', $new_item->getLastUpdate()
                                                      ->getTimestamp()]
            ]
        );

        if ($this->isUpdateHistory()) {
            ilHistory::_createEntry(
                $this->getWebrId(),
                "add",
                [$new_item->getTitle()]
            );
        }

        return $new_item;
    }

Here is the call graph for this function:

Here is the caller graph for this function:

createList()

ilWebLinkDatabaseRepository::createList

(

ilWebLinkDraftList

$list

)

Implements ilWebLinkRepository.

Definition at line 133 of file class.ilWebLinkDatabaseRepository.php.

References ilHistory\_createEntry(), ilWebLinkBaseList\getDescription(), getNewDateTimeImmutable(), ilWebLinkBaseList\getTitle(), getWebrId(), and isUpdateHistory().

                                                        : ilWebLinkList
    {
        $new_list = new ilWebLinkList(
            $this->getWebrId(),
            $list->getTitle(),
            $list->getDescription(),
            $this->getNewDateTimeImmutable(),
            $this->getNewDateTimeImmutable(),
        );

        $this->db->insert(
            self::LISTS_TABLE,
            [
                'webr_id' => ['integer', $new_list->getWebrId()],
                'title' => ['text', $new_list->getTitle()],
                'description' => ['text', $new_list->getDescription() ?? ''],
                'create_date' => ['integer', $new_list->getCreateDate()
                                                      ->getTimestamp()],
                'last_update' => ['integer', $new_list->getLastUpdate()
                                                      ->getTimestamp()],
            ]
        );

        if ($this->isUpdateHistory()) {
            ilHistory::_createEntry(
                $this->getWebrId(),
                "add",
                [$new_list->getTitle()]
            );
        }

        return $new_list;
    }

Here is the call graph for this function:

deleteAllItems()

ilWebLinkDatabaseRepository::deleteAllItems

(

)

Implements ilWebLinkRepository.

Definition at line 469 of file class.ilWebLinkDatabaseRepository.php.

References getWebrId().

                                    : void
    {
        $this->db->manipulate(
            "DELETE FROM " . $this->db->quoteIdentifier(self::ITEMS_TABLE) . " " .
            "WHERE webr_id = " . $this->db->quote($this->getWebrId(), 'integer')
        );

        $this->db->manipulate(
            "DELETE FROM " . $this->db->quoteIdentifier(self::PARAMS_TABLE) . " " .
            "WHERE webr_id = " . $this->db->quote($this->getWebrId(), 'integer')
        );
    }

Here is the call graph for this function:

deleteItemByLinkID()

ilWebLinkDatabaseRepository::deleteItemByLinkID

(

int

$link_id

)

Implements ilWebLinkRepository.

Definition at line 482 of file class.ilWebLinkDatabaseRepository.php.

References ilHistory\_createEntry(), getItemByLinkId(), getWebrId(), and isUpdateHistory().

                                                    : void
    {
        if ($this->isUpdateHistory()) {
            $title = $this->getItemByLinkId($link_id)->getTitle();
        }

        $this->db->manipulate(
            "DELETE FROM " . $this->db->quoteIdentifier(self::ITEMS_TABLE) . " " .
            "WHERE webr_id = " . $this->db->quote($this->getWebrId(), 'integer') . " " .
            "AND link_id = " . $this->db->quote($link_id, 'integer')
        );

        $this->db->manipulate(
            "DELETE FROM " . $this->db->quoteIdentifier(self::PARAMS_TABLE) . " " .
            "WHERE webr_id = " . $this->db->quote($this->getWebrId(), 'integer') . " " .
            "AND link_id = " . $this->db->quote($link_id, 'integer')
        );

        if (isset($title)) {
            ilHistory::_createEntry(
                $this->getWebrId(),
                "delete",
                [$title]
            );
        }
    }

Here is the call graph for this function:

deleteList()

ilWebLinkDatabaseRepository::deleteList

(

)

Implements ilWebLinkRepository.

Definition at line 521 of file class.ilWebLinkDatabaseRepository.php.

References $res, ilHistory\_createEntry(), getList(), getWebrId(), and isUpdateHistory().

                                : void
    {
        if ($this->isUpdateHistory()) {
            $title = $this->getList()->getTitle();
        }

        $res = $this->db->manipulate(
            "DELETE FROM " . $this->db->quoteIdentifier(self::LISTS_TABLE) . " " .
            "WHERE webr_id = " . $this->db->quote($this->getWebrId(), 'integer')
        );

        if (isset($title)) {
            ilHistory::_createEntry(
                $this->getWebrId(),
                "delete",
                [$title]
            );
        }
    }

Here is the call graph for this function:

deleteParameterByLinkIdAndParamId()

ilWebLinkDatabaseRepository::deleteParameterByLinkIdAndParamId	(	int	$link_id,
		int	$param_id
	)

Implements ilWebLinkRepository.

Definition at line 509 of file class.ilWebLinkDatabaseRepository.php.

References getWebrId().

Referenced by updateItem().

     : void {
        $this->db->manipulate(
            "DELETE FROM " . $this->db->quoteIdentifier(self::PARAMS_TABLE) . " " .
            "WHERE webr_id = " . $this->db->quote($this->getWebrId(), 'integer') . " " .
            "AND link_id = " . $this->db->quote($link_id, 'integer') . " " .
            "AND param_id = " . $this->db->quote($param_id, 'integer')
        );
    }

Here is the call graph for this function:

Here is the caller graph for this function:

doesListExist()

ilWebLinkDatabaseRepository::doesListExist

(

)

Implements ilWebLinkRepository.

Definition at line 320 of file class.ilWebLinkDatabaseRepository.php.

References $res, ilDBConstants\FETCHMODE_OBJECT, and getWebrId().

                                   : bool
    {
        $res = $this->db->query(
            "SELECT COUNT(*) AS num FROM " . $this->db->quoteIdentifier(self::LISTS_TABLE) . " " .
            "WHERE webr_id = " . $this->db->quote($this->getWebrId(), 'integer')
        );

        $row = $res->fetchRow(ilDBConstants::FETCHMODE_OBJECT);

        return ((int) $row->num) > 0;
    }

Here is the call graph for this function:

doesOnlyOneItemExist()

ilWebLinkDatabaseRepository::doesOnlyOneItemExist

(

bool

$only_active = false

)

Implements ilWebLinkRepository.

Definition at line 256 of file class.ilWebLinkDatabaseRepository.php.

References $query, ilDBConstants\FETCHMODE_OBJECT, and getWebrId().

                                                                   : bool
    {
        $query = "SELECT COUNT(*) AS num FROM " . $this->db->quoteIdentifier(self::ITEMS_TABLE) . " " .
            "WHERE webr_id = " . $this->db->quote($this->getWebrId(), 'integer');

        if ($only_active) {
            $query .= " AND active = " . $this->db->quote(1, 'integer');
        }

        $row = $this->db->query($query)
                        ->fetchRow(ilDBConstants::FETCHMODE_OBJECT);

        return $row->num == 1;
    }

Here is the call graph for this function:

getAllItemsAsContainer()

ilWebLinkDatabaseRepository::getAllItemsAsContainer

(

bool

$only_active = false

)

Implements ilWebLinkRepository.

Definition at line 181 of file class.ilWebLinkDatabaseRepository.php.

References $query, $res, ilDBConstants\FETCHMODE_OBJECT, getNewDateTimeImmutable(), getParametersByLinkId(), and getWebrId().

                                                                     : ilWebLinkItemsContainer
    {
        $query = "SELECT * FROM " . $this->db->quoteIdentifier(self::ITEMS_TABLE) . " " .
            "WHERE webr_id = " . $this->db->quote($this->getWebrId(), 'integer');

        if ($only_active) {
            $query .= " AND active = " . $this->db->quote(1, 'integer');
        }

        $res = $this->db->query($query);
        $items = [];

        while ($row = $res->fetchRow(ilDBConstants::FETCHMODE_OBJECT)) {
            $parameters = $this->getParametersByLinkId((int) $row->link_id);

            if ($row->internal) {
                $class = ilWebLinkItemInternal::class;
            } else {
                $class = ilWebLinkItemExternal::class;
            }

            $items[] = new $class(
                (int) $row->webr_id,
                (int) $row->link_id,
                (string) $row->title,
                ((string) $row->description) !== '' ? (string) $row->description : null,
                (string) $row->target,
                (bool) $row->active,
                $this->getNewDateTimeImmutable()->setTimestamp((int) $row->create_date),
                $this->getNewDateTimeImmutable()->setTimestamp((int) $row->last_update),
                $parameters
            );
        }

        return new ilWebLinkItemsContainer(
            $this->getWebrId(),
            $items
        );
    }

Here is the call graph for this function:

getCurrentTime()

ilWebLinkDatabaseRepository::getCurrentTime ( )

protected

Definition at line 612 of file class.ilWebLinkDatabaseRepository.php.

Referenced by updateItem(), and updateList().

                                       : int
    {
        return time();
    }

Here is the caller graph for this function:

getItemByLinkId()

ilWebLinkDatabaseRepository::getItemByLinkId

(

int

$link_id

)

Implements ilWebLinkRepository.

Definition at line 221 of file class.ilWebLinkDatabaseRepository.php.

References $query, $res, ilDBConstants\FETCHMODE_OBJECT, getNewDateTimeImmutable(), getParametersByLinkId(), and getWebrId().

Referenced by deleteItemByLinkID().

                                                 : ilWebLinkItem
    {
        $query = "SELECT * FROM " . $this->db->quoteIdentifier(self::ITEMS_TABLE) . " " .
            "WHERE webr_id = " . $this->db->quote($this->getWebrId(), 'integer') . " " .
            "AND link_id = " . $this->db->quote($link_id, 'integer');

        $res = $this->db->query($query);

        while ($row = $res->fetchRow(ilDBConstants::FETCHMODE_OBJECT)) {
            $parameters = $this->getParametersByLinkId((int) $row->link_id);

            if ($row->internal) {
                $class = ilWebLinkItemInternal::class;
            } else {
                $class = ilWebLinkItemExternal::class;
            }

            return new $class(
                (int) $row->webr_id,
                (int) $row->link_id,
                (string) $row->title,
                ((string) $row->description) !== '' ? (string) $row->description : null,
                (string) $row->target,
                (bool) $row->active,
                $this->getNewDateTimeImmutable()->setTimestamp((int) $row->create_date),
                $this->getNewDateTimeImmutable()->setTimestamp((int) $row->last_update),
                $parameters
            );
        }

        throw new ilWebLinkDatabaseRepositoryException(
            'No item with the given link_id was found in this web link object.'
        );
    }

Here is the call graph for this function:

Here is the caller graph for this function:

getList()

ilWebLinkDatabaseRepository::getList

(

)

Implements ilWebLinkRepository.

Definition at line 298 of file class.ilWebLinkDatabaseRepository.php.

References $res, ilDBConstants\FETCHMODE_OBJECT, getNewDateTimeImmutable(), and getWebrId().

Referenced by deleteList().

                             : ilWebLinkList
    {
        $res = $this->db->query(
            "SELECT * FROM " . $this->db->quoteIdentifier(self::LISTS_TABLE) . " " .
            "WHERE webr_id = " . $this->db->quote($this->getWebrId(), 'integer')
        );

        while ($row = $res->fetchRow(ilDBConstants::FETCHMODE_OBJECT)) {
            return new ilWebLinkList(
                (int) $row->webr_id,
                (string) $row->title,
                ((string) $row->description) !== '' ? (string) $row->description : null,
                $this->getNewDateTimeImmutable()->setTimestamp((int) $row->create_date),
                $this->getNewDateTimeImmutable()->setTimestamp((int) $row->last_update),
            );
        }

        throw new ilWebLinkDatabaseRepositoryException(
            'No list exists in this web link object.'
        );
    }

Here is the call graph for this function:

Here is the caller graph for this function:

getNewDateTimeImmutable()

ilWebLinkDatabaseRepository::getNewDateTimeImmutable ( )

protected

Definition at line 617 of file class.ilWebLinkDatabaseRepository.php.

Referenced by createItem(), createList(), getAllItemsAsContainer(), getItemByLinkId(), and getList().

                                                : DateTimeImmutable
    {
        return new DateTimeImmutable();
    }

Here is the caller graph for this function:

getParameterinItemByParamId()

ilWebLinkDatabaseRepository::getParameterinItemByParamId	(	ilWebLinkItem	$item,
		int	$param_id
	)

Implements ilWebLinkRepository.

Definition at line 271 of file class.ilWebLinkDatabaseRepository.php.

References $res, ilDBConstants\FETCHMODE_OBJECT, ilWebLinkItem\getLinkId(), getWebrId(), and ILIAS\Repository\user().

     : ilWebLinkParameter {
        $res = $this->db->query(
            "SELECT * FROM " . $this->db->quoteIdentifier(self::PARAMS_TABLE) . " " .
            "WHERE webr_id = " . $this->db->quote($this->getWebrId(), 'integer') . " " .
            "AND link_id = " . $this->db->quote($item->getLinkId(), 'integer') . " " .
            "AND param_id = " . $this->db->quote($param_id, 'integer')
        );

        while ($row = $res->fetchRow(ilDBConstants::FETCHMODE_OBJECT)) {
            return new ilWebLinkParameter(
                $this->user,
                (int) $row->webr_id,
                (int) $row->link_id,
                (int) $row->param_id,
                (int) $row->value,
                (string) $row->name
            );
        }

        throw new ilWebLinkDatabaseRepositoryException(
            'In the given item of this web link object, no parameter with the given param_id was found.'
        );
    }

Here is the call graph for this function:

getParametersByLinkId()

ilWebLinkDatabaseRepository::getParametersByLinkId ( int  $link_id )

protected

Returns

ilWebLinkParameter[]

Definition at line 544 of file class.ilWebLinkDatabaseRepository.php.

References $res, ilDBConstants\FETCHMODE_OBJECT, getWebrId(), and ILIAS\Repository\user().

Referenced by getAllItemsAsContainer(), and getItemByLinkId().

                                                          : array
    {
        $res = $this->db->query(
            "SELECT * FROM " . $this->db->quoteIdentifier(self::PARAMS_TABLE) . " " .
            "WHERE webr_id = " . $this->db->quote($this->getWebrId(), 'integer') . " " .
            "AND link_id = " . $this->db->quote($link_id, 'integer')
        );
        $parameters = [];

        while ($row = $res->fetchRow(ilDBConstants::FETCHMODE_OBJECT)) {
            $parameters[] = new ilWebLinkParameter(
                $this->user,
                (int) $row->webr_id,
                (int) $row->link_id,
                (int) $row->param_id,
                (int) $row->value,
                (string) $row->name
            );
        }

        return $parameters;
    }

Here is the call graph for this function:

Here is the caller graph for this function:

getWebrId()

ilWebLinkDatabaseRepository::getWebrId

(

)

Definition at line 597 of file class.ilWebLinkDatabaseRepository.php.

References $webr_id.

Referenced by createAllItemsInDraftContainer(), createItem(), createList(), deleteAllItems(), deleteItemByLinkID(), deleteList(), deleteParameterByLinkIdAndParamId(), doesListExist(), doesOnlyOneItemExist(), getAllItemsAsContainer(), getItemByLinkId(), getList(), getParameterinItemByParamId(), getParametersByLinkId(), updateItem(), and updateList().

                               : int
    {
        return $this->webr_id;
    }

Here is the caller graph for this function:

isUpdateHistory()

ilWebLinkDatabaseRepository::isUpdateHistory

(

)

Definition at line 602 of file class.ilWebLinkDatabaseRepository.php.

References $update_history.

Referenced by createItem(), createList(), deleteItemByLinkID(), deleteList(), updateItem(), and updateList().

                                     : bool
    {
        return $this->update_history;
    }

Here is the caller graph for this function:

setUpdateHistory()

ilWebLinkDatabaseRepository::setUpdateHistory

(

bool

$update_history

)

Definition at line 607 of file class.ilWebLinkDatabaseRepository.php.

References $update_history.

                                                          : void
    {
        $this->update_history = $update_history;
    }

updateItem()

ilWebLinkDatabaseRepository::updateItem	(	ilWebLinkItem	$item,
		ilWebLinkDraftItem	$drafted_item
	)

Updates an item.

New parameters added as drafts update the parameter they replace, or else are created fresh. Current parameters of the item not added to the draft are deleted.

Implements ilWebLinkRepository.

Definition at line 332 of file class.ilWebLinkDatabaseRepository.php.

References Vendor\Package\$e, ilHistory\_createEntry(), deleteParameterByLinkIdAndParamId(), getCurrentTime(), ilWebLinkBaseItem\getDescription(), ilWebLinkItem\getLinkId(), ilWebLinkBaseItem\getParameters(), ilWebLinkItem\getParameters(), ilWebLinkBaseItem\getTarget(), ilWebLinkBaseItem\getTitle(), ilWebLinkItem\getWebrId(), getWebrId(), ILIAS\Repository\int(), ilWebLinkBaseItem\isActive(), ilWebLinkDraftItem\isInternal(), isUpdateHistory(), validateInternalItemTarget(), and validateParameter().

     : void {
        if ($item->getWebrId() !== $this->getWebrId()) {
            throw new ilWebLinkDatabaseRepositoryException(
                'Cannot update an item from a different web link object.'
            );
        }

        $this->validateInternalItemTarget($drafted_item);

        $this->db->update(
            self::ITEMS_TABLE,
            [
                'title' => ['text', $drafted_item->getTitle()],
                'description' => ['text', $drafted_item->getDescription() ?? ''],
                'target' => ['text', $drafted_item->getTarget()],
                'active' => ['integer', (int) $drafted_item->isActive()],
                'internal' => ['integer', (int) $drafted_item->isInternal()],
                'last_update' => ['integer', $this->getCurrentTime()]
            ],
            [
                'webr_id' => ['integer', $item->getWebrId()],
                'link_id' => ['integer', $item->getLinkId()]
            ]
        );

        /*
         * drafted parameters of the drafted item are either created or
         * update an existing parameter
         */
        $param_ids = [];
        foreach ($drafted_item->getParameters() as $parameter) {
            if ($parameter instanceof ilWebLinkParameter) {
                $param_ids[] = $parameter->getParamId();
                continue;
            }

            try {
                $this->validateParameter($parameter);
            } catch (Exception $e) {
                continue;
            }

            if ($old_parameter = $parameter->getOldParameter()) {
                if (
                    $old_parameter->getLinkId() !== $item->getLinkId() ||
                    $old_parameter->getWebrId() !== $item->getWebrId()
                ) {
                    throw new ilWebLinkDatabaseRepositoryException(
                        'Cannot update a parameter from a different item.'
                    );
                }

                $this->db->update(
                    self::PARAMS_TABLE,
                    [
                        'name' => ['text', $drafted_item->getTitle()],
                        'value' => ['integer', $drafted_item->getTitle()]
                    ],
                    [
                        'webr_id' => ['integer', $item->getWebrId()],
                        'link_id' => ['integer', $item->getLinkId()],
                        'param_id' => ['integer', $parameter->getOldParameter()
                                                            ->getParamId()],
                    ]
                );
                continue;
            }

            $next_param_id = $this->db->nextId(self::PARAMS_TABLE);
            $this->db->insert(
                self::PARAMS_TABLE,
                [
                    'webr_id' => ['integer', $this->getWebrId()],
                    'link_id' => ['integer', $item->getLinkId()],
                    'param_id' => ['integer', $next_param_id],
                    'name' => ['text', $parameter->getName()],
                    'value' => ['integer', $parameter->getValue()]
                ]
            );
        }

        /*
         * parameters attached to the original item but not the drafted item
         * are deleted
         */
        foreach ($item->getParameters() as $parameter) {
            if (!in_array($parameter->getParamId(), $param_ids)) {
                $this->deleteParameterByLinkIdAndParamId(
                    $item->getLinkId(),
                    $parameter->getParamId()
                );
            }
        }

        if ($this->isUpdateHistory()) {
            ilHistory::_createEntry(
                $this->getWebrId(),
                "update",
                [$item->getTitle()]
            );
        }
    }

Here is the call graph for this function:

updateList()

ilWebLinkDatabaseRepository::updateList	(	ilWebLinkList	$list,
		ilWebLinkDraftList	$drafted_list
	)

Implements ilWebLinkRepository.

Definition at line 438 of file class.ilWebLinkDatabaseRepository.php.

References ilHistory\_createEntry(), getCurrentTime(), ilWebLinkBaseList\getDescription(), ilWebLinkBaseList\getTitle(), ilWebLinkList\getWebrId(), getWebrId(), and isUpdateHistory().

     : void {
        if ($list->getWebrId() !== $this->getWebrId()) {
            throw new ilWebLinkDatabaseRepositoryException(
                'Cannot update a list from a different web link object.'
            );
        }

        $this->db->update(
            self::LISTS_TABLE,
            [
                'title' => ['text', $drafted_list->getTitle()],
                'description' => ['text', $drafted_list->getDescription() ?? ''],
                'last_update' => ['integer', $this->getCurrentTime()]
            ],
            [
                'webr_id' => ['integer', $list->getWebrId()]
            ]
        );

        if ($this->isUpdateHistory()) {
            ilHistory::_createEntry(
                $this->getWebrId(),
                "update",
                [$list->getTitle()]
            );
        }
    }

Here is the call graph for this function:

validateInternalItemTarget()

ilWebLinkDatabaseRepository::validateInternalItemTarget ( ilWebLinkDraftItem  $item )

protected

Exceptions

ilWebLinkDatabaseRepositoryException

Definition at line 585 of file class.ilWebLinkDatabaseRepository.php.

References ilWebLinkBaseItem\getTarget(), ilWebLinkDraftItem\isInternal(), and ilLinkInputGUI\isInternalLink().

Referenced by createItem(), and updateItem().

                                                                           : void
    {
        if (
            $item->isInternal() &&
            !ilLinkInputGUI::isInternalLink($item->getTarget())
        ) {
            throw new ilWebLinkDatabaseRepositoryException(
                'The target of this internal link item is not internal.'
            );
        }
    }

Here is the call graph for this function:

Here is the caller graph for this function:

validateParameter()

ilWebLinkDatabaseRepository::validateParameter ( ilWebLinkBaseParameter  $parameter )

protected

Exceptions

ilWebLinkDatabaseRepositoryException

Definition at line 570 of file class.ilWebLinkDatabaseRepository.php.

References ilWebLinkBaseParameter\getValue(), and ilWebLinkBaseParameter\VALUES.

Referenced by createItem(), and updateItem().

                                                                           : void
    {
        if (!in_array(
            $parameter->getValue(),
            ilWebLinkBaseParameter::VALUES
        )) {
            throw new ilWebLinkDatabaseRepositoryException(
                'The value of the parameter you are trying to create is invalid.'
            );
        }
    }

Here is the call graph for this function:

Here is the caller graph for this function:

Field Documentation

$db

ilDBInterface ilWebLinkDatabaseRepository::$db

protected

Definition at line 31 of file class.ilWebLinkDatabaseRepository.php.

$update_history

bool ilWebLinkDatabaseRepository::$update_history

protected

Definition at line 33 of file class.ilWebLinkDatabaseRepository.php.

Referenced by __construct(), isUpdateHistory(), and setUpdateHistory().

$user

ilObjUser ilWebLinkDatabaseRepository::$user

protected

Definition at line 32 of file class.ilWebLinkDatabaseRepository.php.

$webr_id

int ilWebLinkDatabaseRepository::$webr_id

protected

Definition at line 30 of file class.ilWebLinkDatabaseRepository.php.

Referenced by __construct(), and getWebrId().

ITEMS_TABLE

const ilWebLinkDatabaseRepository::ITEMS_TABLE = 'webr_items'

Definition at line 26 of file class.ilWebLinkDatabaseRepository.php.

Referenced by ilWebResourceDatabaseRepositoryTest\testCreateExternalItem(), ilWebResourceDatabaseRepositoryTest\testCreateInternalItemWithBrokenParameter(), and ilWebResourceDatabaseRepositoryTest\testCreateItemBrokenInternalLinkException().

LISTS_TABLE

const ilWebLinkDatabaseRepository::LISTS_TABLE = 'webr_lists'

Definition at line 27 of file class.ilWebLinkDatabaseRepository.php.

Referenced by ilWebResourceDatabaseRepositoryTest\testCreateList().

PARAMS_TABLE

const ilWebLinkDatabaseRepository::PARAMS_TABLE = 'webr_params'

Definition at line 28 of file class.ilWebLinkDatabaseRepository.php.

Referenced by ilWebResourceDatabaseRepositoryTest\testCreateExternalItem(), and ilWebResourceDatabaseRepositoryTest\testCreateInternalItemWithBrokenParameter().

---

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

• Modules/WebResource/classes/Repository/class.ilWebLinkDatabaseRepository.php