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); }