From c27c1f2beb4ca89a94eaa854fce6b4553db8f2f8 Mon Sep 17 00:00:00 2001 From: xuhy <3313886187@qq.com> Date: 星期三, 15 一月 2025 19:58:12 +0800 Subject: [PATCH] 修改 --- ruoyi-service/ruoyi-account/src/main/java/com/ruoyi/account/controller/AppUserController.java | 530 +++++++++++++++++++++++++++++++++++++++++++++++----------- 1 files changed, 429 insertions(+), 101 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 cef0b0f..01a39c9 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 @@ -2,6 +2,9 @@ import com.baomidou.mybatisplus.core.conditions.query.LambdaQueryWrapper; +import com.baomidou.mybatisplus.core.conditions.update.LambdaUpdateWrapper; +import com.baomidou.mybatisplus.extension.conditions.query.LambdaQueryChainWrapper; +import com.fasterxml.jackson.annotation.JsonFormat; import com.ruoyi.account.api.model.AppUser; import com.ruoyi.account.api.model.UserCancellationLog; import com.ruoyi.account.api.model.UserCoupon; @@ -16,35 +19,50 @@ import com.ruoyi.account.api.model.*; import com.ruoyi.account.dto.DangerInfoDto; import com.ruoyi.account.service.*; +import com.ruoyi.account.util.ObsUploadUtil; import com.ruoyi.common.core.domain.R; import com.ruoyi.common.core.utils.bean.BeanUtils; -import com.ruoyi.common.core.web.domain.AjaxResult; +import com.ruoyi.common.core.web.page.PageInfo; +import com.ruoyi.common.redis.annotation.DistributedLock; 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.factory.ShopBalanceStatementClientFallbackFactory; +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 io.swagger.annotations.*; +import org.springframework.beans.factory.annotation.Autowired; +import org.springframework.format.annotation.DateTimeFormat; +import org.springframework.util.CollectionUtils; 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 javax.annotation.Resource; +import java.io.IOException; import java.math.BigDecimal; 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 java.util.stream.Stream; 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; /** * <p> @@ -79,6 +97,20 @@ private VipSettingService vipSettingService; @Resource private AppUserMapper appUserMapper; + @Resource + private ShopClient shopClient; + @Resource + private RemoteOrderGoodsClient remoteOrderGoodsClient; + @Resource + private SysUserClient sysUserClient; + @Resource + private OrderClient orderClient; + @Resource + private ShopBalanceStatementClient shopBalanceStatementClient; + @Resource + private UserCancellationLogService userCancellationLogService; + @Resource + private BalanceChangeRecordService balanceChangeRecordService; @ResponseBody @@ -97,7 +129,6 @@ } - @ResponseBody @PostMapping("/getAppUserById") public AppUser getAppUserById(@RequestParam("id") Long id) { return appUserService.getById(id); @@ -107,6 +138,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(); } @@ -126,7 +159,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); } @@ -171,10 +208,8 @@ @ResponseBody @GetMapping("/getNearbyReferrer") @ApiOperation(value = "获取附近推荐人列表") - public TableDataInfo<NearbyReferrerVo> getNearbyReferrer(NearbyReferrer nearbyReferrer) { - startPage(); - List<NearbyReferrerVo> list = appUserService.getNearbyReferrer(nearbyReferrer); - return getDataTable(list); + public R<PageInfo<NearbyReferrerVo>> getNearbyReferrer(NearbyReferrer nearbyReferrer) { + return R.ok(appUserService.getNearbyReferrer(nearbyReferrer)); } @@ -187,8 +222,7 @@ return R.ok(user); } - @Resource - private UserCancellationLogService userCancellationLogService; + @ResponseBody @GetMapping("/unregis") @@ -202,8 +236,16 @@ userCancellationLog.setAppUserId(user.getId()); userCancellationLog.setVipId(user.getVipId()); 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(); } @@ -230,15 +272,54 @@ user.setTopUser(byId); } //获取绑定下级列表 - List<AppUser> list = appUserService.lambdaQuery().eq(AppUser::getInviteUserId, user.getInviteUserId()).list(); + List<AppUser> list = appUserService.lambdaQuery() + .eq(AppUser::getInviteUserId, user.getId()) + .eq(AppUser::getDelFlag, 0) + .ne(AppUser::getStatus, 3) + .list(); for (AppUser appUser : list) { - Long count1 = appUserService.lambdaQuery().eq(AppUser::getVipId, 1).eq(AppUser::getTopInviteId, 1).count(); - Long count2 = appUserService.lambdaQuery().eq(AppUser::getVipId, 2).eq(AppUser::getTopInviteId, userId).count(); - Long count3 = appUserService.lambdaQuery().eq(AppUser::getVipId, 3).eq(AppUser::getTopInviteId, userId).count(); - Long count4 = appUserService.lambdaQuery().eq(AppUser::getVipId, 4).eq(AppUser::getTopInviteId, userId).count(); - Long count5 = appUserService.lambdaQuery().eq(AppUser::getVipId, 5).eq(AppUser::getTopInviteId, userId).count(); - Long count6 = appUserService.lambdaQuery().eq(AppUser::getVipId, 6).eq(AppUser::getTopInviteId, userId).count(); - Long count7 = appUserService.lambdaQuery().eq(AppUser::getVipId, 7).eq(AppUser::getTopInviteId, userId).count(); + Long count1 = appUserService.lambdaQuery() + .eq(AppUser::getVipId, 1) + .eq(AppUser::getInviteUserId, appUser.getId()) + .eq(AppUser::getDelFlag, 0) + .ne(AppUser::getStatus, 3) + .count(); + Long count2 = appUserService.lambdaQuery() + .eq(AppUser::getVipId, 2) + .eq(AppUser::getInviteUserId, appUser.getId()) + .eq(AppUser::getDelFlag, 0) + .ne(AppUser::getStatus, 3) + .count(); + Long count3 = appUserService.lambdaQuery() + .eq(AppUser::getVipId, 3) + .eq(AppUser::getInviteUserId, appUser.getId()) + .eq(AppUser::getDelFlag, 0) + .ne(AppUser::getStatus, 3) + .count(); + Long count4 = appUserService.lambdaQuery() + .eq(AppUser::getVipId, 4) + .eq(AppUser::getInviteUserId, appUser.getId()) + .eq(AppUser::getDelFlag, 0) + .ne(AppUser::getStatus, 3) + .count(); + Long count5 = appUserService.lambdaQuery() + .eq(AppUser::getVipId, 5) + .eq(AppUser::getInviteUserId, appUser.getId()) + .eq(AppUser::getDelFlag, 0) + .ne(AppUser::getStatus, 3) + .count(); + Long count6 = appUserService.lambdaQuery() + .eq(AppUser::getVipId, 6) + .eq(AppUser::getInviteUserId, appUser.getId()) + .eq(AppUser::getDelFlag, 0) + .ne(AppUser::getStatus, 3) + .count(); + Long count7 = appUserService.lambdaQuery() + .eq(AppUser::getVipId, 7) + .eq(AppUser::getInviteUserId, appUser.getId()) + .eq(AppUser::getDelFlag, 0) + .ne(AppUser::getStatus, 3) + .count(); appUser.setCount1(count1); appUser.setCount2(count2); appUser.setCount3(count3); @@ -272,7 +353,6 @@ @GetMapping("/index") @ApiOperation(value = "个人中心首页", tags = {"小程序-个人中心首页"}) public R<AppUser> index() { - System.err.println("=-===="); Long userId = tokenService.getLoginUserApplet().getUserid(); //当前用户信息 AppUser user = appUserService.getById(userId); @@ -283,35 +363,55 @@ } //当前绑定门店的店铺信息 if (user.getShopId() != null) { - R<Shop> storeById = storeClient.getStoreById(user.getShopId()); + 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::getTopInviteId, 1).count(); - Long count2 = appUserService.lambdaQuery().eq(AppUser::getVipId, 2).eq(AppUser::getTopInviteId, userId).count(); - Long count3 = appUserService.lambdaQuery().eq(AppUser::getVipId, 3).eq(AppUser::getTopInviteId, userId).count(); - Long count4 = appUserService.lambdaQuery().eq(AppUser::getVipId, 4).eq(AppUser::getTopInviteId, userId).count(); - Long count5 = appUserService.lambdaQuery().eq(AppUser::getVipId, 5).eq(AppUser::getTopInviteId, userId).count(); - Long count6 = appUserService.lambdaQuery().eq(AppUser::getVipId, 6).eq(AppUser::getTopInviteId, userId).count(); - Long count7 = appUserService.lambdaQuery().eq(AppUser::getVipId, 7).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") @@ -390,25 +490,52 @@ public R<IPage<AppUser>> getAppuserPage(@ApiParam("页码") @RequestParam Integer pageNum, @ApiParam("每一页数据大小") Integer pageSize, AppUser appUser) { - IPage<AppUser> appuserPage = appUserService.getAppuserPage(pageNum, pageSize, appUser); + Long userid = tokenService.getLoginUser().getUserid(); + SysUser sysUser = sysUserClient.getSysUser(userid).getData(); + Integer shopId = null; + Set<Long> userId = null; + if(sysUser.getRoleType() == 2){ + shopId = sysUser.getObjectId(); + userId = orderClient.getAppUserByShoppingShop(shopId).getData(); + } + IPage<AppUser> appuserPage = appUserService.getAppuserPage(pageNum, pageSize, appUser, shopId, userId); + for (AppUser record : appuserPage.getRecords()) { + if (record.getInviteUserId() != null) { + AppUser byId1 = appUserService.getById(record.getInviteUserId()); + if (byId1!=null) { + record.setInviteUserName(byId1.getName()); + } + } + if (record.getShopId()!=null){ + R<Shop> shopById = shopClient.getShopById(record.getShopId()); + if (shopById.getData()!=null){ + record.setShopName(shopById.getData().getName()); + } + } + } return R.ok(appuserPage); } @GetMapping("/shop/getAppuserPage") @ApiOperation(value = "用户列表", tags = {"门店后台"}) - public R<IPage<AppUser>> shopGetAppuserPage(@ApiParam("页码") @RequestParam Integer pageNum, + 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(pageNum, pageSize, appUser, objectId, userIds); + IPage<AppUser> appuserPage = appUserService.getAppuserPage1(pageCurr, pageSize, appUser, objectId, userIds); return R.ok(appuserPage); } @@ -450,16 +577,6 @@ AppUser byId = appUserService.getById(id); byId.setVipId(byId.getVipId() - 1); appUserService.updateById(byId); - //执行降级标记代码 - new Thread(new Runnable() { - @Override - public void run() { - { - vipSettingService.downUsers(); - } - } - } - ).start(); return R.ok(); } @@ -475,7 +592,11 @@ @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("搜索失败,手机号错误。"); } @@ -486,6 +607,10 @@ @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("不能选择自己为绑定人。"); + } byId.setInviteUserId(inviteId); byId.setTopInviteId(getTop(inviteId)); appUserService.updateById(byId); @@ -494,7 +619,7 @@ @GetMapping("/change/shop") @ApiOperation(value = "用户列表-更换门店", tags = {"管理后台"}) - public R<AppUser> shop(Long id, Long shopId) { + public R<AppUser> shop(Long id, Integer shopId) { AppUser byId = appUserService.getById(id); byId.setShopId(shopId); appUserService.updateById(byId); @@ -512,14 +637,15 @@ } - @Resource - private ShopClient shopClient; - @Resource - private RemoteOrderGoodsClient remoteOrderGoodsClient; + + @GetMapping("/detail") @ApiOperation(value = "用户列表-详情", tags = {"管理后台"}) public R<AppUser> detail(Long id) { + + 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()))); @@ -537,15 +663,27 @@ } //推广人 if (byId.getInviteUserId() != null) { - AppUser byId1 = appUserService.getById(byId.getInviteUserId()); - byId1.setInviteUserName(byId1.getInviteUserName()); + AppUser appUser = appUserService.getById(byId.getInviteUserId()); + if(null != appUser){ + byId.setInviteUserName(appUser.getName()); + } } //最后下单时间 R<Order> lastOrder = remoteOrderGoodsClient.getLastOrder(id); if (lastOrder.getData() != null) { byId.setLastOrderTime(lastOrder.getData().getCreateTime()); } + List<AppUser> list = appUserService.lambdaQuery().eq(AppUser::getInviteUserId, id).list(); + byId.setBottomUsers(list); //消费总金额 + R<List<Order>> orderR = remoteOrderGoodsClient.byShopId(sysUser.getObjectId()); + 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); } @@ -586,14 +724,20 @@ @GetMapping("/orders") @ApiOperation(value = "用户列表-订单列表", tags = {"管理后台"}) public R<List<Order>> orders(Long id) { - R<List<Order>> listR = remoteOrderGoodsClient.byUserId(id); + Long userid = tokenService.getLoginUser().getUserid(); + SysUser sysUser = sysUserClient.getSysUser(userid).getData(); + Long shopId = Long.valueOf(sysUser.getObjectId()); + R<List<Order>> listR = remoteOrderGoodsClient.byUserId(id,shopId); return R.ok(listR.getData()); } - @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<>(); + } List<AppUser> appUsers = appUserService.listByIds(ids); return appUsers; } @@ -601,10 +745,23 @@ @PostMapping("/getAppUserByPhone1") public R<AppUser> getAppUserByPhone1(@RequestParam("phone") String phone) { - AppUser appUser = appUserService.getOne(new LambdaQueryWrapper<AppUser>().eq(AppUser::getDelFlag, 0).eq(AppUser::getStatus, 1) + AppUser appUser = appUserService.getOne(new LambdaQueryWrapper<AppUser>().eq(AppUser::getDelFlag, 0).ne(AppUser::getStatus, 3) .eq(AppUser::getPhone, phone)); 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(); + } + /** * 用户统计 @@ -612,7 +769,15 @@ @GetMapping("/statistics") @ApiOperation(value = "用户统计", tags = {"管理后台-首页统计-用户统计"}) public R<UserStatistics> statistics() { - UserStatistics userStatistics = appUserMapper.getUserStatistics(); + Long userid = tokenService.getLoginUser().getUserid(); + SysUser data = sysUserClient.getSysUser(userid).getData(); + Integer shopId = null; + Set<Long> userId = null; + if(data.getRoleType() == 2){ + shopId = data.getObjectId(); + userId = orderClient.getAppUserByShoppingShop(shopId).getData(); + } + UserStatistics userStatistics = appUserMapper.getUserStatistics(shopId, userId); return R.ok(userStatistics); } @@ -622,7 +787,24 @@ @GetMapping("/statistics/detail") @ApiOperation(value = "用户统计详情", tags = {"管理后台-首页统计-用户统计详情"}) public R<UserStatisticsDetail> statisticsDetail(@ApiParam(value = "用户id") Long userId) { - UserStatisticsDetail userStatisticsDetail = appUserMapper.getUserStatisticsDetail(userId); + Long userid = tokenService.getLoginUser().getUserid(); + SysUser data = sysUserClient.getSysUser(userid).getData(); + Integer shopId = null; + Set<Long> userIds = null; + if(null != userId){ + userIds = new HashSet<>(); + userIds.add(userId); + } + if(data.getRoleType() == 2){ + shopId = data.getObjectId(); + if(null == userId){ + userIds = orderClient.getAppUserByShoppingShop(shopId).getData(); + }else{ + userIds = new HashSet<>(); + userIds.add(userId); + } + } + UserStatisticsDetail userStatisticsDetail = appUserMapper.getUserStatisticsDetail(shopId, userIds); return R.ok(userStatisticsDetail); } @@ -632,36 +814,98 @@ */ @GetMapping("/commissionDetail") @ApiOperation(value = "分佣统计", tags = "管理后台-首页统计") - public R<CommissionDetail> commissionDetail(BalanceChangeRecord balanceChangeRecord) { - List<AppUser> appUserList = Optional.ofNullable(appUserService.list()).orElse(Collections.emptyList()); - - if (appUserList.isEmpty()) { - return R.ok(new 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("开始时间不能大于结束时间"); } + + Map<String, Map<Integer, BigDecimal>> dailyVipCommissions = new TreeMap<>(); + getDatesBetween(cd.getStartTime(), cd.getEndTime()).forEach(date -> { + for (int i = 1; i < 8; i++){ + List<BalanceChangeRecord> list = balanceChangeRecordService.list(new LambdaQueryWrapper<BalanceChangeRecord>() + .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); + 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++){ + R<List<ShopBalanceStatement>> r = shopBalanceStatementClient.getShopBalanceStatementList2(i, 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); + } + } + }); + + 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; - 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); - BigDecimal serviceFee = Optional.ofNullable(appUser.getShopServiceFee()).orElse(BigDecimal.ZERO); - BigDecimal userCommission = Optional.ofNullable(appUser.getShopCommission()).orElse(BigDecimal.ZERO); - - totalCommission = totalCommission.add(distributionAmount); - totalServiceFee = totalServiceFee.add(serviceFee); - totalUserCommission = totalUserCommission.add(userCommission); - - 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); - } + if (data != null){ + totalServiceFee = data.get("serverGiveawayMoney"); + totalUserCommission = data.get("lowerLevelGiveawayMoney"); } CommissionDetail commissionDetail = new CommissionDetail(); @@ -669,13 +913,14 @@ 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)); + 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 -> { @@ -687,8 +932,15 @@ commissionDate.setDiamondCommission(dailyCommissions.getOrDefault(3, BigDecimal.ZERO)); commissionDate.setAgentCommission(dailyCommissions.getOrDefault(4, BigDecimal.ZERO)); commissionDate.setSuperAgentCommission(dailyCommissions.getOrDefault(5, BigDecimal.ZERO)); - commissionDate.setPartnerCommission(dailyCommissions.getOrDefault(6, 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()); @@ -699,6 +951,82 @@ } + /** + * 获取指定时间段内每一天的列表 + * + * @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()); + } + + + + /** + * 上传图片 + * @param file + * @return + */ + @PostMapping("/upload") + public String upload(MultipartFile file){ + String s = null; + try { + s = ObsUploadUtil.obsUpload(file); + } catch (IOException e) { + throw new RuntimeException(e); + } + return s; + } + + + /** + * 检查会员等级变更 + * @param appUserId + */ + @PostMapping("/vipUpgrade") + public void vipUpgrade(@RequestParam("appUserId") Long appUserId){ + appUserService.vipUpgrade(appUserId); + } + + + /** + * 检查会员降级 + * @param appUserId + */ + @PostMapping("/app-user/vipDemotion") + public void vipDemotion(@RequestParam("appUserId") Long appUserId){ + appUserService.vipDemotion(appUserId); + } + + + + /** + * 用户降级检测 + */ + @PostMapping("/demotionDetection") + public void demotionDetection(){ + appUserService.demotionDetection(); + } + + + /** + * 清空绑定门店的用户门店数据 + * @param shopId + * @return + */ + @PostMapping("/clearBindShop") + public R clearBindShop(@RequestParam("shopId") Integer shopId){ + appUserService.update(new LambdaUpdateWrapper<AppUser>().eq(AppUser::getShopId, shopId).set(AppUser::getShopId, null) + .set(AppUser::getUserType,1)); + return R.ok(); + } } -- Gitblit v1.7.1