public class OfferAccessBean extends com.ibm.ivj.ejb.runtime.AbstractEntityAccessBean implements OfferAccessBeanData
Constructor and Description |
---|
OfferAccessBean()
Zero argument constructor used to initialize the access bean.
|
OfferAccessBean(javax.ejb.EJBObject o) |
OfferAccessBean(com.ibm.commerce.context.content.objects.EntityCreationData entityCreationData)
OfferAccessBean
|
OfferAccessBean(java.lang.Long catalogEntryId, java.lang.Double precedence, java.lang.Long containerId)
Creates an access bean with the specified attributes.
|
OfferAccessBean(java.lang.Long catalogEntryId, java.lang.Double precedence, java.lang.Long containerId, java.lang.Long aIdentifier)
Creates an access bean with the specified attributes.
|
Modifier and Type | Method and Description |
---|---|
void | commitCopyHelper() |
protected java.lang.String | defaultJNDIName() |
OfferAccessBean | findByCatalogEntryAndIdentifierAndTradingPosContainer(java.lang.Long aCatalogEntry, java.lang.Long aIdentifier, java.lang.Long aTradingPosContainerId)
Retrieves the offer for the catalog entry, aIdentifier, and trading position container.
|
java.util.Enumeration | findByCatalogEntryAndStore(java.lang.Long catalogEntryId, java.lang.Integer storeId)
Retrieves all offers for the catalog entry and store.
|
java.util.Enumeration | findByCatalogEntryAndTradingPositionContainer(java.lang.Long aCatalogEntry, java.lang.Long aTradingPostionContainerId)
Retrieves the offers for the catalog entry and trading position container.
|
java.util.Enumeration | findByCatalogEntryId(java.lang.Long catalogEntryId)
findByCatalogEntryId
|
java.util.Enumeration | findByItem(java.lang.Long itemNum)
Retrieves all offers for the catalog entry.
|
OfferAccessBean | findByTimestampAndStore(java.sql.Timestamp timestamp1, java.sql.Timestamp timestamp2, java.lang.Integer storeId) |
java.util.Enumeration | findByTradingPositionContainerId(java.lang.Long tradingPositionContainerId)
Retrieves all offers for the trading position container.
|
java.util.Enumeration | findEffectiveOffersByTimestampCatentriesOffersStoreAndPriceLists(boolean timestampFlag, java.sql.Timestamp timestamp, java.lang.Long[] catalogEntryIds, java.lang.Long[] offerIds, java.lang.Integer storeId, java.lang.Long[] priceListIds)
Retrieves all valid offers, for the store, for the item restricted by the specified input parameters.
|
java.util.Enumeration | findEffectiveOffersByTimestampCatentriesOffersStorePriceListsAndMemberGroups(boolean arg0, java.sql.Timestamp arg1, java.lang.Long[] arg2, java.lang.Long[] arg3, java.lang.Integer arg4, java.lang.Long[] arg5, java.lang.Long[] arg6) |
java.util.Enumeration | findEffectiveOffersByTimestampCatentriesPredicateOffersStoreAndPriceLists(boolean timestampFlag, java.sql.Timestamp timestamp, java.lang.Long[] catalogEntryIds, java.lang.Long[] offerIds, java.lang.Integer storeId, java.lang.Long[] priceListIds, java.lang.String exclusionPredicate, java.lang.Integer[] exclusionIds, java.lang.String inclusionPredicate, java.lang.Integer[] inclusionIds)
findEffectiveOffersByTimestampCatentriesPredicateOffersStoreAndPriceLists
|
java.util.Enumeration | findEffectiveOffersByTimestampCatentriesPredicateOffersStoreAndPriceLists(boolean arg0, java.sql.Timestamp arg1, java.lang.Long[] arg2, java.lang.Long[] arg3, java.lang.Integer arg4, java.lang.Long[] arg5, java.lang.String arg6, java.lang.String arg7) |
java.util.Enumeration | findEffectiveOffersByTimestampCatentryOffersStoreContractsAndMemberGroups(boolean arg0, java.sql.Timestamp arg1, java.lang.Long arg2, java.lang.Long[] arg3, java.lang.Integer arg4, java.lang.Long[] arg5, java.lang.Long[] arg6) |
java.lang.String | getCatalogEntryReferenceNumber() |
java.lang.Long | getCatalogEntryReferenceNumberInEJBType() |
java.lang.String | getEndDate() |
java.sql.Timestamp | getEndDateInEJBType() |
java.lang.String | getField1() |
java.lang.String | getField2() |
java.lang.String | getFlags() |
java.lang.Integer | getFlagsInEJBType() |
java.lang.String | getIdentifier() |
java.lang.Long | getIdentifierInEJBType() |
java.lang.String | getLastUpdate() |
java.sql.Timestamp | getLastUpdateInEJBType() |
java.lang.String | getMaximumQuantity() |
java.lang.Double | getMaximumQuantityInEJBType() |
java.lang.String | getMinimumQuantity() |
java.lang.Double | getMinimumQuantityInEJBType() |
java.lang.String | getOfferId() |
java.lang.Long | getOfferIdInEJBType() |
java.lang.String | getOID() |
java.lang.String | getPrecedence() |
java.lang.Double | getPrecedenceInEJBType() |
OfferPriceAccessBean | getPrice(java.lang.String arg1)
Returns the OfferPriceAccessBean associated with this offer for the specified currency.
|
OfferPriceAccessBean | getPrice(java.lang.String arg1, java.lang.String arg2)
Returns the OfferPriceAccessBean associated with this offer for the negotiated currency.
|
java.util.Vector | getPrices(java.lang.String arg1)
Returns a vector of OfferPriceAccessBean objects.
|
java.lang.String | getPublished() |
java.lang.Integer | getPublishedInEJBType() |
java.lang.String | getQuantityUnitId() |
java.lang.String | getStartDate() |
java.sql.Timestamp | getStartDateInEJBType() |
java.lang.String | getTradePosContainerId() |
java.lang.Long | getTradePosContainerIdInEJBType() |
protected void | instantiateEJB() |
protected boolean | instantiateEJBByPrimaryKey() |
void | refreshCopyHelper() |
void | setCatalogEntryReferenceNumber(java.lang.Long newValue) |
void | setCatalogEntryReferenceNumber(java.lang.String newValue) |
void | setEndDate(java.lang.String newValue) |
void | setEndDate(java.sql.Timestamp newValue) |
void | setField1(java.lang.String newValue) |
void | setField2(java.lang.String newValue) |
void | setFlags(java.lang.Integer newValue) |
void | setFlags(java.lang.String newValue) |
void | setIdentifier(java.lang.Long newValue) |
void | setIdentifier(java.lang.String newValue) |
void | setInitKey_offerId(java.lang.String newValue) |
void | setLastUpdate(java.lang.String newValue) |
void | setLastUpdate(java.sql.Timestamp newValue) |
void | setMaximumQuantity(java.lang.Double newValue) |
void | setMaximumQuantity(java.lang.String newValue) |
void | setMinimumQuantity(java.lang.Double newValue) |
void | setMinimumQuantity(java.lang.String newValue) |
void | setOID(java.lang.String newValue) |
void | setPrecedence(java.lang.Double newValue) |
void | setPrecedence(java.lang.String newValue) |
void | setPublished(java.lang.Integer newValue) |
void | setPublished(java.lang.String newValue) |
void | setQuantityUnitId(java.lang.String newValue) |
void | setStartDate(java.lang.String newValue) |
void | setStartDate(java.sql.Timestamp newValue) |
void | setTradePosContainerId(java.lang.Long newValue) |
void | setTradePosContainerId(java.lang.String newValue) |
public OfferAccessBean()
public OfferAccessBean(javax.ejb.EJBObject o) throws java.rmi.RemoteException
public OfferAccessBean(java.lang.Long catalogEntryId, java.lang.Double precedence, java.lang.Long containerId) throws javax.naming.NamingException, javax.ejb.CreateException, java.rmi.RemoteException, javax.ejb.FinderException
Creates an access bean with the specified attributes.
public OfferAccessBean(java.lang.Long catalogEntryId, java.lang.Double precedence, java.lang.Long containerId, java.lang.Long aIdentifier) throws javax.naming.NamingException, javax.ejb.CreateException, java.rmi.RemoteException, javax.ejb.FinderException
Creates an access bean with the specified attributes.
public OfferAccessBean(com.ibm.commerce.context.content.objects.EntityCreationData entityCreationData) throws javax.naming.NamingException, javax.ejb.FinderException, javax.ejb.CreateException, java.rmi.RemoteException
public OfferAccessBean findByCatalogEntryAndIdentifierAndTradingPosContainer(java.lang.Long aCatalogEntry, java.lang.Long aIdentifier, java.lang.Long aTradingPosContainerId) throws java.rmi.RemoteException, javax.ejb.FinderException, javax.naming.NamingException
Retrieves the offer for the catalog entry, aIdentifier, and trading position container.
The SQL query used to fetch all the required rows from the OFFER table is:
SELECT * FROM OFFER T1 WHERE T1.CATENTRY_ID = ? AND T1.IDENTIFIER = ? AND T1.TRADEPOSCN_ID = ?
public OfferAccessBean findByTimestampAndStore(java.sql.Timestamp timestamp1, java.sql.Timestamp timestamp2, java.lang.Integer storeId) throws java.rmi.RemoteException, javax.ejb.FinderException, javax.naming.NamingException
public java.util.Enumeration findByCatalogEntryAndStore(java.lang.Long catalogEntryId, java.lang.Integer storeId) throws java.rmi.RemoteException, javax.ejb.FinderException, javax.naming.NamingException
Retrieves all offers for the catalog entry and store.
The SQL query used to fetch all the required rows from the OFFER table is:
SELECT * FROM OFFER T1 WHERE (T1.CATENTRY_ID) = ? and (T1.TRADEPOSCN_ID IN (SELECT TRADEPOSCN_ID FROM TDPSCNCNTR, CONTRACT, STORECNTR WHERE CONTRACT.CONTRACT_ID = TDPSCNCNTR.CONTRACT_ID AND CONTRACT.CONTRACT_ID = STORECNTR.CONTRACT_ID AND STORECNTR.STORE_ID = ?))
public java.util.Enumeration findByCatalogEntryAndTradingPositionContainer(java.lang.Long aCatalogEntry, java.lang.Long aTradingPostionContainerId) throws java.rmi.RemoteException, javax.ejb.FinderException, javax.naming.NamingException
Retrieves the offers for the catalog entry and trading position container.
The SQL query used to fetch all the required rows from the OFFER table is:
SELECT * FROM OFFER T1 WHERE T1.CATENTRY_ID=? AND T1.TRADEPOSCN_ID = ? AND (T1.PUBLISHED = 1 OR T1.PUBLISHED IS NULL)
public java.util.Enumeration findByItem(java.lang.Long itemNum) throws java.rmi.RemoteException, javax.ejb.FinderException, javax.naming.NamingException
Retrieves all offers for the catalog entry.
The SQL query used to fetch all the required rows from the OFFER table is:
SELECT * FROM OFFER T1 WHERE (T1.CATENTRY_ID = ?) AND (T1.PUBLISHED = 1 OR T1.PUBLISHED IS NULL)
public java.util.Enumeration findByTradingPositionContainerId(java.lang.Long tradingPositionContainerId) throws java.rmi.RemoteException, javax.ejb.FinderException, javax.naming.NamingException
Retrieves all offers for the trading position container.
The SQL query used to fetch all the required rows from the OFFER table is:
SELECT * FROM OFFER T1 WHERE (T1.TRADEPOSCN_ID = ?)
public java.util.Enumeration findEffectiveOffersByTimestampCatentriesOffersStoreAndPriceLists(boolean timestampFlag, java.sql.Timestamp timestamp, java.lang.Long[] catalogEntryIds, java.lang.Long[] offerIds, java.lang.Integer storeId, java.lang.Long[] priceListIds) throws java.rmi.RemoteException, javax.ejb.FinderException, javax.naming.NamingException
Retrieves all valid offers, for the store, for the item restricted by the specified input parameters.
The SQL query used to fetch all the required rows from the OFFER table is:
SELECT * FROM OFFER T1 WHERE " (T1.startdate < " + (timestampFlag ? "?" : com.ibm.commerce.ejb.helpers.TimestampHelper.getSQLCurrentTimestamp()) + " or T1.startdate is null) and" + " (T1.enddate > " + (timestampFlag ? "?" : com.ibm.commerce.ejb.helpers.TimestampHelper.getSQLCurrentTimestamp()) + " or T1.enddate is null) and" + " (T1.published = 1) and" + (catentryIds == null ? "" : " (T1.catentry_id " + getInPredicate(catentryIds) + ") and") + (offerIds == null ? "" : " (T1.offer_id " + getInPredicate(offerIds) + ") and") + " T1.tradeposcn_id in (" + " select tradeposcn.tradeposcn_id from tradeposcn where" + " ((0 = 0)" + (priceListIds == null ? ")" : " and (tradeposcn_id " + getInPredicate(priceListIds) + ")))") + " order by catentry_id, tradeposcn_id, precedence desc"
public java.util.Enumeration findEffectiveOffersByTimestampCatentriesOffersStorePriceListsAndMemberGroups(boolean arg0, java.sql.Timestamp arg1, java.lang.Long[] arg2, java.lang.Long[] arg3, java.lang.Integer arg4, java.lang.Long[] arg5, java.lang.Long[] arg6) throws java.rmi.RemoteException, javax.ejb.FinderException, javax.naming.NamingException
public java.util.Enumeration findEffectiveOffersByTimestampCatentriesPredicateOffersStoreAndPriceLists(boolean arg0, java.sql.Timestamp arg1, java.lang.Long[] arg2, java.lang.Long[] arg3, java.lang.Integer arg4, java.lang.Long[] arg5, java.lang.String arg6, java.lang.String arg7) throws java.rmi.RemoteException, javax.ejb.FinderException, javax.naming.NamingException
public java.util.Enumeration findEffectiveOffersByTimestampCatentryOffersStoreContractsAndMemberGroups(boolean arg0, java.sql.Timestamp arg1, java.lang.Long arg2, java.lang.Long[] arg3, java.lang.Integer arg4, java.lang.Long[] arg5, java.lang.Long[] arg6) throws java.rmi.RemoteException, javax.ejb.FinderException, javax.naming.NamingException
public void setInitKey_offerId(java.lang.String newValue)
protected java.lang.String defaultJNDIName()
protected void instantiateEJB() throws java.rmi.RemoteException, javax.ejb.FinderException, javax.naming.NamingException
protected boolean instantiateEJBByPrimaryKey() throws java.rmi.RemoteException, javax.ejb.CreateException, javax.naming.NamingException
public void commitCopyHelper() throws java.rmi.RemoteException, javax.ejb.CreateException, javax.ejb.FinderException, javax.naming.NamingException
public void refreshCopyHelper() throws java.rmi.RemoteException, javax.ejb.CreateException, javax.ejb.FinderException, javax.naming.NamingException
public java.lang.String getLastUpdate() throws java.rmi.RemoteException, javax.ejb.CreateException, javax.ejb.FinderException, javax.naming.NamingException
public java.sql.Timestamp getLastUpdateInEJBType() throws java.rmi.RemoteException, javax.ejb.CreateException, javax.ejb.FinderException, javax.naming.NamingException
public void setLastUpdate(java.lang.String newValue)
public void setLastUpdate(java.sql.Timestamp newValue)
public java.lang.String getPublished() throws java.rmi.RemoteException, javax.ejb.CreateException, javax.ejb.FinderException, javax.naming.NamingException
public java.lang.Integer getPublishedInEJBType() throws java.rmi.RemoteException, javax.ejb.CreateException, javax.ejb.FinderException, javax.naming.NamingException
public void setPublished(java.lang.String newValue)
public void setPublished(java.lang.Integer newValue)
public java.lang.String getOID() throws java.rmi.RemoteException, javax.ejb.CreateException, javax.ejb.FinderException, javax.naming.NamingException
public void setOID(java.lang.String newValue)
public java.lang.String getIdentifier() throws java.rmi.RemoteException, javax.ejb.CreateException, javax.ejb.FinderException, javax.naming.NamingException
public java.lang.Long getIdentifierInEJBType() throws java.rmi.RemoteException, javax.ejb.CreateException, javax.ejb.FinderException, javax.naming.NamingException
public void setIdentifier(java.lang.String newValue)
public void setIdentifier(java.lang.Long newValue)
public java.lang.String getStartDate() throws java.rmi.RemoteException, javax.ejb.CreateException, javax.ejb.FinderException, javax.naming.NamingException
public java.sql.Timestamp getStartDateInEJBType() throws java.rmi.RemoteException, javax.ejb.CreateException, javax.ejb.FinderException, javax.naming.NamingException
public void setStartDate(java.lang.String newValue)
public void setStartDate(java.sql.Timestamp newValue)
public java.lang.String getOfferId() throws java.rmi.RemoteException, javax.ejb.CreateException, javax.ejb.FinderException, javax.naming.NamingException
public java.lang.Long getOfferIdInEJBType() throws java.rmi.RemoteException, javax.ejb.CreateException, javax.ejb.FinderException, javax.naming.NamingException
public java.lang.String getCatalogEntryReferenceNumber() throws java.rmi.RemoteException, javax.ejb.CreateException, javax.ejb.FinderException, javax.naming.NamingException
public java.lang.Long getCatalogEntryReferenceNumberInEJBType() throws java.rmi.RemoteException, javax.ejb.CreateException, javax.ejb.FinderException, javax.naming.NamingException
public void setCatalogEntryReferenceNumber(java.lang.String newValue)
public void setCatalogEntryReferenceNumber(java.lang.Long newValue)
public java.lang.String getMinimumQuantity() throws java.rmi.RemoteException, javax.ejb.CreateException, javax.ejb.FinderException, javax.naming.NamingException
public java.lang.Double getMinimumQuantityInEJBType() throws java.rmi.RemoteException, javax.ejb.CreateException, javax.ejb.FinderException, javax.naming.NamingException
public void setMinimumQuantity(java.lang.String newValue)
public void setMinimumQuantity(java.lang.Double newValue)
public java.lang.String getField2() throws java.rmi.RemoteException, javax.ejb.CreateException, javax.ejb.FinderException, javax.naming.NamingException
public void setField2(java.lang.String newValue)
public java.lang.String getField1() throws java.rmi.RemoteException, javax.ejb.CreateException, javax.ejb.FinderException, javax.naming.NamingException
public void setField1(java.lang.String newValue)
public java.lang.String getPrecedence() throws java.rmi.RemoteException, javax.ejb.CreateException, javax.ejb.FinderException, javax.naming.NamingException
public java.lang.Double getPrecedenceInEJBType() throws java.rmi.RemoteException, javax.ejb.CreateException, javax.ejb.FinderException, javax.naming.NamingException
public void setPrecedence(java.lang.String newValue)
public void setPrecedence(java.lang.Double newValue)
public java.lang.String getFlags() throws java.rmi.RemoteException, javax.ejb.CreateException, javax.ejb.FinderException, javax.naming.NamingException
public java.lang.Integer getFlagsInEJBType() throws java.rmi.RemoteException, javax.ejb.CreateException, javax.ejb.FinderException, javax.naming.NamingException
public void setFlags(java.lang.String newValue)
public void setFlags(java.lang.Integer newValue)
public java.lang.String getQuantityUnitId() throws java.rmi.RemoteException, javax.ejb.CreateException, javax.ejb.FinderException, javax.naming.NamingException
public void setQuantityUnitId(java.lang.String newValue)
public java.lang.String getEndDate() throws java.rmi.RemoteException, javax.ejb.CreateException, javax.ejb.FinderException, javax.naming.NamingException
public java.sql.Timestamp getEndDateInEJBType() throws java.rmi.RemoteException, javax.ejb.CreateException, javax.ejb.FinderException, javax.naming.NamingException
public void setEndDate(java.lang.String newValue)
public void setEndDate(java.sql.Timestamp newValue)
public java.lang.String getMaximumQuantity() throws java.rmi.RemoteException, javax.ejb.CreateException, javax.ejb.FinderException, javax.naming.NamingException
public java.lang.Double getMaximumQuantityInEJBType() throws java.rmi.RemoteException, javax.ejb.CreateException, javax.ejb.FinderException, javax.naming.NamingException
public void setMaximumQuantity(java.lang.String newValue)
public void setMaximumQuantity(java.lang.Double newValue)
public java.lang.String getTradePosContainerId() throws java.rmi.RemoteException, javax.ejb.CreateException, javax.ejb.FinderException, javax.naming.NamingException
public java.lang.Long getTradePosContainerIdInEJBType() throws java.rmi.RemoteException, javax.ejb.CreateException, javax.ejb.FinderException, javax.naming.NamingException
public void setTradePosContainerId(java.lang.String newValue)
public void setTradePosContainerId(java.lang.Long newValue)
public OfferPriceAccessBean getPrice(java.lang.String arg1) throws javax.naming.NamingException, javax.ejb.CreateException, javax.ejb.FinderException, java.rmi.RemoteException
Returns the OfferPriceAccessBean associated with this offer for the specified currency.
public OfferPriceAccessBean getPrice(java.lang.String arg1, java.lang.String arg2) throws javax.naming.NamingException, javax.ejb.CreateException, javax.ejb.FinderException, java.rmi.RemoteException
Returns the OfferPriceAccessBean associated with this offer for the negotiated currency. If there is no price available for the negotiated currency, returns the OfferAccessBean for the default currency.
public java.util.Vector getPrices(java.lang.String arg1) throws javax.naming.NamingException, javax.ejb.CreateException, javax.ejb.FinderException, java.rmi.RemoteException
Returns a vector of OfferPriceAccessBean objects. If there is an OfferPrice for this offer and for the currency, returns a one-element vector that only contains this OfferPriceAccessBean. Otherwise returns a vector with all the OfferPriceAccessBean objects associated with this offer.
public java.util.Enumeration findEffectiveOffersByTimestampCatentriesPredicateOffersStoreAndPriceLists(boolean timestampFlag, java.sql.Timestamp timestamp, java.lang.Long[] catalogEntryIds, java.lang.Long[] offerIds, java.lang.Integer storeId, java.lang.Long[] priceListIds, java.lang.String exclusionPredicate, java.lang.Integer[] exclusionIds, java.lang.String inclusionPredicate, java.lang.Integer[] inclusionIds) throws javax.naming.NamingException, javax.ejb.FinderException, java.rmi.RemoteException
public java.util.Enumeration findByCatalogEntryId(java.lang.Long catalogEntryId) throws javax.naming.NamingException, javax.ejb.FinderException, java.rmi.RemoteException