📄 dept_res.php

📁 极限网络智能办公系统 - Office Automation 2008 官方100％源码
💻 PHP
字号:
<?php
 

function tree_size( $SORT_ID )
{
	global $CONTENT_COUNT;
	global $connection;
	$query = "select * from FILE_CONTENT where SORT_ID=".$SORT_ID;
	$cursor2 = exequery( $connection, $query );
	$SORT_SIZE = 0;
	while ( $ROW = mysql_fetch_array( $cursor2 ) )
	{
		++$CONTENT_COUNT;
		$SUBJECT = $ROW['SUBJECT'];
		$CONTENT = $ROW['CONTENT'];
		$ATTACHMENT_ID = $ROW['ATTACHMENT_ID'];
		$ATTACHMENT_NAME = $ROW['ATTACHMENT_NAME'];
		$SORT_SIZE += strlen( $CONTENT ) + strlen( $SUBJECT );
		$ATTACHMENT_ID_ARRAY = explode( ",", $ATTACHMENT_ID );
		$ATTACHMENT_NAME_ARRAY = explode( "*", $ATTACHMENT_NAME );
		$ARRAY_COUNT = sizeof( $ATTACHMENT_ID_ARRAY );
		$I = 0;
		for ( ;	$I < $ARRAY_COUNT - 1;	++$I	)
		{
			$SORT_SIZE += attach_size( $ATTACHMENT_ID_ARRAY[$I], $ATTACHMENT_NAME_ARRAY[$I] );
		}
	}
	$query = "select * from FILE_SORT where SORT_PARENT=".$SORT_ID;
	$cursor2 = exequery( $connection, $query );
	while ( $ROW = mysql_fetch_array( $cursor2 ) )
	{
		$SORT_ID = $ROW['SORT_ID'];
		$SORT_SIZE += tree_size( $SORT_ID );
	}
	return $SORT_SIZE;
}

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\r\n<body class=\"bodycolor\" topmargin=\"5\">\r\n<table border=\"0\" cellspacing=\"1\" width=\"95%\" class=\"small\" bgcolor=\"#000000\" cellpadding=\"3\" align=\"center\">\r\n    <tr class=\"TableHeader\">\r\n      <td nowrap align=\"center\"><b>用户</b></td>\r\n      <td nowrap align=\"center\"><b>内部邮件</b></td>\r\n      <td nowrap align=\"center\"><b>个人文件柜</b></td>\r\n    </tr>\r\n";
$CONTENT_COUNT = 0;
$query = "SELECT * from USER where DEPT_ID='".$DEPT_ID."' order by USER_NO";
$cursor = exequery( $connection, $query );
while ( $ROW = mysql_fetch_array( $cursor ) )
{
	$USER_ID = $ROW['USER_ID'];
	$USER_NAME = $ROW['USER_NAME'];
	$EMAIL_CAPACITY = $ROW['EMAIL_CAPACITY'];
	$FOLDER_CAPACITY = $ROW['FOLDER_CAPACITY'];
	$EMAIL_SIZE1 = 0;
	$query = "SELECT sum(SIZE) from EMAIL,EMAIL_BODY where EMAIL.BODY_ID=EMAIL_BODY.BODY_ID and TO_ID='".$USER_ID."' and SEND_FLAG='1' and DELETE_FLAG!='1'";
	$cursor1 = exequery( $connection, $query );
	if ( $ROW = mysql_fetch_array( $cursor1 ) )
	{
		$EMAIL_SIZE1 = $ROW[0];
	}
	$EMAIL_SIZE2 = 0;
	$query = "SELECT sum(SIZE) from EMAIL,EMAIL_BODY where EMAIL.BODY_ID=EMAIL_BODY.BODY_ID and FROM_ID='".$USER_ID."' and SEND_FLAG='0'";
	$cursor1 = exequery( $connection, $query );
	if ( $ROW = mysql_fetch_array( $cursor1 ) )
	{
		$EMAIL_SIZE2 = $ROW[0];
	}
	$EMAIL_SIZE3 = 0;
	$query = "SELECT sum(SIZE) from EMAIL,EMAIL_BODY where EMAIL.BODY_ID=EMAIL_BODY.BODY_ID and FROM_ID='".$USER_ID."' and SEND_FLAG='1' and DELETE_FLAG!='2' and DELETE_FLAG!='4' group by EMAIL.BODY_ID";
	$cursor1 = exequery( $connection, $query );
	if ( $ROW = mysql_fetch_array( $cursor1 ) )
	{
		$EMAIL_SIZE3 = $ROW[0];
	}
	$EMAIL_SIZE4 = $EMAIL_SIZE1 + $EMAIL_SIZE2 + $EMAIL_SIZE3;
	$EMAIL_SIZE = $EMAIL_SIZE4;
	$EMAIL_SIZE4_M = number_format( $EMAIL_SIZE4 / 1024 / 1024, 2, ".", "," );
	$EMAIL_SIZE4 = number_format( $EMAIL_SIZE4, 0, ".", "," );
	$query = "select * from FILE_SORT where SORT_TYPE=4 and USER_ID='".$USER_ID."' and SORT_PARENT=0";
	$cursor1 = exequery( $connection, $query );
	$SORT_SIZE = 0;
	while ( $ROW = mysql_fetch_array( $cursor1 ) )
	{
		$SORT_ID = $ROW['SORT_ID'];
		$SORT_SIZE += tree_size( $SORT_ID );
	}
	$query = "SELECT * from FILE_CONTENT where SORT_ID=0 and  USER_ID='".$USER_ID."'";
	$cursor1 = exequery( $connection, $query );
	while ( $ROW = mysql_fetch_array( $cursor1 ) )
	{
		++$CONTENT_COUNT;
		$SUBJECT = $ROW['SUBJECT'];
		$CONTENT = $ROW['CONTENT'];
		$ATTACHMENT_ID = $ROW['ATTACHMENT_ID'];
		$ATTACHMENT_NAME = $ROW['ATTACHMENT_NAME'];
		$SORT_SIZE += strlen( $CONTENT ) + strlen( $SUBJECT );
		$ATTACHMENT_ID_ARRAY = explode( ",", $ATTACHMENT_ID );
		$ATTACHMENT_NAME_ARRAY = explode( "*", $ATTACHMENT_NAME );
		$ARRAY_COUNT = sizeof( $ATTACHMENT_ID_ARRAY );
		$I = 0;
		for ( ;	$I < $ARRAY_COUNT - 1;	++$I	)
		{
			$SORT_SIZE += attach_size( $ATTACHMENT_ID_ARRAY[$I], $ATTACHMENT_NAME_ARRAY[$I] );
		}
	}
	$SORT_ALL_SIZE = $SORT_SIZE;
	$SORT_SIZE_M = number_format( $SORT_SIZE / 1024 / 1024, 2, ".", "," );
	$SORT_SIZE = number_format( $SORT_SIZE, 0, ".", "," );
	$TableText1 = "";
	$TableText2 = "";
	if ( $EMAIL_CAPACITY != "" && $EMAIL_CAPACITY != 0 )
	{
		if ( $EMAIL_CAPACITY * 1024 * 1024 <= $EMAIL_SIZE )
		{
			$TableText1 = "TextColor2";
		}
		else if ( $EMAIL_CAPACITY * 1024 * 1024 * 0.8 <= $EMAIL_SIZE )
		{
			$TableText1 = "TextColor1";
		}
		else
		{
			$TableText1 = "";
		}
	}
	if ( $FOLDER_CAPACITY != "" && $FOLDER_CAPACITY != 0 )
	{
		if ( $FOLDER_CAPACITY * 1024 * 1024 <= $SORT_ALL_SIZE )
		{
			$TableText2 = "TextColor2";
		}
		else if ( $FOLDER_CAPACITY * 1024 * 1024 * 0.8 <= $SORT_ALL_SIZE )
		{
			$TableText2 = "TextColor1";
		}
		else
		{
			$TableText2 = "";
		}
	}
	echo "\r\n    <tr class=\"TableData\">\r\n      <td width=\"80\" align=\"center\">";
	echo $USER_NAME;
	echo "</td>\r\n      <td align=\"right\" class=\"";
	echo $TableText1;
	echo "\">";
	echo $EMAIL_SIZE4;
	echo " 字节 （约合";
	echo $EMAIL_SIZE4_M;
	echo "M）</td>\r\n      <td align=\"right\" class=\"";
	echo $TableText2;
	echo "\">";
	echo $SORT_SIZE;
	echo " 字节 （约合";
	echo $SORT_SIZE_M;
	echo "M）</td>\r\n    </tr>\r\n";
}
echo "</table>\r\n\r\n</body>\r\n</html>\r\n";
?>
⌨️ 快捷键说明

复制代码 Ctrl + C
搜索代码 Ctrl + F
全屏模式 F11
切换主题 Ctrl + Shift + D
显示快捷键 ?
增大字号 Ctrl + =
减小字号 Ctrl + -