CategoryCollection.php

Go to the documentation of this file.

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

/*
 * This file is part of the TYPO3 CMS project.
 *
 * It is free software; you can redistribute it and/or modify it under
 * the terms of the GNU General Public License, either version 2
 * of the License, or any later version.
 *
 * For the full copyright and license information, please read the
 * LICENSE.txt file that was distributed with this source code.
 *
 * The TYPO3 project - inspiring people to share!
 */

use TYPO3\CMS\Core\Utility\GeneralUtility;

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

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

    protected function getCollectedRecords()
    {
        $db = self::getDatabaseConnection();

        $relatedRecords = [];
        // Assemble where clause
        $where = 'AND ' . self::$storageTableName . '.uid = ' . (int)$this->getIdentifier();
        // Add condition on tablenames fields
        $where .= ' AND sys_category_record_mm.tablenames = ' . $db->fullQuoteStr(
            $this->getItemTableName(),
            'sys_category_record_mm'
        );
        // Add condition on fieldname field
        $where .= ' AND sys_category_record_mm.fieldname = ' . $db->fullQuoteStr(
            $this->getRelationFieldName(),
            'sys_category_record_mm'
        );
        // Add enable fields for item table
        $tsfe = self::getTypoScriptFrontendController();
        $where .= $tsfe->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 ($tsfe->sys_language_content > 0) {
                $languageCondition .= '
                    OR (' . $languageField . ' = ' . (int)$tsfe->sys_language_content . '
                    AND ' . $this->getItemTableName() . '.' .
                    $GLOBALS['TCA'][$this->getItemTableName()]['ctrl']['transOrigPointerField'] . ' = 0)
                ';
            }
            $where .= ' AND (' . $languageCondition . ')';
        }
        // Get the related records from the database
        $resource = $db->exec_SELECT_mm_query(
            $this->getItemTableName() . '.*',
            self::$storageTableName,
            'sys_category_record_mm',
            $this->getItemTableName(),
            $where
        );

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

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

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