Inheritance diagram for TYPO3\CMS\Core\Database\QueryGenerator:

Public Member Functions
	makeFieldList ()

	init ($name, $table, $fieldList='')

	setAndCleanUpExternalLists ($name, $list, $force='')

	procesData ($qC='')

	cleanUpQueryConfig ($queryConfig)

	getFormElements ($subLevel=0, $queryConfig='', $parent='')

	makeOptionList ($fN, $conf, $table)

	printCodeArray ($codeArr, $l=0)

	formatQ ($str)

	mkOperatorSelect ($name, $op, $draw, $submit)

	mkTypeSelect ($name, $fieldName, $prepend='FIELD_')

	verifyType ($fieldName)

	verifyComparison ($comparison, $neg)

	mkFieldToInputSelect ($name, $fieldName)

	mkTableSelect ($name, $cur)

	mkCompSelect ($name, $comparison, $neg)

	getSubscript ($arr)

	initUserDef ()

	userDef ()

	userDefCleanUp ($queryConfig)

	getQuery ($queryConfig, $pad='')

	getQuerySingle ($conf, $first)

	cleanInputVal ($conf, $suffix='')

	getUserDefQuery ($qcArr)

	updateIcon ()

	getLabelCol ()

	makeSelectorTable ($modSettings, $enableList='table, fields, query, group, order, limit')

	getTreeList ($id, $depth, $begin=0, $perms_clause)

	getSelectQuery ($qString='', $fN='')

	JSbottom ($formname)

	setFormName ($formName)

Public Attributes
	$lang

	$compSQL

	$comp_offsets

	$noWrap = ' nowrap'

	$name

	$table

	$fieldList

	$fields = array()

	$extFieldLists = array()

	$queryConfig = array()

	$enablePrefix = 0

	$enableQueryParts = 0

	$extJSCODE = ''

Protected Attributes
	$formName = ''

Detailed Description

Class for generating front end for building queries

Author: Christian Jul Jensen chris.nosp@m.tian.nosp@m.@typo.nosp@m.3.co.nosp@m.m; Kasper Skårhøj kaspe.nosp@m.rYYY.nosp@m.Y@typ.nosp@m.o3.c.nosp@m.om Jo Hasenau info@.nosp@m.cybe.nosp@m.rcraf.nosp@m.t.de

Definition at line 26 of file QueryGenerator.php.

Member Function Documentation

◆ cleanInputVal()

TYPO3\CMS\Core\Database\QueryGenerator::cleanInputVal	(	$conf,
		$suffix = `''`
	)

[Describe function...]

Parameters

[type]	$conf: ...
[type]	$suffix: ...

Returns: [type] ...

Todo:: Define visibility

Definition at line 1259 of file QueryGenerator.php.

References TYPO3\CMS\Core\Utility\GeneralUtility\intExplode().

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

◆ cleanUpQueryConfig()

TYPO3\CMS\Core\Database\QueryGenerator::cleanUpQueryConfig ( $queryConfig )

[Describe function...]

Parameters

[type] $queryConfig: ...

Returns: [type] ...

Todo:: Define visibility

Definition at line 517 of file QueryGenerator.php.

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

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

◆ formatQ()

TYPO3\CMS\Core\Database\QueryGenerator::formatQ ( $str )

[Describe function...]

Parameters

[type] $str: ...

Returns: [type] ...

Todo:: Define visibility

Definition at line 974 of file QueryGenerator.php.

Referenced by TYPO3\CMS\Core\Database\QueryGenerator\printCodeArray().

◆ getFormElements()

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

[Describe function...]

Parameters

[type]	$subLevel: ...
[type]	$queryConfig: ...
[type]	$parent: ...

Returns: [type] ...

Todo:: Define visibility

Definition at line 574 of file QueryGenerator.php.

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

◆ getLabelCol()

TYPO3\CMS\Core\Database\QueryGenerator::getLabelCol ( )

[Describe function...]

Returns: [type] ...

Todo:: Define visibility

Definition at line 1307 of file QueryGenerator.php.

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

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

◆ getQuery()

TYPO3\CMS\Core\Database\QueryGenerator::getQuery	(	$queryConfig,
		$pad = `''`
	)

[Describe function...]

Parameters

[type]	$queryConfig: ...
[type]	$pad: ...

Returns: [type] ...

Todo:: Define visibility

Definition at line 1187 of file QueryGenerator.php.

