| | |
|---|
| | | package org.springblade.modules.exam.controller; |
|---|
| | | |
|---|
| | | import com.alibaba.excel.EasyExcel; |
|---|
| | | import com.alibaba.fastjson.JSON; |
|---|
| | | 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 org.apache.commons.codec.Charsets; |
|---|
| | | import org.springblade.common.excel.RowWriteHandler; |
|---|
| | | import org.springblade.common.utils.arg; |
|---|
| | | import org.springblade.core.excel.util.ExcelUtil; |
|---|
| | | import org.springblade.core.mp.support.Condition; |
|---|
| | |
|---|
| | | import org.springframework.web.multipart.MultipartFile; |
|---|
| | | |
|---|
| | | import javax.servlet.http.HttpServletResponse; |
|---|
| | | import java.io.IOException; |
|---|
| | | import java.net.URLEncoder; |
|---|
| | | import java.sql.Array; |
|---|
| | | import java.text.DecimalFormat; |
|---|
| | | import java.text.SimpleDateFormat; |
|---|
| | |
|---|
| | | examScore.setQualified(0); |
|---|
| | | //正式考试通过生成保安证编号 |
|---|
| | | ExamPaper paper = examPaperService.getById(examScore.getExamId()); |
|---|
| | | if (paper.getExamType() == 1) { |
|---|
| | | // if (paper.getExamType() == 1) { |
|---|
| | | //去生成保安证编号 |
|---|
| | | String pre = SecurityPaperUtil.getSecurityPaper(); |
|---|
| | | //查询当前年份已有的保安证编号 |
|---|
| | |
|---|
| | | ",paper_time = " + "'" + new SimpleDateFormat("yyyy-MM-dd").format(user.getPaperTime()) + "'" + |
|---|
| | | " " + "where id = " + "'" + user.getId() + "'"; |
|---|
| | | FtpUtil.sqlFileUpload(s1); |
|---|
| | | } |
|---|
| | | // } |
|---|
| | | } else { |
|---|
| | | //不合格 |
|---|
| | | examScore.setQualified(1); |
|---|
| | |
|---|
| | | */ |
|---|
| | | @GetMapping("export-template") |
|---|
| | | @ApiOperation(value = "导出模板") |
|---|
| | | public void exportUser(HttpServletResponse response) { |
|---|
| | | public void exportExamScore(HttpServletResponse response)throws IOException { |
|---|
| | | List<ExamScoreExcel> list = new ArrayList<>(); |
|---|
| | | ExcelUtil.export(response, "实操成绩数据模板", "实操成绩数据表", list, ExamScoreExcel.class); |
|---|
| | | ExamScoreExcel examScoreExcel = new ExamScoreExcel(); |
|---|
| | | examScoreExcel.setExamName("2021年10月**日保安员证培训考试"); |
|---|
| | | examScoreExcel.setName("张三"); |
|---|
| | | examScoreExcel.setIdCardNo("360XXX19XXXXXX****"); |
|---|
| | | examScoreExcel.setCandidateNo("2110**m0001"); |
|---|
| | | examScoreExcel.setLearnGrade(80); |
|---|
| | | list.add(examScoreExcel); |
|---|
| | | |
|---|
| | | ExamScoreExcel examScoreExcel1 = new ExamScoreExcel(); |
|---|
| | | examScoreExcel1.setExamName("2021年10月**日保安员证培训考试"); |
|---|
| | | examScoreExcel1.setName("李四"); |
|---|
| | | examScoreExcel1.setIdCardNo("360XXX19XXXXXX****"); |
|---|
| | | examScoreExcel1.setCandidateNo("2110**m0002"); |
|---|
| | | examScoreExcel1.setLearnGrade(88); |
|---|
| | | list.add(examScoreExcel1); |
|---|
| | | // ExcelUtil.export(response, "实操成绩数据模板", "实操成绩数据表", list, ExamScoreExcel.class); |
|---|
| | | String fileName = null; |
|---|
| | | try { |
|---|
| | | response.setContentType("application/vnd.ms-excel"); |
|---|
| | | response.setCharacterEncoding(org.apache.commons.codec.Charsets.UTF_8.name()); |
|---|
| | | fileName = URLEncoder.encode("实操成绩数据模板", Charsets.UTF_8.name()); |
|---|
| | | response.setHeader("Content-disposition", "attachment;filename=" + fileName + ".xlsx"); |
|---|
| | | //修改单元格格式为文本格式 |
|---|
| | | EasyExcel.write(response.getOutputStream(), ExamScoreExcel.class).sheet("实操成绩数据表").registerWriteHandler(new RowWriteHandler()).doWrite(list); |
|---|
| | | } catch (Throwable var6) { |
|---|
| | | throw var6; |
|---|
| | | } |
|---|
| | | } |
|---|
| | | |
|---|
| | | /** |
|---|
| | |
|---|
| | | @ApiOperationSupport(order = 14) |
|---|
| | | @ApiOperation(value = "导出成绩") |
|---|
| | | public void exportExamScore(HttpServletResponse response,ExamScoreVO examScoreVO) { |
|---|
| | | System.out.println("examScoreVO = " + examScoreVO); |
|---|
| | | //按条件查询成绩数据 |
|---|
| | | List<ExportExamScoreExcel> examScoreExcels = examScoreService.exportExamScoreList(examScoreVO); |
|---|
| | | //导出成绩集合数据 |
|---|
