From 42416fc53badafdce60e95f4bc13498364fb1b0e Mon Sep 17 00:00:00 2001
From: xieb <vip_xiaobin810@163.com>
Date: Thu, 20 Jul 2023 11:33:16 +0800
Subject: [PATCH] 测站经纬度范围查询
---
skjcmanager/skjcmanager-service/skjcmanager-sm/src/main/java/cn/gistack/sm/sjztmd/mapper/AttStBaseMapper.xml | 3 ++-
1 files changed, 2 insertions(+), 1 deletions(-)
diff --git a/skjcmanager/skjcmanager-service/skjcmanager-sm/src/main/java/cn/gistack/sm/sjztmd/mapper/AttStBaseMapper.xml b/skjcmanager/skjcmanager-service/skjcmanager-sm/src/main/java/cn/gistack/sm/sjztmd/mapper/AttStBaseMapper.xml
index 683a458..08270fc 100644
--- a/skjcmanager/skjcmanager-service/skjcmanager-sm/src/main/java/cn/gistack/sm/sjztmd/mapper/AttStBaseMapper.xml
+++ b/skjcmanager/skjcmanager-service/skjcmanager-sm/src/main/java/cn/gistack/sm/sjztmd/mapper/AttStBaseMapper.xml
@@ -10,7 +10,8 @@
from "att_st_base" a
left join "att_res_base" b on (a."res_guid" = b."guid")
--WHERE a."station_latitude" IS NOT NULL
- -- AND a."station_longitude" IS NOT NULL AND (a."is_pptn" = 1 or a."is_rsvr" = 1) ) a
+ -- AND a."station_longitude" IS NOT NULL AND (a."is_pptn" = 1 or a."is_rsvr" = 1)
+ ) a
where a.radius between 0 and #{attStBase.radius} or b.sk_radius between 0 and #{attStBase.radius}
</select>
--
Gitblit v1.9.3