TYPO3 CMS  TYPO3_7-6
TYPO3\CMS\Core\Database\QueryGenerator Class Reference

Public Member Functions

 makeFieldList ()
 
 init ($name, $table, $fieldList='')
 
 setAndCleanUpExternalLists ($name, $list, $force='')
 
 procesData ($qC='')
 
 cleanUpQueryConfig ($queryConfig)
 
 getFormElements ($subLevel=0, $queryConfig='', $parent='')
 
 makeOptionList ($fieldName, $conf, $table)
 
 printCodeArray ($codeArr, $recursionLevel=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 ($fieldPrefix, $conf, $fieldName, $fieldType)
 
 userDefCleanUp ($queryConfig)
 
 getQuery ($queryConfig, $pad='')
 
 getQuerySingle ($conf, $first)
 
 cleanInputVal ($conf, $suffix='')
 
 getUserDefQuery ($qcArr, $first)
 
 updateIcon ()
 
 getLabelCol ()
 
 makeSelectorTable ($modSettings, $enableList='table, fields, query, group, order, limit')
 
 getTreeList ($id, $depth, $begin=0, $perms_clause)
 
 getSelectQuery ($qString='', $fieldName='')
 
 JSbottom ($formname)
 
 setFormName ($formName)
 

Public Attributes

 $lang
 
 $compSQL
 
 $comp_offsets
 
 $noWrap = ' nowrap'
 
 $name
 
 $table
 
 $tableArray
 
 $fieldList
 
 $fields = []
 
 $extFieldLists = []
 
 $queryConfig = []
 
 $enablePrefix = false
 
 $enableQueryParts = false
 
 $extJSCODE = ''
 

Protected Member Functions

 makeComparisonSelector ($subscript, $fieldName, $conf)
 
 getDateTimePickerField ($name, $timestamp, $type)
 
 getDatabaseConnection ()
 
 getBackendUserAuthentication ()
 
 getModule ()
 
 getLanguageService ()
 

Protected Attributes

 $formName = ''
 
 $limitBegin
 
 $limitLength
 
 $fieldName
 

Detailed Description

Class for generating front end for building queries

Definition at line 27 of file QueryGenerator.php.

Member Function Documentation

◆ cleanInputVal()

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

Clear input value

Parameters
array$conf
string$suffix
Returns
string

Definition at line 1331 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()

◆ formatQ()

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

Format query-string (output as HTML)

Parameters
string$str
Returns
string
Deprecated:
since TYPO3 CMS 7, will be removed in TYPO3 CMS 8

Definition at line 1031 of file QueryGenerator.php.

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

◆ getBackendUserAuthentication()

◆ getDatabaseConnection()

◆ getDateTimePickerField()

TYPO3\CMS\Core\Database\QueryGenerator::getDateTimePickerField (   $name,
  $timestamp,
  $type 
)
protected
Parameters
string$namethe field name
int$timestampthe unix timestamp
string$type[datetime, date, time, timesec, year]
Returns
string

Definition at line 1640 of file QueryGenerator.php.

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

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

◆ getFormElements()

◆ getLabelCol()

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

Get label column

Returns
string

Definition at line 1379 of file QueryGenerator.php.

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

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

◆ getLanguageService()

TYPO3\CMS\Core\Database\QueryGenerator::getLanguageService ( )
protected

◆ getModule()

TYPO3\CMS\Core\Database\QueryGenerator::getModule ( )
protected

◆ getQuery()

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

◆ getQuerySingle()

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

◆ getSelectQuery()

◆ getSubscript()

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

Get subscript

Parameters
array$arr
Returns
array

Definition at line 1204 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 
)

◆ getUserDefQuery()

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

Get user definition query

Parameters
array$qcArr
bool$first
Returns
void

Definition at line 1360 of file QueryGenerator.php.

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

◆ init()

◆ initUserDef()

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

Init user definition

Returns
void

Definition at line 1221 of file QueryGenerator.php.

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

◆ JSbottom()

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

JavaScript bottom

Parameters
string$formname
Returns
string
Deprecated:
since TYPO3 CMS 7, will be removed in TYPO3 CMS 8

