枪支，车辆批量导入，制证申请修改，审核通过状态修改为未制证

Administrator

2021-11-15 8782a61b92d8dc1f8d3fd7d16a517fa934ac7e96

 src/main/java/org/springblade/modules/accreditation/controller/AccreditationRecordsController.java

@@ -14,6 +14,7 @@
import org.springblade.modules.FTP.FtpUtil;
import org.springblade.modules.accreditation.excel.ExportSecurityBookPaperExcel;
import org.springblade.modules.accreditation.excel.ExportSecurityPaperExcel;
import org.springblade.modules.system.entity.User;
import org.springblade.modules.system.service.IUserService;
import org.springblade.modules.accreditation.entity.AccreditationRecords;
import org.springblade.modules.accreditation.service.AccreditationRecordsService;
@@ -82,15 +83,39 @@
   @PostMapping("/audit")
   public R audit(@RequestBody AccreditationRecords accreditationRecords){
      accreditationRecords.setAuditTime(new Date());

      boolean b = accreditationRecordsService.updateById(accreditationRecords);
      //内网同步
      String s =
         "update sys_accreditation_records set audit_status = " + accreditationRecords.getAuditStatus() + "" +
            ",audit_detail = " + accreditationRecords.getAuditDetail() + "" +
            ",audit_time = " + new SimpleDateFormat("yyyy-MM-dd HH:mm:ss").format(accreditationRecords.getAuditTime()) + "" +
            ",audit_user = " + accreditationRecords.getAuditUser() + " " +
            "where id = " + "'" + accreditationRecords.getId() + "'";
      FtpUtil.sqlFileUpload(s);
      //审核通过
      if (accreditationRecords.getAuditStatus()==2){
         //修改为未制证状态
         AccreditationRecords records = accreditationRecordsService.getById(accreditationRecords);
         User user = userService.getById(records.getUserId());
         user.setUserType(7);
         user.setUpdateTime(new Date());
         //更新
         userService.updateById(user);

         //内网同步
         String s =
            "update sys_accreditation_records set audit_status = " + accreditationRecords.getAuditStatus() + "" +
               ",audit_detail = " + accreditationRecords.getAuditDetail() + "" +
               ",audit_time = " + new SimpleDateFormat("yyyy-MM-dd HH:mm:ss").format(accreditationRecords.getAuditTime()) + "" +
               ",audit_user = " + accreditationRecords.getAuditUser() + " " +
               "where id = " + "'" + accreditationRecords.getId() + "';" +
            "update blade_user set user_type = " + user.getUserType() + "" +
               ",update_time = " + new SimpleDateFormat("yyyy-MM-dd HH:mm:ss").format(user.getUpdateTime()) + "" +
               "where id = " + "'" + user.getId() + "'";
         FtpUtil.sqlFileUpload(s);
      }else {
         //内网同步
         String s =
            "update sys_accreditation_records set audit_status = " + accreditationRecords.getAuditStatus() + "" +
               ",audit_detail = " + accreditationRecords.getAuditDetail() + "" +
               ",audit_time = " + new SimpleDateFormat("yyyy-MM-dd HH:mm:ss").format(accreditationRecords.getAuditTime()) + "" +
               ",audit_user = " + accreditationRecords.getAuditUser() + " " +
               "where id = " + "'" + accreditationRecords.getId() + "'";
         FtpUtil.sqlFileUpload(s);
      }
      //返回
      return R.status(b);
   }
@@ -110,14 +135,37 @@
         accreditationRecords.setId(Long.parseLong(id));
         accreditationRecords.setAuditTime(new Date());
         accreditationRecordsService.updateById(accreditationRecords);
         //内网同步
         String s =
            "update sys_accreditation_records set audit_status = " + accreditationRecords.getAuditStatus() + "" +
               ",audit_detail = " + accreditationRecords.getAuditDetail() + "" +
               ",audit_time = " + new SimpleDateFormat("yyyy-MM-dd HH:mm:ss").format(accreditationRecords.getAuditTime()) + "" +
               ",audit_user = " + accreditationRecords.getAuditUser() + " " +
               "where id = " + "'" + accreditationRecords.getId() + "'";
         FtpUtil.sqlFileUpload(s);
         //审核通过
         if (accreditationRecords.getAuditStatus()==2){
            //修改为未制证状态
            AccreditationRecords records = accreditationRecordsService.getById(id);
            User user = userService.getById(records.getUserId());
            user.setUserType(7);
            user.setUpdateTime(new Date());
            //更新
            userService.updateById(user);

            //内网同步
            String s =
               "update sys_accreditation_records set audit_status = " + accreditationRecords.getAuditStatus() + "" +
                  ",audit_detail = " + accreditationRecords.getAuditDetail() + "" +
                  ",audit_time = " + new SimpleDateFormat("yyyy-MM-dd HH:mm:ss").format(accreditationRecords.getAuditTime()) + "" +
                  ",audit_user = " + accreditationRecords.getAuditUser() + " " +
                  "where id = " + "'" + accreditationRecords.getId() + "';" +
               "update blade_user set user_type = " + user.getUserType() + "" +
                  ",update_time = " + new SimpleDateFormat("yyyy-MM-dd HH:mm:ss").format(user.getUpdateTime()) + "" +
                  "where id = " + "'" + user.getId() + "'";
            FtpUtil.sqlFileUpload(s);
         }else {
            //内网同步
            String s =
               "update sys_accreditation_records set audit_status = " + accreditationRecords.getAuditStatus() + "" +
                  ",audit_detail = " + accreditationRecords.getAuditDetail() + "" +
                  ",audit_time = " + new SimpleDateFormat("yyyy-MM-dd HH:mm:ss").format(accreditationRecords.getAuditTime()) + "" +
                  ",audit_user = " + accreditationRecords.getAuditUser() + " " +
                  "where id = " + "'" + accreditationRecords.getId() + "'";
            FtpUtil.sqlFileUpload(s);
         }
      });
      //返回
      return R.status(true);