📄 show_reader.php
字号:
<?php
function child_in_toid( $TO_ID, $DEPT_ID )
{
global $connection;
$query = "SELECT DEPT_ID from DEPARTMENT where DEPT_PARENT=".$DEPT_ID;
$cursor = exequery( $connection, $query );
while ( $ROW = mysql_fetch_array( $cursor ) )
{
$DEPT_ID = $ROW['DEPT_ID'];
if ( find_id( $TO_ID, $DEPT_ID ) )
{
return 1;
}
$VALUE = child_in_toid( $TO_ID, $DEPT_ID );
}
return $VALUE;
}
function dept_tree_list( $DEPT_ID, $PRIV_OP )
{
global $DEEP_COUNT;
global $READERS;
global $TO_ID;
global $READ_COUNT;
global $UN_READ_COUNT;
global $USER_ID_TO;
global $PRIV_ID;
global $TO_ID_REAL;
global $DISPLAY_ALL;
$connection = openconnection( );
$query = "SELECT * from DEPARTMENT where DEPT_PARENT=".$DEPT_ID." order by DEPT_NO";
$cursor = exequery( $connection, $query );
$OPTION_TEXT = "";
$DEEP_COUNT1 = $DEEP_COUNT;
$DEEP_COUNT .= " ";
while ( $ROW = mysql_fetch_array( $cursor ) )
{
++$COUNT;
$DEPT_ID = $ROW['DEPT_ID'];
$DEPT_NAME = $ROW['DEPT_NAME'];
if ( $TO_ID != "ALL_DEPT" && !find_id( $TO_ID, $DEPT_ID ) || !child_in_toid( $TO_ID, $DEPT_ID ) )
{
$DEPT_NAME = htmlspecialchars( $DEPT_NAME );
$DEPT_PRIV = 1;
$OPTION_TEXT_CHILD = dept_tree_list( $DEPT_ID, $PRIV_OP );
$UN_USER = "";
$USER_NAME_STR = "";
if ( $TO_ID == "ALL_DEPT" || find_id( $TO_ID, $DEPT_ID ) )
{
$query = "select USER_ID,USER_PRIV,USER_NAME from USER where DEPT_ID=".$DEPT_ID." and NOT_LOGIN='0' order by USER_NO,USER_NAME";
$cursor1 = exequery( $connection, $query );
while ( $ROW1 = mysql_fetch_array( $cursor1 ) )
{
$USER_ID = $ROW1['USER_ID'];
$USER_PRIV = $ROW1['USER_PRIV'];
$USER_NAME = $ROW1['USER_NAME'];
if ( find_id( $READERS, $USER_ID ) )
{
$USER_NAME_STR .= $USER_NAME."，";
++$READ_COUNT;
}
else if ( !( $TO_ID == "ALL_DEPT" ) || !find_id( $TO_ID_REAL, $DEPT_ID ) || !child_in_toid( $TO_ID_REAL, $DEPT_ID ) || !find_id( $PRIV_ID, $USER_PRIV ) || !find_id( $USER_ID_TO, $USER_ID ) )
{
$UN_USER .= $USER_NAME."，";
++$UN_READ_COUNT;
}
}
$USER_NAME_STR = substr( $USER_NAME_STR, 0, -2 );
$UN_USER = substr( $UN_USER, 0, -2 );
}
if ( $DISPLAY_ALL == "" )
{
$READ_LEN = 30;
$UNREAD_LEN = 30;
}
else
{
$READ_LEN = strlen( $USER_NAME_STR );
$UNREAD_LEN = strlen( $UN_USER );
}
if ( $DEPT_PRIV == 1 )
{
$OPTION_TEXT .= "\r\n <tr class=TableData>\r\n <td class=\"TableContent\">".$DEEP_COUNT1."├".$DEPT_NAME.( "</td>\r\n <td style=\"cursor:hand\" title=\"".$USER_NAME_STR."\">" ).csubstr( strip_tags( $USER_NAME_STR ), 0, $READ_LEN ).( $READ_LEN < strlen( $USER_NAME_STR ) ? "..." : "" ).( "</td>\r\n <td style=\"cursor:hand\" title=\"".$UN_USER."\">" ).csubstr( strip_tags( $UN_USER ), 0, $UNREAD_LEN ).( $UNREAD_LEN < strlen( $UN_USER ) ? "..." : "" )."</td>\r\n </tr>";
}
if ( $OPTION_TEXT_CHILD != "" )
{
$OPTION_TEXT .= $OPTION_TEXT_CHILD;
}
}
}
$DEEP_COUNT = $DEEP_COUNT1;
return $OPTION_TEXT;
}
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<script>\r\nfunction delete_reader(CONTENT_ID)\r\n{\r\n msg='确认要清空签阅情况么？';\r\n if(window.confirm(msg))\r\n {\r\n URL=\"delete_reader.php?CONTENT_ID=\" + CONTENT_ID;\r\n window.location=URL;\r\n }\r\n}\r\n</script>\r\n</head>\r\n\r\n";
$query = "SELECT USER_ID from FILE_SORT where SORT_ID='".$SORT_ID."'";
$cursor = exequery( $connection, $query );
if ( $ROW = mysql_fetch_array( $cursor ) )
{
$USER_ID = $ROW['USER_ID'];
$USER_ARRAY = explode( "|", $USER_ID );
list( $TO_ID_REAL, $TO_ID ) = $USER_ARRAY;
$PRIV_ID = $USER_ARRAY[1];
$USER_ID_TO = $USER_ARRAY[2];
}
if ( $TO_ID != "ALL_DEPT" )
{
$TOK = strtok( $PRIV_ID, "," );
while ( $TOK != "" )
{
$query1 = "SELECT DEPT_ID from USER where USER_PRIV='".$TOK."' and NOT_LOGIN='0'";
$cursor1 = exequery( $connection, $query1 );
while ( $ROW = mysql_fetch_array( $cursor1 ) )
{
$DEPT_ID = $ROW['DEPT_ID'];
if ( !find_id( $TO_ID, $DEPT_ID ) )
{
$TO_ID .= $DEPT_ID.",";
}
}
$TOK = strtok( "," );
}
}
if ( $TO_ID != "ALL_DEPT" )
{
$TOK = strtok( $USER_ID_TO, "," );
while ( $TOK != "" )
{
$query1 = "SELECT DEPT_ID from USER where USER_ID='".$TOK."'";
$cursor1 = exequery( $connection, $query1 );
if ( $ROW = mysql_fetch_array( $cursor1 ) )
{
$DEPT_ID = $ROW['DEPT_ID'];
if ( !find_id( $TO_ID, $DEPT_ID ) )
{
$TO_ID .= $DEPT_ID.",";
}
}
$TOK = strtok( "," );
}
}
$query = "SELECT SUBJECT,READERS from FILE_CONTENT where CONTENT_ID=".$CONTENT_ID;
$cursor = exequery( $connection, $query );
if ( $ROW = mysql_fetch_array( $cursor ) )
{
$SUBJECT = $ROW['SUBJECT'];
$SUBJECT = htmlspecialchars( $SUBJECT );
$READERS = $ROW['READERS'];
}
echo "<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/file_folder.gif\" WIDTH=\"22\" HEIGHT=\"20\" align=\"absmiddle\"><span class=\"big3\"> 签阅情况 — ";
echo $SUBJECT;
echo "</span>\r\n <input type=\"button\" value=\"清空签阅情况\" class=\"SmallButton\" onclick=\"delete_reader(";
echo $CONTENT_ID;
echo ");\">\r\n <input type=\"button\" value=\"完整显示签阅情况\" class=\"SmallButton\" onclick=\"location='";
echo $REQUEST_URI;
echo "&DISPLAY_ALL=1'\">\r\n </td>\r\n </tr>\r\n</table>\r\n\r\n";
$READ_COUNT = $UN_READ_COUNT = 0;
$OPTION_TEXT = dept_tree_list( 0, 0 );
if ( $OPTION_TEXT == "" )
{
message( "提示", "无人签阅" );
}
else
{
echo " <table border=\"0\" align=\"center\" cellspacing=\"1\" width=\"100%\" class=\"small\" bgcolor=\"#000000\" cellpadding=\"3\">\r\n <tr>\r\n <td class=\"TableHeader\" align=\"center\" colspan=\"3\">";
echo $SUBJECT;
echo "</td>\r\n </tr>\r\n <tr class=\"TableHeader\">\r\n <td nowrap align=\"center\">部门/成员单位</td>\r\n <td nowrap align=\"center\">已读人员</td>\r\n <td nowrap align=\"center\">未读人员</td>\r\n </tr>\r\n ";
echo $OPTION_TEXT;
echo " <tfoot class=\"TableControl\">\r\n <td nowrap align=\"center\"><b>合计：</b></td>\r\n <td nowrap align=\"center\"><b>";
echo $READ_COUNT;
echo "</b></td>\r\n <td nowrap align=\"center\"><b>";
echo $UN_READ_COUNT;
echo "</b></td>\r\n </tfoot>\r\n </table>\r\n";
}
echo "\r\n</body>\r\n</html>";
?>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -