该楼层疑似违规已被系统折叠 隐藏此楼查看此楼
//获取经纬度 默认值为0.5千米
function returnSquarePoint($lng, $lat, $distance = 0.5)
{
define('EARTH_RADIUS', '6371'); //地球半径,平均半径为6371km
$dlng = 2 * asin(sin($distance / (2 * EARTH_RADIUS)) / cos(deg2rad($lat)));
$dlng = rad2deg($dlng);
$dlat = $distance / EARTH_RADIUS;
$dlat = rad2deg($dlat);
return array(
'left-top' => array('lat' => $lat + $dlat, 'lng' => $lng - $dlng),
'right-top' => array('lat' => $lat + $dlat, 'lng' => $lng + $dlng),
'left-bottom' => array('lat' => $lat - $dlat, 'lng' => $lng - $dlng),
'right-bottom' => array('lat' => $lat - $dlat, 'lng' => $lng + $dlng),
);
}
/**
* 计算两点地理坐标之间的距离
* @param Decimal $longitude1 起点经度
* @param Decimal $latitude1 起点纬度
* @param Decimal $longitude2 终点经度
* @param Decimal $latitude2 终点纬度
* @param Int $unit 单位 1:米 2:公里
* @param Int $decimal 精度 保留小数位数
* @return Decimal
*/
function getDistance($longitude1, $latitude1, $longitude2, $latitude2, $unit=2, $decimal=2){
$EARTH_RADIUS = 6370.996; // 地球半径系数
$PI = 3.1415926;
$radLat1 = $latitude1 * $PI / 180.0;
$radLat2 = $latitude2 * $PI / 180.0;
$radLng1 = $longitude1 * $PI / 180.0;
$radLng2 = $longitude2 * $PI /180.0;
$a = $radLat1 - $radLat2;
$b = $radLng1 - $radLng2;
$distance = 2 * asin(sqrt(pow(sin($a/2),2) + cos($radLat1) * cos($radLat2) * pow(sin($b/2),2)));
$distance = $distance * $EARTH_RADIUS * 1000;
if($unit==2){
$distance = $distance / 1000;
}
return round($distance, $decimal);
}
//$lng = 117.072157 $lat= 36.187136
$squares = returnSquarePoint($lng, $lat);
$where = "lat<>0 and lat >= {$squares['right-bottom']['lat']} and lat<={$squares['left-top']['lat']} and lng>={$squares['left-top']['lng']} and
lng<={$squares['right-bottom']['lng']} and user_status !=0 and is_auth=1 and id !=".$uid;
$field = "*";
$order = "SQRT((".$lng ."- lng)*(".$lng ."- lng)+(".$lat."- lat )*(".$lat."- lat))";
$list = db('user')->where($where)->order($order)->page($page)->select();
$list = emcee_complete($list);
foreach ($list as &$v) {
//计算距离
$v['distance']=getDistance($lng, $lat, $v['lng'], $v['lat'], $unit=2, $decimal=2);
}