Package org.apache.ofbiz.pricat.sample

Class SamplePricatParser

java.lang.Object

org.apache.ofbiz.pricat.AbstractPricatParser

org.apache.ofbiz.pricat.sample.SamplePricatParser

All Implemented Interfaces:

InterfacePricatParser

public class SamplePricatParser
extends AbstractPricatParser

Sample pricat excel parser.

Field Summary

Fields

Modifier and Type	Field	Description
static java.util.Map<java.lang.String,java.util.List<java.lang.Object[]>>	ColNamesList
static int	headerRowNo
static java.lang.String	module

Fields inherited from class org.apache.ofbiz.pricat.AbstractPricatParser

basicBrandConds, basicCategoryConds, currencyId, delegator, dispatcher, errorMessages, facilities, fileItems, formatter, locale, pricatFile, pricatFileVersion, report, selectedFacilityId, selectedPricatType, sequenceNum, session, userLogin, 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	Description
SamplePricatParser(LocalDispatcher dispatcher, Delegator delegator, java.util.Locale locale, InterfaceReport report, java.util.Map<java.lang.String,java.lang.String[]> facilities, java.io.File pricatFile, GenericValue userLogin)

Method Summary

Modifier and Type	Method	Description
boolean	containsDataRows(org.apache.poi.xssf.usermodel.XSSFSheet sheet)
boolean	existsCurrencyId(org.apache.poi.xssf.usermodel.XSSFSheet sheet)
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)	Get data by version definition.
protected int	getHeaderRowNo()
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	isFacilityOk(org.apache.poi.xssf.usermodel.XSSFRow row, java.lang.String facilityName, java.lang.String facilityId)
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)	Check data according to business logic.
void	parsePricatExcel()
void	parsePricatExcel(boolean writeFile)	Parse pricat excel file in xlsx format.
void	parseRowByRow(org.apache.poi.xssf.usermodel.XSSFSheet sheet)
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)

Methods inherited from class org.apache.ofbiz.pricat.AbstractPricatParser

cleanupLogAndCommentedExcel, endExcelImportHistory, getBrandId, getColorIds, getDimensionIds, hasErrorMessages, initBasicConds, isCommentedExcelExists, isEmptyRow, isNumOfSheetsOK, setFacilityId, updateColorAndDimension, updateSkuPrice, writeCommentsToFile

Methods inherited from class java.lang.Object

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

Field Detail

module

public static final java.lang.String module

ColNamesList

public static final java.util.Map<java.lang.String,java.util.List<java.lang.Object[]>> ColNamesList

headerRowNo

public static final int headerRowNo

See Also:

Constant Field Values

Constructor Detail

SamplePricatParser

public SamplePricatParser(LocalDispatcher dispatcher,
                          Delegator delegator,
                          java.util.Locale locale,
                          InterfaceReport report,
                          java.util.Map<java.lang.String,java.lang.String[]> facilities,
                          java.io.File pricatFile,
                          GenericValue userLogin)

Method Detail

parsePricatExcel

public void parsePricatExcel(boolean writeFile)

Parse pricat excel file in xlsx format.

existsCurrencyId

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

parseRowByRow

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

parseCellContentsAndStore

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

Check data according to business logic. If data is ok, store it.

Parameters:

row -

cellContents -

Returns:

Throws:

GenericTransactionException

updateSku

public 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)

getProductId

public 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)

getCellContent

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

getProductCategoryId

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

isFacilityOk

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

isTableHeaderMatched

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

isVersionSupported

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

containsDataRows

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

parsePricatExcel

public void parsePricatExcel()

getCellContents

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

Get data by version definition.

Specified by:

getCellContents in interface InterfacePricatParser

Overrides:

getCellContents in class AbstractPricatParser

Parameters:

row -

colNames -

size -

Returns:

getHeaderRowNo

protected int getHeaderRowNo()

Specified by:

getHeaderRowNo in class AbstractPricatParser