From 8d43111bd0e598bc0b2014cbfa69a32e74959dff Mon Sep 17 00:00:00 2001
From: Administrator <admin>
Date: Wed, 15 Dec 2021 19:24:05 +0800
Subject: [PATCH] ftp sql 同步封装

---
 src/main/java/org/springblade/modules/exam/mapper/ExamPaperMapper.java |   94 +++++++++++++++++++++++++++++++++++++++++++++--
 1 files changed, 90 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 e84a2d3..64be5ad 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,14 @@
 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.entity.ExamSubjectChoices;
 import org.springblade.modules.exam.vo.ExamPaperSubjectVO;
 import org.springblade.modules.exam.vo.ExamPaperVO;
+import org.springblade.modules.exam.vo.ExamSubjectChoicesVO;
+import org.springblade.modules.training.entity.TrainingRegistration;
 
 import java.util.List;
 
@@ -34,16 +37,99 @@
  */
 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);
+	List<ExamPaper> selectExamPaperPageTree(@Param("paper") ExamPaper examPaper);
 
-    boolean UnbindSubject(String paperid,String subjectid);
+	boolean UnbindSubject(String paperid, String subjectid);
+
+	/**
+	 * 查询考生考试信息
+	 * @param userId 用户id
+	 * @return
+	 */
+    List<ExamPaperVO> getExamDetail(String userId);
+
+	/**
+	 * 查询是当前前缀已生成准考证号码最大的一位
+	 * @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);
 }

--
Gitblit v1.9.3