/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

5 votes311 views4 answers
Laravel auth register false
PHP
0 vote366 views1 answer
How to list notification from database
PHP
1 vote309 views5 answers
Eloquent batch insert
PHP
0 vote308 views1 answer
Pdo prepare multiple queries
PHP
0 vote332 views1 answer
Get age in months php
PHP
3 votes369 views2 answers
Laravel blade auth check
PHP
33 votes355 views6 answers
Migrate specific migration laravel
PHP
0 vote344 views1 answer
How to create pdf with doompdf in php
PHP
0 vote327 views1 answer
[InvalidArgumentException] Could not find package symfony/web-server-bundle in a version matching 5.0.
PHP
0 vote343 views1 answer
Axios post not sending data php
PHP