| | |
| | | @PostMapping("/submit") |
| | | public R submit(@RequestBody Apply apply) { |
| | | if (null==apply.getId()){ |
| | | //去生成准考证 |
| | | //去生成准考证号码 |
| | | apply.setCandidateNo(getCandidateNo(apply)); |
| | | //默认通过 |
| | | apply.setApplyStatus(2); |
| | |
| | | } |
| | | |
| | | /** |
| | | * 生成准考证 |
| | | * 生成准考证号码 |
| | | * @param apply 考试报名信息对象 |
| | | */ |
| | | private String getCandidateNo(Apply apply) { |
| | |
| | | SELECT |
| | | sa.id,sa.user_id userId,sa.candidate_no candidateNo,apply_time,exam_id examId, |
| | | ke.total_score paperScore,ke.exam_type examType,ke.start_time examTime,ke.exam_name examName, |
| | | bu.real_name name |
| | | bu.real_name name, |
| | | bd.dept_name deptName |
| | | FROM |
| | | sys_apply sa |
| | | left join |
| | |
| | | blade_user bu |
| | | on |
| | | sa.user_id = bu.id |
| | | left join |
| | | blade_dept bd |
| | | on |
| | | bd.id = bu.dept_id |
| | | WHERE |
| | | 1=1 |
| | | <if test="apply.name!=null and apply.name!=''"> |
| | |
| | | */ |
| | | private String examName; |
| | | |
| | | |
| | | /** |
| | | * 保安单位名称 |
| | | */ |
| | | private String deptName; |
| | | |
| | | } |