From f01fbde90834ad67d7db935d8fa9932db566eaaf Mon Sep 17 00:00:00 2001 From: Helius <wangdoubleone@gmail.com> Date: Thu, 29 Jul 2021 10:36:04 +0800 Subject: [PATCH] fix 8500 --> 9500 --- gc-order/src/main/resources/mapper/order/JhyInfoMapper.xml | 2 +- 1 files changed, 1 insertions(+), 1 deletions(-) diff --git a/gc-order/src/main/resources/mapper/order/JhyInfoMapper.xml b/gc-order/src/main/resources/mapper/order/JhyInfoMapper.xml index d0cce37..de88932 100644 --- a/gc-order/src/main/resources/mapper/order/JhyInfoMapper.xml +++ b/gc-order/src/main/resources/mapper/order/JhyInfoMapper.xml @@ -9,6 +9,6 @@ <select id="selectJhyInfoListInAddressRange" resultType="com.xzx.gc.entity.JhyInfo"> select * from xzx_jhy_info a - where 8500 > lat_lng_distance(a.lat, a.lon, (select latitude from xzx_user_address_info where address_id=#{addressId}), (select longitude from xzx_user_address_info where address_id=#{addressId}))*1000 + where 9500 > lat_lng_distance(a.lat, a.lon, (select latitude from xzx_user_address_info where address_id=#{addressId}), (select longitude from xzx_user_address_info where address_id=#{addressId}))*1000 </select> </mapper> \ No newline at end of file -- Gitblit v1.9.1