adm_product.php

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

<?php
/************************************************
	adm_product.php -

	Version  : 1.2
	Author   : Tracemouse ([e-mail])
	Copyright: http://www.vitci.com
	Writed   : 2003/10/20
	Modified : 2003/04/18
*************************************************/
require "./common.php";
require "../include/catalog.php";
require "../include/multi.php";
$file_name='./adm_product.php';

if ((!$editsubmit)&&(!$searchsubmit))     //未发送表单
{
	if ($action == 'chg')
    	{           //修改页面
		$query = $db->query("select * from $table_products where productid=$productid");
 		if($dbq_rec = $db->fetch_array($query))
        	{
    			$productname = $dbq_rec['productname']; 
    			$sortid = $dbq_rec['sortid']; 
    			$postdate = $dbq_rec['postdate'];
    			$unit = $dbq_rec['unit'];
    			$ourprice = $dbq_rec['ourprice']; $marketprice = $dbq_rec['marketprice']; $finalprice=$dbq_rec['finalprice'];
    			$smallimg=$dbq_rec['smallimg'];$largeimg=$dbq_rec['largeimg'];$subject=$dbq_rec['subject'];
    			$notes=$dbq_rec['notes'];
    			$paraid=$dbq_rec['paraid'];
  		}
 		$query = $db->query("SELECT paraid,paraname FROM $table_parameters");
 		$para_select = "<select size=1 name=paraid>";
 		$isselected='';
 		while($dbq_rec = $db->fetch_array($query))
        	{
   			$isselected = ($dbq_rec['paraid'] == $paraid)?"selected":"";
   			$para_select = $para_select."<option ".$isselected." value=".$dbq_rec['paraid'].">".$dbq_rec['paraname']."</option>";
 		}
 		$para_select = $para_select."</select>";
 		$sort_select = getsortselect($sortid);
 		$display = 'edit';
	}
    	elseif ($action == 'del')
    	{
    		$sqlstr="DELETE FROM $table_products WHERE productid = $productid";
        	if(!($query=$db->query($sqlstr,1)))
    			gotourl($language['db_err'].":<br>".$sqlstr);

        	$sqlstr = "DELETE FROM $table_paravals WHERE productid=$productid";
        	if($query = $db->query($sqlstr,1))
        		gotourl($language['delsuccess'],$file_name);
        	else
        		gotourl($language['db_err'].":<br>".$sqlstr);
    	}
    	else  // 查询页面
	{
        	$sortselect=getsortselect(0);
        	$display = 'search';
	}
}
elseif ($editsubmit)        //发送表单处理
{
    	if(empty($productname))
    		gotourl($language['alt_null_keyword']);
    	if(($ourprice <= 0)||($marketprice <= 0))
    		gotourl($language['alt_num_price']);

  	$sqlstr="UPDATE $table_products SET  productname='$productname',sortid=$sel_sortid,
    			posttime=$timestamp,unit='$unit',ourprice=$ourprice,marketprice=$marketprice,
    			smallimg='$smallimg',largeimg='$largeimg',notes='$Post',paraid=$paraid
    			WHERE productid = $productid";
    	if(!($query=$db->query($sqlstr,1)))
    		gotourl($language['db_err'].":<br>".$sqlstr);
    	if(($oldparaid != $paraid)||($oldparaid > 1))
    	{
        	$sqlstr = "DELETE FROM $table_paravals WHERE productid=$productid AND paraid = $oldparaid";

    		if(!($query = $db->query($sqlstr,1)))
        		gotourl($language['db_err'].":<br>".$sqlstr);
	}
    	if ($paraid > 1)
   		gotourl($language['editsuccess'],'./adm_addpara.php?productid='.$productid);
  	else
   		gotourl($language['editsuccess'],'./adm_product.php?searchsubmit=act&productname='.$productname);

}
elseif ($searchsubmit)
{      
	/*
	$sqlstr="select a.productid,a.productname,a.sortid,a.posttime,a.unit,
                      a.ourprice,a.marketprice,a.smallimg,a.largeimg,
                      a.notes,a.paraid,b.sortname
                      from $table_products a,$table_sorts b
                      where a.sortid = b.sortid ";
	*/
	$condition="where a.sortid = b.sortid ";
    	$condition=(empty($productid))?$condition."and a.productname like '%$srh_productname%'":$condition."and  a.productid = $productid";
    	$condition=($srh_sortid == 0)?$condition:$condition." and a.sortid = $srh_sortid";
    	
    	$query = $db->query("SELECT COUNT(*) FROM $table_products a,$table_sorts b $condition");
	$count=$db->result($query,0);
	$perpage=15;
	if ($count <= $perpage)
	{
		$maxpage=1;
	}
	else
	{
   		$maxpage=($count - ($count % $perpage))/$perpage;
   		$maxpage=$maxpage+1;
	}

	if(!empty($page))
	{
		$start_limit=($page-1) * $perpage;
		$startnum = ($page-1) * $perpage + 1;
		$endnum = $page * $perpage;
	}
	else
	{
		$startnum = 1;
		$endnum = $perpage;
		$start_limit=0;
		$page = 1;
	}

	$multipage = multi($count, $perpage, $page, "adm_product.php?searchsubmit=yes&srh_productname=$srh_productname&srh_sortid=$srh_sortid&productid=$productid");
	    	
    	$sqlstr="select a.productid,a.productname,a.sortid,a.posttime,a.unit,
                      a.ourprice,a.marketprice,a.smallimg,a.largeimg,
                      a.notes,a.paraid,b.sortname
                      from $table_products a,$table_sorts b ".$condition." LIMIT $start_limit,$perpage";
    
    	$reclist = array();
 	$query = $db->query($sqlstr,1);
 	while($dbq_result = $db->fetch_array($query))
 	{
   		$productid=$dbq_result['productid'];
   		$dbq_result['para']=($dbq_result['paraid']>1)?'[<a href=\'./adm_addpara.php?productid='.$productid.'\' target=_self>'.$language['edit'].'</a>]':'';
   		$dbq_result['postdate'] = gmdate($dateformat,$dbq_result['posttime']);
   		$reclist[] = $dbq_result;
  	}
  	$display = 'list';
}

include template('product');
?>