viewproduct.php

这个版本只是修正了一些BUG

<?php
/***********************************************
    	viewproduct.php - 商品显示程序

	Version  : 1.2
	Author   : Tracemouse ([e-mail])
	Copyright: www.vitci.com
	Writed   : 2003/08/08
	Modified : 2004/04/13
***********************************************/

require "./include/base.php";
require "./include/code.php";
require "./include/catalog.php";

if (!$productid) 	$productid=0;
else				$productid=intval($productid);

$query = $db->query("select * from $table_products where productid=$productid");
if($product = $db->fetch_array($query))
{
	$product['img']=empty($product['smallimg'])?IMGDIR."/noimg.gif":$product['smallimg'];
	$paraid=$product['paraid'];
	$sortid=$product['sortid'];
	$product['save']=$product['marketprice'] - $product['ourprice'];
	$product['save']=number_format($product['save'], 2);
	$product['notes']=postify($product['notes']);
    $product['posttime']=gmdate($dateformat." ".$timeformat,$product['posttime']);
    $product['edittime']=gmdate($dateformat." ".$timeformat,$product['edittime']);
    $poster=$product['poster'];	
}
else
	showmessage('product not found');

/*
$sqlstr="select a.sortid,a.sortname,a.class,a.supsortid,a.largesortid,b.sortname as supsortname,c.sortname as largesortname
 		 from $table_sorts a,$table_sorts b,$table_sorts c where a.sortid=$sortid and a.supsortid=b.sortid and a.largesortid=c.sortid";

$query=$db->query($sqlstr);
while($dbq_rec=$db->fetch_array($query))
{
	$sort[sortname]=$dbq_rec['sortname'];
    	$sort[supsortname]=$dbq_rec['supsortname'];
    	$sort[largesortname]=$dbq_rec['largesortname'];
	$sort['class']=$dbq_rec['class'];
    	$sort[supsortid]=$dbq_rec['supsortid'];
}
*/
$sqlstr="select * from $table_sorts where sortid=$sortid";
$query=$db->query($sqlstr,1);
if($sort=$db->fetch_array($query))
{
    	if($sort['class'] == 'group') 	
    	{
    		$nav .= SEPARATER."<a href='catalog.php?sortid=$sort[sortid]'>".$sort[sortname]."</a>";
    	}
    	elseif($sort['class']=='sort')
    	{ 	
    		$sqlstr="select * from $table_sorts where sortid=$sort[supsortid]";
    		$query=$db->query($sqlstr,1);
    		$dbq_rec=$db->fetch_array($query);
    		$sort[groupid]=$dbq_rec[sortid];
    		$sort[group]=$dbq_rec[sortname];
    		$nav .= SEPARATER."<a href='catalog.php?sortid=$sort[groupid]'>".$sort[group]."</a>";
    		$nav .= SEPARATER."<a href='productdisplay.php?sortid=$sort[sortid]'>".$sort[sortname]."</a>";   		  		
    	}
    	elseif($sort['class']=='sub')
    	{
    		$sort[subid]=$sort[sortid];
    		$sort[sub]=$sort[sortname];
    		$sqlstr="select * from $table_sorts where sortid=$sort[supsortid]";
    		$query=$db->query($sqlstr,1);
    		$dbq_rec=$db->fetch_array($query);
    		$sort[sortid]=$dbq_rec[sortid];
    		$sort[sort]=$dbq_rec[sortname];
    		$sqlstr="select * from $table_sorts where sortid=$dbq_rec[supsortid]";
    		$query=$db->query($sqlstr,1);
    		$dbq_rec=$db->fetch_array($query);
    		$sort[groupid]=$dbq_rec[sortid];
    		$sort[group]=$dbq_rec[sortname];
    		$nav .= SEPARATER."<a href='catalog.php?sortid=$sort[groupid]'>".$sort[group]."</a>";
    		$nav .= SEPARATER."<a href='productdisplay.php?sortid=$sort[sortid]'>".$sort[sort]."</a>";   		  		
		$nav .= SEPARATER."<a href='productdisplay.php?sortid=$sort[subid]'>".$sort[sub]."</a>";   		  		
    	}
}
$nav .= SEPARATER.$product['productname'];

$query = $db->query("SELECT * FROM $table_parameters WHERE paraid=$paraid");
if($dbq_rec = $db->fetch_array($query))
{
 	//$PARA_TPLFILE=$dbq_rec['tplfile'];
 	if ($paraid==1) 	$isviewpara=0;
 	else 				$isviewpara = 1;
}
else
{
 	$isviewpara =0;
}

if ($isviewpara)
{
 	$paralist=array();
 	$sqlstr="select a.varhint,a.remarks,b.varname,b.value from $table_paravars a,$table_paravals b
  			where a.paraid=b.paraid and b.productid=$productid and b.paraid=$paraid and a.varname = b.varname ORDER BY a.sid";
 	$query = $db->query($sqlstr);
    	while($dbq_rec = $db->fetch_array($query))
 	{
   		$paralist[]=$dbq_rec;
 	}
}
//访问次数
$query = $db->query("UPDATE $table_products SET viewtimes=viewtimes+1 WHERE productid=$productid");

//取用户评论
$query=$db->query("SELECT COUNT(*) FROM $table_review WHERE pid=$productid");
$reviewnum=$db->result($query,0);
$reviewlist=array();
$query=$db->query("SELECT * FROM $table_review WHERE pid=$productid ORDER BY rid");
while($dbq_rec=$db->fetch_array($query))
{
	$dbq_rec['time'] = gmdate($dateformat,$dbq_rec['posttime']);
	$reviewlist[]=$dbq_rec;
}

//取同类商品
$kinproductlist=array();
$kinproductnum=0;
$query = $db->query("SELECT * FROM $table_products WHERE sortid=$sortid and productid <> $productid ORDER BY posttime LIMIT 0,10");
while($dbq_rec = $db->fetch_array($query))
{
	$kinproductnum++;
	$kinproductlist[]=$dbq_rec;
}

$sortselect=getsortselect();

include template('viewproduct');
?>