培训考试生成修改，考试开始修改

Administrator

2021-09-23 d5c6460d5d63c430153202653fb90bf904d1b816

培训考试生成修改，考试开始修改

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

@@ -698,13 +698,13 @@
        //内网同步
        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,exam_time,user_id,exam_id,apply_id) " +
            "values(" + "'" + sid + "'" + "," + "'" +
            format + "'" + "," + "'" +
            examScore.getUserId() +"'" + ","  +"'" +
            examScore.getExamId() +"'" + ","  +"'" +
            examScore.getApplyId() + "'" + ")";
        FtpUtil.sqlFileUpload(s);
        return examScore;
    }


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

@@ -468,9 +468,9 @@
            apply1.setIsExam(3);
            baseMapper.updateById(apply1);

//            String s1 =
//                "update sys_apply set is_exam = " + apply1.getIsExam() + " " +"where id = " + "'" + apply1.getId() + "'";
//            FtpUtil.sqlFileUpload(s1);
            String s1 =
                "update sys_apply set is_exam = " + apply1.getIsExam() + " " +"where id = " + "'" + apply1.getId() + "'";
            FtpUtil.sqlFileUpload(s1);
        }
        //模拟考
        if (apply.getExamType()==2){
@@ -480,9 +480,9 @@
            trainingRegistration.setIsExam(3);
            trainingRegistrationService.updateById(trainingRegistration);

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


 src/main/java/org/springblade/modules/training/controller/TrainingRegistrationController.java

@@ -582,7 +582,7 @@

                //修改报名信息
                applyIds.forEach(trainingRegistration ->{
                    if(null==trainingRegistration.getTrainExamId() && trainingRegistration.getTrainExamId()=="") {
                    if(null==trainingRegistration.getTrainExamId() || trainingRegistration.getTrainExamId()=="") {
                        trainingRegistration.setTrainExamId(examPaper.getId().toString());
                        //提交考试审核
                        trainingRegistration.setAuditStatus(3);