/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 vote307 views1 answer
If home else php wordpress
PHP
1 vote321 views3 answers
Laravel eloquent to array key value
PHP
13 votes320 views4 answers
Laravel login by id
PHP Laravel
1 vote363 views1 answer
Wordpress change slug programmatically
PHP Wordpress
0 vote277 views1 answer
Using php, how to create a folder in another folder
PHP
1 vote303 views2 answers
How to install redis for php7.4
PHP
19 votes289 views5 answers
Using js variable in php
PHP
1 vote300 views1 answer
How to install theme phpmyadmin
PHP
9 votes330 views4 answers
Convert laravel hash password online
PHP
12 votes264 views6 answers
Php array push key value
PHP