From 70231ff29a5021c01cb31f2c19033defc22c81dd Mon Sep 17 00:00:00 2001 From: fengxiang <110431245@qq.com> Date: Fri, 02 Feb 2018 09:10:37 +0800 Subject: [PATCH] 安全跨域设置 --- src/main/java/com/moral/controller/ReportController.java | 88 +++++++++++++++++++------------------------ 1 files changed, 39 insertions(+), 49 deletions(-) diff --git a/src/main/java/com/moral/controller/ReportController.java b/src/main/java/com/moral/controller/ReportController.java index 73c0897..a226e52 100644 --- a/src/main/java/com/moral/controller/ReportController.java +++ b/src/main/java/com/moral/controller/ReportController.java @@ -4,72 +4,62 @@ import static com.moral.common.util.WebUtils.getParametersStartingWith; import java.io.OutputStream; -import java.util.HashMap; import java.util.List; import java.util.Map; +import java.util.Set; +import javax.annotation.Resource; import javax.servlet.http.HttpServletRequest; import javax.servlet.http.HttpServletResponse; -import org.springframework.beans.factory.annotation.Autowired; -import static org.springframework.util.ObjectUtils.*; import org.springframework.web.bind.annotation.CrossOrigin; import org.springframework.web.bind.annotation.GetMapping; import org.springframework.web.bind.annotation.RequestMapping; import org.springframework.web.bind.annotation.RestController; -import com.moral.common.exception.BusinessException; -import com.moral.service.DeviceService; -import com.moral.service.HistoryService; +import com.moral.common.bean.ResultBean; +import com.moral.service.DataService; @RestController -@RequestMapping(value = "report") +@RequestMapping("report") @CrossOrigin(origins = "*", maxAge = 3600) public class ReportController { - @Autowired - private HistoryService historyService; + @Resource + private DataService dataService; - @Autowired - private DeviceService deviceService; - - @GetMapping("sensors-average") - public Map<String, Object> getSensorsAverageByDevice(HttpServletRequest request,HttpServletResponse response) { - Map<String, Object> result = new HashMap<String, Object>(); - try { - Map<String, Object> parameters = getParametersStartingWith(request, null); - Object mac = parameters.get("mac"); - Object time = parameters.get("time"); - Object type = parameters.get("type"); - if (isEmpty(mac) || isEmpty(time) || isEmpty(type)) { - result.put("msg", "���������������������"); - } else { - List<Map<String, Object>> sensors = deviceService.getSensorsByDevice(mac.toString()); - List<Map<String, Object>> sensorsAverage = historyService.getSensorsAverageByDevice4Report(parameters,sensors); - if (isEmpty(sensorsAverage)) { - result.put("msg", "���������������"); - } else { - String[][] exportColumn = new String[sensors.size() + 1][]; - exportColumn[0] = new String[] { "������", "20", "time" }; - for (int i = 0; i < sensors.size(); i++) { - String name = (String) sensors.get(i).get("name"); - String key = (String) sensors.get(i).get("key"); - exportColumn[i + 1] = new String[] { name, "10", key }; - } - - OutputStream outputStream = exportData(response, time + "_" + mac + "_" + type, sensorsAverage, exportColumn); - outputStream.flush(); - outputStream.close(); - } - } - } catch (BusinessException be) { - be.printStackTrace(); - result.put("msg", be.getMessage()); - } catch (Exception e) { - e.printStackTrace(); - result.put("msg", "���������������������������������������������������"+e.getMessage()); - } - return result; + @GetMapping("compare") + public ResultBean<Map<String, List<Object>>> getCompareReport(HttpServletRequest request) throws Exception { + Map<String, Object> parameters = getParametersStartingWith(request, null); + Map<String, List<Object>> demo = dataService.getCompareReport(parameters); + return new ResultBean<Map<String,List<Object>>>(demo); } + @GetMapping("excel") + public ResultBean<Boolean> getExcelReport(HttpServletRequest request,HttpServletResponse response) throws Exception { + Map<String, Object> parameters = getParametersStartingWith(request, null); + List<Map<String, Object>> list = dataService.getMonitorPointOrDeviceAvgData4Excel(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" }; + int index = 1; + for (String sensorKey : sensors) { + String[] split = sensorKey.split("-"); + String name = split[1]; + String key = split[0]; + exportColumn[index] = new String[] { name, "10", key }; + index++; + } + } else { + exportColumn[1] = new String[] { (String) parameters.get("sensorName"), "10", (String) parameters.get("sensorKey") }; + } + + OutputStream outputStream = exportData(response, "Excel������", list, exportColumn); + outputStream.flush(); + outputStream.close(); + return new ResultBean<Boolean>(true); + } } -- Gitblit v1.8.0