From 7793b8a7a613468532659e698d28b55d8a455892 Mon Sep 17 00:00:00 2001 From: whyclxw <810412026@qq.com> Date: 星期六, 07 六月 2025 15:20:39 +0800 Subject: [PATCH] 系统概览获取半小时核容设备信息添加负载电流load_curr --- src/main/java/com/whyc/service/SubTablePageInfoService.java | 3 ++- 1 files changed, 2 insertions(+), 1 deletions(-) diff --git a/src/main/java/com/whyc/service/SubTablePageInfoService.java b/src/main/java/com/whyc/service/SubTablePageInfoService.java index 1eff6d6..bccff51 100644 --- a/src/main/java/com/whyc/service/SubTablePageInfoService.java +++ b/src/main/java/com/whyc/service/SubTablePageInfoService.java @@ -561,7 +561,7 @@ } //绯荤粺姒傝鑾峰彇鍗婂皬鏃舵牳瀹硅澶囦俊鎭�(缁勭淇℃伅鍙栦竴涓崟浣撲俊鎭嵆鍙�) public List<BattHisRealDto> getHalfHourBattDevData(String tableName,Integer granularity) { - String sql="select distinct mon_num,record_time,group_vol,online_vol,group_curr,group_tmp " + + String sql="select distinct mon_num,record_time,group_vol,online_vol,group_curr,group_tmp,load_curr " + "from (select a.*, (@i:= @i+1) as number " + " from (select * from "+tableName+" "+ " where record_time>date_sub(now(),interval 0.5 hour) and mon_num=1) a, " + @@ -579,6 +579,7 @@ data.setOnlineVol(rs.getFloat("online_vol")); data.setGroupCurr(rs.getFloat("group_curr")); data.setGroupTmp(rs.getFloat("group_tmp")); + data.setLoadCurr(rs.getFloat("load_curr")); list.add(data); } return list; -- Gitblit v1.9.1