/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

13 votes383 views2 answers
Laravel turn off timestamps
PHP Laravel
1 vote320 views1 answer
Laravel foreach else
PHP
3 votes359 views2 answers
Php var exists
PHP
1 vote355 views1 answer
Wordpress print all categories
PHP
0 vote350 views3 answers
Is_unique in codeigniter form validation
PHP
3 votes320 views2 answers
Get all class methods php
PHP
0 vote352 views2 answers
Laravel belongsto with condition date
PHP
0 vote377 views1 answer
Show all laravel valet folders
PHP
1 vote315 views1 answer
How to save data from api to laravel
PHP
0 vote305 views1 answer
Cross-site request forgery validation failed. Required param "state" missing from persistent data
PHP