Package ru.bgcrm.dao.work
Class TabelDAO
java.lang.Object
ru.bgcrm.dao.CommonDAO
ru.bgcrm.dao.work.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, 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 -
Method Summary
Modifier and TypeMethodDescriptionvoidcreateMistakesTabelFile(javax.servlet.http.HttpServletResponse response, Calendar fromDate, Calendar toDate, List<Map<String, Object>> mistakes) static voidcreateUserRows(org.apache.poi.hssf.usermodel.HSSFSheet sheet, int toRow, List<org.apache.poi.ss.util.CellRangeAddress> rangesForCopy) org.apache.poi.hssf.usermodel.HSSFWorkbookgenerateTabel(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
-
Constructor Details
-
TabelDAO
-
-
Method Details
-
generateTabel
public org.apache.poi.hssf.usermodel.HSSFWorkbook generateTabel(CallboardConfig.Callboard callboard, Date dateFrom, Date dateTo) throws BGException, IOException - Throws:
BGExceptionIOException
-
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
-