$leaderList=Db::name('mem_leader')->alias('ml')
->join('mem m', 'm.id = ml.mid')
->field("m.id, ml.truename, m.headimg, ml.lat, ml.lng, ml.address, ml.shop_name,(6378.138 * 2 * asin(sqrt(pow(sin((lat * pi() / 180 - ".$data['lat']." * pi() / 180) / 2),2) + cos(lat * pi() / 180) * cos(".$data['lat']." * pi() / 180) * pow(sin((lng * pi() / 180 - ".$data['lng']." * pi() / 180) / 2),2))) * 1000) as distance")
->where($where)
->order('distance')
->paginate(20)
->toArray();
TP5 根据经纬度计算距离,排序+分页
最新推荐文章于 2022-06-21 16:41:31 发布