| | |
| | | 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.wxPayV2Service.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.wxPayV2Service.downloadBill(request); |