From b1cb0d6fe00a736a68f265aa129bc605b11bc986 Mon Sep 17 00:00:00 2001
From: 16639036659 <577530412@qq.com>
Date: 星期四, 25 四月 2024 15:03:42 +0800
Subject: [PATCH] 饼图添加整改与未整改数据的统计结果
---
src/main/resources/mybatis/doublePrevention/TrHiddenDangerCheckPointMapper.xml | 8 +++++---
src/main/java/com/ruoyi/doublePrevention/entity/SPI/TroubleLevel.java | 19 +++++++++++++++++++
2 files changed, 24 insertions(+), 3 deletions(-)
diff --git a/src/main/java/com/ruoyi/doublePrevention/entity/SPI/TroubleLevel.java b/src/main/java/com/ruoyi/doublePrevention/entity/SPI/TroubleLevel.java
index 1b69fe7..00354b5 100644
--- a/src/main/java/com/ruoyi/doublePrevention/entity/SPI/TroubleLevel.java
+++ b/src/main/java/com/ruoyi/doublePrevention/entity/SPI/TroubleLevel.java
@@ -11,6 +11,9 @@
private String C;
+ private Integer rectifyFinish;
+ private Integer rectifyNotFinish;
+
public String getA() {
return A;
}
@@ -34,4 +37,20 @@
public void setC(String c) {
C = c;
}
+
+ public Integer getRectifyFinish() {
+ return rectifyFinish;
+ }
+
+ public void setRectifyFinish(Integer rectifyFinish) {
+ this.rectifyFinish = rectifyFinish;
+ }
+
+ public Integer getRectifyNotFinish() {
+ return rectifyNotFinish;
+ }
+
+ public void setRectifyNotFinish(Integer rectifyNotFinish) {
+ this.rectifyNotFinish = rectifyNotFinish;
+ }
}
diff --git a/src/main/resources/mybatis/doublePrevention/TrHiddenDangerCheckPointMapper.xml b/src/main/resources/mybatis/doublePrevention/TrHiddenDangerCheckPointMapper.xml
index 3e2930e..54716db 100644
--- a/src/main/resources/mybatis/doublePrevention/TrHiddenDangerCheckPointMapper.xml
+++ b/src/main/resources/mybatis/doublePrevention/TrHiddenDangerCheckPointMapper.xml
@@ -119,7 +119,7 @@
sum(case when danger_level = '0' then 1 else 0 end) generalDanger,
sum(case when danger_level = '1' then 1 else 0 end) majorDanger
FROM tr_hidden_danger_check_point
- WHERE register_create_time >= #{spiDataReqBO.startTime} and #{spiDataReqBO.endTime} >= register_create_time and whether_danger = 1
+ WHERE whether_danger =1 and examine_status =1 and register_create_time >= #{spiDataReqBO.startTime} and #{spiDataReqBO.endTime} >= register_create_time and whether_danger = 1
GROUP BY time
ORDER BY time ASC
</select>
@@ -129,9 +129,11 @@
select
sum(case when trouble_type_name = 'A级隐患' then 1 else 0 end) A,
sum(case when trouble_type_name = 'B级隐患' then 1 else 0 end) B,
- sum(case when trouble_type_name = 'C级隐患' then 1 else 0 end) C
+ sum(case when trouble_type_name = 'C级隐患' then 1 else 0 end) C,
+ sum(case when rectify_status = '1' then 1 else 0 end) rectifyFinish,
+ sum(case when rectify_status = '0' then 1 else 0 end) rectifyNotFinish
from tr_hidden_danger_check_point
- WHERE YEAR(register_create_time) = #{spiDataReqBO.year}
+ WHERE whether_danger =1 and examine_status =1 and YEAR(register_create_time) = #{spiDataReqBO.year}
<if test="spiDataReqBO.month != null and spiDataReqBO.month != ''">
AND MONTH(register_create_time) = #{spiDataReqBO.month}
</if>
--
Gitblit v1.9.2