From 64a8f7a3be0a5584fe2164a2474b189c79cfab5c Mon Sep 17 00:00:00 2001
From: admin <weikou2014>
Date: 星期六, 28 十二月 2019 18:15:39 +0800
Subject: [PATCH] 小程序接口初步建立
---
fanli/src/main/java/com/yeshi/fanli/service/impl/money/extract/ExtractServiceImpl.java | 566 +++++++++++++++++++++++++++++++++++++------------------
1 files changed, 378 insertions(+), 188 deletions(-)
diff --git a/fanli/src/main/java/com/yeshi/fanli/service/impl/money/extract/ExtractServiceImpl.java b/fanli/src/main/java/com/yeshi/fanli/service/impl/money/extract/ExtractServiceImpl.java
index 4b479cc..6099276 100644
--- a/fanli/src/main/java/com/yeshi/fanli/service/impl/money/extract/ExtractServiceImpl.java
+++ b/fanli/src/main/java/com/yeshi/fanli/service/impl/money/extract/ExtractServiceImpl.java
@@ -147,10 +147,9 @@
@Resource
private OrderUserStatisticService orderUserStatisticService;
-
+
@Resource
private ExtractWeiXinRecordService extractWeiXinRecordService;
-
@Transactional
public Integer addExtract(Extract extract) {
@@ -173,12 +172,23 @@
updateExtract.setId(id);
updateExtract.setState(Extract.STATE_PROCESSING);
extractMapper.updateByPrimaryKeySelective(updateExtract);
+ // TODO 鏂扮増閮ㄧ讲鍚庡垹闄�
+ // 鏀瑰彉璧勯噾璁板綍鐘舵��
+ UserMoneyDetail detail = userMoneyDetailService.selectByTypeAndUidAndIdentifyCode(
+ UserMoneyDetailTypeEnum.extract, find.getUserInfo().getId(), find.getId());
+ if (detail != null) {
+ UserMoneyDetail update = new UserMoneyDetail(detail.getId());
+ update.setShow(true);
+ update.setUpdateTime(new Date());
+ userMoneyDetailMapper.updateByPrimaryKeySelective(update);
+ }
+
transfer(find, admin); // 鎻愮幇閫氳繃锛屾敮浠樺疂杞处
return null;
}
- @Transactional
+ @Transactional(rollbackFor = Exception.class)
public synchronized void rejectExtract(long id, String reason, AdminUser admin)
throws ObjectStateException, NotExistObjectException {
Extract find = extractMapper.selectByPrimaryKey(id);
@@ -318,7 +328,6 @@
LogHelper.userInfo("uid=" + user.getId() + ",鎻愪氦杞处鐢宠!");
} else {// 鏆傛椂涓嶈嚜鍔ㄦ彁鐜�
// transfer(extract, null);
- ;
}
return null;
}
@@ -394,17 +403,17 @@
* @param extract
* @param session
*/
- //TODO 杞处閫昏緫闇�瑕佹敼鍙橈紝鍥哄畾IP
+ // TODO 杞处閫昏緫闇�瑕佹敼鍙橈紝鍥哄畾IP
@Transactional
private void extractByZhiFuBao(Extract extract, AdminUser adminUser) {
- LogHelper.userErrorInfo("鎻愮幇:寮�濮嬮�氳繃鎻愮幇-"+extract.getId());
+ LogHelper.userErrorInfo("鎻愮幇:寮�濮嬮�氳繃鎻愮幇-" + extract.getId());
String privateKey = Constant.alipayConfig.getPrivateKey();
AlipayClient alipayClient = new DefaultAlipayClient("https://openapi.alipay.com/gateway.do",
Constant.alipayConfig.getAppId(), privateKey, "json", "gbk", null, "RSA2");
AlipayFundTransToaccountTransferRequest request = new AlipayFundTransToaccountTransferRequest();
String appName = Constant.systemCommonConfig.getProjectChineseName();
JSONObject json = new JSONObject();
- json.put("out_biz_no", "widthdraw_"+extract.getId());//鏈�闀块暱搴�64浣嶏紝鏀寔鑻辨枃锛屼笅鍒掔嚎锛屾暟瀛�
+ json.put("out_biz_no", "widthdraw_" + extract.getId());// 鏈�闀块暱搴�64浣嶏紝鏀寔鑻辨枃锛屼笅鍒掔嚎锛屾暟瀛�
json.put("payee_type", "ALIPAY_LOGONID");
json.put("payee_account", extract.getAccount());
json.put("amount", extract.getMoney());
@@ -415,17 +424,18 @@
AlipayFundTransToaccountTransferResponse response = null;
try {
response = alipayClient.execute(request);
- LogHelper.userErrorInfo("鎻愮幇:鏀粯瀹濋�氳繃鎻愮幇鎴愬姛-"+extract.getId());
+ LogHelper.userErrorInfo("鎻愮幇:鏀粯瀹濋�氳繃鎻愮幇鎴愬姛-" + extract.getId());
} catch (AlipayApiException e) {
- e.printStackTrace();
+ LogHelper.errorDetailInfo(e, "鏀粯瀹濊浆璐﹀紓甯�:" + extract.getId(), "");
LogHelper.userErrorInfo("鎻愮幇:鏀粯瀹濇彁鐜板紓甯革細" + response + ",鎻愮幇淇℃伅" + GsonUtil.toJson(extract));
}
try {
CMQManager.getInstance().addExtractResultMsg(extract, response, adminUser);
- LogHelper.userErrorInfo("鎻愮幇:娣诲姞澶勭悊闃熷垪鎴愬姛-"+extract.getId());
+ LogHelper.userErrorInfo("鎻愮幇:娣诲姞澶勭悊闃熷垪鎴愬姛-" + extract.getId());
} catch (Exception e) {
- LogHelper.userErrorInfo("鎻愮幇:鏀粯瀹濇彁鐜癈MQ寮傚父锛�" + new Gson().toJson(response) + ",鎻愮幇淇℃伅" + GsonUtil.toJson(extract));
+ LogHelper
+ .userErrorInfo("鎻愮幇:鏀粯瀹濇彁鐜癈MQ寮傚父锛�" + new Gson().toJson(response) + ",鎻愮幇淇℃伅" + GsonUtil.toJson(extract));
}
}
@@ -531,7 +541,7 @@
return extractMapper.selectByPrimaryKey(id);
}
- @Transactional
+ @Transactional(rollbackFor = Exception.class)
@Override
public void checkExtract(Long uid) throws ExtractException {
BigDecimal compensateMoney = extractMapper.computeCompensateByUid(uid);
@@ -683,7 +693,16 @@
// 鏇存柊鎻愮幇璁板綍瀹℃牳琛�
extractAuditRecordMapper.updateByPrimaryKeySelective(auditRecord);
+ }
+ // 澶栨樉璐︽埛鏄庣粏
+ UserMoneyDetail userMoneyDetail = userMoneyDetailMapper.selectByTypeAndUidAndIdentifyCode(
+ UserMoneyDetailTypeEnum.extract, extract.getUserInfo().getId(), extract.getId());
+ if (userMoneyDetail != null) {
+ UserMoneyDetail detail = new UserMoneyDetail(userMoneyDetail.getId());
+ detail.setShow(true);
+ detail.setUpdateTime(new Date());
+ userMoneyDetailMapper.updateByPrimaryKeySelective(detail);
}
}
@@ -737,55 +756,53 @@
}
@Override
- public BigDecimal sumTodayApplyMoney(Long uid,String day) {
- return extractMapper.sumToadyApplyByUid(uid,day);
+ public BigDecimal sumTodayApplyMoney(Long uid, String day) {
+ return extractMapper.sumToadyApplyByUid(uid, day);
}
@Override
public BigDecimal sumVerifyingMoney(Long uid) {
- List<Integer> stateList=new ArrayList<>();
- stateList.add(Extract.STATE_NOT_PROCESS);
- stateList.add(Extract.STATE_PROCESSING);
- BigDecimal money= extractMapper.sumMoneyByUidAndState(uid, stateList);
- if(money==null)
+ List<Integer> stateList = new ArrayList<>();
+ stateList.add(Extract.STATE_NOT_PROCESS);
+ stateList.add(Extract.STATE_PROCESSING);
+ BigDecimal money = extractMapper.sumMoneyByUidAndState(uid, stateList);
+ if (money == null)
return new BigDecimal(0);
else
return money;
}
-
-
-
+
@Transactional(rollbackFor = Exception.class)
@Override
public void autoExtract(UserInfo user) {
- if (user == null || user.getWxOpenId() == null || user.getWxUnionId() == null ||
- user.getState() != UserInfo.STATE_NORMAL)
+ if (user == null || user.getWxOpenId() == null || user.getWxUnionId() == null
+ || user.getState() != UserInfo.STATE_NORMAL)
return;
-
+
Date date = new Date();
BigDecimal money = new BigDecimal(Constant.AUTO_EXTRACT_MONEY);
-
+
// 1銆佹彃鍏ヨ褰�
ExtractWeiXinRecord extractRecord = new ExtractWeiXinRecord();
extractRecord.setUid(user.getId());
extractRecord.setOpenId(user.getWxOpenId());
- extractRecord.setUnionId(user.getWxUnionId() );
+ extractRecord.setUnionId(user.getWxUnionId());
extractRecord.setMoney(money);
extractRecord.setCreateTime(date);
extractRecord.setUpdateTime(date);
extractWeiXinRecordService.insertSelective(extractRecord);
-
+
// 浜ゆ槗鍙�
Long recordId = extractRecord.getId();
String billno = "BanLiExtract" + recordId;
-
+
// 鏇存柊璁板綍
ExtractWeiXinRecord updeteRecord = null;
-
+
String mchId = "1520950211";
String appId = "wx5c0d167c6e3ad726";
String key = "XYJkJ2018FAfaodCCx899mLl138rfGVd";
-
+
// 2銆佸彂鏀惧井淇＄孩鍖�
RedPackParams redPackParams = new RedPackParams();
redPackParams.setBillno(billno);
@@ -800,22 +817,22 @@
redPackParams.setActName("鑷姩鎻愮幇");
redPackParams.setKey(key);
redPackParams.setRemark("寰俊鑷姩鎻愮幇");
- //redPackParams.setSceneId(null);
- //redPackParams.setRiskInfo(null);
-
-
+ // redPackParams.setSceneId(null);
+ // redPackParams.setRiskInfo(null);
+
// 鍙戠敓绾㈠寘鐘舵��
boolean stateRedPack = false;
-
+
String pwd = "1520950211";
- InputStream cert = ExtractServiceImpl.class.getClassLoader().getResourceAsStream("certificate/apiclient_cert.p12"); // 璇诲彇.p12鏂囦欢
+ InputStream cert = ExtractServiceImpl.class.getClassLoader()
+ .getResourceAsStream("certificate/apiclient_cert.p12"); // 璇诲彇.p12鏂囦欢
// 鎵ц鍙戞斁绾㈠寘
try {
String result = WXPayUtil.redPackToOpenId(redPackParams, pwd, cert);
if (!StringUtil.isNullOrEmpty(result)) {
stateRedPack = parseSendResult(result);
}
-
+
if (!stateRedPack) {
String redPackRecord = WXPayUtil.getRedPackRecord(billno, mchId, appId, key, pwd, cert);
if (!StringUtil.isNullOrEmpty(redPackRecord)) {
@@ -834,23 +851,23 @@
} catch (IOException e1) {
e1.printStackTrace();
}
-
+
// 鏇存柊淇℃伅
if (updeteRecord == null) {
updeteRecord = new ExtractWeiXinRecord();
} else {
stateRedPack = true;
}
-
+
updeteRecord.setId(recordId);
updeteRecord.setStatus(ExtractWeiXinRecord.SENDING);
updeteRecord.setBillno(billno);
extractWeiXinRecordService.updateByPrimaryKeySelective(updeteRecord);
-
+
// 绾㈠寘鍙戞斁澶辫触
- if (!stateRedPack)
- return;
-
+ if (!stateRedPack)
+ return;
+
// 3銆佸姞鍏ヨ祫閲戞槑缁�
UserMoneyDetail detail = new UserMoneyDetail();
detail.setCreateTime(new Date());
@@ -865,97 +882,213 @@
} catch (UserMoneyDetailException e) {
LogHelper.errorDetailInfo(e);
}
-
+
// 4銆佸彂閫佹秷鎭�氱煡
String desc = "涓轰繚闅滀綘鐨勮处鎴蜂綑棰濆畨鍏紝鑷姩鎻愮幇閲戦灏嗕笉浼氶珮浜�5鍏�";
String beizu = "璐︽埛涓墿浣欎綑棰濊鍦ㄦ湰App鍐呭畬鎴愭彁鐜�";
userMoneyMsgNotificationService.extractAuto(extractRecord, "鏈鍙�-鎻愮幇涓�", desc, beizu);
}
-
private boolean parseSendResult(String result) {
try {
Document document = DocumentHelper.parseText(result);
// 鑾峰彇鏍硅妭鐐瑰厓绱犲璞�
- Element root = document.getRootElement();
- Element returnCode = root.element("return_code");
-
- if (!"SUCCESS".equalsIgnoreCase(returnCode.getText())) {
- Element returnMsg = root.element("return_msg");
- System.out.println(returnMsg.getText());
- return false;
- }
-
- Element resultCode = root.element("result_code");
- if (!"SUCCESS".equalsIgnoreCase(resultCode.getText())) {
- Element errCode = root.element("err_code");
- Element errCodeDes = root.element("err_code_des");
- System.out.println(errCode.getText() + ":" + errCodeDes.getText());
- return false;
- }
- return true;
+ Element root = document.getRootElement();
+ Element returnCode = root.element("return_code");
+
+ if (!"SUCCESS".equalsIgnoreCase(returnCode.getText())) {
+ Element returnMsg = root.element("return_msg");
+ System.out.println(returnMsg.getText());
+ return false;
+ }
+
+ Element resultCode = root.element("result_code");
+ if (!"SUCCESS".equalsIgnoreCase(resultCode.getText())) {
+ Element errCode = root.element("err_code");
+ Element errCodeDes = root.element("err_code_des");
+ System.out.println(errCode.getText() + ":" + errCodeDes.getText());
+ return false;
+ }
+ return true;
} catch (DocumentException e) {
e.printStackTrace();
LogHelper.errorDetailInfo(e);
}
return false;
}
-
-
+
private ExtractWeiXinRecord parseDTO(String result) {
try {
-
+
Document document = DocumentHelper.parseText(result);
// 鑾峰彇鏍硅妭鐐瑰厓绱犲璞�
- Element root = document.getRootElement();
- Element returnCode = root.element("return_code");
-
- if (!"SUCCESS".equalsIgnoreCase(returnCode.getText())) {
- Element returnMsg = root.element("return_msg");
- System.out.println(returnMsg.getText());
- return null;
- }
-
- Element resultCode = root.element("result_code");
- if (!"SUCCESS".equalsIgnoreCase(resultCode.getText())) {
- Element errCode = root.element("err_code");
- Element errCodeDes = root.element("err_code_des");
- System.out.println(errCode.getText() + ":" + errCodeDes.getText());
- }
-
- ExtractWeiXinRecord resultRecord = new ExtractWeiXinRecord();
- resultRecord.setBillno(root.element("result_code").getText());
- resultRecord.setDetailno(root.element("detail_id").getText());
- resultRecord.setStatus(root.element("status").getText());
- resultRecord.setSendType(root.element("send_type").getText());
- resultRecord.setHbType(root.element("result_code").getText());
-
- String totalNum = root.element("total_num").getText();
- resultRecord.setTotalNum(Integer.parseInt(totalNum));
-
- String sendTime = root.element("send_time").getText();
- resultRecord.setSendTime(new Date(TimeUtil.convertDateToTemp2(sendTime)));
-
- Element element = root.element("hblist");
- Iterator<?> iterator = element.elementIterator();
- while (iterator.hasNext()) {
- Element childElement = (Element)iterator.next();
- Element rcvTime = childElement.element("rcv_time");
- resultRecord.setRcvTime(new Date(TimeUtil.convertDateToTemp2(rcvTime.getText())));
- break;
- }
- return resultRecord;
-
+ Element root = document.getRootElement();
+ Element returnCode = root.element("return_code");
+
+ if (!"SUCCESS".equalsIgnoreCase(returnCode.getText())) {
+ Element returnMsg = root.element("return_msg");
+ System.out.println(returnMsg.getText());
+ return null;
+ }
+
+ Element resultCode = root.element("result_code");
+ if (!"SUCCESS".equalsIgnoreCase(resultCode.getText())) {
+ Element errCode = root.element("err_code");
+ Element errCodeDes = root.element("err_code_des");
+ System.out.println(errCode.getText() + ":" + errCodeDes.getText());
+ }
+
+ ExtractWeiXinRecord resultRecord = new ExtractWeiXinRecord();
+ resultRecord.setBillno(root.element("result_code").getText());
+ resultRecord.setDetailno(root.element("detail_id").getText());
+ resultRecord.setStatus(root.element("status").getText());
+ resultRecord.setSendType(root.element("send_type").getText());
+ resultRecord.setHbType(root.element("result_code").getText());
+
+ String totalNum = root.element("total_num").getText();
+ resultRecord.setTotalNum(Integer.parseInt(totalNum));
+
+ String sendTime = root.element("send_time").getText();
+ resultRecord.setSendTime(new Date(TimeUtil.convertDateToTemp2(sendTime)));
+
+ Element element = root.element("hblist");
+ Iterator<?> iterator = element.elementIterator();
+ while (iterator.hasNext()) {
+ Element childElement = (Element) iterator.next();
+ Element rcvTime = childElement.element("rcv_time");
+ resultRecord.setRcvTime(new Date(TimeUtil.convertDateToTemp2(rcvTime.getText())));
+ break;
+ }
+ return resultRecord;
+
} catch (DocumentException e) {
e.printStackTrace();
LogHelper.errorDetailInfo(e);
}
return null;
}
-
-
+
+ @Override
+ public List<UserInfo> preAutoUser() throws Exception {
+ int page = 0;
+ int pageSize = 100;
+ int maxSize = 300;
+ Date nowDate = new Date();
+ // 涓�銆佽嚜鍔ㄦ彁鐜伴拡瀵圭殑鐢ㄦ埛缇わ細 鍓嶆彁鏉′欢:鐢ㄦ埛鍦ㄨ窛浠�60澶╁埌90澶╁唴鏈椿璺冭繃鐨勭敤鎴�
+ String beganDate = DateUtil.reduceDayTostring(90, nowDate);
+ String endDate = DateUtil.reduceDayTostring(60, nowDate);
+ // 鏉′欢3锛氳窛绂讳笂涓�娆℃垚鍔熼鍙栧井淇＄孩鍖呭凡缁忚秴杩囦簡30澶╂椂闂达紝鍙湪绗�31澶╁啀娆′笅鍙戯紱
+ String receivedDate = DateUtil.reduceDayTostring(30, nowDate);
+ // 鏉′欢4锛氳窛绂讳笂涓�娆℃湭鎴愬姛棰嗗彇寰俊绾㈠寘宸茬粡瓒呰繃浜�15澶╂椂闂达紝鍙湪绗�16澶╁啀娆′笅鍙戯紱
+ String refundDate = DateUtil.reduceDayTostring(15, nowDate);
+
+ // 浣欓鏈�浣庨檺鍒�
+ BigDecimal minSurplus = BigDecimal.valueOf(Constant.AUTO_EXTRACT_MIN_SURPLUS);
+
+ List<UserInfo> list = new ArrayList<UserInfo>();
+
+ while (true) {
+ // 鏌ヨ婊¤冻鏉′欢 1銆�2 鐨剈id
+ List<UserInfo> listUser = userInfoService.getAutoExtractUser(page * pageSize, pageSize, minSurplus,
+ beganDate, endDate);
+ if (listUser == null || listUser.isEmpty())
+ break;
+
+ List<Long> listId = new ArrayList<Long>();
+ for (UserInfo userInfo : listUser) {
+ listId.add(userInfo.getId());
+ }
+
+ // 鏌ヨ璁板綍鏄惁婊¤冻
+ List<Long> listValid = extractWeiXinRecordService.getValidUsers(listId, receivedDate, refundDate);
+ if (listValid == null || listValid.isEmpty()) {
+ page++;
+ continue;
+ }
+
+ for (Long uid : listValid) {
+ if (list.size() >= maxSize)
+ break;
+ for (UserInfo userInfo : listUser) {
+ if (list.size() >= maxSize)
+ break;
+
+ if (userInfo.getId().longValue() == uid.longValue()) {
+ list.add(userInfo);
+ break;
+ }
+ }
+ }
+
+ if (list.size() >= maxSize)
+ break;
+
+ page++;
+ }
+ return list;
+ }
+
@Override
public List<String> getAutoExtractOpenIds() throws Exception {
+ int page = 0;
+ int pageSize = 100;
+ int maxSize = 301; // appId + 瀹為檯openid300涓�
+ Date nowDate = new Date();
+ // 涓�銆佽嚜鍔ㄦ彁鐜伴拡瀵圭殑鐢ㄦ埛缇わ細 鍓嶆彁鏉′欢:鐢ㄦ埛鍦ㄨ窛浠�60澶╁埌90澶╁唴鏈椿璺冭繃鐨勭敤鎴�
+ String beganDate = DateUtil.reduceDayTostring(90, nowDate);
+ String endDate = DateUtil.reduceDayTostring(60, nowDate);
+ // 鏉′欢3锛氳窛绂讳笂涓�娆℃垚鍔熼鍙栧井淇＄孩鍖呭凡缁忚秴杩囦簡30澶╂椂闂达紝鍙湪绗�31澶╁啀娆′笅鍙戯紱
+ String receivedDate = DateUtil.reduceDayTostring(30, nowDate);
+ // 鏉′欢4锛氳窛绂讳笂涓�娆℃湭鎴愬姛棰嗗彇寰俊绾㈠寘宸茬粡瓒呰繃浜�15澶╂椂闂达紝鍙湪绗�16澶╁啀娆′笅鍙戯紱
+ String refundDate = DateUtil.reduceDayTostring(15, nowDate);
+
+ // 鎻愮幇閲戦
+ BigDecimal money = BigDecimal.valueOf(Constant.AUTO_EXTRACT_MONEY);
+ // 浣欓鏈�浣庨檺鍒�
+ BigDecimal minSurplus = BigDecimal.valueOf(Constant.AUTO_EXTRACT_MIN_SURPLUS);
+
+ List<String> listOpendIDs = new ArrayList<String>();
+ // 棣栬appID
+ listOpendIDs.add(Constant.getWXAccount(null, null).getAppId());
+
+ while (true) {
+ // 鏌ヨ婊¤冻鏉′欢 1銆�2 鐨剈id
+ List<UserInfo> listUser = userInfoService.getAutoExtractUser(page * pageSize, pageSize, minSurplus,
+ beganDate, endDate);
+ if (listUser == null || listUser.isEmpty())
+ break;
+
+ List<Long> listId = new ArrayList<Long>();
+ for (UserInfo userInfo : listUser) {
+ listId.add(userInfo.getId());
+ }
+
+ // 鏌ヨ璁板綍鏄惁婊¤冻
+ List<Long> listValid = extractWeiXinRecordService.getValidUsers(listId, receivedDate, refundDate);
+ if (listValid == null || listValid.isEmpty()) {
+ page++;
+ continue;
+ }
+
+ for (Long uid : listValid) {
+ UserInfo userInfo = subHongBaoByUid(uid, money, minSurplus);
+ if (userInfo != null) {
+ listOpendIDs.add(userInfo.getWxOpenId());
+ if (listOpendIDs.size() >= maxSize)
+ break;
+ }
+ }
+
+ if (listOpendIDs.size() >= maxSize)
+ break;
+
+ page++;
+ }
+ return listOpendIDs;
+ }
+
+ @Override
+ public List<UserInfo> preAutoUserTo1212() throws Exception {
int page = 0;
int pageSize = 100;
int maxSize = 300;
@@ -964,52 +1097,107 @@
String receivedDate = DateUtil.reduceDayTostring(30, nowDate);
// 鏉′欢4锛氳窛绂讳笂涓�娆℃湭鎴愬姛棰嗗彇寰俊绾㈠寘宸茬粡瓒呰繃浜�15澶╂椂闂达紝鍙湪绗�16澶╁啀娆′笅鍙戯紱
String refundDate = DateUtil.reduceDayTostring(15, nowDate);
-
- // 鎻愮幇閲戦
- BigDecimal money = BigDecimal.valueOf(Constant.AUTO_EXTRACT_MONEY);
// 浣欓鏈�浣庨檺鍒�
- BigDecimal minSurplus = BigDecimal.valueOf(Constant.AUTO_EXTRACT_MIN_SURPLUS);
-
- List<String> listOpendIDs = new ArrayList<String>();
- // 棣栬appID
- listOpendIDs.add(Constant.getWXAccount(null, null).getAppId());
-
+ List<UserInfo> list = new ArrayList<UserInfo>();
while (true) {
// 鏌ヨ婊¤冻鏉′欢 1銆�2 鐨剈id
- List<Long> listId = userInfoService.getAutoExtractUserIds(page * pageSize, pageSize, minSurplus);
- if (listId == null || listId.isEmpty())
+ List<UserInfo> listUser = userInfoService.getAutoExtractUserTo1212(page * pageSize, pageSize);
+ if (listUser == null || listUser.isEmpty())
break;
-
+
+ List<Long> listId = new ArrayList<Long>();
+ for (UserInfo userInfo : listUser) {
+ listId.add(userInfo.getId());
+ }
+
// 鏌ヨ璁板綍鏄惁婊¤冻
List<Long> listValid = extractWeiXinRecordService.getValidUsers(listId, receivedDate, refundDate);
if (listValid == null || listValid.isEmpty()) {
- page ++;
+ page++;
continue;
}
-
- for (Long uid: listValid) {
- UserInfo userInfo = subHongBaoByUid(uid, money, minSurplus);
+
+ for (Long uid : listValid) {
+ if (list.size() >= maxSize)
+ break;
+ for (UserInfo userInfo : listUser) {
+ if (list.size() >= maxSize)
+ break;
+
+ if (userInfo.getId().longValue() == uid.longValue()) {
+ list.add(userInfo);
+ break;
+ }
+ }
+ }
+
+ if (list.size() >= maxSize)
+ break;
+
+ page++;
+ }
+ return list;
+ }
+
+ @Override
+ public List<String> getAutoExtractOpenIdsTo1212() throws Exception {
+ int page = 0;
+ int pageSize = 100;
+ int maxSize = 301; // appId + 瀹為檯openid300涓�
+ Date nowDate = new Date();
+ // 鏉′欢3锛氳窛绂讳笂涓�娆℃垚鍔熼鍙栧井淇＄孩鍖呭凡缁忚秴杩囦簡30澶╂椂闂达紝鍙湪绗�31澶╁啀娆′笅鍙戯紱
+ String receivedDate = DateUtil.reduceDayTostring(30, nowDate);
+ // 鏉′欢4锛氳窛绂讳笂涓�娆℃湭鎴愬姛棰嗗彇寰俊绾㈠寘宸茬粡瓒呰繃浜�15澶╂椂闂达紝鍙湪绗�16澶╁啀娆′笅鍙戯紱
+ String refundDate = DateUtil.reduceDayTostring(15, nowDate);
+
+ // 鎻愮幇閲戦
+ BigDecimal money = BigDecimal.valueOf(1);
+
+ List<String> listOpendIDs = new ArrayList<String>();
+ // 棣栬appID
+ listOpendIDs.add(Constant.getWXAccount(null, null).getAppId());
+
+ while (true) {
+ // 鏌ヨ婊¤冻鏉′欢 1銆�2 鐨剈id
+ List<UserInfo> listUser = userInfoService.getAutoExtractUserTo1212(page * pageSize, pageSize);
+ if (listUser == null || listUser.isEmpty())
+ break;
+
+ List<Long> listId = new ArrayList<Long>();
+ for (UserInfo userInfo : listUser) {
+ listId.add(userInfo.getId());
+ }
+
+ // 鏌ヨ璁板綍鏄惁婊¤冻
+ List<Long> listValid = extractWeiXinRecordService.getValidUsers(listId, receivedDate, refundDate);
+ if (listValid == null || listValid.isEmpty()) {
+ page++;
+ continue;
+ }
+
+ for (Long uid : listValid) {
+ UserInfo userInfo = subHongBaoByUid(uid, money, money);
if (userInfo != null) {
listOpendIDs.add(userInfo.getWxOpenId());
if (listOpendIDs.size() >= maxSize)
break;
}
}
-
+
if (listOpendIDs.size() >= maxSize)
break;
-
- page ++;
+
+ page++;
}
return listOpendIDs;
}
-
-
-
+
@Transactional(rollbackFor = Exception.class)
private UserInfo subHongBaoByUid(Long uid, BigDecimal money, BigDecimal minSurplus) {
UserInfo userInfo = userInfoMapper.selectByPrimaryKeyForUpdate(uid);
- if (userInfo != null && userInfo.getMyHongBao().compareTo(minSurplus) >= 0) {
+ if (userInfo != null && !StringUtil.isNullOrEmpty(userInfo.getWxOpenId())
+ && !StringUtil.isNullOrEmpty(userInfo.getWxUnionId())
+ && userInfo.getMyHongBao().compareTo(minSurplus) >= 0) {
// 寰俊鎻愮幇璁板綍
ExtractWeiXinRecord extractRecord = new ExtractWeiXinRecord();
extractRecord.setUid(uid);
@@ -1023,17 +1211,17 @@
extractWeiXinRecordService.insertSelective(extractRecord);
// 璁板綍id
Long recordId = extractRecord.getId();
-
+
// 璧勯噾鏄庣粏
UserMoneyDetail detail = new UserMoneyDetail();
detail.setCreateTime(new Date());
detail.setIdentifyCode(StringUtil.Md5(UserMoneyDetailTypeEnum.extractAutoWX.name() + ":" + recordId));
- detail.setMoney(new BigDecimal("-"+ money.toString()));
+ detail.setMoney(new BigDecimal("-" + money.toString()));
detail.setTitle(UserMoneyDetailTypeEnum.extractAutoWX.getDesc());
detail.setType(UserMoneyDetailTypeEnum.extractAutoWX);
detail.setUpdateTime(new Date());
detail.setUserInfo(userInfo);
-
+
// 璧勯噾璁＄畻
userMoneyService.subUserMoney(userInfo.getId(), money, detail);
@@ -1041,55 +1229,53 @@
String desc = "涓轰繚闅滀綘鐨勮处鎴蜂綑棰濆畨鍏紝鑷姩鎻愮幇閲戦灏嗕笉浼氶珮浜�5鍏�";
String beizu = "璐︽埛涓墿浣欎綑棰濊鍦ㄦ湰App鍐呭畬鎴愭彁鐜�";
userMoneyMsgNotificationService.extractAuto(extractRecord, "鏈鍙�-鎻愮幇涓�", desc, beizu);
-
+
// 婊¤冻鏉′欢杩斿洖淇℃伅
return userInfo;
}
return null;
}
-
-
+
@Override
- public void updateManualExtractRecord(List<RedPackRecord> list) throws ExtractException{
+ public void updateManualExtractRecord(List<RedPackRecord> list) throws ExtractException {
if (list == null || list.isEmpty())
throw new ExtractException(1, "绾㈠寘璁板綍淇℃伅涓虹┖");
-
- for (RedPackRecord redPackRecord: list) {
+
+ for (RedPackRecord redPackRecord : list) {
updateWeiXinRecord(redPackRecord);
}
}
-
-
+
@Transactional(rollbackFor = Exception.class)
- private void updateWeiXinRecord(RedPackRecord redPackRecord){
+ private void updateWeiXinRecord(RedPackRecord redPackRecord) {
if (StringUtil.isNullOrEmpty(redPackRecord.getOpenId()))
return;
-
- ExtractWeiXinRecord record = extractWeiXinRecordService.getByOpenIdAndType(redPackRecord.getOpenId(), ExtractWeiXinRecord.TYPE_MANUAL);
+
+ ExtractWeiXinRecord record = extractWeiXinRecordService.getByOpenIdAndType(redPackRecord.getOpenId(),
+ ExtractWeiXinRecord.TYPE_MANUAL);
if (record == null)
return;
-
+
// 鐘舵�佽繃婊�
String statusOld = record.getStatus();
- if (StringUtil.isNullOrEmpty(statusOld) ||ExtractWeiXinRecord.REFUND.equals(statusOld)
- || ExtractWeiXinRecord.RFUND_ING.equals(statusOld))
+ if (StringUtil.isNullOrEmpty(statusOld) || ExtractWeiXinRecord.REFUND.equals(statusOld)
+ || ExtractWeiXinRecord.RECEIVED.equals(statusOld))
return;
-
+
ExtractWeiXinRecord updeteRecord = new ExtractWeiXinRecord();
updeteRecord.setId(record.getId());
updeteRecord.setUpdateTime(new Date());
-
+
String billno = redPackRecord.getBillno();
if (!StringUtil.isNullOrEmpty(billno)) {
- updeteRecord.setBillno(billno.replace("`", ""));
+ updeteRecord.setBillno(billno.replace("`", "").replace("'", ""));
}
-
+
String detailno = redPackRecord.getDetailno();
if (!StringUtil.isNullOrEmpty(detailno)) {
- updeteRecord.setDetailno(detailno.replace("`", ""));
+ updeteRecord.setDetailno(detailno.replace("`", "").replace("'", ""));
}
-
- SimpleDateFormat sdf = new SimpleDateFormat("yyyy/MM/dd HH:mm");
+ SimpleDateFormat sdf = new SimpleDateFormat("yyyy-MM-dd HH:mm");
String rcvTime = redPackRecord.getRcvTime();
if (!StringUtil.isNullOrEmpty(rcvTime)) {
try {
@@ -1098,7 +1284,7 @@
e.printStackTrace();
}
}
-
+
String sendTime = redPackRecord.getSendTime();
if (!StringUtil.isNullOrEmpty(sendTime)) {
try {
@@ -1107,44 +1293,48 @@
e.printStackTrace();
}
}
-
+
String status = redPackRecord.getStatus();
if (!StringUtil.isNullOrEmpty(status)) {
switch (status) {
- case "宸插彂鏀惧緟棰嗗彇":
- status = ExtractWeiXinRecord.SENT;
- break;
- case "杩囨湡鏈閫�娆�":
- status = ExtractWeiXinRecord.REFUND;
- break;
- case "宸查鍙�":
- status = ExtractWeiXinRecord.RECEIVED;
- break;
- default:
- status = null;
- break;
- }
+ case "宸插彂鏀惧緟棰嗗彇":
+ status = ExtractWeiXinRecord.SENT;
+ break;
+ case "杩囨湡鏈閫�娆�":
+ status = ExtractWeiXinRecord.REFUND;
+ break;
+ case "宸查鍙�":
+ status = ExtractWeiXinRecord.RECEIVED;
+ break;
+ default:
+ status = null;
+ break;
+ }
}
updeteRecord.setStatus(status);
-
- // 鏇存柊绾㈠寘璁板綍
extractWeiXinRecordService.updateByPrimaryKeySelective(updeteRecord);
-
- if (!ExtractWeiXinRecord.REFUND.equals(status))
- return;
-
- // 璧勯噾鏄庣粏
- UserMoneyDetail detail = new UserMoneyDetail();
- detail.setCreateTime(new Date());
- detail.setIdentifyCode(StringUtil.Md5(UserMoneyDetailTypeEnum.extractAutoWXRefund.name() + ":" + record.getId()));
- detail.setMoney(record.getMoney());
- detail.setTitle(UserMoneyDetailTypeEnum.extractAutoWXRefund.getDesc());
- detail.setType(UserMoneyDetailTypeEnum.extractAutoWXRefund);
- detail.setUpdateTime(new Date());
- detail.setUserInfo(new UserInfo(record.getUid()));
-
- // 璧勯噾璁＄畻
- userMoneyService.addUserMoney(record.getUid(), record.getMoney(), detail);
+
+ if (ExtractWeiXinRecord.RECEIVED.equals(status)) {
+ // 鍙戦�佹秷鎭�氱煡
+ userMoneyMsgNotificationService.extractAuto(record, "宸查鍙�-宸叉彁鐜�", null, null);
+ } else if (ExtractWeiXinRecord.REFUND.equals(status)) {
+ // 璧勯噾鏄庣粏
+ UserMoneyDetail detail = new UserMoneyDetail();
+ detail.setCreateTime(new Date());
+ detail.setIdentifyCode(
+ StringUtil.Md5(UserMoneyDetailTypeEnum.extractAutoWXRefund.name() + ":" + record.getId()));
+ detail.setMoney(record.getMoney());
+ detail.setTitle(UserMoneyDetailTypeEnum.extractAutoWXRefund.getDesc());
+ detail.setType(UserMoneyDetailTypeEnum.extractAutoWXRefund);
+ detail.setUpdateTime(new Date());
+ detail.setUserInfo(new UserInfo(record.getUid()));
+
+ // 璧勯噾璁＄畻
+ userMoneyService.addUserMoney(record.getUid(), record.getMoney(), detail);
+
+ // 鍙戦�佹秷鎭�氱煡
+ userMoneyMsgNotificationService.extractAuto(record, "宸查��鍥�-浣欓涓�", null, null);
+ }
}
-
+
}
--
Gitblit v1.8.0