From c7519882e4e76d88f2c008075c4cfee8e3187f21 Mon Sep 17 00:00:00 2001
From: Administrator <admin>
Date: Fri, 17 Jun 2022 18:19:22 +0800
Subject: [PATCH] 用户修改方法新增
---
src/main/java/org/springblade/modules/training/service/impl/TrainingRegistrationServiceImpl.java | 40 ++++++++++++++++++++++++++--------------
1 files changed, 26 insertions(+), 14 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 f6c31cc..88cbf1a 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
@@ -470,7 +470,6 @@
+ "'" + examScore.getUserId() + "'" + ","
+ "'" + examScore.getApplyId() + "'" + ","
+ "'" + examScore.getExamId() + "'" + ")";
- //FtpUtil.sqlFileUpload(s);
myAsyncService.FTP(s);
}
}
@@ -512,37 +511,50 @@
//计算成绩
int sum = examAnswerRecordList.stream().mapToInt(ExamAnswerRecord::getAnswerScore).sum();
examScore1.setTheoryGrade(sum);
+ examScore1.setExamEndTime(examAnswerRecordList.get(examAnswerRecordList.size()).getAnswerTime());
+ examScore.setAllGrade(Math.round(sum/2));
if (sum>=60){
//暂未录入实操成绩
examScore1.setQualified(2);
}else {
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() + "'" +
+ ",exam_end_time = " + "'" + new SimpleDateFormat("yyyy-MM-dd HH:mm:dd").format(examScore.getExamEndTime()) + "'" +
+ ",all_grade = " + "'" + examScore.getAllGrade() + "'" +
+ " " + "where id = " + "'" + examScore1.getId() + "'";
+ myAsyncService.FTP(s);
}else {
//理论成绩设置为0
examScore1.setTheoryGrade(0);
+ examScore1.setAllGrade(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() + "'" +
+ ",all_grade = " + "'" + examScore.getAllGrade() + "'" +
+ " " + "where id = " + "'" + examScore1.getId() + "'";
+ myAsyncService.FTP(s);
}
- //更新成绩数据
- 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.FTP(s);
});
}else {
//数据同步
String s =
"update sys_training_registration set is_exam = " + trainingRegistration1.getIsExam() +
" " + "where id = " + "'" + trainingRegistration1.getId() + "'";
- //FtpUtil.sqlFileUpload(s);
myAsyncService.FTP(s);
}
});
--
Gitblit v1.9.3