• Home
• com.ning.billing
• killbill-payment
• 0.1.72
• source code
• PaymentAttemptSqlDao.sql.stg

×

Project download

Many resources are needed to download a project. Please understand that we have to compensate our server costs. Thank you in advance.
Project price only 1 $

You can buy this project and download/modify it how often you want.

com.ning.billing.payment.dao.PaymentAttemptSqlDao.sql.stg Maven / Gradle / Ivy

group PaymentAttemptSqlDao: EntitySqlDao;

tableFields(prefix) ::= <<
  payment_id
, gateway_error_code
, gateway_error_msg
, processing_status
, requested_amount
, created_by
, created_date
, updated_by
, updated_date
>>

tableValues() ::= <<
  :paymentId
, :gatewayErrorCode
, :gatewayErrorMsg
, :processingStatus
, :requestedAmount
, :createdBy
, :createdDate
, :updatedBy
, :updatedDate
>>

tableName() ::= "payment_attempts"

historyTableName() ::= "payment_attempt_history"


getById(id) ::= <<
select 
, pa.created_date as effective_date
, p.account_id as account_id
, p.invoice_id as invoice_id
from  pa join payments p
where pa.id = :id
and pa.payment_id = p.id


;
>>

getByPaymentId(paymentId) ::= <<
select 
, pa.created_date as effective_date
, p.account_id as account_id
, p.invoice_id as invoice_id
from  pa join payments p
where pa.payment_id = :paymentId
and p.id = :paymentId


order by effective_date asc
;
>>


updatePaymentAttemptStatus() ::= <<
update 
set processing_status = :processingStatus
, gateway_error_code = :gatewayErrorCode
, gateway_error_msg = :gatewayErrorMsg
where id = :id

;
>>