📄 showdetail.php
字号:
<?
include_once("inc/auth.php");
include_once("inc/check_type.php");
?>
<html>
<head>
<title>销售记录详细信息 </title>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
</head>
<?
$query = "SELECT a.CUSTOMER_ID as CUSTOMER_ID,a.PRODUCT_ID as PRODUCT_ID,c.PRODUCT_NAME as PRODUCT_NAME,a.SERVICE_ID as SERVICE_ID,
d.SERVICE_NAME as SERVICE_NAME,a.TYPE as TYPE,a.DATE as DATE,a.PRICE as PRICE,a.AMT as AMT,a.TOTAL_PRICE as TOTAL_PRICE,a.SALESMAN as SELLER,
e.USER_NAME as SELLER_NAME,b.CUSTOMER_NAME as CUSTOMER_NAME,a.MEMO as MEMO,a.MEMO1 as MEMO1 from SALE_HISTORY a
LEFT OUTER JOIN CUSTOMER b ON a.CUSTOMER_ID=b.CUSTOMER_ID
LEFT OUTER JOIN PRODUCT c ON a.PRODUCT_ID=c.PRODUCT_ID and a.TYPE='PRO'
LEFT OUTER JOIN SERVICE d ON a.SERVICE_ID=d.SERVICE_ID and a.TYPE='SER'
LEFT OUTER JOIN USER e ON a.SALESMAN=e.USER_ID"." where HISTORY_ID='$HISTORY_ID'";
$cursor= exequery($connection,$query);
if($ROW=mysql_fetch_array($cursor))
{
$CUSTOMER_ID1=$ROW["CUSTOMER_ID"];
$PRODUCT_ID1=$ROW["PRODUCT_ID"];
$PRODUCT_NAME1=$ROW["PRODUCT_NAME"];
$SERVICE_ID1=$ROW["SERVICE_ID"];
$SERVICE_NAME1=$ROW["SERVICE_NAME"];
$TYPE1=$ROW["TYPE"];
$CREATE_DATE=$ROW["DATE"];
$PRICE1=$ROW["PRICE"];
$AMT1=$ROW["AMT"];
$TOTAL_PRICE1=$ROW["TOTAL_PRICE"];
$SELLER1=$ROW["SELLER"];
$SELLER_NAME1=$ROW["SELLER_NAME"];
$CUSTOMER_NAME1=$ROW["CUSTOMER_NAME"];
$MEMO1=$ROW["MEMO"];
$MEMO2=$ROW["MEMO1"];
}
?>
<body class="bodycolor" topmargin="5">
<table border="0" width="100%" cellspacing="0" cellpadding="3" class="small">
<tr>
<td class="Big"><img src="/images/menu/histroy.gif" WIDTH="22" HEIGHT="20" align="absmiddle"><span class="big3"> 销售记录详细信息 </span>
</td>
</tr>
</table>
<br>
<table border="0" width="80%" cellpadding="2" cellspacing="1" align="center" bgcolor="#000000" class="small">
<form enctype="multipart/form-data" action="update.php" method="post" name="form1">
<tr id="PRO" style=<? if($TYPE1=="PRO"){ echo "";}
else{echo "display:none";}?> >
<td nowrap class="TableData">产品：</td>
<td class="TableData"><?=$PRODUCT_NAME1?></td>
</tr>
<tr id="SER" style=<? if($TYPE1=="SER"){ echo "";}
else{echo "display:none";}?>>
<td nowrap class="TableData">服务：</td>
<td class="TableData"><?=$SERVICE_NAME1?></td>
</tr>
<tr id="PRI" style=<? if($TYPE1=="PRO"){ echo "";}
else{echo "display:none";}?>>
<td nowrap class="TableData">单价：</td>
<td class="TableData"><?=$PRICE1?></td>
</tr>
<tr id="QTY" style=<? if($TYPE1=="PRO"){ echo "";}
else{echo "display:none";}?>>
<td nowrap class="TableData">数量：</td>
<td class="TableData"><?=$AMT1?></td>
</tr>
<tr id="TOTALPRICE" style=<? if($TYPE1=="SER"){ echo "";}
else{echo "display:none";}?> >
<td nowrap class="TableData">总价：</td>
<td class="TableData"><?=$TOTAL_PRICE1?></td>
</tr>
<tr>
<td nowrap class="TableData">客户名称： </td>
<td class="TableData"><?=$CUSTOMER_NAME1?></td>
</tr>
<tr>
<td nowrap class="TableData">记录日期：</td>
<td class="TableData"><?=$CREATE_DATE?></td>
</tr>
<tr>
<td nowrap class="TableData">销售员：</td>
<td class="TableData"><?=$SELLER_NAME1?></td>
</tr>
<tr>
<td nowrap class="TableData" width="20%">备注：</td>
<td class="TableData"><?=$MEMO1?></td>
</tr>
<tr>
<td nowrap class="TableControl" colspan="4" align="center">
<input type="button" value="关闭" class="SmallButton" onclick="window.close()">
</td>
</tr>
</form>
</table>
</body>
</html>⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -