com.ibm.commerce.tools.catalog.util
Class CatalogEntryCreateUpdateHelper

java.lang.Object
  com.ibm.commerce.tools.catalog.util.CatalogEntryCreateUpdateHelper
Direct Known Subclasses:
ItemCreateHelper, ItemUpdateHelper

public abstract class CatalogEntryCreateUpdateHelper
extends java.lang.Object

CatalogEntryCreateUpdateHelper is an abstract class. Please use ItemUpdateHelper/ItemCreateHelper to create/update SKUs .


Field Summary
static java.lang.String CLASS_NAME
protected java.math.BigDecimal idField3
protected java.util.Hashtable ihashAttrValues
protected java.util.Hashtable ihashCatentryShipping
protected java.util.Hashtable ihashDiscount
protected java.util.Hashtable ihashSalesTax
protected java.util.Hashtable ihashShippingMode
protected java.util.Hashtable ihashShippingTax
protected java.lang.Integer inAvailable
protected java.lang.Integer inBuyable
protected java.lang.Long inCatalogGroupId
protected java.lang.Long inCatalogId
protected java.lang.Long inCatentryId
protected java.lang.Integer inDescLanguage
protected java.lang.Integer inField1
protected java.lang.Integer inField2
protected java.lang.Integer inMarkfordelete
protected java.lang.Long inMemberId
protected java.lang.Integer inOnauction
protected java.lang.Integer inOnspecial
protected java.lang.Long inProductId
protected java.lang.Integer inPublished
protected java.lang.String istrAuxDescription1
protected java.lang.String istrAuxDescription2
protected java.lang.String istrCatenttypeId
protected java.lang.String istrCatEntURL
protected java.lang.String istrField4
protected java.lang.String istrField5
protected java.lang.String istrFullimage
protected java.lang.String istrLongDescription
protected java.lang.String istrMfname
protected java.lang.String istrMfpartnumber
protected java.lang.String istrName
protected java.lang.String istrPartnumber
protected java.lang.String istrShortDescription
protected java.lang.String istrStoreId
protected java.lang.String istrThumbnail
protected java.lang.String istrXMLdetail
protected java.sql.Timestamp itmAvailabilitydate
protected java.sql.Timestamp itmEndDate
protected java.sql.Timestamp itmLastupdate
protected java.sql.Timestamp itmStartDate
protected CommandContext m_cmdContext
Constructor Summary
CatalogEntryCreateUpdateHelper()
Method Summary
static java.lang.Long findAttributeValueId(java.lang.Long nAttributeId, java.lang.Integer nLanguageId, java.lang.String strAttributeValue)
find attribute value ID from attributeId, languageId, and value.
static ItemAccessBean findSKUByAttrValue(java.lang.Long nProductId, java.util.Hashtable hashtableAttributeValues)
Find SKU by its attribute values.
static void flushEJB()
flush EJB.
java.util.Hashtable getAttributeValues()
Get attribute values
java.lang.String getAuxDescription1()
Get additional description of the Catalog Entry description
java.lang.String getAuxDescription2()
Get additional description of the Catalog Entry description
java.lang.Integer getAvailable()
Get the length of time to available of the Catalog Entry description
java.sql.Timestamp getAvailablitydate()
Get availablility date of the Catalog Entry description
java.lang.Integer getBuyable()
Get the buyable
java.lang.Long getCatalogGroupId()
gets Catalog Group Id.
java.lang.Long getCatalogId()
sets Catalog Id.
java.lang.Long getCatentryId()
Get the Catalog Entry Id
java.util.Hashtable getCatentryShippingInfo()
Get the Catalog Entry Shipping information
java.lang.String getCatenttypeId()
Get the catenttype of the Catalog Entry
java.lang.String getCatEntURL()
Get the URL of the Catentry Entry
CommandContext getCommandContext()
get CommandContext
java.lang.Integer getDescLanguage()
Get language id of the Catalog Entry description
java.util.Hashtable getDiscount()
Get the Discount information
java.sql.Timestamp getEndDate()
Get the end date of the Catalog Entry
java.lang.Integer getField1()
Get field1
java.lang.Integer getField2()
Get field2
java.math.BigDecimal getField3()
Get field3
java.lang.String getField4()
Get field4
java.lang.String getField5()
Get field5
java.lang.String getFullimage()
Get path of the full image of the Catalog Entry description
java.sql.Timestamp getLastupdate()
Get last update time of the Catalog Entry
java.lang.String getLongDescription()
Get long description of the Catalog Entry description
java.lang.Integer getMarkfordelete()
Get the value of setting Catalog Entry to mark for delete
java.lang.Long getMemberId()
Get the value of setting Catalog Entry to mark for delete
java.lang.String getMfname()
Get the manufacturer name of the Catalog Entry
java.lang.String getMfpartnumber()
Get the manufacturer part number of the Catalog Entry
java.lang.String getName()
Get name of the Catalog Entry description
java.lang.Integer getOnauction()
Get the value of the Catentry Entry if it is on auction
java.lang.Integer getOnspecial()
Get the value of the Catentry Entry if it is on special
java.lang.String getPartnumber()
Get the part number of the Catalog Entry
java.lang.Long getProductId()
Get the Catalog Entry Id of the product
java.lang.Integer getPublished()
Get published of the Catalog Entry description
java.util.Hashtable getSalesTax()
Get the SalesTax information
java.util.Hashtable getShippingMode()
Get the Shipping Category information
java.util.Hashtable getShippingTax()
Get the Shipping Tax information
java.lang.String getShortDescription()
Get short description of the Catalog Entry description
java.sql.Timestamp getStartDate()
Get the start date of the Catalog Entry
static java.lang.Integer getStoreDefaultLanguage(java.lang.Integer nStoreId)
get the default Language of a store.
java.lang.String getStoreId()
Get the Store Id
java.lang.String getThumbnail()
Get thumbnail image of the Catalog Entry description
java.lang.String getXMLdetail()
Get XML detail of the Catalog Entry description
static boolean hasAttribute(java.lang.Long nProductId)
checks if the product has attributes defined.
static boolean hasAttribute(java.lang.Long nProductId, java.lang.Integer nLanguageId)
checks if the product has attributes defined.
static boolean hasChildCatentry(java.lang.Long nProductId)
checks if the product has child SKUs defined.
static boolean hasPrices(java.lang.Long nCatentryId)
checks if the catentry has prices defined.
static boolean hasPrices(java.lang.Long nCatentryId, java.lang.Integer nStoreId)
checks if the catentry has prices defined.
static boolean isDuplicatedAttrValue(java.lang.Long nProductId, java.util.Hashtable hashtableAttributeValues)
checks if the attribute values have been assigned to a SKU.
static boolean isExistingSKUCode(java.lang.String strSKUCode, java.lang.Long nMemberId)
checks if the SKU code has been assigned to a SKU.
static void refreshCalcCodeRegistry()
refresh CalcCode Registry.
static void refreshRegistry(java.lang.String strRegistryName)
refresh Registry.
void reset()
resets all instance variables to null.
void setAttributeValues(java.util.Hashtable hashAttrValues)
sets attribute values to a catentry.
void setAuxdescription1(java.lang.String astrAuxDescription1)
Set additional description for the Catalog Entry Description
void setAuxdescription2(java.lang.String astrAuxDescription2)
Set additional description for the Catalog Entry Description
void setAvailabilitydate(java.sql.Timestamp atmAvailabilitydate)
Set availability date for the Catalog Entry Description
void setAvailable(java.lang.Integer anAvailable)
Set available for the Catalog Entry Description
void setBuyable(java.lang.Integer anBuyable)
Set the catalog entry to buyable 0 - Non Buyable 1 - Buyable
void setCatalogGroupId(java.lang.Long nCatalogGroupId)
sets Catalog Group Id.
void setCatalogId(java.lang.Long nCatalogId)
sets Catalog Id.
void setCatentryId(java.lang.Long anCatentryId)
Set a Catalog Entry Id
void setCatentryShipping(java.util.Hashtable hashCatentryShipping)
sets Catentry shipping information.
void setCatenttypeId(java.lang.String astrCatenttypeId)
Set a Catalog Entry Type Id
void setCatEntURL(java.lang.String astrCatEntURL)
Set a URL for the Catalog Entry
void setCommandContext(CommandContext cmdContext)
set CommandContext
void setDescLanguage(java.lang.Integer anDescLanguage)
Set language id of Catalog Entry Description
void setDiscount(java.util.Hashtable hashDiscount)
sets Discount information.
void setEndDate(java.sql.Timestamp atmEndDate)
Sets the end date when the Catalog Entry was updated
void setField1(java.lang.Integer anField1)
Set Field1 of the Catalog Entry
void setField2(java.lang.Integer anField2)
Set Field2 of the Catalog Entry
void setField3(java.math.BigDecimal adField3)
Set Field3 of the Catalog Entry
void setField4(java.lang.String astrField4)
Set Field4 of the Catalog Entry
void setField5(java.lang.String astrField5)
Set Field5 of the Catalog Entry
void setFullimage(java.lang.String astrFullimage)
Set path of the full image of Catalog Entry Description
void setLastupdate(java.sql.Timestamp atmLastupdate)
Sets the date and time when the Catalog Entry was updated
void setLongdescription(java.lang.String astrLongDescription)
Set long description of Catalog Entry Description
void setMarkfordelete(java.lang.Integer anMarkfordelete)
Set markfordelete of the Catalog Entry
void setMemberId(java.lang.Long anMemberId)
Set owner of the Catalog Entry
void setMfname(java.lang.String astrMfname)
Set manufacturer name of the Catalog Entry
void setMfpartnumber(java.lang.String astrMfpartnumber)
Set the part number of the Catalog Entry used by the manufacturer
void setName(java.lang.String astrName)
Set language dependent name of Catalog Entry Description
void setOnauction(java.lang.Integer anOnauction)
Set if the Catalog Entry is on auction 0 - Not on auction 1 - on auction
void setOnspecial(java.lang.Integer anOnspecial)
Set if the Catalog Entry is on special 0 - Not on special 1 - on special
void setPartnumber(java.lang.String astrPartnumber)
Set the partnumber of the Catalog Entry
void setProductId(java.lang.Long nProductId)
set Product Id.
void setPublished(java.lang.Integer anPublished)
Set published of Catalog Entry Description
void setSalesTax(java.util.Hashtable hashSalesTax)
sets Sales Tax information.
void setShippingMode(java.util.Hashtable hashShippingMode)
sets Shipping category information.
void setShippingTax(java.util.Hashtable hashShippingTax)
sets Shipping Tax information.
void setShortdescription(java.lang.String astrShortDescription)
Set short description of Catalog Entry Description
void setStartDate(java.sql.Timestamp atmStartDate)
Sets the start date when the Catalog Entry was updated
void setStoreId(java.lang.String astrStoreId)
sets Store Id.
void setThumbnail(java.lang.String astrThumbnail)
Set path to a thumbnail image of Catalog Entry Description
void setXMLdetail(java.lang.String astrXMLdetail)
Set XML detail of Catalog Entry Description
protected java.lang.String str2YN(java.lang.String str)
translate true/false to Y/N.
Methods inherited from class java.lang.Object
clone, equals, finalize, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait
Field Detail

