📄 email.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>
<body class="bodycolor" topmargin="5">
';
if ($BEGIN_DATE != '')
{
$TIME_OK = is_date_time ($BEGIN_DATE);
if (!($TIME_OK))
{
message ('错误', '起始日期格式不对，应形如 1999-1-2 14:55:20');
button_back ();
exit ();
}
}
if ($END_DATE != '')
{
$TIME_OK = is_date_time ($END_DATE);
if (!($TIME_OK))
{
message ('错误', '截止日期格式不对，应形如 1999-1-2 14:55:20');
button_back ();
exit ();
}
}
if ($END_DATE != '')
{
if ($BEGIN_DATE != '')
{
if ($END_DATE < $BEGIN_DATE)
{
message ('错误', '截止时间不能晚于起始时间!');
button_back ();
exit ();
}
}
}
$query = 'select * from EMAIL where 1=1 ';
if ($TO_ID != '')
{
$query .= ' and find_in_set(FROM_ID,\'' . $TO_ID . '\')';
}
if ($COPY_TO_ID != '')
{
$query .= ' and find_in_set(TO_ID,\'' . $COPY_TO_ID . '\')';
}
if ($BEGIN_DATE != '')
{
$query .= ' and SEND_TIME>=\'' . $BEGIN_DATE . '\'';
}
if ($END_DATE != '')
{
$query .= ' and SEND_TIME<=\'' . $END_DATE . '\'';
}
if ($SUBJECT != '')
{
$query .= ' and SUBJECT like \'%' . $SUBJECT . '%\'';
}
if ($CONTENT != '')
{
$query .= ' and CONTENT like \'%' . $CONTENT . '%\'';
}
$query .= ' order by SEND_TIME desc';
$cursor = exequery ($connection, $query);
$COUNT = mysql_num_rows ($cursor);
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"><span class="big3"> 查询结果</span>
</td>
</tr>
</table>
';
if ($COUNT == 0)
{
message ('', '无符合条件的查询结果');
button_back ();
exit ();
}
echo '<table border="0" cellspacing="1" width="95%" class="small" bgcolor="#000000" cellpadding="3">
<tr class="TableHeader" align="center">
<td width="40">状态</td>
<td width="60">发件人</td>
<td width="60">收件人</td>
<td>主题</td>
<td>附件</td>
<td width="120">发送时间 <img border=0 src="/images/arrow_down.gif" width="11" height="10"></td>
</tr>
';
while ($ROW = mysql_fetch_array ($cursor))
{
$EMAIL_ID = $ROW['EMAIL_ID'];
$FROM_ID = $ROW['FROM_ID'];
$TO_ID = $ROW['TO_ID'];
if (0 < strpos ($TO_ID, ','))
{
$TO_ID = substr ($TO_ID, 0, strpos ($TO_ID, ','));
}
$READ_FLAG = $ROW['READ_FLAG'];
$DELETE_FLAG = $ROW['DELETE_FLAG'];
$SUBJECT = $ROW['SUBJECT'];
$SUBJECT = htmlspecialchars ($SUBJECT);
$SEND_TIME = $ROW['SEND_TIME'];
$ATTACHMENT_ID = $ROW['ATTACHMENT_ID'];
$ATTACHMENT_NAME = $ROW['ATTACHMENT_NAME'];
if ($READ_FLAG == '0')
{
$STATUS_DESC = '<img src="/images/email_close.gif" alt="收件人未读">';
}
else
{
$STATUS_DESC = '<img src="/images/email_open.gif" alt="收件人已读">';
}
$FROM_NAME = '';
$query1 = 'SELECT * from USER where USER_ID=\'' . $FROM_ID . '\'';
$cursor1 = exequery ($connection, $query1);
if ($ROW = mysql_fetch_array ($cursor1))
{
$FROM_NAME = $ROW['USER_NAME'];
}
$TO_NAME = '';
$query1 = 'SELECT * from USER where USER_ID=\'' . $TO_ID . '\'';
$cursor1 = exequery ($connection, $query1);
if ($ROW = mysql_fetch_array ($cursor1))
{
$TO_NAME = $ROW['USER_NAME'];
}
$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)
{
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') AND !stristr ($ATTACHMENT_NAME_ARRAY[$I], '.ppt')) AND !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\')";>';
continue;
}
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\');"> ';
continue;
}
continue;
}
}
echo ' <tr class="TableData">
<td align="center">';
echo $STATUS_DESC;
echo '</td>
<td align="center">';
echo $FROM_NAME;
echo '</td>
<td align="center">';
echo $TO_NAME;
echo '</td>
<td><a href="read_email.php?EMAIL_ID=';
echo $EMAIL_ID;
echo '">';
echo $SUBJECT;
echo '</a></td>
<td>
';
if ($ATTACHMENT_NAME != '')
{
echo $EMAIL_ATTACH;
}
echo ' </td>
<td align="center">';
echo $SEND_TIME;
echo '</td>
</tr>
';
}
echo '</table>
<br>
<div align="center">
<input type="button" value="返回" class="BigButton" onClick="location=\'index.php\';">
</div>
</body>
</html>
';
?>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -