📄 search.php
字号:
<?
include_once 'inc/auth.php';
include_once 'inc/check_type.php';
include_once 'inc/utility_all.php';
echo '
<html>
<head>
<title>查询邮件</title>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
</head>
';
echo '<S';
echo 'CRIPT>
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;
}
}
';
echo '
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=';
echo $PAGE_START;
echo '";
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");
}
function SaveFile(ATTACHMENT_ID,ATTACHMENT_NAME)
{
URL="/module/save_file?ATTACHMENT_ID="+ATTACHMENT_ID+"&ATTACHMENT_NAME="+ATTACHMENT_NAME';
echo '+"&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=yes,top="+loc_y+",left="+loc_x+",resizable=yes");
}
</SCRIPT>
<body class="bodycolor" topmargin="5">
';
if ((($BOX_ID == 0) AND ($BOX == 1)))
{
$BOX_DESC = '收件箱';
$BOX_URL = '../inbox/read_email';
$BOX_URL1 = '../inbox/';
}
else
{
if ((($BOX_ID == 0) AND ($BOX == 2)))
{
$BOX_DESC = '发件箱';
$BOX_URL = '../new/';
$BOX_URL1 = '../outbox/';
}
else
{
if ((($BOX_ID == 0) AND ($BOX == 3)))
{
$BOX_DESC = '已发送邮件箱';
$BOX_URL = '../sentbox//read_email';
$BOX_URL1 = '../sentbox/';
}
else
{
if ((($BOX_ID == 0) AND ($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 '
<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">';
echo '<s';
echo 'pan class="big3">';
echo $BOX_DESC;
echo ' - 查询结果</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) AND ($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 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) AND ($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 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) AND ($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 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) AND ($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 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,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 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) AND ($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 '
<table border="0" cellspacing="1" width="100%" class="small" bgcolor="#000000" cellpadding="3">
<tr class="TableHeader">
<td nowrap align="center">选择</td>
<td nowrap align="center">';
if (((($BOX_ID == 0) AND ($BOX == 1)) OR (0 < $BOX_ID)))
{
echo '发件人';
}
else
{
echo '收件人';
}
echo '</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'];
$BODY_ID = $ROW['BODY_ID'];
$FROM_ID = $ROW['FROM_ID'];
$TO_ID = $ROW['TO_ID'];
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -