PagesRepository.php

Go to the documentation of this file.

<?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\Linkvalidator\Repository;
 
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\HiddenRestriction;
use ‪TYPO3\CMS\Core\Utility\GeneralUtility;
 
class ‪PagesRepository
{
    protected const ‪TABLE = 'pages';
 
    public function ‪doesRootLineContainHiddenPages(array $pageInfo): bool
    {
        $pid = (int)($pageInfo['pid'] ?? 0);
        if ($pid === 0) {
            return false;
        }
        $isHidden = (bool)($pageInfo['hidden']);
        $extendToSubpages = (bool)($pageInfo['extendToSubpages']);
 
        if ($extendToSubpages === true && $isHidden === true) {
            return true;
        }
 
        $queryBuilder = GeneralUtility::makeInstance(ConnectionPool::class)
            ->getQueryBuilderForTable(self::TABLE);
        $queryBuilder->getRestrictions()->removeAll();
 
        $row = $queryBuilder
            ->select('uid', 'title', 'hidden', 'extendToSubpages')
            ->from(self::TABLE)
            ->where(
                $queryBuilder->expr()->eq(
                    'uid',
                    $queryBuilder->createNamedParameter($pid, ‪Connection::PARAM_INT)
                )
            )
            ->executeQuery()
            ->fetchAssociative();
 
        if ($row !== false) {
            return $this->‪doesRootLineContainHiddenPages($row);
        }
        return false;
    }
 
    public function ‪getAllSubpagesForPage(
        int $id,
        int $depth,
        string $permsClause,
        bool $considerHidden = false
    ): array {
        $subPageIds = [];
        if ($depth === 0) {
            return $subPageIds;
        }
 
        $queryBuilder = GeneralUtility::makeInstance(ConnectionPool::class)
            ->getQueryBuilderForTable(self::TABLE);
        $queryBuilder->getRestrictions()
            ->removeAll()
            ->add(GeneralUtility::makeInstance(DeletedRestriction::class));
 
        $result = $queryBuilder
            ->select('uid', 'title', 'hidden', 'extendToSubpages')
            ->from(self::TABLE)
            ->where(
                $queryBuilder->expr()->eq(
                    'pid',
                    $queryBuilder->createNamedParameter($id, ‪Connection::PARAM_INT)
                ),
                ‪QueryHelper::stripLogicalOperatorPrefix($permsClause)
            )
            ->executeQuery();
 
        while ($row = $result->fetchAssociative()) {
            $subpageId = (int)$row['uid'];
            $isHidden = (bool)$row['hidden'];
            if (!$isHidden || $considerHidden) {
                $subPageIds[] = $subpageId;
            }
            if ($depth > 1 && (!($isHidden && $row['extendToSubpages'] == 1) || $considerHidden)) {
                $subPageIds = array_merge($subPageIds, $this->‪getAllSubpagesForPage(
                    $subpageId,
                    $depth - 1,
                    $permsClause,
                    $considerHidden
                ));
            }
        }
        return $subPageIds;
    }
 
    public function ‪getTranslationForPage(
        int $currentPage,
        string $permsClause,
        bool $considerHiddenPages,
        array $limitToLanguageIds = []
    ): array {
        $queryBuilder = GeneralUtility::makeInstance(ConnectionPool::class)->getQueryBuilderForTable(self::TABLE);
        $queryBuilder->getRestrictions()
            ->removeAll()
            ->add(GeneralUtility::makeInstance(DeletedRestriction::class));
        if (!$considerHiddenPages) {
            $queryBuilder->getRestrictions()->add(GeneralUtility::makeInstance(HiddenRestriction::class));
        }
        $constraints = [
            $queryBuilder->expr()->eq(
                'l10n_parent',
                $queryBuilder->createNamedParameter($currentPage, ‪Connection::PARAM_INT)
            ),
        ];
        if (!empty($limitToLanguageIds)) {
            $constraints[] = $queryBuilder->expr()->in(
                'sys_language_uid',
                $queryBuilder->createNamedParameter($limitToLanguageIds, Connection::PARAM_INT_ARRAY)
            );
        }
        if ($permsClause) {
            $constraints[] = ‪QueryHelper::stripLogicalOperatorPrefix($permsClause);
        }
 
        $result = $queryBuilder
            ->select('uid', 'title', 'hidden')
            ->from(self::TABLE)
            ->where(...$constraints)
            ->executeQuery();
 
        $translatedPages = [];
        while ($row = $result->fetchAssociative()) {
            $translatedPages[] = (int)$row['uid'];
        }
 
        return $translatedPages;
    }
}