t3lib_queryGenerator Class Reference

Inheritance diagram for t3lib_queryGenerator:

[legend]List of all members.

Public Member Functions
	makeFieldList ()
	init ($name, $table, $fieldList="")
	setAndCleanUpExternalLists ($name, $list, $force="")
	procesData ($qC="")
	cleanUpQueryConfig ($queryConfig)
	getFormElements ($subLevel=0, $queryConfig="", $parent="")
	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")
	getSelectQuery ($qString="")
	JSbottom ($formname="forms[0]")
	makeFieldList ()
	init ($name, $table, $fieldList="")
	setAndCleanUpExternalLists ($name, $list, $force="")
	procesData ($qC="")
	cleanUpQueryConfig ($queryConfig)
	getFormElements ($subLevel=0, $queryConfig="", $parent="")
	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")
	getSelectQuery ($qString="")
	JSbottom ($formname="forms[0]")
Public Attributes
	$lang
	$compSQL
	$comp_offsets
	$noWrap = " nowrap"
	$name
	$table
	$fieldList
	$fields = array()
	$extFieldLists = array()
	$queryConfig = array()
	$enablePrefix = 0
	$enableQueryParts = 0
	$extJSCODE = ""

---

Detailed Description

Definition at line 95 of file class.t3lib_querygenerator.php.

---

Member Function Documentation

t3lib_queryGenerator::cleanInputVal (  $  conf, $  suffix = "" )

[Describe function...] Parameters: [type]  $conf: ... [type]  $suffix: ... Returns: [type] ... Definition at line 827 of file class.t3lib_querygenerator.php. References $conf, and t3lib_div::intExplode().

t3lib_queryGenerator::cleanInputVal (  $  conf, $  suffix = "" )

[Describe function...] Parameters: [type]  $conf: ... [type]  $suffix: ... Returns: [type] ... Definition at line 827 of file class.t3lib_querygenerator.php. References $conf, and t3lib_div::intExplode(). Referenced by cleanUpQueryConfig(), and getQuerySingle().

t3lib_queryGenerator::cleanUpQueryConfig (  $  queryConfig  )

[Describe function...] Parameters: [type]  $queryConfig: ... Returns: [type] ... Definition at line 411 of file class.t3lib_querygenerator.php. References $conf, $key, $queryConfig, cleanInputVal(), cleanUpQueryConfig(), userDefCleanUp(), verifyComparison(), and verifyType().

t3lib_queryGenerator::cleanUpQueryConfig (  $  queryConfig  )

[Describe function...] Parameters: [type]  $queryConfig: ... Returns: [type] ... Definition at line 411 of file class.t3lib_querygenerator.php. References $conf, $key, $queryConfig, cleanInputVal(), userDefCleanUp(), verifyComparison(), and verifyType(). Referenced by cleanUpQueryConfig(), and makeSelectorTable().

t3lib_queryGenerator::formatQ (  $  str  )

[Describe function...] Parameters: [type]  $str: ... Returns: [type] ... Definition at line 578 of file class.t3lib_querygenerator.php. References color, and size.

t3lib_queryGenerator::formatQ (  $  str  )

[Describe function...] Parameters: [type]  $str: ... Returns: [type] ... Definition at line 578 of file class.t3lib_querygenerator.php. References color, and size.

t3lib_queryGenerator::getFormElements (  $  subLevel = 0, $  queryConfig = "", $  parent = "" )

[Describe function...] Parameters: [type]  $subLevel: ... [type]  $queryConfig: ... [type]  $parent: ... Returns: [type] ... Definition at line 468 of file class.t3lib_querygenerator.php. References $conf, $key, $queryConfig, getFormElements(), getQuerySingle(), height, input, mkCompSelect(), mkOperatorSelect(), mkTypeSelect(), updateIcon(), userDef(), and value.

t3lib_queryGenerator::getFormElements (  $  subLevel = 0, $  queryConfig = "", $  parent = "" )

[Describe function...] Parameters: [type]  $subLevel: ... [type]  $queryConfig: ... [type]  $parent: ... Returns: [type] ... Definition at line 468 of file class.t3lib_querygenerator.php. References $conf, $key, $queryConfig, getQuerySingle(), height, input, mkCompSelect(), mkOperatorSelect(), mkTypeSelect(), updateIcon(), userDef(), and value. Referenced by getFormElements(), and makeSelectorTable().

t3lib_queryGenerator::getLabelCol (   )

[Describe function...] Returns: [type] ... Definition at line 863 of file class.t3lib_querygenerator.php. References $TCA, and table.

