智慧保安后台管理-外网
Administrator
2022-03-01 7c2c09439da3dccf1e032e89e1cb950b8fa1cc26
src/main/java/org/springblade/modules/exam/service/impl/ScoreAuditRecordsServiceImpl.java
@@ -18,6 +18,7 @@
import org.springblade.modules.securitypaper.service.SecurityPaperService;
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.system.vo.UserVO;
import org.springblade.modules.training.entity.TrainingRegistration;
import org.springblade.modules.training.service.TrainingRegistrationService;
@@ -53,6 +54,8 @@
   @Autowired
   private SecurityPaperService securityPaperService;
   @Autowired
   private  MyAsyncService myAsyncService;
   /**
    * 自定义分页
@@ -92,8 +95,15 @@
         ExamScore examScore = examScoreService.getById(auditRecords.getExamScoreId());
         //1.修改培训报名考试状态
         TrainingRegistration trainingRegistration = trainingRegistrationService.getById(examScore.getApplyId());
         //已考试
         trainingRegistration.setIsExam(2);
         //考试状态修改
         if(trainingRegistration.getIsExam()==4) {
            //考试状态修改为纸质考试
            trainingRegistration.setIsExam(5);
            trainingRegistration.setCancel(1);
         }else {
            //考试结束
            trainingRegistration.setIsExam(2);
         }
         //修改
         trainingRegistrationService.updateById(trainingRegistration);
@@ -135,10 +145,12 @@
                  ",qualified = " + "'" + examScore.getQualified() + "'" +
                  " " + "where id = " + "'" + examScore.getId() + "';"+
               "update sys_training_registration set is_exam = " + "'" + trainingRegistration.getIsExam() + "'" +
                  ",cancel = " + "'" + trainingRegistration.getCancel() + "'" +
                  " " + "where id = " + "'" + trainingRegistration.getId() + "';"+
               "update blade_user set is_train = " + "'" +  user.getIsTrain() + "'" +
                  " " + "where id = " + "'" + user.getId() + "'";
            FtpUtil.sqlFileUpload(s1);
            //FtpUtil.sqlFileUpload(s1);
            myAsyncService.FTP(s1);
         } else {
            //实操成绩不为空
            if (examScore.getTheoryGrade() >= 60 && examScore.getLearnGrade() >= 60) {
@@ -190,7 +202,8 @@
                        + "," + "'" + securityPaper.getUserId() + "'"
                        + "," + "'" + securityPaper.getApplyId() + "'"
                        + "," +"'" + securityPaper.getExamId() + "'" + ")";
                  FtpUtil.sqlFileUpload(s1);
                  //FtpUtil.sqlFileUpload(s1);
                  myAsyncService.FTP(s1);
               }
            } else {
               //不合格
@@ -223,13 +236,15 @@
                  ",qualified = " + "'" + examScore.getQualified() + "'" +
                  " " + "where id = " + "'" + examScore.getId() + "';"+
               "update sys_training_registration set is_exam = " + "'" + trainingRegistration.getIsExam() + "'" +
                  ",cancel = " + "'" + trainingRegistration.getCancel() + "'" +
                  " " + "where id = " + "'" + trainingRegistration.getId() + "';"+
               "update blade_user set hold = " + "'" + user.getHold() + "'" +
                  ",securitynumber = " + "'" + user.getSecuritynumber() + "'" +
                  ",user_type = " + "'" + user.getUserType() + "'" +
                  ",is_train = " + "'" + user.getIsTrain() + "'" +
                  " " + "where id = " + "'" + user.getId() + "'";
            FtpUtil.sqlFileUpload(s1);
            //FtpUtil.sqlFileUpload(s1);
            myAsyncService.FTP(s1);
         }
      }
      //审核时间
@@ -303,7 +318,8 @@
                     " " + "where id = " + "'" + trainingRegistration.getId() + "';"+
                  "update blade_user set is_train = " + "'" +  user.getIsTrain() + "'" +
                     " " + "where id = " + "'" + user.getId() + "'";
               FtpUtil.sqlFileUpload(s1);
               //FtpUtil.sqlFileUpload(s1);
               myAsyncService.FTP(s1);
            } else {
               //实操成绩不为空
               if (examScore.getTheoryGrade() >= 60 && examScore.getLearnGrade() >= 60) {
@@ -378,7 +394,8 @@
                     ",user_type = " + "'" + user.getUserType() + "'" +
                     ",is_train = " + "'" + user.getIsTrain() + "'" +
                     " " + "where id = " + "'" + user.getId() + "'";
               FtpUtil.sqlFileUpload(s1);
               //FtpUtil.sqlFileUpload(s1);
               myAsyncService.FTP(s1);
            }
         }
         //审核时间