/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 vote157 views1 answer
Extract text before last space php
PHP
1 vote247 views1 answer
Best code editors for php
PHP
6 votes160 views2 answers
How many products can a laravel ecommerce handle
PHP
2 votes204 views3 answers
Laravel url with parameters blade
PHP Laravel
0 vote161 views1 answer
Php parse file
PHP
1 vote213 views2 answers
Laravel check if object is empty
PHP
39 votes211 views6 answers
Php uppercase
PHP
0 vote180 views1 answer
Laravel number input positive only
PHP Laravel
42 votes171 views6 answers
Laravel 8 foreign key
PHP
4 votes169 views2 answers
Php get list of filenames in diretory
PHP