‪TYPO3CMS  ‪main
ConsistencyRestriction.php
Go to the documentation of this file.
1 <?php
2 
3 declare(strict_types=1);
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 
19 
23 use TYPO3\CMS\Core\Database\Query\QueryBuilder;
25 
30 {
34  private ‪$queryBuilder;
35 
36  public function ‪__construct(QueryBuilder ‪$queryBuilder)
37  {
38  $this->queryBuilder = ‪$queryBuilder;
39  }
40 
41  public function ‪buildExpression(array $queriedTables, ‪ExpressionBuilder $expressionBuilder): ‪CompositeExpression
42  {
43  $constraints = [];
44  foreach ($queriedTables as $tableAlias => $tableName) {
45  if ($tableName === 'sys_file') {
46  $constraints[] = $this->queryBuilder->expr()->eq($tableAlias . '.missing', $this->queryBuilder->createNamedParameter(0, ‪Connection::PARAM_INT));
47  }
48  }
49 
50  return $expressionBuilder->‪and(...$constraints);
51  }
52 }
‪TYPO3\CMS\Core\Database\Connection\PARAM_INT
‪const PARAM_INT
Definition: Connection.php:52
‪TYPO3\CMS\Core\Database\Query\Expression\ExpressionBuilder
Definition: ExpressionBuilder.php:40
‪TYPO3\CMS\Core\Database\Query\Restriction\QueryRestrictionInterface
Definition: QueryRestrictionInterface.php:27
‪TYPO3\CMS\Core\Database\Query\Expression\CompositeExpression
Definition: CompositeExpression.php:27
‪TYPO3\CMS\Core\Resource\Search\QueryRestrictions\ConsistencyRestriction
Definition: ConsistencyRestriction.php:30
‪TYPO3\CMS\Core\Resource\Search\QueryRestrictions\ConsistencyRestriction\buildExpression
‪buildExpression(array $queriedTables, ExpressionBuilder $expressionBuilder)
Definition: ConsistencyRestriction.php:40
‪TYPO3\CMS\Core\Resource\Search\QueryRestrictions\ConsistencyRestriction\$queryBuilder
‪QueryBuilder $queryBuilder
Definition: ConsistencyRestriction.php:33
‪TYPO3\CMS\Core\Resource\Search\QueryRestrictions
Definition: ConsistencyRestriction.php:18
‪TYPO3\CMS\Core\Database\Connection
Definition: Connection.php:41
‪TYPO3\CMS\Core\Resource\Search\QueryRestrictions\ConsistencyRestriction\__construct
‪__construct(QueryBuilder $queryBuilder)
Definition: ConsistencyRestriction.php:35
‪TYPO3\CMS\Core\Database\Query\Expression\ExpressionBuilder\and
‪and(CompositeExpression|\Doctrine\DBAL\Query\Expression\CompositeExpression|string|null ... $expressions,)
Definition: ExpressionBuilder.php:50