PlainDataResolver.php

Go to the documentation of this file.

<?php
namespace TYPO3\CMS\Core\DataHandling;

/*
 * 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\Versioning\VersionState;
use TYPO3\CMS\Backend\Utility\BackendUtility;

class PlainDataResolver
{
    protected $tableName;

    protected $liveIds;

    protected $sortingStatement;

    protected $workspaceId;

    protected $keepLiveIds = false;

    protected $keepDeletePlaceholder = false;

    protected $resolvedIds;

    public function __construct($tableName, array $liveIds, $sortingStatement = null)
    {
        $this->tableName = $tableName;
        $this->liveIds = $this->reindex($liveIds);
        $this->sortingStatement = $sortingStatement;
    }

    public function setWorkspaceId($workspaceId)
    {
        $this->workspaceId = (int)$workspaceId;
    }

    public function setKeepLiveIds($keepLiveIds)
    {
        $this->keepLiveIds = (bool)$keepLiveIds;
    }

    public function setKeepDeletePlaceholder($keepDeletePlaceholder)
    {
        $this->keepDeletePlaceholder = (bool)$keepDeletePlaceholder;
    }

    public function get()
    {
        if (isset($this->resolvedIds)) {
            return $this->resolvedIds;
        }

        $ids = $this->processVersionOverlays($this->liveIds);
        $ids = $this->processSorting($ids);
        $ids = $this->applyLiveIds($ids);

        $this->resolvedIds = $ids;
        return $this->resolvedIds;
    }

    protected function processVersionOverlays(array $ids)
    {
        if (empty($this->workspaceId) || !$this->isWorkspaceEnabled() || empty($ids)) {
            return $ids;
        }

        $ids = $this->processVersionMovePlaceholders($ids);
        $versions = $this->getDatabaseConnection()->exec_SELECTgetRows(
            'uid,t3ver_oid,t3ver_state',
            $this->tableName,
            'pid=-1 AND t3ver_oid IN (' . $this->intImplode(',', $ids) . ')'
            . ' AND t3ver_wsid=' . $this->workspaceId
        );

        if (!empty($versions)) {
            foreach ($versions as $version) {
                $liveReferenceId = $version['t3ver_oid'];
                $versionId = $version['uid'];
                if (isset($ids[$liveReferenceId])) {
                    if (!$this->keepDeletePlaceholder && VersionState::cast($version['t3ver_state'])->equals(VersionState::DELETE_PLACEHOLDER)) {
                        unset($ids[$liveReferenceId]);
                    } else {
                        $ids[$liveReferenceId] = $versionId;
                    }
                }
            }
            $ids = $this->reindex($ids);
        }

        return $ids;
    }

    protected function processVersionMovePlaceholders(array $ids)
    {
        // Early return on insufficient data-set
        if (empty($this->workspaceId) || !$this->isWorkspaceEnabled() || empty($ids)) {
            return $ids;
        }

        $movePlaceholders = $this->getDatabaseConnection()->exec_SELECTgetRows(
            'uid,t3ver_move_id',
            $this->tableName,
            'pid<>-1 AND t3ver_state=' . VersionState::MOVE_PLACEHOLDER
            . ' AND t3ver_wsid=' . $this->workspaceId
            . ' AND t3ver_move_id IN (' . $this->intImplode(',', $ids) . ')'
        );

        if (!empty($movePlaceholders)) {
            foreach ($movePlaceholders as $movePlaceholder) {
                $liveReferenceId = $movePlaceholder['t3ver_move_id'];
                $movePlaceholderId = $movePlaceholder['uid'];
                // If both, MOVE_PLACEHOLDER and MOVE_POINTER are set
                if (isset($ids[$liveReferenceId]) && isset($ids[$movePlaceholderId])) {
                    $ids[$movePlaceholderId] = $liveReferenceId;
                    unset($ids[$liveReferenceId]);
                }
            }
            $ids = $this->reindex($ids);
        }

        return $ids;
    }

    protected function processSorting(array $ids)
    {
        // Early return on missing sorting statement or insufficient data-set
        if (empty($this->sortingStatement) || count($ids) < 2) {
            return $ids;
        }

        $records = $this->getDatabaseConnection()->exec_SELECTgetRows(
            'uid',
            $this->tableName,
            'uid IN (' . $this->intImplode(',', $ids) . ')',
            '',
            $this->sortingStatement,
            '',
            'uid'
        );

        if (!is_array($records)) {
            return array();
        }

        $ids = $this->reindex(array_keys($records));
        return $ids;
    }

    protected function applyLiveIds(array $ids)
    {
        if (!$this->keepLiveIds || !$this->isWorkspaceEnabled() || empty($ids)) {
            return $ids;
        }

        $records = $this->getDatabaseConnection()->exec_SELECTgetRows(
            'uid,t3ver_oid',
            $this->tableName,
            'uid IN (' . $this->intImplode(',', $ids) . ')',
            '',
            '',
            '',
            'uid'
        );

        if (!is_array($records)) {
            return array();
        }

        foreach ($ids as $id) {
            if (!empty($records[$id]['t3ver_oid'])) {
                $ids[$id] = $records[$id]['t3ver_oid'];
            }
        }

        $ids = $this->reindex($ids);
        return $ids;
    }

    protected function reindex(array $ids)
    {
        if (empty($ids)) {
            return $ids;
        }
        $ids = array_values($ids);
        $ids = array_combine($ids, $ids);
        return $ids;
    }

    protected function isWorkspaceEnabled()
    {
        return BackendUtility::isTableWorkspaceEnabled($this->tableName);
    }

    protected function isLocalizationEnabled()
    {
        return BackendUtility::isTableLocalizable($this->tableName);
    }

    protected function intImplode($delimiter, array $values)
    {
        return implode($delimiter, $this->getDatabaseConnection()->cleanIntArray($values));
    }

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