/** * Show the application dashboard to the user. * * @return Response */ public function index(Route $route) { //echo $route->getActionName(); // exit(); $upcomingexhibitionevents = ExhibitionEvent::where('start_time', '>', date("Y-m-d H:i:s"))->take(4)->get(); $currentlyexhibitionevents = ExhibitionEvent::where('start_time', '<', date("Y-m-d H:i:s"))->where('end_time', '>', date("Y-m-d H:i:s"))->take(4)->get(); $tracklogins = Tracklogin::where('user_id', '=', Auth::User()->id)->orderBy('created_at', 'desc')->take(2)->get(); $systemtracks = Systemtrack::where('user_id', '=', Auth::User()->id)->orderBy('created_at', 'desc')->take(5)->get(); if (Auth::User()->type == 'company') { $user = User::find(Auth::User()->id); $company = Company::where('user_id', $user->id)->get(); $company = $company[0]; $companyId = $company->id; $exhibitors = Exhibitor::where('company_id', $companyId)->get(); //$booths=array(); $events = array(); $i = 0; foreach ($exhibitors as $exhibitor) { $booths = Booth::where('exhibitor_id', $exhibitor->id)->get(); foreach ($booths as $booth) { $events[$i] = $booth->exhibition_event_id; $i++; } } $events = array_unique($events); //var_dump($events); exit(); $i = 0; $exhibitionevents = array(); foreach ($events as $event) { $exhibitionevents[$i] = ExhibitionEvent::find($event); $i++; } // var_dump($exhibitionevents[0]); exit(); $upcomingcompanyevents = array(); $currentlycompanyevents = array(); $finishedcompanyevents = array(); $i = 0; foreach ($exhibitionevents as $exhibitionevent) { if ($exhibitionevent->start_time > date("Y-m-d H:i:s")) { $upcomingcompanyevents[$i] = $exhibitionevent; $i++; } elseif ($exhibitionevent->start_time < date("Y-m-d H:i:s") && $exhibitionevent->end_time > date("Y-m-d H:i:s")) { $currentlycompanyevents[$i] = $exhibitionevent; $i++; } else { $finishedcompanyevents[$i] = $exhibitionevent; $i++; } } } return view('home', compact('upcomingexhibitionevents', 'currentlyexhibitionevents', 'tracklogins', 'systemtracks', 'upcomingcompanyevents', 'currentlycompanyevents', 'finishedcompanyevents')); }
/** * Remove the specified resource from storage. * * @param int $id * @return Response */ public function destroy($id) { // $exhibitioneventId = Request::get('id'); ExhibitionEvent::where('id', $exhibitioneventId)->delete(); return redirect("exhibitionevents"); }