9.5/_backend_workspace_restriction_8php_source.html

<?php

declare(strict_types = 1);

namespace ‪TYPO3\CMS\Core\Database\Query\Restriction;


/*

 * 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\Core\Context\Context;

use ‪TYPO3\CMS\Core\Database\Query\Expression\CompositeExpression;

use ‪TYPO3\CMS\Core\Database\Query\Expression\ExpressionBuilder;

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

use ‪TYPO3\CMS\Core\Versioning\VersionState;


class ‪BackendWorkspaceRestriction implements ‪QueryRestrictionInterface

{

    protected ‪$workspaceId;


    protected ‪$includeRowsForWorkspaceOverlay;


    public function ‪__construct(int ‪$workspaceId = null, ‪$includeRowsForWorkspaceOverlay = true)

    {

        if (‪$workspaceId === null) {

            $this->workspaceId = GeneralUtility::makeInstance(Context::class)->getPropertyFromAspect('workspace', 'id');

        } else {

            $this->workspaceId = ‪$workspaceId;

        }

        $this->includeRowsForWorkspaceOverlay = ‪$includeRowsForWorkspaceOverlay;

    }


    public function ‪buildExpression(array $queriedTables, ‪ExpressionBuilder $expressionBuilder): ‪CompositeExpression

    {

        $constraints = [];

        foreach ($queriedTables as $tableAlias => $tableName) {

            $workspaceEnabled = ‪$GLOBALS['TCA'][$tableName]['ctrl']['versioningWS'] ?? null;

            if (!empty($workspaceEnabled)) {

                $workspaceIdExpression = $expressionBuilder->‪eq(

                    $tableAlias . '.t3ver_wsid',

                    (int)$this->workspaceId

                );

                if ($this->includeRowsForWorkspaceOverlay) {

                    $constraints[] = $expressionBuilder->‪orX(

                        $workspaceIdExpression,

                        $expressionBuilder->‪lte(

                            $tableAlias . '.t3ver_state',

                            // Trigger __toString(), then cast int

                            (int)(string)new ‪VersionState(‪VersionState::DEFAULT_STATE)

                        )

                    );

                } else {

                    $comparisonExpression = $this->workspaceId === 0 ? 'neq' : 'eq';

                    $constraints[] = $workspaceIdExpression;

                    $constraints[] = $expressionBuilder->{$comparisonExpression}(

                        $tableAlias . '.pid',

                        -1

                    );

                }

            }

        }

        return $expressionBuilder->‪andX(...$constraints);

    }

}