fix:走航日报补充提交

jinpengyong

2024-04-10 f58ecce62bc5ecad8e8a862b7b0ad590005cfc7e

fix:走航日报补充提交

 screen-api/src/main/java/com/moral/api/controller/CruiserController.java

@@ -406,11 +406,14 @@
        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("word/盐城市走航监测报告.docx");
            InputStream stream = WordUtil.class.getClassLoader().getResourceAsStream(name1);
            //获取临时文件
            File file = new File("word/盐城市走航监测报告.docx");
            File file = new File(name1);
            //将读取到的类容存储到临时文件中，后面就可以用这个临时文件访问了
            FileUtils.copyInputStreamToFile(stream, file);
            //这个时候再去获取证书的文件路径 就可以正常获取了
@@ -488,85 +491,166 @@
                detailList6.add(dailyVo.getCode());
                detailList7.add(dailyVo.getCode());
                detailList8.add(dailyVo.getCode());
                builder.append("("+dailyVo.getCode().get("mac")+")白天对市重点区域（宝龙广场、盐城电厂为主）进行走航监测：常规7参数走航过程中PM2.5均值浓度为"+dailyVo.getCode().get("avgPm25")+"ug/m3；PM10均值浓度为"+dailyVo.getCode().get("avgPm10")+"ug/m3；NO2均值浓度为"
                        +dailyVo.getCode().get("avgNO2")+"ug/m3；CO均值浓度为"+dailyVo.getCode().get("avgCO")+"mg/m3；SO2均值浓度为"+dailyVo.getCode().get("avgSO2")+"ug/m3；O3均值浓度为"+dailyVo.getCode().get("avgO3")+"ug/m3，VOCs均值浓度"+dailyVo.getCode().get("avgVOC")+"mg/m3。"+"\n"+"    ");


                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"+"    ");
            }
/*            for (HashMap<String, Object> list : lists) {
                detailList1.add(list);
                detailList2.add(list);
                detailList3.add(list);
                detailList4.add(list);
                detailList5.add(list);
                detailList6.add(list);
                detailList7.add(list);
                detailList8.add(list);
            builder.append("("+list.get("mac")+")白天对市重点区域（宝龙广场、盐城电厂为主）进行走航监测：常规7参数走航过程中PM2.5均值浓度为"+list.get("avgPm25")+"ug/m3；PM10均值浓度为"+list.get("avgPm10")+"ug/m3；NO2均值浓度为"
                    +list.get("avgNO2")+"ug/m3；CO均值浓度为"+list.get("avgCO")+"mg/m3；SO2均值浓度为"+list.get("avgSO2")+"ug/m3；O3均值浓度为"+list.get("avgO3")+"ug/m3，VOCs均值浓度"+list.get("avgVOC")+"mg/m3。"+"\n"+"    ");
            }*/
/*            List<Map> pic = new ArrayList<>();
            for (MultipartFile multipartFile : files) {
                Map picMap = new HashMap();
                InputStream inputStream = multipartFile.getInputStream();
                picMap.put("urlImg", Pictures.ofStream(inputStream, PictureType.JPEG).size(500, 500).create());
                pic.add(picMap);
            }*/

            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"));


            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("pho",new PictureRenderData(100, 100, "G:\\home\\3d423e3cb05d7edc35c38e3173af2a0d.jpg"));
//            map.put("pho1",new PictureRenderData(500, 500, path+"\\0a4ab467-304d-4871-948f-55aa7e820975.png"));

            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"));
                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" );
                    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");
            //保存到本地
                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();
                //下载到线上
                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) {

 screen-api/src/main/java/com/moral/api/service/impl/SpecialDeviceServiceImpl.java

@@ -476,7 +476,7 @@
            map.put("time",join);
            dailyVo.setCode(map);
            dailyVo.setName(areaByCode.getAreaName());
            dailyVo.setType(tbDaily.getType().equals("car")?"走航车":"无人机");
            dailyVo.setType(tbDaily.getType().equals("car")?"走航":"无人机");
            dailyVos.add(dailyVo);
        }
        return dailyVos;

 screen-api/src/main/resources/word/?????????.docx

Binary files differ

 screen-api/src/main/resources/word/?????????2.docx

Binary files differ