上岗证导出修改，新增性别，制证时间导出

Administrator

2021-12-10 c22eae503a6c5884b63737b4ee68fe987d0c9315

上岗证导出修改，新增性别，制证时间导出

 src/main/java/org/springblade/modules/accreditation/excel/ExportSecurityPaperExcel.java

@@ -33,7 +33,7 @@
@Data
@ColumnWidth(25)
@HeadRowHeight(20)
@ContentRowHeight(125)
@ContentRowHeight(100)
public class ExportSecurityPaperExcel implements Serializable {
    private static final long serialVersionUID = 1L;

@@ -45,6 +45,10 @@
    @ExcelProperty("身份证号码")
    private String idCardNo;

    @ColumnWidth(20)
    @ExcelProperty("性别")
    private String sex;

    @ColumnWidth(35)
    @ExcelProperty("企业名称")
    private String deptName;
@@ -55,10 +59,14 @@
    private String securityNumber;

    @ColumnWidth(20)
    @ExcelProperty("发证日期")
    private String paperTime;

    @ColumnWidth(12)
    @ExcelProperty("照片")
    private URL avatar;

    @ColumnWidth(20)
    @ColumnWidth(16)
    @ExcelProperty("二维码图片")
    private byte[] qrCode;
}

 src/main/java/org/springblade/modules/accreditation/service/impl/AccreditationRecordsServiceImpl.java

@@ -135,6 +135,12 @@
                excel.setRealName(accreditationRecordsVo.getRealName());
                excel.setIdCardNo(accreditationRecordsVo.getIdCardNo());
                excel.setDeptName(accreditationRecordsVo.getDeptName());
                if (accreditationRecordsVo.getSex().equals("1")){
                    excel.setSex("男");
                }else {
                    excel.setSex("女");
                }
                excel.setPaperTime(new SimpleDateFormat("yyyy-MM-dd").format(new Date()));
                //如果头像有
                if (null != accreditationRecordsVo.getAvatar() && accreditationRecordsVo.getAvatar() != "") {
                    try {
@@ -188,7 +194,7 @@
    public List<AccreditationRecordsVo> exportSecurityBookPapers(AccreditationRecordsVo accreditationRecords) {
        //查询数据
        List<AccreditationRecordsVo> accreditationRecordsVos = baseMapper.exportSecurityBookPapers(accreditationRecords);
        System.out.println("accreditationRecordsVos = " + accreditationRecordsVos.size());
//        System.out.println("accreditationRecordsVos = " + accreditationRecordsVos.size());
        return accreditationRecordsVos;
    }
}