From 99367ea1c11a68b420936e7f7db5fa7367da4f44 Mon Sep 17 00:00:00 2001
From: 无关风月 <443237572@qq.com>
Date: 星期三, 22 一月 2025 11:44:54 +0800
Subject: [PATCH] 全部代码、数据库提交
---
xinquan-modules/xinquan-course/src/main/java/com/xinquan/course/controller/client/ClientCourseController.java | 225 +++++++++++++++++++++++++++++++++++++++++--------------
1 files changed, 166 insertions(+), 59 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 b42493d..fb64539 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
@@ -45,6 +45,7 @@
import io.swagger.annotations.ApiOperation;
import java.io.IOException;
+import java.math.BigDecimal;
import java.net.URLEncoder;
import java.time.LocalDateTime;
import java.time.format.DateTimeFormatter;
@@ -312,7 +313,7 @@
.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);
+ .orderByDesc(Course::getCreateTime);
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());
@@ -341,18 +342,17 @@
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;
+ int a = 0;
+ int b = 0;
for (CourseChapter courseChapter : list) {
- temp+=courseChapter.getVirtualLearnedNum();
+ a+= courseChapter.getVirtualLearnedNum();
+ Long data1 = remoteAppUserService.getCourseChapterHistoryCount(courseChapter.getId()).getData();
+ b+=data1;
+ courseChapter.setRealLearnedNum(Integer.valueOf(data1+""));
}
- record.setCount(size1+temp);
+ record.setCount(a+b);
}
return R.ok(PageDTO.of(page, Course.class));
}
@@ -373,22 +373,19 @@
}
List<CourseChapter> list = courseChapterService.lambdaQuery()
.eq(CourseChapter::getCourseId, uid).list();
- int temp = 0;
- int temp1 = 0;
+
+ int a = 0;
+ int b = 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;
+ a+= courseChapter.getVirtualLearnedNum();
+ Long data1 = remoteAppUserService.getCourseChapterHistoryCount(courseChapter.getId()).getData();
+ b+=data1;
+ courseChapter.setRealLearnedNum(Integer.valueOf(data1+""));
}
- int size1 = courseLearningRecordService.lambdaQuery()
- .eq(CourseLearningRecord::getCourseId, uid).groupBy(CourseLearningRecord::getAppUserId)
- .list().size();
- byId.setVirtualLearnedNum(temp);
- byId.setRealLearnedNum(size1);
- byId.setCount(temp+size1);
+
+ byId.setVirtualLearnedNum(a);
+ byId.setRealLearnedNum(b);
+ byId.setCount(a+b);
byId.setList(list);
int size = courseUserFavoriteService.lambdaQuery()
.eq(CourseUserFavorite::getCourseId, uid).list().size();
@@ -506,16 +503,15 @@
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 ;
+ int temp1 = 0 ;
for (CourseChapter courseChapter : list) {
temp+= courseChapter.getVirtualLearnedNum();
+ Long data2 = remoteAppUserService.getCourseChapterHistoryCount(courseChapter.getId()).getData();
+ temp1+=data2;
}
- int size = courseLearningRecordService.lambdaQuery().eq(CourseLearningRecord::getCourseId, record.getId())
- .groupBy(CourseLearningRecord::getAppUserId).list().size();
- orderCourseVO.setCount(temp+size);
+ orderCourseVO.setCount(temp+temp1);
orderCourseVOS.add(orderCourseVO);
}
break;
@@ -618,10 +614,10 @@
@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);
+ clientCourseVO.setIsBuy(2);
List<AppUser> data = remoteAppUserService.getUserByCourseId(id).getData();
if (byId.getChargeType()==1 && tokenService.getLoginUser()==null){
if (data!=null){
@@ -644,9 +640,38 @@
}else{
clientCourseVO.setIsVip(0);
}
- // 查询学习人数和头像列表
- if (data!=null){
+ List<Long> collect9 = data.stream().map(AppUser::getId).collect(Collectors.toList());
+ if (!collect9.isEmpty()){
+ if (collect9.contains(userId)){
+ clientCourseVO.setIsBuy(1);
+ }
+ }
+ if(byId.getChargeType() != 1){
+ List<CourseChapter> list = courseChapterService.lambdaQuery().eq(CourseChapter::getCourseId, byId.getId())
+ .list();
+ // 累加实际学习人数
+ int a = 0;
+ int b = 0;
+ for (CourseChapter courseChapter : list) {
+ Long data2 = remoteAppUserService.getCourseChapterHistoryCount(courseChapter.getId()).getData();
+ a+=data2;
+ b+=courseChapter.getVirtualLearnedNum();
+ }
+ clientCourseVO.setCount(a+b);
+ }else if (data!=null){
+ // 查询学习人数和头像列表
clientCourseVO.setCount(data.size());
+ List<CourseChapter> list = courseChapterService.lambdaQuery().eq(CourseChapter::getCourseId, byId.getId())
+ .list();
+ // 累加实际学习人数
+ int a = 0;
+ int b = 0;
+ for (CourseChapter courseChapter : list) {
+ Long data2 = remoteAppUserService.getCourseChapterHistoryCount(courseChapter.getId()).getData();
+ a+=data2;
+ b+=courseChapter.getVirtualLearnedNum();
+ }
+ clientCourseVO.setCount(a+b);
if (data.size()>=5){
clientCourseVO.setHeaders(data.stream().limit(5).map(AppUser::getAvatar).collect(Collectors.toList()));
}else{
@@ -658,6 +683,7 @@
clientCourseVO.setIsBuy(1);
}
}
+
}
// 查询是否已收藏课程
clientCourseVO.setIsCollect(courseUserFavoriteService.lambdaQuery()
@@ -673,18 +699,29 @@
.orderByDesc(CourseChapter::getSortNum)
.list();
for (CourseChapter courseChapter : page) {
- int size = courseLearningRecordService.lambdaQuery()
- .eq(CourseLearningRecord::getChapterId, courseChapter.getId())
- .list().size();
- courseChapter.setRealLearnedNum(size+courseChapter.getVirtualLearnedNum());
+ // 累加实际学习人数
+ int a = 0;
+ int b = 0;
+ Long data2 = remoteAppUserService.getCourseChapterHistoryCount(courseChapter.getId()).getData();
+ a+=data2;
+ b+=courseChapter.getVirtualLearnedNum();
+ courseChapter.setRealLearnedNum(a);
+ courseChapter.setVirtualLearnedNum(b);
+ LoginUser loginUser = tokenService.getLoginUser();
+ if (loginUser!=null){
+ Integer data1 = remoteAppUserService.getCourseChapterHistoryState(loginUser.getUserid(), courseChapter.getId()).getData();
+ courseChapter.setIsOver(data1);
+ }else{
+ courseChapter.setIsOver(2);
+ }
}
clientCourseVO.setList(page);
- clientCourseVO.setIsBuy(2);
-
// 查询推荐课程
List<Course> list = courseService.lambdaQuery().eq(Course::getCateId, byId.getCateId())
.eq(Course::getCourseType,1)
+ .eq(Course::getListingStatus,1)
+ .ne(Course::getId,id)
.eq(Course::getRecommend, 1).list();
List<Course> courses = new ArrayList<>();
// 随机获取两个课程
@@ -693,18 +730,21 @@
int index = (int) (Math.random() * size);
if (size >= 2){
for (int i = 0; i < 2; i++) {
- courses.add(list.get(index));
+ courses.add(list.get(i));
}
}else{
- courses.add(list.get(index));
+ courses.addAll(list);
}
}
for (Course cours : courses) {
List<AppUser> data3 = remoteAppUserService.getUserByCourseId(id).getData();
cours.setCount(data3.size());
}
- clientCourseVO.setList2(courses);
+ clientCourseVO.setList2(courses);
+ if (byId.getChargeType() == 1){
+ byId.setGeneralPrice(new BigDecimal("0"));
+ }
return R.ok(clientCourseVO);
}
/**
@@ -749,6 +789,8 @@
// 查询推荐课程
List<Course> list = courseService.lambdaQuery().eq(Course::getCateId, byId.getCateId())
.eq(Course::getCourseType,1)
+ .eq(Course::getListingStatus,1)
+ .ne(Course::getId,id)
.eq(Course::getRecommend, 1).list();
List<Course> courses = new ArrayList<>();
// 随机获取两个课程
@@ -768,6 +810,9 @@
cours.setCount(data1.size());
}
clientCourseVO.setList2(courses);
+ if (byId.getChargeType() == 1){
+ byId.setGeneralPrice(new BigDecimal("0"));
+ }
return R.ok(clientCourseVO);
}
@@ -881,6 +926,11 @@
Course byId = courseService.getById(courseId);
AppUser data = remoteAppUserService.getAppUserById(userId + "").getData();
byId.setBalance(data.getBalance());
+ System.err.println("课程类型"+byId.getChargeType());
+ if (byId.getChargeType() == 1){
+ byId.setGeneralPrice(new BigDecimal("0"));
+ }
+ System.err.println("返回数据"+byId);
return R.ok(byId);
}
@PostMapping("/successOrder")
@@ -896,6 +946,7 @@
Long userId = loginUser.getUserid();
Course byId = courseService.getById(courseId);
List<Course> list = courseService.lambdaQuery().eq(Course::getCateId, byId.getCateId())
+ .eq(Course::getListingStatus,1)
.ne(Course::getId,courseId)
.eq(Course::getCourseType, 1).list();
for (Course course : list) {
@@ -958,7 +1009,36 @@
course.setRealLearnedNum(a+b);
course.setVirtualLearnedNum(0);
BeanUtils.copyProperties(course, courseVO);
- courseVOS.add(courseVO);
+ List<Long> collect = courseVOS.stream().map(CourseVO::getId).collect(Collectors.toList());
+ if (!collect.contains(courseVO.getId())){
+ courseVOS.add(courseVO);
+ }
+ }
+ }
+ List<Long> data1 = remoteAppUserService.getCourseHistoryByUserId(userId).getData();
+ for (Long l : data1) {
+ CourseChapter byId1 = courseChapterService.getById(l);
+ Course byId = courseService.getById(byId1.getCourseId());
+ if (byId!=null){
+ CourseVO courseVO = new CourseVO();
+ BeanUtils.copyProperties(byId, courseVO);
+ List<CourseChapter> list1 = courseChapterService.lambdaQuery().eq(CourseChapter::getCourseId, byId1.getCourseId()).list();
+ int a = 0;
+ int b = 0;
+ for (CourseChapter courseChapter : list1) {
+ a+= courseChapter.getVirtualLearnedNum();
+ Long data2 = remoteAppUserService.getCourseChapterHistoryCount(courseChapter.getId()).getData();
+ b+=data2;
+ }
+ courseVO.setCount(a+b);
+ courseVO.setRealLearnedNum(a+b);
+ courseVO.setVirtualLearnedNum(0);
+ courseVO.setId(byId.getId());
+ courseVO.setCoverUrl(byId.getCoverUrl());
+ List<Long> collect = courseVOS.stream().map(CourseVO::getId).collect(Collectors.toList());
+ if (!collect.contains(courseVO.getId())){
+ courseVOS.add(courseVO);
+ }
}
}
// 查询两个相同类型的线上免费课程
@@ -967,12 +1047,9 @@
.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 (Course cours : freeCourseList) {
List<CourseChapter> list1 = courseChapterService.lambdaQuery().eq(CourseChapter::getCourseId, cours.getId()).list();
@@ -988,7 +1065,7 @@
cours.setVirtualLearnedNum(0);
}
for (int i = 0; i < 2; i++) {
- courses.add(freeCourseList.get(index));
+ courses.add(freeCourseList.get(i));
}
studyPageVO.setFreeCourseList(courses);
}else{
@@ -1009,20 +1086,27 @@
for (Long l : data1) {
CourseChapter byId1 = courseChapterService.getById(l);
Course byId = courseService.getById(byId1.getCourseId());
- CourseVO courseVO = new CourseVO();
- BeanUtils.copyProperties(byId, courseVO);
- List<CourseChapter> list1 = courseChapterService.lambdaQuery().eq(CourseChapter::getCourseId, byId1.getCourseId()).list();
- int a = 0;
- int b = 0;
- for (CourseChapter courseChapter : list1) {
- a+= courseChapter.getVirtualLearnedNum();
- Long data2 = remoteAppUserService.getCourseChapterHistoryCount(courseChapter.getId()).getData();
- b+=data2;
+ if (byId!=null){
+ CourseVO courseVO = new CourseVO();
+ BeanUtils.copyProperties(byId, courseVO);
+ List<CourseChapter> list1 = courseChapterService.lambdaQuery().eq(CourseChapter::getCourseId, byId1.getCourseId()).list();
+ int a = 0;
+ int b = 0;
+ for (CourseChapter courseChapter : list1) {
+ a+= courseChapter.getVirtualLearnedNum();
+ Long data2 = remoteAppUserService.getCourseChapterHistoryCount(courseChapter.getId()).getData();
+ b+=data2;
+ }
+ courseVO.setCount(a+b);
+ courseVO.setRealLearnedNum(a+b);
+ courseVO.setVirtualLearnedNum(0);
+ courseVO.setId(byId.getId());
+ courseVO.setCoverUrl(byId.getCoverUrl());
+ List<Long> collect = courseVOS.stream().map(CourseVO::getId).collect(Collectors.toList());
+ if (!collect.contains(courseVO.getId())){
+ courseVOS.add(courseVO);
+ }
}
- courseVO.setCount(a+b);
- courseVO.setRealLearnedNum(a+b);
- courseVO.setVirtualLearnedNum(0);
- courseVOS.add(courseVO);
}
studyPageVO.setCourseList(courseVOS);
return R.ok(studyPageVO);
@@ -1035,6 +1119,18 @@
List<Course> courses = new ArrayList<>();
courses.add(list1.get(0));
courses.add(list1.get(1));
+ for (Course cours : courses) {
+ List<CourseChapter> list3 = courseChapterService.lambdaQuery().eq(CourseChapter::getCourseId, cours.getId()).list();
+ int a = 0;
+ int b = 0;
+ for (CourseChapter courseChapter : list3) {
+ a+= courseChapter.getVirtualLearnedNum();
+ Long data2 = remoteAppUserService.getCourseChapterHistoryCount(courseChapter.getId()).getData();
+ b+=data2;
+ }
+ cours.setCount(a+b);
+ cours.setRealLearnedNum(a+b);
+ }
studyPageVO.setFreeCourseList(courses);
}else if (list1.size()==1){
List<Course> courses = new ArrayList<>();
@@ -1045,10 +1141,21 @@
break;
}
}
+ for (Course cours : courses) {
+ List<CourseChapter> list3 = courseChapterService.lambdaQuery().eq(CourseChapter::getCourseId, cours.getId()).list();
+ int a = 0;
+ int b = 0;
+ for (CourseChapter courseChapter : list3) {
+ a+= courseChapter.getVirtualLearnedNum();
+ Long data2 = remoteAppUserService.getCourseChapterHistoryCount(courseChapter.getId()).getData();
+ b+=data2;
+ }
+ cours.setCount(a+b);
+ cours.setRealLearnedNum(a+b);
+ }
studyPageVO.setFreeCourseList(courses);
}
studyPageVO.setCourseList(courseVOS);
-
return R.ok(studyPageVO);
}
--
Gitblit v1.7.1