public class UserSearchBean extends BaseJDBCHelper
Modifier and Type | Field and Description |
---|---|
static java.lang.String |
COPYRIGHT
Copyright.
|
autoFlush, DB_AS400, DB_DB2, DB_DB2_390, DB_DB2J, DB_ORACLE
Constructor and Description |
---|
UserSearchBean() |
Modifier and Type | Method and Description |
---|---|
java.util.Vector |
executeCustomizeableMemberSearch(ECQuery aQuery)
Used to execute a customizeable member search.
|
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)
Deprecated.
Functionality replaced by findUsersInOrgsICanAdmin() from class CustomerSearchDataBean.
|
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,
java.lang.String strActiveUserId)
Deprecated.
Functionality replaced by findUsersInOrgsICanAdmin() from class CustomerSearchDataBean.
|
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.String storeMemberId,
java.lang.Integer start,
java.lang.Integer maxLength)
Deprecated.
|
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.String storeMemberId,
java.lang.Integer start,
java.lang.Integer maxLength,
java.lang.String strActiveUserId)
Search for Collaborative Users - Registered Users and Administrators - if an account is specified, anyone under the account
|
com.ibm.commerce.tools.optools.common.helpers.DynamicListData |
findCollaborativeMembersBasicSearch(java.lang.String logonId,
java.lang.String firstName,
java.lang.String lastName,
java.lang.String phone,
java.lang.String mobilePhone,
java.lang.String email,
java.lang.String city,
java.lang.String zip,
java.lang.String orderby,
java.lang.String storeMemberId,
java.lang.Integer start,
java.lang.Integer maxLength,
boolean isLdapMode,
java.lang.String rdnName,
java.lang.String searchType)
Search for Collaborative Users - Registered Users by default.
|
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.String storeMemberId,
java.lang.Integer start,
java.lang.Integer maxLength)
Deprecated.
|
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.String storeMemberId,
java.lang.Integer start,
java.lang.Integer maxLength,
java.lang.String strActiveUserId)
Search for customers registered to a store.
|
com.ibm.commerce.tools.optools.common.helpers.DynamicListData |
findCustomersAdvancedSearch(java.lang.String logonId,
java.lang.String logonIdSearchType,
java.lang.String firstName,
java.lang.String firstNameSearchType,
java.lang.String lastName,
java.lang.String lastNameSearchType,
java.lang.String phone,
java.lang.String phoneSearchType,
java.lang.String email,
java.lang.String emailSearchType,
java.lang.String city,
java.lang.String citySearchType,
java.lang.String zip,
java.lang.String zipSearchType,
java.lang.String accountId,
java.lang.String orderBy,
java.lang.String storeType,
java.lang.String storeMemberId,
java.lang.Integer start,
java.lang.Integer maxLength)
|
com.ibm.commerce.tools.optools.common.helpers.DynamicListData |
findCustomersAdvancedSearch(java.lang.String logonId,
java.lang.String logonIdSearchType,
java.lang.String firstName,
java.lang.String firstNameSearchType,
java.lang.String lastName,
java.lang.String lastNameSearchType,
java.lang.String phone,
java.lang.String phoneSearchType,
java.lang.String email,
java.lang.String emailSearchType,
java.lang.String city,
java.lang.String citySearchType,
java.lang.String zip,
java.lang.String zipSearchType,
java.lang.String accountId,
java.lang.String orderBy,
java.lang.String storeType,
java.lang.String storeMemberId,
java.lang.Integer start,
java.lang.Integer maxLength,
java.lang.String strActiveUserId)
Finds customers using advanced search.
|
static java.lang.String |
getUpperCaseFunction()
Gets the uppercase function for the configured the database.
|
buildCommaSeparatedWhereClause, convertResultSetToTable, flush, flush, getCharacterStreamFromResultSet, getDataSource, getDataSource, getInQueryClause, getObject, getObject, getObject, getSavedOptCounterInfoForDelete, getSavedOptCounterInfoForOptimisticSelect, getSavedOptCounterInfoForUpdate, init, init, useCloudscape, useDB2_390, useDB2_400, useDB2, useOracle, useOracle9
public static final java.lang.String COPYRIGHT
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 java.sql.SQLException, javax.naming.NamingException
lastName
- java.lang.StringorgId
- java.lang.StringroleId
- java.lang.Stringorderby
- java.lang.Stringstart
- java.lang.IntegermaxLength
- java.lang.Integerjavax.naming.NamingException
java.sql.SQLException
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, java.lang.String strActiveUserId) throws java.sql.SQLException, javax.naming.NamingException
lastName
- java.lang.StringorgId
- java.lang.StringroleId
- java.lang.Stringorderby
- java.lang.Stringstart
- java.lang.IntegermaxLength
- java.lang.IntegerstrActiveUserId
- java.lang.Stringjavax.naming.NamingException
java.sql.SQLException
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.String storeMemberId, java.lang.Integer start, java.lang.Integer maxLength) throws java.sql.SQLException, javax.naming.NamingException
findCollaborativeMembers(String,String,String,String,String,String,String,String,String,String,String,Integer,Integer,String)
logonId
- java.lang.StringfirstName
- java.lang.StringlastName
- java.lang.Stringphone
- java.lang.Stringemail
- java.lang.Stringcity
- java.lang.Stringzip
- java.lang.StringaccountId
- java.lang.Stringorderby
- java.lang.StringstoreType
- java.lang.StringstoreMemberId
- java.lang.Stringstart
- java.lang.IntegermaxLength
- java.lang.Integerjavax.naming.NamingException
java.sql.SQLException
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.String storeMemberId, java.lang.Integer start, java.lang.Integer maxLength, java.lang.String strActiveUserId) throws java.sql.SQLException, javax.naming.NamingException
logonId
- java.lang.StringfirstName
- java.lang.StringlastName
- java.lang.Stringphone
- java.lang.Stringemail
- java.lang.Stringcity
- java.lang.Stringzip
- java.lang.StringaccountId
- java.lang.Stringorderby
- java.lang.StringstoreType
- java.lang.StringstoreMemberId
- java.lang.Stringstart
- java.lang.IntegermaxLength
- java.lang.IntegerstrActiveUserId
- java.lang.Stringjavax.naming.NamingException
java.sql.SQLException
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.String storeMemberId, java.lang.Integer start, java.lang.Integer maxLength) throws java.sql.SQLException, javax.naming.NamingException
findCustomers(String,String,String,String,String,String,String,String,String,String,String,Integer,Integer,String)
logonId
- java.lang.StringfirstName
- java.lang.StringlastName
- java.lang.Stringphone
- java.lang.Stringemail
- java.lang.Stringcity
- java.lang.Stringzip
- java.lang.StringaccountId
- java.lang.Stringorderby
- java.lang.StringstoreType
- java.lang.StringstoreMemberId
- java.lang.Stringstart
- java.lang.IntegermaxLength
- java.lang.Integerjavax.naming.NamingException
java.sql.SQLException
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.String storeMemberId, java.lang.Integer start, java.lang.Integer maxLength, java.lang.String strActiveUserId) throws java.sql.SQLException, javax.naming.NamingException
logonId
- java.lang.StringfirstName
- java.lang.StringlastName
- java.lang.Stringphone
- java.lang.Stringemail
- java.lang.Stringcity
- java.lang.Stringzip
- java.lang.StringaccountId
- java.lang.Stringorderby
- java.lang.StringstoreType
- java.lang.StringstoreMemberId
- java.lang.Stringstart
- java.lang.IntegermaxLength
- java.lang.IntegerstrActiveUserId
- java.lang.Stringjavax.naming.NamingException
java.sql.SQLException
public com.ibm.commerce.tools.optools.common.helpers.DynamicListData findCustomersAdvancedSearch(java.lang.String logonId, java.lang.String logonIdSearchType, java.lang.String firstName, java.lang.String firstNameSearchType, java.lang.String lastName, java.lang.String lastNameSearchType, java.lang.String phone, java.lang.String phoneSearchType, java.lang.String email, java.lang.String emailSearchType, java.lang.String city, java.lang.String citySearchType, java.lang.String zip, java.lang.String zipSearchType, java.lang.String accountId, java.lang.String orderBy, java.lang.String storeType, java.lang.String storeMemberId, java.lang.Integer start, java.lang.Integer maxLength) throws java.sql.SQLException, javax.naming.NamingException
findCustomersAdvancedSearch(String,String,String,String,String,String,String,String,String,String,String,String,String,String,String,String,String,String,Integer,Integer,String)
logonId
- The customer's logon ID.logonIdSearchType
- logonId field search type.firstName
- The customer's firstName.firstNameSearchType
- firstName search type.lastName
- The customer's last name.lastNameSearchType
- lastName search type.phone
- The customer's phone number.phoneSearchType
- phone search type.email
- The customer's email address.emailSearchType
- email search type.city
- The city where the customer lives in.citySearchType
- city search type.zip
- The customer's address zip code.zipSearchType
- zip search type.accountId
- The customer's account ID.orderBy
- The field name to be sorted.storeType
- The store type.storeMemberId
- The store member ID.start
- Start index.maxLength
- The max length for result return.javax.naming.NamingException
- The exception description.java.sql.SQLException
- The exception description.public com.ibm.commerce.tools.optools.common.helpers.DynamicListData findCustomersAdvancedSearch(java.lang.String logonId, java.lang.String logonIdSearchType, java.lang.String firstName, java.lang.String firstNameSearchType, java.lang.String lastName, java.lang.String lastNameSearchType, java.lang.String phone, java.lang.String phoneSearchType, java.lang.String email, java.lang.String emailSearchType, java.lang.String city, java.lang.String citySearchType, java.lang.String zip, java.lang.String zipSearchType, java.lang.String accountId, java.lang.String orderBy, java.lang.String storeType, java.lang.String storeMemberId, java.lang.Integer start, java.lang.Integer maxLength, java.lang.String strActiveUserId) throws java.sql.SQLException, javax.naming.NamingException
logonId
- The customer's logon ID.logonIdSearchType
- logonId field search type.firstName
- The customer's firstName.firstNameSearchType
- firstName search type.lastName
- The customer's last name.lastNameSearchType
- lastName search type.phone
- The customer's phone number.phoneSearchType
- phone search type.email
- The customer's email address.emailSearchType
- email search type.city
- The city where the customer lives in.citySearchType
- city search type.zip
- The customer's address zip code.zipSearchType
- zip search type.accountId
- The customer's account ID.orderBy
- The field name to be sorted.storeType
- The store type.storeMemberId
- The store member ID.start
- Start index.maxLength
- The max length for result return.strActiveUserId
- java.lang.Stringjavax.naming.NamingException
- The exception description.java.sql.SQLException
- The exception description.public com.ibm.commerce.tools.optools.common.helpers.DynamicListData findCollaborativeMembersBasicSearch(java.lang.String logonId, java.lang.String firstName, java.lang.String lastName, java.lang.String phone, java.lang.String mobilePhone, java.lang.String email, java.lang.String city, java.lang.String zip, java.lang.String orderby, java.lang.String storeMemberId, java.lang.Integer start, java.lang.Integer maxLength, boolean isLdapMode, java.lang.String rdnName, java.lang.String searchType) throws java.sql.SQLException, javax.naming.NamingException
logonId
- java.lang.String the logon ID.firstName
- java.lang.String the first name.lastName
- java.lang.String the last name.phone
- java.lang.String the phone number. this will be used to search the phone1 field in address table.mobilePhone
- java.lang.String the mobile phone number. this will be used to search the mobilephone1 field in address table.email
- java.lang.String the email. this will be used to search the email1 field in the address tablecity
- java.lang.String the city name.zip
- java.lang.String the zip codeorderby
- java.lang.String the order by collumn name.storeMemberId
- java.lang.String the store owner Id.start
- java.lang.Integer the start index.maxLength
- java.lang.Integer the page size. If te value is -1, no paging.isLdapMode
- if commerce member system using LDAPrdnName
- the RDN attribute name of the LDAP server (uid or cn).searchType
- the search type.javax.naming.NamingException
java.sql.SQLException
public static java.lang.String getUpperCaseFunction()
public java.util.Vector executeCustomizeableMemberSearch(ECQuery aQuery) throws java.sql.SQLException, javax.naming.NamingException
aQuery
- The ECQuery object.javax.naming.NamingException
java.sql.SQLException