how to perform a sum with laravel in an eloquent relationship

Question

I have a detail table where there is a relationship with the product table, in the detail table I have a product_id field.

I try to multiply the quantity that appears in the detail table and the price that appears in the product table, used DB ::raw but I get a column error not found.

QueryScope in Detalle Model

 $query->with(['product' => function ($query) {
            $query->select('id', 'name', 'price');
        }])
        ->select('*', DB::raw('SUM(count*products.price) as fullcount'))
        ->groupBy('product_id');

what table/alias count column belongs to?

Alex
– Alex

2018-11-12 19:46:50 +00:00
Commented Nov 12, 2018 at 19:46 — Alex
– Alex, Commented Nov 12, 2018 at 19:46
@Alex count in table details

DarkFenix
– DarkFenix

2018-11-13 18:28:19 +00:00
Commented Nov 13, 2018 at 18:28 — DarkFenix
– DarkFenix, Commented Nov 13, 2018 at 18:28
I don't see any details table involved.

Alex
– Alex

2018-11-13 19:17:03 +00:00
Commented Nov 13, 2018 at 19:17 — Alex
– Alex, Commented Nov 13, 2018 at 19:17
@Alex That queryScope is inside the model Details

DarkFenix
– DarkFenix

2018-11-13 20:13:10 +00:00
Commented Nov 13, 2018 at 20:13 — DarkFenix
– DarkFenix, Commented Nov 13, 2018 at 20:13

Jonas Staudenmeir · Accepted Answer · 2018-11-12 20:58:35Z

1

Use a JOIN:

$query->select('product_id', DB::raw('SUM(count*products.price) as fullcount'))
    ->join('products', 'details.product_id', '=', 'products.id')
    ->groupBy('product_id');

answered Nov 12, 2018 at 20:58

Jonas Staudenmeir

26k7 gold badges70 silver badges114 bronze badges

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

2 Comments

DarkFenix Over a year ago

An additional query, what I want is that you group them if a field of the detail table has a certain value, otherwise you leave them separated Is it possible?

Jonas Staudenmeir Over a year ago

I don't think so.

Collectives™ on Stack Overflow

how to perform a sum with laravel in an eloquent relationship

1 Answer 1

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related