org.apache.ofbiz.pricat

Class AbstractPricatParser

java.lang.Object

org.apache.ofbiz.pricat.AbstractPricatParser

All Implemented Interfaces:

InterfacePricatParser

Direct Known Subclasses:

SamplePricatParser

public abstract class AbstractPricatParser
extends Object
implements InterfacePricatParser

Abstract class of pricat parser.

Field Summary

Fields

Modifier and Type	Field and Description
protected List<EntityCondition>	basicBrandConds
protected List<EntityCondition>	basicCategoryConds
protected String	currencyId
protected Delegator	delegator
protected LocalDispatcher	dispatcher
protected Map<org.apache.poi.ss.util.CellReference,String>	errorMessages
protected Map<String,String[]>	facilities
protected List<org.apache.commons.fileupload.FileItem>	fileItems
protected org.apache.poi.hssf.usermodel.HSSFDataFormatter	formatter
protected Locale	locale
static String	module
protected File	pricatFile
protected String	pricatFileVersion
protected InterfaceReport	report
protected String	selectedFacilityId
protected String	selectedPricatType
protected long	sequenceNum
protected HttpSession	session
protected GenericValue	userLogin
protected String	userLoginId

Fields inherited from interface org.apache.ofbiz.pricat.InterfacePricatParser

CONFIRM, DEFAULT_PRICAT_TYPE, defaultCategoryName, defaultColorName, defaultDimensionName, EXCEL_TEMPLATE_TYPE, FACILITY_ID, FileDateTimePattern, HISTORY_MAX_FILENUMBER, messageLabels, messages, PARSE_EXCEL, PRICAT_FILE, PricatTypeLabels, resource, tempFilesFolder

Constructor Summary

Constructors

Constructor and Description
AbstractPricatParser(LocalDispatcher dispatcher, Delegator delegator, Locale locale, InterfaceReport report, Map<String,String[]> facilities, File pricatFile, GenericValue userLogin)

Method Summary

Modifier and Type	Method and Description
protected void	cleanupLogAndCommentedExcel()
void	endExcelImportHistory(String logFileName, String thruReasonId)
String	getBrandId(String brandName, String ownerPartyId)
List<Object>	getCellContents(org.apache.poi.xssf.usermodel.XSSFRow row, List<Object[]> colNames, int size) Get data by version definition.
Map<String,Object>	getColorIds(String productId, String ownerPartyId, String color)
Map<String,Object>	getDimensionIds(String productId, String ownerPartyId, String dimension)
protected abstract int	getHeaderRowNo()
boolean	hasErrorMessages()
void	initBasicConds(List<String> orgPartyIds)
static boolean	isCommentedExcelExists(HttpServletRequest request, Long sequenceNum) Check whether a commented file exists.
protected boolean	isEmptyRow(org.apache.poi.xssf.usermodel.XSSFRow row, int size, boolean display)
boolean	isNumOfSheetsOK(org.apache.poi.xssf.usermodel.XSSFWorkbook workbook)
void	setFacilityId(String selectedFacilityId)
Map<String,Object>	updateColorAndDimension(String productId, String ownerPartyId, String color, String dimension)
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)

Methods inherited from class java.lang.Object

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

Methods inherited from interface org.apache.ofbiz.pricat.InterfacePricatParser

containsDataRows, existsCurrencyId, getCellContent, getProductCategoryId, getProductId, isFacilityOk, isTableHeaderMatched, isVersionSupported, parseCellContentsAndStore, parsePricatExcel, parseRowByRow, updateSku

Field Detail

module

public static final String module

dispatcher

protected LocalDispatcher dispatcher

delegator

protected Delegator delegator

fileItems

protected List<org.apache.commons.fileupload.FileItem> fileItems

pricatFile

protected File pricatFile

userLoginId

protected String userLoginId

userLogin

protected GenericValue userLogin

pricatFileVersion

protected String pricatFileVersion

currencyId

protected String currencyId

errorMessages

protected Map<org.apache.poi.ss.util.CellReference,String> errorMessages

formatter

protected org.apache.poi.hssf.usermodel.HSSFDataFormatter formatter

facilities

protected Map<String,String[]> facilities

session

protected HttpSession session

basicCategoryConds

protected List<EntityCondition> basicCategoryConds

basicBrandConds

protected List<EntityCondition> basicBrandConds

selectedPricatType

protected String selectedPricatType

selectedFacilityId

protected String selectedFacilityId

report

protected InterfaceReport report

locale

protected Locale locale

sequenceNum

protected long sequenceNum

Constructor Detail

AbstractPricatParser

public AbstractPricatParser(LocalDispatcher dispatcher,
                            Delegator delegator,
                            Locale locale,
                            InterfaceReport report,
                            Map<String,String[]> facilities,
                            File pricatFile,
                            GenericValue userLogin)

Method Detail

writeCommentsToFile

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

Specified by:

writeCommentsToFile in interface InterfacePricatParser

initBasicConds

public void initBasicConds(List<String> orgPartyIds)

Specified by:

initBasicConds in interface InterfacePricatParser

updateSkuPrice

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

Specified by:

updateSkuPrice in interface InterfacePricatParser

updateColorAndDimension

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

Specified by:

updateColorAndDimension in interface InterfacePricatParser

getDimensionIds

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

Specified by:

getDimensionIds in interface InterfacePricatParser

getColorIds

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

Specified by:

getColorIds in interface InterfacePricatParser

getBrandId

public String getBrandId(String brandName,
                         String ownerPartyId)

Specified by:

getBrandId in interface InterfacePricatParser

isNumOfSheetsOK

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

Specified by:

isNumOfSheetsOK in interface InterfacePricatParser

getCellContents

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

Get data by version definition.

Specified by:

getCellContents in interface InterfacePricatParser

Parameters:

row -

colNames -

size -

Returns:

setFacilityId

public void setFacilityId(String selectedFacilityId)

Specified by:

setFacilityId in interface InterfacePricatParser

isEmptyRow

protected boolean isEmptyRow(org.apache.poi.xssf.usermodel.XSSFRow row,
                             int size,
                             boolean display)

getHeaderRowNo

protected abstract int getHeaderRowNo()

endExcelImportHistory

public void endExcelImportHistory(String logFileName,
                                  String thruReasonId)

Specified by:

endExcelImportHistory in interface InterfacePricatParser

hasErrorMessages

public boolean hasErrorMessages()

Specified by:

hasErrorMessages in interface InterfacePricatParser

isCommentedExcelExists

public static boolean isCommentedExcelExists(HttpServletRequest request,
                                             Long sequenceNum)

Check whether a commented file exists.

Parameters:

request -

sequenceNum -

Returns:

cleanupLogAndCommentedExcel

protected void cleanupLogAndCommentedExcel()