Package org.bgerp.plugin.pln.callboard.dao

Class TabelDAO

java.lang.Object

ru.bgcrm.dao.CommonDAO

org.bgerp.plugin.pln.callboard.dao.TabelDAO

public class TabelDAO
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
TabelDAO(Connection con)

Method Summary

Modifier and Type	Method	Description
static void	createUserRows(org.apache.poi.hssf.usermodel.HSSFSheet sheet, int toRow, List<org.apache.poi.ss.util.CellRangeAddress> rangesForCopy)
org.apache.poi.hssf.usermodel.HSSFWorkbook	generateTabel(CallboardConfig.Callboard callboard, Date dateFrom, Date dateTo)

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

TabelDAO

public TabelDAO(Connection con)

Method Details

generateTabel

public org.apache.poi.hssf.usermodel.HSSFWorkbook generateTabel(CallboardConfig.Callboard callboard,
 Date dateFrom,
 Date dateTo)
                                                         throws Exception

Throws:

Exception

createUserRows

public static void createUserRows(org.apache.poi.hssf.usermodel.HSSFSheet sheet,
 int toRow,
 List<org.apache.poi.ss.util.CellRangeAddress> rangesForCopy)