TYPO3\CMS\Lowlevel\Database\QueryGenerator Class Reference

Public Member Functions
	__construct (array $settings, array $menuItems, string $moduleName)
string	form ()
string	queryMaker ()
string	search ()
	setFormName ($formName)

Protected Member Functions
string	makeStoreControl ()
array	initStoreArray ()
array	cleanStoreQueryConfigs ($storeQueryConfigs, $storeArray)
	addToStoreQueryConfigs (array $storeQueryConfigs, int $index)
bool	saveQueryInAction ($uid)
array	loadStoreQueryConfigs ($storeQueryConfigs, $storeIndex, $writeArray)
string	procesStoreControl ()
array	getQueryResultCode ($type, array $dataRows, $table)
string	csvValues ($row, $delim=',', $quote='"', $conf = [], $table = '')
string	resultRowDisplay ($row, $conf, $table)
string	getProcessedValueExtra ($table, $fieldName, $fieldValue, $conf, $splitString)
string	getTreeList ($id, $depth, $begin=0, $permsClause='')
string	makeValueList ($fieldName, $fieldValue, $conf, $table, $splitString)
string	resultRowTitles ($row, $conf)
string	makeFieldList ()
	init ($name, $table, $fieldList='', array $settings=[])
	setAndCleanUpExternalLists ($name, $list, $force='')
	procesData ($qC=[])
array	cleanUpQueryConfig ($queryConfig)
array	getFormElements ($subLevel=0, $queryConfig='', $parent='')
string	makeComparisonSelector ($subscript, $fieldName, $conf)
string	makeOptionList ($fieldName, $conf, $table)
string	printCodeArray ($codeArr, $recursionLevel=0)
string	mkOperatorSelect ($name, $op, $draw, $submit)
string	mkTypeSelect ($name, $fieldName, $prepend='FIELD_')
string	verifyType ($fieldName)
int	verifyComparison ($comparison, $neg)
string	mkFieldToInputSelect ($name, $fieldName)
string	mkTableSelect ($name, $cur)
string	mkCompSelect ($name, $comparison, $neg)
array	getSubscript ($arr)
string	getQuery ($queryConfig, $pad='')
array	convertIso8601DatetimeStringToUnixTimestamp (array $conf)
bool	isDateOfIso8601Format ($date)
string	getQuerySingle ($conf, $first)
string int float null	cleanInputVal ($conf, $suffix='')
string	updateIcon ()
string	getLabelCol ()
string	makeSelectorTable ($modSettings, $enableList='table, fields, query, group, order, limit')
string	getSelectQuery ($qString='')
string	getDateTimePickerField ($name, $timestamp, $type)
	getBackendUserAuthentication ()
	getLanguageService ()

Protected Attributes
string	$storeList = 'search_query_smallparts,search_result_labels,labels_noprefix,show_deleted,queryConfig,queryTable,queryFields,queryLimit,queryOrder,queryOrderDesc,queryOrder2,queryOrder2Desc,queryGroup,search_query_makeQuery'
int	$noDownloadB = 0
array	$hookArray = array( )
string	$formName = ''
IconFactory	$iconFactory
array	$tableArray = array( )
array	$settings = array( )
array	$menuItems = array( )
string	$moduleName
array	$lang
array	$compSQL
array	$comp_offsets
string	$name
string	$table
string	$fieldList
array	$fields = array( )
array	$extFieldLists = array( )
array	$queryConfig = array( )
bool	$enablePrefix = false
bool	$enableQueryParts = false
string	$fieldName
bool	$showFieldAndTableNames = false

Private Member Functions
	renderNoResultsFoundMessage ()

Detailed Description

Class used in module tools/dbint (advanced search) and which may hold code specific for that module

This class is a specific implementation for the lowlevel extension and is not part of the TYPO3's Core API.

Definition at line 48 of file QueryGenerator.php.

Constructor & Destructor Documentation

__construct()

TYPO3\CMS\Lowlevel\Database\QueryGenerator::__construct	(	array	$settings,
		array	$menuItems,
		string	$moduleName
	)

Definition at line 270 of file QueryGenerator.php.

References TYPO3\CMS\Lowlevel\Database\QueryGenerator\$menuItems, TYPO3\CMS\Lowlevel\Database\QueryGenerator\$moduleName, TYPO3\CMS\Lowlevel\Database\QueryGenerator\$settings, TYPO3\CMS\Lowlevel\Database\QueryGenerator\getBackendUserAuthentication(), and TYPO3\CMS\Lowlevel\Database\QueryGenerator\getLanguageService().

Member Function Documentation

addToStoreQueryConfigs()

TYPO3\CMS\Lowlevel\Database\QueryGenerator::addToStoreQueryConfigs ( array  $storeQueryConfigs, int  $index  )

protected

Add to store query configs

Definition at line 582 of file QueryGenerator.php.

Referenced by TYPO3\CMS\Lowlevel\Database\QueryGenerator\procesStoreControl().

cleanInputVal()

string int float null TYPO3\CMS\Lowlevel\Database\QueryGenerator::cleanInputVal (   $conf,   $suffix = ''  )

protected

Clean input value

Parameters

array	$conf
string	$suffix

Returns

‪string|int|float|null

Definition at line 2497 of file QueryGenerator.php.

References TYPO3\CMS\Core\Utility\MathUtility\canBeInterpretedAsInteger(), and TYPO3\CMS\Core\Utility\GeneralUtility\intExplode().

Referenced by TYPO3\CMS\Lowlevel\Database\QueryGenerator\cleanUpQueryConfig(), and TYPO3\CMS\Lowlevel\Database\QueryGenerator\getQuerySingle().

cleanStoreQueryConfigs()

array TYPO3\CMS\Lowlevel\Database\QueryGenerator::cleanStoreQueryConfigs (   $storeQueryConfigs,   $storeArray  )

protected

Clean store query configs

Parameters

array	$storeQueryConfigs
array	$storeArray

Returns

‪array

Definition at line 567 of file QueryGenerator.php.

Referenced by TYPO3\CMS\Lowlevel\Database\QueryGenerator\procesStoreControl().

cleanUpQueryConfig()

array TYPO3\CMS\Lowlevel\Database\QueryGenerator::cleanUpQueryConfig (   $queryConfig )

