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 final String	CONFIRM
static final String	DEFAULT_CAT_NAME
static final String	DEFAULT_COL_NAME
static final String	DEFAULT_DIM_NAME
static final String	DEFAULT_PRICAT_TYPE
static final String	EXCEL_TEMPLATE_TYPE
static final String	FACILITY_ID
static final String	FILE_DATETIME_PATTERN
static final int	HISTORY_MAX_FILENUMBER
static final String[]	MESSAGE_LABELS
static final List<String>	MESSAGES
static final String	PARSE_EXCEL
static final String	PRICAT_FILE
static final Map<String,String>	PRICAT_TYPE_LABELS
static final String	RESOURCE
static final String	TEMP_FILES_FOLDER

Method Summary

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

Field Details

PARSE_EXCEL

static final String PARSE_EXCEL

See Also:

• Constant Field Values

CONFIRM

static final String CONFIRM

See Also:

• Constant Field Values

MESSAGE_LABELS

static final String[] MESSAGE_LABELS

MESSAGES

static final List<String> MESSAGES

TEMP_FILES_FOLDER

static final String TEMP_FILES_FOLDER

See Also:

• Constant Field Values

FILE_DATETIME_PATTERN

static final String FILE_DATETIME_PATTERN

See Also:

• Constant Field Values

DEFAULT_COL_NAME

static final String DEFAULT_COL_NAME

See Also:

• Constant Field Values

DEFAULT_DIM_NAME

static final String DEFAULT_DIM_NAME

See Also:

• Constant Field Values

DEFAULT_CAT_NAME

static final String DEFAULT_CAT_NAME

See Also:

• Constant Field Values

EXCEL_TEMPLATE_TYPE

static final String EXCEL_TEMPLATE_TYPE

See Also:

• Constant Field Values

FACILITY_ID

static final String FACILITY_ID

See Also:

• Constant Field Values

RESOURCE

static final String RESOURCE

See Also:

• Constant Field Values

PRICAT_FILE

static final String PRICAT_FILE

See Also:

• Constant Field Values

DEFAULT_PRICAT_TYPE

static final String DEFAULT_PRICAT_TYPE

See Also:

• Constant Field Values

PRICAT_TYPE_LABELS

static final Map<String,String> PRICAT_TYPE_LABELS

HISTORY_MAX_FILENUMBER

static final int HISTORY_MAX_FILENUMBER

Method Details

parsePricatExcel

void parsePricatExcel()

writeCommentsToFile

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

initBasicConds

void initBasicConds(List<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,
 List<Object> cellContents)
                           throws GenericTransactionException

Throws:

GenericTransactionException

updateSkuPrice

Map<String,Object> updateSkuPrice(String skuId,
 String ownerPartyId,
 BigDecimal memberPrice)

updateSku

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

updateColorAndDimension

Map<String,Object> updateColorAndDimension(String productId,
 String ownerPartyId,
 String color,
 String dimension)

getDimensionIds

Map<String,Object> getDimensionIds(String productId,
 String ownerPartyId,
 String dimension)

getColorIds

Map<String,Object> getColorIds(String productId,
 String ownerPartyId,
 String color)

getProductId

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

getBrandId

String getBrandId(String brandName,
 String ownerPartyId)

getCellContent

Object getCellContent(List<Object> cellContents,
 String colName)

getProductCategoryId

String getProductCategoryId(List<Object> cellContents,
 String ownerPartyId)

isFacilityOk

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

getCellContents

List<Object> getCellContents(org.apache.poi.xssf.usermodel.XSSFRow row,
 List<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(String selectedFacilityId)

endExcelImportHistory

void endExcelImportHistory(String logFileName,
 String thruReasonId)

hasErrorMessages

boolean hasErrorMessages()