Class QueueDAO

java.lang.Object

ru.bgcrm.dao.CommonDAO

org.bgerp.plugin.inventoru.dao.queue.QueueDAO

public class QueueDAO
extends CommonDAO

Nested Class Summary

Nested classes/interfaces inherited from class CommonDAO

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

Field Summary

Fields inherited from class CommonDAO

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

Method Summary

Modifier and Type	Method	Description
void	delete(int id)
Queue	get(int id)
List<Queue>	getAll()
void	search(Pageable<Object[]> result, Queue queue, DynActionForm form, Set<Integer> restrictedStoreIds)	Executes a dynamic search for stores based on queue column/filter config.
void	update(Queue queue, 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

QueueDAO

public QueueDAO(Connection con)

Method Details

getAll

public List<Queue> getAll()
                   throws SQLException

Throws:

SQLException

get

public Queue get(int id)
          throws SQLException

Throws:

SQLException

update

public void update(Queue queue,
 int userId)
            throws SQLException

Throws:

SQLException

delete

public void delete(int id)
            throws SQLException

Throws:

SQLException

search

public void search(Pageable<Object[]> result,
 Queue queue,
 DynActionForm form,
 Set<Integer> restrictedStoreIds)
            throws SQLException

Executes a dynamic search for stores based on queue column/filter config. Row structure: Object[0] = store id (int), Object[1..N] = column values (String).

Parameters:

restrictedStoreIds - null for unrestricted (admin-tier) users; otherwise the caller's StoreAccess grants — an empty set means the user has no access to any store.

Throws:

SQLException