| | |
| | | @GetMapping("excel")
|
| | | public ResultBean<Boolean> getExcelReport(HttpServletRequest request,HttpServletResponse response) throws Exception {
|
| | | Map<String, Object> parameters = getParametersStartingWith(request, null);
|
| | | List<Map<String, Object>> list = historyMinutelyService.getMonitorPointOrDeviceAvgData4Excel(parameters); |
| | | List<Map<String, Object>> list = historyMinutelyService.getMonitorPointOrDeviceAvgData(parameters); |
| | | String[][] exportColumn = new String[2][];
|
| | | exportColumn[0] = new String[] { "时间", "20", "time" };
|
| | | if (parameters.containsKey("sensors")) {
|
| | | Set<String> sensors = (Set<String>) parameters.get("sensors");
|
| | | exportColumn = new String[sensors.size() + 1][];
|
| | | exportColumn[0] = new String[] { "时间", "20", "time" };
|
| | | // exportColumn[0] = new String[] { "时间", "20", "time" };
|
| | | int index = 1;
|
| | | for (String sensorKey : sensors) {
|
| | | String[] split = sensorKey.split("-");
|
| | |
| | | } else {
|
| | | exportColumn[1] = new String[] { (String) parameters.get("sensorName"), "10", (String) parameters.get("sensorKey") };
|
| | | }
|
| | | exportColumn[0] = new String[] { "时间", "20", "time" };
|
| | |
|
| | | OutputStream outputStream = exportData(response, "Excel数据", list, exportColumn);
|
| | | outputStream.flush();
|