CLASS_NAME

public static final java.lang.String CLASS_NAME
See Also:
Constant Field Values

m_cmdContext

protected CommandContext m_cmdContext

inCatentryId

protected java.lang.Long inCatentryId

idField3

protected java.math.BigDecimal idField3

inBuyable

protected java.lang.Integer inBuyable

inField1

protected java.lang.Integer inField1

inField2

protected java.lang.Integer inField2

inMarkfordelete

protected java.lang.Integer inMarkfordelete

inMemberId

protected java.lang.Long inMemberId

inOnauction

protected java.lang.Integer inOnauction

inOnspecial

protected java.lang.Integer inOnspecial

istrCatenttypeId

protected java.lang.String istrCatenttypeId

istrField4

protected java.lang.String istrField4

istrField5

protected java.lang.String istrField5

istrMfname

protected java.lang.String istrMfname

istrMfpartnumber

protected java.lang.String istrMfpartnumber

istrPartnumber

protected java.lang.String istrPartnumber

istrCatEntURL

protected java.lang.String istrCatEntURL

itmLastupdate

protected java.sql.Timestamp itmLastupdate

itmEndDate

protected java.sql.Timestamp itmEndDate

itmStartDate

protected java.sql.Timestamp itmStartDate

inAvailable

protected java.lang.Integer inAvailable

