| | |
| | | package com.moral.api.controller; |
| | | |
| | | import com.deepoove.poi.XWPFTemplate; |
| | | import com.deepoove.poi.data.MiniTableRenderData; |
| | | import com.deepoove.poi.data.RowRenderData; |
| | | import com.deepoove.poi.data.TextRenderData; |
| | | import com.moral.api.pojo.dto.historySecondCruiser.HistorySecondCruiserResultDTO; |
| | | |
| | | import cn.afterturn.easypoi.word.WordExportUtil; |
| | | import io.swagger.annotations.Api; |
| | | import io.swagger.annotations.ApiImplicitParam; |
| | | import io.swagger.annotations.ApiImplicitParams; |
| | | import io.swagger.annotations.ApiOperation; |
| | | import lombok.extern.slf4j.Slf4j; |
| | | import org.apache.poi.xwpf.usermodel.XWPFDocument; |
| | | import org.springframework.beans.factory.annotation.Autowired; |
| | | import org.springframework.transaction.annotation.Transactional; |
| | | import org.springframework.util.ObjectUtils; |
| | | import org.springframework.util.ResourceUtils; |
| | | import org.springframework.web.bind.annotation.CrossOrigin; |
| | | import org.springframework.web.bind.annotation.GetMapping; |
| | | import org.springframework.web.bind.annotation.PostMapping; |
| | | import org.springframework.web.bind.annotation.RequestBody; |
| | | import org.springframework.web.bind.annotation.RequestMapping; |
| | | import org.springframework.web.bind.annotation.RestController; |
| | | import org.springframework.web.multipart.MultipartFile; |
| | | import org.springframework.web.multipart.MultipartHttpServletRequest; |
| | | |
| | | import java.io.File; |
| | | import java.io.FileOutputStream; |
| | | import java.io.IOException; |
| | | import java.io.OutputStream; |
| | | import java.net.URLEncoder; |
| | | import java.text.ParseException; |
| | | import java.util.ArrayList; |
| | | |
| | | import java.util.HashMap; |
| | | |
| | | import java.util.List; |
| | | import java.util.Map; |
| | | |
| | | |
| | | import javax.servlet.http.HttpServletRequest; |
| | | import javax.servlet.http.HttpServletResponse; |
| | | |
| | | import cn.hutool.poi.word.WordUtil; |
| | | import com.deepoove.poi.XWPFTemplate; |
| | | import com.deepoove.poi.config.Configure; |
| | | import com.deepoove.poi.data.PictureRenderData; |
| | | import com.deepoove.poi.data.RowRenderData; |
| | | import com.deepoove.poi.policy.HackLoopTableRenderPolicy; |
| | | import com.moral.api.entity.Dustld; |
| | | import com.moral.api.entity.SecondCruiserSort; |
| | | import com.moral.api.exception.BusinessException; |
| | | import com.moral.api.pojo.bo.ExcelBO; |
| | | import com.moral.api.pojo.dto.historySecondCruiser.HistorySecondCruiserResultDTO; |
| | | import com.moral.api.pojo.dust.DustForm; |
| | | import com.moral.api.pojo.vo.excel.DailyVo; |
| | | import com.moral.api.service.DustldService; |
| | | import com.moral.api.service.SpecialDeviceService; |
| | | import com.moral.constant.ResponseCodeEnum; |
| | | import com.moral.constant.ResultMessage; |
| | | import com.moral.util.DateUtils; |
| | | import com.moral.util.WebUtils; |
| | | import io.swagger.annotations.Api; |
| | | import io.swagger.annotations.ApiImplicitParam; |
| | | import io.swagger.annotations.ApiImplicitParams; |
| | | import io.swagger.annotations.ApiOperation; |
| | | import io.swagger.annotations.ApiParam; |
| | | import lombok.extern.slf4j.Slf4j; |
| | | import org.apache.commons.io.FileUtils; |
| | | import org.apache.poi.xwpf.usermodel.XWPFDocument; |
| | | import org.springframework.beans.factory.annotation.Autowired; |
| | | import org.springframework.boot.system.ApplicationHome; |
| | | import org.springframework.transaction.annotation.Transactional; |
| | | import org.springframework.util.ObjectUtils; |
| | | import org.springframework.util.ResourceUtils; |
| | | import org.springframework.web.bind.annotation.*; |
| | | import org.springframework.web.multipart.MultipartFile; |
| | | import org.springframework.web.multipart.MultipartHttpServletRequest; |
| | | import javax.servlet.http.HttpServletRequest; |
| | | import javax.servlet.http.HttpServletResponse; |
| | | import java.io.*; |
| | | import java.net.URLEncoder; |
| | | import java.text.ParseException; |
| | | import java.util.ArrayList; |
| | | import java.util.HashMap; |
| | | import java.util.List; |
| | | import java.util.Map; |
| | | |
| | | import static com.moral.api.controller.SysTestController.getPath; |
| | | |
| | |
| | | return ObjectUtils.isEmpty(daily) ? ResultMessage.ok() : ResultMessage.ok(daily); |
| | | } |
| | | |
| | | |
| | | |
| | | /** |
| | | * 下载走航车日报 |
| | | * @param id |
| | | * @param params |
| | | * @return |
| | | */ |
| | | @GetMapping("loadDaily") |
| | | public ResultMessage loadDaily(Integer id){ |
| | | |
| | | DailyVo dailyVo = specialDeviceService.loadDaily(id); |
| | | if (dailyVo==null){ |
| | | return ResultMessage.fail(ResponseCodeEnum.TARGET_IS_NULL.getCode(), ResponseCodeEnum.TARGET_IS_NULL.getMsg()); |
| | | @PostMapping("loadDaily") |
| | | public void loadDaily( @RequestBody Map<String,Object> params,HttpServletResponse response) throws IOException { |
| | | List<Integer> ids = (List<Integer>) params.get("ids"); |
| | | List<DailyVo> dailyVos = specialDeviceService.loadDaily(ids); |
| | | if (ObjectUtils.isEmpty(dailyVos)){ |
| | | throw new BusinessException("未找到走航信息"); |
| | | } |
| | | return new ResultMessage(ResponseCodeEnum.SUCCESS.getCode(), ResponseCodeEnum.SUCCESS.getMsg(),dailyVo); |
| | | dailyDocx(dailyVos,response); |
| | | } |
| | | |
| | | /** |
| | |
| | | */ |
| | | @PostMapping("dailyDustlds") |
| | | @Transactional |
| | | public ResultMessage dailyDustlds(@RequestBody Map<String,Object> params, HttpServletResponse response) throws IOException { |
| | | public void dailyDustlds(@RequestBody Map<String,Object> params, HttpServletResponse response,HttpServletRequest request) throws IOException { |
| | | |
| | | // Map<String, Object> params = WebUtils.getParametersStartingWith(request, null); |
| | | if (!params.containsKey("mac") || !params.containsKey("startTime") || !params.containsKey("endTime")){ |
| | | return ResultMessage.fail(ResponseCodeEnum.PARAMETERS_IS_MISSING.getCode(), ResponseCodeEnum.PARAMETERS_IS_MISSING.getMsg()); |
| | | return; |
| | | } |
| | | |
| | | Map<String, Object> map = dustldService.dailyDustlds(params); |
| | | if (ObjectUtils.isEmpty(map)){ |
| | | return ResultMessage.fail(ResponseCodeEnum.TARGET_IS_NULL.getCode(), ResponseCodeEnum.TARGET_IS_NULL.getMsg()); |
| | | throw new BusinessException("未找到路段信息"); |
| | | } |
| | | test(map,response); |
| | | // return new ResultMessage(ResponseCodeEnum.SUCCESS.getCode(),ResponseCodeEnum.SUCCESS.getMsg(),map); |
| | | return ResultMessage.ok(); |
| | | test(map,response,request); |
| | | |
| | | |
| | | } |
| | | |
| | | |
| | |
| | | |
| | | } |
| | | |
| | | @GetMapping("sort") |
| | | @ApiOperation("路段排序") |
| | | public ResultMessage sectionRanking(@RequestParam @ApiParam(value = "mac",name = "mac号") String mac, |
| | | @RequestParam @ApiParam(value = "startTime",name = "开始时间") String startTime, |
| | | @RequestParam @ApiParam(value = "endTime",name = "结束时间") String endTime){ |
| | | |
| | | List<SecondCruiserSort> sort = dustldService.sort(mac, startTime, endTime); |
| | | return ResultMessage.ok(sort); |
| | | } |
| | | |
| | | |
| | | |
| | | public static void downloadWord(String fileName, Map<String, Object> params, HttpServletResponse response, String newFileName) { |
| | |
| | | } |
| | | |
| | | |
| | | public void test( Map<String, Object> params,HttpServletResponse response) throws IOException { |
| | | // String path="D:\\尘负荷监测报告.docx"; |
| | | String path = getPath("尘负荷监测报告.docx"); |
| | | public void test( Map<String, Object> params,HttpServletResponse response,HttpServletRequest request) throws IOException { |
| | | |
| | | try { |
| | | //获取当前模板的路径 |
| | | File rootFile = new File(ResourceUtils.getURL("classpath:").getPath()); |
| | | File file= new File(rootFile, path); |
| | | //第一步:读取模板 |
| | | XWPFTemplate compile = XWPFTemplate.compile(file.getPath()); |
| | | //InputStream inputStream = WordUtil.class.getClassLoader().getResourceAsStream("word/尘负荷监测报告.docx"); |
| | | InputStream stream = WordUtil.class.getClassLoader().getResourceAsStream("word/尘负荷监测报告.docx"); |
| | | //获取临时文件 |
| | | File file = new File("word/尘负荷监测报告.docx"); |
| | | //将读取到的类容存储到临时文件中,后面就可以用这个临时文件访问了 |
| | | FileUtils.copyInputStreamToFile(stream, file); |
| | | //这个时候再去获取证书的文件路径 就可以正常获取了 |
| | | String filePath = file.getAbsolutePath(); |
| | | |
| | | |
| | | |
| | | //第二步:创建数据,用于把我们模板中的{{}}包裹的变量替换掉,map中保存的key一定要和模板中的变量保持一致 |
| | | HashMap<String, Object> map = new HashMap<>(); |
| | | //设置单元格,表头 |
| | | RowRenderData header1 = RowRenderData.build(new TextRenderData("6495ED", "序号"), new TextRenderData("6495ED", "道路"),new TextRenderData("6495ED", "平均尘负荷(克/平方米)")); |
| | | //RowRenderData header1 = RowRenderData.build(new TextRenderData("6495ED", "序号"), new TextRenderData("6495ED", "道路"),new TextRenderData("6495ED", "平均尘负荷(克/平方米)")); |
| | | |
| | | //设置表内容,如果在实际应用中,传入一个list集合或者数组,方可用foreach进行循环填充 |
| | | List<DustForm> list1 = (List<DustForm>) params.get("list1"); |
| | | |
| | | ArrayList<Map<String, Object>> mapArrayList = (ArrayList<Map<String, Object>>) params.get("list3"); |
| | | List<Map<String, Object>> mapArrayList = (ArrayList<Map<String, Object>>) params.get("list3"); |
| | | ArrayList<RowRenderData> rsList1 = new ArrayList<>(); |
| | | ArrayList<RowRenderData> rsList3 = new ArrayList<>(); |
| | | |
| | | List<Map> detailList = new ArrayList<>(); |
| | | for (int i = 0; i < list1.size(); i++) { |
| | | DustForm dustForm = list1.get(i); |
| | | RowRenderData row0 = RowRenderData.build(i+1+"",dustForm.getRoad(), dustForm.getValue()+""); |
| | | rsList1.add(row0); |
| | | Map maps = new HashMap(); |
| | | maps.put("table1", i+1); |
| | | maps.put("table2", dustForm.getRoad()); |
| | | maps.put("table3", dustForm.getValue()); |
| | | detailList.add(maps); |
| | | } |
| | | |
| | | List<Map> detailList2 = new ArrayList<>(); |
| | | Map maps = new HashMap(); |
| | | /* maps.put("table4", ""); |
| | | maps.put("table5", ""); |
| | | maps.put("table6", ""); |
| | | maps.put("table7", map.get("date1")); |
| | | maps.put("table8", map.get("date2")); |
| | | detailList2.add(maps);*/ |
| | | for (int i = 0; i < mapArrayList.size(); i++) { |
| | | Map<String, Object> map1 = mapArrayList.get(i); |
| | | RowRenderData row = RowRenderData.build(i + 1 + "", map1.get("road").toString(), map1.get("value1").toString(), map1.get("value2").toString(), map1.get("value3").toString()); |
| | | rsList3.add(row); |
| | | maps = new HashMap(); |
| | | maps.put("time4", i+1); |
| | | maps.put("time5", map1.get("road").toString()); |
| | | maps.put("time6", map1.get("value1").toString()); |
| | | maps.put("time7", map1.get("value2").toString()); |
| | | maps.put("time8", map1.get("value3").toString()); |
| | | detailList2.add(maps); |
| | | } |
| | | if (!ObjectUtils.isEmpty(mapArrayList)){ |
| | | map.put("table3", new MiniTableRenderData(rsList3)); |
| | | } |
| | | map.put("table1", new MiniTableRenderData(header1, rsList1)); |
| | | String data = params.get("data").toString(); |
| | | map.put("data",data); |
| | | map.put("time",params.get("time").toString()); |
| | | map.put("date1",params.get("date1").toString()); |
| | | map.put("date2",params.get("date2").toString()); |
| | | // map.put("data",params.get("data").toString()); |
| | | compile.render(map); |
| | | // response.addHeader("Access-Contro1-Allow-Origin", "*"); |
| | | HackLoopTableRenderPolicy policy = new HackLoopTableRenderPolicy(); |
| | | Configure config = Configure.newBuilder().bind("detailList", policy).bind("detailList2", policy).build(); |
| | | XWPFTemplate compile = XWPFTemplate.compile(filePath,config).render(new HashMap<String, Object>(){{ |
| | | put("time",map.get("time")); |
| | | put("data",map.get("data")); |
| | | put("time1",map.get("date1").toString()); |
| | | put("time2",map.get("date2").toString()); |
| | | put("detailList", detailList); |
| | | put("detailList2", detailList2); |
| | | }}); |
| | | |
| | | response.setHeader("Access-Control-Allow-Origin","*");//允许所有请求跨域 |
| | | response.setHeader("Access-Control-Allow-Methods", "*");//允许跨域的请求方法GET, POST, HEAD 等 |
| | | response.setHeader("Access-Control-Allow-Headers", "*");//允许跨域的请求头 |
| | | response.setHeader("Access-Control-Allow-Credentials", "true");//是否携带cooki |
| | | |
| | | compile.write(response.getOutputStream()); |
| | | response.setContentType("multipart/form-data"); |
| | | // 设置文件名 |
| | | response.addHeader("Content-Disposition", "attachment;fileName=ce.docx" ); |
| | | response.setCharacterEncoding("UTF-8"); |
| | | OutputStream out = response.getOutputStream(); |
| | | compile.write(out); |
| | | out.flush(); |
| | | out.close(); |
| | | compile.close(); |
| | | } catch (IOException e) { |
| | | log.error ("导出失败,请联系网站管理员!", e); |
| | | } catch (Exception e) { |
| | | throw new RuntimeException(e); |
| | | } |
| | | |
| | | } |
| | | |
| | | |
| | | |
| | | public void dailyDocx( List<DailyVo> dailyVos,HttpServletResponse response) throws IOException { |
| | | // String path = getPath(fileName); |
| | | //获取jar包所在目录 |
| | | ApplicationHome applicationHome = new ApplicationHome(getClass()); |
| | | //在jar包所在目录下生成一个upload文件夹用来存储上传的图片 |
| | | String path = applicationHome.getSource().getParentFile().toString() + "\\static\\img"; |
| | | |
| | | String name1 = dailyVos.size()>1?"word/盐城市走航监测报告.docx":"word/盐城市走航监测报告2.docx"; |
| | | |
| | | try { |
| | | //InputStream inputStream = WordUtil.class.getClassLoader().getResourceAsStream("word/尘负荷监测报告.docx"); |
| | | InputStream stream = WordUtil.class.getClassLoader().getResourceAsStream(name1); |
| | | //获取临时文件 |
| | | File file = new File(name1); |
| | | //将读取到的类容存储到临时文件中,后面就可以用这个临时文件访问了 |
| | | FileUtils.copyInputStreamToFile(stream, file); |
| | | //这个时候再去获取证书的文件路径 就可以正常获取了 |
| | | String filePath = file.getAbsolutePath(); |
| | | |
| | | |
| | | |
| | | //第二步:创建数据,用于把我们模板中的{{}}包裹的变量替换掉,map中保存的key一定要和模板中的变量保持一致 |
| | | HashMap<String, Object> map = new HashMap<>(); |
| | | //设置单元格,表头 |
| | | //RowRenderData header1 = RowRenderData.build(new TextRenderData("6495ED", "序号"), new TextRenderData("6495ED", "道路"),new TextRenderData("6495ED", "平均尘负荷(克/平方米)")); |
| | | |
| | | //设置表内容,如果在实际应用中,传入一个list集合或者数组,方可用foreach进行循环填充 |
| | | List<Map> detailList1 = new ArrayList<>(); |
| | | List<Map> detailList2 = new ArrayList<>(); |
| | | List<Map> detailList3 = new ArrayList<>(); |
| | | List<Map> detailList4 = new ArrayList<>(); |
| | | List<Map> detailList5 = new ArrayList<>(); |
| | | List<Map> detailList6 = new ArrayList<>(); |
| | | List<Map> detailList7 = new ArrayList<>(); |
| | | List<Map> detailList8 = new ArrayList<>(); |
| | | StringBuilder builder = new StringBuilder(); |
| | | List<Map> pic1 = new ArrayList<>(); |
| | | List<Map> pic2 = new ArrayList<>(); |
| | | List<Map> pic3 = new ArrayList<>(); |
| | | List<Map> pic4 = new ArrayList<>(); |
| | | List<Map> pic5 = new ArrayList<>(); |
| | | List<Map> pic6 = new ArrayList<>(); |
| | | List<Map> pic7 = new ArrayList<>(); |
| | | List<Map> pic8 = new ArrayList<>(); |
| | | |
| | | // picMap.put("urlImg", Pictures.ofUrl(str, PictureType.JPEG).size(width, height).create()); |
| | | // picMap.put("urlImg",new PictureRenderData(500, 500, "G:\\home\\3d423e3cb05d7edc35c38e3173af2a0d.jpg")); |
| | | // picMap.put("urlImg1",new PictureRenderData(500, 500, "G:\\home\\3d423e3cb05d7edc35c38e3173af2a0d.jpg")); |
| | | // picMap.put("urlImg", Pictures.ofUrl("G:\\home\\3d423e3cb05d7edc35c38e3173af2a0d.jpg", PictureType.JPEG).size(500, 500).create()); |
| | | // picMap.put("urlImg1", Pictures.ofUrl("G:\\home\\3d423e3cb05d7edc35c38e3173af2a0d.jpg", PictureType.JPEG).size(500, 500).create()); |
| | | int i =1; |
| | | for (DailyVo dailyVo : dailyVos) { |
| | | Map picMap1 = new HashMap(); |
| | | Map picMap2 = new HashMap(); |
| | | Map picMap3 = new HashMap(); |
| | | Map picMap4 = new HashMap(); |
| | | Map picMap5 = new HashMap(); |
| | | Map picMap6 = new HashMap(); |
| | | Map picMap7 = new HashMap(); |
| | | Map picMap8 = new HashMap(); |
| | | List<String> images = dailyVo.getImages(); |
| | | if (!ObjectUtils.isEmpty(images)){ |
| | | |
| | | picMap1.put("urlImg"+i,new PictureRenderData(500, 500, path+"\\"+images.get(0))); |
| | | // picMap1.put("urlImg"+i,new PictureRenderData(500, 500, path+"\\0a4ab467-304d-4871-948f-55aa7e820975.png")); |
| | | pic1.add(picMap1); |
| | | picMap2.put("urlImg"+i,new PictureRenderData(500, 500, path+"\\"+images.get(1))); |
| | | // picMap2.put("urlImg"+i,new PictureRenderData(500, 500, path+"\\0a4ab467-304d-4871-948f-55aa7e820975.png")); |
| | | pic2.add(picMap2); |
| | | picMap3.put("urlImg"+i,new PictureRenderData(500, 500, path+"\\"+images.get(2))); |
| | | pic3.add(picMap3); |
| | | picMap4.put("urlImg"+i,new PictureRenderData(500, 500, path+"\\"+images.get(3))); |
| | | pic4.add(picMap4); |
| | | picMap5.put("urlImg"+i,new PictureRenderData(500, 500, path+"\\"+images.get(4))); |
| | | pic5.add(picMap5); |
| | | picMap6.put("urlImg"+i,new PictureRenderData(500, 500, path+"\\"+images.get(5))); |
| | | pic6.add(picMap6); |
| | | picMap7.put("urlImg"+i,new PictureRenderData(500, 500, path+"\\"+images.get(6))); |
| | | pic7.add(picMap7); |
| | | picMap8.put("urlImg"+i,new PictureRenderData(500, 500, path+"\\"+images.get(7))); |
| | | pic8.add(picMap8); |
| | | i++; |
| | | } |
| | | detailList1.add(dailyVo.getCode()); |
| | | detailList2.add(dailyVo.getCode()); |
| | | detailList3.add(dailyVo.getCode()); |
| | | detailList4.add(dailyVo.getCode()); |
| | | detailList5.add(dailyVo.getCode()); |
| | | detailList6.add(dailyVo.getCode()); |
| | | detailList7.add(dailyVo.getCode()); |
| | | detailList8.add(dailyVo.getCode()); |
| | | |
| | | |
| | | builder.append("("+dailyVo.getCode().get("mac")+")白天对市重点区域(宝龙广场、盐城电厂为主)进行走航监测:常规7参数走航过程中PM\u2082.\u2085均值浓度为"+dailyVo.getCode().get("avgPm25")+"ug/m\u00b3;PM\u2081\u2080均值浓度为"+dailyVo.getCode().get("avgPm10")+"ug/m\u00b3;NO\u2082均值浓度为" |
| | | +dailyVo.getCode().get("avgNO2")+"ug/m\u00b3;CO均值浓度为"+dailyVo.getCode().get("avgCO")+"mg/m\u00b3;SO\u2082均值浓度为"+dailyVo.getCode().get("avgSO2")+"ug/m\u00b3;O\u2083均值浓度为"+dailyVo.getCode().get("avgO3")+"ug/m\u00b3,VOCs均值浓度"+dailyVo.getCode().get("avgVOC")+"mg/m\u00b3。"+"\n"+" "); |
| | | } |
| | | |
| | | if (dailyVos.size()>1){ |
| | | String name = dailyVos.get(0).getName(); |
| | | String type = dailyVos.get(0).getType(); |
| | | map.put("code",builder); |
| | | map.put("time1",DateUtils.getCurCNDate()); |
| | | map.put("name",name); |
| | | map.put("type",type); |
| | | map.put("mac",dailyVos.get(0).getCode().get("mac")); |
| | | map.put("pm25",dailyVos.get(0).getCode().get("avgPm25")); |
| | | map.put("pm10",dailyVos.get(0).getCode().get("avgPm10")); |
| | | map.put("no2",dailyVos.get(0).getCode().get("avgNO2")); |
| | | map.put("co",dailyVos.get(0).getCode().get("avgCO")); |
| | | map.put("so2",dailyVos.get(0).getCode().get("avgSO2")); |
| | | map.put("o3",dailyVos.get(0).getCode().get("avgO3")); |
| | | map.put("VOCs",dailyVos.get(0).getCode().get("avgVOC")); |
| | | map.put("mac2",dailyVos.get(1).getCode().get("mac")); |
| | | map.put("2pm25",dailyVos.get(1).getCode().get("avgPm25")); |
| | | map.put("2pm10",dailyVos.get(1).getCode().get("avgPm10")); |
| | | map.put("2no2",dailyVos.get(1).getCode().get("avgNO2")); |
| | | map.put("2co",dailyVos.get(1).getCode().get("avgCO")); |
| | | map.put("2so2",dailyVos.get(1).getCode().get("avgSO2")); |
| | | map.put("2o3",dailyVos.get(1).getCode().get("avgO3")); |
| | | map.put("2VOCs",dailyVos.get(1).getCode().get("avgVOC")); |
| | | |
| | | |
| | | HackLoopTableRenderPolicy policy = new HackLoopTableRenderPolicy(); |
| | | Configure config = Configure.newBuilder().bind("detailList1", policy).bind("detailList2", policy).bind("detailList3", policy).bind("detailList4", policy) |
| | | .bind("detailList5", policy).bind("detailList6", policy).bind("detailList7", policy).bind("detailList8", policy).build(); |
| | | XWPFTemplate compile = XWPFTemplate.compile(filePath,config).render(new HashMap<String, Object>(){{ |
| | | put("code",map.get("code")); |
| | | put("time1",map.get("time1")); |
| | | put("mac",map.get("mac")); |
| | | put("pm25",map.get("pm25")); |
| | | put("pm10",map.get("pm10")); |
| | | put("no2",map.get("no2")); |
| | | put("co",map.get("co")); |
| | | put("so2",map.get("so2")); |
| | | put("o3",map.get("o3")); |
| | | put("VOCs",map.get("VOCs")); |
| | | put("2pm25",map.get("2pm25")); |
| | | put("2pm10",map.get("2pm10")); |
| | | put("2no2",map.get("2no2")); |
| | | put("2co",map.get("2co")); |
| | | put("2so2",map.get("2so2")); |
| | | put("2o3",map.get("2o3")); |
| | | put("2VOCs",map.get("2VOCs")); |
| | | put("mac2",map.get("mac2")); |
| | | // put("pho", map.get("pho")); |
| | | // put("pho1", map.get("pho1")); |
| | | put("name",map.get("name")); |
| | | put("type",map.get("type")); |
| | | put("detailList1", detailList1); |
| | | put("detailList2", detailList2); |
| | | put("detailList3", detailList3); |
| | | put("detailList4", detailList4); |
| | | put("detailList5", detailList5); |
| | | put("detailList6", detailList6); |
| | | put("detailList7", detailList7); |
| | | put("detailList8", detailList8); |
| | | put("picList1", pic1); |
| | | put("picList2", pic2); |
| | | put("picList3", pic3); |
| | | put("picList4", pic4); |
| | | put("picList5", pic5); |
| | | put("picList6", pic6); |
| | | put("picList7", pic7); |
| | | put("picList8", pic8); |
| | | }}); |
| | | response.setContentType("multipart/form-data"); |
| | | // 设置文件名 |
| | | response.addHeader("Content-Disposition", "attachment;fileName=ce.docx" ); |
| | | // response.setHeader("Content-Disposition", "attachment; filename=\"" + name+type+"监测报告" + "\""); |
| | | response.setCharacterEncoding("UTF-8"); |
| | | //保存到本地 |
| | | /* File file1 = new File("G:\\test\\test2.docx"); |
| | | FileOutputStream out = new FileOutputStream(file1); |
| | | compile.write(out);*/ |
| | | //下载到线上 |
| | | OutputStream out = response.getOutputStream(); |
| | | compile.write(out); |
| | | out.flush(); |
| | | out.close(); |
| | | compile.close(); |
| | | |
| | | }else { |
| | | String name = dailyVos.get(0).getName(); |
| | | String type = dailyVos.get(0).getType(); |
| | | map.put("code",builder); |
| | | map.put("time1",DateUtils.getCurCNDate()); |
| | | map.put("name",name); |
| | | map.put("type",type); |
| | | map.put("mac",dailyVos.get(0).getCode().get("mac")); |
| | | map.put("pm25",dailyVos.get(0).getCode().get("avgPm25")); |
| | | map.put("pm10",dailyVos.get(0).getCode().get("avgPm10")); |
| | | map.put("no2",dailyVos.get(0).getCode().get("avgNO2")); |
| | | map.put("co",dailyVos.get(0).getCode().get("avgCO")); |
| | | map.put("so2",dailyVos.get(0).getCode().get("avgSO2")); |
| | | map.put("o3",dailyVos.get(0).getCode().get("avgO3")); |
| | | map.put("VOCs",dailyVos.get(0).getCode().get("avgVOC")); |
| | | |
| | | HackLoopTableRenderPolicy policy = new HackLoopTableRenderPolicy(); |
| | | Configure config = Configure.newBuilder().bind("detailList1", policy).bind("detailList2", policy).bind("detailList3", policy).bind("detailList4", policy) |
| | | .bind("detailList5", policy).bind("detailList6", policy).bind("detailList7", policy).bind("detailList8", policy).build(); |
| | | XWPFTemplate compile = XWPFTemplate.compile(filePath,config).render(new HashMap<String, Object>(){{ |
| | | put("code",map.get("code")); |
| | | put("time1",map.get("time1")); |
| | | put("mac",map.get("mac")); |
| | | put("pm25",map.get("pm25")); |
| | | put("pm10",map.get("pm10")); |
| | | put("no2",map.get("no2")); |
| | | put("co",map.get("co")); |
| | | put("so2",map.get("so2")); |
| | | put("o3",map.get("o3")); |
| | | put("VOCs",map.get("VOCs")); |
| | | // put("pho", map.get("pho")); |
| | | // put("pho1", map.get("pho1")); |
| | | put("name",map.get("name")); |
| | | put("type",map.get("type")); |
| | | put("detailList1", detailList1); |
| | | put("detailList2", detailList2); |
| | | put("detailList3", detailList3); |
| | | put("detailList4", detailList4); |
| | | put("detailList5", detailList5); |
| | | put("detailList6", detailList6); |
| | | put("detailList7", detailList7); |
| | | put("detailList8", detailList8); |
| | | put("picList1", pic1); |
| | | put("picList2", pic2); |
| | | put("picList3", pic3); |
| | | put("picList4", pic4); |
| | | put("picList5", pic5); |
| | | put("picList6", pic6); |
| | | put("picList7", pic7); |
| | | put("picList8", pic8); |
| | | }}); |
| | | response.setContentType("multipart/form-data"); |
| | | // 设置文件名 |
| | | response.addHeader("Content-Disposition", "attachment;fileName=ce.docx" ); |
| | | // response.setHeader("Content-Disposition", "attachment; filename=\"" + name+type+"监测报告" + "\""); |
| | | response.setCharacterEncoding("UTF-8"); |
| | | //保存到本地 |
| | | /* File file1 = new File("G:\\test\\test2.docx"); |
| | | FileOutputStream out = new FileOutputStream(file1); |
| | | compile.write(out);*/ |
| | | //下载到线上 |
| | | OutputStream out = response.getOutputStream(); |
| | | compile.write(out); |
| | | out.flush(); |
| | | out.close(); |
| | | compile.close(); |
| | | |
| | | } |
| | | |
| | | |
| | | } catch (IOException e) { |
| | | log.error ("导出失败,请联系网站管理员!", e); |
| | | } catch (Exception e) { |
| | | throw new RuntimeException(e); |
| | | } |
| | | |
| | | } |
| | | |
| | | } |