export_bat.php

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

PHP

143 行

<?
  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 xmlns:o="urn:schemas-microsoft-com:office:office"
xmlns:x="urn:schemas-microsoft-com:office:excel"
xmlns="http://www.w3.org/TR/REC-html40">
<head>
<title></title>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
</head>
<body topmargin="5">
 <table border="1" cellspacing="1" width="95%" class="small" cellpadding="3">
    <tr style="BACKGROUND: #D3E5FA; color: #000000; f';
  echo 'ont-weight: bold;">
      <td align="center">收件人</td>
      <td align="center">发件人</td>
      <td align="center">抄送</td>
      <td align="center">重要级别</td>
      <td align="center">主题</td>
      <td align="center">时间</td>
      <td align="center">内容</td>
      <td align="center">附件名称</td>
    </tr>
';
  $query = (((''.'SELECT * from EMAIL_BODY where find_in_set(BODY_ID,\'').$DELETE_STR).'\')');
  $cursor = exequery ($connection, $query);
  while ($ROW = mysql_fetch_array ($cursor))
  {
    $TO_ID2 = $ROW['TO_ID2'];
    $FROM_ID = $ROW['FROM_ID'];
    $COPY_TO_ID = $ROW['COPY_TO_ID'];
    $IMPORTANT = $ROW['IMPORTANT'];
    $SUBJECT = $ROW['SUBJECT'];
    $CONTENT = $ROW['CONTENT'];
    $SEND_TIME = $ROW['SEND_TIME'];
    $ATTACHMENT_NAME = $ROW['ATTACHMENT_NAME'];
    if (($FROM_ID != $LOGIN_USER_ID))
    {
      continue;
    }
    else
    {
      $SUBJECT = htmlspecialchars ($SUBJECT);
      $CONTENT = str_replace ('  ', '&nbsp;&nbsp;', $CONTENT);
      $CONTENT = str_replace ('
', '<br>', $CONTENT);
      $TO_ID2 = substr (str_replace (',,', ',', str_replace (',,', ',', $TO_ID2)), 0, -1);
      if (($TO_ID2 == ''))
      {
        $TO_ID2 = $TO_ID;
      }
      $FROM_NAME = $LOGIN_USER_NAME;
      $TO_NAME = '';
      if (($TO_ID2 != $LOGIN_USER_ID))
      {
        $query1 = (((''.'SELECT USER_NAME from USER where find_in_set(USER_ID,\'').$TO_ID2).'\')');
        $cursor1 = exequery ($connection, $query1);
        while ($ROW = mysql_fetch_array ($cursor1))
        {
          ($TO_NAME .= ($ROW['USER_NAME'].','));
        }
        if ((substr ($TO_NAME, -1) == ','))
        {
          $TO_NAME = substr ($TO_NAME, 0, -1);
        }
      }
      else
      {
        $TO_NAME = $LOGIN_USER_NAME;
      }
      $COPY_TO_NAME = '';
      if (($COPY_TO_ID != ''))
      {
        $query1 = (((''.'SELECT USER_NAME from USER where find_in_set(USER_ID,\'').$COPY_TO_ID).'\')');
        $cursor1 = exequery ($connection, $query1);
        while ($ROW = mysql_fetch_array ($cursor1))
        {
          ($COPY_TO_NAME .= ($ROW['USER_NAME'].','));
        }
        if ((substr ($COPY_TO_NAME, -1) == ','))
        {
          $COPY_TO_NAME = substr ($COPY_TO_NAME, 0, -1);
        }
      }
      if ((($IMPORTANT == '0') OR ($IMPORTANT == '')))
      {
        $IMPORTANT_DESC = '';
      }
      else
      {
        if (($IMPORTANT == '1'))
        {
          $IMPORTANT_DESC = '<font color="#FF6600">重要</font>';
        }
        else
        {
          if (($IMPORTANT == '2'))
          {
            $IMPORTANT_DESC = '<font color="#FF0000">非常重要</font>';
          }
        }
      }
      echo '    <tr>
      <td nowrap align="center">';
      echo $TO_NAME;
      echo '</td>
      <td nowrap align="center">';
      echo $FROM_NAME;
      echo '</td>
      <td>';
      echo $COPY_TO_NAME;
      echo '</td>
      <td nowrap align="center">';
      echo $IMPORTANT_DESC;
      echo '</td>
      <td nowrap>';
      echo $SUBJECT;
      echo '</td>
      <td nowrap align="center" x:str="\'';
      echo $SEND_TIME;
      echo '">';
      echo $SEND_TIME;
      echo '</td>
      <td>';
      echo $CONTENT;
      echo '</td>
      <td>';
      echo str_replace ('*', '<br>', $ATTACHMENT_NAME);
      echo '</td>
    </tr>
';
      continue;
    }
  }
  echo '</table>';
?>

export_bat.php - 源码说明

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

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

⌨️ 快捷键说明

复制代码Ctrl + C

搜索代码Ctrl + F

全屏模式F11

增大字号Ctrl + =

减小字号Ctrl + -

显示快捷键?