2025-07-03

zhaowenxuan

昨天 dedacd79c93f8ef95e0cb986f5e7fbd27ddbd907

 ltkj-admin/src/main/java/com/ltkj/web/controller/system/TjReportController.java

@@ -39,6 +39,7 @@
import io.swagger.annotations.Api;
import io.swagger.annotations.ApiOperation;
import io.swagger.annotations.ApiParam;
import jodd.util.StringUtil;
import lombok.extern.slf4j.Slf4j;
import org.springframework.beans.factory.annotation.Value;
import org.springframework.beans.factory.annotation.Autowired;
@@ -81,8 +82,8 @@
    private IDictCompService dictCompService;
    @Resource
    private ITjReportTemplateService reportTemplateService;
    @Value("${path.filePath}")
    private String value;
//    @Value("${path.filePath}")
//    private String value;
    @Value("${path.reportServer}")
    private String urlValue;
    @Resource
@@ -106,24 +107,29 @@
    private IDictHospService dictHospService;
    @Autowired
    private ITjReportPrintService printService;
    @Autowired
    private TjOrderYcxmService ycxmService;

    @GetMapping("/savePdf")
    @ApiOperation(value = "从本地存储模板到数据库")
    public AjaxResult savePdf() {
        //从文件地址读入PDF文件  仅存储一次
        String base64String = PDFBinaryUtil.getPDFBinary(configService.selectConfigByKey("default_pdf5Template"));
        reportTemplateService.remove(new LambdaQueryWrapper<TjReportTemplate>().eq(TjReportTemplate::getName,"体检报告模板5"));
        TjReportTemplate tem = new TjReportTemplate();
        tem.setName("体检报告模板5");
        tem.setRemark("体检报告模板5");
        tem.setTemplate(base64String);
        tem.setFlag("1");
        tem.setOpen("0");
        tem.setCreateTime(DateUtil.date());
        final boolean save = reportTemplateService.save(tem);
        if (save) {
            return AjaxResult.success("保存成功");
        if(StringUtil.isNotBlank(base64String)){
            reportTemplateService.remove(new LambdaQueryWrapper<TjReportTemplate>().eq(TjReportTemplate::getName,"体检报告模板5"));
            TjReportTemplate tem = new TjReportTemplate();
            tem.setName("体检报告模板5");
            tem.setRemark("体检报告模板5");
            tem.setTemplate(base64String);
            tem.setFlag("1");
            tem.setOpen("0");
            tem.setCreateTime(DateUtil.date());
            final boolean save = reportTemplateService.save(tem);
            if (save) {
                return AjaxResult.success("保存成功");
            }
        }

        return AjaxResult.success("保存失败");
//        String base64String2 = PDFBinaryUtil.getPDFBinary("D:\\Tjreport\\心电图1.pdf");
//        TjReport tem2 = new TjReport();
@@ -277,7 +283,7 @@

    @GetMapping("/toPdf/{TjNumber}")
    @ApiOperation(value = "打印体检报告为pdf")
    @Transactional
//    @Transactional
    public AjaxResult toPdf(@PathVariable("TjNumber") @ApiParam(value = "体检号") String tjNumber) {
        //        AjaxResult error = null;
        // 之前的代码 优化速度
@@ -383,19 +389,19 @@
                    tjOrderService.update(updateWrapper);
                    return AjaxResult.success("已生成报告！可直接点击预览！");
                }
                String hisRegistrationId = tjOrder.getCardId();
                Date createTime = tjOrder.getCreateTime();
                SimpleDateFormat dateFormat = new SimpleDateFormat("yyyy-MM-dd HH:mm:ss");
                String ksrq = dateFormat.format(createTime);
                String jsrq = dateFormat.format(new Date());
                HashMap<String, Object> params = new HashMap<>();
                params.put("his_registration_id", hisRegistrationId);
                params.put("ksbm", "");
                params.put("pationid", "");
                params.put("ksrq", ksrq);
                params.put("jsrq", jsrq);
                params.put("pagecount", 100);
                params.put("page", 1);
//                String hisRegistrationId = tjOrder.getCardId();
//                Date createTime = tjOrder.getCreateTime();
//                SimpleDateFormat dateFormat = new SimpleDateFormat("yyyy-MM-dd HH:mm:ss");
//                String ksrq = dateFormat.format(createTime);
//                String jsrq = dateFormat.format(new Date());
//                HashMap<String, Object> params = new HashMap<>();
//                params.put("his_registration_id", hisRegistrationId);
//                params.put("ksbm", "");
//                params.put("pationid", "");
//                params.put("ksrq", ksrq);
//                params.put("jsrq", jsrq);
//                params.put("pagecount", 100);
//                params.put("page", 1);
                LambdaQueryWrapper<TjCustomer> wq1 = new LambdaQueryWrapper<>();
                wq1.eq(TjCustomer::getCusId, tjOrder.getUserId());
                TjCustomer tjCustomer = tjCustomerService.getOne(wq1);
@@ -406,15 +412,15 @@
                try {
                    return shengchengbgmoban(tjNumber, tjOrder, tjCustomer, reportTemplate,zongJianYiShiQianMing);
                } catch (Exception e) {
                    TransactionAspectSupport.currentTransactionStatus().setRollbackOnly();
                    log.error(String.valueOf(e));
//                    TransactionAspectSupport.currentTransactionStatus().setRollbackOnly();
                    log.error("生成报告失败："+e.getMessage(),String.valueOf(e));
                    tjOrder.setReportTime(null);
                    tjOrder.setCheckTime(null);
                    tjOrder.setCheckStatus(0);
                    tjOrder.setPrintLastTime(null);
                    tjOrderService.updateById(tjOrder);

                    logger.error("生成报告异常");
//                    logger.error(String.valueOf(e));
                    return AjaxResult.error("生成报告失败");
                }
            } else {
@@ -424,8 +430,9 @@
        return AjaxResult.error();
    }

    public AjaxResult shengchengbgmoban(String tjNumber, TjOrder tjOrder, TjCustomer tjCustomer, TjReportTemplate reportTemplate,TjReportTemplate zongJianYiShiQianMing) {
    public AjaxResult shengchengbgmoban(String tjNumber, TjOrder tjOrder, TjCustomer tjCustomer, TjReportTemplate reportTemplate,TjReportTemplate zongJianYiShiQianMing) throws Exception {
        AjaxResult ajaxResult = null;
        String value = configService.selectConfigByKey("path_filePath");
        try {
//            ajaxResult = hisPDFUtil.hisPDF(tjOrder, tjCustomer, reportTemplate);
//            ajaxResult = hisPDFUtil.hisPDFNew(tjOrder, tjCustomer, reportTemplate);
@@ -434,9 +441,11 @@
        } catch (Exception e) {
            e.printStackTrace();
            log.error(String.valueOf(e));
            throw new Exception(e);
        }
        if (!ajaxResult.get("code").toString().equals("200")) {
            TransactionAspectSupport.currentTransactionStatus().setRollbackOnly();
//            TransactionAspectSupport.currentTransactionStatus().setRollbackOnly();
            return AjaxResult.error("生成报告失败");
        } else {
            Long userId = tjCustomer.getCusId();
            String outputFileName1 = userId + tjNumber + tjCustomer.getCusName() + "_报告.pdf";
@@ -444,8 +453,8 @@
            tjReport.setTjNumber(String.valueOf(tjNumber));
            tjReport.setPath(urlValue + outputFileName1);
            String outputPath1 = value + File.separator;
            String pdfBinary = getPDFBinary(outputPath1 + outputFileName1);
            tjReport.setReport(pdfBinary);
//            String pdfBinary = getPDFBinary(outputPath1 + outputFileName1);
//            tjReport.setReport(pdfBinary);
            tjReport.setType("体检报告");
            tjReport.setPrint("pdf");
            tjReportService.save(tjReport);
@@ -487,6 +496,7 @@
    }

    private AjaxResult newFun(String tjNumber) {
        String value = configService.selectConfigByKey("path_filePath");
        long startTime = System.currentTimeMillis();
        int num = tjOrderRemarkService.getTjYqOrderRemarkByTjNum(tjNumber);
        if (num > 0) {
@@ -980,481 +990,482 @@
        return byteArrayOutputStream;
    }

    private AjaxResult oldFun(String tjNumber) {
        DictHosp dictHosp = dictHospService.list().get(0);
        long startTime = System.currentTimeMillis();
        int num = tjOrderRemarkService.getTjYqOrderRemarkByTjNum(tjNumber);
        if (num > 0) return AjaxResult.error("有延期项目暂不能生成报告!!!");
        LambdaQueryWrapper<TjOrder> wq = new LambdaQueryWrapper<>();
        wq.eq(TjOrder::getTjNumber, tjNumber);
        TjOrder tjOrder = tjOrderService.getOne(wq);

        if (null != tjOrder) {
            LambdaQueryWrapper<TjReportTemplate> tjReportTemplateLambdaQueryWrapper = new LambdaQueryWrapper<>();
            TjReportTemplate reportTemplate = null;
            if (tjOrder.getTjCategory() != null) {
                //查询字典
                LambdaQueryWrapper<SysDictData> wqq = new LambdaQueryWrapper<>();
                wqq.eq(SysDictData::getDictType, "dict_tjtype");
                wqq.eq(SysDictData::getDictValue, tjOrder.getTjCategory());
                SysDictData one = dictDataService.getOne(wqq);
                if (one != null) {
                    //查询字典
                    LambdaQueryWrapper<SysDictData> wqq1 = new LambdaQueryWrapper<>();
                    wqq1.eq(SysDictData::getDictType, "report_template_type");
                    wqq1.eq(SysDictData::getDictLabel, one.getDictLabel());
                    SysDictData one1 = dictDataService.getOne(wqq1);
                    if (one1 != null) {
                        tjReportTemplateLambdaQueryWrapper.eq(TjReportTemplate::getFlag, one1.getDictValue());
                    } else {
                        tjReportTemplateLambdaQueryWrapper.eq(TjReportTemplate::getFlag, 1);
                    }
                } else {
                    tjReportTemplateLambdaQueryWrapper.eq(TjReportTemplate::getFlag, 1);
                }
                tjReportTemplateLambdaQueryWrapper.eq(TjReportTemplate::getOpen, 0);
                reportTemplate = reportTemplateService.getOne(tjReportTemplateLambdaQueryWrapper);
            } else {
                tjReportTemplateLambdaQueryWrapper.eq(TjReportTemplate::getOpen, 0);
                reportTemplate = reportTemplateService.list(tjReportTemplateLambdaQueryWrapper).get(2);
            }


            //判断表中有没有该体检报告  不能重复生成
            LambdaQueryWrapper<TjReport> wqa = new LambdaQueryWrapper<>();
            wqa.eq(TjReport::getTjNumber, tjNumber);
            wqa.eq(TjReport::getType, "体检报告");
            List<TjReport> list2 = tjReportService.list(wqa);
            if (list2.size() != 0) {
                return AjaxResult.error("该客户报告已生成！不能重复生成！可直接预览或打印！");
            }


            Integer checkStatus = tjOrder.getCheckStatus();
            if (checkStatus == 1) {
                //判断报告生成 保存类型 2024/2/29
                if ("报表".equals(reportTemplate.getPrint())) {
                    TjReport tjReport = new TjReport();
                    tjReport.setTjNumber(String.valueOf(tjNumber));
                    tjReport.setPath(reportTemplate.getUrl() + "?tjNum=" + tjNumber);
                    tjReport.setType("体检报告");
                    tjReport.setPrint("报表");
                    tjReportService.save(tjReport);
                    //修改order表中的打印报告时间为当前时间
                    LambdaUpdateWrapper<TjOrder> updateWrapper = new LambdaUpdateWrapper<>();
                    updateWrapper.eq(TjOrder::getTjNumber, tjNumber);
                    updateWrapper.set(TjOrder::getReportTime, new Date());
                    updateWrapper.set(TjOrder::getPrintLastTime, new Date());
                    updateWrapper.set(TjOrder::getDownloadLastTime, new Date());
                    updateWrapper.set(TjOrder::getStatus, TjConstants.TJ_END);
                    tjOrderService.update(updateWrapper);
                    return AjaxResult.success("已生成报告！可直接点击预览！");
                }


                String template = reportTemplate.getTemplate();
                String userId = SecurityUtils.getLoginUser().getUsername();
                if (template != null) {
                    PDFBinaryUtil.base64StringToPDF(template, FileUtil.mkdir(value).getPath() + File.separator + userId + "体检报告封面模板.pdf");
                }
                // --------以上-------  根据数据库中的模板二进制文件  转pdf  创建文件夹  将pdf放进本地文件夹


                LambdaQueryWrapper<TjCustomer> wq1 = new LambdaQueryWrapper<>();
                wq1.eq(TjCustomer::getCusId, tjOrder.getUserId());
                TjCustomer tjCustomer = tjCustomerService.getOne(wq1);
                LambdaQueryWrapper<DictComp> wq111 = new LambdaQueryWrapper<>();
                wq111.eq(DictComp::getDrugManufacturerId, tjOrder.getFirmId());
                DictComp dictComp = dictCompService.getOne(wq111);
                LambdaQueryWrapper<TjOrderDetail> wq2 = new LambdaQueryWrapper<>();
                wq2.eq(TjOrderDetail::getOrderId, tjOrder.getOrderId());
                //20230306判断该项目是否退费/缴费
                wq2.isNotNull(TjOrderDetail::getFlowingWaterId);
                //20230323判断该项目是否弃检/未检
//                wq2.eq(TjOrderDetail::getTjStatus,1);
                List<TjOrderDetail> list = tjOrderDetailService.list(wq2);
                for (TjOrderDetail tjOrderDetail : list) {
                    TjProject tjProject = projectService.selectTjProjectByProId(tjOrderDetail.getProId());
                    tjOrderDetail.setProject(tjProject);
                }

                String inputFileName = value + File.separator + userId + "体检报告封面模板.pdf";
                String outputFileName = value + File.separator + userId + "体检报告封面页.pdf";
                OutputStream os = null;
                PdfStamper ps = null;
                PdfReader reader = null;
                File file = new File(outputFileName);
                try {
                    os = Files.newOutputStream(file.toPath());
                    // 读入pdf表单
                    reader = new PdfReader(inputFileName);
                    // 根据表单生成一个新的pdf
                    ps = new PdfStamper(reader, os);
                    // 获取pdf表单
                    AcroFields form = ps.getAcroFields();
                    //该字体造成类型不均匀，但是pdf转图片不乱码
                    //BaseFont bf = BaseFont.createFont("C:Windows\\Fonts\\simfang.ttf", BaseFont.IDENTITY_H, BaseFont.EMBEDDED);
                    BaseFont bf = BaseFont.createFont("STSong-Light", "UniGB-UCS2-H", BaseFont.NOT_EMBEDDED);
                    form.addSubstitutionFont(bf);

                    // 填充数据给表格
                    Map<String, Object> data = new HashMap<>();

                    //填充性别：判断男女
                    Long cusSex = tjCustomer.getCusSex();
                    String sex;
                    String name1;
                    String tjtype;
                    if (cusSex == 0) {
                        sex = "男";
                        name1 = tjCustomer.getCusName() + "先生";
                    } else {
                        sex = "女";
                        name1 = tjCustomer.getCusName() + "女士";
                    }
                    data.put("name", tjCustomer.getCusName());
                    data.put("cusId", tjCustomer.getCusId());
                    data.put("name1", name1);
                    if ("1".equals(tjOrder.getTjType())) {
                        tjtype = "团队";
                        data.put("tjtype", tjtype);
                    } else {
                        tjtype = "个人";
                        data.put("tjtype", tjtype);
                    }
                    data.put("dstype", "统一");
                    data.put("sex", sex);
                    data.put("age", DateUtil.ageOfNow(tjCustomer.getCusBrithday()));
                    data.put("tjnumber", tjNumber);
                    data.put("tjdate", DateUtils.parseDateToStr("yyyy/MM/dd", tjOrder.getCreateTime()));
                    data.put("phone", tjCustomer.getCusPhone());
                    data.put("idcard", MatchUtils.hideIdCardNum(tjCustomer.getCusIdcard()));
                    data.put("num1", list.size());
                    data.put("num2", 0);
                    data.put("num3", 4);
                    if (dictComp == null) {
                        data.put("work", "无");
                    } else {
                        data.put("work", dictComp.getCnName());
                    }
                    //封面页下面的总检建议显示
                    if (tjOrder.getCheckAdvice() == null) {
                        data.put("remark", "无");
                    } else {
                        data.put("remark", tjOrder.getCheckAdvice());
                    }
                    //封面页下面的总检建议显示
                    if (tjOrder.getCheckDoctor() == null) {
                        data.put("docname", "无");
                    } else {
                        data.put("docname", tjOrder.getCheckDoctor());
                    }
                    //异常项目
//                    data.put("yichang", "【1】屈光不正\n" +
//                            "【2】扁桃体肥⼤\n" +
//                            "【3】体重指数增⾼\n" +
//                            "【4】⾎脂异常（总胆固醇增⾼；⽢油三酯增⾼）\n" +
//                            "【5】γ-⾕氨酰转移酶增⾼；天⻔冬氨酸氨基转移酶增⾼；丙氨酸氨基转移酶增⾼\n" +
//                            "【6】轻⾄中度脂肪肝");

                    //拼接重大阳性结果
                    StringBuffer str = new StringBuffer();
                    str.append("【重大阳性项目】\n");
                    LambdaQueryWrapper<TjBigPositive> bigPositiveLambdaQueryWrapper = new LambdaQueryWrapper<>();
                    bigPositiveLambdaQueryWrapper.eq(TjBigPositive::getTjNumber, tjNumber);
                    final List<TjBigPositive> list1 = tjBigPositiveService.list(bigPositiveLambdaQueryWrapper);
                    if (list1 != null && list1.size() > 0) {
                        for (int i = 0; i < list1.size(); i++) {
                            str.append((i + 1) + "、" + list1.get(i).getProName() + ";\n");
                        }
                    } else {
                        str.append("    无；\n");
                    }
                    //拼接异常项目
                    str.append("【异常情况项目】\n");
                    if (list.size() > 0) {
                        for (int i = 0; i < list.size(); i++) {
                            if (list.get(i).getExceptionDesc() == 1) {
                                str.append((i + 1) + "、" + projectService.getById(list.get(i).getProId()).getProName() + ";\n");
                            }
                        }
                    } else {
                        str.append("    无；\n");
                    }

                    //异常项目
                    data.put("yichang", str.toString());

                    // 遍历data 给pdf表单表格赋值
                    for (String key : data.keySet()) {
                        form.setField(key, data.get(key).toString());
                    }
                    //设置为无法编辑
                    ps.setFormFlattening(true);
                    ps.close();
                    os.close();
                    reader.close();

                    //====================================以上封面页，以下详情页
                    //文档对象  实现A4纸页面
                    Document document = new Document(PageSize.A4);
                    //document.setMarginMirroring(true);
                    //设置文档的页边距就是距离页面边上的距离，分别为：左边距，右边距，上边距，下边距
                    document.setMargins(70, 70, 40, 40);
                    //生成pdf的位置以及名称
                    String fileName = value + File.separator + userId + tjNumber + "体检报告项目详情页.pdf";
                    OutputStream outputStream = Files.newOutputStream(Paths.get(fileName));
                    PdfWriter pdfWriter = PdfWriter.getInstance(document, outputStream);

                    //pdfWriter.setPageEvent(new MyHeaderFooter());// 页眉页脚

                    document.open();

                    document.add(new Header("健康体检结果", "健康体检结果"));


                    Map<TjOrderRemark, List<TjPdfVO>> tjOrderRemarkObjectMap = addTable(tjNumber);
                    Map<TjOrderRemark, List<TjPdfVO>> tjOrderRemarkListMap = addHuaYanTable(tjNumber);
                    tjOrderRemarkObjectMap.putAll(tjOrderRemarkListMap);
                    for (Map.Entry<TjOrderRemark, List<TjPdfVO>> entry : tjOrderRemarkObjectMap.entrySet()) {
                        List<TjPdfVO> value = entry.getValue();
                        LambdaQueryWrapper<TjProject> wqqq = new LambdaQueryWrapper<>();
                        wqqq.eq(TjProject::getProId, entry.getKey().getProId());
                        TjProject one11 = projectService.getOne(wqqq);
                        //判断该项目是否需要打印报告
                        if (null != one11 && "N".equals(one11.getNeedReport())) {
                            continue;
                        }
                        String titleName = null;
                        if (null != one11 && "1".equals(one11.getResultType())) {
                            titleName = one11.getProName();
                            // 设置标题字体样式
                            Font titleFonts = PdfUtils.setFont(9);
                            Paragraph paragraph = PdfUtils.setParagraph(titleFonts, titleName);

                            String[] titles = {"体检项目", "体检结果"};
                            // 获取列表数据
                            //设置表头字体样式
                            Font headFont = PdfUtils.setFont(9);
                            // 设置正文字体样式：12号
                            Font textFont = PdfUtils.setFont(9);
                            //创建表格  将表头字体和正文字体放进去
                            PdfPTable table = PdfUtils.setTable1(headFont, textFont, titles, value);
                            document.add(paragraph);
                            document.add(table);

                            //判断备注是否为空  空不能显示null
                            if (entry.getKey().getRemark() == null) {
                                entry.getKey().setRemark("");
                            }

                            String remark = "备注：" + entry.getKey().getRemark();
                            if (entry.getKey().getRemark().length() > 50) {
                                int j = 0;
                                for (int i = 0; i < remark.length() / 50; i++) {
                                    String substring = remark.substring(j, j + 50);
                                    Font remarkFonts = PdfUtils.setFont(9);
                                    Paragraph pp = PdfUtils.setParagraph(remarkFonts, substring);
                                    document.add(pp);
                                    j = j + 50;
                                }
                                if (remark.length() % 50 != 0) {
                                    String substring = remark.substring((remark.length() / 50) * 50, remark.length() - 1);
                                    Font remarkFonts = PdfUtils.setFont(9);
                                    Paragraph pp = PdfUtils.setParagraph(remarkFonts, substring);
                                    document.add(pp);
                                }
                            } else {
                                Font remarkFonts = PdfUtils.setFont(9);
                                Paragraph pp = PdfUtils.setParagraph(remarkFonts, remark);
                                document.add(pp);
                            }

                            //判断主检医师是否为空  空不能显示null
                            if (null != entry.getKey().getDoctorName() && null != userService.getById(entry.getKey().getDoctorName())) {
                                //主检医师
                                String doctorName = "主检医师：" + userService.getById(entry.getKey().getDoctorName()).getNickName();
                                Font doctorFonts = PdfUtils.setFont(9);
                                Paragraph df = PdfUtils.setParagraph(doctorFonts, doctorName);
                                df.setAlignment(Element.ALIGN_RIGHT);
                                document.add(df);
                            } else {
                                String doctorName = "主检医师：" + "无";
                                Font doctorFonts = PdfUtils.setFont(9);
                                Paragraph df = PdfUtils.setParagraph(doctorFonts, doctorName);
                                df.setAlignment(Element.ALIGN_RIGHT);
                                document.add(df);

                            }

                            //分割线
                            LineSeparator objectName = new LineSeparator();
                            document.add(objectName);
                        } else {
                            if (null != one11) {
                                titleName = one11.getProName();
                            } else {
                                titleName = entry.getKey().getProName();
                            }

                            // 设置标题字体样式
                            Font titleFonts = PdfUtils.setFont(9);
                            Paragraph paragraph = PdfUtils.setParagraph(titleFonts, titleName);

                            String[] titles = {"体检项目", "体检结果", "单位", "参考范围"};
                            // 获取列表数据
                            //设置表头字体样式
                            Font headFont = PdfUtils.setFont(9);
                            // 设置正文字体样式：12号
                            Font textFont = PdfUtils.setFont(9);
                            //创建表格  将表头字体和正文字体放进去
                            PdfPTable table = PdfUtils.setTable(headFont, textFont, titles, value,dictHosp.equals("澄合矿务局中心医院"));
                            document.add(paragraph);
                            document.add(table);

                            //判断备注是否为空  空不能显示null
                            if (entry.getKey().getRemark() == null) {
                                entry.getKey().setRemark("");
                            }

                            String remark = "备注：" + entry.getKey().getRemark();
                            if (entry.getKey().getRemark().length() > 50) {
                                int j = 0;
                                for (int i = 0; i < remark.length() / 50; i++) {
                                    String substring = remark.substring(j, j + 50);
                                    Font remarkFonts = PdfUtils.setFont(9);
                                    Paragraph pp = PdfUtils.setParagraph(remarkFonts, substring);
                                    document.add(pp);
                                    j = j + 50;
                                }
                                if (remark.length() % 50 != 0) {
                                    String substring = remark.substring((remark.length() / 50) * 50, remark.length() - 1);
                                    Font remarkFonts = PdfUtils.setFont(9);
                                    Paragraph pp = PdfUtils.setParagraph(remarkFonts, substring);
                                    document.add(pp);
                                }
                            } else {
                                Font remarkFonts = PdfUtils.setFont(9);
                                Paragraph pp = PdfUtils.setParagraph(remarkFonts, remark);
                                document.add(pp);
                            }

                            //判断主检医师是否为空  空不能显示null
                            if (null != entry.getKey().getDoctorName() && null != userService.getById(entry.getKey().getDoctorName())) {
                                //主检医师
                                String doctorName = "主检医师：" + userService.getById(entry.getKey().getDoctorName()).getNickName();
                                Font doctorFonts = PdfUtils.setFont(9);
                                Paragraph df = PdfUtils.setParagraph(doctorFonts, doctorName);
                                df.setAlignment(Element.ALIGN_RIGHT);
                                document.add(df);
                            } else {
                                String doctorName = "主检医师：" + "无";
                                Font doctorFonts = PdfUtils.setFont(9);
                                Paragraph df = PdfUtils.setParagraph(doctorFonts, doctorName);
                                df.setAlignment(Element.ALIGN_RIGHT);
                                document.add(df);
                            }
                            //分割线
                            LineSeparator objectName = new LineSeparator();
                            document.add(objectName);
                        }
                    }
                    document.close();
                    pdfWriter.close();
                    outputStream.close();

//                    LambdaQueryWrapper<TjReport> rtwq1 = new LambdaQueryWrapper<>();
//                    rtwq1.eq(TjReport::getType, "医学名词");
////                    rtwq1.eq(TjReport::getTjNumber, tjNumber);
//                    TjReport one11111 = tjReportService.getOne(rtwq1);
//                    if(null !=one11111){
//                        String report1 = one11111.getReport();
//                        PDFBinaryUtil.base64StringToPDF(report1, FileUtil.mkdir(value).getPath() + File.separator + userId + "医学名词.pdf");
//    private AjaxResult oldFun(String tjNumber) {
//        String value = configService.selectConfigByKey("path_filePath");
//        DictHosp dictHosp = dictHospService.list().get(0);
//        long startTime = System.currentTimeMillis();
//        int num = tjOrderRemarkService.getTjYqOrderRemarkByTjNum(tjNumber);
//        if (num > 0) return AjaxResult.error("有延期项目暂不能生成报告!!!");
//        LambdaQueryWrapper<TjOrder> wq = new LambdaQueryWrapper<>();
//        wq.eq(TjOrder::getTjNumber, tjNumber);
//        TjOrder tjOrder = tjOrderService.getOne(wq);
//
//        if (null != tjOrder) {
//            LambdaQueryWrapper<TjReportTemplate> tjReportTemplateLambdaQueryWrapper = new LambdaQueryWrapper<>();
//            TjReportTemplate reportTemplate = null;
//            if (tjOrder.getTjCategory() != null) {
//                //查询字典
//                LambdaQueryWrapper<SysDictData> wqq = new LambdaQueryWrapper<>();
//                wqq.eq(SysDictData::getDictType, "dict_tjtype");
//                wqq.eq(SysDictData::getDictValue, tjOrder.getTjCategory());
//                SysDictData one = dictDataService.getOne(wqq);
//                if (one != null) {
//                    //查询字典
//                    LambdaQueryWrapper<SysDictData> wqq1 = new LambdaQueryWrapper<>();
//                    wqq1.eq(SysDictData::getDictType, "report_template_type");
//                    wqq1.eq(SysDictData::getDictLabel, one.getDictLabel());
//                    SysDictData one1 = dictDataService.getOne(wqq1);
//                    if (one1 != null) {
//                        tjReportTemplateLambdaQueryWrapper.eq(TjReportTemplate::getFlag, one1.getDictValue());
//                    } else {
//                        tjReportTemplateLambdaQueryWrapper.eq(TjReportTemplate::getFlag, 1);
//                    }

                    LambdaQueryWrapper<TjReport> rtwq = new LambdaQueryWrapper<>();
                    rtwq.eq(TjReport::getType, "心电图");
                    rtwq.eq(TjReport::getTjNumber, tjNumber);
                    TjReport one1111 = tjReportService.getOne(rtwq);
                    if (null != one1111) {
                        String report = one1111.getReport();
                        PDFBinaryUtil.base64StringToPDF(report, FileUtil.mkdir(value).getPath() + File.separator + tjNumber + userId + "心电图.pdf");
                    }

                    LambdaQueryWrapper<TjReport> rtwq12 = new LambdaQueryWrapper<>();
                    rtwq12.eq(TjReport::getType, "附件");
                    rtwq12.eq(TjReport::getTjNumber, tjNumber);
                    TjReport one111112 = tjReportService.getOne(rtwq12);
                    if (null != one111112) {
                        String report12 = one111112.getReport();
                        PDFBinaryUtil.base64StringToPDF(report12, FileUtil.mkdir(value).getPath() + File.separator + tjNumber + userId + "附件.pdf");
                    }

                    //合并
                    String[] files1 = null;
                    if (one1111 != null) {
                        if (one111112 != null) {
                            files1 = new String[]{value + File.separator + userId + "体检报告封面页.pdf", value + File.separator + userId + tjNumber + "体检报告项目详情页.pdf", value + File.separator + tjNumber + userId + "附件.pdf", value + File.separator + tjNumber + userId + "心电图.pdf"};
                        } else {
                            files1 = new String[]{value + File.separator + userId + "体检报告封面页.pdf", value + File.separator + userId + tjNumber + "体检报告项目详情页.pdf", value + File.separator + tjNumber + userId + "心电图.pdf"};
                        }
                    } else {
                        if (one111112 != null) {
                            files1 = new String[]{value + File.separator + userId + "体检报告封面页.pdf", value + File.separator + userId + tjNumber + "体检报告项目详情页.pdf", value + File.separator + tjNumber + userId + "附件.pdf"};
                        } else {
                            files1 = new String[]{value + File.separator + userId + "体检报告封面页.pdf", value + File.separator + userId + tjNumber + "体检报告项目详情页.pdf"};
                        }
                    }
                    //合并
//                    String[] files1 = {value + File.separator + userId + "体检报告封面页.pdf", value + File.separator + userId + tjNumber+"体检报告项目详情页.pdf", value + File.separator +tjNumber+ userId + "附件.pdf", value + File.separator + tjNumber + userId + "心电图.pdf"};
                    String outputPath1 = value + File.separator;
                    String outputFileName1 = userId + tjNumber + tjCustomer.getCusName() + "_体检报告.pdf";

                    File file1 = new File(outputPath1 + outputFileName1);
                    List<File> f = new ArrayList<>();
                    for (String s : files1) {
                        f.add(new File(s));
                    }
                    MergePdf.mergeFileToPDF(f, file1);

                    TjReport tjReport = new TjReport();
                    tjReport.setTjNumber(String.valueOf(tjNumber));
                    tjReport.setPath(urlValue + outputFileName1);
                    String pdfBinary = getPDFBinary(outputPath1 + outputFileName1);
                    tjReport.setReport(pdfBinary);
                    tjReport.setType("体检报告");
                    tjReport.setPrint("pdf");
                    tjReportService.save(tjReport);

                    //FileUtil.del(value + File.separator + tjNumber + "体检报告.pdf");
                    //FileUtil.del(value + File.separator + userId + "体检报告封面模板.pdf");
                    //FileUtil.del(value + File.separator + userId +tjNumber+ "体检报告项目详情页.pdf");
                    //FileUtil.del(value + File.separator + userId + "体检报告封面页.pdf");
                    //FileUtil.del(value + File.separator + userId + "心电图.pdf");


                    //修改order表中的打印报告时间为当前时间
                    LambdaUpdateWrapper<TjOrder> updateWrapper = new LambdaUpdateWrapper<>();
                    updateWrapper.eq(TjOrder::getTjNumber, tjNumber);
                    updateWrapper.set(TjOrder::getReportTime, new Date());
                    updateWrapper.set(TjOrder::getPrintLastTime, new Date());
                    updateWrapper.set(TjOrder::getDownloadLastTime, new Date());
                    updateWrapper.set(TjOrder::getStatus, TjConstants.TJ_END);
                    tjOrderService.update(updateWrapper);
                    long entTime = System.currentTimeMillis();
                    System.out.println(entTime - startTime + "ms");
                    return AjaxResult.success("已生成报告！可直接点击预览！");

                } catch (Exception e) {
                    e.printStackTrace();
                    return AjaxResult.success("PDF导出失败");
                } finally {
//                    transitionService.deletedTbTransitionListByCusIdAndTjNum(tjCustomer.getCusIdcard(), tjOrder.getCardId());
                }
            }
        }
        return null;
    }
//                } else {
//                    tjReportTemplateLambdaQueryWrapper.eq(TjReportTemplate::getFlag, 1);
//                }
//                tjReportTemplateLambdaQueryWrapper.eq(TjReportTemplate::getOpen, 0);
//                reportTemplate = reportTemplateService.getOne(tjReportTemplateLambdaQueryWrapper);
//            } else {
//                tjReportTemplateLambdaQueryWrapper.eq(TjReportTemplate::getOpen, 0);
//                reportTemplate = reportTemplateService.list(tjReportTemplateLambdaQueryWrapper).get(2);
//            }
//
//
//            //判断表中有没有该体检报告  不能重复生成
//            LambdaQueryWrapper<TjReport> wqa = new LambdaQueryWrapper<>();
//            wqa.eq(TjReport::getTjNumber, tjNumber);
//            wqa.eq(TjReport::getType, "体检报告");
//            List<TjReport> list2 = tjReportService.list(wqa);
//            if (list2.size() != 0) {
//                return AjaxResult.error("该客户报告已生成！不能重复生成！可直接预览或打印！");
//            }
//
//
//            Integer checkStatus = tjOrder.getCheckStatus();
//            if (checkStatus == 1) {
//                //判断报告生成 保存类型 2024/2/29
//                if ("报表".equals(reportTemplate.getPrint())) {
//                    TjReport tjReport = new TjReport();
//                    tjReport.setTjNumber(String.valueOf(tjNumber));
//                    tjReport.setPath(reportTemplate.getUrl() + "?tjNum=" + tjNumber);
//                    tjReport.setType("体检报告");
//                    tjReport.setPrint("报表");
//                    tjReportService.save(tjReport);
//                    //修改order表中的打印报告时间为当前时间
//                    LambdaUpdateWrapper<TjOrder> updateWrapper = new LambdaUpdateWrapper<>();
//                    updateWrapper.eq(TjOrder::getTjNumber, tjNumber);
//                    updateWrapper.set(TjOrder::getReportTime, new Date());
//                    updateWrapper.set(TjOrder::getPrintLastTime, new Date());
//                    updateWrapper.set(TjOrder::getDownloadLastTime, new Date());
//                    updateWrapper.set(TjOrder::getStatus, TjConstants.TJ_END);
//                    tjOrderService.update(updateWrapper);
//                    return AjaxResult.success("已生成报告！可直接点击预览！");
//                }
//
//
//                String template = reportTemplate.getTemplate();
//                String userId = SecurityUtils.getLoginUser().getUsername();
//                if (template != null) {
//                    PDFBinaryUtil.base64StringToPDF(template, FileUtil.mkdir(value).getPath() + File.separator + userId + "体检报告封面模板.pdf");
//                }
//                // --------以上-------  根据数据库中的模板二进制文件  转pdf  创建文件夹  将pdf放进本地文件夹
//
//
//                LambdaQueryWrapper<TjCustomer> wq1 = new LambdaQueryWrapper<>();
//                wq1.eq(TjCustomer::getCusId, tjOrder.getUserId());
//                TjCustomer tjCustomer = tjCustomerService.getOne(wq1);
//                LambdaQueryWrapper<DictComp> wq111 = new LambdaQueryWrapper<>();
//                wq111.eq(DictComp::getDrugManufacturerId, tjOrder.getFirmId());
//                DictComp dictComp = dictCompService.getOne(wq111);
//                LambdaQueryWrapper<TjOrderDetail> wq2 = new LambdaQueryWrapper<>();
//                wq2.eq(TjOrderDetail::getOrderId, tjOrder.getOrderId());
//                //20230306判断该项目是否退费/缴费
//                wq2.isNotNull(TjOrderDetail::getFlowingWaterId);
//                //20230323判断该项目是否弃检/未检
////                wq2.eq(TjOrderDetail::getTjStatus,1);
//                List<TjOrderDetail> list = tjOrderDetailService.list(wq2);
//                for (TjOrderDetail tjOrderDetail : list) {
//                    TjProject tjProject = projectService.selectTjProjectByProId(tjOrderDetail.getProId());
//                    tjOrderDetail.setProject(tjProject);
//                }
//
//                String inputFileName = value + File.separator + userId + "体检报告封面模板.pdf";
//                String outputFileName = value + File.separator + userId + "体检报告封面页.pdf";
//                OutputStream os = null;
//                PdfStamper ps = null;
//                PdfReader reader = null;
//                File file = new File(outputFileName);
//                try {
//                    os = Files.newOutputStream(file.toPath());
//                    // 读入pdf表单
//                    reader = new PdfReader(inputFileName);
//                    // 根据表单生成一个新的pdf
//                    ps = new PdfStamper(reader, os);
//                    // 获取pdf表单
//                    AcroFields form = ps.getAcroFields();
//                    //该字体造成类型不均匀，但是pdf转图片不乱码
//                    //BaseFont bf = BaseFont.createFont("C:Windows\\Fonts\\simfang.ttf", BaseFont.IDENTITY_H, BaseFont.EMBEDDED);
//                    BaseFont bf = BaseFont.createFont("STSong-Light", "UniGB-UCS2-H", BaseFont.NOT_EMBEDDED);
//                    form.addSubstitutionFont(bf);
//
//                    // 填充数据给表格
//                    Map<String, Object> data = new HashMap<>();
//
//                    //填充性别：判断男女
//                    Long cusSex = tjCustomer.getCusSex();
//                    String sex;
//                    String name1;
//                    String tjtype;
//                    if (cusSex == 0) {
//                        sex = "男";
//                        name1 = tjCustomer.getCusName() + "先生";
//                    } else {
//                        sex = "女";
//                        name1 = tjCustomer.getCusName() + "女士";
//                    }
//                    data.put("name", tjCustomer.getCusName());
//                    data.put("cusId", tjCustomer.getCusId());
//                    data.put("name1", name1);
//                    if ("1".equals(tjOrder.getTjType())) {
//                        tjtype = "团队";
//                        data.put("tjtype", tjtype);
//                    } else {
//                        tjtype = "个人";
//                        data.put("tjtype", tjtype);
//                    }
//                    data.put("dstype", "统一");
//                    data.put("sex", sex);
//                    data.put("age", DateUtil.ageOfNow(tjCustomer.getCusBrithday()));
//                    data.put("tjnumber", tjNumber);
//                    data.put("tjdate", DateUtils.parseDateToStr("yyyy/MM/dd", tjOrder.getCreateTime()));
//                    data.put("phone", tjCustomer.getCusPhone());
//                    data.put("idcard", MatchUtils.hideIdCardNum(tjCustomer.getCusIdcard()));
//                    data.put("num1", list.size());
//                    data.put("num2", 0);
//                    data.put("num3", 4);
//                    if (dictComp == null) {
//                        data.put("work", "无");
//                    } else {
//                        data.put("work", dictComp.getCnName());
//                    }
//                    //封面页下面的总检建议显示
//                    if (tjOrder.getCheckAdvice() == null) {
//                        data.put("remark", "无");
//                    } else {
//                        data.put("remark", tjOrder.getCheckAdvice());
//                    }
//                    //封面页下面的总检建议显示
//                    if (tjOrder.getCheckDoctor() == null) {
//                        data.put("docname", "无");
//                    } else {
//                        data.put("docname", tjOrder.getCheckDoctor());
//                    }
//                    //异常项目
////                    data.put("yichang", "【1】屈光不正\n" +
////                            "【2】扁桃体肥⼤\n" +
////                            "【3】体重指数增⾼\n" +
////                            "【4】⾎脂异常（总胆固醇增⾼；⽢油三酯增⾼）\n" +
////                            "【5】γ-⾕氨酰转移酶增⾼；天⻔冬氨酸氨基转移酶增⾼；丙氨酸氨基转移酶增⾼\n" +
////                            "【6】轻⾄中度脂肪肝");
//
//                    //拼接重大阳性结果
//                    StringBuffer str = new StringBuffer();
//                    str.append("【重大阳性项目】\n");
//                    LambdaQueryWrapper<TjBigPositive> bigPositiveLambdaQueryWrapper = new LambdaQueryWrapper<>();
//                    bigPositiveLambdaQueryWrapper.eq(TjBigPositive::getTjNumber, tjNumber);
//                    final List<TjBigPositive> list1 = tjBigPositiveService.list(bigPositiveLambdaQueryWrapper);
//                    if (list1 != null && list1.size() > 0) {
//                        for (int i = 0; i < list1.size(); i++) {
//                            str.append((i + 1) + "、" + list1.get(i).getProName() + ";\n");
//                        }
//                    } else {
//                        str.append("    无；\n");
//                    }
//                    //拼接异常项目
//                    str.append("【异常情况项目】\n");
//                    if (list.size() > 0) {
//                        for (int i = 0; i < list.size(); i++) {
//                            if (list.get(i).getExceptionDesc() == 1) {
//                                str.append((i + 1) + "、" + projectService.getById(list.get(i).getProId()).getProName() + ";\n");
//                            }
//                        }
//                    } else {
//                        str.append("    无；\n");
//                    }
//
//                    //异常项目
//                    data.put("yichang", str.toString());
//
//                    // 遍历data 给pdf表单表格赋值
//                    for (String key : data.keySet()) {
//                        form.setField(key, data.get(key).toString());
//                    }
//                    //设置为无法编辑
//                    ps.setFormFlattening(true);
//                    ps.close();
//                    os.close();
//                    reader.close();
//
//                    //====================================以上封面页，以下详情页
//                    //文档对象  实现A4纸页面
//                    Document document = new Document(PageSize.A4);
//                    //document.setMarginMirroring(true);
//                    //设置文档的页边距就是距离页面边上的距离，分别为：左边距，右边距，上边距，下边距
//                    document.setMargins(70, 70, 40, 40);
//                    //生成pdf的位置以及名称
//                    String fileName = value + File.separator + userId + tjNumber + "体检报告项目详情页.pdf";
//                    OutputStream outputStream = Files.newOutputStream(Paths.get(fileName));
//                    PdfWriter pdfWriter = PdfWriter.getInstance(document, outputStream);
//
//                    //pdfWriter.setPageEvent(new MyHeaderFooter());// 页眉页脚
//
//                    document.open();
//
//                    document.add(new Header("健康体检结果", "健康体检结果"));
//
//
//                    Map<TjOrderRemark, List<TjPdfVO>> tjOrderRemarkObjectMap = addTable(tjNumber);
//                    Map<TjOrderRemark, List<TjPdfVO>> tjOrderRemarkListMap = addHuaYanTable(tjNumber);
//                    tjOrderRemarkObjectMap.putAll(tjOrderRemarkListMap);
//                    for (Map.Entry<TjOrderRemark, List<TjPdfVO>> entry : tjOrderRemarkObjectMap.entrySet()) {
//                        List<TjPdfVO> value = entry.getValue();
//                        LambdaQueryWrapper<TjProject> wqqq = new LambdaQueryWrapper<>();
//                        wqqq.eq(TjProject::getProId, entry.getKey().getProId());
//                        TjProject one11 = projectService.getOne(wqqq);
//                        //判断该项目是否需要打印报告
//                        if (null != one11 && "N".equals(one11.getNeedReport())) {
//                            continue;
//                        }
//                        String titleName = null;
//                        if (null != one11 && "1".equals(one11.getResultType())) {
//                            titleName = one11.getProName();
//                            // 设置标题字体样式
//                            Font titleFonts = PdfUtils.setFont(9);
//                            Paragraph paragraph = PdfUtils.setParagraph(titleFonts, titleName);
//
//                            String[] titles = {"体检项目", "体检结果"};
//                            // 获取列表数据
//                            //设置表头字体样式
//                            Font headFont = PdfUtils.setFont(9);
//                            // 设置正文字体样式：12号
//                            Font textFont = PdfUtils.setFont(9);
//                            //创建表格  将表头字体和正文字体放进去
//                            PdfPTable table = PdfUtils.setTable1(headFont, textFont, titles, value);
//                            document.add(paragraph);
//                            document.add(table);
//
//                            //判断备注是否为空  空不能显示null
//                            if (entry.getKey().getRemark() == null) {
//                                entry.getKey().setRemark("");
//                            }
//
//                            String remark = "备注：" + entry.getKey().getRemark();
//                            if (entry.getKey().getRemark().length() > 50) {
//                                int j = 0;
//                                for (int i = 0; i < remark.length() / 50; i++) {
//                                    String substring = remark.substring(j, j + 50);
//                                    Font remarkFonts = PdfUtils.setFont(9);
//                                    Paragraph pp = PdfUtils.setParagraph(remarkFonts, substring);
//                                    document.add(pp);
//                                    j = j + 50;
//                                }
//                                if (remark.length() % 50 != 0) {
//                                    String substring = remark.substring((remark.length() / 50) * 50, remark.length() - 1);
//                                    Font remarkFonts = PdfUtils.setFont(9);
//                                    Paragraph pp = PdfUtils.setParagraph(remarkFonts, substring);
//                                    document.add(pp);
//                                }
//                            } else {
//                                Font remarkFonts = PdfUtils.setFont(9);
//                                Paragraph pp = PdfUtils.setParagraph(remarkFonts, remark);
//                                document.add(pp);
//                            }
//
//                            //判断主检医师是否为空  空不能显示null
//                            if (null != entry.getKey().getDoctorName() && null != userService.getById(entry.getKey().getDoctorName())) {
//                                //主检医师
//                                String doctorName = "主检医师：" + userService.getById(entry.getKey().getDoctorName()).getNickName();
//                                Font doctorFonts = PdfUtils.setFont(9);
//                                Paragraph df = PdfUtils.setParagraph(doctorFonts, doctorName);
//                                df.setAlignment(Element.ALIGN_RIGHT);
//                                document.add(df);
//                            } else {
//                                String doctorName = "主检医师：" + "无";
//                                Font doctorFonts = PdfUtils.setFont(9);
//                                Paragraph df = PdfUtils.setParagraph(doctorFonts, doctorName);
//                                df.setAlignment(Element.ALIGN_RIGHT);
//                                document.add(df);
//
//                            }
//
//                            //分割线
//                            LineSeparator objectName = new LineSeparator();
//                            document.add(objectName);
//                        } else {
//                            if (null != one11) {
//                                titleName = one11.getProName();
//                            } else {
//                                titleName = entry.getKey().getProName();
//                            }
//
//                            // 设置标题字体样式
//                            Font titleFonts = PdfUtils.setFont(9);
//                            Paragraph paragraph = PdfUtils.setParagraph(titleFonts, titleName);
//
//                            String[] titles = {"体检项目", "体检结果", "单位", "参考范围"};
//                            // 获取列表数据
//                            //设置表头字体样式
//                            Font headFont = PdfUtils.setFont(9);
//                            // 设置正文字体样式：12号
//                            Font textFont = PdfUtils.setFont(9);
//                            //创建表格  将表头字体和正文字体放进去
//                            PdfPTable table = PdfUtils.setTable(headFont, textFont, titles, value,dictHosp.equals("澄合矿务局中心医院"));
//                            document.add(paragraph);
//                            document.add(table);
//
//                            //判断备注是否为空  空不能显示null
//                            if (entry.getKey().getRemark() == null) {
//                                entry.getKey().setRemark("");
//                            }
//
//                            String remark = "备注：" + entry.getKey().getRemark();
//                            if (entry.getKey().getRemark().length() > 50) {
//                                int j = 0;
//                                for (int i = 0; i < remark.length() / 50; i++) {
//                                    String substring = remark.substring(j, j + 50);
//                                    Font remarkFonts = PdfUtils.setFont(9);
//                                    Paragraph pp = PdfUtils.setParagraph(remarkFonts, substring);
//                                    document.add(pp);
//                                    j = j + 50;
//                                }
//                                if (remark.length() % 50 != 0) {
//                                    String substring = remark.substring((remark.length() / 50) * 50, remark.length() - 1);
//                                    Font remarkFonts = PdfUtils.setFont(9);
//                                    Paragraph pp = PdfUtils.setParagraph(remarkFonts, substring);
//                                    document.add(pp);
//                                }
//                            } else {
//                                Font remarkFonts = PdfUtils.setFont(9);
//                                Paragraph pp = PdfUtils.setParagraph(remarkFonts, remark);
//                                document.add(pp);
//                            }
//
//                            //判断主检医师是否为空  空不能显示null
//                            if (null != entry.getKey().getDoctorName() && null != userService.getById(entry.getKey().getDoctorName())) {
//                                //主检医师
//                                String doctorName = "主检医师：" + userService.getById(entry.getKey().getDoctorName()).getNickName();
//                                Font doctorFonts = PdfUtils.setFont(9);
//                                Paragraph df = PdfUtils.setParagraph(doctorFonts, doctorName);
//                                df.setAlignment(Element.ALIGN_RIGHT);
//                                document.add(df);
//                            } else {
//                                String doctorName = "主检医师：" + "无";
//                                Font doctorFonts = PdfUtils.setFont(9);
//                                Paragraph df = PdfUtils.setParagraph(doctorFonts, doctorName);
//                                df.setAlignment(Element.ALIGN_RIGHT);
//                                document.add(df);
//                            }
//                            //分割线
//                            LineSeparator objectName = new LineSeparator();
//                            document.add(objectName);
//                        }
//                    }
//                    document.close();
//                    pdfWriter.close();
//                    outputStream.close();
//
////                    LambdaQueryWrapper<TjReport> rtwq1 = new LambdaQueryWrapper<>();
////                    rtwq1.eq(TjReport::getType, "医学名词");
//////                    rtwq1.eq(TjReport::getTjNumber, tjNumber);
////                    TjReport one11111 = tjReportService.getOne(rtwq1);
////                    if(null !=one11111){
////                        String report1 = one11111.getReport();
////                        PDFBinaryUtil.base64StringToPDF(report1, FileUtil.mkdir(value).getPath() + File.separator + userId + "医学名词.pdf");
////                    }
//
//                    LambdaQueryWrapper<TjReport> rtwq = new LambdaQueryWrapper<>();
//                    rtwq.eq(TjReport::getType, "心电图");
//                    rtwq.eq(TjReport::getTjNumber, tjNumber);
//                    TjReport one1111 = tjReportService.getOne(rtwq);
//                    if (null != one1111) {
//                        String report = one1111.getReport();
//                        PDFBinaryUtil.base64StringToPDF(report, FileUtil.mkdir(value).getPath() + File.separator + tjNumber + userId + "心电图.pdf");
//                    }
//
//                    LambdaQueryWrapper<TjReport> rtwq12 = new LambdaQueryWrapper<>();
//                    rtwq12.eq(TjReport::getType, "附件");
//                    rtwq12.eq(TjReport::getTjNumber, tjNumber);
//                    TjReport one111112 = tjReportService.getOne(rtwq12);
//                    if (null != one111112) {
//                        String report12 = one111112.getReport();
//                        PDFBinaryUtil.base64StringToPDF(report12, FileUtil.mkdir(value).getPath() + File.separator + tjNumber + userId + "附件.pdf");
//                    }
//
//                    //合并
//                    String[] files1 = null;
//                    if (one1111 != null) {
//                        if (one111112 != null) {
//                            files1 = new String[]{value + File.separator + userId + "体检报告封面页.pdf", value + File.separator + userId + tjNumber + "体检报告项目详情页.pdf", value + File.separator + tjNumber + userId + "附件.pdf", value + File.separator + tjNumber + userId + "心电图.pdf"};
//                        } else {
//                            files1 = new String[]{value + File.separator + userId + "体检报告封面页.pdf", value + File.separator + userId + tjNumber + "体检报告项目详情页.pdf", value + File.separator + tjNumber + userId + "心电图.pdf"};
//                        }
//                    } else {
//                        if (one111112 != null) {
//                            files1 = new String[]{value + File.separator + userId + "体检报告封面页.pdf", value + File.separator + userId + tjNumber + "体检报告项目详情页.pdf", value + File.separator + tjNumber + userId + "附件.pdf"};
//                        } else {
//                            files1 = new String[]{value + File.separator + userId + "体检报告封面页.pdf", value + File.separator + userId + tjNumber + "体检报告项目详情页.pdf"};
//                        }
//                    }
//                    //合并
////                    String[] files1 = {value + File.separator + userId + "体检报告封面页.pdf", value + File.separator + userId + tjNumber+"体检报告项目详情页.pdf", value + File.separator +tjNumber+ userId + "附件.pdf", value + File.separator + tjNumber + userId + "心电图.pdf"};
//                    String outputPath1 = value + File.separator;
//                    String outputFileName1 = userId + tjNumber + tjCustomer.getCusName() + "_体检报告.pdf";
//
//                    File file1 = new File(outputPath1 + outputFileName1);
//                    List<File> f = new ArrayList<>();
//                    for (String s : files1) {
//                        f.add(new File(s));
//                    }
//                    MergePdf.mergeFileToPDF(f, file1);
//
//                    TjReport tjReport = new TjReport();
//                    tjReport.setTjNumber(String.valueOf(tjNumber));
//                    tjReport.setPath(urlValue + outputFileName1);
//                    String pdfBinary = getPDFBinary(outputPath1 + outputFileName1);
//                    tjReport.setReport(pdfBinary);
//                    tjReport.setType("体检报告");
//                    tjReport.setPrint("pdf");
//                    tjReportService.save(tjReport);
//
//                    //FileUtil.del(value + File.separator + tjNumber + "体检报告.pdf");
//                    //FileUtil.del(value + File.separator + userId + "体检报告封面模板.pdf");
//                    //FileUtil.del(value + File.separator + userId +tjNumber+ "体检报告项目详情页.pdf");
//                    //FileUtil.del(value + File.separator + userId + "体检报告封面页.pdf");
//                    //FileUtil.del(value + File.separator + userId + "心电图.pdf");
//
//
//                    //修改order表中的打印报告时间为当前时间
//                    LambdaUpdateWrapper<TjOrder> updateWrapper = new LambdaUpdateWrapper<>();
//                    updateWrapper.eq(TjOrder::getTjNumber, tjNumber);
//                    updateWrapper.set(TjOrder::getReportTime, new Date());
//                    updateWrapper.set(TjOrder::getPrintLastTime, new Date());
//                    updateWrapper.set(TjOrder::getDownloadLastTime, new Date());
//                    updateWrapper.set(TjOrder::getStatus, TjConstants.TJ_END);
//                    tjOrderService.update(updateWrapper);
//                    long entTime = System.currentTimeMillis();
//                    System.out.println(entTime - startTime + "ms");
//                    return AjaxResult.success("已生成报告！可直接点击预览！");
//
//                } catch (Exception e) {
//                    e.printStackTrace();
//                    return AjaxResult.success("PDF导出失败");
//                } finally {
////                    transitionService.deletedTbTransitionListByCusIdAndTjNum(tjCustomer.getCusIdcard(), tjOrder.getCardId());
//                }
//            }
//        }
//        return null;
//    }


    //非化验项目报告
@@ -1709,7 +1720,7 @@
        we.eq(TjReport::getType, "体检报告");
        TjReport one = tjReportService.getOne(we);
        if (one == null) {
            return AjaxResult.error("暂无体检报告");
            return AjaxResult.error("暂无体检报告,请撤回到总检未审核页面,需总检医生重新审核并生成报告!");
        }
        if ("pdf".equals(one.getPrint())) {
            res.put("flag", "0");
@@ -1719,7 +1730,7 @@
            res.put("url", one.getPath());
            return AjaxResult.success(res);
        } else {
            return AjaxResult.error("暂无体检报告");
            return AjaxResult.error("暂无体检报告,请撤回到总检未审核页面,需总检医生重新审核并生成报告!");
        }

    }
@@ -1730,21 +1741,18 @@
    public void preview(HttpServletResponse response, @PathVariable("flag") boolean flag, @PathVariable("TjNumber") String tjNumber) {
        TjOrder tjOrder = tjOrderService.getOrderByTjNum(tjNumber);
        TjCustomer tjCustomer = tjCustomerService.getById( tjOrder.getUserId());
        LambdaQueryWrapper<TjReport> we = new LambdaQueryWrapper<>();
        we.eq(TjReport::getTjNumber, tjNumber);
        we.eq(TjReport::getType, "体检报告");
        TjReport one = tjReportService.getOne(we);
        if (one == null) {
            return;
        }
        String userId = SecurityUtils.getLoginUser().getUsername();
        PDFBinaryUtil.base64StringToPDF(one.getReport(), FileUtil.mkdir(value).getPath() + File.separator + userId + tjNumber + tjCustomer.getCusName() + "_体检报告.pdf");
        String filePath = value + File.separator + userId + tjNumber + tjCustomer.getCusName() + "_体检报告.pdf";
//        LambdaQueryWrapper<TjReport> we = new LambdaQueryWrapper<>();
//        we.eq(TjReport::getTjNumber, tjNumber);
//        we.eq(TjReport::getType, "体检报告");
//        TjReport one = tjReportService.getOne(we);
//        if (one == null) {
//            return;
//        }
//        String userId = SecurityUtils.getLoginUser().getUsername();
//        PDFBinaryUtil.base64StringToPDF(one.getReport(), FileUtil.mkdir(value).getPath() + File.separator + userId + tjNumber + tjCustomer.getCusName() + "_体检报告.pdf");
        String value = configService.selectConfigByKey("path_filePath");
        String filePath = value + File.separator + tjCustomer.getCusId() + tjNumber + tjCustomer.getCusName() + "_报告.pdf";
        File f = new File(filePath);
        if (filePath.isEmpty()) {
            System.out.println("文件不存在！");
            return;
        }
        BufferedInputStream br = null;
        OutputStream out = null;
        FileInputStream fileInputStream = null;
@@ -1761,13 +1769,13 @@
                String contentType = u.openConnection().getContentType();
                response.setContentType(contentType);
                response.setHeader("Content-Disposition", "inline;filename="
                        + userId + tjNumber + ".pdf");
                        + tjCustomer.getCusId() + tjNumber + ".pdf");
            } else {
                // 纯下载方式
                response.setContentType("application/x-msdownload");
                response.setContentType("application/pdf;charset=utf-8");
                response.setHeader("Content-Disposition", "attachment;filename="
                        + userId + tjNumber + ".pdf");
                        + tjCustomer.getCusId() + tjNumber + ".pdf");
            }
            out = response.getOutputStream();
            while ((len = br.read(bs)) > 0) {
@@ -1805,6 +1813,33 @@
        }
    }


