CourseDictMapper.java

package com.subsidy.mapper;

import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import com.baomidou.mybatisplus.core.metadata.IPage;
import com.subsidy.model.ClassMemberMappingDO;
import com.subsidy.model.CourseDictDO;
import com.subsidy.vo.course.QueryCoursesVO;
import com.subsidy.vo.member.StudyPageVO;
import org.springframework.data.repository.query.Param;
import org.springframework.stereotype.Repository;

import java.util.List;

/**
 * <p>
 * Mapper 接口
 * </p>
 *
 * @author DengMin
 * @since 2021-10-11
 */
@Repository
public interface CourseDictMapper extends BaseMapper<CourseDictDO> {

    /**
     * 运营者查询全部课程
     * courseName fieldId categoryId jobId courseRank courseType
     * @return
     */
    IPage<QueryCoursesVO > queryCourses(IPage page, String courseName, Long fieldId,Long categoryId,Long jobId,Long rankId, String courseType,Long companyId,String openStatus,Long businessId,Integer courseDataType);

    /**
     * 通过课程id查询课程下的学生-----弃用
     */
    List<ClassMemberMappingDO > queryCourseMember(StudyPageVO studyPageVO);

    /**
     * 查询全部公共课程
     * @return
     */
    IPage<QueryCoursesVO > queryPublicCourses(IPage page, String courseName, Long categoryId, String courseType, String  courseSource);

    /**
     * 查看课程下有多少课时
     */
    Integer queryCourseCnt(Long courseId);

    /**
     * 查看课程学习总时长
     */
    Integer queryCoursePlayLength(Long courseId);

    /**
     * 修改课程的开放状态
     */
    void updateOpenStatus(CourseDictDO courseDictDO);


    List<CourseDictDO> getListByVodId(@Param("vodId") Long vodId);
}