| | |
|---|
| | | package com.ruoyi.web.controller.system; |
|---|
| | | import java.util.Date; |
|---|
| | | |
|---|
| | | import cn.afterturn.easypoi.excel.ExcelExportUtil; |
|---|
| | | import cn.afterturn.easypoi.excel.ExcelImportUtil; |
|---|
| | |
|---|
| | | Map<String, TDept> deptMap = tDeptService.list().stream().collect(Collectors.toMap(TDept::getDeptName, e -> e)); |
|---|
| | | Map<String, SysRole> roleMap = roleService.selectRoleAll().stream().collect(Collectors.toMap(SysRole::getRoleName, e -> e)); |
|---|
| | | for (EmployeeImportExcel employeeExcel : employeeExcelList) { |
|---|
| | | try { |
|---|
| | | EmployeeImportExcel employeeImportExcel = new EmployeeImportExcel(); |
|---|
| | | String nickName = employeeImportExcel.getNickName(); |
|---|
| | | String sex = employeeImportExcel.getSex(); |
|---|
| | | String idCard = employeeImportExcel.getIdCard(); |
|---|
| | | Integer age = employeeImportExcel.getAge(); |
|---|
| | | String politicalOutlook = employeeImportExcel.getPoliticalOutlook(); |
|---|
| | | Date participationTime = employeeImportExcel.getParticipationTime(); |
|---|
| | | Date companyTime = employeeImportExcel.getCompanyTime(); |
|---|
| | | String firstDegree = employeeImportExcel.getFirstDegree(); |
|---|
| | | String firstCollege = employeeImportExcel.getFirstCollege(); |
|---|
| | | String firstMajor = employeeImportExcel.getFirstMajor(); |
|---|
| | | String highestDegree = employeeImportExcel.getHighestDegree(); |
|---|
| | | String highestCollege = employeeImportExcel.getHighestCollege(); |
|---|
| | | String highestMajor = employeeImportExcel.getHighestMajor(); |
|---|
| | | String department = employeeImportExcel.getDepartment(); |
|---|
| | | String position = employeeImportExcel.getPosition(); |
|---|
| | | Date positionTime = employeeImportExcel.getPositionTime(); |
|---|
| | | String phoneNumber = employeeImportExcel.getPhoneNumber(); |
|---|
| | | String organization = employeeImportExcel.getOrganization(); |
|---|
| | | String roleName = employeeImportExcel.getRoleName(); |
|---|
| | | if (!StringUtils.isEmpty(nickName) |
|---|
| | | &&!StringUtils.isEmpty(sex) |
|---|
| | | &&!StringUtils.isEmpty(idCard) |
|---|
| | | &&!StringUtils.isEmpty(phoneNumber) |
|---|
| | | &&!StringUtils.isEmpty(organization) |
|---|
| | | &&!StringUtils.isEmpty(roleName) |
|---|
| | | &&!StringUtils.isEmpty(department) |
|---|
| | | &&!StringUtils.isEmpty(highestCollege) |
|---|
| | | ){ |
|---|
| | | // 到最后一行了 |
|---|
| | | break; |
|---|
| | | } |
|---|
| | | try { |
|---|
| | | // 数据验证 |
|---|
| | | if (StringUtils.isEmpty(employeeExcel.getNickName())) { |
|---|
| | | errorMessages.add("第" + (successCount + failCount + 1) + "行：姓名为空"); |
|---|