protected

Clean up query config

Parameters

array

$queryConfig

‪Query config

Returns

‪array

Definition at line 1695 of file QueryGenerator.php.

References TYPO3\CMS\Lowlevel\Database\QueryGenerator\$fieldName, TYPO3\CMS\Lowlevel\Database\QueryGenerator\$queryConfig, TYPO3\CMS\Lowlevel\Database\QueryGenerator\cleanInputVal(), TYPO3\CMS\Lowlevel\Database\QueryGenerator\verifyComparison(), and TYPO3\CMS\Lowlevel\Database\QueryGenerator\verifyType().

Referenced by TYPO3\CMS\Lowlevel\Database\QueryGenerator\makeSelectorTable().

convertIso8601DatetimeStringToUnixTimestamp()

array TYPO3\CMS\Lowlevel\Database\QueryGenerator::convertIso8601DatetimeStringToUnixTimestamp ( array  $conf )

protected

Convert ISO-8601 timestamp (string) into unix timestamp (int)

Parameters

array

$conf

Returns

‪array

Definition at line 2406 of file QueryGenerator.php.

References TYPO3\CMS\Lowlevel\Database\QueryGenerator\isDateOfIso8601Format().

Referenced by TYPO3\CMS\Lowlevel\Database\QueryGenerator\getQuery().

csvValues()

string TYPO3\CMS\Lowlevel\Database\QueryGenerator::csvValues (   $row,   $delim = ',',   $quote = '"',   $conf = [],   $table = ''  )

protected

CSV values

Parameters

array	$row
string	$delim
string	$quote
array	$conf
string	$table

Returns

‪string A single line of CSV

Definition at line 861 of file QueryGenerator.php.

References TYPO3\CMS\Lowlevel\Database\QueryGenerator\$table, TYPO3\CMS\Core\Utility\CsvUtility\csvValues(), and TYPO3\CMS\Lowlevel\Database\QueryGenerator\getProcessedValueExtra().

Referenced by TYPO3\CMS\Lowlevel\Database\QueryGenerator\getQueryResultCode().

form()

string TYPO3\CMS\Lowlevel\Database\QueryGenerator::form

(

)

Get form

Returns

‪string

Definition at line 285 of file QueryGenerator.php.

getBackendUserAuthentication()

TYPO3\CMS\Lowlevel\Database\QueryGenerator::getBackendUserAuthentication ( )

protected

Definition at line 2826 of file QueryGenerator.php.

References $GLOBALS.

Referenced by TYPO3\CMS\Lowlevel\Database\QueryGenerator\__construct(), TYPO3\CMS\Lowlevel\Database\QueryGenerator\getSelectQuery(), TYPO3\CMS\Lowlevel\Database\QueryGenerator\makeOptionList(), TYPO3\CMS\Lowlevel\Database\QueryGenerator\makeSelectorTable(), TYPO3\CMS\Lowlevel\Database\QueryGenerator\makeStoreControl(), TYPO3\CMS\Lowlevel\Database\QueryGenerator\makeValueList(), TYPO3\CMS\Lowlevel\Database\QueryGenerator\mkFieldToInputSelect(), TYPO3\CMS\Lowlevel\Database\QueryGenerator\mkTableSelect(), TYPO3\CMS\Lowlevel\Database\QueryGenerator\mkTypeSelect(), and TYPO3\CMS\Lowlevel\Database\QueryGenerator\queryMaker().

getDateTimePickerField()

string TYPO3\CMS\Lowlevel\Database\QueryGenerator::getDateTimePickerField (   $name,   $timestamp,   $type  )

protected

Parameters

string	$name	‪the field name
string	$timestamp	‪ISO-8601 timestamp
string	$type	‪[datetime, date, time, timesec, year]

Returns

‪string

Definition at line 2809 of file QueryGenerator.php.

References $GLOBALS, TYPO3\CMS\Lowlevel\Database\QueryGenerator\$name, and TYPO3\CMS\Core\Utility\StringUtility\getUniqueId().

Referenced by TYPO3\CMS\Lowlevel\Database\QueryGenerator\getFormElements().

getFormElements()

array TYPO3\CMS\Lowlevel\Database\QueryGenerator::getFormElements (   $subLevel = 0,   $queryConfig = '',   $parent = ''  )

protected

Get form elements

Parameters

int	$subLevel
string	$queryConfig
string	$parent

Returns

‪array

Definition at line 1751 of file QueryGenerator.php.

References TYPO3\CMS\Lowlevel\Database\QueryGenerator\$fieldName, TYPO3\CMS\Lowlevel\Database\QueryGenerator\$queryConfig, TYPO3\CMS\Lowlevel\Database\QueryGenerator\getDateTimePickerField(), TYPO3\CMS\Lowlevel\Database\QueryGenerator\getQuerySingle(), TYPO3\CMS\Lowlevel\Database\QueryGenerator\makeComparisonSelector(), TYPO3\CMS\Lowlevel\Database\QueryGenerator\makeOptionList(), TYPO3\CMS\Lowlevel\Database\QueryGenerator\mkOperatorSelect(), and TYPO3\CMS\Lowlevel\Database\QueryGenerator\updateIcon().

Referenced by TYPO3\CMS\Lowlevel\Database\QueryGenerator\makeSelectorTable().

getLabelCol()

string TYPO3\CMS\Lowlevel\Database\QueryGenerator::getLabelCol ( )

protected

Get label column

Returns

‪string

Definition at line 2541 of file QueryGenerator.php.

References $GLOBALS, and TYPO3\CMS\Lowlevel\Database\QueryGenerator\$table.

Referenced by TYPO3\CMS\Lowlevel\Database\QueryGenerator\makeSelectorTable().

getLanguageService()

TYPO3\CMS\Lowlevel\Database\QueryGenerator::getLanguageService ( )

protected

Definition at line 2831 of file QueryGenerator.php.

References $GLOBALS.

