feat: 成绩查询增加年龄查询返回

钟日健

2026-06-01 62eb499b0c969f246d3245d1429a97da4de1ce28

 src/main/java/org/springblade/modules/exam/mapper/ExamScoreMapper.java

@@ -1,10 +1,17 @@
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;
@@ -32,6 +39,7 @@
    * @param examScore 实体
    * @return
    */
   @SqlParser(filter = true)
   List<ExamScoreVO> selectTrainExamScorePage(IPage page, @Param("examScore") ExamScoreVO examScore);

   /**
@@ -46,7 +54,7 @@
    * @param idCardNo 身份证号
    * @return
    */
    ExamScore getExamScoreInfoByIdCardNo(@Param("idCardNo")String idCardNo,@Param("examId")Long examId);
   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);
@@ -64,5 +72,42 @@
    * @param page  分页
    * @return
    */
   List<ExamScoreVO> scorePage(IPage page,String deptid,String jurisdiction);
   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);

    List<ExamScoreVO> getList(@Param("examScore") ExamScoreVO examScoreVO);
}