📄 user_res.php

📁 极限网络智能办公系统—MYOA26—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";
$connection = openconnection( );
$query = "SELECT * from USER where USER_ID='{$USER_ID}'";
$cursor = exequery( $connection, $query );
if ( $ROW = mysql_fetch_array( $cursor ) )
{
	$USER_NAME = $ROW['USER_NAME'];
}
$query = "SELECT * from EMAIL where TO_ID='{$USER_ID}' and SEND_FLAG='1' and DELETE_FLAG!='1'";
$cursor = exequery( $connection, $query );
$INBOX_COUNT = 0;
$EMAIL_SIZE1 = 0;
while ( $ROW = mysql_fetch_array( $cursor ) )
{
	++$INBOX_COUNT;
	$SUBJECT = $ROW['SUBJECT'];
	$CONTENT = $ROW['CONTENT'];
	$ATTACHMENT_ID = $ROW['ATTACHMENT_ID'];
	$ATTACHMENT_NAME = $ROW['ATTACHMENT_NAME'];
	$EMAIL_SIZE1 += 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	)
	{
		$EMAIL_SIZE1 += attach_size( $ATTACHMENT_ID_ARRAY[$I], $ATTACHMENT_NAME_ARRAY[$I] );
	}
}
$query = "SELECT * from EMAIL where FROM_ID='{$USER_ID}' and SEND_FLAG='0'";
$cursor = exequery( $connection, $query );
$OUTBOX_COUNT = 0;
$EMAIL_SIZE2 = 0;
while ( $ROW = mysql_fetch_array( $cursor ) )
{
	++$OUTBOX_COUNT;
	$SUBJECT = $ROW['SUBJECT'];
	$CONTENT = $ROW['CONTENT'];
	$ATTACHMENT_ID = $ROW['ATTACHMENT_ID'];
	$ATTACHMENT_NAME = $ROW['ATTACHMENT_NAME'];
	$EMAIL_SIZE2 += 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	)
	{
		$EMAIL_SIZE2 += attach_size( $ATTACHMENT_ID_ARRAY[$I], $ATTACHMENT_NAME_ARRAY[$I] );
	}
}
$query = "SELECT * from EMAIL where FROM_ID='{$USER_ID}' and SEND_FLAG='1' and DELETE_FLAG='1'";
$cursor = exequery( $connection, $query );
$SENTBOX_COUNT = 0;
$EMAIL_SIZE3 = 0;
while ( $ROW = mysql_fetch_array( $cursor ) )
{
	++$SENTBOX_COUNT;
	$SUBJECT = $ROW['SUBJECT'];
	$CONTENT = $ROW['CONTENT'];
	$ATTACHMENT_ID = $ROW['ATTACHMENT_ID'];
	$ATTACHMENT_NAME = $ROW['ATTACHMENT_NAME'];
	$EMAIL_SIZE3 += 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	)
	{
		$EMAIL_SIZE3 += attach_size( $ATTACHMENT_ID_ARRAY[$I], $ATTACHMENT_NAME_ARRAY[$I] );
	}
}
$EMAIL_SIZE1_M = number_format( $EMAIL_SIZE1 / 1024 / 1024, 2, ".", "," );
$EMAIL_SIZE4 += $EMAIL_SIZE1;
$EMAIL_SIZE1 = number_format( $EMAIL_SIZE1, 0, ".", "," );
$EMAIL_SIZE2_M = number_format( $EMAIL_SIZE2 / 1024 / 1024, 2, ".", "," );
$EMAIL_SIZE4 += $EMAIL_SIZE2;
$EMAIL_SIZE2 = number_format( $EMAIL_SIZE2, 0, ".", "," );
$EMAIL_SIZE3_M = number_format( $EMAIL_SIZE3 / 1024 / 1024, 2, ".", "," );
$EMAIL_SIZE4 += $EMAIL_SIZE3;
$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 );
}
$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\">大小</td>\r\n    </tr>\r\n    <tr class=\"TableData\">\r\n      <td nowrap>收件箱(包括自建邮箱)</td>\r\n      <td al";
echo "ign=\"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\">文件大小</td>\r\n    </tr>\r\n    <tr class=\"TableControl\">\r\n      <td nowrap><b>合计</b></td>\r\n      <td align=";
echo "\"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";
?>
💿 文件大小 18785 K
👤 上传用户 johni
📂 所属分类 OA系统
🏷️ 相关标签

#MYOA #100 #26 #网络
⌨️ 快捷键说明

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