Referenced by TYPO3\CMS\Lowlevel\Database\QueryGenerator\__construct(), TYPO3\CMS\Lowlevel\Database\QueryGenerator\getProcessedValueExtra(), TYPO3\CMS\Lowlevel\Database\QueryGenerator\init(), TYPO3\CMS\Lowlevel\Database\QueryGenerator\makeOptionList(), TYPO3\CMS\Lowlevel\Database\QueryGenerator\makeValueList(), TYPO3\CMS\Lowlevel\Database\QueryGenerator\mkTableSelect(), TYPO3\CMS\Lowlevel\Database\QueryGenerator\procesStoreControl(), TYPO3\CMS\Lowlevel\Database\QueryGenerator\resultRowDisplay(), TYPO3\CMS\Lowlevel\Database\QueryGenerator\resultRowTitles(), and TYPO3\CMS\Lowlevel\Database\QueryGenerator\search().

getProcessedValueExtra()

string TYPO3\CMS\Lowlevel\Database\QueryGenerator::getProcessedValueExtra (   $table,   $fieldName,   $fieldValue,   $conf,   $splitString  )

protected

Get processed value extra

Parameters

string	$table
string	$fieldName
string	$fieldValue
array	$conf	‪Not used
string	$splitString

Returns

‪string

Definition at line 977 of file QueryGenerator.php.

References TYPO3\CMS\Lowlevel\Database\QueryGenerator\$fieldName, TYPO3\CMS\Lowlevel\Database\QueryGenerator\$fields, $GLOBALS, TYPO3\CMS\Lowlevel\Database\QueryGenerator\$table, TYPO3\CMS\Lowlevel\Database\QueryGenerator\getLanguageService(), and TYPO3\CMS\Lowlevel\Database\QueryGenerator\makeValueList().

Referenced by TYPO3\CMS\Lowlevel\Database\QueryGenerator\csvValues(), and TYPO3\CMS\Lowlevel\Database\QueryGenerator\resultRowDisplay().

getQuery()

string TYPO3\CMS\Lowlevel\Database\QueryGenerator::getQuery (   $queryConfig,   $pad = ''  )

protected

Get query

Parameters

array	$queryConfig
string	$pad

Returns

‪string

Definition at line 2377 of file QueryGenerator.php.

References TYPO3\CMS\Lowlevel\Database\QueryGenerator\$queryConfig, TYPO3\CMS\Lowlevel\Database\QueryGenerator\convertIso8601DatetimeStringToUnixTimestamp(), and TYPO3\CMS\Lowlevel\Database\QueryGenerator\getQuerySingle().

Referenced by TYPO3\CMS\Lowlevel\Database\QueryGenerator\getSelectQuery(), TYPO3\CMS\Lowlevel\Database\QueryGenerator\queryMaker(), and TYPO3\CMS\Lowlevel\Database\QueryGenerator\saveQueryInAction().

getQueryResultCode()

array TYPO3\CMS\Lowlevel\Database\QueryGenerator::getQueryResultCode (   $type, array  $dataRows,   $table  )

protected

Get query result code

Parameters

string	$type
array	$dataRows	‪Rows to display
string	$table

Returns

‪array HTML-code for "header" and "content"

Exceptions

Definition at line 776 of file QueryGenerator.php.

References $GLOBALS, TYPO3\CMS\Lowlevel\Database\QueryGenerator\$table, TYPO3\CMS\Lowlevel\Database\QueryGenerator\csvValues(), TYPO3\CMS\Lowlevel\Database\QueryGenerator\renderNoResultsFoundMessage(), TYPO3\CMS\Lowlevel\Database\QueryGenerator\resultRowDisplay(), TYPO3\CMS\Lowlevel\Database\QueryGenerator\resultRowTitles(), and TYPO3\CMS\Core\Utility\DebugUtility\viewArray().

Referenced by TYPO3\CMS\Lowlevel\Database\QueryGenerator\queryMaker().

getQuerySingle()

string TYPO3\CMS\Lowlevel\Database\QueryGenerator::getQuerySingle (   $conf,   $first  )

protected

Get single query

Parameters

array	$conf
bool	$first

Returns

‪string

Definition at line 2441 of file QueryGenerator.php.

References TYPO3\CMS\Lowlevel\Database\QueryGenerator\cleanInputVal().

Referenced by TYPO3\CMS\Lowlevel\Database\QueryGenerator\getFormElements(), and TYPO3\CMS\Lowlevel\Database\QueryGenerator\getQuery().

getSelectQuery()

string TYPO3\CMS\Lowlevel\Database\QueryGenerator::getSelectQuery (   $qString = '' )

protected

Get select query

Parameters

string

$qString

Returns

‪string

Definition at line 2722 of file QueryGenerator.php.

References TYPO3\CMS\Lowlevel\Database\QueryGenerator\$fieldList, TYPO3\CMS\Lowlevel\Database\QueryGenerator\$fieldName, $GLOBALS, TYPO3\CMS\Lowlevel\Database\QueryGenerator\$table, TYPO3\CMS\Lowlevel\Database\QueryGenerator\getBackendUserAuthentication(), TYPO3\CMS\Lowlevel\Database\QueryGenerator\getQuery(), TYPO3\CMS\Lowlevel\Database\QueryGenerator\getTreeList(), TYPO3\CMS\Core\Utility\GeneralUtility\intExplode(), TYPO3\CMS\Core\Type\Bitmask\Permission\PAGE_SHOW, TYPO3\CMS\Core\Database\Query\QueryHelper\parseGroupBy(), TYPO3\CMS\Core\Database\Query\QueryHelper\parseOrderBy(), TYPO3\CMS\Core\Database\Query\QueryHelper\stripLogicalOperatorPrefix(), and TYPO3\CMS\Core\Utility\GeneralUtility\trimExplode().

Referenced by TYPO3\CMS\Lowlevel\Database\QueryGenerator\queryMaker(), and TYPO3\CMS\Lowlevel\Database\QueryGenerator\saveQueryInAction().

getSubscript()

array TYPO3\CMS\Lowlevel\Database\QueryGenerator::getSubscript (   $arr )

protected

Get subscript

Parameters

array

$arr

Returns

‪array

Definition at line 2354 of file QueryGenerator.php.

Referenced by TYPO3\CMS\Lowlevel\Database\QueryGenerator\procesData().

getTreeList()

string TYPO3\CMS\Lowlevel\Database\QueryGenerator::getTreeList (   $id,   $depth,   $begin = 0,   $permsClause = ''  )

protected

Recursively fetch all descendants of a given page

