$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();
