From e4eaabefaaa2ca95f809c47a11712c3bee56e1b5 Mon Sep 17 00:00:00 2001
From: luofl <1442745593@qq.com>
Date: 星期四, 20 二月 2025 15:07:09 +0800
Subject: [PATCH] 修改物流信息导入模板

---
 ruoyi-service/ruoyi-account/src/main/java/com/ruoyi/account/service/impl/BalanceChangeRecordServiceImpl.java |   81 ++++++++++++++++++++++++++++++++++------
 1 files changed, 68 insertions(+), 13 deletions(-)

diff --git a/ruoyi-service/ruoyi-account/src/main/java/com/ruoyi/account/service/impl/BalanceChangeRecordServiceImpl.java b/ruoyi-service/ruoyi-account/src/main/java/com/ruoyi/account/service/impl/BalanceChangeRecordServiceImpl.java
index 147d78f..733c3ef 100644
--- a/ruoyi-service/ruoyi-account/src/main/java/com/ruoyi/account/service/impl/BalanceChangeRecordServiceImpl.java
+++ b/ruoyi-service/ruoyi-account/src/main/java/com/ruoyi/account/service/impl/BalanceChangeRecordServiceImpl.java
@@ -42,6 +42,7 @@
 
     @Override
     public CommissionStatistics commissionStatistics(Page<BalanceChangeRecord> page, BalanceChangeRecord balanceChangeRecord) {
+        balanceChangeRecord.setChangeType(4);
         List<BalanceChangeRecord> balanceChangeRecordList = this.baseMapper.selectBalanceChangeRecordList(balanceChangeRecord);
 
         BigDecimal totalCommission = balanceChangeRecordList.stream()
@@ -53,6 +54,19 @@
         IPage<BalanceChangeRecord> balanceChangeRecordIPage = this.baseMapper.queryCommissionStatistics(page, balanceChangeRecord);
         // 过滤商城购物
         List<BalanceChangeRecord> collect = balanceChangeRecordIPage.getRecords().stream().filter(e -> e.getChangeType() != 5).collect(Collectors.toList());
+        for (BalanceChangeRecord changeRecord : collect) {
+            if (changeRecord.getBeforeAmount()!=null && changeRecord.getAfterAmount()!=null){
+                BigDecimal subtract = changeRecord.getBeforeAmount().subtract(changeRecord.getAfterAmount());
+                if (subtract.compareTo(BigDecimal.ZERO)>0){
+                    // 减少
+                    changeRecord.setChangeAmountString("-¥"+changeRecord.getChangeAmount());
+                }else if (subtract.compareTo(BigDecimal.ZERO)<0){
+                    changeRecord.setChangeAmountString("+¥"+changeRecord.getChangeAmount());
+                }else{
+                    changeRecord.setChangeAmountString("¥"+changeRecord.getChangeAmount());
+                }
+            }
+        }
         balanceChangeRecordIPage.setRecords(collect);
         return new CommissionStatistics(totalCommission, balanceChangeRecordIPage);
     }
@@ -62,14 +76,46 @@
         ShopBalanceStatement shopBalanceStatement = new ShopBalanceStatement();
         shopBalanceStatement.setType(1);
 
-        IPage<BalanceChangeRecord> balanceChangeRecordIPage = this.baseMapper.queryCommissionStatistics(page, balanceChangeRecord);
-        IPage<WalletStatisticsDetail> walletStatisticsDetailIPage = balanceChangeRecordIPage.convert(changeRecord -> {
+        List<BalanceChangeRecord> balanceChangeRecordList = this.baseMapper.selectBalanceChangeRecordList1(balanceChangeRecord);
+        List<WalletStatisticsDetail> walletStatisticsDetailList = new ArrayList<>();
+        BigDecimal totalWithdraw = BigDecimal.ZERO;
+        for (BalanceChangeRecord changeRecord : balanceChangeRecordList) {
+
             WalletStatisticsDetail walletStatisticsDetail = new WalletStatisticsDetail();
             BeanUtils.copyBeanProp(walletStatisticsDetail, changeRecord);
-            return walletStatisticsDetail;
-        });
 
-        Map<Integer, BigDecimal> shopCommissionMap = walletStatisticsDetailIPage.getRecords().stream()
+            BigDecimal beforeAmount = changeRecord.getBeforeAmount();
+            BigDecimal afterAmount = changeRecord.getAfterAmount();
+
+            if (beforeAmount.compareTo(afterAmount) < 0 && changeRecord.getChangeType().equals(2)){
+                BigDecimal changeAmount = changeRecord.getChangeAmount();
+                totalWithdraw = totalWithdraw.add(changeAmount);
+                walletStatisticsDetail.setFlag(2);
+            }else {
+                walletStatisticsDetail.setFlag(1);
+            }
+            walletStatisticsDetailList.add(walletStatisticsDetail);
+        }
+        // 按时间排序(倒序)
+        walletStatisticsDetailList.sort(Comparator.comparing(WalletStatisticsDetail::getCreateTime).reversed());
+        long current = page.getCurrent();
+        long size = page.getSize();
+        if (current < 1) {
+            current = 1;
+        }
+        int fromIndex = (int) ((current - 1) * size);
+        int toIndex = (int) Math.min(fromIndex + size, walletStatisticsDetailList.size());
+
+
+        Page<WalletStatisticsDetail> walletStatisticsDetailPage = new Page<>();
+        WalletStatistics walletStatistics = new WalletStatistics();
+        if (fromIndex >= walletStatisticsDetailList.size()) {
+            walletStatistics.setPage(walletStatisticsDetailPage);
+            return walletStatistics;
+        }
+
+
+        Map<Integer, BigDecimal> shopCommissionMap = walletStatisticsDetailList.stream()
                 .collect(Collectors.groupingBy(
                         WalletStatisticsDetail::getChangeType,
                         Collectors.reducing(
@@ -80,16 +126,25 @@
                 ));
 
         BigDecimal totalRecharge = shopCommissionMap.get(1);
-        BigDecimal totalWithdraw = shopCommissionMap.get(2);
         BigDecimal totalShopWithdraw = shopCommissionMap.get(7);
 
-
-        WalletStatistics walletStatistics = new WalletStatistics();
-        walletStatistics.setPage(walletStatisticsDetailIPage);
-        walletStatistics.setTotalRecharge(totalRecharge);
-        walletStatistics.setTotalWithdraw(totalWithdraw);
-        walletStatistics.setTotalShopWithdraw(totalShopWithdraw);
+        List<WalletStatisticsDetail> walletStatisticsDetailList2 = walletStatisticsDetailList.subList(fromIndex, toIndex);
+        for (WalletStatisticsDetail changeRecord : walletStatisticsDetailList2) {
+            Integer flag = changeRecord.getFlag();
+            if (flag.equals(1)){
+                changeRecord.setChangeAmountString("+¥"+changeRecord.getChangeAmount());
+            }else {
+                changeRecord.setChangeAmountString("-¥"+changeRecord.getChangeAmount());
+            }
+            walletStatisticsDetailPage.setCurrent(current);
+            walletStatisticsDetailPage.setSize(size);
+            walletStatisticsDetailPage.setTotal(walletStatisticsDetailList.size());
+            walletStatisticsDetailPage.setRecords(walletStatisticsDetailList2);
+            walletStatistics.setPage(walletStatisticsDetailPage);
+            walletStatistics.setTotalRecharge(totalRecharge);
+            walletStatistics.setTotalWithdraw(totalWithdraw);
+            walletStatistics.setTotalShopWithdraw(totalShopWithdraw);
+        }
         return walletStatistics;
     }
-
 }

--
Gitblit v1.7.1