Class QQ

Direct known subclasses

Located at includes/framework/QQuery.class.php

Methods summary
`public static`	# `All( )`
`public static`	# `None( )`
`public static`	# `OrCondition( )`
`public static`	# `AndCondition( )`
`public static`	# `Not( QQCondition $objCondition )`
`public static`	# `Equal( QQColumnNode $objQueryNode, $mixValue )`
`public static`	# `NotEqual( QQColumnNode $objQueryNode, $mixValue )`
`public static`	# `GreaterThan( QQColumnNode $objQueryNode, $mixValue )`
`public static`	# `GreaterOrEqual( QQColumnNode $objQueryNode, $mixValue )`
`public static`	# `LessThan( QQColumnNode $objQueryNode, $mixValue )`
`public static`	# `LessOrEqual( QQColumnNode $objQueryNode, $mixValue )`
`public static`	# `IsNull( QQColumnNode $objQueryNode )`
`public static`	# `IsNotNull( QQColumnNode $objQueryNode )`
`public static`	# `In( QQColumnNode $objQueryNode, $mixValuesArray )`
`public static`	# `NotIn( QQColumnNode $objQueryNode, $mixValuesArray )`
`public static`	# `Like( QQColumnNode $objQueryNode, $strValue )`
`public static`	# `NotLike( QQColumnNode $objQueryNode, $strValue )`
`public static`	# `Between( QQColumnNode $objQueryNode, $mixMinValue, $mixMaxValue )`
`public static`	# `NotBetween( QQColumnNode $objQueryNode, $strMinValue, $strMaxValue )`
`public static`	# `Exists( QQSubQuerySqlNode $objQueryNode )`
`public static`	# `NotExists( QQSubQuerySqlNode $objQueryNode )`
`public static QQCondition`	# `_( QQColumnNode $objQueryNode, $strSymbol, mixed\|null $mixValue = null, mixed\|null $mixValueTwo = null )` Parameters `$objQueryNode` `$strSymbol` `$mixValue` `$mixValueTwo` Returns `QQCondition` Throws Exception `QCallerException`
`public static QQSubQuerySqlNode`	# `SubSql( string $strSql, null\|QQNode[] $objParentQueryNodes = null )` Parameters `$strSql` Sql string. Use {1}, {2}, etc. to represent nodes inside of the sql string. `$objParentQueryNodes` Array of nodes to specify replacement value in the sql. Returns `QQSubQuerySqlNode`
`public static`	# `Virtual( $strName, QQSubQueryNode $objSubQueryDefinition = null )`
`public static mixed\|string`	# `GetVirtualAlias( $strName )` Converts a virtual attribute name to an alias used in the query. The name is converted to an identifier that will work on any SQL database. In the query itself, the name will have two underscores in front of the alias name to prevent conflicts with column names. Converts a virtual attribute name to an alias used in the query. The name is converted to an identifier that will work on any SQL database. In the query itself, the name will have two underscores in front of the alias name to prevent conflicts with column names. Parameters `$strName` Returns mixed\|string
`public static`	# `Clause( )`
`public static`	# `OrderBy( )`
`public static`	# `GroupBy( )`
`public static`	# `Having( QQSubQuerySqlNode $objNode )`
`public static`	# `Count( QQColumnNode $objNode, $strAttributeName )`
`public static`	# `Sum( QQColumnNode $objNode, $strAttributeName )`
`public static`	# `Minimum( QQColumnNode $objNode, $strAttributeName )`
`public static`	# `Maximum( QQColumnNode $objNode, $strAttributeName )`
`public static`	# `Average( QQColumnNode $objNode, $strAttributeName )`
`public static`	# `Expand( QQNode $objNode, QQCondition $objJoinCondition = null, QQSelect $objSelect = null )`
`public static`	# `ExpandAsArray( QQNode $objNode, $objCondition = null, QQSelect $objSelect = null )`
`public static`	# `Select( )`
`public static`	# `LimitInfo( $intMaxRowCount, $intOffset = 0 )`
`public static`	# `Distinct( )`
`public static QQSelect`	# `ExtractSelectClause( QQClause[]\|QQClause\|null $objClauses )` Searches for all the QQSelect clauses and merges them into one clause and returns that clause. Returns null if none found. Searches for all the QQSelect clauses and merges them into one clause and returns that clause. Returns null if none found. Parameters `$objClauses` QQClause object or array of QQClause objects Returns `QQSelect` QQSelect clause containing all the nodes from all the QQSelect clauses from $objClauses, or null if $objClauses contains no QQSelect clauses
`public static mixed`	# `Alias( QQNode $objNode, string $strAlias )` Returns the supplied node object, after setting its alias to the value supplied Returns the supplied node object, after setting its alias to the value supplied Parameters `$objNode` The node object to set alias on `$strAlias` The alias to set Returns mixed The same node that was passed in, but with the alias set
`public static`	# `NamedValue( $strName )`
`public static QQFunctionNode`	# `Func( $strName, QQNode\|mixed $param1 )` Apply an arbitrary scalar function using the given parameters. See below for functions that let you apply common SQL functions. The list below only includes sql operations that are generic to all supported versions of SQL. However, you can call Func directly with any named function that works in your current SQL version, knowing that it might not be cross platform compatible if you ever change SQL engines. Apply an arbitrary scalar function using the given parameters. See below for functions that let you apply common SQL functions. The list below only includes sql operations that are generic to all supported versions of SQL. However, you can call Func directly with any named function that works in your current SQL version, knowing that it might not be cross platform compatible if you ever change SQL engines. Parameters `$strName` function name, like ABS or POWER `$param1` The function parameter. Can be a qq node or a number. Returns `QQFunctionNode` The resulting wrapper node
`public static QQFunctionNode`	# `Abs( QQNode $param )` Return the absolute value Return the absolute value Parameters `$param` The qq node to apply the function to. Returns `QQFunctionNode` The resulting wrapper node
`public static QQFunctionNode`	# `Ceil( QQNode $param )` Return the smallest integer value not less than the argument Return the smallest integer value not less than the argument Parameters `$param` The qq node to apply the function to. Returns `QQFunctionNode` The resulting wrapper node
`public static QQFunctionNode`	# `Floor( QQNode $param )` Return the largest integer value not greater than the argument Return the largest integer value not greater than the argument Parameters `$param` The qq node to apply the function to. Returns `QQFunctionNode` The resulting wrapper node
`public static QQFunctionNode`	# `Mod( QQNode $dividend, $divider )` Return the remainder Return the remainder Parameters `$dividend` $param The qq node to apply the function to. `$divider` Returns `QQFunctionNode` The resulting wrapper node
`public static QQFunctionNode`	# `Power( QQNode $base, $exponent )` Return the argument raised to the specified power Return the argument raised to the specified power Parameters `$base` $param The qq node to apply the function to. `$exponent` Returns `QQFunctionNode` The resulting wrapper node
`public static QQFunctionNode`	# `Sqrt( QQNode $param )` Return the square root of the argument Return the square root of the argument Parameters `$param` The qq node to apply the function to. Returns `QQFunctionNode` The resulting wrapper node
`public static QQMathNode`	# `MathOp( $strOperation, QQNode\|mixed $param1 )` Apply an arbitrary math operation to 2 or more operands. Operands can be scalar values, or column nodes. Apply an arbitrary math operation to 2 or more operands. Operands can be scalar values, or column nodes. Parameters `$strOperation` operation symbol, like + or * `$param1` The first parameter Returns `QQMathNode` The resulting wrapper node
`public static QQMathNode`	# `Mul( QQNode\|mixed $op1, QQNode\|mixed $op2 )` The multiplication operation The multiplication operation Parameters `$op1` The first operand `$op2` The second operand Returns `QQMathNode` The resulting wrapper node
`public static QQMathNode`	# `Div( QQNode\|mixed $op1, QQNode\|mixed $op2 )` The division operation The division operation Parameters `$op1` The first operand `$op2` The second operand Returns `QQMathNode` The resulting wrapper node
`public static QQMathNode`	# `Sub( QQNode\|mixed $op1, QQNode\|mixed $op2 )` The subtraction operation The subtraction operation Parameters `$op1` The first operand `$op2` The second operand Returns `QQMathNode` The resulting wrapper node
`public static QQMathNode`	# `Add( QQNode\|mixed $op1, QQNode\|mixed $op2 )` The addition operation The addition operation Parameters `$op1` The first operand `$op2` The second operand Returns `QQMathNode` The resulting wrapper node
`public static QQMathNode`	# `Neg( QQNode\|mixed $op1 )` The negation unary operation The negation unary operation Parameters `$op1` The first operand Returns `QQMathNode` The resulting wrapper node

Packages

Classes

Interfaces

Traits

Exceptions

Functions

Class QQ

Direct known subclasses

Parameters

Returns

Throws

Parameters

Returns

Parameters

Returns

Parameters

Returns

Parameters

Returns

Parameters

Returns

Parameters

Returns

Parameters

Returns

Parameters

Returns

Parameters

Returns

Parameters

Returns

Parameters

Returns

Parameters

Returns

Parameters

Returns

Parameters

Returns

Parameters

Returns

Parameters

Returns

Parameters

Returns