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 and Description
TabelDAO(java.sql.Connection con)

Method Summary

Modifier and Type	Method and Description
void	createMistakesTabelFile(HttpServletResponse response, java.util.Calendar fromDate, java.util.Calendar toDate, java.util.List<java.util.Map<java.lang.String,java.lang.Object>> mistakes)
static void	createUserRows(HSSFSheet sheet, int toRow, java.util.List<CellRangeAddress> rangesForCopy)
HSSFWorkbook	generateTabel(CallboardConfig.Callboard callboard, java.util.Date dateFrom, java.util.Date dateTo)

Methods inherited from class ru.bgcrm.dao.CommonDAO

deleteById, execute, execute, execute, 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 Detail

TabelDAO

public TabelDAO(java.sql.Connection con)

Method Detail

generateTabel

public HSSFWorkbook generateTabel(CallboardConfig.Callboard callboard,
                                  java.util.Date dateFrom,
                                  java.util.Date dateTo)
                           throws BGException,
                                  java.io.IOException

Throws:

BGException

java.io.IOException

createUserRows

public static void createUserRows(HSSFSheet sheet,
                                  int toRow,
                                  java.util.List<CellRangeAddress> rangesForCopy)

createMistakesTabelFile

public void createMistakesTabelFile(HttpServletResponse response,
                                    java.util.Calendar fromDate,
                                    java.util.Calendar toDate,
                                    java.util.List<java.util.Map<java.lang.String,java.lang.Object>> mistakes)
                             throws java.io.IOException

Throws:

java.io.IOException