Package org.bgerp.plugin.pln.grpl.dao
Class GrplDAO
java.lang.Object
ru.bgcrm.dao.CommonDAO
org.bgerp.plugin.pln.grpl.dao.GrplDAO
-
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, SQL_INSERT_IGNORE, 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_WHERE
-
Constructor Summary
-
Method Summary
Modifier and TypeMethodDescriptiongetBoardData
(BoardConfig board, Date dateFrom, Date dateTo) getBoardRow
(BoardConfig board, Date date) getProcessSlot
(BoardConfig board, Process process) getProcessSlots
(BoardConfig board, Date dateFrom, int columnId) void
setBoardGroup
(int boardId, Date date, int columnId, int groupId) Methods inherited from class ru.bgcrm.dao.CommonDAO
deleteById, foundRows, getById, getFoundRows, getGroupedIds, getGroupedIds, getIds, getIds, getLikePatternEnd, getLikePatternStart, getLikePatternSub, getPageLimit, getPeriodSql, lastInsertId, setPeriodParamValue, setRecordCount, sqlToBgException, update, updateColumn, updateIds, updateIds, updateOrInsert
-
Constructor Details
-
GrplDAO
-
-
Method Details
-
getBoardData
public Collection<Row> getBoardData(BoardConfig board, Date dateFrom, Date dateTo) throws SQLException - Throws:
SQLException
-
getBoardRow
- Throws:
SQLException
-
setBoardGroup
- Throws:
SQLException
-
getProcessSlot
- Throws:
SQLException
-
getProcessSlots
public List<Row> getProcessSlots(BoardConfig board, Date dateFrom, int columnId) throws SQLException - Throws:
SQLException
-