From 6ee55849eac9cd9d9183d155e80ebd454115a0c3 Mon Sep 17 00:00:00 2001
From: Administrator <admin>
Date: Tue, 17 Aug 2021 10:28:11 +0800
Subject: [PATCH] 根据userID 查詢年齡,分數計算修改,年齡大於50岁的理论30%,实操70%,小于50岁的总分按理论实操各50%计算

---
 src/main/java/org/springblade/modules/exam/service/impl/ExamScoreServiceImpl.java |   28 ++++++++++++++++++++++++----
 1 files changed, 24 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 87105ee..4eb7edc 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
@@ -22,6 +22,7 @@
 import org.springblade.modules.exam.vo.ExamScoreVO;
 import org.springblade.modules.system.entity.User;
 import org.springblade.modules.system.service.IUserService;
+import org.springblade.modules.system.vo.UserVO;
 import org.springblade.modules.training.entity.TrainingRegistration;
 import org.springblade.modules.training.service.TrainingRegistrationService;
 import org.springframework.stereotype.Service;
@@ -126,11 +127,14 @@
 			}
 			//获取考试信息
 			ExamPaper paper = examPaperService.getById(examScore.getPapersId());
+			int age = 0;
 			//使用准考证号查询报名信息,修改考试状态为已考试
 			if(paper.getExamType()==1){
 				Apply apply = new Apply();
 				apply.setCandidateNo(examScore.getCandidateNo());
 				Apply apply1 = applyService.getOne(Condition.getQueryWrapper(apply));
+				//查询用户年龄,根据年龄计算总分
+				age = userService.getUserAgeById(apply1.getUserId()).getAge();
 				//修改为已考试
 				apply1.setIsExam(2);
 				applyService.updateById(apply1);
@@ -140,16 +144,25 @@
 				TrainingRegistration trainingRegistration = new TrainingRegistration();
 				trainingRegistration.setCandidateNo(examScore.getCandidateNo());
 				TrainingRegistration trainingRegistration1 = trainingRegistrationService.getOne(Condition.getQueryWrapper(trainingRegistration));
+				//查询用户年龄,根据年龄计算总分
+				age = userService.getUserAgeById(Long.parseLong(trainingRegistration1.getUserId())).getAge();
 				//修改为已考试
 				trainingRegistration1.setIsExam(2);
 				trainingRegistrationService.updateById(trainingRegistration1);
 			}
+
+
 			//设置考试ID
 			examScore.setExamId(examScore.getPapersId().toString());
 			//设置理论得分
 			examScore.setTheoryGrade(theoryGrade);
 			//计算总成绩,此时没有实操成绩,总成绩为实操成绩和理论成绩和的一半
-			examScore.setAllGrade(Math.round(theoryGrade/2));
+			if (age<=50) {
+				examScore.setAllGrade(Math.round(theoryGrade / 2));
+			}
+			if (age>50) {
+				examScore.setAllGrade(Integer.parseInt(String.valueOf(Math.round(theoryGrade*0.3))));
+			}
 			//设置状态
 			if (theoryGrade>=60){
 				examScore.setQualified(2);
@@ -184,6 +197,8 @@
 					//查询出成绩数据
 					ExamScore examScore = baseMapper.getExamScoreInfoByIdCardNo(examScoreExcel.getIdCardNo(),examPaper.getId());
 					if (null!=examScore) {
+						//查询当前保安信息
+						UserVO user = userService.getUserAgeById(Long.parseLong(examScore.getUserId()));
 						examScore.setLearnGrade(examScoreExcel.getLearnGrade());
 						if (examScore.getTheoryGrade() >= 60 && examScore.getLearnGrade() >= 60) {
 							//合格
@@ -191,8 +206,7 @@
 							//正式考试通过生成保安证编号
 							if (examPaper.getExamType()==1) {
 								//去生成保安证编号
-								//查询当前保安信息
-								User user = userService.getById(examScore.getUserId());
+
 								String pre = SecurityPaperUtil.getSecurityPaper();
 								//查询当前年份已有的保安证编号
 								int count = userService.getSecurityPaperCount(pre);
@@ -213,7 +227,13 @@
 							examScore.setQualified(1);
 						}
 						//总成绩
-						examScore.setAllGrade(Math.round((examScore.getTheoryGrade()+examScoreExcel.getLearnGrade())/2));
+						if (user.getAge()<=50) {
+							examScore.setAllGrade(Math.round((examScore.getTheoryGrade()+examScoreExcel.getLearnGrade())/2));
+						}
+						if (user.getAge()>50) {
+							examScore.setAllGrade(Integer.parseInt(String.valueOf(Math.round(examScore.getTheoryGrade()*0.3)))
+								+ Integer.parseInt(String.valueOf(Math.round(examScoreExcel.getLearnGrade()*0.7))));
+						}
 						//更新成绩数据
 						baseMapper.updateById(examScore);
 					}

--
Gitblit v1.9.3