| | |
| | | QueryWrapper<WxBillDetail> queryWrapper = new QueryWrapper<>(); |
| | | queryWrapper.lambda().ge(param.getStartDate() !=null,WxBillDetail::getPid,DateUtil.getShortDateStr(param.getStartDate())); |
| | | queryWrapper.lambda().le(param.getEndDate() !=null,WxBillDetail::getPid,DateUtil.getShortDateStr(param.getEndDate())); |
| | | queryWrapper.lambda().ne(WxBillDetail::getAppid, WxMiniConfig.wxPayService.getConfig().getAppId());//非自行车收入统计 |
| | | queryWrapper.lambda().ne(WxBillDetail::getAppid, WxMiniConfig.wxPayV2Service.getConfig().getSubAppId());//非自行车收入统计 |
| | | queryWrapper.lambda().groupBy(WxBillDetail::getBillStatus); |
| | | queryWrapper.select( "count(id) as sum_bill" |
| | | ,"sum(settlement_total_fee) as settlement_total_fee" |
| | |
| | | // Date ydate = DateUtil.addDaysToDate(new Date(), -1); |
| | | request.setBillDate(billDate); |
| | | request.setBillType("SUCCESS"); |
| | | request.setSubMchId(WxMiniConfig.wxProperties.getSubMchId()); |
| | | |
| | | WxPayBillResult response = null; |
| | | try { |
| | | response = WxMiniConfig.wxPayService.downloadBill(request); |
| | | response = WxMiniConfig.wxPayV2Service.downloadBill(request); |
| | | }catch (WxPayException e){ |
| | | |
| | | } |
| | |
| | | //请求退款单交易记录汇总数据 |
| | | WxPayBillResult responseRefund = null; |
| | | try { |
| | | responseRefund = WxMiniConfig.wxPayService.downloadBill(request); |
| | | responseRefund = WxMiniConfig.wxPayV2Service.downloadBill(request); |
| | | }catch (WxPayException e){ |
| | | |
| | | } |
| | |
| | | detail.setRefundSuccessDate(DateUtil.getDateFromString2(info.getRefundSuccessTime()));//成功退款时间 |
| | | detail.setRefundApplyDate(DateUtil.getDateFromString2(info.getRefundTime())); //申请退款时间 |
| | | //计算自行车收入,匹配来自自行车小程序的所有支付成功和退款成功的金额,作为自行车收入(累计收款金额-累计退款成功金额) |
| | | if(StringUtils.equals(detail.getAppid(), WxMiniConfig.wxPayService.getConfig().getAppId())){ |
| | | if(StringUtils.equals(detail.getAppid(), WxMiniConfig.wxPayV2Service.getConfig().getSubAppId())){ |
| | | //自行车收入累计收款金额(支付成功总金额-退款总金额) |
| | | if(StringUtils.equals(info.getTradeState(),"SUCCESS")){ |
| | | //如果是交易 |
| | |
| | | bill.setBikeFee(bill.getBikeFee().subtract(detail.getCmmsAmt()) ); |
| | | } |
| | | } |
| | | |
| | | detailList.add(detail); |
| | | } |
| | | } |