From 5f1d1c462bbf49bc6a22b9e17b49733bcc1e0bc6 Mon Sep 17 00:00:00 2001
From: zjh <1084500556@qq.com>
Date: 星期五, 20 六月 2025 19:01:13 +0800
Subject: [PATCH] zjh20250620
---
ltkj-hosp/src/main/java/com/ltkj/hosp/mapper/TjOrderMapper.java | 21 ++++++++++++++++++---
1 files changed, 18 insertions(+), 3 deletions(-)
diff --git a/ltkj-hosp/src/main/java/com/ltkj/hosp/mapper/TjOrderMapper.java b/ltkj-hosp/src/main/java/com/ltkj/hosp/mapper/TjOrderMapper.java
index e9e0070..005dcb2 100644
--- a/ltkj-hosp/src/main/java/com/ltkj/hosp/mapper/TjOrderMapper.java
+++ b/ltkj-hosp/src/main/java/com/ltkj/hosp/mapper/TjOrderMapper.java
@@ -145,7 +145,7 @@
@Select("SELECT * FROM tj_order WHERE user_id = #{cusId} AND deleted='0' ORDER BY create_time DESC")
public List<TjOrder> getOrderListByCusId(@Param("cusId") String cusId);
- @Select("SELECT * FROM tj_order WHERE tj_number = #{tjNum} AND deleted='0' ")
+ @Select("SELECT * FROM tj_order WHERE tj_number = #{tjNum} AND deleted=0 ")
public TjOrder getOrderByTjNum(String tjNum);
@Select("SELECT * FROM tj_order WHERE card_id = #{cardId} AND deleted='0' ")
@@ -234,9 +234,9 @@
@Select("SELECT \n" +
- " '1' AS xh, " +
+ " ROW_NUMBER() OVER (ORDER BY d.djd_num) AS xh, " +
" REPLACE(d.dept_name, '闂ㄨ瘖', '') AS ksmc,\n" +
- " d.official_web AS ksdz,\n" +
+ " ifnull(d.official_web,'') AS ksdz,\n" +
" e.tjxm,\n" +
" e.tjjg\n" +
"FROM sys_dept d\n" +
@@ -386,4 +386,19 @@
" a.deleted = 0 \n" +
" AND b.org_type = 2 \n")
List<String> getJianChaTjNum();
+
+
+ @Select("SELECT a.tj_number FROM tj_order a WHERE a.deleted=0 AND a.check_status=0 AND\n" +
+ "ISNULL(a.report_time)")
+ List<String> getJianChaTjNumWsh();
+
+
+
+
+
+ List<List<?>> getYxJcList(Map<String,Object> map);
+
+
+ @Select("SELECT count(*) FROM tj_order WHERE tj_number = #{tjNum}")
+ int getOrderCountByTjNum(String tjNum);
}
--
Gitblit v1.8.0