Inheritance diagram for ILIAS\WOPI\Discovery\ActionDBRepository:

Collaboration diagram for ILIAS\WOPI\Discovery\ActionDBRepository:

Public Member Functions
	__construct (private \ilDBInterface $db)

	hasActionForSuffix (string $suffix, ActionTarget ... $action_target)

	hasEditActionForSuffix (string $suffix)

	hasViewActionForSuffix (string $suffix)

	getActionForSuffix (string $suffix, ActionTarget $action_target)

	getEditActionForSuffix (string $suffix)

	getViewActionForSuffix (string $suffix)

	getActions ()

	getActionsForTarget (ActionTarget $action_target)

	getActionsForTargets (ActionTarget ... $action_target)

	getSupportedSuffixes (ActionTarget ... $action_target)

	getActionsForApp (App $app)

	clear ()

	clearSuperfluous (Action ... $actions)

	store (Action $action, App $for_app)

	hasEditActionForSuffix (string $suffix)

	hasViewActionForSuffix (string $suffix)

	hasActionForSuffix (string $suffix, ActionTarget ... $action_target)

	getActionForSuffix (string $suffix, ActionTarget $action_target)

	getEditActionForSuffix (string $suffix)

	getViewActionForSuffix (string $suffix)

	getActions ()

	getActionsForTarget (ActionTarget $action_target)

	getActionsForTargets (ActionTarget ... $action_target)

	getSupportedSuffixes (ActionTarget ... $action_target)

	clearSuperfluous (Action ... $actions)

	store (Action $action, App $for_app)

	clear ()

Private Member Functions
	implodeTargets (ActionTarget ... $targets)

	fromDBRow (array $row)

Private Attributes
const	TABLE_NAME = 'wopi_action'

array	$edit_actions = [ActionTarget::EDIT, ActionTarget::EMBED_EDIT]

array	$view_actions = [ActionTarget::VIEW, ActionTarget::EMBED_VIEW]

Detailed Description

Author: Fabian Schmid fabia.nosp@m.n@sr.nosp@m..solu.nosp@m.tion.nosp@m.s

Definition at line 28 of file ActionDBRepository.php.

Constructor & Destructor Documentation

◆ __construct()

ILIAS\WOPI\Discovery\ActionDBRepository::__construct ( private \ilDBInterface $db )

Definition at line 37 of file ActionDBRepository.php.

39 {

40 }

Member Function Documentation

◆ clear()

ILIAS\WOPI\Discovery\ActionDBRepository::clear ( )

Implements ILIAS\WOPI\Discovery\ActionRepository.

Definition at line 193 of file ActionDBRepository.php.

                           : void
    {
        $query = 'DELETE FROM ' . self::TABLE_NAME;
        $this->db->manipulate($query);
    }

◆ clearSuperfluous()

ILIAS\WOPI\Discovery\ActionDBRepository::clearSuperfluous ( Action ... $actions )

Implements ILIAS\WOPI\Discovery\ActionRepository.

Definition at line 199 of file ActionDBRepository.php.

                                                        : void
    {
        $collected_ids = array_map(
            static fn(Action $act): int => $act->getId(),
            $actions
        );
        $query = 'DELETE FROM ' . self::TABLE_NAME . ' WHERE ' . $this->db->in('id', $collected_ids, true, 'integer');
        $this->db->manipulate($query);
    }

References ILIAS\WOPI\Discovery\Action\getId().

Here is the call graph for this function:

◆ fromDBRow()

ILIAS\WOPI\Discovery\ActionDBRepository::fromDBRow ( array $row )

private

Definition at line 181 of file ActionDBRepository.php.

                                          : Action
    {
        return new Action(
            (int) $row['id'],
            (string) $row['name'],
            (string) $row['ext'],
            new URI((string) $row['urlsrc']),
            empty($row['url_appendix']) ? null : (string) $row['url_appendix'],
            empty($row['target_text']) ? null : (string) $row['target_text']
        );
    }

◆ getActionForSuffix()

ILIAS\WOPI\Discovery\ActionDBRepository::getActionForSuffix	(	string	$suffix,
		ActionTarget	$action_target
	)

Implements ILIAS\WOPI\Discovery\ActionRepository.

Definition at line 87 of file ActionDBRepository.php.

     : ?Action {
        if (!$this->hasActionForSuffix($suffix, $action_target)) {
            return null;
        }
 
        $query = 'SELECT * FROM '
            . self::TABLE_NAME
            . ' WHERE ext = %s AND name = %s';
 
        $result = $this->db->queryF($query, ['text', 'text'], [strtolower($suffix), $action_target->value]);
        $row = $this->db->fetchAssoc($result);
        return $this->fromDBRow($row);
    }

◆ getActions()

ILIAS\WOPI\Discovery\ActionDBRepository::getActions ( )

Returns: Action[]

Implements ILIAS\WOPI\Discovery\ActionRepository.

