Package es.kukenan.smartfi.microservice.onboarding.service

Class CompanyExcelService

java.lang.Object

es.kukenan.smartfi.microservice.onboarding.service.CompanyExcelService

@Service
public class CompanyExcelService
extends Object

Excel management service definition.

Nested Class Summary

Nested Classes

Modifier and Type	Class	Description
private static class	CompanyExcelService.ExcelRow	Internal class for manage excel row data.

Field Summary

Fields

Modifier and Type	Field	Description
private static final String	ADVANCE_PRODUCT	Advance constant.
private InternalBackofficeApiClient	backofficeApiClient	Internal backoffice endpoint.
private BackofficeService	backofficeService	Backoffice service.
private String	excelFolderPath	Excel files destination.

Constructor Summary

Constructors

Constructor	Description
CompanyExcelService()

Method Summary

Modifier and Type	Method	Description
private void	addDataToUser(CompanyExcelService.ExcelRow excelRow, int cellIndex, Object value)	Populate User and Bank Account from Excel Cell.
private void	copyRow(org.apache.poi.ss.usermodel.Workbook workbook, org.apache.poi.ss.usermodel.Sheet worksheet, org.apache.poi.ss.usermodel.Sheet resultSheet, int sourceRowNum, int destinationRowNum, CompanyExcelService.ExcelRow excelRow, Boolean header, Boolean addFailReason)	Copy an Excel Row to another.
void	readCompanyEmployeeExcelFile(String ruc, org.springframework.web.multipart.MultipartFile file, javax.servlet.http.HttpServletResponse response, String userIp, String userAgent)	Load an excel file with employee data from a company.
private String	translateReason(CompanyExcelService.ExcelRow excelRow)	Get fail reason from ExcelRow.

Methods inherited from class java.lang.Object

clone, equals, finalize, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait

Field Details

ADVANCE_PRODUCT

private static final String ADVANCE_PRODUCT

Advance constant.

See Also:

• Constant Field Values

excelFolderPath

@Value("${excel.folder.path}")
private String excelFolderPath

Excel files destination.

backofficeService

@Autowired
private BackofficeService backofficeService

Backoffice service.

backofficeApiClient

@Autowired
private InternalBackofficeApiClient backofficeApiClient

Internal backoffice endpoint.

Constructor Details

CompanyExcelService

public CompanyExcelService()

Method Details

addDataToUser

private void addDataToUser(CompanyExcelService.ExcelRow excelRow,
 int cellIndex,
 Object value)

Populate User and Bank Account from Excel Cell.

Parameters:

excelRow - ExcelRow object created with User and Bank Account.

cellIndex - Excel cell index.

value - Value from excel cell.

readCompanyEmployeeExcelFile

public void readCompanyEmployeeExcelFile(String ruc,
 org.springframework.web.multipart.MultipartFile file,
 javax.servlet.http.HttpServletResponse response,
 String userIp,
 String userAgent)
                                  throws IOException

Load an excel file with employee data from a company.

Parameters:

ruc - Company RUC identifier.

file - Excel file.

response - response.

userIp - user real ip

userAgent - user-agent header

Throws:

IOException - file to write response.

copyRow

private void copyRow(org.apache.poi.ss.usermodel.Workbook workbook,
 org.apache.poi.ss.usermodel.Sheet worksheet,
 org.apache.poi.ss.usermodel.Sheet resultSheet,
 int sourceRowNum,
 int destinationRowNum,
 CompanyExcelService.ExcelRow excelRow,
 Boolean header,
 Boolean addFailReason)

Copy an Excel Row to another.

Parameters:

workbook - Actual Workbook.

worksheet - Actual WorkSheet.

resultSheet - New WorkSheet.

sourceRowNum - Actual row number.

destinationRowNum - New row number.

excelRow - All data from excel and error reason.

header - flag for header row.

addFailReason - flag for add reason column at the left.

translateReason

private String translateReason(CompanyExcelService.ExcelRow excelRow)

Get fail reason from ExcelRow.

Parameters:

excelRow - Excel row data.

Returns:

value of reason