Package ru.bitel.oss.systems.inventory.resource.server.bean

Class IpResourceSubscriptionDao

java.lang.Object
ru.bitel.bgbilling.kernel.base.server.logger.BGLogger
ru.bitel.bgbilling.common.dao.AbstarctDaoConstant
ru.bitel.bgbilling.common.dao.AbstractDao<IpResourceSubscription>
ru.bitel.bgbilling.common.dao.AbstractIdDao<IpResourceSubscription>
ru.bitel.oss.systems.inventory.resource.server.bean.IpResourceSubscriptionDao
public class IpResourceSubscriptionDao extends ru.bitel.bgbilling.common.dao.AbstractIdDao<IpResourceSubscription>

  • 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
    Modifier
    Constructor
    Description
     
    IpResourceSubscriptionDao(Connection con, int moduleId)
     
    protected
    IpResourceSubscriptionDao(Connection con, int moduleId, String tableName)
     

  • Method Summary

    Modifier and Type
    Method
    Description
    int
    deleteBySubsciberId(int subscriberId)
     
    Object[]
    findFree(Collection<Integer> ipResourceCategoryIds, int ipResourceId, byte[] addressFrom, byte[] addressTo, Date dateFrom, Date dateTo, int subscriberId)
     
    IpResourceSubscription
    findSubscribed(int subscriberId)
     
    Object[]
    findSubscribed(Set<Integer> ipResourceCategoryIds, int ipResourceId, byte[] addressFrom, byte[] addressTo, Date dateFrom, Date dateTo, int subscriberId)
     
    protected IpResourceSubscription
    getFromRS(ResultSet rs)
     
    protected IpResourceSubscription
    getSubscriptionFromRS(String prefix, ResultSet rs)
     
    protected static IpResourceSubscription
    getSubscriptionFromRS(ResultSet rs)
     
    List<IpResourceSubscription>
    list(int ipResourceId, Date dateFrom, Date dateTo)
    Возвращает список подписок, которые пересекаются с указанным периодом.
    Result<IpResourceSubscription>
    list(int ipResourceId, Date dateFrom, Date dateTo, Page page)
     
    List<IpResourceSubscriptionRuntime>
    listRuntime(int ipResourceId, Date dateFrom, Date dateTo)
    Возвращает список подписок, которые пересекаются с указанным периодом.
    protected void
    updateImpl(IpResourceSubscription ipResourceSubscription)
     

    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