⭐ 欢迎来到虫虫下载站！ | 📦 资源下载 📁 资源专辑 ℹ️ 关于我们
⭐ 虫虫下载站
📤 上传资源

📄 index.php

📁 通达网络办公 - Office Anywhere 2008 增强版100％源码(3.4.081216) 内含 通达OA2008增強版接近完美破解补丁20081216集 及 最新通达OA2008ADV(
💻 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\r\n<script Language=\"JavaScript\">\r\nfunction CheckForm()\r\n{\r\n   if(document.form1.BOX_NO.value==\"\")\r\n   { alert(\"邮箱序号不能为空！\");\r\n     return (false);\r\n   }\r\n\r\n   if(document.form1.BOX_NAME.value==\"\")\r\n   { alert(\"邮箱名称不能为空！\");\r\n     return (false);\r\n   }\r\n}\r\n\r\nfunction delete_mis(BOX_ID)\r\n{\r\n msg='删除该邮箱将删除该邮箱下的所有邮件，确认要删除该邮箱么？';\r\n if(window.confirm(msg))\r\n {\r\n  URL=\"delete.php?BOX_ID=\" + BOX_ID;\r\n  window.location=URL;\r\n }\r\n}\r\n\r\nfunction setCookie(name,value) {\r\n   var today = new Date();\r\n   var expires = new Date();\r\n   expires.setTime(today.getTime() + 1000*60*60*24*365);\r\n   parent.document.cookie = name + \"=\" + escape(value) + \"; expires=\" + expires.toGMTString();\r\n}\r\nfunction checkNum(str)\r\n{\r\n   var re=/\\D/;\r\n   return str.match(re);\r\n}\r\n\r\nfunction SetEmailNums(UserID,BoxName,BOX_NO,BOX_ID)\r\n{\r\n   var CountValue=document.all(BoxName).value;\r\n   if(CountValue==\"\")\r\n   {\r\n      alert(\"请输入数值\");\r\n      return false;\r\n   }\r\n   if(checkNum(CountValue))\r\n   {\r\n      alert(\"显示封数必须是数字\");\r\n      return false;\r\n   }\r\n\r\n   if(parseInt(CountValue)<=0 || parseInt(CountValue)>=1000)\r\n   {\r\n      alert(\"显示封数必须在1-1000之间\");\r\n      return false;\r\n   }\r\n   window.location=\"setCount.php?CountValue=\"+CountValue+\"&BoxName=\"+BoxName+\"&BOX_ID=\"+BOX_ID+\"&BOX_NO=\"+BOX_NO;\r\n}\r\n</script>\r\n</head>\r\n\r\n<body class=\"bodycolor\" topmargin=\"5\" onLoad=\"document.form1.BOX_NO.focus();\">\r\n\r\n<table border=\"0\" width=\"100%\" cellspacing=\"0\" cellpadding=\"3\" class=\"small\">\r\n  <tr>\r\n    <td class=\"Big\"><img src=\"/images/notify_new.gif\" align=\"absmiddle\"><span class=\"big3\"> 添加邮件箱</span>\r\n    </td>\r\n  </tr>\r\n</table>\r\n\r\n<table class=\"TableBlock\" width=\"450\" align=\"center\" >\r\n  <form action=\"add.php\"  method=\"post\" name=\"form1\" onSubmit=\"return CheckForm();\">\r\n   <tr>\r\n    <td nowrap class=\"TableData\">序号：</td>\r\n    <td nowrap class=\"TableData\">\r\n        <input type=\"text\" name=\"BOX_NO\" class=\"BigInput\" size=\"25\" maxlength=\"25\">&nbsp;\r\n    </td>\r\n   </tr>\r\n   <tr>\r\n    <td nowrap class=\"TableData\">名称：</td>\r\n    <td nowrap class=\"TableData\">\r\n        <input type=\"text\" name=\"BOX_NAME\" class=\"BigInput\" size=\"25\" maxlength=\"25\">&nbsp;\r\n    </td>\r\n   </tr>\r\n   <tr>\r\n    <td nowrap  class=\"TableControl\" colspan=\"2\" align=\"center\">\r\n        <input type=\"submit\" value=\"添加\" class=\"BigButton\" title=\"添加\" name=\"button\">\r\n    </td>\r\n  </form>\r\n</table>\r\n\r\n<br>\r\n\r\n<table width=\"95%\" border=\"0\" cellspacing=\"0\" cellpadding=\"0\" height=\"3\">\r\n <tr>\r\n   <td background=\"/images/dian1.gif\" width=\"100%\"></td>\r\n </tr>\r\n</table>\r\n\r\n<table border=\"0\" width=\"100%\" cellspacing=\"0\" cellpadding=\"3\" class=\"small\">\r\n  <tr>\r\n    <td class=\"Big\"><img src=\"/images/notify_open.gif\" align=\"absmiddle\"><span class=\"big3\"> 管理邮件箱</span>\r\n    </td>\r\n  </tr>\r\n</table>\r\n";
$query = "SELECT DEFAULT_COUNT from EMAIL_BOX where USER_ID='".$LOGIN_USER_ID."' and BOX_NAME='PAGESIZE_IN0'";
$cursor = exequery( $connection, $query );
if ( $ROW = mysql_fetch_array( $cursor ) )
{
	$PAGESIZE_IN0 = $ROW[0];
}
else
{
	$PAGESIZE_IN0 = 10;
}
$query = "SELECT DEFAULT_COUNT from EMAIL_BOX where USER_ID='".$LOGIN_USER_ID."' and BOX_NAME='PAGESIZE_OUT'";
$cursor = exequery( $connection, $query );
if ( $ROW = mysql_fetch_array( $cursor ) )
{
	$PAGESIZE_OUT = $ROW[0];
}
else
{
	$PAGESIZE_OUT = 10;
}
$query = "SELECT DEFAULT_COUNT from EMAIL_BOX where USER_ID='".$LOGIN_USER_ID."' and BOX_NAME='PAGESIZE_SENT'";
$cursor = exequery( $connection, $query );
if ( $ROW = mysql_fetch_array( $cursor ) )
{
	$PAGESIZE_SENT = $ROW[0];
}
else
{
	$PAGESIZE_SENT = 10;
}
$query = "SELECT DEFAULT_COUNT from EMAIL_BOX where USER_ID='".$LOGIN_USER_ID."' and BOX_NAME='PAGESIZE_WEB'";
$cursor = exequery( $connection, $query );
if ( $ROW = mysql_fetch_array( $cursor ) )
{
	$PAGESIZE_WEB = $ROW[0];
}
else
{
	$PAGESIZE_WEB = 10;
}
$query = "SELECT DEFAULT_COUNT from EMAIL_BOX where USER_ID='".$LOGIN_USER_ID."' and BOX_NAME='PAGESIZE_DEL'";
$cursor = exequery( $connection, $query );
if ( $ROW = mysql_fetch_array( $cursor ) )
{
	$PAGESIZE_DEL = $ROW[0];
}
else
{
	$PAGESIZE_DEL = 10;
}
$query = "SELECT sum(SIZE) from EMAIL,EMAIL_BODY where EMAIL.BODY_ID=EMAIL_BODY.BODY_ID and BOX_ID=0 and TO_ID='".$LOGIN_USER_ID."' and SEND_FLAG='1' and (DELETE_FLAG='' or DELETE_FLAG='0' or DELETE_FLAG='2')";
$cursor = exequery( $connection, $query );
if ( $ROW = mysql_fetch_array( $cursor ) )
{
	$EMAIL_SIZE1 = $ROW[0];
}
$query = "SELECT sum(SIZE) from EMAIL_BODY where FROM_ID='".$LOGIN_USER_ID."' and SEND_FLAG='0'";
$cursor = exequery( $connection, $query );
if ( $ROW = mysql_fetch_array( $cursor ) )
{
	$EMAIL_SIZE2 = $ROW[0];
}
$query = "SELECT distinct EMAIL_BODY.BODY_ID, SIZE 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' group by EMAIL.BODY_ID";
$cursor = exequery( $connection, $query );
while ( $ROW = mysql_fetch_array( $cursor ) )
{
	$EMAIL_SIZE3 += $ROW['SIZE'];
}
$query = "SELECT sum(SIZE) 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 ) )
{
	$EMAIL_SIZE4 = $ROW[0];
}
$query = "SELECT sum(SIZE) from EMAIL_BODY where FROM_ID='".$LOGIN_USER_ID."' and SEND_FLAG='1' and TO_WEBMAIL!=''";
$cursor = exequery( $connection, $query );
if ( $ROW = mysql_fetch_array( $cursor ) )
{
	$EMAIL_SIZE5 = $ROW[0];
}
$EMAIL_SIZE1_M = number_format( $EMAIL_SIZE1 / 1024 / 1024, 2, ".", "," );
$EMAIL_SIZE += $EMAIL_SIZE1;
$EMAIL_SIZE1 = number_format( $EMAIL_SIZE1, 0, ".", "," );
$EMAIL_SIZE2_M = number_format( $EMAIL_SIZE2 / 1024 / 1024, 2, ".", "," );
$EMAIL_SIZE += $EMAIL_SIZE2;
$EMAIL_SIZE2 = number_format( $EMAIL_SIZE2, 0, ".", "," );
$EMAIL_SIZE3_M = number_format( $EMAIL_SIZE3 / 1024 / 1024, 2, ".", "," );
$EMAIL_SIZE += $EMAIL_SIZE3;
$EMAIL_SIZE3 = number_format( $EMAIL_SIZE3, 0, ".", "," );
$EMAIL_SIZE4_M = number_format( $EMAIL_SIZE4 / 1024 / 1024, 2, ".", "," );
$EMAIL_SIZE += $EMAIL_SIZE4;
$EMAIL_SIZE4 = number_format( $EMAIL_SIZE4, 0, ".", "," );
$EMAIL_SIZE5_M = number_format( $EMAIL_SIZE5 / 1024 / 1024, 2, ".", "," );
$EMAIL_SIZE5 = number_format( $EMAIL_SIZE5, 0, ".", "," );
echo "<br>\r\n<table class=\"TableList\" width=\"90%\" align=\"center\">\r\n     <tr class=\"TableHeader\">\r\n      <td nowrap align=\"center\" width=\"50\">编号</td>\r\n      <td nowrap align=\"center\">名称</td>\r\n      <td nowrap align=\"center\">占用空间</td>\r\n      <td nowrap align=\"center\">每页显示邮件数</td>\r\n      <td nowrap align=\"center\" width=\"60\">操作</td>\r\n    </tr>\r\n    <tr class=\"TableData\">\r\n      <td nowrap>\r\n      </td>\r\n      <td nowrap align=\"center\">收件箱</td>\r\n      <td>　";
echo $EMAIL_SIZE1;
echo " 字节 （约合";
echo $EMAIL_SIZE1_M;
echo "M）</td>\r\n      <td nowrap><input type=\"text\" value=\"";
echo $PAGESIZE_IN0;
echo "\" name=\"PAGESIZE_IN0\" class=\"SmallInput\" size=\"3\"> <input type=\"button\" value=\"设置\" class=\"SmallButton\" onClick=\"SetEmailNums('";
echo $LOGIN_USER_ID;
echo "','PAGESIZE_IN0','0');\"></td>\r\n      <td nowrap align=\"center\"></td>\r\n    </tr>\r\n    <tr class=\"TableData\">\r\n      <td nowrap></td>\r\n      <td nowrap align=\"center\">发件箱</td>\r\n      <td>　";
echo $EMAIL_SIZE2;
echo " 字节 （约合";
echo $EMAIL_SIZE2_M;
echo "M）</td>\r\n      <td nowrap><input type=\"text\" value=\"";
echo $PAGESIZE_OUT;
echo "\" name=\"PAGESIZE_OUT\" class=\"SmallInput\" size=\"3\"> <input type=\"button\" value=\"设置\" class=\"SmallButton\" onClick=\"SetEmailNums('";
echo $LOGIN_USER_ID;
echo "','PAGESIZE_OUT','0');\"></td>\r\n      <td nowrap align=\"center\"></td>\r\n    </tr>\r\n    <tr class=\"TableData\">\r\n      <td nowrap></td>\r\n      <td nowrap align=\"center\">已发送邮件箱</td>\r\n      <td>　";
echo $EMAIL_SIZE3;
echo " 字节 （约合";
echo $EMAIL_SIZE3_M;
echo "M）</td>\r\n      <td nowrap><input type=\"text\" value=\"";
echo $PAGESIZE_SENT;
echo "\" name=\"PAGESIZE_SENT\" class=\"SmallInput\" size=\"3\"> <input type=\"button\" value=\"设置\" class=\"SmallButton\" onClick=\"SetEmailNums('";
echo $LOGIN_USER_ID;
echo "','PAGESIZE_SENT','0');\"></td>\r\n      <td nowrap align=\"center\"></td>\r\n    </tr>\r\n    <tr class=\"TableData\">\r\n      <td nowrap></td>\r\n      <td nowrap align=\"center\">外发邮件箱</td>\r\n      <td>　";
echo $EMAIL_SIZE5;
echo " 字节 （约合";
echo $EMAIL_SIZE5_M;
echo "M）</td>\r\n      <td nowrap><input type=\"text\" value=\"";
echo $PAGESIZE_WEB;
echo "\" name=\"PAGESIZE_WEB\" class=\"SmallInput\" size=\"3\"> <input type=\"button\" value=\"设置\" class=\"SmallButton\" onClick=\"SetEmailNums('";
echo $LOGIN_USER_ID;
echo "','PAGESIZE_WEB','0');\"></td>\r\n      <td nowrap align=\"center\"></td>\r\n    </tr>\r\n    <tr class=\"TableData\">\r\n      <td nowrap></td>\r\n      <td nowrap align=\"center\">废件箱</td>\r\n      <td>　";
echo $EMAIL_SIZE4;
echo " 字节 （约合";
echo $EMAIL_SIZE4_M;
echo "M）</td>\r\n      <td nowrap><input type=\"text\" value=\"";
echo $PAGESIZE_DEL;
echo "\" name=\"PAGESIZE_DEL\" class=\"SmallInput\" size=\"3\"> <input type=\"button\" value=\"设置\" class=\"SmallButton\" onClick=\"SetEmailNums('";
echo $LOGIN_USER_ID;
echo "','PAGESIZE_DEL','0');\"></td>\r\n      <td nowrap align=\"center\"></td>\r\n    </tr>\r\n";
$DEFAULT_BOXNAME = "PAGESIZE_IN0,PAGESIZE_OUT,PAGESIZE_SENT,PAGESIZE_WEB,PAGESIZE_DEL";
$query = "SELECT * from EMAIL_BOX where USER_ID='".$LOGIN_USER_ID."' and not find_in_set(BOX_NAME,'{$DEFAULT_BOXNAME}') 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'];
	$EMAIL_SIZE1 = 0;
	$query = "SELECT sum(SIZE) from EMAIL,EMAIL_BODY where EMAIL.BODY_ID=EMAIL_BODY.BODY_ID and BOX_ID='".$BOX_ID."' and TO_ID='{$LOGIN_USER_ID}' and SEND_FLAG='1' and DELETE_FLAG!='1'";
	$cursor1 = exequery( $connection, $query );
	if ( $ROW = mysql_fetch_array( $cursor1 ) )
	{
		$EMAIL_SIZE1 = $ROW[0];
	}
	$query = "SELECT DEFAULT_COUNT from EMAIL_BOX where BOX_ID=".$BOX_ID;
	$cursor1 = exequery( $connection, $query );
	if ( $ROW = mysql_fetch_array( $cursor1 ) )
	{
		$THIS_COUNT = $ROW[0];
	}
	else
	{
		$THIS_COUNT = 10;
	}
	$EMAIL_SIZE1_M = number_format( $EMAIL_SIZE1 / 1024 / 1024, 2, ".", "," );
	$EMAIL_SIZE += $EMAIL_SIZE1;
	$EMAIL_SIZE1 = number_format( $EMAIL_SIZE1, 0, ".", "," );
	echo "    <tr class=\"TableData\">\r\n      <td nowrap align=\"center\">";
	echo $BOX_NO;
	echo "</td>\r\n      <td nowrap align=\"center\">";
	echo $BOX_NAME;
	echo "</td>\r\n      <td nowrap>　";
	echo $EMAIL_SIZE1;
	echo " 字节 （约合";
	echo $EMAIL_SIZE1_M;
	echo "M）</td>\r\n      <td nowrap><input type=\"text\" value=\"";
	echo $THIS_COUNT;
	echo "\" name=\"PAGESIZE_IN";
	echo $BOX_ID;
	echo "\" class=\"SmallInput\" size=\"3\"> <input type=\"button\" value=\"设置\" class=\"SmallButton\" onClick=\"SetEmailNums('";
	echo $LOGIN_USER_ID;
	echo "','PAGESIZE_IN";
	echo $BOX_ID;
	echo "','";
	echo $BOX_NO;
	echo "','";
	echo $BOX_ID;
	echo "');\"></td>\r\n      <td nowrap align=\"center\">\r\n      <a href=\"edit.php?BOX_ID=";
	echo $BOX_ID;
	echo "\"> 编辑</a>\r\n      <a href=\"javascript:delete_mis('";
	echo $BOX_ID;
	echo "');\"> 删除</a>\r\n      </td>\r\n    </tr>\r\n";
}
$EMAIL_SIZE_M = number_format( $EMAIL_SIZE / 1024 / 1024, 2, ".", "," );
$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 )
{
	$PERCENT = floor( $EMAIL_SIZE / 1024 / 1024 / $EMAIL_CAPACITY * 100 );
	if ( 100 < $PERCENT )
	{
		$PERCENT = 100;
	}
	if ( $PERCENT <= 60 )
	{
		$BAR_COLOR = "#00FF40";
	}
	else if ( $PERCENT <= 80 )
	{
		$BAR_COLOR = "#FF6600";
	}
	else
	{
		$BAR_COLOR = "#FF0000";
	}
	$PROGRESS_BAR = "<div class=\"percent\" style=\"width:400px;\"><div style=\"background-color:".$BAR_COLOR.";width: ".$PERCENT."%;float:left;\"></div></div></div><div class=\"percenttxt\" style=\"font-size:9pt\">&nbsp;".$PERCENT."% (已用".$EMAIL_SIZE_M."MB，共".$EMAIL_CAPACITY."MB)</div>";
}
echo "    <tr class=\"TableContent\">\r\n      <td nowrap align=\"center\" colspan=\"2\"><b>合计：</b></td>\r\n      <td nowrap colspan=\"3\">";
if ( $EMAIL_CAPACITY != 0 )
{
	echo $PROGRESS_BAR;
}
else
{
	echo "&nbsp;&nbsp;".$EMAIL_SIZE_M."MB";
}
echo "</td>\r\n    </tr>\r\n</table>\r\n</body>\r\n</html>";
?>

⌨️ 快捷键说明

复制代码 Ctrl + C
搜索代码 Ctrl + F
全屏模式 F11
切换主题 Ctrl + Shift + D
显示快捷键 ?
增大字号 Ctrl + =
减小字号 Ctrl + -