From 1157c9c0eca6484e197aaeb941ac7ce572a5cc03 Mon Sep 17 00:00:00 2001
From: liurunyu <lry9898@163.com>
Date: 星期三, 05 二月 2025 11:25:51 +0800
Subject: [PATCH] 取水口综合信息：监控数据信息，统计数据信息

---
 pipIrr-platform/pipIrr-global/src/main/java/com/dy/pipIrrGlobal/daoSe/SeVirtualCardMapper.java |   82 +++++++++++++++++++++++++++++++++++++++--
 1 files changed, 78 insertions(+), 4 deletions(-)

diff --git a/pipIrr-platform/pipIrr-global/src/main/java/com/dy/pipIrrGlobal/daoSe/SeVirtualCardMapper.java b/pipIrr-platform/pipIrr-global/src/main/java/com/dy/pipIrrGlobal/daoSe/SeVirtualCardMapper.java
index 2ccecae..0d90840 100644
--- a/pipIrr-platform/pipIrr-global/src/main/java/com/dy/pipIrrGlobal/daoSe/SeVirtualCardMapper.java
+++ b/pipIrr-platform/pipIrr-global/src/main/java/com/dy/pipIrrGlobal/daoSe/SeVirtualCardMapper.java
@@ -2,11 +2,15 @@
 
 import com.baomidou.mybatisplus.core.mapper.BaseMapper;
 import com.dy.pipIrrGlobal.pojoSe.SeVirtualCard;
+import com.dy.pipIrrGlobal.voSe.VoCardInfo1;
+import com.dy.pipIrrGlobal.voSe.VoVcRecharge;
 import com.dy.pipIrrGlobal.voSe.VoVirtualCard;
 import org.apache.ibatis.annotations.Mapper;
 import org.apache.ibatis.annotations.Param;
 
+import java.util.Date;
 import java.util.List;
+import java.util.Map;
 
 /**
  * @author ZhuBaoMin
@@ -29,19 +33,19 @@
 
     int updateByPrimaryKey(SeVirtualCard record);
 
-    /**
+    /** 搴熷純
      * 楠岃瘉鍐滄埛鏄惁鎷ユ湁鎸囧畾鍚嶇О鐨勮櫄鎷熷崱
      * @param clientId 鍐滄埛缂栧彿
      * @param vcName 铏氭嫙鍗″悕绉�
      * @return 绗﹀悎鏉′欢璁板綍鏁�
      */
-    int getRecordCountByName(@Param("clientId") Long clientId, @Param("vcName") String vcName);
+    //int getRecordCountByName(@Param("clientId") Long clientId, @Param("vcName") String vcName);
 
     /**
-     * 鑾峰彇鍏ㄩ儴铏氭嫙鍗�
+     * 鑾峰彇鍐滄埛鍏ㄩ儴铏氭嫙鍗�
      * @return
      */
-    List<VoVirtualCard> getVCs();
+    List<VoVirtualCard> getVCs(@Param("alarmValue") Integer alarmValue, @Param("clientId") Long clientId);
 
     /**
      * 鏍规嵁铏氭嫙鍗D鑾峰彇铏氭嫙鍗″璞�
@@ -51,9 +55,79 @@
     VoVirtualCard getVcById(@Param("vcId") Long vcId);
 
     /**
+     * 鏍规嵁铏氭嫙鍗＄紪鍙疯幏鍙栬櫄鎷熷崱
+     * @param vcNum
+     * @return
+     */
+    SeVirtualCard getVcCardByNum(@Param("vcNum") String vcNum);
+
+    /**
+     * 鏍规嵁铏氭嫙姘村崱缂栧彿鑾峰彇瀵瑰簲鐨勫啘鎴穒d鍜屽鍚�
+     * @param vcNum
+     * @return
+     */
+    Map getClientIdAndNameByVsCardNo(@Param("vcNum") Long vcNum);
+
+    /**
+     * 寰楀埌姘村崱瀵硅薄
+     * @param cardNum
+     * @return
+     */
+    List<VoCardInfo1> getCardsByNum(@Param("cardNum") Long cardNum);
+
+    /**
      * 鏍规嵁铏氭嫙鍗＄紪鍙疯幏鍙栬櫄鎷熷崱ID
      * @param vcNum
      * @return
      */
     Long getVcIdByNum(@Param("vcNum") String vcNum);
+
+    /**
+     * 鏍规嵁琛屾斂鍖哄垝涓叉ā绯婃煡璇㈣櫄鎷熷崱缂栧彿
+     * @param areaCode
+     * @return
+     */
+    String getVcCardNumOfMax(@Param("areaCode") String areaCode);
+
+    /**
+     * 涓�涓彇姘村彛涓婂崰鐢ㄧ殑铏氭嫙鍗＄姸鎬佸彉鎴愪笉鍗犵敤
+     * @param intakeId
+     * @return
+     */
+    void updateVcCardNoUseStateByIntakeId(@Param("intakeId")Long intakeId, @Param("now")Date now) ;
+
+    /**
+     * 鑾峰彇铏氭嫙鍗″厖鍊艰褰�
+     * @return
+     */
+    List<VoVcRecharge> getVcRechargeRecords(Map<?, ?> params);
+
+    /**
+     * 鑾峰彇铏氭嫙鍗″厖鍊艰褰曟暟
+     * @param params
+     * @return
+     */
+    Long getRechargeRecordCount(Map<?, ?> params);
+
+    /**
+     * 鏇存柊瀹炰綋鍗″墿浣欓噾棰�
+     * @param id
+     * @param money
+     */
+    void updateMoney(@Param("id")Long id , @Param("money")Double money);
+
+    /**
+     * 鏍规嵁鍐滄埛ID鍙婅櫄鎷熷崱ID鑾峰彇姝ｅ父鐘舵�佺殑铏氭嫙鍗″璞★紝閿�鍗′娇鐢�
+     * @param clientId
+     * @param vcId
+     * @return
+     */
+    SeVirtualCard getVcByClientIdAndVcId(@Param("clientId")Long clientId, @Param("vcId")Long vcId);
+
+    /**
+     * 娉ㄩ攢铏氭嫙鍗�
+     * @param vcId
+     * @return
+     */
+    Integer cancelVc(@Param("clientId")Long clientId, @Param("vcId")Long vcId);
 }
\ No newline at end of file

--
Gitblit v1.8.0