References TYPO3\CMS\Core\Database\QueryGenerator\$queryConfig, TYPO3\CMS\Core\Database\QueryGenerator\getQuerySingle(), and TYPO3\CMS\Core\Database\QueryGenerator\getUserDefQuery().

Referenced by TYPO3\CMS\Core\Database\QueryGenerator\getSelectQuery().

◆ getQuerySingle()

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

[Describe function...]

Parameters

[type]	$conf: ...
[type]	$first: ...

Returns: [type] ...

Todo:: Define visibility

Definition at line 1216 of file QueryGenerator.php.

References $GLOBALS, and TYPO3\CMS\Core\Database\QueryGenerator\cleanInputVal().

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

◆ getSelectQuery()

TYPO3\CMS\Core\Database\QueryGenerator::getSelectQuery	(	$qString = `''`,
		$fN = `''`
	)

[Describe function...]

Parameters

[type]	$qString: ...
[type]	$fN: ...

Returns: [type] ...

Todo:: Define visibility

Definition at line 1475 of file QueryGenerator.php.

References $GLOBALS, TYPO3\CMS\Core\Database\QueryGenerator\$table, TYPO3\CMS\Backend\Utility\BackendUtility\deleteClause(), TYPO3\CMS\Core\Database\QueryGenerator\getQuery(), and TYPO3\CMS\Core\Database\QueryGenerator\getTreeList().

◆ getSubscript()

TYPO3\CMS\Core\Database\QueryGenerator::getSubscript ( $arr )

[Describe function...]

Parameters

[type] $arr: ...

Returns: [type] ...

Todo:: Define visibility

Definition at line 1138 of file QueryGenerator.php.

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

◆ getTreeList()

TYPO3\CMS\Core\Database\QueryGenerator::getTreeList	(	$id,
		$depth,
		$begin = `0`,
		$perms_clause
	)

[Describe function...]

Parameters

[type]	$qString: ...
[type]	$depth: ...
[type]	$begin: ...
[type]	$perms_clause: ...

Returns: [type] ...

Todo:: Define visibility

Definition at line 1440 of file QueryGenerator.php.

References $GLOBALS, and TYPO3\CMS\Backend\Utility\BackendUtility\deleteClause().

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

◆ getUserDefQuery()

TYPO3\CMS\Core\Database\QueryGenerator::getUserDefQuery ( $qcArr )

[Describe function...]

Parameters

[type] $qcArr: ...

Returns: [type] ...

Todo:: Define visibility

Definition at line 1287 of file QueryGenerator.php.

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

◆ init()

TYPO3\CMS\Core\Database\QueryGenerator::init	(	$name,
		$table,
		$fieldList = `''`
	)

[Describe function...]

Parameters

[type]	$name: ...
[type]	$table: ...
[type]	$fieldList: ...

Returns: [type] ...

Todo:: Define visibility

Definition at line 260 of file QueryGenerator.php.

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

◆ initUserDef()

TYPO3\CMS\Core\Database\QueryGenerator::initUserDef ( )

[Describe function...]

Returns: [type] ...

Todo:: Define visibility

Definition at line 1154 of file QueryGenerator.php.

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

◆ JSbottom()

TYPO3\CMS\Core\Database\QueryGenerator::JSbottom ( $formname )

[Describe function...]

Parameters

string $formname

Returns: string

Todo:: Define visibility

Definition at line 1511 of file QueryGenerator.php.

References $GLOBALS.

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

◆ makeFieldList()

TYPO3\CMS\Core\Database\QueryGenerator::makeFieldList ( )

Make a list of fields for current table

Returns: string Separated list of fields

Todo:: Define visibility

Definition at line 226 of file QueryGenerator.php.

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

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

◆ makeOptionList()

TYPO3\CMS\Core\Database\QueryGenerator::makeOptionList	(	$fN,
		$conf,
		$table
	)

[Describe function...]

Parameters

[type]	$codeArr: ...
[type]	$l: ...
[type]	$table: ...

Returns: [type] ...

Todo:: Define visibility

Definition at line 736 of file QueryGenerator.php.

References $GLOBALS, TYPO3\CMS\Core\Database\QueryGenerator\$table, TYPO3\CMS\Backend\Utility\BackendUtility\deleteClause(), TYPO3\CMS\Core\Database\QueryGenerator\getTreeList(), and TYPO3\CMS\Core\Utility\GeneralUtility\inList().

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

◆ makeSelectorTable()

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

[Describe function...]

Parameters

[type]	$modSettings: ...
[type]	$enableList: ...

Returns: [type] ...

Todo:: Define visibility

Definition at line 1319 of file QueryGenerator.php.

