📄 diary_detail.php

📁 通达OA官方提供的30源代码,感觉很实在
💻 PHP
字号:
<?
include_once("inc/auth.php");
include_once("inc/utility_file.php");

$query = "SELECT NAME from WORK_PLAN where PLAN_ID='$PLAN_ID'";
$cursor=exequery($connection,$query);
if($ROW=mysql_fetch_array($cursor))
	 $WORK_PLAN_NAME=$ROW["NAME"];  
?>

<html>
<head>
<title>进度日志详情</title>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<script src="/inc/js/attach.js"></script>
<script>
function delete_diary(DETAIL_ID,PLAN_ID,ATTACHMENT_ID,ATTACHMENT_NAME)
{
   msg='确认要删除该进度日志么？';
   if(window.confirm(msg))
   {
      URL="delete_diary.php?DETAIL_ID=" + DETAIL_ID+"&PLAN_ID=" + PLAN_ID+"&ATTACHMENT_ID=" + ATTACHMENT_ID+"&ATTACHMENT_NAME=" + ATTACHMENT_NAME+"&FLAG=" + 1;
      window.location=URL;
   }
}

</script>
</head>

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

<table border="0" width="100%" cellspacing="0" cellpadding="3" class="small">
 <tr>
  <td class="Big"><img src="/images/menu/work_plan.gif" width="22" height="18" align="absMiddle"><span class="big3"> 进度日志详情(<?=$WORK_PLAN_NAME?>)</span><br>
  </td>
 </tr>
</table>
<br>
<?
$query = "SELECT * from WORK_DETAIL where TYPE_FLAG='0'and PLAN_ID='$PLAN_ID' order by WRITE_TIME desc";
$cursor=exequery($connection,$query);
$DETAIL_COUNT=0;
while($ROW=mysql_fetch_array($cursor))
{ 
  $DETAIL_COUNT++;		
  $DETAIL_ID=$ROW["DETAIL_ID"];  
	$WRITE_TIME=$ROW["WRITE_TIME"];     			
	$PROGRESS=$ROW["PROGRESS"];	
	$PERCENT =$ROW["PERCENT"];
	$WRITER=$ROW["WRITER"];
  $ATTACHMENT_ID=$ROW["ATTACHMENT_ID"];
  $ATTACHMENT_NAME=$ROW["ATTACHMENT_NAME"];

  $PROGRESS=str_replace("\n","<br>",$PROGRESS);	
  $query1 = "SELECT * from USER where USER_ID='$WRITER'";
  $cursor1= exequery($connection,$query1);	
  if($ROW1=mysql_fetch_array($cursor1)) 
     $USER_NAME=$ROW1["USER_NAME"]; 
     	
  if($DETAIL_COUNT==1)
	{
?>
<table class="TableList"  width="95%" align="center">
   <tr class="TableHeader"> 	 
     <td nowrap align="center">作者</td>
     <td nowrap align="center">内容</td>
     <td nowrap align="left">附件</td>    
     <td nowrap align="center">日志时间</td>
     <td nowrap align="center">进度百分比</td>
     <td nowrap align="center">操作</td>
   </tr>
<?
  }
  
  if($DETAIL_COUNT%2==1)
     $TableLine="TableLine1";
  else
     $TableLine="TableLine2";   

?>
  <tr class="<?=$TableLine?>">
     <td nowrap align="center"><?=$USER_NAME?></td>
  	 <td nowrap align="left"><?=$PROGRESS?></td>
  	 <td nowrap align="left">
<?
      if($ATTACHMENT_ID=="")
         echo "无附件";
      else
         echo attach_link($ATTACHMENT_ID,$ATTACHMENT_NAME,1,1,1,0,0,1,0,0); 
?>  	 
  	 
  	 </td> 	 
     <td nowrap align="center"><?=$WRITE_TIME?></td>  	 
     <td nowrap align="center"><?=$PERCENT?>％</td>     
     <td nowrap align="center">
<?
if($LOGIN_USER_ID==$WRITER or $LOGIN_USER_PRIV==1)
{
?>
     	 <a href="edit_diary.php?DETAIL_ID=<?=$DETAIL_ID?>&PLAN_ID=<?=$PLAN_ID?>"> 修改</a>
       <a href="javascript:delete_diary('<?=$DETAIL_ID?>','<?=$PLAN_ID?>','<?=$ATTACHMENT_ID?>','<?=$ATTACHMENT_NAME?>');"> 删除</a>
<?
}
?>
     </td> 
  </tr>
  
<?
} //while

if($DETAIL_COUNT==0)
{
   Message("","无进度日志");
   echo "<br><center><input type=\"button\" value=\"关闭\" class=\"BigButton\"  onclick=\"window.close();\"></center>";
   exit;
}
else
{
?>
  <tr class="TableControl">
 	  <td align="center"colspan="7">
      <input type="button" value="关闭" class="BigButton"  onclick="window.close();">
    </td>
  </tr> 
</table>
<?
}
?>
</body>
</html>
⌨️ 快捷键说明

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