public function digitalCatalogs()
{
$page = 'produtos';
$websiteSettings = \App\Exceptions\Handler::readFile("websiteSettings.json");
$pages = Pages::where('slug', '=', $page)->first();
$productsCategories = ProductsCategories::orderBy('sortorder', 'asc')->get();
$activePrinciples = Products::addSelect(DB::raw('DISTINCT(activePrinciple)'))->where('activePrinciple', '!=', '')->orderBy('activePrinciple', 'asc')->get();
foreach ($activePrinciples as $activePrinciple) {
array_add($activePrinciple, 'activePrincipleSlug', str_slug($activePrinciple->activePrinciple, '-'));
}
$digitalCatalogs = DigitalCatalogs::orderBy('sortorder', 'asc')->paginate(3);
$categoryChosen = "Catálogos Digitais";
$categoryChosenSlug = "catalogos-digitais";
return view('website.products.digitalCatalogs')->with(compact('page', 'pages', 'websiteSettings', 'productsCategories', 'digitalCatalogs', 'categoryChosen', 'categoryChosenSlug', 'activePrinciples', 'activePrincipleChosenSlug'));
}
public function goUrl($slug, Slider $slider, Pages $pages)
{
$this->data['slides'] = $slider->getActive();
$this->data['content'] = $pages->getActive($slug);
//dd( $this->data['content']);
return view('pages.page', $this->data);
}
public function index()
{
$page = 'conselhos-regionais';
$websiteSettings = \App\Exceptions\Handler::readFile("websiteSettings.json");
$pages = Pages::where('slug', '=', $page)->first();
$text = Texts::find(10);
return view('website.regionalCouncils.index')->with(compact('page', 'pages', 'websiteSettings', 'text'));
}
public function index()
{
$page = 'seu-negocio-mais-lucrativo';
$websiteSettings = \App\Exceptions\Handler::readFile("websiteSettings.json");
$pages = Pages::where('slug', '=', $page)->first();
$text = Texts::find(18);
return view('website.yourBusinessMoreLucrative.index')->with(compact('page', 'pages', 'websiteSettings', 'text'));
}
public function index()
{
$page = 'instituto-bulla';
$websiteSettings = \App\Exceptions\Handler::readFile("websiteSettings.json");
$pages = Pages::where('slug', '=', $page)->first();
$text = Texts::find(19);
return view('website.bullaInstitute.index')->with(compact('page', 'pages', 'websiteSettings', 'text'));
}
public function reliabilityAndQuality()
{
$page = 'medicamentos-genericos';
$websiteSettings = \App\Exceptions\Handler::readFile("websiteSettings.json");
$pages = Pages::where('slug', '=', $page)->first();
$texts = ReliabilityAndQuality::orderBy('sortorder', 'ASC')->get();
return view('website.genericsMedications.reliabilityAndQuality')->with(compact('page', 'pages', 'websiteSettings', 'texts'));
}
public function index()
{
$page = 'universidade-teuto';
$websiteSettings = \App\Exceptions\Handler::readFile("websiteSettings.json");
$pages = Pages::where('slug', '=', $page)->first();
$text = Texts::find(4);
return view('website.teutoUniversity.index')->with(compact('page', 'pages', 'websiteSettings', 'text'));
}
public function index()
{
$page = 'o-teuto';
$websiteSettings = \App\Exceptions\Handler::readFile("websiteSettings.json");
$pages = Pages::where('slug', '=', $page)->first();
$text = Texts::find(1);
$movie = Texts::find(17);
return view('website.theTeuto.index')->with(compact('page', 'pages', 'websiteSettings', 'text', 'movie'));
}
public function index()
{
$page = 'farmacovigilancia';
//WEBSITE SETTINGS
$websiteSettings = \App\Exceptions\Handler::readFile("websiteSettings.json");
$pages = Pages::where('slug', '=', $page)->first();
$text = Texts::find(6);
return view('website.farmacovigilance.index')->with(compact('page', 'websiteSettings', 'pages', 'text'));
}
public function prev($id, $seo)
{
if (Auth::check()) {
echo 'tak';
} else {
echo 'nie';
}
$prev = Pages::with('files')->findOrFail($id);
return view('frontend.pages')->with(['page' => $prev]);
}
public function getResetWebsite($token = null)
{
$page = 'recuperar-senha';
$websiteSettings = \App\Exceptions\Handler::readFile("websiteSettings.json");
$pages = Pages::where('slug', '=', $page)->first();
$user = PasswordResets::where('token', '=', $token)->first();
if (is_null($token)) {
throw new NotFoundHttpException();
}
return view('website.profile.recoveryPassword')->with(compact('token', 'page', 'websiteSettings', 'pages', 'user'));
}
public function index()
{
$page = 'trabalhe-conosco';
//WEBSITE SETTINGS
$websiteSettings = \App\Exceptions\Handler::readFile("websiteSettings.json");
$pages = Pages::where('slug', '=', $page)->first();
$link = Texts::find(5);
$mainText = Texts::find(16);
$complementText = Texts::find(12);
$vacancies = WorkWithUsVacancies::orderBy('sortorder', 'asc')->get();
return view('website.workWithUs.index')->with(compact('page', 'websiteSettings', 'pages', 'link', 'mainText', 'complementText', 'vacancies'));
}
public function index(Request $request)
{
$page = 'eventos';
$websiteSettings = \App\Exceptions\Handler::readFile("websiteSettings.json");
$pages = Pages::where('slug', '=', $page)->first();
$type = 0;
if (!empty($request->type) and $request->type == "internacionais") {
$type = 1;
}
$events = Events::orderBy('date', 'desc')->where('type', '=', $type)->paginate(5);
return view('website.events.index')->with(compact('page', 'pages', 'websiteSettings', 'request', 'events'));
}
public function putEdit(Request $request)
{
if (!ACL::hasPermission('pages', 'edit')) {
return redirect(route('pages'))->withErrors(['Você não tem permissão para editar as páginas.']);
}
$this->validate($request, ['description' => 'required|max:200', 'keywords' => 'required'], ['description.required' => 'Informe a descrição da página', 'description.max' => 'A descrição da página não pode ter mais de :max caracteres', 'keyword.required' => 'Informe as palavras-chave da página']);
$pages = Pages::find($request->pagesId);
$pages->description = $request->description;
$pages->keywords = $request->keywords;
$pages->save();
$success = "Página editada com sucesso!";
return redirect(route('pages'))->with(compact('success'));
}
public function index()
{
$page = 'o-concurso';
$websiteSettings = \App\Exceptions\Handler::readFile("websiteSettings.json");
$pages = Pages::where('slug', '=', $page)->first();
$advertising = Advertising::orderByRaw("RAND()")->get();
foreach ($advertising as $ad) {
array_add($ad, "image", Advertising::imageVideo($ad->url));
array_set($ad, "url", Advertising::embedVideo($ad->url, 1));
}
$calls = Calls::orderByRaw("RAND()")->limit(2)->get();
$theCompetition = TheCompetition::find(1);
return view('website.theCompetition')->with(compact('page', 'websiteSettings', 'pages', 'advertising', 'calls', 'theCompetition'));
}
public function imcCalculator(Request $request)
{
$page = 'material-de-apoio';
$websiteSettings = \App\Exceptions\Handler::readFile("websiteSettings.json");
$pages = Pages::where('slug', '=', $page)->first();
$imc = "";
if ($request->method() == "POST") {
$this->validate($request, ['height' => 'required|max:4', 'weight' => 'required|max:6'], ['height.required' => 'Informe a sua altura', 'height.max' => 'A altura não pode passar de :max caracteres', 'weight.required' => 'Informe o seu peso', 'weight.max' => 'O peso não pode passar de :max caracteres']);
$weight = str_replace(',', '.', $request->weight);
$height = str_replace(',', '.', $request->height);
$imc = intval($weight / ($height * $height));
}
return view('website.supportMaterial.imcCalculator')->with(compact('page', 'pages', 'websiteSettings', 'imc'));
}
public function index()
{
$page = 'ganhadores-2014';
$websiteSettings = \App\Exceptions\Handler::readFile("websiteSettings.json");
$pages = Pages::where('slug', '=', $page)->first();
$advertising = Advertising::orderByRaw("RAND()")->get();
foreach ($advertising as $ad) {
array_add($ad, "image", Advertising::imageVideo($ad->url));
array_set($ad, "url", Advertising::embedVideo($ad->url, 1));
}
$calls = Calls::orderByRaw("RAND()")->limit(2)->get();
$winners = WinnersLastYear::orderBy('winnersLastYearId', 'ASC')->get();
return view('website.winners2014')->with(compact('page', 'websiteSettings', 'pages', 'advertising', 'calls', 'winners'));
}
public function index()
{
$page = 'cadastre-se';
//WEBSITE SETTINGS
$websiteSettings = \App\Exceptions\Handler::readFile("websiteSettings.json");
//STATES
$statesConsult = \App\Exceptions\Handler::readFile("states.json");
$states = ['' => 'Estado'];
foreach ($statesConsult as $state) {
$states[$state['name']] = $state['name'];
}
$pages = Pages::where('slug', '=', $page)->first();
return view('website.registration.index')->with(compact('page', 'websiteSettings', 'pages', 'states'));
}
public function getResetWebsite($token = null)
{
$page = 'recuperar-senha';
$websiteSettings = \App\Exceptions\Handler::readFile("websiteSettings.json");
$pages = Pages::where('slug', '=', $page)->first();
$advertising = Advertising::orderByRaw("RAND()")->get();
foreach ($advertising as $ad) {
array_add($ad, "image", Advertising::imageVideo($ad->url));
array_set($ad, "url", Advertising::embedVideo($ad->url, 1));
}
$calls = Calls::orderByRaw("RAND()")->limit(2)->get();
if (is_null($token)) {
throw new NotFoundHttpException();
}
return view('website.recoveryPassword')->with(compact('token', 'page', 'websiteSettings', 'pages', 'advertising', 'calls', 'awards'));
}
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 read(Request $request)
{
$page = 'blog';
$websiteSettings = \App\Exceptions\Handler::readFile("websiteSettings.json");
$pages = Pages::where('slug', '=', $page)->first();
$date = $request->year . '-' . $request->month . '-' . $request->day;
$blog = Blog::where('date', '=', $date)->where('slug', '=', $request->slug)->first();
array_set($blog, "date", Carbon::createFromFormat('Y-m-d', $blog->date));
//INCREMENT
Blog::find($blog->blogId)->increment('read');
//MORE BLOG
$moreBlog = Blog::orderBy('date', 'desc')->where('blogId', '!=', $blog->blogId)->limit(2)->addSelect('title')->addSelect('date')->addSelect('slug')->get();
foreach ($moreBlog as $item) {
array_set($item, "date", Carbon::createFromFormat('Y-m-d', $item->date));
}
return view('website.blog.intern')->with(compact('page', 'pages', 'websiteSettings', 'blog', 'moreBlog'));
}
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 watch(Request $request)
{
$page = 'videos-3d';
$websiteSettings = \App\Exceptions\Handler::readFile("websiteSettings.json");
$pages = Pages::where('slug', '=', $page)->first();
$date = $request->year . '-' . $request->month . '-' . $request->day;
$movie3D = Movies3D::where('date', '=', $date)->where('slug', '=', $request->slug)->first();
array_set($movie3D, "date", Carbon::createFromFormat('Y-m-d', $movie3D->date));
array_set($movie3D, "url", Movies3D::embedVideo($movie3D->url, true));
//INCREMENT
Movies3D::find($movie3D->movies3DId)->increment('watch');
//MORE BLOG
$moreMovies3D = Movies3D::orderBy('date', 'desc')->where('movies3DId', '!=', $movie3D->movies3DId)->limit(2)->addSelect('title')->addSelect('date')->addSelect('slug')->get();
foreach ($moreMovies3D as $item) {
array_set($item, "date", Carbon::createFromFormat('Y-m-d', $item->date));
}
return view('website.movies3D.intern')->with(compact('page', 'pages', 'websiteSettings', 'movie3D', 'moreMovies3D'));
}
public function index()
{
$page = 'contato';
//WEBSITE SETTINGS
$websiteSettings = \App\Exceptions\Handler::readFile("websiteSettings.json");
//STATES
$statesConsult = \App\Exceptions\Handler::readFile("states.json");
$states = ['' => 'UF'];
foreach ($statesConsult as $state) {
$states[$state['uf']] = $state['uf'];
}
$pages = Pages::where('slug', '=', $page)->first();
$advertising = Advertising::orderByRaw("RAND()")->get();
foreach ($advertising as $ad) {
array_add($ad, "image", Advertising::imageVideo($ad->url));
array_set($ad, "url", Advertising::embedVideo($ad->url, 1));
}
$calls = Calls::orderByRaw("RAND()")->limit(2)->get();
return view('website.contact')->with(compact('page', 'websiteSettings', 'pages', 'advertising', 'calls', 'states'));
}
public function getAddress()
{
$page = 'meu-endereco';
//WEBSITE SETTINGS
$websiteSettings = \App\Exceptions\Handler::readFile("websiteSettings.json");
//STATES
$statesConsult = \App\Exceptions\Handler::readFile("states.json");
$states = ['' => 'Estado'];
foreach ($statesConsult as $state) {
$states[$state['name']] = $state['name'];
}
//CITIES
$citiesConsult = Cities::where('uf', '=', '' . Auth::getUser()->state . '')->get();
$cities = ['' => 'Cidade'];
foreach ($citiesConsult as $city) {
$cities[$city['name']] = $city['name'];
}
$pages = Pages::where('slug', '=', $page)->first();
return view('website.profile.address')->with(compact('page', 'websiteSettings', 'pages', 'states', 'cities'));
}
public function index()
{
$page = 'finalistas';
$websiteSettings = \App\Exceptions\Handler::readFile("websiteSettings.json");
if ($websiteSettings['votingOk'] == 0) {
$message = "A página que você tentou acessar está indisponível no momento ou não existe";
return redirect('/')->with(compact('message'));
}
$pages = Pages::where('slug', '=', $page)->first();
$advertising = Advertising::orderByRaw("RAND()")->get();
foreach ($advertising as $ad) {
array_add($ad, "image", Advertising::imageVideo($ad->url));
array_set($ad, "url", Advertising::embedVideo($ad->url, 1));
}
$calls = Calls::orderByRaw("RAND()")->limit(2)->get();
$finalistsPhotos = Photos::where('photos.status', '=', 2)->where('urlInstagram', '!=', '')->join('users', 'users.id', '=', 'photos.usersId')->addSelect('users.babyName')->addSelect('users.city')->addSelect('users.state')->addSelect('photos.usersId')->addSelect('photos.photo')->addSelect('photos.urlInstagram')->orderByRaw('RAND()')->get();
$finalistsVideos = Videos::where('videos.status', '=', 2)->where('urlInstagram', '!=', '')->join('users', 'users.id', '=', 'videos.usersId')->addSelect('users.babyName')->addSelect('users.city')->addSelect('users.state')->addSelect('videos.url')->addSelect('videos.urlInstagram')->orderByRaw('RAND()')->get();
foreach ($finalistsVideos as $wiVi) {
array_add($wiVi, "image", Advertising::imageVideo($wiVi->url));
}
return view('website.finalists')->with(compact('page', 'websiteSettings', 'pages', 'advertising', 'calls', 'finalistsPhotos', 'finalistsVideos'));
}
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 index()
{
$page = 'inscricao';
//WEBSITE SETTINGS
$websiteSettings = \App\Exceptions\Handler::readFile("websiteSettings.json");
if ($websiteSettings['registerOk'] == 0) {
$message = "A página que você tentou acessar está indisponível no momento ou não existe";
return redirect('/')->with(compact('message'));
}
//STATES
$statesConsult = \App\Exceptions\Handler::readFile("states.json");
$states = ['' => 'UF'];
foreach ($statesConsult as $state) {
$states[$state['uf']] = $state['uf'];
}
$pages = Pages::where('slug', '=', $page)->first();
$advertising = Advertising::orderByRaw("RAND()")->get();
foreach ($advertising as $ad) {
array_add($ad, "image", Advertising::imageVideo($ad->url));
array_set($ad, "url", Advertising::embedVideo($ad->url, 1));
}
$calls = Calls::orderByRaw("RAND()")->limit(2)->get();
return view('website.registration')->with(compact('page', 'websiteSettings', 'pages', 'advertising', 'calls', 'states'));
}
/**
* Отображает страницу с картой сайта
*
*/
public function getSitemapPage(Request $request)
{
$cats = Cache::remember('cats', 10, function () {
return Cat::roots()->get();
});
$pages = Pages::all();
$news = Cache::remember('news_sitemap', 3600, function () {
$news = News::where('date_publish', '<=', Carbon::parse(Carbon::now())->format('Y-m-d H:i'))->where('category', '=', 0)->get();
return $news;
});
$ogoloshenia = News::where('date_publish', '<=', Carbon::parse(Carbon::now())->format('Y-m-d H:i'))->where('category', '=', 1)->get();
return view('auction.sitemap', ['categories' => $cats, 'currentCategory' => null, 'request' => $request, 'pages' => $pages, 'news' => $news, 'ogoloshenia' => $ogoloshenia]);
}
public function getPageWithTheme()
{
$path = Route::getCurrentRoute()->getPath();
$page = Pages::where(['slug' => $path])->firstOrFail();
return view($path, ['page' => $page]);
}
