/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

1 vote232 views1 answer
Foreign key in php
PHP
1 vote224 views2 answers
Modularizing laravel 8.0
PHP
0 vote247 views1 answer
PHP Resize
PHP
4 votes223 views1 answer
Bcript laravel
PHP
11 votes232 views4 answers
Number format comma php
PHP
1 vote239 views1 answer
Php turney if
PHP
0 vote310 views1 answer
Php differenza giorni tra date
PHP
0 vote249 views1 answer
Append a text string to WooCommerce product title loop
PHP
0 vote221 views1 answer
Age date de naissance php
PHP
9 votes232 views5 answers
Get Current Page URL in PHP
PHP