?? index.php
字號:
<?
include_once '../auth.php';
include_once 'inc/utility_all.php';
echo '
<html>
<head>
<title>公告通知</title>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
</head>
<body>
<font color=blue size=+2><b>新公告通知</b></font>
<br><br>
';
$CUR_DATE = date ('Y-m-d', time ());
$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\' order by TOP desc,BEGIN_DATE desc,SEND_TIME desc');
$cursor = exequery ($connection, $query);
$NOTIFY_COUNT = 0;
while ($ROW = mysql_fetch_array ($cursor))
{
++$NOTIFY_COUNT;
if ((20 < $NOTIFY_COUNT))
{
break;
}
$NOTIFY_ID = $ROW['NOTIFY_ID'];
$FROM_ID = $ROW['FROM_ID'];
$SUBJECT = $ROW['SUBJECT'];
$TOP = $ROW['TOP'];
$TYPE_ID = $ROW['TYPE_ID'];
$SUBJECT = str_replace ('<', '<', $SUBJECT);
$SUBJECT = str_replace ('>', '>', $SUBJECT);
$SUBJECT = stripslashes ($SUBJECT);
$BEGIN_DATE = $ROW['BEGIN_DATE'];
$BEGIN_DATE = strtok ($BEGIN_DATE, ' ');
$TYPE_NAME = get_code_name ($TYPE_ID, 'NOTIFY');
if (($TYPE_NAME != ''))
{
$SUBJECT = ((('【'.$TYPE_NAME).'】').$SUBJECT);
}
$query1 = (((''.'SELECT * from USER where USER_ID=\'').$FROM_ID).'\'');
$cursor1 = exequery ($connection, $query1);
if ($ROW = mysql_fetch_array ($cursor1))
{
$FROM_NAME = $ROW['USER_NAME'];
}
else
{
$FROM_NAME = $FROM_ID;
}
echo '
';
echo $NOTIFY_COUNT;
echo '.';
echo $FROM_NAME;
echo '：';
echo $SUBJECT;
echo '<br>
<i>';
echo $BEGIN_DATE;
echo '</i>
';
if (($TOP == '1'))
{
echo '<font color=red><b>重要：</b></font>';
}
echo '<a href="read.php?P=';
echo $P;
echo '&NOTIFY_ID=';
echo $NOTIFY_ID;
echo '">閱讀</a>
<hr>
';
}
if (($NOTIFY_COUNT == 0))
{
echo '無新公告通知';
}
echo '
<a href="../main.php?P=';
echo $P;
echo '">返回</a>
</body>
</html>
';
?>
?? 快捷鍵說明
復制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號
Ctrl + =
減小字號
Ctrl + -