/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

1 vote143 views2 answers
How to request and display data from db in larave
PHP
0 vote187 views2 answers
Laravel collection intersect
PHP
0 vote209 views1 answer
Wordpress get the main url
PHP Wordpress
45 votes190 views6 answers
Laravel migration add column after
PHP
0 vote162 views1 answer
Disconnect with button click php
PHP
1 vote155 views1 answer
Wp override home url with php
PHP
0 vote162 views1 answer
Relationship on the base of condition in laravel
PHP
4 votes129 views5 answers
Cmd windows download file
PHP
7 votes208 views5 answers
Laravel foreach loop index
PHP Laravel
0 vote174 views1 answer
Get shipping price of choosen shipping method woocommerce
PHP