| | |
| | | package org.springblade.modules.apply.controller; |
| | | |
| | | import com.baomidou.mybatisplus.core.metadata.IPage; |
| | | import com.github.xiaoymin.knife4j.annotations.ApiOperationSupport; |
| | | import io.swagger.annotations.ApiOperation; |
| | | import io.swagger.annotations.ApiParam; |
| | | import lombok.AllArgsConstructor; |
| | |
| | | import net.sourceforge.pinyin4j.format.HanyuPinyinOutputFormat; |
| | | import net.sourceforge.pinyin4j.format.HanyuPinyinToneType; |
| | | import net.sourceforge.pinyin4j.format.exception.BadHanyuPinyinOutputFormatCombination; |
| | | import org.springblade.core.excel.util.ExcelUtil; |
| | | import org.springblade.core.mp.support.Condition; |
| | | 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.apply.entity.Apply; |
| | | import org.springblade.modules.apply.excel.ApplyExcel; |
| | | import org.springblade.modules.apply.excel.ApplyImporter; |
| | | import org.springblade.modules.apply.service.ApplyService; |
| | | import org.springblade.modules.apply.vo.ApplyVO; |
| | | import org.springblade.modules.exam.entity.ExamPaper; |
| | | import org.springblade.modules.exam.service.ExamPaperService; |
| | | import org.springblade.modules.system.excel.UserExcel; |
| | | import org.springblade.modules.system.excel.UserImporter; |
| | | import org.springframework.web.bind.annotation.*; |
| | | import org.springframework.web.multipart.MultipartFile; |
| | | |
| | | import javax.servlet.http.HttpServletResponse; |
| | | import java.text.DecimalFormat; |
| | | import java.text.SimpleDateFormat; |
| | | import java.util.ArrayList; |
| | | import java.util.Date; |
| | | import java.util.List; |
| | | import java.util.UUID; |
| | | |
| | | /** |
| | | * @author zhongrj |
| | |
| | | private final ApplyService applyService; |
| | | |
| | | private final ExamPaperService examPaperService; |
| | | |
| | | /** |
| | | * 自定义分页,资格审查 |
| | | * @param query page,size |
| | | * @param apply 考试报名信息对象 |
| | | */ |
| | | @GetMapping("/page-investigate") |
| | | public R<IPage<ApplyVO>> pageInvestigate(ApplyVO apply, Query query) { |
| | | IPage<ApplyVO> pages = applyService.selectApplyPage(Condition.getPage(query), apply); |
| | | return R.data(pages); |
| | | } |
| | | |
| | | |
| | | /** |
| | | * 自定义分页 |
| | |
| | | if (null==apply.getId()){ |
| | | //去生成准考证号码 |
| | | apply.setCandidateNo(getCandidateNo(apply)); |
| | | //去生成考试编号 |
| | | apply.setApplyCode(getApplyCode(apply)); |
| | | //默认通过 |
| | | apply.setApplyStatus(2); |
| | | //默认为未考试状态 |
| | | apply.setIsExam(1); |
| | | apply.setApplyTime(new Date()); |
| | | } |
| | | return R.status(applyService.saveOrUpdate(apply)); |
| | | } |
| | | |
| | | |
| | | /** |
| | | * 导入报名考试数据 |
| | | */ |
| | | @PostMapping("import-apply") |
| | | @ApiOperation(value = "导入报名考试数据", notes = "传入excel") |
| | | public R importUser(MultipartFile file, Integer isCovered) { |
| | | ApplyImporter applyImporter = new ApplyImporter(applyService, isCovered == 1); |
| | | ExcelUtil.save(file, applyImporter, ApplyExcel.class); |
| | | return R.success("操作成功"); |
| | | } |
| | | |
| | | /** |
| | | * 导出模板 |
| | | */ |
| | | @GetMapping("export-template") |
| | | @ApiOperation(value = "导出模板") |
| | | public void exportUser(HttpServletResponse response) { |
| | | List<ApplyExcel> list = new ArrayList<>(); |
| | | ExcelUtil.export(response, "考试报名数据模板", "考试报名数据表", list, ApplyExcel.class); |
| | | } |
| | | |
| | | /** |
| | |
| | | return null; |
| | | } |
| | | |
| | | |
| | | /** |
| | | * 生成准考证号码 |
| | | * @param apply 考试报名信息对象 |
| | | */ |
| | | private String getApplyCode(Apply apply) { |
| | | //获取考试信息 |
| | | ExamPaper examPaper = examPaperService.getById(apply.getExamId()); |
| | | 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; |
| | | String days = null; |
| | | int month = Integer.parseInt(format.substring(5,7)); |
| | | int day = Integer.parseInt(format.substring(8,10)); |
| | | 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; |
| | | } |
| | | //获取考试名称前缀,去除数字,字母 |
| | | String examName |
| | | = examPaper.getExamName().replaceAll("\\s*", "").replaceAll("[^(\\u4e00-\\u9fa5)]", "").substring(0,1); |
| | | |
| | | //前缀 = 年的最后两位 + 月份(两位) + 考试名称(中文拼音)首字母(去除数字,字母) + 考试类型 + 季度拼音首字母大写(春季就是 C) |
| | | String result = year |
| | | + months |
| | | + toFirstChar(examName).toUpperCase() |
| | | + examPaper.getExamType() |
| | | + quarter; |
| | | //生成随机数 |
| | | UUID uuid = UUID.randomUUID(); |
| | | //返回 |
| | | return result + uuid.toString().replaceAll("\\-",""); |
| | | } |
| | | return null; |
| | | } |
| | | |
| | | /** |
| | | * 获取字符串拼音的第一个字母 |
| | | * @param chinese |