public function vparticulardiscountamount($id)
{
$fetch = DB::table('tbl_payment_user_map')
->leftJoin('tbl_payment_particular', 'tbl_payment_user_map.payment_particular', '=',
'tbl_payment_particular.id')
->leftJoin('tbl_discount', 'tbl_payment_user_map.discount', '=', 'tbl_discount.id')
->select('tbl_payment_particular.amount','tbl_discount.amount as
discountamount',DB::raw('(tbl_payment_particular.amount - tbl_discount.amount) as
total'))
->where('tbl_payment_user_map.payment_user',$id)
->get();
return response()->json(['results' => $fetch], 200);
}
uj5u.com熱心網友回復：
您可以使用Collection'sum方法并將結果添加到您的回應中。
return response()
->json(['results' => $fetch, 'sum' => $fetch->sum('total')], 200);
或者
return response()
->json(['results' => ['data' => $fetch, 'sum' => $fetch->sum('total')]], 200);
轉載請註明出處，本文鏈接：https://www.uj5u.com/qiye/419111.html
標籤：
上一篇：合并到一個查詢兩個不同