Class ParamValueDAO

java.lang.Object

ru.bgcrm.dao.CommonDAO

org.bgerp.dao.param.ParamValueDAO

Direct Known Subclasses:

ParamValueDAO

public class ParamValueDAO
extends CommonDAO

Parameter values DAO. The primary required public methods are sorted alphabetically. Dependency methods even public, called by those, are placed directly after the first usage.

Nested Class Summary

Nested classes/interfaces inherited from class CommonDAO

CommonDAO.ObjectExtractor<T>, CommonDAO.RecordUpdater<T>

Field Summary

Fields

Modifier and Type	Field	Description
static final String	COPY_PARAMS_SEPARATORS
static final String[]	TABLE_NAMES

Fields inherited from class CommonDAO

con, SQL_AND, SQL_DELETE, SQL_DELETE_FROM, SQL_DESC, SQL_DISTINCT, SQL_FROM, SQL_GROUP_BY, SQL_INNER_JOIN, SQL_INSERT_IGNORE_INTO, SQL_INSERT_INTO, SQL_LEFT_JOIN, SQL_LIMIT, SQL_ON_DUP_KEY_UPDATE, SQL_ORDER_BY, SQL_REPLACE, SQL_SELECT, SQL_SELECT_ALL_FROM, SQL_SELECT_COUNT_ROWS, SQL_SET, SQL_UNION_ALL, SQL_UPDATE, SQL_VALUES, SQL_VALUES_1, SQL_VALUES_2, SQL_VALUES_3, SQL_VALUES_4, SQL_VALUES_5, SQL_WHERE

Constructor Summary

Constructors

Constructor	Description
ParamValueDAO(Connection con)
ParamValueDAO(Connection con, boolean history, int userId)

Method Summary

