/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

0 vote197 views1 answer
Add attachment to the invoice laravel
PHP Laravel
0 vote198 views1 answer
Laravel how to query belongsTo relationship
PHP Laravel
-1 vote207 views2 answers
Laravel pagination keep query string
PHP Laravel
2 votes214 views3 answers
How to share a helper globally laravel
PHP Laravel
0 vote189 views1 answer
Gate::before not working laravel 8
PHP Laravel
2 votes198 views1 answer
Laravel Call to a member function diffForHumans() on string
PHP Laravel
0 vote204 views1 answer
Populate old value of dropdown laravel
PHP Laravel
3 votes210 views1 answer
Laravel check if array is empty
PHP Laravel
0 vote193 views1 answer
Laravel (8) - Routing to controller with optional parameters
PHP Laravel
0 vote212 views1 answer
Laravel check if request wantsjson
PHP Laravel