9.5/_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\Database\Query\Expression\CompositeExpression;

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


class ‪WorkspaceRestriction implements ‪QueryRestrictionInterface

{

    protected ‪$workspaceId;


    public function ‪__construct(int ‪$workspaceId = 0)

    {

        $this->workspaceId = (int)‪$workspaceId;

    }


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

    {

        $constraints = [];

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

            if (empty(‪$GLOBALS['TCA'][$tableName]['ctrl']['versioningWS'] ?? false)) {

                continue;

            }

            if ($this->workspaceId === 0) {

                // Only include ws_id=0

                $workspaceIdExpression = $expressionBuilder->‪eq($tableAlias . '.t3ver_wsid', 0);

            } else {

                // Include live records PLUS records from the given workspace

                $workspaceIdExpression = $expressionBuilder->‪in(

                    $tableAlias . '.t3ver_wsid',

                    [0, $this->workspaceId]

                );

            }

            // Always filter out "pid=-1" records

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

                $workspaceIdExpression,

                $expressionBuilder->‪neq(

                    $tableAlias . '.pid',

                    -1

                )

            );

        }

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

    }

}