⭐ 欢迎来到虫虫下载站！ | 📦 资源下载 📁 资源专辑 ℹ️ 关于我们
⭐ 虫虫下载站
📤 上传资源

📄 index.php

📁 极限网络智能办公系统 Office Automation V3.0官方100％源代码.
💻 PHP
字号:
🔍 
<?
include_once("inc/auth.php");
include_once("inc/utility_all.php");

$PAGE_SIZE=intVal($_COOKIE[$LOGIN_USER_ID."_email_ps_del"]);
if($PAGE_SIZE<=0 || $PAGE_SIZE>=1000)
   $PAGE_SIZE=10;
?>

<html>
<head>
<title>收件箱</title>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">

<SCRIPT>
function set_page()
{
 PAGE_START=(document.all("PAGE_NUM").value-1)*<?=$PAGE_SIZE?>+1;
 location="index.php?PAGE_START="+PAGE_START+"&BOX_ID=<?=$BOX_ID?>";
}

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_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-event.offsetY+170;
  window.open(URL,null,"height=180,width=400,status=1,toolbar=no,menubar=no,location=no,scrollbars=no,top="+loc_y+",left="+loc_x+",resizable=yes");
}
</SCRIPT>
</head>

<body class="bodycolor" topmargin="5">

<?
 $query = "SELECT count(*) from EMAIL where TO_ID='$LOGIN_USER_ID' and SEND_FLAG='1' and (DELETE_FLAG='3' or DELETE_FLAG='4')";
 $cursor= exequery($connection,$query);
 $LETER_COUNT=0;
 if($ROW=mysql_fetch_array($cursor))
    $LETER_COUNT=$ROW[0];

 if($LETER_COUNT==0)
 {
?>
<table border="0" width="100%" cellspacing="0" cellpadding="3" class="small">
  <tr>
    <td class="Big"><img src="/images/menu/inbox.gif" WIDTH="22" HEIGHT="20" align="absmiddle"><span class="big3"> 已删除邮件箱</span>
    </td>
  </tr>
</table>
<br>
<br>
<?
   Message("","已删除邮件箱无邮件");
?>
<br>
<div align="center">
 <input type="button"  value="返回" class="BigButton" onClick="location='../';">
</div>
<?
   exit;
 }

 $query = "SELECT count(*) from EMAIL where TO_ID='$LOGIN_USER_ID'  and SEND_FLAG='1' and READ_FLAG='0' and (DELETE_FLAG='3' or DELETE_FLAG='4')";
 $cursor= exequery($connection,$query);
 $NEW_LETER_COUNT=0;
 if($ROW=mysql_fetch_array($cursor))
    $NEW_LETER_COUNT=$ROW[0];

 //============ 分页 =================

 //--- 计算总页数 ---
 $PAGE_TOTAL=$LETER_COUNT/$PAGE_SIZE;
 $PAGE_TOTAL=ceil($PAGE_TOTAL);

 //--- 计算,末页 ---
 if($LETER_COUNT<=$PAGE_SIZE)
    $LAST_PAGE_START=1;
 else if($LETER_COUNT%$PAGE_SIZE==0)
    $LAST_PAGE_START=$LETER_COUNT-$PAGE_SIZE+1;
 else
    $LAST_PAGE_START=$LETER_COUNT-$LETER_COUNT%$PAGE_SIZE+1;

 //--- 智能分页 ---
 //-- 页首 --
 if($PAGE_START=="")
    $PAGE_START=1;

 if($PAGE_START>$LETER_COUNT)
    $PAGE_START=$LAST_PAGE_START;

 if($PAGE_START<1)
    $PAGE_START=1;

 //-- 页尾 --
 $PAGE_END=$PAGE_START+$PAGE_SIZE-1;

 if($PAGE_END>$LETER_COUNT)
    $PAGE_END=$LETER_COUNT;

 //--- 计算当前页 ---
 $PAGE_NUM=($PAGE_START-1)/$PAGE_SIZE+1;

