123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130 |
- //package service;
- //
- //import cn.hutool.core.io.FileUtil;
- //import cn.hutool.poi.excel.ExcelReader;
- //import cn.hutool.poi.excel.ExcelUtil;
- //import com.jiayue.NeimApplication;
- //import com.jiayue.biz.service.EquipmentAttributeService;
- //import com.jiayue.biz.service.impl.*;
- //import org.apache.commons.lang3.time.DateUtils;
- //import org.apache.poi.xssf.streaming.SXSSFRow;
- //import org.apache.poi.xssf.streaming.SXSSFSheet;
- //import org.apache.poi.xssf.streaming.SXSSFWorkbook;
- //import org.joda.time.DateTime;
- //import org.springframework.beans.factory.annotation.Autowired;
- //import org.springframework.beans.factory.annotation.Value;
- //import org.springframework.boot.test.context.SpringBootTest;
- //import org.springframework.security.core.parameters.P;
- //
- //import java.text.SimpleDateFormat;
- //import java.util.*;
- //
- //import org.apache.commons.math3.fitting.PolynomialCurveFitter;
- //import org.apache.commons.math3.fitting.WeightedObservedPoints;
- ///**
- // * 删除上报日志测试类
- // *
- // * @author xsl
- // * @version 3.0
- // */
- //@SpringBootTest(classes = NeimApplication.class, webEnvironment = SpringBootTest.WebEnvironment.RANDOM_PORT)
- //public class Test {
- //
- // @Autowired
- // HomePageServiceImpl homePageService;
- // @Autowired
- // PdfServiceImpl pdfService;
- // @Autowired
- // private WindTowerCalculationDataServiceImpl windTowerCalculationDataService;
- // @Autowired
- // private EquipmentAttributeService equipmentAttributeService;
- // @Autowired
- // private WindDirectionStatisticsDataServiceImpl windDirectionStatisticsDataService;
- // @Autowired
- // private WindTowerInfoServiceImpl windTowerInfoService;
- // @Autowired
- // private StatisticsSituationServiceImpl statisticsSituationService;
- // @Autowired
- // private RealTimeDisplayServiceImpl realTimeDisplayService;
- //@Autowired
- //private WindTowerDataParentTableServiceImpl windTowerDataParentTableService;
- // @Autowired
- //private WsWdServiceImpl wsWdService;
- // @org.junit.jupiter.api.Test
- // public void main() {
- //// homePageService.homePageCharts("006172");86400000
- // try {
- // // 1664467200000L
- // SimpleDateFormat sdf = new SimpleDateFormat("yyyy-MM-dd HH:mm:ss");
- //
- //// System.out.println(sdf.parse("2022-08"));
- //// System.out.println(new SimpleDateFormat("yyyy-MM").parse("2022-08").getTime());
- // windTowerDataParentTableService.selectDataByBetweenTimeAndEquipmetId(new Date(1656604800000L),new Date(1659110400000L),"006173");
- //// homePageService.homePageAllWindMap();
- //// /*系统今日的时间戳*/
- //// long date = DateTimeUtil.getDayStartTime(new Date().getTime()).getTime() - 86400000;
- //// Boolean status = true;
- //// WindTowerDataParentTable lastData = windTowerDataParentTableService.getLastData("006172");
- //// /*获取该塔接入的时间*/
- //// long startTime = DateTimeUtil.getDayStartTime(lastData.getTime().getTime()).getTime();
- //// /*测风塔最新接入时间 - 今日系统时间 = 差值 差值代表此塔几天没有接入数据,若差值>=10 将此塔状态设置为异常*/
- //// long differenceDays = date - startTime;
- //// if ((differenceDays/86400000)>=10){
- //// status = false;
- //// }else {
- //// status = true;
- //// }
- // } catch (Exception e) {
- // e.printStackTrace();
- // }
- //
- // }
- // @org.junit.jupiter.api.Test
- // public void main12() {
- //// homePageService.homePageCharts("006172");
- // try {
- // SimpleDateFormat sdf = new SimpleDateFormat("M");
- // System.out.println(sdf.format(new Date(1662791812000L)));
- // // pdf
- //// long yesterday = new Date().getTime() - 1000 * 60 * 60 * 24;//昨天
- //// Date startTime = DateTimeUtil.getDayStartTime(DateTimeUtil.getYearDay(yesterday).getTime());//报告的开始时间 一年前的昨天的00:00:00
- //// Date endTime = DateTimeUtil.getDayLastTime(yesterday);//报告的结束时间 昨天的23:59:59
- // // 一年的计算数据
- //// List<WindTowerCalculationData> windTowerCalculationDatas = windTowerCalculationDataService.getByBetweenTimeAndEquipmentId(startTime, endTime, "006170");
- // //所有类型数据
- //// List<EquipmentAttribute> equipmentAttributeList = equipmentAttributeService.list();
- //// List<WindDirectionStatisticsData> windDirectionStatisticsDataList = windDirectionStatisticsDataService.getByBetweenTimeAndEquipmentId(startTime, endTime, "006170");
- //// Map<String, Object> wsAndWsStaData = pdfService.getMonthRoseCharts(windDirectionStatisticsDataList, equipmentAttributeList, "120A");
- //// System.out.println(wsAndWsStaData);
- //// List<Map<String, Object>> list = windTowerCalculationDataService.getWindShearByEqidAndAverageAndTime(1659283200000L,"140A","006173");
- //// System.out.println(list);
- //// Map<String, Object> map = realTimeDisplayService.queryTPAndAirDensity(new Date(1663084799000L),new Date(1663689599000L),"006173");
- //// System.out.println(map);
- // // 日期集合
- //// SimpleDateFormat sdf = new SimpleDateFormat("yyyy-MM-dd HH:mm:ss");
- //// ArrayList<String> timeList = new ArrayList<>();
- //// for(long i = 1663171200000L; i < 1663775999999L; i = i + 1000 * 60 * 10L){
- //// timeList.add(sdf.format(new Date(i)));
- //// }
- //// System.out.println(timeList);
- //// SimpleDateFormat sdf1 = new SimpleDateFormat("dd");
- //// // 若当天时间为每个月一号, 结束时间为上个月得月末时间
- //// long date = 1661996396000L;
- //// System.out.println(sdf1.format(new Date(date)).equals("01"));
- //// long endTime = 1L;
- //// if(sdf1.format(new Date(date)).equals("01")){
- //// endTime = DateTimeUtil.getDayLastTime(DateTimeUtil.mouthLastDay(1).getTime()).getTime();
- //// }else{
- //// // 若当天时间不为每个月一号,结束时间为本月的当前时间-1(昨天)
- //// long yesterday = new Date().getTime() - 1000 * 60 * 60 * 24;//昨天
- //// endTime = DateTimeUtil.getDayLastTime(yesterday).getTime();
- //// }
- //
- // } catch (Exception e) {
- // e.printStackTrace();
- // }
- //
- // }
- //
- //
- //}
|