1.正式考试，模拟考试考试申请接口修改 2.用户头像批量上传（压缩zip 包上传） 3.通知公告接口修改

Administrator

2021-09-02 2b5ca6cea92ff6a67582c3331a0704480e63b9b4

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

@@ -457,11 +457,14 @@
   /**
    * 生成试卷,报名
    * @param ids 报名ids
    * @param startTime 考试开始时间
    * @param number 报名人数
    */
   @PostMapping("/batchExam")
   public R batchExam(@RequestParam String ids,
                  String examTime,
                  @RequestParam Date startTime,
                  @RequestParam Integer number,
                  Date endTime){
      if (!ids.equals("")){
         List<String> list = Arrays.asList(ids.split(","));
@@ -506,52 +509,56 @@
               FtpUtil.sqlFileUpload(s1);
            });
         }

      }else {
         //查询已报名未关联试卷的人员
         List<Long> applyIds = trainingRegistrationService.getTrainIds();
         if (applyIds.size()>0){
            //生成考试
            ExamPaper examPaper = new ExamPaper();
         if (number==0){
            return R.data("报名人数不能小于1人");
         }else {
            //查询已报名的人员前 number 个
            //查询已报名未关联试卷的人员
            List<Long> applyIds = trainingRegistrationService.getTrainIds(number);
            if (applyIds.size()>0){
               //生成考试
               ExamPaper examPaper = new ExamPaper();
//            examPaper.setExamTime(examTime);
            examPaper.setExamType(2);
            examPaper.setStartTime(startTime);
               examPaper.setExamType(2);
               examPaper.setStartTime(startTime);
//            examPaper.setEndTime(endTime);
            Calendar instance = Calendar.getInstance();
            instance.setTime(startTime);
            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.setAuditStatus(3);
            //生成考试
            examPaperService.save(examPaper);
               Calendar instance = Calendar.getInstance();
               instance.setTime(startTime);
               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.setAuditStatus(3);
               //生成考试
               examPaperService.save(examPaper);

            Long sid = examPaper.getId();
            String format = new SimpleDateFormat("yyyy-MM-dd HH:mm:ss").format(examPaper.getStartTime());
            String s = "insert into ksxt_exam(id,exam_name,exam_type,start_time,audit_status) " +
               "values(" + "'" + sid + "'" +
               "," + "'" + examPaper.getExamName() + "'" +
               "," + "'" + examPaper.getExamType() +"'" +
               "," + "'" + format +"'" +
               ","  +"'" + examPaper.getAuditStatus() + "'" + ")";
            FtpUtil.sqlFileUpload(s);
               Long sid = examPaper.getId();
               String format = new SimpleDateFormat("yyyy-MM-dd HH:mm:ss").format(examPaper.getStartTime());
               String s = "insert into ksxt_exam(id,exam_name,exam_type,start_time,audit_status) " +
                  "values(" + "'" + sid + "'" +
                  "," + "'" + examPaper.getExamName() + "'" +
                  "," + "'" + examPaper.getExamType() +"'" +
                  "," + "'" + format +"'" +
                  ","  +"'" + examPaper.getAuditStatus() + "'" + ")";
               FtpUtil.sqlFileUpload(s);


            //修改报名信息
            applyIds.forEach(id ->{
               TrainingRegistration trainingRegistration = new TrainingRegistration();
               trainingRegistration.setId(id);
               trainingRegistration.setTrainExamId(examPaper.getId().toString());
               trainingRegistrationService.updateById(trainingRegistration);
               //修改报名信息
               applyIds.forEach(id ->{
                  TrainingRegistration trainingRegistration = new TrainingRegistration();
                  trainingRegistration.setId(id);
                  trainingRegistration.setTrainExamId(examPaper.getId().toString());
                  trainingRegistrationService.updateById(trainingRegistration);

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