From a74d740849c6b25b57e18c67ed14b0f5fea79a12 Mon Sep 17 00:00:00 2001 From: luofl <1442745593@qq.com> Date: 星期二, 11 二月 2025 10:06:05 +0800 Subject: [PATCH] 修改物流信息导入模板 --- ruoyi-service/ruoyi-account/src/main/java/com/ruoyi/account/controller/AppUserController.java | 694 ++++++++++++++++++++++++++++++++++++++++++++++----------- 1 files changed, 560 insertions(+), 134 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 68e789c..b52bdb8 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 @@ -1,42 +1,47 @@ package com.ruoyi.account.controller; +import com.alibaba.fastjson2.JSONObject; import com.baomidou.mybatisplus.core.conditions.query.LambdaQueryWrapper; import com.baomidou.mybatisplus.core.conditions.update.LambdaUpdateWrapper; -import com.ruoyi.account.api.model.AppUser; -import com.ruoyi.account.api.model.UserCancellationLog; -import com.ruoyi.account.api.model.UserCoupon; -import com.ruoyi.account.api.model.UserSignRecord; -import com.ruoyi.account.mapper.AppUserMapper; -import com.ruoyi.account.service.AppUserService; -import com.ruoyi.account.service.UserCancellationLogService; -import com.ruoyi.account.service.UserCouponService; -import com.ruoyi.account.service.UserSignRecordService; import com.baomidou.mybatisplus.core.metadata.IPage; +import com.baomidou.mybatisplus.extension.conditions.query.LambdaQueryChainWrapper; import com.baomidou.mybatisplus.extension.plugins.pagination.Page; import com.ruoyi.account.api.model.*; import com.ruoyi.account.dto.DangerInfoDto; +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; import com.ruoyi.order.model.Order; import com.ruoyi.other.api.domain.Shop; +import com.ruoyi.other.api.domain.ShopBalanceStatement; import com.ruoyi.other.api.domain.VipSetting; +import com.ruoyi.other.api.feignClient.ShopBalanceStatementClient; import com.ruoyi.other.api.feignClient.ShopClient; import com.ruoyi.other.api.feignClient.StoreClient; 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.web.bind.annotation.PostMapping; -import org.springframework.web.bind.annotation.RequestBody; -import org.springframework.web.bind.annotation.RequestMapping; -import org.springframework.web.bind.annotation.RestController; +import lombok.extern.slf4j.Slf4j; +import org.springframework.beans.factory.annotation.Value; +import org.springframework.util.CollectionUtils; +import org.springframework.web.bind.annotation.*; +import org.springframework.web.multipart.MultipartFile; import javax.annotation.Resource; import java.io.IOException; @@ -44,14 +49,10 @@ import java.time.LocalDate; import java.time.LocalDateTime; import java.time.format.DateTimeFormatter; +import java.time.temporal.ChronoUnit; import java.util.*; import java.util.stream.Collectors; - -import com.ruoyi.account.vo.*; -import com.ruoyi.common.core.web.controller.BaseController; -import com.ruoyi.common.core.web.page.TableDataInfo; -import org.springframework.web.bind.annotation.*; -import org.springframework.web.multipart.MultipartFile; +import java.util.stream.Stream; /** * <p> @@ -64,9 +65,9 @@ @Api(tags = {"登录注册-小程序"}) @RestController @RequestMapping("/app-user") +@Slf4j public class AppUserController extends BaseController { - - + @Resource private TokenService tokenService; @Resource @@ -94,6 +95,22 @@ private SysUserClient sysUserClient; @Resource private OrderClient orderClient; + @Resource + private ShopBalanceStatementClient shopBalanceStatementClient; + @Resource + 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 @@ -117,10 +134,23 @@ 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") 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(); } @@ -140,7 +170,11 @@ @ResponseBody @PostMapping("/getCouponCount") public R<Long> getCouponCount(@RequestParam("userId") Long userId, @RequestParam("couponId") Integer couponId) { - Long count = userCouponService.lambdaQuery().eq(UserCoupon::getAppUserId, userId).eq(UserCoupon::getCouponId, couponId).count(); + LambdaQueryChainWrapper<UserCoupon> chainWrapper = userCouponService.lambdaQuery().eq(UserCoupon::getCouponId, couponId); + if(null != userId && -1 == userId){ + chainWrapper.eq(UserCoupon::getAppUserId, userId); + } + Long count = chainWrapper.count(); return R.ok(count); } @@ -196,11 +230,17 @@ 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/start/start", "id=" + user.getId(), EnvVersion.RELEASE, filePath + fileName); + user.setQrCode(getwxacodeunlimit); + appUserService.updateById(user); + } return R.ok(user); } - @Resource - private UserCancellationLogService userCancellationLogService; + @ResponseBody @GetMapping("/unregis") @@ -216,6 +256,14 @@ userCancellationLogService.save(userCancellationLog); user.setStatus(3); appUserService.updateById(user); + + List<AppUser> subUserList = appUserService.list(new LambdaQueryWrapper<AppUser>() + .eq(AppUser::getInviteUserId, userId)); + for (AppUser appUser : subUserList) { + Long inviteUserId = user.getInviteUserId(); + appUser.setInviteUserId(inviteUserId); + } + appUserService.updateBatchById(subUserList); return R.ok(); } @@ -242,15 +290,92 @@ user.setTopUser(byId); } //获取绑定下级列表 - List<AppUser> list = appUserService.lambdaQuery().eq(AppUser::getInviteUserId, user.getId()).list(); + List<AppUser> list = appUserService.lambdaQuery() + .eq(AppUser::getInviteUserId, user.getId()) + .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) { - Long count1 = appUserService.lambdaQuery().eq(AppUser::getVipId, 1).eq(AppUser::getInviteUserId, appUser.getId()).count(); - Long count2 = appUserService.lambdaQuery().eq(AppUser::getVipId, 2).eq(AppUser::getInviteUserId, appUser.getId()).count(); - Long count3 = appUserService.lambdaQuery().eq(AppUser::getVipId, 3).eq(AppUser::getInviteUserId, appUser.getId()).count(); - Long count4 = appUserService.lambdaQuery().eq(AppUser::getVipId, 4).eq(AppUser::getInviteUserId, appUser.getId()).count(); - Long count5 = appUserService.lambdaQuery().eq(AppUser::getVipId, 5).eq(AppUser::getInviteUserId, appUser.getId()).count(); - Long count6 = appUserService.lambdaQuery().eq(AppUser::getVipId, 6).eq(AppUser::getInviteUserId, appUser.getId()).count(); - Long count7 = appUserService.lambdaQuery().eq(AppUser::getVipId, 7).eq(AppUser::getInviteUserId, appUser.getId()).count(); + 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); @@ -260,7 +385,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); } @@ -270,6 +401,12 @@ public R<AppUser> change(@ApiParam("换绑用户手机号") String phone) { Long userId1 = tokenService.getLoginUserApplet().getUserid(); AppUser byId = appUserService.getById(userId1); + List<AppUser> appUserList = appUserService.list(new LambdaQueryWrapper<AppUser>() + .eq(AppUser::getInviteUserId, userId1) + .eq(AppUser::getPhone, phone)); + if (!CollectionUtils.isEmpty(appUserList)){ + return R.fail("绑定关系已存在!"); + } //获取绑定门店 AppUser user = appUserService.lambdaQuery().eq(AppUser::getPhone, phone).one(); if (user == null) { @@ -287,6 +424,14 @@ 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/start/start", "id=" + user.getId(), EnvVersion.RELEASE, filePath + fileName); + user.setQrCode(getwxacodeunlimit); + appUserService.updateById(user); + } + //当前用户的推荐人信息 if (user.getInviteUserId() != null) { AppUser inviteUser = appUserService.getById(user.getInviteUserId()); @@ -296,33 +441,55 @@ if (user.getShopId() != null) { R<Shop> storeById = shopClient.getShopById(user.getShopId()); if (storeById.getData() != null) { - user.setShopName(storeById.getData().getName()); + Shop shop = storeById.getData(); + 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(); - user.setCount1(count1); - user.setCount2(count2); - user.setCount3(count3); - user.setCount4(count4); - user.setCount5(count5); - user.setCount6(count6); - user.setCount7(count7); + List<AppUser> appUserList = appUserService.list(new LambdaQueryWrapper<AppUser>() + .ne(AppUser::getStatus, 3) + .eq(AppUser::getDelFlag, 0)); + ArrayList<Long> userIds = new ArrayList<>(); + userIds.add(userId); + getUserAncestorList(user,userIds,new ArrayList<>(),appUserList); +// 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); +// user.setCount4(count4); +// user.setCount5(count5); +// user.setCount6(count6); +// user.setCount7(count7); - List<UserSignRecord> list = userSignRecordService.lambdaQuery().eq(UserSignRecord::getSignDay, LocalDate.now()).list(); + List<UserSignRecord> list = userSignRecordService.lambdaQuery().eq(UserSignRecord::getSignDay, LocalDate.now()) + .eq(UserSignRecord::getAppUserId,userId).list(); if (!list.isEmpty()) { user.setIsSign(1); } else { user.setIsSign(0); } return R.ok(user); - - + } + + + public void getUserAncestorList(AppUser user,List<Long> userIds, List<AppUser> children,List<AppUser> list) { + children = list.stream().filter(u -> userIds.contains(u.getInviteUserId()) || userIds.contains(u.getTopInviteId())).collect(Collectors.toList()); + if(!CollectionUtils.isEmpty(children)){ + user.setCount1((user.getCount1() == null ? 0L : user.getCount1()) + children.stream().filter(e->e.getVipId() == 1).count()); + user.setCount2((user.getCount2() == null ? 0L : user.getCount2()) + children.stream().filter(e->e.getVipId() == 2).count()); + user.setCount3((user.getCount3() == null ? 0L : user.getCount3()) + children.stream().filter(e->e.getVipId() == 3).count()); + user.setCount4((user.getCount4() == null ? 0L : user.getCount4()) + children.stream().filter(e->e.getVipId() == 4).count()); + user.setCount5((user.getCount5() == null ? 0L : user.getCount5()) + children.stream().filter(e->e.getVipId() == 5).count()); + user.setCount6((user.getCount6() == null ? 0L : user.getCount6()) + children.stream().filter(e->e.getVipId() == 6).count()); + user.setCount7((user.getCount7() == null ? 0L : user.getCount7()) + children.stream().filter(e->e.getVipId() == 7).count()); + List<Long> userIdList = children.stream().map(AppUser::getId).collect(Collectors.toList()); + getUserAncestorList(user,userIdList, children,list); + } } @GetMapping("/index/change") @@ -379,6 +546,16 @@ .like(AppUser::getName, name)); return R.ok(list); } + /** + * 根据用户名称模糊搜索用户列表,不过滤状态 + */ + @GetMapping("/getAppUserByNameNoFilter") + public R<List<AppUser>> getAppUserByNameNoFilter(@RequestParam("name") String name) { + List<AppUser> list = appUserService.list(new LambdaQueryWrapper<AppUser>() + .like(AppUser::getName, name)); + return R.ok(list); + } + /** * 根据用户电话模糊搜索用户列表 @@ -390,6 +567,15 @@ public R<List<AppUser>> getAppUserByPhone(@RequestParam("phone") String phone) { List<AppUser> list = appUserService.list(new LambdaQueryWrapper<AppUser>().eq(AppUser::getDelFlag, 0).eq(AppUser::getStatus, 1) .like(AppUser::getPhone, phone)); + return R.ok(list); + } + + /** + * 更具用户电话模糊查询用户列表,不过滤状态 + */ + @GetMapping("/getAppUserByPhoneNoFilter") + public R<List<AppUser>> getAppUserByPhoneNoFilter(@RequestParam("phone") String phone) { + List<AppUser> list = appUserService.getAppUserByPhoneNoFilter(phone); return R.ok(list); } @@ -432,14 +618,19 @@ public R<IPage<AppUser>> shopGetAppuserPage(@ApiParam("页码") @RequestParam Integer pageCurr, @ApiParam("每一页数据大小") Integer pageSize, AppUser appUser) { - Integer objectId = tokenService.getLoginUser().getSysUser().getObjectId(); + Long userid = tokenService.getLoginUser().getUserid(); + R<SysUser> sysUserR = sysUserClient.getSysUser(userid); + SysUser sysUser = sysUserR.getData(); List<Long> userIds = new ArrayList<>(); userIds.add(-1L); //获取在该本店下单的用户ids + Integer objectId = sysUser.getObjectId(); R<List<Order>> listR = remoteOrderGoodsClient.byShopId(objectId); - for (Order datum : listR.getData()) { - userIds.add(datum.getAppUserId()); + if (listR.getData()!=null){ + for (Order datum : listR.getData()) { + userIds.add(datum.getAppUserId()); + } } IPage<AppUser> appuserPage = appUserService.getAppuserPage1(pageCurr, pageSize, appUser, objectId, userIds); return R.ok(appuserPage); @@ -455,9 +646,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, 2).ge(UserPoint::getCreateTime, now.minusDays(data.getKeepBuyDay())).list(); - List<UserPoint> list3 = userPointService.lambdaQuery().eq(UserPoint::getType, 5).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; @@ -480,9 +671,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(); } @@ -492,13 +712,36 @@ AppUser byId = appUserService.getById(id); byId.setStatus(status); appUserService.updateById(byId); + if (status == 2){ + 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 == null || user.getUserid() == null) { + continue; + } + if (user.getUserid().equals(userId)) { + redisService.deleteObject(key); + break; + } + } + } } @GetMapping("/select") @ApiOperation(value = "用户列表-查询绑定人", tags = {"管理后台"}) public R<AppUser> select(String phone) { - AppUser byId = appUserService.lambdaQuery().eq(AppUser::getPhone, phone).one(); + AppUser byId = appUserService.lambdaQuery() + .eq(AppUser::getPhone, phone) + .eq(AppUser::getDelFlag,0) + .eq(AppUser::getStatus,1) + .one(); if (byId == null) { return R.fail("搜索失败,手机号错误。"); } @@ -509,6 +752,18 @@ @ApiOperation(value = "用户列表-更换绑定人", tags = {"管理后台"}) public R<AppUser> select(Long id, Long inviteId) { AppUser byId = appUserService.getById(id); + Long userId = byId.getId(); + if (userId.equals(inviteId)) { + return R.fail("不能选择自己为绑定人。"); + } + + List<AppUser> appUserList = appUserService.list(new LambdaQueryWrapper<AppUser>() + .eq(AppUser::getInviteUserId, id) + .eq(AppUser::getId, inviteId)); + if (!CollectionUtils.isEmpty(appUserList)){ + return R.fail("绑定关系已存在!"); + } + byId.setInviteUserId(inviteId); byId.setTopInviteId(getTop(inviteId)); appUserService.updateById(byId); @@ -540,7 +795,9 @@ @GetMapping("/detail") @ApiOperation(value = "用户列表-详情", tags = {"管理后台"}) - public R<AppUser> detail(Long id) { + public R<AppUser> detail(Long id, Integer shopId) { + Long userid = tokenService.getLoginUser().getUserid(); + SysUser sysUser = sysUserClient.getSysUser(userid).getData(); AppUser byId = appUserService.getById(id); if (byId.getShopId() != null) { R<Shop> shopById = shopClient.getShopById(Integer.parseInt(String.valueOf(byId.getShopId()))); @@ -571,11 +828,38 @@ List<AppUser> list = appUserService.lambdaQuery().eq(AppUser::getInviteUserId, id).list(); byId.setBottomUsers(list); //消费总金额 + 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); + byId.setShopAmount(paymentAmount); + }else { + byId.setShopAmount(BigDecimal.ZERO); + } return R.ok(byId); } - @Resource - private UserChangeLogService userChangeLogService; + /** + * 获取指定用户的下级用户 + */ + @GetMapping("/bottom/list") + @ApiOperation(value = "用户列表-下级用户", tags = {"管理后台"}) + public R<Page<AppUser>> bottom(Integer pageNum, Integer pageSize, Long userId){ + Page<AppUser> page = appUserService.page(Page.of(pageNum, pageSize), new LambdaQueryWrapper<AppUser>() + .eq(AppUser::getInviteUserId, userId)); + return R.ok(page); + } + + + + + @GetMapping("/change/vip") @ApiOperation(value = "用户列表-修改会员等级", tags = {"管理后台"}) @@ -596,29 +880,57 @@ byId.setVipId(vipId); appUserService.updateById(byId); return R.ok(); - } @GetMapping("/bottom") @ApiOperation(value = "用户列表-绑定下级列表", tags = {"管理后台"}) public R<Page<AppUser>> bottom(Long id, Integer pageNum, Integer pageSize) { //绑定下级 - Page<AppUser> page = appUserService.lambdaQuery().eq(AppUser::getInviteUserId, id).page(Page.of(pageNum, pageSize)); + Page<AppUser> page = appUserService.lambdaQuery() + .eq(AppUser::getInviteUserId, id) + .eq(AppUser::getDelFlag, 0) + .eq(AppUser::getStatus, 1) + .page(Page.of(pageNum, pageSize)); return R.ok(page); } @GetMapping("/orders") @ApiOperation(value = "用户列表-订单列表", tags = {"管理后台"}) - public R<List<Order>> orders(Long id) { - R<List<Order>> listR = remoteOrderGoodsClient.byUserId(id); - return R.ok(listR.getData()); - + public R<JSONObject> orders(Long id,Integer pageNum, Integer pageSize) { + Long userid = tokenService.getLoginUser().getUserid(); + SysUser sysUser = sysUserClient.getSysUser(userid).getData(); + Integer shopId = -1; + if(sysUser.getRoleType() == 2){ + shopId = sysUser.getObjectId(); + } + R<List<Order>> listR = remoteOrderGoodsClient.byUserId(id,shopId); + List<Order> data = listR.getData(); + Integer total = data.size(); + // 手动分页 + if (data != null && data.size() > 0) { + if (pageNum == null || pageNum == 0) { + pageNum = 1; + } + if (pageSize == null || pageSize == 0) { + pageSize = 10; + } + data = data.stream() + .skip((pageNum - 1) * pageSize) + .limit(pageSize) + .collect(Collectors.toList()); + } + JSONObject jsonObject = new JSONObject(); + jsonObject.put("records", data); + jsonObject.put("total", total); + jsonObject.put("size", pageSize); + jsonObject.put("current", pageNum); + return R.ok(jsonObject); } - @GetMapping("/listByIds") - List<AppUser> listByIds(@RequestParam("ids") List<Long> ids) { + @PostMapping("/listByIds") + public List<AppUser> listByIds(@RequestParam("ids") List<Long> ids) { if(ids.size() == 0){ return new ArrayList<>(); } @@ -634,6 +946,19 @@ return R.ok(appUser); } + + /** + * 设置指定用户的下级用户绑定门店 + */ + @PostMapping("/setLowerUserShop") + public R<Void> setLowerUserShop(@RequestParam("userId") Long userId,@RequestParam("shopId") Integer shopId) { + appUserService.update(new LambdaUpdateWrapper<AppUser>() + .set(AppUser::getShopId,shopId) + .eq(AppUser::getInviteUserId, userId)); + return R.ok(); + } + + /** * 用户统计 */ @@ -644,14 +969,11 @@ SysUser data = sysUserClient.getSysUser(userid).getData(); Integer shopId = null; Set<Long> userId = null; - Set<Long> userIdT = null; if(data.getRoleType() == 2){ shopId = data.getObjectId(); userId = orderClient.getAppUserByShoppingShop(shopId).getData(); } UserStatistics userStatistics = appUserMapper.getUserStatistics(shopId, userId); - UserStatistics userStatistics1 = appUserMapper.getUserStatistics(shopId, userIdT); - userStatistics.setShopUser(userStatistics1.getShopUser()); return R.ok(userStatistics); } @@ -688,79 +1010,171 @@ */ @GetMapping("/commissionDetail") @ApiOperation(value = "分佣统计", tags = "管理后台-首页统计") - public R<CommissionDetail> commissionDetail() { + public R<CommissionDetail> commissionDetail(CommissionDetail cd) { + if (cd.getStartTime() == null || cd.getEndTime() == null) { + return R.fail("请选择时间"); + } + if (cd.getStartTime().isAfter(cd.getEndTime())) { + return R.fail("开始时间不能大于结束时间"); + } Long userid = tokenService.getLoginUser().getUserid(); SysUser sysUser = sysUserClient.getSysUser(userid).getData(); - LambdaQueryWrapper<AppUser> queryWrapper = new LambdaQueryWrapper<AppUser>().eq(AppUser::getDelFlag, 0); + Map<String, Map<Integer, BigDecimal>> dailyVipCommissions = new TreeMap<>(); + getDatesBetween(cd.getStartTime(), cd.getEndTime()).forEach(date -> { + for (int i = 1; i < 8; i++){ + LambdaQueryWrapper<BalanceChangeRecord> queryWrapper = new LambdaQueryWrapper<BalanceChangeRecord>() + .between(BalanceChangeRecord::getCreateTime, date, date.plusDays(1)) + .eq(BalanceChangeRecord::getChangeType, 4) + .eq(BalanceChangeRecord::getVipId, i); + if(sysUser.getRoleType() == 2){ + Integer objectId = sysUser.getObjectId(); + List<AppUser> list = appUserService.list(new LambdaQueryWrapper<AppUser>().eq(AppUser::getShopId, objectId).eq(AppUser::getDelFlag, 0).eq(AppUser::getStatus, 1)); + List<Long> appUserIds = list.stream().map(AppUser::getId).collect(Collectors.toList()); + Set<Long> data = orderClient.getAppUserByShoppingShop(objectId).getData(); + if(null != data){ + appUserIds.addAll(data); + } + if(appUserIds.size() == 0){ + appUserIds.add(-1L); + } + queryWrapper.in(BalanceChangeRecord::getAppUserId, appUserIds); + } + List<BalanceChangeRecord> list = balanceChangeRecordService.list(queryWrapper); + BigDecimal reduce = list.stream().map(BalanceChangeRecord::getChangeAmount).reduce(BigDecimal.ZERO, BigDecimal::add); + String dateKey = date.format(DateTimeFormatter.ofPattern("yyyy-MM-dd")); + dailyVipCommissions.computeIfAbsent(dateKey, k -> new HashMap<>()) + .merge(i, reduce, BigDecimal::add); + } + + for (int i = 1; i < 4; i++){ + Integer objectId = 0; + if(sysUser.getRoleType() == 2){ + objectId = sysUser.getObjectId(); + } + R<List<ShopBalanceStatement>> r = shopBalanceStatementClient.getShopBalanceStatementList2(i, objectId, date); + if (!CollectionUtils.isEmpty(r.getData())){ + List<ShopBalanceStatement> list = r.getData(); + BigDecimal reduce = list.stream().map(ShopBalanceStatement::getVariableAmount).reduce(BigDecimal.ZERO, BigDecimal::add); + String dateKey = date.format(DateTimeFormatter.ofPattern("yyyy-MM-dd")); + int type; + if (i == 1){ + type = 8; + }else if (i == 2){ + type = 9; + }else { + type = 10; + } + dailyVipCommissions.computeIfAbsent(dateKey, k -> new HashMap<>()) + .merge(type, reduce, BigDecimal::add); + } + } + }); + Integer objectId = 0; if(sysUser.getRoleType() == 2){ - queryWrapper.eq(AppUser::getShopId, sysUser.getObjectId()); + objectId = sysUser.getObjectId(); } - List<AppUser> appUserList = appUserService.list(queryWrapper); - if (appUserList.isEmpty()) { - return R.ok(new CommissionDetail()); - } - BigDecimal totalCommission = BigDecimal.ZERO; + + R<Map<String, BigDecimal>> shopStatistics = shopClient.getShopStatistics(objectId); + Map<String, BigDecimal> data = shopStatistics.getData(); BigDecimal totalServiceFee = BigDecimal.ZERO; BigDecimal totalUserCommission = BigDecimal.ZERO; - Map<Integer, BigDecimal> vipCommissions = new HashMap<>(); - Map<String, Map<Integer, BigDecimal>> dailyVipCommissions = new HashMap<>(); - 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); + if (data != null){ + totalServiceFee = data.get("serverGiveawayMoney"); + totalUserCommission = data.get("giveawayMoney"); + } - String dateKey = appUser.getCreateTime().format(DateTimeFormatter.ofPattern("yyyy-MM-dd")); - dailyVipCommissions.computeIfAbsent(dateKey, k -> new HashMap<>()) - .merge(vipId, distributionAmount, BigDecimal::add); - } + 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; + + 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); } - 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()); - } + + 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); - return commissionDate; - }) - .collect(Collectors.toList()); - + commissionDetail.setTotalNormalCommission(totalNormalCommission); + commissionDetail.setTotalGoldCommission(totalGoldCommission); + commissionDetail.setTotalDiamondCommission(totalDiamondCommission); + commissionDetail.setTotalAgentCommission(totalAgentCommission); + commissionDetail.setTotalSuperAgentCommission(totalSuperAgentCommission); + commissionDetail.setTotalTopAgentCommission(totalTopAgentCommission); + commissionDetail.setTotalPartnerCommission(totalPartnerCommission); + totalCommission = totalNormalCommission.add(totalGoldCommission).add(totalDiamondCommission).add(totalAgentCommission) + .add(totalSuperAgentCommission).add(totalTopAgentCommission).add(totalPartnerCommission); + commissionDetail.setTotalCommission(totalCommission); commissionDetail.setCommissionDateList(commissionDateList); + return R.ok(commissionDetail); } - + + + /** + * 获取指定时间段内每一天的列表 + * + * @param startDate 开始日期时间 + * @param endDate 结束日期时间 + * @return 包含每天日期时间的列表 + */ + private static List<LocalDateTime> getDatesBetween(LocalDateTime startDate, LocalDateTime endDate) { + // 计算开始日期和结束日期之间的天数差(忽略时间部分) + long daysBetween = ChronoUnit.DAYS.between(startDate.toLocalDate(), endDate.toLocalDate()); + + // 使用Stream.iterate从开始日期开始迭代,每次增加一天,直到达到天数差+1 + return Stream.iterate(startDate, date -> date.plus(1, ChronoUnit.DAYS)) + .limit(daysBetween + 1) + .collect(Collectors.toList()); + } + + /** * 上传图片 @@ -790,6 +1204,17 @@ /** + * 检查会员降级 + * @param appUserId + */ + @PostMapping("/vipDemotion") + public void vipDemotion(@RequestParam("appUserId") Long appUserId){ + appUserService.vipDemotion(appUserId); + } + + + + /** * 用户降级检测 */ @PostMapping("/demotionDetection") @@ -805,7 +1230,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