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

Go to download

Show more of this group Show more artifacts with this name
Show all versions of killbill-invoice Show documentation

There is a newer version: 0.24.12

group InvoiceDao: EntitySqlDao;

tableName() ::= "invoices"

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

tableValues() ::= <<
  :accountId
, :invoiceDate
, :targetDate
, :currency
, :status
, :migrated
, :parentInvoice
, :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
   
   
>>

updateStatus() ::= <<
    UPDATE 
    SET status = :status
    WHERE id = :id
    ;
>>

getParentDraftInvoice() ::= <<
  SELECT 
    FROM 
   WHERE account_id = :accountId
     AND status = 'DRAFT'
   
   
>>

getParentInvoiceByChildInvoiceId() ::= <<
   SELECT 
     FROM  i
     INNER JOIN invoice_parent_children ipc ON i.id = ipc.parent_invoice_id
    WHERE ipc.child_invoice_id = :childInvoiceId
   
   
 >>