* new_products.php module
*
* @package modules
* @copyright Copyright 2003-2008 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: new_products.php 8730 2008-06-28 01:31:22Z drbyte $
*/
if (!defined('IS_ADMIN_FLAG')) {
die('Illegal Access');
}
// initialize vars
$categories_products_id_list = '';
$list_of_products = '';
$new_products_query = '';
$display_limit = zen_get_new_date_range();
if ($manufacturers_id > 0 && $_GET['filter_id'] == 0 || $_GET['music_genre_id'] > 0 || $_GET['record_company_id'] > 0 || (!isset($new_products_category_id) || $new_products_category_id == '0')) {
$new_products_query = "select distinct p.products_id, p.products_image, p.products_tax_class_id, pd.products_name,\n p.products_date_added, p.products_price, p.products_type, p.master_categories_id\n from " . TABLE_PRODUCTS . " p, " . TABLE_PRODUCTS_DESCRIPTION . " pd\n where p.products_id = pd.products_id\n and pd.language_id = '" . (int) $_SESSION['languages_id'] . "'\n and p.products_status = 1 " . $display_limit;
} else {
// get all products and cPaths in this subcat tree
$productsInCategory = zen_get_categories_products_list($manufacturers_id > 0 && $_GET['filter_id'] > 0 ? zen_get_generated_category_path_rev($_GET['filter_id']) : $cPath, false, true, 0, $display_limit);
if (is_array($productsInCategory) && sizeof($productsInCategory) > 0) {
// build products-list string to insert into SQL query
foreach ($productsInCategory as $key => $value) {
$list_of_products .= $key . ', ';
}
$list_of_products = substr($list_of_products, 0, -2);
// remove trailing comma
$new_products_query = "select distinct p.products_id, p.products_image, p.products_tax_class_id, pd.products_name,\n p.products_date_added, p.products_price, p.products_type, p.master_categories_id\n from " . TABLE_PRODUCTS . " p, " . TABLE_PRODUCTS_DESCRIPTION . " pd\n where p.products_id = pd.products_id\n and pd.language_id = '" . (int) $_SESSION['languages_id'] . "'\n and p.products_status = 1\n and p.products_id in (" . $list_of_products . ")";
}
}
$where_cat = "AND p.products_id = p2c.products_id\n AND c.categories_id = " . (int) $current_category_id . "\n AND p2c.categories_id = " . (int) $current_category_id . " ";
} else {
$where_cat = "AND p.master_categories_id = " . (int) $current_category_id . " ";
}
}
$expected_query = "SELECT DISTINCT p.products_id, pd.products_name, pd.products_description, p.products_image, GREATEST(p.products_date_added, IFNULL(p.products_last_modified, 0)) AS products_date, p.products_date_available as date_expected, p.products_price_sorter as price, p.products_tax_class_id, p.products_quantity, p.products_model, p.products_weight, p.manufacturers_id, m.manufacturers_name, r.reviews_rating\n FROM " . TABLE_PRODUCTS . " p\n LEFT JOIN " . TABLE_PRODUCTS_DESCRIPTION . " pd ON (pd.products_id = p.products_id)\n LEFT JOIN " . TABLE_MANUFACTURERS . " m ON (p.manufacturers_id = m.manufacturers_id)\n LEFT JOIN " . TABLE_REVIEWS . " r ON (p.products_id = r.products_id)\n " . $from_cat . "\n WHERE to_days(products_date_available) >= to_days(now())\n AND p.products_status = 1\n AND pd.language_id = " . (int) $_SESSION['languages_id'] . "\n " . $where_cat . "\n " . $display_limit . "\n ORDER BY " . EXPECTED_PRODUCTS_FIELD . " " . EXPECTED_PRODUCTS_SORT . $limit;
zen_rss_products($expected_query, $random);
break;
case "new_products_random":
$random = true;
$rss->rssFeedCahcheSet(false);
$limit = " LIMIT " . MAX_RANDOM_SELECT_NEW;
case "new_products":
$disp_order_default = PRODUCT_NEW_LIST_SORT_DEFAULT;
require DIR_WS_MODULES . zen_get_module_directory(FILENAME_LISTING_DISPLAY_ORDER);
$where_days = zen_get_new_date_range();
case "products":
default:
$where_cat = $from_cat = "";
if (isset($current_category_id) && $current_category_id > 0) {
if (RSS_PRODUCTS_CATEGORIES == 'all') {
$from_cat = ", " . TABLE_PRODUCTS_TO_CATEGORIES . " p2c, " . TABLE_CATEGORIES . " c ";
$where_cat = "AND p.products_id = p2c.products_id\n AND c.categories_id = " . (int) $current_category_id . "\n AND p2c.categories_id = " . (int) $current_category_id . " ";
} else {
$where_cat = "AND p.master_categories_id = " . (int) $current_category_id . " ";
}
}
$where_prod = '';
if (isset($_GET['products_id'])) {
$where_prod = " AND p.products_id=" . (int) $_GET['products_id'];
$limit = " LIMIT 1";
