java.lang.Object
ru.bitel.common.dao.AbstarctDaoConstant
ru.bitel.common.dao.AbstractDao<B>
ru.bitel.common.dao.AbstractIdDao<Subscription>
ru.bitel.bgbilling.modules.subscription.server.bean.SubscriptionDao
All Implemented Interfaces:
java.lang.AutoCloseable

public class SubscriptionDao
extends ru.bitel.common.dao.AbstractIdDao<Subscription>
  • Nested Class Summary

    Nested classes/interfaces inherited from class ru.bitel.common.dao.AbstractDao

    ru.bitel.common.dao.AbstractDao.ResultSetIterator
  • Field Summary

    Fields
    Modifier and Type Field Description
    protected int userId  

    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, SQL_CALC_FOUND_ROWS, SQL_DELETE, SQL_DISTINCT, SQL_EQ, SQL_EQCS, SQL_FROM, SQL_GROUP, SQL_IN, SQL_INSERT, SQL_LIMIT, SQL_ON_DUPLICATE_KEY_UPDATE, SQL_ORDER, SQL_SELECT, SQL_SET, SQL_UPDATE, SQL_VALUES, SQL_WHERE
  • Constructor Summary

    Constructors
    Constructor Description
    SubscriptionDao​(java.sql.Connection con, int moduleId, int userId)  
  • Method Summary

    Modifier and Type Method Description
    void addDetail​(CostSumTime costSumTime, int registrationPeriodId)
    Добавление записи в таблицу детализации наработки
    java.util.List<CostSumTime> getAmountDetail​(int contractId, PeriodWithTime period)  
    protected Subscription getFromRS​(java.sql.ResultSet rs)  
    java.util.List<Subscription> list​(int contractId)  
    protected void updateImpl​(Subscription subscription)  
    void updateRegistrationPeriodId​(int subscriptionId, int registrationPeriodId)  
    void updateSubscriptionJobId​(int subscriptionId, long subscriptionJobId)  

    Methods inherited from class ru.bitel.common.dao.AbstractIdDao

    delete, get, getAndDelete, getAndUpdate

    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, processException, recycle, setStatementParam, update

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

    getSQLOrder

    Methods inherited from class java.lang.Object

    clone, equals, finalize, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait
  • Field Details

    • userId

      protected final int userId
  • Constructor Details

    • SubscriptionDao

      public SubscriptionDao​(java.sql.Connection con, int moduleId, int userId)
      Parameters:
      con -
      moduleId -
      userId -
  • Method Details

    • getFromRS

      protected Subscription getFromRS​(java.sql.ResultSet rs) throws java.sql.SQLException, ru.bitel.bgbilling.common.BGException
      Specified by:
      getFromRS in class ru.bitel.common.dao.AbstractDao<Subscription>
      Throws:
      java.sql.SQLException
      ru.bitel.bgbilling.common.BGException
    • updateImpl

      protected void updateImpl​(Subscription subscription) throws ru.bitel.bgbilling.common.BGException, java.sql.SQLException
      Specified by:
      updateImpl in class ru.bitel.common.dao.AbstractDao<Subscription>
      Throws:
      ru.bitel.bgbilling.common.BGException
      java.sql.SQLException
    • updateRegistrationPeriodId

      public void updateRegistrationPeriodId​(int subscriptionId, int registrationPeriodId) throws ru.bitel.bgbilling.common.BGException
      Parameters:
      subscriptionId -
      registrationPeriodId -
      Throws:
      ru.bitel.bgbilling.common.BGException
    • updateSubscriptionJobId

      public void updateSubscriptionJobId​(int subscriptionId, long subscriptionJobId) throws ru.bitel.bgbilling.common.BGException
      Parameters:
      subscriptionId -
      subscriptionJobId -
      Throws:
      ru.bitel.bgbilling.common.BGException
    • list

      public java.util.List<Subscription> list​(int contractId) throws ru.bitel.bgbilling.common.BGException
      Parameters:
      contractId -
      Returns:
      Throws:
      ru.bitel.bgbilling.common.BGException
    • addDetail

      public void addDetail​(CostSumTime costSumTime, int registrationPeriodId) throws ru.bitel.bgbilling.common.BGException
      Добавление записи в таблицу детализации наработки
      Parameters:
      contractId - код договора
      serviceId - код услуги
      summ - сумма наработки
      Throws:
      ru.bitel.bgbilling.common.BGException
    • getAmountDetail

      public java.util.List<CostSumTime> getAmountDetail​(int contractId, PeriodWithTime period) throws ru.bitel.bgbilling.common.BGException
      Parameters:
      contractId -
      period -
      Returns:
      Throws:
      ru.bitel.bgbilling.common.BGException