inDescLanguage

protected java.lang.Integer inDescLanguage

inPublished

protected java.lang.Integer inPublished

istrAuxDescription1

protected java.lang.String istrAuxDescription1

istrAuxDescription2

protected java.lang.String istrAuxDescription2

istrFullimage

protected java.lang.String istrFullimage

istrLongDescription

protected java.lang.String istrLongDescription

istrName

protected java.lang.String istrName

istrShortDescription

protected java.lang.String istrShortDescription

istrThumbnail

protected java.lang.String istrThumbnail

istrXMLdetail

protected java.lang.String istrXMLdetail

itmAvailabilitydate

protected java.sql.Timestamp itmAvailabilitydate

ihashAttrValues

protected java.util.Hashtable ihashAttrValues

inProductId

protected java.lang.Long inProductId

inCatalogId

protected java.lang.Long inCatalogId

inCatalogGroupId

protected java.lang.Long inCatalogGroupId

istrStoreId

protected java.lang.String istrStoreId

ihashCatentryShipping

protected java.util.Hashtable ihashCatentryShipping

ihashShippingMode

protected java.util.Hashtable ihashShippingMode

ihashShippingTax

protected java.util.Hashtable ihashShippingTax

ihashSalesTax

protected java.util.Hashtable ihashSalesTax

