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("information") InformationVO information);
|
|
/**
|
* 查询所有考试不合格的数据
|
* @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);
|
}
|
