当前位置: 首页>>代码示例>>PHP>>正文


PHP zen_get_new_date_range函数代码示例

本文整理汇总了PHP中zen_get_new_date_range函数的典型用法代码示例。如果您正苦于以下问题:PHP zen_get_new_date_range函数的具体用法?PHP zen_get_new_date_range怎么用?PHP zen_get_new_date_range使用的例子?那么恭喜您, 这里精选的函数代码示例或许可以为您提供帮助。


在下文中一共展示了zen_get_new_date_range函数的2个代码示例,这些例子默认根据受欢迎程度排序。您可以为喜欢或者感觉有用的代码点赞,您的评价将有助于系统推荐出更棒的PHP代码示例。

示例1: die

 * 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 . ")";
    }
}
开发者ID:ygeneration666,项目名称:ec,代码行数:31,代码来源:new_products.php

示例2: GREATEST

             $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";
开发者ID:happyxlq,项目名称:lt_svn,代码行数:31,代码来源:header_php.php


注:本文中的zen_get_new_date_range函数示例由纯净天空整理自Github/MSDocs等开源代码及文档管理平台,相关代码片段筛选自各路编程大神贡献的开源项目,源码版权归原作者所有,传播和使用请参考对应项目的License;未经允许,请勿转载。