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

Class TvAccountDao

java.lang.Object

ru.bitel.bgbilling.kernel.base.server.logger.BGLogger

ru.bitel.bgbilling.common.dao.AbstarctDaoConstant

ru.bitel.bgbilling.common.dao.AbstractDao<TvAccount>

ru.bitel.bgbilling.common.dao.AbstractIdDao<TvAccount>

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

public class TvAccountDao
extends ru.bitel.bgbilling.common.dao.AbstractIdDao<TvAccount>

Field Summary

Fields inherited from class ru.bitel.bgbilling.common.dao.AbstractDao

con, moduleId, orderByPattern, tableName

Fields inherited from class ru.bitel.bgbilling.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 moduleId)

Method Summary

Modifier and Type	Method	Description
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.bgbilling.common.dao.AbstractIdDao

delete, executeUpdate, get, getAndDelete, getAndUpdate, opt, prepareStatement, sqlCommand, sqlCommandAndTable, sqlQuery, sqlWhereId

Methods inherited from class ru.bitel.bgbilling.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, psSetPeriod, queryPeriod, setStatementParam, update

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

getSQLOrder, sqlLimit

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

error, error, error, getLogger, logError, logError, warn

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 moduleId)

Method Details

getFromRS

public static TvAccount getFromRS(ResultSet rs,
 boolean contractLoad,
 boolean specAndDeviceLoad)
                           throws SQLException

Throws:

SQLException

getFromRS

public TvAccount getFromRS(ResultSet rs)
                    throws SQLException

Specified by:

getFromRS in class ru.bitel.bgbilling.common.dao.AbstractDao<TvAccount>

Throws:

SQLException

updateImpl

protected void updateImpl(TvAccount tvAccount)
                   throws SQLException

Specified by:

updateImpl in class ru.bitel.bgbilling.common.dao.AbstractDao<TvAccount>

Throws:

SQLException

list

public List<TvAccount> list(int contractId)
                     throws SQLException

Throws:

SQLException

list

public List<TvAccount> list(int contractId,
 boolean specAndDeviceLoad)
                     throws SQLException

Throws:

SQLException

listRuntime

public List<TvAccount> listRuntime(int deviceId,
 Set<Integer> tvAccountSpecIds)
                            throws SQLException

Получение списка сервисов для runtime. Отсортированы по parentId.

Parameters:

deviceId -

servIds -

Returns:

Throws:

ru.bitel.bgbilling.common.BGException

SQLException

get

public TvAccount get(String login,
 Date time)
              throws SQLException

Throws:

SQLException

getByIdentifier

public TvAccount getByIdentifier(String identifier,
 LocalDate date)
                          throws SQLException

Throws:

SQLException

getByDeviceAccountId

public TvAccount getByDeviceAccountId(String deviceAccountId,
 Date time)
                               throws SQLException

Throws:

SQLException

optByDeviceAccountId

public Optional<TvAccount> optByDeviceAccountId(String deviceAccountId,
 Date time)
                                         throws SQLException

Throws:

SQLException

listChildren

public List<TvAccount> listChildren(int parentId)
                             throws SQLException

Throws:

SQLException

list

public List<TvAccount> list(int deviceId,
 String login,
 Date dateFrom,
 Date dateTo)
                     throws SQLException

Throws:

SQLException

list

public List<TvAccount> list(int deviceId,
 String login,
 Date dateFrom,
 Date dateTo,
 boolean onlyRoot,
 String orderBy)
                     throws SQLException

Throws:

SQLException

updateDeviceStateAndOptions

public void updateDeviceStateAndOptions(int tvAccountId,
 String deviceAccountId,
 short state,
 Set<Integer> deviceOptions,
 int accessCode)
                                 throws SQLException

Throws:

SQLException

listToCreate

public List<TvAccount> listToCreate(Date now)
                             throws SQLException

Throws:

SQLException

listToCancel

public List<TvAccount> listToCancel(Date now)
                             throws SQLException

Throws:

SQLException

lastNumericLogin

public int lastNumericLogin(int max)
                     throws SQLException

Возвращает последний (наибольший) цифровой логин

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 SQLException

Throws:

SQLException