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

Administrator

2022-04-29 65df638262767763375933e8395d5e2253da1798

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

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

@@ -8,6 +8,7 @@
import lombok.AllArgsConstructor;
import org.apache.commons.codec.Charsets;
import org.springblade.common.excel.RowWriteHandler;
import org.springblade.common.utils.DesensitizedUtil;
import org.springblade.core.excel.util.ExcelUtil;
import org.springblade.core.mp.support.Condition;
import org.springblade.core.mp.support.Query;
@@ -198,7 +199,6 @@
                        max++;
                        result = pre + (decimalFormat.format(max));
                    }
                    user1.setSecuritynumber(result);

                    //生成保安证的同时向保安证管理表中插入一条数据
                    SecurityPaper securityPaper = new SecurityPaper();
@@ -210,20 +210,44 @@
                    securityPaper.setExamId(Long.parseLong(examScore1.getExamId()));
                    securityPaper.setApplyId(examScore1.getApplyId());
                    securityPaper.setSource(1);

                    //脱敏,内网
                    SecurityPaper paper1 = securityPaper;
                    //新增保安员证信息
                    securityPaper.setIdCardNo("");
                    securityPaper.setNumber(DesensitizedUtil.desensitizedSecurityNumber(result));
                    securityPaperService.save(securityPaper);

                    //保安证编号同步内网
                    //设置id
                    paper1.setId(securityPaper.getId());
                    //数据同步
                    String s = "insert into sys_security_paper(id,number,create_time,people_name,id_card_no,user_id,apply_id,exam_id,source) " +
                        "values(" + "'" + paper1.getId() + "'" + "," +
                        "'" + paper1.getNumber() + "'" + "," +
                        "," + "'" + new SimpleDateFormat("yyyy-MM-dd HH:mm:ss").format(paper1.getCreateTime()) + "'" +
                        "," + "'" + paper1.getPeopleName() + "'" +
                        "," + "'" + paper1.getIdCardNo() + "'" +
                        "," + "'" + paper1.getUserId() + "'" +
                        "," + "'" + paper1.getApplyId() + "'" +
                        "," + "'" + paper1.getExamId() + "'" +
                        "," + "'" + paper1.getSource() + "'"
                        + ")";
                    myAsyncService.FTP(s);


                    //修改为持证保安
                    user1.setHold("1");
                    user1.setSecuritynumber(DesensitizedUtil.desensitizedSecurityNumber(result));
                    //更新保安数据
                    boolean b = userService.updateById(user1);
                    if (b) {
                        //数据同步
                        String s1 =
                            "update blade_user set hold = " + "'" + user1.getHold() + "'" +
                                ",securitynumber = " + "'" + user1.getSecuritynumber() + "'" +
                                ",securitynumber = " + "'" + result + "'" +
                                ",user_type = " + "'" + user1.getUserType() + "'" +
                                " " + "where id = " + "'" + user1.getId() + "'";
                        //FtpUtil.sqlFileUpload(s1);
                        myAsyncService.FTP(s1);
                    }
                }
@@ -254,7 +278,6 @@
                ",all_grade = " + "'" + examScore.getAllGrade() + "'" +
                ",qualified = " + "'" + examScore.getQualified() + "'" +
                " " + "where id = " + "'" + examScore.getId() + "'";
        //FtpUtil.sqlFileUpload(s1);
        myAsyncService.FTP(s1);

        //本地修改

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

@@ -4,6 +4,7 @@
import com.baomidou.mybatisplus.core.metadata.IPage;
import com.baomidou.mybatisplus.extension.service.impl.ServiceImpl;
import org.apache.commons.lang3.StringUtils;
import org.springblade.common.utils.DesensitizedUtil;
import org.springblade.core.log.exception.ServiceException;
import org.springblade.core.mp.support.Condition;
import org.springblade.modules.FTP.FtpUtil;
@@ -314,7 +315,8 @@
                                                count++;
                                                result = pre + (decimalFormat.format(count));
                                            }
                                            user.setSecuritynumber(result);
                                            //脱敏处理
                                            user.setSecuritynumber(DesensitizedUtil.desensitizedSecurityNumber(result));
                                            //修改为持证保安
                                            user.setHold("1");
                                            user.setUpdateTime(new Date());
@@ -331,32 +333,32 @@
                                            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,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() + "'" + ");" +
                                                "update blade_user set hold = " + "'" + user.getHold() + "'" +
                                                    ",securitynumber = " + "'" + user.getSecuritynumber() + "'" +
                                                    ",securitynumber = " + "'" + result + "'" +
                                                    ",update_time = " + "'" + new SimpleDateFormat("yyyy-MM-dd HH:mm:ss").format(user.getUpdateTime()) + "'" +
                                                    ",user_type = " + "'" + user.getUserType() + "'" +
                                                    " " + "where id = " + "'" + user.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() + "'" + ");" +
//                                                "update blade_user set hold = " + "'" + user.getHold() + "'" +
//                                                    ",securitynumber = " + "'" + user.getSecuritynumber() + "'" +
//                                                    ",update_time = " + "'" + new SimpleDateFormat("yyyy-MM-dd HH:mm:ss").format(user.getUpdateTime()) + "'" +
//                                                    ",user_type = " + "'" + user.getUserType() + "'" +
//                                                    " " + "where id = " + "'" + user.getId() + "'";
                                            //FtpUtil.sqlFileUpload(s1);
                                            myAsyncService.FTP(s1);
                                        }
                                    }
@@ -392,7 +394,7 @@
                                //更新成绩数据
                                baseMapper.updateById(examScore);
                            } else {
                                errorList.add(examScoreExcel.getIdCardNo());
                                errorList.add(examScoreExcel.getName());
                                status.set(false);
                            }
                        });

 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);
            }
        }