Level 15
You are looking for the hasManyThrough relationship. Here is a link to the docs which covers this exact example.
Oct 25, 2016
7
Level 1
Eloquent Relation
Hello,
I've some problem with eloquent relations ,what i want to do :
Ex : I've 3 tables User(id,country_id,username) , Country(id,name), Post(id,user_id,content) I want the list only of countries which have posts , is there a way to do that with Eloquent relations ?
the same of :
SELECT * FROM country
JOIN user ON country.id = user.country_id
JOIN post ON user.id = post.user_id
GROUP BY country.id
Thanks.
Level 1
Yes i tried to do this on Country Model:
public function posts()
{
return $this->hasManyThrough('App\Models\Post', 'App\Models\User' );
}
but how to get the list of only countries with posts ?
Level 15
You can query for relationship existence with the 'has' method as described in this section of the docs.
$countries = App\Country::has('posts')->get();
Level 1
Thanks that exactly what i need :)
But i've an other problem now , i've a Trait global scope on the post model to add globally where conditions, when i put the global scope the returned collection is empty although the BDD request i see in the debugger is right (i tried directly in mysql).
Do you have an idea ?
Thanks again
Level 15
If you are getting the data you expect without the global scope you can remove the global scope for this specific query by using the withoutGlobalScopes method. Look for 'Removing Global Scopes' in this section of the docs.
$countries = App\Country::withoutGlobalScopes()->has('posts')->get();
Level 1
I'm on Laravel 5.1 there is no withoutGlobalScopes i think, but i've just tried with https://github.com/jarektkaczyk/laravel-global-scope implementation and it works fine !
Thanks a lot.
Level 15
Ah. Sorry about that. That is a good package you found anyway. Glad you got it figured out.
Please or to participate in this conversation.