📄 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 open_news(NEWS_ID)
{
 URL="/general/news/show/read_news.php?NEWS_ID="+NEWS_ID;
 myleft=(screen.availWidth-500)/2;
 window.open(URL,"read_news","height=400,width=550,status=1,toolbar=no,menubar=no,location=no,scrollbars=yes,top=150,left="+myleft+",resizable=yes");
}

function delete_news(NEWS_ID,CUR_PAGE)
{
 msg='确认要删除该项新闻么？';
 if(window.confirm(msg))
 {
  URL="delete.php?NEWS_ID=" + NEWS_ID + "&CUR_PAGE=" + CUR_PAGE;
  window.location=URL;
 }
}


function delete_all()
{
 msg='确认要删除所有新闻么？';
 if(window.confirm(msg))
 {
  URL="delete_all.php";
  window.location=URL;
 }
}

function re_news(NEWS_ID)
{
 URL="/general/news/show/re_news.php?NEWS_ID="+NEWS_ID+"&MANAGE=1";
 myleft=(screen.availWidth-500)/2;
 window.open(URL,"read_news","height=500,width=550,status=1,toolbar=no,menubar=no,location=no,scrollbars=yes,top=100,left="+myleft+",resizable=yes");
}
</script>
</head>
<body class="bodycolor" topmargin="5">

<?
 $connection=OpenConnection();
 $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 NEWS_TIME>='$SEND_TIME_MIN'";
 if($SEND_TIME_MAX!="")
    $CONDITION_STR.=" and NEWS_TIME<='$SEND_TIME_MAX'";
 if($CLICK_COUNT_MIN!="")
    $CONDITION_STR.=" and CLICK_COUNT>=$CLICK_COUNT_MIN";
 if($CLICK_COUNT_MAX!="")
    $CONDITION_STR.=" and CLICK_COUNT<=$CLICK_COUNT_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'";
?>

<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 NEWS where 1=1";
else
   $query = "SELECT * from NEWS where PROVIDER='$LOGIN_USER_ID'";
$query.=$CONDITION_STR." order by NEWS_TIME desc";
$cursor=exequery($connection,$query);
$NEWS_COUNT=0;
while($ROW=mysql_fetch_array($cursor))
{
    $NEWS_COUNT++;
    $NEWS_ID=$ROW["NEWS_ID"];
    $SUBJECT=$ROW["SUBJECT"];
    $PROVIDER=$ROW["PROVIDER"];
    $NEWS_TIME=$ROW["NEWS_TIME"];
    $CLICK_COUNT=$ROW["CLICK_COUNT"];
    $TYPE_ID=$ROW["TYPE_ID"];

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

    $query1="select * from USER where USER_ID='$PROVIDER'";
    $cursor1= exequery($connection,$query1);
    if($ROW=mysql_fetch_array($cursor1))
    {
       $PROVIDER_NAME=$ROW["USER_NAME"];
       $DEPT_ID=$ROW["DEPT_ID"];
    }
    
    $TYPE_NAME=get_code_name($TYPE_ID,"NEWS");
    
    $DEPT_NAME=dept_long_name($DEPT_ID);
    
    $query1 = "SELECT count(*) from NEWS_COMMENT where NEWS_ID=$NEWS_ID";
    $cursor1= exequery($connection,$query1);
    $COMMENT_COUNT=0;
    if($ROW1=mysql_fetch_array($cursor1))
       $COMMENT_COUNT=$ROW1[0];

    if($NEWS_COUNT%2==1)
       $TableLine="TableLine1";
    else
       $TableLine="TableLine2";
    
   if($NEWS_COUNT==1)
   {
?>
<table border="0" cellspacing="1" width="95%" 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">发布时间 <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>
    </tr>
<?
   }
   if($NEWS_COUNT%2==1)
      $TableLine="TableLine1";
   else
      $TableLine="TableLine2";
?>
 <tr class="<?=$TableLine?>">
      <td align="center">
      <a href="javascript:open_news('<?=$NEWS_ID?>');"><?=$SUBJECT?></a>
      </td>
      <td align="center"><?=$TYPE_NAME?></td>
      <td nowrap align="center"><u title="部门：<?=$DEPT_NAME?>" style="cursor:hand"><?=$PROVIDER_NAME?></u></td>
      <td nowrap align="center"><?=$NEWS_TIME?></td>
      <td nowrap align="center"><?=$CLICK_COUNT?></td>
      <td nowrap align="center"><?=$COMMENT_COUNT?></td>
      <td nowrap align="center">
      <a href="modify.php?NEWS_ID=<?=$NEWS_ID?>&CUR_PAGE=<?=$CUR_PAGE?>"> 修改</a>
      <a href="javascript:delete_news('<?=$NEWS_ID?>','<?=$CUR_PAGE?>');"> 删除</a>
      <a href="javascript:re_news('<?=$NEWS_ID?>');"> 管理评论</a>
      </td>
    </tr>
<?
}

if($NEWS_COUNT==0)
{
   Message("","无符合条件的新闻");
   Button_Back();
   exit;
}
else
{
?>
</table>
<?
Button_Back();
}

?>
</body>

</html>
💿 文件大小 24085 K
👤 上传用户 happy_christina
📂 所属分类 OA系统
🏷️ 相关标签

#Automation #Office #3.0 #100
⌨️ 快捷键说明

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