CategoryCollection.php

Go to the documentation of this file.

<?php
namespace TYPO3\CMS\Frontend\Category\Collection;

class CategoryCollection extends \TYPO3\CMS\Core\Category\Collection\CategoryCollection {

    static public function create(array $collectionRecord, $fillItems = FALSE) {
        $collection = \TYPO3\CMS\Core\Utility\GeneralUtility::makeInstance(
            'TYPO3\\CMS\\Frontend\\Category\\Collection\\CategoryCollection',
            $collectionRecord['table_name'],
            $collectionRecord['field_name']
        );
        $collection->fromArray($collectionRecord);
        if ($fillItems) {
            $collection->loadContents();
        }
        return $collection;
    }

    static public function load($id, $fillItems = FALSE, $tableName = '', $fieldName = '') {
        $collectionRecord = $GLOBALS['TYPO3_DB']->exec_SELECTgetSingleRow(
            '*',
            static::$storageTableName,
            'uid = ' . (int)$id . self::getFrontendObject()->sys_page->enableFields(static::$storageTableName)
        );
        $collectionRecord['table_name'] = $tableName;
        $collectionRecord['field_name'] = $fieldName;
        return self::create($collectionRecord, $fillItems);
    }

    protected function getCollectedRecords() {
        $relatedRecords = array();
        // Assemble where clause
        $where = 'AND ' . self::$storageTableName . '.uid = ' . (int)$this->getIdentifier();
        // Add condition on tablenames fields
        $where .= ' AND sys_category_record_mm.tablenames = ' . $this->getDatabaseConnection()->fullQuoteStr(
            $this->getItemTableName(),
            'sys_category_record_mm'
        );
        // Add condition on fieldname field
        $where .= ' AND sys_category_record_mm.fieldname = ' . $this->getDatabaseConnection()->fullQuoteStr(
            $this->getRelationFieldName(),
            'sys_category_record_mm'
        );
        // Add enable fields for item table
        $where .= self::getFrontendObject()->sys_page->enableFields($this->getItemTableName());
        // If language handling is defined for item table, add language condition
        if (isset($GLOBALS['TCA'][$this->getItemTableName()]['ctrl']['languageField'])) {
            // Consider default or "all" language
            $languageField = $this->getItemTableName() . '.' . $GLOBALS['TCA'][$this->getItemTableName()]['ctrl']['languageField'];
            $languageCondition = $languageField . ' IN (0, -1)';
            // If not in default language, also consider items in current language with no original
            if ($this->getFrontendObject()->sys_language_content > 0) {
                $languageCondition .= '
                    OR (' . $languageField . ' = ' . (int)$this->getFrontendObject()->sys_language_content . '
                    AND ' . $this->getItemTableName() . '.' .
                    $GLOBALS['TCA'][$this->getItemTableName()]['ctrl']['transOrigPointerField'] . ' = 0)
                ';
            }
            $where .= ' AND (' . $languageCondition . ')';
        }
        // Get the related records from the database
        $resource = $this->getDatabaseConnection()->exec_SELECT_mm_query(
            $this->getItemTableName() . '.*',
            self::$storageTableName,
            'sys_category_record_mm',
            $this->getItemTableName(),
            $where
        );

        if ($resource) {
            while ($record = $this->getDatabaseConnection()->sql_fetch_assoc($resource)) {
                // Overlay the record for workspaces
                $this->getFrontendObject()->sys_page->versionOL(
                    $this->getItemTableName(),
                    $record
                );
                // Overlay the record for translations
                if (is_array($record) && $this->getFrontendObject()->sys_language_contentOL) {
                    if ($this->getItemTableName() === 'pages') {
                        $record = $this->getFrontendObject()->sys_page->getPageOverlay($record);
                    } else {
                        $record = $this->getFrontendObject()->sys_page->getRecordOverlay(
                            $this->getItemTableName(),
                            $record,
                            $this->getFrontendObject()->sys_language_content,
                            $this->getFrontendObject()->sys_language_contentOL
                        );
                    }
                }
                // Record may have been unset during the overlay process
                if (is_array($record)) {
                    $relatedRecords[] = $record;
                }
            }
            $this->getDatabaseConnection()->sql_free_result($resource);
        }
        return $relatedRecords;
    }

    static protected function getFrontendObject() {
        return $GLOBALS['TSFE'];
    }
}