| | |
|---|
| | | String startTime = parameters.get("startTime").toString();
|
|---|
| | | DateTimeFormatter dateTimeFormatter = DateTimeFormatter.ofPattern("yyyy-MM-dd HH:mm:ss");
|
|---|
| | | LocalDateTime startTimeLocalDateTime = LocalDateTime.parse(startTime, dateTimeFormatter);
|
|---|
| | | LocalDate time = LocalDate.now();
|
|---|
| | | int year = startTimeLocalDateTime.getYear();
|
|---|
| | | int month = startTimeLocalDateTime.getMonthValue();
|
|---|
| | | String monthStr = month < 10 ? ("0" + month) : month + "";
|
|---|
| | |
|---|
| | | }
|
|---|
| | | }
|
|---|
| | | }
|
|---|
| | | if(mapAvg.get("e76").equals("0°")||mapMin.get("e76").equals("0")||mapMax.get("e76").equals("0")||mapAvg.get("e77").equals("0°")||mapMin.get("e77").equals("0")||mapMax.get("e77").equals("0")){
|
|---|
| | | if("0°".equals(mapAvg.get("e76")) || "0".equals(mapMin.get("e76")) || "0".equals(mapMax.get("e76")) || "0°".equals(mapAvg.get("e77")) || "0".equals(mapMin.get("e77")) || "0".equals(mapMax.get("e77"))){
|
|---|
| | | continue;
|
|---|
| | | }
|
|---|
| | | listMapAvg.add(mapAvg);
|
|---|
| | |
|---|
| | | return listMaps;
|
|---|
| | | }
|
|---|
| | |
|
|---|
| | | @Override
|
|---|
| | | public List<Map<String, Object>> getDevicesAvgDataToExcel(Map<String, Object> parameters) throws Exception {
|
|---|
| | | if ("month".equals(parameters.get("type"))) {
|
|---|
| | | parameters.put("timeUnits", "daily");
|
|---|
| | | parameters.put("typeFormat", "%Y-%m-%d");
|
|---|
| | | String time = parameters.get("time")+"-01T00:00:00";
|
|---|
| | | LocalDateTime value = LocalDateTime.parse(time);
|
|---|
| | | LocalDateTime start = value.with(TemporalAdjusters.firstDayOfMonth());
|
|---|
| | | LocalDateTime end = value.with(TemporalAdjusters.lastDayOfMonth());
|
|---|
| | | parameters.put("start", start);
|
|---|
| | | parameters.put("end", end);
|
|---|
| | | }else if("day".equals(parameters.get("type"))){
|
|---|
| | | String time = parameters.get("time")+"T00:00:00";
|
|---|
| | | LocalDateTime value = LocalDateTime.parse(time);
|
|---|
| | | LocalDateTime end=value.plusHours(23);
|
|---|
| | | parameters.put("timeUnits", "hourly");
|
|---|
| | | parameters.put("typeFormat", "%Y-%m-%d %H");
|
|---|
| | | parameters.put("start", time);
|
|---|
| | | parameters.put("end", end);
|
|---|
| | | }
|
|---|
| | | return historyMinutelyMapper.getDevicesAvgDataToExcel(parameters);
|
|---|
| | | }
|
|---|
| | |
|
|---|
| | | }
|
|---|
