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