ihashDiscount

protected java.util.Hashtable ihashDiscount
Constructor Detail

CatalogEntryCreateUpdateHelper

public CatalogEntryCreateUpdateHelper()
Method Detail

findSKUByAttrValue

public static ItemAccessBean findSKUByAttrValue(java.lang.Long nProductId,
                                                java.util.Hashtable hashtableAttributeValues)
Find SKU by its attribute values.

getAttributeValues

public java.util.Hashtable getAttributeValues()
Get attribute values

getAuxDescription1

public java.lang.String getAuxDescription1()
Get additional description of the Catalog Entry description

getAuxDescription2

public java.lang.String getAuxDescription2()
Get additional description of the Catalog Entry description

getAvailable

public java.lang.Integer getAvailable()
Get the length of time to available of the Catalog Entry description

getAvailablitydate

public java.sql.Timestamp getAvailablitydate()
Get availablility date of the Catalog Entry description

getBuyable

public java.lang.Integer getBuyable()
Get the buyable

getCatentryId

public java.lang.Long getCatentryId()
Get the Catalog Entry Id

getCatentryShippingInfo

public java.util.Hashtable getCatentryShippingInfo()
Get the Catalog Entry Shipping information

getCatenttypeId

public java.lang.String getCatenttypeId()
Get the catenttype of the Catalog Entry

getCatEntURL

public java.lang.String getCatEntURL()
Get the URL of the Catentry Entry

getCommandContext

public CommandContext getCommandContext()
get CommandContext

getDescLanguage

public java.lang.Integer getDescLanguage()
Get language id of the Catalog Entry description

getDiscount

public java.util.Hashtable getDiscount()
Get the Discount information

getField1

public java.lang.Integer getField1()
Get field1

getField2

public java.lang.Integer getField2()
Get field2

getField3

public java.math.BigDecimal getField3()
Get field3

getField4

public java.lang.String getField4()
Get field4

getField5

public java.lang.String getField5()
Get field5

getFullimage

public java.lang.String getFullimage()
Get path of the full image of the Catalog Entry description

getLastupdate

public java.sql.Timestamp getLastupdate()
Get last update time of the Catalog Entry

getEndDate

public java.sql.Timestamp getEndDate()
Get the end date of the Catalog Entry

getStartDate

public java.sql.Timestamp getStartDate()
Get the start date of the Catalog Entry

getLongDescription

public java.lang.String getLongDescription()
Get long description of the Catalog Entry description

getMarkfordelete

public java.lang.Integer getMarkfordelete()
Get the value of setting Catalog Entry to mark for delete

getMemberId

public java.lang.Long getMemberId()
Get the value of setting Catalog Entry to mark for delete

getMfname

public java.lang.String getMfname()
Get the manufacturer name of the Catalog Entry

getMfpartnumber

public java.lang.String getMfpartnumber()
Get the manufacturer part number of the Catalog Entry

getName

public java.lang.String getName()
Get name of the Catalog Entry description

getOnauction

