📄 all.php.bak
字号:
<?
include_once("inc/auth.php");
include_once("inc/utility_all.php");
$PAGE_SIZE=intVal($_COOKIE[$LOGIN_USER_ID."_email_ps_in".$BOX_ID]);
if($PAGE_SIZE<=0 || $PAGE_SIZE>=1000)
$PAGE_SIZE=10;
if(!isset($PAGE_START)||$PAGE_START=="")
$PAGE_START=0;
?>
<html>
<head>
<title>收件箱</title>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
</head>
<body>
<?
if($BOX_ID=="0")
$BOX_NAME="收件箱";
else
{
$query = "SELECT * from EMAIL_BOX where BOX_ID='$BOX_ID'";
$cursor= exequery($connection,$query);
if($ROW=mysql_fetch_array($cursor))
$BOX_NAME=$ROW["BOX_NAME"];
}
$query = "SELECT count(*) from EMAIL,EMAIL_BODY where EMAIL.BODY_ID=EMAIL_BODY.BODY_ID and BOX_ID='$BOX_ID' and TO_ID='$LOGIN_USER_ID' and SEND_FLAG='1' and (DELETE_FLAG='0' or DELETE_FLAG='2') order by READ_FLAG,SEND_TIME desc";
$cursor= exequery($connection,$query);
if($ROW=mysql_fetch_array($cursor))
$LETER_COUNT=$ROW[0];
if($LETER_COUNT==0)
{
?>
<?=$BOX_NAME?>
<br>无邮件<br>
<div align="center">
<a href="../">返回</a>
</div>
<?
exit;
}
$query = "SELECT count(*) from EMAIL,EMAIL_BODY where EMAIL.BODY_ID=EMAIL_BODY.BODY_ID and BOX_ID='$BOX_ID' and TO_ID='$LOGIN_USER_ID' and SEND_FLAG='1' and READ_FLAG='0' and (DELETE_FLAG='0' or DELETE_FLAG='2')";
$cursor1= exequery($connection,$query);
$NEW_LETER_COUNT=0;
if($ROW=mysql_fetch_array($cursor1))
$NEW_LETER_COUNT=$ROW[0];
?>
<?=$BOX_NAME?>共<?=$LETER_COUNT?>封邮件，<?=$NEW_LETER_COUNT?>封为新邮件<br>
<?=page_barX($PAGE_START,$LETER_COUNT,$PAGE_SIZE,"PAGE_START")?>
<br>
<?
//============================ 显示邮件信息 =======================================
$LETER_COUNT=0;
$query = "SELECT * from EMAIL,EMAIL_BODY where EMAIL.BODY_ID=EMAIL_BODY.BODY_ID and BOX_ID='$BOX_ID' and TO_ID='$LOGIN_USER_ID' and SEND_FLAG='1' and (DELETE_FLAG='0' or DELETE_FLAG='2') order by SEND_TIME desc limit $PAGE_START,$PAGE_SIZE";
$cursor= exequery($connection,$query);
while($ROW=mysql_fetch_array($cursor))
{
$LETER_COUNT++;
$EMAIL_ID=$ROW["EMAIL_ID"];
$TO_ID=$ROW["TO_ID"];
$TO_ID2=$ROW["TO_ID2"];
$FROM_ID=$ROW["FROM_ID"];
$COPY_TO_ID=$ROW["COPY_TO_ID"];
$READ_FLAG=$ROW["READ_FLAG"];
$IMPORTANT=$ROW["IMPORTANT"];
$SIZE=$ROW["SIZE"];
$SUBJECT=$ROW["SUBJECT"];
$CONTENT=$ROW["CONTENT"];
$ATTACHMENT_ID=$ROW["ATTACHMENT_ID"];
$ATTACHMENT_NAME=$ROW["ATTACHMENT_NAME"];
$SUBJECT=htmlspecialchars($SUBJECT);
$SEND_TIME=$ROW["SEND_TIME"];
$EMAIL_SIZE=strlen($CONTENT)+strlen($SUBJECT)+$SIZE;
if(floor($EMAIL_SIZE/1024/1024)>0)
$EMAIL_SIZE=round($EMAIL_SIZE/1024/1024,1)."M";
else
$EMAIL_SIZE=ceil($EMAIL_SIZE/1024)."K";
$query1 = "SELECT * from USER where USER_ID='$FROM_ID'";
$cursor1= exequery($connection,$query1);
if($ROW=mysql_fetch_array($cursor1))
{
$FROM_NAME=$ROW["USER_NAME"];
$AVATAR=$ROW["AVATAR"];
$DEPT_ID=$ROW["DEPT_ID"];
$DEPT_NAME=dept_long_name($DEPT_ID);
}
else
{
$FROM_NAME=$FROM_ID;
$AVATAR="";
$DEPT_NAME="用户已删除";
}
?>
<?=$LETER_COUNT+$PAGE_START?>:<?=$FROM_NAME?>,
<a href="read.php?P=<?=$P?>&PAGE_START=<?=$PAGE_START?>&EMAIL_ID=<?=$EMAIL_ID?>&BOX_ID=<?=$BOX_ID?>&CURSOR_ID=<?=$PAGE_START+$LETER_COUNT-1?>"><?=$SUBJECT?></a>
<?
if($IMPORTANT=='1')
echo "<font color=red>重要</font>";
else if($IMPORTANT=='2')
echo "<font color=red>非常重要</font>";
if($READ_FLAG!="1")
{
?>
(未读)
<?
}
if($ATTACHMENT_NAME!="")
{
echo "(含附件)";
}
?>
;<?=$SEND_TIME?>；<?=$EMAIL_SIZE?>
<hr>
<?
}
echo '
<a href="../main.php?P=';
echo $P;
echo '">返回</a>';
?>
</body>
</html>
<?
function page_barX ($current_start_item, $total_items, $items_in_page = 10, $var_name = 'start', $script_href = null, $direct_print = false)
{
if ((($current_start_item < 0) OR ($total_items < $current_start_item)))
{
$current_start_item = 0;
}
if (($script_href == null))
{
$script_href = $_SERVER['PHP_SELF'];
}
if (($_SERVER['QUERY_STRING'] != ''))
{
($script_href .= ('?'.$_SERVER['QUERY_STRING']));
}
$script_href = preg_replace ((('/^(.+)(\\?|&)'.$var_name).(''.'=[^&]+&?(.*)$/i')), '$1$2$3', $script_href);
if (((substr ($script_href, -1) == '&') OR (substr ($script_href, -1) == '?')))
{
$script_href = substr ($script_href, 0, -1);
}
$hyphen = ((strstr ($script_href, '?') === FALSE) ? '?' : '&');
$num_pages = ceil (($total_items / $items_in_page));
$cur_page = (floor (($current_start_item / $items_in_page)) + 1);
($result_str .= (((((((((('<script>function goto_page(){var page_no=parseInt(document.all(\'page_no\').value);if(isNaN(page_no)||page_no<1||page_no>'.$num_pages).'){alert("页数必须为1-').$num_pages).'");return false;}window.location="').$script_href).$hyphen).$var_name).'="+(page_no-1)*').$items_in_page).';} function input_page_no(){if(event.keyCode==13) goto_page();if(event.keyCode<47||event.keyCode>57) event.returnValue=false;}</script>'));
if (($cur_page <= 1))
{
($result_str .= '首页 上一页 ');
}
else
{
($result_str .= (((((((((('<a href="'.$script_href).$hyphen).$var_name).'=0">首页</a> <a href="').$script_href).$hyphen).$var_name).'=').($current_start_item - $items_in_page)).'">上一页</a> '));
}
if (($num_pages <= $cur_page))
{
($result_str .= '下一页 末页 ');
}
else
{
($result_str .= (((((((((((('<a href="'.$script_href).$hyphen).$var_name).'=').($current_start_item + $items_in_page)).'">下一页</a> <a href="').$script_href).$hyphen).$var_name).'=').((0 < ($total_items % $items_in_page)) ? ($total_items - ($total_items % $items_in_page)) : ($total_items - $items_in_page))).'">末页</a> '));
}
($result_str .= (((('第'.$cur_page).'页/共').$num_pages).'页 '));
($result_str .= (('页数<input type=text size=3 name=page_no value='.$cur_page).' onkeypress="input_page_no()" ><input type=button value=转到 onclick="goto_page();"> '));
if ($direct_print)
{
echo $result_str;
}
else
{
return $result_str;
}
}
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -