package com.gkhy.exam.system.mapper;

import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import com.gkhy.exam.system.domain.ExPhaseStudent;
import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Param;

import java.util.List;

/**
 * <p>
 * 课时批次与学员关系表 Mapper 接口
 * </p>
 *
 * @author kzy
 * @since 2024-06-06 13:53:17
 */
@Mapper
public interface ExPhaseStudentMapper extends BaseMapper<ExPhaseStudent> {
    /**
     * 批量绑定学员
     * @param phaseStudents
     * @return
     */
    public int batchInsert(List<ExPhaseStudent> phaseStudents);

    /**
     * 根据批次id统计学员人数
     * @param phaseId
     * @return
     */
    public int countByPhaseId(Long phaseId);

    /**
     * 根据id查询批次与学员关系
     * @param phaseStudentId
     * @return
     */
    public ExPhaseStudent selectPhaseStudentById(Long phaseStudentId);

    /**
     * 分页获取批次下面的学员
     * @param phaseStudent
     * @return
     */
    public List<ExPhaseStudent> selectPhaseStudentList(ExPhaseStudent phaseStudent);

    /**
     * 查询数量
     * @param phaseId
     * @param studentId
     * @return
     */
    Integer selectCountByPhaseStudentId(@Param("phaseId") Long phaseId, @Param("studentId")Long studentId);

    /**
     * 根据学员id获取学员批次分配列表
     * @param studentId
     * @return
     */
    public List<ExPhaseStudent> selectPhaseStudentByStudentId(Long studentId);
}