From 7293f04d18fb2e882e152f962c3aa1d8fcb1f93e Mon Sep 17 00:00:00 2001
From: Administrator <admin>
Date: Wed, 17 Nov 2021 15:46:35 +0800
Subject: [PATCH] 证书打印信息导出修改

---
 src/main/java/org/springblade/modules/exam/mapper/ExamScoreMapper.java |   31 +++++++++++++++++++++++++++++++
 1 files changed, 31 insertions(+), 0 deletions(-)

diff --git a/src/main/java/org/springblade/modules/exam/mapper/ExamScoreMapper.java b/src/main/java/org/springblade/modules/exam/mapper/ExamScoreMapper.java
index 2ed2858..014d5d6 100644
--- a/src/main/java/org/springblade/modules/exam/mapper/ExamScoreMapper.java
+++ b/src/main/java/org/springblade/modules/exam/mapper/ExamScoreMapper.java
@@ -4,7 +4,10 @@
 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.system.vo.UserVO;
+import org.springblade.modules.training.entity.TrainingRegistration;
 
 import java.util.List;
 import java.util.Map;
@@ -65,4 +68,32 @@
 	 * @return
 	 */
 	List<ExamScoreVO> scorePage(IPage page,String deptid,String jurisdiction);
+
+	/**
+	 * 查询所有考试不合格的数据
+	 * @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);
 }

--
Gitblit v1.9.3