To make this super_invoice.php appearance a bit refined I see where the note itself would be better to keep visible in admin only, but the title could appear on the invoice.
PHP Code:
<td class="dataTableContent"><?php echo $notes->fields['notes_title']; ?></td>
I need to draw the info from the notes table and link to the customer ID to show on that customer's invoice though.
Is this close as it does not currently work? Also, how do I specify the Order Notes category only (notes_categories_id)?
PHP Code:
<?php
$table_notes = $db->Execute("select notes_title
from " . TABLE_NOTES . "
where customers_id = '" . $order->customer['id'] . "'");
?>
Bookmarks