Class StoreAccessDAO

java.lang.Object

ru.bgcrm.dao.CommonDAO

org.bgerp.plugin.inventoru.dao.StoreAccessDAO

public class StoreAccessDAO
extends CommonDAO

DAO for inventoru_store_access — access periods to warehouses, granted either to a user or to a user group.

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

Method Summary

Modifier and Type	Method	Description
void	add(int storeId, int userId, int groupId, Date dateFrom, Date dateTo)	Inserts an access record granted either to a user or to a group — the other ID is 0.
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, Set<Integer> groupIds, Date date)	Returns store IDs accessible on a given date to the user personally or to any of the groups they are in.
List<StoreAccess>	getList(int storeId)	Returns all access records for a given store (for admin UI).

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

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,
 Set<Integer> groupIds,
 Date date)
                               throws SQLException

Returns store IDs accessible on a given date to the user personally or to any of the groups they are in. A null date_to means indefinite access.

Parameters:

groupIds - the user's groups, may be empty — then only personal grants count.

Throws:

SQLException

add

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

Inserts an access record granted either to a user or to a group — the other ID is 0.

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