Package org.apache.ofbiz.pricat

Interface InterfacePricatParser

All Known Implementing Classes:

AbstractPricatParser, SamplePricatParser

public interface InterfacePricatParser

Interface of pricat parser.

Field Summary

Fields

Modifier and Type	Field	Description
static java.lang.String	CONFIRM
static java.lang.String	DEFAULT_PRICAT_TYPE
static java.lang.String	defaultCategoryName
static java.lang.String	defaultColorName
static java.lang.String	defaultDimensionName
static java.lang.String	EXCEL_TEMPLATE_TYPE
static java.lang.String	FACILITY_ID
static java.lang.String	FileDateTimePattern
static int	HISTORY_MAX_FILENUMBER
static java.lang.String[]	messageLabels
static java.util.List<java.lang.String>	messages
static java.lang.String	PARSE_EXCEL
static java.lang.String	PRICAT_FILE
static java.util.Map<java.lang.String,java.lang.String>	PricatTypeLabels
static java.lang.String	resource
static java.lang.String	tempFilesFolder

Method Summary

Modifier and Type	Method	Description
boolean	containsDataRows(org.apache.poi.xssf.usermodel.XSSFSheet sheet)
void	endExcelImportHistory(java.lang.String logFileName, java.lang.String thruReasonId)
boolean	existsCurrencyId(org.apache.poi.xssf.usermodel.XSSFSheet sheet)
java.lang.String	getBrandId(java.lang.String brandName, java.lang.String ownerPartyId)
java.lang.Object	getCellContent(java.util.List<java.lang.Object> cellContents, java.lang.String colName)
java.util.List<java.lang.Object>	getCellContents(org.apache.poi.xssf.usermodel.XSSFRow row, java.util.List<java.lang.Object[]> colNames, int size)
java.util.Map<java.lang.String,java.lang.Object>	getColorIds(java.lang.String productId, java.lang.String ownerPartyId, java.lang.String color)
java.util.Map<java.lang.String,java.lang.Object>	getDimensionIds(java.lang.String productId, java.lang.String ownerPartyId, java.lang.String dimension)
java.lang.String	getProductCategoryId(java.util.List<java.lang.Object> cellContents, java.lang.String ownerPartyId)
java.lang.String	getProductId(org.apache.poi.xssf.usermodel.XSSFRow row, java.lang.String brandId, java.lang.String modelName, java.lang.String productName, java.lang.String productCategoryId, java.lang.String ownerPartyId, java.math.BigDecimal listPrice)
boolean	hasErrorMessages()
void	initBasicConds(java.util.List<java.lang.String> orgPartyIds)
boolean	isFacilityOk(org.apache.poi.xssf.usermodel.XSSFRow row, java.lang.String facilityName, java.lang.String facilityId)
boolean	isNumOfSheetsOK(org.apache.poi.xssf.usermodel.XSSFWorkbook workbook)
boolean	isTableHeaderMatched(org.apache.poi.xssf.usermodel.XSSFSheet sheet)
boolean	isVersionSupported(org.apache.poi.xssf.usermodel.XSSFSheet sheet)
boolean	parseCellContentsAndStore(org.apache.poi.xssf.usermodel.XSSFRow row, java.util.List<java.lang.Object> cellContents)
void	parsePricatExcel()
void	parseRowByRow(org.apache.poi.xssf.usermodel.XSSFSheet sheet)
void	setFacilityId(java.lang.String selectedFacilityId)
java.util.Map<java.lang.String,java.lang.Object>	updateColorAndDimension(java.lang.String productId, java.lang.String ownerPartyId, java.lang.String color, java.lang.String dimension)
java.lang.String	updateSku(org.apache.poi.xssf.usermodel.XSSFRow row, java.lang.String productId, java.lang.String ownerPartyId, java.lang.String facilityId, java.lang.String barcode, java.math.BigDecimal inventory, java.lang.String colorId, java.lang.String color, java.lang.String dimensionId, java.lang.String dimension, java.math.BigDecimal listPrice, java.math.BigDecimal averageCost)
java.util.Map<java.lang.String,java.lang.Object>	updateSkuPrice(java.lang.String skuId, java.lang.String ownerPartyId, java.math.BigDecimal memberPrice)
void	writeCommentsToFile(org.apache.poi.xssf.usermodel.XSSFWorkbook workbook, org.apache.poi.xssf.usermodel.XSSFSheet sheet)

Field Detail

PARSE_EXCEL

static final java.lang.String PARSE_EXCEL

See Also:

Constant Field Values

CONFIRM

static final java.lang.String CONFIRM

See Also:

Constant Field Values

messageLabels

static final java.lang.String[] messageLabels

messages

static final java.util.List<java.lang.String> messages

tempFilesFolder

static final java.lang.String tempFilesFolder

See Also:

Constant Field Values

FileDateTimePattern

static final java.lang.String FileDateTimePattern

See Also:

Constant Field Values

defaultColorName

static final java.lang.String defaultColorName

See Also:

Constant Field Values

defaultDimensionName

static final java.lang.String defaultDimensionName

