public function viewSingle($slug) { if (!Venue::where('slug', $slug)->exists()) { return redirect('/'); } $venue = Venue::where('slug', $slug)->first(); $title = $venue->name; $events = $venue->event; return view('single', compact('venue', 'title', 'events')); }
private function selectVenue($venueInput, $event) { // check if input is an ID if (Venue::where('name', $venueInput)->first()) { $venue = Venue::where('name', $venueInput)->first(); $event->venue_id = $venue->id; } else { if (Venue::where('id', $venueInput)->first()) { $event->venue_id = $venueInput; } else { dd('Venue Error..', $venueInput); } } }
/** * Run the database seeds. * * @return void */ public function run() { Model::unguard(); DB::table('users')->delete(); DB::table('user_location')->delete(); DB::table('venue')->delete(); DB::table('stage')->delete(); DB::table('transactions')->delete(); DB::table('tracks')->delete(); DB::table('users')->insert(['name' => 'Testy Test', 'email' => '*****@*****.**', 'username' => 'test_account', 'password' => Hash::make('Test!234'), 'meta' => '{"points": 5000, "maxRooms": 3, "maxTracks": 3}']); DB::table('user_location')->insert(['user_id' => User::first()->id, 'venue_id' => 0]); DB::table('venue')->insert(['name' => 'Rock Out', 'capacity' => 10, 'user_id' => 0]); DB::table('stage')->insert(['venue_id' => Venue::where('name', '=', 'Rock Out')->get()[0]->id]); DB::table('venue')->insert(['name' => 'The Country Club', 'capacity' => 15, 'user_id' => 0]); DB::table('stage')->insert(['venue_id' => Venue::where('name', '=', 'The Country Club')->get()[0]->id]); DB::table('venue')->insert(['name' => 'EDM', 'capacity' => 25, 'user_id' => 0]); DB::table('stage')->insert(['venue_id' => Venue::where('name', '=', 'EDM')->get()[0]->id]); DB::table('venue')->insert(['name' => 'Perosnal Venue', 'capacity' => 15, 'user_id' => User::first()->id]); DB::table('stage')->insert(['venue_id' => Venue::where('name', '=', 'Perosnal Venue')->get()[0]->id]); DB::table('transactions')->insert(['user_id' => User::first()->id, 'desc' => "Created room 'Personal Venue' for 750 points"]); DB::table('tracks')->insert(['user_id' => User::first()->id, 'name' => 'Bumpin', 'sequence' => '[["","","hipHopTwo_beatz00","","hipHopTwo_beatz00","","","","hipHopTwo_beatz00","","hipHopTwo_beatz00","","hipHopTwo_beatz00","","hipHopTwo_beatz00","","hipHopTwo_beatz00","","hipHopTwo_beatz00","","hipHopTwo_beatz00","","hipHopTwo_beatz00","","hipHopTwo_beatz00","","","","",""],["","","hipHopOne_beatz01","","hipHopOne_beatz01","hipHopOne_beatz01","hipHopOne_beatz01","hipHopOne_beatz01","hipHopOne_beatz01","hipHopOne_beatz01","hipHopOne_beatz01","hipHopOne_beatz01","hipHopOne_beatz01","",""],["shared_triangle00","shared_triangle00","shared_triangle00","shared_triangle00","shared_triangle00","shared_triangle00","","shared_triangle00","","shared_triangle00","","shared_triangle00","","shared_triangle00","shared_triangle00"],["","","","","","","misc_effect00","","","misc_effect00","","","misc_effect00","","","","misc_effect00","","misc_effect00","","","misc_effect00","","","","misc_effect00","","","misc_effect00",""],["","","","","","hipHopOne_kbd00","","hipHopOne_kbd00","","","","hipHopOne_kbd00","","hipHopOne_kbd00",""],["","","","","","","","","","","","","hipHopOne_bass00","hipHopOne_bass00","","hipHopOne_bass00","hipHopOne_bass00","","hipHopOne_bass00","hipHopOne_bass00","","hipHopOne_bass00","hipHopOne_bass00","","hipHopOne_bass00","hipHopOne_bass00","","","hipHopOne_bass00",""]]']); Model::reguard(); }
public function index() { $season = League::whereHas('events', function ($query) { $query->where('datetime', '<=', date('Y-m-d')); })->max('season'); $venues = \App\Venue::where(function ($query) { $query->whereRaw('private is not true'); $query->orWhereRaw('id in (select venue_id from t_venue_players where player_id = ' . (Auth::user()->id ?: 0) . ')'); }); $venuesLive = with(clone $venues)->whereHas('leagues', function ($query) use($season) { $query->where('season', '>=', $season); })->get(); $venuesPast = with(clone $venues)->whereDoesntHave('leagues', function ($query) use($season) { $query->where('season', '>=', $season); })->get(); $venuesLive->each(function ($venue) { $venue->current = 1; }); $venuesPast->each(function ($venue) { $venue->current = null; }); $venues = array_merge($venuesLive->all(), $venuesPast->all()); return view('venues.index', compact('venues')); }
public function retrieve() { $venues = Venue::where('user_id', '=', 0)->get(); return response()->json($venues[0]); }
<?php namespace App\ViewComposers; use View; use Auth; use App\Venue; use App\League; View::composer('partials.select-venue', function ($view) { $season = League::whereHas('events', function ($query) { $query->where('datetime', '<=', date('Y-m-d')); })->max('season'); $venues = Venue::where(function ($query) { $query->whereRaw('private is not true'); $query->orWhereRaw('id in (select venue_id from t_venue_players where player_id = ' . (Auth::user()->id ?: 0) . ')'); }); $venuesLive = with(clone $venues)->whereHas('leagues', function ($query) use($season) { $query->where('season', '>=', $season); })->get(); $venuesPast = with(clone $venues)->whereDoesntHave('leagues', function ($query) use($season) { $query->where('season', '>=', $season); })->get(); $view->with('venuesLive', $venuesLive)->with('venuesPast', $venuesPast); });
public function venue() { return Venue::where('name', '=', $this->venue_name); }