t3lib_queryGenerator::getLabelCol (   )

[Describe function...] Returns: [type] ... Definition at line 863 of file class.t3lib_querygenerator.php. References $TCA, and table.

t3lib_queryGenerator::getQuery (  $  queryConfig, $  pad = "" )

[Describe function...] Parameters: [type]  $queryConfig: ... [type]  $pad: ... Returns: [type] ... Definition at line 773 of file class.t3lib_querygenerator.php. References $conf.

t3lib_queryGenerator::getQuery (  $  queryConfig, $  pad = "" )

[Describe function...] Parameters: [type]  $queryConfig: ... [type]  $pad: ... Returns: [type] ... Definition at line 773 of file class.t3lib_querygenerator.php. References $conf. Referenced by getSelectQuery().

t3lib_queryGenerator::getQuerySingle (  $  conf, $  first )

[Describe function...] Parameters: [type]  $conf: ... [type]  $first: ... Returns: [type] ... Definition at line 803 of file class.t3lib_querygenerator.php. References $conf, cleanInputVal(), and table.

t3lib_queryGenerator::getQuerySingle (  $  conf, $  first )

[Describe function...] Parameters: [type]  $conf: ... [type]  $first: ... Returns: [type] ... Definition at line 803 of file class.t3lib_querygenerator.php. References $conf, cleanInputVal(), and table. Referenced by getFormElements().

t3lib_queryGenerator::getSelectQuery (  $  qString = ""  )

[Describe function...] Parameters: [type]  $qString: ... Returns: [type] ... Definition at line 979 of file class.t3lib_querygenerator.php. References $GLOBALS, $query, and getQuery().

t3lib_queryGenerator::getSelectQuery (  $  qString = ""  )

[Describe function...] Parameters: [type]  $qString: ... Returns: [type] ... Definition at line 979 of file class.t3lib_querygenerator.php. References $GLOBALS, $query, and getQuery().

t3lib_queryGenerator::getSubscript (  $  arr  )

[Describe function...] Parameters: [type]  $arr: ... Returns: [type] ... Definition at line 729 of file class.t3lib_querygenerator.php. References $key.

t3lib_queryGenerator::getSubscript (  $  arr  )

[Describe function...] Parameters: [type]  $arr: ... Returns: [type] ... Definition at line 729 of file class.t3lib_querygenerator.php. References $key. Referenced by procesData().

t3lib_queryGenerator::getUserDefQuery (  $  qcArr  )

[Describe function...] Parameters: [type]  $qcArr: ... Returns: [type] ... Definition at line 846 of file class.t3lib_querygenerator.php.

t3lib_queryGenerator::getUserDefQuery (  $  qcArr  )

[Describe function...] Parameters: [type]  $qcArr: ... Returns: [type] ... Definition at line 846 of file class.t3lib_querygenerator.php.

t3lib_queryGenerator::init (  $  name, $  table, $  fieldList = "" )

[Describe function...] Parameters: [type]  $name: ... [type]  $table: ... [type]  $fieldList: ... Returns: [type] ... Definition at line 203 of file class.t3lib_querygenerator.php. References $fieldList, $name, $table, $TCA, initUserDef(), t3lib_div::loadTCA(), makeFieldList(), table, and t3lib_div::trimExplode().

t3lib_queryGenerator::init (  $  name, $  table, $  fieldList = "" )

[Describe function...] Parameters: [type]  $name: ... [type]  $table: ... [type]  $fieldList: ... Returns: [type] ... Definition at line 203 of file class.t3lib_querygenerator.php. References $fieldList, $name, $table, $TCA, initUserDef(), t3lib_div::loadTCA(), makeFieldList(), table, and t3lib_div::trimExplode().

t3lib_queryGenerator::initUserDef (   )

[Describe function...] Returns: [type] ... Reimplemented in mailSelect. Definition at line 744 of file class.t3lib_querygenerator.php.

t3lib_queryGenerator::initUserDef (   )

[Describe function...] Returns: [type] ... Reimplemented in mailSelect. Definition at line 744 of file class.t3lib_querygenerator.php. Referenced by init().

t3lib_queryGenerator::JSbottom (  $  formname = "forms[0]"  )

[Describe function...] Parameters: [type]  $formname: ... Returns: [type] ... Definition at line 999 of file class.t3lib_querygenerator.php.

t3lib_queryGenerator::JSbottom (  $  formname = "forms[0]"  )

[Describe function...] Parameters: [type]  $formname: ... Returns: [type] ... Definition at line 999 of file class.t3lib_querygenerator.php. Referenced by makeSelectorTable().

