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)
	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 ()

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.

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

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

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.

                                                                                           : ilWebLinkItemsContainer
    {
        $new_items = [];
 
        foreach ($container->getItems() as $item) {
            $new_items[] = $this->createItem($item);
        }
 
        return new ilWebLinkItemsContainer(
            $this->getWebrId(),
            $new_items
        );
    }

References $container, createItem(), and getWebrId().

Here is the call 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.

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

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

Referenced by createAllItemsInDraftContainer().

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.

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

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

Here is the call graph for this function:

deleteAllItems()

ilWebLinkDatabaseRepository::deleteAllItems

(

)

Implements ilWebLinkRepository.

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

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

deleteItemByLinkID()

ilWebLinkDatabaseRepository::deleteItemByLinkID

(

int

$link_id

)

Implements ilWebLinkRepository.

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

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

References ilHistory\_createEntry().

Here is the call graph for this function:

deleteList()

ilWebLinkDatabaseRepository::deleteList

(

)

Implements ilWebLinkRepository.

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

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

References $res, and ilHistory\_createEntry().

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.

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

doesListExist()

ilWebLinkDatabaseRepository::doesListExist

(

)

Implements ilWebLinkRepository.

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

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

References $res, and ilDBConstants\FETCHMODE_OBJECT.

doesOnlyOneItemExist()

ilWebLinkDatabaseRepository::doesOnlyOneItemExist

(

bool

$only_active = false

)

Implements ilWebLinkRepository.

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

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

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

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.

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

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

Here is the call graph for this function:

getCurrentTime()

ilWebLinkDatabaseRepository::getCurrentTime ( )

protected

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

                                       : int
    {
        return time();
    }

getItemByLinkId()

ilWebLinkDatabaseRepository::getItemByLinkId

(

int

$link_id

)

Implements ilWebLinkRepository.

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

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

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

Here is the call graph for this function:

getList()

ilWebLinkDatabaseRepository::getList

(

)

Implements ilWebLinkRepository.

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

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

References $res, and ilDBConstants\FETCHMODE_OBJECT.

getNewDateTimeImmutable()

ilWebLinkDatabaseRepository::getNewDateTimeImmutable ( )

protected

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

                                                : DateTimeImmutable
    {
        return new DateTimeImmutable();
    }

getParameterinItemByParamId()

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

Implements ilWebLinkRepository.

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

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

References ILIAS\Repository\user().

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.

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

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

Referenced by getAllItemsAsContainer(), and getItemByLinkId().

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.

                               : int
    {
        return $this->webr_id;
    }

Referenced by createAllItemsInDraftContainer(), createItem(), createList(), doesOnlyOneItemExist(), getAllItemsAsContainer(), and getItemByLinkId().

Here is the caller graph for this function:

isUpdateHistory()

ilWebLinkDatabaseRepository::isUpdateHistory

(

)

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

                                     : bool
    {
        return $this->update_history;
    }

Referenced by createItem(), and createList().

Here is the caller graph for this function:

setUpdateHistory()

ilWebLinkDatabaseRepository::setUpdateHistory

(

bool

$update_history

)

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

                                                          : 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.

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

updateList()

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

Implements ilWebLinkRepository.

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

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

validateInternalItemTarget()

ilWebLinkDatabaseRepository::validateInternalItemTarget ( ilWebLinkDraftItem  $item )

protected

Exceptions

ilWebLinkDatabaseRepositoryException

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

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

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

Referenced by createItem().

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.

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

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

Referenced by createItem().

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().

$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().

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