• Home
• org.kill-bill.billing
• killbill-invoice
• 0.16.4
• source code
• InvoiceSqlDao.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.

org.killbill.billing.invoice.dao.InvoiceSqlDao.sql.stg Maven / Gradle / Ivy

group InvoiceDao: EntitySqlDao;

tableName() ::= "invoices"

tableFields(prefix) ::= <<
  account_id
, invoice_date
, target_date
, currency
, migrated
, created_by
, created_date
>>

tableValues() ::= <<
  :accountId
, :invoiceDate
, :targetDate
, :currency
, :migrated
, :createdBy
, :createdDate
>>

extraTableFieldsWithComma(prefix) ::= <<
, record_id as invoice_number
>>

getInvoicesBySubscription() ::= <<
  SELECT 
  FROM  i
  JOIN invoice_items ii ON i.id = ii.invoice_id
  WHERE ii.subscription_id = :subscriptionId AND i.migrated = '0'
  
  
  ;
>>

searchQuery(prefix) ::= <<
      = :searchKey
  or account_id = :searchKey
  or currency = :searchKey
>>

getInvoiceIdByPaymentId() ::= <<
  SELECT i.id
    FROM  i, invoice_payments ip
   WHERE ip.invoice_id = i.id
     AND ip.payment_id = :paymentId
   
   
>>