| | |
| | | import javax.servlet.http.HttpServletResponse;
|
| | |
|
| | | import org.apache.commons.collections.CollectionUtils;
|
| | | import org.apache.commons.lang.StringUtils;
|
| | | import org.springframework.util.ObjectUtils;
|
| | | import org.springframework.web.bind.annotation.CrossOrigin;
|
| | | import org.springframework.web.bind.annotation.GetMapping;
|
| | |
| | | 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);
|
| | |
| | | } else {
|
| | | timeb = parameters.get("timeb").toString();
|
| | | }
|
| | |
|
| | |
|
| | | String[] endTimes = timeb.split("-");
|
| | | String dateFormat = "";
|