DatabaseTreeDataProvider.php

Go to the documentation of this file.

<?php
 
/*
 * 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!
 */
 
namespace ‪TYPO3\CMS\Core\Tree\TableConfiguration;
 
use Psr\EventDispatcher\EventDispatcherInterface;
use ‪TYPO3\CMS\Backend\Tree\SortedTreeNodeCollection;
use ‪TYPO3\CMS\Backend\Tree\TreeNode;
use ‪TYPO3\CMS\Backend\Tree\TreeNodeCollection;
use ‪TYPO3\CMS\Backend\Utility\BackendUtility;
use ‪TYPO3\CMS\Core\Database\ConnectionPool;
use ‪TYPO3\CMS\Core\Database\Query\Expression\ExpressionBuilder;
use ‪TYPO3\CMS\Core\Database\RelationHandler;
use ‪TYPO3\CMS\Core\Imaging\Icon;
use ‪TYPO3\CMS\Core\Imaging\IconFactory;
use ‪TYPO3\CMS\Core\Localization\LanguageService;
use ‪TYPO3\CMS\Core\Tree\Event\ModifyTreeDataEvent;
use ‪TYPO3\CMS\Core\Utility\GeneralUtility;
 
class ‪DatabaseTreeDataProvider extends ‪AbstractTableConfigurationTreeDataProvider
{
    const ‪SIGNAL_PostProcessTreeData = 'PostProcessTreeData';
    const ‪MODE_CHILDREN = 1;
    const ‪MODE_PARENT = 2;
 
    protected ‪$tableName = '';
 
    protected ‪$treeId = '';
 
    protected ‪$labelField = '';
 
    protected ‪$tableWhere = '';
 
    protected ‪$lookupMode = ‪self::MODE_CHILDREN;
 
    protected ‪$lookupField = '';
 
    protected ‪$rootUid = 0;
 
    protected ‪$idCache = [];
 
    protected ‪$columnConfiguration;
 
    protected ‪$nodeSortValues = [];
 
    protected ‪$generatedTSConfig = [];
 
    protected ‪$eventDispatcher;
 
    public function ‪__construct(EventDispatcherInterface ‪$eventDispatcher)
    {
        $this->eventDispatcher = ‪$eventDispatcher;
    }
 
    public function ‪setLabelField(‪$labelField)
    {
        $this->labelField = ‪$labelField;
    }
 
    public function ‪getLabelField()
    {
        return ‪$this->labelField;
    }
 
    public function ‪setTableName(‪$tableName)
    {
        $this->tableName = ‪$tableName;
    }
 
    public function ‪getTableName()
    {
        return ‪$this->tableName;
    }
 
    public function ‪setLookupField(‪$lookupField)
    {
        $this->lookupField = ‪$lookupField;
    }
 
    public function ‪getLookupField()
    {
        return ‪$this->lookupField;
    }
 
    public function ‪setLookupMode(‪$lookupMode)
    {
        $this->lookupMode = ‪$lookupMode;
    }
 
    public function ‪getLookupMode()
    {
        return ‪$this->lookupMode;
    }
 
    public function ‪getNodes(TreeNode $node)
    {
    }
 
    public function ‪getRoot()
    {
        return $this->‪buildRepresentationForNode($this->treeData);
    }
 
    public function ‪setRootUid(‪$rootUid)
    {
        $this->rootUid = ‪$rootUid;
    }
 
    public function ‪getRootUid()
    {
        return ‪$this->rootUid;
    }
 
    public function ‪setTableWhere(‪$tableWhere)
    {
        $this->tableWhere = ‪$tableWhere;
    }
 
    public function ‪getTableWhere()
    {
        return ‪$this->tableWhere;
    }
 
