📄 show_detail.php
字号:
<?php
function child_in_toid( $TO_ID, $DEPT_ID )
{
global $connection;
$query = "SELECT * 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 $connection;
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;
$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'];
$DEPT_PARENT = $ROW['DEPT_PARENT'];
$TEL_NO = $ROW['TEL_NO'];
$FAX_NO = $ROW['FAX_NO'];
$DEPT_FUNC = $ROW['DEPT_FUNC'];
if ( $TO_ID != "ALL_DEPT" && !find_id( $TO_ID, $DEPT_ID ) || !child_in_toid( $TO_ID, $DEPT_ID ) )
{
}
else
{
$DEPT_NAME = str_replace( "<", "<", $DEPT_NAME );
$DEPT_NAME = str_replace( ">", ">", $DEPT_NAME );
$DEPT_NAME = stripslashes( $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 * from USER where DEPT_ID=".$DEPT_ID." 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 ( $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, 30 ).( 30 < strlen( $USER_NAME_STR ) ? "..." : "" ).( "</td>\r\n <td style=\"cursor:hand\" title=\"".$UN_USER."\">" ).csubstr( strip_tags( $UN_USER ), 0, 30 ).( 30 < 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(NOTIFY_ID)\r\n{\r\n msg='确认要清空查阅情况么?';\r\n if(window.confirm(msg))\r\n {\r\n URL=\"delete_reader.php?NOTIFY_ID=\" + NOTIFY_ID;\r\n window.location=URL;\r\n }\r\n}\r\n</script>\r\n</head>\r\n\r\n";
$query = "SELECT * from NOTIFY where NOTIFY_ID=".$NOTIFY_ID;
$cursor = exequery( $connection, $query );
if ( $ROW = mysql_fetch_array( $cursor ) )
{
$SUBJECT = $ROW['SUBJECT'];
$TO_ID = $ROW['TO_ID'];
$TO_ID_REAL = $ROW['TO_ID'];
$PRIV_ID = $ROW['PRIV_ID'];
$USER_ID_TO = $ROW['USER_ID'];
$READERS = $ROW['READERS'];
}
if ( $TO_ID != "ALL_DEPT" )
{
$TOK = strtok( $PRIV_ID, "," );
while ( $TOK != "" )
{
$query1 = "SELECT * from USER where USER_PRIV='".$TOK."'";
$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 * 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( "," );
}
}
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\"><span class=\"big3\"> 查阅情况 - ";
echo $SUBJECT;
echo "</span>\r\n <input type=\"button\" value=\"清空查阅情况\" class=\"SmallButton\" onclick=\"delete_reader(";
echo $NOTIFY_ID;
echo ");\">\r\n </td>\r\n </tr>\r\n</table>\r\n<br>\r\n";
$READ_COUNT = $UN_READ_COUNT = 0;
$OPTION_TEXT = dept_tree_list( 0, 0 );
if ( $OPTION_TEXT == "" )
{
message( "提示", "无人查阅" );
}
else
{
echo " <table class=\"TableList\" align=\"center\" width=\"100%\">\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 " <tr 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 </tr>\r\n </table>\r\n";
}
echo "\r\n</body>\r\n</html>";
?>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -