📄 show_return.php

📁 极限网络智能办公系统 - Office Automation 2.8 100％源码
💻 PHP
字号:
<?php

include_once( "inc/auth.php" );
include_once( "inc/utility_all.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/menu/hrms.gif\" align=\"absmiddle\">";
echo "<s";
echo "pan class=\"big3\">&nbsp;归还查看</span><br>\r\n    </tr>\r\n </table>\r\n <br>\r\n <div align=\"center\">\r\n    <table border=\"0\" cellspacing=\"1\" width=\"60%\" class=\"small\" bgcolor=\"#000000\" cellpadding=\"3\">\r\n           <tr class=\"TableHeader\">\r\n  \t          <td nowrap align=\"center\">办公用品ID</td>\r\n              <td nowrap align=\"center\">办公用品名称</td>\r\n              <td nowrap align=\"center\">归还数量</td>\r\n           ";
echo "   <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\r\n           </tr>\r\n";
$query1 = "SELECT a.PRO_ID, b.PRO_NAME ,a.TRANS_QTY ,b.PRO_UNIT,a.TRANS_DATE,a.OPERATOR,a.BORROWER  FROM `OFFICE_TRANSHISTORY` a LEFT OUTER JOIN OFFICE_PRODUCTS b ON a.PRO_ID = b.PRO_ID LEFT OUTER JOIN USER c ON `BORROWER`= c.USER_ID LEFT OUTER JOIN DEPARTMENT d ON d.DEPT_ID = c.DEPT_ID where a.PRO_ID='{$PRO_ID}' and  a.TRANS_FLAG= '3' and TRANS_DATE>='{$DATE}' and c.DEPT_ID='{$DEP_ID}'";
$cursor1 = exequery( $connection, $query1 );
$DETAIL_COUNT = 0;
while ( $ROW = mysql_fetch_array( $cursor1 ) )
{
	++$DETAIL_COUNT;
	$DETAIL_PROID = $ROW['PRO_ID'];
	$DETAIL_PRONAME = $ROW['PRO_NAME'];
	$DETAIL_TRANSQTY = $ROW['TRANS_QTY'];
	$DETAIL_PROUNIT = $ROW['PRO_UNIT'];
	$DETAIL_PRICE = $ROW['PRICE'];
	$DETAIL_USER = $ROW['OPERATOR'];
	$DETAIL_BORROWER = $ROW['BORROWER'];
	$DETAIL_DATE = $ROW['TRANS_DATE'];
	$TOK = strtok( $DETAIL_USER, "," );
	$query1 = "select USER_NAME from USER where USER_ID='{$TOK}'";
	$cursor2 = exequery( $connection, $query1 );
	if ( $ROW = mysql_fetch_array( $cursor2 ) )
	{
		$DETAIL_USERNAME = $ROW['USER_NAME'];
	}
	$TOK = strtok( $DETAIL_BORROWER, "," );
	$query1 = "SELECT `USER_ID` , `USER_NAME` , PRIV_NAME, DEPT_NAME,a.DEPT_ID as DEPT_ID FROM `USER` a LEFT OUTER JOIN DEPARTMENT b ON a.DEPT_ID = b.DEPT_ID LEFT OUTER JOIN USER_PRIV c ON a.USER_PRIV = c.USER_PRIV where a.USER_ID='{$TOK}'";
	$cursor2 = exequery( $connection, $query1 );
	if ( $ROW = mysql_fetch_array( $cursor2 ) )
	{
		$DETAIL_BORROWERNAME = $ROW['USER_NAME'];
		$DETAIL_BORROWERDEPT = $ROW['DEPT_NAME'];
		$DETAIL_BORROWERDEPTID = $ROW['DEPT_ID'];
	}
	if ( $DETAIL_COUNT % 2 == 1 )
	{
		$TableLine = "TableLine1";
	}
	else
	{
		$TableLine = "TableLine2";
	}
	echo "           <tr class=\"TableData\">\r\n           <td nowrap align=\"center\">";
	echo $DETAIL_PROID;
	echo "</td>\r\n           <td align=\"center\">";
	echo $DETAIL_PRONAME;
	echo "</td>\r\n           <td nowrap align=\"center\">";
	echo $DETAIL_TRANSQTY;
	echo $DETAIL_PROUNIT;
	echo "</td>\r\n           <td nowrap align=\"center\">";
	echo $DETAIL_BORROWERNAME;
	echo "</td>\r\n           <td nowrap align=\"center\">";
	echo $DETAIL_BORROWERDEPT;
	echo "</td>\r\n           <td nowrap align=\"center\">";
	echo $DETAIL_USERNAME;
	echo "</td>\r\n           <td nowrap align=\"center\">";
	echo $DETAIL_DATE;
	echo "</td>\r\n           </tr>\r\n";
}
echo "       </table>\r\n\r\n   <br>\r\n   <input type=\"button\" class=\"BigButton\" value=\"关闭\" onclick=\"window.close();\">\r\n</div>\r\n</body>\r\n</html>";
?>
⌨️ 快捷键说明

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