/**
* @param ObjectManager $objectManager
*/
public function load(ObjectManager $objectManager)
{
$csvIterator = new CsvIterator($this->container->getParameter('sulu_event.csv_import_file'));
\Locale::setDefault('de');
$countries = Intl::getRegionBundle()->getCountryNames();
$geocoder = new GoogleMaps(new GuzzleHttpAdapter(), true, $this->container->getParameter('sulu_event.google_maps_api_key'));
$output = $this->getConsoleOutput();
foreach ($csvIterator as $row => $data) {
if (empty($data)) {
break;
}
if ($row == 1) {
continue;
}
// sleep 1 second to prevent Google Geocode API from going OVER_QUERY_LIMIT
sleep(1);
$event = new Event();
$event->setTitle(trim($data[0]) === '' ? 'Nicht definierter Event-Titel' : $data[0]);
$event->setStartDate(new \DateTime($data[1]));
if (!empty($data[2])) {
$event->setStartTime(new \DateTime($data[2]));
}
$event->setDescription('<p>' . $data[3] . '</p>');
$event->setDescriptionVenue('<p>' . $data[4] . '</p>');
$event->setZip($data[5]);
$event->setCity($data[6]);
$countryAlpha2 = array_keys($countries, $data[7]);
$event->setCountry(isset($countryAlpha2[0]) ? $countryAlpha2[0] : 'DE');
$organizer = new EventOrganizer();
$organizer->setTitle($data[10]);
$organizer->setFirstName($data[11]);
$organizer->setLastName($data[12]);
$organizer->setStreet($data[13]);
$organizer->setZip($data[14]);
$organizer->setCity($data[15]);
$organizer->setPhone($data[16]);
$organizer->setFax($data[17]);
$organizer->setEmail($data[18]);
$event->setOrganizer($organizer);
$result = $geocoder->geocode($data[4] . '+' . $data[5]);
if (isset($result->results[0])) {
$event->setLatitude($result->results[0]->geometry->location->lat);
$event->setLongitude($result->results[0]->geometry->location->lng);
} else {
$error = 'No geocoding data at event ' . $data[0] . '(row ' . $row . ') with status' . $result->status;
$output->writeln($error);
$event->setLatitude(0);
$event->setLongitude(0);
}
$event->setWebsite($data[19]);
$objectManager->persist($event);
}
$objectManager->flush();
}
/**
* testGeocodingWillReturnAnArray
*/
public function testGeocodingWillReturnAnArray()
{
$responseMock = $this->prophesize(StreamInterface::class);
$responseMock->getContents()->willReturn('[ { "foo": "bar" }, { "123": 456 } ]');
$this->httpAdapterMock->get(Argument::type('string'))->willReturn($responseMock->reveal());
$googleMapsGeoCoder = new GoogleMaps($this->httpAdapterMock->reveal(), false, 'xoxo');
$results = $googleMapsGeoCoder->geocode('Schützenstraße 8, 10117 Berlin, Deutschland');
$this->assertInternalType('array', $results);
}