Package overit.geocallapp.wfm.inventory.replicator.data

Class DAInventoryWarehouse

java.lang.Object

overit.geocall.da.DABase

overit.geocallapp.replicator.basic.base.DataSource.DABaseReplicator

overit.geocallapp.wfm.replicator.datasource.DAReplicatorWfmBase

overit.geocallapp.wfm.inventory.replicator.data.DAInventoryWarehouse

All Implemented Interfaces:

Serializable, DataAttributesHolder, EDMConfigurableBean, overit.geocall.marks.FieldExposer, overit.geocall.marks.NameExposer, DBFieldMapper, DBObjectMapper, Identified, Tool, overit.geocallapp.replicator.basic.base.DataSource.IDSDABase

public class DAInventoryWarehouse
extends overit.geocallapp.wfm.replicator.datasource.DAReplicatorWfmBase

Data extraction queries for Inventory Management Module

Since:

13.0

See Also:

• Serialized Form

Nested Class Summary

Nested Classes

Modifier and Type	Class	Description
static class	DAInventoryWarehouse.TransactionParameterNames

Field Summary

Fields

Modifier and Type	Field	Description
static final int	SELECT_TOMBSTONES_TR_ITEMS
static final int	SELECT_TOMBSTONES_TR_MATERIALS
static final int	SELECT_TR_MATERIALS
static final int	SELECT_USER_STOCKS
static final int	SELECT_USER_TRANSFER_REQUESTS
static final int	SELECT_USER_TRANSFER_REQUESTS_ITEMS
static final int	SELECT_USER_TRANSFER_REQUESTS_SERIALIZED_MATERIALS
static final int	SELECT_USER_WAREHOUSE_MATERIALS
static final int	SELECT_USER_WAREHOUSES
static final int	SELECT_WAREHOUSE_AGENDA_MATERIALS
static final int	SELECT_WAREHOUSE_AGENDA_SERIALIZED_MATERIALS
static final int	SELECT_WAREHOUSE_IN_WAREHOUSE_MATERIALS

Fields inherited from class overit.geocallapp.wfm.replicator.datasource.DAReplicatorWfmBase

COMMAND_NONE, COMMAND_NOT_ALLOWED, LOG, RESET_TOMBSTONE_VALUE

Fields inherited from class overit.geocallapp.replicator.basic.base.DataSource.DABaseReplicator

_table

Fields inherited from class overit.geocall.da.DABase

DA_BASE_FILTER_PREFIX, DELETE_FILTER, DELETE_PK, INSATE, INSERT, REPLACE_DBVIEW, SAVE_DBVIEW, SELECT_FILTER, SELECT_NONE, SELECT_PK, UPDATE_FILTER, UPDATE_PK, UPSERT

Constructor Summary

Constructors

Constructor	Description
DAInventoryWarehouse()

Method Summary

Modifier and Type	Method	Description
protected void	appendCustomTombstone(ArrayList<String> alTombstones, HashGetter filter, Date lastSync, Long idPda, PooledConnection conn, PooledConnection externalConn)
protected String	getSelectSql(String fields)
protected String	getSelectWithChangeSql(String fields)
protected String	getSelectWithChangeSql(String fields, String datastamp)
protected int	giveCommands(int i, PooledConnection conn, DBStatement stmt, HashGetter oKeys, HashGetter oParams)	Implements new specific commands that are different from the standard ones.
protected DBView	giveQueries(int i, PooledConnection conn, DBStatement stmt, HashGetter filter, int maxrows, int skiprows)	Implements new specific queries that are different from the standard ones.

Methods inherited from class overit.geocallapp.wfm.replicator.datasource.DAReplicatorWfmBase

acknowledge, addCustomTombStone, addResetTombstone, addResetTombstone, addTombstones, buildTableTombstone, calcIdReplicationOperationsCenter, containsResetTombstone, getFilialeAuteLoginPda, getIdAuteUltimaModificaPda, getIdOperationsCenterCustom, getIdPdaFk, getIdServerFk, getListaFiliali, getSyncParams, getTombstoneFkTable, getTombstoneFromDBView, getUserOperationsCenter, getUserVisibilitySettings, giveBranchField, giveDBFieldMap, giveDBObjectMap, giveFactoryField, giveOrderCols, givePoolName, givePrimaryKeys, giveSequenceField, giveTableName, isBlankLastSync, isInitialSync, isUnidentifiedMobileUser, isUnidentifiedMobileUser, isUserSafety, loadUserVisibilitySettings, needsResetTombstone, postOperation, postProcessDataForPda, preOperation, setSqlSelectFkTable, setSqlSelectFkTable, setSqlUnionDifferential

Methods inherited from class overit.geocallapp.replicator.basic.base.DataSource.DABaseReplicator

preInsert, preUpdate, setReplicationParam, setReplicationTable

Methods inherited from class overit.geocall.da.DABase

command, command, command, getAutoIncrementVal, getDataAttributes, getDBFieldMap, getDBFields, getDBObjectMap, getFieldMap, getIdentity, getQueryId, getQueryId, getReadOnlyCols, getSequenceNextVal, getTeacher, giveIsDistinct, giveIsService, giveMinLevel, giveStar, hasNotBeenDecorated, haveDBFieldMap, haveDBObjectMap, markAsDecorated, postDelete, postInsert, postUpdate, preDelete, preQuery, query, query, query, query, query, release, removeReadOnlyCols, replace, replace, save, save, setDataAttributes, setDBFieldMap, setDBObjectMap, setIdentity, setReadOnlyCols, useConnection

