From f3f4e9f08ed504970b6bf72c720e4df1e71ef094 Mon Sep 17 00:00:00 2001
From: aix <vip_xiaobin810@163.com>
Date: Thu, 27 Jun 2024 17:03:41 +0800
Subject: [PATCH] 危害座数统计不对
---
skjcmanager/skjcmanager-service/skjcmanager-sm/src/main/java/cn/gistack/sm/sjztmd/mapper/TbResGeneralInvestigationMapper.xml | 2 +-
1 files changed, 1 insertions(+), 1 deletions(-)
diff --git a/skjcmanager/skjcmanager-service/skjcmanager-sm/src/main/java/cn/gistack/sm/sjztmd/mapper/TbResGeneralInvestigationMapper.xml b/skjcmanager/skjcmanager-service/skjcmanager-sm/src/main/java/cn/gistack/sm/sjztmd/mapper/TbResGeneralInvestigationMapper.xml
index 0774f89..50c39de 100644
--- a/skjcmanager/skjcmanager-service/skjcmanager-sm/src/main/java/cn/gistack/sm/sjztmd/mapper/TbResGeneralInvestigationMapper.xml
+++ b/skjcmanager/skjcmanager-service/skjcmanager-sm/src/main/java/cn/gistack/sm/sjztmd/mapper/TbResGeneralInvestigationMapper.xml
@@ -145,7 +145,7 @@
LEFT JOIN YWXT."att_ad_base" province ON province."ad_code" = city."p_ad_code"
where (town."ad_code" = aab."guid" or county."ad_code" = aab."guid" or city."ad_code" = aab."guid" or province."ad_code" = aab."guid")
<!--只有已审核数据才显示-->
- and (trgis."check_state" = 3)
+ and (trgis."check_state" = 3 and totalDangerNum > 0)
)
) dangerNum
FROM YWXT."att_ad_base" aab
--
Gitblit v1.9.3