通过N个模型的hasMany或hasMany链


Chain of hasMany or hasManyThrough through N models

如何获取属于特定用户的所有提交?尝试这个:

$user=User::find(1);        
dd($user->submissions);

引发错误:

Call to undefined method Illuminate'Database'Query'Builder::hasMany()

我必须循环浏览模型吗?

以下是型号:

class User extends Eloquent implements ConfideUserInterface, BillableInterface
{
    public function categories()
    {
        return $this->hasMany('Category');
    }
    public function forms()
    {
        return $this->hasManyThrough('App'Models'Form', 'Category');
    }
    public function submissions()
    {
        return $this->hasMany('Category')->hasMany('Form')->hasMany('Submission');
    }
}
class Category extends 'Eloquent {
    public function user()
    {
        return $this->belongsTo('User');
    }
    public function forms()
    {
        return $this->hasMany('App'Models'Form');
    }
    public function submissions()
    {
        return $this->hasManyThrough('Submission', 'App'Models'Form', 'id', 'form_id');
    }
}
namespace App'Models;
class Form extends 'Eloquent {
    public function user()
    {
        return $this->category->user();
    }
    public function category()
    {
        return $this->belongsTo('Category');
    }
    public function submissions()
    {
        return $this->hasMany('Submission');
    }
}
class Submission extends 'Eloquent {
    public function user()
    {
        return $this->form->category->user();
    }
    public function category()
    {
        return $this->form->category();
    }
    public function form()
    {
        return $this->belongsTo('App'Models'Form');
    }
}

这在链接关系中并不起作用。。。

你能做的是:

$submissions = Submission::whereHas('form.category.user', function($q){
    $q->where('id', 1);
})->get();

请注意具有嵌套关系的whereHas仅在最新的Laravel 4版本中添加。确保composer update

如果我没有误解你的问题,你需要正确定义关系。

根据laravel 4.2,您可以使用以下类型的代码来定义关系:

class User extends 'Eloquent implements ConfideUserInterface, BillableInterface{
    //...
    public function submissions(){
        return $this->hasMany('Submission');
    }
}
//...
class Submission extends 'Eloquent {
    public function user()
    {
        return $this->belongsTo('User');
    }
    //...
}

要进一步阅读,请查看:http://laravel.com/docs/4.2/eloquent#relationships