t3lib_queryGenerator::makeFieldList (   )

Returns: [type] ... Definition at line 176 of file class.t3lib_querygenerator.php. References $TCA, t3lib_div::loadTCA(), and table.

t3lib_queryGenerator::makeFieldList (   )

Returns: [type] ... Definition at line 176 of file class.t3lib_querygenerator.php. References $TCA, t3lib_div::loadTCA(), and table. Referenced by init().

t3lib_queryGenerator::makeSelectorTable (  $  modSettings, $  enableList = "table,fields,query,group,order,limit" )

[Describe function...] Parameters: [type]  $modSettings: ... [type]  $enableList: ... Returns: [type] ... Definition at line 875 of file class.t3lib_querygenerator.php. References $parts, a, cleanUpQueryConfig(), colspan, getFormElements(), input, t3lib_div::intExplode(), JSbottom(), mkFieldToInputSelect(), mkTableSelect(), mkTypeSelect(), nowrap, printCodeArray(), procesData(), setAndCleanUpExternalLists(), table, td, updateIcon(), and value.

t3lib_queryGenerator::makeSelectorTable (  $  modSettings, $  enableList = "table,fields,query,group,order,limit" )

[Describe function...] Parameters: [type]  $modSettings: ... [type]  $enableList: ... Returns: [type] ... Definition at line 875 of file class.t3lib_querygenerator.php. References $parts, a, cleanUpQueryConfig(), colspan, getFormElements(), input, t3lib_div::intExplode(), JSbottom(), mkFieldToInputSelect(), mkTableSelect(), mkTypeSelect(), nowrap, printCodeArray(), procesData(), setAndCleanUpExternalLists(), table, td, updateIcon(), and value.

t3lib_queryGenerator::mkCompSelect (  $  name, $  comparison, $  neg )

[Describe function...] Parameters: [type]  $name: ... [type]  $comparison: ... [type]  $neg: ... Returns: [type] ... Definition at line 711 of file class.t3lib_querygenerator.php. References $i, lang, select, selected, and value.

t3lib_queryGenerator::mkCompSelect (  $  name, $  comparison, $  neg )

[Describe function...] Parameters: [type]  $name: ... [type]  $comparison: ... [type]  $neg: ... Returns: [type] ... Definition at line 711 of file class.t3lib_querygenerator.php. References $i, lang, select, selected, and value. Referenced by getFormElements().

t3lib_queryGenerator::mkFieldToInputSelect (  $  name, $  fieldName )

[Describe function...] Parameters: [type]  $name: ... [type]  $fieldName: ... Returns: [type] ... Definition at line 668 of file class.t3lib_querygenerator.php. References $key, a, height, img, input, select, selected, size, updateIcon(), and value.

t3lib_queryGenerator::mkFieldToInputSelect (  $  name, $  fieldName )

[Describe function...] Parameters: [type]  $name: ... [type]  $fieldName: ... Returns: [type] ... Definition at line 668 of file class.t3lib_querygenerator.php. References $key, a, height, img, input, select, selected, size, updateIcon(), and value. Referenced by makeSelectorTable().

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

[Describe function...] Parameters: [type]  $name: ... [type]  $op: ... [type]  $draw: ... [type]  $submit: ... Returns: [type] ... Definition at line 591 of file class.t3lib_querygenerator.php. References height, img, input, lang, select, selected, and value.

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

[Describe function...] Parameters: [type]  $name: ... [type]  $op: ... [type]  $draw: ... [type]  $submit: ... Returns: [type] ... Definition at line 591 of file class.t3lib_querygenerator.php. References height, img, input, lang, select, selected, and value. Referenced by getFormElements().

t3lib_queryGenerator::mkTableSelect (  $  name, $  cur )

[Describe function...] Parameters: [type]  $name: ... [type]  $cur: ... Returns: [type] ... Reimplemented in mailSelect. Definition at line 689 of file class.t3lib_querygenerator.php. References $GLOBALS, $TCA, select, selected, and value.

t3lib_queryGenerator::mkTableSelect (  $  name, $  cur )

[Describe function...] Parameters: [type]  $name: ... [type]  $cur: ... Returns: [type] ... Reimplemented in mailSelect. Definition at line 689 of file class.t3lib_querygenerator.php. References $GLOBALS, $TCA, select, selected, and value. Referenced by makeSelectorTable().

t3lib_queryGenerator::mkTypeSelect (  $  name, $  fieldName, $  prepend = "FIELD_" )

