上岗证已制证修改

Administrator

2021-12-27 ff8b904fd730846fadd76fb94c7b9cbde4e134b3

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

@@ -14,6 +14,8 @@
import org.springblade.modules.exam.service.ScoreAuditRecordsService;
import org.springblade.modules.exam.util.SecurityPaperUtil;
import org.springblade.modules.exam.vo.ScoreAuditRecordsVO;
import org.springblade.modules.securitypaper.entity.SecurityPaper;
import org.springblade.modules.securitypaper.service.SecurityPaperService;
import org.springblade.modules.system.entity.User;
import org.springblade.modules.system.service.IUserService;
import org.springblade.modules.system.vo.UserVO;
@@ -48,6 +50,9 @@

   @Autowired
   private TrainingRegistrationService trainingRegistrationService;

   @Autowired
   private SecurityPaperService securityPaperService;

   /**
    * 自定义分页
@@ -157,19 +162,35 @@
                     result = pre + (decimalFormat.format(count));
                  }
                  user.setSecuritynumber(result);
                  //发证日期
//               user.setPaperTime(new Date());
                  //修改为持证保安
                  user.setHold("1");
                  //更新保安数据
                  userService.updateById(user);

//                  String s1 =
//                     "update blade_user set hold = " + "'" + user.getHold() + "'" +
//                        ",securitynumber = " + "'" + user.getSecuritynumber() + "'" +
//                        ",is_train = " + "'" + user.getIsTrain() + "'" +
//                        " " + "where id = " + "'" + user.getId() + "'";
//                  FtpUtil.sqlFileUpload(s1);
                  //生成保安证的同时向保安证管理表中插入一条数据
                  SecurityPaper securityPaper = new SecurityPaper();
                  securityPaper.setUserId(user.getId());
                  securityPaper.setNumber(result);
                  securityPaper.setCreateTime(new Date());
                  securityPaper.setIdCardNo(user.getCardid());
                  securityPaper.setPeopleName(user.getRealName());
                  securityPaper.setExamId(Long.parseLong(examScore.getExamId()));
                  securityPaper.setApplyId(examScore.getApplyId());
                  //新增保安员证信息
                  securityPaperService.save(securityPaper);

                  //数据同步
                  String s1 =
                     "insert into sys_security_paper(id,number,create_time,people_name,id_card_no,user_id,apply_id,exam_id) " +
                        "values(" + "'" + securityPaper.getId() + "'"
                        + "," + "'" + securityPaper.getNumber() +"'"
                        + "," + "'" + new SimpleDateFormat("yyyy-MM-dd HH:mm:ss").format(securityPaper.getCreateTime()) +"'"
                        + "," + "'" + securityPaper.getPeopleName() + "'"
                        + "," + "'" + securityPaper.getIdCardNo() + "'"
                        + "," + "'" + securityPaper.getUserId() + "'"
                        + "," + "'" + securityPaper.getApplyId() + "'"
                        + "," +"'" + securityPaper.getExamId() + "'" + ")";
                  FtpUtil.sqlFileUpload(s1);
               }
            } else {
               //不合格