From b397edee2be2dfcc3f28eeac50298b4de26b1afa Mon Sep 17 00:00:00 2001
From: liurunyu <lry9898@163.com>
Date: 星期五, 13 十二月 2024 16:53:45 +0800
Subject: [PATCH] 取水口日取水量表中，出现一些大数，明显不正确，发析系统日志，发现一些阀控器会上报一些累计流量为0的数据，且无规律，推测是其不能从水表读取到累计流量时会上报0值。如果间歇上报0值，间歇上报一些非0值，非0值减去0值，就会出现大数，一天中出现几次那么会大数进行累加，数值将更大。为此变更算法，规避这种情况，但也会丢失一些流量值。
---
pipIrr-platform/pipIrr-global/src/main/java/com/dy/pipIrrGlobal/daoSe/SeVirtualCardMapper.java | 69 ++++++++++++++++++++++++++++++++++
1 files changed, 68 insertions(+), 1 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 0efdb8a..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
@@ -41,7 +45,7 @@
* 鑾峰彇鍐滄埛鍏ㄩ儴铏氭嫙鍗�
* @return
*/
- List<VoVirtualCard> getVCs(@Param("clientId") Long clientId);
+ List<VoVirtualCard> getVCs(@Param("alarmValue") Integer alarmValue, @Param("clientId") Long clientId);
/**
* 鏍规嵁铏氭嫙鍗D鑾峰彇铏氭嫙鍗″璞�
@@ -49,6 +53,27 @@
* @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
@@ -63,4 +88,46 @@
* @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