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 | 637 ++++++++++++++++++++++++++++++++++++++++++++++++++-------
1 files changed, 550 insertions(+), 87 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 f586f82..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,29 +1,33 @@
package com.xinquan.course.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.query.QueryWrapper;
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.domain.CourseChapter;
+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.CourseCategoryService;
-import com.xinquan.course.service.CourseChapterService;
-import com.xinquan.course.service.CourseService;
-import com.xinquan.course.service.CourseUserFavoriteService;
+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;
@@ -33,13 +37,17 @@
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;
@@ -47,10 +55,13 @@
import java.util.stream.Collectors;
import lombok.RequiredArgsConstructor;
-import org.springframework.data.domain.jaxb.SpringDataJaxb;
+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>
@@ -74,8 +85,79 @@
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
@@ -89,6 +171,137 @@
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) {
@@ -128,23 +341,62 @@
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 = "新增课程管理", notes = "管理后台-课程管理")
+ @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 = "查看详情课程管理", notes = "管理后台-课程管理")
+ @ApiOperation(value = "查看详情课程管理", tags = "管理后台-课程管理")
public R<Course> detailCourse(String uid) {
- return R.ok(courseService.getById(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 = "修改课程上下架状态", notes = "管理后台-课程管理")
+ @ApiOperation(value = "修改课程上下架状态", tags = "管理后台-课程管理")
public R updateState(String uid) {
Course byId = courseService.getById(uid);
if (byId.getListingStatus() == 1){
@@ -152,24 +404,25 @@
}else {
byId.setListingStatus(1);
}
+ courseService.updateById(byId);
return R.ok();
}
@PostMapping("/updateCourse")
- @ApiOperation(value = "修改课程管理", notes = "管理后台-课程管理")
+ @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 = "批量删除", notes = "管理后台-课程管理")
+ @ApiOperation(value = "批量删除", tags = "管理后台-课程管理")
public R deleteCourse(String ids) {
- return R.ok(courseService.removeBatchByIds(Arrays.asList(ids.split(","))));
+ return R.ok(courseService.removeBatchByIds(Arrays.asList(ids.split(",")).stream().map(Long::valueOf).collect(Collectors.toList())));
}
- @PostMapping("/cateList")
+ @GetMapping("/cateList")
public R<List<CourseCategory>> cateList() {
List<CourseCategory> list = courseCategoryService.list();
for (CourseCategory courseCategory : list) {
@@ -198,6 +451,8 @@
}
return R.ok(PageDTO.of(page, Course.class));
}
+ @Autowired
+ private TokenService tokenService;
@PostMapping("/myCollect")
@ApiOperation(value = "我的收藏")
@ApiImplicitParams({
@@ -205,30 +460,66 @@
@ApiImplicitParam(name = "pageCurr", value = "分页参数，当前页码", dataType = "Integer", required = true),
@ApiImplicitParam(name = "pageSize", value = "分页参数，每页数量", dataType = "Integer", required = true)
})
- public R<PageDTO<OrderCourseVO>> myCollect(@RequestParam(value = "state")Integer state,
+ public R<List<OrderCourseVO>> myCollect(@RequestParam(value = "state")Integer state,
@RequestParam(value = "pageCurr")Integer pageCurr,
@RequestParam(value = "pageSize")Integer pageSize) {
- Long userId = SecurityUtils.getUserId();
- if (userId == 0)return R.tokenError("登录失效");
+ 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)
+ 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:
- Page<CourseUserFavorite> page = courseUserFavoriteService.lambdaQuery()
- .eq(CourseUserFavorite::getAppUserId, userId)
- .page(new Page<>(pageCurr, pageSize));
- PageDTO<OrderCourseVO> courseChapterPageDTO = PageDTO.of(page, OrderCourseVO.class);
- for (CourseUserFavorite record : page.getRecords()) {
+ 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();
+ return R.ok(orderCourseVOS);
}
@PostMapping("/collectCourse")
@ApiOperation(value = "收藏/取消课程")
@@ -236,8 +527,11 @@
@ApiImplicitParam(value = "课程id", name = "id", required = true, dataType = "Long"),
})
public R collectCourse(@RequestParam(value = "id")Long id) {
- Long userId = SecurityUtils.getUserId();
- if (userId == 0)return R.tokenError("登录失效");
+ 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();
@@ -260,8 +554,8 @@
*
* @return 课程分类列表
*/
- @PostMapping("/getCourseByCourseId/{courseId}")
- public R<OrderCourseVO> getCourseCategoryList(@RequestBody OrderCourseVO req) {
+ @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){
@@ -311,6 +605,7 @@
* @return 课程详情
*/
+
/**
* 课程详情
*
@@ -322,24 +617,122 @@
@ApiImplicitParam(value = "课程id", name = "id", required = true, dataType = "String"),
})
public R<ClientCourseVO> getPayCourseInfoById(@RequestParam(value = "id")Long id) {
- Long userId = SecurityUtils.getUserId();
- if (userId == 0)return R.tokenError("登录失效");
- AppUserVO data1 = remoteAppUserService.getCurrentUser().getData();
Course byId = courseService.getById(id);
ClientCourseVO clientCourseVO = new ClientCourseVO();
BeanUtils.copyProperties(byId, clientCourseVO);
- if (data1.getVipExpireTime()!=null && data1.getVipExpireTime().isAfter(LocalDateTime.now())){
- clientCourseVO.setIsVip(1);
+ 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{
- clientCourseVO.setIsVip(0);
+ 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();
@@ -351,11 +744,6 @@
clientCourseVO.setHeaders(data.stream().map(AppUser::getAvatar).collect(Collectors.toList()));
}
List<Long> collect = data.stream().map(AppUser::getUserId).collect(Collectors.toList());
- if (!collect.isEmpty()){
- if (collect.contains(userId)){
- clientCourseVO.setIsBuy(1);
- }
- }
}
// 查询推荐课程
List<Course> list = courseService.lambdaQuery().eq(Course::getCateId, byId.getCateId())
@@ -374,11 +762,11 @@
courses.add(list.get(index));
}
}
+ for (Course cours : courses) {
+ List<AppUser> data1 = remoteAppUserService.getUserByCourseId(id).getData();
+ cours.setCount(data1.size());
+ }
clientCourseVO.setList2(courses);
- // 查询是否已收藏课程
- clientCourseVO.setIsCollect(courseUserFavoriteService.lambdaQuery()
- .eq(CourseUserFavorite::getAppUserId, userId)
- .eq(CourseUserFavorite::getCourseId, id) == null ? 2 : 1);
return R.ok(clientCourseVO);
}
@@ -404,51 +792,91 @@
@RequestParam(required = false) Long cateId,
@RequestParam(value = "pageCurr", defaultValue = "1") Integer pageCurr,
@RequestParam(value = "pageSize", defaultValue = "10") Integer pageSize) {
- return R.ok(courseService.getCoursePageList(courseTitle, cateId, pageCurr, 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"),
- @ApiImplicitParam(value = "分页参数，当前页码", name = "pageCurr", required = true, dataType = "Integer"),
- @ApiImplicitParam(value = "分页参数，每页数量", name = "pageSize", required = true, dataType = "Integer")
})
- public R<PageDTO<CourseChapter>> studyPageByChapterId(@RequestParam(value = "chapterId")Long chapterId,
- @RequestParam(value = "pageCurr", defaultValue = "1") Integer pageCurr,
- @RequestParam(value = "pageSize", defaultValue = "10") Integer pageSize) {
+ 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();
// 查询章节
- Page<CourseChapter> page = courseChapterService.lambdaQuery()
+ List<CourseChapter> page = courseChapterService.lambdaQuery()
.eq(CourseChapter::getCourseId, id)
.orderByDesc(CourseChapter::getSortNum)
- .page(new Page<>(pageCurr, pageSize));
- if (CollUtils.isEmpty(page.getRecords())) {
- PageDTO<CourseChapter> empty = PageDTO.empty(page);
- return R.ok(empty);
- }
- PageDTO<CourseChapter> courseChapterPageDTO = PageDTO.of(page, CourseChapter.class);
- if (CollUtils.isNotEmpty(courseChapterPageDTO.getList())) {
- for (CourseChapter courseChapter : courseChapterPageDTO.getList()) {
- AppUserViewingHistory data = remoteAppUserService.getCourseStudyHistory(courseChapter.getId()).getData();
- if (data!=null){
- courseChapter.setMinuteLook(data.getMinuteLook());
- courseChapter.setSecondLook(data.getSecondLook());
- courseChapter.setIsOver(data.getIsOver());
- }
+ .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());
}
- return R.ok();
+ 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> studyPageByChapterId(@RequestParam(value = "courseId")Long courseId) {
- Long userId = SecurityUtils.getUserId();
- if (userId == 0)return R.tokenError("登录失效");
+ 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")
@@ -457,14 +885,19 @@
@ApiImplicitParam(value = "课程id", name = "courseId", required = true, dataType = "Long")
})
public R<List<Course>> successOrder(@RequestParam(value = "courseId")Long courseId) {
- Long userId = SecurityUtils.getUserId();
- if (userId == 0)return R.tokenError("登录失效");
+ 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.setCount(data.size()+course.getVirtualLearnedNum());
+ course.setRealLearnedNum(data.size()+course.getVirtualLearnedNum());
}
List<Course> courses = new ArrayList<>();
@@ -482,14 +915,17 @@
}
@GetMapping("/studyPage")
@ApiOperation(value = "学习")
-
public R<StudyPageVO> studyPage() {
- 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(userId ==null || userId == 0)return R.tokenError("登录失效");
StudyPageVO studyPageVO = new StudyPageVO();
List<CourseVO> courseVOS = new ArrayList<>();
- PageDTO<AppUserCourse> data = remoteAppUserService.getPayCourse(1, 909999).getData();
+ 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());
@@ -508,19 +944,46 @@
.eq(Course::getCourseType, 1)
.eq(Course::getChargeType, 1)
.list();
- // 随机获取两个
- 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));
+ // 远程查询用户观看历史
+ 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);
}
- studyPageVO.setFreeCourseList(courses);
+ return R.ok(studyPageVO);
}else{
- studyPageVO.setFreeCourseList(freeCourseList);
+ 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);
}
- return R.ok(studyPageVO);
+
}
}
--
Gitblit v1.7.1