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

      Fields 
      Modifier and Type Field and Description
      static java.lang.String CLASS_NAME 
    • Method Summary

      All Methods Static Methods Instance Methods Concrete Methods 
      Modifier and Type Method and Description
      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.sql.Timestamp getAvailabilityDate()
      Get the availability date of the Catalog Entry
      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.sql.Timestamp getDiscontinueDate()
      Get the discontinue date of the Catalog Entry
      java.util.Hashtable getDiscount()
      Get the Discount information
      java.sql.Timestamp getEndDate()
      Get the end date of the Catalog Entry
      java.sql.Timestamp getEndOfServiceDate()
      Get the endOfService 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 getLastOrderDate()
      Get the lastOrder date of the Catalog Entry
      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 setAvailabilityDate(java.sql.Timestamp atmAvailabilityDate)
      Sets the availability date when the Catalog Entry was updated
      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 setDiscontinueDate(java.sql.Timestamp atmDiscontinueDate)
      Sets the discontinue date when the Catalog Entry was updated
      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 setEndOfServiceDate(java.sql.Timestamp atmEndOfServiceDate)
      Sets the endOfService 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 setLastOrderDate(java.sql.Timestamp atmLastOrderDate)
      Sets the lastOrder date when the Catalog Entry was updated
      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
      • Methods inherited from class java.lang.Object

        equals, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait
    • 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
      • getAvailabilityDate

        public java.sql.Timestamp getAvailabilityDate()
        Get the availability date of the Catalog Entry
      • getLastOrderDate

        public java.sql.Timestamp getLastOrderDate()
        Get the lastOrder date of the Catalog Entry
      • getEndOfServiceDate

        public java.sql.Timestamp getEndOfServiceDate()
        Get the endOfService date of the Catalog Entry
      • getDiscontinueDate

        public java.sql.Timestamp getDiscontinueDate()
        Get the discontinue 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
      • 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
      • setAvailabilityDate

        public void setAvailabilityDate(java.sql.Timestamp atmAvailabilityDate)
        Sets the availability date when the Catalog Entry was updated
      • setLastOrderDate

        public void setLastOrderDate(java.sql.Timestamp atmLastOrderDate)
        Sets the lastOrder date when the Catalog Entry was updated
      • setEndOfServiceDate

        public void setEndOfServiceDate(java.sql.Timestamp atmEndOfServiceDate)
        Sets the endOfService date when the Catalog Entry was updated
      • setDiscontinueDate

        public void setDiscontinueDate(java.sql.Timestamp atmDiscontinueDate)
        Sets the discontinue 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
      • 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.