index1.php

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

PHP
557 行
字号 
<?
  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>
function open_news(NEWS_ID,FORMAT)
{
 URL="../show/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-10;
    myheight=screen.availHeight-40;
 }
 window.open(URL,"read_news","height="+myheight+",width="+mywidth+",status=1,toolbar=no,menubar=no,l';
  echo 'ocation=no,scrollbars=yes,top="+mytop+",left="+myleft+",resizable=yes");
}
function delete_news(NEWS_ID,start)
{
 msg=\'确认要删除该项新闻么？\';
 if(window.confirm(msg))
 {
  URL="delete.php?NEWS_ID=" + NEWS_ID + "&start=" + start;
  window.location=URL;
 }
}
function delete_all()
{
 msg=\'确认要删除所有新闻么？\';
 if(window.confirm(msg))
 {
  URL="delete_all.php";
  window.lo';
  echo 'cation=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");
}
function order_by(field,asc_desc)
{
 window.location="index1.php?start=';
  echo $start;
  echo '&TYPE=';
  echo $TYPE;
  echo '&FIELD="+field+"&ASC_DESC="+asc_desc;
}
function change_type(type)
{
 window.location="index1.php?start=';
  echo $start;
  echo '&TYPE="+type+"&FIELD=';
  echo $FIELD;
  echo '&ASC_DESC=';
  echo $ASC_DESC;
  echo '";
}
function show_reader(NEWS_ID)
{
  count=0;
  for(i=0;i<document.all("email_select").length;i++)
  {
      el=document.all("email_select").item(i);
      if(el.checked)
      {  email_id=el.value;
         count++;
      }
  }
  if(i==0)
  {
      el=document.all("email_select");
      if(el.checked)
      {  email_id=el.value;
         count++;
      }
  }
  if(cou';
  echo 'nt>1)
  {
     alert("只能选择一条。");
     return;
  }
  if(count==0)
  {
     alert("请至少选择其中一条");
     return;
  }
  URL="show_reader.php?NEWS_ID="+email_id;
  myleft=(screen.availWidth-500)/2;
  window.open(URL,"read_news","height=500,width=700,status=0,toolbar=no,menubar=no,location=no,scrollbars=yes,top=150,left="+myleft+",resizable=yes");
}
function check_all()
';
  echo '
{
 for (i=0;i<document.all("email_select").length;i++)
 {
   if(document.all("allbox").checked)
      document.all("email_select").item(i).checked=true;
   else
      document.all("email_select").item(i).checked=false;
 }
 if(i==0)
 {
   if(document.all("allbox").checked)
      document.all("email_select").checked=true;
   else
      document.all("email_select").checked=false;
 }
';
  echo '}
function check_one(el)
{
   if(!el.checked)
      document.all("allbox").checked=false;
}
function delete_mail()
{
  delete_str="";
  for(i=0;i<document.all("email_select").length;i++)
  {
      el=document.all("email_select").item(i);
      if(el.checked)
      {  val=el.value;
         delete_str+=val + ",";
      }
  }
  if(i==0)
  {
      el=document.all("email_select';
  echo '");
      if(el.checked)
      {  val=el.value;
         delete_str+=val + ",";
      }
  }
  if(delete_str=="")
  {
     alert("要删除新闻，请至少选择其中一条。");
     return;
  }
  msg=\'确认要删除所选新闻么？\';
  if(window.confirm(msg))
  {
    url="delete.php?DELETE_STR="+ delete_str +"&start=';
  echo $start;
  echo '";
    location=url;
  }
}
</script>
</head>
<body class="bodycolor" topmargin="5">
';
  if (($LOGIN_USER_PRIV == '1'))
  {
    $query = 'SELECT count(*) from NEWS where 1=1';
  }
  else
  {
    $query = (((''.'SELECT count(*) from NEWS where PROVIDER=\'').$LOGIN_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>&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>
  </tr>
</table>
<br>
';
    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';
  }
  if (($FIELD == ''))
  {
    $FIELD = 'NEWS_TIME';
  }
  if (($LOGIN_USER_PRIV == '1'))
  {
    $query = 'SELECT * from NEWS where 1=1';
  }
  else
  {
    $query = (((''.'SELECT * from NEWS where PROVIDER=\'').$LOGIN_USER_ID).'\'');
  }
  if (($TYPE != '0'))
  {
    ($query .= (((''.' and TYPE_ID=\'').$TYPE).'\''));
  }
  ($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">选择</td>
      <td nowrap align="center">发布人</td>
      <td nowrap align="center">类型</td>
      <td nowrap align="center">发布范围</td>
      <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" 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" onclick="order_by(\'PUBLISH\',\'';
  if (($FIELD == 'PUBLISH'))
  {
    echo (1 - $ASC_DESC);
  }
  else
  {
    echo '1';
  }
  echo '\');" style="cursor:hand;"><u>状态</u>';
  if (($FIELD == 'PUBLISH'))
  {
    echo $ORDER_IMG;
  }
  echo '</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'];
    $PROVIDER = $ROW['PROVIDER'];
    $NEWS_TIME = $ROW['NEWS_TIME'];
    $CLICK_COUNT = $ROW['CLICK_COUNT'];
    $FORMAT = $ROW['FORMAT'];
    $TYPE_ID = $ROW['TYPE_ID'];
    $PUBLISH = $ROW['PUBLISH'];
    $ANONYMITY_YN = $ROW['ANONYMITY_YN'];
    $TO_ID = $ROW['TO_ID'];
    $PRIV_ID = $ROW['PRIV_ID'];
    $USER_ID = $ROW['USER_ID'];
    $SUBJECT = htmlspecialchars ($SUBJECT);
    $query1 = (((''.'select USER_NAME,DEPT_ID 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'];
    }
    $TO_NAME = '';
    if (($TO_ID == 'ALL_DEPT'))
    {
      $TO_NAME = '全体部门';
    }
    else
    {
      $query1 = (((''.'select DEPT_NAME from DEPARTMENT where find_in_set(DEPT_ID,\'').$TO_ID).'\')');
      $cursor1 = exequery ($connection, $query1);
      while ($ROW = mysql_fetch_array ($cursor1))
      {
        ($TO_NAME .= ($ROW['DEPT_NAME'].'，'));
      }
    }
    $PRIV_NAME = '';
    $query1 = (((''.'SELECT PRIV_NAME from USER_PRIV where find_in_set(USER_PRIV,\'').$PRIV_ID).'\')');
    $cursor1 = exequery ($connection, $query1);
    while ($ROW = mysql_fetch_array ($cursor1))
    {
      ($PRIV_NAME .= ($ROW['PRIV_NAME'].'，'));
    }
    $USER_NAME = '';
    $query1 = (((''.'SELECT USER_NAME from USER where find_in_set(USER_ID,\'').$USER_ID).'\')');
    $cursor1 = exequery ($connection, $query1);
    while ($ROW = mysql_fetch_array ($cursor1))
    {
      ($USER_NAME .= ($ROW['USER_NAME'].'，'));
    }
    $TO_NAME_TITLE = '';
    $TO_NAME_STR = '';
    if (($TO_NAME != ''))
    {
      if ((substr ($TO_NAME, -2) == '，'))
      {
        $TO_NAME = substr ($TO_NAME, 0, -2);
      }
      ($TO_NAME_TITLE .= ('部门：'.$TO_NAME));
      ($TO_NAME_STR .= ((('<font color=#0000FF><b>部门：</b></font>'.csubstr (strip_tags ($TO_NAME), 0, 20)).((20 < strlen ($TO_NAME)) ? '...' : '')).'<br>'));
    }
    if (($PRIV_NAME != ''))
    {
      if ((substr ($PRIV_NAME, -2) == '，'))
      {
        $PRIV_NAME = substr ($PRIV_NAME, 0, -2);
      }
      if (($TO_NAME_TITLE != ''))
      {
        ($TO_NAME_TITLE .= '
');
      }
      ($TO_NAME_TITLE .= ('角色：'.$PRIV_NAME));
      ($TO_NAME_STR .= ((('<font color=#0000FF><b>角色：</b></font>'.csubstr (strip_tags ($PRIV_NAME), 0, 20)).((20 < strlen ($PRIV_NAME)) ? '...' : '')).'<br>'));
    }
    if (($USER_NAME != ''))
    {
      if ((substr ($USER_NAME, -2) == '，'))
      {
        $USER_NAME = substr ($USER_NAME, 0, -2);
      }
      if (($TO_NAME_TITLE != ''))
      {
        ($TO_NAME_TITLE .= '
');
      }
      ($TO_NAME_TITLE .= ('人员：'.$USER_NAME));
      ($TO_NAME_STR .= ((('<font color=#0000FF><b>人员：</b></font>'.csubstr (strip_tags ($USER_NAME), 0, 20)).((20 < strlen ($USER_NAME)) ? '...' : '')).'<br>'));
    }
    $TYPE_NAME = get_code_name ($TYPE_ID, 'NEWS');
    $DEPT_NAME = dept_long_name ($DEPT_ID);
    if (($PUBLISH == '0'))
    {
      $PUBLISH_DESC = '<font color=red>未发布</font>';
    }
    else
    {
      $PUBLISH_DESC = '';
    }
    $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>&nbsp;<input type="checkbox" name="email_select" value="';
    echo $NEWS_ID;
    echo '" onClick="check_one(self);">
      <td nowrap align="center"><u title="部门：';
    echo $DEPT_NAME;
    echo '" style="cursor:hand">';
    echo $PROVIDER_NAME;
    echo '</u></td>
      <td nowrap align="center">';
    echo $TYPE_NAME;
    echo '</td>
      <td style="cursor:hand" title="';
    echo $TO_NAME_TITLE;
    echo '">';
    echo $TO_NAME_STR;
    echo '</td>
      <td><a href="javascript:open_news(\'';
    echo $NEWS_ID;
    echo '\',\'';
    echo $FORMAT;
    echo '\');">';
    echo $SUBJECT;
    echo '</a></td>
      <td 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">';
    echo $PUBLISH_DESC;
    echo '</td>
      <td align="center">
      <a href="modify.php?NEWS_ID=';
    echo $NEWS_ID;
    echo '&start=';
    echo $start;
    echo '"> 修改</a>
';
    if (($ANONYMITY_YN != '2'))
    {
      echo '      <a href="javascript:re_news(\'';
      echo $NEWS_ID;
      echo '\');"> 管理评论</a>
';
    }
    echo '      </td>
    </tr>
';
  }
  echo '
<tr class="TableControl">
<td colspan="19">
    <input type="checkbox" name="allbox" id="allbox_for" onClick="check_all();"><label for="allbox_for">全选</label> &nbsp;
    <input type="button"  value="删除" class="SmallButton" onClick="delete_mail();" title="删除所选新闻"> &nbsp;
    <input type="button"  value="查阅情况" class="SmallButton" onClick="show_reader();" title="查阅情况"> &nbsp;
    <in';
  echo 'put type="button"  value="全部删除" class="SmallButton" onClick="delete_all()" title="删除所有已发布的新闻">
</td>
</tr>
</table>
</body>
</html>
';
?>

index1.php - 源码说明

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

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

⌨️ 快捷键说明

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