/PHP/Laravel/Sum multiple fields separately in laravel

Sum multiple fields separately in laravel

$customer = FinanceSale::select(
  DB::raw('SUM(sub_total) as total_sales'),
  DB::raw('SUM(discount) as d'),
)
->where('customer_id', $id)
->groupBy('customer_id')
->first();

Similar codes

49 votes282 views6 answers
Laravel clear all cache
PHP Laravel
1 vote269 views1 answer
Laravel model created_at format edit
PHP Laravel
5 votes232 views5 answers
Laravel get all request parameters
PHP Laravel
1 vote260 views2 answers
Where clause with paginate laravel multiple column
PHP Laravel
0 vote232 views1 answer
Laravel dateinterval not found
PHP Laravel
6 votes259 views1 answer
Laravel get client public ip
PHP Laravel
1 vote241 views2 answers
Laravel, return view with Request::old
PHP Laravel
1 vote266 views2 answers
Laravel eloquent with query extra parameter
PHP Laravel
0 vote276 views2 answers
Laravel collection sort by date
PHP Laravel
12 votes240 views5 answers
Drop column migration laravel
PHP Laravel