我正在用 laravel 建立一個網站。我使用這些模型：郵政國家標簽城市標簽類別標簽一個帖子可以有很多個countrytags，citytags反之亦然categorytags。我想按標簽搜索帖子。我使用這個功能： public function blogsearchresults(Request $request) { $attributes=request()->validate([ 'countrytag_id'=>'required_without_all:citytag_id,categorytag_id', 'citytag_id'=>'required_without_all:countrytag_id,categorytag_id', 'categorytag_id'=>'required_without_all:countrytag_id,citytag_id' ]); $posts=Post::all(); if($request->has('countrytag_id')) { $countryid=$attributes['countrytag_id']; $posts =$posts->whereHas('countrytags', function ($query) use ($countryid){ $query->wherein('countrytag_id', $countryid); }); } if($request->has('citytag_id')) { $cityid=$attributes['citytag_id']; $posts=$posts->whereHas('citytags', function ($query2) use ($cityid){ $query2->wherein('citytag_id', $cityid); }); } if($request->has('categorytag_id')) { $categoryid=$attributes['categorytag_id']; $posts=$posts->whereHas('categorytags', function ($query3) use ($categoryid){ $query3->wherein('categorytag_id', $categoryid); }); } $posts=$posts->paginate(); return view('pages.blog.blogsearchresults', compact('posts')); }但我得到這個錯誤：Method Illuminate\Database\Eloquent\Collection::whereHas does not exist.你能幫我解決這個問題嗎？謝謝
1 回答
慕絲7291255
TA貢獻1859條經驗 獲得超6個贊
該方法all()返回一個集合，您不能在其上使用查詢構建器方法。（同樣當您查詢構建時，您不需要一遍又一遍地分配值 $posts）
public function blogsearchresults(Request $request)
{
$attributes = request()->validate([
'countrytag_id'=>'required_without_all:citytag_id,categorytag_id',
'citytag_id'=>'required_without_all:countrytag_id,categorytag_id',
'categorytag_id'=>'required_without_all:countrytag_id,citytag_id'
]);
$postQuery = Post::query();
if($request->has('countrytag_id')) {
$countryid = $attributes['countrytag_id'];
$postQuery->whereHas('countrytags', function ($query) use ($countryid){
$query->wherein('countrytag_id', $countryid);
});
}
if($request->has('citytag_id')) {
$cityid = $attributes['citytag_id'];
$postQuery->whereHas('citytags', function ($query2) use ($cityid){
$query2->wherein('citytag_id', $cityid);
});
}
if($request->has('categorytag_id')) {
$categoryid = $attributes['categorytag_id'];
$postQuery->whereHas('categorytags', function ($query3) use ($categoryid){
$query3->wherein('categorytag_id', $categoryid);
});
}
$posts = $postQuery->paginate();
return view('pages.blog.blogsearchresults', compact('posts'));
}
- 1 回答
- 0 關注
- 129 瀏覽
添加回答
舉報
0/150
提交
取消