public function index() { if (Auth::guest()) { return view('pages.home'); } //Check to make sure gender and names are populated $user = Auth::user(); $fields = ['first_name' => $user->first_name, 'last_name' => $user->last_name, 'gender' => $user->gender]; $validation = Validator::make($fields, User::$baseRules); if (!$validation->passes()) { return redirect('user/name-and-gender'); } //Check to make sure user has choson categories if (!$this->categoryAccount->where('user_id', $user->id)->first()) { return redirect('user/categories'); } $chosenCategories = $this->categoryAccount->where('user_id', Auth::user()->id)->orderByRaw('RAND()')->get(); //Get one random task for the "one for the road" $oneForTheRoad = array(); foreach ($chosenCategories as $category) { $events = $this->event->where('type', $category->category_id)->orderByRaw('RAND()')->get(); foreach ($events as $event) { if (!$this->eventUser->where('event_id', $event->id)->where('user_id', Auth::user()->id)->first() && !$this->eventUser->where('user_id', Auth::user()->id)->where('created_at', '<=', date('Y-m-d 24:00:00'))->where('created_at', '>=', date('Y-m-d 00:00:00'))->where('complete', 1)->first()) { array_push($oneForTheRoad, ['id' => $event->id, 'name' => $event->name, 'description' => $event->description, 'class' => 'active']); } else { array_push($oneForTheRoad, ['id' => '0', 'name' => 'None for today!', 'description' => 'One for the road has completed', 'class' => 'inactive']); } } } $category = $this->category; return view('pages.dashboard', compact('category', 'chosenCategories', 'oneForTheRoad')); }
public function Home() { $flash = Event::where('start_date', '<=', new \Datetime())->where('end_date', '>=', new \Datetime())->orderBy('id', 'desc')->take(1)->get()->first(); $articles = Article::where('id', '!=', isset($flash) ? $flash->article->id : 0)->orderBy('publish_at', 'desc')->orderBy('id', 'desc')->take(5)->get(); $ffttNews = FFTTNew::orderBy('date', 'desc')->take(3)->get(); return view('front.home', array('articles' => $articles, 'NewsFlash' => $flash, 'ffttNews' => $ffttNews)); }
public function delete($id) { \App\Event::where('id', $id)->delete(); \App\EventMedia::where('eventID', $id)->delete(); \App\EventTag::where('eventID', $id)->delete(); return redirect('/'); }
public function getCalendar() { $eventos = Event::select('titulo_evento')->where('user_id', '=', Auth::user()->id)->take(4)->get(); //$datos['cTrabajo']= \DB::table('trabajo')->count(); $array = Event::where('user_id', '=', Auth::user()->id)->get(); return view('Calendar/calendar', compact('array', 'datos', 'eventos')); }
function postTask(Request $request) { $task = $request->all(); Task::create($task); $comm = Committee::where('id', $task['comm_id'])->first(); $evnt = Event::where('id', $comm['event_id'])->first(); //UPDATING WEIGHT OF COMMITTEE AND EVENT $comm->increment('weight', $task['weight']); $evnt->increment('weight', $task['weight']); //UPDATING PROGRESS OF COMMITTEE $progress = 0; $tasks = Task::where('comm_id', $comm->id)->get(); foreach ($tasks as $task1) { $progress += $task1->weight * $task1->progress; } $progress = $progress / $comm->weight; $comm->progress = $progress; $comm->save(); //UPDATING PROGRESS OF EVENT $progress2 = 0; $committees = Committee::all(); foreach ($committees as $committee) { if ($committee->event_id == $evnt->id) { $progress2 += $committee->weight * $committee->progress; } } $progress2 = $progress2 / $evnt->weight; $evnt->progress = $progress2; $evnt->save(); return redirect('profile'); }
/** * Reverse the migrations. * * @return void */ public function down() { $city = City::findByIATA('nyc')->first(); $event = Event::where('city_id', '=', $city->id); $city->delete(); $event->delete(); }
/** * Render front page view * @return VIEW welcome */ public function index() { $all_events = Event::where('time', '>', date('Y-m-d H:i:s'))->orderBy(DB::raw('RAND()')); $first_six = $all_events->take(6)->get(); $next_six = $all_events->skip(6)->take(6)->get(); return View::make('welcome')->with('first_six', $first_six)->with('next_six', $next_six); }
/** * Execute the console command. * * @return mixed */ public function handle() { $cities = City::all(); // Grab all the cities and then do a for each. // run this for each of them. foreach ($cities as $city) { $events = Event::where('city_id', '=', $city->id)->where('time_end', '>=', date('Y-m-d H:i:s'))->where('time_end', '<=', date('Y-m-d H:i:s', strtotime('+2 weeks')))->orderBy('time_start', 'asc')->get(); if (!count($events)) { $this->comment('No events found for ' . $city->name . '. Mailer not sent.'); continue; } $categories = Category::orderBy('title', 'asc')->get(); if ($this->option('email')) { $subscriber = new Subscriber(); $subscriber->name = 'Test User'; $subscriber->email = $this->option('email'); $subscribers = [$subscriber]; $this->comment('Sent test email to ' . $this->option('email')); } else { $subscribers = Subscriber::where('city_id', '=', $city->id)->get(); } $count = 0; foreach ($subscribers as $subscriber) { Mail::send('emails.subscribers.mailer', ['subscriber' => $subscriber, 'events' => $events, 'categories' => $categories, 'city' => $city], function ($m) use($subscriber, $city) { $m->from('*****@*****.**', 'See+Do')->to($subscriber->email, $subscriber->name)->subject('Weekly Round-Up of Things to See+Do in ' . $city->name)->getHeaders()->addTextHeader('X-MC-Subaccount', 'see-do'); }); $count++; } $this->comment('Sent to ' . $count . ' email addresses in ' . $city->name . '.'); $count = 0; } }
/** * Execute the job. * * @return void */ public function handle() { // Same time next week! :D $job = (new \App\Jobs\WeeklyMail())->delay(604800); $this->dispatch($job); // We'll just want to double-check our Facebook events still exist // before we email people about them... FacebookSession::setDefaultApplication(getenv('FB_ID'), getenv('FB_SECRET')); $session = FacebookSession::newAppSession(); try { $session->validate(); } catch (FacebookRequestException $ex) { // Session not valid, Graph API returned an exception with the reason. dd($ex); } catch (\Exception $ex) { // Graph API returned info, but it may mismatch the current app or have expired. dd($ex); } $all_events = Event::where('time', '>', date('Y-m-d H:i:s'))->where('time', '<', date('Y-m-d H:i:s', time() + 604800))->get(); foreach ($all_events as $event) { $request = new FacebookRequest($session, 'GET', "/" . $event->facebook_id); try { $response = $request->execute(); } catch (\Exception $ex) { // Facebook Exception looking up event; probably deleted, should mirror here. $event->delete(); } } foreach (User::where('unsubscribed_email', 'no') as $user) { $this->dispatch(new SendEmail($user)); } }
/** * Edit timeline / */ public function editTimeline($timeline_id, Request $request) { $timeline = \App\Timeline::where('id', '=', $timeline_id)->first(); $timeline_events = $timeline->event()->orderBy('start_date')->get(); if ($request->input('showForm') == 'true') { return view('timelines.editTimeline')->with('showForm', 'true')->with('timeline', $timeline)->with('timeline_events', $timeline_events); } else { // Else submit form // Validate the request data $this->validate($request, ['name' => 'required']); $user = \Auth::user(); $timeline->name = $request->input('name'); $timeline->description = $request->input('description'); $timeline->last_modified_by = $user->id; $timeline->save(); // Delete events for ($e = 0; $e < count($timeline_events); $e++) { if ($request->input('delete_event' . $e) == 'true') { \DB::table('character_event')->where('event_id', '=', $timeline_events[$e]->id)->delete(); \DB::table('event_location')->where('event_id', '=', $timeline_events[$e]->id)->delete(); $event = \App\Event::where('id', '=', $timeline_events[$e]->id)->first(); if ($event) { $event->delete(); } } } // Return success message return view('timelines.editTimeline')->with('showForm', 'false')->with('timeline', $timeline); } }
/** * Display the specified resource. * * @param int $id * @return \Illuminate\Http\Response */ public function show($type, $id) { if ($id == 'video') { $events = Video::all(); return view('video.show', compact('events')); } elseif ($id == 'staff') { $events = Staff::all(); return view('staff.show', compact('events')); } elseif ($id == 'gallery') { $events = Image::all(); return view('gallery.show', compact('events')); } else { $event = Event::where('slug', $id)->where('type', $type)->first(); $location = Location::where('event_id', $event->id)->first(); $slider = EventImage::where('event_id', $event->id)->orderBy(\DB::raw('RAND()'))->take(4)->get(); $gallery = EventImage::where('event_id', $event->id)->first(); if ($event->type == $type) { if ($event->status == 1) { return view($type . '.show', compact('event', 'location', 'slider', 'gallery')); } else { return redirect('/' . $type . '/'); } } } }
/** * Display a listing of the resource. * * @return \Illuminate\Http\Response */ public function index() { $events = Event::where('user_id', $user_id)->get(); $jobs = Job::where('user_id', $user_id)->get(); // return view('members.dashboardpage', ['user' => $user, 'events' => $events, 'jobs' => $jobs]); return view('public.frontpage', ['user' => $user, 'events' => $events, 'jobs' => $jobs]); }
/** * Handle an incoming request. * * @param \Illuminate\Http\Request $request * @param \Closure $next * @return mixed */ public function handle($request, Closure $next) { $slug = $request->route('slug'); $event = Event::where(['slug' => $slug])->first(); //dd(\Auth::user()->role); $role = \Auth::user()->role; return $next($request); }
public function viewSingle($id) { if (!Event::where('id', $id)->exists()) { return redirect('/'); } $event = Event::where('id', $id)->first(); return view('single', compact('event', 'title', 'events')); }
protected function tearDown() { PollResponse::where('pid', $this->pollOption->oid)->delete(); PollOption::where('oid', $this->pollOption->oid)->delete(); Poll::where('pid', $this->poll->pid)->delete(); Event::where('eid', $this->event->eid)->delete(); User::where('uid', $this->user->uid)->delete(); }
/** * Display the specified resource. * * @param int $id * @return Response */ public function show($id) { //Get the event with ID and online is 1 $item = Event::where('online', 1)->findOrFail($id); //Add related pages also for this event $item['pages'] = $item->pages()->where('active', 1)->get(); return $item; }
/** * Display a listing of the resource. * * @return Response */ public function getIndex() { // $events = Event::all(); $upcoming = Event::where('event_date', '>', Carbon::now())->get(); $past = Event::where('event_date', '<', Carbon::now())->get(); return view('event.index', compact('upcoming', 'past')); }
/** * Set test session variable to gain access to closed registration. */ public function test($event_slug) { if ($event = Event::where('slug', $event_slug)->first()) { // set event session Session::set('event', $event); Session::set('test', true); } return redirect('/event/' . Session::get('event')->slug . '/start'); }
/** * Display report with limited details. */ public function regional($event_slug, $key) { $event = Event::where('slug', $event_slug)->first(); if ($event->getAccessToken('regional') == $key) { return view('report.regional', ['event' => $event]); } else { abort(404); } }
/** * Show the form for editing the specified resource. * * @param int $id * @return \Illuminate\Http\Response */ public function edit($id) { try { $event = Event::where('priviledge', \Auth::user()->priviledge)->where('id', $id)->firstOrFail(); } catch (\Illuminate\Database\Eloquent\ModelNotFoundException $e) { return view('errors.captureNotFound'); } return view('event.show', compact('event')); }
public function store() { $seven_days = 60 * 60 * 24 * 7; $two_hours = 60 * 60 * 2; $season = $_REQUEST['season']; $venue_id = $_REQUEST['venue_id']; $activity = $_REQUEST['activity']; $lastSeasonsLeague = League::where('season', $season - 1)->where('venue_id', $venue_id)->where('activity', $activity)->first(); $lastSeasonsLastGame = Event::where('league_id', $lastSeasonsLeague->id)->where('week_num', 'Wild Card')->where('game_num', 1)->first(); $start_dt = $_REQUEST['start_dt']; $start_dt = $start_dt ? strtotime($start_dt) : strtotime($lastSeasonsLastGame->date) + $seven_days; $start_wk = $_REQUEST['start_wk']; $start_wk -= 1; $week_cnt = $_REQUEST['week_cnt']; $game_cnt = $_REQUEST['game_cnt']; $games_tm = $_REQUEST['games_tm']; $games_tm = $games_tm ? strtotime($games_tm) : strtotime($lastSeasonsLastGame->time); $events = []; for ($i = $start_wk; $i <= $week_cnt; $i++) { $week_num = $i == $week_cnt ? 'Wild Card' : $i + 1; for ($j = 0; $j < $game_cnt; $j++) { $datetime = date('Y-m-d', $start_dt + $seven_days * $i) . ' ' . date('H:i:s', $games_tm + $two_hours * $j); $game_num = $j + 1; $league = League::where('season', $season)->where('venue_id', $venue_id)->where('activity', $activity)->first(); if (!$league) { $league = new League(); $league->season = $season; $league->venue_id = $venue_id; $league->activity = $activity; $league->save(); } $event = new Event(); $event->league_id = $league->id; $event->season = $league->season; $event->venue_id = $league->venue_id; $event->datetime = $datetime; $event->week_num = $week_num; $event->game_num = $game_num; $event->activity = $league->activity; $events[] = $event; } } try { DB::transaction(function () use($events) { foreach ($events as $event) { $event->save(); } }); $_SESSION['ALERT'] = alert('Season Added!', "Season {$season} for " . Venue::find($venue_id)->name . " was created successfully.", 'success'); } catch (Excepton $e) { print_r($e); exit; $_SESSION['ALERT'] = alert('Season Not Added!', "Season {$season} for " . Venue::find($venue_id)->name . " could not be created.", 'error'); } return redirect('/seasons'); }
/** * Display a listing of the resource. * * @return Response */ public function index() { $this->data['items'] = Event::where('enabled', 1)->first(); $cek = Flag::where('eventid', $this->data['items']->id)->where('from', Auth::id())->where('to', Auth::id())->first(); if ($cek != null) { $this->data['items'] = null; // dd($cek); } return view('pages.dept.dashboard', $this->data); }
public function edit($id) { $category = $this->category->find($id); if ($category->archive == 1) { Event::where('archive', 0)->where('type', $category->id)->update(['archive' => 1, 'archived_through_category' => 1]); } else { Event::where('archive', 1)->where('type', $category->id)->where('archived_through_category', 1)->update(['archive' => 0, 'archived_through_category' => 0]); } return view('admin.pages.categories.edit', compact('category')); }
function categoryMissingCrucialInformation($id) { $category = \App\Category::find($id); if ($category->description > 0) { return false; } if (\App\Event::where('type', $category->id)->count() > 0) { return false; } return true; }
public function readArticle($id, $titleSlugged) { $article = Article::find($id); if (str_slug($article->title) == $titleSlugged) { $mostRecentsNews = Article::where('id', '!=', $id)->orderBy('publish_at', 'desc')->orderBy('id', 'desc')->take(8)->get(); $suggeredEvents = Event::where('start_date', '<=', new \Datetime())->where('end_date', '>=', new \Datetime())->orderBy('id', 'desc')->take(3)->get(); return view('front.articles.read', array('article' => $article, 'mostRecentsNews' => $mostRecentsNews, 'suggeredEvents' => $suggeredEvents)); } else { abort(404); } }
public function deleteevent($id) { $dat = Event::where('id', '=', $id)->get(); if (Auth::user()->privilege > 6 || $dat[0]->society_id == Auth::user()->id) { $data = Event::where('id', '=', $id); $data->delete(); return Redirect::route('view_event')->with('message', 'Event Successfully Deleted'); } else { return Redirect::route('dashboard')->with('error', "Access Denied"); } }
/** * Gets the events for a society * @param [type] $day [description] * @return [type] [description] */ public function eventsForSociety($society_identifier) { $society_identifier = str_replace("-", " ", $society_identifier); try { $society = Society::where('id', $society_identifier)->orWhere('facebook_ref', $society_identifier)->firstOrFail(); } catch (\Exception $e) { abort(404); } $events = Event::where('time', '>', date('Y-m-d H:i:s', time()))->where('society_id', $society->id)->orderBy('time')->get(); return ['society' => $society, 'events' => $events]; }
public function showEventsUserForm(Request $request) { $this->middleware('auth'); $user = $request->user; $daterange = $request->daterange; $dateStart = $request->dateStart; $dateEnd = $request->dateEnd; $events = Event::where('idUser', $user)->where('idUser', $user)->whereBetween('dateGps', [$dateStart, $dateEnd])->get(); $users = User::all(); return view('app.event.user')->with('user', $user)->with('events', $events)->with('users', $users); }
protected function tearDown() { if (is_null($this->lastEvent)) { $event = Event::first(); if (!is_null($event)) { $event->delete(); } } else { Event::where('eid', '>', $this->lastEvent)->delete(); } User::where('uid', $this->user->uid)->delete(); }
public function getHome() { $year = date("Y"); $varr = Auth::user()->empid; $evarr = User::where('empid', $varr)->get(); $edetails = Employee::where('emp_ide_id', $varr)->get(); $categories = Event::where(DB::raw('year(date)'), $year)->get(); $employee = Employee::all(); $invoice = Invoice::orderBy('Id', 'DESC')->where(DB::raw('year(InvoiceDate)'), $year)->where(DB::raw('year(DueDate)'), $year)->get(); $invnull = Invoice::where('Status', '=', 'Null')->get(); return View('reviewer/home')->with(array('categories' => $categories, 'employee' => $employee, 'invoice' => $invoice, 'invnull' => $invnull, 'edetails' => $edetails)); }