?>
<form name="form1">
<table border="0" width="100%" cellspacing="0" cellpadding="3" class="small">
  <tr>
    <td class="Big"><img src="/images/menu/inbox.gif" WIDTH="22" HEIGHT="20" align="absmiddle"><span class="big3"> 已删除邮件箱</span>
    </td>

    <td valign="bottom"><span class="small1">共&nbsp;<span class="big4"><?=$LETER_COUNT?></span>&nbsp;封邮件，<span class="big4"><?=$NEW_LETER_COUNT?></span>&nbsp;封为新邮件</span>
    </td>
    <td valign="bottom">
    <span class="small1">当前为第<b><?=$PAGE_START?></b>至<b><?=$PAGE_END?></b>封 (第<?=$PAGE_NUM?>页，共<?=$PAGE_TOTAL?>页，每页最多<?=$PAGE_SIZE?>封)</span>
    </td>
    </tr>
</table>


<br>


<table border="0" cellspacing="1" width="95%" 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">附件</td>
      <td nowrap align="center">日期 <img border=0 src="/images/arrow_down.gif" width="11" height="10"></td>
      <td nowrap align="center">字节</td>
      <td nowrap align="center">操作</td>
    </tr>

<?
 //============================ 显示邮件信息 =======================================
 $query = "SELECT * from EMAIL where TO_ID='$LOGIN_USER_ID'  and SEND_FLAG='1' and (DELETE_FLAG='3' or DELETE_FLAG='4') order by SEND_TIME desc";
 $cursor= exequery($connection,$query);
 $LETER_COUNT=0;
 while($ROW=mysql_fetch_array($cursor))
 {
    $LETER_COUNT++;
    if($LETER_COUNT<$PAGE_START)
       continue;
    else if($LETER_COUNT>$PAGE_END)
       break;

    $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"];

    if($IMPORTANT=='0' || $IMPORTANT=="")
       $IMPORTANT_DESC="";
    else if($IMPORTANT=='1')
       $IMPORTANT_DESC="<span class=\"TextColor1\">重要</span>";
    else if($IMPORTANT=='2')
       $IMPORTANT_DESC="<span class=\"TextColor2\">非常重要</span>";

    $SUBJECT=$ROW["SUBJECT"];

    $SUBJECT=str_replace("<","&lt",$SUBJECT);
    $SUBJECT=str_replace(">","&gt",$SUBJECT);
    $SUBJECT=stripslashes($SUBJECT);

    $SEND_TIME=$ROW["SEND_TIME"];

    $ATTACHMENT_ID=$ROW["ATTACHMENT_ID"];
    $ATTACHMENT_NAME=$ROW["ATTACHMENT_NAME"];

    $CONTENT=$ROW["CONTENT"];
    $EMAIL_SIZE=strlen($CONTENT)+strlen($SUBJECT);

    $query1 = "SELECT * from USER where USER_ID='$FROM_ID'";
    $cursor1= exequery($connection,$query1);
    if($ROW=mysql_fetch_array($cursor1))
    {
       $FROM_NAME=$ROW["USER_NAME"];
       $AVATAR=$ROW["AVATAR"];
       $DEPT_ID=$ROW["DEPT_ID"];
       $DEPT_NAME=dept_long_name($DEPT_ID);
    }
    else
    {
       $FROM_NAME=$FROM_ID;
       $AVATAR="";
       $DEPT_NAME="用户已删除";
    }

    //--- 计算附件大小 ---
    $ATTACHMENT_ID_ARRAY=explode(",",$ATTACHMENT_ID);
    $ATTACHMENT_NAME_ARRAY=explode("*",$ATTACHMENT_NAME);

    $ARRAY_COUNT=sizeof($ATTACHMENT_ID_ARRAY);
    $EMAIL_ATTACH="";
    $EMAIL_ATTACH1="";
    for($I=0;$I<$ARRAY_COUNT-1;$I++)
    {
       $EMAIL_SIZE+=attach_size($ATTACHMENT_ID_ARRAY[$I],$ATTACHMENT_NAME_ARRAY[$I]);
       if($EMAIL_ATTACH!="")
       {
          $EMAIL_ATTACH.="<br>";
          $EMAIL_ATTACH1.="<br>";
       }
       $EMAIL_ATTACH1.=$ATTACHMENT_NAME_ARRAY[$I];
       $EMAIL_ATTACH.="<img src=\"/images/email_atta.gif\" align=\"absmiddle\"><a href=\"/inc/attach.php?ATTACHMENT_ID=".($ATTACHMENT_ID_ARRAY[$I]*3+2)."&ATTACHMENT_NAME=$ATTACHMENT_NAME_ARRAY[$I]\" target=\"_blank\">$ATTACHMENT_NAME_ARRAY[$I]</a>";
     	 $EMAIL_ATTACH.=" <input type='button' value='转存' class='SmallButton' onClick=\"SaveFile('".($ATTACHMENT_ID_ARRAY[$I]*3+2)."','".urlencode($ATTACHMENT_NAME_ARRAY[$I])."')\";>&nbsp;";

       if(stristr($ATTACHMENT_NAME_ARRAY[$I],".doc")||stristr($ATTACHMENT_NAME_ARRAY[$I],".ppt")||stristr($ATTACHMENT_NAME_ARRAY[$I],".xls"))
       {
	        $EMAIL_ATTACH.=" <input type='button' value='阅读' class='SmallButton' onClick=\"window.open('/module/OC?ATTACHMENT_ID=".($ATTACHMENT_ID_ARRAY[$I]*3+2)."&ATTACHMENT_NAME=".urlencode($ATTACHMENT_NAME_ARRAY[$I])."&OP=5',null,'menubar=0,toolbar=0,status=1,scrollbars=1,resizable=1')\";>";
       }
       else if(is_media($ATTACHMENT_NAME_ARRAY[$I]))
       {
	        $EMAIL_ATTACH.=" <input type=\"button\" value=\"播放\" class=\"SmallButton\" onClick=\"window.open('/module/mediaplayer/index.php?MEDIA_NAME=".urlencode($ATTACHMENT_NAME_ARRAY[$I])."&MEDIA_URL=".urlencode("/inc/attach.php?ATTACHMENT_ID=".($ATTACHMENT_ID_ARRAY[$I]*3+2)."&ATTACHMENT_NAME=".urlencode($ATTACHMENT_NAME_ARRAY[$I]))."','media".$ATTACHMENT_ID_ARRAY[$I]."','menubar=0,toolbar=0,status=1,scrollbars=1,resizable=1');\">&nbsp;";
       }
    }

    $EMAIL_SIZE=number_format($EMAIL_SIZE,0, ".",",");

    if($LETER_COUNT%2==1)
       $TableLine="TableLine1";
    else
       $TableLine="TableLine2";
?>
    <tr class="<?=$TableLine?>">
      <td>&nbsp;<input type="checkbox" name="email_select" value="<?=$EMAIL_ID?>" onClick="check_one(self);">
      </td>

      <td align="center">
<?
       if($READ_FLAG=="1")
       {
?>
       <img src="/images/email_open.gif" alt="已读">
<?
       }
       else
       {
?>
       <img src="/images/email_new.gif" alt="未读">
<?
       }
?>
      </td>

      <td nowrap><img src="/images/avatar/<?=$AVATAR?>.gif" <?=avatar_size($AVATAR)?>> <u title="部门：<?=$DEPT_NAME?>" style="cursor:hand"><?=$FROM_NAME?></u>
<?
      if(!find_id($COPY_TO_ID,$TO_ID)&&!find_id($TO_ID2,$TO_ID))
         echo " (暗送)";
?>
      </td>
      <td><a href="read_email?PAGE_START=<?=$PAGE_START?>&EMAIL_ID=<?=$EMAIL_ID?>&BOX_ID=<?=$BOX_ID?>&CURSOR_ID=<?=$LETER_COUNT-1?>"><?=$SUBJECT?></a></td>
      <td align="center" nowrap><?=$IMPORTANT_DESC?></td>
      <td>
<?
       if($ATTACHMENT_NAME!="")
       {
          if($READ_FLAG=="1")
             echo $EMAIL_ATTACH;
          else
             echo $EMAIL_ATTACH1;
       }
?>
&nbsp;</td>
      </td>
      <td nowrap align="center"><?=$SEND_TIME?></td>
      <td nowrap align="center"><?=$EMAIL_SIZE?></td>
      <td nowrap align="center">&nbsp;<A href="../export.php?EMAIL_ID=<?=$EMAIL_ID?>" target="_blank">导出</A>&nbsp;</td>
    </tr>
<?
 }
