From ad4326adc4ccad14f090fba5acb435deab8260db Mon Sep 17 00:00:00 2001
From: zjh <1084500556@qq.com>
Date: 星期二, 22 七月 2025 16:09:14 +0800
Subject: [PATCH] zjh20250722
---
ltkj-hosp/src/main/java/com/ltkj/hosp/mapper/TjOrderMapper.java | 9 +++++++++
1 files changed, 9 insertions(+), 0 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 dd93ba0..e51251c 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
@@ -436,4 +436,13 @@
//瀛樺偍杩囩▼涓撶敤鎺ュ彛(鎬绘)
List<List<?>> getEsjCunChuGuoChengCustomerList(Map<String,Object> map);
+
+
+ @Select("SELECT * FROM tj_order WHERE tj_number = card_id ")
+ List<TjOrder> getOrderListBypiliangqiandaofasong();
+
+
+ @Select("SELECT COUNT(*) FROM tj_order a WHERE a.deleted=0 AND " +
+ "(a.firm_id=#{compId} OR a.team_no=#{teamNo}) AND a.pac_id=#{pacId}")
+ Integer getTjTeamSelectRecordCount(@Param("teamNo") String teamNo,@Param("compId") String compId,@Param("pacId") String pacId);
}
--
Gitblit v1.8.0