From 98f8160bd6531ef118d1bfcfb90368a3120ff70d Mon Sep 17 00:00:00 2001
From: baizonghao <1719256278@qq.com>
Date: 星期六, 01 四月 2023 13:22:45 +0800
Subject: [PATCH] AI算法效能，AI事件统计
---
ycl-platform/src/main/resources/mapper/allot/EfficiencyMapper.xml | 22 ++++++++++------------
1 files changed, 10 insertions(+), 12 deletions(-)
diff --git a/ycl-platform/src/main/resources/mapper/allot/EfficiencyMapper.xml b/ycl-platform/src/main/resources/mapper/allot/EfficiencyMapper.xml
index 05092bf..f84b45c 100644
--- a/ycl-platform/src/main/resources/mapper/allot/EfficiencyMapper.xml
+++ b/ycl-platform/src/main/resources/mapper/allot/EfficiencyMapper.xml
@@ -12,40 +12,38 @@
<select id="list" resultType="com.ycl.dto.allot.EfficiencyDto">
SELECT
- t4.NAME NAME,
- COUNT(1) NUMBER,
- sum(case WHEN ubc.state = 3 then 1 ELSE 0 END) errorNumber
+ t3.NAME NAME,
+ COUNT( 1 ) NUMBER,
+ sum( CASE WHEN ubc.state = 3 THEN 1 ELSE 0 END ) errorNumber
FROM
`ums_base_case` AS ubc
JOIN ums_violations AS uv ON ubc.id = uv.id
- LEFT JOIN ums_data_dictionary AS t3 ON uv.category_id = t3.id
- LEFT JOIN ums_data_dictionary AS t4 ON uv.type_id = t4.id
+ LEFT JOIN ums_data_dictionary AS t3 ON uv.grade_id = t3.id
LEFT JOIN ums_sccg_region t5 ON ubc.street_id = t5.id
WHERE
ubc.category = 1
- AND t4.`name` IS NOT NULL
+ AND t3.`name` IS NOT NULL
GROUP BY
- t4.id
+ t3.id
</select>
<select id="aiMonthList" resultMap="AIIotStatisticsVO">
SELECT
- t4.NAME type,
+ t3.NAME type,
DATE_FORMAT(alarm_time,'%Y-%m') month,
COUNT(1) count
FROM
`ums_base_case` AS ubc
JOIN ums_violations AS uv ON ubc.id = uv.id
- LEFT JOIN ums_data_dictionary AS t3 ON uv.category_id = t3.id
- LEFT JOIN ums_data_dictionary AS t4 ON uv.type_id = t4.id
+ LEFT JOIN ums_data_dictionary AS t3 ON uv.grade_id = t3.id
LEFT JOIN ums_sccg_region t5 ON ubc.street_id = t5.id
WHERE
ubc.category = 1
- AND t4.`name` IS NOT NULL
+ AND t3.`name` IS NOT NULL
<if test="beginTime!=null">
and ubc.alarm_time BETWEEN #{beginTime} and #{endTime}
</if>
GROUP BY
- t4.id,DATE_FORMAT(alarm_time,'%Y-%m')
+ t3.id,DATE_FORMAT(alarm_time,'%Y-%m')
ORDER BY DATE_FORMAT(alarm_time,'%Y-%m') desc ,COUNT(1) desc
</select>
<select id="getSmokeCustomer" resultType="java.lang.Long">
--
Gitblit v1.8.0