From d866e43afbe901bfc640776e02f767b9045acbc2 Mon Sep 17 00:00:00 2001
From: 赵文轩 <1652863494@qq.com>
Date: 星期三, 12 六月 2024 09:04:56 +0800
Subject: [PATCH] Merge branch 'master' of http://101.42.27.146:5001/r/ltkj_peis

---
 ltkj-hosp/src/main/java/com/ltkj/hosp/mapper/TjPackageMapper.java |   37 +++++++++++++++++++++++++++++++++++++
 1 files changed, 37 insertions(+), 0 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..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
@@ -85,4 +85,41 @@
 
     @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 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" +
+            "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 DESC;\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 DESC;")
+    List<TjPackage> getPacListBySqlAndAll(String pacName);
+
+
 }

--
Gitblit v1.8.0