From 8aae8dad9cb60257efc2bba55481541078008798 Mon Sep 17 00:00:00 2001 From: zhaowenxuan <chacca165@163.com> Date: 星期四, 08 五月 2025 17:43:46 +0800 Subject: [PATCH] 该科室下无项目增加日志打印 --- ltkj-hosp/src/main/java/com/ltkj/hosp/mapper/LtkjHybgdMapper.java | 7 +++++++ 1 files changed, 7 insertions(+), 0 deletions(-) diff --git a/ltkj-hosp/src/main/java/com/ltkj/hosp/mapper/LtkjHybgdMapper.java b/ltkj-hosp/src/main/java/com/ltkj/hosp/mapper/LtkjHybgdMapper.java index 9d66a56..152d5f8 100644 --- a/ltkj-hosp/src/main/java/com/ltkj/hosp/mapper/LtkjHybgdMapper.java +++ b/ltkj-hosp/src/main/java/com/ltkj/hosp/mapper/LtkjHybgdMapper.java @@ -30,4 +30,11 @@ @Select("SELECT * FROM ltkj_hybgd WHERE tmh=#{tmh}") List<LtkjHybgd> getJianYanBaoGaoDanList(String tmh); + + @Select("SELECT a.sqdh FROM ltkj_jianchajianyan_tree a WHERE a.card_id =#{cardId} AND a.type='妫�鏌�' GROUP BY a.sqdh") + List<String> getJianChaBaoGaoDan(String cardId); + + + @Select("SELECT * FROM ltkj_hybgd WHERE tmh=#{tmh} GROUP BY jcxmid HAVING MAX(shsj) ") + List<LtkjHybgd> getReportJianYanBaoGaoDanList(String tmh); } -- Gitblit v1.8.0