->filters([
Filter::make('test_date_range')
->label('Test Date')
->form([
DatePicker::make('start_date')
->label('Test From')
->default(now()->subDays(6)),
DatePicker::make('end_date')
->label('Test To')
->default(now()),
])
->query(function ($query, array $data) {
return $query
->when(
$data['start_date'] ?? null,
fn ($query, $date) => $query->whereDate('test_date', '>=', $date)
)
->when(
$data['end_date'] ?? null,
fn ($query, $date) => $query->whereDate('test_date', '<=', $date)
);
})
->filters([
Filter::make('test_date_range')
->label('Test Date')
->form([
DatePicker::make('start_date')
->label('Test From')
->default(now()->subDays(6)),
DatePicker::make('end_date')
->label('Test To')
->default(now()),
])
->query(function ($query, array $data) {
return $query
->when(
$data['start_date'] ?? null,
fn ($query, $date) => $query->whereDate('test_date', '>=', $date)
)
->when(
$data['end_date'] ?? null,
fn ($query, $date) => $query->whereDate('test_date', '<=', $date)
);
})