com.dpslink.flash.db

Class ProductAttributeController

java.lang.Object

com.dpslink.base.obj.MappedAttributesObject

com.dpslink.base.jdbc.JDBCObjectController<ProductAttribute>

com.dpslink.flash.db.ProductAttributeController

All Implemented Interfaces:

java.io.Serializable

public class ProductAttributeController
extends JDBCObjectController<ProductAttribute>

The controller for the ProductAttribute class. Provides methods for retrieving and persisting product and ext. product attributes x-ref records in the database.

See Also:

Serialized Form

Field Summary

Fields

Modifier and Type	Field and Description
private static java.util.Hashtable<java.lang.String,java.util.ArrayList<java.lang.String[]>>	cvUniqueAttributes A table of unique attribute values per descriptor code.
private static long	serialVersionUID The class' serialization version id.

Fields inherited from class com.dpslink.base.jdbc.JDBCObjectController

ivDBObjCls, ivFieldCount, ivFieldKeyAlt, ivFieldKeyPri, ivFieldResPfx, ivSyncLast, ivSyncType, ivTableName

Fields inherited from class com.dpslink.base.obj.MappedAttributesObject

ivHashCode, ivHashFlds, ivObjAttrs

Constructor Summary

Constructors

Constructor and Description
ProductAttributeController() The constructor for the controller.

Method Summary

Modifier and Type	Method and Description
int	add(ProductAttribute obj, boolean logdup) Adds a new record to the table associated with the controller.
boolean	delete(ProductAttribute obj) Deletes an existing record from the table associated with the controller.
boolean	deleteAll() Deletes all records in the table associated with the controller.
boolean	deleteDescriptor(java.lang.String desccode) Deletes all attribute records for a descriptor code.
boolean	deleteProduct(Product product) Deletes all attribute records for a product.
ProductAttribute	get(java.lang.String prodcode, java.lang.String uomcode, java.lang.String desccode) Returns the attribute record for a product code, unit of measure code and descriptor code.
java.util.ArrayList<ProductAttribute>	getDisplayable(Product product) Returns a collection of the displayable attribute records for a product.
java.util.ArrayList<ProductAttribute>	getFiltersForCategory(Category category) Returns a collection of summarized product attribute records for the given category.
java.util.ArrayList<ProductAttribute>	getFiltersForCategory(java.lang.String category) Returns a collection of summarized product attribute records for the given category code.
java.util.ArrayList<ProductAttribute>	getFiltersForSearch(java.util.ArrayList<Product> products) Returns a collection of summarized product attribute records for the given set of products.
java.util.ArrayList<ProductAttribute>	getProduct(Product product) Returns a collection of attribute records for a product.
java.util.ArrayList<ProductAttribute>	getProduct(java.lang.String prodcode, java.lang.String uomcode) Returns a collection of attribute records for a product code and unit of measure code.
java.util.ArrayList<java.lang.String[]>	getUniqueValues(java.lang.String desccode) Returns a collection of unique attribute values for a descriptor code.
boolean	hasDescriptor(java.lang.String desccode) Answers if the given descriptor code has been assigned to one or more products.
boolean	update(ProductAttribute obj) Updates an existing record in the table associated with the controller.

Methods inherited from class com.dpslink.base.jdbc.JDBCObjectController

add, add, arrayToMap, arrayToMap, countAll, delete, dispose, equals, getAll, getConnection, getConnectionInfo, getController, getFieldNames, getFieldNamesForKey, getFieldNamesForUpdate, getFieldNulls, getFieldNullsForKey, getFieldNullsForUpdate, getFieldsForOrderBy, getFieldsForWhere, getFieldSize, getFieldTypes, getFieldTypesForKey, getFieldTypesForUpdate, getStatementForDelete, getStatementForGet, getStatementForGetAll, getStatementForInsert, getStatementForUpdate, getStatementKey, getStatementString, getTableName, hasFieldNamesForKey, hasFieldNamesForUpdate, isDuplicate, resultSetToArray, resultSetToMap, resultSetToMap, resultSetToObject, setConnectionInfo, setPSDeleteValues, setPSExistsValues, setPSInsertValues, setPSUpdateValues, setPSValue, update, valuesToObject

Methods inherited from class com.dpslink.base.obj.MappedAttributesObject

cloneMapAttributes, formatValue, formatValue, getHashFields, getMapArrayList, getMapAttributes, getMapBigDecimal, getMapBoolean, getMapDate, getMapDouble, getMapInteger, getMapLong, getMapMapped, getMapObject, getMapShort, getMapString, getMapString, getMapStringBuffer, getMapStringBuilder, getMapTime, getMapTimestamp, getMapVector, hashCode, setHashFields, setMap, setMap, setMap, setMap, setMap, setMap, setMap, setMap, setMap, setMap, setMap, setMap, setMap, setMap, setMap, setMapAttributes, setMapObject, setMapTime, setMapTimestamp, toStringArray

Methods inherited from class java.lang.Object

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

