fengxiang
2018-02-28 a0341d4100c15c57fb645fd1f23225563e306712
src/main/java/com/moral/controller/ReportController.java
@@ -18,7 +18,7 @@
import org.springframework.web.bind.annotation.RestController;
import com.moral.common.bean.ResultBean;
import com.moral.service.DataService;
import com.moral.service.HistoryMinutelyService;
@RestController
@RequestMapping("report")
@@ -26,25 +26,24 @@
public class ReportController {
   @Resource
   private DataService dataService;
   private HistoryMinutelyService historyMinutelyService;
   
   @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);
      Map<String, List<Object>> demo = historyMinutelyService.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);
      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("-");
@@ -56,6 +55,7 @@
      } 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();