Documentation TYPO3 par Ameos

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 824 of file class.t3lib_querygenerator.php.

References t3lib_div::intExplode().

t3lib_queryGenerator::cleanInputVal conf,
suffix = ""
 

[Describe function...]

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

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

References t3lib_div::intExplode().

t3lib_queryGenerator::cleanUpQueryConfig queryConfig  ) 
 

[Describe function...]

Parameters:
[type] $queryConfig: ...
Returns:
[type] ...

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

t3lib_queryGenerator::cleanUpQueryConfig queryConfig  ) 
 

[Describe function...]

Parameters:
[type] $queryConfig: ...
Returns:
[type] ...

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

t3lib_queryGenerator::formatQ str  ) 
 

[Describe function...]

Parameters:
[type] $str: ...
Returns:
[type] ...

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

t3lib_queryGenerator::formatQ str  ) 
 

[Describe function...]

Parameters:
[type] $str: ...
Returns:
[type] ...

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

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.

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.

t3lib_queryGenerator::getLabelCol  ) 
 

[Describe function...]

Returns:
[type] ...

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

t3lib_queryGenerator::getLabelCol  ) 
 

[Describe function...]

Returns:
[type] ...

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

t3lib_queryGenerator::getQuery queryConfig,
pad = ""
 

[Describe function...]

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

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

t3lib_queryGenerator::getQuery queryConfig,
pad = ""
 

[Describe function...]

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

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

t3lib_queryGenerator::getQuerySingle conf,
first
 

[Describe function...]

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

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

t3lib_queryGenerator::getQuerySingle conf,
first
 

[Describe function...]

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

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

t3lib_queryGenerator::getSelectQuery qString = ""  ) 
 

[Describe function...]

Parameters:
[type] $qString: ...
Returns:
[type] ...

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

References t3lib_BEfunc::deleteClause().

t3lib_queryGenerator::getSelectQuery qString = ""  ) 
 

[Describe function...]

Parameters:
[type] $qString: ...
Returns:
[type] ...

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

References t3lib_BEfunc::deleteClause().

t3lib_queryGenerator::getSubscript arr  ) 
 

[Describe function...]

Parameters:
[type] $arr: ...
Returns:
[type] ...

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

t3lib_queryGenerator::getSubscript arr  ) 
 

[Describe function...]

Parameters:
[type] $arr: ...
Returns:
[type] ...

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

Referenced by procesData().

t3lib_queryGenerator::getUserDefQuery qcArr  ) 
 

[Describe function...]

Parameters:
[type] $qcArr: ...
Returns:
[type] ...

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

t3lib_queryGenerator::getUserDefQuery qcArr  ) 
 

[Describe function...]

Parameters:
[type] $qcArr: ...
Returns:
[type] ...

Definition at line 843 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, initUserDef(), t3lib_div::loadTCA(), makeFieldList(), 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, initUserDef(), t3lib_div::loadTCA(), makeFieldList(), 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 996 of file class.t3lib_querygenerator.php.

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

[Describe function...]

Parameters:
[type] $formname: ...
Returns:
[type] ...

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

t3lib_queryGenerator::makeFieldList  ) 
 

Returns:
[type] ...

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

References t3lib_div::loadTCA().

t3lib_queryGenerator::makeFieldList  ) 
 

Returns:
[type] ...

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

References t3lib_div::loadTCA().

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 872 of file class.t3lib_querygenerator.php.

References t3lib_div::intExplode().

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

[Describe function...]

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

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

References t3lib_div::intExplode().

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.

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.

t3lib_queryGenerator::mkFieldToInputSelect name,
fieldName
 

[Describe function...]

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

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

t3lib_queryGenerator::mkFieldToInputSelect name,
fieldName
 

[Describe function...]

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

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

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.

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.

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.

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.

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.

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.

Referenced by 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 t3lib_div::modifyHTMLColor().

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 t3lib_div::modifyHTMLColor().

t3lib_queryGenerator::procesData qC = ""  ) 
 

[Describe function...]

Parameters:
[type] $qC: ...
Returns:
[type] ...

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

References 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 t3lib_div::_POST(), and getSubscript().

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().

t3lib_queryGenerator::updateIcon  ) 
 

[Describe function...]

Returns:
[type] ...

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

t3lib_queryGenerator::updateIcon  ) 
 

[Describe function...]

Returns:
[type] ...

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

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.

t3lib_queryGenerator::userDefCleanUp queryConfig  ) 
 

[Describe function...]

Parameters:
[type] $queryConfig: ...
Returns:
[type] ...

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

t3lib_queryGenerator::userDefCleanUp queryConfig  ) 
 

[Describe function...]

Parameters:
[type] $queryConfig: ...
Returns:
[type] ...

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

t3lib_queryGenerator::verifyComparison comparison,
neg
 

[Describe function...]

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

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

t3lib_queryGenerator::verifyComparison comparison,
neg
 

[Describe function...]

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

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

t3lib_queryGenerator::verifyType fieldName  ) 
 

[Describe function...]

Parameters:
[type] $fieldName: ...
Returns:
[type] ...

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

t3lib_queryGenerator::verifyType fieldName  ) 
 

[Describe function...]

Parameters:
[type] $fieldName: ...
Returns:
[type] ...

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


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::$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.


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


Généré par Les spécialistes TYPO3 avec  doxygen 1.4.6