/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

4 votes238 views3 answers
Laravel on delete set null
PHP Laravel
1 vote224 views1 answer
Php convert date and time to iso 8601
PHP
1 vote187 views1 answer
Laravel date rule before 18 years ago
PHP
0 vote199 views1 answer
How to filter the all special characters in cakephp from an array
PHP
1 vote196 views1 answer
Why laravel site loading only
PHP
0 vote282 views1 answer
Comment désactiver la barre latérale Widgets sur des pages spécifiques WordPress
PHP Wordpress
0 vote189 views1 answer
Session() in lumen
PHP
14 votes233 views3 answers
Unset php return array
PHP
1 vote204 views2 answers
Laravel required_if
PHP
0 vote216 views1 answer
Php days in hours
PHP