ElementInformationController.php

Go to the documentation of this file.

<?php
namespace TYPO3\CMS\Backend\Controller\ContentElement;

/*
 * 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 Psr\Http\Message\ResponseInterface;
use Psr\Http\Message\ServerRequestInterface;
use TYPO3\CMS\Backend\Backend\Avatar\Avatar;
use TYPO3\CMS\Backend\Utility\BackendUtility;
use TYPO3\CMS\Core\Imaging\Icon;
use TYPO3\CMS\Core\Imaging\IconFactory;
use TYPO3\CMS\Core\Resource\AbstractFile;
use TYPO3\CMS\Core\Resource\Folder;
use TYPO3\CMS\Core\Resource\ProcessedFile;
use TYPO3\CMS\Core\Resource\ResourceFactory;
use TYPO3\CMS\Core\Utility\GeneralUtility;

class ElementInformationController
{
    public $table;

    public $uid;

    protected $permsClause;

    public $access = false;

    public $type = '';

    public $doc;

    protected $content = '';

    public $pageInfo;

    protected $row;

    protected $fileObject;

    protected $folderObject;

    protected $titleTag;

    protected $iconFactory;

    public function __construct()
    {
        $this->iconFactory = GeneralUtility::makeInstance(IconFactory::class);
        $GLOBALS['SOBE'] = $this;

        $this->init();
    }

    public function init()
    {
        $this->table = GeneralUtility::_GET('table');
        $this->uid = GeneralUtility::_GET('uid');

        $this->permsClause = $this->getBackendUser()->getPagePermsClause(1);
        $this->doc = GeneralUtility::makeInstance(\TYPO3\CMS\Backend\Template\DocumentTemplate::class);
        $this->doc->divClass = 'container';

        if (isset($GLOBALS['TCA'][$this->table])) {
            $this->initDatabaseRecord();
        } elseif ($this->table == '_FILE' || $this->table == '_FOLDER' || $this->table == 'sys_file') {
            $this->initFileOrFolderRecord();
        }
    }

    protected function initDatabaseRecord()
    {
        $this->type = 'db';
        $this->uid = (int)$this->uid;

        // Check permissions and uid value:
        if ($this->uid && $this->getBackendUser()->check('tables_select', $this->table)) {
            if ((string)$this->table == 'pages') {
                $this->pageInfo = BackendUtility::readPageAccess($this->uid, $this->permsClause);
                $this->access = is_array($this->pageInfo) ? 1 : 0;
                $this->row = $this->pageInfo;
            } else {
                $this->row = BackendUtility::getRecordWSOL($this->table, $this->uid);
                if ($this->row) {
                    $this->pageInfo = BackendUtility::readPageAccess($this->row['pid'], $this->permsClause);
                    $this->access = is_array($this->pageInfo) ? 1 : 0;
                }
            }
        }
    }

    protected function initFileOrFolderRecord()
    {
        $fileOrFolderObject = ResourceFactory::getInstance()->retrieveFileOrFolderObject($this->uid);

        if ($fileOrFolderObject instanceof Folder) {
            $this->folderObject = $fileOrFolderObject;
            $this->access = $this->folderObject->checkActionPermission('read');
            $this->type = 'folder';
        } else {
            $this->fileObject = $fileOrFolderObject;
            $this->access = $this->fileObject->checkActionPermission('read');
            $this->type = 'file';
            $this->table = 'sys_file';

            try {
                $this->row = BackendUtility::getRecordWSOL($this->table, $fileOrFolderObject->getUid());
            } catch (\Exception $e) {
                $this->row = [];
            }
        }
    }

    public function mainAction(ServerRequestInterface $request, ResponseInterface $response)
    {
        $this->main();

        $content = $this->doc->startPage($this->titleTag);
        $content .= $this->doc->insertStylesAndJS($this->content);
        $content .= $this->doc->endPage();

        $response->getBody()->write($content);
        return $response;
    }

    public function main()
    {
        if (!$this->access) {
            return;
        }

        // render type by user func
        $typeRendered = false;
        if (is_array($GLOBALS['TYPO3_CONF_VARS']['SC_OPTIONS']['typo3/show_item.php']['typeRendering'])) {
            foreach ($GLOBALS['TYPO3_CONF_VARS']['SC_OPTIONS']['typo3/show_item.php']['typeRendering'] as $classRef) {
                $typeRenderObj = GeneralUtility::getUserObj($classRef);
                // @todo should have an interface
                if (is_object($typeRenderObj) && method_exists($typeRenderObj, 'isValid') && method_exists($typeRenderObj, 'render')) {
                    if ($typeRenderObj->isValid($this->type, $this)) {
                        $this->content .= $typeRenderObj->render($this->type, $this);
                        $typeRendered = true;
                        break;
                    }
                }
            }
        }

        if (!$typeRendered) {
            $this->content .= $this->renderPageTitle();
            $this->content .= $this->renderPreview();
            $this->content .= $this->renderPropertiesAsTable();
            $this->content .= $this->renderReferences();
            $this->content .= $this->renderBackButton();
        }
    }

    protected function renderPageTitle()
    {
        if ($this->type === 'folder') {
            $table = $this->getLanguageService()->sL('LLL:EXT:lang/locallang_common.xlf:folder');
            $title = $this->doc->getResourceHeader($this->folderObject, [' ', ''], false);
        } elseif ($this->type === 'file') {
            $table = $this->getLanguageService()->sL($GLOBALS['TCA'][$this->table]['ctrl']['title']);
            $title = $this->doc->getResourceHeader($this->fileObject, [' ', ''], false);
        } else {
            $table = $this->getLanguageService()->sL($GLOBALS['TCA'][$this->table]['ctrl']['title']);
            $title = $this->doc->getHeader($this->table, $this->row, $this->pageInfo['_thePath'], 1, [' ', ''], false);
        }
        // Set HTML title tag
        $this->titleTag = $table . ': ' . strip_tags(BackendUtility::getRecordTitle($this->table, $this->row));
        return '<h1>' .
                ($table ? '<small>' . $table . '</small><br />' : '') .
                $title .
                '</h1>';
    }

    protected function renderPreview()
    {
        // Perhaps @todo in future: Also display preview for records - without fileObject
        if (!$this->fileObject) {
            return '';
        }

        $previewTag = '';
        $showLink = '';

        // check if file is marked as missing
        if ($this->fileObject->isMissing()) {
            $previewTag .= '<span class="label label-danger">'
                . htmlspecialchars(static::getLanguageService()->sL('LLL:EXT:lang/locallang_core.xlf:warning.file_missing'))
                . '</span>&nbsp;' . htmlspecialchars($this->fileObject->getName()) . '<br />';
        } else {

            $rendererRegistry = GeneralUtility::makeInstance(\TYPO3\CMS\Core\Resource\Rendering\RendererRegistry::class);
            $fileRenderer = $rendererRegistry->getRenderer($this->fileObject);
            $fileExtension = $this->fileObject->getExtension();
            $url = $this->fileObject->getPublicUrl(true);

            // Check if there is a FileRenderer
            if ($fileRenderer !== null) {
                $previewTag = $fileRenderer->render(
                    $this->fileObject,
                    '590m',
                    '400m',
                    [],
                    true
                );

            // else check if we can create an Image preview
            } elseif (GeneralUtility::inList($GLOBALS['TYPO3_CONF_VARS']['GFX']['imagefile_ext'], $fileExtension)) {
                $processedFile = $this->fileObject->process(
                    ProcessedFile::CONTEXT_IMAGEPREVIEW,
                    [
                        'width' => '590m',
                        'height' => '400m'
                    ]
                );
                // Create thumbnail image?
                if ($processedFile) {
                    $thumbUrl = $processedFile->getPublicUrl(true);
                    $previewTag .= '<img class="img-responsive img-thumbnail" src="' . $thumbUrl . '" ' .
                        'width="' . $processedFile->getProperty('width') . '" ' .
                        'height="' . $processedFile->getProperty('height') . '" ' .
                        'alt="' . htmlspecialchars(trim($this->fileObject->getName())) . '" ' .
                        'title="' . htmlspecialchars(trim($this->fileObject->getName())) . '" />';
                }
            }

            // Show
            if ($url) {
                $showLink .= '
                    <a class="btn btn-primary" href="' . htmlspecialchars($url) . '" target="_blank">
                        ' . $this->iconFactory->getIcon('actions-document-view', Icon::SIZE_SMALL)->render() . '
                        ' . $this->getLanguageService()->sL('LLL:EXT:lang/locallang_core.xlf:labels.show', true) . '
                    </a>';
            }
        }

        return ($previewTag ? '<p>' . $previewTag . '</p>' : '') .
                ($showLink ? '<p>' . $showLink . '</p>' : '');
    }

    protected function renderPropertiesAsTable()
    {
        $tableRows = [];
        $extraFields = [];

        $lang = $this->getLanguageService();
        if (in_array($this->type, ['folder', 'file'], true)) {
            if ($this->type === 'file') {
                $extraFields['creation_date'] = $lang->sL('LLL:EXT:lang/locallang_general.xlf:LGL.creationDate', true);
                $extraFields['modification_date'] = $lang->sL('LLL:EXT:lang/locallang_general.xlf:LGL.timestamp', true);
                if ($this->fileObject->getType() === AbstractFile::FILETYPE_IMAGE) {
                    $extraFields['width'] = htmlspecialchars($lang->sL('LLL:EXT:lang/locallang_general.xlf:LGL.width'));
                    $extraFields['height'] = htmlspecialchars($lang->sL('LLL:EXT:lang/locallang_general.xlf:LGL.height'));
                }
            }
            $extraFields['storage'] = $lang->sL('LLL:EXT:lang/locallang_tca.xlf:sys_file.storage', true);
            $extraFields['folder'] = $lang->sL('LLL:EXT:lang/locallang_common.xlf:folder', true);
        } else {
            $extraFields['crdate'] = $lang->sL('LLL:EXT:lang/locallang_general.xlf:LGL.creationDate', true);
            $extraFields['cruser_id'] = $lang->sL('LLL:EXT:lang/locallang_general.xlf:LGL.creationUserId', true);
            $extraFields['tstamp'] = $lang->sL('LLL:EXT:lang/locallang_general.xlf:LGL.timestamp', true);

            // check if the special fields are defined in the TCA ctrl section of the table
            foreach ($extraFields as $fieldName => $fieldLabel) {
                if (isset($GLOBALS['TCA'][$this->table]['ctrl'][$fieldName])) {
                    $extraFields[$GLOBALS['TCA'][$this->table]['ctrl'][$fieldName]] = $fieldLabel;
                } else {
                    unset($extraFields[$fieldName]);
                }
            }
        }

        foreach ($extraFields as $name => $fieldLabel) {
            $rowValue = '';
            if (!isset($this->row[$name])) {
                $resourceObject = $this->fileObject ?: $this->folderObject;
                if ($name === 'storage') {
                    $rowValue = $resourceObject->getStorage()->getName();
                } elseif ($name === 'folder') {
                    $rowValue = $resourceObject->getParentFolder()->getReadablePath();
                } elseif ($name === 'width') {
                    $rowValue = $this->fileObject->getProperty('width') . 'px';
                } elseif ($name === 'height') {
                    $rowValue = $this->fileObject->getProperty('height') . 'px';
                }
            } elseif ($name === 'creation_date' || $name === 'modification_date') {
                $rowValue = BackendUtility::datetime($this->row[$name]);
            } else {
                $rowValue = BackendUtility::getProcessedValueExtra($this->table, $name, $this->row[$name]);
            }
            // show the backend username who created the issue
            if ($name === 'cruser_id' && $rowValue) {
                $creatorRecord = BackendUtility::getRecord('be_users', $rowValue);
                if ($creatorRecord) {
                    $avatar = GeneralUtility::makeInstance(Avatar::class);
                    $icon = $avatar->render($creatorRecord);
                    $rowValue = '
                        <div class="media">
                            <div class="media-left">
                                ' . $icon . '
                            </div>
                            <div class="media-body">
                                <strong>' . htmlspecialchars($creatorRecord['username']) . '</strong><br>
                                ' . ($creatorRecord['realName'] ? htmlspecialchars($creatorRecord['realName']) : '') . '
                            </div>
                        </div>';
                }
            }

            $tableRows[] = '
                <tr>
                    <th class="col-nowrap">' . rtrim($fieldLabel, ':') . '</th>
                    <td>' . ($name === 'cruser_id' ? $rowValue : htmlspecialchars($rowValue)) . '</td>
                </tr>';
        }

        // Traverse the list of fields to display for the record:
        $fieldList = GeneralUtility::trimExplode(',', $GLOBALS['TCA'][$this->table]['interface']['showRecordFieldList'], true);
        foreach ($fieldList as $name) {
            $name = trim($name);
            $uid = $this->row['uid'];

            if (!isset($GLOBALS['TCA'][$this->table]['columns'][$name])) {
                continue;
            }

            // Storage is already handled above
            if ($this->type === 'file' && $name === 'storage') {
                continue;
            }

            // format file size as bytes/kilobytes/megabytes
            if ($this->type === 'file' && $name === 'size') {
                $this->row[$name] = GeneralUtility::formatSize($this->row[$name], $this->getLanguageService()->sL('LLL:EXT:lang/locallang_common.xlf:byteSizeUnits', true));
            }

            $isExcluded = !(!$GLOBALS['TCA'][$this->table]['columns'][$name]['exclude'] || $this->getBackendUser()->check('non_exclude_fields', $this->table . ':' . $name));
            if ($isExcluded) {
                continue;
            }

            $itemValue = BackendUtility::getProcessedValue($this->table, $name, $this->row[$name], 0, 0, false, $uid);
            $itemLabel = $lang->sL(BackendUtility::getItemLabel($this->table, $name), true);
            $tableRows[] = '
                <tr>
                    <th class="col-nowrap">' . $itemLabel . '</th>
                    <td>' . htmlspecialchars($itemValue) . '</td>
                </tr>';
        }

        return '
            <div class="table-fit table-fit-wrap">
                <table class="table table-striped table-hover">
                    ' . implode('', $tableRows) . '
                </table>
            </div>';
    }

    protected function renderReferences()
    {
        $content = '';

        switch ($this->type) {
            case 'db': {
                $references = $this->makeRef($this->table, $this->row['uid']);
                if (!empty($references)) {
                    $content .= '<h3>' . $this->getLanguageService()->sL('LLL:EXT:lang/locallang_core.xlf:show_item.php.referencesToThisItem', true) . '</h3>';
                    $content .= $references;
                }

                $referencesFrom = $this->makeRefFrom($this->table, $this->row['uid']);
                if (!empty($referencesFrom)) {
                    $content .= '<h3>' . $this->getLanguageService()->sL('LLL:EXT:lang/locallang_core.xlf:show_item.php.referencesFromThisItem', true) . '</h3>';
                    $content .= $referencesFrom;
                }
                break;
            }

            case 'file': {
                if ($this->fileObject && $this->fileObject->isIndexed()) {
                    $references = $this->makeRef('_FILE', $this->fileObject);

                    if (!empty($references)) {
                        $content .= '<h3>' . $this->getLanguageService()->sL('LLL:EXT:lang/locallang_core.xlf:show_item.php.referencesToThisItem', true) . '</h3>';
                        $content .= $references;
                    }
                }
                break;
            }
        }

        return $content;
    }

    protected function renderBackButton()
    {
        $backLink = '';
        $returnUrl = GeneralUtility::sanitizeLocalUrl(GeneralUtility::_GET('returnUrl'));
        if ($returnUrl) {
            $backLink .= '
                <a class="btn btn-primary" href="' . htmlspecialchars($returnUrl) . '">
                    ' . $this->iconFactory->getIcon('actions-view-go-back', Icon::SIZE_SMALL)->render() . '
                    ' . $this->getLanguageService()->sL('LLL:EXT:lang/locallang_common.xlf:back', true) . '
                </a>';
        }
        return $backLink;
    }

    protected function renderFileInformationAsTable($fieldList)
    {
        $tableRows = [];
        foreach ($fieldList as $name) {
            if (!isset($GLOBALS['TCA'][$this->table]['columns'][$name])) {
                continue;
            }
            $isExcluded = !(!$GLOBALS['TCA'][$this->table]['columns'][$name]['exclude'] || $this->getBackendUser()->check('non_exclude_fields', $this->table . ':' . $name));
            if ($isExcluded) {
                continue;
            }
            $uid = $this->row['uid'];
            $itemValue = BackendUtility::getProcessedValue($this->table, $name, $this->row[$name], 0, 0, false, $uid);
            $itemLabel = $this->getLanguageService()->sL(BackendUtility::getItemLabel($this->table, $name), true);
            $tableRows[] = '
                <tr>
                    <th>' . $itemLabel . '</th>
                    <td>' . htmlspecialchars($itemValue) . '</td>
                </tr>';
        }

        if (!$tableRows) {
            return '';
        }

        return '
            <div class="table-fit table-fit-wrap">
                <table class="table table-striped table-hover">
                    ' . implode('', $tableRows) . '
                </table>
            </div>';
    }

    public function printContent()
    {
        GeneralUtility::logDeprecatedFunction();
        echo $this->doc->startPage($this->titleTag) .
            $this->doc->insertStylesAndJS($this->content) .
            $this->doc->endPage();
    }

    public function getLabelForTableColumn($tableName, $fieldName)
    {
        if ($GLOBALS['TCA'][$tableName]['columns'][$fieldName]['label'] !== null) {
            $field = $this->getLanguageService()->sL($GLOBALS['TCA'][$tableName]['columns'][$fieldName]['label']);
            if (trim($field) === '') {
                $field = $fieldName;
            }
        } else {
            $field = $fieldName;
        }
        return $field;
    }

    protected function getRecordActions($table, $uid)
    {
        if ($table === '' || $uid < 0) {
            return '';
        }

        // Edit button
        $urlParameters = [
            'edit' => [
                $table => [
                    $uid => 'edit'
                ]
            ],
            'returnUrl' => GeneralUtility::getIndpEnv('REQUEST_URI')
        ];
        $url = BackendUtility::getModuleUrl('record_edit', $urlParameters);
        $pageActionIcons = '
            <a class="btn btn-default btn-sm" href="' . htmlspecialchars($url) . '">
                ' . $this->iconFactory->getIcon('actions-document-open', Icon::SIZE_SMALL)->render() . '
            </a>';

        // History button
        $urlParameters = [
            'element' => $table . ':' . $uid,
            'returnUrl' => GeneralUtility::getIndpEnv('REQUEST_URI')
        ];
        $url = BackendUtility::getModuleUrl('record_history', $urlParameters);
        $pageActionIcons .= '
            <a class="btn btn-default btn-sm" href="' . htmlspecialchars($url) . '">
                ' . $this->iconFactory->getIcon('actions-document-history-open', Icon::SIZE_SMALL)->render() . '
            </a>';

        if ($table === 'pages') {
            // Recordlist button
            $url = BackendUtility::getModuleUrl('web_list', ['id' => $uid, 'returnUrl' => GeneralUtility::getIndpEnv('REQUEST_URI')]);
            $pageActionIcons .= '
                <a class="btn btn-default btn-sm" href="' . htmlspecialchars($url) . '" title="' . $this->getLanguageService()->sL('LLL:EXT:lang/locallang_core.xlf:labels.showList') . '">
                    ' . $this->iconFactory->getIcon('actions-system-list-open', Icon::SIZE_SMALL)->render() . '
                </a>';

            // View page button
            $viewOnClick = BackendUtility::viewOnClick($uid, '', BackendUtility::BEgetRootLine($uid));
            $pageActionIcons .= '
                <a class="btn btn-default btn-sm" href="#" onclick="' . htmlspecialchars($viewOnClick) . '" title="' . $this->getLanguageService()->sL('LLL:EXT:lang/locallang_core.xlf:labels.showPage', true) . '">
                    ' . $this->iconFactory->getIcon('actions-document-view', Icon::SIZE_SMALL)->render() . '
                </a>';
        }

        return '
            <div class="btn-group" role="group">
                ' . $pageActionIcons . '
            </div>';
    }

    protected function makeRef($table, $ref)
    {
        $lang = $this->getLanguageService();
        // Files reside in sys_file table
        if ($table === '_FILE') {
            $selectTable = 'sys_file';
            $selectUid = $ref->getUid();
        } else {
            $selectTable = $table;
            $selectUid = $ref;
        }
        $rows = $this->getDatabaseConnection()->exec_SELECTgetRows(
            '*',
            'sys_refindex',
            'ref_table=' . $this->getDatabaseConnection()->fullQuoteStr($selectTable, 'sys_refindex') . ' AND ref_uid=' . (int)$selectUid . ' AND deleted=0'
        );

        // Compile information for title tag:
        $infoData = [];
        $infoDataHeader = '';
        if (!empty($rows)) {
            $infoDataHeader = '
                <tr>
                    <th class="col-icon"></th>
                    <th class="col-title">' . $lang->sL('LLL:EXT:lang/locallang_core.xlf:show_item.php.title') . '</th>
                    <th>' . $lang->sL('LLL:EXT:lang/locallang_core.xlf:show_item.php.table') . '</th>
                    <th>' . $lang->sL('LLL:EXT:lang/locallang_core.xlf:show_item.php.uid') . '</th>
                    <th>' . $lang->sL('LLL:EXT:lang/locallang_core.xlf:show_item.php.field') . '</th>
                    <th>' . $lang->sL('LLL:EXT:lang/locallang_core.xlf:show_item.php.flexpointer') . '</th>
                    <th>' . $lang->sL('LLL:EXT:lang/locallang_core.xlf:show_item.php.softrefKey') . '</th>
                    <th>' . $lang->sL('LLL:EXT:lang/locallang_core.xlf:show_item.php.sorting') . '</th>
                    <th class="col-control"></th>
                </tr>';
        }
        foreach ($rows as $row) {
            if ($row['tablename'] === 'sys_file_reference') {
                $row = $this->transformFileReferenceToRecordReference($row);
                if ($row['tablename'] === null || $row['recuid'] === null) {
                    return '';
                }
            }
            $record = BackendUtility::getRecord($row['tablename'], $row['recuid']);
            if ($record) {
                $parentRecord = BackendUtility::getRecord('pages', $record['pid']);
                $parentRecordTitle = is_array($parentRecord)
                    ? BackendUtility::getRecordTitle('pages', $parentRecord)
                    : '';
                $icon = $this->iconFactory->getIconForRecord($row['tablename'], $record, Icon::SIZE_SMALL)->render();
                $actions = $this->getRecordActions($row['tablename'], $row['recuid']);
                $urlParameters = [
                    'edit' => [
                        $row['tablename'] => [
                            $row['recuid'] => 'edit'
                        ]
                    ],
                    'returnUrl' => GeneralUtility::getIndpEnv('REQUEST_URI')
                ];
                $url = BackendUtility::getModuleUrl('record_edit', $urlParameters);
                $infoData[] = '
                <tr>
                    <td class="col-icon">
                        <a href="' . htmlspecialchars($url) . '" title="id=' . $record['uid'] . '">
                            ' . $icon . '
                        </a>
                    </td>
                    <td class="col-title">
                        <a href="' . htmlspecialchars($url) . '" title="id=' . $record['uid'] . '" >
                            ' . BackendUtility::getRecordTitle($row['tablename'], $record, true) . '
                        </a>
                    </td>
                    <td>' . $lang->sL($GLOBALS['TCA'][$row['tablename']]['ctrl']['title'], true) . '</td>
                    <td>
                        <span title="' . $lang->sL('LLL:EXT:lang/locallang_common.xlf:page') . ': '
                            . htmlspecialchars($parentRecordTitle) . ' (uid=' . $record['pid'] . ')">
                            ' . $record['uid'] . '
                        </span>
                    </td>
                    <td>' . htmlspecialchars($this->getLabelForTableColumn($row['tablename'], $row['field'])) . '</td>
                    <td>' . htmlspecialchars($row['flexpointer']) . '</td>
                    <td>' . htmlspecialchars($row['softref_key']) . '</td>
                    <td>' . htmlspecialchars($row['sorting']) . '</td>
                    <td class="col-control">' . $actions . '</td>
                </tr>';
            } else {
                $infoData[] = '
                <tr>
                    <td class="col-icon"></td>
                    <td class="col-title">' . $lang->sL('LLL:EXT:lang/locallang_core.xlf:show_item.php.missing_record') . ' (uid=' . (int)$row['recuid'] . ')</td>
                    <td>' . htmlspecialchars($lang->sL($GLOBALS['TCA'][$row['tablename']]['ctrl']['title']) ?: $row['tablename']) . '</td>
                    <td></td>
                    <td>' . htmlspecialchars($this->getLabelForTableColumn($row['tablename'], $row['field'])) . '</td>
                    <td>' . htmlspecialchars($row['flexpointer']) . '</td>
                    <td>' . htmlspecialchars($row['softref_key']) . '</td>
                    <td>' . htmlspecialchars($row['sorting']) . '</td>
                    <td class="col-control"></td>
                </tr>';
            }
        }
        $referenceLine = '';
        if (!empty($infoData)) {
            $referenceLine = '
                <div class="table-fit">
                    <table class="table table-striped table-hover">
                        <thead>' . $infoDataHeader . '</thead>
                        <tbody>' . implode('', $infoData) . '</tbody>
                    </table>
                </div>';
        }
        return $referenceLine;
    }

    protected function makeRefFrom($table, $ref)
    {
        $lang = $this->getLanguageService();
        $rows = $this->getDatabaseConnection()->exec_SELECTgetRows(
            '*',
            'sys_refindex',
            'tablename=' . $this->getDatabaseConnection()->fullQuoteStr($table, 'sys_refindex') . ' AND recuid=' . (int)$ref
        );

        // Compile information for title tag:
        $infoData = [];
        $infoDataHeader = '';
        if (!empty($rows)) {
            $infoDataHeader = '
                <tr>
                    <th class="col-icon"></th>
                    <th class="col-title">' . $lang->sL('LLL:EXT:lang/locallang_core.xlf:show_item.php.title') . '</th>
                    <th>' . $lang->sL('LLL:EXT:lang/locallang_core.xlf:show_item.php.table') . '</th>
                    <th>' . $lang->sL('LLL:EXT:lang/locallang_core.xlf:show_item.php.uid') . '</th>
                    <th>' . $lang->sL('LLL:EXT:lang/locallang_core.xlf:show_item.php.field') . '</th>
                    <th>' . $lang->sL('LLL:EXT:lang/locallang_core.xlf:show_item.php.flexpointer') . '</th>
                    <th>' . $lang->sL('LLL:EXT:lang/locallang_core.xlf:show_item.php.softrefKey') . '</th>
                    <th>' . $lang->sL('LLL:EXT:lang/locallang_core.xlf:show_item.php.sorting') . '</th>
                    <th>' . $lang->sL('LLL:EXT:lang/locallang_core.xlf:show_item.php.refString') . '</th>
                    <th class="col-control"></th>
                </tr>';
        }
        foreach ($rows as $row) {
            $record = BackendUtility::getRecord($row['ref_table'], $row['ref_uid']);
            if ($record) {
                $icon = $this->iconFactory->getIconForRecord($row['tablename'], $record, Icon::SIZE_SMALL)->render();
                $actions = $this->getRecordActions($row['ref_table'], $row['ref_uid']);

                $urlParameters = [
                    'edit' => [
                        $row['ref_table'] => [
                            $row['ref_uid'] => 'edit'
                        ]
                    ],
                    'returnUrl' => GeneralUtility::getIndpEnv('REQUEST_URI')
                ];
                $url = BackendUtility::getModuleUrl('record_edit', $urlParameters);
                $infoData[] = '
                <tr>
                    <td class="col-icon">
                        <a href="' . htmlspecialchars($url) . '" title="id=' . $record['uid'] . '">
                            ' . $icon . '
                        </a>
                    </td>
                    <td class="col-title">
                        <a href="' . htmlspecialchars($url) . '" title="id=' . $record['uid'] . '" >
                            ' . BackendUtility::getRecordTitle($row['ref_table'], $record, true) . '
                        </a>
                    </td>
                    <td>' . $lang->sL($GLOBALS['TCA'][$row['ref_table']]['ctrl']['title'], true) . '</td>
                    <td>' . htmlspecialchars($row['ref_uid']) . '</td>
                    <td>' . htmlspecialchars($this->getLabelForTableColumn($table, $row['field'])) . '</td>
                    <td>' . htmlspecialchars($row['flexpointer']) . '</td>
                    <td>' . htmlspecialchars($row['softref_key']) . '</td>
                    <td>' . htmlspecialchars($row['sorting']) . '</td>
                    <td>' . htmlspecialchars($row['ref_string']) . '</td>
                    <td class="col-control">' . $actions . '</td>
                </tr>';
            } else {
                $infoData[] = '
                <tr>
                    <td class="col-icon"></td>
                    <td class="col-title">' . $lang->sL('LLL:EXT:lang/locallang_core.xlf:show_item.php.missing_record') . ' (uid=' . (int)$row['recuid'] . ')</td>
                    <td>' . $lang->sL($GLOBALS['TCA'][$row['ref_table']]['ctrl']['title'], true) . '</td>
                    <td></td>
                    <td>' . htmlspecialchars($this->getLabelForTableColumn($table, $row['field'])) . '</td>
                    <td>' . htmlspecialchars($row['flexpointer']) . '</td>
                    <td>' . htmlspecialchars($row['softref_key']) . '</td>
                    <td>' . htmlspecialchars($row['sorting']) . '</td>
                    <td>' . htmlspecialchars($row['ref_string']) . '</td>
                    <td class="col-control"></td>
                </tr>';
            }
        }

        if (empty($infoData)) {
            return '';
        }

        return '
            <div class="table-fit">
                <table class="table table-striped table-hover">
                    <thead>' . $infoDataHeader . '</thead>
                    <tbody>' . implode('', $infoData) . '</tbody>
                </table>
            </div>';
    }

    protected function transformFileReferenceToRecordReference(array $referenceRecord)
    {
        $fileReference = $this->getDatabaseConnection()->exec_SELECTgetSingleRow(
            '*',
            'sys_file_reference',
            'uid=' . (int)$referenceRecord['recuid']
        );
        return [
            'recuid' => $fileReference['uid_foreign'],
            'tablename' => $fileReference['tablenames'],
            'field' => $fileReference['fieldname'],
            'flexpointer' => '',
            'softref_key' => '',
            'sorting' => $fileReference['sorting_foreign']
        ];
    }

    protected function getLanguageService()
    {
        return $GLOBALS['LANG'];
    }

    protected function getBackendUser()
    {
        return $GLOBALS['BE_USER'];
    }

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