From de9d3974b9068ffc0893f62d33b50e3864603c80 Mon Sep 17 00:00:00 2001
From: 无关风月 <443237572@qq.com>
Date: 星期五, 06 九月 2024 17:38:56 +0800
Subject: [PATCH] 2.0bug修改

---
 ManagementIGOTravel/guns-admin/src/main/java/com/stylefeng/guns/modular/system/controller/PlatformController.java |  231 +++++++++++++++++++++++++++++++++++++++++++++++++--------
 1 files changed, 197 insertions(+), 34 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 c4543d3..6182e87 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,6 +12,8 @@
 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;
@@ -525,6 +527,13 @@
         EntityWrapper<TOrderLogistics> tOrderLogisticsEntityWrapper = new EntityWrapper<>();
         // 司机手动结算金额
         Wrapper<SettlementDetail> orderType1 = new EntityWrapper<SettlementDetail>();
+        // 用户取消订单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>()
@@ -551,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)
@@ -580,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:
                     // 只查询用户充值
@@ -617,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");
@@ -630,6 +650,7 @@
         BigDecimal driverWithdrawal = new BigDecimal("0");
         // 用户提现金额
         BigDecimal userWithdrawal = new BigDecimal("0");
+
         // 用户订单消费
         for (TOrderPrivateCar tOrderPrivateCar : tOrderPrivateCars) {
             if (payType!=null){
@@ -653,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){
@@ -681,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());
@@ -704,10 +725,73 @@
             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;
+                        }
+                    }
+                    waterVO.setPayType("手机支付");
+                    // 专车
+                    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 2:
+                    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 (tOrderLogistics1.getPayType()){
+                        case 1:
+                            waterVO1.setPayType("手机支付");
+                            break;
+                        case 2:
+                            waterVO1.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 == 1){
+            if(payType!=null && payType == 2){
                 break;
             }
             WaterVO waterVO = new WaterVO();
@@ -719,8 +803,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);
@@ -728,7 +812,7 @@
         }
         // 用户提现
         for (TPubWithdrawal tPubWithdrawal : user) {
-            if(payType!=null && payType == 1){
+            if(payType!=null && payType == 2){
                 break;
             }
             WaterVO waterVO = new WaterVO();
@@ -741,8 +825,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);
@@ -781,7 +865,7 @@
                     }
                 }
 
-                waterVO.setMoney(new BigDecimal(paymentRecord.getAmount().toString()));
+                waterVO.setMoney(new BigDecimal(paymentRecord.getAmount().toString())+"");
             }else{
                 continue;
             }
@@ -854,7 +938,7 @@
                     if (income.getOrderMoney() != null){
                         String string = income.getPrice().toString();
                         BigDecimal bigDecimal1 = new BigDecimal(string);
-                        platformVO.setMoney(bigDecimal1);
+                        platformVO.setMoney(bigDecimal1+"");
                     }else{
                         continue;
                     }
@@ -912,7 +996,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()));
                     }
@@ -953,6 +1037,8 @@
     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) {
@@ -1027,6 +1113,8 @@
         // 用户小件物流订单记录
         List<TOrderPrivateCar> tOrderPrivateCars = new ArrayList<>();
         List<TOrderLogistics> tOrderLogistics = new ArrayList<>();
+        // 用户取消订单记录
+        List<OrderCancel> orderCancels = new ArrayList<>();
         // 用户充值
         List<TPubTransactionDetails> tPubTransactionDetails = new ArrayList<>();
         // 司机结算总额
@@ -1045,8 +1133,13 @@
         EntityWrapper<TOrderPrivateCar> tOrderPrivateCarEntityWrapper = new EntityWrapper<>();
         // 用户小件物流订单wrapper
         EntityWrapper<TOrderLogistics> tOrderLogisticsEntityWrapper = new EntityWrapper<>();
+        // 用户取消订单wrapper
+        Wrapper<OrderCancel> orderCancelEntityWrapper = new EntityWrapper<>();
         // 司机手动结算金额
         Wrapper<SettlementDetail> orderType1 = new EntityWrapper<SettlementDetail>();
+        List<Integer> integers = new ArrayList<>();
+        integers.add(1);
+        integers.add(2);
         if (time == 5 && !StringUtils.hasLength(insertTime)){
             // 余额充值wrapper
             orderType = new EntityWrapper<TPubTransactionDetails>()
@@ -1074,6 +1167,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)
@@ -1104,6 +1201,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);
         }
 
 
@@ -1113,7 +1215,7 @@
                     // 只查询用户订单
                     tOrderPrivateCars = orderPrivateCarService.selectList(tOrderPrivateCarEntityWrapper);
                     tOrderLogistics = orderLogisticsService.selectList(tOrderLogisticsEntityWrapper);
-
+                    orderCancels = orderCancelService.selectList(orderCancelEntityWrapper);
                     break;
                 case 2:
                     // 只查询用户充值
@@ -1141,6 +1243,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");
@@ -1174,13 +1277,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());
@@ -1205,8 +1304,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());
@@ -1228,9 +1327,73 @@
             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;
+                        }
+                    }
+                    waterVO.setPayType("手机支付");
+                    // 专车
+                    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 (tOrderLogistics1.getPayType()){
+                        case 1:
+                            waterVO1.setPayType("手机支付");
+                            break;
+                        case 2:
+                            waterVO1.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 == 1){
+            if(payType!=null && payType == 2){
                 break;
             }
             WaterVO waterVO = new WaterVO();
@@ -1242,8 +1405,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);
@@ -1251,7 +1414,7 @@
         }
         // 用户提现
         for (TPubWithdrawal tPubWithdrawal : user) {
-            if(payType!=null && payType == 1){
+            if(payType!=null && payType == 2){
                 break;
             }
             WaterVO waterVO = new WaterVO();
@@ -1262,8 +1425,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);
@@ -1306,7 +1469,7 @@
                     }
                 }
 
-                waterVO.setMoney(new BigDecimal(paymentRecord.getAmount().toString()));
+                waterVO.setMoney(new BigDecimal(paymentRecord.getAmount().toString())+"");
             }else{
                 continue;
             }
@@ -1377,7 +1540,7 @@
                     if (income.getPrice() != null){
                         String string = income.getPrice().toString();
                         BigDecimal bigDecimal1 = new BigDecimal(string);
-                        platformVO.setMoney(bigDecimal1);
+                        platformVO.setMoney(bigDecimal1+"");
                     }else{
                         continue;
                     }
@@ -1459,7 +1622,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()));
                     }

--
Gitblit v1.7.1