Definition at line 126 of file ActionDBRepository.php.

                                : array
    {
        $actions = [];
        $query = 'SELECT * FROM ' . self::TABLE_NAME;
        $result = $this->db->query($query);
        while ($row = $this->db->fetchAssoc($result)) {
            $actions[] = $this->fromDBRow($row);
        }
        return $actions;
    }

◆ getActionsForApp()

ILIAS\WOPI\Discovery\ActionDBRepository::getActionsForApp ( App $app )

Definition at line 170 of file ActionDBRepository.php.

                                              : array
    {
        $actions = [];
        $query = 'SELECT * FROM ' . self::TABLE_NAME . ' WHERE app_id = %s';
        $result = $this->db->queryF($query, ['integer'], [$app->getId()]);
        while ($row = $this->db->fetchAssoc($result)) {
            $actions[] = $this->fromDBRow($row);
        }
        return $actions;
    }

References ILIAS\WOPI\Discovery\App\getId().

Here is the call graph for this function:

◆ getActionsForTarget()

ILIAS\WOPI\Discovery\ActionDBRepository::getActionsForTarget ( ActionTarget $action_target )

Returns: Action[]

Implements ILIAS\WOPI\Discovery\ActionRepository.

Definition at line 137 of file ActionDBRepository.php.

                                                                    : array
    {
        $query = 'SELECT * FROM ' . self::TABLE_NAME . ' WHERE name = %s';
        $result = $this->db->queryF($query, ['text'], [$action_target->value]);
        $actions = [];
        while ($row = $this->db->fetchAssoc($result)) {
            $actions[] = $this->fromDBRow($row);
        }
        return $actions;
    }

◆ getActionsForTargets()

ILIAS\WOPI\Discovery\ActionDBRepository::getActionsForTargets ( ActionTarget ... $action_target )

Implements ILIAS\WOPI\Discovery\ActionRepository.

Definition at line 148 of file ActionDBRepository.php.

                                                                        : array
    {
        $actions = [];
        foreach ($action_target as $target) {
            $actions += $this->getActionsForTarget($target);
        }
        return $actions;
    }

◆ getEditActionForSuffix()

ILIAS\WOPI\Discovery\ActionDBRepository::getEditActionForSuffix ( string $suffix )

Implements ILIAS\WOPI\Discovery\ActionRepository.

Definition at line 104 of file ActionDBRepository.php.

                                                          : ?Action
    {
        foreach ($this->edit_actions as $action_target) {
            $action = $this->getActionForSuffix($suffix, $action_target);
            if ($action !== null) {
                return $action;
            }
        }
        return null;
    }

◆ getSupportedSuffixes()

ILIAS\WOPI\Discovery\ActionDBRepository::getSupportedSuffixes ( ActionTarget ... $action_target )

Implements ILIAS\WOPI\Discovery\ActionRepository.

Definition at line 157 of file ActionDBRepository.php.

                                                                        : array
    {
        $query = 'SELECT ext FROM '
            . self::TABLE_NAME
            . ' WHERE name IN (' . $this->implodeTargets(...$action_target) . ')';
        $result = $this->db->query($query);
        $suffixes = [];
        while ($row = $this->db->fetchAssoc($result)) {
            $suffixes[] = $row['ext'];
        }
        return $suffixes;
    }

◆ getViewActionForSuffix()

ILIAS\WOPI\Discovery\ActionDBRepository::getViewActionForSuffix ( string $suffix )

Implements ILIAS\WOPI\Discovery\ActionRepository.

Definition at line 115 of file ActionDBRepository.php.

                                                          : ?Action
    {
        foreach ($this->view_actions as $action_target) {
            $action = $this->getActionForSuffix($suffix, $action_target);
            if ($action !== null) {
                return $action;
            }
        }
        return null;
    }

◆ hasActionForSuffix()

ILIAS\WOPI\Discovery\ActionDBRepository::hasActionForSuffix	(	string	$suffix,
		ActionTarget ...	$action_target
	)

Implements ILIAS\WOPI\Discovery\ActionRepository.

Definition at line 53 of file ActionDBRepository.php.

     : bool {
        static $cache = [];
 
        $implode_targets = $this->implodeTargets(...$action_target);
 
        if (isset($cache[$suffix][$implode_targets])) {
            return $cache[$suffix][$implode_targets];
        }
 
        $query = 'SELECT * FROM '
            . self::TABLE_NAME
            . ' WHERE ext = %s AND name IN(' . $implode_targets . ')';
 
        $result = $this->db->queryF(
            $query,
            ['text'],
            [strtolower($suffix)]
        );
        return $cache[$suffix][$implode_targets] = $result->numRows() > 0;
    }

◆ hasEditActionForSuffix()

ILIAS\WOPI\Discovery\ActionDBRepository::hasEditActionForSuffix ( string $suffix )

Implements ILIAS\WOPI\Discovery\ActionRepository.

Definition at line 77 of file ActionDBRepository.php.

                                                          : bool
    {
        return $this->hasActionForSuffix($suffix, ...$this->edit_actions);
    }

◆ hasViewActionForSuffix()