Parameters

int	$id	‪uid of the page
int	$depth
int	$begin
string	$permsClause

Returns

‪string comma separated list of descendant pages

Definition at line 1094 of file QueryGenerator.php.

References TYPO3\CMS\Core\Database\Connection\PARAM_INT, and TYPO3\CMS\Core\Database\Query\QueryHelper\stripLogicalOperatorPrefix().

Referenced by TYPO3\CMS\Lowlevel\Database\QueryGenerator\getSelectQuery(), TYPO3\CMS\Lowlevel\Database\QueryGenerator\makeOptionList(), and TYPO3\CMS\Lowlevel\Database\QueryGenerator\makeValueList().

init()

TYPO3\CMS\Lowlevel\Database\QueryGenerator::init (   $name,   $table,   $fieldList = '', array  $settings = []  )

protected

Init function

Parameters

string	$name	‪The name
string	$table	‪The table name
string	$fieldList	‪The field list
array	$settings	‪Module settings like checkboxes in the interface

Definition at line 1433 of file QueryGenerator.php.

References TYPO3\CMS\Lowlevel\Database\QueryGenerator\$fieldList, TYPO3\CMS\Lowlevel\Database\QueryGenerator\$fieldName, $GLOBALS, TYPO3\CMS\Lowlevel\Database\QueryGenerator\$name, TYPO3\CMS\Lowlevel\Database\QueryGenerator\$settings, TYPO3\CMS\Lowlevel\Database\QueryGenerator\$table, TYPO3\CMS\Lowlevel\Database\QueryGenerator\getLanguageService(), TYPO3\CMS\Lowlevel\Database\QueryGenerator\makeFieldList(), and TYPO3\CMS\Core\Utility\GeneralUtility\trimExplode().

Referenced by TYPO3\CMS\Lowlevel\Database\QueryGenerator\queryMaker(), and TYPO3\CMS\Lowlevel\Database\QueryGenerator\saveQueryInAction().

initStoreArray()

array TYPO3\CMS\Lowlevel\Database\QueryGenerator::initStoreArray ( )

protected

Init store array

Returns

‪array

Definition at line 548 of file QueryGenerator.php.

Referenced by TYPO3\CMS\Lowlevel\Database\QueryGenerator\makeStoreControl(), and TYPO3\CMS\Lowlevel\Database\QueryGenerator\procesStoreControl().

isDateOfIso8601Format()

bool TYPO3\CMS\Lowlevel\Database\QueryGenerator::isDateOfIso8601Format (   $date )

protected

Checks if the given value is of the ISO 8601 format.

Parameters

mixed

$date

Returns

‪bool

Definition at line 2424 of file QueryGenerator.php.

Referenced by TYPO3\CMS\Lowlevel\Database\QueryGenerator\convertIso8601DatetimeStringToUnixTimestamp().

loadStoreQueryConfigs()

array TYPO3\CMS\Lowlevel\Database\QueryGenerator::loadStoreQueryConfigs (   $storeQueryConfigs,   $storeIndex,   $writeArray  )

protected

Load store query configs

Parameters

array	$storeQueryConfigs
int	$storeIndex
array	$writeArray

Returns

‪array

Definition at line 649 of file QueryGenerator.php.

Referenced by TYPO3\CMS\Lowlevel\Database\QueryGenerator\procesStoreControl().

makeComparisonSelector()

string TYPO3\CMS\Lowlevel\Database\QueryGenerator::makeComparisonSelector (   $subscript,   $fieldName,   $conf  )

protected

Parameters

string	$subscript
string	$fieldName
array	$conf

Returns

‪string

Definition at line 1904 of file QueryGenerator.php.

References TYPO3\CMS\Lowlevel\Database\QueryGenerator\$fieldName, TYPO3\CMS\Lowlevel\Database\QueryGenerator\mkCompSelect(), and TYPO3\CMS\Lowlevel\Database\QueryGenerator\mkTypeSelect().

Referenced by TYPO3\CMS\Lowlevel\Database\QueryGenerator\getFormElements().

makeFieldList()

string TYPO3\CMS\Lowlevel\Database\QueryGenerator::makeFieldList ( )

protected

Make a list of fields for current table

Returns

‪string Separated list of fields

Definition at line 1401 of file QueryGenerator.php.

References $GLOBALS, and TYPO3\CMS\Lowlevel\Database\QueryGenerator\$table.

Referenced by TYPO3\CMS\Lowlevel\Database\QueryGenerator\init().

makeOptionList()

string TYPO3\CMS\Lowlevel\Database\QueryGenerator::makeOptionList (   $fieldName,   $conf,   $table  )

protected

Make option list

Parameters

string	$fieldName
array	$conf
string	$table

Returns

‪string

Definition at line 1930 of file QueryGenerator.php.

References TYPO3\CMS\Lowlevel\Database\QueryGenerator\$fieldName, $GLOBALS, TYPO3\CMS\Lowlevel\Database\QueryGenerator\$table, TYPO3\CMS\Lowlevel\Database\QueryGenerator\getBackendUserAuthentication(), TYPO3\CMS\Lowlevel\Database\QueryGenerator\getLanguageService(), TYPO3\CMS\Lowlevel\Database\QueryGenerator\getTreeList(), TYPO3\CMS\Core\Utility\GeneralUtility\intExplode(), TYPO3\CMS\Core\Type\Bitmask\Permission\PAGE_SHOW, TYPO3\CMS\Core\Database\Query\QueryHelper\stripLogicalOperatorPrefix(), and TYPO3\CMS\Core\Utility\GeneralUtility\trimExplode().

Referenced by TYPO3\CMS\Lowlevel\Database\QueryGenerator\getFormElements().

makeSelectorTable()

string TYPO3\CMS\Lowlevel\Database\QueryGenerator::makeSelectorTable (   $modSettings,   $enableList = 'table, fields  , query  , group  , order  , limit'    )

protected

Make selector table

Parameters

array	$modSettings
string	$enableList

Returns

‪string

Definition at line 2553 of file QueryGenerator.php.

