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 | 150 ++++++++++++++++++++++++++++++++++++++++++++++++-
1 files changed, 146 insertions(+), 4 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 a9c4ea4..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,11 +19,12 @@
import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import com.baomidou.mybatisplus.core.metadata.IPage;
import org.apache.ibatis.annotations.Param;
-import org.springblade.modules.desk.entity.Notice;
-import org.springblade.modules.desk.vo.NoticeVO;
+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.vo.ExamPaperSubjectVO;
-import org.springblade.modules.exam.vo.ExamPaperVO;
+import org.springblade.modules.exam.entity.ExamSubjectChoices;
+import org.springblade.modules.exam.vo.*;
+import org.springblade.modules.training.entity.TrainingRegistration;
import java.util.List;
@@ -34,5 +35,146 @@
*/
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);
}
--
Gitblit v1.9.3