我有一个大的搜索查询,一切都很好,但我需要向这个刀片显示每个用户的包(研讨会)
<tbody>
@foreach($users as $i=>$user)
<tr>
<td>{{ $i+1 }}</td>
<td>{{ $user->home_lastname }}</td>
<td>{{ $user->home_firstname }} </td>
//------> <td> HERE I NEED TO SHOW ALL THE PACKAGES NAMES(SEMINARS) FOR EACH USER</td>
<td>{{ $user->home_id }}</td>
<td></td>
用户控制器
$builder = User::query();
if (Input::has('lastname')) {
$queryString = Input::get('lastname');
$builder->where('home_lastname', 'LIKE', "%$queryString%");
}
if (Input::has('name')) {
$queryString = Input::get('name');
$builder->where('home_firstname', 'LIKE', "%$queryString%");
}
if (Input::has('id')) {
$queryString = Input::get('id');
$builder->where('home_id', 'LIKE', "%$queryString%");
}
if (Input::has('type-select')){
$userType = Input::get('type-select');
$builder->select('*')
->where('Home_Students.home_elv_rights',$userType)
->get();
}
if(Input::has('seminar-select')){
$seminar = Input::get('seminar-select');
$builder->select('*')
->join('Home_StudentPackages','Home_StudentPackages.hsp_homeStudID','=','Home_Students.home_id')
->join('Home_Packages','Home_Packages.Package_ID','=','Home_StudentPackages.hsp_packid')
->where('Home_Packages.Package_ID',$seminar)
->get();
}
if(Input::has('class-select')){
$class = Input::get('class-select');
$builder->select('*')
->join('Hw_StudentClasses','Hw_StudentClasses.Stclass_studentid','=','Home_Students.home_id')
->join('Hw_Classes','Hw_Classes.Class_id','=','Hw_StudentClasses.Stclass_classid')
->where('Hw_Classes.Class_id',$class)
->get();
}
if(Input::has('date_created_from')) {
$date = date("Y-m-d", strtotime(Input::get('date_created_from')));
$builder->select('*')
->whereBetween('Home_Students.home_dateCreated', [$date, date("Y-m-d")])
->get();
}
elseif(Input::has('date_created_from','date_created_untill')){
$date = date("Y-m-d", strtotime(Input::get('date_created_from')));
$date2 = date("Y-m-d", strtotime(Input::get('date_created_untill')));
$builder->select('*')
->whereBetween('Home_Students.home_dateCreated', [$date,$date2])
->get();
}
elseif(Input::has('date_created_untill')){
$date2 = date("Y-m-d", strtotime(Input::get('date_created_untill')));
$date = date("Y-m-d", strtotime(Input::get('date_created_from')));
$builder->select('*')
->whereBetween('Home_Students.home_dateCreated',[$date,$date2])
->get();
}
// ... more clauses from the querystring
$users = $builder->orderBy('home_lastname')->get();
return View::make('user.show')->with(array('users' => $users));
}
我尝试了这些连接到start$builder查询和控制器末尾的builder,但都不起作用。还有每个中的where,如果不起作用,所以我不知道其他方法。
DB::table('Home_Students')
->select('home_lastname','home_firstname','home_id','Package_Name')
->join('Home_StudentPackages','Home_StudentPackages.hsp_homeStudID','=','Home_Students.home_id')
->join('Home_Packages','Home_Packages.Package_ID','=','Home_StudentPackages.hsp_PackID'
->get();
我只需要在我的刀片视图中显示每个用户的Packages_Names,但按研讨会(Packages)搜索有问题。
编辑
我试图在用户的模型中创建公共功能,在那里我将获得每个用户的所有包(研讨会);你知道怎么做吗?
有一个将用户和包结合在一起的透视表!
EDIT 2我认为这是错误的,因为它返回[{"Package_Name":"Excel"}]-可以将其作为字符串返回吗?
public function getUserSeminars(){
$users = Seminar::select('Package_Name')
->join('Home_StudentPackages','Home_StudentPackages.hsp_PackID','=','Home_Packages.Package_ID')
->join('Home_Students','Home_Students.home_id','=','Home_StudentPackages.hsp_homeStudID')
->where('Home_Students.home_id','=',$this->home_id)
->get();
return $users;
}
为了不让搜索查询变得如此复杂,我在控制器中转到了我的用户模型,并执行了以下功能:
public function getUserSeminars(){
$seminar = Seminar::select('Package_Name')
->join('Home_StudentPackages','Home_StudentPackages.hsp_PackID','=','Home_Packages.Package_ID')
->join('Home_Students','Home_Students.home_id','=','Home_StudentPackages.hsp_homeStudID')
->where('Home_Students.home_id','=',$this->home_id)
->get();
return $seminar;
}
然后我把它叫做
<td>
@foreach($user->getUserSeminars() as $seminar)
<li> {{$seminar->Package_Name}} </li>
@endforeach
</td>
它就像一个符咒。希望这也能帮助到别人!