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