I'm having difficulty defining the relationship that:
A user owns many listings. Each listing has many quotes and each quote may belong to many listings. Structure:
users
id - integer
listings
id - integer
user_id - integer
quotes
id - integer
title - string
quotes_users (pivot (issue here))
id - integer
quote_id - integer
listing_id - integer
user_id - integer
accepted_at - datetime
rejected_at - datetime
My issue is im getting confused about the quotes_users setup above.
The user will want to see each quote they have along with the connected listing. They may then update their version of the quote, accepting or rejecting it. Before using Laravel, I would not have put user_id inside quotes_users, instead naming it quotes_listings, main reason it sits in this table is my lack of knowledge of laravel relationships.
Models:
class User extends Eloquent {
public function quotes()
{
return $this->belongsToMany('Quote', 'quotes_users')->withTimestamps('accepted_at', 'rejected_at')->withPivot('accepted_at', 'rejected_at')->orderBy('created_at', 'DESC');
}
}
class Quote extends Eloquent {
public function users()
{
return $this->belongsToMany('User', 'quotes_users')->withTimestamps('accepted_at', 'rejected_at')->withPivot('accepted_at', 'rejected_at')->orderBy('created_at', 'DESC');
}
}
With this current setup, struggling to show each listing when using User::quotes() as quotes_users does not have a model and hence I can not tell laravel listing_id should be connected to a listing.
Any help would be much appreciated!
Your user relation is incorrect, should be return $this->hasMany instead of return $this->belongsToMany.
Still, your table doesn't look right to me. I think it should be called listings_quotes, since the many-to-many relation is between those two, not users and quotes.
An easy setup would be:
That way, you could access Quotes from user indirectly like this: User->Listing->Quote
Or, you could use the hasManyThrough relation
You can check this other answer, I think it has a similar problem