| | |
| | | import com.xinquan.common.core.utils.WebUtils; |
| | | import com.xinquan.common.core.utils.page.CollUtils; |
| | | import com.xinquan.common.core.utils.page.PageDTO; |
| | | import com.xinquan.common.core.web.domain.BaseModel; |
| | | import com.xinquan.common.log.enums.BusinessType; |
| | | import com.xinquan.common.redis.service.RedisService; |
| | | import com.xinquan.common.security.service.TokenService; |
| | |
| | | @Autowired |
| | | private RedisService redisService; |
| | | |
| | | |
| | | @PostMapping("/withdrawList") |
| | | @ApiOperation(value = "提现列表-分页", tags = {"管理后台-提现管理"}) |
| | | public R<PageDTO<AppUserWithdraw>> withdrawList(@RequestBody OrderListDTO courseDTO) { |
| | |
| | | if (collect.isEmpty())collect.add(-1L); |
| | | wrapper.in(AppUserWithdraw::getAppUserId,collect); |
| | | } |
| | | if (courseDTO.getPaymentStatus()!=null && courseDTO.getPaymentStatus()==1){ |
| | | wrapper.eq(AppUserWithdraw::getWithdrawStatus,0); |
| | | }else if (courseDTO.getPaymentStatus()!=null &&(courseDTO.getPaymentStatus()==2 || courseDTO.getPaymentStatus()==3)){ |
| | | if (StringUtils.hasLength(courseDTO.getPaymentStatus()) ){ |
| | | List<Integer> integers = new ArrayList<>(); |
| | | if (courseDTO.getPaymentStatus().contains("1")){ |
| | | integers.add(0); |
| | | } |
| | | if (courseDTO.getPaymentStatus().contains("2")){ |
| | | integers.add(1); |
| | | } |
| | | if (courseDTO.getPaymentStatus().contains("3")){ |
| | | integers.add(2); |
| | | } |
| | | if (!integers.isEmpty()){ |
| | | wrapper.in(AppUserWithdraw::getWithdrawStatus,integers); |
| | | } |
| | | } |
| | | if (StringUtils.hasLength(courseDTO.getTime())){ |
| | | String startTime =null; |
| | |
| | | String[] split = courseDTO.getTime().split(" - "); |
| | | startTime = split[0]+" 00:00:00"; |
| | | endTime = split[1]+" 23:59:59"; |
| | | wrapper.between(AppUserWithdraw::getWithdrawTime,startTime,endTime); |
| | | wrapper.between(AppUserWithdraw::getCreateTime,startTime,endTime); |
| | | } |
| | | wrapper.orderByDesc(BaseModel::getCreateTime); |
| | | Page<AppUserWithdraw> list = withdrawService.page(new Page<>(courseDTO.getPageCurr(), courseDTO.getPageSize()), wrapper); |
| | | if (CollUtils.isEmpty(list.getRecords())) { |
| | | return R.ok(PageDTO.empty(list)); |
| | |
| | | if (collect.isEmpty())collect.add(-1L); |
| | | wrapper.in(AppUserWithdraw::getAppUserId,collect); |
| | | } |
| | | if (courseDTO.getPaymentStatus()!=null && courseDTO.getPaymentStatus()==1){ |
| | | wrapper.eq(AppUserWithdraw::getId,0); |
| | | }else if (courseDTO.getPaymentStatus()!=null &&(courseDTO.getPaymentStatus()==2 || courseDTO.getPaymentStatus()==3)){ |
| | | if (StringUtils.hasLength(courseDTO.getPaymentStatus()) ){ |
| | | List<Integer> integers = new ArrayList<>(); |
| | | if (courseDTO.getPaymentStatus().contains("1")){ |
| | | integers.add(0); |
| | | } |
| | | if (courseDTO.getPaymentStatus().contains("2")){ |
| | | integers.add(1); |
| | | } |
| | | if (courseDTO.getPaymentStatus().contains("3")){ |
| | | integers.add(2); |
| | | } |
| | | if (!integers.isEmpty()){ |
| | | wrapper.in(AppUserWithdraw::getWithdrawStatus,integers); |
| | | } |
| | | } |
| | | if (StringUtils.hasLength(courseDTO.getTime())){ |
| | | String startTime =null; |
| | |
| | | if (collect.isEmpty())collect.add(-1L); |
| | | wrapper.in(AppUserWithdraw::getAppUserId,collect); |
| | | } |
| | | if (courseDTO.getOrderFrom()!=null && courseDTO.getOrderFrom()!=5){ |
| | | if (StringUtils.hasLength(courseDTO.getOrderFrom()) && (!courseDTO.getOrderFrom().contains("5"))){ |
| | | wrapper.eq(AppUserWithdraw::getId,0); |
| | | } |
| | | if (courseDTO.getPayType()!=null && courseDTO.getPayType()!=4){ |
| | | if (StringUtils.hasLength(courseDTO.getPayType()) && (!courseDTO.getPayType().contains("4"))){ |
| | | wrapper.eq(AppUserWithdraw::getId,0); |
| | | } |
| | | if (courseDTO.getPaymentStatus()!=null && courseDTO.getPaymentStatus()==1){ |
| | | wrapper.eq(AppUserWithdraw::getId,0); |
| | | }else if (courseDTO.getPaymentStatus()!=null &&(courseDTO.getPaymentStatus()==2 || courseDTO.getPaymentStatus()==3)){ |
| | | if (StringUtils.hasLength(courseDTO.getPaymentStatus()) ){ |
| | | List<Integer> integers = new ArrayList<>(); |
| | | if (courseDTO.getPaymentStatus().contains("1")){ |
| | | integers.add(0); |
| | | } |
| | | if (courseDTO.getPaymentStatus().contains("2")){ |
| | | integers.add(1); |
| | | } |
| | | if (courseDTO.getPaymentStatus().contains("3")||courseDTO.getPaymentStatus().contains("4")){ |
| | | integers.add(2); |
| | | } |
| | | if (!integers.isEmpty()){ |
| | | wrapper.in(AppUserWithdraw::getWithdrawStatus,integers); |
| | | } |
| | | } |
| | | if (StringUtils.hasLength(courseDTO.getTime())){ |
| | | String startTime =null; |
| | |
| | | @ApiImplicitParam(name = "bankId", value = "银行卡id", dataType = "Long", required = true), |
| | | @ApiImplicitParam(name = "money", value = "提现金额", dataType = "String", required = true) |
| | | }) |
| | | public R withdraw(Long bankId,String money) throws Exception { |
| | | public synchronized R withdraw(Long bankId,String money) throws Exception { |
| | | |
| | | LoginUser loginUser = tokenService.getLoginUser(); |
| | | if (loginUser==null){ |
| | |
| | | return R.fail("提现金额不能超过钱包余额"); |
| | | } |
| | | AppUserBank byId1 = appUserBankService.getById(bankId); |
| | | |
| | | if (!Objects.equals(byId1.getAppUserId(), userId)){ |
| | | return R.fail("银行卡不属于当前登录用户"); |
| | | } |
| | | byId.setBalance(byId.getBalance().subtract(new BigDecimal(money))); |
| | | BigDecimal bigDecimal = new BigDecimal(money); |
| | | AppUserWithdraw appUserWithdraw = new AppUserWithdraw(); |
| | |
| | | appUserWithdraw.setWithdrawStatus(0); |
| | | // todo 提现流水号 |
| | | String s = UuidUtils.generateUuid(); |
| | | String replace = s.replace("-", ""); |
| | | |
| | | String replace = s.replace("-", "").substring(0, 16); |
| | | // 商户余额充值到用户余额 |
| | | appUserWithdraw.setCode("CZ"+replace); |
| | | appUserWithdraw.setCode("TX"+replace); |
| | | appUserWithdraw.setWithdrawTime(LocalDateTime.now()); |
| | | appUserWithdraw.setCreateTime(LocalDateTime.now()); |
| | | // 先扣去余额 |
| | |
| | | appUserWalletRecord.setAppUserId(userId); |
| | | appUserWalletRecord.setChangeType(2); |
| | | appUserWalletRecord.setReason("提现"); |
| | | appUserWalletRecord.setOrderId(appUserWithdraw.getId()); |
| | | appUserWalletRecord.setAmount(new BigDecimal(money)); |
| | | BigDecimal bigDecimal1 = new BigDecimal(money).setScale(2, RoundingMode.HALF_DOWN); |
| | | String s1 = JuHeFuUtil.updateAccount(byId.getFenzhangId(), byId1.getCardholder(), byId1.getCellPhone(), byId1.getCardNo()); |
| | |
| | | return R.fail("银行卡信息或持卡人信息有误,请核对后输入"); |
| | | } |
| | | // 从商户余额分账到用户分账接收方 |
| | | JSONObject jsonObject = JuHeFuUtil.balancePay(appUserWithdraw.getCode(), byId.getFenzhangId(), bigDecimal1 + "" |
| | | JSONObject jsonObject = JuHeFuUtil.balancePay("CZ"+replace, byId.getFenzhangId(), bigDecimal1 + "" |
| | | , "https://xq.xqzhihui.com/api/user/client/app-user-withdraw/base/callback"); |
| | | if (jsonObject.getString("error_msg")!=null){ |
| | | return R.fail("系统繁忙,5分钟后重试"); |
| | | // return R.fail(jsonObject.getString("error_msg")); |
| | | } |
| | | JSONObject jsonObject2 = JuHeFuUtil.balanceWithdraw("TX"+replace, bigDecimal1+"", byId.getFenzhangId(), |
| | | "https://xq.xqzhihui.com/api/user/client/app-user-withdraw/base/callbackA"); |
| | | if (jsonObject2.getString("error_msg")!=null){ |
| | | return R.fail("系统繁忙,5分钟后重试"); |
| | | } |
| | | System.err.println("执行完毕====="); |
| | | appUserWithdraw.setCode("TX"+replace); |
| | | appUserService.updateById(byId); |
| | | appUserWalletRecordService.save(appUserWalletRecord); |
| | | withdrawService.save(appUserWithdraw); |
| | | appUserWalletRecord.setOrderId(appUserWithdraw.getId()); |
| | | appUserWalletRecordService.save(appUserWalletRecord); |
| | | return R.ok(); |
| | | } |
| | | private static final String AES_KEY = "cb0a181ac97395c6942be19315fc0727"; |
| | | private static final String AES_KEY = "6d548eb01bad44bbbb4a23743e733103"; |
| | | public static String decrypt(String strToDecrypt) { |
| | | try { |
| | | SecretKeySpec secretKey = new SecretKeySpec(AES_KEY.getBytes(), "AES"); |
| | |
| | | System.out.println("Error while decrypting: " + e.toString()); |
| | | } |
| | | return null;} |
| | | @ResponseBody |
| | | @PostMapping("/base/callback") |
| | | public void callback(HttpServletRequest request, HttpServletResponse response) { |
| | | try { |
| | | System.err.println("提现到分账接收方回调================="+request); |
| | | BufferedReader reader = request.getReader(); |
| | | String string1 = reader.toString(); |
| | | StringBuilder requestBody = new StringBuilder(); |
| | | String line; |
| | | while ((line = reader.readLine()) != null) { |
| | | requestBody.append(line); |
| | | } |
| | | System.err.println("提现回调=================全部请求体"+requestBody); |
| | | com.alibaba.fastjson2.JSONObject jsonObject = JSONObject.parseObject(requestBody.toString()); |
| | | System.err.println("json串"+jsonObject); |
| | | String string9 = jsonObject.getString("resCipher"); |
| | | String decrypt = decrypt(string9); |
| | | System.err.println(decrypt); |
| | | JSONObject jsonObject1 = JSONObject.parseObject(decrypt); |
| | | // 系统订单号 |
| | | String string = jsonObject1.getString("order_no"); |
| | | String payId = jsonObject1.getString("pay_id"); |
| | | AppUserWithdraw one = withdrawService.lambdaQuery().eq(AppUserWithdraw::getCode, string).one(); |
| | | if (jsonObject.getString("type").equals("balancePay.succeeded")){ |
| | | if (one!=null){ |
| | | String s = UuidUtils.generateUuid(); |
| | | String replace = "TX"+s.replace("-", ""); |
| | | // 商户余额充值到用户余额 |
| | | AppUser appUser = appUserService.getById(one.getAppUserId()); |
| | | if (one.getWithdrawStatus()==1 || one.getWithdrawStatus()==2){ |
| | | return; |
| | | } |
| | | |
| | | JSONObject jsonObject2 = JuHeFuUtil.balanceWithdraw(replace, one.getAmount() + "", appUser.getFenzhangId(), |
| | | "https://xq.xqzhihui.com/api/user/client/app-user-withdraw/base/callbackA"); |
| | | if (jsonObject2.getString("error_msg")!=null){ |
| | | // 调用失败 |
| | | // 回退余额记录 |
| | | AppUserWalletRecord appUserWalletRecord = new AppUserWalletRecord(); |
| | | appUserWalletRecord.setAppUserId(one.getAppUserId()); |
| | | appUserWalletRecord.setChangeType(1); |
| | | appUserWalletRecord.setReason("提现回退"); |
| | | appUserWalletRecord.setOrderId(one.getId()); |
| | | appUserWalletRecord.setAmount(one.getAmount()); |
| | | appUserWalletRecordService.save(appUserWalletRecord); |
| | | one.setWithdrawStatus(2); |
| | | one.setReason(jsonObject1.getString("error_msg")); |
| | | withdrawService.updateById(one); |
| | | // 回退用户余额 |
| | | BigDecimal add = appUser.getBalance().add(one.getAmount()); |
| | | appUser.setBalance(add); |
| | | appUserService.updateById(appUser); |
| | | PrintWriter out = response.getWriter(); |
| | | out.write("succeeded"); |
| | | out.flush(); |
| | | out.close(); |
| | | } |
| | | one.setCode(replace); |
| | | withdrawService.updateById(one); |
| | | } |
| | | PrintWriter out = response.getWriter(); |
| | | out.write("succeeded"); |
| | | out.flush(); |
| | | out.close(); |
| | | }else if (jsonObject.getString("type").equals("balancePay.failed")){ |
| | | // 回退余额记录 |
| | | AppUserWalletRecord appUserWalletRecord = new AppUserWalletRecord(); |
| | | appUserWalletRecord.setAppUserId(one.getAppUserId()); |
| | | appUserWalletRecord.setChangeType(1); |
| | | appUserWalletRecord.setReason("提现回退"); |
| | | appUserWalletRecord.setOrderId(one.getId()); |
| | | appUserWalletRecord.setAmount(one.getAmount()); |
| | | appUserWalletRecordService.save(appUserWalletRecord); |
| | | one.setWithdrawStatus(2); |
| | | one.setReason(jsonObject1.getString("error_msg")); |
| | | withdrawService.updateById(one); |
| | | // 回退用户余额 |
| | | AppUser appUser = appUserService.getById(one.getAppUserId()); |
| | | BigDecimal add = appUser.getBalance().add(one.getAmount()); |
| | | appUser.setBalance(add); |
| | | appUserService.updateById(appUser); |
| | | PrintWriter out = response.getWriter(); |
| | | out.write("succeeded"); |
| | | out.flush(); |
| | | out.close(); |
| | | } |
| | | } catch (Exception e) { |
| | | e.printStackTrace(); |
| | | } |
| | | } |
| | | // @ResponseBody |
| | | // @PostMapping("/base/callback") |
| | | // public void callback(HttpServletRequest request, HttpServletResponse response) { |
| | | // try { |
| | | // System.err.println("提现到分账接收方回调================="+request); |
| | | // BufferedReader reader = request.getReader(); |
| | | // String string1 = reader.toString(); |
| | | // StringBuilder requestBody = new StringBuilder(); |
| | | // String line; |
| | | // while ((line = reader.readLine()) != null) { |
| | | // requestBody.append(line); |
| | | // } |
| | | // System.err.println("提现回调=================全部请求体"+requestBody); |
| | | // com.alibaba.fastjson2.JSONObject jsonObject = JSONObject.parseObject(requestBody.toString()); |
| | | // System.err.println("json串"+jsonObject); |
| | | // String string9 = jsonObject.getString("resCipher"); |
| | | // String decrypt = decrypt(string9); |
| | | // System.err.println(decrypt); |
| | | // JSONObject jsonObject1 = JSONObject.parseObject(decrypt); |
| | | // // 系统订单号 |
| | | // String string = jsonObject1.getString("order_no"); |
| | | // String payId = jsonObject1.getString("pay_id"); |
| | | // AppUserWithdraw one = withdrawService.lambdaQuery().eq(AppUserWithdraw::getCode, string).one(); |
| | | // if (jsonObject.getString("type").equals("balancePay.succeeded")){ |
| | | // if (one!=null){ |
| | | // String s = UuidUtils.generateUuid(); |
| | | // String replace = "TX"+s.replace("-", ""); |
| | | // // 商户余额充值到用户余额 |
| | | // AppUser appUser = appUserService.getById(one.getAppUserId()); |
| | | // if (one.getWithdrawStatus()==1 || one.getWithdrawStatus()==2){ |
| | | // return; |
| | | // } |
| | | // |
| | | // JSONObject jsonObject2 = JuHeFuUtil.balanceWithdraw(replace, one.getAmount() + "", appUser.getFenzhangId(), |
| | | // "https://xq.xqzhihui.com/api/user/client/app-user-withdraw/base/callbackA"); |
| | | // if (jsonObject2.getString("error_msg")!=null){ |
| | | // // 调用失败 |
| | | // // 回退余额记录 |
| | | // AppUserWalletRecord appUserWalletRecord = new AppUserWalletRecord(); |
| | | // appUserWalletRecord.setAppUserId(one.getAppUserId()); |
| | | // appUserWalletRecord.setChangeType(1); |
| | | // appUserWalletRecord.setReason("提现回退"); |
| | | // appUserWalletRecord.setOrderId(one.getId()); |
| | | // appUserWalletRecord.setAmount(one.getAmount()); |
| | | // appUserWalletRecordService.save(appUserWalletRecord); |
| | | // one.setWithdrawStatus(2); |
| | | // one.setReason(jsonObject1.getString("error_msg")); |
| | | // withdrawService.updateById(one); |
| | | // // 回退用户余额 |
| | | // BigDecimal add = appUser.getBalance().add(one.getAmount()); |
| | | // appUser.setBalance(add); |
| | | // appUserService.updateById(appUser); |
| | | // PrintWriter out = response.getWriter(); |
| | | // out.write("succeeded"); |
| | | // out.flush(); |
| | | // out.close(); |
| | | // } |
| | | // one.setCode(replace); |
| | | // withdrawService.updateById(one); |
| | | // } |
| | | // PrintWriter out = response.getWriter(); |
| | | // out.write("succeeded"); |
| | | // out.flush(); |
| | | // out.close(); |
| | | // }else if (jsonObject.getString("type").equals("balancePay.failed")){ |
| | | // // 回退余额记录 |
| | | // AppUserWalletRecord appUserWalletRecord = new AppUserWalletRecord(); |
| | | // appUserWalletRecord.setAppUserId(one.getAppUserId()); |
| | | // appUserWalletRecord.setChangeType(1); |
| | | // appUserWalletRecord.setReason("提现回退"); |
| | | // appUserWalletRecord.setOrderId(one.getId()); |
| | | // appUserWalletRecord.setAmount(one.getAmount()); |
| | | // appUserWalletRecordService.save(appUserWalletRecord); |
| | | // one.setWithdrawStatus(2); |
| | | // one.setReason(jsonObject1.getString("error_msg")); |
| | | // withdrawService.updateById(one); |
| | | // // 回退用户余额 |
| | | // AppUser appUser = appUserService.getById(one.getAppUserId()); |
| | | // BigDecimal add = appUser.getBalance().add(one.getAmount()); |
| | | // appUser.setBalance(add); |
| | | // appUserService.updateById(appUser); |
| | | // PrintWriter out = response.getWriter(); |
| | | // out.write("succeeded"); |
| | | // out.flush(); |
| | | // out.close(); |
| | | // } |
| | | // } catch (Exception e) { |
| | | // e.printStackTrace(); |
| | | // } |
| | | // } |
| | | @ResponseBody |
| | | @PostMapping("/base/callbackA") |
| | | public void callbackA(HttpServletRequest request, HttpServletResponse response) { |