From 4427ac5c814c4faa45e7e480c6841a892569d400 Mon Sep 17 00:00:00 2001
From: Administrator <zhubaomin>
Date: 星期四, 28 十二月 2023 17:32:38 +0800
Subject: [PATCH] 2023-12-28 朱宝民 根据水卡编号获取操作记录添加充值总额和订单号

---
 pipIrr-platform/pipIrr-global/src/main/java/com/dy/pipIrrGlobal/daoSe/SeClientCardMapper.java |   21 +++++++++++++++++++++
 1 files changed, 21 insertions(+), 0 deletions(-)

diff --git a/pipIrr-platform/pipIrr-global/src/main/java/com/dy/pipIrrGlobal/daoSe/SeClientCardMapper.java b/pipIrr-platform/pipIrr-global/src/main/java/com/dy/pipIrrGlobal/daoSe/SeClientCardMapper.java
index 7c70169..9eeb8a0 100644
--- a/pipIrr-platform/pipIrr-global/src/main/java/com/dy/pipIrrGlobal/daoSe/SeClientCardMapper.java
+++ b/pipIrr-platform/pipIrr-global/src/main/java/com/dy/pipIrrGlobal/daoSe/SeClientCardMapper.java
@@ -64,4 +64,25 @@
      * @return
      */
     List<VoCardInfo> getCardInfoByClientId(@Param("clientId") Long clientId);
+
+    /**
+     * 鏍规嵁姘村崱缂栧彿鑾峰彇鎿嶄綔璁板綍鍒楄〃
+     * @param cardNum 姘村崱缂栧彿
+     * @return 姘村崱鎿嶄綔璁板綍鍒楄〃
+     */
+    List<Map<String, Object>> getOperateRecordsByCardNum(@Param("cardNum") Long cardNum);
+
+    /**
+     * 鏍规嵁姘村崱缂栧彿鑾峰彇浣欓
+     * @param cardNum 姘村崱缂栧彿
+     * @return 浣欓
+     */
+    Float getMoneyByCardNum(@Param("cardNum") Long cardNum);
+
+    /**
+     * 鏍规嵁姘村崱缂栧彿鑾峰彇鍏呭�兼�婚
+     * @param cardNum
+     * @return
+     */
+    Float sumRechargeByCardNum(@Param("cardNum") Long cardNum);
 }
\ No newline at end of file

--
Gitblit v1.8.0