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.exam.entity.ExamScore;
|
import org.springblade.modules.exam.vo.ExamScoreVO;
|
|
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 分页
|
* @return
|
*/
|
List<ExamScoreVO> scorePage(IPage page,String deptid,String jurisdiction,String realName);
|
|
/**
|
* 自定义分页-模拟考试
|
*
|
* @param page 分页
|
* @param examScore 实体
|
* @return
|
*/
|
List<ExamScoreVO> selectTrainExamScorePage(IPage page, @Param("examScore") ExamScoreVO examScore);
|
|
/**
|
* 详情
|
*
|
* @param examScore 考试成绩信息对象
|
*/
|
ExamScoreVO selectExamScoreInfo(@Param("examScore") ExamScore examScore);
|
|
/**
|
* 根据身份证号导入实操成绩
|
* @param idCardNo 身份证号
|
* @return
|
*/
|
ExamScore getExamScoreInfoByIdCardNo(@Param("idCardNo")String idCardNo,@Param("examId")Long examId);
|
|
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 deptid
|
* @param jurisdiction
|
* @return
|
*/
|
List<Object> scoreStat(String deptid, String jurisdiction);
|
}
|
