From 9e5d3f634b52333c076eb443a64de873c5ddceed Mon Sep 17 00:00:00 2001
From: xuhy <3313886187@qq.com>
Date: 星期六, 09 十一月 2024 14:39:46 +0800
Subject: [PATCH] 代码提交
---
xinquan-modules/xinquan-course/src/main/java/com/xinquan/course/controller/client/ClientCourseController.java | 973 +++++++++++++++++++++++++++++++++++++++++++++++++++++++++
1 files changed, 971 insertions(+), 2 deletions(-)
diff --git a/xinquan-modules/xinquan-course/src/main/java/com/xinquan/course/controller/client/ClientCourseController.java b/xinquan-modules/xinquan-course/src/main/java/com/xinquan/course/controller/client/ClientCourseController.java
index 378181d..07f5572 100644
--- a/xinquan-modules/xinquan-course/src/main/java/com/xinquan/course/controller/client/ClientCourseController.java
+++ b/xinquan-modules/xinquan-course/src/main/java/com/xinquan/course/controller/client/ClientCourseController.java
@@ -1,8 +1,67 @@
package com.xinquan.course.controller.client;
-import org.springframework.web.bind.annotation.RequestMapping;
-import org.springframework.web.bind.annotation.RestController;
+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.extension.plugins.pagination.Page;
+import com.xinquan.common.core.constant.SecurityConstants;
+import com.xinquan.common.core.domain.R;
+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.security.service.TokenService;
+import com.xinquan.common.security.utils.SecurityUtils;
+import com.xinquan.course.api.domain.Course;
+import com.xinquan.course.api.domain.CourseDTO;
+import com.xinquan.course.api.vo.CourseVO;
+import com.xinquan.course.api.vo.StudyPageVO;
+import com.xinquan.course.api.domain.CourseCategory;
+import com.xinquan.course.api.domain.CourseChapter;
+import com.xinquan.course.domain.CourseLearningRecord;
+import com.xinquan.course.domain.CourseUserFavorite;
+import com.xinquan.course.domain.export.CourseExport;
+import com.xinquan.course.domain.export.CourseOffExport;
+import com.xinquan.course.domain.vo.ClientCourseCategoryVO;
+import com.xinquan.course.domain.vo.ClientCourseVO;
+import com.xinquan.course.service.*;
+import com.xinquan.meditation.api.domain.Meditation;
+import com.xinquan.meditation.api.feign.RemoteMeditationService;
+import com.xinquan.system.api.RemoteBannerService;
+import com.xinquan.system.api.domain.AppUser;
+import com.xinquan.system.api.domain.AppUserCourse;
+import com.xinquan.system.api.domain.AppUserViewingHistory;
+import com.xinquan.system.api.domain.vo.AppUserVO;
+import com.xinquan.system.api.domain.vo.BannerVO;
+import com.xinquan.course.api.domain.OrderCourseVO;
+import com.xinquan.system.api.model.LoginUser;
+import com.xinquan.user.api.feign.RemoteAppUserService;
+import io.swagger.annotations.Api;
+import io.swagger.annotations.ApiImplicitParam;
+import io.swagger.annotations.ApiImplicitParams;
+import io.swagger.annotations.ApiOperation;
+
+import java.io.IOException;
+import java.net.URLEncoder;
+import java.time.LocalDateTime;
+import java.time.format.DateTimeFormatter;
+import java.util.ArrayList;
+import java.util.Arrays;
+import java.util.List;
+import java.util.Objects;
+import java.util.stream.Collectors;
+
+import lombok.RequiredArgsConstructor;
+import org.apache.poi.ss.usermodel.Workbook;
+import org.springframework.beans.factory.annotation.Autowired;
+import org.springframework.web.bind.annotation.*;
+
+import javax.annotation.Resource;
+import javax.servlet.ServletOutputStream;
+import javax.servlet.http.HttpServletResponse;
/**
* <p>
@@ -12,9 +71,919 @@
* @author mitao
* @since 2024-08-21
*/
+@Api(tags = {"用户端-课程相关接口"})
@RestController
+@RequiredArgsConstructor
@RequestMapping("/client/course/course")
public class ClientCourseController {
+ private final CourseCategoryService courseCategoryService;
+ private final CourseService courseService;
+ private final RemoteBannerService remoteBannerService;
+ private final RemoteAppUserService remoteAppUserService;
+ @Resource
+ private CourseChapterService courseChapterService;
+ @Resource
+ private CourseUserFavoriteService courseUserFavoriteService;
+
+ @Resource
+ private RemoteMeditationService remoteMeditationService;
+ @Resource
+ private CourseLearningRecordService courseLearningRecordService;
+
+ @GetMapping("/getCourseCount")
+ public R<String> getCourseCount() {
+ StringBuilder stringBuilder = new StringBuilder();
+ List<Course> list = courseService.lambdaQuery().eq(BaseModel::getDelFlag, 0)
+ .eq(Course::getCourseType,1).list();
+ List<Course> list1 = courseService.lambdaQuery().eq(BaseModel::getDelFlag, 0)
+ .eq(Course::getCourseType, 2).list();
+ stringBuilder.append(list.size()+list1.size()).append(",");
+ List<Course> collect1 = list.stream().filter(t -> t.getChargeType() == 1).collect(Collectors.toList());
+ List<Course> collect2 = list.stream().filter(t -> t.getChargeType() == 2).collect(Collectors.toList());
+ List<Course> collect3 = list.stream().filter(t -> t.getChargeType() == 3).collect(Collectors.toList());
+ stringBuilder.append(collect1.size()).append(",");
+ stringBuilder.append(collect2.size()).append(",");
+ stringBuilder.append(collect3.size()).append(",");
+ stringBuilder.append(list1.size());
+ return R.ok(stringBuilder.toString());
+ }
+ /**
+ * 根据课程id 查询学习人数
+ * @param id
+ * @return
+ */
+ @GetMapping("/getCountByCourseId/{id}")
+ public R<Integer> getCountByCourseId(
+ @PathVariable("id")String id)
+ {
+ int size = courseLearningRecordService.lambdaQuery().eq(CourseLearningRecord::getCourseId, id)
+ .groupBy(CourseLearningRecord::getAppUserId).list().size();
+
+ return R.ok(size);
+ }
+ /**
+ * 根据课程id 查询章节列表
+ * @param id
+ * @return
+ */
+ @GetMapping("/getChapterByCourseId/{id}")
+ public R<List<CourseChapter>> getChapterByCourseId(
+ @PathVariable("id")String id)
+ {
+ return R.ok(courseChapterService.lambdaQuery().eq(CourseChapter::getCourseId,id).list());
+ }
+
+
+
+
+ @GetMapping("/getCourseByIds/{pageCurr}/{pageSize}/{ids}")
+ public R<Page<Course>> getCourseByIds(@PathVariable("pageCurr") Integer pageCurr,
+ @PathVariable("pageSize") Integer pageSize,
+ @PathVariable("ids")String ids)
+ {
+ List<Long> collect = courseChapterService.lambdaQuery().in(CourseChapter::getId, Arrays.asList(ids.split(",")))
+ .list().stream().map(CourseChapter::getCourseId).collect(Collectors.toList());
+ if(collect.isEmpty()){
+ collect.add(-1L);
+ }
+ Page<Course> page = courseService
+ .lambdaQuery()
+ .in(Course::getId,collect)
+ .page(new Page<>(pageCurr, pageSize));
+
+ if (page.getRecords().isEmpty()){
+ return R.ok(page);
+ }
+ // 查询人数
+ return R.ok(page);
+ }
+
+ /**
+ * 远程调用 通过课程名字查询课程ids
+ * @return
+ */
+ @PostMapping("/getCourseIdsByName/{name}")
+ public R<List<Long>> getCourseIdsByName(@PathVariable("name") String name) {
+ List<Long> collect = courseService.lambdaQuery().like(Course::getCourseTitle, name)
+ .list().stream().map(Course::getId)
+ .collect(Collectors.toList());
+ return R.ok(collect);
+ }
+
+ @ApiOperation(value = "课程管理列表导出", tags = {"管理后台-课程管理"})
+ @PutMapping("/export")
+ public void export(@RequestBody CourseDTO courseDTO)
+ {
+ List<Long> longs = new ArrayList<>();
+ LambdaQueryWrapper<Course> courseLambdaQueryWrapper = new LambdaQueryWrapper<>();
+ courseLambdaQueryWrapper.like(StringUtils.isNotBlank(courseDTO.getTutor()), Course::getTutor, courseDTO.getTutor())
+ .eq(Objects.nonNull(courseDTO.getCateId()), Course::getCateId, courseDTO.getCateId())
+ .eq(Objects.nonNull(courseDTO.getCourseType()), Course::getCourseType, courseDTO.getCourseType())
+ .eq(Objects.nonNull(courseDTO.getChargeType()), Course::getChargeType, courseDTO.getChargeType())
+ .eq(Objects.nonNull(courseDTO.getListingStatus()), Course::getListingStatus, courseDTO.getListingStatus())
+ .orderByDesc(Course::getSortNum);
+ if (org.springframework.util.StringUtils.hasLength(courseDTO.getIds())){
+ courseLambdaQueryWrapper.in(Course::getId, Arrays.asList(courseDTO.getIds().split(",")));
+ }
+ if (org.springframework.util.StringUtils.hasLength(courseDTO.getCourseTitle())){
+ List<Long> collect = courseService.lambdaQuery().like(Course::getCourseTitle, courseDTO.getCourseTitle()).list()
+ .stream().map(Course::getId).collect(Collectors.toList());
+ longs.addAll(collect);
+ List<Long> collect1 = courseChapterService.lambdaQuery().like(CourseChapter::getChapterTitle, courseDTO.getCourseTitle()).list()
+ .stream().map(CourseChapter::getCourseId).collect(Collectors.toList());
+ longs.addAll(collect1);
+ if (longs.isEmpty()){
+ longs.add(-1L);
+ }
+ courseLambdaQueryWrapper.in(Course::getId, longs);
+ }
+ List<Course> page = courseService.list(courseLambdaQueryWrapper);
+ List<CourseExport> courseExports = new ArrayList<>();
+ List<CourseOffExport> courseOffExports = new ArrayList<>();
+ for (Course record : page) {
+ CourseExport courseExport = new CourseExport();
+ CourseOffExport courseOffExport = new CourseOffExport();
+ CourseCategory byId = courseCategoryService.getById(record.getCateId());
+ if (Objects.nonNull(byId)){
+ record.setCategoryName(byId.getName());
+ courseExport.setCategoryName(byId.getName());
+ }
+ record.setUid(record.getId().toString());
+ long count = courseChapterService.count(new LambdaQueryWrapper<CourseChapter>().eq(CourseChapter::getCourseId, record.getId()));
+ record.setCourseChapterCount(count);
+ // 查询收藏数量
+ long count1 = courseUserFavoriteService.count(new LambdaQueryWrapper<CourseUserFavorite>()
+ .eq(CourseUserFavorite::getCourseId, record.getId()));
+ record.setCollectCount(count1);
+ int size1 = courseLearningRecordService.lambdaQuery().eq(CourseLearningRecord::getCourseId, record.getId())
+ .groupBy(CourseLearningRecord::getAppUserId).list().size();
+ // 查询学习人数
+// int size = remoteAppUserService.getUserByCourseId(record.getId()).getData().size();
+ record.setCount(size1);
+ courseExport.setName(record.getCourseTitle());
+ courseExport.setTutor(record.getTutor());
+ if (record.getCourseType()==1){
+ switch (record.getChargeType()){
+ case 1:
+ courseExport.setGeneralPrice("免费");
+ break;
+ case 2:
+ courseExport.setGeneralPrice("会员免费");
+ break;
+ case 3:
+ courseExport.setGeneralPrice("￥"+record.getGeneralPrice());
+ break;
+ }
+ }
+
+ courseExport.setCourseChapterCount(count+"");
+ courseExport.setListingStatus(record.getListingStatus()+"");
+ courseExport.setRealLearnedNum(size1+"");
+ courseExport.setCollectCount(count1+"");
+ DateTimeFormatter df = DateTimeFormatter.ofPattern("yyyy-MM-dd HH:mm:ss");
+ String format = df.format(record.getCreateTime());
+ courseExport.setCreateTime(format);
+ courseExports.add(courseExport);
+ // 线下
+ courseOffExport.setName(record.getCourseTitle());
+ courseOffExport.setTutor(record.getTutor());
+ courseOffExport.setAddress(record.getAddress()+record.getAddressDetail());
+ courseOffExport.setListingStatus(record.getListingStatus()+"");
+ courseOffExport.setCollectCount(count1+"");
+ courseOffExport.setCreateTime(format);
+ courseOffExports.add(courseOffExport);
+ }
+ if (courseDTO.getCourseType()==1){
+ Workbook workbook = ExcelExportUtil.exportExcel(new ExportParams(), CourseExport.class, courseExports);
+ 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();
+ }
+ }
+ }else{
+ Workbook workbook = ExcelExportUtil.exportExcel(new ExportParams(), CourseOffExport.class, courseOffExports);
+ 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("/courseManagementList")
+ @ApiOperation(value = "课程管理列表-分页", tags = {"管理后台-课程管理"})
+ public R<PageDTO<Course>> courseManagementList(@RequestBody CourseDTO courseDTO) {
+ List<Long> longs = new ArrayList<>();
+ LambdaQueryWrapper<Course> courseLambdaQueryWrapper = new LambdaQueryWrapper<>();
+ courseLambdaQueryWrapper.like(StringUtils.isNotBlank(courseDTO.getTutor()), Course::getTutor, courseDTO.getTutor())
+ .eq(Objects.nonNull(courseDTO.getCateId()), Course::getCateId, courseDTO.getCateId())
+ .eq(Objects.nonNull(courseDTO.getCourseType()), Course::getCourseType, courseDTO.getCourseType())
+ .eq(Objects.nonNull(courseDTO.getChargeType()), Course::getChargeType, courseDTO.getChargeType())
+ .eq(Objects.nonNull(courseDTO.getListingStatus()), Course::getListingStatus, courseDTO.getListingStatus())
+ .orderByDesc(Course::getSortNum);
+ if (org.springframework.util.StringUtils.hasLength(courseDTO.getCourseTitle())){
+ List<Long> collect = courseService.lambdaQuery().like(Course::getCourseTitle, courseDTO.getCourseTitle()).list()
+ .stream().map(Course::getId).collect(Collectors.toList());
+ longs.addAll(collect);
+ List<Long> collect1 = courseChapterService.lambdaQuery().like(CourseChapter::getChapterTitle, courseDTO.getCourseTitle()).list()
+ .stream().map(CourseChapter::getCourseId).collect(Collectors.toList());
+ longs.addAll(collect1);
+ if (longs.isEmpty()){
+ longs.add(-1L);
+ }
+ courseLambdaQueryWrapper.in(Course::getId, longs);
+ }
+ Page<Course> page = courseService.page(new Page<>(courseDTO.getPageCurr(), courseDTO.getPageSize()), courseLambdaQueryWrapper);
+ if (CollUtils.isEmpty(page.getRecords())) {
+ return R.ok(PageDTO.empty(page));
+ }
+ for (Course record : page.getRecords()) {
+ CourseCategory byId = courseCategoryService.getById(record.getCateId());
+ if (Objects.nonNull(byId)){
+ record.setCategoryName(byId.getName());
+ }
+ record.setUid(record.getId().toString());
+ long count = courseChapterService.count(new LambdaQueryWrapper<CourseChapter>().eq(CourseChapter::getCourseId, record.getId()));
+ record.setCourseChapterCount(count);
+ // 查询收藏数量
+ long count1 = courseUserFavoriteService.count(new LambdaQueryWrapper<CourseUserFavorite>()
+ .eq(CourseUserFavorite::getCourseId, record.getId()));
+ record.setCollectCount(count1);
+ // 查询学习人数
+// record.setCount(remoteAppUserService.getUserByCourseId(record.getId()).getData().size());
+ int size1 = courseLearningRecordService.lambdaQuery().eq(CourseLearningRecord::getCourseId, record.getId())
+ .groupBy(CourseLearningRecord::getAppUserId).list().size();
+ List<CourseChapter> list = courseChapterService.lambdaQuery()
+ .eq(CourseChapter::getCourseId, record.getId()).list();
+ // 章节列表累加虚拟学习人数
+ int temp = 0;
+ for (CourseChapter courseChapter : list) {
+ temp+=courseChapter.getVirtualLearnedNum();
+ }
+ record.setCount(size1+temp);
+ }
+ return R.ok(PageDTO.of(page, Course.class));
+ }
+ @PostMapping("/addCourse")
+ @ApiOperation(value = "新增课程管理", tags = "管理后台-课程管理")
+ public R addCourse(@RequestBody Course homeBackgroundMusic) {
+ homeBackgroundMusic.setCreateBy(SecurityUtils.getUsername());
+ homeBackgroundMusic.setCreateTime(LocalDateTime.now());
+ return R.ok(courseService.save(homeBackgroundMusic));
+ }
+ @GetMapping("/detailCourse")
+ @ApiOperation(value = "查看详情课程管理", tags = "管理后台-课程管理")
+ public R<Course> detailCourse(String uid) {
+ Course byId = courseService.getById(uid);
+ CourseCategory byId1 = courseCategoryService.getById(byId.getCateId());
+ if (byId1!=null){
+ byId.setCategoryName(byId1.getName());
+ }
+ List<CourseChapter> list = courseChapterService.lambdaQuery()
+ .eq(CourseChapter::getCourseId, uid).list();
+ int temp = 0;
+ int temp1 = 0;
+ for (CourseChapter courseChapter : list) {
+ int size = courseLearningRecordService.lambdaQuery()
+ .eq(CourseLearningRecord::getChapterId, courseChapter.getId())
+ .list().size();
+ courseChapter.setRealLearnedNum(size+courseChapter.getVirtualLearnedNum());
+ temp+=courseChapter.getVirtualLearnedNum();
+ temp1+=size;
+ }
+ int size1 = courseLearningRecordService.lambdaQuery()
+ .eq(CourseLearningRecord::getCourseId, uid).groupBy(CourseLearningRecord::getAppUserId)
+ .list().size();
+ byId.setVirtualLearnedNum(temp);
+ byId.setRealLearnedNum(size1);
+ byId.setCount(temp+size1);
+ byId.setList(list);
+ int size = courseUserFavoriteService.lambdaQuery()
+ .eq(CourseUserFavorite::getCourseId, uid).list().size();
+ byId.setCollectCount((long) size);
+ return R.ok(byId);
+ }
+ @GetMapping("/updateState")
+ @ApiOperation(value = "修改课程上下架状态", tags = "管理后台-课程管理")
+ public R updateState(String uid) {
+ Course byId = courseService.getById(uid);
+ if (byId.getListingStatus() == 1){
+ byId.setListingStatus(2);
+ }else {
+ byId.setListingStatus(1);
+ }
+ courseService.updateById(byId);
+ return R.ok();
+ }
+ @PostMapping("/updateCourse")
+ @ApiOperation(value = "修改课程管理", tags = "管理后台-课程管理")
+ public R updateCourse(@RequestBody Course homeBackgroundMusic) {
+ homeBackgroundMusic.setUpdateBy(SecurityUtils.getUsername());
+ homeBackgroundMusic.setUpdateTime(LocalDateTime.now());
+ return R.ok(courseService.updateById(homeBackgroundMusic));
+ }
+ @PostMapping("/deleteCourse")
+ @ApiOperation(value = "批量删除", tags = "管理后台-课程管理")
+ public R deleteCourse(String ids) {
+ return R.ok(courseService.removeBatchByIds(Arrays.asList(ids.split(",")).stream().map(Long::valueOf).collect(Collectors.toList())));
+ }
+
+
+
+ @GetMapping("/cateList")
+ public R<List<CourseCategory>> cateList() {
+ List<CourseCategory> list = courseCategoryService.list();
+ for (CourseCategory courseCategory : list) {
+ courseCategory.setUid(courseCategory.getId().toString());
+ }
+ return R.ok(list);
+ }
+ @PostMapping("/courseList")
+ public R<PageDTO<Course>> courseList(@RequestBody CourseDTO courseDTO) {
+ Page<Course> page = courseService.lambdaQuery()
+ .like(StringUtils.isNotBlank(courseDTO.getCourseTitle()), Course::getCourseTitle, courseDTO.getCourseTitle())
+ .like(StringUtils.isNotBlank(courseDTO.getTutor()), Course::getTutor, courseDTO.getTutor())
+ .eq(Objects.nonNull(courseDTO.getCateId()), Course::getCateId, courseDTO.getCateId())
+ .eq(Objects.nonNull(courseDTO.getCourseType()), Course::getCourseType, courseDTO.getCourseType())
+ .orderByDesc(Course::getSortNum)
+ .page(new Page<>(courseDTO.getPageCurr(), courseDTO.getPageSize()));
+ if (CollUtils.isEmpty(page.getRecords())) {
+ return R.ok(PageDTO.empty(page));
+ }
+ for (Course record : page.getRecords()) {
+ CourseCategory byId = courseCategoryService.getById(record.getCateId());
+ if (Objects.nonNull(byId)){
+ record.setCategoryName(byId.getName());
+ }
+ record.setUid(record.getId().toString());
+ }
+ return R.ok(PageDTO.of(page, Course.class));
+ }
+ @Autowired
+ private TokenService tokenService;
+ @PostMapping("/myCollect")
+ @ApiOperation(value = "我的收藏")
+ @ApiImplicitParams({
+ @ApiImplicitParam(name = "state", value = "1冥想 2课程", dataType = "Integer", required = true),
+ @ApiImplicitParam(name = "pageCurr", value = "分页参数，当前页码", dataType = "Integer", required = true),
+ @ApiImplicitParam(name = "pageSize", value = "分页参数，每页数量", dataType = "Integer", required = true)
+ })
+ public R<List<OrderCourseVO>> myCollect(@RequestParam(value = "state")Integer state,
+ @RequestParam(value = "pageCurr")Integer pageCurr,
+ @RequestParam(value = "pageSize")Integer pageSize) {
+ LoginUser loginUser = tokenService.getLoginUser();
+ if (loginUser==null){
+ return R.tokenError("登录失效");
+ }
+ Long userId = loginUser.getUserid();
+ List<OrderCourseVO> orderCourseVOS = new ArrayList<>();
+
+ switch (state){
+ case 1:
+ Page<Meditation> data = remoteMeditationService.getMeditationById(pageCurr, pageSize,userId)
+ .getData();
+ for (Meditation meditation : data.getRecords()) {
+ OrderCourseVO orderCourseVO = new OrderCourseVO();
+ orderCourseVO.setBusinessId(meditation.getId());
+ orderCourseVO.setCourseTitle(meditation.getMeditationTitle());
+ orderCourseVO.setDescription(meditation.getDetailDescription());
+ orderCourseVO.setChargeType(meditation.getChargeType());
+ orderCourseVO.setGeneralPrice(meditation.getGeneralPrice());
+ orderCourseVO.setIosPrice(meditation.getIosPrice());
+ orderCourseVO.setCoverUrl(meditation.getCoverUrl());
+ orderCourseVO.setCount(meditation.getRealLearnedNum()+meditation.getVirtualLearnedNum());
+ orderCourseVOS.add(orderCourseVO);
+ }
+ break;
+ case 2:
+ List<Long> collect = courseUserFavoriteService.lambdaQuery()
+ .eq(CourseUserFavorite::getAppUserId, userId).list().stream()
+ .map(CourseUserFavorite::getCourseId).collect(Collectors.toList());
+ if(collect.isEmpty())collect.add(-1L);
+ Page<Course> page = courseService
+ .lambdaQuery()
+ .in(Course::getId, collect)
+ .page(new Page<>(pageCurr, pageSize));
+ for (Course record : page.getRecords()) {
+ OrderCourseVO orderCourseVO = new OrderCourseVO();
+ orderCourseVO.setBusinessId(record.getId());
+ orderCourseVO.setCourseTitle(record.getCourseTitle());
+ orderCourseVO.setDescription(record.getDescription());
+ orderCourseVO.setChargeType(record.getChargeType());
+ orderCourseVO.setGeneralPrice(record.getGeneralPrice());
+ orderCourseVO.setIosPrice(record.getIosPrice());
+ orderCourseVO.setCoverUrl(record.getCoverUrl());
+ List<AppUser> data1 = remoteAppUserService.getUserByCourseId(record.getId()).getData();
+
+ List<CourseChapter> list = courseChapterService.lambdaQuery().eq(CourseChapter::getCourseId, record.getId()).list();
+ int temp = 0 ;
+ for (CourseChapter courseChapter : list) {
+ temp+= courseChapter.getVirtualLearnedNum();
+ }
+ int size = courseLearningRecordService.lambdaQuery().eq(CourseLearningRecord::getCourseId, record.getId())
+ .groupBy(CourseLearningRecord::getAppUserId).list().size();
+ orderCourseVO.setCount(temp+size);
+ orderCourseVOS.add(orderCourseVO);
+ }
+ break;
+ }
+ return R.ok(orderCourseVOS);
+ }
+ @PostMapping("/collectCourse")
+ @ApiOperation(value = "收藏/取消课程")
+ @ApiImplicitParams({
+ @ApiImplicitParam(value = "课程id", name = "id", required = true, dataType = "Long"),
+ })
+ public R collectCourse(@RequestParam(value = "id")Long id) {
+ LoginUser loginUser = tokenService.getLoginUser();
+ if (loginUser==null){
+ return R.tokenError("登录失效");
+ }
+ Long userId = loginUser.getUserid();
+ CourseUserFavorite one = courseUserFavoriteService.lambdaQuery()
+ .eq(CourseUserFavorite::getAppUserId, userId)
+ .eq(CourseUserFavorite::getCourseId, id).one();
+ if (one==null){
+ // 收藏课程
+ CourseUserFavorite courseUserFavorite = new CourseUserFavorite();
+ courseUserFavorite.setAppUserId(userId);
+ courseUserFavorite.setCourseId(id);
+ courseUserFavoriteService.save(courseUserFavorite);
+ }else{
+ // 取消收藏
+ courseUserFavoriteService.removeById(one);
+ }
+ return R.ok();
+ }
+
+
+ /**
+ * 远程调用 根据课程id查询课程信息
+ *
+ * @return 课程分类列表
+ */
+ @PostMapping("/getCourseByIdAny")
+ public R<OrderCourseVO> getCourseByIdAny(@RequestBody OrderCourseVO req) {
+ Course byId = courseService.getById(req.getBusinessId());
+ List<AppUser> data = remoteAppUserService.getUserByCourseId(req.getBusinessId()).getData();
+ if (data!=null){
+ req.setCount(data.size());
+ req.setCourseTitle(byId.getCourseTitle());
+ req.setDescription(byId.getDescription());
+ req.setGeneralPrice(byId.getGeneralPrice());
+ req.setIosPrice(byId.getIosPrice());
+ req.setCoverUrl(byId.getCoverUrl());
+ }
+ return R.ok(req);
+ }
+
+ /**
+ * 获取轮播图列表
+ *
+ * @return 轮播图列表
+ */
+ @GetMapping("/getBannerList")
+ @ApiOperation(value = "获取轮播图列表")
+ public R<List<BannerVO>> getBannerList() {
+ return remoteBannerService.getBannerList(SecurityConstants.INNER);
+ }
+
+ /**
+ * 获取课程分类列表
+ *
+ * @return 课程分类列表
+ */
+ @GetMapping("/getCourseCategoryList")
+ @ApiOperation(value = "获取课程分类列表")
+ public R<List<ClientCourseCategoryVO>> getCourseCategoryList() {
+ return R.ok(courseCategoryService.getCourseCategoryList());
+ }
+ /**
+ * 远程调用 根据分类id 获取分类对象
+ *
+ * @return 课程分类列表
+ */
+ @GetMapping("/getCategoryById/{id}")
+ public R<CourseCategory> getCategoryById(@PathVariable("id") String id) {
+ return R.ok(courseCategoryService.getById(id));
+ }
+ /**
+ * 课程详情
+ *
+ * @return 课程详情
+ */
+
+
+ /**
+ * 课程详情
+ *
+ * @return 课程详情
+ */
+ @PostMapping("/getPayCourseInfoById")
+ @ApiOperation(value = "根据id获取课程详情")
+ @ApiImplicitParams({
+ @ApiImplicitParam(value = "课程id", name = "id", required = true, dataType = "String"),
+ })
+ public R<ClientCourseVO> getPayCourseInfoById(@RequestParam(value = "id")Long id) {
+
+ Course byId = courseService.getById(id);
+ ClientCourseVO clientCourseVO = new ClientCourseVO();
+ BeanUtils.copyProperties(byId, clientCourseVO);
+ List<AppUser> data = remoteAppUserService.getUserByCourseId(id).getData();
+ if (byId.getChargeType()==1 && tokenService.getLoginUser()==null){
+ if (data!=null){
+ clientCourseVO.setCount(data.size());
+ if (data.size()>=5){
+ clientCourseVO.setHeaders(data.stream().limit(5).map(AppUser::getAvatar).collect(Collectors.toList()));
+ }else{
+ clientCourseVO.setHeaders(data.stream().map(AppUser::getAvatar).collect(Collectors.toList()));
+ }
+ }
+ }else{
+ LoginUser loginUser = tokenService.getLoginUser();
+ if (loginUser==null){
+ return R.tokenError("登录失效");
+ }
+ Long userId = loginUser.getUserid();
+ AppUser data1 = remoteAppUserService.getAppUserById(userId + "").getData();
+ if (data1.getVipExpireTime()!=null && data1.getVipExpireTime().isAfter(LocalDateTime.now())){
+ clientCourseVO.setIsVip(1);
+ }else{
+ clientCourseVO.setIsVip(0);
+ }
+ // 查询学习人数和头像列表
+ if (data!=null){
+ clientCourseVO.setCount(data.size());
+ if (data.size()>=5){
+ clientCourseVO.setHeaders(data.stream().limit(5).map(AppUser::getAvatar).collect(Collectors.toList()));
+ }else{
+ clientCourseVO.setHeaders(data.stream().map(AppUser::getAvatar).collect(Collectors.toList()));
+ }
+ List<Long> collect = data.stream().map(AppUser::getId).collect(Collectors.toList());
+ if (!collect.isEmpty()){
+ if (collect.contains(userId)){
+ clientCourseVO.setIsBuy(1);
+ }
+ }
+ }
+ // 查询是否已收藏课程
+ clientCourseVO.setIsCollect(courseUserFavoriteService.lambdaQuery()
+ .eq(CourseUserFavorite::getAppUserId, userId)
+ .eq(CourseUserFavorite::getCourseId, id).one() == null ? 2 : 1);
+ }
+
+
+ // 查询用户是否已购买该课程
+ // 查询章节
+ List<CourseChapter> page = courseChapterService.lambdaQuery()
+ .eq(CourseChapter::getCourseId, id)
+ .orderByDesc(CourseChapter::getSortNum)
+ .list();
+ for (CourseChapter courseChapter : page) {
+ int size = courseLearningRecordService.lambdaQuery()
+ .eq(CourseLearningRecord::getChapterId, courseChapter.getId())
+ .list().size();
+ courseChapter.setRealLearnedNum(size+courseChapter.getVirtualLearnedNum());
+ }
+ clientCourseVO.setList(page);
+ clientCourseVO.setIsBuy(0);
+
+
+ // 查询推荐课程
+ List<Course> list = courseService.lambdaQuery().eq(Course::getCateId, byId.getCateId())
+ .eq(Course::getCourseType,1)
+ .eq(Course::getRecommend, 1).list();
+ List<Course> courses = new ArrayList<>();
+ // 随机获取两个课程
+ if (CollUtils.isNotEmpty(list)) {
+ int size = list.size();
+ int index = (int) (Math.random() * size);
+ if (size >= 2){
+ for (int i = 0; i < 2; i++) {
+ courses.add(list.get(index));
+ }
+ }else{
+ courses.add(list.get(index));
+ }
+ }
+ for (Course cours : courses) {
+ List<AppUser> data3 = remoteAppUserService.getUserByCourseId(id).getData();
+ cours.setCount(data3.size());
+ }
+ clientCourseVO.setList2(courses);
+
+ return R.ok(clientCourseVO);
+ }
+ /**
+ * 课程详情
+ *
+ * @return 课程详情
+ */
+ @PostMapping("/getPayCourseInfoByIdShare")
+ @ApiOperation(value = "根据id获取课程详情",tags = "分享H5")
+ @ApiImplicitParams({
+ @ApiImplicitParam(value = "课程id", name = "id", required = true, dataType = "String"),
+ })
+ public R<ClientCourseVO> getPayCourseInfoByIdShare(@RequestParam(value = "id")Long id) {
+
+ Course byId = courseService.getById(id);
+ ClientCourseVO clientCourseVO = new ClientCourseVO();
+ BeanUtils.copyProperties(byId, clientCourseVO);
+ // 查询章节
+ List<CourseChapter> page = courseChapterService.lambdaQuery()
+ .eq(CourseChapter::getCourseId, id)
+ .orderByDesc(CourseChapter::getSortNum)
+ .list();
+ for (CourseChapter courseChapter : page) {
+ int size = courseLearningRecordService.lambdaQuery()
+ .eq(CourseLearningRecord::getChapterId, courseChapter.getId())
+ .list().size();
+ courseChapter.setRealLearnedNum(size+courseChapter.getVirtualLearnedNum());
+ }
+ clientCourseVO.setList(page);
+ clientCourseVO.setIsBuy(0);
+ // 查询学习人数和头像列表
+ List<AppUser> data = remoteAppUserService.getUserByCourseId(id).getData();
+ if (data!=null){
+ clientCourseVO.setCount(data.size());
+ if (data.size()>=5){
+ clientCourseVO.setHeaders(data.stream().limit(5).map(AppUser::getAvatar).collect(Collectors.toList()));
+ }else{
+ clientCourseVO.setHeaders(data.stream().map(AppUser::getAvatar).collect(Collectors.toList()));
+ }
+ List<Long> collect = data.stream().map(AppUser::getUserId).collect(Collectors.toList());
+ }
+ // 查询推荐课程
+ List<Course> list = courseService.lambdaQuery().eq(Course::getCateId, byId.getCateId())
+ .eq(Course::getCourseType,1)
+ .eq(Course::getRecommend, 1).list();
+ List<Course> courses = new ArrayList<>();
+ // 随机获取两个课程
+ if (CollUtils.isNotEmpty(list)) {
+ int size = list.size();
+ int index = (int) (Math.random() * size);
+ if (size >= 2){
+ for (int i = 0; i < 2; i++) {
+ courses.add(list.get(index));
+ }
+ }else{
+ courses.add(list.get(index));
+ }
+ }
+ for (Course cours : courses) {
+ List<AppUser> data1 = remoteAppUserService.getUserByCourseId(id).getData();
+ cours.setCount(data1.size());
+ }
+ clientCourseVO.setList2(courses);
+ return R.ok(clientCourseVO);
+ }
+
+ /**
+ * 获取课程列表-分页
+ *
+ * @param courseTitle 课程标题
+ * @param cateId 分类id
+ * @param pageCurr 分页参数，当前页码
+ * @param pageSize 分页参数，每页数量
+ * @return 课程分页列表
+ */
+ @PostMapping("/getCoursePageList")
+ @ApiOperation(value = "获取课程列表-分页")
+ @ApiImplicitParams({
+ @ApiImplicitParam(value = "课程标题", name = "courseTitle", required = false, dataType = "String"),
+ @ApiImplicitParam(value = "课程分类id", name = "cateId", required = false, dataType = "Long"),
+ @ApiImplicitParam(value = "分页参数，当前页码", name = "pageCurr", required = true, dataType = "Integer"),
+ @ApiImplicitParam(value = "分页参数，每页数量", name = "pageSize", required = true, dataType = "Integer")
+ })
+ public R<PageDTO<ClientCourseVO>> getCourseList(
+ @RequestParam(defaultValue = "", value = "courseTitle", required = false) String courseTitle,
+ @RequestParam(required = false) Long cateId,
+ @RequestParam(value = "pageCurr", defaultValue = "1") Integer pageCurr,
+ @RequestParam(value = "pageSize", defaultValue = "10") Integer pageSize) {
+ PageDTO<ClientCourseVO> coursePageList = courseService.getCoursePageList(courseTitle, cateId, pageCurr, pageSize);
+
+ for (ClientCourseVO record : coursePageList.getList()) {
+ int size1 = courseLearningRecordService.lambdaQuery().eq(CourseLearningRecord::getCourseId, record.getId())
+ .groupBy(CourseLearningRecord::getAppUserId).list().size();
+ List<CourseChapter> list = courseChapterService.lambdaQuery()
+ .eq(CourseChapter::getCourseId, record.getId()).list();
+ // 章节列表累加虚拟学习人数
+ int temp = 0;
+ for (CourseChapter courseChapter : list) {
+ temp+=courseChapter.getVirtualLearnedNum();
+ }
+ record.setCount(size1+temp);
+ }
+ return R.ok(coursePageList);
+ }
+ @PostMapping("/studyPageByChapterId")
+ @ApiOperation(value = "课程学习页面")
+ @ApiImplicitParams({
+ @ApiImplicitParam(value = "章节id", name = "chapterId", required = true, dataType = "Long"),
+ })
+ public R<List<CourseChapter>> studyPageByChapterId(@RequestParam(value = "chapterId")Long chapterId) {
+
+ CourseChapter byId1 = courseChapterService.getById(chapterId);
+ Course byId = courseService.getById(byId1.getCourseId());
+ Long id = byId1.getCourseId();
+ // 查询章节
+ List<CourseChapter> page = courseChapterService.lambdaQuery()
+ .eq(CourseChapter::getCourseId, id)
+ .orderByDesc(CourseChapter::getSortNum)
+ .list();
+
+ for (CourseChapter courseChapter : page) {
+ AppUserViewingHistory data = remoteAppUserService.getCourseStudyHistory(courseChapter.getId()).getData();
+ if (data!=null){
+ courseChapter.setMinuteLook(data.getMinuteLook());
+ courseChapter.setSecondLook(data.getSecondLook());
+ courseChapter.setIsOver(data.getIsOver());
+ }
+ int size = courseLearningRecordService
+ .lambdaQuery().eq(CourseLearningRecord::getChapterId, courseChapter.getId())
+ .list().size();
+ courseChapter.setRealLearnedNum(size+courseChapter.getVirtualLearnedNum());
+ }
+ if (byId.getChargeType() == 1&&tokenService.getLoginUser()==null){
+ return R.ok(page);
+ }else{
+ LoginUser loginUser = tokenService.getLoginUser();
+ if (loginUser==null){
+ return R.tokenError("登录失效");
+ }
+ Long userid = loginUser.getUserid();
+ // 新增学习记录
+ CourseLearningRecord one = courseLearningRecordService.lambdaQuery().eq(CourseLearningRecord::getAppUserId, userid)
+ .eq(CourseLearningRecord::getChapterId, chapterId).one();
+ if (one==null){
+ CourseLearningRecord courseLearningRecord = new CourseLearningRecord();
+ courseLearningRecord.setAppUserId(userid);
+ if (byId!=null){
+ courseLearningRecord.setCourseId(byId.getId());
+ }
+ courseLearningRecord.setChapterId(chapterId);
+ courseLearningRecordService.save(courseLearningRecord);
+ }
+
+ return R.ok(page);
+
+ }
+
+ }
+ @PostMapping("/confirmOrder")
+ @ApiOperation(value = "确认订单页面")
+ @ApiImplicitParams({
+ @ApiImplicitParam(value = "课程id", name = "courseId", required = true, dataType = "Long")
+ })
+ public R<Course> confirmOrder(@RequestParam(value = "courseId")Long courseId) {
+ LoginUser loginUser = tokenService.getLoginUser();
+ if (loginUser==null){
+ return R.tokenError("登录失效");
+ }
+ Long userId = loginUser.getUserid();
+
+ Course byId = courseService.getById(courseId);
+ AppUser data = remoteAppUserService.getAppUserById(userId + "").getData();
+ byId.setBalance(data.getBalance());
+ return R.ok(byId);
+ }
+ @PostMapping("/successOrder")
+ @ApiOperation(value = "支付成功页面")
+ @ApiImplicitParams({
+ @ApiImplicitParam(value = "课程id", name = "courseId", required = true, dataType = "Long")
+ })
+ public R<List<Course>> successOrder(@RequestParam(value = "courseId")Long courseId) {
+ LoginUser loginUser = tokenService.getLoginUser();
+ if (loginUser==null){
+ return R.tokenError("登录失效");
+ }
+ Long userId = loginUser.getUserid();
+ Course byId = courseService.getById(courseId);
+ List<Course> list = courseService.lambdaQuery().eq(Course::getCateId, byId.getCateId())
+ .ne(Course::getId,courseId)
+ .eq(Course::getCourseType, 1).list();
+ for (Course course : list) {
+ List<AppUser> data = remoteAppUserService.getUserByCourseId(courseId).getData();
+ course.setCount(data.size()+course.getVirtualLearnedNum());
+ course.setRealLearnedNum(data.size()+course.getVirtualLearnedNum());
+ }
+ List<Course> courses = new ArrayList<>();
+
+ // 如果list集合数据大于2 随机获取两个返回
+ if (CollUtils.isNotEmpty(list) && list.size() > 4) {
+ int size = list.size();
+ int index = (int) (Math.random() * size);
+ for (int i = 0; i < 4; i++) {
+ courses.add(list.get(index));
+ }
+ return R.ok(courses);
+ }else {
+ return R.ok(list);
+ }
+ }
+ @GetMapping("/studyPage")
+ @ApiOperation(value = "学习")
+ public R<StudyPageVO> studyPage() {
+ LoginUser loginUser = tokenService.getLoginUser();
+ if (loginUser==null){
+ return R.tokenError("登录失效");
+ }
+ Long userId = loginUser.getUserid();
+ if(userId ==null || userId == 0)return R.tokenError("登录失效");
+ StudyPageVO studyPageVO = new StudyPageVO();
+ List<CourseVO> courseVOS = new ArrayList<>();
+
+ PageDTO<AppUserCourse> data = remoteAppUserService.getPayCourse(1, 909999,userId+"").getData();
+ List<AppUserCourse> list = data.getList();
+ if (CollUtils.isNotEmpty(list)) {
+ List<Long> courseIds = list.stream().map(AppUserCourse::getCourseId).collect(Collectors.toList());
+ List<Course> page = courseService.lambdaQuery()
+ .in(Course::getId, courseIds)
+ .list();
+ for (Course course : page) {
+ CourseVO courseVO = new CourseVO();
+ BeanUtils.copyProperties(course, courseVO);
+ courseVOS.add(courseVO);
+ studyPageVO.setCourseList(courseVOS);
+ }
+ }
+ // 查询两个相同类型的线上免费课程
+ List<Course> freeCourseList = courseService.lambdaQuery()
+ .eq(Course::getCourseType, 1)
+ .eq(Course::getChargeType, 1)
+ .list();
+ // 远程查询用户观看历史
+ List<Long> data1 = remoteAppUserService.getCourseHistoryByUserId(userId).getData();
+ if (!data1.isEmpty()){
+ // 随机获取两个
+ if (CollUtils.isNotEmpty(freeCourseList) && freeCourseList.size() > 2) {
+ int size = freeCourseList.size();
+ int index = (int) (Math.random() * size);
+ List<Course> courses = new ArrayList<>();
+ for (int i = 0; i < 2; i++) {
+ courses.add(freeCourseList.get(index));
+ }
+ studyPageVO.setFreeCourseList(courses);
+ }else{
+ studyPageVO.setFreeCourseList(freeCourseList);
+ }
+ return R.ok(studyPageVO);
+ }else{
+ List<Course> list1 = courseService.lambdaQuery()
+ .eq(Course::getChargeType, 1)
+ .eq(Course::getListingStatus, 1)
+ .list();
+ if (list1.size()>=2){
+ List<Course> courses = new ArrayList<>();
+ courses.add(list1.get(0));
+ courses.add(list1.get(1));
+ studyPageVO.setFreeCourseList(courses);
+ }else if (list1.size()==1){
+ List<Course> courses = new ArrayList<>();
+ courses.add(list1.get(0));
+ for (Course course : freeCourseList) {
+ if (!course.getId().equals(list1.get(0).getId())){
+ courses.add(course);
+ break;
+ }
+ }
+ studyPageVO.setFreeCourseList(courses);
+ }
+ return R.ok(studyPageVO);
+ }
+
+ }
}
--
Gitblit v1.7.1