LiveSearch.php

Go to the documentation of this file.

<?php
namespace TYPO3\CMS\Backend\Search\LiveSearch;

/*
 * 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\Backend\Utility\BackendUtility;
use TYPO3\CMS\Core\Imaging\Icon;
use TYPO3\CMS\Core\Imaging\IconFactory;
use TYPO3\CMS\Core\Type\Bitmask\Permission;
use TYPO3\CMS\Core\Utility\GeneralUtility;
use TYPO3\CMS\Core\Utility\MathUtility;

class LiveSearch
{
    const PAGE_JUMP_TABLE = 'pages';

    const RECURSIVE_PAGE_LEVEL = 99;

    const GROUP_TITLE_MAX_LENGTH = 15;

    const RECORD_TITLE_MAX_LENGTH = 28;

    private $queryString = '';

    private $startCount = 0;

    private $limitCount = 5;

    protected $userPermissions = '';

    protected $queryParser = null;

    public function __construct()
    {
        $this->userPermissions = $GLOBALS['BE_USER']->getPagePermsClause(1);
        $this->queryParser = GeneralUtility::makeInstance(\TYPO3\CMS\Backend\Search\LiveSearch\QueryParser::class);
    }

    public function findPage($searchQuery)
    {
        $link = '';
        $pageId = $this->queryParser->getId($searchQuery);
        $pageRecord = $this->findPageById($pageId);
        if (!empty($pageRecord)) {
            $link = $this->getEditLink(self::PAGE_JUMP_TABLE, $this->findPageById($pageId));
        }
        return $link;
    }

    public function find($searchQuery)
    {
        $recordArray = array();
        $pageList = array();
        $mounts = $GLOBALS['BE_USER']->returnWebmounts();
        foreach ($mounts as $pageId) {
            $pageList[] = $this->getAvailablePageIds($pageId, self::RECURSIVE_PAGE_LEVEL);
        }
        $pageIdList = implode(',', array_unique(explode(',', implode(',', $pageList))));
        unset($pageList);
        $limit = $this->startCount . ',' . $this->limitCount;
        if ($this->queryParser->isValidCommand($searchQuery)) {
            $this->setQueryString($this->queryParser->getSearchQueryValue($searchQuery));
            $tableName = $this->queryParser->getTableNameFromCommand($searchQuery);
            if ($tableName) {
                $recordArray[] = $this->findByTable($tableName, $pageIdList, $limit);
            }
        } else {
            $this->setQueryString($searchQuery);
            $recordArray = $this->findByGlobalTableList($pageIdList);
        }
        return $recordArray;
    }

    protected function findPageById($id)
    {
        $pageRecord = array();
        $row = BackendUtility::getRecord(self::PAGE_JUMP_TABLE, $id);
        if (is_array($row)) {
            $pageRecord = $row;
        }
        return $pageRecord;
    }

    protected function findByGlobalTableList($pageIdList)
    {
        $limit = $this->limitCount;
        $getRecordArray = array();
        foreach ($GLOBALS['TCA'] as $tableName => $value) {
            // if no access for the table (read or write), skip this table
            if (!$GLOBALS['BE_USER']->check('tables_select', $tableName) && !$GLOBALS['BE_USER']->check('tables_modify', $tableName)) {
                continue;
            }
            $recordArray = $this->findByTable($tableName, $pageIdList, '0,' . $limit);
            $recordCount = count($recordArray);
            if ($recordCount) {
                $limit = $limit - $recordCount;
                $getRecordArray[] = $recordArray;
                if ($limit <= 0) {
                    break;
                }
            }
        }
        return $getRecordArray;
    }

    protected function findByTable($tableName, $pageIdList, $limit)
    {
        $fieldsToSearchWithin = $this->extractSearchableFieldsFromTable($tableName);
        $getRecordArray = array();
        if (!empty($fieldsToSearchWithin)) {
            $pageBasedPermission = $tableName == 'pages' && $this->userPermissions ? $this->userPermissions : '1=1 ';
            $where = 'pid IN (' . $pageIdList . ') AND ' . $pageBasedPermission . $this->makeQuerySearchByTable($tableName, $fieldsToSearchWithin);
            $getRecordArray = $this->getRecordArray($tableName, $where, $this->makeOrderByTable($tableName), $limit);
        }
        return $getRecordArray;
    }

    protected function getRecordArray($tableName, $where, $orderBy, $limit)
    {
        $collect = array();
        $isFirst = true;
        $queryParts = array(
            'SELECT' => '*',
            'FROM' => $tableName,
            'WHERE' => $where,
            'ORDERBY' => $orderBy,
            'LIMIT' => $limit
        );
        $result = $GLOBALS['TYPO3_DB']->exec_SELECT_queryArray($queryParts);
        $dbCount = $GLOBALS['TYPO3_DB']->sql_num_rows($result);
        $iconFactory = GeneralUtility::makeInstance(IconFactory::class);
        while ($row = $GLOBALS['TYPO3_DB']->sql_fetch_assoc($result)) {
            $title = 'id=' . $row['uid'] . ', pid=' . $row['pid'];
            $collect[] = array(
                'id' => $tableName . ':' . $row['uid'],
                'pageId' => $tableName === 'pages' ? $row['uid'] : $row['pid'],
                'typeLabel' =>  htmlspecialchars($this->getTitleOfCurrentRecordType($tableName)),
                'iconHTML' => '<span title="' . htmlspecialchars($title) . '">' . $iconFactory->getIconForRecord($tableName, $row, Icon::SIZE_SMALL)->render() . '</span>',
                'title' => htmlspecialchars(BackendUtility::getRecordTitle($tableName, $row)),
                'editLink' => htmlspecialchars($this->getEditLink($tableName, $row))
            );
            $isFirst = false;
        }
        $GLOBALS['TYPO3_DB']->sql_free_result($result);
        return $collect;
    }

    protected function getEditLink($tableName, $row)
    {
        $pageInfo = BackendUtility::readPageAccess($row['pid'], $this->userPermissions);
        $calcPerms = $GLOBALS['BE_USER']->calcPerms($pageInfo);
        $editLink = '';
        if ($tableName == 'pages') {
            $localCalcPerms = $GLOBALS['BE_USER']->calcPerms(BackendUtility::getRecord('pages', $row['uid']));
            $permsEdit = $localCalcPerms & Permission::PAGE_EDIT;
        } else {
            $permsEdit = $calcPerms & Permission::CONTENT_EDIT;
        }
        // "Edit" link - Only if permissions to edit the page-record of the content of the parent page ($this->id)
        if ($permsEdit) {
            $returnUrl = BackendUtility::getModuleUrl('web_list', array('id' => $row['pid']));
            $editLink = BackendUtility::getModuleUrl('record_edit', array(
                'edit[' . $tableName . '][' . $row['uid'] . ']' => 'edit',
                'returnUrl' => $returnUrl
            ));
        }
        return $editLink;
    }

    protected function getTitleOfCurrentRecordType($tableName)
    {
        return $GLOBALS['LANG']->sL($GLOBALS['TCA'][$tableName]['ctrl']['title']);
    }

    public function getRecordTitlePrep($title, $titleLength = 0)
    {
        // If $titleLength is not a valid positive integer, use BE_USER->uc['titleLen']:
        if (!$titleLength || !MathUtility::canBeInterpretedAsInteger($titleLength) || $titleLength < 0) {
            $titleLength = $GLOBALS['BE_USER']->uc['titleLen'];
        }
        return htmlspecialchars(GeneralUtility::fixed_lgd_cs($title, $titleLength));
    }

    protected function makeQuerySearchByTable($tableName, array $fieldsToSearchWithin)
    {
        $queryPart = '';
        $whereParts = array();
        // If the search string is a simple integer, assemble an equality comparison
        if (MathUtility::canBeInterpretedAsInteger($this->queryString)) {
            foreach ($fieldsToSearchWithin as $fieldName) {
                if ($fieldName == 'uid' || $fieldName == 'pid' || isset($GLOBALS['TCA'][$tableName]['columns'][$fieldName])) {
                    $fieldConfig = &$GLOBALS['TCA'][$tableName]['columns'][$fieldName]['config'];
                    // Assemble the search condition only if the field is an integer, or is uid or pid
                    if ($fieldName == 'uid' || $fieldName == 'pid' || $fieldConfig['type'] == 'input' && $fieldConfig['eval'] && GeneralUtility::inList($fieldConfig['eval'], 'int')) {
                        $whereParts[] = $fieldName . '=' . $this->queryString;
                    } elseif (
                        $fieldConfig['type'] == 'text' ||
                        $fieldConfig['type'] == 'flex' ||
                        ($fieldConfig['type'] == 'input' && (!$fieldConfig['eval'] ||
                        !preg_match('/date|time|int/', $fieldConfig['eval'])))) {
                        // Otherwise and if the field makes sense to be searched, assemble a like condition
                            $whereParts[] = $fieldName . ' LIKE \'%' . $this->queryString . '%\'';
                    }
                }
            }
        } else {
            $like = '\'%' . $GLOBALS['TYPO3_DB']->escapeStrForLike($GLOBALS['TYPO3_DB']->quoteStr($this->queryString, $tableName), $tableName) . '%\'';
            foreach ($fieldsToSearchWithin as $fieldName) {
                if (isset($GLOBALS['TCA'][$tableName]['columns'][$fieldName])) {
                    $fieldConfig = &$GLOBALS['TCA'][$tableName]['columns'][$fieldName]['config'];
                    // Check whether search should be case-sensitive or not
                    $format = 'LOWER(%s) LIKE LOWER(%s)';
                    if (is_array($fieldConfig['search'])) {
                        if (in_array('case', $fieldConfig['search'])) {
                            $format = '%s LIKE %s';
                        }
                        // Apply additional condition, if any
                        if ($fieldConfig['search']['andWhere']) {
                            $format = '((' . $fieldConfig['search']['andWhere'] . ') AND (' . $format . '))';
                        }
                    }
                    // Assemble the search condition only if the field makes sense to be searched
                    if ($fieldConfig['type'] == 'text' || $fieldConfig['type'] == 'flex' || $fieldConfig['type'] == 'input' && (!$fieldConfig['eval'] || !preg_match('/date|time|int/', $fieldConfig['eval']))) {
                        $whereParts[] = sprintf($format, $fieldName, $like);
                    }
                }
            }
        }
        // If at least one condition was defined, create the search query
        if (!empty($whereParts)) {
            $queryPart = ' AND (' . implode(' OR ', $whereParts) . ')';
            // And the relevant conditions for deleted and versioned records
            $queryPart .= BackendUtility::deleteClause($tableName);
            $queryPart .= BackendUtility::versioningPlaceholderClause($tableName);
        } else {
            $queryPart = ' AND 0 = 1';
        }
        return $queryPart;
    }

    protected function makeOrderByTable($tableName)
    {
        $orderBy = '';
        if (is_array($GLOBALS['TCA'][$tableName]['ctrl']) && array_key_exists('sortby', $GLOBALS['TCA'][$tableName]['ctrl'])) {
            $sortBy = trim($GLOBALS['TCA'][$tableName]['ctrl']['sortby']);
            if (!empty($sortBy)) {
                $orderBy = 'ORDER BY ' . $sortBy;
            }
        } else {
            $orderBy = $GLOBALS['TCA'][$tableName]['ctrl']['default_sortby'];
        }
        return $GLOBALS['TYPO3_DB']->stripOrderBy($orderBy);
    }

    protected function extractSearchableFieldsFromTable($tableName)
    {
        // Get the list of fields to search in from the TCA, if any
        if (isset($GLOBALS['TCA'][$tableName]['ctrl']['searchFields'])) {
            $fieldListArray = GeneralUtility::trimExplode(',', $GLOBALS['TCA'][$tableName]['ctrl']['searchFields'], true);
        } else {
            $fieldListArray = array();
        }
        // Add special fields
        if ($GLOBALS['BE_USER']->isAdmin()) {
            $fieldListArray[] = 'uid';
            $fieldListArray[] = 'pid';
        }
        return $fieldListArray;
    }

    public function getQueryString($tableName = '')
    {
        return $GLOBALS['TYPO3_DB']->quoteStr($this->queryString, $tableName);
    }

    public function setLimitCount($limitCount)
    {
        $limit = MathUtility::convertToPositiveInteger($limitCount);
        if ($limit > 0) {
            $this->limitCount = $limit;
        }
    }

    public function setStartCount($startCount)
    {
        $this->startCount = MathUtility::convertToPositiveInteger($startCount);
    }

    public function setQueryString($queryString)
    {
        $this->queryString = GeneralUtility::removeXSS($queryString);
    }

    protected function getAvailablePageIds($id, $depth)
    {
        $tree = GeneralUtility::makeInstance(\TYPO3\CMS\Backend\Tree\View\PageTreeView::class);
        $tree->init('AND ' . $this->userPermissions);
        $tree->makeHTML = 0;
        $tree->fieldArray = array('uid', 'php_tree_stop');
        if ($depth) {
            $tree->getTree($id, $depth, '');
        }
        $tree->ids[] = $id;
        $idList = implode(',', $tree->ids);
        return $idList;
    }
}