📄 index.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 delete_diary(DIA_ID)
{
msg='确认要删除该日志么？';
if(window.confirm(msg))
{
URL="delete.php?DIA_ID=" + DIA_ID;
window.location=URL;
}
}
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">
<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"> 新建日志</span><br>
</td>
</tr>
</table>
<div align="center">
<input type="button" value="新建日志" class="BigButton" onClick="location='new';" title="新建工作日志">
</div>
<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">
<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>
<?
$BEGIN_DATE=date("Y-m-01",time());
$CUR_DATE=date("Y-m-d",time());
//============================ 显示日志 =======================================
$query = "SELECT * from DIARY where USER_ID='$LOGIN_USER_ID' order by DIA_DATE desc,DIA_ID 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," ");
$DIA_TYPE=$ROW["DIA_TYPE"];
$CONTENT=$ROW["CONTENT"];
/*
$CONTENT=str_replace("<","<",$CONTENT);
$CONTENT=str_replace(">",">",$CONTENT);
$CONTENT=stripslashes($CONTENT);
*/
switch($DIA_TYPE)
{
case "1":
$DIA_TYPE_DESC="工作日志";
break;
case "2":
$DIA_TYPE_DESC="个人日志";
break;
}
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";
$query1 = "SELECT * from SYS_PARA where PARA_NAME='LOCK_TIME'";
$cursor1= exequery($connection,$query1);
if($ROW1=mysql_fetch_array($cursor1))
$PARA_VALUE=$ROW1["PARA_VALUE"];
if($PARA_VALUE!="")
{
$W_START=substr($PARA_VALUE,0,strpos($PARA_VALUE,","));
$W_END=substr($PARA_VALUE,strpos($PARA_VALUE,",")+1);
}
?>
<tr class="<?=$TableLine?>">
<td nowrap align="center" width="100"><?=$DIA_DATE?></td>
<td nowrap align="center" width="100"><?=$DIA_TYPE_DESC?></td>
<td><a href="read.php?DIA_ID=<?=$DIA_ID?>"><?=csubstr(strip_tags($CONTENT),0,50);?> <? if(strlen($CONTENT)>50)echo "...";?></a></td>
<td nowrap align="center" width="100">
<?
if($PARA_VALUE=="" || $PARA_VALUE==",")
{
?>
<a href="edit.php?DIA_ID=<?=$DIA_ID?>">编辑</a>
<a href="javascript:delete_diary(<?=$DIA_ID?>);"> 删除</a>
<?
}
elseif($W_START=="" && $W_END!="" && compare_date($DIA_DATE,$W_END)==1)
{
?>
<a href="edit.php?DIA_ID=<?=$DIA_ID?>">编辑</a>
<a href="javascript:delete_diary(<?=$DIA_ID?>);"> 删除</a>
<?
}
elseif($W_START!="" && $W_END=="" && compare_date($W_START,$DIA_DATE)==1)
{
?>
<a href="edit.php?DIA_ID=<?=$DIA_ID?>">编辑</a>
<a href="javascript:delete_diary(<?=$DIA_ID?>);"> 删除</a>
<?
}
elseif($W_START!="" && $W_END!="" && (compare_date($DIA_DATE,$W_END)==1 || compare_date($W_START,$DIA_DATE)==1))
{
?>
<a href="edit.php?DIA_ID=<?=$DIA_ID?>">编辑</a>
<a href="javascript:delete_diary(<?=$DIA_ID?>);"> 删除</a>
<?
}
?>
</td>
</tr>
<?
}
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>
<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">
<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">
<form action="search.php" name="form1" onsubmit="return CheckForm();">
<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">日志类型：</td>
<td class="TableData">
<select name="DIA_TYPE" class="BigSelect">
<option value="0">所有类型</option>
<option value="1">工作日志</option>
<option value="2">个人日志</option>
</select>
</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="submit" value="查询" class="BigButton" title="进行查询" name="button">
</td>
</tr>
</form>
</table>
</body>
</html>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -