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

📄 search.php

📁 通达的部分源代码大家研究一下吧
💻 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 open_notify(NOTIFY_ID)
{
 URL="../show/read_notify.php?NOTIFY_ID="+NOTIFY_ID;
 myleft=(screen.availWidth-500)/2;
 window.open(URL,"read_notify","height=400,width=550,status=1,toolbar=no,menubar=no,location=no,scrollbars=yes,top=150,left="+myleft+",resizable=yes");
}

function show_reader(NOTIFY_ID)
{
 URL="show_reader.php?NOTIFY_ID="+NOTIFY_ID;
 myleft=(screen.availWidth-500)/2;
 window.open(URL,"read_notify","height=350,width=500,status=1,toolbar=no,menubar=no,location=no,scrollbars=yes,top=150,left="+myleft+",resizable=yes");
}

function delete_notify(NOTIFY_ID,CUR_PAGE)
{
 msg='确认要删除该项公告通知么？';
 if(window.confirm(msg))
 {
  URL="delete.php?NOTIFY_ID=" + NOTIFY_ID + "&CUR_PAGE=" + CUR_PAGE;
  window.location=URL;
 }
}
</script>
</head>
<body class="bodycolor" topmargin="5">

<?
 $CUR_DATE=date("Y-m-d",time());
  //----------- 合法性校验 ---------
  if($SEND_TIME_MIN!="")
  {
    $TIME_OK=is_date($SEND_TIME_MIN);

    if(!$TIME_OK)
    { Message("错误","\"发布日期\"的格式不对，应形如 ".$CUR_DATE);
      Button_Back();
      exit;
    }
    $SEND_TIME_MIN=$SEND_TIME_MIN." 00:00:00";
  }

  if($SEND_TIME_MAX!="")
  {
    $TIME_OK=is_date($SEND_TIME_MAX);

    if(!$TIME_OK)
    { Message("错误","\"发布日期\"的格式不对，应形如 ".$CUR_DATE);
      Button_Back();
      exit;
    }
    $SEND_TIME_MAX=$SEND_TIME_MAX." 23:59:59";
  }
  
 //------------------------ 生成条件字符串 ------------------
 $CONDITION_STR="";
 if($SUBJECT!="")
    $CONDITION_STR.=" and SUBJECT like '%".$SUBJECT."%'";
 if($CONTENT!="")
    $CONDITION_STR.=" and CONTENT like '%".$CONTENT."%'";
 if($SEND_TIME_MIN!="")
    $CONDITION_STR.=" and SEND_TIME>='$SEND_TIME_MIN'";
 if($SEND_TIME_MAX!="")
    $CONDITION_STR.=" and SEND_TIME<='$SEND_TIME_MAX'";
 if($FORMAT!="")
    $CONDITION_STR.=" and FORMAT='$FORMAT'";
 if($TYPE_ID!="")
    $CONDITION_STR.=" and TYPE_ID='$TYPE_ID'";
 if($PUBLISH!="")
    $CONDITION_STR.=" and PUBLISH='$PUBLISH'";
    
 if($STAT!="")
 {
    if($STAT==1)
       $CONDITION_STR.=" and BEGIN_DATE>'$CUR_DATE'";
    else if($STAT==2)
       $CONDITION_STR.=" and BEGIN_DATE<='$CUR_DATE' and (END_DATE='0000-00-00' or END_DATE>='$CUR_DATE')";
    else if($STAT==3)
       $CONDITION_STR.=" and END_DATE!='0000-00-00' and END_DATE<='$CUR_DATE'";
 }
?>

<table border="0" width="100%" cellspacing="0" cellpadding="3" class="small">
  <tr>
    <td class="Big"><img src="/images/menu/infofind.gif" width="24" height="24" align="absMiddle"><span class="big3"> 公告通知查询结果</span><br>
    </td>
  </tr>
</table>

<?
if($LOGIN_USER_PRIV!="1")
   $query = "SELECT * from NOTIFY where FROM_ID='$LOGIN_USER_ID'";
else
   $query = "SELECT * from NOTIFY where 1=1";
