send_excel.php

来自「通达OA2007SE源代码 非常好的」· PHP 代码 · 共 123 行

<?
  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 ();
    }
  }
  if ($STAT_MODE)
  {
    ($EXCEL_OUT .= '部门	用户	发送成功	未发送	发送失败
');
  }
  else
  {
    ($EXCEL_OUT .= '部门	发送成功	未发送	发送失败
');
  }
  $query_sms = 'SELECT count(*) from SMS2 where 1=1';
  if (($END_DATE != ''))
  {
    ($query_sms .= (((''.' and SEND_TIME<=\'').$END_DATE).'\''));
  }
  if (($BEGIN_DATE != ''))
  {
    ($query_sms .= (((''.' and SEND_TIME>=\'').$BEGIN_DATE).'\''));
  }
  $query1 = 'SELECT * from USER,USER_PRIV,DEPARTMENT where DEPARTMENT.DEPT_ID=USER.DEPT_ID and USER.USER_PRIV=USER_PRIV.USER_PRIV and NOT_LOGIN!=\'1\' order by DEPT_NO,PRIV_NO,USER_NO,USER_NAME';
  $cursor = exequery ($connection, $query1);
  $TEMP = '';
  while ($ROW = mysql_fetch_array ($cursor))
  {
    $USER_ID = $ROW['USER_ID'];
    $DEPT_NAME = $ROW['DEPT_NAME'];
    $USER_NAME = $ROW['USER_NAME'];
    $query = ($query_sms.(((''.' and SEND_FLAG=\'1\' and FROM_ID=\'').$USER_ID).'\''));
    $cursor1 = exequery ($connection, $query);
    if ($ROW = mysql_fetch_array ($cursor1))
    {
      $COUNT1 = $ROW[0];
    }
    $query = ($query_sms.(((''.' and SEND_FLAG=\'0\' and FROM_ID=\'').$USER_ID).'\''));
    $cursor1 = exequery ($connection, $query);
    if ($ROW = mysql_fetch_array ($cursor1))
    {
      $COUNT2 = $ROW[0];
    }
    $query = ($query_sms.(((''.' and SEND_FLAG=\'2\' and FROM_ID=\'').$USER_ID).'\''));
    $cursor1 = exequery ($connection, $query);
    if ($ROW = mysql_fetch_array ($cursor1))
    {
      $COUNT3 = $ROW[0];
    }
    if (($TEMP != $DEPT_NAME))
    {
      $DEPT_COUNT1_BAK = $DEPT_COUNT1;
      $DEPT_COUNT1 = $COUNT1;
      $DEPT_COUNT2_BAK = $DEPT_COUNT2;
      $DEPT_COUNT2 = $COUNT2;
      $DEPT_COUNT3_BAK = $DEPT_COUNT3;
      $DEPT_COUNT3 = $COUNT3;
    }
    else
    {
      ($DEPT_COUNT1 += $COUNT1);
      ($DEPT_COUNT2 += $COUNT2);
      ($DEPT_COUNT3 += $COUNT3);
    }
    if ($STAT_MODE)
    {
      ($EXCEL_OUT .= ($DEPT_NAME.'	'));
      ($EXCEL_OUT .= ($USER_NAME.'	'));
      ($EXCEL_OUT .= ($COUNT1.'	'));
      ($EXCEL_OUT .= ($COUNT2.'	'));
      ($EXCEL_OUT .= ($COUNT3.'	'));
      ($EXCEL_OUT .= '
');
    }
    else
    {
      if ((($TEMP != $DEPT_NAME) AND $TEMP))
      {
        ($EXCEL_OUT .= ($TEMP.'	'));
        ($EXCEL_OUT .= ($DEPT_COUNT1_BAK.'	'));
        ($EXCEL_OUT .= ($DEPT_COUNT2_BAK.'	'));
        ($EXCEL_OUT .= ($DEPT_COUNT3_BAK.'	'));
        ($EXCEL_OUT .= '
');
      }
    }
    $TEMP = $DEPT_NAME;
  }
  if ($STAT_MODE)
  {
    $FILENAME = '(按人员)';
  }
  else
  {
    $FILENAME = '(按部门)';
  }
  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= 手机短信发送统计').$FILENAME).'.xls'));
  echo $EXCEL_OUT;
?>