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);
}
