receive_excel.php

来自「极限网络智能办公系统 Office Automation V3.0官方100％源」· PHP 代码 · 共 91 行

<?
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 .= '发信人	手机号码	内容	发送时间
';
$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 .= '未知	';
	}
	else
	{
		$EXCEL_OUT .= $PHONE_ARRAY[$PHONE][0] . '	';
	}
	if ($PHONE_ARRAY[$PHONE][1] == 0)
	{
		$EXCEL_OUT .= $PHONE . '	';
	}
	else
	{
		$EXCEL_OUT .= '不公开	';
	}
	$EXCEL_OUT .= $CONTENT . '	';
	$EXCEL_OUT .= $SEND_TIME . '	';
	$EXCEL_OUT .= '
';
}
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;
?>