From a6c2fcf68b27c50f2390e6b9d7e050cc3f76eceb Mon Sep 17 00:00:00 2001
From: zhaowenxuan <chacca165@163.com>
Date: 星期三, 26 二月 2025 15:07:23 +0800
Subject: [PATCH] 切库
---
ltkj-hosp/src/main/java/com/ltkj/hosp/mapper/TjPackageMapper.java | 41 +++++++++++++++++++++++++++++++++++++++--
1 files changed, 39 insertions(+), 2 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 1d013f1..0bed661 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
@@ -76,13 +76,50 @@
public TjPackage getTjPackageByPacId(String pacId);
- @Select("SELECT * FROM tj_package WHERE !locate(\"濂砛",pac_name) and !locate(\"瀛昞",pac_name) and !locate(\"濡嘰",pac_name) and !locate(\"浜",pac_name) and pac_status=0 AND deleted =0 ORDER BY sort DESC")
+ @Select("SELECT * FROM tj_package WHERE !locate(\"濂砛",pac_name) and !locate(\"瀛昞",pac_name) and !locate(\"濡嘰",pac_name) and !locate(\"浜",pac_name) and pac_status=0 AND deleted =0 ORDER BY sort")
List<TjPackage> getTjPackageListByMan();
- @Select("SELECT * FROM tj_package WHERE !locate(\"鐢穃",pac_name) and pac_status=0 AND deleted =0 ORDER BY sort DESC")
+ @Select("SELECT * FROM tj_package WHERE !locate(\"鐢穃",pac_name) and pac_status=0 AND deleted =0 ORDER BY sort")
List<TjPackage> getTjPackageListByWoMan();
@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" +
+ "FROM tj_package a\n" +
+ "left JOIN tj_package_project b\n" +
+ "ON a.pac_id=b.pac_id\n" +
+ "left JOIN tj_project c\n" +
+ "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;\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" +
+ "FROM tj_package a\n" +
+ "left JOIN tj_package_project b\n" +
+ "ON a.pac_id=b.pac_id\n" +
+ "left JOIN tj_project c\n" +
+ "on b.pro_id=c.pro_id\n" +
+ "WHERE !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;\n")
+ List<TjPackage> getPacListBySqlAndWomen(String pacName);
+
+
+
+ @Select(" SELECT a.pac_id,a.pac_name,a.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" +
+ " left JOIN tj_project c\n" +
+ " on b.pro_id=c.pro_id\n" +
+ " WHERE 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;")
+ List<TjPackage> getPacListBySqlAndAll(String pacName);
+
+
}
--
Gitblit v1.8.0