Package ru.bgcrm.dao

Class PonParamValueDAO

java.lang.Object

ru.bgcrm.dao.CommonDAO

ru.bgcrm.dao.ParamValueDAO

ru.bgcrm.dao.PonParamValueDAO

public class PonParamValueDAO
extends ParamValueDAO

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.ParamValueDAO

history, PARAM_ADDRESS_FIELD_FLAT, PARAM_ADDRESS_FIELD_QUARTER, PARAM_ADDRESS_FIELD_STREET, PARAM_ADDRESS_FIELDS

Fields inherited from class ru.bgcrm.dao.CommonDAO

con, dateFormat_DDMMYYYY, dateFormat_DDMMYYYY_HHMM, 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
PonParamValueDAO(Connection con)

Method Summary

Modifier and Type	Method	Description
Map<String,Map<IdTitle,Map<IdTitle,Map<Date,Integer>>>>	getProcessesStatisticsCommon(Date dateFrom, Date dateTo)

Methods inherited from class ru.bgcrm.dao.ParamValueDAO

addElement, buildSearchByFilledParamsQuery, copyParam, copyParam, copyParams, copyParams, deleteElement, deleteParams, getObjectIdAndParamIdByLineId, getParamAddress, getParamAddress, getParamAddressExt, getParamAddressExt, getParamAddressFirst, getParamBlob, getParamBoolean, getParamDate, getParamDateTime, getParamEmail, getParamEmail, getParameterAddressValueFromRs, getParameterAddressValueFromRs, getParameterAddressValueFromRs, getParameterPhoneValueItems, getParamFile, getParamFile, getParamFile, getParamFileFirst, getParamFilesByPositions, getParamJoinFilters, getParamList, getParamListAsBool, getParamListCount, getParamListCountWithTitles, getParamListCountWithTitlesAndCount, getParamListCountWithTitlesAndValues, getParamListWithComments, getParamListWithTitles, getParamListWithTitlesAndComments, getParamNumber, getParamObjectList, getParamPhone, getParamText, getParamTree, getParamTreeWithTitles, getProcessFilledParamIds, isParameterFilled, loadParameters, loadParameterValue, objectIdInvert, paramSelectQuery, paramValueFilter, saveElement, searchObjectByDateAndMonth, searchObjectByDateParam, searchObjectByFilledParams, searchObjectByParameterAddress, searchObjectByParameterPhone, searchObjectByParameterText, updateParamAddress, updateParamBlob, updateParamBoolean, updateParamDate, updateParamDateTime, updateParamEmail, updateParamFile, updateParamList, updateParamList, updateParamListAsBool, updateParamListCount, updateParamNumber, updateParamPhone, updateParamsAddressOnHouseUpdate, updateParamText, updateParamTree, updateParamValueMap, updatePosition

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

PonParamValueDAO

public PonParamValueDAO(Connection con)

Method Details

getProcessesStatisticsCommon

public Map<String,Map<IdTitle,Map<IdTitle,Map<Date,Integer>>>> getProcessesStatisticsCommon(Date dateFrom,
 Date dateTo)
                                                                                     throws BGException

Throws:

BGException