📄 export.php

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

include_once( "inc/auth.php" );
include_once( "inc/utility_all.php" );
ob_end_clean( );
if ( $EMS_TYPE == 0 )
{
	$FILENAME = "寄送快递";
}
else
{
	$FILENAME = "签收快递";
}
header( "Cache-control: private" );
header( "Content-type: application/msword" );
header( "Content-Disposition: attachment; filename=".$FILENAME.".doc" );
echo "\r\n<html>\r\n<head>\r\n<title>";
if ( $EMS_TYPE == 0 )
{
	echo "寄送";
}
else
{
	echo "签收";
}
echo "快递</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      \t";
if ( $EMS_TYPE == 0 )
{
	echo "      <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      <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      ";
}
else
{
	echo "      <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      <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    \t\r\n    \t";
}
echo "      </tr>\r\n";
$cursor = exequery( $connection, $QUERY_DIARY );
while ( $ROW = mysql_fetch_array( $cursor ) )
{
	$EMS_ID = $ROW['EMS_ID'];
	$PERSON = $ROW['PERSON'];
	$UNAME = $ROW['UNAME'];
	$USER_NAME = $ROW['USER_NAME'];
	$TEL_NO = $ROW['TEL_NO'];
	$ADDR = $ROW['ADDR'];
	$COMPANY_NAME = $ROW['COMPANY_NAME'];
	$SEND_TIME = $ROW['SEND_TIME'];
	$EMS_CODE = $ROW['EMS_CODE'];
	$EMS_TYPE = $ROW['EMS_TYPE'];
	$POSTALCODE = $ROW['POSTALCODE'];
	$CONTENTS_NAME = $ROW['CONTENTS_NAME'];
	$CONTENTS_COUNT = $ROW['CONTENTS_COUNT'];
	$REMARK = $ROW['REMARK'];
	$RECEIVER = $ROW['RECEIVER'];
	$RECEIVE_DATE = $ROW['RECEIVE_DATE'];
	if ( $EMS_TYPE == 1 )
	{
		$EMS_TYPE_DESC = "签收";
	}
	else
	{
		$EMS_TYPE_DESC = "寄送";
	}
	echo "    <tr style=\"BACKGROUND: #FFFFFF;\">\r\n      \t";
	if ( $EMS_TYPE == 0 )
	{
		echo "      <td nowrap align=\"center\">";
		echo $EMS_CODE;
		echo "</td>\r\n      <td nowrap align=\"center\">";
		echo $PERSON;
		echo "</td>\r\n      <td nowrap align=\"center\">";
		echo $TEL_NO;
		echo "</td>\r\n      <td nowrap align=\"center\">";
		echo $ADDR;
		echo "</td>\r\n      <td nowrap align=\"center\">";
		echo $POSTALCODE;
		echo "</td>\r\n      <td nowrap align=\"center\">";
		echo $COMPANY_NAME;
		echo "</td>\r\n      <td nowrap align=\"center\">";
		echo $CONTENTS_NAME;
		echo "</td>\r\n      <td nowrap align=\"center\">";
		echo $CONTENTS_COUNT;
		echo "</td>\r\n      <td nowrap align=\"center\">";
		echo $REMARK;
		echo "</td>\r\n      <td nowrap align=\"center\">";
		echo $UNAME;
		echo "</td>\r\n      <td nowrap align=\"center\">";
		echo $SEND_TIME;
		echo "</td>\r\n      ";
	}
	else
	{
		echo "      <td nowrap align=\"center\">";
		echo $EMS_CODE;
		echo "</td>\r\n      <td nowrap align=\"center\">";
		echo $PERSON;
		echo "</td>\r\n      <td nowrap align=\"center\">";
		echo $TEL_NO;
		echo "</td>\r\n      <td nowrap align=\"center\">";
		echo $ADDR;
		echo "</td>\r\n      <td nowrap align=\"center\">";
		echo $POSTALCODE;
		echo "</td>\r\n      <td nowrap align=\"center\">";
		echo $COMPANY_NAME;
		echo "</td>\r\n      <td nowrap align=\"center\">";
		echo $CONTENTS_NAME;
		echo "</td>\r\n      <td nowrap align=\"center\">";
		echo $CONTENTS_COUNT;
		echo "</td>\r\n      <td nowrap align=\"center\">";
		echo $UNAME;
		echo "</td>\r\n      <td nowrap align=\"center\">";
		echo $RECEIVER;
		echo "</td>\r\n      <td nowrap align=\"center\">";
		echo $RECEIVE_DATE;
		echo "</td>\r\n    \t";
	}
	echo "    </tr>\r\n";
}
echo "  </table>\r\n\r\n</body>\r\n</html>";
?>
⌨️ 快捷键说明

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