Level 61
Does this work?
$market->with(benefits.items)->pluck('benefits.items');
Nov 29, 2019
17
Level 1
Accessing data over two many-to-many relationships
Hi, i try to access data over 2 belongsToMany relationships.
I've 5 tables : markets, benefit_market, benefits, benefit_item, items and these 3 models behind.
Markets have multiple benefits and benefits have multiple items
//Market.php
class Market extends Model
{
public function benefits()
{
return $this->belongsToMany(Benefit::class);
}
}
//Benefit.php
class Benefit extends Model
{
public function items()
{
return $this->belongsToMany(Item::class);
}
public function markets()
{
return $this->belongsToMany(Market::class);
}
}
//Item.php
class Item extends Model
{
public function benefits()
{
return $this->belongsToMany(Benefit::class);
}
}
I want to access all items for a given market (and reverse access all markets for given items) like this : $market->items but i don't know how to do it.
I've tried $market->with(benefits.items)->get() but i can't access directly to all items for the market...
Hope someone can help me. Thanks. :)
Level 1
Thanks for your reply bugsysha but it doenst work.
I'va "SQLSTATE[42S22]: Column not found: 1054 Unknown column 'benefits.items' in 'field list' (SQL: select benefits.items from markets)" error...
:-(
Level 1
When i do $market->with(benefits.items)->get() i've a collection of all markets. Each market has for relation a collection of benefits who have items....
Level 61
Did Laravel receive a hasManyThrough() relationship that you can use?
Level 1
I havent hasManyThrough() relation.
Markets -> Benefits = BelongsToMany
Benefits -> Items = BelongsToMany
I've two pivot tables : benefit_market (benefit_id, market_id) & benefit_item (beneift_id, item_id)
I can't make hasManyThroug() relation cross all tables no ?
Level 61
Nope. I've read belongsToMany as hasMany.
Level 61
Post a dummy table which I can use to find a solution.
Level 1
You can find tables modelisation here : https://ibb.co/bXMVf8m
Level 1
For me, i must implement a new relation in Market model but i don't know how i can do this...
Market.php
public function items()
{
return ???
}
Level 1
Somebody else have an idea ?
Level 28
Try something like this: https://stackoverflow.com/a/26187648
Or you can use an accessor to your Market model:
public function getItemsAttribute()
{
return $items = $this->benefits->pluck('items')->collapse()->unique('id');
}
Then in your controller you can do something like this:
$market = Market::with('benefits.items')->first();
dd($market->items);
// or this
$markets = Market::with('benefits.items')->get();
foreach($markets as $market) {
dd($market->items);
}
Level 1
Thanks a lot drgeen !!
$market->benefits->pluck('items')->collapse() works perfectly :)
Level 1
i've an other question : is there a way to paginate item collection ?
Level 28
Not related to the paginate question.
Remember to eager load the relationships or lazy eager load it before calling the accessor to avoid N+1 query problem.
// eager load
$markets = Market::with('benefits.items')->get();
$market = Market::with('benefits.items')->first();
// lazy eager load
$market->load('benefits.items');
// or this
$market->loadMissing('benefits.items');
Refer here for Lazy Eager Loading
Level 1
However i use eager load or not i've the same error : BadMethodCallException Method Illuminate\Support\Collection::paginate does not exist.
This is my controller :
// MarketController.php
public function show(Market $market)
{
$market->loadMissing('benefits.items');
$items = $market->items->paginate(10);
return view('pages.markets.show', compact('market', 'items'));
}
Level 1
After search, i found this : https://gist.github.com/simonhamp/549e8821946e2c40a617c85d2cf5af5e
It works fine, but I'ld prefer a laravel native solution...
Level 28
Maybe you can use this for paginated result:
public function show(Market $market)
{
$items = Item::whereHas('benefits', function ($query) use ($market) {
$query->whereHas('markets', function ($q) use ($market) {
$q->where('markets.id', $market->id);
});
})->paginate(5); // 5 results each page
return view('pages.markets.show', compact('market', 'items'));
}
Please or to participate in this conversation.