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 itmLastupdate
           
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.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
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 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 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

idField3

protected java.math.BigDecimal idField3

ihashAttrValues

protected java.util.Hashtable ihashAttrValues

ihashCatentryShipping

protected java.util.Hashtable ihashCatentryShipping

ihashDiscount

protected java.util.Hashtable ihashDiscount

ihashSalesTax

protected java.util.Hashtable ihashSalesTax

ihashShippingMode

protected java.util.Hashtable ihashShippingMode

ihashShippingTax

protected java.util.Hashtable ihashShippingTax

inAvailable

protected java.lang.Integer inAvailable

inBuyable

protected java.lang.Integer inBuyable

inCatalogGroupId

protected java.lang.Long inCatalogGroupId

inCatalogId

protected java.lang.Long inCatalogId

inCatentryId

protected java.lang.Long inCatentryId

inDescLanguage

protected java.lang.Integer inDescLanguage

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

inProductId

protected java.lang.Long inProductId

inPublished

protected java.lang.Integer inPublished

istrAuxDescription1

protected java.lang.String istrAuxDescription1

istrAuxDescription2

protected java.lang.String istrAuxDescription2

istrCatenttypeId

protected java.lang.String istrCatenttypeId

istrCatEntURL

protected java.lang.String istrCatEntURL

istrField4

protected java.lang.String istrField4

istrField5

protected java.lang.String istrField5

istrFullimage

protected java.lang.String istrFullimage

istrLongDescription

protected java.lang.String istrLongDescription

istrMfname

protected java.lang.String istrMfname

istrMfpartnumber

protected java.lang.String istrMfpartnumber

istrName

protected java.lang.String istrName

istrPartnumber

protected java.lang.String istrPartnumber

istrShortDescription

protected java.lang.String istrShortDescription

istrStoreId

protected java.lang.String istrStoreId

istrThumbnail

protected java.lang.String istrThumbnail

istrXMLdetail

protected java.lang.String istrXMLdetail

itmAvailabilitydate

protected java.sql.Timestamp itmAvailabilitydate

itmLastupdate

protected java.sql.Timestamp itmLastupdate

m_cmdContext

protected CommandContext m_cmdContext
Constructor Detail

CatalogEntryCreateUpdateHelper

public CatalogEntryCreateUpdateHelper()
Method Detail

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

findSKUByAttrValue

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

flushEJB

public static void flushEJB()
flush EJB.

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

getCatalogGroupId

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

getCatalogId

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

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

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

getStoreDefaultLanguage

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

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.

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.

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

setCatalogGroupId

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

setCatalogId

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

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

setDescLanguage

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

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

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.