From 65561ff84ad5520a8f7614dd9adf48ac42ff5347 Mon Sep 17 00:00:00 2001
From: zmc <zmc_li@foxmail.com>
Date: 星期三, 30 八月 2023 16:11:51 +0800
Subject: [PATCH] 扬尘Java代码
---
src/main/java/com/job/zsc/mapper/Vue3FumeMapper.java | 24 ++++++++++++++++++------
1 files changed, 18 insertions(+), 6 deletions(-)
diff --git a/src/main/java/com/job/zsc/mapper/Vue3FumeMapper.java b/src/main/java/com/job/zsc/mapper/Vue3FumeMapper.java
index 20cbfdc..fae3549 100644
--- a/src/main/java/com/job/zsc/mapper/Vue3FumeMapper.java
+++ b/src/main/java/com/job/zsc/mapper/Vue3FumeMapper.java
@@ -16,8 +16,7 @@
//涓ゅ紶琛ㄨ仈鍚堟煡璇�
@Select("select a.MV_ID,a.MV_Stat_Code,b.DI_Name,a.MV_Create_Time,a.MV_Data_Time,a.MV_Fume_Concentration2\n" +
- "from fd_t_minutevalue as a ,ea_t_device_info as b\n" +
- "where a.MV_Stat_Code = b.DI_Code ")
+ "from fd_t_minutevalue as a join ea_t_device_info as b on a.MV_Stat_Code = b.DI_Code ")
List<FumeHistoryData> findall();
List<FumeHistoryData> conditionQuery(String devId, String beginTime, String endTime);
@@ -31,8 +30,7 @@
List<DeviceInfo> allDeviceInfo();
@Select("select a1.dev_id,b.DI_Name,a1.exception,a1.exception_type,a1.region,a1.begin_time,a1.end_time\n" +
- "from abnormal_data as a1,ea_t_device_info as b\n" +
- "where a1.dev_id = b.DI_Code")
+ "from abnormal_data as a1 join ea_t_device_info as b on a1.dev_id = b.DI_Code\n")
List<FumeAbnormalData> allAbnormalData();
List<FumeAbnormalData> conditonQueryAbnormalData(String devId, String beginTime, String endTime);
@@ -41,8 +39,8 @@
//杩斿洖璇ュ紓甯哥被鍨嬪搴旂殑搴楅摵鍚嶅拰璁惧缂栧彿
@Select("select DISTINCT b1.DI_Name,a1.dev_id\n" +
- "from abnormal_data as a1,ea_t_device_info as b1\n" +
- "where a1.dev_id = b1.DI_Code and a1.exception_type = #{exceptionType} ")
+ "from abnormal_data as a1 join ea_t_device_info as b1 on a1.dev_id = b1.DI_Code\n" +
+ "where a1.exception_type = #{exceptionType}")
List<FumeAbnormalData> findShopName(String exceptionType);
List<FumeHistoryData> exportByShopName(@Param("a") String[] shops, String exportBeginTime, String exportEndTime);
@@ -66,6 +64,20 @@
List<FumeAbnormalData> earlyAndLastTime();
+ @Select("select max(MV_Data_Time) as MV_Data_Time from fd_t_minutevalue")
+ List<FumeHistoryData> lastestTimeFromHistoryData();
+
+ @Select("select * from shop_names order by MV_ID")
+ List<FumeHistoryData> shopnamePythonUse();
+
+
+
+
+
+ @Select("select count(*) from abnormal_data where exception_type = #{exceptionType} and (begin_time between #{beginTime} and #{endTime} or end_time between #{beginTime} and #{endTime})")
+ Integer exceptionNum(String exceptionType, String beginTime, String endTime);
+
+
// 杩斿洖璁惧淇℃伅琛ㄧ殑鏉℃暟
// @Select("SELECT count(*) from ea_t_device_info")
// String shopNum();
--
Gitblit v1.9.3