📄 index.php

📁 极限网络智能办公系统 Office Automation V3.0官方100％源代码.
💻 PHP
字号:
<?
include_once("inc/auth.php");
include_once("inc/utility_all.php");

if(!isset($TYPE))
   $TYPE="0";
?>

<html>
<head>
<title>新闻列表</title>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">

<script Language=JavaScript>
window.setTimeout('this.location.reload();',120000);
</script>

<script>
function open_news(NEWS_ID,FORMAT)
{
 URL="read_news.php?NEWS_ID="+NEWS_ID;
 myleft=(screen.availWidth-500)/2;
 mytop=150
 mywidth=600;
 myheight=500;
 if(FORMAT=="1")
 {
    myleft=0;
    mytop=0
    mywidth=screen.availWidth;
    myheight=screen.availHeight-40;
 }
 window.open(URL,"read_news","height="+myheight+",width="+mywidth+",status=1,toolbar=no,menubar=no,location=no,scrollbars=yes,top="+mytop+",left="+myleft+",resizable=yes");
}

function re_news(NEWS_ID)
{
 URL="/general/news/show/re_news.php?NEWS_ID="+NEWS_ID;
 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");
}
function order_by(field,asc_desc)
{
 window.location="index.php?CUR_PAGE=<?=$CUR_PAGE?>&TYPE=<?=$TYPE?>&FIELD="+field+"&ASC_DESC="+asc_desc;
}

function change_type(type)
{
 window.location="index.php?CUR_PAGE=<?=$CUR_PAGE?>&TYPE="+type+"&FIELD=<?=$FIELD?>&ASC_DESC=<?=$ASC_DESC?>";
}
</script>

</head>
<body class="bodycolor" topmargin="5">

<?
 $query = "SELECT count(*) from NEWS where PUBLISH='1'";
 if($TYPE!="0")
   $query .= " and TYPE_ID='$TYPE'";
 $cursor= exequery($connection,$query);
 $NEWS_COUNT=0;
 if($ROW=mysql_fetch_array($cursor))
    $NEWS_COUNT=$ROW[0];

 if($NEWS_COUNT==0)
 {
?>
<table border="0" width="100%" cellspacing="0" cellpadding="3" class="small">
  <tr>
    <td class="Big"><img src="/images/notify_open.gif" align="absmiddle"><span class="big3"> 新闻</span><br>
    </td>
  </tr>
</table>
<br>

<?
   Message("","无已发布的新闻");
   exit;
 }
 $PER_PAGE=15;
 $PAGES=10;
 $PAGE_COUNT=ceil($NEWS_COUNT/$PER_PAGE);

 if($CUR_PAGE<=0 || $CUR_PAGE=="")
    $CUR_PAGE=1;
 if($CUR_PAGE>$PAGE_COUNT)
    $CUR_PAGE=$PAGE_COUNT;

?>

<table border="0" width="100%" cellspacing="0" cellpadding="3" class="small">
  <tr>
    <td class="Big"><img src="/images/notify_open.gif" align="absmiddle"><span class="big3"> 新闻</span>&nbsp;
       <select name="TYPE" class="BigSelect" onchange="change_type(this.value);">
          <option value="0"<?if($TYPE=="0") echo " selected";?>>所有类型</option>
          <?=code_list("NEWS",$TYPE)?>
          <option value=""<?if($TYPE=="") echo " selected";?>>无类型</option>
       </select>
    </td>

    <td align="right" valign="bottom" class="small1">共<span class="big4">&nbsp;<?=$NEWS_COUNT?></span>&nbsp;条新闻
    </td>
    <td align="right" valign="bottom" class="small1">
       <a class="A1" href="index.php?CUR_PAGE=1&TYPE=<?=$TYPE?>&FIELD=<?=$FIELD?>&ASC_DESC=<?=$ASC_DESC?>">首页</a>&nbsp;
       <a class="A1" href="index.php?CUR_PAGE=<?=$PAGE_COUNT?>&TYPE=<?=$TYPE?>&FIELD=<?=$FIELD?>&ASC_DESC=<?=$ASC_DESC?>">末页</a>&nbsp;&nbsp;
<?
if($CUR_PAGE%$PAGES==0)
   $J=$PAGES;
else
   $J=$CUR_PAGE%$PAGES;

if($CUR_PAGE> $PAGES)
{
?>
       <a class="A1" href="index.php?CUR_PAGE=<?=$CUR_PAGE-$J-$PAGES+1?>&TYPE=<?=$TYPE?>&FIELD=<?=$FIELD?>&ASC_DESC=<?=$ASC_DESC?>">上<?=$PAGES?>页</a>&nbsp;&nbsp;
<?
}

for($I=$CUR_PAGE-$J+1;$I<=$CUR_PAGE-$J+$PAGES;$I++)
{
   if($I>$PAGE_COUNT)
      break;

   if($I==$CUR_PAGE)
   {
?>
       [<?=$I?>]&nbsp;
<?
   }
   else
   {
?>
       [<a class="A1" href="index.php?CUR_PAGE=<?=$I?>&TYPE=<?=$TYPE?>&FIELD=<?=$FIELD?>&ASC_DESC=<?=$ASC_DESC?>"><?=$I?></a>]&nbsp;
<?
   }
}
?>
      &nbsp;
