public function getVideo($year = null) { settype($year, 'integer'); if (preg_match('/\\d{4}/', $year)) { return Videos::where('year', '=', $year)->get(); } }
public function postSentVideo(Request $request) { $video = Videos::where('usersId', '=', $request->userId)->addSelect('url')->get(); foreach ($video as $vi) { array_add($vi, "image", Advertising::imageVideo($vi->url)); } return json_encode($video); }
public function getUserVideos() { $title1 = 'Your'; $title = 'Account'; $UserId = \Auth::user()->id; $Videos = Videos::where('user_id', $UserId)->get(); return view('UserVideos')->with('Videos', $Videos)->with('title1', $title1)->with('title', $title); }
public function getFinalist($videosId) { if (!ACL::hasPermission('videos', 'edit')) { return redirect(route('videos'))->withErrors(['Você não tem permissão para editar o status dos vídeos.']); } $video = Videos::where('videos.videosId', '=', $videosId)->join('users', 'users.id', '=', 'videos.usersId')->orderBy('videos.created_at', 'DESC')->addSelect('videos.videosId')->addSelect('videos.created_at')->addSelect('videos.url')->addSelect('videos.urlInstagram')->addSelect('videos.status')->addSelect('users.id AS userId')->addSelect('users.babyName')->addSelect('users.name')->first(); array_add($video, "image", Advertising::imageVideo($video->url)); return view('admin.videos.finalist')->with(compact('video')); }
public function postCategory(Request $request) { if ($request->table == 'videos') { $consult = Videos::where('status', '=', 2)->where('winner', '=', 0)->join('users', 'videos.usersId', '=', 'id')->get(); } else { if ($request->table == 'photos') { $consult = Photos::where('status', '=', 2)->where('winner', '=', 0)->join('users', 'photos.usersId', '=', 'id')->get(); } } return json_encode($consult); }
public function getView($usersId) { if (!ACL::hasPermission('participants')) { return redirect(route('participants'))->withErrors(['Você não tem permissão para visualizar dados dos participantes.']); } $user = User::where('id', '=', $usersId)->first(); $photos = Photos::where('usersId', '=', $usersId)->get(); $videos = Videos::where('usersId', '=', $usersId)->get(); foreach ($videos as $video) { array_add($video, "image", Advertising::imageVideo($video->url)); array_set($video, "url", Advertising::embedVideo($video->url, 1)); } $usersReceipts = UsersReceipts::where('usersId', '=', $usersId)->get(); return view('admin.participants.view')->with(compact('user', 'photos', 'videos', 'usersReceipts')); }
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 displayVideo($id) { $videoName = Videos::where('id', $id)->first(); $videoUrl = $videoName->video_url; $watchVideoTitle = Videos::where('id', $id)->pluck('video_name'); $title1 = 'Watch'; $title = $watchVideoTitle; $videoInfo = $videoName; return view('watchVideo')->with('videoInfo', $videoName)->with('title1', $title1)->with('title', $title)->with('videoUrl', $videoUrl); }
public function upvote($id) { if (Config('app.voting_on') || Auth::user()->admin == 1) { $video = Videos::where('id', '=', $id)->first(); $video->voteSuffix = $video->videoRating != 1 ? "votes" : "vote"; if (!(Auth::user()->admin == 1)) { if (null !== Session::get('user.votes')) { if (count(Session::get('user.votes')) < 3) { foreach (Session::get('user.votes') as $existingVote) { if ($existingVote == $id) { // Video previously voted for return $video->videoRating . " " . $video->voteSuffix . " – You've already voted!"; } } } else { return $video->videoRating . " " . $video->voteSuffix . " – You've run out of votes!"; } } } // Video not previously voted for Videos::where('id', '=', $id)->increment('videoRating'); Session::push('user.votes', $id); $video = Videos::where('id', '=', $id)->first(); $video->voteSuffix = $video->videoRating != 1 ? "votes" : "vote"; return $video->videoRating . " " . $video->voteSuffix . " – Thanks for your vote!"; } }
public function videos($usersId) { return Videos::where('usersId', '=', $usersId); }