/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 vote106 views1 answer
Undefined type excel
PHP
0 vote174 views1 answer
Activerecord yii2 select with limit(start,end) not working
PHP
6 votes125 views4 answers
Illuminate database queryexception could not find driver laravel
PHP Laravel
19 votes118 views4 answers
Php header refresh
PHP
0 vote112 views1 answer
Alert in php after header location
PHP
0 vote176 views1 answer
Laravel count the types of users
PHP Laravel
0 vote137 views1 answer
Gd2 image resizing library in codeigniter
PHP CodeIgniter
9 votes127 views1 answer
Laravel 6 link storage with public
PHP Laravel
0 vote106 views2 answers
Notice: Trying to get property 'NAME' of non-object in
PHP
4 votes124 views2 answers
Auth guard (admin) is not defined laravel 8
PHP