2024-9-19bug修改

whyclxw

2024-09-19 ef8592668904f629f33c7c1f3e5ec0776f74ebc0

 src/main/java/com/whyc/service/ExcelExportService.java

@@ -4,6 +4,7 @@
import cn.afterturn.easypoi.excel.ExcelExportUtil;
import cn.afterturn.easypoi.excel.entity.TemplateExportParams;
import com.google.common.collect.Maps;
import com.whyc.config.I18nLocaleResolver;
import com.whyc.dto.BattGroupStationInfoWithFileParam;
import com.whyc.dto.Response;
import com.whyc.pojo.BattgroupData;
@@ -44,7 +45,12 @@
    @Autowired
    private TestParamService testParamService;

    @Autowired
    private I18nLocaleResolver i18nLocaleResolver;

    public void resTestReport(BattGroupStationInfoWithFileParam info, HttpServletResponse response) throws IOException {
        Locale local = i18nLocaleResolver.getLocal();
        boolean zhFlag = local.getLanguage().toLowerCase().equals("zh");
        HashMap<String, Object> map = Maps.newHashMap();
        //总体评价:内阻/电压/连接条/?容量
        int resGoodCount = 0;
@@ -95,6 +101,11 @@
            float bv = Float.parseFloat(data.getBv());
            float br = Float.parseFloat(data.getBr());
            float cr = Float.parseFloat(data.getCr());
            //计算容量百分比,并回填到dataList中
            float preCap = MathUtil.getPreCapTest(br, stdRes);
            String preCapStr = NumberFormat.getPercentInstance().format(preCap);
            data.setPreCapPercentStr(preCapStr);

            if (bv!=0.0){
                battVolTestCount++;
            }
@@ -120,14 +131,26 @@
            else if(br >= stdRes*resGoodCoeK3/100){
                if(br >= stdRes*resBadCoeK4/100){
                    // data.setHighResFlag2(true);
                    data.setResEvaluation("差");
                    if(zhFlag) {
                        data.setResEvaluation("差");
                    }else{
                        data.setResEvaluation("bad");
                    }
                }else{
                    // data.setHighResFlag1(true);
                    data.setResEvaluation("良");
                    if(zhFlag) {
                        data.setResEvaluation("良");
                    }else {
                        data.setResEvaluation("good");
                    }
                }
            }else{
                resGoodCount +=1;
                data.setResEvaluation("优");
                if(zhFlag) {
                    data.setResEvaluation("优");
                }else {
                    data.setResEvaluation("excellent");
                }
            }
            /*if(bv!=0.0 && !data.isLowVolFlag() && !data.isHighVolFlag()){
                volGoodCount +=1;
@@ -160,6 +183,7 @@
        }
        map.put("dto", info);
        //图片
        //电压柱状图
        BASE64Decoder decoder = new BASE64Decoder();
        if(!info.getVolPic().equals("")) {
            ImageEntity volImage = new ImageEntity();
@@ -169,6 +193,7 @@

            map.put("volImage",volImage);
        }
        //内阻柱状图
        if(!info.getResPic().equals("")) {
            ImageEntity resImage = new ImageEntity();
            resImage.setData(decoder.decodeBuffer(info.getResPic().substring(info.getResPic().indexOf(",") + 1)));
@@ -177,17 +202,45 @@

            map.put("resImage", resImage);
        }
        //电导柱状图
        if(!info.getCondPic().equals("")) {
            ImageEntity condImage = new ImageEntity();
            condImage.setData(decoder.decodeBuffer(info.getCondPic().substring(info.getCondPic().indexOf(",") + 1)));
            condImage.setColspan(6);
            condImage.setRowspan(16);

            map.put("condImage", condImage);
        }
        //链接条柱状图
        if(!info.getChainPic().equals("")) {
            ImageEntity chainImage = new ImageEntity();
            chainImage.setData(decoder.decodeBuffer(info.getChainPic().substring(info.getChainPic().indexOf(",") + 1)));
            chainImage.setColspan(6);
            chainImage.setRowspan(16);

            map.put("chainImage", chainImage);
        }

        //map.put("volImage","volImage");
        //map.put("resImage","resImage");

        //获取导出模板地址
        ClassPathResource classPathResource = new ClassPathResource("excel_templates/res_test_report_single_template.xls");
        ClassPathResource classPathResource;
        if(zhFlag){
            classPathResource = new ClassPathResource("excel_templates/res_test_report_single_template.xls");
        }else {
            classPathResource = new ClassPathResource("excel_templates/res_test_report_single_template_en.xls");
        }
        String path = classPathResource.getPath();
        TemplateExportParams templateExportParams1 = new TemplateExportParams(path);
        Workbook wb = ExcelExportUtil.exportExcel(templateExportParams1, map);
        String time = LocalDateTime.now().format(DateTimeFormatter.ofPattern("yyyy_MM_dd_HH_mm_ss"));
        String fileName = "内阻计测试"+time+".xls";
        String fileName;
        if(zhFlag) {
            fileName = "内阻计测试" + time + ".xls";
        }else{
            fileName = "Resistance Meter Test Report" + time + ".xls";
        }
        try {
            //response.setContentType("application/octet-stream;charset=utf-8");
            response.setContentType("application/vnd.ms-excel");
@@ -200,16 +253,31 @@
    }

    public void resTestCompareReport(String fileId, String fileId2, BattGroupStationInfoWithFileParam dto, HttpServletResponse response) throws IOException {
        Locale local = i18nLocaleResolver.getLocal();
        boolean zhFlag = local.getLanguage().toLowerCase().equals("zh");
        Map<String,Object> map = new HashMap<>();
        Response comparedList = battGroupDataService.getComparedList(fileId, fileId2);
        List<BattgroupData> dataList = (List<BattgroupData>) comparedList.getData();
        List<BattgroupData> dataList2 = (List<BattgroupData>) comparedList.getData2();
        Map<String,List<String>> data3 = (Map<String, List<String>>) comparedList.getData3();

        int baseSize = dataList.size();
        int size = dataList2.size();
        if(baseSize > size){
            dataList = dataList.subList(0,size);
        }else{
            dataList2 = dataList2.subList(0,baseSize);
        }


        //变化率
        List<String> resChangeRateList = data3.get("resChangeRate");
        List<String> volChangeRateList = data3.get("volChangeRate");
        map.put("resChangeRateList",resChangeRateList.subList(0,resChangeRateList.size()-1));
        map.put("volChangeRateList",volChangeRateList.subList(0,volChangeRateList.size()-1));
        /*map.put("resChangeRateList",resChangeRateList.subList(0,resChangeRateList.size()-1));
        map.put("volChangeRateList",volChangeRateList.subList(0,volChangeRateList.size()-1));*/

        map.put("resChangeRateList",resChangeRateList);
        map.put("volChangeRateList",volChangeRateList);

        map.put("volBalanceRateChangeRate",volChangeRateList.get(volChangeRateList.size()-1));
        map.put("resBalanceRateChangeRate",resChangeRateList.get(resChangeRateList.size()-1));
@@ -291,11 +359,23 @@
            }
            else if(!data.isHighResFlag1() && !data.isHighResFlag2() ){
                resGoodCount +=1;
                data.setResEvaluation("优");
                if(zhFlag) {
                    data.setResEvaluation("优");
                }else {
                    data.setResEvaluation("excellent");
                }
            }else if(data.isHighResFlag1()){
                data.setResEvaluation("良");
                if(zhFlag) {
                    data.setResEvaluation("良");
                }else{
                    data.setResEvaluation("good");
                }
            }else{
                data.setResEvaluation("差");
                if(zhFlag) {
                    data.setResEvaluation("差");
                }else{
                    data.setResEvaluation("bad");
                }
            }
            if(bv!=0.0 && !data.isLowVolFlag() && !data.isHighVolFlag()){
                volGoodCount +=1;
@@ -326,13 +406,23 @@


        //获取导出模板地址
        ClassPathResource classPathResource = new ClassPathResource("excel_templates/res_test_report_compare_template.xls");
        ClassPathResource classPathResource;
        if(zhFlag){
            classPathResource  = new ClassPathResource("excel_templates/res_test_report_compare_template.xls");
        }else{
            classPathResource  = new ClassPathResource("excel_templates/res_test_report_compare_template_en.xls");
        }
        String path = classPathResource.getPath();
        TemplateExportParams templateExportParams1 = new TemplateExportParams(path);
        templateExportParams1.setColForEach(true);
        Workbook wb = ExcelExportUtil.exportExcel(templateExportParams1, map);
        String time = LocalDateTime.now().format(DateTimeFormatter.ofPattern("yyyy_MM_dd_HH_mm_ss"));
        String fileName = "内阻计测试"+time+".xls";
        String fileName;
        if(zhFlag) {
            fileName = "内阻计测试" + time + ".xls";
        }else{
            fileName = "Resistance Meter Test Report" + time + ".xls";
        }
        try {
            //response.setContentType("application/octet-stream;charset=utf-8");
            response.setContentType("application/vnd.ms-excel");