📄 read.php

📁 通达OA2007SE源代码非常好的
💻 PHP
字号:
<?
  include_once 'inc/auth.php';
  include_once 'inc/utility_all.php';
  echo '
<html>
<head>
<title>查看日志</title>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
</head>
';
  $query = (((''.'SELECT * from DIARY where DIA_ID=\'').$DIA_ID).'\'');
  $cursor = exequery ($connection, $query);
  if ($ROW = mysql_fetch_array ($cursor))
  {
    $DIA_TIME = $ROW['DIA_TIME'];
    $DIA_DATE = $ROW['DIA_DATE'];
    $DIA_DATE = strtok ($DIA_DATE, ' ');
    $DIA_TYPE = $ROW['DIA_TYPE'];
    $CONTENT = $ROW['CONTENT'];
    $ATTACHMENT_ID = $ROW['ATTACHMENT_ID'];
    $ATTACHMENT_NAME = $ROW['ATTACHMENT_NAME'];
    if (($DIA_TIME == '0000-00-00 00:00:00'))
    {
      $DIA_TIME = '';
    }
  }
  echo '
<body class="bodycolor" topmargin="5">
<div align="center" class="Big1">
<b>[';
  echo $USER_NAME;
  echo ' - 工作日志查询]</b>
</div>
<br>
<table border="0" width="100%" cellspacing="0" cellpadding="3" class="small">
  <tr>
    <td class="Big"><img src="/images/menu/diary.gif" WIDTH="18" HEIGHT="18" align="absmiddle">';
  echo '<s';
  echo 'pan class="big3"> 查看日志（';
  echo $DIA_DATE;
  echo '）</span>
    </td>
  </tr>
</table>
<br>
  <table border="0" width="90%" cellpadding="3" cellspacing="1" align="center" bgcolor="#000000" class="small">
    <tr class="TableHeader">
      <td>日志类型：';
  echo get_code_name ($DIA_TYPE, 'DIARY_TYPE');
  echo '</td>
    </tr>';
  if (($ATTACHMENT_NAME != ''))
  {
    echo '    <tr>
      <td class="TableData">附件文件:<br>
';
    $ATTACHMENT_ID_ARRAY = explode (',', $ATTACHMENT_ID);
    $ATTACHMENT_NAME_ARRAY = explode ('*', $ATTACHMENT_NAME);
    $ARRAY_COUNT = sizeof ($ATTACHMENT_ID_ARRAY);
    for ($I = 0; ($I < $ARRAY_COUNT); ++$I)
    {
      if (($ATTACHMENT_ID_ARRAY[$I] == ''))
      {
        continue;
      }
      else
      {
        $ATTACH_SIZE = attach_size ($ATTACHMENT_ID_ARRAY[$I], $ATTACHMENT_NAME_ARRAY[$I]);
        $ATTACH_SIZE = number_format ($ATTACH_SIZE, 0, '.', ',');
        echo '       <img src="/images/email_atta.gif" align="absmiddle"><a href="/inc/attach.php?ATTACHMENT_ID=';
        echo (($ATTACHMENT_ID_ARRAY[$I] * 3) + 2);
        echo '&ATTACHMENT_NAME=';
        echo urlencode ($ATTACHMENT_NAME_ARRAY[$I]);
        echo '">';
        echo $ATTACHMENT_NAME_ARRAY[$I];
        echo '</a>
     	 <input type="button" value="转存" class="SmallButton" onClick="SaveFile(\'';
        echo (($ATTACHMENT_ID_ARRAY[$I] * 3) + 2);
        echo '\',\'';
        echo urlencode ($ATTACHMENT_NAME_ARRAY[$I]);
        echo '\');">&nbsp;
';
        if (((stristr ($ATTACHMENT_NAME_ARRAY[$I], '.doc') OR stristr ($ATTACHMENT_NAME_ARRAY[$I], '.ppt')) OR stristr ($ATTACHMENT_NAME_ARRAY[$I], '.xls')))
        {
          echo '	     <input type="button" value="阅读" class="SmallButton" onClick="window.open(\'/module/OC?ATTACHMENT_ID=';
          echo (($ATTACHMENT_ID_ARRAY[$I] * 3) + 2);
          echo '&ATTACHMENT_NAME=';
          echo urlencode ($ATTACHMENT_NAME_ARRAY[$I]);
          echo '&OP=5&PRINT=';
          echo $PRINT;
          echo '\',\'';
          echo $ATTACHMENT_ID_ARRAY[$I];
          echo '\',\'menubar=0,toolbar=0,status=1,scrollbars=1,resizable=1\');">&nbsp;
';
        }
        else
        {
          if (is_media ($ATTACHMENT_NAME_ARRAY[$I]))
          {
            echo '	       <input type="button" value="播放" class="SmallButton" onClick="window.open(\'/module/mediaplayer/index.php?MEDIA_NAME=';
            echo urlencode ($ATTACHMENT_NAME_ARRAY[$I]);
            echo '&MEDIA_URL=';
            echo urlencode (((('/inc/attach.php?ATTACHMENT_ID='.(($ATTACHMENT_ID_ARRAY[$I] * 3) + 2)).'&ATTACHMENT_NAME=').urlencode ($ATTACHMENT_NAME_ARRAY[$I])));
            echo '\',\'media';
            echo $ATTACHMENT_ID_ARRAY[$I];
            echo '\',\'menubar=0,toolbar=0,status=1,scrollbars=1,resizable=1\');">&nbsp;
';
          }
        }
        echo '       (';
        echo $ATTACH_SIZE;
        echo '字节)<br>
';
        continue;
      }
    }
    echo '      </td>
    </tr>
';
  }
  echo '    <tr>
      <td class="TableData" height="100" valign="top">
      <font color="#0000FF">[写日志时间：';
  echo $DIA_TIME;
  echo ']</font><br>
      ';
  echo $CONTENT;
  $COUNT = 0;
  $query = (((''.'SELECT * from DIARY_COMMENT where DIA_ID=\'').$DIA_ID).'\' order by SEND_TIME desc');
  $cursor = exequery ($connection, $query);
  while ($ROW = mysql_fetch_array ($cursor))
  {
    ++$COUNT;
    $COMMENT_ID = $ROW['COMMENT_ID'];
    $USER_ID = $ROW['USER_ID'];
    $SEND_TIME = $ROW['SEND_TIME'];
    $CONTENT = $ROW['CONTENT'];
    $CONTENT = str_replace ('"', '\'', $CONTENT);
    $query = (((''.'SELECT * from USER where USER_ID=\'').$USER_ID).'\'');
    $cursor1 = exequery ($connection, $query);
    if ($ROW1 = mysql_fetch_array ($cursor1))
    {
      $USER_NAME1 = $ROW1['USER_NAME'];
    }
    if (($COUNT == 1))
    {
      echo '      <br><br>
      <b>[以下是点评内容]</b><br>
';
    }
    echo '      <font color="#0000FF">';
    echo $USER_NAME1;
    echo '&nbsp;&nbsp;';
    echo $SEND_TIME;
    echo '</font>&nbsp;&nbsp;
';
    if (($USER_ID == $LOGIN_USER_ID))
    {
      echo '      <a href="delete.php?COMMENT_ID=';
      echo $COMMENT_ID;
      echo '&DIA_ID=';
      echo $DIA_ID;
      echo '&USER_NAME=';
      echo $USER_NAME;
      echo '">删除</a>
';
    }
    echo '      <br>
      ';
    echo $CONTENT;
    echo '<br><br>
';
  }
  echo '      </td>
    </tr>
    <tr align="center" class="TableControl">
      <td>
        <input type="button" value="返回" class="BigButton" onClick="history.back();">
      </td>
    </tr>
  </table>
</body>
</html>';
?>
⌨️ 快捷键说明

复制代码 Ctrl + C
搜索代码 Ctrl + F
全屏模式 F11
切换主题 Ctrl + Shift + D
显示快捷键 ?
增大字号 Ctrl + =
减小字号 Ctrl + -