fix
Helius
2021-12-08 aefcec640848fb6f1bc847f4d5c9074ee7c5c95b
fix
1 files modified
1 ■■■■ changed files
gc-order/src/main/resources/mapper/order/JhyInfoMapper.xml 1 ●●●● patch | view | raw | blame | history
gc-order/src/main/resources/mapper/order/JhyInfoMapper.xml
@@ -10,5 +10,6 @@
    <select id="selectJhyInfoListInAddressRange" resultType="com.xzx.gc.entity.JhyInfo">
        select * from xzx_jhy_info a
        where 6000 > 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
          and status = 2
    </select>
</mapper>