📄 search.php
字号:
<?php
include_once( "inc/auth.php" );
include_once( "inc/utility_all.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<body class=\"bodycolor\" topmargin=\"5\">\r\n\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 "\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\" WIDTH=\"22\" HEIGHT=\"20\" align=\"absmiddle\">";
echo "<s";
echo "pan class=\"big3\">";
echo $BOX_DESC;
echo " - 查询结果</span>\r\n </td>\r\n </tr>\r\n</table>\r\n<hr width=\"95%\" height=\"1\" align=\"left\" class=\"big1\">\r\n<br>\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}%'";
}
$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 border=\"0\" cellspacing=\"1\" width=\"95%\" class=\"small\" bgcolor=\"#000000\" cellpadding=\"3\">\r\n <tr class=\"TableHeader\">\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 </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( "<", "<", $SUBJECT );
$SUBJECT = str_replace( ">", ">", $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
{
$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'];
$AVATAR = $ROW['AVATAR'];
$DEPT_ID = $ROW['DEPT_ID'];
$DEPT_NAME = dept_long_name( $DEPT_ID );
}
$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('/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')\";>";
}
}
$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 nowrap><img src=\"/images/avatar/";
echo $AVATAR;
echo ".gif\"> <u title=\"部门：";
echo $DEPT_NAME;
echo "\" style=\"cursor:hand\">";
echo $FROM_TO_NAME;
echo "</u></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 " </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 </tr>\r\n";
}
if ( 0 < $LETER_COUNT )
{
echo " </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='./';\">\r\n</div>\r\n\r\n</body>\r\n</html>\r\n";
?>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -