如何在 4 个表中使用 Laravel 的 hasManyThrough

关系如下:

$user->hasMany('accounts')->hasMany('contacts')->hasMany('orders');

$user->hasMany('accounts')->hasMany('contacts')->hasMany('orders');

/** User Model **/
class User extend Eloquent {
    public function accounts(){
        return $this->hasMany('Accounts');
    }

    public function contacts(){
        return $this->hasManyThrough('Contact', 'Account', 'owner_id');
    }

    //how do I get this?
    public function orders(){

    }
}

/** Account Model */
class Account extends Eloquent {
    public function $user(){
        return $this->belongsTo('User');
    }
    public function contacts(){
        return $this->hasMany('Contact');
    }
}

/** Contact Model **/
class Contact extends Eloquent {
    public function account(){
        return $this->belongsTo('Account');
    }

    public function orders(){
        return $this->hasMany('Order');
    }
}

/** Order Model **/
class Order extends Eloquent {
    public function contact(){
        return $this->belongsTo('contact');
    }
}

经典的 hasManyThrough 是不可能的，因为我们有 4 个表.

A classic hasManyThrough is not possible because we have 4 tables.

如何创建关系以便单个用户可以访问它的订单，而无需链接每个模型的方法，例如:

How can I create a relationship so that a single user can have it's orders accessed without method chaining each model, such as:

User::find(8)->orders;

推荐答案

一开始很难确定查询构建器是如何将事物切分在一起的.我知道我想如何使用原始 SQL 语句格式化查询，但我想使用 Eloquent 来完成这个特定任务，因为其他定义的关系.

It was quite difficult at first to identify exactly how the query builder slices things together. I knew how I wanted to format the query with a raw SQL statement, but I wanted to use Eloquent for this particular task given the other defined relationships.

我能够通过重载属性并手动创建关系来解决这个问题.但是，实际的查询和 hasMany 也需要手动构建.让我们来看看我是如何做到这一点的.请记住，我们的目标是通过 2 个 has-Many 关系从用户那里获得 Orders.

I was able to resolve this by overloading the attribute and manually creating the relation. However, the actual query and hasMany needs to be built manually as well. Let's take a look at how I achieved this. Remember, the goal is to get Orders off of the user through 2 has-Many relationships.

一是属性的重载.

public function getOrdersAttribute()
{
    if( ! array_key_exists('orders', $this->relations)) $this->orders();

    return $this->getRelation('orders');
}

上面函数中的想法是捕获延迟加载的->orders何时被调用.例如$user->orders.这将检查 orders 方法是否在现有 User 模型 的 relations 数组中.如果不是，那么它会调用我们的 next 函数来填充关系，最后返回我们刚刚创建的关系.

The idea in the above function is to capture when a lazy loaded ->orders is called. such as $user->orders. This checks to see if the orders method is in the relations array for the existing User model. If it's not, then it calls our next function in order to populate the relatioship, and finally returns the relationship we've just created.

这是实际查询订单的函数的样子:

This is what the function that actually queries the Orders looks like:

public function orders()
{
    $orders = Order::join('contacts', 'orders.contact_id', '=', 'contacts.id')
        ->join('accounts', 'contacts.account_id', '=', 'accounts.id')
        ->where('accounts.owner_id', $this->getkey())
        ->get();

    $hasMany = new IlluminateDatabaseEloquentRelationsHasMany(User::query(), $this, 'accounts.owner_id', 'id');

    $hasMany->matchMany(array($this), $orders, 'orders');

    return $this;
}

在上面，我们告诉 Orders 表加入它的联系人(在这种情况下，这是给定 belongsTo() 所有权的既定路由).然后从联系人中，我们加入帐户，然后从帐户中我们可以通过将我们的 owner_id 列与我们现有的 $user->id 进行匹配来从我们的用户那里获得，所以我们不需要再做任何事情了.

In the above, we tell the Orders table to join it's contacts (which is the established route given the ownership of belongsTo() in this scenario). Then from the contacts, we join the accounts, then from the accounts we can get there from our user by matching our owner_id column against our existing $user->id, so we don't need to do anything further.

接下来，我们需要通过从 Eloquent Relationship 构建器实例化 hasMany 的实例来手动创建我们的关系.

Next, we need to manually create our relationship by instantiating an instance of hasMany from the Eloquent Relationship builder.