Package ru.bitel.bgbilling.modules.tv.server.bean

Class TvAccountDao

java.lang.Object
ru.bitel.bgbilling.kernel.base.server.logger.BGLogger
ru.bitel.common.dao.AbstarctDaoConstant
ru.bitel.common.dao.AbstractDao<B>
ru.bitel.common.dao.AbstractIdDao<TvAccount>
ru.bitel.bgbilling.modules.tv.server.bean.TvAccountDao
All Implemented Interfaces:
AutoCloseable
public class TvAccountDao extends ru.bitel.common.dao.AbstractIdDao<TvAccount>

  • 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

    Constructors
    Constructor
    Description
    TvAccountDao(Connection con, int mid)
     

  • Method Summary

    Modifier and Type
    Method
    Description
    void
    close()
     
    TvAccount
    get(String login, Date time)
     
    TvAccount
    getByDeviceAccountId(String deviceAccountId, Date time)
     
    TvAccount
    getByIdentifier(String identifier, LocalDate date)
     
    TvAccount
    getFromRS(ResultSet rs)
     
    static TvAccount
    getFromRS(ResultSet rs, boolean contractLoad, boolean specAndDeviceLoad)
     
    int
    lastNumericLogin(int max)
    Возвращает последний (наибольший) цифровой логин
    List<TvAccount>
    list(int contractId)
     
    List<TvAccount>
    list(int contractId, boolean specAndDeviceLoad)
     
    List<TvAccount>
    list(int deviceId, String login, Date dateFrom, Date dateTo)
     
    List<TvAccount>
    list(int deviceId, String login, Date dateFrom, Date dateTo, boolean onlyRoot, String orderBy)
     
    List<TvAccount>
    listChildren(int parentId)
     
    List<TvAccount>
    listRuntime(int deviceId, Set<Integer> tvAccountSpecIds)
    Получение списка сервисов для runtime.
    List<TvAccount>
    listToCancel(Date now)
     
    List<TvAccount>
    listToCreate(Date now)
     
    Optional<TvAccount>
    optByDeviceAccountId(String deviceAccountId, Date time)
     
    List<TvAccount>
    search(List<ru.bitel.bgbilling.common.model.KeyValue> filter, int tvAccountSpecId, boolean loginStrictCheck)
     
    void
    updateDeviceStateAndOptions(int tvAccountId, String deviceAccountId, short state, Set<Integer> deviceOptions, int accessCode)
     
    protected void
    updateImpl(TvAccount tvAccount)
     

    Methods inherited from class ru.bitel.common.dao.AbstractIdDao

    delete, get, getAndDelete, getAndUpdate, opt

    Methods inherited from class ru.bitel.common.dao.AbstractDao

    delete, deleteImpl, eq, get, getById, getImpl, getListFromRS, getPeriod, getQueryById, getSQLOrder, getTableName, list, list, listImpl, listImpl, listImplPS, listImplPS, ormFromResultSet, ormUpdateImpl, ormUpdateImpl, ormUpdateImpl, ormUpdateImpl, processException, setStatementParam, update

    Methods inherited from class ru.bitel.common.dao.AbstarctDaoConstant

    getSQLOrder

    Methods inherited from class ru.bitel.bgbilling.kernel.base.server.logger.BGLogger

    getLogger, logError

    Methods inherited from class java.lang.Object

    clone, equals, finalize, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait

  • Constructor Details

    • TvAccountDao

      public TvAccountDao(Connection con, int mid)

  • Method Details

    • getFromRS

      public static TvAccount getFromRS(ResultSet rs, boolean contractLoad, boolean specAndDeviceLoad) throws SQLException, ru.bitel.bgbilling.common.BGException
      Throws:
      SQLException
      ru.bitel.bgbilling.common.BGException

    • getFromRS

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

    • updateImpl

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

    • list

      public List<TvAccount> list(int contractId) throws ru.bitel.bgbilling.common.BGException
      Throws:
      ru.bitel.bgbilling.common.BGException

    • list

      public List<TvAccount> list(int contractId, boolean specAndDeviceLoad) throws ru.bitel.bgbilling.common.BGException
      Throws:
      ru.bitel.bgbilling.common.BGException

    • listRuntime

      public List<TvAccount> listRuntime(int deviceId, Set<Integer> tvAccountSpecIds) throws ru.bitel.bgbilling.common.BGException
      Получение списка сервисов для runtime. Отсортированы по parentId.
      Parameters:
      deviceId -
      servIds -
      Returns:
      Throws:
      ru.bitel.bgbilling.common.BGException

    • get

      public TvAccount get(String login, Date time) throws ru.bitel.bgbilling.common.BGException
      Throws:
      ru.bitel.bgbilling.common.BGException

    • getByIdentifier

      public TvAccount getByIdentifier(String identifier, LocalDate date) throws ru.bitel.bgbilling.common.BGException
      Throws:
      ru.bitel.bgbilling.common.BGException

    • getByDeviceAccountId

      public TvAccount getByDeviceAccountId(String deviceAccountId, Date time) throws ru.bitel.bgbilling.common.BGException
      Throws:
      ru.bitel.bgbilling.common.BGException

    • optByDeviceAccountId

      public Optional<TvAccount> optByDeviceAccountId(String deviceAccountId, Date time) throws ru.bitel.bgbilling.common.BGException
      Throws:
      ru.bitel.bgbilling.common.BGException

    • listChildren

      public List<TvAccount> listChildren(int parentId) throws ru.bitel.bgbilling.common.BGException
      Throws:
      ru.bitel.bgbilling.common.BGException

    • list

      public List<TvAccount> list(int deviceId, String login, Date dateFrom, Date dateTo) throws ru.bitel.bgbilling.common.BGException
      Throws:
      ru.bitel.bgbilling.common.BGException

    • list

      public List<TvAccount> list(int deviceId, String login, Date dateFrom, Date dateTo, boolean onlyRoot, String orderBy) throws ru.bitel.bgbilling.common.BGException
      Throws:
      ru.bitel.bgbilling.common.BGException

    • updateDeviceStateAndOptions

      public void updateDeviceStateAndOptions(int tvAccountId, String deviceAccountId, short state, Set<Integer> deviceOptions, int accessCode) throws ru.bitel.bgbilling.common.BGException
      Throws:
      ru.bitel.bgbilling.common.BGException

    • listToCreate

      public List<TvAccount> listToCreate(Date now) throws ru.bitel.bgbilling.common.BGException
      Throws:
      ru.bitel.bgbilling.common.BGException

    • listToCancel

      public List<TvAccount> listToCancel(Date now) throws ru.bitel.bgbilling.common.BGException
      Throws:
      ru.bitel.bgbilling.common.BGException

    • lastNumericLogin

      public int lastNumericLogin(int max) throws ru.bitel.bgbilling.common.BGException
      Возвращает последний (наибольший) цифровой логин
      Returns:
      Throws:
      ru.bitel.bgbilling.common.BGException
      SQLException

    • search

      public List<TvAccount> search(List<ru.bitel.bgbilling.common.model.KeyValue> filter, int tvAccountSpecId, boolean loginStrictCheck) throws ru.bitel.bgbilling.common.BGException
      Throws:
      ru.bitel.bgbilling.common.BGException

    • close

      public void close() throws ru.bitel.bgbilling.common.BGException
      Specified by:
      close in interface AutoCloseable
      Overrides:
      close in class ru.bitel.common.dao.AbstractDao<TvAccount>
      Throws:
      ru.bitel.bgbilling.common.BGException