best_sellers.php

PHP 建站工具,CMS系统,类似与oscommerce

<?php
/* -----------------------------------------------------------------------------------------
   $Id: best_sellers.php,v 1.4 2004/03/25 08:31:41 oldpa Exp $   

   TWE-Commerce - community made shopping   
   http://www.oldpa.com.tw
   Copyright (c) 2003 TWE-Commerce
   -----------------------------------------------------------------------------------------
   based on: 
   (c) 2000-2001 The Exchange Project  (earlier name of osCommerce)
   (c) 2002-2003 osCommerce(best_sellers.php,v 1.20 2003/02/10); www.oscommerce.com 
   (c) 2003	 nextcommerce (best_sellers.php,v 1.10 2003/08/17); www.nextcommerce.org   
   (c) 2003	 xt-commerce  www.xt-commerce.com
   Released under the GNU General Public License 
-----------------------------------------------------------------------------------------
   Third Party contributions:
   Enable_Disable_Categories 1.3        	Autor: Mikel Williams | [e-mail]   (c) 2003	 xt-commerce  www.xt-commerce.com
   Released under the GNU General Public License 
---------------------------------------------------------------------------------------*/
// reset var
$box_smarty = new smarty;
$box_content='';
$box_smarty->assign('tpl_path','templates/'.CURRENT_TEMPLATE.'/'); 

  // include needed functions
  require_once(DIR_FS_INC . 'twe_row_number_format.inc.php');

      //fsk18 lock
  $fsk_lock='';
  if ($_SESSION['customers_status']['customers_fsk18_display']=='0') {
  $fsk_lock=' and p.products_fsk18!=1';
  }
    if (GROUP_CHECK=='true') {
   $group_check="and p.group_ids LIKE '%c_".$_SESSION['customers_status']['customers_status_id']."_group%'";
  }
  if (isset($current_category_id) && ($current_category_id > 0)) {
    $best_sellers_query = twe_db_query("select distinct
                                        p.products_id,
                                        p.products_image,
                                        pd.products_name from " .
                                        TABLE_PRODUCTS . " p, " .
                                        TABLE_PRODUCTS_DESCRIPTION . " pd, " .
                                        TABLE_PRODUCTS_TO_CATEGORIES . " p2c, " .
                                        TABLE_CATEGORIES . " c
                                        where p.products_status = '1'
                                        and c.categories_status = '1'
                                        and p.products_ordered > 0
                                        and p.products_id = pd.products_id
                                        and pd.language_id = '" . (int)$_SESSION['languages_id'] . "'
                                        and p.products_id = p2c.products_id ".$fsk_lock."
                                        ".$group_check."
                                        and p2c.categories_id = c.categories_id and '" . $current_category_id . "'
                                        in (c.categories_id, c.parent_id)
                                        order by p.products_ordered desc, pd.products_name limit " . MAX_DISPLAY_BESTSELLERS);
  } else {
    $best_sellers_query = twe_db_query("select distinct
                                        p.products_id,
                                        p.products_image,
                                        pd.products_name from " .
                                        TABLE_PRODUCTS . " p, " .
                                        TABLE_PRODUCTS_DESCRIPTION . " pd, " .
                                        TABLE_CATEGORIES . " c
                                        where p.products_status = '1'
                                        and c.categories_status = '1'
                                        ".$group_check."
                                        and p.products_ordered > 0
                                        and p.products_id = pd.products_id ".$fsk_lock."
                                        and pd.language_id = '" . (int)$_SESSION['languages_id'] . "'
                                        order by p.products_ordered desc,
                                        pd.products_name limit " . MAX_DISPLAY_BESTSELLERS);
  }
  if (twe_db_num_rows($best_sellers_query) >= MIN_DISPLAY_BESTSELLERS) {


    $rows = 0;
    $box_content=array();
    while ($best_sellers = twe_db_fetch_array($best_sellers_query)) {
      $rows++;
      $image='';
      if ($best_sellers['products_image']) $image=DIR_WS_INFO_IMAGES . $best_sellers['products_image'];
      $box_content[]=array(
                           'ID'=> twe_row_number_format($rows),
                           'NAME'=> $best_sellers['products_name'],
                           'IMAGE' => $image,
                           'PRICE'=>twe_get_products_price($best_sellers['products_id'],$price_special=1,$quantity=1),
                           'LINK'=> twe_href_link(FILENAME_PRODUCT_INFO, 'products_id=' . $best_sellers['products_id']));

    }



    $box_smarty->assign('box_content', $box_content);
 	$box_smarty->assign('language', $_SESSION['language']);
    	  // set cache ID
  if (USE_CACHE=='false') {
  $box_smarty->caching = 0;
  $box_best_sellers= $box_smarty->fetch(CURRENT_TEMPLATE.'/boxes/box_best_sellers.html');
  } else {
  $box_smarty->caching = 1;	
  $box_smarty->cache_lifetime=CACHE_LIFETIME;
  $box_smarty->cache_modified_check=CACHE_CHECK;
  $cache_id = $_SESSION['language'];
  $box_best_sellers= $box_smarty->fetch(CURRENT_TEMPLATE.'/boxes/box_best_sellers.html',$cache_id);
  }

    $smarty->assign('box_BESTSELLERS',$box_best_sellers);


  }
?>