Filter model based on multiple relations

I have a model Booking which have hasMany rooms, hasMany expenses and hasMany payments. I want to get those bookings which fulfill following condition:

booking->rooms->sum('price') + booking->expenses->sum('amount') < booking->payments->sum('amount')

rodrigo.pedra

3 years ago

Best Answer

Level 56

$bookings = Booking::query()
    ->withSum('rooms', 'amount')
    ->withSum('expenses', 'amount')
    ->withSum('payments', 'amount')
    ->havingRaw('rooms_sum_amount + expenses_sum_amount < payments_sum_amount')
    ->withCasts([
        'rooms_sum_amount' => 'float',
        'expenses_sum_amount' => 'float',
        'payments_sum_amount' => 'float',
    ])
    ->get();

1 like

Please or to participate in this conversation.