From aa33bb96ba9f14b16c6c7832e21bfbd88983ba6d Mon Sep 17 00:00:00 2001
From: zjh <1084500556@qq.com>
Date: 星期三, 24 一月 2024 18:02:39 +0800
Subject: [PATCH] zjh 2024/01/24--3
---
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