From 6beeb715fcef8db22b17c309ec8fecc45cc04b00 Mon Sep 17 00:00:00 2001
From: Administrator <admin>
Date: Tue, 17 Aug 2021 16:30:47 +0800
Subject: [PATCH] 1.考试成绩查询修改 2.用户查询修改

---
 src/main/java/org/springblade/modules/exam/service/impl/ExamScoreServiceImpl.java |   44 ++++++++++++++++++++++++++++++++++++++++----
 1 files changed, 40 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..e556b9d 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;
@@ -60,6 +61,14 @@
 	 */
 	@Override
 	public IPage<ExamScoreVO> selectExamScorePage(IPage<ExamScoreVO> page, ExamScoreVO examScore) {
+		if (null!=examScore.getExamType()){
+			if (examScore.getExamType()==1){
+				return page.setRecords(baseMapper.selectExamScorePage(page, examScore));
+			}
+			if (examScore.getExamType()==2){
+				return page.setRecords(baseMapper.selectTrainExamScorePage(page, examScore));
+			}
+		}
 		return page.setRecords(baseMapper.selectExamScorePage(page, examScore));
 	}
 
@@ -126,11 +135,19 @@
 			}
 			//获取考试信息
 			ExamPaper paper = examPaperService.getById(examScore.getPapersId());
+			int age = 0;
+			UserVO user = new UserVO();
 			//使用准考证号查询报名信息,修改考试状态为已考试
 			if(paper.getExamType()==1){
 				Apply apply = new Apply();
 				apply.setCandidateNo(examScore.getCandidateNo());
 				Apply apply1 = applyService.getOne(Condition.getQueryWrapper(apply));
+				//查询用户年龄,根据年龄计算总分
+				user = userService.getUserAgeById(apply1.getUserId());
+				//修改用户的考试状态,理论考试结束
+				user.setIsApply(3);
+				userService.updateById(user);
+				age = user.getAge();
 				//修改为已考试
 				apply1.setIsExam(2);
 				applyService.updateById(apply1);
@@ -140,16 +157,28 @@
 				TrainingRegistration trainingRegistration = new TrainingRegistration();
 				trainingRegistration.setCandidateNo(examScore.getCandidateNo());
 				TrainingRegistration trainingRegistration1 = trainingRegistrationService.getOne(Condition.getQueryWrapper(trainingRegistration));
+				//查询用户年龄,根据年龄计算总分
+				user = userService.getUserAgeById(Long.parseLong(trainingRegistration1.getUserId()));
+				//修改用户的培训状态,理论考试结束
+				user.setIsTrain(3);
+				age = user.getAge();
+				userService.updateById(user);
 				//修改为已考试
 				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 +213,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 +222,7 @@
 							//正式考试通过生成保安证编号
 							if (examPaper.getExamType()==1) {
 								//去生成保安证编号
-								//查询当前保安信息
-								User user = userService.getById(examScore.getUserId());
+
 								String pre = SecurityPaperUtil.getSecurityPaper();
 								//查询当前年份已有的保安证编号
 								int count = userService.getSecurityPaperCount(pre);
@@ -213,7 +243,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