📄 search.php
字号:
echo "</td>\r\n <td nowrap align=\"center\">主题</td>\r\n <td nowrap align=\"center\">附件</td>\r\n <td nowrap align=\"center\">日期 <img border=0 src=\"/images/arrow_down.gif\" width=\"11\" height=\"10\"></td>\r\n <td nowrap align=\"center\">大小</td>\r\n <td nowrap align=\"center\">操作</td>\r\n </tr>\r\n";
}
$EMAIL_ID = $ROW['EMAIL_ID'];
$BODY_ID = $ROW['BODY_ID'];
$FROM_ID = $ROW['FROM_ID'];
$TO_ID = $ROW['TO_ID'];
$TO_ID2 = $ROW['TO_ID2'];
$READ_FLAG = $ROW['READ_FLAG'];
$SUBJECT = $ROW['SUBJECT'];
$CONTENT = $ROW['CONTENT'];
$IMPORTANT = $ROW['IMPORTANT'];
$SIZE = $ROW['SIZE'];
$ATTACHMENT_ID = $ROW['ATTACHMENT_ID'];
$ATTACHMENT_NAME = $ROW['ATTACHMENT_NAME'];
$SUBJECT = htmlspecialchars( $SUBJECT );
$SEND_TIME = substr( $ROW['SEND_TIME'], 5, -3 );
$EMAIL_SIZE = strlen( $CONTENT ) + strlen( $SUBJECT ) + $SIZE;
if ( 0 < floor( $EMAIL_SIZE / 1024 / 1024 ) )
{
$EMAIL_SIZE = round( $EMAIL_SIZE / 1024 / 1024, 1 )."M";
}
else
{
$EMAIL_SIZE = ceil( $EMAIL_SIZE / 1024 )."K";
}
if ( $IMPORTANT == "0" || $IMPORTANT == "" )
{
$IMPORTANT_DESC = "";
}
else if ( $IMPORTANT == "1" )
{
$IMPORTANT_DESC = "<span class=\"TextColor1\">重要</span>";
}
else if ( $IMPORTANT == "2" )
{
$IMPORTANT_DESC = "<span class=\"TextColor2\">非常重要</span>";
}
$GROUP_COUNT = 1;
if ( $BOX_ID == 0 && $BOX == 3 )
{
$EMAIL_ID_STR = "";
$query = "select EMAIL_ID from EMAIL where BODY_ID=".$BODY_ID;
$cursor1 = exequery( $connection, $query );
$GROUP_COUNT = mysql_num_rows( $cursor1 );
while ( $ROW1 = mysql_fetch_array( $cursor1 ) )
{
$EMAIL_ID_STR .= $ROW1['EMAIL_ID'].",";
}
$EMAIL_ID_STR = substr( $EMAIL_ID_STR, 0, -1 );
}
else
{
$EMAIL_ID_STR = $EMAIL_ID;
}
if ( $BOX == 1 )
{
$query1 = "SELECT USER_NAME,DEPT_ID from USER where USER_ID='".$FROM_ID."'";
}
else
{
$query1 = "SELECT USER_NAME,DEPT_ID from USER where USER_ID='".$TO_ID."'";
}
$cursor1 = exequery( $connection, $query1 );
if ( $ROW = mysql_fetch_array( $cursor1 ) )
{
$FROM_TO_NAME = $ROW['USER_NAME'];
$DEPT_ID = $ROW['DEPT_ID'];
$DEPT_NAME = dept_long_name( $DEPT_ID );
}
else
{
$FROM_TO_NAME = $FROM_ID;
$AVATAR = "";
$DEPT_NAME = "用户已删除";
}
if ( $BOX == 2 )
{
$FROM_TO_NAME = "";
$query1 = "SELECT USER_NAME from USER where find_in_set(USER_ID,'".$TO_ID."')";
$cursor1 = exequery( $connection, $query1 );
while ( $ROW = mysql_fetch_array( $cursor1 ) )
{
$FROM_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 = "";
$I = 0;
for ( ; $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" ) || stristr( $ATTACHMENT_NAME_ARRAY[$I], ".ppt" ) || 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')\";>";
}
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');\"> ";
}
}
if ( $LETER_COUNT % 2 == 1 )
{
$TableLine = "TableLine1";
}
else
{
$TableLine = "TableLine2";
}
echo " <tr class=\"";
echo $TableLine;
echo "\">\r\n <td> <input type=\"checkbox\" name=\"email_select\" value=\"";
echo $EMAIL_ID_STR;
echo "\" onClick=\"check_one(self);\"></td>\r\n <td nowrap align=\"center\">\r\n";
if ( 1 < $GROUP_COUNT )
{
echo " <a href=\"javascript:read_status('";
echo $EMAIL_ID;
echo "');\">查看</a>\r\n";
}
else if ( $BOX != 2 )
{
echo " <u title=\"部门：";
echo $DEPT_NAME;
echo "\" style=\"cursor:hand\">";
echo $FROM_TO_NAME;
echo "</u>\r\n";
}
else
{
echo " ";
echo $FROM_TO_NAME;
}
echo " </td>\r\n <td><a href=\"";
echo $BOX_URL;
echo "?EMAIL_ID=";
echo $EMAIL_ID;
echo "&BOX_ID=";
echo $BOX_ID;
echo "&QUERY=1\">";
echo $SUBJECT;
echo "</a> ";
echo $IMPORTANT_DESC;
echo "</td>\r\n <td>\r\n";
if ( $ATTACHMENT_ID == "" )
{
echo "无";
}
else
{
echo attach_link( $ATTACHMENT_ID, $ATTACHMENT_NAME, 1, 1, 1, 0, 0, 1, 1, 0, "" );
}
echo " </td>\r\n </td>\r\n <td nowrap align=\"center\">";
echo $SEND_TIME;
echo "</td>\r\n <td nowrap align=\"center\">";
echo $EMAIL_SIZE;
echo "</td>\r\n <td nowrap align=\"center\">\r\n";
if ( $GROUP_COUNT == 1 && $BOX_ID == 0 && $BOX == 3 )
{
if ( $READ_FLAG == "0" )
{
echo " <a href=\"";
echo $BOX_URL1;
echo "edit_email.php?PAGE_START=";
echo $PAGE_START;
echo "&EMAIL_ID=";
echo $EMAIL_ID;
echo "\"> 编辑</a> \r\n";
}
echo " <a href=\"";
echo $BOX_URL1;
echo "resend.php?EMAIL_ID=";
echo $EMAIL_ID;
echo "\"> 再次发送</a> \r\n";
}
echo " </td>\r\n </tr>\r\n";
}
if ( 0 < $LETER_COUNT )
{
echo "<tr class=\"TableControl\">\r\n<td colspan=\"10\">\r\n <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=\"导出Excel\" class=\"SmallButton\" onClick=\"export_mail();\" title=\"批量导出\"> \r\n <input type=\"button\" value=\"导出eml\" class=\"SmallButton\" onClick=\"export_eml();\" title=\"单独导出\"> \r\n</td>\r\n</tr>\r\n </table>\r\n";
}
else
{
message( "", "<br>未找到符合条件的邮件" );
}
echo "\r\n<br>\r\n<div align=\"center\">\r\n <input type=\"button\" value=\"返回\" class=\"BigButton\" onClick=\"location='index.php';\">\r\n</div>\r\n\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 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\r\n\r\n msg='确认要删除所选邮件么？';\r\n if(window.confirm(msg))\r\n {\r\n url=\"";
echo $BOX_URL1;
echo "delete.php?BOX_ID=";
echo $BOX_ID;
echo "&DELETE_STR=\"+ delete_str +\"&PAGE_START=";
echo $PAGE_START;
echo "\";\r\n location=url;\r\n }\r\n}\r\nfunction export_eml()\r\n{\r\n count=0;\r\n for(i=0;i<document.all(\"email_select\").length;i++)\r\n {\r\n el=document.all(\"email_select\").item(i);\r\n if(el.checked)\r\n { email_id=el.value;\r\n count++;\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 { email_id=el.value;\r\n count++;\r\n }\r\n }\r\n \r\n if(count>1)\r\n {\r\n alert(\"每次只能导出一封。\");\r\n return;\r\n }\r\n\r\n if(count==0)\r\n {\r\n alert(\"要导出邮件，请至少选择其中一封\");\r\n return;\r\n }\r\n window.location='../export.php?EMAIL_ID='+ email_id;\r\n}\r\n</SCRIPT>\r\n</body>\r\n</html>\r\n";
?>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -