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')); }