Class IpResourceSubscriptionDao
java.lang.Object
ru.bitel.common.dao.AbstarctDaoConstant
ru.bitel.common.dao.AbstractDao<B>
ru.bitel.common.dao.AbstractIdDao<IpResourceSubscription>
ru.bitel.oss.systems.inventory.resource.server.bean.IpResourceSubscriptionDao
- All Implemented Interfaces:
AutoCloseable
public class IpResourceSubscriptionDao
extends ru.bitel.common.dao.AbstractIdDao<IpResourceSubscription>
-
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
ModifierConstructorDescriptionIpResourceSubscriptionDao
(Connection con, int moduleId) protected
IpResourceSubscriptionDao
(Connection con, int moduleId, String tableName) -
Method Summary
Modifier and TypeMethodDescriptionint
deleteBySubsciberId
(int subscriberId) Object[]
findFree
(Collection<Integer> ipResourceCategoryIds, int ipResourceId, byte[] addressFrom, byte[] addressTo, Date dateFrom, Date dateTo, int subscriberId) findSubscribed
(int subscriberId) Object[]
findSubscribed
(Set<Integer> ipResourceCategoryIds, int ipResourceId, byte[] addressFrom, byte[] addressTo, Date dateFrom, Date dateTo, int subscriberId) protected IpResourceSubscription
protected IpResourceSubscription
getSubscriptionFromRS
(String prefix, ResultSet rs) protected static IpResourceSubscription
Возвращает список подписок, которые пересекаются с указанным периодом.listRuntime
(int ipResourceId, Date dateFrom, Date dateTo) Возвращает список подписок, которые пересекаются с указанным периодом.protected void
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, recycle, setStatementParam, update
Methods inherited from class ru.bitel.common.dao.AbstarctDaoConstant
getLogger, getSQLOrder
-
Constructor Details
-
IpResourceSubscriptionDao
-
IpResourceSubscriptionDao
-
-
Method Details
-
getFromRS
- Specified by:
getFromRS
in classru.bitel.common.dao.AbstractDao<IpResourceSubscription>
- Throws:
SQLException
-
getSubscriptionFromRS
protected IpResourceSubscription getSubscriptionFromRS(String prefix, ResultSet rs) throws SQLException - Throws:
SQLException
-
list
public List<IpResourceSubscription> list(int ipResourceId, Date dateFrom, Date dateTo) throws ru.bitel.bgbilling.common.BGException Возвращает список подписок, которые пересекаются с указанным периодом.- Parameters:
ipResourceId
-dateFrom
-dateTo
-- Returns:
- Throws:
ru.bitel.bgbilling.common.BGException
-
listRuntime
public List<IpResourceSubscriptionRuntime> listRuntime(int ipResourceId, Date dateFrom, Date dateTo) throws ru.bitel.bgbilling.common.BGException Возвращает список подписок, которые пересекаются с указанным периодом.- Parameters:
ipResourceId
-dateFrom
-dateTo
-- Returns:
- Throws:
ru.bitel.bgbilling.common.BGException
-
list
public Result<IpResourceSubscription> list(int ipResourceId, Date dateFrom, Date dateTo, Page page) throws ru.bitel.bgbilling.common.BGException - Throws:
ru.bitel.bgbilling.common.BGException
-
updateImpl
protected void updateImpl(IpResourceSubscription b) throws ru.bitel.bgbilling.common.BGException, SQLException - Specified by:
updateImpl
in classru.bitel.common.dao.AbstractDao<IpResourceSubscription>
- Throws:
ru.bitel.bgbilling.common.BGException
SQLException
-
deleteBySubsciberId
public int deleteBySubsciberId(int subscriberId) throws ru.bitel.bgbilling.common.BGException - Throws:
ru.bitel.bgbilling.common.BGException
-
findSubscribed
public IpResourceSubscription findSubscribed(int subscriberId) throws ru.bitel.bgbilling.common.BGException - Throws:
ru.bitel.bgbilling.common.BGException
-
findFree
public Object[] findFree(Collection<Integer> ipResourceCategoryIds, int ipResourceId, byte[] addressFrom, byte[] addressTo, Date dateFrom, Date dateTo, int subscriberId) throws ru.bitel.bgbilling.common.BGException - Parameters:
ipResourceCategoryIds
-ipResourceId
-addressFrom
-addressTo
-dateFrom
-dateTo
-subscriberId
-- Returns:
- Throws:
ru.bitel.bgbilling.common.BGException
- если данный ip пересекается с другим подписчиком и подходящих ресурсов нет
-
findSubscribed
public Object[] findSubscribed(Set<Integer> ipResourceCategoryIds, int ipResourceId, byte[] addressFrom, byte[] addressTo, Date dateFrom, Date dateTo, int subscriberId) throws ru.bitel.bgbilling.common.BGException - Throws:
ru.bitel.bgbilling.common.BGException
-
getSubscriptionFromRS
- Throws:
SQLException
-