xzx.git - Gitblit

main / xzx

summary
reflog
commits
tree
docs
forks
compare

parent: 2ff78850 | patch | commit | show whitespace

Helius

2021-12-08 ef4ad171c46f615a5b719bac70c468b561bc08ac

Merge branch 'score-shop' into xc-prd

1 files modified

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>

			@@ -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>