ThinkChat2.0新版上线,更智能更精彩,支持会话、画图、阅读、搜索等,送10W Token,即刻开启你的AI之旅 广告
 $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();