📄 index.php
字号:
<?
include_once("inc/auth.php");
include_once("inc/utility_all.php");
$PAGE_SIZE=intVal($_COOKIE[$LOGIN_USER_ID."_email_ps_sent"]);
if($PAGE_SIZE<=0 || $PAGE_SIZE>=1000)
$PAGE_SIZE=10;
?>
<html>
<head>
<title>已发送邮件箱</title>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<SCRIPT>
function set_page()
{
PAGE_START=(PAGE_NUM.value-1)*<?=$PAGE_SIZE?>+1;
location="index.php?PAGE_START="+PAGE_START;
}
function check_all()
{
for (i=0;i<document.all("email_select").length;i++)
{
if(allbox.checked)
document.all("email_select").item(i).checked=true;
else
document.all("email_select").item(i).checked=false;
}
if(i==0)
{
if(allbox.checked)
document.all("email_select").checked=true;
else
document.all("email_select").checked=false;
}
}
function check_one(el)
{
if(!el.checked)
allbox.checked=false;
}
function read_status(EMAIL_ID)
{
URL="read_status.php?EMAIL_ID="+EMAIL_ID+"&PAGE_START=<?=$PAGE_START?>";
myleft=(screen.availWidth-400)/2;
mytop=250
mywidth=400;
myheight=300;
window.open(URL,"read","height="+myheight+",width="+mywidth+",status=1,toolbar=no,menubar=no,location=no,scrollbars=yes,top="+mytop+",left="+myleft+",resizable=yes");
}
</SCRIPT>
</head>
<body class="bodycolor" topmargin="5">
<?
$query = "SELECT * from EMAIL where FROM_ID='$LOGIN_USER_ID' and SEND_FLAG='1' and DELETE_FLAG!='2' and DELETE_FLAG!='4' group by SEND_TIME,TO_ID2 order by SEND_TIME desc";
$cursor= exequery($connection,$query);
$LETER_COUNT=mysql_num_rows($cursor);
if($LETER_COUNT==0)
{
?>
<table border="0" width="100%" cellspacing="0" cellpadding="3" class="small">
<tr>
<td class="Big"><img src="/images/menu/outbox.gif" WIDTH="22" HEIGHT="20" align="absmiddle"><span class="big3"> 已发送邮件箱</span>
</td>
</tr>
</table>
<br>
<br>
<?
Message("","已发送邮件箱无邮件");
?>
<br>
<div align="center">
<input type="button" value="返回" class="BigButton" onClick="location='../';">
</div>
<?
exit;
}
//============ 分页 =================
//--- 计算总页数 ---
$PAGE_TOTAL=$LETER_COUNT/$PAGE_SIZE;
$PAGE_TOTAL=ceil($PAGE_TOTAL);
//--- 计算,末页 ---
if($LETER_COUNT<=$PAGE_SIZE)
$LAST_PAGE_START=1;
else if($LETER_COUNT%$PAGE_SIZE==0)
$LAST_PAGE_START=$LETER_COUNT-$PAGE_SIZE+1;
else
$LAST_PAGE_START=$LETER_COUNT-$LETER_COUNT%$PAGE_SIZE+1;
//--- 智能分页 ---
//-- 页首 --
if($PAGE_START=="")
$PAGE_START=1;
if($PAGE_START>$LETER_COUNT)
$PAGE_START=$LAST_PAGE_START;
if($PAGE_START<1)
$PAGE_START=1;
//-- 页尾 --
$PAGE_END=$PAGE_START+$PAGE_SIZE-1;
if($PAGE_END>$LETER_COUNT)
$PAGE_END=$LETER_COUNT;
//--- 计算当前页 ---
$PAGE_NUM=($PAGE_START-1)/$PAGE_SIZE+1;
?>
<table border="0" width="100%" cellspacing="0" cellpadding="3" class="small">
<tr>
<td class="Big"><img src="/images/menu/outbox.gif" WIDTH="22" HEIGHT="20" align="absmiddle"><span class="big3"> 已发送邮件箱</span>
</td>
<td valign="bottom" class="small1">共<span class="big4"> <?=$LETER_COUNT?></span> 封邮件
</td>
<td valign="bottom" class="small1">
当前为第<b><?=$PAGE_START?></b>至<b><?=$PAGE_END?></b>封 (第<?=$PAGE_NUM?>页，共<?=$PAGE_TOTAL?>页，每页最多<?=$PAGE_SIZE?>封)</font>
</td>
</tr>
</table>
<br>
<table border="0" cellspacing="1" width="95%" class="small" bgcolor="#000000" cellpadding="3">
<tr class="TableHeader">
<td nowrap align="center">选择</td>
<td nowrap align="center">状态</td>
<td nowrap align="center">收件人</td>
<td nowrap align="center">主题</td>
<td nowrap align="center">重要程度</td>
<td nowrap align="center">附件</td>
<td nowrap align="center">日期 <img border=0 src="/images/arrow_down.gif" width="11" height="10"></td>
<td nowrap align="center">字节</td>
<td nowrap align="center">操作</td>
</tr>
<?
//============================ 显示邮件信息 =======================================
// $query = "SELECT * from EMAIL where FROM_ID='$LOGIN_USER_ID' and SEND_FLAG='1' and DELETE_FLAG!='2' group by SEND_TIME,TO_ID2 order by SEND_TIME desc";
// $cursor= exequery($connection,$query);
$LETER_COUNT=0;
while($ROW=mysql_fetch_array($cursor))
{
$LETER_COUNT++;
if($LETER_COUNT<$PAGE_START)
continue;
else if($LETER_COUNT>$PAGE_END)
break;
$EMAIL_ID=$ROW["EMAIL_ID"];
$TO_ID=$ROW["TO_ID"];
$TO_ID2=$ROW["TO_ID2"];
$COPY_TO_ID=$ROW["COPY_TO_ID"];
$READ_FLAG=$ROW["READ_FLAG"];
$DELETE_FLAG=$ROW["DELETE_FLAG"];
$IMPORTANT=$ROW["IMPORTANT"];
$SEND_TIME=$ROW["SEND_TIME"];
$SUBJECT=$ROW["SUBJECT"];
$SUBJECT=htmlspecialchars($SUBJECT);
$EMAIL_ID_STR="";
$query="select * from EMAIL where FROM_ID='$LOGIN_USER_ID' and SEND_FLAG='1' and DELETE_FLAG!='2' and DELETE_FLAG!='4' and SEND_TIME='$SEND_TIME' and TO_ID2='$TO_ID2'";
$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);
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>";
$ATTACHMENT_ID=$ROW["ATTACHMENT_ID"];
$ATTACHMENT_NAME=$ROW["ATTACHMENT_NAME"];
$CONTENT=$ROW["CONTENT"];
$EMAIL_SIZE=strlen($CONTENT)+strlen($SUBJECT);
$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"];
}
//--- 计算附件大小 ---
$ATTACHMENT_ID_ARRAY=explode(",",$ATTACHMENT_ID);
$ATTACHMENT_NAME_ARRAY=explode("*",$ATTACHMENT_NAME);
$ARRAY_COUNT=sizeof($ATTACHMENT_ID_ARRAY);
$EMAIL_ATTACH="";
for($I=0;$I<$ARRAY_COUNT-1;$I++)
{
$EMAIL_SIZE+=attach_size($ATTACHMENT_ID_ARRAY[$I],$ATTACHMENT_NAME_ARRAY[$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');\"> ";
}
}
$EMAIL_SIZE=number_format($EMAIL_SIZE,0, ".",",");
if($LETER_COUNT%2==1)
$TableLine="TableLine1";
else
$TableLine="TableLine2";
?>
<tr class="<?=$TableLine?>">
<td> <input type="checkbox" name="email_select" value="<?=$EMAIL_ID_STR?>" onClick="check_one(self);"></td>
<td align="center">
<?
if($GROUP_COUNT>1)
{
?>
<a href="javascript:read_status('<?=$EMAIL_ID?>');">查看</a>
<?
}
else
{
if($DELETE_FLAG=="1"||$DELETE_FLAG=="4")
{
$DEL_MAIL_STR.=$EMAIL_ID.",";
?>
<img src="/images/email_delete.gif" alt="收件人已删除">
<?
}
else if($READ_FLAG=="1")
{
?>
<img src="/images/email_open.gif" alt="收件人已读">
<?
}
else
{
$UNREAD_MAIL_STR.=$EMAIL_ID.",";
?>
<img src="/images/email_close.gif" alt="收件人未读">
<?
}
}
?>
</td>
<td nowrap align="center">
<?
if($GROUP_COUNT>1)
{
?>
<a href="javascript:read_status('<?=$EMAIL_ID?>');">查看</a>
<?
}
else
{
?>
<u title="部门：<?=$DEPT_NAME?>" style="cursor:hand"><?=$TO_NAME?></u>
<?
if(!find_id($COPY_TO_ID,$TO_ID)&&!find_id($TO_ID2,$TO_ID))
echo " (暗送)";
}
?>
</td>
<td><a href="read_email?PAGE_START=<?=$PAGE_START?>&EMAIL_ID=<?=$EMAIL_ID?>&CURSOR_ID=<?=$LETER_COUNT-1?>"><?=$SUBJECT?></a></td>
<td align="center" nowrap><?=$IMPORTANT_DESC?></td>
<td>
<?
if($ATTACHMENT_NAME!="")
{
echo $EMAIL_ATTACH;
}
?>
</td>
<td nowrap align="center"><?=$SEND_TIME?></td>
<td nowrap align="center"><?=$EMAIL_SIZE?></td>
<td nowrap>
<?
if($GROUP_COUNT==1)
{
if($READ_FLAG=="0")
{
?>
<a href="edit_email.php?PAGE_START=<?=$PAGE_START?>&EMAIL_ID=<?=$EMAIL_ID?>"> 编辑</a>
<?
}
?>
<A href="../export.php?EMAIL_ID=<?=$EMAIL_ID?>" target="_blank">导出</A>
<a href="resend.php?EMAIL_ID=<?=$EMAIL_ID?>"> 再次发送</a>
</td>
</tr>
<?
}
}
?>
<tr class="TableControl">
<td colspan="10">
<table width="100%" class="small">
<tr>
<td><input type="checkbox" name="allbox" id="allbox_for" onClick="check_all();">
<label for="allbox_for">全选</label>
<input type="button" value="删除" class="SmallButton" onClick="delete_mail();">
<input type="button" value="导出" class="SmallButton" onClick="export_mail();" title="批量导出">
</td>
<td align="right">
<input type="button" value="首页" class="SmallButton" <?if($PAGE_START==1)echo "disabled";?> onclick="location='index.php'">
<input type="button" value="上一页" class="SmallButton" <?if($PAGE_START==1)echo "disabled";?> onclick="location='index.php?PAGE_START=<?=($PAGE_START-$PAGE_SIZE)?>'">
<input type="button" value="下一页" class="SmallButton" <?if($PAGE_END>=$LETER_COUNT)echo "disabled";?> onclick="location='index.php?PAGE_START=<?=($PAGE_END+1)?>'">
<input type="button" value="末页" class="SmallButton" <?if($PAGE_END>=$LETER_COUNT)echo "disabled";?> onclick="location='index.php?PAGE_START=<?=$LAST_PAGE_START?>'">
页数
<input type="text" name="PAGE_NUM" value="<?=$PAGE_NUM?>" class="SmallInput" size="2"> <input type="button" value="转到" class="SmallButton" onclick="set_page();" title="转到指定的页面">
</td>
</tr>
</table>
</td>
</tr>
</table>
<br>
<table border="0" cellspacing="1" width="95%" class="small" bgcolor="#000000" cellpadding="3">
<tr>
<td class="TableContent" nowrap align="center" width="80"><b>批量删除：</b></td>
<td class="TableControl" nowrap>
<img src="/images/delete.gif"> <a href="javascript:del_mail('del','所有收件人已删除');" title="删除所有收件人已删除邮件">删除所有收件人已删除邮件</a>
<img src="/images/delete.gif"> <a href="javascript:del_mail('unread','所有收件人未读');" title="删除所有收件人未读邮件">删除所有收件人未读邮件</a>
</td>
</tr>
</table>
<br>
<div align="center">
<input type="button" value="返回" class="BigButton" onClick="location='../';">
</div>
</body>
<SCRIPT>
function delete_mail_one(EMAIL_ID)
{
msg='确认要删除该邮件么？\n注意：如果删除对方未读邮件，对方将不会接收到该邮件！';
if(window.confirm(msg))
{
url="delete.php?DELETE_STR="+ EMAIL_ID +"&PAGE_START=<?=$PAGE_START?>";
location=url;
}
}
function export_mail()
{
delete_str="";
for(i=0;i<document.all("email_select").length;i++)
{
el=document.all("email_select").item(i);
if(el.checked)
{ val=el.value;
delete_str+=val + ",";
}
}
if(i==0)
{
el=document.all("email_select");
if(el.checked)
{ val=el.value;
delete_str+=val + ",";
}
}
if(delete_str=="")
{
alert("要导出邮件，请至少选择其中一封。");
return;
}
window.open('../export_bat.php?DELETE_STR='+ delete_str);
}
function delete_mail()
{
delete_str="";
for(i=0;i<document.all("email_select").length;i++)
{
el=document.all("email_select").item(i);
if(el.checked)
{ val=el.value;
delete_str+=val + ",";
}
}
if(i==0)
{
el=document.all("email_select");
if(el.checked)
{ val=el.value;
delete_str+=val + ",";
}
}
if(delete_str=="")
{
alert("要删除邮件，请至少选择其中一封。");
return;
}
msg='确认要删除所选邮件么？\n注意：如果删除对方未读邮件，对方将不会接收到该邮件！';
if(window.confirm(msg))
{
url="delete.php?DELETE_STR="+ delete_str +"&PAGE_START=<?=$PAGE_START?>";
location=url;
}
}
function del_mail(delete_str,type_str)
{
if(delete_str=="")
{
alert("无"+type_str+"的邮件！");
return;
}
msg='确认要删除'+type_str+'邮件么？';
if(window.confirm(msg))
{
url="del_email.php?DELETE="+ delete_str +"&PAGE_START=<?=$PAGE_START?>";
location=url;
}
}
</SCRIPT>
</html>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -