index.php
来自「通达OA2007SE源代码 非常好的」· PHP 代码 · 共 469 行
PHP
469 行
<?
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) OR (1000 <= $PAGE_SIZE)))
{
$PAGE_SIZE = 10;
}
if ((!isset ($PAGE_START) OR ($PAGE_START == '')))
{
$PAGE_START = 0;
}
echo '
<html>
<head>
<title>已发送邮件箱</title>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
';
echo '<S';
echo 'CRIPT>
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;
}
}
';
echo '
function check_one(el)
{
if(!el.checked)
allbox.checked=false;
}
function read_status(BODY_ID)
{
URL="read_status.php?BODY_ID="+BODY_ID+"&PAGE_START=';
echo $PAGE_START;
echo '";
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");
}
function SaveFile(ATTACHMENT_ID,ATTACHMENT_NAME)
{
URL="/module/save_file?ATTACHMENT_ID="+ATTACHMENT_ID+"&ATTACHMENT_NAME="+ATTACHMENT_NAME';
echo '+"&A=1";
loc_x=document.body.scrollLeft+event.clientX-event.offsetX-100;
loc_y=document.body.scrollTop+event.clientY-event.offsetY+170;
window.open(URL,null,"height=180,width=400,status=1,toolbar=no,menubar=no,location=no,scrollbars=yes,top="+loc_y+",left="+loc_x+",resizable=yes");
}
</SCRIPT>
</head>
<body class="bodycolor" topmargin="5">
';
$query = (((''.'SELECT EMAIL_ID,TO_ID,READ_FLAG,DELETE_FLAG,EMAIL_BODY.BODY_ID,TO_ID2,COPY_TO_ID,TO_WEBMAIL,SUBJECT,SEND_TIME,ATTACHMENT_ID,ATTACHMENT_NAME,IMPORTANT,SIZE,USER_NAME,DEPT_ID from EMAIL_BODY,EMAIL LEFT JOIN USER ON USER.USER_ID = EMAIL.TO_ID where EMAIL.BODY_ID=EMAIL_BODY.BODY_ID and FROM_ID=\'').$LOGIN_USER_ID).'\' and DELETE_FLAG!=\'2\' and DELETE_FLAG!=\'4\' group by EMAIL.BODY_ID order by SEND_TIME desc');
$cursor = exequery ($connection, $query);
$LETER_COUNT = mysql_num_rows ($cursor);
echo '<table border="0" width="100%" cellspacing="0" cellpadding="3" class="small">
<tr>
<td class="Big"><img src="/images/sentbox.gif" WIDTH="20" HEIGHT="20" align="absmiddle">';
echo '<s';
echo 'pan class="big3"> 已发送邮件箱</span>
</td>
<td valign="bottom" class="small1">共';
echo '<s';
echo 'pan class="big4"> ';
echo $LETER_COUNT;
echo '</span> 封邮件</td>
<td align="right" valign="bottom" class="small1">';
echo page_bar ($PAGE_START, $LETER_COUNT, $PAGE_SIZE, 'PAGE_START');
echo '</td>
</tr>
</table>
';
if (($LETER_COUNT == 0))
{
echo '<br>
<br>
';
message ('', '已发送邮件箱无邮件');
echo '<br>
<div align="center">
<input type="button" value="返回" class="BigButton" onClick="location=\'../\';">
</div>
';
exit ();
}
echo '
<table border="0" cellspacing="1" width="100%" 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">日期 <img border=0 src="/images/arrow_';
echo 'down.gif" width="11" height="10"></td>
<td nowrap align="center">字节</td>
<td nowrap align="center">操作</td>
</tr>
';
$LETER_COUNT = 0;
while ($ROW = mysql_fetch_array ($cursor))
{
++$LETER_COUNT;
if (($LETER_COUNT <= $PAGE_START))
{
continue;
}
else
{
if ((($PAGE_START + $PAGE_SIZE) < $LETER_COUNT))
{
break;
}
$EMAIL_ID = $ROW['EMAIL_ID'];
$BODY_ID = $ROW['BODY_ID'];
$TO_ID = $ROW['TO_ID'];
$TO_ID2 = $ROW['TO_ID2'];
$COPY_TO_ID = $ROW['COPY_TO_ID'];
$TO_WEBMAIL = $ROW['TO_WEBMAIL'];
$READ_FLAG = $ROW['READ_FLAG'];
$DELETE_FLAG = $ROW['DELETE_FLAG'];
$IMPORTANT = $ROW['IMPORTANT'];
$SIZE = $ROW['SIZE'];
$SUBJECT = $ROW['SUBJECT'];
$ATTACHMENT_ID = $ROW['ATTACHMENT_ID'];
$ATTACHMENT_NAME = $ROW['ATTACHMENT_NAME'];
$SUBJECT = htmlspecialchars ($SUBJECT);
$SEND_TIME = substr ($ROW['SEND_TIME'], 0, -3);
$TO_NAME = $ROW['USER_NAME'];
$DEPT_ID = $ROW['DEPT_ID'];
$DEPT_NAME = dept_long_name ($DEPT_ID);
if (($TO_NAME == ''))
{
$TO_NAME = $TO_ID;
$DEPT_NAME = '用户已删除';
}
$EMAIL_ID_STR = '';
$query = (((''.'select EMAIL_ID from EMAIL where BODY_ID=').$BODY_ID).' and DELETE_FLAG!=\'2\' and DELETE_FLAG!=\'4\'');
$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 ((substr ($TO_WEBMAIL, -1) == ','))
{
$TO_WEBMAIL = substr ($TO_WEBMAIL, 0, -1);
}
$WEBMAIL_DESC = '';
if (($TO_WEBMAIL != ''))
{
$WEBMAIL_DESC = (('<img src=\'/images/mailout.gif\' align=\'absMiddle\' title=\'外发至:'.$TO_WEBMAIL).'\'> ');
}
if ((($IMPORTANT == '0') OR ($IMPORTANT == '')))
{
$IMPORTANT_DESC = '';
}
else
{
if (($IMPORTANT == '1'))
{
$IMPORTANT_DESC = '<span class="TextColor1">重要</span>';
}
else
{
if (($IMPORTANT == '2'))
{
$IMPORTANT_DESC = '<span class="TextColor2">非常重要</span>';
}
}
}
$EMAIL_SIZE = (strlen ($SUBJECT) + ($SIZE * $GROUP_COUNT));
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 ((($LETER_COUNT % 2) == 1))
{
$TableLine = 'TableLine1';
}
else
{
$TableLine = 'TableLine2';
}
echo ' <tr class="';
echo $TableLine;
echo '">
<td> <input type="checkbox" name="email_select" value="';
echo $EMAIL_ID_STR;
echo '" onClick="check_one(self);"></td>
<td align="center">
';
if ((1 < $GROUP_COUNT))
{
echo ' <a href="javascript:read_status(\'';
echo $BODY_ID;
echo '\');">查看</a>
';
}
else
{
if (($DELETE_FLAG == '1'))
{
($DEL_MAIL_STR .= ($EMAIL_ID.','));
echo ' <img src="/images/email_delete.gif" alt="收件人已删除">
';
}
else
{
if (($READ_FLAG == '1'))
{
echo ' <img src="/images/email_open.gif" alt="收件人已读">
';
}
else
{
($UNREAD_MAIL_STR .= ($EMAIL_ID.','));
echo ' <img src="/images/email_close.gif" alt="收件人未读">
';
}
}
}
echo ' </td>
<td nowrap align="center">
';
if ((1 < $GROUP_COUNT))
{
echo ' <a href="javascript:read_status(\'';
echo $BODY_ID;
echo '\');">查看</a>
';
}
else
{
echo ' <u title="部门:';
echo $DEPT_NAME;
echo '" style="cursor:hand">';
echo $TO_NAME;
echo '</u>
';
if (((($TO_ID2 != '') AND !find_id ($COPY_TO_ID, $TO_ID)) AND !find_id ($TO_ID2, $TO_ID)))
{
echo ' (暗送)';
}
}
echo ' </td>
<td><a href="read_email?PAGE_START=';
echo $PAGE_START;
echo '&EMAIL_ID=';
echo $EMAIL_ID;
echo '&CURSOR_ID=';
echo (($PAGE_START + $LETER_COUNT) - 1);
echo '">';
echo $SUBJECT;
echo '</a> ';
echo $WEBMAIL_DESC;
echo ' ';
echo $IMPORTANT_DESC;
echo '</td>
<td>';
echo attach_link ($ATTACHMENT_ID, $ATTACHMENT_NAME, 0, 1, 1);
echo '</td>
<td nowrap align="center">';
echo $SEND_TIME;
echo '</td>
<td nowrap align="center">';
echo $EMAIL_SIZE;
echo '</td>
<td nowrap>
';
if (($GROUP_COUNT == 1))
{
if (($READ_FLAG == '0'))
{
echo ' <a href="edit_email.php?PAGE_START=';
echo $PAGE_START;
echo '&EMAIL_ID=';
echo $EMAIL_ID;
echo '"> 编辑</a>
';
}
echo ' <a href="resend.php?EMAIL_ID=';
echo $EMAIL_ID;
echo '"> 再次发送</a>
</td>
</tr>
';
continue;
}
continue;
}
}
echo '
<tr class="TableControl">
<td colspan="10">
<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="导出Excel" class="SmallButton" onClick="export_mail();" title="批量导出">
<input ';
echo 'type="button" value="导出eml" class="SmallButton" onClick="export_eml();" title="单独导出">
</td>
</tr>
</table>
</td>
</tr>
</table>
<br>
<table border="0" cellspacing="1" width="100%" class="small" bgcolor="#000000" cellpadding="3">
<tr>
<td class="TableContent" nowrap align="center" width="80"><b>快捷操作:</b></td>
<td class="TableControl" nowrap>
<img src="/i';
echo 'mages/delete.gif"> <a href="javascript:del_mail(\'del\',\'所有收件人已删除\');" title="删除所有收件人已删除邮件">删除所有收件人已删除邮件</a>
<img src="/images/delete.gif"> <a href="javascript:del_mail(\'unread\',\'所有收件人未读\');" title="删除所有收件人未读邮件">删除所有收件人未读邮件</a>
<img src="/images/delete.gif"> <a href="javascript:del_mail(\'readed\',\'所有收件人已读\');" t';
echo 'itle="删除所有收件人已读邮件">删除所有收件人已读邮件</a>
</td>
</tr>
</table>
<br>
<div align="center">
<input type="button" value="返回" class="BigButton" onClick="location=\'../\';">
</div>
</body>
';
echo '<S';
echo 'CRIPT>
function delete_mail_one(EMAIL_ID)
{
msg=\'确认要删除该邮件么?\\n注意:如果删除对方未读邮件,对方将不会接收到该邮件!\';
if(window.confirm(msg))
{
url="delete.php?DELETE_STR="+ EMAIL_ID +"&PAGE_START=';
echo $PAGE_START;
echo '";
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_';
echo 'str+=val + ",";
}
}
if(delete_str=="")
{
alert("要导出邮件,请至少选择其中一封。");
return;
}
window.open(\'../export_bat.php?DELETE_STR=\'+ delete_str);
}
function export_eml()
{
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;
d';
echo 'elete_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.location=\'../export.php?DELETE_STR=\'+ delete_str;
}
function delete_mail()
{
delete_str="";
for(';
echo '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("要删除邮件,';
echo '请至少选择其中一封。");
return;
}
msg=\'确认要删除所选邮件么?\\n注意:如果删除对方未读邮件,对方将不会接收到该邮件!\';
if(window.confirm(msg))
{
url="delete.php?DELETE_STR="+ delete_str +"&PAGE_START=';
echo $PAGE_START;
echo '";
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=';
echo $PAGE_START;
echo '";
location=url;
}
}
</SCRIPT>
</html>
';
?>
⌨️ 快捷键说明
复制代码Ctrl + C
搜索代码Ctrl + F
全屏模式F11
增大字号Ctrl + =
减小字号Ctrl + -
显示快捷键?