receive_excel.php

来自「通达OA2007SE源代码 非常好的」· 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;
?>