public java.lang.Integer getOnauction()
Get the value of the Catentry Entry if it is on auction

getOnspecial

public java.lang.Integer getOnspecial()
Get the value of the Catentry Entry if it is on special

getPartnumber

public java.lang.String getPartnumber()
Get the part number of the Catalog Entry

getProductId

public java.lang.Long getProductId()
Get the Catalog Entry Id of the product

getPublished

public java.lang.Integer getPublished()
Get published of the Catalog Entry description

getSalesTax

public java.util.Hashtable getSalesTax()
Get the SalesTax information

getShippingMode

public java.util.Hashtable getShippingMode()
Get the Shipping Category information

getShippingTax

public java.util.Hashtable getShippingTax()
Get the Shipping Tax information

getShortDescription

public java.lang.String getShortDescription()
Get short description of the Catalog Entry description

getStoreId

public java.lang.String getStoreId()
Get the Store Id

getThumbnail

public java.lang.String getThumbnail()
Get thumbnail image of the Catalog Entry description

getXMLdetail

public java.lang.String getXMLdetail()
Get XML detail of the Catalog Entry description

hasAttribute

public static boolean hasAttribute(java.lang.Long nProductId)
checks if the product has attributes defined.

hasAttribute

public static boolean hasAttribute(java.lang.Long nProductId,
                                   java.lang.Integer nLanguageId)
checks if the product has attributes defined.

hasChildCatentry

public static boolean hasChildCatentry(java.lang.Long nProductId)
checks if the product has child SKUs defined.

isDuplicatedAttrValue

public static boolean isDuplicatedAttrValue(java.lang.Long nProductId,
                                            java.util.Hashtable hashtableAttributeValues)
checks if the attribute values have been assigned to a SKU.

isExistingSKUCode

public static boolean isExistingSKUCode(java.lang.String strSKUCode,
                                        java.lang.Long nMemberId)
checks if the SKU code has been assigned to a SKU.

refreshCalcCodeRegistry

public static void refreshCalcCodeRegistry()
refresh CalcCode Registry.

refreshRegistry

public static void refreshRegistry(java.lang.String strRegistryName)
refresh Registry.

reset

public void reset()
resets all instance variables to null.

setAttributeValues

public void setAttributeValues(java.util.Hashtable hashAttrValues)
sets attribute values to a catentry.

setAuxdescription1

public void setAuxdescription1(java.lang.String astrAuxDescription1)
Set additional description for the Catalog Entry Description

setAuxdescription2

public void setAuxdescription2(java.lang.String astrAuxDescription2)
Set additional description for the Catalog Entry Description

setAvailabilitydate

public void setAvailabilitydate(java.sql.Timestamp atmAvailabilitydate)
Set availability date for the Catalog Entry Description

setAvailable

public void setAvailable(java.lang.Integer anAvailable)
Set available for the Catalog Entry Description

setBuyable

public void setBuyable(java.lang.Integer anBuyable)
Set the catalog entry to buyable 0 - Non Buyable 1 - Buyable

setCatentryId

public void setCatentryId(java.lang.Long anCatentryId)
Set a Catalog Entry Id

setCatentryShipping

public void setCatentryShipping(java.util.Hashtable hashCatentryShipping)
sets Catentry shipping information.

setCatenttypeId

public void setCatenttypeId(java.lang.String astrCatenttypeId)
Set a Catalog Entry Type Id

setCatEntURL

public void setCatEntURL(java.lang.String astrCatEntURL)
Set a URL for the Catalog Entry

setCommandContext

public void setCommandContext(CommandContext cmdContext)
                       throws ECApplicationException
set CommandContext
Throws:
ECApplicationException

setDescLanguage

public void setDescLanguage(java.lang.Integer anDescLanguage)
                     throws ECException
Set language id of Catalog Entry Description
Throws:
ECException

setDiscount

public void setDiscount(java.util.Hashtable hashDiscount)
sets Discount information.

setField1

public void setField1(java.lang.Integer anField1)
Set Field1 of the Catalog Entry

setField2

public void setField2(java.lang.Integer anField2)
Set Field2 of the Catalog Entry

setField3

public void setField3(java.math.BigDecimal adField3)
Set Field3 of the Catalog Entry

setField4

public void setField4(java.lang.String astrField4)
Set Field4 of the Catalog Entry