◆ mkCompSelect()

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

[Describe function...]

Parameters

[type]	$name: ...
[type]	$comparison: ...
[type]	$neg: ...

Returns: [type] ...

Todo:: Define visibility

Definition at line 1119 of file QueryGenerator.php.

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

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

◆ mkFieldToInputSelect()

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

[Describe function...]

Parameters

[type]	$name: ...
[type]	$fieldName: ...

Returns: [type] ...

Todo:: Define visibility

Definition at line 1075 of file QueryGenerator.php.

References $GLOBALS, TYPO3\CMS\Core\Database\QueryGenerator\$name, and TYPO3\CMS\Core\Database\QueryGenerator\updateIcon().

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

◆ mkOperatorSelect()

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

[Describe function...]

Parameters

[type]	$name: ...
[type]	$op: ...
[type]	$draw: ...
[type]	$submit: ...

Returns: [type] ...

Todo:: Define visibility

Definition at line 988 of file QueryGenerator.php.

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

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

◆ mkTableSelect()

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

[Describe function...]

Parameters

[type]	$name: ...
[type]	$cur: ...

Returns: [type] ...

Todo:: Define visibility

Definition at line 1098 of file QueryGenerator.php.

References $GLOBALS, and TYPO3\CMS\Core\Database\QueryGenerator\$name.

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

◆ mkTypeSelect()

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

[Describe function...]

Parameters

[type]	$name: ...
[type]	$fieldName: ...
[type]	$prepend: ...

Returns: [type] ...

Todo:: Define visibility

Definition at line 1011 of file QueryGenerator.php.

References $GLOBALS, and TYPO3\CMS\Core\Database\QueryGenerator\$name.

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

◆ printCodeArray()

TYPO3\CMS\Core\Database\QueryGenerator::printCodeArray	(	$codeArr,
		$l = `0`
	)

[Describe function...]

Parameters

[type]	$codeArr: ...
[type]	$l: ...

Returns: [type] ...

Todo:: Define visibility

Definition at line 947 of file QueryGenerator.php.

References $GLOBALS, TYPO3\CMS\Core\Database\QueryGenerator\formatQ(), and TYPO3\CMS\Core\Utility\GeneralUtility\modifyHTMLColor().

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

◆ procesData()

TYPO3\CMS\Core\Database\QueryGenerator::procesData ( $qC = '' )

[Describe function...]

Parameters

[type] $qC: ...

Returns: [type] ...

Todo:: Define visibility

Definition at line 413 of file QueryGenerator.php.

References TYPO3\CMS\Core\Database\QueryGenerator\$queryConfig, TYPO3\CMS\Core\Utility\GeneralUtility\_POST(), and TYPO3\CMS\Core\Database\QueryGenerator\getSubscript().

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

◆ setAndCleanUpExternalLists()

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

[Describe function...]

Parameters

[type]	$name: ...
[type]	$list: ...
[type]	$force: ...

Returns: [type] ...

Todo:: Define visibility

Definition at line 395 of file QueryGenerator.php.

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

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

◆ setFormName()

TYPO3\CMS\Core\Database\QueryGenerator::setFormName ( $formName )

Sets the current name of the input form.

Parameters

string $formName The name of the form.

Returns: void

Definition at line 1533 of file QueryGenerator.php.

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

◆ updateIcon()

TYPO3\CMS\Core\Database\QueryGenerator::updateIcon ( )

[Describe function...]

Returns: [type] ...

Todo:: Define visibility

Definition at line 1297 of file QueryGenerator.php.

References $GLOBALS, and TYPO3\CMS\Backend\Utility\IconUtility\skinImg().

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

◆ userDef()

TYPO3\CMS\Core\Database\QueryGenerator::userDef ( )

[Describe function...]

Returns: [type] ...

Todo:: Define visibility

Definition at line 1164 of file QueryGenerator.php.

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

◆ userDefCleanUp()

TYPO3\CMS\Core\Database\QueryGenerator::userDefCleanUp ( $queryConfig )

[Describe function...]

Parameters

[type] $queryConfig: ...

Returns: [type] ...

Todo:: Define visibility

Definition at line 1175 of file QueryGenerator.php.

References TYPO3\CMS\Core\Database\QueryGenerator\$queryConfig.

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

◆ verifyComparison()

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

[Describe function...]

Parameters

[type]	$comparison: ...
[type]	$neg: ...

Returns: [type] ...

Todo:: Define visibility

Definition at line 1053 of file QueryGenerator.php.

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

