/**
* Find locations by contraint
*
* @param \Evoweb\StoreFinder\Domain\Model\Constraint $constraint
* @return \TYPO3\CMS\Extbase\Persistence\QueryResultInterface
*/
public function findByConstraint($constraint)
{
/** @var \TYPO3\CMS\Extbase\Persistence\Generic\Query $query */
$query = $this->createQuery();
if (!$constraint->isGeocoded()) {
return array();
}
$queryParts = array('SELECT' => '
distinct l.*,
(acos(
sin(' . $constraint->getLatitude() * M_PI . ' / 180) *
sin(latitude * ' . M_PI . ' / 180) +
cos(' . $constraint->getLatitude() * M_PI . ' / 180) *
cos(latitude * ' . M_PI . ' / 180) *
cos((' . $constraint->getLongitude() . ' - longitude) * ' . M_PI . ' / 180)
) * 6370) as distance', 'FROM' => 'tx_storefinder_domain_model_location l', 'WHERE' => 'l.pid IN (' . implode(',', $query->getQuerySettings()->getStoragePageIds()) . ')' . $this->getWhereClauseForEnabledFields('tx_storefinder_domain_model_location', 'l'), 'GROUPBY' => '', 'ORDERBY' => 'distance', 'LIMIT' => '');
$queryParts = $this->addCountryQueryPart($constraint, $queryParts);
$queryParts = $this->addCategoryQueryPart($constraint, $queryParts);
$queryParts = $this->addRadiusQueryPart($constraint, $queryParts);
$queryParts = $this->addLimitQueryParts($constraint, $queryParts);
/** @var \TYPO3\CMS\Core\Database\DatabaseConnection $database */
$database = $GLOBALS['TYPO3_DB'];
$sql = $database->SELECTquery($queryParts['SELECT'], $queryParts['FROM'], $queryParts['WHERE'], $queryParts['GROUPBY'], $queryParts['ORDERBY'], $queryParts['LIMIT']);
$query->statement($sql);
return $query->execute();
}
