| | |
| | | import org.springblade.modules.apply.vo.ApplyVO; |
| | | import org.springblade.modules.exam.entity.ExamPaper; |
| | | import org.springblade.modules.exam.entity.ExamScore; |
| | | import org.springblade.modules.exam.excel.ExamScoreExcel; |
| | | import org.springblade.modules.exam.service.ExamPaperService; |
| | | import org.springblade.modules.system.entity.User; |
| | | import org.springblade.modules.system.service.IUserService; |
| | | import org.springblade.modules.training.entity.TrainExam; |
| | | import org.springblade.modules.training.entity.TrainingRegistration; |
| | | import org.springblade.modules.training.excel.TrainingRegistrationExcel; |
| | | import org.springblade.modules.training.excel.TrainingRegistrationImporter; |
| | | import org.springblade.modules.training.service.TrainExamService; |
| | | import org.springblade.modules.training.service.TrainingRegistrationService; |
| | |
| | | import javax.servlet.http.HttpServletResponse; |
| | | import java.text.DecimalFormat; |
| | | import java.text.SimpleDateFormat; |
| | | import java.util.Arrays; |
| | | import java.util.Date; |
| | | import java.util.List; |
| | | import java.util.UUID; |
| | | import java.util.*; |
| | | |
| | | /** |
| | | * @author zhongrj |
| | |
| | | return R.data(detail); |
| | | } |
| | | |
| | | /** |
| | | * 导出报名数数据 |
| | | * @param response |
| | | * @param trainingRegistration 培训报名对象 |
| | | */ |
| | | @GetMapping("export-apply") |
| | | @ApiOperation(value = "导出报名清册") |
| | | public void exportApply(HttpServletResponse response,TrainingRegistrationVo trainingRegistration) { |
| | | List<ApplyInfoExcel> list = trainingRegistrationService.getTrainingRegistrationExcelList(trainingRegistration); |
| | | ExcelUtil.export(response, "考试报名清册数据"+ DateUtil.time(), "考试报名清册数据表", list, ApplyInfoExcel.class); |
| | | } |
| | | // /** |
| | | // * 导出报名数数据 |
| | | // * @param response |
| | | // * @param trainingRegistration 培训报名对象 |
| | | // */ |
| | | // @GetMapping("export-apply") |
| | | // @ApiOperation(value = "导出报名清册") |
| | | // public void exportApply(HttpServletResponse response,TrainingRegistrationVo trainingRegistration) { |
| | | // List<TrainingRegistrationExcel> list = trainingRegistrationService.getTrainingRegistrationExcelList(trainingRegistration); |
| | | // ExcelUtil.export(response, "培训报名清册数据"+ DateUtil.time(), "培训报名清册数据表", list, TrainingRegistrationExcel.class); |
| | | // } |
| | | |
| | | |
| | | |
| | | /** |
| | | * 导入报名考试数据 |
| | | */ |
| | | @PostMapping("import-trainingRegistration") |
| | | @ApiOperation(value = "导入报名考试数据", notes = "传入excel") |
| | | @ApiOperation(value = "导入培训报名数据", notes = "传入excel") |
| | | public R importUser(MultipartFile file, Integer isCovered) { |
| | | TrainingRegistrationImporter trainingRegistrationImporter = new TrainingRegistrationImporter(trainingRegistrationService, false); |
| | | ExcelUtil.save(file, trainingRegistrationImporter, ApplyInfoExcel.class); |
| | | ExcelUtil.save(file, trainingRegistrationImporter, TrainingRegistrationExcel.class); |
| | | return R.success("操作成功"); |
| | | } |
| | | |
| | | /** |
| | | * 导出模板 |
| | | */ |
| | | @GetMapping("export-template") |
| | | @ApiOperation(value = "导出模板") |
| | | public void exportUser(HttpServletResponse response) { |
| | | List<TrainingRegistrationExcel> list = new ArrayList<>(); |
| | | ExcelUtil.export(response, "培训报名数据模板", "培训报名数据表", list, TrainingRegistrationExcel.class); |
| | | } |
| | | |
| | | |
| | |
| | | } |
| | | return pinyinStr; |
| | | } |
| | | |
| | | |
| | | /** |
| | | * 生成试卷,报名 |
| | | * @param ids 报名ids |
| | | */ |
| | | @PostMapping("/batchExam") |
| | | public R batchExam(@RequestParam String ids, |
| | | @RequestParam String examTime, |
| | | @RequestParam Date startTime, |
| | | @RequestParam Date endTime){ |
| | | if (!ids.equals("")){ |
| | | List<String> list = Arrays.asList(ids.split(",")); |
| | | if (list.size()>0){ |
| | | ExamPaper examPaper = new ExamPaper(); |
| | | examPaper.setExamTime(examTime); |
| | | 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); |
| | | //修改报名信息 |
| | | list.forEach(id ->{ |
| | | TrainingRegistration trainingRegistration = new TrainingRegistration(); |
| | | trainingRegistration.setId(Long.parseLong(id)); |
| | | trainingRegistration.setTrainExamId(examPaper.getId().toString()); |
| | | trainingRegistrationService.updateById(trainingRegistration); |
| | | }); |
| | | } |
| | | |
| | | }else { |
| | | //查询已报名未关联试卷的人员 |
| | | List<Long> applyIds = trainingRegistrationService.getTrainIds(); |
| | | if (applyIds.size()>0){ |
| | | //生成考试 |
| | | ExamPaper examPaper = new ExamPaper(); |
| | | examPaper.setExamTime(examTime); |
| | | 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); |
| | | //修改报名信息 |
| | | applyIds.forEach(id ->{ |
| | | TrainingRegistration trainingRegistration = new TrainingRegistration(); |
| | | trainingRegistration.setId(id); |
| | | trainingRegistration.setTrainExamId(examPaper.getId().toString()); |
| | | trainingRegistrationService.updateById(trainingRegistration); |
| | | }); |
| | | } |
| | | } |
| | | return null; |
| | | } |
| | | } |