Modifier and Type	Method	Description
void	copyParam(int fromObjectId, int toObjectId, int paramId)	Copies a parameter from an object to an object
void	copyParam(int fromObjectId, int fromParamId, int toObjectId, int toParamId)	Copies a parameter from an object to an object.
void	copyParams(int fromObjectId, int toObjectId, String copyMapping)	Copies parameters from an object to another object according to the given configuration
void	copyParams(int fromObjectId, int toObjectId, Collection<Integer> paramIds)	Copies parameters from an object to an object
void	deleteParams(String objectType, int id)	Deletes object's parameters
SortedMap<Integer, ParameterAddressValue>	getParamAddress(int id, int paramId)	Returns values of an object's address parameter
SortedMap<Integer, ParameterAddressValue>	getParamAddress(int id, int paramId, boolean loadDirs)	Returns values of an object's address parameter
SortedMap<Integer, ParameterAddressValue>	getParamAddress(int id, int paramId, boolean loadDirs, String formatName)	Returns values of an object's address parameter
ParameterAddressValue	getParamAddress(int id, int paramId, int position)	Returns an object's address parameter
String	getParamBlob(int id, int paramId)	Selects a value for parameter type 'blob'
Date	getParamDate(int id, int paramId)	Selects a value for parameter type 'date'
Date	getParamDateTime(int id, int paramId)	Selects a value for parameter type 'datetime'
SortedMap<Integer, ParameterEmailValue>	getParamEmail(int id, int paramId)	Selects values for parameter type 'email'
ParameterEmailValue	getParamEmail(int id, int paramId, int position)	Deprecated.
SortedMap<Integer,FileData>	getParamFile(int id, int paramId)	Selects values for parameter type 'file'
FileData	getParamFile(int id, int paramId, int position)	Selects a value for parameter type 'file'
Set<Integer>	getParamList(int id, int paramId)	Selects a parameter value with type 'list'
Map<Integer, BigDecimal>	getParamListCount(int id, int paramId)	Selects a parameter value with type 'listcount'
List<IdTitle>	getParamListCountWithTitles(int id, int paramId)	Deprecated.
Map<Integer,String>	getParamListWithComments(int id, int paramId)	Selects a parameter value with type 'list' with value comments
List<IdTitle>	getParamListWithTitles(int id, int paramId)	Deprecated.
List<IdTitleComment>	getParamListWithTitlesAndComments(int id, int paramId)	Deprecated.
BigDecimal	getParamMoney(int id, int paramId)	Selects a parameter value with type 'money'
ParameterPhoneValue	getParamPhone(int id, int paramId)	Selects a parameter value with type 'phone'
static ParameterPhoneValueItem	getParamPhoneValueItemFromRs(ResultSet rs)
String	getParamText(int id, int paramId)	Selects a value of parameter type 'text'
Set<String>	getParamTree(int id, int paramId)	Selects a parameter value with type 'tree'
Map<String, BigDecimal>	getParamTreeCount(int id, int paramId)	Selects parameter values with type 'treecount'
List<IdStringTitle>	getParamTreeWithTitles(int id, int paramId)	Deprecated.
boolean	isParameterFilled(int id, Parameter param)	Checks whether the parameter is filled for the object with code id
List<ParameterValue>	loadParameters(List<Parameter> paramList, int id, boolean offEncryption)	Loads parameter's values
void	objectIdInvert(String objectType, int currentObjectId)	Moves parameters from object code to -object code.
Map<Integer, ParameterValue>	parameters(Id object)	Loads parameters for Customer, Process, User or AddressHouse
void	updateParamAddress(int id, int paramId, int position, ParameterAddressValue value)	Updates, appends and deletes an address parameter value
void	updateParamBlob(int id, int paramId, String value)	Updates value for parameter type 'blob'
void	updateParamDate(int id, int paramId, Date value)	Updates value for parameter type 'date'
void	updateParamDateTime(int id, int paramId, Date value)	Updates value for parameter type 'datetime'
void	updateParamEmail(int id, int paramId, int position, ParameterEmailValue value)	Updates values for parameter type 'email'
void	updateParamEmail(int id, int paramId, List<ParameterEmailValue> values)	Updates values for parameter type 'email'
void	updateParamFile(int id, int paramId, int position, String comment, FileData fileData)	Deprecated.
void	updateParamFile(int id, int paramId, int position, FileData fileData)	Updates values for parameter type 'file'
void	updateParamList(int id, int paramId, Map<Integer,String> values)	Deprecated.
void	updateParamList(int id, int paramId, Set<Integer> values)	Updates values without comments for parameter type 'list'
void	updateParamListCount(int id, int paramId, Map<Integer,?> values)	Updates values for parameter type 'listcount'
void	updateParamListCount(int id, int paramId, Map<Integer,Double> values, Map<Integer,String> valuesComments)	Deprecated.
void	updateParamListWithComments(int id, int paramId, Map<Integer,String> values)	Updates values with comments for parameter type 'list'
void	updateParamMoney(int id, int paramId, String value)	Updates value for parameter type 'money'
void	updateParamMoney(int id, int paramId, BigDecimal value)	Updates value for parameter type 'money'
void	updateParamPhone(int id, int paramId, ParameterPhoneValue value)	Updates values for parameter type 'phone'
void	updateParamsAddressOnHouseUpdate(int houseId)	Updates address parameter strings for a house.
void	updateParamText(int id, int paramId, String value)	Updates value for parameter type 'text'
void	updateParamTree(int id, int paramId, Set<String> values)	Updates values for parameter type 'tree'
void	updateParamTreeCount(int id, int paramId, Map<String, BigDecimal> values)	Updates values for parameter type 'treecount'

Methods inherited from class CommonDAO

deleteById, foundRows, getById, getGroupedIds, getGroupedIds, getIds, getIds, getPageLimit, getPeriodSql, lastInsertId, setPeriodParamValue, setRecordCount, update, updateColumn, updateIds, updateIds, updateOrInsert

Methods inherited from class Object

clone, equals, finalize, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait

Field Details

TABLE_NAMES

public static final String[] TABLE_NAMES

COPY_PARAMS_SEPARATORS

public static final String COPY_PARAMS_SEPARATORS

See Also:

• Constant Field Values

Constructor Details

ParamValueDAO

public ParamValueDAO(Connection con)

ParamValueDAO

public ParamValueDAO(Connection con,
 boolean history,
 int userId)

Method Details

copyParam

public void copyParam(int fromObjectId,
 int toObjectId,
 int paramId)
               throws SQLException

Copies a parameter from an object to an object

Parameters:

fromObjectId - object ID of the source

toObjectId - object ID of the target

paramId - the parameter's code

Throws:

SQLException

copyParam

public void copyParam(int fromObjectId,
 int fromParamId,
 int toObjectId,
 int toParamId)
               throws SQLException

Copies a parameter from an object to an object. Parameters must be of the same type.

Parameters:

fromObjectId - object ID of the source

fromParamId - param ID of the source

toObjectId - object ID of the target

toParamId - param ID of the target

Throws:

SQLException

copyParams

public void copyParams(int fromObjectId,
 int toObjectId,
 String copyMapping)
                throws SQLException

Copies parameters from an object to another object according to the given configuration

Parameters:

fromObjectId - the source object

toObjectId - the target object

copyMapping - the configuration

Throws:

SQLException

copyParams

public void copyParams(int fromObjectId,
 int toObjectId,
 Collection<Integer> paramIds)
                throws SQLException

Copies parameters from an object to an object

Parameters:

fromObjectId - object ID of the source

toObjectId - object ID of the target

paramIds - the parameters' codes

Throws:

SQLException

deleteParams

public void deleteParams(String objectType,
 int id)
                  throws SQLException

Deletes object's parameters

Parameters:

objectType - object type

id - object ID

Throws:

SQLException

getParamAddress

public ParameterAddressValue getParamAddress(int id,
 int paramId,
 int position)
                                      throws SQLException

Returns an object's address parameter

Parameters:

id - - object code

paramId - - param ID

position - - position, starting from 1, if the parameter has multiple values set

Returns:

the value

Throws:

SQLException

getParamAddress

public SortedMap<Integer, ParameterAddressValue> getParamAddress(int id,
 int paramId)
                                                          throws SQLException

Returns values of an object's address parameter

Parameters:

id - - object code

paramId - - param ID

Returns:

key - position, value - the value at the position

Throws:

SQLException

getParamAddress

public SortedMap<Integer, ParameterAddressValue> getParamAddress(int id,
 int paramId,
 boolean loadDirs)
                                                          throws SQLException

Returns values of an object's address parameter

Parameters:

id - - object code

paramId - - param ID

loadDirs - - flag whether directories need to be loaded, so that ParameterAddressValue.getHouse() is correctly filled

Returns:

key - position, value - the value at the position

Throws:

SQLException

getParamAddress

public SortedMap<Integer, ParameterAddressValue> getParamAddress(int id,
 int paramId,
 boolean loadDirs,
 String formatName)
                                                          throws SQLException

Returns values of an object's address parameter

Parameters:

id - - object code

paramId - - param ID

loadDirs - - flag whether directories need to be loaded, so that ParameterAddressValue.getHouse() is correctly filled

formatName - - name of the address format from the configuration, used to format the address value

Returns:

key - position, value - the value at the position

Throws:

SQLException

getParamBlob

public String getParamBlob(int id,
 int paramId)
                    throws SQLException

Selects a value for parameter type 'blob'

Parameters:

id - object ID

paramId - param ID

Returns:

the value

Throws:

SQLException

getParamDate

public Date getParamDate(int id,
 int paramId)
                  throws SQLException

Selects a value for parameter type 'date'

Parameters:

id - object ID

paramId - param ID

Returns:

the value

Throws:

SQLException

getParamDateTime

public Date getParamDateTime(int id,
 int paramId)
                      throws SQLException

Selects a value for parameter type 'datetime'

Parameters:

id - object ID

paramId - param ID

Returns:

the value

Throws:

SQLException

getParamEmail

public SortedMap<Integer, ParameterEmailValue> getParamEmail(int id,
 int paramId)
                                                      throws SQLException

Selects values for parameter type 'email'

Parameters:

id - object ID

paramId - param ID

Returns:

key - param value position, value - a value itself

Throws:

SQLException

getParamFile

public FileData getParamFile(int id,
 int paramId,
 int position)
                      throws SQLException

Selects a value for parameter type 'file'

Parameters:

id - object ID

paramId - param ID

position - position number for multiple values

Returns:

the value

Throws:

SQLException

getParamFile

public SortedMap<Integer,FileData> getParamFile(int id,
 int paramId)
                                         throws SQLException

Selects values for parameter type 'file'

Parameters:

id - object ID

paramId - param ID

Returns:

map with key equals value's position

Throws:

SQLException

getParamList

public Set<Integer> getParamList(int id,
 int paramId)
                          throws SQLException

Selects a parameter value with type 'list'

Parameters:

id - object ID

paramId -

Returns:

Set with value codes

Throws:

SQLException

getParamListWithComments

public Map<Integer,String> getParamListWithComments(int id,
 int paramId)
                                             throws SQLException

Selects a parameter value with type 'list' with value comments

Parameters:

id - object ID

paramId - param ID

Returns:

key - value code, value - the comment

Throws:

SQLException

getParamListCount

public Map<Integer, BigDecimal> getParamListCount(int id,
 int paramId)
                                           throws SQLException

Selects a parameter value with type 'listcount'

Parameters:

id - object ID

paramId - param ID

Returns:

a map with key equals value IDs and values counts

Throws:

SQLException

getParamMoney

public BigDecimal getParamMoney(int id,
 int paramId)
                         throws SQLException

Selects a parameter value with type 'money'

Parameters:

id - object ID

paramId - param ID

Returns:

the value or null

Throws:

SQLException

getParamPhone

public ParameterPhoneValue getParamPhone(int id,
 int paramId)
                                  throws SQLException

Selects a parameter value with type 'phone'

Parameters:

id - object ID

paramId - param ID

Returns:

the value or null

Throws:

SQLException

getParamPhoneValueItemFromRs

public static ParameterPhoneValueItem getParamPhoneValueItemFromRs(ResultSet rs)
                                                            throws SQLException

Throws:

SQLException

getParamText

public String getParamText(int id,
 int paramId)
                    throws SQLException

Selects a value of parameter type 'text'

Parameters:

id - object ID

paramId - param ID

Returns:

the value

Throws:

SQLException

getParamTree

public Set<String> getParamTree(int id,
 int paramId)
                         throws SQLException

Selects a parameter value with type 'tree'

Parameters:

id - object ID

paramId - param ID

Returns:

set of values

Throws:

SQLException

getParamTreeCount

public Map<String, BigDecimal> getParamTreeCount(int id,
 int paramId)
                                          throws SQLException

Selects parameter values with type 'treecount'

Parameters:

id - object ID

paramId - param ID

Returns:

map with a key equal to the parameter value ID, and the value - value amount (count)

Throws:

SQLException

isParameterFilled

public boolean isParameterFilled(int id,
 Parameter param)
                          throws Exception

Checks whether the parameter is filled for the object with code id

Parameters:

id - object ID

param - the parameter

Returns:

true if filled

Throws:

Exception

objectIdInvert

public void objectIdInvert(String objectType,
 int currentObjectId)
                    throws SQLException

Moves parameters from object code to -object code. Used when converting a not-fully-created process with a negative code into a created one.

Parameters:

objectType -

currentObjectId -

Throws:

SQLException

parameters

public Map<Integer, ParameterValue> parameters(Id object)
                                        throws SQLException

