📄 show_return.php
字号:
<?
include_once("inc/auth.php");
include_once("inc/utility_all.php");
?>
<html>
<head>
<title>归还查看</title>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
</head>
<body class="bodycolor" topmargin="5">
<table border="0" width="100%" cellspacing="0" cellpadding="3" class="small">
<tr>
<td class="Big"><img src="/images/menu/hrms.gif" align="absmiddle"><span class="big3"> 归还查看</span><br>
</tr>
</table>
<br>
<div align="center">
<table border="0" cellspacing="1" width="60%" class="small" bgcolor="#000000" cellpadding="3">
<tr class="TableHeader">
<td nowrap align="center">办公用品ID</td>
<td nowrap align="center">办公用品名称</td>
<td nowrap align="center">归还数量</td>
<td nowrap align="center">归还人</td>
<td nowrap align="center">归还部门</td>
<td nowrap align="center">操作员</td>
<td nowrap align="center">归还日期</td>
</tr>
<?
//============================显示明细查询=======================================
$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";
?>
<tr class="TableData">
<td nowrap align="center"><?=$DETAIL_PROID?></td>
<td align="center"><?=$DETAIL_PRONAME?></td>
<td nowrap align="center"><?=$DETAIL_TRANSQTY?><?=$DETAIL_PROUNIT?></td>
<td nowrap align="center"><?=$DETAIL_BORROWERNAME?></td>
<td nowrap align="center"><?=$DETAIL_BORROWERDEPT?></td>
<td nowrap align="center"><?=$DETAIL_USERNAME?></td>
<td nowrap align="center"><?=$DETAIL_DATE?></td>
</tr>
<?
}
?>
</table>
<br>
<input type="button" class="BigButton" value="关闭" onclick="window.close();">
</div>
</body>
</html>⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -