/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

2 votes284 views3 answers
Laravel 8 404 status
PHP
4 votes252 views4 answers
Laravel meta csrf
PHP
0 vote250 views1 answer
Internal server error phpmyadmin
PHP
0 vote251 views1 answer
Php only includable file
PHP
0 vote267 views1 answer
.phtml
PHP
0 vote245 views3 answers
How to go one folder back in __dir__ in php
PHP
5 votes314 views5 answers
Unique laravel migration
PHP Laravel
12 votes302 views2 answers
Laravel query with trashed
PHP Laravel
5 votes292 views2 answers
Paginate relationship laravel7
PHP Laravel
0 vote251 views1 answer
Codeigniter update query return value
PHP