📄 export.php

📁 极限网络智能办公系统 - Office Automation 2008 官方100％源码
💻 PHP
字号:
<?php
 

include_once( "inc/auth.php" );
include_once( "inc/utility_all.php" );
ob_end_clean( );
header( "Cache-control: private" );
header( "Content-type: application/msword" );
header( "Content-Disposition: attachment; filename= ".$USER_NAME.".doc" );
echo "\r\n<html>\r\n<head>\r\n<title>工作日志查询</title>\r\n<meta http-equiv=\"Content-Type\" content=\"text/html; charset=gb2312\">\r\n</head>\r\n\r\n<body topmargin=\"5\">\r\n  <table border=\"1\" cellspacing=\"1\" width=\"95%\" class=\"small\" cellpadding=\"3\">\r\n      <tr style=\"BACKGROUND: #D3E5FA; color: #000000; font-weight: bold;\">\r\n        <td nowrap align=\"center\">日期</td>\r\n        <td nowrap align=\"center\">日志类型</td>\r\n        <td nowrap align=\"center\">日志标题</td>\r\n        <td nowrap align=\"center\">日志内容</td>\r\n        <td nowrap align=\"center\">点评</td>\r\n      </tr>\r\n";
$cursor = exequery( $connection, $QUERY_DIARY );
while ( $ROW = mysql_fetch_array( $cursor ) )
{
	$DIA_ID = $ROW['DIA_ID'];
	$DIA_DATE = $ROW['DIA_DATE'];
	$DIA_DATE = substr( $DIA_DATE, 0, 16 );
	$DIA_TYPE = $ROW['DIA_TYPE'];
	$SUBJECT = $ROW['SUBJECT'];
	$CONTENT = $ROW['CONTENT'];
	if ( $SUBJECT == "" )
	{
		$SUBJECT = csubstr( strip_tags( $CONTENT ), 0, 50 ).( 50 < strlen( $CONTENT ) ? "..." : "" );
	}
	$FLAG = 0;
	if ( $KEY1 != "" && stristr( strip_tags( $CONTENT ), $KEY1 ) )
	{
		++$FLAG;
	}
	if ( $KEY2 != "" && stristr( strip_tags( $CONTENT ), $KEY2 ) )
	{
		++$FLAG;
	}
	if ( $KEY3 != "" && stristr( strip_tags( $CONTENT ), $KEY3 ) )
	{
		++$FLAG;
	}
	if ( $FLAG == 0 && ( $KEY1 != "" || $KEY2 != "" || $KEY3 != "" ) )
	{
		$CONTENT_COMENT = "";
		$query = "SELECT * from DIARY_COMMENT where DIA_ID=".$DIA_ID." order by SEND_TIME desc";
		$cursor1 = exequery( $connection, $query );
		while ( $ROW = mysql_fetch_array( $cursor1 ) )
		{
			$USER_ID = $ROW['USER_ID'];
			$SEND_TIME = $ROW['SEND_TIME'];
			$CONTENT1 = $ROW['CONTENT'];
			$CONTENT1 = str_replace( "\"", "'", $CONTENT1 );
			$query = "SELECT * from USER where USER_ID='".$USER_ID."'";
			$cursor2 = exequery( $connection, $query );
			if ( $ROW1 = mysql_fetch_array( $cursor2 ) )
			{
				$USER_NAME = $ROW1['USER_NAME'];
			}
			$CONTENT_COMENT .= "<font color=\"#0000FF\">".$USER_NAME."&nbsp;&nbsp;".$SEND_TIME."</font><br>".$CONTENT1."<br><br>";
		}
		$DIA_TYPE_DESC = get_code_name( $DIA_TYPE, "DIARY_TYPE" );
		echo "    <tr style=\"BACKGROUND: #FFFFFF;\">\r\n      <td nowrap align=\"center\" width=\"100\">";
		echo $DIA_DATE;
		echo "</td>\r\n      <td nowrap align=\"center\" width=\"100\">";
		echo $DIA_TYPE_DESC;
		echo "</td>\r\n      <td>";
		echo $SUBJECT;
		echo "</td>\r\n      <td>";
		echo $CONTENT;
		echo "</td>\r\n      <td>";
		echo $CONTENT_COMENT;
		echo "</td>\r\n    </tr>\r\n";
	}
}
echo "  </table>\r\n\r\n</body>\r\n</html>";
?>
⌨️ 快捷键说明

复制代码 Ctrl + C
搜索代码 Ctrl + F
全屏模式 F11
切换主题 Ctrl + Shift + D
显示快捷键 ?
增大字号 Ctrl + =
减小字号 Ctrl + -