Class PhoneResourceSubscriptionDao
java.lang.Object
ru.bitel.common.dao.AbstarctDaoConstant
ru.bitel.common.dao.AbstractDao<PhoneResourceSubscription>
ru.bitel.oss.systems.inventory.resource.server.bean.PhoneResourceSubscriptionDao
- All Implemented Interfaces:
AutoCloseable
public class PhoneResourceSubscriptionDao
extends ru.bitel.common.dao.AbstractDao<PhoneResourceSubscription>
-
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 TypeMethodDescriptionint
deleteBySubscriberId
(int subscriberId) protected PhoneResourceSubscription
subscribedPnones
(int phoneResourceId, Date dateFrom, Date dateTo) protected void
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, recycle, setStatementParam, update
Methods inherited from class ru.bitel.common.dao.AbstarctDaoConstant
getLogger, getSQLOrder
-
Constructor Details
-
PhoneResourceSubscriptionDao
-
-
Method Details
-
getFromRS
protected PhoneResourceSubscription getFromRS(ResultSet rs) throws SQLException, ru.bitel.bgbilling.common.BGException - Specified by:
getFromRS
in classru.bitel.common.dao.AbstractDao<PhoneResourceSubscription>
- Throws:
SQLException
ru.bitel.bgbilling.common.BGException
-
updateImpl
protected void updateImpl(PhoneResourceSubscription b) throws ru.bitel.bgbilling.common.BGException, SQLException - Specified by:
updateImpl
in classru.bitel.common.dao.AbstractDao<PhoneResourceSubscription>
- Throws:
ru.bitel.bgbilling.common.BGException
SQLException
-
subscribedPnones
public Set<Integer> subscribedPnones(int phoneResourceId, Date dateFrom, Date dateTo) throws ru.bitel.bgbilling.common.BGException - Throws:
ru.bitel.bgbilling.common.BGException
-
list
public List<PhoneResourceSubscription> list(int phoneResourceId, Date dateFrom, Date dateTo, long phone) throws ru.bitel.bgbilling.common.BGException - Throws:
ru.bitel.bgbilling.common.BGException
-
list
public List<PhoneResourceSubscription> list(int phoneResourceId, Date dateFrom, Date dateTo) throws ru.bitel.bgbilling.common.BGException - Throws:
ru.bitel.bgbilling.common.BGException
-
list
public Result<PhoneResourceSubscription> list(int phoneResourceId, Date dateFrom, Date dateTo, Page page) throws ru.bitel.bgbilling.common.BGException - Throws:
ru.bitel.bgbilling.common.BGException
-
deleteBySubscriberId
public int deleteBySubscriberId(int subscriberId) throws ru.bitel.bgbilling.common.BGException - Throws:
ru.bitel.bgbilling.common.BGException
-