📄 search.php

📁 泛微协同办公系统标准版E-office V5.5的源代码内含泛微办公系统V5.5自动注册文件。
💻 PHP
字号:
<?php

include_once( "inc/auth.php" );
include_once( "inc/utility_all.php" );
include_once( "inc/function_page_01.php" );
echo "\r\n<html>\r\n<head>\r\n<title>查询邮件</title>\r\n<meta http-equiv=\"Content-Type\" content=\"text/html; charset=gb2312\">\r\n";
echo "<s";
echo "cript>\r\nfunction check_all()\r\n{\r\n for (i=0;i<document.all(\"email_select\").length;i++)\r\n {\r\n   if(document.all(\"allbox\").checked)\r\n      document.all(\"email_select\").item(i).checked=true;\r\n   else\r\n      document.all(\"email_select\").item(i).checked=false;\r\n }\r\n \r\n if(i==0)\r\n {\r\n   if(document.all(\"allbox\").checked)\r\n      document.all(\"email_select\").checked=true;\r\n   else\r\n      document.all(\"email";
echo "_select\").checked=false;\r\n }\r\n}\r\n\r\nfunction check_one(el)\r\n{\r\n   if(!el.checked)\r\n      document.all(\"allbox\").checked=false;\r\n}\r\n</script>\r\n</head>\r\n\r\n<body class=\"bodycolor\" topmargin=\"5\">\r\n";
if ( $BOX_ID == 0 && $BOX == 1 )
{
	$BOX_DESC = "收件箱";
	$BOX_URL = "../inbox/read_email";
}
else if ( $BOX_ID == 0 && $BOX == 2 )
{
	$BOX_DESC = "发件箱";
	$BOX_URL = "../new/";
}
else if ( $BOX_ID == 0 && $BOX == 3 )
{
	$BOX_DESC = "已发送邮件箱";
	$BOX_URL = "../sentbox/read_email";
}
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 = "../mailbox/read_email";
}
echo "<table border=\"0\" width=\"100%\" cellspacing=\"1\"  cellpadding=\"0\">\r\n   <tr class=\"tablehead1\">\r\n    <td ><img src=\"/images/menu/infofind.gif\"  align=\"absmiddle\">";
echo $BOX_DESC;
echo " - 查询结果\r\n    </td>\r\n  </tr>\r\n  <tr class=\"tablehead2\"><td>\r\n  <a href=\"../new\"><img src=\"/images/button/newmail.gif\" border=\"0\" title=\"写新邮件\"></a>\r\n  <a href=\"../query\"><img src=\"/images/button/searchmail.gif\" border=\"0\" title=\"查询邮件\"></a> \r\n  <a href=\"../mailbox/manage\"><img src=\"/images/button/managemail.gif\" border=\"0\" title=\"邮件箱管理\"></a>\r\n  <a href=\"../\"><img src=\"/images/button/return.gif\" bor";
echo "der=\"0\"></a>\r\n  </td></tr>\r\n</table>\r\n\r\n<br>\r\n\r\n\r\n";
$connection = openconnection( );
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!='1' 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 if ( $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}%'";
	}
}
else if ( $BOX_ID == 0 && $BOX == 3 )
{
	$query = "SELECT * from EMAIL where FROM_ID='{$LOGIN_USER_ID}' and SEND_FLAG='1' and DELETE_FLAG!='2' 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}%'";
	}
}
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 ( $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}%'";
}
switch ( $_REQUEST['order'] )
{
case "userid" :
	if ( $BOX_ID == 0 && $BOX == 1 || 0 < $BOX_ID )
	{
		$query .= " ORDER BY FROM_ID";
	}
	else
	{
		$query .= " ORDER BY TO_ID";
	}
	break;
case "subject" :
	$query .= " ORDER BY SUBJECT";
	break;
case "date" :
	$query .= " ORDER BY SEND_TIME";
	break;
default :
	$query .= " ORDER BY EMAIL_ID";
	break;
}
$query .= $_REQUEST['sens'] ? " ASC" : " DESC";
$query = page( $query, 10 );
$cursor = exequery( $connection, $query );
$LETER_COUNT = 0;
while ( $ROW = mysql_fetch_array( $cursor ) )
{
	++$LETER_COUNT;
	if ( $LETER_COUNT == 1 )
	{
		echo "\r\n<table border=\"0\" cellspacing=\"1\" width=\"100%\" class=\"small\" cellpadding=\"5\">\r\n  <tr class=\"TableHeader\">\r\n  ";
		$sens = $_REQUEST['sens'] ? 0 : 1;
		$sensimg = $_REQUEST['sens'] ? "arrow_up.gif" : "arrow_down.gif";
		$sensimg = "/images/".$sensimg;
		$sufurl = $_SERVER['PHP_SELF']."?BOX={$BOX}&FROM_ID={$FROM_ID}&TO_ID={$TO_ID}&SUBJECT={$SUBJECT}&KEY1={$KEY1}&KEY2={$KEY2}&KEY3={$KEY3}&ATTACHMENT_NAME={$ATTACHMENT_NAME}&x={$x}&y={$y}&BOX_ID=".$_REQUEST['BOX_ID']."&sens=".$sens;
		echo "  \r\n  <td width=\"5%\" nowrap >选择</td>\r\n      <td width=\"12%\" nowrap ><a href=\"";
		echo $sufurl;
		echo "&order=userid\">";
		if ( $BOX_ID == 0 && $BOX == 1 || 0 < $BOX_ID )
		{
			echo "发件人";
		}
		else
		{
			echo "收件人";
		}
		echo "</a> ";
		if ( $_REQUEST['order'] == "userid" )
		{
			echo "<img src='".$sensimg."'>";
		}
		echo "</td>\r\n      <td nowrap ><a href=\"";
		echo $sufurl;
		echo "&order=subject\">主题</a> ";
		if ( $_REQUEST['order'] == "subject" )
		{
			echo "<img src='".$sensimg."'>";
		}
		echo "</td>\r\n      <td nowrap >附件</td>\r\n      <td width=\"15%\" nowrap ><a href=\"";
		echo $sufurl;
		echo "&order=date\">日期</a> ";
		if ( $_REQUEST['order'] == "date" )
		{
			echo "<img src='".$sensimg."'>";
		}
		echo "</td>\r\n      <td width=\"8%\" nowrap >字节</td>\r\n  </tr>\r\n";
	}
	$EMAIL_ID = $ROW['EMAIL_ID'];
	$FROM_ID = $ROW['FROM_ID'];
	$TO_ID = $ROW['TO_ID'];
	$READ_FLAG = $ROW['READ_FLAG'];
	$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 );
	if ( $BOX == 1 )
	{
		$query1 = "SELECT * from USER where USER_ID='{$FROM_ID}'";
	}
	else
	{
		if ( substr( $TO_ID, -1 ) == "," )
		{
			$strid = substr( $TO_ID, 0, -1 );
			$strid = str_replace( ",", "','", $strid );
		}
		else
		{
			$strid = $TO_ID;
		}
		$strid = "'".$strid."'";
		$query1 = "SELECT * from USER where USER_ID IN ({$strid})";
	}
	$cursor1 = exequery( $connection, $query1 );
	$strname = "";
	$strc = 0;
	while ( $ROW = mysql_fetch_array( $cursor1 ) )
	{
		$FROM_TO_NAME = $ROW['USER_NAME'];
		$AVATAR = $ROW['AVATAR'];
		$DEPT_ID = $ROW['DEPT_ID'];
		$DEPT_NAME = dept_long_name( $DEPT_ID );
		if ( $strc != 0 )
		{
			$strname .= ",";
		}
		$strname .= "<u title='部门：{$DEPT_NAME}' style='cursor:hand'>{$FROM_TO_NAME}</u>";
		++$strc;
	}
	$ATTACHMENT_ID_ARRAY = explode( ",", $ATTACHMENT_ID );
	$ATTACHMENT_NAME_ARRAY = explode( "*", $ATTACHMENT_NAME );
	$ARRAY_COUNT = sizeof( $ATTACHMENT_ID_ARRAY );
	$EMAIL_ATTACH = "";
	$I = 0;
	for ( ;	$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]}\">{$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('/iWebOffice/DocumentEdit.php?RecordID=".$EMAIL_ID."&EditType=0&UserName={$LOGIN_USER_ID}&ATTACHMENT_ID=".( $ATTACHMENT_ID_ARRAY[$I] * 3 + 2 ) )."&ATTACHMENT_NAME=".urlencode( $ATTACHMENT_NAME_ARRAY[$I] )."',null,'menubar=0,toolbar=0,status=1,scrollbars=1,resizable=1')\";>";
		}
	}
	$EMAIL_SIZE = number_format( $EMAIL_SIZE, 0, ".", "," );
	if ( $LETER_COUNT % 2 == 1 )
	{
		$TableLine = "TableLine1";
	}
	else
	{
		$TableLine = "TableLine2";
	}
	echo "    <tr class=\"";
	echo $TableLine;
	echo "\">\r\n      <td>&nbsp;<input type=\"checkbox\" name=\"email_select\" value=\"";
	echo $EMAIL_ID;
	echo "\" onClick=\"check_one(self);\"></td>\t\r\n      <td nowrap>";
	echo $strname;
	echo "</td>\r\n      <td><a href=\"";
	echo $BOX_URL;
	echo "?EMAIL_ID=";
	echo $EMAIL_ID;
	echo "&BOX_ID=";
	echo $BOX_ID;
	echo "&QUERY=1\">";
	echo $SUBJECT;
	echo "</a>\r\n\r\n      <td>\r\n";
	if ( $ATTACHMENT_NAME != "" )
	{
		echo $EMAIL_ATTACH;
	}
	echo "&nbsp;</td>\r\n      </td>\r\n      <td nowrap >";
	echo $SEND_TIME;
	echo "</td>\r\n      <td nowrap >";
	echo $EMAIL_SIZE;
	echo "</td>\r\n    </tr>\r\n";
}
if ( 0 < $LETER_COUNT )
{
	echo "</table>\r\n<table width=\"100%\" >\r\n  <tr>\r\n    <td><input type=\"checkbox\" name=\"allbox\" onClick=\"check_all();\">\r\n      全部选中&nbsp;\r\n      <input name=\"button\" type=\"button\" class=\"SmallButton\" title=\"导出\" onClick=\"export_mail();\"  value=\"导出\">\r\n      <input name=\"button\" type=\"button\" class=\"SmallButton\" title=\"导出所有邮件\" onClick=\"export_mail_all();\"  value=\"全部导出\">\r\n    </td>\r\n  </tr>\r\n</table>\r\n<t";
	echo "able width=\"100%\"  border=\"0\" cellspacing=\"2\" cellpadding=\"2\">\r\n  <tr>";
	echo "    <td align=\"right\">";
	disp( "BOX=".$_REQUEST['BOX']."&FROM_ID=".$_REQUEST['FROM_ID']."&TO_ID=".$_REQUEST['TO_ID']."&SUBJECT=".$_REQUEST['SUBJECT']."&KEY1=".$_REQUEST['KEY1']."&KEY2=".$_REQUEST['KEY2']."&KEY3=".$_REQUEST['KEY3']."&ATTACHMENT_NAME=".$_REQUEST['ATTACHMENT_NAME']."&x=".$_REQUEST['x']."&y=".$_REQUEST['y']."&BOX_ID=".$_REQUEST['BOX_ID']."&sens=".$_REQUEST['sens']."&order=".$_REQUEST['order'] );
	echo "</td>\r\n  </tr>\r\n</table>\r\n";
}
else
{
	message( "", "<br>未找到符合条件的邮件" );
}
echo "\r\n\r\n\r\n</body>\r\n</html>\r\n";
echo "<s";
echo "cript>\r\n\r\nfunction change_box()\r\n{\r\n  delete_str=\"\";\r\n  for(i=0;i<document.all(\"email_select\").length;i++)\r\n  {\r\n\r\n      el=document.all(\"email_select\").item(i);\r\n      if(el.checked)\r\n      {  val=el.value;\r\n         delete_str+=val + \",\";\r\n      }\r\n  }\r\n  \r\n  if(i==0)\r\n  {\r\n      el=document.all(\"email_select\");\r\n      if(el.checked)\r\n      {  val=el.value;\r\n         delete_str+=val + \",\";\r\n     ";
echo " }\r\n  }\r\n\r\n  if(delete_str==\"\")\r\n  {\r\n     alert(\"要转移邮件，请至少选择其中一封。\");\r\n     document.form1.reset();\r\n     return;\r\n  }\r\n  \r\n  box_id=document.all(\"BOX_ID\").value;\r\n  url=\"../change_box.php?DELETE_STR=\"+ delete_str +\"&BOX_ID=\"+box_id+\"&PAGE_START=";
echo $PAGE_START;
echo "\";\r\n  location=url;\r\n}\r\n\r\nfunction delete_mail()\r\n{\r\n  delete_str=\"\";\r\n  for(i=0;i<document.all(\"email_select\").length;i++)\r\n  {\r\n\r\n      el=document.all(\"email_select\").item(i);\r\n      if(el.checked)\r\n      {  val=el.value;\r\n         delete_str+=val + \",\";\r\n      }\r\n  }\r\n  \r\n  if(i==0)\r\n  {\r\n      el=document.all(\"email_select\");\r\n      if(el.checked)\r\n      {  val=el.value;\r\n         delete_str+=";
echo "val + \",\";\r\n      }\r\n  }\r\n\r\n  if(delete_str==\"\")\r\n  {\r\n     alert(\"要删除邮件，请至少选择其中一封。\");\r\n     return;\r\n  }\r\n\r\n  msg='确认要删除所选邮件么？';\r\n  if(window.confirm(msg))\r\n  {\r\n    url=\"delete.php?DELETE_STR=\"+ delete_str +\"&PAGE_START=";
echo $PAGE_START;
echo "&BOX_ID=";
echo $BOX_ID;
echo "\";\r\n    location=url;\r\n  }\r\n}\r\nfunction export_mail_all()\r\n{\r\n  url=\"../replace.php?searchbox=1&isall=1&BOX_ID=";
echo $_REQUEST[BOX_ID];
echo "&BOX=";
echo $_REQUEST[BOX];
echo "&FROM_ID=";
echo $_REQUEST[FROM_ID];
echo "&TO_ID=";
echo $_REQUEST[TO_ID];
echo "&SUBJECT=";
echo $_REQUEST[SUBJECT];
echo "&KEY1=";
echo $_REQUEST[KEY1];
echo "&KEY2=";
echo $_REQUEST[KEY2];
echo "&KEY3=";
echo $_REQUEST[KEY3];
echo "&ATTACHMENT_NAME=";
echo $_REQUEST[ATTACHMENT_NAME];
echo "&x=";
echo $_REQUEST[x];
echo "&y=";
echo $_REQUEST[y];
echo "\";\r\n  \r\n  //location=url;\r\n  window.open(url,\"download\",\"width=200,height=100,scrollbar=no,resizable=yes\");\r\n}\r\n\r\nfunction export_mail()\r\n{\r\n  export_str=\"\";\r\n  for(i=0;i<document.all(\"email_select\").length;i++)\r\n  {\r\n\r\n      el=document.all(\"email_select\").item(i);\r\n      if(el.checked)\r\n      {  val=el.value;\r\n         export_str+=val + \",\";\r\n      }\r\n  }\r\n  \r\n  if(i==0)\r\n  {\r\n      el=document.a";
echo "ll(\"email_select\");\r\n      if(el.checked)\r\n      {  val=el.value;\r\n         export_str+=val + \",\";\r\n      }\r\n  }\r\n\r\n  if(export_str==\"\")\r\n  {\r\n     alert(\"要导出邮件，请至少选择其中一封。\");\r\n     return;\r\n  }\r\n  url=\"../replace.php?export_str=\"+ export_str;\r\n  //location=url;\r\n  window.open(url,\"download\",\"width=200,height=100,scrollbar=no,resizable=yes\");\r\n}\r\n\r\nfunction read_mail()\r\n{\r\n  read_st";
echo "r=\"\";\r\n  for(i=0;i<document.all(\"email_select\").length;i++)\r\n  {\r\n\r\n      el=document.all(\"email_select\").item(i);\r\n      if(el.checked)\r\n      {  val=el.value;\r\n         read_str+=val + \",\";\r\n      }\r\n  }\r\n  \r\n  if(i==0)\r\n  {\r\n      el=document.all(\"email_select\");\r\n      if(el.checked)\r\n      {  val=el.value;\r\n         read_str+=val + \",\";\r\n      }\r\n  }\r\n\r\n  if(read_str==\"\")\r\n  {\r\n     alert(\"要
⌨️ 快捷键说明

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