Class TabelDAO
java.lang.Object
ru.bgcrm.dao.CommonDAO
org.bgerp.plugin.pln.callboard.dao.TabelDAO
-
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 TypeMethodDescriptionstatic 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
-
Constructor Details
-
TabelDAO
-
-
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)
-