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

📄 search.php

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

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

<SCRIPT>
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;
 }
}

function check_one(el)
{
   if(!el.checked)
      allbox.checked=false;
}

function read_status(EMAIL_ID)
{
 URL="../sentbox/read_status.php?EMAIL_ID="+EMAIL_ID+"&PAGE_START=<?=$PAGE_START?>";
 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");
}
</SCRIPT>
<body class="bodycolor" topmargin="5">

<?
 if($BOX_ID==0&&$BOX==1)
 {
    $BOX_DESC="收件箱";
    $BOX_URL="../inbox/read_email";
    $BOX_URL1="../inbox/";
 }
 elseif($BOX_ID==0&&$BOX==2)
 {
    $BOX_DESC="发件箱";
    $BOX_URL="../new/";
    $BOX_URL1="../outbox/";
 }
 elseif($BOX_ID==0&&$BOX==3)
 {
    $BOX_DESC="已发送邮件箱";
    $BOX_URL="../sentbox//read_email";
    $BOX_URL1="../sentbox/";
 }
 elseif($BOX_ID==0&&$BOX==4)
 {
    $BOX_DESC="已删除邮件箱";
    $BOX_URL="../delbox//read_email";
    $BOX_URL1="../delbox/";
 }
 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"];
    $BOX_DESC=$BOX_NAME;
    $BOX_URL="../inbox/read_email";
 }
?>

<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"><span class="big3"><?=$BOX_DESC?> - 查询结果</span>
    </td>
  </tr>
</table>

