📄 notify.php
字号:
<?
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);
function read_all()
{
msg=\'确认要标记所有公告通知为已读吗？\';
if(window.confirm(msg))
{
url="read_all.php";
location=url;
}
}
</script>
';
echo '<s';
echo 'cript>
function open_notify(NOTIFY_ID)
{
URL="../show/read_notify.php?NOTIFY_ID="+NOTIFY_ID;
myleft=(screen.availWidth-650)/2;
window.open(URL,"read_notify","height=500,width=650,status=1,toolbar=no,menubar=no,location=no,scrollbars=yes,top=100,left="+myleft+",resizable=yes");
}
function order_by(field,asc_desc)
{
window.location="notify.php?start=';
echo $start;
echo '&TYPE=';
echo $TYPE;
echo '&FIELD="+field+"&ASC_DESC="+asc_desc;
}
function change_type(type)
{
window.location="notify.php?start=';
echo $start;
echo '&TYPE="+type+"&FIELD=';
echo $FIELD;
echo '&ASC_DESC=';
echo $ASC_DESC;
echo '";
}
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=\'0000-00-00\') 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))
{
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>
';
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 ('NOTIFY', $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>
';
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 ('NOTIFY', $TYPE);
echo ' <option value=""';
if (($TYPE == ''))
{
echo ' selected';
}
echo '>无类型</option>
</select>
</td>
<td align="right" valign="bottom" class="small1">';
echo page_bar ($start, $NOTIFY_COUNT, $ITEMS_IN_PAGE);
echo '</td>
</tr>
</table>
';
if (($ASC_DESC == ''))
{
$ASC_DESC = '1';
}
$query = (((((((((((''.'SELECT NOTIFY_ID,FROM_ID,TO_ID,SUBJECT,READERS,FORMAT,TOP,PRIV_ID,USER_ID,TYPE_ID,BEGIN_DATE 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=\'0000-00-00\') 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');
}
}
($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">
<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';
}
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(\'SEND_TIME\',\'';
if ((($FIELD == 'SEND_TIME') OR ($FIELD == '')))
{
echo (1 - $ASC_DESC);
}
else
{
echo '1';
}
echo '\');" style="cursor:hand;"><u>发布时间</u>';
if ((($FIELD == 'SEND_TIME') OR ($FIELD == '')))
{
echo $ORDER_IMG;
}
echo '</td>
</thead>
';
$NOTIFY_COUNT = 0;
$cursor = exequery ($connection, $query);
while ($ROW = mysql_fetch_array ($cursor))
{
++$NOTIFY_COUNT;
$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 USER_NAME,AVATAR,DEPT_ID 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 CODE_NAME 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 DEPT_NAME 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)).((20 < strlen ($TO_NAME)) ? '...' : '')).'<br>'));
}
$PRIV_NAME = '';
$TOK = strtok ($PRIV_ID, ',');
while (($TOK != ''))
{
$query1 = (((''.'SELECT PRIV_NAME 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 .= '
');
}
($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>'));
}
$USER_NAME = '';
$TOK = strtok ($USER_ID, ',');
while (($TOK != ''))
{
$query1 = (((''.'SELECT USER_NAME 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 .= '
');
}
($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>'));
}
if (($TOP == '1'))
{
$SUBJECT = (('<font color=red><b>'.$SUBJECT).'</b></font>');
}
if ((($NOTIFY_COUNT % 2) == 1))
{
$TableLine = 'TableLine1';
}
else
{
$TableLine = 'TableLine2';
}
echo ' <tr class="';
echo $TableLine;
echo '">
<td nowrap width="120"><img src="/images/avatar/';
echo $AVATAR;
echo '.gif" ';
echo avatar_size ($AVATAR);
echo '> <u title="部门：';
echo $DEPT_NAME;
echo '" style="cursor:hand">';
echo $FROM_NAME;
echo '</u></td>
<td align="center">';
echo $TYPE_NAME;
echo '</td>
<td>
<a href="javascript:open_notify(\'';
echo $NOTIFY_ID;
echo '\');">';
echo $SUBJECT;
echo '</a>
';
if (find_id ($LOGIN_FUNC_STR, '24'))
{
echo ' <input type="button" class="SmallButton" value="转发" onclick="fw_notify(\'';
echo $NOTIFY_ID;
echo '\');">
';
}
if (!find_id ($READERS, $LOGIN_USER_ID))
{
echo '<img src=\'/images/new.gif\' height=11 width=28>';
}
echo ' </td>
<td style="cursor:hand" title="';
echo $TO_NAME_TITLE;
echo '">';
echo $TO_NAME_STR;
echo '</td>
<td nowrap align="center">';
echo $BEGIN_DATE;
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>
<a href="javascript:read_all();" title="标记所有公告通知为已读"><img src="/images/email_open.gif" align="absMiddle" border="0"> 标记所有公告为已读</a>&nbs';
echo 'p;
</td>
</tr>
</table>
</body>
</html>
';
?>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -