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

public class VoiceSessionLogDao extends ru.bitel.common.dao.AbstractDao<VoiceSession>
  • Field Details

  • Constructor Details

    • VoiceSessionLogDao

      public VoiceSessionLogDao(Connection con, int mid, Date date)
    • VoiceSessionLogDao

      protected VoiceSessionLogDao(Connection con, int mid, String tableName)
  • Method Details

    • getFromRS

      protected VoiceSession getFromRS(ResultSet rs) throws SQLException, ru.bitel.bgbilling.common.BGException
      Specified by:
      getFromRS in class ru.bitel.common.dao.AbstractDao<VoiceSession>
      Throws:
      SQLException
      ru.bitel.bgbilling.common.BGException
    • getSessionFromRs

      public static VoiceSession getSessionFromRs(ResultSet rs) throws SQLException
      Throws:
      SQLException
    • updateImpl

      protected void updateImpl(VoiceSession session) throws ru.bitel.bgbilling.common.BGException, SQLException
      Specified by:
      updateImpl in class ru.bitel.common.dao.AbstractDao<VoiceSession>
      Throws:
      ru.bitel.bgbilling.common.BGException
      SQLException
    • getFieldPart

      protected String getFieldPart()
    • setPsParams

      protected int setPsParams(VoiceSession session, PreparedStatement ps, int idx) throws SQLException
      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

      public List<VoiceSession> list() throws ru.bitel.bgbilling.common.BGException
      Throws:
      ru.bitel.bgbilling.common.BGException
    • get

      public VoiceSession get(long id) throws ru.bitel.bgbilling.common.BGException
      Throws:
      ru.bitel.bgbilling.common.BGException