?? order_sale_back.php
字號:
<?php
require(dirname(__FILE__)."/include/config_base.php");
require(dirname(__FILE__)."/include/config_rglobals.php");
?>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312" />
<link href="style/main.css" rel="stylesheet" type="text/css" />
</head>
<body oncontextmenu="return false">
<?php
if($action=='del'){
$dsql=New Dedesql(false);
$delstring="delete from #@__kcbackgys where id='$id'";
$dsql->executenonequery($delstring);
$dsql->close();
header("Location:current_order_back.php?action=normal&did=".$rid);
}
?>
<table width="100%" border="0" cellpadding="0" cellspacing="2">
<tr>
<td><strong> 客戶退貨詳細產品</strong></td>
</tr>
<form method="post" name="sel">
<tr>
<td bgcolor="#FFFFFF">
<?php
echo "<table width=\"100%\" cellspacing=\"0\" cellpadding=\"0\" border=\"0\" id=\"table_border\">";
$csql=New Dedesql(false);
if ($pid==''){//初始狀態
if($action=='normal')
$csql->SetQuery("select * from #@__saleback where rdh='$did'");
else
$csql->SetQuery("select * from #@__saleback where id<0");
}
else{
if($action=='' && $did!=''){
//寫入產品記錄
$wsql=New Dedesql(false);
$writesql="select * from #@__basic where cp_number='$pid'";
$wsql->Setquery($writesql);
$wsql->Execute();
$wrs=$wsql->GetOne();
$wsql->ExecuteNoneQuery("insert into #@__saleback(productid,number,rdh,dtime,r_text) values('".$pid."','".$num."','".$did."','".GetDateTimeMk(time())."','".$r_text."')");
$wsql->close();
}
$csql->SetQuery("select * from #@__saleback where rdh='$did'");
}
$csql->Execute();
$rowcount=$csql->GetTotalRow();
if($rowcount==0)
echo "<tr><td> </td></tr>";
else{
echo "<tr class='row_color_head'><td>貨號</td><td>名稱</td><td>規格</td><td>分類</td><td>單位</td><td>售價</td><td>退回原因<td>退回數量</td><td>刪除</tr>";
while($row=$csql->GetArray()){
$nsql=New dedesql(false);
$query1="select * from #@__basic where cp_number='".$row['productid']."'";
$nsql->setquery($query1);
$nsql->execute();
$row1=$nsql->getone();
$amoney+=$row1['cp_sale']*$row['number'];
$anum+=$row['number'];
echo "<tr onMouseMove=\"javascript:this.bgColor='#EBF1F6';\" onMouseOut=\"javascript:this.bgColor='#FFFFFF';\"><td>".$row['productid']."</td><td> ".$row1['cp_name']."</td><td>".$row1['cp_gg']."</td><td>".get_name($row1['cp_categories'],'categories').">".get_name($row1['cp_categories_down'],'categories')."</td><td>".get_name($row1['cp_dwname'],'dw')."</td><td>￥".$row1['cp_sale']."</td><td>".$row['r_text']."</td><td>".$row['number']."</td><td><a href='current_order_back.php?action=del&id=".$row['id']."&rid=".$row['rdh']."'>刪除</a></td></tr>";
$nsql->close();
}
}
echo "<tr><td> 共計:</td><td></td><td></td><td></td><td> 金額:</td><td>￥".$amoney."</td><td align='right'>數量:</td><td>".$anum."</td></tr></table>";
$csql->close();
?>
</td>
</tr></form>
</table>
</body>
</html>
?? 快捷鍵說明
復制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號
Ctrl + =
減小字號
Ctrl + -