/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 vote102 views1 answer
Throws php
PHP
4 votes101 views1 answer
Uuid nom package for laravel 18.04
PHP
0 vote104 views1 answer
Cakephp get present name
PHP
0 vote133 views1 answer
Laravel has many limit
PHP Laravel
4 votes98 views2 answers
Spaceship operator php
PHP
0 vote63 views1 answer
Diffinhours with minutes carbon
PHP
0 vote109 views1 answer
Laravel get limited character of string
PHP Laravel
0 vote97 views1 answer
Laravel subtract date
PHP
4 votes117 views2 answers
Add class to body class wordpress
PHP
0 vote107 views1 answer
Wordrpess debugg is off but still showing
PHP