817 lines
33 KiB
PHP
817 lines
33 KiB
PHP
<?php
|
|
|
|
declare(strict_types=1);
|
|
|
|
/*
|
|
* This file is part of the TYPO3 CMS project.
|
|
*
|
|
* It is free software; you can redistribute it and/or modify it under
|
|
* the terms of the GNU General Public License, either version 2
|
|
* of the License, or any later version.
|
|
*
|
|
* For the full copyright and license information, please read the
|
|
* LICENSE.txt file that was distributed with this source code.
|
|
*
|
|
* The TYPO3 project - inspiring people to share!
|
|
*/
|
|
|
|
namespace TYPO3\CMS\Backend\Tree\Repository;
|
|
|
|
use Psr\EventDispatcher\EventDispatcherInterface;
|
|
use TYPO3\CMS\Backend\Utility\BackendUtility;
|
|
use TYPO3\CMS\Core\Authentication\BackendUserAuthentication;
|
|
use TYPO3\CMS\Core\Cache\CacheManager;
|
|
use TYPO3\CMS\Core\Cache\Frontend\FrontendInterface;
|
|
use TYPO3\CMS\Core\Database\Connection;
|
|
use TYPO3\CMS\Core\Database\ConnectionPool;
|
|
use TYPO3\CMS\Core\Database\Query\QueryHelper;
|
|
use TYPO3\CMS\Core\Database\Query\Restriction\DeletedRestriction;
|
|
use TYPO3\CMS\Core\Database\Query\Restriction\WorkspaceRestriction;
|
|
use TYPO3\CMS\Core\DataHandling\PlainDataResolver;
|
|
use TYPO3\CMS\Core\Utility\GeneralUtility;
|
|
use TYPO3\CMS\Core\Utility\MathUtility;
|
|
use TYPO3\CMS\Core\Versioning\VersionState;
|
|
|
|
/**
|
|
* Fetches ALL pages in the page tree, possibly overlaid with the workspace
|
|
* in a sorted way.
|
|
*
|
|
* This works agnostic of the Backend User, allows to be used in FE as well in the future.
|
|
*
|
|
* @internal this class is not public API yet, as it needs to be proven stable enough first.
|
|
*/
|
|
class PageTreeRepository
|
|
{
|
|
/**
|
|
* Fields to be queried from the database
|
|
*
|
|
* @var string[]
|
|
*/
|
|
protected readonly array $fields;
|
|
|
|
/**
|
|
* The fields array, quoted for repeated use in recursive pages queries, to avoid the need to newly
|
|
* quote the fields for each single query (which can get really expensive for a large amount of fields)
|
|
* @var string[]
|
|
*/
|
|
protected readonly array $quotedFields;
|
|
|
|
/**
|
|
* The workspace ID to operate on
|
|
*/
|
|
protected readonly int $currentWorkspace;
|
|
|
|
/**
|
|
* Full page tree when selected without permissions applied.
|
|
*/
|
|
protected array $fullPageTree = [];
|
|
|
|
protected readonly array $additionalQueryRestrictions;
|
|
|
|
protected ?string $additionalWhereClause = null;
|
|
|
|
protected ?int $languageFilter = null;
|
|
|
|
protected string $defaultLanguageTag;
|
|
|
|
protected EventDispatcherInterface $eventDispatcher;
|
|
|
|
protected readonly FrontendInterface $runtimeCache;
|
|
|
|
/**
|
|
* @param int $workspaceId the workspace ID to be checked for.
|
|
* @param array $additionalFieldsToQuery an array with more fields that should be accessed.
|
|
* @param array $additionalQueryRestrictions an array with more restrictions to add
|
|
*/
|
|
public function __construct(int $workspaceId = 0, array $additionalFieldsToQuery = [], array $additionalQueryRestrictions = [])
|
|
{
|
|
$this->defaultLanguageTag = \Local\Multilanguage\Service\DefaultLanguageTagService::getTag();
|
|
$this->currentWorkspace = $workspaceId;
|
|
$this->fields = array_merge([
|
|
'uid',
|
|
'pid',
|
|
'sorting',
|
|
'starttime',
|
|
'endtime',
|
|
'hidden',
|
|
'fe_group',
|
|
'title',
|
|
'nav_title',
|
|
'nav_hide',
|
|
'php_tree_stop',
|
|
'doktype',
|
|
'is_siteroot',
|
|
'module',
|
|
'extendToSubpages',
|
|
'content_from_pid',
|
|
't3ver_oid',
|
|
't3ver_wsid',
|
|
't3ver_state',
|
|
't3ver_stage',
|
|
'perms_userid',
|
|
'perms_user',
|
|
'perms_groupid',
|
|
'perms_group',
|
|
'perms_everybody',
|
|
'mount_pid',
|
|
'shortcut',
|
|
'shortcut_mode',
|
|
'mount_pid_ol',
|
|
'link',
|
|
'sys_language_uid',
|
|
'l10n_parent',
|
|
'language_tag',
|
|
], $additionalFieldsToQuery);
|
|
$this->additionalQueryRestrictions = $additionalQueryRestrictions;
|
|
|
|
// @todo: use DI in the future
|
|
$this->eventDispatcher = GeneralUtility::makeInstance(EventDispatcherInterface::class);
|
|
$this->runtimeCache = GeneralUtility::makeInstance(CacheManager::class)->getCache('runtime');
|
|
$this->quotedFields = GeneralUtility::makeInstance(ConnectionPool::class)
|
|
->getQueryBuilderForTable('pages')
|
|
->quoteIdentifiersForSelect($this->fields);
|
|
}
|
|
|
|
public function setLanguageFilter(?int $languageUid): void
|
|
{
|
|
$this->languageFilter = $languageUid;
|
|
}
|
|
|
|
public function setAdditionalWhereClause(string $additionalWhereClause): void
|
|
{
|
|
$this->additionalWhereClause = $additionalWhereClause;
|
|
}
|
|
|
|
private function getLanguageCondition($queryBuilder): void
|
|
{
|
|
$queryBuilder->andWhere(
|
|
$queryBuilder->expr()->or(
|
|
$queryBuilder->expr()->eq('language_tag', $queryBuilder->createNamedParameter($this->defaultLanguageTag)),
|
|
$queryBuilder->expr()->or(
|
|
$queryBuilder->expr()->eq('language_tag', $queryBuilder->createNamedParameter('')),
|
|
$queryBuilder->expr()->isNull('language_tag')
|
|
)
|
|
)
|
|
);
|
|
}
|
|
|
|
/**
|
|
* Get translation language UIDs that matched for a specific page UID
|
|
*
|
|
* @return int[]
|
|
*/
|
|
public function getTranslationMatches(int $pageUid): array
|
|
{
|
|
$translationMatches = $this->runtimeCache->get('pageTree_translationMatches') ?: [];
|
|
return $translationMatches[$pageUid] ?? [];
|
|
}
|
|
|
|
/**
|
|
* Main entry point for this repository, to fetch the tree data for a page.
|
|
* Basically the page record, plus all child pages and their child pages recursively, stored within "_children" item.
|
|
*
|
|
* @param int $entryPoint the page ID to fetch the tree for
|
|
* @param callable|null $callback a callback to be used to check for permissions and filter out pages not to be included.
|
|
*/
|
|
public function getTree(
|
|
int $entryPoint,
|
|
?callable $callback = null,
|
|
array $dbMounts = []
|
|
): array {
|
|
$this->fetchAllPages($dbMounts);
|
|
if ($entryPoint === 0) {
|
|
$tree = $this->fullPageTree;
|
|
} else {
|
|
$tree = $this->findInPageTree($entryPoint, $this->fullPageTree);
|
|
}
|
|
if (!empty($tree) && $callback !== null) {
|
|
$this->applyCallbackToChildren($tree, $callback);
|
|
}
|
|
return $tree;
|
|
}
|
|
|
|
/**
|
|
* Removes items from a tree based on a callback, usually used for permission checks
|
|
*/
|
|
protected function applyCallbackToChildren(array &$tree, callable $callback): void
|
|
{
|
|
if (!isset($tree['_children'])) {
|
|
return;
|
|
}
|
|
foreach ($tree['_children'] as $k => &$childPage) {
|
|
if (!$callback($childPage)) {
|
|
unset($tree['_children'][$k]);
|
|
continue;
|
|
}
|
|
$this->applyCallbackToChildren($childPage, $callback);
|
|
}
|
|
}
|
|
|
|
/**
|
|
* Get the page tree based on a given page record and a given depth
|
|
*
|
|
* @param array $pageTree The page record of the top level page you want to get the page tree of
|
|
* @param int $depth Number of levels to fetch
|
|
* @param ?array $entryPointIds entryPointIds to include (null in case no entry-points were provided)
|
|
* @return array An array with page records and their children
|
|
*/
|
|
public function getTreeLevels(array $pageTree, int $depth, ?array $entryPointIds = null): array
|
|
{
|
|
$groupedAndSortedPagesByPid = [];
|
|
// the method was called without any entry-point information
|
|
if ($entryPointIds === null) {
|
|
$parentPageIds = [$pageTree['uid']];
|
|
// the method was called with entry-point information, that is not empty
|
|
} elseif ($entryPointIds !== []) {
|
|
$pageRecords = $this->getPageRecords($entryPointIds);
|
|
$groupedAndSortedPagesByPid[$pageTree['uid']] = $pageRecords;
|
|
$parentPageIds = $entryPointIds;
|
|
}
|
|
for ($i = 0; $i < $depth; $i++) {
|
|
// stop in case the initial or recursive query did not have any pages
|
|
if (empty($parentPageIds)) {
|
|
break;
|
|
}
|
|
$pageRecords = $this->getChildPageRecords($parentPageIds);
|
|
$groupedAndSortedPagesByPid = $this->groupAndSortPages($pageRecords, $groupedAndSortedPagesByPid);
|
|
$parentPageIds = array_column($pageRecords, 'uid');
|
|
}
|
|
$this->addChildrenToPage($pageTree, $groupedAndSortedPagesByPid);
|
|
return $pageTree;
|
|
}
|
|
|
|
/**
|
|
* Useful to get a list of pages, with a specific depth, e.g. to limit
|
|
* a query to another table to a list of page IDs.
|
|
*
|
|
* @param int[] $entryPointIds
|
|
*/
|
|
public function getFlattenedPages(array $entryPointIds, int $depth): array
|
|
{
|
|
$allPageRecords = $this->getPageRecords($entryPointIds);
|
|
$parentPageIds = $entryPointIds;
|
|
for ($i = 0; $i < $depth; $i++) {
|
|
if (empty($parentPageIds)) {
|
|
break;
|
|
}
|
|
$pageRecords = $this->getChildPageRecords($parentPageIds);
|
|
$parentPageIds = array_column($pageRecords, 'uid');
|
|
$allPageRecords = array_merge($allPageRecords, $pageRecords);
|
|
}
|
|
return $allPageRecords;
|
|
}
|
|
|
|
protected function getChildPageRecords(array $parentPageIds): array
|
|
{
|
|
return $this->getPageRecords([], $parentPageIds);
|
|
}
|
|
|
|
/**
|
|
* Retrieve the page records based on the given page or parent page ids
|
|
*/
|
|
protected function getPageRecords(array $pageIds = [], array $parentPageIds = []): array
|
|
{
|
|
$queryBuilder = GeneralUtility::makeInstance(ConnectionPool::class)
|
|
->getQueryBuilderForTable('pages');
|
|
$queryBuilder->getRestrictions()
|
|
->removeAll()
|
|
->add(GeneralUtility::makeInstance(DeletedRestriction::class))
|
|
->add(GeneralUtility::makeInstance(WorkspaceRestriction::class, $this->currentWorkspace));
|
|
|
|
if (!empty($this->additionalQueryRestrictions)) {
|
|
foreach ($this->additionalQueryRestrictions as $additionalQueryRestriction) {
|
|
$queryBuilder->getRestrictions()->add($additionalQueryRestriction);
|
|
}
|
|
}
|
|
|
|
$queryBuilder->getConcreteQueryBuilder()->select(...$this->quotedFields);
|
|
$queryBuilder
|
|
->from('pages')
|
|
->where('1=1');
|
|
$this->getLanguageCondition($queryBuilder);
|
|
$queryBuilder
|
|
// ensure deterministic sorting
|
|
->orderBy('sorting', 'ASC')
|
|
->addOrderBy('uid', 'ASC');
|
|
|
|
if (!empty($this->additionalWhereClause)) {
|
|
$queryBuilder->andWhere(
|
|
QueryHelper::stripLogicalOperatorPrefix($this->additionalWhereClause)
|
|
);
|
|
}
|
|
|
|
if (count($pageIds) > 0) {
|
|
$queryBuilder->andWhere(
|
|
$queryBuilder->expr()->in('uid', $queryBuilder->createNamedParameter($pageIds, Connection::PARAM_INT_ARRAY))
|
|
);
|
|
}
|
|
|
|
if (count($parentPageIds) > 0) {
|
|
$queryBuilder->andWhere(
|
|
$queryBuilder->expr()->in('pid', $queryBuilder->createNamedParameter($parentPageIds, Connection::PARAM_INT_ARRAY))
|
|
);
|
|
}
|
|
|
|
$pageRecords = $queryBuilder
|
|
->executeQuery()
|
|
->fetchAllAssociative();
|
|
|
|
// This is necessary to resolve all IDs in a workspace
|
|
if ($this->currentWorkspace !== 0 && !empty($pageRecords)) {
|
|
$livePageIds = [];
|
|
$movedPages = [];
|
|
foreach ($pageRecords as $pageRecord) {
|
|
$livePageIds[] = (int)$pageRecord['uid'];
|
|
if (VersionState::tryFrom($pageRecord['t3ver_state'] ?? 0) === VersionState::MOVE_POINTER) {
|
|
$movedPages[$pageRecord['t3ver_oid']] = [
|
|
'pid' => (int)$pageRecord['pid'],
|
|
'sorting' => (int)$pageRecord['sorting'],
|
|
];
|
|
}
|
|
}
|
|
|
|
// Resolve placeholders of workspace versions
|
|
$resolver = GeneralUtility::makeInstance(
|
|
PlainDataResolver::class,
|
|
'pages',
|
|
$livePageIds
|
|
);
|
|
$resolver->setWorkspaceId($this->currentWorkspace);
|
|
$resolver->setKeepDeletePlaceholder(false);
|
|
$resolver->setKeepMovePlaceholder(false);
|
|
$resolver->setKeepLiveIds(false);
|
|
$recordIds = $resolver->get();
|
|
|
|
if (!empty($recordIds)) {
|
|
$queryBuilder->getRestrictions()->removeAll();
|
|
$queryBuilder->getConcreteQueryBuilder()->select(...$this->quotedFields);
|
|
$pageRecords = $queryBuilder
|
|
->from('pages')
|
|
->where(
|
|
$queryBuilder->expr()->in('uid', $queryBuilder->createNamedParameter($recordIds, Connection::PARAM_INT_ARRAY))
|
|
)
|
|
// ensure deterministic sorting
|
|
->orderBy('sorting', 'ASC')
|
|
->addOrderBy('uid', 'ASC')
|
|
->executeQuery()
|
|
->fetchAllAssociative();
|
|
|
|
foreach ($pageRecords as &$pageRecord) {
|
|
if (VersionState::tryFrom($pageRecord['t3ver_state'] ?? 0) === VersionState::MOVE_POINTER && !empty($movedPages[$pageRecord['t3ver_oid']])) {
|
|
$pageRecord['uid'] = $pageRecord['t3ver_oid'];
|
|
$pageRecord['sorting'] = (int)$movedPages[$pageRecord['t3ver_oid']]['sorting'];
|
|
$pageRecord['pid'] = (int)$movedPages[$pageRecord['t3ver_oid']]['pid'];
|
|
} elseif ((int)$pageRecord['t3ver_oid'] > 0) {
|
|
$liveRecord = BackendUtility::getRecord('pages', $pageRecord['t3ver_oid']);
|
|
$pageRecord['sorting'] = (int)$liveRecord['sorting'];
|
|
$pageRecord['uid'] = (int)$liveRecord['uid'];
|
|
$pageRecord['pid'] = (int)$liveRecord['pid'];
|
|
}
|
|
}
|
|
unset($pageRecord);
|
|
} else {
|
|
$pageRecords = [];
|
|
}
|
|
}
|
|
foreach ($pageRecords as &$pageRecord) {
|
|
$pageRecord['uid'] = (int)$pageRecord['uid'];
|
|
}
|
|
|
|
return $pageRecords;
|
|
}
|
|
|
|
public function hasChildren(int $pid): bool
|
|
{
|
|
$pageRecords = $this->getChildPageRecords([$pid]);
|
|
return !empty($pageRecords);
|
|
}
|
|
|
|
/**
|
|
* Fetch all non-deleted pages, regardless of permissions (however, considers additionalQueryRestrictions and additionalWhereClause).
|
|
* That's why it's internal.
|
|
*
|
|
* @return array the full page tree of the whole installation
|
|
*/
|
|
protected function fetchAllPages(array $dbMounts): array
|
|
{
|
|
if (!empty($this->fullPageTree)) {
|
|
return $this->fullPageTree;
|
|
}
|
|
$queryBuilder = GeneralUtility::makeInstance(ConnectionPool::class)
|
|
->getQueryBuilderForTable('pages');
|
|
$queryBuilder->getRestrictions()
|
|
->removeAll()
|
|
->add(GeneralUtility::makeInstance(DeletedRestriction::class))
|
|
->add(GeneralUtility::makeInstance(WorkspaceRestriction::class, $this->currentWorkspace));
|
|
|
|
if (!empty($this->additionalQueryRestrictions)) {
|
|
foreach ($this->additionalQueryRestrictions as $additionalQueryRestriction) {
|
|
$queryBuilder->getRestrictions()->add($additionalQueryRestriction);
|
|
}
|
|
}
|
|
|
|
$queryBuilder->getConcreteQueryBuilder()->select(...$this->quotedFields);
|
|
$query = $queryBuilder
|
|
->from('pages')
|
|
->where('1=1');
|
|
$this->getLanguageCondition($queryBuilder);
|
|
|
|
if (!empty($this->additionalWhereClause)) {
|
|
$queryBuilder->andWhere(
|
|
QueryHelper::stripLogicalOperatorPrefix($this->additionalWhereClause)
|
|
);
|
|
}
|
|
|
|
$pageRecords = $query->executeQuery()->fetchAllAssociative();
|
|
|
|
$ids = array_column($pageRecords, 'uid');
|
|
foreach ($dbMounts as $mount) {
|
|
$entryPointRootLine = BackendUtility::BEgetRootLine($mount, '', false, $this->fields);
|
|
foreach ($entryPointRootLine as $page) {
|
|
$pageId = (int)$page['uid'];
|
|
if (in_array($pageId, $ids) || $pageId === 0) {
|
|
continue;
|
|
}
|
|
$pageRecords[] = $page;
|
|
$ids[] = $pageId;
|
|
}
|
|
}
|
|
|
|
$livePagePids = [];
|
|
$movedPages = [];
|
|
// This is necessary to resolve all IDs in a workspace
|
|
if ($this->currentWorkspace !== 0 && !empty($pageRecords)) {
|
|
$livePageIds = [];
|
|
foreach ($pageRecords as $pageRecord) {
|
|
$livePageIds[] = (int)$pageRecord['uid'];
|
|
$livePagePids[(int)$pageRecord['uid']] = (int)$pageRecord['pid'];
|
|
if (VersionState::tryFrom($pageRecord['t3ver_state'] ?? 0) === VersionState::MOVE_POINTER) {
|
|
$movedPages[$pageRecord['t3ver_oid']] = [
|
|
'pid' => (int)$pageRecord['pid'],
|
|
'sorting' => (int)$pageRecord['sorting'],
|
|
];
|
|
}
|
|
}
|
|
// Resolve placeholders of workspace versions
|
|
$resolver = GeneralUtility::makeInstance(
|
|
PlainDataResolver::class,
|
|
'pages',
|
|
$livePageIds
|
|
);
|
|
$resolver->setWorkspaceId($this->currentWorkspace);
|
|
$resolver->setKeepDeletePlaceholder(false);
|
|
$resolver->setKeepMovePlaceholder(false);
|
|
$resolver->setKeepLiveIds(false);
|
|
$recordIds = $resolver->get();
|
|
|
|
$queryBuilder->getRestrictions()->removeAll();
|
|
$queryBuilder->getConcreteQueryBuilder()->select(...$this->quotedFields);
|
|
$pageRecords = $queryBuilder
|
|
->from('pages')
|
|
->where(
|
|
$queryBuilder->expr()->in('uid', $recordIds)
|
|
)
|
|
->executeQuery()
|
|
->fetchAllAssociative();
|
|
}
|
|
|
|
// Now set up sorting, nesting (tree-structure) for all pages based on pid+sorting fields
|
|
$groupedAndSortedPagesByPid = [];
|
|
foreach ($pageRecords as $pageRecord) {
|
|
$parentPageId = (int)$pageRecord['pid'];
|
|
// In case this is a record from a workspace
|
|
// The uid+pid of the live-version record is fetched
|
|
// This is done in order to avoid fetching records again (e.g. via BackendUtility::workspaceOL()
|
|
if ((int)$pageRecord['t3ver_oid'] > 0) {
|
|
// When a move pointer is found, the pid+sorting of the versioned record should be used
|
|
if (VersionState::tryFrom($pageRecord['t3ver_state'] ?? 0) === VersionState::MOVE_POINTER && !empty($movedPages[$pageRecord['t3ver_oid']])) {
|
|
$parentPageId = (int)$movedPages[$pageRecord['t3ver_oid']]['pid'];
|
|
$pageRecord['sorting'] = (int)$movedPages[$pageRecord['t3ver_oid']]['sorting'];
|
|
} else {
|
|
// Just a record in a workspace (not moved etc)
|
|
$parentPageId = (int)($livePagePids[$pageRecord['t3ver_oid']] ?? $pageRecord['pid']);
|
|
}
|
|
// this is necessary so the links to the modules are still pointing to the live IDs
|
|
$pageRecord['uid'] = (int)$pageRecord['t3ver_oid'];
|
|
$pageRecord['pid'] = $parentPageId;
|
|
}
|
|
|
|
$sorting = (int)$pageRecord['sorting'];
|
|
while (isset($groupedAndSortedPagesByPid[$parentPageId][$sorting])) {
|
|
$sorting++;
|
|
}
|
|
$groupedAndSortedPagesByPid[$parentPageId][$sorting] = $pageRecord;
|
|
}
|
|
|
|
$this->fullPageTree = [
|
|
'uid' => 0,
|
|
'title' => $GLOBALS['TYPO3_CONF_VARS']['SYS']['sitename'] ?: 'TYPO3',
|
|
];
|
|
$this->addChildrenToPage($this->fullPageTree, $groupedAndSortedPagesByPid);
|
|
return $this->fullPageTree;
|
|
}
|
|
|
|
/**
|
|
* Adds the property "_children" to a page record with the child pages
|
|
*
|
|
* @param array[] $groupedAndSortedPagesByPid
|
|
*/
|
|
protected function addChildrenToPage(array &$page, array &$groupedAndSortedPagesByPid): void
|
|
{
|
|
$page['_children'] = $groupedAndSortedPagesByPid[(int)$page['uid']] ?? [];
|
|
ksort($page['_children']);
|
|
|
|
$event = $this->eventDispatcher->dispatch(new AfterRawPageRowPreparedEvent($page, $this->currentWorkspace));
|
|
$page = $event->getRawPage();
|
|
foreach ($page['_children'] as &$child) {
|
|
$this->addChildrenToPage($child, $groupedAndSortedPagesByPid);
|
|
}
|
|
}
|
|
|
|
/**
|
|
* Looking for a page by traversing the tree
|
|
*
|
|
* @param int $pageId the page ID to search for
|
|
* @param array $pages the page tree to look for the page
|
|
* @return array Array of the tree data, empty array if nothing was found
|
|
*/
|
|
protected function findInPageTree(int $pageId, array $pages): array
|
|
{
|
|
foreach ($pages['_children'] as $childPage) {
|
|
if ((int)$childPage['uid'] === $pageId) {
|
|
return $childPage;
|
|
}
|
|
$result = $this->findInPageTree($pageId, $childPage);
|
|
if (!empty($result)) {
|
|
return $result;
|
|
}
|
|
}
|
|
return [];
|
|
}
|
|
|
|
/**
|
|
* Retrieve the page tree based on the given search filter
|
|
*/
|
|
public function fetchFilteredTree(string $searchFilter, array $allowedMountPointPageIds, string $additionalWhereClause): array
|
|
{
|
|
$queryBuilder = GeneralUtility::makeInstance(ConnectionPool::class)
|
|
->getQueryBuilderForTable('pages');
|
|
$queryBuilder->getRestrictions()
|
|
->removeAll()
|
|
->add(GeneralUtility::makeInstance(DeletedRestriction::class));
|
|
|
|
if (!empty($this->additionalQueryRestrictions)) {
|
|
foreach ($this->additionalQueryRestrictions as $additionalQueryRestriction) {
|
|
$queryBuilder->getRestrictions()->add($additionalQueryRestriction);
|
|
}
|
|
}
|
|
|
|
$expressionBuilder = $queryBuilder->expr();
|
|
|
|
if ($this->currentWorkspace === 0) {
|
|
// Only include records from live workspace
|
|
$workspaceIdExpression = $expressionBuilder->eq('t3ver_wsid', 0);
|
|
} else {
|
|
// Include live records PLUS records from the given workspace
|
|
$workspaceIdExpression = $expressionBuilder->in(
|
|
't3ver_wsid',
|
|
$queryBuilder->createNamedParameter([0, $this->currentWorkspace], Connection::PARAM_INT_ARRAY)
|
|
);
|
|
}
|
|
|
|
$queryBuilder->getConcreteQueryBuilder()->select(...$this->quotedFields);
|
|
$queryBuilder = $queryBuilder
|
|
->from('pages')
|
|
->where(
|
|
$workspaceIdExpression,
|
|
QueryHelper::stripLogicalOperatorPrefix($additionalWhereClause)
|
|
);
|
|
$this->getLanguageCondition($queryBuilder);
|
|
|
|
// Clear translation matches cache for new search
|
|
$this->runtimeCache->remove('pageTree_translationMatches');
|
|
|
|
// Allow to extend search parts and search uids
|
|
$event = $this->eventDispatcher->dispatch(
|
|
new BeforePageTreeIsFilteredEvent($expressionBuilder->or(), [], $searchFilter, $queryBuilder)
|
|
);
|
|
$searchParts = $event->searchParts;
|
|
$searchUids = $event->searchUids;
|
|
|
|
if (!empty($searchUids)) {
|
|
// Ensure that the LIVE id is also found
|
|
if ($this->currentWorkspace > 0) {
|
|
$uidConditions = [
|
|
// Check for UID of live record
|
|
$expressionBuilder->and(
|
|
$expressionBuilder->in('uid', $queryBuilder->createNamedParameter($searchUids, Connection::PARAM_INT_ARRAY)),
|
|
$expressionBuilder->eq('t3ver_wsid', 0),
|
|
),
|
|
// Check for UID of live record in versioned record
|
|
$expressionBuilder->and(
|
|
$expressionBuilder->in('t3ver_oid', $queryBuilder->createNamedParameter($searchUids, Connection::PARAM_INT_ARRAY)),
|
|
$expressionBuilder->eq('t3ver_wsid', $queryBuilder->createNamedParameter($this->currentWorkspace, Connection::PARAM_INT)),
|
|
),
|
|
];
|
|
// Check for UID for new or moved versioned record (only if searchFilter is numeric)
|
|
if (MathUtility::canBeInterpretedAsInteger($searchFilter)) {
|
|
$uidConditions[] = $expressionBuilder->and(
|
|
$expressionBuilder->eq('uid', $queryBuilder->createNamedParameter((int)$searchFilter, Connection::PARAM_INT)),
|
|
$expressionBuilder->eq('t3ver_oid', 0),
|
|
$expressionBuilder->eq('t3ver_wsid', $queryBuilder->createNamedParameter($this->currentWorkspace, Connection::PARAM_INT)),
|
|
);
|
|
}
|
|
$uidFilter = $expressionBuilder->or(...$uidConditions);
|
|
} else {
|
|
$uidFilter = $expressionBuilder->in('uid', $queryBuilder->createNamedParameter($searchUids, Connection::PARAM_INT_ARRAY));
|
|
}
|
|
$searchParts = $searchParts->with($uidFilter);
|
|
}
|
|
|
|
$queryBuilder->andWhere($searchParts);
|
|
$pageRecords = $queryBuilder
|
|
->executeQuery()
|
|
->fetchAllAssociative();
|
|
|
|
$livePagePids = [];
|
|
if ($this->currentWorkspace !== 0 && !empty($pageRecords)) {
|
|
$livePageIds = [];
|
|
foreach ($pageRecords as $pageRecord) {
|
|
$livePageIds[] = (int)$pageRecord['uid'];
|
|
$livePagePids[(int)$pageRecord['uid']] = (int)$pageRecord['pid'];
|
|
if ((int)$pageRecord['t3ver_oid'] > 0) {
|
|
$livePagePids[(int)$pageRecord['t3ver_oid']] = (int)$pageRecord['pid'];
|
|
}
|
|
if (VersionState::tryFrom($pageRecord['t3ver_state'] ?? 0) === VersionState::MOVE_POINTER) {
|
|
$movedPages[$pageRecord['t3ver_oid']] = [
|
|
'pid' => (int)$pageRecord['pid'],
|
|
'sorting' => (int)$pageRecord['sorting'],
|
|
];
|
|
}
|
|
}
|
|
// Resolve placeholders of workspace versions
|
|
$resolver = GeneralUtility::makeInstance(
|
|
PlainDataResolver::class,
|
|
'pages',
|
|
$livePageIds
|
|
);
|
|
$resolver->setWorkspaceId($this->currentWorkspace);
|
|
$resolver->setKeepDeletePlaceholder(false);
|
|
$resolver->setKeepMovePlaceholder(false);
|
|
$resolver->setKeepLiveIds(false);
|
|
$recordIds = $resolver->get();
|
|
|
|
$pageRecords = [];
|
|
if (!empty($recordIds)) {
|
|
$queryBuilder->getRestrictions()->removeAll();
|
|
$queryBuilder->getConcreteQueryBuilder()->select(...$this->quotedFields);
|
|
$queryBuilder
|
|
->from('pages')
|
|
->where(
|
|
$queryBuilder->expr()->in('uid', $queryBuilder->createNamedParameter($recordIds, Connection::PARAM_INT_ARRAY))
|
|
);
|
|
$queryBuilder->andWhere($searchParts);
|
|
$pageRecords = $queryBuilder
|
|
->executeQuery()
|
|
->fetchAllAssociative();
|
|
}
|
|
}
|
|
|
|
$pages = [];
|
|
foreach ($pageRecords as $pageRecord) {
|
|
// In case this is a record from a workspace
|
|
// The uid+pid of the live-version record is fetched
|
|
// This is done in order to avoid fetching records again (e.g. via BackendUtility::workspaceOL()
|
|
if ((int)$pageRecord['t3ver_oid'] > 0) {
|
|
// This probably should also remove the live version
|
|
$versionState = VersionState::tryFrom($pageRecord['t3ver_state'] ?? 0);
|
|
if ($versionState === VersionState::DELETE_PLACEHOLDER) {
|
|
continue;
|
|
}
|
|
// When a move pointer is found, the pid+sorting of the versioned record be used
|
|
if ($versionState === VersionState::MOVE_POINTER && !empty($movedPages[$pageRecord['t3ver_oid']])) {
|
|
$parentPageId = (int)$movedPages[$pageRecord['t3ver_oid']]['pid'];
|
|
$pageRecord['sorting'] = (int)$movedPages[$pageRecord['t3ver_oid']]['sorting'];
|
|
} else {
|
|
// Just a record in a workspace (not moved etc)
|
|
$parentPageId = (int)$livePagePids[$pageRecord['t3ver_oid']];
|
|
}
|
|
// this is necessary so the links to the modules are still pointing to the live IDs
|
|
$pageRecord['uid'] = (int)$pageRecord['t3ver_oid'];
|
|
$pageRecord['pid'] = $parentPageId;
|
|
}
|
|
$pages[(int)$pageRecord['uid']] = $pageRecord;
|
|
}
|
|
unset($pageRecords);
|
|
|
|
$pages = $this->filterPagesOnMountPoints($pages, $allowedMountPointPageIds);
|
|
|
|
$groupedAndSortedPagesByPid = $this->groupAndSortPages($pages);
|
|
|
|
$this->fullPageTree = [
|
|
'uid' => 0,
|
|
'title' => $GLOBALS['TYPO3_CONF_VARS']['SYS']['sitename'] ?: 'TYPO3',
|
|
];
|
|
$this->addChildrenToPage($this->fullPageTree, $groupedAndSortedPagesByPid);
|
|
|
|
return $this->fullPageTree;
|
|
}
|
|
|
|
/**
|
|
* Filter all records outside of the allowed mount points
|
|
*/
|
|
protected function filterPagesOnMountPoints(array $pages, array $mountPoints): array
|
|
{
|
|
foreach ($pages as $key => $pageRecord) {
|
|
$rootline = BackendUtility::BEgetRootLine(
|
|
$pageRecord['uid'],
|
|
'',
|
|
$this->currentWorkspace !== 0,
|
|
$this->fields
|
|
);
|
|
$rootline = array_reverse($rootline);
|
|
if (!in_array(0, $mountPoints, true)) {
|
|
$isInsideMountPoints = false;
|
|
foreach ($rootline as $rootlineElement) {
|
|
if (in_array((int)$rootlineElement['uid'], $mountPoints, true)) {
|
|
$isInsideMountPoints = true;
|
|
break;
|
|
}
|
|
}
|
|
if (!$isInsideMountPoints) {
|
|
unset($pages[$key]);
|
|
//skip records outside of the allowed mount points
|
|
continue;
|
|
}
|
|
}
|
|
|
|
$inFilteredRootline = false;
|
|
$amountOfRootlineElements = count($rootline);
|
|
for ($i = 0; $i < $amountOfRootlineElements; ++$i) {
|
|
$rootlineElement = $rootline[$i];
|
|
$rootlineElement['uid'] = (int)$rootlineElement['uid'];
|
|
$isInWebMount = false;
|
|
if ($rootlineElement['uid'] > 0) {
|
|
$isInWebMount = (int)$this->getBackendUser()->isInWebMount($rootlineElement);
|
|
}
|
|
|
|
if (!$isInWebMount
|
|
|| ($rootlineElement['uid'] === (int)$mountPoints[0]
|
|
&& $rootlineElement['uid'] !== $isInWebMount)
|
|
) {
|
|
continue;
|
|
}
|
|
if ($this->getBackendUser()->isAdmin() || ($rootlineElement['uid'] === $isInWebMount && in_array($rootlineElement['uid'], $mountPoints, true))) {
|
|
$inFilteredRootline = true;
|
|
}
|
|
if (!$inFilteredRootline) {
|
|
continue;
|
|
}
|
|
|
|
if (!isset($pages[$rootlineElement['uid']])) {
|
|
$pages[$rootlineElement['uid']] = $rootlineElement;
|
|
}
|
|
}
|
|
}
|
|
// Make sure the mountpoints show up in page tree even when parent pages are not accessible pages
|
|
foreach ($mountPoints as $mountPoint) {
|
|
if ($mountPoint !== 0) {
|
|
if (!array_key_exists($mountPoint, $pages)) {
|
|
$pages[$mountPoint] = BackendUtility::getRecordWSOL('pages', $mountPoint);
|
|
$pages[$mountPoint]['uid'] = (int)$pages[$mountPoint]['uid'];
|
|
}
|
|
$pages[$mountPoint]['pid'] = 0;
|
|
}
|
|
}
|
|
|
|
return $pages;
|
|
}
|
|
|
|
/**
|
|
* Group pages by parent page and sort pages based on sorting property
|
|
*/
|
|
protected function groupAndSortPages(array $pages, array $groupedAndSortedPagesByPid = []): array
|
|
{
|
|
foreach ($pages as $pageRecord) {
|
|
$parentPageId = (int)$pageRecord['pid'];
|
|
$sorting = (int)$pageRecord['sorting'];
|
|
// If the page record was already added in another depth level, don't add it another time.
|
|
// This may happen, if entry points are intersecting each other (Entry point B is inside entry point A).
|
|
if (($groupedAndSortedPagesByPid[$parentPageId][$sorting]['uid'] ?? 0) === $pageRecord['uid']) {
|
|
continue;
|
|
}
|
|
while (isset($groupedAndSortedPagesByPid[$parentPageId][$sorting])) {
|
|
$sorting++;
|
|
}
|
|
$groupedAndSortedPagesByPid[$parentPageId][$sorting] = $pageRecord;
|
|
}
|
|
|
|
return $groupedAndSortedPagesByPid;
|
|
}
|
|
|
|
protected function getBackendUser(): BackendUserAuthentication
|
|
{
|
|
return $GLOBALS['BE_USER'];
|
|
}
|
|
}
|