index.php
来自「通达OA2007SE源代码 非常好的」· PHP 代码 · 共 253 行
PHP
253 行
<?
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">
</head>
<body class="bodycolor" topmargin="5">
<table border="0" width="100%" cellspacing="0" cellpadding="3" class="small">
<tr>
<td class="Big"><img src="/images/notify_new.gif" align="absmiddle">';
echo '<s';
echo 'pan class="big3"> 借书登记 </span><br>
</td>
</tr>
</table>
<div align="center">
<input type="button" value="借书登记" class="BigButton" onClick="location=\'new.php\';" title="借书登记">
</div>
<br>
';
$BORROW_COUNT = 0;
$query = 'SELECT count(*) from BOOK_MANAGE where BOOK_STATUS=\'0\'';
$cursor = exequery ($connection, $query);
if ($ROW = mysql_fetch_array ($cursor))
{
$BORROW_COUNT = $ROW[0];
}
if (($BORROW_COUNT == 0))
{
echo '<table border="0" width="95%" cellspacing="0" cellpadding="3" class="small">
<tr>
<td class="Big"><img src="/images/menu/book.gif" align="absmiddle">';
echo '<s';
echo 'pan class="big3"> 借书管理</span>
</td>
</tr>
</table>
<br>
';
message ('', '没有借书信息');
exit ();
}
$PER_PAGE = 15;
$PAGES = 10;
$PAGE_COUNT = ceil (($BORROW_COUNT / $PER_PAGE));
if ((($CUR_PAGE <= 0) OR ($CUR_PAGE == '')))
{
$CUR_PAGE = 1;
}
if (($PAGE_COUNT < $CUR_PAGE))
{
$CUR_PAGE = $PAGE_COUNT;
}
echo '<table border="0" width="100%" cellspacing="0" cellpadding="3" class="small" align="center">
<tr>
<td class="Big"><img src="/images/menu/book.gif" align="absmiddle">';
echo '<s';
echo 'pan class="big3"> 已借出图书列表</span>
</td>
<td align="right" valign="bottom" class="small1">共';
echo '<s';
echo 'pan class="big4"> ';
echo $BORROW_COUNT;
echo '</span> 条 每页显示';
echo $PER_PAGE;
echo '条
</td>
<td align="right" valign="bottom" class="small1">
<a class="A1" href="index.php?CUR_PAGE=1">首页</a>
<a class="A1" href="index.php?CUR_PAGE=';
echo $PAGE_COUNT;
echo '">末页</a>
';
if ((($CUR_PAGE % $PAGES) == 0))
{
$J = $PAGES;
}
else
{
$J = ($CUR_PAGE % $PAGES);
}
if (($PAGES < $CUR_PAGE))
{
echo ' <a class="A1" href="index.php?CUR_PAGE=';
echo ((($CUR_PAGE - $J) - $PAGES) + 1);
echo '">上';
echo $PAGES;
echo '页</a>
';
}
for ($I = (($CUR_PAGE - $J) + 1); ($I <= (($CUR_PAGE - $J) + $PAGES)); ++$I)
{
if (($PAGE_COUNT < $I))
{
break;
}
if (($I == $CUR_PAGE))
{
echo ' [';
echo $I;
echo ']
';
continue;
}
else
{
echo ' [<a class="A1" href="index.php?CUR_PAGE=';
echo $I;
echo '">';
echo $I;
echo '</a>]
';
continue;
}
}
echo '
';
if ((($I - 1) < $PAGE_COUNT))
{
echo ' <a class="A1" href="index.php?CUR_PAGE=';
echo $I;
echo '">下';
echo $PAGES;
echo '页</a>
';
}
if ((1 <= ($CUR_PAGE - 1)))
{
echo ' <a class="A1" href="index.php?CUR_PAGE=';
echo ($CUR_PAGE - 1);
echo '">上一页</a>
';
}
else
{
echo ' 上一页
';
}
if ((($CUR_PAGE + 1) <= $PAGE_COUNT))
{
echo ' <a class="A1" href="index.php?CUR_PAGE=';
echo ($CUR_PAGE + 1);
echo '">下一页</a>
';
}
else
{
echo ' 下一页
';
}
echo ' </td>
</tr>
</table>
<table border="0" cellspacing="1" width="100%" class="small" bgcolor="#000000" cellpadding="3" align="center">
<tr class="TableHeader">
<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="c';
echo 'enter">备 注</td>
<td nowrap align="center">操 作</td>
</tr>
';
$query = 'SELECT * from BOOK_MANAGE where BOOK_STATUS=\'0\'order by RETURN_DATE desc';
$cursor = exequery ($connection, $query);
$BORROW_COUNT = 0;
while ($ROW = mysql_fetch_array ($cursor))
{
++$BORROW_COUNT;
if (($BORROW_COUNT < ((($CUR_PAGE * $PER_PAGE) - $PER_PAGE) + 1)))
{
continue;
}
else
{
if ((($CUR_PAGE * $PER_PAGE) < $BORROW_COUNT))
{
break;
}
$BORROW_ID = $ROW['BORROW_ID'];
$BUSER_ID = $ROW['BUSER_ID'];
$BOOK_NO = $ROW['BOOK_NO'];
$BORROW_DATE = $ROW['BORROW_DATE'];
$BORROW_REMARK = $ROW['BORROW_REMARK'];
$RUSER_ID = $ROW['RUSER_ID'];
$RETURN_DATE = $ROW['RETURN_DATE'];
$query1 = (((''.'select * from USER where USER_ID=\'').$BUSER_ID).'\'');
$cursor1 = exequery ($connection, $query1);
while ($ROW = mysql_fetch_array ($cursor1))
{
$USER_NAME1 = $ROW['USER_NAME'];
}
$query1 = (((''.'select * from USER where USER_ID=\'').$RUSER_ID).'\'');
$cursor1 = exequery ($connection, $query1);
while ($ROW = mysql_fetch_array ($cursor1))
{
$USER_NAME2 = $ROW['USER_NAME'];
}
$query1 = (((''.'select * from BOOK_INFO where BOOK_NO=\'').$BOOK_NO).'\'');
$cursor1 = exequery ($connection, $query1);
while ($ROW = mysql_fetch_array ($cursor1))
{
$BOOK_NAME = $ROW['BOOK_NAME'];
}
if ((($BORROW_COUNT % 2) == 1))
{
$TableLine = 'TableLine1';
}
else
{
$TableLine = 'TableLine2';
}
echo ' <tr class="';
echo $TableLine;
echo '">
<td nowrap align="center">';
echo $USER_NAME1;
echo '</td>
<td nowrap align="center">';
echo $BOOK_NAME;
echo '</td>
<td nowrap align="center">';
echo $BORROW_DATE;
echo '</td>
<td nowrap align="center">';
echo $RETURN_DATE;
echo '</td>
<td nowrap align="center">';
echo $USER_NAME2;
echo '</td>
<td nowrap align="center">';
echo $BORROW_REMARK;
echo '</td>
<td nowrap align="center"><a href="manage.php?BORROW_ID=';
echo $BORROW_ID;
echo '&BOOK_NO=';
echo $BOOK_NO;
echo '">还书</a></td>
</tr>
';
continue;
}
}
echo '</table>
</body>
</html>';
?>
⌨️ 快捷键说明
复制代码Ctrl + C
搜索代码Ctrl + F
全屏模式F11
增大字号Ctrl + =
减小字号Ctrl + -
显示快捷键?