user_diary.php
来自「通达OA官方提供的30源代码,感觉很实在」· PHP 代码 · 共 195 行
PHP
195 行
<?
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/module.js"></script>
<link rel="stylesheet" type="text/css" href="/theme/<?=$LOGIN_THEME?>/diary.css">
<script src="/inc/js/attach.js"></script>
<style>
ol{margin-left:20px;}
</style>
</head>
<body class="bodycolor" topmargin="5">
<?
$BEGIN_DATE=date("Y-m-01",time());
$CUR_DATE=date("Y-m-d",time());
$query = "SELECT USER_NAME from USER where USER_ID='$USER_ID'";
$cursor= exequery($connection,$query);
if($ROW=mysql_fetch_array($cursor))
$USER_NAME=$ROW["USER_NAME"];
?>
<div align="center" class="Big1" style="padding-top:10px;">
<b>[<?=$USER_NAME?> - 工作日志]</b>
</div>
<div id="body_top">
<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"> 最近的10篇日志</span>
</td>
</tr>
</table>
</div>
<?
//============================ 显示日志 =======================================
$query = "SELECT DIA_ID,CONTENT,DIA_TIME,DIA_DATE,SUBJECT,ATTACHMENT_ID,ATTACHMENT_NAME from DIARY where USER_ID='$USER_ID' and DIA_TYPE!='2' order by DIA_DATE desc,DIA_ID desc limit 0,10";
$cursor= exequery($connection,$query);
$DIA_COUNT=0;
while($ROW=mysql_fetch_array($cursor))
{
$DIA_COUNT++;
$DIA_ID=$ROW["DIA_ID"];
$DIA_DATE=$ROW["DIA_DATE"];
$DIA_DATE=strtok($DIA_DATE," ");
$SUBJECT=$ROW["SUBJECT"];
$DIA_TIME=$ROW["DIA_TIME"];
$CONTENT=$ROW["CONTENT"];
$ATTACHMENT_ID=$ROW["ATTACHMENT_ID"];
$ATTACHMENT_NAME=$ROW["ATTACHMENT_NAME"];
if($SUBJECT=="")
$SUBJECT=csubstr(strip_tags($CONTENT),0,50).(strlen($CONTENT)>50?"...":"");
if($DIA_COUNT==1)
{
?>
<div class="body_content">
<?
}
?>
<div class="one_diary">
<DIV class="subject"><A href="read.php?DIA_ID=<?=$DIA_ID?>&USER_NAME=<?=$USER_NAME?>&FROM_FLAG=1&DIA_COUNT=<?=$DIA_COUNT-1?>"><?=$SUBJECT?></A></DIV>
<DIV class="diary_type">工作日志 | 日志日期：<?=$DIA_DATE?> | 最后修改：<?=$DIA_TIME?></DIV>
<DIV class="content" style="overflow-y:auto;overflow-x:auto;width=100%;height=100%">
<?
echo $CONTENT;
if($ATTACHMENT_ID!="")
{
echo "<br><br>附件：<br>";
echo attach_link($ATTACHMENT_ID,$ATTACHMENT_NAME,0,1,1);
}
?>
</DIV>
<div class="content">
<?
$COUNT=0;
$query2 = "SELECT * from DIARY_COMMENT where DIA_ID='$DIA_ID' order by SEND_TIME asc";
$cursor2= exequery($connection,$query2);
while($ROW=mysql_fetch_array($cursor2))
{
$COUNT++;
$USER_ID1=$ROW["USER_ID"];
$SEND_TIME=$ROW["SEND_TIME"];
$CONTENT=$ROW["CONTENT"];
$COMMENT_ID=$ROW["COMMENT_ID"];
$COMMENT_FLAG=$ROW["COMMENT_FLAG"];
$CONTENT=str_replace("\"","'",$CONTENT);
$query3 = "SELECT * from USER where USER_ID='$USER_ID1'";
$cursor3= exequery($connection,$query3);
if($ROW1=mysql_fetch_array($cursor3))
$USER_NAME1=$ROW1["USER_NAME"];
if($COMMENT_FLAG==0 && $DIA_TYPE!=2)
$COMMENT_FLAG_DESC="<font color=red>未读</font>";
else if($DIA_TYPE!=2)
$COMMENT_FLAG_DESC="<font color=green>已读</font>";
if($COUNT==1)
{
?>
<b>[以下是点评内容]</b><br />
<?
}
?>
<font color="#0000FF"><?=$COUNT?>楼 <?=$USER_NAME1?> <?=$SEND_TIME?></font> <?=$COMMENT_FLAG_DESC?>
<?
if($USER_ID1 == $LOGIN_USER_ID)
{
?>
<a href="delete.php?COMMENT_ID=<?=$COMMENT_ID?>&FROMUD=1&USER_ID=<?=$USER_ID?>&DEPT_ID=<?=$DEPT_ID?>">删除</a>
<?
}
?>
<div class="replycontent"><?=$CONTENT?></div>
<?
}
?>
</div>
<DIV class="operate">
<input type="button" value="点评" onclick="javascript:location.href('comment.php?DIA_ID=<?=$DIA_ID?>&USER_ID=<?=$USER_ID?>')" class="SmallButton" name="button">
</DIV>
</div>
<?
}//while
?>
<?
if($DIA_COUNT==0)
{
Message("","无日志记录");
exit;
}
?>
<br>
<table border="0" width="100%" cellspacing="0" cellpadding="3" class="small">
<form action="search.php" name="form1">
<tr>
<td class="Big"><img src="/images/menu/diary.gif" WIDTH="18" HEIGHT="18" align="absmiddle"><span class="big3"> 日志查询</span>
</td>
</tr>
</table>
<table class="TableBlock" width="97%" align="center">
<tr>
<td nowrap class="TableData">起始日期：</td>
<td class="TableData"><input type="text" name="BEGIN_DATE" size="10" maxlength="10" class="BigInput" value="<?=$BEGIN_DATE?>">
<img src="/images/menu/calendar.gif" align="absMiddle" border="0" style="cursor:hand" onclick="td_calendar('form1.BEGIN_DATE');">
</td>
</tr>
<tr>
<td nowrap class="TableData">截止日期：</td>
<td class="TableData"><input type="text" name="END_DATE" size="10" maxlength="10" class="BigInput" value="<?=$CUR_DATE?>">
<img src="/images/menu/calendar.gif" align="absMiddle" border="0" style="cursor:hand" onclick="td_calendar('form1.END_DATE');">
</td>
</tr>
<tr>
<td nowrap class="TableData">标题：</td>
<td class="TableData"><input type="text" name="SUBJECT" class="BigInput" size="40"></td>
</tr>
<tr>
<td nowrap class="TableData">关键词1：</td>
<td class="TableData"><input type="text" name="KEY1" class="BigInput" size="40"></td>
</tr>
<tr>
<td nowrap class="TableData">关键词2：</td>
<td class="TableData"><input type="text" name="KEY2" class="BigInput" size="40"></td>
</tr>
<tr>
<td nowrap class="TableData">关键词3：</td>
<td class="TableData"><input type="text" name="KEY3" class="BigInput" size="40"></td>
</tr>
<tr >
<td nowrap class="TableControl" colspan="2" align="center">
<input type="hidden" name="USER_ID" value="<?=$USER_ID?>">
<input type="hidden" name="USER_NAME" value="<?=$USER_NAME?>">
<input type="submit" value="查询" class="BigButton" title="进行查询" name="button">
</td>
</tr>
</form>
</table>
</body>
</html>
⌨️ 快捷键说明
复制代码Ctrl + C
搜索代码Ctrl + F
全屏模式F11
增大字号Ctrl + =
减小字号Ctrl + -
显示快捷键?