index.php

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

PHP
469
字号
<?
  include_once 'inc/auth.php';
  include_once 'inc/utility_all.php';
  $PAGE_SIZE = intval ($_COOKIE[($LOGIN_USER_ID.'_email_ps_sent')]);
  if ((($PAGE_SIZE <= 0) OR (1000 <= $PAGE_SIZE)))
  {
    $PAGE_SIZE = 10;
  }
  if ((!isset ($PAGE_START) OR ($PAGE_START == '')))
  {
    $PAGE_START = 0;
  }
  echo '
<html>
<head>
<title>已发送邮件箱</title>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
';
  echo '<S';
  echo 'CRIPT>
function check_all()
{
 for (i=0;i<document.all("email_select").length;i++)
 {
   if(allbox.checked)
      document.all("email_select").item(i).checked=true;
   else
      document.all("email_select").item(i).checked=false;
 }
 if(i==0)
 {
   if(allbox.checked)
      document.all("email_select").checked=true;
   else
      document.all("email_select").checked=false;
 }
}
';
  echo '
function check_one(el)
{
   if(!el.checked)
      allbox.checked=false;
}
function read_status(BODY_ID)
{
 URL="read_status.php?BODY_ID="+BODY_ID+"&PAGE_START=';
  echo $PAGE_START;
  echo '";
 myleft=(screen.availWidth-400)/2;
 mytop=250
 mywidth=400;
 myheight=300;
 window.open(URL,"read","height="+myheight+",width="+mywidth+",status=1,toolbar=no,menubar=no,location=no,scrollbars=yes,top="+mytop+",left="+myleft+",resizable=yes");
}
function SaveFile(ATTACHMENT_ID,ATTACHMENT_NAME)
{
  URL="/module/save_file?ATTACHMENT_ID="+ATTACHMENT_ID+"&ATTACHMENT_NAME="+ATTACHMENT_NAME';
  echo '+"&A=1";
  loc_x=document.body.scrollLeft+event.clientX-event.offsetX-100;
  loc_y=document.body.scrollTop+event.clientY-event.offsetY+170;
  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">
';
  $query = (((''.'SELECT EMAIL_ID,TO_ID,READ_FLAG,DELETE_FLAG,EMAIL_BODY.BODY_ID,TO_ID2,COPY_TO_ID,TO_WEBMAIL,SUBJECT,SEND_TIME,ATTACHMENT_ID,ATTACHMENT_NAME,IMPORTANT,SIZE,USER_NAME,DEPT_ID from EMAIL_BODY,EMAIL LEFT JOIN USER ON USER.USER_ID = EMAIL.TO_ID where EMAIL.BODY_ID=EMAIL_BODY.BODY_ID and FROM_ID=\'').$LOGIN_USER_ID).'\' and DELETE_FLAG!=\'2\' and DELETE_FLAG!=\'4\' group by EMAIL.BODY_ID order by SEND_TIME desc');
  $cursor = exequery ($connection, $query);
  $LETER_COUNT = mysql_num_rows ($cursor);
  echo '<table border="0" width="100%" cellspacing="0" cellpadding="3" class="small">
  <tr>
    <td class="Big"><img src="/images/sentbox.gif" WIDTH="20" HEIGHT="20" align="absmiddle">';
  echo '<s';
  echo 'pan class="big3"> 已发送邮件箱</span>
    </td>
    <td valign="bottom" class="small1">共';
  echo '<s';
  echo 'pan class="big4">&nbsp;';
  echo $LETER_COUNT;
  echo '</span>&nbsp;封邮件</td>
    <td align="right" valign="bottom" class="small1">';
  echo page_bar ($PAGE_START, $LETER_COUNT, $PAGE_SIZE, 'PAGE_START');
  echo '</td>
    </tr>
</table>
';
  if (($LETER_COUNT == 0))
  {
    echo '<br>
<br>
';
    message ('', '已发送邮件箱无邮件');
    echo '<br>
<div align="center">
 <input type="button"  value="返回" class="BigButton" onClick="location=\'../\';">
</div>
';
    exit ();
  }
  echo '
<table border="0" cellspacing="1" width="100%" class="small" bgcolor="#000000" cellpadding="3">
  <tr class="TableHeader">
      <td nowrap align="center">选择</td>
      <td nowrap align="center">状态</td>
      <td nowrap align="center">收件人</td>
      <td nowrap align="center">主题</td>
      <td nowrap align="center">附件</td>
      <td nowrap align="center">日期 <img border=0 src="/images/arrow_';
  echo 'down.gif" width="11" height="10"></td>
      <td nowrap align="center">字节</td>
      <td nowrap align="center">操作</td>
    </tr>
';
  $LETER_COUNT = 0;
  while ($ROW = mysql_fetch_array ($cursor))
  {
    ++$LETER_COUNT;
    if (($LETER_COUNT <= $PAGE_START))
    {
      continue;
    }
    else
    {
      if ((($PAGE_START + $PAGE_SIZE) < $LETER_COUNT))
      {
        break;
      }
      $EMAIL_ID = $ROW['EMAIL_ID'];
      $BODY_ID = $ROW['BODY_ID'];
      $TO_ID = $ROW['TO_ID'];
      $TO_ID2 = $ROW['TO_ID2'];
      $COPY_TO_ID = $ROW['COPY_TO_ID'];
      $TO_WEBMAIL = $ROW['TO_WEBMAIL'];
      $READ_FLAG = $ROW['READ_FLAG'];
      $DELETE_FLAG = $ROW['DELETE_FLAG'];
      $IMPORTANT = $ROW['IMPORTANT'];
      $SIZE = $ROW['SIZE'];
      $SUBJECT = $ROW['SUBJECT'];
      $ATTACHMENT_ID = $ROW['ATTACHMENT_ID'];
      $ATTACHMENT_NAME = $ROW['ATTACHMENT_NAME'];
      $SUBJECT = htmlspecialchars ($SUBJECT);
      $SEND_TIME = substr ($ROW['SEND_TIME'], 0, -3);
      $TO_NAME = $ROW['USER_NAME'];
      $DEPT_ID = $ROW['DEPT_ID'];
      $DEPT_NAME = dept_long_name ($DEPT_ID);
      if (($TO_NAME == ''))
      {
        $TO_NAME = $TO_ID;
        $DEPT_NAME = '用户已删除';
      }
      $EMAIL_ID_STR = '';
      $query = (((''.'select EMAIL_ID from EMAIL where BODY_ID=').$BODY_ID).' and DELETE_FLAG!=\'2\' and DELETE_FLAG!=\'4\'');
      $cursor1 = exequery ($connection, $query);
      $GROUP_COUNT = mysql_num_rows ($cursor1);
      while ($ROW1 = mysql_fetch_array ($cursor1))
      {
        ($EMAIL_ID_STR .= ($ROW1['EMAIL_ID'].','));
      }
      $EMAIL_ID_STR = substr ($EMAIL_ID_STR, 0, -1);
      if ((substr ($TO_WEBMAIL, -1) == ','))
      {
        $TO_WEBMAIL = substr ($TO_WEBMAIL, 0, -1);
      }
      $WEBMAIL_DESC = '';
      if (($TO_WEBMAIL != ''))
      {
        $WEBMAIL_DESC = (('<img src=\'/images/mailout.gif\' align=\'absMiddle\' title=\'外发至:'.$TO_WEBMAIL).'\'>&nbsp;');
      }
      if ((($IMPORTANT == '0') OR ($IMPORTANT == '')))
      {
        $IMPORTANT_DESC = '';
      }
      else
      {
        if (($IMPORTANT == '1'))
        {
          $IMPORTANT_DESC = '<span class="TextColor1">重要</span>';
        }
        else
        {
          if (($IMPORTANT == '2'))
          {
            $IMPORTANT_DESC = '<span class="TextColor2">非常重要</span>';
          }
        }
      }
      $EMAIL_SIZE = (strlen ($SUBJECT) + ($SIZE * $GROUP_COUNT));
      if ((0 < floor ((($EMAIL_SIZE / 1024) / 1024))))
      {
        $EMAIL_SIZE = (round ((($EMAIL_SIZE / 1024) / 1024), 1).'M');
      }
      else
      {
        $EMAIL_SIZE = (ceil (($EMAIL_SIZE / 1024)).'K');
      }
      if ((($LETER_COUNT % 2) == 1))
      {
        $TableLine = 'TableLine1';
      }
      else
      {
        $TableLine = 'TableLine2';
      }
      echo '    <tr class="';
      echo $TableLine;
      echo '">
      <td>&nbsp;<input type="checkbox" name="email_select" value="';
      echo $EMAIL_ID_STR;
      echo '" onClick="check_one(self);"></td>
      <td align="center">
';
      if ((1 < $GROUP_COUNT))
      {
        echo '       <a href="javascript:read_status(\'';
        echo $BODY_ID;
        echo '\');">查看</a>
';
      }
      else
      {
        if (($DELETE_FLAG == '1'))
        {
          ($DEL_MAIL_STR .= ($EMAIL_ID.','));
          echo '       <img src="/images/email_delete.gif" alt="收件人已删除">
';
        }
        else
        {
          if (($READ_FLAG == '1'))
          {
            echo '       <img src="/images/email_open.gif" alt="收件人已读">
';
          }
          else
          {
            ($UNREAD_MAIL_STR .= ($EMAIL_ID.','));
            echo '       <img src="/images/email_close.gif" alt="收件人未读">
';
          }
        }
      }
      echo '      </td>
      <td nowrap align="center">
';
      if ((1 < $GROUP_COUNT))
      {
        echo '       <a href="javascript:read_status(\'';
        echo $BODY_ID;
        echo '\');">查看</a>
';
      }
      else
      {
        echo '      <u title="部门:';
        echo $DEPT_NAME;
        echo '" style="cursor:hand">';
        echo $TO_NAME;
        echo '</u>
';
        if (((($TO_ID2 != '') AND !find_id ($COPY_TO_ID, $TO_ID)) AND !find_id ($TO_ID2, $TO_ID)))
        {
          echo ' (暗送)';
        }
      }
      echo '      </td>
      <td><a href="read_email?PAGE_START=';
      echo $PAGE_START;
      echo '&EMAIL_ID=';
      echo $EMAIL_ID;
      echo '&CURSOR_ID=';
      echo (($PAGE_START + $LETER_COUNT) - 1);
      echo '">';
      echo $SUBJECT;
      echo '</a> ';
      echo $WEBMAIL_DESC;
      echo ' ';
      echo $IMPORTANT_DESC;
      echo '</td>
      <td>';
      echo attach_link ($ATTACHMENT_ID, $ATTACHMENT_NAME, 0, 1, 1);
      echo '</td>
      <td nowrap align="center">';
      echo $SEND_TIME;
      echo '</td>
      <td nowrap align="center">';
      echo $EMAIL_SIZE;
      echo '</td>
      <td nowrap>
';
      if (($GROUP_COUNT == 1))
      {
        if (($READ_FLAG == '0'))
        {
          echo '      <a href="edit_email.php?PAGE_START=';
          echo $PAGE_START;
          echo '&EMAIL_ID=';
          echo $EMAIL_ID;
          echo '"> 编辑</a>&nbsp;
';
        }
        echo '      <a href="resend.php?EMAIL_ID=';
        echo $EMAIL_ID;
        echo '"> 再次发送</a>&nbsp;
      </td>
    </tr>
';
        continue;
      }
      continue;
    }
  }
  echo '
<tr class="TableControl">
<td colspan="10">
      <input type="checkbox" name="allbox" id="allbox_for" onClick="check_all();">
      <label for="allbox_for">全选</label> &nbsp;
      <input type="button"  value="删除" class="SmallButton" onClick="delete_mail();"> &nbsp;
      <input type="button"  value="导出Excel" class="SmallButton" onClick="export_mail();" title="批量导出"> &nbsp;
      <input ';
  echo 'type="button"  value="导出eml" class="SmallButton" onClick="export_eml();" title="单独导出"> &nbsp;
</td>
</tr>
</table>
</td>
</tr>
</table>
<br>
<table border="0" cellspacing="1" width="100%" class="small" bgcolor="#000000" cellpadding="3">
  <tr>
      <td class="TableContent" nowrap align="center" width="80"><b>快捷操作:</b></td>
      <td class="TableControl" nowrap>&nbsp;
   <img src="/i';
  echo 'mages/delete.gif"> <a href="javascript:del_mail(\'del\',\'所有收件人已删除\');" title="删除所有收件人已删除邮件">删除所有收件人已删除邮件</a>&nbsp;&nbsp;
   <img src="/images/delete.gif"> <a href="javascript:del_mail(\'unread\',\'所有收件人未读\');" title="删除所有收件人未读邮件">删除所有收件人未读邮件</a>&nbsp;&nbsp;
   <img src="/images/delete.gif"> <a href="javascript:del_mail(\'readed\',\'所有收件人已读\');" t';
  echo 'itle="删除所有收件人已读邮件">删除所有收件人已读邮件</a>&nbsp;&nbsp;
      </td>
</tr>
</table>
<br>
<div align="center">
 <input type="button"  value="返回" class="BigButton" onClick="location=\'../\';">
</div>
</body>
';
  echo '<S';
  echo 'CRIPT>
function delete_mail_one(EMAIL_ID)
{
  msg=\'确认要删除该邮件么?\\n注意:如果删除对方未读邮件,对方将不会接收到该邮件!\';
  if(window.confirm(msg))
  {
    url="delete.php?DELETE_STR="+ EMAIL_ID +"&PAGE_START=';
  echo $PAGE_START;
  echo '";
    location=url;
  }
}
function export_mail()
{
  delete_str="";
  for(i=0;i<document.all("email_select").length;i++)
  {
      el=document.all("email_select").item(i);
      if(el.checked)
      {  val=el.value;
         delete_str+=val + ",";
      }
  }
  if(i==0)
  {
      el=document.all("email_select");
      if(el.checked)
      {  val=el.value;
         delete_';
  echo 'str+=val + ",";
      }
  }
  if(delete_str=="")
  {
     alert("要导出邮件,请至少选择其中一封。");
     return;
  }
  window.open(\'../export_bat.php?DELETE_STR=\'+ delete_str);
}
function export_eml()
{
  delete_str="";
  for(i=0;i<document.all("email_select").length;i++)
  {
      el=document.all("email_select").item(i);
      if(el.checked)
      {  val=el.value;
         d';
  echo 'elete_str+=val + ",";
      }
  }
  if(i==0)
  {
      el=document.all("email_select");
      if(el.checked)
      {  val=el.value;
         delete_str+=val + ",";
      }
  }
  if(delete_str=="")
  {
     alert("要导出邮件,请至少选择其中一封");
     return;
  }
  window.location=\'../export.php?DELETE_STR=\'+ delete_str;
}
function delete_mail()
{
  delete_str="";
  for(';
  echo 'i=0;i<document.all("email_select").length;i++)
  {
      el=document.all("email_select").item(i);
      if(el.checked)
      {  val=el.value;
         delete_str+=val + ",";
      }
  }
  if(i==0)
  {
      el=document.all("email_select");
      if(el.checked)
      {  val=el.value;
         delete_str+=val + ",";
      }
  }
  if(delete_str=="")
  {
     alert("要删除邮件,';
  echo '请至少选择其中一封。");
     return;
  }
  msg=\'确认要删除所选邮件么?\\n注意:如果删除对方未读邮件,对方将不会接收到该邮件!\';
  if(window.confirm(msg))
  {
    url="delete.php?DELETE_STR="+ delete_str +"&PAGE_START=';
  echo $PAGE_START;
  echo '";
    location=url;
  }
}
function del_mail(delete_str,type_str)
{
  if(delete_str=="")
  {
     alert("无"+type_str+"的邮件!");
     return;
  }
  msg=\'确认要删除\'+type_str+\'邮件么?\';
  if(window.confirm(msg))
  {
    url="del_email.php?DELETE="+ delete_str +"&PAGE_START=';
  echo $PAGE_START;
  echo '";
    location=url;
  }
}
</SCRIPT>
</html>
';
?>

⌨️ 快捷键说明

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