From f6b20962bb0453683e9366a3f87b7ec9bfaed03c Mon Sep 17 00:00:00 2001
From: xuhy <3313886187@qq.com>
Date: 星期二, 14 一月 2025 15:18:58 +0800
Subject: [PATCH] Merge remote-tracking branch 'origin/master'

---
 ruoyi-service/ruoyi-account/src/main/java/com/ruoyi/account/controller/AppUserController.java |  220 ++++++++++++++++++++++++++----------------------------
 1 files changed, 107 insertions(+), 113 deletions(-)

diff --git a/ruoyi-service/ruoyi-account/src/main/java/com/ruoyi/account/controller/AppUserController.java b/ruoyi-service/ruoyi-account/src/main/java/com/ruoyi/account/controller/AppUserController.java
index 25f0f98..806b875 100644
--- a/ruoyi-service/ruoyi-account/src/main/java/com/ruoyi/account/controller/AppUserController.java
+++ b/ruoyi-service/ruoyi-account/src/main/java/com/ruoyi/account/controller/AppUserController.java
@@ -137,6 +137,8 @@
     @PostMapping("/editAppUserById")
     public R<Void> editAppUserById(@RequestBody AppUser appUser) {
         appUserService.updateById(appUser);
+        appUserService.update(new LambdaUpdateWrapper<AppUser>().eq(AppUser::getId, appUser.getId())
+                .set(AppUser::getLastShopTime, appUser.getLastShopTime()));
         return R.ok();
 
     }
@@ -319,13 +321,13 @@
                 user.setShopName(shop.getName());
             }
         }
-        Long count1 = appUserService.lambdaQuery().eq(AppUser::getVipId, 1).eq(AppUser::getInviteUserId, userId).or().eq(AppUser::getTopInviteId,userId).count();
-        Long count2 = appUserService.lambdaQuery().eq(AppUser::getVipId, 2).eq(AppUser::getInviteUserId, userId).or().eq(AppUser::getTopInviteId,userId).count();
-        Long count3 = appUserService.lambdaQuery().eq(AppUser::getVipId, 3).eq(AppUser::getInviteUserId, userId).or().eq(AppUser::getTopInviteId,userId).count();
-        Long count4 = appUserService.lambdaQuery().eq(AppUser::getVipId, 4).eq(AppUser::getInviteUserId, userId).or().eq(AppUser::getTopInviteId,userId).count();
-        Long count5 = appUserService.lambdaQuery().eq(AppUser::getVipId, 5).eq(AppUser::getInviteUserId, userId).or().eq(AppUser::getTopInviteId,userId).count();
-        Long count6 = appUserService.lambdaQuery().eq(AppUser::getVipId, 6).eq(AppUser::getInviteUserId, userId).or().eq(AppUser::getTopInviteId,userId).count();
-        Long count7 = appUserService.lambdaQuery().eq(AppUser::getVipId, 7).eq(AppUser::getInviteUserId, userId).or().eq(AppUser::getTopInviteId,userId).count();
+        Long count1 = appUserService.lambdaQuery().ne(AppUser::getStatus,3).eq(AppUser::getVipId, 1).eq(AppUser::getInviteUserId, userId).or().eq(AppUser::getTopInviteId,userId).count();
+        Long count2 = appUserService.lambdaQuery().ne(AppUser::getStatus,3).eq(AppUser::getVipId, 2).eq(AppUser::getInviteUserId, userId).or().eq(AppUser::getTopInviteId,userId).count();
+        Long count3 = appUserService.lambdaQuery().ne(AppUser::getStatus,3).eq(AppUser::getVipId, 3).eq(AppUser::getInviteUserId, userId).or().eq(AppUser::getTopInviteId,userId).count();
+        Long count4 = appUserService.lambdaQuery().ne(AppUser::getStatus,3).eq(AppUser::getVipId, 4).eq(AppUser::getInviteUserId, userId).or().eq(AppUser::getTopInviteId,userId).count();
+        Long count5 = appUserService.lambdaQuery().ne(AppUser::getStatus,3).eq(AppUser::getVipId, 5).eq(AppUser::getInviteUserId, userId).or().eq(AppUser::getTopInviteId,userId).count();
+        Long count6 = appUserService.lambdaQuery().ne(AppUser::getStatus,3).eq(AppUser::getVipId, 6).eq(AppUser::getInviteUserId, userId).or().eq(AppUser::getTopInviteId,userId).count();
+        Long count7 = appUserService.lambdaQuery().ne(AppUser::getStatus,3).eq(AppUser::getVipId, 7).eq(AppUser::getInviteUserId, userId).or().eq(AppUser::getTopInviteId,userId).count();
         user.setCount1(count1);
         user.setCount2(count2);
         user.setCount3(count3);
