public function read(Request $request) { $page = 'noticias-e-releases'; $websiteSettings = \App\Exceptions\Handler::readFile("websiteSettings.json"); $pages = Pages::where('slug', '=', $page)->first(); $date = $request->year . '-' . $request->month . '-' . $request->day; $newsAndReleases = NewsAndReleases::where('date', '=', $date)->where('slug', '=', $request->slug)->first(); array_set($newsAndReleases, "date", Carbon::createFromFormat('Y-m-d', $newsAndReleases->date)); //INCREMENT NewsAndReleases::find($newsAndReleases->newsAndReleasesId)->increment('read'); //MORE NEWS AND RELEASES $moreNewsAndReleases = NewsAndReleases::orderBy('date', 'desc')->where('newsAndReleasesId', '!=', $newsAndReleases->newsAndReleasesId)->limit(2)->addSelect('title')->addSelect('date')->addSelect('slug')->get(); foreach ($moreNewsAndReleases as $item) { array_set($item, "date", Carbon::createFromFormat('Y-m-d', $item->date)); } return view('website.newsAndReleases.intern')->with(compact('page', 'pages', 'websiteSettings', 'newsAndReleases', 'moreNewsAndReleases')); }
public function post(Request $request) { $page = 'busca'; $websiteSettings = \App\Exceptions\Handler::readFile("websiteSettings.json"); $pages = Pages::where('slug', '=', $page)->first(); if (!$request->inputSearch) { return redirect('/')->with('message', 'Informe algum conteúdo para a busca.'); } $blog = Blog::where('title', 'LIKE', '%' . $request->inputSearch . '%')->orWhere('subtitle', 'LIKE', '%' . $request->inputSearch . '%')->orderBy('date', 'desc')->get(); foreach ($blog as $item) { array_set($item, "date", Carbon::createFromFormat('Y-m-d', $item->date)); } $newsAndReleases = NewsAndReleases::where('title', 'LIKE', '%' . $request->inputSearch . '%')->orWhere('subtitle', 'LIKE', '%' . $request->inputSearch . '%')->orderBy('date', 'desc')->get(); foreach ($newsAndReleases as $item) { array_set($item, "date", Carbon::createFromFormat('Y-m-d', $item->date)); } return view('website.search.index')->with(compact('page', 'pages', 'websiteSettings', 'request', 'blog', 'newsAndReleases')); }
public function index() { $page = 'home'; $websiteSettings = \App\Exceptions\Handler::readFile("websiteSettings.json"); $pages = Pages::where('slug', '=', $page)->first(); $banners = Banners::orderByRaw("RAND()")->get(); $newsAndReleases = NewsAndReleases::orderBy('date', 'desc')->limit(6)->get(); foreach ($newsAndReleases as $item) { array_set($item, 'date', Carbon::createFromFormat('Y-m-d', $item->date)); } $blog = Blog::orderBy('date', 'desc')->limit(3)->get(); foreach ($blog as $item) { array_set($item, 'date', Carbon::createFromFormat('Y-m-d', $item->date)); } $products = Products::getHomeCategories(); $workWithUsHomeText = Texts::find($this->homeTextId); $workWithUsLink = Texts::find($this->linkId); $workWithUsImage = Texts::find($this->imageId); $calls = Calls::orderByRaw("RAND()")->limit(3)->get(); $videoTheTeuto = Texts::find($this->videoTheTeuto); return view('website.home')->with(compact('page', 'pages', 'websiteSettings', 'banners', 'newsAndReleases', 'blog', 'products', 'workWithUsHomeText', 'workWithUsLink', 'workWithUsImage', 'calls', 'videoTheTeuto')); }
public function delete(Request $request) { if (!ACL::hasPermission('newsAndReleases', 'delete')) { return redirect(route('newsAndReleases'))->withErrors(['Você não tem permissão para deletar.']); } if ($request->image != "") { if (File::exists($this->folder . $request->image)) { File::delete($this->folder . $request->image); } } NewsAndReleases::find($request->get('newsAndReleasesId'))->delete(); $success = "Notícia/Release excluída com sucesso."; return redirect(route('newsAndReleases'))->with(compact('success')); }