news.php

来自「通达OA2007SE源代码 非常好的」· PHP 代码 · 共 313 行

PHP
313 行
字号 
<?
  include_once 'inc/auth.php';
  include_once 'inc/utility_all.php';
  if (!isset ($TYPE))
  {
    $TYPE = '0';
  }
  $ITEMS_IN_PAGE = 10;
  if ((!isset ($start) OR ($start == '')))
  {
    $start = 0;
  }
  echo '
<html>
<head>
<title>新闻列表</title>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
';
  echo '<s';
  echo 'cript Language=JavaScript>
window.setTimeout(\'this.location.reload();\',120000);
</script>
';
  echo '<s';
  echo 'cript>
function open_news(NEWS_ID,FORMAT)
{
 URL="read_news.php?NEWS_ID="+NEWS_ID;
 myleft=(screen.availWidth-650)/2;
 mytop=100
 mywidth=650;
 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,';
  echo '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=';
  echo '"news.php?start=';
  echo $start;
  echo '&TYPE=';
  echo $TYPE;
  echo '&FIELD="+field+"&ASC_DESC="+asc_desc;
}
function change_type(type)
{
 window.location="news.php?start=';
  echo $start;
  echo '&TYPE="+type+"&FIELD=';
  echo $FIELD;
  echo '&ASC_DESC=';
  echo $ASC_DESC;
  echo '";
}
function read_all()
{
  msg=\'确认要标记所有新闻为已读吗？\';
  if(window.confirm(msg))
  {
    url="read_all.php";
    location=url;
  }
}
</script>
</head>
<body class="bodycolor" topmargin="5">
';
  $query = (((((((''.'SELECT count(*) from NEWS where PUBLISH=\'1\' and (TO_ID=\'ALL_DEPT\' or find_in_set(\'').$LOGIN_DEPT_ID).'\',TO_ID) or find_in_set(\'').$LOGIN_USER_PRIV).'\',PRIV_ID) or find_in_set(\'').$LOGIN_USER_ID).'\',USER_ID))');
  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))
  {
    echo '<table border="0" width="100%" cellspacing="0" cellpadding="3" class="small">
  <tr>
    <td class="Big"><img src="/images/notify_open.gif" align="absmiddle">';
    echo '<s';
    echo 'pan class="big3"> 新闻</span><br>
    </td>
  </tr>
</table>
';
    message ('', '无已发布的新闻');
    exit ();
  }
  echo '
<table border="0" width="100%" cellspacing="0" cellpadding="3" class="small">
  <tr>
    <td class="Big"><img src="/images/notify_open.gif" align="absmiddle">';
  echo '<s';
  echo 'pan class="big3"> 新闻</span>&nbsp;
       ';
  echo '<s';
  echo 'elect name="TYPE" class="BigSelect" onchange="change_type(this.value);">
          <option value="0"';
  if (($TYPE == '0'))
  {
    echo ' selected';
  }
  echo '>所有类型</option>
          ';
  echo code_list ('NEWS', $TYPE);
  echo '          <option value=""';
  if (($TYPE == ''))
  {
    echo ' selected';
  }
  echo '>无类型</option>
       </select>
    </td>
<td align="right" valign="bottom" class="small1">';
  echo page_bar ($start, $NEWS_COUNT, $ITEMS_IN_PAGE);
  echo '</td>
    </tr>
</table>
';
  if (($ASC_DESC == ''))
  {
    $ASC_DESC = '1';
  }
  $query = (((((((''.'SELECT NEWS_ID,SUBJECT,NEWS_TIME,CLICK_COUNT,FORMAT,TYPE_ID,ANONYMITY_YN,READERS from NEWS where PUBLISH=\'1\' and (TO_ID=\'ALL_DEPT\' or find_in_set(\'').$LOGIN_DEPT_ID).'\',TO_ID) or find_in_set(\'').$LOGIN_USER_PRIV).'\',PRIV_ID) or find_in_set(\'').$LOGIN_USER_ID).'\',USER_ID))');
  if (($TYPE != '0'))
  {
    ($query .= (((''.' and TYPE_ID=\'').$TYPE).'\''));
  }
  if (($FIELD == ''))
  {
    ($query .= ' order by NEWS_TIME desc');
  }
  else
  {
    ($query .= (' order by '.$FIELD));
    if (($ASC_DESC == '1'))
    {
      ($query .= ' desc');
    }
    else
    {
      ($query .= ' asc');
    }
  }
  ($query .= ((((''.' limit ').$start).',').$ITEMS_IN_PAGE));
  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">';
  }
  echo '
