public class WorkArea extends DBPersist
WorkArea
Modifier and Type | Field and Description |
---|---|
static short |
ClassId |
Constructor and Description |
---|
WorkArea()
Create empty WorkArea.
|
WorkArea(JDCConnection oConn,
java.lang.String sIdWorkArea)
Load WorkArea from database
|
Modifier and Type | Method and Description |
---|---|
boolean |
allCaps()
Whether all capitals mode is activated for this WorkArea or not
|
static boolean |
allCaps(java.sql.Connection oConn,
java.lang.String sWorkArea)
Whether all capitals mode is activated for a WorkArea or not
|
boolean |
allowDuplicatedIdentityDocuments()
Whether all capitals mode is activated for this WorkArea or not
|
static boolean |
allowDuplicatedIdentityDocuments(java.sql.Connection oConn,
java.lang.String sWorkArea)
Whether duplicated identity documents are allowed for a WorkArea or not
|
boolean |
autoNumericContactReferences()
Whether autonumeric contact references must be generated
|
static boolean |
autoNumericContactReferences(java.sql.Connection oConn,
java.lang.String sWorkArea)
Whether autonumeric contact references are generated for a WorkArea or not
|
boolean |
delete(JDCConnection oConn)
Delete a WorkArea and all its associated data.
|
static boolean |
delete(JDCConnection oConn,
java.lang.String sWrkAreaGUID)
Delete a WorkArea and all its associated data.
|
static boolean |
delete(JDCConnection oConn,
java.lang.String sWrkAreaGUID,
java.util.Properties oProps)
Delete a WorkArea, its associated data and working directories.
|
static java.lang.String |
getDateFormat(java.sql.Connection oConn,
java.lang.String sWorkAreaGuid)
Get value of tx_date_format column at k_workareas table for given WorkArea
|
static java.lang.String |
getIdFromName(java.sql.Connection oConn,
int iDomainId,
java.lang.String sWorkAreaNm) |
static java.lang.String |
getIdFromName(JDCConnection oConn,
int iDomainId,
java.lang.String sWorkAreaNm) |
static java.lang.String |
getPath(JDCConnection oConn,
java.lang.String sWrkAId)
Get path_logo field from k_workareas table
|
static java.text.SimpleDateFormat |
getSimpleDateFormat(java.sql.Connection oConn,
java.lang.String sWorkAreaGuid)
Get SimpleDateFormat objects based on the values of tx_date_format and id_locale columns from k_workareas table
|
static boolean |
getUserAppAccess(JDCConnection oConn,
java.lang.String guWorkArea,
java.lang.String sUserId,
int idApp)
Checks whether or not a user has access rights for a given WorkArea and Application
|
int |
getUserAppMask(JDCConnection oConn,
java.lang.String sUserId) |
static int |
getUserAppMask(JDCConnection oConn,
java.lang.String guWorkArea,
java.lang.String sUserId)
Get applications bitmask for a user at a given WorkArea
The bitmask is a 32 bits integer with one bit per application.
|
DBSubset |
getUsers(JDCConnection oConn)
Users that may have access to this WorkArea
Get a list of users that have any kind of access to this WorkArea.
|
static boolean |
isAdmin(JDCConnection oConn,
java.lang.String guWorkArea,
java.lang.String sUserId)
Check if given user belongs to the administrators' group of a WorkArea
|
static boolean |
isAnyRole(JDCConnection oConn,
java.lang.String guWorkArea,
java.lang.String sUserId)
Check if given user belongs to any permissions group associated with a WorkArea
This is equivalent to doing [isAdmin() Or isPowerUser() Or isUser() Or isGuest()]
but faster to compute than the previous expresion
|
static boolean |
isGuest(JDCConnection oConn,
java.lang.String guWorkArea,
java.lang.String sUserId)
Check if given user belongs to the guests' group of a WorkArea
|
static boolean |
isPowerUser(JDCConnection oConn,
java.lang.String guWorkArea,
java.lang.String sUserId)
Check if given user belongs to the power users' group of a WorkArea
|
static boolean |
isUser(JDCConnection oConn,
java.lang.String guWorkArea,
java.lang.String sUserId)
Check if given user belongs to the users' group of a WorkArea
|
boolean |
store(JDCConnection oConn)
Store a register at database representing this instance of DBPersist
Insertions and updates : The store method automatically manages
register insertions and updates.
|
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, 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 WorkArea()
public WorkArea(JDCConnection oConn, java.lang.String sIdWorkArea) throws java.sql.SQLException
oConn
- Database ConenctionsIdWorkArea
- GUID of WorkArea to be loadedjava.sql.SQLException
public boolean delete(JDCConnection oConn) throws java.sql.SQLException
Delete a WorkArea and all its associated data.
USE THIS METHOD WITH EXTREME CARE. AS IT WILL DELETE DATA FROM EVERY TABLE CONTAINING A gu_workarea COLUMN MATCHING THE DELETED WORKAREA GUID.public boolean store(JDCConnection oConn) throws java.sql.SQLException
DBPersist
Store a register at database representing this instance of DBPersist
Insertions and updates : The store method automatically manages register insertions and updates. If the stored object already exists at database then it is updated, if it does not exists then it is inserted. A primary key violation error is never thrown so ther is no need to call delete() method before re-writing an existing object.
NULL fields : All values not set calling put() methods for DBPersist
will be assumed to be NULL. If a not nullable field is not set then an
SQLException will be raised.
On storing an already existing object all values will we overwrited,
so is a DBPersist is not fully loaded before storing it, values not set
by calling put() methods that already were present at database will be lost.
public int getUserAppMask(JDCConnection oConn, java.lang.String sUserId) throws java.sql.SQLException
java.sql.SQLException
public DBSubset getUsers(JDCConnection oConn) throws java.sql.SQLException
Users that may have access to this WorkArea
Get a list of users that have any kind of access to this WorkArea. The list is taken by querying k_x_group_user table looking for users that belong to any of the five permissions groups of the WorkArea {admins,powusers,users,guests,other}java.sql.SQLException
public static boolean delete(JDCConnection oConn, java.lang.String sWrkAreaGUID) throws java.sql.SQLException
Delete a WorkArea and all its associated data.
USE THIS METHOD WITH EXTREME CARE. AS IT WILL DELETE DATA FROM EVERY TABLE CONTAINING A gu_workarea COLUMN MATCHING THE DELETED WORKAREA GUID.k_activities |
k_x_activity_audience |
DELETE k_sms_audit |
DELETE k_sms_audit |
DELETE k_syndentries |
DELETE k_x_portlet_user |
QueryByForm.delete |
MicrositeDB.delete |
PageSetDB.delete |
DELETE k_images |
DELETE k_global_black_list |
DistributionList.delete |
Meeting.delete |
Fellow.delete |
DELETE k_lu_fellow_titles |
DELETE k_fellows_lookup |
Room.delete |
DELETE k_rooms_lookup |
DELETE k_to_do |
DELETE k_to_do_lookup |
DELETE k_phone_calls |
DELETE k_sales_men |
DELETE k_sales_men_lookup |
DELETE k_bulkloads |
Supplier.delete |
Company.delete |
DELETE k_companies_lookup |
DELETE k_contacts_lookup |
DELETE k_oportunities_lookup |
DELETE k_welcome_packs_lookup |
Project.delete |
DELETE k_projects_lookup |
DELETE k_duties_lookup |
DELETE k_bugs_lookup |
DELETE k_invoices |
DELETE k_invoice_lines |
DELETE k_invoices_lookup |
DELETE k_invoices_next |
DELETE k_returned_invoices |
DELETE k_x_order_invoices |
DELETE k_despatch_advices |
DELETE k_despatch_lines |
DELETE k_despatch_advices_lookup |
DELETE k_x_orders_despatch |
DELETE k_despatch_next |
DELETE k_orders |
DELETE k_order_lines |
DELETE k_orders_lookup |
DELETE k_quotations |
DELETE k_quotation_lines |
DELETE k_x_quotations_orders |
DELETE k_quotation_next |
DELETE k_warehouses |
DELETE k_sale_points |
DELETE k_lu_business_states |
DELETE k_business_states |
Shop.delete |
DELETE k_events |
Job.delete |
DELETE k_lu_meta_attrs |
DELETE k_addresses |
DELETE k_addresses_lookup |
DELETE k_thesauri_lookup |
DELETE k_bank_accounts |
DELETE k_bank_accounts_lookup |
DELETE k_urls |
DELETE k_x_app_workarea |
DELETE k_workareas |
oConn
- Database ConnectionsWrkAreaGUID
- GUID of WorkArea to be deleted.java.sql.SQLException
public boolean allCaps()
public boolean allowDuplicatedIdentityDocuments()
public boolean autoNumericContactReferences()
public static boolean allCaps(java.sql.Connection oConn, java.lang.String sWorkArea) throws java.sql.SQLException
oConn
- ConnectionsWorkArea
- String WorkArea GUIDjava.sql.SQLException
public static boolean allowDuplicatedIdentityDocuments(java.sql.Connection oConn, java.lang.String sWorkArea) throws java.sql.SQLException
oConn
- ConnectionsWorkArea
- String WorkArea GUIDjava.sql.SQLException
public static boolean autoNumericContactReferences(java.sql.Connection oConn, java.lang.String sWorkArea) throws java.sql.SQLException
oConn
- ConnectionsWorkArea
- String WorkArea GUIDjava.sql.SQLException
public static boolean delete(JDCConnection oConn, java.lang.String sWrkAreaGUID, java.util.Properties oProps) throws java.lang.Exception, java.io.IOException, java.sql.SQLException
Delete a WorkArea, its associated data and working directories.
USE THIS METHOD WITH EXTREME CARE. AS IT WILL DELETE DATA FROM EVERY TABLE CONTAINING A gu_workarea COLUMN MATCHING THE DELETED WORKAREA GUID.oConn
- Database ConnectionsWrkAreaGUID
- GUID of WorkArea to be deletedoProps
- Properties Colection containing "storage" and "workareasput" properties.java.io.IOException
java.sql.SQLException
java.lang.Exception
com.knowgate.dfs.FileSystem.delete(String)
public static java.lang.String getPath(JDCConnection oConn, java.lang.String sWrkAId) throws java.sql.SQLException
oConn
- JDCConnectionsWrkAId
- String GUID of WorkAreajava.sql.SQLException
public static boolean isAdmin(JDCConnection oConn, java.lang.String guWorkArea, java.lang.String sUserId) throws java.sql.SQLException
Check if given user belongs to the administrators' group of a WorkArea
oConn
- JDCConnectionguWorkArea
- String GUID of WorkAreasUserId
- GUID of Userjava.sql.SQLException
public static boolean isPowerUser(JDCConnection oConn, java.lang.String guWorkArea, java.lang.String sUserId) throws java.sql.SQLException
Check if given user belongs to the power users' group of a WorkArea
oConn
- JDCConnectionguWorkArea
- String GUID of WorkAreasUserId
- GUID of Userjava.sql.SQLException
public static boolean isUser(JDCConnection oConn, java.lang.String guWorkArea, java.lang.String sUserId) throws java.sql.SQLException
Check if given user belongs to the users' group of a WorkArea
oConn
- JDCConnectionguWorkArea
- String GUID of WorkAreasUserId
- GUID of Userjava.sql.SQLException
public static boolean isGuest(JDCConnection oConn, java.lang.String guWorkArea, java.lang.String sUserId) throws java.sql.SQLException
Check if given user belongs to the guests' group of a WorkArea
oConn
- JDCConnectionguWorkArea
- String GUID of WorkAreasUserId
- GUID of Userjava.sql.SQLException
public static boolean isAnyRole(JDCConnection oConn, java.lang.String guWorkArea, java.lang.String sUserId) throws java.sql.SQLException
Check if given user belongs to any permissions group associated with a WorkArea
This is equivalent to doing [isAdmin() Or isPowerUser() Or isUser() Or isGuest()] but faster to compute than the previous expresionoConn
- JDCConnectionguWorkArea
- String GUID of WorkAreasUserId
- GUID of Userjava.sql.SQLException
public static int getUserAppMask(JDCConnection oConn, java.lang.String guWorkArea, java.lang.String sUserId) throws java.sql.SQLException
Get applications bitmask for a user at a given WorkArea
The bitmask is a 32 bits integer with one bit per application. A bit set to one means that the application is available for the user, if it s set to zero then the application is not available. Applications bits positions are as follows:Bit Number | Application Name |
10 | Incidents Tracker |
11 | Duty Manager |
12 | Project Manager |
13 | Mailwire |
14 | Web Builder |
15 | Virtual Disk |
16 | Contact & Sales Management |
17 | Collaborative Tools |
18 | Marketing Tools |
19 | Directory |
20 | Shop |
21 | Hipermail |
22 | Training |
23 | Wiki |
24 | Passwords Manager |
25 | Surveys |
30 | Configuration & Administration |
java.sql.SQLException
public static boolean getUserAppAccess(JDCConnection oConn, java.lang.String guWorkArea, java.lang.String sUserId, int idApp) throws java.sql.SQLException
Checks whether or not a user has access rights for a given WorkArea and Application
oConn
- JDBC database connectionguWorkArea
- WorkArea GUIDisApp
- Application Identifierjava.sql.SQLException
public static java.lang.String getIdFromName(JDCConnection oConn, int iDomainId, java.lang.String sWorkAreaNm) throws java.sql.SQLException
java.sql.SQLException
public static java.lang.String getIdFromName(java.sql.Connection oConn, int iDomainId, java.lang.String sWorkAreaNm) throws java.sql.SQLException
java.sql.SQLException
public static java.lang.String getDateFormat(java.sql.Connection oConn, java.lang.String sWorkAreaGuid) throws java.sql.SQLException
oConn
- JDBC database connectionsWorkAreaGuid
- WorkArea GUIDjava.sql.SQLException
public static java.text.SimpleDateFormat getSimpleDateFormat(java.sql.Connection oConn, java.lang.String sWorkAreaGuid) throws java.sql.SQLException
Get SimpleDateFormat objects based on the values of tx_date_format and id_locale columns from k_workareas table
oConn
- JDBC database connectionsWorkAreaGuid
- WorkArea GUIDjava.sql.SQLException