From 3ec572e2cb7adf7d33d2018b24c003d9ef18906a Mon Sep 17 00:00:00 2001 From: 无关风月 <443237572@qq.com> Date: 星期二, 12 十一月 2024 13:32:51 +0800 Subject: [PATCH] 代码提交 --- xinquan-modules/xinquan-user/src/main/java/com/xinquan/user/controller/client/ClientAppUserController.java | 1302 ++++++++++++++++++++++++++++++++++++++++++++-------------- 1 files changed, 987 insertions(+), 315 deletions(-) diff --git a/xinquan-modules/xinquan-user/src/main/java/com/xinquan/user/controller/client/ClientAppUserController.java b/xinquan-modules/xinquan-user/src/main/java/com/xinquan/user/controller/client/ClientAppUserController.java index 5842e00..611c8fe 100644 --- a/xinquan-modules/xinquan-user/src/main/java/com/xinquan/user/controller/client/ClientAppUserController.java +++ b/xinquan-modules/xinquan-user/src/main/java/com/xinquan/user/controller/client/ClientAppUserController.java @@ -1,28 +1,45 @@ package com.xinquan.user.controller.client; +import cn.afterturn.easypoi.excel.ExcelExportUtil; +import cn.afterturn.easypoi.excel.entity.ExportParams; import com.alibaba.nacos.common.utils.StringUtils; 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.baomidou.mybatisplus.extension.plugins.pagination.Page; +import com.xinquan.common.core.constant.CacheConstants; import com.xinquan.common.core.domain.R; +import com.xinquan.common.core.exception.ServiceException; +import com.xinquan.common.core.utils.WebUtils; import com.xinquan.common.core.utils.page.BeanUtils; import com.xinquan.common.core.utils.page.CollUtils; import com.xinquan.common.core.utils.page.PageDTO; import com.xinquan.common.core.web.domain.BaseModel; +import com.xinquan.common.redis.service.RedisService; +import com.xinquan.common.security.service.TokenService; import com.xinquan.common.security.utils.SecurityUtils; import com.xinquan.course.api.domain.Course; import com.xinquan.course.api.domain.CourseCategory; import com.xinquan.course.api.domain.CourseDTO; +import com.xinquan.course.api.domain.OrderCourseVO; import com.xinquan.order.api.feign.RemoteOrderService; import com.xinquan.system.api.RemoteBannerService; import com.xinquan.system.api.RemoteUserService; import com.xinquan.system.api.domain.*; import com.xinquan.system.api.domain.vo.*; +import com.xinquan.system.api.feignClient.SysUserClient; +import com.xinquan.system.api.model.LoginUser; import com.xinquan.user.api.domain.dto.AppUserManagementDTO; +import com.xinquan.user.api.domain.dto.OrderListDTO; +import com.xinquan.user.api.domain.dto.UserChildDTO; import com.xinquan.user.api.domain.vo.FreezingVO; import com.xinquan.user.api.domain.vo.ViewReport; import com.xinquan.user.domain.dto.UserAnswerDTO; +import com.xinquan.user.domain.dto.UserFreezingDTO; +import com.xinquan.user.domain.export.UserExport; +import com.xinquan.user.domain.export.UserInfoExport; +import com.xinquan.user.domain.export.WithdrawExport; import com.xinquan.user.domain.vo.TagVO; import com.xinquan.user.service.*; import com.xinquan.user.utils.MailUtils; @@ -35,10 +52,14 @@ import java.io.*; import java.math.BigDecimal; import java.net.URL; +import java.net.URLEncoder; import java.text.SimpleDateFormat; import java.time.LocalDate; import java.time.LocalDateTime; +import java.time.Month; import java.time.format.DateTimeFormatter; +import java.time.temporal.ChronoUnit; +import java.time.temporal.TemporalAdjusters; import java.util.*; import java.util.stream.Collectors; @@ -47,6 +68,8 @@ import lombok.extern.slf4j.Slf4j; import org.apache.commons.compress.utils.IOUtils; import org.apache.poi.ss.formula.functions.T; +import org.apache.poi.ss.usermodel.Workbook; +import org.springframework.beans.factory.annotation.Autowired; import org.springframework.validation.annotation.Validated; import org.springframework.web.bind.annotation.*; @@ -58,6 +81,8 @@ import javax.mail.*; import javax.mail.internet.*; import javax.mail.util.ByteArrayDataSource; +import javax.servlet.ServletOutputStream; +import javax.servlet.http.HttpServletResponse; import static com.xinquan.common.core.enums.TreeLevelEnum.TOWERING_TREES; @@ -69,8 +94,6 @@ * @author mitao * @since 2024-08-21 */ -@Api(tags = {"用户相关接口"}) -@Slf4j @RestController @RequestMapping("/client/app-user") @RequiredArgsConstructor @@ -81,121 +104,255 @@ private AppUserViewingHistoryService appUserViewingHistoryService; @Resource private AppUserEnergyRecordService appUserEnergyRecordService; + @Resource + private AppUserTagService appUserTagService; + @Resource + private TagService tagService; @Resource private AppUserTreeService appUserTreeService; @Resource private AppUserQuestionService appUserQuestionService; - @Resource - private TagService tagService; + @Resource private RemoteBannerService remoteBannerService; @Resource private RemoteOrderService remoteOrderService; @Resource private RemoteUserService remoteUserService; - public static void main(String[] args) { - // 收件人电子邮箱,TODO 换成自己的收件箱 - String to = "443237572@qq.com"; - // 发件人电子邮箱,TODO 换成自己的发件箱 - String from = "13281306557@163.com"; - // 指定发送邮件的主机为 - String host = "smtp.163.com"; - Properties properties = new Properties(); - // 设置邮件服务器 - properties.setProperty("mail.smtp.host", host); - // 邮件发送协议 - properties.setProperty("mail.transport.protocol", "smtp"); - //是否启用调试模式(启用调试模式可打印客户端与服务器交互过程时一问一答的响应消息) - properties.setProperty("mail.debug","true"); - properties.setProperty("mail.smtp.auth", "true"); - // 获取默认session对象 - Session session = Session.getDefaultInstance(properties,new Authenticator(){ - @Override - public PasswordAuthentication getPasswordAuthentication() - { - //发件人邮件用户名、授权码,换成自己的发件箱及授权码 - return new PasswordAuthentication("13281306557@163.com", "NUSdxDQqadYvVek2"); + @Resource + private NoticeRecordService noticeRecordService; + @GetMapping("/deleteBalance/{id}/{amount}") + public R deleteBalance(@PathVariable("id")String id,@PathVariable("amount")String amount) { + AppUser byId = appUserService.getById(id); + if (byId!=null){ + BigDecimal subtract = byId.getBalance().subtract(new BigDecimal(amount)); + if (subtract.compareTo(BigDecimal.ZERO)<0){ + byId.setBalance(BigDecimal.ZERO); } - }); - - try{ - // 创建默认的 MimeMessage 对象 - MimeMessage message = new MimeMessage(session); - // Set From,设置发件人 - InternetAddress fromMail = new InternetAddress(from); - //设置发件人名称,TODO 换成自己的发件箱 - fromMail.setPersonal(MimeUtility.encodeText("明星电力<13281306557@163.com>")); - message.setFrom(fromMail); - // Set To: 设置收件人 - InternetAddress toMail = new InternetAddress(to); - // TODO 换成自己的收件箱 - InternetAddress toMail2 = new InternetAddress("443237572@qq.com"); - //发一个邮箱 -// message.setRecipient(Message.RecipientType.TO, toMail); - //发多个邮箱 - Address[] allRecipients = {toMail, toMail2}; - message.setRecipients(Message.RecipientType.TO, allRecipients); - // Set Subject: 邮件主体 - message.setSubject("明星电力"); - // 设置消息体 - message.setSentDate(new Date()); - // 指定为混合关系 - MimeMultipart msgMultipart = new MimeMultipart("mixed"); - message.setContent(msgMultipart); - // 邮件信息组装 - //组装的顺序非常重要,一定要先组装文本域,再组装文件 - MimeBodyPart htmlPart = new MimeBodyPart(); - // 组装内容 - htmlPart.setContent("This is message content", "text/html;charset=UTF-8"); - msgMultipart.addBodyPart(htmlPart); - // 组装附件 - MimeBodyPart filePart = new MimeBodyPart(); - String imageUrl = "https://xqgwzh.obs.cn-south-1.myhuaweicloud.com/xinquan/b176cf9af35d4773a276e55b7afe3b63.mp4"; - try { - // 下载数据 - URL url = new URL(imageUrl); - InputStream inputStream = url.openStream(); - byte[] imageBytes = IOUtils.toByteArray(inputStream); - // 创建临时文件 - // 截取imageUrl后缀名 - String fileExtension = imageUrl.substring(imageUrl.lastIndexOf(".")); - File tempFile = File.createTempFile("tempImage", fileExtension); - try (FileOutputStream fos = new FileOutputStream(tempFile)) { - fos.write(imageBytes); - } - // 创建 FileDataSource - FileDataSource fileDataSource = new FileDataSource(tempFile); - System.out.println("FileDataSource created: " + fileDataSource.getName()); - // 如果需要,可以使用 DataHandler 进行进一步处理 - DataHandler dh = new DataHandler(fileDataSource); - // 清理:删除临时文件(如果不再需要) - tempFile.deleteOnExit(); // 可根据需要保留或删除 -// DataHandler dh = new DataHandler(dataSource); - filePart.setDataHandler(dh); - // 附件区别内嵌内容的一个特点是有文件名,为防止中文乱码要编码 - filePart.setFileName(MimeUtility.encodeText(dh.getName())); - msgMultipart.addBodyPart(filePart); - - message.saveChanges(); - //发送 - //Transport.send(message, message.getAllRecipients()); - Transport.send(message); - System.out.println("Sent mail successfully...."); - } catch (Exception e) { - e.printStackTrace(); - } - //TODO 换成自己的附件地址 - - }catch (MessagingException | UnsupportedEncodingException mex) { - mex.printStackTrace(); - } catch (Exception e) { - throw new RuntimeException(e); } + return R.ok(); + } + @GetMapping("/testNotice") + @ApiOperation(value = "测试通知", tags = "测试通知") + public R testNotice() { + LocalDateTime now = LocalDateTime.now(); + List<AppUser> list = appUserService.lambdaQuery().ne(AppUser::getUserStatus, 3).list(); + for (AppUser appUser : list) { + if (appUser.getVipExpireTime()!=null && appUser.getVipExpireTime().isAfter(now)){ + // 计算两个now和time的天数差 + long between = Math.abs(ChronoUnit.DAYS.between(appUser.getVipExpireTime(), now)); + if (between<=7){ + NoticeRecord noticeRecord = new NoticeRecord(); + noticeRecord.setAppUserId(appUser.getId()); + noticeRecord.setReadStatus(1); + noticeRecord.setNoticeType(1); + noticeRecord.setTitle("【会员临期通知】"); + noticeRecord.setContent("尊敬的心泉疗愈会员你好,你的会员即将在" + +appUser.getVipExpireTime().toLocalDate()+"到期,到期后将不再享受会员权益,请及时续费"); + noticeRecordService.save(noticeRecord); + } + } + AppUserTree one = appUserTreeService.lambdaQuery().eq(AppUserTree::getAppUserId, appUser.getId()) + .eq(AppUserTree::getSowAgain, 2).one(); + if(one!=null && (one.getTaskOne()==2||one.getTaskTwo()==2)){ + NoticeRecord noticeRecord = new NoticeRecord(); + noticeRecord.setAppUserId(appUser.getId()); + noticeRecord.setReadStatus(1); + noticeRecord.setNoticeType(1); + noticeRecord.setTitle("【冥想通知】"); + noticeRecord.setContent("你今天的冥想任务还未完成,完成冥想后可获得能量值奖励,快去冥想吧!"); + noticeRecordService.save(noticeRecord); + } + } + return R.ok(); } + + + @GetMapping("/getUserByPhone/{phone}") + public R<AppUser> getUserByPhone(@PathVariable("phone")String phone) { + AppUser one = appUserService.lambdaQuery().eq(AppUser::getCellPhone, phone).ne(AppUser::getUserStatus, 3) + .one(); + return R.ok(one); + } + @GetMapping("/getAllUserList") + public R<List<AppUser>> getAllUserList() { + List<AppUser> list = appUserService.list(); + return R.ok(list); + } + @PostMapping("/bindVx") + @ApiOperation(value = "绑定微信号", tags = "个人中心") + public R bindVx(String openId,String wxName) { + LoginUser loginUser = tokenService.getLoginUser(); + if (loginUser==null){ + return R.tokenError("登录失效"); + } + AppUser byId = appUserService.getById(loginUser.getUserid()); + AppUser one = appUserService.lambdaQuery().eq(AppUser::getWxOpenId, openId) + .isNotNull(AppUser::getCellPhone) + .ne(AppUser::getUserStatus, 3).one(); + if (one!=null){ + return R.fail("当前微信号已绑定其他账号"); + } + byId.setWxOpenId(openId); + byId.setWxName(wxName); + appUserService.updateById(byId); + return R.ok(); + } + public static void main(String[] args) { + // 获取当前年份 + int currentYear = LocalDate.now().getYear(); + // 定义日期时间格式 + DateTimeFormatter formatter = DateTimeFormatter.ofPattern("yyyy-MM-dd HH:mm:ss"); + // 获取1月份的第一天 + LocalDate firstDayOfMonth = LocalDate.of(currentYear, 2, 1); + LocalDateTime firstDayOfMonthDateTime = firstDayOfMonth.atStartOfDay(); + + // 获取1月份的最后一天 + LocalDate lastDayOfMonth = LocalDate.of(currentYear, 2, 12).with(TemporalAdjusters.lastDayOfMonth()); + LocalDateTime lastDayOfMonthDateTime = lastDayOfMonth.atTime(23, 59, 59); + + + + // 格式化日期时间 + String firstDayOfMonthString = firstDayOfMonthDateTime.format(formatter); + String lastDayOfMonthString = lastDayOfMonthDateTime.format(formatter); + + System.out.println("1月份的第一天: " + firstDayOfMonthString); + System.out.println("1月份的最后一天: " + lastDayOfMonthString); + } + @GetMapping("/addVipExpireTime/{id}/{type}") + public R addVipExpireTime(@PathVariable("id")Long id,@PathVariable("type")Integer type) { + AppUser byId = appUserService.getById(id); + byId.setVipLevel(type); + switch (type){ + case 1: + if (byId.getVipExpireTime()!=null&&byId.getVipExpireTime().isAfter(LocalDateTime.now())){ + byId.setVipExpireTime(byId.getVipExpireTime().plusDays(30)); + }else{ + byId.setVipExpireTime(LocalDateTime.now().plusDays(30)); + } + break; + case 2: + if (byId.getVipExpireTime()!=null&&byId.getVipExpireTime().isAfter(LocalDateTime.now())){ + byId.setVipExpireTime(byId.getVipExpireTime().plusDays(90)); + }else{ + byId.setVipExpireTime(LocalDateTime.now().plusDays(90)); + } + break; + case 3: + if (byId.getVipExpireTime()!=null&&byId.getVipExpireTime().isAfter(LocalDateTime.now())){ + byId.setVipExpireTime(byId.getVipExpireTime().plusDays(365)); + }else{ + byId.setVipExpireTime(LocalDateTime.now().plusDays(365)); + } + break; + } + appUserService.updateById(byId); + return R.ok(); + } + @GetMapping("/addBalance/{id}/{money}") + public R addBalance(@PathVariable("id")Long id,@PathVariable("money")BigDecimal money) { + AppUser byId = appUserService.getById(id); + byId.setBalance(byId.getBalance().add(money)); + appUserService.updateById(byId); + return R.ok(); + } + /** + * 远程调用 获取用户总数上升趋势 + */ + @ApiOperation(value = "首页统计测试接口", tags = "首页统计测试接口") + @PostMapping("/getUserListCount") + public R<Map<String,Object>> getUserListCount() { + Map<String, Object> res = new HashMap<>(); + // 获取当前年份 + int currentYear = LocalDate.now().getYear(); + // 定义日期时间格式 + DateTimeFormatter formatter = DateTimeFormatter.ofPattern("yyyy-MM-dd HH:mm:ss"); + for (int i = 1; i <= 12; i++) { + // 获取1月份的第一天 + LocalDate firstDayOfMonth = LocalDate.of(currentYear, i, 1); + LocalDateTime firstDayOfMonthDateTime = firstDayOfMonth.atStartOfDay(); + // 获取1月份的最后一天 + LocalDate lastDayOfMonth = LocalDate.of(currentYear, i, 12).with(TemporalAdjusters.lastDayOfMonth()); + LocalDateTime lastDayOfMonthDateTime = lastDayOfMonth.atTime(23, 59, 59); + // 格式化日期时间 + String firstDayOfMonthString = firstDayOfMonthDateTime.format(formatter); + String lastDayOfMonthString = lastDayOfMonthDateTime.format(formatter); + List<AppUser> list = appUserService.lambdaQuery().eq(BaseModel::getDelFlag, 0) + .ne(AppUser::getUserStatus, 3) + .between(BaseModel::getCreateTime, firstDayOfMonthString, lastDayOfMonthString) + .list(); + + res.put(i+"月",list.size()); + } + // 定义月份的排序顺序 + List<String> monthsOrder = Arrays.asList("1月", "2月", "3月", "4月", "5月", + "6月", "7月", "8月", "9月", + "10月", "11月", "12月"); + + // 创建一个 LinkedHashMap 来保持插入顺序 + Map<String, Object> sortedData = new LinkedHashMap<>(); + + // 按照定义的顺序将数据放入 LinkedHashMap + for (String month : monthsOrder) { + if (res.containsKey(month)) { + sortedData.put(month, res.get(month)); + } + } + return R.ok(sortedData); + } + + /** + * 远程调用 获取用户总数 非会员数 会员数 + * @return + */ + @PostMapping("/getUserCount") + public R<String> getUserCount() { + StringBuilder stringBuilder = new StringBuilder(); + List<AppUser> list = appUserService.lambdaQuery() + .eq(BaseModel::getDelFlag, 0) + .ne(AppUser::getUserStatus, 3).list(); + stringBuilder.append(list.size()).append(","); + List<AppUser> memberList = list.stream().filter(appUser -> + appUser.getVipExpireTime() == null || + appUser.getVipExpireTime() + .isBefore(LocalDateTime.now())).collect(Collectors.toList()); + int month=0; + int quarter=0; + int year=0; + // 获取当前时间的单例 + LocalDateTime now = LocalDateTime.now(); + stringBuilder.append(memberList.size()).append(","); + for (AppUser appUser : list) { + if (appUser.getVipExpireTime()!=null){ + if (appUser.getVipExpireTime().isAfter(now)){ + if (appUser.getVipLevel()!=null){ + switch (appUser.getVipLevel()){ + case 1: + month++; + break; + case 2: + quarter++; + break; + case 3: + year++; + break; + } + } + } + } + } + stringBuilder.append(month).append(","); + stringBuilder.append(quarter).append(","); + stringBuilder.append(year); + return R.ok(stringBuilder.toString()); + } + + @PostMapping("/userDetail") - @ApiOperation(value = "用户详情-基础信息", notes = "管理后台-用户管理") + @ApiOperation(value = "用户详情-基础信息", tags = "管理后台-用户管理") public R userDetail(String uid) { AppUser byId = appUserService.getById(uid); // 判断是不是会员 @@ -206,23 +363,11 @@ }else{ byId.setIsVip(1); } - List<AppUserTree> list1 = appUserTreeService.lambdaQuery().eq(AppUserTree::getAppUserId, byId.getId()) - .list(); - // 查询用户等级最高的那颗树苗 - AppUserTree tree = list1.stream().max((o1, o2) -> { - if (o1.getTreeLevelType() > o2.getTreeLevelType()) { - return 1; - } else if (o1.getTreeLevelType() < o2.getTreeLevelType()) { - return -1; - } else { - return 0; - } - }).orElse(null); + AppUserTree list1 = appUserTreeService.lambdaQuery().eq(AppUserTree::getAppUserId, uid) + .eq(AppUserTree::getSowAgain,2) + .one(); // 查询疗愈等级 名称 图标 - int level = 1; - if (tree != null){ - level = tree.getTreeLevelType(); - } + int level = list1.getTreeLevelType(); // 根据等级查询疗愈名称和图标 UserLevelSetting data = remoteBannerService.getIconNameByLevel(level).getData(); byId.setLevel(level); @@ -238,49 +383,58 @@ return R.ok(); } @GetMapping("/viewReport") - @ApiOperation(value = "用户详情-查看报告", notes = "管理后台-用户管理") + @ApiOperation(value = "用户详情-查看报告", tags = "管理后台-用户管理") public R<ViewReport> viewReport(String uid) { ViewReport viewReport = new ViewReport(); String tagId = appUserService.getById(uid).getTagId(); - List<AppUserQuestion> list = appUserQuestionService.lambdaQuery().eq(AppUserQuestion::getAppUserId, uid).list(); - List<Tag> list1 = tagService.lambdaQuery().list(); - String[] split = tagId.split(","); - List<String> list2 = Arrays.asList(split); - if (!list2.isEmpty()){ - for (Tag tag : list1) { - if (list2.contains(tag.getId().toString())){ - tag.setIsCheck(1); + List<AppUserQuestion> appUserQuestions = new ArrayList<>(); + List<AppUserQuestion> list = appUserQuestionService.lambdaQuery().eq(AppUserQuestion::getAppUserId, uid).orderByAsc(AppUserQuestion::getType).list(); + for (int i = 0; i < 6; i++) { + AppUserQuestion appUserQuestion = new AppUserQuestion(); + appUserQuestion.setType(i+1); + if (!list.isEmpty()){ + appUserQuestion.setAnswer(list.get(i)!=null?list.get(i).getAnswer():""); + }else{ + appUserQuestion.setAnswer(null); + } + appUserQuestions.add(appUserQuestion); + } + List<Tag> list1 = tagService.lambdaQuery().eq(Tag::getTagType,2).list(); + if (org.springframework.util.StringUtils.hasLength(tagId)){ + String[] split = tagId.split(","); + List<String> list2 = Arrays.asList(split); + if (!list2.isEmpty()){ + for (Tag tag : list1) { + if (list2.contains(tag.getId().toString())){ + tag.setIsCheck(1); + } } } }else{ for (Tag tag : list1) { - tag.setIsCheck(2); + tag.setIsCheck(2); } } - viewReport.setQuestions(list); + viewReport.setQuestions(appUserQuestions); viewReport.setTags(list1); return R.ok(viewReport); } - @GetMapping("/freezing") - @ApiOperation(value = "冻结用户", notes = "管理后台-用户管理") - @ApiImplicitParams({ - @ApiImplicitParam(name = "uid", value = "uid", dataType = "String", required = true), - @ApiImplicitParam(name = "freezingReason", value = "冻结原因", dataType = "String", required = true), - }) - public R freezingDetail(String uid,String freezingReason) { - AppUser byId = appUserService.getById(uid); + @Autowired + private TokenService tokenService; + @PostMapping("/freezing") + @ApiOperation(value = "冻结用户", tags = "管理后台-用户管理") + + public R freezingDetail(@RequestBody UserFreezingDTO dto) { + AppUser byId = appUserService.getById(dto.getUid()); byId.setFreezingTime(LocalDateTime.now()); - byId.setFreezingReason(freezingReason); + byId.setFreezingReason(dto.getFreezingReason()); byId.setUserStatus(2); - byId.setFreezingOperator(SecurityUtils.getUserId()+""); + byId.setFreezingOperator(tokenService.getLoginUser().getUserid()+""); appUserService.updateById(byId); return R.ok(); } @GetMapping("/detail") - @ApiOperation(value = "用户详情", notes = "管理后台-用户管理") - @ApiImplicitParams({ - @ApiImplicitParam(name = "uid", value = "uid", dataType = "String", required = true), - }) + @ApiOperation(value = "用户详情", tags = "管理后台-用户管理") public R<AppUser> detail(String uid) { AppUser byId = appUserService.getById(uid); List<AppUserTree> list1 = appUserTreeService.lambdaQuery().eq(AppUserTree::getAppUserId, byId.getId()) @@ -307,11 +461,16 @@ byId.setLevelName(data.getLevelName()); byId.setLevelIcon(data.getLevelIcon()); } - - return R.ok(); + if (org.springframework.util.StringUtils.hasLength(byId.getTagId())){ + List<String> list = Arrays.asList(byId.getTagId().split(",")); + List<String> collect = tagService.lambdaQuery().in(Tag::getId, list).list().stream() + .map(Tag::getTagName).collect(Collectors.toList()); + byId.setTags(collect); + } + return R.ok(byId); } @GetMapping("/unFreezing") - @ApiOperation(value = "解冻用户", notes = "管理后台-用户管理") + @ApiOperation(value = "解冻用户", tags = "管理后台-用户管理") public R unFreezing(String uid) { AppUser byId = appUserService.getById(uid); byId.setUserStatus(1); @@ -319,7 +478,7 @@ return R.ok(byId.getFreezingReason()); } @GetMapping("/setSanskritFlag") - @ApiOperation(value = "设置梵文权限", notes = "管理后台-用户管理") + @ApiOperation(value = "设置梵文权限", tags = "管理后台-用户管理") @ApiImplicitParams({ @ApiImplicitParam(name = "uid", value = "用户uid 多个逗号拼接", dataType = "String", required = true), @ApiImplicitParam(name = "setSanskritFlag", value = "梵文权限 1是2否", dataType = "int", required = true), @@ -334,15 +493,21 @@ return R.ok(); } @GetMapping("/setTotalEnergyValue") - @ApiOperation(value = "能量值修改", notes = "管理后台-用户管理") + @ApiOperation(value = "能量值修改", tags = "管理后台-用户管理") @ApiImplicitParams({ - @ApiImplicitParam(name = "uid", value = "用户uid 多个逗号拼接", dataType = "String", required = true), + @ApiImplicitParam(name = "uid", value = "用户uid", dataType = "String", required = true), @ApiImplicitParam(name = "energyValue", value = "能量值", dataType = "int", required = true), - @ApiImplicitParam(name = "reason", value = "备注", dataType = "int", required = true), + @ApiImplicitParam(name = "reason", value = "备注", dataType = "String", required = true) }) - public R setTotalEnergyValue(String uid,Integer energyValue,String remark) { + public R setTotalEnergyValue(String uid,Integer energyValue,String reason) { AppUser byId = appUserService.getById(uid); + if (energyValue<0){ + if (byId.getTotalEnergyValue()<Math.abs(energyValue)){ + return R.fail("扣除能量值应小于当前能量值"); + } + } byId.setTotalEnergyValue(byId.getTotalEnergyValue()+energyValue); + byId.setEnergyValue(byId.getEnergyValue()+energyValue); appUserService.updateById(byId); AppUserEnergyRecord appUserEnergyRecord = new AppUserEnergyRecord(); appUserEnergyRecord.setAppUserId(byId.getId()); @@ -353,66 +518,69 @@ appUserEnergyRecord.setChangeType(1); appUserEnergyRecord.setEnergyValue(energyValue); } - appUserEnergyRecord.setReason(remark); + appUserEnergyRecord.setUpdateId(tokenService.getLoginUser().getUserid()); + appUserEnergyRecord.setReason(reason); appUserEnergyRecord.setCreateBy(SecurityUtils.getUsername()); appUserEnergyRecord.setCreateTime(LocalDateTime.now()); appUserEnergyRecordService.save(appUserEnergyRecord); return R.ok(); } + + @GetMapping("/setVip") - @ApiOperation(value = "设置会员", notes = "管理后台-用户管理") + @ApiOperation(value = "设置会员", tags = "管理后台-用户管理") @ApiImplicitParams({ @ApiImplicitParam(name = "uid", value = "uid", dataType = "String", required = true), @ApiImplicitParam(name = "vipType", value = "会员类型 1非 2月 3季 4年", dataType = "Integer", required = true), + @ApiImplicitParam(name = "vipExpireTime", value = "会员到期时间 yyyy-MM-dd HH:mm", dataType = "String", required = true), }) - public R setVip(String uid, Integer vipType) { + public R setVip(String uid, Integer vipType,String vipExpireTime) { + // 将其转化为LocalDateTime格式 + LocalDateTime parse = LocalDateTime.parse(vipExpireTime, DateTimeFormatter.ofPattern("yyyy-MM-dd HH:mm:ss")); LambdaUpdateWrapper<AppUser> appUserLambdaUpdateWrapper = new LambdaUpdateWrapper<>(); AppUser byId = appUserService.getById(uid); switch (vipType){ case 1: - appUserLambdaUpdateWrapper.set(AppUser::getVipExpireTime,null); - appUserLambdaUpdateWrapper.set(AppUser::getVipLevel,null); - appUserService.update(appUserLambdaUpdateWrapper); + byId.setVipExpireTime(null); + byId.setVipLevel(null); + appUserService.updateById(byId); break; case 2: - if (byId.getVipExpireTime() == null){ byId.setVipLevel(1); - byId.setVipExpireTime(LocalDateTime.now().plusDays(30)); + byId.setVipExpireTime(parse); }else if (byId.getVipExpireTime().isAfter(LocalDateTime.now())){ - - - byId.setVipExpireTime(byId.getVipExpireTime().plusDays(30)); + byId.setVipExpireTime(parse); }else{ - byId.setVipExpireTime(LocalDateTime.now().plusDays(30)); + byId.setVipExpireTime(parse); } break; case 3: if (byId.getVipExpireTime() == null){ byId.setVipLevel(2); - byId.setVipExpireTime(LocalDateTime.now().plusMonths(90)); + byId.setVipExpireTime(parse); }else if (byId.getVipExpireTime().isAfter(LocalDateTime.now())){ // 如果当前用户的会员等级大于设置的会员等级那么不管 if (byId.getVipLevel()<2){ byId.setVipLevel(2); } - byId.setVipExpireTime(byId.getVipExpireTime().plusDays(90)); + byId.setVipExpireTime(parse); }else{ if (byId.getVipLevel()<2){ byId.setVipLevel(2); } - byId.setVipExpireTime(LocalDateTime.now().plusDays(90)); + byId.setVipExpireTime(parse); } break; case 4: byId.setVipLevel(3); if (byId.getVipExpireTime() == null){ - byId.setVipExpireTime(LocalDateTime.now().plusMonths(365)); + byId.setVipExpireTime(parse); }else if (byId.getVipExpireTime().isAfter(LocalDateTime.now())){ - byId.setVipExpireTime(byId.getVipExpireTime().plusDays(365)); + byId.setVipExpireTime(parse); }else{ - byId.setVipExpireTime(LocalDateTime.now().plusDays(365)); + byId.setVipExpireTime(parse); } break; } @@ -420,7 +588,7 @@ return R.ok(); } @GetMapping("/freezingDetail") - @ApiOperation(value = "冻结详情", notes = "管理后台-用户管理") + @ApiOperation(value = "冻结详情", tags = "管理后台-用户管理") public R<FreezingVO> freezingDetail(String uid) { AppUser byId = appUserService.getById(uid); SimpleDateFormat simpleDateFormat = new SimpleDateFormat("yyyy-MM-dd HH:mm:ss"); @@ -432,9 +600,77 @@ freezingVO.setFreezingOperator(data.getNickName()+"("+data.getUserName()+")"); return R.ok(freezingVO); } - @PostMapping("/userManagementList") - @ApiOperation(value = "用户管理列表-分页", tags = {"管理后台-用户管理"}) - public R<PageDTO<AppUser>> userManagementList(@RequestBody AppUserManagementDTO courseDTO) { + @ApiOperation(value = "用户列表-下级用户管理导出", tags = {"管理后台-用户管理"}) + @PutMapping("/exportUser") + public void export(@RequestBody UserChildDTO dto) + { + String startTime = null; + String endTime = null; + if (org.springframework.util.StringUtils.hasLength(dto.getTime())){ + String[] split = dto.getTime().split(" - "); + startTime = split[0]+"00:00:00"; + endTime = split[1]+"23:59:59"; + } + String userId = dto.getUid(); + LambdaQueryWrapper<AppUser> appUserWalletRecordLambdaQueryWrapper = new LambdaQueryWrapper<>(); + appUserWalletRecordLambdaQueryWrapper.between(startTime!=null,BaseModel::getCreateTime,startTime,endTime); + appUserWalletRecordLambdaQueryWrapper.eq(AppUser::getInviteUserId, userId); + appUserWalletRecordLambdaQueryWrapper.like(org.springframework.util.StringUtils.hasLength(dto.getCellPhone()),AppUser::getCellPhone,dto.getCellPhone()); + appUserWalletRecordLambdaQueryWrapper.like(org.springframework.util.StringUtils.hasLength(dto.getNickName()),AppUser::getNickname,dto.getNickName()); + appUserWalletRecordLambdaQueryWrapper.orderByDesc(BaseModel::getCreateTime); + List<AppUser> page = appUserService + .list(appUserWalletRecordLambdaQueryWrapper); + List<UserInfoExport> userInfoExports = new ArrayList<>(); + + for (AppUser record : page) { + // 查询该用户带来收益 + List<AppUserWalletRecord> list = appUserWalletRecordService.lambdaQuery().eq(AppUserWalletRecord::getAppUserId, record.getId()) + .eq(AppUserWalletRecord::getChildAppUserId, record.getUserId()).list(); + BigDecimal bigDecimal = new BigDecimal("0"); + for (AppUserWalletRecord appUserWalletRecord : list) { + if (appUserWalletRecord.getAmount()!=null && appUserWalletRecord.getChangeType() == 1){ + bigDecimal = bigDecimal.add(appUserWalletRecord.getAmount()); + } + record.setMoney(bigDecimal); + } + UserInfoExport userInfoExport = new UserInfoExport(); + userInfoExport.setCode(record.getCode()); + userInfoExport.setUserName(record.getNickname()); + userInfoExport.setCellphone(record.getCellPhone()); + userInfoExport.setIncome("¥"+record.getMoney()); + DateTimeFormatter df = DateTimeFormatter.ofPattern("yyyy-MM-dd HH:mm:ss"); + String format = df.format(record.getInviteUserTime()); + userInfoExport.setInviteUserTime(format); + userInfoExport.setUserStatus(record.getUserStatus()+""); + userInfoExports.add(userInfoExport); + } + Workbook workbook = ExcelExportUtil.exportExcel(new ExportParams(), UserInfoExport.class, userInfoExports); + HttpServletResponse response = WebUtils.response(); + response.setContentType("application/vnd.ms-excel"); + response.setCharacterEncoding("utf-8"); + ServletOutputStream outputStream = null; + try { + String fileName = URLEncoder.encode("用户管理导出.xls", "utf-8"); + response.setHeader("Content-Disposition", "attachment;filename=" + fileName); + response.setContentType("application/vnd.ms-excel;charset=UTF-8"); + response.setHeader("Pragma", "no-cache"); + response.setHeader("Cache-Control", "no-cache"); + outputStream = response.getOutputStream(); + workbook.write(outputStream); + } catch (IOException e) { + e.printStackTrace(); + } finally { + try { + outputStream.close(); + } catch (IOException e) { + e.printStackTrace(); + } + } + } + @ApiOperation(value = "用户列表管理导出", tags = {"管理后台-用户管理"}) + @PutMapping("/export") + public void export(@RequestBody AppUserManagementDTO courseDTO) + { String startTime = null; String endTime = null; if (org.springframework.util.StringUtils.hasLength(courseDTO.getVipExpireTime())){ @@ -456,7 +692,6 @@ .like(StringUtils.isNotBlank(courseDTO.getCellPhone()), AppUser::getCellPhone, courseDTO.getCellPhone()) .eq(Objects.nonNull(courseDTO.getGender()), AppUser::getGender, courseDTO.getGender()) .eq(Objects.nonNull(courseDTO.getUserStatus()), AppUser::getUserStatus, courseDTO.getUserStatus()) - .isNotNull(AppUser::getVipExpireTime) .between(Objects.nonNull(startTime),AppUser::getVipExpireTime,startTime,endTime) .between(Objects.nonNull(startTime1),AppUser::getRegisterTime,startTime1,endTime1) .orderByDesc(AppUser::getRegisterTime); @@ -510,11 +745,233 @@ } courseLambdaQueryWrapper.in(AppUser::getId, collect); } + List<AppUser> page = appUserService.list(courseLambdaQueryWrapper); + List<UserExport> userExports = new ArrayList<>(); + for (AppUser record : page) { + record.setUid(record.getId()+""); + // 判断是不是会员 + if (record.getVipExpireTime() == null){ + record.setIsVip(2); + }else if (record.getVipExpireTime().isBefore(LocalDateTime.now())){ + record.setIsVip(2); + }else{ + record.setIsVip(1); + } + List<AppUserTree> list1 = appUserTreeService.lambdaQuery().eq(AppUserTree::getAppUserId, record.getId()) + .list(); + // 查询用户等级最高的那颗树苗 + AppUserTree tree = list1.stream().max((o1, o2) -> { + if (o1.getTreeLevelType() > o2.getTreeLevelType()) { + return 1; + } else if (o1.getTreeLevelType() < o2.getTreeLevelType()) { + return -1; + } else { + return 0; + } + }).orElse(null); + // 查询疗愈等级 名称 图标 + int level = 1; + if (tree != null){ + level = tree.getTreeLevelType(); + } + // 根据等级查询疗愈名称和图标 + UserLevelSetting data = remoteBannerService.getIconNameByLevel(level).getData(); + record.setLevel(level); + record.setLevelIcon(data.getLevelIcon()); + record.setLevelName(data.getLevelName()); + record.setUid(record.getId().toString()); + UserExport userExport = new UserExport(); + userExport.setCode(record.getCode()); + userExport.setUserName(record.getNickname()); + userExport.setRealname(record.getRealname()); + userExport.setCellphone(record.getCellPhone()); + userExport.setGender(record.getGender()+""); + userExport.setBirthday(record.getBirthday()); + userExport.setEducation(record.getEducation()); + userExport.setLocation(record.getLocation()); + userExport.setHometown(record.getHometown()); + userExport.setEmail(record.getEmail()); + userExport.setIndustry(record.getIndustry()); + userExport.setCompany(record.getCompany()); + userExport.setOccupation(record.getOccupation()); + if (record.getVipExpireTime()!=null){ + if (record.getVipExpireTime().isAfter(LocalDateTime.now())){ + userExport.setIsVip(1+""); + }else{ + userExport.setIsVip(2+""); + } + }else{ + userExport.setIsVip(2+""); + + } + userExport.setMeditationLevel(record.getLevelName()); + userExport.setTotalEnergyValue(record.getTotalEnergyValue()+""); + userExport.setBalance(record.getBalance()+""); + DateTimeFormatter df = DateTimeFormatter.ofPattern("yyyy-MM-dd HH:mm:ss"); + String format = df.format(record.getRegisterTime()); + userExport.setRegisterTime(format); + userExport.setUserStatus(record.getUserStatus()+""); + List<AppUserQuestion> list = appUserQuestionService.lambdaQuery() + .eq(AppUserQuestion::getAppUserId, record.getId()).list(); + for (AppUserQuestion appUserQuestion : list) { + switch (appUserQuestion.getType()){ + case 1: + userExport.setType1(appUserQuestion.getAnswer()); + break; + case 2: + userExport.setType2(appUserQuestion.getAnswer()); + break; + case 3: + userExport.setType3(appUserQuestion.getAnswer()); + break; + case 4: + userExport.setType4(appUserQuestion.getAnswer()); + break; + case 5: + userExport.setType5(appUserQuestion.getAnswer()); + break; + case 6: + userExport.setType6(appUserQuestion.getAnswer()); + break; + } + } + List<Integer> collect = appUserTagService.lambdaQuery() + .eq(AppUserTag::getAppUserId, record.getId()).list().stream() + .map(AppUserTag::getTagId) + .collect(Collectors.toList()); + if (collect.isEmpty()){ + collect.add(-1); + } + List<Tag> list2 = tagService.lambdaQuery().in(Tag::getId, collect).list(); + StringBuilder stringBuilder = new StringBuilder(); + for (Tag tag : list2) { + stringBuilder.append(tag.getTagName()).append(";"); + } + userExport.setType7(stringBuilder+""); + userExport.setSanskritFlag(record.getSanskritFlag()+""); + int size = appUserService.lambdaQuery().eq(AppUser::getInviteUserId, record.getId()).list() + .size(); + userExport.setUserCount(size+""); + userExports.add(userExport); + } + Workbook workbook = ExcelExportUtil.exportExcel(new ExportParams(), UserExport.class, userExports); + HttpServletResponse response = WebUtils.response(); + response.setContentType("application/vnd.ms-excel"); + response.setCharacterEncoding("utf-8"); + ServletOutputStream outputStream = null; + try { + String fileName = URLEncoder.encode("用户管理导出.xls", "utf-8"); + response.setHeader("Content-Disposition", "attachment;filename=" + fileName); + response.setContentType("application/vnd.ms-excel;charset=UTF-8"); + response.setHeader("Pragma", "no-cache"); + response.setHeader("Cache-Control", "no-cache"); + outputStream = response.getOutputStream(); + workbook.write(outputStream); + } catch (IOException e) { + e.printStackTrace(); + } finally { + try { + outputStream.close(); + } catch (IOException e) { + e.printStackTrace(); + } + } + } + @PostMapping("/userManagementList") + @ApiOperation(value = "用户管理列表-分页", tags = {"管理后台-用户管理"}) + public R<PageDTO<AppUser>> userManagementList(@RequestBody AppUserManagementDTO courseDTO) { + String startTime = null; + String endTime = null; + if (org.springframework.util.StringUtils.hasLength(courseDTO.getVipExpireTime())){ + String[] split = courseDTO.getVipExpireTime().split(" - "); + startTime = split[0]+"00:00:00"; + endTime = split[1]+"23:59:59"; + } + String startTime1 = null; + String endTime1 = null; + if (org.springframework.util.StringUtils.hasLength(courseDTO.getRegisterTime())){ + String[] split = courseDTO.getRegisterTime().split(" - "); + startTime1 = split[0]+"00:00:00"; + endTime1 = split[1]+"23:59:59"; + } + List<Long> longs = new ArrayList<>(); + LambdaQueryWrapper<AppUser> courseLambdaQueryWrapper = new LambdaQueryWrapper<>(); + courseLambdaQueryWrapper + .like(StringUtils.isNotBlank(courseDTO.getNickname()), AppUser::getNickname, courseDTO.getNickname()) + .like(StringUtils.isNotBlank(courseDTO.getCellPhone()), AppUser::getCellPhone, courseDTO.getCellPhone()) + .eq(Objects.nonNull(courseDTO.getGender()), AppUser::getGender, courseDTO.getGender()) + .eq(Objects.nonNull(courseDTO.getUserStatus()), AppUser::getUserStatus, courseDTO.getUserStatus()) + .between(Objects.nonNull(startTime),AppUser::getVipExpireTime,startTime,endTime) + .between(Objects.nonNull(startTime1),AppUser::getRegisterTime,startTime1,endTime1) + .orderByDesc(AppUser::getRegisterTime); + if (org.springframework.util.StringUtils.hasLength(courseDTO.getVipType())){ + String[] split = courseDTO.getVipType().split(","); + List<Integer> objects = new ArrayList<>(); + for (String s : split) { + objects.add(Integer.parseInt(s)-1); + } + List<AppUser> appUsers = new ArrayList<>(); + List<AppUser> list = appUserService.lambdaQuery().list(); + for (AppUser appUser : list) { + if (objects.contains(0)){ + if (appUser.getVipExpireTime()==null){ + appUsers.add(appUser); + }else if (appUser.getVipExpireTime().isBefore(LocalDateTime.now())){ + appUsers.add(appUser); + } + } + if (objects.contains(1)){ + if (appUser.getVipExpireTime()!=null&&appUser.getVipExpireTime().isAfter(LocalDateTime.now())&&appUser.getVipLevel()==1){ + appUsers.add(appUser); + } + } + if (objects.contains(2)){ + if (appUser.getVipExpireTime()!=null&&appUser.getVipExpireTime().isAfter(LocalDateTime.now())&&appUser.getVipLevel()==2){ + appUsers.add(appUser); + } + } + if (objects.contains(3)){ + if (appUser.getVipExpireTime()!=null&&appUser.getVipExpireTime().isAfter(LocalDateTime.now())&&appUser.getVipLevel()==3){ + appUsers.add(appUser); + } + } + } + List<Long> collect = appUsers.stream().distinct().map(AppUser::getId).collect(Collectors.toList()); + if (collect.isEmpty()){ + collect.add(-1L); + } + courseLambdaQueryWrapper.in(AppUser::getId, collect); + } + if (org.springframework.util.StringUtils.hasLength(courseDTO.getLevel())){ + List<String> list2 = Arrays.asList(courseDTO.getLevel().split(",")); + List<AppUser> list = appUserService.lambdaQuery().list(); + List<AppUser> appUsers = new ArrayList<>(); + for (AppUser appUser : list) { + AppUserTree list1 = appUserTreeService.lambdaQuery().eq(AppUserTree::getAppUserId, appUser.getId()) + .eq(AppUserTree::getSowAgain,2) + .one(); + // 查询疗愈等级 名称 图标 + int level = 1; + if (list1 != null){ + level = list1.getTreeLevelType(); + } + if (list2.contains(level+"")){ + appUsers.add(appUser); + } + } + List<Long> collect = appUsers.stream().map(AppUser::getId).collect(Collectors.toList()); + if (collect.isEmpty()){ + collect.add(-1L); + } + courseLambdaQueryWrapper.in(AppUser::getId, collect); + } + courseLambdaQueryWrapper.isNotNull(AppUser::getCellPhone); Page<AppUser> page = appUserService.page(new Page<>(courseDTO.getPageCurr(), courseDTO.getPageSize()), courseLambdaQueryWrapper); if (CollUtils.isEmpty(page.getRecords())) { return R.ok(PageDTO.empty(page)); } for (AppUser record : page.getRecords()) { + record.setUid(record.getId()+""); // 判断是不是会员 if (record.getVipExpireTime() == null){ record.setIsVip(2); @@ -577,29 +1034,88 @@ @PostMapping("/changePhone") @ApiOperation(value = "更换绑定手机号", tags = {"设置"}) public R changePhone(String phone,String code) { - Long userId = SecurityUtils.getUserId(); - if (userId == 0)return R.tokenError("登录失效"); - + LoginUser loginUser = tokenService.getLoginUser(); + if (loginUser==null){ + return R.tokenError("登录失效"); + } + Long userId = loginUser.getUserid(); + // 校验验证码 + if (!verifyCaptcha(phone, code, + CacheConstants.APP_CHANGE_PHONE_CODE_PREFIX)) { + throw new ServiceException("验证码不正确"); + } + AppUser byId = appUserService.getById(userId); + AppUser one = appUserService.lambdaQuery().eq(AppUser::getCellPhone, phone) + .ne(AppUser::getId, userId) + .ne(AppUser::getUserStatus, 3).one(); + if (one!=null){ + return R.fail("当前手机号已被绑定"); + } + byId.setCellPhone(phone); + boolean b = appUserService.updateById(byId); return R.ok(); + } + + @Autowired + private RedisService redisService; + private boolean verifyCaptcha(String cellPhone, String captcha, String keyPrefix) { + + if (com.xinquan.common.core.utils.StringUtils.isNotBlank(cellPhone) && com.xinquan.common.core.utils.StringUtils.isNotBlank(captcha)) { + String key = keyPrefix + cellPhone; + String code = redisService.getCacheObject(key); + // 万能验证码 + if (captcha.equals("123456") || (com.xinquan.common.core.utils.StringUtils.isNotBlank(code) && code.equals( + captcha))) { + redisService.deleteObject(key); + return true; + } + } + return false; } @PostMapping("/deleteUser") @ApiOperation(value = "注销账号", tags = {"设置"}) public R deleteUser() { - Long userId = SecurityUtils.getUserId(); - if (userId == 0)return R.tokenError("登录失效"); - + LoginUser loginUser = tokenService.getLoginUser(); + if (loginUser==null){ + return R.tokenError("登录失效"); + } + Long userId = loginUser.getUserid(); + AppUser byId = appUserService.getById(userId); + byId.setUserStatus(3); + byId.setLogoutTime(LocalDateTime.now()); + appUserService.updateById(byId); + appUserService.removeById(byId); + remoteUserService.removeByAppUserId(byId.getUserId()); return R.ok(); } @PostMapping("/wallet") @ApiOperation(value = "我的钱包", tags = {"个人中心"}) - public R<WalletVO> wallet(UpdateAppUserDTO dto) { - Long userId = SecurityUtils.getUserId(); - if (userId == 0)return R.tokenError("登录失效"); + public R<WalletVO> wallet() { + LoginUser loginUser = tokenService.getLoginUser(); + if (loginUser==null){ + return R.tokenError("登录失效"); + } + Long userId = loginUser.getUserid(); AppUser byId = appUserService.getById(userId); WalletVO walletVO = new WalletVO(); walletVO.setId(userId); walletVO.setBalance(byId.getBalance()); - walletVO.setIncome(byId.getIncome()); + + List<AppUser> page = appUserService.lambdaQuery() + .eq(AppUser::getInviteUserId, userId) + .list(); + // 查询登录用户邀请了哪些人 + List<Long> collect = page.stream().map(AppUser::getId).collect(Collectors.toList()); + BigDecimal bigDecimal1 = new BigDecimal("0"); + + for (AppUser record : page) { + List<AppUserWalletRecord> list = appUserWalletRecordService.lambdaQuery().eq(AppUserWalletRecord::getAppUserId, userId) + .like(AppUserWalletRecord::getReason,"分佣").eq(AppUserWalletRecord::getChildAppUserId, record.getId()).list(); + BigDecimal reduce = list.stream().map(AppUserWalletRecord::getAmount).reduce(BigDecimal.ZERO, BigDecimal::add); + bigDecimal1 = bigDecimal1.add(reduce); + record.setMoney(reduce); + } + walletVO.setIncome(bigDecimal1); // 查询用户充值 String data = remoteOrderService.queryChargeByUserId(userId).getData(); BigDecimal bigDecimal = new BigDecimal(data); @@ -622,34 +1138,62 @@ public R<PageDTO<InviteRankListVO>> myInviteRankList( @RequestParam(value = "pageCurr", defaultValue = "1") Integer pageCurr, @RequestParam(value = "pageSize", defaultValue = "10") Integer pageSize) { - Long userId = SecurityUtils.getUserId(); - if (userId == 0)return R.tokenError("登录失效"); - Page<AppUser> page = appUserService.lambdaQuery().ne(AppUser::getUserStatus, 3) - .eq(AppUser::getInviteUserId, userId) - .page(new Page<>(pageCurr, pageSize)); - if (page.getRecords().isEmpty()){ - return R.ok(PageDTO.empty(page)); + LoginUser loginUser = tokenService.getLoginUser(); + if (loginUser==null){ + return R.tokenError("登录失效"); } - // 查询登录用户邀请了哪些人 - List<Long> collect = page.getRecords().stream().map(AppUser::getId).collect(Collectors.toList()); - if (collect.isEmpty())return R.ok(PageDTO.empty(page)); - for (int i = 0; i < page.getRecords().size(); i++) { - AppUser appUser = page.getRecords().get(i); - // 查询该给用户带来收益 - List<AppUserWalletRecord> list = appUserWalletRecordService.lambdaQuery().eq(AppUserWalletRecord::getAppUserId, userId) - .eq(AppUserWalletRecord::getChildAppUserId,appUser.getUserId()).list(); - BigDecimal bigDecimal = new BigDecimal("0"); - for (AppUserWalletRecord appUserWalletRecord : list) { - if (appUserWalletRecord.getAmount()!=null && appUserWalletRecord.getChangeType() == 1){ - bigDecimal = bigDecimal.add(appUserWalletRecord.getAmount()); - } - } - appUser.setMoney(bigDecimal); + Page<AppUser> objectPage = new Page<>(pageCurr, pageSize); + Long userId = loginUser.getUserid(); + List<AppUser> page = appUserService.lambdaQuery().ne(AppUser::getUserStatus, 3) + .eq(AppUser::getInviteUserId, userId) + .list(); + // 查询登录用户邀请了哪些人 + List<Long> collect = page.stream().map(AppUser::getId).collect(Collectors.toList()); + for (AppUser record : page) { + List<AppUserWalletRecord> list = appUserWalletRecordService.lambdaQuery().eq(AppUserWalletRecord::getAppUserId, userId) + .like(AppUserWalletRecord::getReason,"分佣").eq(AppUserWalletRecord::getChildAppUserId, record.getId()).list(); + BigDecimal reduce = list.stream().map(AppUserWalletRecord::getAmount).reduce(BigDecimal.ZERO, BigDecimal::add); + record.setMoney(reduce); } // 根据佣金金额 从大到小排序 - page.getRecords().sort((o1, o2) -> o2.getMoney().compareTo(o1.getMoney())); - return R.ok(PageDTO.of(page, InviteRankListVO.class)); + page.sort((o1, o2) -> o2.getMoney().compareTo(o1.getMoney())); + + List<AppUser> testing = testing(page.size(), pageCurr, pageSize, page); + objectPage.setTotal(testing.size()); + objectPage.setRecords(testing); + return R.ok(PageDTO.of(objectPage, InviteRankListVO.class)); + } + @PostMapping("/myInviteRankListShare") + @ApiOperation(value = "我的助力-分页", tags = {"H5分享"}) + @ApiImplicitParams({ + @ApiImplicitParam(value = "分页参数,当前页码", name = "pageCurr", required = true, dataType = "Integer"), + @ApiImplicitParam(value = "分页参数,每页数量", name = "pageSize", required = true, dataType = "Integer"), + @ApiImplicitParam(value = "用户id", name = "userId", required = true, dataType = "String"), + }) + public R<PageDTO<InviteRankListVO>> myInviteRankListShare( + @RequestParam(value = "pageCurr", defaultValue = "1") Integer pageCurr, + @RequestParam(value = "pageSize", defaultValue = "10") Integer pageSize, + @RequestParam(value = "userId") String userId) { + Page<AppUser> objectPage = new Page<>(pageCurr, pageSize); + List<AppUser> page = appUserService.lambdaQuery().ne(AppUser::getUserStatus, 3) + .eq(AppUser::getInviteUserId, userId) + .list(); + // 查询登录用户邀请了哪些人 + List<Long> collect = page.stream().map(AppUser::getId).collect(Collectors.toList()); + for (AppUser record : page) { + List<AppUserWalletRecord> list = appUserWalletRecordService.lambdaQuery().eq(AppUserWalletRecord::getAppUserId, userId) + .like(AppUserWalletRecord::getReason,"分佣").eq(AppUserWalletRecord::getChildAppUserId, record.getId()).list(); + BigDecimal reduce = list.stream().map(AppUserWalletRecord::getAmount).reduce(BigDecimal.ZERO, BigDecimal::add); + record.setMoney(reduce); + } + // 根据佣金金额 从大到小排序 + page.sort((o1, o2) -> o2.getMoney().compareTo(o1.getMoney())); + + List<AppUser> testing = testing(page.size(), pageCurr, pageSize, page); + objectPage.setTotal(testing.size()); + objectPage.setRecords(testing); + return R.ok(PageDTO.of(objectPage, InviteRankListVO.class)); } @Resource private AppUserWalletRecordService appUserWalletRecordService; @@ -669,24 +1213,89 @@ public R<PageDTO<InviteRankListVO>> inviteRankList( @RequestParam(value = "pageCurr", defaultValue = "1") Integer pageCurr, @RequestParam(value = "pageSize", defaultValue = "10") Integer pageSize) { - Page<AppUser> page = appUserService.lambdaQuery().ne(AppUser::getUserStatus, 3) - .page(new Page<>(pageCurr, pageSize)); - for (AppUser appUser : page.getRecords()) { + Page<AppUser> objectPage = new Page<>(pageCurr, pageSize); + + List<AppUser> page = appUserService.lambdaQuery().ne(AppUser::getUserStatus, 3) + .list(); + List<AppUser> res = new ArrayList<>(); + for (AppUser appUser : page) { int size = appUserService.lambdaQuery().ne(AppUser::getUserStatus, 3) .eq(AppUser::getInviteUserId, appUser.getId()) .list().size(); appUser.setCount(size); + if (size>0){ + res.add(appUser); + } } // 根据帮助人数 从大到小排序 - page.getRecords().sort((o1, o2) -> o2.getCount() - o1.getCount()); - return R.ok(PageDTO.of(page, InviteRankListVO.class)) ; + res.sort((o1, o2) -> o2.getCount() - o1.getCount()); + List<AppUser> testing = testing(res.size(), pageCurr, pageSize, res); + objectPage.setRecords(testing); + objectPage.setTotal(res.size()); + return R.ok(PageDTO.of(objectPage, InviteRankListVO.class)) ; + } + public static List<AppUser> testing(long total, long current, long size, List<AppUser> str){ + List<AppUser> result = new ArrayList<>(); + //获取初始化分页结构 + Page<AppUser> page = new Page<>(current - 1, size, total); + //获取集合下标初始值 + long startIndex = (current - 1) * size; + //获取集合下标结束值 + long endInddex = 0; + if(startIndex + page.getCurrent() >= total || size > total){ + endInddex = total; + }else { + endInddex = Math.min(startIndex + page.getSize(), total); + } + //如果输入的开始查询下标大于集合大小,则查询为空值 + if(startIndex > total){ + result = Collections.emptyList(); + }else{ + result = str.subList((int)startIndex,(int)endInddex); + } + return result; + } + @PostMapping("/inviteRankListShare") + @ApiOperation(value = "爱心助力榜单-分页", tags = {"H5分享"}) + @ApiImplicitParams({ + @ApiImplicitParam(value = "分页参数,当前页码", name = "pageCurr", required = true, dataType = "Integer"), + @ApiImplicitParam(value = "分页参数,每页数量", name = "pageSize", required = true, dataType = "Integer") + }) + public R<PageDTO<InviteRankListVO>> inviteRankListShare( + @RequestParam(value = "pageCurr", defaultValue = "1") Integer pageCurr, + @RequestParam(value = "pageSize", defaultValue = "10") Integer pageSize) { + Page<AppUser> objectPage = new Page<>(pageCurr, pageSize); + + List<AppUser> page = appUserService.lambdaQuery().ne(AppUser::getUserStatus, 3) + .list(); + List<AppUser> res = new ArrayList<>(); + for (AppUser appUser : page) { + int size = appUserService.lambdaQuery().ne(AppUser::getUserStatus, 3) + .eq(AppUser::getInviteUserId, appUser.getId()) + .list().size(); + appUser.setCount(size); + if (size>0){ + res.add(appUser); + } + } + // 根据帮助人数 从大到小排序 + res.sort((o1, o2) -> o2.getCount() - o1.getCount()); + List<AppUser> testing = testing(res.size(), pageCurr, pageSize, res); + objectPage.setRecords(testing); + objectPage.setTotal(res.size()); + return R.ok(PageDTO.of(objectPage, InviteRankListVO.class)) ; } @PostMapping("/getUserInfo") @ApiOperation(value = "获取用户信息", tags = {"个人中心"}) public R<AppUserInfoVO> getUserInfo() { - Long userId = SecurityUtils.getUserId(); - if (userId == 0)return R.tokenError("登录失效"); + LoginUser loginUser = tokenService.getLoginUser(); + if (loginUser==null){ + return R.tokenError("登录失效"); + } + Long userId = loginUser.getUserid(); AppUserInfoVO appUserInfoVO = new AppUserInfoVO(); + AppUser byId = appUserService.getById(userId); + BeanUtils.copyProperties(byId, appUserInfoVO); AppUserVO currentUser = appUserService.getCurrentUser(); DateTimeFormatter formatter = DateTimeFormatter.ofPattern("yyyy-MM-dd"); if (currentUser.getVipExpireTime() == null){ @@ -704,7 +1313,10 @@ List<AppUserViewingHistory> com = appUserViewingHistoryService.cumulative(userId); appUserInfoVO.setCumulative(com.size()); // 查询用户今日学习多少分钟 - int temp = appUserViewingHistoryService.today(userId); + Integer temp = appUserViewingHistoryService.today(userId); + if (temp == null){ + temp =0; + } if (temp == 0){ appUserInfoVO.setToday(0); }else if (temp<60){ @@ -735,23 +1347,14 @@ consecutiveDays++; currentDate = currentDate.minusDays(1); } - appUserInfoVO.setToday(consecutiveDays); - List<AppUserTree> list1 = appUserTreeService.lambdaQuery().eq(AppUserTree::getAppUserId, userId) - .list(); - // 查询用户等级最高的那颗树苗 - AppUserTree tree = list1.stream().max((o1, o2) -> { - if (o1.getTreeLevelType() > o2.getTreeLevelType()) { - return 1; - } else if (o1.getTreeLevelType() < o2.getTreeLevelType()) { - return -1; - } else { - return 0; - } - }).orElse(null); + appUserInfoVO.setContinuity(consecutiveDays); + AppUserTree list1 = appUserTreeService.lambdaQuery().eq(AppUserTree::getAppUserId, userId) + .eq(AppUserTree::getSowAgain,2) + .one(); // 查询疗愈等级 名称 图标 int level = 1; - if (tree != null){ - level = tree.getTreeLevelType(); + if (list1 != null){ + level = list1.getTreeLevelType(); } appUserInfoVO.setLevel(level); // 根据等级查询疗愈名称和图标 @@ -763,8 +1366,11 @@ @PostMapping("/getUserDetail") @ApiOperation(value = "获取个人资料", tags = {"个人中心"}) public R<AppUser> getUserDetail() { - Long userId = SecurityUtils.getUserId(); - if (userId == 0)return R.tokenError("登录失效"); + LoginUser loginUser = tokenService.getLoginUser(); + if (loginUser==null){ + return R.tokenError("登录失效"); + } + Long userId = loginUser.getUserid(); AppUser appUser = appUserService.lambdaQuery().eq(AppUser::getId, userId).one(); if (appUser.getVipExpireTime() == null){ appUser.setIsVip(2); @@ -773,85 +1379,131 @@ }else{ appUser.setIsVip(2); } + AppUserTree list1 = appUserTreeService.lambdaQuery().eq(AppUserTree::getAppUserId, userId) + .eq(AppUserTree::getSowAgain,2) + .one(); + // 查询疗愈等级 名称 图标 + int level = list1.getTreeLevelType(); + appUser.setLevel(level); + // 查询用户累计学习天数 + DateTimeFormatter formatter = DateTimeFormatter.ofPattern("yyyy-MM-dd"); + List<AppUserViewingHistory> com = appUserViewingHistoryService.cumulative(userId); + appUser.setCumulative(com.size()); + // 查询用户今日学习多少分钟 + Integer temp = appUserViewingHistoryService.today(userId); + if (temp == null){ + temp =0; + } + if (temp == 0){ + appUser.setToday(0); + }else if (temp<60){ + // 不足一分钟按一分钟计算 + appUser.setToday(1); + }else{ + appUser.setToday(temp/60); + } + // 查询用户连续观看天数 + List<AppUserViewingHistory> list = appUserViewingHistoryService.lambdaQuery().eq(AppUserViewingHistory::getAppUserId, userId) + .eq(AppUserViewingHistory::getViewingType, 1) + .orderByDesc(BaseModel::getCreateTime).list(); + Set<LocalDate> viewingDates = list.stream() + .map(record -> LocalDate.parse(record.getCreateTime().toLocalDate().toString(), formatter)) + .collect(Collectors.toCollection(HashSet::new)); + // 获取今天的日期 + LocalDate today = LocalDate.now(); + // 计算连续观看天数 + int consecutiveDays = 0; + LocalDate currentDate = today; + // 如果今天没有观看 也进入循环判断 + while (viewingDates.contains(currentDate)||LocalDate.parse(currentDate.toString(), formatter).equals(today)) { + if (!viewingDates.contains(currentDate)){ + // 如果今天没有观看 + currentDate = currentDate.minusDays(1); + continue; + } + consecutiveDays++; + currentDate = currentDate.minusDays(1); + } + appUser.setContinuity(consecutiveDays); + // 根据等级查询疗愈名称和图标 + UserLevelSetting data = remoteBannerService.getIconNameByLevel(level).getData(); + appUser.setLevelName(data.getLevelName()); + appUser.setLevelIcon(data.getLevelIcon()); return R.ok(appUser); } + @Resource + private SysUserClient sysUserClient; @PostMapping("/healingLevel") @ApiOperation(value = "冥想等级", tags = {"个人中心"}) public R<HealingLevelVO> healingLevel() { - Long userId = SecurityUtils.getUserId(); - if (userId == 0)return R.tokenError("登录失效"); - List<AppUserTree> list1 = appUserTreeService.lambdaQuery().eq(AppUserTree::getAppUserId, userId) - .list(); - // 查询用户等级最高的那颗树苗 - AppUserTree tree = list1.stream().max((o1, o2) -> { - if (o1.getTreeLevelType() > o2.getTreeLevelType()) { - return 1; - } else if (o1.getTreeLevelType() < o2.getTreeLevelType()) { - return -1; - } else { - return 0; - } - }).orElse(null); - // 查询疗愈等级 名称 图标 - int level = 1; - if (tree != null){ - level = tree.getTreeLevelType(); + LoginUser loginUser = tokenService.getLoginUser(); + if (loginUser==null){ + return R.tokenError("登录失效"); } - HealingLevelVO healingLevelVO = new HealingLevelVO(); + Long userId = loginUser.getUserid(); + HealingLevelVO healingLevelVO = new HealingLevelVO(); + AppUser one = appUserService.getById(userId); + AppUserTree list1 = appUserTreeService.lambdaQuery().eq(AppUserTree::getAppUserId, userId) + .eq(AppUserTree::getSowAgain,2) + .one(); + // 查询疗愈等级 名称 图标 + int level = list1.getTreeLevelType(); + healingLevelVO.setLevel(level); + // 查询疗愈等级 名称 图标 + if (list1 != null){ + level = list1.getTreeLevelType(); + } healingLevelVO.setLevel(level); // 根据等级查询疗愈名称和图标 UserLevelSetting data = remoteBannerService.getIconNameByLevel(level).getData(); healingLevelVO.setLevelName(data.getLevelName()); healingLevelVO.setLevelIcon(data.getLevelIcon()); - if (level==10){ - healingLevelVO.setNextLevel(2400); - }else{ - switch (level){ - case 1: - healingLevelVO.setNextLevel(1000); - healingLevelVO.setDifferenceLevel(1000-tree.getGrowthValue()); + List<TreeLevelSetting> data3 = sysUserClient.getTreeGroup().getData(); - break; - case 2: - healingLevelVO.setNextLevel(1000); - healingLevelVO.setDifferenceLevel(1000-tree.getGrowthValue()); - break; - case 3: - healingLevelVO.setNextLevel(1000); - healingLevelVO.setDifferenceLevel(1000-tree.getGrowthValue()); - break; - case 4: - healingLevelVO.setNextLevel(1000); - healingLevelVO.setDifferenceLevel(1000-tree.getGrowthValue()); - break; - case 5: - healingLevelVO.setNextLevel(2000); - healingLevelVO.setDifferenceLevel(2000-tree.getGrowthValue()); - break; - case 6: - healingLevelVO.setNextLevel(2000); - healingLevelVO.setDifferenceLevel(2000-tree.getGrowthValue()); - break; - case 7: - healingLevelVO.setNextLevel(2000); - healingLevelVO.setDifferenceLevel(2000-tree.getGrowthValue()); - break; - case 8: - healingLevelVO.setNextLevel(2000); - healingLevelVO.setDifferenceLevel(2000-tree.getGrowthValue()); - break; - case 9: - healingLevelVO.setNextLevel(2400); - healingLevelVO.setDifferenceLevel(2400-tree.getGrowthValue()); - break; - case 10: - healingLevelVO.setNextLevel(2400); - healingLevelVO.setDifferenceLevel(2400-tree.getGrowthValue()); - break; + Integer total1 = list1.getTotal(); + // 根据总能量值 确定他在哪一等级 + int x = 1; + int tem = 0; + for (TreeLevelSetting datum : data3) { + if (total1 == 0){ + Integer growthValue = data3.get(1).getGrowthValue(); + tem = growthValue; + break; + }else if (total1>=datum.getGrowthValue()){ + x = datum.getTreeLevelType(); } } - healingLevelVO.setGrowthValue(tree.getGrowthValue()); + if (x == 10){ + // 如果等级为10那么成长阈值是10级减去9级 + int ten=0; + int nine = 0; + for (TreeLevelSetting datum : data3) { + if (datum.getTreeLevelType()==10){ + ten = datum.getGrowthValue(); + } + if (datum.getTreeLevelType()==9){ + nine = datum.getGrowthValue(); + } + } + tem = ten-nine; + total1 = tem; + }else{ + // 根据当前所在等级查询成长值 + int a = data3.get(x).getGrowthValue()-data3.get(x-1).getGrowthValue(); + tem = a; + total1 = Math.abs(total1-data3.get(x-1).getGrowthValue()); + } + if (x==10){ + healingLevelVO.setDifferenceLevel(0); + healingLevelVO.setGrowthValue(tem); + }else{ + healingLevelVO.setDifferenceLevel(tem-total1); + healingLevelVO.setGrowthValue(total1); + } + healingLevelVO.setNextLevel(tem); + healingLevelVO.setLevel(x); + // 将当前成长值更新 String data1 = remoteUserService.getCourseList(7).getData(); healingLevelVO.setContent(data1); return R.ok(healingLevelVO); @@ -859,16 +1511,22 @@ @PostMapping("/getTotalEnergyValue") @ApiOperation(value = "获取用户当前累计能量值",tags = "树苗打卡站") public R getTotalEnergyValue() { - Long userId = SecurityUtils.getUserId(); - if (userId==0)return R.tokenError("登录失效"); + LoginUser loginUser = tokenService.getLoginUser(); + if (loginUser==null){ + return R.tokenError("登录失效"); + } + Long userId = loginUser.getUserid(); AppUser byId = appUserService.getById(userId); return R.ok(byId.getTotalEnergyValue()); } @PostMapping("/updateUserDetail") @ApiOperation(value = "修改个人资料", tags = {"个人中心"}) - public R<AppUser> updateUserDetail(UpdateAppUserDTO dto) { - Long userId = SecurityUtils.getUserId(); - if (userId == 0)return R.tokenError("登录失效"); + public R<AppUser> updateUserDetail(@RequestBody UpdateAppUserDTO dto) { + LoginUser loginUser = tokenService.getLoginUser(); + if (loginUser==null){ + return R.tokenError("登录失效"); + } + Long userId = loginUser.getUserid(); AppUser byId = appUserService.getById(userId); LambdaUpdateWrapper<AppUser> updateWrapper = new LambdaUpdateWrapper<>(AppUser.class); updateWrapper.set(AppUser::getNickname, dto.getNickname()); @@ -882,15 +1540,19 @@ updateWrapper.set(AppUser::getOccupation, dto.getOccupation()); updateWrapper.set(AppUser::getLocation, dto.getLocation()); updateWrapper.set(AppUser::getHometown, dto.getHometown()); - updateWrapper.set(AppUser::getEmail, dto.getEducation()); + updateWrapper.set(AppUser::getEmail, dto.getEmail()); + updateWrapper.eq(AppUser::getId,userId); appUserService.update(byId, updateWrapper); - return R.ok(); + return R.ok(byId); } @PostMapping("/updateUserAvatar") @ApiOperation(value = "修改头像", tags = {"个人中心"}) public R updateUserDetail(String avatar) { - Long userId = SecurityUtils.getUserId(); - if (userId == 0)return R.tokenError("登录失效"); + LoginUser loginUser = tokenService.getLoginUser(); + if (loginUser==null){ + return R.tokenError("登录失效"); + } + Long userId = loginUser.getUserid(); AppUser byId = appUserService.getById(userId); byId.setAvatar(avatar); appUserService.updateById(byId); @@ -917,20 +1579,29 @@ @PostMapping("/getUserByPhone") @ApiOperation(value = "根据用户手机号查询用户信息") public R<AppUserDetailVO> getCurrentUser(String phone) { - AppUser one = appUserService.lambdaQuery().eq(AppUser::getCellPhone, phone).one(); - AppUserDetailVO appUserDetailVO = new AppUserDetailVO(); - appUserDetailVO.setId(one.getId()); - appUserDetailVO.setCellPhone(one.getCellPhone()); - appUserDetailVO.setAvatar(one.getAvatar()); - appUserDetailVO.setNickname(one.getNickname()); - return R.ok(appUserDetailVO); + AppUser one = appUserService.lambdaQuery().eq(AppUser::getCellPhone, phone) + .ne(AppUser::getUserStatus,3).one(); + if (one!=null){ + AppUserDetailVO appUserDetailVO = new AppUserDetailVO(); + appUserDetailVO.setId(one.getId()); + appUserDetailVO.setCellPhone(one.getCellPhone()); + appUserDetailVO.setAvatar(one.getAvatar()); + appUserDetailVO.setNickname(one.getNickname()); + return R.ok(appUserDetailVO); + + }else { + return R.fail("未查询到账户信息"); + } } @PostMapping("/getUserBalance") @ApiOperation(value = "查询当前用户余额") public R<String> getUserBalance() { - Long userId = SecurityUtils.getUserId(); - if (userId == 0)return R.tokenError("登录失效"); - AppUser one = appUserService.lambdaQuery().eq(AppUser::getUserId, userId).one(); + LoginUser loginUser = tokenService.getLoginUser(); + if (loginUser==null){ + return R.tokenError("登录失效"); + } + Long userId = loginUser.getUserid(); + AppUser one = appUserService.lambdaQuery().eq(AppUser::getId, userId).one(); return R.ok(one.getBalance().toString()); } @@ -955,6 +1626,7 @@ @PostMapping("/saveUserAnswers") @ApiOperation(value = "保存计划引导页用户的答案", tags = {"用户端-计划引导相关接口"}) public R<?> saveUserAnswers(@Validated @RequestBody UserAnswerDTO dto) { + appUserService.saveUserAnswers(dto); return R.ok(); } -- Gitblit v1.7.1