return if id not null, laravel elequent

Question

I have connected tables with a hasMany & belongsTo relationship.

Bridal Model:

public function plans()
{
    return $this->hasMany("App\Plan");
}

Plan Model:

public function bridal()
{
    return $this->belongsTo("App\Bridal");
}

And I have an query that returns those data to endpoint.

public function bridal()
{

    $bridals = Bridal::with(["plans" => function($query){
        $query->orderBy("plans.plan_price");
    }])
    ->groupBy("place_name")
    ->get();


    return $bridals;

}

Everything is fine, except one thing. In Bridal table some of ID doesn't have plan. So when I return datas, some of bridal id comes with an empty Plans array.

I want to prevent that. If a bridal id doesn't have a plan, then I don't want to return that bridal id. How can I achieve what I want here?

score 2 · Accepted Answer · edited Oct 21 '19 at 06:04

2

You can use Has. If you just use has('relation') that means you only want to get the models that have at least one related model in this relation.

$bridals = Bridal::with(["plans" => function($query){
        $query->orderBy("plans.plan_price");
    }])->has('plans')
    ->groupBy("place_name")
    ->get();

Check more info SO answer

edited Oct 21 '19 at 06:04

lagbox

48,571
8
72
83

answered Oct 21 '19 at 05:55

Dilip Hirapara

14,810
3
27
49

1

thank you, also appreciate for explanation link. I will check it as answer. – yvl Oct 21 '19 at 06:00
Happy to help brother. – Dilip Hirapara Oct 21 '19 at 06:04

score 1 · Answer 2 · answered Oct 21 '19 at 05:54

1

Add whereHas() in your query : so you will get bridal records which has plans

$bridals = Bridal::with(["plans" => function($query){
       $query->orderBy("plans.plan_price");
   }])
   ->whereHas('plans')
   ->groupBy("place_name")
   ->get();

answered Oct 21 '19 at 05:54

Yasin Patel

5,624
8
31
53

return if id not null, laravel elequent

2 Answers2