public function search(Request $request)
{
$validator = Validator::make($request->all(), ['keyword' => 'required']);
if ($validator->fails()) {
return redirect()->back()->withErrors($validator->errors());
} else {
$this->setMetadata('Tìm kiếm');
$name = $request->input('keyword');
$limit = Config::findByKey('rows_per_page_article')->first()->value;
$articles = Article::whereHas('translations', function ($query) use($name) {
$query->where('locale', app()->getLocale())->where('is_publish', 1)->where('name', 'LIKE', '%' . $name . '%')->orderBy('priority')->orderBy('created_at', 'desc');
})->paginate($limit);
return view('frontend.sites.searchResult', ['articles' => $articles]);
}
}
public function homepage()
{
$articles = Article::with('pictures')->orderByRaw("RAND()")->take(6)->get();
$carrousselArticle = Article::whereHas('pictures', function ($query) {
$query->whereNotNull('fileentries.id');
})->orderByRaw("RAND()")->take(5)->get();
return view('online_shop.welcome.index')->with(compact('articles'))->with(compact('carrousselArticle'));
}
