Apr 14, 2020
0
Level 3
Mysql Raw query with groupBy in laravel
Is there any better way of using Eloquent or Query builder
$PurchasesdAmount = DB::select(
'SELECT pp.supplier_id,SUM(pp.amount)AS PaidAmount,pp.id,
(SELECT NAME FROM suppliers sa WHERE sa.id = pp.supplier_id) AS Supplier
FROM purchases_payments pp
Group BY pp.supplier_id'
);
return response()->json(['data' => $PurchasesdAmount]);
Please or to participate in this conversation.