Field Detail

serialVersionUID

private static final long serialVersionUID

The class' serialization version id.

See Also:

Constant Field Values

cvUniqueAttributes

private static java.util.Hashtable<java.lang.String,java.util.ArrayList<java.lang.String[]>> cvUniqueAttributes

A table of unique attribute values per descriptor code.

Constructor Detail

ProductAttributeController

public ProductAttributeController()

The constructor for the controller.

Method Detail

add

public int add(ProductAttribute obj,
               boolean logdup)

Adds a new record to the table associated with the controller. Overrides add in JDBCObjectController.

Overrides:

add in class JDBCObjectController<ProductAttribute>

Parameters:

obj - (JDBCObject) The object for the record to be added.

logdup - (boolean) true if duplicate errors are to be logged as an exception, otherwise false if not. When duplicates are logged, the return value of 1 is never returned.

Returns:

int - 0 = success, 1 = duplicate, 2 = failure.

delete

public boolean delete(ProductAttribute obj)

Deletes an existing record from the table associated with the controller.

Overrides:

delete in class JDBCObjectController<ProductAttribute>

Parameters:

obj - (JDBCObject) The object for the record to be deleted.

Returns:

boolean - true if the record deleted successfully, otherwise false.

deleteAll

public boolean deleteAll()

Deletes all records in the table associated with the controller.

Overrides:

deleteAll in class JDBCObjectController<ProductAttribute>

Returns:

boolean - true if the deletes are successful, otherwise false.

update

public boolean update(ProductAttribute obj)

Updates an existing record in the table associated with the controller.

Overrides:

update in class JDBCObjectController<ProductAttribute>

Parameters:

obj - (JDBCObject) The object for the record to be updated.

Returns:

boolean - true if the record updated successfully, otherwise false.

deleteDescriptor

public boolean deleteDescriptor(java.lang.String desccode)

Deletes all attribute records for a descriptor code.

Parameters:

desccode - (String) The descriptor code for the records to delete.

Returns:

boolean - true if the deletes are successful, otherwise false.

deleteProduct

public boolean deleteProduct(Product product)

Deletes all attribute records for a product.

Parameters:

product - (Product) The product for the records to delete.

Returns:

boolean - true if the deletes are successful, otherwise false.

get

public ProductAttribute get(java.lang.String prodcode,
                            java.lang.String uomcode,
                            java.lang.String desccode)

Returns the attribute record for a product code, unit of measure code and descriptor code.

Parameters:

prodcode - (String) The product code for the desired record.

uomcode - (String) The unit of measure code for the desired record.

desccode - (String) The descriptor code for the desired record.

Returns:

ProductAttribute - An object initialized with values from the database.

getDisplayable

public java.util.ArrayList<ProductAttribute> getDisplayable(Product product)

Returns a collection of the displayable attribute records for a product.

Parameters:

product - (Product) The product for the desired records.

Returns:

ArrayList - A collection of attributes.

getFiltersForCategory

public java.util.ArrayList<ProductAttribute> getFiltersForCategory(Category category)

Returns a collection of summarized product attribute records for the given category.

Parameters:

category - (Category) The category for the desired records.

Returns:

ArrayList - A collection of summarized product attribute records.

getFiltersForCategory

public java.util.ArrayList<ProductAttribute> getFiltersForCategory(java.lang.String category)

Returns a collection of summarized product attribute records for the given category code.

Parameters:

category - (String) The category code for the desired records.

Returns:

ArrayList - A collection of summarized product attribute records.

getFiltersForSearch

public java.util.ArrayList<ProductAttribute> getFiltersForSearch(java.util.ArrayList<Product> products)

Returns a collection of summarized product attribute records for the given set of products.

Parameters:

products - (ArrayList) The products for the desired records.

Returns:

ArrayList - A collection of summarized product attribute records.

getProduct

public java.util.ArrayList<ProductAttribute> getProduct(Product product)

Returns a collection of attribute records for a product.

Parameters:

product - (Product) The product for the desired records.

Returns:

ArrayList - A collection of attributes.

getProduct

public java.util.ArrayList<ProductAttribute> getProduct(java.lang.String prodcode,
                                                        java.lang.String uomcode)

Returns a collection of attribute records for a product code and unit of measure code.

Parameters:

prodcode - (String) The product code for the desired records.

uomcode - (String) The unit of measure code for the desired records.

Returns:

ArrayList - A collection of attributes.

getUniqueValues

public java.util.ArrayList<java.lang.String[]> getUniqueValues(java.lang.String desccode)

Returns a collection of unique attribute values for a descriptor code.

Parameters:

desccode - (String) The descriptor code for the desired values.

Returns:

ArrayList - A collection of unique values.

hasDescriptor

public boolean hasDescriptor(java.lang.String desccode)

Answers if the given descriptor code has been assigned to one or more products.

Parameters:

desccode - (String) The descriptor code to be checked.

Returns:

boolean - true if descriptor code was found in the table, otherwise false.