From 5dc77a2fed0bb955f4f17550eaae8d4f2743d1a4 Mon Sep 17 00:00:00 2001
From: xieb <vip_xiaobin810@163.com>
Date: Wed, 24 May 2023 11:33:44 +0800
Subject: [PATCH] 增加是否审核筛选
---
skjcmanager/skjcmanager-service/skjcmanager-sm/src/main/java/cn/gistack/sm/reportFlood/mapper/ReportFloodRecordMapper.xml | 4 ++++
1 files changed, 4 insertions(+), 0 deletions(-)
diff --git a/skjcmanager/skjcmanager-service/skjcmanager-sm/src/main/java/cn/gistack/sm/reportFlood/mapper/ReportFloodRecordMapper.xml b/skjcmanager/skjcmanager-service/skjcmanager-sm/src/main/java/cn/gistack/sm/reportFlood/mapper/ReportFloodRecordMapper.xml
index 40ebe3b..60c44fd 100644
--- a/skjcmanager/skjcmanager-service/skjcmanager-sm/src/main/java/cn/gistack/sm/reportFlood/mapper/ReportFloodRecordMapper.xml
+++ b/skjcmanager/skjcmanager-service/skjcmanager-sm/src/main/java/cn/gistack/sm/reportFlood/mapper/ReportFloodRecordMapper.xml
@@ -41,6 +41,10 @@
<if test="reportFloodRecord.reservoirName != null and reportFloodRecord.reservoirName !=''">
AND atb."name" LIKE CONCAT('%',#{reportFloodRecord.reservoirName},'%')
</if>
+ <if test="reportFloodRecord.isAudit != null and reportFloodRecord.isAudit !=''">
+ AND r.is_audit = #{reportFloodRecord.isAudit}
+ </if>
+ ORDER BY CREATE_TIME DESC
</select>
<select id="customizeGetDetail" resultMap="vo">
--
Gitblit v1.9.3