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

Class TvAccountDao

java.lang.Object

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

getLogger, getSQLOrder

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