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

Administrator

2021-11-12 fb1238cf8982d299cb24536938bbeee942c2226e

 src/main/java/org/springblade/modules/exam/service/impl/ExamScoreServiceImpl.java

@@ -274,6 +274,8 @@
                  if (examScore.getTheoryGrade() >= 60 && examScore.getLearnGrade() >= 60) {
                     //合格
                     examScore.setQualified(0);
                     //修改制证状态为未制证
                     user.setUserType(7);
                     //正式考试通过生成保安证编号
//                     if (examPaper.getExamType()==1) {
                     //如果已有保安证编号，不更新用户信息
@@ -293,7 +295,7 @@
                        }
                        user.setSecuritynumber(result);
                        //发证日期
                        user.setPaperTime(new Date());
//                        user.setPaperTime(new Date());
                        //修改为持证保安
                        user.setHold("1");
                        //更新保安数据
@@ -302,7 +304,7 @@
                        String s1 =
                           "update blade_user set hold = " + "'" + user.getHold() + "'" +
                              ",securitynumber = " + "'" + user.getSecuritynumber() + "'" +
                              ",paper_time = " + "'" + new SimpleDateFormat("yyyy-MM-dd").format(user.getPaperTime()) + "'" +
                              ",user_type = " + "'" + user.getUserType() + "'" +
                              " " + "where id = " + "'" + user.getId() + "'";
                        FtpUtil.sqlFileUpload(s1);
                     }