/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 vote132 views1 answer
Get All dates of a month with laravel carbon
PHP
0 vote148 views1 answer
Wp main menu
PHP
0 vote196 views1 answer
Mysql secure
PHP
1 vote147 views2 answers
Remove All Spaces Out of a String in PHP
PHP
0 vote125 views2 answers
Catch any exception php
PHP
8 votes142 views4 answers
Laravel model soft delete
PHP Laravel
-1 vote125 views2 answers
Adminlte 3 laravel
PHP
0 vote144 views1 answer
How to check confirm password in php
PHP
0 vote119 views3 answers
How to check if all values in an array are equal php
PHP
0 vote122 views1 answer
Multi-idiomas com PHP
PHP