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 = '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 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 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 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 = '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 = '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 delete(Request $request)
 {
     if (!ACL::hasPermission('calls', 'delete')) {
         return redirect(route('calls'))->withErrors(['Você não pode deletar chamadas.']);
     }
     if ($request->image != "") {
         if (File::exists($this->folder . $request->image)) {
             File::delete($this->folder . $request->image);
         }
     }
     Calls::find($request->get('callsId'))->delete();
     $success = "Chamada excluída com sucesso.";
     return redirect(route('calls'))->with(compact('success'));
 }