From 7f046650eea24ba1a43f09831407e4e37b8cb898 Mon Sep 17 00:00:00 2001
From: Administrator <admin>
Date: Tue, 12 Oct 2021 23:34:28 +0800
Subject: [PATCH] 用户，保安员新增同账号判断修改
---
src/main/java/org/springblade/modules/exam/mapper/ExamScoreMapper.java | 41 ++++++++++++++++++++++++++++++++++++++++-
1 files changed, 40 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 a272dfb..0b534a0 100644
--- a/src/main/java/org/springblade/modules/exam/mapper/ExamScoreMapper.java
+++ b/src/main/java/org/springblade/modules/exam/mapper/ExamScoreMapper.java
@@ -5,6 +5,7 @@
import org.apache.ibatis.annotations.Param;
import org.springblade.modules.exam.entity.ExamScore;
import org.springblade.modules.exam.vo.ExamScoreVO;
+import org.springblade.modules.training.entity.TrainingRegistration;
import java.util.List;
import java.util.Map;
@@ -48,5 +49,43 @@
*/
ExamScore getExamScoreInfoByIdCardNo(@Param("idCardNo")String idCardNo,@Param("examId")Long examId);
- List<Map<String,Object>> scoreStatistics();
+ 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 page 分页
+ * @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();
+
}
--
Gitblit v1.9.3