Class KanbanBoardDAO

java.lang.Object

ru.bgcrm.dao.CommonDAO

ru.bgcrm.dao.process.ProcessDAO

org.bgerp.dao.process.ProcessQueueDAO

org.bgerp.plugin.kanban.dao.KanbanBoardDAO

public class KanbanBoardDAO
extends ProcessQueueDAO

Selects the card list for a Kanban board: a single process type's processes from a process queue the current user has access to, narrowed by the queue's own configured filters (applied exactly as /user/process/queue applies them) plus a mandatory type constraint, since Kanban columns are always a single type's status list.

Nested Class Summary

Nested classes/interfaces inherited from class CommonDAO

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

Field Summary

Fields inherited from class ProcessQueueDAO

LINKED_PROCESS_JOIN

Fields inherited from class ProcessDAO

form, LINKED_PROCESS, MODE_USER_CLOSED, MODE_USER_CREATED, MODE_USER_STATUS_CHANGED

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
KanbanBoardDAO(Connection con, DynActionForm form)

Method Summary

Modifier and Type	Method	Description
List<Card>	getCards(Queue queue, int typeId)

Methods inherited from class ProcessQueueDAO

addFilters, getCountQuery, prepareQueueSelect, searchProcess

Methods inherited from class ProcessDAO

deleteProcess, getIsolationJoin, getProcess, getProcessFromRs, getProcessFromRs, getProcessOrThrow, processIdInvert, searchProcessListByAddress, searchProcessListForUser, searchProcessListForUser, updateProcess, updateProcessExecutors, updateProcessGroups, updateProcessTitle

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

KanbanBoardDAO

public KanbanBoardDAO(Connection con,
 DynActionForm form)

Method Details

getCards

public List<Card> getCards(Queue queue,
 int typeId)
                    throws Exception

Parameters:

queue -

typeId - single process type to narrow down to; must be one of queue.getProcessTypeIds().

Returns:

cards ordered per the queue's selected sort combo(s), same as the request would order a plain queue table.

Throws:

Exception