From 8297013f990a5440fa8bebb8c0eb9fb0f6af4862 Mon Sep 17 00:00:00 2001
From: zuoxiao <lf_zuo@163.com>
Date: 星期三, 25 六月 2025 09:30:26 +0800
Subject: [PATCH] feat(card): 添加管理卡状态枚举并更新相关逻辑

---
 pipIrr-platform/pipIrr-web/pipIrr-web-terminal/src/main/java/com/dy/pipIrrTerminal/card/CardSv.java |  762 ++++++++++++++++++++++++++++++++++++++++++++++++++++++++--
 1 files changed, 732 insertions(+), 30 deletions(-)

diff --git a/pipIrr-platform/pipIrr-web/pipIrr-web-terminal/src/main/java/com/dy/pipIrrTerminal/card/CardSv.java b/pipIrr-platform/pipIrr-web/pipIrr-web-terminal/src/main/java/com/dy/pipIrrTerminal/card/CardSv.java
index af93c99..674f238 100644
--- a/pipIrr-platform/pipIrr-web/pipIrr-web-terminal/src/main/java/com/dy/pipIrrTerminal/card/CardSv.java
+++ b/pipIrr-platform/pipIrr-web/pipIrr-web-terminal/src/main/java/com/dy/pipIrrTerminal/card/CardSv.java
@@ -1,29 +1,30 @@
 package com.dy.pipIrrTerminal.card;
 
 import com.dy.common.webUtil.BaseResponseUtils;
+import com.dy.common.webUtil.QueryResultVo;
 import com.dy.pipIrrGlobal.daoPr.PrWaterPriceMapper;
-import com.dy.pipIrrGlobal.daoSe.SeCardOperateMapper;
-import com.dy.pipIrrGlobal.daoSe.SeClientCardMapper;
-import com.dy.pipIrrGlobal.daoSe.SeClientMapper;
-import com.dy.pipIrrGlobal.daoSe.SeRechargeHistoryMapper;
+import com.dy.pipIrrGlobal.daoSe.*;
 import com.dy.pipIrrGlobal.pojoSe.SeCardOperate;
 import com.dy.pipIrrGlobal.pojoSe.SeClientCard;
+import com.dy.pipIrrGlobal.pojoSe.SeManagementCard;
 import com.dy.pipIrrGlobal.pojoSe.SeRechargeHistory;
-import com.dy.pipIrrGlobal.voSe.VoAfterRecharge;
-import com.dy.pipIrrGlobal.voSe.VoTermActiveCard;
-import com.dy.pipIrrGlobal.voSe.VoTermRecharge;
+import com.dy.pipIrrGlobal.voSe.*;
 import com.dy.pipIrrTerminal.card.dto.*;
+import com.dy.pipIrrTerminal.card.qo.QoCards;
+import com.dy.pipIrrTerminal.card.qo.QoLostCards;
 import com.dy.pipIrrTerminal.card.enums.CardStateENUM;
 import com.dy.pipIrrTerminal.card.enums.LastOperateENUM;
+import com.dy.pipIrrTerminal.card.enums.ManagementCardStateENUM;
 import com.dy.pipIrrTerminal.card.enums.OperateTypeENUM;
 import com.dy.pipIrrTerminal.card.enums.RechargeTypeENUM;
 import lombok.extern.slf4j.Slf4j;
+import org.apache.dubbo.common.utils.PojoUtils;
 import org.springframework.beans.factory.annotation.Autowired;
 import org.springframework.beans.factory.annotation.Value;
 import org.springframework.stereotype.Service;
 import org.springframework.transaction.annotation.Transactional;
+import com.dy.common.util.IDLongGenerator;
 
-import java.time.Duration;
 import java.time.LocalDateTime;
 import java.time.format.DateTimeFormatter;
 import java.util.*;
@@ -53,11 +54,21 @@
     @Autowired
     private SeRechargeHistoryMapper seRechargeHistoryMapper;
 
+    @Autowired
+    private SeManagerCardMapper seManagerCardMapper;
+
+    @Autowired
+    private SeManagementCardMapper seManagementCardMapper;
+
+    @Autowired
+    private IDLongGenerator idLongGenerator;
+
     @Value("${project.projectNo}")
     private Integer projectNo;
 
     /**
      * 鏍规嵁姘村崱鍦板潃鍒ゆ柇璇ュ崱鏄惁鍙互寮�鍗�
+     * 
      * @param cardAddr
      * @return true:鍙互寮�鍗�
      */
@@ -79,6 +90,7 @@
 
     /**
      * 鏍规嵁姘村崱缂栧彿鍒ゆ柇璇ュ崱鏄惁鍙互鍏呭��
+     * 
      * @param po
      * @return true:鍙互鍏呭��
      */
@@ -89,7 +101,7 @@
 
         String stateName = Optional.ofNullable(seClientCardMapper.getCardStateByCardNum(po.getCardNum())).orElse("");
         // 鍗曠嫭鍏呭�兼椂鍗$墖蹇呴』涓烘甯�
