| java.lang.Object
 com.knowgate.crm.ListMember
| ListMember | | public class ListMember (Code) | | List Member
List Members are kept at database differently depending on the type of list
they belong to.
For Members of Dynamic Lists (k_lists.tp_list=2) no member record is explicitly
stored at database, but members are dynamically extracted from k_member_address
view each time that the DistributionList is used.
For Members of Static Lists (k_lists.tp_list=1) a record is stored at
k_x_list_members table. Members of Static Lists can be Companies from k_companies
table of Contacts from k_contacts table. If Member is a Company then tp_member is
set to 91 and gu_company is set to Company GUID. If Member is a Contact then
tp_member is set to 90 and gu_contact is set to Contact GUID.
For Members of Direct and Black Lists (k_lists.tp_list=3 and k_lists.tp_list=4)
tp_member is set to 95. One record is stored at k_x_list_members table and
another record is stored at k_list_members. There is one unique record per
Member at k_list_members and one record per member and list at k_x_list_members.
List Member Storage Summary
| List Type | k_lists.tp_member | k_x_list_member.gu_contact | k_x_list_member.gu_company | k_list_member.gu_member |
| DYNAMIC | 90 or 91 | NONE | NONE | NONE |
| STATIC | 90 or 91 | References k_contacts if tp_member=90 | References k_companies if tp_member=91 | NONE |
| DIRECT | 95 | References k_list_members | NULL | Member GUID |
author:
Sergio Montoro Ten
version:
2.0 |
| Field Summary | |
| final public static short | ClassId
|
| Method Summary | |
| public void | block(JDCConnection oConn, String sListGUID)
| | public boolean | delete(JDCConnection oConn, String sListId)
Remove Member from a DistributionList.
Member is also removed from associated black list. | | public boolean | delete(JDCConnection oConn)
Remove Member from all DistributionList. | | public java.util.Date | getDate(String sKey)
| | public String | getDateFormated(String sKey, String sFormat)
| | public short | getShort(String sKey)
| | public String | getString(String sKey)
| | public String | getStringNull(String sKey, String sDefault)
| | public boolean | isBlocked(JDCConnection oConn)
| | public boolean | isNull(String sColumnName)
| | public DBPersist | member()
Internal DBPersist object reference for k_list_members register. | | public void | put(String sKey, String sVal)
| | public void | put(String sKey, short iVal)
| | public void | put(String sKey, java.util.Date dtVal)
| | public void | put(String sKey, Object oObj)
| | public void | remove(String sKey)
| | public void | replace(String sKey, Object oObj)
| | public void | replace(String sKey, short iVal)
| | public boolean | store(JDCConnection oConn, String sListGUID)
| | public void | unblock(JDCConnection oConn, String sListGUID)
|
| ClassId | | final public static short ClassId(Code) | | |
| ListMember | | public ListMember()(Code) | | |
| ListMember | | public ListMember(JDCConnection oConn, String sMemberId, String sListGUID) throws SQLException(Code) | | Create ListMember and load its fields from database.
ListMember with given GUID or e-amil is seeked at k_x_list_members table.
Parameters:
oConn - Database Connection
Parameters:
sMemberId - One of: GUID for Contact, GUID for Company or Member e-mail.
Parameters:
sListGUID - DistributionList GUID
throws:
SQLException - |
| delete | | public boolean delete(JDCConnection oConn, String sListId) throws SQLException(Code) | | Remove Member from a DistributionList.
Member is also removed from associated black list.
Parameters:
oConn - Database Connection
Parameters:
sListId - GUID of DistributionList from witch Member is to be removed.
throws:
SQLException - |
| isBlocked | | public boolean isBlocked(JDCConnection oConn) throws SQLException(Code) | | Get whether or not a List Member is Blocked
Blocked Members are those present on the associated black list.
Companies and Contacts are considered to be in the black list if its
gu_company or gu_contact is into black list register at k_x_list_members
Direct List Members are considered to be in the black list if its
tx_email is into black list register at k_x_list_members
This way, by searching Companies and Contacts by GUID and Direct Members by
e-mail, a Contact or Company may have several e-mail addresses all of them
blocked by a single black list entry.
This method calls stored procedures: k_sp_company_blocked, k_sp_contact_blocked and k_sp_email_blocked
Parameters:
oConn - Database Connection true if member is blocked (present at associated black list for this list) false otherwise.
throws:
SQLException - |
| member | | public DBPersist member()(Code) | | Internal DBPersist object reference for k_list_members register.
|
| unblock | | public void unblock(JDCConnection oConn, String sListGUID) throws SQLException(Code) | | Unblock Member
Remove member from Black List associated to Base List.
Parameters:
oConn - Database Connection
Parameters:
sListGUID - Base List GUID
throws:
SQLException - |
|
|