/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 vote173 views1 answer
Laravel This package is not auto-updated. Please set up the GitHub Hook for Packagist so that it gets updated whenever you push!
PHP
0 vote197 views1 answer
Laravel collection intersectKey
PHP
1 vote209 views1 answer
Laravel server sent events
PHP Laravel
6 votes206 views3 answers
Set route name laravel
PHP Laravel
32 votes219 views6 answers
For loop in php
PHP
1 vote182 views1 answer
Php remove span tags from string
PHP
1 vote233 views1 answer
Laravel best practices
PHP
2 votes272 views2 answers
Laravel run controller from command line
PHP
-2 votes179 views5 answers
Www.roblox.com
PHP
0 vote211 views1 answer
Warning: require(C:\xampp\htdocs\ilsa\phpapiboatekapp\public/../vendor/autoload.php): failed to open stream: No such file or directory in C:\xampp\htdocs\ilsa\phpapiboatekapp\public\index.php on line 34
PHP