证书打印信息导出修改

Administrator

2021-11-17 7293f04d18fb2e882e152f962c3aa1d8fcb1f93e

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

@@ -135,11 +135,14 @@
                  " " + "where id = " + "'" + user.getId() + "'";
            FtpUtil.sqlFileUpload(s1);
         } else {
            //实操成绩不为空
            if (examScore.getTheoryGrade() >= 60 && examScore.getLearnGrade() >= 60) {
               //合格
               examScore.setQualified(0);
               //设置为未制证的状态
               user.setUserType(7);
               //如果已有保安证编号，不更保安证编号信息
               if (null == user.getSecuritynumber() || user.getSecuritynumber() == "") {
               if (null == user.getSecuritynumber() || user.getSecuritynumber().equals("")) {
                  //去生成保安证编号
                  String pre = SecurityPaperUtil.getSecurityPaper();
                  //查询当前年份已有的保安证编号
@@ -202,6 +205,7 @@
                  " " + "where id = " + "'" + trainingRegistration.getId() + "';"+
               "update blade_user set hold = " + "'" + user.getHold() + "'" +
                  ",securitynumber = " + "'" + user.getSecuritynumber() + "'" +
                  ",user_type = " + "'" + user.getUserType() + "'" +
                  ",is_train = " + "'" + user.getIsTrain() + "'" +
                  " " + "where id = " + "'" + user.getId() + "'";
            FtpUtil.sqlFileUpload(s1);