From 91bf27944d48c20c113e08a087d799fd0dede51f Mon Sep 17 00:00:00 2001
From: guoshilong <123456>
Date: Fri, 01 Dec 2023 14:17:26 +0800
Subject: [PATCH] 蓄水量日报市县查询修改
---
skjcmanager/skjcmanager-service/skjcmanager-sm/src/main/java/cn/gistack/sm/sjztods/mapper/XsfsQktjMapper.xml | 5 +++--
1 files changed, 3 insertions(+), 2 deletions(-)
diff --git a/skjcmanager/skjcmanager-service/skjcmanager-sm/src/main/java/cn/gistack/sm/sjztods/mapper/XsfsQktjMapper.xml b/skjcmanager/skjcmanager-service/skjcmanager-sm/src/main/java/cn/gistack/sm/sjztods/mapper/XsfsQktjMapper.xml
index 167b3fc..56990b3 100644
--- a/skjcmanager/skjcmanager-service/skjcmanager-sm/src/main/java/cn/gistack/sm/sjztods/mapper/XsfsQktjMapper.xml
+++ b/skjcmanager/skjcmanager-service/skjcmanager-sm/src/main/java/cn/gistack/sm/sjztods/mapper/XsfsQktjMapper.xml
@@ -7,12 +7,13 @@
select
xq.*
from SJZT_ODS."xsfs_qktj" xq
+ left join SJZT_MD."att_ad_base" a ON a."ad_code" = xq."ad_code"
where 1=1
<if test="xsfsQktj.queryTime!=null and xsfsQktj.queryTime!=''">
and date_format(xq."statistic_time",'%Y-%m-%d') = #{xsfsQktj.queryTime}
</if>
- <if test="xsfsQktj.adCode!=null and xsfsQktj.adCode!=''">
- and xq."ad_code" = #{xsfsQktj.adCode}
+ <if test="xsfsQktj.adCode!=null and xsfsQktj.adCode!='' ">
+ AND a."p_ad_code" = #{xsfsQktj.adCode}
</if>
</select>
--
Gitblit v1.9.3