public class OrderProductSearchAccessBean
extends com.ibm.ivj.ejb.runtime.AbstractSessionAccessBean
Constructor and Description |
---|
OrderProductSearchAccessBean()
Default constructor.
|
OrderProductSearchAccessBean(javax.ejb.EJBObject o) |
Modifier and Type | Method and Description |
---|---|
protected java.lang.String | defaultJNDIName() |
com.ibm.commerce.tools.optools.common.helpers.DynamicListData | findByTypeSkuNameDesc(java.lang.String types, java.lang.String SKULike, java.lang.String nameLike, java.lang.String descLike, java.lang.String searchSkuOption, java.lang.String searchNameOption, java.lang.String searchDescOption, java.lang.String maxMatches, java.lang.String orderBy, java.lang.String langId, java.lang.String storeId)
Used by LI 413 of starlight, performs a fuzzy search on Types, SKU, name, and description.
|
com.ibm.commerce.tools.optools.common.helpers.DynamicListData | findItemBySkuNameDesc(java.lang.String SKULike, java.lang.String nameLike, java.lang.String descLike, java.lang.String orderBy, java.lang.String langId, java.lang.String storeId)
Searches the catalog and return a list of products that are currently available for sale depending on the criteria specified.
|
com.ibm.commerce.tools.optools.common.helpers.DynamicListData | findItemBySkuNameDesc(java.lang.String SKULike, java.lang.String nameLike, java.lang.String descLike, java.lang.String orderBy, java.lang.String langId, java.util.Vector storeIds)
Performs a fuzzy search on SKU, name, and description.
|
com.ibm.commerce.tools.optools.common.helpers.DynamicListData | findItemBySkuNameDescWithMax(java.lang.String SKULike, java.lang.String nameLike, java.lang.String descLike, java.lang.String orderBy, java.lang.String langId, java.lang.String storeId, java.lang.String maxMatches)
Searches the catalog and return a list of products that are currently available for sale depending on the criteria specified.
|
com.ibm.commerce.tools.optools.common.helpers.DynamicListData | findItemBySkuNameDescWithMax(java.lang.String SKULike, java.lang.String nameLike, java.lang.String descLike, java.lang.String orderBy, java.lang.String langId, java.util.Vector storeIds, java.lang.String maxMatches)
Performs a fuzzy search on SKU, name, and description.
|
protected void | instantiateEJB() |
public OrderProductSearchAccessBean()
Default constructor.
public OrderProductSearchAccessBean(javax.ejb.EJBObject o) throws java.rmi.RemoteException
protected java.lang.String defaultJNDIName()
protected void instantiateEJB() throws javax.ejb.CreateException, java.rmi.RemoteException, javax.naming.NamingException
public com.ibm.commerce.tools.optools.common.helpers.DynamicListData findItemBySkuNameDesc(java.lang.String SKULike, java.lang.String nameLike, java.lang.String descLike, java.lang.String orderBy, java.lang.String langId, java.lang.String storeId) throws javax.naming.NamingException, java.sql.SQLException, javax.ejb.CreateException, java.rmi.RemoteException, javax.ejb.FinderException
Searches the catalog and return a list of products that are currently available for sale depending on the criteria specified.
The SQL query executed depends on the input parameters. A sample query where all input parameters are given:
SELECT CATENTRY.CATENTRY_ID, CATENTRY.PARTNUMBER, CATENTDESC.NAME, CATENTDESC.SHORTDESCRIPTION FROM CATENTRY, CATENTDESC, STORECENT WHERE (CATENTRY.BUYABLE IS NULL OR CATENTRY.BUYABLE <> 0) AND (CATENTRY.MARKFORDELETE <> 1) AND (CATENTRY.PUBLISHED = 1) AND (CATENTRY.CATENTRY_ID = CATENTDESC.CATENTRY_ID) AND (CATENTRY.CATENTRY_ID = STORECENT.CATENTRY_ID) AND (CATENTRY.CATENTRYTYPE_ID = 'ItemBean')
AND (STORECENT.STOREENT_ID = ? OR STORECENT.STOREENT_ID = ?) AND (CATENTRY.PARTNUMBER LIKE ? ESCAPE '\\') AND (CATENTRY.LANGUAGUE_ID = ?) AND (UPPER(CATENTDESC.NAME LIKE ? ESCAPE '\\')) AND (UPPER(CATENTDESC.SHORTDESCRIPTION LIKE ? ESCAPE '\\')) ORDER BY CATENTRY.PARTNUMBER
The possible values for orderBy are:
public com.ibm.commerce.tools.optools.common.helpers.DynamicListData findItemBySkuNameDesc(java.lang.String SKULike, java.lang.String nameLike, java.lang.String descLike, java.lang.String orderBy, java.lang.String langId, java.util.Vector storeIds) throws javax.naming.NamingException, javax.ejb.FinderException, javax.ejb.CreateException, java.rmi.RemoteException, java.sql.SQLException
public com.ibm.commerce.tools.optools.common.helpers.DynamicListData findItemBySkuNameDescWithMax(java.lang.String SKULike, java.lang.String nameLike, java.lang.String descLike, java.lang.String orderBy, java.lang.String langId, java.util.Vector storeIds, java.lang.String maxMatches) throws javax.naming.NamingException, javax.ejb.FinderException, javax.ejb.CreateException, java.rmi.RemoteException, java.sql.SQLException
public com.ibm.commerce.tools.optools.common.helpers.DynamicListData findItemBySkuNameDescWithMax(java.lang.String SKULike, java.lang.String nameLike, java.lang.String descLike, java.lang.String orderBy, java.lang.String langId, java.lang.String storeId, java.lang.String maxMatches) throws javax.naming.NamingException, javax.ejb.FinderException, javax.ejb.CreateException, java.rmi.RemoteException, java.sql.SQLException
Searches the catalog and return a list of products that are currently available for sale depending on the criteria specified.
The SQL query executed depends on the input parameters. A sample query where all input parameters are given:
SELECT CATENTRY.CATENTRY_ID, CATENTRY.PARTNUMBER, CATENTDESC.NAME, CATENTDESC.SHORTDESCRIPTION FROM CATENTRY, CATENTDESC, STORECENT WHERE (CATENTRY.BUYABLE IS NULL OR CATENTRY.BUYABLE <> 0) AND (CATENTRY.MARKFORDELETE <> 1) AND (CATENTRY.PUBLISHED = 1) AND (CATENTRY.CATENTRY_ID = CATENTDESC.CATENTRY_ID) AND (CATENTRY.CATENTRY_ID = STORECENT.CATENTRY_ID) AND (CATENTRY.CATENTRYTYPE_ID = 'ItemBean')
AND (STORECENT.STOREENT_ID = ? OR STORECENT.STOREENT_ID = ?) AND (CATENTRY.PARTNUMBER LIKE ? ESCAPE '\\') AND (CATENTRY.LANGUAGUE_ID = ?) AND (UPPER(CATENTDESC.NAME LIKE ? ESCAPE '\\')) AND (UPPER(CATENTDESC.SHORTDESCRIPTION LIKE ? ESCAPE '\\')) FETCH FIRST n ROWS ONLY ORDER BY CATENTRY.PARTNUMBER
The possible values for orderBy are:
public com.ibm.commerce.tools.optools.common.helpers.DynamicListData findByTypeSkuNameDesc(java.lang.String types, java.lang.String SKULike, java.lang.String nameLike, java.lang.String descLike, java.lang.String searchSkuOption, java.lang.String searchNameOption, java.lang.String searchDescOption, java.lang.String maxMatches, java.lang.String orderBy, java.lang.String langId, java.lang.String storeId) throws javax.naming.NamingException, javax.ejb.FinderException, javax.ejb.CreateException, java.rmi.RemoteException, java.sql.SQLException