com.ibm.commerce.tools.optools.user.helpers
Class UserSearchAccessBean

java.lang.Object
  |
  +--com.ibm.ivj.ejb.runtime.AbstractAccessBean
        |
        +--com.ibm.ivj.ejb.runtime.AbstractSessionAccessBean
              |
              +--com.ibm.commerce.tools.optools.user.helpers.UserSearchAccessBean
All Implemented Interfaces:
java.io.Serializable

public class UserSearchAccessBean
extends com.ibm.ivj.ejb.runtime.AbstractSessionAccessBean

UserSearchAccessBean

See Also:
Serialized Form

Fields inherited from class com.ibm.ivj.ejb.runtime.AbstractAccessBean
DEFAULT_NAMESERVICE_PROVIDER_URL, DEFAULT_NAMESERVICE_TYPE, ejbRef
 
Constructor Summary
UserSearchAccessBean()
          Default constructor.
UserSearchAccessBean(javax.ejb.EJBObject Object)
          Creates an access bean for the specified EJB.
 
Method Summary
 com.ibm.commerce.tools.optools.common.helpers.DynamicListData findBusinessUsers(java.lang.String lastName, java.lang.String orgId, java.lang.String roleId, java.lang.String orderby, java.lang.Integer start, java.lang.Integer maxLength)
          Contains the SQL.
 com.ibm.commerce.tools.optools.common.helpers.DynamicListData findCollaborativeMembers(java.lang.String logonId, java.lang.String firstName, java.lang.String lastName, java.lang.String phone, java.lang.String email, java.lang.String city, java.lang.String zip, java.lang.String accountId, java.lang.String orderby, java.lang.String storeType, java.lang.Integer start, java.lang.Integer maxLength)
          Contains the SQL for DB2.
 com.ibm.commerce.tools.optools.common.helpers.DynamicListData findCustomers(java.lang.String logonId, java.lang.String firstName, java.lang.String lastName, java.lang.String phone, java.lang.String email, java.lang.String city, java.lang.String zip, java.lang.String accountId, java.lang.String orderby, java.lang.String storeType, java.lang.Integer start, java.lang.Integer maxLength)
           Contains the SQL for DB2.
 
Methods inherited from class com.ibm.ivj.ejb.runtime.AbstractAccessBean
defaultJNDIName, defaultNameServiceType, defaultNameServiceURL, getEJBRef, getGlobalHome, getHome, getInit_GlobalNameServiceTypeName, getInit_GlobalNameServiceURLName, getInit_JNDIName, getInit_NameServiceTypeName, getInit_NameServiceURLName, getInitContext, getInitContext, instantiateEJB, resetEJBRef, resetHomeCache, setEJBRef, setInit_GlobalNameServiceTypeName, setInit_GlobalNameServiceURLName, setInit_JNDIName, setInit_NameServiceTypeName, setInit_NameServiceURLName
 
Methods inherited from class java.lang.Object
clone, equals, finalize, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait
 

Constructor Detail

UserSearchAccessBean

public UserSearchAccessBean()

Default constructor. Maps to findByPrimaryKey.


UserSearchAccessBean

public UserSearchAccessBean(javax.ejb.EJBObject Object)
                     throws java.rmi.RemoteException

Creates an access bean for the specified EJB.

Parameters:
object - javax.ejb.EJBObject
Throws:
java.rmi.RemoteException - The java.rmi.RemoteException exception
Method Detail

findBusinessUsers

public com.ibm.commerce.tools.optools.common.helpers.DynamicListData findBusinessUsers(java.lang.String lastName,
                                                                                       java.lang.String orgId,
                                                                                       java.lang.String roleId,
                                                                                       java.lang.String orderby,
                                                                                       java.lang.Integer start,
                                                                                       java.lang.Integer maxLength)
                                                                                throws javax.naming.NamingException,
                                                                                       java.sql.SQLException,
                                                                                       javax.ejb.CreateException,
                                                                                       java.rmi.RemoteException

Contains the SQL.

SELECT DISTINCT USERS.USERS_ID

FROM USERS, ADDRESS, MBRREL, MBRROLE

WHERE USERS.PROFILETYPE='B' AND USERS.USERS_ID=MBRREL.DESCENDANT_ID

AND USERS.USERS_ID=ADDRESS.MEMBER_ID AND ADDRESS.LASTNAME like ?

AND MBRREL.ANCESTOR_ID = ? AND USERS.USERS_ID=MBRROLE.MEMBER_ID

AND MBRROLE.ROLE_ID = ?

