From 364dbd0499df3df3cd5caaa7ce819e5f4649973e Mon Sep 17 00:00:00 2001
From: zhongrj <646384940@qq.com>
Date: Fri, 27 Oct 2023 22:37:24 +0800
Subject: [PATCH] 库容统计查询修改
---
skjcmanager/skjcmanager-service/skjcmanager-sm/src/main/java/cn/gistack/sm/sjztods/mapper/SkxsQkTjMapper.xml | 6 +++---
1 files changed, 3 insertions(+), 3 deletions(-)
diff --git a/skjcmanager/skjcmanager-service/skjcmanager-sm/src/main/java/cn/gistack/sm/sjztods/mapper/SkxsQkTjMapper.xml b/skjcmanager/skjcmanager-service/skjcmanager-sm/src/main/java/cn/gistack/sm/sjztods/mapper/SkxsQkTjMapper.xml
index 884540b..c770175 100644
--- a/skjcmanager/skjcmanager-service/skjcmanager-sm/src/main/java/cn/gistack/sm/sjztods/mapper/SkxsQkTjMapper.xml
+++ b/skjcmanager/skjcmanager-service/skjcmanager-sm/src/main/java/cn/gistack/sm/sjztods/mapper/SkxsQkTjMapper.xml
@@ -32,7 +32,7 @@
<if test="skxsQkTj.resName!=null and skxsQkTj.resName!=''">
and sqt."res_name" like concat('%',#{skxsQkTj.resName},'%')
</if>
- ) x
+ ) x where 1=1
<if test="skxsQkTj.adCode!=null and skxsQkTj.adCode!='' and skxsQkTj.adCode!='420000000000'">
and (townCode = #{skxsQkTj.adCode} or countyCode = #{skxsQkTj.adCode} or cityCode = #{skxsQkTj.adCode})
</if>
@@ -81,7 +81,7 @@
<if test="skxsQkTj.resName!=null and skxsQkTj.resName!=''">
and sqt."res_name" like concat('%',#{skxsQkTj.resName},'%')
</if>
- ) a
+ ) a where 1=1
<if test="skxsQkTj.adCode!=null and skxsQkTj.adCode!='' and skxsQkTj.adCode!='420000000000'">
and (townCode = #{skxsQkTj.adCode} or countyCode = #{skxsQkTj.adCode} or cityCode = #{skxsQkTj.adCode})
</if>
@@ -130,7 +130,7 @@
<if test="skxsQkTj.resName!=null and skxsQkTj.resName!=''">
and sqt."res_name" like concat('%',#{skxsQkTj.resName},'%')
</if>
- ) x
+ ) x where 1=1
<if test="skxsQkTj.adCode!=null and skxsQkTj.adCode!='' and skxsQkTj.adCode!='420000000000'">
and (townCode = #{skxsQkTj.adCode} or countyCode = #{skxsQkTj.adCode} or cityCode = #{skxsQkTj.adCode})
</if>
--
Gitblit v1.9.3