CategoryBasedFileCollection.php

Go to the documentation of this file.

<?php
namespace TYPO3\CMS\Core\Resource\Collection;

class CategoryBasedFileCollection extends \TYPO3\CMS\Core\Resource\Collection\AbstractFileCollection {

    static protected $storageTableName = 'sys_file_collection';

    static protected $type = 'categories';

    static protected $itemsCriteriaField = 'category';

    protected $itemTableName = 'sys_category';

    public function loadContents() {

        $resource = $this->getDatabaseConnection()->exec_SELECT_mm_query(
            'sys_file_metadata.file',
            'sys_category',
            'sys_category_record_mm',
            'sys_file_metadata',
            'AND sys_category.uid=' . (int)$this->getItemsCriteria() .
            ' AND sys_category_record_mm.tablenames = \'sys_file_metadata\''
        );

        $resourceFactory = \TYPO3\CMS\Core\Resource\ResourceFactory::getInstance();
        if ($resource) {
            while (($record = $this->getDatabaseConnection()->sql_fetch_assoc($resource)) !== FALSE) {
                $this->add($resourceFactory->getFileObject((int)$record['file']));
            }
            $this->getDatabaseConnection()->sql_free_result($resource);
        }
    }

    protected function getDatabaseConnection() {
        return $GLOBALS['TYPO3_DB'];
    }

}