Loads parameters for Customer, Process, User or AddressHouse

Parameters:

object - customer or process

Returns:

the parameters map, key - parameter ID

Throws:

SQLException

updateParamAddress

public void updateParamAddress(int id,
 int paramId,
 int position,
 ParameterAddressValue value)
                        throws SQLException

Updates, appends and deletes an address parameter value

Parameters:

id - - entity ID

paramId - - param ID

position - - starting from 1 value's position, 0 - appends a value with position MAX+1

value - - the value, null - delete value from the position if position > 0, else delete all the values

Throws:

SQLException

updateParamsAddressOnHouseUpdate

public void updateParamsAddressOnHouseUpdate(int houseId)
                                      throws SQLException

Updates address parameter strings for a house. Used after changes in address directories, to generate correct strings with address parameters.

Parameters:

houseId - house code

Throws:

SQLException

updateParamBlob

public void updateParamBlob(int id,
 int paramId,
 String value)
                     throws SQLException

Updates value for parameter type 'blob'

Parameters:

id - object ID

paramId - param ID

value - the value, null or empty string - delete the value

Throws:

SQLException

updateParamDate

public void updateParamDate(int id,
 int paramId,
 Date value)
                     throws SQLException

Updates value for parameter type 'date'

Parameters:

id - object ID

paramId - param ID

value - the value, null - delete

Throws:

SQLException

updateParamDateTime

public void updateParamDateTime(int id,
 int paramId,
 Date value)
                         throws SQLException

Updates value for parameter type 'datetime'

Parameters:

id - object ID

paramId - param ID

value - the value, null - delete

Throws:

SQLException

updateParamEmail

public void updateParamEmail(int id,
 int paramId,
 List<ParameterEmailValue> values)
                      throws SQLException

Updates values for parameter type 'email'

Parameters:

id - object ID

paramId - param ID

values - the values, null or empty - delete values in DB

Throws:

SQLException

updateParamEmail

public void updateParamEmail(int id,
 int paramId,
 int position,
 ParameterEmailValue value)
                      throws SQLException

Updates values for parameter type 'email'

Parameters:

id - object ID

paramId - param ID

position - values' position, starting from 1, 0 add a new value with position MAX + 1

value - the value, null delete the values from the position more than 0, delete all values if position is 0

Throws:

SQLException

updateParamFile

public void updateParamFile(int id,
 int paramId,
 int position,
 FileData fileData)
                     throws Exception

Updates values for parameter type 'file'

Parameters:

id - object ID

paramId - param ID

position - position for multiple values, when is 0 - adding with new positions

fileData - value for the given position, if null - removes a value from the position or all values with position == -1

Throws:

Exception

updateParamList

public void updateParamList(int id,
 int paramId,
 Set<Integer> values)
                     throws SQLException

Updates values without comments for parameter type 'list'

Parameters:

id - object ID

paramId - param ID

values - the values

Throws:

SQLException

updateParamListWithComments

public void updateParamListWithComments(int id,
 int paramId,
 Map<Integer,String> values)
                                 throws SQLException

Updates values with comments for parameter type 'list'

Parameters:

id - object ID

paramId - param ID

values - the values map, keys represent values, values - comments

Throws:

SQLException

updateParamListCount

public void updateParamListCount(int id,
 int paramId,
 Map<Integer,?> values)
                          throws SQLException

Updates values for parameter type 'listcount'

Parameters:

id - entity ID

paramId - param ID

values - map with key = value ID, and values with possible types: String, BigDecimal

Throws:

SQLException

updateParamMoney

public void updateParamMoney(int id,
 int paramId,
 BigDecimal value)
                      throws SQLException

Updates value for parameter type 'money'

Parameters:

id - object ID

paramId - param ID

value - the value, when null - delete

Throws:

SQLException

updateParamMoney

public void updateParamMoney(int id,
 int paramId,
 String value)
                      throws SQLException

