9.5/_frontend_groups_repository_8php_source.html

<?php

declare(strict_types = 1);


namespace ‪TYPO3\CMS\Adminpanel\Repositories;


/*

 * 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!

 */


use ‪TYPO3\CMS\Backend\FrontendBackendUserAuthentication;

use ‪TYPO3\CMS\Core\Database\ConnectionPool;

use ‪TYPO3\CMS\Core\Database\Query\Restriction\DeletedRestriction;

use ‪TYPO3\CMS\Core\Type\Bitmask\Permission;

use ‪TYPO3\CMS\Core\Utility\GeneralUtility;


class ‪FrontendGroupsRepository

{

    public function ‪getAvailableFrontendUserGroups(): array

    {

        $optionCount = $this->‪getUserGroupOptionCountByBackendUser($this->‪getBackendUser());


        $frontendGroups = [];

        if ($optionCount > 0) {

            $frontendGroups = $this->‪getUserGroupsForPagesByBackendUser($this->‪getBackendUser());

        }


        return $frontendGroups;

    }


    protected function ‪getUserGroupOptionCountByBackendUser(‪FrontendBackendUserAuthentication $beUser): int

    {

        $queryBuilder = GeneralUtility::makeInstance(ConnectionPool::class)

            ->getQueryBuilderForTable('fe_groups');


        $queryBuilder->getRestrictions()

            ->removeAll()

            ->add(GeneralUtility::makeInstance(DeletedRestriction::class));


        $optionCount = $queryBuilder->count('fe_groups.uid')

            ->from('fe_groups', 'fe_groups')

            ->innerJoin(

                'fe_groups',

                'pages',

                'pages',

                $queryBuilder->expr()->eq('pages.uid', $queryBuilder->quoteIdentifier('fe_groups.pid'))

            )

            ->where(

                $beUser->‪getPagePermsClause(‪Permission::PAGE_SHOW)

            )

            ->execute()

            ->fetchColumn(0);


        return (int)$optionCount;

    }


    protected function ‪getUserGroupsForPagesByBackendUser(‪FrontendBackendUserAuthentication $beUser): array

    {

        $queryBuilder = GeneralUtility::makeInstance(ConnectionPool::class)

            ->getQueryBuilderForTable('fe_groups');


        $queryBuilder->getRestrictions()

            ->removeAll()

            ->add(GeneralUtility::makeInstance(DeletedRestriction::class));


        return $queryBuilder->select('fe_groups.uid', 'fe_groups.title')

            ->from('fe_groups')

            ->innerJoin(

                'fe_groups',

                'pages',

                'pages',

                $queryBuilder->expr()->eq('pages.uid', $queryBuilder->quoteIdentifier('fe_groups.pid'))

            )

            ->where(

                $beUser->‪getPagePermsClause(‪Permission::PAGE_SHOW)

            )

            ->orderBy('fe_groups.title')

            ->execute()

            ->fetchAll();

    }


    protected function ‪getBackendUser(): ‪FrontendBackendUserAuthentication

    {

        return ‪$GLOBALS['BE_USER'];

    }

}