com.dpslink.flash.db

Class PendingProductController

java.lang.Object

com.dpslink.base.obj.MappedAttributesObject

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

com.dpslink.flash.db.PendingProductController

All Implemented Interfaces:

java.io.Serializable

public class PendingProductController
extends JDBCObjectController<PendingProduct>

The controller for the PendingProduct class. Provides methods for retrieving and persisting pending product table records in the database.

See Also:

Serialized Form

Field Summary

Fields

Modifier and Type	Field and Description
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
PendingProductController() The constructor for the controller.

Method Summary

Modifier and Type	Method and Description
boolean	add(PendingProduct obj) Adds a new record to the table associated with the controller.
boolean	delete(PendingProduct obj) Deletes an existing record from the table associated with the controller.
boolean	delete(PendingProduct obj, boolean deleteall) Deletes a pending product record from the database, plus optionally deletes any associated pending product information (cross references, descriptions, images).
boolean	deleteBatch(ImportBatch batch) Deletes all records from the pending product table for the given batch plus any associated pending product information (cross references, images, descriptions).
boolean	deleteBatch(int batch) Deletes all records from the pending product table for the given batch number plus any associated pending product information (cross references, images, descriptions).
boolean	deleteBatchUnselected(ImportBatch batch) Deletes unselected records from the pending product table for the given batch plus any associated pending product information (cross references, images, descriptions).
boolean	deleteBatchUnselected(int batch) Deletes unselected records from the pending product table for the given batch number plus any associated pending product information (cross references, images, descriptions).
boolean	deselectBatch(ImportBatch batch) Deselects all pending product records for the given batch.
boolean	deselectBatch(int batch) Deselects all pending product records for the given batch number.
boolean	deselectBatchFind(ImportBatch batch, int findkey) Deselects pending product records for the given batch and find key.
boolean	deselectBatchFind(int batch, int findkey) Deselects pending product records for the given batch number and find key.
PendingProduct	get(java.lang.String code, java.lang.String uom) Returns the pending product record for the given product code and unit of measure code.
java.lang.Object[]	getAllAsRS() Returns a result set of all pending product records.
java.util.ArrayList<PendingProduct>	getBatch(ImportBatch batch) Returns a collection of pending product records for the given batch.
java.util.ArrayList<PendingProduct>	getBatch(int batch) Returns a collection of pending product records for the given batch number.
int	getBatchCount(ImportBatch batch) Returns the number of pending product records in the given batch.
int	getBatchCount(int batch) Returns the number of pending product records in the given batch number.
int	getBatchErrorCount(ImportBatch batch, java.lang.String errorcode) Returns the number of pending product records in the given batch that have the given error.
int	getBatchErrorCount(int batch, java.lang.String errorcode) Returns the number of pending product records in the given batch number that have the given error.
java.util.ArrayList<PendingProduct>	getBatchFind(ImportBatch batch, int findkey) Returns a collection of pending product records for the given batch and find key.
java.util.ArrayList<PendingProduct>	getBatchFind(int batch, int findkey) Returns a collection of pending product records for the given batch number and find key.
int	getBatchMatchCount(ImportBatch batch, java.lang.String field, java.lang.String operand, java.lang.String argument) Returns the number of pending product records in the given batch that have a field that contains characters matching the given criteria.
int	getBatchMatchCount(int batch, java.lang.String field, java.lang.String operand, java.lang.String argument) Returns the number of pending product records in the given batch number that have a field that contains characters matching the given criteria.
int	getBatchNoErrorCount(ImportBatch batch) Returns the number of pending product records in the given batch that have no errors.
int	getBatchNoErrorCount(int batch) Returns the number of pending product records in the given batch number that have no errors.
java.util.ArrayList<PendingProduct>	getBatchSelected(ImportBatch batch) Returns a collection of selected pending product records for the given batch.
java.util.ArrayList<PendingProduct>	getBatchSelected(int batch) Returns a collection of selected pending product records for the given batch number.
int	getBatchSelectedCount(ImportBatch batch) Returns the number of selected pending product records in the given batch.
int	getBatchSelectedCount(int batch) Returns the number of selected pending product records in the given batch number.
java.util.ArrayList<PendingProduct>	getBatchUnselected(ImportBatch batch) Returns a collection of unselected pending product records for the given batch.
java.util.ArrayList<PendingProduct>	getBatchUnselected(int batch) Returns a collection of unselected pending product records for the given batch number.
int	getBatchUnselectedCount(ImportBatch batch) Returns the number of unselected pending product records in the given batch.
int	getBatchUnselectedCount(int batch) Returns the number of unselected pending product records in the given batch number.
boolean	hasProduct(java.lang.String code) Answers if a given product (code only) exists in the pending product table.
boolean	hasProduct(java.lang.String code, java.lang.String uom) Answers if a given product (code & uom) exists in the pending product table.
boolean	selectBatch(ImportBatch batch) Selects all pending product records for the given batch.
boolean	selectBatch(int batch) Selects all pending product records for the given batch number.
boolean	selectBatchFind(ImportBatch batch, int findkey) Selects pending product records for the given batch and find key.
boolean	selectBatchFind(int batch, int findkey) Selects pending product records for the given batch number and find key.
boolean	setBatchErrorFind(ImportBatch batch, java.lang.String errorcode, int findkey) Sets the find key for pending product records in the given batch that have the given error.
boolean	setBatchErrorFind(int batch, java.lang.String errorcode, int findkey) Sets the find key for pending product records in the given batch number that have the given error.
boolean	setBatchMatchFind(ImportBatch batch, java.lang.String field, java.lang.String operand, java.lang.String argument, int findkey) Sets the find key for pending product records in the given batch that have a field that contains characters matching the given criteria.
boolean	setBatchMatchFind(int batch, java.lang.String field, java.lang.String operand, java.lang.String argument, int findkey) Sets the find key for pending product records in the given batch number that have a field that contains characters matching the given criteria.
PendingProduct	valuesToObject(java.util.HashMap<java.lang.String,java.lang.Object> attrs) Returns a database object from the given set of attributes.

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

