$query = $this->model;
if (isset($param['latitude']) && $param['latitude'] && isset($param['longitude']) && $param['longitude']) {
$fields = 'ACOS(SIN((' . $param['latitude'] . ' * 3.1415) / 180 ) *SIN((a.latitude * 3.1415) / 180 ) +COS((' . $param['latitude'] . ' * 3.1415) / 180 )
* COS((a.latitude * 3.1415) / 180 ) *COS((' . $param['longitude'] . ' * 3.1415) / 180 - (a.longitude * 3.1415) / 180 ) ) * 6380 as distance';
$query = $query->alias('a')->field($fields . ',a.*')->order("distance asc");
}
$data = $query
->select()
->toArray();
php 根据经纬度计算距离
最新推荐文章于 2024-01-26 18:30:26 发布