duanduo3712 2019-01-16 02:44
浏览 71
已采纳

Laravel Eloquent Eager从多个表中加载

I'm relatively new to Laravel and only recently started to learn about eager loading. Currently, I have a project in which I was required to develop an app for connection between companies and partners.

Connection can either be between company-company, partner-partner or company-partner. For now, I stored all the connections in one Connection table as shown here:

In Connection class, I use polymorphic to retrieve all the connections for a company/partner:

public function connectable()
{
    return $this->morphTo();
}

And this function in Partner and Company classes:

public function my_connection()
{
    return $this->morphMany(Connection::class, 'connectable', 'model_type', 'model_id');
}

I can retrieve the list of connections just fine, but problem arise when I want to get the details for each connected company/partner. I want to use eager load in Connection class as below but it only manage to either get from company or partner but not both

protected $with = [
    'following'
];

public function following()
{
    return $this->belongsTo(Company::class, 'connect_to', 'id');
}

Is it possible to do this? Or should I separate company and partner connections into different tables?

Edit: By connection, I meant a partner or company can connect/follow each other like the usual social media app. It wasn't mutual tho. Say, if Partner A follow Partner B, then only that connection will be stored. Partner B is still considered not connected to A.

  • 写回答

1条回答 默认 最新

  • douwu5009 2019-01-16 08:41
    关注

    I am not sure exactly which model do you want to eager load (i.e. model_type or connect_type), but in either case you can use a morphTo relation, as in:

    public function following()
        {
            return $this->morphTo(null, $type = 'connect_type', $id = 'connect_to');
        }
    
    本回答被题主选为最佳回答 , 对您是否有帮助呢?
    评论

报告相同问题?

悬赏问题

  • ¥15 怎么实现输入一个要删除的数后删除后显示剩余数再输入再删除显示剩余数(语言-c语言)
  • ¥35 引用csv数据文件(4列1800行),通过高斯-赛德尔法拟合曲线,在选取(每五十点取1点)数据,求该数据点的曲率中心。
  • ¥20 程序只发送0X01,串口助手显示不正确,配置看了没有问题115200-8-1-no,如何解决?
  • ¥15 Google speech command 数据集获取
  • ¥15 vue3+element-plus页面崩溃
  • ¥15 像这种代码要怎么跑起来?
  • ¥15 安卓C读取/dev/fastpipe屏幕像素数据
  • ¥15 pyqt5tools安装失败
  • ¥15 mmdetection
  • ¥15 nginx代理报502的错误