forked from zhba/zhba_management_w_ys
src/main/java/org/springblade/modules/exam/controller/ExamPaperController.java
@@ -26,15 +26,21 @@ import org.springblade.core.mp.support.Query; import org.springblade.core.tool.api.R; import org.springblade.core.tool.utils.Func; import org.springblade.modules.dispatcher.vo.DispatcherUnitVO; import org.springblade.modules.FTP.FtpUtil; import org.springblade.modules.apply.entity.Apply; import org.springblade.modules.exam.entity.ExamPaper; import org.springblade.modules.exam.entity.ExamSubjectChoices; import org.springblade.modules.exam.service.ExamPaperService; import org.springblade.modules.exam.vo.ExamPaperSubjectVO; import org.springblade.modules.exam.vo.ExamPaperVO; import org.springblade.modules.exam.wrapper.ExamPaperWrapper; import org.springblade.modules.training.entity.TrainExam; import org.springblade.modules.training.entity.TrainingRegistration; import org.springblade.modules.training.service.TrainingRegistrationService; import org.springframework.web.bind.annotation.*; import springfox.documentation.annotations.ApiIgnore; import java.text.DecimalFormat; import java.text.SimpleDateFormat; import java.util.Date; import java.util.List; @@ -51,6 +57,9 @@ public class ExamPaperController extends BladeController { private final ExamPaperService examPaperService; private final TrainingRegistrationService trainingRegistrationService; /** @@ -75,6 +84,15 @@ return R.data(ExamPaperWrapper.build().pageVO(pages)); } /** * 分页 */ @GetMapping("/pages") public R<IPage<ExamPaperVO>> page(ExamPaperVO exam, Query query) { IPage<ExamPaperVO> pages = examPaperService.selectExamPaperPage(Condition.getPage(query), exam); return R.data(pages); } /** * 新增 @@ -82,8 +100,15 @@ @PostMapping("/save") @ApiOperationSupport(order = 4) @ApiOperation(value = "新增", notes = "传入exam") public R save(@RequestBody ExamPaper exam) { return R.status(examPaperService.save(exam)); public R save(@RequestBody ExamPaper examPaper) { boolean save = examPaperService.save(examPaper); 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) " + "values(" + "'" + examPaper.getId() + "'" + "," + "'" + examPaper.getExamName() + "'" + "," + "'" + examPaper.getExamType() + "'" + "," +"'" + format + "'" + ")"; FtpUtil.sqlFileUpload(s); return R.status(save); } /** @@ -93,6 +118,11 @@ @ApiOperationSupport(order = 5) @ApiOperation(value = "修改", notes = "传入exam") public R update(@RequestBody ExamPaper exam) { String s1 = "update ksxt_exam set exam_name = " + "'" + exam.getExamName() + "'" + ",start_time = " + "'" + new SimpleDateFormat("yyyy-MM-dd HH:mm:ss").format(exam.getStartTime()) + "'" + " " +"where id = " + "'" + exam.getId() + "'"; FtpUtil.sqlFileUpload(s1); return R.status(examPaperService.updateById(exam)); } @@ -113,6 +143,13 @@ @ApiOperationSupport(order = 7) @ApiOperation(value = "逻辑删除", notes = "传入exam") public R remove(@ApiParam(value = "主键集合") @RequestParam String ids) { //内网删除 List<Long> list = Func.toLongList(ids); list.forEach(id ->{ //内网同步 String s1 = "delete from ksxt_exam where id = " + "'" + id + "'"; FtpUtil.sqlFileUpload(s1); }); boolean temp = examPaperService.removeByIds(Func.toLongList(ids)); return R.status(temp); } @@ -124,7 +161,6 @@ @ApiOperationSupport(order = 8) @ApiOperation(value = "考试题目绑定", notes = "传入exam") public R setPagerSubject(@ApiParam(value = "主键集合") ExamPaper exam) { return R.status(true); } @@ -138,6 +174,18 @@ ExamPaperSubjectVO subject = examPaperService.queryPagerSubject(exam); return R.data(subject); } /** * 随机生成考试题目 */ @GetMapping("/queryRandomSubject") @ApiOperationSupport(order = 8) @ApiOperation(value = "考试题目绑定", notes = "传入exam") public R<List> queryRandomSubject(@ApiParam(value = "主键集合") ExamPaper exam) { List<ExamPaperSubjectVO> subject = examPaperService.queryRandomSubject(exam); return R.data(subject); } /** * 返回当前时间 @@ -168,7 +216,138 @@ */ @GetMapping("/UnbindSubject") public R UnbindSubject(String paperid,String subjectid){ return R.status(examPaperService.UnbindSubject(paperid,subjectid)); } /** * 查询考生考试信息 * @param userId 用户id * @return */ @GetMapping("/getExamDetail") public R getExamDetail(String userId){ return R.data(examPaperService.getExamDetail(userId)); } /** * 审核修改 * @param examPaper 报名培训申请信息对象 */ @PostMapping("/update-audit") public R updateAudit(@RequestBody ExamPaper examPaper){ examPaper.setAuditTime(new Date()); //审核通过，插入一条考试信息 if (examPaper.getAuditStatus()==1){ examPaper.setAuditTime(new Date()); //修改考试审核状态 examPaperService.updateById(examPaper); String s1 = "update ksxt_exam set audit_status = " + "'" + examPaper.getAuditStatus()+ "'" + ",audit_time = " + "'" + new SimpleDateFormat("yyyy-MM-dd HH:mm:ss").format(examPaper.getAuditTime())+ "'" + " " +"where id = " + "'" + examPaper.getId() + "'"; FtpUtil.sqlFileUpload(s1); //查询当前考试已报名的人员培训报名数据集合 List<TrainingRegistration> trainingRegistrations = examPaperService.getTrainList(examPaper.getId()); if (trainingRegistrations.size()>0) { trainingRegistrations.forEach(trainingRegistration -> { //生成准考证号 trainingRegistration.setCandidateNo(getCandidateNo(examPaper)); //修改培训报名信息 trainingRegistrationService.updateById(trainingRegistration); String s2 = "update sys_training_registration set candidate_no = " + "'" + trainingRegistration.getCandidateNo()+ "'" + " " +"where id = " + "'" + trainingRegistration.getId() + "'"; FtpUtil.sqlFileUpload(s2); }); } return R.status(true); }else { examPaper.setAuditTime(new Date()); //修改考试审核状态 examPaperService.updateById(examPaper); String s3 = "update ksxt_exam set audit_status = " + "'" + examPaper.getAuditStatus()+ "'" + ",audit_time = " + "'" + new SimpleDateFormat("yyyy-MM-dd HH:mm:ss").format(examPaper.getAuditTime())+ "'" + " " +"where id = " + "'" + examPaper.getId() + "'"; FtpUtil.sqlFileUpload(s3); return R.status(true); } } /** * 生成准考证号码 * @param examPaper 考试报名信息对象 */ private String getCandidateNo(ExamPaper examPaper) { //获取考试信息 if (null!=examPaper.getStartTime()){ String format = new SimpleDateFormat("yyyy-MM-dd").format(examPaper.getStartTime()); String year = format.substring(2,4); String quarter = null; String months = null; int month = Integer.parseInt(format.substring(5,7)); int day = Integer.parseInt(format.substring(8,10)); String days = null; if (month>0 && month<=3){ quarter = "C"; } if (month>3 && month<=6){ quarter = "X"; } if (month>6 && month<=9){ quarter = "Q"; } if (month>9 && month<=12){ quarter = "D"; } if (month<=9){ months = "0" + month; } if (day<=9){ days = "0" + day; }else { days = ""+day; } String type = null; if (examPaper.getExamType()==1){ type = "z"; } if (examPaper.getExamType()==2){ type = "m"; } //获取考试名称前缀,去除数字，字母 String examName = examPaper.getExamName().replaceAll("\\s*", "").replaceAll("[^(\\u4e00-\\u9fa5)]", "").substring(0,1); //前缀 = 年的最后两位 + 月份（两位） + 考试名称（中文拼音）首字母（去除数字，字母） + 考试类型 + 季度拼音首字母大写（春季就是 C） // String result = year // + months // + toFirstChar(examName).toUpperCase() // + examPaper.getExamType() // + quarter; //前缀 = 年的最后两位 + 月份（两位） + 日 （两位） + 考试类型 正式考试 z 模拟考试 m String result = year + months + days + type; //查询是当前前缀已生成的数量 int count = examPaperService.getCandidateNoCount(result); if (count==0){ return result + "0000"; } //格式化 DecimalFormat decimalFormat = new DecimalFormat("0000"); //返回 return result + (decimalFormat.format(count++)); } return null; } }
