user_res.php

来自「极限网络智能办公系统 Office Automation V3.0官方100％源」· PHP 代码 · 共 261 行

PHP
261 行
字号 
<?
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);
		for ($I = 0; $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 '
<html>
<head>
<title>系统资源状况查询</title>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
</head>
<body class="bodycolor" topmargin="5">
';
$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'];
	$EMAIL_CAPACITY = $ROW['EMAIL_CAPACITY'];
	$FOLDER_CAPACITY = $ROW['FOLDER_CAPACITY'];
}
$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);
	for ($I = 0; $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);
	for ($I = 0; $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!=\'2\'';
$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);
	for ($I = 0; $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);
}
$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);
	for ($I = 0; $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 '
<table align="center">
<tr>
<td>
<table border="0" cellspacing="1" width="400" class="small" bgcolor="#000000" cellpadding="3" align="center">
	<tr class="TableHeader">
		<td nowrap align="center"><b>内部邮件</b></td>
		<td nowrap align="center">邮件数</td>
		<td nowrap align="center">大小(';
if ($EMAIL_CAPACITY != 0)
{
	echo $EMAIL_CAPACITY . 'MB';
}
else
{
	echo '无限制';
}
echo ')</td>
	</tr>
	<tr class="TableData">
		<td nowrap>收件箱(包括自建邮箱)</td>
		<td align="center">';
echo $INBOX_COUNT;
echo '</td>
		<td>';
echo $EMAIL_SIZE1;
echo ' 字节 （约合';
echo $EMAIL_SIZE1_M;
echo 'M）</td>
	</tr>
	<tr class="TableData">
		<td nowrap>发件箱</td>
		<td align="center">';
echo $OUTBOX_COUNT;
echo '</td>
		<td>';
echo $EMAIL_SIZE2;
echo ' 字节 （约合';
echo $EMAIL_SIZE2_M;
echo 'M）</td>
	</tr>
	<tr class="TableData">
		<td nowrap>已发送邮件箱</td>
		<td align="center">';
echo $SENTBOX_COUNT;
echo '</td>
		<td>';
echo $EMAIL_SIZE3;
echo ' 字节 （约合';
echo $EMAIL_SIZE3_M;
echo 'M）</td>
	</tr>
	<tr class="TableControl">
		<td nowrap><b>合计</b></td>
		<td align="center">';
echo $INBOX_COUNT + $OUTBOX_COUNT + $SENTBOX_COUNT;
echo '</td>
		<td>';
echo $EMAIL_SIZE4;
echo ' 字节 （约合';
echo $EMAIL_SIZE4_M;
echo 'M）</td>
	</tr>
</table>
<br>
<table border="0" cellspacing="1" width="400" class="small" bgcolor="#000000" cellpadding="3" align="center">
	<tr class="TableHeader">
		<td nowrap align="center"><b>个人文件柜</b></td>
		<td nowrap align="center">文件数</td>
		<td nowrap align="center">大小(';
if ($FOLDER_CAPACITY != 0)
{
	echo $FOLDER_CAPACITY . 'MB';
}
else
{
	echo '无限制';
}
echo ')</td>
	</tr>
	<tr class="TableControl">
		<td nowrap><b>合计</b></td>
		<td align="center">';
echo $CONTENT_COUNT;
echo '</td>
		<td>';
echo $SORT_SIZE;
echo ' 字节 （约合';
echo $SORT_SIZE_M;
echo 'M）</td>
	</tr>
</table>
</td>
</tr>
<thead>
<td>
';
$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>
</table>
</body>
</html>
';
?>

user_res.php - 源码说明

本页面展示了「极限网络智能办公系统 Office Automation V3.0官方100％源代码.」中的 user_res.php 源码文件，采用 PHP 编程语言编写，共 261 行代码。您可以在线阅读完整代码内容，也可以返回资源详情页下载完整源码包进行本地学习和开发。

虫虫下载站收录了大量与Automation相关的技术资源，包括源代码、技术文档、电路图等，是电子工程师和嵌入式开发者的专业学习平台。

⌨️ 快捷键说明

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