From af335bf1ef9104dc62c721e142eca790356d18b6 Mon Sep 17 00:00:00 2001 From: Pu Zhibing <393733352@qq.com> Date: 星期三, 02 四月 2025 09:42:25 +0800 Subject: [PATCH] 修改bug --- ManagementIGOTravel/guns-admin/src/main/java/com/stylefeng/guns/modular/system/controller/PlatformController.java | 124 ++++++++++++++++++++++++++--------------- 1 files changed, 79 insertions(+), 45 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 af20a78..0169e04 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 @@ -188,9 +188,20 @@ } EntityWrapper<SettlementDetail> settlementDetailEntityWrapper = new EntityWrapper<>(); - settlementDetailEntityWrapper.between("createTime", start, end); if (state!=null && state == 2){ - settlementDetailEntityWrapper.eq("paymentStatus", 2); + List<SettlementRecord> paymentStatus = settlementRecordService.selectList(new EntityWrapper<SettlementRecord>().eq("paymentStatus", 1)); + if(paymentStatus.size() > 0){ + settlementDetailEntityWrapper.in("settlementRecordId", paymentStatus.stream().map(SettlementRecord::getId).collect(Collectors.toList())); + }else{ + settlementDetailEntityWrapper.eq("settlementRecordId", 0); + } + }else if (state!=null && state == 1){ + List<SettlementRecord> paymentStatus = settlementRecordService.selectList(new EntityWrapper<SettlementRecord>().eq("paymentStatus", 2)); + if(paymentStatus.size() > 0){ + settlementDetailEntityWrapper.in("settlementRecordId", paymentStatus.stream().map(SettlementRecord::getId).collect(Collectors.toList())); + }else{ + settlementDetailEntityWrapper.eq("settlementRecordId", 0); + } } if (time == 5 && !StringUtils.hasLength(insertTime)){ @@ -200,12 +211,16 @@ settlementDetails = settlementDetailService.selectList(settlementDetailEntityWrapper); List<PlatformVO> res = new ArrayList<>(); SimpleDateFormat format = new SimpleDateFormat("yyyy-MM-dd HH:mm:ss"); - Map<Integer, TDriver> driverMap = driverService.selectList(new EntityWrapper<TDriver>()) - .stream() - .collect(Collectors.toMap(TDriver::getId, user -> user)); + Map<Integer, SettlementRecord> settlementRecordMap = settlementRecordService.selectList(new EntityWrapper<SettlementRecord>()) .stream() .collect(Collectors.toMap(SettlementRecord::getId, user -> user)); + Map<Integer, TOrderPrivateCar> orderPrivateCarMap = orderPrivateCarService.selectList(new EntityWrapper<TOrderPrivateCar>()) + .stream() + .collect(Collectors.toMap(TOrderPrivateCar::getId, user -> user)); + Map<Integer, TOrderLogistics> orderLogisticsRecordMap = orderLogisticsService.selectList(new EntityWrapper<TOrderLogistics>()) + .stream() + .collect(Collectors.toMap(TOrderLogistics::getId, user -> user)); // 已结算金额 BigDecimal balance = new BigDecimal("0"); // 未结算金额 @@ -221,10 +236,7 @@ } // 查询订单信息 // TOrderPrivateCar tOrderPrivateCar = orderPrivateCarService.selectById(income.getIncomeId()); - TOrderPrivateCar tOrderPrivateCar = orderPrivateCarService.selectOne(new EntityWrapper<TOrderPrivateCar>() - .eq("id", income.getIncomeId()) - .between("insertTime", start, end)); - + TOrderPrivateCar tOrderPrivateCar = orderPrivateCarMap.get(income.getIncomeId()); if (tOrderPrivateCar==null){ continue; } @@ -244,9 +256,9 @@ // 小件物流 // 查询订单信息 // TOrderLogistics tOrderLogistics = orderLogisticsService.selectById(income.getIncomeId()); - TOrderLogistics tOrderLogistics = orderLogisticsService.selectOne(new EntityWrapper<TOrderLogistics>() - .eq("id", income.getIncomeId()) - .between("insertTime", start, end)); + + TOrderLogistics tOrderLogistics = orderLogisticsRecordMap.get(income.getIncomeId()); + if (tOrderLogistics==null){ continue; } @@ -268,10 +280,8 @@ switch (settlementDetail.getOrderType()){ case 1: // 专车订单 -// TOrderPrivateCar tOrderPrivateCar = orderPrivateCarService.selectById(settlementDetail.getOrderId()); - TOrderPrivateCar tOrderPrivateCar = orderPrivateCarService.selectOne(new EntityWrapper<TOrderPrivateCar>() - .eq("id", settlementDetail.getOrderId()) - .between("insertTime", start, end)); + TOrderPrivateCar tOrderPrivateCar = orderPrivateCarMap.get(settlementDetail.getOrderId()); + if (tOrderPrivateCar==null){ continue; } @@ -310,10 +320,8 @@ case 4: // 小件物流 // 查询订单信息 -// TOrderLogistics tOrderLogistics = orderLogisticsService.selectById(settlementDetail.getOrderId()); - TOrderLogistics tOrderLogistics = orderLogisticsService.selectOne(new EntityWrapper<TOrderLogistics>() - .eq("id", settlementDetail.getOrderId()) - .between("insertTime", start, end)); + TOrderLogistics tOrderLogistics = orderLogisticsRecordMap.get(settlementDetail.getOrderId()); + if (tOrderLogistics==null){ continue; } @@ -1775,7 +1783,6 @@ break; } } - Page<Map<String,Object>> page = new PageFactory<Map<String,Object>>().defaultPage(); List<Income> incomes = new ArrayList<>(); List<SettlementDetail> settlementDetails = new ArrayList<>(); if (time == 5 && !StringUtils.hasLength(insertTime)){ @@ -1794,9 +1801,23 @@ } EntityWrapper<SettlementDetail> settlementDetailEntityWrapper = new EntityWrapper<>(); - settlementDetailEntityWrapper.between("createTime", start, end); +// settlementDetailEntityWrapper.between("createTime", start, end); if (state!=null && state == 2){ - settlementDetailEntityWrapper.eq("paymentStatus", 2); + List<SettlementRecord> paymentStatus = settlementRecordService.selectList(new EntityWrapper<SettlementRecord>().eq("paymentStatus", 1)); + if(paymentStatus.size() > 0){ + settlementDetailEntityWrapper.in("settlementRecordId", paymentStatus.stream().map(SettlementRecord::getId).collect(Collectors.toList())) + .or().isNull("settlementRecordId"); + }else{ + settlementDetailEntityWrapper.eq("settlementRecordId", 0); + } + }else if (state!=null && state == 1){ + List<SettlementRecord> paymentStatus = settlementRecordService.selectList(new EntityWrapper<SettlementRecord>().eq("paymentStatus", 2)); + if(paymentStatus.size() > 0){ + settlementDetailEntityWrapper.in("settlementRecordId", paymentStatus.stream().map(SettlementRecord::getId).collect(Collectors.toList())) + .or().isNull("settlementRecordId");; + }else{ + settlementDetailEntityWrapper.eq("settlementRecordId", 0); + } } if (time == 5 && !StringUtils.hasLength(insertTime)){ @@ -1818,6 +1839,30 @@ Map<Integer, SettlementDetail> settlementDetailMap = settlementDetailService.selectList(new EntityWrapper<SettlementDetail>()) .stream() .collect(Collectors.toMap(SettlementDetail::getId, user -> user)); + Map<Integer, TOrderPrivateCar> orderPrivateCarMap = orderPrivateCarService.selectList(new EntityWrapper<TOrderPrivateCar>()) + .stream() + .collect(Collectors.toMap(TOrderPrivateCar::getId, user -> user)); + Map<Integer, TOrderLogistics> orderLogisticsRecordMap = orderLogisticsService.selectList(new EntityWrapper<TOrderLogistics>()) + .stream() + .collect(Collectors.toMap(TOrderLogistics::getId, user -> user)); + // 专车取消订单 + Map<Integer, OrderCancel> orderCancelRecordMap1 = orderCancelService.selectList(new EntityWrapper<OrderCancel>() + .eq("orderType",1) + .eq("state",2) + .isNotNull("payType") + .isNotNull("money") + ) + .stream() + .collect(Collectors.toMap(OrderCancel::getOrderId, user -> user)); + // 小件物流取消 + Map<Integer, OrderCancel> orderCancelRecordMap2 = orderCancelService.selectList(new EntityWrapper<OrderCancel>() + .eq("state",2) + .isNotNull("payType") + .isNotNull("money") + .eq("orderType",4) + ) + .stream() + .collect(Collectors.toMap(OrderCancel::getOrderId, user -> user)); // 已结算金额 BigDecimal balance = new BigDecimal("0"); // 未结算金额 @@ -1832,10 +1877,7 @@ continue; } // 查询订单信息 -// TOrderPrivateCar tOrderPrivateCar = orderPrivateCarService.selectById(income.getIncomeId()); - TOrderPrivateCar tOrderPrivateCar = orderPrivateCarService.selectOne(new EntityWrapper<TOrderPrivateCar>() - .eq("id", income.getIncomeId()) - .between("insertTime", start, end)); + TOrderPrivateCar tOrderPrivateCar = orderPrivateCarMap.get(income.getIncomeId()); if (tOrderPrivateCar==null){ continue; @@ -1857,9 +1899,7 @@ } if (tOrderPrivateCar.getState() == 10){ // 查询取消订单 用户支付方式 - OrderCancel orderCancel = orderCancelService.selectOne(new EntityWrapper<OrderCancel>() - .eq("orderType", 1) - .eq("orderId", tOrderPrivateCar.getId())); + OrderCancel orderCancel = orderCancelRecordMap1.get(tOrderPrivateCar.getId()); if (orderCancel!=null &&orderCancel.getPayType()!=null){ switch (orderCancel.getPayType()){ case 1: @@ -1904,10 +1944,9 @@ } // 小件物流 // 查询订单信息 -// TOrderLogistics tOrderLogistics = orderLogisticsService.selectById(income.getIncomeId()); - TOrderLogistics tOrderLogistics = orderLogisticsService.selectOne(new EntityWrapper<TOrderLogistics>() - .eq("id", income.getIncomeId()) - .between("insertTime", start, end)); +// + TOrderLogistics tOrderLogistics = orderLogisticsRecordMap.get(income.getIncomeId()); + if (tOrderLogistics==null){ continue; } @@ -1928,9 +1967,9 @@ } if (tOrderLogistics.getState() == 10){ // 查询取消订单 用户支付方式 - OrderCancel orderCancel = orderCancelService.selectOne(new EntityWrapper<OrderCancel>() - .eq("orderType", 4) - .eq("orderId", tOrderLogistics.getId())); + + OrderCancel orderCancel = orderCancelRecordMap2.get(tOrderLogistics.getId()); + if (orderCancel!=null &&orderCancel.getPayType()!=null){ switch (orderCancel.getPayType()){ case 1: @@ -1975,10 +2014,8 @@ switch (settlementDetail.getOrderType()){ case 1: // 专车订单 -// TOrderPrivateCar tOrderPrivateCar = orderPrivateCarService.selectById(settlementDetail.getOrderId()); - TOrderPrivateCar tOrderPrivateCar = orderPrivateCarService.selectOne(new EntityWrapper<TOrderPrivateCar>() - .eq("id", settlementDetail.getOrderId()) - .between("insertTime", start, end)); + TOrderPrivateCar tOrderPrivateCar = orderPrivateCarMap.get(settlementDetail.getOrderId()); + if (tOrderPrivateCar==null){ continue; } @@ -2024,10 +2061,7 @@ case 4: // 小件物流 // 查询订单信息 -// TOrderLogistics tOrderLogistics = orderLogisticsService.selectById(settlementDetail.getOrderId()); - TOrderLogistics tOrderLogistics = orderLogisticsService.selectOne(new EntityWrapper<TOrderLogistics>() - .eq("id", settlementDetail.getOrderId()) - .between("insertTime", start, end)); + TOrderLogistics tOrderLogistics = orderLogisticsRecordMap.get(settlementDetail.getOrderId()); if (tOrderLogistics==null){ continue; } -- Gitblit v1.7.1