From 62eb499b0c969f246d3245d1429a97da4de1ce28 Mon Sep 17 00:00:00 2001
From: 钟日健 <arsn163@163.com>
Date: Mon, 01 Jun 2026 20:46:13 +0800
Subject: [PATCH] feat: 成绩查询增加年龄查询返回
---
src/main/java/org/springblade/modules/training/service/impl/TrainingRegistrationServiceImpl.java | 185 ++++++++++++++++++++++++++++++++++-----------
1 files changed, 138 insertions(+), 47 deletions(-)
diff --git a/src/main/java/org/springblade/modules/training/service/impl/TrainingRegistrationServiceImpl.java b/src/main/java/org/springblade/modules/training/service/impl/TrainingRegistrationServiceImpl.java
index a21e5f4..4dfe1e2 100644
--- a/src/main/java/org/springblade/modules/training/service/impl/TrainingRegistrationServiceImpl.java
+++ b/src/main/java/org/springblade/modules/training/service/impl/TrainingRegistrationServiceImpl.java
@@ -13,19 +13,23 @@
import org.springblade.modules.absentrecords.service.AbsentRecordsService;
import org.springblade.modules.apply.entity.Apply;
import org.springblade.modules.apply.excel.ApplyInfoExcel;
+import org.springblade.modules.exam.entity.ExamAnswerRecord;
import org.springblade.modules.exam.entity.ExamPaper;
import org.springblade.modules.exam.entity.ExamScore;
+import org.springblade.modules.exam.service.ExamAnswerRecordService;
import org.springblade.modules.exam.service.ExamPaperService;
import org.springblade.modules.exam.service.ExamScoreService;
import org.springblade.modules.system.entity.User;
import org.springblade.modules.system.service.IUserDeptService;
import org.springblade.modules.system.service.IUserService;
+import org.springblade.modules.system.service.MyAsyncService;
import org.springblade.modules.training.entity.TrainingRegistration;
import org.springblade.modules.training.excel.TrainingRegistrationExcel;
import org.springblade.modules.training.mapper.TrainingRegistrationMapper;
import org.springblade.modules.training.service.TrainingRegistrationService;
import org.springblade.modules.training.util.LongTimeUtil;
import org.springblade.modules.training.vo.TrainingRegistrationVo;
+import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Service;
import org.springframework.transaction.annotation.Transactional;
@@ -53,7 +57,11 @@
private final AbsentRecordsService absentRecordsService;
private final ExamScoreService examScoreService;
+ @Autowired
+ private MyAsyncService myAsyncService;
+ @Autowired
+ private ExamAnswerRecordService examAnswerRecordService;
@Override
public IPage<TrainingRegistrationVo> selectTrainingRegistrationPage(IPage<TrainingRegistrationVo> page, TrainingRegistrationVo trainingRegistration) {
@@ -287,7 +295,8 @@
+ "," + "'" + trainingRegistration.getIsExam() + "'"
+ "," +"'" + trainingRegistration.getAuditStatus() + "'" + ");" +
"update blade_user set is_train = " + user1.getIsTrain() + " " +"where id = " + "'" + user1.getId() + "'";
- FtpUtil.sqlFileUpload(s);
+ //FtpUtil.sqlFileUpload(s);
+ myAsyncService.dataSync(s);
}
@@ -352,57 +361,139 @@
this.updateById(trainingRegistration1);
//修改保安报名状态
User user = userService.getById(trainingRegistration1.getUserId());
- //考试结束
- user.setIsTrain(3);
- userService.updateById(user);
- //生成缺考记录
- AbsentRecords absentRecords = new AbsentRecords();
- absentRecords.setUserId(user.getId());
- absentRecords.setApplyId(trainingRegistration1.getId());
- absentRecords.setExamId(Long.parseLong(trainingRegistration1.getTrainExamId()));
- absentRecords.setCandidateNo(trainingRegistration1.getCandidateNo());
- absentRecords.setCreateTime(new Date());
- //新增
- absentRecordsService.save(absentRecords);
+ if (null != user) {
+ //考试结束
+ user.setIsTrain(3);
+ userService.updateById(user);
+ //生成缺考记录
+ AbsentRecords absentRecords = new AbsentRecords();
+ absentRecords.setUserId(user.getId());
+ absentRecords.setApplyId(trainingRegistration1.getId());
+ absentRecords.setExamId(Long.parseLong(trainingRegistration1.getTrainExamId()));
+ absentRecords.setCandidateNo(trainingRegistration1.getCandidateNo());
+ absentRecords.setCreateTime(new Date());
+ //新增
+ absentRecordsService.save(absentRecords);
- //新增成绩，成绩为0
- ExamScore examScore = new ExamScore();
- examScore.setCandidateNo(trainingRegistration1.getCandidateNo());
- examScore.setTheoryGrade(0);
- examScore.setAllGrade(0);
- examScore.setQualified(3);
- examScore.setUserId(user.getId().toString());
- examScore.setApplyId(trainingRegistration1.getId());
- examScore.setExamId(trainingRegistration1.getTrainExamId());
- //新增
- examScoreService.save(examScore);
+ //新增成绩，成绩为0
+ ExamScore examScore = new ExamScore();
+ examScore.setCandidateNo(trainingRegistration1.getCandidateNo());
+ examScore.setTheoryGrade(0);
+ examScore.setAllGrade(0);
+ examScore.setQualified(3);
+ examScore.setUserId(user.getId());
+ examScore.setApplyId(trainingRegistration1.getId());
+ examScore.setExamId(trainingRegistration1.getTrainExamId());
+ //新增
+ examScoreService.save(examScore);
- //内网同步
- String s =
- "update sys_training_registration set cancel = " + trainingRegistration1.getCancel() +
- ",is_exam = " + "'" + trainingRegistration1.getIsExam() + "'" +
- " " + "where id = " + "'" + trainingRegistration1.getId() + "';" +
- "update blade_user set is_train = " + user.getIsTrain() + " " + "where id = " + "'" + user.getId() + "';" +
- "insert into sys_absent_records(id,user_id,create_time,exam_id,apply_id,candidate_no) " +
- "values(" + "'" + absentRecords.getId() + "'" + ","
- + "'" + absentRecords.getUserId() + "'" + ","
- + "'" + new SimpleDateFormat("yyyy-MM-dd HH:mm:ss").format(absentRecords.getCreateTime()) + "'" + ","
- + "'" + absentRecords.getExamId() + "'" + ","
- + "'" + absentRecords.getApplyId() + "'" + ","
- + "'" + absentRecords.getCandidateNo() + "'" + ");" +
- "insert into exam_score(id,candidate_no,theory_grade,all_grade,qualified,user_id,apply_id,exam_id) " +
- "values(" + "'" + examScore.getId() + "'" + ","
- + "'" + examScore.getCandidateNo() + "'" + ","
- + "'" + examScore.getTheoryGrade() + "'" + ","
- + "'" + examScore.getAllGrade() + "'" + ","
- + "'" + examScore.getQualified() + "'" + ","
- + "'" + examScore.getUserId() + "'" + ","
- + "'" + examScore.getApplyId() + "'" + ","
- + "'" + examScore.getExamId() + "'" + ")";
- FtpUtil.sqlFileUpload(s);
+ //内网同步
+ String s =
+ "update sys_training_registration set cancel = " + trainingRegistration1.getCancel() +
+ ",is_exam = " + "'" + trainingRegistration1.getIsExam() + "'" +
+ " " + "where id = " + "'" + trainingRegistration1.getId() + "';" +
+ "update blade_user set is_train = " + user.getIsTrain() + " " + "where id = " + "'" + user.getId() + "';" +
+ "insert into sys_absent_records(id,user_id,create_time,exam_id,apply_id,candidate_no) " +
+ "values(" + "'" + absentRecords.getId() + "'" + ","
+ + "'" + absentRecords.getUserId() + "'" + ","
+ + "'" + new SimpleDateFormat("yyyy-MM-dd HH:mm:ss").format(absentRecords.getCreateTime()) + "'" + ","
+ + "'" + absentRecords.getExamId() + "'" + ","
+ + "'" + absentRecords.getApplyId() + "'" + ","
+ + "'" + absentRecords.getCandidateNo() + "'" + ");" +
+ "insert into exam_score(id,candidate_no,theory_grade,all_grade,qualified,user_id,apply_id,exam_id) " +
+ "values(" + "'" + examScore.getId() + "'" + ","
+ + "'" + examScore.getCandidateNo() + "'" + ","
+ + "'" + examScore.getTheoryGrade() + "'" + ","
+ + "'" + examScore.getAllGrade() + "'" + ","
+ + "'" + examScore.getQualified() + "'" + ","
+ + "'" + examScore.getUserId() + "'" + ","
+ + "'" + examScore.getApplyId() + "'" + ","
+ + "'" + examScore.getExamId() + "'" + ")";
+ //FtpUtil.sqlFileUpload(s);
+ myAsyncService.dataSync(s);
+ }
}
}
});
}
}
+
+ /**
+ * 定时任务处理考试中的
+ */
+ @Override
+ public void examLoading() {
+ //封装条件
+ TrainingRegistration trainingRegistration = new TrainingRegistration();
+ trainingRegistration.setCancel(1);
+ trainingRegistration.setAuditStatus(1);
+ trainingRegistration.setIsExam(3);
+ //查询考试申请审核通过，已报名，未考试的人员
+ List<TrainingRegistration> trainingRegistrationList = baseMapper.selectTrainingRegistrationList(trainingRegistration);
+ if (trainingRegistrationList.size()>0){
+ //遍历
+ trainingRegistrationList.forEach(trainingRegistration1 -> {
+ //修改考试状态,已结束
+ trainingRegistration1.setIsExam(2);
+ //更新
+ this.updateById(trainingRegistration1);
+ //查询考试成绩记录
+ ExamScore examScore = new ExamScore();
+ examScore.setApplyId(trainingRegistration1.getId());
+ List<ExamScore> list = examScoreService.list(Condition.getQueryWrapper(examScore));
+ if (list.size()>0) {
+ list.forEach(examScore1 -> {
+ //查询是否有考试记录
+ ExamAnswerRecord examAnswerRecord = new ExamAnswerRecord();
+ examAnswerRecord.setScoreId(examScore1.getId());
+ List<ExamAnswerRecord> examAnswerRecordList = examAnswerRecordService.list(Condition.getQueryWrapper(examAnswerRecord));
+ if (examAnswerRecordList.size()>0){
+ //计算成绩
+ int sum = examAnswerRecordList.stream().mapToInt(ExamAnswerRecord::getAnswerScore).sum();
+ examScore1.setTheoryGrade(sum);
+ if (sum>=60){
+ //暂未录入实操成绩
+ examScore1.setQualified(2);
+ }else {
+ examScore1.setQualified(1);
+ }
+ }else {
+ //理论成绩设置为0
+ examScore1.setTheoryGrade(0);
+ //不合格
+ examScore1.setQualified(1);
+ }
+ //更新成绩数据
+ examScoreService.updateById(examScore1);
+
+ //数据同步
+ String s =
+ "update sys_training_registration set is_exam = " + trainingRegistration1.getIsExam() +
+ " " + "where id = " + "'" + trainingRegistration1.getId() + "';" +
+ "update exam_score set theory_grade = " + examScore1.getTheoryGrade() +
+ ",qualified = " + "'" + examScore1.getQualified() + "'" +
+ " " + "where id = " + "'" + examScore1.getId() + "'";
+ //FtpUtil.sqlFileUpload(s);
+ myAsyncService.dataSync(s);
+ });
+ }else {
+ //数据同步
+ String s =
+ "update sys_training_registration set is_exam = " + trainingRegistration1.getIsExam() +
+ " " + "where id = " + "'" + trainingRegistration1.getId() + "'";
+ //FtpUtil.sqlFileUpload(s);
+ myAsyncService.dataSync(s);
+ }
+ });
+ }
+ }
+
+ /**
+ * 查看报名集合信息
+ * @return
+ */
+ @Override
+ public List<TrainingRegistration> getList(TrainingRegistrationVo trainingRegistration) {
+ return baseMapper.getList(trainingRegistration);
+ }
}
--
Gitblit v1.9.3