public class OrderSearchAccessBean
extends com.ibm.ivj.ejb.runtime.AbstractSessionAccessBean
Constructor and Description |
---|
OrderSearchAccessBean()
Default constructor.
|
OrderSearchAccessBean(javax.ejb.EJBObject o)
OrderSearchAccessBean
|
Modifier and Type | Method and Description |
---|---|
java.lang.String | defaultJNDIName()
defaultJNDIName
|
java.util.Vector | executeCustomizableOrderSearch(ECQuery aQuery)
Used to execute a customizable order search.
|
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.
|
java.util.List | findOrderCommentsByOrderAndOrdVersion(java.lang.Long orderId, boolean isCSROrderComment, java.lang.Short orderVersion, java.lang.String orderBy, boolean isAsc, java.lang.Integer startIndex, java.lang.Integer maxLength)
findOrderCommentsByOrderAndOrdVersion
|
java.util.List | findOrderHistoriesByOrderId(java.lang.Long orderId, java.lang.String orderBy, boolean isAsc, java.lang.Integer startIndex, java.lang.Integer maxLength)
findOrderHistoriesByOrderId
|
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 criteria 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
|
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, java.lang.String orderType, java.lang.String orderBlocked, java.lang.String blockReasonCode, java.lang.String addr_shipaddress1, java.lang.String addr_shipA1SearchType, java.lang.String addr_shipzipcode, java.lang.String addr_shipZCSearchType, java.lang.String addr_shipfirstName, java.lang.String addr_shipFNSearchType, java.lang.String addr_shiplastName, java.lang.String addr_shipLNSearchType, java.lang.String addr_city, java.lang.String addr_cityA1SearchTypeString, java.lang.String addr_shipcity, java.lang.String addr_shipcityA1SearchTypeString, java.lang.String orgName, java.lang.String orgNameSearchType, java.lang.String ordersField1, java.lang.String SKU, java.lang.String ordersNotFulfilled, java.lang.String orgField1, java.lang.String orgField1SearchType, java.lang.String addr_billfirstName, java.lang.String addr_billFNSearchType, java.lang.String addr_billlastName, java.lang.String addr_billLNSearchType, java.lang.String addr_billaddress1, java.lang.String addr_billA1SearchType, java.lang.String addr_billcity, java.lang.String addr_billcityA1SearchTypeString, java.lang.String addr_billzipcode, java.lang.String addr_billZCSearchType, java.lang.Long fulfillmentCenterId, java.lang.String orderItemStatus, java.util.HashMap paymentData)
findOrdersForStoreAdvanced
|
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 majorStatus, 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, java.lang.String orderType, java.lang.String orderBlocked, java.lang.String blockReasonCode, java.lang.String addr_shipaddress1, java.lang.String addr_shipA1SearchType, java.lang.String addr_shipzipcode, java.lang.String addr_shipZCSearchType, java.lang.String addr_shipfirstName, java.lang.String addr_shipFNSearchType, java.lang.String addr_shiplastName, java.lang.String addr_shipLNSearchType, java.lang.String addr_city, java.lang.String addr_cityA1SearchTypeString, java.lang.String addr_shipcity, java.lang.String addr_shipcityA1SearchTypeString, java.lang.String orgName, java.lang.String orgNameSearchType, java.lang.String ordersField1, java.lang.String SKU, java.lang.String ordersNotFulfilled, java.lang.String orgField1, java.lang.String orgField1SearchType, java.lang.String addr_billfirstName, java.lang.String addr_billFNSearchType, java.lang.String addr_billlastName, java.lang.String addr_billLNSearchType, java.lang.String addr_billaddress1, java.lang.String addr_billA1SearchType, java.lang.String addr_billcity, java.lang.String addr_billcityA1SearchTypeString, java.lang.String addr_billzipcode, java.lang.String addr_billZCSearchType, java.lang.Long fulfillmentCenterId, java.lang.String orderItemStatus, java.util.HashMap paymentData, java.lang.String addr_ownerfirstName, java.lang.String addr_ownerFNSearchType, java.lang.String addr_ownerlastName, java.lang.String addr_ownerLNSearchType, java.lang.String addr_owneraddress1, java.lang.String addr_ownerA1SearchType, java.lang.String addr_ownercity, java.lang.String addr_ownercityA1SearchTypeString, java.lang.String addr_ownerzipcode, java.lang.String addr_ownerZCSearchType, java.lang.String addr_ownerphone1, java.lang.String addr_owneremail1, java.lang.String addr_ownerE1SearchType)
findOrdersForStoreAdvanced
|
java.util.HashMap | findOrdersInStores(java.lang.Long hubStoreId, java.lang.Long adminId, java.lang.String storeName, java.lang.String storeNameSearchType, java.lang.String storeCategoryName, java.lang.String storeCgrySearchType, java.lang.String orderBy, java.lang.String orderId, java.lang.String userLogin, java.lang.String userId, java.lang.String orderStatus, java.lang.String orgId, java.lang.Integer start, java.lang.Integer maxLength, CommandContext context)
findOrdersInStores
|
java.util.HashMap | findOrdersInStoresAdvanced(java.lang.Long hubStoreId, java.lang.Long adminId, java.lang.String storeName, java.lang.String storeNameSearchType, java.lang.String storeCategoryName, java.lang.String storeCgrySearchType, 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, java.lang.String orderType, java.lang.String orderBlocked, java.lang.String blockReasonCode, java.lang.String addr_shipaddress1, java.lang.String addr_shipA1SearchType, java.lang.String addr_shipzipcode, java.lang.String addr_shipZCSearchType, java.lang.String addr_shipfirstName, java.lang.String addr_shipFNSearchType, java.lang.String addr_shiplastName, java.lang.String addr_shipLNSearchType, java.lang.String addr_city, java.lang.String addr_cityA1SearchTypeString, java.lang.String addr_shipcity, java.lang.String addr_shipcityA1SearchTypeString, java.lang.String orgName, java.lang.String orgNameSearchType, java.lang.String ordersField1, java.lang.String SKU, java.lang.String ordersNotFulfilled, java.lang.String orgField1, java.lang.String orgField1SearchType, java.lang.String addr_billfirstName, java.lang.String addr_billFNSearchType, java.lang.String addr_billlastName, java.lang.String addr_billLNSearchType, java.lang.String addr_billaddress1, java.lang.String addr_billA1SearchType, java.lang.String addr_billcity, java.lang.String addr_billcityA1SearchTypeString, java.lang.String addr_billzipcode, java.lang.String addr_billZCSearchType, java.lang.Long fulfillmentCenterId, java.lang.String orderItemStatus, java.util.HashMap paymentData, CommandContext context)
findOrdersInStoresAdvanced
|
protected void | instantiateEJB()
instantiateEJB
|
public OrderSearchAccessBean()
Default constructor. Maps to findByPrimaryKey.
public OrderSearchAccessBean(javax.ejb.EJBObject o) throws java.rmi.RemoteException
public java.lang.String defaultJNDIName()
protected void instantiateEJB() throws javax.naming.NamingException, javax.ejb.CreateException, java.rmi.RemoteException
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
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, java.lang.String orderType, java.lang.String orderBlocked, java.lang.String blockReasonCode, java.lang.String addr_shipaddress1, java.lang.String addr_shipA1SearchType, java.lang.String addr_shipzipcode, java.lang.String addr_shipZCSearchType, java.lang.String addr_shipfirstName, java.lang.String addr_shipFNSearchType, java.lang.String addr_shiplastName, java.lang.String addr_shipLNSearchType, java.lang.String addr_city, java.lang.String addr_cityA1SearchTypeString, java.lang.String addr_shipcity, java.lang.String addr_shipcityA1SearchTypeString, java.lang.String orgName, java.lang.String orgNameSearchType, java.lang.String ordersField1, java.lang.String SKU, java.lang.String ordersNotFulfilled, java.lang.String orgField1, java.lang.String orgField1SearchType, java.lang.String addr_billfirstName, java.lang.String addr_billFNSearchType, java.lang.String addr_billlastName, java.lang.String addr_billLNSearchType, java.lang.String addr_billaddress1, java.lang.String addr_billA1SearchType, java.lang.String addr_billcity, java.lang.String addr_billcityA1SearchTypeString, java.lang.String addr_billzipcode, java.lang.String addr_billZCSearchType, java.lang.Long fulfillmentCenterId, java.lang.String orderItemStatus, java.util.HashMap paymentData) throws javax.naming.NamingException, javax.ejb.ObjectNotFoundException, javax.ejb.CreateException, java.rmi.RemoteException, java.sql.SQLException
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 majorStatus, 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, java.lang.String orderType, java.lang.String orderBlocked, java.lang.String blockReasonCode, java.lang.String addr_shipaddress1, java.lang.String addr_shipA1SearchType, java.lang.String addr_shipzipcode, java.lang.String addr_shipZCSearchType, java.lang.String addr_shipfirstName, java.lang.String addr_shipFNSearchType, java.lang.String addr_shiplastName, java.lang.String addr_shipLNSearchType, java.lang.String addr_city, java.lang.String addr_cityA1SearchTypeString, java.lang.String addr_shipcity, java.lang.String addr_shipcityA1SearchTypeString, java.lang.String orgName, java.lang.String orgNameSearchType, java.lang.String ordersField1, java.lang.String SKU, java.lang.String ordersNotFulfilled, java.lang.String orgField1, java.lang.String orgField1SearchType, java.lang.String addr_billfirstName, java.lang.String addr_billFNSearchType, java.lang.String addr_billlastName, java.lang.String addr_billLNSearchType, java.lang.String addr_billaddress1, java.lang.String addr_billA1SearchType, java.lang.String addr_billcity, java.lang.String addr_billcityA1SearchTypeString, java.lang.String addr_billzipcode, java.lang.String addr_billZCSearchType, java.lang.Long fulfillmentCenterId, java.lang.String orderItemStatus, java.util.HashMap paymentData, java.lang.String addr_ownerfirstName, java.lang.String addr_ownerFNSearchType, java.lang.String addr_ownerlastName, java.lang.String addr_ownerLNSearchType, java.lang.String addr_owneraddress1, java.lang.String addr_ownerA1SearchType, java.lang.String addr_ownercity, java.lang.String addr_ownercityA1SearchTypeString, java.lang.String addr_ownerzipcode, java.lang.String addr_ownerZCSearchType, java.lang.String addr_ownerphone1, java.lang.String addr_owneremail1, java.lang.String addr_ownerE1SearchType) throws javax.naming.NamingException, javax.ejb.ObjectNotFoundException, javax.ejb.CreateException, java.rmi.RemoteException, java.sql.SQLException
public java.util.HashMap findOrdersInStoresAdvanced(java.lang.Long hubStoreId, java.lang.Long adminId, java.lang.String storeName, java.lang.String storeNameSearchType, java.lang.String storeCategoryName, java.lang.String storeCgrySearchType, 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, java.lang.String orderType, java.lang.String orderBlocked, java.lang.String blockReasonCode, java.lang.String addr_shipaddress1, java.lang.String addr_shipA1SearchType, java.lang.String addr_shipzipcode, java.lang.String addr_shipZCSearchType, java.lang.String addr_shipfirstName, java.lang.String addr_shipFNSearchType, java.lang.String addr_shiplastName, java.lang.String addr_shipLNSearchType, java.lang.String addr_city, java.lang.String addr_cityA1SearchTypeString, java.lang.String addr_shipcity, java.lang.String addr_shipcityA1SearchTypeString, java.lang.String orgName, java.lang.String orgNameSearchType, java.lang.String ordersField1, java.lang.String SKU, java.lang.String ordersNotFulfilled, java.lang.String orgField1, java.lang.String orgField1SearchType, java.lang.String addr_billfirstName, java.lang.String addr_billFNSearchType, java.lang.String addr_billlastName, java.lang.String addr_billLNSearchType, java.lang.String addr_billaddress1, java.lang.String addr_billA1SearchType, java.lang.String addr_billcity, java.lang.String addr_billcityA1SearchTypeString, java.lang.String addr_billzipcode, java.lang.String addr_billZCSearchType, java.lang.Long fulfillmentCenterId, java.lang.String orderItemStatus, java.util.HashMap paymentData, CommandContext context) throws javax.naming.NamingException, javax.ejb.ObjectNotFoundException, javax.ejb.CreateException, java.sql.SQLException, java.rmi.RemoteException
public com.ibm.commerce.tools.optools.common.helpers.DynamicListData findOrderAccountIDsForCustomer(java.lang.String customer) throws javax.naming.NamingException, javax.ejb.ObjectNotFoundException, javax.ejb.CreateException, java.rmi.RemoteException, java.sql.SQLException
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, javax.ejb.ObjectNotFoundException, javax.ejb.CreateException, java.rmi.RemoteException, java.sql.SQLException
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 java.util.HashMap findOrdersInStores(java.lang.Long hubStoreId, java.lang.Long adminId, java.lang.String storeName, java.lang.String storeNameSearchType, java.lang.String storeCategoryName, java.lang.String storeCgrySearchType, java.lang.String orderBy, java.lang.String orderId, java.lang.String userLogin, java.lang.String userId, java.lang.String orderStatus, java.lang.String orgId, java.lang.Integer start, java.lang.Integer maxLength, CommandContext context) throws javax.naming.NamingException, javax.ejb.ObjectNotFoundException, javax.ejb.CreateException, java.sql.SQLException, java.rmi.RemoteException
public java.util.Vector executeCustomizableOrderSearch(ECQuery aQuery) throws javax.naming.NamingException, javax.ejb.CreateException, java.rmi.RemoteException, java.sql.SQLException
public java.util.List findOrderHistoriesByOrderId(java.lang.Long orderId, java.lang.String orderBy, boolean isAsc, java.lang.Integer startIndex, java.lang.Integer maxLength) throws javax.naming.NamingException, javax.ejb.ObjectNotFoundException, javax.ejb.CreateException, java.rmi.RemoteException, java.sql.SQLException
public java.util.List findOrderCommentsByOrderAndOrdVersion(java.lang.Long orderId, boolean isCSROrderComment, java.lang.Short orderVersion, java.lang.String orderBy, boolean isAsc, java.lang.Integer startIndex, java.lang.Integer maxLength) throws javax.naming.NamingException, javax.ejb.ObjectNotFoundException, javax.ejb.CreateException, java.rmi.RemoteException, java.sql.SQLException