public class ListUsersInMemberGroupCmdImpl extends TaskCommandImpl implements ListUsersInMemberGroupCmd, SegmentConstants, ConditionConstants
Modifier and Type | Field and Description |
---|---|
protected boolean | _databaseIsDB2
The database type of the system
|
protected MemberGroupAccessBean | _memberGroupAccessBean
An instance of MemberGroupAccessBean.
|
protected java.lang.String | _memberGroupName
The member group name.
|
protected java.lang.Long | _memberGroupOwnerId
The member group ID.
|
protected java.lang.Long[] | _orgEntityIds
The organization IDs.
|
protected java.lang.String | _query
An SQL select statement used to find the users.
|
protected java.lang.String[] | _userIds
An array of user IDs.
|
protected UserAccessBean[] | _users
An array of UserAccessBean objects.
|
static java.lang.String | COPYRIGHT
Copyright.
|
Constructor and Description |
---|
ListUsersInMemberGroupCmdImpl() |
Modifier and Type | Method and Description |
---|---|
protected void | constructQuery()
Constructs an SQL query that will retrieve the users that belong to the member group.
|
protected java.lang.String | convertAccountAmountSpentCondition(java.lang.String operator, java.lang.String value, SimpleCondition.Qualifier[] qualifiers)
Converts the "AccountAmountSpent" condition to an SQL query.
|
protected java.lang.String | convertAccountBusinessCondition(java.lang.String operator, java.lang.String value, SimpleCondition.Qualifier[] qualifiers)
Converts the "AccountBusiness" condition to an SQL query.
|
protected java.lang.String | convertAccountCondition(java.lang.String operator, java.lang.String value, SimpleCondition.Qualifier[] qualifiers)
Converts the "Account" condition to an SQL query.
|
protected java.lang.String | convertAccountCountryCondition(java.lang.String operator, java.lang.String value, SimpleCondition.Qualifier[] qualifiers)
Converts the "AccountCountry" condition to an SQL query.
|
protected java.lang.String | convertAccountCreditCondition(java.lang.String operator, java.lang.String value, SimpleCondition.Qualifier[] qualifiers)
Converts the "AccountCredit" condition to an SQL query.
|
protected java.lang.String | convertAccountIndustryCondition(java.lang.String operator, java.lang.String value, SimpleCondition.Qualifier[] qualifiers)
Converts the "AccountIndustry" condition to an SQL query.
|
protected java.lang.String | convertAccountLocationCondition(java.lang.String operator, java.lang.String value, SimpleCondition.Qualifier[] qualifiers)
Converts the "AccountLocation" condition to an SQL query.
|
protected java.lang.String | convertAccountSizeCondition(java.lang.String operator, java.lang.String value, SimpleCondition.Qualifier[] qualifiers)
Converts the "AccountSize" condition to an SQL query.
|
protected java.lang.String | convertAgeGroupCondition(java.lang.String operator, java.lang.String value, SimpleCondition.Qualifier[] qualifiers)
Converts the "AgeGroup" condition to an SQL query.
|
protected java.lang.String | convertAgeRangeCondition(java.lang.String operator, java.lang.String value, SimpleCondition.Qualifier[] qualifiers)
Converts the "Age Range" condition to an SQL query.
|
protected java.lang.String | convertAmountSpentCondition(java.lang.String operator, java.lang.String value, SimpleCondition.Qualifier[] qualifiers)
Converts the "AmountSpent" condition to an SQL query.
|
protected java.lang.String | convertChildrenCondition(java.lang.String operator, java.lang.String value, SimpleCondition.Qualifier[] qualifiers)
Converts the "children" condition to an SQL query.
|
protected java.lang.String | convertCityCondition(java.lang.String operator, java.lang.String value, SimpleCondition.Qualifier[] qualifiers)
Converts the "City" condition to an SQL query.
|
protected java.lang.String | convertCompanyCondition(java.lang.String operator, java.lang.String value, SimpleCondition.Qualifier[] qualifiers)
Converts the "Company" condition to an SQL query.
|
protected java.lang.String | convertCountryCondition(java.lang.String operator, java.lang.String value, SimpleCondition.Qualifier[] qualifiers)
Converts the "Country" condition to an SQL query.
|
protected java.lang.String | convertCurrencyCondition(java.lang.String operator, java.lang.String value, SimpleCondition.Qualifier[] qualifiers)
Converts the "Currency" condition to an SQL query.
|
protected java.lang.String | convertDaysSinceLastPurchaseCondition(java.lang.String operator, java.lang.String value, SimpleCondition.Qualifier[] qualifiers)
Converts the "DaysSinceLastPurchase" condition to an SQL query.
|
protected java.lang.String | convertDaysSinceLastVisitCondition(java.lang.String operator, java.lang.String value, SimpleCondition.Qualifier[] qualifiers)
Converts the "DaysSinceLastVisit" condition to an SQL query.
|
protected java.lang.String | convertDaysSinceRegistrationChangeCondition(java.lang.String operator, java.lang.String value, SimpleCondition.Qualifier[] qualifiers)
Converts the "DaysSinceRegistrationChange" condition to an SQL query.
|
protected java.lang.String | convertDaysSinceRegistrationCondition(java.lang.String operator, java.lang.String value, SimpleCondition.Qualifier[] qualifiers)
Converts the "DaysSinceRegistration" condition to an SQL query.
|
protected java.lang.String | convertEMailCondition(java.lang.String operator, java.lang.String value, SimpleCondition.Qualifier[] qualifiers)
Converts the "EMail" condition to an SQL query.
|
protected java.lang.String | convertGenderCondition(java.lang.String operator, java.lang.String value, SimpleCondition.Qualifier[] qualifiers)
Converts the "gender" condition to an SQL query.
|
protected java.lang.String | convertHouseholdCondition(java.lang.String operator, java.lang.String value, SimpleCondition.Qualifier[] qualifiers)
Converts the "household" condition to an SQL query.
|
protected java.lang.String | convertIncomeGroupCondition(java.lang.String operator, java.lang.String value, SimpleCondition.Qualifier[] qualifiers)
Converts the "IncomeGroup" condition to an SQL query.
|
protected java.lang.String | convertInterestsCondition(java.lang.String operator, java.lang.String value, SimpleCondition.Qualifier[] qualifiers)
Converts the "Interests" condition to an SQL query.
|
protected java.lang.String | convertJobFunctionCondition(java.lang.String operator, java.lang.String value, SimpleCondition.Qualifier[] qualifiers)
Converts the "JobFunction" condition to an SQL query.
|
protected java.lang.String | convertLanguageCondition(java.lang.String operator, java.lang.String value, SimpleCondition.Qualifier[] qualifiers)
Converts the "Language" condition to an SQL query.
|
protected java.lang.String | convertLastPurchaseDateCondition(java.lang.String operator, java.lang.String value, SimpleCondition.Qualifier[] qualifiers)
Converts the "RegistrationChangeDate" condition to an SQL query.
|
protected java.lang.String | convertLastVisitDateCondition(java.lang.String operator, java.lang.String value, SimpleCondition.Qualifier[] qualifiers)
Converts the "LastVisitDate" condition to an SQL query.
|
protected java.lang.String | convertLocaleCondition(java.lang.String operator, java.lang.String value, SimpleCondition.Qualifier[] qualifiers)
Converts the "Locale" condition to an SQL query.
|
protected java.lang.String | convertMaritalStatusCondition(java.lang.String operator, java.lang.String value, SimpleCondition.Qualifier[] qualifiers)
Converts the "MaritalStatus" condition to an SQL query.
|
protected java.lang.String | convertMarketingPopulatesCondition(java.lang.String memberGroupId)
Converts the "Marketing Populates" condition to an SQL query.
|
protected java.lang.String | convertOrdersCondition(java.lang.String operator, java.lang.String value, SimpleCondition.Qualifier[] qualifiers)
Converts the "Orders" condition to an SQL query.
|
protected java.lang.String | convertOrgCondition(java.lang.String operator, java.lang.String value, SimpleCondition.Qualifier[] qualifiers)
Converts the "org" condition to an SQL query.
|
protected java.lang.String | convertOrgDNCondition(java.lang.String operator, java.lang.String value, SimpleCondition.Qualifier[] qualifiers)
Converts the "orgDN" condition to an SQL query.
|
protected java.lang.String | convertPhoneCondition(java.lang.String operator, java.lang.String value, SimpleCondition.Qualifier[] qualifiers)
Converts the "Phone" condition to an SQL query.
|
protected java.lang.String | convertPreferredCommunicationCondition(java.lang.String operator, java.lang.String value, SimpleCondition.Qualifier[] qualifiers)
Converts the "PreferredCommunication" condition to an SQL query.
|
protected java.lang.String | convertRegistrationChangeDateCondition(java.lang.String operator, java.lang.String value, SimpleCondition.Qualifier[] qualifiers)
Converts the "RegistrationChangeDate" condition to an SQL query.
|
protected java.lang.String | convertRegistrationDateCondition(java.lang.String operator, java.lang.String value, SimpleCondition.Qualifier[] qualifiers)
Converts the "RegistrationDate" condition to an SQL query.
|
protected java.lang.String | convertRegistrationStatusCondition(java.lang.String operator, java.lang.String value, SimpleCondition.Qualifier[] qualifiers)
Converts the "RegistrationStatus" condition to an SQL query.
|
protected java.lang.String | convertRoleCondition(java.lang.String operator, java.lang.String value, SimpleCondition.Qualifier[] qualifiers)
Converts the "role" condition to an SQL query.
|
protected java.lang.String | convertRoleListCondition(OpenCondition.Parameter[] parameters)
Converts the "roleList" open condition to an SQL query.
|
protected java.lang.String | convertSegmentCondition(java.lang.String operator, java.lang.String value, SimpleCondition.Qualifier[] qualifiers)
Converts the "Segment" condition to an SQL query.
|
protected java.lang.String | convertStateCondition(java.lang.String operator, java.lang.String value, SimpleCondition.Qualifier[] qualifiers)
Converts the "State" condition to an SQL query.
|
protected java.lang.String | convertStatusCondition(java.lang.String operator, java.lang.String value, SimpleCondition.Qualifier[] qualifiers)
Converts the "status" condition to an SQL query.
|
protected java.lang.String | convertToSQL(AndListCondition condition)
Converts an and list condition to an SQL query.
|
protected java.lang.String | convertToSQL(Condition condition)
Converts a condition to an SQL query.
|
protected java.lang.String | convertToSQL(OpenCondition condition)
Converts an open condition to an SQL query.
|
protected java.lang.String | convertToSQL(OrListCondition condition)
Converts an or list condition to an SQL query.
|
protected java.lang.String | convertToSQL(SimpleCondition condition)
Converts an simple condition to an SQL query.
|
protected java.lang.String | convertToSQL(TrueCondition condition)
Converts an true condition to an SQL query.
|
protected java.lang.String | convertZipCodeCondition(java.lang.String operator, java.lang.String value, SimpleCondition.Qualifier[] qualifiers)
Converts the "ZipCode" condition to an SQL query.
|
java.lang.String | getQuery()
Returns the SQL query used to generate the list of members in the group.
|
java.lang.String[] | getUserIds()
Gets the array of user IDs.
|
UserAccessBean[] | getUsers()
Gets the array of UserAccessBean objects.
|
boolean | isReadyToCallExecute()
Checks to see if the command is ready to call.
|
void | performExecute()
Performs the execution of the command.
|
protected MemberGroupAccessBean | resolveCustomerSegmentByOwnerAndName(java.lang.Long memberGroupOwnerId, java.lang.String segmentName)
Returns a member group access bean for the specified customer segment.
|
void | setAdditionalAndCondition(Condition condition)
Adds an additonal condition that must also be met on top of the conditions outlined in the member group rules.
|
void | setMemberGroupAccessBean(MemberGroupAccessBean memberGroupAccessBean)
Sets the instance of MemberGroupAccessBean.
|
void | setMemberGroupIds(java.lang.String[] mbrGrpIds, java.lang.String anyOrAll)
This method sets the additonal member group IDs of the customer segments to which to return the list of users.
|
void | setMemberGroupName(java.lang.String memberGroupName)
Sets the member group name.
|
void | setMemberGroupOwnerId(java.lang.Long memberGroupOwnerId)
Sets the member group ID.
|
void | setOrgEntityIds(java.lang.Long[] orgEntityIds)
Sets the organization IDs.
|
void | setQueryOnly(boolean flag)
Defers executing the query generated for querying members of the group to the caller.
|
void | setQueryWrapper(java.lang.String queryWrapper)
Wraps the query used to determine the members of the group with the passed parameter.
|
public static final java.lang.String COPYRIGHT
protected java.lang.String _memberGroupName
protected java.lang.Long _memberGroupOwnerId
protected MemberGroupAccessBean _memberGroupAccessBean
protected java.lang.Long[] _orgEntityIds
protected java.lang.String[] _userIds
protected UserAccessBean[] _users
protected java.lang.String _query
protected boolean _databaseIsDB2
public void setMemberGroupName(java.lang.String memberGroupName)
public void setMemberGroupOwnerId(java.lang.Long memberGroupOwnerId)
public void setMemberGroupAccessBean(MemberGroupAccessBean memberGroupAccessBean)
public void setOrgEntityIds(java.lang.Long[] orgEntityIds)
public java.lang.String[] getUserIds()
public UserAccessBean[] getUsers()
public boolean isReadyToCallExecute()
public void performExecute() throws ECException
protected void constructQuery() throws java.lang.Exception
protected java.lang.String convertToSQL(Condition condition)
protected java.lang.String convertToSQL(TrueCondition condition)
protected java.lang.String convertToSQL(OrListCondition condition)
protected java.lang.String convertToSQL(AndListCondition condition)
protected java.lang.String convertToSQL(SimpleCondition condition)
protected java.lang.String convertToSQL(OpenCondition condition)
protected java.lang.String convertRoleCondition(java.lang.String operator, java.lang.String value, SimpleCondition.Qualifier[] qualifiers)
protected java.lang.String convertStatusCondition(java.lang.String operator, java.lang.String value, SimpleCondition.Qualifier[] qualifiers)
protected java.lang.String convertChildrenCondition(java.lang.String operator, java.lang.String value, SimpleCondition.Qualifier[] qualifiers)
protected java.lang.String convertHouseholdCondition(java.lang.String operator, java.lang.String value, SimpleCondition.Qualifier[] qualifiers)
protected java.lang.String convertRegistrationStatusCondition(java.lang.String operator, java.lang.String value, SimpleCondition.Qualifier[] qualifiers)
protected java.lang.String convertRegistrationDateCondition(java.lang.String operator, java.lang.String value, SimpleCondition.Qualifier[] qualifiers)
protected java.lang.String convertDaysSinceRegistrationCondition(java.lang.String operator, java.lang.String value, SimpleCondition.Qualifier[] qualifiers)
protected java.lang.String convertDaysSinceRegistrationChangeCondition(java.lang.String operator, java.lang.String value, SimpleCondition.Qualifier[] qualifiers)
protected java.lang.String convertRegistrationChangeDateCondition(java.lang.String operator, java.lang.String value, SimpleCondition.Qualifier[] qualifiers)
protected java.lang.String convertGenderCondition(java.lang.String operator, java.lang.String value, SimpleCondition.Qualifier[] qualifiers)
protected java.lang.String convertAgeGroupCondition(java.lang.String operator, java.lang.String value, SimpleCondition.Qualifier[] qualifiers)
protected java.lang.String convertIncomeGroupCondition(java.lang.String operator, java.lang.String value, SimpleCondition.Qualifier[] qualifiers)
protected java.lang.String convertMaritalStatusCondition(java.lang.String operator, java.lang.String value, SimpleCondition.Qualifier[] qualifiers)
protected java.lang.String convertCurrencyCondition(java.lang.String operator, java.lang.String value, SimpleCondition.Qualifier[] qualifiers)
protected java.lang.String convertLanguageCondition(java.lang.String operator, java.lang.String value, SimpleCondition.Qualifier[] qualifiers)
protected java.lang.String convertLocaleCondition(java.lang.String operator, java.lang.String value, SimpleCondition.Qualifier[] qualifiers)
protected java.lang.String convertDaysSinceLastPurchaseCondition(java.lang.String operator, java.lang.String value, SimpleCondition.Qualifier[] qualifiers)
protected java.lang.String convertLastPurchaseDateCondition(java.lang.String operator, java.lang.String value, SimpleCondition.Qualifier[] qualifiers)
protected java.lang.String convertDaysSinceLastVisitCondition(java.lang.String operator, java.lang.String value, SimpleCondition.Qualifier[] qualifiers)
protected java.lang.String convertLastVisitDateCondition(java.lang.String operator, java.lang.String value, SimpleCondition.Qualifier[] qualifiers)
protected java.lang.String convertAmountSpentCondition(java.lang.String operator, java.lang.String value, SimpleCondition.Qualifier[] qualifiers)
protected java.lang.String convertOrdersCondition(java.lang.String operator, java.lang.String value, SimpleCondition.Qualifier[] qualifiers)
protected java.lang.String convertJobFunctionCondition(java.lang.String operator, java.lang.String value, SimpleCondition.Qualifier[] qualifiers)
protected java.lang.String convertAccountCondition(java.lang.String operator, java.lang.String value, SimpleCondition.Qualifier[] qualifiers)
protected java.lang.String convertAccountSizeCondition(java.lang.String operator, java.lang.String value, SimpleCondition.Qualifier[] qualifiers)
protected java.lang.String convertAccountLocationCondition(java.lang.String operator, java.lang.String value, SimpleCondition.Qualifier[] qualifiers)
protected java.lang.String convertAccountCountryCondition(java.lang.String operator, java.lang.String value, SimpleCondition.Qualifier[] qualifiers)
protected java.lang.String convertAccountBusinessCondition(java.lang.String operator, java.lang.String value, SimpleCondition.Qualifier[] qualifiers)
protected java.lang.String convertAccountIndustryCondition(java.lang.String operator, java.lang.String value, SimpleCondition.Qualifier[] qualifiers)
protected java.lang.String convertAccountAmountSpentCondition(java.lang.String operator, java.lang.String value, SimpleCondition.Qualifier[] qualifiers)
protected java.lang.String convertAccountCreditCondition(java.lang.String operator, java.lang.String value, SimpleCondition.Qualifier[] qualifiers)
protected java.lang.String convertCityCondition(java.lang.String operator, java.lang.String value, SimpleCondition.Qualifier[] qualifiers)
protected java.lang.String convertStateCondition(java.lang.String operator, java.lang.String value, SimpleCondition.Qualifier[] qualifiers)
protected java.lang.String convertCountryCondition(java.lang.String operator, java.lang.String value, SimpleCondition.Qualifier[] qualifiers)
protected java.lang.String convertZipCodeCondition(java.lang.String operator, java.lang.String value, SimpleCondition.Qualifier[] qualifiers)
protected java.lang.String convertPhoneCondition(java.lang.String operator, java.lang.String value, SimpleCondition.Qualifier[] qualifiers)
protected java.lang.String convertEMailCondition(java.lang.String operator, java.lang.String value, SimpleCondition.Qualifier[] qualifiers)
protected java.lang.String convertCompanyCondition(java.lang.String operator, java.lang.String value, SimpleCondition.Qualifier[] qualifiers)
protected java.lang.String convertInterestsCondition(java.lang.String operator, java.lang.String value, SimpleCondition.Qualifier[] qualifiers)
protected java.lang.String convertPreferredCommunicationCondition(java.lang.String operator, java.lang.String value, SimpleCondition.Qualifier[] qualifiers)
protected MemberGroupAccessBean resolveCustomerSegmentByOwnerAndName(java.lang.Long memberGroupOwnerId, java.lang.String segmentName) throws java.rmi.RemoteException, javax.ejb.FinderException, javax.naming.NamingException, java.lang.Exception
protected java.lang.String convertSegmentCondition(java.lang.String operator, java.lang.String value, SimpleCondition.Qualifier[] qualifiers)
protected java.lang.String convertMarketingPopulatesCondition(java.lang.String memberGroupId)
protected java.lang.String convertAgeRangeCondition(java.lang.String operator, java.lang.String value, SimpleCondition.Qualifier[] qualifiers)
protected java.lang.String convertOrgCondition(java.lang.String operator, java.lang.String value, SimpleCondition.Qualifier[] qualifiers)
protected java.lang.String convertOrgDNCondition(java.lang.String operator, java.lang.String value, SimpleCondition.Qualifier[] qualifiers)
protected java.lang.String convertRoleListCondition(OpenCondition.Parameter[] parameters)
public void setAdditionalAndCondition(Condition condition)
public void setQueryOnly(boolean flag)
public java.lang.String getQuery()
public void setQueryWrapper(java.lang.String queryWrapper)
public void setMemberGroupIds(java.lang.String[] mbrGrpIds, java.lang.String anyOrAll)