/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 vote148 views2 answers
Wordpress disable editor
PHP
11 votes162 views5 answers
Uuid in laravel
PHP
0 vote157 views2 answers
Append data in csv file php
PHP
0 vote144 views1 answer
Php header utf8 json
PHP
0 vote195 views1 answer
Add multi product at the same time using repearter default view laravel
PHP Laravel
0 vote186 views1 answer
Menampilkan hari dan tanggal sekarang di php
PHP
14 votes148 views6 answers
Get featured image url in wordpress
PHP
2 votes179 views2 answers
How get query from url in laravel
PHP
0 vote259 views1 answer
Laravel collection shift
PHP Laravel
3 votes156 views1 answer
Laravel edit form modal example
PHP