?>

<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="recover_mail();" title="恢复该邮件到删除前的状态"> &nbsp;
      <input type="button"  value="永久删除" class="SmallButton" onClick="delete_mail();" title="删除所选邮件"> &nbsp;
      <input type="button"  value="导出" class="SmallButton" onClick="export_mail();" title="批量导出"> &nbsp;
</td>

<td align="right">
<input type="button"  value="首页" class="SmallButton"  <?if($PAGE_START==1)echo "disabled";?> onclick="location='index.php?BOX_ID=<?=$BOX_ID?>'"> &nbsp;
<input type="button"  value="上一页" class="SmallButton" <?if($PAGE_START==1)echo "disabled";?> onclick="location='index.php?PAGE_START=<?=($PAGE_START-$PAGE_SIZE)?>&BOX_ID=<?=$BOX_ID?>'"> &nbsp;
<input type="button"  value="下一页" class="SmallButton" <?if($PAGE_END>=$LETER_COUNT)echo "disabled";?> onclick="location='index.php?PAGE_START=<?=($PAGE_END+1)?>&BOX_ID=<?=$BOX_ID?>'"> &nbsp;
<input type="button"  value="末页" class="SmallButton"  <?if($PAGE_END>=$LETER_COUNT)echo "disabled";?> onclick="location='index.php?PAGE_START=<?=$LAST_PAGE_START?>&BOX_ID=<?=$BOX_ID?>'"> &nbsp;
页数
<input type="text" name="PAGE_NUM" value="<?=$PAGE_NUM?>" class="SmallInput" size="2"> <input type="button"  value="转到" class="SmallButton" onclick="set_page();" title="转到指定的页面">&nbsp;
</td>
</tr>
</table>

