| | |
| | | @PostMapping("import-apply") |
| | | @ApiOperation(value = "导入报名考试数据", notes = "传入excel") |
| | | public R importUser(MultipartFile file, Integer isCovered) { |
| | | ApplyImporter applyImporter = new ApplyImporter(applyService, false); |
| | | ApplyImporter applyImporter = new ApplyImporter(applyService, false,null); |
| | | ExcelUtil.save(file, applyImporter, ApplyExcel.class); |
| | | return R.success("操作成功"); |
| | | } |
| | | |
| | | /** |
| | | * 导入报名考试数据(已生成考试) |
| | | */ |
| | | @PostMapping("import-applys") |
| | | @ApiOperation(value = "导入报名考试数据", notes = "传入excel") |
| | | public R importUser(MultipartFile file, Integer isCovered,Long examId) { |
| | | ApplyImporter applyImporter = new ApplyImporter(applyService, false,examId); |
| | | ExcelUtil.save(file, applyImporter, ApplyExcel.class); |
| | | return R.success("操作成功"); |
| | | } |
| | |
| | | //内网同步 |
| | | Long sid = examScore.getId(); |
| | | String format = new SimpleDateFormat("yyyy-MM-dd HH:mm:ss").format(examScore.getExamTime()); |
| | | String s = "insert into exam_score(id,exam_time,user_id,exam_id,apply_id) " + |
| | | "values(" + "'" + sid + "'" + "," + "'" + |
| | | format + "'" + "," + "'" + |
| | | examScore.getUserId() +"'" + "," +"'" + |
| | | examScore.getExamId() +"'" + "," +"'" + |
| | | examScore.getApplyId() + "'" + ")"; |
| | | FtpUtil.sqlFileUpload(s); |
| | | // String s = "insert into exam_score(id,exam_time,user_id,exam_id,apply_id) " + |
| | | // "values(" + "'" + sid + "'" + "," + "'" + |
| | | // format + "'" + "," + "'" + |
| | | // examScore.getUserId() +"'" + "," +"'" + |
| | | // examScore.getExamId() +"'" + "," +"'" + |
| | | // examScore.getApplyId() + "'" + ")"; |
| | | // FtpUtil.sqlFileUpload(s); |
| | | return examScore; |
| | | } |
| | | |