src/main/java/org/springblade/modules/training/controller/TrainingRegistrationController.java
@@ -16,6 +16,7 @@ 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.DateUtil; import org.springblade.core.tool.utils.Func; import org.springblade.modules.FTP.FtpUtil; import org.springblade.modules.apply.entity.Apply; @@ -378,17 +379,16 @@ return R.data(detail); } // /** // * 导出报名数数据 // * @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); // } /** * 导出报名数数据 * @param response * @param trainingRegistration 培训报名对象 */ @GetMapping("export-apply-info") public void exportApplyInfo(HttpServletResponse response,TrainingRegistrationVo trainingRegistration) { List<TrainingRegistrationExcel> list = trainingRegistrationService.getTrainingRegistrationExcelList(trainingRegistration); ExcelUtil.export(response, "报名清册数据"+ DateUtil.time(), "报名清册数据表", list, TrainingRegistrationExcel.class); }
@@ -7,11 +7,12 @@ import lombok.Data; import java.io.Serializable; import java.util.Date; /** * TrainingRegistrationExcel * @author zhongrj * @since 2021-08-12 * @since 2021-12-09 */ @Data @ColumnWidth(25) @@ -20,15 +21,39 @@ public class TrainingRegistrationExcel implements Serializable { private static final long serialVersionUID = 1L; @ColumnWidth(15) @ExcelProperty("保安姓名") private String realName; @ColumnWidth(25) @ExcelProperty("培训机构名称") @ExcelProperty("考试名称") private String trainExamName; @ColumnWidth(25) @ExcelProperty("所属企业名称") private String deptName; @ColumnWidth(15) @ExcelProperty("姓名") private String realName; @ExcelProperty("准考证号") private String candidateNo; @ColumnWidth(20) @ExcelProperty("身份证号") private String idCardNo; @ColumnWidth(20) @ExcelProperty("报名时间") private Date trainingTime; @ColumnWidth(20) @ExcelProperty("考试时间") private Date trainExamTime; @ColumnWidth(15) @ExcelProperty("审核状态") private String auditStatus; @ColumnWidth(15) @ExcelProperty("考试状态") private String isExam; } src/main/java/org/springblade/modules/training/mapper/TrainingRegistrationMapper.java
@@ -6,6 +6,7 @@ import org.springblade.modules.absentrecords.entity.AbsentRecords; import org.springblade.modules.apply.excel.ApplyInfoExcel; import org.springblade.modules.training.entity.TrainingRegistration; import org.springblade.modules.training.excel.TrainingRegistrationExcel; import org.springblade.modules.training.vo.TrainingRegistrationVo; import java.util.List; @@ -38,7 +39,7 @@ * @param trainingRegistration 培训报名对象 * @return */ List<ApplyInfoExcel> getTrainingRegistrationExcelList(@Param("trainingRegistration")TrainingRegistrationVo trainingRegistration); List<TrainingRegistrationExcel> getTrainingRegistrationExcelList(@Param("trainingRegistration")TrainingRegistrationVo trainingRegistration); /** * 查询准考证前缀相同的数量 src/main/java/org/springblade/modules/training/mapper/TrainingRegistrationMapper.xml
@@ -67,7 +67,7 @@ <if test="trainingRegistration.isTrain!=null"> and bu.is_train = #{trainingRegistration.isTrain} </if> order by sr.id desc </select> <!--报名培训详情信息--> @@ -88,18 +88,30 @@ </select> <!--导出报名数数据--> <select id="getTrainingRegistrationExcelList" resultType="org.springblade.modules.apply.excel.ApplyInfoExcel"> select sr.training_time applyTime,sr.candidate_no candidateNo, bt.dept_name AS deptName,"保安证" applyCard, bu.real_name realName,bu.cardid idCardNo, ke.start_time examTime,ke.exam_name examName <select id="getTrainingRegistrationExcelList" resultType="org.springblade.modules.training.excel.TrainingRegistrationExcel"> SELECT sr.id, sr.candidate_no candidateNo, sr.training_time trainingTime, case when sr.is_exam = 1 then "未考试" when sr.is_exam = 2 then "考试结束" when sr.is_exam = 3 then "考试中" else "缺考" end as isExam, bt.dept_name AS deptName, bt0.dept_name AS trainUnitName, bu.real_name realName, bu.phone,bu.cardid idCardNo, ke.start_time trainExamTime, if(ke.audit_status=1,ke.exam_name,"") trainExamName, case when sr.audit_status = 1 then "审核通过" when sr.audit_status = 2 then "审核不通过" when sr.audit_status = 3 then "已提交审核" else "未提交审核" end as auditStatus, "保安证" applyCard FROM sys_training_registration sr LEFT JOIN blade_dept bt ON sr.dept_id = bt.id LEFT JOIN blade_dept bt0 ON @@ -108,13 +120,21 @@ blade_user bu on sr.user_id = bu.id LEFT JOIN blade_dept bt ON bu.dept_id = bt.id left join ksxt_exam ke on ke.id = sr.train_exam_id WHERE 1=1 and is_exam = 1 and bu.status = 1 and bu.is_deleted = 0 <if test="trainingRegistration.isExam!=null and trainingRegistration.isExam!=0"> and is_exam = #{trainingRegistration.isExam} </if> <if test="trainingRegistration.trainingUnitId!=null and trainingRegistration.trainingUnitId!=''"> and sr.training_unit_id = #{trainingRegistration.trainingUnitId} </if> @@ -123,6 +143,12 @@ </if> <if test="trainingRegistration.userId!=null and trainingRegistration.userId!=''"> and sr.user_id = #{trainingRegistration.userId} </if> <if test="trainingRegistration.deptId!=null and trainingRegistration.deptId!=''"> and bu.dept_id = #{trainingRegistration.deptId} </if> <if test="trainingRegistration.auditStatus!=null and trainingRegistration.auditStatus!=0"> and sr.audit_status = #{trainingRegistration.auditStatus} </if> <if test="trainingRegistration.deptName!=null and trainingRegistration.deptName!=''"> and bt.dept_name like concat('%', #{trainingRegistration.deptName},'%') @@ -133,9 +159,13 @@ <if test="trainingRegistration.idCardNo!=null and trainingRegistration.idCardNo!=''"> and bu.cardid like concat('%', #{trainingRegistration.idCardNo},'%') </if> <if test="trainingRegistration.cancel!=null"> <if test="trainingRegistration.cancel!=null and trainingRegistration.cancel!=0"> and sr.cancel = #{trainingRegistration.cancel} </if> <if test="trainingRegistration.isTrain!=null"> and bu.is_train = #{trainingRegistration.isTrain} </if> order by sr.id desc </select>
@@ -34,7 +34,7 @@ * @param trainingRegistration 培训报名对象 * @return */ List<ApplyInfoExcel> getTrainingRegistrationExcelList(TrainingRegistrationVo trainingRegistration); List<TrainingRegistrationExcel> getTrainingRegistrationExcelList(TrainingRegistrationVo trainingRegistration); /** * 培训考试清册导入 src/main/java/org/springblade/modules/training/service/impl/TrainingRegistrationServiceImpl.java
@@ -82,7 +82,7 @@ * @return */ @Override public List<ApplyInfoExcel> getTrainingRegistrationExcelList(TrainingRegistrationVo trainingRegistration) { public List<TrainingRegistrationExcel> getTrainingRegistrationExcelList(TrainingRegistrationVo trainingRegistration) { return baseMapper.getTrainingRegistrationExcelList(trainingRegistration); }
