How can I implement Laravel Eloquent wherehas count question?

Question

I have bookings and addon table.

bookings has many addons.

I want to get bookings with addon type Optional Tour

I tried this

 $bookings = Booking::with([
        "add_ons",  
         ])
        ->whereHas("add_ons",function($q){
            $q->where("type","<>" ,AddOn::T_OPTIONAL_TOUR);
        })

which obviously not working. how can i get only bookings with no optional tour addon?

here is table infomation

bookings

id
name

Booking_add_ons

id
booking_id
add_on_id

add_ons

id
type
add_name

I need to get bookings with add ons where the addon has no optional tours. — Jaeyoung Heo, Feb 14 '19 at 03:55

score 1 · Accepted Answer · answered Feb 14 '19 at 02:58

1

Use whereDoesntHave():

$bookings = Booking::with('add_ons')
    ->whereDoesntHave('add_ons', function($q) {
        $q->where('type', '=', AddOn::T_OPTIONAL_TOUR);
    })->get();

answered Feb 14 '19 at 02:58

Jonas Staudenmeir

24,815
6
63
109

Thanks. This works. I had more where clauses which caused malfunctioning. – Jaeyoung Heo Feb 14 '19 at 07:10

How can I implement Laravel Eloquent wherehas count question?

1 Answers1