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

# 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:
  `java.lang.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

  Fields
  Modifier and Type | Field | Description
  --- | --- | ---
  `protected java.lang.String` | `accountTableName` |
  `protected java.lang.String` | `detailTableName` |
  `static java.lang.String` | `TABLE_INET_SESSION_ACCOUNT` |
  `static java.lang.String` | `TABLE_INET_SESSION_DETAIL` |
  `static java.lang.String` | `TABLE_INET_SESSION_LOG` |
  `static java.lang.String` | `TABLE_INET_SESSION_LOG_ACCOUNT` |
  `static java.lang.String` | `TABLE_INET_SESSION_LOG_DETAIL` |
  `static java.lang.String` | `TABLE_INET_SESSION_LOG_ROUTE` |

  ### 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_CALC_FOUND_ROWS, SQL_DELETE, SQL_DISTINCT, SQL_EQ, SQL_EQCS, SQL_FROM, SQL_GROUP, SQL_IN, SQL_INSERT, SQL_LIMIT, SQL_ON_DUPLICATE_KEY_UPDATE, SQL_ORDER, SQL_SELECT, SQL_SET, SQL_UPDATE, SQL_VALUES, SQL_WHERE`

- ## Constructor Summary

  Constructors
  Constructor | Description
  --- | ---
  `AbstractInetSessionDao​(java.sql.Connection con, int mid)` |
  `AbstractInetSessionDao​(java.sql.Connection con, int mid, java.util.Date date)` |

- ## Method Summary

  Modifier and Type | Method | Description
  --- | --- | ---
  `protected java.lang.String` | `addWherePart​(java.util.Collection<java.lang.Integer> servIds, Period period, java.lang.String sql)` |
  `protected java.lang.String` | `getFromAndWherePart()` |
  `protected java.sql.PreparedStatement` | `getPs​(int cid, java.util.Collection<java.lang.Integer> servIds, Period period, Page page, java.lang.String sql)` |
  `java.util.Map<java.lang.Integer,​java.lang.Long>` | `getSessionTrafficsReport​(int cid, java.util.Collection<java.lang.Integer> servIds, Period period, java.util.Collection<java.lang.Integer> trafficTypeIds)` |
  `java.util.List<java.lang.Double>` | `getSumReportInfo​(int cid, java.util.Collection<java.lang.Integer> servIds, Period period)` |
  `void` | `loadAccount​(java.util.List<InetSessionLog> sessions, java.util.Collection<java.lang.Integer> serviceIds)` |
  `void` | `loadTraffics​(java.util.List<InetSessionLog> sessions, java.util.Collection<java.lang.Integer> trafficTypeIds)` |
  `protected void` | `setParams​(int cid, Period period, Page page, java.sql.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

  `getSQLOrder`

  ### Methods inherited from class java.lang.Object

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

- ## Field Details

  - ### TABLE_INET_SESSION_LOG

    public static final java.lang.String TABLE_INET_SESSION_LOG
    See Also:
      Constant Field Values

  - ### TABLE_INET_SESSION_LOG_DETAIL

    public static final java.lang.String TABLE_INET_SESSION_LOG_DETAIL
    See Also:
      Constant Field Values

  - ### TABLE_INET_SESSION_LOG_ROUTE

    public static final java.lang.String TABLE_INET_SESSION_LOG_ROUTE
    See Also:
      Constant Field Values

  - ### TABLE_INET_SESSION_LOG_ACCOUNT

    public static final java.lang.String TABLE_INET_SESSION_LOG_ACCOUNT
    See Also:
      Constant Field Values

  - ### TABLE_INET_SESSION_DETAIL

    public static final java.lang.String TABLE_INET_SESSION_DETAIL
    See Also:
      Constant Field Values

  - ### TABLE_INET_SESSION_ACCOUNT

    public static final java.lang.String TABLE_INET_SESSION_ACCOUNT
    See Also:
      Constant Field Values

  - ### detailTableName

    protected final java.lang.String detailTableName

  - ### accountTableName

    protected final java.lang.String accountTableName

- ## Constructor Details

  - ### AbstractInetSessionDao

    public AbstractInetSessionDao​(java.sql.Connection con, int mid, java.util.Date date)

  - ### AbstractInetSessionDao

    public AbstractInetSessionDao​(java.sql.Connection con, int mid)

- ## Method Details

  - ### getSessionTrafficsReport

    public java.util.Map<java.lang.Integer,​java.lang.Long> getSessionTrafficsReport​(int cid, java.util.Collection<java.lang.Integer> servIds, Period period, java.util.Collection<java.lang.Integer> trafficTypeIds) throws ru.bitel.bgbilling.common.BGException
    Throws:
      `ru.bitel.bgbilling.common.BGException`

  - ### addWherePart

    protected java.lang.String addWherePart​(java.util.Collection<java.lang.Integer> servIds, Period period, java.lang.String sql)

  - ### setParams

    protected void setParams​(int cid, Period period, Page page, java.sql.PreparedStatement ps) throws java.sql.SQLException
    Throws:
      `java.sql.SQLException`

  - ### loadAccount

    public void loadAccount​(java.util.List<InetSessionLog> sessions, java.util.Collection<java.lang.Integer> serviceIds) throws ru.bitel.bgbilling.common.BGException
    Throws:
      `ru.bitel.bgbilling.common.BGException`

  - ### loadTraffics

    public void loadTraffics​(java.util.List<InetSessionLog> sessions, java.util.Collection<java.lang.Integer> trafficTypeIds) throws ru.bitel.bgbilling.common.BGException
    Throws:
      `ru.bitel.bgbilling.common.BGException`

  - ### getSumReportInfo

    public java.util.List<java.lang.Double> getSumReportInfo​(int cid, java.util.Collection<java.lang.Integer> servIds, Period period) throws ru.bitel.bgbilling.common.BGException
    Throws:
      `ru.bitel.bgbilling.common.BGException`

  - ### getFromAndWherePart

    protected java.lang.String getFromAndWherePart()

  - ### getPs

    protected java.sql.PreparedStatement getPs​(int cid, java.util.Collection<java.lang.Integer> servIds, Period period, Page page, java.lang.String sql) throws java.sql.SQLException
    Throws:
      `java.sql.SQLException`