    protected function ‪buildRepresentationForNode(‪TreeNode $basicNode, ‪DatabaseTreeNode $parent = null, $level = 0)
    {
        $node = GeneralUtility::makeInstance(DatabaseTreeNode::class);
        $row = [];
        if ($basicNode->‪getId() == 0) {
            $node->setSelected(false);
            $node->setExpanded(true);
            $node->setLabel($this->‪getLanguageService()->sL(‪$GLOBALS['TCA'][$this->tableName]['ctrl']['title']));
        } else {
            $row = ‪BackendUtility::getRecordWSOL($this->tableName, (int)$basicNode->‪getId(), '*', '', false);
            $node->setLabel(‪BackendUtility::getRecordTitle($this->tableName, $row) ?: $basicNode->‪getId());
            $node->setSelected(GeneralUtility::inList($this->‪getSelectedList(), $basicNode->‪getId()));
            $node->setExpanded($this->‪isExpanded($basicNode));
        }
        $node->setId($basicNode->‪getId());
        $node->setSelectable(!GeneralUtility::inList($this->‪getNonSelectableLevelList(), (string)$level) && !in_array($basicNode->‪getId(), $this->getItemUnselectableList()));
        $node->setSortValue($this->nodeSortValues[$basicNode->‪getId()]);
        $iconFactory = GeneralUtility::makeInstance(IconFactory::class);
        $node->setIcon($iconFactory->getIconForRecord($this->tableName, $row, ‪Icon::SIZE_SMALL));
        $node->setParentNode($parent);
        if ($basicNode->‪hasChildNodes()) {
            $node->setHasChildren(true);
            $childNodes = GeneralUtility::makeInstance(SortedTreeNodeCollection::class);
            $tempNodes = [];
            foreach ($basicNode->‪getChildNodes() as $child) {
                $tempNodes[] = $this->‪buildRepresentationForNode($child, $node, $level + 1);
            }
            $childNodes->exchangeArray($tempNodes);
            $childNodes->asort();
            $node->setChildNodes($childNodes);
        }
        return $node;
    }
 
    public function ‪initializeTreeData()
    {
        parent::initializeTreeData();
        $this->nodeSortValues = array_flip($this->itemWhiteList);
        $this->columnConfiguration = ‪$GLOBALS['TCA'][$this->‪getTableName()]['columns'][$this->‪getLookupField()]['config'];
        if (isset($this->columnConfiguration['foreign_table']) && $this->columnConfiguration['foreign_table'] != $this->‪getTableName()) {
            throw new \InvalidArgumentException('TCA Tree configuration is invalid: tree for different node-Tables is not implemented yet', 1290944650);
        }
        $this->treeData = GeneralUtility::makeInstance(TreeNode::class);
        $this->‪loadTreeData();
        $event = $this->eventDispatcher->dispatch(new ‪ModifyTreeDataEvent($this->treeData, $this));
        $this->treeData = $event->getTreeData();
    }
 
    protected function ‪loadTreeData()
    {
        $this->treeData->setId($this->‪getRootUid());
        $this->treeData->setParentNode(null);
        if ($this->levelMaximum >= 1) {
            $childNodes = $this->‪getChildrenOf($this->treeData, 1);
            if ($childNodes !== null) {
                $this->treeData->setChildNodes($childNodes);
            }
        }
    }
 
    protected function ‪getChildrenOf(TreeNode $node, $level)
    {
        $nodeData = null;
        if ($node->getId() !== 0) {
            $queryBuilder = GeneralUtility::makeInstance(ConnectionPool::class)
                ->getQueryBuilderForTable($this->‪getTableName());
            $queryBuilder->getRestrictions()->removeAll();
            $nodeData = $queryBuilder->select('*')
                ->from($this->‪getTableName())
                ->where(
                    $queryBuilder->expr()->eq(
                        'uid',
                        $queryBuilder->createNamedParameter($node->getId(), \PDO::PARAM_INT)
                    )
                )
                ->setMaxResults(1)
                ->execute()
                ->fetch();
        }
        if (empty($nodeData)) {
            $nodeData = [
                'uid' => 0,
                $this->‪getLookupField() => ''
            ];
        }
        $storage = null;
        $children = $this->‪getRelatedRecords($nodeData);
        if (!empty($children)) {
            $storage = GeneralUtility::makeInstance(TreeNodeCollection::class);
            foreach ($children as $child) {
                $node = GeneralUtility::makeInstance(TreeNode::class);
                $node->setId($child);
                if ($level < $this->levelMaximum) {
                    $children = $this->‪getChildrenOf($node, $level + 1);
                    if ($children !== null) {
                        $node->setChildNodes($children);
                    }
                }
                $storage->append($node);
            }
        }
        return $storage;
    }
 
    protected function ‪getRelatedRecords(array $row)
    {
        if ($this->‪getLookupMode() == self::MODE_PARENT) {
            $children = $this->‪getChildrenUidsFromParentRelation($row);
        } else {
            $children = $this->‪getChildrenUidsFromChildrenRelation($row);
        }
        $allowedArray = [];
        foreach ($children as $child) {
            if (!in_array($child, $this->idCache) && in_array($child, $this->itemWhiteList)) {
                $allowedArray[] = $child;
            }
        }
        $this->idCache = array_merge($this->idCache, $allowedArray);
        return $allowedArray;
    }
 
