| | |
| | | */ |
| | | @PostMapping("import-trainingRegistration") |
| | | @ApiOperation(value = "导入培训报名数据", notes = "传入excel") |
| | | public R importUser(MultipartFile file, Integer isCovered,Long examId) { |
| | | TrainingRegistrationImporter trainingRegistrationImporter = new TrainingRegistrationImporter(trainingRegistrationService, false,examId); |
| | | public R importUser(MultipartFile file, Integer isCovered,String deptId) { |
| | | TrainingRegistrationImporter trainingRegistrationImporter = new TrainingRegistrationImporter(trainingRegistrationService, false,deptId); |
| | | ExcelUtil.save(file, trainingRegistrationImporter, TrainingRegistrationExcel.class); |
| | | return R.success("操作成功"); |
| | | } |
| | |
| | | @ApiOperation(value = "导出模板") |
| | | public void exportUser(HttpServletResponse response) { |
| | | List<TrainingRegistrationExcel> list = new ArrayList<>(); |
| | | ExcelUtil.export(response, "培训报名数据模板", "培训报名数据表", list, TrainingRegistrationExcel.class); |
| | | //创建示例 |
| | | TrainingRegistrationExcel excel = new TrainingRegistrationExcel(); |
| | | excel.setDeptName("****保安公司"); |
| | | excel.setRealName("张三"); |
| | | excel.setDeptName("360110202201010001"); |
| | | list.add(excel); |
| | | ExcelUtil.export(response, "培训报名数据模板" + DateUtil.time(), "培训报名数据表", list, TrainingRegistrationExcel.class); |
| | | } |
| | | |
| | | |