Class QQueryBuilder

QQueryBuilder class

QBaseClass

QQueryBuilder

Direct known subclasses

Located at includes/framework/QQuery.class.php

Methods summary
`public`	# `__construct( QDatabaseBase $objDatabase, string $strRootTableName )` Parameters `$objDatabase` `$strRootTableName`
`public`	# `AddSelectItem( string $strTableName, string $strColumnName, string $strFullAlias )` Parameters `$strTableName` `$strColumnName` `$strFullAlias`
`public`	# `AddSelectFunction( string $strFunctionName, string $strColumnName, string $strFullAlias )` Parameters `$strFunctionName` `$strColumnName` `$strFullAlias`
`public`	# `AddFromItem( string $strTableName )` Parameters `$strTableName`
`public string`	# `GetTableAlias( string $strTableName )` Parameters `$strTableName` Returns string
`public`	# `AddJoinItem( string $strJoinTableName, string $strJoinTableAlias, string $strTableName, string $strColumnName, string $strLinkedColumnName, QQCondition $objJoinCondition = null )` Parameters `$strJoinTableName` `$strJoinTableAlias` `$strTableName` `$strColumnName` `$strLinkedColumnName` `$objJoinCondition` Throws Exception `QCallerException`
`public`	# `AddJoinCustomItem( string $strJoinTableName, string $strJoinTableAlias, QQCondition $objJoinCondition )` Parameters `$strJoinTableName` `$strJoinTableAlias` `$objJoinCondition` Throws Exception `QCallerException`
`public`	# `AddJoinCustomSqlItem( string $strSql )` Parameters `$strSql`
`public`	# `AddWhereItem( string $strItem )` Parameters `$strItem`
`public`	# `AddOrderByItem( string $strItem )` Parameters `$strItem`
`public`	# `AddGroupByItem( string $strItem )` Parameters `$strItem`
`public`	# `AddHavingItem( string $strItem )` Parameters `$strItem`
`public`	# `SetLimitInfo( $strLimitInfo )` Parameters `$strLimitInfo`
`public`	# `SetDistinctFlag( )`
`public`	# `SetCountOnlyFlag( )`
`public`	# `SetVirtualNode( string $strName, QQColumnNode $objNode )` Parameters `$strName` `$objNode`
`public QQColumnNode`	# `GetVirtualNode( string $strName )` Parameters `$strName` Returns `QQColumnNode` Throws `QCallerException`
`public`	# `AddExpandAsArrayNode( QQNode $objNode )` Parameters `$objNode` Throws `QCallerException`
`public string`	# `GetStatement( )` Returns string
`public`	# `SetOrderByClause( QQOrderBy $objOrderByClause )` Sets the one order by clause allowed in a query. Stores it for delayed processing. Sets the one order by clause allowed in a query. Stores it for delayed processing. Parameters `$objOrderByClause`
`protected`	# `ProcessClauses( )` Final processing of delayed clauses. Clauses like OrderBy need to wait to be processed until the complete set of aliases is known. Final processing of delayed clauses. Clauses like OrderBy need to wait to be processed until the complete set of aliases is known.
`public mixed`	# `__get( string $strName )` Override method to perform a property "Get" This will get the value of $strName All inhereted objects that call __get() should always fall through to calling parent::__get() in a try/catch statement catching for CallerExceptions. Override method to perform a property "Get" This will get the value of $strName All inhereted objects that call __get() should always fall through to calling parent::__get() in a try/catch statement catching for CallerExceptions. Parameters `$strName` Name of the property to get Returns mixed the returned property Throws `QUndefinedPropertyException` Overrides `QBaseClass::__get()`

Methods inherited from QBaseClass
`OverrideAttributes(), __call(), __set()`

Properties summary
`protected string[]`	`$strSelectArray`	#
`protected string[]`	`$strColumnAliasArray`	#
`protected integer`	`$intColumnAliasCount`	# `0`
`protected string[]`	`$strTableAliasArray`	#
`protected integer`	`$intTableAliasCount`	# `0`
`protected string[]`	`$strFromArray`	#
`protected string[]`	`$strJoinArray`	#
`protected string[]`	`$strJoinConditionArray`	#
`protected string[]`	`$strWhereArray`	#
`protected string[]`	`$strOrderByArray`	#
`protected string[]`	`$strGroupByArray`	#
`protected string[]`	`$strHavingArray`	#
`protected QQVirtualNode[]`	`$objVirtualNodeArray`	#
`protected string`	`$strLimitInfo`	#
`protected boolean`	`$blnDistinctFlag`	#
`protected QQNode`	`$objExpandAsArrayNode`	#
`protected boolean`	`$blnCountOnlyFlag`	#
`protected QDatabaseBase`	`$objDatabase`	#
`protected string`	`$strRootTableName`	#
`protected string`	`$strEscapeIdentifierBegin`	#
`protected string`	`$strEscapeIdentifierEnd`	#
`protected QQOrderBy`	`$objOrderByClause`	#

Magic properties summary
`public QDatabaseBase`	`$Database`
`public string`	`$RootTableName`
`public QQNode`	`$ExpandAsArrayNode`

Packages

Classes

Interfaces

Traits

Exceptions

Functions

Class QQueryBuilder

Direct known subclasses

Parameters

Parameters

Parameters

Parameters

Parameters

Returns

Parameters

Throws

Parameters

Throws

Parameters

Parameters

Parameters

Parameters

Parameters

Parameters

Parameters

Parameters

Returns

Throws

Parameters

Throws

Returns

Parameters

Parameters

Returns

Throws

Overrides