Class StoreDAO

java.lang.Object

ru.bgcrm.dao.CommonDAO

org.bgerp.plugin.inventory.dao.StoreDAO

public class StoreDAO
extends CommonDAO

DAO for Store (warehouses). Also handles inventory_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.
int	getIdByExtIdParam(int extIdParamId, String extId)	Looks up a store by ext_id parameter value in param_text.
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	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

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

getIdByExtIdParam

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

Looks up a store by ext_id parameter value in param_text.

Parameters:

extIdParamId - param_id of the ext_id parameter (configured per instance)

extId - external ID value to search

Returns:

store id, or 0 if not found

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

fromRs

public static Store fromRs(ResultSet rs)
                    throws SQLException

Throws:

SQLException