证书打印信息导出修改,已过考试的，系统每天凌晨1点定时清理，标记为缺考，并生成缺考记录，保安员导入新增年龄判断，超过60岁的不能导入

Administrator

2021-11-18 19f40c8e0649ae81b3f0183a6f4c8aa6c3db39bc

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

@@ -61,6 +61,11 @@
         records.setAuditStatus(1);
         records.setType(accreditationRecords.getType());
         records.setUserId(Long.parseLong(id));
         //判断类型，如果是上岗证则判断是否有申请，有申请的不在新增记录
         if (accreditationRecords.getType()==1){
            //查询当前人员是否有申请记录
            int count  = baseMapper.getAccreditationRecordsByUserIdCount(id);
            if (count<1){
         //新增
         this.save(records);

@@ -74,6 +79,29 @@
            + "'" + records.getType() +"'" + ","
            +"'" + records.getAuditStatus() + "'" + ")";
         FtpUtil.sqlFileUpload(s);
            }
         }
         //判断类型，如果是证书的，审核未通过的可以再次申请，审核通过的，暂时不给于新增记录
         if (accreditationRecords.getType()==2){
            //查询当前人员是否有待审核和审核通过的记录数
            int count  = baseMapper.getAccreditationRecordsByUserIdAuditCount(id);
            if (count<1){
               //新增
               this.save(records);

               //内网新增
               String s = "insert into sys_accreditation_records(id,user_id,create_time,create_user,status,type,audit_status) " +
                  "values(" + "'" + records.getId() + "'" + ","
                  + "'" + records.getUserId() + "'" + ","
                  + "'" + new SimpleDateFormat("yyyy-MM-dd HH:mm:ss").format(records.getCreateTime()) + "'" + ","
                  + "'" + records.getCreateUser() +"'" + ","
                  + "'" + records.getStatus() +"'" + ","
                  + "'" + records.getType() +"'" + ","
                  +"'" + records.getAuditStatus() + "'" + ")";
               FtpUtil.sqlFileUpload(s);
            }
         }

      });
      return true;
   }