Created
April 17, 2023 10:11
-
-
Save akoepcke/9e63352a9f6014782b08bb30f859d19d to your computer and use it in GitHub Desktop.
FilterableByDates Traits
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
<?php | |
namespace App\Traits; | |
use Carbon\Carbon; | |
trait FilterableByDates | |
{ | |
public function scopeToday($query, $column = 'created_at') | |
{ | |
return $query->whereDate($column, Carbon::today()); | |
} | |
public function scopeYesterday($query, $column = 'created_at') | |
{ | |
return $query->whereDate($column, Carbon::yesterday()); | |
} | |
public function scopeMonthToDate($query, $column = 'created_at') | |
{ | |
return $query->whereBetween($column, [Carbon::now()->startOfMonth(), Carbon::now()]); | |
} | |
public function scopeQuarterToDate($query, $column = 'created_at') | |
{ | |
$now = Carbon::now(); | |
return $query->whereBetween($column, [$now->startOfQuarter(), $now]); | |
} | |
public function scopeYearToDate($query, $column = 'created_at') | |
{ | |
return $query->whereBetween($column, [Carbon::now()->startOfYear(), Carbon::now()]); | |
} | |
public function scopeLast7Days($query, $column = 'created_at') | |
{ | |
return $query->whereBetween($column, [Carbon::today()->subDays(6), Carbon::now()]); | |
} | |
public function scopeLast30Days($query, $column = 'created_at') | |
{ | |
return $query->whereBetween($column, [Carbon::today()->subDays(29), Carbon::now()]); | |
} | |
public function scopeLastQuarter($query, $column = 'created_at') | |
{ | |
$now = Carbon::now(); | |
return $query->whereBetween($column, [$now->startOfQuarter()->subMonths(3), $now->startOfQuarter()]); | |
} | |
public function scopeLastYear($query, $column = 'created_at') | |
{ | |
return $query->whereBetween($column, [Carbon::now()->subYear(), Carbon::now()]); | |
} | |
} |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment