public class Address extends DBPersist
Address
A generic postal address object for being associated to any other objects that may require address information.Modifier and Type | Field and Description |
---|---|
static short |
ClassId |
Constructor and Description |
---|
Address()
Create empty Address
|
Address(JDCConnection oConn,
java.lang.String guAddr)
Load Address from database
|
Modifier and Type | Method and Description |
---|---|
static boolean |
addLookupState(java.sql.Connection oConn,
java.lang.String sGuWorkArea,
java.lang.String sIdCountry,
java.lang.String sNmState,
java.util.HashMap<java.lang.String,java.lang.String> oTranslations)
Add a State for a given country at k_addresses_lookup table
This methods checks whether the given State Name exists at k_addresses_lookup
for a given country and, if not, then inserts it.
|
static boolean |
addLookupStreetType(java.sql.Connection oConn,
java.lang.String sGuWorkArea,
java.lang.String sTpStreet,
java.util.HashMap<java.lang.String,java.lang.String> oTranslations)
Add a Street Type lookup value
|
boolean |
delete(JDCConnection oConn)
Delete Address
Registers at k_welcome_packs, k_x_company_addr, k_x_contact_addr, k_meetings, k_sms_audit, k_activities, k_x_activity_audience are deleted on cascade
|
static DBSubset |
getAddressesByCompanyName(JDCConnection oConn,
java.lang.String sCompanyNm,
java.lang.String sWorkArea)
Get addresses given their company name
This method difers from Company.getAddresses()
in that getAddresses() takes the Company GUID
and makes a query into k_x_company_addr table.
|
static java.lang.String |
getIdFromEmail(JDCConnection oConn,
java.lang.String sEMail,
java.lang.String sWorkArea)
Get Address Unique Id. from its e-mail.
|
boolean |
load(JDCConnection oConn,
java.lang.Object[] PKVals)
Load values set at table k_addresses
This method trims the value of id_country column and loads the translated value for street type
|
boolean |
load(JDCConnection oConn,
java.lang.String sGuAddress)
Load values set at table k_addresses
This method trims the value of id_country column
|
static int |
nextLocalIndex(java.sql.Connection oConn,
java.lang.String sLinkTable,
java.lang.String sLinkField,
java.lang.String sLinkValue)
Get next free address index for a given object.
|
boolean |
store(JDCConnection oConn)
Store Address
If gu_address is null a new GUID is automatically assigned.
|
java.lang.String |
toLocaleString()
Get Address as a single plain text line using country as locale
|
java.lang.String |
toLocaleString(java.lang.String sCountryId)
Get Address as a single plain text line using the given locale
|
java.lang.String |
toXML()
Get an XML dump for the DBPersist values.
|
java.lang.String |
toXML(java.lang.String sIdent)
Get an XML dump for the DBPersist values.
|
java.lang.String |
toXML(java.lang.String sIdent,
java.lang.String sDelim)
Get an XML dump for the DBPersist values
|
allcaps, allcaps, clear, clone, columns, containsKey, containsValue, entrySet, exists, get, get, getAuditClassName, getCreationDate, getDate, getDate, getDateFormated, getDateShort, getDateTime, getDateTime24, getDecimal, getDecimalFormated, getDecimalFormated, getDouble, getDoubleFormated, getFloat, getFloatFormated, getInt, getIntArray, getInteger, getIntegerArray, getIntervalPart, getItemMap, getItems, getMoney, getPrimaryKey, getShort, getSQLDate, getSQLTime, getString, getStringHtml, getStringNull, getTable, getTable, getTime, getTimeOfDay, getTimestamp, isEmpty, isNull, iterator, keySet, parseXML, put, put, put, put, put, put, put, put, put, put, put, put, put, put, put, put, put, put, put, put, put, put, put, putAll, putAll, remove, remove, replace, replace, replace, replace, replace, replace, replace, replace, setAuditTransact, setAuditUser, setCreationDate, setPrimaryKey, size, toLowerCase, toUpperCase, values
public static final short ClassId
public Address()
public Address(JDCConnection oConn, java.lang.String guAddr) throws java.sql.SQLException
oConn
- Database ConnectionguAddr
- GUID of address to be loadedjava.sql.SQLException
public boolean load(JDCConnection oConn, java.lang.Object[] PKVals) throws java.sql.SQLException
Load values set at table k_addresses
This method trims the value of id_country column and loads the translated value for street typepublic boolean load(JDCConnection oConn, java.lang.String sGuAddress) throws java.sql.SQLException
Load values set at table k_addresses
This method trims the value of id_country columnpublic boolean delete(JDCConnection oConn) throws java.sql.SQLException
Delete Address
Registers at k_welcome_packs, k_x_company_addr, k_x_contact_addr, k_meetings, k_sms_audit, k_activities, k_x_activity_audience are deleted on cascadepublic boolean store(JDCConnection oConn) throws java.sql.SQLException
Store Address
If gu_address is null a new GUID is automatically assigned.public java.lang.String toLocaleString(java.lang.String sCountryId)
Get Address as a single plain text line using the given locale
sCountryId
- 2 letters identifier for country locale.
Currently format are supported for us, gb, uk, es, fr, and itpublic java.lang.String toLocaleString()
Get Address as a single plain text line using country as locale
public java.lang.String toXML(java.lang.String sIdent, java.lang.String sDelim) throws java.lang.IllegalStateException
Get an XML dump for the DBPersist values
public java.lang.String toXML(java.lang.String sIdent)
Get an XML dump for the DBPersist values.
Lines are delimited by a single Line Feed CHR(10) '\n' character.
public java.lang.String toXML()
Get an XML dump for the DBPersist values.
No left padding is placed to the left of each line.
Lines are delimited by a single Line Feed CHR(10) '\n' character.
public static int nextLocalIndex(java.sql.Connection oConn, java.lang.String sLinkTable, java.lang.String sLinkField, java.lang.String sLinkValue) throws java.sql.SQLException
Get next free address index for a given object.
Address indexes are integers assigned on a per object basis.oConn
- Database ConnectionsLinkTable
- Table used for linking addresses to instances of objects
of a given class (for example "k_x_company_addr" or "k_x_contact_addr").sLinkField
- Foreign object column name at link table (for example "gu_company" or "gu_contact")sLinkValue
- Value for foreign object GUIDjava.sql.SQLException
public static java.lang.String getIdFromEmail(JDCConnection oConn, java.lang.String sEMail, java.lang.String sWorkArea) throws java.sql.SQLException
Get Address Unique Id. from its e-mail.
oConn
- Database ConnectionsEMail
- Address e-mail (tx_email from k_addresses table)sWorkArea
- WorkArea filter. If null all WorkAreas are seachedjava.sql.SQLException
public static boolean addLookupState(java.sql.Connection oConn, java.lang.String sGuWorkArea, java.lang.String sIdCountry, java.lang.String sNmState, java.util.HashMap<java.lang.String,java.lang.String> oTranslations) throws java.sql.SQLException
Add a State for a given country at k_addresses_lookup table
This methods checks whether the given State Name exists at k_addresses_lookup for a given country and, if not, then inserts it.oConn
- ConnectionsGuWorkArea
- String GUID of WorkAreasIdCountry
- String Two letters country identifier from k_lu_countries tablesNmState
- String Language Neutral State Name or CodeoTranslations
- HashMap with one entry for each language
Language codes must be those from id_language column of k_lu_languages table.java.sql.SQLException
public static boolean addLookupStreetType(java.sql.Connection oConn, java.lang.String sGuWorkArea, java.lang.String sTpStreet, java.util.HashMap<java.lang.String,java.lang.String> oTranslations) throws java.sql.SQLException
Add a Street Type lookup value
oConn
- ConnectionsGuWorkArea
- String GUID of WorkAreasTpStreet
- String Street Type Internal ValueoTranslations
- HashMap with one entry for each languagejava.sql.SQLException
public static DBSubset getAddressesByCompanyName(JDCConnection oConn, java.lang.String sCompanyNm, java.lang.String sWorkArea) throws java.sql.SQLException
Get addresses given their company name
This method difers from Company.getAddresses() in that getAddresses() takes the Company GUID and makes a query into k_x_company_addr table. getAddressesForCompany() instead tests the value of nm_company column at k_addresses table.oConn
- ConnectionsCompanyNm
- String Exact Company Name (case sensitive)sWorkArea
- String GUID of WorkArea where to searchjava.sql.SQLException