/** * 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')); }
/** * list booth of certain company in certain events * @param integer $id * @return Response */ public function listboothsofcompanyinthisevent($id) { if (!$this->companyAuth($id)) { return view('errors.404'); } $user = User::find($id); $company = Company::where('user_id', $user->id)->get(); $company = $company[0]; $companyId = $company->id; $exhibitors = Exhibitor::where('company_id', $companyId)->get(); $booths = array(); $i = 0; foreach ($exhibitors as $exhibitor) { $booths = Booth::where('exhibitor_id', $exhibitor->id)->get(); $booths[$i] = $booths[0]; $i++; } // var_dump($booths); exit(); return view('booths.index', compact('booths')); }
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')); }
/** * destroy company exhibitor when log in as company * @param integer $id * @return Response */ public function destroyCompanyExhibitor($id) { // $exhibitorId = Request::get('id'); Exhibitor::where('id', $exhibitorId)->delete(); return redirect("/companies/showexhibitorsofcompanybyuserid/" . Auth::User()->id); }
/** * Show the form for editing the specified resource. * * @param int $id * @return Response */ public function edit($id) { // $seriesevent = SeriesEvent::find($id); $exhibitions = Exhibition::all(); $exhibitors = Exhibitor::all(); return view('seriesevents.edit', compact('seriesevent', 'exhibitors', 'exhibitions')); }
public function storeexhibitorbyadmin() { $v = Validator::make(Request::all(), ['name' => 'required|max:50', 'company' => 'required']); if ($v->fails()) { return redirect()->back()->withErrors($v->errors())->withInput(); } else { $exhibitor = new Exhibitor(); $exhibitor->company_id = Request::get('company'); $exhibitor->country_id = Request::get('country'); $exhibitor->city = Request::get('city'); $exhibitor->address = Request::get('address'); $exhibitor->name = Request::get('name'); $exhibitor->desc = Request::get('desc'); $exhibitor->phone = Request::get('phone'); $exhibitor->anotherphone = Request::get('anotherphone'); $exhibitor->fax = Request::get('fax'); $exhibitor->save(); // File Storage $file = new File(); $file->name = Request::get('filename'); $file->desc = Request::get('filedesc'); $file->type = Request::get('filetype'); if (Request::hasFile('file')) { $destination = 'files/'; $filename = str_random(6) . "_" . Request::file('file')->getClientOriginalName(); Request::file('file')->move($destination, $filename); $file->file = $filename; } else { $file->file = Request::get('file'); } $file->save(); $exhibitorfile = new ExhibitorFile(); $exhibitorfile->exhibitor_id = $exhibitor->id; $exhibitorfile->file_id = $file->id; $exhibitorfile->save(); // Admin if ($this->adminAuth()) { return redirect('exhibitors'); } //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(); return view('companies.listallexhibitorsofCompany', compact('exhibitors')); } }