From 1fe54cbb927dd89f7568d971fe427e980302f1d1 Mon Sep 17 00:00:00 2001 From: zhaowenxuan <chacca165@163.com> Date: 星期三, 23 七月 2025 14:03:54 +0800 Subject: [PATCH] 总检页面查询数据接口弃检结果去重 --- ltkj-hosp/src/main/java/com/ltkj/hosp/mapper/LtkjHybgdMapper.java | 5 ++++- 1 files changed, 4 insertions(+), 1 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 5ecb689..633c953 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 @@ -17,7 +17,7 @@ * @Date: 2023/12/11 17:56 */ @Mapper -@DataSource(value = DataSourceType.MASTER) +//@DataSource(value = DataSourceType.MASTER) public interface LtkjHybgdMapper extends BaseMapper<LtkjHybgd> { @@ -33,4 +33,7 @@ @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