/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 vote137 views1 answer
Laravel request file empty
PHP
0 vote137 views1 answer
Call function from default parameter php
PHP
1 vote243 views1 answer
Cakephp 404 exception
PHP CakePHP
0 vote137 views1 answer
+ php quantifer
PHP
0 vote131 views1 answer
Best Image Manipulation and Graphs tools for php
PHP
0 vote145 views1 answer
Send var in header php
PHP
0 vote145 views1 answer
Bin/cake cache clear_all
PHP
2 votes261 views1 answer
Yii2 migration add column
PHP Yii
0 vote171 views1 answer
Symfony see all make command
PHP Symfony
4 votes276 views2 answers
Php select option selected from database
PHP