/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

9 votes270 views4 answers
Add another field in existing migration laravel
PHP Laravel
5 votes286 views2 answers
Get app url in laravel
PHP Laravel
1 vote316 views2 answers
Get database name laravel
PHP Laravel
0 vote294 views2 answers
Share to facebook from website laravel
PHP Laravel
0 vote299 views1 answer
Get database columns laravel
PHP Laravel
1 vote265 views2 answers
Laravel, return view with Request::old
PHP Laravel
0 vote314 views1 answer
Check mobile or email in laravel
PHP Laravel
2 votes299 views2 answers
Laravel pagination with get parameters
PHP Laravel
4 votes264 views5 answers
Laravel array_pluck
PHP Laravel
0 vote298 views1 answer
Set default value for column in laravel model
PHP Laravel