Trait Framework\Database\Manipulation\Traits\Having

Having

Trait Having.

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.

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

Having

Table of Contents

Methods

having()

Parameters

Return values

havingBetween()

Parameters

Tags

Return values

havingEqual()

Parameters

Tags

Return values

havingGreaterThan()

Parameters

Tags

Return values

havingGreaterThanOrEqual()

Parameters

Tags

Return values

havingIn()

Parameters

Tags

Return values

havingIsNotNull()

Parameters

Tags

Return values

havingIsNull()

Parameters

Tags

Return values

havingLessThan()

Parameters

Tags

Return values

havingLessThanOrEqual()

Parameters

Tags

Return values

havingLike()

Parameters

Tags

Return values

havingNotBetween()

Parameters

Tags

Return values

havingNotEqual()

Parameters

Tags

Return values

havingNotIn()

Parameters

Tags

Return values

havingNotLike()

Parameters

Tags

Return values

havingNullSafeEqual()

Parameters

Tags

Return values

orHaving()

Parameters

Return values

orHavingBetween()

Parameters

Tags

Return values

orHavingEqual()

Parameters

Tags

Return values

orHavingGreaterThan()

Parameters

Tags