public function index(Request $request) { $page = 'blog'; $websiteSettings = \App\Exceptions\Handler::readFile("websiteSettings.json"); $pages = Pages::where('slug', '=', $page)->first(); $blog = Blog::orderBy('date', 'desc'); if (!empty($request->palavra)) { $palavra = urldecode($request->palavra); $blog = $blog->where('tags', 'LIKE', '%' . $palavra . '%'); } $blog = $blog->paginate(4); if (!empty($request->palavra)) { $blog->setPath('busca?palavra=' . $palavra . '&'); } foreach ($blog as $item) { array_set($item, "date", Carbon::createFromFormat('Y-m-d', $item->date)); } $tagsMoreSearchedConsult = Blog::addSelect('tags')->orderBy('read', 'DESC')->limit(10)->get(); $tags = ""; foreach ($tagsMoreSearchedConsult as $tagsMore) { $tags .= $tagsMore->tags . ","; } $tags = substr($tags, 0, -1); $tags = explode(',', $tags); shuffle($tags); $arrayTags = []; $tagsChosen = ""; $qtdTags = 0; foreach ($tags as $tag) { if (!array_search($tag, $arrayTags)) { array_push($arrayTags, $tag); $tagsChosen .= $tag . ","; $qtdTags++; } if ($qtdTags == 10) { break; } } $tagsChosen = substr($tagsChosen, 0, -1); $tagsMoreSearched = Blog::tagsList($tagsChosen, 'blog'); return view('website.blog.index')->with(compact('page', 'pages', 'websiteSettings', 'request', 'blog', 'tagsMoreSearched')); }