zjh20250121

zjh

2025-01-21 7caeae303d4a93d0af2dc2d2f546987dd192be3c

zjh20250121

 ltkj-admin/src/main/java/com/ltkj/web/controller/his/HisPDFUtil.java

@@ -2,6 +2,7 @@

import cn.hutool.core.date.DateUtil;
import cn.hutool.core.util.StrUtil;
import cn.hutool.json.JSONArray;
import cn.hutool.json.JSONObject;
import cn.hutool.json.JSONUtil;
import com.baomidou.mybatisplus.core.conditions.query.LambdaQueryWrapper;
@@ -115,6 +116,8 @@
    private SysDeptController sysDeptController;
    @Autowired
    private ITjProAdvicerulesService tjProAdvicerulesService;
    @Autowired
    private TjOrderYcxmService ycxmService;

    private Integer pdfPage = 0;

@@ -308,7 +311,6 @@
        if (StrUtil.isBlank(sex)) sex = "未知";



        // 生成 document2 并将其内容保存到 byteArrayOutputStream2 中
        ByteArrayOutputStream byteArrayOutputStream2 = new ByteArrayOutputStream();
        Document document2 = new Document(PageSize.A4);
@@ -386,7 +388,6 @@
//        List<Map<String, Object>> jiancha = new ArrayList<>();



        paragraph = PdfUtils.setParagraph(defaultTitleFont, "检查综述：");
        paragraph.setSpacingBefore(3f);
        paragraph.setSpacingAfter(2f);
@@ -458,19 +459,11 @@
        }






        paragraph = PdfUtils.setParagraph(defaultFont, "");
        paragraph.setLeading(0f);
        paragraph.setSpacingBefore(10f);
        paragraph.setSpacingAfter(10f);
        document2.add(paragraph);






        paragraph = PdfUtils.setParagraph(defaultTitleFont, "医生建议：");
@@ -528,7 +521,8 @@
//                                paragraph.setAlignment(Element.ALIGN_LEFT);
//                                document2.add(paragraph);
                                String content1 = str+objectMap.get("bt").toString().trim()+objectMap.get("nr").toString().trim();
                                if (StrUtil.isBlank(content1)) content1 = "     本报告仅对本次检查负责，临床医生依据病情如有疑问，请及时复查或进一步检查";
                            if (StrUtil.isBlank(content1))
                                content1 = "     本报告仅对本次检查负责，临床医生依据病情如有疑问，请及时复查或进一步检查";

                                paragraph = new Paragraph(content1,defaultFont);
                                paragraph.setAlignment(Element.ALIGN_LEFT);
@@ -577,7 +571,8 @@
                        builder.append("    (").append(index1).append(")").append(s).append("\n");
                        index1++;
                    }
                    if (!contains) builder.append("    (").append(index1).append(")").append("本报告仅对本次检查负责，临床医生依据病情如有疑问，请及时复查或进一步检查");
                    if (!contains)
                        builder.append("    (").append(index1).append(")").append("本报告仅对本次检查负责，临床医生依据病情如有疑问，请及时复查或进一步检查");
                    else builder.substring(0,builder.length() - 1);
                    result = builder.toString();
                }
@@ -592,7 +587,8 @@
                List<Map<String, Object>> maps = tjRulesService.getyichangxiangmujianyiguize(entry.getKey().toString(),"","",tjOrder.getTjNumber(),detail.getProName(),"");
                for (Map<String, Object> objectMap : maps) {
                    String content1 = str+objectMap.get("bt").toString()+objectMap.get("nr").toString();
                    if (StrUtil.isBlank(content1)) content1 = "     本报告仅对本次检查负责，临床医生依据病情如有疑问，请及时复查或进一步检查";
                    if (StrUtil.isBlank(content1))
                        content1 = "     本报告仅对本次检查负责，临床医生依据病情如有疑问，请及时复查或进一步检查";

                    paragraph = new Paragraph(content1,defaultFont);
                    paragraph.setAlignment(Element.ALIGN_LEFT);
@@ -606,9 +602,6 @@
                document2.add(paragraph);
            }
        }





        for (int i = 0; i < 1; i++) {
@@ -734,7 +727,6 @@
        document2.close();



        ByteArrayOutputStream byteArrayOutputStream = new ByteArrayOutputStream();
        Document document = new Document(PageSize.A4);
        PdfWriter pdfWriter = null;
@@ -774,9 +766,6 @@
            return AjaxResult.error();
        }
        document.close();





        // 首页表单