add, add, arrayToMap, arrayToMap, countAll, delete, deleteAll, 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, update

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

Constructor Detail

PendingProductController

public PendingProductController()

The constructor for the controller.

Method Detail

add

public boolean add(PendingProduct obj)

Adds a new record to the table associated with the controller. Assumes that duplicates are always logged as an exception. Overrides add in JDBCObjectController. Also adds any associated customer-product cross references.

Overrides:

add in class JDBCObjectController<PendingProduct>

Parameters:

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

Returns:

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

delete

public boolean delete(PendingProduct obj)

Deletes an existing record from the table associated with the controller. Overrides delete in JDBCObjectController. Does not delete any associated information (cross references, descriptions, images).

Overrides:

delete in class JDBCObjectController<PendingProduct>

Parameters:

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

Returns:

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

valuesToObject

public PendingProduct valuesToObject(java.util.HashMap<java.lang.String,java.lang.Object> attrs)

Returns a database object from the given set of attributes. Overrides valuesToObject in JDBCObjectController.

Overrides:

valuesToObject in class JDBCObjectController<PendingProduct>

Parameters:

attrs - (HashMap) The attributes to assign to the new object.

Returns:

PendingProduct - An object initialized with the specified attributes.

delete

public boolean delete(PendingProduct obj,
                      boolean deleteall)

Deletes a pending product record from the database, plus optionally deletes any associated pending product information (cross references, descriptions, images).

Parameters:

obj - (PendingProduct) The pending product to delete.

deleteall - (boolean) true if all pending product info is to be deleted, false if only the pending product record is to be deleted and all other info is to be left as is (such as when pending product records are posted to the product table).

Returns:

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

deleteBatch

public boolean deleteBatch(ImportBatch batch)

Deletes all records from the pending product table for the given batch plus any associated pending product information (cross references, images, descriptions).

Parameters:

batch - (ImportBatch) The batch for the records to delete.

Returns:

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

deleteBatch

public boolean deleteBatch(int batch)

Deletes all records from the pending product table for the given batch number plus any associated pending product information (cross references, images, descriptions).

Parameters:

batch - (int) The batch number for the records to delete.

Returns:

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

deleteBatchUnselected

public boolean deleteBatchUnselected(ImportBatch batch)

