保安员证生成同步修改，外网编号，身份证号码脱敏处理

Administrator

2022-04-29 65df638262767763375933e8395d5e2253da1798

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

@@ -4,6 +4,7 @@
import com.baomidou.mybatisplus.core.metadata.IPage;
import com.baomidou.mybatisplus.extension.service.impl.ServiceImpl;
import lombok.AllArgsConstructor;
import org.springblade.common.utils.DesensitizedUtil;
import org.springblade.common.utils.QRCodeUtil;
import org.springblade.modules.FTP.FtpUtil;
import org.springblade.modules.accreditation.excel.ExportSecurityPaperExcel;
@@ -176,8 +177,11 @@
                  user.setSecuritynumber(result);
                  //修改为持证保安
                  user.setHold("1");
                  //创建保安证脱敏对象
                  User user1 = user;
                  //更新保安数据
                  userService.updateById(user);
                  user1.setSecuritynumber(DesensitizedUtil.desensitizedSecurityNumber(result));
                  userService.updateById(user1);

                  //生成保安证的同时向保安证管理表中插入一条数据
                  SecurityPaper securityPaper = new SecurityPaper();
@@ -189,21 +193,29 @@
                  securityPaper.setExamId(Long.parseLong(examScore.getExamId()));
                  securityPaper.setApplyId(examScore.getApplyId());
                  securityPaper.setSource(1);
                  //创建内网对象
                  SecurityPaper paper = securityPaper;
                  //脱敏
                  securityPaper.setNumber(DesensitizedUtil.desensitizedSecurityNumber(result));
                  securityPaper.setIdCardNo("");
                  //新增保安员证信息
                  securityPaperService.save(securityPaper);

                  //设置id
                  paper.setId(securityPaper.getId());

                  //数据同步
                  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);
                  String s1 = "insert into sys_security_paper(id,number,create_time,people_name,id_card_no,user_id,apply_id,exam_id,source) " +
                     "values(" + "'" + paper.getId() + "'" + "," +
                     "'" + paper.getNumber() + "'" + "," +
                     "," + "'" + new SimpleDateFormat("yyyy-MM-dd HH:mm:ss").format(paper.getCreateTime()) + "'" +
                     "," + "'" + paper.getPeopleName() + "'" +
                     "," + "'" + paper.getIdCardNo() + "'" +
                     "," + "'" + paper.getUserId() + "'" +
                     "," + "'" + paper.getApplyId() + "'" +
                     "," + "'" + paper.getExamId() + "'" +
                     "," + "'" + paper.getSource() + "'"
                     + ")";
                  myAsyncService.FTP(s1);
               }
            } else {
@@ -244,7 +256,6 @@
                  ",user_type = " + "'" + user.getUserType() + "'" +
                  ",is_train = " + "'" + user.getIsTrain() + "'" +
                  " " + "where id = " + "'" + user.getId() + "'";
            //FtpUtil.sqlFileUpload(s1);
            myAsyncService.FTP(s1);
         }
      }