References TYPO3\CMS\Lowlevel\Database\QueryGenerator\cleanUpQueryConfig(), TYPO3\CMS\Lowlevel\Database\QueryGenerator\getBackendUserAuthentication(), TYPO3\CMS\Lowlevel\Database\QueryGenerator\getFormElements(), TYPO3\CMS\Lowlevel\Database\QueryGenerator\getLabelCol(), TYPO3\CMS\Core\Utility\GeneralUtility\intExplode(), TYPO3\CMS\Lowlevel\Database\QueryGenerator\mkFieldToInputSelect(), TYPO3\CMS\Lowlevel\Database\QueryGenerator\mkTableSelect(), TYPO3\CMS\Lowlevel\Database\QueryGenerator\mkTypeSelect(), TYPO3\CMS\Lowlevel\Database\QueryGenerator\printCodeArray(), TYPO3\CMS\Lowlevel\Database\QueryGenerator\procesData(), TYPO3\CMS\Lowlevel\Database\QueryGenerator\setAndCleanUpExternalLists(), and TYPO3\CMS\Lowlevel\Database\QueryGenerator\updateIcon().

Referenced by TYPO3\CMS\Lowlevel\Database\QueryGenerator\queryMaker(), and TYPO3\CMS\Lowlevel\Database\QueryGenerator\saveQueryInAction().

makeStoreControl()

string TYPO3\CMS\Lowlevel\Database\QueryGenerator::makeStoreControl ( )

protected

Make store control

Returns

‪string

Definition at line 495 of file QueryGenerator.php.

References TYPO3\CMS\Lowlevel\Database\QueryGenerator\getBackendUserAuthentication(), TYPO3\CMS\Lowlevel\Database\QueryGenerator\initStoreArray(), TYPO3\CMS\Core\Utility\ExtensionManagementUtility\isLoaded(), and TYPO3\CMS\Core\Database\Connection\PARAM_INT.

Referenced by TYPO3\CMS\Lowlevel\Database\QueryGenerator\queryMaker().

makeValueList()

string TYPO3\CMS\Lowlevel\Database\QueryGenerator::makeValueList (   $fieldName,   $fieldValue,   $conf,   $table,   $splitString  )

protected

Make value list

Parameters

string	$fieldName
string	$fieldValue
array	$conf
string	$table
string	$splitString

Returns

‪string

Definition at line 1147 of file QueryGenerator.php.

References TYPO3\CMS\Lowlevel\Database\QueryGenerator\$fieldName, $GLOBALS, TYPO3\CMS\Lowlevel\Database\QueryGenerator\$table, TYPO3\CMS\Lowlevel\Database\QueryGenerator\getBackendUserAuthentication(), TYPO3\CMS\Lowlevel\Database\QueryGenerator\getLanguageService(), TYPO3\CMS\Lowlevel\Database\QueryGenerator\getTreeList(), TYPO3\CMS\Core\Utility\GeneralUtility\intExplode(), TYPO3\CMS\Core\Type\Bitmask\Permission\PAGE_SHOW, TYPO3\CMS\Core\Database\Query\QueryHelper\stripLogicalOperatorPrefix(), and TYPO3\CMS\Core\Utility\GeneralUtility\trimExplode().

Referenced by TYPO3\CMS\Lowlevel\Database\QueryGenerator\getProcessedValueExtra().

mkCompSelect()

string TYPO3\CMS\Lowlevel\Database\QueryGenerator::mkCompSelect (   $name,   $comparison,   $neg  )

protected

Make comparison select

Parameters

string	$name
string	$comparison
int	$neg

Returns

‪string

Definition at line 2334 of file QueryGenerator.php.

References TYPO3\CMS\Lowlevel\Database\QueryGenerator\$name.

Referenced by TYPO3\CMS\Lowlevel\Database\QueryGenerator\makeComparisonSelector().

mkFieldToInputSelect()

string TYPO3\CMS\Lowlevel\Database\QueryGenerator::mkFieldToInputSelect (   $name,   $fieldName  )

protected

Make field to input select

Parameters

string	$name
string	$fieldName

Returns

‪string

Definition at line 2277 of file QueryGenerator.php.

References TYPO3\CMS\Lowlevel\Database\QueryGenerator\$fieldName, TYPO3\CMS\Lowlevel\Database\QueryGenerator\$name, TYPO3\CMS\Lowlevel\Database\QueryGenerator\getBackendUserAuthentication(), and TYPO3\CMS\Lowlevel\Database\QueryGenerator\updateIcon().

Referenced by TYPO3\CMS\Lowlevel\Database\QueryGenerator\makeSelectorTable().

mkOperatorSelect()

string TYPO3\CMS\Lowlevel\Database\QueryGenerator::mkOperatorSelect (   $name,   $op,   $draw,   $submit  )

protected

Make operator select

Parameters

string	$name
string	$op
bool	$draw
bool	$submit

Returns

‪string

Definition at line 2184 of file QueryGenerator.php.

References TYPO3\CMS\Lowlevel\Database\QueryGenerator\$name.

Referenced by TYPO3\CMS\Lowlevel\Database\QueryGenerator\getFormElements().

mkTableSelect()

string TYPO3\CMS\Lowlevel\Database\QueryGenerator::mkTableSelect (   $name,   $cur  )

protected

Make table select

Parameters

string	$name
string	$cur

Returns

‪string

Definition at line 2308 of file QueryGenerator.php.

References $GLOBALS, TYPO3\CMS\Lowlevel\Database\QueryGenerator\$name, TYPO3\CMS\Lowlevel\Database\QueryGenerator\getBackendUserAuthentication(), and TYPO3\CMS\Lowlevel\Database\QueryGenerator\getLanguageService().

Referenced by TYPO3\CMS\Lowlevel\Database\QueryGenerator\makeSelectorTable().

mkTypeSelect()

string TYPO3\CMS\Lowlevel\Database\QueryGenerator::mkTypeSelect (   $name,   $fieldName,   $prepend = 'FIELD_'  )

protected

Make type select

Parameters

string	$name
string	$fieldName
string	$prepend

Returns

‪string

Definition at line 2210 of file QueryGenerator.php.

References TYPO3\CMS\Lowlevel\Database\QueryGenerator\$fieldName, TYPO3\CMS\Lowlevel\Database\QueryGenerator\$name, and TYPO3\CMS\Lowlevel\Database\QueryGenerator\getBackendUserAuthentication().

