TYPO3CMS  8
 All Classes Namespaces Files Functions Variables Pages
FrontendWorkspaceRestriction.php
Go to the documentation of this file.
1 <?php
2 declare(strict_types=1);
3 namespace TYPO3\CMS\Core\Database\Query\Restriction;
4 
5 /*
6  * This file is part of the TYPO3 CMS project.
7  *
8  * It is free software; you can redistribute it and/or modify it under
9  * the terms of the GNU General Public License, either version 2
10  * of the License, or any later version.
11  *
12  * For the full copyright and license information, please read the
13  * LICENSE.txt file that was distributed with this source code.
14  *
15  * The TYPO3 project - inspiring people to share!
16  */
17 
21 
26 {
30  protected $workspaceId;
31 
36 
41 
47  public function __construct(int $workspaceId = null, bool $includeRowsForWorkspacePreview = null, bool $enforceLiveRowsOnly = true)
48  {
49  $this->workspaceId = $workspaceId === null ? $GLOBALS['TSFE']->sys_page->versioningWorkspaceId : $workspaceId;
50  $this->includeRowsForWorkspacePreview = $includeRowsForWorkspacePreview === null ? $GLOBALS['TSFE']->sys_page->versioningPreview : $includeRowsForWorkspacePreview;
51  $this->enforceLiveRowsOnly = $enforceLiveRowsOnly;
52  }
53 
62  public function buildExpression(array $queriedTables, ExpressionBuilder $expressionBuilder): CompositeExpression
63  {
64  $constraints = [];
65  foreach ($queriedTables as $tableName => $tableAlias) {
66  $workspaceEnabled = $GLOBALS['TCA'][$tableName]['ctrl']['versioningWS'] ?? null;
67  if (!empty($workspaceEnabled)) {
68  $tablePrefix = $tableAlias ?: $tableName;
69  if (!$this->includeRowsForWorkspacePreview) {
70  // Filter out placeholder records (new/moved/deleted items)
71  // in case we are NOT in a versioning preview (That means we are online!)
72  $constraints[] = $expressionBuilder->lte(
73  $tablePrefix . '.t3ver_state',
74  // Trigger __toString(), then cast int
76  );
77  } elseif ($tableName !== 'pages') {
78  // Show only records of the live and current workspace in case we are in a versioning preview
79  $constraints[] = $expressionBuilder->orX(
80  $expressionBuilder->eq($tablePrefix . '.t3ver_wsid', 0),
81  $expressionBuilder->eq($tablePrefix . '.t3ver_wsid', (int)$this->workspaceId)
82  );
83  }
84  // Filter out versioned records
85  if ($this->enforceLiveRowsOnly) {
86  $constraints[] = $expressionBuilder->neq($tablePrefix . '.pid', -1);
87  }
88  }
89  }
90  return $expressionBuilder->andX(...$constraints);
91  }
92 }
buildExpression(array $queriedTables, ExpressionBuilder $expressionBuilder)
if(TYPO3_MODE=== 'BE') $GLOBALS['TYPO3_CONF_VARS']['SC_OPTIONS']['t3lib/class.t3lib_tsfebeuserauth.php']['frontendEditingController']['default']
__construct(int $workspaceId=null, bool $includeRowsForWorkspacePreview=null, bool $enforceLiveRowsOnly=true)