⭐ 欢迎来到虫虫下载站！ | 📦 资源下载 📁 资源专辑 ℹ️ 关于我们
⭐ 虫虫下载站
📤 上传资源

📄 search.php

📁 极限网络智能办公系统 Office Automation V3.0官方100％源代码.
💻 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;
    }
  }

?>

<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"> 查询结果</span>
    </td>
  </tr>
</table>

<br>

<?
 $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='$USER_ID' and DIA_TYPE='1'";

 $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," ");
    $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++;

    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>
<?
 }

 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>
   </thead>
   </table>
<?
 }
?>

<br>
<?
if($DIA_COUNT>0)
{
   Message("","共 ".$DIA_COUNT." 篇日志");
}
?>
<div align="center">
 <input type="button"  value="返回" class="BigButton" onClick="location='user_diary.php?USER_ID=<?=$USER_ID?>&USER_NAME=<?=$USER_NAME?>';">
</div>

</body>
</html>

⌨️ 快捷键说明

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