Aplus Framework Docs
Having
Trait Having.
Table of Contents
- having() : static
- Appends an "AND $column $operator ...$values" condition in the HAVING clause.
- havingBetween() : static
- Appends an "AND $column BETWEEN $min AND $max" condition in the HAVING clause.
- havingEqual() : static
- Appends an "AND $column = $value" condition in the HAVING clause.
- havingGreaterThan() : static
- Appends an "AND $column > $value" condition in the HAVING clause.
- havingGreaterThanOrEqual() : static
- Appends an "AND $column >= $value" condition in the HAVING clause.
- havingIn() : static
- Appends an "AND $column IN (...$values)" condition in the HAVING clause.
- havingIsNotNull() : static
- Appends an "AND $column IS NOT NULL" condition in the HAVING clause.
- havingIsNull() : static
- Appends an "AND $column IS NULL" condition in the HAVING clause.
- havingLessThan() : static
- Appends an "AND $column < $value" condition in the HAVING clause.
- havingLessThanOrEqual() : static
- Appends an "AND $column <= $value" condition in the HAVING clause.
- havingLike() : static
- Appends an "AND $column LIKE $value" condition in the HAVING clause.
- havingNotBetween() : static
- Appends an "AND $column NOT BETWEEN $min AND $max" condition in the HAVING clause.
- havingNotEqual() : static
- Appends an "AND $column != $value" condition in the HAVING clause.
- havingNotIn() : static
- Appends an "AND $column NOT IN (...$values)" condition in the HAVING clause.
- havingNotLike() : static
- Appends an "AND $column NOT LIKE" $value condition.
- havingNullSafeEqual() : static
- Appends an "AND $column <=> $value" condition in the HAVING clause.
- orHaving() : static
- Appends a "OR $column $operator ...$values" condition in the HAVING clause.
- orHavingBetween() : static
- Appends a "OR $column BETWEEN $min AND $max" condition in the HAVING clause.
- orHavingEqual() : static
- Appends a "OR $column = $value" condition in the HAVING clause.
- orHavingGreaterThan() : static
- Appends a "OR $column > $value" condition in the HAVING clause.
- orHavingGreaterThanOrEqual() : static
- Appends a "OR $column >= $value" condition in the HAVING clause.
- orHavingIn() : static
- Appends a "OR $column IN (...$values)" condition in the HAVING clause.
- orHavingIsNotNull() : static
- Appends a "OR $column IS NOT NULL" condition in the HAVING clause.
- orHavingIsNull() : static
- Appends a "OR $column IS NULL" condition in the HAVING clause.
- orHavingLessThan() : static
- Appends a "OR $column < $value" condition in the HAVING clause.
- orHavingLessThanOrEqual() : static
- Appends a "OR $column <= $value" condition in the HAVING clause.
- orHavingLike() : static
- Appends a "OR $column LIKE $value" condition in the HAVING clause.
- orHavingNotBetween() : static
- Appends a "OR $column NOT BETWEEN $min AND $max" condition in the HAVING clause.
- orHavingNotEqual() : static
- Appends a "OR $column != $value" condition in the HAVING clause.
- orHavingNotIn() : static
- Appends a "OR $column NOT IN (...$values)" condition in the HAVING clause.
- orHavingNotLike() : static
- Appends a "OR $column NOT LIKE $value" condition in the HAVING clause.
- orHavingNullSafeEqual() : static
- Appends a "OR $column <=> $value" condition in the HAVING clause.
- renderHaving() : string|null
- Renders the full HAVING clause.
Methods
having()
Appends an "AND $column $operator ...$values" condition in the HAVING clause.
public
having(Closure|string $column, string $operator, Closure|float|int|string|null ...$values) : static
Parameters
- $column : Closure|string
-
Closure for a subquery or a string with the column name
- $operator : string
- $values : Closure|float|int|string|null
Return values
static —havingBetween()
Appends an "AND $column BETWEEN $min AND $max" condition in the HAVING clause.
public
havingBetween(Closure|string $column, Closure|float|int|string|null $min, Closure|float|int|string|null $max) : static
Parameters
- $column : Closure|string
-
Closure for a subquery or a string with the column name
- $min : Closure|float|int|string|null
- $max : Closure|float|int|string|null
Tags
Return values
static —havingEqual()
Appends an "AND $column = $value" condition in the HAVING clause.
public
havingEqual(Closure|string $column, Closure|float|int|string|null $value) : static
Parameters
- $column : Closure|string
-
Closure for a subquery or a string with the column name
- $value : Closure|float|int|string|null
Tags
Return values
static —havingGreaterThan()
Appends an "AND $column > $value" condition in the HAVING clause.
public
havingGreaterThan(Closure|string $column, Closure|float|int|string|null $value) : static
Parameters
- $column : Closure|string
-
Closure for a subquery or a string with the column name
- $value : Closure|float|int|string|null
Tags
Return values
static —havingGreaterThanOrEqual()
Appends an "AND $column >= $value" condition in the HAVING clause.
public
havingGreaterThanOrEqual(Closure|string $column, Closure|float|int|string|null $value) : static
Parameters
- $column : Closure|string
-
Closure for a subquery or a string with the column name
- $value : Closure|float|int|string|null
Tags
Return values
static —havingIn()
Appends an "AND $column IN (...$values)" condition in the HAVING clause.
public
havingIn(Closure|string $column, Closure|float|int|string|null $value, Closure|float|int|string|null ...$values) : static
Parameters
- $column : Closure|string
-
Closure for a subquery or a string with the column name
- $value : Closure|float|int|string|null
- $values : Closure|float|int|string|null
Tags
Return values
static —havingIsNotNull()
Appends an "AND $column IS NOT NULL" condition in the HAVING clause.
public
havingIsNotNull(Closure|string $column) : static
Parameters
- $column : Closure|string
-
Closure for a subquery or a string with the column name
Tags
Return values
static —havingIsNull()
Appends an "AND $column IS NULL" condition in the HAVING clause.
public
havingIsNull(Closure|string $column) : static
Parameters
- $column : Closure|string
-
Closure for a subquery or a string with the column name
Tags
Return values
static —havingLessThan()
Appends an "AND $column < $value" condition in the HAVING clause.
public
havingLessThan(Closure|string $column, Closure|float|int|string|null $value) : static
Parameters
- $column : Closure|string
-
Closure for a subquery or a string with the column name
- $value : Closure|float|int|string|null
Tags
Return values
static —havingLessThanOrEqual()
Appends an "AND $column <= $value" condition in the HAVING clause.
public
havingLessThanOrEqual(Closure|string $column, Closure|float|int|string|null $value) : static
Parameters
- $column : Closure|string
-
Closure for a subquery or a string with the column name
- $value : Closure|float|int|string|null
Tags
Return values
static —havingLike()
Appends an "AND $column LIKE $value" condition in the HAVING clause.
public
havingLike(Closure|string $column, Closure|float|int|string|null $value) : static
Parameters
- $column : Closure|string
-
Closure for a subquery or a string with the column name
- $value : Closure|float|int|string|null
Tags
Return values
static —havingNotBetween()
Appends an "AND $column NOT BETWEEN $min AND $max" condition in the HAVING clause.
public
havingNotBetween(Closure|string $column, Closure|float|int|string|null $min, Closure|float|int|string|null $max) : static
Parameters
- $column : Closure|string
-
Closure for a subquery or a string with the column name
- $min : Closure|float|int|string|null
- $max : Closure|float|int|string|null
Tags
Return values
static —havingNotEqual()
Appends an "AND $column != $value" condition in the HAVING clause.
public
havingNotEqual(Closure|string $column, Closure|float|int|string|null $value) : static
Parameters
- $column : Closure|string
-
Closure for a subquery or a string with the column name
- $value : Closure|float|int|string|null
Tags
Return values
static —havingNotIn()
Appends an "AND $column NOT IN (...$values)" condition in the HAVING clause.
public
havingNotIn(Closure|string $column, Closure|float|int|string|null $value, Closure|float|int|string|null ...$values) : static
Parameters
- $column : Closure|string
-
Closure for a subquery or a string with the column name
- $value : Closure|float|int|string|null
- $values : Closure|float|int|string|null
Tags
Return values
static —havingNotLike()
Appends an "AND $column NOT LIKE" $value condition.
public
havingNotLike(Closure|string $column, Closure|float|int|string|null $value) : static
Parameters
- $column : Closure|string
-
Closure for a subquery or a string with the column name
- $value : Closure|float|int|string|null
Tags
Return values
static —havingNullSafeEqual()
Appends an "AND $column <=> $value" condition in the HAVING clause.
public
havingNullSafeEqual(Closure|string $column, Closure|float|int|string|null $value) : static
Parameters
- $column : Closure|string
-
Closure for a subquery or a string with the column name
- $value : Closure|float|int|string|null
Tags
Return values
static —orHaving()
Appends a "OR $column $operator ...$values" condition in the HAVING clause.
public
orHaving(Closure|string $column, string $operator, Closure|float|int|string|null ...$values) : static
Parameters
- $column : Closure|string
-
Closure for a subquery or a string with the column name
- $operator : string
- $values : Closure|float|int|string|null
Return values
static —orHavingBetween()
Appends a "OR $column BETWEEN $min AND $max" condition in the HAVING clause.
public
orHavingBetween(Closure|string $column, Closure|float|int|string|null $min, Closure|float|int|string|null $max) : static
Parameters
- $column : Closure|string
-
Closure for a subquery or a string with the column name
- $min : Closure|float|int|string|null
- $max : Closure|float|int|string|null
Tags
Return values
static —orHavingEqual()
Appends a "OR $column = $value" condition in the HAVING clause.
public
orHavingEqual(Closure|string $column, Closure|float|int|string|null $value) : static
Parameters
- $column : Closure|string
-
Closure for a subquery or a string with the column name
- $value : Closure|float|int|string|null
Tags
Return values
static —orHavingGreaterThan()
Appends a "OR $column > $value" condition in the HAVING clause.
public
orHavingGreaterThan(Closure|string $column, Closure|float|int|string|null $value) : static
Parameters
- $column : Closure|string
-
Closure for a subquery or a string with the column name
- $value : Closure|float|int|string|null
Tags
Return values
static —orHavingGreaterThanOrEqual()
Appends a "OR $column >= $value" condition in the HAVING clause.
public
orHavingGreaterThanOrEqual(Closure|string $column, Closure|float|int|string|null $value) : static
Parameters
- $column : Closure|string
-
Closure for a subquery or a string with the column name
- $value : Closure|float|int|string|null
Tags
Return values
static —orHavingIn()
Appends a "OR $column IN (...$values)" condition in the HAVING clause.
public
orHavingIn(Closure|string $column, Closure|float|int|string|null $value, Closure|float|int|string|null ...$values) : static
Parameters
- $column : Closure|string
-
Closure for a subquery or a string with the column name
- $value : Closure|float|int|string|null
- $values : Closure|float|int|string|null
Tags
Return values
static —orHavingIsNotNull()
Appends a "OR $column IS NOT NULL" condition in the HAVING clause.
public
orHavingIsNotNull(Closure|string $column) : static
Parameters
- $column : Closure|string
-
Closure for a subquery or a string with the column name
Tags
Return values
static —orHavingIsNull()
Appends a "OR $column IS NULL" condition in the HAVING clause.
public
orHavingIsNull(Closure|string $column) : static
Parameters
- $column : Closure|string
-
Closure for a subquery or a string with the column name
Tags
Return values
static —orHavingLessThan()
Appends a "OR $column < $value" condition in the HAVING clause.
public
orHavingLessThan(Closure|string $column, Closure|float|int|string|null $value) : static
Parameters
- $column : Closure|string
-
Closure for a subquery or a string with the column name
- $value : Closure|float|int|string|null
Tags
Return values
static —orHavingLessThanOrEqual()
Appends a "OR $column <= $value" condition in the HAVING clause.
public
orHavingLessThanOrEqual(Closure|string $column, Closure|float|int|string|null $value) : static
Parameters
- $column : Closure|string
-
Closure for a subquery or a string with the column name
- $value : Closure|float|int|string|null
Tags
Return values
static —orHavingLike()
Appends a "OR $column LIKE $value" condition in the HAVING clause.
public
orHavingLike(Closure|string $column, Closure|float|int|string|null $value) : static
Parameters
- $column : Closure|string
-
Closure for a subquery or a string with the column name
- $value : Closure|float|int|string|null
Tags
Return values
static —orHavingNotBetween()
Appends a "OR $column NOT BETWEEN $min AND $max" condition in the HAVING clause.
public
orHavingNotBetween(Closure|string $column, Closure|float|int|string|null $min, Closure|float|int|string|null $max) : static
Parameters
- $column : Closure|string
-
Closure for a subquery or a string with the column name
- $min : Closure|float|int|string|null
- $max : Closure|float|int|string|null
Tags
Return values
static —orHavingNotEqual()
Appends a "OR $column != $value" condition in the HAVING clause.
public
orHavingNotEqual(Closure|string $column, Closure|float|int|string|null $value) : static
Parameters
- $column : Closure|string
-
Closure for a subquery or a string with the column name
- $value : Closure|float|int|string|null
Tags
Return values
static —orHavingNotIn()
Appends a "OR $column NOT IN (...$values)" condition in the HAVING clause.
public
orHavingNotIn(Closure|string $column, Closure|float|int|string|null $value, Closure|float|int|string|null ...$values) : static
Parameters
- $column : Closure|string
-
Closure for a subquery or a string with the column name
- $value : Closure|float|int|string|null
- $values : Closure|float|int|string|null
Tags
Return values
static —orHavingNotLike()
Appends a "OR $column NOT LIKE $value" condition in the HAVING clause.
public
orHavingNotLike(Closure|string $column, Closure|float|int|string|null $value) : static
Parameters
- $column : Closure|string
-
Closure for a subquery or a string with the column name
- $value : Closure|float|int|string|null
Tags
Return values
static —orHavingNullSafeEqual()
Appends a "OR $column <=> $value" condition in the HAVING clause.
public
orHavingNullSafeEqual(Closure|string $column, Closure|float|int|string|null $value) : static
Parameters
- $column : Closure|string
-
Closure for a subquery or a string with the column name
- $value : Closure|float|int|string|null
Tags
Return values
static —renderHaving()
Renders the full HAVING clause.
protected
renderHaving() : string|null
Return values
string|null —The full clause or null if has not a clause