java.lang.Objectcom.ibm.ivj.ejb.runtime.AbstractSessionAccessBean
com.ibm.commerce.tools.optools.order.helpers.OrderSearchAccessBean
Constructor Summary | |
OrderSearchAccessBean() Default constructor. |
|
OrderSearchAccessBean(javax.ejb.EJBObject o) This method was generated by the VisualAge for Java Access Bean SmartGuide. |
Method Summary | |
protected java.lang.String | defaultJNDIName() This method was generated by the VisualAge for Java Access Bean SmartGuide. |
com.ibm.commerce.tools.optools.common.helpers.DynamicListData | findOrderAccountIDsForCustomer(java.lang.String customer) This methods retrieves all account ids that the user or the user's organization holds. |
com.ibm.commerce.tools.optools.common.helpers.DynamicListData | findOrdersForStore(java.lang.Long storeId, java.lang.String orderBy, java.lang.String orderId, java.lang.String userLogin, java.lang.String userId, java.lang.String orderStatus, java.lang.String accountId, java.lang.Integer start, java.lang.Integer maxLength) This methods retrieves the IDs of the orders in the store specified by the storeId. |
com.ibm.commerce.tools.optools.common.helpers.DynamicListData | findOrdersForStoreAdvanced(java.lang.Long storeId, java.lang.String orderBy, java.lang.String orderId, java.lang.String userLogin, java.lang.String userLogonSearchType, java.lang.String userId, java.lang.String orderStatus, java.lang.String orgId, java.lang.Integer start, java.lang.Integer maxLength, java.sql.Timestamp orderDateSD, java.sql.Timestamp orderDateED, java.sql.Timestamp lastUpdateSD, java.sql.Timestamp lastUpdateED, java.lang.String addr_firstName, java.lang.String addr_FNSearchType, java.lang.String addr_lastName, java.lang.String addr_LNSearchType, java.lang.String addr_address1, java.lang.String addr_A1SearchType, java.lang.String addr_zipcode, java.lang.String addr_ZCSearchType, java.lang.String addr_email1, java.lang.String addr_E1SearchType, java.lang.String addr_phone1, java.lang.String numToFetch) Finds the orders that match the search criterias provided one or more of the following parameters: orderId userLogin userId orgId orderStatus orderDateSD orderDateED lastUpdateSD lastUpdateED addr_firstName addr_lastName addr_address1 addr_zipcode addr_email1 addr_phone1 |
protected void | instantiateEJB() This method was generated by the VisualAge for Java Access Bean SmartGuide. |
Methods inherited from class java.lang.Object |
clone, equals, finalize, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait |
Constructor Detail |
public OrderSearchAccessBean()
Default constructor. Maps to findByPrimaryKey.
public OrderSearchAccessBean(javax.ejb.EJBObject o) throws java.rmi.RemoteException
Method Detail |
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 findOrderAccountIDsForCustomer(java.lang.String customer) throws javax.naming.NamingException, java.sql.SQLException, java.rmi.RemoteException, javax.ejb.ObjectNotFoundException, javax.ejb.CreateException
This methods retrieves all account ids that the user or the user's organization holds.
SELECT TRADING_ID FROM PARTICIPNT WHERE MEMBER_ID = ? AND PARTROLE_ID = 5 SELECT TRADING_ID FROM PARTICIPNT, MBRREL WHERE PARTROLE_ID = 5 AND DESCENDANT_ID = ? AND ANCESTOR_ID = MEMBER_ID AND SEQUENCE IN (SELECT MAX(SEQUENCE) FROM MBRREL WHERE DESCENDANT_ID = ? AND ANCESTOR_ID NOT IN (-2001))
public com.ibm.commerce.tools.optools.common.helpers.DynamicListData findOrdersForStore(java.lang.Long storeId, java.lang.String orderBy, java.lang.String orderId, java.lang.String userLogin, java.lang.String userId, java.lang.String orderStatus, java.lang.String accountId, java.lang.Integer start, java.lang.Integer maxLength) throws javax.naming.NamingException, java.sql.SQLException, java.rmi.RemoteException, javax.ejb.ObjectNotFoundException, javax.ejb.CreateException
This methods retrieves the IDs of the orders in the store specified by the storeId. Optional parameters can be passed in to narrow the search. A start and maxLength are required to limit the number of the order IDs to be returned.
SELECT ORDERS_ID, LOGONID, TIMEPLACED, LASTUPDATE, TOTALPRODUCT+TOTALADJUSTMENT+TOTALSHIPPING+TOTALTAX+TOTALTAXSHIPPING AS TOTAL FROM ORDERS LEFT OUTER JOIN USERREG ON MEMBER_ID=USERS_ID
WHERE STOREENT_ID=? AND ORDERS_ID IN (?) AND ORDERS.STATUS IN (?) AND ORDERS.MEMBER_ID IN (?) AND (LOGONID LIKE ? ESCAPE '\\') AND ORDERS.ORGENTITY_ID IN (SELECT DESCENDANT_ID FROM MBRREL, ORGENTITY WHERE MBRREL.DESCENDANT_ID = ORGENTITY.ORGENTITY_ID AND ((ANCESTOR_ID = ? AND ORGENTITY.ORGENTITYTYPE = 'OU') OR ORGENTITY.ORGENTITY_ID = ?)) ORDER BY ?
The possible values for orderStatus are:
The possible values for orderBy are:
public com.ibm.commerce.tools.optools.common.helpers.DynamicListData findOrdersForStoreAdvanced(java.lang.Long storeId, java.lang.String orderBy, java.lang.String orderId, java.lang.String userLogin, java.lang.String userLogonSearchType, java.lang.String userId, java.lang.String orderStatus, java.lang.String orgId, java.lang.Integer start, java.lang.Integer maxLength, java.sql.Timestamp orderDateSD, java.sql.Timestamp orderDateED, java.sql.Timestamp lastUpdateSD, java.sql.Timestamp lastUpdateED, java.lang.String addr_firstName, java.lang.String addr_FNSearchType, java.lang.String addr_lastName, java.lang.String addr_LNSearchType, java.lang.String addr_address1, java.lang.String addr_A1SearchType, java.lang.String addr_zipcode, java.lang.String addr_ZCSearchType, java.lang.String addr_email1, java.lang.String addr_E1SearchType, java.lang.String addr_phone1, java.lang.String numToFetch) throws javax.naming.NamingException, javax.ejb.ObjectNotFoundException, javax.ejb.CreateException, java.rmi.RemoteException, java.sql.SQLException
(C) Copyright IBM Corporation 1996, 2005. All Rights Reserved.