|  |  | 
 |  |  |         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); | 
 |  |  |             } | 
 |  |  |         } |