mysql query in a form of laravel eloquent many to many relationship

Question

I have a query

SELECT product_id, SUM(quantity) as quantity FROM `order_product` GROUP BY product_id

the order_product is the pivot table of products and orders in which they have many to many relationship

This is my model relationship

Order model

public function products()
{
    return $this->belongsToMany('App\Product')->withPivot('quantity')->withTimestamps();
}

Product model

public function orders()
{
    return $this->belongsToMany('App\Order')->withPivot('quantity')->withTimestamps();
}

how can i use this in a form of laravel eloquent?

`order_product` is a pivot table between `order` and `product` right ? — rkj, Aug 08 '18 at 05:04
is that the proper way of fetching all of the results in order_product pivot table? because i make a model for this pivot table and just fetch all of the result. — Beginner, Aug 08 '18 at 05:06

score 1 · Accepted Answer · answered Aug 08 '18 at 05:15

1

You can fetch it like this

$products = Product::with('orders')->get(); //always eager load orders relation

Now print it

foreach($products as $product){
      echo $product->orders->sum(pivot.quantity);
}

answered Aug 08 '18 at 05:15

rkj

im trying it now sir – Beginner Aug 08 '18 at 05:42
sir https://stackoverflow.com/questions/51742584/laravel-api-resource-add-other-data – Beginner Aug 08 '18 at 08:59
sir check the link – Beginner Aug 08 '18 at 09:03
@Beginner added answer check there – rkj Aug 08 '18 at 09:31

1 Answers1