Filter::make('program')
->form([
Forms\Components\Select::make('program')
->multiple()
->options(function(){
$arr = [];
$programs = Program::all();
foreach ($programs as $program) {
$arr[$program->id] = $program->name;
}
return $arr;
})
])
->query(function (Builder $query, array $data): Builder {
return $query->whereHas('client', function($q) use ($data) {
return $q->where('program_id', $data);
});
})
Filter::make('program')
->form([
Forms\Components\Select::make('program')
->multiple()
->options(function(){
$arr = [];
$programs = Program::all();
foreach ($programs as $program) {
$arr[$program->id] = $program->name;
}
return $arr;
})
])
->query(function (Builder $query, array $data): Builder {
return $query->whereHas('client', function($q) use ($data) {
return $q->where('program_id', $data);
});
})