From f1e088fbd984c8ca1a59e3757328c4d4aa36c9d0 Mon Sep 17 00:00:00 2001
From: lxw <810412026@qq.com>
Date: 星期二, 17 十月 2023 16:45:07 +0800
Subject: [PATCH] 35
---
src/main/java/com/whyc/service/SubTablePageInfoService.java | 81 ++++++++++++++++++++++++++++++++++++++++
1 files changed, 81 insertions(+), 0 deletions(-)
diff --git a/src/main/java/com/whyc/service/SubTablePageInfoService.java b/src/main/java/com/whyc/service/SubTablePageInfoService.java
index d4fa059..1dc035f 100644
--- a/src/main/java/com/whyc/service/SubTablePageInfoService.java
+++ b/src/main/java/com/whyc/service/SubTablePageInfoService.java
@@ -2,6 +2,7 @@
import com.whyc.dto.InterfaceParam;
import com.whyc.dto.StandardFeatureCurve;
+import com.whyc.dto.paramter.AlarmPar;
import com.whyc.dto.paramter.DevAlarmPar;
import com.whyc.dto.result.AlarmRes;
import com.whyc.mapper.CallBack;
@@ -1083,4 +1084,84 @@
}
return num;
}
+
+ //35-SubTablePageInfoUtils.java;176琛�
+ public List<AlarmRes> getList2(AlarmPar param){
+ String sql="select history.BattGroupId,history.num,alm_signal_id,history.monnum,alm_value,alm_level,alm_is_confirmed,alm_confirmed_time,alm_start_time,alm_end_time " +
+ " ,alm_severity,stationname,StationName1,StationName2,StationName3,StationName5,battgroupname " +
+ " from db_alarm."+param.getRecordYear()+" history,db_battinf.tb_battinf " +
+ " where history.battgroupid=db_battinf.tb_battinf.battgroupid " +
+ " and alm_id in("+param.getAlmIdOne()+","+param.getAlmIdTwo()+", "+param.getAlmIdThree()+ ", "+param.getAlmIdFour()+ ", "+param.getAlmIdFive()+ ", "+param.getAlmIdSix()+ ", "+param.getAlmIdSeven()+ ", "+param.getAlmIdEight()+ ") " +
+ " and alm_signal_id%2 in("+param.getAlmSignalIdOne()+","+param.getAlmSignalIdTwo()+") " +
+ " and alm_level in( "+param.getAlmLevelOne()+ ", "+param.getAlmLevelTwo()+ ", "+param.getAlmLevelThree()+ ", "+param.getAlmLevelFour()+ ") " +
+ " and alm_start_time>='"+ActionUtil.sdf.format(param.getAlmStartTime())+"' and alm_start_time <='"+ActionUtil.sdf.format(param.getAlmStartTime1())+"' " +
+ " and db_battinf.tb_battinf.stationname1 like '%"+param.getStationname1()+"%' " +
+ " and db_battinf.tb_battinf.stationname like '%"+param.getStationname()+"%' ";
+ if(param.getBattGroupId()==0){
+ sql+=" and db_battinf.tb_battinf.battgroupid!="+param.getBattGroupId()+" ";
+ }else{
+ sql+=" and db_battinf.tb_battinf.battgroupid="+param.getBattGroupId()+" ";
+ }
+ sql+=" and history.BattGroupId " +
+ " in(select distinct db_battinf.tb_battinf.battgroupid from " +
+ " db_battinf.tb_battinf,db_user.tb_user_battgroup_baojigroup_battgroup,db_user.tb_user_battgroup_baojigroup_usr,db_user.tb_user_inf " +
+ " where db_user.tb_user_battgroup_baojigroup_battgroup.BattGroupId=db_battinf.tb_battinf.BattGroupId " +
+ " and " +
+ " db_user.tb_user_battgroup_baojigroup_usr.baoji_group_id=db_user.tb_user_battgroup_baojigroup_battgroup.baoji_group_id " +
+ " and db_user.tb_user_inf.uid=db_user.tb_user_battgroup_baojigroup_usr.uid and db_user.tb_user_inf.uid="+param.getUId()+" " +
+ " )";
+ sql+=" order by history.BattGroupId asc,history.alm_start_time desc,history.monnum asc limit "+param.getLimitStart()+","+param.getLimitEnd()+" ";
+
+ List<AlarmRes> list = sqlExecuteService.executeQuery_call(sql, new CallBack() {
+ @Override
+ public List getResults(ResultSet rs) throws SQLException {
+ List<AlarmRes> list=new ArrayList<>();
+ int id=0;
+ int i=0;
+ List dataList=new ArrayList();
+ AlarmRes ph=new AlarmRes();
+ while (rs.next()){
+ int battGroupId=rs.getInt("BattGroupId");
+ if(battGroupId!=id){
+ ph.setAdataHs(dataList);
+ dataList=new ArrayList();
+ }
+ BattalarmDataHistory data=new BattalarmDataHistory();
+ data.setNum(rs.getLong("num"));
+ data.setBattGroupId(rs.getInt("BattGroupId"));
+ data.setAlmSignalId(rs.getInt("alm_signal_id"));
+ data.setMonNum(rs.getInt("monnum"));
+ data.setAlmValue(rs.getFloat("alm_value"));
+ data.setAlmLevel(rs.getInt("alm_level"));
+ data.setAlmIsConfirmed(rs.getInt("alm_is_confirmed"));
+ data.setAlmConfirmedTime(rs.getTimestamp("alm_confirmed_time"));
+ data.setAlmStartTime(rs.getTimestamp("alm_start_time"));
+ data.setAlmEndTime(rs.getTimestamp("alm_end_time"));
+ data.setAlmSeverity(rs.getInt("alm_severity"));
+ dataList.add(data);
+ if(battGroupId!=id){
+ if(i!=0){
+ list.add(ph);
+ }
+ id=battGroupId;
+ ph=new AlarmRes();
+ ph.setBattGroupId(battGroupId);
+ ph.setStationName(rs.getString("stationname"));
+ ph.setStationName1(rs.getString("stationname1"));
+ ph.setStationName2(rs.getString("stationname2"));
+ ph.setStationName3(rs.getString("stationname3"));
+ ph.setStationName5(rs.getString("stationname5"));
+ ph.setBattGroupName(rs.getString("battgroupname"));
+ }
+ if(rs.isLast()){
+ ph.setAdataHs(dataList);
+ list.add(ph);
+ }
+ i++;
+ }
+ return list;
+ }
+ });
+ return list;
+ }
}
--
Gitblit v1.9.1