* Displays listing of All 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_all_listing.php 6096 2007-04-01 00:43:21Z ajeh $ */ ?> number_of_rows > 0) { $products_all = $db->Execute($products_all_split->sql_query); $row_counter = 0; while (!$products_all->EOF) { $row_counter++; if (PRODUCT_ALL_LIST_IMAGE != '0') { if ($products_all->fields['products_image'] == '' and PRODUCTS_IMAGE_NO_IMAGE_STATUS == 0) { $display_products_image = str_repeat('
', substr(PRODUCT_ALL_LIST_IMAGE, 3, 1)); } else { $display_products_image = '' . zen_image(DIR_WS_IMAGES . $products_all->fields['products_image'], $products_all->fields['products_name'], IMAGE_PRODUCT_ALL_LISTING_WIDTH, IMAGE_PRODUCT_ALL_LISTING_HEIGHT) . '' . str_repeat('
', substr(PRODUCT_ALL_LIST_IMAGE, 3, 1)); } } else { $display_products_image = ''; } if (PRODUCT_ALL_LIST_NAME != '0') { $display_products_name = '' . $products_all->fields['products_name'] . '' . str_repeat('
', substr(PRODUCT_ALL_LIST_NAME, 3, 1)); } else { $display_products_name = ''; } if (PRODUCT_ALL_LIST_MODEL != '0' and zen_get_show_product_switch($products_all->fields['products_id'], 'model')) { $display_products_model = TEXT_PRODUCTS_MODEL . $products_all->fields['products_model'] . str_repeat('
', substr(PRODUCT_ALL_LIST_MODEL, 3, 1)); } else { $display_products_model = ''; } if (PRODUCT_ALL_LIST_WEIGHT != '0' and zen_get_show_product_switch($products_all->fields['products_id'], 'weight')) { $display_products_weight = TEXT_PRODUCTS_WEIGHT . $products_all->fields['products_weight'] . TEXT_SHIPPING_WEIGHT . str_repeat('
', substr(PRODUCT_ALL_LIST_WEIGHT, 3, 1)); } else { $display_products_weight = ''; } if (PRODUCT_ALL_LIST_QUANTITY != '0' and zen_get_show_product_switch($products_all->fields['products_id'], 'quantity')) { if ($products_all->fields['products_quantity'] <= 0) { $display_products_quantity = TEXT_OUT_OF_STOCK . str_repeat('
', substr(PRODUCT_ALL_LIST_QUANTITY, 3, 1)); } else { $display_products_quantity = TEXT_PRODUCTS_QUANTITY . $products_all->fields['products_quantity'] . str_repeat('
', substr(PRODUCT_ALL_LIST_QUANTITY, 3, 1)); } } else { $display_products_quantity = ''; } if (PRODUCT_ALL_LIST_DATE_ADDED != '0' and zen_get_show_product_switch($products_all->fields['products_id'], 'date_added')) { $display_products_date_added = TEXT_DATE_ADDED . ' ' . zen_date_long($products_all->fields['products_date_added']) . str_repeat('
', substr(PRODUCT_ALL_LIST_DATE_ADDED, 3, 1)); } else { $display_products_date_added = ''; } if (PRODUCT_ALL_LIST_MANUFACTURER != '0' and zen_get_show_product_switch($products_all->fields['products_id'], 'manufacturer')) { $display_products_manufacturers_name = ($products_all->fields['manufacturers_name'] != '' ? TEXT_MANUFACTURER . ' ' . $products_all->fields['manufacturers_name'] . str_repeat('
', substr(PRODUCT_ALL_LIST_MANUFACTURER, 3, 1)) : ''); } else { $display_products_manufacturers_name = ''; } if ((PRODUCT_ALL_LIST_PRICE != '0' and zen_get_products_allow_add_to_cart($products_all->fields['products_id']) == 'Y') and zen_check_show_prices() == true) { $products_price = zen_get_products_display_price($products_all->fields['products_id']); $display_products_price = TEXT_PRICE . ' ' . $products_price . str_repeat('
', substr(PRODUCT_ALL_LIST_PRICE, 3, 1)) . (zen_get_show_product_switch($products_all->fields['products_id'], 'ALWAYS_FREE_SHIPPING_IMAGE_SWITCH') ? (zen_get_product_is_always_free_shipping($products_all->fields['products_id']) ? TEXT_PRODUCT_FREE_SHIPPING_ICON . '
' : '') : ''); } else { $display_products_price = ''; } // more info in place of buy now if (PRODUCT_ALL_BUY_NOW != '0' and zen_get_products_allow_add_to_cart($products_all->fields['products_id']) == 'Y') { if (zen_has_product_attributes($products_all->fields['products_id'])) { $link = '' . MORE_INFO_TEXT . ''; } else { // $link= '' . zen_image_button(BUTTON_IMAGE_IN_CART, BUTTON_IN_CART_ALT) . ''; if (PRODUCT_ALL_LISTING_MULTIPLE_ADD_TO_CART > 0 && $products_all->fields['products_qty_box_status'] != 0) { // $how_many++; $link = TEXT_PRODUCT_ALL_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($products_all->fields['products_id'], $the_button, $products_link) . '
' . zen_get_products_quantity_min_units_display($products_all->fields['products_id']) . str_repeat('
', substr(PRODUCT_ALL_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($products_all->fields['products_id'], $the_button, $products_link) . '
' . zen_get_products_quantity_min_units_display($products_all->fields['products_id']) . str_repeat('
', substr(PRODUCT_ALL_BUY_NOW, 3, 1)); } if (PRODUCT_ALL_LIST_DESCRIPTION > '0') { $disp_text = zen_get_products_description($products_all->fields['products_id']); $disp_text = zen_clean_html($disp_text); $display_products_description = stripslashes(zen_trunc_string($disp_text, PRODUCT_ALL_LIST_DESCRIPTION, ' ' . MORE_INFO_TEXT . '')); } else { $display_products_description = ''; } ?> '0') { ?> MoveNext(); } } else { ?>

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_ALL_LIST_IMAGE') { echo $display_products_image; } if ($disp_sort_order->fields['configuration_key'] == 'PRODUCT_ALL_LIST_QUANTITY') { echo $display_products_quantity; } if ($disp_sort_order->fields['configuration_key'] == 'PRODUCT_ALL_BUY_NOW') { echo $display_products_button; } if ($disp_sort_order->fields['configuration_key'] == 'PRODUCT_ALL_LIST_NAME') { echo $display_products_name; } if ($disp_sort_order->fields['configuration_key'] == 'PRODUCT_ALL_LIST_MODEL') { echo $display_products_model; } if ($disp_sort_order->fields['configuration_key'] == 'PRODUCT_ALL_LIST_MANUFACTURER') { echo $display_products_manufacturers_name; } if ($disp_sort_order->fields['configuration_key'] == 'PRODUCT_ALL_LIST_PRICE') { echo $display_products_price; } if ($disp_sort_order->fields['configuration_key'] == 'PRODUCT_ALL_LIST_WEIGHT') { echo $display_products_weight; } if ($disp_sort_order->fields['configuration_key'] == 'PRODUCT_ALL_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_ALL_LIST_IMAGE') { echo $display_products_image; } if ($disp_sort_order->fields['configuration_key'] == 'PRODUCT_ALL_LIST_QUANTITY') { echo $display_products_quantity; } if ($disp_sort_order->fields['configuration_key'] == 'PRODUCT_ALL_BUY_NOW') { echo $display_products_button; } if ($disp_sort_order->fields['configuration_key'] == 'PRODUCT_ALL_LIST_NAME') { echo $display_products_name; } if ($disp_sort_order->fields['configuration_key'] == 'PRODUCT_ALL_LIST_MODEL') { echo $display_products_model; } if ($disp_sort_order->fields['configuration_key'] == 'PRODUCT_ALL_LIST_MANUFACTURER') { echo $display_products_manufacturers_name; } if ($disp_sort_order->fields['configuration_key'] == 'PRODUCT_ALL_LIST_PRICE') { echo $display_products_price; } if ($disp_sort_order->fields['configuration_key'] == 'PRODUCT_ALL_LIST_WEIGHT') { echo $display_products_weight; } if ($disp_sort_order->fields['configuration_key'] == 'PRODUCT_ALL_LIST_DATE_ADDED') { echo $display_products_date_added; } $disp_sort_order->MoveNext(); } ?>