index.php

来自「通达OA2007SE源代码 非常好的」· PHP 代码 · 共 219 行

PHP
219 行
字号 
<?
  include_once 'inc/auth.php';
  include_once 'inc/utility_all.php';
  if (($_COOKIE['COUNT_EMAIL_SIZE'] == ''))
  {
    $query = (((((''.'SELECT EMAIL_BODY.BODY_ID,ATTACHMENT_ID,ATTACHMENT_NAME from EMAIL,EMAIL_BODY where EMAIL.BODY_ID=EMAIL_BODY.BODY_ID and (FROM_ID=\'').$LOGIN_USER_ID).'\' or TO_ID=\'').$LOGIN_USER_ID).'\') and ATTACHMENT_NAME!=\'\' and ATTACHMENT_ID!=\'\' and SIZE=\'0\'');
    $cursor = exequery ($connection, $query);
    while ($ROW = mysql_fetch_array ($cursor))
    {
      $BODY_ID = $ROW['BODY_ID'];
      $ATTACHMENT_ID = $ROW['ATTACHMENT_ID'];
      $ATTACHMENT_NAME = $ROW['ATTACHMENT_NAME'];
      $ATTACHMENT_ID_ARRAY = explode (',', $ATTACHMENT_ID);
      $ATTACHMENT_NAME_ARRAY = explode ('*', $ATTACHMENT_NAME);
      $SIZE = 0;
      for ($I = 0; ($I < (sizeof ($ATTACHMENT_ID_ARRAY) - 1)); ++$I)
      {
        ($SIZE += attach_size ($ATTACHMENT_ID_ARRAY[$I], $ATTACHMENT_NAME_ARRAY[$I]));
      }
      $query = ((((''.'update EMAIL_BODY set SIZE=\'').$SIZE).'\' where BODY_ID=').$BODY_ID);
      exequery ($connection, $query);
    }
    $_COOKIE['COUNT_EMAIL_SIZE'] = time ();
  }
  echo '
<html>
<head>
<title>内部邮件</title>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
';
  echo '<s';
  echo 'cript Language=JavaScript>
