export.php

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

PHP

120 行

<?
  include_once 'inc/auth.php';
  include_once 'inc/utility_all.php';
  ob_end_clean ();
  header ('Cache-control: private');
  header ('Content-type: application/msword');
  header ((((''.'Content-Disposition: attachment; filename= ').$LOGIN_USER_ID).'.doc'));
  echo '
<html>
<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; font-weight: bold;">
        <td nowrap align="center">日期</td>
        <td nowrap align="center">日志类型</td>
        <td no';
  echo 'wrap align="center">日志标题</td>
        <td nowrap align="center">日志内容</td>
        <td nowrap align="center">点评</td>
        <td nowrap align="center">附件名称</td>
      </tr>
';
  $cursor = exequery ($connection, $QUERY_DIARY);
  while ($ROW = mysql_fetch_array ($cursor))
  {
    $DIA_ID = $ROW['DIA_ID'];
    $DIA_DATE = $ROW['DIA_DATE'];
    $DIA_DATE = strtok ($DIA_DATE, ' ');
    $DIA_TYPE = $ROW['DIA_TYPE'];
    $SUBJECT = $ROW['SUBJECT'];
    $CONTENT = $ROW['CONTENT'];
    $ATTACHMENT_ID = $ROW['ATTACHMENT_ID'];
    $ATTACHMENT_NAME = $ROW['ATTACHMENT_NAME'];
    if (($SUBJECT == ''))
    {
      $SUBJECT = (csubstr (strip_tags ($CONTENT), 0, 50).((50 < strlen ($CONTENT)) ? '...' : ''));
    }
    $FLAG = 0;
    if ((($KEY1 != '') AND stristr (strip_tags ($CONTENT), $KEY1)))
    {
      ++$FLAG;
    }
    if ((($KEY2 != '') AND stristr (strip_tags ($CONTENT), $KEY2)))
    {
      ++$FLAG;
    }
    if ((($KEY3 != '') AND stristr (strip_tags ($CONTENT), $KEY3)))
    {
      ++$FLAG;
    }
    if ((($FLAG == 0) AND ((($KEY1 != '') OR ($KEY2 != '')) OR ($KEY3 != ''))))
    {
      continue;
    }
    else
    {
      $CONTENT_COMENT = '';
      $query = (((''.'SELECT * from DIARY_COMMENT where DIA_ID=').$DIA_ID).' order by SEND_TIME desc');
      $cursor1 = exequery ($connection, $query);
      while ($ROW = mysql_fetch_array ($cursor1))
      {
        $USER_ID = $ROW['USER_ID'];
        $SEND_TIME = $ROW['SEND_TIME'];
        $CONTENT1 = $ROW['CONTENT'];
        $CONTENT1 = str_replace ('"', '\'', $CONTENT1);
        $query = (((''.'SELECT * from USER where USER_ID=\'').$USER_ID).'\'');
        $cursor2 = exequery ($connection, $query);
        if ($ROW1 = mysql_fetch_array ($cursor2))
        {
          $USER_NAME = $ROW1['USER_NAME'];
        }
        ($CONTENT_COMENT .= (((((('<font color="#0000FF">'.$USER_NAME).'&nbsp;&nbsp;').$SEND_TIME).'</font><br>').$CONTENT1).'<br><br>'));
      }
      $DIA_TYPE_DESC = get_code_name ($DIA_TYPE, 'DIARY_TYPE');
      echo '    <tr style="BACKGROUND: #FFFFFF;">
      <td nowrap align="center" width="100">';
      echo $DIA_DATE;
      echo '</td>
      <td nowrap align="center" width="100">';
      echo $DIA_TYPE_DESC;
      echo '</td>
      <td>';
      echo $SUBJECT;
      echo '</td>
      <td>';
      echo $CONTENT;
      echo '</td>
      <td>';
      echo $CONTENT_COMENT;
      echo '</td>
      <td>
';
      $ATTACHMENT_NAME_ARRAY = explode ('*', $ATTACHMENT_NAME);
      $ARRAY_COUNT = sizeof ($ATTACHMENT_NAME_ARRAY);
      for ($I = 0; ($I < $ARRAY_COUNT); ++$I)
      {
        if (($ATTACHMENT_NAME_ARRAY[$I] == ''))
        {
          continue;
        }
        else
        {
          echo ($ATTACHMENT_NAME_ARRAY[$I].'<br>');
          continue;
        }
      }
      echo '      </td>
    </tr>
';
      continue;
    }
  }
  echo '  </table>
</body>
</html>';
?>

export.php - 源码说明

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

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

⌨️ 快捷键说明

复制代码Ctrl + C

搜索代码Ctrl + F

全屏模式F11

增大字号Ctrl + =

减小字号Ctrl + -

显示快捷键?