1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27
| $product_info_query = tep_db_query("select p.products_id, pd.products_head_title_tag, p.products_quantity, p.products_image, p.products_subimage1, p.products_subimage2, p.products_subimage3, p.products_subimage4, p.products_tax_class_id, ptc.classification_id from " . TABLE_PRODUCTS . " p, " . TABLE_PRODUCTS_DESCRIPTION . " pd, " . TABLE_PRODUCTS_TO_CLASSIFICATION . " ptc where p.products_status = '1' and p.products_id = '" . (int)$products_id . "' and pd.products_id = p.products_id and ptc.products_id = p.products_id and pd.language_id = '" . (int)$languages_id . "'");
$product_info = tep_db_fetch_array($product_info_query);
$products_quantity = $product_info['products_quantity'];
if ($products_quantity > '1') {
$product_order_check_query = tep_db_query("select count(*) as total from " . TABLE_PRODUCTS_ORDER_IMAGE . " where products_id = '" . (int)$HTTP_GET_VARS['products_id'] . "'");
$product_order_check = tep_db_fetch_array($product_order_check_query);
if ($product_order_check['total'] > 0) {
$product_image_query = tep_db_query("select * from " . TABLE_PRODUCTS_ORDER_IMAGE . " where products_id = '" . (int)$HTTP_GET_VARS['products_id'] . "' ");
$product_image = tep_db_fetch_array($product_image_query);
$order = array();
$a=1;
while ($a<6)
{
if ($product_image['products_order_image']==$a){$img_order[$a] = $product_info['products_image'] ; }
if ($product_image['products_order_subimage1']==$a){$img_order[$a] = $product_info['products_subimage1'] ; }
if ($product_image['products_order_subimage2']==$a){$img_order[$a] = $product_info['products_subimage2'] ; }
if ($product_image['products_order_subimage3']==$a){$img_order[$a] = $product_info['products_subimage3'] ; }
if ($product_image['products_order_subimage4']==$a){$img_order[$a] = $product_info['products_subimage4'] ; }
$a++;
}
$img =$img_order['1'];
} else {
$img = $product_info['products_image'] ;
}
return '<a href="' . tep_href_link(FILENAME_PRODUCT_INFO, 'products_id=' . $products_id) . '" title="'.$product_info['products_name'].'">' . tep_image(DIR_WS_IMAGES .'product/' .$img, $listing['products_name'], 400, 266) . '<br>'.$product_info['products_head_title_tag'].'</a>'; |
Partager