/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

0 vote229 views1 answer
WordPress Convert Object To Array
PHP
9 votes225 views3 answers
Define url wordpress
PHP
0 vote223 views1 answer
Nuxt auth login with laravel passport
PHP
0 vote222 views1 answer
Wordpress disallow_file_edit
PHP
1 vote233 views1 answer
How to display MySQL data dynamically using jQuery and PHP
PHP
6 votes209 views2 answers
How many products can a laravel ecommerce handle
PHP
0 vote235 views1 answer
Joomla include jfactory
PHP
20 votes259 views6 answers
Create model laravel
PHP Laravel
1 vote331 views1 answer
Laravel profile migration tool
PHP Laravel
12 votes270 views3 answers
How to remove composer package in laravel
PHP