How to use condition with query builder

Question

I have orders table which contains status, paymode, pay_status column

I want to get order if paymode is cod then pay_status unconfirmed can get
and
if paymode is payu then pay_status only confirmed can get

Here I tried with whereRaw

$orders = Order::whereHas('products', function (Builder $query) use ($seller) {
            $query->where('seller_id', $seller->id);
        })
            ->whereRaw('IF (`paymode` = `payu`, `pay_status` = `confirmed`)')
            ->paginate(25);

but it's not working

Answer 1

you can try like this also for multiple conditions

 $orders = Order::whereHas('products', 
    function (Builder $query) use ($seller) { 
         $query->where('seller_id', $seller->id); 
    })->whereRaw('paymode = ? AND pay_status = ?', ['payu','confirmed']) 
      ->orWhereRaw('paymode = ? AND pay_status = ?', ['cod','unconfimed ']) 
    ->paginate(25);