| | |
| | | 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; |
| | |
| | | |
| | | @Autowired |
| | | private SecurityPaperService securityPaperService; |
| | | @Autowired |
| | | private MyAsyncService myAsyncService; |
| | | |
| | | /** |
| | | * 自定义分页 |
| | |
| | | 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); |
| | | |
| | |
| | | ",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) { |
| | |
| | | + "," + "'" + securityPaper.getUserId() + "'" |
| | | + "," + "'" + securityPaper.getApplyId() + "'" |
| | | + "," +"'" + securityPaper.getExamId() + "'" + ")"; |
| | | FtpUtil.sqlFileUpload(s1); |
| | | //FtpUtil.sqlFileUpload(s1); |
| | | myAsyncService.FTP(s1); |
| | | } |
| | | } else { |
| | | //不合格 |
| | |
| | | ",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); |
| | | } |
| | | } |
| | | //审核时间 |
| | |
| | | " " + "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) { |
| | |
| | | ",user_type = " + "'" + user.getUserType() + "'" + |
| | | ",is_train = " + "'" + user.getIsTrain() + "'" + |
| | | " " + "where id = " + "'" + user.getId() + "'"; |
| | | FtpUtil.sqlFileUpload(s1); |
| | | //FtpUtil.sqlFileUpload(s1); |
| | | myAsyncService.FTP(s1); |
| | | } |
| | | } |
| | | //审核时间 |