//    @GetMapping("/previewBase64/{flag}/{TjNumber}")
//    @ApiOperation(value = "下载体检报告Base64")
    public String previewBase64( @PathVariable("TjNumber") String tjNumber) {
        try {
            TjOrder tjOrder = tjOrderService.getOrderByTjNum(tjNumber);
            TjCustomer tjCustomer = tjCustomerService.getById( tjOrder.getUserId());
            String value = configService.selectConfigByKey("path_filePath");
            String filePath = value + File.separator + tjCustomer.getCusId() + tjNumber + tjCustomer.getCusName() + "_报告.pdf";
            File f = new File(filePath);
            //            System.out.println("Base64: " + base64);
            return fileToBase64(f);
        } catch (IOException e) {
            log.error(e.toString());
            throw new RuntimeException(e);
        }
    }

    public static String fileToBase64(File file) throws IOException {
        try (FileInputStream fileInputStream = new FileInputStream(file)) {
            byte[] fileBytes = new byte[(int) file.length()];
            fileInputStream.read(fileBytes);
            return Base64.getEncoder().encodeToString(fileBytes);
        }
    }


    @GetMapping("/previewprint/{flag}/{TjNumber}/{sfdy}")
    @ApiOperation(value = "下载体检报告")
    public void previewprint(HttpServletResponse response, @PathVariable("flag") boolean flag, @PathVariable("TjNumber") String tjNumber,@PathVariable("sfdy") String sfdy) {
@@ -1814,17 +1849,19 @@

        TjCustomer tjCustomer = tjCustomerService.getById( tjOrder.getUserId());

        LambdaQueryWrapper<TjReport> we = new LambdaQueryWrapper<>();
        we.eq(TjReport::getTjNumber, tjNumber);
        we.eq(TjReport::getType, "体检报告");
        TjReport one = tjReportService.getOne(we);
        if (one == null) {
            return;
        }

        String userId = SecurityUtils.getLoginUser().getUsername();
        PDFBinaryUtil.base64StringToPDF(one.getReport(), FileUtil.mkdir(value).getPath() + File.separator + userId + tjNumber + tjCustomer.getCusName() + "_体检报告.pdf");
        String filePath = value + File.separator + userId + tjNumber + tjCustomer.getCusName() + "_体检报告.pdf";
//        LambdaQueryWrapper<TjReport> we = new LambdaQueryWrapper<>();
//        we.eq(TjReport::getTjNumber, tjNumber);
//        we.eq(TjReport::getType, "体检报告");
//        TjReport one = tjReportService.getOne(we);
//        if (one == null) {
//            return;
//        }
//
//        String userId = SecurityUtils.getLoginUser().getUsername();
//        PDFBinaryUtil.base64StringToPDF(one.getReport(), FileUtil.mkdir(value).getPath() + File.separator + userId + tjNumber + tjCustomer.getCusName() + "_体检报告.pdf");
//        String filePath = value + File.separator + userId + tjNumber + tjCustomer.getCusName() + "_体检报告.pdf";
        String value = configService.selectConfigByKey("path_filePath");
        String filePath = value + File.separator + tjCustomer.getCusId() + tjNumber + tjCustomer.getCusName() + "_报告.pdf";
        File f = new File(filePath);
        if (filePath.isEmpty()) {
            System.out.println("文件不存在！");
@@ -1846,13 +1883,13 @@
                String contentType = u.openConnection().getContentType();
                response.setContentType(contentType);
                response.setHeader("Content-Disposition", "inline;filename="
                        + userId + tjNumber + ".pdf");
                        + tjCustomer.getCusId() + tjNumber + ".pdf");
            } else {
                // 纯下载方式
                response.setContentType("application/x-msdownload");
                response.setContentType("application/pdf;charset=utf-8");
                response.setHeader("Content-Disposition", "attachment;filename="
                        + userId + tjNumber + ".pdf");
                        + tjCustomer.getCusId() + tjNumber + ".pdf");
            }
            out = response.getOutputStream();
            while ((len = br.read(bs)) > 0) {
@@ -1897,11 +1934,35 @@
    public AjaxResult preview(@RequestBody String data) {
        String is_batch_report_use_sql = configService.selectConfigByKey("is_batch_report_use_sql");
        List<String> tjNumbers = Arrays.stream(data.split(",")).collect(Collectors.toList());
        String value = configService.selectConfigByKey("path_filePath");
        if ("true".equals(is_batch_report_use_sql)) {
            return tjReportService.makeBatchReport(tjNumbers);
            return tjReportService.makeBatchReport(tjNumbers,value);
        } else {
            return makeReport(tjNumbers);
        }
    }


    @GetMapping("/xiugaidayinzhuangtai")
    @ApiOperation(value = "修改打印状态接口")
    @Transactional
    public AjaxResult xiugaidayinzhuangtai(@RequestParam String tjNumber) {
        TjOrder order = tjOrderService.getOrderByTjNum(tjNumber);
        if(null !=order){
            Date date=new Date();
            TjReportPrint print=new TjReportPrint();
            print.setTjNumber(tjNumber);
            print.setPrintBy(SecurityUtils.getLoginUser().getUser().getNickName());
            print.setPrintTime(date);
            print.setPrintStatus("已打印");
            if (printService.save(print)) {
                order.setPrintLastTime(date);
                order.setStatus(TjConstants.TJ_END);
                tjOrderService.updateById(order);
            }
            return AjaxResult.success();
        }
     return AjaxResult.error();
    }

    /**
@@ -2133,20 +2194,8 @@

    @GetMapping("/revocationReport/{TjNumber}")
    @ApiOperation(value = "撤销生成体检报告")
    @Transactional
    public AjaxResult revocationReport(@PathVariable("TjNumber") String tjNumber) {
        //逻辑删除数据库里的报告
        QueryWrapper<TjReport> wq1 = new QueryWrapper<>();
        wq1.select("re_id");
        wq1.eq("tj_number", tjNumber);
        wq1.eq("type", "体检报告");
        TjReport tjReport = tjReportService.getOne(wq1);
        if (null != tjReport) {
            // 不在使用逻辑删除 逻辑删除导致打印报告生成 查询sql缓慢
            int i = tjReportService.deleteTjReportByReId(tjReport.getReId());
            if (i == 0) {
                return AjaxResult.error("撤回失败！");
            }
        }

        TjOrder one = tjOrderService.getOrderByTjNum(tjNumber);
        if(null !=one){
@@ -2167,10 +2216,25 @@
            one.setPrintLastTime(null);
            one.setDownloadLastTime(null);
            if (tjOrderService.updateById(one)) {

                //逻辑删除数据库里的报告
                QueryWrapper<TjReport> wq1 = new QueryWrapper<>();
                wq1.select("re_id");
                wq1.eq("tj_number", tjNumber);
                wq1.eq("type", "体检报告");
                TjReport tjReport = tjReportService.getOne(wq1);
                if (null != tjReport) {
                    // 不在使用逻辑删除 逻辑删除导致打印报告生成 查询sql缓慢
                    int i = tjReportService.deleteTjReportByReId(tjReport.getReId());
                    if (i == 0) {
                        return AjaxResult.error("暂无体检报告,请撤回到总检未审核页面,需总检医生重新审核并生成报告!");
                    }
                }

                return AjaxResult.success("撤回成功！");
            }
        }
        return AjaxResult.error("撤回失败！");
        return AjaxResult.error("该人员体检记录不存在,请核实人员信息!");

    }

@@ -2220,8 +2284,8 @@
        LambdaQueryWrapper<TjOrder> wq2 = new LambdaQueryWrapper<>();
        wq2.eq(TjOrder::getFirmId, firmId);
        wq2.eq(TjOrder::getFirmDeptId, firmDeptId);
        wq2.eq(TjOrder::getTjType, "1");
        wq2.in(TjOrder::getStatus, 401, 402);
        wq2.ne(TjOrder::getTjType, "2");
//        wq2.in(TjOrder::getStatus, 401, 402);
        final List<TjOrder> list = tjOrderService.list(wq2);

        for (TjOrder tjOrder : list) {
@@ -2580,16 +2644,14 @@

    @GetMapping("/tuanDuiYiChangBySex")
    @ApiOperation(value = "生成团队体检报告——男女异常结果统计")
    public Map<String, List<Map<String, Object>>> tuanDuiYiChangBySex(@ApiParam(value = "单位") @RequestParam String firmId,
                                                                      @ApiParam(value = "部门") @RequestParam String firmDeptId) {
    public Map<String, List<Map<String, Object>>> tuanDuiYiChangBySex(@ApiParam(value = "单位") @RequestParam String dwname) {

        Map<String, List<Map<String, Object>>> all = new HashMap<>();

        LambdaQueryWrapper<TjOrder> wq2 = new LambdaQueryWrapper<>();
        wq2.eq(TjOrder::getFirmId, firmId);
        wq2.eq(TjOrder::getFirmDeptId, firmDeptId);
        wq2.eq(TjOrder::getTjType, "1");
        wq2.in(TjOrder::getStatus, 401, 402);
        wq2.eq(TjOrder::getFirmName,dwname);
        wq2.ne(TjOrder::getTjType, "2");
//        wq2.in(TjOrder::getStatus, 401, 402);
        final List<TjOrder> list = tjOrderService.list(wq2);

        List<String> tjNumberList = list.stream().map(TjOrder::getTjNumber).collect(Collectors.toList());