window.setTimeout(\'this.location.reload();\',60000);
function del_mail()
{
  msg=\'确认要删除所有废件箱的邮件？\';
  if(window.confirm(msg))
  {
    url="delbox/del_email.php?BOX_ID=0&PAGE_START=1";
    location=url;
  }
}
</script>
</head>
<body class="bodycolor" topmargin="5">
';
  $EMAIL_COUNT = 0;
  $NEW_COUNT = 0;
  $query = (((''.'SELECT count(*) from EMAIL,EMAIL_BODY where EMAIL.BODY_ID=EMAIL_BODY.BODY_ID and BOX_ID=0 and TO_ID=\'').$LOGIN_USER_ID).'\' and READ_FLAG!=\'1\' and (DELETE_FLAG=\'\' or DELETE_FLAG=\'0\' or DELETE_FLAG=\'2\')');
  $cursor = exequery ($connection, $query);
  $NEW_LETER_COUNT = 0;
  if ($ROW = mysql_fetch_array ($cursor))
  {
    $NEW_LETER_COUNT = $ROW[0];
  }
  $NEW_COUNT = $NEW_LETER_COUNT;
  $INBOX_COUNT = 0;
  $query = (((''.'SELECT count(*) from EMAIL,EMAIL_BODY where EMAIL.BODY_ID=EMAIL_BODY.BODY_ID and BOX_ID=0 and TO_ID=\'').$LOGIN_USER_ID).'\' and (DELETE_FLAG=\'\' or DELETE_FLAG=\'0\' or DELETE_FLAG=\'2\')');
  $cursor = exequery ($connection, $query);
  if ($ROW = mysql_fetch_array ($cursor))
  {
    $INBOX_COUNT = $ROW[0];
  }
  $OUTBOX_COUNT = 0;
  $query = (((''.'SELECT count(*) from EMAIL_BODY where FROM_ID=\'').$LOGIN_USER_ID).'\' and SEND_FLAG=\'0\'');
  $cursor = exequery ($connection, $query);
  if ($ROW = mysql_fetch_array ($cursor))
  {
    $OUTBOX_COUNT = $ROW[0];
  }
  $SENTBOX_COUNT = 0;
  $query = (((''.'SELECT count(*) from EMAIL,EMAIL_BODY where EMAIL.BODY_ID=EMAIL_BODY.BODY_ID and FROM_ID=\'').$LOGIN_USER_ID).'\' and DELETE_FLAG!=\'2\' and DELETE_FLAG!=\'4\'');
  $cursor = exequery ($connection, $query);
  if ($ROW = mysql_fetch_array ($cursor))
  {
    $SENTBOX_COUNT = $ROW[0];
  }
  $SENTBOX_COUNT1 = 0;
  $query = (((''.'SELECT count(*) from EMAIL,EMAIL_BODY where EMAIL.BODY_ID=EMAIL_BODY.BODY_ID and FROM_ID=\'').$LOGIN_USER_ID).'\' and DELETE_FLAG=\'1\'');
  $cursor = exequery ($connection, $query);
  if ($ROW = mysql_fetch_array ($cursor))
  {
    $SENTBOX_COUNT1 = $ROW[0];
  }
  $query = (((''.'SELECT count(*) from EMAIL,EMAIL_BODY where EMAIL.BODY_ID=EMAIL_BODY.BODY_ID and TO_ID=\'').$LOGIN_USER_ID).'\' and READ_FLAG!=\'1\' and (DELETE_FLAG=\'3\' or DELETE_FLAG=\'4\')');
  $cursor = exequery ($connection, $query);
  $NEW_DEL_COUNT = 0;
  if ($ROW = mysql_fetch_array ($cursor))
  {
    $NEW_DEL_COUNT = $ROW[0];
  }
  $DELBOX_COUNT = 0;
  $query = (((''.'SELECT count(*) from EMAIL,EMAIL_BODY where EMAIL.BODY_ID=EMAIL_BODY.BODY_ID and TO_ID=\'').$LOGIN_USER_ID).'\' and (DELETE_FLAG=\'3\' or DELETE_FLAG=\'4\')');
  $cursor = exequery ($connection, $query);
  if ($ROW = mysql_fetch_array ($cursor))
  {
    $DELBOX_COUNT = $ROW[0];
  }
  $EMAIL_COUNT = ((($INBOX_COUNT + $OUTBOX_COUNT) + $SENTBOX_COUNT) + $DELBOX_COUNT);
  echo '
<table border="0" width="100%" cellspacing="0" cellpadding="3" class="small">
  <tr>
    <td class="Big"><img src="/images/menu/email.gif" WIDTH="22" HEIGHT="18" align="absmiddle">';
  echo '<s';
  echo 'pan class="big3"> 内部邮件</span>
    </td>
    </tr>
</table>
<br>
<table border="0" cellspacing="1" width="450" class="small" bgcolor="#000000" cellpadding="5" align="center">
    <tr class="TableHeader">
      <td nowrap align="center" width="40%">邮件箱</td>
      <td nowrap align="center" width="60%">邮件数</td>
    </tr>
    <tr class="TableData">
      <td nowrap><img src="/images/inbox.gif';
  echo '" align="absMiddle">&nbsp;&nbsp;<a href="inbox/?BOX_ID=0">收件箱</a>
';
  if ((0 < $NEW_LETER_COUNT))
  {
    echo '       <img src="/images/email_new.gif">
';
  }
  echo '      </td>
      <td>　';
  echo $INBOX_COUNT;
  echo ' （';
  echo $NEW_LETER_COUNT;
  echo ' 封新邮件）</td>
    </tr>
    <tr class="TableData">
      <td nowrap><img src="/images/outbox.gif" align="absMiddle">&nbsp;&nbsp;<a href="outbox/?BOX_ID=0">发件箱</a></td>
      <td>　';
  echo $OUTBOX_COUNT;
  echo '</td>
    </tr>
    <tr class="TableData">
      <td nowrap><img src="/images/sentbox.gif" align="absMiddle">&nbsp;&nbsp;<a href="sentbox/?BOX_ID=0">已发送邮件箱</a></td>
      <td>　';
  echo $SENTBOX_COUNT;
  echo ' （';
  echo $SENTBOX_COUNT1;
  echo ' 封收件人已删除）</td>
    </tr>
    <tr class="TableData">
      <td nowrap><img src="/images/trash.gif" align="absMiddle">&nbsp;&nbsp;<a href="delbox/?BOX_ID=0">废件箱</a></td>
      <td>　';
  echo $DELBOX_COUNT;
  echo ' （';
  echo $NEW_DEL_COUNT;
  echo ' 封新邮件）&nbsp;&nbsp;<a href="javascript:del_mail();">清空废件箱</a></td>
    </tr>
';
  $query = (((''.'SELECT * from EMAIL_BOX where USER_ID=\'').$LOGIN_USER_ID).'\' order by BOX_NO');
  $cursor = exequery ($connection, $query);
  while ($ROW = mysql_fetch_array ($cursor))
  {
    $BOX_ID = $ROW['BOX_ID'];
    $BOX_NO = $ROW['BOX_NO'];
    $BOX_NAME = $ROW['BOX_NAME'];
    $NEW_LETER_COUNT = 0;
    $query = (((((''.'SELECT count(*) from EMAIL,EMAIL_BODY where EMAIL.BODY_ID=EMAIL_BODY.BODY_ID and BOX_ID=').$BOX_ID).' and TO_ID=\'').$LOGIN_USER_ID).'\' and READ_FLAG!=\'1\' and (DELETE_FLAG=\'\' or DELETE_FLAG=\'0\' or DELETE_FLAG=\'2\')');
    $cursor1 = exequery ($connection, $query);
    if ($ROW1 = mysql_fetch_array ($cursor1))
    {
      $NEW_LETER_COUNT = $ROW1[0];
    }
    $BOX_COUNT = 0;
    $query = (((((''.'SELECT count(*) from EMAIL,EMAIL_BODY where EMAIL.BODY_ID=EMAIL_BODY.BODY_ID and BOX_ID=').$BOX_ID).' and TO_ID=\'').$LOGIN_USER_ID).'\' and (DELETE_FLAG=\'\' or DELETE_FLAG=\'0\' or DELETE_FLAG=\'2\')');
    $cursor1 = exequery ($connection, $query);
    if ($ROW1 = mysql_fetch_array ($cursor1))
    {
      $BOX_COUNT = $ROW1[0];
    }
    ($EMAIL_COUNT += $BOX_COUNT);
    ($NEW_COUNT += $NEW_LETER_COUNT);
    echo '    <tr class="TableData">
      <td nowrap><img src="/images/inbox.gif" align="absMiddle">&nbsp;&nbsp;<a href="inbox/?BOX_ID=';
    echo $BOX_ID;
    echo '">';
    echo $BOX_NAME;
    echo '</a>
';
    if ((0 < $NEW_LETER_COUNT))
    {
      echo '       <img src="/images/email_new.gif">
';
    }
    echo '      </td>
      <td>　';
    echo $BOX_COUNT;
    echo ' （';
    echo $NEW_LETER_COUNT;
    echo ' 封新邮件）</td>
    </tr>
';
  }
  echo '    <tr class="TableContent">
      <td nowrap align="center"><b>合计：</b></td>
      <td nowrap>　';
  echo $EMAIL_COUNT;
  echo ' （';
  echo $NEW_COUNT;
  echo ' 封新邮件）</td>
    </tr>
    <tr class="TableControl">
      <td align="center" colspan="3">
       <input type="button" value="写新邮件" class="BigButton" onclick="location=\'new\'" title="撰写新的内部邮件">&nbsp;&nbsp;&nbsp;&nbsp;
       <input type="button" value="查询邮件" class="BigButton" onclick="location=\'query\'" title="内部邮件查询">&nbsp;&nbsp;&nbsp;&nbsp;
       <input type="button" valu';
  echo 'e="邮件箱管理" class="BigButton" onclick="location=\'mailbox/manage\'" title="内部邮件查询">
      </td>
    </tr>
</table>
</body>
</html>
';
?>

index.php - 源码说明

本页面展示了「通达OA2007SE源代码 非常好的」中的 index.php 源码文件，采用 PHP 编程语言编写，共 219 行代码。您可以在线阅读完整代码内容，也可以返回资源详情页下载完整源码包进行本地学习和开发。

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

⌨️ 快捷键说明

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