📄 read_roll.php
字号:
<?php
include_once( "inc/auth.php" );
include_once( "inc/utility_all.php" );
echo "\r\n<html>\r\n<head>\r\n<title>查看案卷</title>\r\n<meta http-equiv=\"Content-Type\" content=\"text/html; charset=gb2312\">\r\n</head>\r\n";
$query = "select * from RMS_ROLL where ROLL_ID=".$ROLL_ID;
$cursor = exequery( $connection, $query );
if ( $ROW = mysql_fetch_array( $cursor ) )
{
$ROLL_CODE = $ROW['ROLL_CODE'];
$ROLL_NAME = $ROW['ROLL_NAME'];
$ROOM_ID = $ROW['ROOM_ID'];
$YEARS = $ROW['YEARS'];
$BEGIN_DATE = $ROW['BEGIN_DATE'];
$END_DATE = $ROW['END_DATE'];
$DEPT_ID = $ROW['DEPT_ID'];
$CATEGORY_NO = $ROW['CATEGORY_NO'];
$DEADLINE = $ROW['DEADLINE'];
$SECRET = $ROW['SECRET'];
$CATALOG_NO = $ROW['CATALOG_NO'];
$ARCHIVE_NO = $ROW['ARCHIVE_NO'];
$BOX_NO = $ROW['BOX_NO'];
$MICRO_NO = $ROW['MICRO_NO'];
$CERTIFICATE_KIND = $ROW['CERTIFICATE_KIND'];
$CERTIFICATE_START = $ROW['CERTIFICATE_START'];
$CERTIFICATE_END = $ROW['CERTIFICATE_END'];
$ROLL_PAGE = $ROW['ROLL_PAGE'];
$BORROW = $ROW['BORROW'];
}
echo "<body class=\"bodycolor\" topmargin=\"5\">\r\n\r\n<table border=\"0\" width=\"90%\" cellspacing=\"0\" cellpadding=\"3\" class=\"small\">\r\n <tr>\r\n <td class=\"Big\"><img src=\"/images/notify_new.gif\" align=\"absmiddle\"><span class=\"big3\"> 查看案卷</span>\r\n </td>\r\n </tr>\r\n</table>\r\n\r\n<table class=\"TableBlock\" width=\"85%\" align=\"center\">\r\n <form enctype=\"multipart/form-data\" action=\"update.php\" method=\"post\" name=\"form1\">\r\n <TR>\r\n <TD class=\"TableData\">案 卷 号：</TD>\r\n <TD class=\"TableData\">";
echo $ROLL_CODE;
echo "</TD>\r\n <TD class=\"TableData\">案卷名称：</TD>\r\n <TD class=\"TableData\">";
echo $ROLL_NAME;
echo "</TD>\r\n </TR>\r\n <TR>\r\n <TD class=\"TableData\">所属卷库：</TD>\r\n <TD class=\"TableData\">\r\n";
$query = "SELECT * FROM RMS_ROLL_ROOM WHERE ROOM_ID=".$ROOM_ID;
$cursor = exequery( $connection, $query );
$ROW = mysql_fetch_array( $cursor );
$ROOM_NAME = $ROW['ROOM_NAME'];
echo $ROOM_NAME;
echo "\t\r\n </TD>\r\n <TD class=\"TableData\">归卷年代：</TD>\r\n <TD class=\"TableData\">";
echo $YEARS;
echo "</TD>\r\n </TR>\r\n <TR>\r\n <TD class=\"TableData\">起始日期：</TD>\r\n <TD class=\"TableData\">";
echo $BEGIN_DATE;
echo "</TD>\r\n <TD class=\"TableData\">终止日期：</TD>\r\n <TD class=\"TableData\">";
echo $END_DATE;
echo "</TD>\r\n </TR>\r\n <TR>\r\n <TD class=\"TableData\">所属部门：</TD>\r\n <TD class=\"TableData\">\r\n";
$query = "SELECT * FROM DEPARTMENT WHERE DEPT_ID=".$DEPT_ID;
$cursor = exequery( $connection, $query );
$ROW = mysql_fetch_array( $cursor );
$DEPT_NAME = $ROW['DEPT_NAME'];
echo $DEPT_NAME;
echo "\t</select>\r\n </TD>\r\n <TD class=\"TableData\">编制机构：</TD>\r\n <TD class=\"TableData\">";
echo $CATEGORY_NO;
echo "</TD>\r\n </TR>\r\n <TR>\r\n <TD class=\"TableData\">保管期限：</TD>\r\n <TD class=\"TableData\">";
echo $DEADLINE;
echo "</TD>\r\n <TD class=\"TableData\">案卷密级：</TD>\r\n <TD class=\"TableData\">";
echo get_code_name( $SECRET, "RMS_SECRET" );
echo "</TD>\r\n </TR>\r\n <TR>\r\n <TD class=\"TableData\">全 宗 号：</TD>\r\n <TD class=\"TableData\">";
echo $CATEGORY_NO;
echo "</TD>\r\n <TD class=\"TableData\">目 录 号：</TD>\r\n <TD class=\"TableData\">";
echo $CATALOG_NO;
echo "</TD>\r\n </TR>\r\n <TR>\r\n <TD nowrap class=\"TableData\">档案馆号：</TD>\r\n <TD class=\"TableData\">";
echo $ARCHIVE_NO;
echo "</TD>\r\n <TD class=\"TableData\">保险箱号：</TD>\r\n <TD class=\"TableData\">";
echo $BOX_NO;
echo "</TD>\r\n </TR>\r\n <TR>\r\n <TD nowrap class=\"TableData\">缩 微 号：</TD>\r\n <TD class=\"TableData\">";
echo $MICRO_NO;
echo "</TD>\r\n <TD class=\"TableData\">凭证类别：</TD>\r\n <TD class=\"TableData\">";
echo get_code_name( $CERTIFICATE_KIND, "RMS_CERTIFICATE_KIND" );
echo " </TD>\r\n </TR>\r\n <TR>\r\n <TD nowrap class=\"TableData\">凭证编号(起)：</TD>\r\n <TD class=\"TableData\">";
echo $CERTIFICATE_START;
echo "</TD>\r\n <TD class=\"TableData\">凭证编号(止)：</TD>\r\n <TD class=\"TableData\"";
echo $CERTIFICATE_END;
echo "</TD>\r\n </TR>\r\n <TR>\r\n <TD nowrap class=\"TableData\">页 数：</TD>\r\n <TD class=\"TableData\">";
echo $ROLL_PAGE;
echo "</TD>\r\n <TD class=\"TableData\">借阅审批：</TD>\r\n <TD class=\"TableData\"></TD>\r\n </TR>\r\n <TR>\r\n <TD nowrap class=\"TableData\">备注：</TD>\r\n <TD class=\"TableData\" colSpan=3>";
echo $REMARK;
echo "</TD>\r\n </TR>\r\n <tr align=\"center\" class=\"TableControl\">\r\n <td colspan=\"4\" nowrap>\r\n <input type=\"button\" value=\"关闭\" class=\"BigButton\" onClick=\"javascript:window.close();\">\r\n </td>\r\n </tr>\r\n </table>\r\n</form>\r\n\r\n</body>\r\n</html>";
?>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -