use_item.php

通达OA官方提供的30源代码,感觉很实在

<?
 include_once("inc/auth.php");
 include_once("inc/utility_field.php");

 global $connection,$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($ITEM_COUNT>0)
 {
?>
<title>领用物品清单</title>
<table width="100%" class="TableList">
<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=-$TRANS_QTY;
		}
		if ($TRANS_FLAG=="2")
		{
		 $TRANS_NAME="借用";
		}
		if ($TRANS_FLAG=="3")
		{
		 $TRANS_NAME="归还";
		}
?>
<tr class="TableData"><td nowrap align=center><?=$PRO_NAME?></td><td nowrap align=center><?=$TRANS_QTY?></td><td nowrap align=center><?=$PRO_UNIT?></td><td nowrap align=center><?=$TRANS_NAME?></td><td nowrap align=center><?=$TRANS_DATE?></td></tr>
<?
	  }//end while
?>
</table>
<?
  }
  else  //ITEM_COUNT=0
  {
    Message("","无领用物品记录");
  }
//use_items('admin');
?>