Parameters:
lastName - java.lang.String
orgIdjava.lang.String -  
roleId - java.lang.String
orderby - java.lang.String
start - java.lang.Integer
maxLength - java.lang.Integer
Returns:
com.ibm.commerce.tools.optools.common.helpers.DynamicListData
Throws:
javax.naming.NamingException - The javax.naming.NamingException exception
java.sql.SQLException - The java.sql.SQLException exception
javax.ejb.CreateException - The javax.ejb.CreateException exception
java.rmi.RemoteException - The java.rmi.RemoteException exception

findCollaborativeMembers

public com.ibm.commerce.tools.optools.common.helpers.DynamicListData findCollaborativeMembers(java.lang.String logonId,
                                                                                              java.lang.String firstName,
                                                                                              java.lang.String lastName,
                                                                                              java.lang.String phone,
                                                                                              java.lang.String email,
                                                                                              java.lang.String city,
                                                                                              java.lang.String zip,
                                                                                              java.lang.String accountId,
                                                                                              java.lang.String orderby,
                                                                                              java.lang.String storeType,
                                                                                              java.lang.Integer start,
                                                                                              java.lang.Integer maxLength)
                                                                                       throws javax.naming.NamingException,
                                                                                              java.sql.SQLException,
                                                                                              javax.ejb.CreateException,
                                                                                              java.rmi.RemoteException

Contains the SQL for DB2.

UNION SELECT USERS.USERS_ID, ADDRESS_ID, LOGONID, FIRSTNAME, LASTNAME, PHONE1, CITY, EMAIL1, ZIPCODE

FROM USERS, USERREG, ADDRESS, ACCOUNT, MBRREL, ORGENTITY, TRADING, PARTICIPNT

WHERE USERS.REGISTERTYPE IN ('R','A','S') AND USERS.USERS_ID=USERREG.USERS_ID

AND USERS.USERS_ID=ADDRESS.MEMBER_ID AND ADDRESS.STATUS='P' AND ADDRESS.SELFADDRESS = 1

AND ORGENTITY.ORGENTITYTYPE = 'O' AND USERS.USERS_ID = MBRREL.DESCENDANT_ID

AND ACCOUNT.ACCOUNT_ID = TRADING.TRADING_ID AND TRADING.TRADING_ID = PARTICIPNT.TRADING_ID

AND PARTICIPNT.PARTROLE_ID = 5 AND PARTICIPNT.MEMBER_ID = MBRREL.ANCESTOR_ID

AND ORGENTITY.ORGENTITY_ID = PARTICIPNT.MEMBER_ID AND SUBSTR(LOGONID, 1, LOCATE(',', LOGONID)) LIKE ?

AND FIRSTNAME LIKE ? AND LASTNAME like ? AND PHONE1 LIKE ? AND EMAIL1 LIKE ?

AND CITY LIKE ? AND ZIPCODE LIKE ? AND ACCOUNT.ACCOUNT_ID = ? ORDERBY LOGONID

SQL for ORACLE:

UNION SELECT USERS.USERS_ID, ADDRESS_ID, LOGONID, FIRSTNAME, LASTNAME, PHONE1, CITY, EMAIL1, ZIPCODE

FROM USERS, USERREG, ADDRESS, ACCOUNT, MBRREL, ORGENTITY, TRADING, PARTICIPNT

WHERE USERS.REGISTERTYPE IN ('R','A','S') AND USERS.USERS_ID=USERREG.USERS_ID

AND USERS.USERS_ID=ADDRESS.MEMBER_ID AND ADDRESS.STATUS='P' AND ADDRESS.SELFADDRESS = 1

AND ORGENTITY.ORGENTITYTYPE = 'O' AND USERS.USERS_ID = MBRREL.DESCENDANT_ID

AND ACCOUNT.ACCOUNT_ID = TRADING.TRADING_ID AND TRADING.TRADING_ID = PARTICIPNT.TRADING_ID

AND PARTICIPNT.PARTROLE_ID = 5 AND PARTICIPNT.MEMBER_ID = MBRREL.ANCESTOR_ID

AND ORGENTITY.ORGENTITY_ID = PARTICIPNT.MEMBER_ID AND AND SUBSTR( LOGONID, 1, INSTR(LOGONID, ',')) LIKE ?

AND FIRSTNAME LIKE ? AND LASTNAME like ? AND PHONE1 LIKE ? AND EMAIL1 LIKE ?

AND CITY LIKE ? AND ZIPCODE LIKE ? AND ACCOUNT.ACCOUNT_ID = ? ORDERBY LOGONID

