index.php

来自「通达OA2007SE源代码非常好的」· PHP 代码 · 共 489 行
PHP
489 行
<?
  include_once 'inc/auth.php';
  include_once 'inc/utility_all.php';
  $PAGE_SIZE = intval ($_COOKIE[(($LOGIN_USER_ID.'_email_ps_in').$BOX_ID)]);
  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(document.all("allbox").checked)
      document.all("email_select").item(i).checked=true;
   else
      document.all("email_select").item(i).checked=false;
 }
 if(i==0)
 {
   if(document.all("allbox").checked)
      document.all("email_select").checked=true;
   else
      document.all("email_';
  echo 'select").checked=false;
 }
}
function check_one(el)
{
   if(!el.checked)
      document.all("allbox").checked=false;
}
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-event.offsetX-100;
  loc_y=document.body.scrollTop+event.clientY-eve';
  echo 'nt.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">
';
  if (($BOX_ID == '0'))
  {
    $BOX_NAME = '收件箱';
  }
  else
  {
    $query = (((''.'SELECT * from EMAIL_BOX where BOX_ID=\'').$BOX_ID).'\'');
    $cursor = exequery ($connection, $query);
    if ($ROW = mysql_fetch_array ($cursor))
    {
      $BOX_NAME = $ROW['BOX_NAME'];
    }
  }
  $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\')');
  $cursor = exequery ($connection, $query);
  if ($ROW = mysql_fetch_array ($cursor))
  {
    $LETER_COUNT = $ROW[0];
  }
  if (($LETER_COUNT == 0))
  {
    echo '<table border="0" width="100%" cellspacing="0" cellpadding="3" class="small">
  <tr>
    <td class="Big"><img src="/images/inbox.gif" WIDTH="20" HEIGHT="20" align="absmiddle">';
    echo '<s';
    echo 'pan class="big3"> ';
    echo $BOX_NAME;
    echo '</span>
    </td>
  </tr>
</table>
<br>
<br>
';
    message ('', ($BOX_NAME.'无邮件'));
    echo '<br>
<div align="center">
 <input type="button"  value="返回" class="BigButton" onClick="location=\'../\';">
</div>
';
    exit ();
  }
  $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);
  $NEW_LETER_COUNT = 0;
  if ($ROW = mysql_fetch_array ($cursor1))
  {
    $NEW_LETER_COUNT = $ROW[0];
  }
  echo '<form name="form1">
<table border="0" width="100%" cellspacing="0" cellpadding="3" class="small">
  <tr>
    <td class="Big"><img src="/images/inbox.gif" WIDTH="20" HEIGHT="20" align="absmiddle">';
  echo '<s';
  echo 'pan class="big3"> ';
  echo $BOX_NAME;
  echo '</span></td>
    <td valign="bottom">';
  echo '<s';
  echo 'pan class="small1">共&nbsp;';
  echo '<s';
  echo 'pan class="big4">';
  echo $LETER_COUNT;
  echo '</span>&nbsp;封邮件，';
  echo '<s';
  echo 'pan class="big4">';
  echo $NEW_LETER_COUNT;
  echo '</span>&nbsp;封为新邮件</span></td>
    <td align="right" valign="bottom" class="small1">';
  echo page_bar ($PAGE_START, $LETER_COUNT, $PAGE_SIZE, 'PAGE_START');
  echo '</td>
    </tr>
</table>
<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">日期 <img border=0 src="/images/arrow';
  echo '_down.gif" width="11" height="10"></td>
      <td nowrap align="center">大小</td>
    </tr>
