| | |
|---|
| | | import org.springframework.transaction.annotation.Transactional; |
|---|
| | | import org.springframework.web.multipart.MultipartFile; |
|---|
| | | |
|---|
| | | import java.io.File; |
|---|
| | | import java.io.FileOutputStream; |
|---|
| | | import java.io.OutputStreamWriter; |
|---|
| | | import java.io.StringWriter; |
|---|
| | | import java.io.*; |
|---|
| | | import java.nio.charset.StandardCharsets; |
|---|
| | | import java.time.Instant; |
|---|
| | | import java.time.LocalDate; |
|---|
| | |
|---|
| | | // 创建合同记录 |
|---|
| | | StaffContract staffContract = new StaffContract(); |
|---|
| | | staffContract.setStaffOnJobId(staffOnJobPrams.getId()); |
|---|
| | | staffContract.setContractTerm(staffOnJobPrams.getContractTerm()); |
|---|
| | | String contractTerm = staffOnJobPrams.getContractTerm(); |
|---|
| | | staffContract.setContractTerm(StringUtils.isNotEmpty(contractTerm) ? contractTerm : null); |
|---|
| | | staffContract.setContractStartTime(staffOnJobPrams.getContractStartTime()); |
|---|
| | | staffContract.setContractEndTime(staffOnJobPrams.getContractEndTime()); |
|---|
| | | return staffContractMapper.insert(staffContract); |
|---|
| | |
|---|
| | | |
|---|
| | | @Override |
|---|
| | | @Transactional(rollbackFor = Exception.class) |
|---|
| | | public Boolean importData(MultipartFile file) { |
|---|
| | | try { |
|---|
| | | public Boolean importData(MultipartFile file) throws IOException { |
|---|
| | | ExcelUtil<StaffOnJobExcelDto> util = new ExcelUtil<>(StaffOnJobExcelDto.class); |
|---|
| | | List<StaffOnJobExcelDto> staffOnJobs = util.importExcel(file.getInputStream()); |
|---|
| | | if (CollectionUtils.isEmpty(staffOnJobs)){ |
|---|
| | |
|---|
| | | StaffOnJobDto staffOnJobDto = new StaffOnJobDto(); |
|---|
| | | BeanUtils.copyProperties(staffOnJob, staffOnJobDto); |
|---|
| | | // 通过名称获取部门id |
|---|
| | | staffOnJobDto.setSysDeptId(// ... existing code ... |
|---|
| | | staffOnJobDto.setSysDeptId( |
|---|
| | | sysDepts.stream() |
|---|
| | | .filter(dept -> dept.getDeptName() != null && dept.getDeptName().equals(staffOnJob.getSysDeptName())) |
|---|
| | | .findFirst() |
|---|
| | |
|---|
| | | add(staffOnJobDto); |
|---|
| | | }); |
|---|
| | | return true; |
|---|
| | | } catch (Exception e) { |
|---|
| | | e.printStackTrace(); |
|---|
| | | return false; |
|---|
| | | } |
|---|
| | | } |
|---|
| | | |
|---|
| | | |
|---|
