* 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 = '
' . 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 = '
'.TEXT_DATE_ADDED . ' ' . zen_date_long($featured_products->fields['products_date_added']) . str_repeat('', substr(PRODUCT_FEATURED_LIST_DATE_ADDED, 3, 1)).'
';
} 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 = '
';
}
}
$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 {
?>