◆ verifyType()

TYPO3\CMS\Core\Database\QueryGenerator::verifyType ( $fieldName )

[Describe function...]

Parameters

[type] $fieldName: ...

Returns: [type] ...

Todo:: Define visibility

Definition at line 1032 of file QueryGenerator.php.

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

Member Data Documentation

◆ $comp_offsets

TYPO3\CMS\Core\Database\QueryGenerator::$comp_offsets

Initial value:

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

Todo:: Define visibility

Definition at line 151 of file QueryGenerator.php.

◆ $compSQL

TYPO3\CMS\Core\Database\QueryGenerator::$compSQL

Todo:: Define visibility

Definition at line 93 of file QueryGenerator.php.

◆ $enablePrefix

TYPO3\CMS\Core\Database\QueryGenerator::$enablePrefix = 0

Todo:: Define visibility

Definition at line 206 of file QueryGenerator.php.

◆ $enableQueryParts

TYPO3\CMS\Core\Database\QueryGenerator::$enableQueryParts = 0

Todo:: Define visibility

Definition at line 211 of file QueryGenerator.php.

◆ $extFieldLists

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

Todo:: Define visibility

Definition at line 195 of file QueryGenerator.php.

◆ $extJSCODE

TYPO3\CMS\Core\Database\QueryGenerator::$extJSCODE = ''

Todo:: Define visibility

Definition at line 216 of file QueryGenerator.php.

◆ $fieldList

TYPO3\CMS\Core\Database\QueryGenerator::$fieldList

Todo:: Define visibility

Definition at line 184 of file QueryGenerator.php.

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

◆ $fields

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

Todo:: Define visibility

Definition at line 190 of file QueryGenerator.php.

Referenced by TYPO3\CMS\Core\Database\QueryGenerator\setAndCleanUpExternalLists().

◆ $formName

TYPO3\CMS\Core\Database\QueryGenerator::$formName = ''

protected

Definition at line 218 of file QueryGenerator.php.

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

◆ $lang

TYPO3\CMS\Core\Database\QueryGenerator::$lang

Todo:: Define visibility

Definition at line 31 of file QueryGenerator.php.

◆ $name

TYPO3\CMS\Core\Database\QueryGenerator::$name

Todo:: Define visibility

Definition at line 172 of file QueryGenerator.php.

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

◆ $noWrap

TYPO3\CMS\Core\Database\QueryGenerator::$noWrap = ' nowrap'

Todo:: Define visibility

Definition at line 166 of file QueryGenerator.php.

◆ $queryConfig

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

Todo:: Define visibility

Definition at line 201 of file QueryGenerator.php.

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

◆ $table

TYPO3\CMS\Core\Database\QueryGenerator::$table

Todo:: Define visibility

Definition at line 178 of file QueryGenerator.php.

Referenced by TYPO3\CMS\Core\Database\QueryGenerator\getLabelCol(), TYPO3\CMS\Core\Database\QueryGenerator\getSelectQuery(), TYPO3\CMS\Core\Database\QueryGenerator\init(), TYPO3\CMS\Core\Database\QueryGenerator\makeFieldList(), and TYPO3\CMS\Core\Database\QueryGenerator\makeOptionList().

Public Member Functions

Public Attributes

Protected Attributes

Detailed Description

Member Function Documentation

◆ cleanInputVal()

◆ cleanUpQueryConfig()

◆ formatQ()

◆ getFormElements()

◆ getLabelCol()

◆ getQuery()

◆ getQuerySingle()

◆ getSelectQuery()

◆ getSubscript()

◆ getTreeList()

◆ getUserDefQuery()

◆ init()

◆ initUserDef()

◆ JSbottom()

◆ makeFieldList()

◆ makeOptionList()

◆ makeSelectorTable()

◆ mkCompSelect()

◆ mkFieldToInputSelect()

◆ mkOperatorSelect()

◆ mkTableSelect()

◆ mkTypeSelect()

◆ printCodeArray()

◆ procesData()

◆ setAndCleanUpExternalLists()

◆ setFormName()

◆ updateIcon()

◆ userDef()

◆ userDefCleanUp()

◆ verifyComparison()

◆ verifyType()

Member Data Documentation

◆ $comp_offsets

◆ $compSQL

◆ $enablePrefix

◆ $enableQueryParts

◆ $extFieldLists

◆ $extJSCODE

◆ $fieldList

◆ $fields

◆ $formName

◆ $lang

◆ $name

◆ $noWrap

◆ $queryConfig

◆ $table