From 9ac01b48ef00a0855306d72e8c680b912a9a8d03 Mon Sep 17 00:00:00 2001 From: zjh <1084500556@qq.com> Date: 星期四, 07 八月 2025 08:44:50 +0800 Subject: [PATCH] zjh20250807 --- ltkj-hosp/src/main/java/com/ltkj/hosp/mapper/TjOrderRemarkMapper.java | 7 +++++++ 1 files changed, 7 insertions(+), 0 deletions(-) diff --git a/ltkj-hosp/src/main/java/com/ltkj/hosp/mapper/TjOrderRemarkMapper.java b/ltkj-hosp/src/main/java/com/ltkj/hosp/mapper/TjOrderRemarkMapper.java index 696482c..f59e9e2 100644 --- a/ltkj-hosp/src/main/java/com/ltkj/hosp/mapper/TjOrderRemarkMapper.java +++ b/ltkj-hosp/src/main/java/com/ltkj/hosp/mapper/TjOrderRemarkMapper.java @@ -327,4 +327,11 @@ @Select("call newpacsJianChaData(#{tjnumber,mode=IN},0)") List<TjOrderRemark> newpacsJianChaData(String tjnumber); + + + @Select(" SELECT CONCAT(CONCAT('鍏�',COUNT(*),'椤�'),': '," + + "TRIM(GROUP_CONCAT(b.pro_name ORDER BY b.pro_name SEPARATOR ' | '))) AS xmm" + + " FROM tj_order_remark a LEFT JOIN tj_project b ON b.pro_id=a.pro_id" + + " WHERE a.tj_number=#{tjNumber} AND a.type !=2 AND a.deleted=0") + String getTjxm(String tjNumber); } -- Gitblit v1.8.0