<?
if($I-1< $PAGE_COUNT)
{
?>
       <a class="A1" href="index.php?CUR_PAGE=<?=$I?>&TYPE=<?=$TYPE?>&FIELD=<?=$FIELD?>&ASC_DESC=<?=$ASC_DESC?>">下<?=$PAGES?>页</a>&nbsp;&nbsp;
<?
}
if($CUR_PAGE-1>=1)
{
?>
       <a class="A1" href="index.php?CUR_PAGE=<?=$CUR_PAGE-1?>&TYPE=<?=$TYPE?>&FIELD=<?=$FIELD?>&ASC_DESC=<?=$ASC_DESC?>">上一页</a>&nbsp;
<?
}
else
{
?>
       上一页&nbsp;
<?
}

if($CUR_PAGE+1<= $PAGE_COUNT)
{
?>
       <a class="A1" href="index.php?CUR_PAGE=<?=$CUR_PAGE+1?>&TYPE=<?=$TYPE?>&FIELD=<?=$FIELD?>&ASC_DESC=<?=$ASC_DESC?>">下一页</a>&nbsp;
<?
}
else
{
?>
       下一页&nbsp;
<?
}
?>
       &nbsp;
    </td>
    </tr>
</table>
<?
if($ASC_DESC=="")
   $ASC_DESC="1";
if($FIELD=="")
   $FIELD="NEWS_TIME";
$query = "SELECT * from NEWS where PUBLISH='1'";

if($TYPE!="0")
   $query .= " and TYPE_ID='$TYPE'";
$query .= " order by $FIELD";
if($ASC_DESC=="1")
   $query .= " desc";
else
   $query .= " asc";

if($ASC_DESC=="0")
   $ORDER_IMG="<img border=0 src=\"/images/arrow_up.gif\" width=\"11\" height=\"10\">";
else
   $ORDER_IMG="<img border=0 src=\"/images/arrow_down.gif\" width=\"11\" height=\"10\">";
?>
<br>
<table border="0" cellspacing="1" width="95%" class="small" bgcolor="#000000" cellpadding="3">
  <tr class="TableHeader">
      <td nowrap align="center" onclick="order_by('SUBJECT','<?if($FIELD=="SUBJECT") echo 1-$ASC_DESC;else echo "1";?>');" style="cursor:hand;"><u>标题</u><?if($FIELD=="SUBJECT") echo $ORDER_IMG;?></td>
      <td nowrap align="center">类型</td>
      <td nowrap align="center" onclick="order_by('NEWS_TIME','<?if($FIELD=="NEWS_TIME"||$FIELD=="") echo 1-$ASC_DESC;else echo "1";?>');" style="cursor:hand;"><u>发布时间</u><?if($FIELD=="NEWS_TIME"||$FIELD=="") echo $ORDER_IMG;?></td>
      <td nowrap align="center" onclick="order_by('CLICK_COUNT','<?if($FIELD=="CLICK_COUNT") echo 1-$ASC_DESC;else echo "1";?>');" style="cursor:hand;"><u>点击次数</u><?if($FIELD=="CLICK_COUNT") echo $ORDER_IMG;?></td>
      <td nowrap align="center">评论(条)</td>
      <td nowrap align="center">新闻评论</td>
    </tr>

<?
 //============================ 显示已发布新闻 =======================================
 $cursor= exequery($connection,$query);
 $NEWS_COUNT=0;
 while($ROW=mysql_fetch_array($cursor))
 {
    $NEWS_COUNT++;
    if($NEWS_COUNT<$CUR_PAGE*$PER_PAGE-$PER_PAGE+1)
       continue;
    if($NEWS_COUNT>$CUR_PAGE*$PER_PAGE)
       break;

    $NEWS_ID=$ROW["NEWS_ID"];
    $SUBJECT=$ROW["SUBJECT"];
    $NEWS_TIME=$ROW["NEWS_TIME"];
    $CLICK_COUNT=$ROW["CLICK_COUNT"];
    $FORMAT=$ROW["FORMAT"];
    $TYPE_ID=$ROW["TYPE_ID"];
    $TYPE_NAME=get_code_name($TYPE_ID,"NEWS");

    $SUBJECT=htmlspecialchars($SUBJECT);

    $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";
?>
    <tr class="<?=$TableLine?>">
      <td>
      <a href="javascript:open_news('<?=$NEWS_ID?>','<?=$FORMAT?>');"><?=$SUBJECT?></a>
<?
    if(time()-strtotime($NEWS_TIME)<=48*3600)
    {
?>
      <img src="/images/email_new.gif" align="absMiddle">
<?
    }
?>
      </td>
      <td nowrap align="center"><?=$TYPE_NAME?></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="javascript:re_news('<?=$NEWS_ID?>');">评论</a></td>
    </tr>
<?
 }
?>

</table>

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

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

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