Deletes unselected records from the pending product table for the given batch plus any associated pending product information (cross references, images, descriptions).

Parameters:

batch - (ImportBatch) The batch for the records to delete.

Returns:

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

deleteBatchUnselected

public boolean deleteBatchUnselected(int batch)

Deletes unselected records from the pending product table for the given batch number plus any associated pending product information (cross references, images, descriptions).

Parameters:

batch - (int) The batch number for the records to delete.

Returns:

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

deselectBatch

public boolean deselectBatch(ImportBatch batch)

Deselects all pending product records for the given batch.

Parameters:

batch - (ImportBatch) The batch for the records to deselect.

Returns:

boolean - true if the deselects were successful, otherwise false.

deselectBatch

public boolean deselectBatch(int batch)

Deselects all pending product records for the given batch number.

Parameters:

batch - (int) The batch number for the records to deselect.

Returns:

boolean - true if the deselects were successful, otherwise false.

deselectBatchFind

public boolean deselectBatchFind(ImportBatch batch,
                                 int findkey)

Deselects pending product records for the given batch and find key.

Parameters:

batch - (ImportBatch) The batch for the records to deselect.

findkey - (int) The find key for the records to deselect.

Returns:

boolean - true if the deselects were successful, otherwise false.

deselectBatchFind

public boolean deselectBatchFind(int batch,
                                 int findkey)

Deselects pending product records for the given batch number and find key.

Parameters:

batch - (int) The batch number for the records to deselect.

findkey - (int) The find key for the records to deselect.

Returns:

boolean - true if the deselects were successful, otherwise false.

get

public PendingProduct get(java.lang.String code,
                          java.lang.String uom)

Returns the pending product record for the given product code and unit of measure code.

Parameters:

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

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

Returns:

PendingProduct - An object initialized with values from the database.

getAllAsRS

public java.lang.Object[] getAllAsRS()

Returns a result set of all pending product records.

The invoker of this method is responsible for closing the returned result set and prepared statement.

Returns:

Object[] - An object array containing the result set ([0]) and the prepared statement ([1]) used to obtain the result set.

getBatch

public java.util.ArrayList<PendingProduct> getBatch(ImportBatch batch)

Returns a collection of pending product records for the given batch.

Parameters:

batch - (ImportBatch) The batch for the desired records.

Returns:

ArrayList - The batch's pending product records.

getBatch

public java.util.ArrayList<PendingProduct> getBatch(int batch)

Returns a collection of pending product records for the given batch number.

Parameters:

batch - (int) The batch number for the desired records.

Returns:

ArrayList - The batch's pending product records.

getBatchCount

public int getBatchCount(ImportBatch batch)

Returns the number of pending product records in the given batch.

Parameters:

batch - (ImportBatch) The batch for the desired count.

Returns:

int - The number of pending product records in the batch.

getBatchCount

public int getBatchCount(int batch)

Returns the number of pending product records in the given batch number.

Parameters:

batch - (int) The batch number for the desired count.

Returns:

int - The number of pending product records in the batch.

getBatchErrorCount

public int getBatchErrorCount(ImportBatch batch,
                              java.lang.String errorcode)

Returns the number of pending product records in the given batch that have the given error.

Parameters:

batch - (ImportBatch) The batch for the desired count.

errorcode - (String) The code for the error to count.

Returns:

int - The number of pending product records in the batch with the given error.

getBatchErrorCount

public int getBatchErrorCount(int batch,
                              java.lang.String errorcode)

Returns the number of pending product records in the given batch number that have the given error.

Parameters:

batch - (int) The batch number for the desired count.

errorcode - (String) The code for the error to count.

Returns:

int - The number of pending product records in the batch with the given error.

getBatchFind

public java.util.ArrayList<PendingProduct> getBatchFind(ImportBatch batch,
                                                        int findkey)

Returns a collection of pending product records for the given batch and find key.

Parameters:

batch - (ImportBatch) The batch for the desired records.

findkey - (int) The find key for the desired records.

Returns:

ArrayList - The batch's pending product records for the find key.

getBatchFind

public java.util.ArrayList<PendingProduct> getBatchFind(int batch,
                                                        int findkey)

