Class DataExtractor
java.lang.Object
ru.bitel.bgbilling.modules.bill.server.bean.DataExtractor
-
Constructor Summary
-
Method Summary
Modifier and TypeMethodDescriptionprotected BigDecimal
getAmount
(Connection con, String table, String col, List<String> paramList, Calendar month, String cids) protected BigDecimal
getAmount
(Connection con, String table, String col, List<String> paramList, Calendar month, String cids, String filter) protected BigDecimal
getAmount
(Connection con, String table, String col, List<String> paramList, Calendar month, String cids, String filter, String cidFieldName, String sidFieldName) protected long
getCountFromTable
(Connection con, String tableName, String cids, Calendar month, String filter) protected long
getCountFromTable
(Connection con, String tableName, String cids, Calendar month, String filter, String cidFieldName, String date1Field, String date2Field) protected BigDecimal
getCountSession
(Connection con, String table, List<String> paramList, Calendar month, String cids, String filter) protected BigDecimal
getCountSession
(Connection con, String table, List<String> paramList, Calendar month, String cids, String filter, String cidFieldName, String sidFieldName) protected String
getIdsFromEnd
(int posFrom, List<String> paramList) protected int
getIntParam
(List<String> paramList, int pos) protected Calendar
getMonthParam
(Calendar month, List<String> paramList, int pos) protected BigDecimal
getSumFromTable
(Connection con, String tableName, String col, String cids, String sids, String filter, String cidFieldName, String sidFieldName)
-
Constructor Details
-
DataExtractor
public DataExtractor()
-
-
Method Details
-
getIntParam
-
getMonthParam
-
getIdsFromEnd
-
getSumFromTable
protected BigDecimal getSumFromTable(Connection con, String tableName, String col, String cids, String sids, String filter, String cidFieldName, String sidFieldName) throws SQLException - Throws:
SQLException
-
getCountFromTable
protected long getCountFromTable(Connection con, String tableName, String cids, Calendar month, String filter) throws SQLException - Throws:
SQLException
-
getCountFromTable
protected long getCountFromTable(Connection con, String tableName, String cids, Calendar month, String filter, String cidFieldName, String date1Field, String date2Field) throws SQLException - Throws:
SQLException
-
getAmount
protected BigDecimal getAmount(Connection con, String table, String col, List<String> paramList, Calendar month, String cids) -
getAmount
protected BigDecimal getAmount(Connection con, String table, String col, List<String> paramList, Calendar month, String cids, String filter) -
getAmount
-
getCountSession
protected BigDecimal getCountSession(Connection con, String table, List<String> paramList, Calendar month, String cids, String filter) -
getCountSession
protected BigDecimal getCountSession(Connection con, String table, List<String> paramList, Calendar month, String cids, String filter, String cidFieldName, String sidFieldName)
-