shop/order2.php
复制自order.php
<?php
require_once("global.php");
if(!$lfjuid)
{
showerr("你还没有登录");
}if($page<1)
{
$page=1;
}
$rows=20;
$min=($page-1)*$rows;
if($job=='sell')
{
$SQL=" WHERE A.uid='$lfjuid' ";
}
else
{
$SQL=" WHERE B.shopuid='$lfjuid' ";
}$showpage=getpage("{$pre}shop_orderuser A LEFT JOIN {$pre}shop_orderproduct B ON A.id=B.orderid","$SQL","?job=$job","");
$query = $db->query("SELECT A.*,B.* FROM {$pre}shop_orderuser A LEFT JOIN {$pre}shop_orderproduct B ON A.id=B.orderid $SQL ORDER BY A.id DESC LIMIT $min,$rows");
while($rs = $db->fetch_array($query))
{
$rs[ifsend]=$rs[ifsend]?"<A HREF='?lfj=$lfj&action=send&pid=$rs[pid]&jobs=0' style='color:blue;'>已发货</A>":"<A HREF='?lfj=$lfj&action=send&pid=$rs[pid]&jobs=1' style='color:red;'>未发货</A>";
$rs[posttime]=date("Y-m-d H:i:s",$rs[posttime]);
$listdb[$rs[id]]=$rs;
}
require("head.php");
require(getTpl("order"));if($action=='del')
{
$rs=$db->get_one("SELECT A.*,B.* FROM {$pre}shop_orderuser A LEFT JOIN {$pre}shop_orderproduct B ON A.id=B.orderid WHERE B.pid='$pid'");
if(!$web_admin&&$rs[uid]!=$lfjuid&&$rs[shopuid]!=$lfjuid){
showerr("你无权操作");
}
$db->query("DELETE FROM {$pre}shop_orderproduct WHERE pid='$pid'");
$rs2=$db->get_one("SELECT A.*,B.* FROM {$pre}shop_orderuser A LEFT JOIN {$pre}shop_orderproduct B ON A.id=B.orderid WHERE B.orderid='$rs[orderid]'");
if(!$rs2){
$db->query("DELETE FROM {$pre}shop_orderuser WHERE id='$rs[id]'");
}
}
elseif($action=="send")
{
$db->query("UPDATE {$pre}shop_orderproduct SET ifsend='$jobs' WHERE pid='$pid' ");
//echo "<META HTTP-EQUIV=REFRESH CONTENT='0;URL=$FROMURL'>";
header("location:$FROMURL");
exit;
}elseif($job=="view")
{
$rsdb=$db->get_one("SELECT * FROM {$pre}shop_orderuser WHERE id='$orderid'");
if(!$rsdb){
header("location:?lfj=$lfj&job=list");
}
$query = $db->query("SELECT A.*,B.* FROM {$pre}shop_orderproduct A LEFT JOIN {$pre}shop_product B ON A.shopid=B.id WHERE A.orderid='$orderid' ");
while($rs = $db->fetch_array($query)){
$rs[num]=$numdb[$rs[id]];
$listdb[$rs[id]]=$rs;
}
require(getTpl("show"));
}
require("foot.php");
?>[ 此贴被cgone在2007-11-24 11:21重新编辑 ]
