新增数据同步方式及配置，当选择为sql时则为数据库直连同步，全局替换所有的同步方法，用户修改，离职，注销修改调整，文件上传去除同步推送上传

zhongrj

2022-08-22 3c607f075990d6d3238daa7db1c68eaae8126424

 src/main/java/org/springblade/modules/apply/service/impl/ApplyServiceImpl.java

@@ -28,8 +28,10 @@
import org.springblade.modules.exam.service.ExamScoreService;
import org.springblade.modules.system.entity.User;
import org.springblade.modules.system.service.IUserService;
import org.springblade.modules.system.service.MyAsyncService;
import org.springblade.modules.training.entity.TrainingRegistration;
import org.springblade.modules.training.service.TrainingRegistrationService;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Service;
import org.springframework.transaction.annotation.Transactional;

@@ -40,23 +42,23 @@
import java.text.SimpleDateFormat;
import java.util.*;

import static org.springblade.common.constant.FtpConstant.*;
import static org.springblade.common.constant.FtpConstant.fileName;

/**
 * 考试报名服务实现类
 * @author zhongrj
 */
@Service
@AllArgsConstructor
public class ApplyServiceImpl extends ServiceImpl<ApplyMapper, Apply> implements ApplyService {

   @Autowired
   private ExamPaperService examPaperService;

   private final ExamPaperService examPaperService;
   @Autowired
   private IUserService userService;

   private final IUserService userService;

   private final TrainingRegistrationService trainingRegistrationService;
   @Autowired
   private TrainingRegistrationService trainingRegistrationService;
   @Autowired
   private  MyAsyncService myAsyncService;