See Also:

Constant Field Values

defaultCategoryName

static final java.lang.String defaultCategoryName

See Also:

Constant Field Values

EXCEL_TEMPLATE_TYPE

static final java.lang.String EXCEL_TEMPLATE_TYPE

See Also:

Constant Field Values

FACILITY_ID

static final java.lang.String FACILITY_ID

See Also:

Constant Field Values

resource

static final java.lang.String resource

See Also:

Constant Field Values

PRICAT_FILE

static final java.lang.String PRICAT_FILE

See Also:

Constant Field Values

DEFAULT_PRICAT_TYPE

static final java.lang.String DEFAULT_PRICAT_TYPE

See Also:

Constant Field Values

PricatTypeLabels

static final java.util.Map<java.lang.String,java.lang.String> PricatTypeLabels

HISTORY_MAX_FILENUMBER

static final int HISTORY_MAX_FILENUMBER

Method Detail

parsePricatExcel

void parsePricatExcel()

writeCommentsToFile

void writeCommentsToFile(org.apache.poi.xssf.usermodel.XSSFWorkbook workbook,
                         org.apache.poi.xssf.usermodel.XSSFSheet sheet)

initBasicConds

void initBasicConds(java.util.List<java.lang.String> orgPartyIds)

existsCurrencyId

boolean existsCurrencyId(org.apache.poi.xssf.usermodel.XSSFSheet sheet)

parseRowByRow

void parseRowByRow(org.apache.poi.xssf.usermodel.XSSFSheet sheet)

parseCellContentsAndStore

boolean parseCellContentsAndStore(org.apache.poi.xssf.usermodel.XSSFRow row,
                                  java.util.List<java.lang.Object> cellContents)
                           throws GenericTransactionException

Throws:

GenericTransactionException

updateSkuPrice

java.util.Map<java.lang.String,java.lang.Object> updateSkuPrice(java.lang.String skuId,
                                                                      java.lang.String ownerPartyId,
                                                                      java.math.BigDecimal memberPrice)

updateSku

java.lang.String updateSku(org.apache.poi.xssf.usermodel.XSSFRow row,
                           java.lang.String productId,
                           java.lang.String ownerPartyId,
                           java.lang.String facilityId,
                           java.lang.String barcode,
                           java.math.BigDecimal inventory,
                           java.lang.String colorId,
                           java.lang.String color,
                           java.lang.String dimensionId,
                           java.lang.String dimension,
                           java.math.BigDecimal listPrice,
                           java.math.BigDecimal averageCost)

updateColorAndDimension

java.util.Map<java.lang.String,java.lang.Object> updateColorAndDimension(java.lang.String productId,
                                                                               java.lang.String ownerPartyId,
                                                                               java.lang.String color,
                                                                               java.lang.String dimension)

getDimensionIds

java.util.Map<java.lang.String,java.lang.Object> getDimensionIds(java.lang.String productId,
                                                                       java.lang.String ownerPartyId,
                                                                       java.lang.String dimension)

getColorIds

java.util.Map<java.lang.String,java.lang.Object> getColorIds(java.lang.String productId,
                                                                   java.lang.String ownerPartyId,
                                                                   java.lang.String color)

getProductId

java.lang.String getProductId(org.apache.poi.xssf.usermodel.XSSFRow row,
                              java.lang.String brandId,
                              java.lang.String modelName,
                              java.lang.String productName,
                              java.lang.String productCategoryId,
                              java.lang.String ownerPartyId,
                              java.math.BigDecimal listPrice)

getBrandId

java.lang.String getBrandId(java.lang.String brandName,
                            java.lang.String ownerPartyId)

getCellContent

java.lang.Object getCellContent(java.util.List<java.lang.Object> cellContents,
                                java.lang.String colName)

getProductCategoryId

java.lang.String getProductCategoryId(java.util.List<java.lang.Object> cellContents,
                                      java.lang.String ownerPartyId)

isFacilityOk

boolean isFacilityOk(org.apache.poi.xssf.usermodel.XSSFRow row,
                     java.lang.String facilityName,
                     java.lang.String facilityId)

getCellContents

java.util.List<java.lang.Object> getCellContents(org.apache.poi.xssf.usermodel.XSSFRow row,
                                                 java.util.List<java.lang.Object[]> colNames,
                                                 int size)

isTableHeaderMatched

boolean isTableHeaderMatched(org.apache.poi.xssf.usermodel.XSSFSheet sheet)

isVersionSupported

boolean isVersionSupported(org.apache.poi.xssf.usermodel.XSSFSheet sheet)

containsDataRows

boolean containsDataRows(org.apache.poi.xssf.usermodel.XSSFSheet sheet)

isNumOfSheetsOK

boolean isNumOfSheetsOK(org.apache.poi.xssf.usermodel.XSSFWorkbook workbook)

setFacilityId

void setFacilityId(java.lang.String selectedFacilityId)

endExcelImportHistory

void endExcelImportHistory(java.lang.String logFileName,
                           java.lang.String thruReasonId)

hasErrorMessages

boolean hasErrorMessages()