user_res.php

来自「通达OA2007SE源代码非常好的」· PHP 代码 · 共 237 行
PHP
237 行
<?
  function tree_size ($SORT_ID)
  {
    global $CONTENT_COUNT;
    global $connection;
    $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">
';
  $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);
    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 - 源码说明

本页面展示了「通达OA2007SE源代码非常好的」中的 user_res.php 源码文件，采用 PHP 编程语言编写，共 237 行代码。您可以在线阅读完整代码内容，也可以返回资源详情页下载完整源码包进行本地学习和开发。
虫虫下载站收录了大量与2007相关的技术资源，包括源代码、技术文档、电路图等，是电子工程师和嵌入式开发者的专业学习平台。
⌨️ 快捷键说明

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