/*
|
* 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);
|
}
|
