From aa4a9a6f2f40f57fc725ebcd5a6c09d34921f0eb Mon Sep 17 00:00:00 2001 From: 赵文轩 <1652863494@qq.com> Date: 星期五, 07 六月 2024 10:23:06 +0800 Subject: [PATCH] hisAPI配置 --- ltkj-hosp/src/main/java/com/ltkj/hosp/mapper/TjPackageMapper.java | 2 +- 1 files changed, 1 insertions(+), 1 deletions(-) diff --git a/ltkj-hosp/src/main/java/com/ltkj/hosp/mapper/TjPackageMapper.java b/ltkj-hosp/src/main/java/com/ltkj/hosp/mapper/TjPackageMapper.java index 9a0d458..867d132 100644 --- a/ltkj-hosp/src/main/java/com/ltkj/hosp/mapper/TjPackageMapper.java +++ b/ltkj-hosp/src/main/java/com/ltkj/hosp/mapper/TjPackageMapper.java @@ -94,7 +94,7 @@ "on b.pro_id=c.pro_id\n" + "WHERE !locate(\"濂砛",a.pac_name) and !locate(\"瀛昞",a.pac_name) and !locate(\"濡嘰",a.pac_name) and !locate(\"浜",a.pac_name) and a.pac_status=0 AND a.deleted =0 and a.pac_name like concat('%',#{name},'%')\n" + "GROUP BY a.pac_id\n" + - "ORDER BY a.sort DESC;}") + "ORDER BY a.sort DESC;\n") List<TjPackage> getPacListBySqlAndMan(String pacName); @Select("SELECT a.pac_id,a.pac_name,a.price,GROUP_CONCAT(distinct c.pro_name SEPARATOR ',') AS allProName\n" + -- Gitblit v1.8.0