From 62eb499b0c969f246d3245d1429a97da4de1ce28 Mon Sep 17 00:00:00 2001
From: 钟日健 <arsn163@163.com>
Date: Mon, 01 Jun 2026 20:46:13 +0800
Subject: [PATCH] feat: 成绩查询增加年龄查询返回
---
src/main/java/org/springblade/modules/exam/mapper/ExamPaperMapper.java | 121 +++++++++++++++++++++++++++++++++++++--
1 files changed, 113 insertions(+), 8 deletions(-)
diff --git a/src/main/java/org/springblade/modules/exam/mapper/ExamPaperMapper.java b/src/main/java/org/springblade/modules/exam/mapper/ExamPaperMapper.java
index 50504ba..c55ab89 100644
--- a/src/main/java/org/springblade/modules/exam/mapper/ExamPaperMapper.java
+++ b/src/main/java/org/springblade/modules/exam/mapper/ExamPaperMapper.java
@@ -19,10 +19,11 @@
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.ExamPaperSubjectVO;
-import org.springblade.modules.exam.vo.ExamPaperVO;
+import org.springblade.modules.exam.vo.*;
import org.springblade.modules.training.entity.TrainingRegistration;
import java.util.List;
@@ -34,11 +35,20 @@
*/
public interface ExamPaperMapper extends BaseMapper<ExamPaper> {
- IPage<ExamPaperVO> selectExamPaperPage(IPage page, ExamPaperVO exam);
+ 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<ExamPaperSubjectVO> queryRandomSubject(@Param("paper") ExamPaper paper);
+ List<ExamSubjectChoicesVO> queryRandomSubject(@Param("paper") ExamPaper paper);
ExamPaperSubjectVO PagerSubject(@Param("paper") ExamPaper paper);
@@ -54,13 +64,13 @@
/**
* 查询考生考试信息
- * @param userId 用户id
+ * @param examPaper 用户id
* @return
*/
- List<ExamPaperVO> getExamDetail(String userId);
+ List<ExamPaperVO> getExamDetail(@Param("examPaper") ExamPaperVO examPaper);
/**
- * 查询前缀相同的准考证数量
+ * 查询是当前前缀已生成准考证号码最大的一位
* @param result 前缀
* @return
*/
@@ -71,5 +81,100 @@
* @param id 考试id
* @return
*/
- List<TrainingRegistration> getTrainList(Long id);
+ 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);
}
--
Gitblit v1.9.3