t3lib_queryGenerator Class Reference

Inheritance diagram for t3lib_queryGenerator:

Inheritance graph
[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