From cc25bc0eec2d50da39d62f9896ed4d5e66805366 Mon Sep 17 00:00:00 2001
From: zjh <1084500556@qq.com>
Date: 星期五, 11 七月 2025 18:04:05 +0800
Subject: [PATCH] zjh20250711
---
ltkj-hosp/src/main/java/com/ltkj/hosp/mapper/TjCompPayMapper.java | 15 +++++++++++++++
1 files changed, 15 insertions(+), 0 deletions(-)
diff --git a/ltkj-hosp/src/main/java/com/ltkj/hosp/mapper/TjCompPayMapper.java b/ltkj-hosp/src/main/java/com/ltkj/hosp/mapper/TjCompPayMapper.java
index 2409eb1..88d6478 100644
--- a/ltkj-hosp/src/main/java/com/ltkj/hosp/mapper/TjCompPayMapper.java
+++ b/ltkj-hosp/src/main/java/com/ltkj/hosp/mapper/TjCompPayMapper.java
@@ -4,6 +4,11 @@
import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import com.ltkj.hosp.domain.TjCompPay;
import org.apache.ibatis.annotations.Mapper;
+import org.apache.ibatis.annotations.Param;
+import org.apache.ibatis.annotations.Select;
+
+import java.math.BigDecimal;
+import java.util.List;
/**
* 浣撴鍗曚綅缂磋垂涓籑apper鎺ュ彛
@@ -13,4 +18,14 @@
*/
@Mapper
public interface TjCompPayMapper extends BaseMapper<TjCompPay> {
+
+
+
+ @Select("SELECT IFNULL(SUM(a.paid_in),0) yf FROM tj_comp_pay a WHERE a.deleted=0 " +
+ "AND a.comp_id=#{compId} AND a.team_no=#{teamNo} AND a.pac_id=#{pacId}")
+ BigDecimal sumZje(@Param("compId")String compId,@Param("teamNo") String teamNo,@Param("pacId") String pacId);
+
+ @Select("SELECT a.serial_number FROM tj_comp_pay a WHERE a.deleted=0 " +
+ "AND a.comp_id=#{compId} AND a.team_no=#{teamNo} AND a.pac_id=#{pacId}")
+ List<String> serialNumbers(@Param("compId")String compId,@Param("teamNo") String teamNo,@Param("pacId") String pacId);
}
--
Gitblit v1.8.0