receive_excel.php

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

<?php

include_once( "inc/auth.php" );
include_once( "inc/check_type.php" );
include_once( "inc/utility_all.php" );
if ( $BEGIN_DATE != "" )
{
	$TIME_OK = is_date_time( $BEGIN_DATE );
	if ( !$TIME_OK )
	{
		message( "错误", "起始时间格式不对，应形如 1999-1-2 14:55:20" );
		exit( );
	}
}
if ( $END_DATE != "" )
{
	$TIME_OK = is_date_time( $END_DATE );
	if ( !$TIME_OK )
	{
		message( "错误", "截止时间格式不对，应形如 1999-1-2 14:55:20" );
		exit( );
	}
}
$query = "SELECT * from SMS3 where 1=1";
if ( $END_DATE != "" )
{
	$query .= " and SEND_TIME<='{$END_DATE}'";
}
if ( $BEGIN_DATE != "" )
{
	$query .= " and SEND_TIME>='{$BEGIN_DATE}'";
}
if ( $PHONE != "" )
{
	$query .= " and PHONE like '%{$PHONE}%'";
}
if ( $CONTENT != "" )
{
	$query .= " and CONTENT like '%{$CONTENT}%'";
}
$EXCEL_OUT .= "发信人\t手机号码\t内容\t发送时间\n";
$query1 = "select * from USER where MOBIL_NO<>''";
$cursor = exequery( $connection, $query1 );
while ( $ROW = mysql_fetch_array( $cursor ) )
{
	$USER_NAME = $ROW['USER_NAME'];
	$MOBIL_NO = $ROW['MOBIL_NO'];
	$MOBIL_NO_HIDDEN = $ROW['MOBIL_NO_HIDDEN'];
	$PHONE_ARRAY[$MOBIL_NO][0] = $USER_NAME;
	$PHONE_ARRAY[$MOBIL_NO][1] = $MOBIL_NO_HIDDEN;
}
$query .= " order by SEND_TIME desc,SMS_ID desc";
$cursor = exequery( $connection, $query );
$SMS_COUNT = 0;
while ( $ROW = mysql_fetch_array( $cursor ) )
{
	++$SMS_COUNT;
	$SMS_ID = $ROW['SMS_ID'];
	$PHONE = $ROW['PHONE'];
	$CONTENT = $ROW['CONTENT'];
	$SEND_TIME = $ROW['SEND_TIME'];
	if ( $PHONE_ARRAY[$PHONE][0] == "" )
	{
		$EXCEL_OUT .= "未知\t";
	}
	else
	{
		$EXCEL_OUT .= $PHONE_ARRAY[$PHONE][0]."\t";
	}
	if ( $PHONE_ARRAY[$PHONE][1] == 0 )
	{
		$EXCEL_OUT .= $PHONE."\t";
	}
	else
	{
		$EXCEL_OUT .= "不公开\t";
	}
	$EXCEL_OUT .= $CONTENT."\t";
	$EXCEL_OUT .= $SEND_TIME."\t";
	$EXCEL_OUT .= "\n";
}
ob_end_clean( );
header( "Cache-control: private" );
header( "Content-type: application/vnd.ms-excel" );
header( "Accept-Ranges: bytes" );
header( "Accept-Length: ".strlen( $EXCEL_OUT ) );
header( "Content-Disposition: attachment; filename= 手机短信接收记录.xls" );
echo $EXCEL_OUT;
?>