new_products.php

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

<?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_PRODUCTS_NEW_NUM_A_ROW) && is_numeric(MAX_PRODUCTS_NEW_NUM_A_ROW) && MAX_PRODUCTS_NEW_A_ROW!='0' && tep_not_null(MAX_PRODUCTS_NEW_OF_ROW) && is_numeric(MAX_PRODUCTS_NEW_OF_ROW) && MAX_PRODUCTS_NEW_OF_ROW!='0'){
    $total=MAX_PRODUCTS_NEW_NUM_A_ROW * MAX_PRODUCTS_NEW_OF_ROW;
		if ( (!isset($new_products_category_id)) || ($new_products_category_id == '0') ) {
        $query = $db->query("select p.products_id, p.products_image, p.products_tax_class_id, s.specials_new_products_price as specials_price , s.status,  p.products_price  from $table_products p left join $table_specials s on p.products_id = s.products_id where products_status = '1' order by p.products_date_added desc limit $total");

    } else {
		    $query = $db->query("select distinct p.products_id, p.products_image, p.products_tax_class_id,  s.specials_new_products_price as specials_price ,s.status,  p.products_price from $table_products  p left join $table_specials s on p.products_id = s.products_id, $table_categories c where  p.categories_id = c.categories_id and c.parent_id = '" . (int)$new_products_category_id . "' and p.products_status = '1' order by p.products_date_added desc limit $total");
    }
    if($query){
        $show_new=true;
		    $key=0;
        $key_t=0;
	      while ($new_products = $db->fetch_array($query)) {
            $soobic_price='';    
			      $product_query = $db->query("select products_name from $table_products_description where products_id = '" . (int)$new_products['products_id']. "' and language_id = '" . (int)$languages_id. "'");
            @extract($db->fetch_array($product_query));
		        $new_products_list[$key_t][0][]='<a href="' . tep_href_link('product_info.php', 'products_id=' . $new_products['products_id']) . '">'.tep_image('upload/images/products/small_'. $new_products['products_image'],$products_name,SMALL_IMAGE_WIDTH,SMALL_IMAGE_HEIGHT).'</a>';
		        $new_products_list[$key_t][1][]='<a href="' . tep_href_link('product_info.php', 'products_id=' . $new_products['products_id']) . '">' . $products_name. '</a>';
		        $new_products_list[$key_t][2][]=TEXT_PRICE.$currencies->display_price($new_products['products_price'], tep_get_tax_rate($new_products['products_tax_class_id']));
				
				    if($customer_email && $groupdiscount>=1 && $groupdiscount<10 && MARK_OF_CUSTOMER_DISPLAYE=='True'){
                $groupdiscount= $groupdiscount<MARK_OF_CUSTOMER_BIG ? MARK_OF_CUSTOMER_BIG : $groupdiscount; 
								$final = $new_products['products_price'] + $cart->attributes_price($product_info['products_id']);
				        $soobic_price=TEXT_CUSTOMER_SPECIALS.$currencies->display_price($final*$groupdiscount/10, tep_get_tax_rate($new_products['products_tax_class_id']));
            }elseif(DEFAULT_DISCOUNT>0 && DEFAULT_DISCOUNT<10 && MARK_OF_CUSTOMER_DISPLAYE=='True'){
                $final = $new_products['products_price'] + $cart->attributes_price($product_info['products_id']);
								$soobic_price=TEXT_CUSTOMER_SPECIALS.$currencies->display_price($final*DEFAULT_DISCOUNT/10, tep_get_tax_rate($new_products['products_tax_class_id']));
            }
				      
				    if($new_products['specials_price']){
                $soobic_price=TEXT_PRICE_SPECIALS.$currencies->display_price($new_products['specials_price'], tep_get_tax_rate($product_info['products_tax_class_id']));
            }
				    $new_products_list[$key_t][3][]=($soobic_price) ? $soobic_price : '';
		        $key_t= !(++$key % MAX_PRODUCTS_NEW_NUM_A_ROW) ? ++$key_t : $key_t;
		   }
       include template("modules_new_products");
   } 
}


?>