jfreechart+easyExcel 方式导出报表

Administrator

2021-04-16 dfed9c07aa8da5791d568736716bc4b44d59ebaf

 blade-service/blade-jfpts/src/main/java/org/springblade/jfpt/feign/ReportFeign.java

@@ -36,6 +36,33 @@
   public List<AlarmExcel> getAlarmList(@RequestBody String body){
      Map<String,Object> map = JSONObject.parseObject(body);
      //创建对象，并封装数据
      AlarmVO alarmVO = getAlarmVO(map);
      //查询数据并返回数据
      List<AlarmExcel> excelList = iAlarmService.exportAlarm(alarmVO);
      return excelList;
   }

   /**
    * 获取实时警情数据集合
    * @param body map集合数据
    * @return
    */
   @PostMapping("getAlarmPie")
   public List<ReportReturnData> getAlarmPie(@RequestBody String body){
      Map<String,Object> map = JSONObject.parseObject(body);
      //创建对象，并封装数据
      AlarmVO alarmVO = getAlarmVO(map);
      //查询数据并返回数据
      List<ReportReturnData> excelList = iAlarmService.getAlarmPie(alarmVO);
      return excelList;
   }

   /**
    * 封装实时警情查询条件
    * @param map
    * @return
    */
   private AlarmVO getAlarmVO(Map<String, Object> map) {
      AlarmVO alarmVO = new AlarmVO();
      if (null!=map.get("beginTime")) {
         alarmVO.setBeginTime(map.get("beginTime").toString());
@@ -49,10 +76,9 @@
      if (null!=map.get("timeDesc")) {
         alarmVO.setTimeDesc(map.get("timeDesc").toString());
      }
      //查询数据并返回数据
      List<AlarmExcel> excelList = iAlarmService.exportAlarm(alarmVO);
      return excelList;
      return alarmVO;
   }


   /**
    * 获取健康码数据集合
@@ -63,6 +89,35 @@
   public List<HealthcodeExcel> getHealthcodeList(@RequestBody String body){
      Map<String,Object> map = JSONObject.parseObject(body);
      //创建对象，并封装数据
      HealthcodeVO healthcodeVO = getHealthcodeVo(map);
      //查询数据并返回数据
      List<HealthcodeExcel> excelList = ihealthcodeService.exportHealthcode(healthcodeVO);
      return excelList;
   }



   /**
    * 获取健康码图标数据
    * @param body map集合数据
    * @return
    */
   @PostMapping("getHealthcodePie")
   public List<HealthcodeExcel> getHealthcodePie(@RequestBody String body){
      Map<String,Object> map = JSONObject.parseObject(body);
      //创建对象，并封装数据
      HealthcodeVO healthcodeVO = getHealthcodeVo(map);
      //查询数据并返回数据
      List<HealthcodeExcel> excelList = ihealthcodeService.getHealthcodePie(healthcodeVO);
      return excelList;
   }

   /**
    * 封装健康码条件数据
    * @param map
    * @return
    */
   private HealthcodeVO getHealthcodeVo(Map<String, Object> map) {
      HealthcodeVO healthcodeVO = new HealthcodeVO();
      if (null!=map.get("begTime")) {
         healthcodeVO.setBegTime(map.get("begTime").toString());
@@ -76,9 +131,7 @@
      if (null!=map.get("timeDesc")) {
         healthcodeVO.setTimeDesc(map.get("timeDesc").toString());
      }
      //查询数据并返回数据
      List<HealthcodeExcel> excelList = ihealthcodeService.exportHealthcode(healthcodeVO);
      return excelList;
      return healthcodeVO;
   }

   /**
@@ -90,6 +143,34 @@
   public List<AnimalHeatExcel> getAnimalHeatList(@RequestBody String body){
      Map<String,Object> map = JSONObject.parseObject(body);
      //创建对象，并封装数据
      AnimalHeatVo animalHeatVo = getAnimalHeatVo(map);
      //查询数据并返回数据
      List<AnimalHeatExcel> excelList = animalHeatService.exportAnimalHeat(animalHeatVo);
      return excelList;
   }

   /**
    * 获取体温图表数据
    * @param body map集合数据
    * @return
    */
   @PostMapping("getAnimalHeatPie")
   public List<ReportReturnData> getAnimalHeatPie(@RequestBody String body){
      Map<String,Object> map = JSONObject.parseObject(body);
      //创建对象，并封装数据
      AnimalHeatVo animalHeatVo = getAnimalHeatVo(map);
      //查询数据并返回数据
      List<ReportReturnData> reportReturnData = animalHeatService.getAnimalHeatPie(animalHeatVo);
      System.out.println("reportReturnData = " + reportReturnData);
      return reportReturnData;
   }

   /**
    * 体温数据条件封装
    * @param map
    * @return
    */
   private AnimalHeatVo getAnimalHeatVo(Map<String, Object> map) {
      AnimalHeatVo animalHeatVo = new AnimalHeatVo();
      if (null!=map.get("begTime")) {
         animalHeatVo.setBegTime(map.get("begTime").toString());
@@ -103,9 +184,7 @@
      if (null!=map.get("timeDesc")) {
         animalHeatVo.setTimeDesc(map.get("timeDesc").toString());
      }
      //查询数据并返回数据
      List<AnimalHeatExcel> excelList = animalHeatService.exportAnimalHeat(animalHeatVo);
      return excelList;
      return animalHeatVo;
   }

   /**