From e9e2230b41133c2e1821fa096fb1acf30c4d5698 Mon Sep 17 00:00:00 2001
From: liuhaonan <31457034@qq.com>
Date: 星期三, 27 七月 2022 17:16:39 +0800
Subject: [PATCH] 优化
---
dao/src/main/resources/mapper/LightReportErrorMapper.xml | 15 +++++++++++++++
dao/src/main/java/com/sandu/ximon/dao/mapper/LightReportErrorMapper.java | 2 ++
2 files changed, 17 insertions(+), 0 deletions(-)
diff --git a/dao/src/main/java/com/sandu/ximon/dao/mapper/LightReportErrorMapper.java b/dao/src/main/java/com/sandu/ximon/dao/mapper/LightReportErrorMapper.java
index 8d547c7..22e72a1 100644
--- a/dao/src/main/java/com/sandu/ximon/dao/mapper/LightReportErrorMapper.java
+++ b/dao/src/main/java/com/sandu/ximon/dao/mapper/LightReportErrorMapper.java
@@ -20,6 +20,8 @@
* @return 鏁呴殰鐮佸垪琛�
*/
List<LightReportErrorBo> listReportError(String keyword, Integer error_code, Long userid);
+
+ List<LightReportErrorBo> listError(Long userid);
}
diff --git a/dao/src/main/resources/mapper/LightReportErrorMapper.xml b/dao/src/main/resources/mapper/LightReportErrorMapper.xml
index 71d342b..4bc7b40 100644
--- a/dao/src/main/resources/mapper/LightReportErrorMapper.xml
+++ b/dao/src/main/resources/mapper/LightReportErrorMapper.xml
@@ -42,4 +42,19 @@
</where>
ORDER BY t1.light_report_error_id DESC
</select>
+ <select id="listError" resultType="com.sandu.ximon.dao.bo.LightReportErrorBo"
+ parameterType="java.lang.Long">
+ SELECT
+ t1.*
+ FROM
+ light_report_error t1
+ LEFT JOIN pole t3 ON t1.device_code = t3.device_code
+ WHERE
+ <if test="userid != null">
+ t3.client_id = #{userId} OR t3.user_id = #{userId}
+ </if>
+ t1.light_report_error_id IN ( SELECT t.max_id FROM ( SELECT Max( light_report_error.light_report_error_id ) AS max_id FROM light_report_error GROUP BY light_report_error.device_code ) AS t )
+ ORDER BY
+ t1.create_time DESC
+ </select>
</mapper>
--
Gitblit v1.9.3