Returns a collection of pending product records for the given batch number and find key.

Parameters:

batch - (int) The batch number for the desired records.

findkey - (int) The find key for the desired records.

Returns:

ArrayList - The batch's pending product records for the find key.

getBatchMatchCount

public int getBatchMatchCount(ImportBatch batch,
                              java.lang.String field,
                              java.lang.String operand,
                              java.lang.String argument)

Returns the number of pending product records in the given batch that have a field that contains characters matching the given criteria.

Parameters:

batch - (ImportBatch) The batch for the desired count.

field - (String) The field that is to be involved in determining the query results. This value is appended to the end of the sql properties key when obtaining the appropriate sql statement for the requested query.

operand - (String) The operation that the query is to perform on the given field in order to determine the query results. Currently only "contains" and "equals" are supported.

argument - (String) The query search argument. The character string that the query is to use in determining its results.

Returns:

int - The number of pending product records in the batch that match the criteria.

getBatchMatchCount

public int getBatchMatchCount(int batch,
                              java.lang.String field,
                              java.lang.String operand,
                              java.lang.String argument)

Returns the number of pending product records in the given batch number that have a field that contains characters matching the given criteria.

Parameters:

batch - (int) The batch number for the desired count.

field - (String) The field that is to be involved in determining the query results. This value is appended to the end of the sql properties key when obtaining the appropriate sql statement for the requested query.

operand - (String) The operation that the query is to perform on the given field in order to determine the query results. Currently only "contains" and "equals" are supported.

argument - (String) The query search argument. The character string that the query is to use in determining its results.

Returns:

int - The number of pending product records in the batch that match the criteria.

getBatchNoErrorCount

public int getBatchNoErrorCount(ImportBatch batch)

Returns the number of pending product records in the given batch that have no errors.

Parameters:

batch - (ImportBatch) The batch for the desired count.

Returns:

int - The number of pending product records in the batch with no errors.

getBatchNoErrorCount

public int getBatchNoErrorCount(int batch)

Returns the number of pending product records in the given batch number that have no errors.

Parameters:

batch - (int) The batch number for the desired count.

Returns:

int - The number of pending product records in the batch with no errors.

getBatchSelected

public java.util.ArrayList<PendingProduct> getBatchSelected(ImportBatch batch)

Returns a collection of selected pending product records for the given batch.

Parameters:

batch - (ImportBatch) The batch for the desired records.

Returns:

ArrayList - The batch's selected pending product records.

getBatchSelected

public java.util.ArrayList<PendingProduct> getBatchSelected(int batch)

Returns a collection of selected pending product records for the given batch number.

Parameters:

batch - (int) The batch number for the desired records.

Returns:

ArrayList - The batch's selected pending product records.

getBatchSelectedCount

public int getBatchSelectedCount(ImportBatch batch)

Returns the number of selected pending product records in the given batch.

Parameters:

batch - (ImportBatch) The batch for the desired count.

Returns:

int - The number of selected pending product records in the batch.

getBatchSelectedCount

public int getBatchSelectedCount(int batch)

Returns the number of selected pending product records in the given batch number.

Parameters:

batch - (int) The batch number for the desired count.

Returns:

int - The number of selected pending product records in the batch.

getBatchUnselected

public java.util.ArrayList<PendingProduct> getBatchUnselected(ImportBatch batch)

Returns a collection of unselected pending product records for the given batch.

Parameters:

batch - (ImportBatch) The batch for the desired records.

Returns:

ArrayList - The batch's unselected pending product records.

getBatchUnselected

public java.util.ArrayList<PendingProduct> getBatchUnselected(int batch)

Returns a collection of unselected pending product records for the given batch number.

Parameters:

batch - (int) The batch number for the desired records.

Returns:

ArrayList - The batch's unselected pending product records.

getBatchUnselectedCount

public int getBatchUnselectedCount(ImportBatch batch)

Returns the number of unselected pending product records in the given batch.

Parameters:

batch - (ImportBatch) The batch for the desired count.

Returns:

int - The number of unselected pending product records in the batch.

getBatchUnselectedCount

public int getBatchUnselectedCount(int batch)

Returns the number of unselected pending product records in the given batch number.

Parameters:

