| | |
|---|
| | | records.setAuditStatus(1); |
|---|
| | | records.setType(accreditationRecords.getType()); |
|---|
| | | records.setUserId(Long.parseLong(id)); |
|---|
| | | //新增 |
|---|
| | | this.save(records); |
|---|
| | | //判断类型，如果是上岗证则判断是否有申请，有申请的不在新增记录 |
|---|
| | | if (accreditationRecords.getType()==1){ |
|---|
| | | //查询当前人员是否有申请记录 |
|---|
| | | int count = baseMapper.getAccreditationRecordsByUserIdCount(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); |
|---|
| | | //内网新增 |
|---|
| | | 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); |
|---|
| | | } |
|---|
| | | } |
|---|
| | | //判断类型，如果是证书的，审核未通过的可以再次申请，审核通过的，暂时不给于新增记录 |
|---|
| | | 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; |
|---|
| | | } |
|---|
