noreturn.php
来自「通达OA2007SE源代码 非常好的」· PHP 代码 · 共 160 行
PHP
160 行
<?
include_once 'inc/auth.php';
include_once 'inc/utility_all.php';
echo '<html>
<head>
<title>未归还物品报表</title>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
';
echo '<s';
echo 'tyle type="text/css">
.small { font-size: 9pt;}
</style>
</head>
<body>
<table border="0" width="100%" cellspacing="0" cellpadding="3" class="small">
<tr>
<td class="Big"><img src="/images/notify_open.gif" WIDTH="22" HEIGHT="22" align="absmiddle">';
echo '<s';
echo 'pan class="big5"> 未归还物品报表</span>
</td>
<td align="right">
<input type="button" class="SmallButton" value="关闭" onclick="window.close();"> <input type="button" class="SmallButton" value="打印" onclick="window.print();">
</td>
</tr>
</table>
<br>
<div align="center">
';
$CUR_DATE = date ('Y-m-d', time ());
($WHERE_STR .= ' where a.TRANS_FLAG=\'2\'');
if (($FROM_DATE != ''))
{
($WHERE_STR .= (((''.' and a.TRANS_DATE>=\'').$FROM_DATE).'\''));
}
if (($TO_DATE != ''))
{
($WHERE_STR .= (((''.' and a.TRANS_DATE<=\'').$TO_DATE).'\''));
}
if (($PRO_ID != ''))
{
($WHERE_STR .= (((''.' and a.PRO_ID=\'').$PRO_ID).'\''));
}
if (($OFFICE_PROTYPE != ''))
{
($WHERE_STR .= (((''.' and b.OFFICE_PROTYPE=\'').$OFFICE_PROTYPE).'\''));
}
$query1 = 'select DEPT_ID from DEPARTMENT';
$cursor1 = exequery ($connection, $query1);
while ($ROW = mysql_fetch_array ($cursor1))
{
$DEPT_ID = $ROW['DEPT_ID'];
if ((is_dept_priv ($DEPT_ID) == 1))
{
$TO_ID = (($TO_ID.$DEPT_ID).',');
continue;
}
}
$TO_ID = (('\''.str_replace (',', '\',\'', substr ($TO_ID, 0, -1))).'\'');
if (($WHERE_STR == ''))
{
($WHERE_STR .= (((''.' where c.DEPT_ID in (').$TO_ID).')'));
}
else
{
($WHERE_STR .= (((''.' and c.DEPT_ID in (').$TO_ID).')'));
}
$CUR_DATE = date ('Y-m-d', time ());
$query = (('SELECT a.PRO_ID, b.PRO_NAME,a.TRANS_FLAG ,a.TRANS_QTY,a.BORROWER,b.PRO_UNIT,a.PRICE,a.TRANS_DATE,a.OPERATOR,a.REMARK from OFFICE_TRANSHISTORY a
LEFT OUTER JOIN OFFICE_PRODUCTS b ON a.PRO_ID = b.PRO_ID
LEFT OUTER JOIN USER c ON a.OPERATOR = c.USER_ID
'.$WHERE_STR).' order by b.PRO_NAME,a.TRANS_DATE DESC');
$cursor = exequery ($connection, $query);
$VOTE_COUNT = 0;
while ($ROW = mysql_fetch_array ($cursor))
{
$PROID = $ROW['PRO_ID'];
$RETURN_QTY = 0;
$PRONAME = $ROW['PRO_NAME'];
$PRO_UNIT = $ROW['PRO_UNIT'];
$BORROWER = $ROW['BORROWER'];
$TRANSFLAG = $ROW['TRANS_FLAG'];
$REMARK = $ROW['REMARK'];
$BORROW_QTY = ($ROW['TRANS_QTY'] * -1);
$PRICE = $ROW['PRICE'];
$TRANS_DATE = $ROW['TRANS_DATE'];
$OPERATOR = $ROW['OPERATOR'];
$query1 = (((''.'select USER_NAME from USER where USER_ID=\'').$OPERATOR).'\'');
$cursor1 = exequery ($connection, $query1);
if ($ROW = mysql_fetch_array ($cursor1))
{
$OPERATOR_NAME = $ROW['USER_NAME'];
}
$query1 = (((''.'select USER_NAME from USER where USER_ID=\'').$BORROWER).'\'');
$cursor1 = exequery ($connection, $query1);
if ($ROW = mysql_fetch_array ($cursor1))
{
$BORROWER_NAME = $ROW['USER_NAME'];
}
$query1 = (((((((''.'SELECT sum(a.TRANS_QTY) as TRANS_QTY from OFFICE_TRANSHISTORY a LEFT OUTER JOIN OFFICE_PRODUCTS b ON a.PRO_ID = b.PRO_ID where a.PRO_ID=\'').$PROID).'\' and a.TRANS_FLAG=\'3\' and a.TRANS_DATE>=\'').$TRANS_DATE).'\' and BORROWER=\'').$BORROWER).'\' group by a.PRO_ID');
$cursor1 = exequery ($connection, $query1);
if ($ROW = mysql_fetch_array ($cursor1))
{
$RETURN_QTY = $ROW['TRANS_QTY'];
}
$NORETURN_QTY = ($BORROW_QTY - $RETURN_QTY);
if ((0 < $NORETURN_QTY))
{
++$VOTE_COUNT;
if (($VOTE_COUNT == 1))
{
echo ' <table bordercolor="#000000" width="95%" style=\'border-collapse:collapse\' border=1 cellspacing=0 cellpadding=2 bordercolor=\'#000000\' class="small" align="center">
';
}
if ((($VOTE_COUNT % 2) == 1))
{
$TableLine = 'TableLine1';
}
else
{
$TableLine = 'TableLine2';
}
echo ' <tr>
<td nowrap align="center">';
echo $PRONAME;
echo '</td>
<td nowrap align="center">';
echo $NORETURN_QTY;
echo $PRO_UNIT;
echo '</td>
<td nowrap align="center">';
echo $BORROWER_NAME;
echo '</td>
<td nowrap align="center">';
echo $TRANS_DATE;
echo '</td>
</tr>
';
continue;
}
}
if ((0 < $VOTE_COUNT))
{
echo ' <thead bgcolor="#D3E5FA">
<td nowrap align="center"><b>办公用品名称</b></td>
<td nowrap align="center"><b>未归还数量</b></td>
<td nowrap align="center"><b>借用人</b></td>
<td nowrap align="center"><b>借用日期</b></td>
</thead>
</table>
';
}
else
{
message ('', '无符合条件的记录！！');
}
echo '</div>
</body>
</html>';
?>
⌨️ 快捷键说明
复制代码Ctrl + C
搜索代码Ctrl + F
全屏模式F11
增大字号Ctrl + =
减小字号Ctrl + -
显示快捷键?