Package ru.bgcrm.dao.work

Class TabelDAO

java.lang.Object

ru.bgcrm.dao.CommonDAO

ru.bgcrm.dao.work.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, dateFormat_DDMMYYYY, dateFormat_DDMMYYYY_HHMM, log, SQL_AND, SQL_DELETE, SQL_DESC, SQL_FROM, SQL_GROUP_BY, SQL_INNER_JOIN, SQL_INSERT, SQL_INSERT_IGNORE, SQL_LEFT_JOIN, SQL_LEFT_OUTER_JOIN, SQL_LIMIT, SQL_ON_DUP_KEY_UPDATE, SQL_OR, SQL_ORDER_BY, SQL_REPLACE, SQL_SELECT, SQL_SELECT_ALL_FROM, SQL_SELECT_COUNT_ROWS, SQL_SET, SQL_UPDATE, SQL_WHERE

Constructor Summary

Constructors

Constructor	Description
TabelDAO(Connection con)

Method Summary

Modifier and Type	Method	Description
void	createMistakesTabelFile(javax.servlet.http.HttpServletResponse response, Calendar fromDate, Calendar toDate, List<Map<String,Object>> mistakes)
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

buildPlaceholders, deleteById, execute, execute, execute, executeBatch, executeInsert, executeUpdate, getById, getFoundRows, getFoundRows, getGroupedIds, getGroupedIds, getIds, getIds, getLikePattern, getLikePatternEnd, getLikePatternStart, getLikePatternSub, getMySQLLimit, getPeriodSql, lastInsertId, setPeriodParamValue, setRecordCount, sqlToBgException, update, updateColumn, updateIds, updateIds

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 BGException,
IOException

Throws:

BGException

IOException

createUserRows

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

createMistakesTabelFile

public void createMistakesTabelFile(javax.servlet.http.HttpServletResponse response,
 Calendar fromDate,
 Calendar toDate,
 List<Map<String,Object>> mistakes)
                             throws IOException

Throws:

IOException