内部邮件.php

极限网络智能办公系统 - Office Automation 2.8 100％ 源码

<?php

echo "<!-------------------- 内部邮件 ----------------------->\r\n\r\n <tr class=\"TableControl\">\r\n   <td class=\"TableHeader\" width=\"70%\"><img src=\"/images/menu/email.gif\" WIDTH=\"18\" HEIGHT=\"16\" align=\"absmiddle\"> 内部邮件</td>\r\n   <td align=\"right\"><a href=\"/general/email/new\"> <img src=\"/images/green_arrow.gif\" border=\"0\" align=\"absmiddle\"> 撰写</a>&nbsp;</td>\r\n </tr>\r\n  <tr class=\"TableData\">\r\n    <td colspan=2 height";
echo "=\"50\">\r\n";
$query = "SELECT * from EMAIL where BOX_ID=0 and TO_ID='{$LOGIN_USER_ID}'  and SEND_FLAG='1' and DELETE_FLAG!='1' order by SEND_TIME desc";
$cursor = exequery( $connection, $query );
$LETER_COUNT = 0;
while ( $ROW = mysql_fetch_array( $cursor ) )
{
	++$LETER_COUNT;
	if ( 5 < $LETER_COUNT )
	{
	}
	else
	{
		$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'];
		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>";
		}
		$SUBJECT = $ROW['SUBJECT'];
		$SUBJECT = str_replace( "<", "&lt", $SUBJECT );
		$SUBJECT = str_replace( ">", "&gt", $SUBJECT );
		$SUBJECT = stripslashes( $SUBJECT );
		$SEND_TIME = $ROW['SEND_TIME'];
		$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 = "用户已删除";
		}
		echo "\r\n      ·<u title=\"部门：";
		echo $DEPT_NAME;
		echo "\" style=\"cursor:hand\">";
		echo $FROM_NAME;
		echo "</u>\r\n";
		if ( $READ_FLAG == "0" )
		{
			echo "       <img src=\"/images/email_new.gif\" alt=\"未读\" align=\"absmiddle\">\r\n";
		}
		echo "      ";
		echo $IMPORTANT_DESC;
		echo " <a href=\"/general/email/inbox/read_email?EMAIL_ID=";
		echo $EMAIL_ID;
		echo "&BOX_ID=0\">";
		echo $SUBJECT;
		echo "</a>\r\n      <br>\r\n";
	}
}
if ( $LETER_COUNT == 0 )
{
	echo "·暂无内部邮件";
}
echo "\r\n </td>\r\n</tr>\r\n";
?>