Updating invoice template for stockpick

[Tim Norton]

Hi everyone. I have a request to modify the invoice to include one of the resource images that I have attached to each product.  I have read through all of the prior mentions of invoice modifications but none seem to be entirely clear on how to do this.

I need to know what is the default location of an invoice.tpl to modify, and what MySQL table is the full data located in so I need to know if I need to add a sql view or something to pull the data forward.

Basically, the simplest version of the query that identifies the image is:

SELECT resource_path  FROM `abe7_resource_map` A
LEFT JOIN `abe7_resource_descriptions` B ON A.resource_id = B.resource_id
WHERE sort_order = 2 and A.object_id = {product_id}

Any help would be appreciated.

Tim

[maxter]

Here is the location of the invoice template:
https://github.com/abantecart/abantecart-src/blob/master/public_html/storefront/view/default/template/pages/account/invoice.tpl

But SQL are not handled in the template. You need to add this to the controller or better model:
https://github.com/abantecart/abantecart-src/blob/master/public_html/storefront/controller/pages/account/invoice.php