public class Company extends DBPersist
Company
Copyright: Copyright (c) KnowGate 2003
Modifier and Type | Field and Description |
---|---|
static short |
ClassId |
Constructor and Description |
---|
Company()
Create Empty Company.
|
Company(JDCConnection oConn,
java.lang.String sCompanyId)
Create Company and load fields from database.
|
Company(java.lang.String sCompanyId)
Create Company and set gu_company field.
|
Modifier and Type | Method and Description |
---|---|
boolean |
addAddress(JDCConnection oConn,
java.lang.String sAddrGUID)
Add an Address to this Company
If contact is already associated to the given address a foreign key violation
SQLExceception is raised.
|
boolean |
addBankAccount(JDCConnection oConn,
java.lang.String sFullBankAccount)
Add a bank account to this Company
If company is already associated to the given bank account then a foreign key violation SQLException is thrown
|
static boolean |
addLookupCompanyType(java.sql.Connection oConn,
java.lang.String sGuWorkArea,
java.lang.String sIdType,
java.util.HashMap oTranslations)
Add a Company Type lookup value
|
static boolean |
addLookupSector(java.sql.Connection oConn,
java.lang.String sGuWorkArea,
java.lang.String sIdSector,
java.util.HashMap oTranslations)
Add a Company Sector lookup value
|
int |
addToACLGroups(JDCConnection oConn,
java.lang.String sGroupList)
Add Company to a set of security restrictions groups.
|
int |
clearACLGroups(JDCConnection oConn)
Remove company from all security restrictions groups
|
boolean |
delete(JDCConnection oConn)
Delete Company
|
static boolean |
delete(JDCConnection oConn,
java.lang.String sCompanyGUID)
Delete Company.
|
boolean |
exists(JDCConnection oConn)
Find out whether or not a company exists at database
Look up company by GUID or by legal name and work area.
|
static Company |
forAddress(JDCConnection oConn,
java.lang.String sGuAddr) |
DBSubset |
getActiveAddresses(JDCConnection oConn)
Get Company Addresses
|
DBSubset |
getActiveBankAccounts(JDCConnection oConn)
Get active bank accounts for this Company
|
Address |
getAddress(JDCConnection oConn,
java.lang.String sTpLocation)
Get address by location type
|
DBSubset |
getAddresses(JDCConnection oConn)
Get Company Addresses
|
DBSubset |
getAllBankAccounts(JDCConnection oConn)
Get all bank accounts associated with Company
|
DBSubset |
getGroups(JDCConnection oConn)
Get groups that may have access to this company.
|
static java.lang.String |
getIdFromLegalNum(java.sql.Connection oConn,
java.lang.String sLegalId,
java.lang.String sWorkArea)
Get company GUID given its legal number
|
static java.lang.String |
getIdFromName(java.sql.Connection oConn,
java.lang.String sLegalName,
java.lang.String sWorkArea)
Get company GUID given its legal name
|
static java.lang.String |
getIdFromRef(java.sql.Connection oConn,
java.lang.String sReference,
java.lang.String sWorkArea)
Get company GUID given its external reference
|
DBSubset |
getUnactiveBankAccounts(JDCConnection oConn)
Get unactive bank accounts for this Company
|
int |
removeFromACLGroup(JDCConnection oConn,
java.lang.String sIdGroup)
Remove Company from security restrictions group.
|
boolean |
store(JDCConnection oConn)
Store Company
Automatically generates gu_company GUID and dt_modified DATE if not explicitly set.
|
java.lang.String |
toXML(JDCConnection oConn,
java.lang.String sIdent,
java.lang.String sDelim)
Get an XML dump for Company and its associated addresses
|
allcaps, allcaps, clear, clone, columns, containsKey, containsValue, entrySet, 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, load, load, 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, toXML, toXML, toXML, values
public static final short ClassId
public Company()
public Company(java.lang.String sCompanyId)
sCompanyId
- Company GUIDpublic Company(JDCConnection oConn, java.lang.String sCompanyId) throws java.sql.SQLException
oConn
- JDCConnectionsCompanyId
- Company GUIDjava.sql.SQLException
public DBSubset getGroups(JDCConnection oConn) throws java.sql.SQLException
oConn
- Database ConnectionDBSubset
with a 1 column containing each group unique identifier (gu_acl_group).java.sql.SQLException
public int addToACLGroups(JDCConnection oConn, java.lang.String sGroupList) throws java.sql.SQLException
Add Company to a set of security restrictions groups.
Insert new registers at k_x_group_company table.
oConn
- Database ConnectionsGroupList
- A string of comma delimited ACLGroup GUIDs to with this ACLUser must be added.java.sql.SQLException
- May throw a primary key constraint violation if company already belongs to group.public int clearACLGroups(JDCConnection oConn) throws java.sql.SQLException
Remove company from all security restrictions groups
oConn
- Database Connectionjava.sql.SQLException
public int removeFromACLGroup(JDCConnection oConn, java.lang.String sIdGroup) throws java.sql.SQLException
Remove Company from security restrictions group.
remove register from k_x_group_user table.
oConn
- Database ConnectionsIdGroup
- Group Unique Identifier.java.sql.SQLException
public boolean addBankAccount(JDCConnection oConn, java.lang.String sFullBankAccount) throws java.sql.SQLException
Add a bank account to this Company
If company is already associated to the given bank account then a foreign key violation SQLException is thrownoConn
- Database Connectionjava.sql.SQLException
public DBSubset getAllBankAccounts(JDCConnection oConn) throws java.sql.SQLException, java.lang.IllegalStateException
oConn
- JDCConnectionjava.sql.SQLException
java.lang.IllegalStateException
- if gu_company or gu_workarea are not setpublic DBSubset getActiveBankAccounts(JDCConnection oConn) throws java.sql.SQLException, java.lang.IllegalStateException
oConn
- JDCConnectionjava.sql.SQLException
java.lang.IllegalStateException
- if gu_company or gu_workarea are not setpublic DBSubset getUnactiveBankAccounts(JDCConnection oConn) throws java.sql.SQLException, java.lang.IllegalStateException
oConn
- JDCConnectionjava.sql.SQLException
java.lang.IllegalStateException
- if gu_company or gu_workarea are not setpublic boolean store(JDCConnection oConn) throws java.sql.SQLException
public boolean delete(JDCConnection oConn) throws java.sql.SQLException
public boolean exists(JDCConnection oConn) throws java.sql.SQLException
Find out whether or not a company exists at database
Look up company by GUID or by legal name and work area.public boolean addAddress(JDCConnection oConn, java.lang.String sAddrGUID) throws java.sql.SQLException
Add an Address to this Company
If contact is already associated to the given address a foreign key violation SQLExceception is raised.oConn
- Database Connectionjava.sql.SQLException
public Address getAddress(JDCConnection oConn, java.lang.String sTpLocation) throws java.sql.SQLException, java.lang.IllegalStateException
oConn
- JDCConnectionsTpLocation
- String Value for column tp_location from k_addresses tablejava.sql.SQLException
java.lang.IllegalStateException
- if gu_company property is not setpublic DBSubset getAddresses(JDCConnection oConn) throws java.sql.SQLException, java.lang.IllegalStateException
Get Company Addresses
oConn
- Database Connectionjava.sql.SQLException
java.lang.IllegalStateException
- if gu_company property is not setpublic DBSubset getActiveAddresses(JDCConnection oConn) throws java.sql.SQLException, java.lang.IllegalStateException
Get Company Addresses
oConn
- Database Connectionjava.sql.SQLException
java.lang.IllegalStateException
- if gu_company property is not setpublic java.lang.String toXML(JDCConnection oConn, java.lang.String sIdent, java.lang.String sDelim) throws java.lang.IllegalStateException, java.sql.SQLException
Get an XML dump for Company and its associated addresses
sIdent
- Number of blank spaces for left padding at every line.sDelim
- Line delimiter (usually "\n" or "\r\n")java.lang.IllegalStateException
- If XML method is invoked before Company object is loadedjava.sql.SQLException
public static boolean delete(JDCConnection oConn, java.lang.String sCompanyGUID) throws java.sql.SQLException
Delete Company.
Delete all associated contacts and call k_sp_del_company stored procedure.oConn
- Database ConnectionsCompanyGUID
- Company GUIDjava.sql.SQLException
public static boolean addLookupSector(java.sql.Connection oConn, java.lang.String sGuWorkArea, java.lang.String sIdSector, java.util.HashMap oTranslations) throws java.sql.SQLException
Add a Company Sector lookup value
oConn
- ConnectionsGuWorkArea
- String GUID of WorkAreasDeTitle
- String Sector Internal IdentifieroTranslations
- HashMap with one entry for each languagejava.sql.SQLException
public static boolean addLookupCompanyType(java.sql.Connection oConn, java.lang.String sGuWorkArea, java.lang.String sIdType, java.util.HashMap oTranslations) throws java.sql.SQLException
Add a Company Type lookup value
oConn
- ConnectionsGuWorkArea
- String GUID of WorkAreasDeTitle
- String Company Type Internal IdentifieroTranslations
- HashMap with one entry for each languagejava.sql.SQLException
public static java.lang.String getIdFromName(java.sql.Connection oConn, java.lang.String sLegalName, java.lang.String sWorkArea) throws java.sql.SQLException
Get company GUID given its legal name
oConn
- ConnectionsLegalName
- String Legal name of sought CompanysWorkArea
- String GUID of WorkArea where to searchjava.sql.SQLException
public static java.lang.String getIdFromRef(java.sql.Connection oConn, java.lang.String sReference, java.lang.String sWorkArea) throws java.sql.SQLException
Get company GUID given its external reference
oConn
- ConnectionsLegalName
- String External reference of sought CompanysWorkArea
- String GUID of WorkArea where to searchjava.sql.SQLException
public static java.lang.String getIdFromLegalNum(java.sql.Connection oConn, java.lang.String sLegalId, java.lang.String sWorkArea) throws java.sql.SQLException
Get company GUID given its legal number
oConn
- ConnectionsLegalName
- String Legal Number of sought CompanysWorkArea
- String GUID of WorkArea where to searchjava.sql.SQLException
public static Company forAddress(JDCConnection oConn, java.lang.String sGuAddr) throws java.sql.SQLException
java.sql.SQLException