Referenced by TYPO3\CMS\Lowlevel\Database\QueryGenerator\makeComparisonSelector(), and TYPO3\CMS\Lowlevel\Database\QueryGenerator\makeSelectorTable().

printCodeArray()

string TYPO3\CMS\Lowlevel\Database\QueryGenerator::printCodeArray (   $codeArr,   $recursionLevel = 0  )

protected

Print code array

Parameters

array	$codeArr
int	$recursionLevel

Returns

‪string

Definition at line 2147 of file QueryGenerator.php.

Referenced by TYPO3\CMS\Lowlevel\Database\QueryGenerator\makeSelectorTable().

procesData()

TYPO3\CMS\Lowlevel\Database\QueryGenerator::procesData (   $qC = [] )

protected

Process data

Parameters

array

$qC

‪Query config

Definition at line 1586 of file QueryGenerator.php.

References TYPO3\CMS\Lowlevel\Database\QueryGenerator\$queryConfig, and TYPO3\CMS\Lowlevel\Database\QueryGenerator\getSubscript().

Referenced by TYPO3\CMS\Lowlevel\Database\QueryGenerator\makeSelectorTable().

procesStoreControl()

string TYPO3\CMS\Lowlevel\Database\QueryGenerator::procesStoreControl ( )

protected

Process store control

Returns

‪string

Definition at line 665 of file QueryGenerator.php.

References TYPO3\CMS\Lowlevel\Database\QueryGenerator\addToStoreQueryConfigs(), TYPO3\CMS\Lowlevel\Database\QueryGenerator\cleanStoreQueryConfigs(), TYPO3\CMS\Core\Messaging\AbstractMessage\ERROR, TYPO3\CMS\Lowlevel\Database\QueryGenerator\getLanguageService(), TYPO3\CMS\Lowlevel\Database\QueryGenerator\initStoreArray(), TYPO3\CMS\Core\Utility\ExtensionManagementUtility\isLoaded(), TYPO3\CMS\Lowlevel\Database\QueryGenerator\loadStoreQueryConfigs(), and TYPO3\CMS\Lowlevel\Database\QueryGenerator\saveQueryInAction().

Referenced by TYPO3\CMS\Lowlevel\Database\QueryGenerator\queryMaker().

queryMaker()

string TYPO3\CMS\Lowlevel\Database\QueryGenerator::queryMaker

(

)

Query marker

Returns

‪string

Definition at line 303 of file QueryGenerator.php.

References $GLOBALS, $output, TYPO3\CMS\Lowlevel\Database\QueryGenerator\getBackendUserAuthentication(), TYPO3\CMS\Lowlevel\Database\QueryGenerator\getQuery(), TYPO3\CMS\Lowlevel\Database\QueryGenerator\getQueryResultCode(), TYPO3\CMS\Lowlevel\Database\QueryGenerator\getSelectQuery(), TYPO3\CMS\Lowlevel\Database\QueryGenerator\init(), TYPO3\CMS\Lowlevel\Database\QueryGenerator\makeSelectorTable(), TYPO3\CMS\Lowlevel\Database\QueryGenerator\makeStoreControl(), TYPO3\CMS\Lowlevel\Database\QueryGenerator\procesStoreControl(), TYPO3\CMS\Lowlevel\Database\QueryGenerator\setFormName(), and TYPO3\CMS\Core\Database\Query\QueryHelper\stripLogicalOperatorPrefix().

renderNoResultsFoundMessage()

TYPO3\CMS\Lowlevel\Database\QueryGenerator::renderNoResultsFoundMessage ( )

private

Exceptions

Definition at line 1388 of file QueryGenerator.php.

References TYPO3\CMS\Core\Messaging\AbstractMessage\INFO.

Referenced by TYPO3\CMS\Lowlevel\Database\QueryGenerator\getQueryResultCode().

resultRowDisplay()

string TYPO3\CMS\Lowlevel\Database\QueryGenerator::resultRowDisplay (   $row,   $conf,   $table  )

protected

Result row display

Parameters

array	$row
array	$conf
string	$table

Returns

‪string

Definition at line 880 of file QueryGenerator.php.

References TYPO3\CMS\Lowlevel\Database\QueryGenerator\$fieldName, $GLOBALS, TYPO3\CMS\Lowlevel\Database\QueryGenerator\$table, TYPO3\CMS\Core\Utility\HttpUtility\buildQueryString(), TYPO3\CMS\Lowlevel\Database\QueryGenerator\getLanguageService(), TYPO3\CMS\Lowlevel\Database\QueryGenerator\getProcessedValueExtra(), and TYPO3\CMS\Core\Imaging\Icon\SIZE_SMALL.

Referenced by TYPO3\CMS\Lowlevel\Database\QueryGenerator\getQueryResultCode(), and TYPO3\CMS\Lowlevel\Database\QueryGenerator\search().

resultRowTitles()

string TYPO3\CMS\Lowlevel\Database\QueryGenerator::resultRowTitles (   $row,   $conf  )

protected

Render table header

Parameters

array	$row	‪Table columns
array	$conf	‪Table TCA

Returns

‪string HTML of table header

Definition at line 1357 of file QueryGenerator.php.

References TYPO3\CMS\Lowlevel\Database\QueryGenerator\$fieldName, and TYPO3\CMS\Lowlevel\Database\QueryGenerator\getLanguageService().

Referenced by TYPO3\CMS\Lowlevel\Database\QueryGenerator\getQueryResultCode(), and TYPO3\CMS\Lowlevel\Database\QueryGenerator\search().

saveQueryInAction()

bool TYPO3\CMS\Lowlevel\Database\QueryGenerator::saveQueryInAction (   $uid )

protected

Save query in action

Parameters

int

$uid

Returns

‪bool

Definition at line 598 of file QueryGenerator.php.

References TYPO3\CMS\Lowlevel\Database\QueryGenerator\getQuery(), TYPO3\CMS\Lowlevel\Database\QueryGenerator\getSelectQuery(), TYPO3\CMS\Lowlevel\Database\QueryGenerator\init(), TYPO3\CMS\Core\Utility\ExtensionManagementUtility\isLoaded(), TYPO3\CMS\Lowlevel\Database\QueryGenerator\makeSelectorTable(), TYPO3\CMS\Core\Database\Connection\PARAM_LOB, and TYPO3\CMS\Core\Database\Query\QueryHelper\stripLogicalOperatorPrefix().

