成绩修改审核修改成绩合格后修改用户制证状态为未制证

Administrator

2021-11-12 fb1238cf8982d299cb24536938bbeee942c2226e

 src/main/java/org/springblade/modules/exam/controller/ExamScoreController.java

@@ -156,6 +156,8 @@
         if (examScore.getTheoryGrade() >= 60 && examScore.getLearnGrade() >= 60) {
            //合格
            examScore.setQualified(0);
            //设置为未制证的状态
            user1.setUserType(7);
            //正式考试通过生成保安证编号
            ExamPaper paper = examPaperService.getById(examScore.getExamId());
//            if (paper.getExamType() == 1) {
@@ -176,7 +178,7 @@
               }
               user1.setSecuritynumber(result);
               //发证日期
               user1.setPaperTime(new Date());
//               user1.setPaperTime(new Date());
               //修改为持证保安
               user1.setHold("1");
               //分配保安角色
@@ -190,7 +192,7 @@
               String s1 =
                  "update blade_user set hold = " + "'" + user1.getHold() + "'" +
                     ",securitynumber = " + "'" + user1.getSecuritynumber() + "'" +
                     ",paper_time = " + "'" + new SimpleDateFormat("yyyy-MM-dd").format(user1.getPaperTime()) + "'" +
                     ",user_type = " + "'" + user1.getUserType() + "'" +
                     " " + "where id = " + "'" + user1.getId() + "'";
               FtpUtil.sqlFileUpload(s1);
            }