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

Class PhoneResourceSubscriptionDao

java.lang.Object

ru.bitel.bgbilling.kernel.base.server.logger.BGLogger

ru.bitel.bgbilling.common.dao.AbstarctDaoConstant

ru.bitel.bgbilling.common.dao.AbstractDao<PhoneResourceSubscription>

ru.bitel.bgbilling.common.dao.AbstractIdDao<PhoneResourceSubscription>

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

public class PhoneResourceSubscriptionDao
extends ru.bitel.bgbilling.common.dao.AbstractIdDao<PhoneResourceSubscription>

Field Summary

Fields inherited from class ru.bitel.bgbilling.common.dao.AbstractDao

orderByPattern

Fields inherited from class ru.bitel.bgbilling.common.dao.AbstarctDaoConstant

con, ERROR, fields, moduleId, 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, tableName

Constructor Summary

Constructors

Constructor	Description
PhoneResourceSubscriptionDao(Connection con, int moduleId)

Method Summary

Modifier and Type	Method	Description
int	deleteBySubscriberId(int subscriberId)
Map<Integer,Long>	freePhoneResource(List<Integer> phoneResourceIds, Date onDate)
protected PhoneResourceSubscription	getFromRS(ResultSet rs)
List<PhoneResourceSubscription>	list(int phoneResourceId, Date dateFrom, Date dateTo)
List<PhoneResourceSubscription>	list(int phoneResourceId, Date dateFrom, Date dateTo, long phone)
Result<PhoneResourceSubscription>	list(int phoneResourceId, Date dateFrom, Date dateTo, Page page)
Set<Integer>	subscribedPnones(int phoneResourceId, Date dateFrom, Date dateTo)
protected void	updateImpl(PhoneResourceSubscription phoneResourceSubscription)

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, 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, getTableName, psSetDate, psSetInt, psSetString

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

Constructor Details

PhoneResourceSubscriptionDao

public PhoneResourceSubscriptionDao(Connection con,
 int moduleId)

Method Details

getFromRS

protected PhoneResourceSubscription getFromRS(ResultSet rs)
                                       throws SQLException

Specified by:

getFromRS in class ru.bitel.bgbilling.common.dao.AbstractDao<PhoneResourceSubscription>

Throws:

SQLException

updateImpl

protected void updateImpl(PhoneResourceSubscription phoneResourceSubscription)
                   throws SQLException

Specified by:

updateImpl in class ru.bitel.bgbilling.common.dao.AbstractDao<PhoneResourceSubscription>

Throws:

SQLException

subscribedPnones

public Set<Integer> subscribedPnones(int phoneResourceId,
 Date dateFrom,
 Date dateTo)
                              throws SQLException

Throws:

SQLException

list

public List<PhoneResourceSubscription> list(int phoneResourceId,
 Date dateFrom,
 Date dateTo,
 long phone)
                                     throws SQLException

Throws:

SQLException

list

public List<PhoneResourceSubscription> list(int phoneResourceId,
 Date dateFrom,
 Date dateTo)
                                     throws SQLException

Throws:

SQLException

list

public Result<PhoneResourceSubscription> list(int phoneResourceId,
 Date dateFrom,
 Date dateTo,
 Page page)
                                       throws SQLException

Throws:

SQLException

freePhoneResource

public Map<Integer,Long> freePhoneResource(List<Integer> phoneResourceIds,
 Date onDate)
                                    throws SQLException

Throws:

SQLException

deleteBySubscriberId

public int deleteBySubscriberId(int subscriberId)
                         throws SQLException

Throws:

SQLException