Referenced by TYPO3\CMS\Lowlevel\Database\QueryGenerator\procesStoreControl().

search()

string TYPO3\CMS\Lowlevel\Database\QueryGenerator::search

(

)

Search

Returns

‪string

Definition at line 378 of file QueryGenerator.php.

References TYPO3\CMS\Lowlevel\Database\QueryGenerator\$fields, $GLOBALS, TYPO3\CMS\Lowlevel\Database\QueryGenerator\$table, TYPO3\CMS\Lowlevel\Database\QueryGenerator\getLanguageService(), TYPO3\CMS\Core\Database\Connection\PARAM_STR, TYPO3\CMS\Lowlevel\Database\QueryGenerator\resultRowDisplay(), and TYPO3\CMS\Lowlevel\Database\QueryGenerator\resultRowTitles().

setAndCleanUpExternalLists()

TYPO3\CMS\Lowlevel\Database\QueryGenerator::setAndCleanUpExternalLists (   $name,   $list,   $force = ''  )

protected

Set and clean up external lists

Parameters

string	$name	‪The name
string	$list	‪The list
string	$force

Definition at line 1569 of file QueryGenerator.php.

References TYPO3\CMS\Lowlevel\Database\QueryGenerator\$fieldName, TYPO3\CMS\Lowlevel\Database\QueryGenerator\$fields, TYPO3\CMS\Lowlevel\Database\QueryGenerator\$name, and TYPO3\CMS\Core\Utility\GeneralUtility\trimExplode().

Referenced by TYPO3\CMS\Lowlevel\Database\QueryGenerator\makeSelectorTable().

setFormName()

TYPO3\CMS\Lowlevel\Database\QueryGenerator::setFormName

(

$formName

)

Sets the current name of the input form.

Parameters

string

$formName

‪The name of the form.

Definition at line 485 of file QueryGenerator.php.

References TYPO3\CMS\Lowlevel\Database\QueryGenerator\$formName.

Referenced by TYPO3\CMS\Lowlevel\Database\QueryGenerator\queryMaker().

updateIcon()

string TYPO3\CMS\Lowlevel\Database\QueryGenerator::updateIcon ( )

protected

Update icon

Returns

‪string

Definition at line 2531 of file QueryGenerator.php.

Referenced by TYPO3\CMS\Lowlevel\Database\QueryGenerator\getFormElements(), TYPO3\CMS\Lowlevel\Database\QueryGenerator\makeSelectorTable(), and TYPO3\CMS\Lowlevel\Database\QueryGenerator\mkFieldToInputSelect().

verifyComparison()

int TYPO3\CMS\Lowlevel\Database\QueryGenerator::verifyComparison (   $comparison,   $neg  )

protected

Verify comparison

Parameters

string	$comparison
int	$neg

Returns

‪int

Definition at line 2255 of file QueryGenerator.php.

Referenced by TYPO3\CMS\Lowlevel\Database\QueryGenerator\cleanUpQueryConfig().

verifyType()

string TYPO3\CMS\Lowlevel\Database\QueryGenerator::verifyType (   $fieldName )

protected

Verify type

Parameters

string

$fieldName

Returns

‪string

Definition at line 2234 of file QueryGenerator.php.

References TYPO3\CMS\Lowlevel\Database\QueryGenerator\$fieldName.

Referenced by TYPO3\CMS\Lowlevel\Database\QueryGenerator\cleanUpQueryConfig().

Member Data Documentation

$comp_offsets

array TYPO3\CMS\Lowlevel\Database\QueryGenerator::$comp_offsets

protected

Initial value:

= array( 
        'text' => 0,
        'number' => 1,
        'multiple' => 2,
        'relation' => 2,
        'date' => 3,
        'time' => 3,
        'boolean' => 4,
        'binary' => 5,
     )

Definition at line 206 of file QueryGenerator.php.

$compSQL

array TYPO3\CMS\Lowlevel\Database\QueryGenerator::$compSQL

protected

Definition at line 149 of file QueryGenerator.php.

$enablePrefix

bool TYPO3\CMS\Lowlevel\Database\QueryGenerator::$enablePrefix = false

protected

Definition at line 253 of file QueryGenerator.php.

$enableQueryParts

bool TYPO3\CMS\Lowlevel\Database\QueryGenerator::$enableQueryParts = false

protected

Definition at line 257 of file QueryGenerator.php.

$extFieldLists

array TYPO3\CMS\Lowlevel\Database\QueryGenerator::$extFieldLists = array( )

protected

Definition at line 243 of file QueryGenerator.php.

$fieldList

string TYPO3\CMS\Lowlevel\Database\QueryGenerator::$fieldList

protected

Field list

Definition at line 233 of file QueryGenerator.php.

Referenced by TYPO3\CMS\Lowlevel\Database\QueryGenerator\getSelectQuery(), and TYPO3\CMS\Lowlevel\Database\QueryGenerator\init().

$fieldName

string TYPO3\CMS\Lowlevel\Database\QueryGenerator::$fieldName

protected

Definition at line 261 of file QueryGenerator.php.

Referenced by TYPO3\CMS\Lowlevel\Database\QueryGenerator\cleanUpQueryConfig(), TYPO3\CMS\Lowlevel\Database\QueryGenerator\getFormElements(), TYPO3\CMS\Lowlevel\Database\QueryGenerator\getProcessedValueExtra(), TYPO3\CMS\Lowlevel\Database\QueryGenerator\getSelectQuery(), TYPO3\CMS\Lowlevel\Database\QueryGenerator\init(), TYPO3\CMS\Lowlevel\Database\QueryGenerator\makeComparisonSelector(), TYPO3\CMS\Lowlevel\Database\QueryGenerator\makeOptionList(), TYPO3\CMS\Lowlevel\Database\QueryGenerator\makeValueList(), TYPO3\CMS\Lowlevel\Database\QueryGenerator\mkFieldToInputSelect(), TYPO3\CMS\Lowlevel\Database\QueryGenerator\mkTypeSelect(), TYPO3\CMS\Lowlevel\Database\QueryGenerator\resultRowDisplay(), TYPO3\CMS\Lowlevel\Database\QueryGenerator\resultRowTitles(), TYPO3\CMS\Lowlevel\Database\QueryGenerator\setAndCleanUpExternalLists(), and TYPO3\CMS\Lowlevel\Database\QueryGenerator\verifyType().