[Describe function...] Parameters: [type]  $name: ... [type]  $fieldName: ... [type]  $prepend: ... Returns: [type] ... Definition at line 613 of file class.t3lib_querygenerator.php. References $key, select, selected, and value.

t3lib_queryGenerator::mkTypeSelect (  $  name, $  fieldName, $  prepend = "FIELD_" )

[Describe function...] Parameters: [type]  $name: ... [type]  $fieldName: ... [type]  $prepend: ... Returns: [type] ... Definition at line 613 of file class.t3lib_querygenerator.php. References $key, select, selected, and value. Referenced by getFormElements(), makeSelectorTable(), and mailSelect::userDef().

t3lib_queryGenerator::printCodeArray (  $  codeArr, $  l = 0 )

[Describe function...] Parameters: [type]  $codeArr: ... [type]  $l: ... Returns: [type] ... Definition at line 555 of file class.t3lib_querygenerator.php. References height, img, t3lib_div::modifyHTMLColor(), printCodeArray(), table, and td.

t3lib_queryGenerator::printCodeArray (  $  codeArr, $  l = 0 )

[Describe function...] Parameters: [type]  $codeArr: ... [type]  $l: ... Returns: [type] ... Definition at line 555 of file class.t3lib_querygenerator.php. References height, img, t3lib_div::modifyHTMLColor(), table, and td. Referenced by makeSelectorTable(), and printCodeArray().

t3lib_queryGenerator::procesData (  $  qC = ""  )

[Describe function...] Parameters: [type]  $qC: ... Returns: [type] ... Definition at line 308 of file class.t3lib_querygenerator.php. References $i, $j, t3lib_div::_POST(), and getSubscript().

t3lib_queryGenerator::procesData (  $  qC = ""  )

[Describe function...] Parameters: [type]  $qC: ... Returns: [type] ... Definition at line 308 of file class.t3lib_querygenerator.php. References $i, $j, t3lib_div::_POST(), and getSubscript(). Referenced by makeSelectorTable().

t3lib_queryGenerator::setAndCleanUpExternalLists (  $  name, $  list, $  force = "" )

[Describe function...] Parameters: [type]  $name: ... [type]  $list: ... [type]  $force: ... Returns: [type] ... Definition at line 292 of file class.t3lib_querygenerator.php. References $fields, $name, and t3lib_div::trimExplode().

t3lib_queryGenerator::setAndCleanUpExternalLists (  $  name, $  list, $  force = "" )

[Describe function...] Parameters: [type]  $name: ... [type]  $list: ... [type]  $force: ... Returns: [type] ... Definition at line 292 of file class.t3lib_querygenerator.php. References $fields, $name, and t3lib_div::trimExplode(). Referenced by makeSelectorTable().

t3lib_queryGenerator::updateIcon (   )

[Describe function...] Returns: [type] ... Definition at line 854 of file class.t3lib_querygenerator.php. References height, and input.

t3lib_queryGenerator::updateIcon (   )

[Describe function...] Returns: [type] ... Definition at line 854 of file class.t3lib_querygenerator.php. References height, and input. Referenced by getFormElements(), makeSelectorTable(), and mkFieldToInputSelect().

t3lib_queryGenerator::userDef (   )

[Describe function...] Returns: [type] ... Definition at line 753 of file class.t3lib_querygenerator.php.

t3lib_queryGenerator::userDef (   )

[Describe function...] Returns: [type] ... Definition at line 753 of file class.t3lib_querygenerator.php. Referenced by getFormElements().

t3lib_queryGenerator::userDefCleanUp (  $  queryConfig  )

[Describe function...] Parameters: [type]  $queryConfig: ... Returns: [type] ... Definition at line 762 of file class.t3lib_querygenerator.php. References $queryConfig.

t3lib_queryGenerator::userDefCleanUp (  $  queryConfig  )

[Describe function...] Parameters: [type]  $queryConfig: ... Returns: [type] ... Definition at line 762 of file class.t3lib_querygenerator.php. References $queryConfig. Referenced by cleanUpQueryConfig().

t3lib_queryGenerator::verifyComparison (  $  comparison, $  neg )

[Describe function...] Parameters: [type]  $comparison: ... [type]  $neg: ... Returns: [type] ... Definition at line 649 of file class.t3lib_querygenerator.php. References $i.

t3lib_queryGenerator::verifyComparison (  $  comparison, $  neg )

[Describe function...] Parameters: [type]  $comparison: ... [type]  $neg: ... Returns: [type] ... Definition at line 649 of file class.t3lib_querygenerator.php. References $i. Referenced by cleanUpQueryConfig().

t3lib_queryGenerator::verifyType (  $  fieldName  )

