From 5c2d7fcc8450e02fd51ea6a20e34567068c7f31f Mon Sep 17 00:00:00 2001
From: zengh <123456>
Date: Fri, 27 Aug 2021 21:08:01 +0800
Subject: [PATCH] 成绩统计
---
src/main/java/org/springblade/modules/exam/controller/ExamScoreController.java | 16 ++++++++--------
1 files changed, 8 insertions(+), 8 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 1fe2958..388224e 100644
--- a/src/main/java/org/springblade/modules/exam/controller/ExamScoreController.java
+++ b/src/main/java/org/springblade/modules/exam/controller/ExamScoreController.java
@@ -29,10 +29,7 @@
import javax.servlet.http.HttpServletResponse;
import java.text.DecimalFormat;
import java.text.SimpleDateFormat;
-import java.util.ArrayList;
-import java.util.Arrays;
-import java.util.List;
-import java.util.Random;
+import java.util.*;
/**
* @author zhongrj
@@ -84,8 +81,8 @@
Long sid = examScore.getId();
String format = new SimpleDateFormat("yyyy-MM-dd HH:mm:ss").format(examScore.getExamTime());
String s = "insert into exam_score(id,exam_time) " +
- "values(" + "'" + sid + "'" + "," + "'" +
- format + "'" + "," + "'" + ")";
+ "values(" + "'" + sid + "'" +
+ "," + "'" +format + "'" + ")";
FtpUtil.sqlFileUpload(s);
//返回
return R.status(save);
@@ -141,6 +138,8 @@
result = pre + (decimalFormat.format(count++));
}
user.setSecuritynumber(result);
+ //发证日期
+ user.setPaperTime(new Date());
//修改为持证保安
user.setHold("1");
//分配保安角色
@@ -155,6 +154,7 @@
"update blade_user set role_id = " + "'" + user.getRoleId() + "'" +
",hold = " + "'" + user.getHold() + "'" +
",securitynumber = " + "'" + user.getSecuritynumber() + "'" +
+ ",paper_time = " + "'" + new SimpleDateFormat("yyyy-MM-dd").format(user.getPaperTime()) + "'" +
" " +"where id = " + "'" + user.getId() + "'";
FtpUtil.sqlFileUpload(s1);
}
@@ -265,7 +265,7 @@
*/
@GetMapping("score-statistics")
@ApiOperation(value = "分数统计")
- public R<List> scoreStatistics(HttpServletResponse response) {
- return R.data(examScoreService.scoreStatistics());
+ public R<List> scoreStatistics(HttpServletResponse response,String deptid,String jurisdiction) {
+ return R.data(examScoreService.scoreStatistics(deptid,jurisdiction));
}
}
--
Gitblit v1.9.3