From d6caa33b757fcb2f32b693b5db3c0398e96194a3 Mon Sep 17 00:00:00 2001
From: zjh <zjh@888>
Date: 星期二, 25 六月 2024 18:25:10 +0800
Subject: [PATCH] zjh 本地 2024/06/25 --1
---
ltkj-hosp/src/main/java/com/ltkj/hosp/mapper/TjPackageMapper.java | 10 +++++-----
1 files changed, 5 insertions(+), 5 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 867d132..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,10 +76,10 @@
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();
@@ -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;\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" +
@@ -105,7 +105,7 @@
"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")
+ "ORDER BY a.sort;\n")
List<TjPackage> getPacListBySqlAndWomen(String pacName);
@@ -118,7 +118,7 @@
" 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;")
+ " ORDER BY a.sort;")
List<TjPackage> getPacListBySqlAndAll(String pacName);
--
Gitblit v1.8.0