智慧保安后台管理-外网
Administrator
2022-01-05 d99a7a5fff2641459f8746138a678de043ff2c3e
src/main/java/org/springblade/modules/training/controller/TrainingRegistrationController.java
@@ -25,6 +25,7 @@
import org.springblade.modules.exam.service.ExamPaperService;
import org.springblade.modules.system.entity.User;
import org.springblade.modules.system.service.IUserService;
import org.springblade.modules.system.vo.UserVO;
import org.springblade.modules.training.entity.TrainingRegistration;
import org.springblade.modules.training.excel.TrainingRegistrationExcel;
import org.springblade.modules.training.excel.TrainingRegistrationImporter;
@@ -139,7 +140,7 @@
         + "," + "'" + trainingRegistration.getIsExam() + "'"
         + "," +"'" + trainingRegistration.getAuditStatus() + "'" + ");" +
         "update blade_user set is_train = " + user1.getIsTrain() + " " +"where id = " + "'" + user1.getId() + "'";
      return FtpSyncUtil.sqlHandler(builder, sql);
      return FtpSyncUtil.sqlHandler(builder, sql,500);
   }
   /**
@@ -196,13 +197,9 @@
            if (status){
               return R.data(200,"取消报名成功");
            }
         }else {
            return R.data(201,"尚未报名");
         }
      }
      return R.data(202,"取消报名失败");
   }
@@ -302,13 +299,13 @@
      AtomicInteger count  = new AtomicInteger();
      //创建年龄部分对象集合
      List<String> errorList = new ArrayList<>();
      AtomicReference<StringBuilder> builder = new AtomicReference<>(new StringBuilder());
//      AtomicReference<StringBuilder> builder = new AtomicReference<>(new StringBuilder());
      //遍历
      list.forEach(userId ->{
         User user = userService.getById(userId);
         UserVO userVO = userService.getUserAgeById(Long.parseLong(userId));
         //判断年龄
         Integer age = AgeUtil.idCardToAge(user.getCardid());
         if (age>=18 && age<=60) {
         if (userVO.getAge()>=18 && userVO.getAge()<=60) {
            //未报名的新增,已报名的不做处理
            if (null == user.getIsTrain()) {
               TrainingRegistration trainingRegistration1 = new TrainingRegistration();
@@ -326,7 +323,8 @@
               userService.updateById(user);
               //数据同步
               builder.set(batchSaveTrainingRegistration(trainingRegistration1, user, builder.get()));
               saveTrainingRegistration(trainingRegistration1,user);
//               builder.set(batchSaveTrainingRegistration(trainingRegistration1, user, builder.get()));
            } else {
               if (user.getIsTrain() != 1) {
                  TrainingRegistration trainingRegistration1 = new TrainingRegistration();
@@ -344,7 +342,8 @@
                  userService.updateById(user);
                  //数据同步
                  builder.set(batchSaveTrainingRegistration(trainingRegistration1, user, builder.get()));
                  saveTrainingRegistration(trainingRegistration1,user);
//                  builder.set(batchSaveTrainingRegistration(trainingRegistration1, user, builder.get()));
               }
            }
         }else {
@@ -354,10 +353,10 @@
            errorList.add(user.getCardid());
         }
      });
      //同步
      if (builder.get().length()>0) {
         FtpSyncUtil.slqSync(builder.get());
      }
//      //同步
//      if (builder.get().length()>0) {
//         FtpSyncUtil.slqSync(builder.get());
//      }
      //如果存在年龄不符的,则抛出异常
      if (count.get()>0){
         String errorAccount = StringUtils.join(errorList, "\\\n");