From 7fe1ea37e4044eb61374a51c5a2fe1ecf9e834be Mon Sep 17 00:00:00 2001
From: whycxzp <glperry@163.com>
Date: 星期一, 09 六月 2025 19:07:39 +0800
Subject: [PATCH] 杂项更新
---
src/main/java/com/whyc/service/BattRealTimeDataHistoryService.java | 43 ++++++++++++++++++++++++++++++++++++++++++-
1 files changed, 42 insertions(+), 1 deletions(-)
diff --git a/src/main/java/com/whyc/service/BattRealTimeDataHistoryService.java b/src/main/java/com/whyc/service/BattRealTimeDataHistoryService.java
index da30755..5df9704 100644
--- a/src/main/java/com/whyc/service/BattRealTimeDataHistoryService.java
+++ b/src/main/java/com/whyc/service/BattRealTimeDataHistoryService.java
@@ -190,7 +190,7 @@
public Date getChargeStartTime(int battGroupId, Date recordTime) {
String battGroupIdTable = getBattGroupIdTable(battGroupId, recordTime);
- String sql = "select record_time from db_power_history.tb_batt_realdata_" + battGroupIdTable + " where record_time > '" + recordTime + "' and batt_test_type = 2 order limit 1";
+ String sql = "select record_time from db_power_history.tb_batt_realdata_" + battGroupIdTable + " where record_time > '" + recordTime + "' and batt_test_type = 2 limit 1";
List<Date> timeList = sqlExecuteService.executeQuery_call(sql, new CallBack() {
@Override
@@ -269,4 +269,45 @@
});
return list;
}
+
+ /**
+ * select * from tb_batt_realdata_100001_2025_04 where record_time in
+ * (SELECT MIN(record_time) AS min_time FROM tb_batt_realdata_100001_2025_04
+ * GROUP BY DATE(record_time))
+ *
+ * @param tableName
+ * @param timeAgo
+ * @return
+ */
+ public List<BattRealTimeDataHistory> getFirstRecordListOfDay(String tableName, Date timeAgo) {
+ String sqlExtra;
+ if(timeAgo!=null){
+ sqlExtra = " where record_time > '" + timeAgo + "'";
+ }else{
+ sqlExtra = "";
+ }
+ String sql = "select * from db_power_history." + tableName + " where record_time in (SELECT MIN(record_time) FROM db_power_history." + tableName + sqlExtra +" GROUP BY DATE(record_time))";
+ List<BattRealTimeDataHistory> list = sqlExecuteService.executeQuery_call(sql, new CallBack() {
+
+ @Override
+ public List getResults(ResultSet rs) throws SQLException {
+ List<BattRealTimeDataHistory> list = new LinkedList<>();
+ //濡傛灉瀛樺湪璁板綍
+ while (rs.next()) {
+ BattRealTimeDataHistory his = new BattRealTimeDataHistory();
+ his.setTestStartTime(rs.getTimestamp("test_start_time"));
+ his.setRecordTime(rs.getTimestamp("record_time"));
+ his.setMonNum(rs.getInt("mon_num"));
+ his.setMonVol(rs.getFloat("mon_vol"));
+ his.setMonRes(rs.getFloat("mon_res"));
+ his.setMonTmp(rs.getFloat("mon_tmp"));
+
+ list.add(his);
+ }
+ return list;
+
+ }
+ });
+ return list;
+ }
}
--
Gitblit v1.9.1