📄 read_status.php
字号:
<?php
include_once( "inc/auth.php" );
include_once( "inc/utility_all.php" );
if ( $BODY_ID == "" )
{
message( "", "未找到指定邮件" );
exit( );
}
$query = "SELECT * from EMAIL_BODY where BODY_ID=".$BODY_ID." and FROM_ID='{$LOGIN_USER_ID}'";
$cursor = exequery( $connection, $query );
if ( $ROW = mysql_fetch_array( $cursor ) )
{
$TO_ID2 = $ROW['TO_ID2'];
$COPY_TO_ID = $ROW['COPY_TO_ID'];
$SEND_TIME = $ROW['SEND_TIME'];
$SUBJECT = $ROW['SUBJECT'];
$SUBJECT = htmlspecialchars( $SUBJECT );
}
else
{
message( "", "未找到指定邮件" );
exit( );
}
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>\r\nfunction check_all()\r\n{\r\n for (i=0;i<document.all(\"email_select\").length;i++)\r\n {\r\n if(allbox.checked)\r\n document.all(\"email_select\").item(i).checked=true;\r\n else\r\n document.all(\"email_select\").item(i).checked=false;\r\n }\r\n\r\n if(i==0)\r\n {\r\n if(allbox.checked)\r\n document.all(\"email_select\").checked=true;\r\n else\r\n document.all(\"email_select\").checked=false;\r\n }\r\n}\r\n\r\nfunction check_one(el)\r\n{\r\n if(!el.checked)\r\n allbox.checked=false;\r\n}\r\n</SCRIPT>\r\n<body class=\"bodycolor\" topmargin=\"5\">\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/outbox.gif\" WIDTH=\"22\" HEIGHT=\"20\" align=\"absmiddle\"><span class=\"big3\"> 邮件主题 — ";
echo $SUBJECT;
echo "</span>\r\n </td>\r\n </tr>\r\n</table>\r\n\r\n<table border=\"0\" cellspacing=\"1\" width=\"95%\" class=\"small\" bgcolor=\"#000000\" cellpadding=\"3\">\r\n <tr class=\"TableHeader\">\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\">操作</td>\r\n </tr>\r\n";
$query = "select * from EMAIL where BODY_ID=".$BODY_ID." and DELETE_FLAG!='2' and DELETE_FLAG!='4'";
$cursor = exequery( $connection, $query );
while ( $ROW = mysql_fetch_array( $cursor ) )
{
$EMAIL_ID = $ROW['EMAIL_ID'];
$TO_ID = $ROW['TO_ID'];
$READ_FLAG = $ROW['READ_FLAG'];
$READ_TIME = $ROW['READ_TIME'];
$DELETE_FLAG = $ROW['DELETE_FLAG'];
$DEPT_NAME = "";
$TO_NAME = "";
$query1 = "SELECT * from USER where USER_ID='".$TO_ID."'";
$cursor1 = exequery( $connection, $query1 );
if ( $ROW1 = mysql_fetch_array( $cursor1 ) )
{
$DEPT_ID = $ROW1['DEPT_ID'];
$DEPT_NAME = dept_long_name( $DEPT_ID );
$TO_NAME = $ROW1['USER_NAME'];
}
echo "<tr class=\"TableData\">\r\n <td> <input type=\"checkbox\" name=\"email_select\" value=\"";
echo $EMAIL_ID;
echo "\" onClick=\"check_one(self);\">\r\n </td>\r\n <td align=\"center\">\r\n";
if ( $DELETE_FLAG == "1" )
{
$DEL_MAIL_STR .= $EMAIL_ID.",";
echo " <img src=\"/images/email_delete.gif\" alt=\"收件人已删除\">\r\n";
}
else if ( $READ_FLAG == "1" )
{
echo " <img src=\"/images/email_open.gif\" alt=\"阅读于";
echo $READ_TIME;
echo "\">\r\n";
}
else
{
$UNREAD_MAIL_STR .= $EMAIL_ID.",";
echo " <img src=\"/images/email_close.gif\" alt=\"收件人未读\">\r\n";
}
echo " </td>\r\n <td nowrap align=\"center\">\r\n <u title=\"部门：";
echo $DEPT_NAME;
echo "\" style=\"cursor:hand\">";
echo $TO_NAME;
echo "</u>\r\n";
if ( !find_id( $COPY_TO_ID, $TO_ID ) || !find_id( $TO_ID2, $TO_ID ) )
{
echo " (暗送)";
}
echo " </td>\r\n <td nowrap>\r\n";
if ( $READ_FLAG == "0" )
{
echo " <a href=\"edit_email.php?PAGE_START=";
echo $PAGE_START;
echo "&EMAIL_ID=";
echo $EMAIL_ID;
echo "\"> 编辑</a> \r\n";
}
echo " <A href=\"../export.php?EMAIL_ID=";
echo $EMAIL_ID;
echo "\" target=\"_blank\">导出</A> \r\n <a href=\"resend.php?EMAIL_ID=";
echo $EMAIL_ID;
echo "\"> 再次发送</a> \r\n </td>\r\n </tr>\r\n";
}
echo "\r\n<tr class=\"TableControl\">\r\n<td colspan=\"10\">\r\n\r\n<table width=\"100%\" class=\"small\">\r\n<tr>\r\n<td><input type=\"checkbox\" name=\"allbox\" id=\"allbox_for\" onClick=\"check_all();\">\r\n <label for=\"allbox_for\">全选</label> \r\n <input type=\"button\" value=\"删除\" class=\"SmallButton\" onClick=\"delete_mail();\"> \r\n <input type=\"button\" value=\"导出\" class=\"SmallButton\" onClick=\"export_mail();\" title=\"批量导出\"> \r\n</td>\r\n</tr>\r\n</table>\r\n<SCRIPT>\r\nfunction export_mail()\r\n{\r\n delete_str=\"\";\r\n for(i=0;i<document.all(\"email_select\").length;i++)\r\n {\r\n\r\n el=document.all(\"email_select\").item(i);\r\n if(el.checked)\r\n { val=el.value;\r\n delete_str+=val + \",\";\r\n }\r\n }\r\n\r\n if(i==0)\r\n {\r\n el=document.all(\"email_select\");\r\n if(el.checked)\r\n { val=el.value;\r\n delete_str+=val + \",\";\r\n }\r\n }\r\n\r\n if(delete_str==\"\")\r\n {\r\n alert(\"要导出邮件，请至少选择其中一封。\");\r\n return;\r\n }\r\n window.open('../export_bat.php?DELETE_STR='+ delete_str);\r\n}\r\n\r\nfunction delete_mail()\r\n{\r\n var delete_str=\"\";\r\n var email_id=\"\";\r\n for(i=0;i<document.all(\"email_select\").length;i++)\r\n {\r\n\r\n el=document.all(\"email_select\").item(i);\r\n if(el.checked)\r\n delete_str+=el.value + \",\";\r\n else\r\n \tif(email_id==\"\")\r\n email_id=el.value;\r\n }\r\n\r\n if(i==0)\r\n {\r\n el=document.all(\"email_select\");\r\n if(el.checked)\r\n delete_str+=el.value + \",\";\r\n else\r\n \tif(email_id==\"\")\r\n email_id=el.value;\r\n }\r\n\r\n if(delete_str==\"\")\r\n {\r\n alert(\"要删除邮件，请至少选择其中一封。\");\r\n return;\r\n }\r\n\r\n msg='确认要删除所选邮件么？';\r\n if(window.confirm(msg))\r\n {\r\n opener.location=\"delete.php?DELETE_STR=\"+ delete_str +\"&PAGE_START=";
echo $PAGE_START;
echo "\";\r\n location=\"read_status.php?BODY_ID=";
echo $BODY_ID;
echo "&EMAIL_ID=\"+email_id+\"&PAGE_START=";
echo $PAGE_START;
echo "\";\r\n }\r\n}\r\n</SCRIPT>\r\n</html>";
?>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -