From cc057177b2fb17aee9a173a6adbabdc578fd74c7 Mon Sep 17 00:00:00 2001
From: tangzy <tangzy123456>
Date: Mon, 06 Dec 2021 10:30:44 +0800
Subject: [PATCH] 1.许可
---
src/main/java/org/springblade/modules/exam/mapper/ExamScoreMapper.java | 38 +++++++++++++++++++++++++++++++++++++-
1 files changed, 37 insertions(+), 1 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 1875259..9ff7a57 100644
--- a/src/main/java/org/springblade/modules/exam/mapper/ExamScoreMapper.java
+++ b/src/main/java/org/springblade/modules/exam/mapper/ExamScoreMapper.java
@@ -7,6 +7,7 @@
import org.springblade.modules.exam.vo.ExamScoreVO;
import java.util.List;
+import java.util.Map;
/**
* 考试成绩Mapper 接口
@@ -25,6 +26,23 @@
List<ExamScoreVO> selectExamScorePage(IPage page, @Param("examScore") ExamScoreVO examScore);
/**
+ * 自定义分页
+ *
+ * @param page 分页
+ * @return
+ */
+ List<ExamScoreVO> scorePage(IPage page,String deptid,String jurisdiction,String realName);
+
+ /**
+ * 自定义分页-模拟考试
+ *
+ * @param page 分页
+ * @param examScore 实体
+ * @return
+ */
+ List<ExamScoreVO> selectTrainExamScorePage(IPage page, @Param("examScore") ExamScoreVO examScore);
+
+ /**
* 详情
*
* @param examScore 考试成绩信息对象
@@ -36,5 +54,23 @@
* @param idCardNo 身份证号
* @return
*/
- ExamScore getExamScoreInfoByIdCardNo(@Param("idCardNo")String idCardNo);
+ ExamScore getExamScoreInfoByIdCardNo(@Param("idCardNo")String idCardNo,@Param("examId")Long examId);
+
+ List<Map<String,Object>> scoreStatistics(String deptid,String jurisdiction);
+ List<Map<String,Object>> scoreStatisticssc(String deptid,String jurisdiction);
+
+ /**
+ * 修改成绩信息
+ * @param examScore
+ * @return
+ */
+ int updateByIdAndQualifiee(@Param("examScore") ExamScore examScore);
+
+ /**
+ * 考试合格人数对比
+ * @param deptid
+ * @param jurisdiction
+ * @return
+ */
+ List<Object> scoreStat(String deptid, String jurisdiction);
}
--
Gitblit v1.9.3