/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

17 votes190 views4 answers
Laravel with trashed
PHP
47 votes230 views6 answers
Laravel create seeder
PHP
0 vote191 views1 answer
Blade check user role laravel
PHP
0 vote207 views2 answers
Laravel download file from s3
PHP Laravel
0 vote227 views1 answer
Php count matching words in two strings
PHP
0 vote203 views1 answer
Window.location javascript php
PHP
0 vote197 views1 answer
Exception::getMessage in php
PHP
0 vote170 views1 answer
Laravel foreign id
PHP
1 vote191 views1 answer
Vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDO/Exception.php:18
PHP
0 vote218 views1 answer
Laravel filter get pagiination does not flter Appending To Pagination Links
PHP Laravel