[code]
/**
* 获得最近的地理位置信息
*/
function getLocationInfo ($entId,$minLong,$currLat,$currLng,$resultSize = 5) {
$db = $this->db;
try{
$sql = 'select 6371.012 *
acos(cos(acos(-1) / 180 * d.latitude_x) *
cos(acos(-1) / 180 * '.$currLat.') *
cos(acos(-1) / 180 * d.latitude_y - acos(-1) / 180 * '.$currLng.') +
sin(acos(-1) / 180 * d.latitude_x) *
sin(acos(-1) / 180 * '.$currLat.'))*1 as a,
d.latitude_x,d.latitude_y ,d.shop_name,d.address_info,d.id as shop_id,im.path from haier_shop d,haier_images im
where im.shop_id=d.id AND 6371.012 * acos(cos(acos(-1) / 180 * d.latitude_x) *
cos(acos(-1) / 180 * '.$currLat.') *
cos(acos(-1) / 180 * d.latitude_y - acos(-1) / 180 * '.$currLng.') +
sin(acos(-1) / 180 * d.latitude_x) *
sin(acos(-1) / 180 * '.$currLat.'))*1 < '.$minLong.' AND d.is_del=0 AND d.is_check=1 GROUP BY d.id order by a asc
LIMIT '.$resultSize;
// return $sql;die;
return $db->getAll($sql);
}catch (Exception $e){
errorLog('获得最近的地理位置信息sql:'.$sql,$e->getMessage());
return 0;
}
}
[/code]

上一篇:PHP 防止重复提交--令牌TOKEN--SESSION--COOKIE两种方法
下一篇:Thinksns 二次开发随笔---001