📄 search.php
字号:
<?php
include_once( "inc/auth.php" );
include_once( "inc/check_type.php" );
include_once( "inc/utility_all.php" );
include_once( "inc/utility_file.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</head>\r\n\r\n<script src=\"/inc/js/attach.js\"></script>\r\n<SCRIPT>\r\nfunction check_all()\r\n{\r\n for (i=0;i<document.all(\"email_select\").length;i++)\r\n {\r\n if(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(allbox.checked)\r\n document.all(\"email_select\").checked=true;\r\n else\r\n document.all(\"email_select\").checked=false;\r\n }\r\n}\r\n\r\nfunction check_one(el)\r\n{\r\n if(!el.checked)\r\n allbox.checked=false;\r\n}\r\n\r\nfunction read_status(BODY_ID)\r\n{\r\n URL=\"../sentbox/read_status.php?BODY_ID=\"+BODY_ID+\"&PAGE_START=";
echo $PAGE_START;
echo "\";\r\n myleft=(screen.availWidth-400)/2;\r\n mytop=250\r\n mywidth=400;\r\n myheight=300;\r\n window.open(URL,\"read\",\"height=\"+myheight+\",width=\"+mywidth+\",status=1,toolbar=no,menubar=no,location=no,scrollbars=yes,top=\"+mytop+\",left=\"+myleft+\",resizable=yes\");\r\n}\r\n\r\nfunction change_box()\r\n{\r\n delete_str=get_checked();\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+\"&BOX_ID_OLD=";
echo $BOX_ID;
echo "&PAGE_START=";
echo $PAGE_START;
echo "&FIELD=";
echo $FIELD;
echo "&ASC_DESC=";
echo $ASC_DESC;
echo "\";\r\n location=url;\r\n}\r\n\r\n</SCRIPT>\r\n<body class=\"bodycolor\" topmargin=\"5\">\r\n\r\n";
if ( $BOX_ID == 0 && $BOX == 1 )
{
$BOX_DESC = "收件箱";
$BOX_URL = "../inbox/read_email";
$BOX_URL1 = "../inbox/";
}
else if ( $BOX_ID == 0 && $BOX == 2 )
{
$BOX_DESC = "发件箱";
$BOX_URL = "../new/";
$BOX_URL1 = "../outbox/";
}
else if ( $BOX_ID == 0 && $BOX == 3 )
{
$BOX_DESC = "已发送邮件箱";
$BOX_URL = "../sentbox//read_email";
$BOX_URL1 = "../sentbox/";
}
else if ( $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";
}
echo "\r\n<table border=\"0\" width=\"100%\" cellspacing=\"0\" cellpadding=\"3\" class=\"small\">\r\n <tr>\r\n <td class=\"Big\"><img src=\"/images/menu/infofind.gif\" align=\"absmiddle\">\r\n \t<span class=\"big3\">";
echo $BOX_DESC;
echo " - 查询结果</span>\r\n </td>\r\n </tr>\r\n</table>\r\n\r\n";
$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,EMAIL_BODY where EMAIL.BODY_ID=EMAIL_BODY.BODY_ID and TO_ID='".$LOGIN_USER_ID."' and SEND_FLAG='1' and (DELETE_FLAG='' or DELETE_FLAG='0' or DELETE_FLAG='2') and BOX_ID={$BOX_ID}";
if ( $FROM_ID1 != "" )
{
$query .= " and FROM_ID='".$FROM_ID1."'";
}
else if ( $FROM_ID != "" )
{
$query .= " and FROM_ID like '%".$FROM_ID."%'";
}
}
else if ( $BOX_ID == 0 && $BOX == 2 )
{
$query = "SELECT * from EMAIL,EMAIL_BODY where EMAIL.BODY_ID=EMAIL_BODY.BODY_ID and FROM_ID='".$LOGIN_USER_ID."' and SEND_FLAG='0' and BOX_ID={$BOX_ID}";
if ( $TO_ID1 != "" )
{
$query .= " and TO_ID='".$TO_ID1."'";
}
else if ( $TO_ID != "" )
{
$query .= " and TO_ID like '%".$TO_ID."%'";
}
}
else if ( $BOX_ID == 0 && $BOX == 3 )
{
$query = "SELECT * from EMAIL,EMAIL_BODY where EMAIL.BODY_ID=EMAIL_BODY.BODY_ID and 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='".$TO_ID1."'";
}
else if ( $TO_ID != "" )
{
$query .= " and TO_ID like '%".$TO_ID."%'";
}
}
else if ( $BOX_ID == 0 && $BOX == 4 )
{
$query = "SELECT * from EMAIL,EMAIL_BODY where EMAIL.BODY_ID=EMAIL_BODY.BODY_ID and 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='".$FROM_ID1."'";
}
else if ( $FROM_ID != "" )
{
$query .= " and FROM_ID like '%".$FROM_ID."%'";
}
}
else
{
$query = "SELECT * from EMAIL,EMAIL_BODY where EMAIL.BODY_ID=EMAIL_BODY.BODY_ID and TO_ID='".$LOGIN_USER_ID."' and BOX_ID={$BOX_ID}";
if ( $FROM_ID1 != "" )
{
$query .= " and FROM_ID='".$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 )
{
echo "\r\n<table class=\"TableList\" width=\"100%\">\r\n <tr class=\"TableHeader\">\r\n <td nowrap align=\"center\">选</td>\r\n <td nowrap align=\"center\">";
if ( !( $BOX_ID == 0 ) && $BOX == 1 || 0 < $BOX_ID )
{
echo "发件人";
}
else
{
echo "收件人";
}
echo "</td>\r\n <td nowrap align=\"center\">主题</td>\r\n <td nowrap align=\"center\">附件</td>\r\n <td nowrap align=\"center\">日期 <img border=0 src=\"/images/arrow_down.gif\" width=\"11\" height=\"10\"></td>\r\n <td nowrap align=\"center\">大小</td>\r\n <td nowrap align=\"center\">操作</td>\r\n </tr>\r\n";
}
$EMAIL_ID = $ROW['EMAIL_ID'];
$BODY_ID = $ROW['BODY_ID'];
$FROM_ID = $ROW['FROM_ID'];
$TO_ID = $ROW['TO_ID'];
$TO_ID2 = $ROW['TO_ID2'];
$READ_FLAG = $ROW['READ_FLAG'];
$SUBJECT = $ROW['SUBJECT'];
$CONTENT = $ROW['CONTENT'];
$IMPORTANT = $ROW['IMPORTANT'];
$SIZE = $ROW['SIZE'];
$ATTACHMENT_ID = $ROW['ATTACHMENT_ID'];
$ATTACHMENT_NAME = $ROW['ATTACHMENT_NAME'];
$SUBJECT = htmlspecialchars( $SUBJECT );
$SEND_TIME = substr( $ROW['SEND_TIME'], 0, -3 );
$EMAIL_SIZE = strlen( $CONTENT ) + 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 ( $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>";
}
$GROUP_COUNT = 1;
if ( $BOX_ID == 0 && $BOX == 3 )
{
$EMAIL_ID_STR = "";
$query = "select EMAIL_ID from EMAIL where BODY_ID='".$BODY_ID."'";
$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 );
}
else
{
$EMAIL_ID_STR = $EMAIL_ID;
}
if ( $BOX == 1 )
{
$query1 = "SELECT USER_NAME,DEPT_ID from USER where USER_ID='".$FROM_ID."'";
}
else
{
$query1 = "SELECT USER_NAME,DEPT_ID 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 = "";
$query1 = "SELECT USER_NAME from USER where find_in_set(USER_ID,'".$TO_ID."')";
$cursor1 = exequery( $connection, $query1 );
while ( $ROW = mysql_fetch_array( $cursor1 ) )
{
$FROM_TO_NAME .= $ROW['USER_NAME'].",";
}
}
if ( $LETER_COUNT % 2 == 1 )
{
$TableLine = "TableLine1";
}
else
{
$TableLine = "TableLine2";
}
echo " <tr class=\"";
echo $TableLine;
echo "\">\r\n <td> <input type=\"checkbox\" name=\"email_select\" value=\"";
echo $EMAIL_ID_STR;
echo "\" onClick=\"check_one(self);\"></td>\r\n <td nowrap align=\"center\">\r\n";
if ( 1 < $GROUP_COUNT )
{
echo " <a href=\"javascript:read_status('";
echo $BODY_ID;
echo "');\">查看</a>\r\n";
}
else if ( $BOX != 2 )
{
echo " <u title=\"部门：";
echo $DEPT_NAME;
echo "\" style=\"cursor:hand\">";
echo $FROM_TO_NAME;
echo "</u>\r\n";
}
else
{
echo " ";
echo $FROM_TO_NAME;
}
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> ";
echo $IMPORTANT_DESC;
echo "</td>\r\n <td>";
echo attach_link( $ATTACHMENT_ID, $ATTACHMENT_NAME, 0, $BOX == 3, 1 );
echo "</td>\r\n </td>\r\n <td nowrap align=\"center\">";
echo $SEND_TIME;
echo "</td>\r\n <td nowrap align=\"center\">";
echo $EMAIL_SIZE;
echo "</td>\r\n <td nowrap align=\"center\">\r\n";
if ( $GROUP_COUNT == 1 && $BOX_ID == 0 && $BOX == 3 )
{
if ( $READ_FLAG == "0" )
{
echo " <a href=\"";
echo $BOX_URL1;
echo "edit_email.php?PAGE_START=";
echo $PAGE_START;
echo "&EMAIL_ID=";
echo $EMAIL_ID;
echo "\"> 编辑</a> \r\n";
}
echo " <a href=\"";
echo $BOX_URL1;
echo "resend.php?EMAIL_ID=";
echo $EMAIL_ID;
echo "\"> 再次发送</a> \r\n";
}
echo " </td>\r\n </tr>\r\n";
}
if ( 0 < $LETER_COUNT )
{
echo "<tr class=\"TableControl\">\r\n<td colspan=\"10\">\r\n <input type=\"checkbox\" name=\"allbox\" id=\"allbox_for\" onClick=\"check_all();\">\r\n <label for=\"allbox_for\">全选</label> \r\n <a href=\"javascript:delete_mail();\" title=\"删除所选邮件\"><img src=\"/images/delete.gif\" align=\"absMiddle\">删除</a> \r\n <a href=\"javascript:export_mail();\" title=\"批量导出\"><img src=\"/general/netdisk/images/xls.gif\" align=\"absMiddle\">导出Excel</a> \r\n <a href=\"javascript:export_eml();\" title=\"单独导出\"><img src=\"/general/netdisk/images/eml.gif\" align=\"absMiddle\">导出eml</a>\r\n";
if ( $BOX != 2 && $BOX != 3 && $BOX != 4 )
{
echo " \r\n 转到\r\n <select name=\"BOX_ID\" onChange=\"change_box();\" class=\"SmallSelect\">\r\n <option value=0 ";
if ( $BOX_ID == 0 )
{
echo "selected";
}
echo ">收件箱</option>\r\n";
$DEFAULT_BOXNAME = "PAGESIZE_IN0,PAGESIZE_OUT,PAGESIZE_SENT,PAGESIZE_WEB,PAGESIZE_DEL";
$query = "SELECT * from EMAIL_BOX where USER_ID='".$LOGIN_USER_ID."' and not find_in_set(BOX_NAME,'{$DEFAULT_BOXNAME}') 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>\r\n";
}
echo " </select>\r\n";
}
echo "</td>\r\n</tr>\r\n </table>\r\n";
}
else
{
message( "", "<br>未找到符合条件的邮件" );
}
echo "\r\n<br>\r\n<div align=\"center\">\r\n <input type=\"button\" value=\"返回\" class=\"BigButton\" onClick=\"location='index.php';\">\r\n</div>\r\n\r\n<SCRIPT>\r\nfunction get_checked()\r\n{\r\n checked_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 checked_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 checked_str+=val + \",\";\r\n }\r\n }\r\n return checked_str;\r\n}\r\nfunction export_mail()\r\n{\r\n delete_str=get_checked();\r\n if(delete_str==\"\")\r\n {\r\n alert(\"要导出邮件，请至少选择其中一封。\");\r\n return;\r\n }\r\n window.open('../export_bat.php?DELETE_STR='+ delete_str);\r\n}\r\n\r\nfunction delete_mail()\r\n{\r\n delete_str=get_checked();\r\n if(delete_str==\"\")\r\n {\r\n alert(\"要删除邮件，请至少选择其中一封。\");\r\n return;\r\n }\r\n\r\n\r\n msg='确认要删除所选邮件么？';\r\n if(window.confirm(msg))\r\n {\r\n url=\"";
echo $BOX_URL1;
echo "delete.php?BOX_ID=";
echo $BOX_ID;
echo "&DELETE_STR=\"+ delete_str +\"&PAGE_START=";
echo $PAGE_START;
echo "\";\r\n location=url;\r\n }\r\n}\r\nfunction export_eml()\r\n{\r\n delete_str=get_checked();\r\n if(delete_str==\"\")\r\n {\r\n alert(\"要导出邮件，请至少选择其中一封\");\r\n return;\r\n }\r\n\r\n window.location='../export.php?DELETE_STR='+ delete_str;\r\n}\r\n</SCRIPT>\r\n</body>\r\n</html>\r\n";
?>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -