📄 show_detail.php
字号:
<?
function getalldate ($CODE, $GETVALUE)
{
global $connection;
$query = (((''.'SELECT * from SYS_CODE where PARENT_NO=\'').$CODE).'\'');
$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;
continue;
}
}
}
include_once 'inc/auth.php';
include_once 'inc/utility_all.php';
echo '
<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">';
echo '<s';
echo 'pan 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'];
}
}
echo '<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>
';
echo ' <td class="TableData">
';
echo $PROVIDER_NAME1;
echo ' </td>
<td nowrap class="TableData">订单编号： </td>
<td nowrap class="TableData">
';
echo $ORDER_NO1;
echo ' </td>
</tr>
<tr>
<td nowrap class="TableData">订单类型： </td>
<td nowrap class="TableData">
';
getalldate ('ORDER_TYPE', $ORDER_TYPE1);
echo ' </td>
<td nowrap class="TableData">订单打印样式： </td>
<td nowrap class="TableData">
电子产品采购订单
</td>
</tr>
<tr>
<td nowrap class="TableData">订单名称： </td>
<td nowrap class="TableData" colspan="3">
';
echo $ORDER_NAME1;
echo ' </td>
</tr>
<tr>
<td nowrap class="TableData">订单描述： </td>
<td nowrap class="TableData" colspan="3">
';
echo $ORDER_MEMO1;
echo ' </td>
</tr>
<tr>
<td nowrap class="TableData">创建日期：</td>
<td nowrap class="TableData">
';
echo $CREATE_DATE1;
echo ' </td>
<td nowrap class="TableData">来货日期： </td>
<td nowrap class="TableData">
';
echo $BEGIN_DATE1;
echo ' </td>
</tr>
<tr>
<td nowrap class="TableData">创建人： </td>
<td nowrap class="TableData">
';
echo $SELLER1_NAME;
echo ' </td>
<td nowrap class="TableData">负责人： </td>
<td nowrap class="TableData">
';
echo $RECIVER_NAME1;
echo ' </td>
</tr>
<tr>
<td nowrap class="TableData">备注： </td>
<td nowrap class="TableData" colspan="3">
';
echo $REMARK1;
echo ' </td>
</tr>
<tr>
<td class="TableData" colspan="8">
';
echo get_field_table (get_field_text ('SUPPLY_ORDER', $ORDER_ID));
echo ' </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>
<t';
echo 'd 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';
}
echo ' <tr class="';
echo $TableLine;
echo '">
<td nowrap align="center">';
echo $PRODUCT_NAME;
echo '</td>
<td align="center">';
echo $PRODUCT_CODE;
echo '</td>
<td align="center">';
echo $PRODUCT_TYPE;
echo '</td>
<td align="center">';
echo $TRANS_PRICE;
echo '</td>
<td nowrap align="center">';
echo $TRANS_QTY;
echo '</td>
<td nowrap align="center">';
echo $MEASURE_UNIT;
echo '</td>
<td nowrap align="center">';
echo $TOTAL_PRICE;
echo '</td>
</tr>
';
}
echo '
</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))
{
echo ' <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>
';
echo ' <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';
}
echo ' <tr class="';
echo $TableLine;
echo '">
<td nowrap align="center">';
echo $PRODUCT_NAME;
echo '</td>
<td align="center">';
echo $PRODUCT_CODE;
echo '</td>
<td align="center">';
echo $PRODUCT_TYPE;
echo '</td>
<td align="center">';
echo $TRANS_PRICE;
echo '</td>
<td nowrap align="center">';
echo $TRANS_QTY;
echo '</td>
<td nowrap align="center">';
echo $MEASURE_UNIT;
echo '</td>
<td nowrap align="center">';
echo $TOTAL_PRICE;
echo '</td>
<td nowrap align="center">';
echo $TRANS_DATE;
echo '</td>
<td nowrap align="center">';
echo $SELLER;
echo '</td>
</tr>
';
}
echo ' </table>
<br>
</td>
</tr>
</table>
<br>
<div align="center">
<input type="button" value="关闭" class="SmallButton" onclick="window.close()">
</div>
</body>
</html>
';
?>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -