Package ru.bitel.bgbilling.plugins.sbpilot.server.dao

Class SbPilotPaymentDao

java.lang.Object
ru.bitel.bgbilling.kernel.base.server.logger.BGLogger
ru.bitel.bgbilling.common.dao.AbstractDaoConstant
ru.bitel.bgbilling.common.dao.AbstractDao<SbPilotPayment>
ru.bitel.bgbilling.common.dao.AbstractIdDao<SbPilotPayment>
ru.bitel.bgbilling.plugins.sbpilot.server.dao.SbPilotPaymentDao
public class SbPilotPaymentDao extends ru.bitel.bgbilling.common.dao.AbstractIdDao<SbPilotPayment>

  • Nested Class Summary

    Nested classes/interfaces inherited from class ru.bitel.bgbilling.common.dao.AbstractDao

    ru.bitel.bgbilling.common.dao.AbstractDao.ListParams

  • Field Summary

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

    orderByPattern

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

    con, ERROR, fields, moduleId, SQL_ALL, SQL_AND, 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_ORDER, SQL_SELECT, SQL_SET, SQL_UPDATE, SQL_VALUES, SQL_WHERE, tableName

  • Constructor Summary

    Constructors
    Constructor
    Description
    SbPilotPaymentDao(Connection con)
     

  • Method Summary

    Modifier and Type
    Method
    Description
    void
    addPayment(SbPilotPayment payment)
    Добавление платежа в лог SbPilot-платежей.
    protected SbPilotPayment
    getFromRS(ResultSet rs)
     
    Result<SbPilotPayment>
    getPaymentList(Period period, Page page)
     
    protected void
    updateImpl(SbPilotPayment b)
     

    Methods inherited from class ru.bitel.bgbilling.common.dao.AbstractIdDao

    delete, executeUpdate, get, getAndDelete, getAndUpdate, loadData, opt, prepareStatement, sqlCommand, sqlCommandAndTable, sqlInsertValues, sqlQuery, sqlUpdateSet, sqlWhereId

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

    deleteImpl, dropTemporaryTable, eq, get, getById, getImpl, getListFromRS, getPeriod, getQueryById, getQueryWithFilter, getSQLOrder, list, list, list, listCountImplPS, listImpl, listImplPS, ormFromResultSet, ormUpdateImpl, ormUpdateImpl, ormUpdateImpl, ormUpdateImpl, queryPeriod, setPageRecordCount, update

    Methods inherited from class ru.bitel.bgbilling.common.dao.AbstractDaoConstant

    getPlaceholders, getSQLOrder, getSQLOrderFields, getTableName, psSetDate, psSetDateOrNull, psSetInt, psSetIntOrNull, psSetPeriod, psSetString, psSetStringOrNull, psSetTimestampOrNull, queryAndIn, setStatementParam, sqlDelete, sqlDeleteBatch, sqlInsert, sqlInsertBatch, sqlInsertGetId, sqlInsertGetLongId, sqlInsertOnDuplicateKeyUpdate, sqlInsertSelect, sqlInsertUpdateById, sqlSelectCountAsInt, sqlUpdate, sqlUpdateBatch

    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

    • SbPilotPaymentDao

      public SbPilotPaymentDao(Connection con)

  • Method Details

    • getPaymentList

      public Result<SbPilotPayment> getPaymentList(Period period, Page page) throws SQLException
      Throws:
      SQLException

    • getFromRS

      protected SbPilotPayment getFromRS(ResultSet rs) throws SQLException
      Specified by:
      getFromRS in class ru.bitel.bgbilling.common.dao.AbstractDao<SbPilotPayment>
      Throws:
      SQLException

    • addPayment

      public void addPayment(SbPilotPayment payment) throws SQLException
      Добавление платежа в лог SbPilot-платежей. Если есть уже в логе с таким ИД платежа, то не добавляется.
      Parameters:
      payment - паймет для добавления заполненный. используются поля: 1) payment_id, summa, 2) cardnum, carddate, authcode, internalnum, cardtype, 3) dt ставится текущий, type не используется
      Throws:
      SQLException

    • updateImpl

      protected void updateImpl(SbPilotPayment b) throws SQLException
      Specified by:
      updateImpl in class ru.bitel.bgbilling.common.dao.AbstractDao<SbPilotPayment>
      Throws:
      SQLException