[SOLVE] Display product image in order detail - prestashop 1.6

[PS newbi]

Hello

 

I would like to show product image on order detail in Prestashop 1.6

I know i have to add the below code in order-detail.tpl, but where exactly do i place it, and do i need to do more then that? Should i also do an override or something? If yes, then what to override and where?

 

the code:

<img src="{$link->getImageLink('productimage', $product.image->id_image, 'home_default')}" />

Edited July 30, 2015 by PS newbi (see edit history)

[jgamio]

Your code is not right

 

you put 'productimage' but you need to put the $product->link_rewrite instead

 

You not need override because is a theme file you just need change your tpl file

[PS newbi]

Thanks for reply. Where exactly do i place <img src="{$link->getImageLink($product->link_rewrite, $product.image->id_image, 'home_default')}" /> ?

[PS newbi]

Your code is not right

 

you put 'productimage' but you need to put the $product->link_rewrite instead

 

You not need override because is a theme file you just need change your tpl file

 

It doesn't make a difference. I only get a image box with a question mark. 

How do i get the product image to show? Thanks

[PS newbi]

Some people say that i need to do something in the controller, but what and where? Anyone? Please help. Thanks

[PS newbi]

This worked.

 

Step1 in class/order/Order.php

public function getProductsDetail()
{
return Db::getInstance(_PS_USE_SQL_SLAVE_)->ExecuteS('
SELECT *
FROM `'._DB_PREFIX_.'order_detail` od
LEFT JOIN '._DB_PREFIX_.'product p ON ( p.id_product = od.product_id)
LEFT JOIN '._DB_PREFIX_.'product_lang pl ON (pl.id_product = p.id_product)
LEFT JOIN '._DB_PREFIX_.'image i ON (i.id_product = p.id_product AND i.cover = 1)
WHERE od.`id_order` = '.(int)($this->id));
}

 

Step2 in  /controller/front/OrderDetailController.php

 

foreach($products as $key => $value) {
$objet_produit= new Product($value['product_id']);

$products[$key]['link_rewrite']= $objet_produit->link_rewrite;
$products[$key]['cover']= Product::getCover($value['product_id']);
}

or

 

$id_lang_default= Configuration::get('PS_LANG_DEFAULT');
foreach($products as $key => $value) {
$objet_produit= new Product($value['product_id']);

$products[$key]['link_rewrite']= $objet_produit->link_rewrite[$id_lang_default];
$products[$key]['cover']= Product::getCover($value['product_id']);
}

Step 3 in order-detail.tpl

 

<img src="{$link->getImageLink($product.link_rewrite, $product.cover.id_image, 'small_default')}" title="{$product.product_name|escape:'htmlall':'UTF-8'}" alt="{$product.product_name|escape:'htmlall':'UTF-8'}" />

Edited July 25, 2015 by PS newbi (see edit history)

[PS newbi]

Now i have a new proplem. The order detail is showing wrong image for combination products. It is showing the cover image instead of the image for the combination.

Someone help?? :-)

[jgamio]

You need use the image id for the combination

<img src="{$link->getImageLink($product.link_rewrite, $product.cover.id_image, 'small_default')}" title="{$product.product_name|escape:'htmlall':'UTF-8'}" alt="{$product.product_name|escape:'htmlall':'UTF-8'}" />

you need get the image id and change  $product.cover.id_image

[PS newbi]

jgamio, how do i get the image id for the combination? Where do i find it?

[jgamio]

Ok I dont sure  but is something like these

 

 

In your step2 use Product::getCombinationImages to get the combinations images then In your ps_order_detail table you have a field product_attribute_id 

 

You need do a for to compare ps_product_attribute to get the id_image to get the correct id for the image

[PS newbi]

Hello jgamio

 

Could you please paste the code how you will do it step by step? It is easier for me to understand.  :-)

Thanks a lot.

[PS newbi]

up

[PS newbi]

This one worked:

Step 1 + step 2 and below code in order_detail.tpl

<img src="{$link->getImageLink('productimage', $product.image->id_image, 'small_default')}" />

Edited July 30, 2015 by PS newbi (see edit history)