<?
//----------- 合法性校验 ---------
  $CUR_TIME=date("Y-m-d H:i:s",time());
  if($SEND_TIME_MIN!="")
  {
    $TIME_OK=is_date_time($SEND_TIME_MIN);

    if(!$TIME_OK)
    { Message("错误","\"发布日期\"的格式不对，应形如 ".$CUR_TIME);
      Button_Back();
      exit;
    }
  }

  if($SEND_TIME_MAX!="")
  {
    $TIME_OK=is_date_time($SEND_TIME_MAX);

    if(!$TIME_OK)
    { Message("错误","\"发布日期\"的格式不对，应形如 ".$CUR_TIME);
      Button_Back();
      exit;
    }
  }
  
 //============================ 显示邮件信息 =======================================
 
 if($FROM_ID!="")
 {
    $query = "SELECT * from USER where USER_NAME like '%$FROM_ID%'";
    $cursor= exequery($connection,$query);
    if($ROW=mysql_fetch_array($cursor))
       $FROM_ID1=$ROW["USER_ID"];
 }
 
 if($TO_ID!="")
 {
    $query = "SELECT * from USER where USER_NAME like '%$TO_ID%'";
    $cursor= exequery($connection,$query);
    if($ROW=mysql_fetch_array($cursor))
       $TO_ID1=$ROW["USER_ID"];
 }
 
 if($BOX_ID==0&&$BOX==1)
 {
    $query = "SELECT * from EMAIL where TO_ID='$LOGIN_USER_ID'  and SEND_FLAG='1' and (DELETE_FLAG='0' or DELETE_FLAG='2') and BOX_ID=$BOX_ID";
    if($FROM_ID1!="")
       $query.= " and (FROM_ID like '%$FROM_ID%' or FROM_ID like '%$FROM_ID1%')";
    else
       if($FROM_ID!="")
          $query.= " and FROM_ID like '%$FROM_ID%'";
 }
 elseif($BOX_ID==0&&$BOX==2)
 {
    $query = "SELECT * from EMAIL where FROM_ID='$LOGIN_USER_ID' and SEND_FLAG='0' and BOX_ID=$BOX_ID";
    if($TO_ID1!="")
       $query.= " and (TO_ID like '%$TO_ID%' or TO_ID like '%$TO_ID1%')";
    else
       if($TO_ID!="")
          $query.= " and TO_ID like '%$TO_ID%'";
}
 elseif($BOX_ID==0&&$BOX==3)
 {
    $query = "SELECT * from EMAIL where FROM_ID='$LOGIN_USER_ID' and SEND_FLAG='1' and DELETE_FLAG!='2' and DELETE_FLAG!='4' and BOX_ID=$BOX_ID";
    if($TO_ID1!="")
       $query.= " and (TO_ID like '%$TO_ID%' or TO_ID like '%$TO_ID1%')";
    else
       if($TO_ID!="")
          $query.= " and TO_ID like '%$TO_ID%'";
}
elseif($BOX_ID==0&&$BOX==4)
 {
    $query = "SELECT * from EMAIL where TO_ID='$LOGIN_USER_ID'  and SEND_FLAG='1' and (DELETE_FLAG='3' or DELETE_FLAG='4') and BOX_ID=$BOX_ID";
    if($FROM_ID1!="")
       $query.= " and (FROM_ID like '%$FROM_ID%' or FROM_ID like '%$FROM_ID1%')";
    else
       if($FROM_ID!="")
          $query.= " and FROM_ID like '%$FROM_ID%'";
 }
 else
 {
    $query = "SELECT * from EMAIL where TO_ID='$LOGIN_USER_ID' and BOX_ID=$BOX_ID";
    if($FROM_ID1!="")
       $query.= " and (FROM_ID like '%$FROM_ID%' or FROM_ID like '%$FROM_ID1%')";
    else
       if($FROM_ID!="")
          $query.= " and FROM_ID like '%$FROM_ID%'";
}
  
 if($READ_FLAG!="")
    $query.= " and READ_FLAG='$READ_FLAG'";
 if($SEND_TIME_MIN!="")
    $query.= " and SEND_TIME>='$SEND_TIME_MIN'";
 if($SEND_TIME_MAX!="")
    $query.= " and SEND_TIME<='$SEND_TIME_MAX'";
 if($SUBJECT!="")
    $query.= " and SUBJECT like '%$SUBJECT%'";
 if($KEY1!="")
    $query.= " and CONTENT like '%$KEY1%'";
 if($KEY2!="")
    $query.= " and CONTENT like '%$KEY2%'";
 if($KEY3!="")
    $query.= " and CONTENT like '%$KEY3%'";
 if($ATTACHMENT_NAME!="")
    $query.= " and ATTACHMENT_NAME like '%$ATTACHMENT_NAME%'";

 if($BOX_ID==0&&$BOX==3)
    $query.= " group by SEND_TIME,TO_ID2";
 $query.= " order by SEND_TIME desc";

 $cursor= exequery($connection,$query);//
 $LETER_COUNT=0;
 while($ROW=mysql_fetch_array($cursor))
 {
    $LETER_COUNT++;

    if($LETER_COUNT==1)
    {
?>

<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"><?if(($BOX_ID==0&&$BOX==1)||$BOX_ID>0)echo "发件人";else echo "收件人";?></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>
<?
    }

    $EMAIL_ID=$ROW["EMAIL_ID"];
    $FROM_ID=$ROW["FROM_ID"];
    $TO_ID=$ROW["TO_ID"];
    $TO_ID2=$ROW["TO_ID2"];
    $READ_FLAG=$ROW["READ_FLAG"];

    $SUBJECT=$ROW["SUBJECT"];
    $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=htmlspecialchars($SUBJECT);

    $SEND_TIME=$ROW["SEND_TIME"];

    $ATTACHMENT_ID=$ROW["ATTACHMENT_ID"];
    $ATTACHMENT_NAME=$ROW["ATTACHMENT_NAME"];
    
    $GROUP_COUNT=1;
    if($BOX_ID==0&&$BOX==3)
    {
       $query="select count(*) from EMAIL where FROM_ID='$LOGIN_USER_ID'  and SEND_FLAG='1' and DELETE_FLAG!='2' and DELETE_FLAG!='4' and SEND_TIME='$SEND_TIME' and TO_ID2='$TO_ID2'";
       $cursor1= exequery($connection,$query);
       if($ROW1=mysql_fetch_array($cursor1))
          $GROUP_COUNT=$ROW1[0];
    }

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

    if($BOX==1)
       $query1 = "SELECT * from USER where USER_ID='$FROM_ID'";
    else
       $query1 = "SELECT * from USER where USER_ID='$TO_ID'";

    $cursor1= exequery($connection,$query1);
    if($ROW=mysql_fetch_array($cursor1))
    {
       $FROM_TO_NAME=$ROW["USER_NAME"];
       $DEPT_ID=$ROW["DEPT_ID"];
       $DEPT_NAME=dept_long_name($DEPT_ID);
    }
    else
    {
       $FROM_TO_NAME=$FROM_ID;
       $AVATAR="";
       $DEPT_NAME="用户已删除";
    }

    if($BOX==2)
    {
       $FROM_TO_NAME="";
       $TOK=strtok($TO_ID,",");
       while($TOK!="")
       {
          $query1 = "SELECT * from USER where USER_ID='$TOK'";
          $cursor1= exequery($connection,$query1);
          if($ROW=mysql_fetch_array($cursor1))
             $FROM_TO_NAME.=$ROW["USER_NAME"].",";
          $TOK=strtok(",");
       }
    }

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

    $ARRAY_COUNT=sizeof($ATTACHMENT_ID_ARRAY);
    $EMAIL_ATTACH="";
    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_ATTACH.="<img src=\"/images/email_atta.gif\"><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>";

       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','".$ATTACHMENT_ID_ARRAY[$I]."','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 nowrap align="center">
<?
    if($GROUP_COUNT>1)
    {
?>
       <a href="javascript:read_status('<?=$EMAIL_ID?>');">查看</a>
<?
    }
    else
    {
       if($BOX!=2)
       {
?>
      <u title="部门：<?=$DEPT_NAME?>" style="cursor:hand"><?=$FROM_TO_NAME?></u>
<?
       }
       else
       {
?>
      <?=$FROM_TO_NAME?>
<?
       }
    }
?>
      </td>
      <td><a href="<?=$BOX_URL?>?EMAIL_ID=<?=$EMAIL_ID?>&BOX_ID=<?=$BOX_ID?>&QUERY=1"><?=$SUBJECT?></a></td>
      <td align="center" nowrap><?=$IMPORTANT_DESC?></td>
      <td>
<?
       if($ATTACHMENT_NAME!="")
       {
          echo $EMAIL_ATTACH;
       }
?>
&nbsp;</td>
      </td>
      <td nowrap align="center"><?=$SEND_TIME?></td>
      <td nowrap align="center"><?=$EMAIL_SIZE?></td>
      <td nowrap align="center">
<?
    if($GROUP_COUNT==1)
    {
      if($BOX_ID==0&&$BOX==3)
      {
         if($READ_FLAG=="0")
         {
?>
      <a href="<?=$BOX_URL1?>edit_email.php?PAGE_START=<?=$PAGE_START?>&EMAIL_ID=<?=$EMAIL_ID?>"> 编辑</a>&nbsp;
<?
         }
?>
      <a href="<?=$BOX_URL1?>resend.php?EMAIL_ID=<?=$EMAIL_ID?>"> 再次发送</a>&nbsp;
<?
      }
?>
      <A href="../export.php?EMAIL_ID=<?=$EMAIL_ID?>" target="_blank">导出</A>&nbsp;

<?
     }
?>
      </td>
    </tr>
<?
 }

 if($LETER_COUNT>0)
 {
?>
<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="导出" class="SmallButton" onClick="export_mail();" title="批量导出"> &nbsp;
</td>
</tr>
  </table>
<?
 }
 else
    Message("","<br>未找到符合条件的邮件");
?>

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

<SCRIPT>
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 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="<?=$BOX_URL1?>delete.php?DELETE_STR="+ delete_str +"&PAGE_START=<?=$PAGE_START?>";
    location=url;
  }
}
</SCRIPT>
</body>
</html>

⌨️ 快捷键说明

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