setField5

public void setField5(java.lang.String astrField5)
Set Field5 of the Catalog Entry

setFullimage

public void setFullimage(java.lang.String astrFullimage)
Set path of the full image of Catalog Entry Description

setLastupdate

public void setLastupdate(java.sql.Timestamp atmLastupdate)
Sets the date and time when the Catalog Entry was updated

setEndDate

public void setEndDate(java.sql.Timestamp atmEndDate)
Sets the end date when the Catalog Entry was updated

setStartDate

public void setStartDate(java.sql.Timestamp atmStartDate)
Sets the start date when the Catalog Entry was updated

setLongdescription

public void setLongdescription(java.lang.String astrLongDescription)
Set long description of Catalog Entry Description

setMarkfordelete

public void setMarkfordelete(java.lang.Integer anMarkfordelete)
Set markfordelete of the Catalog Entry

setMemberId

public void setMemberId(java.lang.Long anMemberId)
Set owner of the Catalog Entry

setMfname

public void setMfname(java.lang.String astrMfname)
Set manufacturer name of the Catalog Entry

setMfpartnumber

public void setMfpartnumber(java.lang.String astrMfpartnumber)
Set the part number of the Catalog Entry used by the manufacturer

setName

public void setName(java.lang.String astrName)
Set language dependent name of Catalog Entry Description

setOnauction

public void setOnauction(java.lang.Integer anOnauction)
Set if the Catalog Entry is on auction 0 - Not on auction 1 - on auction

setOnspecial

public void setOnspecial(java.lang.Integer anOnspecial)
Set if the Catalog Entry is on special 0 - Not on special 1 - on special

setPartnumber

public void setPartnumber(java.lang.String astrPartnumber)
Set the partnumber of the Catalog Entry

setProductId

public void setProductId(java.lang.Long nProductId)
set Product Id.

setPublished

public void setPublished(java.lang.Integer anPublished)
Set published of Catalog Entry Description

setSalesTax

public void setSalesTax(java.util.Hashtable hashSalesTax)
sets Sales Tax information.

setShippingMode

public void setShippingMode(java.util.Hashtable hashShippingMode)
sets Shipping category information.

setShippingTax

public void setShippingTax(java.util.Hashtable hashShippingTax)
sets Shipping Tax information.

setShortdescription

public void setShortdescription(java.lang.String astrShortDescription)
Set short description of Catalog Entry Description

setStoreId

public void setStoreId(java.lang.String astrStoreId)
sets Store Id.

setThumbnail

public void setThumbnail(java.lang.String astrThumbnail)
Set path to a thumbnail image of Catalog Entry Description

setXMLdetail

public void setXMLdetail(java.lang.String astrXMLdetail)
Set XML detail of Catalog Entry Description

str2YN

protected java.lang.String str2YN(java.lang.String str)
translate true/false to Y/N.

getCatalogGroupId

public java.lang.Long getCatalogGroupId()
gets Catalog Group Id.

getCatalogId

public java.lang.Long getCatalogId()
sets Catalog Id.

setCatalogGroupId

public void setCatalogGroupId(java.lang.Long nCatalogGroupId)
sets Catalog Group Id.

setCatalogId

public void setCatalogId(java.lang.Long nCatalogId)
sets Catalog Id.

findAttributeValueId

public static java.lang.Long findAttributeValueId(java.lang.Long nAttributeId,
                                                  java.lang.Integer nLanguageId,
                                                  java.lang.String strAttributeValue)
find attribute value ID from attributeId, languageId, and value. Creation date: (11/14/2001 2:10:26 PM)
Parameters:
nAttributeId - java.lang.Long
nLanguageId - java.lang.Integer
strAttributeValue - java.lang.String
Returns:
java.lang.Long

getStoreDefaultLanguage

public static java.lang.Integer getStoreDefaultLanguage(java.lang.Integer nStoreId)
get the default Language of a store.

flushEJB

public static void flushEJB()
flush EJB.

hasPrices

public static boolean hasPrices(java.lang.Long nCatentryId)
checks if the catentry has prices defined.

hasPrices

public static boolean hasPrices(java.lang.Long nCatentryId,
                                java.lang.Integer nStoreId)
checks if the catentry has prices defined.

Feedback