⭐ 欢迎来到虫虫下载站! | 📦 资源下载 📁 资源专辑 ℹ️ 关于我们
⭐ 虫虫下载站

📄 show_detail.php

📁 通达网络办公 - Office Anywhere 2008 增强版100%源码(3.4.081216) 内含 通达OA2008增強版接近完美破解补丁20081216集 及 最新通达OA2008ADV(
💻 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( "<", "&lt", $DEPT_NAME );
			$DEPT_NAME = str_replace( ">", "&gt", $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      &nbsp;&nbsp;&nbsp;<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 + -