/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

8 votes280 views2 answers
Store file into specific directory laravel using storage facade
PHP
0 vote280 views1 answer
SET DEFAULT hide title astra wordpress
PHP
4 votes314 views1 answer
Print beauty php
PHP
-1 vote259 views1 answer
Laravel 7 generator
PHP Laravel
0 vote349 views1 answer
Laravel 8 jwt api authentication
PHP Laravel
21 votes305 views1 answer
Php delete array item by value not key
PHP
1 vote248 views1 answer
How to print a pdf
PHP
0 vote286 views1 answer
Wp create menu location
PHP
0 vote324 views1 answer
Connecting to database and performing sql queries
PHP
0 vote290 views1 answer
Laravel post index method
PHP Laravel