From 8aea3ecc955f5c55024686375bc6b2fc3a989a35 Mon Sep 17 00:00:00 2001
From: zjh <1084500556@qq.com>
Date: 星期三, 03 七月 2024 15:44:32 +0800
Subject: [PATCH] zjh 2024/07/3-1
---
ltkj-hosp/src/main/java/com/ltkj/hosp/mapper/LtkjJianchajianyanTreeMapper.java | 6 ++++++
1 files changed, 6 insertions(+), 0 deletions(-)
diff --git a/ltkj-hosp/src/main/java/com/ltkj/hosp/mapper/LtkjJianchajianyanTreeMapper.java b/ltkj-hosp/src/main/java/com/ltkj/hosp/mapper/LtkjJianchajianyanTreeMapper.java
index bd8b4a0..75ee29e 100644
--- a/ltkj-hosp/src/main/java/com/ltkj/hosp/mapper/LtkjJianchajianyanTreeMapper.java
+++ b/ltkj-hosp/src/main/java/com/ltkj/hosp/mapper/LtkjJianchajianyanTreeMapper.java
@@ -2,6 +2,9 @@
import com.ltkj.hosp.domain.LtkjJianchajianyanTree;
import com.baomidou.mybatisplus.core.mapper.BaseMapper;
+import org.apache.ibatis.annotations.Select;
+
+import java.math.BigDecimal;
/**
* @author chacca
@@ -11,6 +14,9 @@
*/
public interface LtkjJianchajianyanTreeMapper extends BaseMapper<LtkjJianchajianyanTree> {
+ @Select("SELECT SUM(aa.fyhj) FROM (" +
+ "SELECT a.fyhj FROM ltkj_jianchajianyan_tree a WHERE a.card_id=#{cardId} GROUP BY a.sqdh,a.type)aa;")
+ BigDecimal getLtkjJianchajianyanTreeFyhjByCardId(String cardId);
}
--
Gitblit v1.8.0