</td>
</tr>
</table>
</form>

<div align="center">
 <input type="button"  value="返回" class="BigButton" onClick="location='../';">
</div>

</body>

<script>
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 + ",";
      }
  }

  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+"&PAGE_START=<?=$PAGE_START?>";
  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+=val + ",";
      }
  }

  if(delete_str=="")
  {
     alert("要删除邮件，请至少选择其中一封。");
     return;
  }

  msg='邮件删除后将不可恢复，确认要删除所选邮件么？';
  if(window.confirm(msg))
  {
    url="delete.php?DELETE_STR="+ delete_str +"&PAGE_START=<?=$PAGE_START?>&BOX_ID=<?=$BOX_ID?>";
    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_str+=val + ",";
      }
  }

  if(delete_str=="")
  {
     alert("要导出邮件，请至少选择其中一封。");
     return;
  }
  window.open('../export_bat.php?DELETE_STR='+ delete_str);
}

function recover_mail()
{
  read_str="";
  for(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("要将恢复邮件，请至少选择其中一封。");
     return;
  }

  msg='确认要恢复邮件么？';
  if(window.confirm(msg))
  {
    url="recover.php?RECOVER_STR="+ read_str +"&PAGE_START=<?=$PAGE_START?>&BOX_ID=<?=$BOX_ID?>";
    location=url;
  }
}
</script>
</html>

⌨️ 快捷键说明

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