/PHP/DB::raw('SUM(subtotal) as total sales', 'SUM(discount) as d')

DB::raw('SUM(subtotal) as total sales', 'SUM(discount) as d')

$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 vote140 views1 answer
Get DAYS absent from working days from given date range
PHP
1 vote139 views1 answer
Check if post id exists wordpress
PHP
1 vote180 views3 answers
Laravel required if
PHP Laravel
0 vote156 views2 answers
How to disable laravel cors
PHP Laravel
3 votes142 views1 answer
Sms laravel
PHP Laravel
1 vote167 views1 answer
Laravel refresh server
PHP Laravel
10 votes147 views4 answers
Laravel create
PHP Laravel
1 vote118 views2 answers
Show date time with milliseconds php
PHP
13 votes206 views6 answers
How to run laravel project
PHP Laravel
0 vote165 views1 answer
Indian time laravel
PHP Laravel