NIUCLOUD是一款SaaS管理后台框架多应用插件+云编译。上千名开发者、服务商正在积极拥抱开发者生态。欢迎开发者们免费入驻。一起助力发展! 广告
 $field = 'ACOS(SIN(('.$addr\["lat"\].' \* 3.1415) / 180 ) \*SIN((a.lat \* 3.1415) / 180 ) +COS(('.$addr\["lat"\].' \* 3.1415) / 180 )                 \* COS((a.lat \* 3.1415) / 180 ) \*COS(('.$addr\["lng"\].' \* 3.1415) / 180 - (a.lng \* 3.1415) / 180 ) ) \* 6380 as distance';             $dot=Db::name('dot')                 ->alias('a')                 ->field($field.",dot\_store\_name,dot\_door\_photo,id,business\_status,service\_distance,xysm")                 ->where($where)                 ->having( "distance<=service\_distance")                 ->order("distance asc") //                ->page($page,$limit)                 ->select();