ftp sql 同步封装

Administrator

2021-12-15 8d43111bd0e598bc0b2014cbfa69a32e74959dff

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

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