Query with sum many columns from same table with laravel query

Question

This seems very easy query but can't translate it into laravel query. I have table orders there are two columns total_usd and total_gbp. I want to sum each column to get total of usd and total of gbp on the page.

This query is working in phpmyadmin and I got correct result

SELECT sum(order_total_usd) as usd, sum(order_total_gbp) as gbp FROM `orders`

In laravel I've tried this

$sumOrders = Order::select('sum(order_total_gbp) as gbp, sum(order_total_usd) as usd');

when I dd($sumOrders) I've one really huge output which almost cause browser to freeze. Where is my mistake here?

Yashvantsinh Zala · Accepted Answer · 2017-07-19 11:27:55Z

1

You can try something like this

$sumOrders = Order::select( \DB::raw("sum(order_total_gbp) as gbp"),  \DB::raw("sum(order_total_usd) as usd"))->get();

answered Jul 19, 2017 at 11:27

Yashvantsinh Zala

5311 gold badge3 silver badges11 bronze badges

Sign up to request clarification or add additional context in comments.

5 Comments

user7956165 Over a year ago

Okay, thanks. Now when I dd($sumOrders['gbp']) in order to access the sum of gdp I've got Undefined index: gdp.

Sagar Gautam Over a year ago

You have to get like $sumOrders->gdp

user7956165 Over a year ago

When I dd($sumOrders->gbp) I've got ErrorException: Undefined property: Illuminate\Database\Eloquent\Builder::$gbp. When I dd($sumOrders) I've got one relatively long array and inside I can see array(2) { ["gbp"]=> float(0.43829558) ["usd"]=> float(27) }

user7956165 Over a year ago

Okay got it to work. I've changed ->get() with ->first() at the end and now is working. Thanks

Yashvantsinh Zala Over a year ago

@Ivan Glad I could help! :) –

vijaykumar · Accepted Answer · 2017-07-19 11:31:39Z

0

You can use selectRaw

$sumOrders = Order::selectRaw('sum(order_total_gbp) as gbp, sum(order_total_usd) as usd');

answered Jul 19, 2017 at 11:31

vijaykumar

4,8367 gold badges40 silver badges56 bronze badges

1 Comment

user7956165 Over a year ago

Thanks but this return again ErrorException: Undefined property: Illuminate\Database\Eloquent\Builder::$gbp

alex t · Accepted Answer · 2022-10-31 04:40:58Z

0

Except for one missed word, your code is OK. Add "Raw" after "select" as shown:

$sumOrders = 
Order::selectRaw(
    'sum(order_total_gbp) as gbp, 
    sum(order_total_usd) as usd'
);

Just replace "Order::select(...)" with Order::selectRaw(...).

Have a great day!

answered Oct 31, 2022 at 4:40

alex t

8618 silver badges9 bronze badges

Collectives™ on Stack Overflow

Query with sum many columns from same table with laravel query

3 Answers 3

5 Comments

1 Comment

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

5 Comments

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Related