如何获取属于特定用户的所有提交?尝试这个:
$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