‪TYPO3CMS  10.4
FolderIdentifierRestriction.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 
25 
31 {
35  private ‪$folderIdentifier;
36 
37  public function ‪__construct(string ‪$folderIdentifier)
38  {
39  $this->folderIdentifier = ‪$folderIdentifier;
40  }
41 
42  public function ‪buildExpression(array $queriedTables, ‪ExpressionBuilder $expressionBuilder): ‪CompositeExpression
43  {
44  $constraints = [];
45  foreach ($queriedTables as $tableAlias => $tableName) {
46  if ($tableName !== 'sys_file') {
47  continue;
48  }
49  $connection = GeneralUtility::makeInstance(ConnectionPool::class)->getConnectionForTable($tableName);
50  ‪$folderIdentifier = $connection->createQueryBuilder()->escapeLikeWildcards($this->folderIdentifier);
51  $constraints[] = $expressionBuilder->‪like(
52  $tableAlias . '.identifier',
53  $connection->quote(‪$folderIdentifier . '%')
54  );
55  }
56 
57  return $expressionBuilder->‪orX(...$constraints);
58  }
59 }
‪TYPO3\CMS\Core\Database\Query\Expression\ExpressionBuilder\like
‪string like(string $fieldName, $value)
Definition: ExpressionBuilder.php:217
‪TYPO3\CMS\Core\Database\Query\Expression\ExpressionBuilder
Definition: ExpressionBuilder.php:35
‪TYPO3\CMS\Core\Database\Query\Restriction\QueryRestrictionInterface
Definition: QueryRestrictionInterface.php:27
‪TYPO3\CMS\Core\Resource\Search\QueryRestrictions\FolderIdentifierRestriction
Definition: FolderIdentifierRestriction.php:31
‪TYPO3\CMS\Core\Resource\Search\QueryRestrictions\FolderIdentifierRestriction\buildExpression
‪buildExpression(array $queriedTables, ExpressionBuilder $expressionBuilder)
Definition: FolderIdentifierRestriction.php:41
‪TYPO3\CMS\Core\Database\Query\Expression\CompositeExpression
Definition: CompositeExpression.php:25
‪TYPO3\CMS\Core\Resource\Search\QueryRestrictions\FolderIdentifierRestriction\$folderIdentifier
‪string $folderIdentifier
Definition: FolderIdentifierRestriction.php:34
‪TYPO3\CMS\Core\Database\Query\Expression\ExpressionBuilder\orX
‪CompositeExpression orX(... $expressions)
Definition: ExpressionBuilder.php:82
‪TYPO3\CMS\Core\Resource\Search\QueryRestrictions
Definition: ConsistencyRestriction.php:18
‪TYPO3\CMS\Core\Resource\Search\QueryRestrictions\FolderIdentifierRestriction\__construct
‪__construct(string $folderIdentifier)
Definition: FolderIdentifierRestriction.php:36
‪TYPO3\CMS\Core\Database\ConnectionPool
Definition: ConnectionPool.php:46
‪TYPO3\CMS\Core\Utility\GeneralUtility
Definition: GeneralUtility.php:46