    protected function ‪getChildrenUidsFromParentRelation(array $row)
    {
        $uid = $row['uid'];
        switch ((string)$this->columnConfiguration['type']) {
            case 'inline':
 
            case 'select':
                if ($this->columnConfiguration['MM']) {
                    $dbGroup = GeneralUtility::makeInstance(RelationHandler::class);
                    // Dummy field for setting "look from other site"
                    $this->columnConfiguration['MM_oppositeField'] = 'children';
                    $dbGroup->start($row[$this->‪getLookupField()], $this->‪getTableName(), $this->columnConfiguration['MM'], $uid, $this->‪getTableName(), $this->columnConfiguration);
                    $relatedUids = $dbGroup->tableArray[$this->‪getTableName()];
                } elseif ($this->columnConfiguration['foreign_field']) {
                    $relatedUids = $this->‪listFieldQuery($this->columnConfiguration['foreign_field'], $uid);
                } else {
                    $relatedUids = $this->‪listFieldQuery($this->‪getLookupField(), $uid);
                }
                break;
            default:
                $relatedUids = $this->‪listFieldQuery($this->‪getLookupField(), $uid);
        }
        return $relatedUids;
    }
 
    protected function ‪getChildrenUidsFromChildrenRelation(array $row)
    {
        $relatedUids = [];
        $uid = $row['uid'];
        $value = $row[$this->‪getLookupField()];
        switch ((string)$this->columnConfiguration['type']) {
            case 'inline':
                // Intentional fall-through
            case 'select':
                if ($this->columnConfiguration['MM']) {
                    $dbGroup = GeneralUtility::makeInstance(RelationHandler::class);
                    $dbGroup->start(
                        $value,
                        $this->‪getTableName(),
                        $this->columnConfiguration['MM'],
                        $uid,
                        $this->‪getTableName(),
                        $this->columnConfiguration
                    );
                    $relatedUids = $dbGroup->tableArray[$this->‪getTableName()];
                } elseif ($this->columnConfiguration['foreign_field']) {
                    $queryBuilder = GeneralUtility::makeInstance(ConnectionPool::class)
                        ->getQueryBuilderForTable($this->‪getTableName());
                    $queryBuilder->getRestrictions()->removeAll();
                    $records = $queryBuilder->select('uid')
                        ->from($this->‪getTableName())
                        ->where(
                            $queryBuilder->expr()->eq(
                                $this->columnConfiguration['foreign_field'],
                                $queryBuilder->createNamedParameter($uid, \PDO::PARAM_INT)
                            )
                        )
                        ->execute()
                        ->fetchAll();
 
                    if (!empty($records)) {
                        $relatedUids = array_column($records, 'uid');
                    }
                } else {
                    $relatedUids = ‪GeneralUtility::intExplode(',', $value, true);
                }
                break;
            default:
                $relatedUids = ‪GeneralUtility::intExplode(',', $value, true);
        }
        return $relatedUids;
    }
 
    protected function ‪listFieldQuery($fieldName, $queryId)
    {
        $queryId = (int)$queryId;
        $queryBuilder = GeneralUtility::makeInstance(ConnectionPool::class)
            ->getQueryBuilderForTable($this->‪getTableName());
        $queryBuilder->getRestrictions()->removeAll();
 
        $queryBuilder->select('uid')
            ->from($this->‪getTableName())
            ->where($queryBuilder->expr()->inSet($fieldName, $queryBuilder->quote($queryId)));
 
        if ($queryId === 0) {
            $queryBuilder->orWhere(
                $queryBuilder->expr()->comparison(
                    'CAST(' . $queryBuilder->quoteIdentifier($fieldName) . ' AS CHAR)',
                    ‪ExpressionBuilder::EQ,
                    $queryBuilder->quote('')
                )
            );
        }
 
        $records = $queryBuilder->execute()->fetchAll();
        $uidArray = is_array($records) ? array_column($records, 'uid') : [];
 
        return $uidArray;
    }
 
    protected function ‪getLanguageService(): ?LanguageService
    {
        return ‪$GLOBALS['LANG'] ?? null;
    }
}