| | |
| | | // 专车wrapper |
| | | between = new EntityWrapper<TOrderPrivateCar>() |
| | | .isNotNull("activityId") |
| | | .isNotNull("discountMoney"); |
| | | .isNotNull("discountMoney") |
| | | .between("insertTime", start, end); |
| | | |
| | | // 小件物流wrapper |
| | | between1 = new EntityWrapper<TOrderLogistics>() |
| | | .isNotNull("activityId") |
| | | .isNotNull("discountMoney"); |
| | | .isNotNull("discountMoney") |
| | | .between("insertTime", start, end); |
| | | |
| | | // 已使用优惠券记录wrapper |
| | | between2 = new EntityWrapper<TOrderPrivateCar>() |
| | | .isNotNull("couponId") |
| | | .isNotNull("couponMoney"); |
| | | .isNotNull("couponMoney") |
| | | .between("insertTime", start, end); |
| | | |
| | | between22 = new EntityWrapper<TOrderLogistics>() |
| | | .isNotNull("couponId") |
| | | .isNotNull("couponMoney"); |
| | | .isNotNull("couponMoney") |
| | | .between("insertTime", start, end); |
| | | |
| | | // 已使用红包记录wrapper |
| | | between3 = new EntityWrapper<TOrderPrivateCar>() |
| | | .isNotNull("redPacketId") |
| | | .isNotNull("redPacketMoney"); |
| | | .isNotNull("redPacketMoney") |
| | | .between("insertTime", start, end); |
| | | |
| | | between33 = new EntityWrapper<TOrderLogistics>() |
| | | .isNotNull("redPacketId") |
| | | .isNotNull("redPacketMoney"); |
| | | .isNotNull("redPacketMoney") |
| | | .between("insertTime", start, end); |
| | | |
| | | // 司机已消费金额 |
| | | between4 = new EntityWrapper<BalanceUsageRecord>() |
| | | .eq("type",1) |
| | | .ne("purpose", 6); |
| | | .ne("purpose", 6) |
| | | .between("insertTime", start, end); |
| | | |
| | | // 司机提现 |
| | | driverWrapper = new EntityWrapper<TPubWithdrawal>() |
| | | .eq("state", 2) |
| | | .eq("type",1) |
| | | .eq("userType", 2) |
| | | .between("insertTime", start, end); |
| | | |
| | | ; |
| | | }else{ |
| | | driverWrapper = new EntityWrapper<TPubWithdrawal>() |
| | |
| | | GrantVO grantVO = new GrantVO(); |
| | | grantVO.setInsertTime(format.format(userRedPacketRecord.getInsertTime())); |
| | | grantVO.setType("红包"); |
| | | // JSONArray objects = JSONArray.parseArray(userRedPacketRecord.getRedPacketId()); |
| | | // BigDecimal temp = new BigDecimal(BigInteger.ZERO); |
| | | // for (int i = 0; i < objects.size(); i++) { |
| | | // String string = objects.getJSONObject(i).getString("money"); |
| | | // temp = temp.add(new BigDecimal(string)); |
| | | // } |
| | | if (userRedPacketRecord.getRedPacketMoney()==null){ |
| | | continue; |
| | | } |
| | |
| | | GrantVO grantVO = new GrantVO(); |
| | | grantVO.setInsertTime(format.format(userRedPacketRecord.getInsertTime())); |
| | | grantVO.setType("红包"); |
| | | JSONArray objects = JSONArray.parseArray(userRedPacketRecord.getRedPacketId()); |
| | | BigDecimal temp = new BigDecimal(BigInteger.ZERO); |
| | | for (int i = 0; i < objects.size(); i++) { |
| | | String string = objects.getJSONObject(i).getString("money"); |
| | | temp = temp.add(new BigDecimal(string)); |
| | | if (userRedPacketRecord.getRedPacketMoney()==null){ |
| | | continue; |
| | | } |
| | | grantVO.setAmount(temp.toString()); |
| | | if (userRedPacketRecord.getRedPacketMoney().compareTo(new BigDecimal("0"))==0){ |
| | | continue; |
| | | } |
| | | grantVO.setAmount(userRedPacketRecord.getRedPacketMoney().toString()); |
| | | TUser tUser = appUserService.selectById(userRedPacketRecord.getUserId()); |
| | | if (tUser!=null){ |
| | | grantVO.setName(tUser.getNickName()); |
| | |
| | | // 专车wrapper |
| | | between = new EntityWrapper<TOrderPrivateCar>() |
| | | .isNotNull("activityId") |
| | | .isNotNull("discountMoney"); |
| | | .isNotNull("discountMoney") |
| | | .between("insertTime", start, end); |
| | | |
| | | // 小件物流wrapper |
| | | between1 = new EntityWrapper<TOrderLogistics>() |
| | | .isNotNull("activityId") |
| | | .isNotNull("discountMoney"); |
| | | .isNotNull("discountMoney") |
| | | .between("insertTime", start, end); |
| | | |
| | | // 已使用优惠券记录wrapper |
| | | between2 = new EntityWrapper<TOrderPrivateCar>() |
| | | .isNotNull("couponId") |
| | | .isNotNull("couponMoney"); |
| | | .isNotNull("couponMoney") |
| | | .between("insertTime", start, end); |
| | | |
| | | between22 = new EntityWrapper<TOrderLogistics>() |
| | | .isNotNull("couponId") |
| | | .isNotNull("couponMoney"); |
| | | .isNotNull("couponMoney") |
| | | .between("insertTime", start, end); |
| | | |
| | | // 已使用红包记录wrapper |
| | | between3 = new EntityWrapper<TOrderPrivateCar>() |
| | | .isNotNull("redPacketId") |
| | | .isNotNull("redPacketMoney"); |
| | | .isNotNull("redPacketMoney") |
| | | .between("insertTime", start, end); |
| | | |
| | | between33 = new EntityWrapper<TOrderLogistics>() |
| | | .isNotNull("redPacketId") |
| | | .isNotNull("redPacketMoney"); |
| | | .isNotNull("redPacketMoney") |
| | | .between("insertTime", start, end); |
| | | |
| | | // 司机已消费金额 |
| | | between4 = new EntityWrapper<BalanceUsageRecord>() |
| | | .eq("type",1) |
| | | .ne("purpose", 6); |
| | | .ne("purpose", 6) |
| | | .between("insertTime", start, end); |
| | | |
| | | // 司机提现 |
| | | driverWrapper = new EntityWrapper<TPubWithdrawal>() |
| | | .eq("state", 2) |
| | | .eq("type",1) |
| | | .eq("userType", 2) |
| | | .between("insertTime", start, end); |
| | | |
| | | ; |
| | | }else{ |
| | | driverWrapper = new EntityWrapper<TPubWithdrawal>() |
| | |
| | | } |
| | | grantVO.setRemark("订单号:"+userRedPacketRecord.getOrderNum()); |
| | | res.add(grantVO); |
| | | redPackage = redPackage.add(new BigDecimal(userRedPacketRecord.getPayMoney().toString())); |
| | | redPackage = redPackage.add(userRedPacketRecord.getRedPacketMoney()); |
| | | } |
| | | for (TOrderLogistics userRedPacketRecord : userRedPacketRecords1) { |
| | | GrantVO grantVO = new GrantVO(); |
| | | grantVO.setInsertTime(format.format(userRedPacketRecord.getInsertTime())); |
| | | grantVO.setType("红包"); |
| | | JSONArray objects = JSONArray.parseArray(userRedPacketRecord.getRedPacketId()); |
| | | BigDecimal temp = new BigDecimal(BigInteger.ZERO); |
| | | for (int i = 0; i < objects.size(); i++) { |
| | | String string = objects.getJSONObject(i).getString("money"); |
| | | temp = temp.add(new BigDecimal(string)); |
| | | if (userRedPacketRecord.getRedPacketMoney()==null){ |
| | | continue; |
| | | } |
| | | grantVO.setAmount(temp.toString()); |
| | | if (userRedPacketRecord.getRedPacketMoney().compareTo(new BigDecimal("0"))==0){ |
| | | continue; |
| | | } |
| | | grantVO.setAmount(userRedPacketRecord.getRedPacketMoney().toString()); |
| | | TUser tUser = appUserService.selectById(userRedPacketRecord.getUserId()); |
| | | if (tUser!=null){ |
| | | grantVO.setName(tUser.getNickName()); |
| | |
| | | driverWithdrawal1 = driverWithdrawal1.add(new BigDecimal(balanceUsageRecord.getMoney().toString())); |
| | | res.add(grantVO); |
| | | } |
| | | |
| | | |
| | | // 总额 |
| | | total = total.add(redPackage).add(coupon).add(discount).add(driverConsume).add(driverWithdrawal1); |
| | | // 已使用司机奖励合计 |
| | | driver = driverConsume.add(driverWithdrawal1); |
| | | UseMoneyVO useMoneyVO = new UseMoneyVO(); |
| | | useMoneyVO.setTotal(total.add(driver)); |
| | | useMoneyVO.setTotal(total); |
| | | useMoneyVO.setDiscount(discount); |
| | | useMoneyVO.setRedPackage(redPackage); |
| | | useMoneyVO.setCoupon(coupon); |