📄 trans_detail.php

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

include_once( "inc/auth.php" );
include_once( "inc/utility_all.php" );
echo "<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";
$query = "SELECT * from OFFICE_TRANSHISTORY where TRANS_ID = '".$TRANS_ID."'";
$cursor = exequery( $connection, $query );
if ( $ROW = mysql_fetch_array( $cursor ) )
{
	$PRO_ID = $ROW['PRO_ID'];
	$TRANS_FLAG = $ROW['TRANS_FLAG'];
	$TRANS_QTY = $ROW['TRANS_QTY'];
	$REMARK = $ROW['REMARK'];
	$TRANS_DATE = $ROW['TRANS_DATE'];
	$TRANS_STATE = $ROW['TRANS_STATE'];
	$BORROWER = $ROW['BORROWER'];
	$FACT_QTY = $ROW['FACT_QTY'];
	$OPERATOR = $ROW['OPERATOR'];
	$query1 = "select USER_NAME from USER where USER_ID='".$BORROWER."'";
	$cursor1 = exequery( $connection, $query1 );
	if ( $ROW = mysql_fetch_array( $cursor1 ) )
	{
		$BORROWER_NAME = $ROW[0];
	}
	else
	{
		$BORROWER_NAME = "已不存在该用户";
	}
	$query1 = "select USER_NAME from USER where USER_ID='".$OPERATOR."'";
	$cursor1 = exequery( $connection, $query1 );
	if ( $ROW = mysql_fetch_array( $cursor1 ) )
	{
		$OPERATOR_NAME = $ROW[0];
	}
	else
	{
		$OPERATOR_NAME = "已不存在该用户";
	}
	$query1 = "SELECT OFFICE_PROTYPE,PRO_NAME,PRO_PRICE,PRO_LOWSTOCK,PRO_MAXSTOCK,PRO_STOCK from OFFICE_PRODUCTS where PRO_ID = '".$PRO_ID."'";
	$cursor1 = exequery( $connection, $query1 );
	if ( $ROW = mysql_fetch_array( $cursor1 ) )
	{
		$PRO_NAME = $ROW['PRO_NAME'];
		$OFFICE_PROTYPE = $ROW['OFFICE_PROTYPE'];
		$PRO_PRICE = $ROW['PRO_PRICE'];
		$PRO_LOWSTOCK = $ROW['PRO_LOWSTOCK'];
		$PRO_MAXSTOCK = $ROW['PRO_MAXSTOCK'];
		$PRO_STOCK = $ROW['PRO_STOCK'];
	}
	else
	{
		$PRO_NAME = "此物品已删除";
	}
	$query1 = "SELECT CODE_NAME from SYS_CODE where CODE_NO='".$OFFICE_PROTYPE."' and PARENT_NO='OFFICE_PROTYPE'";
	$cursor1 = exequery( $connection, $query1 );
	if ( $ROW = mysql_fetch_array( $cursor1 ) )
	{
		$CODE_NAME = $ROW['CODE_NAME'];
	}
	else
	{
		$CODE_NAME = "此类别已删除";
	}
	if ( $TRANS_FLAG == "1" )
	{
		$TRANS_NAME = "领用";
	}
	if ( $TRANS_FLAG == "2" )
	{
		$TRANS_NAME = "借用";
	}
	if ( $TRANS_FLAG == "3" )
	{
		$TRANS_NAME = "归还";
	}
	if ( substr( $TRANS_QTY, 0, 1 ) == "-" )
	{
		$TRANS_QTY = substr( $TRANS_QTY, 1 );
	}
}
echo "<body class=\"bodycolor\" topmargin=\"5\">\r\n<table border=\"0\" width=\"50%\" 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\">&nbsp;登记信息详情</span>\r\n    </td>\r\n  </tr>\r\n</table>\r\n<br>\r\n<form enctype=\"multipart/form-data\" action=\"trans_handle.php\"  method=\"post\" name=\"form1\">\r\n<table width=\"70%\" align=\"center\" class=\"TableBlock\">\r\n    <tr>\r\n      <td nowrap class=\"TableData\" width=\"30%\">申请类型：</td>\r\n      <td class=\"TableData\">";
echo $TRANS_NAME;
echo "</td>\r\n    </tr>\r\n    <tr>\r\n      <td nowrap class=\"TableData\" width=\"30%\">申请人：</td>\r\n      <td class=\"TableData\">";
echo $BORROWER_NAME;
echo "</td>\r\n    </tr>\r\n    <tr>\r\n      <td nowrap class=\"TableData\" width=\"30%\">申请时间：</td>\r\n      <td class=\"TableData\">";
echo $TRANS_DATE;
echo "</td>\r\n    </tr>\r\n    <tr>\r\n      <td nowrap class=\"TableData\">办公用品类别：</td>\r\n      <td class=\"TableData\">";
echo $CODE_NAME;
echo "</td>\r\n    </tr>\r\n    <tr>\r\n      <td nowrap class=\"TableData\">办公用品名称：</td>\r\n      <td class=\"TableData\">";
echo $PRO_NAME;
echo "</td>\r\n      </tr>\r\n    <tr>\r\n    <tr>\r\n      <td nowrap class=\"TableData\">申请数量：</td>\r\n      <td class=\"TableData\">";
echo $TRANS_QTY;
echo "</td>\r\n    </tr>\r\n     <tr>\r\n      <td nowrap class=\"TableData\">实际数量：</td>\r\n      <td class=\"TableData\">";
echo $FACT_QTY;
echo "</td>\r\n    </tr>\r\n    <tr>\r\n      <td nowrap class=\"TableData\">审批人：</td>\r\n      <td class=\"TableData\">";
echo $OPERATOR_NAME;
echo "</td>\r\n    </tr>\r\n     <tr>\r\n      <td nowrap class=\"TableData\">备注：</td>\r\n      <td class=\"TableData\">";
echo $REMARK;
echo "</td>\r\n    </tr>\r\n    <input type=\"hidden\" name=\"OPERATOR_ID\" value=\"";
echo $LOGIN_USER_ID;
echo "\">\r\n    <input type=\"hidden\" name=\"TRANS_ID\" value=\"";
echo $TRANS_ID;
echo "\">\r\n    <input type=\"hidden\" name=\"TRANS_FLAG\" value=\"";
echo $TRANS_FLAG;
echo "\">\r\n    <input type=\"hidden\" name=\"PRO_ID\" value=\"";
echo $PRO_ID;
echo "\">\r\n    <input type=\"hidden\" name=\"PRO_STOCK\" value=\"";
echo $PRO_STOCK;
echo "\">\r\n    <tfoot align=\"center\" class=\"TableFooter\">\r\n      <td colspan=\"2\" nowrap>\r\n        <input type=\"button\" value=\"返回\" class=\"BigButton\" onClick=\"javascript:history.go(-1)\">\r\n      </td>\r\n    </tfoot>\r\n  </table>\r\n</form>\r\n</body>\r\n</html>\r\n";
?>
⌨️ 快捷键说明

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