Test.java 6.4 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130
  1. //package service;
  2. //
  3. //import cn.hutool.core.io.FileUtil;
  4. //import cn.hutool.poi.excel.ExcelReader;
  5. //import cn.hutool.poi.excel.ExcelUtil;
  6. //import com.jiayue.NeimApplication;
  7. //import com.jiayue.biz.service.EquipmentAttributeService;
  8. //import com.jiayue.biz.service.impl.*;
  9. //import org.apache.commons.lang3.time.DateUtils;
  10. //import org.apache.poi.xssf.streaming.SXSSFRow;
  11. //import org.apache.poi.xssf.streaming.SXSSFSheet;
  12. //import org.apache.poi.xssf.streaming.SXSSFWorkbook;
  13. //import org.joda.time.DateTime;
  14. //import org.springframework.beans.factory.annotation.Autowired;
  15. //import org.springframework.beans.factory.annotation.Value;
  16. //import org.springframework.boot.test.context.SpringBootTest;
  17. //import org.springframework.security.core.parameters.P;
  18. //
  19. //import java.text.SimpleDateFormat;
  20. //import java.util.*;
  21. //
  22. //import org.apache.commons.math3.fitting.PolynomialCurveFitter;
  23. //import org.apache.commons.math3.fitting.WeightedObservedPoints;
  24. ///**
  25. // * 删除上报日志测试类
  26. // *
  27. // * @author xsl
  28. // * @version 3.0
  29. // */
  30. //@SpringBootTest(classes = NeimApplication.class, webEnvironment = SpringBootTest.WebEnvironment.RANDOM_PORT)
  31. //public class Test {
  32. //
  33. // @Autowired
  34. // HomePageServiceImpl homePageService;
  35. // @Autowired
  36. // PdfServiceImpl pdfService;
  37. // @Autowired
  38. // private WindTowerCalculationDataServiceImpl windTowerCalculationDataService;
  39. // @Autowired
  40. // private EquipmentAttributeService equipmentAttributeService;
  41. // @Autowired
  42. // private WindDirectionStatisticsDataServiceImpl windDirectionStatisticsDataService;
  43. // @Autowired
  44. // private WindTowerInfoServiceImpl windTowerInfoService;
  45. // @Autowired
  46. // private StatisticsSituationServiceImpl statisticsSituationService;
  47. // @Autowired
  48. // private RealTimeDisplayServiceImpl realTimeDisplayService;
  49. //@Autowired
  50. //private WindTowerDataParentTableServiceImpl windTowerDataParentTableService;
  51. // @Autowired
  52. //private WsWdServiceImpl wsWdService;
  53. // @org.junit.jupiter.api.Test
  54. // public void main() {
  55. //// homePageService.homePageCharts("006172");86400000
  56. // try {
  57. // // 1664467200000L
  58. // SimpleDateFormat sdf = new SimpleDateFormat("yyyy-MM-dd HH:mm:ss");
  59. //
  60. //// System.out.println(sdf.parse("2022-08"));
  61. //// System.out.println(new SimpleDateFormat("yyyy-MM").parse("2022-08").getTime());
  62. // windTowerDataParentTableService.selectDataByBetweenTimeAndEquipmetId(new Date(1656604800000L),new Date(1659110400000L),"006173");
  63. //// homePageService.homePageAllWindMap();
  64. //// /*系统今日的时间戳*/
  65. //// long date = DateTimeUtil.getDayStartTime(new Date().getTime()).getTime() - 86400000;
  66. //// Boolean status = true;
  67. //// WindTowerDataParentTable lastData = windTowerDataParentTableService.getLastData("006172");
  68. //// /*获取该塔接入的时间*/
  69. //// long startTime = DateTimeUtil.getDayStartTime(lastData.getTime().getTime()).getTime();
  70. //// /*测风塔最新接入时间 - 今日系统时间 = 差值 差值代表此塔几天没有接入数据,若差值>=10 将此塔状态设置为异常*/
  71. //// long differenceDays = date - startTime;
  72. //// if ((differenceDays/86400000)>=10){
  73. //// status = false;
  74. //// }else {
  75. //// status = true;
  76. //// }
  77. // } catch (Exception e) {
  78. // e.printStackTrace();
  79. // }
  80. //
  81. // }
  82. // @org.junit.jupiter.api.Test
  83. // public void main12() {
  84. //// homePageService.homePageCharts("006172");
  85. // try {
  86. // SimpleDateFormat sdf = new SimpleDateFormat("M");
  87. // System.out.println(sdf.format(new Date(1662791812000L)));
  88. // // pdf
  89. //// long yesterday = new Date().getTime() - 1000 * 60 * 60 * 24;//昨天
  90. //// Date startTime = DateTimeUtil.getDayStartTime(DateTimeUtil.getYearDay(yesterday).getTime());//报告的开始时间 一年前的昨天的00:00:00
  91. //// Date endTime = DateTimeUtil.getDayLastTime(yesterday);//报告的结束时间 昨天的23:59:59
  92. // // 一年的计算数据
  93. //// List<WindTowerCalculationData> windTowerCalculationDatas = windTowerCalculationDataService.getByBetweenTimeAndEquipmentId(startTime, endTime, "006170");
  94. // //所有类型数据
  95. //// List<EquipmentAttribute> equipmentAttributeList = equipmentAttributeService.list();
  96. //// List<WindDirectionStatisticsData> windDirectionStatisticsDataList = windDirectionStatisticsDataService.getByBetweenTimeAndEquipmentId(startTime, endTime, "006170");
  97. //// Map<String, Object> wsAndWsStaData = pdfService.getMonthRoseCharts(windDirectionStatisticsDataList, equipmentAttributeList, "120A");
  98. //// System.out.println(wsAndWsStaData);
  99. //// List<Map<String, Object>> list = windTowerCalculationDataService.getWindShearByEqidAndAverageAndTime(1659283200000L,"140A","006173");
  100. //// System.out.println(list);
  101. //// Map<String, Object> map = realTimeDisplayService.queryTPAndAirDensity(new Date(1663084799000L),new Date(1663689599000L),"006173");
  102. //// System.out.println(map);
  103. // // 日期集合
  104. //// SimpleDateFormat sdf = new SimpleDateFormat("yyyy-MM-dd HH:mm:ss");
  105. //// ArrayList<String> timeList = new ArrayList<>();
  106. //// for(long i = 1663171200000L; i < 1663775999999L; i = i + 1000 * 60 * 10L){
  107. //// timeList.add(sdf.format(new Date(i)));
  108. //// }
  109. //// System.out.println(timeList);
  110. //// SimpleDateFormat sdf1 = new SimpleDateFormat("dd");
  111. //// // 若当天时间为每个月一号, 结束时间为上个月得月末时间
  112. //// long date = 1661996396000L;
  113. //// System.out.println(sdf1.format(new Date(date)).equals("01"));
  114. //// long endTime = 1L;
  115. //// if(sdf1.format(new Date(date)).equals("01")){
  116. //// endTime = DateTimeUtil.getDayLastTime(DateTimeUtil.mouthLastDay(1).getTime()).getTime();
  117. //// }else{
  118. //// // 若当天时间不为每个月一号,结束时间为本月的当前时间-1(昨天)
  119. //// long yesterday = new Date().getTime() - 1000 * 60 * 60 * 24;//昨天
  120. //// endTime = DateTimeUtil.getDayLastTime(yesterday).getTime();
  121. //// }
  122. //
  123. // } catch (Exception e) {
  124. // e.printStackTrace();
  125. // }
  126. //
  127. // }
  128. //
  129. //
  130. //}