package com.xinquan.order.controller.client; import com.alibaba.fastjson2.JSONObject; import com.auth0.jwt.JWT; import com.auth0.jwt.algorithms.Algorithm; import com.auth0.jwt.exceptions.SignatureVerificationException; import com.auth0.jwt.interfaces.DecodedJWT; import com.baomidou.mybatisplus.core.conditions.query.QueryWrapper; import com.baomidou.mybatisplus.extension.plugins.pagination.Page; import com.sun.corba.se.spi.ior.IdentifiableFactory; import com.xinquan.common.core.constant.SecurityConstants; import com.xinquan.common.core.domain.R; import com.xinquan.common.core.utils.page.BeanUtils; import com.xinquan.common.core.utils.page.CollUtils; import com.xinquan.common.core.utils.page.PageDTO; import com.xinquan.common.core.web.domain.AjaxResult; import com.xinquan.common.core.web.domain.BaseModel; import com.xinquan.common.security.service.TokenService; import com.xinquan.common.security.utils.SecurityUtils; import com.xinquan.course.api.domain.Course; import com.xinquan.course.api.domain.CourseChapter; import com.xinquan.course.api.feign.RemoteCourseService; import com.xinquan.meditation.api.domain.Meditation; import com.xinquan.meditation.api.feign.RemoteMeditationService; import com.xinquan.order.api.domain.Order; import com.xinquan.order.api.domain.vo.PayOrderVO; import com.xinquan.order.domain.OrderPaymentRecord; import com.xinquan.order.domain.vo.ClientPlaceOrderVO; import com.xinquan.order.service.OrderPaymentRecordService; import com.xinquan.order.service.OrderService; import com.xinquan.course.api.domain.OrderCourseVO; import com.xinquan.order.utils.OrderUtil; import com.xinquan.system.api.domain.AppUser; import com.xinquan.system.api.domain.AppUserCourse; import com.xinquan.system.api.domain.AppUserWalletRecord; import com.xinquan.system.api.domain.CommissionRule; import com.xinquan.system.api.feignClient.SysUserClient; import com.xinquan.system.api.model.LoginUser; import com.xinquan.user.api.domain.dto.AppUserDTO; import com.xinquan.user.api.feign.RemoteAppUserService; import io.swagger.annotations.Api; import io.swagger.annotations.ApiImplicitParam; import io.swagger.annotations.ApiImplicitParams; import io.swagger.annotations.ApiOperation; import lombok.RequiredArgsConstructor; import org.springframework.beans.factory.annotation.Autowired; import org.springframework.util.StringUtils; import org.springframework.web.bind.annotation.*; import javax.annotation.Resource; import javax.crypto.Cipher; import javax.crypto.spec.SecretKeySpec; import javax.servlet.http.HttpServletRequest; import javax.servlet.http.HttpServletResponse; import java.io.*; import java.math.BigDecimal; import java.security.PublicKey; import java.security.cert.CertificateException; import java.security.cert.CertificateFactory; import java.security.cert.X509Certificate; import java.security.interfaces.ECPublicKey; import java.time.LocalDateTime; import java.util.*; import java.util.stream.Collectors; /** *

* 订单表 前端控制器 *

* * @author mitao * @since 2024-08-21 */ @RestController @RequiredArgsConstructor @Api(tags = {"用户端-订单相关接口"}) @RequestMapping("/client/order/order") public class ClientOrderController { @Resource private OrderService orderService; @Resource private OrderPaymentRecordService orderPaymentRecordService; @Resource private RemoteCourseService remoteCourseService; @Resource private RemoteMeditationService remoteMeditationService; @Resource private RemoteAppUserService remoteAppUserService; @Resource private SysUserClient sysUserClient; @Autowired private TokenService tokenService; @GetMapping("/getMeditationIsBuy/{id}/{meditationId}") public R getMeditationIsBuy(@PathVariable("id")Long id,@PathVariable("meditationId")Long meditationId) { List list = orderService.lambdaQuery().eq(Order::getBusinessId, meditationId) .eq(Order::getAppUserId, id) .eq(Order::getOrderFrom, 1) .eq(Order::getPaymentStatus, 2) .ne(Order::getRefundStatus, 3).list(); if (list.isEmpty()){ return R.ok(0); }else{ return R.ok(1); } } @PostMapping("/payOrder") @ApiOperation(value = "已购详情-待支付状态-页面数据",tags = "我的已购") @ApiImplicitParams({ @ApiImplicitParam(name = "id", value = "订单id", dataType = "Long", required = true), @ApiImplicitParam(name = "type", value = "1=android 2=ios", dataType = "Integer", required = true), }) public R payOrder(Long id,Integer type) { Order byId = orderService.getById(id); PayOrderVO payOrderVO = new PayOrderVO(); if (byId==null){ return R.fail("订单失效"); } if (byId.getGiveUserId()!=null){ AppUser data1 = remoteAppUserService.getAppUserById(byId.getGiveUserId() + "").getData(); payOrderVO.setPhone(data1.getCellPhone()); } AppUser data1 = remoteAppUserService.getAppUserById(byId.getAppUserId() + "").getData(); payOrderVO.setBalance(data1.getBalance()); payOrderVO.setOrderId(id); if (byId.getOrderFrom()==1){ Meditation data = remoteMeditationService.getMeditationById(byId.getBusinessId()).getData(); payOrderVO.setTitle(data.getMeditationTitle()); payOrderVO.setOrderFrom(1); payOrderVO.setCoverUrl(data.getCoverUrl()); payOrderVO.setId(data.getId()); switch (type){ case 1: payOrderVO.setAmount(data.getGeneralPrice()); break; case 2: payOrderVO.setAmount(data.getIosPrice()); break; } if (byId.getChangePrice()!=null){ payOrderVO.setAmount(payOrderVO.getAmount().add(byId.getChangePrice())); } }else if (byId.getOrderFrom() == 2){ Course data = remoteCourseService.getCourseById(byId.getBusinessId()).getData(); payOrderVO.setTitle(data.getCourseTitle()); payOrderVO.setTutor(data.getTutor()); payOrderVO.setOrderFrom(2); payOrderVO.setCoverUrl(data.getCoverUrl()); payOrderVO.setId(data.getId()); switch (type){ case 1: payOrderVO.setAmount(data.getGeneralPrice()); break; case 2: payOrderVO.setAmount(data.getIosPrice()); break; } if (byId.getChangePrice()!=null){ payOrderVO.setAmount(payOrderVO.getAmount().add(byId.getChangePrice())); } } return R.ok(payOrderVO); } @PostMapping("/myOrderCourse") @ApiOperation(value = "我的已购",tags = "我的已购") @ApiImplicitParams({ @ApiImplicitParam(name = "state", value = "1冥想 2课程", dataType = "Integer", required = true), @ApiImplicitParam(name = "pageCurr", value = "分页参数,当前页码", dataType = "Integer", required = true), @ApiImplicitParam(name = "pageSize", value = "分页参数,每页数量", dataType = "Integer", required = true) }) public R> balanceList(Integer state, Integer pageCurr, Integer pageSize) { LoginUser loginUser = tokenService.getLoginUser(); if (loginUser==null){ return R.tokenError("登录失效"); } Long userId = loginUser.getUserid(); List res = new ArrayList<>(); List page = orderService.lambdaQuery() .eq(Order::getOrderFrom, state) .ne(Order::getPaymentStatus, 3) .orderByDesc(BaseModel::getCreateTime).list(); List list = orderService.lambdaQuery().eq(Order::getGiveUserId, userId).list(); for (Order order : page) { OrderCourseVO orderCourseVO = new OrderCourseVO(); orderCourseVO.setId(order.getId()); orderCourseVO.setOrderFrom(order.getOrderFrom()); orderCourseVO.setBusinessId(order.getBusinessId()); if (order.getAppUserId().equals(userId) && order.getGiveUserId() == null){ BeanUtils.copyProperties(order, orderCourseVO); orderCourseVO.setBusinessId(order.getBusinessId()); res.add(orderCourseVO); } if (order.getGiveUserId()!=null&&order.getGiveUserId().equals(userId)){ BeanUtils.copyProperties(order, orderCourseVO); orderCourseVO.setBusinessId(order.getBusinessId()); res.add(orderCourseVO); } } List res1 = new ArrayList<>(); for (OrderCourseVO orderCourseVO : res) { switch (orderCourseVO.getOrderFrom()){ case 1: Meditation data1 = remoteMeditationService.getMeditationById(orderCourseVO.getBusinessId()).getData(); if (data1==null)continue; orderCourseVO.setCourseTitle(data1.getMeditationTitle()); orderCourseVO.setDescription(data1.getCoverDescription()); orderCourseVO.setCoverUrl(data1.getCoverUrl()); orderCourseVO.setGeneralPrice(data1.getGeneralPrice()); orderCourseVO.setIosPrice(data1.getIosPrice()); orderCourseVO.setCount(data1.getRealLearnedNum()+data1.getVirtualLearnedNum()); orderCourseVO.setChargeType(data1.getChargeType()); orderCourseVO.setCoverDescription(data1.getCoverDescription()); res1.add(orderCourseVO); break; case 2: OrderCourseVO data = remoteCourseService.getCourseByIdAny(orderCourseVO).getData(); if (data==null)continue; BeanUtils.copyProperties(data, orderCourseVO); Course data4 = remoteCourseService.getCourseById(data.getBusinessId()).getData(); List data2 = remoteCourseService.getChapterByCourseId(orderCourseVO.getBusinessId() + "").getData(); int temp = 0 ; for (CourseChapter courseChapter : data2) { temp+=courseChapter.getVirtualLearnedNum(); } Integer data3 = remoteCourseService.getCountByCourseId(orderCourseVO.getBusinessId() + "").getData(); orderCourseVO.setCount(data3+temp); if (data4!=null){ orderCourseVO.setCourseTitle(data4.getCourseTitle()); orderCourseVO.setCoverUrl(data4.getCoverUrl()); orderCourseVO.setBusinessId(data4.getId()); } res1.add(orderCourseVO); break; } } List orderCourseVOS = new ArrayList<>(); List longs1 = new ArrayList<>(); for (OrderCourseVO orderCourseVO : res1) { if (!longs1.contains(orderCourseVO.getBusinessId())){ longs1.add(orderCourseVO.getBusinessId()); orderCourseVOS.add(orderCourseVO); } } List testing = testing(orderCourseVOS.size(), pageCurr, pageSize, orderCourseVOS); return R.ok(testing); } public static List testing(long total, long current, long size, List str){ List result = new ArrayList<>(); //获取初始化分页结构 Page page = new Page<>(current - 1, size, total); //获取集合下标初始值 long startIndex = (current - 1) * size; //获取集合下标结束值 long endInddex = 0; if(startIndex + page.getCurrent() >= total || size > total){ endInddex = total; }else { endInddex = Math.min(startIndex + page.getSize(), total); } //如果输入的开始查询下标大于集合大小,则查询为空值 if(startIndex > total){ result = Collections.emptyList(); }else{ result = str.subList((int)startIndex,(int)endInddex); } return result; } /** * 根据邀请用户ids 查询对应佣金 */ @GetMapping("/getCommissionByUserIds/{userIds}") public R getCommissionByUserIds(@PathVariable("userIds") String userIds) { String[] split = userIds.split(","); StringBuilder stringBuilder = new StringBuilder(); for (String s : split) { List list = orderService.lambdaQuery().eq(Order::getAppUserId, s) .eq(Order::getPaymentStatus, 2).list(); BigDecimal commissionAmount = list.stream() .filter(t -> t.getCommissionAmount()!= null) .map(Order::getCommissionAmount) .reduce(BigDecimal.ZERO, BigDecimal::add); stringBuilder.append(commissionAmount).append(","); } StringBuilder stringBuilder1 = stringBuilder.deleteCharAt(stringBuilder.length() - 1); return R.ok(stringBuilder1.toString()); } /** * 创建待支付订单 * * @param targetId 目标id * @param orderFrom 订单来源 1=冥想音频 2=课程 * @param receiverId 被赠送课程APP用户id * @param balanceFlag 是否使用余额抵扣 1=是 2=否 * @param payType 支付方式 1=微信 2=支付宝 * @return 下单返回数据视图对象 * @see com.xinquan.order.domain.vo.ClientPlaceOrderVO */ @PostMapping("/placeOrder") @ApiOperation(value = "创建支付订单", notes = "微信|支付宝") @ApiImplicitParams({ @ApiImplicitParam(name = "targetId", value = "目标id 订单类型为会员和充值时不传", dataType = "Long", required = false), @ApiImplicitParam(name = "orderId", value = "订单id 待支付时传", dataType = "Long", required = false), @ApiImplicitParam(name = "orderFrom", value = "订单来源 1=冥想音频 2=课程 3=购买会员 4充值", dataType = "Integer", required = true), @ApiImplicitParam(name = "receiverId", value = "被赠送课程APP用户id", dataType = "Long", required = false), @ApiImplicitParam(name = "balanceFlag", value = "是否使用余额抵扣 1=是 2=否", dataType = "Integer", required = false), @ApiImplicitParam(name = "payType", value = "支付方式 1=微信 2=支付宝", dataType = "Integer", required = false), @ApiImplicitParam(name = "amount", value = "购买会员的金额/充值金额", dataType = "BigDecimal", required = false), @ApiImplicitParam(name = "vipType", value = "订单类型为会员时 必传 会员类型 1月度 2季度 3年度", dataType = "Integer", required = false), }) public R placeOrder( @RequestParam(value = "targetId", required = false) Long targetId, @RequestParam(value = "orderId", required = false) Long orderId, @RequestParam(value = "orderFrom") Integer orderFrom, @RequestParam(value = "receiverId", required = false) Long receiverId, @RequestParam(value = "balanceFlag", required = false) Integer balanceFlag, @RequestParam(value = "payType") Integer payType, @RequestParam(value = "amount", required = false) BigDecimal amount, @RequestParam(value = "vipType", required = false) Integer vipType) { try { return R.ok( orderService.placeOrder(targetId, orderFrom, receiverId,orderId, balanceFlag, payType,amount,vipType)); } catch (Exception e) { throw new RuntimeException(e); } } @ResponseBody @PostMapping("/refund") @ApiOperation(value = "退款", tags = "管理后台-订单列表管理") @ApiImplicitParams({ @ApiImplicitParam(name = "uid", value = "订单id", dataType = "String", required = false), @ApiImplicitParam(name = "remark", value = "退款备注", dataType = "String", required = false), }) public R refund(@RequestParam(value = "uid") String uid, @RequestParam(value = "remark") String remark) throws Exception { Order byId = orderService.getById(uid); byId.setRefundStatus(2); byId.setRefundRemark(remark); byId.setPaymentStatus(3); orderService.updateById(byId); orderService.refund(Long.valueOf(uid)); return R.ok(); } @ResponseBody @PostMapping("/placeOrderApple") @ApiOperation(value = "苹果支付", notes = "苹果支付") @ApiImplicitParams({ @ApiImplicitParam(name = "targetId", value = "目标id 订单类型为会员和充值时不传", dataType = "Long", required = false), @ApiImplicitParam(name = "orderFrom", value = "订单来源 1=冥想音频 2=课程 3=购买会员 4充值", dataType = "Integer", required = true), @ApiImplicitParam(name = "receiverId", value = "被赠送课程APP用户id", dataType = "Long", required = false), @ApiImplicitParam(name = "balanceFlag", value = "是否使用余额抵扣 1=是 2=否", dataType = "Integer", required = false), @ApiImplicitParam(name = "amount", value = "购买会员的金额/充值金额", dataType = "BigDecimal", required = false), @ApiImplicitParam(name = "transactionIdentifier", value = "苹果订单id"), @ApiImplicitParam(name = "vipType", value = "订单类型为会员时 必传 会员类型 1月度 2季度 3年度", dataType = "Integer", required = false), }) public R placeOrderApple( @RequestParam(value = "targetId", required = false) Long targetId, @RequestParam(value = "orderFrom") Integer orderFrom, @RequestParam(value = "receiverId", required = false) Long receiverId, @RequestParam(value = "balanceFlag", required = false) Integer balanceFlag, @RequestParam(value = "amount", required = false) BigDecimal amount, @RequestParam(value = "vipType", required = false) Integer vipType, @RequestParam(value = "transactionIdentifier")String transactionIdentifier) throws Exception { return R.ok(orderService.placeOrderApple(targetId, orderFrom, receiverId, balanceFlag,amount,vipType,transactionIdentifier)); } @ResponseBody @PostMapping("/gvieCourse") @ApiOperation(value = "购买疗愈/课程-纯余额支付", notes = "赠送课程-纯余额支付") @ApiImplicitParams({ @ApiImplicitParam(name = "targetId", value = "目标id 订单类型为会员和充值时不传", dataType = "Long", required = false), @ApiImplicitParam(name = "orderFrom", value = "订单来源 1=冥想音频 2=课程", dataType = "Integer", required = true), @ApiImplicitParam(name = "receiverId", value = "被赠送课程APP用户id",dataType = "Long", required = false), @ApiImplicitParam(name = "payType", value = "1安卓 2ios", dataType = "Long", required = false), @ApiImplicitParam(name = "amount", value = "金额", dataType = "BigDecimal", required = false) }) public R placeOrderApple( @RequestParam(value = "targetId") Long targetId, @RequestParam(value = "orderFrom") Integer orderFrom, @RequestParam(value = "receiverId",required = false) Long receiverId, @RequestParam(value = "amount",required = false) BigDecimal amount, @RequestParam(value = "payType") Integer payType ){ LoginUser loginUser = tokenService.getLoginUser(); if (loginUser==null){ return R.tokenError("登录失效"); } Long userId = loginUser.getUserid(); Order order = new Order(); String orderNo = OrderUtil.getOrderNoForPrefix("MX"); order.setBizOrderNo(orderNo); order.setAppUserId(userId); order.setBusinessId(targetId); order.setGiveUserId(receiverId); order.setOrderFrom(orderFrom); order.setPaymentStatus(2); order.setPayType(4); order.setPaymentTime(LocalDateTime.now()); switch (orderFrom){ case 1: Meditation data1 = remoteMeditationService.getMeditationById(targetId).getData(); order.setBuyContent("购买疗愈【"+data1.getMeditationTitle()+"】"); switch (payType){ case 1: order.setTotalAmount(data1.getGeneralPrice()); order.setRealPayAmount(data1.getGeneralPrice()); break; case 2: order.setTotalAmount(data1.getIosPrice()); order.setRealPayAmount(data1.getIosPrice()); break; } break; case 2: Course data = remoteCourseService.getCourseById(targetId).getData(); order.setBuyContent("购买课程【"+data.getCourseTitle()+"】"); switch (payType){ case 1: order.setTotalAmount(data.getGeneralPrice()); order.setRealPayAmount(data.getGeneralPrice()); break; case 2: order.setTotalAmount(data.getIosPrice()); order.setRealPayAmount(data.getIosPrice()); break; } if (receiverId!=null){ remoteAppUserService.addNotice(receiverId + "", data.getId() + "", userId + "", order.getTotalAmount() + ""); } break; } orderService.save(order); switch (orderFrom){ case 2: if (receiverId!=null){ remoteAppUserService.addAppUserCourse(order.getBusinessId(),order.getGiveUserId(),order.getId(),1); remoteAppUserService.addNotice(receiverId+"",order.getBusinessId()+"",order.getAppUserId()+"",order.getTotalAmount()+""); }else{ // 自己购买 remoteAppUserService.addAppUserCourse(order.getBusinessId(),order.getAppUserId(),order.getId(),2); } break; } OrderPaymentRecord orderPaymentRecord = new OrderPaymentRecord(); orderPaymentRecord.setOrderId(order.getId()); orderPaymentRecord.setPaymentType(4); orderPaymentRecord.setPayAmount(order.getTotalAmount()); orderPaymentRecord.setPaymentStatus(2); orderPaymentRecordService.save(orderPaymentRecord); // 增加用户余额购买流水记录 AppUserWalletRecord appUserWalletRecord1 = new AppUserWalletRecord(); appUserWalletRecord1.setAppUserId(order.getAppUserId()); appUserWalletRecord1.setChangeType(2); appUserWalletRecord1.setReason(order.getBuyContent()); appUserWalletRecord1.setAmount(order.getRealPayAmount()); appUserWalletRecord1.setChildAppUserId(order.getAppUserId()); appUserWalletRecord1.setOrderId(order.getId()); remoteAppUserService.addBalanceRecord(appUserWalletRecord1); // 判断订单所属用户是否有上级 是否需要做分佣处理 AppUser data = remoteAppUserService.getAppUserById(order.getAppUserId() + "").getData(); BigDecimal realPayAmount = order.getRealPayAmount(); if (data.getInviteUserId()!=null) { if (order.getOrderFrom() == 1 || order.getOrderFrom() == 2 || order.getOrderFrom() == 3) { // // 查询实际支付价格 不包含余额抵扣价格 // OrderPaymentRecord one1 = orderPaymentRecordService.lambdaQuery().eq(OrderPaymentRecord::getOrderId, order.getId()) // .one(); // // 分佣给上级 先远程查询分佣比例 // CommissionRule data1 = sysUserClient.getCommission().getData(); // if (data1 != null) { // if (data1.getProportion() != null) { // // BigDecimal bigDecimal = one1.getPayAmount().multiply(data1.getProportion()).divide(new BigDecimal("100")) // .setScale(2, BigDecimal.ROUND_HALF_DOWN); // // 上级获取的分佣金额 // AppUser appUserById = remoteAppUserService.getAppUserById(data.getInviteUserId() + "").getData(); // // 更新用户余额 // remoteAppUserService.updateAppUser( // AppUserDTO.builder().balance( // appUserById.getBalance().add(bigDecimal)) // .build(), SecurityConstants.INNER); // // 新增分佣流水明细 // AppUserWalletRecord appUserWalletRecord = new AppUserWalletRecord(); // appUserWalletRecord.setAppUserId(data.getInviteUserId()); // appUserWalletRecord.setChangeType(1); // appUserWalletRecord.setReason("分佣收益"); // appUserWalletRecord.setAmount(bigDecimal); // appUserWalletRecord.setChildAppUserId(order.getAppUserId()); // appUserWalletRecord.setOrderId(order.getId()); // remoteAppUserService.addBalanceRecord(appUserWalletRecord); // order.setCommissionAmount(bigDecimal); // order.setCommissionId(data.getInviteUserId()); // orderService.updateById(order); // } // } } } return R.ok(); } /** * 三方支付统一回调 * * @param request * @param response */ @ResponseBody @PostMapping("/base/callback") public void callback(HttpServletRequest request, HttpServletResponse response) { try { System.err.println("请求"+request); BufferedReader reader = request.getReader(); String string1 = reader.toString(); System.err.println("请求reader"+string1); 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); if (jsonObject.getString("type").equals("payment.succeeded")){ 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 string2 = jsonObject1.getString("payment_id"); // 支付金额 String string3 = jsonObject1.getString("pay_fee"); Order one = orderService.lambdaQuery().eq(Order::getBizOrderNo, string).one(); if (one.getPaymentStatus()==2){ return; } one.setPaymentStatus(2); one.setPaymentTime(LocalDateTime.now()); OrderPaymentRecord one2 = orderPaymentRecordService.lambdaQuery().eq(OrderPaymentRecord::getOrderId, one.getId()) .ne(OrderPaymentRecord::getPaymentType, 4).one(); if (one2!=null){ one2.setPaymentStatus(2); // 扣除用户余额 Object data = remoteAppUserService.deleteBalance(one.getAppUserId() + "", one2.getPayAmount() + "").getData(); orderPaymentRecordService.updateById(one2); } // 实际支付金额 BigDecimal realPayAmount = one.getRealPayAmount(); // 判断订单所属用户是否有上级 是否需要做分佣处理 AppUser data = remoteAppUserService.getAppUserById(one.getAppUserId() + "").getData(); if (one.getGiveUserId()!=null){ remoteAppUserService.addNotice(one.getGiveUserId() + "", one.getBusinessId() + "", one.getAppUserId() + "", one.getTotalAmount() + ""); } if (data.getInviteUserId()!=null) { if (one.getOrderFrom() == 1 || one.getOrderFrom() == 2 || one.getOrderFrom() == 3) { // 查询实际支付价格 不包含余额抵扣价格 OrderPaymentRecord one1 = orderPaymentRecordService.lambdaQuery().eq(OrderPaymentRecord::getOrderId, one.getId()) .ne(OrderPaymentRecord::getPaymentType, 4).one(); // 分佣给上级 先远程查询分佣比例 CommissionRule data1 = sysUserClient.getCommission().getData(); if (data1 != null) { if (data1.getProportion() != null) { BigDecimal bigDecimal = one1.getPayAmount().multiply(data1.getProportion()).divide(new BigDecimal("100")) .setScale(2, BigDecimal.ROUND_HALF_DOWN); // 上级获取的分佣金额 AppUser appUserById = remoteAppUserService.getAppUserById(data.getInviteUserId() + "").getData(); // 更新用户余额 // remoteAppUserService.updateAppUser( // AppUserDTO.builder().balance( // appUserById.getBalance().add(bigDecimal)) // .build(), SecurityConstants.INNER); // 新增分佣流水明细 AppUserWalletRecord appUserWalletRecord = new AppUserWalletRecord(); appUserWalletRecord.setAppUserId(data.getInviteUserId()); appUserWalletRecord.setChangeType(1); appUserWalletRecord.setReason("分佣收益"); appUserWalletRecord.setAmount(bigDecimal); appUserWalletRecord.setChildAppUserId(one.getAppUserId()); appUserWalletRecord.setOrderId(one.getId()); remoteAppUserService.addBalanceRecord(appUserWalletRecord); one.setCommissionAmount(bigDecimal); one.setCommissionId(data.getInviteUserId()); orderService.updateById(one); } } } } if (one.getPayType() == 4 ||one.getPayType() == 5 ||one.getPayType() == 6 ||one.getPayType() == 7){ // 涉及到余额支付 新增一条余额支付记录 OrderPaymentRecord one1 = orderPaymentRecordService.lambdaQuery().eq(OrderPaymentRecord::getOrderId, one.getId()) .eq(OrderPaymentRecord::getPaymentType, 4).one(); AppUserWalletRecord appUserWalletRecord = new AppUserWalletRecord(); appUserWalletRecord.setAppUserId(one.getAppUserId()); String reason=null; switch (one.getOrderFrom()){ case 1: Meditation data1 = remoteMeditationService.getMeditationById(one.getBusinessId()).getData(); appUserWalletRecord.setChangeType(2); reason = "购买【"+data1.getMeditationTitle()+"】"; break; case 2: Course data2 = remoteCourseService.getCourseById(one.getBusinessId()).getData(); reason = "购买【"+data2.getCourseTitle()+"】"; appUserWalletRecord.setChangeType(2); // 增加用户与课程的关系表 if (one.getGiveUserId()!=null){ remoteAppUserService.addAppUserCourse(one.getBusinessId(),one.getGiveUserId(),one.getId(),1); }else{ // 自己购买 remoteAppUserService.addAppUserCourse(one.getBusinessId(),one.getAppUserId(),one.getId(),2); } break; case 3: // 会员 reason = "购买【"+one.getBuyContent()+"】"; appUserWalletRecord.setChangeType(2); break; case 4: // 充值 reason = "充值"; appUserWalletRecord.setChangeType(1); break; } appUserWalletRecord.setReason(reason); appUserWalletRecord.setAmount(one1.getPayAmount()); appUserWalletRecord.setOrderId(one.getId()); remoteAppUserService.addBalanceRecord(appUserWalletRecord); }else{ switch (one.getOrderFrom()){ case 2: Course data2 = remoteCourseService.getCourseById(one.getBusinessId()).getData(); // 增加用户与课程的关系表 if (one.getGiveUserId()!=null){ remoteAppUserService.addAppUserCourse(one.getBusinessId(),one.getGiveUserId(),one.getId(),1); }else{ // 自己购买 remoteAppUserService.addAppUserCourse(one.getBusinessId(),one.getAppUserId(),one.getId(),2); } break; case 3: // 会员 if (one.getBuyContent().contains("月")){ remoteAppUserService.addVipExpireTime(one.getAppUserId(),1); }else if (one.getBuyContent().contains("季")){ remoteAppUserService.addVipExpireTime(one.getAppUserId(),2); }else if (one.getBuyContent().contains("年")){ remoteAppUserService.addVipExpireTime(one.getAppUserId(),3); } break; case 4: remoteAppUserService.addBalance(one.getAppUserId(),one.getRealPayAmount()); AppUserWalletRecord appUserWalletRecord = new AppUserWalletRecord(); appUserWalletRecord.setAppUserId(one.getAppUserId()); appUserWalletRecord.setChangeType(1); appUserWalletRecord.setReason("充值"); appUserWalletRecord.setAmount(one.getRealPayAmount()); appUserWalletRecord.setChildAppUserId(one.getAppUserId()); appUserWalletRecord.setOrderId(one.getId()); remoteAppUserService.addBalanceRecord(appUserWalletRecord); break; } } orderService.updateById(one); PrintWriter out = response.getWriter(); out.write("succeeded"); out.flush(); out.close(); } } catch (Exception e) { e.printStackTrace(); } } private static final String AES_KEY = "cb0a181ac97395c6942be19315fc0727"; public static String decrypt(String strToDecrypt) { try { SecretKeySpec secretKey = new SecretKeySpec(AES_KEY.getBytes(), "AES"); Cipher cipher = Cipher.getInstance("AES/ECB/PKCS5Padding"); cipher.init(Cipher.DECRYPT_MODE, secretKey); return new String(cipher.doFinal(Base64.getDecoder().decode(strToDecrypt))); } catch (Exception e) { System.out.println("Error while decrypting: " + e.toString()); } return null;} /** * 购买套餐微信支付回调 * * @param request * @param response */ @ResponseBody @PostMapping("/base/testApple") public void testApple(HttpServletRequest request, HttpServletResponse response) { try { Map params = new HashMap(); System.err.println("请求"+request); BufferedReader reader = request.getReader(); String string1 = reader.toString(); System.err.println("请求reader"+string1); StringBuilder requestBody = new StringBuilder(); String line; while ((line = reader.readLine()) != null) { requestBody.append(line); } System.err.println("全部请求体"+requestBody); org.json.JSONObject jsonObject1 = new org.json.JSONObject(requestBody.toString()); System.err.println("json串"+jsonObject1); String o = jsonObject1.getString("signedPayload"); com.alibaba.fastjson.JSONObject payload = verifyAndGet(o); String notificationType = payload.get("notificationType").toString(); com.alibaba.fastjson.JSONObject data = payload.getJSONObject("data"); String signedTransactionInfo = data.get("signedTransactionInfo").toString(); String environment = data.get("environment").toString(); com.alibaba.fastjson.JSONObject transactionInfo = verifyAndGet(signedTransactionInfo); String transactionId = transactionInfo.get("transactionId").toString(); String originalTransactionId = transactionInfo.get("originalTransactionId").toString(); String productId = transactionInfo.get("productId").toString(); System.err.println("json串"+transactionInfo); System.err.println("data"+data); // 苹果流水号 String string = transactionInfo.getString("originalTransactionId"); System.err.println("苹果流水号"+string); OrderPaymentRecord two = orderPaymentRecordService.lambdaQuery() .eq(OrderPaymentRecord::getPayOrderNo, string).ne(OrderPaymentRecord::getPaymentStatus, 2).one(); if (two!=null){ Order one = orderService.getById(two.getOrderId()); if (one.getPaymentStatus()==2){ return; } one.setPaymentStatus(2); one.setPaymentTime(LocalDateTime.now()); orderService.updateById(one); OrderPaymentRecord one2 = orderPaymentRecordService.lambdaQuery().eq(OrderPaymentRecord::getOrderId, one.getId()) .ne(OrderPaymentRecord::getPaymentType, 4).one(); if (one2!=null){ one2.setPaymentStatus(2); orderPaymentRecordService.updateById(one2); } // 实际支付金额 BigDecimal realPayAmount = one.getRealPayAmount(); // 判断订单所属用户是否有上级 是否需要做分佣处理 AppUser data9 = remoteAppUserService.getAppUserById(one.getAppUserId() + "").getData(); if (one.getGiveUserId()!=null){ remoteAppUserService.addNotice(one.getGiveUserId() + "", one.getBusinessId() + "", one.getAppUserId() + "", one.getTotalAmount() + ""); } if (data9.getInviteUserId()!=null) { if (one.getOrderFrom() == 1 || one.getOrderFrom() == 2 || one.getOrderFrom() == 3) { // 查询实际支付价格 不包含余额抵扣价格 OrderPaymentRecord one1 = orderPaymentRecordService.lambdaQuery().eq(OrderPaymentRecord::getOrderId, one.getId()) .ne(OrderPaymentRecord::getPaymentType, 4).one(); // 分佣给上级 先远程查询分佣比例 CommissionRule data1 = sysUserClient.getCommission().getData(); if (data1 != null) { if (data1.getProportion() != null) { BigDecimal bigDecimal = one1.getPayAmount().multiply(data1.getProportion()).divide(new BigDecimal("100")) .setScale(2, BigDecimal.ROUND_HALF_DOWN); // 上级获取的分佣金额 AppUser appUserById = remoteAppUserService.getAppUserById(data9.getInviteUserId() + "").getData(); // 更新用户余额 // remoteAppUserService.updateAppUser( // AppUserDTO.builder().balance( // appUserById.getBalance().add(bigDecimal)) // .build(), SecurityConstants.INNER); // 新增分佣流水明细 AppUserWalletRecord appUserWalletRecord = new AppUserWalletRecord(); appUserWalletRecord.setAppUserId(data9.getInviteUserId()); appUserWalletRecord.setChangeType(1); appUserWalletRecord.setReason("分佣收益"); appUserWalletRecord.setAmount(bigDecimal); appUserWalletRecord.setChildAppUserId(one.getAppUserId()); appUserWalletRecord.setOrderId(one.getId()); remoteAppUserService.addBalanceRecord(appUserWalletRecord); one.setCommissionAmount(bigDecimal); one.setCommissionId(data9.getInviteUserId()); orderService.updateById(one); } } } } if (one.getPayType() == 4 ||one.getPayType() == 5 ||one.getPayType() == 6 ||one.getPayType() == 7){ // 涉及到余额支付 新增一条余额支付记录 OrderPaymentRecord one1 = orderPaymentRecordService.lambdaQuery().eq(OrderPaymentRecord::getOrderId, one.getId()) .eq(OrderPaymentRecord::getPaymentType, 4).one(); AppUserWalletRecord appUserWalletRecord = new AppUserWalletRecord(); appUserWalletRecord.setAppUserId(data9.getInviteUserId()); String reason=null; switch (one.getOrderFrom()){ case 1: Meditation data1 = remoteMeditationService.getMeditationById(one.getBusinessId()).getData(); appUserWalletRecord.setChangeType(2); reason = "购买【"+data1.getMeditationTitle()+"】"; break; case 2: Course data2 = remoteCourseService.getCourseById(one.getBusinessId()).getData(); reason = "购买【"+data2.getCourseTitle()+"】"; appUserWalletRecord.setChangeType(2); // 增加用户与课程的关系表 if (one.getGiveUserId()!=null){ remoteAppUserService.addAppUserCourse(one.getBusinessId(),one.getGiveUserId(),one.getId(),1); }else{ // 自己购买 remoteAppUserService.addAppUserCourse(one.getBusinessId(),one.getAppUserId(),one.getId(),2); } break; case 3: // 会员 reason = "购买【"+one.getBuyContent()+"】"; appUserWalletRecord.setChangeType(2); break; case 4: // 充值 reason = "充值"; appUserWalletRecord.setChangeType(1); break; } appUserWalletRecord.setReason(reason); appUserWalletRecord.setAmount(one1.getPayAmount()); appUserWalletRecord.setChildAppUserId(one.getAppUserId()); appUserWalletRecord.setOrderId(one.getId()); remoteAppUserService.addBalanceRecord(appUserWalletRecord); }else{ switch (one.getOrderFrom()){ case 2: Course data2 = remoteCourseService.getCourseById(one.getBusinessId()).getData(); // 增加用户与课程的关系表 if (one.getGiveUserId()!=null){ remoteAppUserService.addAppUserCourse(one.getBusinessId(),one.getGiveUserId(),one.getId(),1); }else{ // 自己购买 remoteAppUserService.addAppUserCourse(one.getBusinessId(),one.getAppUserId(),one.getId(),2); } break; case 3: // 会员 if (one.getBuyContent().contains("月")){ remoteAppUserService.addVipExpireTime(one.getAppUserId(),1); }else if (one.getBuyContent().contains("季")){ remoteAppUserService.addVipExpireTime(one.getAppUserId(),2); }else if (one.getBuyContent().contains("年")){ remoteAppUserService.addVipExpireTime(one.getAppUserId(),3); } break; case 4: System.err.println("进入充值"); remoteAppUserService.addBalance(one.getAppUserId(),one.getTotalAmount()); AppUserWalletRecord appUserWalletRecord = new AppUserWalletRecord(); appUserWalletRecord.setAppUserId(one.getAppUserId()); appUserWalletRecord.setChangeType(1); appUserWalletRecord.setReason("充值"); appUserWalletRecord.setAmount(one.getTotalAmount()); appUserWalletRecord.setChildAppUserId(one.getAppUserId()); appUserWalletRecord.setOrderId(one.getId()); remoteAppUserService.addBalanceRecord(appUserWalletRecord); break; } } PrintWriter out = response.getWriter(); out.write("succeeded"); out.flush(); out.close(); } // Recharge orderNumber = rechargeService.selectOne(new EntityWrapper() // .eq("orderNumber", string)); // if (orderNumber!=null){ // if (orderNumber.getState()!=2){ // // 进入 // orderNumber.setState(2); // orderNumber.setPayTime(new Date()); // rechargeService.updateById(orderNumber); // BigDecimal amount = orderNumber.getAmount(); // AppUser appUser = appUserService.selectById(orderNumber.getUserId()); // BigDecimal add = appUser.getBalance().add(amount); // appUser.setBalance(add); // appUserService.updateById(appUser); // } // } PrintWriter out = response.getWriter(); out.write("success"); out.flush(); out.close(); } catch (Exception e) { e.printStackTrace(); } } public static com.alibaba.fastjson.JSONObject verifyAndGet(String jws) throws CertificateException { DecodedJWT decodedJWT = JWT.decode(jws); // 拿到 header 中 x5c 数组中第一个 String header = new String(java.util.Base64.getDecoder().decode(decodedJWT.getHeader())); String x5c = com.alibaba.fastjson.JSONObject.parseObject(header).getJSONArray("x5c").getString(0); // 获取公钥 PublicKey publicKey = getPublicKeyByX5c(x5c); // 验证 token Algorithm algorithm = Algorithm.ECDSA256((ECPublicKey) publicKey, null); try { algorithm.verify(decodedJWT); } catch (SignatureVerificationException e) { throw new RuntimeException("签名验证失败"); } // 解析数据 return com.alibaba.fastjson.JSONObject.parseObject(new String(java.util.Base64.getDecoder().decode(decodedJWT.getPayload()))); } /** * 获取公钥 * @param x5c * @return * @throws */ private static PublicKey getPublicKeyByX5c(String x5c) throws CertificateException { byte[] x5c0Bytes = java.util.Base64.getDecoder().decode(x5c); CertificateFactory fact = CertificateFactory.getInstance("X.509"); X509Certificate cer = (X509Certificate) fact.generateCertificate(new ByteArrayInputStream(x5c0Bytes)); return cer.getPublicKey(); } /** * 获取请求内容 * * @param request * @return * @throws IOException */ private String getParam(HttpServletRequest request) throws IOException { // 读取参数 InputStream inputStream; StringBuilder sb = new StringBuilder(); inputStream = request.getInputStream(); String s; BufferedReader in = new BufferedReader(new InputStreamReader(inputStream, "UTF-8")); while ((s = in.readLine()) != null) { sb.append(s); } in.close(); inputStream.close(); return sb.toString(); } @ResponseBody @PostMapping("/testCallback") public void wechatPaymentGameCallback(HttpServletRequest request, HttpServletResponse response) throws Exception { System.err.println("进入回调"); } /** * 远程调用 根据用户id 查询充值金额 */ @PostMapping("/queryChargeByUserId/{userId}") public R queryChargeByUserId(@PathVariable("userId") Long userId) { BigDecimal reduce = orderService.lambdaQuery() .eq(Order::getAppUserId, userId) .eq(Order::getOrderFrom, 4) .eq(Order::getPaymentStatus, 2) .list().stream().filter(t -> t.getTotalAmount() != null) .map(Order::getTotalAmount).reduce(BigDecimal.ZERO, BigDecimal::add); return R.ok(reduce.toString()); } /** * 远程调用 根据订单id 查询订单明细 */ @PostMapping("/getOrderById/{orderId}") public R getOrderById(@PathVariable("orderId") Long orderId) { Long userId = tokenService.getLoginUser().getUserid(); if(userId ==null || userId == 0)return R.tokenError("登录失效"); Order one = orderService.lambdaQuery() .eq(Order::getId, orderId).one(); if (one!=null){ OrderPaymentRecord two = orderPaymentRecordService.lambdaQuery() .eq(OrderPaymentRecord::getOrderId, orderId) .ne(OrderPaymentRecord::getPaymentType, 4) .eq(OrderPaymentRecord::getPaymentStatus, 2).one(); if (two==null){ one.setRemark("余额支付"); one.setBalance(one.getTotalAmount()); }else{ switch (two.getPaymentType()){ case 1: one.setRemark("微信支付"); break; case 2: one.setRemark("支付宝支付"); break; case 3: one.setRemark("苹果内购"); } one.setPayOrderNo(two.getPayOrderNo()); } if (one.getCommissionId()!=null){ switch (one.getOrderFrom()){ case 1: one.setRemark("购买疗愈"); break; case 2: one.setRemark("购买课程"); break; case 3: one.setRemark("购买会员"); case 4: one.setRemark("充值"); } } return R.ok(one); } return R.ok(); } }