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

📄 notify.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_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 order_by(field,asc_desc)
{
 window.location="notify.php?CUR_PAGE=<?=$CUR_PAGE?>&TYPE=<?=$TYPE?>&FIELD="+field+"&ASC_DESC="+asc_desc;
}

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

function fw_notify(NOTIFY_ID)
{
 if(window.confirm("确认要转发该公告通知吗？"))
    parent.location="../manage/fw.php?NOTIFY_ID="+NOTIFY_ID;
}
</script>

</head>
<body class="bodycolor" topmargin="0">
<?
 $CUR_TIME=date("Y-m-d H:i:s",time());

 //============================ 显示已发布公告 =======================================
 $CUR_DATE=date("Y-m-d",time());
 $NOTIFY_COUNT=0;
 $query = "SELECT count(*) from NOTIFY where (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)) and begin_date<='$CUR_DATE' and (end_date>='$CUR_DATE' or end_date is null) and PUBLISH='1'";
 
 if($TYPE!="0")
   $query .= " and TYPE_ID='$TYPE'";
   
 $cursor= exequery($connection,$query);
 if($ROW=mysql_fetch_array($cursor))
    $NOTIFY_COUNT=$ROW[0];

 if($NOTIFY_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>&nbsp;
       <select name="TYPE" class="BigSelect" onchange="change_type(this.value);">
          <option value="0"<?if($TYPE=="0") echo " selected";?>>所有类型</option>
          <?=code_list("NOTIFY",$TYPE)?>
          <option value=""<?if($TYPE=="") echo " selected";?>>无类型</option>
       </select>
    </td>
  </tr>
</table>
<br>

<?
   Message("","无公告通知");
   exit;
 }

 $PER_PAGE=15;
 $PAGES=10;
 $PAGE_COUNT=ceil($NOTIFY_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("NOTIFY",$TYPE)?>
          <option value=""<?if($TYPE=="") echo " selected";?>>无类型</option>
       </select>
    </td>
    <td align="right" valign="bottom" class="small1">共<span class="big4">&nbsp;<?=$NOTIFY_COUNT?></span>&nbsp;条
    </td>
    <td align="right" valign="bottom" class="small1">
       <a class="A1" href="notify.php?CUR_PAGE=1&TYPE=<?=$TYPE?>&FIELD=<?=$FIELD?>&ASC_DESC=<?=$ASC_DESC?>">首页</a>&nbsp;
       <a class="A1" href="notify.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="notify.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="notify.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="notify.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="notify.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="notify.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";
$query = "SELECT * from NOTIFY where (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)) and begin_date<='$CUR_DATE' and (end_date>='$CUR_DATE' or end_date is null) and PUBLISH='1'";

if($TYPE!="0")
   $query .= " and TYPE_ID='$TYPE'";

if($FIELD=="")
   $query .= " order by TOP desc,BEGIN_DATE desc,SEND_TIME desc";
else
{
   $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\">";
?>
<table border="0" cellspacing="1" width="98%" class="small" bgcolor="#000000" cellpadding="3">
   <thead class="TableHeader">
      <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";?>');" style="cursor:hand;"><u>标题</u><?if($FIELD=="SUBJECT") echo $ORDER_IMG;?></td>
      <td nowrap align="center">发布范围</td>
      <td nowrap align="center" onclick="order_by('SEND_TIME','<?if($FIELD=="SEND_TIME"||$FIELD=="") echo 1-$ASC_DESC;else echo "1";?>');" style="cursor:hand;"><u>发布时间</u><?if($FIELD=="SEND_TIME"||$FIELD=="") echo $ORDER_IMG;?></td>
   </thead>
<?
 $NOTIFY_COUNT=0;
 $cursor= exequery($connection,$query);
 while($ROW=mysql_fetch_array($cursor))
 {
    $NOTIFY_COUNT++;
    if($NOTIFY_COUNT<$CUR_PAGE*$PER_PAGE-$PER_PAGE+1)
       continue;
    if($NOTIFY_COUNT>$CUR_PAGE*$PER_PAGE)
       break;

    $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=htmlspecialchars($SUBJECT);

    $BEGIN_DATE=$ROW["BEGIN_DATE"];

    $BEGIN_DATE=strtok($BEGIN_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"];
       $AVATAR=$ROW["AVATAR"];
       $DEPT_ID=$ROW["DEPT_ID"];
       $DEPT_NAME=dept_long_name($DEPT_ID);
    }
    else
    {
       $FROM_NAME=$FROM_ID;
       $AVATAR="";
       $DEPT_NAME="用户已删除";
    }
    
    $TYPE_NAME="";
    $query1="select * from SYS_CODE where PARENT_NO='NOTIFY' and CODE_NO='$TYPE_ID'";
    $cursor1= exequery($connection,$query1);
    if($ROW=mysql_fetch_array($cursor1))
       $TYPE_NAME=$ROW["CODE_NAME"];
    
    $TO_NAME="";
    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($TOP=="1")
       $SUBJECT="<font color=red><b>".$SUBJECT."</b></font>";

    if($NOTIFY_COUNT%2==1)
       $TableLine="TableLine1";
    else
       $TableLine="TableLine2";
?>
    <tr class="<?=$TableLine?>">
      <td nowrap width="120"><img src="/images/avatar/<?=$AVATAR?>.gif" <?=avatar_size($AVATAR)?>> <u title="部门：<?=$DEPT_NAME?>" style="cursor:hand"><?=$FROM_NAME?></u></td>
      <td align="center"><?=$TYPE_NAME?></td>
      <td>
      <a href="javascript:open_notify('<?=$NOTIFY_ID?>');"><?=$SUBJECT?></a>
<?
      if(find_id($LOGIN_FUNC_STR,"24"))
      {
?>
      <input type="button" class="SmallButton" value="转发" onclick="fw_notify('<?=$NOTIFY_ID?>');">
<?
      }
      if(!find_id($READERS,$LOGIN_USER_ID))
         echo "<img src='/images/new.gif' height=11 width=28>";
?>
      </td>
      <td style="cursor:hand" title="<?=$TO_NAME_TITLE?>"><?=$TO_NAME_STR?></td>
      <td nowrap align="center"><?=$BEGIN_DATE?></td>
    </tr>
<?
 }
?>
</table>
</body>
</html>

⌨️ 快捷键说明

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