public function getIndex()
 {
     if (!ACL::hasPermission('newsAndReleases')) {
         return redirect(route('home'))->withErrors(['Você não pode acessar a página de Notícias e Releases.']);
     }
     $newsAndReleases = NewsAndReleases::orderBy('date', 'DESC')->get();
     foreach ($newsAndReleases as $item) {
         array_set($item, 'date', Carbon::createFromFormat('Y-m-d', $item->date)->format('d/m/Y'));
     }
     return view('admin.newsAndReleases.index')->with(compact('newsAndReleases'));
 }
 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 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'));
 }