search.php
来自「通达OA2007SE源代码 非常好的」· PHP 代码 · 共 215 行
PHP
215 行
<?
include_once 'inc/auth.php';
include_once 'inc/check_type.php';
echo '
<html>
<head>
<title>还书查询</title>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
';
echo '<s';
echo 'cript>
function delete_borrow(BORROW_ID,TO_ID,BOOK_NO,BOOK_STATUS)
{
msg=\'此操作不是真正意义上的删除，可以到历史纪录查询中查到\';
if(window.confirm(msg))
{
URL="delete.php?BORROW_ID=" + BORROW_ID + "&TO_ID=" + TO_ID + "&BOOK_NO=" + BOOK_NO + "&BOOK_STATUS=" + BOOK_STATUS;
window.location=URL;
}
}
</script>
</head>
<body class="bodycolor" topmargin="5">
';
$CUR_DATE = date ('Y-m-d', time ());
if (($START_B != ''))
{
$TIME_OK = is_date ($START_B);
if (!$TIME_OK)
{
message ('错误', ('"开始时间"的格式不对，应形如 '.$CUR_DATE));
button_back ();
exit ();
}
}
if (($END_B != ''))
{
$TIME_OK = is_date ($END_B);
if (!$TIME_OK)
{
message ('错误', ('"开始时间"的格式不对，应形如 '.$CUR_DATE));
button_back ();
exit ();
}
}
if (($TO_ID != ''))
{
($WHERE_STR .= (((''.' and BUSER_ID=\'').$TO_ID).'\''));
}
if (($BOOK_NO != ''))
{
($WHERE_STR .= (((''.' and BOOK_NO=\'').$BOOK_NO).'\''));
}
if (($START_B != ''))
{
($WHERE_STR .= (((''.' and BORROW_DATE>=\'').$START_B).'\''));
}
if (($END_B != ''))
{
($WHERE_STR .= (((''.' and BORROW_DATE<=\'').$END_B).'\''));
}
if (($BOOK_STATUS != ''))
{
($WHERE_STR .= (((''.' and BOOK_STATUS=\'').$BOOK_STATUS).'\''));
}
$query = (('SELECT count(*) from BOOK_MANAGE where (BOOK_STATUS=\'1\' or BOOK_STATUS=\'0\') and DELETE_FLAG=\'0\''.$WHERE_STR).' order by RETURN_DATE desc');
$cursor = exequery ($connection, $query);
$BOOK_COUNT = 0;
if ($ROW = mysql_fetch_array ($cursor))
{
$BOOK_COUNT = $ROW[0];
}
if (($BOOK_COUNT == 0))
{
message ('<br>提示', '没有符合条件的借书记录');
echo '<br>
<div align="center">
<input type="button" value="返回" class="BigButton" onClick="location=\'index.php\';">
</div>
';
exit ();
}
echo '
<table border="0" width="100%" cellspacing="0" cellpadding="3" class="small">
<tr>
<td class="Big"><img src="/images/menu/book.gif" WIDTH="22" HEIGHT="20" align="absmiddle">';
echo '<s';
echo 'pan class="big3"> 还书查询 </span><br>
</td>
</tr>
</table>
<table border="0" cellspacing="1" width="95%" class="small" bgcolor="#000000" cellpadding="3">
<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>
<t';
echo 'd nowrap align="center">状 态</td>
<td nowrap align="center">操 作</td>
</tr>
';
$query1 = str_replace ('count(*)', '*', $query);
$cursor1 = exequery ($connection, $query1);
$BOOK_COUNT = 0;
while ($ROW = mysql_fetch_array ($cursor1))
{
++$BOOK_COUNT;
$BORROW_ID = $ROW['BORROW_ID'];
$BUSER_ID = $ROW['BUSER_ID'];
$BOOK_NO1 = $ROW['BOOK_NO'];
$BORROW_DATE = $ROW['BORROW_DATE'];
$RUSER_ID = $ROW['RUSER_ID'];
$RETURN_DATE = $ROW['RETURN_DATE'];
$BOOK_STATUS1 = $ROW['BOOK_STATUS'];
$query2 = (((''.'select * from USER where USER_ID=\'').$BUSER_ID).'\'');
$cursor2 = exequery ($connection, $query2);
while ($ROW = mysql_fetch_array ($cursor2))
{
$USER_NAME1 = $ROW['USER_NAME'];
}
$query2 = (((''.'select * from USER where USER_ID=\'').$RUSER_ID).'\'');
$cursor2 = exequery ($connection, $query2);
while ($ROW = mysql_fetch_array ($cursor2))
{
$USER_NAME2 = $ROW['USER_NAME'];
}
$query2 = (((''.'select * from BOOK_INFO where BOOK_NO=\'').$BOOK_NO1).'\'');
$cursor2 = exequery ($connection, $query2);
while ($ROW = mysql_fetch_array ($cursor2))
{
$BOOK_NAME = $ROW['BOOK_NAME'];
}
if (($BOOK_STATUS1 == '1'))
{
$BOOK_STATUS_DESC = '已还';
}
if (($BOOK_STATUS1 == '0'))
{
$BOOK_STATUS_DESC = '未还';
}
if ((($BOOK_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 $BOOK_STATUS_DESC;
echo '</td>
';
if (($BOOK_STATUS1 == '0'))
{
echo ' <td nowrap align="center"><a href="manage.php?BORROW_ID=';
echo $BORROW_ID;
echo '&BOOK_NO1=';
echo $BOOK_NO1;
echo '&TO_ID=';
echo $TO_ID;
echo '&BOOK_NO=';
echo $BOOK_NO;
echo '&BOOK_STATUS=';
echo $BOOK_STATUS;
echo '">还书</a></td>
';
}
if (($BOOK_STATUS1 == '1'))
{
echo ' <td nowrap align="center">
<a href="javascript:delete_borrow(\'';
echo $BORROW_ID;
echo '\',\'';
echo $TO_ID;
echo '\',\'';
echo $BOOK_NO;
echo '\',\'';
echo $BOOK_STATUS;
echo '\');"> 删除并存为历史纪录</a>
</td>
';
}
echo ' </tr>
';
}
echo '</table>
<br>
<div align="center">
<input type="button" value="返回" class="BigButton" onClick="location=\'index.php\';">
</div>
</body>
</html>';
?>
⌨️ 快捷键说明
复制代码Ctrl + C
搜索代码Ctrl + F
全屏模式F11
增大字号Ctrl + =
减小字号Ctrl + -
显示快捷键?