Definition at line 1621 of file QueryGenerator.php.

References TYPO3\CMS\Core\Database\QueryGenerator\$extJSCODE, and TYPO3\CMS\Core\Utility\GeneralUtility\logDeprecatedFunction().

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

◆ makeComparisonSelector()

TYPO3\CMS\Core\Database\QueryGenerator::makeComparisonSelector (   $subscript,
  $fieldName,
  $conf 
)
protected

◆ makeFieldList()

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

Make a list of fields for current table

Returns
string Separated list of fields

Definition at line 255 of file QueryGenerator.php.

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

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

◆ makeOptionList()

◆ makeSelectorTable()

◆ mkCompSelect()

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

Make comparison select

Parameters
string$name
string$comparison
int$neg
Returns
string

Definition at line 1184 of file QueryGenerator.php.

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

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

◆ mkFieldToInputSelect()

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

◆ mkOperatorSelect()

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

Make operator select

Parameters
string$name
string$op
bool$draw
bool$submit
Returns
string

Definition at line 1046 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 
)

◆ mkTypeSelect()

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

◆ printCodeArray()

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

Print code array

Parameters
array$codeArr
int$recursionLevel
Returns
string

Definition at line 997 of file QueryGenerator.php.

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

◆ procesData()

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

◆ setAndCleanUpExternalLists()

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

◆ setFormName()

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

Sets the current name of the input form.

Parameters
string$formNameThe name of the form.
Returns
void

Definition at line 1664 of file QueryGenerator.php.

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

◆ updateIcon()

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

◆ userDef()

TYPO3\CMS\Core\Database\QueryGenerator::userDef (   $fieldPrefix,
  $conf,
  $fieldName,
  $fieldType 
)

User definition

Parameters
string$fieldPrefix
array$conf
string$fieldName
string$fieldType
Returns
string

Definition at line 1235 of file QueryGenerator.php.

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

◆ userDefCleanUp()

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

User definition clean up

Parameters
array$queryConfig
Returns
array

Definition at line 1246 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 
)

Verify comparison

Parameters
string$comparison
int$neg
Returns
int

Definition at line 1110 of file QueryGenerator.php.

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

◆ verifyType()

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

Verify type

Parameters
string$fieldName
Returns
string

Definition at line 1089 of file QueryGenerator.php.

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

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

Member Data Documentation

◆ $comp_offsets

TYPO3\CMS\Core\Database\QueryGenerator::$comp_offsets
Initial value:
= [
'text' => 0

Definition at line 152 of file QueryGenerator.php.

◆ $compSQL

TYPO3\CMS\Core\Database\QueryGenerator::$compSQL
Initial value:
= [
'0' => '#FIELD# LIKE \'%#VALUE#%\''

Definition at line 94 of file QueryGenerator.php.

◆ $enablePrefix

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

Definition at line 217 of file QueryGenerator.php.

◆ $enableQueryParts

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

Definition at line 222 of file QueryGenerator.php.

◆ $extFieldLists

TYPO3\CMS\Core\Database\QueryGenerator::$extFieldLists = []

Definition at line 205 of file QueryGenerator.php.

◆ $extJSCODE

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

Definition at line 228 of file QueryGenerator.php.

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

◆ $fieldList

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

◆ $fieldName

◆ $fields

TYPO3\CMS\Core\Database\QueryGenerator::$fields = []

◆ $formName

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

◆ $lang

TYPO3\CMS\Core\Database\QueryGenerator::$lang
Initial value:
= [
'OR' => 'or'

Definition at line 32 of file QueryGenerator.php.

◆ $limitBegin

TYPO3\CMS\Core\Database\QueryGenerator::$limitBegin
protected

Definition at line 238 of file QueryGenerator.php.

◆ $limitLength

TYPO3\CMS\Core\Database\QueryGenerator::$limitLength
protected

◆ $name

◆ $noWrap

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

Definition at line 167 of file QueryGenerator.php.

◆ $queryConfig

◆ $table

◆ $tableArray

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

Definition at line 186 of file QueryGenerator.php.