how to get hasmany relation inside another relation in Laravel

Question

i want to get product optionGroup with product options

i made this

    $try1 = Product::with(["optionGroups.options"])->find(1);

but this return all group options

i want to get product optionGroup with product options only

i want it to be like

{
  "title": "product name",
  "optionGroups": [
    {
      "name": "Size",
      "options": [
        {
          "name": "XL",
          "price": 1200
        },
        {
          "name": "L",
          "price": 1000
        }
      ]
    }
  ]
}

models

class Product extends Model
{
    public function options()
    {
        return $this->hasMany(Option::class, 'product_id');
    }
    public function optionGroups()
    {
        return $this->belongsToMany(OptionGroup::class, 'options')->groupBy("id");
    }
}

class Option extends Model
{
    public function product()
    {
        return $this->belongsTo(\App\Models\Product::class, 'product_id', 'id');
    }
    public function optionGroup()
    {
        return $this->belongsTo(\App\Models\OptionGroup::class, 'option_group_id', 'id');
    }
}

class OptionGroup extends Model
{
    public $table = 'option_groups';
    public $fillable = [
        'name'
    ];
    public function options()
    {
        return $this->hasMany(Option::class, 'option_group_id');
    }
}

Schema::create('products', function (Blueprint $table) {
    $table->id('id');
    $table->string('title');
});
Schema::create('options', function (Blueprint $table) {
    $table->increments('id');
    $table->string('name', 127);
    $table->double('price', 8, 2)->default(0);
    $table->integer('product_id')->unsigned();
    $table->integer('option_group_id')->unsigned();
});
Schema::create('option_groups', function (Blueprint $table) {
    $table->increments('id');
    $table->string('name', 127);
});

please help me

Have you tried? Product::with(["options.optionGroup"])->find(1); — Basharmal
– Basharmal, Commented Apr 1, 2021 at 2:53

Bipin Regmi · Accepted Answer · 2021-04-01 10:46:13Z

2

Product::whereHas('optionGroups', function($query){
     $query->with(['options']);
})->first();

edited Apr 1, 2021 at 10:46

answered Apr 1, 2021 at 3:15

Bipin Regmi

1372 silver badges11 bronze badges

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

3 Comments

yemenpoint Over a year ago

This will return the group inside the option .... i want the option inside the group 👍👍

Bipin Regmi Over a year ago

@yemenpoint I just updated the answer . Once try that and let me know

yemenpoint Over a year ago

Hi Bipin this doesn't return any option or any optionGroup

Basharmal · Accepted Answer · 2021-04-01 06:02:02Z

0

Try adding this to your Product model

public function optionGroupsAndOptions()
{
    return $this->optionGroups->with('options')->where('product_id', $this->id);
}

then

$try1 = Product::with("optionGroupsAndOptions")->find(1);

answered Apr 1, 2021 at 6:02

Basharmal

1,3941 gold badge14 silver badges36 bronze badges

3 Comments

yemenpoint Over a year ago

Not work i even tried this. return $this->optionGroups()->with(["options" => function($q){ $q->where("product_id",$this->id); }]);

yemenpoint Over a year ago

$this->id is null and this["id"] is null

Basharmal Over a year ago

Try this $try1 = Product::with("optionGroupsAndOptions")->where('product_id', 1);

Collectives™ on Stack Overflow

how to get hasmany relation inside another relation in Laravel

2 Answers 2

3 Comments

3 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

3 Comments

3 Comments

Your Answer

Sign up or log in

Post as a guest

Related