package org.springblade.modules.exam.mapper;

import com.baomidou.mybatisplus.annotation.SqlParser;
import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import com.baomidou.mybatisplus.core.metadata.IPage;
import org.apache.ibatis.annotations.Param;
import org.springblade.modules.exam.entity.ExamScore;
import org.springblade.modules.exam.excel.ExportExamScoreExcel;
import org.springblade.modules.exam.vo.ExamScoreVO;
import org.springblade.modules.exam.vo.ExamSocreStatis;
import org.springblade.modules.information.entity.Information;
import org.springblade.modules.information.vo.InformationVO;
import org.springblade.modules.system.vo.UserVO;
import org.springblade.modules.training.entity.TrainingRegistration;

import java.util.List;
import java.util.Map;

/**
 * 考试成绩Mapper 接口
 * @author zhongrj
 */
public interface ExamScoreMapper extends BaseMapper<ExamScore> {


	/**
	 * 自定义分页
	 *
	 * @param page  分页
	 * @param examScore 实体
	 * @return
	 */
	List<ExamScoreVO> selectExamScorePage(IPage page, @Param("examScore") ExamScoreVO examScore);

	/**
	 * 自定义分页-模拟考试
	 *
	 * @param page  分页
	 * @param examScore 实体
	 * @return
	 */
	@SqlParser(filter = true)
	List<ExamScoreVO> selectTrainExamScorePage(IPage page, @Param("examScore") ExamScoreVO examScore);

	/**
	 * 详情
	 *
	 * @param examScore 考试成绩信息对象
	 */
	ExamScoreVO selectExamScoreInfo(@Param("examScore") ExamScore examScore);

	/**
	 * 根据身份证号导入实操成绩
	 * @param idCardNo 身份证号
	 * @return
	 */
	List<ExamScore> getExamScoreInfoByIdCardNo(@Param("idCardNo")String idCardNo,@Param("startTime")String startTime);

	List<Map<String,Object>> scoreStatistics(String deptid,String jurisdiction);
	List<Map<String,Object>> scoreStatisticssc(String deptid,String jurisdiction);

	/**
	 * 修改成绩信息
	 * @param examScore
	 * @return
	 */

    int updateByIdAndQualifiee(@Param("examScore") ExamScore examScore);
	/**
	 * 自定义分页
	 *
	 * @param page  分页
	 * @return
	 */
	List<ExamScoreVO> scorePage(IPage page,@Param("examScore") ExamScoreVO examScore);

	/**
	 * 查询所有考试不合格的数据
	 * @return
	 */
    List<ExamScore> getDisqualificationExamInfo();

	/**
	 * 根据准考证号查询培训信息
	 * @param trainingRegistration
	 * @return
	 */
	TrainingRegistration getTrainInfo(@Param("trainingRegistration")TrainingRegistration trainingRegistration);

	/**
	 * 查询所有无成绩的数据
	 * @return
	 */
	List<ExamScore> getNoScoreInfo();

	List<ExamScore> getLheoryGradeLess60();

	/**
	 * 按条件查询成绩数据
	 * @param examScoreVO
	 * @return
	 */
	List<ExportExamScoreExcel> getExamScoreList(@Param("examScore") ExamScoreVO examScoreVO);

	/**
	 * 查询每个培训学校的考试信息
	 * @param information
	 * @return
	 */
    List<ExamSocreStatis> getExamStatisInfo(@Param("information") InformationVO information);

	/**
	 * 查询考试成绩
	 * @return
	 */
	List<ExamScore> getExamScoreLists();
}