@@ -744,108 +746,6 @@
     @GetMapping("/commissionDetail")
     @ApiOperation(value = "分佣统计", tags = "管理后台-首页统计")
     public R<CommissionDetail> commissionDetail(CommissionDetail cd) {
-        Long userid = tokenService.getLoginUser().getUserid();
-        SysUser sysUser = sysUserClient.getSysUser(userid).getData();
-        LambdaQueryWrapper<AppUser> queryWrapper = new LambdaQueryWrapper<AppUser>().eq(AppUser::getDelFlag, 0);
-        if(sysUser.getRoleType() == 2){
-            queryWrapper.eq(AppUser::getShopId, sysUser.getObjectId());
-        }
-        LocalDateTime startTime = cd.getStartTime();
-        LocalDateTime endTime = cd.getEndTime();
-        queryWrapper.ge(null != startTime, AppUser::getCreateTime, startTime);
-        queryWrapper.le(null != endTime, AppUser::getCreateTime, endTime);
-        queryWrapper.orderByAsc(AppUser::getCreateTime);
-        List<AppUser> appUserList = appUserService.list(queryWrapper);
-        if (appUserList.isEmpty()) {
-            return R.ok(new CommissionDetail());
-        }
-        BigDecimal totalCommission = BigDecimal.ZERO;
-        BigDecimal totalServiceFee = BigDecimal.ZERO;
-        BigDecimal totalUserCommission = BigDecimal.ZERO;
-        Map<Integer, BigDecimal> vipCommissions = new HashMap<>();
-        Map<String, Map<Integer, BigDecimal>> dailyVipCommissions = new TreeMap<>();
-        for (AppUser appUser : appUserList) {
-            BigDecimal distributionAmount = Optional.ofNullable(appUser.getTotalDistributionAmount()).orElse(BigDecimal.ZERO);
-            totalCommission = totalCommission.add(distributionAmount);
-            Integer vipId = appUser.getVipId();
-            if (vipId != null && vipId >= 1 && vipId <= 7) {
-                vipCommissions.merge(vipId, distributionAmount, BigDecimal::add);
-
-                String dateKey = appUser.getCreateTime().format(DateTimeFormatter.ofPattern("yyyy-MM-dd"));
-                dailyVipCommissions.computeIfAbsent(dateKey, k -> new HashMap<>())
-                        .merge(vipId, distributionAmount, BigDecimal::add);
-            }
-        }
-        List<Shop> data = shopClient.getAllShop().getData();
-        if(sysUser.getRoleType() == 2){
-            data = Arrays.asList(shopClient.getShopById(sysUser.getObjectId()).getData());
-        }
-        for (Shop shop : data) {
-            totalServiceFee = totalServiceFee.add(shop.getServerGiveawayMoney());
-            totalUserCommission = totalUserCommission.add(shop.getGiveawayMoney());
-        }
-
-        R<List<ShopBalanceStatement>> r = shopBalanceStatementClient.getShopBalanceStatementList(Arrays.asList(1, 2, 3), null);
-        List<ShopBalanceStatement> data1 = r.getData();
-        if (!CollectionUtils.isEmpty(data1)){
-            for (ShopBalanceStatement shopBalanceStatement : data1) {
-                String dateKey = shopBalanceStatement.getCreateTime().format(DateTimeFormatter.ofPattern("yyyy-MM-dd"));
-                Integer type = shopBalanceStatement.getType();
-                if (type == 1){
-                    type = 8;
-                }else if (type == 2){
-                    type = 9;
-                }else {
-                    type = 10;
-                }
-                dailyVipCommissions.computeIfAbsent(dateKey, k -> new HashMap<>())
-                        .merge(type, shopBalanceStatement.getVariableAmount(), BigDecimal::add);
-            }
-        }
-
-
-        CommissionDetail commissionDetail = new CommissionDetail();
-        commissionDetail.setTotalCommission(totalCommission);
-        commissionDetail.setTotalServiceFee(totalServiceFee);
-        commissionDetail.setTotalUserCommission(totalUserCommission);
-
-        commissionDetail.setTotalNormalCommission(vipCommissions.getOrDefault(1, BigDecimal.ZERO));
-        commissionDetail.setTotalGoldCommission(vipCommissions.getOrDefault(2, BigDecimal.ZERO));
-        commissionDetail.setTotalDiamondCommission(vipCommissions.getOrDefault(3, BigDecimal.ZERO));
-        commissionDetail.setTotalAgentCommission(vipCommissions.getOrDefault(4, BigDecimal.ZERO));
-        commissionDetail.setTotalSuperAgentCommission(vipCommissions.getOrDefault(5, BigDecimal.ZERO));
-        commissionDetail.setTotalTopAgentCommission(vipCommissions.getOrDefault(6, BigDecimal.ZERO));
-        commissionDetail.setTotalPartnerCommission(vipCommissions.getOrDefault(7, BigDecimal.ZERO));
-
-        List<CommissionDate> commissionDateList = dailyVipCommissions.entrySet().stream()
-                .map(entry -> {
-                    CommissionDate commissionDate = new CommissionDate();
-                    commissionDate.setDate(entry.getKey());
-                    Map<Integer, BigDecimal> dailyCommissions = entry.getValue();
-                    commissionDate.setNormalCommission(dailyCommissions.getOrDefault(1, BigDecimal.ZERO));
-                    commissionDate.setGoldCommission(dailyCommissions.getOrDefault(2, BigDecimal.ZERO));
-                    commissionDate.setDiamondCommission(dailyCommissions.getOrDefault(3, BigDecimal.ZERO));
-                    commissionDate.setAgentCommission(dailyCommissions.getOrDefault(4, BigDecimal.ZERO));
-                    commissionDate.setSuperAgentCommission(dailyCommissions.getOrDefault(5, BigDecimal.ZERO));
-                    commissionDate.setTopAgentCommission(dailyCommissions.getOrDefault(6, BigDecimal.ZERO));
-                    commissionDate.setPartnerCommission(dailyCommissions.getOrDefault(7, BigDecimal.ZERO));
-                    BigDecimal add = commissionDate.getNormalCommission().add(commissionDate.getGoldCommission()).add(commissionDate.getDiamondCommission()).add(commissionDate.getAgentCommission())
-                            .add(commissionDate.getSuperAgentCommission()).add(commissionDate.getTopAgentCommission()).add(commissionDate.getPartnerCommission());
-                    commissionDate.setTotalCommission(add);
-
-                    commissionDate.setServiceChargeCommission(dailyCommissions.getOrDefault(10, BigDecimal.ZERO));
-                    commissionDate.setAssociatedUserCommission(dailyCommissions.getOrDefault(8, BigDecimal.ZERO));
-                    commissionDate.setBindLowerLevelStoresCommission(dailyCommissions.getOrDefault(9, BigDecimal.ZERO));
-                    return commissionDate;
-                })
-                .collect(Collectors.toList());
-
-        commissionDetail.setCommissionDateList(commissionDateList);
-        return R.ok(commissionDetail);
-    }
-
-
-    public R<CommissionDetail> commissionDetail2(CommissionDetail cd) {
         if (cd.getStartTime() == null || cd.getEndTime() == null) {
             return R.fail("请选择时间");
         }
@@ -858,7 +758,7 @@
         getDatesBetween(cd.getStartTime(), cd.getEndTime()).forEach(date -> {
             for (int i = 1; i < 8; i++){
                 List<BalanceChangeRecord> list = balanceChangeRecordService.list(new LambdaQueryWrapper<BalanceChangeRecord>()
-                        .eq(BalanceChangeRecord::getCreateTime, date)
+                        .between(BalanceChangeRecord::getCreateTime, date, date.plusDays(1))
                         .eq(BalanceChangeRecord::getChangeType,4)
                         .eq(BalanceChangeRecord::getVipId, i));
                 BigDecimal reduce = list.stream().map(BalanceChangeRecord::getChangeAmount).reduce(BigDecimal.ZERO, BigDecimal::add);
@@ -886,7 +786,99 @@
                 }
             }
         });
