com.ning.billing.invoice.dao.InvoicePaymentSqlDao.sql.stg Maven / Gradle / Ivy

Go to download
group InvoicePayment: EntitySqlDao;

tableName() ::= "invoice_payments"

tableFields(prefix) ::= <<
  type
, invoice_id
, payment_id
, payment_date
, amount
, currency
, payment_cookie_id
, linked_invoice_payment_id
, created_by
, created_date
>>

tableValues() ::= <<
  :type
, :invoiceId
, :paymentId
, :paymentDate
, :amount
, :currency
, :paymentCookieId
, :linkedInvoicePaymentId
, :createdBy
, :createdDate
>>

getByPaymentId() ::= <<
  SELECT 
  FROM 
  WHERE payment_id = :paymentId
  
  ;
>>

getPaymentsForCookieId() ::= <<
  SELECT 
  FROM 
  WHERE payment_cookie_id = :paymentCookieId
  
  ;
>>

getPaymentsForInvoice() ::= <<
  SELECT 
  FROM 
  WHERE invoice_id = :invoiceId
  
  ;
>>

getInvoicePayments() ::= <<
    SELECT 
    FROM 
    WHERE payment_id = :paymentId
    
    ;
>>

getRemainingAmountPaid() ::= <<
    SELECT SUM(amount)
    FROM 
    WHERE (id = :invoicePaymentId OR linked_invoice_payment_id = :invoicePaymentId)
    
    ;
>>

getAccountIdFromInvoicePaymentId() ::= <<
    SELECT i.account_id
    FROM  ip
    INNER JOIN invoices i ON i.id = ip.invoice_id
    WHERE ip.id = :invoicePaymentId
    
    
    ;
>>

getChargeBacksByAccountId() ::= <<
    SELECT 
    FROM  ip
    INNER JOIN invoices i ON i.id = ip.invoice_id
    WHERE ip.type = 'CHARGED_BACK' AND i.account_id = :accountId
    
    
    ;
>>

getChargebacksByPaymentId() ::= <<
    SELECT 
    FROM 
    WHERE type = 'CHARGED_BACK'
    AND linked_invoice_payment_id IN (SELECT id FROM invoice_payments WHERE payment_id = :paymentId)
    
    ;
>>