buildSimpleCondition() public method Creates an SQL expressions like "column" operator value. public string buildSimpleCondition ( $operator, $operands, &$params )$operator string The operator to use. Anything could be used e.g. >, <=, etc. $operands array Contains two column names. $params array The binding parameters to be populated return string The generated SQL expression throws yii\base\InvalidParamException if wrong number of operands have been given.

buildSelect() public method public string buildSelect ( $columns, &$params, $distinct = false, $selectOption = null )$columns array $params array The binding parameters to be populated $distinct boolean $selectOption string return string The SELECT clause built from yii\db\Query::$select.

buildOrderByAndLimit() public method Builds the ORDER BY and LIMIT/OFFSET clauses and appends them to the given SQL. public string buildOrderByAndLimit ( $sql, $orderBy, $limit, $offset, &$params )$sql string The existing SQL (without ORDER BY/LIMIT/OFFSET) $orderBy array The order by columns. See yii\db\Query::orderBy() for more details on how to specify this parameter. $limit integer The limit number. See yii\db\Query::limit() for more details. $offset integer The offset numb

buildOrderBy() public method public string buildOrderBy ( $columns, &$params )$columns array $params array The binding parameters to be populated return string The ORDER BY clause built from yii\db\Query::$orderBy.

buildNotCondition() public method Inverts an SQL expressions with NOT operator. public string buildNotCondition ( $operator, $operands, &$params )$operator string The operator to use for connecting the given operands $operands array The SQL expressions to connect. $params array The binding parameters to be populated return string The generated SQL expression throws yii\base\InvalidParamException if wrong number of operands have been given.

buildLimit() public method public string buildLimit ( $limit, $offset )$limit integer $offset integer return string The LIMIT and OFFSET clauses

buildLikeCondition() public method Creates an SQL expressions with the LIKE operator. public string buildLikeCondition ( $operator, $operands, &$params )$operator string The operator to use (e.g. LIKE, NOT LIKE, OR LIKE or OR NOT LIKE) $operands array An array of two or three operands The first operand is the column name. The second operand is a single value or an array of values that column value should be compared with. If it is an empty array the generated expression will be a f

buildJoin() public method public string buildJoin ( $joins, &$params )$joins array $params array The binding parameters to be populated return string The JOIN clause built from yii\db\Query::$join. throws yii\db\Exception if the $joins parameter is not in proper format

buildInCondition() public method Creates an SQL expressions with the IN operator. public string buildInCondition ( $operator, $operands, &$params )$operator string The operator to use (e.g. IN or NOT IN) $operands array The first operand is the column name. If it is an array a composite IN condition will be generated. The second operand is an array of values that column value should be among. If it is an empty array the generated expression will be a false value if operator is IN a

buildHaving() public method public string buildHaving ( $condition, &$params )$condition string|array $params array The binding parameters to be populated return string The HAVING clause built from yii\db\Query::$having.