nielsnuebel/items.md

Last active March 15, 2019 11:45

Star (0) You must be signed in to star a gist
Fork (1) You must be signed in to fork a gist

Learn more about clone URLs
Clone this repository at <script src="https://gist.github.com/nielsnuebel/1a46e9cdfee4debab89ebe8ddf6774ab.js"></script>
Save nielsnuebel/1a46e9cdfee4debab89ebe8ddf6774ab to your computer and use it in GitHub Desktop.

Joomla Umkreissuche Query

Raw

$lat      = $this->getState('filter.lat');
$lng      = $this->getState('filter.lng');
$distance = $this->getState('filter.distance');

if (!empty($lat) && !empty($lng))
{
	//$query->select('( 6371 * acos( cos( radians(' . $lat . ') ) * cos( radians( a.lat ) ) * cos( radians( a.lng ) - radians(' . $lng . ') ) + sin( radians(' . $lat . ') ) * sin( radians( a.lat ) ) ) ) AS distance')
	//->having('distance <= ' . $distance);
	$query->select('( 6371 * acos( cos( radians(' . $lat . ') ) * cos( radians( a.lat ) ) * cos( radians( a.lng ) - radians(' . $lng . ') ) + sin( radians(' . $lat . ') ) * sin( radians( a.lat ) ) ) ) AS distance');
	$query->order($db->escape('distance ASC'));
}

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment