Level 25
Hi @msslgomez
Just query for relationship existence:
$categories = Category::has('products')->get();
docs: https://laravel.com/docs/master/eloquent-relationships#querying-relationship-existence
Sep 18, 2020
8
Level 9
Get model items included in relationship (categories that have products)
I have an online store and I was wondering if I could show only the categories that have products from the list of products and the relationship.
Right now this is how I bring the products and categories, I would like to get only the categories that the products in $products have, the Product has a categories relationship to get that info
$products = Product::whereHas('inventorySumQuantity', function ($query) {
$query->where('quantity', '>', 0);
})
->where('type', 'glassware')
->get();
$new = Product::whereHas('inventorySumQuantity', function ($query) {
$query->where('quantity', '>', 0);
})
->where('type', 'glassware')
->orderByDesc('created_at')
->take(10)
->get();
$categories = Category::all();
$categories->each(function ($item) {
if (App::getLocale() === 'es') {
$item->name = $item->es_name;
} else {
if ($item->en_name != null){
$item->name = $item->en_name;
} else {
$item->name = $item->es_name;
}
}
});
How can I do this? Or is this not recommended, the reason behind it is that the user can click on the shown categories to see all the products that belong to that category but if it's empty I don't see a real reason to show the category.
Level 25
@msslgomez actually, reading again, you should use whereHas instead so you can filter the Products using a whereIn and passing your $products list.
Sorry I can’t write an example for you, as I’m at my phone and it gets hard to write that code hehe
Level 75
$categories = Category::whereHas('products', function ($query) use ($products) {
$query->whereIn('id', $products->pluck('id'));
})->get();
In Category model you can create an accessor
public function getNameAttribute()
{
return (app()->getLocale() === 'es' ? $this->es_name : $this->en_name) ?? $this->es_name;
}
Then you can use $category->name without that logic what you have in previous post.
Level 9
@michaloravec Is model function used like this?
$categories->each(function ($item) {
$item->name = $item->getNameAttribute();
});
Level 75
No it will work automatically
Docs: https://laravel.com/docs/8.x/eloquent-mutators#accessors-and-mutators
Level 9
@michaloravec I need to send it to a vue file so without me adding that I don't get a name attribute for each category
Level 75
So append it to your model and it will be still included to the model
protected $appends = ['name'];
public function getNameAttribute()
{
return (app()->getLocale() === 'es' ? $this->es_name : $this->en_name) ?? $this->es_name;
}
Docs: https://laravel.com/docs/8.x/eloquent-serialization#appending-values-to-json
Level 9
@michaloravec Thanks, I have a lot to learn!
Please or to participate in this conversation.