@@ -837,7 +826,6 @@
        reader4.close();
        // 将修改后的PDF内容写入
        byte[] bytes = byteArrayOutputStream4.toByteArray();



        ByteArrayOutputStream finalOutput = new ByteArrayOutputStream();
@@ -903,7 +891,6 @@
            }
        }
        if (StrUtil.isBlank(sex)) sex = "未知";



        // 生成 document2 并将其内容保存到 byteArrayOutputStream2 中
@@ -988,7 +975,6 @@
        //        List<TjOrderRemark> remarks = tjOrderRemarkMapper.getzongjianyishengchakanyichangxiangmu3( tjOrder.getTjNumber());
        List<TjOrderDetail> orderDetails = tjOrderDetailMapper.getzongjianyishengchakanyichangxiangmu4( tjOrder.getTjNumber());
//        List<Map<String, Object>> jiancha = new ArrayList<>();



        paragraph = PdfUtils.setParagraph(defaultTitleFont, "检查综述：");
@@ -1097,6 +1083,153 @@
        paragraph.setSpacingAfter(2f);
        document2.add(paragraph);
        xmXh = 0;
        LambdaQueryWrapper<TjOrderYcxm> wq = new LambdaQueryWrapper<>();
        wq.eq(TjOrderYcxm::getTjh, tjOrder.getTjNumber());
        List<TjOrderYcxm> ycxms = ycxmService.list(wq);
        if (null != ycxms && !ycxms.isEmpty()) {
            for (Map.Entry<String, List<CsProVo>> deptEntry : listMap.entrySet()) {
                List<CsProVo> proVos = deptEntry.getValue();
                if (proVos.size() > 1) {
                    proVos = proVos.stream()
                            .sorted(Comparator.comparingLong(CsProVo::getProId))
                            .collect(Collectors.toList());
                }
                ArrayList<String> jianYanYiDa = new ArrayList<>();
                for (CsProVo proVo : proVos) {
                    // 检查
                    for (Map.Entry<Long, List<TjOrderDetail>> entry : collect.entrySet()) {
                        if (!entry.getKey().equals(proVo.getProId())) continue;
                        List<TjOrderDetail> details = entry.getValue();
                        String xmmc = details.get(0).getProName();
                        boolean isXmWrite = false;
                        int index = 1;
                        for (TjOrderDetail detail : details) {
                            if (!isXmWrite) {
                                xmXh++;
                                paragraph = new Paragraph("【" + xmXh + "." + xmmc + "】", defaultFont);
                                paragraph.setAlignment(Element.ALIGN_LEFT);
                                document2.add(paragraph);
                                isXmWrite = true;
                            }
                            String result = detail.getProResult();
                            if (StrUtil.isNotBlank(result)) {
                                int index1 = 1;
                                String[] split = result.split("\n");
                                StringBuilder builder = new StringBuilder();
                                for (String s : split) {
                                    if (StrUtil.isBlank(s.replaceAll("\n", "").trim())) continue;
                                    builder.append("    (").append(index1).append(")").append(s).append("\n");
                                    index1++;
                                }
                                result = builder.toString();
                            }
                            if (StrUtil.isNotBlank(result)) {
                                paragraph = new Paragraph(result, defaultFont);
                                paragraph.setAlignment(Element.ALIGN_LEFT);
                                document2.add(paragraph);
                            } else {
                                paragraph = new Paragraph("建议定期复查", defaultFont);
                                paragraph.setAlignment(Element.ALIGN_LEFT);
                                document2.add(paragraph);
                            }
                            String str = "     ";
                            List<Map<String, Object>> maps = new ArrayList<>();

                            LambdaQueryWrapper<TjOrderYcxm> ycwq=new LambdaQueryWrapper<>();
                            ycwq.eq(TjOrderYcxm::getTjh,tjOrder.getTjNumber());
                            ycwq.eq(TjOrderYcxm::getJcxm,xmmc);
                            TjOrderYcxm ycxm = ycxmService.getOne(ycwq);
                            if(null !=ycxm){
                                String jynr = ycxm.getJynr();
                                JSONArray array = JSONUtil.parseArray(jynr);
                                for (Object object : array) {
                                    Map<String,Object> objectMap=new HashMap<>();
                                    JSONObject jsonObject = (JSONObject) object;
                                    String bt = jsonObject.getStr("bt");
                                    String nr = jsonObject.getStr("nr");
                                    objectMap.put("bt",bt);
                                    objectMap.put("nr",nr);
                                    if(null !=bt || null !=nr) maps.add(objectMap);
                                }
                                List<Map<String, Object>> collect1 = maps.stream().distinct().collect(Collectors.toList());
                                for (Map<String, Object> objectMap : collect1) {
                                    String content = str + objectMap.get("bt").toString() + objectMap.get("nr").toString();
                                    if (StrUtil.isBlank(content)) content = "     ";
                                    paragraph = new Paragraph(content, defaultFont);
                                    paragraph.setAlignment(Element.ALIGN_LEFT);
                                    document2.add(paragraph);
                                }
                            }
                            index++;
                            paragraph = PdfUtils.setParagraph(defaultFont, "");
                            paragraph.setLeading(0f);
                            paragraph.setSpacingBefore(0f);
                            paragraph.setSpacingAfter(5f);
                            document2.add(paragraph);
                        }
                    }
                    // 检验
                    for (Map.Entry<String, Object> item : map.entrySet()) {
                        String xmmc = item.getKey();
                        HashMap<String, Object> entryValue = (HashMap<String, Object>) item.getValue();
                        ArrayList<List<String>> lists = (ArrayList<List<String>>) entryValue.get("data");
                        boolean isXmWrite = false;
                        int index = 1;
                        for (List<String> i : lists) {
                            if (!i.get(6).contains(String.valueOf(proVo.getProId()))) continue;
                            if (i.contains("↓") || i.contains("↑")) {
                                if (jianYanYiDa.contains(i.get(5))) continue;
                                jianYanYiDa.add(i.get(5));
                                if (!isXmWrite) {
                                    xmXh++;
                                    paragraph = new Paragraph("【" + xmXh + "." + xmmc + "】", defaultFont);
                                    paragraph.setAlignment(Element.ALIGN_LEFT);
                                    document2.add(paragraph);
                                    isXmWrite = true;
                                }
                                String content = "    (" + index + ")" + i.get(0) + "：" + i.get(1) + "  " + i.get(3) + "  " + i.get(4) + "  " + i.get(2);
                                paragraph = new Paragraph(content, defaultFont);
                                paragraph.setAlignment(Element.ALIGN_LEFT);
                                document2.add(paragraph);
                                String str = "    ";

                                LambdaQueryWrapper<TjOrderYcxm> ycwq=new LambdaQueryWrapper<>();
                                ycwq.eq(TjOrderYcxm::getTjh,tjOrder.getTjNumber());
                                ycwq.eq(TjOrderYcxm::getJcxm,i.get(0));
                                TjOrderYcxm ycxm = ycxmService.getOne(ycwq);
                                if(null !=ycxm){
                                    String jynr = ycxm.getJynr();
                                    JSONArray array = JSONUtil.parseArray(jynr);
                                    for (Object object : array) {
                                        JSONObject jsonObject = (JSONObject) object;
                                        String bt = jsonObject.getStr("bt");
                                        String nr = jsonObject.getStr("nr");
                                        if(null !=bt || null !=nr) {
                                            String content1 = str + bt + nr;
                                            if (StrUtil.isBlank(content)) content1 = "     ";
                                            paragraph = new Paragraph(content1, defaultFont);
                                        }
                                        paragraph.setAlignment(Element.ALIGN_LEFT);
                                        document2.add(paragraph);
                                    }
                                    paragraph = PdfUtils.setParagraph(defaultFont, "");
                                    paragraph.setSpacingBefore(2f);
                                    paragraph.setSpacingAfter(5f);
                                    document2.add(paragraph);
                                    index++;
                                }
                            }
                        }
                        if (isXmWrite) {
                            paragraph = PdfUtils.setParagraph(defaultFont, "");
                            paragraph.setSpacingBefore(0f);
                            paragraph.setSpacingAfter(5f);
                            document2.add(paragraph);
                        }
                    }
                }
            }
        } else {
        for (Map.Entry<String, List<CsProVo>> deptEntry : listMap.entrySet()) {
            List<CsProVo> proVos = deptEntry.getValue();
            if (proVos.size() > 1) {
@@ -1274,6 +1407,8 @@
                }
            }
        }
        }

        for (int i = 0; i < 1; i++) {
            paragraph = PdfUtils.setParagraph(defaultFont, "");
            document2.add(paragraph);
@@ -1418,7 +1553,6 @@
        document2.close();



        ByteArrayOutputStream byteArrayOutputStream = new ByteArrayOutputStream();
        Document document = new Document(PageSize.A4);
        PdfWriter pdfWriter = null;
@@ -1458,9 +1592,6 @@
            return AjaxResult.error();
        }
        document.close();





        // 首页表单
