谷粒学院（十一）课程最终发布 | 课程列表 | 阿里云视频点播服务 | 小节实现视频上传（二）

//对课程进行分页查询
@Override
public Page <EduCourse> pageQuery(Integer current, Integer limit, CourseQuery courseQuery) {
    Page <EduCourse> page = new Page <>(current,limit);
    QueryWrapper <EduCourse> wrapper = new QueryWrapper <>();
    String title = courseQuery.getTitle();
    String subjectId = courseQuery.getSubjectId();
    String subjectParentId = courseQuery.getSubjectParentId();
    String teacherId = courseQuery.getTeacherId();
    //判空,构造查询条件
    if(!StringUtils.isEmpty(title)){
        wrapper.like("title",title);
    }
    if(!StringUtils.isEmpty(subjectId)){
        wrapper.eq("subject_id",subjectId);
    }
    if(!StringUtils.isEmpty(subjectParentId)){
        wrapper.eq("subject_parent_id",subjectParentId);
    }
    if(!StringUtils.isEmpty(teacherId)){
        wrapper.eq("teacher_id",teacherId);
    }
    wrapper.orderByDesc("gmt_create");
    //进行分页查询
    this.baseMapper.selectPage(page, wrapper);//分页查询后自动封装到page中
    return page;
}

//根据id删除课程信息
@Override
public void removeCourse(String id) {
    //1.删除小节
    videoService.removeVideoByCourseId(id);
    //2.删除章节
    chapterService.removeChapterByCourseId(id);
    //3.删除课程描述信息
    courseDescriptionService.removeById(id);
    //4.删除课程信息
    this.baseMapper.deleteById(id);
}

//删除课程
removeCourse(id) {
    return request({
        url: `/eduservice/course/removeCourse/${id}`,
        method: 'delete'
    })
},
//分页查询课程
pageQuery(current, limit, courseQuery) {
    return request({
        url: `/eduservice/course/pageQuery/${current}/${limit}`,
        method: 'post',
        data: courseQuery
    })
}

<style scoped>
.myClassList .info {
    width: 450px;
    overflow: hidden;
}
.myClassList .info .pic {
    width: 150px;
    height: 90px;
    overflow: hidden;
    float: left;
}
.myClassList .info .pic a {
    display: block;
    width: 100%;
    height: 100%;
    margin: 0;
    padding: 0;
}
.myClassList .info .pic img {
    display: block;
    width: 100%;
}
.myClassList td .info .title {
    width: 280px;
    float: right;
    height: 90px;
}
.myClassList td .info .title a {
    display: block;
    height: 48px;
    line-height: 24px;
    overflow: hidden;
    color: #00baf2;
    margin-bottom: 12px;
}
.myClassList td .info .title p {
    line-height: 20px;
    margin-top: 5px;
    color: #818181;
}
</style>

<script>
import course from '@/api/edu/course'
import subject from '@/api/edu/subject'
export default {

    data() {
      return {
        listLoading: false, // 是否显示loading信息
        list: null, // 数据列表
        total: 0, // 总记录数
        page: 1, // 页码
        limit: 10, // 每页记录数
        searchObj: {
          subjectParentId: '',
          subjectId: '',
          title: '',
          teacherId: ''
        }, // 查询条件
        teacherList: [], // 讲师列表
        subjectNestedList: [], // 一级分类列表
        subSubjectList: [] // 二级分类列表,
      }
    },
    created() {
      this.init()
    },
    methods: {
        //编辑课程大纲
        updateChapter(id){
          this.$router.push({path:'/course/chapter/'+id})
        },
        //编辑课程基本信息
        updateCourse(id){
          this.$router.push({path:'/course/info/'+id})
        },
        removeCourse(id){
            this.$confirm('此操作将永久删除该课程的所有内容,是否继续?','提示',{
            confirmButtonText:'确定',
            cancelButtonText:'取消',
            type:'warning'
          }).then(()=>{//点击确定
              course.removeCourse(id).then((response)=>{
                this.$message({
                  type:'success',
                  message:'删除成功!' 
                }) 
                //回到列表页面
                this.getList()
              }).catch(()=>{
                this.$message({
                  type:'error',
                  message:'删除失败!' 
                }) 
              })
          }).catch(() => { // 点击取消
              this.$message({
                  type: 'info',
                  message: '已取消删除!'
              })
           })
        },
        //分页+条件查询
        getList(page = 1){//page默认值为1,当使用分页组件时会传入新的page参数
          this.page = page
          course.pageQuery(this.page,this.limit,this.searchObj).then(response=>{
            this.list = response.data.list
            this.total = response.data.total
          })
        },
      //查询表单重置方法
        resetData(){
          this.searchObj = {},
          this.subSubjectList = []
        },
        //当一级分类下拉菜单改变时的方法
        subjectLevelOneChanged(id){
          // console.log(id);
          for(var i = 0;i < this.subjectNestedList.length;i++){
            if(this.subjectNestedList[i].id == id){
              this.subSubjectList = this.subjectNestedList[i].children
            }
          }
        },
        //初始化方法
        init(){
          //1.查询一级分类
          subject.getAllSubject().then(response=>{
            this.subjectNestedList = response.data.list
          })
          //2.查询所有讲师
          course.getTeacherList().then(response=>{
            this.teacherList = response.data.items
          })
          //3.查询课程列表
          this.getList()
        }
    }
}
</script>