📄 email.php

📁 通达OA2007SE源代码非常好的
💻 PHP
字号:
<?
  include_once 'inc/auth.php';
  include_once 'inc/check_type.php';
  include_once 'inc/utility_all.php';
  echo '
<html>
<head>
<title>邮件查询</title>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
';
  echo '<s';
  echo 'cript>
function delete_one(EMAIL_ID)
{
 msg=\'确认要删除该邮件吗？\';
 if(window.confirm(msg))
 {
  URL="delete_email.php?EMAIL_ID=" + EMAIL_ID;
  window.location=URL;
 }
}
function SaveFile(ATTACHMENT_ID,ATTACHMENT_NAME)
{
  URL="/module/save_file?ATTACHMENT_ID="+ATTACHMENT_ID+"&ATTACHMENT_NAME="+ATTACHMENT_NAME+"&A=1";
  loc_x=document.body.scrollLeft+event.clientX-100;
  loc_y=docum';
  echo 'ent.body.scrollTop;
  window.open(URL,null,"height=180,width=400,status=1,toolbar=no,menubar=no,location=no,scrollbars=yes,top="+loc_y+",left="+loc_x+",resizable=yes");
}
</script>
</head>
<body class="bodycolor" topmargin="5">
';
  if (($BEGIN_DATE != ''))
  {
    $TIME_OK = is_date_time ($BEGIN_DATE);
    if (!$TIME_OK)
    {
      message ('错误', '起始日期格式不对，应形如 1999-1-2 14:55:20');
      button_back ();
      exit ();
    }
  }
  if (($END_DATE != ''))
  {
    $TIME_OK = is_date_time ($END_DATE);
    if (!$TIME_OK)
    {
      message ('错误', '截止日期格式不对，应形如 1999-1-2 14:55:20');
      button_back ();
      exit ();
    }
  }
  if (((($END_DATE != '') AND ($BEGIN_DATE != '')) AND ($END_DATE < $BEGIN_DATE)))
  {
    message ('错误', '截止时间不能晚于起始时间!');
    button_back ();
    exit ();
  }
  $query = 'select * from EMAIL,EMAIL_BODY where EMAIL.BODY_ID=EMAIL_BODY.BODY_ID and TO_ID!=\'\' and FROM_ID!=\'\'';
  if (($TO_ID != ''))
  {
    ($query .= (((''.' and find_in_set(FROM_ID,\'').$TO_ID).'\')'));
  }
  if (($COPY_TO_ID != ''))
  {
    ($query .= (((''.' and find_in_set(TO_ID,\'').$COPY_TO_ID).'\')'));
  }
  if (($BEGIN_DATE != ''))
  {
    ($query .= (((''.' and SEND_TIME>=\'').$BEGIN_DATE).'\''));
  }
  if (($END_DATE != ''))
  {
    ($query .= (((''.' and SEND_TIME<=\'').$END_DATE).'\''));
  }
  if (($SUBJECT != ''))
  {
    ($query .= (((''.' and SUBJECT like \'%').$SUBJECT).'%\''));
  }
  if (($CONTENT != ''))
  {
    ($query .= (((''.' and CONTENT like \'%').$CONTENT).'%\''));
  }
  ($query .= ' order by SEND_TIME desc');
  $cursor = exequery ($connection, $query);
  $COUNT = mysql_num_rows ($cursor);
  echo '
<table border="0" width="100%" cellspacing="0" cellpadding="3" class="small">
  <tr>
    <td class="Big"><img src="/images/menu/infofind.gif" WIDTH="22" HEIGHT="20" align="absmiddle">';
  echo '<s';
  echo 'pan class="big3"> 查询结果</span>
    </td>
  </tr>
</table>
';
  if (($COUNT == 0))
  {
    message ('', '无符合条件的查询结果');
    button_back ();
    exit ();
  }
  echo '<table border="0" cellspacing="1" width="100%" class="small" bgcolor="#000000" cellpadding="3">
  <tr class="TableHeader" align="center">
      <td width="40">状态</td>
      <td width="60">发件人</td>
      <td width="60">收件人</td>
      <td>主题</td>
      <td>附件</td>
      <td width="120">发送时间 <img border=0 src="/images/arrow_down.gif" width="11" height="10"></td>
      <td width="30">操作</td>
';
  echo '
    </tr>
';
  while ($ROW = mysql_fetch_array ($cursor))
  {
    $EMAIL_ID = $ROW['EMAIL_ID'];
    $FROM_ID = $ROW['FROM_ID'];
    $TO_ID = $ROW['TO_ID'];
    $READ_FLAG = $ROW['READ_FLAG'];
    $DELETE_FLAG = $ROW['DELETE_FLAG'];
    $SUBJECT = $ROW['SUBJECT'];
    $SUBJECT = htmlspecialchars ($SUBJECT);
    $SEND_TIME = $ROW['SEND_TIME'];
    $ATTACHMENT_ID = $ROW['ATTACHMENT_ID'];
    $ATTACHMENT_NAME = $ROW['ATTACHMENT_NAME'];
    if (($READ_FLAG == '0'))
    {
      $STATUS_DESC = '<img src="/images/email_close.gif" alt="收件人未读">';
    }
    else
    {
      $STATUS_DESC = '<img src="/images/email_open.gif" alt="收件人已读">';
    }
    $FROM_NAME = '';
    $query1 = (((''.'SELECT * from USER where USER_ID=\'').$FROM_ID).'\'');
    $cursor1 = exequery ($connection, $query1);
    if ($ROW = mysql_fetch_array ($cursor1))
    {
      $FROM_NAME = $ROW['USER_NAME'];
    }
    $TO_NAME = $TO_ID;
    $query1 = (((''.'SELECT * from USER where USER_ID=\'').$TO_ID).'\'');
    $cursor1 = exequery ($connection, $query1);
    if ($ROW = mysql_fetch_array ($cursor1))
    {
      $TO_NAME = $ROW['USER_NAME'];
    }
    echo '    <tr class="TableData">
      <td align="center">';
    echo $STATUS_DESC;
    echo '</td>
      <td align="center">';
    echo $FROM_NAME;
    echo '</td>
      <td align="center">';
    echo $TO_NAME;
    echo '</td>
      <td><a href="read_email.php?EMAIL_ID=';
    echo $EMAIL_ID;
    echo '">';
    echo $SUBJECT;
    echo '</a></td>
      <td>';
    echo attach_link ($ATTACHMENT_ID, $ATTACHMENT_NAME, 0, 1, 1, 0, 0, 1, 1, 0, 'email');
    echo '</td>
      <td align="center">';
    echo $SEND_TIME;
    echo '</td>
      <td align="center">
      <a href="javascript:delete_one(';
    echo $EMAIL_ID;
    echo ');">删除</a>
      </td>
    </tr>
';
  }
  echo '</table>
<br>
<div align="center">
 <input type="button"  value="返回" class="BigButton" onClick="location=\'index.php\';">
</div>
</body>
</html>
';
?>
⌨️ 快捷键说明

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