batch - (int) The batch number for the desired count.

Returns:

int - The number of unselected pending product records in the batch.

hasProduct

public boolean hasProduct(java.lang.String code)

Answers if a given product (code only) exists in the pending product table.

Parameters:

code - (String) The product code to check.

Returns:

boolean - true if the product exists, otherwise false.

hasProduct

public boolean hasProduct(java.lang.String code,
                          java.lang.String uom)

Answers if a given product (code & uom) exists in the pending product table.

Parameters:

code - (String) The product code to check.

uom - (String) The unit of measure code to check.

Returns:

boolean - true if the product exists, otherwise false.

selectBatch

public boolean selectBatch(ImportBatch batch)

Selects all pending product records for the given batch.

Parameters:

batch - (ImportBatch) The batch for the records to select.

Returns:

boolean - true if the selects were successful, otherwise false.

selectBatch

public boolean selectBatch(int batch)

Selects all pending product records for the given batch number.

Parameters:

batch - (int) The batch number for the records to select.

Returns:

boolean - true if the selects were successful, otherwise false.

selectBatchFind

public boolean selectBatchFind(ImportBatch batch,
                               int findkey)

Selects pending product records for the given batch and find key.

Parameters:

batch - (ImportBatch) The batch for the records to select.

findkey - (int) The find key for the records to select.

Returns:

boolean - true if the selects were successful, otherwise false.

selectBatchFind

public boolean selectBatchFind(int batch,
                               int findkey)

Selects pending product records for the given batch number and find key.

Parameters:

batch - (int) The batch number for the records to select.

findkey - (int) The find key for the records to select.

Returns:

boolean - true if the selects were successful, otherwise false.

setBatchErrorFind

public boolean setBatchErrorFind(ImportBatch batch,
                                 java.lang.String errorcode,
                                 int findkey)

Sets the find key for pending product records in the given batch that have the given error.

Parameters:

batch - (ImportBatch) The batch for the records to update.

errorcode - (String) The code for the error that is to be selected for update.

findkey - (int) The find key that is to be set in the selected pending products.

Returns:

boolean - true if the find key is successfully set, otherwise false.

setBatchErrorFind

public boolean setBatchErrorFind(int batch,
                                 java.lang.String errorcode,
                                 int findkey)

Sets the find key for pending product records in the given batch number that have the given error.

Parameters:

batch - (int) The batch number for the records to update.

errorcode - (String) The code for the error that is to be selected for update.

findkey - (int) The find key that is to be set in the selected pending products.

Returns:

boolean - true if the find key is successfully set, otherwise false.

setBatchMatchFind

public boolean setBatchMatchFind(ImportBatch batch,
                                 java.lang.String field,
                                 java.lang.String operand,
                                 java.lang.String argument,
                                 int findkey)

Sets the find key for pending product records in the given batch that have a field that contains characters matching the given criteria.

Parameters:

batch - (ImportBatch) The batch for the records to update.

field - (String) The field that is to be involved in determining the query results. This value is appended to the end of the sql properties key when obtaining the appropriate sql statement for the requested query.

operand - (String) The operation that the query is to perform on the given field in order to determine the query results. Currently only "contains" and "equals" are supported.

argument - (String) The query search argument. The character string that the query is to use in determining its results.

findkey - (int) The find key that is to be set in the selected pending products.

Returns:

boolean - true if the find key is successfully set, otherwise false.

setBatchMatchFind

public boolean setBatchMatchFind(int batch,
                                 java.lang.String field,
                                 java.lang.String operand,
                                 java.lang.String argument,
                                 int findkey)

Sets the find key for pending product records in the given batch number that have a field that contains characters matching the given criteria.

Parameters:

batch - (int) The batch number for the records to update.

field - (String) The field that is to be involved in determining the query results. This value is appended to the end of the sql properties key when obtaining the appropriate sql statement for the requested query.

operand - (String) The operation that the query is to perform on the given field in order to determine the query results. Currently only "contains" and "equals" are supported.

argument - (String) The query search argument. The character string that the query is to use in determining its results.

findkey - (int) The find key that is to be set in the selected pending products.

Returns:

boolean - true if the find key is successfully set, otherwise false.