📄 show_reader.php
字号:
<?php
include_once( "inc/auth.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\r\n";
$connection = openconnection( );
$query = "SELECT * from NOTIFY where NOTIFY_ID={$NOTIFY_ID}";
$cursor = exequery( $connection, $query );
if ( $ROW = mysql_fetch_array( $cursor ) )
{
$SUBJECT = $ROW['SUBJECT'];
$READERS = $ROW['READERS'];
}
echo "\r\n<body class=\"bodycolor\" topmargin=\"5\">\r\n<table border=\"0\" width=\"100%\" cellspacing=\"0\" cellpadding=\"3\" class=\"small\">\r\n <tr>\r\n <td class=\"Big\"><img src=\"/images/menu/notify.gif\" align=\"absmiddle\">";
echo "<s";
echo "pan class=\"big3\"> 查阅情况 - ";
echo $SUBJECT;
echo "</span><br>\r\n </td>\r\n </tr>\r\n</table>\r\n\r\n<hr width=\"100%\" height=\"1\" align=\"left\" color=\"#FFFFFF\">\r\n\r\n";
if ( $READERS != "" )
{
$READERS_ARRAY = explode( ",", $READERS );
$READERS_ARRAY_NUM = sizeof( $READERS_ARRAY ) - 1;
echo "<table border=\"0\" cellspacing=\"1\" width=\"100%\" class=\"small\" bgcolor=\"#000000\" cellpadding=\"3\">\r\n <tr>\r\n <td align=\"center\" class=\"TableHeader\" width=\"80\">所属部门 </td>\r\n <td align=\"center\" class=\"TableHeader\" colspan=\"2\">用户姓名</td>\r\n </tr>\r\n";
$I = 0;
for ( ; $I < $READERS_ARRAY_NUM; ++$I )
{
$USER_ID = $READERS_ARRAY[$I];
$query = "select * from USER where USER_ID='{$USER_ID}'";
$cursor = exequery( $connection, $query );
if ( $ROW = mysql_fetch_array( $cursor ) )
{
$USER_NAME = $ROW['USER_NAME'];
$DEPT_ID = $ROW['DEPT_ID'];
}
$J = 0;
for ( ; $J < count( $USER_ARRAY ); ++$J )
{
if ( $DEPT_ID == $USER_ARRAY[$J]['DEPT'] )
{
$USER_ARRAY[$J]['USER'] .= "，".$USER_NAME;
break;
}
}
if ( $J == count( $USER_ARRAY ) )
{
$USER_ARRAY[$J]['DEPT'] = $DEPT_ID;
$USER_ARRAY[$J]['USER'] = $USER_NAME;
}
}
$query = "select * from DEPARTMENT order by DEPT_NO";
$cursor = exequery( $connection, $query );
while ( $ROW = mysql_fetch_array( $cursor ) )
{
$DEPT_ID = $ROW['DEPT_ID'];
$DEPT_NAME = $ROW['DEPT_NAME'];
$UN_USER = "";
$query = "select * from USER where DEPT_ID={$DEPT_ID} order by USER_NAME";
$cursor1 = exequery( $connection, $query );
while ( $ROW1 = mysql_fetch_array( $cursor1 ) )
{
$USER_ID = $ROW1['USER_ID'];
$USER_NAME = $ROW1['USER_NAME'];
if ( find_id( $READERS, $USER_ID ) )
{
}
else
{
$UN_USER .= $USER_NAME."，";
}
}
$UN_USER = substr( $UN_USER, 0, -2 );
$J = 0;
for ( ; $J < count( $USER_ARRAY ); ++$J )
{
if ( $USER_ARRAY[$J]['DEPT'] == $DEPT_ID )
{
echo " <tr>\r\n <td nowrap align=\"center\" class=\"TableContent\" rowspan=\"2\">";
echo $DEPT_NAME;
echo "</td>\r\n <td align=\"center\" class=\"TableData\" width=\"40\">已阅读</td>\r\n <td align=\"left\" class=\"TableData\">";
echo $USER_ARRAY[$J]['USER'];
echo "</td>\r\n </tr>\r\n <tr>\r\n <td align=\"center\" class=\"TableData\" width=\"40\">未阅读</td>\r\n <td align=\"left\" class=\"TableLine1\">";
echo $UN_USER;
echo "</td>\r\n </tr>\r\n";
}
}
}
echo " <tr class=\"TableControl\">\r\n <td colspan=\"3\" align=\"center\">\r\n <input type=\"button\" value=\"打印\" class=\"BigButton\" onclick=\"document.execCommand('Print');\" title=\"直接打印表格页面\"> \r\n <input type=\"button\" value=\"关闭\" class=\"BigButton\" onClick=\"window.close();\" title=\"关闭窗口\">\r\n </td>\r\n </tr>\r\n</table>\r\n";
}
else
{
message( "", "无人查阅！" );
}
echo "\r\n</body>\r\n</html>";
?>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -