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