/** * Show the application dashboard to the user. * * @return Response */ public function index(Route $route) { $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')); }
/** * Update the specified resource in storage. * * @param int $id * @return Response */ public function update($id) { // $v = Validator::make(Request::all(), ['name' => 'required|max:50', 'hall_id' => 'required', 'exhibition_id' => 'required']); if ($v->fails()) { return redirect()->back()->withErrors($v->errors())->withInput(); } else { $id = Request::get('id'); $exhibitionevent = ExhibitionEvent::find($id); $exhibitionevent->name = Request::get('name'); $exhibitionevent->desc = Request::get('desc'); $exhibitionevent->start_time = Request::get('start_time'); $exhibitionevent->end_time = Request::get('end_time'); // $exhibitionevent->hall_id = Request::get('hall_id'); $exhibitionevent->exhibition_id = Request::get('exhibition_id'); $exhibitionevent->save(); $exhibitioneventhall = ExhibitionEventHall::find($id); $exhibitioneventhall->hall_id = Request::get('hall_id'); $exhibitioneventhall->save(); return redirect('exhibitionevents'); } }
public function bookBooth($id) { if (!$this->adminAuth() && !$this->checkCompanyType()) { return view('errors.404'); } $exhibitioneventId = $id; $checExEv = ExhibitionEvent::find($exhibitioneventId); if (date("Y-m-d H:i:s") > $checExEv->start_time) { return view('errors.404'); } $exhibitors = Exhibitor::all(); $exhibitionevents = ExhibitionEvent::all(); $types = Type::all(); $models = Modeldesign::all(); $spots = Spot::all(); return view('CompanyCP.booths.create', compact('types', 'models', 'exhibitors', 'exhibitionevents', 'exhibitioneventId', 'spots')); }
/** * function to show event in certain page * * @param int $id * @return Response */ public function showEventPage($id) { //check on event_id is exsist if (Session::has('systemtrack_event_id')) { $systemtrack_event_id_value = Session::get('systemtrack_event_id'); $systemtrack_event = Systemtrack::find($systemtrack_event_id_value); if ($systemtrack_event->leave_at == null) { DB::table('systemtracks')->where('id', $systemtrack_event_id_value)->update(['leave_at' => date("Y-m-d H:i:s")]); //$systemtrack_booth->leave_at=date("Y-m-d H:i:s"); } } //check on booth_id is exsist if (Session::has('systemtrack_booth_id')) { $systemtrackid = Systemtrack::all()->last()->pluck('id'); $systemtrack_booth_id_value = Session::get('systemtrack_booth_id'); $systemtrack_booth = Systemtrack::find($systemtrack_booth_id_value); if ($systemtrack_booth->leave_at == null) { DB::table('systemtracks')->where('id', $systemtrack_booth_id_value)->update(['leave_at' => date("Y-m-d H:i:s")]); //$systemtrack_booth->leave_at=date("Y-m-d H:i:s"); } } $exhibitionevent = ExhibitionEvent::find($id); $booths = Booth::where('exhibition_event_id', $id)->get(); $systemtrack = new Systemtrack(); $systemtrack->user_id = Auth::User()->id; // $systemtrack->spot_id=$booth->spot_id; $systemtrack->do = Auth::User()->name . ' ' . 'visit' . ' ' . $exhibitionevent->name . ' Event ' . 'at' . ' ' . date("Y-m-d H:i:s"); $systemtrack->comein_at = date("Y-m-d H:i:s"); $systemtrack->type = 'exhibitionevent'; $systemtrack->type_id = $id; $systemtrack->save(); //save exhibition event id in session Session::put('event_id', $id); Session::put('systemtrack_event_id', $systemtrack->id); DB::table('systemtracks')->where('id', $systemtrack->id)->update(['eventid' => $id, 'systemeventid' => $systemtrack->id]); return view('exhibitionevents.eventpage', compact('exhibitionevent', 'booths')); }