Methods inherited from class java.lang.Object

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

Methods inherited from interface overit.geocall.edm.model.DataAttributesHolder

getEntities

Methods inherited from interface overit.geocall.edm.model.EDMConfigurableBean

getEntity, hasEntity

Field Details

SELECT_USER_WAREHOUSES

public static final int SELECT_USER_WAREHOUSES

See Also:

• Constant Field Values

SELECT_USER_WAREHOUSE_MATERIALS

public static final int SELECT_USER_WAREHOUSE_MATERIALS

See Also:

• Constant Field Values

SELECT_USER_STOCKS

public static final int SELECT_USER_STOCKS

See Also:

• Constant Field Values

SELECT_USER_TRANSFER_REQUESTS

public static final int SELECT_USER_TRANSFER_REQUESTS

See Also:

• Constant Field Values

SELECT_USER_TRANSFER_REQUESTS_ITEMS

public static final int SELECT_USER_TRANSFER_REQUESTS_ITEMS

See Also:

• Constant Field Values

SELECT_TR_MATERIALS

public static final int SELECT_TR_MATERIALS

See Also:

• Constant Field Values

SELECT_USER_TRANSFER_REQUESTS_SERIALIZED_MATERIALS

public static final int SELECT_USER_TRANSFER_REQUESTS_SERIALIZED_MATERIALS

See Also:

• Constant Field Values

SELECT_WAREHOUSE_IN_WAREHOUSE_MATERIALS

public static final int SELECT_WAREHOUSE_IN_WAREHOUSE_MATERIALS

See Also:

• Constant Field Values

SELECT_TOMBSTONES_TR_ITEMS

public static final int SELECT_TOMBSTONES_TR_ITEMS

See Also:

• Constant Field Values

SELECT_TOMBSTONES_TR_MATERIALS

public static final int SELECT_TOMBSTONES_TR_MATERIALS

See Also:

• Constant Field Values

SELECT_WAREHOUSE_AGENDA_MATERIALS

public static final int SELECT_WAREHOUSE_AGENDA_MATERIALS

See Also:

• Constant Field Values

SELECT_WAREHOUSE_AGENDA_SERIALIZED_MATERIALS

public static final int SELECT_WAREHOUSE_AGENDA_SERIALIZED_MATERIALS

See Also:

• Constant Field Values

Constructor Details

DAInventoryWarehouse

public DAInventoryWarehouse()

Method Details

giveQueries

protected DBView giveQueries(int i,
 PooledConnection conn,
 DBStatement stmt,
 HashGetter filter,
 int maxrows,
 int skiprows)
                      throws SQLException

Description copied from class: DABase

Implements new specific queries that are different from the standard ones.
For all the queries implemented with this method we must set, in the DBStatement, the SQL (setSql()), the parameters (available as filters and settable using set()) and any map (setDBObjectMap(), setDBFieldMap()) to use on the DBStatement.
The execution is done when we call one of the query() methods, so we can do here only the statement setup.
It is fundamental that the method return null if the query id is not recognized.

Overrides:

giveQueries in class overit.geocallapp.wfm.replicator.datasource.DAReplicatorWfmBase

Parameters:

i - The id of the query

conn - Connection from which we have extracted the DBStatement; it can be used to extract other DBStatement

stmt - DBStatement used to set the SQL code and the parameters

filter - Parameters to set in the DBStatement

maxrows - Maximum rows number extracted with the query

skiprows - Number of initial lines that you do not want to be returned. Even these lines, although skipped, are counted in the maxrows parameter.

Returns:

If the query id is valid we must return the DBStatement passed as parameter; if the is is not valid, or we don't want to add specific queries to the standard ones we must return null

Throws:

SQLException - If there is an error in the SQL SQLException is thrown

getSelectWithChangeSql

protected String getSelectWithChangeSql(String fields)

getSelectWithChangeSql

protected String getSelectWithChangeSql(String fields,
 String datastamp)

getSelectSql

protected String getSelectSql(String fields)

giveCommands

protected int giveCommands(int i,
 PooledConnection conn,
 DBStatement stmt,
 HashGetter oKeys,
 HashGetter oParams)
                    throws SQLException

Description copied from class: DABase

Implements new specific commands that are different from the standard ones.
For all the commands implemented with this method we must set, in the DBStatement, the SQL (setSql()), (setDBObjectMap(), setDBFieldMap()) to use on the DBStatement.
The execution is done when we call one of the command() methods, so we can do here only the statement setup.
It is fundamental that the method return null if the command id is not recognized.

Overrides:

giveCommands in class overit.geocallapp.wfm.replicator.datasource.DAReplicatorWfmBase

Parameters:

i - The id of the command

conn - Connection from which we have extracted the DBStatement; it can be used to extract other DBStatement

stmt - DBStatement used to set the SQL code and the parameters

oKeys - Values used as filters to set for the update commands

oParams - Values to set as parameters in the DBStatement

Returns:

If the command id is valid we must return the DBStatement passed as parameter; if the id is not valid, or we don't want to add specific commands to the standard ones we must return null

Throws:

SQLException - If there is an error in the SQL SQLException is thrown

appendCustomTombstone

protected void appendCustomTombstone(ArrayList<String> alTombstones,
 HashGetter filter,
 Date lastSync,
 Long idPda,
 PooledConnection conn,
 PooledConnection externalConn)
                              throws DAException

Overrides:

appendCustomTombstone in class overit.geocallapp.wfm.replicator.datasource.DAReplicatorWfmBase

Throws:

DAException