Laravel eloquent query with

Question

This query returns all groups with an id however it also returns all the products to every group.

$groups = \App\Group::where('campaign_id', $id)->with('product')->get();
    dd($groups->toArray());array:2 [▼

This is the output.

0 => array:6 [▼
    "id" => 24
    "campaign_id" => "TRE36934"
    "group_name" => "group2"
    "created_at" => "2017-05-17 16:14:55"
    "updated_at" => null
    "product" => array:4 [▼
      0 => array:8 [▶]
      1 => array:8 [▶]
      2 => array:8 [▶]
      3 => array:8 [▶]

I am trying to return the groups with same id. Can I somehow query? The join in the id in the groups table and the foreign key in call 'group' in the group table.

Trying to run products that belong to a group. So the product array. Should be products with the same camapign_id. — LeBlaireau
– LeBlaireau, Commented May 18, 2017 at 12:50

Mozammil · Accepted Answer · 2017-05-18 12:41:06Z

2

A simple inner join should suffice here, right?

$groups = \App\Group::join('product', 'group.campaign_id', '=', 'product.group')
                    ->where('group.campaign_id', $id)
                    ->get();

answered May 18, 2017 at 12:41

Mozammil

8,77017 silver badges30 bronze badges

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

Comments

vipin · Accepted Answer · 2017-05-18 13:22:37Z

2

try :

$groups = Group::join('product', 'group.campaign_id', '=', 'product.group')
                    ->where('group.campaign_id', $id)
                    ->get();

answered May 18, 2017 at 13:22

vipin

2,5101 gold badge22 silver badges37 bronze badges

Comments

Mathieu Ferre · Accepted Answer · 2017-05-18 12:57:03Z

1

If you want to get your product with the same campaing id, you can do the following :

$products = Product::get()->groupBy('campaign_id');

Or you can do it directly from SQL

So, if you want a collection of Product, use your product model :)

answered May 18, 2017 at 12:57

Mathieu Ferre

4,4671 gold badge16 silver badges31 bronze badges

Comments

MevlütÖzdemir · Accepted Answer · 2017-05-18 13:01:22Z

1

I'm not sure but you may try this:

$group = \App\Group::where('campaign_id', $id)->get();
$group->load('products');

answered May 18, 2017 at 13:01

MevlütÖzdemir

3,4981 gold badge27 silver badges33 bronze badges

Comments

LeBlaireau · Accepted Answer · 2017-05-18 13:16:52Z

0

Thanks for all your replies they all got me a bit cloer

$products = \App\Product::join('groups', 'groups.id', '=', 'products.group')->get()->groupBy('group');

The basic groupby by Mathieu Ferre got me close. I added a join with a groupby as suggested by Mozammil on the name to give me

$products = \App\Product::join('groups', 'groups.id', '=', 'products.group')->get()->groupBy('group_name');

answered May 18, 2017 at 13:16

LeBlaireau

17.5k34 gold badges116 silver badges197 bronze badges

Collectives™ on Stack Overflow

Laravel eloquent query with

5 Answers 5

Comments

Comments

Comments

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

5 Answers 5

Comments

Comments

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related