index1.php
来自「极限网络智能办公系统 - Office Automation 2008 官方10」· PHP 代码 · 共 194 行
PHP
194 行
<?php
include_once( "inc/auth.php" );
include_once( "inc/utility_all.php" );
if ( $_COOKIE['COUNT_EMAIL_SIZE'] == "" )
{
$query = "SELECT EMAIL_BODY.BODY_ID,ATTACHMENT_ID,ATTACHMENT_NAME from EMAIL,EMAIL_BODY where EMAIL.BODY_ID=EMAIL_BODY.BODY_ID and (FROM_ID='".$LOGIN_USER_ID."' or TO_ID='{$LOGIN_USER_ID}') and ATTACHMENT_NAME!='' and ATTACHMENT_ID!='' and SIZE='0'";
$cursor = exequery( $connection, $query );
while ( $ROW = mysql_fetch_array( $cursor ) )
{
$BODY_ID = $ROW['BODY_ID'];
$ATTACHMENT_ID = $ROW['ATTACHMENT_ID'];
$ATTACHMENT_NAME = $ROW['ATTACHMENT_NAME'];
$ATTACHMENT_ID_ARRAY = explode( ",", $ATTACHMENT_ID );
$ATTACHMENT_NAME_ARRAY = explode( "*", $ATTACHMENT_NAME );
$SIZE = 0;
$I = 0;
for ( ; $I < sizeof( $ATTACHMENT_ID_ARRAY ) - 1; ++$I )
{
$SIZE += attach_size( $ATTACHMENT_ID_ARRAY[$I], $ATTACHMENT_NAME_ARRAY[$I] );
}
$query = "update EMAIL_BODY set SIZE='".$SIZE."' where BODY_ID={$BODY_ID}";
exequery( $connection, $query );
}
$GLOBALS['_COOKIE']['COUNT_EMAIL_SIZE'] = time( );
}
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<script Language=JavaScript>\r\nwindow.setTimeout('this.location.reload();',60000);\r\n\r\nfunction del_mail()\r\n{\r\n msg='确认要删除所有废件箱的邮件？';\r\n if(window.confirm(msg))\r\n {\r\n url=\"delbox/del_email.php?BOX_ID=0&PAGE_START=1\";\r\n location=url;\r\n }\r\n}\r\n</script>\r\n</head>\r\n\r\n<body class=\"bodycolor\" topmargin=\"5\">\r\n\r\n";
$EMAIL_COUNT = 0;
$NEW_COUNT = 0;
$query = "SELECT count(*) from EMAIL,EMAIL_BODY where EMAIL.BODY_ID=EMAIL_BODY.BODY_ID and BOX_ID=0 and TO_ID='".$LOGIN_USER_ID."' and READ_FLAG!='1' and (DELETE_FLAG='' or 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,EMAIL_BODY where EMAIL.BODY_ID=EMAIL_BODY.BODY_ID and BOX_ID=0 and TO_ID='".$LOGIN_USER_ID."' and (DELETE_FLAG='' or 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_BODY 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,EMAIL_BODY where EMAIL.BODY_ID=EMAIL_BODY.BODY_ID and FROM_ID='".$LOGIN_USER_ID."' and DELETE_FLAG!='2' and DELETE_FLAG!='4'";
$cursor = exequery( $connection, $query );
if ( $ROW = mysql_fetch_array( $cursor ) )
{
$SENTBOX_COUNT = $ROW[0];
}
$SENTBOX_COUNT1 = 0;
$query = "SELECT count(*) from EMAIL,EMAIL_BODY where EMAIL.BODY_ID=EMAIL_BODY.BODY_ID and FROM_ID='".$LOGIN_USER_ID."' and DELETE_FLAG='1'";
$cursor = exequery( $connection, $query );
if ( $ROW = mysql_fetch_array( $cursor ) )
{
$SENTBOX_COUNT1 = $ROW[0];
}
$query = "SELECT count(*) from EMAIL,EMAIL_BODY where EMAIL.BODY_ID=EMAIL_BODY.BODY_ID and TO_ID='".$LOGIN_USER_ID."' and READ_FLAG!='1' 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,EMAIL_BODY where EMAIL.BODY_ID=EMAIL_BODY.BODY_ID and TO_ID='".$LOGIN_USER_ID."' 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;
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/email.gif\" WIDTH=\"22\" HEIGHT=\"18\" align=\"absmiddle\"><span class=\"big3\"> 内部邮件</span>\r\n </td>\r\n </tr>\r\n</table>\r\n\r\n<br>\r\n\r\n<table border=\"0\" cellspacing=\"1\" width=\"400\" bgcolor=\"#000000\" cellpadding=\"3\" align=\"center\" class=\"small\">\r\n <tr class=\"TableHeader\">\r\n <td nowrap align=\"center\" width=\"40%\">邮件箱</td>\r\n <td nowrap align=\"center\" width=\"60%\">邮件数</td>\r\n </tr>\r\n <tr class=\"TableData\">\r\n <td nowrap><img src=\"/images/menu/inbox.gif\"> <a href=\"inbox/?BOX_ID=0\">收件箱</a>\r\n";
if ( 0 < $NEW_LETER_COUNT )
{
echo " <img src=\"/images/email_new.gif\">\r\n";
}
echo " </td>\r\n <td> ";
echo $INBOX_COUNT;
echo " （";
echo $NEW_LETER_COUNT;
echo " 封新邮件）</td>\r\n </tr>\r\n <tr class=\"TableData\">\r\n <td nowrap><img src=\"/images/menu/outbox.gif\"> <a href=\"outbox/?BOX_ID=0\">草稿箱</a></td>\r\n <td> ";
echo $OUTBOX_COUNT;
echo "</td>\r\n </tr>\r\n <tr class=\"TableData\">\r\n <td nowrap><img src=\"/images/menu/outbox.gif\"> <a href=\"sentbox/?BOX_ID=0\">已发送</a></td>\r\n <td> ";
echo $SENTBOX_COUNT;
echo " （";
echo $SENTBOX_COUNT1;
echo " 封收件人已删除）</td>\r\n </tr>\r\n <tr class=\"TableData\">\r\n <td nowrap><img src=\"/images/menu/outbox.gif\"> <a href=\"delbox/?BOX_ID=0\">已删除</a></td>\r\n <td> ";
echo $DELBOX_COUNT;
echo " （";
echo $NEW_DEL_COUNT;
echo " 封新邮件） <a href=\"javascript:del_mail();\">清空废件箱</a></td>\r\n </tr>\r\n";
$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,EMAIL_BODY where EMAIL.BODY_ID=EMAIL_BODY.BODY_ID and BOX_ID=".$BOX_ID." and TO_ID='{$LOGIN_USER_ID}' and READ_FLAG!='1' and (DELETE_FLAG='' or 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,EMAIL_BODY where EMAIL.BODY_ID=EMAIL_BODY.BODY_ID and BOX_ID=".$BOX_ID." and TO_ID='{$LOGIN_USER_ID}' and (DELETE_FLAG='' or 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;
echo " <tr class=\"TableData\">\r\n <td nowrap><img src=\"/images/menu/inbox.gif\"> <a href=\"inbox/?BOX_ID=";
echo $BOX_ID;
echo "\">";
echo $BOX_NAME;
echo "</a>\r\n";
if ( 0 < $NEW_LETER_COUNT )
{
echo " <img src=\"/images/email_new.gif\">\r\n";
}
echo " </td>\r\n <td> ";
echo $BOX_COUNT;
echo " （";
echo $NEW_LETER_COUNT;
echo " 封新邮件）</td>\r\n </tr>\r\n";
}
echo " <tr class=\"TableContent\">\r\n <td nowrap align=\"center\"><b>合计：</b></td>\r\n <td nowrap> ";
echo $EMAIL_COUNT;
echo " （";
echo $NEW_COUNT;
echo " 封新邮件）</td>\r\n </tr>\r\n <tr class=\"TableControl\">\r\n <td align=\"center\" colspan=\"3\">\r\n <input type=\"button\" value=\"写新邮件\" class=\"BigButton\" onclick=\"location='new'\" title=\"撰写新的内部邮件\"> \r\n <input type=\"button\" value=\"查询邮件\" class=\"BigButton\" onclick=\"location='query'\" title=\"内部邮件查询\"> \r\n <input type=\"button\" value=\"参数设置\" class=\"BigButton\" onclick=\"location='set'\" title=\"设置邮箱常规选项\"> \r\n <input type=\"button\" value=\"邮件箱管理\" class=\"BigButton\" onclick=\"location='mailbox/manage'\" title=\"内部邮件查询\">\r\n </td>\r\n </tr>\r\n";
$query = "SELECT * from USER where USER_ID='".$LOGIN_USER_ID."'";
$cursor = exequery( $connection, $query );
if ( $ROW = mysql_fetch_array( $cursor ) )
{
$EMAIL_CAPACITY = $ROW['EMAIL_CAPACITY'];
}
if ( $EMAIL_CAPACITY != 0 )
{
$USER_ID = $LOGIN_USER_ID;
$EMAIL_SIZE1 = 0;
$query = "SELECT sum(SIZE) from EMAIL,EMAIL_BODY where EMAIL.BODY_ID=EMAIL_BODY.BODY_ID and TO_ID='".$USER_ID."' and SEND_FLAG='1' and DELETE_FLAG!='1'";
$cursor = exequery( $connection, $query );
if ( $ROW = mysql_fetch_array( $cursor ) )
{
$EMAIL_SIZE1 = $ROW[0];
}
$EMAIL_SIZE2 = 0;
$query = "SELECT sum(SIZE) from EMAIL,EMAIL_BODY where EMAIL.BODY_ID=EMAIL_BODY.BODY_ID and FROM_ID='".$USER_ID."' and SEND_FLAG='0'";
$cursor = exequery( $connection, $query );
if ( $ROW = mysql_fetch_array( $cursor ) )
{
$EMAIL_SIZE2 = $ROW[0];
}
$EMAIL_SIZE3 = 0;
$query = "SELECT sum(SIZE) from EMAIL,EMAIL_BODY where EMAIL.BODY_ID=EMAIL_BODY.BODY_ID and FROM_ID='".$USER_ID."' and SEND_FLAG='1' and DELETE_FLAG!='2' and DELETE_FLAG!='4'";
$cursor = exequery( $connection, $query );
if ( $ROW = mysql_fetch_array( $cursor ) )
{
$EMAIL_SIZE3 = $ROW[0];
}
$EMAIL_CAPACITY = $EMAIL_CAPACITY * 1024 * 1024;
$EMAIL_USE_SIZE = $EMAIL_SIZE1 + $EMAIL_SIZE2 + $EMAIL_SIZE3;
$EMAIL_USE = intval( $EMAIL_USE_SIZE / $EMAIL_CAPACITY * 100 );
if ( 100 < $EMAIL_USE )
{
$EMAIL_USE = 100;
}
echo "\r\n\t<tr class=\"TableControl\">\r\n <td align=\"center\" colspan=\"3\">\r\n\t <b>邮件容量示意图</b> <font color=\"#FF0000\">红:使用</font> <font color=\"#00CC66\">绿:剩余</font><br> <img src=/images/red.gif height=10 width=";
echo $EMAIL_USE * 4;
echo " alt=";
echo number_format( $EMAIL_USE_SIZE, 0, ".", "," );
echo "字节><img src=/images/green.gif height=10 width=";
echo ( 100 - $EMAIL_USE ) * 4;
echo " alt=";
echo number_format( $EMAIL_CAPACITY - $EMAIL_USE_SIZE, 0, ".", "," );
echo "字节>\r\n </td>\r\n </tr>\r\n";
}
echo "</table>\r\n</body>\r\n</html>\r\n";
?>
⌨️ 快捷键说明
复制代码Ctrl + C
搜索代码Ctrl + F
全屏模式F11
增大字号Ctrl + =
减小字号Ctrl + -
显示快捷键?