use_item.php

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

<?php

include_once( "inc/auth.php" );
include_once( "inc/utility_field.php" );
global $connection;
global $query;
$query = "SELECT * from OFFICE_TRANSHISTORY,OFFICE_PRODUCTS where BORROWER='".$USER_ID."' and  OFFICE_TRANSHISTORY.PRO_ID=OFFICE_PRODUCTS.PRO_ID AND(TRANS_FLAG=1 OR TRANS_FLAG=2 OR TRANS_FLAG=3) order by TRANS_DATE";
$cursor = exequery( $connection, $query );
$ITEM_COUNT = mysql_num_rows( $cursor );
if ( 0 < $ITEM_COUNT )
{
	echo "<title>领用物品清单</title>\r\n<table width=\"100%\" class=\"TableList\">\r\n<tr class=\"TableHeader\"><td>物品名称</td><td>数量</td><td>单位</td><td>状态</td><td>日期</td></tr>";
	while ( $ROW = mysql_fetch_array( $cursor ) )
	{
		$PRO_UNIT = $ROW['PRO_UNIT'];
		$PRO_NAME = $ROW['PRO_NAME'];
		$TRANS_FLAG = $ROW['TRANS_FLAG'];
		$TRANS_QTY = $ROW['TRANS_QTY'];
		$TRANS_DATE = $ROW['TRANS_DATE'];
		if ( $TRANS_FLAG == "1" )
		{
			$TRANS_NAME = "领用";
			$TRANS_QTY = 0 - $TRANS_QTY;
		}
		if ( $TRANS_FLAG == "2" )
		{
			$TRANS_NAME = "借用";
		}
		if ( $TRANS_FLAG == "3" )
		{
			$TRANS_NAME = "归还";
		}
		echo "<tr class=\"TableData\"><td nowrap align=center>";
		echo $PRO_NAME;
		echo "</td><td nowrap align=center>";
		echo $TRANS_QTY;
		echo "</td><td nowrap align=center>";
		echo $PRO_UNIT;
		echo "</td><td nowrap align=center>";
		echo $TRANS_NAME;
		echo "</td><td nowrap align=center>";
		echo $TRANS_DATE;
		echo "</td></tr>\r\n";
	}
	echo "</table>\r\n";
}
else
{
	message( "", "无领用物品记录" );
}
?>