From 3f31a0466e7a706424d28aaab10bb70e2895bcfc Mon Sep 17 00:00:00 2001
From: zjh <1084500556@qq.com>
Date: 星期一, 21 四月 2025 16:13:25 +0800
Subject: [PATCH] zjh20250419
---
ltkj-hosp/src/main/java/com/ltkj/hosp/mapper/TjPackageMapper.java | 6 +++---
1 files changed, 3 insertions(+), 3 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 0bed661..9718687 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
@@ -86,7 +86,7 @@
@Select("SELECT GROUP_CONCAT(b.pro_name ) AS names FROM tj_package_project a LEFT JOIN tj_project b ON a.pro_id=b.pro_id WHERE a.pac_id=#{pacId}")
String getTjPacProNames(String pacId);
- @Select("SELECT a.pac_id,a.pac_name,a.price,GROUP_CONCAT(distinct c.pro_name SEPARATOR ',') AS allProName\n" +
+ @Select("SELECT a.pac_id,a.pac_name,a.new_price price,GROUP_CONCAT(distinct c.pro_name SEPARATOR ',') AS allProName\n" +
"FROM tj_package a\n" +
"left JOIN tj_package_project b\n" +
"ON a.pac_id=b.pac_id\n" +
@@ -97,7 +97,7 @@
"ORDER BY a.sort;\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" +
+ @Select("SELECT a.pac_id,a.pac_name,a.new_price price,GROUP_CONCAT(distinct c.pro_name SEPARATOR ',') AS allProName\n" +
"FROM tj_package a\n" +
"left JOIN tj_package_project b\n" +
"ON a.pac_id=b.pac_id\n" +
@@ -110,7 +110,7 @@
- @Select(" SELECT a.pac_id,a.pac_name,a.price,GROUP_CONCAT(distinct c.pro_name SEPARATOR ',') AS allProName\n" +
+ @Select(" SELECT a.pac_id,a.pac_name,a.new_price price,GROUP_CONCAT(distinct c.pro_name SEPARATOR ',') AS allProName\n" +
" FROM tj_package a\n" +
" left JOIN tj_package_project b\n" +
" ON a.pac_id=b.pac_id\n" +
--
Gitblit v1.8.0