/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 vote174 views1 answer
Php set header content type html
PHP
1 vote187 views3 answers
Check if session is started php
PHP
0 vote176 views1 answer
Php fpm config file location
PHP
0 vote197 views1 answer
Setup cron on macos for laravel
PHP Laravel
0 vote181 views1 answer
Php pagination ellipsis
PHP
0 vote185 views1 answer
Vagrant no pg_hba.conf entry for host
PHP
0 vote142 views1 answer
Php home url
PHP
0 vote228 views1 answer
Check Data Load More Laravel Livewire
PHP Laravel
1 vote187 views2 answers
Laravel ckeditor
PHP
8 votes181 views5 answers
Codeigniter 4 redirect with data
PHP