From 8fd10b1d55e57e7ecaa36082d3ef85aed016e2e5 Mon Sep 17 00:00:00 2001 From: luodangjia <luodangjia> Date: 星期四, 06 二月 2025 16:08:04 +0800 Subject: [PATCH] 修改物流信息导入模板 --- ruoyi-service/ruoyi-account/src/main/java/com/ruoyi/account/controller/AppUserController.java | 276 +++++++++++++++++++++++++++++++++++++++---------------- 1 files changed, 196 insertions(+), 80 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 dba0a45..3810f15 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 @@ -11,11 +11,16 @@ import com.ruoyi.account.mapper.AppUserMapper; import com.ruoyi.account.service.*; import com.ruoyi.account.util.ObsUploadUtil; +import com.ruoyi.account.util.weChat.EnvVersion; +import com.ruoyi.account.util.weChat.WeChatUtil; import com.ruoyi.account.vo.*; +import com.ruoyi.common.core.constant.CacheConstants; import com.ruoyi.common.core.domain.R; +import com.ruoyi.common.core.utils.StringUtils; import com.ruoyi.common.core.utils.bean.BeanUtils; import com.ruoyi.common.core.web.controller.BaseController; import com.ruoyi.common.core.web.page.PageInfo; +import com.ruoyi.common.redis.service.RedisService; import com.ruoyi.common.security.service.TokenService; import com.ruoyi.order.feignClient.OrderClient; import com.ruoyi.order.feignClient.RemoteOrderGoodsClient; @@ -29,7 +34,9 @@ import com.ruoyi.other.api.feignClient.VipSettingClient; import com.ruoyi.system.api.domain.SysUser; import com.ruoyi.system.api.feignClient.SysUserClient; +import com.ruoyi.system.api.model.LoginUser; import io.swagger.annotations.*; +import org.springframework.beans.factory.annotation.Value; import org.springframework.util.CollectionUtils; import org.springframework.web.bind.annotation.*; import org.springframework.web.multipart.MultipartFile; @@ -57,8 +64,7 @@ @RestController @RequestMapping("/app-user") public class AppUserController extends BaseController { - - + @Resource private TokenService tokenService; @Resource @@ -92,6 +98,16 @@ private UserCancellationLogService userCancellationLogService; @Resource private BalanceChangeRecordService balanceChangeRecordService; + @Resource + private UserChangeLogService userChangeLogService; + @Resource + private RedisService redisService; + + @Resource + private WeChatUtil weChatUtil; + + @Value("${file.upload.location}") + private String filePath; @ResponseBody @@ -114,6 +130,17 @@ public AppUser getAppUserById(@RequestParam("id") Long id) { return appUserService.getById(id); } + + @PostMapping("/getBaseUserById") + public R<Map<String, Object>> getBaseUserById(@RequestParam("id") Long id) { + AppUser appUser = appUserService.getById(id); + Map<String, Object> map = new HashMap<>(); + map.put("id", appUser.getId()); + map.put("name", appUser.getName()); + map.put("phone", appUser.getPhone()); + return R.ok(map); + } + @ResponseBody @PostMapping("/editAppUserById") @@ -200,6 +227,13 @@ public R<AppUser> info() { Long userId = tokenService.getLoginUserApplet().getUserid(); AppUser user = appUserService.getById(userId); + if(StringUtils.isEmpty(user.getQrCode())){ + //获取微信推广二维码 + String fileName = UUID.randomUUID() + ".jpg"; + String getwxacodeunlimit = weChatUtil.getwxacodeunlimit("pages/login/login", "id=" + user.getId(), EnvVersion.RELEASE, filePath + fileName); + user.setQrCode(getwxacodeunlimit); + appUserService.updateById(user); + } return R.ok(user); } @@ -258,49 +292,87 @@ .eq(AppUser::getDelFlag, 0) .ne(AppUser::getStatus, 3) .list(); + + Long vip1Count1 =0L; + Long vip1Count2 =0L; + Long vip1Count3 =0L; + Long vip1Count4 =0L; + Long vip1Count5 =0L; + Long vip1Count6 =0L; + Long vip1Count7 =0L; for (AppUser appUser : list) { + if (appUser.getVipId() == 1){ + vip1Count1++; + } + if (appUser.getVipId() == 2){ + vip1Count2++; + } + if (appUser.getVipId() == 3){ + vip1Count3++; + } + if (appUser.getVipId() == 4){ + vip1Count4++; + } + if (appUser.getVipId() == 5){ + vip1Count5++; + } + if (appUser.getVipId() == 6){ + vip1Count6++; + } + if (appUser.getVipId() == 7){ + vip1Count7++; + } + Long count1 = appUserService.lambdaQuery() .eq(AppUser::getVipId, 1) .eq(AppUser::getInviteUserId, appUser.getId()) .eq(AppUser::getDelFlag, 0) .ne(AppUser::getStatus, 3) .count(); + vip1Count1 += count1; + Long count2 = appUserService.lambdaQuery() .eq(AppUser::getVipId, 2) .eq(AppUser::getInviteUserId, appUser.getId()) .eq(AppUser::getDelFlag, 0) .ne(AppUser::getStatus, 3) .count(); + vip1Count2 += count2; Long count3 = appUserService.lambdaQuery() .eq(AppUser::getVipId, 3) .eq(AppUser::getInviteUserId, appUser.getId()) .eq(AppUser::getDelFlag, 0) .ne(AppUser::getStatus, 3) .count(); + vip1Count3 += count3; Long count4 = appUserService.lambdaQuery() .eq(AppUser::getVipId, 4) .eq(AppUser::getInviteUserId, appUser.getId()) .eq(AppUser::getDelFlag, 0) .ne(AppUser::getStatus, 3) .count(); + vip1Count4 += count4; Long count5 = appUserService.lambdaQuery() .eq(AppUser::getVipId, 5) .eq(AppUser::getInviteUserId, appUser.getId()) .eq(AppUser::getDelFlag, 0) .ne(AppUser::getStatus, 3) .count(); + vip1Count5 += count5; Long count6 = appUserService.lambdaQuery() .eq(AppUser::getVipId, 6) .eq(AppUser::getInviteUserId, appUser.getId()) .eq(AppUser::getDelFlag, 0) .ne(AppUser::getStatus, 3) .count(); + vip1Count6 += count6; Long count7 = appUserService.lambdaQuery() .eq(AppUser::getVipId, 7) .eq(AppUser::getInviteUserId, appUser.getId()) .eq(AppUser::getDelFlag, 0) .ne(AppUser::getStatus, 3) .count(); + vip1Count7 += count7; appUser.setCount1(count1); appUser.setCount2(count2); appUser.setCount3(count3); @@ -310,7 +382,13 @@ appUser.setCount7(count7); } user.setBottomUsers(list); - + user.setCount1(vip1Count1); + user.setCount2(vip1Count2); + user.setCount3(vip1Count3); + user.setCount4(vip1Count4); + user.setCount5(vip1Count5); + user.setCount6(vip1Count6); + user.setCount7(vip1Count7); return R.ok(user); } @@ -530,9 +608,9 @@ VipSetting data = vipSetting.getData(); DangerInfoDto dangerInfoDto = new DangerInfoDto(); BeanUtils.copyProperties(data, dangerInfoDto); - List<UserPoint> list1 = userPointService.lambdaQuery().eq(UserPoint::getType, 1).ge(UserPoint::getCreateTime, now.minusDays(data.getKeepBuyDay())).list(); - List<UserPoint> list2 = userPointService.lambdaQuery().eq(UserPoint::getType, 9).ge(UserPoint::getCreateTime, now.minusDays(data.getKeepBuyDay())).list(); - List<UserPoint> list3 = userPointService.lambdaQuery().eq(UserPoint::getType, 8).ge(UserPoint::getCreateTime, now.minusDays(data.getKeepBuyDay())).list(); + List<UserPoint> list1 = userPointService.lambdaQuery().eq(UserPoint::getAppUserId,id).eq(UserPoint::getType, 1).ge(UserPoint::getCreateTime, now.minusDays(data.getKeepBuyDay())).list(); + List<UserPoint> list2 = userPointService.lambdaQuery().eq(UserPoint::getAppUserId,id).eq(UserPoint::getType, 2).ge(UserPoint::getCreateTime, now.minusDays(data.getKeepBuyDay())).list(); + List<UserPoint> list3 = userPointService.lambdaQuery().eq(UserPoint::getAppUserId,id).eq(UserPoint::getType, 8).ge(UserPoint::getCreateTime, now.minusDays(data.getKeepBuyDay())).list(); Integer userKeepBuyPoint = 0; for (UserPoint userPoint : list1) { userKeepBuyPoint = userPoint.getVariablePoint() + userKeepBuyPoint; @@ -555,9 +633,38 @@ @GetMapping("/danger/down") @ApiOperation(value = "用户列表-保级条件降级", tags = {"管理后台"}) public R down(Long id) { - AppUser byId = appUserService.getById(id); - byId.setVipId(byId.getVipId() - 1); - appUserService.updateById(byId); + AppUser appUser = appUserService.getById(id); + UserChangeLog userChangeLog = new UserChangeLog(); + userChangeLog.setDelFlag(0); + userChangeLog.setCreateTime(LocalDateTime.now()); + userChangeLog.setAppUserId(id); + userChangeLog.setBeforeVipId(appUser.getVipId()); + userChangeLog.setAfterVipId(appUser.getVipId() - 1); + userChangeLog.setChangeType(0); + userChangeLogService.save(userChangeLog); + appUser.setVipId(appUser.getVipId() - 1); + appUser.setIsDanger(0); + //检查是否达标,不达标继续标红 + VipSetting vipSetting = vipSettingClient.getVipSetting(appUser.getVipId()).getData(); + //消费积分 + List<UserPoint> list1 = userPointService.list(new LambdaQueryWrapper<UserPoint>().eq(UserPoint::getAppUserId, appUser.getId()).eq(UserPoint::getType, 1).last(" and SUBDATE(now(), INTERVAL " + vipSetting.getKeepBuyDay() + " DAY) <= create_time")); + int sum = list1.stream().mapToInt(UserPoint::getVariablePoint).sum(); + if(sum < vipSetting.getKeepBuyPoint()){ + appUser.setIsDanger(1); + } + //返佣积分 + list1 = userPointService.list(new LambdaQueryWrapper<UserPoint>().eq(UserPoint::getAppUserId, appUser.getId()).eq(UserPoint::getType, 2).last(" and SUBDATE(now(), INTERVAL " + vipSetting.getKeepShareDay() + " DAY) <= create_time")); + sum = list1.stream().mapToInt(UserPoint::getVariablePoint).sum(); + if(sum < vipSetting.getKeepSharePoint()){ + appUser.setIsDanger(1); + } + //门店业绩 + list1 = userPointService.list(new LambdaQueryWrapper<UserPoint>().eq(UserPoint::getAppUserId, appUser.getId()).eq(UserPoint::getType, 8).last(" and SUBDATE(now(), INTERVAL " + vipSetting.getKeepShopDay() + " DAY) <= create_time")); + sum = list1.stream().mapToInt(UserPoint::getVariablePoint).sum(); + if(sum < vipSetting.getKeepShopPoint()){ + appUser.setIsDanger(1); + } + appUserService.updateById(appUser); return R.ok(); } @@ -567,7 +674,21 @@ AppUser byId = appUserService.getById(id); byId.setStatus(status); appUserService.updateById(byId); + loginout(id); return R.ok(); + } + + private void loginout(Long userId) { + Collection<String> keys = redisService.keys(CacheConstants.LOGIN_TOKEN_KEY + "*"); + if (!CollectionUtils.isEmpty(keys)) { + for (String key : keys) { + LoginUser user = redisService.getCacheObject(key); + if (user.getUserid().equals(userId)) { + redisService.deleteObject(key); + break; + } + } + } } @GetMapping("/select") @@ -623,8 +744,7 @@ @GetMapping("/detail") @ApiOperation(value = "用户列表-详情", tags = {"管理后台"}) - public R<AppUser> detail(Long id) { - + public R<AppUser> detail(Long id, Integer shopId, Integer pageNum, Integer pageSize) { Long userid = tokenService.getLoginUser().getUserid(); SysUser sysUser = sysUserClient.getSysUser(userid).getData(); AppUser byId = appUserService.getById(id); @@ -654,10 +774,16 @@ if (lastOrder.getData() != null) { byId.setLastOrderTime(lastOrder.getData().getCreateTime()); } - List<AppUser> list = appUserService.lambdaQuery().eq(AppUser::getInviteUserId, id).list(); - byId.setBottomUsers(list); + Page<AppUser> page = appUserService.page(Page.of(pageNum, pageSize), new LambdaQueryWrapper<AppUser>().eq(AppUser::getInviteUserId, id)); + byId.setBottomUsersPage(page); //消费总金额 - R<List<Order>> orderR = remoteOrderGoodsClient.byShopIdAndUserId(id,sysUser.getObjectId()); + if(null == shopId || 1 == sysUser.getRoleType()){ + shopId = -1; + } + if(null == shopId && 2 == sysUser.getRoleType()){ + shopId = sysUser.getObjectId(); + } + R<List<Order>> orderR = remoteOrderGoodsClient.byUserId(id, shopId); List<Order> orderList = orderR.getData(); if (!CollectionUtils.isEmpty(orderList)){ BigDecimal paymentAmount = orderList.stream().map(Order::getPaymentAmount).reduce(BigDecimal.ZERO, BigDecimal::add); @@ -668,8 +794,7 @@ return R.ok(byId); } - @Resource - private UserChangeLogService userChangeLogService; + @GetMapping("/change/vip") @ApiOperation(value = "用户列表-修改会员等级", tags = {"管理后台"}) @@ -707,7 +832,10 @@ public R<List<Order>> orders(Long id) { Long userid = tokenService.getLoginUser().getUserid(); SysUser sysUser = sysUserClient.getSysUser(userid).getData(); - Integer shopId = sysUser.getObjectId(); + Integer shopId = -1; + if(sysUser.getRoleType() == 2){ + shopId = sysUser.getObjectId(); + } R<List<Order>> listR = remoteOrderGoodsClient.byUserId(id,shopId); return R.ok(listR.getData()); @@ -802,8 +930,6 @@ if (cd.getStartTime().isAfter(cd.getEndTime())) { return R.fail("开始时间不能大于结束时间"); } - - Map<String, Map<Integer, BigDecimal>> dailyVipCommissions = new TreeMap<>(); getDatesBetween(cd.getStartTime(), cd.getEndTime()).forEach(date -> { for (int i = 1; i < 8; i++){ @@ -838,6 +964,15 @@ }); + 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("giveawayMoney"); + } + BigDecimal totalCommission = BigDecimal.ZERO; BigDecimal totalNormalCommission = BigDecimal.ZERO; @@ -853,47 +988,50 @@ 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); - } + Set<String> keySet = dailyVipCommissions.keySet(); + List<CommissionDate> commissionDateList = new ArrayList<>(); + for (String key : keySet) { + CommissionDate commissionDate = new CommissionDate(); + commissionDate.setDate(key); + Map<Integer, BigDecimal> dailyCommissions = dailyVipCommissions.get(key); + commissionDate.setNormalCommission(dailyCommissions.getOrDefault(1, BigDecimal.ZERO)); + totalNormalCommission = totalNormalCommission.add(dailyCommissions.getOrDefault(1, BigDecimal.ZERO)); + + commissionDate.setGoldCommission(dailyCommissions.getOrDefault(2, BigDecimal.ZERO)); + totalGoldCommission = totalGoldCommission.add(dailyCommissions.getOrDefault(2, BigDecimal.ZERO)); + + commissionDate.setDiamondCommission(dailyCommissions.getOrDefault(3, BigDecimal.ZERO)); + totalDiamondCommission = totalDiamondCommission.add(dailyCommissions.getOrDefault(3, BigDecimal.ZERO)); + + commissionDate.setAgentCommission(dailyCommissions.getOrDefault(4, BigDecimal.ZERO)); + totalAgentCommission = totalAgentCommission.add(dailyCommissions.getOrDefault(4, BigDecimal.ZERO)); + + commissionDate.setSuperAgentCommission(dailyCommissions.getOrDefault(5, BigDecimal.ZERO)); + totalSuperAgentCommission = totalSuperAgentCommission.add(dailyCommissions.getOrDefault(5, BigDecimal.ZERO)); + + commissionDate.setTopAgentCommission(dailyCommissions.getOrDefault(6, BigDecimal.ZERO)); + totalTopAgentCommission = totalTopAgentCommission.add(dailyCommissions.getOrDefault(6, BigDecimal.ZERO)); + + commissionDate.setPartnerCommission(dailyCommissions.getOrDefault(7, BigDecimal.ZERO)); + totalPartnerCommission = totalPartnerCommission.add(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)); + commissionDateList.add(commissionDate); } - 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); @@ -901,31 +1039,9 @@ 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()); - + totalCommission = totalNormalCommission.add(totalGoldCommission).add(totalDiamondCommission).add(totalAgentCommission) + .add(totalSuperAgentCommission).add(totalTopAgentCommission).add(totalPartnerCommission); + commissionDetail.setTotalCommission(totalCommission); commissionDetail.setCommissionDateList(commissionDateList); return R.ok(commissionDetail); @@ -982,7 +1098,7 @@ * 检查会员降级 * @param appUserId */ - @PostMapping("/app-user/vipDemotion") + @PostMapping("/vipDemotion") public void vipDemotion(@RequestParam("appUserId") Long appUserId){ appUserService.vipDemotion(appUserId); } -- Gitblit v1.7.1