| | |
|---|
| | | 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().getAppId());//非自行车收入统计 |
|---|
| | | queryWrapper.lambda().groupBy(WxBillDetail::getBillStatus); |
|---|
| | | queryWrapper.select( "count(id) as sum_bill" |
|---|
| | | ,"sum(settlement_total_fee) as settlement_total_fee" |
|---|
| | |
|---|
| | | request.setBillType("SUCCESS"); |
|---|
| | | 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().getAppId())){ |
|---|
| | | //自行车收入累计收款金额(支付成功总金额-退款总金额） |
|---|
| | | if(StringUtils.equals(info.getTradeState(),"SUCCESS")){ |
|---|
| | | //如果是交易 |
|---|
