📄 user_diary.php
字号:
<?
include_once("inc/auth.php");
include_once("inc/utility_all.php");
?>
<html>
<head>
<title>工作日志查询</title>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<script>
function CheckForm()
{
if(document.form1.BEGIN_DATE.value=="")
{ alert("起始日期不能为空！");
return (false);
}
if(document.form1.END_DATE.value=="")
{ alert("截止日期不能为空！");
return (false);
}
return true;
}
function td_calendar(fieldname)
{
myleft=document.body.scrollLeft+event.clientX-event.offsetX-80;
mytop=document.body.scrollTop+event.clientY-event.offsetY+140;
window.showModalDialog("/inc/calendar.php?FIELDNAME="+fieldname,self,"edge:raised;scroll:0;status:0;help:0;resizable:1;dialogWidth:280px;dialogHeight:215px;dialogTop:"+mytop+"px;dialogLeft:"+myleft+"px");
}
</script>
</head>
<body class="bodycolor" topmargin="5">
<?
$BEGIN_DATE=date("Y-m-01",time());
$CUR_DATE=date("Y-m-d",time());
$query = "SELECT * 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">
<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="22" HEIGHT="20" align="absmiddle"><span class="big3"> 最近的10篇日志</span>
</td>
</tr>
</table>
<br>
<?
//============================ 显示日志 =======================================
$query = "SELECT * from DIARY where USER_ID='$USER_ID' and DIA_TYPE='1' order by DIA_DATE desc";
$cursor= exequery($connection,$query);
$DIA_COUNT=0;
while($ROW=mysql_fetch_array($cursor))
{
$DIA_COUNT++;
if($DIA_COUNT>10)
break;
$DIA_ID=$ROW["DIA_ID"];
$DIA_DATE=$ROW["DIA_DATE"];
$DIA_DATE=strtok($DIA_DATE," ");
$CONTENT=$ROW["CONTENT"];
if($DIA_COUNT==1)
{
?>
<table border="0" cellspacing="1" width="95%" class="small" bgcolor="#000000" cellpadding="3">
<?
}
if($DIA_COUNT%2==1)
$TableLine="TableLine1";
else
$TableLine="TableLine2";
?>
<tr class="<?=$TableLine?>">
<td nowrap align="center" width="100"><?=$DIA_DATE?></td>
<td><a href="read.php?DIA_ID=<?=$DIA_ID?>&USER_NAME=<?=$USER_NAME?>"><?=csubstr(strip_tags($CONTENT),0,50)?> <? if(strlen($CONTENT)>50)echo "...";?></a></td>
<td nowrap align="center" width="60"><a href="comment.php?DIA_ID=<?=$DIA_ID?>&USER_ID=<?=$USER_ID?>">点评</a></td>
</tr>
<?
}//while
if($DIA_COUNT==0)
{
Message("","无日志记录");
exit;
}
else
{
?>
<thead class="TableHeader">
<td nowrap align="center">日期 <img border=0 src="/images/arrow_down.gif" width="11" height="10"></td>
<td nowrap align="center">日志内容</td>
<td nowrap align="center">操作</td>
</thead>
</table>
<?
}
?>
<br>
<table width="95%" border="0" cellspacing="0" cellpadding="0" height="3">
<tr>
<td background="/images/dian1.gif" width="100%"></td>
</tr>
</table>
<table border="0" width="100%" cellspacing="0" cellpadding="3" class="small">
<form action="search.php" name="form1" onsubmit="return CheckForm();">
<tr>
<td class="Big"><img src="/images/menu/diary.gif" WIDTH="22" HEIGHT="20" align="absmiddle"><span class="big3"> 日志查询</span>
</td>
</tr>
</table>
<table border="0" width="400" cellpadding="2" cellspacing="1" align="center" bgcolor="#000000" class="small">
<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" 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" border="0" style="cursor:hand" onclick="td_calendar('form1.END_DATE');">
</td>
</tr>
<tr>
<td nowrap class="TableData">关键词1：</td>
<td class="TableData"><input type="text" name="KEY1" class="BigInput" size="20"></td>
</tr>
<tr>
<td nowrap class="TableData">关键词2：</td>
<td class="TableData"><input type="text" name="KEY2" class="BigInput" size="20"></td>
</tr>
<tr>
<td nowrap class="TableData">关键词3：</td>
<td class="TableData"><input type="text" name="KEY3" class="BigInput" size="20"></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 + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -