Package org.bgerp.plugin.inventory.dao

Class StoreAccessDAO

java.lang.Object

ru.bgcrm.dao.CommonDAO

org.bgerp.plugin.inventory.dao.StoreAccessDAO

public class StoreAccessDAO
extends CommonDAO

DAO for inventory_store_access — engineer access periods to warehouses.

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

Method Summary

Modifier and Type	Method	Description
void	add(int storeId, int userId, Date dateFrom, Date dateTo)	Inserts an access record.
void	closePeriod(int id, Date closeTo)	Closes the open period (sets date_to) for the record identified by id.
void	delete(int id)	Deletes an access record by id.
Set<Integer>	getActiveStoreIds(int userId, Date date)	Returns store IDs accessible to a user on a given date.
List<StoreAccess>	getList(int storeId)	Returns all access records for a given store (for admin UI).

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

StoreAccessDAO

public StoreAccessDAO(Connection con)

Method Details

getList

public List<StoreAccess> getList(int storeId)
                          throws SQLException

Returns all access records for a given store (for admin UI).

Throws:

SQLException

getActiveStoreIds

public Set<Integer> getActiveStoreIds(int userId,
 Date date)
                               throws SQLException

Returns store IDs accessible to a user on a given date. A null date_to means indefinite access.

Throws:

SQLException

add

public void add(int storeId,
 int userId,
 Date dateFrom,
 Date dateTo)
         throws SQLException

Inserts an access record.

Throws:

SQLException

delete

public void delete(int id)
            throws SQLException

Deletes an access record by id.

Throws:

SQLException

closePeriod

public void closePeriod(int id,
 Date closeTo)
                 throws SQLException

Closes the open period (sets date_to) for the record identified by id.

Throws:

SQLException