DatabaseRecordList.php

Go to the documentation of this file.

<?php
namespace TYPO3\CMS\Dbal\RecordList;

class DatabaseRecordList extends \TYPO3\CMS\Recordlist\RecordList\DatabaseRecordList {

    public function makeSearchString($table) {
        // Make query, only if table is valid and a search string is actually defined:
        if ($GLOBALS['TCA'][$table] && $this->searchString) {
            // Initialize field array:
            $sfields = array();
            $or = '';
            // add the uid only if input is numeric, cast to int
            if (is_numeric($this->searchString)) {
                $queryPart = ' AND (uid=' . (int)$this->searchString . ' OR ';
            } else {
                $queryPart = ' AND (';
            }
            if ($GLOBALS['TYPO3_DB']->runningADOdbDriver('oci8')) {
                foreach ($GLOBALS['TCA'][$table]['columns'] as $fieldName => $info) {
                    if ($GLOBALS['TYPO3_DB']->cache_fieldType[$table][$fieldName]['metaType'] === 'B') {

                    } elseif ($info['config']['type'] === 'text' || $info['config']['type'] === 'input' && !preg_match('/date|time|int/', $info['config']['eval'])) {
                        $queryPart .= $or . $fieldName . ' LIKE \'%' . $GLOBALS['TYPO3_DB']->quoteStr($this->searchString, $table) . '%\'';
                        $or = ' OR ';
                    }
                }
            } else {
                // Traverse the configured columns and add all columns that can be searched
                foreach ($GLOBALS['TCA'][$table]['columns'] as $fieldName => $info) {
                    if ($info['config']['type'] === 'text' || $info['config']['type'] === 'input' && !preg_match('/date|time|int/', $info['config']['eval'])) {
                        $sfields[] = $fieldName;
                    }
                }
                // If search-fields were defined (and there always are) we create the query:
                if (count($sfields)) {
                    $like = ' LIKE \'%' . $GLOBALS['TYPO3_DB']->quoteStr($this->searchString, $table) . '%\'';
                    // Free-text
                    $queryPart .= implode(($like . ' OR '), $sfields) . $like;
                }
            }
            // Return query:
            return $queryPart . ')';
        }
    }

}