specials_products.php

来自「全新且完善的强大网上商店系统」· PHP 代码 · 共 39 行

<?php
/*
  [SOOBIC!]

	Version: 1.5
	Author: Soolan ([e-mail])
	Copyright: soolan (www.soobic.com)
	Last Modified: 2005/4/1 10:00

*/



if( tep_not_null(MAX_INDEX_SPECIALS_NUM_A_ROW) && is_numeric(MAX_INDEX_SPECIALS_NUM_A_ROW) && MAX_INDEX_SPECIALS_NUM_A_ROW!='0' && tep_not_null(MAX_INDEX_SPECIALS_NUM_OF_ROW) && is_numeric(MAX_INDEX_SPECIALS_NUM_OF_ROW) && MAX_INDEX_SPECIALS_NUM_OF_ROW!='0'){
    $total=MAX_INDEX_SPECIALS_NUM_A_ROW * MAX_INDEX_SPECIALS_NUM_OF_ROW;
		
		$query = $db->query("select p.products_id, p.products_price, p.products_tax_class_id, p.products_image, s.specials_new_products_price from $table_products p, $table_products_description pd, $table_specials s where p.products_status = '1' and p.products_id = s.products_id and pd.products_id = s.products_id and pd.language_id = '" . (int)$languages_id . "' and s.status = '1' order by s.specials_date_added desc limit $total");
		$show_specials=true;
		$key=0;
    $key_t=0;
		while ($specials_products = $db->fetch_array($query)) {
        $product_query = $db->query("select products_name from $table_products_description where products_id = '" . (int)$specials_products['products_id']. "' and language_id = '" . (int)$languages_id. "'");
        @extract($db->fetch_array($product_query));
		    $specials_products_list[$key_t][0][]='<a href="' . tep_href_link('product_info.php', 'products_id=' . $specials_products['products_id']) . '">'.tep_image('upload/images/products/small_'.$specials_products['products_image'],$products_name,SMALL_IMAGE_WIDTH,SMALL_IMAGE_HEIGHT).'</a>';
		    $specials_products_list[$key_t][1][]='<a href="' . tep_href_link('product_info.php', 'products_id=' . $specials_products['products_id']) . '">' . $products_name. '</a>';
		    $specials_products_list[$key_t][2][]=TEXT_PRICE.$currencies->display_price($specials_products['products_price'], tep_get_tax_rate($specials_products['products_tax_class_id']));
				$specials_products_list[$key_t][3][]=TEXT_PRICE_SPECIALS.$currencies->display_price($specials_products['specials_new_products_price'], tep_get_tax_rate($specials_products['products_tax_class_id']));
		    $key_t= !(++$key % MAX_INDEX_SPECIALS_NUM_A_ROW) ? ++$key_t : $key_t;
		}
    if($specials_products_list){
		    include template("modules_specials_products");
		}
}



?>