package com.whyc.service;
|
|
import cn.hutool.json.JSONUtil;
|
import com.whyc.dto.InterfaceParam;
|
import com.whyc.dto.ReportBattDTO;
|
import com.whyc.dto.Response;
|
import com.whyc.dto.StandardFeatureCurve;
|
import com.whyc.dto.paramter.AlarmPar;
|
import com.whyc.dto.paramter.DevAlarmPar;
|
import com.whyc.mapper.CallBack;
|
import com.whyc.mapper.CommonMapper;
|
import com.whyc.mapper.PwrdevDataHistoryMapper;
|
import com.whyc.mapper.StandardFeatureCurveMapper;
|
import com.whyc.pojo.*;
|
import com.whyc.util.ActionUtil;
|
import com.whyc.util.ThreadLocalUtil;
|
import net.sf.json.JSONArray;
|
import org.apache.poi.openxml4j.exceptions.InvalidFormatException;
|
import org.apache.poi.ss.usermodel.*;
|
import org.springframework.beans.factory.annotation.Autowired;
|
import org.springframework.stereotype.Service;
|
import org.springframework.transaction.annotation.Transactional;
|
|
import javax.annotation.Resource;
|
import javax.swing.*;
|
import java.io.*;
|
import java.text.ParseException;
|
import java.text.SimpleDateFormat;
|
import java.util.*;
|
import java.util.stream.Collectors;
|
|
@Service
|
public class StandardFeatureCurveService {
|
|
@Resource
|
private StandardFeatureCurveMapper mapper;
|
|
@Resource
|
private CommonMapper commonMapper;
|
|
@Autowired
|
private MybatisSqlExecuteService sqlExecuteService;
|
|
@Autowired
|
private SubTablePageInfoService subService;
|
|
@Resource
|
private PwrdevDataHistoryMapper pdhmapper;
|
|
|
@Transactional
|
public void excelImport(InputStream inputStream) throws IOException, InvalidFormatException {
|
List<StandardFeatureCurve> curveList = new LinkedList<>();
|
//获取book
|
Workbook book = WorkbookFactory.create(inputStream);
|
int numberOfSheets = book.getNumberOfSheets();
|
for (int i = 0; i < numberOfSheets; i++) {
|
Sheet sheet = book.getSheetAt(i);
|
String sheetName = sheet.getSheetName();
|
int lastRowNum = sheet.getLastRowNum();
|
Row row1 = sheet.getRow(0);
|
//根据row1的列数来生成对象
|
short lastCellNum = row1.getLastCellNum();
|
for (int j = 1; j < lastRowNum; j++) {
|
//获取当前行
|
Row row = sheet.getRow(j);
|
Cell cellTime = row.getCell(0);
|
Date dateCellValue = cellTime.getDateCellValue();
|
String time = new SimpleDateFormat("HH:mm:ss").format(dateCellValue);
|
for (int k = 1; k < lastCellNum; k++) {
|
Cell cell = row.getCell(k);
|
if(cell == null){
|
break;
|
}
|
double value = cell.getNumericCellValue();
|
if(value == 0.0d){
|
break;
|
}
|
|
String titleNameUnion = sheetName+"_"+row1.getCell(k).getStringCellValue();
|
|
StandardFeatureCurve curve = new StandardFeatureCurve();
|
curve.setTitleNameUnion(titleNameUnion);
|
curve.setTime(time);
|
curve.setValue(value);
|
|
curveList.add(curve);
|
}
|
}
|
}
|
//存入数据库
|
Map<String, List<StandardFeatureCurve>> curveListMap = curveList.stream().collect(Collectors.groupingBy(StandardFeatureCurve::getTitleNameUnion));
|
curveListMap.forEach((titleNameUnion,curveList2)->{
|
//查询表是否存在,不存在需要先创建表
|
String tableName = commonMapper.existTable("web_site", "tb_standard_feature_curve_"+titleNameUnion);
|
if(tableName==null){
|
//mapper.createTable(titleNameUnion);
|
subService.createTable(titleNameUnion);
|
}else{ //存在表,先清空数据
|
commonMapper.truncate("web_site", "tb_standard_feature_curve_"+titleNameUnion);
|
}
|
//mapper.insertBatch(titleNameUnion,curveList2);
|
subService.insertBatch(titleNameUnion,curveList2);
|
});
|
|
}
|
|
public List<StandardFeatureCurve> getList(String va, String c) {
|
if(commonMapper.existTable("web_site","tb_standard_feature_curve_"+va+"_"+c) == null){
|
return null;
|
}
|
// return mapper.getList(va,c);
|
return subService.getList(va,c);
|
}
|
//测试mybatisDb
|
/*public List testTableDb(String va, String c) {
|
String sql="select * from `web_site`.`tb_standard_feature_curve_"+va+"_"+c+"`";
|
List<StandardFeatureCurve> list = sqlExecuteService.executeQuery(sql);
|
return list;
|
}*/
|
public Response testTableDb() {
|
Date date1 = ThreadLocalUtil.parse("2023-04-11 16:08:20",1 );
|
Date date2 = ThreadLocalUtil.parse("2023-04-11 16:09:20",1);
|
Date date3 = ThreadLocalUtil.parse("2022-06-25 03:47:37",1);
|
Date date4 =ThreadLocalUtil.parse("2022-06-27 03:47:37",1);
|
/*2，3 "2020-03-22 15:11:23" "2020-03-23 15:11:23"
|
PwrdevAlarmHistory data=new PwrdevAlarmHistory();
|
data.setRecordYear("tb_pwrdev_alarm_history_2020");
|
data.setAlmStartTime(date1);
|
data.setAlmStartTime1(date2);
|
data.setAlmSource(0);
|
List typeList=new ArrayList();
|
typeList.add(110119);
|
List levelList=new ArrayList();
|
levelList.add(1);
|
levelList.add(2);
|
levelList.add(3);
|
levelList.add(4);
|
data.setAlmTypes(typeList);
|
data.setUsrId(1002);
|
data.setLimitStart(0);
|
data.setLimitEnd(10);
|
//List list=subService.getList2(data);
|
List list=subService.getListForTX(data);*/
|
/*4 "2022-05-10 09:20:09" "2022-05-21 16:21:53"
|
UserLog userLog=new UserLog();
|
userLog.setRecordYear("tb_user_log_2022");
|
userLog.setOperationTime(date1);
|
userLog.setOperationTime2(date2);
|
userLog.setEventType(1);
|
userLog.setOperationType(31);
|
int count=subService.getCount(userLog);
|
List list=new ArrayList();
|
list.add(count);*/
|
/*5
|
String tableName="tb_pwrdev_historydata_110000099_2021_06";
|
List list=subService.getData(tableName);*/
|
/*6 2023-04-11 16:08:20 2023-04-11 20:08:20
|
List list=subService.getListByParam(110000001l,"2023_04",date1,date2);*/
|
/*8
|
List list=subService.getList("122v150ah","0.15c");*/
|
/*9 "2022-09-27 08:26:37" "2022-09-27 09:04:40"
|
InterfaceParam param=new InterfaceParam();
|
List battGroupList=new ArrayList();
|
battGroupList.add(1000034);
|
battGroupList.add(1000030);
|
param.setBattgroupIds(battGroupList);
|
param.setRecordYear("tb_battalarm_data_history_2022_09");
|
param.setStartTime(date1);
|
param.setEndTime(date2);
|
param.setLimitStart(1);
|
param.setLimitEnd(10);
|
List list=subService.getListForInterface(param);*/
|
/*10 2020-03-22 15:11:23 2020-03-23 15:11:23
|
PwrdevAlarmHistory data=new PwrdevAlarmHistory();
|
data.setRecordYear("tb_pwrdev_alarm_history_2020");
|
data.setAlmStartTime(date1);
|
data.setAlmStartTime1(date2);
|
data.setAlmSource(0);
|
List typeList=new ArrayList();
|
typeList.add(110119);
|
List levelList=new ArrayList();
|
levelList.add(1);
|
levelList.add(2);
|
levelList.add(3);
|
levelList.add(4);
|
data.setAlmTypes(typeList);
|
data.setUsrId(1002);
|
data.setLimitStart(0);
|
data.setLimitEnd(10);
|
int count=subService.getCount(data);
|
List list=new ArrayList();
|
list.add(count);*/
|
/*13
|
DevAlarmPar param=new DevAlarmPar();
|
param.setRecordYear("tb_devalarm_data_history_2023_03");
|
param.setAlmStartTime(date1);
|
param.setAlmStartTime1(date2);
|
param.setStationName("");
|
param.setStationName1("");
|
param.setUId(1002);
|
int count=subService.getCount(param);
|
List list=new ArrayList();
|
list.add(count);*/
|
/*15
|
List list=subService.getList(1002,"tb_pwrdev_alarm_param_115000001");*/
|
/*16
|
DevAlarmPar param=new DevAlarmPar();
|
param.setRecordYear("tb_devalarm_data_history_2023_03");
|
param.setAlmStartTime(date1);
|
param.setAlmStartTime1(date2);
|
param.setStationName("");
|
param.setStationName1("");
|
param.setLimitStart(0);
|
param.setLimitEnd(10);
|
param.setUId(1002);
|
List list=subService.getList2(param);*/
|
/*21 "2022-05-10 09:20:09" 2022-05-21 16:21:53
|
UserLog userLog=new UserLog();
|
userLog.setRecordYear("tb_user_log_2022");
|
userLog.setOperationTime(date1);
|
userLog.setOperationTime2(date2);
|
userLog.setEventType(1);
|
userLog.setOperationType(31);
|
userLog.setLimitStart(0);
|
userLog.setLimitEnd(10);
|
List list= subService.getList2(userLog);*/
|
/*23
|
InterfaceParam param=new InterfaceParam();
|
param.setRecordYear("tb_devalarm_data_history_2023_03");
|
param.setStartTime(date1);
|
param.setEndTime(date2);
|
List devList=new ArrayList();
|
devList.add(618500017);
|
devList.add(481500011);
|
param.setDeviceIds(devList);
|
param.setLimitStart(0);
|
param.setLimitEnd(10);
|
List list=subService.getListForInterface_dev(param);*/
|
/*26
|
List List=new ArrayList();
|
for (int i=0;i<4;i++){
|
BattalarmDataHistory bh=new BattalarmDataHistory();
|
bh.setBattGroupId(1000021+i);
|
bh.setMonNum(1+i);
|
bh.setRecordId(-6069479889549612607l);
|
bh.setAlmId(119005+i);
|
bh.setAlmSignalId(1+i);
|
bh.setAlmLevel(1+i);
|
bh.setAlmStartTime(date1);
|
bh.setAlmEndTime(date2);
|
bh.setAlmValue(2.53f+i);
|
bh.setAlmIsConfirmed(0+i);
|
bh.setAlmConfirmedTime(date1);
|
bh.setAlmClearedType(1+i);
|
bh.setUsrId(1002+i);
|
bh.setAlmSeverity(1+i);
|
List.add(bh);
|
}
|
subService.insertBatch4BattAlarmDataHistoryByYear("2022_09",List);*/
|
/*28
|
subService.create_standard_curve("tb_battmon_testcap_2_1000_15");*/
|
/*29
|
PwrdevAlarmHistory data=new PwrdevAlarmHistory();
|
data.setRecordYear("tb_pwrdev_alarm_history_2020");
|
data.setAlmStartTime(date1);
|
data.setAlmStartTime1(date2);
|
data.setAlmSource(0);
|
List typeList=new ArrayList();
|
typeList.add(110119);
|
List levelList=new ArrayList();
|
levelList.add(1);
|
levelList.add(2);
|
levelList.add(3);
|
levelList.add(4);
|
data.setAlmTypes(typeList);
|
data.setUsrId(1002);
|
data.setLimitStart(0);
|
data.setLimitEnd(10);
|
int count=subService.getCountForTX(data);
|
List list=new ArrayList();
|
list.add(count);*/
|
/*32
|
List list=subService.searchAll("tb_pwrdev_alarm_param_110000001");*/
|
/*34
|
InterfaceParam param=new InterfaceParam();
|
param.setRecordYear("tb_devalarm_data_history_2023_03");
|
param.setStartTime(date1);
|
param.setEndTime(date2);
|
List devList=new ArrayList();
|
devList.add(618500017);
|
devList.add(481500011);
|
param.setDeviceIds(devList);
|
param.setLimitStart(0);
|
param.setLimitEnd(10);
|
int count=subService.getCountForInterface(param);
|
List list=new ArrayList();
|
list.add(count);*/
|
/*35
|
AlarmPar param=new AlarmPar();
|
param.setRecordYear("tb_battalarm_data_history_2023_03");
|
param.setAlmIdOne(119001);
|
param.setAlmIdTwo(119002);
|
param.setAlmIdThree(119003);
|
param.setAlmIdFour(119004);
|
param.setAlmIdFive(119005);
|
param.setAlmIdSix(119006);
|
param.setAlmIdSeven(1190011);
|
param.setAlmIdEight(1190012);
|
param.setAlmSignalIdOne(0);
|
param.setAlmSignalIdTwo(1);
|
param.setAlmLevelOne(1);
|
param.setAlmLevelTwo(2);
|
param.setAlmLevelThree(3);
|
param.setAlmLevelFour(4);
|
param.setStationname("");
|
param.setStationname1("");
|
param.setAlmStartTime(date1);
|
param.setAlmStartTime1(date2);
|
param.setBattGroupId(0);
|
param.setUId(1002);
|
param.setLimitStart(0);
|
param.setLimitEnd(100);
|
List list= subService.getList2(param);*/
|
/*40
|
BattmonStandardcurve curve=new BattmonStandardcurve();
|
curve.setMonVolStd("2");
|
curve.setMonCapStd("150");
|
curve.setNote("15");
|
curve.setBattproducer("理士");
|
curve.setBattmodel("TEST");
|
List list= subService.getTestCapList(curve);*/
|
/*42
|
List list=new ArrayList();
|
for (int i=0;i<4;i++){
|
PwrdevAlarmHistory bh=new PwrdevAlarmHistory();
|
bh.setPowerDeviceId(110000001l+i);
|
bh.setRecordId(-6069479889549612607l);
|
bh.setAlmType(110121);
|
bh.setAlmLevel(1+i);
|
bh.setAlmSource(0);
|
bh.setAlmIndex(1);
|
bh.setAlmStartTime(date1);
|
bh.setAlmEndTime(date2);
|
bh.setAlmValue(2.53f+i);
|
bh.setAlmIsConfirmed(0+i);
|
bh.setAlmConfirmedTime(date1);
|
bh.setAlmClearedType(1+i);
|
bh.setUsrId(1002+i);
|
bh.setAlmSeverity(1);
|
bh.setAlmTrigger(1);
|
list.add(bh);
|
}
|
subService.insertBatch4PowerAlarmHistoryByYear("2022",list);*/
|
/*43
|
List list= subService.getGtStartTime("tb_pwrdev_historydata_115000003_2022_06",date3);*/
|
/*44 2023-06-09 15:46:10 2023-06-15 00:00:34
|
InterfaceParam param=new InterfaceParam();
|
param.setRecordYear("tb_battalarm_data_history_2023_06");
|
param.setStartTime(date1);
|
param.setEndTime(date2);
|
List battList=new ArrayList();
|
battList.add(1000048);
|
battList.add(1000162);
|
battList.add(1000161);
|
param.setBattgroupIds(battList);
|
param.setLimitStart(0);
|
param.setLimitEnd(10);
|
int count=subService.getCountForInterface_batt(param);
|
List list=new ArrayList();
|
list.add(count);*/
|
/*48 2023-09-19 10:00:09 2023-09-26 06:52:56
|
BattRealdata realdata = new BattRealdata();
|
realdata.setTableName("1000018_2023_09");
|
realdata.setRecrodTime(date1);
|
realdata.setRecrodTime1(date2);
|
realdata.setMonNum(1);
|
List list=subService.serchByCondition(realdata);*/
|
/*52*/
|
/*52
|
List list=new ArrayList();
|
for (int i=0;i<4;i++){
|
UserLog userLog=new UserLog();
|
userLog.setUId(1002);
|
userLog.setOperationType(31+i);
|
userLog.setTerminalIp("192.168.10.79");
|
userLog.setOperationMsg("测试");
|
userLog.setOperationDetail("insertBatch4UserLogByYear");
|
userLog.setReadFlag(1+i);
|
userLog.setOperationTime(date1);
|
list.add(userLog);
|
}
|
subService.insertBatch4UserLogByYear("2021",list);*/
|
/*56
|
BattmonTestcap btcp=new BattmonTestcap();
|
btcp.setTableName("tb_battmon_testcap_2_1000_15");
|
btcp.setMonvolstd(2);
|
btcp.setMoncapstd(1000);
|
btcp.setBattmodel("TEST");
|
btcp.setBattproducer("理士");
|
btcp.setNote("15");
|
btcp.setBattgroupId(1000121);
|
btcp.setMonNum("1");
|
btcp.setTestRecordCount(1);
|
int flag=subService.add(btcp);
|
List list=new ArrayList();
|
list.add(flag);*/
|
/*58
|
subService.createTable4PowerAlarmHistoryByYear("2019");*/
|
/*63
|
List list=subService.getList_adj(1002,"tb_pwrdev_alarm_param_115000001");*/
|
/*66 2023-03-27 10:10:01 2023-03-31 14:36:55
|
AlarmPar param=new AlarmPar();
|
param.setRecordYear("tb_battalarm_data_history_2023_03");
|
param.setAlmIdOne(119001);
|
param.setAlmIdTwo(119002);
|
param.setAlmIdThree(119003);
|
param.setAlmIdFour(119004);
|
param.setAlmIdFive(119005);
|
param.setAlmIdSix(119006);
|
param.setAlmIdSeven(1190011);
|
param.setAlmIdEight(1190012);
|
param.setAlmSignalIdOne(0);
|
param.setAlmSignalIdTwo(1);
|
param.setAlmLevelOne(1);
|
param.setAlmLevelTwo(2);
|
param.setAlmLevelThree(3);
|
param.setAlmLevelFour(4);
|
param.setStationname("");
|
param.setStationname1("");
|
param.setAlmStartTime(date1);
|
param.setAlmStartTime1(date2);
|
param.setBattGroupId(0);
|
param.setUId(1002);
|
param.setLimitStart(0);
|
param.setLimitEnd(100);
|
int count= subService.getCount(param);
|
List list=new ArrayList();
|
list.add(count);*/
|
/*69
|
List list=subService.getLevelSubList_batt(1002,"tb_battalarm_data_history_2023_08");*/
|
/*91
|
subService.createTable4UserLogByYear("2021");*/
|
/*0
|
List<BattRealdata> list=subService.serchDate100("1000018_2023_09");*/
|
/*92
|
List list= subService.getLtEndTime("tb_pwrdev_historydata_115000003_2022_06",date3);*/
|
/*95
|
subService.createTable4BattAlarmDataHistoryByYear("2021_01");*/
|
/*97
|
List list=pdhmapper.getTableNameList("110000111_2021_06");*/
|
/*114
|
List list=new ArrayList();
|
for (int i=0;i<4;i++){
|
DevalarmDataHistory bh=new DevalarmDataHistory();
|
bh.setDevId(618500005+i);
|
bh.setDevIp("192.168.10.79");
|
bh.setRecordId(-6069479889549612607l);
|
bh.setAlmType(110121);
|
bh.setAlmLevel(1+i);
|
bh.setAlmStartTime(date1);
|
bh.setAlmEndTime(date2);
|
bh.setAlmValue(2.53f+i);
|
bh.setAlmIsConfirmed(0+i);
|
bh.setAlmConfirmedTime(date1);
|
bh.setAlmClearedType(1+i);
|
bh.setUsrId(1002+i);
|
bh.setAlmSeverity(1);
|
list.add(bh);
|
}
|
subService.insertBatch4DevAlarmDataHistoryByYear("2023_09",list);*/
|
/*115*/
|
/*115
|
List list= subService.getWeekOrDayData("tb_pwrdev_historydata_115000003_2022_06",date3,date4);*/
|
/*119
|
subService.createTable4DevAlarmDataHistoryByYear("2022_10");
|
*/
|
/*121
|
List list= subService.getLevelSubList_dev(1002,"tb_devalarm_data_history_2022_12");*/
|
/*125
|
BattmonTestcap btcp=new BattmonTestcap();
|
btcp.setTableName("tb_battmon_testcap_2_1000_15");
|
btcp.setMonvolstd(2);
|
btcp.setMoncapstd(1000);
|
btcp.setBattmodel("TEST");
|
btcp.setBattproducer("理士");
|
btcp.setNote("15");
|
btcp.setBattgroupId(1000121);
|
btcp.setMonNum("1");
|
btcp.setTestRecordCount(1);
|
subService.del(btcp);*/
|
/*130*/
|
/*130
|
List typelist=new ArrayList();
|
typelist.add(110121);
|
typelist.add(110122);
|
List list=subService.getLevelSubList_pwr(1002,"tb_pwrdev_alarm_history_2022",typelist);*/
|
/*时间格式测试1
|
String time1= ThreadLocalUtil.format(date2,2);
|
/*时间格式测试2
|
Date date= ThreadLocalUtil.parse(time1,2);
|
System.out.println(date);*/
|
/*1
|
*
|
List list=subService.searchMaxNum2(date1,date2,"110000001_2023_04");*/
|
/*
|
List<StandardFeatureCurve> list=new ArrayList();
|
StandardFeatureCurve sf1=new StandardFeatureCurve();
|
sf1.setTime("00:00:07");
|
sf1.setValue(13.078000259399414);
|
list.add(sf1);
|
StandardFeatureCurve sf2=new StandardFeatureCurve();
|
sf2.setTime("00:00:07");
|
sf2.setValue(13.078000259399414);
|
list.add(sf2);
|
subService.insertBatch("122v150ah_0.15c",list);
|
subService.createTable("123v150ah_0.15c");*/
|
/*6
|
subService.delete(1000094,1);*/
|
/*7
|
subService.deleteByNum("tb_eleprice_1014",5);*/
|
|
Date date5=ThreadLocalUtil.parse("2023-08-01 10:39:16",1);
|
Date date6=ThreadLocalUtil.parse("2023-08-11 12:11:42",1);
|
/*10List list=subService.getListByStationId(date5,date6,"42010011","tb_battalarm_data_history_2023_08");*/
|
/*12
|
ElePrice ele=new ElePrice();
|
ele.setTmpId(1015);
|
ele.setTmpStarttime(date5);
|
ele.setTmpStoptime(date6);
|
ele.setElePrice(20f);
|
subService.addElePrice(ele);*/
|
/*15
|
BattResData br=subService.getMinInfo(1000005,1);*/
|
/*16
|
Ld9testdataInf linf=new Ld9testdataInf();
|
linf.setBattGroupId(1000003);
|
linf.setTestRecordCount(1);
|
List list=subService.searchlinftestdata(linf);*/
|
/*17
|
int tableNum= subService.judgeTable("1000012");*/
|
/*18
|
List list= subService.serchByCondition(date5,date6,"110000001_2023_04",7);*/
|
/*19
|
List list= subService.serchByInfo(1,1000003,3);
|
List list= subService.serchByCondition(1,1000003);*/
|
/*20
|
float monvol=subService.calcAvgVol(1000005,1);*/
|
/*23
|
subService.deleteEleprice("tb_eleprice_1001");
|
subService.createEleprice("tb_eleprice_1016");
|
List list=subService.getList("tb_eleprice_1002");*/
|
/*24
|
int tableNum= subService.judgeTable_realdata("1000003_2020_12");*/
|
/*29
|
BattRealdata realdata = new BattRealdata();
|
realdata.setTableName("1000018_2023_09");
|
realdata.setRecrodTime(date5);
|
realdata.setRecrodTime1(date6);
|
realdata.setMonNum(19);
|
realdata.setRoteN(7);
|
//List list=subService.searchMaxNum2(realdata);
|
//int maxNum=subService.searchMaxNum(realdata);
|
List list=subService.serchByCondition2(realdata);*/
|
/*32
|
List list= subService.getList(1000011,1);*/
|
/*33
|
List list= subService.getListByStationId_pwr(date5,date6,"42010020","tb_pwrdev_alarm_history_2023");*/
|
/*35
|
//List list= subService.serchByCondition(7,1,1000069,1);
|
Ld9testdata ld9testdata=new Ld9testdata();
|
ld9testdata.setBattGroupId(1000069);
|
ld9testdata.setTestRecordCount(1);
|
//List list= subService.serchByInfo(ld9testdata);
|
Ld9testdataInf ld9inf=new Ld9testdataInf();
|
ld9inf.setBattGroupId(1000069);
|
ld9inf.setTestRecordCount(1);
|
//List list= subService.getLD9AllGroupByTestRecordCount(ld9inf);
|
Map map= subService.getLD9AllGroupTimeLong(ld9inf);*/
|
/*37
|
//float vol=subService.calcAvgVol_stop(1000028,1);
|
//BattTestDataStop btsp=subService.findByMonNum(1000028,1);
|
BattTestDataStop stop=new BattTestDataStop();
|
stop.setBattGroupId(1000028);
|
stop.setMonNum(1);
|
stop.setTestRecordCount(1);
|
stop.setMonVol(1.0f);
|
//float cap= subService.getRealCap(stop);
|
List list= subService.getTestDataStop(1000028,date5);*/
|
/*38
|
ReportBattDTO dto=new ReportBattDTO();
|
dto.setBattGroupId(1000007);
|
dto.setTestType(5);
|
dto.setMonNum(0);
|
dto.setStationName("山西省-太原市-迎泽区-局机房119-局机房站-2");
|
dto.setStationName1("山西省");
|
List list= subService.searchByBattGroupId5(dto);*/
|
/*45
|
//List list= subService.getList_fbo(1000048,5);
|
int monCount=subService.getMonCuntBytestRecordCount(1000048,5);*/
|
/*46
|
ReportBattDTO dto=new ReportBattDTO();
|
dto.setBattGroupId(1000007);
|
dto.setTestType(2);
|
dto.setMonNum(0);
|
dto.setStationName("山西省-太原市-迎泽区-局机房119-局机房站-2");
|
dto.setStationName1("山西省");
|
List list= subService.searchByBattGroupId(dto);*/
|
/*49
|
int flag=subService.updateFlag("AppServer_Reinit_BattGroupData_EN");*/
|
/*52
|
int judgeNUm= subService.judge(1000007);*/
|
/*55*/
|
List list=subService.getListByStationId_dev(date5,date6,"42010020","tb_devalarm_data_history_2023_08");
|
return new Response().setII(1,true,list,null);
|
}
|
}
|
