Class SubscriptionDao
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:
AutoCloseable
-
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 TypeMethodDescriptionvoid
addDetail
(CostSumTime costSumTime, int registrationPeriodId) Добавление записи в таблицу детализации наработкиgetAmountDetail
(int contractId, PeriodWithTime period) protected Subscription
Boolean[][]
getSubscriptionStatusValues
(List<Integer> subscriptionIds, List<Integer> statusIds, boolean replaceDefaultToValue) 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.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
-
Field Details
-
userId
protected final int userId
-
-
Constructor Details
-
SubscriptionDao
- Parameters:
con
-moduleId
-userId
-
-
-
Method Details
-
getFromRS
protected Subscription getFromRS(ResultSet rs) throws SQLException, ru.bitel.bgbilling.common.BGException - Specified by:
getFromRS
in classru.bitel.common.dao.AbstractDao<Subscription>
- Throws:
SQLException
ru.bitel.bgbilling.common.BGException
-
updateImpl
protected void updateImpl(Subscription subscription) throws ru.bitel.bgbilling.common.BGException, SQLException - Specified by:
updateImpl
in classru.bitel.common.dao.AbstractDao<Subscription>
- Throws:
ru.bitel.bgbilling.common.BGException
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
- 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 List<CostSumTime> getAmountDetail(int contractId, PeriodWithTime period) throws ru.bitel.bgbilling.common.BGException - Parameters:
contractId
-period
-- Returns:
- Throws:
ru.bitel.bgbilling.common.BGException
-
getSubscriptionStatusValues
public Boolean[][] getSubscriptionStatusValues(List<Integer> subscriptionIds, List<Integer> statusIds, boolean replaceDefaultToValue) throws ru.bitel.bgbilling.common.BGException - Throws:
ru.bitel.bgbilling.common.BGException
-
updateSubscriptionStatusValues
public void updateSubscriptionStatusValues(List<Integer> subscriptionIds, List<Integer> statusIds, Boolean[][] values) throws ru.bitel.bgbilling.common.BGException - Throws:
ru.bitel.bgbilling.common.BGException
-