From 39ecc194aeca3ded5cd046270dc1ca3d0749d09b Mon Sep 17 00:00:00 2001 From: ZhuDongming <773644075@qq.com> Date: Wed, 06 May 2020 08:58:22 +0800 Subject: [PATCH] update --- src/main/java/com/moral/controller/ReportController.java | 19 +++++++++++++++---- 1 files changed, 15 insertions(+), 4 deletions(-) diff --git a/src/main/java/com/moral/controller/ReportController.java b/src/main/java/com/moral/controller/ReportController.java index b01286f..8e0f4ef 100644 --- a/src/main/java/com/moral/controller/ReportController.java +++ b/src/main/java/com/moral/controller/ReportController.java @@ -2,7 +2,12 @@ import java.io.OutputStream; import java.text.SimpleDateFormat; -import java.util.*; +import java.util.ArrayList; +import java.util.Calendar; +import java.util.HashMap; +import java.util.LinkedHashMap; +import java.util.List; +import java.util.Map; import javax.annotation.Resource; import javax.servlet.ServletOutputStream; @@ -92,17 +97,23 @@ public ResultBean<Boolean> getNExcelReport(HttpServletRequest request, HttpServletResponse response) throws Exception { Map<String, Object> parameters = getParametersStartingWith(request, null); List<Map<String, Object>> list = historyMinutelyService.getMonitorPointOrDeviceAvgData(parameters); - System.out.println(list); + ArrayList<String> sensorKeys = (ArrayList<String>)parameters.get("sensorKeys"); + for (Map<String, Object> map : list) { + for (String sensorKey : sensorKeys) { + if(map.get(sensorKey)==null){ + map.put(sensorKey,""); + } + } + } + String type = parameters.get("type").toString(); String time = parameters.get("time").toString(); - System.out.println(parameters); String timeb = ""; if (parameters.get("timeb") == null) { timeb = parameters.get("time").toString(); } else { timeb = parameters.get("timeb").toString(); } - String[] endTimes = timeb.split("-"); String dateFormat = ""; -- Gitblit v1.8.0