$fields

array TYPO3\CMS\Lowlevel\Database\QueryGenerator::$fields = array( )

protected

Array of the fields possible

Definition at line 239 of file QueryGenerator.php.

Referenced by TYPO3\CMS\Lowlevel\Database\QueryGenerator\getProcessedValueExtra(), TYPO3\CMS\Lowlevel\Database\QueryGenerator\search(), and TYPO3\CMS\Lowlevel\Database\QueryGenerator\setAndCleanUpExternalLists().

$formName

string TYPO3\CMS\Lowlevel\Database\QueryGenerator::$formName = ''

protected

Definition at line 64 of file QueryGenerator.php.

Referenced by TYPO3\CMS\Lowlevel\Database\QueryGenerator\setFormName().

$hookArray

array TYPO3\CMS\Lowlevel\Database\QueryGenerator::$hookArray = array( )

protected

Definition at line 60 of file QueryGenerator.php.

$iconFactory

IconFactory TYPO3\CMS\Lowlevel\Database\QueryGenerator::$iconFactory

protected

Definition at line 68 of file QueryGenerator.php.

$lang

array TYPO3\CMS\Lowlevel\Database\QueryGenerator::$lang

protected

Definition at line 88 of file QueryGenerator.php.

$menuItems

array TYPO3\CMS\Lowlevel\Database\QueryGenerator::$menuItems = array( )

protected

information on the menu of this module

Definition at line 80 of file QueryGenerator.php.

Referenced by TYPO3\CMS\Lowlevel\Database\QueryGenerator\__construct().

$moduleName

string TYPO3\CMS\Lowlevel\Database\QueryGenerator::$moduleName

protected

Definition at line 84 of file QueryGenerator.php.

Referenced by TYPO3\CMS\Lowlevel\Database\QueryGenerator\__construct().

$name

string TYPO3\CMS\Lowlevel\Database\QueryGenerator::$name

protected

Form data name prefix

Definition at line 221 of file QueryGenerator.php.

Referenced by TYPO3\CMS\Lowlevel\Database\QueryGenerator\getDateTimePickerField(), TYPO3\CMS\Lowlevel\Database\QueryGenerator\init(), TYPO3\CMS\Lowlevel\Database\QueryGenerator\mkCompSelect(), TYPO3\CMS\Lowlevel\Database\QueryGenerator\mkFieldToInputSelect(), TYPO3\CMS\Lowlevel\Database\QueryGenerator\mkOperatorSelect(), TYPO3\CMS\Lowlevel\Database\QueryGenerator\mkTableSelect(), TYPO3\CMS\Lowlevel\Database\QueryGenerator\mkTypeSelect(), and TYPO3\CMS\Lowlevel\Database\QueryGenerator\setAndCleanUpExternalLists().

$noDownloadB

int TYPO3\CMS\Lowlevel\Database\QueryGenerator::$noDownloadB = 0

protected

Definition at line 56 of file QueryGenerator.php.

$queryConfig

array TYPO3\CMS\Lowlevel\Database\QueryGenerator::$queryConfig = array( )

protected

The query config

Definition at line 249 of file QueryGenerator.php.

Referenced by TYPO3\CMS\Lowlevel\Database\QueryGenerator\cleanUpQueryConfig(), TYPO3\CMS\Lowlevel\Database\QueryGenerator\getFormElements(), TYPO3\CMS\Lowlevel\Database\QueryGenerator\getQuery(), and TYPO3\CMS\Lowlevel\Database\QueryGenerator\procesData().

$settings

array TYPO3\CMS\Lowlevel\Database\QueryGenerator::$settings = array( )

protected

Settings, usually from the controller

Definition at line 76 of file QueryGenerator.php.

Referenced by TYPO3\CMS\Lowlevel\Database\QueryGenerator\__construct(), and TYPO3\CMS\Lowlevel\Database\QueryGenerator\init().

$showFieldAndTableNames

bool TYPO3\CMS\Lowlevel\Database\QueryGenerator::$showFieldAndTableNames = false

protected

If the current user is an admin and $GLOBALS['TYPO3_CONF_VARS']['BE']['debug'] is set to true, the names of fields and tables are displayed.

Definition at line 268 of file QueryGenerator.php.

$storeList

string TYPO3\CMS\Lowlevel\Database\QueryGenerator::$storeList = 'search_query_smallparts,search_result_labels,labels_noprefix,show_deleted,queryConfig,queryTable,queryFields,queryLimit,queryOrder,queryOrderDesc,queryOrder2,queryOrder2Desc,queryGroup,search_query_makeQuery'

protected

Definition at line 52 of file QueryGenerator.php.

$table

string TYPO3\CMS\Lowlevel\Database\QueryGenerator::$table

protected

Table for the query

Definition at line 227 of file QueryGenerator.php.

Referenced by TYPO3\CMS\Lowlevel\Database\QueryGenerator\csvValues(), TYPO3\CMS\Lowlevel\Database\QueryGenerator\getLabelCol(), TYPO3\CMS\Lowlevel\Database\QueryGenerator\getProcessedValueExtra(), TYPO3\CMS\Lowlevel\Database\QueryGenerator\getQueryResultCode(), TYPO3\CMS\Lowlevel\Database\QueryGenerator\getSelectQuery(), TYPO3\CMS\Lowlevel\Database\QueryGenerator\init(), TYPO3\CMS\Lowlevel\Database\QueryGenerator\makeFieldList(), TYPO3\CMS\Lowlevel\Database\QueryGenerator\makeOptionList(), TYPO3\CMS\Lowlevel\Database\QueryGenerator\makeValueList(), TYPO3\CMS\Lowlevel\Database\QueryGenerator\resultRowDisplay(), and TYPO3\CMS\Lowlevel\Database\QueryGenerator\search().

$tableArray

array TYPO3\CMS\Lowlevel\Database\QueryGenerator::$tableArray = array( )

protected

Definition at line 72 of file QueryGenerator.php.