From a664fe7e9c3526bd5b44bc8c1d7bbcc56655cbbc Mon Sep 17 00:00:00 2001
From: 101captain <237651143@qq.com>
Date: 星期三, 25 五月 2022 15:55:59 +0800
Subject: [PATCH] bug修改
---
springcloud_k8s_panzhihuazhihuishequ/service_community/src/main/resources/mapper/ComPropertyMapper.xml | 8 ++++----
1 files changed, 4 insertions(+), 4 deletions(-)
diff --git a/springcloud_k8s_panzhihuazhihuishequ/service_community/src/main/resources/mapper/ComPropertyMapper.xml b/springcloud_k8s_panzhihuazhihuishequ/service_community/src/main/resources/mapper/ComPropertyMapper.xml
index cafb3cd..19fbcae 100644
--- a/springcloud_k8s_panzhihuazhihuishequ/service_community/src/main/resources/mapper/ComPropertyMapper.xml
+++ b/springcloud_k8s_panzhihuazhihuishequ/service_community/src/main/resources/mapper/ComPropertyMapper.xml
@@ -124,9 +124,9 @@
(SELECT COUNT(t1.id) FROM com_property_alarm t1 LEFT JOIN com_property_equipment t2 ON t1.serial_no = t2.serial_no
WHERE t2.community_id = #{communityId} AND t1.`status` = 1 AND t1.`type` = 2) AS completeAbnormalTotal,
(SELECT COUNT(t1.id) FROM com_property_alarm t1 LEFT JOIN com_property_equipment t2 ON t1.serial_no = t2.serial_no
- WHERE t2.community_id = #{communityId} AND t1.`status` = 0 AND t1.`type` = 1) AS pendingServiceTotal,
+ WHERE t2.community_id = #{communityId} AND t1.`status` = 0 AND t1.`type` = 1 and t1.serial_no not like '70%') AS pendingServiceTotal,
(SELECT COUNT(t1.id) FROM com_property_alarm t1 LEFT JOIN com_property_equipment t2 ON t1.serial_no = t2.serial_no
- WHERE t2.community_id = #{communityId} AND t1.`status` = 1 AND t1.`type` = 1) AS completeServiceTotal
+ WHERE t2.community_id = #{communityId} AND t1.`status` = 1 AND t1.`type` = 1 and t1.serial_no not like '70%') AS completeServiceTotal
</select>
<select id="retrieveAbnormalAddPolylineData"
resultType="com.panzhihua.common.model.vos.community.StatisticsCommVO">
@@ -222,7 +222,7 @@
SELECT DISTINCT(t1.serial_no)
FROM com_property_alarm t1
LEFT JOIN com_property_equipment t2 ON t1.serial_no = t2.serial_no
- WHERE t2.community_id = #{communityId} AND t1.`status` = 0
+ WHERE t2.community_id = #{communityId} AND t1.`status` = 0 and t1.serial_no not like '70%'
)
UNION ALL
SELECT
@@ -240,7 +240,7 @@
FROM com_property_alarm t1
LEFT JOIN com_property_equipment t2 ON t1.serial_no = t2.serial_no
WHERE t2.community_id = #{communityId} AND t1.`status` = 0
- )
+ ) and serial_no not like '70%'
</select>
</mapper>
--
Gitblit v1.7.1