📄 export.php

📁 通达网络办公 - Office Anywhere 2008 增强版100％源码(3.4.081216) 内含通达OA2008增強版接近完美破解补丁20081216集及最新通达OA2008ADV(

💻 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= ".$LOGIN_USER_ID.".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        <td nowrap align=\"center\">附件名称</td>\r\n      </tr>\r\n";
$query = "SELECT DIA_ID,DIA_DATE,SUBJECT,DIA_TYPE,ATTACHMENT_ID,ATTACHMENT_NAME,CONTENT from DIARY where USER_ID='".$USER_ID."' and DIA_TYPE!='2' ".str_replace( "`", "'", $WHERE_STR )." order by DIA_DATE desc,DIA_ID desc";
$cursor = exequery( $connection, $query );
while ( $ROW = mysql_fetch_array( $cursor ) )
{
	$DIA_ID = $ROW['DIA_ID'];
	$DIA_DATE = $ROW['DIA_DATE'];
	$DIA_DATE = strtok( $DIA_DATE, " " );
	$DIA_TYPE = $ROW['DIA_TYPE'];
	$SUBJECT = $ROW['SUBJECT'];
	$CONTENT = $ROW['CONTENT'];
	$ATTACHMENT_ID = $ROW['ATTACHMENT_ID'];
	$ATTACHMENT_NAME = $ROW['ATTACHMENT_NAME'];
	$CONTENT_COMENT = "";
	$query = "SELECT USER.USER_NAME,DIARY_COMMENT.SEND_TIME,DIARY_COMMENT.CONTENT from DIARY_COMMENT,USER where DIARY_COMMENT.DIA_ID='".$DIA_ID."' and DIARY_COMMENT.USER_ID = USER.USER_ID order by DIARY_COMMENT.SEND_TIME desc";
	$cursor1 = exequery( $connection, $query );
	while ( $ROW = mysql_fetch_array( $cursor1 ) )
	{
		$USER_NAME = $ROW['USER_NAME'];
		$SEND_TIME = $ROW['SEND_TIME'];
		$CONTENT1 = $ROW['CONTENT'];
		$CONTENT1 = str_replace( "\"", "'", $CONTENT1 );
		$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     <td>\r\n";
	$ATTACHMENT_NAME_ARRAY = explode( "*", $ATTACHMENT_NAME );
	$ARRAY_COUNT = sizeof( $ATTACHMENT_NAME_ARRAY );
	$I = 0;
	for ( ;	$I < $ARRAY_COUNT;	++$I	)
	{
		if ( !( $ATTACHMENT_NAME_ARRAY[$I] == "" ) )
		{
			echo $ATTACHMENT_NAME_ARRAY[$I]."<br>";
		}
	}
	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 + -