PHP Class QQueryBuilder, qcodo

Inheritance: extends QBaseClass

Show file Open project: qcodo/qcodo Class Usage Examples

Protected Properties

Property	Type	Description
$blnCountOnlyFlag
$blnDistinctFlag
$intColumnAliasCount
$intTableAliasCount
$objDatabase
$objVirtualNodeArray
$strColumnAliasArray
$strCustomFromArray
$strEscapeIdentifierBegin
$strEscapeIdentifierEnd
$strExpandAsArrayNodes
$strFromArray
$strGroupByArray
$strJoinArray
$strJoinConditionArray
$strLimitInfo
$strOrderByArray
$strRootTableName
$strSelectArray
$strTableAliasArray
$strWhereArray

Public Methods

Method	Description
AddExpandAsArrayNode ( $objNode )
AddFromItem ( $strTableName, $strAliasOverride = null )
AddGroupByItem ( $strItem )
AddJoinCustomItem ( $strJoinTableName, $strJoinTableAlias, QQCondition $objJoinCondition )
AddJoinCustomSqlItem ( $strSql )
AddJoinItem ( $strJoinTableName, $strJoinTableAlias, $strTableName, $strColumnName, $strLinkedColumnName, QQCondition $objJoinCondition = null )
AddOrderByItem ( $strItem )
AddSelectFunction ( $strFunctionName, $strColumnName, $strFullAlias )
AddSelectItem ( $strTableName, $strColumnName, $strFullAlias )
AddWhereItem ( $strItem )
GetStatement ( )
GetTableAlias ( $strTableName )
GetVirtualNode ( $strName )
SetCountOnlyFlag ( )
SetDistinctFlag ( )
SetLimitInfo ( $strLimitInfo )
SetVirtualNode ( $strName, QQSubQueryNode $objNode )
__construct ( QDatabaseBase $objDatabase, $strRootTableName )
__get ( $strName )

Method Details

AddExpandAsArrayNode() public method

public AddExpandAsArrayNode ( $objNode )

AddFromItem() public method

public AddFromItem ( $strTableName, $strAliasOverride = null )

AddGroupByItem() public method

public AddGroupByItem ( $strItem )

AddJoinCustomItem() public method

public AddJoinCustomItem ( $strJoinTableName, $strJoinTableAlias, QQCondition $objJoinCondition )
$objJoinCondition	QQCondition

AddJoinCustomSqlItem() public method

public AddJoinCustomSqlItem ( $strSql )

AddJoinItem() public method

public AddJoinItem ( $strJoinTableName, $strJoinTableAlias, $strTableName, $strColumnName, $strLinkedColumnName, QQCondition $objJoinCondition = null )
$objJoinCondition	QQCondition

AddOrderByItem() public method

public AddOrderByItem ( $strItem )

AddSelectFunction() public method

public AddSelectFunction ( $strFunctionName, $strColumnName, $strFullAlias )

AddSelectItem() public method

public AddSelectItem ( $strTableName, $strColumnName, $strFullAlias )

AddWhereItem() public method

public AddWhereItem ( $strItem )

GetStatement() public method

public GetStatement ( )

GetTableAlias() public method

public GetTableAlias ( $strTableName )

GetVirtualNode() public method

public GetVirtualNode ( $strName )

SetCountOnlyFlag() public method

public SetCountOnlyFlag ( )

SetDistinctFlag() public method

public SetDistinctFlag ( )

SetLimitInfo() public method

public SetLimitInfo ( $strLimitInfo )

SetVirtualNode() public method

public SetVirtualNode ( $strName, QQSubQueryNode $objNode )
$objNode	QQSubQueryNode

__construct() public method

public __construct ( QDatabaseBase $objDatabase, $strRootTableName )
$objDatabase	QDatabaseBase

__get() public method

public __get ( $strName )

Property Details

$blnCountOnlyFlag protected property

protected $blnCountOnlyFlag

$blnDistinctFlag protected property

protected $blnDistinctFlag

$intColumnAliasCount protected property

protected $intColumnAliasCount

$intTableAliasCount protected property

protected $intTableAliasCount

$objDatabase protected property

protected $objDatabase

$objVirtualNodeArray protected property

protected $objVirtualNodeArray

$strColumnAliasArray protected property

protected $strColumnAliasArray

$strCustomFromArray protected property

protected $strCustomFromArray

$strEscapeIdentifierBegin protected property

protected $strEscapeIdentifierBegin

$strEscapeIdentifierEnd protected property

protected $strEscapeIdentifierEnd

$strExpandAsArrayNodes protected property

protected $strExpandAsArrayNodes

$strFromArray protected property

protected $strFromArray

$strGroupByArray protected property

protected $strGroupByArray

$strJoinArray protected property

protected $strJoinArray

$strJoinConditionArray protected property

protected $strJoinConditionArray

$strLimitInfo protected property

protected $strLimitInfo

$strOrderByArray protected property

protected $strOrderByArray

$strRootTableName protected property

protected $strRootTableName

$strSelectArray protected property

protected $strSelectArray

$strTableAliasArray protected property

protected $strTableAliasArray

$strWhereArray protected property

protected $strWhereArray