/*
 *      Copyright (c) 2018-2028, Chill Zhuang All rights reserved.
 *
 *  Redistribution and use in source and binary forms, with or without
 *  modification, are permitted provided that the following conditions are met:
 *
 *  Redistributions of source code must retain the above copyright notice,
 *  this list of conditions and the following disclaimer.
 *  Redistributions in binary form must reproduce the above copyright
 *  notice, this list of conditions and the following disclaimer in the
 *  documentation and/or other materials provided with the distribution.
 *  Neither the name of the dreamlu.net developer nor the names of its
 *  contributors may be used to endorse or promote products derived from
 *  this software without specific prior written permission.
 *  Author: Chill 庄骞 (smallchill@163.com)
 */
package org.springblade.modules.exam.mapper;

import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import com.baomidou.mybatisplus.core.metadata.IPage;
import org.apache.ibatis.annotations.Param;
import org.springblade.modules.apply.entity.Apply;
import org.springblade.modules.exam.entity.ExamExaminationSubject;
import org.springblade.modules.exam.entity.ExamPaper;
import org.springblade.modules.exam.entity.ExamSubjectChoices;
import org.springblade.modules.exam.vo.*;
import org.springblade.modules.training.entity.TrainingRegistration;

import java.util.List;

/**
 * Mapper 接口
 *
 * @author Chill
 */
public interface ExamPaperMapper extends BaseMapper<ExamPaper> {

	IPage<ExamPaperVO> selectExamPaperPages(IPage page, ExamPaperVO exam);


	/**
	 * 自定义查询
 	 * @param page 分页条件
	 * @param examPaperVO 查询参数
	 * @return
	 */
	IPage<ExamPaperVO> selectExamPaperPage(IPage page, @Param("paper")ExamPaperVO examPaperVO);

	ExamPaperSubjectVO queryPagerSubject(@Param("paper") ExamPaper paper);

	List<ExamSubjectChoicesVO> queryRandomSubject(@Param("paper") ExamPaper paper);

	ExamPaperSubjectVO PagerSubject(@Param("paper") ExamPaper paper);

	/**
	 * 自定义树
	 *
	 * @param examPaper 试卷对象
	 * @return
	 */
	List<ExamPaper> selectExamPaperPageTree(@Param("paper") ExamPaper examPaper);

	boolean UnbindSubject(String paperid, String subjectid);

	/**
	 * 查询考生考试信息
	 * @param examPaper 用户id
	 * @return
	 */
    List<ExamPaperVO> getExamDetail(@Param("examPaper") ExamPaperVO examPaper);

	/**
	 * 查询是当前前缀已生成准考证号码最大的一位
	 * @param result 前缀
	 * @return
	 */
	int getCandidateNoCount(String result);

	/**
	 * 查询当前考试已报名的人员培训报名数据集合
	 * @param id 考试id
	 * @return
	 */
	List<TrainingRegistration> getTrainList(@Param("id") Long id);

	/**
	 * 使用考试名称匹配考试信息
	 * @param examName 考试名称
	 * @return
	 */
	List<ExamPaper> getExamInfoByExamName(@Param("examName") String examName);

	/**
	 * 查询每个考试的报名人员数量
	 * @param examPaperVO1
	 * @return
	 */
	Integer getApplyNumber(@Param("examPaper")ExamPaperVO examPaperVO1);

	/**
	 * 查询每个考试的报名人员数量 模拟考试
	 * @param examPaperVO1
	 * @return
	 */
	Integer getTrainNumber(@Param("examPaper")ExamPaperVO examPaperVO1);

	/**
	 * 根据用户id查询报名信息
	 * @param userId 用户id
	 * @return
	 */
	List<Apply> getApplyDetail(@Param("userId")String userId);

	/**
	 * 查询当前人员当前考试的考试题目信息
	 * @param examPaperVO
	 * @return
	 */
	List<ExamSubjectChoicesVO> getExaminationSubjectList(@Param("examPaper")ExamPaperVO examPaperVO);

	/**
	 * 批量新增
	 * @param list
	 */
    void insertBatch(@Param("list")List<ExamExaminationSubject> list);

	/**
	 * 查询报名人数
	 * @param examPaperVO1
	 * @return
	 */
	Integer getExamNumber(@Param("examPaper") ExamPaperVO examPaperVO1);

	/**
	 * 查询考试统计信息
	 * @param examPaper
	 * @param page
	 * @return
	 */
	List<ExamStatisticsVO> getExamStatistics(@Param("page") IPage<ExamStatisticsVO> page,@Param("examPaper") ExamPaperVO examPaper);

	/**
	 * 根据考试id 统计查询考试信息
	 * @param examPaperVO
	 * @return
	 */
	List<ExamStatisticsVO> getExamInfoByExamId(@Param("page") IPage<ExamStatisticsVO> page,@Param("examPaper") ExamStatisticsVO examPaperVO);

	/**
	 * 根据考试id 统计查询考试信息
	 * @param examScoreVO
	 * @return
	 */
	List<ExamStatisticsVO> getExamInfoByExamIdList(@Param("examPaper") ExamScoreVO examScoreVO);

	/**
	 * 查询考试成绩明细
	 * @param examScoreVO
	 * @return
	 */
	List<ExamScoreVO> getExamScoreList(@Param("examScore") ExamScoreVO examScoreVO);

	/**
	 * 取出随机的题目
	 * @param list
	 * @param number 取出的数量
	 * @return
	 */
	List<ExamSubjectChoicesVO> queryRandomSubjectList(@Param("list") List<String> list,@Param("number") Integer number);

	/**
	 * 模拟考试随机抽题，未缴费人员
	 * @return
	 */
	List<ExamSubjectChoicesVO> simulateQueryRandomSubjectList();

    List<ExamPaperVO> getList(@Param("vo") ExamPaperVO examPaperVO);

	ExamPaperVO getLatest(@Param("vo") ExamPaperVO examPaperVO);
}