/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

7 votes224 views3 answers
How to show validation error in laravel blade
PHP Laravel
1 vote183 views1 answer
Copy php array to javascript
PHP
0 vote180 views1 answer
Laravel job delay dispatch
PHP
0 vote176 views1 answer
Response()->make laravel pdf
PHP
0 vote169 views1 answer
Php get keys of duplicate values in array
PHP
0 vote216 views1 answer
Model hasmany laravel
PHP Laravel
0 vote235 views1 answer
Wordpress change email new user template
PHP
9 votes230 views5 answers
Laravel password hash decrypt online
PHP
0 vote210 views1 answer
Laravel collection forPage
PHP Laravel
0 vote287 views1 answer
Symfony form submit on refresh
PHP Symfony