• Home
• org.kill-bill.billing
• killbill-invoice
• 0.16.4
• source code
• InvoiceItemSqlDao.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.InvoiceItemSqlDao.sql.stg Maven / Gradle / Ivy

group InvoiceItemSqlDao: EntitySqlDao;

tableName() ::= "invoice_items"

tableFields(prefix) ::= <<
  type
, invoice_id
, account_id
, bundle_id
, subscription_id
, description
, plan_name
, phase_name
, usage_name
, start_date
, end_date
, amount
, rate
, currency
, linked_item_id
, created_by
, created_date
>>

tableValues() ::= <<
  :type
, :invoiceId
, :accountId
, :bundleId
, :subscriptionId
, :description
, :planName
, :phaseName
, :usageName
, :startDate
, :endDate
, :amount
, :rate
, :currency
, :linkedItemId
, :createdBy
, :createdDate
>>


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

getInvoiceItemsBySubscription() ::= <<
  SELECT 
  FROM 
  WHERE subscription_id = :subscriptionId
  
  ;
>>

getAdjustedOrRepairedInvoiceItemsByLinkedId() ::= <<
  SELECT 
  FROM 
  WHERE linked_item_id = :linkedItemId
  AND type IN ('ITEM_ADJ', 'REPAIR_ADJ')
  
  ;
>>