ftp sql 同步封装

Administrator

2021-12-15 8d43111bd0e598bc0b2014cbfa69a32e74959dff

 src/main/java/org/springblade/modules/apply/controller/ApplyController.java

@@ -10,7 +10,6 @@
import net.sourceforge.pinyin4j.format.HanyuPinyinOutputFormat;
import net.sourceforge.pinyin4j.format.HanyuPinyinToneType;
import net.sourceforge.pinyin4j.format.exception.BadHanyuPinyinOutputFormatCombination;
import org.springblade.common.utils.arg;
import org.springblade.core.excel.util.ExcelUtil;
import org.springblade.core.mp.support.Condition;
import org.springblade.core.mp.support.Query;
@@ -33,6 +32,7 @@
import org.springblade.modules.system.entity.User;
import org.springblade.modules.system.service.IUserService;
import org.springblade.modules.training.vo.TrainingRegistrationVo;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.web.bind.annotation.*;
import org.springframework.web.multipart.MultipartFile;

@@ -44,7 +44,7 @@
import java.text.SimpleDateFormat;
import java.util.*;

import static org.springblade.common.constant.FtpConstant.*;
import static org.springblade.common.config.FtpConfig.*;

/**
 * @author zhongrj
@@ -56,12 +56,16 @@
@RequestMapping("/apply")
public class ApplyController {

//   @Autowired
   private final ApplyService applyService;

//   @Autowired
   private final ExamPaperService examPaperService;

//   @Autowired
   private final IUserService userService;

//   @Autowired
   private final ExamScoreService examScoreService;

   /**
@@ -370,6 +374,12 @@
    */
   @PostMapping("/remove")
   public R remove(@ApiParam(value = "主键集合") @RequestParam String ids) {
      List<String> list = Arrays.asList(ids.split(","));
      list.forEach(id -> {
         //内网同步
         String s1 = "delete from sys_apply where id = " + "'" + id + "'";
         FtpUtil.sqlFileUpload(s1);
      });
      return R.status(applyService.removeByIds(Func.toLongList(ids)));
   }

@@ -692,19 +702,21 @@
      examScore.setExamId(apply.getExamId().toString());
      examScore.setUserId(apply.getUserId().toString());
      examScore.setApplyId(apply.getId());
      examScore.setCandidateNo(apply.getCandidateNo());
      examScore.setExamTime(new Date());
      //新增考试成绩
      examScoreService.save(examScore);
      //内网同步
      Long sid = examScore.getId();
      String format = new SimpleDateFormat("yyyy-MM-dd HH:mm:ss").format(examScore.getExamTime());
//      String s = "insert into exam_score(id,exam_time,user_id,exam_id,apply_id) " +
//         "values(" + "'" + sid + "'" + "," + "'" +
//         format + "'" + "," + "'" +
//         examScore.getUserId() +"'" + ","  +"'" +
//         examScore.getExamId() +"'" + ","  +"'" +
//         examScore.getApplyId() + "'" + ")";
//      FtpUtil.sqlFileUpload(s);
      String s = "insert into exam_score(id,candidate_no,exam_time,user_id,exam_id,apply_id) " +
         "values(" + "'" + sid + "'" +
         "," + "'" + examScore.getCandidateNo() + "'" +
         "," + "'" + format + "'" +
         "," + "'" + examScore.getUserId() +"'" +
         ","  +"'" + examScore.getExamId() +"'" +
         ","  +"'" + examScore.getApplyId() + "'" + ")";
      FtpUtil.sqlFileUpload(s);
      return examScore;
   }

@@ -731,7 +743,7 @@
      } catch (FileNotFoundException e) {
         e.printStackTrace();
      }
      FtpUtil.uploadFile(ftpHost_dev, ftpPort, ftpUserName, ftpPassword, ftpPath, "/",  "f"+response1+".json", in1);
      FtpUtil.uploadFile(ftpHost, ftpPort, ftpUserName, ftpPassword, ftpPath, "/",  "f"+response1+".json", in1);
      return "成功";
   }