dept_res.php
来自「通达OA2007SE源代码 非常好的」· PHP 代码 · 共 179 行
PHP
179 行
<?
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);
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>
';
echo ' <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'];
$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);
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 != '') AND ($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 != '') AND ($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 '
<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 + =
减小字号Ctrl + -
显示快捷键?