From 87a9119e22d949d4b93fb88a7b9497506990b761 Mon Sep 17 00:00:00 2001
From: Administrator <zhubaomin>
Date: 星期五, 29 十二月 2023 11:41:39 +0800
Subject: [PATCH] 2023-12-29 朱宝民 控制器添加、获取水卡状态

---
 pipIrr-platform/pipIrr-global/src/main/java/com/dy/pipIrrGlobal/daoSe/SeClientCardMapper.java |   71 +++++++++++++++++++++++++++++++++--
 1 files changed, 67 insertions(+), 4 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 0e75827..946c184 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
@@ -1,15 +1,23 @@
 package com.dy.pipIrrGlobal.daoSe;
 
+import com.baomidou.mybatisplus.core.mapper.BaseMapper;
 import com.dy.pipIrrGlobal.pojoSe.SeClientCard;
+import com.dy.pipIrrGlobal.voSe.VoCardInfo;
+import org.apache.ibatis.annotations.Mapper;
 import org.apache.ibatis.annotations.Param;
+
+import java.util.List;
+import java.util.Map;
 
 /**
  * @author ZhuBaoMin
- * @date 2023/12/7 9:06
- * @LastEditTime 2023/12/7 9:06
+ * @date 2023/12/22 16:04
+ * @LastEditTime 2023/12/22 16:04
  * @Description
  */
-public interface SeClientCardMapper {
+
+@Mapper
+public interface SeClientCardMapper extends BaseMapper<SeClientCard> {
     int deleteByPrimaryKey(Long id);
 
     int insert(SeClientCard record);
@@ -23,10 +31,65 @@
     int updateByPrimaryKey(SeClientCard record);
 
     /**
-     * 渚濇嵁姘村崱鍦板潃鑾峰彇姘村崱缂栧彿锛堜富閿級
+     * 渚濇嵁姘村崱鍦板潃鑾峰彇姘村崱缂栧彿锛�12鏈�19鏃ュ簾寮冿級
      * @param cardAddr
      * @return
      */
     Long getCardIdByAddr(@Param("cardAddr") String cardAddr);
 
+    /**
+     * 鏍规嵁姘村崱缂栧彿鑾峰彇姘村崱琛ㄤ富閿紙12鏈�19鏃ユ坊鍔犲悗搴熷純锛�
+     * @param cardNum 16浣嶆按鍗＄紪鍙�
+     * @return 姘村崱琛ㄤ富閿�
+     */
+    Long getCardIdByNum(@Param("cardNum") String cardNum);
+
+    /**
+     * 鏍规嵁琛屾斂鍖哄垝涓叉ā鍧楁煡璇㈡按鍗＄紪鍙�
+     * @param areaCode
+     * @return
+     */
+    String getCardNumOfMax(@Param("areaCode") String areaCode);
+
+    /**
+     * 鏍规嵁姘村崱缂栧彿鑾峰彇姘村崱琛ㄤ富閿強鍐滄埛缂栧彿
+     * @param cardNum
+     * @return
+     */
+    Map getCardIdAndClientNum(@Param("cardNum") String cardNum);
+
+    /**
+     * 鏍规嵁鍐滄埛涓婚敭鑾峰彇姘村崱鍒楄〃
+     * @param clientId
+     * @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);
+
+    /**
+     * 鏍规嵁姘村崱缂栧彿鑾峰彇鍗＄墖鐘舵��
+     * @param cardNum
+     * @return
+     */
+    String getCardStateByCardNum(@Param("cardNum") Long cardNum);
 }
\ No newline at end of file

--
Gitblit v1.8.0