';
  $LETER_COUNT = 0;
  $query = ((((((((''.'SELECT EMAIL_ID,TO_ID,READ_FLAG,FROM_ID,TO_ID2,COPY_TO_ID,SUBJECT,SEND_TIME,ATTACHMENT_ID,ATTACHMENT_NAME,IMPORTANT,SIZE,USER_NAME,AVATAR,DEPT_ID from EMAIL,EMAIL_BODY LEFT JOIN USER ON USER.USER_ID = EMAIL_BODY.FROM_ID 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\') order by SEND_TIME desc limit ').$PAGE_START).',').$PAGE_SIZE);
  $cursor = exequery ($connection, $query);
  while ($ROW = mysql_fetch_array ($cursor))
  {
    ++$LETER_COUNT;
    $EMAIL_ID = $ROW['EMAIL_ID'];
    $TO_ID = $ROW['TO_ID'];
    $TO_ID2 = $ROW['TO_ID2'];
    $FROM_ID = $ROW['FROM_ID'];
    $COPY_TO_ID = $ROW['COPY_TO_ID'];
    $READ_FLAG = $ROW['READ_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);
    $FROM_NAME = $ROW['USER_NAME'];
    $AVATAR = $ROW['AVATAR'];
    $DEPT_ID = $ROW['DEPT_ID'];
    $DEPT_NAME = dept_long_name ($DEPT_ID);
    $EMAIL_SIZE = (strlen ($SUBJECT) + $SIZE);
    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 (($FROM_NAME == ''))
    {
      $FROM_NAME = $FROM_ID;
      $AVATAR = '';
      $DEPT_NAME = '用户已删除';
    }
    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;
    echo '" onClick="check_one(self);">
      </td>
      <td nowrap><img src="/images/avatar/';
    echo $AVATAR;
    echo '.gif" ';
    echo avatar_size ($AVATAR);
    echo '> <u title="部门：';
    echo $DEPT_NAME;
    echo '" style="cursor:hand">';
    echo $FROM_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 '&BOX_ID=';
    echo $BOX_ID;
    echo '&CURSOR_ID=';
    echo (($PAGE_START + $LETER_COUNT) - 1);
    echo '">';
    echo $SUBJECT;
    echo '</a>
';
    if (($IMPORTANT == '1'))
    {
      echo '<span class="TextColor1">重要</span>';
    }
    else
    {
      if (($IMPORTANT == '2'))
      {
        echo '<span class="TextColor2">非常重要</span>';
      }
    }
    if (($READ_FLAG != '1'))
    {
      echo '       <img src="/images/email_new.gif" alt="未读">
';
    }
    echo '      </td>
      <td>';
    echo attach_link ($ATTACHMENT_ID, $ATTACHMENT_NAME, 0, $READ_FLAG, 1);
    echo '</td>
      </td>
      <td nowrap align="center">';
    echo $SEND_TIME;
    echo '</td>
      <td nowrap align="right">';
    echo $EMAIL_SIZE;
    echo '</td>
</tr>
';
  }
  echo '
<tr class="TableControl">
<td colspan="10">
<table width="100%" class="small">
<tr>
<td><input type="checkbox" name="allbox" id="allbox_for" onClick="check_all();">
      <label for="allbox_for">全选</label> &nbsp;
      <input type="button"  value="已读" class="SmallButton" onClick="read_mail();" title="标记为已读"> &nbsp;
      <input type="button"  value="删除" class="SmallButton" onClick="del';
  echo 'ete_mail();" title="删除所选邮件"> &nbsp;
      <input type="button"  value="导出Excel" class="SmallButton" onClick="export_mail();" title="批量导出"> &nbsp;
      <input type="button"  value="导出eml" class="SmallButton" onClick="export_eml();" title="单独导出"> &nbsp;
      转到&nbsp;
      ';
  echo '<s';
  echo 'elect name="BOX_ID" onchange="change_box();" class="SmallSelect">
         <option value=0 ';
  if (($BOX_ID == 0))
  {
    echo 'selected';
  }
  echo '>收件箱</option>
';
  $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_ID1 = $ROW['BOX_ID'];
    $BOX_NO = $ROW['BOX_NO'];
    $BOX_NAME = $ROW['BOX_NAME'];
    echo '         <option value=';
    echo $BOX_ID1;
    echo ' ';
    if (($BOX_ID == $BOX_ID1))
    {
      echo 'selected';
    }
    echo '>';
    echo $BOX_NAME;
    echo '</option>
';
  }
  echo '</select>
</td>
<td align="right">
  <img src="/images/delete.gif" align="absMiddle"> <a href="javascript:del_mail();" title="删除所有已读邮件">删除所有已读邮件</a>&nbsp;
</td>
</tr>
</table>
</td>
</tr>
</table>
</form>
<div align="center">
 <input type="button"  value="返回" class="BigButton" onClick="location=\'../\';">
</div>
</body>
';
  echo '<s';
  echo 'cript>
function change_box()
{
  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_str+=val + ",";
      }
';
  echo '  }
  if(delete_str=="")
  {
     alert("要转移邮件，请至少选择其中一封。");
     document.form1.reset();
     return;
  }
  box_id=document.all("BOX_ID").value;
  url="../change_box.php?DELETE_STR="+ delete_str +"&BOX_ID="+box_id+"&BOX_ID_OLD=';
  echo $BOX_ID;
  echo '&PAGE_START=';
  echo $PAGE_START;
  echo '";
  location=url;
}
function delete_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_str+=va';
  echo 'l + ",";
      }
  }
  if(delete_str=="")
  {
     alert("要删除邮件，请至少选择其中一封。");
     return;
  }
  msg=\'确认要删除所选邮件么？\';
  if(window.confirm(msg))
  {
    url="delete.php?DELETE_STR="+ delete_str +"&PAGE_START=';
  echo $PAGE_START;
  echo '&BOX_ID=';
  echo $BOX_ID;
  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 read_mail()
{
  read_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;
         read_str+=val + ",";
      }
  }
  if(i==0)
  {
      el=document.all("email_select");
      if(el.checked)
      {  val=el.value;
         read_str+=val + ",";
      }
  }
  if(read_str=="")
  {
     alert("要将邮件标记为已读';
  echo '，请至少选择其中一封。");
     return;
  }
  msg=\'确认要将所选邮件标记为已读么？\';
  if(window.confirm(msg))
  {
    url="read_ok.php?READ_STR="+ read_str +"&PAGE_START=';
  echo $PAGE_START;
  echo '&BOX_ID=';
  echo $BOX_ID;
  echo '";
    location=url;
  }
}
function del_mail()
{
  msg=\'确认要删除所有已读邮件？\';
  if(window.confirm(msg))
  {
    url="del_email.php?BOX_ID=';
  echo $BOX_ID;
  echo '&PAGE_START=';
  echo $PAGE_START;
  echo '";
    location=url;
  }
}
</script>
</html>
';
?>
index.php - 源码说明

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

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