public function storeEvents($resource)
{
$events = $this->getPageEvents($resource->facebook);
$venue = $resource;
foreach ($events as $event) {
$venueId = isset($event->place->id) ? $event->place->id : null;
if (!$venueId || $venueId != $resource->facebook) {
$venue = Venue::where('name', 'like', $event->place->name)->first();
if (!$venue) {
echo 'No venue found in our database...';
if (isset($event->place->location)) {
echo "getting location info from Facebook\n";
$venueData = ['name' => $event->place->name, 'street' => $event->place->location->street, 'city' => $event->place->location->city, 'state' => $event->place->location->state, 'zip' => $event->place->location->zip, 'longitude' => $event->place->location->longitude, 'latitude' => $event->place->location->latitude, 'facebook' => $event->place->id, 'visible' => true];
} else {
echo "getting location info from Google Maps\n";
$geocoder = new GoogleGeocoder($event->place->name);
$components = $geocoder->getComponents();
$venueData = ['name' => $event->place->name, 'street' => $components['street_number'] . ' ' . $components['route'], 'city' => $components['locality'], 'state' => $components['administrative_area_level_1'], 'zip' => $components['postal_code'], 'longitude' => $components['longitude'], 'latitude' => $components['latitude'], 'visible' => true];
}
$venue = Venue::firstOrCreate($venueData);
echo "Venue created: {$venue->name} ({$venue->id})\n";
}
}
$eventData = ['name' => $event->name, 'description' => isset($event->description) ? $event->description : null, 'start_time' => $this->castToDateTime($event->start_time), 'end_time' => isset($event->end_time) ? $this->castToDateTime($event->end_time) : null, 'facebook' => $event->id, 'venue_id' => $venue->id, 'updated_at' => $this->castToDateTime($event->updated_time), 'tags' => $venue->tags->lists('id')->toArray()];
$this->updateOrCreate($eventData);
}
}
/**
* Search venues by name and street with API.
*
* @return Response
*/
public function getVenuesByLocation(Request $request)
{
$query = $request->get('query');
$venues = Venue::where('name', 'like', "%{$query}%")->orWhere('street', 'like', "%{$query}%")->get();
return response()->json($venues);
}
