From 53075e9b90ca91a2d004895c095ff399dacd32fc Mon Sep 17 00:00:00 2001
From: zengh <123456>
Date: Thu, 29 Jul 2021 17:25:19 +0800
Subject: [PATCH] 排序问题修复

---
 src/main/java/org/springblade/modules/exam/service/impl/ExamScoreServiceImpl.java |   42 ++++++++++++++++++++++++++++++++++++++----
 1 files changed, 38 insertions(+), 4 deletions(-)

diff --git a/src/main/java/org/springblade/modules/exam/service/impl/ExamScoreServiceImpl.java b/src/main/java/org/springblade/modules/exam/service/impl/ExamScoreServiceImpl.java
index f8c09c8..5322df1 100644
--- a/src/main/java/org/springblade/modules/exam/service/impl/ExamScoreServiceImpl.java
+++ b/src/main/java/org/springblade/modules/exam/service/impl/ExamScoreServiceImpl.java
@@ -7,19 +7,20 @@
 import org.springblade.modules.exam.entity.ExamExaminationSubject;
 import org.springblade.modules.exam.entity.ExamPaper;
 import org.springblade.modules.exam.entity.ExamScore;
+import org.springblade.modules.exam.excel.ExamScoreExcel;
 import org.springblade.modules.exam.mapper.ExamScoreMapper;
 import org.springblade.modules.exam.service.ExamPaperService;
 import org.springblade.modules.exam.service.ExamScoreService;
-import org.springblade.modules.exam.vo.ExamPaperSubjectVO;
 import org.springblade.modules.exam.vo.ExamResultVO;
 import org.springblade.modules.exam.vo.ExamScoreVO;
-import org.springframework.beans.factory.annotation.Autowired;
 import org.springframework.stereotype.Service;
 import org.springframework.transaction.annotation.Transactional;
 
-import java.util.ArrayList;
 import java.util.Arrays;
 import java.util.List;
+import java.util.Map;
+
+import static com.bstek.ureport.expression.model.condition.Join.and;
 
 /**
  * 考试成绩服务实现类
@@ -76,7 +77,7 @@
 					if (examResultVO.getSubjectChoicesId().equals(examExaminationSubject.getExamSubjectChoices().getId())) {
 						//对比答案
 
-						if (examExaminationSubject.getExamSubjectChoices().getChoicesType() == 2){
+						if (examExaminationSubject.getExamSubjectChoices().getChoicesType() == 2 || examExaminationSubject.getExamSubjectChoices().getChoicesType() == 3){
 							//判断题逻辑
 							if (examResultVO.getValue().equals(examExaminationSubject.getExamSubjectChoices().getAnswer())) {
 								theoryGrade += examResultVO.getGrade();
@@ -123,4 +124,37 @@
 		//返回结果
 		return false;
 	}
+
+	/**
+	 * 导入实操成绩
+	 * @param examScoreExcelList
+	 * @param isCovered 是否覆盖
+	 */
+	@Override
+	public void importExamScore(List<ExamScoreExcel> examScoreExcelList, Boolean isCovered) {
+		if (examScoreExcelList.size()>0){
+			examScoreExcelList.forEach(examScoreExcel -> {
+				if (null!=examScoreExcel.getLearnGrade() && null!=examScoreExcel.getIdCardNo() && examScoreExcel.getIdCardNo()!=""){
+					ExamScore examScore = baseMapper.getExamScoreInfoByIdCardNo(examScoreExcel.getIdCardNo());
+					if (null!=examScore) {
+						examScore.setLearnGrade(examScoreExcel.getLearnGrade());
+						if (examScore.getTheoryGrade() >= 60 && examScore.getLearnGrade() >= 60) {
+							//合格
+							examScore.setQualified(0);
+						} else {
+							//不合格
+							examScore.setQualified(1);
+						}
+						//更新成绩数据
+						baseMapper.updateById(examScore);
+					}
+				}
+			});
+		}
+	}
+
+	@Override
+	public List<Map<String, Object>> scoreStatistics() {
+		return baseMapper.scoreStatistics();
+	}
 }

--
Gitblit v1.9.3