From dedacd79c93f8ef95e0cb986f5e7fbd27ddbd907 Mon Sep 17 00:00:00 2001
From: zhaowenxuan <chacca165@163.com>
Date: 星期四, 03 七月 2025 09:12:49 +0800
Subject: [PATCH] 2025-07-03
---
ltkj-hosp/src/main/java/com/ltkj/hosp/mapper/TjOrderMapper.java | 14 +++++++++++++-
1 files changed, 13 insertions(+), 1 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 494690f..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' ")
@@ -388,5 +388,17 @@
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