$query.=$CONDITION_STR." order by TOP desc, SEND_TIME desc";
$cursor=exequery($connection,$query);
$NOTIFY_COUNT=0;
while($ROW=mysql_fetch_array($cursor))
{
   $NOTIFY_COUNT++;

    $NOTIFY_ID=$ROW["NOTIFY_ID"];
    $FROM_ID=$ROW["FROM_ID"];
    $TO_ID=$ROW["TO_ID"];
    $SUBJECT=$ROW["SUBJECT"];
    $READERS=$ROW["READERS"];
    $FORMAT=$ROW["FORMAT"];
    $TOP=$ROW["TOP"];
    $PRIV_ID=$ROW["PRIV_ID"];
    $USER_ID=$ROW["USER_ID"];
    $TYPE_ID=$ROW["TYPE_ID"];

    $SUBJECT=str_replace("<","&lt",$SUBJECT);
    $SUBJECT=str_replace(">","&gt",$SUBJECT);
    $SUBJECT=stripslashes($SUBJECT);

    $SEND_TIME=$ROW["SEND_TIME"];
    $BEGIN_DATE=$ROW["BEGIN_DATE"];
    $END_DATE=$ROW["END_DATE"];

    $BEGIN_DATE=strtok($BEGIN_DATE," ");
    $END_DATE=strtok($END_DATE," ");
    
    if($END_DATE=="0000-00-00")
       $END_DATE="";

    $query1="select * from USER where USER_ID='$FROM_ID'";
    $cursor1= exequery($connection,$query1);
    if($ROW=mysql_fetch_array($cursor1))
    {
       $FROM_NAME=$ROW["USER_NAME"];
       $DEPT_ID=$ROW["DEPT_ID"];
    }

    $DEPT_NAME=dept_long_name($DEPT_ID);
    
    $TYPE_NAME=get_code_name($TYPE_ID,"NOTIFY");
    
    if($TO_ID=="ALL_DEPT")
       $TO_NAME="全体部门";
    else
    {
      $TO_NAME="";
      $TOK=strtok($TO_ID,",");
      while($TOK!="")
      {
        if($TO_NAME!="")
           $TO_NAME.="，";
        $query1="select * from DEPARTMENT where DEPT_ID=$TOK";
        $cursor1= exequery($connection,$query1);
        if($ROW=mysql_fetch_array($cursor1))
           $TO_NAME.=$ROW["DEPT_NAME"];
        
        $TOK=strtok(",");
      }
    }
    
    $TO_NAME_TITLE="";
    $TO_NAME_STR="";
    if($TO_NAME!="")
    {
       $TO_NAME_TITLE.="部门：".$TO_NAME;
       $TO_NAME_STR.="<font color=#0000FF><b>部门：</b></font>".csubstr(strip_tags($TO_NAME),0,20).(strlen($TO_NAME)>20?"...":"")."<br>";
    }
    
    $PRIV_NAME="";
    $TOK=strtok($PRIV_ID,",");
    while($TOK!="")
    {
       $query1 = "SELECT * from USER_PRIV where USER_PRIV='$TOK'";
       $cursor1= exequery($connection,$query1);
       if($ROW=mysql_fetch_array($cursor1))
          $PRIV_NAME.=$ROW["PRIV_NAME"]."，";
       $TOK=strtok(",");
    }
    if($PRIV_NAME!="")
    {
       $PRIV_NAME=substr($PRIV_NAME,0,-2);
       if($TO_NAME_TITLE!="")
          $TO_NAME_TITLE.="\n\n";
       $TO_NAME_TITLE.="角色：".$PRIV_NAME;
       $TO_NAME_STR.="<font color=#0000FF><b>角色：</b></font>".csubstr(strip_tags($PRIV_NAME),0,20).(strlen($PRIV_NAME)>20?"...":"")."<br>";
    }
    
    $USER_NAME="";
    $TOK=strtok($USER_ID,",");
    while($TOK!="")
    {
       $query1 = "SELECT * from USER where USER_ID='$TOK'";
       $cursor1= exequery($connection,$query1);
       if($ROW=mysql_fetch_array($cursor1))
          $USER_NAME.=$ROW["USER_NAME"]."，";
       $TOK=strtok(",");
    }
    if($USER_NAME!="")
    {
       $USER_NAME=substr($USER_NAME,0,-2);
       if($TO_NAME_TITLE!="")
          $TO_NAME_TITLE.="\n\n";
       $TO_NAME_TITLE.="人员：".$USER_NAME;
       $TO_NAME_STR.="<font color=#0000FF><b>人员：</b></font>".csubstr(strip_tags($USER_NAME),0,20).(strlen($USER_NAME)>20?"...":"")."<br>";
    }


    if(compare_date($CUR_DATE,$BEGIN_DATE)<0)
    {
       $NOTIFY_STATUS=1;
       $NOTIFY_STATUS_STR="待生效";
    }
    else
    {
       $NOTIFY_STATUS=2;
       $NOTIFY_STATUS_STR="<font color='#00AA00'><b>生效</span>";
    }

    
    if($END_DATE!="")
    {
      if(compare_date($CUR_DATE,$END_DATE)>0)
      {
         $NOTIFY_STATUS=3;
         $NOTIFY_STATUS_STR="<font color='#FF0000'><b>终止</span>";
      }
    }
    
   if($NOTIFY_COUNT==1)
   {
?>
<table border="0" cellspacing="1" width="100%" class="small" bgcolor="#000000" cellpadding="3">
  <tr class="TableHeader">
      <td nowrap align="center">发送人</td>
      <td nowrap align="center">类型</td>
      <td nowrap align="center">发送范围</td>
      <td nowrap align="center">标题</td>
      <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>
      <td nowrap align="center">操作</td>
    </tr>
<?
   }
   if($NOTIFY_COUNT%2==1)
      $TableLine="TableLine1";
   else
      $TableLine="TableLine2";
?>
 <tr class="<?=$TableLine?>">
      <td nowrap align="center"><u title="部门：<?=$DEPT_NAME?>" style="cursor:hand"><?=$FROM_NAME?></u></td>
      <td nowrap align="center"><?=$TYPE_NAME?></td>
      <td style="cursor:hand" title="<?=$TO_NAME_TITLE?>"><?=$TO_NAME_STR?></td>
      <td>
      <a href="javascript:open_notify('<?=$NOTIFY_ID?>');"><?if($TOP=="1") echo "<font color=#FF0000><b>重要：</b></font>";?><?=$SUBJECT?></a>
      </td>
      <td align="center"><?=$SEND_TIME?></a></td>
      <td nowrap align="center"><?=$BEGIN_DATE?></td>
      <td nowrap align="center"><?=$END_DATE?></td>
      <td nowrap align="center"><?=$NOTIFY_STATUS_STR?></td>
      <td nowrap align="center">
      <a href="modify.php?NOTIFY_ID=<?=$NOTIFY_ID?>"> 修改</a>
      <a href="javascript:delete_notify('<?=$NOTIFY_ID?>','<?=$CUR_PAGE?>');"> 删除</a>
      <?
      if($NOTIFY_STATUS==1)
      {
      ?>
      <a href="manage.php?NOTIFY_ID=<?=$NOTIFY_ID?>&OPERATION=1"> 立即生效</a>
      <?
      }
      else if($NOTIFY_STATUS==2)
      {
      ?>
      <a href="manage.php?NOTIFY_ID=<?=$NOTIFY_ID?>&OPERATION=2"> 终止</a>
      <?
      }
      else if($NOTIFY_STATUS==3)
      {
      ?>
      <a href="manage.php?NOTIFY_ID=<?=$NOTIFY_ID?>&OPERATION=3"> 生效</a>
      <?
      }
      ?>
      <br>
      <a href="javascript:show_reader('<?=$NOTIFY_ID?>');"> 查阅情况</a>
      </td>
    </tr>
<?
}

if($NOTIFY_COUNT==0)
{
   Message("","无符合条件的公告通知");
   Button_Back();
   exit;
}
else
{
?>
</table>
<?
Button_Back();
}

?>
</body>

</html>

⌨️ 快捷键说明

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