I imagine you already have the sidebar loading all the categories and relative ids.
Then on flagged checkbox goes to livewire action and add the ids to a Wherein().
Can I ask if this is the only filtering that you plan to do?
1 like
Oct 1, 2021
7
Level 4
How i filter my product car by category_id with multiple selection (checkbox)
Good afternoon im new in laravel -livewire and i try to make sidebar filters for my project i cant make multiple selection by id . Any idea or any doc for that
Level 4
thank you for response !! no the sidebar will have many filters like model, brand ,years I would like to use $ querystring ,so that I can use a listener to combine compnent.
can I somehow send you printscreen in this forum?
Level 7
@Constantine_92 so i think something generically like:
view:
foreach(some parameter){
livewire model checkbox (put values and ids...)
}
component:
"some query"->when($this->"some parameter", function($query,"some parameter" ){ query->whereIn(...)}
...i dont know the perfomance :)...but if is ugly and works it anyway a start
Level 4
@alessandro.mirabelli thank you very much for your help. I appreciate it!
Level 4
public $SelectedCat = [];
public $queryString=[
'SelectedCat',
];
public function SelectCategory()
{
dd($this->SelectedCat);
}
public function render()
{
$carcategories =CarCategory::all();
return view('livewire.cars-index',[
'cars'=>Car::with('user','carcategory')
->when($this->SelectedCat = array_filter($this->SelectedCat), function($query)
{
return $query->whereIn('carcategory_id', array_keys($this->SelectedCat)) -> get();
}),
'carcategories'=>$carcategories,
]);
}
}
this way it works but when the category is not selected(is empty ) it does not bring anything back. how i work with if statement to fix it . Any idea
1 like
Level 4
public function render() {
if(empty($this->SelectedCat)) {
$cars = Car::all();
}
else
{
$this->SelectedCat = array_filter($this->SelectedCat );
$cars= Car::with('user','carcategory')->whereIn('carcategory_id', array_keys($this->SelectedCat)) -> get();
}
$carcategories =CarCategory::all();
return view('livewire.cars-index',['cars'=>$cars,'carcategories'=>$carcategories]);
}
}
i did this but when i click and after unclick the category again display empty cars
@Constantine_92 maybe you should check updated value, it seems like you need to keep updated values, check this discussion: https://laracasts.com/discuss/channels/livewire/livewire-forgetting-an-array-value-when-the-model-updates
Please or to participate in this conversation.