How to set where in relation Laravel?

Question

I use the following construction for joining tables: with("attachments", "offers.publisher").

public function publisher()
    {
        return $this->belongsTo("App\User", "user_id", "id");
    }

How to join publisher relation only when offers.status = 1?

In other words I need to use publisher by condition Where

I tried also this:

 $announcements = Announcement::whereHas('offers', function($q) {
            $q->with("publisher")->where('status', 1);
        })->get();

Or how to exclude `publisher` from result object? – Darama Feb 17 '17 at 19:00 — Darama, Feb 17 '17 at 19:00

Samsquanch · Accepted Answer · 2017-02-17T19:05:31.960

3

The best way would to just have two definitions, publishers for all publishers, and active_publishers for those with status = 1:

public function publisher()
{
    return $this->belongsTo("App\User", "user_id", "id");
}

public function active_publisher()
{
    return $this->publisher()->where('status', 1);
}

Use with $object->active_publisher()->get();

edited Feb 17 '17 at 19:05

answered Feb 17 '17 at 19:00

Samsquanch

8,866
12
50
89

I got: `Call to undefined method Illuminate\Database\Query\Builder::active_publisher()` – Darama Feb 17 '17 at 19:08
Also I need join `publisher` if `offers.status=1`, but yoy wrote `user.status=1` – Darama Feb 17 '17 at 19:11

score 1 · Answer 2 · edited May 23 '17 at 12:34

Here is link that can help you:

Please check this:

Eloquent where condition based on a "belongs to" relationship

Also you can do like this:

Suppose you have a post modal and each post has many comment. So can get the condition matching post comments by as following with where conditions

 public function comments()
{
    return $this->hasMany('App\Comment');
}

 App\Post::find(1)->comments()->where('title', 'foo')->get();

Thanks

How to set where in relation Laravel?

2 Answers2

Linked

Related