   /**
    * 自定义分页数据
@@ -106,7 +108,7 @@
    */
   @Override
   @Transactional(rollbackFor = Exception.class)
   public void importApply(List<ApplyExcel> data, Boolean isCovered) {
   public void importApply(List<ApplyExcel> data, Boolean isCovered,Long examId) {
      data.forEach(applyExcel -> {
         //查询用户信息
         User user = new User();
@@ -121,6 +123,12 @@
               apply1.setIsExam(1);
               apply1.setApplyTime(new Date());
               apply1.setUserId(user1.getId());
               if (null!=examId){
                  apply1.setExamId(examId);
                  //生成准考证号
                  apply1.setCandidateNo(getCandidateNo(apply1));
               }

               this.save(apply1);
               //修改保安报名状态
               user1.setIsApply(1);
@@ -128,19 +136,17 @@

               String formatStr = new SimpleDateFormat("yyyy-MM-dd HH:mm:ss").format(new Date());
               Long id = apply1.getId();
               String s = "insert into sys_apply(id,user_id,apply_time,apply_status,is_exam) " +
                  "values(" + "'" + id + "'" + "," + "'" + apply1.getUserId() + "'" + "," + "'" + formatStr +
                  "'" + "," + "'" + apply1.getApplyStatus() + "'" + "," +"'" + apply1.getIsExam() + "'" + ");" +
               String s = "insert into sys_apply(id,user_id,candidate_no,apply_time,apply_status,exam_id,is_exam) " +
                  "values(" + "'" + id + "'" + ","
                  + "'" + apply1.getUserId() + "'" + ","
                  + "'" + apply1.getCandidateNo() + "'" + ","
                  + "'" + formatStr +"'" + ","
                  + "'" + apply1.getApplyStatus() + "'" + ","
                  + "'" + examId + "'" + ","
                  +"'" + apply1.getIsExam() + "'" + ");" +
                  "update blade_user set is_apply = " + "'" + user1.getIsApply() + "'" +"where id = " + "'" + user1.getId() + "'";
               String json = JSON.toJSONString(s);
               OutJson.createJsonFile(json, "d:/", "wsql");
               FileInputStream in = null;
               try {
                  in = new FileInputStream(new File("D:\\" + fileName));
               } catch (FileNotFoundException e) {
                  e.printStackTrace();
               }
               FtpUtil.uploadFile(ftpHost, ftpPort, ftpUserName, ftpPassword, "anbao/", "/", fileName, in);
               //FtpUtil.sqlFileUpload(s);
               myAsyncService.dataSync(s);
            }else {
               if (user1.getIsApply()!=1) {
                  Apply apply1 = new Apply();
@@ -149,6 +155,11 @@
                  apply1.setIsExam(1);
                  apply1.setApplyTime(new Date());
                  apply1.setUserId(user1.getId());
                  if (null!=examId){
                     apply1.setExamId(examId);
                     //生成准考证号
                     apply1.setCandidateNo(getCandidateNo(apply1));
                  }
                  this.save(apply1);
                  //修改保安报名状态
                  user1.setIsApply(1);
@@ -157,19 +168,17 @@
                  //内网数据同步
                  String formatStr = new SimpleDateFormat("yyyy-MM-dd HH:mm:ss").format(new Date());
                  Long id = apply1.getId();
                  String s = "insert into sys_apply(id,user_id,apply_time,apply_status,is_exam) " +
                     "values(" + "'" + id + "'" + "," + "'" + apply1.getUserId() + "'" + "," + "'" + formatStr +
                     "'" + "," + "'" + apply1.getApplyStatus() + "'" + "," +"'" + apply1.getIsExam() + "'" + ");" +
                  String s = "insert into sys_apply(id,user_id,candidate_no,apply_time,apply_status,exam_id,is_exam) " +
                     "values(" + "'" + id + "'" + ","
                     + "'" + apply1.getUserId() + "'" + ","
                     + "'" + apply1.getCandidateNo() + "'" + ","
                     + "'" + formatStr +"'" + ","
                     + "'" + apply1.getApplyStatus() + "'" + ","
                     + "'" + examId + "'" + ","
                     +"'" + apply1.getIsExam() + "'" + ");" +
                     "update blade_user set is_apply = " + "'" + user1.getIsApply() + "'" +"where id = " + "'" + user1.getId() + "'";
                  String json = JSON.toJSONString(s);
                  OutJson.createJsonFile(json, "d:/", "wsql");
                  FileInputStream in = null;
                  try {
                     in = new FileInputStream(new File("D:\\" + fileName));
                  } catch (FileNotFoundException e) {
                     e.printStackTrace();
                  }
                  FtpUtil.uploadFile(ftpHost, ftpPort, ftpUserName, ftpPassword, "anbao/", "/", fileName, in);
                  //FtpUtil.sqlFileUpload(s);
                  myAsyncService.dataSync(s);
               }
            }
         }
@@ -390,8 +399,10 @@
    * @return
    */
   @Override
   public List<Long> getApplyIds() {
      return baseMapper.getApplyIds();
   public List<Apply> getApplyIds(ApplyVO applyVO) {
      applyVO.setSerialStart(applyVO.getSerialStart() -1);
      applyVO.setSerialEnd(applyVO.getSerialEnd() -applyVO.getSerialStart());
      return baseMapper.getApplyIds(applyVO);
   }

   /**
@@ -456,6 +467,11 @@
         //考试中
         apply1.setIsExam(3);
         baseMapper.updateById(apply1);

         String s1 =
            "update sys_apply set is_exam = " + apply1.getIsExam() + " " +"where id = " + "'" + apply1.getId() + "'";
         //FtpUtil.sqlFileUpload(s1);
         myAsyncService.dataSync(s1);
      }
      //模拟考
      if (apply.getExamType()==2){
@@ -463,7 +479,13 @@
         trainingRegistration.setId(apply.getId());
         //考试中
         trainingRegistration.setIsExam(3);
//         trainingRegistration.setIsExam(1);
         trainingRegistrationService.updateById(trainingRegistration);

         String s1 =
            "update sys_training_registration set is_exam = " + trainingRegistration.getIsExam() + " " +"where id = " + "'" + trainingRegistration.getId() + "'";
         //FtpUtil.sqlFileUpload(s1);
         myAsyncService.dataSync(s1);
      }
   }