BuildsWhereDateClauses
trait BuildsWhereDateClauses (View source)
Methods
Add a where clause to determine if a "date" column is in the past to the query.
Add a where clause to determine if a "date" column is in the past or now to the query.
Add an "or where" clause to determine if a "date" column is in the past to the query.
Add a where clause to determine if a "date" column is in the past or now to the query.
Add a where clause to determine if a "date" column is in the future to the query.
Add a where clause to determine if a "date" column is in the future or now to the query.
Add an "or where" clause to determine if a "date" column is in the future to the query.
Add an "or where" clause to determine if a "date" column is in the future or now to the query.
Add an "where" clause to determine if a "date" column is in the past or future.
Add a "where date" clause to determine if a "date" column is today to the query.
Add a "where date" clause to determine if a "date" column is before today.
Add a "where date" clause to determine if a "date" column is today or before to the query.
Add a "where date" clause to determine if a "date" column is after today.
Add a "where date" clause to determine if a "date" column is today or after to the query.
Add an "or where date" clause to determine if a "date" column is today to the query.
Add an "or where date" clause to determine if a "date" column is before today.
Add an "or where date" clause to determine if a "date" column is today or before to the query.
Add an "or where date" clause to determine if a "date" column is after today.
Add an "or where date" clause to determine if a "date" column is today or after to the query.
Add a "where date" clause to determine if a "date" column is today or after to the query.
Details
$this
wherePast(array|string $columns)
Add a where clause to determine if a "date" column is in the past to the query.
$this
whereNowOrPast(array|string $columns)
Add a where clause to determine if a "date" column is in the past or now to the query.
$this
orWherePast(array|string $columns)
Add an "or where" clause to determine if a "date" column is in the past to the query.
$this
orWhereNowOrPast(array|string $columns)
Add a where clause to determine if a "date" column is in the past or now to the query.
$this
whereFuture(array|string $columns)
Add a where clause to determine if a "date" column is in the future to the query.
$this
whereNowOrFuture(array|string $columns)
Add a where clause to determine if a "date" column is in the future or now to the query.
$this
orWhereFuture(array|string $columns)
Add an "or where" clause to determine if a "date" column is in the future to the query.
$this
orWhereNowOrFuture(array|string $columns)
Add an "or where" clause to determine if a "date" column is in the future or now to the query.
protected $this
wherePastOrFuture(array|string $columns, $operator, $boolean)
Add an "where" clause to determine if a "date" column is in the past or future.
$this
whereToday(array|string $columns, string $boolean = 'and')
Add a "where date" clause to determine if a "date" column is today to the query.
$this
whereBeforeToday(array|string $columns)
Add a "where date" clause to determine if a "date" column is before today.
$this
whereTodayOrBefore(array|string $columns)
Add a "where date" clause to determine if a "date" column is today or before to the query.
$this
whereAfterToday(array|string $columns)
Add a "where date" clause to determine if a "date" column is after today.
$this
whereTodayOrAfter(array|string $columns)
Add a "where date" clause to determine if a "date" column is today or after to the query.
$this
orWhereToday(array|string $columns)
Add an "or where date" clause to determine if a "date" column is today to the query.
$this
orWhereBeforeToday(array|string $columns)
Add an "or where date" clause to determine if a "date" column is before today.
$this
orWhereTodayOrBefore(array|string $columns)
Add an "or where date" clause to determine if a "date" column is today or before to the query.
$this
orWhereAfterToday(array|string $columns)
Add an "or where date" clause to determine if a "date" column is after today.
$this
orWhereTodayOrAfter(array|string $columns)
Add an "or where date" clause to determine if a "date" column is today or after to the query.
protected $this
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.