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.
Laravel Cloud is the best place to deploy Laravel, Nuxt, Express, Hono, Node.js, Bun, Go, Flask, Python, and more, with dedicated infrastructure available on AWS through Laravel Private Cloud.