doufan9395 2017-09-21 11:03
浏览 58
已采纳

多个表的Laravel Eloquent关系问题

In Laravel 5.5 I try to create a small application to manage products of a couple of sellers/stores.

Therefore, I have four different models like this:

Seller.php

class Attribute extends Model
{

    public function items()
    {

        return $this->belongsToMany(Item::class);
    }
}

Item.php

class Item extends Model
{

    public function seller()
    {

         return $this->belongsTo(Seller::class);
    }

    public function category()
    {

        return $this->belongsTo(Category::class);
    }

    public function attributes()
    {

        return $this->belongsToMany(Item::class);
    }
}

Category.php

class Category extends Model
{

    public function items()
    {

        return $this->hasMany(Item::class);
    }
}

Attribute.php

class Attribute extends Model
{

    public function items()
    {

        return $this->belongsToMany(Item::class);
    }
 }

For the many-to-many relation between Attributes & Items, I created a pivot table:

Schema::create('attribute_item', function (Blueprint $table) {
    $table->integer('attribute_id')->unsigned()->index();
    $table->foreign('attribute_id')->references('id')->on('attributes')->onDelete('cascade');
    $table->integer('item_id')->unsigned()->index();
    $table->foreign('item_id')->references('id')->on('items')->onDelete('cascade');
    $table->primary(['attribute_id', 'item_id']);
});

The goal of the entire application is to:

  • fetch all items of a seller by category with attributes (for filtering or something)
  • Fetch a specific item of an seller and get its attributes and category

I'm a little bit confused by Laravels relationhip methods and which one to use in that case.

May it is better to hasManyThrough or polymorphic relationhips?

I have to admit that I have a little logic problem here. Hopefully you can help me.

Thank you!

  • 写回答

1条回答 默认 最新

  • dpdx51205 2017-09-21 13:27
    关注

    You can use whereHas method to find the nested relationship let's for example your first goal

    fetch all items from a seller by category with attributes (for filtering or something)

    You may write the following:

    $items = Item::whereHas('seller.items', function ($query) {
            $query->whereHas('categories', function ($categories) {
                $categories->where('name', '=', 'Mens');
            })
            ->orWhereHas('attributes', function ($attributes) {
                $attriutes->where('size', '=', 'large');
            });
        })->get();
    

    Find out more about this: https://laravel.com/docs/5.5/eloquent-relationships#querying-relationship-existence

    This will give you the list of items if you want to get items with categories and attributes you can use with method to get the relational data:

    $items = Item::whereHas('seller.items', function ($query) {
            $query->whereHas('categories', function ($caegories) {
                $categories->where('name', '=', 'Mens');
            })
            ->orWhereHas('attributes', function ($attributes) {
                $atributes->where('size', '=', 'large');
            });
        })
        ->with('categories', 'attributes')
        ->get();
    

    Hope this guide you the problem which you are facing.

    本回答被题主选为最佳回答 , 对您是否有帮助呢?
    评论

报告相同问题?

悬赏问题

  • ¥18 深度学习tensorflow1,ssdv1,coco数据集训练一个模型
  • ¥100 关于注册表摄像头和麦克风的问题
  • ¥30 代码本地运行正常,但是TOMCAT部署时闪退
  • ¥15 关于#python#的问题
  • ¥15 主机可以ping通路由器但是连不上网怎么办
  • ¥15 数据库一张以时间排好序的表中,找出多次相邻的那些行
  • ¥50 关于DynamoRIO处理多线程程序时候的问题
  • ¥15 kubeadm部署k8s出错
  • ¥15 Abaqus打不开cae文件怎么办?
  • ¥15 小程序准备上线,软件开发公司需要提供哪些资料给甲方