News:

Looking for documentation? Take a look on our wiki

Main Menu

How to add a product thumbails to invoice (invoice_items.php)?

Started by Al37, April 03, 2012, 17:28:59 PM

Previous topic - Next topic

Al37

How to add a product thumbails to invoice (\components\com_virtuemart\views\invoice\tmpl\invoice_items.php)?

Please, tell me the code.

Al37

Here it is, may be it will help somebody else..
                <?php 
                $db 
JFactory::getDbo(); 
                
$db->setQuery('SELECT m.file_url_thumb FROM #__virtuemart_product_medias pm,#__virtuemart_medias m WHERE (pm.virtuemart_product_id='.$item->virtuemart_product_id.')AND(pm.virtuemart_media_id=m.virtuemart_media_id)'); 
                
$res $db->LoadResult(); 
                echo 
"<img src=\"$res\">"
                
?>