提交一把

jiangping

2024-06-25 545cc3a93547af47080440010c03b70ed7baabdd

 server/service/src/main/java/com/doumee/core/annotation/excel/ExcelExporter.java

@@ -1190,24 +1190,27 @@
            }
            Row header1 = sheet.createRow(1);
            header1.createCell(0).setCellValue("投保人");
            header1.createCell(1).setCellValue("被保险人");
            header1.createCell(2).setCellValue("");
            header1.createCell(3).setCellValue("保险方案");
            header1.createCell(4).setCellValue("保险生效起期");
            header1.createCell(5).setCellValue("保险生效止期");
            header1.createCell(1).setCellValue("");
            header1.createCell(2).setCellValue("被保险人");
            header1.createCell(3).setCellValue("");
            header1.createCell(4).setCellValue("保险方案");
            header1.createCell(5).setCellValue("申请提交日期");
//            header1.createCell(5).setCellValue("保险生效止期");
            for (int i = 0; i < 6; i++) {
                configFirstCell(sxssfWorkbook,header1.getCell(i));
            }
            sheet.addMergedRegion(new CellRangeAddress(1  ,1,1,2));
            sheet.addMergedRegion(new CellRangeAddress(1  ,1,0,1));
            sheet.addMergedRegion(new CellRangeAddress(1  ,1,2,3));

            Row header2 = sheet.createRow(2);
            header2.createCell(0).setCellValue(insuranceApply.getShopName());
            header2.createCell(1).setCellValue(insuranceApply.getCompanyName());
            header2.createCell(2).setCellValue(insuranceApply.getInsureNum());
            header2.createCell(3).setCellValue(insuranceApply.getSolutionsName());
            header2.createCell(4).setCellValue(com.doumee.core.utils.DateUtil.getPlusTime2(insuranceApply.getStartTime()));
            header2.createCell(5).setCellValue(com.doumee.core.utils.DateUtil.getPlusTime2(insuranceApply.getEndTime()));
            sheet.addMergedRegion(new CellRangeAddress(2  ,2,1,2));
            header2.createCell(1).setCellValue("");
            header2.createCell(2).setCellValue(insuranceApply.getCompanyName());
            header2.createCell(3).setCellValue("");
            header2.createCell(4).setCellValue(insuranceApply.getSolutionsName());
            header2.createCell(5).setCellValue(com.doumee.core.utils.DateUtil.getPlusTime2(insuranceApply.getCreateDate()));
            sheet.addMergedRegion(new CellRangeAddress(2  ,2,0,1));
            sheet.addMergedRegion(new CellRangeAddress(2  ,2,2,3));
            for (int i = 0; i < 6; i++) {
                configDataCell(sxssfWorkbook,header2.getCell(i));
            }