From cf2ceec786652531974c39d573dfcb8d3f661e1e Mon Sep 17 00:00:00 2001
From: wuzeyu <1223318623@qq.com>
Date: 星期五, 09 八月 2024 10:37:26 +0800
Subject: [PATCH] 指定时间内开物理卡农户
---
pipIrr-platform/pipIrr-global/src/main/java/com/dy/pipIrrGlobal/daoSe/SeVirtualCardMapper.java | 89 ++++++++++++++++++++++++++++++++++++++++++--
1 files changed, 85 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 d042d95..7e4033b 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,13 +2,19 @@
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.List;
+import java.util.Map;
+
/**
* @author ZhuBaoMin
- * @date 2024-04-22 9:38
- * @LastEditTime 2024-04-22 9:38
+ * @date 2024-05-23 16:44
+ * @LastEditTime 2024-05-23 16:44
* @Description
*/
@@ -26,11 +32,86 @@
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(@Param("clientId") Long clientId);
+
+ /**
+ * 鏍规嵁铏氭嫙鍗D鑾峰彇铏氭嫙鍗″璞�
+ * @param vcId
+ * @return
+ */
+ 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) ;
+
+ /**
+ * 鑾峰彇铏氭嫙鍗″厖鍊艰褰�
+ * @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);
}
\ No newline at end of file
--
Gitblit v1.8.0