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