Updates value for parameter type 'money'

Parameters:

id - object ID

paramId - parm ID.

value - the value, when null or a blank string - delete

Throws:

SQLException

updateParamPhone

public void updateParamPhone(int id,
 int paramId,
 ParameterPhoneValue value)
                      throws SQLException

Updates values for parameter type 'phone'

Parameters:

id - object ID

paramId - param ID

value - the values, null or empty itemList - delete values

Throws:

SQLException

updateParamText

public void updateParamText(int id,
 int paramId,
 String value)
                     throws SQLException

Updates value for parameter type 'text'

Parameters:

id - object ID

paramId - param ID

value - the value, null or emtpy string - delete value

Throws:

SQLException

updateParamTree

public void updateParamTree(int id,
 int paramId,
 Set<String> values)
                     throws SQLException

Updates values for parameter type 'tree'

Parameters:

id - object ID

paramId - param ID

values - the values, null or empty set - delete values

Throws:

SQLException

updateParamTreeCount

public void updateParamTreeCount(int id,
 int paramId,
 Map<String, BigDecimal> values)
                          throws SQLException

Updates values for parameter type 'treecount'

Parameters:

id - object ID

paramId - param ID

values - the values map (key - treecount value ID, value - 'count'), null or emtpy map - delete values

Throws:

SQLException

loadParameters

public List<ParameterValue> loadParameters(List<Parameter> paramList,
 int id,
 boolean offEncryption)
                                    throws SQLException

Loads parameter's values

Parameters:

paramList - parameters list

id - entity id

offEncryption - decrypt pseudo encrypted values

Throws:

SQLException

getParamEmail

@Deprecated
public ParameterEmailValue getParamEmail(int id,
 int paramId,
 int position)
                                  throws SQLException

Deprecated.

Selects a value for parameter type 'email'

Parameters:

id - object ID

paramId - param ID

position - param value position

Returns:

the value

Throws:

SQLException

getParamListWithTitles

@Deprecated
public List<IdTitle> getParamListWithTitles(int id,
 int paramId)
                                     throws SQLException

Deprecated.

Selects a parameter value with type 'list' with value titles

Parameters:

id - object ID

paramId - param ID

Returns:

the values

Throws:

SQLException

getParamListWithTitlesAndComments

@Deprecated
public List<IdTitleComment> getParamListWithTitlesAndComments(int id,
 int paramId)
                                                       throws SQLException

Deprecated.

Selects a parameter value with type 'list' with value titles and comments

Parameters:

id - object ID

paramId - param ID

Returns:

the values

Throws:

SQLException

getParamListCountWithTitles

@Deprecated
public List<IdTitle> getParamListCountWithTitles(int id,
 int paramId)
                                          throws SQLException

Deprecated.

Selects a parameter value with type 'listcount' with value titles

Parameters:

id - object ID

paramId - param ID

Returns:

the values

Throws:

SQLException

getParamTreeWithTitles

@Deprecated
public List<IdStringTitle> getParamTreeWithTitles(int id,
 int paramId)
                                           throws SQLException

Deprecated.

Values of an object's parameter with type 'tree' with text titles

Parameters:

id - object ID

paramId - param ID

Returns:

the values

Throws:

SQLException

updateParamFile

@Deprecated
public void updateParamFile(int id,
 int paramId,
 int position,
 String comment,
 FileData fileData)
                     throws Exception

Deprecated.

Use updateParamFile(int, int, int, FileData)

Throws:

Exception

updateParamList

@Deprecated
public void updateParamList(int id,
 int paramId,
 Map<Integer,String> values)
                     throws SQLException

Deprecated.

Throws:

SQLException

updateParamListCount

@Deprecated
public void updateParamListCount(int id,
 int paramId,
 Map<Integer,Double> values,
 Map<Integer,String> valuesComments)
                          throws SQLException

Deprecated.

Use updateParamListCount(int, int, Map)

Throws:

SQLException