@@ -1532,7 +1663,6 @@
        reader4.close();
        // 将修改后的PDF内容写入
        byte[] bytes = byteArrayOutputStream4.toByteArray();



        ByteArrayOutputStream finalOutput = new ByteArrayOutputStream();
@@ -1720,6 +1850,7 @@

    /**
     * 医师信息行
     *
     * @param phrase
     * @param doctorFonts
     * @param sqrxm
@@ -1784,7 +1915,6 @@
//        fileInputStream.close();
//        fileOutputStream.close();
    }



    /**
@@ -2267,6 +2397,7 @@

    /**
     * 主见医师行显示设置
     *
     * @param document1
     * @param entry
     * @throws DocumentException
@@ -2308,28 +2439,32 @@
                        document1.add(elements);
                    } catch (IOException e) {
                        String doctorName = "主检医师：" + doctorNameDefault;
                        if (createTime != null) doctorName = "检查时间："+new SimpleDateFormat("yyyy-MM-dd").format(createTime)+"             主检医师：" + doctorNameDefault;
                        if (createTime != null)
                            doctorName = "检查时间：" + new SimpleDateFormat("yyyy-MM-dd").format(createTime) + "             主检医师：" + doctorNameDefault;
                        Paragraph df = PdfUtils.setParagraph(doctorFonts, doctorName);
                        df.setAlignment(Element.ALIGN_RIGHT);
                        document1.add(df);
                    }
                }else {
                    String doctorName = "主检医师：" + doctorNameDefault;
                    if (createTime != null) doctorName = "检查时间："+new SimpleDateFormat("yyyy-MM-dd").format(createTime)+"             主检医师：" + doctorNameDefault;
                    if (createTime != null)
                        doctorName = "检查时间：" + new SimpleDateFormat("yyyy-MM-dd").format(createTime) + "             主检医师：" + doctorNameDefault;
                    Paragraph df = PdfUtils.setParagraph(doctorFonts, doctorName);
                    df.setAlignment(Element.ALIGN_RIGHT);
                    document1.add(df);
                }
            }else {
                String doctorName = "主检医师：" + doctorNameDefault;
                if (createTime != null) doctorName = "检查时间："+new SimpleDateFormat("yyyy-MM-dd").format(createTime)+"             主检医师：" + doctorNameDefault;
                if (createTime != null)
                    doctorName = "检查时间：" + new SimpleDateFormat("yyyy-MM-dd").format(createTime) + "             主检医师：" + doctorNameDefault;
                Paragraph df = PdfUtils.setParagraph(doctorFonts, doctorName);
                df.setAlignment(Element.ALIGN_RIGHT);
                document1.add(df);
            }
        } else {
            String doctorName = "主检医师：" + "无";
            if (createTime != null) doctorName = "检查时间："+new SimpleDateFormat("yyyy-MM-dd").format(createTime)+"             主检医师：" + "无";
            if (createTime != null)
                doctorName = "检查时间：" + new SimpleDateFormat("yyyy-MM-dd").format(createTime) + "             主检医师：" + "无";
            Font doctorFonts = PdfUtils.setFont(9);
            Paragraph df = PdfUtils.setParagraph(doctorFonts, doctorName);
            df.setAlignment(Element.ALIGN_RIGHT);
@@ -2653,6 +2788,7 @@
            printReport.put(entry.getKey(), tjPdfVOS);
        }
    }

    private void pacsJianChaData(String tjNumber, Map<TjOrderRemark, List<TjPdfVO>> printReport, TjOrder one, TjCustomer customer) {
//        LambdaQueryWrapper<TjOrderRemark> wqq = new LambdaQueryWrapper<>();
//        wqq.eq(TjOrderRemark::getTjNumber, tjNumber);

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

@@ -56,6 +56,7 @@
import static com.ltkj.framework.datasource.DynamicDataSourceContextHolder.log;
import static org.apache.poi.hemf.record.emfplus.HemfPlusRecordType.save;
import static org.apache.poi.hemf.record.emfplus.HemfPlusRecordType.setClipRect;
import static org.jeecg.modules.jmreport.dyndb.util.b.a;

/**
 * @Author: 西安路泰科技有限公司/赵佳豪
@@ -124,6 +125,8 @@
    private ITjRulesService rulesService;
    @Autowired
    private ITjProAdvicerulesService tjProAdvicerulesService;
    @Autowired
    private TjOrderYcxmService ycxmService;


    @GetMapping ("/ceshicc")
@@ -1636,7 +1639,53 @@
    @ApiOperation (value = "总检查看异常项目接口")
    public AjaxResult getzongjianyishengchakanyichangxiangmu(@RequestParam String tjNum) {
        if (StrUtil.isNotBlank(tjNum)) {
        LambdaQueryWrapper<TjOrderYcxm> wq=new LambdaQueryWrapper<>();
        wq.eq(TjOrderYcxm::getTjh,tjNum);
        List<TjOrderYcxm> list = ycxmService.list(wq);
        if(null !=list && !list.isEmpty()){
            Collections.reverse(list);
            Map<String, List<TjOrderYcxm>> map = list.stream().collect(Collectors.groupingBy(TjOrderYcxm::getParentName));
            List<Map<String, Object>> maps = new ArrayList<>();

            for (Map.Entry<String, List<TjOrderYcxm>> entry : map.entrySet()) {

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

                List<TjOrderDetail> dels = new ArrayList<>();

                for (TjOrderYcxm ycxm : entry.getValue()) {
                    TjOrderDetail detail=new TjOrderDetail();
                    detail.setProName(ycxm.getJcxm());
                    detail.setProResult(ycxm.getJcjg());
                    detail.setStanId(ycxm.getCkfw());
                    detail.setProAdvice(ycxm.getDw());
                    List<Map<String,Object>> btnrlist=new ArrayList<>();
                    String jynr = ycxm.getJynr();
                    JSONArray array = JSONUtil.parseArray(jynr);
                    for (Object object : array) {
                        Map<String,Object> objectMap=new HashMap<>();
                        JSONObject jsonObject = (JSONObject) object;
                        String bt = jsonObject.getStr("bt");
                        String nr = jsonObject.getStr("nr");
                        objectMap.put("bt",bt);
                        objectMap.put("nr",nr);
                        if(null !=bt || null !=nr) btnrlist.add(objectMap);
                    }
                    detail.setAdvices(btnrlist);
                    dels.add(detail);
                }

                    parent.put("proName",entry.getKey());
                    parent.put("jyjc",entry.getValue().get(0).getJyjc());
                    parent.put("sone",dels);
                    maps.add(parent);
            }
            return AjaxResult.success(maps);
        }else {
            return zongjianyishengchakanyichangxiangmu(tjNum);
        }

//            return zongjianyishengchakanyichangxiangmu(tjNum);
        }
        return AjaxResult.error();
    }
@@ -1719,5 +1768,24 @@
    }


    @PostMapping ("/addOrderYcXmByTjh")
    @ApiOperation (value = "总检医生页面新增异常项目建议")
    public AjaxResult addOrderYcXmJyByTjh(@RequestBody List<TjOrderYcxm> ycxms) {
        if(null !=ycxms && !ycxms.isEmpty()){
            String tjh = ycxms.get(0).getTjh();
            if(StringUtils.isNotBlank(tjh)){
                ycxmService.delOrderYcXmJyByTjh(tjh);

                for (TjOrderYcxm ycxm : ycxms) {
                    ycxm.setJynr(JSONUtil.toJsonStr(ycxm.getMap()));
                }
                ycxmService.saveBatch(ycxms);
                return AjaxResult.success();
            }
        }
        return AjaxResult.error();
    }



}

 ltkj-hosp/src/main/java/com/ltkj/hosp/domain/TjOrderYcxm.java

New file
@@ -0,0 +1,50 @@
package com.ltkj.hosp.domain;

import com.baomidou.mybatisplus.annotation.TableField;
import com.ltkj.common.core.domain.BaseEntity;
import io.swagger.annotations.ApiModel;
import io.swagger.annotations.ApiModelProperty;
import lombok.Data;

import java.util.List;
import java.util.Map;

/**
 * ClassName: TjOrderYcxm <br/>
 * Description: <br/>
 * date: 2025/1/21 15:36<br/>
 *
 * @author zjh<br />
 */