<table border="0" cellspacing="1" width="100%" 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';
  }
  echo '\');" style="cursor:hand;"><u>标题</u>';
  if (($FIELD == 'SUBJECT'))
  {
    echo $ORDER_IMG;
  }
  echo '</td>
      <td nowrap align="center">类型</td>
      <td nowrap align="center" onclick="order_by(\'NEWS_TIME\',\'';
  if ((($FIELD == 'NEWS_TIME') OR ($FIELD == '')))
  {
    echo (1 - $ASC_DESC);
  }
  else
  {
    echo '1';
  }
  echo '\');" style="cursor:hand;"><u>发布时间</u>';
  if ((($FIELD == 'NEWS_TIME') OR ($FIELD == '')))
  {
    echo $ORDER_IMG;
  }
  echo '</td>
      <td nowrap align="center" onclick="order_by(\'CLICK_COUNT\',\'';
  if (($FIELD == 'CLICK_COUNT'))
  {
    echo (1 - $ASC_DESC);
  }
  else
  {
    echo '1';
  }
  echo '\');" style="cursor:hand;"><u>点击次数</u>';
  if (($FIELD == 'CLICK_COUNT'))
  {
    echo $ORDER_IMG;
  }
  echo '</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;
    $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');
    $ANONYMITY_YN = $ROW['ANONYMITY_YN'];
    $READERS = $ROW['READERS'];
    $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';
    }
    echo '    <tr class="';
    echo $TableLine;
    echo '">
      <td>
      <a href="javascript:open_news(\'';
    echo $NEWS_ID;
    echo '\',\'';
    echo $FORMAT;
    echo '\');">';
    echo $SUBJECT;
    echo '</a>
';
    if (!find_id ($READERS, $LOGIN_USER_ID))
    {
      echo '      <img src="/images/email_new.gif" align="absMiddle">
';
    }
    echo '      </td>
      <td nowrap align="center">';
    echo $TYPE_NAME;
    echo '</td>
      <td nowrap align="center">';
    echo $NEWS_TIME;
    echo '</td>
      <td nowrap align="center">';
    echo $CLICK_COUNT;
    echo '</td>
      <td nowrap align="center">';
    echo $COMMENT_COUNT;
    echo '</td>
      <td nowrap align="center">
';
    if (($ANONYMITY_YN != '2'))
    {
      echo '      <a href="javascript:re_news(\'';
      echo $NEWS_ID;
      echo '\');">评论</a>
';
    }
    echo '      </td>
    </tr>
';
  }
  echo '
</table>
<br>
<table border="0" cellspacing="1" width="100%" class="small" bgcolor="#000000" cellpadding="3">
  <tr>
      <td class="TableContent" nowrap align="center" width="80"><b>快捷操作：</b></td>
      <td class="TableControl" nowrap>&nbsp;
   <a href="javascript:read_all();" title="标记所有新闻为已读"><img src="/images/email_open.gif" align="absMiddle" border="0"> 标记所有新闻为已读</a>&nbsp;';
  echo '&nbsp;
      </td>
</tr>
</table>
</body>
</html>
';
?>

news.php - 源码说明

本页面展示了「通达OA2007SE源代码 非常好的」中的 news.php 源码文件，采用 PHP 编程语言编写，共 313 行代码。您可以在线阅读完整代码内容，也可以返回资源详情页下载完整源码包进行本地学习和开发。

虫虫下载站收录了大量与2007相关的技术资源，包括源代码、技术文档、电路图等，是电子工程师和嵌入式开发者的专业学习平台。

⌨️ 快捷键说明

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