ILIAS\WOPI\Discovery\ActionDBRepository::hasViewActionForSuffix ( string $suffix )

Implements ILIAS\WOPI\Discovery\ActionRepository.

Definition at line 82 of file ActionDBRepository.php.

                                                          : bool
    {
        return $this->hasActionForSuffix($suffix, ...$this->view_actions);
    }

◆ implodeTargets()

ILIAS\WOPI\Discovery\ActionDBRepository::implodeTargets ( ActionTarget ... $targets )

private

Definition at line 42 of file ActionDBRepository.php.

                                                             : string
    {
        return implode(
            ', ',
            array_map(
                fn(ActionTarget $target): string => $this->db->quote($target->value, 'text'),
                $targets
            )
        );
    }

◆ store()

ILIAS\WOPI\Discovery\ActionDBRepository::store	(	Action	$action,
		App	$for_app
	)

Implements ILIAS\WOPI\Discovery\ActionRepository.

Definition at line 209 of file ActionDBRepository.php.

                                                       : void
    {
        // store only actions with extensions
        if (empty($action->getExtension())) {
            return;
        }
 
        // check for existing action to update them
        $query = 'SELECT * FROM ' . self::TABLE_NAME . ' WHERE name = %s AND ext = %s AND target_ext = %s';
        $result = $this->db->queryF(
            $query,
            ['text', 'text', 'text'],
            [$action->getName(), $action->getExtension(), $action->getTargetExtension()]
        );
 
        if ($this->db->numRows($result) > 0) {
            $row = $this->db->fetchAssoc($result);
            $action = $action->withId((int) $row['id']);
        }
 
        if ($this->db->queryF(
            'SELECT * FROM ' . self::TABLE_NAME . ' WHERE id = %s',
            ['integer'],
            [$action->getId()]
        )->numRows() === 0) {
            $next_id = $this->db->nextId(self::TABLE_NAME);
            $this->db->insert(self::TABLE_NAME, [
                'id' => ['integer', $next_id],
                'name' => ['text', $action->getName()],
                'ext' => ['text', strtolower($action->getExtension())],
                'urlsrc' => ['text', $action->getLauncherUrl()],
                'app_id' => ['integer', $for_app->getId()],
                'url_appendix' => ['text', $action->getUrlAppendix()],
                'target_ext' => ['text', $action->getTargetExtension()],
            ]);
            $action = $action->withId($next_id);
        } else {
            $this->db->update(self::TABLE_NAME, [
                'name' => ['text', $action->getName()],
                'ext' => ['text', strtolower($action->getExtension())],
                'urlsrc' => ['text', $action->getLauncherUrl()],
                'app_id' => ['integer', $for_app->getId()],
                'url_appendix' => ['text', $action->getUrlAppendix()],
                'target_ext' => ['text', $action->getTargetExtension()],
            ], [
                'id' => ['integer', $action->getId()],
            ]);
        }
    }

References ILIAS\WOPI\Discovery\Action\getExtension(), ILIAS\WOPI\Discovery\Action\getId(), ILIAS\WOPI\Discovery\App\getId(), ILIAS\WOPI\Discovery\Action\getLauncherUrl(), ILIAS\WOPI\Discovery\Action\getName(), ILIAS\WOPI\Discovery\Action\getTargetExtension(), ILIAS\WOPI\Discovery\Action\getUrlAppendix(), and ILIAS\WOPI\Discovery\Action\withId().

Here is the call graph for this function:

Field Documentation

◆ $edit_actions

array ILIAS\WOPI\Discovery\ActionDBRepository::$edit_actions = [ActionTarget::EDIT, ActionTarget::EMBED_EDIT]

private

Definition at line 34 of file ActionDBRepository.php.

◆ $view_actions

array ILIAS\WOPI\Discovery\ActionDBRepository::$view_actions = [ActionTarget::VIEW, ActionTarget::EMBED_VIEW]

private

Definition at line 35 of file ActionDBRepository.php.

◆ TABLE_NAME

const ILIAS\WOPI\Discovery\ActionDBRepository::TABLE_NAME = 'wopi_action'

private

Definition at line 33 of file ActionDBRepository.php.

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

components/ILIAS/WOPI/classes/Discovery/ActionDBRepository.php

Public Member Functions

Private Member Functions

Private Attributes

Detailed Description

Constructor & Destructor Documentation

◆ __construct()

Member Function Documentation

◆ clear()

◆ clearSuperfluous()

◆ fromDBRow()

◆ getActionForSuffix()

◆ getActions()

◆ getActionsForApp()

◆ getActionsForTarget()

◆ getActionsForTargets()

◆ getEditActionForSuffix()

◆ getSupportedSuffixes()

◆ getViewActionForSuffix()

◆ hasActionForSuffix()

◆ hasEditActionForSuffix()

◆ hasViewActionForSuffix()

◆ implodeTargets()

◆ store()

Field Documentation

◆ $edit_actions

◆ $view_actions

◆ TABLE_NAME