From 3ae40be3383cb79c2abc28a1d51e8aaab1cec1a9 Mon Sep 17 00:00:00 2001 From: 无关风月 <443237572@qq.com> Date: 星期五, 06 九月 2024 19:12:39 +0800 Subject: [PATCH] 2.0bug修改 --- ManagementIGOTravel/guns-admin/src/main/java/com/stylefeng/guns/modular/system/controller/PlatformController.java | 448 ++++++++++++++++++++++++++++++++++++++++++++----------- 1 files changed, 353 insertions(+), 95 deletions(-) diff --git a/ManagementIGOTravel/guns-admin/src/main/java/com/stylefeng/guns/modular/system/controller/PlatformController.java b/ManagementIGOTravel/guns-admin/src/main/java/com/stylefeng/guns/modular/system/controller/PlatformController.java index b369640..d924c2c 100644 --- a/ManagementIGOTravel/guns-admin/src/main/java/com/stylefeng/guns/modular/system/controller/PlatformController.java +++ b/ManagementIGOTravel/guns-admin/src/main/java/com/stylefeng/guns/modular/system/controller/PlatformController.java @@ -12,9 +12,12 @@ import com.stylefeng.guns.modular.system.vo.PlatformVO; import com.stylefeng.guns.modular.system.vo.WaterMoneyVO; import com.stylefeng.guns.modular.system.vo.WaterVO; +import io.swagger.models.auth.In; +import org.checkerframework.checker.units.qual.A; import org.springframework.beans.factory.annotation.Autowired; import org.springframework.stereotype.Controller; import org.springframework.ui.Model; +import org.springframework.util.StringUtils; import org.springframework.web.bind.annotation.RequestMapping; import org.springframework.web.bind.annotation.ResponseBody; @@ -176,7 +179,7 @@ .ne("type", 1) .isNotNull("orderType")); }else{ - if (time == 5 && insertTime==null){ + if (time == 5 && !StringUtils.hasLength(insertTime)){ incomes = tIncomeService.selectList(new EntityWrapper<Income>() .eq("userType", 1) .eq("objectId",1) @@ -304,7 +307,7 @@ } EntityWrapper<SettlementDetail> settlementDetailEntityWrapper = new EntityWrapper<>(); - if (time == 5 && insertTime==null){ + if (time == 5 && !StringUtils.hasLength(insertTime)){ }else{ settlementDetailEntityWrapper.between("createTime", start, end); @@ -315,6 +318,7 @@ PlatformVO platformVO = new PlatformVO(); switch (settlementDetail.getOrderType()){ case 1: + // 专车订单 TOrderPrivateCar tOrderPrivateCar = orderPrivateCarService.selectById(settlementDetail.getOrderId()); if (tOrderPrivateCar==null){ @@ -333,20 +337,29 @@ platformVO.setMoney(bigDecimal1); platformVO.setPayType("现金支付"); if (settlementDetail.getSettlementRecordId()!=null){ - if (state!=null && state!=1){ - continue; - } - // 已结算 - platformVO.setState(1); SettlementRecord settlementRecord = settlementRecordService.selectById(settlementDetail.getSettlementRecordId()); - balance = balance.add(new BigDecimal(settlementDetail.getPrice())); - platformVO.setEndTime(format.format(settlementRecord.getDay())); + if (settlementRecord.getPaymentStatus()!=null && settlementRecord.getPaymentStatus()==2){ + if (state!=null && state!=1){ + continue; + } + // 已结算 + platformVO.setState(1); + balance = balance.add(new BigDecimal(settlementDetail.getPrice())); + platformVO.setEndTime(format.format(settlementRecord.getDay())); + }else{ + // 未结算 + if (state!=null && state!=2){ + continue; + } + platformVO.setState(2); + unBalance = unBalance.add(new BigDecimal(settlementDetail.getPrice())); + platformVO.setEndTime(format.format(settlementRecord.getDay())); + } }else{ + // 未结算 if (state!=null && state!=2){ continue; } - // 未结算 - platformVO.setState(2); unBalance = unBalance.add(new BigDecimal(settlementDetail.getPrice())); } @@ -372,20 +385,29 @@ platformVO.setInsertTime(format.format(tOrderLogistics.getInsertTime())); platformVO.setPayType("现金支付"); if (settlementDetail.getSettlementRecordId()!=null){ - if (state!=null && state!=1){ - continue; - } - // 已结算 - platformVO.setState(1); SettlementRecord settlementRecord = settlementRecordService.selectById(settlementDetail.getSettlementRecordId()); - balance = balance.add(new BigDecimal(settlementDetail.getPrice())); - platformVO.setEndTime(format.format(settlementRecord.getDay())); + if (settlementRecord.getPaymentStatus()!=null && settlementRecord.getPaymentStatus()==2){ + if (state!=null && state!=1){ + continue; + } + // 已结算 + platformVO.setState(1); + balance = balance.add(new BigDecimal(settlementDetail.getPrice())); + platformVO.setEndTime(format.format(settlementRecord.getDay())); + }else{ + // 未结算 + if (state!=null && state!=2){ + continue; + } + platformVO.setState(2); + unBalance = unBalance.add(new BigDecimal(settlementDetail.getPrice())); + platformVO.setEndTime(format.format(settlementRecord.getDay())); + } }else{ + // 未结算 if (state!=null && state!=2){ continue; } - // 未结算 - platformVO.setState(2); unBalance = unBalance.add(new BigDecimal(settlementDetail.getPrice())); } res.add(platformVO); @@ -414,6 +436,16 @@ @RequestMapping(value = "/water/getCount") @ResponseBody public Object getCount1(Integer time,String insertTime,Integer payType,Integer type) { + if (payType!=null){ + switch (payType){ + case 1: + payType = 2; + break; + case 2: + payType = 1; + break; + } + } if (time == null){ time = 1; } @@ -495,7 +527,14 @@ EntityWrapper<TOrderLogistics> tOrderLogisticsEntityWrapper = new EntityWrapper<>(); // 司机手动结算金额 Wrapper<SettlementDetail> orderType1 = new EntityWrapper<SettlementDetail>(); - if (time == 5 && insertTime==null){ + // 用户取消订单wrapper + Wrapper<OrderCancel> orderCancelEntityWrapper = new EntityWrapper<>(); + // 用户取消订单记录 + List<OrderCancel> orderCancels = new ArrayList<>(); + List<Integer> integers = new ArrayList<>(); + integers.add(1); + integers.add(2); + if (time == 5 && !StringUtils.hasLength(insertTime)){ // 余额充值wrapper orderType = new EntityWrapper<TPubTransactionDetails>() .eq("userType",1) @@ -521,6 +560,10 @@ // 司机手动结算金额 orderType1 = new EntityWrapper<SettlementDetail>() .in("orderType", Arrays.asList(1, 4)); + // 用户取消订单费用 + orderCancelEntityWrapper.eq("state", 2) + .eq("userType", 1).in("payType",integers) + ; }else{ orderType = new EntityWrapper<TPubTransactionDetails>() .eq("orderType", 5) @@ -550,16 +593,21 @@ .isNotNull("payMoney") .in("payType",Arrays.asList(1, 2)) .between("insertTime", start, end); + // 用户取消订单费用 + orderCancelEntityWrapper.eq("state", 2) + .eq("userType", 1) + .in("payType",integers) + .between("insertTime", start, end); } - - if (type != null){ switch (type){ case 1: // 只查询用户订单 - tOrderPrivateCars = orderPrivateCarService.selectList(tOrderPrivateCarEntityWrapper); + tOrderPrivateCars = orderPrivateCarService.selectList(tOrderPrivateCarEntityWrapper); tOrderLogistics = orderLogisticsService.selectList(tOrderLogisticsEntityWrapper); - + // 用户取消订单费用 + orderCancelEntityWrapper.eq("state", 2) + .eq("userType", 1); break; case 2: // 只查询用户充值 @@ -587,6 +635,8 @@ settlementDetails1 = settlementDetailService.selectList(orderType1); driver = pubWithdrawalService.selectList(between); user = pubWithdrawalService.selectList(userWrapper); + orderCancels = orderCancelService.selectList(orderCancelEntityWrapper); + } List<WaterVO> res = new ArrayList<>(); SimpleDateFormat format = new SimpleDateFormat("yyyy-MM-dd HH:mm:ss"); @@ -600,6 +650,7 @@ BigDecimal driverWithdrawal = new BigDecimal("0"); // 用户提现金额 BigDecimal userWithdrawal = new BigDecimal("0"); + // 用户订单消费 for (TOrderPrivateCar tOrderPrivateCar : tOrderPrivateCars) { if (payType!=null){ @@ -623,9 +674,9 @@ if (tOrderPrivateCar != null){ waterVO.setCode(tOrderPrivateCar.getOrderNum()); String string = tOrderPrivateCar.getPayMoney().toString(); - waterVO.setMoney(new BigDecimal(string)); + waterVO.setMoney(new BigDecimal(string)+""); }else{ - waterVO.setMoney(new BigDecimal("0")); + waterVO.setMoney(new BigDecimal("0")+""); } TUser user1 = appUserService.selectById(tOrderPrivateCar.getUserId()); if (user1!=null){ @@ -651,8 +702,8 @@ // 小件物流 waterVO.setCode(tOrderLogistic.getOrderNum()); String string = tOrderLogistic.getPayMoney().toString(); - waterVO.setMoney(new BigDecimal(string)); - waterVO.setMoney(new BigDecimal("0")); + waterVO.setMoney(new BigDecimal(string)+""); + waterVO.setMoney(new BigDecimal("0")+""); TUser user2 = appUserService.selectById(tOrderLogistic.getUserId()); if (user2!=null){ waterVO.setName(user2.getNickName()); @@ -674,9 +725,83 @@ userConsume = userConsume.add(new BigDecimal(tOrderLogistic.getPayMoney().toString())); break; } + for (OrderCancel orderCancel : orderCancels) { + WaterVO waterVO = new WaterVO(); + switch (orderCancel.getOrderType()){ + case 1: + TOrderPrivateCar tOrderPrivateCar = orderPrivateCarService.selectById(orderCancel.getOrderId()); + if (tOrderPrivateCar == null){ + continue; + } + waterVO.setInsertTime(format.format(tOrderPrivateCar.getInsertTime())); + waterVO.setType("用户订单消费"); + if (payType!=null){ + if (!Objects.equals(tOrderPrivateCar.getPayType(), payType)){ + continue; + } + } + switch (orderCancel.getPayType()){ + case 1: + waterVO.setPayType("手机支付"); + break; + case 2: + waterVO.setPayType("银行卡支付"); + break; + case 3: + waterVO.setPayType("余额支付"); + break; + } + // 专车 + waterVO.setCode(tOrderPrivateCar.getOrderNum()); + String string = orderCancel.getMoney().toString(); + waterVO.setMoney(new BigDecimal(string)+""); + TUser user1 = appUserService.selectById(tOrderPrivateCar.getUserId()); + if (user1!=null){ + waterVO.setName(user1.getNickName()); + waterVO.setPhone(user1.getPhone()); + } + waterVO.setRemark(tOrderPrivateCar.getRemark()); + res.add(waterVO); + userConsume = userConsume.add(new BigDecimal(orderCancel.getMoney().toString())); + break; + case 4: + TOrderLogistics tOrderLogistics1 = orderLogisticsService.selectById(orderCancel.getOrderId()); + if (payType!=null){ + if (!Objects.equals(tOrderLogistics1.getPayType(), payType)){ + continue; + } + } + WaterVO waterVO1 = new WaterVO(); + waterVO1.setInsertTime(format.format(tOrderLogistics1.getInsertTime())); + waterVO1.setType("用户订单消费"); + // 小件物流 + waterVO1.setCode(tOrderLogistics1.getOrderNum()); + String string1 = orderCancel.getMoney().toString(); + waterVO1.setMoney(new BigDecimal(string1)+""); + TUser user2 = appUserService.selectById(tOrderLogistics1.getUserId()); + if (user2!=null){ + waterVO1.setName(user2.getNickName()); + waterVO1.setPhone(user2.getPhone()); + } + waterVO1.setType("用户订单消费"); + switch (orderCancel.getPayType()){ + case 1: + waterVO.setPayType("手机支付"); + break; + case 2: + waterVO.setPayType("银行卡支付"); + break; + case 3: + waterVO.setPayType("余额支付"); + break; + } + waterVO1.setRemark(tOrderLogistics1.getRemark()); - - + res.add(waterVO1); + userConsume = userConsume.add(new BigDecimal(orderCancel.getMoney().toString())); + break; + } + } // 司机提现 for (TPubWithdrawal tPubWithdrawal : driver) { if(payType!=null && payType == 2){ @@ -691,8 +816,8 @@ waterVO.setPhone(tDriver.getPhone()); } - waterVO.setMoney(tPubWithdrawal.getMoney()); - waterVO.setPayType("银行卡支付"); + waterVO.setMoney("-"+tPubWithdrawal.getMoney()); + waterVO.setPayType("手机支付"); waterVO.setType("司机提现"); waterVO.setRemark(tPubWithdrawal.getRemark()); res.add(waterVO); @@ -704,15 +829,17 @@ break; } WaterVO waterVO = new WaterVO(); - waterVO.setInsertTime(format.format(tPubWithdrawal.getHandleTime())); + if (tPubWithdrawal.getHandleTime()!=null){ + waterVO.setInsertTime(format.format(tPubWithdrawal.getHandleTime())); + } waterVO.setCode(tPubWithdrawal.getCode()); TUser user2 = appUserService.selectById(tPubWithdrawal.getUserId()); if (user2!=null){ waterVO.setName(user2.getNickName()); waterVO.setPhone(user2.getPhone()); } - waterVO.setMoney(tPubWithdrawal.getMoney()); - waterVO.setPayType("银行卡支付"); + waterVO.setMoney("-"+tPubWithdrawal.getMoney()); + waterVO.setPayType("手机支付"); waterVO.setType("用户提现"); waterVO.setRemark(tPubWithdrawal.getRemark()); res.add(waterVO); @@ -724,6 +851,10 @@ Integer orderId = tPubTransactionDetail.getOrderId(); PaymentRecord paymentRecord = paymentRecordService.selectById(orderId); if (paymentRecord!=null){ + if (paymentRecord.getState() == 1){ + // 临时数据 + continue; + } waterVO.setInsertTime(format.format(paymentRecord.getInsertTime())); waterVO.setCode(paymentRecord.getCode()); if (paymentRecord.getPayType()!=null){ @@ -747,7 +878,7 @@ } } - waterVO.setMoney(new BigDecimal(paymentRecord.getAmount().toString())); + waterVO.setMoney(new BigDecimal(paymentRecord.getAmount().toString())+""); }else{ continue; } @@ -772,11 +903,11 @@ case 1: SettlementRecord settlementRecord = settlementRecordService.selectById(income.getSettlementRecordId()); if (settlementRecord!=null){ - if (settlementRecord.getPayType()!=null){ + if (settlementRecord.getPaymentStatus()!=null && settlementRecord.getPaymentStatus() == 2){ switch (settlementRecord.getPayType()){ case 1: if (payType!=null){ - if (payType == 1){ + if (payType != 1){ continue; } } @@ -784,7 +915,7 @@ break; case 2: if (payType!=null){ - if (payType == 2){ + if (payType != 2){ continue; } } @@ -795,6 +926,8 @@ continue; } + }else{ + continue; } }else{ continue; @@ -818,7 +951,7 @@ if (income.getOrderMoney() != null){ String string = income.getPrice().toString(); BigDecimal bigDecimal1 = new BigDecimal(string); - platformVO.setMoney(bigDecimal1); + platformVO.setMoney(bigDecimal1+""); }else{ continue; } @@ -835,12 +968,12 @@ break; case 4: SettlementRecord settlementRecord1 = settlementRecordService.selectById(income.getSettlementRecordId()); - if (settlementRecord1==null){ + if (settlementRecord1!=null&& settlementRecord1.getPaymentStatus()!=null && settlementRecord1.getPaymentStatus() == 2){ if (settlementRecord1.getPayType()!=null){ switch (settlementRecord1.getPayType()){ case 1: if (payType!=null){ - if (payType == 1){ + if (payType != 1){ continue; } } @@ -848,7 +981,7 @@ break; case 2: if (payType!=null){ - if (payType == 2){ + if (payType != 2){ continue; } } @@ -860,6 +993,8 @@ } } + }else { + continue; } // 小件物流 // 查询订单信息 @@ -874,7 +1009,7 @@ platformVO.setPhone(tDriver1.getPhone()); } platformVO.setRemark(tOrderLogistics1.getRemark()); - platformVO.setMoney(new BigDecimal(income.getPrice())); + platformVO.setMoney(new BigDecimal(income.getPrice())+""); if (income.getCreateTime()!=null){ platformVO.setInsertTime(format.format(income.getCreateTime())); } @@ -890,6 +1025,8 @@ break; } } + // 过滤掉res中insertTime未空的数据 + res.removeIf(waterVO -> waterVO.getInsertTime() == null); Collections.sort(res, Comparator.comparing(WaterVO::getInsertTime).reversed()); WaterMoneyVO waterMoneyVO = new WaterMoneyVO(); BigDecimal add = userRecharge.add(userConsume).add(balance).subtract(driverWithdrawal).subtract(userWithdrawal); @@ -913,9 +1050,21 @@ private IPaymentRecordService paymentRecordService; @Autowired private ITUserService appUserService; + @Autowired + private IOrderCancelService orderCancelService; @RequestMapping(value = "/water/list") @ResponseBody public Object list1(Integer time,String insertTime,Integer payType,Integer type) { + if (payType!=null){ + switch (payType){ + case 1: + payType = 2; + break; + case 2: + payType = 1; + break; + } + } if (time == null){ time = 1; } @@ -977,6 +1126,8 @@ // 用户小件物流订单记录 List<TOrderPrivateCar> tOrderPrivateCars = new ArrayList<>(); List<TOrderLogistics> tOrderLogistics = new ArrayList<>(); + // 用户取消订单记录 + List<OrderCancel> orderCancels = new ArrayList<>(); // 用户充值 List<TPubTransactionDetails> tPubTransactionDetails = new ArrayList<>(); // 司机结算总额 @@ -995,9 +1146,14 @@ EntityWrapper<TOrderPrivateCar> tOrderPrivateCarEntityWrapper = new EntityWrapper<>(); // 用户小件物流订单wrapper EntityWrapper<TOrderLogistics> tOrderLogisticsEntityWrapper = new EntityWrapper<>(); + // 用户取消订单wrapper + Wrapper<OrderCancel> orderCancelEntityWrapper = new EntityWrapper<>(); // 司机手动结算金额 Wrapper<SettlementDetail> orderType1 = new EntityWrapper<SettlementDetail>(); - if (time == 5 && insertTime==null){ + List<Integer> integers = new ArrayList<>(); + integers.add(1); + integers.add(2); + if (time == 5 && !StringUtils.hasLength(insertTime)){ // 余额充值wrapper orderType = new EntityWrapper<TPubTransactionDetails>() .eq("userType",1) @@ -1024,6 +1180,10 @@ orderType1 = new EntityWrapper<SettlementDetail>() .isNotNull("settlementRecordId") .in("orderType", Arrays.asList(1, 4)); + // 用户取消订单费用 + orderCancelEntityWrapper.eq("state", 2) + .in("payType",integers) + .eq("userType", 1); }else{ orderType = new EntityWrapper<TPubTransactionDetails>() .eq("orderType", 5) @@ -1054,6 +1214,11 @@ .isNotNull("payMoney") .in("payType",Arrays.asList(1, 2)) .between("insertTime", start, end); + // 用户取消订单费用 + orderCancelEntityWrapper.eq("state", 2) + .eq("userType", 1) + .in("payType",integers) + .between("insertTime", start, end); } @@ -1063,7 +1228,7 @@ // 只查询用户订单 tOrderPrivateCars = orderPrivateCarService.selectList(tOrderPrivateCarEntityWrapper); tOrderLogistics = orderLogisticsService.selectList(tOrderLogisticsEntityWrapper); - + orderCancels = orderCancelService.selectList(orderCancelEntityWrapper); break; case 2: // 只查询用户充值 @@ -1091,6 +1256,7 @@ settlementDetails1 = settlementDetailService.selectList(orderType1); driver = pubWithdrawalService.selectList(between); user = pubWithdrawalService.selectList(userWrapper); + orderCancels = orderCancelService.selectList(orderCancelEntityWrapper); } List<WaterVO> res = new ArrayList<>(); SimpleDateFormat format = new SimpleDateFormat("yyyy-MM-dd HH:mm:ss"); @@ -1112,7 +1278,6 @@ continue; } } - WaterVO waterVO = new WaterVO(); waterVO.setInsertTime(format.format(tOrderPrivateCar.getInsertTime())); waterVO.setType("用户订单消费"); @@ -1125,13 +1290,9 @@ break; } // 专车 - if (tOrderPrivateCar != null){ waterVO.setCode(tOrderPrivateCar.getOrderNum()); String string = tOrderPrivateCar.getPayMoney().toString(); - waterVO.setMoney(new BigDecimal(string)); - }else{ - waterVO.setMoney(new BigDecimal("0")); - } + waterVO.setMoney(new BigDecimal(string)+""); TUser user1 = appUserService.selectById(tOrderPrivateCar.getUserId()); if (user1!=null){ waterVO.setName(user1.getNickName()); @@ -1156,8 +1317,8 @@ // 小件物流 waterVO.setCode(tOrderLogistic.getOrderNum()); String string = tOrderLogistic.getPayMoney().toString(); - waterVO.setMoney(new BigDecimal(string)); - waterVO.setMoney(new BigDecimal("0")); + waterVO.setMoney(new BigDecimal(string)+""); + waterVO.setMoney(new BigDecimal("0")+""); TUser user2 = appUserService.selectById(tOrderLogistic.getUserId()); if (user2!=null){ waterVO.setName(user2.getNickName()); @@ -1179,6 +1340,83 @@ userConsume = userConsume.add(new BigDecimal(tOrderLogistic.getPayMoney().toString())); break; } + for (OrderCancel orderCancel : orderCancels) { + WaterVO waterVO = new WaterVO(); + switch (orderCancel.getOrderType()){ + case 1: + TOrderPrivateCar tOrderPrivateCar = orderPrivateCarService.selectById(orderCancel.getOrderId()); + if (tOrderPrivateCar == null){ + continue; + } + waterVO.setInsertTime(format.format(tOrderPrivateCar.getInsertTime())); + waterVO.setType("用户订单消费"); + if (payType!=null){ + if (!Objects.equals(tOrderPrivateCar.getPayType(), payType)){ + continue; + } + } + switch (orderCancel.getPayType()){ + case 1: + waterVO.setPayType("手机支付"); + break; + case 2: + waterVO.setPayType("银行卡支付"); + break; + case 3: + waterVO.setPayType("余额支付"); + break; + } + // 专车 + waterVO.setCode(tOrderPrivateCar.getOrderNum()); + String string = orderCancel.getMoney().toString(); + waterVO.setMoney(new BigDecimal(string)+""); + TUser user1 = appUserService.selectById(tOrderPrivateCar.getUserId()); + if (user1!=null){ + waterVO.setName(user1.getNickName()); + waterVO.setPhone(user1.getPhone()); + } + waterVO.setRemark(tOrderPrivateCar.getRemark()); + res.add(waterVO); + userConsume = userConsume.add(new BigDecimal(orderCancel.getMoney().toString())); + break; + case 4: + TOrderLogistics tOrderLogistics1 = orderLogisticsService.selectById(orderCancel.getOrderId()); + if (payType!=null){ + if (!Objects.equals(tOrderLogistics1.getPayType(), payType)){ + continue; + } + } + WaterVO waterVO1 = new WaterVO(); + waterVO1.setInsertTime(format.format(tOrderLogistics1.getInsertTime())); + waterVO1.setType("用户订单消费"); + // 小件物流 + waterVO1.setCode(tOrderLogistics1.getOrderNum()); + String string1 = orderCancel.getMoney().toString(); + waterVO1.setMoney(new BigDecimal(string1)+""); + TUser user2 = appUserService.selectById(tOrderLogistics1.getUserId()); + if (user2!=null){ + waterVO1.setName(user2.getNickName()); + waterVO1.setPhone(user2.getPhone()); + } + waterVO1.setType("用户订单消费"); + switch (orderCancel.getPayType()){ + case 1: + waterVO.setPayType("手机支付"); + break; + case 2: + waterVO.setPayType("银行卡支付"); + break; + case 3: + waterVO.setPayType("余额支付"); + break; + } + waterVO1.setRemark(tOrderLogistics1.getRemark()); + + res.add(waterVO1); + userConsume = userConsume.add(new BigDecimal(orderCancel.getMoney().toString())); + break; + } + } // 司机提现 for (TPubWithdrawal tPubWithdrawal : driver) { if(payType!=null && payType == 2){ @@ -1193,8 +1431,8 @@ waterVO.setPhone(tDriver.getPhone()); } - waterVO.setMoney(tPubWithdrawal.getMoney()); - waterVO.setPayType("银行卡支付"); + waterVO.setMoney("-"+tPubWithdrawal.getMoney()); + waterVO.setPayType("手机支付"); waterVO.setType("司机提现"); waterVO.setRemark(tPubWithdrawal.getRemark()); res.add(waterVO); @@ -1213,8 +1451,8 @@ waterVO.setName(user2.getNickName()); waterVO.setPhone(user2.getPhone()); } - waterVO.setMoney(tPubWithdrawal.getMoney()); - waterVO.setPayType("银行卡支付"); + waterVO.setMoney("-"+tPubWithdrawal.getMoney()); + waterVO.setPayType("手机支付"); waterVO.setType("用户提现"); waterVO.setRemark(tPubWithdrawal.getRemark()); res.add(waterVO); @@ -1226,6 +1464,10 @@ Integer orderId = tPubTransactionDetail.getOrderId(); PaymentRecord paymentRecord = paymentRecordService.selectById(orderId); if (paymentRecord!=null){ + if (paymentRecord.getState() == 1){ + // 临时数据 + continue; + } waterVO.setInsertTime(format.format(paymentRecord.getInsertTime())); waterVO.setCode(paymentRecord.getCode()); if (paymentRecord.getPayType()!=null){ @@ -1253,7 +1495,7 @@ } } - waterVO.setMoney(new BigDecimal(paymentRecord.getAmount().toString())); + waterVO.setMoney(new BigDecimal(paymentRecord.getAmount().toString())+""); }else{ continue; } @@ -1271,19 +1513,18 @@ userRecharge = userRecharge.add(new BigDecimal(paymentRecord.getAmount().toString())); } // 查询所有已结算的订单 - // 查询所有已结算的订单 for (SettlementDetail income : settlementDetails1) { WaterVO platformVO = new WaterVO(); platformVO.setType("司机结算"); switch (income.getOrderType()){ case 1: SettlementRecord settlementRecord = settlementRecordService.selectById(income.getSettlementRecordId()); - if (settlementRecord!=null){ + if (settlementRecord!=null && settlementRecord.getPaymentStatus()!=null && settlementRecord.getPaymentStatus() == 2){ if (settlementRecord.getPayType()!=null){ switch (settlementRecord.getPayType()){ case 1: if (payType!=null){ - if (payType == 1){ + if (payType != 1){ continue; } } @@ -1291,7 +1532,7 @@ break; case 2: if (payType!=null){ - if (payType == 2){ + if (payType != 2){ continue; } } @@ -1325,7 +1566,7 @@ if (income.getPrice() != null){ String string = income.getPrice().toString(); BigDecimal bigDecimal1 = new BigDecimal(string); - platformVO.setMoney(bigDecimal1); + platformVO.setMoney(bigDecimal1+""); }else{ continue; } @@ -1343,12 +1584,12 @@ // 小件物流 // 查询订单信息 SettlementRecord settlementRecord1 = settlementRecordService.selectById(income.getSettlementRecordId()); - if (settlementRecord1==null){ - if (settlementRecord1.getPayType()!=null){ + if (settlementRecord1!=null){ + if (settlementRecord1.getPaymentStatus()!=null && settlementRecord1.getPaymentStatus() == 2){ switch (settlementRecord1.getPayType()){ case 1: if (payType!=null){ - if (payType == 1){ + if (payType != 1){ continue; } } @@ -1356,7 +1597,7 @@ break; case 2: if (payType!=null){ - if (payType == 2){ + if (payType != 2){ continue; } } @@ -1367,7 +1608,11 @@ continue; } + }else{ + continue; } + }else{ + continue; } TOrderLogistics tOrderLogistics1 = orderLogisticsService.selectById(income.getOrderId()); if (tOrderLogistics1==null){ @@ -1403,7 +1648,7 @@ } platformVO.setRemark(tOrderLogistics1.getRemark()); - platformVO.setMoney(BigDecimal.valueOf(income.getPrice())); + platformVO.setMoney(BigDecimal.valueOf(income.getPrice())+""); if (income.getCreateTime()!=null){ platformVO.setInsertTime(format.format(income.getCreateTime())); } @@ -1500,7 +1745,8 @@ .ne("type", 1) .isNotNull("orderType")); }else{ - if (time == 5 && insertTime==null){ + + if (time == 5 && !StringUtils.hasLength(insertTime)){ incomes = tIncomeService.selectList(new EntityWrapper<Income>() .eq("userType", 1) .eq("objectId",1) @@ -1516,7 +1762,7 @@ } } EntityWrapper<SettlementDetail> settlementDetailEntityWrapper = new EntityWrapper<>(); - if (time == 5 && insertTime==null){ + if (time == 5 && !StringUtils.hasLength(insertTime)){ }else{ settlementDetailEntityWrapper.between("createTime", start, end); @@ -1623,7 +1869,6 @@ break; } } - // 查询所有现金支付的订单 for (SettlementDetail settlementDetail : settlementDetails) { PlatformVO platformVO = new PlatformVO(); @@ -1640,33 +1885,37 @@ platformVO.setDriverName(tDriver.getFirstName()+tDriver.getLastName()); platformVO.setDriverPhone(tDriver.getPhone()); } - platformVO.setRemark(tOrderPrivateCar.getRemark()); - platformVO.setInsertTime(format.format(tOrderPrivateCar.getInsertTime())); String string = settlementDetail.getPrice().toString(); BigDecimal bigDecimal1 = new BigDecimal(string); platformVO.setMoney(bigDecimal1); platformVO.setPayType("现金支付"); - if (settlementDetail.getSettlementRecordId()!=null){ - if (state!=null && state!=1){ - continue; - } - // 已结算 - platformVO.setState(1); SettlementRecord settlementRecord = settlementRecordService.selectById(settlementDetail.getSettlementRecordId()); - balance = balance.add(new BigDecimal(settlementDetail.getPrice())); - platformVO.setEndTime(format.format(settlementRecord.getDay())); + if (settlementRecord.getPaymentStatus()!=null && settlementRecord.getPaymentStatus()==2){ + if (state!=null && state!=1){ + continue; + } + // 已结算 + platformVO.setState(1); + balance = balance.add(new BigDecimal(settlementDetail.getPrice())); + platformVO.setEndTime(format.format(settlementRecord.getPayTime())); + }else{ + // 未结算 + if (state!=null && state!=2){ + continue; + } + platformVO.setState(2); + unBalance = unBalance.add(new BigDecimal(settlementDetail.getPrice())); + } }else{ + // 未结算 if (state!=null && state!=2){ continue; } - // 未结算 - platformVO.setState(2); unBalance = unBalance.add(new BigDecimal(settlementDetail.getPrice())); } - res.add(platformVO); break; case 4: @@ -1689,20 +1938,29 @@ platformVO.setInsertTime(format.format(tOrderLogistics.getInsertTime())); platformVO.setPayType("现金支付"); if (settlementDetail.getSettlementRecordId()!=null){ - if (state!=null && state!=1){ - continue; - } - // 已结算 - platformVO.setState(1); SettlementRecord settlementRecord = settlementRecordService.selectById(settlementDetail.getSettlementRecordId()); - balance = balance.add(new BigDecimal(settlementDetail.getPrice())); - platformVO.setEndTime(format.format(settlementRecord.getDay())); + if (settlementRecord.getPaymentStatus()!=null && settlementRecord.getPaymentStatus()==2){ + if (state!=null && state!=1){ + continue; + } + // 已结算 + platformVO.setState(1); + balance = balance.add(new BigDecimal(settlementDetail.getPrice())); + platformVO.setEndTime(format.format(settlementRecord.getDay())); + }else{ + // 未结算 + if (state!=null && state!=2){ + continue; + } + platformVO.setState(2); + unBalance = unBalance.add(new BigDecimal(settlementDetail.getPrice())); + platformVO.setEndTime(format.format(settlementRecord.getDay())); + } }else{ + // 未结算 if (state!=null && state!=2){ continue; } - // 未结算 - platformVO.setState(2); unBalance = unBalance.add(new BigDecimal(settlementDetail.getPrice())); } res.add(platformVO); -- Gitblit v1.7.1