Class MinLevelDAO

java.lang.Object

ru.bgcrm.dao.CommonDAO

org.bgerp.plugin.inventoru.dao.MinLevelDAO

public class MinLevelDAO
extends CommonDAO

DAO for inventoru_min_level — per store+item minimum stock thresholds used to flag "running low" rows in the balance view. Absence of a row means no threshold is set (never flagged), not a threshold of zero.

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
MinLevelDAO(Connection con)

Method Summary

Modifier and Type	Method	Description
Map<Integer, BigDecimal>	getMapByStore(int storeId)	Returns itemId -> min_quantity for all thresholds set on a store.
void	set(int storeId, int itemId, BigDecimal minQuantity)	Sets (or clears, when minQuantity is null) the threshold for a store+item pair.

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

MinLevelDAO

public MinLevelDAO(Connection con)

Method Details

getMapByStore

public Map<Integer, BigDecimal> getMapByStore(int storeId)
                                       throws SQLException

Returns itemId -> min_quantity for all thresholds set on a store.

Throws:

SQLException

set

public void set(int storeId,
 int itemId,
 BigDecimal minQuantity)
         throws SQLException

Sets (or clears, when minQuantity is null) the threshold for a store+item pair.

Throws:

SQLException