无关风月
2025-02-28 dd663d0ac783755d889e270eee57ee58630c88c8
xinquan-modules/xinquan-course/src/main/java/com/xinquan/course/controller/client/ClientCourseController.java
@@ -5,6 +5,7 @@
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.plugins.pagination.Page;
import com.xinquan.common.core.constant.SecurityConstants;
import com.xinquan.common.core.domain.R;
@@ -313,7 +314,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());
@@ -342,18 +343,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));
    }
@@ -374,22 +374,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();
@@ -411,9 +408,15 @@
    @PostMapping("/updateCourse")
    @ApiOperation(value = "修改课程管理", tags = "管理后台-课程管理")
    public R updateCourse(@RequestBody Course homeBackgroundMusic) {
        LambdaUpdateWrapper<Course> courseLambdaUpdateWrapper = new LambdaUpdateWrapper<>();
        courseLambdaUpdateWrapper.eq(Course::getId, homeBackgroundMusic.getId());
        courseLambdaUpdateWrapper.set(Course::getDetailUrl, homeBackgroundMusic.getDetailUrl());
        courseLambdaUpdateWrapper.set(Course::getDetailName, homeBackgroundMusic.getDetailName());
        courseService.update(homeBackgroundMusic, courseLambdaUpdateWrapper);
        homeBackgroundMusic.setUpdateBy(SecurityUtils.getUsername());
        homeBackgroundMusic.setUpdateTime(LocalDateTime.now());
        return R.ok(courseService.updateById(homeBackgroundMusic));
        courseService.updateById(homeBackgroundMusic);
        return R.ok();
    }
    @PostMapping("/deleteCourse")
    @ApiOperation(value = "批量删除", tags = "管理后台-课程管理")
@@ -507,16 +510,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;
@@ -619,7 +621,6 @@
            @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);
@@ -645,6 +646,12 @@
                clientCourseVO.setIsVip(1);
            }else{
                clientCourseVO.setIsVip(0);
            }
            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())
@@ -720,6 +727,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<>();
        // 随机获取两个课程
@@ -728,10 +737,10 @@
            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) {
@@ -787,6 +796,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<>();
        // 随机获取两个课程
@@ -942,6 +953,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) {
@@ -1004,7 +1016,10 @@
                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();
@@ -1027,7 +1042,10 @@
                courseVO.setVirtualLearnedNum(0);
                courseVO.setId(byId.getId());
                courseVO.setCoverUrl(byId.getCoverUrl());
                courseVOS.add(courseVO);
                List<Long> collect = courseVOS.stream().map(CourseVO::getId).collect(Collectors.toList());
                if (!collect.contains(courseVO.getId())){
                    courseVOS.add(courseVO);
                }
            }
        }
        // 查询两个相同类型的线上免费课程
@@ -1091,7 +1109,10 @@
                    courseVO.setVirtualLearnedNum(0);
                    courseVO.setId(byId.getId());
                    courseVO.setCoverUrl(byId.getCoverUrl());
                    courseVOS.add(courseVO);
                    List<Long> collect = courseVOS.stream().map(CourseVO::getId).collect(Collectors.toList());
                    if (!collect.contains(courseVO.getId())){
                        courseVOS.add(courseVO);
                    }
                }
            }
            studyPageVO.setCourseList(courseVOS);