📄 user_res.php

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

function tree_size( $SORT_ID )
{
	global $CONTENT_COUNT;
	$connection = openconnection( );
	$query = "select * from FILE_CONTENT where SORT_ID=".$SORT_ID;
	$cursor = exequery( $connection, $query );
	$SORT_SIZE = 0;
	while ( $ROW = mysql_fetch_array( $cursor ) )
	{
		++$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;
	$cursor = exequery( $connection, $query );
	while ( $ROW = mysql_fetch_array( $cursor ) )
	{
		$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\r\n";
$query = "SELECT * from USER where USER_ID='".$USER_ID."'";
$cursor = exequery( $connection, $query );
if ( $ROW = mysql_fetch_array( $cursor ) )
{
	$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'";
$cursor = exequery( $connection, $query );
if ( $ROW = mysql_fetch_array( $cursor ) )
{
	$EMAIL_SIZE1 = $ROW[0];
}
$query = "SELECT count(*) 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'";
$cursor = exequery( $connection, $query );
if ( $ROW = mysql_fetch_array( $cursor ) )
{
	$INBOX_COUNT = $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'";
$cursor = exequery( $connection, $query );
if ( $ROW = mysql_fetch_array( $cursor ) )
{
	$EMAIL_SIZE2 = $ROW[0];
}
$query = "SELECT count(*) from EMAIL,EMAIL_BODY where EMAIL.BODY_ID=EMAIL_BODY.BODY_ID and FROM_ID='".$USER_ID."' and SEND_FLAG='0'";
$cursor = exequery( $connection, $query );
if ( $ROW = mysql_fetch_array( $cursor ) )
{
	$OUTBOX_COUNT = $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'";
$cursor = exequery( $connection, $query );
if ( $ROW = mysql_fetch_array( $cursor ) )
{
	$EMAIL_SIZE3 = $ROW[0];
}
$query = "SELECT count(*) 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'";
$cursor = exequery( $connection, $query );
if ( $ROW = mysql_fetch_array( $cursor ) )
{
	$SENTBOX_COUNT = $ROW[0];
}
$EMAIL_SIZE4 = $EMAIL_SIZE1 + $EMAIL_SIZE2 + $EMAIL_SIZE3;
$EMAIL_SIZE1_M = number_format( $EMAIL_SIZE1 / 1024 / 1024, 2, ".", "," );
$EMAIL_SIZE1 = number_format( $EMAIL_SIZE1, 0, ".", "," );
$EMAIL_SIZE2_M = number_format( $EMAIL_SIZE2 / 1024 / 1024, 2, ".", "," );
$EMAIL_SIZE2 = number_format( $EMAIL_SIZE2, 0, ".", "," );
$EMAIL_SIZE3_M = number_format( $EMAIL_SIZE3 / 1024 / 1024, 2, ".", "," );
$EMAIL_SIZE3 = number_format( $EMAIL_SIZE3, 0, ".", "," );
$EMAIL_SIZE = $EMAIL_SIZE4;
$EMAIL_SIZE4_M = number_format( $EMAIL_SIZE4 / 1024 / 1024, 2, ".", "," );
$EMAIL_SIZE4 = number_format( $EMAIL_SIZE4, 0, ".", "," );
$CONTENT_COUNT = 0;
$query = "select * from FILE_SORT where SORT_TYPE=4 and USER_ID='".$USER_ID."' and SORT_PARENT=0";
$cursor = exequery( $connection, $query );
$SORT_SIZE = 0;
while ( $ROW = mysql_fetch_array( $cursor ) )
{
	$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."'";
$cursor = exequery( $connection, $query );
while ( $ROW = mysql_fetch_array( $cursor ) )
{
	++$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, ".", "," );
echo "\r\n<table align=\"center\">\r\n<tr>\r\n<td>\r\n\r\n<table border=\"0\" cellspacing=\"1\" width=\"400\" 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\">邮件数</td>\r\n      <td nowrap align=\"center\">大小(";
if ( $EMAIL_CAPACITY != 0 )
{
	echo $EMAIL_CAPACITY."MB";
}
else
{
	echo "无限制";
}
echo ")</td>\r\n    </tr>\r\n    <tr class=\"TableData\">\r\n      <td nowrap>收件箱(包括自建邮箱)</td>\r\n      <td align=\"center\">";
echo $INBOX_COUNT;
echo "</td>\r\n      <td>";
echo $EMAIL_SIZE1;
echo " 字节 （约合";
echo $EMAIL_SIZE1_M;
echo "M）</td>\r\n    </tr>\r\n    <tr class=\"TableData\">\r\n      <td nowrap>发件箱</td>\r\n      <td align=\"center\">";
echo $OUTBOX_COUNT;
echo "</td>\r\n      <td>";
echo $EMAIL_SIZE2;
echo " 字节 （约合";
echo $EMAIL_SIZE2_M;
echo "M）</td>\r\n    </tr>\r\n    <tr class=\"TableData\">\r\n      <td nowrap>已发送邮件箱</td>\r\n      <td align=\"center\">";
echo $SENTBOX_COUNT;
echo "</td>\r\n      <td>";
echo $EMAIL_SIZE3;
echo " 字节 （约合";
echo $EMAIL_SIZE3_M;
echo "M）</td>\r\n    </tr>\r\n    <tr class=\"TableControl\">\r\n      <td nowrap><b>合计</b></td>\r\n      <td align=\"center\">";
echo $INBOX_COUNT + $OUTBOX_COUNT + $SENTBOX_COUNT;
echo "</td>\r\n      <td>";
echo $EMAIL_SIZE4;
echo " 字节 （约合";
echo $EMAIL_SIZE4_M;
echo "M）</td>\r\n    </tr>\r\n</table>\r\n\r\n<br>\r\n<table border=\"0\" cellspacing=\"1\" width=\"400\" 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\">文件数</td>\r\n      <td nowrap align=\"center\">大小(";
if ( $FOLDER_CAPACITY != 0 )
{
	echo $FOLDER_CAPACITY."MB";
}
else
{
	echo "无限制";
}
echo ")</td>\r\n    </tr>\r\n    <tr class=\"TableControl\">\r\n      <td nowrap><b>合计</b></td>\r\n      <td align=\"center\">";
echo $CONTENT_COUNT;
echo "</td>\r\n      <td>";
echo $SORT_SIZE;
echo " 字节 （约合";
echo $SORT_SIZE_M;
echo "M）</td>\r\n    </tr>\r\n</table>\r\n</td>\r\n</tr>\r\n\r\n<thead>\r\n<td>\r\n";
$ALL_SIZE = $EMAIL_SIZE + $SORT_ALL_SIZE;
$ALL_SIZE_M = number_format( $ALL_SIZE / 1024 / 1024, 2, ".", "," );
message( "总合计：".$ALL_SIZE_M." M", "用户：".$USER_NAME );
echo "</td>\r\n</table>\r\n\r\n</body>\r\n</html>\r\n";
?>
⌨️ 快捷键说明

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