⭐ 欢迎来到虫虫下载站！ | 📦 资源下载 📁 资源专辑 ℹ️ 关于我们
⭐ 虫虫下载站
📤 上传资源

📄 show_detail.php

📁 通达网络办公 - Office Anywhere 2008 增强版100％源码(3.4.081216) 内含 通达OA2008增強版接近完美破解补丁20081216集 及 最新通达OA2008ADV(
💻 PHP
字号:
🔍 
<?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;
		}
	}
}

include_once( "inc/auth.php" );
include_once( "inc/utility_field.php" );
echo "\r\n<html>\r\n<head>\r\n<title>采购订单详细信息</title>\r\n<meta http-equiv=\"Content-Type\" content=\"text/html; charset=gb2312\">\r\n</head>\r\n<body class=\"bodycolor\" topmargin=\"5\">\r\n\r\n<table border=\"0\" width=\"100%\" cellspacing=\"0\" cellpadding=\"3\" class=\"small\">\r\n  <tr>\r\n    <td class=\"Big\"><img src=\"/images/notify_new.gif\" align=\"absmiddle\"><span class=\"big3\"> 采购订单详细信息</span>\r\n    </td>\r\n  </tr>\r\n</table>\r\n<br>\r\n";
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\" >\r\n  <form action=\"add.php\" enctype=\"multipart/form-data\" method=\"post\" name=\"form1\" onsubmit=\"return CheckForm();\">\r\n   <tr>\r\n    <td nowrap  class=\"TableHeader\" colspan=\"4\" align=\"left\">\r\n    采购订单基本信息：\r\n    </td>\r\n   </tr>\r\n   <tr>\r\n   \t<td nowrap class=\"TableData\">供应商名称： </td>\r\n    <td class=\"TableData\">\r\n      ";
echo $PROVIDER_NAME1;
echo "    </td>\r\n    <td nowrap class=\"TableData\">订单编号： </td>\r\n    <td nowrap class=\"TableData\">\r\n        ";
echo $ORDER_NO1;
echo "    </td>\r\n   </tr>\r\n\r\n   <tr>\r\n   <td nowrap class=\"TableData\">订单类型： </td>\r\n    <td nowrap class=\"TableData\">\r\n";
getalldate( "ORDER_TYPE", $ORDER_TYPE1 );
echo "   </td>\r\n    <td nowrap class=\"TableData\">订单打印样式： </td>\r\n    <td nowrap class=\"TableData\">\r\n      电子产品采购订单\r\n    </td>\r\n   </tr>\r\n\r\n\r\n    <tr>\r\n    <td nowrap class=\"TableData\">订单名称： </td>\r\n    <td nowrap class=\"TableData\" colspan=\"3\">\r\n     ";
echo $ORDER_NAME1;
echo "    </td>\r\n   </tr>\r\n\r\n    <tr>\r\n    <td nowrap class=\"TableData\">订单描述： </td>\r\n    <td nowrap class=\"TableData\" colspan=\"3\">\r\n    \t";
echo $ORDER_MEMO1;
echo "    </td>\r\n   </tr>\r\n   \r\n  <tr>\r\n    <td nowrap class=\"TableData\">创建日期：</td>\r\n    <td nowrap class=\"TableData\">\r\n       ";
echo $CREATE_DATE1;
echo "    </td>\r\n     <td nowrap class=\"TableData\">来货日期： </td>\r\n    <td nowrap class=\"TableData\">\r\n        ";
echo $BEGIN_DATE1;
echo "    </td>\r\n  </tr>\r\n  \r\n  <tr>\r\n    <td nowrap class=\"TableData\">创建人： </td>\r\n    <td nowrap class=\"TableData\">\r\n    ";
echo $SELLER1_NAME;
echo "    </td>\r\n     <td nowrap class=\"TableData\">负责人： </td>\r\n    <td nowrap class=\"TableData\">\r\n        ";
echo $RECIVER_NAME1;
echo "    </td>\r\n   </tr>\r\n<tr>\r\n <td nowrap class=\"TableData\">备注： </td>\r\n    <td nowrap class=\"TableData\" colspan=\"3\">\r\n        ";
echo $REMARK1;
echo "    </td>\r\n</tr>\r\n  <tr>\r\n      <td class=\"TableData\" colspan=\"8\">\r\n        ";
echo get_field_table( get_field_text( "SUPPLY_ORDER", $ORDER_ID ) );
echo "      </td>\r\n  </tr>\r\n  <tr>\r\n    <td nowrap  class=\"TableHeader\" colspan=\"4\" align=\"left\">\r\n     订单明细：\r\n    </td>\r\n  </tr>\r\n  <tr>\r\n   <td nowrap class=\"TableData\" colspan=\"4\" align=\"center\">\r\n   \t<br>\r\n    \t <table border=\"0\" cellspacing=\"1\" width=\"95%\" class=\"small\" bgcolor=\"#000000\" cellpadding=\"3\">\r\n    \t \t  <tr class=\"TableHeader\">\r\n  \t         <td nowrap align=\"center\">产品名称</td>\r\n  \t          <td nowrap align=\"center\">产品编码</td>\r\n  \t         <td nowrap align=\"center\">产品型号</td>\r\n             <td nowrap align=\"center\">单价</td>\r\n             <td nowrap align=\"center\">交付数量</td>\r\n              <td nowrap align=\"center\">单位</td>\r\n             <td nowrap align=\"center\">总价</td>\r\n          </tr>\r\n";
$query = "SELECT a.LINE_ID as LINE_ID,b.PRODUCT_ID as PRODUCT_ID,b.PRODUCT_NAME as PRODUCT_NAME,\r\n                   a.TRANS_PRICE as TRANS_PRICE,b.MEASURE_UNIT,\r\n                   a.TRANS_QTY as TRANS_QTY,a.PAYMENT as PAYMENT,a.MEMO as MEMO,\r\n                   b.PRODUCT_CODE as PRODUCT_CODE,a.TRANS_PRICE*a.TRANS_QTY as TOTALPRICE,b.PRODUCT_TYPE as PRODUCT_TYPE\r\n                   from ORDER_LINE a\r\n                   LEFT OUTER JOIN PRODUCT b ON a.PRODUCT_ID = b.PRODUCT_ID\r\n                   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 += $TRANS_QTY;
	$SUM_TOTAL_PRICE += $TOTAL_PRICE;
	if ( $VOTE_COUNT % 2 == 1 )
	{
		$TableLine = "TableLine1";
	}
	else
	{
		$TableLine = "TableLine2";
	}
	echo "      <tr class=\"";
	echo $TableLine;
	echo "\">\r\n      <td nowrap align=\"center\">";
	echo $PRODUCT_NAME;
	echo "</td>\r\n      <td align=\"center\">";
	echo $PRODUCT_CODE;
	echo "</td>\r\n       <td align=\"center\">";
	echo $PRODUCT_TYPE;
	echo "</td>\r\n      <td align=\"center\">";
	echo $TRANS_PRICE;
	echo "</td>\r\n      <td nowrap align=\"center\">";
	echo $TRANS_QTY;
	echo "</td>\r\n       <td nowrap align=\"center\">";
	echo $MEASURE_UNIT;
	echo "</td>\r\n      <td nowrap align=\"center\">";
	echo $TOTAL_PRICE;
	echo "</td>\r\n     </tr>\r\n";
}
echo "\r\n</table>\r\n<br>\r\n</td>\r\n</tr>\r\n <tr>\r\n    <td nowrap  class=\"TableHeader\" colspan=\"4\" align=\"left\">\r\n     接货记录：\r\n    </td>\r\n  </tr>\r\n  <tr>\r\n   <td nowrap class=\"TableData\" colspan=\"4\" align=\"center\">\r\n ";
$query = "SELECT  a.LINE_ID as LINE_ID,a.PRODUCT_ID as PRODUCT_ID,b.PRODUCT_NAME as PRODUCT_NAME,b.MEASURE_UNIT,\r\n                   a.PRICE as TRANS_PRICE,b.PRODUCT_TYPE as PRODUCT_TYPE,b.PRODUCT_CODE as PRODUCT_CODE,\r\n                   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\r\n                   from SUPPLY_HISTORY  a\r\n                   LEFT OUTER JOIN PRODUCT b ON a.PRODUCT_ID = b.PRODUCT_ID\r\n                   LEFT OUTER JOIN ORDER_LINE d ON a.LINE_ID = d.LINE_ID\r\n                   LEFT OUTER JOIN SUPPLY_ORDER e ON d.ORDER_ID = e.ORDER_ID\r\n                   LEFT OUTER JOIN USER f ON a.SALESMAN=f.USER_ID\r\n                   LEFT OUTER JOIN PROVIDER g ON a.PROVIDER_ID=g.PROVIDER_ID\r\n                   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>\r\n     <table border=\"0\" cellspacing=\"1\" width=\"95%\" class=\"small\" bgcolor=\"#000000\" cellpadding=\"3\">\r\n     <tr class=\"TableHeader\">\r\n  \t  <td nowrap align=\"center\">产品名称</td>\r\n  \t  <td nowrap align=\"center\">产品编码</td>\r\n  \t  <td nowrap align=\"center\">产品型号</td>\r\n      <td nowrap align=\"center\">单价</td>\r\n      <td nowrap align=\"center\">交付数量</td>\r\n       <td nowrap align=\"center\">单位</td>\r\n      <td nowrap align=\"center\">总价</td>\r\n      <td nowrap align=\"center\">交付日期</td>\r\n      <td nowrap align=\"center\">接货员</td>\r\n    </tr>\r\n";
	}
	if ( $VOTE_COUNT % 2 == 1 )
	{
		$TableLine = "TableLine1";
	}
	else
	{
		$TableLine = "TableLine2";
	}
	echo "    <tr class=\"";
	echo $TableLine;
	echo "\">\r\n      <td nowrap align=\"center\">";
	echo $PRODUCT_NAME;
	echo "</td>\r\n      <td align=\"center\">";
	echo $PRODUCT_CODE;
	echo "</td>\r\n      <td align=\"center\">";
	echo $PRODUCT_TYPE;
	echo "</td>\r\n      <td align=\"center\">";
	echo $TRANS_PRICE;
	echo "</td>\r\n      <td nowrap align=\"center\">";
	echo $TRANS_QTY;
	echo "</td>\r\n       <td nowrap align=\"center\">";
	echo $MEASURE_UNIT;
	echo "</td>\r\n      <td nowrap align=\"center\">";
	echo $TOTAL_PRICE;
	echo "</td>\r\n      <td nowrap align=\"center\">";
	echo $TRANS_DATE;
	echo "</td>\r\n       <td nowrap align=\"center\">";
	echo $SELLER;
	echo "</td>\r\n    </tr>\r\n";
}
echo "   </table>\r\n   <br>\r\n   </td>\r\n  </tr>\r\n</table>\r\n<br>\r\n<div align=\"center\">\r\n <input type=\"button\" value=\"关闭\" class=\"SmallButton\" onclick=\"window.close()\">\r\n</div>\r\n</body>\r\n</html>\r\n";
?>

⌨️ 快捷键说明

复制代码 Ctrl + C
搜索代码 Ctrl + F
全屏模式 F11
切换主题 Ctrl + Shift + D
显示快捷键 ?
增大字号 Ctrl + =
减小字号 Ctrl + -