📄 dept_res.php
字号:
<?
function tree_size ($SORT_ID)
{
global $CONTENT_COUNT;
$connection = openconnection ();
$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);
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;
$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 '
<html>
<head>
<title>系统资源状况查询</title>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
</head>
<body class="bodycolor" topmargin="5">
<table border="0" cellspacing="1" width="95%" class="small" bgcolor="#000000" cellpadding="3" align="center">
<tr class="TableHeader">
<td nowrap align="center"><b>用户</b></td>
<td nowrap align="center"><b>内部邮件</b></td>
<td nowrap align="center"><b>个人文件柜</b></td>
</tr>
';
$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'];
$query = 'SELECT * from EMAIL where TO_ID=\'' . $USER_ID . '\' and SEND_FLAG=\'1\' and DELETE_FLAG!=\'1\'';
$cursor1 = exequery ($connection, $query);
$INBOX_COUNT = 0;
$EMAIL_SIZE1 = 0;
while ($ROW = mysql_fetch_array ($cursor1))
{
++$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\'';
$cursor1 = exequery ($connection, $query);
$OUTBOX_COUNT = 0;
$EMAIL_SIZE2 = 0;
while ($ROW = mysql_fetch_array ($cursor1))
{
++$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=\'1\'';
$cursor1 = exequery ($connection, $query);
$SENTBOX_COUNT = 0;
$EMAIL_SIZE3 = 0;
while ($ROW = mysql_fetch_array ($cursor1))
{
++$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, '.', ',');
$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);
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, '.', ',');
$TableText1 = '';
$TableText2 = '';
if ($EMAIL_CAPACITY != '')
{
if ($EMAIL_CAPACITY != 0)
{
if ($EMAIL_CAPACITY * 1024 * 1024 <= $EMAIL_SIZE)
{
$TableText1 = 'TextColor2';
}
else
{
if ($EMAIL_CAPACITY * 1024 * 1024 * 0.800000000000000044408921 <= $EMAIL_SIZE)
{
$TableText1 = 'TextColor1';
}
else
{
$TableText1 = '';
}
}
}
}
if ($FOLDER_CAPACITY != '')
{
if ($FOLDER_CAPACITY != 0)
{
if ($FOLDER_CAPACITY * 1024 * 1024 <= $SORT_ALL_SIZE)
{
$TableText2 = 'TextColor2';
}
else
{
if ($FOLDER_CAPACITY * 1024 * 1024 * 0.800000000000000044408921 <= $SORT_ALL_SIZE)
{
$TableText2 = 'TextColor1';
}
else
{
$TableText2 = '';
}
}
}
}
echo '
<tr class="TableData">
<td width="80" align="center">';
echo $USER_NAME;
echo '</td>
<td align="right" class="';
echo $TableText1;
echo '">';
echo $EMAIL_SIZE4;
echo ' 字节 （约合';
echo $EMAIL_SIZE4_M;
echo 'M）</td>
<td align="right" class="';
echo $TableText2;
echo '">';
echo $SORT_SIZE;
echo ' 字节 （约合';
echo $SORT_SIZE_M;
echo 'M）</td>
</tr>
';
}
echo '</table>
</body>
</html>
';
?>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -