‪TYPO3CMS  ‪main
CategoryBasedFileCollection.php
Go to the documentation of this file.
1 <?php
2 
3 /*
4  * This file is part of the TYPO3 CMS project.
5  *
6  * It is free software; you can redistribute it and/or modify it under
7  * the terms of the GNU General Public License, either version 2
8  * of the License, or any later version.
9  *
10  * For the full copyright and license information, please read the
11  * LICENSE.txt file that was distributed with this source code.
12  *
13  * The TYPO3 project - inspiring people to share!
14  */
15 
17 
22 
28 {
32  protected static ‪$storageTableName = 'sys_file_collection';
33 
37  protected static ‪$type = 'categories';
38 
42  protected static ‪$itemsCriteriaField = 'category';
43 
47  protected ‪$itemTableName = 'sys_category';
48 
52  public function ‪loadContents()
53  {
54  $queryBuilder = GeneralUtility::makeInstance(ConnectionPool::class)->getQueryBuilderForTable('sys_category');
55  $queryBuilder->getRestrictions()->removeAll();
56  $statement = $queryBuilder->select('sys_file_metadata.file')
57  ->from('sys_category')
58  ->join(
59  'sys_category',
60  'sys_category_record_mm',
61  'sys_category_record_mm',
62  $queryBuilder->expr()->eq(
63  'sys_category_record_mm.uid_local',
64  $queryBuilder->quoteIdentifier('sys_category.uid')
65  )
66  )
67  ->join(
68  'sys_category_record_mm',
69  'sys_file_metadata',
70  'sys_file_metadata',
71  $queryBuilder->expr()->eq(
72  'sys_category_record_mm.uid_foreign',
73  $queryBuilder->quoteIdentifier('sys_file_metadata.uid')
74  )
75  )
76  ->where(
77  $queryBuilder->expr()->eq(
78  'sys_category.uid',
79  $queryBuilder->createNamedParameter($this->getItemsCriteria(), ‪Connection::PARAM_INT)
80  ),
81  $queryBuilder->expr()->eq(
82  'sys_category_record_mm.tablenames',
83  $queryBuilder->createNamedParameter('sys_file_metadata')
84  )
85  )
86  ->executeQuery();
87  $resourceFactory = GeneralUtility::makeInstance(ResourceFactory::class);
88  while (‪$record = $statement->fetchAssociative()) {
89  $this->‪add($resourceFactory->getFileObject((int)‪$record['file']));
90  }
91  }
92 }
‪TYPO3\CMS\Core\Resource\Collection
Definition: AbstractFileCollection.php:16
‪TYPO3\CMS\Core\Database\Connection\PARAM_INT
‪const PARAM_INT
Definition: Connection.php:52
‪TYPO3\CMS\Core\Resource\Collection\AbstractFileCollection
Definition: AbstractFileCollection.php:28
‪TYPO3\CMS\Core\Resource\Collection\CategoryBasedFileCollection
Definition: CategoryBasedFileCollection.php:28
‪TYPO3\CMS\Core\Resource\Collection\AbstractFileCollection\add
‪add(FileInterface $data)
Definition: AbstractFileCollection.php:188
‪TYPO3\CMS\Core\Resource\Collection\CategoryBasedFileCollection\$storageTableName
‪static string $storageTableName
Definition: CategoryBasedFileCollection.php:31
‪TYPO3\CMS\Core\Resource\ResourceFactory
Definition: ResourceFactory.php:42
‪TYPO3\CMS\Webhooks\Message\$record
‪identifier readonly int readonly array $record
Definition: PageModificationMessage.php:36
‪TYPO3\CMS\Core\Resource\Collection\CategoryBasedFileCollection\$type
‪static string $type
Definition: CategoryBasedFileCollection.php:35
‪TYPO3\CMS\Core\Database\Connection
Definition: Connection.php:41
‪TYPO3\CMS\Core\Resource\Collection\CategoryBasedFileCollection\$itemsCriteriaField
‪static string $itemsCriteriaField
Definition: CategoryBasedFileCollection.php:39
‪TYPO3\CMS\Core\Resource\Collection\CategoryBasedFileCollection\loadContents
‪loadContents()
Definition: CategoryBasedFileCollection.php:48
‪TYPO3\CMS\Core\Resource\Collection\CategoryBasedFileCollection\$itemTableName
‪string $itemTableName
Definition: CategoryBasedFileCollection.php:43
‪TYPO3\CMS\Core\Database\ConnectionPool
Definition: ConnectionPool.php:46
‪TYPO3\CMS\Core\Utility\GeneralUtility
Definition: GeneralUtility.php:52