* Displays listing of Featured Products * * @package templateSystem * @copyright Copyright 2003-2007 Zen Cart Development Team * @copyright Portions Copyright 2003 osCommerce * @license http://www.zen-cart.com/license/2_0.txt GNU Public License V2.0 * @version $Id: tpl_modules_products_featured_listing.php 6096 2007-04-01 00:43:21Z ajeh $ */ ?>
number_of_rows > 0) { $featured_products = $db->Execute($featured_products_split->sql_query); while (!$featured_products->EOF) { if (PRODUCT_FEATURED_LIST_IMAGE != '0') { if ($featured_products->fields['products_image'] == '' and PRODUCTS_IMAGE_NO_IMAGE_STATUS == 0) { $display_products_image = str_repeat('
', substr(PRODUCT_FEATURED_LIST_IMAGE, 3, 1)); } else { if(zen_get_products_special_price($featured_products->fields['products_id'])){ $ps_dd=true; } else{ $ps_dd=false; } $pf_dd=true; if($featured_products->fields['product_is_always_free_shipping']){ $free_dd=true; }else{ $free_dd=false; } if($ps_dd&&$pf_dd&&$free_dd){ $dd='Sale Free shipping'; } else if(($ps_dd&&$pf_dd)||($pf_dd&&$free_dd)||($ps_dd&&$free_dd)){ if($ps_dd&&$pf_dd){ $dd='Sale '; }else if($pf_dd&&$free_dd){ $dd=' Free shipping'; }else if($ps_dd&&$free_dd){ $dd='Sale Free shipping'; } } else if($ps_dd){ $dd='Sale'; } else if($pf_dd){ $dd=''; } else if($free_dd){ $dd='Free shipping'; } else{ $dd=''; } $display_products_image = '
' . zen_image(DIR_WS_IMAGES . $featured_products->fields['products_image'], $featured_products->fields['products_name'], IMAGE_FEATURED_PRODUCTS_LISTING_WIDTH, IMAGE_FEATURED_PRODUCTS_LISTING_HEIGHT) . '
'.$dd.'
' . str_repeat('
', substr(PRODUCT_FEATURED_LIST_IMAGE, 3, 1)); } } else { $display_products_image = ''; } if (PRODUCT_FEATURED_LIST_NAME != '0') { $display_products_name = '' .zen_trunc_string($featured_products->fields['products_name'],70) . ''; } else { $display_products_name = ''; } if (PRODUCT_FEATURED_LIST_MODEL != '0' and zen_get_show_product_switch($featured_products->fields['products_id'], 'model')) { $display_products_model = ''.''.TEXT_PRODUCTS_MODEL.'' . $featured_products->fields['products_model'] . str_repeat('
', substr(PRODUCT_FEATURED_LIST_MODEL, 3, 1)).'
'; } else { $display_products_model = ''; } if (PRODUCT_FEATURED_LIST_WEIGHT != '0' and zen_get_show_product_switch($featured_products->fields['products_id'], 'weight')) { $display_products_weight = ''.TEXT_PRODUCTS_WEIGHT.'' . $featured_products->fields['products_weight'] . TEXT_SHIPPING_WEIGHT . str_repeat('
', substr(PRODUCT_FEATURED_LIST_WEIGHT, 3, 1)); } else { $display_products_weight = ''; } if (PRODUCT_FEATURED_LIST_QUANTITY != '0' and zen_get_show_product_switch($featured_products->fields['products_id'], 'quantity')) { if ($featured_products->fields['products_quantity'] <= 0) { $display_products_quantity = ''.TEXT_OUT_OF_STOCK . str_repeat('', substr(PRODUCT_FEATURED_LIST_QUANTITY, 3, 1)).''; } else { $display_products_quantity = ''; } } else { $display_products_quantity = ''; } if (PRODUCT_FEATURED_LIST_DATE_ADDED != '0' and zen_get_show_product_switch($featured_products->fields['products_id'], 'date_added')) { $display_products_date_added = ''; } else { $display_products_date_added = ''; } if (PRODUCT_FEATURED_LIST_MANUFACTURER != '0' and zen_get_show_product_switch($featured_products->fields['products_id'], 'manufacturer')) { $display_products_manufacturers_name = ($featured_products->fields['manufacturers_name'] != '' ? ''.TEXT_MANUFACTURER.'' . ' ' . $featured_products->fields['manufacturers_name'] . str_repeat('
', substr(PRODUCT_FEATURED_LIST_MANUFACTURER, 3, 1)) : ''); } else { $display_products_manufacturers_name = ''; } if ((PRODUCT_FEATURED_LIST_PRICE != '0' and zen_get_products_allow_add_to_cart($featured_products->fields['products_id']) == 'Y') and zen_check_show_prices() == true) { $products_price = ''.zen_get_products_display_price($featured_products->fields['products_id']).''; $display_products_price = ''.zen_get_products_display_price($featured_products->fields['products_id']).''; } else { $display_products_price = ''; } // more info in place of buy now if (PRODUCT_FEATURED_BUY_NOW != '0' and zen_get_products_allow_add_to_cart($featured_products->fields['products_id']) == 'Y') { if (zen_has_product_attributes($featured_products->fields['products_id'])) { $link = '' . MORE_INFO_TEXT . ''; } else { // $link= '' . zen_image_button(BUTTON_IMAGE_IN_CART, BUTTON_IN_CART_ALT) . ''; if (PRODUCT_FEATURED_LISTING_MULTIPLE_ADD_TO_CART > 0 && $featured_products->fields['products_qty_box_status'] != 0) { // $how_many++; $link = TEXT_PRODUCT_FEATURED_LISTING_MULTIPLE_ADD_TO_CART . "fields['products_id'] . "]\" value=\"0\" size=\"4\" />"; } else { $link = '
' . zen_image_button(BUTTON_IMAGE_BUY_NOW, BUTTON_BUY_NOW_ALT) . '
 '; } } $the_button = $link; $products_link = '' . MORE_INFO_TEXT . ''; $display_products_button = zen_get_buy_now_button($featured_products->fields['products_id'], $the_button, $products_link) . '
' . zen_get_products_quantity_min_units_display($featured_products->fields['products_id']) . str_repeat('
', substr(PRODUCT_FEATURED_BUY_NOW, 3, 1)); } else { $link = '' . MORE_INFO_TEXT . ''; $the_button = $link; $products_link = '' . MORE_INFO_TEXT . ''; $display_products_button = zen_get_buy_now_button($featured_products->fields['products_id'], $the_button, $products_link) . '
' . zen_get_products_quantity_min_units_display($featured_products->fields['products_id']) . str_repeat('
', substr(PRODUCT_FEATURED_BUY_NOW, 3, 1)); } if (PRODUCT_FEATURED_LIST_DESCRIPTION > '0') { $disp_text = zen_get_products_description($featured_products->fields['products_id']); $disp_text = zen_clean_html($disp_text); $display_products_description = stripslashes(zen_trunc_string($disp_text, PRODUCT_FEATURED_LIST_DESCRIPTION, ' ' . MORE_INFO_TEXT . '')); } else { $display_products_description = ''; } ?>
Execute("select configuration_key, configuration_value from " . TABLE_CONFIGURATION . " where configuration_group_id='" . $group_id . "' and (configuration_value >= 1000 and configuration_value <= 1999) order by LPAD(configuration_value,11,0)"); while (!$disp_sort_order->EOF) { if ($disp_sort_order->fields['configuration_key'] == 'PRODUCT_FEATURED_LIST_IMAGE') { echo $display_products_image; } if ($disp_sort_order->fields['configuration_key'] == 'PRODUCT_FEATURED_LIST_QUANTITY') { echo $display_products_quantity; } if ($disp_sort_order->fields['configuration_key'] == 'PRODUCT_FEATURED_BUY_NOW') { echo $display_products_button; } if ($disp_sort_order->fields['configuration_key'] == 'PRODUCT_FEATURED_LIST_NAME') { echo $display_products_name; } if ($disp_sort_order->fields['configuration_key'] == 'PRODUCT_FEATURED_LIST_MODEL') { echo $display_products_model; } if ($disp_sort_order->fields['configuration_key'] == 'PRODUCT_FEATURED_LIST_MANUFACTURER') { echo $display_products_manufacturers_name; } if ($disp_sort_order->fields['configuration_key'] == 'PRODUCT_FEATURED_LIST_PRICE') { echo $display_products_price; } if ($disp_sort_order->fields['configuration_key'] == 'PRODUCT_FEATURED_LIST_WEIGHT') { echo $display_products_weight; } if ($disp_sort_order->fields['configuration_key'] == 'PRODUCT_FEATURED_LIST_DATE_ADDED') { echo $display_products_date_added .'
'; } $disp_sort_order->MoveNext(); } ?>
Execute("select configuration_key, configuration_value from " . TABLE_CONFIGURATION . " where configuration_group_id='" . $group_id . "' and (configuration_value >= 2000 and configuration_value <= 2999) order by LPAD(configuration_value,11,0)"); while (!$disp_sort_order->EOF) { if ($disp_sort_order->fields['configuration_key'] == 'PRODUCT_FEATURED_LIST_NAME') { echo $display_products_name; } $disp_sort_order->MoveNext(); } ?>
MoveNext(); } } else { ?>