📄 show_detail.php
字号:
<?
include_once("inc/auth.php");
include_once("inc/utility_all.php");
?>
<html>
<head>
<title>采购订单详细信息</title>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
</head>
<body class="bodycolor" topmargin="5">
<table border="0" width="100%" cellspacing="0" cellpadding="3" class="small">
<tr>
<td class="Big"><img src="/images/notify_new.gif" align="absmiddle"><span class="big3"> 采购订单详细信息</span>
</td>
</tr>
</table>
<br>
<?
if($ORDER_ID!="")
{
$query="select * from SUPPLY_ORDER where ORDER_ID='$ORDER_ID'";
$cursor= exequery($connection,$query);
if($ROW=mysql_fetch_array($cursor))
{
$ORDER_NO1=$ROW["ORDER_NO"];
$ORDER_NAME1=$ROW["ORDER_NAME"];
$ORDER_TYPE1=$ROW["ORDER_TYPE"];
$ORDER_MEMO1=$ROW["ORDER_MEMO"];
$PROVIDER_ID1=$ROW["PROVIDER_ID"];
$LINKMAN_ID1=$ROW["LINKMAN_ID"];
$CREATOR1=$ROW["CREATOR"];
$RECIVER1=$ROW["RECIVER"];
$CREATE_DATE1=$ROW["CREATE_DATE"];
$BEGIN_DATE1=$ROW["BEGIN_DATE"];
$ORDER_PRINT1=$ROW["ORDER_PRINT"];
$REMARK1=$ROW["REMARK"];
$USERDEF11=$ROW["USERDEF1"];
$USERDEF21=$ROW["USERDEF2"];
$USERDEF31=$ROW["USERDEF3"];
$USERDEF41=$ROW["USERDEF4"];
$USERDEF51=$ROW["USERDEF5"];
}
$query2="select PROVIDER_NAME from PROVIDER where PROVIDER_ID='$PROVIDER_ID1'";
$cursor2 = exequery($connection, $query2);
if($ROW=mysql_fetch_array($cursor2))
$PROVIDER_NAME1=$ROW["PROVIDER_NAME"];
$query2="select USER_NAME from USER where USER_ID='$CREATOR1'";
$cursor2 = exequery($connection, $query2);
if($ROW=mysql_fetch_array($cursor2))
$CREATOR_NAME1=$ROW["USER_NAME"];
$query2="select USER_NAME from USER where USER_ID='$RECIVER1'";
$cursor2 = exequery($connection, $query2);
if($ROW=mysql_fetch_array($cursor2))
$RECIVER_NAME1=$ROW["USER_NAME"];
}
?>
<table border="0" cellspacing="1" width="650" class="small" bgcolor="#000000" cellpadding="3" align="center" >
<form action="add.php" enctype="multipart/form-data" method="post" name="form1" onsubmit="return CheckForm();">
<tr>
<td nowrap class="TableHeader" colspan="4" align="left">
采购订单基本信息：
</td>
</tr>
<tr>
<td nowrap class="TableData">供应商名称： </td>
<td class="TableData">
<?=$PROVIDER_NAME1?>
</td>
<td nowrap class="TableData">订单编号： </td>
<td nowrap class="TableData">
<?=$ORDER_NO1?>
</td>
</tr>
<tr>
<td nowrap class="TableData">订单类型： </td>
<td nowrap class="TableData">
<?
GETALLDATE("ORDER_TYPE",$ORDER_TYPE1);
?>
</td>
<td nowrap class="TableData">订单打印样式： </td>
<td nowrap class="TableData">
电子产品采购订单
</td>
</tr>
<tr>
<td nowrap class="TableData">订单名称： </td>
<td nowrap class="TableData" colspan="3">
<?=$ORDER_NAME1?>
</td>
</tr>
<tr>
<td nowrap class="TableData">订单描述： </td>
<td nowrap class="TableData" colspan="3">
<?=$ORDER_MEMO1?>
</td>
</tr>
<tr>
<td nowrap class="TableData">创建日期：</td>
<td nowrap class="TableData">
<?=$CREATE_DATE1?>
</td>
<td nowrap class="TableData">来货日期： </td>
<td nowrap class="TableData">
<?=$BEGIN_DATE1?>
</td>
</tr>
<tr>
<td nowrap class="TableData">创建人： </td>
<td nowrap class="TableData">
<?=$SELLER1_NAME?>
</td>
<td nowrap class="TableData">负责人： </td>
<td nowrap class="TableData">
<?=$RECIVER_NAME1?>
</td>
</tr>
<tr>
<td nowrap class="TableData">备注： </td>
<td nowrap class="TableData" colspan="3">
<?=$REMARK1?>
</td>
</tr>
<tr>
<td class="TableData" colspan="8">
<?=get_field_table(get_field_text("SUPPLY_ORDER", $ORDER_ID))?>
</td>
</tr>
<tr>
<td nowrap class="TableHeader" colspan="4" align="left">
订单明细：
</td>
</tr>
<tr>
<td nowrap class="TableData" colspan="4" align="center">
<br>
<table border="0" cellspacing="1" width="95%" class="small" bgcolor="#000000" cellpadding="3">
<tr class="TableHeader">
<td nowrap align="center">产品名称</td>
<td nowrap align="center">产品编码</td>
<td nowrap align="center">产品型号</td>
<td nowrap align="center">单价</td>
<td nowrap align="center">交付数量</td>
<td nowrap align="center">单位</td>
<td nowrap align="center">总价</td>
</tr>
<?
$query = "SELECT a.LINE_ID as LINE_ID,b.PRODUCT_ID as PRODUCT_ID,b.PRODUCT_NAME as PRODUCT_NAME,
a.TRANS_PRICE as TRANS_PRICE,b.MEASURE_UNIT,
a.TRANS_QTY as TRANS_QTY,a.PAYMENT as PAYMENT,a.MEMO as MEMO,
b.PRODUCT_CODE as PRODUCT_CODE,a.TRANS_PRICE*a.TRANS_QTY as TOTALPRICE,b.PRODUCT_TYPE as PRODUCT_TYPE
from ORDER_LINE a
LEFT OUTER JOIN PRODUCT b ON a.PRODUCT_ID = b.PRODUCT_ID
where a.ORDER_ID='$ORDER_ID' order by a.LINE_ID desc ";
$cursor= exequery($connection,$query);
$VOTE_COUNT=0;
$SUM_TRANS_QTY=0;
$SUM_TOTAL_PRICE=0;
while($ROW=mysql_fetch_array($cursor))
{
$VOTE_COUNT++;
$LINE_ID=$ROW["LINE_ID"];
$PRODUCT_ID=$ROW["PRODUCT_ID"];
$PRODUCT_NAME=$ROW["PRODUCT_NAME"];
$TRANS_PRICE=$ROW["TRANS_PRICE"];
$TRANS_QTY=$ROW["TRANS_QTY"];
$PAYMENT=$ROW["PAYMENT"];
$MEMO=$ROW["MEMO"];
$PRODUCT_TYPE=$ROW["PRODUCT_TYPE"];
$PRODUCT_CODE=$ROW["PRODUCT_CODE"];
$TOTAL_PRICE=$ROW["TOTALPRICE"];
$MEASURE_UNIT=$ROW["MEASURE_UNIT"];
$SUM_TRANS_QTY=$SUM_TRANS_QTY+$TRANS_QTY;
$SUM_TOTAL_PRICE=$SUM_TOTAL_PRICE+$TOTAL_PRICE;
if($VOTE_COUNT%2==1)
$TableLine="TableLine1";
else
$TableLine="TableLine2";
?>
<tr class="<?=$TableLine?>">
<td nowrap align="center"><?=$PRODUCT_NAME?></td>
<td align="center"><?=$PRODUCT_CODE?></td>
<td align="center"><?=$PRODUCT_TYPE?></td>
<td align="center"><?=$TRANS_PRICE?></td>
<td nowrap align="center"><?=$TRANS_QTY?></td>
<td nowrap align="center"><?=$MEASURE_UNIT?></td>
<td nowrap align="center"><?=$TOTAL_PRICE?></td>
</tr>
<?
}
?>
</table>
<br>
</td>
</tr>
<tr>
<td nowrap class="TableHeader" colspan="4" align="left">
接货记录：
</td>
</tr>
<tr>
<td nowrap class="TableData" colspan="4" align="center">
<?
//============================显示接货记录=======================================
$query = "SELECT a.LINE_ID as LINE_ID,a.PRODUCT_ID as PRODUCT_ID,b.PRODUCT_NAME as PRODUCT_NAME,b.MEASURE_UNIT,
a.PRICE as TRANS_PRICE,b.PRODUCT_TYPE as PRODUCT_TYPE,b.PRODUCT_CODE as PRODUCT_CODE,
a.AMT as TRANS_QTY, (a.PRICE*a.AMT) as TOTAL_PRICE,a.DATE as TRANS_DATE,f.USER_NAME as SELLER,g.PROVIDER_NAME as PROVIDER_NAME,a.HISTORY_ID as HISTORY_ID
from SUPPLY_HISTORY a
LEFT OUTER JOIN PRODUCT b ON a.PRODUCT_ID = b.PRODUCT_ID
LEFT OUTER JOIN ORDER_LINE d ON a.LINE_ID = d.LINE_ID
LEFT OUTER JOIN SUPPLY_ORDER e ON d.ORDER_ID = e.ORDER_ID
LEFT OUTER JOIN USER f ON a.SALESMAN=f.USER_ID
LEFT OUTER JOIN PROVIDER g ON a.PROVIDER_ID=g.PROVIDER_ID
where a.ORDER_ID='$ORDER_ID' order by HISTORY_ID desc";
$cursor= exequery($connection,$query);
$VOTE_COUNT=0;
while($ROW=mysql_fetch_array($cursor))
{
$VOTE_COUNT++;
$LINE_ID=$ROW["LINE_ID"];
$PRODUCT_ID=$ROW["PRODUCT_ID"];
$PRODUCT_NAME=$ROW["PRODUCT_NAME"];
$TRANS_PRICE=$ROW["TRANS_PRICE"];
$TRANS_QTY=$ROW["TRANS_QTY"];
$TOTAL_PRICE =$ROW["TOTAL_PRICE"];
$TRANS_DATE =$ROW["TRANS_DATE"];
$SELLER =$ROW["SELLER"];
$PROVIDER_NAME =$ROW["PROVIDER_NAME"];
$MEMO=$ROW["MEMO"];
$PRODUCT_TYPE=$ROW["PRODUCT_TYPE"];
$PRODUCT_CODE=$ROW["PRODUCT_CODE"];
$HISTORY_ID=$ROW["HISTORY_ID"];
$MEASURE_UNIT=$ROW["MEASURE_UNIT"];
if($VOTE_COUNT==1)
{
?>
<br>
<table border="0" cellspacing="1" width="95%" class="small" bgcolor="#000000" cellpadding="3">
<tr class="TableHeader">
<td nowrap align="center">产品名称</td>
<td nowrap align="center">产品编码</td>
<td nowrap align="center">产品型号</td>
<td nowrap align="center">单价</td>
<td nowrap align="center">交付数量</td>
<td nowrap align="center">单位</td>
<td nowrap align="center">总价</td>
<td nowrap align="center">交付日期</td>
<td nowrap align="center">接货员</td>
</tr>
<?
}
if($VOTE_COUNT%2==1)
$TableLine="TableLine1";
else
$TableLine="TableLine2";
?>
<tr class="<?=$TableLine?>">
<td nowrap align="center"><?=$PRODUCT_NAME?></td>
<td align="center"><?=$PRODUCT_CODE?></td>
<td align="center"><?=$PRODUCT_TYPE?></td>
<td align="center"><?=$TRANS_PRICE?></td>
<td nowrap align="center"><?=$TRANS_QTY?></td>
<td nowrap align="center"><?=$MEASURE_UNIT?></td>
<td nowrap align="center"><?=$TOTAL_PRICE?></td>
<td nowrap align="center"><?=$TRANS_DATE?></td>
<td nowrap align="center"><?=$SELLER?></td>
</tr>
<?
}
?>
</table>
<br>
</td>
</tr>
</table>
<br>
<div align="center">
<input type="button" value="关闭" class="SmallButton" onclick="window.close()">
</div>
</body>
</html>
<?
function GETALLDATE($CODE,$GETVALUE)
{
global $connection;
$query = "SELECT * from SYS_CODE where PARENT_NO='$CODE'";
$connection=OpenConnection();
$cursor= exequery($connection,$query);
while($ROW=mysql_fetch_array($cursor))
{
$CODE_NO=$ROW["CODE_NO"];
$CODE_NAME=$ROW["CODE_NAME"];
if ($CODE_NO==$GETVALUE)
{
echo $CODE_NAME;
}
}
}
?>⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -