ke
2024-05-20 9de7f6c737a6370888564add8cc0e2be9f196329
skjcmanager/skjcmanager-service/skjcmanager-sm/src/main/java/cn/gistack/sm/sjztmd/word/controller/DownTemplateController.java
@@ -2,7 +2,9 @@
import cn.gistack.sm.sjztmd.util.MyDateUtils;
import cn.gistack.sm.sjztmd.word.service.ISjztmdService;
import cn.gistack.sm.sjztmd.word.util.BriefReportUtil;
import cn.gistack.sm.sjztmd.word.util.ExcelUtil;
import cn.gistack.sm.sjztmd.word.util.WordUtil;
import cn.gistack.sm.sjztmd.word.vo.*;
@@ -10,6 +12,7 @@
import io.swagger.annotations.Api;
import lombok.AllArgsConstructor;
import lombok.extern.slf4j.Slf4j;
import org.springblade.core.tool.api.R;
import org.springframework.core.io.InputStreamResource;
import org.springframework.http.MediaType;
import org.springframework.http.ResponseEntity;
@@ -42,12 +45,22 @@
   private final ISjztmdService sjztmdService;
   @GetMapping(value = "/getBriefReport")
   public R getBriefReport() {
      //获取总览、大中库、明细数据
      List<TotalInfo> totalList = sjztmdService.getTotalInfo("");
      return R.data(BriefReportUtil.formatTotalInfo(totalList));
   }
   @GetMapping("/download/{resGuid}")
   public ResponseEntity genera(HttpServletResponse response, @PathVariable String resGuid) throws Exception {
      TbWordVO tbWordVO = sjztmdService.getTbWordVO(resGuid);
      HashMap<String,Object> obj = sjztmdService.getTbWordVO(resGuid);
      TbWordVO tbWordVO = (TbWordVO) obj.get("tbWordVO");
      Map<String,Object> tableMap= (Map<String, Object>) obj.get("tableMap");
      String fileName = resGuid + ".docx";
      byte[] data = WordUtil.compileTemplateAndRenderData(tbWordVO);
      byte[] data = WordUtil.compileTemplateAndRenderData(tbWordVO,tableMap);
      // 创建响应实体并设置响应头,将输出流作为响应体返回给客户端
      InputStreamResource resource = new InputStreamResource(new ByteArrayInputStream(data));
@@ -60,35 +73,55 @@
   }
   @GetMapping("/download/overFloodInfo")
   public ResponseEntity overFloodInfo() throws Exception{
      String time = new SimpleDateFormat("yyyy-MM-dd").format(new Date());
      String fileName =  time+ "全省水库防汛情况.docx";
   public ResponseEntity overFloodInfo(String isShow) throws Exception{
      String time = new SimpleDateFormat("yyyy日MM月dd日HH时").format(new Date());
      String fileName =  time+ "报汛文件.docx";
      String fileNameURL = URLEncoder.encode(fileName, "UTF-8");
      //获取总览、大中库、明细数据
      List<TotalInfo> totalList = sjztmdService.getTotalInfo();
      List<DzkInfo> dzkList = sjztmdService.getDzkInfo();
      List<OverDetail> overDetailList = sjztmdService.getOverDetailInfo();
      List<SzInfo> szInfoList = sjztmdService.getSzInfo();
      List<TotalInfo> totalList = sjztmdService.getTotalInfo(isShow);
      List<DzkInfo> dzkList = sjztmdService.getDzkInfo(isShow);
      List<OverDetail> overDetailList = sjztmdService.getOverDetailInfo(isShow);
      List<SzInfo> szInfoList = sjztmdService.getSzInfo(isShow);
      byte[] data = WordUtil.GetOverInfo(totalList,dzkList,overDetailList,szInfoList);
      HashMap<String,String> over10Params = new HashMap<>();
      //small_start_stag=0&small_end_stag=2&mid_start_stag=0&mid_end_stag=2&big_start_stag=0&big_end_stag=2
      over10Params.put("small_start_stag", "0.1");
      over10Params.put("mid_start_stag", "0.1");
      over10Params.put("big_start_stag", "0.1");
      HashMap<String,String> normalParams = new HashMap<>();
      //small_start_stag=0&small_end_stag=2&mid_start_stag=0&mid_end_stag=2&big_start_stag=0&big_end_stag=2
      normalParams.put("small_start_stag", "0");
      normalParams.put("mid_start_stag", "0");
      normalParams.put("big_start_stag", "0");
      List<TotalInfo> totalOverList = sjztmdService.getTotalOverInfo(isShow,normalParams);
      List<TotalInfo> totalOver10List = sjztmdService.getTotalOverInfo(isShow,over10Params);
      byte[] data =  null;
      if (MyDateUtils.isTodayInFloodSeason()){
         data = WordUtil.GetOverInfo(totalList,dzkList,overDetailList,szInfoList);
      }else {
         data= WordUtil.GetNotInSeasonOverInfo(totalList,dzkList,overDetailList,szInfoList,totalOverList,totalOver10List);
      }
      // 创建响应实体并设置响应头,将输出流作为响应体返回给客户端
      InputStreamResource resource = new InputStreamResource(new ByteArrayInputStream(data));
      // 将临时文件添加到响应中,以便用户下载
      return ResponseEntity.ok()
         .contentType(MediaType.APPLICATION_OCTET_STREAM) // 设置响应的内容类型为二进制流(octet stream)
         .header("Content-Disposition", "attachment; filename=\"" + fileNameURL) // 设置响应的Content-Disposition头,以便浏览器提示用户下载文件
         .contentType(MediaType.valueOf("application/vnd.openxmlformats-officedocument.wordprocessingml.document")) // 设置响应的内容类型为二进制流(octet stream)
         .header("Content-Disposition", "attachment; filename=" + fileNameURL) // 设置响应的Content-Disposition头,以便浏览器提示用户下载文件
         .body(resource); // 将InputStreamResource对象作为响应体
   }
   @GetMapping("/download/getOverFloodInfoExcel")
   public void getOverFloodInfoExcel(HttpServletResponse response) throws Exception {
   public void getOverFloodInfoExcel(HttpServletResponse response,String isShow) throws Exception {
      //获取总览、大中库、明细数据
      List<TotalInfo> totalList = sjztmdService.getTotalInfo();
      List<DzkInfo> dzkList = sjztmdService.getDzkInfo();
      List<OverDetail> overDetailList = sjztmdService.getOverDetailInfo();
      List<TotalInfo> totalList = sjztmdService.getTotalInfo(isShow);
      List<DzkInfo> dzkList = sjztmdService.getDzkInfo(isShow);
      List<OverDetail> overDetailList = sjztmdService.getOverDetailInfo(isShow);
      ExcelUtil.generateExcel(response,totalList,dzkList,overDetailList);
   }