?? read.php
字號:
<?
include_once '../auth.php';
include_once 'inc/utility_all.php';
?>
<html>
<head>
<title>讀郵件</title>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
</head>
<?
$IMAGE_COUNT=0;
$IMG_TYPE_STR="gif,jpg,png,tiff,bmp,iff,jp2,jpx,jb2,jpc,xbm,wbmp,";
$query = "SELECT * from EMAIL,EMAIL_BODY where EMAIL_ID='$EMAIL_ID' and EMAIL.BODY_ID=EMAIL_BODY.BODY_ID";
$cursor= exequery($connection,$query);
if($ROW=mysql_fetch_array($cursor))
{
$FROM_ID=$ROW["FROM_ID"];
$TO_ID=$ROW["TO_ID"];
$TO_ID2=$ROW["TO_ID2"];
$COPY_TO_ID=$ROW["COPY_TO_ID"];
$SUBJECT=$ROW["SUBJECT"];
$IMPORTANT=$ROW["IMPORTANT"];
$CONTENT=$ROW["CONTENT"];
$SEND_TIME=$ROW["SEND_TIME"];
$ATTACHMENT_ID=$ROW["ATTACHMENT_ID"];
$ATTACHMENT_NAME=$ROW["ATTACHMENT_NAME"];
$READ_FLAG=$ROW["READ_FLAG"];
$SIZE=$ROW["SIZE"];
if($IMPORTANT=='0' || $IMPORTANT=="")
$IMPORTANT_DESC="";
else if($IMPORTANT=='1')
$IMPORTANT_DESC="<font color=\"#FF6600\">重要</font>";
else if($IMPORTANT=='2')
$IMPORTANT_DESC="<font color=\"#FF0000\">非常重要</font>";
$SUBJECT=htmlspecialchars($SUBJECT);
$query1 = "SELECT * from USER where USER_ID='$FROM_ID'";
$cursor1= exequery($connection,$query1);
if($ROW=mysql_fetch_array($cursor1))
{
$DEPT_ID=$ROW["DEPT_ID"];
$DEPT_NAME=dept_long_name($DEPT_ID);
$FROM_NAME="<u title=\"部門：".$DEPT_NAME."\" style=\"cursor:hand\">".$ROW["USER_NAME"]."</u>";
}
$TO_ARRAY=array();
$query1 = "SELECT * from USER where find_in_set(USER_ID,'$TO_ID2')";
$cursor1= exequery($connection,$query1);
while($ROW=mysql_fetch_array($cursor1))
{
$USER_ID=$ROW["USER_ID"];
$TO_ARRAY[$USER_ID]["DEPT_NAME"]=dept_long_name($ROW["DEPT_ID"]);
$TO_ARRAY[$USER_ID]["USER_NAME"]=$ROW["USER_NAME"];
}
$TOK=strtok($TO_ID2,",");
while($TOK!="")
{
$TO_NAME_TITLE.=$TO_ARRAY[$TOK]["USER_NAME"].",";
if(strlen($TO_NAME_TITLE)<80)
$TO_NAME.="<u title=\"部門：".$TO_ARRAY[$TOK]["DEPT_NAME"]."\" style=\"cursor:hand\">".$TO_ARRAY[$TOK]["USER_NAME"]."</u>,";
else
$TO_NAME_LONG=1;
$TOK=strtok(",");
}
$COPY_TO_ARRAY=array();
$query1 = "SELECT * from USER where find_in_set(USER_ID,'$COPY_TO_ID')";
$cursor1= exequery($connection,$query1);
while($ROW=mysql_fetch_array($cursor1))
{
$USER_ID=$ROW["USER_ID"];
$COPY_TO_ARRAY[$USER_ID]["DEPT_NAME"]=dept_long_name($ROW["DEPT_ID"]);
$COPY_TO_ARRAY[$USER_ID]["USER_NAME"]=$ROW["USER_NAME"];
}
$TOK=strtok($COPY_TO_ID,",");
while($TOK!="")
{
$TO_NAME_TITLE.=$COPY_TO_ARRAY[$TOK]["USER_NAME"].",";
if(strlen($COPY_TO_NAME_TITLE)<80)
$COPY_TO_NAME.="<u title=\"部門：".$COPY_TO_ARRAY[$TOK]["DEPT_NAME"]."\" style=\"cursor:hand\">".$COPY_TO_ARRAY[$TOK]["USER_NAME"]."</u>,";
else
$COPY_TO_NAME_LONG=1;
$TOK=strtok(",");
}
}
if(substr($TO_NAME,-1)==",")
$TO_NAME=substr($TO_NAME,0,-1);
if(substr($COPY_TO_NAME,-1)==",")
$COPY_TO_NAME=substr($COPY_TO_NAME,0,-1);
if($TO_ID!=$LOGIN_USER_ID)
exit;
?>
<?=$SUBJECT?> <?=$IMPORTANT_DESC?>
<br><b>發件人：</b><?=$FROM_NAME?>
<b>發送于：</b><?=$SEND_TIME?>
<br>
<b>內容：</b><br>
<?=$CONTENT?>
<br> <b>附 件：</b>
<?
if($ATTACHMENT_NAME=="")
echo "無";
else
{
$ATTACHMENT_ID_ARRAY=explode(",",$ATTACHMENT_ID);
$ATTACHMENT_NAME_ARRAY=explode("*",$ATTACHMENT_NAME);
echo "<br>";
$ARRAY_COUNT=sizeof($ATTACHMENT_ID_ARRAY);
for($I=0;$I<$ARRAY_COUNT-1;$I++)
{
$EXT_NAME=strtolower(substr(strrchr($ATTACHMENT_NAME_ARRAY[$I],"."),1));
if(find_id($IMG_TYPE_STR,$EXT_NAME))
$IMAGE_COUNT++;
$ATTACH_SIZE=attach_size($ATTACHMENT_ID_ARRAY[$I],$ATTACHMENT_NAME_ARRAY[$I]);
$ATTACH_SIZE=number_format($ATTACH_SIZE,0, ".",",");
?>
<a href="/inc/attach.php?ATTACHMENT_ID=<?=$ATTACHMENT_ID_ARRAY[$I]*3+2?>&ATTACHMENT_NAME=<?=urlencode($ATTACHMENT_NAME_ARRAY[$I])?>" target="_blank"><?=$ATTACHMENT_NAME_ARRAY[$I]?></a>
(<?=$ATTACH_SIZE?>字節)<br>
<? }//for
}//else
?>
<?
if($IMAGE_COUNT>0)
{
?>
<tr>
<td class="TableData">
<img src="/images/image.gif" align="absmiddle" border="0"> 附件圖片: <br><br>
<?
for($I=0;$I<$ARRAY_COUNT;$I++)
{
if($ATTACHMENT_ID_ARRAY[$I]=="")
continue;
$EXT_NAME=substr(strrchr($ATTACHMENT_NAME_ARRAY[$I],"."),1);
$EXT_NAME=strtolower($EXT_NAME);
if(find_id($IMG_TYPE_STR,$EXT_NAME))
{
$IMAGE_COUNT1++;
?>
<a href="/inc/attach.php?ATTACHMENT_ID=<?=$ATTACHMENT_ID_ARRAY[$I]*3+2?>&ATTACHMENT_NAME=<?=$ATTACHMENT_NAME_ARRAY[$I]?>" target="_blank"><img src="/inc/attach.php?ATTACHMENT_ID=<?=$ATTACHMENT_ID_ARRAY[$I]*3+2?>&ATTACHMENT_NAME=<?=$ATTACHMENT_NAME_ARRAY[$I]?>" border="0" width="100" height="100" alt="文件名：<?=$ATTACHMENT_NAME_ARRAY[$I]?>"></a>
<?
}
}
?>
<?
}
?>
<br>
<?
if($READ_FLAG=="0")
{
$query = "update EMAIL set READ_FLAG='1' where EMAIL_ID=$EMAIL_ID";
exequery($connection,$query);
}
?>
<?
echo '<a href="../email/?P=';
echo $P;
echo '">返回</a>';
?>
</body>
</html>?? 快捷鍵說明
復制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號
Ctrl + =
減小字號
Ctrl + -