-        return null;
+
+
+        BigDecimal totalCommission = BigDecimal.ZERO;
+        BigDecimal totalNormalCommission = BigDecimal.ZERO;
+
+        BigDecimal totalGoldCommission = BigDecimal.ZERO;
+
+        BigDecimal totalDiamondCommission = BigDecimal.ZERO;
+
+        BigDecimal totalAgentCommission = BigDecimal.ZERO;
+
+        BigDecimal totalSuperAgentCommission = BigDecimal.ZERO;
+
+        BigDecimal totalTopAgentCommission = BigDecimal.ZERO;
+
+        BigDecimal totalPartnerCommission = BigDecimal.ZERO;
+
+        List<AppUser> allAppUserList = appUserService.list();
+        for (AppUser appUser : allAppUserList) {
+            BigDecimal totalDistributionAmount = appUser.getTotalDistributionAmount();
+            totalCommission = totalCommission.add(totalDistributionAmount);
+            if (appUser.getVipId() == 1){
+                totalNormalCommission = totalNormalCommission.add(totalDistributionAmount);
+            }
+            if (appUser.getVipId() == 2){
+                totalGoldCommission = totalGoldCommission.add(totalDistributionAmount);
+            }
+            if (appUser.getVipId() == 3){
+                totalDiamondCommission = totalDiamondCommission.add(totalDistributionAmount);
+            }
+            if (appUser.getVipId() == 4){
+                totalAgentCommission = totalAgentCommission.add(totalDistributionAmount);
+            }
+            if (appUser.getVipId() == 5){
+                totalSuperAgentCommission = totalSuperAgentCommission.add(totalDistributionAmount);
+            }
+            if (appUser.getVipId() == 6){
+                totalTopAgentCommission = totalTopAgentCommission.add(totalDistributionAmount);
+            }
+            if (appUser.getVipId() == 7){
+                totalPartnerCommission = totalPartnerCommission.add(totalDistributionAmount);
+            }
+        }
+
+        R<Map<String, BigDecimal>> shopStatistics = shopClient.getShopStatistics();
+        Map<String, BigDecimal> data = shopStatistics.getData();
+        BigDecimal totalServiceFee = BigDecimal.ZERO;
+        BigDecimal totalUserCommission = BigDecimal.ZERO;
+        if (data != null){
+            totalServiceFee = data.get("serverGiveawayMoney");
+            totalUserCommission = data.get("lowerLevelGiveawayMoney");
+        }
+
+        CommissionDetail commissionDetail = new CommissionDetail();
+        commissionDetail.setTotalCommission(totalCommission);
+        commissionDetail.setTotalServiceFee(totalServiceFee);
+        commissionDetail.setTotalUserCommission(totalUserCommission);
+
+        commissionDetail.setTotalNormalCommission(totalNormalCommission);
+        commissionDetail.setTotalGoldCommission(totalGoldCommission);
+        commissionDetail.setTotalDiamondCommission(totalDiamondCommission);
+        commissionDetail.setTotalAgentCommission(totalAgentCommission);
+        commissionDetail.setTotalSuperAgentCommission(totalSuperAgentCommission);
+        commissionDetail.setTotalTopAgentCommission(totalTopAgentCommission);
+        commissionDetail.setTotalPartnerCommission(totalPartnerCommission);
+
+
+        List<CommissionDate> commissionDateList = dailyVipCommissions.entrySet().stream()
+                .map(entry -> {
+                    CommissionDate commissionDate = new CommissionDate();
+                    commissionDate.setDate(entry.getKey());
+                    Map<Integer, BigDecimal> dailyCommissions = entry.getValue();
+                    commissionDate.setNormalCommission(dailyCommissions.getOrDefault(1, BigDecimal.ZERO));
+                    commissionDate.setGoldCommission(dailyCommissions.getOrDefault(2, BigDecimal.ZERO));
+                    commissionDate.setDiamondCommission(dailyCommissions.getOrDefault(3, BigDecimal.ZERO));
+                    commissionDate.setAgentCommission(dailyCommissions.getOrDefault(4, BigDecimal.ZERO));
+                    commissionDate.setSuperAgentCommission(dailyCommissions.getOrDefault(5, BigDecimal.ZERO));
+                    commissionDate.setTopAgentCommission(dailyCommissions.getOrDefault(6, BigDecimal.ZERO));
+                    commissionDate.setPartnerCommission(dailyCommissions.getOrDefault(7, BigDecimal.ZERO));
+                    BigDecimal add = commissionDate.getNormalCommission().add(commissionDate.getGoldCommission()).add(commissionDate.getDiamondCommission()).add(commissionDate.getAgentCommission())
+                            .add(commissionDate.getSuperAgentCommission()).add(commissionDate.getTopAgentCommission()).add(commissionDate.getPartnerCommission());
+                    commissionDate.setTotalCommission(add);
+
+                    commissionDate.setServiceChargeCommission(dailyCommissions.getOrDefault(10, BigDecimal.ZERO));
+                    commissionDate.setAssociatedUserCommission(dailyCommissions.getOrDefault(8, BigDecimal.ZERO));
+                    commissionDate.setBindLowerLevelStoresCommission(dailyCommissions.getOrDefault(9, BigDecimal.ZERO));
+                    return commissionDate;
+                })
+                .collect(Collectors.toList());
+
+        commissionDetail.setCommissionDateList(commissionDateList);
+
+        return R.ok(commissionDetail);
     }
 
 
@@ -906,7 +898,8 @@
                 .limit(daysBetween + 1)
                 .collect(Collectors.toList());
     }
-    
+
+
     
     /**
      * 上传图片
@@ -951,7 +944,8 @@
      */
     @PostMapping("/clearBindShop")
     public R clearBindShop(@RequestParam("shopId") Integer shopId){
-        appUserService.update(new LambdaUpdateWrapper<AppUser>().eq(AppUser::getShopId, shopId).set(AppUser::getShopId, null));
+        appUserService.update(new LambdaUpdateWrapper<AppUser>().eq(AppUser::getShopId, shopId).set(AppUser::getShopId, null)
+                .set(AppUser::getUserType,1));
         return R.ok();
     }
 }

--
Gitblit v1.7.1