package com.mindskip.xzs.repository;

import com.mindskip.xzs.domain.QuestionSubject;
import com.mindskip.xzs.domain.vo.QuestionVO;
import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Param;

import java.util.List;

@Mapper
public interface QuestionSubjectMapper extends BaseMapper<QuestionSubject>{

    /**
     * 批量删除
     * @param ids
     * @return
     */
    Integer removes(@Param("ids") Integer[] ids);

    /**
     *
     * @return
     */
    List<QuestionSubject> getQuestion(Integer id);

    Integer saves(List<QuestionSubject> list);

    Integer removeQuestionId(Integer questionId);

    Integer removeSubjectId(Integer subjectId);

    List<QuestionSubject> getSubject(Integer id);

    /** 统计课目的题目数 */
    Integer countQuestionNum(@Param("subjects") List<Integer> subjects);

    /** 随机题目 */
    List<QuestionVO> getRandomQuestionId(@Param("subjectIds") List<Integer> subjectIds, @Param("questionType") Integer questionType, @Param("questionNum") Integer questionNum);

    /** 查询题目ID，根据课目ids */
    List<Integer> questionsBySubjectIds(@Param("subjectIds") List<Integer> subjectIds);

    /** 查询题目ID根据课目id */
    List<Integer> questionsBySubjectId(Integer subjectId);

    /** 根据课目和题型查询题目ID */
    List<Integer> questionsBySubjectIdAndQuestionType(@Param("subjectId") Integer subjectId, @Param("questionType") Integer questionType);
}