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

Class SubscriptionDao

java.lang.Object
ru.bitel.bgbilling.kernel.base.server.logger.BGLogger
ru.bitel.bgbilling.common.dao.AbstarctDaoConstant
ru.bitel.bgbilling.common.dao.AbstractDao<B>
ru.bitel.bgbilling.common.dao.AbstractIdDao<Subscription>
ru.bitel.bgbilling.modules.subscription.server.bean.SubscriptionDao
public class SubscriptionDao extends ru.bitel.bgbilling.common.dao.AbstractIdDao<Subscription>

  • Field Summary

    Fields
    Modifier and Type
    Field
    Description
    protected final int
    userId
     

    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
    SubscriptionDao(Connection con, int moduleId, int userId)
     

  • Method Summary

    Modifier and Type
    Method
    Description
    void
    addDetail(CostSumTime costSumTime, int registrationPeriodId)
    Добавление записи в таблицу детализации наработки
    List<CostSumTime>
    getAmountDetail(int contractId, PeriodWithTime period)
     
    protected Subscription
    getFromRS(ResultSet rs)
     
    Boolean[][]
    getSubscriptionStatusValues(List<Integer> subscriptionIds, List<Integer> statusIds, boolean replaceDefaultToValue)
     
    List<Subscription>
    list(int contractId)
     
    protected void
    updateImpl(Subscription subscription)
     
    void
    updateRegistrationPeriodId(int subscriptionId, int registrationPeriodId)
     
    void
    updateSubscriptionJobId(int subscriptionId, long subscriptionJobId)
     
    void
    updateSubscriptionStatusValues(List<Integer> subscriptionIds, List<Integer> statusIds, Boolean[][] values)
     

    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

    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(Connection con, int moduleId, int userId)
      Parameters:
      con -
      moduleId -
      userId -

  • Method Details

    • getFromRS

      protected Subscription getFromRS(ResultSet rs) throws SQLException
      Specified by:
      getFromRS in class ru.bitel.bgbilling.common.dao.AbstractDao<Subscription>
      Throws:
      SQLException

    • updateImpl

      protected void updateImpl(Subscription subscription) throws SQLException
      Specified by:
      updateImpl in class ru.bitel.bgbilling.common.dao.AbstractDao<Subscription>
      Throws:
      SQLException

    • updateRegistrationPeriodId

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

    • updateSubscriptionJobId

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

    • list

      public List<Subscription> list(int contractId) throws SQLException
      Parameters:
      contractId -
      Returns:
      Throws:
      ru.bitel.bgbilling.common.BGException
      SQLException

    • addDetail

      public void addDetail(CostSumTime costSumTime, int registrationPeriodId) throws SQLException
      Добавление записи в таблицу детализации наработки
      Parameters:
      contractId - код договора
      serviceId - код услуги
      summ - сумма наработки
      Throws:
      SQLException

    • getAmountDetail

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

    • getSubscriptionStatusValues

      public Boolean[][] getSubscriptionStatusValues(List<Integer> subscriptionIds, List<Integer> statusIds, boolean replaceDefaultToValue) throws SQLException
      Throws:
      SQLException

    • updateSubscriptionStatusValues

      public void updateSubscriptionStatusValues(List<Integer> subscriptionIds, List<Integer> statusIds, Boolean[][] values) throws SQLException
      Throws:
      SQLException