/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 vote104 views1 answer
Apt-get install php wordpress extensions
PHP
0 vote104 views3 answers
Laravel get all records order by
PHP
0 vote107 views1 answer
Yii2 GridView Filtering on Relational Column
PHP
0 vote114 views1 answer
Php leggere file txt riga per riga
PHP
3 votes130 views6 answers
Laravel find query
PHP Laravel
0 vote122 views3 answers
How to add posts to php
PHP
0 vote126 views1 answer
Order table in laravel
PHP Laravel
0 vote103 views1 answer
Php compress csv file
PHP
2 votes115 views2 answers
Laravel pagination with get parameters
PHP
0 vote113 views1 answer
WordPress Creating “startupl” folder and Wrtting to .htaccess
PHP