Class StoreDAO

java.lang.Object

ru.bgcrm.dao.CommonDAO

org.bgerp.plugin.inventoru.dao.StoreDAO

public class StoreDAO
extends CommonDAO

DAO for Store (warehouses). Also handles inventoru_balance read operations.

Nested Class Summary

Nested classes/interfaces inherited from class CommonDAO

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

Field Summary

Fields inherited from class CommonDAO

con, log, 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
StoreDAO(Connection con)

Method Summary

Modifier and Type	Method	Description
void	delete(int id, int userId)
static Store	fromRs(ResultSet rs)
Store	get(int id)
BigDecimal	getAvailable(int storeId, int itemId)	Gets available (quantity - reserved) balance for an item in a store.
Map<Integer,String>	getByParamNotEmpty(int paramId)	Stores carrying a value in the given parameter — how a store says which 1C base it belongs to: the connector names the parameter, a store with something in it takes part in that exchange.
BigDecimal	getCurrentQuantity(int storeId, int itemId)	Gets the raw recorded quantity (not quantity-reserved) for an item in a store — the baseline an inventory-count correction (adjustment movement) is computed against.
int	getIdByExtIdParam(int extIdParamId, String extId)
Set<Integer>	getIdsByEditGroupIds(Set<Integer> groupIds)	Returns IDs of non-deleted stores whose edit_group_id is one of the given groups — e.g.
Set<Integer>	getIdsByOwner(int userId)	Returns IDs of non-deleted stores personally owned by the given user (store.user_id).
List<Store>	getList(boolean includeDeleted)
void	restore(int id)	Undoes a delete: it is a soft one, and until now there was no way back from it.
void	update(Store store, int userId)

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

Constructor Details

StoreDAO

public StoreDAO(Connection con)

Method Details

getList

public List<Store> getList(boolean includeDeleted)
                    throws SQLException

Throws:

SQLException

get

public Store get(int id)
          throws SQLException

Throws:

SQLException

update

public void update(Store store,
 int userId)
            throws SQLException

Throws:

SQLException

delete

public void delete(int id,
 int userId)
            throws SQLException

Throws:

SQLException

restore

public void restore(int id)
             throws SQLException

Undoes a delete: it is a soft one, and until now there was no way back from it.

Throws:

SQLException

getIdsByOwner

public Set<Integer> getIdsByOwner(int userId)
                           throws SQLException

Returns IDs of non-deleted stores personally owned by the given user (store.user_id).

Throws:

SQLException

getIdsByEditGroupIds

public Set<Integer> getIdsByEditGroupIds(Set<Integer> groupIds)
                                  throws SQLException

Returns IDs of non-deleted stores whose edit_group_id is one of the given groups — e.g. a "кладовщик" group shared by several users managing the same store.

Throws:

SQLException

getByParamNotEmpty

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

Stores carrying a value in the given parameter — how a store says which 1C base it belongs to: the connector names the parameter, a store with something in it takes part in that exchange. Deleted stores are left out (they would be polled every cycle and revive their pending rows), and so are empty values — the kernel usually deletes an emptied value, but rows written straight into the table by hand outlive that.

Returns:

store id to the value, in no particular order

Throws:

SQLException

getIdByExtIdParam

public int getIdByExtIdParam(int extIdParamId,
 String extId)
                      throws SQLException

Throws:

SQLException

getAvailable

public BigDecimal getAvailable(int storeId,
 int itemId)
                        throws SQLException

Gets available (quantity - reserved) balance for an item in a store. Returns 0 if no balance record exists.

Throws:

SQLException

getCurrentQuantity

public BigDecimal getCurrentQuantity(int storeId,
 int itemId)
                              throws SQLException

Gets the raw recorded quantity (not quantity-reserved) for an item in a store — the baseline an inventory-count correction (adjustment movement) is computed against. Returns 0 if no balance record exists.

Throws:

SQLException

fromRs

public static Store fromRs(ResultSet rs)
                    throws SQLException

Throws:

SQLException