@Data
@ApiModel
public class TjOrderYcxm extends BaseEntity {
   private String id;

   @ApiModelProperty(value = "体检号")
   private String tjh;
   @ApiModelProperty(value = "父项目")
   private String parentName ;
   @ApiModelProperty(value = "检测项目")
   private String jcxm;
   @ApiModelProperty(value = "检查结果")
   private String jcjg;
   @ApiModelProperty(value = "参考范围")
   private String ckfw;
   @ApiModelProperty(value = "单位")
   private String dw;
   @ApiModelProperty(value = "标题")
   private String jynr;
   @ApiModelProperty(value = "检验检查")
   private String jyjc;

   @ApiModelProperty(value = "数组")
   @TableField(exist = false)
   private List<TjOrderYcxmMap> map;


   @ApiModelProperty(value = "数组1")
   @TableField(exist = false)
   private List<Map<String,Object>> yclist;
}

 ltkj-hosp/src/main/java/com/ltkj/hosp/domain/TjOrderYcxmMap.java

New file
@@ -0,0 +1,20 @@
package com.ltkj.hosp.domain;

import io.swagger.annotations.ApiModelProperty;
import lombok.Data;

/**
 * ClassName: TjOrderYcxmMap <br/>
 * Description: <br/>
 * date: 2025/1/21 16:44<br/>
 *
 * @author zjh<br />
 */

