From 9f3c4a33279f10ed420d604765487558ab0744f0 Mon Sep 17 00:00:00 2001
From: zhubaomin <zhubaomin>
Date: 星期五, 11 四月 2025 11:42:21 +0800
Subject: [PATCH] 获取已完成灌溉计划接口增加分页功能
---
pipIrr-platform/pipIrr-web/pipIrr-web-wechat/src/main/java/com/dy/pipIrrWechat/virtualCard/VirtualCardSv.java | 208 +++++++++++++++++++++++++++++++++++++++++++++++----
1 files changed, 190 insertions(+), 18 deletions(-)
diff --git a/pipIrr-platform/pipIrr-web/pipIrr-web-wechat/src/main/java/com/dy/pipIrrWechat/virtualCard/VirtualCardSv.java b/pipIrr-platform/pipIrr-web/pipIrr-web-wechat/src/main/java/com/dy/pipIrrWechat/virtualCard/VirtualCardSv.java
index 7cd6de0..a0912b9 100644
--- a/pipIrr-platform/pipIrr-web/pipIrr-web-wechat/src/main/java/com/dy/pipIrrWechat/virtualCard/VirtualCardSv.java
+++ b/pipIrr-platform/pipIrr-web/pipIrr-web-wechat/src/main/java/com/dy/pipIrrWechat/virtualCard/VirtualCardSv.java
@@ -3,13 +3,20 @@
import com.dy.common.webUtil.BaseResponse;
import com.dy.common.webUtil.BaseResponseUtils;
import com.dy.common.webUtil.QueryResultVo;
+import com.dy.pipIrrGlobal.daoPr.PrIntakeMapper;
+import com.dy.pipIrrGlobal.daoPr.PrIntakeVcMapper;
import com.dy.pipIrrGlobal.daoSe.*;
+import com.dy.pipIrrGlobal.pojoIr.IrPlanOperate;
+import com.dy.pipIrrGlobal.pojoPr.PrIntakeVc;
import com.dy.pipIrrGlobal.pojoSe.*;
+import com.dy.pipIrrGlobal.voPr.VoIntakeSimple;
import com.dy.pipIrrGlobal.voSe.VoOrders;
import com.dy.pipIrrGlobal.voSe.VoRechargeProfile;
import com.dy.pipIrrGlobal.voSe.VoVcRecharge;
import com.dy.pipIrrGlobal.voSe.VoVirtualCard;
+import com.dy.pipIrrWechat.irrigatePlan.enums.OperateTypeENUM;
import com.dy.pipIrrWechat.result.WechatResultCode;
+import com.dy.pipIrrWechat.virtualCard.dto.DtoRegist;
import com.dy.pipIrrWechat.virtualCard.dto.DtoVirtualCard;
import com.dy.pipIrrWechat.virtualCard.enums.LastOperateENUM;
import com.dy.pipIrrWechat.virtualCard.enums.OrderStateENUM;
@@ -21,9 +28,7 @@
import org.springframework.stereotype.Service;
import org.springframework.transaction.annotation.Transactional;
-import java.util.Date;
-import java.util.List;
-import java.util.Map;
+import java.util.*;
/**
* @author ZhuBaoMin
@@ -56,11 +61,18 @@
@Autowired
private SeRechargeProfileMapper seRechargeProfileMapper;
+ @Autowired
+ private PrIntakeMapper prIntakeMapper;
+
+ @Autowired
+ private PrIntakeVcMapper prIntakeVcMapper;
+
@Value("${vc.alarmValue}")
private Integer alarmValue;
/**
* 鏍规嵁鍐滄埛ID鑾峰彇5绾ц鏀垮尯鍒掍唬鐮侊紝娉ㄥ唽铏氭嫙鍗′娇鐢�
+ *
* @param clientId 鍐滄埛ID
* @return 5绾ц鏀垮尯鍒掍唬鐮�
*/
@@ -70,6 +82,7 @@
/**
* 鑾峰彇鍐滄埛鍏ㄩ儴铏氭嫙鍗�
+ *
* @return
*/
public List<VoVirtualCard> getVCs(Long clientId) {
@@ -78,6 +91,7 @@
/**
* 鏍规嵁铏氭嫙鍗D鑾峰彇铏氭嫙鍗″璞�
+ *
* @param vcId
* @return
*/
@@ -87,6 +101,7 @@
/**
* 娉ㄥ唽铏氭嫙鍗�
+ *
* @param po
* @return
*/
@@ -97,16 +112,18 @@
/**
* 鏍规嵁鍐滄埛ID鍙婅櫄鎷熷崱ID鑾峰彇姝ｅ父鐘舵�佺殑铏氭嫙鍗″璞�
+ *
* @param clientId
* @param vcId
* @return
*/
- public SeVirtualCard getVcByClientIdAndVcId (Long clientId, Long vcId) {
+ public SeVirtualCard getVcByClientIdAndVcId(Long clientId, Long vcId) {
return seVirtualCardMapper.getVcByClientIdAndVcId(clientId, vcId);
}
/**
* 鏍规嵁铏氭嫙鍗D娉ㄩ攢铏氭嫙鍗�
+ *
* @param clientId
* @param vcId
* @return
@@ -117,6 +134,7 @@
/**
* 鏍规嵁琛屾斂鍖哄垝涓叉ā绯婃煡璇㈣櫄鎷熷崱缂栧彿锛屾敞鍐岃櫄鎷熷崱浣跨敤
+ *
* @param areaCode
* @return
*/
@@ -136,6 +154,7 @@
/**
* 淇敼铏氭嫙鍗�
* 鍏呭�笺�佹秷璐广�佺敵璇烽��娆俱�佸鏍搁��娆炬椂闇�瑕佷慨鏀硅櫄鎷熷崱鐨勶細浣欓銆佹渶鍚庢搷浣溿�佹渶鍚庢搷浣滄椂闂�
+ *
* @param po
* @return
*/
@@ -145,6 +164,7 @@
/**
* 鏍规嵁铏氭嫙鍗＄紪鍙疯幏鍙栬櫄鎷熷崱瀵硅薄
+ *
* @param virtualId
* @return
*/
@@ -155,6 +175,7 @@
/**
* 娣诲姞铏氭嫙鍗″厖鍊艰褰�
* JSAPI涓嬪崟鍚庣敓鎴愰儴鍒嗗厖鍊艰褰�
+ *
* @param po
* @return -1锛氳櫄鎷熷崱涓嶅瓨鍦紝0锛氭坊鍔犲厖鍊艰褰曞け璐�
*/
@@ -168,7 +189,7 @@
// 楠岃瘉璇ヨ櫄鎷熷崱璐︽埛鏄惁瀛樺湪骞跺彇鍑哄綋鍓嶈处鎴蜂綑棰�
SeVirtualCard seVirtualCard = seVirtualCardMapper.selectByPrimaryKey(virtualId);
- if(seVirtualCard == null) {
+ if (seVirtualCard == null) {
return -1L;
}
Double money = seVirtualCard.getMoney();
@@ -184,7 +205,7 @@
seVcRecharge.setOrderState(OrderStateENUM.NON_PAYMENT.getCode());
seVcRechargeMapper.insert(seVcRecharge);
Long rechargeId = seVcRecharge.getId();
- if(rechargeId == null) {
+ if (rechargeId == null) {
return 0L;
}
return rechargeId;
@@ -192,6 +213,7 @@
/**
* 鏍规嵁璁㈠崟鍙疯幏鍙栬櫄鎷熷崱鍏呭�煎璞�
+ *
* @param orderNumber
* @return
*/
@@ -202,15 +224,16 @@
/**
* 淇敼铏氭嫙鍗″厖鍊艰褰�
* 寰俊鏀粯閫氱煡鍚庯細
- * 1. 鏇存柊鍏呭�艰〃锛氬厖鍊煎悗浣欓銆佹敮浠樺畬鎴愭椂闂淬�佽鍗曠姸鎬�
- * 2. 鏇存柊铏氭嫙鍗¤〃锛氳处鎴蜂綑棰濄�佹渶鍚庢搷浣溿�佹渶鍚庢搷浣滄椂闂�
+ * 1. 鏇存柊鍏呭�艰〃锛氬厖鍊煎悗浣欓銆佹敮浠樺畬鎴愭椂闂淬�佽鍗曠姸鎬�
+ * 2. 鏇存柊铏氭嫙鍗¤〃锛氳处鎴蜂綑棰濄�佹渶鍚庢搷浣溿�佹渶鍚庢搷浣滄椂闂�
+ *
* @param orderNumber 璁㈠崟缂栧彿
* @return
*/
@Transactional(rollbackFor = Exception.class)
public BaseResponse<Boolean> updateVCRecharge(String orderNumber, Date rechargeTime) {
SeVcRecharge seVcRecharge = seVcRechargeMapper.getVCRechargeByorderNumber(orderNumber);
- if(seVcRecharge == null) {
+ if (seVcRecharge == null) {
return BaseResponseUtils.buildFail(WechatResultCode.RECHARGE_NOT_EXIST.getMessage());
}
@@ -223,27 +246,28 @@
seVcRecharge.setRechargeTime(rechargeTime);
seVcRecharge.setOrderState(OrderStateENUM.PAID.getCode());
Integer rec = seVcRechargeMapper.updateByPrimaryKeySelective(seVcRecharge);
- if(rec == null) {
+ if (rec == null) {
return BaseResponseUtils.buildFail(WechatResultCode.RECHARGE_FAIL.getMessage());
}
SeVirtualCard seVirtualCard = seVirtualCardMapper.selectByPrimaryKey(virtualId);
- if(seVirtualCard == null) {
+ if (seVirtualCard == null) {
return BaseResponseUtils.buildFail(WechatResultCode.VIRTUAL_CARD_NOT_EXIST.getMessage());
}
seVirtualCard.setMoney(afterRrecharge);
seVirtualCard.setLastOperate(LastOperateENUM.RECHARGE.getCode());
seVirtualCard.setLastOperateTime(new Date());
Integer rec2 = seVirtualCardMapper.updateByPrimaryKeySelective(seVirtualCard);
- if(rec2 == null) {
+ if (rec2 == null) {
return BaseResponseUtils.buildFail(WechatResultCode.RECHARGE_FAIL.getMessage());
}
- return BaseResponseUtils.buildSuccess(true) ;
+ return BaseResponseUtils.buildSuccess(true);
}
/**
* 淇敼铏氭嫙鍗″厖鍊艰褰曪紙搴熷純锛�
* 寰俊灏忕▼搴忔敮浠橀�氱煡鍚庝慨鏀癸細浣欓銆佸厖鍊煎悗浣欓銆佸厖鍊煎畬鎴愭椂闂�
+ *
* @param po
* @return
*/
@@ -253,16 +277,18 @@
/**
* 鏍规嵁铏氭嫙鍗″彿鑾峰彇璁㈠崟鍒楄〃
+ *
* @param virtualId
* @return
*/
public List<VoOrders> selectOrders(Long virtualId) {
List<VoOrders> rsVo = seVcRechargeMapper.getOrders(virtualId);
- return rsVo ;
+ return rsVo;
}
/**
* 鏍规嵁閫�娆綢D鑾峰彇閫�娆惧璞�
+ *
* @param refundId
* @return
*/
@@ -272,6 +298,7 @@
/**
* 娣诲姞閫�娆剧敵璇�
+ *
* @param po
* @return
*/
@@ -282,6 +309,7 @@
/**
* 淇敼閫�娆捐褰�
+ *
* @param po
* @return
*/
@@ -291,6 +319,7 @@
/**
* 鏍规嵁璁㈠崟鍙疯幏鍙栧叾鍚勭瑪閫�娆鹃噾棰�
+ *
* @param orderNumber
* @return
*/
@@ -301,6 +330,7 @@
/**
* 娣诲姞閫�娆惧垎椤�
+ *
* @param po
* @return
*/
@@ -311,6 +341,7 @@
/**
* 缂栬緫閫�娆惧垎椤�
+ *
* @param po
* @return
*/
@@ -320,22 +351,24 @@
/**
* 鏍规嵁璁㈠崟鍙风敓鎴愰��娆惧崟鍙�
+ *
* @param orderNumber
* @return
*/
public String generateRefundNumber(String orderNumber) {
String refundNumber = seVcRefundItemMapper.getLastRefundNumber(orderNumber);
- if(refundNumber == null) {
+ if (refundNumber == null) {
refundNumber = orderNumber + "01";
return refundNumber;
}
- String a = String.format("%02d", (Integer.parseInt(refundNumber.substring(29,30).trim()) + 1));
- return a;
+ String a = String.format("%02d", (Integer.parseInt(refundNumber.substring(29, 30).trim()) + 1));
+ return a;
}
/**
* 鏍规嵁璁㈠崟鍙疯幏鍙栧厖鍊奸噾棰濓紝璋冪敤閫�娆剧敵璇锋帴鍙ｄ娇鐢�
+ *
* @param orderNumber
* @return
*/
@@ -346,6 +379,7 @@
/**
* 鏍规嵁閫�娆鹃�氱煡鎺ュ彛杩斿洖鐨勯��娆惧崟鍙峰弽鏌ラ��娆綢D锛屾煡璇㈣閫�娆綢D涓嬫湭閫�娆捐褰曟暟閲�
+ *
* @param refundNumber
* @return
*/
@@ -355,6 +389,7 @@
/**
* 鏍规嵁閫�娆惧崟鍙疯幏鍙栭��娆綢D锛岄��娆鹃�氱煡鍚庢洿鏂伴��娆捐〃鎵�闇�
+ *
* @param refundNumber
* @return
*/
@@ -364,10 +399,11 @@
/**
* 鑾峰彇铏氭嫙鍗″厖鍊艰褰�
+ *
* @param dtoVcRecharge
* @return
*/
- public QueryResultVo<List<VoVcRecharge>> getVcRechargeRecords(QoVcRecharge dtoVcRecharge){
+ public QueryResultVo<List<VoVcRecharge>> getVcRechargeRecords(QoVcRecharge dtoVcRecharge) {
Map<String, Object> params = (Map<String, Object>) PojoUtils.generalize(dtoVcRecharge);
Long itemTotal = seVirtualCardMapper.getRechargeRecordCount(params);
@@ -383,6 +419,7 @@
/**
* 娣诲姞铏氭嫙鍗℃搷浣滆褰�
+ *
* @param po
* @return
*/
@@ -393,9 +430,144 @@
/**
* 鑾峰彇铏氭嫙鍗″父鐢ㄥ厖鍊奸噾棰濋厤缃�
+ *
* @return
*/
public List<VoRechargeProfile> gerRechargeProfiles() {
return seRechargeProfileMapper.gerRechargeProfiles();
}
+
+ /**
+ * 娉ㄥ唽铏氭嫙鍗�
+ *
+ * @param clientId
+ * @return
+ */
+ public Map addVC(Long clientId, Double money) {
+ // 鑾峰彇5绾ц鏀垮尯鍒掍覆areaCode
+ Long areaCodeL = getAreaCodeById(clientId);
+ if (areaCodeL == null) {
+ Map map = new HashMap<>();
+ map.put("success", false);
+ map.put("msg", WechatResultCode.AREA_CODE_MISTAKE.getMessage());
+ map.put("content", null);
+ return map;
+ }
+ String areaCode = String.valueOf(areaCodeL);
+
+ /**
+ * 鏍规嵁琛屾斂鍖哄垝涓诧紙areaCode锛夊湪铏氭嫙鍗¤〃涓拡瀵硅櫄鎷熷崱缂栧彿锛坴cNum锛夎繘琛屾ā绯婃煡璇�
+ * 濡傛灉5浣嶉『搴忓彿宸茬粡杈惧埌鏈�澶у�硷紝鎻愮ず鐢ㄦ埛鑱旂郴绯荤粺绠＄悊鍛�
+ * 濡傛灉5浣嶉『搴忓彿鏈揪鍒版渶澶у�硷紝鍒欏姞1
+ * cardNum涓烘柊鐨勫崱鍙�
+ */
+ String vcNum = Optional.ofNullable(getVcCardNumOfMax(areaCode)).orElse("");
+ if (vcNum != null && vcNum.trim().length() > 0) {
+ Integer number = Integer.parseInt(vcNum.substring(12));
+ number = number + 1;
+ if (number > 65535) {
+ Map map = new HashMap<>();
+ map.put("success", false);
+ map.put("msg", WechatResultCode.CARD_NUMBER_OVERRUN.getMessage());
+ map.put("content", null);
+ return map;
+ }
+ vcNum = vcNum.substring(0, 12) + String.format("%05d", number);
+ } else {
+ vcNum = areaCode + "00001";
+ }
+
+ // 鐢熸垚铏氭嫙鍗¤褰�
+ SeVirtualCard seVirtualCard = new SeVirtualCard();
+ seVirtualCard.setVcNum(Long.parseLong(vcNum));
+ seVirtualCard.setClientId(clientId);
+ seVirtualCard.setMoney(money);
+ seVirtualCard.setState((byte) 1);
+ seVirtualCard.setLastOperate(LastOperateENUM.OPEN_ACCOUNT.getCode());
+ seVirtualCard.setLastOperateTime(new Date());
+ seVirtualCard.setInUse((byte) 0);
+ seVirtualCard.setCreateTime(new Date());
+ Long vcId = insertVirtualCard(seVirtualCard);
+ if (vcId == null) {
+ Map map = new HashMap<>();
+ map.put("success", false);
+ map.put("msg", WechatResultCode.VC_OPEN_ACCOUNT_FAIL.getMessage());
+ map.put("content", null);
+ return map;
+ }
+
+ // 鐢熸垚铏氭嫙鍗℃搷浣滆褰曪紝娉ㄥ唽铏氭嫙鍗℃搷浣滀汉涓哄啘鎴�
+ SeVcOperate seVcOperate = new SeVcOperate();
+ seVcOperate.setVcId(vcId);
+ seVcOperate.setClientId(clientId);
+ seVcOperate.setOperateType(LastOperateENUM.OPEN_ACCOUNT.getCode());
+ seVcOperate.setOperator(clientId);
+ seVcOperate.setOperateTime(new Date());
+ Long vcOperateId = insertVcOperate(seVcOperate);
+ if (vcOperateId == null) {
+ Map map = new HashMap<>();
+ map.put("success", false);
+ map.put("msg", WechatResultCode.VC_OPEN_ACCOUNT_FAIL.getMessage());
+ map.put("content", null);
+ return map;
+ }
+
+ Map map = new HashMap<>();
+ map.put("success", true);
+ map.put("msg", "铏氭嫙鍗℃敞鍐屾垚鍔�");
+ map.put("content", vcId);
+ return map;
+ }
+
+ /**
+ * 鑾峰彇鏈粦瀹氳櫄鎷熷崱鐨勫彇姘村彛鍒楄〃锛岀粰鍙栨按鍙ｇ粦铏氭嫙鍗′娇鐢�
+ *
+ * @return
+ */
+ public Map linkVcToIntake(Long clientId) {
+ // 楠岃瘉鏄惁瀛樺湪鍙栨按鍙ｆ湭缁戣櫄鎷熷崱
+ List<VoIntakeSimple> list = prIntakeMapper.getNotLinkVcIntakes();
+ if (list == null || list.size() == 0) {
+ Map map = new HashMap<>();
+ map.put("success", true);
+ map.put("msg", "鎵�鏈夊彇姘村彛閮藉尮閰嶄簡铏氭嫙鍗�");
+ map.put("content", null);
+ return map;
+ }
+
+ // 閬嶅巻鎵�鏈夋湭缁戣櫄鎷熷崱鐨勫彇姘村彛
+ for (VoIntakeSimple voIntakeSimple : list) {
+ Long intakeId = voIntakeSimple.getIntakeId();
+
+ // 鍒涘缓铏氭嫙鍗�
+ Map map_result = addVC(clientId, 100000D);
+ if (map_result.get("success").equals(false)) {
+ Map map = new HashMap<>();
+ map.put("success", false);
+ map.put("msg", "鐏岃櫄鎷熷崱娉ㄥ唽澶辫触");
+ map.put("content", null);
+ return map;
+ }
+ Long vcId = (Long) map_result.get("content");
+
+ // 鍙栨按鍙ｇ粦铏氭嫙鍗�
+ PrIntakeVc intakeVc = new PrIntakeVc();
+ intakeVc.setIntakeId(intakeId);
+ intakeVc.setVcId(vcId);
+ Integer result = prIntakeVcMapper.insert(intakeVc);
+
+ if (result == null) {
+ Map map = new HashMap<>();
+ map.put("success", false);
+ map.put("msg", "鍙栨按鍙ｇ粦铏氭嫙鍗″け璐�");
+ map.put("content", null);
+ return map;
+ }
+ }
+ Map map = new HashMap<>();
+ map.put("success", true);
+ map.put("msg", "鍙栨按鍙ｇ粦铏氭嫙鍗℃垚鍔�");
+ map.put("content", null);
+ return map;
+ }
}
\ No newline at end of file
--
Gitblit v1.8.0