public function update($id)
{
$venue = Venue::findOrFail($id);
if (isset($_REQUEST['name'])) {
$venue->name = $_REQUEST['name'];
}
if (isset($_REQUEST['phone'])) {
$venue->phone = $_REQUEST['phone'];
}
if (isset($_REQUEST['website'])) {
$venue->website = $_REQUEST['website'];
}
if (isset($_REQUEST['address'])) {
$venue->address = $_REQUEST['address'];
}
if (isset($_REQUEST['zip-code'])) {
$venue->zip_code = $_REQUEST['zip-code'];
}
if (isset($_REQUEST['visibility'])) {
$venue->private = $_REQUEST['visibility'] === 0 ? 1 : null;
}
$venue->save();
$_SESSION['ALERT'] = alert("Venue Update Successfully!", "", "success");
return redirect("/venues");
}
public static function addRectangle($NElat, $NElng, $SWlat, $SWlng, $type, $id)
{
$model = Venue::firstByAttributes(array('rec_id' => $id));
if (!$model) {
$model = new Venue();
}
$model->venue_type_id = 1;
$model->lat_top_right = $NElat;
$model->lng_top_right = $NElng;
$model->lat_bottom_left = $SWlat;
$model->lng_bottom_left = $SWlng;
$model->rec_id = $id;
if ($model->save()) {
return TRUE;
}
return FALSE;
}
public function viewAll()
{
$venues = Venue::orderBy('name')->get();
foreach ($venues as $venue) {
$venue['eventCount'] = count($venue->event);
}
return view('archive-venue', compact('venues'));
}
public function run()
{
$faker = Faker\Factory::create();
$venues = [['name' => 'Brewdog', 'city_id' => '1', 'type_id' => '1', 'latitude' => '51.453536', 'longitude' => '-2.592712', 'twitter' => '@BrewDogBristol', 'address' => '58 Baldwin Street, Bristol, BS1 1QW'], ['name' => 'Small Bar', 'city_id' => '1', 'type_id' => '2', 'latitude' => '51.451942', 'longitude' => '-2.594879', 'twitter' => '@smallbarbristol', 'address' => '31 King Street, Bristol, City of Bristol BS1 4DZ'], ['name' => 'The Hillgrove Porter Stores', 'city_id' => '1', 'type_id' => '2', 'latitude' => '51.4630439002269', 'longitude' => '-2.59280648278449', 'twitter' => '@TheHillgrove', 'address' => '53 Hillgrove Street North, Bristol, Avon BS2 8LT']];
foreach ($venues as $venue) {
Venue::create(['name' => $venue['name'], 'description' => $faker->paragraph(), 'latitude' => $venue['latitude'], 'longitude' => $venue['longitude'], 'twitter' => $venue['twitter'], 'address' => $venue['address'], 'type_id' => $venue['type_id'], 'city_id' => $venue['city_id'], 'image-small' => $faker->imageUrl(100, 100, 'nightlife'), 'image-large' => $faker->imageUrl(400, 200, 'nightlife')]);
$this->command->info('Creating ' . $venue['name']);
}
}
public function dashboard()
{
$venues = Venue::orderBy('name', 'asc')->get();
$bands = Band::orderBy('name', 'asc')->get();
$events = Event::orderBy('date', 'asc')->get();
$events_future = Event::futureEvents();
$events_past = Event::pastEvents();
return view('dashboard', compact('venues', 'events', 'events_future', 'events_past', 'bands'));
}
public function run()
{
$venues = Venue::all();
//$features = Feature::all()->toArray();
foreach ($venues as $venue) {
$venue->features()->attach([1, 2, 3]);
//$this->command->info('Creating '.$venue['name']);
}
}
public function store()
{
$seven_days = 60 * 60 * 24 * 7;
$two_hours = 60 * 60 * 2;
$season = $_REQUEST['season'];
$venue_id = $_REQUEST['venue_id'];
$activity = $_REQUEST['activity'];
$lastSeasonsLeague = League::where('season', $season - 1)->where('venue_id', $venue_id)->where('activity', $activity)->first();
$lastSeasonsLastGame = Event::where('league_id', $lastSeasonsLeague->id)->where('week_num', 'Wild Card')->where('game_num', 1)->first();
$start_dt = $_REQUEST['start_dt'];
$start_dt = $start_dt ? strtotime($start_dt) : strtotime($lastSeasonsLastGame->date) + $seven_days;
$start_wk = $_REQUEST['start_wk'];
$start_wk -= 1;
$week_cnt = $_REQUEST['week_cnt'];
$game_cnt = $_REQUEST['game_cnt'];
$games_tm = $_REQUEST['games_tm'];
$games_tm = $games_tm ? strtotime($games_tm) : strtotime($lastSeasonsLastGame->time);
$events = [];
for ($i = $start_wk; $i <= $week_cnt; $i++) {
$week_num = $i == $week_cnt ? 'Wild Card' : $i + 1;
for ($j = 0; $j < $game_cnt; $j++) {
$datetime = date('Y-m-d', $start_dt + $seven_days * $i) . ' ' . date('H:i:s', $games_tm + $two_hours * $j);
$game_num = $j + 1;
$league = League::where('season', $season)->where('venue_id', $venue_id)->where('activity', $activity)->first();
if (!$league) {
$league = new League();
$league->season = $season;
$league->venue_id = $venue_id;
$league->activity = $activity;
$league->save();
}
$event = new Event();
$event->league_id = $league->id;
$event->season = $league->season;
$event->venue_id = $league->venue_id;
$event->datetime = $datetime;
$event->week_num = $week_num;
$event->game_num = $game_num;
$event->activity = $league->activity;
$events[] = $event;
}
}
try {
DB::transaction(function () use($events) {
foreach ($events as $event) {
$event->save();
}
});
$_SESSION['ALERT'] = alert('Season Added!', "Season {$season} for " . Venue::find($venue_id)->name . " was created successfully.", 'success');
} catch (Excepton $e) {
print_r($e);
exit;
$_SESSION['ALERT'] = alert('Season Not Added!', "Season {$season} for " . Venue::find($venue_id)->name . " could not be created.", 'error');
}
return redirect('/seasons');
}
function show()
{
$venues = Venue::all();
$select_timings = Timing::lists('artist_name', 'artist_name');
$title = "Plan by Time";
$user = Auth::user();
$already_selected_timings = [];
// if logged in then set this to an actual array
if ($user !== null) {
$already_selected_timings = $user->timings->lists('artist_name', 'artist_name')->toArray();
}
return view('bytime', compact('venues', 'select_timings', 'already_selected_timings', 'title'));
}
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);
}
}
}
public function leaveStage()
{
$userWhereabouts = $this->user->whereAbouts;
$venue = Venue::find($userWhereabouts->venue_id);
if ($userWhereabouts->venue_id != $venue->id) {
return response()->json(['success' => false, 'message' => 'You can\'t leave the stage if you\'re not in the right venue!'], 403);
}
if ($venue->stage->current_artist === $this->user->id) {
$venue->stage->update(['current_artist' => 0, 'track_id' => 0]);
return response()->json(['success' => true]);
} else {
return response()->json(['success' => false, 'message' => 'You\'re not on the stage!'], 403);
}
}
public function saveRectangleToDatabase(Request $request)
{
$id = $request->input('id');
$NElng = $request->input('NElng');
$type = $request->input('type');
$SWlat = $request->input('SWlat');
$NElat = $request->input('NELat');
$SWlng = $request->input('SWlng');
if ($type === 'rec') {
$result = Venue::addRectangle($NElat, $NElng, $SWlat, $SWlng, $type, $id);
}
if ($result) {
return response()->json(array('status' => 1, 'message' => 'Success'));
}
return response()->json(array('status' => 0, 'message' => 'Error !!'));
}
public static function seed($id, $slug, $name)
{
$response = Curl::get('http://api.football-data.org/alpha/teams/' . $id . '/fixtures/?venue=home&timeFrame=n28');
if (!empty($response)) {
$fixtures = json_decode($response)->fixtures;
foreach ($fixtures as $fixture) {
$end_time = Carbon::parse($fixture->date);
$end_time->minute = 90;
$venue = array('slug' => $slug, 'venue_name' => $name);
$venue = Venue::firstOrCreate($venue);
$event = array('event_name' => $fixture->homeTeamName . ' vs ' . $fixture->awayTeamName, 'start_time' => Carbon::parse($fixture->date), 'end_time' => $end_time, 'duration' => 90, 'venue_id' => $venue->id);
$event = Event::firstOrCreate($event);
}
return;
}
}
/**
* 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();
}
/**
* Remove the specified resource from storage.
*
* @param int $id
* @return \Illuminate\Http\Response
*/
public function destroy(Request $request)
{
foreach ($request->input('to_delete') as $item_id) {
// delete file if exists
$image = Venue::getImage($item_id);
$this->deleteImage('venues', $image);
Venue::destroy($item_id);
}
Session::flash('message', 'Lugar de encuentro borrado Correctamente');
return Redirect::to('venues');
}
/**
* Update the specified resource in storage.
*
* @param \Illuminate\Http\Request $request
* @param int $id
* @return \Illuminate\Http\Response
*/
public function update(Request $request, $id)
{
$art = Venue::find($id);
$art->fill($request->input())->save();
return redirect('venue');
}
public function venue($id)
{
if (isset($id)) {
return Venue::find($id);
}
}
public function venue()
{
return Venue::where('name', '=', $this->venue_name);
}
public function retrieve()
{
$venues = Venue::where('user_id', '=', 0)->get();
return response()->json($venues[0]);
}
/**
* Remove the specified resource from storage.
*
* @param int $id
* @return Response
*/
public function destroy(Venue $venue)
{
$venue->features()->sync([]);
$venue->delete();
return redirect('venues')->with('flash_message', 'Venue Deleted!');
}
public function selectMall()
{
$venues = Venue::all();
return view('select_mall')->with('venues', $venues);
}
/**
* Create a new command instance.
*
* @return void
*/
public function __construct($user, $venueId)
{
$this->user = User::find($user->id);
$this->venue = Venue::find($venueId);
}
/**
* Display a listing of the resource.
*
* @return Response
*/
public function index()
{
$venues = Venue::all();
return $venues;
}
public function run()
{
DB::table('venues')->delete();
// Venue::create(['id' => 1, 'name' => 'Mall of America', 'description' => 'One of biggest malls in America'', 'venue_type_id' => 1, ''gps_latitude' => '34.4255648', 'gps_longitude' => '-103.1964765', 'zip_postal_code' => '55019',
// 'lat_top_left' => '', 'lng_top_left' => '', 'lat_top_right' => '', 'lng_top_right' => '', 'lat_bottom_left' => '', 'lng_bottom_left' => '', 'lat_bottom_right' => '', 'lng_bottom_right' => '']);
Venue::create(['name' => 'King of Prussia Mall', 'venue_type_id' => 1, 'gps_latitude' => '40.088669', 'gps_longitude' => '-75.39369']);
Venue::create(['name' => 'Mall of America', 'venue_type_id' => 1, 'gps_latitude' => '34.425565', 'gps_longitude' => '-103.196477']);
Venue::create(['name' => 'Aventura Mall', 'venue_type_id' => 1, 'gps_latitude' => '25.957008', 'gps_longitude' => '-80.146343']);
Venue::create(['name' => 'South Coast Plaza', 'venue_type_id' => 1, 'gps_latitude' => '8.727826', 'gps_longitude' => '79.962152']);
Venue::create(['name' => 'Del Amo Fashion Center', 'venue_type_id' => 1, 'gps_latitude' => '0', 'gps_longitude' => '0']);
Venue::create(['name' => 'Destiny USA ', 'venue_type_id' => 1, 'gps_latitude' => '33.368896', 'gps_longitude' => '-112.035155']);
Venue::create(['name' => 'Sawgrass Mills', 'venue_type_id' => 1, 'gps_latitude' => '33.368896', 'gps_longitude' => '-112.035155']);
Venue::create(['name' => 'The Galleria ', 'venue_type_id' => 1, 'gps_latitude' => '30.304748', 'gps_longitude' => '-97.942261']);
Venue::create(['name' => 'Roosvelt Field ', 'venue_type_id' => 1, 'gps_latitude' => '30.304748', 'gps_longitude' => '-97.942261']);
Venue::create(['name' => 'Woodfield Mall ', 'venue_type_id' => 1, 'gps_latitude' => '42.04551', 'gps_longitude' => '-88.037232']);
Venue::create(['name' => 'Palisades Center', 'venue_type_id' => 1, 'gps_latitude' => '42.04551', 'gps_longitude' => '-88.037232']);
Venue::create(['name' => 'Tysons Corner Center ', 'venue_type_id' => 1, 'gps_latitude' => '38.917367', 'gps_longitude' => '-77.220867']);
Venue::create(['name' => 'Plaza Las Americas ', 'venue_type_id' => 1, 'gps_latitude' => '-27.086719', 'gps_longitude' => '-54.858345']);
Venue::create(['name' => 'South Shore Plaza', 'venue_type_id' => 1, 'gps_latitude' => '-27.086719', 'gps_longitude' => '-54.858345']);
Venue::create(['name' => 'Westfield Garden State Plaza ', 'venue_type_id' => 1, 'gps_latitude' => '40.615023', 'gps_longitude' => '-74.311395']);
Venue::create(['name' => 'Ala Moana Center ', 'venue_type_id' => 1, 'gps_latitude' => '40.615023', 'gps_longitude' => '-74.311395']);
Venue::create(['name' => 'Lakewood Center ', 'venue_type_id' => 1, 'gps_latitude' => '34.535018', 'gps_longitude' => '-94.153539']);
Venue::create(['name' => 'Scottsdale Fashion Square ', 'venue_type_id' => 1, 'gps_latitude' => '34.535018', 'gps_longitude' => '-94.153539']);
Venue::create(['name' => 'Oakbrook Center', 'venue_type_id' => 1, 'gps_latitude' => '41.850409', 'gps_longitude' => '-87.95042']);
Venue::create(['name' => 'Bel Air Mall', 'venue_type_id' => 1, 'gps_latitude' => '41.850409', 'gps_longitude' => '-87.95042']);
Venue::create(['name' => 'Bridge Street Town Centre', 'venue_type_id' => 1, 'gps_latitude' => '33.670865', 'gps_longitude' => '-80.799858']);
Venue::create(['name' => 'Colonial Brookwood Village', 'venue_type_id' => 1, 'gps_latitude' => '33.670865', 'gps_longitude' => '-80.799858']);
Venue::create(['name' => 'Quintard Mall ', 'venue_type_id' => 1, 'gps_latitude' => '43.108075', 'gps_longitude' => '-80.645452']);
Venue::create(['name' => 'Regency Square Mall ', 'venue_type_id' => 1, 'gps_latitude' => '43.108075', 'gps_longitude' => '-80.645452']);
Venue::create(['name' => 'Riverchase Galleria ', 'venue_type_id' => 1, 'gps_latitude' => '33.379733', 'gps_longitude' => '-86.807571']);
Venue::create(['name' => 'Selma Mall ', 'venue_type_id' => 1, 'gps_latitude' => '33.379733', 'gps_longitude' => '-86.807571']);
Venue::create(['name' => 'The Shoppes at EastChase', 'venue_type_id' => 1, 'gps_latitude' => '32.35631', 'gps_longitude' => '-86.16372']);
Venue::create(['name' => 'The Summit Birmingham ', 'venue_type_id' => 1, 'gps_latitude' => '32.35631', 'gps_longitude' => '-86.16372']);
Venue::create(['name' => 'The Wharf', 'venue_type_id' => 1, 'gps_latitude' => '10.686611', 'gps_longitude' => '122.951072']);
Venue::create(['name' => 'Decatur Mall', 'venue_type_id' => 1, 'gps_latitude' => '10.686611', 'gps_longitude' => '122.951072']);
Venue::create(['name' => 'University Mall ', 'venue_type_id' => 1, 'gps_latitude' => '34.101872', 'gps_longitude' => '-117.773116']);
Venue::create(['name' => 'Eastern Shore Centre', 'venue_type_id' => 1, 'gps_latitude' => '34.101872', 'gps_longitude' => '-117.773116']);
Venue::create(['name' => 'Factory Stores of America ', 'venue_type_id' => 1, 'gps_latitude' => '34.216006', 'gps_longitude' => '-119.062601']);
Venue::create(['name' => 'Gadsden Mall ', 'venue_type_id' => 1, 'gps_latitude' => '34.216006', 'gps_longitude' => '-119.062601']);
Venue::create(['name' => 'Madison Square ', 'venue_type_id' => 1, 'gps_latitude' => '36.254304', 'gps_longitude' => '-86.717035']);
Venue::create(['name' => 'Midtown Village ', 'venue_type_id' => 1, 'gps_latitude' => '36.254304', 'gps_longitude' => '-86.717035']);
Venue::create(['name' => 'Parkway Place Mall', 'venue_type_id' => 1, 'gps_latitude' => '29.615892', 'gps_longitude' => '-95.60425']);
Venue::create(['name' => 'Patton Creek', 'venue_type_id' => 1, 'gps_latitude' => '29.615892', 'gps_longitude' => '-95.60425']);
Venue::create(['name' => 'Vestavia Hills CITYCenter', 'venue_type_id' => 1, 'gps_latitude' => '33.485576', 'gps_longitude' => '-86.830841']);
Venue::create(['name' => 'Village Mall', 'venue_type_id' => 1, 'gps_latitude' => '33.485576', 'gps_longitude' => '-86.830841']);
Venue::create(['name' => 'Wiregrass Commons Mall ', 'venue_type_id' => 1, 'gps_latitude' => '34.246417', 'gps_longitude' => '-77.849332']);
Venue::create(['name' => 'Anchorage 5th Avenue Mall', 'venue_type_id' => 1, 'gps_latitude' => '34.246417', 'gps_longitude' => '-77.849332']);
Venue::create(['name' => 'Dimond Center', 'venue_type_id' => 1, 'gps_latitude' => '61.145504', 'gps_longitude' => '-149.871616']);
Venue::create(['name' => 'Ketchikan Plaza', 'venue_type_id' => 1, 'gps_latitude' => '31.903583', 'gps_longitude' => '-106.41607']);
Venue::create(['name' => 'Northway Mall', 'venue_type_id' => 1, 'gps_latitude' => '42.70616', 'gps_longitude' => '-73.825662']);
Venue::create(['name' => 'Arizona Center', 'venue_type_id' => 1, 'gps_latitude' => '33.453821', 'gps_longitude' => '-112.069434']);
Venue::create(['name' => 'Arizona Mills', 'venue_type_id' => 1, 'gps_latitude' => '34.508771', 'gps_longitude' => '-109.35884']);
Venue::create(['name' => 'Arrowhead Towne Center', 'venue_type_id' => 1, 'gps_latitude' => '33.639646', 'gps_longitude' => '-112.225906']);
Venue::create(['name' => 'Biltmore Fashion Park ', 'venue_type_id' => 1, 'gps_latitude' => '0', 'gps_longitude' => '0']);
Venue::create(['name' => 'Borgata of Scottsdale', 'venue_type_id' => 1, 'gps_latitude' => '33.49417', 'gps_longitude' => '-111.926052']);
Venue::create(['name' => 'Camelback Colonnade', 'venue_type_id' => 1, 'gps_latitude' => '33.49417', 'gps_longitude' => '-111.926052']);
Venue::create(['name' => 'Citadelle Plaza', 'venue_type_id' => 1, 'gps_latitude' => '37.713748', 'gps_longitude' => '-121.405368']);
Venue::create(['name' => 'Dana Park Village Square', 'venue_type_id' => 1, 'gps_latitude' => '33.367267', 'gps_longitude' => '-111.761336']);
Venue::create(['name' => 'Desert Ridge Marketplace', 'venue_type_id' => 1, 'gps_latitude' => '33.6771', 'gps_longitude' => '-111.974035']);
Venue::create(['name' => 'Desert Sky Mall', 'venue_type_id' => 1, 'gps_latitude' => '32.384064', 'gps_longitude' => '-110.970482']);
Venue::create(['name' => 'Fiesta Mall ', 'venue_type_id' => 1, 'gps_latitude' => '33.390085', 'gps_longitude' => '-111.857989']);
Venue::create(['name' => 'Flagstaff Mall', 'venue_type_id' => 1, 'gps_latitude' => '35.224115', 'gps_longitude' => '-111.578109']);
Venue::create(['name' => 'Foothills Mall ', 'venue_type_id' => 1, 'gps_latitude' => '35.743989', 'gps_longitude' => '-83.99801']);
Venue::create(['name' => 'Gilbert Town Square ', 'venue_type_id' => 1, 'gps_latitude' => '33.328843', 'gps_longitude' => '-111.794471']);
Venue::create(['name' => 'Green Valley Village ', 'venue_type_id' => 1, 'gps_latitude' => '31.854251', 'gps_longitude' => '-110.993702']);
Venue::create(['name' => 'Chandler Fashion Center', 'venue_type_id' => 1, 'gps_latitude' => '33.299794', 'gps_longitude' => '-111.902178']);
Venue::create(['name' => 'Christown Spectrum Mall ', 'venue_type_id' => 1, 'gps_latitude' => '0', 'gps_longitude' => '0']);
Venue::create(['name' => 'Kierkland Commons ', 'venue_type_id' => 1, 'gps_latitude' => '33.623773', 'gps_longitude' => '-111.928029']);
Venue::create(['name' => 'La Encantada ', 'venue_type_id' => 1, 'gps_latitude' => '33.623773', 'gps_longitude' => '-111.928029']);
Venue::create(['name' => 'Main Gate Square', 'venue_type_id' => 1, 'gps_latitude' => '41.797655', 'gps_longitude' => '-70.776659']);
Venue::create(['name' => 'Metro Center Mall', 'venue_type_id' => 1, 'gps_latitude' => '33.576189', 'gps_longitude' => '-112.122541']);
Venue::create(['name' => 'Paradise Valley Mall', 'venue_type_id' => 1, 'gps_latitude' => '33.603422', 'gps_longitude' => '-111.979392']);
Venue::create(['name' => 'Paradise Village Gateway ', 'venue_type_id' => 1, 'gps_latitude' => '36.085679', 'gps_longitude' => '-115.084405']);
Venue::create(['name' => 'Park Place', 'venue_type_id' => 1, 'gps_latitude' => '42.857372', 'gps_longitude' => '-72.560793']);
Venue::create(['name' => 'Prescott Gateway Mall', 'venue_type_id' => 1, 'gps_latitude' => '34.540024', 'gps_longitude' => '-112.468502']);
Venue::create(['name' => 'Promenade at Casa Grande ', 'venue_type_id' => 1, 'gps_latitude' => '44.154337', 'gps_longitude' => '-121.242582']);
Venue::create(['name' => 'SanTan Village ', 'venue_type_id' => 1, 'gps_latitude' => '47.023655', 'gps_longitude' => '5.661037']);
Venue::create(['name' => 'Scottsdale Pavilions', 'venue_type_id' => 1, 'gps_latitude' => '33.538686', 'gps_longitude' => '-111.886711']);
Venue::create(['name' => 'Scottsdale Quarter ', 'venue_type_id' => 1, 'gps_latitude' => '35.890032', 'gps_longitude' => '-78.686209']);
Venue::create(['name' => 'Superstition Spring Center ', 'venue_type_id' => 1, 'gps_latitude' => '33.391386', 'gps_longitude' => '-111.69479']);
Venue::create(['name' => 'Tempe Marketplace ', 'venue_type_id' => 1, 'gps_latitude' => '33.430881', 'gps_longitude' => '-111.904639']);
Venue::create(['name' => 'The Mall at Sierra Vista ', 'venue_type_id' => 1, 'gps_latitude' => '39.473727', 'gps_longitude' => '-119.792764']);
Venue::create(['name' => 'The Pavilions at Talking Stick', 'venue_type_id' => 1, 'gps_latitude' => '0', 'gps_longitude' => '0']);
Venue::create(['name' => 'The Shops at Gainey Village', 'venue_type_id' => 1, 'gps_latitude' => '0', 'gps_longitude' => '0']);
Venue::create(['name' => 'The Shop at Norterra', 'venue_type_id' => 1, 'gps_latitude' => '0', 'gps_longitude' => '0']);
Venue::create(['name' => 'The Tucson Mall', 'venue_type_id' => 1, 'gps_latitude' => '32.287496', 'gps_longitude' => '-110.966842']);
Venue::create(['name' => 'Westgate CITYCenter', 'venue_type_id' => 1, 'gps_latitude' => '54.878352', 'gps_longitude' => '-1.407807']);
Venue::create(['name' => 'Yuma Palms ', 'venue_type_id' => 1, 'gps_latitude' => '32.665834', 'gps_longitude' => '-114.515498']);
Venue::create(['name' => 'Central Mall Fort Smith ', 'venue_type_id' => 1, 'gps_latitude' => '35.366204', 'gps_longitude' => '-94.375857']);
Venue::create(['name' => 'Hot Springs Mall', 'venue_type_id' => 1, 'gps_latitude' => '34.452141', 'gps_longitude' => '-93.078438']);
Venue::create(['name' => 'McCain Mall', 'venue_type_id' => 1, 'gps_latitude' => '34.791592', 'gps_longitude' => '-92.225948']);
Venue::create(['name' => 'Northwest Arkansas Mall ', 'venue_type_id' => 1, 'gps_latitude' => '36.128651', 'gps_longitude' => '-94.148155']);
Venue::create(['name' => 'Park Plaza Mall', 'venue_type_id' => 1, 'gps_latitude' => '38.034525', 'gps_longitude' => '-78.477974']);
Venue::create(['name' => 'Pinnacle Hills Promenade', 'venue_type_id' => 1, 'gps_latitude' => '36.306312', 'gps_longitude' => '-94.187031']);
Venue::create(['name' => 'Pleasant Ridge Town Center', 'venue_type_id' => 1, 'gps_latitude' => '42.471147', 'gps_longitude' => '-83.142148']);
Venue::create(['name' => 'The Mall at Turtle Creek ', 'venue_type_id' => 1, 'gps_latitude' => '35.82325', 'gps_longitude' => '-90.664045']);
Venue::create(['name' => 'Aspen Grove', 'venue_type_id' => 1, 'gps_latitude' => '43.58334', 'gps_longitude' => '-111.173235']);
Venue::create(['name' => 'Aurora CITYPlace', 'venue_type_id' => 1, 'gps_latitude' => '41.808264', 'gps_longitude' => '-88.202062']);
Venue::create(['name' => 'Belmar', 'venue_type_id' => 1, 'gps_latitude' => '40.178447', 'gps_longitude' => '-74.021804']);
Venue::create(['name' => 'Colorado Mills', 'venue_type_id' => 1, 'gps_latitude' => '28.598663', 'gps_longitude' => '-95.98047']);
Venue::create(['name' => 'Denver Pavilions', 'venue_type_id' => 1, 'gps_latitude' => '39.749548', 'gps_longitude' => '-105.055818']);
Venue::create(['name' => 'Denver West Village ', 'venue_type_id' => 1, 'gps_latitude' => '39.703517', 'gps_longitude' => '-105.020676']);
Venue::create(['name' => 'FlatIron Crossing ', 'venue_type_id' => 1, 'gps_latitude' => '46.241108', 'gps_longitude' => '-116.815188']);
Venue::create(['name' => 'Foothills Mall ', 'venue_type_id' => 1, 'gps_latitude' => '35.743989', 'gps_longitude' => '-83.99801']);
Venue::create(['name' => 'Greeley Mall', 'venue_type_id' => 1, 'gps_latitude' => '40.390639', 'gps_longitude' => '-104.712448']);
Venue::create(['name' => 'Chapel Hills Mall', 'venue_type_id' => 1, 'gps_latitude' => '41.113735', 'gps_longitude' => '-81.471234']);
Venue::create(['name' => 'Cherry Creek ', 'venue_type_id' => 1, 'gps_latitude' => '39.720689', 'gps_longitude' => '-104.947647']);
Venue::create(['name' => 'Larkridge & Larkridge South ', 'venue_type_id' => 1, 'gps_latitude' => '27.285212', 'gps_longitude' => '-82.496311']);
Venue::create(['name' => 'Marketplace at Austin Bluffs', 'venue_type_id' => 1, 'gps_latitude' => '30.392034', 'gps_longitude' => '-97.6775']);
Venue::create(['name' => 'Mesa Mall', 'venue_type_id' => 1, 'gps_latitude' => '39.09096', 'gps_longitude' => '-108.600341']);
Venue::create(['name' => 'Northfield Stapleton', 'venue_type_id' => 1, 'gps_latitude' => '39.783945', 'gps_longitude' => '-104.900164']);
Venue::create(['name' => 'Park Meadows', 'venue_type_id' => 1, 'gps_latitude' => '28.000018', 'gps_longitude' => '-97.539043']);
Venue::create(['name' => 'Pueblo Mall', 'venue_type_id' => 1, 'gps_latitude' => '38.303806', 'gps_longitude' => '-104.610479']);
Venue::create(['name' => 'Ridgeview Marketplace ', 'venue_type_id' => 1, 'gps_latitude' => '38.939434', 'gps_longitude' => '-94.799586']);
Venue::create(['name' => 'Southlands Town Center ', 'venue_type_id' => 1, 'gps_latitude' => '-45.415716', 'gps_longitude' => '167.71472']);
Venue::create(['name' => 'Southwest Plaza', 'venue_type_id' => 1, 'gps_latitude' => '39.613761', 'gps_longitude' => '-105.09207']);
Venue::create(['name' => 'The Orchad Town Center', 'venue_type_id' => 1, 'gps_latitude' => '29.587967', 'gps_longitude' => '-95.629419']);
Venue::create(['name' => 'The Promenade Shops at Briargate ', 'venue_type_id' => 1, 'gps_latitude' => '0', 'gps_longitude' => '0']);
Venue::create(['name' => 'The Promenade Shops at Centerra', 'venue_type_id' => 1, 'gps_latitude' => '0', 'gps_longitude' => '0']);
Venue::create(['name' => 'The Streets at South Glenn', 'venue_type_id' => 1, 'gps_latitude' => '43.987897', 'gps_longitude' => '-102.238989']);
Venue::create(['name' => 'The Village Shopping Center ', 'venue_type_id' => 1, 'gps_latitude' => '39.564869', 'gps_longitude' => '-76.980175']);
Venue::create(['name' => 'Town Center at Aurora ', 'venue_type_id' => 1, 'gps_latitude' => '36.303584', 'gps_longitude' => '-115.273885']);
Venue::create(['name' => 'Twenty Ninth Street ', 'venue_type_id' => 1, 'gps_latitude' => '28.363336', 'gps_longitude' => '-82.19056']);
Venue::create(['name' => 'Twin Peaks Mall ', 'venue_type_id' => 1, 'gps_latitude' => '40.146785', 'gps_longitude' => '-105.12623']);
Venue::create(['name' => '4S Commons Town Center', 'venue_type_id' => 1, 'gps_latitude' => '32.110932', 'gps_longitude' => '-82.370147']);
Venue::create(['name' => 'Alameda Towne Centre', 'venue_type_id' => 1, 'gps_latitude' => '37.528527', 'gps_longitude' => '-122.306029']);
Venue::create(['name' => 'Almaden Plaza Shopping Center', 'venue_type_id' => 1, 'gps_latitude' => '37.249334', 'gps_longitude' => '-121.862665']);
Venue::create(['name' => 'Amerige Heights Town Center ', 'venue_type_id' => 1, 'gps_latitude' => '0', 'gps_longitude' => '0']);
Venue::create(['name' => 'Anaheim Town Square', 'venue_type_id' => 1, 'gps_latitude' => '33.810506', 'gps_longitude' => '-117.918592']);
Venue::create(['name' => 'Antelope Valley Mall ', 'venue_type_id' => 1, 'gps_latitude' => '34.678516', 'gps_longitude' => '-118.158347']);
Venue::create(['name' => 'Arden Fair ', 'venue_type_id' => 1, 'gps_latitude' => '38.600953', 'gps_longitude' => '-121.426333']);
Venue::create(['name' => 'Ashland Town Center', 'venue_type_id' => 1, 'gps_latitude' => '42.194576', 'gps_longitude' => '-122.709477']);
Venue::create(['name' => 'Baldwin Hills Crenshaw Plaza', 'venue_type_id' => 1, 'gps_latitude' => '34.018002', 'gps_longitude' => '-118.335099']);
Venue::create(['name' => 'Bay Street ', 'venue_type_id' => 1, 'gps_latitude' => '31.144255', 'gps_longitude' => '-81.494882']);
Venue::create(['name' => 'Bayfair Center', 'venue_type_id' => 1, 'gps_latitude' => '37.701774', 'gps_longitude' => '-122.126939']);
Venue::create(['name' => 'Bayshore Mall', 'venue_type_id' => 1, 'gps_latitude' => '40.780446', 'gps_longitude' => '-124.188855']);
Venue::create(['name' => 'Bella Terra Huntington Beach ', 'venue_type_id' => 1, 'gps_latitude' => '33.730875', 'gps_longitude' => '-117.994645']);
Venue::create(['name' => 'Beverly Center', 'venue_type_id' => 1, 'gps_latitude' => '34.073898', 'gps_longitude' => '-118.3773']);
Venue::create(['name' => 'Blackhawk Plaza', 'venue_type_id' => 1, 'gps_latitude' => '42.480404', 'gps_longitude' => '-89.04441']);
Venue::create(['name' => 'Blue Oaks Town Centr', 'venue_type_id' => 1, 'gps_latitude' => '47.637335', 'gps_longitude' => '-122.643946']);
Venue::create(['name' => 'Bon Air Center', 'venue_type_id' => 1, 'gps_latitude' => '37.946594', 'gps_longitude' => '-122.523828']);
Venue::create(['name' => 'Brea Downtown ', 'venue_type_id' => 1, 'gps_latitude' => '33.916681', 'gps_longitude' => '-117.90006']);
Venue::create(['name' => 'Brea Mall', 'venue_type_id' => 1, 'gps_latitude' => '33.913937', 'gps_longitude' => '-117.883862']);
Venue::create(['name' => 'Broadway Plaza', 'venue_type_id' => 1, 'gps_latitude' => '40.704512', 'gps_longitude' => '-74.014276']);
Venue::create(['name' => 'Buena Park Downtown ', 'venue_type_id' => 1, 'gps_latitude' => '33.867514', 'gps_longitude' => '-117.998118']);
Venue::create(['name' => 'Burbank Town Center', 'venue_type_id' => 1, 'gps_latitude' => '34.180839', 'gps_longitude' => '-118.308966']);
Venue::create(['name' => 'Canyon Center', 'venue_type_id' => 1, 'gps_latitude' => '38.020003', 'gps_longitude' => '-87.50566']);
Venue::create(['name' => 'Canyon Crest Towne Centre', 'venue_type_id' => 1, 'gps_latitude' => '32.803184', 'gps_longitude' => '-96.623669']);
Venue::create(['name' => 'Capitol Mall', 'venue_type_id' => 1, 'gps_latitude' => '38.578675', 'gps_longitude' => '-121.501578']);
Venue::create(['name' => 'Carmel Mountin Plaza', 'venue_type_id' => 1, 'gps_latitude' => '32.965', 'gps_longitude' => '-117.119046']);
Venue::create(['name' => 'Carmel Plaza', 'venue_type_id' => 1, 'gps_latitude' => '39.9368', 'gps_longitude' => '-86.236005']);
Venue::create(['name' => 'Centerpoint Mall ', 'venue_type_id' => 1, 'gps_latitude' => '16.617925', 'gps_longitude' => '120.317389']);
Venue::create(['name' => 'CITYPlace', 'venue_type_id' => 1, 'gps_latitude' => '32.806132', 'gps_longitude' => '-96.793574']);
Venue::create(['name' => 'Clairemont Town Square S/C', 'venue_type_id' => 1, 'gps_latitude' => '32.82869', 'gps_longitude' => '-117.135601']);
Venue::create(['name' => 'Coddingtown Mall ', 'venue_type_id' => 1, 'gps_latitude' => '38.458346', 'gps_longitude' => '-122.730995']);
Venue::create(['name' => 'COUNTRY Fair Mall ', 'venue_type_id' => 1, 'gps_latitude' => '48.451775', 'gps_longitude' => '-89.254188']);
Venue::create(['name' => 'Crossing at Corona', 'venue_type_id' => 1, 'gps_latitude' => '33.826106', 'gps_longitude' => '-117.515828']);
Venue::create(['name' => 'Del Mar Plaza', 'venue_type_id' => 1, 'gps_latitude' => '-38.260097', 'gps_longitude' => '-57.824934']);
Venue::create(['name' => 'Del Monte Center ', 'venue_type_id' => 1, 'gps_latitude' => '36.585205', 'gps_longitude' => '-121.896699']);
Venue::create(['name' => 'Downtown Pleasant Hill ', 'venue_type_id' => 1, 'gps_latitude' => '37.947979', 'gps_longitude' => '-122.060796']);
Venue::create(['name' => 'Downtown Sunnyvale ', 'venue_type_id' => 1, 'gps_latitude' => '37.36883', 'gps_longitude' => '-122.03635']);
Venue::create(['name' => 'Eagle Rock Plaza ', 'venue_type_id' => 1, 'gps_latitude' => '45.438571', 'gps_longitude' => '-66.32544']);
Venue::create(['name' => 'Eastridge', 'venue_type_id' => 1, 'gps_latitude' => '37.6735', 'gps_longitude' => '-97.2518']);
Venue::create(['name' => 'El Cerrito Plaza', 'venue_type_id' => 1, 'gps_latitude' => '37.903059', 'gps_longitude' => '-122.299272']);
Venue::create(['name' => 'Embarcadero Center ', 'venue_type_id' => 1, 'gps_latitude' => '37.794873', 'gps_longitude' => '-122.397892']);
Venue::create(['name' => 'Fashion Fair ', 'venue_type_id' => 1, 'gps_latitude' => '36.807032', 'gps_longitude' => '-119.778851']);
Venue::create(['name' => 'Fashion Island', 'venue_type_id' => 1, 'gps_latitude' => '37.554351', 'gps_longitude' => '-122.291372']);
Venue::create(['name' => 'Fashion Valley ', 'venue_type_id' => 1, 'gps_latitude' => '32.768569', 'gps_longitude' => '-117.167075']);
Venue::create(['name' => 'Fountains at Roseville', 'venue_type_id' => 1, 'gps_latitude' => '38.752124', 'gps_longitude' => '-121.288006']);
Venue::create(['name' => 'Fremont Hub ', 'venue_type_id' => 1, 'gps_latitude' => '37.545142', 'gps_longitude' => '-121.987177']);
Venue::create(['name' => 'Galleria at Tyler ', 'venue_type_id' => 1, 'gps_latitude' => '33.909748', 'gps_longitude' => '-117.457836']);
Venue::create(['name' => 'Glendale Galleria ', 'venue_type_id' => 1, 'gps_latitude' => '34.145785', 'gps_longitude' => '-118.258443']);
Venue::create(['name' => 'Great Mall ', 'venue_type_id' => 1, 'gps_latitude' => '37.415774', 'gps_longitude' => '-121.905068']);
Venue::create(['name' => 'Grossmont Center ', 'venue_type_id' => 1, 'gps_latitude' => '32.779496', 'gps_longitude' => '-117.009158']);
Venue::create(['name' => 'Hacienda Crossings', 'venue_type_id' => 1, 'gps_latitude' => '37.704055', 'gps_longitude' => '-121.884597']);
Venue::create(['name' => 'Hanford Mall ', 'venue_type_id' => 1, 'gps_latitude' => '36.32535', 'gps_longitude' => '-119.668541']);
Venue::create(['name' => 'Harden Ranch Plaza', 'venue_type_id' => 1, 'gps_latitude' => '0', 'gps_longitude' => '0']);
Venue::create(['name' => 'Hillsdale Shopping Center ', 'venue_type_id' => 1, 'gps_latitude' => '37.537417', 'gps_longitude' => '-122.300192']);
Venue::create(['name' => 'Hilltop Mall ', 'venue_type_id' => 1, 'gps_latitude' => '49.030205', 'gps_longitude' => '-122.800978']);
Venue::create(['name' => 'Hollywood & Highland Center', 'venue_type_id' => 1, 'gps_latitude' => '33.33578', 'gps_longitude' => '-105.600741']);
Venue::create(['name' => 'Chico Mall ', 'venue_type_id' => 1, 'gps_latitude' => '39.729128', 'gps_longitude' => '-121.803682']);
Venue::create(['name' => 'Chino Spectrum Marketplace ', 'venue_type_id' => 1, 'gps_latitude' => '0', 'gps_longitude' => '0']);
Venue::create(['name' => 'Chula Vista Center ', 'venue_type_id' => 1, 'gps_latitude' => '32.640732', 'gps_longitude' => '-117.08532']);
Venue::create(['name' => 'Imperial Valley Mall', 'venue_type_id' => 1, 'gps_latitude' => '29.993761', 'gps_longitude' => '-95.408411']);
Venue::create(['name' => 'Inland Center ', 'venue_type_id' => 1, 'gps_latitude' => '29.760588', 'gps_longitude' => '-94.965124']);
Venue::create(['name' => 'Irvine Spectrum Center', 'venue_type_id' => 1, 'gps_latitude' => '33.650882', 'gps_longitude' => '-117.744112']);
Venue::create(['name' => 'Japan Center ', 'venue_type_id' => 1, 'gps_latitude' => '40.913846', 'gps_longitude' => '-73.121042']);
Venue::create(['name' => 'Kings Village', 'venue_type_id' => 1, 'gps_latitude' => '37.048593', 'gps_longitude' => '-122.02813']);
Venue::create(['name' => 'La Cumbre Plaza ', 'venue_type_id' => 1, 'gps_latitude' => '33.729339', 'gps_longitude' => '-118.318549']);
Venue::create(['name' => 'Laguna Hills Mall', 'venue_type_id' => 1, 'gps_latitude' => '33.610189', 'gps_longitude' => '-117.707538']);
Venue::create(['name' => 'Lake Arrowhead Village ', 'venue_type_id' => 1, 'gps_latitude' => '34.24834', 'gps_longitude' => '-117.189208']);
Venue::create(['name' => 'Lakewood Center ', 'venue_type_id' => 1, 'gps_latitude' => '34.535018', 'gps_longitude' => '-94.153539']);
Venue::create(['name' => 'Lancaster Marketplace ', 'venue_type_id' => 1, 'gps_latitude' => '34.666908', 'gps_longitude' => '-118.126395']);
Venue::create(['name' => 'Lomas Santa Fe Plaza', 'venue_type_id' => 1, 'gps_latitude' => '32.995525', 'gps_longitude' => '-117.250584']);
Venue::create(['name' => 'Los Cerritos Center', 'venue_type_id' => 1, 'gps_latitude' => '33.86362', 'gps_longitude' => '-118.094454']);
Venue::create(['name' => 'Macys Plaza ', 'venue_type_id' => 1, 'gps_latitude' => '41.25979', 'gps_longitude' => '-70.065112']);
Venue::create(['name' => 'Mall of Victor Valley ', 'venue_type_id' => 1, 'gps_latitude' => '34.474691', 'gps_longitude' => '-117.346068']);
Venue::create(['name' => 'Manhattan Village ', 'venue_type_id' => 1, 'gps_latitude' => '39.183608', 'gps_longitude' => '-96.571669']);
Venue::create(['name' => 'Manchester Center ', 'venue_type_id' => 1, 'gps_latitude' => '41.77729', 'gps_longitude' => '-72.535272']);
Venue::create(['name' => 'Merced Mall ', 'venue_type_id' => 1, 'gps_latitude' => '37.320989', 'gps_longitude' => '-120.483922']);
Venue::create(['name' => 'Metreon Shopping Centre', 'venue_type_id' => 1, 'gps_latitude' => '0', 'gps_longitude' => '0']);
Venue::create(['name' => 'Montclair Plaza ', 'venue_type_id' => 1, 'gps_latitude' => '40.82561', 'gps_longitude' => '-74.153688']);
Venue::create(['name' => 'Monte Vista Crossings', 'venue_type_id' => 1, 'gps_latitude' => '37.417302', 'gps_longitude' => '-122.071296']);
Venue::create(['name' => 'Montebello Town Center ', 'venue_type_id' => 1, 'gps_latitude' => '45.651949', 'gps_longitude' => '-74.940872']);
Venue::create(['name' => 'Montgomery Village Shopping Ctr. ', 'venue_type_id' => 1, 'gps_latitude' => '32.335904', 'gps_longitude' => '-86.307564']);
Venue::create(['name' => 'Moreno Valley Mall ', 'venue_type_id' => 1, 'gps_latitude' => '33.938122', 'gps_longitude' => '-117.22462']);
Venue::create(['name' => 'Mt. Shasta Mall ', 'venue_type_id' => 1, 'gps_latitude' => '40.589233', 'gps_longitude' => '-122.355138']);
Venue::create(['name' => 'New Park Mall ', 'venue_type_id' => 1, 'gps_latitude' => '52.857796', 'gps_longitude' => '-2.723253']);
Venue::create(['name' => 'Northgate ', 'venue_type_id' => 1, 'gps_latitude' => '39.252835', 'gps_longitude' => '-84.592446']);
Venue::create(['name' => 'Northridge Fashion Center ', 'venue_type_id' => 1, 'gps_latitude' => '34.239999', 'gps_longitude' => '-118.554881']);
Venue::create(['name' => 'Northridge Mall ', 'venue_type_id' => 1, 'gps_latitude' => '43.181067', 'gps_longitude' => '-88.006488']);
Venue::create(['name' => 'Norwalk Town Square ', 'venue_type_id' => 1, 'gps_latitude' => '43.831853', 'gps_longitude' => '-90.624771']);
Venue::create(['name' => 'Nut Tree ', 'venue_type_id' => 1, 'gps_latitude' => '50.876281', 'gps_longitude' => '-2.779139']);
Venue::create(['name' => 'Ontario Mills ', 'venue_type_id' => 1, 'gps_latitude' => '34.075728', 'gps_longitude' => '-117.550102']);
Venue::create(['name' => 'Otay Ranch Town Center ', 'venue_type_id' => 1, 'gps_latitude' => '32.627457', 'gps_longitude' => '-116.968078']);
Venue::create(['name' => 'Pacific View ', 'venue_type_id' => 1, 'gps_latitude' => '33.462429', 'gps_longitude' => '-117.676258']);
Venue::create(['name' => 'Panorama Mall ', 'venue_type_id' => 1, 'gps_latitude' => '40.515464', 'gps_longitude' => '-85.655368']);
Venue::create(['name' => 'Park West Place ', 'venue_type_id' => 1, 'gps_latitude' => '32.882067', 'gps_longitude' => '-79.783417']);
Venue::create(['name' => 'Paseo Colorado ', 'venue_type_id' => 1, 'gps_latitude' => '-34.822968', 'gps_longitude' => '-58.63215']);
Venue::create(['name' => 'Paseo Nuevo ', 'venue_type_id' => 1, 'gps_latitude' => '35.176666', 'gps_longitude' => '-106.576454']);
Venue::create(['name' => 'Plaza Carolina Puerto Rico ', 'venue_type_id' => 1, 'gps_latitude' => '18.424714', 'gps_longitude' => '-65.981342']);
Venue::create(['name' => 'Plaza Mexico ', 'venue_type_id' => 1, 'gps_latitude' => '19.727672', 'gps_longitude' => '-101.141821']);
Venue::create(['name' => 'Promenade at Howard Hughes Center', 'venue_type_id' => 1, 'gps_latitude' => '33.97803', 'gps_longitude' => '-118.391548']);
Venue::create(['name' => 'Promenade on the Peninsula ', 'venue_type_id' => 1, 'gps_latitude' => '46.39871', 'gps_longitude' => '-87.223877']);
Venue::create(['name' => 'Promenade Temecula ', 'venue_type_id' => 1, 'gps_latitude' => '33.52143', 'gps_longitude' => '-117.153019']);
Venue::create(['name' => 'Punete Hills ', 'venue_type_id' => 1, 'gps_latitude' => '34.452019', 'gps_longitude' => '-118.56242']);
Venue::create(['name' => 'River Park ', 'venue_type_id' => 1, 'gps_latitude' => '41.350445', 'gps_longitude' => '-86.298834']);
Venue::create(['name' => 'Riverside Plaza ', 'venue_type_id' => 1, 'gps_latitude' => '37.240017', 'gps_longitude' => '-82.066699']);
Venue::create(['name' => 'San Bruno Towne Center ', 'venue_type_id' => 1, 'gps_latitude' => '37.63049', 'gps_longitude' => '-122.411084']);
Venue::create(['name' => 'Santa Maria Town Center ', 'venue_type_id' => 1, 'gps_latitude' => '34.953034', 'gps_longitude' => '-120.435719']);
Venue::create(['name' => 'Santa Monica Place', 'venue_type_id' => 1, 'gps_latitude' => '27.739139', 'gps_longitude' => '-97.377704']);
Venue::create(['name' => 'Santa Rosa Plaza ', 'venue_type_id' => 1, 'gps_latitude' => '-37.887793', 'gps_longitude' => '-67.741531']);
Venue::create(['name' => 'Santana Row ', 'venue_type_id' => 1, 'gps_latitude' => '37.321632', 'gps_longitude' => '-121.947919']);
Venue::create(['name' => 'Seacliff Village Shopping Center', 'venue_type_id' => 1, 'gps_latitude' => '0', 'gps_longitude' => '0']);
Venue::create(['name' => 'Seaport Village ', 'venue_type_id' => 1, 'gps_latitude' => '32.709237', 'gps_longitude' => '-117.170121']);
Venue::create(['name' => 'Serramonte Center ', 'venue_type_id' => 1, 'gps_latitude' => '37.673102', 'gps_longitude' => '-122.468583']);
Venue::create(['name' => 'Sherman Oaks Galleria ', 'venue_type_id' => 1, 'gps_latitude' => '34.15581', 'gps_longitude' => '-118.468062']);
Venue::create(['name' => 'Sherwood Mall', 'venue_type_id' => 1, 'gps_latitude' => '31.892911', 'gps_longitude' => '-102.377891']);
Venue::create(['name' => 'Shopping At The Rose ', 'venue_type_id' => 1, 'gps_latitude' => '34.22568', 'gps_longitude' => '-77.866555']);
Venue::create(['name' => 'Sierra Vista Mall ', 'venue_type_id' => 1, 'gps_latitude' => '40.803709', 'gps_longitude' => '-77.907244']);
Venue::create(['name' => 'Simi Valley Town Cente r', 'venue_type_id' => 1, 'gps_latitude' => '34.269447', 'gps_longitude' => '-118.781482']);
Venue::create(['name' => 'Solana Beach Towne Centre I - IV', 'venue_type_id' => 1, 'gps_latitude' => '32.991155', 'gps_longitude' => '-117.271148']);
Venue::create(['name' => 'Somersville Towne Center ', 'venue_type_id' => 1, 'gps_latitude' => '41.982874', 'gps_longitude' => '-72.487863']);
Venue::create(['name' => 'South Bay Galleria ', 'venue_type_id' => 1, 'gps_latitude' => '23.78232', 'gps_longitude' => '90.41637']);
Venue::create(['name' => 'South Coast Plaza ', 'venue_type_id' => 1, 'gps_latitude' => '8.727826', 'gps_longitude' => '79.962152']);
Venue::create(['name' => 'SouthBay Pavilion ', 'venue_type_id' => 1, 'gps_latitude' => '33.846746', 'gps_longitude' => '-118.368764']);
Venue::create(['name' => 'Southland Mall', 'venue_type_id' => 1, 'gps_latitude' => '35.018578', 'gps_longitude' => '-90.022565']);
Venue::create(['name' => 'Standfornd Shopping Center ', 'venue_type_id' => 1, 'gps_latitude' => '37.442121', 'gps_longitude' => '-122.170868']);
Venue::create(['name' => 'Stoneridfe Shopping Center ', 'venue_type_id' => 1, 'gps_latitude' => '51.540718', 'gps_longitude' => '-0.261752']);
Venue::create(['name' => 'Stonestown Galleria ', 'venue_type_id' => 1, 'gps_latitude' => '0', 'gps_longitude' => '0']);
Venue::create(['name' => 'Stonewood Center ', 'venue_type_id' => 1, 'gps_latitude' => '33.686249', 'gps_longitude' => '-117.788969']);
Venue::create(['name' => 'Sunrise Mall ', 'venue_type_id' => 1, 'gps_latitude' => '40.682054', 'gps_longitude' => '-73.435405']);
Venue::create(['name' => 'Sunvalley Shopping Center ', 'venue_type_id' => 1, 'gps_latitude' => '33.414189', 'gps_longitude' => '-111.683586']);
Venue::create(['name' => 'Terra Vista Town Center ', 'venue_type_id' => 1, 'gps_latitude' => '33.224727', 'gps_longitude' => '-117.207706']);
Venue::create(['name' => 'The Americana at Brand', 'venue_type_id' => 1, 'gps_latitude' => '34.144417', 'gps_longitude' => '-118.255073']);
Venue::create(['name' => 'The Block at Orange ', 'venue_type_id' => 1, 'gps_latitude' => '0', 'gps_longitude' => '0']);
Venue::create(['name' => 'The Commons at Calabasas ', 'venue_type_id' => 1, 'gps_latitude' => '34.1543', 'gps_longitude' => '-118.646608']);
Venue::create(['name' => 'The Forum at Carlsbad', 'venue_type_id' => 1, 'gps_latitude' => '33.158093', 'gps_longitude' => '-117.350594']);
Venue::create(['name' => 'The Gardens on El Paso ', 'venue_type_id' => 1, 'gps_latitude' => '31.777576', 'gps_longitude' => '-106.442456']);
Venue::create(['name' => 'The Grove ', 'venue_type_id' => 1, 'gps_latitude' => '42.411582', 'gps_longitude' => '-83.296371']);
Venue::create(['name' => 'The Mall of Victor Valley ', 'venue_type_id' => 1, 'gps_latitude' => '34.474691', 'gps_longitude' => '-117.346068']);
Venue::create(['name' => 'The Market Place ', 'venue_type_id' => 1, 'gps_latitude' => '51.585705', 'gps_longitude' => '-0.180867']);
Venue::create(['name' => 'The McHenry Village ', 'venue_type_id' => 1, 'gps_latitude' => '42.333355', 'gps_longitude' => '-88.266753']);
Venue::create(['name' => 'The Oaks ', 'venue_type_id' => 1, 'gps_latitude' => '54.66305', 'gps_longitude' => '-5.908826']);
Venue::create(['name' => 'The Promenade at Westlake ', 'venue_type_id' => 1, 'gps_latitude' => '42.921585', 'gps_longitude' => '-76.436248']);
Venue::create(['name' => 'The Promenade Shops at Dos Lagos ', 'venue_type_id' => 1, 'gps_latitude' => '6.524379', 'gps_longitude' => '3.379206']);
Venue::create(['name' => 'The River at Rancho Mirage ', 'venue_type_id' => 1, 'gps_latitude' => '33.68473', 'gps_longitude' => '-112.329194']);
Venue::create(['name' => 'The Shoppes at Chino Hills ', 'venue_type_id' => 1, 'gps_latitude' => '33.989819', 'gps_longitude' => '-117.732585']);
Venue::create(['name' => 'The Shops at Anaheim Garden Walk ', 'venue_type_id' => 1, 'gps_latitude' => '33.846173', 'gps_longitude' => '-117.95348']);
Venue::create(['name' => 'The Shops at Dos Lagos ', 'venue_type_id' => 1, 'gps_latitude' => '6.524379', 'gps_longitude' => '3.379206']);
Venue::create(['name' => 'The Shops at La Jolla', 'venue_type_id' => 1, 'gps_latitude' => '32.832811', 'gps_longitude' => '-117.271272']);
Venue::create(['name' => 'the Shops at Montebello ', 'venue_type_id' => 1, 'gps_latitude' => '34.034557', 'gps_longitude' => '-118.085037']);
Venue::create(['name' => 'The Shops at Tanforan ', 'venue_type_id' => 1, 'gps_latitude' => '0', 'gps_longitude' => '0']);
Venue::create(['name' => 'Beijing APM Sun Dong An Plaza', 'venue_type_id' => 1, 'gps_latitude' => '39.904211', 'gps_longitude' => '116.407395']);
Venue::create(['name' => 'Beijing Department Store ', 'venue_type_id' => 1, 'gps_latitude' => '39.913465', 'gps_longitude' => '116.410732']);
Venue::create(['name' => 'Golden Resoruces Mall ', 'venue_type_id' => 1, 'gps_latitude' => '22.351163', 'gps_longitude' => '114.109269']);
Venue::create(['name' => 'The Malls (Beijing Oriental Plaza Co.) ', 'venue_type_id' => 1, 'gps_latitude' => '39.904211', 'gps_longitude' => '116.407395']);
Venue::create(['name' => 'Beijing Friendship Store ', 'venue_type_id' => 1, 'gps_latitude' => '39.909151', 'gps_longitude' => '116.442948']);
Venue::create(['name' => 'Shin Kong Place', 'venue_type_id' => 1, 'gps_latitude' => '39.909993', 'gps_longitude' => '116.478767']);
Venue::create(['name' => 'Beijing Yansha Outlets ', 'venue_type_id' => 1, 'gps_latitude' => '39.877648', 'gps_longitude' => '116.486142']);
Venue::create(['name' => 'You Yi Shopping CITY(Beijing Lufthansa Center) ', 'venue_type_id' => 1, 'gps_latitude' => '0', 'gps_longitude' => '0']);
Venue::create(['name' => 'Parkson', 'venue_type_id' => 1, 'gps_latitude' => '36.872731', 'gps_longitude' => '120.538048']);
Venue::create(['name' => 'Chungyou Department Store', 'venue_type_id' => 1, 'gps_latitude' => '0', 'gps_longitude' => '0']);
Venue::create(['name' => 'New World Department Store', 'venue_type_id' => 1, 'gps_latitude' => '30.550777', 'gps_longitude' => '114.266348']);
Venue::create(['name' => 'Grand Pacific', 'venue_type_id' => 1, 'gps_latitude' => '-34.45443', 'gps_longitude' => '150.873841']);
Venue::create(['name' => 'Scitech Shopping Center', 'venue_type_id' => 1, 'gps_latitude' => '39.82854', 'gps_longitude' => '109.985926']);
Venue::create(['name' => 'SOGO ', 'venue_type_id' => 1, 'gps_latitude' => '34.385987', 'gps_longitude' => '133.060626']);
Venue::create(['name' => 'Cuiwei Tower ', 'venue_type_id' => 1, 'gps_latitude' => '0', 'gps_longitude' => '0']);
Venue::create(['name' => 'Cloud Nine', 'venue_type_id' => 1, 'gps_latitude' => '46.760833', 'gps_longitude' => '-100.655278']);
Venue::create(['name' => 'Global harbor ', 'venue_type_id' => 1, 'gps_latitude' => '33.779981', 'gps_longitude' => '-118.287743']);
Venue::create(['name' => 'Gran Gateway ', 'venue_type_id' => 1, 'gps_latitude' => '38.680696', 'gps_longitude' => '-108.976884']);
Venue::create(['name' => 'Plaza 66', 'venue_type_id' => 1, 'gps_latitude' => '-34.95913', 'gps_longitude' => '-57.971139']);
Venue::create(['name' => 'Super Brand Mall', 'venue_type_id' => 1, 'gps_latitude' => '41.79003', 'gps_longitude' => '123.401617']);
Venue::create(['name' => 'Printemps (Huaihai Branch) ', 'venue_type_id' => 1, 'gps_latitude' => '0', 'gps_longitude' => '0']);
Venue::create(['name' => 'Parkson (Huaihai Branch)', 'venue_type_id' => 1, 'gps_latitude' => '0', 'gps_longitude' => '0']);
Venue::create(['name' => 'New Hualian Mansion ', 'venue_type_id' => 1, 'gps_latitude' => '31.218735', 'gps_longitude' => '121.464253']);
Venue::create(['name' => 'Novel Department Store ', 'venue_type_id' => 1, 'gps_latitude' => '0', 'gps_longitude' => '0']);
Venue::create(['name' => 'Times Square', 'venue_type_id' => 1, 'gps_latitude' => '40.758895', 'gps_longitude' => '-73.985131']);
Venue::create(['name' => 'Pacific Department Store (Xuhui Branch) ', 'venue_type_id' => 1, 'gps_latitude' => '0', 'gps_longitude' => '0']);
Venue::create(['name' => 'Grand Gateway ', 'venue_type_id' => 1, 'gps_latitude' => '38.680696', 'gps_longitude' => '-108.976884']);
Venue::create(['name' => 'Huijin Department Store', 'venue_type_id' => 1, 'gps_latitude' => '31.195479', 'gps_longitude' => '121.440172']);
Venue::create(['name' => 'Metro CITY', 'venue_type_id' => 1, 'gps_latitude' => '22.32254', 'gps_longitude' => '114.257067']);
Venue::create(['name' => 'Nextage', 'venue_type_id' => 1, 'gps_latitude' => '35.700243', 'gps_longitude' => '139.619679']);
Venue::create(['name' => 'Shanghai Times Square', 'venue_type_id' => 1, 'gps_latitude' => '31.224256', 'gps_longitude' => '121.478065']);
}
<?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);
});
/**
* Show the form for editing the specified resource.
*
* @param Post $post
* @return Response
* @internal param int $id
*/
public function edit(Post $post)
{
$venues = Venue::orderBy('name')->lists('name', 'id');
return view('posts.edit', compact('post', 'venues'));
}