From 06e4e5ed216062b28f2a2f05f3e4a5e538d41d53 Mon Sep 17 00:00:00 2001
From: lige <bestlige@outlook.com>
Date: 星期五, 15 十二月 2023 18:36:41 +0800
Subject: [PATCH] 套餐价重复项
---
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