package com.ycl.jxkg.mapper;

import com.ycl.jxkg.domain.entity.ClassesUser;
import com.baomidou.mybatisplus.core.metadata.IPage;
import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import com.ycl.jxkg.domain.entity.User;
import com.ycl.jxkg.domain.query.ClassesUserQuery;
import com.ycl.jxkg.domain.vo.ClassesUserVO;
import com.ycl.jxkg.domain.form.ClassesUserForm;
import java.util.List;

import com.ycl.jxkg.domain.vo.StudentExamInfoVO;
import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Param;

/**
 * 班级与用户关联表 Mapper 接口
 *
 * @author xp
 * @since 2024-06-04
 */
@Mapper
public interface ClassesUserMapper extends BaseMapper<ClassesUser> {

    /**
     * id查找班级与用户关联表
     * @param id
     * @return
     */
    ClassesUserVO getById(Integer id);

    /**
    *  分页
    */
    IPage getPage(IPage page, @Param("query") ClassesUserQuery query);

    /**
     * 获取班级学生
     *
     * @param classesId
     * @return
     */
    List<StudentExamInfoVO> getClassesUserList(@Param("classesId") Integer classesId);

    /**
     * 根据学生获取班级
     *
     * @param userId
     * @return
     */
    List<Integer> getClassesByUserId(@Param("userId") Integer userId);
}