@Data
public class TjOrderYcxmMap {
    @ApiModelProperty(value = "标题")
    private String bt;
    @ApiModelProperty(value = "内容")
    private String nr;
}

 ltkj-hosp/src/main/java/com/ltkj/hosp/mapper/TjOrderYcxmMapper.java

New file
@@ -0,0 +1,20 @@
package com.ltkj.hosp.mapper;

import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import com.ltkj.hosp.domain.TjOrderYcxm;
import org.apache.ibatis.annotations.Delete;
import org.apache.ibatis.annotations.Mapper;

/**
 * ClassName: TjOrderYcxmMapper <br/>
 * Description: <br/>
 * date: 2025/1/21 15:37<br/>
 *
 * @author zjh<br />
 */
@Mapper
public interface TjOrderYcxmMapper extends BaseMapper<TjOrderYcxm> {

    @Delete("DELETE FROM tj_order_ycxm WHERE tjh=#{tjh}")
    void delOrderYcXmJyByTjh(String tjh);
}

 ltkj-hosp/src/main/java/com/ltkj/hosp/service/TjOrderYcxmService.java

New file
@@ -0,0 +1,16 @@
package com.ltkj.hosp.service;

import com.baomidou.mybatisplus.extension.service.IService;
import com.ltkj.hosp.domain.TjOrderYcxm;

