ilWebLinkDatabaseRepository Class Reference

Inheritance diagram for ilWebLinkDatabaseRepository:

Collaboration diagram for ilWebLinkDatabaseRepository:

Public Member Functions
	__construct (int $webr_id)
	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 ()

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

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

Protected Attributes
int	$webr_id
ilDBInterface	$db
ilObjUser	$user

Detailed Description

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

)

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

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

    {
        global $DIC;

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

Here is the call graph for this function:

Member Function Documentation

createAllItemsInDraftContainer()

ilWebLinkDatabaseRepository::createAllItemsInDraftContainer

(

ilWebLinkDraftItemsContainer

$container

)

Implements ilWebLinkRepository.

Definition at line 149 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 43 of file class.ilWebLinkDatabaseRepository.php.

References Vendor\Package\$e, ilWebLinkBaseItem\getDescription(), getNewDateTimeImmutable(), ilWebLinkBaseItem\getParameters(), ilWebLinkBaseItem\getTarget(), ilWebLinkBaseItem\getTitle(), getWebrId(), ILIAS\Repository\int(), ilWebLinkBaseItem\isActive(), ilWebLinkDraftItem\isInternal(), 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()]
            ]
        );

        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 123 of file class.ilWebLinkDatabaseRepository.php.

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

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

        return $new_list;
    }

Here is the call graph for this function:

deleteAllItems()

ilWebLinkDatabaseRepository::deleteAllItems

(

)

Implements ilWebLinkRepository.

Definition at line 435 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 448 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') . " " .
            "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')
        );
    }

Here is the call graph for this function:

deleteList()

ilWebLinkDatabaseRepository::deleteList

(

)

Implements ilWebLinkRepository.

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

References $res, and getWebrId().

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

Here is the call graph for this function:

deleteParameterByLinkIdAndParamId()

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

Implements ilWebLinkRepository.

Definition at line 463 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 302 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 238 of file class.ilWebLinkDatabaseRepository.php.

References 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 163 of file class.ilWebLinkDatabaseRepository.php.

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

                                                                     : 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 555 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 203 of file class.ilWebLinkDatabaseRepository.php.

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

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

getList()

ilWebLinkDatabaseRepository::getList

(

)

Implements ilWebLinkRepository.

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

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

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

getNewDateTimeImmutable()

ilWebLinkDatabaseRepository::getNewDateTimeImmutable ( )

protected

Definition at line 560 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 253 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 486 of file class.ilWebLinkDatabaseRepository.php.

References Vendor\Package\$e, $res, ilDBConstants\FETCHMODE_OBJECT, getWebrId(), ILIAS\Repository\user(), and validateParameter().

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)) {
            $parameter = new ilWebLinkParameter(
                $this->user,
                (int) $row->webr_id,
                (int) $row->link_id,
                (int) $row->param_id,
                (int) $row->value,
                (string) $row->name
            );
            try {
                $this->validateParameter($parameter);
            } catch (Exception $e) {
                continue;
            }
            $parameters[] = $parameter;
        }

        return $parameters;
    }

Here is the call graph for this function:

Here is the caller graph for this function:

getWebrId()

ilWebLinkDatabaseRepository::getWebrId

(

)

Definition at line 550 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:

isInternalLink()

ilWebLinkDatabaseRepository::isInternalLink ( string  $value )

protected

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

References ilLinkInputGUI\isInternalLink().

Referenced by validateInternalItemTarget().

                                                    : bool
    {
        return ilLinkInputGUI::isInternalLink($value);
    }

Here is the call graph for this function:

Here is the caller graph for this function:

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 314 of file class.ilWebLinkDatabaseRepository.php.

References Vendor\Package\$e, deleteParameterByLinkIdAndParamId(), getCurrentTime(), ilWebLinkBaseItem\getDescription(), ilWebLinkItem\getLinkId(), ilWebLinkBaseItem\getParameters(), ilWebLinkItem\getParameters(), ilWebLinkBaseItem\getTarget(), ilWebLinkBaseItem\getTitle(), ilWebLinkItem\getWebrId(), getWebrId(), ILIAS\Repository\int(), ilWebLinkBaseItem\isActive(), ilWebLinkDraftItem\isInternal(), 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()
                );
            }
        }
    }

Here is the call graph for this function:

updateList()

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

Implements ilWebLinkRepository.

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

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

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

Here is the call graph for this function:

validateInternalItemTarget()

ilWebLinkDatabaseRepository::validateInternalItemTarget ( ilWebLinkDraftItem  $item )

protected

Exceptions

ilWebLinkDatabaseRepositoryException

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

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

Referenced by createItem(), and updateItem().

                                                                           : void
    {
        if (
            $item->isInternal() &&
            !$this->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 518 of file class.ilWebLinkDatabaseRepository.php.

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

Referenced by createItem(), getParametersByLinkId(), 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.

$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 string 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 string ilWebLinkDatabaseRepository::LISTS_TABLE = 'webr_lists'

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

Referenced by ilWebResourceDatabaseRepositoryTest\testCreateList().

PARAMS_TABLE

const string 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:

• components/ILIAS/WebResource/classes/Repository/class.ilWebLinkDatabaseRepository.php