[Sommaire] [Imprimer]

   1  <?php
   2  /**

   3   * whats_new sidebox - displays a random "new" product

   4   *

   5   * @package templateSystem

   6   * @copyright Copyright 2003-2005 Zen Cart Development Team

   7   * @copyright Portions Copyright 2003 osCommerce

   8   * @license http://www.zen-cart.com/license/2_0.txt GNU Public License V2.0

   9   * @version $Id: whats_new.php 4162 2006-08-17 03:55:02Z ajeh $

  10   */
  11  
  12  // display limits

  13  //$display_limit = zen_get_products_new_timelimit();

  14        $display_limit = zen_get_new_date_range();
  15    $random_whats_new_sidebox_product_query = "select p.products_id, p.products_image, p.products_tax_class_id, p.products_price
  16                             from " . TABLE_PRODUCTS . " p
  17                             where p.products_status = 1 " . $display_limit . "
  18                             limit " . MAX_RANDOM_SELECT_NEW;
  19  
  20    $random_whats_new_sidebox_product = zen_random_select($random_whats_new_sidebox_product_query);
  21  
  22    if ($random_whats_new_sidebox_product->RecordCount() > 0 ) {
  23      $whats_new_price = zen_get_products_display_price($random_whats_new_sidebox_product->fields['products_id']);
  24      $random_whats_new_sidebox_product->fields['products_name'] = zen_get_products_name($random_whats_new_sidebox_product->fields['products_id']);
  25      $random_whats_new_sidebox_product->fields['specials_new_products_price'] = zen_get_products_special_price($random_whats_new_sidebox_product->fields['products_id']);
  26      require($template->get_template_dir('tpl_whats_new.php',DIR_WS_TEMPLATE, $current_page_base,'sideboxes'). '/tpl_whats_new.php');
  27      $title =  BOX_HEADING_WHATS_NEW;
  28      $title_link = FILENAME_PRODUCTS_NEW;
  29      require($template->get_template_dir($column_box_default, DIR_WS_TEMPLATE, $current_page_base,'common') . '/' . $column_box_default);
  30    }
  31  ?>