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
-
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
-
Method Summary
Modifier and TypeMethodDescriptiongetByDeviceAccountId
(String deviceAccountId, Date time) getByIdentifier
(String identifier, LocalDate date) static TvAccount
int
lastNumericLogin
(int max) Возвращает последний (наибольший) цифровой логинlist
(int contractId) list
(int contractId, boolean specAndDeviceLoad) listChildren
(int parentId) listRuntime
(int deviceId, Set<Integer> tvAccountSpecIds) Получение списка сервисов для runtime.listToCancel
(Date now) listToCreate
(Date now) optByDeviceAccountId
(String deviceAccountId, Date time) void
recycle()
search
(String login, String deviceAccountId, int tvAccountSpecId, String identifier, String macAddress, 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
close, 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
-
Constructor Details
-
TvAccountDao
-
-
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
- Specified by:
getFromRS
in classru.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 classru.bitel.common.dao.AbstractDao<TvAccount>
- Throws:
ru.bitel.bgbilling.common.BGException
SQLException
-
list
- 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
- 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
- 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
- Throws:
ru.bitel.bgbilling.common.BGException
-
listToCancel
- 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(String login, String deviceAccountId, int tvAccountSpecId, String identifier, String macAddress, boolean loginStrictCheck) throws ru.bitel.bgbilling.common.BGException - Throws:
ru.bitel.bgbilling.common.BGException
-
recycle
public void recycle() throws ru.bitel.bgbilling.common.BGException- Overrides:
recycle
in classru.bitel.common.dao.AbstractDao<TvAccount>
- Throws:
ru.bitel.bgbilling.common.BGException
-