📄 index.php
字号:
<?
include_once("inc/auth.php");
?>
<html>
<head>
<title>内部邮件</title>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<script Language=JavaScript>
window.setTimeout('this.location.reload();',60000);
</script>
</head>
<body class="bodycolor" topmargin="5">
<?
$EMAIL_COUNT=0;
$NEW_COUNT=0;
$query = "SELECT count(*) from EMAIL where BOX_ID=0 and TO_ID='$LOGIN_USER_ID' and SEND_FLAG='1' and READ_FLAG='0' and (DELETE_FLAG='0' or DELETE_FLAG='2')";
$cursor= exequery($connection,$query);
$NEW_LETER_COUNT=0;
if($ROW=mysql_fetch_array($cursor))
$NEW_LETER_COUNT=$ROW[0];
$NEW_COUNT=$NEW_LETER_COUNT;
$INBOX_COUNT=0;
$query = "SELECT count(*) from EMAIL where BOX_ID=0 and TO_ID='$LOGIN_USER_ID' and SEND_FLAG='1' and (DELETE_FLAG='0' or DELETE_FLAG='2')";
$cursor= exequery($connection,$query);
if($ROW=mysql_fetch_array($cursor))
$INBOX_COUNT=$ROW[0];
////////////////////////////////////////////////////////////////////////////////////////
$OUTBOX_COUNT=0;
$query = "SELECT count(*) from EMAIL where FROM_ID='$LOGIN_USER_ID' and SEND_FLAG='0'";
$cursor= exequery($connection,$query);
if($ROW=mysql_fetch_array($cursor))
$OUTBOX_COUNT=$ROW[0];
///////////////////////////////////////////////////////////////////////////////////////////////////////////////
$SENTBOX_COUNT=0;
$query = "SELECT count(*) from EMAIL where FROM_ID='$LOGIN_USER_ID' and SEND_FLAG='1' and DELETE_FLAG!='2' and DELETE_FLAG!='4' group by SEND_TIME,TO_ID2";
$cursor= exequery($connection,$query);
$SENTBOX_COUNT=mysql_num_rows($cursor);
$SENTBOX_COUNT1=0;
$query = "SELECT count(*) from EMAIL where FROM_ID='$LOGIN_USER_ID' and SEND_FLAG='1' and DELETE_FLAG='1'";
$cursor= exequery($connection,$query);
if($ROW=mysql_fetch_array($cursor))
$SENTBOX_COUNT1=$ROW[0];
////////////////////////////////////////////////////////////////////////////////////////////////////////////////
$query = "SELECT count(*) from EMAIL where TO_ID='$LOGIN_USER_ID' and SEND_FLAG='1' and READ_FLAG='0' and (DELETE_FLAG='3' or DELETE_FLAG='4')";
$cursor= exequery($connection,$query);
$NEW_DEL_COUNT=0;
if($ROW=mysql_fetch_array($cursor))
$NEW_DEL_COUNT=$ROW[0];
$DELBOX_COUNT=0;
$query = "SELECT count(*) from EMAIL where TO_ID='$LOGIN_USER_ID' and SEND_FLAG='1' and (DELETE_FLAG='3' or DELETE_FLAG='4')";
$cursor= exequery($connection,$query);
if($ROW=mysql_fetch_array($cursor))
$DELBOX_COUNT=$ROW[0];
$EMAIL_COUNT=$INBOX_COUNT+$OUTBOX_COUNT+$SENTBOX_COUNT+$DELBOX_COUNT;
?>
<table border="0" width="100%" cellspacing="0" cellpadding="3" class="small">
<tr>
<td class="Big"><img src="/images/menu/email.gif" WIDTH="22" HEIGHT="18" align="absmiddle"><span class="big3"> 内部邮件</span>
</td>
</tr>
</table>
<br>
<table border="0" cellspacing="1" width="450" class="small" bgcolor="#000000" cellpadding="3" align="center">
<tr class="TableHeader">
<td nowrap align="center" width="40%">邮件箱</td>
<td nowrap align="center" width="60%">邮件数</td>
</tr>
<tr class="TableData">
<td nowrap><img src="/images/menu/inbox.gif"> <a href="inbox/?BOX_ID=0">收件箱</a>
<?
if($NEW_LETER_COUNT>0)
{
?>
<img src="/images/email_new.gif">
<?
}
?>
</td>
<td> <?=$INBOX_COUNT?> （<?=$NEW_LETER_COUNT?> 封新邮件）</td>
</tr>
<tr class="TableData">
<td nowrap><img src="/images/menu/outbox.gif"> <a href="outbox/?BOX_ID=0">发件箱</a></td>
<td> <?=$OUTBOX_COUNT?></td>
</tr>
<tr class="TableData">
<td nowrap><img src="/images/menu/outbox.gif"> <a href="sentbox/?BOX_ID=0">已发送邮件箱</a></td>
<td> <?=$SENTBOX_COUNT?> （<?=$SENTBOX_COUNT1?> 封收件人已删除）</td>
</tr>
<tr class="TableData">
<td nowrap><img src="/images/menu/outbox.gif"> <a href="delbox/?BOX_ID=0">已删除邮件箱</a></td>
<td> <?=$DELBOX_COUNT?> （<?=$NEW_DEL_COUNT?> 封新邮件）</td>
</tr>
<?
$query = "SELECT * from EMAIL_BOX where USER_ID='$LOGIN_USER_ID' order by BOX_NO";
$cursor= exequery($connection,$query);
while($ROW=mysql_fetch_array($cursor))
{
$BOX_ID=$ROW["BOX_ID"];
$BOX_NO=$ROW["BOX_NO"];
$BOX_NAME=$ROW["BOX_NAME"];
$NEW_LETER_COUNT=0;
$query = "SELECT count(*) from EMAIL where BOX_ID=$BOX_ID and TO_ID='$LOGIN_USER_ID' and SEND_FLAG='1' and READ_FLAG='0' and (DELETE_FLAG='0' or DELETE_FLAG='2')";
$cursor1= exequery($connection,$query);
if($ROW1=mysql_fetch_array($cursor1))
$NEW_LETER_COUNT=$ROW1[0];
$BOX_COUNT=0;
$query = "SELECT count(*) from EMAIL where BOX_ID=$BOX_ID and TO_ID='$LOGIN_USER_ID' and SEND_FLAG='1' and (DELETE_FLAG='0' or DELETE_FLAG='2')";
$cursor1= exequery($connection,$query);
if($ROW1=mysql_fetch_array($cursor1))
$BOX_COUNT=$ROW1[0];
$EMAIL_COUNT+=$BOX_COUNT;
$NEW_COUNT+=$NEW_LETER_COUNT;
?>
<tr class="TableData">
<td nowrap><img src="/images/menu/inbox.gif"> <a href="inbox/?BOX_ID=<?=$BOX_ID?>"><?=$BOX_NAME?></a>
<?
if($NEW_LETER_COUNT>0)
{
?>
<img src="/images/email_new.gif">
<?
}
?>
</td>
<td> <?=$BOX_COUNT?> （<?=$NEW_LETER_COUNT?> 封新邮件）</td>
</tr>
<?
}
?>
<tr class="TableContent">
<td nowrap align="center"><b>合计：</b></td>
<td nowrap> <?=$EMAIL_COUNT?> （<?=$NEW_COUNT?> 封新邮件）</td>
</tr>
<tr class="TableControl">
<td align="center" colspan="3">
<input type="button" value="写新邮件" class="BigButton" onclick="location='new'" title="撰写新的内部邮件">
<input type="button" value="查询邮件" class="BigButton" onclick="location='query'" title="内部邮件查询">
<input type="button" value="邮件箱管理" class="BigButton" onclick="location='mailbox/manage'" title="内部邮件查询">
</td>
</tr>
</table>
</body>
</html>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -