public class VoiceSessionLogDao extends ru.bitel.common.dao.AbstractDao<VoiceSession>
Modifier and Type | Field and Description |
---|---|
protected static org.apache.log4j.Logger |
logger |
static java.lang.String |
TABLE_VOICE_SESSION_LOG |
Modifier | Constructor and Description |
---|---|
|
VoiceSessionLogDao(java.sql.Connection con,
int mid,
java.util.Date date) |
protected |
VoiceSessionLogDao(java.sql.Connection con,
int mid,
java.lang.String tableName) |
Modifier and Type | Method and Description |
---|---|
static void |
checkTables(java.sql.Connection con,
int moduleId,
java.util.Date date) |
void |
deleteSessions(int divizer,
int remainder,
java.util.Date hour,
int deviceId) |
VoiceSession |
get(long id) |
SessionAccountAmount |
getContractSums(VoiceSessionFilter filter)
Получение отфильтрованного списка сессий.
|
java.util.Map<java.lang.String,ru.bitel.bgbilling.modules.voice.api.common.bean.report.SessionDetail> |
getDetailSumValues(VoiceSessionFilter filter) |
protected java.lang.String |
getFieldPart() |
protected VoiceSession |
getFromRS(java.sql.ResultSet rs) |
static VoiceSession |
getSessionFromRs(java.sql.ResultSet rs) |
java.util.List<ru.bitel.bgbilling.modules.voice.api.common.bean.report.SessionDetail<ru.bitel.bgbilling.modules.voice.api.common.bean.report.SessionDetail<ru.bitel.bgbilling.modules.voice.api.common.bean.report.SessionDetailReportItem>>> |
getSessionsDetail(VoiceSessionFilter filter,
Page page) |
java.util.List<ru.bitel.bgbilling.modules.voice.api.common.bean.report.SessionAccountReportItem> |
getSessionsGroupedByAccount(VoiceSessionFilter filter) |
java.util.List<ru.bitel.bgbilling.modules.voice.api.common.bean.report.SessionDestinationReportItem> |
getSessionsGroupedByAccountAndDestination(VoiceSessionFilter filter) |
java.util.List<ru.bitel.bgbilling.modules.voice.api.common.bean.report.SessionServiceReportItem> |
getSessionsGroupedByAccountAndService(VoiceSessionFilter filter) |
void |
insertSessions(java.util.List<VoiceSession> sessions) |
java.util.List<VoiceSession> |
list() |
java.util.List<VoiceSession> |
list(VoiceSessionFilter filter,
Page page,
boolean loadSessionAccount) |
protected int |
setPsParams(VoiceSession session,
java.sql.PreparedStatement ps,
int idx) |
protected void |
updateImpl(VoiceSession session) |
protected static final org.apache.log4j.Logger logger
public static final java.lang.String TABLE_VOICE_SESSION_LOG
public VoiceSessionLogDao(java.sql.Connection con, int mid, java.util.Date date)
protected VoiceSessionLogDao(java.sql.Connection con, int mid, java.lang.String tableName)
protected VoiceSession getFromRS(java.sql.ResultSet rs) throws java.sql.SQLException, ru.bitel.bgbilling.common.BGException
getFromRS
in class ru.bitel.common.dao.AbstractDao<VoiceSession>
java.sql.SQLException
ru.bitel.bgbilling.common.BGException
public static VoiceSession getSessionFromRs(java.sql.ResultSet rs) throws java.sql.SQLException
java.sql.SQLException
protected void updateImpl(VoiceSession session) throws ru.bitel.bgbilling.common.BGException, java.sql.SQLException
updateImpl
in class ru.bitel.common.dao.AbstractDao<VoiceSession>
ru.bitel.bgbilling.common.BGException
java.sql.SQLException
protected java.lang.String getFieldPart()
protected int setPsParams(VoiceSession session, java.sql.PreparedStatement ps, int idx) throws java.sql.SQLException
java.sql.SQLException
public SessionAccountAmount getContractSums(VoiceSessionFilter filter) throws ru.bitel.bgbilling.common.BGException
filter
- фильтрru.bitel.bgbilling.common.BGException
public java.util.List<ru.bitel.bgbilling.modules.voice.api.common.bean.report.SessionAccountReportItem> getSessionsGroupedByAccount(VoiceSessionFilter filter) throws ru.bitel.bgbilling.common.BGException
ru.bitel.bgbilling.common.BGException
public java.util.List<ru.bitel.bgbilling.modules.voice.api.common.bean.report.SessionDestinationReportItem> getSessionsGroupedByAccountAndDestination(VoiceSessionFilter filter) throws ru.bitel.bgbilling.common.BGException
ru.bitel.bgbilling.common.BGException
public java.util.List<ru.bitel.bgbilling.modules.voice.api.common.bean.report.SessionServiceReportItem> getSessionsGroupedByAccountAndService(VoiceSessionFilter filter) throws ru.bitel.bgbilling.common.BGException
ru.bitel.bgbilling.common.BGException
public java.util.List<ru.bitel.bgbilling.modules.voice.api.common.bean.report.SessionDetail<ru.bitel.bgbilling.modules.voice.api.common.bean.report.SessionDetail<ru.bitel.bgbilling.modules.voice.api.common.bean.report.SessionDetailReportItem>>> getSessionsDetail(VoiceSessionFilter filter, Page page) throws ru.bitel.bgbilling.common.BGException
ru.bitel.bgbilling.common.BGException
public java.util.Map<java.lang.String,ru.bitel.bgbilling.modules.voice.api.common.bean.report.SessionDetail> getDetailSumValues(VoiceSessionFilter filter) throws ru.bitel.bgbilling.common.BGException
ru.bitel.bgbilling.common.BGException
public java.util.List<VoiceSession> list(VoiceSessionFilter filter, Page page, boolean loadSessionAccount) throws ru.bitel.bgbilling.common.BGException
ru.bitel.bgbilling.common.BGException
public static void checkTables(java.sql.Connection con, int moduleId, java.util.Date date) throws ru.bitel.bgbilling.common.BGException
ru.bitel.bgbilling.common.BGException
public void insertSessions(java.util.List<VoiceSession> sessions) throws ru.bitel.bgbilling.common.BGException
ru.bitel.bgbilling.common.BGException
public void deleteSessions(int divizer, int remainder, java.util.Date hour, int deviceId) throws java.sql.SQLException, ru.bitel.bgbilling.common.BGException
java.sql.SQLException
ru.bitel.bgbilling.common.BGException
public java.util.List<VoiceSession> list() throws ru.bitel.bgbilling.common.BGException
ru.bitel.bgbilling.common.BGException
public VoiceSession get(long id) throws ru.bitel.bgbilling.common.BGException
ru.bitel.bgbilling.common.BGException