From c19de84fa332a00c651f28e3a52292fd14f143a1 Mon Sep 17 00:00:00 2001
From: liurunyu <lry9898@163.com>
Date: 星期二, 23 九月 2025 17:30:07 +0800
Subject: [PATCH] 陆常丽反应软件系统财务对账时而数据不准确,分析源码,找到bug原因是,财务对账统计只有用户点击后才会触发统计功能,把历史上及当天进行了统计,如果当天统计时未下班,例如是中午触发统计了,而下午又进行了充值售水,但下班后未再点击触发对账统计,那么今天的对账统计完成了但数据不对。编写自动任务,在下半夜进行对账统计。

---
 pipIrr-platform/pipIrr-global/src/main/java/com/dy/pipIrrGlobal/daoSe/SeVirtualCardMapper.java |   24 ++++++++++++++++++++----
 1 files changed, 20 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 7e4033b..c4f0df8 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
@@ -8,6 +8,7 @@
 import org.apache.ibatis.annotations.Mapper;
 import org.apache.ibatis.annotations.Param;
 
+import java.util.Date;
 import java.util.List;
 import java.util.Map;
 
@@ -44,12 +45,12 @@
      * 鑾峰彇鍐滄埛鍏ㄩ儴铏氭嫙鍗�
      * @return
      */
-    List<VoVirtualCard> getVCs(@Param("clientId") Long clientId);
+    List<VoVirtualCard> getVCs(@Param("alarmValue") Integer alarmValue, @Param("clientId") Long clientId);
 
     /**
      * 鏍规嵁铏氭嫙鍗D鑾峰彇铏氭嫙鍗″璞�
-     * @param vcId
-     * @return
+     * @param vcId 铏氭嫙鍗D
+     * @return 铏氭嫙鍗″璞�
      */
     VoVirtualCard getVcById(@Param("vcId") Long vcId);
 
@@ -93,7 +94,7 @@
      * @param intakeId
      * @return
      */
-    void updateVcCardNoUseStateByIntakeId(@Param("intakeId")Long intakeId) ;
+    void updateVcCardNoUseStateByIntakeId(@Param("intakeId")Long intakeId, @Param("now")Date now) ;
 
     /**
      * 鑾峰彇铏氭嫙鍗″厖鍊艰褰�
@@ -114,4 +115,19 @@
      * @param money
      */
     void updateMoney(@Param("id")Long id , @Param("money")Double money);
+
+    /**
+     * 鏍规嵁鍐滄埛ID鍙婅櫄鎷熷崱ID鑾峰彇姝e父鐘舵�佺殑铏氭嫙鍗″璞★紝閿�鍗′娇鐢�
+     * @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