From 0f15f409eef03c3f95948ea4384fbd252919e851 Mon Sep 17 00:00:00 2001
From: xieb <vip_xiaobin810@163.com>
Date: Thu, 26 Sep 2024 17:01:17 +0800
Subject: [PATCH] 普查统计提防柱状图数据接口支持季节查询
---
skjcmanager/skjcmanager-service/skjcmanager-sm/src/main/java/cn/gistack/sm/sjztmd/mapper/TbDykeInvestigationMapper.xml | 3 +++
1 files changed, 3 insertions(+), 0 deletions(-)
diff --git a/skjcmanager/skjcmanager-service/skjcmanager-sm/src/main/java/cn/gistack/sm/sjztmd/mapper/TbDykeInvestigationMapper.xml b/skjcmanager/skjcmanager-service/skjcmanager-sm/src/main/java/cn/gistack/sm/sjztmd/mapper/TbDykeInvestigationMapper.xml
index 1b13575..0fe2914 100644
--- a/skjcmanager/skjcmanager-service/skjcmanager-sm/src/main/java/cn/gistack/sm/sjztmd/mapper/TbDykeInvestigationMapper.xml
+++ b/skjcmanager/skjcmanager-service/skjcmanager-sm/src/main/java/cn/gistack/sm/sjztmd/mapper/TbDykeInvestigationMapper.xml
@@ -266,6 +266,9 @@
<if test="params.tbYear!=null and params.tbYear!=''">
AND tdi."tb_year" = #{params.tbYear}
</if>
+ <if test="params.tbQuarter != null and params.tbQuarter !=''">
+ AND tdi."tb_quarter" = #{params.tbQuarter}
+ </if>
-- and tdi."investigation_variety" = '白蚁'
group by tdi."tb_state_id",tdi."dyke_guid",tdi."unit"
)TEMP1
--
Gitblit v1.9.3