Package org.bgerp.plugin.inventory.dao

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 ru.bgcrm.dao.CommonDAO

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

Field Summary

Fields inherited from class ru.bgcrm.dao.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.
List<Store>	getList(boolean includeDeleted)
void	update(Store store, int userId)

Methods inherited from class ru.bgcrm.dao.CommonDAO

deleteById, foundRows, getById, getGroupedIds, getGroupedIds, getIds, getIds, getPageLimit, getPeriodSql, lastInsertId, setPeriodParamValue, setRecordCount, update, updateColumn, updateIds, updateIds, updateOrInsert

Methods inherited from class java.lang.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

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