📄 search_email.php
字号:
<?php
include_once( "inc/auth.php" );
include_once( "inc/function_page_01.php" );
include_once( "ikernel/utility.php" );
include_once( "inc/utility_all.php" );
if ( $_REQUEST['cur_page'] == "" )
{
$cur_page = 1;
}
else
{
$cur_page = $_REQUEST['cur_page'];
}
$page_purview = 12;
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</head>\r\n\r\n<body class=\"bodycolor\" topmargin=\"5\">\r\n";
$SAFE_CHECK_OK = 0;
if ( find_id( $USER_FUNC_ID_STR, $page_purview ) )
{
$SAFE_CHECK_OK = 1;
}
if ( $SAFE_CHECK_OK == 0 )
{
message( "警告", "无该模块使用权限！如需使用该模块，请联系管理员重新设置本角色权限！" );
exit( );
}
echo "\r\n<table border=\"0\" width=\"100%\" cellspacing=\"1\" cellpadding=\"0\" class=\"small\">\r\n <tr>\r\n <td class=\"tablehead1\"><img src=\"/images/menu/inbox.gif\" align=\"absmiddle\"> 收件箱 - 查询结果</td>\r\n\t<tr class=\"tableline2\">\r\n\t<td> \r\n\t</td>\r\n\t</tr>\r\n</table>\r\n<br>\r\n<table border=\"0\" cellspacing=\"1\" width=\"100%\" class=\"small\" cellpadding=\"3\">\r\n <tr class=\"TableHeader\">\r\n ";
$sens = $_REQUEST['sens'] ? 0 : 1;
$sensimg = $_REQUEST['sens'] ? "arrow_up.gif" : "arrow_down.gif";
$sensimg = "/images/".$sensimg;
$sufurl = $_SERVER['PHP_SELF']."?sens=".$sens."&keyword=".$_REQUEST['keyword'];
echo " \r\n \r\n <td width=\"3%\" nowrap >选择</td>\r\n <td width=\"7%\" nowrap ><a href=\"";
echo $sufurl;
echo "&order=status\">状态</a>\r\n ";
if ( $_REQUEST['order'] == "status" )
{
echo "<img src='".$sensimg."'>";
}
echo "</td>\r\n <td width=\"12%\" nowrap ><a href=\"";
echo $sufurl;
echo "&order=fromuser\">发件人</a> ";
if ( $_REQUEST['order'] == "fromuser" )
{
echo "<img src='".$sensimg."'>";
}
echo "</td>\r\n <td nowrap ><a href=\"";
echo $sufurl;
echo "&order=subjecet\">主题</a> ";
if ( $_REQUEST['order'] == "subjecet" )
{
echo "<img src='".$sensimg."'>";
}
echo "</td>\r\n <td width=\"5%\" nowrap >附件</td>\r\n <td width=\"15%\" nowrap ><a href=\"";
echo $sufurl;
echo "&order=sendtime\">日期</a> ";
if ( $_REQUEST['order'] == "sendtime" )
{
echo "<img src='".$sensimg."'>";
}
echo "</td>\r\n <td width=\"8%\" nowrap >大小</td>\r\n <td width=\"8%\" nowrap >操作</td>\r\n </tr>\r\n ";
$sql = " \r\n SELECT u.USER_ID,u.USER_NAME,up.PRIV_NAME,d.DEPT_NAME FROM user u,user_priv up,department d\r\n\t\t WHERE 1 \r\n\t\t\t AND u.USER_PRIV=up.USER_PRIV \r\n\t\t\t AND u.DEPT_ID=d.DEPT_ID\r\n\t\t\t ORDER BY u.USER_ID DESC ";
$res = exequery( $connection, $sql );
while ( $row = mysql_fetch_array( $res ) )
{
$userarray[$row['USER_ID']]['username'] = $row['USER_NAME'];
$userarray[$row['USER_ID']]['priv'] = $row['PRIV_NAME'];
$userarray[$row['USER_ID']]['dept'] = $row['DEPT_NAME'];
}
$sql = "\r\n SELECT EMAIL_ID,FROM_ID,TO_ID,COPY_TO_ID,TO_ID2,SUBJECT,CONTENT,SEND_TIME,ATTACHMENT_ID,ATTACHMENT_NAME,READ_FLAG,SEND_FLAG,DELETE_FLAG,SMS_REMIND,BOX_ID FROM email\r\n\t\t WHERE 1 AND (\r\n\t\t\t TO_ID='".$_SESSION['LOGIN_USER_ID']."') \r\n\t\t\t\tAND SEND_FLAG='1' \r\n\t\t\t\tAND DELETE_FLAG<>'1'\r\n\t\t\t\tAND BOX_ID=0\r\n ";
if ( $_REQUEST['keyword'] != "" )
{
$sql .= " AND SUBJECT LIKE '%".$_REQUEST['keyword']."%'";
$sql .= " AND CONTENT LIKE '%".$_REQUEST['keyword']."%'";
}
switch ( $_REQUEST['order'] )
{
case "status" :
$sql .= "ORDER BY READ_FLAG ";
break;
case "fromuser" :
$sql .= "ORDER BY FROM_ID ";
break;
case "subjecet" :
$sql .= "ORDER BY SUBJECT ";
break;
case "sendtime" :
$sql .= "ORDER BY SEND_TIME ";
break;
default :
$sql .= "ORDER BY SEND_TIME ";
}
$sql .= $_REQUEST['sens'] ? " ASC" : " DESC";
$sql = page( $sql, 12 );
$res = exequery( $connection, $sql );
$email_count = 0;
$email_new_count = 0;
while ( $row = mysql_fetch_array( $res ) )
{
if ( $_REQUEST['keyword'] != "" )
{
$content = replacestr( substrgb( strip_tags( $row['CONTENT'] ), 200, "..." ), "red", $_REQUEST['keyword'] );
$subject = replacestr( substrgb( strip_tags( $row['SUBJECT'] ), 50, "..." ), "red", $_REQUEST['keyword'] );
}
else
{
$content = substrgb( strip_tags( $row['CONTENT'] ), 200, "..." );
$subject = substrgb( strip_tags( $row['SUBJECT'] ), 50, "..." );
}
$email_id = $row['EMAIL_ID'];
$from_id = $row['FROM_ID'];
$from_name = $userarray[$from_id]['username'];
$to_id = $row['TO_ID'];
$to_id2 = $row['TO_ID2'];
$copy_to_id = $row['COPY_TO_ID'];
$to_name = $userarray[$to_id]['username'];
$send_time = $row['SEND_TIME'];
$read_flag = $row['READ_FLAG'];
$rd_fg_im_dir = "/images/littlegif/";
$read_flag_img = $rd_fg_im_dir.( $read_flag ? "b046.gif" : "icon-new.gif" );
$read_flag_img_title = $read_flag ? "已读" : "未读";
$attachment_id = $row['ATTACHMENT_ID'];
$attachment_name = $row['ATTACHMENT_NAME'];
$email_size = strlen( $row['SUBJECT'] ) + strlen( $row['CONTENT'] );
++$email_count;
$email_new_count = $read_flag ? $email_new_count : $email_new_count + 1;
$attachment_id_array = explode( ",", $attachment_id );
$attachment_name_array = explode( "*", $attachment_name );
$i = 0;
for ( ; $i < count( $attachment_id_array ); ++$i )
{
$email_size += attach_size( $attachment_id_array[$i], $attachment_name_array[$i] );
}
if ( $email_size <= 1024 )
{
$email_size_str = $email_size." <span style=\"color:#333333;font-size:12px\">B</span>";
}
if ( 1024 < $email_size )
{
$email_size_str = round( $email_size / 1024 )." <span style=\"color:#333333;font-size:12px\">KB</span>";
}
if ( 1048576 <= $email_size )
{
$email_size_str = round( $email_size / 1048576 )." <span style=\"color:#333333;font-size:12px\">MB</span>";
}
if ( !find_id( $copy_to_id, $to_id ) && !find_id( $to_id2, $to_id ) )
{
$from_name_str = $from_name."(暗送)";
}
else
{
$from_name_str = $from_name;
}
if ( $attachment_id != "" )
{
unset( $at_img_title );
$at_nm_count = sizeof( $attachment_name_array );
$at_nm_amount = 0;
while ( list( $key, $var ) = each( $attachment_name_array ) )
{
++$at_nm_amount;
if ( $var != "" )
{
if ( $at_nm_amount == $at_nm_count )
{
$at_img_title .= $var;
}
else
{
$at_img_title .= $var." \r\n";
}
}
}
$attachment_str = "<img src=\"/images/treeicon/attachment_ico.gif\" title=\"".$at_img_title."\">";
}
else
{
$attachment_str = "";
}
if ( $email_count % 2 == 1 )
{
$TableLine = "TableLine1";
}
else
{
$TableLine = "TableLine2";
}
echo " \r\n\r\n <tr class=\"";
echo $TableLine;
echo "\">\r\n <td> \r\n <input type=\"checkbox\" name=\"email_select\" value=\"";
echo $email_id;
echo "\" onClick=\"check_one(self);\">\r\n </td>\r\n <td align=\"center\" ><img src=\"";
echo $read_flag_img;
echo "\" title=\"";
echo $read_flag_img_title;
echo "\">\r\n </td>\r\n <td nowrap><u title=\"部门：";
echo $userarray[$from_id]['dept'];
echo " \r\n角色：";
echo $userarray[$from_id]['priv'];
echo "\" style=\"cursor:hand\"><a href=\"/general/email/inbox/read_email?PAGE_START=";
echo $PAGE_START;
echo "&EMAIL_ID=";
echo $email_id;
echo "&BOX_ID=0\">\r\n ";
echo $from_name_str;
echo " </a>\r\n </u></td>\r\n <td><a href=\"/general/email/inbox/read_email?PAGE_START=";
echo $PAGE_START;
echo "&EMAIL_ID=";
echo $email_id;
echo "&BOX_ID=0\" title=\"";
echo $content;
echo "\">\r\n ";
echo $subject;
echo " </a>\r\n <td>";
echo $attachment_str;
echo "</td>\r\n <td nowrap >";
echo $send_time;
echo "</td>\r\n <td nowrap >";
echo $email_size_str;
echo "</td>\r\n <td nowrap > <A href=\"/general/email/export.php?EMAIL_ID=";
echo $email_id;
echo "\" target=\"_blank\">导出</A> </td>\r\n </tr>\r\n ";
}
echo "</table>\r\n<table width=\"100%\" cellpadding=\"5\" cellspacing=\"0\" >\r\n <tr class=\"TableLine2\">\r\n <td><input type=\"checkbox\" name=\"allbox\" ";
if ( 0 < $total_page_nums )
{
echo "onClick=\"check_all();\"";
}
echo ">\r\n 全部选中 \r\n <input type=\"button\" value=\"标记为已读\" class=\"SmallButton\" title=\"标记为已读\" ";
if ( 0 < $total_page_nums )
{
echo "onClick=\"read_mail();\"";
}
echo ">\r\n \r\n <input type=\"button\" value=\"删除\" class=\"SmallButton\" title=\"删除所选邮件\" ";
if ( 0 < $total_page_nums )
{
echo "onClick=\"delete_mail();\"";
}
echo ">\r\n \r\n <input name=\"button\" type=\"button\" class=\"SmallButton\" title=\"导出\" value=\"导出\" ";
if ( 0 < $total_page_nums )
{
echo "onClick=\"export_mail();\"";
}
echo ">\r\n \r\n </td>\r\n <td width=\"20%\"> </td>\r\n </tr>\r\n</table>\r\n<table width=\"100%\" border=\"0\" cellspacing=\"0\" cellpadding=\"0\">\r\n <tr class=\"TableLine2\">\r\n <td align=\"right\">";
disp( "keyword=".$_REQUEST['keyword']."&order=".$_REQUEST['order']."&sens=".$_REQUEST['sens'] );
echo "</td>\r\n <td width=\"2%\" align=\"right\"></td>\r\n </tr>\r\n</table>\r\n</body>\r\n</html>\r\n";
echo "<s";
echo "cript>\r\nfunction check_all()\r\n{\r\n for (i=0;i<document.all(\"email_select\").length;i++)\r\n {\r\n if(document.all(\"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(document.all(\"allbox\").checked)\r\n document.all(\"email_select\").checked=true;\r\n else\r\n document.all(\"email";
echo "_select\").checked=false;\r\n }\r\n}\r\n\r\nfunction check_one(el)\r\n{\r\n if(!el.checked)\r\n document.all(\"allbox\").checked=false;\r\n}\r\n\r\nfunction change_box()\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 ";
echo " 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 document.form1.reset();\r\n return;\r\n }\r\n \r\n box_id=document.all(\"BOX_ID\").value;\r\n url=\"../change_box.php?DELETE_STR=\"+ delete_str +\"&BOX_ID=\"+box_id+\"&PAGE_START=";
echo $PAGE_START;
echo "\";\r\n location=url;\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+=";
echo "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 msg='确认要删除所选邮件么？';\r\n if(window.confirm(msg))\r\n {\r\n url=\"/general/email/do.php?id_str=\"+ delete_str +\"&cur_page=";
echo $_REQUEST['cur_page'];
echo "&order=";
echo $_REQUEST['order'];
echo "&sens=";
echo $_REQUEST['sens'];
echo "&keyword=";
echo $_REQUEST['keyword'];
echo "&f=delete\";\r\n location=url;\r\n }\r\n}\r\n\r\n\r\nfunction export_mail()\r\n{\r\n export_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 export_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 ";
echo " export_str+=val + \",\";\r\n }\r\n }\r\n\r\n if(export_str==\"\")\r\n {\r\n alert(\"要导出邮件，请至少选择其中一封。\");\r\n return;\r\n }\r\n url=\"/general/email/replace.php?export_str=\"+ export_str;\r\n //location=url;\r\n window.open(url,\"download\",\"width=200,height=100,scrollbar=no,resizable=yes\");\r\n}\r\n\r\nfunction read_mail()\r\n{\r\n read_str=\"\";\r\n for(i=0;i<document.all(\"email_select\").length;i++)";
echo "\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 read_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 read_str+=val + \",\";\r\n }\r\n }\r\n\r\n if(read_str==\"\")\r\n {\r\n alert(\"要将邮件标记为已读，请至少选择其中一封。\");\r\n return;\r\n ";
echo "}\r\n\r\n msg='确认要将所选邮件标记为已读么？';\r\n if(window.confirm(msg))\r\n {\r\n url=\"/general/email/do.php?id_str=\"+ read_str +\"&cur_page=";
echo $_REQUEST['cur_page'];
echo "&order=";
echo $_REQUEST['order'];
echo "&sens=";
echo $_REQUEST['sens'];
echo "&keyword=";
echo $_REQUEST['keyword'];
echo "&f=readok\";\r\n location=url;\r\n }\r\n}\r\n</script>\r\n";
if ( 0 < ( $n = $_REQUEST['cur_page'] - $total_page_nums ) )
{
$cur_page = $_REQUEST['cur_page'] - $n;
header( "location:".$_SERVER['PHP_SELF']."?&keyword=".$_REQUEST['keyword']."&order=".$_REQUEST['order']."&sens=".$_REQUEST['sens']."&cur_page=".$cur_page );
}
?>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -