📄 search.php
字号:
<?
include_once("inc/auth.php");
include_once("inc/check_type.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;
}
}
</script>
</head>
<body class="bodycolor" topmargin="5">
<?
//----------- 合法性校验 ---------
if($BEGIN_DATE!="")
{
$TIME_OK=is_date($BEGIN_DATE);
if(!$TIME_OK)
{ Message("错误","起始日期格式不对，应形如 1999-1-2");
Button_Back();
exit;
}
}
if($END_DATE!="")
{
$TIME_OK=is_date($END_DATE);
if(!$TIME_OK)
{ Message("错误","截止日期格式不对，应形如 1999-1-2");
Button_Back();
exit;
}
}
?>
<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>
<br>
<?
$CUR_DATE=date("Y-m-d",time());
$BEGIN_DATE.=" 00:00:00";
$END_DATE.=" 23:59:59";
//============================ 显示日志 =======================================
$query = "SELECT * from DIARY where DIA_DATE>='$BEGIN_DATE' and DIA_DATE<='$END_DATE' and USER_ID='$LOGIN_USER_ID'";
if($DIA_TYPE!="0")
$query .= " and DIA_TYPE='$DIA_TYPE'";
$query .= " order by DIA_DATE desc";
$cursor= exequery($connection,$query);
$DIA_COUNT=0;
while($ROW=mysql_fetch_array($cursor))
{
$DIA_ID=$ROW["DIA_ID"];
$DIA_DATE=$ROW["DIA_DATE"];
$DIA_DATE=strtok($DIA_DATE," ");
$DIA_TYPE=$ROW["DIA_TYPE"];
$CONTENT=$ROW["CONTENT"];
$FLAG=0;
if($KEY1!="" && stristr(strip_tags($CONTENT),$KEY1))
$FLAG++;
if($KEY2!="" && stristr(strip_tags($CONTENT),$KEY2))
$FLAG++;
if($KEY3!="" && stristr(strip_tags($CONTENT),$KEY3))
$FLAG++;
if($FLAG==0&&($KEY1!=""||$KEY2!=""||$KEY3!=""))
continue;
$DIA_COUNT++;
switch($DIA_TYPE)
{
case "1":
$DIA_TYPE_DESC="工作日志";
break;
case "2":
$DIA_TYPE_DESC="个人日志";
break;
}
$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);
}
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 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>
<?
}//while
if($DIA_COUNT==0)
{
Message("","无符合条件的日志记录");
}
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>
<?
}
session_start();
$QUERY_DIARY=$query;
if(!session_is_registered("QUERY_DIARY"))
session_register("QUERY_DIARY");
if($DIA_COUNT>0)
{
Message("","共 ".$DIA_COUNT." 篇日志");
}
?>
<div align="center">
<?
if($DIA_COUNT>0)
{
?>
<input type="button" value="导出" class="BigButton" onClick="window.open('export.php?KEY1=<?=$KEY1?>&KEY2=<?=$KEY2?>&KEY3=<?=$KEY3?>');">
<?
}
?>
<input type="button" value="返回" class="BigButton" onClick="location='index.php';">
</div>
</body>
</html>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -