Package org.bgerp.plugin.pln.grpl.dao

Class GrplDAO

java.lang.Object

ru.bgcrm.dao.CommonDAO

org.bgerp.plugin.pln.grpl.dao.GrplDAO

public class GrplDAO
extends CommonDAO

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

Constructors

Constructor	Description
GrplDAO(Connection con)

Method Summary

Modifier and Type	Method	Description
Collection<Row>	getBoardData(BoardConfig board, Date dateFrom, Date dateTo)
Row	getBoardRow(BoardConfig board, Date date)
Slot	getProcessSlot(BoardConfig board, Process process)
List<Row>	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

Methods inherited from class java.lang.Object

clone, equals, finalize, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait

Constructor Details

GrplDAO

public GrplDAO(Connection con)

Method Details

getBoardData

public Collection<Row> getBoardData(BoardConfig board,
 Date dateFrom,
 Date dateTo)
                             throws SQLException

Throws:

SQLException

getBoardRow

public Row getBoardRow(BoardConfig board,
 Date date)
                throws SQLException

Throws:

SQLException

setBoardGroup

public void setBoardGroup(int boardId,
 Date date,
 int columnId,
 int groupId)
                   throws SQLException

Throws:

SQLException

getProcessSlot

public Slot getProcessSlot(BoardConfig board,
 Process process)
                    throws SQLException

Throws:

SQLException

getProcessSlots

public List<Row> getProcessSlots(BoardConfig board,
 Date dateFrom,
 int columnId)
                          throws SQLException

Throws:

SQLException