Class AbstractInetSessionDao<B>
java.lang.Object
ru.bitel.common.dao.AbstarctDaoConstant
ru.bitel.common.dao.AbstractDao<B>
ru.bitel.bgbilling.modules.inet.server.bean.AbstractInetSessionDao<B>
- All Implemented Interfaces:
AutoCloseable
public abstract class AbstractInetSessionDao<B>
extends ru.bitel.common.dao.AbstractDao<B>
-
Nested Class Summary
Nested classes/interfaces inherited from class ru.bitel.common.dao.AbstractDao
ru.bitel.common.dao.AbstractDao.ResultSetIterator
-
Field Summary
Modifier and TypeFieldDescriptionprotected final String
protected final String
static final String
static final String
static final String
static final String
static final String
static final String
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
ConstructorDescriptionAbstractInetSessionDao
(Connection con, int mid) AbstractInetSessionDao
(Connection con, int mid, Date date) -
Method Summary
Modifier and TypeMethodDescriptionprotected String
addWherePart
(Collection<Integer> servIds, Period period, String sql) protected String
protected PreparedStatement
getSessionTrafficsReport
(int cid, Collection<Integer> servIds, Period period, Collection<Integer> trafficTypeIds) getSumReportInfo
(int cid, Collection<Integer> servIds, Period period) void
loadAccount
(List<InetSessionLog> sessions, Collection<Integer> serviceIds) void
loadTraffics
(List<InetSessionLog> sessions, Collection<Integer> trafficTypeIds) protected void
setParams
(int cid, Period period, PreparedStatement ps) Methods inherited from class ru.bitel.common.dao.AbstractDao
close, delete, deleteImpl, eq, get, getById, getFromRS, getImpl, getListFromRS, getPeriod, getQueryById, getSQLOrder, getTableName, list, list, listImpl, listImpl, listImplPS, listImplPS, ormFromResultSet, ormUpdateImpl, ormUpdateImpl, ormUpdateImpl, ormUpdateImpl, processException, recycle, setStatementParam, update, updateImpl
Methods inherited from class ru.bitel.common.dao.AbstarctDaoConstant
getLogger, getSQLOrder
-
Field Details
-
TABLE_INET_SESSION_LOG
- See Also:
-
TABLE_INET_SESSION_LOG_DETAIL
- See Also:
-
TABLE_INET_SESSION_LOG_ROUTE
- See Also:
-
TABLE_INET_SESSION_LOG_ACCOUNT
- See Also:
-
TABLE_INET_SESSION_DETAIL
- See Also:
-
TABLE_INET_SESSION_ACCOUNT
- See Also:
-
detailTableName
-
accountTableName
-
-
Constructor Details
-
AbstractInetSessionDao
-
AbstractInetSessionDao
-
-
Method Details
-
getSessionTrafficsReport
public Map<Integer,Long> getSessionTrafficsReport(int cid, Collection<Integer> servIds, Period period, Collection<Integer> trafficTypeIds) throws ru.bitel.bgbilling.common.BGException - Throws:
ru.bitel.bgbilling.common.BGException
-
addWherePart
-
setParams
- Throws:
SQLException
-
loadAccount
public void loadAccount(List<InetSessionLog> sessions, Collection<Integer> serviceIds) throws ru.bitel.bgbilling.common.BGException - Throws:
ru.bitel.bgbilling.common.BGException
-
loadTraffics
public void loadTraffics(List<InetSessionLog> sessions, Collection<Integer> trafficTypeIds) throws ru.bitel.bgbilling.common.BGException - Throws:
ru.bitel.bgbilling.common.BGException
-
getSumReportInfo
public List<Double> getSumReportInfo(int cid, Collection<Integer> servIds, Period period) throws ru.bitel.bgbilling.common.BGException - Throws:
ru.bitel.bgbilling.common.BGException
-
getFromAndWherePart
-
getPs
protected PreparedStatement getPs(int cid, Collection<Integer> servIds, Period period, Page page, String sql) throws SQLException - Throws:
SQLException
-