/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

1 vote208 views1 answer
Supervisor configuration for laravel queue
PHP Laravel
1 vote145 views1 answer
Laravel parent child same table
PHP Laravel
0 vote140 views3 answers
Laravel where json array column
PHP Laravel
2 votes151 views2 answers
Echo query in laravel
PHP Laravel
15 votes155 views1 answer
Laravel skip requirements
PHP Laravel
0 vote150 views1 answer
Laravel eloquent only today
PHP Laravel
1 vote226 views1 answer
Laravel search data relationship
PHP Laravel
0 vote142 views1 answer
How to get post by comment in laravel
PHP Laravel
9 votes168 views5 answers
Laravel create password hash
PHP Laravel
0 vote178 views5 answers
Laravel create multiple models at once
PHP Laravel