export.php

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

PHP

172 行

<?
  include_once 'inc/auth.php';
  include_once 'inc/check_type.php';
  include_once 'inc/utility_all.php';
  ob_end_clean ();
  header ('Cache-control: private');
  header ('Content-type: application/vnd.ms-excel');
  header ('Content-Disposition: attachment; filename= 内部短消息.xls');
  echo '
<html>
<head>
<title>短信查询</title>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
</head>
<body>
';
  if (($BEGIN_DATE != ''))
  {
    $TIME_OK = is_date_time ($BEGIN_DATE);
    if (!$TIME_OK)
    {
      message ('错误', '起始日期格式不对，应形如 1999-1-2 14:55:20');
      button_back ();
      exit ();
    }
  }
  if (($END_DATE != ''))
  {
    $TIME_OK = is_date_time ($END_DATE);
    if (!$TIME_OK)
    {
      message ('错误', '截止日期格式不对，应形如 1999-1-2 14:55:20');
      button_back ();
      exit ();
    }
  }
  if (((($END_DATE != '') AND ($BEGIN_DATE != '')) AND ($END_DATE < $BEGIN_DATE)))
  {
    message ('错误', '截止时间不能晚于起始时间!');
    button_back ();
    exit ();
  }
  if (($TO_ID != ''))
  {
    $TO_ID = (('\''.str_replace (',', '\',\'', substr ($TO_ID, 0, -1))).'\'');
  }
  if (($TO_ID != ''))
  {
    ($query1 .= (((((''.' and ').$TYPE).' in (').$TO_ID).')'));
  }
  if (($BEGIN_DATE != ''))
  {
    ($query1 .= (((''.' and SEND_TIME>=\'').$BEGIN_DATE).'\''));
  }
  if (($END_DATE != ''))
  {
    ($query1 .= (((''.' and SEND_TIME<=\'').$END_DATE).'\''));
  }
  if (($TYPE == 'TO_ID'))
  {
    $TYPE_OTHER = 'FROM_ID';
    $TITLE = '收信人';
  }
  else
  {
    $TYPE_OTHER = 'TO_ID';
    $TITLE = '发送人';
  }
  if (($ORDER_BY == 'FROM_TO'))
  {
    $ORDER_BY = $TYPE;
  }
  $query = (((((((''.'select * from SMS where ').$TYPE_OTHER).'=\'').$LOGIN_USER_ID).'\'').$query1).((((''.' order by ').$ORDER_BY).' ').$SEQ));
  echo '<table border="1" cellspacing="0" width="95%" cellpadding="3">
  <tr style="BACKGROUND: #D3E5FA; color: #000000; font-weight: bold;">
      <td nowrap align="center">类别</td>
      <td nowrap align="center">';
  echo $TITLE;
  echo '</td>
      <td nowrap align="center">内容</td>
      <td nowrap align="center">发送时间</td>
      <td nowrap align="center">提醒</td>
    </tr>
';
  $cursor = exequery ($connection, $query);
  $SMS_COUNT = 0;
  while ($ROW = mysql_fetch_array ($cursor))
  {
    ++$SMS_COUNT;
    if ((200 < $SMS_COUNT))
    {
      break;
    }
    $SMS_ID = $ROW['SMS_ID'];
    $FROM_ID = $ROW['FROM_ID'];
    $TO_ID = $ROW['TO_ID'];
    $SEND_TIME = $ROW['SEND_TIME'];
    $SMS_TYPE = $ROW['SMS_TYPE'];
    $CONTENT = $ROW['CONTENT'];
    $CONTENT = htmlspecialchars ($CONTENT);
    $REMIND_FLAG = $ROW['REMIND_FLAG'];
    if (($REMIND_FLAG == '0'))
    {
      $REMIND_FLAG_DESC = '否';
    }
    else
    {
      $REMIND_FLAG_DESC = '是';
    }
    $query1 = (((''.'SELECT * from USER where USER_ID=\'').$FROM_ID).'\'');
    $cursor1 = exequery ($connection, $query1);
    if ($ROW = mysql_fetch_array ($cursor1))
    {
      $FROM_NAME = $ROW['USER_NAME'];
      $FROM_AVATAR = $ROW['AVATAR'];
    }
    $query1 = (((''.'SELECT * from USER where USER_ID=\'').$TO_ID).'\'');
    $cursor1 = exequery ($connection, $query1);
    if ($ROW = mysql_fetch_array ($cursor1))
    {
      $TO_NAME = $ROW['USER_NAME'];
      $TO_AVATAR = $ROW['AVATAR'];
    }
    $SMS_TYPE_NAME = get_code_name ($SMS_TYPE, 'SMS_REMIND');
    if ((($SMS_COUNT % 2) == 1))
    {
      $TableLine = 'TableLine1';
    }
    else
    {
      $TableLine = 'TableLine2';
    }
    if (($TYPE == 'TO_ID'))
    {
      $AVATAR = $TO_AVATAR;
    }
    else
    {
      $AVATAR = $FROM_AVATAR;
    }
    echo '    <tr>
      <td align="center">';
    echo $SMS_TYPE_NAME;
    echo '</td>
      <td nowrap align="center">';
    if (($TYPE == 'TO_ID'))
    {
      echo $TO_NAME;
    }
    else
    {
      echo $FROM_NAME;
    }
    echo '</td>
      <td>';
    echo $CONTENT;
    echo '</td>
      <td align="center">';
    echo $SEND_TIME;
    echo '</td>
      <td nowrap align="center">';
    echo $REMIND_FLAG_DESC;
    echo '</td>
    </tr>
';
  }
  echo '</table>
</body>
</html>
';
?>

export.php - 源码说明

本页面展示了「通达OA2007SE源代码非常好的」中的 export.php 源码文件，采用 PHP 编程语言编写，共 172 行代码。您可以在线阅读完整代码内容，也可以返回资源详情页下载完整源码包进行本地学习和开发。

虫虫下载站收录了大量与2007相关的技术资源，包括源代码、技术文档、电路图等，是电子工程师和嵌入式开发者的专业学习平台。

⌨️ 快捷键说明

复制代码Ctrl + C

搜索代码Ctrl + F

全屏模式F11

增大字号Ctrl + =

减小字号Ctrl + -

显示快捷键?