From 3011f29e06877bd56e6c0dd402677c3c8926ca79 Mon Sep 17 00:00:00 2001
From: lige <bestlige@outlook.com>
Date: 星期三, 03 一月 2024 13:48:19 +0800
Subject: [PATCH] 职业健康报表既往病史sql
---
ltkj-hosp/src/main/java/com/ltkj/hosp/mapper/TjOrderMapper.java | 10 +++++++++-
1 files changed, 9 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 93cc83b..33cf20a 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
@@ -188,6 +188,14 @@
TjOrder getLastTjOrderListByCusId(Long userId);
- //瀛樺偍杩囩▼涓撶敤鎺ュ彛
+ //瀛樺偍杩囩▼涓撶敤鎺ュ彛(鎬绘)
List<List<?>> getCunChuGuoChengCustomerList(Map<String,Object> map);
+
+
+ //瀛樺偍杩囩▼涓撶敤鎺ュ彛(鍒濆)
+ List<List<?>> getCsCunChuGuoChengCustomerList(Map<String,Object> map);
+
+
+ @Select("SELECT count(*) FROM tj_order a WHERE a.deleted=0 and a.card_id=#{cardId}")
+ int selectTjOrderByCardId(String cardId);
}
--
Gitblit v1.8.0