Tak si odpovedám sám, možno to niekomu pomôže ale predsa potrebujem ešte pomôcť ...
Tu je query na zmenu img coveru: (Zmení to img cover podľa predvolenej kombinácie)
Kód:
UPDATE ps_image SET cover = NULL;
UPDATE ps_image_shop SET cover = NULL;
UPDATE IGNORE ps_image
SET cover = 1
WHERE ps_image.id_image IN (
SELECT ps_product_attribute_image.id_image
FROM ps_product_attribute
INNER JOIN ps_product_attribute_image
ON ps_product_attribute.id_product_attribute = ps_product_attribute_image.id_product_attribute
AND ps_product_attribute.default_on = 1
);
UPDATE IGNORE ps_image_shop
SET cover = 1
WHERE ps_image_shop.id_image IN (
SELECT ps_product_attribute_image.id_image
FROM ps_product_attribute
INNER JOIN ps_product_attribute_image
ON ps_product_attribute.id_product_attribute = ps_product_attribute_image.id_product_attribute
AND ps_product_attribute.default_on = 1
);
UPDATE IGNORE `ps_image` SET `cover` = 1;
UPDATE IGNORE `ps_image_shop` SET `cover` = 1;
Používam tento kód na zobrazenie dvoch produktových obrázkov.
• 1. obrázok: = img cover
• 2. obrázok: = druhý v poradí tak ako sú zoradené v produktoch -> obrázky
Používam tento kód:
Kód:
<a class="product_img_link is_stlazyloading" href="{$product.link|escape:'html':'UTF-8'}" title="{$product.name|escape:'html':'UTF-8'}" itemprop="url">
<img src="{$link->getImageLink($product.link_rewrite, $product.id_image, 'home_default')|escape:'html':'UTF-8'}" class="stlazyloading_holder" {if isset($homeSize)} width="{$homeSize.width}" height="{$homeSize.height}"{/if} />
{assign var='productimg' value=Tools::getProductsImgs($product.id_product)}
{if isset($productimg[0]) && isset($productimg[1])}
<img class="replace-2x img-responsive stlazyloadthis" data-src="{$link->getImageLink($product.link_rewrite, $product.id_image, 'home_default')|escape:'html':'UTF-8'}" alt="{if !empty($product.legend)}{$product.legend|escape:'html':'UTF-8'}{else}{$product.name|escape:'html':'UTF-8'}{/if}" title="{if !empty($product.legend)}{$product.legend|escape:'html':'UTF-8'}{else}{$product.name|escape:'html':'UTF-8'}{/if}" {if isset($homeSize)} width="{$homeSize.width}" height="{$homeSize.height}"{/if} itemprop="image" />
{if $mobile_device}
<!-- no hover img for mobile -->
{else}
<!--hover 2nd img-->
<img class="replace-2x img-responsive img_1 stlazyloadthis" data-src="{$link->getImageLink($product.link_rewrite,$product.id_product|cat:"-"|cat:$productimg[1].id_image, 'home_default')}" alt="{if !empty($product.legend)}{$product.legend|escape:'html':'UTF-8'}{else}{$product.name|escape:'html':'UTF-8'}{/if}" title="{if !empty($product.legend)}{$product.legend|escape:'html':'UTF-8'}{else}{$product.name|escape:'html':'UTF-8'}{/if}" {if isset($homeSize)} width="{$homeSize.width}" height="{$homeSize.height}"{/if} />
<!--hover 2nd img-->
{/if}
{else}
<img class="replace-2x img-responsive stlazyloadthis" data-src="{$link->getImageLink($product.link_rewrite, $product.id_image, 'home_default')|escape:'html':'UTF-8'}" alt="{if !empty($product.legend)}{$product.legend|escape:'html':'UTF-8'}{else}{$product.name|escape:'html':'UTF-8'}{/if}" title="{if !empty($product.legend)}{$product.legend|escape:'html':'UTF-8'}{else}{$product.name|escape:'html':'UTF-8'}{/if}" {if isset($homeSize)} width="{$homeSize.width}" height="{$homeSize.height}"{/if} itemprop="image" />
{/if}
</a>
A tu potrebujem spraviť to, aby mi druhý obrázok nebralo z druhej pozície tak ako sú zoradené obrázky v admine, ale aby mi načítalo druhý obŕázok v poradí z danej (rsp. predvolenej) kombinácie.
Ako Prosím? ...