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

Class RunTelContractTariffDao

java.lang.Object

ru.bitel.common.dao.AbstarctDaoConstant

ru.bitel.common.dao.AbstractDao<B>

ru.bitel.common.dao.AbstractIdDao<RunTelContractTariff>

ru.bitel.bgbilling.modules.runtel.server.bean.RunTelContractTariffDao

All Implemented Interfaces:

AutoCloseable

public class RunTelContractTariffDao
extends ru.bitel.common.dao.AbstractIdDao<RunTelContractTariff>

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

Constructors

Constructor	Description
RunTelContractTariffDao(Connection con, int moduleId)

Method Summary

Modifier and Type	Method	Description
protected int	deleteImpl(int id)
RunTelContractTariff	get(int contractId, LocalDate date)
protected RunTelContractTariff	getFromRS(ResultSet rs)
Map<Integer,RunTelContractTariff>	getLastRunTelContractTariffs()	последние тарифы договоров (на текущую дату)
LocalDateTime	getOnDate(int contractId)
List<RunTelContractTariff>	getRunTelContractTariffs(int contractId, PeriodWithTime period)
List<RunTelContractTariff>	getRunTelContractTariffs(LocalDateTime date)
List<RunTelContractTariff>	getRunTelContractTariffs(Period period)
void	updateDateTo(int contractTariffId, LocalDateTime dateTo)
protected void	updateImpl(RunTelContractTariff runTelContractTariff)

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, 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

Methods inherited from class java.lang.Object

clone, equals, finalize, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait

Constructor Details

RunTelContractTariffDao

public RunTelContractTariffDao(Connection con,
 int moduleId)

Method Details

getRunTelContractTariffs

public List<RunTelContractTariff> getRunTelContractTariffs(LocalDateTime date)
                                                    throws ru.bitel.bgbilling.common.BGException

Throws:

ru.bitel.bgbilling.common.BGException

getRunTelContractTariffs

public List<RunTelContractTariff> getRunTelContractTariffs(Period period)
                                                    throws ru.bitel.bgbilling.common.BGException

Throws:

ru.bitel.bgbilling.common.BGException

getRunTelContractTariffs

public List<RunTelContractTariff> getRunTelContractTariffs(int contractId,
 PeriodWithTime period)
                                                    throws ru.bitel.bgbilling.common.BGException

Throws:

ru.bitel.bgbilling.common.BGException

getOnDate

public LocalDateTime getOnDate(int contractId)
                        throws ru.bitel.bgbilling.common.BGException

Throws:

ru.bitel.bgbilling.common.BGException

get

public RunTelContractTariff get(int contractId,
 LocalDate date)
                         throws ru.bitel.bgbilling.common.BGException

Throws:

ru.bitel.bgbilling.common.BGException

deleteImpl

protected int deleteImpl(int id)
                  throws ru.bitel.bgbilling.common.BGException,
SQLException

Overrides:

deleteImpl in class ru.bitel.common.dao.AbstractDao<RunTelContractTariff>

Throws:

ru.bitel.bgbilling.common.BGException

SQLException

getFromRS

protected RunTelContractTariff getFromRS(ResultSet rs)
                                  throws SQLException,
ru.bitel.bgbilling.common.BGException

Specified by:

getFromRS in class ru.bitel.common.dao.AbstractDao<RunTelContractTariff>

Throws:

SQLException

ru.bitel.bgbilling.common.BGException

updateImpl

protected void updateImpl(RunTelContractTariff runTelContractTariff)
                   throws ru.bitel.bgbilling.common.BGException,
SQLException

Specified by:

updateImpl in class ru.bitel.common.dao.AbstractDao<RunTelContractTariff>

Throws:

ru.bitel.bgbilling.common.BGException

SQLException

updateDateTo

public void updateDateTo(int contractTariffId,
 LocalDateTime dateTo)
                  throws ru.bitel.bgbilling.common.BGException,
SQLException

Throws:

ru.bitel.bgbilling.common.BGException

SQLException

getLastRunTelContractTariffs

public Map<Integer,RunTelContractTariff> getLastRunTelContractTariffs()
                                                               throws ru.bitel.bgbilling.common.BGException

последние тарифы договоров (на текущую дату)

Returns:

Throws:

ru.bitel.bgbilling.common.BGException

SQLException