How to add custom field values to invoice

[carry2web]

Hello netshine,

I'm working on a custom invoice template and need to add some csutom order field info (form_field_values in inv_orders) per invoice item.
I noticed that there are two intermediate tables one called inv_invoice_items and inv_orders_invoice via which invoice items can be related back to the order they belong to. Only when I have the order_id I can use the get_form_value function. Is that correct?
Do you perhaps have a relationship diagram of your data tables documented?
TIA

[carry2web]

Got it in the for loop for the invoice items, get the order_id and then the field values from that order:

Code:

$db = & JFactory::getDBO();
$query = "SELECT order_id FROM #__inv_orders_invoice WHERE invoice_item_id = $invoice_item->id AND invoice_id = $invoice->id";
$db->setQuery($query);
$order_id = $db->loadResult();
// get field values
$the_service = get_form_field_value($order_id, "service");
etc...

[netshine]

You got it. 

[ericta]

I'm trying to solve the same problem.

But it seems I can't find the this #__inv_orders_invoice table and how do you use this get_form_value() function? is there a document?

Thank you

[netshine]

This thread is for nBill 1. For nBill 2, see http://www.nbill.co.uk/forum-smf/index.php/topic,1727.0.html