/**
* @return string
*/
public function getRankingKey()
{
return $this->geoname->getId() . '-' . $this->cuisine->getId();
}
/**
* @param Geoname $geoname
* @return float
*/
public function getRandomLng(Geoname $geoname)
{
$lng = floatval($geoname->getLng());
return $lng + $this->getRandomOffset();
}
protected function importCity(Geoname $geoname)
{
$previewGeoname = $this->input->getOption('previewGeoname');
if ($previewGeoname) {
return;
}
if ($geoname->getCountry() === 'US') {
$cityName = $geoname->getAsciiName() . ', ' . $geoname->getAdmin1();
} else {
$cityName = $geoname->getAsciiName() . ',' . $geoname->getCountry();
}
$maxPages = $this->input->getOption('pages');
$currentPage = 0;
while ($currentPage < $maxPages) {
$venues = $this->foursquareClient->explore($cityName, $currentPage * 50);
$this->processResults($venues, $geoname);
$currentPage++;
}
}
/**
* @param Geoname $geoname
*
* @throws \Doctrine\DBAL\DBALException
* @return boolean
*/
public function checkIfUsed(Geoname $geoname)
{
$id = $geoname->getId();
$sql = 'SELECT(
(SELECT COUNT(reviews.geoname_id) FROM reviews WHERE geoname_id = ' . $id . ') +
(SELECT COUNT(users.geoname_id) FROM users WHERE geoname_id = ' . $id . ') +
(SELECT COUNT(wishes.geoname_id) FROM wishes WHERE geoname_id = ' . $id . '6) +
(SELECT COUNT(restaurants.geoname_id) FROM restaurants WHERE geoname_id = ' . $id . ')
) as geonameCount';
$result = $this->getEntityManager()->getConnection()->fetchAll($sql);
return $result[0]['geonameCount'] > 0;
}