-        if((po.getRechargeType() == RechargeTypeENUM.RECHARGE.getCode()) && !stateName.equals("姝e父")) {
+        if ((po.getRechargeType() == RechargeTypeENUM.RECHARGE.getCode()) && !stateName.equals("姝e父")) {
             map.put("msg", stateName + ", " + "姘村崱鐘舵�佷笉鏀寔褰撳墠鎿嶄綔");
             return map;
         }
@@ -100,6 +112,7 @@
 
     /**
      * 鏍规嵁姘村崱缂栧彿鍒ゆ柇璇ュ崱鏄惁鍙互鎸傚け
+     * 
      * @param po
      * @return true:鍙互鎶ュけ
      */
@@ -110,7 +123,7 @@
 
         Long cardNum = po.getCardNum();
         String stateName = seClientCardMapper.getCardStateByCardNum(cardNum);
-        if(stateName == null || stateName.equals("") || !stateName.equals("姝e父")) {
+        if (stateName == null || stateName.equals("") || !stateName.equals("姝e父")) {
             map.put("msg", stateName + ", " + "姘村崱鐘舵�佷笉鏀寔褰撳墠鎿嶄綔");
             return map;
         }
@@ -126,7 +139,42 @@
         CardSimple card = new CardSimple();
         card.setCardId(Long.parseLong(map_card.get("cardId").toString()));
         card.setClientId(Long.parseLong(map_card.get("clientId").toString()));
-        //card.setProtocol(map_card.get("protocol").toString());
+        // card.setProtocol(map_card.get("protocol").toString());
+
+        map.put("success", true);
+        map.put("content", card);
+        return map;
+    }
+
+    /**
+     * 鏍规嵁姘村崱缂栧彿鍒ゆ柇璇ュ崱鏄惁鍙互瑙i攣
+     * 
+     * @param po
+     * @return
+     */
+    public Map canUnlock(DtoUnlock po) {
+        Map map = new HashMap<>();
+        map.put("success", false);
+        map.put("content", null);
+
+        Long cardNum = po.getCardNum();
+        // 鍒ゆ柇褰撳墠姘村崱鏄惁涓烘寕澶辩姸鎬佷笖鏈ˉ鍗★紝浠呭凡缁忔寕澶卞叾鏈ˉ鍗$殑鍙互瑙i攣
+        if (!isLostAndUnreplaced(cardNum)) {
+            map.put("msg", "姘村崱鐘舵�佷笉鏀寔褰撳墠鎿嶄綔");
+            return map;
+        }
+
+        /**
+         * 渚濇嵁姘村崱缂栧彿鑾峰彇姘村崱琛ㄤ富閿強鍐滄埛缂栧彿
+         */
+        Map map_card = Optional.ofNullable(seClientCardMapper.getCardIdAndClientNum(cardNum)).orElse(new HashMap());
+        if (map_card == null || map_card.size() <= 0) {
+            map.put("msg", "鍗″彿閿欒锛岃鍗′笉瀛樺湪");
+            return map;
+        }
+        CardSimple card = new CardSimple();
+        card.setCardId(Long.parseLong(map_card.get("cardId").toString()));
+        card.setClientId(Long.parseLong(map_card.get("clientId").toString()));
 
         map.put("success", true);
         map.put("content", card);
@@ -135,6 +183,7 @@
 
     /**
      * 鏍规嵁姘村崱缂栧彿鍒ゆ柇璇ュ崱鏄惁鍙互琛ュ崱
+     * 
      * @param po
      * @return true:鍙互琛ュ崱
      */
@@ -146,7 +195,7 @@
         Long cardNum = po.getCardNum();
         Integer lostCount = seClientCardMapper.getLostCount(cardNum);
         Integer replacedCount = seClientCardMapper.getReplacedCount(cardNum);
-        if(lostCount == 0 || replacedCount > 0) {
+        if (lostCount == 0 || replacedCount > 0) {
             map.put("msg", "姘村崱鏈寕澶辨垨宸茶ˉ鍗★紝涓嶈兘琛ュ崱");
             return map;
         }
@@ -177,7 +226,113 @@
     }
 
     /**
+     * 鏍规嵁姘村崱缂栧彿鍒ゆ柇璇ュ崱鏄惁鍙互娉ㄩ攢
+     * 
+     * @param po
+     * @return
+     */
+    public Map canCancel(DtoCancel po) {
+        Map map = new HashMap<>();
+        map.put("success", false);
+        map.put("content", null);
+
+        Long cardNum = po.getCardNum();
+        String stateName = seClientCardMapper.getCardStateByCardNum(cardNum);
+        if (stateName == null || stateName.equals("") || !stateName.equals("姝e父")) {
+            map.put("msg", stateName + ", " + "姘村崱鐘舵�佷笉鏀寔褰撳墠鎿嶄綔");
+            return map;
+        }
+
+        /**
+         * 渚濇嵁姘村崱缂栧彿鑾峰彇姘村崱琛ㄤ富閿強鍐滄埛缂栧彿
+         */
+        Map map_card = Optional.ofNullable(seClientCardMapper.getCardIdAndClientNum(cardNum)).orElse(new HashMap());
+        if (map_card == null || map_card.size() <= 0) {
+            map.put("msg", "鍗″彿閿欒锛岃鍗′笉瀛樺湪");
+            return map;
+        }
+        CardSimple card = new CardSimple();
+        card.setCardId(Long.parseLong(map_card.get("cardId").toString()));
+        card.setClientId(Long.parseLong(map_card.get("clientId").toString()));
+
+        map.put("success", true);
+        map.put("content", card);
+        return map;
+    }
+
+    /**
+     * 鏍规嵁姘村崱缂栧彿鍒ゆ柇璇ュ崱鏄惁鍙互琛ユ墸
+     * 
+     * @param po
+     * @return
+     */
+    public Map canRepay(DtoRepaySupplement po) {
+        Map map = new HashMap<>();
+        map.put("success", false);
+        map.put("content", null);
+
+        Long cardNum = po.getCardNum();
+        String stateName = seClientCardMapper.getCardStateByCardNum(cardNum);
+        if (stateName == null || stateName.equals("") || !stateName.equals("姝e父")) {
+            map.put("msg", stateName + ", " + "姘村崱鐘舵�佷笉鏀寔褰撳墠鎿嶄綔");
+            return map;
+        }
+
+        /**
+         * 渚濇嵁姘村崱缂栧彿鑾峰彇姘村崱琛ㄤ富閿強鍐滄埛缂栧彿
+         */
+        Map map_card = Optional.ofNullable(seClientCardMapper.getCardIdAndClientNum(cardNum)).orElse(new HashMap());
+        if (map_card == null || map_card.size() <= 0) {
+            map.put("msg", "鍗″彿閿欒锛岃鍗′笉瀛樺湪");
+            return map;
+        }
+        CardSimple card = new CardSimple();
+        card.setCardId(Long.parseLong(map_card.get("cardId").toString()));
+        card.setClientId(Long.parseLong(map_card.get("clientId").toString()));
+
+        map.put("success", true);
+        map.put("content", card);
+        return map;
+    }
+
+    /**
+     * 鏍规嵁姘村崱缂栧彿鍒ゆ柇璇ュ崱鏄惁鍙互杩旇繕
+     * 
+     * @param po
+     * @return
+     */
+    public Map canSupplement(DtoRepaySupplement po) {
+        Map map = new HashMap<>();
+        map.put("success", false);
+        map.put("content", null);
+
+        Long cardNum = po.getCardNum();
+        String stateName = seClientCardMapper.getCardStateByCardNum(cardNum);
+        if (stateName == null || stateName.equals("") || !stateName.equals("姝e父")) {
+            map.put("msg", stateName + ", " + "姘村崱鐘舵�佷笉鏀寔褰撳墠鎿嶄綔");
+            return map;
+        }
+
+        /**
+         * 渚濇嵁姘村崱缂栧彿鑾峰彇姘村崱琛ㄤ富閿強鍐滄埛缂栧彿
+         */
+        Map map_card = Optional.ofNullable(seClientCardMapper.getCardIdAndClientNum(cardNum)).orElse(new HashMap());
+        if (map_card == null || map_card.size() <= 0) {
+            map.put("msg", "鍗″彿閿欒锛岃鍗′笉瀛樺湪");
+            return map;
+        }
+        CardSimple card = new CardSimple();
+        card.setCardId(Long.parseLong(map_card.get("cardId").toString()));
+        card.setClientId(Long.parseLong(map_card.get("clientId").toString()));
+
+        map.put("success", true);
+        map.put("content", card);
+        return map;
+    }
+
+    /**
      * 鏍规嵁鍐滄埛缂栧彿鑾峰彇5绾ц鏀垮尯鍒掍覆areaCode锛岃ˉ鍗¤繃绋嬩腑寮�鏂板崱浣跨敤
+     * 
      * @param clientId
      * @return
      */
@@ -299,6 +454,7 @@
 
     /**
      * 寮�鍗¢檮鍔犲厖鍊�
+     * 
      * @param po
      * @param cardNum
      * @return
@@ -332,6 +488,7 @@
 
     /**
      * 婵�娲绘垨琛ュ崱
+     * 
      * @param po
      * @return
      */
@@ -349,7 +506,7 @@
         }
 
         Map map_cardNum = generateCardNum(po.getClientId());
-        if(map_cardNum.get("success").equals(false)) {
+        if (map_cardNum.get("success").equals(false)) {
             map.put("msg", map_cardNum.get("msg").toString());
             return map;
         }
@@ -357,14 +514,14 @@
 
         String orderNo = generateOrderNo();
         Map map_addCardAndOperate = addCardAndOperate(po, cardNum, orderNo);
-        if(map_addCardAndOperate.get("success").equals(false)) {
+        if (map_addCardAndOperate.get("success").equals(false)) {
             map.put("msg", map_addCardAndOperate.get("msg").toString());
             return map;
         }
 
         if (amount != null && amount > 0 && originalCardId == null) {
             Map map_plusRecharge = plusRecharge(po, cardNum, orderNo);
-            if(map_plusRecharge.get("success").equals(false)) {
+            if (map_plusRecharge.get("success").equals(false)) {
                 map.put("msg", map_plusRecharge.get("msg").toString());
                 return map;
             }
@@ -389,6 +546,7 @@
 
     /**
      * 鍏呭��
+     * 
      * @param po
      * @return
      */
@@ -399,7 +557,7 @@
         map.put("content", null);
 
         Map map_canRecharge = canRecharge(po);
-        if(map_canRecharge.get("success").equals(false)) {
+        if (map_canRecharge.get("success").equals(false)) {
             map.put("msg", map_canRecharge.get("msg").toString());
             return map;
         }
@@ -414,7 +572,7 @@
         }
         Long cardId = Long.parseLong(map_cardAndClient.get("cardId").toString());
         Long clientId = Long.parseLong(map_cardAndClient.get("clientId").toString());
-        if(orderNo == null || orderNo.length() <= 0) {
+        if (orderNo == null || orderNo.length() <= 0) {
             orderNo = generateOrderNo();
         }
 
@@ -467,10 +625,11 @@
             return map;
         }
 
-        VoTermRecharge voTermRecharge = new VoTermRecharge();
+        VoTermCommon voTermRecharge = new VoTermCommon();
         voTermRecharge.setProjectNo(projectNo);
         voTermRecharge.setCardNum(po.getCardNum());
         voTermRecharge.setOrderNo(orderNo);
+        voTermRecharge.setBalance(afterRecharge);
 
         map.put("success", true);
         map.put("msg", "鎿嶄綔鎴愬姛");
@@ -480,6 +639,7 @@
 
     /**
      * 琛ュ崱
+     * 
      * @param po
      * @return
      */
@@ -490,7 +650,7 @@
         map.put("content", null);
 
         Map map_canReissue = canReissue(po);
-        if(map_canReissue.get("success").equals(false)) {
+        if (map_canReissue.get("success").equals(false)) {
             map.put("msg", map_canReissue.get("msg").toString());
             return map;
         }
@@ -522,6 +682,12 @@
         return map;
     }
 
+    /**
+     * 鎸傚け
+     * 
+     * @param po
+     * @return
+     */
     @Transactional(rollbackFor = Exception.class)
     public Map reportLoss(DtoLoss po) {
         Map map = new HashMap<>();
@@ -529,7 +695,7 @@
         map.put("content", null);
 
         Map map_canReportLoss = canReportLoss(po);
-        if(map_canReportLoss.get("success").equals(false)) {
+        if (map_canReportLoss.get("success").equals(false)) {
             map.put("msg", map_canReportLoss.get("msg").toString());
             return map;
         }
@@ -546,7 +712,8 @@
         seClientCard.setLossdtdt(new Date());
         seClientCard.setState(CardStateENUM.LOSS.getCode());
         seClientCard.setLastoper(LastOperateENUM.LOSS.getCode());
-        Integer rec_updateClientCard = Optional.ofNullable(seClientCardMapper.updateByPrimaryKeySelective(seClientCard)).orElse(0);
+        Integer rec_updateClientCard = Optional.ofNullable(seClientCardMapper.updateByPrimaryKeySelective(seClientCard))
+                .orElse(0);
         if (rec_updateClientCard == 0) {
             map.put("msg", "鎸傚け澶辫触-鍐滄埛鍗′慨鏀瑰紓甯�");
             return map;
@@ -575,7 +742,226 @@
     }
 
     /**
+     * 瑙i攣
+     * 
+     * @param po
+     * @return
+     */
+    @Transactional(rollbackFor = Exception.class)
+    public Map unlock(DtoUnlock po) {
+        Map map = new HashMap<>();
+        map.put("success", false);
+        map.put("content", null);
+
+        Map map_canUnlock = canUnlock(po);
+        if (map_canUnlock.get("success").equals(false)) {
+            map.put("msg", map_canUnlock.get("msg").toString());
+            return map;
+        }
+        CardSimple card = (CardSimple) map_canUnlock.get("content");
+        Long cardId = card.getCardId();
+        Long clientId = card.getClientId();
+
+        /**
+         * 淇敼鍐滄埛鍗′俊鎭細
+         * 鎸傚け鏃堕棿
+         * 鏈�鍚庢搷浣滅被鍨�-4
+         */
+        SeClientCard seClientCard = new SeClientCard();
+        seClientCard.setId(cardId);
+        seClientCard.setUnlockdt(new Date());
+        seClientCard.setMoney(po.getMoney());
+        seClientCard.setState(CardStateENUM.NORMAL.getCode());
+        seClientCard.setLastoper(LastOperateENUM.UNLOCK.getCode());
+        Integer rec_updateClientCard = Optional.ofNullable(seClientCardMapper.updateByPrimaryKeySelective(seClientCard))
+                .orElse(0);
+        if (rec_updateClientCard == 0) {
+            map.put("msg", "瑙i攣澶辫触-鍐滄埛鍗′慨鏀瑰紓甯�");
+            return map;
+        }
+
+        /**
+         * 娣诲姞瑙i攣璁板綍
+         */
+        SeCardOperate seCardOperate = new SeCardOperate();
+        seCardOperate.setCardId(cardId);
+        seCardOperate.setClientId(clientId);
+        seCardOperate.setMoney(po.getMoney());
+        seCardOperate.setOperateType(OperateTypeENUM.UNLOCK.getCode());
+        seCardOperate.setRemarks(po.getRemarks());
+        seCardOperate.setOperator(po.getOperator());
+        seCardOperate.setOperateDt(new Date());
+        seCardOperate.setOperateValid((byte) 2);
+        seCardOperateMapper.insert(seCardOperate);
+        Long rec = Optional.ofNullable(seCardOperate.getId()).orElse(0L);
+        if (rec == 0) {
+            map.put("msg", "瑙i攣澶辫触-瑙i攣璁板綍鍐欏叆寮傚父");
+            return map;
+        }
+
+        map.put("success", true);
+        map.put("msg", "鎿嶄綔鎴愬姛");
+        return map;
+    }
+
+    /**
+     * 閿�鍗�
+     * 
+     * @param po
+     * @return
+     */
+    @Transactional(rollbackFor = Exception.class)
+    public Map cancel(DtoCancel po) {
+        Map map = new HashMap<>();
+        map.put("success", false);
+        map.put("content", null);
+        String orderNo = generateOrderNo();
+
+        Map map_canCancel = canCancel(po);
+        if (map_canCancel.get("success").equals(false)) {
+            map.put("msg", map_canCancel.get("msg").toString());
+            return map;
+        }
+        CardSimple card = (CardSimple) map_canCancel.get("content");
+        Long cardId = card.getCardId();
+        Long clientId = card.getClientId();
+
+        SeCardOperate seCardOperate = new SeCardOperate();
+        seCardOperate.setCardId(cardId);
+        seCardOperate.setClientId(clientId);
+        seCardOperate.setTradeAmount(-po.getRefund());
+        seCardOperate.setPaymentId(po.getRefundType());
+        seCardOperate.setOperateType(OperateTypeENUM.CANCEL.getCode());
+        seCardOperate.setRemarks(po.getRemarks());
+        seCardOperate.setOperator(po.getOperator());
+        seCardOperate.setOperateDt(new Date());
+        seCardOperate.setOrderNo(orderNo);
+        seCardOperate.setOperateValid((byte) 1);
+        seCardOperateMapper.insert(seCardOperate);
+        if (seCardOperate.getId() == 0) {
+            map.put("msg", "閿�鍗″け璐�-閿�鍗¤褰曞啓鍏ュ紓甯�");
+            return map;
+        }
+
+        VoTermCommon voTermCandel = new VoTermCommon();
+        voTermCandel.setProjectNo(projectNo);
+        voTermCandel.setCardNum(po.getCardNum());
+        voTermCandel.setOrderNo(orderNo);
+
+        map.put("success", true);
+        map.put("msg", "鎿嶄綔鎴愬姛");
+        map.put("content", voTermCandel);
+        return map;
+    }
+
+    /**
+     * 琛ユ墸
+     * 
+     * @param po
+     * @return
+     */
+    @Transactional(rollbackFor = Exception.class)
+    public Map repay(DtoRepaySupplement po) {
+        Map map = new HashMap<>();
+        map.put("success", false);
+        map.put("content", null);
+        String orderNo = generateOrderNo();
+        Date operateTime = new Date();
+        Double waterPrice = Optional.ofNullable(prWaterPriceMapper.getPrice()).orElse(0.0);
+
+        Map map_canRepay = canRepay(po);
+        if (map_canRepay.get("success").equals(false)) {
+            map.put("msg", map_canRepay.get("msg").toString());
+            return map;
+        }
+        CardSimple card = (CardSimple) map_canRepay.get("content");
+        Long cardId = card.getCardId();
+        Long clientId = card.getClientId();
+
+        SeCardOperate seCardOperate = new SeCardOperate();
+        seCardOperate.setCardId(cardId);
+        seCardOperate.setClientId(clientId);
+        seCardOperate.setMoney(po.getBalance());
+        seCardOperate.setRefundAmount(po.getRepayMorny());
+        seCardOperate.setOperateType(OperateTypeENUM.REFUND.getCode());
+        seCardOperate.setRemarks(po.getRemarks());
+        seCardOperate.setOperator(po.getOperator());
+        seCardOperate.setOperateDt(operateTime);
+        seCardOperate.setOrderNo(orderNo);
+        seCardOperate.setOperateValid((byte) 1);
+        seCardOperateMapper.insert(seCardOperate);
+        if (seCardOperate.getId() == 0) {
+            map.put("msg", "琛ユ墸澶辫触-琛ユ墸璁板綍鍐欏叆寮傚父");
+            return map;
+        }
+
+        VoRepaySupplement voRepaySupplement = new VoRepaySupplement();
+        voRepaySupplement.setBalance(po.getBalance() - po.getRepayMorny());
+        voRepaySupplement.setWaterPrice(waterPrice);
+        voRepaySupplement.setTime(operateTime);
+        voRepaySupplement.setOrderNo(orderNo);
+
+        map.put("success", true);
+        map.put("msg", "鎿嶄綔鎴愬姛");
+        map.put("content", voRepaySupplement);
+        return map;
+    }
+
+    /**
+     * 杩旇繕
+     * 
+     * @param po
+     * @return
+     */
+    @Transactional(rollbackFor = Exception.class)
+    public Map supplement(DtoRepaySupplement po) {
+        Map map = new HashMap<>();
+        map.put("success", false);
+        map.put("content", null);
+        String orderNo = generateOrderNo();
+        Date operateTime = new Date();
+        Double waterPrice = Optional.ofNullable(prWaterPriceMapper.getPrice()).orElse(0.0);
+
+        Map map_canSupplement = canSupplement(po);
+        if (map_canSupplement.get("success").equals(false)) {
+            map.put("msg", map_canSupplement.get("msg").toString());
+            return map;
+        }
+        CardSimple card = (CardSimple) map_canSupplement.get("content");
+        Long cardId = card.getCardId();
+        Long clientId = card.getClientId();
+
+        SeCardOperate seCardOperate = new SeCardOperate();
+        seCardOperate.setCardId(cardId);
+        seCardOperate.setClientId(clientId);
+        seCardOperate.setMoney(po.getBalance());
+        seCardOperate.setRefundAmount(po.getSupplementMoney());
+        seCardOperate.setOperateType(OperateTypeENUM.WRITE_BACK.getCode());
+        seCardOperate.setRemarks(po.getRemarks());
+        seCardOperate.setOperator(po.getOperator());
+        seCardOperate.setOperateDt(operateTime);
+        seCardOperate.setOrderNo(orderNo);
+        seCardOperate.setOperateValid((byte) 1);
+        seCardOperateMapper.insert(seCardOperate);
+        if (seCardOperate.getId() == 0) {
+            map.put("msg", "杩旇繕澶辫触-杩旇繕璁板綍鍐欏叆寮傚父");
+            return map;
+        }
+        VoRepaySupplement voRepaySupplement = new VoRepaySupplement();
+        voRepaySupplement.setBalance(po.getBalance() + po.getSupplementMoney());
+        voRepaySupplement.setWaterPrice(waterPrice);
+        voRepaySupplement.setTime(operateTime);
+        voRepaySupplement.setOrderNo(orderNo);
+
+        map.put("success", true);
+        map.put("msg", "鎿嶄綔鎴愬姛");
+        map.put("content", voRepaySupplement);
+        return map;
+    }
+
+    /**
      * 鎿嶄綔鍥炶皟
+     * 
      * @param po
      * @return
      */
@@ -595,15 +981,15 @@
             return map;
         }
 
-        if(operateType == 1) {
+        if (operateType == 1) {
             /**
              * 寮�鍗℃搷浣滄墽琛岄�氱煡
-             *  1.渚濇嵁璁㈠崟鍙峰皢鏃犳晥鐘舵�佺殑鎿嶄綔璁板綍鏀逛负鏈夋晥
-             *  2.渚濇嵁姘村崱ID灏嗘棤鏁堢姸鎬佺殑姘村崱璁板綍鏀逛负鏈夋晥
-             *  3.濡傛灉寮�鍗″悓姝ュ厖鍊�
-             *      淇敼鍏呭�兼搷浣滆褰曚负鏈夋晥
-             *      淇敼鍏呭�煎巻鍙茶褰曚负鏈夋晥
-             *      淇敼姘村崱琛ㄧ殑鎿嶄綔淇℃伅
+             * 1.渚濇嵁璁㈠崟鍙峰皢鏃犳晥鐘舵�佺殑鎿嶄綔璁板綍鏀逛负鏈夋晥
+             * 2.渚濇嵁姘村崱ID灏嗘棤鏁堢姸鎬佺殑姘村崱璁板綍鏀逛负鏈夋晥
+             * 3.濡傛灉寮�鍗″悓姝ュ厖鍊�
+             * 淇敼鍏呭�兼搷浣滆褰曚负鏈夋晥
+             * 淇敼鍏呭�煎巻鍙茶褰曚负鏈夋晥
+             * 淇敼姘村崱琛ㄧ殑鎿嶄綔淇℃伅
              */
             Integer rec_ope = turnOperateValidByOrderNumber(orderNumber);
             Integer rec_card = turnCardValidByOrderNumber(orderNumber);
@@ -612,10 +998,73 @@
                 return map;
             }
 
-            if(isMergeRecharge(cardId)) {
+            if (isMergeRecharge(cardId)) {
                 turnOperateValidByOrderNumber(orderNumber + "p");
                 turnRechargeHistoryValidByOrderNumber(orderNumber);
-                updateCard(cardId, orderNumber+"p");
+                updateCard(cardId, orderNumber + "p");
+            }
+        } else if (operateType == 2) {
+            /**
+             * 鍏呭�兼搷浣滄墽琛岄�氱煡
+             * 1. 鎿嶄綔璁板綍鏀逛负鏈夋晥
+             * 2. 鍏呭�煎巻鍙茶褰曟敼涓烘湁鏁�
+             * 3. 淇敼姘村崱琛ㄧ殑鎿嶄綔淇℃伅
+             */
+            turnOperateValidByOrderNumber(orderNumber + "p");
+            turnRechargeHistoryValidByOrderNumber(orderNumber);
+            updateCard(cardId, orderNumber + "p");
+        } else if (operateType == 3) {
+            /**
+             * 閿�鍗℃搷浣滄墽琛岄�氱煡
+             * 1. 鎿嶄綔璁板綍鏀逛负鏈夋晥
+             * 2. 淇敼姘村崱琛ㄦ搷浣滀俊鎭強浣欓
+             */
+
+            Integer rec_ope = turnOperateValidByOrderNumber(orderNumber);
+            Integer rec_card = updateCardInfo(cardId, orderNumber);
+            if (rec_ope == 0 || rec_card == 0) {
+                map.put("msg", "閿�鍗″洖璋冨け璐�");
+                return map;
+            }
+
+        } else if (operateType == 4) {
+            /**
+             * 琛ュ崱鎿嶄綔鎵ц閫氱煡
+             * 1. 鏂版按鍗¤褰曟敼涓烘湁鏁�
+             * 2. 寮�鍗℃搷浣滆褰曟敼涓烘湁鏁�
+             * 3. 濡傛灉瀛樺湪閫�杩橀噾棰�
+             * 娓呯┖鍘熷崱浣欓
+             */
+            Integer rec_card = turnCardValidByOrderNumber(orderNumber);
+            Integer rec_ope = turnOperateValidByOrderNumber(orderNumber);
+            emptyCardBalance(orderNumber);
+            if (rec_card == 0 || rec_ope == 0) {
+                map.put("msg", "琛ュ崱鍥炶皟澶辫触");
+                return map;
+            }
+        } else if (operateType == 5) {
+            /**
+             * 琛ユ墸鎿嶄綔鎵ц閫氱煡
+             * 1. 鎿嶄綔璁板綍鏀逛负鏈夋晥
+             * 2. 淇敼姘村崱琛ㄦ搷浣滀俊鎭強浣欓
+             */
+            Integer rec_ope = turnOperateValidByOrderNumber(orderNumber);
+            Integer rec_card = updateCardInfo_repay(cardId, orderNumber);
+            if (rec_ope == 0 || rec_card == 0) {
+                map.put("msg", "琛ユ墸鍥炶皟澶辫触");
+                return map;
+            }
+        } else if (operateType == 6) {
+            /**
+             * 杩旇繕鎿嶄綔鎵ц閫氱煡
+             * 1. 鎿嶄綔璁板綍鏀逛负鏈夋晥
+             * 2. 淇敼姘村崱琛ㄦ搷浣滀俊鎭強浣欓
+             */
+            Integer rec_ope = turnOperateValidByOrderNumber(orderNumber);
+            Integer rec_card = updateCardInfo_supplement(cardId, orderNumber);
+            if (rec_ope == 0 || rec_card == 0) {
+                map.put("msg", "杩旇繕鍥炶皟澶辫触");
+                return map;
             }
         }
 
@@ -663,4 +1112,257 @@
         }
         return true;
     }
+
+    /**
+     * 濡傛灉琛ュ崱鏃堕��杩樹簡閲戦锛屾竻绌烘寕澶卞崱浣欓
+     * 
+     * @param orderNumber
+     */
+    public Integer emptyCardBalance(String orderNumber) {
+        Integer rec_empty = 0;
+        Float noTradeAmount = seCardOperateMapper.getNoTradeAmount(orderNumber);
+        if (noTradeAmount != null && noTradeAmount > 0) {
+            rec_empty = seClientCardMapper.emptyCardBalance(orderNumber);
+        }
+        return rec_empty;
+    }
+
+    /**
+     * 淇敼娉ㄩ攢姘村崱琛ㄧ殑璁板綍鍙婁綑棰濓紙0锛�
+     * 
+     * @param orderNumber
+     * @return
+     */
+    public Integer updateCardInfo(Long cardId, String orderNumber) {
+        Date operateTime = seCardOperateMapper.getOperateTime(orderNumber);
+
+        SeClientCard clientCard = new SeClientCard();
+        clientCard.setId(cardId);
+        clientCard.setCanceldt(operateTime);
+        clientCard.setMoney(0f);
+        clientCard.setState(CardStateENUM.CANCELLED.getCode());
+        clientCard.setLastoper(LastOperateENUM.CANCEL.getCode());
+        return seClientCardMapper.updateByPrimaryKeySelective(clientCard);
+    }
+
+    /**
+     * 淇敼琛ユ墸姘村崱琛ㄨ褰曞強浣欓
+     * 
+     * @param cardId
+     * @param orderNumber
+     * @return
+     */
+    public Integer updateCardInfo_repay(Long cardId, String orderNumber) {
+        VoRepaySupplementSimple po = seCardOperateMapper.getCardOperateByOrderNumber(orderNumber);
+        Float money = Optional.ofNullable(po.getMoney()).orElse(0f);
+        Float refundAmount = Optional.ofNullable(po.getRefundAmount()).orElse(0f);
+        Date operateTime = po.getOperateTime();
+
+        SeClientCard clientCard = new SeClientCard();
+        clientCard.setId(cardId);
+        clientCard.setRefunddt(operateTime);
+        clientCard.setMoney(money - refundAmount);
+        clientCard.setState(CardStateENUM.NORMAL.getCode());
+        clientCard.setLastoper(LastOperateENUM.REFUND.getCode());
+        return seClientCardMapper.updateByPrimaryKeySelective(clientCard);
+    }
+
+    /**
+     * 淇敼杩旇繕姘村崱琛ㄨ褰曞強浣欓
+     * 
+     * @param cardId
+     * @param orderNumber
+     * @return
+     */
+    public Integer updateCardInfo_supplement(Long cardId, String orderNumber) {
+        VoRepaySupplementSimple po = seCardOperateMapper.getCardOperateByOrderNumber(orderNumber);
+        Float money = Optional.ofNullable(po.getMoney()).orElse(0f);
+        Float refundAmount = Optional.ofNullable(po.getRefundAmount()).orElse(0f);
+        Date operateTime = po.getOperateTime();
+
+        SeClientCard clientCard = new SeClientCard();
+        clientCard.setId(cardId);
+        clientCard.setRefunddt(operateTime);
+        clientCard.setMoney(money + refundAmount);
+        clientCard.setState(CardStateENUM.NORMAL.getCode());
+        clientCard.setLastoper(LastOperateENUM.WRITE_BACK.getCode());
+        return seClientCardMapper.updateByPrimaryKeySelective(clientCard);
+    }
+
+    /**
+     * 鍒ゆ柇鎸囧畾姘村崱鏄惁涓烘寕澶辩姸鎬佷笖鏃犺ˉ鍗¤褰�
+     * 
+     * @param cardNum
+     * @return
+     */
+    public Boolean isLostAndUnreplaced(Long cardNum) {
+        Integer lostCount = seClientCardMapper.getLostCount(cardNum);
+        Integer replacedCount = seClientCardMapper.getReplacedCount(cardNum);
+        if (lostCount > 0 && replacedCount == 0) {
+            return true;
+        }
+        return false;
+    }
+
+    /**
+     * 璇诲彇姘村崱淇℃伅
+     * 
+     * @param cardAddr
+     * @return
+     */
+    public VoTermCard readCard(String cardAddr) {
+        VoTermCard voTermCard = seClientCardMapper.getTermCardInfo(cardAddr);
+        if (voTermCard != null) {
+            return voTermCard;
+        }
+
+        VoTermCard voTermManagerCard = seManagerCardMapper.getTermManagerCardInfo(cardAddr);
+        if (voTermManagerCard != null) {
+            return voTermManagerCard;
+        }
+
+        return null;
+    }
+
+    /**
+     * 鏍规嵁鎸囧畾鏉′欢鑾峰彇姘村崱鍒楄〃
+     * 
+     * @param vo 鏌ヨ鏉′欢
+     * @return 姘村崱鍒楄〃
+     */
+    public QueryResultVo<List<VoCards>> getCards(QoCards vo) {
+        Map<String, Object> params = (Map<String, Object>) PojoUtils.generalize(vo);
+        Long itemTotal = seClientCardMapper.getCardsCount(params);
+
+        QueryResultVo<List<VoCards>> rsVo = new QueryResultVo<>();
+        rsVo.pageSize = vo.pageSize;
+        rsVo.pageCurr = vo.pageCurr;
+
+        if (itemTotal > 0) {
+            rsVo.calculateAndSet(itemTotal, params);
+            List<VoCards> list = seClientCardMapper.getCards(params);
+            rsVo.obj = list;
+        } else {
+            rsVo.obj = new ArrayList<>();
+            rsVo.itemTotal = 0L;
+        }
+
+        return rsVo;
+    }
+
+    /**
+     * 鑾峰彇宸叉寕澶辩殑姘村崱鍒楄〃
+     * 
+     * @param vo 鏌ヨ鏉′欢
+     * @return 宸叉寕澶辩殑姘村崱鍒楄〃
+     */
+    public QueryResultVo<List<VoCards>> getLostCards(QoLostCards vo) {
+        Map<String, Object> params = new HashMap<>();
+        params.put("pageCurr", vo.pageCurr);
+        params.put("pageSize", vo.pageSize);
+        params.put("state", 2); // 鎸傚け鐘舵��
+
+        Long itemTotal = seClientCardMapper.getLostCardsCount(params);
+
+        QueryResultVo<List<VoCards>> rsVo = new QueryResultVo<>();
+        rsVo.pageSize = vo.pageSize;
+        rsVo.pageCurr = vo.pageCurr;
+
+        if (itemTotal > 0) {
+            rsVo.calculateAndSet(itemTotal, params);
+            List<VoCards> list = seClientCardMapper.getLostCards(params);
+            rsVo.obj = list;
+        } else {
+            rsVo.obj = new ArrayList<>();
+            rsVo.itemTotal = 0L;
+        }
+
+        return rsVo;
+    }
+
+    /**
+     * 鏍规嵁姘村崱缂栧彿鑾峰彇鍗′俊鎭�
+     * 
+     * @param cardNum 姘村崱缂栧彿
+     * @return 鍗′俊鎭�
+     */
+    public VoCardByClientNum getCardByCardNum(String cardNum) {
+        return seClientCardMapper.getCardByCardNum(cardNum);
+    }
+
+    /**
+     * 鍒涘缓绠$悊鍗�
+     * 
+     * @param dto 鍒涘缓绠$悊鍗TO
+     * @return 鍒涘缓缁撴灉
+     */
+    @Transactional(rollbackFor = Exception.class)
+    public Map<String, Object> createManagementCard(CreateManagementCardDto dto) {
+        Map<String, Object> result = new HashMap<>();
+        result.put("success", false);
+
+        try {
+            // 妫�鏌ュ崱鍦板潃鏄惁宸插瓨鍦�
+            if (isCardAddrExists(dto.getCardAddr())) {
+                result.put("msg", "鍒涘缓澶辫触-姝ゅ崱鍦板潃宸插瓨鍦�");
+                return result;
+            }
+
+            // 鍙傝�僼ermActiveCard閫昏緫锛氱敓鎴愯鍗曞彿
+            String orderNo = generateOrderNo();
+
+            // 浣跨敤IDLongGenerator鐢熸垚鍞竴ID
+            Long id = idLongGenerator.generate();
+            Date createTime = new Date();
+
+            // 鏋勫缓绠$悊鍗″璞�
+            SeManagementCard managementCard = SeManagementCard.builder()
+                    .id(id)
+                    .protocol(dto.getProtocol())
+                    .cardAddr(dto.getCardAddr())
+                    .securityCode(dto.getSecurityCode())
+                    .cardType(dto.getCardType())
+                    .createTime(createTime)
+                    .orderNo(orderNo)
+                    .districtCode(dto.getDistrictCode())
+                    .projectNo(dto.getProjectNo() != null ? dto.getProjectNo() : this.projectNo)
+                    .ip(dto.getIp())
+                    .domain(dto.getDomain())
+                    .openClostTime(dto.getOpenClostTime())
+                    .remarks(dto.getRemarks())
+                    .state(ManagementCardStateENUM.NORMAL.getCode()) // 榛樿鐘舵�佷负姝e父
+                    .build();
+
+            // 鎻掑叆鏁版嵁搴�
+            int insertResult = seManagementCardMapper.insertSelective(managementCard);
+
+            if (insertResult > 0) {
+                result.put("success", true);
+                result.put("content", orderNo); // 杩斿洖璁㈠崟鍙�
+                result.put("msg", "璇锋眰鎴愬姛");
+            } else {
+                result.put("msg", "绠$悊鍗″垱寤哄け璐�-鏁版嵁搴撴彃鍏ュ紓甯�");
+            }
+
+        } catch (Exception e) {
+            log.error("鍒涘缓绠$悊鍗″紓甯�: {}", e.getMessage(), e);
+            result.put("msg", "绠$悊鍗″垱寤哄け璐�: " + e.getMessage());
+        }
+
+        return result;
+    }
+
+    /**
+     * 妫�鏌ュ崱鐗囧湴鍧�鏄惁宸插瓨鍦�
+     * 
+     * @param cardAddr 鍗$墖鍦板潃
+     * @return true-宸插瓨鍦紝false-涓嶅瓨鍦�
+     */
+    public boolean isCardAddrExists(String cardAddr) {
+        // 浣跨敤涓�娆℃煡璇㈡鏌ヤ袱涓〃涓槸鍚﹀瓨鍦ㄨ鍗″湴鍧�
+        // 1. 绠$悊鍗¤〃锛氭墍鏈夎褰曢兘妫�鏌�
+        // 2. 鍐滄埛姘村崱琛細鍙鏌ユ甯�(1)鍜屾寕澶�(3)鐘舵�佺殑璁板綍
+        Long totalCount = seClientCardMapper.checkCardAddrExists(cardAddr);
+        return totalCount != null && totalCount > 0;
+    }
 }

--
Gitblit v1.8.0