用户查询接口修改，部门名称需拼接父部门名称

Administrator

2021-09-22 35a6e9cedc2f44bebc9e4ec81a429eddc8b631ea

 src/main/java/org/springblade/modules/resource/endpoint/OssEndpoint.java

@@ -458,6 +458,7 @@
            if (null!=user){
               ExamPayment examPayment = new ExamPayment();
               examPayment.setWorkerId(user.getId().toString());
               examPayment.setPaymentStatus(1);
               examPayment.setCertificateUrl(urls);
               examPayment.setType(1);
               examPayment.setPaymentTime(new Date());
@@ -472,12 +473,12 @@

               //数据推送
               String formatStr = new SimpleDateFormat("yyyy-MM-dd HH:mm:ss").format(examPayment.getPaymentTime());
               String s = "insert into sys_apply(id,type,payment_time,worker_id,apply_code,certificate_url) " +
               String s = "insert into sys_exam_payment(id,type,payment_time,worker_id,payment_status,certificate_url) " +
                  "values(" + "'" + examPayment.getId() + "'" +
                  "," + "'" + examPayment.getType() + "'" +
                  "," + "'" + formatStr + "'" +
                  "," + "'" + examPayment.getWorkerId() + "'" +
                  "," + "'" + examPayment.getApplyCode() + "'" +
                  "," + "'" + examPayment.getPaymentStatus() + "'" +
                  "," +"'" + examPayment.getCertificateUrl() + "'" + ")";
               FtpUtil.sqlFileUpload(s);

@@ -631,7 +632,23 @@
         "insert into blade_attach(id,tenant_id,link,domain,name,original_name,extension,attach_size,create_user,deptid," +
            "create_time,update_user,update_time,status,is_deleted,type,cardid";
      if (noticeId != null) {
         s1 += ",notice_id";
         s1 += ",notice_id"+")" +"values(" + "'" + attach.getId() + "'" + "," +
            "'" + attach.getTenantId() + "'" + "," +
            "'" + imgurl + "'" + "," +
            "'" + ip + "'" + "," +
            "'" + split[2] + "'" + "," +
            "'" + attach.getOriginalName() + "'" + "," +
            "'" + attach.getExtension() + "'" + "," +
            "'" + attach.getAttachSize() + "'" + "," +
            "'" + attach.getCreateUser() + "'" + "," +
            "'" + attach.getDeptid() + "'" + "," +
            "'" + new SimpleDateFormat("yyyy-MM-dd HH:mm:ss").format(new Date()) + "'" + "," +
            "'" + attach.getUpdateUser() + "'" + "," +
            "'" + new SimpleDateFormat("yyyy-MM-dd HH:mm:ss").format(new Date()) + "'" + "," +
            "'" + attach.getStatus() + "'" + "," +
            "'" + attach.getIsDeleted() + "'" + "," +
            "'" + attach.getType() + "'" + "," +
            "'" + cardid + "'";
      } else {
         s1 += ") " +
            "values(" + "'" + attach.getId() + "'" + "," +
@@ -653,7 +670,7 @@
            "'" + cardid + "'";
      }
      if (noticeId != null) {
         s1 += "'" + noticeId + "'" + ")";
         s1 += ","+"'" + noticeId + "'" + ")";
      } else {
         s1 += ")";
      }