[Describe function...] Parameters: [type]  $fieldName: ... Returns: [type] ... Definition at line 632 of file class.t3lib_querygenerator.php. References $key.

t3lib_queryGenerator::verifyType (  $  fieldName  )

[Describe function...] Parameters: [type]  $fieldName: ... Returns: [type] ... Definition at line 632 of file class.t3lib_querygenerator.php. References $key. Referenced by cleanUpQueryConfig().

---

Member Data Documentation

t3lib_queryGenerator::$comp_offsets

Initial value: array( "text" => 0, "number" => 1, "date" => 1 ) Definition at line 150 of file class.t3lib_querygenerator.php.

t3lib_queryGenerator::$compSQL

Initial value: array( // Type = text offset = 0 "0" => "#FIELD# LIKE '%#VALUE#%'", "1" => "#FIELD# NOT LIKE '%#VALUE#%'", "2" => "#FIELD# LIKE '#VALUE#%'", "3" => "#FIELD# NOT LIKE '#VALUE#%'", "4" => "#FIELD# LIKE '%#VALUE#'", "5" => "#FIELD# NOT LIKE '%#VALUE#'", "6" => "#FIELD# = '#VALUE#'", "7" => "#FIELD# != '#VALUE#'", // Type = date,number , offset = 32 "32" => "#FIELD# = '#VALUE#'", "33" => "#FIELD# != '#VALUE#'", "34" => "#FIELD# > #VALUE#", "35" => "#FIELD# < #VALUE#", "36" => "#FIELD# >= #VALUE# AND #FIELD# <= #VALUE1#", "37" => "NOT (#FIELD# >= #VALUE# AND #FIELD# <= #VALUE1#)", "38" => "#FIELD# IN (#VALUE#)", "39" => "#FIELD# NOT IN (#VALUE#)", "40" => "(#FIELD# & #VALUE#)=#VALUE#", "41" => "(#FIELD# & #VALUE#)!=#VALUE#", "42" => "(#FIELD# | #VALUE#)=#VALUE#", "43" => "(#FIELD# | #VALUE#)!=#VALUE#" ) Definition at line 125 of file class.t3lib_querygenerator.php.

t3lib_queryGenerator::$enablePrefix = 0

Definition at line 163 of file class.t3lib_querygenerator.php.

t3lib_queryGenerator::$enableQueryParts = 0

Definition at line 164 of file class.t3lib_querygenerator.php.

t3lib_queryGenerator::$extFieldLists = array()

Definition at line 161 of file class.t3lib_querygenerator.php.

t3lib_queryGenerator::$extJSCODE = ""

Definition at line 165 of file class.t3lib_querygenerator.php.

t3lib_queryGenerator::$fieldList

Definition at line 159 of file class.t3lib_querygenerator.php. Referenced by init().

t3lib_queryGenerator::$fields = array()

Definition at line 160 of file class.t3lib_querygenerator.php. Referenced by setAndCleanUpExternalLists().

t3lib_queryGenerator::$lang

Initial value: array( "OR" => "or", "AND" => "and", "comparison" => array( // Type = text offset = 0 "0_" => "contains", "1_" => "does not contain", "2_" => "starts with", "3_" => "does not start with", "4_" => "ends with", "5_" => "does not end with", "6_" => "equals", "7_" => "does not equal", // Type = date,number , offset = 32 "32_" => "equals", "33_" => "does not equal", "34_" => "is greater than", "35_" => "is less than", "36_" => "is between", "37_" => "is not between", "38_" => "is in list", "39_" => "is not in list", "40_" => "binary AND equals", "41_" => "binary AND does not equal", "42_" => "binary OR equals", "43_" => "binary OR does not equal" ) ) Definition at line 96 of file class.t3lib_querygenerator.php.

t3lib_queryGenerator::$name

Definition at line 157 of file class.t3lib_querygenerator.php. Referenced by init(), and setAndCleanUpExternalLists().

t3lib_queryGenerator::$noWrap = " nowrap"

Definition at line 155 of file class.t3lib_querygenerator.php.

t3lib_queryGenerator::$queryConfig = array()

Definition at line 162 of file class.t3lib_querygenerator.php. Referenced by cleanUpQueryConfig(), getFormElements(), and userDefCleanUp().

t3lib_queryGenerator::$table

Definition at line 158 of file class.t3lib_querygenerator.php. Referenced by init().

---

The documentation for this class was generated from the following files:

• t3lib/class.t3lib_querygenerator.php
• typo3/t3lib/class.t3lib_querygenerator.php

---