class MenuItemRepository extends NestedSetRepository implements BlockAwareNestedSetRepositoryInterface

Class MenuItemRepository

Constants

TABLE_NAME

PRIMARY_KEY_COLUMN

Properties

protected Connection $db from AbstractRepository

Methods

__construct(Connection $db)

No description

bool|int
insert(array $data)

Executes the SQL insert statement

string
getTableName(string $tableName = '')

No description

bool|int
delete(int|array $entryId, string $columnName = self::PRIMARY_KEY_COLUMN)

Executes the SQL delete statement

bool|int
update(array $data, int|array $entryId)

Executes the SQL update statement

string
buildLimitStmt(int|string $limitStart = '', int|string $resultsPerPage = '')

Build the SQL limit

array
getOneById(int $entryId)

No description

array
fetchNodeWithSiblings(int $nodeId)

Die aktuelle Seite mit allen untergeordneten Seiten selektieren

array
fetchNextNodeWithSiblings(int $leftId)

No description

array
fetchPrevNodeWithSiblings(int $rightId)

No description

bool
nodeExists(int $nodeId)

No description

bool
nextNodeExists(int $rightId, int $blockId = 0)

No description

bool
previousNodeExists(int $rightId, int $blockId = 0)

No description

array
fetchNodeById(int $nodeId)

No description

bool
nodeIsRootItem(int $leftId, int $rightId)

No description

int
fetchParentNode(int $leftId, int $rightId)

No description

int
fetchRootNode(int $leftId, int $rightId)

No description

int
fetchMaximumRightIdByBlockId(int $blockId)

No description

int
fetchMaximumRightId()

No description

int
fetchMinimumLeftIdByBlockId(int $blockId)

No description

bool
menuItemExists(int $menuItemId)

No description

array
getOneMenuItemByUri(string $uri)

No description

array
getAllItemsByBlockId(int $menuId)

No description

string
getMenuItemUriById(int $menuItemId)

No description

int
getMenuIdByMenuItemId(int $menuItemId)

No description

int
getMenuItemIdByUri(string $uri)

No description

array
getAllMenuItems()

No description

array
getVisibleMenuItemsByBlockName(string $blockName)

No description

int
getLeftIdByUris(string $menuName, array $uris)

No description

array
getMenuItemsByUri(array $uris)

No description

Details

in AbstractRepository at line 28
__construct(Connection $db)

Parameters

Connection $db

in AbstractRepository at line 39
bool|int insert(array $data)

Executes the SQL insert statement

Parameters

array $data

Return Value

bool|int

in AbstractRepository at line 55
string getTableName(string $tableName = '')

Parameters

string $tableName

Return Value

string

in AbstractRepository at line 67
bool|int delete(int|array $entryId, string $columnName = self::PRIMARY_KEY_COLUMN)

Executes the SQL delete statement

Parameters

int|array $entryId
string $columnName

Return Value

bool|int

in AbstractRepository at line 95
bool|int update(array $data, int|array $entryId)

Executes the SQL update statement

Parameters

array $data
int|array $entryId

Return Value

bool|int

in AbstractRepository at line 114
protected string buildLimitStmt(int|string $limitStart = '', int|string $resultsPerPage = '')

Build the SQL limit

Parameters

int|string $limitStart
int|string $resultsPerPage

Return Value

string

in AbstractRepository at line 130
array getOneById(int $entryId)

Parameters

int $entryId

Return Value

array

in NestedSetRepository at line 23
array fetchNodeWithSiblings(int $nodeId)

Die aktuelle Seite mit allen untergeordneten Seiten selektieren

Parameters

int $nodeId

Return Value

array

in NestedSetRepository at line 35
array fetchNextNodeWithSiblings(int $leftId)

Parameters

int $leftId

Return Value

array

in NestedSetRepository at line 47
array fetchPrevNodeWithSiblings(int $rightId)

Parameters

int $rightId

Return Value

array

in NestedSetRepository at line 59
bool nodeExists(int $nodeId)

Parameters

int $nodeId

Return Value

bool

in NestedSetRepository at line 69
bool nextNodeExists(int $rightId, int $blockId = 0)

Parameters

int $rightId
int $blockId

Return Value

bool

in NestedSetRepository at line 83
bool previousNodeExists(int $rightId, int $blockId = 0)

Parameters

int $rightId
int $blockId

Return Value

bool

in NestedSetRepository at line 96
array fetchNodeById(int $nodeId)

Parameters

int $nodeId

Return Value

array

in NestedSetRepository at line 107
bool nodeIsRootItem(int $leftId, int $rightId)

Parameters

int $leftId
int $rightId

Return Value

bool

in NestedSetRepository at line 120
int fetchParentNode(int $leftId, int $rightId)

Parameters

int $leftId
int $rightId

Return Value

int

in NestedSetRepository at line 133
int fetchRootNode(int $leftId, int $rightId)

Parameters

int $leftId
int $rightId

Return Value

int

in NestedSetRepository at line 145
int fetchMaximumRightIdByBlockId(int $blockId)

Parameters

int $blockId

Return Value

int

in NestedSetRepository at line 156
int fetchMaximumRightId()

Return Value

int

in NestedSetRepository at line 165
int fetchMinimumLeftIdByBlockId(int $blockId)

Parameters

int $blockId

Return Value

int

at line 25
bool menuItemExists(int $menuItemId)

Parameters

int $menuItemId

Return Value

bool

at line 38
array getOneMenuItemByUri(string $uri)

Parameters

string $uri

Return Value

array

at line 51
array getAllItemsByBlockId(int $menuId)

Parameters

int $menuId

Return Value

array

at line 64
string getMenuItemUriById(int $menuItemId)

Parameters

int $menuItemId

Return Value

string

at line 77
int getMenuIdByMenuItemId(int $menuItemId)

Parameters

int $menuItemId

Return Value

int

at line 90
int getMenuItemIdByUri(string $uri)

Parameters

string $uri

Return Value

int

at line 101
array getAllMenuItems()

Return Value

array

at line 113
array getVisibleMenuItemsByBlockName(string $blockName)

Parameters

string $blockName

Return Value

array

at line 128
int getLeftIdByUris(string $menuName, array $uris)

Parameters

string $menuName
array $uris

Return Value

int

Exceptions

DBALException

at line 143
array getMenuItemsByUri(array $uris)

Parameters

array $uris

Return Value

array

Exceptions

DBALException