Class VoiceSessionLogDao
java.lang.Object
ru.bitel.common.dao.AbstarctDaoConstant
ru.bitel.common.dao.AbstractDao<VoiceSession>
ru.bitel.bgbilling.modules.voice.server.bean.VoiceSessionLogDao
- All Implemented Interfaces:
AutoCloseable
- Direct Known Subclasses:
VoiceSessionDao
-
Nested Class Summary
Nested classes/interfaces inherited from class ru.bitel.common.dao.AbstractDao
ru.bitel.common.dao.AbstractDao.ResultSetIterator
-
Field Summary
Fields inherited from class ru.bitel.common.dao.AbstractDao
cacheFilter, cacheJoin, cacheOrderBy, cachePaged, cachePS, cacheWhat, con, getByIdPS, moduleId, orderByPattern, tableName
Fields inherited from class ru.bitel.common.dao.AbstarctDaoConstant
ERROR, fields, SQL_ALL, SQL_AND, SQL_CALC_FOUND_ROWS, SQL_DELETE, SQL_DISTINCT, SQL_EQ, SQL_EQCS, SQL_FROM, SQL_GROUP, SQL_IN, SQL_INSERT, SQL_JOIN, SQL_LEFT_JOIN, SQL_LIMIT, SQL_NOT_IN, SQL_ON, SQL_ON_DUPLICATE_KEY_UPDATE, SQL_ORDER, SQL_SELECT, SQL_SET, SQL_UPDATE, SQL_VALUES, SQL_WHERE
-
Constructor Summary
ModifierConstructorDescriptionprotected
VoiceSessionLogDao
(Connection con, int mid, String tableName) VoiceSessionLogDao
(Connection con, int mid, Date date) -
Method Summary
Modifier and TypeMethodDescriptionstatic void
checkTables
(Connection con, int moduleId, Date date) void
deleteSessions
(int divizer, int remainder, Date hour, int deviceId) void
deleteSessions
(LocalDate day, int deviceId) void
deleteSessions
(Date hour, int deviceId) get
(long id) getContractSums
(VoiceSessionFilter filter) Получение отфильтрованного списка сессий.getDetailSumValues
(VoiceSessionFilter filter) protected String
protected VoiceSession
static VoiceSession
getSessionsDetail
(VoiceSessionFilter filter, Page page) void
insertSessions
(List<VoiceSession> sessions) list()
list
(VoiceSessionFilter filter, Page page, boolean loadSessionAccount) protected int
setPsParams
(VoiceSession session, PreparedStatement ps, int idx) protected void
updateImpl
(VoiceSession session) Methods inherited from class ru.bitel.common.dao.AbstractDao
close, delete, deleteImpl, eq, get, getById, getImpl, getListFromRS, getPeriod, getQueryById, getSQLOrder, getTableName, list, list, listImpl, listImpl, listImplPS, listImplPS, ormFromResultSet, ormUpdateImpl, ormUpdateImpl, ormUpdateImpl, ormUpdateImpl, processException, recycle, setStatementParam, update
Methods inherited from class ru.bitel.common.dao.AbstarctDaoConstant
getLogger, getSQLOrder
-
Field Details
-
TABLE_VOICE_SESSION_LOG
- See Also:
-
-
Constructor Details
-
VoiceSessionLogDao
-
VoiceSessionLogDao
-
-
Method Details
-
getFromRS
protected VoiceSession getFromRS(ResultSet rs) throws SQLException, ru.bitel.bgbilling.common.BGException - Specified by:
getFromRS
in classru.bitel.common.dao.AbstractDao<VoiceSession>
- Throws:
SQLException
ru.bitel.bgbilling.common.BGException
-
getSessionFromRs
- Throws:
SQLException
-
updateImpl
protected void updateImpl(VoiceSession session) throws ru.bitel.bgbilling.common.BGException, SQLException - Specified by:
updateImpl
in classru.bitel.common.dao.AbstractDao<VoiceSession>
- Throws:
ru.bitel.bgbilling.common.BGException
SQLException
-
getFieldPart
-
setPsParams
- Throws:
SQLException
-
getContractSums
public SessionAccountAmount getContractSums(VoiceSessionFilter filter) throws ru.bitel.bgbilling.common.BGException Получение отфильтрованного списка сессий.- Parameters:
filter
- фильтр- Returns:
- отфильтрованный список сессий
- Throws:
ru.bitel.bgbilling.common.BGException
-
getSessionsGroupedByAccount
public List<SessionAccountReportItem> getSessionsGroupedByAccount(VoiceSessionFilter filter) throws ru.bitel.bgbilling.common.BGException - Throws:
ru.bitel.bgbilling.common.BGException
-
getSessionsGroupedByAccountAndDestination
public List<SessionDestinationReportItem> getSessionsGroupedByAccountAndDestination(VoiceSessionFilter filter) throws ru.bitel.bgbilling.common.BGException - Throws:
ru.bitel.bgbilling.common.BGException
-
getSessionsGroupedByAccountAndService
public List<SessionServiceReportItem> getSessionsGroupedByAccountAndService(VoiceSessionFilter filter) throws ru.bitel.bgbilling.common.BGException - Throws:
ru.bitel.bgbilling.common.BGException
-
getSessionsDetail
public List<SessionDetail<SessionDetail<SessionDetailReportItem>>> getSessionsDetail(VoiceSessionFilter filter, Page page) throws ru.bitel.bgbilling.common.BGException - Throws:
ru.bitel.bgbilling.common.BGException
-
getDetailSumValues
public Map<String,SessionDetail> getDetailSumValues(VoiceSessionFilter filter) throws ru.bitel.bgbilling.common.BGException - Throws:
ru.bitel.bgbilling.common.BGException
-
list
public List<VoiceSession> list(VoiceSessionFilter filter, Page page, boolean loadSessionAccount) throws ru.bitel.bgbilling.common.BGException - Throws:
ru.bitel.bgbilling.common.BGException
-
checkTables
public static void checkTables(Connection con, int moduleId, Date date) throws ru.bitel.bgbilling.common.BGException - Throws:
ru.bitel.bgbilling.common.BGException
-
insertSessions
public void insertSessions(List<VoiceSession> sessions) throws ru.bitel.bgbilling.common.BGException - Throws:
ru.bitel.bgbilling.common.BGException
-
deleteSessions
public void deleteSessions(LocalDate day, int deviceId) throws SQLException, ru.bitel.bgbilling.common.BGException - Throws:
SQLException
ru.bitel.bgbilling.common.BGException
-
deleteSessions
public void deleteSessions(Date hour, int deviceId) throws SQLException, ru.bitel.bgbilling.common.BGException - Throws:
SQLException
ru.bitel.bgbilling.common.BGException
-
deleteSessions
public void deleteSessions(int divizer, int remainder, Date hour, int deviceId) throws SQLException, ru.bitel.bgbilling.common.BGException - Throws:
SQLException
ru.bitel.bgbilling.common.BGException
-
list
- Throws:
ru.bitel.bgbilling.common.BGException
-
get
- Throws:
ru.bitel.bgbilling.common.BGException
-