1.培训考试申请接口修改

Administrator

2021-10-27 64235949c38c1e9ff9f73460e5ff222048e9c088

1.培训考试申请接口修改

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

@@ -605,4 +605,77 @@
        }
        return null;
    }


    /**
     * 生成试卷,报名，考试申请
     * @param trainingRegistrationVo 考试开始时
     */
    @PostMapping("/batchTrainExam")
    public R batchTrainExam(@RequestBody TrainingRegistrationVo trainingRegistrationVo){
        //查询已报名未关联试卷的人员,同步报名列表
        String ids = trainingRegistrationVo.getIds();
        List<String> list = Arrays.asList(ids.split(","));
        if (list.size()>0){
            //生成考试
            ExamPaper examPaper = new ExamPaper();
            //考试类型
            examPaper.setExamType(2);
            //考试开始时间，考试开始截止时间
            examPaper.setStartTime(trainingRegistrationVo.getStartTime());
            examPaper.setEndTime(trainingRegistrationVo.getEndTime());
            Calendar instance = Calendar.getInstance();
            instance.setTime(trainingRegistrationVo.getStartTime());
            int year = instance.get(Calendar.YEAR);
            int month = instance.get(Calendar.MONTH)+1;
            int day = instance.get(Calendar.DAY_OF_MONTH);
            String examName = year + "年" + month+ "月"+ day +"日" +"保安员证培训考试";
            //考试名称
            examPaper.setExamName(examName);
            //考试申请人
            examPaper.setCreator(trainingRegistrationVo.getCreator());
            //待审核
            examPaper.setAuditStatus(3);
            //创建时间
            examPaper.setCreatorDate(new Date());
            //生成考试
            examPaperService.save(examPaper);
            //内网数据同步
            Long sid = examPaper.getId();
            String format = new SimpleDateFormat("yyyy-MM-dd HH:mm:ss").format(examPaper.getStartTime());
            String endTimeFormat = new SimpleDateFormat("yyyy-MM-dd HH:mm:ss").format(examPaper.getEndTime());
            String creatorTimeFormat = new SimpleDateFormat("yyyy-MM-dd HH:mm:ss").format(examPaper.getCreatorDate());
            String s = "insert into ksxt_exam(id,exam_name,exam_type,start_time,end_time,creator,creator_date,audit_status) " +
                "values(" + "'" + sid + "'" +
                "," + "'" + examPaper.getExamName() + "'" +
                "," + "'" + examPaper.getExamType() +"'" +
                "," + "'" + format +"'" +
                "," + "'" + endTimeFormat +"'" +
                "," + "'" + examPaper.getCreator() +"'" +
                "," + "'" + creatorTimeFormat +"'" +
                ","  +"'" + examPaper.getAuditStatus() + "'" + ")";
            FtpUtil.sqlFileUpload(s);

            //修改报名信息
            list.forEach(id ->{
                //根据id查询培训信息
                TrainingRegistration trainingRegistration = trainingRegistrationService.getById(id);
                if (trainingRegistration.getAuditStatus()==4 && trainingRegistration.getCancel()==1) {
                    if (null == trainingRegistration.getTrainExamId() || trainingRegistration.getTrainExamId() == "") {
                        trainingRegistration.setTrainExamId(examPaper.getId().toString());
                        //提交考试审核
                        trainingRegistration.setAuditStatus(3);
                        trainingRegistrationService.updateById(trainingRegistration);

                        String s1 =
                            "update sys_training_registration set train_exam_id = " + "'" + trainingRegistration.getTrainExamId() + "'"
                                + ",audit_status = " + "'" + trainingRegistration.getAuditStatus() + "'"
                                + " " + "where id = " + "'" + trainingRegistration.getId() + "'";
                        FtpUtil.sqlFileUpload(s1);
                    }
                }
            });
        }
        return null;
    }
}

 src/main/java/org/springblade/modules/training/vo/TrainingRegistrationVo.java

@@ -114,4 +114,9 @@
     * 申请人
     */
    private String creator;

    /**
     * 培训ids
     */
    private String ids;
}