trait BuildsWhereDateClauses

Methods

wherePast(array|string $columns)

Add a where clause to determine if a "date" column is in the past to the query.

whereNowOrPast(array|string $columns)

Add a where clause to determine if a "date" column is in the past or now to the query.

orWherePast(array|string $columns)

Add an "or where" clause to determine if a "date" column is in the past to the query.

orWhereNowOrPast(array|string $columns)

Add a where clause to determine if a "date" column is in the past or now to the query.

whereFuture(array|string $columns)

Add a where clause to determine if a "date" column is in the future to the query.

whereNowOrFuture(array|string $columns)

Add a where clause to determine if a "date" column is in the future or now to the query.

orWhereFuture(array|string $columns)

Add an "or where" clause to determine if a "date" column is in the future to the query.

orWhereNowOrFuture(array|string $columns)

Add an "or where" clause to determine if a "date" column is in the future or now to the query.

wherePastOrFuture(array|string $columns, string $operator, string $boolean)

Add an "where" clause to determine if a "date" column is in the past or future.

whereToday(array|string $columns, string $boolean = 'and')

Add a "where date" clause to determine if a "date" column is today to the query.

whereBeforeToday(array|string $columns)

Add a "where date" clause to determine if a "date" column is before today.

whereTodayOrBefore(array|string $columns)

Add a "where date" clause to determine if a "date" column is today or before to the query.

whereAfterToday(array|string $columns)

Add a "where date" clause to determine if a "date" column is after today.

whereTodayOrAfter(array|string $columns)

Add a "where date" clause to determine if a "date" column is today or after to the query.

orWhereToday(array|string $columns)

Add an "or where date" clause to determine if a "date" column is today to the query.

orWhereBeforeToday(array|string $columns)

Add an "or where date" clause to determine if a "date" column is before today.

orWhereTodayOrBefore(array|string $columns)

Add an "or where date" clause to determine if a "date" column is today or before to the query.

orWhereAfterToday(array|string $columns)

Add an "or where date" clause to determine if a "date" column is after today.

orWhereTodayOrAfter(array|string $columns)

Add an "or where date" clause to determine if a "date" column is today or after to the query.

whereTodayBeforeOrAfter(array|string $columns, string $operator, string $boolean)

Add a "where date" clause to determine if a "date" column is today or after to the query.

Details

at line 17
BuildsWhereDateClauses wherePast(array|string $columns)

Add a where clause to determine if a "date" column is in the past to the query.

Parameters

array|string $columns

Return Value

BuildsWhereDateClauses

at line 27
BuildsWhereDateClauses whereNowOrPast(array|string $columns)

Add a where clause to determine if a "date" column is in the past or now to the query.

Parameters

array|string $columns

Return Value

BuildsWhereDateClauses

at line 37
BuildsWhereDateClauses orWherePast(array|string $columns)

Add an "or where" clause to determine if a "date" column is in the past to the query.

Parameters

array|string $columns

Return Value

BuildsWhereDateClauses

at line 47
BuildsWhereDateClauses orWhereNowOrPast(array|string $columns)

Add a where clause to determine if a "date" column is in the past or now to the query.

Parameters

array|string $columns

Return Value

BuildsWhereDateClauses

at line 57
BuildsWhereDateClauses whereFuture(array|string $columns)

Add a where clause to determine if a "date" column is in the future to the query.

Parameters

array|string $columns

Return Value

BuildsWhereDateClauses

at line 67
BuildsWhereDateClauses whereNowOrFuture(array|string $columns)

Add a where clause to determine if a "date" column is in the future or now to the query.

Parameters

array|string $columns

Return Value

BuildsWhereDateClauses

at line 77
BuildsWhereDateClauses orWhereFuture(array|string $columns)

Add an "or where" clause to determine if a "date" column is in the future to the query.

Parameters

array|string $columns

Return Value

BuildsWhereDateClauses

at line 87
BuildsWhereDateClauses orWhereNowOrFuture(array|string $columns)

Add an "or where" clause to determine if a "date" column is in the future or now to the query.

Parameters

array|string $columns

Return Value

BuildsWhereDateClauses

at line 97
protected BuildsWhereDateClauses wherePastOrFuture(array|string $columns, string $operator, string $boolean)

Add an "where" clause to determine if a "date" column is in the past or future.

Parameters

array|string $columns
string $operator
string $boolean

Return Value

BuildsWhereDateClauses

at line 116
BuildsWhereDateClauses whereToday(array|string $columns, string $boolean = 'and')

Add a "where date" clause to determine if a "date" column is today to the query.

Parameters

array|string $columns
string $boolean

Return Value

BuildsWhereDateClauses

at line 126
BuildsWhereDateClauses whereBeforeToday(array|string $columns)

Add a "where date" clause to determine if a "date" column is before today.

Parameters

array|string $columns

Return Value

BuildsWhereDateClauses

at line 136
BuildsWhereDateClauses whereTodayOrBefore(array|string $columns)

Add a "where date" clause to determine if a "date" column is today or before to the query.

Parameters

array|string $columns

Return Value

BuildsWhereDateClauses

at line 146
BuildsWhereDateClauses whereAfterToday(array|string $columns)

Add a "where date" clause to determine if a "date" column is after today.

Parameters

array|string $columns

Return Value

BuildsWhereDateClauses

at line 156
BuildsWhereDateClauses whereTodayOrAfter(array|string $columns)

Add a "where date" clause to determine if a "date" column is today or after to the query.

Parameters

array|string $columns

Return Value

BuildsWhereDateClauses

at line 166
BuildsWhereDateClauses orWhereToday(array|string $columns)

Add an "or where date" clause to determine if a "date" column is today to the query.

Parameters

array|string $columns

Return Value

BuildsWhereDateClauses

at line 176
BuildsWhereDateClauses orWhereBeforeToday(array|string $columns)

Add an "or where date" clause to determine if a "date" column is before today.

Parameters

array|string $columns

Return Value

BuildsWhereDateClauses

at line 186
BuildsWhereDateClauses orWhereTodayOrBefore(array|string $columns)

Add an "or where date" clause to determine if a "date" column is today or before to the query.

Parameters

array|string $columns

Return Value

BuildsWhereDateClauses

at line 196
BuildsWhereDateClauses orWhereAfterToday(array|string $columns)

Add an "or where date" clause to determine if a "date" column is after today.

Parameters

array|string $columns

Return Value

BuildsWhereDateClauses

at line 206
BuildsWhereDateClauses orWhereTodayOrAfter(array|string $columns)

Add an "or where date" clause to determine if a "date" column is today or after to the query.

Parameters

array|string $columns

Return Value

BuildsWhereDateClauses

at line 216
protected BuildsWhereDateClauses whereTodayBeforeOrAfter(array|string $columns, string $operator, string $boolean)

Add a "where date" clause to determine if a "date" column is today or after to the query.

Parameters

array|string $columns
string $operator
string $boolean

Return Value

BuildsWhereDateClauses