Parameters:
logonId - java.lang.String
firstName - java.lang.String
lastName - java.lang.String
phone - java.lang.String
email - java.lang.String
city - java.lang.String
zip - java.lang.String
accountId - java.lang.String
orderby - java.lang.String
storeType - java.lang.String
start - java.lang.Integer
maxLength - java.lang.Integer
Returns:
com.ibm.commerce.tools.optools.common.helpers.DynamicListData
Throws:
javax.naming.NamingException - The javax.naming.NamingException exception
java.sql.SQLException - The java.sql.SQLException exception
javax.ejb.CreateException - The javax.ejb.CreateException exception
java.rmi.RemoteException - The java.rmi.RemoteException exception

findCustomers

public com.ibm.commerce.tools.optools.common.helpers.DynamicListData findCustomers(java.lang.String logonId,
                                                                                   java.lang.String firstName,
                                                                                   java.lang.String lastName,
                                                                                   java.lang.String phone,
                                                                                   java.lang.String email,
                                                                                   java.lang.String city,
                                                                                   java.lang.String zip,
                                                                                   java.lang.String accountId,
                                                                                   java.lang.String orderby,
                                                                                   java.lang.String storeType,
                                                                                   java.lang.Integer start,
                                                                                   java.lang.Integer maxLength)
                                                                            throws javax.naming.NamingException,
                                                                                   java.sql.SQLException,
                                                                                   java.rmi.RemoteException,
                                                                                   javax.ejb.CreateException

Contains the SQL for DB2.

SELECT DISTINCT USERS.USERS_ID, LOGONID, FIRSTNAME, LASTNAME, PHONE1, CITY, EMAIL1, ZIPCODE

FROM USERS, USERREG LEFT OUTER JOIN ADDRESS ON USERREG.USERS_ID = ADDRESS.MEMBER_ID AND ADDRESS.STATUS='P' AND ADDRESS.SELFADDRESS = 1

WHERE USERS.REGISTERTYPE='R' AND USERS.USERS_ID=USERREG.USERS_ID AND USERS.PROFILETYPE = 'C'

AND ((LOGONID LIKE ? ESCAPE '\\') OR (LOGONID LIKE ? ESCAPE '\\'))

AND FIRSTNAME LIKE ? ESCAPE '\\' AND LASTNAME LIKE ? ESCAPE '\\'

AND PHONE1 LIKE ? ESCAPE '\\' AND EMAIL1 LIKE ? ESCAPE '\\'

AND CITY LIKE ? ESCAPE '\\' AND ZIPCODE LIKE ? ESCAPE '\\'

ORDER BY LOGONID

The SQL for ORACLE:

SELECT DISTINCT USERS.USERS_ID, LOGONID, FIRSTNAME, LASTNAME, PHONE1, CITY, EMAIL1, ZIPCODE

FROM USERS, USERREG, ADDRESS

WHERE USERREG.USERS_ID = ADDRESS.MEMBER_ID(+) AND ADDRESS.STATUS(+)='P'

AND ADDRESS.SELFADDRESS(+) = 1 AND USERS.REGISTERTYPE='R'

AND SERS.USERS_ID=USERREG.USERS_ID AND USERS.PROFILETYPE = 'C'

AND ((LOGONID LIKE ? ESCAPE '\\') OR (LOGONID LIKE ? ESCAPE '\\'))

AND FIRSTNAME LIKE ? ESCAPE '\\' AND LASTNAME LIKE ? ESCAPE '\\'

AND PHONE1 LIKE ? ESCAPE '\\' AND EMAIL1 LIKE ? ESCAPE '\\'

AND CITY LIKE ? ESCAPE '\\' AND ZIPCODE LIKE ? ESCAPE '\\'

ORDER BY LOGONID

Parameters:
logonId - java.lang.String
firstName - java.lang.String
lastName - java.lang.String
phone - java.lang.String
email - java.lang.String
city - java.lang.String
zip - java.lang.String
accountId - java.lang.String
orderby - java.lang.String
storeType - java.lang.String
start - java.lang.Integer
maxLength - java.lang.Integer
Returns:
com.ibm.commerce.tools.optools.common.helpers.DynamicListData
Throws:
javax.naming.NamingException - The javax.naming.NamingException exception
java.sql.SQLException - The java.sql.SQLException exception
java.rmi.RemoteException - The java.rmi.RemoteException exception
javax.ejb.CreateException - The javax.ejb.CreateException exception