/**
 * ClassName: TjOrderYcxmService <br/>
 * Description: <br/>
 * date: 2025/1/21 15:38<br/>
 *
 * @author zjh<br />
 */

public interface TjOrderYcxmService extends IService<TjOrderYcxm> {
    void delOrderYcXmJyByTjh(String tjh);
}

 ltkj-hosp/src/main/java/com/ltkj/hosp/service/impl/TjOrderYcxmServiceImpl.java

New file
@@ -0,0 +1,27 @@
package com.ltkj.hosp.service.impl;

import com.baomidou.mybatisplus.extension.service.impl.ServiceImpl;
import com.ltkj.hosp.domain.TjOrderYcxm;
import com.ltkj.hosp.mapper.TjOrderYcxmMapper;
import com.ltkj.hosp.service.TjOrderYcxmService;
import org.springframework.stereotype.Service;

import javax.annotation.Resource;

/**
 * ClassName: TjOrderYcxmServiceImpl <br/>
 * Description: <br/>
 * date: 2025/1/21 15:40<br/>
 *
 * @author zjh<br />
 */
@Service
public class TjOrderYcxmServiceImpl extends ServiceImpl<TjOrderYcxmMapper, TjOrderYcxm> implements TjOrderYcxmService {
   @Resource
   private TjOrderYcxmMapper mapper;

    @Override
    public void delOrderYcXmJyByTjh(String tjh) {
        mapper.delOrderYcXmJyByTjh(tjh);
    }
}

 ltkj-hosp/src/main/resources/mapper/TjPackageMapper.xml

@@ -54,7 +54,8 @@
               sale_num,
               category_id,
               his_pac_bm,
               pym,tj_category
               pym,
               tj_category
        from tj_package
    </sql>

@@ -64,6 +65,7 @@
            <if test="pacName != null  and pacName != ''">and pac_name like concat('%', #{pacName}, '%')</if>
            <if test="pacRemark != null  and pacRemark != ''">and pac_remark like concat('%', #{pacRemark}, '%')</if>
            <if test="categoryId != null  and categoryId != ''">and category_id = #{categoryId}</if>
            <if test="tjCategory != null  and tjCategory != ''">and tj_category = #{tjCategory}</if>
            and deleted =0
        </where>
    </select>