From 157a9ee9c166cc84a04539748a1b9d7269147002 Mon Sep 17 00:00:00 2001
From: zjh <1084500556@qq.com>
Date: 星期三, 13 九月 2023 14:51:54 +0800
Subject: [PATCH] zjh 2023/09/13---3
---
ltkj-hosp/src/main/java/com/ltkj/hosp/mapper/TbTransitionMapper.java | 4 ++++
1 files changed, 4 insertions(+), 0 deletions(-)
diff --git a/ltkj-hosp/src/main/java/com/ltkj/hosp/mapper/TbTransitionMapper.java b/ltkj-hosp/src/main/java/com/ltkj/hosp/mapper/TbTransitionMapper.java
index c7cd20f..e96c429 100644
--- a/ltkj-hosp/src/main/java/com/ltkj/hosp/mapper/TbTransitionMapper.java
+++ b/ltkj-hosp/src/main/java/com/ltkj/hosp/mapper/TbTransitionMapper.java
@@ -9,6 +9,7 @@
import org.apache.ibatis.annotations.Select;
import java.math.BigDecimal;
+import java.util.Date;
import java.util.List;
/**
@@ -89,4 +90,7 @@
@Select("SELECT SUM(a.now_price) now_price FROM tb_transition a WHERE cus_id=#{cusId}")
BigDecimal sumNowPrice(String cusId);
+
+ @Select("SELECT MAX(a.create_time) FROM tb_transition a WHERE a.cus_id=#{cusId} ")
+ Date getTbTransitionCreateTimeByCusId(String cusId);
}
--
Gitblit v1.8.0