Here is my query.. I have tried several different ways to get the proper result while formatting for laravel 5, if anyone can assist with the proper format I would greatly appreciate it
SELECT z.id, z.address, z.city, z.state, z.zip,
z.latitude, z.longitude,
(p.distance_unit
* DEGREES(ACOS(COS(RADIANS(p.latpoint))
* COS(RADIANS(z.latitude))
* COS(RADIANS(p.longpoint) - RADIANS(z.longitude))
+ SIN(RADIANS(p.latpoint))
* SIN(RADIANS(z.latitude))))) AS distance
FROM locations AS z
JOIN (
SELECT ? AS latpoint,
? AS longpoint,
? AS radius,
? AS distance_unit
) AS p
WHERE z.latitude
BETWEEN p.latpoint - (p.radius / p.distance_unit)
AND p.latpoint + (p.radius / p.distance_unit)
AND z.longitude
BETWEEN p.longpoint - (p.radius / (p.distance_unit * COS(RADIANS(p.latpoint))))
AND p.longpoint + (p.radius / (p.distance_unit * COS(RADIANS(p.latpoint))))
ORDER BY distance
LIMIT ?
my variables are in order:
$latpoint
$longpoint
$radius
$distance_units
$limit
via Chebli Mohamed
Aucun commentaire:
Enregistrer un commentaire