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/exam/controller/ExamScoreController.java | 57 +++++++++++++++++++++++++++------------------------------
1 files changed, 27 insertions(+), 30 deletions(-)
diff --git a/src/main/java/org/springblade/modules/exam/controller/ExamScoreController.java b/src/main/java/org/springblade/modules/exam/controller/ExamScoreController.java
index e35da21..165f632 100644
--- a/src/main/java/org/springblade/modules/exam/controller/ExamScoreController.java
+++ b/src/main/java/org/springblade/modules/exam/controller/ExamScoreController.java
@@ -101,7 +101,8 @@
"values(" + "'" + sid + "'" +
"," + "'" + format + "'" + ")";
//FtpUtil.sqlFileUpload(s);
- myAsyncService.FTP(s);
+ //数据同步
+ myAsyncService.dataSync(s);
}
//返回
return R.status(save);
@@ -120,7 +121,7 @@
/**
- * 点击了开始考试后超过60分钟后再考试的，计算之前的考试成绩
+ * 点击了开始考试后超过90分钟后再考试的，计算之前的考试成绩
*
* @param examScore 考试成绩信息对象
*/
@@ -156,7 +157,7 @@
"update exam_score set qualified = " + "'" + examScore.getQualified() + "'" +
" " + "where id = " + "'" + examScore.getId() + "'";
//FtpUtil.sqlFileUpload(s1);
- myAsyncService.FTP(s1);
+ myAsyncService.dataSync(s1);
}
return R.status(status);
}
@@ -171,11 +172,11 @@
if (null != examScore.getLearnGrade() && null != examScore.getTheoryGrade()) {
ExamScore examScore1 = examScoreService.getById(examScore.getId());
//查询当前保安信息
- UserVO user = userService.getUserAgeById(Long.parseLong(examScore1.getUserId()));
+ UserVO user = userService.getUserAgeById(examScore1.getUserId());
//再根据身份证号查询用户,方式用户考了试，被删除，又新建的情况,修改最新用户的状态信息
User user1 = userService.getUserInfoByIdCardNo(user.getCardid());
//考试合格
- if (examScore.getTheoryGrade() >= 60 && examScore.getLearnGrade() >= 60) {
+ if (examScore.getTheoryGrade() >= 60 && examScore.getLearnGrade()== 0) {
//合格
examScore.setQualified(0);
//设置为未制证的状态
@@ -191,10 +192,10 @@
int max = userService.getSecurityPaperCount(pre);
String result = null;
if (max == 0) {
- result = pre + "00001";
+ result = pre + "000001";
} else {
//格式化
- DecimalFormat decimalFormat = new DecimalFormat("00000");
+ DecimalFormat decimalFormat = new DecimalFormat("000000");
max++;
result = pre + (decimalFormat.format(max));
}
@@ -214,6 +215,7 @@
securityPaperService.save(securityPaper);
//修改为持证保安
user1.setHold("1");
+ user1.setUpdateTime(new Date());
//更新保安数据
boolean b = userService.updateById(user1);
if (b) {
@@ -222,30 +224,14 @@
"update blade_user set hold = " + "'" + user1.getHold() + "'" +
",securitynumber = " + "'" + user1.getSecuritynumber() + "'" +
",user_type = " + "'" + user1.getUserType() + "'" +
+ ",update_time = " + "'" + new SimpleDateFormat("yyyy-MM-dd HH:mm:ss").format(user1.getUpdateTime()) + "'" +
" " + "where id = " + "'" + user1.getId() + "'";
- //FtpUtil.sqlFileUpload(s1);
- myAsyncService.FTP(s1);
+ myAsyncService.dataSync(s1);
}
}
} else {
//不合格
examScore.setQualified(1);
- }
- //总成绩
- if (user.getAge() <= 50) {
- if (null != examScore1.getTheoryGrade()) {
- examScore.setAllGrade(Math.round((examScore.getLearnGrade() + examScore1.getTheoryGrade()) / 2));
- } else {
- examScore.setAllGrade(Math.round(examScore.getLearnGrade() / 2));
- }
- }
- if (user.getAge() > 50) {
- if (null != examScore1.getTheoryGrade()) {
- examScore.setAllGrade(Integer.parseInt(String.valueOf(Math.round(examScore1.getTheoryGrade() * 0.5)))
- + Integer.parseInt(String.valueOf(Math.round(examScore.getLearnGrade() * 0.5))));
- } else {
- examScore.setAllGrade(Math.round(examScore.getLearnGrade() / 2));
- }
}
}
//内网同步
@@ -255,7 +241,7 @@
",qualified = " + "'" + examScore.getQualified() + "'" +
" " + "where id = " + "'" + examScore.getId() + "'";
//FtpUtil.sqlFileUpload(s1);
- myAsyncService.FTP(s1);
+ myAsyncService.dataSync(s1);
//本地修改
return R.status(examScoreService.updateById(examScore));
@@ -283,7 +269,7 @@
//内网同步
String s1 = "delete from exam_score where id = " + "'" + id + "'";
//FtpUtil.sqlFileUpload(s1);
- myAsyncService.FTP(s1);
+ myAsyncService.dataSync(s1);
});
return R.status(examScoreService.removeByIds(Func.toLongList(ids)));
}
@@ -344,7 +330,7 @@
examScoreExcel.setName("张三");
examScoreExcel.setIdCardNo("360XXX19XXXXXX****");
// examScoreExcel.setCandidateNo("2110**m0001");
- examScoreExcel.setLearnGrade(80);
+ examScoreExcel.setLearnGrade("合格");
list.add(examScoreExcel);
ExamScoreExcel examScoreExcel1 = new ExamScoreExcel();
@@ -352,7 +338,7 @@
examScoreExcel1.setName("李四");
examScoreExcel1.setIdCardNo("360XXX19XXXXXX****");
// examScoreExcel1.setCandidateNo("2110**m0002");
- examScoreExcel1.setLearnGrade(88);
+ examScoreExcel1.setLearnGrade("不合格");
list.add(examScoreExcel1);
// ExcelUtil.export(response, "实操成绩数据模板", "实操成绩数据表", list, ExamScoreExcel.class);
String fileName = null;
@@ -443,7 +429,7 @@
*/
@PostMapping("/refreshTrainExamInfo")
public R refreshTrainExamInfo(@RequestBody UpdateParamVo updateParamVo) {
- return R.status(examScoreService.refreshTrainExamInfo(updateParamVo));
+ return R.data(examScoreService.refreshTrainExamInfo(updateParamVo));
}
/**
@@ -490,4 +476,15 @@
}
+ /**
+ * 获取考试成绩列表
+ * @param examScoreVO
+ * @return
+ */
+ @GetMapping("/getList")
+ public R getList(ExamScoreVO examScoreVO) {
+ return R.data(examScoreService.getList(examScoreVO));
+ }
+
+
}
--
Gitblit v1.9.3