read.php

来自「通达OA官方提供的30源代码,感觉很实在」· PHP 代码 · 共 127 行

PHP
127
字号
<?
include_once("inc/auth.php");
include_once("inc/utility_all.php");
include_once("inc/utility_file.php");
?>

<html>
<head>
<title>查看日志</title>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">

<script src="/inc/js/attach.js"></script>
</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="";
}
?>

<body class="bodycolor" topmargin="5">

<div align="center" class="Big1">
<b>[<?=$USER_NAME?> - 工作日志查询]</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"><span class="big3"> 查看日志(<?=$DIA_DATE?>)</span>
    </td>
  </tr>
</table>

<br>
  <table class="TableList" width="97%"  align="center">
    <tr class="TableHeader">
      <td>日志类型:<?=get_code_name($DIA_TYPE,"DIARY_TYPE");?></td>
    </tr>
<?
if($ATTACHMENT_NAME!="")
{
?>    
    <tr>
      <td class="TableData">附件文件:<br><?=attach_link($ATTACHMENT_ID,$ATTACHMENT_NAME,1,1,1)?></td>
    </tr>
<?
}
?>         
    <tr>
      <td class="TableData" height="100" valign="top">
      <font color="#0000FF">[写日志时间:<?=$DIA_TIME?>]</font><br>
<?
echo $CONTENT;

$COUNT=0;
$query = "SELECT * from DIARY_COMMENT where DIA_ID='$DIA_ID' order by SEND_TIME asc";
$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"];

  $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)
  {
?>
    <br><br>
    <b>[以下是点评内容]</b><br>
<?
  }
?>
    <font color="#0000FF"><?=$COUNT?>楼 <?=$USER_NAME1?>&nbsp;&nbsp;<?=$SEND_TIME?></font>&nbsp;&nbsp;
<?
if($USER_ID == $LOGIN_USER_ID)
{
?>
    <a href="delete.php?COMMENT_ID=<?=$COMMENT_ID?>&DIA_ID=<?=$DIA_ID?>&USER_NAME=<?=urlencode($USER_NAME)?>&FROM=<?=$FROM?>&BEGIN_DATE=<?=$BEGIN_DATE?>&END_DATE=<?=$END_DATE?>&SUBJECT=<?=urlencode($SUBJECT)?>">删除</a>
<?
}
?>
    <div class="replycontent"><?=$CONTENT?></div>
<?
}
?>
    </td>
  </tr>
  <tr align="center" class="TableControl">
    <td>
<?
if($FROM==1)
{
?>    	
      <input type="button" value="返回" class="BigButton" onClick="location='user_search.php?BEGIN_DATE=<?=$BEGIN_DATE?>&END_DATE=<?=$END_DATE?>&SUBJECT=<?=urlencode($SUBJECT)?>'">
<?
}else{
?>
      <input type="button" value="返回" class="BigButton" onClick="history.back();">
<?
}
?>
    </td>
  </tr>
</table>

</body>
</html>

⌨️ 快捷键说明

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